📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>销售机会信息查看</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$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"];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/customerdetail.gif" align="absmiddle"> <span class="big3">销售机会信息查看</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="500" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<TR>
<TD class="TableData" width=10%>机会主题：</TD>
<TD class="TableData"><?=$CHANCE_NAME0?></TD>
</TR>
<TR>
<TD nowrap class="TableData">客户单位：</TD>
<TD class="TableData"><?=$CUSTOMER_NAME?></TD>
</TR>
<TR>
<TD nowrap class="TableData">机会等级：</TD>
<TD class="TableData">
<?=get_code_name($CHANCE_RANK,"CHANCE_RANK")?>
</TD>
</TR>
<TR>
<TD nowrap class="TableData">机会状态：</TD>
<TD class="TableData">
<?=get_code_name($CHANCE_STATUS,"CHANCE_STATUS")?>
</TR>
<TR>
<TD nowrap class="TableData">预计成交时间：</TD>
<TD class="TableData"><?=$BARGAIN_DATE?></TD>
</TR>
<TR>
<TD nowrap class="TableData">预计成交金额：</TD>
<TD class="TableData"><?=$BARGAIN_MONEY?></TD>
</TR>
<TR>
<TD nowrap class="TableData">业务员：</TD>
<TD class="TableData"><?=$SELLER_NAME?></TD>
</TR>
<TR>
<TD class="TableData">完成度：</TD>
<TD class="TableData"><?=$FINISH?> %</TD>
</TR>
<TR>
<TD nowrap class="TableData">达成率：</TD>
<TD class="TableData"><?=$ACHIEVE?> %</TD>
</TR>
<TR>
<TD nowrap class="TableData">机会描述：</TD>
<TD class="TableData"><?=$DESC?></TD>
</TR>
<TR>
<TD nowrap class="TableData">备注：</TD>
<TD class="TableData"><?=$REMARK?></TD>
</TR>
</table>
<br>
<div align=center>
<input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -