|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | import cn.hutool.core.util.IdcardUtil; | 
 |  |  | import cn.hutool.core.util.PhoneUtil; | 
 |  |  | import com.alibaba.fastjson.JSONObject; | 
 |  |  | import com.doumee.biz.system.SystemDictDataBiz; | 
 |  |  | import com.doumee.core.annotation.excel.ExcelImporter; | 
 |  |  | import com.doumee.core.constants.ResponseStatus; | 
 |  |  | import com.doumee.core.exception.BusinessException; | 
 |  |  | import com.doumee.core.model.LoginUserInfo; | 
 |  |  | import com.doumee.core.model.PageData; | 
 |  |  | import com.doumee.core.model.PageWrap; | 
 |  |  | import com.doumee.service.business.third.model.LoginUserInfo; | 
 |  |  | import com.doumee.service.business.third.model.PageData; | 
 |  |  | import com.doumee.service.business.third.model.PageWrap; | 
 |  |  | import com.doumee.core.utils.Constants; | 
 |  |  | import com.doumee.core.utils.DESUtil; | 
 |  |  | import com.doumee.core.utils.DateUtil; | 
 |  |  | import com.doumee.dao.admin.request.MemberImport; | 
 |  |  | import com.doumee.dao.admin.request.TrainTimeImport; | 
 |  |  | import com.doumee.dao.business.EmpowerMapper; | 
 |  |  | import com.doumee.dao.business.MemberRoleMapper; | 
 |  |  | 
 |  |  |         queryWrapper.selectAs(Company::getCompanyNamePath,TrainTime::getCompanyName); | 
 |  |  |         queryWrapper.selectAs(SystemUser::getRealname,TrainTime::getCreateName); | 
 |  |  |         queryWrapper.eq(TrainTime::getIsdeleted, Constants.ZERO); | 
 |  |  |         queryWrapper.ge(pageWrap.getModel().getStartTimeStart() != null, TrainTime::getStartTime,  pageWrap.getModel().getStartTimeStart()); | 
 |  |  |         queryWrapper.le(pageWrap.getModel().getStartTimeEnd() != null, TrainTime::getStartTime, pageWrap.getModel().getStartTimeEnd()); | 
 |  |  |  | 
 |  |  |         queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()), ms->ms.like(Member::getPhone,pageWrap.getModel().getName()) | 
 |  |  |                 .or().like(Member::getName,pageWrap.getModel().getName())); | 
 |  |  |         queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getName,pageWrap.getModel().getCompanyName()); |