<?php session_start();
//include('../../includes/connect.php');
include('../../includes/function_db.php');
$dt = date('Y-m-d H:i:s');
$tbname = "slideBanner";

function checkFileType($file, $allowType) {
    $fileName = basename($_FILES[$file]['name']);
    $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
    $allow = array('jpg', 'jpeg', 'png', 'gif', 'webp');
    if (in_array(strtolower($fileType), $allow)) {
        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;
    
    // สร้างโฟลเดอร์ถ้ายังไม่มี
    $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 '1':
        unset($_POST['form_action'], $_POST['id']);
        
        $fileName = basename($_FILES['file_jpg']['name']);
        $fileType = pathinfo($fileName, PATHINFO_EXTENSION);
        $_POST['coverImg'] = $fileType;
        $_POST['createDate'] = $dt;

        // ดักค่าให้ตรงกับ Database เพื่อไม่ให้ฟ้อง Error 1364
        if(empty($_POST['link'])) $_POST['link'] = '';
        if(empty($_POST['contentTypeID'])) $_POST['contentTypeID'] = $_SESSION['login_workGroup'] ?? 0;
        if(empty($_POST['rec_order'])) $_POST['rec_order'] = 1;
        if(empty($_POST['status'])) $_POST['status'] = 1;
        if(empty($_POST['createBy'])) $_POST['createBy'] = $_SESSION['login_userName'] ?? 'admin';

        echo $cdb->insert_data($tbname, $_POST);
        
        $cdb = new control_db();
        $sql = "select id from $tbname where createDate='$dt' order by id DESC limit 1";
        $query = $cdb->conn->prepare($sql);
        $query->execute();
        $data = $query->fetch(PDO::FETCH_ASSOC);
        
        $fd = 'slideBanner';
        if (!empty($_FILES['file_jpg']['name'])) {
            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 $tbname where id='$id'";
            $query = $cdb->conn->prepare($sql);
            $query->execute();
            $data = $query->fetch(PDO::FETCH_ASSOC);
            
            $fd = 'slideBanner';
            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;

        // ลบข้อมูล
    case '3':
        // ดึงชื่อไฟล์มาก่อนลบ DB
        $id = $_POST['id'];
        $sql = "select coverImg from $tbname where id='$id'";
        $query = $cdb->conn->prepare($sql);
        $query->execute();
        $data = $query->fetch(PDO::FETCH_ASSOC);
        
        if(!empty($data['coverImg'])) {
            $fds = "../../uploads/slideBanner/" . $id . "." . $data['coverImg'];
            if(file_exists($fds)) unlink($fds); // ลบไฟล์รูปออกโฮสต์ด้วย
        }

        echo $cdb->delete_data($tbname, "id='$id'");
        break;

        // ดึงข้อมูลเพื่อแก้ไขข้อมูล
    case '5':
        $sql = "select * from $tbname 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);
            $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':
        // ดึงข้อมูลหมวดหมู่มาเทียบชื่อ (ถ้ามี)
        $sjt = array();
        $sql = "select id, title from contentType";
        $query = $cdb->conn->prepare($sql);
        try {
            $query->execute();
            while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
                $sjt[$data['id']] = $data['title'];
            }
        } catch (PDOException $er) {}
        
        $userName = $_SESSION['login_workGroup'] ?? '';
        $no_field = array('page', 'qpage', 'form_action');
        $sql = "select * from $tbname where 1=1 "; 
        
        // ถ้าต้องการดูเฉพาะของกลุ่มงานตัวเอง ให้เปิดใช้งานบรรทัดล่างนี้ (ถ้าแอดมินดูทั้งหมด ข้ามไปได้ครับ)
        // $sql .= " and contentTypeID LIKE '$userName' ";
        
        $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 id DESC ";
        
        $query = $cdb->conn->prepare($sql);
        $query->execute($param);
        $count = $query->rowCount();
        
        $json_data = array();
        $json_data['pagination']['max_data'] = $count;
        
        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);
            $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 json_encode($json_data);
        break;
}