在mybatis的mapper.xml中查询为:
<sql id="AbnormalLuggage">
a.id,
a.pass_name,
a.flight_date,
a.is_loss,
a.flight_no,
a.luggage_no,
a.dispose_type ,
a.oper_user_name,
a.status
</sql>
<select id="selectAbnormalLuggagePage" resultType="com.neu.psm.model.vo.AbnormalLuggageVo">
select
<include refid="AbnormalLuggage"></include>,
sum(compensation_amount+nvl(supplement,0)) amountPaid
from ablg_abnormal_luggage a
<where>
<choose>
<when test="disposeType == 1"><!-- 处置类型为少收 -->
a.dispose_type = #{disposeType}
</when>
<when test="disposeType == 2"><!-- 处置类型为破损 -->
a.dispose_type = #{disposeType}
</when>
<otherwise></otherwise>
</choose>
and a.status = '1'
<if test="startFlightDate != null"><!-- 航班日期 -->
and a.flight_date between #{startFlightDate} and #{endFlightDate}
</if>
<if test="isLoss == 1"><!-- 是否遗失:1:是 0:否 -->
and a.is_loss = #{isLoss}
</if>
<if test="passName != null"><!-- 姓名 -->
and a.pass_name = #{passName}
</if>
<if test="luggageNo != null"><!-- 行李号 -->
and a.luggage_no = #{luggageNo}
</if>
</where>
group by
<include refid="AbnormalLuggage"></include>
</select>