<?php  //欠品調整入力
include "func.cgi";
myopen();
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//センター名の取得
$centerdatalist = dbselect("companyname","company","companykind=30",-1,-1);
$centername = $centerdatalist[0][0];

//１ページ数
if($_POST[pageset]=="") {
	$pageset = 120;
} else {
	$pageset = $_POST[pageset];
}


$errcount = 0;  //エラーカウント
$okcount = 0;  //エラーカウント
$errmsg = "";  //エラーメッセージ

if ($_POST[chgday] == "") {
	$chgday = 0;
} else {
	$chgday = (int)$_POST[chgday];
}

$excutedate = "DATE_ADD(CURDATE(),INTERVAL $chgday DAY)";
$excutedate2 = "DATE_ADD(CURDATE(),INTERVAL ".($chgday + 1)." DAY)";


//センターコード
//センター権限の時はそのセンターを使用する。
//センター権限以外の時は指定された使用センターを使用する。
if ($userdata["kengen"] == 30) {  //10Tradex,20本部、30センター、40サプライヤー、50納品先
	$strsqlcenter = " and centerid = '".$userdata["companyid"]."'";
} elseif ($_POST[center] <> ""){
	$centerid = $_POST[center];
	$strsqlcenter = " and centerid = '$centerid'";
} elseif ($userdata["centerid"] <> ""){
	$centerid = str_replace("'","",$userdata["centerid"]);
	$strsqlcenter = " and centerid = '$centerid'";
} else {
}

//statusid
if($_POST[id] <> "") {
	$statusid = $_POST[id];
} else {
	$statusdata = dbselect("statusid","`".$company."status`","operatedate = $excutedate AND status > 2 ".$strsqlcenter,-1,-1);
	$statusid = $statusdata[0][0];
	Testecho("statusid=".$statusid);
}


