1.计算收入或支出表的金额总和
<?php
//sum的function是用来记录支出/收入的金额总数。
// 现在遇到的问题是,如何将计算 收入表-支出表的差。
include 'conn.php';
function sum($name,$table_name){
// 进行数据筛选
$sql = "SELECT * FROM {$table_name} ";
$query = mysql_query($sql);
$list = array();
$sum1 = 0;
while($res = mysql_fetch_array($query))
{
$list[]=$res;
$sum1 += $res['money'];
}
//检测录入的表名,如果是payout,显示负数
if($table_name == 'payout'){
echo '<h3 align = "center" >'.$name.":"." - ".$sum1."";
}
else{
echo '<h3>'.$name.":".$sum1."</h3>";
}
}
// $sum2 = $sum('收入表:','income');
// $sum1 = $sum('收入表:','payout');
?>
2.收入列表
<?php
session_start();
error_reporting(0);
include 'conn.php';
include 'header.php';
include 'sum.php';
if(!$_SESSION['user']) header('location:index.php');
//分页逻辑
$length = 5;
$pagenum=$_GET['page']?$_GET['page']:1;
$offset = ($pagenum-1) * $length;
$sql = "SELECT * FROM income order by id asc limit {$offset},{$length}";
$query = mysql_query($sql);
//输出表格
echo '<table width="80%" border="0" cellpadding="0" cellspacing="1" bgcolor="#c9c9c9" align="center">
<tr>
<td><div><strong><span>项目</span></strong></div></td>
<td><div><strong><span>摘要</span></strong></div></td>
<td><div><strong><span>金额(元)</span></strong></div></td>
<td><div><strong><span>签订合同</span></strong></div></td>
<td><div><strong><span>提成</span></strong></div></td>
<td><div><strong><span>日期</span></strong></div></td>
<td><div><strong><span>负责人</span></strong></div></td>
<td><div><strong><span>操作</span></strong></div></td>
</tr>';
echo "<h3>收入明细表</h3>";
while($res = mysql_fetch_array($query))
{
?>
<meta>
<title></title>
";
//获取上一页下一页
$prevpage = $pagenum-1;
$nextpage = $pagenum+1;
?>
">上一页 | ">下一页
3.支出列表
<?php
//读取payout表中的内容,并以表格形式显示
session_start();
error_reporting(0);
include("conn.php");
include 'function.php';
include 'sum.php';
if(!$_SESSION['user']) header("location:login.php");
include("header.php");
echo '<meta http-equiv="Content-Type" content="text/html" charset="utf-8" />';
//分页逻辑
$pagesize = 20;
$pagenum = $_GET['page'] ? $_GET['page'] : 1;
$offset = ($pagenum - 1) * $pagesize;
$sql = "SELECT * FROM payout order by pid asc limit {$pagenum},{$pagesize} ";
$query = mysql_query($sql);
//表格开始
echo '
项目明细 |
摘要 |
金额 |
日期 |
经手人 |










