Company internal management system

Simply record expenses, income, and reimbursements.
The problem we encounter now is how to calculate the difference between the income table (income) and the expenditure table (payout).
If you need the complete set of source code, you can directly leave your email address, or add me on QQ to send it directly.
And I hope you can help me correct the wrong logic or how to strengthen it.
Thank you

//The function of sum is used to record the total amount of expenditure/income.
// The problem now is how to calculate the difference between the income statement and the expense statement.
 include 'conn.php';

 function sum($name,$table_name){

 // Filter data
 $sql = "SELECT * FROM {$table_name} ";
 $query = mysql_query($sql) ;
 $list = array();
 $sum1 = 0;

 while($res = mysql_fetch_array($query))
 {
 $list[]=$res;
 $sum1 += $res['money' ];
 }
 //Detect the entered table name. If it is payout, display a negative number
 if($table_name == 'payout'){
 echo ''.$name." :"." - ".$sum1."";
 }
 else{
 echo ''.$name.":".$sum1. "";
 }

}


 // $sum2 = $sum('income statement:','income');
 // $sum1 = $sum('income statement:', 'payout');






?>

	 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 '                                                                             ';		echo "收入明细表";	while($res = mysql_fetch_array($query))	{
?>	  				                                              	
                      
				
			
}echo "

项目
摘要
金额(元)
签订合同
提成
日期
负责人
操作

















 

																		 

编辑
										  删除






";
//获取上一页下一页
        $prevpage = $pagenum-1;
        $nextpage = $pagenum+1;
?>






  上一页 | 下一页



 // 计算总价

  echo $table =sum('收入表明细','income');

?>

  //读取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 '';

  //分页逻辑
        $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 '';   echo '                                              ';     echo "支出明细表";
  //循环读取数据开始  while ( $res = mysql_fetch_array($query)) {?>支出表填写

                                               
} echo "

项目明细
摘要
金额
日期
经手人
















      
 



 

";

 //Get the previous page and next page
 $prevpage = $pagenum-1;

 $nextpage = $pagenum+1;


?>

 Previous page | Next page < ;/h3>




 $sql = "SELECT * from payout";
 $query = mysql_query($sql);

 //Start calculation

 echo $sum = sum("income table","payout");
 mysql_close();


?>