| | |
| | | from reserve_goods_order_time t |
| | | left join reserve_goods_order rgo on t.order_id = rgo.order_id and rgo.status_cd='0' |
| | | left join reserve_goods rg on t.goods_id = rg.goods_id and rg.status_cd = '0' |
| | | left join t_dict td on td.table_name = 'reserve_goods_order' and td.table_columns = 'state' |
| | | left join t_dict td on td.table_name = 'reserve_goods_order' and td.table_columns = 'state' and rgo.state = td.status_cd |
| | | where 1 =1 |
| | | <if test="appointmentTime !=null and appointmentTime != ''"> |
| | | and rgo.appointment_time = #{appointmentTime} |