report_project_view.php

CRM 不仅仅是一个管理名词和管理概念

<?
	########################################
	#OsoonCrm
	#费用列表
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";
	include "include/array.inc.php";
	include "include/priv.report.inc.php";
?>
<?	
	if (!$pid) { echo "没有项目！";exit; }
	// 项目信息
	$sql = "select * from $tbl_crm_project where ProjectID='$pid'";
	$res = mysql_query($sql);
	$row = @mysql_fetch_array($res);
?>
<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>
      <table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ede5d2" bordercolordark="#ffffff">
        <tr bgcolor="#ffffff"> 
          <td colspan=12>
          	报表名：项目详细报表
          	<br>
          	客户名：<? echo $array_crm_id2account[$row[AccountID]]; ?>
          	<br>
          	项目名：<? echo $row[ProjectName]; ?>
          </td>
        </tr>

        <tr bgcolor="#ede5d2"> 
          <td align=center width=40>序 号</td>
          <td>报销时间</td>
          <td>报销人</td>
          <td>报销部门</td>
          <td>费用类别</td>
          <td>费用名</td>
          <td align=right>费用额(元)</td>
        </tr>
<?
	$sql="select * from $tbl_crm_expense where ProjectID='$pid'";
	$res=mysql_query($sql);
	$i = 0;
	$exp_total = 0;
	while ($row=@mysql_fetch_array($res)) {
		$i++;
		$exp_total += $row[RealExpense];
?>
        <tr> 
          <td align=center><? echo $i ?></td>
          <td><? echo $row[UseTime] ?>&nbsp;</td>
          <td><? echo $array_crm_id2user[$row[UserID]]; ?>&nbsp;</td>
          <td><? echo $array_crm_id2dept[$row[DeptID]]; ?>&nbsp;</td>
          <td><? echo $array_crm_expense_name[$row[ProjectExpenseName]] ?>&nbsp;</td>
          <td><? echo $row[ExpenseName] ?>&nbsp;</td>
          <td align=right><? echo $row[RealExpense] ?>&nbsp;</td>
        </tr>
<?
	}
?>
        <tr align=center> 
          <td>合 计</td>
          <td colspan=6 align=right><? echo $exp_total ?></td>
        </tr>
      </table>
      <p></p>
    </td>
  </tr>
</table>
<? include "include/footer.inc.php"; ?>