<?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.xxfc.platform.tour.mapper.TourGoodVerificationMapper">

	<!-- 可根据自己的需求，是否要使用 -->
    <resultMap type="com.xxfc.platform.tour.entity.TourGoodVerification" id="tourGoodVerificationMap">
        <result property="id" column="id"/>
        <result property="speId" column="spe_id"/>
        <result property="siteId" column="site_id"/>
        <result property="goodId" column="good_id"/>
        <result property="totalPerson" column="total_person"/>
        <result property="verificationPerson" column="verification_person"/>
        <result property="status" column="status"/>
        <result property="isDel" column="is_del"/>
    </resultMap>

    <update id="delVerification">
        update  tour_good_verification set  is_del=1
        where total_person=0 and verification_person=0
        and good_id=#{goodId}
        <if test="list!=null ">
            and id not in (
            <trim suffixOverrides=",">
                <foreach collection="list" item="id">
                    #{id},
                </foreach>
            </trim>
            )
        </if>
    </update>

    <select id="findVerificationAll" resultType="com.xxfc.platform.tour.vo.TourGoodOrderVo">
       select * from (SELECT v.id as `id`,v.total_person as `headCount`,v.status as `travelStatus`,v.verification_person as `tripOfNum`,g.name as `name`,
        g.cover as `coverUrl`,p.start_time as `startDate`,s.depart_time as `startTime`FROM tour_good_verification v
        LEFT JOIN tour_good_site s ON v.site_id=s.id
        LEFT JOIN tour_good g ON v.good_id=g.id
        LEFT JOIN tour_good_spe_price p ON v.spe_id=p.id
        WHERE s.company_id=#{companyId} and v.status=#{orderStatus} and p.start_time=#{travelDate} ORDER BY s.depart_time ) as `goodOrder`
    </select>
</mapper>