| | |
| | | Page pagination = new Page(pageNo, pageSize); |
| | | ComEvent comEvent=new ComEvent(); |
| | | BeanUtils.copyProperties(comEventVO, comEvent); |
| | | log.info("==================参数vo"+comEventVO); |
| | | log.info("==================参数comEvent"+comEvent); |
| | | LoginUserInfoVO loginUserInfo = getLoginUserInfo(); |
| | | if (isNull(comEventVO.getAppId())){ |
| | | String appId = userService.detailUser(loginUserInfo.getUserId()).getData().getAppId(); |
| | |
| | | QueryWrapper<ComSanshuoExpert> wrapper=new QueryWrapper<>(); |
| | | wrapper.eq("level",level); |
| | | wrapper.eq("app_id",appId); |
| | | wrapper.eq("status",1 ); |
| | | wrapper.eq("del_flag",1 ); |
| | | if (level.equals(2)){ |
| | | wrapper.eq("industry_center_id", id); |
| | | }else if (level.equals(3)){ |
| | |
| | | AND ( order_sn like concat ('%',#{comEvent.keyword},'%') or request_user_tel like concat ('%',#{comEvent.keyword},'%') or current_org_name like concat ('%',#{comEvent.keyword},'%')) |
| | | </if> |
| | | <if test="comEvent.startTime != null and comEvent.startTime != ''"> |
| | | AND create_at between DATA_FORMAT(#{comEvent.startTime},'%Y-%m-%d 00:00:00') and DATA_FORMAT(#{comEvent.endTime},'%Y-%m-%d 00:00:00') |
| | | AND create_at between DATE_FORMAT(#{comEvent.startTime},'%Y-%m-%d 00:00:00') and DATE_FORMAT(#{comEvent.endTime},'%Y-%m-%d 00:00:00') |
| | | </if> |
| | | <if test="comEvent.createBy != null and comEvent.createBy!=''" > |
| | | AND create_by = #{comEvent.createBy} |