Internal management system-PHP source code

Company internal management system 1. calculate the total amount of income or expenditure tables

2. income list

               
Project
        
Summary
        
Amount (RMB)
        
Sign Contract
        
Commission
         
Date
        
Owner
        
Operation
      '; Echo "revenue schedule"; while ($ res = mysql_fetch_array ($ query) {?>
                
 "; // Get previous page $ prevpage = $ pagenum-1; $ nextpage = $ pagenum + 1;?>
   "> Previous Page |"> Next page
 

3. expenditure list

 '; // Paging logic $ 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); // table start echo'Output Table
 
 
 
  
  
'; Echo'
  
  '; Echo "expense detail table"; // starts to read data cyclically while ($ res = mysql_fetch_array ($ query) {?>   
  
 
   
 
    
Project details
 
    
Summary
 
    
Amount
 
    
Date
 
    
Handled