0 and operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST["center"]."' "; $strorder = " ORDER BY main.deliveryid,main.route,sho.shozokuid,code"; $strsql = " SELECT sho.shozokuid, sho.brand, main.centerid, sho.gyotaiid, main.picktimes, main.ryutu_type as DC_TC, main.code, floor(sum(amari) / 7 + 1) + sum(jo) + (case when sum(amari) > 0 then 0 else -1 end ) as boxqty, main.operatedate , main.deliverdate , main.deliveryid, main.route, '".$userdata["tid"]."' as creater, now() FROM ( SELECT shu.operatedate,shu.picktimes,shu.deliverdate,shu.centerid,shu.shozokuid,shu.shukkaqty ,mod(shukkaqty , sm.irisuu) as amari,irisuu,floor(shukkaqty / sm.irisuu) as jo, sm.ryutu_type,sm.code,shu.deliveryid,shu.route FROM ".$company."shukka as shu INNER JOIN ".$company."shohinmaster as sm USING(shohincd) ".$strwhere." ) as main INNER JOIN ".$company."shozokumaster as sho USING(shozokuid) GROUP BY shozokuid,main.code ".$strorder; $strsql = "INSERT INTO ".$company."shukka_box (shozokuid,brand,centerid,gyotaiid,picktimes,DC_TC,code,boxqty,operatedate,deliverdate,deliveryid,route,creater,createdate) ".$strsql; //$result=mysql_query($strsql,$my_con); //Testecho ($y.mysql_affected_rows()." $errcode ".$strsql); #debug //mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //対象データ取得 if ($_POST[picktimes]=="") { //ピック指定無し $strwhere = " WHERE "; } else { $strwhere = " WHERE shu.picktimes ='$_POST[picktimes]' and "; } $strwhere .= "shu.operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."'"; if ($userdata["kengen"] == 60) { //配送会社 $strwhere .= " and shu.deliveryid='".$userdata["companyid"]."'"; } if ($_POST["deliver"] <> "") { //配送会社 $strwhere .= " and shu.deliveryid='".$_POST["deliver"]."' "; } if (count($_POST["ryutu_type"]) == 1) { //流通型 $strwhere .= " and shu.DC_TC ='".$_POST["ryutu_type"][0]."' "; } //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //所属コード if($_POST[tenpo]<>"") { $strwhere .= " and shu.shozokuid='".$_POST[tenpo]."' "; } //配送業者 $honbudata = 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); /* 納品先単位 { //出荷データ、商品情報 $data1 店舗詳細データdata2 取引明細{data3 　出荷データ商品単位 商品 } } */ //出荷個口データに反映 $strsql ="update `".$company."deliverchange` as a ,`".$company."shukka_box` as b SET b.`deliveryid` = a.deliveryid ,b.route = a.memo3 where a.shozokuid = b.shozokuid and a.operatedate = b.operatedate and b.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__); //納品先、ページ単位の出荷データ $strsql ="SELECT shu.shozokuid,shu.operatedate,shu.deliverdate,shu.deliveryid,address1,address2,address3,tel, postcode,shu.route FROM `".$company."shukka_box` as shu INNER JOIN `".$company."shozokumaster` as sho USING(shozokuid) $strwhere GROUP BY shu.shozokuid,shu.deliverdate ,shu.deliveryid ORDER BY shu.deliveryid,shu.route,shu.shozokuid"; Testecho ($y." $errcode ".$strsql); //最短納品日を取得　実際の納品日が異なっても最短を表示する $strsqlmin ="SELECT min(deliverdate) as deliverdate FROM `".$company."shukka_box` as shu INNER JOIN `".$company."shozokumaster` as sho USING(shozokuid) $strwhere GROUP BY shu.deliverdate"; Testecho ($y." $errcode ".$strsqlmin); $resultmin=@mysql_query($strsqlmin,$my_con); $datamin = mysql_fetch_array($resultmin); ?> <?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) and ($prevdeliveryid <> $data["deliveryid"]) ) or ($line > $pagekaigyo) ) { //改ページの信号プリント echo $header; echo $detail;$detail="";$tatalqty=""; echo $footer; echo "
  
\n"; echo "
  
