<?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_id']) or !isset($_POST['txt_name']) or !isset($_POST['txt_family']) or !isset($_POST['txt_male']) or !isset($_POST['txt_female']) or !isset($_POST['txt_total']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{

        $data_insert_id_village = trim($con_db_administrator->real_escape_string($_POST['txt_id']));
        $data_insert_name_village = trim($con_db_administrator->real_escape_string($_POST['txt_name']));
        $data_insert_family_village = trim($con_db_administrator->real_escape_string($_POST['txt_family']));
        $data_insert_total_male_village = trim($con_db_administrator->real_escape_string($_POST['txt_male']));
        $data_insert_total_female_village = trim($con_db_administrator->real_escape_string($_POST['txt_female']));
        $data_insert_total_all_village = trim($con_db_administrator->real_escape_string($_POST['txt_total']));

            $sql_check_village = " SELECT COUNT(*) FROM `data_village` WHERE `id_village`='$data_insert_id_village' ";
            $qr_check_village = mysqli_query($con_db_administrator, $sql_check_village) or trigger_error("sql_check_village", E_USER_ERROR);
            $r_check_village = mysqli_fetch_row($qr_check_village);
            $rs_check_village = $r_check_village[0];    

            if($rs_check_village >= 1){
                echo "<SCRIPT type='text/javascript'>
                        alert('หมู่ที่ $data_insert_id_village มีในระบบแล้ว หากต้องการเพิ่มใหม่ กรุณาข้อมูลหมู่ที่ $data_insert_id_village ออกก่อน');
                        window.location.replace('../VillageMain');
                    </SCRIPT>";
                exit;
            }else{
                
                /////// insert DATA to SQL

                $insert_village = " INSERT INTO `data_village`(`id_village`, `name_village`, `family_village`, `total_male_village`, `total_female_village`, `total_all_village`, `lastupdate_village`)
                                    VALUES ( '$data_insert_id_village', '$data_insert_name_village', '$data_insert_family_village', '$data_insert_total_male_village ', '$data_insert_total_female_village ', '$data_insert_total_all_village ', '$datetime' )";
                $action_village = $con_db_administrator->query($insert_village);
                if(!$action_village){
                    echo "<SCRIPT type='text/javascript'>
                            alert('เพิ่มข้อมูล ไม่สำเร็จ กรุณาลองอีกครั้ง');
                            window.location.replace('../VillageMain');
                        </SCRIPT>";
                    exit;
                }else{
                    
                    $ud_data_dt = " UPDATE `data_dataother` SET `lastupdate_dataother`='$datetime' WHERE `id_dataother` = 4 ";  
                    $action_ud_data_dt = $con_db_administrator->query($ud_data_dt);

                    echo "<SCRIPT type='text/javascript'>
                            alert('เพิ่มข้อมูลหมู่บ้าน สำเร็จ');
                            window.location.replace('../VillageMain');
                        </SCRIPT>";
                    exit;

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