📄 rpt_new_inventory.php
字号:
<?
include("../application.php");
$username=$SESSION["user"]["user_name"];
$username=$SESSION["user"]["user_name"];
$work_type=$SESSION["user"]["work_type"];
$unit_set=$SESSION["user"]["unit_set"];
include("rptheader.php");
//echo $op_bal;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
<tr>
<td align ="left" class="txtThai" colspan="3" height='20' width="80%"><font size="+2">Hitachi Transport System (Thailand ) Co.,Ltd.</font><br></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2" height='20'>INVENTORY STOCK : <?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">CUSTOMER : <?echo site_info($site_id);?></td>
<td align ="left" class="txtThai" height='20' width="15%" >Date Print : <?echo date('d-m-y');?></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:i:s');?></td>
</tr>
</table>
<DIV class="outerframe">
<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='28%' class='txtThaiLB' colspan='2'>DESCRIPTION</td> ";
//echo "<td align='center' valign='middle' class='txtThai' rowspan='2' ><font color='#000000'>COL </font>";
//echo "</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' AND start_date<='$op_date' AND end_date>='$op_date' GROUP BY style_io ORDER BY style_ord ";
$col_count=0;
$qid = db_query($sql_head);
while ($x = db_fetch_object($qid)) {
$col_count+=$x->cnt;?>
<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='20%'><font color='#000000'>REMARK</font> ";
echo "</td> ";
echo "</tr>";
echo "<tr bgcolor='#ffffff' >";
echo "<td align='center' width='40' 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_list="SELECT stock_product.group_id,stock_product_group.group_name, ".$data_style."stock_detail.product_id,stock_product.model,stock_product.color, ";
if($my_style=="1")$sql_list.=" SUM(IF (".$data_style."stock_detail.op_date<'$op_date',concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty),0)) as bf_qty ";
else $sql_list.="SUM(IF (".$data_style."stock_detail.op_date<'$op_date'&&".$data_style."stock_detail.op_date<='$op_bal',concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty),0)) as bf_qty";
$tmp_opt='';
$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' AND start_date<='$op_date' AND end_date>='$op_date' ORDER BY style_ord ASC";
$qid = db_query($sql_head);
$i=0;
$sum_bf=0;
$sum_bal =0;
while ($h = db_fetch_object($qid)) {
$i++;
$tmp_opt.="+opt$i";
$sum_item[$i]=0;
if($my_style=="1"){//Style dialy
$sql_list.=", SUM(if(".$data_style."stock_detail.op_date='$op_date' && ".$data_style."stock_detail.doc_type='$h->style_type' && ".$data_style."stock_detail.type = '$h->style_io',".$data_style."stock_detail.qty,0)) as opt$i ";
}else {// Style Monthly
$sql_list.=" , SUM(IF ((".$data_style."stock_detail.op_date<='$op_date'&&".$data_style."stock_detail.op_date>'$op_bal' )&& ".$data_style."stock_detail.doc_type='$h->style_type' && ".$data_style."stock_detail.type = '$h->style_io',".$data_style."stock_detail.qty,0)) as opt$i ";
}
?>
<td align="center" valign="middle" class="txtThaiL" width="4%" bgcolor="#ffffff"><font color="#000000"><?echo $h->style_type;?></font>
</td>
<?
}
echo "</tr>";
$sql_list.=" ,SUM(concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty)) as now_qty,stock_product.remarks FROM ".$data_style."stock_detail ,stock_product_group,stock_product,stock_style_io WHERE stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=".$data_style."stock_detail.product_id AND ".$data_style."stock_detail.doc_type=stock_style_io.style_type AND ".$data_style."stock_detail.log_status='1' AND stock_style_io.inven_status='1' AND ".$data_style."stock_detail.site_id='$site_id' AND ".$data_style."stock_detail.op_date<='$op_date' ";
$group_val=str_replace("\\","",$group_val);
$s_date=substr($op_date,0,-2).'01';
if($group_val<>"")$sql_list.=" AND stock_product_group.group_id IN ('$group_val') ";
if($product_id<>"")$sql_list.=" AND ".$data_style."stock_detail.product_id='$product_id'";
$sql_list.=" GROUP BY stock_product.product_id ";
if($show_zero=="1")$sql_list.=" HAVING (now_qty$tmp_opt+bf_qty) > 0";
$sql_list.=" ORDER BY stock_product_group.group_id,stock_product.product_id ";
//echo $sql_list;
$row=0;
$qid = db_query($sql_list);
$group_id="";
?>
</THEAD>
</DIV>
<DIV class="innerframe">
<?
while ($frm = db_fetch_array($qid)) {
$row++;
if($group_id<>$frm["group_id"]){
echo "<tr bgcolor='#ffffff' class='txtThai'>";
echo "<td colspan='";
echo $col_count+6;
echo "'> <b>$frm[group_name]</b></td>";
echo "</tr>";
}
$group_id=$frm["group_id"];
?>
<tr bgcolor="#ffffff">
<td align="center" class="txtThaiB" ><?echo $row;?> </td>
<td align="left" class="txtThaiLB" > <?echo $frm["product_id"];?></td>
<td align="left" class="txtThaiLB" valign="middle"> <?echo $frm["model"];?> <?echo $frm["color"];?> </td>
<td align="right" class="txtThaiLB" valign="middle"><?echo number_format($frm["bf_qty"],$unit_set,'.',',');?> </td
>
<?for($i=1;$i<=$col_count;$i++){?>
<td align="right" class="txtThaiLB" valign="middle"><?if($frm["opt".$i]>0)echo number_format($frm["opt".$i],$unit_set,'.',',');?> </td>
<?
$sum_item[$i]+=$frm["opt".$i];
}?>
<td align="right" class="txtThaiLB" valign="middle"><?echo number_format($frm["now_qty"],$unit_set,'.',',');?> </td>
<td align="left" class="txtThaiLB" valign="middle"> <?echo $frm["remarks"];?></td>
</tr>
<?
$sum_bf+=$frm["bf_qty"];
$sum_bal+=$frm["now_qty"];
}
echo "</DIV>";
?>
<div class="outerframe">
<tfoot>
<tr bgcolor="#ffffff" >
<td class='TFOOT TD' align='right' colspan='<?echo $col_count+6;?>'>F.STC.1.Rev.01
</td>
</tr>
</tfoot>
</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<=$col_count;$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' > </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' class='txtThai'>$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' class='txtThai'>REPORTD BY</td>";
echo "<td class='txtThai' align='center' width='18%' class='txtThai'>CHECKED BY</td>";
echo "<td class='txtThai' align='center' width='18%' class='txtThai'>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 + -