| 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"])){
$location_id = 1;
}else{
$location_id = (int)$_GET["location_id"];
}
update_master_room_total_number();
$mater_room_info = get_master_room(null, $location_id);
$locations = get_location();
if(!function_exists('sort_display_size_low_to_high')){
function sort_display_size_low_to_high($a, $b)
{
if ($a["display_size"] == $b["display_size"]) {
return 0;
}
return ($a["display_size"] < $b["display_size"]) ? -1 : 1;
}
}
uasort($mater_room_info, 'sort_display_size_low_to_high');
//default master room discount
/*foreach($mater_room_info as $mroom){
if($mroom["master_room_id"] <= 25){
continue;
}
$sql = "insert into master_room_discount set createby = ?, createdate = ?, lastupby = ?, lastupdate = ?, location_id = ?, payment_term = ?, discount_type = ?, discount = ?, effectivedate_from = ?, effectivedate_to = ?, master_room_id = ? ";
$parameters = array(1, $nowdate, 1, $nowdate, 1, "PREPAID_3-6MO", "%", 10, "2015-10-01", "2099-12-31", $mroom["master_room_id"]);
bind_pdo($sql, $parameters);
$sql = "insert into master_room_discount set createby = ?, createdate = ?, lastupby = ?, lastupdate = ?, location_id = ?, payment_term = ?, discount_type = ?, discount = ?, effectivedate_from = ?, effectivedate_to = ?, master_room_id = ? ";
$parameters = array(1, $nowdate, 1, $nowdate, 1, "PREPAID_7-12MO", "%", 20, "2015-10-01", "2099-12-31", $mroom["master_room_id"]);
bind_pdo($sql, $parameters);
}*/
/*$sql = "insert into master_room_discount set createby = ?, createdate = ?, lastupby = ?, lastupdate = ?, location_id = ?, payment_term = ?, discount_type = ?, discount = ?, effectivedate_from = ?, effectivedate_to = ?";
$parameters = array(1, $nowdate, 1, $nowdate, 1, "", "MO", 1, "2015-10-01", "2099-12-31");
bind_pdo($sql, $parameters);*/
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once('html_head.php'); ?>
<script type="text/javascript">
function DeleteRow(master_room_id) {
if (confirm("你確定要刪除?")) {
window.location.href = 'master_room_delete.php?master_room_id=' + master_room_id;
}
}
</script>
</head>
<body>
<table width="1000" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("menu.php"); ?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td width="800" align="left" valign="top">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<!--<a href="master_room_addform.php"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0"/><br/> 新增
</a>--></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 height="25" align="left" valign="middle">
樓層:
<select name="location_id" style="margin-bottom: 10px;" onchange="location.href='master_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>
</td>
</tr>
<tr>
<td align="left" valign="middle">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<!--<td width="100" class="listtitletxt">尺寸</td>-->
<td width="120" class="listtitletxt">樓層</td>
<!--<td width="100" class="listtitletxt">前台顯示尺寸</td>-->
<td width="100" class="listtitletxt">尺寸</td>
<td width="100" class="listtitletxt">價錢</td>
<td width="100" class="listtitletxt">可網上預訂?</td>
<td width="100" class="listtitletxt">預留單位</td>
<td width="100" class="listtitletxt">單位總數</td>
<td width="100" class="listtitletxt">最近更新</td>
<td width="20" class="listtitletxt"></td>
<!--<td width="20" class="listtitletxt"></td>-->
</tr>
<?php
foreach ($mater_room_info as $master_room) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
//print "<td class='listtxt' style='padding-left:5'>" ."[".$master_room["id"]."] ". $master_room{'length'}." X ". $master_room{'width'}." X ".$master_room{'height'}. "</td>";
/*print "<td class='listtxt' style='padding-left:5'>". $master_room{'length'}." X ". $master_room{'width'}." X ".$master_room{'height'}. "</td>";*/
foreach ($locations as $location){
if($master_room["location_id"]==$location["location_id"]){
print "<td class='listtxt' style='padding-left:5'>". $location["location_code"]." ".$location["location_name_tc"]. "</td>";
break;
}
}
print "<td class='listtxt' style='padding-left:5'>". $master_room["display_size"]. "</td>";
if($master_room{'retail_price'} == $master_room{'discounted_price'}){
print "<td class='listtxt' style='padding-left:5'>$" . numberformat($master_room{'retail_price'}) . "</td>";
}else{
print "<td class='listtxt' style='padding-left:5'>$" . $master_room{'discounted_price'} . " <del>$".numberformat($master_room{'retail_price'})."</del></td>";
}
if($master_room["is_onlinesales"] == 1){
print "<td class='listtxt' style='padding-left:5'>可以</td>";
print "<td class='listtxt' style='padding-left:5'>".$master_room{'remain_room'}."</td>";
}else{
print "<td class='listtxt' style='padding-left:5'>不可以</td>";
print "<td class='listtxt' style='padding-left:5'>0</td>";
}
print "<td class='listtxt' style='padding-left:5'>".$master_room{'total_room'}."</td>";
print "<td class='listtxt' style='padding-left:5'>" . $master_room{'master_room_lastupdate'} . "</td>";
//Status
/*print "<td class='listtxt' align='center'>";
if ($master_room{'master_room_status'} == 1) // Enable
{
print "<a href='master_room_status.php?master_room_id=" . $master_room{'master_room_id'} . "'>";
print "<img src='images/tick.png' title='Enable' alt='Enable' border='0' hspace='2'></a>";
} else // Disable
{
print "<a href='master_room_status.php?master_room_id=" . $master_room{'master_room_id'} . "'>";
print "<img src='images/cross.png' title='Disable' alt='Disable' border='0' hspace='2'></a>";
}
print "</td>";*/
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='master_room_modifyform.php?id=" . $master_room{'master_room_id'} . "&location_id=".$location_id."'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
//check if this master room has been applied or not
/*$sql = "select * from room where master_room_id = ? and deleted = 0 ";
$parameters = array($master_room{'master_room_id'});
$room_info = bind_pdo($sql, $parameters, "selectall");
if(!empty($room_info)){
print "<td class='listtxt' align='center'></td>";
}else{
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 "</tr>";
}
$dbh = null;
?>
</table>
<br><br><br><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>