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

（开头部分） 6KB

这里只显示每个文件的开头 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.LeaveFormMapper" >
  <resultMap id="BaseResultMap" type="com.yj.oa.project.po.LeaveForm" >

    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="procInstId" property="procInstanId" jdbcType="VARCHAR" />
    <result column="proposer_Id" property="proposer_Id" jdbcType="VARCHAR" />
    <result column="agent_Id" property="agent_Id" jdbcType="VARCHAR" />
    <result column="title" property="title" jdbcType="VARCHAR" />
    <result column="leaveType" property="leaveType" jdbcType="VARCHAR" />
    <result column="leaveContent" property="leaveContent" jdbcType="VARCHAR" />
    <result column="leaveTime" property="leaveTime" jdbcType="TIMESTAMP" />
    <result column="expireTime" property="expireTime" jdbcType="TIMESTAMP" />
    <result column="createTime" property="createTime" jdbcType="TIMESTAMP" />
    <result column="endTime" property="endTime" jdbcType="TIMESTAMP" />
    <result column="reply" property="reply" jdbcType="VARCHAR" />
    <result column="status" property="status" jdbcType="INTEGER" />
    <result column="currDate" property="currDate" jdbcType="DATE" />
  </resultMap>


  <sql id="Base_Column_List" >
     *
  </sql>



  <!--
     统计一个月有多少天请假
  -->
  <select id="selectByUserIdAndDate" resultMap="BaseResultMap" parameterType="LeaveForm">
    SELECT
    <include refid="Base_Column_List"/>
    FROM t_leaveForm t
    <where>

        <if test="proposer_Id !=null and proposer_Id !=''">
          and proposer_Id=#{proposer_Id}
        </if>
        <if test="beginTime !=null">
          <![CDATA[   and DATE_FORMAT(currDate, '%Y-%m-%d') >=  DATE_FORMAT(#{beginTime}, '%Y-%m-%d')   ]]>
        </if>
        <if test="overTime !=null">
          <![CDATA[  and DATE_FORMAT(currDate, '%Y-%m-%d') <= DATE_FORMAT(#{overTime}, '%Y-%m-%d')    ]]>
        </if>

    </where>
  </select>


  <!--查询列表-->
  <select id="selectLeavFormList" resultMap="BaseResultMap" parameterType="LeaveForm">
     SELECT
    <include refid="Base_Column_List"/>
    FROM t_applyroom t
    <where>
      <if test="proposer_Id !null and proposer_Id != ''">
      and proposer_Id=#{proposer_Id},
    </if>
后面还有 160 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。