<?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['txt_name']) or !isset($_POST['txt_id']) or !isset($_POST['txt_group']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{
        $data_name = trim($con_db_administrator->real_escape_string($_POST['txt_name']));
        $data_id = trim($con_db_administrator->real_escape_string($_POST['txt_id']));
    
        $data_group = $con_db_administrator->real_escape_string($_POST['txt_group']);
        $data_group_explode = explode('|',$data_group);
        $data_idgroup = $data_group_explode[0];
        $data_namegroup = $data_group_explode[1];
    
        /////// เช็คข้อมูล id ซ้ำ
        $sql_check_id = " SELECT COUNT(*) FROM `data_position` WHERE `id_position`='$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]; 

        /////// เช็คข้อมูล name ซ้ำ
        $sql_check_name = " SELECT COUNT(*) FROM `data_position` WHERE `name_position`='$data_name' AND `name_group_position`='$data_namegroup' ";
        $qr_check_name = mysqli_query($con_db_administrator, $sql_check_name) or trigger_error("sql_check_name", E_USER_ERROR);
        $rs_check_name = mysqli_fetch_row($qr_check_name);
        $check_name = $rs_check_name[0]; 

        if($check_id >= 1){
            echo "<SCRIPT type='text/javascript'>
                    alert('ลำดับตำแหน่ง [ $data_id ] ซ้ำ');
                    window.location.replace('../ChartPositionMain');
                </SCRIPT>";
            exit;
        }else if($check_name >= 1){
            echo "<SCRIPT type='text/javascript'>
                    alert('ชื่อตำแหน่ง [ $data_name ] ในสังกัดหน่วยงาน$data_namegroup ซ้ำ');
                    window.location.replace('../ChartPositionMain');
                </SCRIPT>";
            exit;
        }else{

            $insert_data = " INSERT INTO `data_position`(`id_position`, `name_position`, `id_group_position`, `name_group_position`)
                             VALUES ( '$data_id', '$data_name', '$data_idgroup', '$data_namegroup' )";     
            $action_data = $con_db_administrator->query($insert_data);
            if(!$action_data){
                echo "<SCRIPT type='text/javascript'>
                        alert('เพิ่มข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง');
                        window.location.replace('../ChartPositionMain');
                    </SCRIPT>";
                exit;
            }else{
                echo "<SCRIPT type='text/javascript'>
                        alert('เพิ่มข้อมูลใหม่ สำเร็จ');
                        window.location.replace('../ChartPositionMain');
                    </SCRIPT>";
                exit;
            }

        }

    } 
           

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