采购仓储项目 » erp技术优化

<table height="1130" style="border-collapse:collapse; width:985.50pt; border:undefined" width="1314">
<colgroup>
<col style="width:91.24pf" width="121" />
<col style="width:59.40pf" width="79" />
<col style="width:157.50pf" width="210" />
<col style="width:81.83pf" width="109" />
<col style="width:132.49pf" width="176" />
<col style="width:59.40pf" width="79" />
<col width="79" />
<col width="79" />
<col width="79" />
<col width="79" />
<col style="width:42.49pf" width="56" />
<col style="width:126.26pf" width="168" />
</colgroup>
<tbody>
<tr height="26" style="height:19.50pf">
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">表名</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">处理方式/tips</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">涉及功能</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口用法</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">参考sql</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">php负责人</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go负责人</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">模块/服务</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go接口</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">进度（0～1）</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">难度</span></span></span></span></span></span></td>
<td class="et2" height="26" style="text-align:center; vertical-align:middle; white-space:normal; height:19.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">备注</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_from_supply</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1.供应商自主上款相关</span></span></span></span></span></span></td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:81.75pt" width="109">&nbsp;</td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:132.00pt" width="176">&nbsp;</td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:42.00pt" width="56">&nbsp;</td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">功能迁移到商城,ERP做转发,需要看商城现有接口是否兼容.</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_in_stock</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:157.50pt" width="210" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1.获取订单信息用于生成工单(getOrderInfoForServiceOrder)</span></span></span></span></span></span></p>

<p>erp - 售后工单- 工单列表- 修改</p>
</td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1.根据goods_id获取数据</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select&nbsp;goods_id&nbsp;from&nbsp;fmys_goods_in_stock&nbsp;where&nbsp;goods_id&nbsp;in&nbsp;(?)</span></span></span></span></span></span></p>

<p><span style="color:#e74c3c;"><span style="font-size:9px;"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">商城产品在安排需求干掉这个功能</span></span></span></span></span></span></p>
</td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼(伟权)</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">松辉</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">goods</span></span></span></span></span></span></td>
<td class="et4" height="38" rowspan="2" style="text-align:general; vertical-align:middle; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:&quot;Arial Unicode MS&quot;">GetOrderGenerationWork</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">erp功能需要拆sql</span></span></span></span></span></span></td>
</tr>
<tr height="19">
</tr>
<tr height="19">
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_in_stock</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">爆版和小程序商品断货操作,判断商品是不是现货商品(supplyStopGoods)</span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:81.75pt" width="109" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">查找根据货号非现货的商品</span></span></span></span></span></span></p>

<p>&nbsp;</p>
</td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT&nbsp;g.goods_id,&nbsp;gl.goods_no,&nbsp;gl.goods_status</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼(伟权)</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">松辉</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">goods</span></span></span></span></span></span></td>
<td class="et4" height="133" rowspan="7" style="text-align:general; vertical-align:middle; height:99.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:&quot;Arial Unicode MS&quot;">GetNonSpotGoods</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="133" rowspan="7" style="text-align:general; vertical-align:middle; white-space:normal; height:99.75pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="133" rowspan="7" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">FROM&nbsp;fmys_goods_lib&nbsp;gl</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">JOIN&nbsp;fmys_goods&nbsp;g&nbsp;ON&nbsp;g.goods_no&nbsp;=&nbsp;gl.goods_no</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">LEFT&nbsp;JOIN&nbsp;fmys_goods_in_stock&nbsp;gis&nbsp;ON&nbsp;gis.goods_id&nbsp;=&nbsp;g.goods_id</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">WHERE&nbsp;gl.goods_status&nbsp;&lt;&gt;&nbsp;g.goods_status</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">AND&nbsp;gis.goods_id&nbsp;IS&nbsp;NULL</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str="">
<p><span style="color:#e74c3c;">爆版app---商品助手---断货</span></p>

