<?php  //1102.php出荷データ閲覧
/*****************************************************************************
// 2016/00/00
// 関連データベース・テーブル
// 参照：
// 	コード	code
// 	商品マスター	shohinmaster
// 	場所マスター	company（センター）
// 	出荷			shukka
// 	納品マスター	shozokumaster
// 変更履歴：
---	2016/06/13	流通型を追加
---	2016/07/16	複数サプライヤー対応 
---	2016/10/18	作業日と納品日の両方に対応、ダウンロード商品計、ページ移動追加	Ohyama
*****************************************************************************/
ini_set("max_execution_time",180);
ini_set('memory_limit', '512M');
set_time_limit(180);
include "func.cgi";
myopen();

//１ページ数
$pageset = 50;
//レコードの指定
if ($_POST[pagenum] == "") {
	$page = 1;
} else {
	$page = (int)$_POST[pagenum];
}

//データ取得数
$limit = " LIMIT ".($pageset*($page  - 1)).",$pageset";

//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//4ヶ月前の1日は？
$firstday =  date("z",strtotime(date("Y/m/1",strtotime ("-4 month"))));
$today = date("z");
if (($today - $firstday)< 0) {
	$firstday = 0 - ($today - $firstday +365);
} else {
	$firstday = 0 - ($today - $firstday);
}

//対象 2016/10/18
$day_typedata = array(array('納品日','deliverdate'),array('作業日','operatedate'));

$strsql = "";
//検索処理
$sw = Eucjp($_POST[searchword]);
$sw = mb_convert_kana($sw,'KV');  //全て全角へ変換

if ($sw<>"") {
	$strsqlwhere = " and searchword like '%".$sw."%'";
}

//出荷確定　//確定、未確定
$codedata2[] = array('全て',-1);
$codedata2[] = array('未確定',1);
$codedata2[] = array('確定済',2);

if ($_POST["intshukkaflg"] == "") {
	$intshukkaflg = -1;
} elseif ($_POST["intshukkaflg"] == "-1") {
	$intshukkaflg = $_POST["intshukkaflg"];
} elseif ($_POST["intshukkaflg"] == "1") {
	$intshukkaflg = $_POST["intshukkaflg"];
	$strwhereflg = " AND shukkaflg < 2 ";
} else {
	$intshukkaflg = $_POST["intshukkaflg"];
	$strwhereflg = " AND shukkaflg >= 2 ";
}

//サプライヤーコード
if ($_POST[maker]<>""){
	$strsqlwhere .= " and shu.supplyerid = '$_POST[maker]'";
}
if ($userdata["supplyerid2"]<> ""){
	$strwheremaker = " and shu.supplyerid 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);

//温度
$codedata1 = dbselect("cname,code","`".$company."code`","codekind = 1","code",-1);

//納品先コード
//ブランド
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,shozoku_string1,shozoku_string2","`".$company."shozokumaster` as main","1=1".$strsqlwhereshozoku,"shozokuid",-1);
testecho($strsqldbselect);
	//ブランド
	$codedata105 = dbselect("cname,code","`".$company."code`","codekind = 105 and code in (".$userdata["brand"].")","cname",-1);
	$codedata105 = array_merge_recursive($codedata10b, $codedata105);
} else {
	//ブランド
	$codedata105 = dbselect("cname,code","`".$company."code`","codekind = 105","cname",-1);
	$codedata105 = array_merge_recursive($codedata10b, $codedata105);
	$tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid,shozoku_string1","`".$company."shozokumaster` as main",-1,"shozokuid",-1);
testecho($strsqldbselect);
}

$tenpodataAll = $tenpodata;
if($_POST["brand"] == "-1") {
	$brand = -1;
} elseif($_POST["brand"] <> "") {
	$brand = $_POST["brand"];
	$strsqlwherebrand .= " AND brand = '".$brand."' ";
} else {
	$brand = -1;
}

if ($userdata["kengen"] == 50) {
	$strsqltenpo = " AND main.shozokuid='".$userdata["shozokuid"]."'";
	$shozokuid = $userdata["shozokuid"];
	$tenpodata =dbselect("shozokuname,shozokuid","`".$company."shozokumaster`","shozokuid = '".$shozokuid."'",-1,-1);
} elseif ($_POST[shop]<>"") {
	$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);
	$strsqlshop = " and ".$strsqlshop;
	if(sizeof($tenpodata2) == 1) {
		$shozokuid = $tenpodata2[0][1];
		$strsqlwhere .= " and shu.shozokuid = '".$shozokuid."'";
	} elseif(sizeof($tenpodata2) == 0) {
		$shozokuid = "";
		$tenpodata = array(array("該当データありません",""));
	} else {
		$shozokuid = "";
		$tenpodata = $tenpodata2 ;
	}
} elseif ($_POST[tenpo]<>"") {
	$shozokuid = $_POST[tenpo];
	$strsqlwhere .= " and shu.shozokuid = '".$shozokuid."'";
}

