| | |
|---|
| | | |
|---|
| | | queryWrapper.orderByDesc(ApplyDetail::getCreateDate); |
|---|
| | | |
|---|
| | | // for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
|---|
| | | // if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
|---|
| | | // queryWrapper.orderByDesc(sortData.getProperty()); |
|---|
| | | // } else { |
|---|
| | | // queryWrapper.orderByAsc(sortData.getProperty()); |
|---|
| | | // } |
|---|
| | | // } |
|---|
| | | PageData<ApplyChange> pageData = PageData.from(applyChangeJoinMapper.selectJoinPage(page,ApplyChange.class, queryWrapper)); |
|---|
| | | return pageData; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<ApplyChange> findListForCompany(ApplyChange model) { |
|---|
| | | MPJLambdaWrapper<ApplyChange> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper |
|---|
| | | .selectAll(ApplyChange.class) |
|---|
| | | .selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode) |
|---|
| | | .selectAs(Solutions::getName,ApplyChange::getSolutionsName) |
|---|
| | | .selectAs(Solutions::getType,ApplyChange::getSolutionType) |
|---|
| | | .selectAs(Company::getName,ApplyChange::getCompanyName) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0 )",ApplyChange::getAddNum) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1 )",ApplyChange::getDelNum) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 2 )",ApplyChange::getChangeNum) |
|---|
| | | .select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID )",ApplyChange::getChangeMoney) |
|---|
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId) |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) |
|---|
| | | .eq(!Objects.isNull(model.getType()),ApplyChange::getType,model.getType()) |
|---|
| | | .eq(!Objects.isNull(model.getStatus())&&!model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,model.getStatus()) |
|---|
| | | .in(!Objects.isNull(model.getStatus())&&model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus, |
|---|
| | | Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey(), |
|---|
| | | Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey()) |
|---|
| | | .eq(!Objects.isNull(model.getUnionApplyId()),InsuranceApply::getUnionApplyId,model.getUnionApplyId()) |
|---|
| | | // .eq(!Objects.isNull(model.getSolutionsId()),ApplyChange::getSolutionsId,model.getSolutionsId()) |
|---|
| | | .eq(!Objects.isNull(model.getSolutionType()),Solutions::getType,model.getSolutionType()) |
|---|
| | | .eq(!Objects.isNull(model.getApplyId()),ApplyChange::getApplyId,model.getApplyId()) |
|---|
| | | .eq(!Objects.isNull(model.getBaseSolutionsId()),Solutions::getBaseId,model.getBaseSolutionsId()) |
|---|
| | | .like(StringUtils.isNotBlank(model.getSolutionsName()),Solutions::getName,model.getSolutionsName()) |
|---|
| | | .ge(StringUtils.isNotBlank(model.getCreateDateS()),ApplyChange::getCreateDate, model.getCreateDateS()+" 00:00:00" ) |
|---|
| | | .le(StringUtils.isNotBlank(model.getCreateDateE()),ApplyChange::getCreateDate, model.getCreateDateE()+" 23:59:59" ) |
|---|
| | | .ge(StringUtils.isNotBlank(model.getApplyStartS()),ApplyChange::getApplyStartTime, model.getApplyStartS()+" 00:00:00" ) |
|---|
| | | .le(StringUtils.isNotBlank(model.getApplyStartE()),ApplyChange::getApplyStartTime, model.getApplyStartE()+" 23:59:59" ); |
|---|
| | | LoginUserInfo loginUserInfo =(LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
|---|
| | | //企业人员查看本企业数据 |
|---|
| | | if(loginUserInfo.getType().equals(Constants.ONE)){ |
|---|
| | | queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId()); |
|---|
| | | }else if(loginUserInfo.getType().equals(Constants.TWO)){ |
|---|
| | | //如果是商户查看 |
|---|
| | | if(model.getSolutionType()!=null && model.getSolutionType() ==0){ |
|---|
| | | queryWrapper.exists("select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId()); |
|---|
| | | }else if(model.getSolutionType()!=null && model.getSolutionType() ==1){ |
|---|
| | | queryWrapper.eq(Solutions::getShopId,loginUserInfo.getCompanyId()); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.apply("((t1.type=0 and exists(select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" + |
|---|
| | | "t2.type=1 and t2.shop_id="+loginUserInfo.getCompanyId()+"))") ; |
|---|
| | | } |
|---|
| | | }else{ |
|---|
| | | if(loginUserInfo.getCompanyIdList()!=null && loginUserInfo.getCompanyIdList().size()>0){ |
|---|
| | | queryWrapper.in(InsuranceApply::getCompanyId, loginUserInfo.getCompanyIdList()); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.eq(InsuranceApply::getCompanyId, -1); |
|---|
| | | } |
|---|
| | | queryWrapper.eq(model.getCompanyId()!=null,InsuranceApply::getCompanyId, model.getCompanyId()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | queryWrapper.orderByDesc(ApplyDetail::getCreateDate); |
|---|
| | | return applyChangeJoinMapper.selectJoinList(ApplyChange.class,queryWrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | @Transactional(rollbackFor = {Exception.class,BusinessException.class}) |
|---|
