<?php  //出荷帳票発行
include "func.cgi";
myopen();

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

//業態IDのセット
if($_POST["gyotai"]=="") {
	$gyotai=$gyotaidata[0][1];
} else {
	$gyotai=$_POST["gyotai"];
}
if($_POST["picktimes"] <> "") {
	$pictimes = $_POST["picktimes"];
} else {
	$pictimes = 1;
}
if($_POST["center"]<>"") {
	$centerid=$_POST["center"];
} else {
	$centerid = $centerdata[0][1];
}
$strsqlcenter = " and centerid='$centerid'";

if($userdata["brand"] <> "") {
	$brand = $userdata["brand"];
	$strsqlbrand = " and brand='$brand'";
} elseif($_POST[brand] <> "") {
	$brand =$_POST["brand"];
	$strsqlbrand = " and brand='$brand'";
} else {
}

//対象範囲
$startday2 = -62;
$endday2 = 10;
//出荷データ
if($company == "body_") {
	$orderdata=dbselect("operatedate,operatedate,count(orderid)","`".$company."ordermain` INNER  JOIN `".$company."ordersheet` USING(ordermainid) ","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY ) and shohincd like '%D%' $strsqlcenter $strsqlbrand GROUP BY operatedate","operatedate desc",-1);
} else {
	$orderdata=dbselect("operatedate,operatedate,count(orderid)","`".$company."ordermain` INNER  JOIN `".$company."ordersheet` USING(ordermainid) ","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and DATE_ADD( CURDATE() , INTERVAL $endday2 DAY ) $strsqlcenter $strsqlbrand GROUP BY operatedate","operatedate desc",-1);
}
Testecho ($strsqldbselect);

if(($_POST[chgday]<>"") and ($centerid==$_POST[oldcenter])){
	$startday = $_POST[chgday];
	$endday = $_POST[chgday];
	$operatedate = $_POST[chgday];
} elseif(sizeof($orderdata)>0) {
	//注文予定がある場合は過去日で最新の日付をデフォルトとする
	$orderdatatemp=dbselect("operatedate,operatedate,count(orderid)","`".$company."ordermain` INNER  JOIN `".$company."ordersheet` USING(ordermainid) ","operatedate between DATE_ADD( CURDATE() , INTERVAL $startday2 DAY ) and CURDATE() $strsqlcenter GROUP BY operatedate","operatedate desc",-1);
	$interval = date_diff($orderdatatemp[0][1],date("Y-m-d"));
	$operatedate = $interval["days"];
	$startday = $interval["days"];
	$endday = $interval["days"];
}

//回数リスト
$batchdata = dbselect("picktimes,picktimes","`".$company."shukka`","operatedate = DATE_ADD( CURDATE() , INTERVAL $operatedate DAY ) GROUP BY picktimes",-1,-1);
Testecho ($strsqldbselect );

//ロケーション印刷するしない
$locationselectdata=array(array("する","1"),array("しない","2"));

//サプライヤー以外はDataSet()のデータを上書き
if ($userdata["kengen"]<>40) {  
	$strsqlmaker = "SELECT distinct(makercode) FROM `".$company."ordersheet` as os,`".$company."ordermain` as om,`".$company."shohinmaster`  as sm WHERE os.ordermainid=om.ordermainid and os.shohincd = sm.shohincd and om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter;
Testecho ($strsqlmaker);
	$makerdata = dbselect("companyname,companyid","`company`",dbselectin($strsqlmaker,"companyid in "),-1,-1);
Testecho ($strsqldbselect);
}

//納品先以外はDataSet()のデータを上書き
if ($userdata["kengen"] <> 50) {  
	$strsqltenpo = "SELECT distinct(shozokuid) FROM `".$company."ordermain` as om WHERE om.operatedate between DATE_ADD( CURDATE( ) , INTERVAL $startday DAY ) and DATE_ADD( CURDATE( ) , INTERVAL $endday DAY )".$strsqlcenter;
Testecho ($strsqltenpo);
	$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",dbselectin($strsqltenpo,"shozokuid in ").$strsqlbrand,-1,-1);
Testecho ($strsqldbselect);
}

