notes/work/移动杭研/问题处理/2024-01/0111-爱奇艺开通时间需早于当前时间的特殊处理方案.md

来源：客响

此问题是总结来的，今天调整笔记结构放在问题处理中。

#首次开通单数据处理
业务开通订单号：NO.000A230428371002001
订购关系ID：60000013334
开通时间2023-04-30 00:00:00
处理动作：
1、更新订购关系记录

UPDATE `productid_info` SET `develop_stage` = 3, `business_start_time` = '2023-04-30 00:00:00' WHERE `id` = 126;

2、流程中结束当前审核人记录

UPDATE `order_process` SET `updated_time` = now(), `status` = 1 WHERE `id` = 2446;

3、更新工单状态、更新业务受理工单明细

UPDATE `order_info` SET `updated_time` = now(), `result` = '开通成功', `order_state` = 3 WHERE `id` = 1448;

#下发话单  portal机器执行
curl -ksS -X POST  -H 'Content-type: application/json' -d '{"ecId":"000AE0002022020820525230","productType":"2","orderNum":"000A221208088579001","billMethod":"3","productId":"60000013334"}' 'https://p.cdn.10086.cn/portal/bss/businessorder'

#开通单提交反馈bboss   bss机器执行
curl -ksS -X POST  -H 'Content-type: application/json' -d '{"accessToken":"20230524084725eb94a679d44a4173b89faa0f428d82c4-0330-1682297245","busType":"BBSS","content":{"BackFlag":"0","DevelopStage":"3","OrderNum":"000A230428371002001","ProductID":"60000013334","StartDate":"20230430000000"},"domain":"BBSS","envFlag":"1","routeType":"00","routeValue":"998","sessionID":"632b81fc20c14f05ba52b10332e7f8","sign":"ECBBD5DCB2DF714595D5185D6460073F","signMethod":"md5","timeStamp":"20230505090814","transIDO":"632b81fc20c14f05ba52b10332e7f8","version":"1.0.0"}' 'https://bss.cmcdn.cdn.10086.cn/sync/BBOSS/BusiProvResultServ'

UPDATE `bbossorder_info` SET `develop_stage` = 3, `remark` = '处理成功', `result_rsp` = '00', `start_time` = '2023-04-30 00:00:00', `order_state` = 3 WHERE `id` = 126;


4、新增当前审核人的操作

INSERT INTO `order_info_history_record`(`created_time`, `deleted`, `updated_time`, `handle_action`, `next_operator`, `operation_user_mobile`, `operation_user_name`, `operator_user_email`, `operator_user_role`, `order_id`, `pre_order_explain`, `predict_test_end_time`, `remark`, `result`, `test_actu_time`, `test_end_date`, `test_start_time`, `turn_on_time`, `complete_time`, `modify_date`, `reason`) VALUES (now(), b'0', now(), 2, NULL, '13693662092', '朱鹏昊', 'zhupenghao@cmhi.chinamobile.com', '集团集团运营经理', 1448, NULL, NULL, '处理成功', '开通成功', NULL, NULL, NULL, '2023-04-30 00:00:00', NULL, NULL, NULL);