//センターコード
if ($_POST[center]<>""){
	$strsqlwhere .= " and shu.centerid = '$_POST[center]'";
}

//コード
if ($_POST[code]<>""){
	$strsqlwhere .= " and sm.code = '$_POST[code]'";
}

//期間
if ($_POST[startdate] <> ""){
	$day_type = $_POST[day_type];
	$startdate = $_POST[startdate]; $enddate = $_POST[enddate];
} else {
	$startdate = date("Y-m-d");
	$enddate = date("Y-m-d");
	$day_type = "operatedate";
	$strsqldate  = " and $day_type >= '".$startdate."'";
	$strsqldate .= " and $day_type <= '".$enddate."'";
}
$strsqldate  = " and $day_type >= '".$startdate."'";
$strsqldate .= " and $day_type <= '".$enddate."'";

//並び順
$strsqlorder1 = " order by centerid,shozokuid,shukkadate,code,shohincd,price_piece,shukkaid";
$strsqlorder2 = " order by centerid,shozokuid,FLG";

//カテゴリー
$codedata107a = dbselect("cname,code","`".$company."code`","codekind = 107","code",-1);
$codedata107b[] = array('全て',-1);
$codedata107 = array_merge_recursive($codedata107b, $codedata107a);
if ($_POST[category] == ""){
	$category = -1;
} elseif ((int)$_POST[category] >= '0'){
	$category = (int)$_POST[category];
	$strsqlwhere .= " and sm.category = '$category'";
} else {
	$category = -1;
}

//出荷実績
$strsql = "select shu.shukkaid,shu.orderid,shu.`shozokuid`,shu.supplyerid, sm.*, shu.`centerid`, shu.`stockdate`, shu.shomi,  shu.`shukkaqty`, shu.`operatedate`,shu.`shukkadate`,shu.`deliverdate`,shu.`totalgram`,shu.`memo` ,shu.`memo2`,shu.`memo3`,shu.`memoadd` ,shu.shukkaflg,shu.price_piece,shu.price_piece2,shu.price_piece3,shu.lotnum,shu.shomi,shu.price_total,shu.price_total2,shu.price_total3,shu.totalgram,sm.shohincd2 ,shu.DC_TC,shu.creater,shu.updater,shu.updatedate,shu.createdate,sm.shohin_kubun4 from `".$company."shohinmaster` AS sm INNER JOIN `".$company."shukka` AS shu USING(shohincd) 
where shu.shukkaqty <> 0 ".$strsqldate.$strsqlwhere.$strsqlwherebrand.$strwheremaker.$strsqlwhereshozoku.$strwhereflg.$strsqlorder1;

//オプション
$codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104 and code > 0","codeid",-1);
Testecho($strsql);

