<?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.qx.dao.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.qx.dao.domain.User">
        <id property="id" column="id" jdbcType="VARCHAR"/>
        <result property="userName" column="user_name" jdbcType="VARCHAR"/>
        <result property="creator" column="creator" jdbcType="VARCHAR"/>
        <result property="createdTime" column="created_time" jdbcType="TIMESTAMP"/>
        <result property="updater" column="updater" jdbcType="VARCHAR"/>
        <result property="updatedTime" column="updated_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        id,user_name,
        creator,created_time,
        updater,updated_time
    </sql>

    <select id="getListByKeyword" resultType="com.qx.dao.domain.User">
        SELECT *
        FROM user
        WHERE
        name like '%${keyword}%'
    </select>

    <!-- 根据条件查询 -->
    <select id="selectByCondition" resultType="com.qx.dao.domain.User">
        SELECT *
        FROM user
        <where>
            <if test="id != null">
                AND id = #{id},
            </if>
            <if test="userName != null">
                AND user_name = #{userName},
            </if>
        </where>
    </select>

    <insert id="insertByEntity" keyColumn="id" keyProperty="id"
            parameterType="com.qx.dao.domain.User" useGeneratedKeys="true">
        insert into user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="userName != null">user_name,</if>
            <if test="creator != null">creator,</if>
            <if test="createdTime != null">created_time,</if>
            <if test="updater != null">updater,</if>
            <if test="updatedTime != null">updated_time,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
<!--            <if test="id != null">#{id,jdbcType=VARCHAR},</if>-->
            <if test="id != null">#{id},</if>
            <if test="userName != null">#{userName},</if>
            <if test="creator != null">#{creator},</if>
            <if test="createdTime != null">#{createdTime},</if>
            <if test="updater != null">#{updater},</if>
            <if test="updatedTime != null">#{updatedTime},</if>
        </trim>
    </insert>

    <!--  -->
    <update id="updateByEntity">
        update user
        <set>
            <if test="userName != null">
                user_name = #{userName},
            </if>
            <if test="creator != null">
                creator = #{creator},
            </if>
            <if test="createdTime != null">
                created_time = #{createdTime},
            </if>
            <if test="updater != null">
                updater = #{updater},
            </if>
            <if test="updatedTime != null">
                updated_time = #{updatedTime},
            </if>
        </set>
        where id = #{id}
    </update>
</mapper>

<select id="selectGroupByJobId" resultType="com.qx.dao.domain.ManuDataSumDTO">
    SELECT
        plm_job_dataid AS jobId,
        SUM(num) AS num,
        SUM(defect) AS defect
    FROM mes_execution_manufacturedata
    WHERE 1 = 1
      AND data_id IN ('646804091774697401', '646804091774697472', '645448035827974144')
    GROUP BY plm_job_dataid;
</select>

<select id="selectGroupByJobId" resultType="com.qx.dao.domain.ManuDataSumDTO">
    SELECT
        plm_job_dataid AS jobId,
        SUM(num) AS num,
        SUM(defect) AS defect
    FROM mes_execution_manufacturedata
    WHERE 1 = 1
    AND data_id IN
    <foreach item="dataId" collection="dataIds" open="(" separator="," close=")">
        #{dataId}
    </foreach>
    GROUP BY plm_job_dataid;
</select>