<!--
修改订单状态,变成已撤销 -->
<update id="orderCheckJob" parameterType = "com.bondroo.common.model.OrderInfo">
UPDATE order_info a
<set>
a.order_status = 11,
a.undo_date = NOW()
</set>
<where>
order_status=1 AND
UNIX_TIMESTAMP(NOW())-(UNIX_TIMESTAMP(a.create_date)+ (SELECT b.expire_time FROM scene b WHERE b.scene_id=a.scene_id)) <![CDATA[ >= ]]> 0
</where>
</update>
<update id="orderCheckJob" parameterType = "com.bondroo.common.model.OrderInfo">
UPDATE order_info a
<set>
a.order_status = 11,
a.undo_date = NOW()
</set>
<where>
order_status=1 AND
UNIX_TIMESTAMP(NOW())-(UNIX_TIMESTAMP(a.create_date)+ (SELECT b.expire_time FROM scene b WHERE b.scene_id=a.scene_id)) <![CDATA[ >= ]]> 0
</where>
</update>