保理联调笔记
## 1.保理联调
新号码：绑银行卡：62269017 +4位+6677
1.下单参数，下单地址：http://10.9.10.115:17011/MPL_CpchCca_UAT/
2. https://cf.cmpay.com/mpl/login.html
3. 更改数据库日期：mpltpubdt表（gwa_tx_dt，gwa_tx_tm。uat时间是取的这个表的这俩字段）
UPDATE mpltpubdt set GWA_TX_DT='20220425' WHERE RRC_TX_DT='20220415'
COMMIT
1. 手机号：志哥：15874929121
2. 4A密码：Yyz123123#
4. 查看日志：
cdt 到日志目录
less+日志编号.trc
ctrl+f 翻页
G最后
？错误码 /错误码
grep 5066018 TXN*
查看报文 grep loan-agw206021047470005100999 MPL_FPS_SCA.trc
流水号查日志 grep 220614560022836130 data*|less
grep -l SIMU20220615101203 C*
grep -l loan-agw209261048200007031352 *
```
根据订单号找5066089日志
1. loanchannel（181） 机器 grep 50620220816141003000368208 access-loan-channel.log |less
2. 搜索 /loan-channel/v1/mpl/cpch/agree-authorization
3. 找到日志号loan-agw208191012240006186293
4. 到mploln（216）机器 grep loan-agw208191012240006186293 TXN*
```
18684741155
张三：13974856860
谭杰：18684748230
6.上传pdf路径：/app/mploln/data/mpl/cpch/mould
7.grep 50620220601200000000347838 data*|less
# 重新授信删除记录
```sql
SELECT * FROM MPLTCREDITCPT
WHERE ORG_ID='888073155233179' AND CRE_JRN_NO='220601560022588949'
SELECT * from mpltcptcrejrn
WHERE ORG_ID='888073155233179' AND JRN_DT='20220601'
SELECT * FROM MPLTCREDITCPT
WHERE CREDIT_STS = 'P' AND CRE_TYP = '002'
AND ID_NO18 = 'F7D68A796A3E2A0FED923D11499527919E71BC6C0A7FDEDE'
AND ORG_ID = '888073155233179'
```
```
验签失败
grep loan-agw206081606410005118523 lemon-loan-agw*|less
```
分省提前清贷/退货文件
```sql
添加boss对账记录
SELECT *
FROM MPLTCKCT
WHERE CHK_TYP_ID = 'BC000'
AND CHK_FIL_STS = '9'
AND CHK_FIL_DT = '20220609'
AND CHK_ORG_ID = '18';
上传后删除两张表记录
select *
FROM MPLTCKCT
WHERE CHK_FIL_DT = '20220609'
AND CHK_ORG_ID = '888073155233179'
AND CHK_TYP_ID = 'FC002';
select *
FROM MPLTHCKCT
WHERE CHK_FIL_DT = '20220609'
AND CHK_ORG_ID = '888073155233179'
AND CHK_TYP_ID = 'FC002'
AND VER_NO = '18'
commit
没有生成数据看这张表，退货，当天生成不能当天退货，（改状态L102）
SELECT
*
FROM MPLTCPTORDT A,MPLTRPYJRN B,MPLTORDEXPORG C
WHERE A.ORD_NO = B.BRW_ORD_NO
AND A.ORD_NO = C.ORD_NO
AND A.ORD_DT = C.ORD_DT
AND B.RPY_TYP IN ('2', '3')
AND B.SEQ_NO = 'ALL'
AND B.RPY_STS IN ('S1', 'S2')
AND A.ORD_STS = 'S2'
AND A.RPY_STS IN ('R2','R3')
AND A.BUS_TYP != 'L103'
AND A.ORG_ID = '888073155233179'
AND A.PROV_NO = '18'
AND A.RE_ACP_DT = '20220608'
```
资金方解冻额度接口
```
方式一、订单状态S1P调BOSS业务办理通知（套餐办理通知接口）选择R（取消） S1F
方式二、订单当日办理当日退 S1F
```
1.1下单成功------>借款------->获取取货码（密码123123）---------->到营业员
选择------>
上传-------->更改告知书状态
SELECT * from MPLTIMGCHK WHERE ORD_NO='50620220601200000000346631'
UPDATE MPLTIMGCHK SET CHK_STS='S' WHERE ORD_NO='50620220601200000000346631'
boss确认------->
8.确认办理文件，（boss业务办理通知后一天D+1）
