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