//更新処理
if (($_POST[kakutei] <> "") or ($_POST[update] <> "")){
	For ($y=0;$y<($_POST[max]);$y++) {
		if ($_POST{"id".$y} == "") 	break;
		#$a = "amount".$y;

		//更新可能　欠品TをUPDATE
		$memo = Eucjp($_POST{"memo".$y});
		$memo = mysql_escape_string(mb_strcut($memo,0,70));
		$strsql = "
		UPDATE `".$company."keppin` SET 
			shukkaqty=".Numchecker2($_POST{"shukka".$y}).",
			directqty=".Numchecker2($_POST{"choku".$y}).",
			keppinqty=".(Numchecker2($_POST{"orderqty".$y}) - Numchecker2($_POST{"shukka".$y}) - Numchecker2($_POST{"choku".$y}) - Numchecker2($_POST{"kari".$y})).",
			etcqty1=".Numchecker2($_POST{"kari".$y}).",
			memo='$memo', 
			updater='".$userdata["tid"]."'
		 where keppinid = '".$_POST{"id".$y}."' limit 1";
		$result=mysql_query($strsql,$my_con);
		$errcode =mysql_errno();if ($errcode==0) 
		Testecho ("LINE ".__LINE__." ".$y." ".$strsql." ROWS=".mysql_affected_rows()); 
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		if (mysql_affected_rows()==1) {$okcount++; }

		//サプライヤ直送にデータ書き込み
		$strsql ="DELETE FROM `".$company."directsupply` WHERE keppinid ='".$_POST{"id".$y}."' limit 1";
		Testecho ("LINE ".__LINE__." ".$y." ".$strsql." ROWS=".mysql_affected_rows()); 
		$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		//直送の場合は納品明細にデータ書き込み
		if ((int)$_POST{"choku".$y}>0) {
			$strsql ="INSERT INTO `".$company."directsupply` ( `orderid`, `shozokuid`, `shohincd`, `centerid`, `supplyerid`, `gyotaiid`, `shukkaqty`, `operatedate`, `deliverdate`,`shukkadate`, `keppinid`,  `creater`, `createdate`)  SELECT  `orderid`, `shozokuid`, `shohincd`, `centerid`, `makercode` , `ke`.`gyotaiid`, `directqty`, `operatedate`, `deliverdate`, ".$excutedate2.",`keppinid`,  '".$userdata["tid"]."', now() FROM `".$company."keppin` AS ke INNER JOIN `".$company."shohinmaster` USING(shohincd) WHERE keppinid ='".$_POST{"id".$y}."'";
		Testecho ("LINE ".__LINE__." ".$y." ".$strsql." ROWS=".mysql_affected_rows()); 
			$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
			//受注明細更新
			$strsql ="UPDATE `".$company."ordersheet` SET karihikiate2 ='".Numchecker2($_POST{"shukka".$y})."', memo2='別送数量(".$_POST{"choku".$y}.")',kariflg = 1 WHERE orderid ='".$_POST{"orderid".$y}."' limit 1";
		Testecho ("LINE ".__LINE__." ".$y." ".$strsql." ROWS=".mysql_affected_rows()); 
			$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		} else {
			//受注明細更新
			$strsql ="UPDATE `".$company."ordersheet` SET karihikiate2 ='".Numchecker2($_POST{"shukka".$y})."',memo2='',kariflg = 1 WHERE orderid ='".$_POST{"orderid".$y}."' limit 1";
		Testecho ("LINE ".__LINE__." ".$y." ".$strsql." ROWS=".mysql_affected_rows()); 
			$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}

		//仮入荷分は出荷データを作成する
		if((int)$_POST{"kari".$y} > 0) {
			$int_kari_shukka_qty += (int)$_POST{"kari".$y};
			//仮出荷データ
			$InputValues[0]["centerid"]    = $centerid ;
			$InputValues[0]["shohincd"]    = $_POST[shohin];
			$InputValues[0]["shukkaqty"]   = (int)$_POST{"kari".$y};
			$InputValues[0]["operatedate"] = date("Y/m/d",strtotime ("".$chgday." day"));//$excutedate;
			$InputValues[0]["shukkadate"]  = date("Y/m/d",strtotime ("".$chgday." day"));//$excutedate;
			$InputValues[0]["shozokuid"]   = $_POST{"shozoku".$y};//納品先ID
			$InputValues[0]["orderid"]     = (int)$_POST{"orderid".$y};//注文ID
			$InputValues[0]["transid"]     = "";
			$InputValues[0]["gyotaiid"]    = $userdata["gyotaiid"];//業態ID
			$InputValues[0]["lotnum"]      = 0;//在庫処理無し
			$InputValues[0]["memo"]        = "仮入荷処理";
			$InputValues[$y]["comeinid"]   = 0; //仮入荷予定ID";
			inputShukka($InputValues,"",1,"");//出荷データ作成
			$orderid[] = (int)$_POST{"orderid".$y};//注文ID
		}
	}

	//仮入荷出荷分は、入荷予定と出荷データを作成
	if ($int_kari_shukka_qty > 0) {
		//入荷データ
		$InputValues[0]["centerid"]   = $centerid ;
		$InputValues[0]["shohincd"]   = $_POST[shohin];
		$InputValues[0]["comeinqty"]  = $int_kari_shukka_qty;
		$InputValues[0]["comeindate"] = date("Y/m/d",strtotime ("".$chgday." day"));//$excutedate;
		$InputValues[0]["kubun"]      = 3;//仮入荷
		$InputValues[0]["memo"]       = "仮入荷分";
		$id = inputComeinData($InputValues,"",1,"");//入荷データ作成 入荷予定IDの作成

		//出荷データに仮入荷IDを反映する
		For($iii = 0;$iii <sizeof($orderid);$iii++) {
			$strsql = "UPDATE `".$company."shukka` SET comeinid = '".$id[0]."' WHERE orderid = '".$orderid[$iii]."' and comeinid = 0 and `createdate` >= current_timestamp + interval -1 minute  limit 1;";
			$result=mysql_query($strsql,$my_con);
			$errcode =@mysql_errno();
			Testecho ($strsql." ROWS=".mysql_affected_rows());
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}
	}
}
if ($_POST[kakutei] <> ""){
	//欠品数にマイナスがないかをチェックする
	$datacheck = dbselect("sum(orderqty)","`".$company."keppin`","shohincd='".$_POST[shohin]."' AND operatedate=$excutedate AND keppinflg=1 AND keppinqty<0 GROUP BY shohincd",-1,-1);
Testecho("受注 ".$strsqldbselect);
	$datacheck2 = dbselect("sum(shukkaqty)","`".$company."keppin`","shohincd='".$_POST[shohin]."' AND operatedate=$excutedate AND keppinflg=1 GROUP BY shohincd",-1,-1);
Testecho("出荷 ".$strsqldbselect);
Testecho("TOTALZAIKO ".(int)$_POST["totalzaiko"]." 出荷確定数 ".(int)$datacheck2[0][0]." 受注確定数  ".(int)$datacheck[0][0]);
	if ((int)$datacheck[0][0]>0) {
		$errcount++;
		$errmsg = "数が合わないデータがあるため、確定できません。";
	} elseif ((int)$datacheck2[0][0] > (int)$_POST["totalzaiko"]) {
		//出荷確定数が実在庫よりも多い場合
		$errcount++;
		$errmsg = "在庫数より出荷数が多いため、確定できません。入荷の実績登録をしてください。 ";
Testecho ($datacheck2[0][0] ."-".$_POST["totalzaiko"]);
	} else {
		//確定処理

		For ($y=0;$y<($_POST[max]);$y++) {
			$strsql = "UPDATE `".$company."keppin` SET keppinflg=2 ,updater='".$userdata["tid"]."' where keppinid = '".$_POST{"id".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

			$memo = Eucjp($_POST{"memo".$y});
			if ((int)$_POST{"choku".$y}>0) {
				$memo = "別送数量(".$_POST{"choku".$y}.") ".$memo;
			}
			$memo = mysql_escape_string(mb_strcut($memo,0,60));
			//出荷実績データ書き換え
			$strsql = "UPDATE `".$company."shukka` SET shukkaqty=".Numchecker2($_POST{"shukka".$y}).",price_total= price_piece * ".Numchecker2($_POST{"shukka".$y}).", memo2 = concat(memo,'".$memo."') WHERE orderid='".$_POST{"orderid".$y}."'";
			$result=mysql_query($strsql,$my_con);
			Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}

		//出荷引当
		include("5201.php");

		//欠品数
		$nonfixcount=0;$fixcount=0;
		$shohindata=dbselect("keppinflg","`".$company."shohinmaster` as sm,`".$company."keppin` as ke", "ke.shohincd=sm.shohincd AND operatedate = $excutedate GROUP BY sm.shohincd","sm.shohincd",-1);
		Testecho($strsqldbselect);
		for ($pi = 0; $pi < sizeof($shohindata); $pi++) {
			if($shohindata[$pi][0] == 1) {
				$nonfixcount++;
			} else {
				$fixcount++;
			}
		}

		$strsql = "UPDATE `".$company."status` SET keppinqty = $nonfixcount, keppinfixqty= $fixcount where operatedate=$excutedate AND centerid='".$centerid."'";// AND gyotaiid='".$userdata["gyotaiid"]."'
		$result=mysql_query($strsql,$my_con);
		Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		$strsql = "UPDATE `".$company."status` SET status=4 where keppinqty=keppinfixqty AND operatedate=$excutedate  AND status=3 AND centerid='".$centerid."'";//AND gyotaiid='".$userdata["gyotaiid"]."' 
		$result=mysql_query($strsql,$my_con);
		Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
	}
} elseif ($_POST[cancel] <> ""){
	//FLGを更新可能とする
	For ($y=0;$y<($_POST[max]);$y++) {
		$strsql = "UPDATE `".$company."keppin` SET keppinflg=1 ,updater='".$userdata["tid"]."' where keppinid = '".$_POST{"id".$y}."' limit 1";
		$result=mysql_query($strsql,$my_con);
		Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
	}

	//欠品数
	$nonfixcount=0;$fixcount=0;
	$shohindata=dbselect("keppinflg","`".$company."shohinmaster` as sm,`".$company."keppin` as ke", "ke.shohincd=sm.shohincd AND operatedate = $excutedate GROUP BY sm.shohincd","sm.shohincd",-1);
	Testecho($strsqldbselect);
	for ($pi = 0; $pi < sizeof($shohindata); $pi++) {
		if($shohindata[$pi][0] == 1) {
			$nonfixcount++;
		} else {
			$fixcount++;
		}
	}
	$strsql = "UPDATE `".$company."status` SET keppinfixqty=$fixcount,status=3 where operatedate=$excutedate AND centerid='".$centerid."'";//AND gyotaiid='".$userdata["gyotaiid"]."'
	$result=mysql_query($strsql,$my_con);
	Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
}

//出荷データに納品先IDをつける
$strsql = "UPDATE `".$company."shukka` as shu, `".$company."shozokumaster` as sho SET `shu`.`deliveryid` = `sho`.`deliveryid`, `shu`.`route` = `sho`.`route` WHERE `shu`.`shozokuid` = `sho`.`shozokuid` and (`shu`.`deliveryid` is null or `shu`.`route` is null)";
$result=mysql_query($strsql,$my_con);
Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//出荷データにルート変更
$strsql = "UPDATE `".$company."deliverchange` AS dc, `".$company."shukka` AS s SET s.deliveryid = dc.deliveryid,s.memo4 = dc.memo1,s.memo2 = dc.memo2 ,s.route = dc.memo3 WHERE dc.shozokuid <>'' and dc.shozokuid = s.shozokuid AND s.operatedate = dc.operatedate AND s.operatedate = ".$excutedate;
$result=mysql_query($strsql,$my_con);
$errcode =@mysql_errno();
Testecho ($y.$strsql."<br>");  #debug
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);


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

