审核分页添加查询

mg

2022-10-21 aaa4300122c220333376d0ca5a63534a20a541e1

审核分页添加查询

 ycl-platform/src/main/java/com/ycl/entity/message/SmsAudit.java

@@ -88,4 +88,31 @@
    @TableField("update_time")
    @ApiModelProperty(value = "更新时间")
    private Date updateTime;


    /**
     * 审核人文本
     */
    @ApiModelProperty(value = "审核人文本")
    @TableField(value = "audit_text",exist = false)
    private String auditText;
    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    @TableField(value = "title",exist = false)
    private String title;
    /**
     * 消息体
     */
    @ApiModelProperty(value = "消息体")
    @TableField(value = "body",exist = false)
    private String body;
    /**
     * 创建人文本
     */
    @ApiModelProperty(value = "创建人文本")
    @TableField(value = "create_user_text",exist = false)
    private String createUserText;

}

 ycl-platform/src/main/java/com/ycl/mapper/message/SmsAuditMapper.java

@@ -1,7 +1,9 @@
package com.ycl.mapper.message;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.message.SmsAudit;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
@@ -12,4 +14,7 @@
 * @since 2022-10-17
 */
public interface SmsAuditMapper extends BaseMapper<SmsAudit> {


    Page<SmsAudit> selectCondPage(Page<?> page,@Param("smsAudit") SmsAudit smsAudit);
}

 ycl-platform/src/main/java/com/ycl/service/message/impl/SmsAuditServiceImpl.java

@@ -33,7 +33,7 @@
    @Override
    public IPage<SmsAudit> list(SmsAudit smsAudit) {
        Page<SmsAudit> page = new Page<>(smsAudit.getCurrent(), smsAudit.getPageSize());
        LambdaQueryWrapper<SmsAudit> queryWrapper = new LambdaQueryWrapper<>();
        /*LambdaQueryWrapper<SmsAudit> queryWrapper = new LambdaQueryWrapper<>();
        if (smsAudit.getAuditId() != null) {
            queryWrapper.eq(SmsAudit::getAuditId, smsAudit.getAuditId());
        }
@@ -41,7 +41,8 @@
            queryWrapper.eq(SmsAudit::getAuditStatus, smsAudit.getAuditStatus());
        }
        queryWrapper.orderByDesc(SmsAudit::getCreateTime);
        Page<SmsAudit> result = baseMapper.selectPage(page, queryWrapper);
        Page<SmsAudit> result = baseMapper.selectPage(page, queryWrapper);*/
        Page<SmsAudit> result = baseMapper.selectCondPage(page, smsAudit);
        return result;
    }


 ycl-platform/src/main/resources/mapper/message/SmsAuditMapper.xml

New file
@@ -0,0 +1,51 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ycl.mapper.message.SmsAuditMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ycl.entity.message.SmsAudit">
        <id column="id" property="id"/>
        <result column="message_id" property="messageId"/>
        <result column="audit_id" property="auditId"/>
        <result column="audit_status" property="auditStatus"/>
        <result column="audit_result" property="auditResult"/>
        <result column="audit_opinion" property="auditOpinion"/>
        <result column="create_user" property="createUser"/>
        <result column="create_time" property="createTime"/>
        <result column="update_user" property="updateUser"/>
        <result column="update_time" property="updateTime"/>
    </resultMap>
    <resultMap type="com.ycl.entity.message.SmsAudit" id="CondMapResultMap" extends="BaseResultMap">
        <result column="audit_text" property="auditText"/>
        <result column="title" property="title"/>
        <result column="body" property="body"/>
        <result column="create_user_text" property="createUserText"/>
    </resultMap>

    <select id="selectCondPage" parameterType="com.ycl.entity.message.SmsAudit" resultMap="CondMapResultMap">
        SELECT
            usa.*,
            um.head title,
            um.body,
            ua.username audit_text,
            ua2.username create_user_text
        FROM
            ums_sms_audit usa
                LEFT JOIN ums_message um ON usa.message_id = um.id
                LEFT JOIN ums_admin ua ON usa.audit_id = ua.id
                LEFT JOIN ums_admin ua2 ON usa.create_user = ua2.id
        where 1=1
        <if test="smsAudit.auditId !=null and smsAudit.auditId >=0 ">
            AND usa.audit_id = #{smsAudit.auditId}
        </if>
        <if test="smsAudit.messageId !=null and smsAudit.messageId >=0 ">
            AND usa.message_id = #{smsAudit.messageId}
        </if>
        <if test="smsAudit.auditStatus !=null and smsAudit.auditStatus >= 0">
            AND usa.audit_status = #{smsAudit.auditStatus}
        </if>
        ORDER BY
            usa.create_time DESC
    </select>

</mapper>