"") {
$strsqlsw = " AND searchword like '%".$sw."%'";
}
//対象
$targetdata = array(array('納品日','deliverdate'),array('作業日','operatedate'));
//ユーザーデータ
$userlist = dbselect("name,tid","usermaster",-1,"lastlogon desc","50");
//ブランド
if($userdata[brand] <> "") {
$strsqlwherebrand = " AND brand in (".$userdata["brand"].")";
$whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE 1=1 ".$strsqlwherebrand." ";
$strsqlwhereshozoku = dbselectin($whereselectin," and shozokuid in ");
$tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlwhereshozoku,"shozokuid",-1);
//ブランド
$codedata105 = dbselect("concat('[',code,'] ',cname),code","`".$company."code`","codekind = 105 and code in (".$userdata["brand"].")","code",-1);
testecho($strsqldbselect);
} else {
//ブランド
$codedata105 = dbselect("concat('[',code,'] ',cname),code","`".$company."code`","codekind = 105","code",-1);
}
if($_POST["brand"] == "") {
$brand = -1;
} elseif($_POST["brand"] == "-1") {
$brand = -1;
} elseif($_POST["brand"] <> "") {
$brand = $_POST["brand"];
$strsqlwherebrand .= " AND brand = '".$brand."' ";
} else {
$brand = -1;
}
//価格設定
$strsql = "update `".$company."shozokushohin` as a,`".$company."ordermain` as b, `".$company."ordersheet` as c SET c.orderprice = a.nohinprice WHERE a.shozokuid = b.shozokuid AND a.shohincd = c.shohincd AND b.ordermainid = c.ordermainid AND b.operatedate >= curdate() and c.orderprice = 0";
$result=mysql_query($strsql,$my_con);
$errcode =mysql_errno();if ($errcode==0) $okcount++;
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho (mysql_affected_rows()."=ROW ".$strsql."
"); #debug
//納品先の絞込み
$tenpodataAll = $tenpodata;
//納品先コードの設定
if ($userdata["kengen"] == 50) {
$strsqltenpo = " AND main.shozokuid='".$userdata["shozokuid"]."'";
$shozokuid = $userdata["shozokuid"];
} elseif ($_POST[shop]<>"") {
$shop = $_POST[shop];
$strsqlshop = "search like '%".$shop."%'";
$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",$strsqlshop,"shozokuid",-1);
if (sizeof($tenpodata) == 1) {
$shozokuid = $tenpodata[0][1];
$strsqltenpo = " AND $strsqlwherebrand main.shozokuid='".$shozokuid."'";
}
Testecho($strsqldbselect);
} elseif($_POST[tenpo]<>"") {
$shozokuid = $_POST[tenpo];
$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
$shozokuid = "";
}
//サプライヤーコード
if ($userdata["kengen"] == 40) {
$strsqlmaker = " AND sm.makercode='".$userdata["companyid"]."'";
} elseif($_POST[maker]<>"") {
$strsqlmaker = " AND sm.makercode='$_POST[maker]'";
}
if ($userdata["supplyerid2"]<> ""){
//サプライヤー設定があるユーザー
$strsqlmaker .= " AND sm.makercode in (".$userdata["supplyerid2"].") ";
}
//流通型
if ((int)$_POST[ryutu_type] >= '0'){
$strsqlwhere .= " and sm.ryutu_type = '$_POST[ryutu_type]'";
$ryutu_type = $_POST["ryutu_type"];
} else {
$ryutu_type = -1;
}
$codedata10a = dbselect("cname,code","`".$company."code`","codekind = 10","cname",-1);
$codedata10b[] = array('全て',-1);
$codedata10 = array_merge_recursive($codedata10b, $codedata10a);
//カテゴリー
$codedata100 = dbselect("cname,code","`".$company."code`","codekind = 100","codeid",-1);
//カテゴリー2
$codedata107a = dbselect("cname,code","`".$company."code`","codekind = 107","code",-1);
$codedata107b[] = array('全て',-1);
$codedata107 = array_merge_recursive($codedata107b, $codedata107a);
if ((int)$_POST[category] >= '0'){
$category = (int)$_POST[category];
$strsqlwhere .= " and sm.category = '$category'";
} else {
$category = -1;
}
//オプション
$codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104","codeid",-1);
//温度帯
$codedata1 = dbselect("cname,code","`".$company."code`","codekind = 1","codeid",-1);
//センターコード
if ($userdata["centerid"] <> "") {
$centerid = $userdata["centerid"];
if(strpos($centerid, "'") === false) {
$strsqlcenter = " AND main.centerid='".$centerid."'";
} elseif($_POST[center]<>"") {
$centerid = $_POST[center];
$strsqlcenter = " AND main.centerid='".$centerid."'";
} else {
$strsqlcenter = " AND main.centerid in (".$centerid.")";
$centerid = "";
}
} elseif($_POST[center]<>"") {
$centerid = $_POST[center];
$strsqlcenter = " AND main.centerid='".$centerid."'";
} else {
}
//区分の指定
if($_POST[gyotai]<>"") {
$strsqlgyotai = " AND main.gyotaiid='$_POST[gyotai]'";
}
//出荷作業日
if ($_POST[startdate]<>""){
$strsqldate = " and main.$_POST[target] >= '$_POST[startdate]'";
$strsqldate .= " and main.$_POST[target] <= '$_POST[enddate]'";
$startdate = $_POST[startdate]; $enddate = $_POST[enddate];
$target = $_POST[target];
} else {
// $startdate = date("Y-m-01");
// $enddate = date("Y-m-d",time()+86400);//1日
if(date("Gi") > 1800) {
$startdate = date("Y-m-d",strtotime ("1 day"));
$enddate = date("Y-m-d",strtotime ("1 day"));
} else {
$startdate = date("Y-m-d");
$enddate = date("Y-m-d");
}
$strsqldate = " and main.$_POST[target] >= '".$startdate."'";
$strsqldate .= " and main.$_POST[target] <= '".$enddate."'";
$target = "operatedate";
}
//並び順
$strsqlorder = " order by os.centerid,os.operatedate,sm.ryutu_type,sm.code,sm.category,os.shozokuid,os.shohincd";
//受注データ
$strsql="SELECT main.ordermainid,shohincd,orderqty,checkedflg,main.operatedate,main.deliverdate,centerid,gyotaiid,main.shozokuid,sheet.memo,sheet.memo2,orderid,main.quickflg,sheet.orderprice,sheet.ordercartid ,sheet.creater as screater, main.creater as mcreater,sheet.createdate,main.brand
FROM `".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet
USING(ordermainid)
WHERE 1=1 ".$strsqltenpo.$strsqlcenter.$strsqlwhereshozoku.$strsqlwherebrand.$strsqlgyotai.$strsqldate;
$strsql = "SELECT os.shohincd,sm.shohincd2,sm.shohincd3,os.orderqty,checkedflg,os.operatedate,os.deliverdate,os.centerid,os.gyotaiid,os.shozokuid,sm.makercode,sm.shohinmei,os.memo,os.memo2,os.ordermainid,os.ordercartid,os.orderid,os.quickflg,sm.kikaku,sm.nisugata,shohin_string2,sm.shohin_order_memo,os.orderprice,sm.shohin_kubun3,sm.irisuus,os.mcreater,os.screater,os.createdate,os.brand,sm.ryutu_type,sm.code,sm.category FROM `".$company."shohinmaster` as sm ,($strsql) as os WHERE sm.shohincd=os.shohincd ".$strsqlwhere.$strsqlsw.$strsqlmaker.$strsqlorder;
//ダウンロード
if (($_POST[dl2] <>"") or ($_POST[dl] <>"")){
if ($userdata["kengen"]==50) {
$strdate = Sjis("発注".date("Ymd-Gi").".csv");
} else {
$strdate = Sjis("受注".date("Ymd-Gi").".csv");
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=$strdate");
header("Connection: close");
ob_end_clean();
if($userdata["gyotaiid"] > 1) {
echo Sjis("No,\"センター\",\"納品コード\",\"納品先\",\"サプライヤー\",\"商品コード\",\"商品コード2\",\"商品コード3\",\"商品名\",\"発注数\",\"規格\",\"単位\",\"荷姿\",\"出荷作業日\",\"状態\",\"特記\",\"受注明細ID\",\"店着価格\",\"店着合計（定貫）\",\"区分\",\"納品日\",\"業態\",\"温度\",\"流通型\",\"カテゴリ\"")."\r\n";
} else {
echo Sjis("No,\"センター\",\"納品コード\",\"納品先\",\"サプライヤー\",\"商品コード\",\"商品コード2\",\"商品名\",\"発注数\",\"規格\",\"単位\",\"荷姿\",\"出荷作業日\",\"状態\",\"特記\",\"受注明細ID\",\"店着価格\",\"店着合計（定貫）\",\"区分\",\"納品日\",\"ルート\",\"業態\",\"商品コード3\",\"温度\",\"流通型\",\"カテゴリ\"")."\r\n";
}
#データ取得
$result=@mysql_query($strsql,$my_con);
$i=1;
while ($data = mysql_fetch_array($result)) {
if($company <> "cool_") {
//生鮮以外
$data["shohin_string2"] = $data["kikaku"];
$data["kikaku"] = $data["nisugata"];
}
echo $i.",";
echo Sprint(GetList($centerdata,$data[centerid]));
echo Sprint($data[shozokuid]);
echo Sprint(GetList($tenpodataAll,$data[shozokuid]));
echo Sprint(GetList($makerdata,$data[makercode]));
echo Sprint($data["shohincd"]);
echo Sprint($data["shohincd2"]);
if($userdata["gyotaiid"] > 1) {
echo Sprint($data["shohincd3"]);
}
echo Sprint($data["shohinmei"]);
echo Sprint(str_replace(".0","",$data[orderqty]));
if ($_POST[dl2] <>"") {
echo Sprint($data["shohin_string2"]); //規格
echo Sprint($data["kikaku"]); //単位
echo Sprint($data["nisugata"]); //荷姿
} else {
echo Sprint($data["nisugata"]); //荷姿(規格）
echo Sprint($data["shohin_string2"]); //規格（価格単位）
echo Sprint($data["kikaku"]); //単位
}
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("");
}
if($data["memo2"] > 0 ) {
echo Sprint($data["memo"].$data["shohin_order_memo"].GetList($codedata104,$data["memo2"],0));
} else {
echo Sprint($data["memo"].$data["shohin_order_memo"]);
}
echo Sprint($data["orderid"]);
if($userdata["cost_dispoff"] == 1) { //仕入れ金額非表示
echo Sprint("-");
} else {
echo Sprint($data["orderprice"]);
}
if($userdata["cost_dispoff"] == 1) { //仕入れ金額非表示
echo Sprint("-");
echo Sprint("");
} else {
if($data["shohin_kubun3"] == 1) {
echo "\"0\","; //不定貫
echo Sprint("不定貫");
} else {
echo "\"".($data["orderprice"] * $data["orderqty"] * $data["irisuus"])."\",";
echo Sprint("");
}
}
echo Sprint($data["deliverdate"]);
echo Sprint(GetListData($tenpodataAll,$data[shozokuid],4));
echo Sprint(GetList($codedata105,$data[brand]));
echo Sprint($data["shohincd3"]);
echo Sprint($data["code"]." ".GetList($codedata1,$data[code]));
echo Sprint($data["ryutu_type"]." ".GetList($codedata10,$data[ryutu_type]));
echo Sprint($data["category"]." ".GetList($codedata100,$data[category]));
echo "\r\n";
$i++;
}
Testecho ("\"".$strsql."\"");
myclose();
exit;
} elseif ($_POST[dl3] <>""){
//受注データ
$strsql="SELECT distinct(main.shozokuid),centerid FROM `".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet USING(ordermainid) ,`".$company."shohinmaster` AS sm
WHERE sheet.shohincd = sm.shohincd ".$strsqltenpo.$strsqlmaker.$strsqlcenter.$strsqlgyotai.$strsqldate;
$strsql = "SELECT os.centerid,os.shozokuid,tel,postcode,address1,address2,shozokuname FROM `".$company."shozokumaster` as sho ,($strsql) as os WHERE os.shozokuid = sho.shozokuid ";
// $strsql2 = "SELECT tel,fax,postcode,address1,address2,companyname FROM `company` WHERE companyid = '".$centerid."' ";
$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("\"お届け先電話番号\",\"お届け先郵便番号\",\"お届け先住所１\",\"お届け先住所２\",\"お届け先名称１\",\"店舗コード\",\"センター電話番号\",\"センター郵便番号\",\"センター住所１\",\"センター住所２\",\"センター名称\"")."\r\n";
#データ取得
$result=@mysql_query($strsql,$my_con);
$i=1;
// $result2=@mysql_query($strsql2,$my_con);
// $data2 = mysql_fetch_array($result2);
while ($data = mysql_fetch_array($result)) {
echo Sprint($data["tel"]);
echo Sprint($data["postcode"]);
echo Sprint($data["address1"]);
echo Sprint($data["address2"]);
echo Sprint($data["shozokuname"]);
echo Sprint($data["shozokuid"]);
echo Sprint(GetListData($centerdata,$data["centerid"],7));//tel
echo Sprint(GetListData($centerdata,$data["centerid"],8));//postcode
echo Sprint(GetListData($centerdata,$data["centerid"],6));//address1
echo Sprint(GetListData($centerdata,$data["centerid"],7));//address2
echo Sprint(GetListData($centerdata,$data["centerid"],0));//name
echo "\r\n";
$i++;
}
myclose();
exit;
}
if ($userdata["kengen"] >= 50) {
$title= "発注確認";
} else {
$title= "受注確認";
}
$result=@mysql_query($strsql,$my_con);
$maxrow=@mysql_num_rows($result);
?>
".mysql_affected_rows()."=ROW
".$strsql."
"); #debug
ShowNavBar2($maxrow,$pageset,$page,"500",1);
if ($_POST[startdate] == ""){
PrintMsg("","検索してください。",700);
} elseif ($maxrow == 0) {
//start NG
PrintMsg("","この条件での該当データはありませんでした。",700);
} else {
?>
| # |
".mysql_field_name($result, $i)."\n";
//}
?>
センター名 |
業態 |
納品先 |
サプライヤー |
商品CD |
商品CD2 |
商品CD3 |
品名 |
発注数 |
流通型 |
単位 |
規格 |
荷姿 |
価格 |
作業日 |
納品日 |
状態 |
特記 |
主注文ID |
注文明細ID |
カートID |
明細作成 |
作成日 |
"cool_") {
//生鮮以外
$data["shohin_string2"] = $data["kikaku"];
$data["kikaku"] = $data["nisugata"];
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|