<?php
	//echo "123abc";
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}
	
	if(isset($_GET['ID'])){
		$ID=$_GET['ID'];
		$table1='<table border="1" cellpadding="1" cellspacing="1" width="1024">';
		$table1=$table1.'<tr><td>id</td><td>ALCID 配货ID号</td><td>SOID SO编号</td><td>SO_ID SO的id号</td><td>SO_D_ID SODetail的id</td><td>SKU SKU编号</td><td>QTY 配货数量</td><td>LOTID 批号ID</td><td>LOC 库位</td><td>REMARK1</td></tr>';
		$sql="SELECT * FROM `allocxloc` WHERE `SO_ID` =$ID";
		$result=mysql_query($sql,$dbc);
		while($row_Rec=mysql_fetch_assoc($result)){
			$table1=$table1.'<tr>
				<td>'.$row_Rec['id'].'</td>
				<td>'.$row_Rec['ALCID'].'</td>
				<td>'.$row_Rec['SOID'].'</td>
				<td>'.$row_Rec['SO_ID'].'</td>
				<td>'.$row_Rec['SO_D_ID'].'</td>
				<td>'.$row_Rec['SKU'].'</td>
				<td>'.$row_Rec['QTY'].'</td>
				<td>'.$row_Rec['LOTID'].'</td>
				<td>'.$row_Rec['LOC'].'</td>
				<td>'.$row_Rec['REMARK1'].'</td>
				</tr>';
		}
		$table1=$table1.'</table>';
		//echo $table1;
		$obj->result=1;
		$obj->status=1;
		$obj->respText="show Allocate Detail SO ID is->".$ID;
		$obj->table=$table1;
		echo json_encode($obj);
	}
/**
id	ALCID 配货ID号	SOID SO编号	SO_ID SO的id号	SO_D_ID SODetail的id	SKU SKU编号	QTY 配货数量	LOTID 批号ID	LOC 库位	REMARK1	REMARK2
*/
?>