📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.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\r\n<body class=\"bodycolor\">\r\n";
if ( $PRO_CONTENT != "" )
{
$PRO_CONTENT = str_replace( "'", "\\'", $PRO_CONTENT );
$PRO_CONTENT = str_replace( "\"", "\\'", $PRO_CONTENT );
$MY_ARRAY = explode( "\r\n", $PRO_CONTENT );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$MY_ARRAY1 = explode( "`", $MY_ARRAY[$I] );
$TOTAL_PRICE = $MY_ARRAY1[2] * $MY_ARRAY1[3];
$query = "INSERT into SALE_HISTORY(`CUSTOMER_ID`,`PRODUCT_ID`,`SERVICE_ID`,`HISTORY_CODE`,`TYPE`,`DATE`,`AMT`,`PRICE`,`TOTAL_PRICE`,`SALESMAN`,`DISCOUNT`,`CONTRACT_ID`,`LINE_ID`,`MEMO`,`MEMO1`,CREATOR)values\r\n('".$CUSTOMER_ID."', '{$MY_ARRAY1['1']}','','{$HISTORY_CODE}','PRO','{$CREATE_DATE}','{$MY_ARRAY1['3']}','{$MY_ARRAY1['2']}','{$TOTAL_PRICE}','{$TO_ID}','{$DISCOUNT}','{$CONTRACT_ID}','{$LINE_ID}','{$MEMO}','{$MEMO1}','{$CREATOR}')";
exequery( $connection, $query );
}
}
if ( $SER_CONTENT != "" )
{
$SER_CONTENT = str_replace( "'", "\\'", $SER_CONTENT );
$SER_CONTENT = str_replace( "\"", "\\'", $SER_CONTENT );
$MY_ARRAY = explode( "\r\n", $SER_CONTENT );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$MY_ARRAY1 = explode( "`", $MY_ARRAY[$I] );
$query = "INSERT into SALE_HISTORY(`CUSTOMER_ID`,`PRODUCT_ID`,`SERVICE_ID`,`HISTORY_CODE`,`TYPE`,`DATE`,`AMT`,`PRICE`,`TOTAL_PRICE`,`SALESMAN`,`DISCOUNT`,`CONTRACT_ID`,`LINE_ID`,`MEMO`,`MEMO1`,CREATOR)values\r\n ('".$CUSTOMER_ID."', '','{$MY_ARRAY1['1']}','{$HISTORY_CODE}','SER','{$CREATE_DATE}','0','0','{$MY_ARRAY1['2']}','{$TO_ID}','{$DISCOUNT}','{$CONTRACT_ID}','{$LINE_ID}','{$MEMO}','{$MEMO1}','{$CREATOR}')";
exequery( $connection, $query );
}
}
header( "location: index.php" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -