From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001 From: liujie <1793218484@qq.com> Date: 星期一, 09 六月 2025 11:54:00 +0800 Subject: [PATCH] 6.9新增登录失败冻结逻辑 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComExServicemanDAO.java | 61 ++++++++++-------------------- 1 files changed, 20 insertions(+), 41 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComExServicemanDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComExServicemanDAO.java index 374dd4c..e0cdc65 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComExServicemanDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComExServicemanDAO.java @@ -1,22 +1,15 @@ package com.panzhihua.service_community.dao; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.baomidou.mybatisplus.core.metadata.IPage; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.panzhihua.common.model.dtos.community.ComExServicemanDTO; -import com.panzhihua.common.model.dtos.community.ComMngRealCompanyBelongsDTO; -import com.panzhihua.common.model.dtos.community.ExportRealCompanyExcelDTO; -import com.panzhihua.common.model.dtos.community.PageComMngRealCompanyDTO; -import com.panzhihua.common.model.vos.community.ComExServicemanVO; -import com.panzhihua.common.model.vos.community.ComMngRealCompanyBelongsVO; -import com.panzhihua.common.model.vos.community.ComMngRealCompanyExcelVO; -import com.panzhihua.common.model.vos.community.ComMngRealCompanyVO; -import com.panzhihua.service_community.model.dos.ComExServicemanDO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; -import java.util.List; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.panzhihua.common.model.dtos.community.ComExServicemanDTO; +import com.panzhihua.common.model.vos.community.ComExServicemanVO; +import com.panzhihua.service_community.model.dos.ComExServicemanDO; /** * @description: 退役军人 @@ -26,32 +19,18 @@ @Mapper public interface ComExServicemanDAO extends BaseMapper<ComExServicemanDO> { - @Select("<script> " + - " SELECT " + - " id, " + - " com_name AS comName, " + - " legal_person AS legalPerson, " + - " leader, " + - " contacts_phone AS contactsPhone, " + - " scope, " + - " credit_code AS creditCode, " + - " province_adcode AS provinceAdcode, " + - " city_adcode AS cityAdcode, " + - " district_adcode AS districtAdcode, " + - " address, " + - " create_at AS createAt " + - "FROM " + - " com_ex_serviceman where 1=1" + - "<if test='pageComMngRealCompanyDTO.legalPerson != null and pageComMngRealCompanyDTO.legalPerson.trim() != ""'>" + - " and t.legal_person LIKE concat( #{pageComMngRealCompanyDTO.legalPerson}, '%' ) " + - " </if> " + - "<if test='pageComMngRealCompanyDTO.comName != null and pageComMngRealCompanyDTO.comName.trim() != ""'>" + - " and t.com_name LIKE concat( '%',#{pageComMngRealCompanyDTO.comName}, '%' ) " + - " </if> " + - "<if test='pageComMngRealCompanyDTO.communityId != null and pageComMngRealCompanyDTO.communityId != 0'>" + - " and t.community_id = #{pageComMngRealCompanyDTO.communityId} " + - " </if> " + - " order by t.create_at desc" + - "</script>") - IPage<ComExServicemanVO> pageQueryComExServiceman(Page page, @Param(value = "comExServicemanDTO") ComExServicemanDTO comExServicemanDTO); + @Select("<script> " + " SELECT " + " id, " + " com_name AS comName, " + " legal_person AS legalPerson, " + + " leader, " + " contacts_phone AS contactsPhone, " + " scope, " + " credit_code AS creditCode, " + + " province_adcode AS provinceAdcode, " + " city_adcode AS cityAdcode, " + + " district_adcode AS districtAdcode, " + " address, " + " create_at AS createAt " + "FROM " + + " com_ex_serviceman where 1=1" + + "<if test='pageComMngRealCompanyDTO.legalPerson != null and pageComMngRealCompanyDTO.legalPerson.trim() != ""'>" + + " and t.legal_person LIKE concat( #{pageComMngRealCompanyDTO.legalPerson}, '%' ) " + " </if> " + + "<if test='pageComMngRealCompanyDTO.comName != null and pageComMngRealCompanyDTO.comName.trim() != ""'>" + + " and t.com_name LIKE concat( '%',#{pageComMngRealCompanyDTO.comName}, '%' ) " + " </if> " + + "<if test='pageComMngRealCompanyDTO.communityId != null and pageComMngRealCompanyDTO.communityId != 0'>" + + " and t.community_id = ${pageComMngRealCompanyDTO.communityId} " + " </if> " + " order by t.create_at desc" + + "</script>") + IPage<ComExServicemanVO> pageQueryComExServiceman(Page page, + @Param(value = "comExServicemanDTO") ComExServicemanDTO comExServicemanDTO); } -- Gitblit v1.7.1