"") { $pictimes = $_POST["picktimes"]; } else { //バッチ回数取得 $batchdata = dbselect("picktimes,picktimes","`".$company."shukka`","operatedate = CURDATE() GROUP BY picktimes","picktimes desc",-1); if (sizeof($batchdata)>0) { //現在のピック数+1 $pictimes = $batchdata[0][0]; } else { $pictimes = 1; } } if($_POST["center"]<>"") { $centerid=$_POST["center"]; } else { $centerid = $centerdata[0][1]; } Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); $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 { } //対象範囲 $startday2 = -62; $endday2 = 10; //データ整理 $strsql8="UPDATE `".$company."ordermain` as om SET shozokuid = '0' WHERE (shozokuid is null or shozokuid ='') and operatedate = DATE_ADD(CURDATE(),INTERVAL $startday2 DAY)"; $result8=@mysql_query($strsql8,$my_con); $row8=@mysql_num_rows($result8); mysql_sql_log2($strsql8,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //データ整理 /*$strsql8="UPDATE `".$company."shohinmaster` as sm, `".$company."shukka` as shu SET shu.supplyerid = sm.makercode WHERE (shu.supplyerid is null or shu.supplyerid ='') and operatedate = DATE_ADD(CURDATE(),INTERVAL $startday2 DAY)"; $result8=@mysql_query($strsql8,$my_con); $row8=@mysql_num_rows($result8); mysql_sql_log2($strsql8,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec");*/ $strsql8="UPDATE `".$company."shukka` as shu SET deliverdate = null WHERE deliverdate='0000-00-00' and operatedate >= DATE_ADD(CURDATE(),INTERVAL $startday2 DAY)"; $result8=@mysql_query($strsql8,$my_con); $row8=@mysql_num_rows($result8); mysql_sql_log2($strsql8,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //出荷データ 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(distinct(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("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 ) $strsqlcenter $strsqlbrand GROUP BY operatedate","operatedate desc",-1); $orderdata=dbselect("date,date,cnt","calendar as c left join (SELECT operatedate,count(shukkaid) as cnt FROM `".$company."shukka` WHERE operatedate >= DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) $strsqlcenter $strsqlbrand GROUP BY operatedate) as shu on (shu.operatedate = c.date) ","c.date between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY )","c.date desc",-1); } Testecho ($strsqldbselect); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); 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"]; } Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //回数リスト if($settingdata["ecommerce_pictimes"] >= 1) { $batchdata = dbselect("concat(picktimes,'回目:',count(distinct(ordermainid)),'件:',createdate),picktimes","`".$company."shukka`","operatedate = DATE_ADD( CURDATE() , INTERVAL $operatedate DAY ) 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 ) GROUP BY picktimes","picktimes desc",-1); } Testecho ($strsqldbselect ); //ロケーション印刷するしない $locationselectdata=array(array("する","1"),array("しない","2")); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //サプライヤー以外はDataSet()のデータを上書き if ($userdata["kengen"]<>40) { $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 $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter; Testecho ($strsqlmaker); $makerdata = dbselect("companyname,companyid","`company`",dbselectin($strsqlmaker,"companyid in "),-1,-1); Testecho ($strsqldbselect); } Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //納品先以外はDataSet()のデータを上書き if ($userdata["kengen"] <> 50) { $strsqltenpo = "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; 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); Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); //ステータス $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; } 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; } Testecho ("LINE:".__LINE__." Time:".microtime()." μsec =1/100万 sec"); ?>