📄 rpt_stock_list2.php
字号:
<?
include("../application.php");
$work_type=$SESSION["user"]["work_type"];
$unit_set=$SESSION["user"]["unit_set"];
$data_style=$SESSION["user"]["data_style"];
include("rptheader.php");
?>
<!-- <DIV class=outerframe> -->
<table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#ffffff" bgcolor="#ffffff" >
<THEAD>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="3"><font size='+2'>Hitachi Transport System (Thailand ) Co.,Ltd.</font><br></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2">REPORT STOCK List (DL)</td>
<td align ="right" class="txtThai" height='20'>Date Print : <?echo date('y-m-d');?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2">CUSTOMER : <?echo site_info($site_id);?></td>
<td align ="right" class="txtThai" height='20'>Time Print : <?echo date('H:i:s');?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="1">Group Product : <?echo $group_id;?></td>
<td align ="center" class="txtThai" colspan="1">From : <b><?echo $op_date;?></b> To <b><?echo $to_date;?></b></td>
</tr>
</THEAD>
</table>
<!-- </DIV> -->
<br>
<table border="0" bgcolor="#ffffff" bordercolor="#000000" cellspacing="0" cellpadding="1" width="100%">
<?
echo "<DIV class=innerframe>";
$sql_list="SELECT ".$data_style."stock_detail.lot_number,".$data_style."stock_detail.type as type_io,".$data_style."stock_detail.head_id,".$data_style."stock_detail.op_date,".$data_style."stock_detail.date_ref as ref_date,".$data_style."stock_detail.head_id,".$data_style."stock_detail.product_id,".$data_style."stock_detail.doc_type,".$data_style."stock_detail.qty,stock_product.model,stock_product.color FROM stock_product,".$data_style."stock_detail WHERE stock_product.product_id=".$data_style."stock_detail.product_id AND ".$data_style."stock_detail.log_status='1' AND ".$data_style."stock_detail.op_date>='$op_date' AND ".$data_style."stock_detail.op_date<='$to_date' AND stock_product.work_type='$work_type'";
if($group_id<>"")$sql_list.=" AND stock_product.group_id='$group_id'";
if($pro_id<>""){
$pro_id=str_replace("\\","",$pro_id);
$sql_list.=" AND ".$data_style."stock_detail.product_id IN('$pro_id')";
}
$sql_list.=" ORDER BY ".$data_style."stock_detail.product_id,".$data_style."stock_detail.op_date";
//echo $sql_list;
$no_pro="";
$qid = db_query($sql_list);
$bf_qty=0;
$product_id="";
$row=0;
while ($r = db_fetch_object($qid)) {
if($product_id<>$r->product_id){
$no_pro.=",'$r->product_id'";
$row=0;
echo "<tr bgcolor='#ffffff'>";
echo "<td align='left' class='txtThai' colspan='10' ><br><b><font color='#000000'> $r->product_id</font> ";
echo " $r->model $r->color </b></td>";
echo "</tr>";
echo "<tr><td colspan='10' ><hr color='#000000' size='1'></td></tr>";
echo "<tr>";
echo "<td align='center' width='5%' class='txtThai' >Item</td>";
echo "<td align='center' valign='middle' class='txtThai' ><font color='#000000'>Date OUT </font>";
echo "</td> ";
echo "<td align='center' valign='middle' class='txtThai' ><font color='#000000'>Date IN</font>";
echo "</td> ";
echo "<td align='right' valign='middle' class='txtThai' width='80' ><font color='#000000'>LotNumber</font>";
echo "</td>";
echo "<td align='right' valign='middle' class='txtThai' width='80' ><font color='#000000'>Stock IN</font>";
echo "</td> ";
echo "<td align='right' valign='middle' class='txtThai' width='80' ><font color='#000000'>Stock OUT</font> ";
echo "</td> ";
echo " <td align='right' valign='middle' class='txtThai' width='80' ><font color='#000000'>Balance</font></td> ";
echo "<td align='left' valign='middle' class='txtThai' > <font color='#000000'>Remark</font></td> ";
echo "</tr>";
echo "<tr><td colspan='10' ><hr color='#000000' size='1'></td></tr>";
$sql_bal="SELECT SUM(if(".$data_style."stock_detail.op_date<'$op_date',concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty),0)) as last_qty FROM ".$data_style."stock_detail WHERE ".$data_style."stock_detail.product_id='$r->product_id' AND ".$data_style."stock_detail.log_status='1' AND ".$data_style."stock_detail.site_id='$site_id' AND ".$data_style."stock_detail.op_date<'$op_date' GROUP BY ".$data_style."stock_detail.product_id";
$xqid=db_query($sql_bal);
//echo $sql_bal;
$frm=db_fetch_array($xqid);
echo "<tr bgcolor='#ffffff'>";
echo "<td align='center' class='txtThai'></td> ";
echo "<td align='right' class='txtThai' valign='middle' width='80'> </td>";
echo "<td align='right' class='txtThai' valign='middle'> </td>";
echo "<td align='right' class='txtThai' valign='middle'> </td>";
echo "<td align='right' class='txtThai' valign='middle'> </td>";
echo "<td align='right' class='txtThai' valign='middle'> </td>";
echo "<td align='right' class='txtThai' valign='middle'>".number_format($frm["last_qty"],$unit_set,'.',',')." </td>";
echo "<td align='left' class='txtThai' ><font color='#000000'> BALNCE BEGINING</font></td> ";
echo "</tr>";
$bf_qty=$frm["last_qty"];
}
$row++
?>
<tr bgcolor="#ffffff">
<td align="center" style="border-color:#ffffff;border-width:0pt" class='txtThai' ><?echo $row;?> </td>
<td align="center" class="txtThai" valign="middle" width="80"><?if($r->ref_date<>"0000-00-00")echo $r->ref_date;?> </td>
<td align="center" class="txtThai" valign="middle" ><?echo $r->op_date;?> </td>
<td align="center" class="txtThai" valign="middle" ><?echo $r->lot_number;?> </td>
<td align="right" class="txtThai" valign="middle" style="border-color:#ffffff;border-width:0pt"><?if($r->type_io=="+"){$bf_qty+=$r->qty;echo number_format($r->qty,$unit_set,'.',',');}?> </td>
<td align="right" class="txtThai" valign="middle" style="border-color:#ffffff;border-width:0pt"><?if($r->type_io=="-"){$bf_qty-=$r->qty;echo number_format($r->qty,$unit_set,'.',',');}?> </td>
<td align="right" class="txtThai" valign="middle" ><?echo number_format($bf_qty,$unit_set,'.',',');?> </td>
<td align="left" class="txtThai" > <font color="#000000"> <?echo get_document($r->head_id,$r->type_io,$data_style);?></font></td>
</tr>
<?
$product_id=$r->product_id;
}
//echo $no_pro;
/* Stock non movement Process*/
$sql_bal="SELECT SUM(concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty)) as bf_qty,stock_product.product_id ,stock_product.model,stock_product.color FROM ".$data_style."stock_detail,stock_product WHERE stock_product.product_id=".$data_style."stock_detail.product_id AND ".$data_style."stock_detail.log_status='1' AND ".$data_style."stock_detail.site_id='$site_id' AND ".$data_style."stock_detail.op_date<='$op_date' ";
if($group_id<>"")$sql_bal.=" AND stock_product.group_id='$group_id'";
if($pro_id<>""){$sql_bal.=" AND ".$data_style."stock_detail.product_id IN('$pro_id')"; }
if($no_pro<>""){
$no_pro=substr($no_pro,1);
$sql_bal.=" AND ".$data_style."stock_detail.product_id NOT IN($no_pro) ";
}
$sql_bal.=" AND ".$data_style."stock_detail.op_date < '$op_date' GROUP BY ".$data_style."stock_detail.product_id HAVING bf_qty > 0 ORDER BY stock_product.product_id ";
//echo $sql_bal;
$qid = db_query($sql_bal);
if(db_num_rows($qid)>0){
echo "<tr><td calss='txtThai' colspan='7'><br><b>Stock Non Movement </b><hr color='#000000' size='1'></td></tr>";
$row=1;
while ($r = db_fetch_object($qid)) {
echo "<tr bgcolor='#ffffff'>";
echo "<td align='center' class='txtThai'>".$row++."</td> ";
echo "<td align='left' class='txtThai' valign='middle' width='80'>$to_date </td>";
echo "<td align='left' class='txtThai' valign='middle'>$r->product_id </td>";
echo "<td align='left' class='txtThai' valign='middle'>$r->model </td>";
echo "<td align='left' class='txtThai' valign='middle'>$r->color </td>";
echo "<td align='right' class='txtThai' valign='middle'>".number_format($r->bf_qty,$unit_set,'.',',')." </td>";
echo "<td align='left' class='txtThai' ><font color='#000000'> BALNCE </font></td> ";
echo "</tr>";
}
}
?>
</DIV>
</table>
<script language="javascript">
print_pv(7);
this.window.close();
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -