任务 #24332
<p style="width:84.56pf" width="112"> </p>
<table height="3096" style="border-collapse: collapse; width: 787.5pt;" style="border-collapse:collapse; width:787.50pt; border:undefined" width="1050">
<colgroup>
<col style="width:84.56pf" width="112" />
<col width="51" />
<col style="width:170.63pf" width="227" />
<col width="51" />
<col style="width:151.24pf" width="201" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col style="width:77.21pf" width="102" />
</colgroup>
<tbody>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 84pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">表名</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">表名</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">处理方式/tips</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">处理方式/tips</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">涉及功能</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">涉及功能</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">接口用法</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口用法</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 150.75pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">参考sql</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">参考sql</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">php负责人</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">php负责人</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">go负责人</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go负责人</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">模块/服务</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">模块/服务</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">go接口</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go接口</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">进度(0~1)</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">进度(0~1)</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">难度</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">难度</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 76.5pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">备注</span></span></span></span></p>
</td> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">备注</span></span></span></span></span></span></td>
</tr>
<tr height="159"> height="159" style="height:119.25pf">
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_goods_from_supply</span></span></span></p> 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>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.供应商自主上款相关</span></span></span></p> 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>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:150.75pt" width="201"> width="201"> </td>
<p> </p>
</td>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">功能迁移到商城,ERP做转发,需要看商城现有接口是否兼容.</span></span></span></p>
</td> 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="123"> height="123" style="height:92.55pf">
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.获取订单信息用于生成工单(getOrderInfoForServiceOrder)</span></span></span></p> 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></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.根据goods_id获取数据</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">select goods_id from fmys_goods_in_stock where goods_id in (?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select goods_id from fmys_goods_in_stock where goods_id in (?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="142" rowspan="2" style="text-align:general; vertical-align:middle; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetOrderGenerationWork</span></span></span></p> MS"">GetOrderGenerationWork</span></span></span></span></span></span></td>
</td>
<td height="142" rowspan="2" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">erp功能需要拆sql</span></span></span></p>
</td> 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="76"> height="19">
</tr>
<tr height="76" style="height:57.00pf">
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">爆版和小程序商品断货操作,判断商品是不是现货商品(supplyStopGoods)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">爆版和小程序商品断货操作,判断商品是不是现货商品(supplyStopGoods)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">查找根据货号非现货的商品</span></span></span></p> 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>
<td class="et3" height="76" style="vertical-align: middle; height: 57pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT g.goods_id, gl.goods_no, gl.goods_status</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT g.goods_id, gl.goods_no, gl.goods_status</span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="338" rowspan="7" style="text-align:general; vertical-align:middle; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetNonSpotGoods</span></span></span></p> MS"">GetNonSpotGoods</span></span></span></span></span></span></td>
</td>
<td height="338" rowspan="7" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="338" rowspan="7" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">FROM fmys_goods_lib gl</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">FROM fmys_goods_lib gl</span></span></span></span></span></span></td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">JOIN fmys_goods g ON g.goods_no = gl.goods_no</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">JOIN fmys_goods g ON g.goods_no = gl.goods_no</span></span></span></span></span></span></td>
</tr>
<tr height="84"> height="84" style="height:63.00pf">
<td class="et3" height="84" style="vertical-align: middle; height: 63pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:63.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">LEFT JOIN fmys_goods_in_stock gis ON gis.goods_id = g.goods_id</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">LEFT JOIN fmys_goods_in_stock gis ON gis.goods_id = g.goods_id</span></span></span></span></span></span></td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">WHERE gl.goods_status <> g.goods_status</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">WHERE gl.goods_status <> g.goods_status</span></span></span></span></span></span></td>
</tr>
<tr height="71"> height="71" style="height:53.25pf">
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">AND gis.goods_id IS NULL</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">AND gis.goods_id IS NULL</span></span></span></span></span></span></td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">AND gl.goods_no IN (?)</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">AND gl.goods_no IN (?)</span></span></span></span></span></span></td>
</tr>
<tr height="106"> height="106" style="height:79.50pf">
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.脚本,task:AutoSetGoodsLibStockOut</span></span></span></p> 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>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">整个脚本迁移到商城,里面用到的所有表都是商城的....</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="71"> height="71" style="height:53.25pf">
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据断货日志断商品库</span></span></span></p>
</td> 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="106"> height="106" style="height:79.50pf">
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据条件回复上架状态</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">采购版恢复商品上架时,要排除现货商品</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update fmys_goods g left join fmys_goods_in_stock gis on gis.goods_id = g.goods_id set g.goods_status = 1,is_on_sale=1 where g.goods_no = ? and g.goods_status = 2 and gis.goods_is is null</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update fmys_goods g left join fmys_goods_in_stock gis on gis.goods_id = g.goods_id set g.goods_status = 1,is_on_sale=1 where g.goods_no = ? and g.goods_status = 2 and gis.goods_is is null</span></span></span></span></span></span></td>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">UpdateShelfStatus</span></span></span></p> 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>
<td height="106" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="106" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="127"> height="127" style="height:95.25pf">
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_goods_lib_gfs</span></span></span></p> 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>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">自主上款判断是否已经上款,同fmys_goods_from_supply一起迁移到商城(selfAdd,selfEdit,selfDelete,getGoodsList)</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:150.75pt" width="201"> width="201"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">功能迁移,ERP转发,需要看商城现有接口是否兼容.</span></span></span></p>
</td> 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="71"> height="71" style="height:53.25pf">
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_prop_table</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_prop_table</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">爆版获取供应商商品列表(</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取商品的属性,一手独家款等,goods_no必传,其它条件非必传</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">select prop_table_id,goods_no,prop_value_name from fmys_goods_prop_table where goods_no in (?) and prop_value_id = ? and prop_type_id in (?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select prop_table_id,goods_no,prop_value_name from fmys_goods_prop_table where goods_no in (?) and prop_value_id = ? and prop_type_id in (?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="394" rowspan="9" style="text-align:general; vertical-align:middle; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetSupplierProduct</span></span></span></p> MS"">GetSupplierProduct</span></span></span></span></span></span></td>
</td>
<td height="394" rowspan="9" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">erp需要拆sql</span></span></span></p>
</td> 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">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">getSupplyGoodsList)</span></span></span></p>
</td> 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>
</tr>
<tr height="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="88"> height="88" style="height:66.00pf">
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">退换货点货(rejectWaitingTally)</span></span></span></p>
</td> 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="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="88"> height="88" style="height:66.00pf">
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取组合信息:combineInfo</span></span></span></p>
</td> 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="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取商品长短款提示:getGoodsProp</span></span></span></p>
</td> 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="155"> height="155" style="height:116.25pf">
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量写入信息</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">INSERT INTO `fmys_shipping` (`order_id` , `fee` , `weight_shipping_fee` , `shipping_time` , `parcel_weight` , `shipping_name` , `shipping_num` , `shipping_type` , `origin`) VALUES ( ?,?,?,?,?,?,?,?,? )</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT INTO `fmys_shipping` (`order_id` , `fee` , `weight_shipping_fee` , `shipping_time` , `parcel_weight` , `shipping_name` , `shipping_num` , `shipping_type` , `origin`) VALUES ( ?,?,?,?,?,?,?,?,? )</span></span></span></span></span></span></td>
</td>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.InsertBatchShippingInfo</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="155" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="153"> height="153" style="height:114.75pf">
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="color:#e74c3c;"><span style="font-family:宋体">fmys_shipping</span></span></span></p> style="font-size:12.0pt"><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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="153" style="vertical-align: middle; height: 114.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:114.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改已出库的波次快递,批量修改(</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改某行信息</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update fmys_shipping s set SET `s`.`shipping_name` = 'wuliu' , `s`.`shipping_num` = 'JDX004885348755' , `s`.`status` = '0' where s.order_id in (?) and s.shipping_num = ? and s.shipping_name = ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update fmys_shipping s set SET `s`.`shipping_name` = 'wuliu' , `s`.`shipping_num` = 'JDX004885348755' , `s`.`status` = '0' where s.order_id in (?) and s.shipping_num = ? and s.shipping_name = ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateOutboundShippingInfo</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et3" height="36" style="vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">changeShipping</span></span></span></p>
</td> 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="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="88"> height="88" style="height:66.00pf">
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping</span></span></span></p> 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>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">运费监控脚本(_checkPrepayShipping)</span></span></span></p> 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>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据某个时间查询快递费用不对的信息</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et5" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#111f2c"><span style="font-family:宋体">_checkOrderWeight</span></span></span></p>
</td> 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="53"> height="53" style="height:39.75pf">
<td class="et5" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#111f2c"><span style="font-family:宋体">_checkRefundShippingFee</span></span></span></p>
</td> 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 height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et6" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#ff0000"><span style="font-family:宋体">删除脚本,没用了</span></span></span></p>
</td> 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="160"> height="160" style="height:120.00pf">
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量写入</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">INSERT INTO `fmys_shipping_detail` (`shipping_num` , `num` , `order_info_id` , `order_id` , `status` , `create_time`) VALUES ( ?,?,?,?,?,?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT INTO `fmys_shipping_detail` (`shipping_num` , `num` , `order_info_id` , `order_id` , `status` , `create_time`) VALUES ( ?,?,?,?,?,?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.InsertBatchShippingDetailInfo</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="160" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="140"> height="140" style="height:105.30pf">
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="140" style="vertical-align: middle; height: 105pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:105.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次出库插入可分账数据(</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据条件查询</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT `num` FROM `fmys_shipping_detail` WHERE `shipping_num` = ? AND `order_info_id` =? LIMIT 1</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT `num` FROM `fmys_shipping_detail` WHERE `shipping_num` = ? AND `order_info_id` =? LIMIT 1</span></span></span></span></span></span></td>
</td>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.GetOutboundShippingDetailInfo</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="230" rowspan="4" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">setWaitProfitsharing</span></span></span></p>
</td> 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>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="125"> height="125" style="height:93.75pf">
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="color:#e74c3c;"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> style="font-size:12.0pt"><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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="125" style="vertical-align: middle; height: 93.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:93.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改已出库的波次快递,批量修改(</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量更新</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">UPDATE `fmys_shipping_detail` `sd` SET `sd`.`shipping_num` = ? where sd.order_id = ? and sd.order_info_id = ? and sd.shipping_num = ? </span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">UPDATE `fmys_shipping_detail` `sd` SET `sd`.`shipping_num` = ? where sd.order_id = ? and sd.order_info_id = ? and sd.shipping_num = ? </span></span></span></span></span></span></td>
</td>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateOutboundShippingDetailInfo</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateOutboundShippingDetailInfo</span></span></span></span></span></span></td>
</td>
<td height="198" rowspan="4" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et3" height="36" style="vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">changeShipping</span></span></span></p>
</td> 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="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="76"> height="76" style="height:57.00pf">
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="76" style="vertical-align: middle; height: 57pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">仓库批量导入快递信息,批量修改(</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量更新,量大</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update `fmys_shipping_detail` `sd` ` SET `sd`.`sign_time` = ? where sd.shipping_num = ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update `fmys_shipping_detail` `sd` ` SET `sd`.`sign_time` = ? where sd.shipping_num = ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateImportShippingDetailInfo</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateImportShippingDetailInfo</span></span></span></span></span></span></td>
</td>
<td height="113" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">importShippingInfo)</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">importShippingInfo<span style="font-size:12pt"><span style="color:#000000"><span style="font-style:normal"><span style="text-decoration:none">)</span></span></span></span></span></span></span></span></span></span></td>
</tr>
<tr height="194"> height="194" style="height:145.50pf">
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:84.00pt" width="112" x:str=""> x:str=""><span style="font-size:12.0pt"><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></td>
<p><span style="font-size:10px;"><span style="font-family:宋体">fmys_shipping_detail</span></span></p>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="194" style="vertical-align: middle; height: 145.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:145.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">查询今日有无发货数据</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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">含有order_infos表,goods_sku表</span></span></span></span></p> style="font-size:12pt"><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></span></td>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT oi.sku as skuNo,sk.co_val as color,sk.si_val as size,`sd`.`shipping_num`,sd.num as quantity,`oi`.`shop_price`,`oi`.`goods_id`,`oi`.`goods_no` FROM fmys_order_infos oi INNER JOIN `fmys_shipping_detail` `sd` ON `oi`.`rec_id`=`sd`.`order_info_id` INNER JOIN `fmys_goods_sku` `sk` ON `oi`.`sku`=`sk`.`sku` WHERE `oi`.`user_id` = ? AND `sd`.`create_time` >= ? AND `sd`.`create_time` < ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT oi.sku as skuNo,sk.co_val as color,sk.si_val as size,`sd`.`shipping_num`,sd.num as quantity,`oi`.`shop_price`,`oi`.`goods_id`,`oi`.`goods_no` FROM fmys_order_infos oi INNER JOIN `fmys_shipping_detail` `sd` ON `oi`.`rec_id`=`sd`.`order_info_id` INNER JOIN `fmys_goods_sku` `sk` ON `oi`.`sku`=`sk`.`sku` WHERE `oi`.`user_id` = ? AND `sd`.`create_time` >= ? AND `sd`.`create_time` < ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.ListForShippingData</span></span></span></p> 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>
<td height="266" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td height="266" rowspan="3" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">脚本 task:PushGoods</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">脚本 task:PushGoods</span></span></span></span></span></span></td>
</tr>
</tbody>
</table>
<table height="3096" style="border-collapse: collapse; width: 787.5pt;" style="border-collapse:collapse; width:787.50pt; border:undefined" width="1050">
<colgroup>
<col style="width:84.56pf" width="112" />
<col width="51" />
<col style="width:170.63pf" width="227" />
<col width="51" />
<col style="width:151.24pf" width="201" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col style="width:77.21pf" width="102" />
</colgroup>
<tbody>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 84pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">表名</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">表名</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">处理方式/tips</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">处理方式/tips</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">涉及功能</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">涉及功能</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">接口用法</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口用法</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 150.75pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">参考sql</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">参考sql</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">php负责人</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">php负责人</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">go负责人</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go负责人</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">模块/服务</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">模块/服务</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">go接口</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go接口</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">进度(0~1)</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">进度(0~1)</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 38.25pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">难度</span></span></span></span></p> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">难度</span></span></span></span></span></span></td>
</td>
<td class="et2" height="36" style="text-align: center; vertical-align: middle; height: 27pt; width: 76.5pt;" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-family:宋体">备注</span></span></span></span></p>
</td> style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">备注</span></span></span></span></span></span></td>
</tr>
<tr height="159"> height="159" style="height:119.25pf">
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_goods_from_supply</span></span></span></p> 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>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.供应商自主上款相关</span></span></span></p> 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>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:150.75pt" width="201"> width="201"> </td>
<p> </p>
</td>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="159" style="text-align:general; vertical-align:middle; height:119.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="159" style="vertical-align: middle; height: 119.25pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:119.25pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">功能迁移到商城,ERP做转发,需要看商城现有接口是否兼容.</span></span></span></p>
</td> 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="123"> height="123" style="height:92.55pf">
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.获取订单信息用于生成工单(getOrderInfoForServiceOrder)</span></span></span></p> 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></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.根据goods_id获取数据</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">select goods_id from fmys_goods_in_stock where goods_id in (?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select goods_id from fmys_goods_in_stock where goods_id in (?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="142" rowspan="2" style="text-align:general; vertical-align:middle; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetOrderGenerationWork</span></span></span></p> MS"">GetOrderGenerationWork</span></span></span></span></span></span></td>
</td>
<td height="142" rowspan="2" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="142" rowspan="2" style="vertical-align: middle; height: 106.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:106.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">erp功能需要拆sql</span></span></span></p>
</td> 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="76"> height="19">
</tr>
<tr height="76" style="height:57.00pf">
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">爆版和小程序商品断货操作,判断商品是不是现货商品(supplyStopGoods)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">爆版和小程序商品断货操作,判断商品是不是现货商品(supplyStopGoods)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">查找根据货号非现货的商品</span></span></span></p> 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>
<td class="et3" height="76" style="vertical-align: middle; height: 57pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT g.goods_id, gl.goods_no, gl.goods_status</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT g.goods_id, gl.goods_no, gl.goods_status</span></span></span></span></span></span></td>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="338" rowspan="7" style="text-align:general; vertical-align:middle; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetNonSpotGoods</span></span></span></p> MS"">GetNonSpotGoods</span></span></span></span></span></span></td>
</td>
<td height="338" rowspan="7" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="338" rowspan="7" style="vertical-align: middle; height: 253.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:253.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="338" rowspan="7" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">FROM fmys_goods_lib gl</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">FROM fmys_goods_lib gl</span></span></span></span></span></span></td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">JOIN fmys_goods g ON g.goods_no = gl.goods_no</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">JOIN fmys_goods g ON g.goods_no = gl.goods_no</span></span></span></span></span></span></td>
</tr>
<tr height="84"> height="84" style="height:63.00pf">
<td class="et3" height="84" style="vertical-align: middle; height: 63pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:63.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">LEFT JOIN fmys_goods_in_stock gis ON gis.goods_id = g.goods_id</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">LEFT JOIN fmys_goods_in_stock gis ON gis.goods_id = g.goods_id</span></span></span></span></span></span></td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">WHERE gl.goods_status <> g.goods_status</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">WHERE gl.goods_status <> g.goods_status</span></span></span></span></span></span></td>
</tr>
<tr height="71"> height="71" style="height:53.25pf">
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">AND gis.goods_id IS NULL</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">AND gis.goods_id IS NULL</span></span></span></span></span></span></td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">AND gl.goods_no IN (?)</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">AND gl.goods_no IN (?)</span></span></span></span></span></span></td>
</tr>
<tr height="106"> height="106" style="height:79.50pf">
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1.脚本,task:AutoSetGoodsLibStockOut</span></span></span></p> 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>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="196" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="196" rowspan="3" style="vertical-align: middle; height: 147pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:147.00pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">整个脚本迁移到商城,里面用到的所有表都是商城的....</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="71"> height="71" style="height:53.25pf">
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据断货日志断商品库</span></span></span></p>
</td> 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="106"> height="106" style="height:79.50pf">
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_in_stock</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据条件回复上架状态</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">采购版恢复商品上架时,要排除现货商品</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update fmys_goods g left join fmys_goods_in_stock gis on gis.goods_id = g.goods_id set g.goods_status = 1,is_on_sale=1 where g.goods_no = ? and g.goods_status = 2 and gis.goods_is is null</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update fmys_goods g left join fmys_goods_in_stock gis on gis.goods_id = g.goods_id set g.goods_status = 1,is_on_sale=1 where g.goods_no = ? and g.goods_status = 2 and gis.goods_is is null</span></span></span></span></span></span></td>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">UpdateShelfStatus</span></span></span></p> 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>
<td height="106" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="106" style="vertical-align: middle; height: 79.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:79.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="106" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="127"> height="127" style="height:95.25pf">
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_goods_lib_gfs</span></span></span></p> 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>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">自主上款判断是否已经上款,同fmys_goods_from_supply一起迁移到商城(selfAdd,selfEdit,selfDelete,getGoodsList)</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:150.75pt" width="201"> width="201"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et1" height="127" style="text-align:general; vertical-align:middle; height:95.25pt; width:38.25pt" width="51"> width="51"> </td>
<p> </p>
</td>
<td class="et3" height="127" style="vertical-align: middle; height: 95.25pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:95.25pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">功能迁移,ERP转发,需要看商城现有接口是否兼容.</span></span></span></p>
</td> 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="71"> height="71" style="height:53.25pf">
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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="background-color:#f1c40f;">fmys_goods_prop_table</span></span></span></span></p> style="background-color:#f1c40f;">fmys_goods_prop_table</span></span></span></span></span></span></span></td>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="71" style="vertical-align: middle; height: 53.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">爆版获取供应商商品列表(</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取商品的属性,一手独家款等,goods_no必传,其它条件非必传</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">select prop_table_id,goods_no,prop_value_name from fmys_goods_prop_table where goods_no in (?) and prop_value_id = ? and prop_type_id in (?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">select prop_table_id,goods_no,prop_value_name from fmys_goods_prop_table where goods_no in (?) and prop_value_id = ? and prop_type_id in (?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">松辉</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">goods</span></span></span></p> 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>
<td class="et4" height="394" rowspan="9" style="text-align:general; vertical-align:middle; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:10.0pt"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:"Arial Unicode MS"">GetSupplierProduct</span></span></span></p> MS"">GetSupplierProduct</span></span></span></span></span></span></td>
</td>
<td height="394" rowspan="9" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td class="et3" height="394" rowspan="9" style="vertical-align: middle; height: 295.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:295.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">erp需要拆sql</span></span></span></p>
</td> 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">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">getSupplyGoodsList)</span></span></span></p>
</td> 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>
</tr>
<tr height="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="88"> height="88" style="height:66.00pf">
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">退换货点货(rejectWaitingTally)</span></span></span></p>
</td> 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="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="88"> height="88" style="height:66.00pf">
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取组合信息:combineInfo</span></span></span></p>
</td> 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="19">
<td class="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">获取商品长短款提示:getGoodsProp</span></span></span></p>
</td> 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="155"> height="155" style="height:116.25pf">
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量写入信息</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">INSERT INTO `fmys_shipping` (`order_id` , `fee` , `weight_shipping_fee` , `shipping_time` , `parcel_weight` , `shipping_name` , `shipping_num` , `shipping_type` , `origin`) VALUES ( ?,?,?,?,?,?,?,?,? )</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT INTO `fmys_shipping` (`order_id` , `fee` , `weight_shipping_fee` , `shipping_time` , `parcel_weight` , `shipping_name` , `shipping_num` , `shipping_type` , `origin`) VALUES ( ?,?,?,?,?,?,?,?,? )</span></span></span></span></span></span></td>
</td>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.InsertBatchShippingInfo</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="155" style="vertical-align: middle; height: 116.25pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:116.25pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="155" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="153"> height="153" style="height:114.75pf">
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="color:#e74c3c;"><span style="font-family:宋体">fmys_shipping</span></span></span></p> style="font-size:12.0pt"><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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="153" style="vertical-align: middle; height: 114.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:114.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改已出库的波次快递,批量修改(</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改某行信息</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update fmys_shipping s set SET `s`.`shipping_name` = 'wuliu' , `s`.`shipping_num` = 'JDX004885348755' , `s`.`status` = '0' where s.order_id in (?) and s.shipping_num = ? and s.shipping_name = ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update fmys_shipping s set SET `s`.`shipping_name` = 'wuliu' , `s`.`shipping_num` = 'JDX004885348755' , `s`.`status` = '0' where s.order_id in (?) and s.shipping_num = ? and s.shipping_name = ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateOutboundShippingInfo</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td class="et3" height="226" rowspan="4" style="vertical-align: middle; height: 169.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:169.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et3" height="36" style="vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">changeShipping</span></span></span></p>
</td> 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="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="88"> height="88" style="height:66.00pf">
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping</span></span></span></p> 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>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="88" style="vertical-align: middle; height: 66pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">运费监控脚本(_checkPrepayShipping)</span></span></span></p> 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>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据某个时间查询快递费用不对的信息</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td height="250" rowspan="6" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="250" rowspan="6" style="vertical-align: middle; height: 187.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:187.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="250" rowspan="6" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et5" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#111f2c"><span style="font-family:宋体">_checkOrderWeight</span></span></span></p>
</td> 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="53"> height="53" style="height:39.75pf">
<td class="et5" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#111f2c"><span style="font-family:宋体">_checkRefundShippingFee</span></span></span></p>
</td> 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 height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et6" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#ff0000"><span style="font-family:宋体">删除脚本,没用了</span></span></span></p>
</td> 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="160"> height="160" style="height:120.00pf">
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次发货出库批量写入(wavePickingOut)</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量写入</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">INSERT INTO `fmys_shipping_detail` (`shipping_num` , `num` , `order_info_id` , `order_id` , `status` , `create_time`) VALUES ( ?,?,?,?,?,?)</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">INSERT INTO `fmys_shipping_detail` (`shipping_num` , `num` , `order_info_id` , `order_id` , `status` , `create_time`) VALUES ( ?,?,?,?,?,?)</span></span></span></span></span></span></td>
</td>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.InsertBatchShippingDetailInfo</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="160" style="vertical-align: middle; height: 120pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="160" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="140"> height="140" style="height:105.30pf">
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="140" style="vertical-align: middle; height: 105pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:105.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">波次出库插入可分账数据(</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">根据条件查询</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT `num` FROM `fmys_shipping_detail` WHERE `shipping_num` = ? AND `order_info_id` =? LIMIT 1</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT `num` FROM `fmys_shipping_detail` WHERE `shipping_num` = ? AND `order_info_id` =? LIMIT 1</span></span></span></span></span></span></td>
</td>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.GetOutboundShippingDetailInfo</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:num="1">
<p><span style="font-size:10px;"><span x:num="1"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">1</span></span></span></p> 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>
<td class="et3" height="230" rowspan="4" style="vertical-align: middle; height: 172.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td height="230" rowspan="4" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">setWaitProfitsharing</span></span></span></p>
</td> 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>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="125"> height="125" style="height:93.75pf">
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="color:#e74c3c;"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> style="font-size:12.0pt"><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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="125" style="vertical-align: middle; height: 93.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:93.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">修改已出库的波次快递,批量修改(</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量更新</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">UPDATE `fmys_shipping_detail` `sd` SET `sd`.`shipping_num` = ? where sd.order_id = ? and sd.order_info_id = ? and sd.shipping_num = ? </span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">UPDATE `fmys_shipping_detail` `sd` SET `sd`.`shipping_num` = ? where sd.order_id = ? and sd.order_info_id = ? and sd.shipping_num = ? </span></span></span></span></span></span></td>
</td>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateOutboundShippingDetailInfo</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateOutboundShippingDetailInfo</span></span></span></span></span></span></td>
</td>
<td height="198" rowspan="4" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="198" rowspan="4" style="vertical-align: middle; height: 148.5pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:148.50pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="36"> height="36" style="height:27.00pf">
<td class="et3" height="36" style="vertical-align: middle; height: 27pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">changeShipping</span></span></span></p>
</td> 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="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">)</span></span></span></p>
</td> 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="76"> height="76" style="height:57.00pf">
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:84.00pt" width="112" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">fmys_shipping_detail</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口/队列消费</span></span></span></p> 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>
<td class="et3" height="76" style="vertical-align: middle; height: 57pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:57.00pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">仓库批量导入快递信息,批量修改(</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">批量更新,量大</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">update `fmys_shipping_detail` `sd` ` SET `sd`.`sign_time` = ? where sd.shipping_num = ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">update `fmys_shipping_detail` `sd` ` SET `sd`.`sign_time` = ? where sd.shipping_num = ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.UpdateImportShippingDetailInfo</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">logistics.UpdateImportShippingDetailInfo</span></span></span></span></span></span></td>
</td>
<td height="113" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">*</span></span></span></p> 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>
<td class="et3" height="113" rowspan="3" style="vertical-align: middle; height: 84.75pt; width: 76.5pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:84.75pt; width:76.50pt" width="102" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">需要拆sql</span></span></span></p>
</td> 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="et1" height="19" style="text-align:general; vertical-align:middle; height:14.25pt; width:170.25pt" width="227">
<p> </p>
</td> width="227"> </td>
</tr>
<tr height="18"> height="18" style="height:13.50pf">
<td class="et3" height="18" style="vertical-align: middle; height: 13.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:13.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">importShippingInfo)</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">importShippingInfo<span style="font-size:12pt"><span style="color:#000000"><span style="font-style:normal"><span style="text-decoration:none">)</span></span></span></span></span></span></span></span></span></span></td>
</tr>
<tr height="194"> height="194" style="height:145.50pf">
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 84pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:84.00pt" width="112" x:str=""> x:str=""><span style="font-size:12.0pt"><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></td>
<p><span style="font-size:10px;"><span style="font-family:宋体">fmys_shipping_detail</span></span></p>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">接口</span></span></span></p> 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>
<td class="et3" height="194" style="vertical-align: middle; height: 145.5pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:145.50pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">查询今日有无发货数据</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><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">含有order_infos表,goods_sku表</span></span></span></span></p> style="font-size:12pt"><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></span></td>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 150.75pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:150.75pt" width="201" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">SELECT oi.sku as skuNo,sk.co_val as color,sk.si_val as size,`sd`.`shipping_num`,sd.num as quantity,`oi`.`shop_price`,`oi`.`goods_id`,`oi`.`goods_no` FROM fmys_order_infos oi INNER JOIN `fmys_shipping_detail` `sd` ON `oi`.`rec_id`=`sd`.`order_info_id` INNER JOIN `fmys_goods_sku` `sk` ON `oi`.`sku`=`sk`.`sku` WHERE `oi`.`user_id` = ? AND `sd`.`create_time` >= ? AND `sd`.`create_time` < ?</span></span></span></p> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">SELECT oi.sku as skuNo,sk.co_val as color,sk.si_val as size,`sd`.`shipping_num`,sd.num as quantity,`oi`.`shop_price`,`oi`.`goods_id`,`oi`.`goods_no` FROM fmys_order_infos oi INNER JOIN `fmys_shipping_detail` `sd` ON `oi`.`rec_id`=`sd`.`order_info_id` INNER JOIN `fmys_goods_sku` `sk` ON `oi`.`sku`=`sk`.`sku` WHERE `oi`.`user_id` = ? AND `sd`.`create_time` >= ? AND `sd`.`create_time` < ?</span></span></span></span></span></span></td>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">诺曼</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">Lamber</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics</span></span></span></p> 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>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">logistics.ListForShippingData</span></span></span></p> 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>
<td height="266" rowspan="3" style="vertical-align:middle"> style="vertical-align:middle"> </td>
<p> </p>
</td>
<td class="et3" height="266" rowspan="3" style="vertical-align: middle; height: 199.5pt; width: 38.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:199.50pt; width:38.25pt" width="51" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">**</span></span></span></p> 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>
<td height="266" rowspan="3" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle">
<p> </p>
</td> style="vertical-align:middle"> </td>
</tr>
<tr height="53"> height="53" style="height:39.75pf">
<td class="et3" height="53" style="vertical-align: middle; height: 39.75pt; width: 170.25pt;" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:170.25pt" width="227" x:str="">
<p><span style="font-size:10px;"><span x:str=""><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-family:宋体">脚本 task:PushGoods</span></span></span></p>
</td> style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">脚本 task:PushGoods</span></span></span></span></span></span></td>
</tr>
</tbody>
</table>