<?php  //倉庫在庫移動
include "func.cgi";
myopen();
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//未処理データ
$norundata = dbselect("count(statusid)","`".$company."status`","status > 0 and operatedate =CURDATE()","operatedate,status","1");
Testecho($strsqldbselect);

//センターコード
$centerid = $_POST[center];
$centerid2 = $_POST[center2];
if($userdata["kengen"] == 30) {
	$centerdata = dbselect("co.companyname,co.companyid","company as co INNER JOIN usecenter USING (companyid)","companykind=30","companyid",-1);
	$centerid = $centerdata[0][1];
	$centerid2 = $centerdata[1][1];
testecho($strsqldbselect);
} elseif($centerid =="") {
	$centerid2 = $centerdata[1][1];
	$centerid = $centerdata[0][1];
} elseif($centerid==$centerid2) {
	if($centerid == $centerdata[0][1]) {
		$centerid2 = $centerdata[1][1];
	} else {
		$centerid2 = $centerdata[0][1];
	}
}
if($_POST[chgday]=="") {
	$chgday = 0;
} else {
	$chgday = $_POST[chgday];
}

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

//在庫調整区分
$stockkubundata = dbselect("cname,code","`".$company."code`","codekind = '2'","code",-1);

//更新処理
if ($_POST[update] <> ""){

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

	For ($y=0;$y<((int)$_POST[rownum]);$y++) {
		if ($_POST{"lot".$y} == "") 	break;

		if(($_POST{"amount".$y} == 0) and ($_POST{"amountold".$y} == 0)) {
			//更新しない
		} elseif($_POST{"amount".$y} == $_POST{"amountold".$y}) {
			//更新しない
		} elseif($_POST{"amount".$y}==0) { 
			//削除
			$strsql = "DELETE FROM `".$company."transdata` where transid='".$_POST{"trans".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
			if($errcode==1062) {  //重複
				Testecho ("A.更新 1062");
				$errcount++;
			} elseif($errcode==0) {
				if(mysql_affected_rows()==1) { 	$okcount++; }
				Testecho ("A.更新 OK 0");
			} else {
				Testecho ("A.更新 ERROR");
				$errcount++;
				$errmsg .= "ERROR=".$errcode;
			}

			$strsql = "DELETE FROM `".$company."comeindata` where transid='".$_POST{"trans".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		} elseif(($_POST{"amount".$y}>0) and ($_POST{"amountold".$y}==0)) {
			//新規
			$strsql = "DELETE FROM `".$company."transdata` where transid='".$_POST{"trans".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
			if($_POST{"amount".$y} > $_POST{"zaikonow".$y}){
				$errmsg .= "[ No.".($y +1). "]" .$_POST{"shohincd".$y}." 在庫数を超える移動数量の入力はできません。";
				$errcount++;
				$intnewamount = (int)$_POST{"zaikonow".$y};
			} else {
				$intnewamount = (int)$_POST{"amount".$y};
			}
			$strsql = "INSERT INTO `".$company."transdata`(lotnum,centerid,shohincd,transdate,shomi,stockdate,transqty,tocenterid,creater,createdate) SELECT lotnum,centerid,shohincd,DATE_ADD( CURDATE() , INTERVAL ".$chgday." DAY ),shomi,stockdate,'".$intnewamount."','".$centerid2."','".$userdata["tid"]."',now() from `".$company."stockdata` where lotnum='".$_POST{"lot".$y}."'";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
			if($errcode==1062) {  //重複
				Testecho ("A.更新 1062");
				$errcount++;
			} elseif($errcode==0) {
				if(mysql_affected_rows()==1) { 	$okcount++; }
				Testecho ("A.更新 OK 0");
			} else {
				Testecho ("A.更新 ERROR");
				$errcount++;
				$errmsg .= "ERROR=".$errcode;
			}

			$locationdata = dbselect("loccode","`".$company."shohinlocation`","centerid='".$centerid2."' AND shohincd='".$_POST{"shohincd".$y}."'",-1,-1);
			Testecho($strsqldbselect);
			$transdata = dbselect("transid","`".$company."transdata`","lotnum='".$_POST{"lot".$y}."' and transdate = DATE_ADD(CURDATE() , INTERVAL ".$chgday." DAY ) AND centerid ='".$centerid."'",-1,-1);

			$strsql = "INSERT INTO `".$company."comeindata`(centerid,shohincd,comeindate,shomi,comeinqty,loccode,transid,creater,createdate) SELECT '".$centerid2."',shohincd,DATE_ADD( CURDATE() , INTERVAL ".$chgday." DAY ),shomi,'".$intnewamount."','".$locationdata[0][0]."','".$transdata[0][0]."','".$userdata["tid"]."',now() from `".$company."stockdata` where lotnum='".$_POST{"lot".$y}."'";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		} else {	
			//更新
			if($_POST{"amount".$y} > $_POST{"zaikonow".$y}){
				$errmsg .= "[ No.".($y +1) ."]" .$_POST{"shohincd".$y}." 在庫数を超える移動数量の入力はできません。";
				$errcount++;
				$intnewamount = (int)$_POST{"zaikonow".$y};
			} else {
				$intnewamount = (int)$_POST{"amount".$y};
			}
			$strsql = "UPDATE `".$company."transdata` SET transqty='".$intnewamount."',updater='".$userdata["tid"]."',updatedate = '' where transid='".$_POST{"trans".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

			if($errcode==0) {
				if(mysql_affected_rows()==1) { 	$okcount++; }
				Testecho ("A.更新 OK 0");
			} else {
				Testecho ("A.更新 ERROR");
				$errcount++;
				$errmsg .= "ERROR=".$errcode;
			}

			$strsql = "UPDATE `".$company."comeindata` SET comeinqty='".$intnewamount."',updater='".$userdata["tid"]."',updatedate = '' where transid='".$_POST{"trans".$y}."' limit 1";
			$result=mysql_query($strsql,$my_con);
			Testecho($y." = ".$strsql);  #debug
			$errcode =mysql_errno();
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}
	}
}


//１ページ数
$pageset = 20;

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


//データ取得数
$limit = " LIMIT ".($pageset*($page  - 1)).",$pageset";

//検索処理
$sw = Eucjp($_POST[searchword]);
$sw = str_replace(" ","",$sw); //空白除く
$sw = mb_convert_kana($sw,'KV');  //全て全角へ変換

//検索用語のＷＨＥＲＥ句
$strsql = "";
if ($sw<>"") {
	$strsqljoin = " and sm.searchword like '%".$sw."%'";
} else {
	$strsqljoin = "";
}

$strsqljoin .= " and sm.zaiko=1 and validflg=1";
if(($company == "body_") and ($userdata["roleid"] == 20)) {
	$strsqljoin .= " and sm.category = 8 ";
}

$strsql = "SELECT sd.lotnum, sd.shohincd, sd.centerid, sd.stockdate, sd.shomi, nonreserveqty,transqty, sd.location, nonreserveqty ,sm.shohinmei,sm.makercode,sm.shomiflg,sm.kikaku,td.transid,transflg FROM (`".$company."stockdata` AS sd INNER JOIN `".$company."shohinmaster` AS sm USING(shohincd) ) LEFT JOIN `".$company."transdata` AS td on(sd.lotnum = td.lotnum and transdate = DATE_ADD( CURDATE() , INTERVAL ".$chgday." DAY ) ) WHERE nonreserveqty>0 ".$strsqljoin." AND sd.centerid='".$centerid."' order by sd.shohincd,shomi,sd.stockdate";
//全数
$resultall=@mysql_query($strsql,$my_con);
$maxrow=@mysql_num_rows($resultall);

//１ページ分
$strsql .= $limit;

$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 submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  form.order.value= order
  form.searchword.value="<?php echo $sw; //検索語 ?>"
  FormGetSubmit.submit()
}

function disableSubmit(form) {
  var elements = form.elements;
  for (var i = 0; i < elements.length; i++) {
	if (elements[i].type == 'submit') {
	  elements[i].disabled = true;
	}
  }
}
function submitALL2() {
  form = document.sww
  sww.submit()
}
-->
</SCRIPT>
<body>
<?php Honbutitle3("倉庫在庫移動",$_SERVER['PHP_SELF']); ?>
<div class="border1">
<form action="3700.php#fragment-3" method="post" name="sww" onsubmit="disableSubmit(this)">
	<span class="border1box">
	作業日<br>
	<select name="chgday" onchange="document.sww.Submit.disabled=true;submitALL2();return false;">
	<?php 
	//移動日セレクトリスト
	if ($norundata[0][0] >= 1) {
		PrintSelectDay2(1,3,-2,$chgday,"移動日<br>","1111111");
	} else {
		PrintSelectDay2(0,3,-2,$chgday,"移動日<br>","1111111");
	}
	?>
	</select>
	</span>
	<span class="border1box">
		センター（出）<br>
		<select name="center" onchange="document.sww.Submit.disabled=true;submitALL2();return false;">
		<?php if (($userdata["kengen"] <> 30) and (count($centerdata)>1)) { ?>
		<?php } PrintSelectList($centerdata,$centerid ,0); ?>
		</select>
	</span>
	<span class="border1box">
		センター（至）<br>
		<select name="center2" onchange="document.sww.Submit.disabled=true;submitALL2();return false;">
		<?php if (($userdata["kengen"] <> 30) and (count($centerdata)>1)) { ?>
		<?php } PrintSelectList($centerdata,$centerid2 ,0); ?>
		</select>
	</span>
<?php showSearchbox($sw,1,-1); //商品検索 ?>
<?php showSearchBotton(-1,-1,-1); //検索ボタン ?>
</form>
</div>

<?php 
//更新情報
if (($okcount+$errcount)>0) {
	if ($okcount > 0 ){
		PrintMsg("","$okcount 件のデータを更新しました。",700);
	}
	if ($errcount > 0 ){
		PrintMsg("登録エラーが $errcount 件有りました。","",700);
	}
	PrintMsg($errmsg,"",700);
} elseif($_POST[update] <> ""){
	PrintMsg("","更新は0件です。",700);
}
?>
<form action="3700.php#fragment-3" method="post" name="sw" target="_top">
<?php 
$order=1;
ShowNavBar3($maxrow,$pageset,$page,"700",$order);
?>
<table id="data-table">
<tr> 
	<th>No</th>
	<th>LOT</th>
	<th>サプライヤー</th>
	<th>商品名</td>
	<th>商品コード</a></th>
	<th>規格</th>
	<th>入荷日</th>
	<th>期限管理</th>
	<th>期限</th>
	<th>ロケーション</th>
	<th>有効<br>在庫</th>
	<th>移動数</th>
	<th>受付数</th>
</tr>
<?php 
$i=0;$flg=0;$j=0;
if ($maxrow==0) {
?><tr><td colspan=12>検索結果はゼロ件でした。</td></tr>
<?php 
} else {
	$i=0;

	while ($data=@mysql_fetch_array($result)) {
	?>
<tr> 
	<td><?php echo ($i + 1 +$pageset*($page -1 )) ?></td>
	<td><?php echo $data["lotnum"]; ?></td>
	<input type="hidden" name="lot<?php echo $i;?>" value="<?php echo $data["lotnum"]; //Lot ?>">
	<input type="hidden" name="trans<?php echo $i;?>" value="<?php echo $data["transid"]; //transid ?>">
	<input type="hidden" name="shohincd<?php echo $i;?>" value="<?php echo $data["shohincd"]; //shohincd ?>">
	<input type="hidden" name="zaikonow<?php echo $i;?>" value="<?php echo (int)$data["nonreserveqty"]; // ?>">
	<td><?php PrintList($companydata,$data["makercode"],0); ?></td>
	<td><?php echo $data["shohinmei"]; ?></td>
	<td><?php echo $data["shohincd"]; ?></td>
	<td><?php echo $data["kikaku"]; ?></td>
	<td><?php echo $data["stockdate"]; //入庫日 ?></td>
	<td><?php PrintShomi($data["shomiflg"],1); //賞味期限 ?></td>
	<td><?php echo $data["shomi"]; //賞味期限 ?></td>
	<td><?php echo $data["location"]; //ロケーション ?></td>
	<td class="rt"><?php echo $data["nonreserveqty"]; //有効在庫数 ?></td>
<?php
		if($data["transflg"]>1) {
?>
	<td>処理済</td>

<?php
		} else {
?>
	<td><input type="hidden" name="amountold<?php echo $i;?>" value="<?php echo (int)$data["transqty"]; // ?>"><input type=text size=3 name="amount<?php echo $i;?>" value="<?php echo (int)$data["transqty"]; // ?>" class="EDIT"></td>
<?php
		}
?>
	<td class="rt"><?php echo (int)$data["transqty"]; // ?></td>
</tr> 
	<?php 
	$i++;
	}

}
?>
</table>
<input type=hidden name="rownum" value="<?php echo $maxrow; //更新数 ?>">
</table>
<?php 
ShowNavBar3($maxrow,$pageset,$page,"700",$order);
?>
<input type="hidden" name="maker" value="<?php echo $_POST[maker]; //サプライヤー ?>">
<input type="hidden" name="center" value="<?php echo $centerid; //センター ?>">
<input type="hidden" name="center2" value="<?php echo $centerid2; //センター ?>">
<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; //発注日 ?>"><br>
</form>
<br>
<br>

<FORM METHOD="POST" name="FormGetSubmit" action="3700.php#fragment-3">
<INPUT type="hidden" name="pagenum"        value="">
<INPUT type="hidden" name="order"          value="">
<INPUT type="hidden" name="searchword"     value="">
<INPUT type="hidden" name="center"         value="<?php echo $centerid; //検索語 ?>">
<input type="hidden" name="center2"        value="<?php echo $centerid2; //センター ?>">
<INPUT type="hidden" name="goods"          value="<?php echo $_POST[goods]; //検索語 ?>">
<input type="hidden" name="chgday"         value="<?php echo $chgday; //発注日 ?>"><br>

</FORM>
</DIV>
<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
myclose();
Testecho( $strsql);//debug

?>