| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/innoutstorage/webadmin/ |
Upload File : |
<?php
require_once('check_login.php');
if (empty($_GET["location_id"])) {
header("Location: room_index.php?location_id=1");
exit;
} else {
$location_id = (int)$_GET["location_id"];
}
update_master_room_total_number();
check_and_update_reserved_room();
if (!isset($_GET["filter1"]) && !isset($_GET["filter2"]) && !isset($_GET["all"])) {
$room_info = array();
} else {
$filter_sql = "";
$parameters = array($location_id);
if (isset($_GET["all"]) && (int)$_GET["all"] == 1) {
$filter_sql = "";
//$parameters = NULL;
} else {
if (isset($_GET["filter1"]) && isset($_GET["filter2"])) {
/*if($_GET["filter1"] == 0){ //typeid
$filter_sql = "and room.typeid = ?";
}*/
if ($_GET["filter1"] == 0) { //master_room code
$filter_sql = "and master_room.id = ?";
}
if ($_GET["filter1"] == 1) { //room status
$filter_sql = "and room.status = ?";
}
if ($_GET["filter1"] == 2) { //room status
$filter_sql = "and room.zone = ?";
}
$parameters[] = ($_GET["filter2"]);
//for reserved only
if (isset($_GET["filter3"])) {
if (is_numeric($_GET["filter3"])) {
$filter_sql .= " and reserve_by_tel = ?";
$parameters[] = $_GET["filter3"];
} else {
//do nothing
}
}
}
}
$sql = "select *, room.id as room_id, room.code as room_code, room.status as room_status,room.master_room_id from room room INNER JOIN master_room master_room ON room.master_room_id = master_room.id where room.deleted = 0 and room.location_id = ? " . $filter_sql . " order by room.code ASC, room.zone ASC";
$room_info = bind_pdo($sql, $parameters, "selectall");
}
//$filter_typeid = "";
$filter_master_room = "";
$filter_status = "";
$filter_zone = "";
$status_info = get_master_type_code("ROOM_STATUS");
$location_info = get_location();
$locations = $location_info;
//$typeid_info = get_master_type_code("ROOM_TYPE");
$master_room_info = get_master_room(null, $location_id);
$zone_info = get_master_type_code("ZONE", null, $location_id);
/*foreach ($typeid_info as $key => $typeid) {
$filter_typeid[$key][0] = $typeid["code"];
$filter_typeid[$key][1] = $typeid["name_tc"];
}*/
foreach ($master_room_info as $key => $master_room) {
$filter_master_room[$key][0] = $master_room["id"];
$filter_master_room[$key][1] = $master_room{'length'} . " X " . $master_room{'width'} . " X " . $master_room{'height'} . ($master_room{"display_size"} != $master_room{'length'} . "' x " . $master_room{'width'} . "' x " . $master_room{'height'} . "'" ? " (" . $master_room{"display_size"} . ")" : "");
}
foreach ($status_info as $key => $status) {
$filter_status[$key][0] = $status["code"];
$filter_status[$key][1] = $status["name_tc"];
}
foreach ($zone_info as $key => $zone) {
$filter_zone[$key][0] = $zone["code"];
$filter_zone[$key][1] = $zone["code"];
}
/*$filter1_info = array("類別", "尺寸編號", "狀態");
$filter2_info = array(0 => $filter_typeid, 1 => $filter_master_room, 2 => $filter_status);*/
$filter1_info = array("尺寸", "狀態", "區域");
$filter2_info = array(0 => $filter_master_room, 1 => $filter_status, 2 => $filter_zone);
//var_dump($filter2_info);
//for reserved
$sql = "select * from room where status = ? and deleted = ? and location_id = ? order by reserve_by_tel ASC";
$parameters = array("RESERVED", 0, $location_id);
$reserved_room_info = bind_pdo($sql, $parameters, "selectall");
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once('html_head.php'); ?>
<script type="text/javascript" src="js/chosen_v1.4.1/chosen.jquery.min.js"></script>
<link rel="stylesheet" href="js/chosen_v1.4.1/chosen.min.css">
<script type="text/javascript" src="js/jquery.chained.js"></script>
<script type="text/javascript">
$(function () {
var selected_room_num = 0;
$("#filter2").chained("#filter1");
$(".room_id").on("click", function () {
selected_room_num = 0;
$(".room_id").each(function () {
if ($(this).prop("checked")) {
selected_room_num++;
}
});
if (selected_room_num > 0) {
$("#update_btn").show();
} else {
$("#update_btn").hide();
}
});
});
function DeleteRow(room_id) {
if (confirm("你確定要刪除?")) {
window.location.href = 'room_delete.php?room_id=' + room_id;
}
}
function filter() {
var filter1 = $("select[name='filter1']").val();
var filter2 = $("select[name='filter2']").val();
if (filter1 != "" && filter2 != "") {
if (filter2 == "RESERVED") {
var filter3 = $("select[name='filter3']").val();
if (filter2 != "") {
window.location.href = 'room_index.php?filter1=' + filter1 + '&filter2=' + filter2 + '&filter3=' + filter3;
} else {
alert("請輸入預約人聯絡電話。");
}
} else {
window.location.href = 'room_index.php?location_id=<?=$location_id?>&filter1=' + filter1 + '&filter2=' + filter2;
}
} else {
alert("請選擇篩選方式。");
}
}
function check_checkbox(room_tr) {
$(room_tr).find(".room_id").prop("checked", true);
$("#update_btn").show();
}
function update_room(room_code) {
var master_room_id = $("#" + room_code + " .master_room_id").val();
var room_status = $("#" + room_code + " .room_status").val();
var room_id = $("#" + room_code + " .room_id").val();
var xmlhttp;
if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
}
else {// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var result = $.trim(xmlhttp.responseText);
alert(result);
}
}
xmlhttp.open("POST", "_ajax.php?for=update_room", true);
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
//xmlhttp.send("selected_room_id_list=" + selected_room_id_list + "&prepaid_month=" + prepaid_month);
xmlhttp.send("room_code=" + room_code + "&room_id=" + room_id + "&master_room_id=" + master_room_id + "&room_status=" + room_status);
}
function check_room_contract(room_code) {
var master_room_id = $("#" + room_code + " .master_room_id").val();
var room_status = $("#" + room_code + " .room_status").val();
var room_id = $("#" + room_code + " .room_id").val();
var xmlhttp;
if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
}
else {// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var result = $.trim(xmlhttp.responseText);
if(result){
alert(result);
}
}
}
xmlhttp.open("POST", "_ajax.php?for=check_room_contract", true);
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
//xmlhttp.send("selected_room_id_list=" + selected_room_id_list + "&prepaid_month=" + prepaid_month);
xmlhttp.send("room_code=" + room_code + "&room_id=" + room_id + "&master_room_id=" + master_room_id + "&room_status=" + room_status);
}
function ajax_floor_plan_rent_room(go_to_warehousing, room_id, master_room_id, room_code) {
var xmlhttp;
if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
}
else {// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var result = $.trim(xmlhttp.responseText);
//console.log(result);
if (result == "success" && go_to_warehousing != 1) {
//alert("你已將這個倉庫單位加入租用列表，你可前往租倉程序或加入更多的倉庫單位。");
$(".go_to_warehousing").show();
//modify for room index
if ($("#" + room_id).length <= 0) {
$(".rent_current_room").after('<span class="cancel_room" id="' + room_id + '" onclick=\"ajax_delete_rent_room(this.id);\">' + " " + room_code + " [刪除]" + '</span>');
}
}
if (go_to_warehousing == 1) {
window.top.location.href = 'warehousing_step1.php';
}
}
}
xmlhttp.open("POST", "_ajax.php?for=floor_plan_rent_room", true);
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.send("go_to_warehousing=" + go_to_warehousing + "&room_id=" + room_id + "&master_room_id=" + master_room_id + "&room_code=" + room_code);
}
function ajax_delete_rent_room(room_id) {
var xmlhttp;
if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
}
else {// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var result = $.trim(xmlhttp.responseText);
alert("你已將這個倉庫單位從租用列表中刪除。");
$(".cancel_room").each(function () {
if ($(this).attr("id") == room_id) {
if ($(this).hasClass("rent_current_room")) {
$(this).empty();
} else {
$(this).remove();
}
}
});
}
}
xmlhttp.open("POST", "_ajax.php?for=floor_plan_delete_room", true);
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.send("room_id=" + room_id);
}
$(function () {
$(".cancel_room").on("click", function () {
ajax_delete_rent_room(this.id);
});
$("#filter3").chosen({width: "160px", search_contains: true});
$("#filter3_chosen").css("display", "none");
$("#filter2").on("change", function () {
if ($(this).val() == "RESERVED") {
$("#filter3_chosen").css("display", "inline-block");
} else {
$("#filter3_chosen").css("display", "none");
}
});
$('.room_status').on('change', function () {
var room_code = $(this).closest("tr").attr("id");
console.log(room_code);
check_room_contract(room_code);
});
<?php
if (isset($_GET["filter3"])) {
echo '$("#filter3_chosen").css("display", "inline-block");';
}
?>
});
</script>
</head>
<body>
<table height="600" border="0" cellpadding="0" cellspacing="0" style="margin-left: 15px;">
<tr>
<td align="left" valign="top">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="right" valign="middle" class="icontxt">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50" align="center">
<a href="index.php"><img src="images/iconCancel.png" alt="Cancel" width="32" height="32" border="0"><br>
取消 </a></td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/>
倉庫管理設定(單位) </b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (!empty($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<div class="floor_plan" style="display: none;">
<div id="loading" style="text-align: center;">
<img src="images/loading_icon.gif" style="width: 100px;"></div>
<iframe id="floor_plan_iframe" src="" style="width: 1800px; height: 660px; margin-bottom: 30px;" onload="$('#loading').hide();"></iframe>
</div>
</td>
</tr>
<tr>
<td align="left" valign="middle" style="padding-bottom: 50px;">
<div>篩選:
<select name="location_id" style="margin-bottom: 10px;" onChange="location.href='room_index.php?location_id='+this.value;">
<?php
foreach ($locations as $location) {
echo "<option value='" . $location["location_id"] . "' " . ($location_id == $location["location_id"] ? "selected" : "") . ">" . $location["location_code"] . " " . $location["location_name_tc"] . "</option>";
}
?>
</select>
<select name="filter1" id="filter1">
<option value="">---請選擇---</option>
<?php
foreach ($filter1_info as $key => $filter1) {
if (isset($_GET["filter1"]))
$selected = matched_option($key, $_GET["filter1"], "select");
else
$selected = "";
echo '<option value="' . $key . '" ' . $selected . '>' . $filter1 . '</option>';
}
?>
</select>
<select name="filter2" id="filter2">
<option value="">---請選擇---</option>
<?php
foreach ($filter2_info as $key => $filter2) {
foreach ($filter2 as $data) {
if (isset($_GET["filter2"]))
$selected = matched_option($data[0], $_GET["filter2"], "select");
else
$selected = "";
echo '<option value="' . $data[0] . '" ' . $selected . ' class="' . $key . '">' . $data[1] . '</option>';
}
}
?>
</select>
<select name="filter3" id="filter3" style="display: none;">
<option value="">---請選擇聯絡電話---</option>
<option value="ALL" <?php if (isset($_GET["filter3"]) && $_GET["filter3"] == "ALL") echo "selected"; ?>>
所有
</option>
<?php
if (!empty($reserved_room_info)) {
foreach ($reserved_room_info as $key => $reserved_room) {
if (isset($_GET["filter3"]))
$selected = matched_option($reserved_room["reserve_by_tel"], $_GET["filter3"], "select");
else
$selected = "";
echo '<option value="' . $reserved_room["reserve_by_tel"] . '" ' . $selected . ' >' . $reserved_room["reserve_by_tel"] . '</option>';
}
}
?>
</select>
<button type="button" onClick="filter();">送出</button>
<button type="button" onClick="window.location.href='room_index.php?location_id=<?= $location_id ?>&all=1';" style="margin-left: 15px;">
全部單位
</button>
<button type="button" onClick="$('.floor_plan').slideToggle(); $('#loading').show(); $('iframe').attr('src', 'floor_plan.php?location_id=<?= $location_id ?>')" style="margin-left: 15px;">
顯示倉庫平面圖
</button>
</div>
<br>
<form action="room_modify.php" method="post" enctype="multipart/form-data" id="room_modify">
<input type="hidden" name="last_url_parameter" value="<?= $_SERVER['QUERY_STRING']; ?>"/>
<table id="room_index" width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="80" class="listtitletxt">單位編號</td>
<!--<td width="150" class="listtitletxt">類別</td>-->
<td width="120" class="listtitletxt">尺寸</td>
<td width="100" class="listtitletxt">狀態</td>
<td width="50" class="listtitletxt">區域</td>
<td width="200" class="listtitletxt">其他資料</td>
<td width="80" class="listtitletxt"></td>
</tr>
<?php
$i = 0;
foreach ($room_info as $key => $room) {
$i++;
$rm_code = $room["room_code"];
//echo '<script>console.log($room["room_code"])</script>';
print "<tr id='" . $room["room_code"] . "'>";
print "<td class='listtxt' style='padding-left:5px;'> </td>";
print "<td class='listtxt' style='padding-left:5px;'>" . $i . ".</td>";
print "<td class='listtxt' style='padding-left:5px;'><input type='checkbox' name='room_id[" . $key . "]' value='" . $room["room_id"] . "' class='room_id'></td>";
//2019-04-24 如租的倉是 "服裝倉"，於所有合約/單上顯示倉的編號後加上 "(服裝倉)"
$master_room = get_master_room($room['master_room_id']);
if($master_room['type'] == 'CLOTH'){
$room{'room_code'} .= "(服裝倉)";
}
print "<td class='listtxt' style='padding-left:5px;'>" . $room{'room_code'} . "<input type='hidden' name='code[" . $key . "]' value='" . $rm_code . "' /></td>";
//print "<td class='listtxt' style='padding-left:5px;'>" . $room{'room_code'} . "<input type='hidden' name='code[" . $key . "]' value='" . $room["room_code"] . "' /></td>";
//print "<td class='listtxt' style='padding-left:5px;'><input type='text' name='code[".$key."]' value='" . $room["room_code"] . "' onchange='check_checkbox($(this).closest(\"tr\"))'/></td>";
/*print "<td class='listtxt' style='padding-left:5px;'><select name='typeid[".$key."]' >";
foreach ($typeid_info as $typeid) {
print "<option value='" . $typeid["code"] . "' " . matched_option($typeid["code"], $room["typeid"], "select") . ">" . $typeid["name_tc"] . "</option>";
}
print "</select></td>";*/
print "<td class='listtxt' style='padding-left:5px;'><select class='master_room_id' name='master_room_id[" . $key . "]' onchange='check_checkbox($(this).closest(\"tr\"))'>";
foreach ($master_room_info as $master_room) {
print "<option value='" . $master_room["id"] . "' " . matched_option($master_room["id"], $room["master_room_id"], "select") . "> " . $master_room{'length'} . " X " . $master_room{'width'} . " X " . $master_room{'height'} . ($master_room{"display_size"} != $master_room{'length'} . "' x " . $master_room{'width'} . "' x " . $master_room{'height'} . "'" ? " (" . $master_room{"display_size"} . ")" : "") . "</option>";
//print "<option value='" . $master_room["id"] . "' " . matched_option($master_room["id"], $room["master_room_id"], "select") . "> " .$master_room{"display_size"}."</option>";
//print "<option value='" . $master_room["id"] . "' " . matched_option($master_room["id"], $room["master_room_id"], "select") . "> " .$master_room{'length'} . " X " . $master_room{'width'} . " X " . $master_room{'height'}."</option>";
}
print "</select></td>";
print "<td class='listtxt' style='padding-left:5px;'><select class='room_status' name='room_status[" . $key . "]' onchange='check_checkbox($(this).closest(\"tr\"))'>";
foreach ($status_info as $status) {
print "<option value='" . $status["code"] . "' " . matched_option($status["code"], $room["room_status"], "select") . " " . ($status["code"] == "OPEN_FOR_INTERNAL" ? "disabled" : "") . ">" . $status["name_tc"] . "</option>";
}
print "</select></td>";
/*print "<td class='listtxt' style='padding-left:5px;'><select name='zone[".$key."]' onchange='check_checkbox($(this).closest(\"tr\"))'>";
$zone_array = array("A", "B", "C", "D", "E", "F", "G");
foreach ($zone_array as $zone) {
print "<option value='" . $zone . "' " . matched_option($zone, $room["zone"], "select") . ">" . $zone . "</option>";
}
print "</select></td>";*/
// Delete
//print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRow(" . $master_room{'master_room_id'} . ")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "<td class='listtxt' style='padding-left:5px;'>" . $room["zone"] . "<input type='hidden' name='zone[" . $key . "]' value='" . $room["zone"] . "'></td>";
print "<td class='listtxt' style='padding-left:5px;'>";
if ($room["room_status"] == "RESERVED") {
echo "預約人 : " . $room["reserve_by_name"] . "<br>";
echo "聯絡電話 : " . $room["reserve_by_tel"] . "<br>";
echo "聯絡電郵 : " . $room["reserve_by_email"] . "<br>";
echo "預約期 : " . $room["reservedate_from"] . " 到 " . $room["reservedate_to"] . "<br><br>";
echo '<button type="button" onclick="ajax_floor_plan_rent_room(0, ' . $room["room_id"] . ',' . $room["master_room_id"] . ',\'' . $room["room_code"] . '\');" style="font-size:12px;">立即租用</button>';
if (isset($_SESSION["floor_plan_rent_room"])) {
$display = "block";
} else {
$display = "none";
}
echo '<div class="go_to_warehousing" style="display: ' . $display . '"><br>
<div>已選擇單位： ';
$room_list = "";
if (!empty($_SESSION["floor_plan_rent_room"])) {
foreach ($_SESSION["floor_plan_rent_room"] as $rent_room) {
$room_list .= "<span class='cancel_room " . $rent_room["room_id"] . "' id='" . $rent_room["room_id"] . "'>" . $rent_room["room_code"] . " [刪除], </span>";
}
$room_list = substr_replace($room_list, "", -9, 1);
echo $room_list;
}
echo '<span class="cancel_room rent_current_room" ></span></div>
<br>
<div onclick="ajax_floor_plan_rent_room(1, ' . $room["room_id"] . ',' . $room["master_room_id"] . ',\'' . $room["room_code"] . '\');" style="text-decoration: underline; cursor: pointer;">前往租倉程序
</div>';
}
print "</td>";
print "<td class='listtxt' style='padding-left:5px;'><button type='button' onclick='update_room($(this).closest(\"tr\").attr(\"id\"));'>更新</button></td>";
print "</tr>";
}
print "<tr id='update_btn' style='display: none;'><td></td><td class='listtxt' style='padding-left:5px;' colspan='5'><button type='button' id='room_modify_submit_btn' >更新</button></td></tr>";
$dbh = null;
?>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
<script type="text/javascript">
$(function () {
$("#room_modify_submit_btn").on("click", function () {
$(".room_id").each(function (index, element) {
if (!$(element).prop("checked")) {
//disable it
$(element).parent().parent().find("input").attr("disabled", true);
$(element).parent().parent().find("select").attr("disabled", true);
}
});
$("#room_modify").submit();
});
});
</script>
</body>
</html>