ht网厅 - ashorefish/-software-test GitHub Wiki

obs_pass_chg_apply

ocr_identification

SELECT * FROM HTSEC_PRODUCT.OBS_IMPORTANT_CHG_APPLY a WHERE a.USER_ID = '21644' ORDER BY a.CREATE_TIME DESC;

SELECT * FROM OBS_USER_PROFILE a WHERE a.CUST_NO = '0502059857';

DELETE OBS_IMPORTANT_CHG_APPLY a WHERE a.id = '20118';

缺少配置，导致财富视图解绑失败 proxyConfig.properties: WealthViewMidAddr=http://10.10.14.33:6080/

obs_pass_chg_apply 这张表 current_set改成5 绕过视频

测试环境新意接口地址更新 #XY_HttpUri=http://10.10.10.236:8080 XY_HttpUri=http://172.190.14.132:8080

解决“上传图片后，查看协议，返回后无法看到已上传的图片” #homedir.uploader.cdn=http://apiww.httest.com:10080/abc123 homedir.uploader.cdn=/var/www/htsec/abc123

#server.staticfile.cdn=http://apiww.httest.com:10080/abc123 #这里需要配置前台地址，网厅暂时没用到这里，掌厅在打回身份信息修改页面回显历史图片的时候会用到这里，后台视频见证也会用到这里（加载证件照） server.staticfile.cdn=http://wtww.httest.com:10443/abc123

esb接口调用失败

检查esb接口是否配置，阿里云环境是通过海通nginx中转了的

掌厅查看协议报错 修改 #protocal_web_addr=http://api.httest.cairenhui.com/abc123/ protocal_web_addr=http://bhmobile.httest.cairenhui.com/abc123 和 server.staticfile.cdn=http://bhmobile.httest.cairenhui.com/abc123 保持一致后解决

--身份证信息变更 审核中或部分成功的记录 select * from obs_important_chg_apply o where ((STATUS=1 and remark='TOS') or STATUS=3) and src_order_no is not null order by ID desc; --涉税信息更新 已提交记录 select * from OBS_USER_RESID_CLASSIFICATION where STATUS = 1; --三方存管更新 已提交记录 select * from OBS_USER_THIRD_DEPOSITY_APPLY where APPLY_SUCCESS_FLAG = 6; --风险警示 开通申请中 或 关闭中 select * from SBB_USER_APPLY where (CURRENT_BIZ_UNIT_ID = 5201 and STATUS = 1) or (CURRENT_BIZ_UNIT_ID = 5202 and STATUS = 4) order by APPLY_ID desc; --CDR 开通SH/SZ 申请中 或者 CDR关闭 申请中 select * from SBB_USER_APPLY where (CURRENT_BIZ_UNIT_ID = 3001 and STATUS = 1) or (CURRENT_BIZ_UNIT_ID = 3002 and STATUS = 1) union all select * from SBB_USER_APPLY where (CURRENT_BIZ_UNIT_ID = 3003 and STATUS = 1); --OTC 开通或关闭申请中 select * from SBB_USER_APPLY where (CURRENT_BIZ_UNIT_ID = 1801 and STATUS = 1) or (CURRENT_BIZ_UNIT_ID = 1803 and STATUS = 1) order by APPLY_ID desc; --贵金属 已提交记录 select * from SBB_USER_APPLY where BIZ_ID = 45 and status in(1); -- 融资融券客户信息采集 已提交 select * from SBB_USER_APPLY where BIZ_ID = 38 and status in(1); --融资行权 股权融资合同申请已提交/成功/股票质押合同申请失败/股票质押合同申请成功，股权融资合同申请失败 /暂留 select * from SBB_USER_APPLY where BIZ_ID = 40 and status in(1,2,3,4,5); --研究所直播 待处理/处理中/审批中 select * from OBS_USER_BISINESSES where BIZ_ID=59 and STATUS in(1,3,6);

管理后台登录失败 游谦(6718478) 18:14:31

  1. 有人改了系统时间，导致redis的验证码时间过期
  2. 有人改了config.properties的domain参数为httest.com, 导致cookie的域名不对，程序取不到验证码的session值，应该为httest.cairenhui.com 有人把海通测试环境的配置直接拷贝过来了吧？ 树上猫(2922645865) 18:16:47 2有可能，改系统时间这个就不知道为什么了，我以为一致和正常时间有差异 游谦(6718478) 18:22:21 嗯，主要是2