"") { $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]; } $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",-1); } elseif($_POST[brand] <> "") { $brand =$_POST["brand"]; $strsqlbrand = " and brand='$brand'"; } else { } //対象範囲 $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(distinct(ordermainid))","`".$company."shukka`","DC_TC in (1,2) AND 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 = ''"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$strsql); //debug //supplyer無しは埋める $strsql = "update `".$company."shukka` as shu,`".$company."shohinmaster` as sm SET shu.supplyerid = sm.makercode WHERE shu.shohincd = sm.shohincd AND ( shu.supplyerid = '' or shu.supplyerid is NULL) and shu.operatedate > DATE_ADD( CURDATE() , INTERVAL -5 DAY )"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); $errcode =mysql_errno();if ($errcode <> 0) {echo "shukka No supplyerid colomun";}; Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$strsql); //debug //在庫品はDC_TC=1で統一 $strsql = "update `".$company."shukka` as shu,`".$company."shohinmaster` as sm SET shu.DC_TC = sm.ryutu_type WHERE sm.shohincd = shu.shohincd AND DC_TC = 0 and shu.operatedate > DATE_ADD( CURDATE() , INTERVAL -5 DAY )"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("LINE ".__LINE__." ROWS=".mysql_affected_rows()." ".$strsql); //debug $orderdata=dbselect("c.date,c.date,ifnull(cnt,0) as cnt2","`calendar` as c LEFT JOIN (SELECT operatedate ,count(v.orderid) as cnt FROM `v_order` as v WHERE operatedate > DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) $strsqlcenter $strsqlbrand GROUP BY operatedate) as v2 ON(c.date = v2.operatedate)", "c.`date` between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY ) ","c.date desc",-1); } Testecho ("LINE:".__LINE__.$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"]; Testecho ($strsqldbselect); } //回数リスト 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); } if(sizeof($batchdata) == 0){$batchdata = array("1","1");} Testecho ($strsqldbselect ); //ロケーション印刷するしない $locationselectdata=array(array("する","1"),array("しない","2")); //サプライヤー以外はDataSet()のデータを上書き $strsqlx = "SELECT distinct(supplyerid) FROM `".$company."ordermain` as om INNER JOIN `".$company."ordersheet` as os USING(ordermainid) WHERE om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter." UNION SELECT distinct(supplyerid) FROM `".$company."shukka` WHERE operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter; $strsqlx = dbselectin($strsqlx,"companyid in "); if ($userdata["supplyerid2"] == ""){ $makerdata = dbselect("companyname,companyid","`company` as c",$strsqlx,-1,-1); Testecho ($strsqldbselect); // $makerdata[] = array('イーシップ','eshipsup'); } else { $makerdata = dbselect("companyname,companyid","`company`"," companyid in (".$userdata["supplyerid2"].") ",-1,-1); } //納品先以外はDataSet()のデータを上書き if ($userdata["kengen"] <> 50) { $strsqltenpo = "SELECT distinct(shozokuid) FROM `".$company."ordermain` as om INNER JOIN `".$company."ordersheet` as os USING(ordermainid) WHERE om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter." UNION SELECT distinct(shozokuid) FROM `".$company."shukka` WHERE 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); //ステータス $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); //通過品の重複は削除する $strsql = " DELETE FROM ".$company."shukka where shukkaid in ( SELECT joken.id from( SELECT max(shukkaid) as id ,count(shukkaid) as cnt,orderid FROM `".$company."shukka` WHERE DC_TC=2 and orderid > 0 group by orderid having cnt>1) as joken )"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($strsql." ROWS=".mysql_affected_rows().$_SERVER['SCRIPT_NAME'].":".__LINE__); 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; } ?>

出力条件 1) { ?>
センター
作業日
業態区分A
バッチ
納品先
サプライヤー
温度帯 ".$codedata[$i][0].""; } ?>
在庫区分 在庫型 通過型
配送
配送一覧 >ルート別発行
帳票まとめ 複数サプライヤーをまとめる
帳票・データ出力
0)) echo "disabled";?>> 0)) { } else {echo "disabled";} ?>> > > >
0)) echo "disabled";?>> 0)) { } else {echo "disabled";}?>> > >
> > 0)) or ($statusdata<4)) echo "disabled";?>> 0)) or ($statusdata<4)) echo "disabled";?>>
> > > > 0)) or ($statusdata<5)) echo "disabled";?>> > > > > > > > >
> >
> > >
> >
0) or (!(FunctionUseCheck("5574")))) echo "disabled";?>>
> >
> > >

INFORMART