<?php
require_once('session_backend_administrator.php');
header('Content-Type: text/html; charset=UTF-8');
date_default_timezone_set("Asia/Bangkok"); 
$datetime = date('d/m/Y H.i'); 

if($STT_login=="admin_login_true"){


    if( !isset($_POST['edt_oldid']) or !isset($_POST['edt_id']) or !isset($_POST['edt_name']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{
            $data_oldid = trim($con_db_administrator->real_escape_string($_POST['edt_oldid']));
            $data_id = trim($con_db_administrator->real_escape_string($_POST['edt_id']));
            $data_name = trim($con_db_administrator->real_escape_string($_POST['edt_name']));
            $data_data = $con_db_administrator->real_escape_string($_POST['edt_data']);

            $data_statusshow = $con_db_administrator->real_escape_string($_POST['statusshow']);

            if( $data_id == $data_oldid ){
                        /////// update DATA to SQL

                        $ud_data = " UPDATE `data_agency` SET `name_agency`='$data_name', `data_agency`='$data_data', `stt_agency`='$data_statusshow', `lastupdate_agency`='$datetime'
                                    WHERE `id_agency`='$data_oldid' ";  
                        $action_ud_data = $con_db_administrator->query($ud_data);
                        if(!$action_ud_data){
                            echo "<SCRIPT type='text/javascript'>
                                    alert('เกิดข้อผิดพลาด! แก้ไขข้อมูลไม่สำเร็จ');
                                    window.location.replace('../Agency');
                                </SCRIPT>";
                            exit;
                        }else{
                            echo "<SCRIPT type='text/javascript'>
                                    alert('แก้ไขข้อมูล [ $data_name ] สำเร็จ');
                                    window.location.replace('../Agency');
                                </SCRIPT>";
                            exit;
                
                        }
            }else{
                /////// เช็คข้อมูล id ซ้ำ
                $sql_check_id = " SELECT COUNT(*) FROM `data_agency` WHERE `id_agency`='$data_id' ";
                $qr_check_id = mysqli_query($con_db_administrator, $sql_check_id) or trigger_error("sql_check_id", E_USER_ERROR);
                $rs_check_id = mysqli_fetch_row($qr_check_id);
                $check_id = $rs_check_id[0]; 
                if($check_id >= 1){
                    echo "<SCRIPT type='text/javascript'>
                            alert('ลำดับหน่วยงานซ้ำ');
                            window.location.replace(document.referrer);
                        </SCRIPT>";
                    exit;
                }else{
                    $ud_data = " UPDATE `data_agency` SET `id_agency`='$data_id', `name_agency`='$data_name', `data_agency`='$data_data', `stt_agency`='$data_statusshow', `lastupdate_agency`='$datetime'
                                WHERE `id_agency`='$data_oldid' ";  
                    $action_ud_data = $con_db_administrator->query($ud_data);
                    if(!$action_ud_data){
                        echo "<SCRIPT type='text/javascript'>
                                alert('เกิดข้อผิดพลาด! แก้ไขข้อมูลไม่สำเร็จ');
                                window.location.replace('../Agency');
                            </SCRIPT>";
                        exit;
                    }else{
                        echo "<SCRIPT type='text/javascript'>
                                alert('แก้ไขข้อมูล [ $data_name ] สำเร็จ');
                                window.location.replace('../Agency');
                            </SCRIPT>";
                        exit;

                    }
                }


            }
    
    }

}else{
    echo "<SCRIPT type='text/javascript'>
        alert('กรุณาเข้าสู่ระบบ');
        window.location.replace('../../index');
    </SCRIPT>";
    exit;
}
mysqli_close($con_db_administrator);
?>