| | |
|---|
| | | LambdaQueryWrapper<TjSampling> wrapper = new LambdaQueryWrapper<>(); |
|---|
| | | wrapper.eq(TjSampling::getIsSignFor, isSignFor); |
|---|
| | | if (null != tjNum && StrUtil.isNotBlank(tjNum)) |
|---|
| | | wrapper.eq(TjSampling::getTjNum, tjNum); |
|---|
| | | wrapper.like(TjSampling::getTjNum, tjNum); |
|---|
| | | if (null != name && StrUtil.isNotBlank(name)) |
|---|
| | | wrapper.eq(TjSampling::getCusName, name); |
|---|
| | | wrapper.like(TjSampling::getCusName, name); |
|---|
| | | if (null != beginTime && null != endTime && StrUtil.isNotBlank(beginTime) && StrUtil.isNotBlank(endTime)) |
|---|
| | | wrapper.between(TjSampling::getApplicationTime, beginTime, endTime); |
|---|
| | | wrapper.groupBy(TjSampling::getCusId); |
|---|
| | | wrapper.orderByDesc(TjSampling::getCreateTime); |
|---|
| | | // wrapper.last("LIMIT " + (pageNum - 1) * pageSize + "," + pageSize); |
|---|
| | | Page<TjSampling> page = tjSamplingService.page(samplingPage, wrapper); |
|---|
| | | List<TjSampling> list = page.getRecords(); |
|---|
| | | ArrayList<TjCustomer> tjCustomers = new ArrayList<>(); |
|---|
| | | for (TjSampling tjSampling : list) { |
|---|
| | | TjCustomer customer = customerService.getById(tjSampling.getCusId()); |
|---|
| | | customer.setCusName(customer.getCusName()); |
|---|
| | | customer.setCusPhone(MatchUtils.hidePhoneNum(customer.getCusPhone())); |
|---|
| | | customer.setCusIdcard(MatchUtils.hideIdCardNum(customer.getCusIdcard())); |
|---|
| | | customer.setTjNumber(tjSampling.getTjNum()); |
|---|
| | | customer.setApplicationTime(tjSampling.getApplicationTime()); |
|---|
| | | tjCustomers.add(customer); |
|---|
| | | if(null !=customer){ |
|---|
| | | customer.setCusName(customer.getCusName()); |
|---|
| | | customer.setCusPhone(MatchUtils.hidePhoneNum(customer.getCusPhone())); |
|---|
| | | customer.setCusIdcard(MatchUtils.hideIdCardNum(customer.getCusIdcard())); |
|---|
| | | customer.setTjNumber(tjSampling.getTjNum()); |
|---|
| | | customer.setApplicationTime(tjSampling.getApplicationTime()); |
|---|
| | | tjCustomers.add(customer); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | HashMap<String, Object> hashMap = new HashMap<>(); |
|---|
| | | hashMap.put("list", tjCustomers); |
|---|
| | |
|---|
| | | wrapper.eq(TjSampling::getTjNum, tjNumber); |
|---|
| | | wrapper.eq(TjSampling::getIsSignFor,isSignFor); |
|---|
| | | wrapper.and(i -> i.isNull(TjSampling::getParentId).or().eq(TjSampling::getIsMerge,1)); |
|---|
| | | // wrapper.eq(TjSampling::getIsPay,1); |
|---|
| | | // if (isSignFor == 1) |
|---|
| | | // wrapper.eq(TjSampling::getIsApply,0); |
|---|
| | | wrapper.orderByDesc(TjSampling::getIsMerge); |
|---|
| | | List<TjSampling> list = tjSamplingService.list(wrapper); |
|---|
| | | if (list.isEmpty()){ |
|---|
| | | logger.info("jtNum ->{}",tjNumber); |
|---|
| | | // return AjaxResult.error("未查询到数据，人员未缴费或没有未采样项目"); |
|---|
| | | return AjaxResult.error("参数错误,未查询到数据"); |
|---|
| | | } |
|---|
| | | // for (TjSampling sampling : list) { |
|---|
