<td>' . $type[$row['em_type']] . '</td>
<td>' . $gender . '</td>
<td>' . $row['em_admit'] . '</td>
<td>' . $row['em_dead'] . '</td>
<td><div class="btn-group btn-group-sm">
<a href="' . SITE_URL . '/edit/' . $row['em_id'] . '" class="btn btn-warning tt" title="แก้ไข"><i class="fa fa-pencil-square-o"></i></a>
<a href="' . SITE_URL . '/delete/' . $row['em_id'] . '" class="btn btn-default tt delete" title="ลบ"><i class="fa fa-trash"></i></a>
</a>
</div></td>
</tr>';
}
if ($GET_MODE == 'edit') {
$heading = 'แก้ไขรายการที่ : ' . $GET_ID;
$panel = 'panel-warning';
$button = '<button type="submit" class="btn btn-lg btn-warning">Edit <i class="fa fa-reply-all"></i></button>';
$getlog = CON::selectArrayDB(array($GET_ID), 'SELECT * FROM ' . TB_PREFIX . '7days WHERE em_id = ?');
} else {
$heading = 'เพิ่มอุบัติเหตุใหม่';
$panel = 'panel-primary';
$button = '<button type="submit" class="btn btn-lg btn-primary">Submit <i class="fa fa-paper-plane"></i></button>';
}
?>
<!DOCTYPE html>
<html lang="">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<title>7Days</title>
<!-- Bootstrap CSS -->
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 "มันต้องมีอะไรซักอย่างไม่ถูกต้อง";
}
MONTH(' . TB_PREFIX . 'booking_order.ord_date_start) = ' . $month . ' AND
YEAR(' . TB_PREFIX . 'booking_order.ord_date_start) = ' . $year . '
ORDER BY
' . TB_PREFIX . 'booking_order.ord_date_start';
$res = CON::selectArrayDB(array(), $sql);
// echo '<div class="col-md-6"><h2>Before</h2><pre>';
// print_r($res);
// echo '</pre></div>';
// foreach ($res as $key => $value) {
// //$currentDate = ($currentDate!=$value['cDay']) ? $value['cDay'] : $currentDate;
// $ardate[$value['cDay']][] = '<a href="'.SITE_URL.'/view-detail.php?id='.$value['ord_id'].'" class="label label-order tt detail fancybox.iframe" style="background-color:rgba('.$value['rm_color'].',.7);" title="'.$value['ord_owner_name'].' : '.$value['rm_name'].'">'.$value['sTime'].' - '.$value['eTime'].'</a>';
// }
// echo '<div class="col-md-6"><h2>After</h2><pre>';
// print_r($ardate);
// echo '</pre></div>';
$res_room = CON::selectArrayDB(array(), "SELECT * FROM " . TB_PREFIX . "booking_room ORDER BY rm_id");
echo '
<!-- Navigator -->
<div class="row nav navbar hidden-xs hidden-sm">
<div class="col-xs-3">
<a class="btn btn-lg btn-primary tt" href="' . SITE_URL . '/task/' . $prevMon . '/' . $prevYear . '/" title="' . lang_previous . '" id="prevMonth"><i class="fa fa-lg fa-arrow-left"></i> ' . $month_array[$prevMon] . '</a>
</div>
<div class="col-xs-6 text-center">
<h3>' . $title . '</h3>
</div>
<div class="col-xs-3 text-right">
<a class="btn btn-lg btn-primary tt" href="' . SITE_URL . '/task/' . $nextMon . '/' . $nextYear . '/" title="' . lang_next . '" id="nextMonth">' . $month_array[$nextMon] . ' <i class="fa fa-lg fa-arrow-right"></i></a>
</div>
</div><!-- //Navigator -->
<!-- Navigator Mobile -->
<?php session_start(); error_reporting(E_ERROR | E_WARNING | E_PARSE); //require ( 'login-check.php' ); require '../dv-config.php'; require DEV_PATH . '/functions/global.php'; require DEV_PATH . '/classes/db.class.v2.php'; require 'lang/th.php'; $rm = CON::selectArrayDB(array(), "SELECT " . TB_PREFIX . "booking_order.ord_id,\n" . TB_PREFIX . "booking_order.ord_date_start,\n" . TB_PREFIX . "booking_order.ord_date_end,\n" . TB_PREFIX . "booking_order.ord_date_request,\n" . TB_PREFIX . "booking_order.ord_room_id,\n" . TB_PREFIX . "booking_order.ord_subject,\n" . TB_PREFIX . "booking_order.ord_person,\n" . TB_PREFIX . "booking_order.ord_person_amount,\n" . TB_PREFIX . "booking_order.ord_owner_name,\n" . TB_PREFIX . "booking_order.ord_owner_section,\n" . TB_PREFIX . "booking_order.ord_ps,\n" . TB_PREFIX . "booking_order.ord_status,\n" . TB_PREFIX . "booking_order.ord_user_id,\n" . TB_PREFIX . "department_section.sec_name,\n" . TB_PREFIX . "booking_room.rm_id,\n" . TB_PREFIX . "booking_room.rm_name,\n" . TB_PREFIX . "booking_room.rm_detail,\n" . TB_PREFIX . "booking_room.rm_limit,\n" . TB_PREFIX . "booking_room.rm_type,\n" . TB_PREFIX . "booking_room.rm_cost,\n" . TB_PREFIX . "booking_room.rm_photo,\n" . TB_PREFIX . "booking_room.rm_color,\n" . TB_PREFIX . "booking_room.rm_status,\n" . TB_PREFIX . "member.mem_name\nFROM " . TB_PREFIX . "booking_order\nLEFT JOIN " . TB_PREFIX . "booking_room ON " . TB_PREFIX . "booking_room.rm_id = " . TB_PREFIX . "booking_order.ord_room_id\nLEFT JOIN " . TB_PREFIX . "department_section ON " . TB_PREFIX . "department_section.sec_id = " . TB_PREFIX . "booking_order.ord_owner_section\nLEFT JOIN " . TB_PREFIX . "member ON " . TB_PREFIX . "member.mem_id = " . TB_PREFIX . "booking_order.ord_user_id\nWHERE ord_id = " . $_GET['id']); $photo = isset($rm[0]['rm_photo']) ? '<img src="' . SITE_URL . '/upload/' . $rm[0]['rm_photo'] . '" class="img-responsive" />' : '<img src="//placehold.it/300x200&text=No+Photo" class="img-responsive" />'; ?> <br> <div class="container-fluid" id="detail"> <div class="col-sm-6 col-sm-push-6"> <h1><i class="fa fa-check-square-o"></i> <?php echo lang_head_view; ?> </h1> <div class="panel panel-default"> <big><?php echo $status_array[$rm[0]['ord_status']]; ?> </big> <?php echo lang_on; ?> <strong><?php echo thai_date($rm[0]['ord_date_request'], 0, 1); ?> </strong>
*
*/
$sql = '
SELECT
ord_id,DATE(ath_booking_order.ord_date_start) as cDay,TIME_FORMAT(ath_booking_order.ord_date_start,"%H:%i%p") as sTime,TIME_FORMAT(ath_booking_order.ord_date_end,"%H:%i%p") as eTime,ord_date_end,ord_room_id,ord_subject,ord_owner_name,rm_name,rm_color
FROM
' . TB_PREFIX . 'booking_order
INNER JOIN
' . TB_PREFIX . 'booking_room ON (' . TB_PREFIX . 'booking_order.ord_room_id = ' . TB_PREFIX . 'booking_room.rm_id)
WHERE
MONTH(' . TB_PREFIX . 'booking_order.ord_date_start) = ' . $month . ' AND
YEAR(' . TB_PREFIX . 'booking_order.ord_date_start) = ' . $year . ' AND
' . TB_PREFIX . 'booking_order.ord_status = 1
ORDER BY
' . TB_PREFIX . 'booking_order.ord_date_start';
$res = CON::selectArrayDB(array(), $sql);
// echo '<div class="col-md-6"><h2>Before</h2><pre>';
// print_r($res);
// echo '</pre></div>';
foreach ($res as $key => $value) {
//$currentDate = ($currentDate!=$value['cDay']) ? $value['cDay'] : $currentDate;
$ardate[$value['cDay']][] = '
<a href="' . SITE_URL . '/v' . $value['ord_id'] . '/"
data-target="#BookDetail"
data-toggle="modal"
data-html="true"
class="detail label label-order tt"
style="background-color:rgba(' . hex2rgb($value['rm_color']) . ',.7);"
title=" ' . $value['ord_subject'] . '<br>' . $value['rm_name'] . ' ">
' . $value['sTime'] . ' - ' . $value['eTime'] . '
</a>';
<th class="text-center">Total</th>
<th class="text-center">Man</th>
<th class="text-center">Lady</th>
<th class="text-center" style="background-color:#b71c1c;color:white;">R</th>
<th class="text-center" style="background-color:#d81b60;color:white;">E</th>
<th class="text-center" style="background-color:#ffea00;color:white;" >U</th>
<th class="text-center" style="background-color:#43a047;color:white;">SU</th>
<th class="text-center" style="background-color:#9e9e9e;color:white;">N</th>
<th class="text-center">Admit</th>
<th class="text-center">Dead</th>
</tr>
</thead>
<tbody>
<?php
$graph_sql = "\n SELECT\n ath_7days.em_date,\n Sum(IF(ath_7days.em_sex = 'm',1,0)) AS man,\n Sum(IF(ath_7days.em_sex = 'w',1,0)) AS woman,\n SUM(IF(ath_7days.em_type = 'R',1,0)) AS R,\n SUM(IF(ath_7days.em_type = 'E',1,0)) AS E,\n SUM(IF(ath_7days.em_type = 'U',1,0)) AS U,\n SUM(IF(ath_7days.em_type = 'S',1,0)) AS S,\n SUM(IF(ath_7days.em_type = 'N',1,0)) AS N,\n (Sum(IF(ath_7days.em_sex = 'm',1,0)) + Sum(IF(ath_7days.em_sex = 'w',1,0))) AS total,\n SUM(IF(ath_7days.em_admit = 1,1,0)) AS admit,\n SUM(IF(ath_7days.em_dead = 1,1,0)) AS dead\n FROM\n ath_7days\n GROUP BY\n ath_7days.em_date\n ";
$graph_query = CON::selectArrayDB(array(), $graph_sql);
foreach ($graph_query as $row) {
echo '<tr class="text-center">
<td>' . thai_date($row['em_date'], 0, 0) . '</td>
<td class="active"><strong>' . $row['total'] . '</strong></td>
<td>' . $row['man'] . '</td>
<td>' . $row['woman'] . '</td>
<td>' . $row['R'] . '</td>
<td>' . $row['E'] . '</td>
<td>' . $row['U'] . '</td>
<td>' . $row['S'] . '</td>
<td>' . $row['N'] . '</td>
<td>' . $row['admit'] . '</td>
<td>' . $row['dead'] . '</td>
</tr>';
$level .= '{ date: "' . $row['em_date'] . '", r: ' . $row['R'] . ', e: ' . $row['E'] . ', u:' . $row['U'] . ',s:' . $row['S'] . ',n:' . $row['N'] . ' },';
<div class="btn-group btn-group-xs pull-right">';
echo '
<a class="btn btn-warning clickOFF tt" title="แก้ไข" data-placement="left" href="' . SITE_URL . '/admin-rooms/' . $tk['rm_id'] . '/edit/#room"><i class="fa fa-edit"></i></a>
<a class="btn btn-danger clickOFF delete tt" title="ลบ" data-placement="right" data-id="' . $tk['rm_id'] . '" data-act="delrm" href="../admin-manage.php"><i class="fa fa-trash"></i></a>
</div></td>
</tr>';
}
echo '</tbody></table>';
}
?>
</div>
</div>
<?php
if (isset($GET_ID)) {
$res = CON::selectArrayDB(array(), "SELECT rm_id, rm_name, rm_detail, rm_limit, rm_type, rm_cost, rm_photo, rm_color, rm_status FROM " . TB_PREFIX . "booking_room WHERE " . TB_PREFIX . "booking_room.rm_id = " . $GET_ID);
$btn = 'warning';
$btt = lang_update;
$photo = isset($res[0]['rm_photo']) ? '<img src="' . SITE_URL . '/upload/' . $res[0]['rm_photo'] . '" class="img-responsive" /><input type="hidden" name="rm_photo_cur" value="' . $res[0]['rm_photo'] . '">' : '<img src="//placehold.it/300x200&text=No+Photo" class="img-responsive" />';
} else {
$res = array(0);
$btn = 'info';
$btt = lang_submit;
$photo = '<img src="//placehold.it/300x200&text=Room+Photo" class="img-responsive" />';
}
$jsExt .= <<<JSEXT
/* ColorPicker */
\$('#colorSelector').ColorPicker({
JSEXT;
$jsExt .= PHP_EOL . "color:'#" . $res[0]['rm_color'] . "'," . PHP_EOL;
$jsExt .= <<<JSEXT
<div class="panel panel-primary">
<div class="panel-heading">
<h3 class="panel-title"><span class="fa fa-building-o"></span> Room List</h3>
</div>
<div class="panel-body">
<?php
$rm_status = array('Y' => 'ให้จองได้', 'N' => 'งดจอง', 'U' => 'ปิดปรับปรุง');
/* dropdown */
$rm_status_fa = array('Y' => 'fa-check-square text-success big', 'N' => 'fa-exclamation-triangle text-warning', 'U' => 'fa-gavel text-info');
/* fa */
$sql = 'SELECT rm_id, rm_name, rm_detail, rm_limit, rm_type, rm_cost, rm_photo, rm_color, rm_status FROM ' . TB_PREFIX . 'booking_room ORDER BY ' . TB_PREFIX . 'booking_room.rm_id';
$room_all = CON::selectArrayDB(array(), $sql);
echo '<!-- Tasklist -->';
if (empty($room_all)) {
echo '<div class="jumbotron text-center text-success">
<span class="fa-stack fa-5x">
<i class="fa fa-square-o fa-stack-2x"></i>
<i class="fa fa-check fa-stack-1x"></i>
</span>
<h1>Available</h1>
</div>';
} else {
echo '<table class="table table-bordered table-condensed">
<thead>
<tr class="small">
<th class="col-sm-1">' . lang_r_id . '</th>
<th class="col-sm-6">' . lang_r_name . '</th>
<th class="col-sm-1">' . lang_r_type . '</th>
<th class="col-sm-1">' . lang_r_limit . '</th>
<th class="col-sm-1">' . lang_r_cost . '</th>
<th class="col-sm-1">' . lang_r_status . '</th>
}
if ($param == 'edit') {
$arr = array('ord_id' => $_POST['ord_id'], 'ord_date_start' => $_POST['ord_date_start'] . ' ' . $_POST['ord_date_start_t'], 'ord_date_end' => $_POST['ord_date_end'] . ' ' . $_POST['ord_date_end_t'], 'ord_room_id' => $_POST['ord_room_id'], 'ord_subject' => $_POST['ord_subject'], 'ord_person' => $_POST['ord_person'], 'ord_person_amount' => $_POST['ord_person_amount'], 'ord_owner_name' => $_POST['ord_owner_name'], 'ord_owner_section' => $_POST['ord_owner_section'], 'ord_ps' => $_POST['ord_ps'], 'ord_status' => $_POST['ord_status']);
$sql = "UPDATE " . TB_PREFIX . "booking_order SET\n\t\tord_date_start = :ord_date_start,\n\t\tord_date_end = :ord_date_end,\n\t\tord_room_id = :ord_room_id,\n\t\tord_subject = :ord_subject,\n\t\tord_person = :ord_person,\n\t\tord_person_amount = :ord_person_amount,\n\t\tord_owner_name = :ord_owner_name,\n\t\tord_owner_section = :ord_owner_section,\n\t\tord_ps = :ord_ps,\n\t\tord_status = :ord_status\n\t\tWHERE ord_id = :ord_id";
}
// echo print_test($arr);
// echo print_test($_POST);
// echo $sql;
if (CON::updateDB($arr, $sql)) {
echo '<div class="col-md-12"><p class="report alert alert-success"><a class="close">×</a><strong>Success</strong> ปรับปรุงข้อมูลสำเร็จ ', date('Y-m-d H:i:s'), '</p></div>';
} else {
echo '<div class="col-md-12><p class="report alert alert-error"><a class="close">×</a><strong>Error</strong> ไม่สามารถเพิ่มข้อมูลได้</p></div>';
}
}
if (isset($GET_ID)) {
$res = CON::selectArrayDB(array(), "SELECT\n\t\tath_booking_order.ord_id,\n\t\tDATE(ath_booking_order.ord_date_start) AS date_start,\n\t\tDATE(ath_booking_order.ord_date_end) AS date_end,\n\t\tTIME(ath_booking_order.ord_date_start) AS time_start,\n\t\tTIME(ath_booking_order.ord_date_end) AS time_end,\n\t\tath_booking_order.ord_date_request,\n\t\tath_booking_order.ord_room_id,\n\t\tath_booking_order.ord_subject,\n\t\tath_booking_order.ord_person,\n\t\tath_booking_order.ord_person_amount,\n\t\tath_booking_order.ord_owner_name,\n\t\tath_booking_order.ord_owner_section,\n\t\tath_booking_order.ord_ps,\n\t\tath_booking_order.ord_status,\n\t\tath_booking_order.ord_user_id\n\t\tFROM\n\t\tath_booking_order\n\t\tWHERE " . TB_PREFIX . "booking_order.ord_id = " . $GET_ID);
// echo print_test($res);
$booking_date_start = $res[0]['date_start'];
$booking_date_end = $res[0]['date_start'];
$booking_time_start = $res[0]['time_start'];
$booking_time_end = $res[0]['time_end'];
$btn = 'warning';
$btt = lang_update;
$event = '<p class="alert alert-warning"><strong><i class="fa fa-edit"></i> ' . date('l j F Y', strtotime($booking_date_start)) . '</strong></p>';
} else {
$booking_date_start = $booking_date_end = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d', mktime(0, 0, 0, date("m"), date("d") + 1, date("Y")));
// $max = CON::selectArrayDB(array(), 'SELECT MAX(' . TB_PREFIX . 'booking_order.cm_da_number) AS max FROM ' . TB_PREFIX . 'booking_order WHERE ' . TB_PREFIX . 'booking_order.cm_da_number LIKE "'.$GET_NUMBER.'%"');
// $m = explode('/',$max[0]['max']);
// $lastID = $m[1]+1;
$btn = 'info';
$btt = lang_submit;
ord_id,
DATE(' . TB_PREFIX . 'booking_order.ord_date_start) as cDay,
TIME_FORMAT(' . TB_PREFIX . 'booking_order.ord_date_start,"%H:%i%p") as sTime,
TIME_FORMAT(' . TB_PREFIX . 'booking_order.ord_date_end,"%H:%i%p") as eTime,
ord_date_end,
ord_subject,
ord_person,
ord_room_id,
ord_status,
rm_name,
rm_color
FROM
' . TB_PREFIX . 'booking_order
INNER JOIN
' . TB_PREFIX . 'booking_room ON (' . TB_PREFIX . 'booking_order.ord_room_id = ' . TB_PREFIX . 'booking_room.rm_id)
ORDER BY
' . TB_PREFIX . 'booking_order.ord_date_start DESC';
$query = CON::selectArrayDB(array(), $arsql);
foreach ($query as $row) {
$approved = $row['ord_status'] == 0 ? '<a id="btn' . $row['ord_id'] . '" class="btn btn-success clickOFF approve tt" title="อนุมัติ" data-placement="left" data-id="' . $row['ord_id'] . '" data-act="apv" href="../admin-manage.php"><i class="fa fa-check"></i></a>' : '';
$data['data'][] = array('DT_RowId' => 'row' . $row['ord_id'], 'date' => thai_date($row['cDay'], 1, 0), 'time' => $row['sTime'] . ' - ' . $row['eTime'], 'subject' => '<a href="' . SITE_URL . '/v' . $row['ord_id'] . '/"
data-target="#BookDetail"
data-toggle="modal"
data-html="true"
data-placement="left"
class="detail tt"
title="รายละเอียด">
' . $row['ord_subject'] . '
</a>', 'name' => $row['rm_name'], 'person' => $row['ord_person'], 'status' => $status_array[$row['ord_status']], 'manage' => '<div class="btn-group btn-group-xs pull-right">' . $approved . '<a class="btn btn-warning tt" title="แก้ไข" data-placement="top" href="' . SITE_URL . '/booking/' . $row['ord_id'] . '/edit/"><i class="fa fa-edit"></i></a><a class="btn btn-danger clickOFF delete tt" title="ลบ" data-placement="right" data-id="' . $row['ord_id'] . '" data-act="delord" href="../admin-manage.php"><i class="fa fa-trash"></i></a></div>');
}
echo json_encode($data);
