<?php  //6512　納品書　アサマフーズ　鮮魚6410改良
include "func.cgi";
myopen();

//何アイテムで改ページするか
$pagekaigyo = 30;  //30行まで
//再チェック
SecurityCheck();
PostData();
//FunctionUseCheck2();


//対象データ取得
if ($_POST[picktimes]=="") {
	//ピック指定無し
	$strwhere = " WHERE ";
} else {
	$strwhere = " WHERE ";
}
//注文日
if (($_GET[chgday] =="") and ($_POST[chgday] =="")){
	$orderdate = 0;
} elseif ($_GET[chgday] <> ""){
	$orderdate = $_GET[chgday];
} else {
	$orderdate = $_POST[chgday];  //出荷作業日
}

//納品先の絞込み
//ブランド
if($userdata[brand] <> "") {
//	$whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")";
//	$strwhereshozoku = dbselectin($whereselectin," and shozokuid in ");
	//	$tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlshozoku,"shozokuid",-1);
}
	$whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in ('30','31')"; //固定
	$strwhereshozoku = dbselectin($whereselectin," and shozokuid in ");

//所属コード
if($_POST[tenpo]<>"") {
	$strwhereshozoku .= " and shozokuid='".$_POST[tenpo]."' ";
}
//メーカー
if($_POST[maker]<>"") {
	$strwheresupplyer .= " and makercode='".$_POST[maker]."' ";
}
if ($userdata["supplyerid2"]<> ""){
	$strwheresupplyer .= " and makercode in (".$userdata["supplyerid2"].") ";
}

$strwhere .= "  operatedate = DATE_ADD(CURDATE(),INTERVAL $orderdate DAY) AND shu.centerid='c101'";
//表示順 商品順 ロケーションの最小
$strorder = " ORDER BY shozokuid,category,shohincd";
$strorder2 = " ORDER BY shozokuid,pagenumber";
$strorder3 = " ORDER BY sho.deliveryid,sho.route,sho.shozokuid,sho.address1,pagenumber";

//温度帯データの取得
$codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1);

//本部データ
$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) AND centerid='c101'".$strwhereshozoku,-1,-1);

