任务 #24289
<table border="1" cellpadding="1" cellspacing="1" style="width:100%;">
<tbody>
<tr>
<td>表名</td>
<td>冗余</td>
<td>sql</td>
<td>接口</td>
<td>功能</td>
</tr>
<tr>
<td>
<p>fmys_supply_activity_fee</p>
</td>
<td>
<p>mq/接口</p>
</td>
<td>
<hr />
<p>select rec_id,rec_index,shop_price from fmys_supply_activity_fee where rec_id in () group by rec_id, rec_index</p>
<hr />
<p>select id from fmys_supply_activity_fee where order_id = :d and activity_type in ()（in参数会有'1,2'或'3'）<br />
</p>
<hr />
<p>select rec_id, rec_index, sum(if(saf.activity_type >= 3, 0, saf.discount_shop_price)) as discount_shop_price,sum(if(saf.activity_type >= 3, 0, saf.yishou_discount_shop_price)) as yishou_discount_shop_price from fmys_supply_activity_fee WHERE rec_id in () group by rec_id, rec_index</p>
<hr />
<p>SELECT *, count(id) AS buy_num , sum(shop_price) AS sale_amount , sum(discount_shop_price) AS supply_discount , sum(yishou_discount_shop_price) AS yishou_discount , sum(supply_fee) AS supply_fee , sum(yishou_fee) AS yishou_fee FROM fmys_supply_activity_fee WHERE activity_name LIKE '%%' AND supply_name LIKE '%%' AND brand_name LIKE '%%' AND goods_kh LIKE '%%' AND supply_id = : d AND activity_id = : d AND activity_type = : d AND order_id = : d AND goods_no = : d AND sku = : d AND activity_start_time <= : d AND activity_end_time >= : d AND create_time >= : d AND create_time <= : d group by order_id , activity_id , activity_type , sku order by id desc limit 0,10（每个where条件都为可选，activity_start_time或create_time为绑定条件，做分页且返回总数）</p>
</td>
<td>
<hr />
<p>runSplitOrderInfosOne</p>
<hr />
<p>createActivityFeeByOrder</p>
<p>seckillFee</p>
<p>checkOrderShopPrice</p>
<p>activityFeeList</p>
</td>
<td>
<hr />
<p>拆分销售单件价格</p>
<hr />
<p>活动费用单生成和优惠信息调整</p>
<p>秒杀活动</p>
<p>校准订单shop_price的价格</p>
<p>返回活动费用优惠单</p>
</td>
</tr>
<tr>
<td>
<p>fmys_allot_detail</p>
</td>
<td>
<p>否</p>
</td>
<td>
<p>select count(*) from fmys_allot_detail where create_time >= :d and create_time < :d and rec_id in () and status = 1</p>
<p>select create_time,rec_id from fmys_allot_detail where rec_id in () and status = 1</p>
<p>select count(*),rec_id as allot_num from fmys_allot_detail where create_time >= :d and create_time < :d and status = 1 group by rec_id</p>
</td>
<td>
<p>supplementData<br />
</p>
<p>getDataDetail</p>
</td>
<td>
<p>获取交易数据明细列表</p>
</td>
</tr>
</tbody>
</table>
<p> </p>
<tbody>
<tr>
<td>表名</td>
<td>冗余</td>
<td>sql</td>
<td>接口</td>
<td>功能</td>
</tr>
<tr>
<td>
<p>fmys_supply_activity_fee</p>
</td>
<td>
<p>mq/接口</p>
</td>
<td>
<hr />
<p>select rec_id,rec_index,shop_price from fmys_supply_activity_fee where rec_id in () group by rec_id, rec_index</p>
<hr />
<p>select id from fmys_supply_activity_fee where order_id = :d and activity_type in ()（in参数会有'1,2'或'3'）<br />
</p>
<hr />
<p>select rec_id, rec_index, sum(if(saf.activity_type >= 3, 0, saf.discount_shop_price)) as discount_shop_price,sum(if(saf.activity_type >= 3, 0, saf.yishou_discount_shop_price)) as yishou_discount_shop_price from fmys_supply_activity_fee WHERE rec_id in () group by rec_id, rec_index</p>
<hr />
<p>SELECT *, count(id) AS buy_num , sum(shop_price) AS sale_amount , sum(discount_shop_price) AS supply_discount , sum(yishou_discount_shop_price) AS yishou_discount , sum(supply_fee) AS supply_fee , sum(yishou_fee) AS yishou_fee FROM fmys_supply_activity_fee WHERE activity_name LIKE '%%' AND supply_name LIKE '%%' AND brand_name LIKE '%%' AND goods_kh LIKE '%%' AND supply_id = : d AND activity_id = : d AND activity_type = : d AND order_id = : d AND goods_no = : d AND sku = : d AND activity_start_time <= : d AND activity_end_time >= : d AND create_time >= : d AND create_time <= : d group by order_id , activity_id , activity_type , sku order by id desc limit 0,10（每个where条件都为可选，activity_start_time或create_time为绑定条件，做分页且返回总数）</p>
</td>
<td>
<hr />
<p>runSplitOrderInfosOne</p>
<hr />
<p>createActivityFeeByOrder</p>
<p>seckillFee</p>
<p>checkOrderShopPrice</p>
<p>activityFeeList</p>
</td>
<td>
<hr />
<p>拆分销售单件价格</p>
<hr />
<p>活动费用单生成和优惠信息调整</p>
<p>秒杀活动</p>
<p>校准订单shop_price的价格</p>
<p>返回活动费用优惠单</p>
</td>
</tr>
<tr>
<td>
<p>fmys_allot_detail</p>
</td>
<td>
<p>否</p>
</td>
<td>
<p>select count(*) from fmys_allot_detail where create_time >= :d and create_time < :d and rec_id in () and status = 1</p>
<p>select create_time,rec_id from fmys_allot_detail where rec_id in () and status = 1</p>
<p>select count(*),rec_id as allot_num from fmys_allot_detail where create_time >= :d and create_time < :d and status = 1 group by rec_id</p>
</td>
<td>
<p>supplementData<br />
</p>
<p>getDataDetail</p>
</td>
<td>
<p>获取交易数据明细列表</p>
</td>
</tr>
</tbody>
</table>
<p> </p>
