report_user.php

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

<?
	########################################
	#OsoonCrm
	#费用列表
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/header.inc.php";
	include "include/array.inc.php";
	//if ($departmentid!=1) { echo "对不起，你无权查看报表！";exit; }
	include "include/priv.report.inc.php";
?>
<?	
	if (!$id) { echo "没有用户！";exit; }
	// 默认显示当前月报表
	if (!$year) $year = date("Y");
	if (!$month) $month = date("n");
?>
<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="3" align="center" bordercolorlight="#ede5d2" bordercolordark="#ffffff">
        <form name="form1" method="post" action="">
          <tr align=right> 
            <td> 报表月份：
              <input type="text" name="year" size="5" maxlength="4" value="<? echo $year ?>">
              年
              <select name="month">
<?
	for ($i=1; $i<=12; $i++) {
		if ($i==$month)
			echo "<option value=\"$i\" selected>$i</option>";
		else
			echo "<option value=\"$i\">$i</option>";
	}
?>
              </select>月
              <input type="hidden" name="id" value="<? echo $id ?>">
              <input type="submit" name="Submit" value="查看">
            </td>
          </tr>
        </form>
      </table>
      <table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ede5d2" bordercolordark="#ffffff">
        <tr bgcolor="#ffffff"> 
          <td colspan=12>
          	报表名：个人月报表
          	<br>
          	月份：<? echo $year."年".$month."月"; ?>
          	<br>
          	用户：<? echo $array_crm_id2user[$id]; ?>
          </td>
        </tr>

        <tr bgcolor="#ede5d2" align=right> 
          <td align=left rowspan=2><b>项目名</b>&nbsp;</td>
          <td align=center colspan=7><b>项目费用</b></td>
          <td align=center colspan=3><b>日常费用</b></td>
          <td rowspan=2><b>合 计</b>&nbsp;</td>
        </tr>
        <tr bgcolor="#ede5d2" align=right> 
<?
	for ($i=1; $i<=10; $i++) {
		echo "<td><b>$array_crm_expense_name[$i]</b></td>";
	}
?>
        </tr>


<?	
	$mon_view = "0".$month;
	$mon_view = substr($mon_view, -2);
	$where = " where UseTime like '%$year"."-".$mon_view."%' and UserID='$id' ";
	$sql = "select distinct ProjectID from $tbl_crm_expense $where";
	//echo $sql;
	$res = mysql_query($sql);
	$exp_zongji = 0;
	while ($row=@mysql_fetch_array($res)) {
		$projectid = "$row[0]";
		
		$sql3 = "select * from $tbl_crm_project where ProjectID='$projectid'";
		$res3 = mysql_query($sql3);
		$row3 = @mysql_fetch_array($res3);
		$projectname = $row3[ProjectName];
		
		$sql2 = "select * from $tbl_crm_expense $where and ProjectID='$projectid'";
		$res2 = mysql_query($sql2);

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

		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;
				case 8:
					$exp8 += $row2[RealExpense];
					break;
				case 9:
					$exp9 += $row2[RealExpense];
					break;
				case 10:
					$exp10 += $row2[RealExpense];
					break;
			}
			$exp_heji += $row2[RealExpense];
		}
		$exp_zongji += $exp_heji;
?> 
        <tr align=right> 
          <td align=left><? echo $projectname ?>&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 $exp8 ?>&nbsp;</td>
          <td><? echo $exp9 ?>&nbsp;</td>
          <td><? echo $exp10 ?>&nbsp;</td>
          <td><? echo $exp_heji ?>&nbsp;</td>
        </tr>
<?
	}
?>
        <tr align=right> 
          <td align=left><b>总 计</b>&nbsp;</td>
          <td colspan=10>&nbsp;</td>
          <td><? echo $exp_zongji ?>&nbsp;</td>
        </tr>
      </table>
      <p></p>
    </td>
  </tr>
</table>
<? include "include/footer.inc.php"; ?>