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

<table height="531" style="border-collapse:collapse; width:459.00pt; border:undefined" width="612">
<colgroup>
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
<col width="51" />
</colgroup>
<tbody>
<tr height="36" style="height:27.00pf">
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">表名</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">处理方式/tips</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">涉及功能</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">接口用法</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">参考sql</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">php负责人</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go负责人</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">模块/服务</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">go接口</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">进度（0～1）</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">难度</span></span></span></span></span></span></td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><span style="font-size:12.0pt"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:宋体">备注</span></span></span></span></span></span></td>
</tr>
<tr height="176" style="height:132.30pf">
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">fmys_allot_green_order_channel</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td class="et3" height="176" style="text-align:general; vertical-align:middle; white-space:normal; height:132.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">脚本：ModifyBigAllotLevel</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">查询15天内添加到绿色通道的用于订单，对应修改配货优先级</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">select&nbsp;order_id&nbsp;from&nbsp;fmys_allot_green_order_channel&nbsp;where&nbsp;create_time&gt;xxx</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">order/order</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">GetAllotGreenOrderChannel</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:num="0"><span style="font-size:9px;"><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:宋体">0</span></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td class="et3" height="283" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:212.25pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">DDL:ALTER&nbsp;TABLE&nbsp;fmys_allot_green_order_channel&nbsp;add&nbsp;index&nbsp;create_time(create_time),&nbsp;ALGORITHM=INPLACE;</span></span></span></span></span></span></td>
</tr>
<tr height="88" style="height:66.00pf">
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></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:38.25pt" width="51">&nbsp;</td>
</tr>
<tr height="53" style="height:39.75pf">
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">fmys_goods_lib_stock_log</span></span></span></span></span></span></td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="53" style="height:39.75pf">
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">fmys_goods_stock_log</span></span></span></span></span></span></td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="53" style="height:39.75pf">
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">fmys_message_logistics</span></span></span></span></span></span></td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
</tr>
<tr height="53" style="height:39.75pf">
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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:宋体">fmys_public_msg_push</span></span></span></span></span></span></td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td class="et3" height="53" style="text-align:general; vertical-align:middle; white-space:normal; height:39.75pt; width:38.25pt" width="51" x:str=""><span style="font-size:9px;"><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></span></span></span></span></span></td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
<td height="53" style="vertical-align:middle">&nbsp;</td>
</tr>
</tbody>
</table>