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);
?>
印刷日:
$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)."" ;} ?> |
対象データがありません。