📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_field.php" );
echo "<html>\r\n<head>\r\n<title>增加采购订单 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body class=\"bodycolor\">\r\n";
$query = "select * from PRODUCT where PRODUCT_ID='".$PRO_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRICE = $ROW['COST_PRICE'];
}
if ( $OP == "2" )
{
$query = "delete ORDER_LINE,SALE_HISTORY from ORDER_LINE a\r\n LEFT OUTER JOIN SALE_HISTORY b ON a.LINE_ID =b.LINE_ID\r\n where a.LINE_ID='".$LINE_ID."'";
exequery( $connection, $query );
echo "<script>\r\nlocation=\"index.php?ORDER_ID=";
echo $ORDER_ID;
echo "\";\r\n</script>\r\n";
}
if ( $OP == "1" )
{
if ( $ORDER_ID == "" )
{
$query = "select * from SUPPLY_ORDER where ORDER_NO='".$ORDER_NO."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
message( "错误", "订单 ".$ORDER_NO." 已存在" );
echo " <br>\r\n <div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php'\">\r\n </div>\r\n";
exit( );
}
$query = "INSERT into SUPPLY_ORDER (ORDER_NO,ORDER_NAME,ORDER_TYPE,ORDER_MEMO,PROVIDER_ID,LINKMAN_ID,CREATOR,RECIVER,CREATE_DATE,BEGIN_DATE,ORDER_PRINT,REMARK) values\r\n ('".$ORDER_NO."','{$ORDER_NAME}','{$ORDER_TYPE}','{$ORDER_MEMO}','{$PROVIDER_ID}','{$LINKMAN_ID}','{$CREATOR}','{$TO_ID}','{$CREATE_DATE}','{$BEGIN_DATE}','{$ORDER_PRINT}','{$REMARK}')";
exequery( $connection, $query );
$ORDER_ID = mysql_insert_id( );
save_field_data( "SUPPLY_ORDER", $ORDER_ID, $_POST );
}
else
{
$query = "update SUPPLY_ORDER set ORDER_NO='".$ORDER_NO."',ORDER_NAME='{$ORDER_NAME}',ORDER_TYPE='{$ORDER_TYPE}',ORDER_MEMO='{$ORDER_MEMO}',PROVIDER_ID='{$PROVIDER_ID}',LINKMAN_ID='{$LINKMAN_ID}',CREATOR='{$CREATOR}',RECIVER='{$TO_ID}',CREATE_DATE='{$CREATE_DATE}',BEGIN_DATE='{$BEGIN_DATE}',ORDER_PRINT='{$ORDER_PRINT}',REMARK='{$REMARK}' where ORDER_ID='{$ORDER_ID}'";
exequery( $connection, $query );
save_field_data( "SUPPLY_ORDER", $ORDER_ID, $_POST );
}
if ( $LINE_ID == "" )
{
$query = "INSERT into ORDER_LINE (ORDER_ID,PRODUCT_ID,TRANS_PRICE,TRANS_QTY,MEMO)\r\n values('".$ORDER_ID."','{$PRO_ID}','{$PRICE}','{$TRANS_QTY}','{$MEMO}')";
exequery( $connection, $query );
$LINE_ID = mysql_insert_id( );
$query = "INSERT into SUPPLY_HISTORY (PROVIDER_ID,PRODUCT_ID,DATE,AMT,PRICE,SALESMAN,ORDER_ID,LINE_ID,MEMO)\r\n values('".$PROVIDER_ID."','{$PRO_ID}','{$CREATE_DATE}','{$TRANS_QTY}','{$PRICE}','{$LOGIN_USER_ID}','{$ORDER_ID}','{$LINE_ID}','{$MEMO}')";
exequery( $connection, $query );
$query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='".$ORDER_ID."' and LINE_ID!='{$LINE_ID}'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINE_ID = $ROW['LINE_ID'];
$PRICE = $LINE_ID."PRICE";
$TRANS_QTY = $LINE_ID."TRANS_QTY";
$MEMO = $LINE_ID."MEMO";
$PRICE = $$PRICE;
$TRANS_QTY = $$TRANS_QTY;
$MEMO = $$MEMO;
$query = "update ORDER_LINE set TRANS_PRICE='".$PRICE."',TRANS_QTY='{$TRANS_QTY}',MEMO='{$MEMO}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
$query = "update SUPPLY_HISTORY set DATE='".$CREATE_DATE."',AMT='{$TRANS_QTY}',PRICE='{$PRICE}',SALESMAN='{$LOGIN_USER_ID}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
}
}
else
{
$query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='".$ORDER_ID."' ";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINE_ID = $ROW['LINE_ID'];
$PRICE = $LINE_ID."PRICE";
$TRANS_QTY = $LINE_ID."TRANS_QTY";
$MEMO = $LINE_ID."MEMO";
$PRICE = $$PRICE;
$TRANS_QTY = $$TRANS_QTY;
$MEMO = $$MEMO;
$query = "update ORDER_LINE set TRANS_PRICE='".$PRICE."',TRANS_QTY='{$TRANS_QTY}',MEMO='{$MEMO}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
$query = "update SUPPLY_HISTORY set DATE='".$CREATE_DATE."',AMT='{$TRANS_QTY}',PRICE='{$PRICE}',SALESMAN='{$LOGIN_USER_ID}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
}
}
echo "<script>\r\nlocation=\"index.php?ORDER_ID=";
echo $ORDER_ID;
echo "\";\r\n</script>\r\n";
}
else
{
if ( $ORDER_ID == "" )
{
$query = "INSERT into SUPPLY_ORDER (ORDER_NO,ORDER_NAME,ORDER_TYPE,ORDER_MEMO,PROVIDER_ID,LINKMAN_ID,CREATOR,RECIVER,CREATE_DATE,BEGIN_DATE,ORDER_PRINT,REMARK) values\r\n ('".$ORDER_NO."','{$ORDER_NAME}','{$ORDER_TYPE}','{$ORDER_MEMO}','{$PROVIDER_ID}','{$LINKMAN_ID}','{$CREATOR}','{$TO_ID}','{$CREATE_DATE}','{$BEGIN_DATE}','{$ORDER_PRINT}','{$REMARK}')";
exequery( $connection, $query );
$ORDER_ID = mysql_insert_id( );
save_field_data( "SUPPLY_ORDER", $ORDER_ID, $_POST );
}
else
{
$query = "update SUPPLY_ORDER set ORDER_NO='".$ORDER_NO."',ORDER_NAME='{$ORDER_NAME}',ORDER_TYPE='{$ORDER_TYPE}',ORDER_MEMO='{$ORDER_MEMO}',PROVIDER_ID='{$PROVIDER_ID}',LINKMAN_ID='{$LINKMAN_ID}',CREATOR='{$CREATOR}',RECIVER='{$TO_ID}',CREATE_DATE='{$CREATE_DATE}',BEGIN_DATE='{$BEGIN_DATE}',ORDER_PRINT='{$ORDER_PRINT}',REMARK='{$REMARK}' where ORDER_ID='{$ORDER_ID}'";
exequery( $connection, $query );
save_field_data( "SUPPLY_ORDER", $ORDER_ID, $_POST );
}
$query = "SELECT LINE_ID from ORDER_LINE where ORDER_ID='".$ORDER_ID."' ";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINE_ID = $ROW['LINE_ID'];
$PRICE = $LINE_ID."PRICE";
$TRANS_QTY = $LINE_ID."TRANS_QTY";
$MEMO = $LINE_ID."MEMO";
$PRICE = $$PRICE;
$TRANS_QTY = $$TRANS_QTY;
$MEMO = $$MEMO;
$query = "update ORDER_LINE set TRANS_PRICE='".$PRICE."',TRANS_QTY='{$TRANS_QTY}',MEMO='{$MEMO}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
$query = "update SUPPLY_HISTORY set DATE='".$CREATE_DATE."',AMT='{$TRANS_QTY}',PRICE='{$PRICE}',SALESMAN='{$LOGIN_USER_ID}' where LINE_ID='{$LINE_ID}'";
exequery( $connection, $query );
}
message( "提示", " ".$ORDER_NAME." 添加成功！！" );
}
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"转至订单管理页面\" class=\"BigButton\" onClick=\"location='../manage/index.php'\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -