根据业务员ID查询应收款和实收款数据

/**

• 根据业务员id查询该业务员的应收款和实收款数据

• @param salesmanId 业务员id

• @return */ public List getIncomeListBySalesmanId(String salesmanId){ List incomeList=null; //查询业务员关联的合同数据 List contractList=getPayedContractListBySalesmanId(salesmanId); if(contractList!=null&&contractList.size()>0){ //有合同数据，根据合同数据查询应收款数据 Set contractIdSet=new HashSet(); for(int i=0;i<contractList.size();i++){ Contract contract=contractList.get(i); contractIdSet.add(contract.getId()); } //查询应收款数据 List receivableList=receivableService.getReceivableListByContractIdSet(contractIdSet); //查询实收款数据 incomeList=incomeService.getIncomeListByContractIdSet(contractIdSet); }

  return incomeList; }

/**

• 根据业务员id查询该业务员的应收款数据

• @param salesmanId 业务员id

• @param payStatus 付款状态，1-未支付，2-已支付

• @return */ public List getReceivableListBySalesmanId(String salesmanId,String payStatus){ List receivableList=null; //查询业务员关联的合同数据 List contractList=getPayedContractListBySalesmanId(salesmanId); if(contractList!=null&&contractList.size()>0){ //有合同数据，根据合同数据查询应收款数据 Set contractIdSet=new HashSet(); for(int i=0;i<contractList.size();i++){ Contract contract=contractList.get(i); contractIdSet.add(contract.getId()); } //查询应收款数据 receivableList=receivableService.getReceivableListByContractIdSet(contractIdSet); if(payStatus!=null){ //有付款状态要求，根据付款状态，筛选应收款数据 List newReceivableList=new ArrayList(); for(int i=0;i<receivableList.size();i++){ Receivable receivable=receivableList.get(i); if(payStatus.equals(receivable.getPayStatus())){ //付款状态符合 newReceivableList.add(receivable); } } //覆盖应收款数据 receivableList=newReceivableList; } }

  return receivableList; }

/**

• 根据业务员id查询该业务员的应收款数据

• @param salesmanId 业务员id

• @param payStatus 付款状态，1-未支付，2-已支付

• @param startDate 开始日期

• @param endDate 结束日期

• @return */ public List getReceivableListBySalesmanId(String salesmanId,String payStatus,String startDate,String endDate){ List receivableList=getReceivableListBySalesmanId(salesmanId, payStatus);

  //根据日期筛选应收款数据 if(receivableList!=null&&receivableList.size()>0&&startDate!=null&&endDate!=null&&startDate!=""&&endDate!=""){ //有日期要求 List newReceivableList=new ArrayList(); for(int i=0;i<receivableList.size();i++){ Receivable receivable=receivableList.get(i); String dueDate=receivable.getDueDate(); if(dueDate!=null&&dueDate!=""){ //有到期日期 if(DateUtil.dateCompare(startDate, dueDate)<=0&&DateUtil.dateCompare(dueDate, endDate)<=0){ //到期日期在开始和结束日期之间 newReceivableList.add(receivable); } } } //覆盖应收款数据 receivableList=newReceivableList; }

  return receivableList; }

/**

• 根据业务员id查询该业务员的实收款数据

• @param salesmanId 业务员id

• @return */ public List getIncomeListBySalesmanId(String salesmanId){ List incomeList=null; //查询业务员关联的合同数据 List contractList=getPayedContractListBySalesmanId(salesmanId); if(contractList!=null&&contractList.size()>0){ //有合同数据，根据合同数据查询实收款数据 Set contractIdSet=new HashSet(); for(int i=0;i<contractList.size();i++){ Contract contract=contractList.get(i); contractIdSet.add(contract.getId()); } //查询实收款数据 incomeList=incomeService.getIncomeListByContractIdSet(contractIdSet); }

  return incomeList; }

/**

• 根据业务员id查询该业务员的实收款数据

• @param salesmanId 业务员id

• @param startDate 开始日期

• @param endDate 结束日期

• @return */ public List getIncomeListBySalesmanId(String salesmanId,String startDate,String endDate){ List incomeList=getIncomeListBySalesmanId(salesmanId);

  //根据日期筛选实收款数据 if(incomeList!=null&&incomeList.size()>0&&startDate!=null&&endDate!=null&&startDate!=""&&endDate!=""){ //有日期要求 List newIncomeList=new ArrayList(); for(int i=0;i<incomeList.size();i++){ Income income=incomeList.get(i); String paymentDate=income.getPaymentDate(); if(paymentDate!=null&&paymentDate!=""){ //有支付日期 if(DateUtil.dateCompare(startDate, paymentDate)<=0&&DateUtil.dateCompare(paymentDate, endDate)<=0){ //支付日期在开始和结束日期之间 newIncomeList.add(income); } } } //覆盖实收款数据 incomeList=newIncomeList; }

  return incomeList; }

/**

• 根据业务员id查询该业务员的已支付的挂靠经营合同列表

• @param salesmanId 业务员id

• @return */ private List getPayedContractListBySalesmanId(String salesmanId){ List contractList=null; //查询该业务员关联的所有合同数据 List contractListAll=contractService.getContractListBySalesmanId(salesmanId); //合同类型 String contractType='1'; //已支付的合同id集合 Set payedContractIdSet=new HashSet(); if(contractListAll!=null&&contractListAll.size()>0){ //有合同数据 for(int i=0;i<contractListAll.size();i++){ Contract contract=contractListAll.get(i); //判断合同类型是否为挂靠经营合同 if(contract.getContractType().equals(contractType)){ //合同类型是挂靠经营合同 //查询合同付款信息 List contractPaymentList=contractPaymentService.getContractPaymentList(contract.getId()); if(contractPaymentList!=null&&contractPaymentList.size()>0){ //有合同付款信息 //判断该合同是否是有效的 String payStatus=contract.getPayStatus(); if(payStatus!=null&&payStatus.equals('1')){ //合同状态是有效 //判断该合同付款信息是否是已支付状态 for(int i=0;i<contractPaymentList.size();i++){ ContractPayment contractPayment=contractPaymentList.get(i); if(contractPayment.getPaymentStatus().equals('1')){ //付款状态是已付款，添加该合同id到set中 payedContractIdSet.add(contract.getId()); } } } } } } } //查询合同数据 if(payedContractIdSet!=null&&payedContractIdSet.size()>0){ //有支付过的合同，根据合同id查询合同数据 contractList=contractService.getContractListByPayedContractIdSet(payedContractIdSet); }

  return contractList; }