0 AND "; } else { $strwhere = " WHERE shu.shozokuid <> 0 AND shu.picktimes ='$_POST[picktimes]' and "; } $strwhere .= " (shukkaqty>0 or memo<>'') and operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."'"; //表示順 商品順 ロケーションの最小 $strorder = " ORDER BY shozokuid,shohincd"; $strorder2 = " ORDER BY shu.deliveryid,shu.route,shozokuid,pagenumber"; //出荷データに反映 $strsql = "UPDATE `".$company."deliverchange` AS dc, `".$company."shukka` AS s SET s.deliveryid = dc.deliveryid,s.memo4 = dc.memo1,s.memo2 = dc.memo2 ,s.route = dc.memo3 WHERE dc.shozokuid <>'' and dc.shozokuid = s.shozokuid AND s.operatedate = dc.operatedate AND s.operatedate = DATE_ADD(CURDATE() , INTERVAL ".$_POST[chgday]." DAY )"; $result=mysql_query($strsql,$my_con); $errcode =@mysql_errno(); Testecho ($y.$strsql."
"); #debug mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //所属コード if($_POST[tenpo]<>"") { $strwhere .= " and shu.shozokuid='".$_POST[tenpo]."' "; } //配送会社 if ($userdata["kengen"] == 60) { $strwhere .= " and shu.deliveryid='".$userdata["companyid"]."'"; } elseif($_POST[deliver]<>"") { $strwhere .= " and shu.deliveryid='".$_POST[deliver]."' "; } //配送業者 $honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax","company","companyid='".$userdata["companyid"]."'",-1,-1); $honbudata2 = dbselect("companyname,postcode,address1,address2,address3,tel,fax","company","companyid='".$userdata["hcompanyid"]."'",-1,-1); $deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companykind in ('30','60')",-1,-1); //配送会社変更データ $datadelivery = dbselect("deliverchangeid,shozokuid,deliveryid,memo1,memo2,memo3","`".$company."deliverchange`","operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY )",-1,-1); //出荷データにページ番号挿入 納品先単位の出荷データ数 $strsql ="SELECT shukkaid,shozokuid FROM `".$company."shukka` AS shu ".$strwhere." ".$strorder; $result=@mysql_query($strsql,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); $line = 1;$page=1;//処理行数/ページ while ($data = mysql_fetch_array($result)) { if($data[shozokuid]<>$prevshozokuid){ //所属IDが変わったら改ページ $page = 1; $line=1; } elseif($line>$pagekaigyo) { //行数が改ページに達していたら $page++; $line=1; } else { $line++; } $strsql2 ="UPDATE `".$company."shukka` SET pagenumber=".$page." WHERE shukkaid='".$data[shukkaid]."'"; Testecho ("LINE ".__LINE__." ".$y." ".$strsql2); //debug $result2=@mysql_query($strsql2,$my_con); mysql_sql_log($strsql2,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } if ($userdata["kengen"] == 60) { $strwhere .= " and shu.deliveryid='".$userdata["companyid"]."'"; }/* 納品先単位 { //出荷データ、商品情報 $data1 店舗詳細データdata2 取引明細{data3 　出荷データ商品単位 商品 } } */ if ($_POST[deliver]<>"") { $strwhere .= " AND shu.deliveryid ='".$_POST[deliver]."'"; } //納品先、ページ単位の出荷データ $strsql ="SELECT shu.operatedate,shu.shukkadate,shu.shozokuid,shu.centerid,shu.pagenumber,shu.deliverdate,shu.memo2,shu.memo4,`tenpoid`, `shozokuname`, `postcode`, `address1`, `address2`, `address3`, `tel`, `fax`, `shu`.`route`, `shu`.`deliveryid` ,sum(shukkaqty) as shukkaqty ,`carte`FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ".$strwhere." GROUP BY `shu`.deliveryid,shozokuid,pagenumber ".$strorder2; Testecho ($y." $errcode ".$strsql); ?> <?php echo $systemname; ?> 作業日<?php echo date("Y/m/d",strtotime ("".$_POST[chgday]." day")); ?> - <?php echo $_POST[picktimes] ?>回目 #\n"; for ($i=0;$i<$rows;$i++) { echo "\n"; } ?> ".$data[$i]."\n"; } ?>
------------------------------------------

1) { //改ページの信号プリント echo "
  
\n"; echo "
  
"; $line=1; } $newdelivery ="";$newdelivery[2] = $data["deliveryid"];$newdelivery[4] = $data["carte"] ;$newdelivery[5] = $data["route"]; for ($j = 0; $j < $intchange; $j++) { if($datadelivery[$j][1] == $data["shozokuid"]) { $newdelivery = $datadelivery[$j]; break; } } ?>
 
 
0 or memo<>"") and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' GROUP BY shohincd "; $strsql2 = "SELECT shohincd,SUM(shukkaqty) AS shukkaqty,price_piece,SUM(price_total) AS price_total,pagenumber,orderid,memo FROM `".$company."shukka` WHERE (shukkaqty>0 or memo<>'') and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' and operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) GROUP BY shohincd "; $strsql2 = "SELECT shu.*,sho.shohinmei, sho.code,ryutu_type, kikaku,nisugata,price_sell,makercode,sho.shohincd,irisuu,aisuu FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) ORDER BY shu.shohincd"; $totalamount = 0;$tatalqty = 0; $result2=@mysql_query($strsql2,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql2); //debug mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__); while ($data2 = mysql_fetch_array($result2)) { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $totalamount += $data2["price_sell"]*$data2["shukkaqty"]; echo " \n"; $tatalqty += $data2["shukkaqty"]; echo "\n"; $line++; } echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; $page++; ?>
No.
コード
商品名
規格
入
合
集荷数
$line ".$data2["shohincd"]." ".$data2["shohinmei"]." ".$data2["kikaku"]."".$data2["irisuu"]."".$data2["aisuu"]."
".number_format($data2["shukkaqty"],0)."
合計
".number_format($tatalqty,0)."

.

対象データがありません。 "); #debug ?>