//出荷データにページ番号挿入 納品先単位の出荷データ数
$strsql ="SELECT shukkaid,shozokuid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shohinmaster` AS sm USING(shohincd) ".$strwhere.$strwhereshozoku.$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`, sho.route, shu.deliveryid FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ".$strwhere." GROUP BY shozokuid,pagenumber ".$strorder3;
Testecho ($y." $errcode ".$strsql);  
$strsql ="SELECT shu.operatedate,shu.shukkadate,shu.shozokuid,shu.pagenumber,`shozokuid`, `shozokuname`,code2, `postcode`, `address1`, `address2`, `address3`, `tel`, `fax`, sho.route, shu.deliveryid,sm.makercode FROM `".$company."shukka` AS shu INNER JOIN `".$company."shozokumaster` AS sho USING(shozokuid) ,`".$company."shohinmaster` AS sm ".$strwhere.$strwhereshozoku.$strwheresupplyer." AND sm.shohincd = shu.shohincd GROUP BY shozokuid,makercode,pagenumber ".$strorder3;
Testecho ($y." $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" >一幸　納品書
</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;
?>
<div id="container">
	<div id="header">
		<h6>納　品　書</h6>
	</div>
	<div id="content">
		<?php echo strftime("%G年%m月%d日 (%a)",strtotime($data["operatedate"])); ?><br>
		<div id="content2"><br>
<?php
		$honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='".$data["makercode"]."'",-1,-1);
?>
		<h2>アサマフーズ株式会社</h2><div id="font10">（納品業者）大田市場<?php echo $honbudata[0][0]; ?><br>TEL:<?php echo $honbudata[0][5]; ?><br>FAX:<?php echo $honbudata[0][6]; ?><br><?php echo $honbudata[0][7]; ?></div>
		</div>
		<table><tr><td>&nbsp;<p><p></td></tr></table>
	</div>
	<div id="subnav">
		<h2>ルート<?php echo $data["route"]; // ?></h2>
		<h4><?php echo ($data["shozokuid"]); //店舗コード ?><br>
		<?php echo ($data["shozokuname"]); //店舗名称 ?>　御中</h4>
		<h2>〒<?php echo $data["postcode"]; // ?></h2>
		<h2><?php echo $data["address1"]; // ?><?php echo $data["address2"]; // ?></h2><h2><?php echo $data["address3"]; // ?></h2>
		<h7>TEL:<?php echo $data["tel"]; // ?></h7><br>
		<h7>FAX:<?php echo $data["fax"]; // ?></h7>
	</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" 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 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 makercode='".$data["makercode"]."'".$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";
		if($data2["shohincd"] =='0') {
			$strhtml .= "	<td id=\"cell55\" class=\"ltrtbmborder12\">&nbsp;".$data2["memo3"]." ".$data2["shohinmei2"]."</td>\n";
		} else {
		//	$strhtml .= "	<td id=\"cell55\" class=\"ltrtbmborder12\">&nbsp;".$data2["shohinmei"]." ".$data2["shohinmei2"]."</td>\n";
			$strhtml .= "	<td id=\"cell55\" class=\"ltrtbmborder12\">&nbsp;".$data2["shohinmei"]." </td>\n";
		}

		if($data2["orderqty"] =='0') {
			$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">&nbsp;-</td>\n";
		} else {
			$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">&nbsp;".str_replace(".0","",$data2["orderqty"])." ".$data2["kikaku"]."</td>\n";
		}

	if ($data2["shukkaqty"] % 2) { }
	
		$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">&nbsp;".str_replace(".0","",number_format($data2["shukkaqty"],1))." ".$data2["kikaku"]."</td>\n";
if($data2[totalgram] > 0 ) {
		$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">".number_format($data2["totalgram"],2)." Kg</td>\n";
		$inttotal = $data2["totalgram"] * $data2["price_piece"] ;
} else {
		$strhtml .= "	<td id=\"cell15\" class=\"rtrtbmborder\">-</td>\n";//.$data2["shohin_string2"]
		$inttotal = $data2["shukkaqty"] * $data2["price_piece"] ;
}
		$strhtml .= "	<td id=\"cell18\" class=\"rtrtbmborder\">\\".number_format($data2["price_piece"],0)."/".$data2["shohin_string2"]."</td>\n";
		$strhtml .= "	<td id=\"cell18\" class=\"rtrtbmborder12\">\\".number_format($data2["price_total"],0)."</td>\n";
		if($data2["price_total3"] > 0) {
			$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">\\".number_format($data2["price_piece3"],0)."</td>\n";
			$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder12\">\\".number_format($data2["price_total3"],0)."</td>\n";
		} else {
			$strhtml .= "	<td id=\"cell12\" class=\"rtrtbmborder\">&nbsp;-</td>\n";
			$strhtml .= "	<td id=\"cell12\" 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=\"5\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">合計</th>\n";
	$strhtml .= "	<td  id=\"cell18\" class=\"rtrtbmborder12\">\\".str_replace(".0","",number_format($totalamout))."</td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">合計</th>\n";
	$strhtml .= "	<td  id=\"cell12\" class=\"rtrtbmborder12\">\\".str_replace(".0","",number_format($totalamout3))."</td>\n";
	$strhtml .= "	<td  id=\"cell20\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "</tr>\n";
	$strhtml .= "<tr>\n";
	$strhtml .= "	<td colspan=\"5\" class=\"rtrtbmborder12\"></td>\n";
	$strhtml .= "	<th class=\"cenrtborder\">全計</th>\n";
	$strhtml .= "	<td  id=\"cell30\" class=\"rtrtbmborder12\" colspan=\"3\">\\".str_replace(".0","",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>
</div>
</div>


<?php
}
?>

<?php if($maxrow==0) {?>
対象データがありません。印刷対象をチェックしてください。（アサマフーズ帳票）
<?php } else { 

?>
<div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" />
   <input type="button" onClick="javascript:window.opener = window;window.close();" value="閉じる" class="box1" >
</div>
<?php } ?>
</body>
</html>
<?php 
myclose();
Testecho($strsql);
?>