//商品データ
$shohindata=dbselect("concat(sm.shohincd,' ',sm.shohinmei) ,sm.shohincd,sm.shohinmei,kikaku,makercode,keppinflg","`".$company."shohinmaster` as sm,`".$company."keppin` as ke", "ke.shohincd=sm.shohincd AND operatedate = $excutedate AND ke.centerid ='".$centerid."' GROUP BY sm.shohincd","sm.shohincd",-1);
Testecho($strsqldbselect);

//商品指定
if (($_POST[kakutei] <> "") and ($errcount == 0))  {
	$strsqlwhere = " AND ke.shohincd='".$shohindata[0][1]."'";
	$shohin = $shohindata[0][1];
} elseif (($_POST[kakutei] <> "") and ($errcount > 0))  {
	$strsqlwhere = " AND ke.shohincd='".$_POST[shohin]."'";
	$shohin = $_POST[shohin];
} elseif ($_POST[shohin] <> "")  {
	$strsqlwhere = " AND ke.shohincd='".$_POST[shohin]."'";
	$shohin = $_POST[shohin];
} else {
	$strsqlwhere = " AND ke.shohincd='".$shohindata[0][1]."'";
	$shohin = $shohindata[0][1];
}


//欠品データ
$strsqlkeppin="SELECT ke.*,shoz.shozokuname,sm.shohinmei,company.companyname,sm.nisugata,sm.kikaku,sm.irisuu,sm.aisuu  FROM `".$company."keppin` as ke,`".$company."shohinmaster` as sm,`".$company."shozokumaster` as shoz,company  WHERE ke.shohincd=sm.shohincd AND ke.shozokuid = shoz.shozokuid AND sm.makercode = company.companyid AND ke.operatedate = $excutedate and ke.centerid = '$centerid' $strsqlwhere ORDER BY shoz.hikiateorder,ke.shozokuid";

