| | |
|---|
| | | left join shop_product t3 on t2.goods_id=t3.id |
|---|
| | | left join shop_activities_group_price t4 on t1.id=t4.act_id and t4.seq=1 |
|---|
| | | where find_in_set(#{record.shopId}, t1.shop_ids) and t1.act_status=1 and t1.act_type=1 |
|---|
| | | and company_id=#{record.companyId} |
|---|
| | | and t1.company_id=#{record.companyId} |
|---|
| | | <if test="record !=null"><!-- 判断pageVo对象是否为空 --> |
|---|
| | | <if test="record.sort !=null and record.order !=null"> |
|---|
| | | order by |
|---|
| | |
|---|
| | | left join shop_product t3 on t2.goods_id=t3.id |
|---|
| | | left join shop_activities_group_price t4 on t1.id=t4.act_id and t4.seq=1 |
|---|
| | | where find_in_set(#{record.shopId}, t1.shop_ids) and t1.act_status=1 |
|---|
| | | and company_id=#{record.companyId} |
|---|
| | | and t1.company_id=#{record.companyId} |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="selectGroupInfoByActId" resultMap="ShopActivitiesGroupInfoMap"> |
|---|
