| 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"); ?>
<?php require_once("head.php"); ?>
<!-- Main Menu -->
<link rel="stylesheet" type="text/css" href="css/menu.css"/>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script type="text/javascript" src="js/menuddaccordion.js"></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">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> Product
Sorting (All Product) </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">
<form name="form1" method="post" action="product_detail_show_index_sort_update.php">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="40" class="listtitletxt">Sort</td>
<td width="60" class="listtitletxt">Code</td>
<td width="400" class="listtitletxt">Product Name</td>
</tr>
<?php
$sql2 = "SELECT * FROM pro_product pd INNER JOIN pro_product_category pdc ON pd.productid = pdc.productid WHERE pd.deleted = ? and pd.old_record = ? group by pdc.productid ORDER BY pd.all_product_sort ASC ";
$parameters2 = array("0", "0");
$row_array = bind_pdo($sql2, $parameters2, "selectall");
if (count($row_array) < 0) {
exit;
}
foreach ($row_array as $row) {
$sql3 = "select * from pro_product_sku where deleted = ? and old_record = ? and productid = ?";
$parameters3 = array("0", "0", $row{'productid'} );
$row3_array = bind_pdo($sql3, $parameters3, "selectall");
$cntsku = count($row3_array);
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' valign='middle' align='left'><input class='sortinput' type='text' name='idarraynumber[]' value='" . $row{'all_product_sort'} . "' size='2' /><input type='hidden' name='idarray[]' value='" . $row{'productid'} . "'></td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'productitemcode'} . "</td>";
if(!empty($row{'productname_tc'})){
print "<td class='listtxt' style='padding-left:5'><a href='product_sku_index.php?categoryid=".$row{'categoryid'}."&productid=".$row{'productid'}."'>" . $row{'productname_tc'} . "</a> (Total SKU: ".$cntsku.")</td>";
}else{
print "<td class='listtxt' style='padding-left:5'></td>";
}
print "</tr>";
} //End while product
$dbh = null;
?>
</table>
<input type="submit" value="Update Sort">
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>