//配送業者
if ($userdata["kengen"] == 60) {  //10Tradex,20本部、30センター、40サプライヤー、50納品先、60配送業者、	70工場
	$deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companyid = ('".$userdata["companyid"]."')",-1,-1);
} else {
	$deliverdata = dbselect("companyname,companyid,namedetail,postcode,address1,address2,address3,tel,fax,memo","company","companykind in ('60')",-1,-1);
}
//update cool_shukka  as a,cool_shozokumaster as b set a.brand = b.brand where a.shozokuid = b.shozokuid;update cool_ordermain  as a,cool_shozokumaster as b set a.brand = b.brand where a.shozokuid = b.shozokuid
$branddata = dbselect("code,cname,count(orderid)","`".$company."ordermain` as o INNER  JOIN `".$company."ordersheet` USING(ordermainid) ,`".$company."code` as c","operatedate = DATE_ADD( CURDATE() , INTERVAL ".$operatedate." DAY ) $strsqlcenter and codekind = '105' and o.brand = c.code GROUP BY brand","brand desc",-1);

//ステータス
$statusdata = dbselect("status,picktimes,statusid","`".$company."status`","operatedate = DATE_ADD( CURDATE() , INTERVAL ".$operatedate." DAY )".$strsqlcenter,"status desc",1);
Testecho ($strsqldbselect);
$statusid   = $statusdata[0][2];
$statusdata = (int)$statusdata[0][0];
Testecho("STATUS=". $statusdata);

if ($_POST[dl3] <>""){
	$strdate = Sjis("出荷ラベルデータ.csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	echo Sjis("配送会社,\"ルートNo\",\"納品コード\",\"納品先名\",\"温度帯\"")."\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]." ".GetList($tenpodata2,$data[shozokuid]));
		echo Sprint(GetList($makerdata,$data[makercode]));
		echo Sprint($data["shohincd"]);
		echo Sprint($data["shohincd2"]);
		echo Sprint($data["shohinmei"]);
		echo Sprint($data["orderqty"]);
		echo Sprint($data["operatedate"]);
		switch($data["checkedflg"]) {
			case 1:
				echo Sprint("1.注文中");
				break;
			case 2:
				echo Sprint("2.発注締め済み");
				break;
			case 3:
				echo Sprint("3.受注承認済み");
				break;
			case 4:
				echo Sprint("4.発送締め済み");
				break;
			case 5:
				echo Sprint("5.出荷確定済み");
				break;
			case 6:
				echo Sprint("6.納品締め済み");
				break;
			default:
				echo Sprint("");
		}
		echo Sprint($data["memo"]);
		echo "\n";
		$i++;
	}
	myclose();
	exit;
}


?><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 submitFormData(actionto,targetto) {
	form = document.formjoken
	/*if(form.act.checked) {
		form.action=  form.act.checked
	} else {
		form.action=  form.act.checked
	}*/
	form.action= actionto
	form.target= targetto
	formjoken.submit()
}
function submitALL2() {
  form = document.formjoken
  form.action= '5600.php#fragment-8'
  form.target= '_top'
  form.submit()
}

-->
</SCRIPT>
<body>
<?php Honbutitle3("出荷帳票発行",$_SERVER['PHP_SELF']); ?>
<p>
<form action="5600.php#fragment-8" method="post" name="formjoken" target="_top">

<DIV class="floatlt350">出力条件
<table border=0 class="border1">
<tr>
<tr>
	<td>センター</td>
	<td><select name="center" onChange="submitALL2();return false;">
	<?php PrintSelectList($centerdata,$centerid,0); ?>
	</select>
	<input type="hidden" name="oldcenter" value="<?php echo $centerid; ?>">
	</td>
</tr>
	<td>作業日</td>
	<td>
	<select name="chgday" onChange="submitALL2();return false;">
	<?php
	if(sizeof($orderdata)==0) {
		echo "<option>出荷データがありません</option>";
	} else {
		PrintSelectListB($orderdata,$operatedate,0); 
	} ?>
	</select>
	</td>
