0 and shu.operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) "; //$strwhere .= " shu.shukkaqty > 0 and shu.operatedate >= DATE_ADD( CURDATE() , INTERVAL -5 DAY ) "; if ($_POST[picktimes]=="") { //ピック指定無し } else { $strsqlpick = " AND shu.picktimes ='$_POST[picktimes]' "; } //サプライヤーコード if (($_POST[maker]<>"all") and ($_POST[maker]<>"")){ $makerid = $_POST[maker]; $strsqlmaker = " and supplyerid = '".$makerid."' "; } elseif ($userdata["kengen"] == 40) { $makerid = $userdata["companyid"]; $strsqlmaker = " and supplyerid = '".$makerid."' "; } //センターコード if ($_POST[center]<>""){ $strsqlcenter = " and centerid = '$_POST[center]'"; $centerid = $_POST[center]; } else { } //センターコード if ($_POST[tenpo]<>""){ $strsqltenpo = " and shozokuid = '$_POST[tenpo]'"; $shozokuid = $_POST[tenpo]; } else { } //メーカーコード if ($_POST[maker]<>""){ $strsqlmaker = " and makercode = '$_POST[maker]'"; $maker = $_POST["maker"]; } else { } //表示順 $strorder = " ORDER BY FLG desc,shu.ordermainid,shu.ordermainid,pagenumber"; //本部データを取り出す $honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax","company","companyid='nagase'",-1,-1); $kendata = dbselect("kenname,kenid","ken",-1,-1,-1); //配送時間帯データの取得 $codedata17 = dbselect("cname,code","`".$company."code`","codekind = '17'","code",-1); //注文区分データの取得 $codedata21 = dbselect("cname,code","`".$company."code`","codekind = '21'","code",-1); //AD区分 $codedata93 = dbselect("cname,code","`".$company."code`","codekind = 93","codeid",-1); //納品先、ページ単位の出荷データ $strsql ="SELECT om.yamatoid, (case when pay_kubun = 2 then 1 else 2 end) as FLG ,shu.operatedate,shu.shukkadate,shu.ordermainid,shu.operatedate, `name`, om.namekana, `postcode`, `address1`, `address2`, `address3`, `address4`, `tel`, `receipt_name` ,om.`deliverdate`,om.`delivertime` ,sum(price_total) as price_total,om.receipt_shohinmei,om.pay_kubun,om.orderkubun ,om.orderid2,om.memo,om.memo2,om.memo3,om.ad_kubun ,om.nagase_flg,om.customerid,om.inputdatetime FROM `".$company."shukka` AS shu INNER JOIN `".$company."ordermain` AS om USING(ordermainid) WHERE nagase_flg in( 0,1) AND ".$strwhere.$strsqlpick.$strsqlmaker.$strsqltenpo." GROUP BY ordermainid,nagase_flg,pagenumber ".$strorder; Testecho ($y." $errcode ".$strsql); ?> <?php//echo $systemname; ?> 印刷日:<?php echo date("Y/m/d"); ?>
$intpagekaigyo) {$intpage++; $intline = 1;} if($intcnt >1) { if($nagaseflg <> $data[nagase_flg]) {$intline = 1;$intcnt = 1;} if($intline == 1) { echo "\n\n"; echo "
  
\n"; echo "
  
"; } } // if($nagaseflg <> $data[nagase_flg]) {$intpage = 1; } $nagaseflg = $data[nagase_flg]; if($intline == 1) { ?>
   
No.
届け先
詳細
【数量】商品 ★は代引
確認
12) { echo "14"; } else { echo "18"; } ?>">


【配送】 ""){ echo strftime("%m月%d日 (%a)",strtotime($data["deliverdate"]));} else {echo "指定日なし";} ?> 
【処理】 ID:
"; $intTotalPrice += $data2["price_total"]; } echo "
"; if($data["FLG"] == "1"){ echo "★"; } echo " ".number_format($intTotalPrice)." 円
"; ?>
"") { echo "【お客様】".$data["memo"]."" ;} else { echo ""; } ?> 
"") { echo "【業務連絡】".$data["memo2"]."" ;} else { echo ""; } ?> 
"") { echo "【配送連絡】".$data["memo3"]."" ;} ?> 
0 ) { echo "【広告媒体】".GetList($codedata93,$data["ad_kubun"],0) ;} ?> 
 
 
"") { echo "【ヤマト伝票】".substr($data["yamatoid"],0,4)." ".substr($data["yamatoid"],4,4)." ".substr($data["yamatoid"],8,4)."" ;} ?>
対象データがありません。