|  |  |  | 
|---|
|  |  |  | import com.doumee.dao.business.dto.InsuranceApplyQueryDTO; | 
|---|
|  |  |  | import com.doumee.dao.business.join.ApplyDetailJoinMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.join.ApplyLogJoinMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.join.DuSolutionJoinMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.join.InsuranceApplyJoinMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.model.*; | 
|---|
|  |  |  | import com.doumee.dao.business.vo.CountCyclePriceVO; | 
|---|
|  |  |  | 
|---|
|  |  |  | private MemberMapper memberMapper; | 
|---|
|  |  |  | @Autowired | 
|---|
|  |  |  | private DuSolutionMapper duSolutionMapper; | 
|---|
|  |  |  | @Autowired | 
|---|
|  |  |  | private DuSolutionJoinMapper duSolutionJoinMapper; | 
|---|
|  |  |  | @Autowired | 
|---|
|  |  |  | private DuWorktypeMapper duWorktypeMapper; | 
|---|
|  |  |  |  | 
|---|
|  |  |  | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | //查询保险方案下的所有派遣单位 | 
|---|
|  |  |  | List<DuSolution> duSolutionList = duSolutionMapper.selectList(new QueryWrapper<DuSolution>().lambda() | 
|---|
|  |  |  | List<DuSolution>  duSolutionList = duSolutionJoinMapper.selectJoinList(DuSolution.class,new MPJLambdaWrapper<DuSolution>() | 
|---|
|  |  |  | .selectAll(DuSolution.class) | 
|---|
|  |  |  | .innerJoin(DispatchUnit.class,DispatchUnit::getId,DuSolution::getDispatchUnitId) | 
|---|
|  |  |  | .eq(DispatchUnit::getCompanyId,insuranceApply.getCompanyId()) | 
|---|
|  |  |  | .eq(DispatchUnit::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(DispatchUnit::getUnitStatus,Constants.ONE) | 
|---|
|  |  |  | .eq(DuSolution::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(DuSolution::getStatus,Constants.ONE) | 
|---|
|  |  |  | .eq(DuSolution::getSolutionId,insuranceApply.getSolutionId())); | 
|---|
|  |  |  | 
|---|
|  |  |  | MPJLambdaWrapper wrapper=  new MPJLambdaWrapper<InsuranceApply>() | 
|---|
|  |  |  | .selectAll(InsuranceApply.class) | 
|---|
|  |  |  | .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) | 
|---|
|  |  |  | .selectAs(Company::getName,ApplyLog::getCompanyName) | 
|---|
|  |  |  | .selectAs(Company::getName,InsuranceApply::getCompanyName) | 
|---|
|  |  |  | .select(" ( select count(1) from apply_detail ad  where ad.apply_id = t.id ) as insureNum") | 
|---|
|  |  |  | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) | 
|---|
|  |  |  | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) | 
|---|
|  |  |  | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | if(insuranceApply.getStartTime().compareTo(new Date())<0  && insuranceApply.getEndTime().compareTo(new Date()) > 0 ){ | 
|---|
|  |  |  | insuranceApply.setLoseEfficacyDays(DateUtil.daysBetweenDates(insuranceApply.getEndTime(),new Date())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | initApplyStatus(insuranceApply); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | //查询附件数据 | 
|---|