任务 #24334: 拆分三期----如貂 - erp技术优化 - 一手-项目管理

任务 #24334

<table height="867" style="border-collapse:collapse; width:866.25pt; border:undefined" width="1155">
<colgroup>
<col style="width:84.56pf" width="112" />
<col width="51" />
<col style="width:170.63pf" width="227" />
<col style="width:85.76pf" width="114" />
<col style="width:151.24pf" width="201" />
<col width="51" />
<col width="51" />
<col width="51" />
<col style="width:69.86pf" width="93" />
<col width="51" />
<col width="51" />
<col style="width:77.21pf" width="102" />
</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:84.00pt" width="112" x:str="">表名</td> style="font-family:宋体">表名</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="">处理方式/tips</td> style="font-family:宋体">处理方式/tips</td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:170.25pt" width="227" x:str="">涉及功能</td> style="font-family:宋体">涉及功能</td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:85.50pt" width="114" x:str="">接口用法</td> style="font-family:宋体">接口用法</td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:150.75pt" width="201" x:str="">参考sql</td> style="font-family:宋体">参考sql</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="">php负责人</td> style="font-family:宋体">php负责人</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="">go负责人</td> style="font-family:宋体">go负责人</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="">模块/服务</td> style="font-family:宋体">模块/服务</td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:69.75pt" width="93" x:str="">go接口</td> style="font-family:宋体">go接口</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="">进度（0～1）</td> style="font-family:宋体">进度（0～1）</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="">难度</td> style="font-family:宋体">难度</td>
<td class="et2" height="36" style="text-align:center; vertical-align:middle; white-space:normal; height:27.00pt; width:76.50pt" width="102" x:str="">备注</td> style="font-family:宋体">备注</td>
</tr>
<tr height="141" style="height:106.05pf">
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:84.00pt" width="112" x:str="">fmys_goods_reminder</td> style="font-family:宋体">fmys_goods_reminder</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">接口</td> style="font-family:宋体">接口</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:170.25pt" width="227" x:str="">编辑预计回货天数(editEstimatedReturnTime)</td> style="font-family:宋体">编辑预计回货天数(editEstimatedReturnTime)</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:85.50pt" width="114" x:str="">取消客服催单</td> style="font-family:宋体">取消客服催单</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:150.75pt" width="201" x:str="">update fmys_goods_reminder set is_reminder = 0 where goods_no = :d</td> style="font-family:宋体">update fmys_goods_reminder set is_reminder = 0 where goods_no = :d</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">雅木茶</td> style="font-family:宋体">雅木茶</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">松辉</td> style="font-family:宋体">松辉</td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">goods</td> style="font-family:宋体">goods</td>
<td class="et4" height="160" rowspan="2" style="text-align:general; vertical-align:middle; height:120.00pt; width:69.75pt" width="93" x:str="">UpdateGoodsReminder</td> MS"">UpdateGoodsReminder</td>
<td height="160" rowspan="2" style="vertical-align:middle"> </td>
<td class="et3" height="160" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:120.00pt; width:38.25pt" width="51" x:str="">*</td> style="font-family:宋体">*</td>
<td height="160" rowspan="2" style="vertical-align:middle"> </td>
</tr>
<tr height="19">
</tr>
<tr height="140" style="height:105.30pf">
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:84.00pt" width="112" x:str="">fmys_goods_reminder</td> style="font-family:宋体">fmys_goods_reminder</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">接口</td> style="font-family:宋体">接口</td>
<td class="et3" height="140" style="text-align:general; vertical-align:middle; white-space:normal; height:105.00pt; width:170.25pt" width="227" x:str="">采购app: 供应商欠货列表(supplyOweGoods)</td> style="font-family:宋体">采购app: 供应商欠货列表(supplyOweGoods)</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:85.50pt" width="114" x:str="">查询货号是否有客服催单</td> style="font-family:宋体">查询货号是否有客服催单</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:150.75pt" width="201" x:str="">select goods_no,is_reminder,update_time,add_time from fmys_goods_reminder where goods_no in (:d)</td> style="font-family:宋体">select goods_no,is_reminder,update_time,add_time from fmys_goods_reminder where goods_no in (:d)</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">雅木茶</td> style="font-family:宋体">雅木茶</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">松辉</td> style="font-family:宋体">松辉</td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">goods</td> style="font-family:宋体">goods</td>
<td class="et4" height="230" rowspan="3" style="text-align:general; vertical-align:middle; height:172.50pt; width:69.75pt" width="93" x:str="">GetGoodsReminder</td> MS"">GetGoodsReminder</td>
<td height="230" rowspan="3" style="vertical-align:middle"> </td>
<td class="et3" height="230" rowspan="3" style="text-align:general; vertical-align:middle; white-space:normal; height:172.50pt; width:38.25pt" width="51" x:str="">*</td> style="font-family:宋体">*</td>
<td height="230" rowspan="3" style="vertical-align:middle"> </td>
</tr>
<tr height="71" style="height:53.25pf">
<td class="et3" height="71" style="text-align:general; vertical-align:middle; white-space:normal; height:53.25pt; width:170.25pt" width="227" x:str="">排单情况列表(scheduleList)</td> style="font-family:宋体">排单情况列表(scheduleList)</td>
</tr>
<tr height="19">
<td height="19" style="vertical-align:middle"> </td>
</tr>
<tr height="141" style="height:105.75pf">
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:84.00pt" width="112" x:str="">fmys_seckill</td> style="font-family:宋体">fmys_seckill</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:str="">接口</td> style="font-family:宋体">接口</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:170.25pt" width="227" x:str="">爆版: 活动优惠清单(getActivityList)</td> style="font-family:宋体">爆版: 活动优惠清单(getActivityList)</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:85.50pt" width="114" x:str="">获取活动的创建人</td> style="font-family:宋体">获取活动的创建人</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:150.75pt" width="201" x:str="">select admin_id from fmys_seckill where seckill_id in (:d)</td> style="font-family:宋体">select admin_id from fmys_seckill where seckill_id in (:d)</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:str="">雅木茶</td> style="font-family:宋体">雅木茶</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:str="">Lamber</td> style="font-family:宋体">Lamber</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:str="">activity</td> style="font-family:宋体">activity</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:69.75pt" width="93" x:str="">activity.ListCreatorOfActivities</td> style="font-family:宋体">activity.ListCreatorOfActivities</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:num="1">1</td> style="font-family:宋体">1</td>
<td class="et3" height="141" style="text-align:general; vertical-align:middle; white-space:normal; height:105.75pt; width:38.25pt" width="51" x:str="">*</td> style="font-family:宋体">*</td>
<td height="141" style="vertical-align:middle"> </td>
</tr>
<tr height="88" style="height:66.00pf">
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:84.00pt" width="112" x:str="">fmys_special_work_arrange</td> style="font-family:宋体">fmys_special_work_arrange</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:38.25pt" width="51" x:str="">接口</td> style="font-family:宋体">接口</td>
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">更新主播信息时</td> style="font-family:宋体">更新主播信息时</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:85.50pt" width="114" x:str="">获取主播绑定的专场的开场日期</td> style="font-family:宋体">获取主播绑定的专场的开场日期</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:150.75pt" width="201" x:str="">select start_date from fmys_special_work_arrange where anchor_id = :d and status = 1</td> style="font-family:宋体">select start_date from fmys_special_work_arrange where anchor_id = :d and status = 1</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:38.25pt" width="51" x:str="">雅木茶</td> style="font-family:宋体">雅木茶</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:38.25pt" width="51" x:str="">Lamber</td> style="font-family:宋体">Lamber</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:38.25pt" width="51" x:str="">special</td> style="font-family:宋体">special</td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:69.75pt" width="93" x:str="">special.ListStartDateOfAnchorSpecial</td> style="font-family:宋体">special.ListStartDateOfAnchorSpecial</td>
<td height="212" rowspan="2" style="vertical-align:middle"> </td>
<td class="et3" height="212" rowspan="2" style="text-align:general; vertical-align:middle; white-space:normal; height:159.00pt; width:38.25pt" width="51" x:str="">*</td> style="font-family:宋体">*</td>
<td height="212" rowspan="2" style="vertical-align:middle"> </td>
</tr>
<tr height="124" style="height:93.00pf">
<td class="et3" height="124" style="text-align:general; vertical-align:middle; white-space:normal; height:93.00pt; width:170.25pt" width="227" x:str="">判断主播与专场的绑定信息(anchorNotBindSpecial)</td> style="font-family:宋体">判断主播与专场的绑定信息(anchorNotBindSpecial)</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:84.00pt" width="112" x:str="">fmys_supply_arrange</td> style="font-family:宋体">fmys_supply_arrange</td>
<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="">接口</td> style="font-family:宋体">接口</td>
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:170.25pt" width="227" x:str="">YS/采购: 搜索供应商信息(searchSupplyInfo)</td> style="font-family:宋体">YS/采购: 搜索供应商信息(searchSupplyInfo)</td>
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:85.50pt" width="114" x:str="">获取供应商下的某个月的专场负责人</td> style="font-family:宋体">获取供应商下的某个月的专场负责人</td>
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:150.75pt" width="201" x:str="">select person from fmys_supply_arrange where supply_id in (:d) and ym = "2021-05"</td> style="font-family:宋体">select person from fmys_supply_arrange where supply_id in (:d) and ym = "2021-05"</td>
<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="">雅木茶</td> style="font-family:宋体">雅木茶</td>
<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="">Lamber</td> style="font-family:宋体">Lamber</td>
<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="">special</td> style="font-family:宋体">special</td>
<td class="et3" height="88" style="text-align:general; vertical-align:middle; white-space:normal; height:66.00pt; width:69.75pt" width="93" x:str="">special.GetSupPersonInSpecificMonth</td> style="font-family:宋体">special.GetSupPersonInSpecificMonth</td>
<td height="88" style="vertical-align:middle"> </td>
<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="">*</td> style="font-family:宋体">*</td>
<td height="88" style="vertical-align:middle"> </td>
</tr>
</tbody>
</table>

项目

一般

简介

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

任务 #24334