| | |
|---|
| | | <select id="getGroupBuyBatchInfo" parameterType="Map" resultType="Map"> |
|---|
| | | select t.batch_end_time,t.batch_end_time batchEndTime,t.status_cd,t.status_cd statusCd,t.batch_id,t.batch_id |
|---|
| | | batchId,t.store_id,t.store_id storeId,t.setting_id,t.setting_id settingId,t.batch_start_time,t.batch_start_time |
|---|
| | | batchStartTime,t.cur_batch,t.cur_batch curBatch,t.create_time createName,gbs.group_buy_name groupBuyName |
|---|
| | | batchStartTime,t.cur_batch,t.cur_batch curBatch,t.create_time createTime,gbs.group_buy_name groupBuyName |
|---|
| | | from group_buy_batch t |
|---|
| | | left join group_buy_setting gbs on t.setting_id = gbs.setting_id and t.store_id = gbs.store_id and gbs.status_cd = '0' |
|---|
| | | where 1 =1 |
|---|
