文档更改深圳德顺

在2020/07/24 11:28上被chinyee he修改
从版本< 46.1 >
由shi chuck编辑
在2020/03/14 09:45上
到版本
由shi chuck编辑
在2020/03/20 01:06上
< >
修改评论 该版本没有评论

Summary

Details

Page properties
Content
... ... @@ -5,6 +5,54 @@
5 5  
6 6  **~* 金凯瑞和其子客户那边所有问题，令狐充的分析结果在金凯瑞内部群里说明，统一交由金凯瑞方（如，吴小英）去最终告知 当地运营客户的群。**
7 7  
8 += szds_case#35_20200319 =
9 +
10 +问题描述：平台和腾讯商户收入对账不匹配
11 +
12 +~-~-跟踪
13 +
14 +(% class="box message" %)
15 +(((
16 +【客户提供数据背景和我方整理】： 
17 +1、（图1） 样本 为客户统计数据，时间区间：1月投入运营后 至 2020-3-19 00:00 。
18 +2、德顺商户平台操作查询的时间点： 3月19日22：00
19 +3、[[attach:德顺新能源 华夏户3292555（2020.01.19-2020.03.19）.xls||target="_blank"]] 是 客户2020-3-19 午后（具体时间不明），在银行系统确认之进帐明细。
20 +4、（图2红框） 注意 3.19号的 单边贷记 
21 +结论：平台和银行实收 有较大差异。
22 +\\[[image:1584630611527-190.png]]图1
23 +[[image:1584631672367-243.png]]图2
24 +\\\\【shi】：以下数据样本时间皆为：截止2020/3/19  零点。
25 +**一、数据**
26 +~~令狐充平台端数据
27 +消费总额   153134.88
28 +充值总额   269735.00  |  人工线下充值总额：100010.00  |  微信线上充值：169725.00   扣除千分之六： 169725.00*(1-0.006)= 168706.65
29 +线上总计退款： 1768.70
30 +~~根据本case中客户xls和图文中重新统计数据
31 +银行账户实收：  155692.70 （排除 2020-3-19当日费用） |  166948.63（包括 2020-3-19当日费用）
32 +腾讯商户平台总计退款： 待客户提供。
33 +**二、分析**
34 +1、基于令狐充平台计算公式：微信线上充值总额（扣除千分之六）-线上总计退款=（令狐充预期的）银行账户收款
35 +公式结果：  168706.65-1768.70=166937.95  
36 +2、基于客户xls，客户银行实收款 =166948.63（包括 2020-3-19当日费用）
37 +**三、结论：**
38 +~~计算误差公式：客户银行实收款-（令狐充预期的）银行账户收款
39 +~~公式结果： 166948.63-166937.95=10.68  |  **疑惑见下* 推论**
40 +~~客户银行实收款  大于（令狐充预期的）银行账户收款。  德顺运营商获利。
41 +~~误差率： 十万分之六。  公式为：10.68/166948.63=0.00006
42 +*** 推论**
43 +1）此处以166948.63参与计算。 见上文中引用：“银行账户实收：  155692.70 （排除 2020-3-19当日费用） |  166948.63（包括 2020-3-19当日费用）”
44 +2）必须搞清楚xls中“单边贷记”性质。
45 +3）根据计算，我方推测：2020-3-19 单边贷记 款项记录 是 2020-3-18 00:00至2020-3-19 00:00 期间发生之充值；同时，德顺在2020-3-19 午后在银行系统查账，预期钱款此刻应到帐，但实则“单边贷记”，需客户和财务进一步确认。
46 +4）按照德顺描述：商户平台T+1， 实际到帐德顺账户时间是第二日 凌晨2至4点。
47 +\\\\\\【平台功能缺陷】：
48 +1、“首页/客户管理/会员管理/退款审核管理”无法导出退款记录，不利于统计对账。
49 +)))
50 +
51 +~-~-解决:
52 +
53 +状态（☑表示选定 ）： 已解决 | 处理中 | 暂搁置 
54 +售后（跟单）工程师：施文俊
55 +
8 8  = szds_case#34_20200312 =
9 9  
10 10  问题描述：罗宾森10w元扣费
... ... @@ -14,10 +14,43 @@
14 14  (% class="box infomessage" %)
15 15  (((
16 16  billing_Id=20200314021804697386
65 +桩:44030500040000200011, 2号枪, 账单:20200314021804697386 , 巨额账单问题原因:
66 +1、该账单鉴权及启动充电时间在03-14 02:18:04.701及03-14 02:18:10.812, 启动成功;
67 +2、启动前，该枪的"电表度数"为：2343.78
68 +3、在之后的充电心跳中,在03-14 02:21:48.864的心跳中上送的"电表度数"为851999.7 (注意:这个产生巨额账单问题原因),报文如下:
69 +0xFEA6000002FFFF06F13434303330353030303430303030323030303131020205020202B0B310020E0314A8DE12020E031404000000D8782C3200000018A90700000000000000000000000000000000000000000000000000620C14054F015103800C800B01000132303230303331343032313830343639373338360000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B916
70 +4、该充电在03-14 02:21:49.191发起停止并结束;
71 +5、该充电结束后，桩没有在30分钟内上传账单 (注意:账单延时)
72 +6、平台在该充电结束后30分钟, 平台根据心跳中的电表数据预估费用, 由于之前该枪产生过异常的电表度数所致;
17 17  [[image:1584149733644-145.png]]
74 +
75 +【shi】：bo端日志片段。通过关键字查询：addChargeRecord 20200314021804697386
76 +第一次平台账单片段：
77 +**2020-03-14 02:54:14.691** | http-nio-8091-exec-3 | INFO | c.s.b.f.CustomAuthenticationFilter.doFilter(69) : POST : authType: 1 batteryRatedCapacity: 0.0 batteryRatedTotalVoltage: 0.0 batteryType: 6 billingId: 20200314021804697386 billingType: 1 billingValid: 1 chargeDuration: 219 chargeEnd: 2020-03-14 02:22:06 chargePower: 309.36 chargeStart: 2020-03-14 02:18:26 chargeUnitLabel: 2 deviceNumber: 44030500040000200011 gunConnectTime: 2020-03-14 02:16:46 occupyDuration: 103 pbBillingValid: pbChargeDuration: 219 pbChargeEnd: 2020-03-14 02:22:06 pbChargePower: 1.81 pbChargeStart: 2020-03-14 02:18:26 pbExactChargeEnd: true pbExactServiceEnd: true pbOccupyDuration: 103 pbPhasePowers: 0.0,0.0,0.0,0.0,**849655.92**,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0 
78 +第二次设备账单片段：
79 +**2020-03-14 02:57:07.049** | http-nio-8091-exec-7 | INFO | c.s.b.f.CustomAuthenticationFilter.doFilter(69) : POST : authType: 1 batteryRatedCapacity: 0.0 batteryRatedTotalVoltage: 0.0 batteryType: 6 billingId: 20200314021804697386 billingType: 2 billingValid: 10 chargeDuration: 180 chargeEnd: 2020-03-14 02:21:02 chargePower: 1.81 chargeStart: 2020-03-14 02:18:02 chargeUnitLabel: 2 deviceNumber: 44030500040000200011 gunConnectTime: 2020-03-14 02:16:46 occupyDuration: 2040 pbBillingValid: pbChargeDuration: 219 pbChargeEnd: 2020-03-14 02:22:06 pbChargePower: 1.81 pbChargeStart: 2020-03-14 02:18:26 pbExactChargeEnd: true pbExactServiceEnd: true pbOccupyDuration: 103 pbPhasePowers: 0.0,0.0,0.0,0.0,849655.92,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0 pbServiceEnd: 2020-03-14 02:23:49 pbServiceStart: 2020-03-14 02:18:05 phasePowers: 0.0,0.0,0.0,0.0,1.81,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0 productType: 2
80 +
81 +
82 +**紧急修正办法：**
83 +1、此单心跳数据不正确+账单丢失，双重原因导致绝费用，可进入异常账单修正。（如果最终账单上传了，会按真实账单计算（账单中心跳如果正确），但此账单最终未上送。）
84 +2、桩端bug及时修复。
85 +
86 +**临时调整账单机制：**
87 +平台支持机制包括：
88 +机制1）异常账单 手工修复 后终端用户才实际收到 修复后的账单。
89 +机制2）先产生账单，后手工修复 纠正账单数据。
90 +
91 +两种机制优缺点：
92 +机制1）至少7x24（7x16）小时有人办公，及时修复异常账单，仅修复后 终端用户才收到账单，并进行扣费。如不及时扣费，用户可再次充电，可能导致累计扣费引起账户余额大额负数。
93 +机制2）减小桩端的bug数据对终端用户直接产生不可靠影响。 包括：电量费用、时间异常等。
94 +\\运营商可按实际运营情况提出申请，平台方可按客户要求调整机制。
95 +
96 +[[image:1584150339953-344.png]]
18 18  )))
19 19  
20 20  ~-~-解决:
100 +
101 +
21 21  状态（☑表示选定 ）： 已解决 | 处理中 | 暂搁置 
22 22  售后（跟单）工程师：施文俊
23 23  
1584630611527-190.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ShiChuck
Size
... ... @@ -1,0 +1,1 @@
1 +64.5 KB
Content
1584631672367-243.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ShiChuck
Size
... ... @@ -1,0 +1,1 @@
1 +15.9 KB
Content
德顺新能源 华夏户3292555（2020.01.19-2020.03.19）.xls
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ShiChuck
Size
... ... @@ -1,0 +1,1 @@
1 +31.0 KB
Content