代码拉取完成，页面将自动刷新
<?php
header('Content-type: text/html; charset=utf-8');
require_once('connDB.php');
if(!isset($_SESSION)){
session_start();
}
//--格式化数据的函数-------------------------------------------
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if((isset($_POST['MM_Gains']))&&($_POST['MM_Gains']=="GainsAdd")){
$SKU = $_POST['SKU'];
$QTY = $_POST['QTY'];
$LOC = $_POST['LOC'];
$remark2 = $_POST['remark2'];
if(empty($SKU)){
echo "错误，请选择相应的sku";
return;
}
$sql="SELECT MAX(`Id`) AS MAXID, MAX(`VCODE`) AS mvcode FROM `lotxloc`";
$result=mysql_query($sql,$dbc);
$row_Rec=mysql_fetch_assoc($result);
$MID=$row_Rec['MAXID'];
$MVCODE=$row_Rec['mvcode'];
$MID=$MID+1;
$MVCODE=$MVCODE+1;
$LOTID1=getGAINSID($MID);
$ASNID=date("Ymdhis",time());
//echo $LOTID1.$MVCODE;
$sql="INSERT INTO `webwms`.`lotxloc` (
`LOTID`, `SKU`, `QTY`, `ASNID`, `VCODE`, `LOC`, `remark5`, `isHold`, `REMARK1`) VALUES
('$LOTID1', '$SKU', '$QTY', 'D$ASNID','$MVCODE','$LOC',CURRENT_TIMESTAMP, '0', '$remark2');";
mysql_query($sql,$dbc);
echo "盘盈入库成功";
}
/*
SELECT MAX(`Id`) AS MAXID FROM `lotxloc`
INSERT INTO `webwms`.`lotxloc` (`Id`, `LOTID`, `SKU`, `QTY`, `ASNID`, `VCODE`, `LOC`, `REMARK1`, `remark2`, `remark3`, `remark4`, `remark5`, `isHold`) VALUES (NULL, '111', '222', '333', '444', '555', '666', NULL, NULL, NULL, NULL, CURRENT_TIMESTAMP, '0'); */
if((isset($_POST['MM_Losse']))&&($_POST['MM_Losse']=="LosseAdd")){
$SKU = $_POST['SKU'];
$QTY = $_POST['QTY'];
$LOC = $_POST['LOC'];
$LOTID = $_POST['LOTID'];
$remark1 = $_POST['remark1'];
if(empty($SKU)||empty($LOC)||empty($LOTID)){
echo "错误，请填入相应的sku,库位和批次号";
return;
}
$sql="SELECT * FROM `lotxloc`
WHERE `SKU` = '$SKU'
AND `LOC` = '$LOC'
AND `LOTID` = '$LOTID'";
//echo $sql;
$result1=mysql_query($sql,$dbc);
$row_Rec1=mysql_fetch_assoc($result1);
$ID2=$row_Rec1['Id'];
$QTY2=$row_Rec1['QTY'];
$LOT=$row_Rec1['LOTID'];
if($QTY<=$QTY2)
{ //未做循环判断，之后需补上
$sql="UPDATE `webwms`.`lotxloc` SET `QTY`=`QTY`-'$QTY' WHERE `lotxloc`.`id` =$ID2;";
mysql_query($sql,$dbc);
$sql="SELECT MAX(`id`) AS ID FROM `allocxloc`";
$result2=mysql_query($sql,$dbc);
$row_Rec2=mysql_fetch_assoc($result2);
$mID=$row_Rec2['ID'];
$mID=$mID+1;
$ALCID=getLOSSEID($mID);
$sql="INSERT INTO `webwms`.`allocxloc` (
`ALCID`, `SOID`, `SO_ID`, `SO_D_ID`, `SKU`, `QTY`, `LOTID`, `LOC`, `REMARK1`, `REMARK2`) VALUES (
'$ALCID', '0', '0', '0', '$SKU', '$QTY', '$LOTID', '$LOC', '$remark1', NULL);";
mysql_query($sql,$dbc);
echo "盘亏出库成功";
}else{
echo "错误，亏损数量大与库存数量";
return;
}
}
/*
SELECT MAX(`id`) AS ID FROM `allocxloc`
SELECT * FROM `lotxloc`
WHERE `LOTID` = 'LOT000000231' AND `SKU` = 'hjhwds001' AND `LOC` = 'aaa2'
INSERT INTO `webwms`.`allocxloc` (`id`, `ALCID`, `SOID`, `SO_ID`, `SO_D_ID`, `SKU`, `QTY`, `LOTID`, `LOC`, `REMARK1`, `REMARK2`) VALUES (NULL, '11', '22', '33', '44', '55', '66', '77', '88', NULL, NULL);
UPDATE `webwms`.`lotxloc` SET `QTY` = '1' WHERE `lotxloc`.`Id` =3;
UPDATE `webwms`.`allocxloc` SET `QTY` = '41' WHERE `allocxloc`.`id` =77;
SELECT * FROM `lotxloc`
WHERE `SKU` LIKE 'hjhwds001'
AND `LOC` LIKE 'aaa2'
**/
$sqlSKU="SELECT * FROM `sku`";
$resultSKU=mysql_query($sqlSKU,$dbc);
$resultSKU1=mysql_query($sqlSKU,$dbc);
//$row_Rec_SKU=mysql_fetch_assoc($resultSKU);
?>
<html>
<head>
<title>损益操作</title>
<script src="utils.js" type="text/javascript"></script>
<script src="gainslosse.js" type="text/javascript"></script>
<link rel="stylesheet" href="./themes/base/jquery.ui.all.css">
<script src="jquery-1.9.1.js" type="text/javascript"></script>
<script src="./ui/jquery.ui.core.js"></script>
<script src="./ui/jquery.ui.widget.js"></script>
<script src="./ui/jquery.ui.datepicker.js"></script>
<script src="./ui/jquery.ui.mouse.js"></script>
<script src="./ui/jquery.ui.draggable.js"></script>
<script src="./ui/jquery.ui.position.js"></script>
<script src="./ui/jquery.ui.resizable.js"></script>
<script src="./ui/jquery.ui.button.js"></script>
<script src="./ui/jquery.ui.dialog.js"></script>
<script src="./ui/jquery.ui.effect.js"></script>
<script src="./ui/jquery.ui.effect-blind.js"></script>
<script src="./ui/jquery.ui.effect-explode.js"></script>
<script src="./ui/jquery.ui.menu.js"></script>
<script src="./ui/jquery.ui.autocomplete.js"></script>
<link rel="stylesheet" href="demos.css">
<style type="text/css">
<!--
body {
#background-color: #00FFF1;
background:url(yh3.gif);
}
table {
border-collapse : collapse;
background-color: #FFFFFF;
}
.STYLE2 {
background-color: #FFFFFF;
}
.STYLE3 {
#background-color: #00FFF1;
background:url(yh3.gif);
}
-->
</style>
</head>
<script type="text/javascript">
$(function(){
var arrgains1=["-供应商多发","-装箱错误","-盘库多余","-其他原因"];
var arrlosse1=["-供应商少发","-装箱错误","-盘库缺少","-库内损坏","-其他原因"];
$("#remark2").autocomplete({
source: arrgains1
});
$("#remark1").autocomplete({
source: arrlosse1
});
});
</script>
<body align="center">
<p><h1>损益操作</h1></p><br>
<table border = "0" cellpadding="1" cellspacing="1" width="100%">
<tr><td align="center">
<button id="gains" style="width:150;height:30" >盘盈入库</button>
</td><td align="center">
<button id="losse" style="width:150;height:30" >盘亏出库</button>
</td></tr>
</table>
<br>
<div align="center" id="showGains">
<form method="POST" action="<?php echo $editFormAction?>" id="GainsForm1" name="GainsForm1">
<table border = "0" cellpadding="1" cellspacing="1" width="100%">
<tr><td>商品编码
</td><td>
<select id="SKU" name="SKU" width="200">
<option></option>
<?php while($row_Rec_SKU=mysql_fetch_assoc($resultSKU)){?>
<option value="<?php echo $row_Rec_SKU['skuid']?>">
<?php echo $row_Rec_SKU['skuid']."->".$row_Rec_SKU['skucn'] ?>
</option>
<?php } ?>
</select>
</td><td>数量
</td><td>
<input type="text" name="QTY" id="QTY" value="1" />
</td><td>库位
</td><td>
<input type="text" name="LOC" id="LOC" value="default" />
</td><td>原因
</td><td>
<input type="text" name="remark2" id="remark2" value="" />
</td></tr>
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
</table>
<input type="submit" name="Submit" value="提交盘盈入库" style="width:175;height:45" />
<input type="hidden" name="MM_Gains" value="GainsAdd" />
</form>
</div>
<div align="center" id="showLosse">
<form method="POST" action="<?php echo $editFormAction?>" id="LosseForm1" name="LosseForm1">
<table border = "0" cellpadding="1" cellspacing="1" width="100%">
<tr><td>商品编码
</td><td>
<select id="SKU" name="SKU" width="200">
<option></option>
<?php while($row_Rec_SKU=mysql_fetch_assoc($resultSKU1)){?>
<option value="<?php echo $row_Rec_SKU['skuid']?>">
<?php echo $row_Rec_SKU['skuid']."->".$row_Rec_SKU['skucn'] ?>
</option>
<?php } ?>
</select>
</td><td>数量
</td><td>
<input type="text" name="QTY" id="QTY" value="1" />
</td><td>库位
</td><td>
<input type="text" name="LOC" id="LOC" value="default" />
</td><td>原因
</td><td>
<input type="text" name="remark1" id="remark1" value="" />
</td></tr>
<tr><td>亏损批次号
</td><td>
<input type="text" name="LOTID" id="LOTID" value="" />
</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
</table>
<input type="submit" name="Submit" value="提交盘亏出库" style="width:175;height:45" />
<input type="hidden" name="MM_Losse" value="LosseAdd" />
</form>
</div>
</body>
<script type="text/javascript">
$("#showGains").css("display", "none");
$("#showLosse").css("display", "none");
$(document).ready(function(){
$("#gains").click(function(){
$("#showGains").css("display", "block");
$("#showLosse").css("display", "none");
});
$("#losse").click(function(){
$("#showLosse").css("display", "block");
$("#showGains").css("display", "none");
});
});
</script>
</html>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。