"") { //不要のデータ削除　時間かかる /* $strsql = "SELECT a.ordermainid , b.ordermainid FROM `nagase_shukka` as a LEFT JOIN `nagase_ordermain` as b on(a.ordermainid = b.ordermainid) where b.ordermainid is null group by a.ordermainid"; $strsql = dbselectin($strsql," ordermainid in "); $strsql = "DELETE FROM `".$company."shukka` WHERE ".$strsql; $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作成 $kendata = dbselect("kenname,kenid","ken","kenid>0",-1,-1); For ($i = 0;$i < count($kendata);$i++) { //注文データ $strsql ="Select ordermainid,address2 FROM nagase_ordermain WHERE address1 = 0 AND address2 like '".$kendata[$i][0]."%' AND createdate > DATE_ADD(CURDATE(),INTERVAL -2 DAY)"; $result=@mysql_query($strsql,$my_con); while ($data=@mysql_fetch_array($result)) { $straddress = mb_ereg_replace($kendata[$i][0],'',$data["address2"]); $strsql2 = "UPDATE nagase_ordermain SET address1 =".$kendata[$i][1].",address2 = '".$straddress."' WHERE ordermainid =".$data["ordermainid"]; $result2=@mysql_query($strsql2,$my_con); mysql_sql_log($strsql2,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } //顧客データ $strsql3 ="Select customerid,address2 FROM customer WHERE updatedate > DATE_ADD(CURDATE(),INTERVAL -2 DAY) AND address1 = 0 AND address2 like '".$kendata[$i][0]."%'"; $result3=@mysql_query($strsql3,$my_con); while ($data=@mysql_fetch_array($result3)) { $straddress = mb_ereg_replace($kendata[$i][0],'',$data["address2"]); $strsql4 = "UPDATE customer SET address1 =".$kendata[$i][1].",address2 = '".$straddress."' WHERE customerid =".$data["customerid"]; $result4=@mysql_query($strsql4,$my_con); mysql_sql_log($strsql4,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } } //送付親登録 $strsql = "UPDATE `".$company."ordermain` as a, `customer` as c SET a.customer_master_name = c.custname WHERE a.customerid = c.customerid and (a.customer_master_name = '' or a.customer_master_name is null)"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //非登録ユーザー $strsql = "UPDATE `".$company."ordermain` SET customer_master_name = name WHERE customer_master_name is null"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug $strsql = "UPDATE `".$company."ordermain` SET err_check = 0,err_memo ='' WHERE operatedate is null or operatedate = curdate()"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //電話無し $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'') WHERE (operatedate is null or operatedate = curdate()) AND tel =''"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //名前無し $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<名前無>') WHERE (operatedate is null or operatedate = curdate()) AND name =''"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //POST無し $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<〒無>') WHERE (operatedate is null or operatedate = curdate()) AND postcode =''"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //日付無し $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<時間有日付無>') WHERE (operatedate is null or operatedate = curdate()) AND deliverdate is null AND delivertime <>''"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //指定外 $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<納品6日超>') WHERE (operatedate is null or operatedate = curdate()) AND deliverdate > DATE_ADD(CURDATE(),INTERVAL 6 DAY)"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //領収書名義桁足らず $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<領収書名桁足>') WHERE (operatedate is null or operatedate = curdate()) AND CHAR_LENGTH(receipt_name) < 5"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //届け先相違名前 $strsql = "UPDATE `nagase_ordermain` as om ,nagase_orderdata2 as od SET om.err_check = 1,om.err_memo =concat(om.err_memo,'<別送扱い留意[名前]>') WHERE (om.operatedate is null or om.operatedate = curdate()) AND om.customer_master_name <> om.name and od.orderid_ec= om.orderid2"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); $strsqlall .= "ROW=".mysql_affected_rows()." 届け先相違名前 ".$strsql."\n"; //届け先相違EC名前 $strsql = "UPDATE `nagase_ordermain` as om ,nagase_orderdata2 as od SET om.err_check = 1,om.err_memo =concat(om.err_memo,'<別送扱い留意[EC名前]>') WHERE (om.operatedate is null or om.operatedate = curdate()) AND (od.name2 <> od.deli_name2 or od.name1 <> od.deli_name1 ) and od.orderid_ec= om.orderid2"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); $strsqlall .= "ROW=".mysql_affected_rows()." 届け先相違EC名前 ".$strsql."\n"; //届け先相違EC住所 $strsql = "UPDATE `nagase_ordermain` as om ,nagase_orderdata2 as od SET om.err_check = 1,om.err_memo =concat(om.err_memo,'<別送扱い留意[EC住所]>') WHERE (om.operatedate is null or om.operatedate = curdate()) AND od.deli_address3 <> od.address3 and od.orderid_ec= om.orderid2"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); $strsqlall .= "ROW=".mysql_affected_rows()." 届け先相違EC住所 ".$strsql."\n"; //届け先相違 $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<別送扱い留意(名)>') WHERE (operatedate is null or operatedate = curdate()) AND customer_master_name <> name"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //届け先相違 $strsql = "UPDATE `".$company."ordermain` as o, `customer` as c SET err_check = 1,err_memo =concat(err_memo,'<別送扱い留意(住)>') WHERE (operatedate is null or operatedate = curdate()) AND o.customerid = c.customerid AND o.address3 <> c.address3"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //住所1桁超 $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<住所2+3桁32超>') WHERE (operatedate is null or operatedate = curdate()) AND CHAR_LENGTH(concat(address2,address3)) > 28"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //住所2桁超 $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<住所4桁16超>') WHERE (operatedate is null or operatedate = curdate()) AND CHAR_LENGTH(address4) > 16"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //カナナシ $strsql = "UPDATE `".$company."ordermain` SET err_check = 1,err_memo =concat(err_memo,'<氏名カナ無>') WHERE (operatedate is null or operatedate = curdate()) AND namekana is NULL"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug //〒辞書不一致 $strsql = "UPDATE `".$company."ordermain` as om, univarsal.`postdata` as p SET err_check = 1,err_memo =concat(err_memo,'<〒不一致>',postname,'') WHERE (operatedate is null or operatedate = curdate()) AND om.postcode = p.postcode AND postname <> address2"; $result=mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug } elseif ($_POST[deleteflg] == "yes"){ //出荷データ削除 $strsql3 = "DELETE FROM `".$company."shukka` WHERE ordermainid ='".$_POST["idmain"]."'"; $result=mysql_query($strsql3,$my_con); mysql_sql_log($strsql3,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql3."
"); #debug //受注フラグ更新 $strsql3 = "UPDATE `".$company."ordermain` SET nagase_flg = 4,operatedate = null,checkedflg = 0,memo2 = concat(ifnull(memo2,''),ifnull(yamatoid,'')),yamatoid=null WHERE ordermainid ='".$_POST["idmain"]."' limit 1"; $result=mysql_query($strsql3,$my_con); mysql_sql_log($strsql3,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql3."
"); #debug //ステータス更新 $strsql3 = "select count(distinct(ordermainid)) as cnt,picktimes from ".$company."shukka where operatedate=curdate() group by picktimes"; $result=mysql_query($strsql3,$my_con); mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql3."
"); #debug while ($data = mysql_fetch_array($result)) { $strsql4 = "UPDATE `".$company."status` SET hikiateqty = ".$data["cnt"]." WHERE operatedate=curdate() AND picktimes ='".$data["picktimes"]."' limit 1"; $result2=mysql_query($strsql4,$my_con); mysql_sql_log($strsql4,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql4."
"); #debug } } //レコードの指定 if ($_POST[pagenum] == "") { $page = 1; } else { $page = (int)$_POST[pagenum]; } if ($_POST["nagase_flg"] == "") { $intnagase_flg = 0; $strwhereflg = " AND nagase_flg = $intnagase_flg "; } elseif ($_POST["nagase_flg"] == "-1") { $intnagase_flg = -1; } else { $intnagase_flg = $_POST[nagase_flg]; $strwhereflg = " AND nagase_flg = $intnagase_flg "; } //表示対象 $errdata = array(array('すべて',-1),array('正常',0),array('エラー',1)); //出荷状況区分 $gostopdata = array(array('すべて',-1),array('未出荷',0),array('出荷済',1)); if ($_POST["err_check"] == "") { $interr_check = -1; } elseif ($_POST["err_check"] == "-1") { $interr_check = $_POST[err_check]; } elseif ($_POST["err_check"] == "0") { $interr_check = $_POST[err_check]; $strwhereflg .= " AND err_check = $interr_check "; } else { $interr_check = $_POST[err_check]; $strwhereflg .= " AND err_check = $interr_check "; } if ($_POST["gostopdata"] == "") { $intgostop = -1; } elseif ($_POST["gostopdata"] == "-1") { $intgostop = $_POST[gostopdata]; } elseif ($_POST["gostopdata"] == "0") { $intgostop = $_POST[gostopdata]; $strwhereflg .= " AND checkedflg = 0 "; } else { $intgostop = $_POST[gostopdata]; $strwhereflg .= " AND checkedflg > 0 "; } if ($_POST["intcheck"] == "") { $intcheck = -1; } elseif ($_POST["intcheck"] == "-1") { $intcheck = $_POST[intcheck]; } elseif ($_POST["intcheck"] == "0") { $intcheck = $_POST[intcheck]; $strwhereflg .= " AND checkuserflg = $intcheck "; } else { $intcheck = $_POST[intcheck]; $strwhereflg .= " AND checkuserflg = $intcheck "; } //広告区分 if ($_POST["intad"] == "") { $intad = 0; } elseif ($_POST["intad"] == "0") { $intad = 0; } else { $intad = $_POST[intad]; $strwhereflg .= " AND ad_kubun = $intad "; } //受注CH if ($_POST["intinput_media"] == "") { $intinput_media = -1; } elseif ($_POST["intinput_media"] == "-1") { $intinput_media = -1; } else { $intinput_media = $_POST["intinput_media"]; $strwhereflg .= " AND input_media = $intinput_media "; } //データ取得数 $limit = " LIMIT ".($pageset*($page - 1)).",$pageset"; $strsql = ""; //検索処理 $sw = trim(mb_convert_kana($_POST[searchword],'KV')); //全て全角へ変換 if ($sw<>"") { $strsqlsw = " AND searchword like '%".$sw."%'"; $strsqlshohin = "SELECT shohincd FROM `".$company."shohinmaster` WHERE searchword like '%".$sw."%'"; $strsqlshohin2 = dbselectin($strsqlshohin,"sheet.shohincd in "); } else { $strsqlshohin2 = " 1 = 1 "; } //納品先の絞込み $tenpodataall = $tenpodata; //納品先コードの設定 if($userdata["brand"] <> "") { //ブランド設定があるユーザー $brand = $userdata["brand"]; $strsqlbrand = " and brand = '".$brand."'" ; $tenpodata = dbselect("shozokuname,shozokuid,brand","`".$company."shozokumaster`","1 = 1".$strsqlbrand,"shozokuid",-1); if(sizeof($tenpodata)==1) { //1件のときはリスト表示のため(1件だとリスト表示されない） $shozokuid = $tenpodata[0][1]; $tenpodata = $tenpodataall; } } elseif ($_POST["brand"] <> "") { //ブランド指定 $brand = $_POST["brand"]; $strsqlbrand = " and brand = '".$brand."'" ; $tenpodata = dbselect("shozokuname,shozokuid,brand","`".$company."shozokumaster`","1 = 1".$strsqlbrand,"shozokuid",-1); if(sizeof($tenpodata)==1) { //1件のときはリスト表示のため(1件だとリスト表示されない） $shozokuid = $tenpodata[0][1]; $tenpodata = $tenpodataall; } } else { //指定なし　$tenpodataはデフォルトセットを使用 } if ($userdata["kengen"] == 50) { //納品先権限では、自分に限定する $strsqltenpo = " AND main.shozokuid='".$userdata["shozokuid"]."'"; $shozokuid = $userdata["shozokuid"]; } elseif ($_POST[shop]<>"") { //納品先コード、納品先名称検索 //店舗検索 $shop = $_POST[shop]; $strsqlshop = "search like '%".mb_convert_encoding($shop, "UTF-8", "UTF-8")."%'"; //UTF-8に変換して入れる $tenpodata2 = dbselect("shozokuname,shozokuid,brand","`".$company."shozokumaster`",$strsqlshop.$strsqlbrand,"shozokuid",-1); if (sizeof($tenpodata2) == 1) { //特定できた $shozokuid = $tenpodata2[0][1]; $strsqltenpo = " AND main.shozokuid='".$shozokuid."'"; //デフォルトをブランド設定する必要なし $brand = $tenpodata2[0][2]; } else { $shozokuid = ""; $tenpodata = $tenpodata2; } } elseif($_POST[tenpo]<>"") { //店舗コード指定 $tenpodata2 = dbselect("shozokuname,shozokuid,brand","`".$company."shozokumaster`","shozokuid ='".$_POST[tenpo]."' ".$strsqlbrand,"shozokuid",-1); if(sizeof($tenpodata2) == 1) { //ブランドと店舗と店舗コードが一致 $shozokuid = $_POST[tenpo]; $strsqltenpo = " AND main.shozokuid='".$shozokuid."'"; //デフォルトをブランド設定する必要なし $brand = $tenpodata2[0][2]; } else { //ブランドと店舗と店舗コードが不一致はリストなし $tenpodata = dbselect("shozokuname,shozokuid,brand","`".$company."shozokumaster`","1 = 1".$strsqlbrand,"shozokuid",-1); if(sizeof($tenpodata)==1) { //1件のときはリスト表示のため(1件だとリスト表示されない） $shozokuid = $tenpodata[0][1]; $tenpodata = $tenpodataall; } } } else { //店舗検索、店舗指定なし //特定できないときはデフォルト店舗リスト } //サプライヤーコード if ($userdata["kengen"] == 40) { $strsqlmaker = " AND sm.makercode='".$userdata["companyid"]."'"; } elseif($_POST[maker]<>"") { $strsqlmaker = " AND sm.makercode='$_POST[maker]'"; } //センターコード if ($userdata["kengen"] == 30) { $strsqlcenter = " AND main.centerid='".$userdata["companyid"]."'"; } elseif($_POST[center]<>"") { $strsqlcenter = " AND main.centerid='$_POST[center]'"; } //区分の指定 if($_POST[gyotai]<>"") { $strsqlgyotai = " AND main.gyotaiid='$_POST[gyotai]'"; } //発注日 if ($_POST[startdate]<>""){ $strsqldate = " and main.inputdatetime >= '$_POST[startdate] 11:00:00'"; $strsqldate .= " and main.inputdatetime < '$_POST[enddate] 11:00:00'"; $startdate = $_POST[startdate]; $enddate = $_POST[enddate]; } elseif(date("Gi") > 1200) { $startdate = date("Y-m-d"); $enddate = date("Y-m-d", strtotime("1 day")); $strsqldate = " and main.inputdatetime >= '".$startdate." 11:00:00'"; $strsqldate .= " and main.inputdatetime < '".$enddate." 11:00:00'"; } else { $startdate = date("Y-m-d", strtotime("-1 day")); $enddate = date("Y-m-d"); $strsqldate = " and main.inputdatetime >= '".$startdate." 11:00:00'"; $strsqldate .= " and main.inputdatetime < '".$enddate." 11:00:00'"; } //入力者 if($_POST[user] == "") { $user = "X"; } elseif ($_POST[user] <> "X") { $user = $_POST[user]; $strsqlgyotai .= " AND main.creater = '".$user."'"; } else { $user = "X"; } //ID検索 if($_POST[ids]<>"") { $strsqldate = " and main.ordermainid = ".trim($_POST[ids])." "; $strids = $_POST[ids]; $strname = ""; $strwhereflg = " "; $intgostop = -1; $intcheck = -1; $intad = 0; $intinput_media = -1; $interr_check = -1; $intnagase_flg = -1; } elseif($_POST[ids2]<>"") { $strsqldate = " and main.orderid2 = ".trim($_POST[ids2])." "; $strids2 = $_POST[ids]; $strname = ""; $strwhereflg = " "; $intgostop = -1; $intcheck = -1; $intad = 0; $intinput_media = -1; $interr_check = -1; $intnagase_flg = -1; } elseif($_POST[names]<>"") { $strsqldate = " and main.name = '".trim($_POST[names])."' "; $strids = ""; $strname = $_POST[names]; $strwhereflg = " "; $intgostop = -1; $intcheck = -1; $intad = 0; $intinput_media = -1; $interr_check = -1; $intnagase_flg = -1; } //並び順 $strsqlorder = " order by os.centerid,os.shozokuid,os.ordermainid desc ,os.shohincd"; $strsql="SELECT main.ordermainid,main.checkedflg,main.inputdatetime,main.centerid,main.gyotaiid,main.shozokuid,main.memo,main.memo2,main.memo3,main.memo4,main.creater,customer_master_name,name,namekana,email,yamatoid,deliverdate ,delivertime,orderid2,pay_kubun,address1,address2,address3,address4,postcode,tel ,operatedate,nagase_flg,err_memo,receipt_name,customerid,main.ad_kubun ,main.checkuserflg,main.checkuser ,main.input_media FROM `".$company."ordermain` AS main WHERE 1=1 ".$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate.$strsqlbrand.$strwhereflg." order by ordermainid desc"; //ユーザーリスト $userlist = dbselect("name,tid","usermaster as um INNER JOIN userrole as ur USING(tid)","shozokuid = 10","lastlogon desc",-1);$userlist[] = array("EC連動","SYSTEM"); $userlist2[] = array("すべて","X"); $userlist = array_merge_recursive($userlist2, $userlist); //ダウンロード if ($_POST[dl3] <>""){ //日付指定明細 $strdate = Sjis("実績A".date("Ymd-Gi").".csv"); header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=$strdate"); header("Connection: close"); header("Cache-Control: public"); header("Pragma: public"); ob_end_clean(); $strsql99 = "update ".$company."ordermain SET media=99 where media = 0"; $result=mysql_query($strsql99,$my_con); mysql_sql_log2($strsql99,$_SERVER['SCRIPT_NAME'].":".__LINE__); testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql99."
"); #debug //出荷ステータス $codedata5 = dbselect("cname,code","`".$company."code`","codekind = 5","code",-1); //欠品ステータス $codedata7 = dbselect("cname,code","`".$company."code`","codekind = 7","code",-1); $strsqldate = " and main.operatedate >= '".$startdate."' "; $strsqldate .= " and main.operatedate < '".$enddate."' "; $strsqldate = " and main.inputdatetime >= '".$startdate." 11:00:00'"; $strsqldate .= " and main.inputdatetime < '".$enddate." 11:00:00'"; $strsql5="SELECT main.ordermainid,main.checkedflg,main.inputdatetime,main.centerid,main.gyotaiid,main.shozokuid,main.memo,main.memo2,main.memo3,main.memo4,main.deliverdate,main.delivertime,main.creater,customer_master_name,name,email,yamatoid,deliverdate ,delivertime,orderid2,pay_kubun,main.address1,main.address2,main.address3,main.address4,main.postcode,main.tel ,operatedate,nagase_flg,err_memo,receipt_name,main.customerid,os.orderprice,os.orderqty,sm.shohincd,sm.shohinmei,sm.kikaku,cu.occupation,cu.customerlevel,main.media,main.ad_kubun ,namekana,main.input_media ,main.checkuserflg,main.checkuser FROM `nagase_ordermain` AS main INNER JOIN `nagase_ordersheet` as os USING(ordermainid) ,`nagase_shohinmaster` as sm , customer as cu where main.customerid = cu.customerid AND sm.shohincd = os.shohincd ".$strsqldate." order by main.ordermainid "; $strsql6="SELECT count(main.ordermainid) as cnt,pay_kubun FROM `nagase_ordermain` AS main where checkedflg >= 0 ".$strsqldate." GROUP BY ordermainid,pay_kubun "; echo Sjis("No,\"出荷日\",\"ｽﾃｰﾀｽ\",\"受付種別\",\"支払区分\",\"出荷区分\",\"代引金額\",\"カード決済額\",\"振替・振込金額\",\"〒\",\"都道府県\",\"顧客名\",\"職業\",\"顧客レベル\",\"媒体\",\"受注ID\",\"受注ECID\",\"商品CD\",\"商品名\",\"数量\",\"単価\",\"合計\",\"広告区分\",\"住所\",\"TEL\",\"カナ\",\"受注CH\",\"コール業務連絡\",\"本社業務連絡\",\"配達指定日\",\"配達時間\",\"チェック\"")."\n"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; //echo Sprint($strsql5); while ($data = mysql_fetch_array($result)) { echo $i.","; echo Sprint($data[operatedate]); echo Sprint(GetList($codedata30,$data[checkedflg])); if($data[orderid2] > 0) { echo Sprint("WEB"); $intweb++; } else { echo Sprint("CALL"); $intCALL++; } echo Sprint(GetList($codedata18,$data[pay_kubun])); echo Sprint(GetList($codedata20,$data[nagase_flg])); $inttotal = (int)$data["orderqty"] * (int)$data["orderprice"]; $inttotalall += $inttotal; if($data[pay_kubun] == 0) { echo Sprint("0"); echo Sprint($inttotal); echo Sprint("0"); $intcard +=$inttotal; } elseif($data[pay_kubun] == 2) { echo Sprint($inttotal); echo Sprint("0"); echo Sprint("0"); $intcorect += $inttotal; } else { echo Sprint("0"); echo Sprint("0"); echo Sprint($inttotal); $intetc +=$inttotal; } echo Sprint($data["postcode"]); echo Sprint(GetList($codedataken,$data[address1])); echo Sprint($data["name"]); echo Sprint($data[occupation].".".GetList($codedata19,$data[occupation])); echo Sprint($data["customerlevel"]); echo Sprint($data["media"].".".GetList($codedata92,$data["media"])); echo Sprint($data["ordermainid"]); echo Sprint($data["orderid2"]); echo Sprint($data["shohincd"]); echo Sprint($data["shohinmei"]." ".$data["kikaku"]); echo Sprint($data["orderqty"]); echo Sprint($data["orderprice"]); echo Sprint($data["orderqty"] * $data["orderprice"]); echo Sprint(GetList($codedata93,$data["ad_kubun"])); echo Sprint($data[address2].$data[address3].$data[address4]); echo Sprint($data["tel"]); echo Sprint($data["namekana"]); echo Sprint(GetList($codedata95,$data["input_media"])); echo Sprint($data["memo4"]); echo Sprint($data["memo3"]); echo Sprint($data["deliverdate"]); echo Sprint($data["delivertime"]); if($data["checkuserflg"] == 0) {echo Sprint(GetList($codedata2,$data["checkuserflg"]));} else {echo Sprint(GetList($userlist,$data["checkuser"]));} echo "\n"; $i++; } echo ","; echo Sprint("WEB受注"); echo Sprint((int)$intweb); echo Sprint("CALL受注"); echo Sprint((int)$intCALL); echo Sprint("合計"); // echo Sprint((int)$inttotalall); echo Sprint((int)$intcorect); echo Sprint((int)$intcard); echo $intetc; echo ",,,,,,,,,,,,,".$inttotalall."\n"; myclose(); exit; } elseif ($_GET[dl3] <>""){ //一日サマリー if ($userdata["kengen"]>20) { $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"); header("Cache-Control: public"); header("Pragma: public"); ob_end_clean(); //出荷ステータス $codedata5 = dbselect("cname,code","`".$company."code`","codekind = 5","code",-1); //欠品ステータス $codedata7 = dbselect("cname,code","`".$company."code`","codekind = 7","code",-1); //支払区分 $codedata18 = dbselect("cname,code","`".$company."code`","codekind = 18","code desc",-1); $strsql5 ="SELECT main.operatedate,main.ordermainid,main.orderid2, main.memo2, main.deliverdate, main.delivertime, main.sendto, main.customerid, main.name, main.receipt_name, main.receipt_shohinmei, main.pay_kubun, main.nagase_flg,main.checkedflg, sum(orderqty) as qty,sum(price_total) as total FROM `nagase_ordermain`AS main INNER JOIN `nagase_ordersheet` AS sheet USING ( ordermainid ) where operatedate='".$_GET["date"]."' group by ordermainid"; echo Sjis("No,\"出荷日\",\"ｽﾃｰﾀｽ\",\"受付種別\",\"支払区分\",\"出荷区分\",\"売上金額\",\"代引金額\",\"カード決済額\",\"振替・振込金額\",\"顧客名\",\"受注ID\",\"受注ECID\"")."\n"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; while ($data = mysql_fetch_array($result)) { echo $i.","; echo Sprint($data[operatedate]); echo Sprint(GetList($codedata30,$data[checkedflg])); if($data[orderid2] > 0) { echo Sprint("WEB"); $intweb++; } else { echo Sprint("CALL"); $intCALL++; } echo Sprint(GetList($codedata18,$data[pay_kubun])); echo Sprint(GetList($codedata20,$data[nagase_flg])); echo Sprint($data["total"]); $inttotal += $data["total"]; if($data[pay_kubun] == 0) { echo Sprint("0"); echo Sprint($data["total"]); echo Sprint("0"); $intcard += $data["total"]; } elseif($data[pay_kubun] == 2) { echo Sprint($data["total"]); echo Sprint("0"); echo Sprint("0"); $intcorect += $data["total"]; } else { echo Sprint("0"); echo Sprint("0"); echo Sprint($data["total"]); $intetc += $data["total"]; } echo Sprint($data["name"]); echo Sprint($data["ordermainid"]); echo Sprint($data["orderid2"]); echo "\r\n"; $i++; } echo ","; echo Sprint("WEB受注"); echo Sprint((int)$intweb); echo Sprint("CALL受注"); echo Sprint((int)$intCALL); echo Sprint("合計"); echo Sprint((int)$inttotal); echo Sprint((int)$intcorect); echo Sprint((int)$intcard); echo $intetc; echo ",\n"; myclose(); exit; } elseif ($_POST[dlmonth] <>""){ //月間サマリー $strdate = Sjis("月間".date("Ymd-Gi").".csv"); header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=$strdate"); header("Connection: close"); header("Cache-Control: public"); header("Pragma: public"); ob_end_clean(); echo Sprint("期間：".$startdate."～".$enddate); echo "\r\n"; //1.受注チャネル別売上 $strsql5 = "SELECT a.*,b.* FROM (select orderkubun,sum(price_total) as total,count(distinct(ordermainid)) as cnt FROM nagase_ordermain inner join nagase_ordersheet using(ordermainid) WHERE `operatedate` between '".$startdate."' and '".$enddate."' and checkedflg = 5 group by orderkubun) as a ,nagase_code as b where a.orderkubun = b.code and codekind=21"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo "\r\n"; echo Sprint("1.受注チャネル別売上"); //echo Sprint($strsql5); echo "\r\n"; echo Sprint("受注区分"); echo Sprint("件数"); echo Sprint("金額"); echo "\r\n"; while ($data = mysql_fetch_array($result)) { echo Sprint($data[cname]); echo Sprint($data[cnt]); echo Sprint($data[total]); echo "\r\n"; $i++; } echo "\r\n"; echo "\r\n"; //2.支払方法別売上 $strsql5 = "SELECT a.*,b.* FROM (select pay_kubun,sum(price_total) as total,count(distinct(ordermainid)) as cnt FROM nagase_ordermain inner join nagase_ordersheet using(ordermainid) WHERE `operatedate` between '".$startdate."' and '".$enddate."' and checkedflg = 5 group by pay_kubun) as a ,nagase_code as b where a.pay_kubun = b.code and codekind=18 order by total desc"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("2.支払方法別売上"); echo "\r\n"; //echo Sprint($strsql5); echo Sprint("区分"); echo Sprint("件数"); echo Sprint("金額"); echo "\r\n"; while ($data = mysql_fetch_array($result)) { echo Sprint($data[cname]); echo Sprint($data[cnt]); echo Sprint($data[total]); echo "\r\n"; $i++; } echo Sprint("※支払無しはサンプル＋帳票のみの合算のため、サンプル総数は3.の数量を合算して算出すること！"); echo "\r\n"; echo "\r\n"; echo "\r\n"; //3.サンプル　受付件数 $strsql5 = "SELECT a.*,b.* FROM (select input_media,sum(price_total),count(distinct(ordermainid)) as cnt FROM nagase_ordermain inner join nagase_ordersheet using(ordermainid) WHERE `operatedate` between '".$startdate."' and '".$enddate."' and nagase_flg = 1 and checkedflg = 5 group by input_media) as a ,nagase_code as b where a.input_media = b.code and codekind=95"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("3.サンプル　受付件数"); //echo Sprint($strsql5); echo "\r\n"; echo Sprint("区分"); echo Sprint("件数"); echo "\r\n"; while ($data = mysql_fetch_array($result)) { echo Sprint($data[cname]); echo Sprint($data[cnt]); echo "\r\n"; $i++; } echo "\r\n"; echo "\r\n"; //4.新規顧客 $strsql5 = "Select count(customerid) as cnt FROM customer where createdate between '".$startdate."' and '".$enddate."'"; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("4.新規顧客"); //echo Sprint($strsql5); echo "\r\n"; echo Sprint("件数"); // echo Sprint($strsql5); while ($data = mysql_fetch_array($result)) { echo Sprint($data[cnt]); echo "\r\n"; $i++; } echo "\r\n"; echo "\r\n"; //5.商品別売上RANKING $strsql5 = "SELECT a.*,concat(shohinmei,' ',ifnull(kikaku,'')) as sname ,price_sell * 1.05 as tanka FROM (select shohincd,sum(price_total) as total,sum(orderqty) as qty FROM nagase_ordermain inner join nagase_ordersheet using(ordermainid) WHERE `operatedate` between '".$startdate."' and '".$enddate."' and checkedflg = 5 group by shohincd) as a ,nagase_shohinmaster as b where a.shohincd = b.shohincd order by qty desc ,shohincd3 "; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("5.商品別売上RANKING"); //echo Sprint($strsql5); echo "\r\n"; echo Sprint("商品CD"); echo Sprint("商品名"); echo Sprint("数量"); echo Sprint("単価"); echo Sprint("合計"); echo "\r\n"; // echo Sprint($strsql5); while ($data = mysql_fetch_array($result)) { echo Sprint($data[shohincd]); echo Sprint($data[sname]); echo Sprint($data[qty]); echo Sprint($data[tanka]); echo Sprint($data[total]); echo "\r\n"; $i++; } echo "\r\n"; echo "\r\n"; //6.媒体別反響数 $strsql5 = "SELECT a.*,b.* FROM (select count(ordermainid) as cnt ,ad_kubun FROM `nagase_ordermain` WHERE `operatedate` between '".$startdate."' and '".$enddate."' and checkedflg = 5 group by ad_kubun) as a ,nagase_code as b where a.ad_kubun = b.code and codekind=93 order by cnt desc "; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("6.媒体別反響数"); //echo Sprint($strsql5); echo "\r\n"; echo Sprint("広告区分"); echo Sprint("件数"); echo "\r\n"; $intTotal = 0; while ($data = mysql_fetch_array($result)) { echo Sprint(str_replace("　","",Trim($data[cname]))); echo Sprint($data[cnt]); echo "\r\n"; $i++; $intTotal += $data[cnt]; } echo Sprint("※空欄は媒体不明"); echo "\r\n"; echo "\r\n"; //7.都道府県別数 $strsql5 = "select count(ordermainid) as cnt ,kenname,count(ordermainid) / $intTotal as perc FROM `nagase_ordermain` inner join ken on (address1 = kenid ) WHERE `operatedate` between '".$startdate."' and '".$enddate."' and checkedflg = 5 group by address1 order by cnt desc "; #データ取得 $result=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); $i=1;$intetc=0;$intcorect=0;$intcard=0; echo Sprint("7.エリア別受注件数"); echo "\r\n"; echo Sprint($strsql5); echo Sprint("都道府県"); echo Sprint("件数"); echo Sprint("構成比"); echo "\r\n"; $intTotal = 0; while ($data = mysql_fetch_array($result)) { echo Sprint(Trim($data[kenname])); echo Sprint($data[cnt]); echo Sprint($data[perc] * 100); echo "\r\n"; $i++; $intTotal += $data[cnt]; } echo Sprint("※空欄は媒体不明"); echo "\r\n"; echo "\r\n"; myclose(); exit; } if ($userdata["kengen"]>20) {$title= "発注閲覧";} else {$title= "受注閲覧";} $result=@mysql_query($strsql,$my_con); $maxrow=@mysql_num_rows($result); if($strname <> "") { //検索記録 $strsqlhis = "INSERT INTO ".$company."searchhis (tid,telsearch,namesearch,searchrow) values('".$userdata["tid"]."','".$strtel."','".$strname."','".$maxrow."')"; $resulthis=@mysql_query($strsqlhis,$my_con); mysql_sql_log($strsqlhis,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho($strsqlhis); } ?>