//受注データ
$juchu = dbselect("sum(orderqty)","`".$company."ordersheet` AS sheet,`".$company."ordermain` AS main","sheet.ordermainid=main.ordermainid AND operatedate = $excutedate AND shohincd='".$shohin."' $strsqlcenter GROUP BY shohincd",-1,-1);
Testecho($strsqldbselect);

//在庫データ
$zaiko = dbselect("sum(stockqty),sum(arrangeqty)","`".$company."stockdata`","validflg=1 AND shohincd='".$shohin."' $strsqlcenter GROUP BY shohincd",-1,-1);

//現在のステータスデータ
$status = dbselect("status","`".$company."status`","operatedate=$excutedate and centerid='".$centerid."'",-1,-1);//AND gyotaiid='".$userdata["gyotaiid"]."'
$statusflg = $status[0][0];
//全数
$result=@mysql_query($strsqlkeppin,$my_con);
$maxrow=@mysql_num_rows($result);
mysql_sql_log2($strsqlkeppin,$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho(__LINE__.$strsqlkeppin);

//１ページ分
$strsqlkeppin = $strsqlkeppin." LIMIT ".($pageset*($page  - 1)).",$pageset";
$result=@mysql_query($strsqlkeppin,$my_con);
$row=@mysql_num_rows($result);
mysql_sql_log2($strsqlkeppin,$_SERVER['SCRIPT_NAME'].":".__LINE__);
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<?php title(); ?>
<link rel="stylesheet" type="text/css" href="reportprintgeneral.css" media="print" / >
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  form.order.value= order
  form.searchword.value="<?php echo $sw; //検索語 ?>"
  form.chgday.value="<?php echo $_POST[chgday]; //納品日 ?>"
  form.shozoku.value="<?php echo $shozokuid; //納品先 ?>"
  FormGetSubmit.submit()
}
-->
</SCRIPT>
<body>
<?php Honbutitle3("欠品調整入力",$_SERVER['PHP_SELF']); ?>
<form action="5200.php#fragment-5" method="post" name="selecshohin" target="_top">
<DIV class="floatlt">
作業日<br>
<select name="chgday" onChange="window.document.selecshohin.submit();">
<?php 
//PrintSelectDay2(開始日,終了日,本ファイル名,デフォルト日数,表示文字列,表示可能曜日);
PrintSelectDay2(-20,10,-2,$chgday,"作業日<br>","1111111");
?>
</DIV>
<DIV class="floatlt">
	センター<br>
	<select name="center" onChange="window.document.selecshohin.submit();">
	<? PrintSelectList($centerdata,$centerid,0); ?>
	</select>
