📄 rpt_stock_actual.php
字号:
<?
include("../application.php");
$username=$SESSION["user"]["user_name"];
$site_id=$SESSION["user"]["site_id"];
include("rptheader.php");
$sql_list="SELECT stock_detail.stock_id,stock_detail.site_id,stock_product.group_id, stock_detail.product_id,stock_product.color,SUM(if(stock_detail.op_date<='$op_date',concat(stock_detail.type , stock_detail.qty),0)) as last_qty,stock_product.model FROM stock_detail ,stock_product_group,stock_product WHERE stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=stock_detail.product_id AND stock_detail.log_status='1' AND stock_detail.site_id='$site_id' AND stock_detail.op_date<='$op_date' AND stock_product.group_id='$group_id' ";
if($product_id<>"")$sql_list.=" AND stock_detail.product_id='$product_id'";
$sql_list.=" GROUP BY stock_product.product_id";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="3" height="35"><font size="+2">Hitachi Transport System (Thailand ) Co.,Ltd.</font></td>
</tr>
<tr bgcolor="#ffffff">
<td valign ="top" align ="left" class="txtThai" colspan="2">SITE INFOMATION : <?echo site_info($site_id);?></td>
<td align ="right" class="txtThai" height='20'>User Print : <?echo $username;?></td>
</tr>
<tr bgcolor="#ffffff">
<td valign ="top" align ="left" class="txtThai" colspan="2">PRODUCT GROUP : <?echo $group_id;?></td>
<td align ="right" class="txtThai" height='20'>Date Print : <?echo date('y-m-d');?></td>
</tr>
<tr bgcolor="#ffffff">
<td valign ="top" align ="left" class="txtThai">STOCK CHECK REPORT (ACTUAL)</td>
<td valign ="top" align ="left" class="txtThai">DATE CHECK : <?echo $op_date;?></td>
<td align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:m:d');?></td>
</tr>
</table>
<br>
<table border="1" bgcolor="#ffffff" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000">
<tr >
<td align="center" width="5%" class="txtThai" rowspan="2">Item</td>
<td align="center" valign="middle" class="txtThai" rowspan="2">Part</td>
<td align="center" valign="middle" class="txtThai" rowspan="2">Model</td>
<td align="center" valign="middle" class="txtThai" rowspan="2" width="8%"><font color="#000000">B/L</font>
</td>
<?
$adj_diff=""; // 淝槭铀醚亨$氦枰 stock diff
$old_val="";//淝榇帧㈤土倥 diff 啻粤
$xcount=0; // よ曳砧琳∫没橥耿橥临培丛
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -