"") {
$strsqlsw = " AND searchword like '%".$sw."%'";
}
//業態
$codedata105 = dbselect("cname,code","`".$company."code`","codekind = 105","cname",-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 main.shozokuid='".$shozokuid."'";
}
Testecho($strsqldbselect);
} elseif($_POST[tenpo]<>"") {
$shozokuid = $_POST[tenpo];
$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
$shozokuid = "";
}
if($userdata["brand"] <> "") {
//ブランド設定があるユーザー
$whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")";
$strsqltenpo .= dbselectin($whereselectin," and main.shozokuid in ");
}
//サプライヤーコード
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"].") ";
}
//オプション
$codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104","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.operatedate >= '$_POST[startdate]'";
$strsqldate .= " and main.operatedate <= '$_POST[enddate]'";
$startdate = $_POST[startdate]; $enddate = $_POST[enddate];
} 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.operatedate >= '".$startdate."'";
$strsqldate .= " and main.operatedate <= '".$enddate."'";
}
//並び順
$strsqlorder = " order by os.centerid,os.shozokuid,os.operatedate,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.$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 FROM `".$company."shohinmaster` as sm ,($strsql) as os WHERE sm.shohincd=os.shohincd ".$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\",\"店着価格\",\"店着合計（定貫）\",\"区分\",\"納品日\",\"ルート\",\"業態\"")."\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($data[brand]." ".GetList($codedata105,$data[brand]));
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_field_name($result, $i)."\n";
//}
?>
センター名 |
業態 |
納品先 |
サプライヤー |
商品コード |
商品コード2 |
商品コード3 |
商品名 |
発注数 |
単位 |
規格 |
荷姿 |
価格 |
出荷作業日 |
納品日 |
状態 |
特記 |
明細作成日 |
"cool_") {
//生鮮以外
$data["shohin_string2"] = $data["kikaku"];
$data["kikaku"] = $data["nisugata"];
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|