"; $line=1; } $strsql2 ="SELECT shu.shozokuid, sum(case when DC_TC = 2 then 0 when code=0 then boxqty else 0 end) as codeD0, sum(case when DC_TC = 2 then 0 when code=1 then boxqty else 0 end) as codeD1, sum(case when DC_TC = 2 then 0 when code=2 then boxqty else 0 end) as codeD2, sum(case when DC_TC = 1 then 0 when code=0 then boxqty else 0 end) as codeT0, sum(case when DC_TC = 1 then 0 when code=1 then boxqty else 0 end) as codeT1 FROM `".$company."shukka_box` as shu $strwhere AND shu.shozokuid = '".$data["shozokuid"]."' AND shu.operatedate = '".$data["operatedate"]."' AND shu.deliverdate = '".$data["deliverdate"]."' AND shu.deliveryid = '".$data["deliveryid"]."' GROUP BY shu.shozokuid "; Testecho ($y." $errcode ".$strsql2); $result2=@mysql_query($strsql2,$my_con); $data2 = mysql_fetch_array($result2); $header = "
"; $header .= "
"; $header .= "
配送個口数　検品表
"; $header .= "
"; $header .= "
"; $header .= " ".date("発行日 Y 年 m 月 d 日 ").$weekday[date("w")]."
"; $header .= " ".date("納品日 Y 年 m 月 d 日 ",strtotime($datamin["deliverdate"])).$weekday[date("w",strtotime($datamin["deliverdate"]))]."
"; $header .= "

発行元：".$honbudata[0][0]."

"; $header .= " 〒".$honbudata[0][1].$honbudata[0][2].$honbudata[0][3].$honbudata[0][4]."
"; $header .= " TEL:".$honbudata[0][5]." FAX:".$honbudata[0][6]; $header .= "
"; $header .= "
"; $header .= "

".GetList($deliverdata,$data["deliveryid"])."御中

"; $header .= "

お世話になります。下記商品の納品をお願いいたします。

"; $header .= "

作業日：".str_replace("-","/",$data["operatedate"])."

"; $header .= "

納品日：".str_replace("-","/",$datamin["deliverdate"])."

"; $header .= "
"; // $header .= "
"; // //商品明細テーブルヘッダ $header .= "
"; $header .= ""; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $header .= " "; $detail .= "\n"; $detail .= " \n"; $detail .= " \n"; $detail .= " \n"; $detail .= " \n"; if($printqtyflg == 2) {$data2["codeD0"] = "";$data2["codeD1"] = "";$data2["codeD2"] = "";$data2["codeT1"] = "";$data2["codeT2"] = ""; } $detail .= " \n"; $detail .= " \n"; $detail .= " \n"; $detail .= " \n"; $detail .= " \n"; $total = $data2["codeD0"] + $data2["codeD1"] + $data2["codeD2"] + $data2["codeT0"] + $data2["codeT1"]; $tatalqty[0] += $data2["codeD0"];$tatalqty[1] += $data2["codeD1"];$tatalqty[2] += $data2["codeD2"];$tatalqty[3] += $data2["codeT1"];$tatalqty[4] += $data2["codeT2"];$tatalqty[5] += $total; if($printqtyflg == 2) {$total = "";} $detail .= " \n"; $detail .= "\n"; if($printqtyflg == 2) {$tatalqty = ""; } $footer = "\n"; $footer .= " \n"; $footer .= " \n"; $footer .= " \n"; $footer .= " \n"; $footer .= " \n"; $footer .= " \n"; $footer .= " \n"; $footer .= "\n"; $footer .="
No.配送会社ルート配送先".GetList($codedata,0,0)."".GetList($codedata,1,0)."".GetList($codedata,2,0)."通過
".GetList($codedata,0,0)."		通過
".GetList($codedata,1,0)."		合計
$line "; $detail .= GetList($deliverdata,$data["deliveryid"])." ".$data["route"]." [".$data["shozokuid"]."] "; $detail .= GetList($tenpodata,$data["shozokuid"]); $detail .= "
     ".$data["postcode"]." ".$data["address1"].$data["address2"].$data["address3"]."
TEL:".$data["tel"]."
".$data["memo2"]."
".str_replace(".0","",$data2["codeD0"])."".str_replace(".0","",$data2["codeD1"])."".str_replace(".0","",$data2["codeD2"])."".str_replace(".0","",$data2["codeT0"])."".str_replace(".0","",$data2["codeT1"])."".str_replace(".0","",$total)."
合計
".str_replace(".0","",$tatalqty[0])."".str_replace(".0","",$tatalqty[1])."".str_replace(".0","",$tatalqty[2])."".str_replace(".0","",$tatalqty[3])."".str_replace(".0","",$tatalqty[4])."".str_replace(".0","",$tatalqty[5])."
"; $footer .="
"; $footer .=""; $line++; $prevdeliveryid = $data["deliveryid"]; $prevroute = mb_substr($data["route"],0,3); $page++; } //最後のページ echo $header; echo $detail;$detail=""; echo $footer; ?> 対象データがありません。