<?php session_start();
include('../../includes/function_db.php');
$dt = date('Y-m-d H:i:s');
$tbname = "personnel";

function uploadFiles($file, $path, $fn) {
    $fileName = basename($_FILES[$file]['name']);
    $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
    $folder = "../../uploads/$path/" . $fn . "." . $fileType;
    
    $dir = "../../uploads/$path";
    if (!is_dir($dir)) { mkdir($dir, 0777, true); }
    
    move_uploaded_file($_FILES[$file]["tmp_name"], $folder);
}

$cdb = new control_db();
switch ($_POST['form_action']) {
        // แก้ไขข้อมูล (Case 2 อย่างเดียว ไม่มี Insert/Delete)
    case '2':
        $id = $_POST['id'];
        unset($_POST['form_action'], $_POST['id']);
        
        $_POST['updateDate'] = $dt;
        
        // จัดการอัปโหลดไฟล์ใหม่ถ้ามีการเลือกไฟล์มา
        if (isset($_FILES['file_jpg']) && $_FILES['file_jpg']['error'] == 0) {
            $sql = "select coverImg from $tbname where id='$id'";
            $query = $cdb->conn->prepare($sql);
            $query->execute();
            $data = $query->fetch(PDO::FETCH_ASSOC);
            
            $fd = 'personnel';
            if(!empty($data['coverImg'])) {
                $fds = "../../uploads/" . $fd . "/" . $id . "." . $data['coverImg'];
                if(file_exists($fds)) unlink($fds); // ลบไฟล์เก่า
            }
            uploadFiles('file_jpg', $fd, $id);
            $_POST['coverImg'] = pathinfo(basename($_FILES['file_jpg']['name']), PATHINFO_EXTENSION);
        }
        
        echo $cdb->update_data($tbname, $_POST, "id='$id'");
        break;

        // ดึงข้อมูลเพื่อมาแสดงใน Modal แก้ไข
    case '5':
        $sql = "select * from $tbname where id=:id";
        unset($_POST['form_action']);
        
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute($_POST);
            $data = $query->fetch(PDO::FETCH_ASSOC);
            $json_data = array();
            foreach ($data as $key => $value) {
                $json_data[$key] = ($value == '') ? ' ' : $value;
            }
            echo json_encode($json_data);
        } catch (PDOException $er) {
            echo 'Error :' . $er->getMessage();
        }
        break;

        // ดึงข้อมูลเพื่อแสดงตาราง
    case '6':
        $no_field = array('page', 'qpage', 'form_action');
        $sql = "select * from $tbname where 1=1 "; 
        
        $param = [];
        foreach ($_POST as $key => $value) {
            if (!in_array($key, $no_field) && $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 rec_order ASC "; // เรียงตามลำดับหน้า 1 2 3
        
        $query = $cdb->conn->prepare($sql);
        $query->execute($param);
        $count = $query->rowCount();
        
        $json_data = array();
        $json_data['pagination']['max_data'] = $count;
        $json_data['pagination']['state'] = "แสดงทั้งหมด $count รายการ";
        $json_data['pagination']['max_loop'] = 1;
        
        // ไม่ต้อง Limit หน้า เพราะหน้าทำเนียบมีจำกัดอยู่แล้ว
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute($param);
            $i = 1;
            while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
                foreach ($data as $key => $value) {
                    $json_data[$i][$key] = $value;
                }
                ++$i;
            }
        } catch (PDOException $er) {}
        echo json_encode($json_data);
        break;
}