深圳智汇创想科技有限公司

验证点：

一、ERP->系统参数设置->销售管理->订单，新增配置规则：备库单需求统计规则；

1）选择日期为单选，从星期一到星期天；点'+',可新增一条，如上图；

2）输入框支持选择时间，精确到时；

3）初始默认关闭；勾选’开启‘，选择星期和时间框必填；一行中，时间框必填一个；

二、

ERP->销售管理->备库订单（新）->FBA备库订单,备库类型为’本地-FBA‘，

以及ERP->销售管理->备库订单（新）->海外仓备库订单,备库类型为’本地-海外仓‘

1）界面新增需求状态查询条件，包含暂存需求和正常需求；

2）新增字段--需求状态，包含暂存需求和正常需求，初始默认为NULL；

SELECT DemandState,* from  RB_OrderInfo 

3）在系统参数中，备库单需求统计规则勾选关闭，不管什么时间，订单审核通过后，需求状态都变为’正常需求‘；

4）在系统参数中，备库单需求统计规则勾选开启后：

4.1）订单审核通过后，需求状态改为'暂存需求'；---单号列里对应标识图’暂存需求‘

4.2）到达规则的时间点，系统自动触发服务，把需求暂存的订单改为’正常需求‘；------单号列里对应标识图’正常需求‘

服务地址：10.158.158.22:8080/testcw.aspx

4.3）订单审核通过，或自动释放，都需要添加日志

5）在下图按钮中，新增选项--批量释放暂存需求，勾选订单后，选择【批量释放暂存需求】，

5.1）新增日志，

备注：只针对【本地--fba】【本地--海外仓】

类型订单有效

三、智能备货计划2.2，当开启ERP->系统设置勾选规则后，调整服务统计逻辑：

1）备库订单本地备货预出数、同步海外仓FBA仓备货预出数、同步未配货预出数的服务，只统计发货仓库为本地仓，正常状态或者部分发货状态，未发货且正常需求的总数量；

测试环境服务地址：http://quartz.internal.zhcxkj.com/schedules

未配货预出数服务 对应服务：UnPickPlanoutListJob

海外仓&FBA对应同步服务：OverSeaStockPlanoutListJob

本地仓备货预出数同步服务：LocalStockPlanoutListJob

相关SQL：

sql相关：

-- 服务需要判断的数据
SELECT
                        ad.TransportID,
                        tp.TransferType,
                        outWh.ID AS OutWareHouseID,
                        outWh.WareHouseType AS OutWareHouseType,
                        outWh.WareHouseCountry AS OutWareHouseCountry,
                        inWh.ID AS InWareHouseID,
                        inWh.WareHouseType AS InWareHouseType,
                        inWh.WareHouseCountry AS InWareHouseCountry,
                        ad.OrginNumber AS OrderCode,
                        ad.RelationId AS PackageID,
                        ad.AllocationNumber,
                        ad.ID,
                            oi.ShipTime
                        FROM
                        RB_Inventory_AllocationBill ad (NOLOCK)
                        LEFT JOIN RB_WareHouse outWh (NOLOCK) ON ad.CustomerID = outWh.CustomerID 
                        AND ad.OutWareHouseID = outWh.ID
                        LEFT JOIN RB_WareHouse inWh (NOLOCK) ON ad.CustomerID = outWh.CustomerID 
                        AND ad.InWareHouseID = inWh.ID
                        LEFT JOIN RB_OrderInfo oi (NOLOCK) ON oi.OrderCode = ad.OrginNumber 
                        AND ad.CustomerID = oi.CustomerID 
                        LEFT JOIN RB_Transport tp (NOLOCK) ON tp.ID = oi.TransportID 
                        AND tp.CustomerID = oi.CustomerID 
                        WHERE
                        ad.Status IN ( 0, 1 ) 

                        AND ad.Id IN ( 1738,1746,1974,2086,2218,2219,2247,2254,2256,2282,2283,2284,2285,2288,2290,2292,2293,2298,2299,2301,2309,2311,2312,2313,2317,2322,2325,2326,2327,2328,2329,2354,2355,2356,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2405,2406 )  AND oi.ShipTime IS NOT NULL AND ad.TransportID > 0 AND tp.TransferType > -1

列表数据：

SELECT
                                itm.Id,
                                ad.ID AllocationBillID,
                                itm.TransitStatus,
                                itm.IsReceive,
                                itm.IsDelayed,
                                ad.RelationId AS PackageID,
                                ad.AllocationNumber,
                                ad.OrginNumber AS OrderCode,
                                ad.TrackNumber,
                                oi.TransportID,
                                tp.TransportName,
                                outWh.WareHouseName AS OutWareHouseName,
                                inWh.WareHouseName AS InWareHouseName,
                                (SELECT SUM(ShipNum) FROM RB_Inventory_AllocationDetailBill (NOLOCK) WHERE AllocationBillID = ad.ID ) AS ShipNum,
                                (SELECT SUM (ReceiveNum) FROM RB_Inventory_AllocationDetailBill (NOLOCK) WHERE AllocationBillID = ad.ID ) AS ReceiveNum,
                                itm.ErpIsClosed,
                                ad.AuditTime,
                                oi.AmazonShipmentId,
                                (SELECT MAX (FinishTime) FROM RB_Inventory_AllocationDetailBill (NOLOCK) WHERE AllocationBillID = ad.ID ) FinishTime
                                                        FROM
                                RB_Inventory_InTransitMonitor itm (NOLOCK)
                                INNER JOIN RB_Inventory_AllocationBill ad (NOLOCK) ON itm.AllocationBillID = ad.ID
                                AND itm.CustomerID = ad.CustomerID
                                LEFT JOIN RB_WareHouse outWh (NOLOCK) ON ad.CustomerID = outWh.CustomerID
                                AND ad.OutWareHouseID = outWh.ID
                                LEFT JOIN RB_WareHouse inWh (NOLOCK) ON ad.CustomerID = outWh.CustomerID
                                AND ad.InWareHouseID = inWh.ID
                                LEFT JOIN RB_OrderInfo oi (NOLOCK) ON oi.OrderCode = ad.OrginNumber
                                AND ad.CustomerID = oi.CustomerID
                                LEFT JOIN RB_Transport tp (NOLOCK) ON tp.ID = oi.TransportID
                                AND tp.CustomerID = oi.CustomerID
                            WHERE
                                itm.CustomerID = 1

运输时效查询

SELECT
                                tl.Id,
                                tl.CustomerId,
                                tl.TransportId,
                                tl.ShipperCountry,
                                tl.ShipperCountryCode,
                                tl.ReceiveCountry,
                                tl.ReceiveCountryCode,
                                ts.TransferType,
                                tl.LogisticsDays,
                                tl.IsDeleted,
                                tl.UpdatedAt,
                                tl.CreatedAt,
                                ts.TransportName
    FROM
                                RB_Transport_Timeliness tl (nolock)
                                INNER JOIN RB_Transport ts (nolock) ON tl.TransportId = ts.ID
                                AND tl.CustomerId = ts.CustomerId
                            WHERE
                                tl.CustomerID = 1

SELECT
    IsReceive AS '是否签收',
    IsDelayed AS '是否超期',
    TransitStatus AS '在途状态0-正常,1-异常',
    ErpIsClosed as 'ERP接收完结',
    *
FROM
    RB_Inventory_InTransitMonitor