| | |
|---|
| | | 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.and(StringUtils.isNotBlank(pageWrap.getModel().getName()), ms->ms.like(Member::getPhone,pageWrap.getModel().getName()) |
|---|
| | | .or().like(Member::getName,pageWrap.getModel().getName())); |
|---|
| | | 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().getKeyWords()), ms->ms.like(Member::getPhone,pageWrap.getModel().getKeyWords()) |
|---|
| | | .or().like(Member::getName,pageWrap.getModel().getKeyWords())); |
|---|
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getName,pageWrap.getModel().getCompanyName()); |
|---|
| | | queryWrapper.orderByDesc(TrainTime::getId); |
|---|
| | | IPage<TrainTime> result = trainTimeJoinMapper.selectJoinPage(page, TrainTime.class,queryWrapper); |
|---|
