"") { $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; } ?>

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

INFORMART