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