//ダウンロード
if (($_POST[kubun] == "dl2") or ($_POST[kubun] == "dl")){//dl2ダウンロード（明細）dlダウンロード（明細）2
	if ($_POST[kubun] == "dl") {
		//発注数
		$orderdata = dbselect("orderqty,orderid","`".$company."ordermain` INNER JOIN `".$company."ordersheet` USING(ordermainid)","operatedate between '".$_POST[startdate]."' AND '".$_POST[enddate]."'","orderid",-1);
	}
	$strdate = Sjis("出荷".date("Ymd-Gi").".csv");
	header("Content-type:application/octet-stream");
	header("Content-Disposition:attachment;filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	//50直営納品先	：　商品単価　←（price_sell）　を表示
	//50FC納品先		：　商品単価　←（price_sell2）　を表示
	//40サプライヤー：　通過商品単価　←（price_buy）　を表示
	//30センター	：　通過商品単価　←（price_buy）　を表示
	//20納品先本部	：　通過商品単価、直営店単価、FC店単価　の3つを表示
	//20仕入本部	：　通過商品単価、直営店単価、FC店単価　の3つを表示
	//10管理者		：　通過商品単価、直営店単価、FC店単価　の3つを表示
	$totalamount1=0;$totalamount2=0;$totalamount3=0;$totalamount4=0;$totalamount5=0;

	if ($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	
		if($userdata["roleid"] == "1x") {
			echo Sjis("\"No\",\"納品先コード\",\"納品先名\",\"商品コード1\",\"商品コード2(本部)\",\"商品名\",\"サプライヤー\",\"規格\",\"単位\",\"荷姿\",\"出荷作業日\",\"発注数\",\"出荷確定数\",\"備考\",\"定貫区分\",\"重量Kg\",\"加工単価\",\"加工小計\",\"店着単価\",\"店着小計\",\"店着全計\",\"仕入単価\",\"仕入小計\",\"仕入全計\",\"オプション\",\"カテゴリ\",\"注文明細ID\",\"出荷ID\",\"納品日\",\"出荷確定\",\"サプライヤー\",\"流通型\"")."\r\n";
		} elseif ($_POST[kubun] == "dl2"){
			echo Sjis("\"No\",\"納品先コード\",\"納品先名\",\"商品コード1\",\"商品コード2(本部)\",\"商品名\",\"規格\",\"出荷日\",\"出荷確定数\",\"備考\",\"定貫区分\",\"重量Kg\",\"加工単価\",\"加工小計\",\"店着単価\",\"店着小計\",\"店着全計\",\"仕入単価\",\"仕入小計\",\"仕入全計\",\"オプション\",\"カテゴリ\",\"納品日\",\"出荷確定\",\"サプライヤー\",\"流通型\"");
			if($userdata["roleid"] == 1) {echo ","; Sprint("orderid");Sprint("shukkaid");Sprint("DC_TC");Sprint("LOT"); }
			echo "\r\n";//		echo "\r\n";
		} else {
			echo Sjis("\"No\",\"納品先コード\",\"納品先名\",\"商品コード1\",\"商品コード2(本部)\",\"商品名\",\"サプライヤー\",\"規格\",\"単位\",\"荷姿\",\"出荷作業日\",\"発注数\",\"出荷確定数\",\"備考\",\"定貫区分\",\"重量Kg\",\"加工単価\",\"加工小計\",\"店着単価\",\"店着小計\",\"店着全計\",\"仕入単価\",\"仕入小計\",\"仕入全計\",\"オプション\",\"カテゴリ\",\"納品日\",\"出荷確定\",\"サプライヤー\",\"流通型\"");
			if($userdata["roleid"] == 1) {echo ","; Sprint("orderid");Sprint("shukkaid");Sprint("DC_TC");Sprint("LOT"); }
			echo "\r\n";//		echo "\r\n";
		}
	} elseif($userdata["kengen"] == 50) {
		echo Sjis("\"No\",\"納品先コード\",\"納品先名\",\"商品コード\",\"商品コード2(本部)\",\"商品名\",\"規格\",\"出荷作業日\",\"出荷作業日\",\"出荷確定数\",\"備考\",\"定貫区分\",\"重量Kg\"\"単価\",,\"合計金額\",\"オプション\",\"カテゴリ\",\"納品日\",\"出荷確定\",\"サプライヤー\",\"流通型\"")."\r\n";
	} else {
		echo Sjis("\"No\",\"納品先コード\",\"納品先名\",\"商品コード\",\"商品コード2(本部)\",\"商品名\",\"規格\",\"出荷作業日\",\"出荷確定数\",\"備考\",\"定貫区分\",\"重量Kg\",\"単価\",\"合計金額\",\"オプション\",\"カテゴリ\",\"納品日\",\"出荷確定\",\"サプライヤー\",\"流通型\"")."\r\n";
	}

	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;

	while ($data = mysql_fetch_array($result)) {
		echo $i.",";
//		echo Sprint(GetList($centerdata,$data["centerid"]));
		echo Sprint($data["shozokuid"]);
		echo Sprint(GetList($tenpodataAll,$data["shozokuid"]));
		echo Sprint($data["shohincd"]);
		echo Sprint($data["shohincd2"]);
		if ($data["shohincd"] == "0") {
			echo Sprint($data["memo3"]);
		} else {
			echo Sprint($data["shohinmei"]);
		}
		if ($_POST[kubun] == "dl2"){
			echo Sprint($data["kikaku"]);
		} else {
			echo Sprint(GetList($makerdata,$data["supplyerid"]));
			echo Sprint($data["nisugata"]);        //荷姿(規格）
			echo Sprint($data["shohin_string2"]);  //規格（価格単位）
			echo Sprint($data["kikaku"]);          //単位
		}
		echo Sprint($data["operatedate"]);
//		echo Sprint($data["deliverdate"]);
		if ($_POST[kubun] == "dl2"){
		} else {
			echo Sprint((int)GetList($orderdata,$data["orderid"]));
		}
		echo Sprint($data["shukkaqty"]);
		echo Sprint($data["memo"].$data["memoadd"]);
//		echo Sprint(GetList($codedata,$data["code"]));
		if($data["shohin_kubun3"] == 1) {
			echo Sprint("不定貫");
		} else {
			echo Sprint("定貫");
		}

		if($data["totalgram"]==0) {
			echo ",";
		} else {
			echo Sprint($data["totalgram"]);
		}
		if($userdata["cost_dispoff"] == 1) { //仕入れ金額非表示
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
		} else {
			echo Sprint((int)$data["price_piece3"]);
			echo Sprint((int)$data["price_total3"]);
			echo Sprint((int)$data["price_piece"]);
			echo Sprint((int)$data["price_total"]);
			echo Sprint((int)$data["price_total"] +(int)$data["price_total3"]);
			if ($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	
				echo Sprint((int)$data["price_piece2"]);
				echo Sprint((int)$data["price_total2"]);
				echo Sprint((int)$data["price_total2"] +(int)$data["price_total3"]);
			}
		}
		$totalamount1 += (int)$data["price_total"];
		echo Sprint(GetList($codedata104,$data["memo2"],0));
		echo Sprint($data["category"]."_".GetList($codedata107,$data["category"]));
		echo Sprint($data["deliverdate"]);
		if($data["shukkaflg"] < 2 ) {
			echo Sprint("未");
		} else {
			echo Sprint("済");
		}
		echo Sprint(GetList($makerdata,$data["supplyerid"]));
		if($userdata["roleid"] == 1) {echo Sprint($data["orderid"]);Sprint($data["shukkaid"]); ;Sprint($data["DC_TC"]);Sprint($data["lotnum"]); }
		echo Sprint(GetListData($codedata10,$data["ryutu_type"],0));
		echo "\r\n";//		echo "\r\n";
		$i++;
	}
	if ($userdata["kengen"]<50) {  //10管理者　20本部　30:センター	
//		echo Sjis(",,,,,,,,,,,,,,,,,,\"合計金額\",,,")."\r\n";
//		echo      ",,,,,,,,,,,,,,,,,,";
//		echo Sprint($totalamount1);
	} elseif($userdata["kengen"]==50) {
//		echo Sjis(",,,,,,,,,,,,,,,,\"合計金額\",,,")."\r\n";
//		echo      ",,,,,,,,,,,,,,,,";
//		echo Sprint($totalamount1);
	} else {
//		echo Sjis(",,,,,,,,,,,,,,,,\"合計金額\",,,")."\r\n";
//		echo      ",,,,,,,,,,,,,,,,";
//		echo Sprint($totalamount1);
	}
	myclose();
	exit;
} elseif ($_POST[kubun] =="dl1"){ //ダウンロード(納品先計
	//合計
	$strsql = "select shozokuid,`centerid`, sum(shu.price_total) as price_total,sum(shu.price_total2) as price_total2,sum(shu.price_total3) as price_total3 ,'1' as FLG from `".$company."shohinmaster` AS sm INNER JOIN `".$company."shukka` AS shu USING(shohincd) 
	where shukkaqty <> 0 and shohincd NOT like '99999%'  ".$strsqldate.$strsqlwhere.$strwheremaker.$strsqlwhereshozoku." GROUP BY shozokuid";
	$strsql .= " UNION select shozokuid,`centerid`, sum(shu.price_total) as price_total,sum(shu.price_total2) as price_total2,sum(shu.price_total3) as price_total3 ,'2' as FLG from `".$company."shohinmaster` AS sm INNER JOIN `".$company."shukka` AS shu USING(shohincd) 
	where shukkaqty <> 0 and shohincd like '99999%' ".$strsqldate.$strsqlwhere.$strwheremaker.$strsqlwhereshozoku." GROUP BY shozokuid";
	$strsql .= " UNION select shozokuid,`centerid`, sum(shu.price_total) as price_total,sum(shu.price_total2) as price_total2,sum(shu.price_total3) as price_total3 ,'3' as FLG from `".$company."shohinmaster` AS sm INNER JOIN `".$company."shukka` AS shu USING(shohincd) 
	where shukkaqty <> 0 ".$strsqldate.$strsqlwhere.$strwheremaker.$strsqlwhereshozoku." GROUP BY shozokuid";
	$strsql .= $strsqlorder2;

	$strdate = Sjis("出荷合計（納品先別合計）".date("Ymd-Gi")."TOTAL.csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	if ($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	
		echo Sjis("\"納品先コード\",\"納品先名\",\"区分\",\"加工小計\",\"店着小計\",\"店着全計\",\"仕入小計\",\"仕入全計\",")."\r\n";
	} else {
		echo Sjis("\"納品先コード\",\"納品先名\",\"区分\",\"加工小計\",\"商品小計\",\"全計\",")."\r\n";
	}
	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;

	while ($data = mysql_fetch_array($result)) {
		echo Sprint($data["shozokuid"]);
		echo Sprint(GetList($tenpodataAll,$data["shozokuid"]));
		if ($data["FLG"] == 1) {
			echo Sprint("1.商品代"); 
		} elseif ($data["FLG"] == 2) {
			echo Sprint("2.配送代"); 
		} else {
			echo Sprint("3.全合計"); 
		}
		if($userdata["cost_dispoff"] == 1) { //仕入れ金額非表示
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
			echo Sprint("-");
		} else {
			echo Sprint((int)$data["price_total3"]); //加工
			echo Sprint((int)$data["price_total"]);  //店着
			echo Sprint((int)$data["price_total"] +(int)$data["price_total3"]);
			if($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	
				echo Sprint((int)$data["price_total2"]);  //仕入
				echo Sprint((int)$data["price_total2"] +(int)$data["price_total3"]);
			}
		}
		$totalamount1 += (int)$data["price_total"];
		echo "\r\n";//		echo "\r\n";
		$i++;
	}
/*	if ($userdata["kengen"]==50) {
		echo Sjis(",,,,,,,,\"総合計金額\"")."\r\n";
		echo      ",,,,,,,,";
		echo Sprint($totalamount4);
	} elseif ($userdata["kengen"]<30) {
		echo Sjis(",,,,,,,\"総合計額\",,")."\r\n";
		echo      ",,,,,,,";
		echo Sprint($totalamount4);
	} else {
		echo Sjis(",,,,,,,,\"総合計額\",,")."\r\n";
		echo      ",,,,,,,,";
		echo Sprint($totalamount5);
	}*/
	myclose();
	exit;
} elseif ($_POST[kubun] =="dl3"){ //ダウンロード(納品先リスト)
	//合計
	$strsql = "select shozokuid, shozokuname,sho.route,count(shu.shukkaid) as cnt,postcode,address1,address2,address3,address4 from `".$company."shozokumaster` AS sho INNER JOIN `".$company."shukka` AS shu USING(shozokuid) 
where shukkaqty <> 0 and shohincd NOT like '99999%'  ".$strsqldate.$strsqlwhere." GROUP BY shozokuid having cnt>0 order by shu.route,sho.shozokuid";

	$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;

	while ($data = mysql_fetch_array($result)) {
		echo Sprint($data["shozokuid"]);
		echo Sprint($data["shozokuname"]);
		echo Sprint($data["route"]);
		echo Sprint($data["postcode"]);
		echo Sprint($data["address1"]);
		echo Sprint($data["address2"]);
		echo Sprint($data["address3"]);
		echo Sprint($data["address4"]);
		echo "\r\n";//		echo "\r\n";
		$i++;
	}
	myclose();
	exit;
} elseif ($_POST[kubun] == "dl5"){ //ダウンロード明細K3(関東食糧仕様）
	$strdate = Sjis("出荷明細K".date("Ymd-Gi").".csv");
	header("Content-type:application/octet-stream");
	header("Content-Disposition:attachment;filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	echo Sjis("\"［納品日］\",\"［取引先コード］\",\"［取引先名］\",\"空白(受注形式）\",\"空白（取引区分）\",\"［自社管理商品コード］\",\"［商品名］\",\"［自社単位コード］\",\"［単価］\",\"［数量］\",\"［単位］\",\"［取引ID_SYSTEM］\",\"\"");
	echo "\r\n";//		echo "\r\n";

	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;

	while ($data = mysql_fetch_array($result)) {
		if($data["centerid"] == "c301") {
			echo Sprint(str_replace("-","",$data["deliverdate"]));  //出荷日
			if($data["shohin_kubun4"] == 1) {
				echo Sprint(GetListData($tenpodataAll,$data["shozokuid"],5));
			} else {
				echo Sprint(GetListData($tenpodataAll,$data["shozokuid"],4));
			}
			echo Sprint(GetListData($tenpodataAll,$data["shozokuid"],0));
		} else {
			echo Sprint(str_replace("-","",$data["operatedate"]));  //出荷日
			echo Sprint($data["shozokuid"]);
			echo Sprint(GetList($tenpodataAll,$data["shozokuid"]));
		}
		echo Sprint("1");
		echo Sprint("0");
		if($data["centerid"] == "c301") {
			echo Sprint($data["shohincd3"]);
		} else {
			echo Sprint($data["shohincd2"]);
		}
		echo Sprint($data["shohinmei"]);
		if($data["centerid"] == "c301") {
			$nisugata = $data["shohin_string6"];
		} else {
			$nisugata = $data["nisugata"];
		}
		switch($nisugata) {
			case "甲":
				echo Sprint("1");
				break;
			case "ケース":
				echo Sprint("2");
				break;
			case "ボール":
				echo Sprint("3");
				break;
			case "バラ":
				echo Sprint("4");
				break;
			default:
				echo Sprint("1-4以外".$nisugata);
				break;
		}
		echo Sprint($data["price_piece2"]);
		if((int)$data["totalgram"] == 0) {
			echo Sprint(str_replace(".0","",$data["shukkaqty"]));
		} else {
			echo Sprint(str_replace(".000","",$data["totalgram"]));
		}
		echo Sprint($nisugata);
		echo Sprint("334378224");
		echo Sprint("");
		echo "\r\n";//		echo "\r\n";
		$i++;
	}
	myclose();
	exit;
} elseif ($_POST[kubun] == "dl6"){ //ダウンロード商品計
	$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\",\"センター\",\"商品コード1\",\"商品コード2\",\"商品コード3\",\"商品名\",\"サプライヤー\",\"出荷数\",\"重量Kg\",\"温度\",\"規格\",\"荷姿\",\"入数\",\"合数\",\"店着全計\",\"カテゴリ\",\"明細行\",\"流通型\",\"最低単価\",\"最高単価\",\"平均単価\"")."\r\n";

	//出荷実績
	$strsql = "
	SELECT count(shu.shukkaid) as cnt,shu.supplyerid,  shu.`centerid`, SUM(shu.`shukkaqty`) as shukkaqty ,SUM(shu.`totalgram`) as totalgram ,SUM(shu.price_total) as price_total,shu.DC_TC,sm.shohin_kubun4,min(price_piece) as minprice,max(price_piece) as maxprice ,companyname,sm.*
	FROM `".$company."shohinmaster` AS sm 
	INNER JOIN `".$company."shukka` AS shu 
	USING(shohincd) ,
	company as com
	WHERE com.companyid = shu.supplyerid AND shu.shukkaqty <> 0 ".$strsqldate.$strsqlwhere.$strsqlwherebrand.$strwheremaker.$strsqlwhereshozoku.$strwhereflg."
	GROUP BY shu.centerid,shu.shohincd,shu.supplyerid
	ORDER BY shu.centerid,shu.shohincd ";

	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;

	while ($data = mysql_fetch_array($result)) {
		Sprint($i);
		Sprint($data["centerid"].".".GetListData($centerdata,$data["centerid"],0));
		Sprint($data["shohincd"]);
		Sprint($data["shohincd2"]);
		Sprint($data["shohincd3"]);
		Sprint($data["shohinmei"]);
		Sprint($data["supplyerid"].".".$data["companyname"]);
		Sprint($data["shukkaqty"]);
		Sprint($data["totalgram"]);
		Sprint($data["code"].".".GetList($codedata1,$data["code"]));
		Sprint($data["kikaku"]);
		Sprint($data["nisugata"]);
		Sprint($data["irisuu"]);
		Sprint($data["aisuu"]);
		Sprint($data["price_total"]);
		Sprint($data["category"].".".GetList($codedata107,$data["category"]));
		Sprint($data["cnt"]);
		Sprint($data["DC_TC"].".".GetListData($codedata10,$data["ryutu_type"],0));
		Sprint($data["minprice"]);
		Sprint($data["maxprice"]);
		Sprint($data["price_total"]/$data["shukkaqty"]);
		echo "\r\n";//		echo "\r\n";
		$i++;
	}
	myclose();
	exit;
} elseif ($_POST[kubun] =="disp"){
	$result=@mysql_query($strsql,$my_con);
	$maxrow=@mysql_num_rows($result);
	//１ページ分
	$strsql .= $limit;
	$result=@mysql_query($strsql,$my_con);
	$row=@mysql_num_rows($result);
}
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<?php title(); ?>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function submitALL3() {
  form = document.sww
  form.action= '5530.php'
  form.kubun.value= '';
  form.target= 'seikyu';
  form.submit()
}
function submitALL2() {
  form = document.sww
  form.kubun.value= 'disp'
  form.submit()
}

