$type = array("R" => '1 Resuscitation', "E" => '2 Emergency', "U" => '3 Urgency', "S" => '4 Semi-Urgency', "N" => '5 Non-Urgency');
if (check_post($_POST, array('em_date', 'em_type'))) {
if (!empty($_POST['em_id'])) {
$sql = 'UPDATE ' . TB_PREFIX . '7days SET
em_date = :date,
em_type = :type,
em_sex = :sex,
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' ? 'ชาย' : 'หญิง';
session_start();
error_reporting(E_ALL ^ E_NOTICE);
if (empty($_POST['act']) || empty($_POST['id'])) {
http_response_code(400);
echo "ข้อมูลไม่เพียงพอ";
exit;
}
$ID = isset($_POST['id']) ? $_POST['id'] : NULL;
if ($_SERVER["REQUEST_METHOD"] == "POST") {
require '../dv-config.php';
require DEV_PATH . '/classes/db.class.v2.php';
require DEV_PATH . '/functions/global.php';
switch ($_POST['act']) {
case 'apv':
try {
CON::updateDB(array('id' => $ID), "UPDATE " . TB_PREFIX . "booking_order SET " . TB_PREFIX . "booking_order.ord_status = '1' WHERE " . TB_PREFIX . "booking_order.ord_id=:id");
} catch (Exception $e) {
echo 'ไม่สามารถบันทึกข้อมูลได้' . $e;
http_response_code(403);
}
echo 'อนุมัติเรียบร้อยแล้ว';
http_response_code(200);
break;
case 'delord':
try {
CON::deleteDB('booking_order', 'ord_id = ' . $ID, true);
} catch (Exception $e) {
echo 'ไม่สามารถลบได้' . $e;
http_response_code(403);
}
echo 'ลบรายการที่เลือกแล้ว';
