bs3000+ 百胜 计算生产的总数是否够市场的需求 计算方法
看到这个我列出了一个公式和计算的PHP脚本
--index.php--start-->>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
#apDiv1 {
position:absolute;
width:200px;
height:115px;
z-index:1;
left: 115px;
top: 163px;
}
</style>
</head>
<body>
<p>select 裁床数,主表:</p>
<p>--单号和货品信息<br />
--商品 单号,款号,颜色编号,尺码编号,订单数,订单金额,有效数,有效金额,。。。<br />
SELECT * FROM VW_SPORDER<br />
--商品的主要的信息,基础资料()<br />
SELECT * FROM SHANGPIN<br />
--商品的单位名称<br />
SELECT * FROM DANWEI</p>
<p>查询类型:</p>
<div id="apDiv1">
<form action="t2.php" method="post" name="form1" target="_blank" id="form1">
<table width="200" border="1">
<tr>
<td> </td>
<td>选择类型</td>
<td> </td>
</tr>
<tr>
<td>童装<br />
女装</td>
<td><p>
<label>
<input type="radio" name="pinpai_id" value="Q" id="RadioGroup1_0" />
Q</label>
<br />
<label>
<input type="radio" name="pinpai_id" value="M" id="RadioGroup1_0" />
M</label>
<br />
</p></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="button" id="button" value="提交" /></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</div>
</body>
</html>
--index.php--end--<<
--t2.php--start-->>
<?PHP
include("../../include/func.php");
/* $cangku_id_arr=$_POST["checkbox"];
print_r($cangku_id_arr);
echo "<br />";
$cangku_sum_id="";
$cangku_name_sum="";
for($i=0;$i<(count($cangku_id_arr));$i++){
$cangku_id_arr_b=$cangku_id_arr[$i];
$cangku_sum_id=$cangku_sum_id.",'".$cangku_id_arr_b."'";
// //
// //查询 仓库编号对应的仓库名称
$dbh_4 = new PDO('mssql:host=192.168.6.23;dbname=[BS3000+_000_2010]',$username,$pwd);
$sqlstri_4="select CKMC from CANGKU where CKDM='$cangku_id_arr_b'";
foreach($dbh_4->query($sqlstri_4) as $row_4){
$cangku_name=$row_4['CKMC'];
$cangku_name_sum=$cangku_name_sum.",".$cangku_name;
}
$cangku_name_sum=substr($cangku_name_sum,1);
// //
}
echo $sql_cangku_sum_id=substr($cangku_sum_id,1);
*/
$pinpai_id=$_POST["pinpai_id"];
if($pinpai_id=="Q"){$cang_leixing="001";}
if($pinpai_id=="M"){$cang_leixing="101";}
echo $pinpai_id."<br />";
echo $cang_leixing."<br />";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
上面想列出的是 生产的裁床数是不是够现在的发货总数。<br />
生产裁床数-调拨订单的订单总数-调拨订单的非订单的发货总数-配货订单的订单总数-配货发货的非订单的发货总数=生产需求差异单
<br />
<table border="1" cellpadding="0" cellspacing="0">
<col width="98" />
<col width="91" />
<col width="72" span="3" />
<col width="37" span="10" />
<col width="72" span="2" />
<tr>
<td width="98"> </td>
<td width="98">SPDM</td>
<td width="91">GG1DM</td>
<td width="91">GG1MC</td>
<td width="91">SPMC</td>
<td width="72">ZJF</td>
<td width="72">DWMC</td>
<td width="37">WZ1</td>
<td width="37">WZ2</td>
<td width="37">WZ3</td>
<td width="37">WZ4</td>
<td width="37">WZ5</td>
<td width="37">WZ6</td>
<td width="37">WZ7</td>
<td width="37">WZ8</td>
<td width="37">WZ9</td>
<td width="37">WZ10</td>
<td width="72">SL</td>
<td width="72">IsAdjust</td>
</tr>
<tr>
<td rowspan="3" width="98">id </td>
<td rowspan="3" width="98">商品代码</td>
<td rowspan="3" width="91">颜色代码</td>
<td rowspan="3" width="91">颜色</td>
<td rowspan="3" width="91">商品名称</td>
<td rowspan="3" width="72">助记符</td>
<td rowspan="3" width="72">单位名称</td>
<td colspan="10" width="370">尺码名称</td>
<td rowspan="3" width="72">数量</td>
<td>调价商品</td>
</tr>
<tr>
<td width="37">80</td>
<td width="37">90</td>
<td width="37">100</td>
<td width="37">110</td>
<td width="37">120</td>
<td width="37">130</td>
<td width="37">140</td>
<td width="37">150</td>
<td width="37">160</td>
<td width="37">QF</td>
<td> </td>
</tr>
<tr>
<td width="37">S</td>
<td width="37">M</td>
<td width="37">L</td>
<td width="37">XL</td>
<td width="37">XXL</td>
<td width="37">MF</td>
<td width="37"> </td>
<td width="37"> </td>
<td width="37"> </td>
<td width="37"> </td>
<td> </td>
</tr>
<?php
$username = "sa";
$pwd = "dgbaison";
try
{
$dbh = new PDO('mssql:host=192.168.6.23;dbname=[BS3000+_000_2010]',$username,$pwd);
$sqlstri1 = "SELECT VW_SPORDER.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,Shangpin.dtDefine2 ,VW_SPORDER.GG1DM,GUIGE1.GGMC AS GG1MC ,SUM(CASE GUIGE2.GGWZ2 WHEN 1 THEN VW_SPORDER.SL END) AS WZ1,SUM(CASE GUIGE2.GGWZ2 WHEN 2 THEN VW_SPORDER.SL END) AS WZ2,SUM(CASE GUIGE2.GGWZ2 WHEN 3 THEN VW_SPORDER.SL END) AS WZ3,SUM(CASE GUIGE2.GGWZ2 WHEN 4 THEN VW_SPORDER.SL END) AS WZ4,SUM(CASE GUIGE2.GGWZ2 WHEN 5 THEN VW_SPORDER.SL END) AS WZ5,SUM(CASE GUIGE2.GGWZ2 WHEN 6 THEN VW_SPORDER.SL END) AS WZ6,SUM(CASE GUIGE2.GGWZ2 WHEN 7 THEN VW_SPORDER.SL END) AS WZ7,SUM(CASE GUIGE2.GGWZ2 WHEN 8 THEN VW_SPORDER.SL END) AS WZ8,SUM(CASE GUIGE2.GGWZ2 WHEN 9 THEN VW_SPORDER.SL END) AS WZ9,SUM(CASE GUIGE2.GGWZ2 WHEN 10 THEN VW_SPORDER.SL END) AS WZ10,CASE SUM(VW_SPORDER.SL_3N) WHEN 0 THEN SHANGPIN.BZSJ ELSE SUM(SHANGPIN.BZSJ* VW_SPORDER.SL)/SUM(VW_SPORDER.SL) END AS CKJ,abs(SUM(SHANGPIN.BZSJ* VW_SPORDER.SL)) AS CKJE ,abs(SUM(VW_SPORDER.SL)) AS SL,abs(SUM(VW_SPORDER.SL_3N)) AS SL_3N,abs(SUM(VW_SPORDER.SL_3)) AS SL_3, CASE SUM(VW_SPORDER.SL_3N) WHEN 0 THEN NULL ELSE SUM(VW_SPORDER.JE_3N)/SUM(VW_SPORDER.SL_3N) END AS DJ,abs(SUM(VW_SPORDER.JE)) AS JE,abs(SUM(VW_SPORDER.JE_3N)) AS JE_3N,abs(SUM(VW_SPORDER.JE_3)) AS JE_3, abs(SUM(VW_SPORDER.SL_1)) AS SL_1,abs(SUM(VW_SPORDER.JE_1)) AS JE_1, abs(SUM(VW_SPORDER.SL_1N)) AS SL_1N,abs(SUM(VW_SPORDER.JE_1N)) AS JE_1N, abs(SUM(VW_SPORDER.SL_2)) AS SL_2,abs(SUM(VW_SPORDER.JE_2)) AS JE_2, SUM(VW_SPORDER.SL_2N) AS SL_2N,SUM(VW_SPORDER.JE_2N) AS JE_2N, VW_SPORDER.SPDM AS SPGG FROM VW_SPORDER,SHANGPIN,GONGHUOSHANG, DANWEI ,GUIGE1, GUIGE2 WHERE VW_SPORDER.SPDM=SHANGPIN.SPDM AND VW_SPORDER.DM1=GONGHUOSHANG.GHSDM AND SHANGPIN.DWMC = DANWEI.DWDM AND VW_SPORDER.GG1DM=GUIGE1.GGDM AND VW_SPORDER.GG2DM=GUIGE2.GGDM AND (SHANGPIN.FJSX1 in ('$pinpai_id')) AND (SHANGPIN.FJSX4 in ('1')) AND (VW_SPORDER.JZ = '1') AND VW_SPORDER.DJXZ = 11 AND (VW_SPORDER.DM2 in ('$cang_leixing')) GROUP BY VW_SPORDER.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,Shangpin.dtDefine2,SHANGPIN.BZSJ ,VW_SPORDER.GG1DM,GUIGE1.GGMC ";
$id_num=0;
$WZ1_NUM=0;
$WZ2_NUM=0;
$WZ3_NUM=0;
$WZ4_NUM=0;
$WZ5_NUM=0;
$WZ6_NUM=0;
$WZ7_NUM=0;
$WZ8_NUM=0;
$WZ9_NUM=0;
$WZ10_NUM=0;
$SL_NUM=0;
foreach ($dbh->query($sqlstri1) as $row)
{
$id_num++;
// echo "";
// echo $row['SPDM'];
// echo "-";
// echo $row['SPMC'];
// echo "-";
//
// echo $row['SL'];
// echo "<br />";
//print_r($row);
//或者
//echo $row['name'];
//指定字段输出
?>
<!--循环开始-->
<tr bgcolor="#999999">
<td><?php echo $id_num; ?>(裁床数)</td>
<td><?php echo $row["SPDM"]; ?></td>
<td><?php echo $row["GG1DM"]; ?></td>
<td><?php echo $row["GG1MC"]; ?></td>
<td><?php echo $row["SPMC"]; ?></td>
<td><?php echo $row["ZJF"]; ?></td>
<td><?php echo $row["DWMC"]; ?></td>
<td><?php echo floor($row["WZ1"]); ?></td>
<td><?php echo floor($row["WZ2"]); ?></td>
<td><?php echo floor($row["WZ3"]); ?></td>
<td><?php echo floor($row["WZ4"]); ?></td>
<td><?php echo floor($row["WZ5"]); ?></td>
<td><?php echo floor($row["WZ6"]); ?></td>
<td><?php echo floor($row["WZ7"]); ?></td>
<td><?php echo floor($row["WZ8"]); ?></td>
<td><?php echo floor($row["WZ9"]); ?></td>
<td><?php echo floor($row["WZ10"]); ?></td>
<td><?php echo floor($row["SL"]); ?></td>
<td><?php echo floor($row["IsAdjust"]); ?></td>
</tr>
<?php
///新增加的 根据 款式 颜色 尺码 查找 数据
$k_ids=$row["SPDM"];
$k_colors=$row["GG1DM"];
?>
<?PHP
///---->>>
//第一个是 调拨发货单,总发货数
$diaobodingdan_sql=" SELECT VW_DBJRDMX.SPDM,SHANGPIN.SPMC,SHANGPIN.ZJF,DANWEI.DWMC ,VW_DBJRDMX.GG1DM,GUIGE1.GGMC AS GG1MC ,SUM(CASE GUIGE2.GGWZ2 WHEN 1 THEN VW_DBJRDMX.SL_3N END) AS WZ1,SUM(CASE GUIGE2.GGWZ2 WHEN 2 THEN VW_DBJRDMX.SL_3N END) AS WZ2,SUM(CASE GUIGE2.GGWZ2 WHEN 3 THEN VW_DBJRDMX.SL_3N END) AS WZ3,SUM(CASE GUIGE2.GGWZ2 WHEN 4 THEN VW_DBJRDMX.SL_3N END) AS WZ4,SUM(CASE GUIGE2.GGWZ2 WHEN 5 THEN VW_DBJRDMX.SL_3N END) AS WZ5,SUM(CASE GUIGE2.GGWZ2 WHEN 6 THEN VW_DBJRDMX.SL_3N END) AS WZ6,SUM(CASE GUIGE2.GGWZ2 WHEN 7 THEN VW_DBJRDMX.SL_3N END) AS WZ7,SUM(CASE GUIGE2.GGWZ2 WHEN 8 THEN VW_DBJRDMX.SL_3N END) AS WZ8,SUM(CASE GUIGE2.GGWZ2 WHEN 9 THEN VW_DBJRDMX.SL_3N END) AS WZ9,SUM(CASE GUIGE2.GGWZ2 WHEN 10 THEN VW_DBJRDMX.SL_3N END) AS WZ10,CASE SUM(VW_DBJRDMX.SL_3N) WHEN 0 THEN NULL ELSE SUM(SHANGPIN.BZJJ* VW_DBJRDMX.SL)/SUM(VW_DBJRDMX.SL) END AS CKJ,abs(SUM(SHANGPIN.BZJJ* VW_DBJRDMX.SL)) AS CKJE ,abs(SUM(VW_DBJRDMX.JE)) AS JE,abs(SUM(VW_DBJRDMX.JE_3N)) AS JE_3N,abs(SUM(VW_DBJRDMX.JE_3)) AS JE_3, abs(SUM(VW_DBJRDMX.SL)) AS SL ,abs(SUM(VW_DBJRDMX.SL_3N)) AS SL_3N,abs(SUM(VW_DBJRDMX.SL_3)) AS SL_3 ,CASE SUM(VW_DBJRDMX.SL_3N) WHEN 0 THEN NULL ELSE abs(SUM(VW_DBJRDMX.JE_3N)/SUM(VW_DBJRDMX.SL_3N)) END AS DJ ,abs(SUM(VW_DBJRDMX.SL_1)) AS SL_1,abs(SUM(VW_DBJRDMX.JE_1)) AS JE_1 ,abs(SUM(VW_DBJRDMX.SL_2)) AS SL_2,abs(SUM(VW_DBJRDMX.JE_2)) AS JE_2 ,SUM(VW_DBJRDMX.SL_2N) AS SL_2N,SUM(VW_DBJRDMX.JE_2N) AS JE_2N ,CONVERT(BIT,CASE WHEN SUM(VW_DBJRDMX.SL_2N)>0 THEN 0 ELSE 1 END) AS SPWG ,SHANGPIN.CBJE FROM VW_DBJRDMX,SHANGPIN, DANWEI ,GUIGE1, GUIGE2 WHERE VW_DBJRDMX.SPDM=SHANGPIN.SPDM AND SHANGPIN.DWMC = DANWEI.DWDM AND VW_DBJRDMX.GG1DM=GUIGE1.GGDM AND VW_DBJRDMX.GG2DM=GUIGE2.GGDM AND (SHANGPIN.FJSX1 in ('$pinpai_id')) AND (SHANGPIN.FJSX4 in ('1')) AND (SHANGPIN.SPDM in ('$k_ids')) AND (GUIGE1.GGDM in ('$k_colors')) AND VW_DBJRDMX.DJXZ = 15 AND VW_DBJRDMX.LXDM IN('001') GROUP BY VW_DBJRDMX.SPDM,SHANGPIN.SPMC,SHANGPIN.ZJF,DANWEI.DWMC,SHANGPIN.CBJE,SHANGPIN. BZJJ ,VW_DBJRDMX.GG1DM,GUIGE1.GGMC ";
foreach ($dbh->query($diaobodingdan_sql) as $row_diaobodingdan){
?>
<tr bgcolor="#009999">
<td>(调拨订单)</td>
<td><?php echo $row_diaobodingdan["SPDM"]; ?></td>
<td><?php echo $row_diaobodingdan["GG1DM"]; ?></td>
<td><?php echo $row_diaobodingdan["GG1MC"]; ?></td>
<td><?php echo $row_diaobodingdan["SPMC"]; ?></td>
<td><?php echo $row_diaobodingdan["ZJF"]; ?></td>
<td><?php echo $row_diaobodingdan["DWMC"]; ?></td>
<td><?php echo floor($row_diaobodingdan["WZ1"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ2"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ3"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ4"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ5"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ6"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ7"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ8"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ9"]); ?></td>
<td><?php echo floor($row_diaobodingdan["WZ10"]); ?></td>
<td><?php echo floor($row_diaobodingdan["SL"]); ?></td>
<td><?php echo floor($row_diaobodingdan["IsAdjust"]); ?></td>
</tr>
<?php
}
///----<<<
?>
<?PHP
///---->>>
//第一个是 调拨发货单
$diaobochuhuodan_sql="SELECT VW_QDDBMX.SPDM,SHANGPIN.SPMC,SHANGPIN.ZJF,DANWEI.DWMC ,VW_QDDBMX.GG1DM,GUIGE1.GGMC AS GG1MC ,SUM(CASE GUIGE2.GGWZ2 WHEN 1 THEN VW_QDDBMX.SL END) AS WZ1,SUM(CASE GUIGE2.GGWZ2 WHEN 2 THEN VW_QDDBMX.SL END) AS WZ2,SUM(CASE GUIGE2.GGWZ2 WHEN 3 THEN VW_QDDBMX.SL END) AS WZ3,SUM(CASE GUIGE2.GGWZ2 WHEN 4 THEN VW_QDDBMX.SL END) AS WZ4,SUM(CASE GUIGE2.GGWZ2 WHEN 5 THEN VW_QDDBMX.SL END) AS WZ5,SUM(CASE GUIGE2.GGWZ2 WHEN 6 THEN VW_QDDBMX.SL END) AS WZ6,SUM(CASE GUIGE2.GGWZ2 WHEN 7 THEN VW_QDDBMX.SL END) AS WZ7,SUM(CASE GUIGE2.GGWZ2 WHEN 8 THEN VW_QDDBMX.SL END) AS WZ8,SUM(CASE GUIGE2.GGWZ2 WHEN 9 THEN VW_QDDBMX.SL END) AS WZ9,SUM(CASE GUIGE2.GGWZ2 WHEN 10 THEN VW_QDDBMX.SL END) AS WZ10,CASE SUM(VW_QDDBMX.SL) WHEN 0 THEN NULL ELSE SUM(SHANGPIN.BZJJ* VW_QDDBMX.SL)/SUM(VW_QDDBMX.SL) END AS CKJ ,SUM(SHANGPIN.BZJJ* VW_QDDBMX.SL) AS CKJE ,SUM(VW_QDDBMX.SL) AS SL,CASE SUM(VW_QDDBMX.SL) WHEN 0 THEN NULL ELSE SUM(VW_QDDBMX.JE)/SUM(VW_QDDBMX.SL) END AS DJ,SUM(VW_QDDBMX.JE) AS JE_S ,SHANGPIN.CBJE ,VW_QDDBMX.SPDM AS SPGG FROM VW_QDDBMX,SHANGPIN, DANWEI ,GUIGE1, GUIGE2 WITH (NOLOCK) WHERE VW_QDDBMX.SPDM=SHANGPIN.SPDM AND SHANGPIN.DWMC = DANWEI.DWDM AND VW_QDDBMX.GG1DM=GUIGE1.GGDM AND VW_QDDBMX.GG2DM=GUIGE2.GGDM AND (SHANGPIN.FJSX1 in ('$leixing')) AND (SHANGPIN.FJSX4 in ('1')) AND (SHANGPIN.SPDM in ('$k_ids')) AND (GUIGE1.GGDM in ('$k_colors')) AND (VW_QDDBMX.YS = '1') AND (VW_QDDBMX.DM2 in ('$cang_leixing')) AND (VW_QDDBMX.DM4 in ('000','002','003','004','005','006','007')) GROUP BY VW_QDDBMX.SPDM,SHANGPIN.SPMC,SHANGPIN.ZJF,DANWEI.DWMC,SHANGPIN.CBJE,SHANGPIN. BZJJ ,VW_QDDBMX.GG1DM,GUIGE1.GGMC ";
foreach ($dbh->query($diaobochuhuodan_sql) as $row_diaobochuhuodan){
?>
<tr bgcolor="#009999">
<td>(调拨出货)</td>
<td><?php echo $row_diaobochuhuodan["SPDM"]; ?></td>
<td><?php echo $row_diaobochuhuodan["GG1DM"]; ?></td>
<td><?php echo $row_diaobochuhuodan["GG1MC"]; ?></td>
<td><?php echo $row_diaobochuhuodan["SPMC"]; ?></td>
<td><?php echo $row_diaobochuhuodan["ZJF"]; ?></td>
<td><?php echo $row_diaobochuhuodan["DWMC"]; ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ1"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ2"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ3"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ4"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ5"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ6"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ7"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ8"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ9"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["WZ10"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["SL"]); ?></td>
<td><?php echo floor($row_diaobochuhuodan["IsAdjust"]); ?></td>
</tr>
<?php
}
///----<<<
?>
<?PHP
///---->>>
//第san个是 配货订单
$peihuodingdan_sql=" SELECT VW_PHJRMX.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,shangpin.dtDefine2 ,VW_PHJRMX.GG1DM,GUIGE1.GGMC AS GG1MC ,SUM(CASE GUIGE2.GGWZ2 WHEN 1 THEN VW_PHJRMX.SL END) AS WZ1,SUM(CASE GUIGE2.GGWZ2 WHEN 2 THEN VW_PHJRMX.SL END) AS WZ2,SUM(CASE GUIGE2.GGWZ2 WHEN 3 THEN VW_PHJRMX.SL END) AS WZ3,SUM(CASE GUIGE2.GGWZ2 WHEN 4 THEN VW_PHJRMX.SL END) AS WZ4,SUM(CASE GUIGE2.GGWZ2 WHEN 5 THEN VW_PHJRMX.SL END) AS WZ5,SUM(CASE GUIGE2.GGWZ2 WHEN 6 THEN VW_PHJRMX.SL END) AS WZ6,SUM(CASE GUIGE2.GGWZ2 WHEN 7 THEN VW_PHJRMX.SL END) AS WZ7,SUM(CASE GUIGE2.GGWZ2 WHEN 8 THEN VW_PHJRMX.SL END) AS WZ8,SUM(CASE GUIGE2.GGWZ2 WHEN 9 THEN VW_PHJRMX.SL END) AS WZ9,SUM(CASE GUIGE2.GGWZ2 WHEN 10 THEN VW_PHJRMX.SL END) AS WZ10,CASE SUM(VW_PHJRMX.SL_3N) WHEN 0 THEN NULL ELSE SUM(SHANGPIN.BZJJ* VW_PHJRMX.SL)/SUM(VW_PHJRMX.SL) END AS CKJ,abs(SUM(SHANGPIN.BZJJ* VW_PHJRMX.SL)) AS CKJE, abs(SUM(VW_PHJRMX.SL)) AS SL,abs(SUM(VW_PHJRMX.SL_3N)) AS SL_3N,abs(SUM(VW_PHJRMX.SL_3)) AS SL_3, CASE SUM(VW_PHJRMX.SL) WHEN 0 THEN NULL ELSE abs(SUM(VW_PHJRMX.JE_3N)/SUM(VW_PHJRMX.SL_3N)) END AS DJ, abs(SUM(VW_PHJRMX.JE)) AS JE,abs(SUM(VW_PHJRMX.JE_3N)) AS JE_3N,abs(SUM(VW_PHJRMX.JE_3)) AS JE_3, abs(SUM(VW_PHJRMX.SL_1)) AS SL_1,abs(SUM(VW_PHJRMX.JE_1)) AS JE_1, abs(SUM(VW_PHJRMX.SL_2)) AS SL_2, abs(SUM(VW_PHJRMX.JE_2)) AS JE_2, SUM(VW_PHJRMX.SL_2N) AS SL_2N, SUM(VW_PHJRMX.JE_2N) AS JE_2N, CONVERT(BIT,CASE WHEN SUM(VW_PHJRMX.SL_2N)>0 THEN 0 ELSE 1 END) AS SPWG FROM VW_PHJRMX,SHANGPIN, DANWEI ,GUIGE1, GUIGE2 WHERE VW_PHJRMX.SPDM=SHANGPIN.SPDM AND SHANGPIN.DWMC = DANWEI.DWDM AND VW_PHJRMX.GG1DM=GUIGE1.GGDM AND VW_PHJRMX.GG2DM=GUIGE2.GGDM AND (SHANGPIN.FJSX1 in ('$pinpai_id')) AND (SHANGPIN.FJSX4 in ('1')) AND (SHANGPIN.SPDM in ('$k_ids')) AND (GUIGE1.GGDM in ('$k_colors')) AND VW_PHJRMX.DJXZ = 19 AND VW_PHJRMX.LXDM In('001') AND (VW_PHJRMX.DM2 in ('$cang_leixing')) GROUP BY VW_PHJRMX.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,shangpin.dtDefine2,SHANGPIN.BZJJ ,VW_PHJRMX.GG1DM,GUIGE1.GGMC ";
foreach ($dbh->query($peihuodingdan_sql) as $row_peihuodingdan){
?>
<tr bgcolor="#009999">
<td>(配货订单)</td>
<td><?php echo $row_peihuodingdan["SPDM"]; ?></td>
<td><?php echo $row_peihuodingdan["GG1DM"]; ?></td>
<td><?php echo $row_peihuodingdan["GG1MC"]; ?></td>
<td><?php echo $row_peihuodingdan["SPMC"]; ?></td>
<td><?php echo $row_peihuodingdan["ZJF"]; ?></td>
<td><?php echo $row_peihuodingdan["DWMC"]; ?></td>
<td><?php echo floor($row_peihuodingdan["WZ1"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ2"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ3"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ4"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ5"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ6"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ7"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ8"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ9"]); ?></td>
<td><?php echo floor($row_peihuodingdan["WZ10"]); ?></td>
<td><?php echo floor($row_peihuodingdan["SL"]); ?></td>
<td><?php echo floor($row_peihuodingdan["IsAdjust"]); ?></td>
</tr>
<?php
}
///----<<<
?>
<?PHP
///---->>>
//第si个是 配货订单
$row_peihuofahuodan_sql="SELECT VW_SDPHMX.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,shangpin.dtDefine2 ,VW_SDPHMX.GG1DM,GUIGE1.GGMC AS GG1MC ,SUM(CASE GUIGE2.GGWZ2 WHEN 1 THEN VW_SDPHMX.SL END) AS WZ1,SUM(CASE GUIGE2.GGWZ2 WHEN 2 THEN VW_SDPHMX.SL END) AS WZ2,SUM(CASE GUIGE2.GGWZ2 WHEN 3 THEN VW_SDPHMX.SL END) AS WZ3,SUM(CASE GUIGE2.GGWZ2 WHEN 4 THEN VW_SDPHMX.SL END) AS WZ4,SUM(CASE GUIGE2.GGWZ2 WHEN 5 THEN VW_SDPHMX.SL END) AS WZ5,SUM(CASE GUIGE2.GGWZ2 WHEN 6 THEN VW_SDPHMX.SL END) AS WZ6,SUM(CASE GUIGE2.GGWZ2 WHEN 7 THEN VW_SDPHMX.SL END) AS WZ7,SUM(CASE GUIGE2.GGWZ2 WHEN 8 THEN VW_SDPHMX.SL END) AS WZ8,SUM(CASE GUIGE2.GGWZ2 WHEN 9 THEN VW_SDPHMX.SL END) AS WZ9,SUM(CASE GUIGE2.GGWZ2 WHEN 10 THEN VW_SDPHMX.SL END) AS WZ10,CASE SUM(VW_SDPHMX.SL) WHEN 0 THEN NULL ELSE SUM(SHANGPIN.BZJJ* VW_SDPHMX.SL)/SUM(VW_SDPHMX.SL) END AS CKJ ,SUM(SHANGPIN.BZJJ* VW_SDPHMX.SL) AS CKJE ,SUM(VW_SDPHMX.SL) AS SL,CASE SUM(VW_SDPHMX.SL) WHEN 0 THEN NULL ELSE SUM(VW_SDPHMX.JE)/SUM(VW_SDPHMX.SL) END AS DJ,SUM(VW_SDPHMX.JE) AS JE_S ,VW_SDPHMX.SPDM AS SPGG FROM VW_SDPHMX,SHANGPIN, DANWEI ,GUIGE1, GUIGE2 WITH (NOLOCK) WHERE VW_SDPHMX.SPDM=SHANGPIN.SPDM AND SHANGPIN.DWMC = DANWEI.DWDM AND VW_SDPHMX.GG1DM=GUIGE1.GGDM AND VW_SDPHMX.GG2DM=GUIGE2.GGDM AND (SHANGPIN.FJSX1 in ('$pinpai_id')) AND (SHANGPIN.FJSX4 in ('1')) AND (SHANGPIN.SPDM in ('$k_ids')) AND (GUIGE1.GGDM in ('$k_colors')) AND (VW_SDPHMX.YS = '1') AND (VW_SDPHMX.DM2 in ('$cang_leixing')) AND (VW_SDPHMX.DM4 in ('002','003','004','005','006','007','021','024','025','026','027','028','000')) GROUP BY VW_SDPHMX.SPDM,SHANGPIN.SPMC,SHANGPIN.SPBM,SHANGPIN.ZJF,DANWEI.DWMC,shangpin.dtDefine2,SHANGPIN.BZJJ ,VW_SDPHMX.GG1DM,GUIGE1.GGMC";
foreach ($dbh->query($row_peihuofahuodan_sql) as $row_peihuofahuodan){
?>
<tr bgcolor="#009999">
<td>(配货出货)</td>
<td><?php echo $row_peihuofahuodan["SPDM"]; ?></td>
<td><?php echo $row_peihuofahuodan["GG1DM"]; ?></td>
<td><?php echo $row_peihuofahuodan["GG1MC"]; ?></td>
<td><?php echo $row_peihuofahuodan["SPMC"]; ?></td>
<td><?php echo $row_peihuofahuodan["ZJF"]; ?></td>
<td><?php echo $row_peihuofahuodan["DWMC"]; ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ1"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ2"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ3"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ4"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ5"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ6"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ7"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ8"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ9"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["WZ10"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["SL"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["IsAdjust"]); ?></td>
</tr>
<?php
}
///----<<<
?>
<?php
?>
<tr bgcolor="#CC66CC">
<td>(差异单)</td>
<td><?php echo $row_peihuofahuodan["SPDM"]; ?></td>
<td><?php echo $row_peihuofahuodan["GG1DM"]; ?></td>
<td><?php echo $row_peihuofahuodan["GG1MC"]; ?></td>
<td><?php echo $row_peihuofahuodan["SPMC"]; ?></td>
<td><?php echo $row_peihuofahuodan["ZJF"]; ?></td>
<td><?php echo $row_peihuofahuodan["DWMC"]; ?></td>
<td><?php echo ($row["WZ1"])-($row_diaobodingdan["WZ1"])-($row_peihuodingdan["WZ1"])-($row_diaobochuhuodan["WZ1"])-($row_peihuofahuodan["WZ1"]); ?></td>
<td><?php echo ($row["WZ2"])-($row_diaobodingdan["WZ2"])-($row_peihuodingdan["WZ2"])-($row_diaobochuhuodan["WZ2"])-($row_peihuofahuodan["WZ2"]); ?></td>
<td><?php echo ($row["WZ3"])-($row_diaobodingdan["WZ3"])-($row_peihuodingdan["WZ3"])-($row_diaobochuhuodan["WZ3"])-($row_peihuofahuodan["WZ3"]); ?></td>
<td><?php echo ($row["WZ4"])-($row_diaobodingdan["WZ4"])-($row_peihuodingdan["WZ4"])-($row_diaobochuhuodan["WZ4"])-($row_peihuofahuodan["WZ4"]); ?></td>
<td><?php echo ($row["WZ5"])-($row_diaobodingdan["WZ5"])-($row_peihuodingdan["WZ5"])-($row_diaobochuhuodan["WZ5"])-($row_peihuofahuodan["WZ5"]); ?></td>
<td><?php echo ($row["WZ6"])-($row_diaobodingdan["WZ6"])-($row_peihuodingdan["WZ6"])-($row_diaobochuhuodan["WZ6"])-($row_peihuofahuodan["WZ6"]); ?></td>
<td><?php echo ($row["WZ7"])-($row_diaobodingdan["WZ7"])-($row_peihuodingdan["WZ7"])-($row_diaobochuhuodan["WZ7"])-($row_peihuofahuodan["WZ7"]); ?></td>
<td><?php echo ($row["WZ8"])-($row_diaobodingdan["WZ8"])-($row_peihuodingdan["WZ8"])-($row_diaobochuhuodan["WZ8"])-($row_peihuofahuodan["WZ8"]); ?></td>
<td><?php echo ($row["WZ9"])-($row_diaobodingdan["WZ9"])-($row_peihuodingdan["WZ9"])-($row_diaobochuhuodan["WZ9"])-($row_peihuofahuodan["WZ9"]); ?></td>
<td><?php echo ($row["WZ10"])-($row_diaobodingdan["WZ10"])-($row_peihuodingdan["WZ10"])-($row_diaobochuhuodan["WZ10"])-($row_peihuofahuodan["WZ10"]); ?></td>
<td><?php echo ($row["SL"])-($row_diaobodingdan["SL"])-($row_peihuodingdan["SL"])-($row_diaobochuhuodan["SL"])-($row_peihuofahuodan["SL"]); ?></td>
<td><?php echo floor($row_peihuofahuodan["IsAdjust"]); ?></td>
</tr>
<!--循环结束-->
<?php
$row["WZ1"]=0;
$row["WZ2"]=0;
$row["WZ3"]=0;
$row["WZ4"]=0;
$row["WZ5"]=0;
$row["WZ6"]=0;
$row["WZ7"]=0;
$row["WZ8"]=0;
$row["WZ9"]=0;
$row["WZ10"]=0;
$row["SL"]=0;
$row_diaobodingdan["WZ1"]=0;
$row_diaobodingdan["WZ2"]=0;
$row_diaobodingdan["WZ3"]=0;
$row_diaobodingdan["WZ4"]=0;
$row_diaobodingdan["WZ5"]=0;
$row_diaobodingdan["WZ6"]=0;
$row_diaobodingdan["WZ7"]=0;
$row_diaobodingdan["WZ8"]=0;
$row_diaobodingdan["WZ9"]=0;
$row_diaobodingdan["WZ10"]=0;
$row_diaobodingdan["SL"]=0;
$row_peihuodingdan["WZ1"]=0;
$row_peihuodingdan["WZ2"]=0;
$row_peihuodingdan["WZ3"]=0;
$row_peihuodingdan["WZ4"]=0;
$row_peihuodingdan["WZ5"]=0;
$row_peihuodingdan["WZ6"]=0;
$row_peihuodingdan["WZ7"]=0;
$row_peihuodingdan["WZ8"]=0;
$row_peihuodingdan["WZ9"]=0;
$row_peihuodingdan["WZ10"]=0;
$row_peihuodingdan["SL"]=0;
$row_diaobochuhuodan["WZ1"]=0;
$row_diaobochuhuodan["WZ2"]=0;
$row_diaobochuhuodan["WZ3"]=0;
$row_diaobochuhuodan["WZ4"]=0;
$row_diaobochuhuodan["WZ5"]=0;
$row_diaobochuhuodan["WZ6"]=0;
$row_diaobochuhuodan["WZ7"]=0;
$row_diaobochuhuodan["WZ8"]=0;
$row_diaobochuhuodan["WZ9"]=0;
$row_diaobochuhuodan["WZ10"]=0;
$row_diaobochuhuodan["SL"]=0;
$row_peihuofahuodan["WZ1"]=0;
$row_peihuofahuodan["WZ2"]=0;
$row_peihuofahuodan["WZ3"]=0;
$row_peihuofahuodan["WZ4"]=0;
$row_peihuofahuodan["WZ5"]=0;
$row_peihuofahuodan["WZ6"]=0;
$row_peihuofahuodan["WZ7"]=0;
$row_peihuofahuodan["WZ8"]=0;
$row_peihuofahuodan["WZ9"]=0;
$row_peihuofahuodan["WZ10"]=0;
$row_peihuofahuodan["SL"]=0;
}
}
catch (PDOException $e)
{
print "Error!;".$e->getMessage()."<br>";
}
?>
</table>
</body>
</html>
--t2.php--end<<