function submitck2() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'disp'
  form.submit()
}
function submitdl1() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl1'
  form.submit()
}

function submitdl2() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl2'
  form.submit()
}
function submitdl3() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl3'
  form.submit()
}
function submitdl4() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl'
  form.submit()
}
function submitdl5() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl5'
  form.submit()
}
function submitdl6() {
  form = document.sww
  form.action= '1102.php#fragment-5'
  form.target= '_top'
  form.kubun.value= 'dl6'
  form.submit()
}
function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  form.order.value= order
  FormGetSubmit.submit()
}

-->
</SCRIPT>
<body>
<?php Honbutitle3("出荷実績閲覧",$_SERVER['PHP_SELF']); ?>
<div class="border1">
<form action="1102.php#fragment-5" method="post" name="sww" target="">
	<span class="border1box">
	期間指定<br>
	<select name="day_type">
	 <?php PrintSelectList($day_typedata,$day_type,0); ?>
	</select>
	<?php 
	//発注日セレクトリスト（開始日）
//	if ($_POST[startdate]=="") {$defaultdate = IntervalDay(-1,1,1); } else {$defaultdate=$_POST[startdate]; } //初期値セット　指定がなければ前月末日
	if ($_POST[startdate]=="") {$defaultdate = 0; } else {$defaultdate=$_POST[startdate]; } //初期値セット　指定がなければ前月末日