<p><span style="color:#e74c3c;">档口小程序----商品断货 （sku断货不调go接口，只有整款断才需要）</span></p>
</td>
</tr>
<tr height="19">
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_in_stock</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1.脚本,task:AutoSetGoodsLibStockOut</span></span></span></span></span></span></td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td height="38" rowspan="2" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">整个脚本迁移到商城,里面用到的所有表都是商城的....</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">根据断货日志断商品库</span></span></span></span></span></span></td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_in_stock</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">根据条件回复上架状态</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">采购版 断货或者恢复商品上下架状态（对sku或款）stopOrRevertGoods</span></span></span></span></span></span></p>
</td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">采购版恢复商品上架时,要排除现货商品</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update&nbsp;fmys_goods&nbsp;g&nbsp;left&nbsp;join&nbsp;fmys_goods_in_stock&nbsp;gis&nbsp;on&nbsp;gis.goods_id&nbsp;=&nbsp;g.goods_id&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">set&nbsp;g.goods_status&nbsp;=&nbsp;1,is_on_sale=1&nbsp;where&nbsp;g.goods_no&nbsp;=&nbsp;?</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">&nbsp;and&nbsp;g.goods_status&nbsp;=&nbsp;2&nbsp;and&nbsp;gis.goods_is&nbsp;is&nbsp;null</span></span></span></span></span></span></p>
</td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼（伟权）</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">松辉</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">goods</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">UpdateShelfStatus</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="54" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="56" style="height:42.00pf">
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_lib_gfs</span></span></span></span></span></span></td>
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">自主上款判断是否已经上款,同fmys_goods_from_supply一起迁移到商城(selfAdd,selfEdit,selfDelete,getGoodsList)</span></span></span></span></span></span></td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:81.75pt" width="109">&nbsp;</td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:132.00pt" width="176">&nbsp;</td>
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">goods</span></span></span></span></span></span></td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:59.25pt" width="79">&nbsp;</td>
<td class="et1" height="56" style="text-align:general; vertical-align:middle; height:42.00pt; width:42.00pt" width="56">&nbsp;</td>
<td class="et3" height="56" style="text-align:general; vertical-align:middle; white-space:normal; height:42.00pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">功能迁移,ERP转发,需要看商城现有接口是否兼容.</span></span></span></span></span></span></td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_goods_prop_table</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">爆版获取供应商商品列表(getSupplyGoodsList)</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">获取商品的属性,一手独家款等,goods_no必传,其它条件非必传</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select&nbsp;prop_table_id,goods_no,prop_value_name&nbsp;from&nbsp;fmys_goods_prop_table&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">where&nbsp;goods_no&nbsp;in&nbsp;(?)&nbsp;and&nbsp;prop_value_id&nbsp;=&nbsp;?&nbsp;and&nbsp;prop_type_id&nbsp;in&nbsp;(?)</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1 爆版app--非平台化供应商--商品助手--商品列表</span></span></span></span></span></span></p>

<p>&nbsp;</p>
</td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼（伟权）</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">松辉</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">goods</span></span></span></span></span></span></td>
<td class="et4" height="270" rowspan="5" style="text-align:general; vertical-align:middle; height:202.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:&quot;Arial Unicode MS&quot;">GetSupplierProduct</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">**</span></span></span></span></span></span></td>
<td class="et3" height="270" rowspan="5" style="text-align:general; vertical-align:middle; white-space:normal; height:202.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">erp需要拆sql</span></span></span></span></span></span></td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str="">
<p>&nbsp;</p>
</td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">退换货点货(rejectWaitingTally)</span></span></span></span></span></span></td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">获取组合信息:combineInfo</span></span></span></span></span></span></td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">获取商品长短款提示:getGoodsProp</span></span></span></span></span></span></td>
</tr>
<tr height="72" style="height:54.00pf">
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口/队列消费</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">批量写入信息</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT&nbsp;INTO&nbsp;`fmys_shipping`&nbsp;(`order_id`&nbsp;,&nbsp;`fee`&nbsp;,&nbsp;`weight_shipping_fee`&nbsp;,&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">`shipping_time`&nbsp;,&nbsp;`parcel_weight`&nbsp;,&nbsp;`shipping_name`&nbsp;,&nbsp;`shipping_num`&nbsp;,</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">&nbsp;`shipping_type`&nbsp;,&nbsp;`origin`)&nbsp;VALUES&nbsp;(&nbsp;?,?,?,?,?,?,?,?,?&nbsp;)</span></span></span></span></span></span></p>

<p><span style="color:#e74c3c;"><span style="font-size:9px;"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">要用脚本进行出库，然后日志搜索 运单号</span></span></span></span></span></span></p>
</td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.InsertBatchShippingInfo</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="72" style="text-align:general; vertical-align:middle; white-space:normal; height:54.00pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="72" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="19">
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口/队列消费</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">修改已出库的波次快递,批量修改(</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">修改某行信息</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update&nbsp;fmys_shipping&nbsp;s&nbsp;set&nbsp;SET&nbsp;`s`.`shipping_name`&nbsp;=&nbsp;&#39;wuliu&#39;&nbsp;,&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">`s`.`shipping_num`&nbsp;=&nbsp;&#39;JDX004885348755&#39;&nbsp;,&nbsp;`s`.`status`&nbsp;=&nbsp;&#39;0&#39;&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">where&nbsp;s.order_id&nbsp;in&nbsp;(?)&nbsp;and&nbsp;s.shipping_num&nbsp;=&nbsp;?&nbsp;and&nbsp;s.shipping_name&nbsp;=&nbsp;?</span></span></span></span></span></span></p>
</td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateOutboundShippingInfo</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">**</span></span></span></span></span></span></td>
<td class="et3" height="38" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:28.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">需要拆sql</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">changeShipping</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et3" height="76" rowspan="4" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping</span></span></span></span></span></span></td>
<td class="et3" height="76" rowspan="4" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">运费监控脚本(_checkPrepayShipping)</span></span></span></span></span></span></td>
<td class="et3" height="76" rowspan="4" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">根据某个时间查询快递费用不对的信息</span></span></span></span></span></span></td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="76" rowspan="4" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="76" rowspan="4" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="76" rowspan="4" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="19">
<td class="et5" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#111f2c"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">_checkOrderWeight</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et5" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#111f2c"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">_checkRefundShippingFee</span></span></span></span></span></span></td>
</tr>
<tr height="19">
<td class="et6" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#ff0000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">删除脚本,没用了</span></span></span></span></span></span></td>
</tr>
<tr height="78" style="height:58.50pf">
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口/队列消费</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">批量写入</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT&nbsp;INTO&nbsp;`fmys_shipping_detail`&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">(`shipping_num`&nbsp;,&nbsp;`num`&nbsp;,&nbsp;`order_info_id`&nbsp;,&nbsp;`order_id`&nbsp;,&nbsp;`status`&nbsp;,&nbsp;`create_time`)&nbsp;VALUES&nbsp;(&nbsp;?,?,?,?,?,?)</span></span></span></span></span></span></p>
</td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.InsertBatchShippingDetailInfo</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="78" style="text-align:general; vertical-align:middle; white-space:normal; height:58.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="78" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="19">
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">波次出库插入可分账数据(setWaitProfitsharing）</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">根据条件查询</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT&nbsp;`num`&nbsp;FROM&nbsp;`fmys_shipping_detail`&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">WHERE&nbsp;&nbsp;`shipping_num`&nbsp;=&nbsp;?&nbsp;&nbsp;AND&nbsp;`order_info_id`&nbsp;=?&nbsp;LIMIT&nbsp;1</span></span></span></span></span></span></p>
</td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.GetOutboundShippingDetailInfo</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="19" style="text-align:general; vertical-align:middle; white-space:normal; height:14.25pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td height="19" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="54" style="height:40.50pf">
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">修改已出库的波次快递,批量修改(changeShipping）</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">批量更新</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">UPDATE&nbsp;`fmys_shipping_detail`&nbsp;`sd`&nbsp;&nbsp;SET&nbsp;`sd`.`shipping_num`&nbsp;=&nbsp;?</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">&nbsp;where&nbsp;sd.order_id&nbsp;=&nbsp;?&nbsp;and&nbsp;sd.order_info_id&nbsp;=&nbsp;?&nbsp;and&nbsp;sd.shipping_num&nbsp;=&nbsp;?&nbsp;</span></span></span></span></span></span></p>
</td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼（伟权）</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateBatchObShippingDetailInfo</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td class="et3" height="54" style="text-align:general; vertical-align:middle; white-space:normal; height:40.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">需要拆sql<br />
传参为数组&nbsp;例：<br />
[{&quot;shipping_num&quot;:1,&nbsp;&quot;order_id&quot;:1,&quot;order_info_id&quot;:1,&quot;shipping_num&quot;:1},&nbsp;{&quot;shipping_num&quot;:1,&nbsp;&quot;order_id&quot;:1,&quot;order_info_id&quot;:1,&quot;shipping_num&quot;:1},&nbsp;{&quot;shipping_num&quot;:1,&nbsp;&quot;order_id&quot;:1,&quot;order_info_id&quot;:1,&quot;shipping_num&quot;:1}]</span></span></span></span></span></span></td>
</tr>
<tr height="70" style="height:52.50pf">
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口/队列消费</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">仓库批量导入快递信息,批量修改(importShippingInfo)</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">批量更新,量大</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:132.00pt" width="176" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update&nbsp;`fmys_shipping_detail`&nbsp;`sd`&nbsp;`&nbsp;SET&nbsp;`sd`.`sign_time`&nbsp;=&nbsp;?&nbsp;where&nbsp;sd.shipping_num&nbsp;=&nbsp;?</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼（伟权）</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateBatchImpShippingDetailInfo</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">*</span></span></span></span></span></span></td>
<td class="et3" height="70" style="text-align:general; vertical-align:middle; white-space:normal; height:52.50pt; width:126.00pt" width="168" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">需要拆sql<br />
传参为数组&nbsp;例：&nbsp;<br />
[{&quot;sign_time&quot;:1,&nbsp;&quot;shipping_num&quot;:1},{&quot;sign_time&quot;:1,&nbsp;&quot;shipping_num&quot;:1}]</span></span></span></span></span></span></td>
</tr>
<tr height="89" style="height:66.75pf">
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:90.75pt" width="121" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:157.50pt" width="210" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">查询今日有无发货数据<br />
脚本&nbsp;task:PushGoods</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:81.75pt" width="109" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">查询有无发货数据,<span style="color:#ff0000"><span style="font-style:normal"><span style="text-decoration:none">含有order_infos表,goods_sku表</span></span></span></span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:132.00pt" width="176" x:str="">
<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT&nbsp;oi.sku&nbsp;as&nbsp;skuNo,sk.co_val&nbsp;as&nbsp;color,sk.si_val&nbsp;as&nbsp;size,`sd`.`shipping_num`,</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">sd.num&nbsp;as&nbsp;quantity,`oi`.`shop_price`,`oi`.`goods_id`,`oi`.`goods_no`&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">FROM&nbsp;fmys_order_infos&nbsp;oi&nbsp;INNER&nbsp;JOIN&nbsp;`fmys_shipping_detail`&nbsp;`sd`&nbsp;ON&nbsp;`oi`.`rec_id`=`sd`.`order_info_id`&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INNER&nbsp;JOIN&nbsp;`fmys_goods_sku`&nbsp;`sk`&nbsp;ON&nbsp;`oi`.`sku`=`sk`.`sku`&nbsp;</span></span></span></span></span></span></p>

<p><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">WHERE&nbsp;&nbsp;`oi`.`user_id`&nbsp;=&nbsp;?&nbsp;&nbsp;AND&nbsp;`sd`.`create_time`&nbsp;&gt;=&nbsp;?&nbsp;AND&nbsp;`sd`.`create_time`&nbsp;&lt;&nbsp;?</span></span></span></span></span></span></p>
</td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">诺曼（伟权）</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">Lamber</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.ListForShippingData</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:59.25pt" width="79" x:num="1"><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">1</span></span></span></span></span></span></td>
<td class="et3" height="89" style="text-align:general; vertical-align:middle; white-space:normal; height:66.75pt; width:42.00pt" width="56" x:str=""><span style="font-size:9px;"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">**</span></span></span></span></span></span></td>
<td height="89" style="vertical-align:middle">&nbsp;</td>
</tr>
</tbody>
</table>