</DIV>
<DIV class="floatlt">
<?php if($maxrow==0) {?>
<br>
欠品情報は有りません。
<?php } else { ?>
	<INPUT type="hidden" name="id"        value="<?php echo $statusid; //ステータスＩＤ ?>">
	<input type="hidden" name="picktimes" value="<?php echo $_POST[picktimes]; //ピック回数 ?>">
	<input type="hidden" name="totalzaiko" value="<?php echo (int)$zaiko[0][0]; //現在の在庫数 ?>">
	商品<br>
	<select name="shohin" onChange="window.document.selecshohin.submit();">
	<?php PrintSelectList5200($shohindata,$_POST[shohin],5); ?>
	</select>
<?php //PrintSelectPageset($pageset); //表示件数 ?>
</form>
<?php } ?>
</DIV>


<DIV id="noprintarea">
<?php 
//更新情報
if (($okcount+$errcount)>0) {
	if ($okcount > 0 ){
		PrintMsg("","$okcount 件のデータを更新しました。",700);
	}
	if ($errcount > 0 ){
		PrintMsg("登録エラーが $errcount 件有りました。<br>$errmsg","",700);
	}
}
?>
<br></DIV>
<DIV class="floatlt100">
<?php if($maxrow>0) {?>
<table border=2>
<tr> 
	<th><h2>サプライヤー</h2></th>
	<th><h2>商品コード<br>商品名</h2></th>
	<th><h2>規格</h2></th>
	<th><h2>現在在庫</h2></th>
	<th><h2>調整数</h2></th>
	<th><h2>受注数</h2></th>
	<th><h2>入荷予定</h2></th>
</tr> 
<tr> 
	<td><h2><?php PrintList2($companydata,GetListData($shohindata,$shohin,4),0); ?></h2></td>
	<td><h2><?php echo $shohin; ?><br><?php PrintList2($shohindata,$shohin,2); ?></h2></td>
	<td><h2><?php PrintList2($shohindata,$shohin,3); ?></h2></td>
	<td class="rt"><h2><?php echo number_format($zaiko[0][0]); ?></h2></td>
	<td class="rt"><h2><?php echo number_format($zaiko[0][1]); ?></h2></td>
	<td class="rt"><h2><?php echo number_format($juchu[0][0]); ?></h2></td>
	<td><h2><?php
	//入荷予定
	$strsql2="SELECT sum(comeinqty) AS comeinqty,comeindate,comeinflg FROM `".$company."comeindata` as ke WHERE comeindate>= $excutedate $strsqlwhere $strsqlcenter GROUP BY comeindate ORDER BY comeindate";
	$result2=@mysql_query($strsql2,$my_con);
	$maxrow2=@mysql_num_rows($result2);
	Testecho ("LINE ".__LINE__." ".$y." ".$strsql2);  //debug
	mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
	if ($maxrow2==0) {
		echo "入荷予定無し";
	} else {
		while ($data2 = mysql_fetch_array($result2)) {
			echo $data2[comeindate];
			echo "　数量：";
			echo number_format($data2[comeinqty]);
			if($data2[comeinflg]>0) {
				echo "(在庫反映済)";
			}
			echo "<br>";
		}
	}
?>
</h2></td>
</tr> 
</table>
</DIV>


<?php 
ShowNavBar2($maxrow,$pageset,$page,"75%",$order);
?>
<form action="5200.php#fragment-5" method="post" name="sw" target="_top">
<?php if ($maxrow>0) { ?>
<table width="95%" border="0" cellspacing="5"><tr><td align="right"><input type="submit" name="update" value="更新" class="box1"></td></tr></table>
<?php } ?>
<table id="data-table">
<tr> 
    <th>No</th>
    <th>サプライヤー</th>
    <th>納品先</th>
    <th>入数</th>
    <th>合数</th>
    <th>荷姿</th>
    <th>規格</th>
    <th>受注</th>
    <th>出荷</th>
    <th>直送</th>
    <th>仮入荷出荷</th>
    <th>特記</th>
    <th>備考</th>
    <th>欠品数</th>
    </tr>
<?php 
$j=0;$k=0;;
	while ($data=@mysql_fetch_array($result)) {

 ?>
	<tr> 
		<input type="hidden" name="id<?php echo $j;?>" value="<?php echo $data[keppinid]; //欠品ID?>">
		<input type="hidden" name="orderid<?php echo $j;?>" value="<?php echo $data[orderid]; //受注明細ID ?>">
		<td class="rt"><?php echo ($pageset*($page  - 1))+$j+1;// ?></td>
		<td><?php echo $data[companyname]; //サプライヤー ?></td>
		<td><?php echo $data[shozokuname]; //納品先 ?></td>
		<td class="rt"><?php echo $data[irisuu]; //入数 ?></td>
		<td class="rt"><?php echo $data[aisuu]; //合数 ?></td>
		<td class="rt"><?php echo $data[nisugata]; //センター荷姿 ?></td>
		<td class="rt"><?php echo $data[kikaku]; //規格 ?></td>
		<td class="rt"><?php echo (int)$data[orderqty];$totalorder += (int)$data[orderqty]; //受注数 ?></td>
<?php if ($data[keppinflg]=="1"){ ?>
		<td class="rt"><input type=text size="5" name="shukka<?php echo $j;?>" value="<?php echo (int)$data[shukkaqty]; $totalshukka += (int)$data[shukkaqty];//出荷数 ?>" class="EDIT"></td>
		<td class="rt"><input type=text size="5" name="choku<?php echo $j;?>" value="<?php echo (int)$data[directqty];  $totaldirect += (int)$data[directqty];//直送 ?>" class="EDIT"></td>
		<td class="rt"><input type=text size="5" name="kari<?php echo $j;?>" value="<?php echo (int)$data[etcqty1];  $totalkari += (int)$data[etcqty1];//仮入荷出荷 ?>" class="EDIT"></td>

<?php } else { ?>
		<td class="rt"><input type="hidden" name="shukka<?php echo $j;?>" value="<?php echo (int)$data[shukkaqty]; $totalshukka += (int)$data[shukkaqty];//出荷数 ?>" class="EDIT"><?php echo $data[shukkaqty];?></td>
		<td class="rt"><input type="hidden" name="choku<?php echo $j;?>" value="<?php echo $data[directqty];  $totaldirect += (int)$data[directqty];//直送 ?>" class="EDIT"><?php echo $data[directqty];?></td>
<?php } ?>
		<td class="rt"><input type=text size="25" name="memo<?php echo $j;?>" value="<?php echo $data[memo]; ?>"></td>
		<td>
<?php
//セラピストデータ表示
$staffdata = dbselect("sf.staffid,sf.staff_name","`".$company."ordersheet` INNER JOIN `".$company."staff` as sf USING(staffid)","orderid ='".$data[orderid]."'",-1,-1);

echo "[".$staffdata[0][0]."] ".$staffdata[0][1];
?>
		</td>
		<td class="rt">
<?php
$totalqty += $data[keppinqty];
$keppinflg=$data[keppinflg];

if ($data[keppinqty]>=0) { echo $data[keppinqty] ;} else {echo "<div class=\"border3\"> 数が合いません(".$data[keppinqty].")</div>";$interr++;} ?>
<input type="hidden" name="orderqty<?php echo $j;?>" value="<?php echo $data[orderqty]; ?>">
	</tr>

	<?php 
		$j++;
	}

?>
	<tr> 
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<th>合計</th>
		<td class="rt"><?php echo $totalorder; //受注数?></td>
		<td class="rt"><?php if ($totalshukka <= $zaiko[0][0]) { echo $totalshukka ;} else {echo "<div class=\"border3\">出荷総数".$totalshukka."が在庫".$zaiko[0][0]."以上です。(".($zaiko[0][0] - $totalshukka) .")</div>";$interr++;} //出荷数 ?></td>
		<td class="rt"><?php echo $totaldirect; //直送 ?></td>
		<td class="rt"><?php echo $totalkari; //仮入荷分出荷 ?></td>
		<td class="rt"></td>
		<td class="rt"></td>
		<td class="rt"><?php echo $totalqty; //欠品 ?></td>
	</tr>


</table>
<DIV id="noprintarea">
<?php 
ShowNavBar2($maxrow,$pageset,$page,"75%",$order);
?>
	<INPUT type="hidden" name="center" value="<?php echo $centerid; //センター ?>">
	<input type="hidden" name="max" value="<?php echo $j; //更新数 ?>">
	<input type="hidden" name="order" value="<?php echo $order; //表示順 ?>">
	<input type="hidden" name="pagenum" value="<?php echo $page; //ページ ?>">
	<input type="hidden" name="searchword" value="<?php echo $sw; //検索語 ?>">
	<input type="hidden" name="chgday" value="<?php echo $chgday; //発注日 ?>">
	<input type="hidden" name="shozoku" value="<?php echo $shozokuid; //納品先 ?>">
	<input type="hidden" name="picktimes" value="<?php echo $_POST[picktimes]; //ピック回数 ?>">
	<INPUT type="hidden" name="id"                  value="<?php echo $statusid; //ステータスＩＤ ?>">
	<input type="hidden" name="pageset" value="<?php echo $pageset; //表示件数 ?>">
	<input type="hidden" name="shohin" value="<?php echo $shohin; //商品 ?>">
	<input type="hidden" name="totalzaiko" value="<?php echo (int)$zaiko[0][0]; //現在の在庫数 ?>">
<?php if ($maxrow>0) { ?>
<table width="95%" border="0" cellspacing="5"><tr><td>
<?php if ($keppinflg==1) { ?>
<input type="submit" name="kakutei" value="確定処理" class="box1"<?php if ($interr<>"") echo " disabled"; ?>>
<?php } elseif ($keppinflg>=2) { ?>
<input type="submit" name="cancel" value="確定取り消し" class="box1" <?php if ($statusflg>4) echo " disabled"; ?>>
<?php } ?>
</td><td align="right"><input type="submit" name="update" value="更新" class="box1"></td></tr></table>
<?php } ?>
</form>
<?php } ?>
<br>
<br>
</FORM>
<FORM METHOD="POST" name="back" action="5000.php">
<input type="submit" value="状況確認へ戻る" name="button" class="box1">
<input type="hidden" name="chgday" value="<?php echo $chgday; //発注日 ?>">
</FORM>
<FORM METHOD="POST" name="FormGetSubmit" action="5200.php#fragment-5">
<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="id"                  value="<?php echo $statusid; //ステータスＩＤ ?>">
<INPUT type="hidden" name="shozoku"              value="">
<input type="hidden" name="picktimes" value="<?php echo $_POST[picktimes]; //ピック回数 ?>">
<INPUT type="hidden" name="center" value="<?php echo $centerid; //センター ?>">
<INPUT type="hidden" name="pageset" value="<?php echo $pageset; //表示件数 ?>">
<input type="hidden" name="totalzaiko" value="<?php echo (int)$zaiko[0][0]; //現在の在庫数 ?>">

