""){ $refdate = (int)$_POST[chgday]; //本日からの経過時間 } elseif ($_GET[chgday] <> ""){ $refdate = (int)$_GET[chgday]; //本日からの経過時間 } else { $refdate = 0; } //納品先の絞込み //ブランド if($userdata[brand] <> "") { $whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")"; $strwhereshozoku = dbselectin($whereselectin," and shu.shozokuid in "); // $tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlshozoku,"shozokuid",-1); } //メーカー絞りこみ if($userdata[supplyerid2] <> "") { $strwheremaker = " and sm.makercode in(".$userdata[supplyerid2].")"; } if($_GET[nohinsho] == "end") { //6410からの戻り //注文メモ更新 $arraylist = split("-",$_GET["shotenp"]); if (sizeof($arraylist) > 0 ) { For ($ii = 0;$ii < sizeof($arraylist); $ii++) { $strsqlwhere .= "'".$arraylist[$ii]."'"; if($ii < (sizeof($arraylist) - 1)) $strsqlwhere .= ","; } } $strsql = "UPDATE `".$company."ordermemo` SET print = '1' WHERE shozokuid in (".$strsqlwhere.") and operatedate = DATE_ADD( CURDATE() , INTERVAL $refdate DAY ) "; $result=mysql_query($strsql,$my_con); $errcode =@mysql_errno(); Testecho ($y.$strsql."
"); #debug mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } //センターコード //センター権限の時はそのセンターを使用する。 //センター権限以外の時は指定された使用センターを使用する。 if ($userdata["kengen"] == 30) { //10Tradex,20本部、30センター、40サプライヤー、50納品先 $centerid = $userdata["companyid"]; } elseif ($_POST[center]<>""){ $centerid = $_POST[center]; } else { $centerid = $centerdata[0][1]; } $strwhere = " WHERE shukkaqty >0 and shukkadate = DATE_ADD( CURDATE() , INTERVAL $refdate DAY ) AND shu.centerid='".$centerid."'"; //配送業者 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); $strwhere .= " AND shu.deliveryid ='".$userdata["companyid"]."'"; } else { $deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companykind in ('60')",-1,-1); if ($_POST[deliver]<>"") { $strwhere .= " AND shu.deliveryid ='".$_POST[deliver]."'"; } } //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //1ページ数 $pageset = 80; //レコードの指定 if ($_POST[pagenum] == "") { $page = 1; } else { $page = (int)$_POST[pagenum]; } $excutedate2 = "DATE_ADD(CURDATE(),INTERVAL ".$refdate." DAY)"; //変更処理 if ($_POST[update] <> ""){ For ($y=0;$y<=$_POST[row];$y++) { if ($_POST{"shozoku".$y} == "") break; //更新 if($_POST{"memo".$y}<>($_POST{"memoold".$y})) { $strsql = "UPDATE `".$company."shukka` set memo2='".$_POST{"memo".$y}."', updater='".$userdata["tid"]."' "; $strsql .= " WHERE shukkadate = DATE_ADD( CURDATE() , INTERVAL $refdate DAY ) AND centerid='".$centerid."' AND shozokuid='".$_POST{"shozoku".$y}."'";$okcount++; Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } } } //サプライヤーコメント更新 For ($ii = 0;$ii < $_POST["row"];$ii++) { $strsql = "UPDATE `".$company."ordermemo` set memosup='".sqlinjection($_POST["memosup"][$ii],-1)."', updater='".$userdata["tid"]."' WHERE operatedate = DATE_ADD( CURDATE() , INTERVAL $refdate DAY ) AND centerid='".$centerid."' AND shozokuid='".$_POST["shozokuid"][$ii]."'"; Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } //データ取得数 $limit = " LIMIT ".($pageset*($page - 1)).",$pageset"; //オプション $codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104 and code > 0","codeid",-1); /*if(substr($userdata["tid"],0,1) == "K") { $strsql20 = " and shu.shozokuid > 5000 "; $tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`","shozokuid > 5000","shozokuid",-1); } elseif(substr($userdata["tid"],0,1) == "A") { $strsql20 = " and shu.shozokuid < 2000 "; $tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`","shozokuid < 2000","shozokuid",-1); }*/ //納品先の絞込み //ブランド if($userdata[brand] <> "") { $whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")"; $strsql20 = dbselectin($whereselectin," and shu.shozokuid in "); $strsqlshozoku = dbselectin($whereselectin," shozokuid in "); $tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` ",$strsqlshozoku,"shozokuid",-1); } //リストを取り出す //在庫テーブル、センターマスター、商品マスター //出荷判定OK,本部指定、 //納品先、ページ単位の出荷データ $strsql ="SELECT shu.shozokuid,shu.shukkadate,shu.deliverdate,address1,address2,address3,tel, sho.route,shu.deliveryid,memo.memo,memo.memosup,kakutei,print, sum(case when code=0 then 1 else 0 end) as code0, sum(case when code=1 then 1 else 0 end) as code1, sum(case when code=2 then 1 else 0 end) as code2, sum(case when code=3 then 1 else 0 end) as code3, sum(case when code=4 then 1 else 0 end) as code4, sum(case when code=5 then 1 else 0 end) as code5, sum(case when shukkaflg > 1 then 1 else 0 end) as endflg, count(shukkaid) as shukkacnt FROM (`".$company."shukka` as shu INNER JOIN `".$company."shohinmaster` as sm USING(shohincd), `".$company."shozokumaster` as sho) LEFT JOIN `".$company."ordermemo` as memo on (shu.shozokuid=memo.shozokuid AND memo.operatedate=shu.operatedate) $strwhere $strwhereshozoku $strwheremaker AND sho.shozokuid=shu.shozokuid $strsql20 GROUP BY shozokuid ORDER BY shu.deliveryid,route,shu.shozokuid"; Testecho ($y." $errcode ".$strsql); //全数 $result=@mysql_query($strsql,$my_con); $maxrow=@mysql_num_rows($result); mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); //1ページ分 $strsql .= $limit; $result=@mysql_query($strsql,$my_con); $row=@mysql_num_rows($result); mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); ?>
"); ?> センター
配送


>
0) { if ($okcount > 0 ){ PrintMsg("","$okcount 件のデータを更新しました。",700); } if ($errcount > 0 ){ PrintMsg("登録エラーが $errcount 件有りました。","",700); } PrintMsg($errmsg,"",700); } ?>
" name="shozokuid[]">
No. 配送会社 ルート 配送先 注文数 確定 納品書 顧客コメント 店舗へ連絡事項
検索結果はゼロ件でした。
 
[ >&chgday='" value="入力" name="button" > >&chgday='" value="発行" name="button">" //納品書 ?>
>