<?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_question']) or !isset($_POST['edt_answer']) ){
        echo "<SCRIPT type='text/javascript'>
                alert('กรุณากรอกข้อมูลให้ครบ');
                window.location.replace(document.referrer);
            </SCRIPT>";
        exit;
    }else{
        $data_oldidfaq = $con_db_administrator->real_escape_string($_POST['edt_oldid']);
        $data_idfaq = $con_db_administrator->real_escape_string($_POST['edt_id']);
        $data_questionfaq = trim($con_db_administrator->real_escape_string($_POST['edt_question']));
        $data_answerfaq = trim($con_db_administrator->real_escape_string($_POST['edt_answer']));
        $data_sttfaq = $con_db_administrator->real_escape_string($_POST['statusshow']);
        $lastupdate_faq = $datetime;

        if( $data_idfaq == $data_oldidfaq ){
                /////// UPDATE DATA to SQL
                $ud_data = " UPDATE `data_faq` SET `question_faq`='$data_questionfaq', `answer_faq`='$data_answerfaq', `stt_faq`='$data_sttfaq' , `lastupdate_faq`='$lastupdate_faq' 
                            WHERE `id_faq`='$data_idfaq' ";  
                $action_ud_data = $con_db_administrator->query($ud_data);
                if(!$action_ud_data){
                    echo "<SCRIPT type='text/javascript'>
                            alert('เกิดข้อผิดพลาด! แก้ไขข้อมูลไม่สำเร็จ');
                            window.location.replace(document.referrer);
                        </SCRIPT>";
                    exit;
                }else{

                    echo "<SCRIPT type='text/javascript'>
                            alert('แก้ไขข้อมูล สำเร็จ');
                            window.location.replace('../FaqMain');
                        </SCRIPT>";
                    exit;
                }
        }else{
            /////// เช็คข้อมูล id ซ้ำ
            $sql_check_id = " SELECT COUNT(*) FROM `data_faq` WHERE `id_faq`='$data_idfaq' ";
            $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('ลำดับแสดงผล [ $data_idfaq ] ซ้ำ');
                        window.location.replace(document.referrer);
                    </SCRIPT>";
                exit;
            }else{
                /////// UPDATE DATA to SQL
                $ud_data = " UPDATE `data_faq` SET `id_faq`='$data_idfaq', `question_faq`='$data_questionfaq', `answer_faq`='$data_answerfaq', `stt_faq`='$data_sttfaq' , `lastupdate_faq`='$lastupdate_faq' 
                            WHERE `id_faq`='$data_oldidfaq' ";  
                $action_ud_data = $con_db_administrator->query($ud_data);
                if(!$action_ud_data){
                    echo "<SCRIPT type='text/javascript'>
                            alert('เกิดข้อผิดพลาด! แก้ไขข้อมูลไม่สำเร็จ');
                            window.location.replace(document.referrer);
                        </SCRIPT>";
                    exit;
                }else{

                    echo "<SCRIPT type='text/javascript'>
                            alert('แก้ไขข้อมูล สำเร็จ');
                            window.location.replace('../FaqMain');
                        </SCRIPT>";
                    exit;
                }
            }

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