TripleDNN

Current Directory: /home/pack/admin

File Name	Size	Actions
beacons.php	12815 bytes	Edit \| Delete \| Rename \| Download
dashboard.php	8161 bytes	Edit \| Delete \| Rename \| Download
header.php	3166 bytes	Edit \| Delete \| Rename \| Download
items.php	12949 bytes	Edit \| Delete \| Rename \| Download
logs.php	3380 bytes	Edit \| Delete \| Rename \| Download
users.php	8756 bytes	Edit \| Delete \| Rename \| Download

<?php
require_once "../config.php";
require_once "../auth.php";
require_login();

include "header.php";

/* ========================= SweetAlert Helper ========================= */
function swal($title, $text, $icon, $redirect = null) {
    echo "<script>
        Swal.fire({
            title: '$title',
            text: '$text',
            icon: '$icon',
            confirmButtonText: 'ตกลง'
        }).then(() => {";

if ($redirect) echo "window.location='$redirect';";

echo "});
    </script>";
}

/* ===================================================================
   ฟังก์ชันแปลงวันที่ ENUM → ไทย
=================================================================== */
function thaiDay($d) {
    $map = [
        'monday' => 'จันทร์',
        'tuesday' => 'อังคาร',
        'wednesday' => 'พุธ',
        'thursday' => 'พฤหัสบดี',
        'friday' => 'ศุกร์',
        'saturday' => 'เสาร์',
        'sunday' => 'อาทิตย์'
    ];
    return $map[$d];
}

/* ===================================================================
   สีของวัน
=================================================================== */
function dayColor($d) {
    $color = [
        'monday' => '#0d6efd',
        'tuesday' => '#6610f2',
        'wednesday' => '#198754',
        'thursday' => '#fd7e14',
        'friday' => '#dc3545',
        'saturday' => '#20c997',
        'sunday' => '#6f42c1'
    ];
    return $color[$d];
}

/* ===================================================================
   ตรวจ user_id ที่จะใช้ filter
=================================================================== */
if ($ROLE == "user") {
    $selected_user = $USER_ID;
} else {
    $selected_user = isset($_GET['uid']) ? intval($_GET['uid']) : 0;
}

/* ===================================================================
   ADD ITEM (Prevent duplicate day)
=================================================================== */
if (isset($_POST['add_item'])) {

$uid = ($ROLE == "user") ? $USER_ID : intval($_POST['user_id']);
    $day = $_POST['day'];
    $name = trim($_POST['item_name']);

// ตรวจว่ามีวันนี้แล้วหรือยัง
    $chk = $conn->query("SELECT id FROM items WHERE user_id=$uid AND day='$day'");

if ($chk->num_rows > 0) {
        swal("ซ้ำ!", "ไม่สามารถเพิ่มรายการวันนี้ได้ (มีข้อมูลอยู่แล้ว)", "error");
    } else {
        $stmt = $conn->prepare("INSERT INTO items (user_id, day, item_name) VALUES (?, ?, ?)");
        $stmt->bind_param("iss", $uid, $day, $name);
        $stmt->execute();

swal("สำเร็จ", "เพิ่มรายการสำเร็จ", "success", "items.php?uid=$uid");
    }
}

/* ===================================================================
   EDIT ITEM (Prevent duplicate day)
=================================================================== */
if (isset($_POST['edit_item'])) {

$id   = intval($_POST['item_id']);
    $day  = $_POST['day'];
    $name = trim($_POST['item_name']);

$r = $conn->query("SELECT user_id FROM items WHERE id=$id")->fetch_assoc();
    $uid = $r['user_id'];

if ($ROLE == "user" && $uid != $USER_ID) {
        swal("สิทธิ์ไม่เพียงพอ", "คุณไม่มีสิทธิ์แก้ไขรายการนี้", "error", "items.php");
        exit;
    }

// เช็คซ้ำ
    $chk = $conn->query("
        SELECT id FROM items 
        WHERE user_id=$uid AND day='$day' AND id<>$id
    ");

if ($chk->num_rows > 0) {
        swal("วันซ้ำ!", "ไม่สามารถบันทึกได้ — วันนี้มีรายการอยู่แล้ว", "error");
    } else {
        $stmt = $conn->prepare("UPDATE items SET day=?, item_name=? WHERE id=?");
        $stmt->bind_param("ssi", $day, $name, $id);
        $stmt->execute();

swal("สำเร็จ", "บันทึกข้อมูลเรียบร้อย", "success", "items.php?uid=$uid");
    }
}

/* ===================================================================
   DELETE ITEM
=================================================================== */
if (isset($_GET['del'])) {

$id = intval($_GET['del']);

$r = $conn->query("SELECT user_id FROM items WHERE id=$id")->fetch_assoc();
    if ($ROLE=="user" && $r['user_id'] != $USER_ID) {
        swal("สิทธิ์ไม่เพียงพอ", "คุณไม่มีสิทธิ์ลบรายการนี้", "error", "items.php");
        exit;
    }

$conn->query("DELETE FROM items WHERE id=$id");

swal("สำเร็จ", "ลบรายการเรียบร้อย", "success", "items.php?uid={$r['user_id']}");
}
?>

<h3><i class="bi bi-list-check"></i> รายการสิ่งของประจำวัน</h3>
<hr>

<?php if ($ROLE != "user"): ?>
<h5><i class="bi bi-people"></i> เลือกผู้ใช้</h5>

<div class="row mb-4">
<?php
$users = $conn->query("SELECT id, fullname, role FROM users ORDER BY fullname");
while ($u = $users->fetch_assoc()):
?>
<div class="col-md-3">
    <a href="items.php?uid=<?= $u['id'] ?>" class="text-decoration-none text-dark">
        <div class="user-list-box mb-2 <?= ($selected_user==$u['id'])?'border-primary':'' ?>">
            <strong><?= $u['fullname'] ?></strong><br>
            <small><?= $u['role'] ?></small>
        </div>
    </a>
</div>
<?php endwhile; ?>
</div>

<?php if (!$selected_user): ?>
<div class="alert alert-info">กรุณาเลือกผู้ใช้ก่อน</div>
<?php include "../footer.php"; exit(); ?>
<?php endif; ?>

<?php else: ?>
<h5 class="text-muted"><i class="bi bi-person"></i> ผู้ใช้: <?= $_SESSION['fullname'] ?></h5>
<?php endif; ?>

<?php
$sql = "
    SELECT items.*, users.fullname
    FROM items
    JOIN users ON items.user_id = users.id
    WHERE items.user_id = $selected_user
    ORDER BY FIELD(day,'monday','tuesday','wednesday','thursday','friday','saturday','sunday'),
             items.id DESC
";
$res = $conn->query($sql);
?>

<?php while ($i = $res->fetch_assoc()): ?>
<?php $color = dayColor($i['day']); ?>

<button onclick="confirmDelete(<?= $i['id'] ?>)"
               class="btn btn-danger btn-sm">
                <i class="bi bi-trash"></i>
            </button>

<?php endif; ?>
        </div>

</div>
</div>

<script>
function confirmDelete(id){
    Swal.fire({
        title: "ลบรายการ?",
        text: "ต้องการลบรายการนี้หรือไม่?",
        icon: "warning",
        showCancelButton: true,
        confirmButtonText: "ลบ",
        cancelButtonText: "ยกเลิก"
    }).then((res)=>{
        if(res.isConfirmed){
            window.location = "items.php?del=" + id + "&uid=<?= $selected_user ?>";
        }
    });
}
</script>

<div class="modal fade" id="editModal<?= $i['id'] ?>">
  <div class="modal-dialog">
    <div class="modal-content">

<div class="modal-header">
          <h5 class="modal-title">แก้ไขรายการ</h5>
          <button class="btn-close" data-bs-dismiss="modal"></button>
        </div>

<label>วัน</label>
          <select name="day" class="form-select mb-2">
            <?php
            foreach (['monday'=>'จันทร์','tuesday'=>'อังคาร','wednesday'=>'พุธ','thursday'=>'พฤหัสบดี','friday'=>'ศุกร์','saturday'=>'เสาร์','sunday'=>'อาทิตย์'] as $k=>$v):
            ?>
            <option value="<?= $k ?>" <?= $i['day']==$k?'selected':'' ?>><?= $v ?></option>
            <?php endforeach; ?>
          </select>

<label>รายการสิ่งของ</label>
          <input type="text" name="item_name"
                 class="form-control"
                 value="<?= htmlspecialchars($i['item_name']) ?>"
                 required>

</div>

<div class="modal-footer">
          <button name="edit_item" class="btn btn-success">
            <i class="bi bi-save"></i> บันทึก
          </button>
        </div>

</form>

</div>
  </div>
</div>

<?php endwhile; ?>
</div>

<div class="btn btn-primary rounded-circle"
     style="position: fixed; bottom:25px; right:25px; width:60px; height:60px; font-size:32px;"
     data-bs-toggle="modal" data-bs-target="#addModal">+
</div>

<?php
/* ========================
   วันทั้งหมด
======================== */
$all_days = [
    'monday' => 'จันทร์',
    'tuesday' => 'อังคาร',
    'wednesday' => 'พุธ',
    'thursday' => 'พฤหัสบดี',
    'friday' => 'ศุกร์',
    'saturday' => 'เสาร์',
    'sunday' => 'อาทิตย์'
];

/* ========================
   วันของ user ที่ใช้ไปแล้ว
======================== */
$used_days = [];
$day_q = $conn->query("SELECT day FROM items WHERE user_id=$selected_user");
while ($d = $day_q->fetch_assoc()) {
    $used_days[] = $d['day'];
}
?>

<div class="modal fade" id="addModal">
  <div class="modal-dialog">
    <div class="modal-content">

<div class="modal-header">
          <h5 class="modal-title">เพิ่มรายการสิ่งของ</h5>
          <button class="btn-close" data-bs-dismiss="modal"></button>
        </div>

<?php if ($ROLE != "user"): ?>
          <label>ผู้ใช้</label>
          <select name="user_id" class="form-select mb-2">
            <?php
            $u = $conn->query("SELECT id, fullname FROM users ORDER BY fullname");
            while ($x = $u->fetch_assoc()):
            ?>
              <option value="<?= $x['id'] ?>" <?= ($selected_user==$x['id'])?'selected':'' ?>>
                <?= $x['fullname'] ?>
              </option>
            <?php endwhile; ?>
          </select>
          <?php else: ?>
          <input type="hidden" name="user_id" value="<?= $USER_ID ?>">
          <?php endif; ?>

<label>รายการสิ่งของ</label>
          <input type="text" name="item_name" class="form-control" required>

</div>

<div class="modal-footer">
          <button name="add_item" class="btn btn-primary">
            <i class="bi bi-plus-circle"></i> เพิ่มรายการ
          </button>
        </div>

</form>

</div>
  </div>
</div>

<?php include "../footer.php"; ?>