project_view.php
来自「CRM 不仅仅是一个管理名词和管理概念」· PHP 代码 · 共 209 行
PHP
209 行
<?
########################################
#OsoonCrm
#项目详细信息
########################################
include "include/db.inc.php";
include "include/check.inc.php";
include "include/header.inc.php";
include "include/array.inc.php";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
<tr valign=top>
<td width="201">
<? include "include/left.inc.php"; ?>
</td>
<td align=center>
<br>
<?
// 项目详细信息
$sql="select * from $tbl_crm_project where ProjectID='$pid'";
$sql.=" and $where_account_view ";// 添加检查
$res=mysql_query($sql);
$row=@mysql_fetch_array($res);
$aid = $row[AccountID];
$cid = $row[ContactID];
// 客户信息
$sql="select * from $tbl_crm_account where AccountID='$aid'";
$res=mysql_query($sql);
$row_a=@mysql_fetch_array($res);
$AccountOwnerID = $row_a[AccountOwnerID];// 客户所有人的ID
// 项目联系人信息
$sql="select * from $tbl_crm_contact where ContactID='$cid'";
$res=mysql_query($sql);
$row_c=@mysql_fetch_array($res);
?>
<?
// 功能按钮
$btn_edit_1 = " <input type=button value=\"编辑\" style=\"width:60\" onclick=\"javascript:document.location='project_edit.php?pid=$pid'\"> ";
$btn_edit_0 = " <input type=button value=\"编辑\" style=\"width:60\" disabled> ";
$btn_copy_1 = " <input type=button value=\"复制\" style=\"width:60\" onclick=\"javascript:document.location='project_add.php?pid=$pid'\"> ";
$btn_copy_0 = " <input type=button value=\"复制\" style=\"width:60\" disabled> ";
$btn_delete_1 = " <input type=button value=\"删除\" style=\"width:60\" onclick=\"javascript:cfmop('project_man.php?action=delete&pid=$pid','注意：是否真的删除这个项目？');\"> ";
$btn_delete_0 = " <input type=button value=\"删除\" style=\"width:60\" disabled> ";
$btn_closed_gb = " <input type=button value=\"关闭\" style=\"width:60\" onclick=\"javascript:document.location='project_close.php?pid=$pid'\"> ";
$btn_closed_jh = " <input type=button value=\"激活\" style=\"width:60\" onclick=\"javascript:cfmop('project_man.php?action=jihuo&pid=$pid','注意：是否真的激活这个项目？');\"> ";
$btn_list = " <input type=button value=\"返回列表\" style=\"width:60\" onclick=\"javascript:document.location='project_list.php'\"> ";
// 项目是否已经关闭
if ($row[Closed])
{
$btn_display = $btn_edit_0.$btn_copy_1.$btn_delete_1.$btn_closed_jh.$btn_list;
}
else
{
$btn_display = $btn_edit_1.$btn_copy_1.$btn_delete_1.$btn_closed_gb.$btn_list;
}
// 如果不是自己的项目
if ($AccountOwnerID != $G_uid)
{
$btn_display = $btn_edit_0.$btn_copy_0.$btn_delete_0.$btn_list;
}
?>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td><b>项目详细信息</b></td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td width="50%">
<A HREF="project_view.php?pid=<? echo $pid; ?>">详细信息 - 普通</A> |
<A HREF="project_adview.php?pid=<? echo $pid; ?>">详细信息 - 高级</A>
</td>
<td width="50%" align=right>
<? echo $btn_display; ?>
</td>
</tr>
</table>
<hr width=95% align=center>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"><b>基本信息</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#ede5d2">
<tr>
<td width="25%">项目名</td>
<td width="25%"><? echo $row[ProjectName]; ?> </td>
<td width="25%">销售额(元)</td>
<td width="25%"><? echo $row[ProjectSale]; ?> </td>
</tr>
<tr>
<td width="25%">项目编号 </td>
<td width="25%"><? echo $row[ProjectSN]; ?> </td>
<td width="25%">可能性(%)</td>
<td width="25%"><? echo $row[Possibility]; ?> </td>
</tr>
<tr>
<td width="25%">项目阶段</td>
<td width="25%"><? echo $array_crm_jieduan[$row[JieDuan]]; ?> </td>
<td width="25%">项目状态</td>
<td width="25%"><? echo $array_crm_project_state[$row[ProjectState]]; ?> </td>
</tr>
<tr>
<td width="25%">项目来源</td>
<td width="25%"><? echo $array_crm_source[$row[ProjectSource]]; ?> </td>
<td width="25%">项目确立时间</td>
<td width="25%"><? echo $row[BeginTime]; ?> </td>
</tr>
<tr>
<td width="25%">项目结果</td>
<td width="25%">
<input id="successful_1" type="radio" name="Successful" value="1" disabled <? if ($row[Successful]=="1") echo "checked" ?>>
<label for="successful_1" disabled>成功</label>
<input id="successful_0" type="radio" name="Successful" value="0" disabled <? if ($row[Successful]=="0") echo "checked" ?>>
<label for="successful_0" disabled>失败</label>
</td>
<td width="25%">预计结束时间</td>
<td width="25%"><? echo $row[EndTime]; ?> </td>
</tr>
<tr>
<td width="25%">关 闭</td>
<td width="25%"><? if ($row[Closed]) echo $array_crm_id2user[$row[CloseID]]; ?> </td>
<td width="25%">项目关闭时间</td>
<td width="25%"><? echo $row[CloseTime]; ?> </td>
</tr>
<tr>
<td width="25%">项目简介</td>
<td colspan=3><textarea name="ProjectContent" style="height:40px;width:400px;" readonly><? echo $row[ProjectContent]; ?></textarea></td>
</tr>
</table>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"> <b>项目联系人</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#ede5d2">
<tr>
<td width="25%">联系人姓名</td>
<td width="25%"><? echo $row_c[ContactName]; ?> </td>
<td width="25%">称谓</td>
<td width="25%"><? echo $row_c[ChenWei]; ?> </td>
</tr>
<tr>
<td width="25%">公司电话</td>
<td width="25%"><? echo $row_c[OfficeTel]; ?> </td>
<td width="25%">手机号码</td>
<td width="25%"><? echo $row_c[Mobile]; ?> </td>
</tr>
</table>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"> <b>所属客户</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#ede5d2">
<tr>
<td width="25%">客户名称</td>
<td width="25%"><? echo $row_a[AccountName]; ?> </td>
<td width="25%">电话</td>
<td width="25%"><? echo $row_a[Tel]; ?> </td>
</tr>
<tr>
<td width="25%">类型</td>
<td width="25%"><? echo $array_crm_account_type[$row_a[AccountType]]; ?> </td>
<td width="25%">网站</td>
<td width="25%"><? echo $row_a[WebSite]; ?> </td>
</tr>
<tr>
<td width="25%">行业</td>
<td colspan="3"><? echo $array_crm_account_industry[$row_a[AccountIndustry]]; ?> </td>
</tr>
<tr>
<td width="25%">地址</td>
<td colspan="3"><? echo $row_a[Address]; ?> </td>
</tr>
</table>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
<tr>
<td colspan="2"> <b>创建者/修改者</b></td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#ede5d2">
<tr>
<td width="25%" height="21">创建者</td>
<td width="25%" height="21"><? echo $array_crm_id2user[$row[CreateID]]; ?> </td>
<td width="25%" height="21">修改者</td>
<td width="25%" height="21"><? echo $array_crm_id2user[$row[ModifyID]]; ?> </td>
</tr>
<tr>
<td width="25%">创建时间</td>
<td width="25%"><? echo $row[CreateTime]; ?> </td>
<td width="25%">修改时间</td>
<td width="25%"><? echo $row[ModifyTime]; ?> </td>
</tr>
</table>
<p></p>
</td>
</tr>
</table>
<? include "include/footer.inc.php"; ?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?