代码拉取完成，页面将自动刷新
<?php
header('Content-type: text/html; charset=utf-8');
require_once('connDB.php');
if(!isset($_SESSION)){
session_start();
}
//echo 'abccccc3';
$ID = " ";
$CUSTID = " ";
$CUSTMNO = " ";
$REVTIME = " ";
$BUSINO = " ";
$INBONO = " ";
$CARRNO = " ";
$TGW = " ";
$TVOL = " ";
$SHIPTO = " ";
$SHIPFROM = " ";
$CHEPAI = " ";
$BAIKAHAO = " ";
$REMARK = " ";
$REF01 = " ";
$PKGTYPE = " ";
$sql=" ";
//echo 'abccccc2';
if(isset($_GET['ID']) AND isset($_GET['ITEMNO']) AND isset($_GET['SKU']))
{
//echo 'abccccc';
$ID = $_GET['ID'];
$ITEMNO= $_GET['ITEMNO'];
$SKU= $_GET['SKU'];
$SKUCN= $_GET['SKUCN'];
$SKUEN= $_GET['SKUEN'];
$VEDCODE= $_GET['VEDCODE'];
$UOM= $_GET['UOM'];
$UOMNUM= $_GET['UOMNUM'];
$FDUNIT= $_GET['FDUNIT'];
$TWEIGHT= $_GET['TWEIGHT'];
$UNITWEIGHT= $_GET['UNITWEIGHT'];
$SKUN= $_GET['SKUN'];
$CUSTMITEM= $_GET['CUSTMITEM'];
$COO= $_GET['COO'];
$UNITPRICE= $_GET['UNITPRICE'];
$TPRICE= $_GET['TPRICE'];
$LOC= $_GET['LOC'];
//echo "123";
//echo iconv("gbk","UTF-8//IGNORE",$SKUCN);
$sql = "UPDATE `webwms`.`asnd` SET `SKU` = '$SKU',".
"SKUCN = '$SKUCN', ".
"SKUEN = '$SKUEN', ".
"VEDCODE = '$VEDCODE',".
"UOM = '$UOM', ".
"UOMNUM = '$UOMNUM', ".
"FDUNIT = '$FDUNIT', ".
"TWEIGHT = '$TWEIGHT', ".
"UNITWEIGHT = '$UNITWEIGHT', ".
"SKUN = '$SKUN', ".
"CUSTMITEM = '$CUSTMITEM', ".
"COO = '$COO', ".
"UNITPRICE = '$UNITPRICE', ".
"TPRICE = '$TPRICE', ".
"LOC = '$LOC' ".
"WHERE asnd.ID =$ID AND asnd.ITEMNO =$ITEMNO ";
mysql_query($sql,$dbc);
//echo $sql;
//echo ' add detail ok';
$sql = "SELECT nID, ID, ASNID, ITEMNO, SKU, SKUCN, SKUEN, VEDCODE, UOM, UOMNUM, ";
$sql = $sql."FDUNIT, TWEIGHT, UNITWEIGHT, SKUN,CUSTMITEM,COO,UNITPRICE,TPRICE,LOC FROM asnd WHERE ID=$ID ";
//echo $sql;
$result = mysql_query($sql,$dbc);
$row_Rec = mysql_fetch_assoc($result);
$strHtml = "";
$strHtml = $strHtml."<table border='1'>";
$strHtml = $strHtml."<tr>";
$strHtml = $strHtml."<td>nID</td>";
$strHtml = $strHtml."<td>ID</td>";
$strHtml = $strHtml."<td>ASNID</td>";
$strHtml = $strHtml."<td>ITEMNO</td>";
$strHtml = $strHtml."<td>SKU</td>";
$strHtml = $strHtml."<td>SKUCN</td>";
$strHtml = $strHtml."<td>SKUEN</td>";
$strHtml = $strHtml."<td>VEDCODE</td>";
$strHtml = $strHtml."<td>UOM</td>";
$strHtml = $strHtml."<td>UOMNUM</td>";
$strHtml = $strHtml."<td>FDUNIT</td>";
$strHtml = $strHtml."<td>TWEIGHT</td>";
$strHtml = $strHtml."<td>UNITWEIGHT</td>";
$strHtml = $strHtml."<td>SKUN</td>";
$strHtml = $strHtml."<td>CUSTMITEM</td>";
$strHtml = $strHtml."<td>COO</td>";
$strHtml = $strHtml."<td>UNITPRICE</td>";
$strHtml = $strHtml."<td>TPRICE</td>";
$strHtml = $strHtml."<td>LOC</td>";
$strHtml = $strHtml."<td>操作</td>";
$strHtml = $strHtml."</tr>";
do{
$strHtml = $strHtml."<tr>";
$strHtml = $strHtml."<td>".$row_Rec['nID']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['ID']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['ASNID']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['ITEMNO']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['SKU']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['SKUCN']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['SKUEN']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['VEDCODE']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['UOM']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['UOMNUM']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['FDUNIT']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['TWEIGHT']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['UNITWEIGHT']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['SKUN']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['CUSTMITEM']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['COO']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['UNITPRICE']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['TPRICE']."</td>";
$strHtml = $strHtml."<td>".$row_Rec['LOC']."</td>";
//$strHtml = $strHtml."<td><a href=\"#\" id=\"$row_Rec['nID']\">DEL</a></td>"
$strHtml = $strHtml."<td>";
$strHtml = $strHtml."<a href=\"#\" id=\"".$row_Rec['nID']."\">DEL</a>";
$strHtml = $strHtml." | ";
$strHtml = $strHtml."<a href=\"#\" id=\"".$row_Rec['nID']."\">MODIFY</a>";
$strHtml = $strHtml."</td>";
$strHtml = $strHtml."</tr>";
} while($row_Rec = mysql_fetch_assoc($result));
$strHtml = $strHtml."</table>";
echo $strHtml;
return;
// SELECT * FROM asnd WHERE ID=108 AND `ITEMNO` =1
//nID ID ASNID ITEMNO SKU SKUCN SKUEN VEDCODE UOM UOMNUM FDUNIT TWEIGHT UNITWEIGHT SKUN CUSTMITEM COO UNITPRICE TPRICE LOC
}
/*
UPDATE `webwms`.`asnd` SET `SKU` = 'aa',
`SKUCN` = 'bb',
`SKUEN` = 'cc',
`VEDCODE` = 'ddd',
`UOM` = 'ff',
`UOMNUM` = '1',
`FDUNIT` = 'aa',
`TWEIGHT` = '2',
`UNITWEIGHT` = '3',
`SKUN` = 'aa',
`CUSTMITEM` = 'bb',
`COO` = 'cc',
`UNITPRICE` = '1',
`TPRICE` = '2',
`LOC` = 'aaa' WHERE `asnd`.`nID` =34;
WHERE `asnd`.`ID` =96 AND `asnd`.`ITEMNO` =1;
*/
if(isset($_GET['ASN']) AND isset($_GET['DADD']))
{
/*
返回客户端响应，显示DETAIL的详细信息。
*/
//echo "TRUE";
//echo $_GET['DADD'];
//echo $_GET['ID'];
//echo $_GET['ASN'];
$res_Row = 0;
$ID = $_GET['ID'];
$ASN= $_GET['ASN'];
$sql = "SELECT * FROM asnd WHERE ID =$ID";
$row_Rec1 = mysql_query($sql,$dbc);
$res_Row=mysql_num_rows($row_Rec1);
//echo $res_Row;
$res_Row = $res_Row +1;
$sql= "INSERT INTO webwms.asnd(nID,ID,ASNID,ITEMNO)".
"VALUES(NULL, '$ID', '$ASN', $res_Row)";
mysql_query($sql,$dbc);
$sql="SELECT * FROM asnd WHERE ".
"ID = $ID ".
"AND ASNID = '$ASN' ".
"AND ITEMNO =$res_Row";
//SELECT CUSTID FROM asnh WHERE ID =249
//SELECT skuid, skucn FROM sku WHERE custid = 'zy1'
$sql2 = "SELECT CUSTID FROM asnh WHERE ID = $ID";
//echo $sql2;
$result2 = mysql_query($sql2,$dbc);
//echo '<br>';
//echo mysql_num_rows($result2);
//echo '<br>';
if(mysql_num_rows($result2)>0){
$res_Rec2 = mysql_fetch_assoc($result2);
//echo $res_Rec2['CUSTID'];
$cid = $res_Rec2['CUSTID'];
$sql2 = "SELECT skuid, skucn, skuen FROM sku WHERE custid = '$cid'";
echo $sql2;
}else{
return;
}
$result3=mysql_query($sql2,$dbc);
$row_Rec3 = mysql_fetch_assoc($result3);
echo "--o|o--";
$SKU_CN = "START";
$SKU_EN = "START";
echo '<table border = "1" width="1024">';
echo '<tr>';
echo '<td>ID</td>';
echo '<td>'.$_GET['ID'].'</td>';
echo '<td>ASN</td>';
echo '<td>'.$_GET['ASN'].'</td>';
echo '<td>Detail_ID</td>';
echo '<td>'.$res_Row.'</td>';
echo '<td>Item_NO</td>';
//echo '<td> </td>';
echo '<td>';
echo '<input name="ID" type="hidden" id="ID" value='.$_GET['ID'].'/>';
echo '<input name="ITEMNO" type="hidden" id="ITEMNO" value='.$res_Row.' />';
echo '</td>';
echo '</tr>';
echo '<tr>';
echo '<td>SKU</td>';
if(mysql_num_rows($result3)>0){
echo '<td>';
echo '<select name ="SKU" id="SKU" width="100" onchange="change(this)">';
echo '<option>Please Choice SKU ID</option>';
do {
echo '<option value="'.$row_Rec3['skuid'].'">';
echo $row_Rec3['skuid'].'->'.$row_Rec3['skucn'];
$SKU_CN=$SKU_CN.'.|.'.$row_Rec3['skucn'];
$SKU_EN=$SKU_EN.'.|.'.$row_Rec3['skuen'];
echo '</option>';
}while($row_Rec3 = mysql_fetch_assoc($result3));
echo '</select>';
echo '</td>';
}else{
echo '<td><input name="SKU" type="text" id="SKU"/></td>';
}
echo '<td>SKUCN</td>';
echo '<td><input name="SKUCN" type="text" id="SKUCN"/></td>';
echo '<td>SKUEN</td>';
echo '<td><input name="SKUEN" type="text" id="SKUEN"/></td>';
echo '<td>VEDCODE</td>';
echo '<td><input name="VEDCODE" type="text" id="VEDCODE"/></td>';
echo '</tr>';
echo '<tr>';
echo '<td>UOM</td>';
echo '<td><input name="UOM" type="text" id="UOM"/></td>';
echo '<td>UOMNUM</td>';
echo '<td><input name="UOMNUM" type="text" id="UOMNUM"/></td>';
echo '<td>FDUNIT</td>';
echo '<td><input name="FDUNIT" type="text" id="FDUNIT"/></td>';
echo '<td>TWEIGHT</td>';
echo '<td><input name="TWEIGHT" type="text" id="TWEIGHT"/></td>';
echo '</tr>';
echo '<tr>';
echo '<td>UNITWEIGHT</td>';
echo '<td><input name="UNITWEIGHT" type="text" id="UNITWEIGHT"/></td>';
echo '<td>CUSTMITEM</td>';
echo '<td><input name="CUSTMITEM" type="text" id="CUSTMITEM"/></td>';
echo '<td>COO</td>';
echo '<td><input name="COO" type="text" id="COO"/></td>';
echo '<td>UNITPRICE</td>';
echo '<td><input name="UNITPRICE" type="text" id="UNITPRICE"/></td>';
echo '</tr>';
echo '<tr>';
echo '<td>TPRICE</td>';
echo '<td><input name="TPRICE" type="text" id="TPRICE"/></td>';
echo '<td>LOC</td>';
echo '<td><input name="LOC" type="text" id="LOC"/></td>';
echo '<td> </td>';
echo '<td> </td>';
echo '<td> </td>';
echo '<td> </td>';
echo '</tr>';
echo '</table>';
echo "--o|o--";
echo $SKU_CN;
//$obj->skucn=$SKU_CN;
//$obj->skuen=$SKU_EN;
//echo json_encode($obj);
return;
}
if(isset($_GET['ID']))
{
$ID = $_GET['ID'];
$CUSTID = $_GET['CUSTID'];
$CUSTMNO = $_GET['CUSTMNO'];
$REVTIME = $_GET['REVTIME'];
$BUSINO = $_GET['BUSINO'];
$INBONO = $_GET['INBONO'];
$CARRNO = $_GET['CARRNO'];
$TGW = $_GET['TGW'];
$TVOL = $_GET['TVOL'];
$SHIPTO = $_GET['SHIPTO'];
$SHIPFROM = $_GET['SHIPFROM'];
$CHEPAI = $_GET['CHEPAI'];
$BAIKAHAO = $_GET['BAIKAHAO'];
$REMARK = $_GET['REMARK'];
$REF01 = $_GET['REF01'];
$PKGTYPE = $_GET['PKGTYPE'];
//echo 'ok'.$ID.$CUSTID.$CUSTMNO.$REVTIME.$BUSINO.$INBONO.$CARRNO.$TGW.$TVOL.$SHIPTO.$SHIPFROM.$CHEPAI.$BAIKAHAO.$REMARK.$REF01.$PKGTYPE;
$sql="UPDATE webwms.asnh SET CUSTID = '$CUSTID', ".
"CUSTMNO = '$CUSTMNO', ".
"REVTIME = '$REVTIME', ".
"BUSINO = '$BUSINO', ".
"INBONO = '$INBONO', ".
"CARRNO = '$CARRNO', ".
"TGW = '$TGW', ".
"TVOL = '$TVOL', ".
"SHIPTO = '$SHIPTO', ".
"SHIPFROM = '$SHIPFROM', ".
"CHEPAI = '$CHEPAI', ".
"BAIKAHAO = '$BAIKAHAO', ".
"REMARK = '$REMARK', ".
"REF01 = '$REF01', ".
"PKGTYPE = '$PKGTYPE' ".
"WHERE asnh.ID =$ID ";
mysql_query($sql,$dbc);
}
/*
UPDATE webwms.asnh SET CUSTID = 'test5',
CUSTMNO = '0987654321',
REVTIME = '2014-01-27 14:36:43',
BUSINO = 'FADFWE887985',
INBONO = 'DDWE88974',
CARRNO = 'FFS34234566',
TGW = '66.3',
TVOL = '58',
SHIPTO = 'TESTSHIP1',
SHIPFROM = 'TESTSHIP2',
CHEPAI = 'HU11344',
BAIKAHAO = 'WUWU',
REMARK = 'DFE3FFD',
REF01 = 'FDSFE',
PKGTYPE = 'PKGS' WHERE asnh.ID =7;
*/
/*
INSERT INTO webwms.asnd (
nID ,
ID ,
ASNID ,
ITEMNO ,
SKU ,
SKUCN ,
SKUEN ,
VEDCODE ,
UOM ,
UOMNUM ,
FDUNIT ,
TWEIGHT ,
UNITWEIGHT ,
SKUN ,
CUSTMITEM ,
COO ,
UNITPRICE ,
TPRICE ,
LOC
)
VALUES (
NULL , '46', 'ASN000000046', '1', 'EEEFD', '在战争中', 'aaaaa', 'bbbbb', '个', '555', '个', '88', '1', NULL , '6657765', 'CN', '8', '666', 'A1');
*/
?>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
