<?php  //出荷データＣＳＶダウンロード（鮮魚）出荷作業日ベース
ini_set("max_execution_time",180);
ini_set('memory_limit', '512M');
set_time_limit(180);
include "func.cgi";
myopen();

//再チェック
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);
}


$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 sm.makercode = '$_POST[maker]'";
}
if ($userdata["supplyerid2"]<> ""){
	$strwheremaker = " and sm.makercode in (".$userdata["supplyerid2"].") ";
}

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

$tenpodataAll = $tenpodata;
if($_POST["brand"] == "") {
	$brand = -1;
} elseif($_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]'";
}

//出荷作業日日
$strsqlwhere .= " and operatedate >= '$_POST[startdate]'";
$strsqlwhere .= " and operatedate <= '$_POST[enddate]'";


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

//出荷実績
$strsql = "select shu.shukkaid,shu.orderid,shu.`shozokuid`, 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 ".$strsqlwhere.$strsqlwherebrand.$strwheremaker.$strsqlwhereshozoku.$strwhereflg.$strsqlorder1;

//魚カテゴリー
$codedata107 = dbselect("cname,code","`".$company."code`","codekind = 107","code",-1);
//オプション
$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["makercode"]));
			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["makercode"]));
		if($userdata["roleid"] == 1) {echo Sprint($data["orderid"]);Sprint($data["shukkaid"]); ;Sprint($data["DC_TC"]);Sprint($data["lotnum"]); }
		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%'  ".$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%' ".$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 ".$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%'  ".$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] =="disp"){
	$result=@mysql_query($strsql,$my_con);
	$rowmax=@mysql_num_rows($result);
	$strsql .=" limit 200";
	$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.target= 'seikyu'
  form.kubun.value= ''
  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()
}


-->
</SCRIPT>
<body>
<?php Honbutitle3("出荷実績閲覧（出荷作業日ベース）",$_SERVER['PHP_SELF']); ?>
<div class="border1">
<form action="1102.php#fragment-5" method="post" name="sww" target="_top">
	<span class="border1box">
	<?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,"出荷作業日期間<br>",-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,1,-1,2,1,-1,1); //温度帯 ?>
<?php InputItem(2,1,-1,2,2,$shozokuid,1); //納品先 ?>
<?php InputItem(3,1,-1,2,1,-1,1); //サプライヤー ?>
<?php showSearchbox($sw,1,-1); //商品検索 ?>
	<span class="border1box">
		出荷確定<br>
		<select name="intshukkaflg" onchange="document.sww.Submit.disabled=true;submitALL2();return false;">
		<?php
		 PrintSelectList($codedata2,$intshukkaflg,0); ?>
		</select>
	</span>
	<span class="border1box">
	業態<br>
	<select name="brand">
	<option SELECTED style="color:#000000; background-color:#f5deb3"  value="-1">全て</option>
	<?php PrintSelectList($codedata105,$brand,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" zadisabled<?php if($row==0) echo ""; ?>>
	</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>
</form>
</div>
<?php  if ($_POST[kubun]=="disp") { ?>
<span class="marker1">該当件数は　<?php echo $rowmax; ?>　件です。最大表示件数200</span>
<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>
<?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);
?>
</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[makercode],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 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);
?>
</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="page"        value="">
<INPUT type="hidden" name="disp"        value="page">
<input type="hidden" name="maker" value="<?php echo $_POST[maker]; //サプライヤー ?>">
<input type="hidden" name="center" value="<?php echo $_POST[center]; //センター ?>">
<input type="hidden" name="gyotai" value="<?php echo $_POST[gyotai]; //業態 ?>">
<input type="hidden" name="tenpo" value="<?php echo $_POST[tenpo]; //納品先 ?>">
<input type="hidden" name="intshukkaflg" value="<?php echo $intshukkaflg; //出荷確定 ?>">
<INPUT type="hidden" name="order"                value="">
<INPUT type="hidden" name="pagenum"                value="">
<INPUT type="hidden" name="searchword"          value="<?php echo $sw; //検索語 ?>">
<INPUT type="hidden" name="startend"              value="<?php echo $term; //開始日～終了日 ?>">
<input type="hidden" name="type" value="<?php echo $zaikotype; //在庫型 ?>"><br>
</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);

?>