webadmin.php

/var/www/hkosl.com/innoutstorage2019/webadmin/room_index.php

<?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.zone ASC, room.code 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'} . "'" ? " &nbsp;&nbsp;&nbsp;(" . $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 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);\">' + "&nbsp;&nbsp;&nbsp;" + 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");
                }
            });

            <?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>
                                        &nbsp;取消&nbsp;&nbsp;</a></td>
                                <td>&nbsp;</td>
                            </tr>
                        </table>
                    </td>
                </tr>

                <tr>
                    <td class="pagetitletxt">
                        &nbsp;&nbsp;<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: 1360px; 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++;

                                        print "<tr id='" . $room["room_code"] . "'>";
                                        print "<td class='listtxt' style='padding-left:5px;'>&nbsp;</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='" . $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'} . "'" ? " &nbsp;&nbsp;&nbsp;(" . $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>