| | |
|---|
| | | @Select("SELECT * FROM tour_order WHERE id = #{id} AND deleted = 0 FOR UPDATE") |
|---|
| | | TourOrder selectForUpdate(Long id); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tour_order WHERE refund_order_no = #{refundOrderNo} AND deleted = 0 LIMIT 1 FOR UPDATE") |
|---|
| | | TourOrder selectByRefundOrderNoForUpdate(String refundOrderNo); |
|---|
| | | |
|---|
| | | @Select("SELECT COUNT(*) AS today_order_count, COALESCE(SUM(people_count), 0) AS today_people_count " + |
|---|
| | | "FROM tour_order WHERE deleted = 0 AND guide_id = #{guideId} " + |
|---|
| | | "AND accepted_at >= CURDATE() AND accepted_at < DATE_ADD(CURDATE(), INTERVAL 1 DAY) " + |
|---|
