📄 showdetail.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\" topmargin=\"5\">\r\n";
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$MANAGER_ID = $ROW['MANAGER_ID'];
$MANAGERS = $ROW['MANAGERS'];
}
$query = "SELECT * from SALE_CHANCE where CHANCE_ID=".$CHANCE_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CHANCE_NAME0 = $ROW['CHANCE_NAME'];
$CUSTOMER_ID0 = $ROW['CUSTOMER_ID'];
$CHANCE_RANK = $ROW['CHANCE_RANK'];
$CHANCE_STATUS = $ROW['CHANCE_STATUS'];
$BARGAIN_DATE = $ROW['BARGAIN_DATE'];
$BARGAIN_MONEY = $ROW['BARGAIN_MONEY'];
$DESC = $ROW['DESC'];
$SELLER = $ROW['SELLER'];
$FINISH = $ROW['FINISH'];
$ACHIEVE = $ROW['ACHIEVE'];
$REMARK = $ROW['REMARK'];
$SELLER_NAME = "";
$query1 = "SELECT * from USER where USER_ID='".$SELLER."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SELLER_NAME = $ROW['USER_NAME'];
}
$CUSTOMER_NAME = "";
$query1 = "SELECT * from CUSTOMER where CUSTOMER_ID='".$CUSTOMER_ID0."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
}
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/customerdetail.gif\" align=\"absmiddle\"> <span class=\"big3\">销售机会信息查看</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"500\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <TR>\r\n <TD class=\"TableData\" width=10%>机会主题:</TD>\r\n <TD class=\"TableData\">";
echo $CHANCE_NAME0;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">客户单位:</TD>\r\n <TD class=\"TableData\">";
echo $CUSTOMER_NAME;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">机会等级:</TD>\r\n <TD class=\"TableData\">\r\n ";
echo get_code_name( $CHANCE_RANK, "CHANCE_RANK" );
echo " </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">机会状态:</TD>\r\n <TD class=\"TableData\">\r\n ";
echo get_code_name( $CHANCE_STATUS, "CHANCE_STATUS" );
echo " </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">预计成交时间:</TD>\r\n <TD class=\"TableData\">";
echo $BARGAIN_DATE;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">预计成交金额:</TD>\r\n <TD class=\"TableData\">";
echo $BARGAIN_MONEY;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">业务员:</TD>\r\n <TD class=\"TableData\">";
echo $SELLER_NAME;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">完成度:</TD>\r\n <TD class=\"TableData\">";
echo $FINISH;
echo " %</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">达成率:</TD>\r\n <TD class=\"TableData\">";
echo $ACHIEVE;
echo " %</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">机会描述:</TD>\r\n <TD class=\"TableData\">";
echo $DESC;
echo "</TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">备注:</TD>\r\n <TD class=\"TableData\">";
echo $REMARK;
echo "</TD>\r\n </TR>\r\n</table>\r\n<br>\r\n<div align=center>\r\n <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -