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 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 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 FROM `".$company."shukka` AS shu INNER JOIN `".$company."ordermain` AS om USING(ordermainid) WHERE nagase_flg = 0 AND ".$strwhere.$strsqlpick.$strsqlmaker.$strsqltenpo." GROUP BY ordermainid,pagenumber ".$strorder; Testecho ($y." $errcode ".$strsql); ?> <?php//echo $systemname; ?> 印刷日:<?php echo date("Y/m/d"); ?>
$intpagekaigyo) {$intpage++; $intline = 1;} if($intpage >1) { if($intline == 1) { echo "\n\n"; echo "
  
\n"; echo "
  
"; } } if($intline == 1) { ?>
 
 
 
 
 
 
No.
届け先
詳細
【数量】商品
確認
7) { echo "12"; } else { echo "16"; } ?>">



""){ echo strftime("%G年%m月%d日 (%a)",strtotime($data["deliverdate"]));} else {echo "指定日なし";} ?> 
"; } ?>
"") { echo "【お客様】".$data["memo"] ;} ?> "") { echo "
【業務連絡】".$data["memo2"] ;} ?> "") { echo "
【配送連絡】".$data["memo3"] ;} ?> 0 ) { echo "
【広告媒体】".GetList($codedata93,$data["ad_kubun"],0) ;} ?>
対象データがありません。