Subversion Repositories SmartDukaan

<?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="in.shop2020.crm.persistence.TicketMapper">

  <resultMap type="ticket" id="ticketResult">

    <id property="id" column="id"/>

  </resultMap>

  <insert id="insertTicket" parameterType="ticket" useGeneratedKeys="true" keyProperty="id">

    INSERT INTO ticket

      (customerId, openDate, closeDate, receipientId, creatorId, subject, productName, airwayBillNo, orderId)

    VALUES

      (#{customerId}, #{openDate},  #{closeDate},  #{receipientId},  #{creatorId}, #{subject}, #{productName}, #{airwayBillNo}, #{orderId})

  </insert>

  <update id="updateTicket" parameterType="ticket">

    UPDATE ticket

    SET

    <if test="subject != null">

      subject = #{subject},

    </if>

    closeDate = #{closeDate}

    WHERE id = #{id}

  </update>

  <select id="getTickets" parameterType="long" resultType="ticket">

    SELECT * FROM ticket

    WHERE customerId = #{customerId}

    ORDER BY openDate DESC

  </select>

  <select id="getTicket" parameterType="long" resultType="ticket">

    SELECT * FROM ticket

    WHERE id = #{ticketId}

  </select>

</mapper>