📄 update.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
echo "\r\n<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 ( $DATE != "" && $DATE != "0000-00-00" )
{
	$TIME_OK = is_date( $DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "日期格式不对，应形如 1999-1-2" );
		echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='edit.php?CUSTOMER_ID=";
		echo $CUSTOMER_ID;
		echo "&PRODUCT_ID=";
		echo $PRODUCT_ID;
		echo "&PROVIDER_ID=";
		echo $PROVIDER_ID;
		echo "&DATE=";
		echo $DATE;
		echo "&AMT=";
		echo $AMT;
		echo "&PRICE=";
		echo $PRICE;
		echo "&DISCOUNT=";
		echo $DISCOUNT;
		echo "&SALESMAN=";
		echo $SALESMAN;
		echo "&MEMO=";
		echo $MEMO;
		echo "'\">\r\n</div>\r\n\r\n";
		exit( );
	}
}
if ( $AMT != "" )
{
	$TIME_OK = is_number( $AMT );
	if ( !$TIME_OK )
	{
		message( "错误", "数量错误" );
		echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?CUSTOMER_ID=";
		echo $CUSTOMER_ID;
		echo "&PRODUCT_ID=";
		echo $PRODUCT_ID;
		echo "&PROVIDER_ID=";
		echo $PROVIDER_ID;
		echo "&DATE=";
		echo $DATE;
		echo "&AMT=";
		echo $AMT;
		echo "&PRICE=";
		echo $PRICE;
		echo "&DISCOUNT=";
		echo $DISCOUNT;
		echo "&SALESMAN=";
		echo $SALESMAN;
		echo "&MEMO=";
		echo $MEMO;
		echo "'\">\r\n</div>\r\n\r\n";
		exit( );
	}
}
$connection = openconnection( );
$query = "update SALE_HISTORY set CUSTOMER_ID='{$CUSTOMER_ID}',PRODUCT_ID='{$PRODUCT_ID}',DATE='{$DATE}',AMT={$AMT},PRICE='{$PRICE}',DISCOUNT='{$DISCOUNT}',SALESMAN='{$SALESMAN}',MEMO='{$MEMO}',SALE_HISTORY_CREATE_USER='".$_SESSION['LOGIN_USER_ID']."' where HISTORY_ID='{$HISTORY_ID}'";
exequery( $connection, $query );
if ( $_REQUEST['edt_r'] == "index_r" )
{
	header( "location:index.php?cur_page=".$_REQUEST['cur_page']."&sens=".$_REQUEST['sens']."&order=".$_REQUEST['order']."" );
}
if ( $_REQUEST['edt_r'] == "list_r" )
{
	header( "location: list.php?cur_page=".$_REQUEST['cur_page']."&sens=".$_REQUEST['sens']."&order=".$_REQUEST['order']."&CUSTOMER_NAME=".$_REQUEST['list_CUSTOMER_NAME']."&PRODUCT_ID=".$_REQUEST['list_PRODUCT_ID']."&DATE=".$_REQUEST['list_DATE']."&DATE2=".$_REQUEST['list_DATE2']."&AMT=".$_REQUEST['list_AMT']."&AMT2=".$_REQUEST['list_AMT2']."&PRICE=".$_REQUEST['list_PRICE']."&PRICE2=".$_REQUEST['list_PRICE2']."&DISCOUNT=".$_REQUEST['list_DISCOUNT']."&DISCOUNT2=".$_REQUEST['list_DISCOUNT2']."&SALESMAN=".$_REQUEST['list_SALESMAN']."&MEMO=".$_REQUEST['list_MEMO']."" );
}
echo "</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -