<?php  //6410納品書鮮魚
include "func.cgi";
myopen();

//何アイテムで改ページするか
$pagekaigyo = 30;  //30行まで
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();


//対象データ取得
if ($_POST[picktimes]=="") {
	//ピック指定無し
	$strwhere = " WHERE ";
} else {
	$strwhere = " WHERE shu.picktimes ='$_POST[picktimes]' and ";
}
//注文日
if (($_GET[chgday] =="") and ($_POST[chgday] =="")){
	$orderdate = 0;
} elseif ($_GET[chgday] <> ""){
	$orderdate = $_GET[chgday];
} else {
	$orderdate = $_POST[chgday];  //出荷作業日
}

if ($userdata["supplyerid2"]<> ""){
	$strwheresupplyer = " and makercode in (".$userdata["supplyerid2"].") ";
}

if($userdata["centerid"] == "") {
} else {
	$strsqlcenter1 = " AND shu.centerid='".$userdata["centerid"]."' ";
	$strsqlcenter2 = " AND centerid='".$userdata["centerid"]."' ";
}

$strwhere .= "  operatedate = DATE_ADD(CURDATE(),INTERVAL $orderdate DAY)".$strsqlcenter1;
//表示順 商品順 ロケーションの最小
$strorder = " ORDER BY shozokuid,category,shohincd";
$strorder2 = " ORDER BY shozokuid,pagenumber";
$strorder3 = " ORDER BY shu.deliveryid,shu.route,sho.shozokuid,shu.subkubun,sho.address1,pagenumber";

//温度帯データの取得
$codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1);

//所属コード
if($_GET[shotenp] <> "") {
	$strwhereshozoku .= " and shozokuid='".$_GET[shotenp]."' ";
	$printlist = $_GET[shotenp];
} elseif($_POST["nohinsho"] <> "") {
	$strwhereshozoku .= " and shozokuid in (";
	For($ii = 0;$ii < sizeof($_POST["nohinsho"]); $ii++) {
		$strwhereshozoku .= "'".$_POST["nohinsho"][$ii]."'";
		$printlist .= $_POST["nohinsho"][$ii];
		if($ii < (sizeof($_POST["nohinsho"]) -1)) {$printlist .= "-";$strwhereshozoku .= "," ;}
	}
	$strwhereshozoku .= ")";
} else {
	$strwhereshozoku .= " and shozokuid in ('0')";
}
$strwhere  .= $strwhereshozoku;
//本部データ
$honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='cool'",-1,-1);
//印刷済み件数
$printdata = dbselect("count(ordermemoid)","`".$company."ordermemo`","print = 0 AND operatedate = DATE_ADD(CURDATE(),INTERVAL $orderdate DAY)".$strsqlcenter2.$strwhereshozoku,-1,-1);

//出荷データにページ番号挿入 納品先単位の出荷データ数
$strsql ="SELECT shukkaid,shozokuid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shohinmaster` AS sm USING(shohincd) ".$strwhere.$strwheresupplyer." ".$strorder;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql);  //debug
mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$line = 1;$page=1;//処理行数/ページ
while ($data = mysql_fetch_array($result)) {
	if($data[shozokuid]<>$prevshozokuid){
		//所属IDが変わったら改ページ
		$page = 1;
		$line=1;
	} elseif($line > ($pagekaigyo - 1)) {
		//行数が改ページに達していたら
		$page++;
		$line=1;
	} else {
		$line++;
	}
	$prevshozokuid = $data[shozokuid];
	$strsql2 ="UPDATE `".$company."shukka` SET pagenumber=".$page." WHERE shukkaid='".$data[shukkaid]."'";
	Testecho ("LINE ".__LINE__." ".$y." ".$strsql2);  //debug
	$result2=@mysql_query($strsql2,$my_con);
	mysql_sql_log($strsql2,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

}
if ($userdata["kengen"] == 60) {
	$strwhere .= " and deliveryid='".$userdata["companyid"]."'";
}/*
納品先単位 {  //出荷データ、商品情報 $data1
	店舗詳細データdata2  
	取引明細{data3  　出荷データ商品単位
		商品
	}
}
*/

//納品先、ページ単位の出荷データ
$strsql ="SELECT shu.operatedate,shu.shukkadate,shu.shozokuid,shu.pagenumber,`shozokuid`, `shozokuname`,code2, `postcode`, `address1`, `address2`, `address3`, `tel`, `fax`, shu.route, shu.deliveryid,sm.makercode, shu.subkubun, shu.deliverdate FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ,`".$company."shohinmaster` AS sm ".$strwhere.$strwheresupplyer." AND sm.shohincd = shu.shohincd GROUP BY shozokuid,sm.makercode,shu.subkubun,pagenumber ".$strorder3;
Testecho (__LINE__." $errcode ".$strsql);  

//オプション
$codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104 and code > 0","codeid",-1);
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="report.css">
<link rel="stylesheet" type="text/css" href="reportprint.css" media="print" / >
<TITLE>納品書<?php //echo $systemname; ?> <?php //echo "作業日".date("Y/m/d",strtotime ("".$_POST[chgday]." day")); ?> - <?php //echo $_POST[picktimes]."回目"; ?></TITLE>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
-->
</SCRIPT>
<BODY leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="focus()">

<?php 
//start リストを表示するかどうかdebug時のみ
if ($_COOKIE[testmode]=="1") {
	$result=@mysql_query($strsql,$my_con);
	$errcode =mysql_errno();
Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__);
?>
	<table><tr>
<?php 
	//カラム行
	$rows = mysql_num_fields($result);
	//タイトル行の表示
	echo "<td class=\"border3\">#</td>\n";
	for ($i=0;$i<$rows;$i++) {
		echo "<td".mysql_field_name($result, $i)."</td>\n";
	}
?>
	</tr>
<?php 

	$j = 0;
	while ($data = mysql_fetch_array($result)) {
	?>
	<tr> 
		<td><?php echo ($j+1);// ?></td>
	<?php 
		for ($i=0;$i<$rows;$i++) {
			echo "<td>".$data[$i]."</td>\n";
		}
	?>
	</tr>
	<?php 
		$j++;

} //END 
?>
</table>
------------------------------------------<p>
<?php } //debug時のみ ?><div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" >
   <input type="button" onClick="javascript:window.opener = window;window.close();" value="閉じる" class="box1" disabled>
   <input type="button" onClick="location.href='6408.php?nohinsho=end&shotenp=<? echo $printlist; //配送先 ?>&chgday=<? echo $orderdate; //発送日 ?>'" value="納品書済" name="button" <?php if(($printdata[0][0] == 0) or (!(FunctionUseCheck("6409")))) echo "disabled";?>>
   <input type="button" onClick="location.href='6408.php?chgday=<? echo $orderdate; //発送日 ?>'" value="発注一覧へ戻る" name="button" class="box1">
</div><?php 
$page=1;$line=1;
$result=@mysql_query($strsql,$my_con);
$maxrow=@mysql_num_rows($result);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql);  //debug
mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__);
while ($data = mysql_fetch_array($result)) {
	if($page>1) {
		//改ページの信号プリント
		echo "<div class=\"pagenum\">&nbsp;&nbsp;</div>\n";
		echo "<div id=\"buttonarea\">&nbsp;&nbsp;</div>";
		$line=1;
	}
	$totalqty = 0;
	$totalamout= 0;
	$totalamout3 =0;
	$arraydata = explode("　",$data["shozokuname"]);
	$shozokuname1 = $arraydata[0];
	$shozokuname2 = $arraydata[1];

	$datasubkubun =dbselect("subkubun_name".$data[subkubun].",subkubun_code".$data[subkubun],"".$company."shozokumaster","shozokuid='".$data[shozokuid]."'",-1,-1);
	Testecho($strsqldbselect);

?>
<div id="container">
	<div id="header">
		<h6>納　品　書</h6>
	</div>
	<div id="content">
		<div id="content2">
			伝票番号&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15100<?php echo $page; ?><br>
			納品日&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo strftime("%G年%m月%d日 (%a)",strtotime($data["deliverdate"])); ?><br>
<?php
			$honbudata = dbselect("companyname,concat('〒',postcode),address1,address2,address3,tel,fax,memo","company","companyid='".$data["makercode"]."'",-1,-1);
?>
			<h2><?php echo $honbudata[0][0]; ?></h2><div id="font10"><?php echo $honbudata[0][1]; ?></div><div id="font8"><?php echo $honbudata[0][2].$honbudata[0][3].$honbudata[0][4]; ?><br>
			TEL:<?php echo $honbudata[0][5]; ?>&nbsp;&nbsp;<br>FAX:<?php echo $honbudata[0][6]; ?><br><?php echo $honbudata[0][7]; ?></div>
		</div>
		<table><tr><td>&nbsp;<p><p></td></tr></table>
	<img src="./images/inkan.gif" width="100" height="100" class="inkan">
	</div>
	<div id="subnav">
		事務所No.&nbsp;<?php echo ($data["shozokuid"]);  ?><br>
		便区分No.&nbsp;<?php echo ($datasubkubun[0][1]);  ?><br>
		便区分名&nbsp;&nbsp;<?php echo ($datasubkubun[0][0]); //店舗コード ?><br><br>
		<?php echo $shozokuname1; //店舗名称1 ?><br>
		<?php echo $shozokuname2; //店舗名称2 ?>　様<br>
		〒<?php echo $data["postcode"]; // ?><br>
		<?php echo $data["address1"]; // ?><?php echo $data["address2"]; // ?><?php echo $data["address3"]; // ?><br>
		TEL:<?php echo $data["tel"]; // ?><br>
	</div>
</div>
<?php
	//商品明細テーブルヘッダ
?>
<div id="main">
<table>
	<tr>
		<th class="cenrtborder" rowspan="2">No.</th>
		<th class="cenrtborder" rowspan="2">コード</th>
		<th class="cenrtborder" rowspan="2">商品名</th>
		<th class="cenrtborder" rowspan="2">発注数</th>
		<th class="cenrtborder" rowspan="2">出荷数</th>
		<th class="cenrtborder" rowspan="2">重量</th>
		<th class="cenrtborder" colspan="2">商品</th>
		<th class="cenrtborder" colspan="2">オプション</th>
		<th class="cen" rowspan="2">備考</th>
	</tr>
	<tr>
		<th class="cenrtborder">単価</th>
		<th class="cenrtborder">小計</th>
		<th class="cenrtborder">単価</th>
		<th class="cenrtborder">小計</th>
	</tr>
<?php
$shozokuid = $data["shozokuid"];
	//賞味期限、入荷待ち単位の出荷データ（商品グロス+商品マスタ）
	//$strsql2 = "SELECT shohincd,SUM(shukkaqty) AS shukkaqty,price_piece,SUM(price_total) AS price_total,pagenumber,orderid FROM `".$company."shukka` WHERE shukkaflg=2 and (shukkaqty>0 or memo<>"") and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' GROUP BY shohincd ";
	$strsql2 = "SELECT shohincd,orderqty,shukkaqty,price_piece,price_total,price_piece3,price_total3,pagenumber,orderid,memo,memo2,memo3,memoadd,deliverdate,totalgram,shukkaid FROM `".$company."shukka` WHERE shukkaqty <> 0  and shozokuid='".$data["shozokuid"]."' AND pagenumber='".$data["pagenumber"]."' AND subkubun ='".$data["subkubun"]."' and operatedate = DATE_ADD(CURDATE(),INTERVAL $orderdate DAY) ";
	$strsql2 = "SELECT shu.*,sho.shohinmei,sho.shohinmei2, sho.code,ryutu_type, kikaku,nisugata,price_sell,category,sho.shohin_string2,shohin_kubun3 FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) WHERE 1= 1 $strwheresupplyer ORDER BY sho.code,shu.shohincd,shu.shukkaid";
	$totalamount = 0;$totalamount3 = 0;$totalqty = 0;$strhtml = "";
	$result2=@mysql_query($strsql2,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql2);  //debug
mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
	while ($data2 = mysql_fetch_array($result2)) {
		$strhtml .= "<tr>\n";
		$strhtml .= "	<td id=\"cell5\"  class=\"cenrtbmborder12\">$line</td>\n";
		$strhtml .= "	<td id=\"cell9\"  class=\"ltrtbmborder12\">".$data2["shohincd"]."</td>\n";
		if($data2["shohincd"] =='0') {
			$strhtml .= "	<td id=\"cell50\" class=\"ltrtbmborder12\">&nbsp;".$data2["memo3"]." ".$data2["shohinmei2"]."</td>\n";
		} else {
			$strhtml .= "	<td id=\"cell50\" class=\"ltrtbmborder12\">&nbsp;".$data2["shohinmei"]." ".$data2["shohinmei2"]."</td>\n";
		}

		if($data2["orderqty"] =='0') {
			$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">&nbsp;-</td>\n";
		} else {
			$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">&nbsp;".str_replace(".0","",$data2["orderqty"]).$data2["kikaku"]."&nbsp;</td>\n";
		}

	if ($data2["shukkaqty"] % 2) { }
	
		$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">&nbsp;".str_replace(".0","",number_format($data2["shukkaqty"],1)).$data2["kikaku"]."&nbsp;</td>\n";
if($data2[totalgram] > 0 ) {
		$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">".number_format($data2["totalgram"],2)." Kg</td>\n";
		$inttotal = $data2["totalgram"] * $data2["price_piece"] ;
} else {
		$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">-</td>\n";//.$data2["shohin_string2"]
		$inttotal = $data2["shukkaqty"] * $data2["price_piece"] ;
}
		$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">\\".number_format($data2["price_piece"],0)."/".$data2["shohin_string2"]."</td>\n";
		$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder12\">\\".number_format($data2["price_total"],0)."</td>\n";
		if($data2["price_total3"] > 0) {
			$strhtml .= "	<td id=\"cell10\" class=\"rtrtbmborder\">\\".number_format($data2["price_piece3"],0)."</td>\n";
			$strhtml .= "	<td id=\"cell10\" class=\"rtrtbmborder12\">\\".number_format($data2["price_total3"],0)."</td>\n";
		} else {
			$strhtml .= "	<td id=\"cell10\" class=\"rtrtbmborder\">&nbsp;-</td>\n";
			$strhtml .= "	<td id=\"cell10\" class=\"rtrtbmborder\">&nbsp;-</td>\n";
		}
		$totalqty += $data2["shukkaqty"];
		$totalamout += $data2["price_total"];
		$totalamout3 += $data2["price_total3"];
		$strhtml .= "	<td id=\"cell20\" class=\"ltrtbmborder\" >".GetListData($codedata104,$data2["memo2"],0)."<br>".nl2br(htmlspecialchars($data2["memo"].$data2["memoadd"]))."</td>\n";
		$strhtml .= "</tr>\n";
		$line++;
	}
	$page++;
	$strhtml .= "<tr>\n";
	$strhtml .= "	<td colspan=\"6\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">合計</th>\n";
	$strhtml .= "	<td  id=\"cell15\" class=\"rtrtbmborder12\">\\".number_format($totalamout)."</td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">合計</th>\n";
	$strhtml .= "	<td  id=\"cell10\" class=\"rtrtbmborder12\">\\".number_format($totalamout3)."</td>\n";
	$strhtml .= "	<td  id=\"cell20\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "</tr>\n";
	$strhtml .= "<tr>\n";
	$strhtml .= "	<td colspan=\"6\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">全計</th>\n";
	$strhtml .= "	<td  id=\"cell30\" class=\"rtrtbmborder12\" colspan=\"3\">\\".number_format($totalamout + $totalamout3)."</td>\n";
	$strhtml .= "	<td  id=\"cell10\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "</tr>\n";
	echo $strhtml;
	//メモ
	$memodata = dbselect("memosup","`".$company."ordermemo`","shozokuid = '".$data["shozokuid"]."' AND operatedate = DATE_ADD( CURDATE() , INTERVAL ".$orderdate." DAY ) ",-1,-1);
	 ?>
</table>
	<table>
	<tr><td>
		<h2>&nbsp;<?php echo nl2br(htmlspecialchars($memodata[0][0])); ?></h2>
	</td></tr>
	</table>
<?php
?>
</div>
</div>



<?php
}
?>

<?php if($maxrow==0) {?>
対象データがありません。印刷対象をチェックしてください。
<?php } else { 

?>
<div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" />
   <input type="button" onClick="location.href='6408.php?nohinsho=end&shotenp=<? echo $printlist; //配送先 ?>&chgday=<? echo $orderdate; //発送日 ?>'" value="納品書済" name="button" <?php if(($printdata[0][0] == 0) or (!(FunctionUseCheck("6409")))) echo "disabled";?>>
   <input type="button" onClick="location.href='6408.php?chgday=<? echo $orderdate; //発送日 ?>'" value="発注一覧へ戻る" name="button" class="box1">
</div>
<?php } ?>
</body>
</html>
<?php 
myclose();
Testecho($strsql);
?>