//	PrintSelectDay5(IntervalDay(-6,1,2),10,"startdate",$defaultdate,"出荷作業日期間<br>",-1);
	PrintSelectDay5(-360,10,"startdate",$defaultdate,"",-1);
	?>
	～
	<?php 
	//発注日セレクトリスト（終了日）
//	if ($_POST[enddate]=="") {$defaultdate = IntervalDay(-1,2,1); } else {$defaultdate=$_POST[enddate]; } //初期値セット　指定がなければ前月末日
	if ($_POST[enddate]=="") {$defaultdate = 0; } else {$defaultdate=$_POST[enddate]; } //初期値セット　指定がなければ前月末日
//	PrintSelectDay5(IntervalDay(-6,1,2),10,"enddate",$defaultdate,"",-1);
	PrintSelectDay5(-360,10,"enddate",$defaultdate,"",-1);
 ?>	</span>
<?php InputItem(1,1,-1,2,1,-1,1); //センター ?>
<?php InputItem(4,2,-1,2,1,-1,1); //温度帯 ?>
	<span class="border1box">
	業態<br>
	<select name="brand">
	<?php PrintSelectList2($codedata105,$brand,0); ?>
	</select>
	</span>
<?php InputItem(2,2,-1,2,2,$shozokuid,1); //納品先 ?>
<?php InputItem(3,2,-1,2,1,-1,1); //サプライヤー ?>
<?php showSearchbox($sw,1,-1); //商品検索 ?>
	<span class="border1box">
		出荷確定<br>
		<select name="intshukkaflg" xonchange="document.sww.Submit.disabled=true;submitALL2();return false;">
		<?php
		 PrintSelectList($codedata2,$intshukkaflg,0); ?>
		</select>
	</span>
	<span class="border1box">
		流通型<br>
		<select name="ryutu_type">
		<?php PrintSelectList($codedata10,$ryutu_type,0); ?>
		</select>
	</span>
	<span class="border1box">
		カテゴリ<br>
		<select name="category">
		<?php PrintSelectList($codedata107,$category,0); ?>
		</select>
	</span>
	<span class="border1box">
	<br>
	<INPUT type="hidden" name="kubun" value="">
	<INPUT type="button" onClick="document.sww.Submit.disabled=true;submitck2(); return true" name="Submit" value="検　索" class="box1">
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitALL3(); return true" name="seikyu" value="請求書" class="box1" <?php if($row==0) echo "disabled"; ?>>
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl2(); return true" name="dl20" value="ダウンロード（明細）" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl4(); return true" name="dl40" value="ダウンロード（明細）2" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl5(); return true" name="dl50" value="ダウンロード（明細）3K" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl1(); return true" name="dl10" value="ダウンロード(納品先計)" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl3(); return true" name="dl30" value="ダウンロード(納品先リスト)" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
	<span class="border1box">
	<br>
	<INPUT type="button" onClick="submitdl6(); return true" name="dl60" value="ダウンロード(商品計)" class="box1" <?php if($row==0) echo "disabled"; ?> >
	</span>
