📄 rpt_inventory_actual.php
字号:
<?
include("../application.php");
$username=$SESSION["user"]["user_name"];
$work_type=$SESSION["user"]["work_type"];
$unit_set=$SESSION["user"]["unit_set"];
include("rptheader.php");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" style="DISPLAY: table-header-group">
<tr>
<td align ="left" class="txtThai" colspan="3" height='20' width="80%"><font size="+2">Hitachi Transport System (Thailand )</font><br></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2" height='20'>INVENTORY STOCK (Manual): <?echo str_replace("\\'"," ",$group_val);?></td>
<td align ="left" class="txtThai" height='20' >User Print : <?echo $username;?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2">CUSTOMMER : <?echo site_info($site_id);?></td>
<td align ="left" class="txtThai" height='20' width="15%" >Date Print : <?echo date('y-m-d');?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai">STYLE : <?if($my_style=="1")echo "DAILY";else echo "SUMMARY";?></td>
<td align ="center" class="txtThai" height='20'>MONTHLY STOCK : <b>
<?
list($op_year,$op_month,$op_day)= split ("-", $op_date, 3);
echo $op_day." ".engmonth($op_month)." ".$op_year;
?></b></td>
<td align ="left" class="txtThai" height='20' width="15%" >Time Print : <?echo date('h:m:d');?></td>
</tr>
</table>
<table border="1" bgcolor="#000000" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000">
<THEAD>
<tr bgcolor="#ffffff" >
<?
echo "<td align='center' width='5%' class='txtThai' rowspan='2'>ITEM</td>";
echo "<td align='center' width='25%' class='txtThaiLB' colspan='2'>DESCRIPTION</td> ";
echo "<td align='center' rowspan='2' class='txtThaiL' width='6%'><font color='#000000'>B/F</font> </td> ";
$sql_head="SELECT COUNT(style_io) cnt ,style_io FROM stock_style_io WHERE work_type='$work_type' AND log_status='1' AND (style_io='+' OR style_io='-') AND inven_status='1' GROUP BY style_io ORDER BY style_ord ASC";
$qid = db_query($sql_head);
while ($x = db_fetch_object($qid)) {
?>
<td align="center" valign="middle" class="txtThaiLB" colspan="<?echo $x->cnt;?>"><font color="#000000"><?if($x->style_io=="+")echo "IN";else echo "OUT";?></font>
</td>
<?
}
echo "<td align='center' rowspan='2' class='txtThaiL' width='6%'><font color='#000000'>BAL</font> ";
echo "</td> ";
echo "<td align='center' rowspan='2' class='txtThaiL' width='6%'><font color='#000000'>ACTUAL<br> CHECK</font> ";
echo "</td> ";
echo "<td align='center' class='txtThaiLB' width='6%'><font color='#000000'>DIF</font> ";
echo "</td> ";
echo "<td align='center' rowspan='2' class='txtThaiL' width='20%'><font color='#000000'>REMARK</font> ";
echo "</td> ";
echo "</tr>";
echo "<tr bgcolor='#ffffff' >";
echo "<td align='center' valign='middle' class='txtThaiL' ><font color='#000000'>Part</font> ";
echo "</td> ";
echo "<td align='center' valign='middle' class='txtThaiL' ><font color='#000000'>Model </font> ";
echo "</td> ";
$sql_head="SELECT style_type,style_io FROM stock_style_io WHERE work_type='$work_type' AND log_status='1' AND (style_io='+' OR style_io='-') AND inven_status='1' ORDER BY style_ord ASC";
$qid = db_query($sql_head);
$count_head=0;
while ($r = db_fetch_object($qid)) {
$count_head++;
$item[$count_head]=0;
$sum_item[$count_head]=0;
?>
<td align="center" valign="middle" class="txtThaiL" width="4%" bgcolor="#ffffff"><font color="#000000"><?echo $r->style_type;?></font>
</td>
<?
}
echo "<td align='center' class='txtThaiL' width='6%'><font color='#000000'>+/-</font> ";
echo "</td> ";
echo "</tr>";
if($my_style=="1"){//Style dialy
$sql_list="SELECT stock_detail.stock_id,stock_detail.site_id,stock_product.group_id,stock_product_group.group_name, stock_detail.product_id,stock_product.model,stock_product.remarks,stock_product.color,SUM(IF (stock_detail.op_date<'$op_date',concat(stock_detail.type , stock_detail.qty),0)) as bf_qty,stock_product.remarks as remarks FROM stock_detail ,stock_product_group,stock_style_io ,stock_product WHERE stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=stock_detail.product_id AND stock_detail.doc_type=stock_style_io.style_type AND stock_detail.log_status='1' AND stock_style_io.inven_status='1'AND stock_detail.site_id='$site_id' AND stock_detail.op_date<='$op_date' ";
}else {
$sql_list="SELECT stock_product.group_id,stock_product_group.group_name, stock_detail.product_id,stock_product.model,stock_product.remarks,stock_product.color,SUM(IF (stock_detail.op_date<'$op_date'&&stock_detail.op_date<='$op_bal',concat(stock_detail.type , stock_detail.qty),0)) as bf_qty,stock_product.remarks as remark FROM stock_detail ,stock_product_group,stock_style_io ,stock_product WHERE stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=stock_detail.product_id AND stock_detail.doc_type=stock_style_io.style_type AND stock_detail.log_status='1' AND stock_style_io.inven_status='1' AND stock_detail.site_id='$site_id' AND stock_detail.op_date<='$op_date' ";
}
$group_val=str_replace("\\","",$group_val);
if($group_val<>"")$sql_list.=" AND stock_product_group.group_id IN ('$group_val') ";
if($product_id<>"")$sql_list.=" AND stock_detail.product_id='$product_id'";
$sql_list.=" GROUP BY stock_product.product_id ORDER BY stock_product_group.group_id,stock_product.product_id";
//if($show_zero=="1")$sql_list.=" HAVING bf_qty > 0";
//$sql_list.="";
//echo $sql_list;
$sum_bf=0;
$sum_bal=0;
$sum_dif=0;
$sum_act=0;
$row=0;
$group_id="";
?>
</THEAD>
</DIV>
<DIV class="innerframe">
<?
$qid = db_query($sql_list);
while ($r = db_fetch_object($qid)) {
$row++;
$mybf=$r->bf_qty;
if($group_id<>$r->group_id){
echo "<tr bgcolor='#ffffff'>";
echo "<td colspan='";
echo $count_head+8;
echo "' class='txtThaiB'> $r->group_name</td>";
echo "</tr>";
}
$group_id=$r->group_id;
?>
<tr bgcolor="#ffffff">
<td align="center" class="txtThaiB"><?echo $row;?> </td>
<td align="left" class="txtThaiLB" ><font color="#000000"> <?echo $r->product_id;?></font></td>
<td align="left" class="txtThaiLB" valign="middle"> <?echo $r->model;?> <?echo $r->color;?>
</td>
<td align="right" class="txtThaiLB" valign="middle"><?echo number_format($r->bf_qty,$unit_set,'.',',');?> </td>
<?
$sql="SELECT stock_style_io.style_ord,stock_detail.type,SUM(if(stock_detail.op_date>'$op_bal',stock_detail.qty,0)) as qty FROM stock_detail,stock_style_io WHERE stock_style_io.style_type=stock_detail.doc_type AND stock_style_io.style_io=stock_detail.type AND stock_detail.product_id='$r->product_id' AND stock_detail.log_status='1' AND stock_style_io.inven_status='1'";
if($my_style=="1") $sql.=" AND stock_detail.op_date='$op_date' ";
else $sql.=" AND stock_detail.op_date<='$op_date'" ;
$sql.=" GROUP BY stock_detail.product_id,stock_detail.doc_type";
//$sql.=" GROUP BY stock_detail.op_date,stock_detail.doc_type";
//echo $sql;
$d_qid=db_query($sql);
while ($d = db_fetch_object($d_qid)) {
$item[$d->style_ord]=$d->qty;
$sum_item[$d->style_ord]+=$d->qty;
if($d->type=='+')$mybf+=$d->qty;
else $mybf-=$d->qty;
}
for($i=1;$i<=$count_head;$i++){
echo "<td class='txtThaiLB' align='right'>";
if($item[$i]>0)echo number_format($item[$i],$unit_set,'.',',');
echo " </td>";
$item[$i]=0;
}
echo "<td align='right' class='txtThaiLB' >".number_format($mybf,$unit_set,'.',',')." </td>";
echo "<td align='right' class='txtThaiLB'>";
$temp=get_actual_stock($r->product_id,$op_date,$site_id);
echo $temp;
echo " </td>";
echo "<td align='right' class='txtThaiLB'>";
echo $mybf-$temp;
echo " </td>";
echo "<td align='right' class='txtThaiLB'> $r->remarks</td>";
echo "</tr>";
$sum_bf+=$r->bf_qty;
$sum_bal+=$mybf;
$sum_act+=$temp;
$sum_dif+=($mybf-$temp);
}
echo "</DIV>";
echo "<tr bgcolor='#ffffff'>";
echo "<td class='txtThai' align='center' colspan='3' >GRAND TOTAL</td>";
echo "<td class='txtThaiL' align='right'>".number_format($sum_bf,$unit_set,'.',',')."</td>";
for($i=1;$i<=$count_head;$i++){
echo "<td class='txtThaiL' align='right'>".number_format($sum_item[$i],$unit_set,'.',',')." </td>";
}
echo "<td class='txtThaiL' align='right'>".number_format($sum_bal,$unit_set,'.',',')." </td>";
echo "<td class='txtThaiL' align='right'>".number_format($sum_act,$unit_set,'.',',')." </td>";
echo "<td class='txtThaiL' align='right'>".number_format($sum_dif,$unit_set,'.',',')." </td>";
echo "<td class='txtThaiL'> </td>";
echo "</tr>";
echo "</table>";
echo "<table border='1' bordercolor='#000000' cellspacing='0' cellpadding='1' width='100%'>";
echo "<tr bgcolor='#ffffff'>";
echo "<td class='txtThai' rowspan='2'> </td>";
echo "<td class='txtThaiL' width='18%' height='40' align='center'>$username</td>";
echo "<td class='txtThaiL' width='18%'> </td>";
echo "<td class='txtThaiL' width='18%'> </td>";
echo "</tr>";
echo "<tr bgcolor='#ffffff'>";
echo "<td class='txtThai' align='center' width='18%' height='20'>REPORTD BY</td>";
echo "<td class='txtThaiL' align='center' width='18%'>CHECKED BY</td>";
echo "<td class='txtThaiL' align='center' width='18%'>APPROVED BY</td>";
echo "</tr>";
echo "</table>"
?>
<script language="javascript">
print_pv(7);
this.window.close();
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -