<?php session_start();
//include('../../includes/connect.php');
include('../../includes/function_db.php');
//echo '0';
$dt = date('Y-m-d H:i:s');
$tbname = "ministerialLaws";

function checkFileType($file, $allowType)
{
    $fileName = basename($_FILES[$file]['name']);
    $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
    switch ($allowType) {
        case 'photo':
            $allow = array('jpg', 'jpeg', 'png', 'gif');
            break;
        case 'docutment':
            $allow = array('doc', 'docx', 'pdf');
            break;
        case 'word':
            $allow = array('doc', 'docx');
            break;
        case 'powerpoint':
            $allow = array('ptt', 'pttx');
            break;
        case 'excel':
            $allow = array('xls', 'xlsx');
            break;
        case 'pdf':
            $allow = array('pdf');
            break;;
    }
    if (in_array($allowType, $fileType)) {
        return 'true';
    } else {
        return 'false';
    }
}

function uploadFiles($file, $path, $fn)
{
    $fileName = basename($_FILES[$file]['name']);
    $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
    $folder = "../../uploads/$path/" . $fn . "." . $fileType;
    $re = move_uploaded_file($_FILES[$file]["tmp_name"], $folder);
}

$cdb = new control_db();
switch ($_POST['form_action']) {
        //เพิ่มข้อมูล
//เพิ่มข้อมูล
  //เพิ่มข้อมูล
    case '1':
        unset($_POST['form_action'], $_POST['id']);
        $fileName = basename($_FILES['file_jpg']['name']);
        $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
        $_POST['coverImg'] = $fileType;
        $_POST['createDate'] = $dt;
        
        // ---> ชุดดัก Error 1364 (ฐานข้อมูลบังคับกรอก แต่ในฟอร์มไม่มี) <---
        $_POST['articleTypeID'] = 0; 
        $_POST['subTitle'] = ''; 
        $_POST['detail'] = ''; 
        
        // ตัวล่าสุดที่ฟ้องครับ กำหนดลำดับเริ่มต้นเป็น 0 หรือ 1
        $_POST['rec_order'] = 1; 
        
        // เผื่อมันถามหาสถานะการแสดงผล (ส่วนใหญ่ 1 = เปิดใช้งาน)
        $_POST['status'] = 1; 

        // ถ้าต่อไปมันฟ้องตัวไหนอีก ให้คัดลอกรูปแบบ $_POST['ชื่อฟิลด์'] = ''; มาวางต่อตรงนี้ได้เลยครับ

        echo $cdb->insert_data($tbname, $_POST);
        
        $sql = "select id from ministerialLaws where contentTypeID='$_POST[contentTypeID]' and createDate='$dt'";
        $query = $cdb->conn->prepare($sql);
        $query->execute();
        $data = $query->fetch(PDO::FETCH_ASSOC);
        
        $fd = 'ministerialLaws';
        uploadFiles('file_jpg', $fd, $data['id']);
        break;

        //แก้ไขข้อมูล
    case '2':
        $id = $_POST['id'];
        unset($_POST['form_action'], $_POST['id']);
        if ($_FILES['file_jpg']['error'] == 0) {
            $sql = "select coverImg from ministerialLaws where id='$id'";
            $query = $cdb->conn->prepare($sql); // แก้ไข Syntax จาก $query->$cdb ให้ถูกต้อง
            $query->execute();
            $data = $query->fetch(PDO::FETCH_ASSOC);
            
            $fd = 'ministerialLaws';
            $fds = "../../uploads/" . $fd . "/" . $id . "." . $data['coverImg'];
            unset($fds);
            uploadFiles('file_jpg', $fd, $id);
        }
        echo $cdb->update_data($tbname, $_POST, "id='$id'");
        break;

        // ลบข้อมูล
    case '3':
        echo $cdb->delete_data($tbname, "id='$_POST[id]'");
        break;

        // เช็ค url ซ้ำ (ยังไม่ถูกใช้งาน)
    case '4':
        break;

        //ดึงข้อมูลเพื่อแก้ไขข้อมูล
    case '5':
        $sql = "select * ";
        $sql .= " from $tbname ";
        $sql .= " where id=:id ";
        unset($_POST['form_action'], $_POST['createDate'], $_POST['createBy']);
        
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute($_POST);
            $data = $query->fetch(PDO::FETCH_ASSOC);
            foreach ($data as $key => $value) {
                if ($value == '') {
                    $value = ' ';
                }
                $json_data[$key] = $value;
            }
            $json = json_encode($json_data);
            echo $json;
        } catch (PDOException $er) {
            echo 'Error :' . $er->getMessage();
        }
        break;

        //ดึงข้อมูลเพื่อแสดง
    case '6':
        //ดึงข้อมูลหมวดหมู่
        $sql = "select id, title from contentType";
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute();
            $count = $query->rowCount();
            $i = 1;
            while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
                $sjt[$data['id']] = $data['title'];
            }
        } catch (PDOException $er) {
            echo 'Error :' . $er->getMessage();
        }
        
        $userName = $_SESSION['login_workGroup'];
        $no_field = array('page', 'qpage', 'form_action');
        $sql = "select * ";
        $sql .= " from $tbname where 1=1  and  $tbname.contentTypeID LIKE  '$userName'  ";
        
        $param = [];
        foreach ($_POST as $key => $value) {
            if (!in_array($key, $no_field)) {
                if ($value <> '') {
                    $field = str_replace('s_', '', $key);
                    if (strpos($key, 'title') !== false) {
                        $param[$field] = "%$value%";
                        $sql .= " and $field like :$field ";
                    } else {
                        $param[$field] = $value;
                        $sql .= " and $field=:$field ";
                    }
                }
            }
        }
        $sql .= " order by id  DESC ";
        
        // คำนวณจำนวนหน้า   
        $query = $cdb->conn->prepare($sql);
        $query->execute($param);
        $count = $query->rowCount();
        $json_data['pagination']['max_data'] = $count;
        
        //คำนวณ record เริ่มต้น
        if ($_POST['page'] == 1) {
            $json_data['pagination']['state'] = 'แสดง 1 - ' . $_POST['qpage'] . ' จาก ' . number_format($count) . ' รายการ';
            $start = 0;
        } else {
            $start = ($_POST['page'] - 1) * $_POST['qpage'];
            $json_data['pagination']['state'] = 'แสดง ' . ($start + 1) . ' - ' . ($start + $_POST['qpage']) . ' จาก ' . number_format($count) . ' รายการ';
        }
        $json_data['pagination']['max_loop'] = ceil(($count / $_POST['qpage']));
        
        $sql .= " limit $start,$_POST[qpage] ";
        
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute($param);
            $count = $query->rowCount();
            $i = 1;
            while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
                foreach ($data as $key => $value) {
                    //ดึงข้อหมวดหมู่
                    if ($key == 'contentTypeID') {
                        $json_data[$i]['name_type'] = isset($sjt[$value]) ? $sjt[$value] : '';
                    }
                    $json_data[$i][$key] = $value;
                }
                ++$i;
            }
        } catch (PDOException $er) {
            echo 'Error :' . $er->getMessage();
        }
        $json = json_encode($json_data);
        echo $json;
        break;

    case '7':
        $sql = "select * from $tbname order by rec_order";
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute();
            $count = $query->rowCount();
            $i = 1;
            while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
                foreach ($data as $key => $value) {
                    $json_data[$i][$key] = $value;
                }
                if ($data['id'] == $_POST['id']) {
                    $x = $i;
                }
                unset($json_data[$x]);
                ++$i;
            }
            $json = json_encode($json_data);
            echo $json;
        } catch (PDOException $er) {
            echo 'Error :' . $er->getMessage();
        }
        break;

        //สลับตำแหน่งข้อมูล function sort
    case 'getArticle':
        $sql = "select id,title from articleType   order by id ";
        $query = $cdb->conn->prepare($sql);
        $query->execute($param);
        while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
            $json_data[$data['id']] = $data['title'];
        }
        echo json_encode($json_data);
        break;
}