<tr>
	<td>業態区分Ａ</td>
	<td><select name="gyotai">
	<?php PrintSelectList($gyotaidata,$gyotai,0); ?><?php //PrintSelectList($batchdata,"",0); ?>
	</select>
	</td>
</tr>
<tr>
<!--	<td>業態区分Ｂ</td>
	<td><select name="brand">
	<option value="">全て</option>
	<?php PrintSelectListB($branddata,$brand,0); ?><?php //PrintSelectList($batchdata,"",0); ?>
	</select>
	</td>
</tr>-->
<tr>
	<td>バッチ</td>
	<td><select name="picktimes">
	<?php PrintSelectList($batchdata,$pictimes,0); ?>
	</select>
	</td>
</tr>
<tr>
	<td>納品先</td>
	<td><select name="tenpo">
<?php
	if(sizeof($tenpodata)==0) {
		echo "<option>データがありません</option>";
	} elseif(sizeof($tenpodata)==1) {
		//PrintSelectList2($tenpodata,$_POST[tenpo],0);
		PrintSelectList2($tenpodata,"",0);
	} else {
		echo "<option value=\"\">全て</option>";
		//PrintSelectList2($tenpodata,$_POST[tenpo],0);
		PrintSelectList2($tenpodata,"",0);
	}
?>
	</select></td>
</tr>
<tr>
	<td><nobr>サプライヤー</nobr></td>
	<td><select name="maker">
<?php
	if(sizeof($makerdata)==0) {
		echo "<option>データがありません</option>";
	} else	if(sizeof($makerdata)==1) {
		//PrintSelectList2($makerdata,$_POST[maker],0);
		PrintSelectList2($makerdata,"",0);
	} else {
		echo "<option value=\"\">全て</option>";
		//PrintSelectList2($makerdata,$_POST[maker],0);
		PrintSelectList2($makerdata,"",0);
	}
?>
	</select>
	</td>
</tr>
<tr>
	<td>温度帯</td>
	<td>
<?php
for ($i = 0; $i < sizeof($codedata); $i++) {
	echo "<lavel><input type=\"checkbox\" value=\"".$codedata[$i][1]."\" name=\"code[]\" checked>".$codedata[$i][0]."</label>";
}
?>
	</td>
</tr>
<tr>
	<td>在庫区分</td>
	<td>
	<lavel><input type="checkbox" value="1" name="ryutu_type[]" checked>在庫型</label>
	<lavel><input type="checkbox" value="2" name="ryutu_type[]">通過型</label>
	</td>
</tr>
<tr>
	<td>配送</td>
	<td><select name="deliver">
<?php
	if(sizeof($deliverdata)==1) {
		PrintSelectList2($deliverdata,$_POST[deliver],0);
	} else {
		echo "<option value=\"\">全て</option>";
		PrintSelectList2($deliverdata,$_POST[deliver],0);
	}
?>
	</select>
	</td>
</tr>
<tr>
	<td>配送一覧</td>
	<td><lavel><input type="checkbox" value="1" name="route"
<?php
	if($_POST["route"]==1) {echo " checked "; }
?> >ルート別発行</label>
	</td>
</tr>
</table>
</DIV>

<DIV class="floatlt350">帳票・データ出力
<table border=0 class="border1">
<tr>
	<td><input type="button" onClick="submitFormData('5310.php','gross'); return true" class="box1" value="グロスピッキング" <?php if((!(FunctionUseCheck("5310"))) or ($statusdata<3)) echo "disabled";?>>
<input type="button" onClick="submitFormData('6412.php','gross'); return true" class="box1" value="グロスピッキングB" <?php if((!(FunctionUseCheck("6412"))) or ($statusdata<3)) echo "disabled";?>></td>
</tr>
<tr>
	<td><input type="button" onClick="submitFormData('5410.php','tane'); return true" class="box1" value="種まきリスト" <?php if((!(FunctionUseCheck("5410"))) or ($statusdata<4)) echo "disabled";?>>
