📄 uprpt_list_out.php
字号:
<?
include("../application.php");
$username=$SESSION["user"]["user_name"];
$unit_set=$SESSION["user"]["unit_set"];
$work_type=$SESSION["user"]["work_type"];
include("print_head.php");
?>
<body onload="print_report();report.printing.Preview();this.window.close();">
<table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2" height='20'>Hitachi Transport System (Thailand )<br></td>
<td align ="right" class="txtThai" height='20'>User Print : <?echo $username;?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" colspan="2" height='20'>Report : Stock Out List </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" height='20'>CUSTOMMER : <?echo site_info($site_id);?></td>
<td align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:m:d');?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" height='20'>Group Product : <?echo $group_id;?></td>
<td align ="left" class="txtThai" height='20'>Document Type : <?echo $doc_type;?></td>
<td align ="left" class="txtThai" height='20'>Product : <?echo $product_id;?></td>
</tr>
<tr bgcolor="#ffffff">
<td align ="left" class="txtThai" height='20'>Supplier : <?echo $customer_id;?></td>
<td align ="left" class="txtThai" colspan="2" height='20'>Receive Date : <?echo $op_date;?> to <?echo $to_date;?></td>
</tr>
</table>
<br>
<table border="1" bgcolor="#ffffff" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000">
<?
$sql="SELECT stock_head_out.doc_no,stock_head_out.doc_type,stock_head_out.op_date,stock_head_out.sender_id as info_name, stock_detail.product_id,stock_detail.qty,stock_detail.lot_number,stock_location.loc_name as location_name,stock_product.model,stock_product.color FROM stock_head_out, stock_detail,stock_location,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_head_out.head_id=stock_detail.head_id AND stock_detail.location_id=stock_location.loc_id AND stock_head_out.log_status='1' AND stock_detail.log_status='1' AND stock_detail.type='-' AND stock_product.work_type='$work_type'";
if($op_date<>"" AND $to_date<>"")$sql.=" AND stock_head_out.op_date>='$op_date' AND stock_head_out.op_date<='$to_date' ";
if($product_id<>"")$sql.=" AND stock_detail.product_id='$product_id'";
if($lot_number<>"*")$sql.=" AND stock_detail.lot_number='$lot_number'";
if($group_id<>"")$sql.=" AND stock_product_group.group_id='$group_id'";
if($doc_type<>"")$sql.=" AND stock_head_out.doc_type='$doc_type'";
if($customer_id<>"")$sql.=" AND stock_head_out.sender_id='$customer_id'";
$sql.=" ORDER BY stock_head_out.op_date,stock_head_out.doc_no,stock_detail.product_id";
$qid = db_query($sql);
$row=0;
$doc_tmp="";
while ($r = db_fetch_object($qid)) {
$row++;
if($doc_tmp<>$r->doc_no){
$row=1;
?>
<tr bgcolor="#ffffff">
<td align="center" class="txtThai" ><b>Doc No</b></td>
<td align="center" class="txtThai" ><u><?echo $r->doc_no;?></u></td>
<td align="center" class="txtThai" ><b>From</b></td>
<td align="left" class="txtThai" colspan="2"> <u><?echo $r->info_name;?></u></td>
<td align="center" class="txtThai" ><b>Doc Type :</b> <u><?echo $r->doc_type;?></u></td>
<td align="center" class="txtThai"><b>Receive Date</b></td>
<td align="center" class="txtThai" ><u><?echo $r->op_date;?></u></td>
<!-- <td align="left" class="txtThai" > <?echo $r->location_name;?> </td> -->
</tr>
<?}?>
<tr bgcolor="#ffffff">
<td align="center" class="txtThai" ><b><?echo $row;?></b></td>
<td align="center" class="txtThai" ><b>Part</b></td>
<td align="left" class="txtThai" > <?echo $r->product_id;?></td>
<td align="left" class="txtThai" colspan="2" > <?echo $r->model." (".$r->color.")";?> </td>
<td align="center" class="txtThai" ><b>Qty</b> : <u><?echo number_format($r->qty,$unit_set,'.',',');?></u> </td>
<td align="left" class="txtThai" colspan="2" > <b>Lotnumber</b> :<u><?echo $r->lot_number;?></u> </td>
</tr>
<?
$doc_tmp=$r->doc_no;
}?>
</table>
<?
echo "<table border='1' bordercolor='#000000' cellspacing='0' cellpadding='1' width='100%'>";
echo "<tr bgcolor='#ffffff'>";
echo "<td style='border-width:0 pt;' rowspan='2'> </td>";
echo "<td style='border-width:0 pt;' width='18%' height='40' align='center'>$username</td>";
echo "<td style='border-width:0 pt;' width='18%'> </td>";
echo "<td style='border-width:0 pt;' 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='txtThai' align='center' width='18%'>CHECKED BY</td>";
echo "<td class='txtThai' align='center' width='18%'>APPROVED BY</td>";
echo "</tr>";
echo "</table>"
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -