步骤1：
找最新订单记录：
SELECT * FROM orders t ORDER BY t.rcd_crt_time desc，
注意：保障期间和缴费年限必须要有。
步骤2：
修改userId，orderNo,policyNo，productId
报文的来由：
【1】用linux命令ls -h先找到2018年11月14日报文，cd /root/logs/UserCenter，看到n号——m号 的日志，
【2】sz UserCenter.log下载下来，拿取你需要的报文（会有回调信息摘取这里的报文），
【3】放到postman里面
a，拿到报文首先在线json校验
b，然后放到postman请求报文里面，
c，接着修改postman数据，模拟回调（回调：不需要我们真实付钱，调取人家支付接口，我们自己充当模拟支付完毕这个角色）
【4】页面核保，投保，点击立即支付，这里不真实去支付【生产环境或者测试环境】
【5】数据库orders表里面出现关于这一订单的信息，运用SELECT * FROM orders t ORDER BY t.rcd_crt_time desc，
【6】修改userId，orderNo,policyNo，productId 点击send，
【7】然后，管理保单处可以看到，手机页面已经支付完成
图一
图二，
如下json在线校验：
{
"insurants": [{
"name": "巩秀香",
"cardType": "01",
"cardNo": "1xx4211965070136xx",
"serialNo": 1,
"mobile": "1583008xxx1",
"email": "107919xxx6@qq.com",
"occupationType": "",
"occupationCode": ""
}],
"applicant": {
"relation": "2",
"name": "王利超",
"cardType": "01",
"cardNo": "1xx42119900501xxxx",
"mobile": "1521081xxxx",
"email": "107919xxxx@qq.com",
"userId": "5e8502d4c2c556cedfc593728xxxxxxx",
"userIdType": "userId"
},
"insureInfo": {
"insureCom": "复星保德信人寿保险有限公司",
"productName": "孝顺康恶性肿瘤疾病保险",
"premium": 1365,
"amount": 50000,
"startDate": "2018-11-15",
"endDate": "2019-11-14",
"startHour": 0,
"endHour": 24,
"beneficiary": "1",
"insureComId": "CH10000109",
"productId": "ABX40000009",
"orderNo": "FX2018111517025977",
"policyNo": "00002177620011xxx",
"status": "6",
"policyUrl": "http://puip.pflife.com.cn/ebiz-entry/ebiz/downloadEpolicy.do?action=dealBiz&policyNo=559cd0d2be166eaa6c876e08725a6f2afbd7e9c5f05xxx"
},
"errorCode": "0000",
"errorMsg": "成功",
"channelCode": "CH10000067"
}
}
步骤3：
Post请求 http://139.224.138.110:8004/user/policy/index
订单/保单降序查找：
SELECT * FROM orders t ORDER BY t.rcd_crt_time desc;
SELECT * FROM policy t ORDER BY t.rcd_crt_time desc;
查找上级下级关系：
SELECT * FROM `agent_friends` t where t.myUserId = 'xxxxxxxxxxxxxxxxxxx';
查找结算中心：cd /root/logs/aiTaskService/
库里面无这个用户userid，导致未出现列表
调取的SQL函数：（调取了所有表进行数据增删改查）
CALL proc_delete_user_data_by_userID('7a22de10f34d5874f67ded57aaxxxxxxx');
SQL：
SELECT * FROM orders t ORDER BY t.rcd_crt_time desc;
SELECT * FROM policy t ORDER BY t.rcd_crt_time desc;
SELECT * FROM `agent_friends` t where t.myUserId = '76bf604cc3af11e8b9a77cdxxxxxxx';
CALL proc_delete_user_data_by_userID('?????????????');
网友评论