em_admit = :admit,
em_dead = :dead,
em_record = :record
WHERE em_id=:id';
} else {
$sql = 'INSERT INTO ' . TB_PREFIX . '7days VALUES (:id,:date,:type,:sex,:admit,:dead,:record)';
}
$arr = array('id' => $_POST['em_id'], 'date' => $_POST['em_date'], 'type' => $_POST['em_type'], 'sex' => $_POST['em_sex'], 'admit' => $_POST['em_admit'], 'dead' => $_POST['em_dead'], 'record' => date("Y-m-d H:i:s"));
if (CON::updateDB($arr, $sql)) {
$jsExt .= 'swal({title: "All done!", text: "บันทึกสำเร็จ", timer: 2000, showConfirmButton: false, type: "success"});';
} else {
$jsExt .= 'swal({title:"มีข้อผิดพลาด",type:"warning",confirmButtonColor:"#FF5722"});';
}
}
if ($GET_MODE == 'delete') {
if (CON::deleteDB('7days', 'em_id = ' . $GET_ID)) {
$jsExt .= 'swal("Deleted!", "ลบรายการที่เลือกแล้ว", "success");';
} else {
$jsExt .= 'swal({title:"มีข้อผิดพลาด",type:"warning",confirmButtonColor:"#FF5722"});';
}
}
$query = CON::selectArrayDB(array(), 'SELECT * FROM ' . TB_PREFIX . '7days');
foreach ($query as $row) {
$gender = $row['em_sex'] == 'm' ? 'ชาย' : 'หญิง';
$table .= '<tr>
<td class="text-center">' . $row['em_id'] . '</td>
<td>' . $row['em_date'] . '</td>
<td>' . $type[$row['em_type']] . '</td>
<td>' . $gender . '</td>
<td>' . $row['em_admit'] . '</td>
<td>' . $row['em_dead'] . '</td>
break;
case 'delord':
try {
CON::deleteDB('booking_order', 'ord_id = ' . $ID, true);
} catch (Exception $e) {
echo 'ไม่สามารถลบได้' . $e;
http_response_code(403);
}
echo 'ลบรายการที่เลือกแล้ว';
http_response_code(200);
break;
case 'delrm':
try {
$sql = 'SELECT rm_photo FROM ' . TB_PREFIX . 'booking_room WHERE rm_id = ' . $ID;
$row = CON::selectArrayDB(array(), $sql);
if (file_exists('upload/' . $row[0]['rm_photo'])) {
unlink('upload/' . $row[0]['rm_photo']);
}
CON::deleteDB('booking_room', 'rm_id = ' . $ID);
} catch (Exception $e) {
echo 'ไม่สามารถลบได้' . $e;
http_response_code(403);
}
echo 'ลบรายการที่เลือกแล้ว';
http_response_code(200);
break;
}
} else {
http_response_code(403);
echo "มันต้องมีอะไรซักอย่างไม่ถูกต้อง";
}