"") { echo "無操作状態が続いたので画面を自動更新しました"; } ?>

".mysql_field_name($result, $i)."\n"; //} ?> "") { $staffdata = dbselect("staff_name","`".$company."staff`"," staffid ='".$data["staffid"]."'",-1,-1);$staffdata = $data["staffid"]." ".$staffdata[0][0]; } $pricedata = dbselect("shohinmei,orderqty,price_total,kikaku","`".$company."ordersheet` INNER JOIN `".$company."shohinmaster` USING(shohincd)","ordermainid ='".$data["ordermainid"]."'",-1,-1); $strpricedisp = "";$intTotalamount = 0; For($k = 0; $k < sizeof($pricedata); $k++) { $strpricedisp .= "【".$pricedata[$k][1]."】".$pricedata[$k][0].$pricedata[$k][3]." ".number_format($pricedata[$k][2],0); $intTotalamount += $pricedata[$k][2]; if($k < (sizeof($pricedata) -1)) { $strpricedisp .= "
"; } } $bikodata = dbselect("memo","customer","customerid ='".$data["customerid"]."'",-1,-1); ?>

#	表示	注文ID	EC-ID	CK	ERR	納品先発注者領収名称	支払	備考	住所	入力時間	出荷日	指定日時間	客コメント	業務	コール	配送	入力者	ヤマト伝票	ｽﾃｰﾀｽ	受注CH	広告	区分	再作成
	',''); return true" class="box1s" value="表示" >					">";}; ?>	".GetList($codedata18,$data["pay_kubun"]); ?>	"") { echo "有"; } ?>	〒 ".$data["address3"]." ".$data["address4"]." TEL:".$data["tel"]; ?>														','',''); return true" class="box1s" value="取消" >

4) { ?> チェック情報更新
事前Ｂ２チェック
サマリー