<?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_type']) or !isset($_POST['txt_subtype']) or !isset($_POST['txt_data']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{
        
        $data_namesubdatafile = trim($con_db_administrator->real_escape_string($_POST['txt_name']));
        $data_typesubdatafile = $con_db_administrator->real_escape_string($_POST['txt_type']);
        $data_subtypesubdatafile = $con_db_administrator->real_escape_string($_POST['txt_subtype']);
        $data_sttsubdatafile = $con_db_administrator->real_escape_string($_POST['statusshow']);
        $data_linksubdatafile = $con_db_administrator->real_escape_string($_POST['linksubdatafile']);
        $data_subdatafile = $con_db_administrator->real_escape_string($_POST['txt_data']);

        $date = $_POST['txt_date'];
        $lastupdate_subdatafile = date("d/m/Y",strtotime($date));
    
            /////// insert DATA to SQL

            $insert_subdatafile = " INSERT INTO `data_subdatafile` (`name_subdatafile`, `type_subdatafile`, `subtype_subdatafile`, `data_subdatafile`, `stt_subdatafile`, `lastupdate_subdatafile`) 
                                    VALUES ('$data_namesubdatafile', '$data_typesubdatafile', '$data_subtypesubdatafile', '$data_subdatafile', '$data_sttsubdatafile', '$lastupdate_subdatafile') ";      
            $action_subdatafile = $con_db_administrator->query($insert_subdatafile);
            if(!$action_subdatafile){
                echo "<SCRIPT type='text/javascript'>
                        alert('เพิ่มข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง');
                        window.location.replace('../$data_linksubdatafile');
                    </SCRIPT>";
                exit;
            }else{
                $sql_data = " SELECT `id_subdatafile` FROM `data_subdatafile` WHERE `name_subdatafile`='$data_namesubdatafile' AND `lastupdate_subdatafile`='$lastupdate_subdatafile' ORDER BY `id_subdatafile` DESC LIMIT 1 "; 
                $qr_data = mysqli_query($con_db_administrator, $sql_data); 
                $rs_data = mysqli_fetch_assoc($qr_data); 

                $id_data = $rs_data['id_subdatafile'];

                echo "<SCRIPT type='text/javascript'>
                        alert('เพิ่มข้อมูลใหม่ สำเร็จ');
                        window.location.replace('../subdatafile-edit?id=$id_data&type=$data_typesubdatafile&link=$data_linksubdatafile');
                    </SCRIPT>";
                exit;
            }
            
    }

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