任务 #24291
<table width="1430">
<colgroup>
<col width="251" />
<col width="76" />
<col width="671" />
<col width="250" />
<col width="182" />
</colgroup>
<tbody>
<tr height="21">
<td height="21" width="251">表名</td>
<td width="76">冗余</td>
<td width="671">sql</td>
<td width="250">接口</td>
<td width="182">功能</td>
</tr>
<tr height="21">
<td height="105" rowspan="5">
<p>fmys_supply_portrait</p>
</td>
<td rowspan="5">否</td>
<td rowspan="5">
<p>select 30_end_allot_rates, amount,cop_time from fmys_supply_protrait where supply_id in ?</p>
</td>
<td>
<p>batchModifyStock</p>
</td>
<td>
<p>批量修改库存</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>autoAddSupplyEs</p>
</td>
<td>
<p>添加供应商到es，脚本</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getGoodsInfoV2</p>
</td>
<td>
<p>商详</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getSupplyFollowList</p>
</td>
<td>
<p>收藏供应商列表</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getPraiseBrandList</p>
<p>getMarketSupplyList</p>
<p>getSupplyQualityRank</p>
</td>
<td>
<p>口碑档口</p>
<p>一批最火档口</p>
<p>统计档口质量榜数据</p>
</td>
</tr>
<tr height="21">
<td height="63" rowspan="3">fmys_storage_stock_detail</td>
<td rowspan="3">是</td>
<td rowspan="3"> </td>
<td>
<pre>
updateStrategy</pre>
</td>
<td>编辑策略模板</td>
</tr>
<tr height="21">
<td height="21">
<pre>
changeStatus</pre>
</td>
<td>修改模板状态</td>
</tr>
<tr height="21">
<td height="21">
<pre>
setGoodsRule</pre>
</td>
<td>
<pre>
设置选品规则缓存</pre>
</td>
</tr>
<tr>
<td height="63">
<p>fmys_wcg_plan_goods_schedule</p>
</td>
<td>否</td>
<td>select paln_billing_avg, order_stockin_avg, promise_probability,goods_no from wcg_plan_goods_schedule where goods_no in ?</td>
<td height="21">
<pre>
getGoodsLibList</pre>
</td>
<td>获取商品库列表</td>
</tr>
</tbody>
</table>
<colgroup>
<col width="251" />
<col width="76" />
<col width="671" />
<col width="250" />
<col width="182" />
</colgroup>
<tbody>
<tr height="21">
<td height="21" width="251">表名</td>
<td width="76">冗余</td>
<td width="671">sql</td>
<td width="250">接口</td>
<td width="182">功能</td>
</tr>
<tr height="21">
<td height="105" rowspan="5">
<p>fmys_supply_portrait</p>
</td>
<td rowspan="5">否</td>
<td rowspan="5">
<p>select 30_end_allot_rates, amount,cop_time from fmys_supply_protrait where supply_id in ?</p>
</td>
<td>
<p>batchModifyStock</p>
</td>
<td>
<p>批量修改库存</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>autoAddSupplyEs</p>
</td>
<td>
<p>添加供应商到es，脚本</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getGoodsInfoV2</p>
</td>
<td>
<p>商详</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getSupplyFollowList</p>
</td>
<td>
<p>收藏供应商列表</p>
</td>
</tr>
<tr height="21">
<td height="21">
<p>getPraiseBrandList</p>
<p>getMarketSupplyList</p>
<p>getSupplyQualityRank</p>
</td>
<td>
<p>口碑档口</p>
<p>一批最火档口</p>
<p>统计档口质量榜数据</p>
</td>
</tr>
<tr height="21">
<td height="63" rowspan="3">fmys_storage_stock_detail</td>
<td rowspan="3">是</td>
<td rowspan="3"> </td>
<td>
<pre>
updateStrategy</pre>
</td>
<td>编辑策略模板</td>
</tr>
<tr height="21">
<td height="21">
<pre>
changeStatus</pre>
</td>
<td>修改模板状态</td>
</tr>
<tr height="21">
<td height="21">
<pre>
setGoodsRule</pre>
</td>
<td>
<pre>
设置选品规则缓存</pre>
</td>
</tr>
<tr>
<td height="63">
<p>fmys_wcg_plan_goods_schedule</p>
</td>
<td>否</td>
<td>select paln_billing_avg, order_stockin_avg, promise_probability,goods_no from wcg_plan_goods_schedule where goods_no in ?</td>
<td height="21">
<pre>
getGoodsLibList</pre>
</td>
<td>获取商品库列表</td>
</tr>
</tbody>
</table>