</FORM><?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</DIV>
</html>
<?php 
/*------------------------------------------------------------
 *  関数名 : PrintSelectList5200()
 *  返却値 : なし
 *  引数   : (1) i: プルダウンリストの配列
 *                  [i][0]表示文字列[i][1]value コード値は２番目
 *         : (2) i: リストの中でどれをSelectedにするか(配列要素番号)
 *         : (3) i: 項目番号
 *  説明   : 指定されたものをSelectedにしてプルダウン表示
 *------------------------------------------------------------
 */
function PrintSelectList5200(
    $list,
    $selected,
    $no )
{
    
    $n = sizeof($list);
    for ($pi = 0; $pi < $n; $pi++) {
        $str = "<option";
        
		Switch($list[$pi][$no]) {
			case 3:
				$str .=	" style=\"color:#000000; background-color:#bbbbbb\" ";break;
			case 2:
				$str .=	" style=\"color:#000000; background-color:#bbbbbb\" ";break;
			default :
				$str .=	" style=\"color:#000000; background-color:#eee8aa;\" ";break;
		}
		if($list[$pi][1] == $selected) $str .= " selected";
		if(isset($list[$pi][1])) {
			$str .= " value=\"";
			$str .= $list[$pi][1]."\"";
		}
		$str .= ">";
		Switch($list[$pi][$no]) {
			case 3:
				$str .=	"(確定済)";break;
			case 2:
				$str .=	"(確定済)";break;
		}
		$str .= $list[$pi][0]."</option>\n";
        echo $str;
    }
}

myclose();
Testecho($strsqlkeppin.$limit);
Testecho($strsqlkeppin);
Testecho($strsql3);
?>