<input type="button" onClick="submitFormData('6413.php','tane'); return true" class="box1" value="種まきリストB" <?php if((!(FunctionUseCheck("6413"))) or ($statusdata<4)) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5440.php','tane2'); return true" class="box1" value="不定貫記入票" <?php if((!(FunctionUseCheck("5440"))) or ($statusdata<4)) echo "disabled";?>></td>
</tr>
<tr>
	<td><input type="button" onClick="submitFormData('5520.php','saki'); return true" class="box1" value="納品先別" <?php if((!(FunctionUseCheck("5520"))) or ($statusdata<4)) echo "disabled";?>>
<input type="button" onClick="submitFormData('6414.php','tane'); return true" class="box1" value="納品先別B" <?php if((!(FunctionUseCheck("6414"))) or ($statusdata<4)) echo "disabled";?>></td>
</tr>
<tr>
	<td>
	<input type="button" onClick="submitFormData('5510.php','nouhin'); return true" class="box1" value="納品書A" <?php if((!(FunctionUseCheck("5510"))) or ($statusdata<5)) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5511.php','nouhin'); return true" class="box1" value="納品・受領書" <?php if((!(FunctionUseCheck("5511"))) or ($statusdata<5)) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5521.php','nouhin'); return true" class="box1" value="納品書" <?php if((!(FunctionUseCheck("5521"))) or ($statusdata<5)) echo "disabled";?>>
	</td>
</tr>
<tr>
	<td><input type="button" onClick="submitFormData('5560.php','delivery'); return true" class="box1" value="配送依頼書(確定)" <?php if((!(FunctionUseCheck("5560"))) or ($statusdata<3)) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5561.php','delivery'); return true" class="box1" value="配送依頼書(受注ベース)" <?php if(!(FunctionUseCheck("5561")))  echo "disabled";?>></td>
</tr>
<tr>
	<td><input type="button" onClick="submitFormData('5570.php','delivery'); return true" class="box1" value="個数検品表" <?php if((!(FunctionUseCheck("5570"))) or ($statusdata<3)) echo "disabled";?>>
	<input type="button" onClick="submitFormData('6322.php','delivery'); return true" class="box1" value="出荷データ出力" <?php if(!(FunctionUseCheck("6322")))  echo "disabled";?>>
</td>
</tr>
<tr>
	<td>
	<input type="button" onClick="submitFormData('5572.php','delivery'); return true" class="box1" value="佐川送り状e飛伝" <?php if(1==1) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5573.php','delivery'); return true" class="box1" value="佐川送り状e飛伝II" <?php if(!(FunctionUseCheck("5573")))  echo "disabled";?>></td>
</tr>
<tr>
	<td>
	<input type="button" onClick="submitFormData('5574.php','delivery'); return true" class="box1" value="ヤマト送り状B2" <?php if(1==1) echo "disabled";?>>
	<input type="button" onClick="submitFormData('5571.php','delivery'); return true" class="box1" value="佐川用データ" <?php if(!(FunctionUseCheck("5571")))  echo "disabled";?>>
	</td>
</tr>
</tr>
</table>
</DIV>
<INPUT type="hidden" name="id"              value="<?php echo $statusid; ?>">
</FORM>

<br>
<DIV class="floatlt100">
<FORM METHOD="POST" name="back" action="5000.php">
<input type="hidden" name="chgday" value="<?php echo $operatedate; //作業日 ?>">
</FORM>

<FORM METHOD="POST" name="FormGetSubmit" action=".php">
<INPUT type="hidden" name="order"                value="">
<INPUT type="hidden" name="pagenum"                value="">
<INPUT type="hidden" name="searchword"          value="">
<INPUT type="hidden" name="chgday"              value="">
<INPUT type="hidden" name="tenpono"              value="">
<INPUT type="hidden" name="id"              value="<?php echo $statusid; ?>">
</FORM
</DIV>
</DIV>
<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
myclose();

?>