| | |
| | | .selectAs(Category::getName,JkCustomer::getCategoryName) |
| | | .leftJoin(JkLine.class,JkLine::getId,JkCustomer::getLineId ) |
| | | .leftJoin(Category.class,Category::getId,JkLine::getCategoryId ); |
| | | queryWrapper.eq( pageWrap.getModel().getDistanceStatus()!=null,JkCustomer::getDistanceStatus, pageWrap.getModel().getDistanceStatus()); |
| | | queryWrapper.eq( pageWrap.getModel().getCategoryId()!=null,JkLine::getCategoryId, pageWrap.getModel().getCategoryId()); |
| | | queryWrapper.eq(StringUtils.isNotBlank(pageWrap.getModel().getLineWeeks()),JkLine::getWeeks, pageWrap.getModel().getLineWeeks()); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCategoryName()),Category::getName, pageWrap.getModel().getCategoryName()); |
| | |
| | | try { |
| | | LambdaQueryWrapper<JkCustomer> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.isNotNull(JkCustomer::getLocation); |
| | | queryWrapper.isNotNull(JkCustomer::getLocation); |
| | | queryWrapper.and(wrapper ->{ |
| | | wrapper.isNull(JkCustomer::getLatitude) |
| | | .or().isNull(JkCustomer::getLongitude); }); |
| | |
| | | String url = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.GAODE_LOCATION_GEOAPI_URL).getCode(); |
| | | for(JkCustomer c : list){ |
| | | try { |
| | | String result = HttpsUtil.get(url.replace("${param}",c.getLocation()),true); |
| | | String urlStr =url.replace("${param}" |
| | | ,c.getLocation().replaceAll("[^a-zA-Z0-9\\u4e00-\\u9fa5]", "")); |
| | | String result = HttpsUtil.get(urlStr,true); |
| | | JSONObject json = JSONObject.parseObject(result); |
| | | if(json!=null |
| | | && json.getInteger("status")!=null |
| | |
| | | } |
| | | }else{ |
| | | log.error("更新交控中心客户经纬度信息=====获取json=========="+json); |
| | | log.error("更新交控中心客户经纬度信息=====获取失败=========="+c.getName()+"-"+c.getLocation()); |
| | | log.error("更新交控中心客户经纬度信息=====获取失败=========="+urlStr+c.getName()+"-"+c.getLocation()); |
| | | } |
| | | }catch (Exception e){ |
| | | log.error("更新交控中心客户经纬度信息=====失败=========="+c.getName()+"-"+c.getLocation()); |