Merge remote-tracking branch 'origin/master'
| | |
| | | String hkToken = DESUtil.generateTokenToHk(loginUserInfo.getUsername(),Integer.valueOf( |
| | | systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_TOKEN_VALIDITY).getCode() |
| | | ),redisTemplate); |
| | | String url = systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_HTTPS).getCode() + |
| | | systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_HOST).getCode() |
| | | String url = (type==6?"":(systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_HTTPS).getCode() + |
| | | systemDictDataBiz.queryByCode(Constants.HK_PARAM,Constants.HK_HOST).getCode())) |
| | | + HKService.getMenuUrl(type,hkToken); |
| | | try { |
| | | if(redisTemplate!=null&& jwtProperties!=null){ |
| | |
| | | .leftJoin(HiddenDangerParam.class,HiddenDangerParam::getId,HiddenDanger::getAreaId) //隐患区域 |
| | | .eq(HiddenDanger::getIsdeleted,Constants.ZERO) |
| | | .eq(Objects.nonNull(hiddenDanger.getStatus()),HiddenDanger::getStatus,hiddenDanger.getStatus()) |
| | | .apply(" ( DATE_FORMAT(t.CREATE_DATE, '%Y') = DATE_FORMAT(now(), '%Y') ) ") |
| | | .ge(Objects.nonNull(hiddenDanger.getQueryStartTime()), HiddenDanger::getCreateDate,hiddenDanger.getQueryStartTime()) |
| | | .le(Objects.nonNull(hiddenDanger.getQueryEndTime()),HiddenDanger::getCreateDate,hiddenDanger.getQueryEndTime()) |
| | | // .apply(" ( DATE_FORMAT(t.CREATE_DATE, '%Y') = DATE_FORMAT(now(), '%Y') ) ") |
| | | // .ge(Objects.nonNull(hiddenDanger.getQueryStartTime()), HiddenDanger::getCreateDate,hiddenDanger.getQueryStartTime()) |
| | | // .le(Objects.nonNull(hiddenDanger.getQueryEndTime()),HiddenDanger::getCreateDate,hiddenDanger.getQueryEndTime()) |
| | | ); |
| | | List<GeneralDataVO> yearDataList = new ArrayList<>(); |
| | | if(CollectionUtils.isEmpty(hiddenDangerAllList)){ |
| | |
| | | .selectAs(Company::getName,Retention::getCompanyName) |
| | | .selectAs(Company::getType,Retention::getCompanyType) |
| | | .select(" ( SELECT v.company_name FROM visits v WHERE v.member_id = t.member_id and v.status = "+Constants.VisitStatus.signin+" ORDER BY create_date DESC limit 1 ) as visitCompanyName "); |
| | | queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) |
| | | queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) |
| | | .eq(Company::getIsdeleted,Constants.ZERO) |
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getKeyWords()),w->{ |
| | | w.like( Retention::getPhone,pageWrap.getModel().getKeyWords()) |
| | | .or().like( Retention::getName,pageWrap.getModel().getKeyWords()); }) |
| | |
| | | .isNull(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.ZERO), |
| | | Retention::getCompanyId) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.ONE), |
| | | Company::getType,Constants.ZERO) |
| | | Retention::getType,Constants.FOUR) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.TWO), |
| | | Company::getType,Constants.ONE) |
| | | Retention::getType,Constants.TWO) |
| | | //过滤车辆数据 |
| | | .ne(Retention::getType,3) |
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), |
| | |
| | | List<Integer> lwCompanyIds = lwCompanyList.stream().map(i->i.getId()).collect(Collectors.toList()); |
| | | List<Retention> retentionList = retentionMapper.selectList( |
| | | new QueryWrapper<Retention>().lambda() |
| | | .eq(Retention::getIsdeleted,Constants.ZERO) |
| | | .eq(Retention::getType,Constants.FOUR) |
| | | .in(Retention::getCompanyId,lwCompanyIds) |
| | | ); |
| | |
| | | List<Integer> internalCompanyIds = internalCompanyList.stream().map(i->i.getId()).collect(Collectors.toList()); |
| | | List<Retention> retentionList = retentionMapper.selectList( |
| | | new QueryWrapper<Retention>().lambda() |
| | | .eq(Retention::getIsdeleted,Constants.ZERO) |
| | | .eq(Retention::getType,Constants.TWO) |
| | | .in(Retention::getCompanyId,internalCompanyIds) |
| | | ); |