acurrentaccoutreport.java

(Java+SQL)-大型企业JAVA的ERP系统

package src.report;

import src.com.*;
import java.sql.*;
import java.io.*;

public class ACurrentAccoutReport extends ShangObject 
{

   /**
部门名称
   */
   private String deptId;

   /**
部门名称
   */
   private String deptName;

   /**
姓名
   */
   private String empName;

   /**
单位编号
   */
   private String customerId;
   
   /**
单位名称
   */
   private String customerName;

   /**
上月应收款
   */
   private double lastAR;

   /**
上月应付款
   */
   private double lastAP;
   /**
本月应收款
   */
   private double thisAR;
   /**
本月应付款
   */
   private double thisAP;
   /**
本月增减
   */
   private double balance;

   /**
最后发生日期
   */
   public Timestamp lmDate;
   public Timestamp invoiceDate;
      
   /**
开始日期
   */
   public Timestamp beginDate;

   /**
结束日期
   */
   public Timestamp endDate;   

   /**
上月开始日期
   */
   public Timestamp lastBeginDate;

   /**
上月结束日期
   */
   public Timestamp lastEndDate;  
   
   private int flag; 
   
   private String whereClauseTemp="";
   
   private String beginDateWhere="";
   
   private String endDateWhere="";
   
   private String lastBeginDateWhere="";
   
   private String lastEndDateWhere="";
   
   private String lmBeginDateWhere="";
   
   private String lmEndDateWhere="";
   
   private String lmLastBeginDateWhere="";
   
   private String lmLastEndDateWhere="";
   
   public int flagReport;	//0：部门 1：客户

   /**
记录数
   */
   private int countNum;   
   
   public ACurrentAccoutReport(){
	   this.numInOnePager = 10;  
   }
   
   private void getDate(Timestamp day)
   {	
   	int monthTemp=Integer.parseInt(getStringDate(day,2));
   	int month=monthTemp;
   	//System.out.println("month:"+day);
   	if (monthTemp>1&&monthTemp<12)
   		{
   			beginDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+"-" + String.valueOf(month) + "-01 0:0:0.0");
   			endDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+"-" + String.valueOf(month+1) + "-01 0:0:0.0");
   			lastBeginDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1)) + "-" + String.valueOf(month-1) + "-01 0:0:0.0");
   			lastEndDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1)) + "-" + String.valueOf(month) + "-01 0:0:0.0");
   		}
   	if (monthTemp==1)
   		{
   			beginDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+"-1-01 0:0:0.0");
   			endDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1)) + "-2-01 0:0:0.0");
   			lastBeginDate=Timestamp.valueOf(String.valueOf(Integer.parseInt(getStringDate(day,1))-1) + "-12-01 0:0:0.0");
   			lastEndDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+"-1-01 0:0:0.0");
   		}
   	if (monthTemp==12)
   		{
   			beginDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+ "-1-01 0:0:0.0");
   			endDate=Timestamp.valueOf(String.valueOf(Integer.parseInt(getStringDate(day,1))+1) + "-1-01 0:0:0.0");
   			lastBeginDate=Timestamp.valueOf(String.valueOf(Integer.parseInt(getStringDate(day,1))) + "-11-01 0:0:0.0");
   			lastEndDate=Timestamp.valueOf(String.valueOf(getStringDate(day,1))+"-12-01 0:0:0.0");
   		}
   }
   
   public int loadAttr(){
       try{
	   	   if (flagReport==0) {
	   	   	deptId=getRsString(rs,"deptid");
	   	   	deptName = getRsString(rs,"deptname");       
	   	   	//empName = getRsString(rs,"empName");
	   	   }
	   	   else
	   	   {
	   	   	customerId=getRsString(rs,"customerid");
	   	   	customerName=getRsString(rs,"customername");
	   	   }
	   	   lastAR = rs.getDouble("lastAR");
	   	   lastAP = rs.getDouble("lastAP");
	   	   thisAR = rs.getDouble("thisAR");
	   	   thisAP = rs.getDouble("thisAP");
	   	   balance = (lastAR-lastAP)+(thisAR-thisAP);	   
	   	   invoiceDate= rs.getTimestamp("invoicedate");	   	   	   	   	   	   	   	   	   
	   	   lmDate = rs.getTimestamp("lmdate");	 
	   	   
	   	   //beginDate = rs.getTimestamp("begindate");
	   	   //endDate = rs.getTimestamp("endDate");	   	   	   	   
	   	   //countNum = rs.getInt("countNum");
	   	   if ((invoiceDate!=null)&&(lmDate==null)) {
	   	   	lmDate=invoiceDate;	
	   	   }
	   	   if ((lmDate!=null)&&(invoiceDate!=null)) {
		   	   if (invoiceDate.after(lmDate))
		   	   {
		   	   	lmDate=invoiceDate;
		   	   }	
		   }
	           return 1;
	   }catch(SQLException e){
			e.printStackTrace();
			System.out.println("query failed!");
			return -1;   
	    }		 
   }

/*
        deptName varchar(30)          -- 部门名称
        ,empName varchar(10)	       -- 姓名
        ,customerName varchar(30)      -- 单位名称        
        ,lastAR float          -- 上月应收款
        ,lastAP float          -- 上月应付款
        ,thisAR float          -- 本月应收款
        ,thisAP float          -- 本月应付款                        
        ,balance float         -- 本月增减   
	,lmDate datetime       -- 最后发生日期                     
        ,beginDate datetime    -- 开始日期
        ,endDate datetime      -- 结束日期        
        ,countNum int          -- 记录数	
*/ 
  

public int conditionSetup(javax.servlet.ServletRequest request) {
	String beginDaten;
	String beginDatey;
	String beginDater	;
	String endDaten;
	String endDatey;
	String endDater;
	String[] customerId;
	String[] department;
	int yue;
	flagReport=Integer.parseInt(request.getParameter("flag"));
	whereClause="";
	if (flagReport==0) {
		if ((request.getParameterValues("department")!=null)&&(!request.getParameterValues("department").equals(""))) {
			department=request.getParameterValues("department");
			for (int i = 0; i < department.length; i++) {
				whereClause = orWhereClause(whereClause, "", "", "'", department[i]);
			}
	       		whereClause=whereClause+ ")";
	       		whereClause="deptId in (" + whereClause;
	       		whereClauseTemp="department." + whereClause;
	       	}
       	}
	if (flagReport==1) {
		if ((request.getParameterValues("customer")!=null)&&(!request.getParameterValues("customer").equals(""))) {
			customerId=request.getParameterValues("customer");
			for (int i = 0; i < customerId.length; i++) {
				whereClause = orWhereClause(whereClause, "", "", "'", customerId[i]);
			}
	       		whereClause=whereClause+ ")";
	       		whereClause="customerId in (" + whereClause;
	       		whereClauseTemp="customer." + whereClause;
	       	}
       	}
	if((request.getParameter("beginDate")!=null)&&(!request.getParameter("beginDate").equals(""))){
		beginDate=Timestamp.valueOf(request.getParameter("beginDate"));
		System.out.println("1");	
   	} else {
		yue = new Integer(getStringDate(getCurDate(),2)).intValue();
	        beginDatey = "" + yue;