report_project.php

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

<?
	########################################
	#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 (!$jieduan) $jieduan = 1;
?>
<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="0" cellspacing="0" cellpadding="0" height=25>
        <tr align="right"> 
          <td>
          	<a href="report_project.php">项目报表</a>
          	|
          	<a href="report_month.php">月 报 表</a>
          </td>
        </tr>
      </table>
      <hr>
      <table width="95%" border="0" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ede5d2" bordercolordark="#ffffff" bgcolor="#FFFFFF">
        <tr align=right> 
          <td align=left>
<?
	while (list($key, $val) = each($array_crm_jieduan))
	{
		if ($jieduan==$key)
			echo " <a href=\"report_project.php?jieduan=$key\" style=\"color:red\">$val</a> &nbsp;&nbsp; ";
		else
			echo " <a href=\"report_project.php?jieduan=$key\">$val</a> &nbsp;&nbsp; ";
	}
?>
          </td>
        </tr>
      </table>
      <table width="95%" border="0" cellspacing="1" cellpadding="3" align="center" bordercolorlight="#ede5d2" bordercolordark="#ffffff" bgcolor="#cccccc">
        <tr bgcolor="#ede5d2" align=right> 
          <td width="40" align=center rowspan=2><b>序号</b></td>
          <td align=left rowspan=2><b>项目编号</b></td>
          <td rowspan=2 align=left><b>项目名称</b></td>
          <td colspan=7 align=center><b>项目费用</b></td>
          <td rowspan=2 width=50><b>合 计</b></td>
        </tr>
        <tr bgcolor="#ede5d2" align=right> 
<?
	for ($i=1; $i<=7; $i++) {
		echo "<td><b>$array_crm_expense_name[$i]</b></td>";
	}
?>
        </tr>
<?
	// 选定的项目列表
	$sql = "select * from $tbl_crm_project where JieDuan='$jieduan'";
	$res = mysql_query($sql);
	$list_pid = "";
	while ($row=@mysql_fetch_array($res))
	{
		$list_pid .= $row[ProjectID].",";
		$array_project[$row[ProjectID]][sn] = $row[ProjectSN];
		$array_project[$row[ProjectID]][name] = $row[ProjectName];
	}
	$list_pid = substr($list_pid, 0, -1);
	
	// 有费用的项目
	$sql = "select distinct ProjectID from $tbl_crm_expense where ProjectID in ($list_pid)";
	$res = mysql_query($sql);
	$i = 0;
	while ($row=@mysql_fetch_array($res))
	{
		$i++;
		$projectid = $row[0];

		$exp1 = 0;
		$exp2 = 0;
		$exp3 = 0;
		$exp4 = 0;
		$exp5 = 0;
		$exp6 = 0;
		$exp7 = 0;
		$exp_heji = 0;

		$sql2 = "select * from $tbl_crm_expense where ProjectID='$projectid'";
		$res2 = mysql_query($sql2);
		while ($row2=@mysql_fetch_array($res2)) {
			switch ($row2[ProjectExpenseName]) {
				case 1:
					$exp1 += $row2[RealExpense];
					break;
				case 2:
					$exp2 += $row2[RealExpense];
					break;
				case 3:
					$exp3 += $row2[RealExpense];
					break;
				case 4:
					$exp4 += $row2[RealExpense];
					break;
				case 5:
					$exp5 += $row2[RealExpense];
					break;
				case 6:
					$exp6 += $row2[RealExpense];
					break;
				case 7:
					$exp7 += $row2[RealExpense];
					break;
				default:// >8
					$exp7 += $row2[RealExpense];
					break;
			}
			//if ($row2[ProjectExpenseName] < 8) $exp_heji += $row2[RealExpense];
			$exp_heji += $row2[RealExpense];
		}
?>
        <tr bgcolor="#ede5d2" align=right>
          <td align=center><? echo $i ?>&nbsp;</td>
          <td align=left><? echo $array_project[$projectid][sn] ?>&nbsp;</td>
          <td align=left><a href="report_project_view.php?pid=<? echo $projectid ?>" style="color:blue"><? echo $array_project[$projectid][name] ?></a>&nbsp;</td>
          <td><? echo $exp1 ?>&nbsp;</td>
          <td><? echo $exp2 ?>&nbsp;</td>
          <td><? echo $exp3 ?>&nbsp;</td>
          <td><? echo $exp4 ?>&nbsp;</td>
          <td><? echo $exp5 ?>&nbsp;</td>
          <td><? echo $exp6 ?>&nbsp;</td>
          <td><? echo $exp7 ?>&nbsp;</td>
          <td><? echo $exp_heji ?>&nbsp;</td>
        </tr>
<?
	}
?>
      </table>
      <p></p>
    </td>
  </tr>
</table>
<? include "include/footer.inc.php"; ?>