"") { //納品先コード、納品先名称検索
$shop = $_POST[shop];
$strsqlshop = "search like '%".mb_convert_encoding($shop, "UTF-8", "UTF-8")."%'"; //UTF-8に変換して入れる
$tenpodata2 = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",$strsqlshop,"shozokuid",-1);
if(sizeof($tenpodata2)==1) {
$shozokuid = $tenpodata2[0][1];
} else {
$shozokuid = "";
$tenpodata = $tenpodata2 ;
}
} elseif ($_POST[tenpo]<>"") {
$shozokuid = $_POST[tenpo];
} else {
$strsqlshop = -1;
}
//初期値データ
if ($_POST[startdate]=="") {$startdate = date("Y-m-d"); } else {$startdate=$_POST[startdate]; } //初期値セット 指定がなければ前月末日
if ($_POST[enddate]=="") {$enddate = date("Y-m-d"); } else {$enddate=$_POST[enddate]; } //初期値セット 指定がなければ前月末日
$strsqldate = " and operatedate >= '".$startdate."' and operatedate <='".$enddate."' ";
//処理フラグ
if (($_POST["fixflg"] == "") or ($_POST["fixflg"] == "1")) {
$fixflg = 1; //未処理
$strsqlflg = " and orderid_flg = 1 ";
} else {
$fixflg = 2; //処理済
$strsqlflg = " and orderid_flg = 10 ";
}
//センターコード
if (($_POST[center]<>"all") and ($_POST[center]<>"")){
$strsqlcenter = " and centerid = '$_POST[center]'";
$centerid = $_POST[center];
} else {
$centerid = $centerdata[0][1];
}
$errcount = 0; //エラーカウント
$okcount = 0; //エラーカウント
$errmsg = ""; //エラーメッセージ
//変更処理（画面）新規・訂正
For ($y=1;$y<(int)$_POST[max];$y++) {
$NG = 0;
if ($_POST[update] == "") break;
if ($_POST{"id".$y} == "") break;
if (Numchecker3($_POST{"qty".$y})=="CHR") {
//0.数値欄に文字が入れられたら何も更新しない。
$errmsg .= "数値以外の入力値がありましたので、更新できない商品がありました。[No.".$y."] 商品コード:".$_POST{"shohincd".$y}."
";$errcount++;
Testecho ($y." ID=".$_POST{"id".$y}." ERR
"); #debug
} else {
//数量更新
$strsql = "UPDATE `".$company."ordersheet` SET shukkaqty = '".$_POST{"qty".$y}."',updater='".$userdata["tid"]."',updatedate=now() WHERE orderid = '".$_POST{"id".$y}."' LIMIT 1";
$result=mysql_query($strsql,$my_con);
$errcode =@mysql_errno();
Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
//出荷データ(まず削除）
$strsql = "DELETE FROM `".$company."shukka` WHERE orderid = '".$_POST{"id".$y}."' LIMIT 1";
$result=mysql_query($strsql,$my_con);
$errcode =@mysql_errno();
Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
//出荷データ(追加）
$strsql = "INSERT INTO `".$company."shukka` (`orderid`, `shozokuid`, `shohincd`, `centerid`,`picktimes`, `loccode`,`gyotaiid`, `stockdate`, `shomi`,`lotzan`, `waitingflg`, `orderqty`,`shukkaqty`, `operatedate`, `shukkadate`, `deliverdate`, `creater`, `lotnum`,`price_piece`,`price_total`,memo,memo2) SELECT `orderid`, `shozokuid`, `shohincd`, `centerid`,1, null,`gyotaiid`, null, null,null, 0,`orderqty`, `shukkaqty`, `operatedate`, `operatedate`, `operatedate`, '".$userdata["tid"]."', 0,`orderprice`,orderprice * shukkaqty ,os.memo,os.memo2 FROM `".$company."ordersheet` as os INNER JOIN `".$company."ordermain` as om USING(ordermainid) WHERE orderid ='".$_POST{"id".$y}."' LIMIT 1";
$result=mysql_query($strsql,$my_con);
$errcode =@mysql_errno();
Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
}
}
//出荷データに納品先IDをつける
$strsql = "UPDATE `".$company."shukka` as shu, `".$company."shozokumaster` as sho SET `shu`.`deliveryid` = `sho`.`deliveryid`, `shu`.`route` = `sho`.`route` WHERE `shu`.`shozokuid` = `sho`.`shozokuid` and `shu`.`deliveryid` is null";
$result=mysql_query($strsql,$my_con);
Testecho ($y." $errcode ".$strsql); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
//ステータスフラグ
$strsql = "INTO `".$company."status`(operatedate,gyotaiid,centerid,picktimes,status,hikiateqty,keppinqty,keppinfixqty) values(CURDATE(),1,'c101',1,6,0,0,0)";
$result=mysql_query($strsql,$my_con);
Testecho ($y." $errcode ".$strsql); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
$strsql = "UPDATE `".$company."status`s SET status =6 ,hikiateqty =0 ,keppinqty = 0 ,keppinfixqty = 0 WHERE operatedate = CURDATE() and centerid = 'c101' and picktimes = 1 and status in (1,2)";
$result=mysql_query($strsql,$my_con);
Testecho ($y." $errcode ".$strsql); #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
//レコードの指定
if ($_POST[pagenum] == "") {
$page = 1;
} else {
$page = (int)$_POST[pagenum];
}
//データ取得数
$limit = " LIMIT ".($pageset*($page - 1)).",$pageset";
$strsql = "";
//サプライヤーコード
if ($_POST[maker]<>""){
$makerid = $_POST[maker];
$strsqlmaker = " and makercode = '".$makerid."'";
} elseif ($userdata[kengen] == 40){//サプライヤーは40
$makerid = $userdata["companyid"];
$strsqlmaker = " and makercode = '".$makerid."'";
}
//店舗絞込み
if ($_POST[tenpo]<>""){
$strsqltenpo = " and om.shozokuid = '$_POST[tenpo]'";
}
//検索用語
if ($sw<>"") {
$strsqlsearchword = " and searchword like '%".$sw."%'";
//商品のリストを取り出す（shohin in 句用＆総合計数用）
$strsql1 = "SELECT shohincd FROM `".$company."shohinmaster` WHERE zaiko=1 ".$strsqlmaker.$strsqlsearchword." ORDER BY shohincd";
Testecho ($y." strsql1= ".$strsql1 ); #debug
$strsqlshohin = dbselectin($strsql1,"and sm.shohincd in ");
}
//商品マスタ＋サプライヤ情報
//SELECT * FROM (SELECT FROM 商品マスタ、サプライヤ on makeracode=companyid) AS mas
$strsql2 = "SELECT os.orderid,om.shozokuid,sho.shozokuname,sho.postcode,sho.address1,sho.address2,sho.address3,sho.tel,sm.shohinmei,om.operatedate,os.orderqty,os.shukkaqty,os.orderid_flg,sm.shohincd, sm.kikaku, sm.irisuu, sm.aisuu, sm.code, sm.juryo, sm.nisugata,sm.shohin_string2,sm.shomiflg, makercode ,os.orderprice FROM `".$company."shohinmaster` AS sm INNER JOIN `".$company."ordersheet` as os USING(shohincd),`".$company."shozokumaster` as sho ,`".$company."ordermain` as om WHERE om.ordermainid = os.ordermainid and om.shozokuid = sho.shozokuid ".$strsqlmaker.$strsqlflg.$strsqltenpo.$strsqlshohin.$strsqldate." ORDER BY om.operatedate,om.shozokuid,sm.shohincd";
//echo $strsql2;
$startarray[] = array('選択して下さい',-100);
$startarray[] = array('欠品／受注取消',-2);
$startarray[] = array('注文受諾／出荷日未定',-3);
//ダウンロード
if ($_POST[dl] <>""){
$strdate = Sjis("店舗直送受注データ".date("Ymd-Gi").".csv");
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=$strdate");
header("Connection: close");
ob_end_clean();
echo Sjis("No,\"納品先コード\",\"納品先\",\"郵便\",\"都道府県\",\"住所\",\"TEL\",\"サプライヤー\",\"商品コード\",\"商品名\",\"荷姿\",\"発注数\",\"出荷数\",\"発注日\",\"出荷日\",\"状態\"")."\n";
#データ取得
$result=@mysql_query($strsql2,$my_con);
$i=1;
while ($data = mysql_fetch_array($result)) {
echo $i.",";
echo Sprint($data[shozokuid]);
echo Sprint($data[shozokuname]);
echo Sprint($data[postcode]);
echo Sprint($data[address1]);
echo Sprint($data[address2]." ".$data[address3]);
echo Sprint($data[tel]);
echo Sprint(GetList($makerdata,$data[makercode]));
echo Sprint($data["shohincd2"]);
echo Sprint($data["shohinmei2"]);
echo Sprint($data["nisugata"]);
echo Sprint((int)$data["orderqty"]);
echo Sprint((int)$data["shukkaqty"]);
echo Sprint(strftime("%G-%m-%d",strtotime($data[operatedate])));
if($data[orderdirectflg] == 1) {
echo Sprint(strftime("%G-%m-%d",strtotime($data[shukkadate])));
} else {
echo ",";
}
if($data[orderdirectflg] > 1) {
$strdate = - $data[orderdirectflg];
echo Sprint(GetListData($startarray,$strdate,0));
} elseif($data[orderdirectflg] == 1) {
echo Sprint("処理済");
}
echo "\n";
$i++;
}
myclose();
exit;
}
//全数
//$result=@mysql_query($strsql2,$my_con);
$result=@mysql_query($strsql2,$my_con);
Testecho ($y." $errcode ".$strsql2); #debug
$maxrow=@mysql_num_rows($result);
mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__);
//データ１ページ分
$result=@mysql_query($strsql2.$limit,$my_con);
Testecho ($y." $errcode ".$strsql2); #debug
$row=@mysql_num_rows($result);
mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
?>
0) {
if ($okcount > 0 ){
PrintMsg("","データを更新しました。",700);
}
if ($errcount > 0 ){
PrintMsg("登録エラーが $errcount 件有りました。","",700);
}
PrintMsg($errmsg,$worningmsg,700);
}
?>
""){
echo "商品検索：$sw";
}
if($_POST[fixflg] == 1){
echo " 未処理";
} else {
echo " 処理済";
}
echo " 該当件数：".$maxrow."件 ";
?>