一手商城需求管理 » 商城技术项目

<p><img alt="" data-rich-file-id="1508" src="/system/rich/rich_files/rich_files/000/001/508/original/20210527141543.jpg" /></p>

<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>runSplitOrderInfosOne<br <td>
<p>mq/接口</p>
</td>
<td>
<hr />
createActivityFeeByOrder<br <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 />
seckillFee<br <p>select id from fmys_supply_activity_fee where order_id = :d and activity_type in ()（in参数会有&#39;1,2&#39;或&#39;3&#39;）<br />
checkOrderShopPrice<br &nbsp;</p>

<hr />
activityFeeList</td> <p>select rec_id, rec_index, sum(if(saf.activity_type &gt;= 3, 0, saf.discount_shop_price)) as discount_shop_price,sum(if(saf.activity_type &gt;= 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 &#39;%%&#39; AND supply_name LIKE &#39;%%&#39; AND brand_name LIKE &#39;%%&#39; AND goods_kh LIKE &#39;%%&#39; 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 &lt;= : d AND activity_end_time &gt;= : d AND create_time &gt;= : d AND create_time &lt;= : 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>
<p>拆分销售单件价格<br <hr />
活动费用单生成和优惠信息调整<br <p>runSplitOrderInfosOne</p>

<hr />
秒杀活动<br <p>createActivityFeeByOrder</p>

<p>seckillFee</p>

<p>checkOrderShopPrice</p>

<p>activityFeeList</p>
</td>
<td>
<hr />
校准订单shop_price的价格<br <p>拆分销售单件价格</p>

<hr />
返回活动费用优惠单</p> <p>活动费用单生成和优惠信息调整</p>

<p>秒杀活动</p>

<p>校准订单shop_price的价格</p>

<p>返回活动费用优惠单</p>
</td>
</tr>
<tr>
<td>
<p>fmys_allot_detail</p>
</td>
<td>
<p>supplementData</p> <p>否</p>
</td>
<td>
<p>select count(*) from fmys_allot_detail where create_time &gt;= :d and create_time &lt; :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 &gt;= :d and create_time &lt; :d and status = 1 group by rec_id</p>
</td>
<td>
<p>supplementData<br />
&nbsp;</p>

<p>getDataDetail</p>
</td>
<td>
<p>自动补充数据</p>

<p>获取交易数据明细列表</p>
</td>
</tr>
</tbody>
</table>

<p>&nbsp;</p> <p><img alt="" data-rich-file-id="1508" src="undefined" /></p>