server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/WxNoticeConfigController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,109 @@ package com.doumee.cloud.admin; import com.doumee.api.BaseController; import com.doumee.config.annotation.CloudRequiredPermission; import com.doumee.core.annotation.excel.ExcelExporter; import com.doumee.core.annotation.pr.PreventRepeat; import com.doumee.core.model.ApiResponse; import com.doumee.core.model.PageWrap; import com.doumee.core.model.PageData; import com.doumee.core.utils.Constants; import com.doumee.dao.business.model.WxNoticeConfig; import com.doumee.service.business.WxNoticeConfigService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.List; /** * @author æ±è¹è¹ * @date 2024/10/17 15:44 */ @Api(tags = "å¾®ä¿¡å ¬ä¼å·éç¥é ç½®") @RestController @RequestMapping(Constants.CLOUD_SERVICE_URL_INDEX+"/business/wxNoticeConfig") public class WxNoticeConfigController extends BaseController { @Autowired private WxNoticeConfigService wxNoticeConfigService; @PreventRepeat @ApiOperation("æ°å»º") @PostMapping("/create") @CloudRequiredPermission("business:wxnoticeconfig:create") public ApiResponse create(@RequestBody WxNoticeConfig wxNoticeConfig) { return ApiResponse.success(wxNoticeConfigService.create(wxNoticeConfig)); } @ApiOperation("æ ¹æ®IDå é¤") @GetMapping("/delete/{id}") @CloudRequiredPermission("business:wxnoticeconfig:delete") public ApiResponse deleteById(@PathVariable Integer id) { wxNoticeConfigService.deleteById(id); return ApiResponse.success(null); } @ApiOperation("æ¹éå é¤") @GetMapping("/delete/batch") @CloudRequiredPermission("business:wxnoticeconfig:delete") public ApiResponse deleteByIdInBatch(@RequestParam String ids) { String [] idArray = ids.split(","); List<Integer> idList = new ArrayList<>(); for (String id : idArray) { idList.add(Integer.valueOf(id)); } wxNoticeConfigService.deleteByIdInBatch(idList); return ApiResponse.success(null); } @ApiOperation("æ ¹æ®IDä¿®æ¹") @PostMapping("/updateById") @CloudRequiredPermission("business:wxnoticeconfig:update") public ApiResponse updateById(@RequestBody WxNoticeConfig wxNoticeConfig) { wxNoticeConfigService.updateById(wxNoticeConfig); return ApiResponse.success(null); } @ApiOperation("å页æ¥è¯¢") @PostMapping("/page") @CloudRequiredPermission("business:wxnoticeconfig:query") public ApiResponse<PageData<WxNoticeConfig>> findPage (@RequestBody PageWrap<WxNoticeConfig> pageWrap) { return ApiResponse.success(wxNoticeConfigService.findPage(pageWrap)); } @ApiOperation("导åºExcel") @PostMapping("/exportExcel") @CloudRequiredPermission("business:wxnoticeconfig:exportExcel") public void exportExcel (@RequestBody PageWrap<WxNoticeConfig> pageWrap, HttpServletResponse response) { ExcelExporter.build(WxNoticeConfig.class).export(wxNoticeConfigService.findPage(pageWrap).getRecords(), "å¾®ä¿¡å ¬ä¼å·éç¥é ç½®", response); } @ApiOperation("æ ¹æ®IDæ¥è¯¢") @GetMapping("/{id}") @CloudRequiredPermission("business:wxnoticeconfig:query") public ApiResponse findById(@PathVariable Integer id) { return ApiResponse.success(wxNoticeConfigService.findById(id)); } @ApiOperation("æ¹éç¦å¯ç¨") @GetMapping("/updateStatus/batch") @CloudRequiredPermission("business:wxnoticeconfig:update") public ApiResponse updateStatusBatch(@RequestParam String ids,@RequestParam Integer status) { String [] idArray = ids.split(","); List<Integer> idList = new ArrayList<>(); for (String id : idArray) { idList.add(Integer.valueOf(id)); } wxNoticeConfigService.updateStatusByIdInBatch(idList,status); return ApiResponse.success(null); } } server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatConstants.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,145 @@ package com.doumee.core.wx.wxPlat; import com.doumee.core.utils.Constants; /** * Created by IntelliJ IDEA. * * @Author : Rk * @create 2024/10/17 13:54 */ public class WxPlatConstants { public static final String visit ="1" ; public static final String visitReport ="2" ; public static final String hiddenDanger ="3" ; public static final String carUse ="4" ; public static final String meeting ="5" ; public static final String platformBook ="6" ; public static final String platformJob ="7" ; /** * 访客ç³è¯· */ public interface visitContent{ // æäº¤æåç»ç³è¯·äººï¼ç³è¯·æäº¤æåå¾ å®¡æ ¸ String visitUpload = "visitUpload"; // 审æ¹éè¿ç»ç³è¯·äººï¼ç³è¯·å·²å®¡æ ¸éè¿ String visitAuditSuccess = "visitAuditSuccess"; // 审æ¹é©³åç»ç³è¯·äººï¼ç³è¯·å·²è¢«é©³å String visitAuditFail = "visitWaitAudit"; // ç»å®¡æ¹äººï¼ç³è¯·å¾ æ¨å®¡æ¹ String visitWaitAudit = "visitWaitAudit"; } /** * 访客æ¥å¤ */ public interface visitReportContent{ // æäº¤æåç»ç³è¯·äººï¼ç³è¯·æäº¤æåå¾ å®¡æ ¸ String visitReportUpload = "visitReportUpload"; // 审æ¹éè¿ç»ç³è¯·äººï¼ç³è¯·å·²å®¡æ ¸éè¿ String visitReportAuditSuccess = "visitReportAuditSuccess"; // 审æ¹é©³åç»ç³è¯·äººï¼ç³è¯·å·²è¢«é©³å String visitReportAuditFail = "visitReportAuditFail"; // ç»å®¡æ¹äººï¼ç³è¯·å¾ æ¨å®¡æ¹ String visitReportWaitAudit = "visitReportAuditSuccess"; } /** * 鿣鿿 */ public interface hiddenDangerContent{ //鿣䏿¥éç¥ String hiddenDangerUpload = "hiddenDangerUpload"; //éæ£æ´æ¹éç¥ String hiddenDangerDeal = "hiddenDangerDeal"; } /** * ç¨è½¦ç³è¯· */ public interface carUseBookContent{ //çä¿¡éç¥æ¨¡æ¿ï¼ç»å¤çäººï¼ String carUseBookUpload = "carUseBookUpload"; //ç¨è½¦ç³è¯·-审æ¹éè¿éç¥ï¼ç»ç³è¯·äººï¼ï¼ã String carUseBookAuditSuccess = "carUseBookAuditSuccess"; //ç¨è½¦ç³è¯·-审æ¹é©³åéç¥ï¼ç»ç³è¯·äººï¼ï¼ã String carUseBookAuditFail = "carUseBookAuditFail"; //ç¨è½¦ç³è¯·-审æ¹é©³åéç¥ï¼ç»ç³è¯·äººï¼ï¼ã String carUseBookWaitAudit = "carUseBookWaitAudit"; } /** * ä¼è®®éç¥ */ public interface meetingContent{ //线ä¸ä¼è®®é¢çº¦æåéç¥ String reservationSuccess = "reservationSuccess"; //ä¼è®®åæ¶éç¥ã String meetingCancel = "meetingCancel"; //ä¼è®®å³å°å¼å§æéï¼è®¢é æ¶æ¯ï¼ String meetingBeginA = "meetingBeginA"; //ä¼è®®å³å°ç»ææéï¼è®¢é æ¶æ¯ï¼ String meetingEndA = "meetingEndA"; } /** * ç©æµè½¦é¢çº¦ */ public interface platformBookContent{ // æäº¤æåç»ç³è¯·äººï¼ç³è¯·æäº¤æåå¾ å®¡æ ¸ String platformBookUpload = "platformBookUpload"; // 审æ¹éè¿ç»ç³è¯·äººï¼ç³è¯·å·²å®¡æ ¸éè¿ String platformBookAuditSuccess = "platformBookAuditSuccess"; // 审æ¹é©³åç»ç³è¯·äººï¼ç³è¯·å·²è¢«é©³å String platformBookAuditFail = "platformBookWaitAudit"; // ç»å®¡æ¹äººï¼ç³è¯·å¾ æ¨å®¡æ¹ String platformBookWaitAudit = "platformBookWaitAudit"; } /** * ç©æµä½ä¸ */ public interface platformJobContent{ //ç©æµè½¦é¢çº¦-å«å·å ¥åçå¾ ï¼ç»å¸æºï¼ String platformJobCallIn = "platformJobCallIn"; //ç©æµè½¦é¢çº¦-æå°å«å·ï¼ç»å¸æºï¼ String platformJobSingIn = "platformJobSingIn"; //ç©æµè½¦é¢çº¦-æå°å«å·è¿å·ï¼ç»å¸æºï¼ String platformJobOverNum = "platformJobOverNum"; //ç©æµè½¦é¢çº¦-ä½ä¸å¼å§ï¼ç»å¸æºï¼ String platformJobWorking = "platformJobWorking"; //ç©æµè½¦é¢çº¦-ä½ä¸å®æï¼ç»å¸æºï¼ String platformJobFinish = "platformJobFinish"; //ç©æµè½¦é¢çº¦-ç¦»åææï¼ç»å¸æºï¼ String platformJobLevelPower = "platformJobLevelPower"; //ç©æµè½¦é¢çº¦-æå°è½¬ç§»ï¼ç»å¸æºï¼ String platformJobMove = "platformJobMove"; //ç©æµè½¦é¢çº¦-ä½ä¸å¼å¸¸æèµ·ï¼ç»å¸æºï¼ String platformJobError = "platformJobError"; //ç©æµè½¦é¢çº¦-æå°åé è¶ æ¶ï¼ç»å¸æºï¼ String platformJobTimeOut = "platformJobTimeOut"; //ç©æµè½¦é¢çº¦-æå°åé é误ï¼ç»å¸æºï¼ String platformJobStopErr = "platformJobStopErr"; // è¿è¾ä»»å¡ä¸è¾¾ ï¼ç»å¸æºï¼ String platformJobNewJob = "platformJobNewJob"; } } server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java
@@ -1,6 +1,11 @@ package com.doumee.core.wx.wxPlat; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.doumee.core.utils.Constants; import com.doumee.dao.business.WxNoticeConfigMapper; import com.doumee.dao.business.model.Visits; import com.doumee.dao.business.model.WxNoticeConfig; import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import lombok.extern.slf4j.Slf4j; import me.chanjar.weixin.common.error.WxErrorException; import me.chanjar.weixin.mp.api.WxMpService; @@ -8,6 +13,9 @@ import me.chanjar.weixin.mp.bean.template.WxMpTemplateMessage; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Component; import java.util.List; import java.util.Objects; /** * å¾®ä¿¡å ¬ä¼å·éç¥ @@ -28,8 +36,9 @@ this.wxMpService = wxMpService; } /** * 访客记å½å®¡æ¹ä¸å¡éç¥ * 访客ä¸å¡éç¥æ¥å£ */ public Boolean sendVisitAuditTemplateNotice(Visits visits,String prefix,String tempId){ if(StringUtils.isBlank(visits.getOpenid())){ @@ -40,6 +49,8 @@ .templateId(tempId) .url(prefix + visits.getId()) .build(); String thing1 = "å¾ å®¡æ¹"; if(visits.getStatus()==2){ thing1 = "å®¡æ ¸éè¿"; @@ -66,4 +77,50 @@ } /** * 访客ä¸å¡éç¥ */ public void sendVisitTemplateNotice(WxNoticeConfigMapper wxNoticeConfigMapper,Visits visits,String objCode, String prefix, String tempId, List<String> openIds){ if(CollectionUtils.isNotEmpty(openIds)){ WxNoticeConfig wxNoticeConfig = wxNoticeConfigMapper.selectOne(new QueryWrapper<WxNoticeConfig>().lambda().eq(WxNoticeConfig::getObjType,WxPlatConstants.visit) .eq(WxNoticeConfig::getObjCode,objCode) .eq(WxNoticeConfig::getStatus, Constants.ZERO) .last(" limit 1") ); if(Objects.isNull(wxNoticeConfig)){ return; } WxMpTemplateMessage templateMessage = WxMpTemplateMessage.builder() .toUser(visits.getOpenid()) .templateId(tempId) .url(prefix + visits.getId()) .build(); templateMessage.addData(new WxMpTemplateData("thing1", visits.getName())) .addData(new WxMpTemplateData("car_number7", StringUtils.isBlank(visits.getCarNos())?visits.getCarNos():"-")) .addData(new WxMpTemplateData("character_string6", Constants.equalsInteger(visits.getMemberNum(),Constants.ZERO)?Constants.ONE+"":visits.getMemberNum().toString())) .addData(new WxMpTemplateData("const9", wxNoticeConfig.getTitile())) .addData(new WxMpTemplateData("thing4", visits.getReason())) ; String msgId = null; try { for (String openId:openIds) { templateMessage.setToUser(openId); } // å鿍¡æ¿æ¶æ¯ msgId = wxMpService.getTemplateMsgService().sendTemplateMsg(templateMessage); } catch (WxErrorException e) { e.printStackTrace(); } log.warn("·==++--·æ¨é微信模æ¿ä¿¡æ¯ï¼{}·--++==·", msgId != null ? "æå" : "失败"); } } } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/WxNoticeConfigMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,12 @@ package com.doumee.dao.business; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.doumee.dao.business.model.WxNoticeConfig; /** * @author æ±è¹è¹ * @date 2024/10/17 15:44 */ public interface WxNoticeConfigMapper extends BaseMapper<WxNoticeConfig> { } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/SmsConfig.java
@@ -59,6 +59,10 @@ @ExcelColumn(name="çä¿¡ç¼ç ") private String code; @ApiModelProperty(value = "æ é¢") @ExcelColumn(name="æ é¢") private String name; @ApiModelProperty(value = "çä¿¡å 容") @ExcelColumn(name="çä¿¡å 容") private String content; server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/WxNoticeConfig.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,74 @@ package com.doumee.dao.business.model; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.Date; /** * å¾®ä¿¡å ¬ä¼å·éç¥é ç½® * @author æ±è¹è¹ * @date 2024/10/17 15:44 */ @Data @ApiModel("å¾®ä¿¡å ¬ä¼å·éç¥é ç½®") @TableName("`wx_notice_config`") public class WxNoticeConfig { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主é®", example = "1") @ExcelColumn(name="主é®") private Integer id; @ApiModelProperty(value = "å建人ç¼ç ") @ExcelColumn(name="å建人ç¼ç ") private String creator; @ApiModelProperty(value = "å建æ¶é´") @ExcelColumn(name="å建æ¶é´") @JsonFormat(pattern = "yyyy-MM-dd") private Date createDate; @ApiModelProperty(value = "æ´æ°äººç¼ç ") @ExcelColumn(name="æ´æ°äººç¼ç ") private String edirot; @ApiModelProperty(value = "æ´æ°æ¶é´") @ExcelColumn(name="æ´æ°æ¶é´") @JsonFormat(pattern = "yyyy-MM-dd") private Date editDate; @ApiModelProperty(value = "æ¯å¦å é¤0å¦ 1æ¯", example = "1") @ExcelColumn(name="æ¯å¦å é¤0å¦ 1æ¯") private Integer isdeleted; @ApiModelProperty(value = "夿³¨") @ExcelColumn(name="夿³¨") private String remark; @ApiModelProperty(value = "å¼å¯ç¶æï¼0å¼å¯ï¼1å ³é", example = "1") @ExcelColumn(name="å¼å¯ç¶æï¼0å¼å¯ï¼1å ³é") private Integer status; @ApiModelProperty(value = "模æ¿ID") @ExcelColumn(name="模æ¿ID") private String tempId; @ApiModelProperty(value = "æ é¢(æä¸¾å¼)") @ExcelColumn(name="æ é¢(æä¸¾å¼)") private String titile; @ApiModelProperty(value = "ä¸å¡ç¼ç ") @ExcelColumn(name="ä¸å¡ç¼ç ") private String objCode; @ApiModelProperty(value = "ä¸å¡ç±»å 1=访客ä¸å¡ï¼2=访客æ¥å¤ï¼3=鿣鿿ï¼4=ç¨è½¦ç³è¯·ï¼5=ä¼è®®å®¤ä¿¡æ¯ï¼6=ç©æµè½¦é¢çº¦ï¼7=ç©æµè½¦ä½ä¸", example = "1") @ExcelColumn(name="ä¸å¡ç±»å 1=访客ä¸å¡ï¼2=访客æ¥å¤ï¼3=鿣鿿ï¼4=ç¨è½¦ç³è¯·ï¼5=ä¼è®®å®¤ä¿¡æ¯ï¼6=ç©æµè½¦é¢çº¦ï¼7=ç©æµè½¦ä½ä¸") private Integer objType; } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java
@@ -115,7 +115,7 @@ DriverHomeVO getDriverHome(LoginUserInfo loginUserInfo); /** * è·ç¦»ç¾å° * è·ç¦»ç¾å°Â· * @param signInDTO */ void signIn(SignInDTO signInDTO); server/visits/dmvisit_service/src/main/java/com/doumee/service/business/WxNoticeConfigService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,101 @@ package com.doumee.service.business; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.dao.business.model.WxNoticeConfig; import java.util.List; /** * å¾®ä¿¡å ¬ä¼å·éç¥é ç½®Serviceå®ä¹ * @author æ±è¹è¹ * @date 2024/10/17 15:44 */ public interface WxNoticeConfigService { /** * å建 * * @param wxNoticeConfig å®ä½å¯¹è±¡ * @return Integer */ Integer create(WxNoticeConfig wxNoticeConfig); /** * 主é®å é¤ * * @param id ä¸»é® */ void deleteById(Integer id); /** * å é¤ * * @param wxNoticeConfig å®ä½å¯¹è±¡ */ void delete(WxNoticeConfig wxNoticeConfig); /** * æ¹é主é®å é¤ * * @param ids 主é®é */ void deleteByIdInBatch(List<Integer> ids); /** * 䏻鮿´æ° * * @param wxNoticeConfig å®ä½å¯¹è±¡ */ void updateById(WxNoticeConfig wxNoticeConfig); /** * æ¹é䏻鮿´æ° * * @param wxNoticeConfigs å®ä½é */ void updateByIdInBatch(List<WxNoticeConfig> wxNoticeConfigs); /** * 䏻鮿¥è¯¢ * * @param id ä¸»é® * @return WxNoticeConfig */ WxNoticeConfig findById(Integer id); /** * æ¡ä»¶æ¥è¯¢åæ¡è®°å½ * * @param wxNoticeConfig å®ä½å¯¹è±¡ * @return WxNoticeConfig */ WxNoticeConfig findOne(WxNoticeConfig wxNoticeConfig); /** * æ¡ä»¶æ¥è¯¢ * * @param wxNoticeConfig å®ä½å¯¹è±¡ * @return List<WxNoticeConfig> */ List<WxNoticeConfig> findList(WxNoticeConfig wxNoticeConfig); /** * å页æ¥è¯¢ * * @param pageWrap å页对象 * @return PageData<WxNoticeConfig> */ PageData<WxNoticeConfig> findPage(PageWrap<WxNoticeConfig> pageWrap); /** * æ¡ä»¶ç»è®¡ * * @param wxNoticeConfig å®ä½å¯¹è±¡ * @return long */ long count(WxNoticeConfig wxNoticeConfig); void updateStatusByIdInBatch(List<Integer> ids,Integer status); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/WxNoticeConfigServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,160 @@ package com.doumee.service.business.impl; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Utils; import com.doumee.dao.business.WxNoticeConfigMapper; import com.doumee.dao.business.model.SmsConfig; import com.doumee.dao.business.model.WxNoticeConfig; import com.doumee.service.business.WxNoticeConfigService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.List; import java.util.Objects; /** * å¾®ä¿¡å ¬ä¼å·éç¥é ç½®Serviceå®ç° * @author æ±è¹è¹ * @date 2024/10/17 15:44 */ @Service public class WxNoticeConfigServiceImpl implements WxNoticeConfigService { @Autowired private WxNoticeConfigMapper wxNoticeConfigMapper; @Override public Integer create(WxNoticeConfig wxNoticeConfig) { wxNoticeConfigMapper.insert(wxNoticeConfig); return wxNoticeConfig.getId(); } @Override public void deleteById(Integer id) { wxNoticeConfigMapper.deleteById(id); } @Override public void delete(WxNoticeConfig wxNoticeConfig) { UpdateWrapper<WxNoticeConfig> deleteWrapper = new UpdateWrapper<>(wxNoticeConfig); wxNoticeConfigMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List<Integer> ids) { if (CollectionUtils.isEmpty(ids)) { return; } wxNoticeConfigMapper.deleteBatchIds(ids); } @Override public void updateById(WxNoticeConfig wxNoticeConfig) { wxNoticeConfigMapper.updateById(wxNoticeConfig); } @Override public void updateByIdInBatch(List<WxNoticeConfig> wxNoticeConfigs) { if (CollectionUtils.isEmpty(wxNoticeConfigs)) { return; } for (WxNoticeConfig wxNoticeConfig: wxNoticeConfigs) { this.updateById(wxNoticeConfig); } } @Override public WxNoticeConfig findById(Integer id) { return wxNoticeConfigMapper.selectById(id); } @Override public WxNoticeConfig findOne(WxNoticeConfig wxNoticeConfig) { QueryWrapper<WxNoticeConfig> wrapper = new QueryWrapper<>(wxNoticeConfig); return wxNoticeConfigMapper.selectOne(wrapper); } @Override public List<WxNoticeConfig> findList(WxNoticeConfig wxNoticeConfig) { QueryWrapper<WxNoticeConfig> wrapper = new QueryWrapper<>(wxNoticeConfig); return wxNoticeConfigMapper.selectList(wrapper); } @Override public PageData<WxNoticeConfig> findPage(PageWrap<WxNoticeConfig> pageWrap) { IPage<WxNoticeConfig> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper<WxNoticeConfig> queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.lambda().ge(WxNoticeConfig::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.lambda().le(WxNoticeConfig::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEdirot() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getEdirot, pageWrap.getModel().getEdirot()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.lambda().ge(WxNoticeConfig::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.lambda().le(WxNoticeConfig::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getTempId() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getTempId, pageWrap.getModel().getTempId()); } if (pageWrap.getModel().getTitile() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getTitile, pageWrap.getModel().getTitile()); } if (pageWrap.getModel().getObjCode() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getObjCode, pageWrap.getModel().getObjCode()); } if (pageWrap.getModel().getObjType() != null) { queryWrapper.lambda().eq(WxNoticeConfig::getObjType, pageWrap.getModel().getObjType()); } for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } return PageData.from(wxNoticeConfigMapper.selectPage(page, queryWrapper)); } @Override public long count(WxNoticeConfig wxNoticeConfig) { QueryWrapper<WxNoticeConfig> wrapper = new QueryWrapper<>(wxNoticeConfig); return wxNoticeConfigMapper.selectCount(wrapper); } @Override public void updateStatusByIdInBatch(List<Integer> ids,Integer status) { if (CollectionUtils.isEmpty(ids) || Objects.isNull(status)) { return; } wxNoticeConfigMapper.update(new UpdateWrapper<WxNoticeConfig>() .set("status",status) .in("id",ids) ); } }