<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	
	if(!isset($_SESSION)){
		session_start();
	}
	$id = " ";
	$LOCID= " ";
	$LOCCODE= " ";
	$LOCTYPE= " ";
	$LOCATTR= " ";
	$REMARK= " ";
	
	if(isset($_GET['onhold'])){
		$onholdID1 = $_GET['onhold'];
		//echo $onholdID1;
		$sql="UPDATE `lotxloc` INNER JOIN `loc` ON `lotxloc`.`LOC` = `loc`.`LOCCODE` 
			  SET `lotxloc`.`isHold` =  '1',
			 `loc`.`LOCATTR` = 'OnHold' WHERE `loc`.`ID` =$onholdID1";
		mysql_query($sql,$dbc);
		$obj->status=1;
		$obj->result=1;
		$obj->reason="Location Hold Complete";
		//$obj->sql=$sql;
		echo json_encode($obj);
		return;
	}
/*UPDATE `lotxloc` INNER JOIN `loc` ON `lotxloc`.`LOC` = `loc`.`LOCCODE` 
SET `lotxloc`.`isHold` =  '1',
`loc`.`LOCATTR` = 'OnHold' WHERE `loc`.`ID` =6*/		

	if(isset($_GET['freehold'])){
		$freeholdID1 = $_GET['freehold'];
		//echo $freeholdID1;
		$sql="UPDATE `lotxloc` INNER JOIN `loc` ON `lotxloc`.`LOC` = `loc`.`LOCCODE` 
			  SET `lotxloc`.`isHold` =  '0',
			 `loc`.`LOCATTR` = 'NORMAL' WHERE `loc`.`ID` =$freeholdID1";
		mysql_query($sql,$dbc);
		$obj->status=1;
		$obj->result=1;
		$obj->reason="Location Free Hold Complete";
		//$obj->sql=$sql;
		echo json_encode($obj);
		return;
	}
	
	if(isset($_POST['LOCID'])&& isset($_POST['addnew'])){	}
	
	if(isset($_GET['show'])&&($_GET['show']=="true")){
		echo '<form action="locf.php" method="POST">';
		echo '<label>库位ID</label>';
		echo '<input type="text" id="LOCID" name="LOCID" /><br>';
		echo '<label>库位编号</label>';
		echo '<input type="text" id="LOCCODE" name="LOCCODE" /><br>';
		echo '<label>库位类型</label>';
		echo '<input type="text" id="LOCTYPE" name="LOCTYPE" /><br>';
		echo '<label>库位属性</label>';
		echo '<input type="text" id="LOCATTR" name="LOCATTR" /><br>';
		echo '<label>库位备注</label>';
		//echo '<input type="text" id="REMARK" name="REMARK" /><br>';
		echo '<textarea name="REMARK" cols="50" row="15" id="REMARK" ></textarea><br>';
		echo '<input name="addnew" type="hidden" id="addnew" value="true" />';
		echo '<input type="submit" value="SUBMIT" name="submit" />';		
		echo '</form>';
	}
?>