| | |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.platform.mapper.CheckRuleMapper"> |
| | | |
| | | |
| | | <resultMap type="com.ycl.platform.domain.entity.CheckRule" id="CheckRuleResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="ruleName" column="rule_name" /> |
| | |
| | | <result property="updateTime" column="update_time" /> |
| | | <result property="state" column="state" /> |
| | | <result property="deleted" column="deleted" /> |
| | | <result property="apiUrl" column="api_url" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectCheckRuleVo"> |
| | |
| | | |
| | | <select id="selectCheckRuleList" resultMap="CheckRuleResult"> |
| | | select cr.id, cr.rule_name, cr.rule_index, cr.rule_category, cr.rule_condition, cr.rule_description, |
| | | cr.update_time, cr.state, cr.deleted,cr.icon |
| | | cr.update_time, cr.state, cr.deleted,cr.icon, cr.api_url |
| | | from t_check_rule cr |
| | | <where> |
| | | <where> |
| | | <if test="ruleName != null and ruleName != ''"> and rule_name like concat('%', #{ruleName}, '%')</if> |
| | | <if test="ruleIndex != null and ruleIndex != ''"> and rule_index = #{ruleIndex}</if> |
| | | <if test="ruleCategory != null "> and rule_category = #{ruleCategory}</if> |
| | |
| | | <if test="deleted != null and deleted != ''"> and deleted = #{deleted}</if> |
| | | </where> |
| | | </select> |
| | | |
| | | |
| | | <select id="selectCheckRuleById" resultMap="CheckRuleResult"> |
| | | <include refid="selectCheckRuleVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | |
| | | <insert id="insertCheckRule" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into t_check_rule |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | |
| | | </delete> |
| | | |
| | | <delete id="deleteCheckRuleByIds" > |
| | | delete from t_check_rule where id in |
| | | delete from t_check_rule where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | </mapper> |
| | | </mapper> |