'' 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__); //サプライヤー $whereselectin = "SELECT distinct(supplyerid) FROM `".$company."shukka` WHERE DC_TC in (1,2) AND operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND centerid='".$_POST[center]."'"; $strsqlwhere = dbselectin($whereselectin,"companyid in "); $makerdata = dbselect("companyname,companyid","company",$strsqlwhere,-1,-1); //対象データ取得 if ($_POST[picktimes]=="") { //ピック指定無し $strwhere = " WHERE "; } elseif($_POST[id] <> "") { //引当状況確認からの遷移は緊急分も出す $strwhere = " WHERE shu.picktimes IN ('$_POST[picktimes]',99) and "; } else { $strwhere = " WHERE shu.picktimes ='$_POST[picktimes]' and "; } $strwhere .= " shu.DC_TC < 3 AND shu.shukkaqty>0 and shu.operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."'"; //表示順 商品順 ロケーションの最小 $strorder = " ORDER BY sho.route,shozokuid,shohincd"; $strorder2 = " ORDER BY sho.route,shozokuid,pagenumber"; $strorder3 = " ORDER BY sho.deliveryid,sho.route,sho.address1,shozokuid,pagenumber"; //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //オプション $codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104 and code > 0","codeid",-1); //所属コード if($_POST[tenpo]<>"") { $strwhere .= " and shozokuid='".$_POST[tenpo]."' "; } //出荷データにページ番号挿入 納品先単位の出荷データ数 $strsql ="SELECT shukkaid,shozokuid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) ".$strwhere." ORDER BY shozokuid,sho.code desc,loccode,shohincd"; $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 - 1)) { //行数が改ページに達していたら $page++; $line=1; } else { $line++; } $prevshozokuid = $data[shozokuid]; $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__); } /* 納品先単位 { //出荷データ、商品情報 $data1 店舗詳細データdata2 取引明細{data3 　出荷データ商品単位 商品 } } */ //納品先、ページ単位の出荷データ $strsql ="SELECT shu.operatedate,shu.shukkadate,shu.shozokuid,shu.pagenumber,`tenpoid`, `shozokuname`, `postcode`, `address1`, `address2`, `address3`, `tel`, `fax`, sho.route,`shu`.`deliveryid` ,shu.memo4,shu.memo2 FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ".$strwhere." GROUP BY shu.shozokuid,pagenumber ".$strorder3; Testecho ($y." $errcode ".$strsql); //配送業者 $deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companykind in ('30','60')",-1,-1); //温度帯 $codedata1 = dbselect("cname,code","`".$company."code`","codekind = 1","cname",-1); ?> <?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; } ?>
出荷日:　
No.1--

  
 
\n"; //テーブルヘッダ echo "\n"; echo ""; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; $strshohin_head2 = "\n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; // $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= "\n"; echo $strshohin_head2;$strshohin_head2=""; //賞味期限、入荷待ち単位の出荷データ（商品グロス+商品マスタ） $strsql2 = "SELECT shu2.shohincd,sum(shu2.shukkaqty) as shukkaqty,shu2.pagenumber,shu2.supplyerid,shu2.orderid,shu2.memo,shu2.memo2,shu.loccode,shu.shomi,shu.zanzaiko FROM `".$company."shukka` as shu2,`".$company."shukka` as shu WHERE shu2.shozokuid='".$data["shozokuid"]."' AND shu.shukkaid=shu2.shukkaid and shu2.pagenumber='".$data["pagenumber"]."' and shu2.operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) AND shu.picktimes ='$_POST[picktimes]' GROUP BY shohincd,supplyerid "; $strsql2 = "SELECT shu.*,sho.shohinmei, irisuu,aisuu,sho.code,ryutu_type, kikaku,nisugata,price_sell,sho.centernisugata,sho.shomiflg,shohin_string2,sho.makercode FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) ORDER BY sho.code desc,shu.loccode,shu.shohincd"; $totalamount = 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)) { $strshohin_head1 = "\n"; $strshohin_head1 .= " \n"; $strshohin_head1 .= " \n"; $strshohin_head1 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= "\n"; $strshohin_head2 .= "\n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= "\n"; //出荷総数 $intshohingross += (int)$data["shukkaqty"]; echo $strshohin_head1; echo $strshohin_head2; if($data2["supplyerid"] == "") {$data2["supplyerid"] = $data2["makercode"]; } //商品詳細を格納 $strshohin_detail ="\n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; //$strshohin_detail .=" \n"; $strshohin_detail .=""; if ($chgflg==1) { echo ""; } // echo $strshohin_detail; //賞味出荷データ（納品先グロス） $strsql3 = "SELECT sum(shukkaqty) as shukkaqty, loccode,shomi,memo,memo2,memoadd,price_piece FROM `".$company."shukka` AS shu ".$strwhere." AND shozokuid = '".$data["shozokuid"]."' AND shohincd ='".$data2["shohincd"]."' AND pagenumber ='".$data["pagenumber"]."' GROUP BY memo,memo2,memoadd"; $result3=@mysql_query($strsql3,$my_con); Testecho ("LINE ".__LINE__." ".$y." ".$strsql3); //debug mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__); while ($data3 = mysql_fetch_array($result3)) { //商品詳細を格納 $strshohin_detail ="\n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; //$strshohin_detail .=" \n"; $strshohin_detail .=""; if ($chgflg==1) { echo ""; } //商品詳細を出力 echo $strshohin_detail; } $i++; $line++; } $page++; ?>
 商品コード
 商品名		規格  
   特記オプション価格単位数量

".$data2["shohincd"]."　".GetList($codedata1,$data2[code])."

"."

計".str_replace(".0","",$data2["shukkaqty"]); $strshohin_head2 = "".$data2["kikaku"]."
 
".$data2["shohinmei"]."

 

".$data2["loccode"]."

".$data2["memo"].GetList($codedata104,$data2["memo2"]).GetListData($makerdata,$data2["supplyerid"],0)."xxx

"; $inttotalbara=(int)$data2["shukkaqty"] ; //総バラ数 $intaisuu = floor($inttotalbara / ($data2["aisuu"]*$data2["irisuu"])); //合数 $intcase = floor(($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) / $data2["irisuu"]); //ケース $intbara = ($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) % $data2["irisuu"]; //バラ if ($intaisuu==0) {$intaisuu=" ";} if ($intcase==0) {$intcase=" ";} if ($intbara==0) {$intbara=" ";} $strshohin_detail .="

".str_replace(".0","",$data2["shukkaqty"])."".$data2["kikaku"]."".$data2["zanzaiko"]."".$data2["nisugata"]."

".$data3["memo"].$data3["memoadd"]."

".GetList($codedata104,$data3["memo2"]).GetListData($makerdata,$data2["supplyerid"],0)."

"; $inttotalbara=(int)$data3["shukkaqty"]; //総バラ数 $intaisuu = floor($inttotalbara / ($data2["aisuu"]*$data2["irisuu"])); //合数 $intcase = floor(($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) / $data2["irisuu"]); //ケース $intbara = ($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) % $data2["irisuu"]; //バラ if ($intaisuu==0) {$intaisuu=" ";} if ($intcase==0) {$intcase=" ";} if ($intbara==0) {$intbara=" ";} $strshohin_detail .="

@ ".number_format($data3["price_piece"],0)."

".$data3["memo3"]."

".$data2["shohin_string2"]."

".str_replace(".0","",$data3["shukkaqty"])."".$data2["kikaku"]."".$data3["zanzaiko"]."".$data3["nisugata"]."
対象データがありません。 "); #debug ?>