"") {
$centerid=$_POST["center"];
} else {
$centerid = $centerdata[0][1];
if($company == "ha_") {
$centerid = "W2";
}
}
//業態IDのセット
if($_POST["gyotai"]=="") {
$gyotai=$gyotaidata[0][1];
} else {
$gyotai=$_POST["gyotai"];
}
if($_POST["picktimes"] <> "") {
$pictimes = $_POST["picktimes"];
} else {
//バッチ回数取得
if($userdata["brand"] <> "") {
$batchdata = dbselect("picktimes,picktimes","`".$company."shukka`","operatedate = CURDATE() and centerid = '".$centerid."' and brand in (".$userdata["brand"].") GROUP BY picktimes","picktimes desc",-1);
} else {
$batchdata = dbselect("picktimes,picktimes","`".$company."shukka`","operatedate = CURDATE() and centerid = '".$centerid."' GROUP BY picktimes","picktimes desc",-1);
}
Testecho (__LINE__.$strsqldbselect);
if (sizeof($batchdata)>0) {
//現在のピック数+1
$pictimes = $batchdata[0][0];
} else {
$pictimes = 1;
}
}
$strsqlcenter = " and centerid='$centerid'";
if($userdata["brand"] <> "") {
$brand = $userdata["brand"];
$strsqlbrand = " and brand in ($brand)";
$tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlshozoku,"shozokuid",-1);
} elseif($_POST[brand] <> "") {
$brand =$_POST["brand"];
$strsqlbrand = " and brand='$brand'";
} else {
}
Testecho (__LINE__.$strsqldbselect);
//対象範囲
$startday2 = -62;
$endday2 = 10;
//出荷データ
if($company == "body_") {
$orderdata=dbselect("operatedate,operatedate,count(orderid)","`".$company."ordermain` INNER JOIN `".$company."ordersheet` USING(ordermainid) ","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY ) and shohincd like '%D%' $strsqlcenter $strsqlbrand GROUP BY operatedate","operatedate desc",-1);
} elseif($settingdata["ecommerce_pictimes"]== 1) {
$orderdata=dbselect("operatedate,operatedate,count(ordermainid)","`".$company."shukka`","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY ) $strsqlcenter $strsqlbrand GROUP BY operatedate","operatedate desc",-1);
} else {
//ordermainブランド無しは埋める
$strsql = "update `".$company."ordermain` as om,`".$company."shozokumaster` as sho SET om.brand = sho.brand where om.shozokuid = sho.shozokuid and om.brand = ''";
Testecho ($strsql);
$result=mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
$orderdata=dbselect("c.date,c.date","calendar as c","c.date between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY )","c.date desc",-1);
}
Testecho ($strsqldbselect);
if(($_POST[chgday]<>"") and ($centerid==$_POST[oldcenter])){
$startday = $_POST[chgday];
$endday = $_POST[chgday];
$operatedate = $_POST[chgday];
} elseif($settingdata["ecommerce_pictimes"]== 1) {
//注文予定がある場合は過去日で最新の日付をデフォルトとする
$interval = getdate_diff($orderdata[0][1],date("Y-m-d"));
$operatedate = $interval["days"];
$startday = $interval["days"];
$endday = $interval["days"];
} elseif(sizeof($orderdata)>0) {
//注文予定がある場合は過去日で最新の日付をデフォルトとする
$orderdatatemp=dbselect("operatedate,operatedate,count(orderid)","`".$company."ordermain` INNER JOIN `".$company."ordersheet` USING(ordermainid) ","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and CURDATE() $strsqlcenter GROUP BY operatedate","operatedate desc",-1);
$interval = getdate_diff($orderdatatemp[0][1],date("Y-m-d"));
$operatedate = $interval["days"];
$startday = $interval["days"];
$endday = $interval["days"];
}
//回数リスト
if($settingdata["ecommerce_pictimes"]== 1) {
$batchdata = dbselect("concat(picktimes,'回目:',count(distinct(ordermainid)),'件:',createdate),picktimes","`".$company."shukka`","operatedate = DATE_ADD( CURDATE() , INTERVAL $operatedate DAY ) and centerid = '".$centerid."' GROUP BY picktimes","picktimes desc",-1);
Testecho ($strsqldbselect);
$pictimes = $batchdata[0][1];
} else {
// $batchdata = dbselect("picktimes,picktimes","`".$company."shukka`","operatedate = DATE_ADD( CURDATE() , INTERVAL $operatedate DAY ) and centerid = '".$centerid."' GROUP BY picktimes","picktimes desc",-1);
}
Testecho ($strsqldbselect );
//ロケーション印刷するしない
$locationselectdata=array(array("する","1"),array("しない","2"));
//サプライヤー以外はDataSet()のデータを上書き
if ($userdata["supplyerid2"]<>"") {
$int1 = $startday - 2;
$int2 = $endday + 2;
$strsqlmaker = "SELECT distinct(makercode) FROM `".$company."ordersheet` as os,`".$company."ordermain` as om,`".$company."shohinmaster` as sm WHERE os.ordermainid=om.ordermainid and os.shohincd = sm.shohincd and om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $int1 DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $int2 DAY )".$strsqlcenter;
Testecho ($strsqlmaker);
$makerdata = dbselect("companyname,companyid","`company`",dbselectin($strsqlmaker,"companyid in "),-1,-1);
Testecho ($strsqldbselect);
$makerdata[] = array('イーシップ','eshipsup');
}
//納品先以外はDataSet()のデータを上書き
if ($userdata["kengen"] <> 50) {
$strsqltenpo = "SELECT c.shozokuid FROM (SELECT distinct(shozokuid) FROM `".$company."ordermain` as om WHERE om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter;
$strsqltenpo .= " UNION SELECT distinct(shozokuid) FROM `".$company."shukka` as shu WHERE shu.deliverdate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter.") as c";
Testecho ($strsqltenpo);
$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",dbselectin($strsqltenpo," shozokuid in ").$strsqlbrand,"shozokuid",-1);
Testecho ($strsqldbselect);
}
//配送業者
if ($userdata["kengen"] == 60) { //10Tradex,20本部、30センター、40サプライヤー、50納品先、60配送業者、 70工場
$deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companyid = ('".$userdata["companyid"]."')",-1,-1);
} else {
$deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companykind in ('60')",-1,-1);
}
//update cool_shukka as a,cool_shozokumaster as b set a.brand = b.brand where a.shozokuid = b.shozokuid;update cool_ordermain as a,cool_shozokumaster as b set a.brand = b.brand where a.shozokuid = b.shozokuid
$branddata = dbselect("code,cname,count(orderid)","`".$company."ordermain` as o INNER JOIN `".$company."ordersheet` USING(ordermainid) ,`".$company."code` as c","operatedate = DATE_ADD( CURDATE() , INTERVAL ".$operatedate." DAY ) $strsqlcenter and codekind = '105' and o.brand = c.code GROUP BY brand","brand desc",-1);
//ステータス
$statusdata = dbselect("status,picktimes,statusid","`".$company."status`","operatedate = DATE_ADD( CURDATE() , INTERVAL ".$operatedate." DAY )".$strsqlcenter,"status desc",1);
Testecho ($strsqldbselect);
$statusid = $statusdata[0][2];
$statusdata = (int)$statusdata[0][0];
//暫定 生鮮は当日すべての出荷帳票出力可能
if(($company == "cool_") and ($operatedate == 0)) {
$statusdata = 6;
//暫定
$strsqlzantei = "update `cool_shukka` set picktimes = 1 where picktimes = 0";
$result=mysql_query($strsqlzantei,$my_con);
Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsqlzantei."
"); #debug
mysql_sql_log($strsqlzantei,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
}
Testecho("STATUS=". $statusdata);
if ($_POST[dl3] <>""){
$strdate = Sjis("出荷ラベルデータ.csv");
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=$strdate");
header("Connection: close");
ob_end_clean();
echo Sjis("配送会社,\"ルートNo\",\"納品コード\",\"納品先名\",\"温度帯\"")."\n";
#データ取得
$result=@mysql_query($strsql,$my_con);
$i=1;
while ($data = mysql_fetch_array($result)) {
echo $i.",";
echo Sprint(GetList($centerdata,$data[centerid]));
echo Sprint($data[shozokuid]." ".GetList($tenpodata2,$data[shozokuid]));
echo Sprint(GetList($makerdata,$data[makercode]));
echo Sprint($data["shohincd"]);
echo Sprint($data["shohincd2"]);
echo Sprint($data["shohinmei"]);
echo Sprint($data["orderqty"]);
echo Sprint($data["operatedate"]);
switch($data["checkedflg"]) {
case 1:
echo Sprint("1.注文中");
break;
case 2:
echo Sprint("2.発注締め済み");
break;
case 3:
echo Sprint("3.受注承認済み");
break;
case 4:
echo Sprint("4.発送締め済み");
break;
case 5:
echo Sprint("5.出荷確定済み");
break;
case 6:
echo Sprint("6.納品締め済み");
break;
default:
echo Sprint("");
}
echo Sprint($data["memo"]);
echo "\n";
$i++;
}
myclose();
exit;
}
?>