default.php

来自「CRM 不仅仅是一个管理名词和管理概念」· PHP 代码 · 共 110 行

<?
	########################################
	#OsoonCrm
	#首页
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";

	$where_account = " where AccountOwnerID='$G_uid' ";
	$where_account_share = " where Shared='1' ";

	$where_contact = " where AddID='$G_uid' ";

	$where_project = " where CreateID='$G_uid' ";
	$where_project_suss = " where CreateID='$G_uid' AND Successful='1' ";
	$where_project_fail = " where CreateID='$G_uid' AND Successful='0' ";

	$sql_count_a = "select count(*) from $tbl_crm_account $where_account";
	$res_count_a = mysql_query($sql_count_a);
	$row_count_a = @mysql_fetch_array($res_count_a);

	$sql_count_a_share = "select count(*) from $tbl_crm_account $where_account_share";
	$res_count_a_share = mysql_query($sql_count_a_share);
	$row_count_a_share = @mysql_fetch_array($res_count_a_share);

	$sql_count_c = "select count(*) from $tbl_crm_contact $where_contact";
	$res_count_c = mysql_query($sql_count_c);
	$row_count_c = @mysql_fetch_array($res_count_c);

	$sql_count_p = "select count(*) from $tbl_crm_project $where_project";
	$res_count_p = mysql_query($sql_count_p);
	$row_count_p = @mysql_fetch_array($res_count_p);

	$sql_count_p_suss = "select count(*) from $tbl_crm_project $where_project_suss";
	$res_count_p_suss = mysql_query($sql_count_p_suss);
	$row_count_p_suss = @mysql_fetch_array($res_count_p_suss);

	$sql_count_p_fail = "select count(*) from $tbl_crm_project $where_project_fail";
	$res_count_p_fail = mysql_query($sql_count_p_fail);
	$row_count_p_fail = @mysql_fetch_array($res_count_p_fail);

	$sql_count_act="select count(*) from $tbl_crm_activity where ActivityExecuteID='$G_uid'";
	$res_count_act=mysql_query($sql_count_act);
	$row_count_act=@mysql_fetch_array($res_count_act);
?> 
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
  <tr valign=top> 
    <td width="201"> 
      <? include "include/left.inc.php"; ?>
    </td>
    <td> 
      <br>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#FFFFFF" bordercolor="#F7F2EA">
        <tr bgcolor="#ede5d2" bordercolor="#ede5d2"> 
          <td colspan="2"><b>统计信息</b></td>
        </tr>
        <tr> 
          <td width="21%"><a href="account_list.php">客户</a></td>
          <td width="79%">共享客户 <b><? echo $row_count_a_share[0] ?></b> 私有客户 <b><? echo $row_count_a[0] ?></b></td>
        </tr>
        <tr> 
          <td width="21%"><a href="contact_list.php">联系人</a></td>
          <td width="79%"><b><? echo $row_count_c[0] ?></b></td>
        </tr>
        <tr> 
          <td width="21%"><a href="project_list.php">项目</a></td>
          <td width="79%"><b><? echo $row_count_p[0] ?></b> (成功项目 <b><? echo $row_count_p_suss[0] ?></b> 失败项目 <b><? echo $row_count_p_fail[0] ?></b> )</td>
        </tr>
        <tr>
          <td width="21%">行动</td>
          <td width="79%"><b><? echo $row_count_act[0] ?></b> &nbsp;</td>
        </tr>
        <tr>
          <td width="21%">费用</td>
          <td width="79%">&nbsp;</td>
        </tr>
      </table>
      <br>
      <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#FFFFFF" bordercolor="#F7F2EA">
        <tr bordercolor="#ede5d2"> 
          <td colspan="2" bgcolor="#ede5d2"><b>快速操作</b></td>
        </tr>
        <tr> 
          <td width="21%">客户</td>
          <td width="79%"><a href="account_add.php">新建客户</a> <a href="account_list.php">浏览客户</a></td>
        </tr>
        <tr> 
          <td width="21%">联系人</td>
          <td width="79%"><a href="contact_add.php">新建联系人</a> <a href="contact_list.php">浏览联系人</a></td>
        </tr>
        <tr> 
          <td width="21%">项目</td>
          <td width="79%"><a href="project_add.php">新建项目</a> <a href="project_list.php">浏览项目</a></td>
        </tr>
        <tr> 
          <td width="21%">行动</td>
          <td width="79%"><a href="activity_add.php">新建行动</a> <a href="activity_list.php">浏览行动</a></td>
        </tr>
        <tr> 
          <td width="21%">费用</td>
          <td width="79%"><? if ($G_username=="expense") { ?><a href="expense_add.php">新建费用</a><? } ?> <a href="expense_list.php">浏览费用</a></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<? include "include/footer.inc.php"; ?>