📄 detail.php
字号:
<?php
include_once( "inc/auth.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\r\n</head>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from SALE_HISTORY where HISTORY_ID={$HISTORY_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$HISTORY_ID = $ROW['HISTORY_ID'];
$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
$PRODUCT_ID1 = $ROW['PRODUCT_ID'];
$DATE1 = $ROW['DATE'];
$AMT1 = $ROW['AMT'];
$PRICE1 = $ROW['PRICE'];
$DISCOUNT1 = $ROW['DISCOUNT'];
$SALESMAN1 = $ROW['SALESMAN'];
$MEMO1 = $ROW['MEMO'];
$query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID={$CUSTOMER_ID1}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
}
$query = "SELECT PRODUCT_NAME,PRODUCT_TYPE from PRODUCT where PRODUCT_ID={$PRODUCT_ID1}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRODUCT_NAME = $ROW['PRODUCT_NAME'];
$PRODUCT_TYPE = $ROW['PRODUCT_TYPE'];
if ( $PRODUCT_TYPE != "" )
{
$PRODUCT_NAME_TYPE = $PRODUCT_NAME.$PRODUCT_TYPE;
}
else
{
$PRODUCT_NAME_TYPE = $PRODUCT_NAME;
}
}
$CUSTOMER_NAME = str_replace( "<", "<", $CUSTOMER_NAME );
$CUSTOMER_NAME = str_replace( ">", ">", $CUSTOMER_NAME );
$CUSTOMER_NAME = stripslashes( $CUSTOMER_NAME );
$PRODUCT_NAME_TYPE = str_replace( "<", "<", $PRODUCT_NAME_TYPE );
$PRODUCT_NAME_TYPE = str_replace( ">", ">", $PRODUCT_NAME_TYPE );
$PRODUCT_NAME_TYPE = stripslashes( $PRODUCT_NAME_TYPE );
$DATE1 = str_replace( "<", "<", $DATE1 );
$DATE1 = str_replace( ">", ">", $DATE1 );
$DATE1 = stripslashes( $DATE1 );
$AMT1 = str_replace( "<", "<", $AMT1 );
$AMT1 = str_replace( ">", ">", $AMT1 );
$AMT1 = stripslashes( $AMT1 );
$PRICE1 = str_replace( "<", "<", $PRICE1 );
$PRICE1 = str_replace( ">", ">", $PRICE1 );
$PRICE1 = stripslashes( $PRICE1 );
$DISCOUNT1 = str_replace( "<", "<", $DISCOUNT1 );
$DISCOUNT1 = str_replace( ">", ">", $DISCOUNT1 );
$DISCOUNT1 = stripslashes( $DISCOUNT1 );
$SALESMAN1 = str_replace( "<", "<", $SALESMAN1 );
$SALESMAN1 = str_replace( ">", ">", $SALESMAN1 );
$SALESMAN1 = stripslashes( $SALESMAN1 );
$MEMO1 = str_replace( "<", "<", $MEMO1 );
$MEMO1 = str_replace( ">", ">", $MEMO1 );
$MEMO1 = stripslashes( $MEMO1 );
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 销售记录详细信息</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"450\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <form name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\">客户： </td>\r\n <td class=\"TableData\">\r\n ";
echo $CUSTOMER_NAME;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">产品： </td>\r\n <td class=\"TableData\">\r\n ";
echo $PRODUCT_NAME_TYPE;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">销售日期： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $DATE1;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">数量：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $AMT1;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">价格：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $PRICE1;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">折扣：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $DISCOUNT1;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">销售员：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $SALESMAN1;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">备注： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $MEMO1;
echo " \r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\">\r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -