⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 rpt_plan_analiysis.php

📁 warehouse management system
💻 PHP
字号:
🔍 
<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$unit_set=$SESSION["user"]["unit_set"];
$work_type=$SESSION["user"]["work_type"];
include("rptheader.php");
 ?>
 <title>Plan Analiysis </title>
 
<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 ) Co.,Ltd.<br></td>
		<td  align ="right" class="txtThai" height='20'>User Print : <?echo $username;?></td>
</tr>
 <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai"  height='20'>Report : Inventory of plan analiysis </td>
		<td  align ="center" class="txtThai"   height='20'>&nbsp;</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:i:s');?></td>
</tr>
</table>
<br>
<DIV class=outerframe>
<table  border="1" bgcolor="#ffffff" bordercolor="#000000" cellspacing="0" cellpadding="1" >
<THEAD>
<tr bgcolor="#ffffff">
	<td   align="center"   class="txtThaiB" rowspan="2" width="5%">item</td> 
	<td   align="center"   class="txtThaiLB" colspan="4">Description	</td> 
	<td   align="center"   class="txtThaiLB" rowspan="2">Destination	</td> 
	 <td   align="center"   class="txtThaiLB" rowspan="2">Stock
	</td> 
	
	<?
	$sum_bf=0;// よ沂卮烽衣
	$ttl=0;//よ颐橇峒故瑙试工橐
	$sql_plan="SELECT  1";
	list($s_year,$s_month,$s_day)= split ("-", $in_date, 3); 
	list($f_year,$f_month,$f_day)= split ("-", $to_date, 3); 
	$start=$s_day*1;
	$end=$f_day*1;

	//	echo $i;
	$sum[0]=0;
	for($start;$start<=$end;$start++){
		$sum[$start]=0;
		echo "<td   align='center'  valign='middle' class='txtThaiLB' rowspan='2'>";
		echo $start;
		echo "<br>".date ("D", mktime(0,0,0,$s_month,$start,$s_year));
		echo "</td>";
		$sql_plan.=" ,SUM(if(op_date='";
		$sql_plan.=$s_year."-".$s_month."-".$start;
		$sql_plan.="',qty,0)) as ";
		$sql_plan.="item".$start;
	}

	if($pin_date<>""){
		
		$sql_plan_next="SELECT  1";
		list($ps_year,$ps_month,$ps_day)= split ("-", $pin_date, 3); 
		list($pf_year,$pf_month,$pf_day)= split ("-", $pto_date, 3); 
		$pstart=$ps_day*1;
		$pend=$pf_day*1;
		//	echo $i;
		echo "\n<td colspan='";
		echo ($pend-$pstart+1)+2;
		echo "' class='txtThaiLB' align='center'>";
		echo " PLAN SHIP</td>";
		echo "<td   align='center'  valign='middle' class='txtThaiLB' rowspan='2'>BF </td>"; 
		echo "</tr><tr bgcolor='#ffffff'>";
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>Part </td>"; 
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>Model </td>"; 
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>Color </td>"; 
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>Lotnumber </td>"; 
		for($pstart;$pstart<=$pend;$pstart++){
			$psum[$pstart]=0;
			echo "<td   align='center'  valign='middle' class='txtThaiLB' >$pstart -";
			echo date ("M", mktime(0,0,0,$ps_month,$pstart,$ps_year));
			echo "</td>";
			$sql_plan_next.=" ,SUM(if(plan_date='";
			$sql_plan_next.=$ps_year."-".$ps_month."-".$pstart;
			$sql_plan_next.="',qty,0)) as ";
			$sql_plan_next.="item".$pstart;
		}$psum[$pstart]=0;
		$sql_plan_next.=",SUM(if(plan_date='0000-00-00',qty,0)) as unknow ";
		$sql_plan_next.=" FROM stock_plan_detail  WHERE log_status='1' ";
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>?</td>"; 
		echo "<td   align='center'  valign='middle' class='txtThaiLB'>TTL</td>"; 
	}else	echo "<td   align='center'  valign='middle' class='txtThaiLB' rowspan='2'>BF </td>"; 
	echo "</tr>";
	$sql_plan.=" FROM stock_plan_detail  WHERE log_status='1' ";
	
	?>
 </THEAD>
