<?php 
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');	
	if(!isset($_SESSION)){
		session_start();
	}	
	if(isset($_POST['allTRSid'])){
		$str1 = $_POST['allTRSid'];
		//echo $str1;
		$arr1=array();
		$str1=rtrim($str1,"|");
		$str2=str_replace("|","','",$str1);
		$arr1=explode("|",$str1);
		//echo count($arr1);
		//echo $str2;
		$sql="UPDATE  `webwms`.`transmanage` 
			  SET  `TRASTATE` =  'SHIPPED' 
			  WHERE  `transmanage`.`TRSID` IN ('$str2');";
		mysql_query($sql,$dbc);		
		$sql="SELECT * 
			FROM  `transmanage` 
			INNER JOIN  `transmanaged` ON  `transmanage`.`id` =  `transmanaged`.`id` 
			WHERE  `transmanage`.`TRSID` 
			IN ('$str2')";
		$result=mysql_query($sql,$dbc);
		while($row_Rec=mysql_fetch_assoc($result)){
			$soID=$row_Rec['SOID'];
			$sql2="UPDATE `webwms`.`soh` SET `SOState` = 'SHIPPED' WHERE `soh`.`SOID` ='$soID';";
			mysql_query($sql2,$dbc);		
		}		
		$obj->result=1;
		$obj->status=1;
		$obj->reasons="transport order change state complete";
		echo json_encode($obj);
		return;
	}
/*SELECT * 
FROM  `transmanage` 
INNER JOIN  `transmanaged` ON  `transmanage`.`id` =  `transmanaged`.`id` 
WHERE  `transmanage`.`TRSID` 
IN (
'TRS00000008',  'TRS00000009',  'TRS00000007'
)*/	
/*UPDATE  `webwms`.`transmanage` SET  `TRASTATE` =  'SHIPPED' WHERE  `transmanage`.`id` =3;*/	
	if(isset($_POST['DRIVERNAME'])){
		$DRIVERNAME =  $_POST['DRIVERNAME'];
		$DRIVERPHONE =  $_POST['DRIVERPHONE'];
		$CHEPAI =  $_POST['CHEPAI'];
		$REMARK1 =  $_POST['REMARK1'];
		$sql="SELECT MAX(id) AS ID FROM `transmanage`";
		$result=mysql_query($sql,$dbc);
		$rec_Row=mysql_fetch_assoc($result);
		$mID = $rec_Row['ID'];
		$mID=$mID+1;
		$TRSID1=getTRSID($mID);
		$sql="INSERT INTO `webwms`.`transmanage` 
		(`TRSID`, `TRASTATE`, `CREATEDATE`, `DRIVERNAME`, `DRIVERPHONE`, `CHEPAI`, `REMARK1`) 
		VALUES 
		('$TRSID1', 'CREATE', CURRENT_TIMESTAMP, '$DRIVERNAME', '$DRIVERPHONE', '$CHEPAI', '$REMARK1');";
		mysql_query($sql,$dbc);
		
		$obj->result=1;
		$obj->status=1;
		$obj->reasons="add transfor info complete";
		echo json_encode($obj);
		return;
	}
	
	if(isset($_POST['delid'])){
		$did=$_POST['delid'];
		$sql="DELETE FROM `webwms`.`transmanage` WHERE `transmanage`.`id` = $did";
		mysql_query($sql,$dbc);
		
		$obj->result=1;
		$obj->status=1;
		$obj->reasons="transOrder delete is complete";
		echo json_encode($obj);
		return;		
	}

/*INSERT INTO `webwms`.`transmanage` (`id`, `TRSID`, `TRASTATE`, `CREATEDATE`, `DRIVERNAME`, `DRIVERPHONE`, `CHEPAI`, `REMARK1`, `REMARK2`, `REMARK3`, `REMARK4`, `REMARK5`) VALUES (NULL, '1', '2', CURRENT_TIMESTAMP, '3', '4', '5', '6', '7', '8', '9', '10');*/
?>