</form>
</div>
<?php  if ($_POST[kubun] <> "disp") {
	PrintMsg("","検索してください。",700);
} elseif ($maxrow == 0) {
	//start NG
	PrintMsg("","この条件での該当データはありませんでした。",700);
} else { 
ShowNavBar2($maxrow,$pageset,$page,"500",1);
?>
<br>
<table id="data-table">
<tr>
<th rowspan="2">No</th>
<?php 
//タイトル行の表示
?>
<th rowspan="2">センター名</th>
<th rowspan="2">納品先</th>
<th rowspan="2">サプライヤー</th>
<th rowspan="2">商品コード</th>
<th rowspan="2">商品コード2</th>
<th rowspan="2">商品コード3</th>
<th rowspan="2">商品名</th>
<th rowspan="2">出荷数</th>
<th rowspan="2">作業日</th>
<th rowspan="2">納品日</th>
<th rowspan="2">作成者</th>
<th rowspan="2">更新者</th>
<th rowspan="2">更新日</th>
<th rowspan="2">定貫区分</th>
<th rowspan="2">重量</th>
<th rowspan="2">温度</th>
<th rowspan="2">メモ</th>
<th rowspan="2">オプション</th>
<th rowspan="2">カテゴリ名</th>
<th rowspan="2">出荷確定</th>
<?php
	if($userdata["cost_dispoff"] == 1) { 	//仕入れ金額非表示
	} else {
?>
<th rowspan="2">加工単価</th>
<th rowspan="2">加工計</th>
<?php
		if($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター 50:納品先	?>
<th colspan="3">店着</th>
<th colspan="3">仕入</th>
</tr>
<?php 	}  
	} ?>
<?php
	if($userdata["cost_dispoff"] == 1) { 	//仕入れ金額非表示
?><tr>
<?php
	} else {
?>
<tr>
<th>単価</th>
<th>小計</th>
<th>全計</th>
<?php
		if ($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	?>
<th>単価</th>
<th>小計</th>
<th>全計</th>
<?php 	}  
	} 
	Testecho3("注文明細ID",3);
	Testecho3("出荷ID",3);
	Testecho3("LOT",3);
?>
			<th>流通型</th>
</tr>
<?php 

	$j = $pageset*($page  - 1);
	while ($data = mysql_fetch_array($result)) {
?>
<tr> 
	<td><?php echo ($j+1);// ?></td>
	<td><?php PrintList($centerdata,$data[centerid],0); ?></td>
	<td><?php echo $data[shozokuid]." ";PrintList($tenpodataAll,$data[shozokuid],0); ?></td>
	<td><?php PrintList($makerdata,$data[supplyerid],0); ?></td>
	<td><?php echo $data["shohincd"]; ?></td>
	<td><?php echo $data["shohincd2"]; ?></td>
	<td><?php echo $data["shohincd3"]; ?></td>
	<td><?php if ($data["shohincd"] == "0") {echo $data["memo3"]; } else {echo $data["shohinmei"];} ?></td>
	<td class="rt"><?php echo str_replace(".0","",$data["shukkaqty"]); ?></td>
	<td><?php echo $data["operatedate"]; ?></td>
	<td><?php echo $data["deliverdate"]; ?></td>
	<td><?php echo $data["creater"]; ?></td>
	<td><?php echo $data["updater"]; ?></td>
	<td><?php echo $data["updatedate"]; ?></td>
	<td class="rt"><?php if ((int)$data["shohin_kubun3"] == 1) {echo "不"; }?>定貫</td>
	<td class="rt"><?php if ($data["totalgram"] <> 0) {echo number_format($data["totalgram"],2); }?></td>
	<td><?php PrintList($codedata1,$data["code"],0); ?></td>
	<td><?php echo nl2br(htmlspecialchars($data["memo"].$data["memoadd"])); ?></td>
	<td><?php PrintList($codedata104,$data["memo2"],0); ?></td>
	<td>
<?php if ($data["shohincd"] == '0') { } else {
	PrintList($codedata107,$data["category"],0);
	}
?>
	</td>
	<td><?php if($data["shukkaflg"] < 2 ) {  PrintMsg("未","",30); } else { PrintMsg("","済",30);} ?></td>
<?php
	if($userdata["cost_dispoff"] == '1') { 	//仕入れ金額非表示
	} else {
?>
	<td class="rt"><?php echo number_format($data["price_piece3"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_total3"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_piece"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_total"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_total"] + $data["price_total3"],0); ?></td>
<?php
		if ($userdata["kengen"] < 50) {  //10管理者　20本部　30:センター	?>
	<td class="rt"><?php echo number_format($data["price_piece2"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_total2"],0); ?></td>
	<td class="rt"><?php echo number_format($data["price_total2"] + $data["price_total3"],0); ?></td>
<?php	}
	} ?>
<?php
	Testecho3($data["orderid"],2);
	Testecho3($data["shukkaid"],2);
	Testecho3($data["lotnum"],2);
?>
	<td><?php PrintList($codedata10,$data["ryutu_type"],0); ?></td>
</tr>
<?php 
		$j++;
	}
?>
</table>
<?php 
	ShowNavBar2($maxrow,$pageset,$page,"75%",1);
?>
<br>

<FORM METHOD="POST" name="FormGetSubmit" action="1102.php#fragment-5" >
<INPUT type="hidden" name="day_type"          value="<?php echo $day_type; //基準日 ?>">
<INPUT type="hidden" name="startdate"              value="<?php echo $startdate; //開始日?>">
<INPUT type="hidden" name="enddate"              value="<?php echo $enddate; //終了日?>">
<INPUT type="hidden" name="center" value="<?php echo $_POST[center]; //センター ?>">
<INPUT type="hidden" name="code" value="<?php echo $_POST[code]; //温度帯 ?>">
<INPUT type="hidden" name="brand" value="<?php if($_POST["brand"] <> -1) echo $_POST["brand"]; //業態 ?>"><br>
<INPUT type="hidden" name="shop" value="<?php echo $_POST[shop]; //納品先検索 ?>">
<INPUT type="hidden" name="tenpo" value="<?php echo $_POST[tenpo]; //納品先 ?>">
<INPUT type="hidden" name="maker" value="<?php echo $_POST[maker]; //サプライヤー ?>">
<INPUT type="hidden" name="searchword"          value="<?php echo $sw; //検索語 ?>">
<INPUT type="hidden" name="intshukkaflg" value="<?php if($intshukkaflg <> -1) echo $intshukkaflg; //出荷確定 ?>">
<INPUT type="hidden" name="ryutu_type" value="<?php if($_POST[ryutu_type] <> -1) echo $_POST[ryutu_type]; //流通型 ?>"><br>
<INPUT type="hidden" name="category"          value="<?php if($_POST[category] <> -1) echo $_POST[category]; //カテゴリ ?>">
<INPUT type="hidden" name="page"        value="">
<INPUT type="hidden" name="pagenum"                value="">
<INPUT type="hidden" name="kubun"        value="disp">
<INPUT type="hidden" name="order"        value="">
<INPUT type="hidden" name="gyotai" value="<?php echo $_POST[gyotai]; //業態 ?>">
</DIV>
</FORM>


<?php } ?>
<br>
<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
Function Sprint($str) {
	if($str == "0" ) {
		echo "\"0\",";
	} else {
		echo "\"".Sjis($str)."\",";
	}
}
myclose();

Testecho($strsql);

?>