</DIV>
<DIV class="innerframe">
<?
$sql_list="SELECT stock_detail.lot_number,stock_detail.stock_id,stock_detail.site_id,stock_product.group_id, stock_detail.product_id,SUM(concat(stock_detail.type , stock_detail.qty)) as bf_qty,stock_product.model,stock_product.color,stock_product.remarks as remark 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<='$to_date'";
$group_val=str_replace("\\","",$group_val);
if($group_id<>"" && $group_val=="")$sql_list.=" AND stock_product_group.group_id='$group_id'";
else if($group_val<>"")$sql_list.=" AND stock_product_group.group_id IN('$group_val')";
if($pro_now<>""){
	$pro_now=str_replace("\\","",$pro_now);
	$sql_list.=" AND stock_detail.product_id IN ('$pro_now')";
}
$sql_list.=" GROUP BY stock_product.group_id,stock_product.product_id,stock_detail.lot_number ";
if($show_zero=="1")$sql_list.=" HAVING bf_qty > 0";
//$sql_list.=" AND stock_detail.product_id='0V1ZA3034N'";
$sql_list.=" ORDER BY stock_product.group_id,stock_detail.lot_number,stock_product.model,stock_product.color ";

//echo $sql_list;

$row=0;
$qid = db_query($sql_list);
while ($r = db_fetch_object($qid)) { $row++
//$group_id=$r->group_id;	

?>
<tr bgcolor="#ffffff">
	<td  align="center" class="txtThaiB"  ><?echo $row;?>	</td> 
	<td  align="left" class="txtThaiLB" >&nbsp;<?echo $r->product_id;?></a></td> 
	<td  align="left" class="txtThaiLB" >&nbsp;<?echo $r->model;?></a></td> 
	<td  align="left" class="txtThaiLB"   >&nbsp;<?echo $r->color;?></td> 
	<td  align="left" class="txtThaiLB"   >&nbsp;<?echo $r->lot_number;?></td> 
	<td  align="left" class="txtThaiLB"   >&nbsp;<?echo $r->remark;?></td> 
	<td  align="right" class="txtThaiLB" ><?echo number_format($r->bf_qty,$unit_set,'.',',');?>&nbsp;</td>
	
	<?

	$sum[0]+=$r->bf_qty;
	$bf=$r->bf_qty;
	$temp_sql=$sql_plan." AND product_id='$r->product_id' ";
	//echo $temp_sql;
		$item_qid = db_query($temp_sql);
		$start=$s_day*1;
		 while ($item =db_fetch_array($item_qid, MYSQL_NUM)) {
			 $i=1;
			 for($start;$start<=$end;$start++){
				 $sum[$start]+=$item[$i];
				echo "<td class='txtThaiLB' align='right'>";
				echo number_format($item[$i],$unit_set,'.',',');
				//echo "@@$item[$i]##$start</td>";
				echo "</td>";
				$bf=$bf-$item[$i];
				
				$i++;
			 }
		  }
		 if($pin_date<>""){
			//  echo $start;
			$temp_sql=$sql_plan_next." AND product_id='$r->product_id'";
			//echo $temp_sql;
			$item_qid = db_query($temp_sql);
			$pstart=$ps_day*1;
			//$start--;
			$psum[0]=0;
			$sub_ttl=0;
			 while ($item =db_fetch_array($item_qid, MYSQL_NUM)) {
				 $i=1;
				 for($pstart;$pstart<=$pend+1;$pstart++){
					 $psum[$pstart]+=$item[$i];
					echo "<td class='txtThaiLB' align='right'>";
					echo number_format($item[$i],$unit_set,'.',',');
					//echo "@@$item[$i]##$start</td>";
					echo "</td>";
					$bf=$bf-$item[$i];
					$sub_ttl+$item[$i];
					$ttl+=$item[$i];
					$i++;
					
				 }
				echo "<td  align='right' class='txtThaiLB'>".number_format($sub_ttl,$unit_set,'.',',')."</td>";
				 // び骨长枰守捶橐

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -