| | |
| | | |
| | | @Override |
| | | public List<HiddenDanger> findList(HiddenDanger hiddenDanger) { |
| | | hiddenDanger.setIsdeleted(Constants.ZERO); |
| | | QueryWrapper<HiddenDanger> wrapper = new QueryWrapper<>(hiddenDanger); |
| | | return hiddenDangerMapper.selectList(wrapper); |
| | | } |
| | |
| | | |
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()), ms->ms.like(Member::getName,pageWrap.getModel().getMemberName()) |
| | | .or().like(Member::getPhone,pageWrap.getModel().getMemberName())) |
| | | .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), HiddenDanger::getCreateDate,pageWrap.getModel().getQueryStartTime()) |
| | | .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),HiddenDanger::getCreateDate,pageWrap.getModel().getQueryEndTime()) |
| | | .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), HiddenDanger::getSubmitTime,pageWrap.getModel().getQueryStartTime()) |
| | | .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),HiddenDanger::getSubmitTime,pageWrap.getModel().getQueryEndTime()) |
| | | .orderByDesc(Visits::getCreateDate) |
| | | ; |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | |
| | | |
| | | @Override |
| | | public long count(HiddenDanger hiddenDanger) { |
| | | hiddenDanger.setIsdeleted(Constants.ZERO); |
| | | QueryWrapper<HiddenDanger> wrapper = new QueryWrapper<>(hiddenDanger); |
| | | return hiddenDangerMapper.selectCount(wrapper); |
| | | } |
| | |
| | | .selectAll(HiddenDanger.class) |
| | | .selectAs(HiddenDangerParam::getCompanyId, HiddenDanger::getAreaCompanyId) |
| | | .leftJoin(HiddenDangerParam.class,HiddenDangerParam::getId,HiddenDanger::getAreaId) //隐患区域 |
| | | .eq(HiddenDanger::getIsdeleted,Constants.ZERO) |
| | | .eq(Objects.nonNull(hiddenDanger.getStatus()),HiddenDanger::getStatus,hiddenDanger.getStatus()) |
| | | .ge(Objects.nonNull(hiddenDanger.getQueryStartTime()), HiddenDanger::getCreateDate,hiddenDanger.getQueryStartTime()) |
| | | .le(Objects.nonNull(hiddenDanger.getQueryEndTime()),HiddenDanger::getCreateDate,hiddenDanger.getQueryEndTime()) |
| | |
| | | List<HiddenDangerParam> hiddenDangerParamList = hiddenDangerParamMapper.selectList(new QueryWrapper<HiddenDangerParam>() |
| | | .lambda().eq(HiddenDangerParam::getIsdeleted,Constants.ZERO).eq(HiddenDangerParam::getType,Constants.ONE)); |
| | | for (Integer cateId:cateSetList) { |
| | | if(Objects.isNull(cateId)){ |
| | | continue; |
| | | } |
| | | Optional<HiddenDangerParam> optionalHiddenDanger = hiddenDangerParamList.stream().filter(i->Constants.equalsInteger(i.getId(),cateId)).findAny(); |
| | | if(optionalHiddenDanger.isPresent()){ |
| | | GeneralDataVO generalDataVO = new GeneralDataVO(); |
| | |
| | | generalDataVO.setTotal(total); |
| | | generalDataVO.setRata( |
| | | Constants.equalsInteger(total,Constants.ZERO)? |
| | | BigDecimal.ZERO:new BigDecimal(total.toString()).divide(new BigDecimal(hiddenDangerDataVO.getTotal().toString()),2).multiply(new BigDecimal("100")) |
| | | BigDecimal.ZERO:new BigDecimal(total.toString()) |
| | | .divide(new BigDecimal(hiddenDangerDataVO.getTotal().toString()),2,BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100")) |
| | | ); |
| | | cateGeneralDataList.add(generalDataVO); |
| | | } |
| | |
| | | List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>() |
| | | .lambda().eq(Company::getIsdeleted,Constants.ZERO)); |
| | | for (Integer companyId:companyIdSetList) { |
| | | if(Objects.isNull(companyId)){ |
| | | continue; |
| | | } |
| | | Optional<Company> optionalCompany = companyList.stream().filter(i->Constants.equalsInteger(i.getId(),companyId)).findAny(); |
| | | if(optionalCompany.isPresent()){ |
| | | GeneralDataVO generalDataVO = new GeneralDataVO(); |