$name = $row['name'];
$_ID = $row['id'];
$order++;
$mediaStatus = getDataDesc('status', 'tb_borrow_list', 'borrow_id=' . $borrow_id . ' AND media_id=' . $id);
$dateBorrow = getDataDesc('borrow_date', 'tb_borrow_list', 'borrow_id=' . $borrow_id . ' AND media_id=' . $id);
$dateReturnReal = '';
if (getDataDesc('return_date', 'tb_borrow_list', 'borrow_id=' . $borrow_id . ' AND media_id=' . $id) != '0000-00-00') {
$dateReturnReal = getDataDesc('return_date', 'tb_borrow_list', 'borrow_id=' . $borrow_id . ' AND media_id=' . $id);
}
$dateReturn = getAddDays($dateBorrow, $row['days_borrow']);
//หาวันที่ต้องคืน
$total = 0;
//เก็บค่าปรับเฉพาะสื่อ
if (strtotime(DATE) > strtotime($dateReturn)) {
//เปรียบเทียบวันถ้าคืนเกินเวลาให้ตำนวณค่าปรับ
$total = DiffDays($dateReturn, DATE) * $row['fine_per_day'];
//คิดค่าปรับตามระยะเวลาที่เกิน
$totalAmt = $totalAmt + $total;
}
// $classStatus = 'bg-warning';
$classStatus = $mediaStatus == 'ยืม' ? 'bg-warning' : 'bg-success';
$btn_cancel_return = '';
if ($mediaStatus == 'ยืม') {
$classStatus = 'bg-warning';
$strStaus = 'รอคืน';
} else {
$classStatus = 'bg-success';
$strStaus = 'คืนแล้ว';
$btn_cancel_return = "<a href='javascript:;' onclick='xx({$_ID});' class='btn btn-sm btn-danger'>ยกเลิกการคืน</a>";
}
// $check_media_id_null = getDataDesc('media_id', 'tb_booking_list', 'booking_id ='.$booking_id.' AND media_id ='.$mediaID);
public function Reservation()
{
$meetingroom_id = I("selectedMeetingroom");
$meetingroom_startHour = I("meetingroom_startHour");
$meetingroom_endHour = I("meetingroom_endHour");
$startHour = I("startHour");
$startMinute = I("startMinute");
$endHour = I("endHour");
$endMinute = I("endMinute");
$selectedDate = I("selectedDate");
$repeat_mode = I("repeat");
for ($i = $meetingroom_startHour * 60; $i < $meetingroom_endHour * 60; $i++) {
$meetingroom_time_axis[$i] = 0;
}
$meetingroom_record = M("meetingroom_record_table")->where("(meetingroomid={$meetingroom_id}) AND ((reservation_date={$selectedDate}) OR ( (reservation_date < {$selectedDate}) AND (repeat_mode != 0 )))")->select();
foreach ($meetingroom_record as $key => $record) {
if ($record["reservation_date"] < $selectedDate) {
$diffDays = DiffDays($record["reservation_date"], $selectedDate);
$repeat = $record["repeat_mode"];
if ($repeat == 2 && $diffDays % 7 != 0) {
continue;
} else {
if ($repeat == 3 && substr($record["reservation_date"], 6) != substr($selectedDate, 6)) {
continue;
} else {
if ($repeat == 4 && substr($record["reservation_date"], 4) != substr($selectedDate, 4)) {
continue;
}
}
}
}
for ($i = $record["startHour"] * 60 + $record["startMinute"]; $i < $record["endHour"] * 60 + $record["endMinute"]; $i++) {
$meetingroom_time_axis[$i] = 1;
}
}
$result["status"] = 1;
for ($i = $startHour * 60 + $startMinute; $i < $endHour * 60 + $endMinute; $i++) {
if ($meetingroom_time_axis[$i] == 1) {
$result["status"] = 0;
break;
}
}
$meetingroom_record_repeat = M("meetingroom_record_table")->where("(meetingroomid={$meetingroom_id}) AND (repeat_mode != 0 )")->select();
foreach ($meetingroom_record_repeat as $key => $record) {
$diffDays = DiffDays($record["reservation_date"], $selectedDate);
$repeat = $record["repeat_mode"];
if ($repeat == 1 && $repeat_mode >= 1) {
if (CheckReservationAvaliable($record["startHour"], $record["startMinute"], $record["endHour"], $record["endMinute"], $startHour, $endHour, $startMinute, $endMinute)) {
continue;
} else {
$result["status"] = 0;
break;
}
}
if ($repeat == 2 && $diffDays % 7 == 0 && $repeat_mode == 2) {
if (CheckReservationAvaliable($record["startHour"], $record["startMinute"], $record["endHour"], $record["endMinute"], $startHour, $endHour, $startMinute, $endMinute)) {
continue;
} else {
$result["status"] = 0;
break;
}
} else {
if ($repeat == 3 && $repeat_mode == 3 && substr($record["reservation_date"], 6) == substr($selectedDate, 6)) {
if (CheckReservationAvaliable($record["startHour"], $record["startMinute"], $record["endHour"], $record["endMinute"], $startHour, $endHour, $startMinute, $endMinute)) {
continue;
} else {
$result["status"] = 0;
break;
}
} else {
if ($repeat == 4 && $repeat_mode == 4 && substr($record["reservation_date"], 4) == substr($selectedDate, 4)) {
if (CheckReservationAvaliable($record["startHour"], $record["startMinute"], $record["endHour"], $record["endMinute"], $startHour, $endHour, $startMinute, $endMinute)) {
continue;
} else {
$result["status"] = 0;
break;
}
}
}
}
}
if ($result["status"]) {
$data["meetingroomid"] = $meetingroom_id;
$data["subscriberid"] = session("id");
$data["reservation_time"] = date("Y-m-d H:i", time());
$data["reservation_date"] = $selectedDate;
$data["startHour"] = $startHour;
$data["endHour"] = $endHour;
$data["startMinute"] = $startMinute;
$data["endMinute"] = $endMinute;
$data["repeat_mode"] = $repeat_mode;
if (M("meetingroom_record_table")->add($data)) {
$result["status"] = $meetingroom_id;
} else {
$result["status"] = -1;
}
$result["reservationStartTime"] = date("Y-m-d", strtotime($selectedDate)) . " {$startHour}:" . sprintf("%02d", $startMinute);
$result["reservationEndTime"] = date("Y-m-d", strtotime($selectedDate)) . " {$endHour}:" . sprintf("%02d", $endMinute);
$repeat_mode_table = array("0" => "不重复", "1" => "每日", "2" => "每周", "3" => "每月", "4" => "每年");
$result["repeat_mode"] = $repeat_mode_table[$repeat_mode];
}
echo json_encode($result);
}
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$classStatus = '';
$catID = getDataDesc('category_id', 'tb_media', 'id = ' . $row['media_id']);
$peopleID = getDataDesc('people_id', 'tb_borrow', 'id=' . $row['borrow_id']);
$dateBorrow = $row['borrow_date'];
$dateReturnReal = '';
$dateReturnReal = $row['return_date'];
$dateReturn = getAddDays($dateBorrow, getDataDesc('days_borrow', 'tb_media', 'id=' . $row['media_id']));
//หาวันที่ต้องคืน
$total = 0;
//เก็บค่าปรับเฉพาะสื่อ
if (strtotime($dateReturnReal) > strtotime($dateReturn)) {
//เปรียบเทียบวันถ้าคืนเกินเวลาให้ตำนวณค่าปรับ
$total = DiffDays($dateReturn, $dateReturnReal) * getDataDesc('fine_per_day', 'tb_media', 'id=' . $row['media_id']);
//คิดค่าปรับตามระยะเวลาที่เกิน
$totalAmt = $totalAmt + $total;
}
?>
<tr class="<?php
echo $classStatus;
?>
" >
<td class="center"><?php
echo $row['media_id'];
?>
</td>
<td class="center"><?php
echo getDataDesc('name', 'tb_category', 'id = ' . $catID);
