""){ $centerid = $_POST[center]; $strsqlcenter = " and centerid = '$_POST[center]'"; $strsqlcenter2 = " and tocenterid = '$_POST[center]'"; } else { //全て // $centerid = $centerdata[0][1]; // $strsqlcenter = " and centerid = '".$centerdata[0][1]."'"; } //引当無しは注文と同じ /*$strsql ="UPDATE `".$company."ordersheet` SET karihikiate=orderqty WHERE kariflg =0"; Testecho ("LINE ".__LINE__." ".$y." ".$strsql); //debug $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);*/ //サプライヤーコード if ($userdata["supplyerid2"] <> "") { $strsqljoin .= " and sm.makercode in (".$userdata["supplyerid2"].")"; } elseif ($userdata["supplyerid"] <> "") { $makerid = $userdata["supplyerid"]; $strsqljoin .= " and sm.makercode in ('".$makerid."')"; } elseif ($_POST[maker] <> "") { $makerid = $_POST[maker]; $strsqljoin .= " and sm.makercode = '".$makerid."'"; } else { } //コードデータの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); //取扱区分コードデータの取得 $codedata9 = dbselect("cname,code","`".$company."code`","codekind = '9'","code",-1); //検索処理 $sw = Eucjp(trim(mb_convert_kana($_POST[searchword],"s"))); $sw = mb_convert_kana($sw,'KV', "UTF-8"); //全て全角へ変換 $sw = str_replace(" ","",$sw); //空白除く //１ページ数 $pageset = 20; //レコードの指定 if ($_POST[pagenum] == "") { $page = 1; } else { $page = (int)$_POST[pagenum]; } //照会日 if ($_POST[chgday] ==""){ $refdate = 0; } else { $refdate = (int)$_POST[chgday]; //本日からの経過時間 } $excutedate2 = "DATE_ADD(CURDATE(),INTERVAL ".$refdate." DAY)"; //データ取得数 $limit = " LIMIT ".($pageset*($page - 1)).",$pageset"; //検索用語のＷＨＥＲＥ句 $strsql = ""; if ($sw<>"") { //$strsqljoin = " and sm.searchword like '%".$sw."%'"; $strsqljoin .= " and sm.searchword like '%".$sw."%'"; } else { } //商品コードのＷＨＥＲＥＮ句 if ($_POST[goods]<>"") { $strsqljoin .= " and sm.shohincd like '%".Eucjp($_POST[goods])."%'"; } //業態コードのＷＨＥＲＥＮ句 //$strsqljoin .= " and sm.gyotaicode = '".$userdata["gyotaiid"]."' "; //ロット番号のＷＨＥＲＥＮ句 if ($_POST[lotnumber]<>"") { $lotnumber=str_replace("-","",$_POST[lotnumber]); //ハイフンを取り除く $lotnumber=(int)$lotnumber; $strsqljoin .= dbselectin("SELECT shohincd from `".$company."stockdata` where lotnum like '%".$lotnumber."%' and validflg=1"," and sm.shohincd in "); } //在庫管理対象＝1 if ($userdata["kengen"]==20) { //本部は取り扱いフラグを有効とする。 // } $strsqljoin .= " and sm.zaiko < 4 "; //流通対象＝1　在庫型 $strsqljoin .= " and sm.ryutu_type = '1' "; //在庫有り分のみ if ((int)$_POST[zaikotype]==1) { $strsqljoin2 = "validflg=1 and sd.stockqty>0 "; //0.商品数 $shohindata = dbselect("shohincd","`".$company."shohinmaster` as sm left join `".$company."stockdata` sd USING(shohincd)",$strsqljoin2.$strsqlcenter.$strsqljoin." group by shohincd",-1,-1); $strsqljoin .= dbselectin("SELECT shohincd from `".$company."stockdata` as sd where ".$strsqljoin2.$strsqlcenter." group by shohincd"," and sm.shohincd in "); } else { //0.商品数 $shohindata = dbselect("shohincd","`".$company."shohinmaster` as sm left join `".$company."stockdata` sd USING(shohincd)","1=1 ".$strsqljoin." group by shohincd",-1,-1); } //リストを取り出す //在庫テーブル、センターマスター、商品マスター //出荷判定ＯＫ，本部指定、 //1.在庫 $strsql1 = "SELECT shohincd,sum(stockqty) as stockqty ,sum(arrangeqty) as arrangeqty,sum(nonreserveqty) as nonreserveqty,centerid FROM `".$company."stockdata` WHERE shippingflg =1 AND validflg=1 ".$strsqlcenter." GROUP BY shohincd"; $strsql1 = "SELECT sm.shohinmei,sm.shohinmei2,sm.shohincd,sm.shohincd2, sd.stockqty ,sd.arrangeqty,sd.nonreserveqty,sm.kikaku,sm.irisuu,sm.aisuu,sm.sell_end_date,shomiflg,makercode,sm.rot,sm.nisugata,sm.zaiko,sd.centerid FROM `".$company."shohinmaster` AS sm LEFT JOIN ($strsql1) AS sd on sm.shohincd=sd.shohincd WHERE 1=1 ".$strsqljoin." GROUP BY sm.shohincd order by sm.shohincd"; //2.注文数 $strsql2="SELECT shohincd,sum(orderqty) as orderqty FROM `".$company."ordersheet` as sheet,`".$company."ordermain` as main WHERE sheet.ordermainid=main.ordermainid and main.checkedflg<5 and sheet.kariflg<4 ".$strsqlcenter." and operatedate<= $excutedate2 group by shohincd"; $strsql2 = "SELECT sm.shohincd,os.orderqty FROM `".$company."shohinmaster` AS sm LEFT JOIN ($strsql2) AS os on sm.shohincd=os.shohincd WHERE 1=1 ".$strsqljoin." GROUP BY sm.shohincd order by sm.shohincd"; //3.転送数（入荷）転送先センターコードで集計する //$strsql3 = "SELECT sm.shohincd,sum(td.transqty) AS transqty FROM `".$company."shohinmaster` AS sm LEFT JOIN `".$company."transdata` AS td on sm.shohincd=td.shohincd and td.transflg=0 and transdate<=CURDATE() ".$strsqlcenter2." WHERE 1=1 ".$strsqljoin." GROUP BY sm.shohincd order by sm.shohincd"; //3b.転送数（出荷）転送元センターコードで集計する $strsql3b = "SELECT sm.shohincd,sum(td.transqty) AS transqty FROM `".$company."shohinmaster` AS sm LEFT JOIN `".$company."transdata` AS td on sm.shohincd=td.shohincd and td.transflg=0 and transdate<= $excutedate2 ".$strsqlcenter." WHERE 1=1 ".$strsqljoin." GROUP BY sm.shohincd order by sm.shohincd"; //4.入荷数 $strsql4 = "SELECT sm.shohincd,sum(comeinqty) AS comeinqty,sum(comeinqty) AS kakuteiqty FROM `".$company."shohinmaster` AS sm LEFT JOIN `".$company."comeindata` AS cd on sm.shohincd=cd.shohincd and cd.comeinflg=0 and comeindate<=".$excutedate2.$strsqlcenter." WHERE 1=1 ".$strsqljoin." GROUP BY sm.shohincd order by sm.shohincd"; //SELECT 在庫.本部, 在庫.商品, 在庫.センター, Sum(在庫.在庫量) AS 在庫量の合計 //FROM 在庫 //GROUP BY 在庫.本部, 在庫.商品, 在庫.センター; //HAVING (((在庫.センター)=1)); //全数 $maxrow=sizeof($shohindata); //ダウンロード if ($_POST[dl] <>""){ $strdate = Sjis("在庫閲覧").date("Y-m-d-Gi").".csv"; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=$strdate"); header("Connection: close"); ob_end_clean(); $result=@mysql_query($strsql1,$my_con); mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result2=@mysql_query($strsql2,$my_con); mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result3=@mysql_query($strsql3,$my_con); mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result3b=@mysql_query($strsql3b,$my_con); mysql_sql_log2($strsql3b,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result4=@mysql_query($strsql4,$my_con); mysql_sql_log2($strsql4,$_SERVER['SCRIPT_NAME'].":".__LINE__); //タイトル行の表示 echo Sjis("No.,センター,取扱区分,商品コード1,商品コード2,商品名,商品名2,サプライヤー,入数,合数,規格,最低発注ロット数,荷姿,最終納品日,在庫,調整数(+),有効在庫,発注数(-),入荷数(+),移動数(-),当日末予定在庫"); echo "\n"; $i=1; while ($data = mysql_fetch_array($result)) { echo $i.","; $data2=@mysql_fetch_array($result2); $data3=@mysql_fetch_array($result3); $data3b=@mysql_fetch_array($result3b); $data4=@mysql_fetch_array($result4); echo Sprint(GetList($centerdata,$data["centerid"])); //センター echo Sprint(GetList($codedata9,$data["zaiko"])); //取扱区分 echo Sprint($data["shohincd"]); //商品コード echo Sprint($data["shohincd2"]); //商品コード2 echo Sprint($data["shohinmei"]); //商品名 echo Sprint($data["shohinmei2"]); //商品名2 echo Sprint(GetList($makerdata,$data["makercode"])); //ｻﾌﾟﾗｲﾔｰ echo Sprint($data["irisuu"]); //入数 echo Sprint($data["aisuu"]); //合数 echo Sprint($data["kikaku"]); //最低発注 echo Sprint($data["rot"]); //荷姿 echo Sprint($data["nisugata"]); //規格 echo Sprint($data["sell_end_date"]); //最終納品日  echo Sprint(number_format($data["stockqty"])); //在庫数 echo Sprint(number_format($data["arrangeqty"])); //調整数 echo Sprint(number_format($data["nonreserveqty"])); //有効在庫数 echo Sprint(number_format($data2["orderqty"])); //注文数 echo Sprint(number_format($data4["kakuteiqty"])); //有効在庫 //echo Sprint(number_format((int)$data3["transqty"])); //転送入荷数 echo Sprint(number_format((int)$data3b["transqty"])); //転送出荷数 echo Sprint(number_format((int)$data["stockqty"]-(int)$data2["orderqty"]+(int)$data4["kakuteiqty"] + (int)$data["arrangeqty"]+(int)$data3["transqty"]-(int)$data3b["transqty"])); //現在在庫 echo "\n"; $i++; } myclose(); exit; } elseif ($_POST[dl2] <>""){ $strdate = Sjis("在庫ロット別").date("Y-m-d-Gi").".csv"; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=$strdate"); header("Connection: close"); ob_end_clean(); $result=@mysql_query($strsql1,$my_con); mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__); //タイトル行の表示 echo Sjis("No.,センター,取扱区分,商品コード1,商品名,サプライヤー,ロケーション,管理,期限,入庫日,最終納品日,在庫,調整数,有効在庫,入数,合数,規格,備考"); echo "\n"; //1.在庫 $strsqllot = "SELECT shohincd,centerid,location, sum(stockqty) as stockqty ,sum(arrangeqty) as arrangeqty,sum(nonreserveqty) as nonreserveqty,stockdate,shomi,biko FROM `".$company."stockdata` WHERE shippingflg =1 AND validflg=1 ".$strsqlcenter." GROUP BY shohincd,shomi,stockdate"; $strsqllot = "SELECT sd.*,sm.shohinmei,sm.shohincd, sm.kikaku,sm.irisuu,sm.aisuu,sm.sell_end_date,shomiflg,makercode,sm.zaiko FROM `".$company."shohinmaster` AS sm INNER JOIN ($strsqllot) AS sd on sm.shohincd=sd.shohincd WHERE 1=1 ".$strsqljoin." order by sm.shohincd,shomi"; mysql_sql_log2($strsqllot,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result=@mysql_query($strsqllot,$my_con); $i=1; while ($data = mysql_fetch_array($result)) { echo $i.","; echo Sprint(GetList($centerdata,$data["centerid"])); //センター echo Sprint(GetList($codedata9,$data["zaiko"])); //取扱区分 echo Sprint($data["shohincd"]); //商品コード echo Sprint($data["shohinmei"]); //商品名 echo Sprint(GetList($makerdata,$data["makercode"])); //ｻﾌﾟﾗｲﾔｰ echo Sprint($data["location"]); //ロケーション PrintShomi($data[shomiflg],2); echo Sprint($data["shomi"]); // echo Sprint($data["stockdate"]); // echo Sprint($data["sell_end_date"]); //最終納品日  echo Sprint(number_format($data["stockqty"])); //在庫数 echo Sprint(number_format($data["arrangeqty"])); //調整数 echo Sprint(number_format($data["nonreserveqty"])); //有効在庫数 echo Sprint($data["irisuu"]); //入数 echo Sprint($data["aisuu"]); //合数 echo Sprint($data["kikaku"]); //規格 echo Sprint($data["biko"]); //備考 echo "\n"; $i++; } myclose(); exit; } elseif ($_POST[dl3] <>""){ $strdate = Sjis("出荷留め在庫ロット別").date("Y-m-d-Gi").".csv"; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=$strdate"); header("Connection: close"); ob_end_clean(); $result=@mysql_query($strsql1,$my_con); mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__); //タイトル行の表示 echo Sjis("No.,センター,取扱区分,商品コード1,商品名,サプライヤー,ロケーション,管理,期限,入庫日,最終納品日,在庫,調整数,有効在庫,入数,合数,規格,備考"); echo "\n"; //1.在庫 $strsqllot = "SELECT shohincd,centerid,location, sum(stockqty) as stockqty ,sum(arrangeqty) as arrangeqty,sum(nonreserveqty) as nonreserveqty,stockdate,shomi,biko FROM `".$company."stockdata` WHERE shippingflg =1 AND validflg=2 ".$strsqlcenter." GROUP BY shohincd,shomi,stockdate"; $strsqllot = "SELECT sd.*,sm.shohinmei,sm.shohincd, sm.kikaku,sm.irisuu,sm.aisuu,sm.sell_end_date,shomiflg,makercode,sm.zaiko FROM `".$company."shohinmaster` AS sm INNER JOIN ($strsqllot) AS sd on sm.shohincd=sd.shohincd WHERE 1=1 ".$strsqljoin." order by sm.shohincd,shomi"; mysql_sql_log2($strsqllot,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result=@mysql_query($strsqllot,$my_con); $i=1; while ($data = mysql_fetch_array($result)) { echo $i.","; echo Sprint(GetList($centerdata,$data["centerid"])); //センター echo Sprint(GetList($codedata9,$data["zaiko"])); //取扱区分 echo Sprint($data["shohincd"]); //商品コード echo Sprint($data["shohinmei"]); //商品名 echo Sprint(GetList($makerdata,$data["makercode"])); //ｻﾌﾟﾗｲﾔｰ echo Sprint($data["location"]); //ロケーション PrintShomi($data[shomiflg],2); echo Sprint($data["shomi"]); // echo Sprint($data["stockdate"]); // echo Sprint($data["sell_end_date"]); //最終納品日  echo Sprint(number_format($data["stockqty"])); //在庫数 echo Sprint(number_format($data["arrangeqty"])); //調整数 echo Sprint(number_format($data["nonreserveqty"] )); //有効在庫数 echo Sprint($data["irisuu"]); //入数 echo Sprint($data["aisuu"]); //合数 echo Sprint($data["kikaku"]); //規格 echo Sprint($data["biko"]); //備考 echo "\n"; $i++; } myclose(); exit; } //１ページ分 $strsql1 .= $limit; $strsql2 .= $limit; $strsql3 .= $limit; $strsql3b .= $limit; $strsql4 .= $limit; $result=@mysql_query($strsql1,$my_con); $row=@mysql_num_rows($result); mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__); //過去日付は在庫履歴テーブルより取得する if ($refdate>=0) { $result2=@mysql_query($strsql2,$my_con); mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result3=@mysql_query($strsql3,$my_con); mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result3b=@mysql_query($strsql3b,$my_con); mysql_sql_log2($strsql3b,$_SERVER['SCRIPT_NAME'].":".__LINE__); $result4=@mysql_query($strsql4,$my_con); mysql_sql_log2($strsql4,$_SERVER['SCRIPT_NAME'].":".__LINE__); } else { //過去日付は集計より取得する $strsql5="select datalog.shohincd,sum(zaikoqty) as zaikoqty,sum(comeqty) as comeqty,sum(transqty) as transqty,sum(arrangeqty) as arrangeqty,sum(orderqty) as orderqty,sum(transqty2) as transqty2,sum(nouhinqty) as nouhinqty from datalog INNER join shohinmaster as sm USING(honbuid,shohincd) where executedate=DATE_ADD(CURDATE(),INTERVAL $_POST[chgday] DAY)".$strsqljoin.$strsqlcenter." group by shohincd order by shohincd".$limit; Testecho($strsql5); $result5=@mysql_query($strsql5,$my_con); mysql_sql_log2($strsql5,$_SERVER['SCRIPT_NAME'].":".__LINE__); } ?>

"); ?> 対象
onclick="document.sww.Submit.disabled=true;document.sww.submit();">在庫有り



=0) { //本日分の表示 $data2=@mysql_fetch_array($result2); $data3=@mysql_fetch_array($result3); $data3b=@mysql_fetch_array($result3b); $data4=@mysql_fetch_array($result4); //debug checker if (($data["shohincd"]<>$data2["shohincd"]) or ($data["shohincd"]<>$data3b["shohincd"]) or ($data["shohincd"]<>$data4["shohincd"])) { $ERR = "処理エラー"; if ($_COOKIE[testmode]=="1") { $ERR .= $data["shohincd"]; $ERR .= "/".$data2["shohincd"]; $ERR .= "/".$data3["shohincd"]; $ERR .= "/".$data4["shohincd"]; } } ?> 0) { ?>
No. コード 商品名 ｻﾌﾟﾗｲﾔｰ 入数 合数 規格 最終納品日 在庫 調整数(+) 有効在庫 受注数(-) 入荷数(+) 移動出(-) 当日末予定在庫 日別
検索結果はゼロ件でした。
12) { $shohincd = mb_strcut($data["shohincd"],0,6)." ".mb_strcut($data["shohincd"],6,4)." ".mb_strcut($data["shohincd"],10,100); } elseif(mb_strlen($data["shohincd"]) > 6) { $shohincd = mb_strcut($data["shohincd"],0,6)." ".mb_strcut($data["shohincd"],6,100); } else { $shohincd = $data["shohincd"]; } if($data["stockqty"]>0) { ?>
　
   ')">詳細
')">