src/main/resources/mapper/act/ActHiTaskInstMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.yj.oa.project.mapper.ActHiTaskInstMapper" >
  <resultMap id="BaseResultMap" type="com.yj.oa.project.po.ActHiTaskInst" >
    <id column="ID_" property="id" jdbcType="VARCHAR" />
    <result column="PROC_DEF_ID_" property="procDefId" jdbcType="VARCHAR" />
    <result column="TASK_DEF_KEY_" property="taskDefKey" jdbcType="VARCHAR" />
    <result column="PROC_INST_ID_" property="procInstId" jdbcType="VARCHAR" />
    <result column="EXECUTION_ID_" property="executionId" jdbcType="VARCHAR" />
    <result column="NAME_" property="name" jdbcType="VARCHAR" />
    <result column="PARENT_TASK_ID_" property="parentTaskId" jdbcType="VARCHAR" />
    <result column="DESCRIPTION_" property="description" jdbcType="VARCHAR" />
    <result column="OWNER_" property="owner" jdbcType="VARCHAR" />
    <result column="ASSIGNEE_" property="assignee" jdbcType="VARCHAR" />
    <result column="START_TIME_" property="startTime" jdbcType="TIMESTAMP" />
    <result column="CLAIM_TIME_" property="claimTime" jdbcType="TIMESTAMP" />
    <result column="END_TIME_" property="endTime" jdbcType="TIMESTAMP" />
    <result column="DURATION_" property="duration" jdbcType="BIGINT" />
    <result column="DELETE_REASON_" property="deleteReason" jdbcType="VARCHAR" />
    <result column="PRIORITY_" property="priority" jdbcType="INTEGER" />
    <result column="DUE_DATE_" property="dueDate" jdbcType="TIMESTAMP" />
    <result column="FORM_KEY_" property="formKey" jdbcType="VARCHAR" />
    <result column="CATEGORY_" property="category" jdbcType="VARCHAR" />
    <result column="TENANT_ID_" property="tenantId" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    ID_, PROC_DEF_ID_, TASK_DEF_KEY_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, 
    DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, 
    DELETE_REASON_, PRIORITY_, DUE_DATE_, FORM_KEY_, CATEGORY_, TENANT_ID_
  </sql>

  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from act_hi_taskinst
    where ID_ = #{id,jdbcType=VARCHAR}
  </select>

  <select id="selectActHiTaskInstList" parameterType="ActHiTaskInst" resultMap="BaseResultMap">
    SELECT <include refid="Base_Column_List"/>
    FROM act_hi_taskinst
    <where>
      <if test="id !=null ">
        and ID_ LIKE concat('%',#{id},'%')
      </if>

      <if test="name !=null and name !=''">
        and NAME_ like concat('%',#{name},'%')
      </if>

      <if test="procInstId !=null and procInstId !=''">
        and PROC_INST_ID_ like concat('%',#{procInstId},'%')
      </if>

      <if test="description !=null and description !=''">
        and DESCRIPTION_ like concat('%',#{description},'%')
      </if>

      <if test="beginTime!=null">
        and #{beginTime} &lt;= START_TIME_