四扫客户接口——接口测试完成文档

tech2023-08-17 116

文章目录

CREATE TABLE1创建custom表6新建活动表_ACTIVITY7创建teller表8、建立模板表9、增加个性化模板表10、建立客户与活动对应表11、创建流水表16、创建资产表ASSET21 经营表operate26 family表31、创建业务表professional33创建金融需求表_financial36创建任务表--task38创建产品表--product39、创建营销业绩汇总表--marketing_performance45、创建金融地图数据表financial_map_data46、创建表金融趋势图financial_trend_map49、小额信贷CREDIT_INDEX65、创建机构表agency66、创建一个级别表level72、创建日程信息表schedule74、创建降幅表decline77、创建”影像“表imageurl 11、给teller表添加角色1、用户角色查询 22、客户四扫数据查询_根据客户号2、客户四扫数据查询_根据证件号 33、客户行内数据查询3、role 44、添加列“外部数据类型编码”4、外部数据查询 55、图片上传影像 66、添加数据6、四扫数据保存 77、为新增字段添加数据7、四扫数据提交_获取数据7、四扫数据提交7、添加数据 8柜员添加法人号插入模板查询模板 9插入个性化模板数据查询模板数据 10客户营销活动营销列表 11新增客户 13活动列表查询 14活动文件列表 15插入数据 1616、为表ASSET添加数据16、资产列表查询 1717、资产明细查询 1818、资产新增 1919、资产明细编辑 2020、资产明细删除 2121、为经营operate表添加数据21、经营列表查询 2222、经营明细查询 2323、经营新增 2424、经营明细编辑___根据编号ID来编辑___因为多个的经营种类会对应同一个客户号 2525、经营明细删除___根据编号 2626、家庭成员查询 27家庭成员明细查询 28家庭成员新增 29家庭成员明细编辑 30家庭成员删除 3131、为业务表professional添加数据31、业务量查询 3232、业务量明细查询 3333、增加---为financial表添加数据33、修改financial表数据 3434、金融需求查询 35待完成 3636、（新增--数据）36、任务列表的查询 3737、活动详情查询（新增） 3838、新增--数据38、产品列表查询（新增） 3939、营销业绩汇总查询（新增）39、为表marketing_performance添加数据 4040、营销业绩明细查询（新增）40、添加新增字段的数据 4141.营销业绩考评查询（新增） 4242、排行榜查询（新增） 4343、活动影像下载（新增）___查询 4444、产品明细查询（新增） 4545、添加数据45、查询金融地图数据 4646、添加数据-模拟46、查询金融趋势图 4747、查询金融饼状图 4848、查询行内客户号（新增） 49插入两条征信插入两条预授信细项明细插入一条准入请求查询申请人征信 50插入一条贷款申请插入一条调查信息 51上传影像 52查询申请列表 53流水号查询客户信贷信息 55暂存申请、调查信息 50 中的两个post请求即可 56增加三个产品查询产品列表 57执行利率查询插入一条执行利率信息 58查询责任人 59根据柜员号查询机构号 6565、添加数据-agency65、（新增）获取CRM的角色信息 6666、添加数据66、获取VIP客户变化和流失客户详细 6767、客户基本信息接口(新增) 6868、客户关联信息列表查询(新增) 6969、前十客户排名查询接口(新增) 7070、客户360视图客户列表查询 7171、客户分析信息查询 7272、ADD DATA72、查询出日程和生日提醒信息 7373、查询出日程里面生日提醒的具体信息 7474、ADD DATA74、降幅十大客户列表排名查询接口(新增) 7575、查询出客户经理的VIP客户数，各个指标（3 4 5星级，升级，降级，流失）的当日客户数和较上年末接口(新增) 7676、查询登记簿客户列表信息 7777、ADD DATA OF imageurl77、查询登记簿客户详细信息 7878、修改登记簿客户信息 7979、新增登记簿客户影像信息79、修改登记簿客户影像信息 8080、查询预授信额度模板 8181、修改预授信额度评分 8282、查询登记簿批量标签 8383、小额信贷删除待办任务（新增） 8484、重载预授信额度评分_____预授信细项明细84、重载预授信额度评分___预授信算分明细___添加预授信额度YSXED

CREATE TABLE

1创建custom表

url:localhost:50002/services/table body:

{ "custom": { "MONEYPERYEAR": "int(11) NOT NULL COMMENT '家庭年收入'", "HAVE_OUT": "varchar(10) NOT NULL COMMENT '是否含有外部数据标记：\r\n 02有，其他无'", "image_index": "varchar(255) NOT NULL COMMENT '影像'", "ASSIGN_STATUS": "varchar(10) NOT NULL COMMENT '分配状态：01:未指定；02:已指定'", "OUT_NORM": "varchar(255) DEFAULT NULL COMMENT '外部数据指标集'", "JBXX108": "varchar(255) NOT NULL COMMENT '证件号'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'", "external_data_type_code": "int(11) DEFAULT NULL COMMENT '外部数据类型编码：\r\n01:医疗参合；02:供电信息；03:供水信息；04:公积金信息；05:社保信息；06:税务信息；07:征信信息；08:户籍信息；09:工商信息；10:建档立卡贫困户信息；11:新型农业主体和家庭农场名单信息'", "JBXX107": "varchar(25) NOT NULL COMMENT '证件类型'", "JBXX101": "varchar(100) NOT NULL COMMENT '客户名称'", "CUST_TYPE": "varchar(100) NOT NULL COMMENT '客户类型'", "IDENT": "varchar(100) NOT NULL COMMENT '行内/行外：\r\n01行内、02行外'", "CUST_IDE": "varchar(100) DEFAULT NULL COMMENT '客户标识：\r\n重点跟进客户、定期回访客户等6项'", "SS0306": "int(100) DEFAULT NULL COMMENT '信用测算额度'", "CUSTUUID": "varchar(100) NOT NULL COMMENT'返回一个客户的唯一标识CUSTUUID' ", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "ADDRESS": "varchar(255) NULL COMMENT '地址：筛选条件,选填'", "YXZL_START": "varchar(255) NULL COMMENT '客户信息完整度（%）最小值：筛选条件,选填'", "YXZL_END": "varchar(255) NULL COMMENT '客户信息完整度（%）最大值 '", "CUSTTRADE": "varchar(255) NOT NULL COMMENT '从事行业'", "PHONENO": "varchar(255) NOT NULL COMMENT '联系号码 '", "JZDZ": "varchar(255) NOT NULL COMMENT '现居地址 '", "CZDZ": "varchar(255) NOT NULL COMMENT '常住地址 '", "SFZDZ": "varchar(255) NOT NULL COMMENT '身份证地址 '", "YXZL": "varchar(255) NOT NULL COMMENT '客户信息完整度（%） '", "CUSTSEX": "varchar(255) NOT NULL COMMENT '客户性别'", "jbxx112": "varchar(100) NOT NULL COMMENT '生日'", "jbxx113": "int(10) NOT NULL COMMENT '年龄'", "kh060": "int(100) NOT NULL COMMENT'客户积分'", "KHZBHYDLB": "double NOT NULL COMMENT'客户贡献度'", "relation_id": "int(11) NULL COMMENT'关联ID'", "relationShip": "varchar(100) NULL COMMENT'关联关系'", "relationJobUnit": "varchar(100) NOT NULL COMMENT'工作单位名称 '", "ralationMarriage": "varchar(10) NOT NULL COMMENT'婚姻状况 '", "ralationCultural": "varchar(50) NOT NULL COMMENT'文化程度 '", "healthy": "varchar(100) NOT NULL COMMENT'健康状况 '", "chname": "varchar(100) NOT NULL COMMENT'姓名'", "custlevel": "int(10) NOT NULL COMMENT'客户星级'", "rank": "int(100) NOT NULL COMMENT'排名'", "flag": "int(100) NOT NULL COMMENT'是否可查询详细信息：0不可以，1可以'", "jbxx206": "int(10) NOT NULL COMMENT'客户公私（0 对公，1 对私）'", "hx_rksx": "varchar(100) NOT NULL COMMENT'人口属性'", "hx_kh021": "decimal(50,2) NOT NULL COMMENT'行内资金'", "KHZBZCDLB": "int(100) NOT NULL COMMENT'客户粘性:指标（1 非常感兴趣，2 比较感兴趣，3 一般感兴趣，4 不感兴趣，5 一般不感兴趣，6 比较不感兴趣，7 非常不感兴趣，0 不确定）'", "qdph": "varchar(100) NULL COMMENT'渠道偏好'", "CREATE_TIME": "date NULL COMMENT'导入日期'", "UPDATE_TIME": "date NULL COMMENT'修改日期'", "LOAD_FLAG": "varchar(10) NOT NULL COMMENT'批量标签'", "LIVESITUATION": "varchar(10) NOT NULL COMMENT'居住状况'", "SS0011": "varchar(10) NOT NULL COMMENT'道德评价'", "SS0005": "int(10) NOT NULL COMMENT'家庭成员人数'", "NHXX101": "int(10) NOT NULL COMMENT'家庭劳动力人口数'", "SS0319": "varchar(10) NOT NULL COMMENT'建档立卡贫困户标志'", "SS0003": "varchar(10) NOT NULL COMMENT'客户分类'", "SS0031": "varchar(10) NOT NULL COMMENT'职务'", "SS0219": "varchar(10) NOT NULL COMMENT'职称'", "ACTIVITY_ID": "varchar(100) NULL COMMENT '活动编号'" } }

6新建活动表_ACTIVITY

url:localhost:50002/services/table body:

{ "ACTIVITY": { "BUSSINES_ID": "varchar(100) NOT NULL COMMENT '流水号'", "TEMP_ID": "varchar(100) NOT NULL COMMENT '模版编号:\r\nCRM配置，由外围系统填写'", "ACTIVITY_ID": "varchar(100) NOT NULL COMMENT '活动编号'", "ACTIVITY_NAME": "varchar(100) NOT NULL COMMENT '活动名称'", "ENTRY_TELLER": "varchar(100) NOT NULL COMMENT '柜员号'", "corporate_id": "varchar(100) NOT NULL COMMENT '法人id'", "ACTIVITY_STATUS": "varchar(10) NOT NULL COMMENT '活动状态：01未开始；02进行中；03已失效。选填（如不填会查出本行所有的活动）'", "CREATE_TELLER": "varchar(100) NOT NULL COMMENT '创建人'", "TEMP_TYPE": "varchar(100) NOT NULL COMMENT '模版类型：01基础模版 02自定义模版'", "FILE_NAMES": "varchar(255) NOT NULL COMMENT '文件名称'" } }

7创建teller表

url:localhost:50002/services/table body:

{ "teller": { "role_type": "varchar(255) NOT NULL COMMENT '90: 省联社主管、80：县联社主管、20：网点主管、10：客户经理、1：普通人员'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "corporate_id": "varchar(255) NOT NULL COMMENT '法人号'", "TELLER_ADDR": "varchar(100) NOT NULL COMMENT '录入柜员地址: 用户录入时定位地址'", "TELLER_LOCATION": "varchar(100) NOT NULL COMMENT '录入柜员定位坐标: 用户地址经纬度'", "ANCBRTCOD": "varchar(100) NOT NULL COMMENT'法人机构号'", "ANCBRTCOD_NAME": "varchar(100) NOT NULL COMMENT'法人机构名称'", "BEL_UNIT_NAME": "varchar(100) NOT NULL COMMENT'机构名称'", "BEL_UNIT": "varchar(100) NOT NULL COMMENT'机构号'", "CUSTMANAGER": "varchar(100) NOT NULL COMMENT'客户经理编号:查询范围为客户经理时返回'", "CUSTMANAGERS": "varchar(255) NOT NULL COMMENT '客户经理 '", "CUSTMANAGER_NAME": "varchar(255) NOT NULL COMMENT '客户经理名称 '", "XZJDS": "int(100) NULL COMMENT '新增建档数'", "ORDERNO": "varchar(100) NOT NULL COMMENT'排名'" } }

8、建立模板表

url：localhost:50002/services/table

body：

{ "TEMP": { "corporate_id":"varchar(10) NOT NULL", "temp_id":"varchar(10) NOT NULL COMMENT '模板id'", "temp_name":"varchar(10) NOT NULL COMMENT '模板名称'", "temp_content":"LONGTEXT NOT NULL COMMENT '模板内容'", "temp_type":"varchar(10) NOT NULL COMMENT '模板类型'" } }

9、增加个性化模板表

body:

{ "PERSON_TEMP":{ "MEA_ID":"varchar(20) NOT NULL", "MEA_NAME":"varchar(20) NOT NULL", "MEA_TYPE":"varchar(10) NOT NULL", "INPUT_TYPE":"varchar(10) NOT NULL", "IS_VALID":"varchar(10) NOT NULL", "TEMP_ID":"varchar(10) NOT NULL" } }

10、建立客户与活动对应表

{ "custom_act":{ "CUSTNO":"varchar(20) NOT NULL", "ACTIVITY_ID":"varchar(20) NOT NULL", "ASSIGN_TELLER":"varchar(20)", "MARKET_UNIT":"varchar(20)", "TEMP_ID":"varchar(20) NOT NULL", "TEMP_TYPE":"varchar(20) NOT NULL", "MARKET_STATUS":"varchar(10) NOT NULL", "IDENT":"varchar(10) NOT NULL" } }

11、创建流水表

{ "BUSSINES": { "BUSSINES_ID":"varchar(255) NOT NULL", "ENTRY_TELLER":"varchar(255) NOT NULL", "TELLER_ADDR":"varchar(255)", "TELLER_LOCATION": "varchar(255)", "BUSSINES_CONTENT":"varchar(255)" } }

16、创建资产表ASSET

url：localhost:50002/services/table

body：

{ "ASSET": { "IS_MORTGAGE": "int(10) NOT NULL COMMENT '是否已抵押：01是；02否'", "ASSETS_TYPE": "int(10) NOT NULL COMMENT '资产类型：01房产；02交通工具；03大型农机具；04土地；05林权，06其他资产'", "NUM": "int(255) NOT NULL COMMENT '数量'", "MEASUREMENT": "varchar(100) NOT NULL COMMENT '单位'", "MARKET_VAL": "varchar(100) NOT NULL COMMENT '市场估值'", "CUSTNO": "varchar(255) NOT NULL COMMENT '资产对应的客户号'", "ASSETS_CONTENT": "varchar(100) NOT NULL COMMENT '资产详情：房产的位置、名称，交通工具名称、型号等'", "NUM_ID": "varchar(255) NOT NULL COMMENT '编号ID'" } }

21 经营表operate

{ "OPERATE": { "MANAGE_TYPE": "int(10) NOT NULL COMMENT '经营类型：01种植业；02养殖业；03加工业；04农业服务业；05商业服务业；06劳务业；07家庭其他成员收入，'", "PARA_VALUE": "varchar(100) NOT NULL COMMENT '经营种类：行业分类中的PARA_VALUE'", "MEASUREMENT": "varchar(100) NOT NULL COMMENT '单位'", "NUM": "int(255) NOT NULL COMMENT '数量'", "INCOME": "varchar(255) NOT NULL COMMENT '年收入'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'", "JYDZ": "varchar(100) NOT NULL COMMENT'经营地址'", "SS0018": "varchar(100) NULL COMMENT'店铺名称'", "GTSH100": "varchar(100) NOT NULL COMMENT'营业执照号码'", "SS0129": "varchar(100) NOT NULL COMMENT'经营场地所有权'", "BUSI_DESC": "varchar(100) NOT NULL COMMENT'经营资料'", "SS0019": "varchar(100) NOT NULL COMMENT'经营范围'", "SS0024": "int(10) NOT NULL COMMENT'经营年限'", "SS0120": "decimal(50,2) NOT NULL COMMENT'注册资金'", "SS0281": "decimal(50,2) NOT NULL COMMENT'上年纳税金额'", "SS0107": "varchar(10) NOT NULL COMMENT'法定代表人名称'", "SS0108": "varchar(255) NOT NULL COMMENT'法定代表人联系号码'", "SS0131": "int(255) NOT NULL COMMENT'企业员工人数'", "SS0165": "varchar(10) NOT NULL COMMENT'主要负责人名称'", "SS0166": "varchar(255) NOT NULL COMMENT'主要负责人联系号码'", "SS0167": "varchar(100) NOT NULL COMMENT'财务负责人名称'", "SS0168": "varchar(255) NOT NULL COMMENT'财务负责人联系号码'", "INPUT_ADDRESS": "varchar(255) NOT NULL COMMENT'录入地址'", "op_id":"varchar(100) NOT NULL COMMENT'经营编号ID'" } }

26 family表

{ "FAMILY":{ "ID":"int NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '编号'", "JBXX108": "varchar(255) NOT NULL COMMENT '证件号'", "NAME": "varchar(255) NOT NULL COMMENT '姓名'", "RELATION": "varchar(255) NOT NULL COMMENT '与户主关系'", "NATION":"varchar(100) NOT NULL COMMENT '民族'", "ID_NUMBER":"varchar(100) NOT NULL COMMENT '身份证号'", "PERMANENT_RESIDENCE":"varchar(255) NOT NULL COMMENT '常住地'", "CONTACT_NUMBER":"varchar(30) NOT NULL COMMENT '联系电话'", "OCCUPATION":"varchar(255) NOT NULL COMMENT '职业'", "COMPANY":"varchar(100) NOT NULL COMMENT '单位'" } }

31、创建业务表professional

url:localhost:50002/services/table

{ "professional": { "BEGIN_DATE": "DATE NOT NULL COMMENT '营销开始日期'", "END_DATE": "DATE NOT NULL COMMENT '营销结束日期'", "NUM": "int(255) NOT NULL COMMENT '排名：在成员行内的排名'", "JDKHS": "int(255) NOT NULL COMMENT '建档户数 '", "SXKHS": "int(255) NOT NULL COMMENT '授信户数'", "FFDKKHS": "int(10) NOT NULL COMMENT '发放贷款户数'", "FFDKYE": "decimal(50,2) NOT NULL COMMENT '发放贷款余额'", "ZDGJKHS": "int(255) NOT NULL COMMENT '重点跟进客户'", "DQHFKHS": "int(255) NOT NULL COMMENT '定期回访客户'", "YBGZKHS": "int(255) NOT NULL COMMENT '一般关注客户'", "BYPJKHS": "int(255) NOT NULL COMMENT '不予评级客户'", "HMDKHS": "int(255) NOT NULL COMMENT '黑名单'", "BFWGKHS": "int(255) NOT NULL COMMENT '拜访未果'", "ACTIVITY_ID": "varchar(100) NOT NULL COMMENT '活动编号'", "MARKET_STATUS": "varchar(10) NULL COMMENT '活动编号'", "ASSIGN_TELLER": "varchar(100) NOT NULL COMMENT'营销客户经理'", "MARKET_UNIT": "varchar(100) NOT NULL COMMENT'营销机构'" } }

33创建金融需求表_financial

url:localhost:50002/services/table

{ "financial": { "CP_MYD": "varchar(11) NOT NULL COMMENT'对我行(社)产品满意度CP_MYD：01:较为适用；02:需进一步改进；03:很差'", "LN_ZJXQ": "varchar(11) NOT NULL COMMENT'在未来两年内是否有资金需求LN_ZJXQ：01:很需要；02:需要；03:不需要'", "DKJH": "varchar(11) NOT NULL COMMENT'如需贷款您计划用贷款做什么DKJH：多选以逗号分隔，01:做生意周转；02:购买农业生产资料；03:子女上学；04:盖（买）房子；05:购买大件物品；06:其他'", "XW_DKJE": "int(255) NOT NULL COMMENT'希望得到的贷款金额是多少（万元）XW_DKJE：正整数，最大长度6位'", "XW_DKQX": "int(100) NOT NULL COMMENT'希望得到的贷款期限是多久（月）XW_DKQX：正整数，最大长度3位'", "DBW": "varchar(11) NOT NULL COMMENT'可提供的担保物DBW：多选以逗号分隔，01:房地产；02:存单、债券；03:保证人；04:无'", "LSDK": "varchar(11) NOT NULL COMMENT'贷款投向是否符合绿色信贷LSDK：01:是；02:否'", "LSDK_FL": "varchar(11) NOT NULL COMMENT'绿色贷款项目分类LSDK_FL：《绿色贷款分类.XLSX》中的PARA_VALUE'", "XCZXZL": "varchar(11) NOT NULL COMMENT'贷款投向是否属于支持乡村振兴战略XCZXZL：01:是；02:否'", "XCZXZL_FL": "varchar(11) NOT NULL COMMENT'支持乡村振兴战略项目分类XCZXZL_FL：01:无；02:节能环保；03:新能源；04:新材料；05:生物和新医药；06:新一代信息技术；07:航空；08:先进装备制造；09:锂电及电动车；10:文化暨创意；11:绿色食品'", "LN_ZYYT": "varchar(11) NOT NULL COMMENT'未来1—2年储蓄的主要用途LN_ZYYT：多选以逗号分隔，01:做生意；02:子女上学；03:盖（买）房子；04:购买大件物品；05:获得利息；06:购买其他金融资产'", "OTHER": "varchar(33) NOT NULL COMMENT'其他'", "JRFWYX": "varchar(11) NOT NULL COMMENT'获得金融服务意向JRFWYX：多选以逗号分隔，01:存款；02:汇兑；03:结算；04:贷款；05:信用卡办理；06:个人理财服务；07:代缴代收服务；08:贵重物品保管；09:外汇买卖；10:金融政策、知识的宣传'", "KHJY": "varchar(11) NOT NULL COMMENT'客户建议KHJY：最大长度100中文'", "KHBLYX": "varchar(11) NOT NULL COMMENT'客户业办理意向KHBLYX：多选以逗号分隔，01新建客户；02移动开卡；03自助设备转账签约；04两银签约；05短信签约；06贷款申请；07购买理财；08动态令牌发放；09电费缴费签约；10信用卡申请；11校园通进件；12社区通进件'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'" } }

36创建任务表–task

url:localhost:50002/services/table

{ "task": { "TASK_NAME": "varchar(100) NOT NULL COMMENT '任务名称'", "TASK_STATUS": "varchar(5) NOT NULL COMMENT '任务状态: 0:待办任务 1：已办任务'", "STATUS": "varchar(25) NOT NULL COMMENT '任务状态: 0:正常 1：终止'", "PRODUCT_NUM": " varchar(255) NOT NULL COMMENT '产品数'", "ACTIVITY_ID": "varchar(100) NOT NULL COMMENT '活动ID'", "BEGIN_DATE": "date NOT NULL COMMENT '开始日期'", "END_DATE": "date NOT NULL COMMENT '结束日期'", "CREATE_TELLER": "varchar(100) NOT NULL COMMENT '创建人'", "TEMP_TYPE": "varchar(10) NOT NULL COMMENT '模版类型：01基础模版 02自定义模版'", "ON_DATE": "date NOT NULL COMMENT '生效时间'", "OFF_DATE": "date NOT NULL COMMENT '失效时间'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "TIME_UNITS_DESC": "time NULL COMMENT'时间粒度'", "MBZ": "varchar(100) NOT NULL COMMENT'目标值'", "WCZ": "varchar(100) NOT NULL COMMENT'完成值'", "WCB": "varchar(100) NOT NULL COMMENT'完成比'", "DTADAT": "date NULL COMMENT'数据日期'" } }

38创建产品表–product

url:localhost:50002/services/table

{ "product": { "TASK_ID": "varchar(100) NOT NULL COMMENT '任务ID'", "PRODUCT_ID": "varchar(5) NOT NULL COMMENT '产品ID'", "PRODUCT_NAME": "varchar(25) NOT NULL COMMENT '产品名称'", "PRODUCT_NUM": " varchar(255) NOT NULL COMMENT '产品数'", "UNITS": "varchar(100) NOT NULL COMMENT '单位'", "TARGET": "varchar(100) NOT NULL COMMENT '目标值'", "FINISH_VAL": "varchar(100) NOT NULL COMMENT '完成值'", "FINISH_PERCENT": "varchar(100) NOT NULL COMMENT '完成比'", "BEGIN_DATE": "date NOT NULL COMMENT '开始时间'", "END_DATE": "date NOT NULL COMMENT '结束日期'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "prd_name":"varchar(100) NOT NULL COMMENT'产品使用情况'" } }

39、创建营销业绩汇总表–marketing_performance

url:localhost:50002/services/table

{ "marketing_performance": { "QUERY_TYPE": "varchar(100) NOT NULL COMMENT '查询范围：筛选条件，单选:02网点 03客户经理'", "ORDER_TYPE": "varchar(100) NOT NULL COMMENT '排序方式: 筛选条件，单选,'", "JDRQ": "varchar(100) NOT NULL COMMENT '客户建档'", "SCJDCKNRJ": " varchar(255) NOT NULL COMMENT '存款年日均变化'", "SCCKYE": "decimal(10,2) NOT NULL COMMENT '新增存款金额'", "CKKLH": "int(255) NOT NULL COMMENT '新增存款户数'", "DQSXJE": "decimal(10,2) NOT NULL COMMENT '新增授信金额'", "SCSXRQ": "varchar(100) NOT NULL COMMENT '新增授信户数'", "YXJE": "decimal(10,2) NOT NULL COMMENT '新增用信金额'", "DYCYXRQ": "int(100) NOT NULL COMMENT '新增用信户数'", "LCCPQYRQ": "int(100) NOT NULL COMMENT '理财产品户数'", "LCCPJE": "decimal(10,2) NOT NULL COMMENT '理财产品金额'", "BEGIN_DATE": "date NOT NULL COMMENT '营销开始时间'", "END_DATE": "date NOT NULL COMMENT '营销结束日期'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'", "DQSXJE_START": "decimal(10,2) NULL COMMENT '授信金额最小值'", "DQSXJE_END": "decimal(10,2) NULL COMMENT '授信金额最大值'", "YXJE_START": "decimal(10,2) NULL COMMENT '用信金额最小值'", "YXJE_END": "decimal(10,2) NULL COMMENT '用信金额最大值'", "KHBLYWQY": "varchar(100) NULL COMMENT '业务签约：筛选条件,选填，多选以逗号分隔，sjyhqyrq：手机；wsyhqyrq: 网银；jhzfqyrq: 聚合支付；etcqyrq:ETC；posqyrq:POS；ebaifuqyrq: E百福 xykqyr:信用卡签约; lccpqyrq: 理财产品签约'", "JDRQ_DATE": "date NULL COMMENT '客户建档日期'", "DSCJKHXX": "date NULL COMMENT '创建客户信息日期（个人）'", "DGCJKHXX": "date NULL COMMENT '创建客户信息日期（对公）'", "SCSXJE": "decimal(10,2) NULL COMMENT '建档后首次授信金额（元）'", "DQSXJE_NOW": "decimal(10,2) NULL COMMENT '当前授信总金额（元）'", "SCSXRQ_DATE": "date NULL COMMENT '首次授信日期'", "DYCYXRQ_DATE": "date NULL COMMENT '第一次用信日期'", "CSED": "decimal(10,2) NULL COMMENT '测算额度（元）'", "CKYE_SCCKYE": "decimal(10,2) NULL COMMENT '新增存款金额(元）'", "DKYE_SCJDDKYE": "decimal(10,2) NULL COMMENT '贷款余额变化（元）'", "SJYHQYRQ": "date NULL COMMENT '签约手机银行日期'", "WSYHQYRQ": "date NULL COMMENT '签约网上银行日期'", "JHZFQYRQ": "date NULL COMMENT '签约聚合支付日期'", "ETC": "date NULL COMMENT '签约ETC日期'", "POSQYRQ": "date NULL COMMENT '签约POS日期'", "EBAIFUQYRQ": "date NULL COMMENT '签约E百福日期'", "ZHCQY": "date NULL COMMENT '首次签约或开立智慧存产品日期'", "XYKQYRQ": "date NULL COMMENT '信用卡签约日期'", "LCCPQYRQ_DATE": "date NULL COMMENT '理财产品签约日期'", "SBKJHRQ": "date NULL COMMENT '社保卡激活日期'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "YXRQ": "date NULL COMMENT '营销日期'", "SCJDDKNRJ": " varchar(255) NOT NULL COMMENT '贷款年日均变化(元)'", "SCJDDKYE": "decimal(10,2) NOT NULL COMMENT '贷款余额变化(元) '", "JD_FLAG": " varchar(255) NOT NULL COMMENT '建档标志'" } }

45、创建金融地图数据表financial_map_data

url:localhost:50002/services/table

{ "financial_map_data": { "ANCBRTCOD": "varchar(100) NOT NULL COMMENT'上级机构代码(省、市、成员行)，用于查询该机构的下级机构数据'", "DATEFLG": "varchar(10) NOT NULL COMMENT'日期标志：1查询日，2查询月'", "DTADAT": "date NOT NULL COMMENT'日期'", "OBJCOD": "varchar(255) NOT NULL COMMENT'对象代码'", "OBJNUM": "int(255) NOT NULL COMMENT'对象户籍总数'", "OBJCKZJE": "decimal(50,2) NOT NULL COMMENT'对象存款增加额'", "OBJDKZJE": "decimal(50,2) NOT NULL COMMENT'对象贷款增加额'", "OBJXYZHL": "double NOT NULL COMMENT'对象四扫效益转换率'", "OBJXYZHLPM": " int(255) NOT NULL COMMENT'对象四扫效益转换率排名'", "OBJSSJDNUM": "int(100) NOT NULL COMMENT'对象完成四扫建档户数'", "OBJSSJDPM": "int(25)NOT NULL COMMENT'对象完成四扫建档数排名'", "OBJSSWCB": "double NOT NULL COMMENT'对象四扫完成比/建档覆盖率'", "OBJJDNUMBSY": "double NOT NULL COMMENT'对象已完成建档户比上月'", "OBJJDNUMBNC": "double NOT NULL COMMENT'对象已完成建档户比年初'", "OBJSXFGL": "double NOT NULL COMMENT'对象授信覆盖率'", "OBJWJDNUM": "int(100) NOT NULL COMMENT'对象未完成建档户'", "OBJWJDNUMBSY": "double NOT NULL COMMENT'对象未完成建档户比上月'", "OBJWJDNUMBNC": "double NOT NULL COMMENT'对象未完成建档户比年初'", "OBJYSXNUM": "int(255) NOT NULL COMMENT'对象已授信户数'", "OBJYSXNUMBSY": "double NOT NULL COMMENT'对象已授信户数比上月'", "OBJYSXNUMBNC": "double NOT NULL COMMENT'对象已授信户数比年初'", "OBJWSXNUM": "int(255) NOT NULL COMMENT'对象未授信户数'", "OBJWSXNUMBSY": "double NOT NULL COMMENT'对象未授信户数比上月'", "OBJWSXNUMBNC": "double NOT NULL COMMENT'对象未授信户数比年初'", "OBJYXHS": "int(255) NOT NULL COMMENT'对象用信户数'", "OBJYXHSBSY": "double NOT NULL COMMENT'对象用信户数比上月'", "OBJYXHSBNC": "double NOT NULL COMMENT'对象用信户数比年初'", "OBJYXJE": "decimal(50,2) NOT NULL COMMENT'对象用信金额'", "OBJYXJEBSY": "double NOT NULL COMMENT'对象用信金额比上月'", "OBJYXJEBNC": "double NOT NULL COMMENT'对象用信金额比年初'", "OBJYXFGL": "double NOT NULL COMMENT'对象用信覆盖率'", "OBJYXFGLBSY": "double NOT NULL COMMENT'对象用信覆盖率比上月'", "OBJSXFGLBSY": "double NOT NULL COMMENT'对象授信覆盖率比上月'", "OBJSSWCBBSY": "double NOT NULL COMMENT'对象四扫完成比/建档覆盖率比上月'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'" } }

46、创建表金融趋势图financial_trend_map

url:localhost:50002/services/table

{ "financial_trend_map": { "OBJCOD": "varchar(100) NOT NULL COMMENT'省联社、成员行机构代码，用于查询该机构的趋势图数据'", "DATEFLG": "varchar(10) NOT NULL COMMENT'日期标志：1查询日，2查询月'", "DTADAT": "date NOT NULL COMMENT'日期'", "BEGINDATE": "date NOT NULL COMMENT'开始日期'", "ENDDATE": "date NOT NULL COMMENT'结束日期'", "JDHS": "int(255) NOT NULL COMMENT'建档户数'", "JDHCKRJ": "decimal(50,2) NOT NULL COMMENT'建档户存款日均(万元)'", "JDHDKYE": "decimal(50,2) NOT NULL COMMENT'建档户贷款余额(万元)'", "JDHKHZS": "int(255) NOT NULL COMMENT'建档户开户总数'", "JDHSJYHQY": " int(255) NOT NULL COMMENT'建档户手机银行签约'", "JDHETCQY": "int(100) NOT NULL COMMENT'建档户ETC签约'", "JDHSBKJH": "int(25)NOT NULL COMMENT'建档户社保卡激活'", "JDHJHZFQY": "int(25)NOT NULL COMMENT'建档户聚合支付签约'", "JDHEBFQY": "int(25)NOT NULL COMMENT'建档户E百福签约'", "JDHSBSY": "double NOT NULL COMMENT'建党户数比上月'", "JDHCKRJBSY": "double NOT NULL COMMENT'建档户存款日均比上月(万元)'", "JDHDKYEBSY": "double NOT NULL COMMENT'建档户贷款余额比上月(万元)'", "JDHKHZSBSY": "double NOT NULL COMMENT'建档户开户总数比上月'", "JDHSJYHQYBSY": "double NOT NULL COMMENT'建档户手机银行签约比上月'", "JDHETCQYBSY": "double NOT NULL COMMENT'建档户ETC签约比上月'", "JDHSBKJHBSY": "double NOT NULL COMMENT'建档户社保卡激活比上月'", "JDHJHZFQYBSY": "double NOT NULL COMMENT'建档户聚合支付签约比上月'", "JDHEBFQYBSY": "double NOT NULL COMMENT'建档户E百福签约比上月'", "entry_teller": "varchar(255) NOT NULL COMMENT '柜员号'", "ckye": "decimal(50,2) NOT NULL COMMENT'存款余额'", "ckrj": "decimal(50,2) NOT NULL COMMENT'存款日均'", "dkkhyezrmb": "decimal(50,2) NOT NULL COMMENT'贷款余额'", "lcck": "decimal(50,2) NOT NULL COMMENT'理财余额'", "flagmark": "decimal(50) NOT NULL COMMENT'总签约数'", "signSum": "varchar(255) NOT NULL COMMENT'签约明细'", "bnljjybs": "decimal(60,0) NOT NULL COMMENT'本年度存款累计交易笔数'", "bnjyljjyje": "decimal(60,2) NOT NULL COMMENT'本年度累计交易金额'", "kh052": "decimal(60,2) NOT NULL COMMENT'总净利润'", "kh050": "decimal(60,2) NOT NULL COMMENT'存款净利润'", "kh051": "decimal(60,2) NOT NULL COMMENT'贷款净利润'" } }

49、小额信贷CREDIT_INDEX

{ "agency": { "ANCBRTCOD": "varchar(255) NOT NULL COMMENT '联社号'", "unitLvl": "varchar(255) NOT NULL COMMENT '机构层次'", "OBJTYPE": "varchar(255) NOT NULL COMMENT '机构类别'", "BEL_UNIT": "varchar(255) NOT NULL COMMENT'机构号'", "MEAVAL": "int(255) NOT NULL COMMENT'当日客户数'", "MEAVAL_LASTYEAR": "int(255) NOT NULL COMMENT'较上年末的客户数'" } }

url:localhost:50002/services/table

{ "CREDIT_INDEX": { "CUSTID": "varchar(100) NOT NULL COMMENT '客户号'", "HEALTH": "varchar(100) NOT NULL COMMENT '身体状况'", "FLOW_ID": "varchar(10) NOT NULL COMMENT '流水号'", "MARITALSTATUS": "varchar(100) NOT NULL COMMENT '婚姻状况'", "AGE": "varchar(100) NOT NULL COMMENT '年龄'", "SS0011": "varchar(100) COMMENT '品行及信誉'", "SSZD0003": "varchar(100) COMMENT '经营年限或则工作年限'", "SSZD0004": "varchar(100) NOT NULL COMMENT '净资产'", "SSZD0005": "varchar(100) NOT NULL COMMENT '纯收入'", "SSZD0006": "varchar(100) COMMENT '业务开办情况'", "SSZD0007": "varchar(100) COMMENT '存款贡献'", "SSZD0008": "varchar(100) COMMENT '利息贡献'", "SSZD0009": "varchar(100) NOT NULL COMMENT '同盾信用'", "SSZD0010": "varchar(100) NOT NULL COMMENT '征信信用'", "SSZD0014": "varchar(100) COMMENT '经营规模'", "SSZD0015": "varchar(100) NOT NULL COMMENT '总资产'", "SSZD0016": "varchar(100) COMMENT '职务'", "SSZD0017": "varchar(100) NOT NULL COMMENT '年收入'", "ANCBRTCOD": "varchar(100) NOT NULL COMMENT '法人机构号'", "ysxed": "decimal(50,2) NOT NULL COMMENT '预授信额度'" } }

credit_apply

{ "credit_apply":{ "CUSTID":"varchar(100) NOT NULL COMMENT '客户号'", "APTYPE":"varchar(10) NOT NULL COMMENT '申请类型'", "CUSTNM":"varchar(100) NOT NULL COMMENT '客户名称'", "CUTSEX":"varchar(10) NOT NULL COMMENT '客户性别'", "CERTNO":"varchar(100) NOT NULL COMMENT '身份证号'", "PHOENM":"varchar(100) NOT NULL COMMENT '手机号'", "LEGNID":"varchar(100) NOT NULL COMMENT '法人机构号'", "UNITID":"varchar(100) NOT NULL COMMENT '机构号'", "TELLERID":"varchar(100) NOT NULL COMMENT '客户经理'", "FLOWID":"varchar(100) NOT NULL COMMENT '流水号'", "COUNTRY":"varchar(100) NOT NULL COMMENT '国籍'", "HOUSES":"varchar(100) NOT NULL COMMENT '居住状况'", "NATION":"varchar(100) NOT NULL COMMENT '民族'", "HOMEADDRTOTAL":"varchar(100) NOT NULL COMMENT '居住地址'", "ISMARRIED":"varchar(100) NOT NULL COMMENT '婚姻状况'", "MONEYPERYEAR":"DOUBLE NOT NULL COMMENT '家庭年收入'", "BUYSTOCKMONEY":"DOUBLE COMMENT '入股金额'", "SMALLFLAG":"varchar(100) COMMENT '小微企业主标志'", "ISENTREPRENEUR":"varchar(100) NOT NULL COMMENT '创业者标志'", "ENTREPRENEURTYPE":"varchar(100) COMMENT '创业者类型'", "SMALLCUSSTANDARD":"varchar(100) COMMENT '人行小微客户标准'", "FINANCINGINSTITUTIONCODE":"varchar(100) COMMENT '基本账户行'", "EDULEV":"varchar(100) NOT NULL COMMENT '最高学历'", "TOPDEGREE":"varchar(100) NOT NULL COMMENT '最高学位'", "POLITY":"varchar(10) NOT NULL COMMENT '政治面貌'", "JOB":"varchar(100) NOT NULL COMMENT '职业'", "TRADETYPE":"varchar(10) NOT NULL COMMENT '行业分类'", "HEALTH":"varchar(100) NOT NULL COMMENT '身体状况'", "REDBLACKLIST":"varchar(100) NOT NULL COMMENT '红黑名单'", "ISCORRELATSIGN":"varchar(10) NOT NULL COMMENT '关联人是否签字'", "CORRELATNAME":"varchar(100) NOT NULL COMMENT '关联人名称'", "CORRELATIDCARD":"varchar(100) NOT NULL COMMENT '关联人身份证号码'", "CORRELATTEL":"varchar(100) NOT NULL COMMENT '关联人联系电话'", "CORRELATIONTYPE":"varchar(100) NOT NULL COMMENT '关联种类'", "HANDL_STATUS":"varchar(10) NOT NULL COMMENT '办理状态 01 待办，02 已办'", "FLOW_ID":"varchar(10) NOT NULL COMMENT '流水号'" } }

credit_zx

{ "CREDIT_ZX":{ "CERTNO":"varchar(100) NOT NULL COMMENT '身份证号'", "SPASS":"varchar(100) NOT NULL COMMENT '是否通过'", "REPORTID":"varchar(100) NOT NULL COMMENT '报告编码'", "REPORTSTS":"varchar(100) NOT NULL COMMENT '是否有征信报告'", "RESIDESTAT":"varchar(100) NOT NULL COMMENT '房产状况'", "MARRIGE":"varchar(100) NOT NULL COMMENT '婚姻状况'", "EDULEV":"varchar(100) NOT NULL COMMENT '最高学历'", "HOMEADDRE":"varchar(100) NOT NULL COMMENT '居住地址'", "COMPANY":"varchar(100) NOT NULL COMMENT '工作单位'", "WORKADDRE":"varchar(100) NOT NULL COMMENT '单位地址'", "LOANPERNUM":"varchar(100) COMMENT '未结清贷款法人数量'", "LOANPERAMT":"double COMMENT '未结清贷款余额'", "LOANCNT":"int COMMENT '当前贷款逾期笔数'", "LOANBLANCEAMT":"double COMMENT '当前贷款逾期金额'", "DEBITCNT":"int COMMENT '当前贷记卡逾期个数'", "DEBITAMT":"double COMMENT '当前贷记卡逾期金额'", "LOAN60MAXCNT":"int COMMENT '贷款近60个月内最长连续逾期期数'", "LOAN60SUMCNT":"int COMMENT '贷款近60个月内累计逾期次数'", "LOAN24MONINFO":"varchar(100) COMMENT '贷款24月还款状态'", "DEBIT24MONINFO":"varchar(100) COMMENT '贷记卡24月还款状态'", "REDEBIT24MONINFO":"varchar(100) COMMENT '准贷记卡24月还款状态'", "PLEDGEAMT":"double COMMENT '抵押贷款余额'", "LOANAMT":"double COMMENT '信用类贷款的贷款余额'", "GUARANTAMT":"double COMMENT '保证类贷款的贷款余额'", "MAYPAY6MON":"double COMMENT '近6个月平均应还款金额'", "DEBITSTS":"varchar(100) NOT NULL COMMENT '是否有贷记卡（包括准贷记卡）'", "SUM1MONDEBITAPPR":"int COMMENT '近1个月信用卡查询次数'", "SUM1MONLOANAPPR":"int COMMENT '近1个月贷款审批查询次数'", "SUM1MONGURANTAPPR ":"int COMMENT '近1个月担保资格审查查询次数'", "SUM12MONDEBITAPPR":"int COMMENT '近12个月信用卡审批查询次数'", "SUM12MONLOANAPPR":"int COMMENT '近12个月贷款审批查询次数'", "SUM12MONGURANTAPPR":"int COMMENT '近12个月担保资格审查查询次数'", "SUM24MONLOANLATEAPPR":"int COMMENT '近24月贷后管理查询次数'", "SEMINUM":"int COMMENT '对外担保未结清笔数'", "SEMIAMT":"double COMMENT '对外担保余额'", "DEBITBRNOCNT":"int COMMENT '贷记卡发卡机构数（包括准贷记卡）'", "DEBITGRANTAMT":"double COMMENT '信用卡总授信额度'", "DEBIT6MONAVANTAMT":"double COMMENT '信用卡近6个月平均使用额度'", "BADLOANCNT":"int COMMENT '不良贷款笔数'", "BADLOANAMT":"double COMMENT '不良贷款余额'", "SPECIALCNT":"int COMMENT '特殊交易笔数'", "TAXARREACNT":"int COMMENT '欠税记录个数'", "ACCFUNDINFO":"varchar(100) COMMENT '公积金缴至月份|月缴存额'", "OVERDUESTATEB":"varchar(100) COMMENT '借款人逾期情况（行内）'", "BADLOANB":"varchar(100) COMMENT '借款人不良贷款（行内）'", "LOANSTATUSB":"varchar(100) COMMENT '借款人贷款状态'", "OVERDUESTATEP":"varchar(100) COMMENT '配偶逾期情况（行内）'", "BADLOANP":"varchar(100) COMMENT '配偶不良贷款（行内）'", "LOANSTATUSP":"varchar(100) COMMENT '配偶贷款状态'", "BAKUP1":"varchar(100) COMMENT '备用1'", "BAKUP2":"varchar(100) COMMENT '备用2'", "DEBIT6MONYQ":"int COMMENT '贷记卡6个月内最长逾期期数'", "DEBIT6MONYQNUM":"int COMMENT '贷记卡6个月内累计逾期次数'", "DEBIT12MONYQ":"int COMMENT '贷记卡12个月内最长逾期期数'", "DEBIT12MONYQNUM":"int COMMENT '贷记卡12个月内累计逾期次数'", "DEBIT24MONYQ":"int COMMENT '贷记卡24个月内最长逾期期数'", "DEBIT24MONYQNUM":"int COMMENT '贷记卡24个月内累计逾期次数'", "LOAN12MONYQ":"int COMMENT '贷款12个月内最长逾期期数'", "LOAN12MONYQNUM":"int COMMENT '贷款12个月内累计逾期次数'", "LOAN24MONYQ":"int COMMENT '贷款24个月内最长逾期期数'", "LOAN24MONYQNUM":"int COMMENT '贷款24个月内累计逾期次数'", "O2RLNAME":"varchar(100) NOT NULL COMMENT '命中规则'", "O2RLVAUE":"varchar(100) NOT NULL COMMENT '命中值 '" } }

credit_post

{ "CREDIT_POST": { "CUSTID":"varchar(100) NOT NULL COMMENT '客户号'", "TELLERID":"varchar(100) NOT NULL COMMENT '客户经理'", "UNITID":"varchar(100) NOT NULL COMMENT '机构'", "CUSTOMERCLASSIFY":"varchar(100) NOT NULL COMMENT '客户主体分类'", "LOANKINDCLASSIFY":"varchar(100) NOT NULL COMMENT '业务种类分类'", "ASSURETYPECLASSIFY":"varchar(100) NOT NULL COMMENT '贷款方式分类'", "PRODUCTID":"varchar(100) NOT NULL COMMENT '产品'", "TNFLAG":"varchar(100) NOT NULL COMMENT '业务条线'", "LOANUSECLASSIFY":"varchar(100) NOT NULL COMMENT '借款用途分类'", "APPLYTERM":"varchar(100) NOT NULL COMMENT '申请借款期限'", "APPLYAMOUNT":"double NOT NULL COMMENT '申请借款金额(元)'", "LOANUSE":"varchar(100) NOT NULL COMMENT '借款用途'", "LOANFORM":"varchar(100) NOT NULL COMMENT '发放类型'", "LOANINVEST":"varchar(100) COMMENT '贷款投向（给予规则前端送，业务种类转化）'", "XHFLAG":"varchar(100) NOT NULL COMMENT '循环标志'", "JXCYCLE":"varchar(100) NOT NULL COMMENT '结息周期'", "INTEREXMODEL":"varchar(100) NOT NULL COMMENT '利率执行方式'", "INTEREST":"varchar(100) NOT NULL COMMENT '浮动比例'", "EXEINTEREST":"varchar(100) NOT NULL COMMENT '执行利率(%)'", "YQINTERFLOAT":"varchar(100) NOT NULL COMMENT '逾期利率上浮幅度(%)'", "FXFLAG":"varchar(100) NOT NULL COMMENT '是否收取复息'", "INTERTZMODEL":"varchar(100) NOT NULL COMMENT '利息调整方式'", "WFLSQ":"varchar(100) COMMENT '未分类（申请）'", "JBZZ":"varchar(100) COMMENT '基本证照(申请)'", "SFZM":"varchar(100) COMMENT '身份证明'", "SQZL":"varchar(100) COMMENT '申请资料'", "SFZ":"varchar(100) COMMENT '身份证'", "rateType":"varchar(100) NOT NULL COMMENT '贷款定价利率基准类型'", "CURDATE":"varchar(20) NOT NULL COMMENT '维护日期'", "FLOW_ID":"varchar(10) NOT NULL COMMENT '流水号'" } }

credit_survey

{ "CREDIT_SURVEY":{ "CUSTID":"varchar(100) NOT NULL COMMENT '客户号'", "DC1":"varchar(100) COMMENT '借款人主体资格合法'", "DC2":"varchar(100) COMMENT '法人代表或授权委托人签章、个人客户签单有效'", "DC3":"varchar(100) COMMENT '营业执照或事业法人登记证书有效'", "DC4":"varchar(100) COMMENT '相关许可证、合格证、资质证齐全且有效'", "DC5":"varchar(100) COMMENT '单位印签有效'", "DC6":"varchar(100) COMMENT '贷款或担保经过董事会、股东会决议'", "DC7":"varchar(100) COMMENT '借款用途合法'", "DC8":"varchar(100) COMMENT '借款人符合贷款条件和对象的规定'", "DC9":"varchar(100) COMMENT '用款计划合理'", "DC10":"varchar(100) COMMENT '偿债能力分析'", "DC11":"varchar(100) COMMENT '还款来源分析'", "DC12":"varchar(100) COMMENT '财务情况分析'", "DC13":"varchar(100) COMMENT '信用情况记录'", "DCYJ":"varchar(100) NOT NULL COMMENT '调查意见'", "JZADD":"varchar(100) COMMENT '是否支持自助用信'", "DCTELLERS":"varchar(100) NOT NULL COMMENT '调查责任人'", "DCMAINTELLER":"varchar(100) NOT NULL COMMENT '调查主责任人'", "MAINTELLER":"varchar(100) NOT NULL COMMENT '管理责任人'", "FIRSTTELLER":"varchar(100) NOT NULL COMMENT '第一责任人'", "SYBFLAG":"varchar(100) COMMENT '是否创业贷标识'", "ISGREEN":"varchar(100) NOT NULL COMMENT '是否绿色贷款'", "ISPOOR":"varchar(100) COMMENT '是否精准扶贫贷款'", "WFLDC":"varchar(100) COMMENT '未分类（调查）'", "RWZP":"varchar(100) COMMENT '现场影像'", "JBZZ2":"varchar(100) COMMENT '基本证照'", "CWBB":"varchar(100) COMMENT '财务报表'", "ZCZM":"varchar(100) COMMENT '资产证明'", "ZZZS":"varchar(100) COMMENT '资质证书'", "JYZL":"varchar(100) COMMENT '经营资料'", "ZXBG":"varchar(100) COMMENT '征信报告'", "FLWS":"varchar(100) COMMENT '法律文书'", "JKYT":"varchar(100) COMMENT '用途资料'", "DBZL":"varchar(100) COMMENT '担保资料'", "DSZL":"varchar(100) COMMENT '贷审资料'", "BAKUP1":"varchar(100) COMMENT '备用1'", "FLOW_ID":"varchar(10) NOT NULL COMMENT '流水号'" } }

credit_image

{ "CREDIT_IMAGE":{ "ID":"varchar(100) NOT NULL COMMENT '流水号'", "CUSTOMERID":"varchar(100) NOT NULL COMMENT '客户号'", "CUSTNM":"varchar(100) NOT NULL COMMENT '客户名称'", "ANCBRTCOD":"varchar(100) NOT NULL COMMENT '联社号'", "JBXX108":"varchar(100) NOT NULL COMMENT '证件号'", "FLOW_ID":"varchar(10) NOT NULL COMMENT '流水号'", "影像指标1":"varchar(500) COMMENT '影像文件'" } }

credit_product

{ "CREDIT_PRODUCT":{ "productId":"varchar(255) NOT NULL COMMENT '产品编号'", "productName":"varchar(255) NOT NULL COMMENT '产品名称'", "xyFlag":"varchar(255) NOT NULL COMMENT '协议标志'", "ajFlag":"varchar(255) NOT NULL COMMENT '是否按揭'", "txFlag":"varchar(255) NOT NULL COMMENT '是否贴息'", "loanPricingBaseRateType":"varchar(255) NOT NULL COMMENT '贷款定价利率基准类型 0:人行基准利率 1：lpr'", "CUSTOMERCLASSIFY":"varchar(255) NOT NULL COMMENT '客户主体分类'", "LOANKINDCLASSIFY":"varchar(255) NOT NULL COMMENT '业务种类分类'", "ASSURETYPECLASSIFY":"varchar(255) NOT NULL COMMENT '贷款方式分类'", "UNITID":"varchar(255) NOT NULL COMMENT '机构号'" } }

credit_interest

{ "CREDIT_INTEREST":{ "INTEREST":"double NOT NULL COMMENT '浮点/浮比/年利率'", "LOANTERM":"int NOT NULL COMMENT '贷款期限'", "INTEREXMODEL":"int NOT NULL COMMENT '利率执行方式 1浮比2浮点3固定'", "AJLOAN":"varchar(10) NOT NULL COMMENT '人行基准利率01 非按揭 02按揭 lpr 07非按揭 08按揭'", "APPLYID":"varchar(100) COMMENT '申请编号'", "RATE":"double NOT NULL COMMENT '执行利率'" } }

65、创建机构表agency

url:localhost:50002/services/table

66、创建一个级别表level

url:localhost:50002/services/table

{ "level": { "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'", "CHG_LEVEL_BEFORE": "varchar(255) NOT NULL COMMENT '调整前级别'", "CHG_LEVEL_AFTER": "varchar(255) NOT NULL COMMENT '调整后级别'", "MISS_TIME": "time NOT NULL COMMENT'流失时间'", "BEL_UNIT": "varchar(255) NOT NULL COMMENT'机构号'", "MEACOD": "varchar(255) NULL COMMENT'指标：MOBILE0004 当天升级客户数，MOBILE0005 当天降级客户数，MOBILE0006 流失客户数'", "MISS_BEFORE_CUST_LEVEL": "varchar(255) NULL COMMENT'流失前级别'", "FIRST_LEVEL_TIME": "DATETIME NULL COMMENT'首次评级时间'", "MEACOD_ID": "varchar(255) NOT NULL COMMENT'指标编号'" } }

72、创建日程信息表schedule

url:localhost:50002/services/table

{ "schedule": { "THEME": "varchar(100) NOT NULL COMMENT'日程名称'", "BEG_DATE": "date NOT NULL COMMENT'开始日期'", "END_DATE": "date NOT NULL COMMENT'结束日期'", "START_TIME": "DATETIME NOT NULL COMMENT'开始时间'", "END_TIME": "DATETIME NOT NULL COMMENT'结束时间'", "CIRCLE": "varchar(100) NOT NULL COMMENT'周期循序'", "CONTENT": "varchar(100) NOT NULL COMMENT'备注'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'" } }

74、创建降幅表decline

url:localhost:50002/services/table

{ "decline": { "RANK": "int(100) NOT NULL COMMENT'排名'", "MEACOD": "varchar(100) NULL COMMENT'指标:交易笔数降幅 KH084 存款降幅 KH085 贷款降幅 KH086'", "meavallstdaydec": "decimal(50,2) NOT NULL COMMENT'比上日'", "meavallstmondec": "decimal(50,2) NOT NULL COMMENT'比上月'", "meavallstquarterdec": "decimal(50,2) NOT NULL COMMENT'比上季'", "meavalyearbgndec": "decimal(50,2) NOT NULL COMMENT'比年初'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'" } }

77、创建”影像“表imageurl

url:localhost:50002/services/table

{ "imageurl": { "SS0033": "varchar(255) NOT NULL COMMENT '影像-身份证'", "SS0035": "varchar(255) NOT NULL COMMENT '影像-身份证明'", "SS0339": "varchar(255) NOT NULL COMMENT '影像-资质证书'", "SS0037": "varchar(255) NOT NULL COMMENT '影像-法律文书'", "SS0036": "varchar(255) NOT NULL COMMENT '影像-现场影像'", "SS0090": "varchar(255) NOT NULL COMMENT '影像-经营资料'", "SS0366": "varchar(255) NOT NULL COMMENT '影像-未分类'", "CUSTNO": "varchar(255) NOT NULL COMMENT '客户号'", "CUSTUUID": "varchar(100) NOT NULL COMMENT'客户的唯一标识CUSTUUID' " } }

#####################################################################

1

1、给teller表添加角色

url:localhost:50002/services/post body:

{ "user[]": [ { "entry_teller": "t0001", "role_type": "90", "MONEYPERYEAR":"10000", "image_index":"url", "HAVE_OUT":"02", "ASSIGN_STATUS":"01", "JBXX108":"522732199610081017", "CUSTNO":"c0000110001" }, { "entry_teller": "t0002", "role_type": "80", "MONEYPERYEAR":"50000", "image_index":"url", "HAVE_OUT":"02", "ASSIGN_STATUS":"01", "JBXX108":"522732199610081018", "CUSTNO":"c0000110002" }, { "entry_teller": "t0003", "role_type": "20", "MONEYPERYEAR":"60000", "image_index":"url", "HAVE_OUT":"01", "ASSIGN_STATUS":"01", "JBXX108":"522732199610081019", "CUSTNO":"c0000110003" }, { "entry_teller": "t0004", "role_type": "10", "MONEYPERYEAR":"230000", "image_index":"url", "HAVE_OUT":"02", "ASSIGN_STATUS":"02", "JBXX108":"52273219961008101X", "CUSTNO":"c0000110004" }, { "entry_teller": "t0011", "role_type": "1", "MONEYPERYEAR":"770000", "image_index":"url", "HAVE_OUT":"01", "ASSIGN_STATUS":"02", "JBXX108":"522732199610081019", "CUSTNO":"c0000110005" } ] }

1、用户角色查询

url:localhost:50002/services/get body:

{ "[]": { "teller": { "entry_teller": "t0001", "@column": "role_type" }, "@count": 2, "@page": 0 } }

2

2、客户四扫数据查询_根据客户号

url:localhost:50002/services/get body:

{ "teller": { "role_type{}": [ 80, 20, 10 ], "ENTRY_TELLER": "t0004", "@column": "role_type" }, "[]": { "custom": { "custno": "c0000110001", "@column": "CUSTNO,ASSIGN_STATUS,MONEYPERYEAR,HAVE_OUT,OUT_NORM,image_index" } } }

2、客户四扫数据查询_根据证件号

url:localhost:50002/services/get body:

{ "teller": { "role_type{}": [ 80, 20, 10 ], "ENTRY_TELLER": "t0004", "@column": "role_type" }, "[]": { "custom": { "jbxx108": "522732199610081017", "@column": "CUSTNO,ASSIGN_STATUS,MONEYPERYEAR,HAVE_OUT,OUT_NORM,image_index" } } }

3

3、客户行内数据查询

url:localhost:50002/services/get body:

{ "custom": { "JBXX108": "522732199610081017", "@column": "CUSTNO" } }

3、role

url:localhost:50002/services/get body:

{ "teller": { "entry_teller": "t0004", "@column": "role_type" } }

4

4、添加列“外部数据类型编码”

url:localhost:50002/services/table body:

{ "teller": { "JBXX108":"varchar(255) NOT NULL", "CUSTNO":"varchar(255) NOT NULL", "ASSIGN_STATUS":"varchar(10) NOT NULL", "MONEYPERYEAR":"int NOT NULL", "image_index":"varchar(255) NOT NULL", "HAVE_OUT":"varchar(10) NOT NULL", "OUT_NORM":"varchar(255)", "external_data_type_code":"int NULL" } }

4、外部数据查询

url:localhost:50002/services/get body:

{ "custom": { "JBXX108": "522732199610081017", "@column": "JBXX101,JBXX107,JBXX108,external_data_type_code" } }

5

5、图片上传影像

url:localhost:50002/services/put body:

{ "custom": { "JBXX108": "522732199610081017", "IDENT": "02", "CUST_TYPE":"农户", "ENTRY_TELLER":"t0001", "JBXX101":"居民", "image_index":"'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "@content": "IDENT,CUST_TYPE,ACTIVITY_NAME,JBXX101,image_index" }, "activity":{ "ACTIVITY_NAME":"特别级活动", "ENTRY_TELLER":"t0001", "BUSSINES_ID":"f00001", "TEMP_ID":"t001", "ACTIVITY_ID":"a00001", "@content": "ACTIVITY_NAME,ENTRY_TELLER,BUSSINES_ID,TEMP_ID" } }

6

6、添加数据

url:localhost:50002/services/post body:

{ "activity[]": [ { "BUSSINES_ID": "f00001", "TEMP_ID": "t001", "ACTIVITY_ID": "a00001", "ENTRY_TELLER": "t0001", "ACTIVITY_NAME": "一般级活动", "@content":"ACTIVITY_NAME" }, { "BUSSINES_ID": "f00002", "TEMP_ID": "t002", "ACTIVITY_ID": "a00002", "ENTRY_TELLER": "t0002", "ACTIVITY_NAME": "县级活动", "@content":"ACTIVITY_NAME" }, { "BUSSINES_ID": "f00003", "TEMP_ID": "t003", "ACTIVITY_ID": "a00003", "ENTRY_TELLER": "t0003", "ACTIVITY_NAME": "乡级活动", "@content":"ACTIVITY_NAME" }, { "BUSSINES_ID": "f00004", "TEMP_ID": "t004", "ACTIVITY_ID": "a00004", "ENTRY_TELLER": "t0004", "ACTIVITY_NAME": "特别级活动", "@content":"ACTIVITY_NAME" }, { "BUSSINES_ID": "f00005", "TEMP_ID": "t005", "ACTIVITY_ID": "a00005", "ENTRY_TELLER": "t0005", "ACTIVITY_NAME": "普通级活动", "@content":"ACTIVITY_NAME" } ] }

6、四扫数据保存

url:localhost:50002/services/put body:

{ "custom": { "JBXX108": "522732199610081017", "CUSTNO": "c0000110004", "CUST_TYPE": "农户", "IDENT": "02", "@content": "CUSTNO,CUST_TYPE,IDENT" }, "activity": { "BUSSINES_ID": "00004", "TEMP_ID": "t004", "ACTIVITY_NAME": "特别级活动", "ACTIVITY_ID": "a00004", "@content": "TEMP_ID,ACTIVITY_NAME,ACTIVITY_ID" } }

7

7、为新增字段添加数据

url:localhost:50002/services/table body:

{ "teller[]": [ { "TELLER_ADDR": "beijing", "TELLER_LOCATION": "40°N,116°E", "entry_teller": "t0001", "@content": "TELLER_ADDR,TELLER_LOCATION" }, { "TELLER_ADDR": "天津", "TELLER_LOCATION": "30°N,99°E", "entry_teller": "t0002", "@content": "TELLER_ADDR,TELLER_LOCATION" }, { "TELLER_ADDR": "上海", "TELLER_LOCATION": "55°N,96°E", "entry_teller": "t0001", "@content": "TELLER_ADDR,TELLER_LOCATION" }, { "TELLER_ADDR": "南京", "TELLER_LOCATION": "70°N,86°E", "entry_teller": "t0003", "@content": "TELLER_ADDR,TELLER_LOCATION" }, { "TELLER_ADDR": "成都", "TELLER_LOCATION": "20°N,126°E", "entry_teller": "t0004", "@content": "TELLER_ADDR,TELLER_LOCATION" }, { "TELLER_ADDR": "西藏", "TELLER_LOCATION": "60°N,106°E", "entry_teller": "t0005", "@content": "TELLER_ADDR,TELLER_LOCATION" } ] }

7、四扫数据提交_获取数据

url:localhost:50002/services/get body:

{ "custom": { "JBXX108": "522732199610081017", "CUSTNO": "00004", "@column": "CUST_IDE,MONEYPERYEAR" }, "activity": { "entry_teller": "t0004", "@column": "TEMP_ID,ACTIVITY_ID" }, "teller": { "ENTRY_TELLER": "t0004", "@column": "ROLE_TYPE,TELLER_ADDR,TELLER_LOCATION" } }

7、四扫数据提交

url：localhost:50002/services/put

body：

{ "custom[]": [{ "JBXX108": "522732199610081017", "SS0306": 88880, "MONEYPERYEAR": 12340, "@content": "SS0306,MONEYPERYEAR" }] }

7、添加数据

url：localhost:50002/services/post

body：

{ "activity[]": [ { "BUSSINES_ID": "f00006", "TEMP_ID": "t006", "ACTIVITY_ID": "a00006", "ACTIVITY_NAME": "一级活动", "ENTRY_TELLER": "t0006", } ], "teller[]": [ { "role_type": "2", "entry_teller": "t0012", "corporate_id": "c0011", "TELLER_ADDR": "guangzhoui", "TELLER_LOCATION": "48°N,119°E" } ], "custom[]": [ { "MONEYPERYEAR": "9999", "HAVE_OUT": "02", "image_index": "'url':'<img src=\"https://abs.agree.com/img/055ee.jpg\" style=\"max-width: 100%;\"> ''<img src=\"https://abs.agree.com/img/055gg.jpg\" style=\"max-width: 100%;\"> '", "ASSIGN_STATUS": "01", "JBXX108": "522732199610081819", "CUSTNO": "c0000110006", "JBXX107": "外星客户", "JBXX101": "重客户", "CUST_TYPE": "村级", "IDENT": "02", "SS0306": "6987" } ] }

8

柜员添加法人号

url: localhost:50002/services/put

{ "teller[]": [ { "corporate_id":"c001", "entry_teller":"t0001", "@content":"corporate_id" },{ "corporate_id":"c002", "entry_teller":"t0002", "@content":"corporate_id" }, { "corporate_id":"c003", "entry_teller":"t0003", "@content":"corporate_id" }, { "corporate_id":"c004", "entry_teller":"t0004", "@content":"corporate_id" }, { "corporate_id":"c001", "entry_teller":"t0011", "@content":"corporate_id" } ] }

插入模板

url: localhost:50002/services/post

body:

{ "TEMP[]": [ { "temp_name":"开卡", "temp_id":"t005", "corporate_id" :"c002", "temp_content":"user, id, count", "temp_type":"01" } ] }

查询模板

url： localhost:50002/services/get

body:

{ "teller": { "entry_teller": "t0001", "@column": "corporate_id" }, "[]": { "TEMP": { "corporate_id@": "teller/corporate_id", "@column": "temp_id,temp_name" }, "@count":2, "@page":0 } }

9

插入个性化模板数据

{ "PERSON_TEMP[]" : [ { "MEA_ID":"m01", "MEA_NAME":"开卡", "MEA_TYPE":"01", "INPUT_TYPE":"01", "is_valid":"02", "temp_id":"t001" } ] }

查询模板数据

{ "[]":{ "person_temp":{ "temp_id":"t001", "@column":"mea_id,mea_name,mea_type,input_type,is_valid" } } }

10

客户营销活动

{ "custom_act[]": [ { "CUSTNO": "c0000110001", "ACTIVITY_ID": "a00001", "ASSIGN_TELLER": "t0004", "MARKET_UNIT": "c004", "TEMP_TYPE": "01", "MARKET_STATUS": "02" }, { "CUSTNO": "c0000110002", "ACTIVITY_ID": "a00001", "ASSIGN_TELLER": "", "MARKET_UNIT": "", "TEMP_TYPE": "", "MARKET_STATUS": "01" }, { "CUSTNO": "c0000110003", "ACTIVITY_ID": "a00002", "ASSIGN_TELLER": "t0004", "MARKET_UNIT": "c004", "TEMP_TYPE": "01", "MARKET_STATUS": "02" } ] }

营销列表

{ "[]": { "custom_act":{ "MARKET_STATUS":"02", // "ACTIVITY_ID":"a00002", "@column":"ACTIVITY_ID,CUSTNO,ASSIGN_TELLER,MARKET_UNIT,TEMP_TYPE" }, "custom":{ "CUSTNO@":"/custom_act/CUSTNO", "@column":"JBXX107,JBXX108" }, "activity":{ "ACTIVITY_ID@":"/custom_act/ACTIVITY_ID", "@column":"ACTIVITY_NAME" } } }

11

新增客户

{ "CUSTOM_ACT":{ "CUSTNO":"c0000110007", "ACTIVITY_ID":"a0003", "IDENT":"02", "TEMP_ID":"t001", "TEMP_TYPE":"01", "MARKET_STATUS":"01" }, "CUSTOM":{ "CUSTNO":"c0000110007", "CUSTUUID":"4e7a0007", "JBXX107":"居民身份证", "JBXX108":"131122199310213411", "CUST_IDE":"重点跟进客户", "JBXX101":"李先生", "CUST_TYPE":"村级", "SS0306":"120000", "IDENT":"01", "MONEYPERYEAR":"600000", "HAVE_OUT":"01", "image_index":"'url':'<img src=\"https://abs.agree.com/img/04dd.jpg\" style=\"max-width: 100%;\"> '", "ASSIGN_STATUS":"02" }, "BUSSINES":{ "BUSSINES_ID":"f00001", "ENTRY_TELLER":"t0003", "TELLER_ADDR":"", "TELLER_LOCATION":"" } }

13

活动列表查询

{ "teller": { "ENTRY_TELLER": "t0001", "@column": "corporate_id" }, "[]": { "ACTIVITY": { "corporate_id@": "teller/corporate_id", // "ACTIVITY_STATUS": "02", "@column": "ACTIVITY_ID,ACTIVITY_NAME,CREATE_TELLER,TEMP_TYPE" } } }

14

活动文件列表

{ "activity":{ "activity_id":"a00001", "@column":"FILE_NAMES" } }

15

插入数据

url：localhost:50002/services/put

body：

{ "activity[]": [ { "activity_id": "a00001", "FILE_NAMES": "activity.xlsx", "@content": "FILE_NAMES" }, { "activity_id": "a00002", "FILE_NAMES": "activity.jpg", "@content": "FILE_NAMES" }, { "activity_id": "a00003", "FILE_NAMES": "activity.pdf", "@content": "FILE_NAMES" }, { "activity_id": "a00004", "FILE_NAMES": "activity.docx", "@content": "FILE_NAMES" }, { "activity_id": "a00005", "FILE_NAMES": "activity.pdf", "@content": "FILE_NAMES" }, { "activity_id": "a00006", "FILE_NAMES": "activity00.jpg", "@content": "FILE_NAMES" } ] }

16

16、为表ASSET添加数据

url：localhost:50002/services/post

body：

{ "ASSET[]": [ { "ASSETS_TYPE": "01", "ASSETS_CONTENT": "北京朝阳北京西路向北500米处,北京科技园", "MEASUREMENT": "平方米", "NUM": "6600000", "MARKET_VAL": "8000万", "IS_MORTGAGE": "02", "CUSTNO": "14" }, { "ASSETS_TYPE": "02", "ASSETS_CONTENT": "北京朝阳北京西客站,万达客车", "MEASUREMENT": "辆", "NUM": "2000", "MARKET_VAL": "900万", "IS_MORTGAGE": "02", "CUSTNO": "15" }, { "ASSETS_TYPE": "04", "ASSETS_CONTENT": "北京市通州区潞城镇胡各庄路大桥处,通州森林公园", "MEASUREMENT": "平方米", "NUM": "8800000", "MARKET_VAL": "90000万", "IS_MORTGAGE": "02", "CUSTNO": "16" }, { "ASSETS_TYPE": "03", "ASSETS_CONTENT": "北京朝阳北京西路向北500米处,玉米收割机", "MEASUREMENT": "辆", "NUM": "500", "MARKET_VAL": "150万", "IS_MORTGAGE": "02", "CUSTNO": "17" }, { "ASSETS_TYPE": "06", "ASSETS_CONTENT": "北京朝阳北京西路向北500米处,挖掘机", "MEASUREMENT": "辆", "NUM": "500", "MARKET_VAL": "50000万", "IS_MORTGAGE": "02", "CUSTNO": "18" } ] }

16、资产列表查询

url：localhost:50002/services/get

body：

{ "teller": { "role_type":"90" , "ENTRY_TELLER": "t0001", "@column": "role_type,ENTRY_TELLER" }, "custom": { "ENTRY_TELLER@":"/teller/ENTRY_TELLER", "jbxx108": "522732199610081017", "@column": "jbxx108,CUSTNO" }, "asset": { "ASSETS_TYPE": "1", "CUSTNO@":"/custom/CUSTNO", "@column": "id,ASSETS_CONTENT,MEASUREMENT,NUM,MARKET_VAL,IS_MORTGAGE" } }

17

17、资产明细查询

url：localhost:50002/services/get

body：

{ "teller": { "role_type":"90" , "ENTRY_TELLER": "t0001", "@column": "role_type,ENTRY_TELLER" }, "custom": { "ENTRY_TELLER@":"/teller/ENTRY_TELLER", "jbxx108": "522732199610081017", "@column": "jbxx108,CUSTNO" }, "asset": { "NUM_ID":"n0001", "ASSETS_TYPE": "1", "CUSTNO@":"/custom/CUSTNO", "@column": "id,ASSETS_CONTENT,MEASUREMENT,NUM,MARKET_VAL,IS_MORTGAGE" } }

18

18、资产新增

url：localhost:50002/services/post

body：

{ "ASSET[]": [ { "ASSETS_TYPE": "01", "ASSETS_CONTENT": "北京朝阳区望京,望京SOHO", "MEASUREMENT": "平方米", "NUM": "1500", "MARKET_VAL": "30000万", "IS_MORTGAGE": "02" }, { "ASSETS_TYPE": "05", "ASSETS_CONTENT": "北京,朝阳公园", "MEASUREMENT": "平方米", "NUM": "60000", "MARKET_VAL": "90000万", "IS_MORTGAGE": "02" } ] }

19

19、资产明细编辑

url：localhost:50002/services/put

body：

{ "asset[]": [{ "id": "7", "ASSETS_CONTENT": "北京丰台,丰台科技园", "MARKET_VAL": "10000万", "MEASUREMENT": "平方米", "IS_MORTGAGE": "02", "NUM":"50000", "@content": "ASSETS_CONTENT,MARKET_VAL,MEASUREMENT,IS_MORTGAGE,NUM," }] }

20

20、资产明细删除

url：localhost:50002/services/delete

body：

{ "asset":{ "id":6 } }

21

21、为经营operate表添加数据

url：localhost:50002/services/post

body：

{ "operate[]": [ { "MANAGE_TYPE": "01", "PARA_VALUE": "玉米", "MEASUREMENT": "KG", "NUM": "800000", "INCOME": "10万" }, { "MANAGE_TYPE": "02", "PARA_VALUE": "湖泊", "MEASUREMENT": "平方米", "NUM": "6600", "INCOME": "800万" }, { "MANAGE_TYPE": "02", "PARA_VALUE": "稻田", "MEASUREMENT": "平方米", "NUM": "600", "INCOME": "11万" }, { "MANAGE_TYPE": "01", "PARA_VALUE": "水果", "MEASUREMENT": "KG", "NUM": "6996", "INCOME": "39万" }, { "MANAGE_TYPE": "06", "PARA_VALUE": "美容美发", "MEASUREMENT": "分店", "NUM": "6", "INCOME": "3000万" } ] }

21、经营列表查询

url：localhost:50002/services/get

body：

{ "custom": { "JBXX108": "522732199610081017", "@column": "CUSTNO,JBXX108" }, "[]": { "OPERATE": { "CUSTNO@": "custom/CUSTNO", "@column": "id,PARA_VALUE,MEASUREMENT,NUM,INCOME" } } }

22

22、经营明细查询

url：localhost:50002/services/get

body：

{ "custom": { "JBXX108": "522732199610081017", "@column": "CUSTNO,JBXX108" }, "[]": { "OPERATE": { "CUSTNO@": "custom/CUSTNO", "@column": "id,PARA_VALUE,MEASUREMENT,NUM,INCOME" } } }

23

23、经营新增

url：localhost:50002/services/post

body：

{ "operate[]": [ { "MANAGE_TYPE": "03", "PARA_VALUE": "石油开采", "NUM": "10000", "MEASUREMENT": "平方米", "INCOME": "900000万", "CUSTNO": "c0000110007" }, { "MANAGE_TYPE": "03", "PARA_VALUE": "金属矿开采", "NUM": "1000", "MEASUREMENT": "平方米", "INCOME": "60000万", "CUSTNO": "c0000110006" }, { "MANAGE_TYPE": "07", "PARA_VALUE": "出售奢侈品", "NUM": "10000", "MEASUREMENT": "KG", "INCOME": "99900000万", "CUSTNO": "c0000110005" }, { "MANAGE_TYPE": "06", "PARA_VALUE": "餐饮", "NUM": "200", "MEASUREMENT": "平方米", "INCOME": "100万", "CUSTNO": "c0000110001" } ] }

24

24、经营明细编辑_根据编号ID来编辑_因为多个的经营种类会对应同一个客户号

url：localhost:50002/services/put

body：

{ "operate[]": [ { "MANAGE_TYPE": "5", "PARA_VALUE": "计算机软件", "NUM": "8000001", "MEASUREMENT": "KG", "INCOME": "10万", "CUSTNO": "c0000110001", "op_id": "op0001", "@content": "MANAGE_TYPE,PARA_VALUE,NUM,MEASUREMENT,INCOME,CUSTNO" } ] }

25

25、经营明细删除___根据编号

url：localhost:50002/services/

body：

{ "operate":{ "id":10 } }

26

26、家庭成员查询

{ "[]":{ "family":{ "JBXX108":"522732199610081017", "@content":"ID,JBXX108,NAME,RELATION,NATION,ID_NUMBER,PERMANENT_RESIDENCE,CONTACT_NUMBER,OCCUPATION,COMPANY" } } }

27

家庭成员明细查询

{ "family": { "ID": "2", "@content": "ID,JBXX108,NAME,RELATION,NATION,ID_NUMBER,PERMANENT_RESIDENCE,CONTACT_NUMBER,OCCUPATION,COMPANY" } }

28

家庭成员新增

{ "family[]":[ { "JBXX108":"522732199610081019", "NAME":"lisi", "RELATION":"父子", "NATION":"汉", "ID_NUMBER":"131122202106073410", "PERMANENT_RESIDENCE":"天津", "CONTACT_NUMBER":"13261914254", "OCCUPATION":"肄业", "COMPANY":"无" }, { "JBXX108":"522732199610081019", "NAME":"liling", "RELATION":"父女", "NATION":"汉", "ID_NUMBER":"131122202106073410", "PERMANENT_RESIDENCE":"天津", "CONTACT_NUMBER":"16661914254", "OCCUPATION":"肄业", "COMPANY":"无" } ] }

29

家庭成员明细编辑

{ "family[]":[ { "ID":"1", "OCCUPATION":"管理", "COMPANY":"赞同科技", "@content":"OCCUPATION,COMPANY" } ] }

30

家庭成员删除

{ "family":{ "ID":"3" } }

31

31、为业务表professional添加数据

url:localhost:50002/services/post

{ "professional[]": [ { "BEGIN_DATE": "2020-01-11", "END_DATE": "2020-01-12", "NUM": "2", "JDKHS": "13", "SXKHS": "3", "FFDKKHS": "8", "FFDKYE": "23234999999992.23", "ZDGJKHS": "3", "DQHFKHS": "1", "YBGZKHS": "0", "BYPJKHS": "0", "HMDKHS": "1", "BFWGKHS": "0", "ACTIVITY_ID": "a00001" }, { "BEGIN_DATE": "2020-01-15", "END_DATE": "2020-01-18", "NUM": "2", "JDKHS": "13", "SXKHS": "3", "FFDKKHS": "8", "FFDKYE": "88888888.88", "ZDGJKHS": "3", "DQHFKHS": "1", "YBGZKHS": "0", "BYPJKHS": "0", "HMDKHS": "1", "BFWGKHS": "0", "ACTIVITY_ID": "a00002" }, { "BEGIN_DATE": "2020-08-11", "END_DATE": "2020-08-20", "NUM": "5", "JDKHS": "10", "SXKHS": "3", "FFDKKHS": "8", "FFDKYE": "66669999.66", "ZDGJKHS": "3", "DQHFKHS": "1", "YBGZKHS": "0", "BYPJKHS": "0", "HMDKHS": "1", "BFWGKHS": "0", "ACTIVITY_ID": "a00003" } ] }

31、业务量查询

{ "teller": { "role_type": "90", "@column": "entry_teller" }, "activity": { "entry_teller@": "teller/entry_teller", "@column": "ACTIVITY_ID" }, "professional": { "ACTIVITY_ID@": "activity/ACTIVITY_ID", "BEGIN_DATE{}": "> '2020-01-10'", "END_DATE{}": "< '2020-01-13'", "@column": "NUM,JDKHS,SXKHS,FFDKKHS,FFDKYE,ZDGJKHS,DQHFKHS,YBGZKHS,BYPJKHS,HMDKHS,BFWGKHS" } }

32

32、业务量明细查询

url:localhost:50002/services/get

{ "teller": { "role_type": "90", "@column": "entry_teller" }, "activity": { "entry_teller@": "teller/entry_teller", "@column": "ACTIVITY_ID" }, "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO,JBXX101,JBXX107,JBXX108" }, "professional": { "ACTIVITY_ID@": "activity/ACTIVITY_ID", "BEGIN_DATE{}": "> '2020-01-10'", "END_DATE{}": "<= '2020-01-15'", "MARKET_STATUS": "02", "@column": "NUM,JDKHS,SXKHS,FFDKKHS,FFDKYE,ZDGJKHS,DQHFKHS,YBGZKHS,BYPJKHS,HMDKHS,BFWGKHS,ASSIGN_TELLER,MARKET_STATUS,MARKET_UNIT" } }

33

33、增加—为financial表添加数据

url:localhost:50002/services/post

{ "financial[]": [ { "CP_MYD": "01'", "LN_ZJXQ": "02", "DKJH": "03", "XW_DKJE": "60", "XW_DKQX": "7", "DBW": "05", "LSDK": "01", "LSDK_FL": "xx", "XCZXZL": "02", "XCZXZL_FL": "11", "LN_ZYYT": "02", "OTHER": "其他", "JRFWYX": "10", "KHJY": "客户建议1", "KHBLYX": "09", "CUSTNO": "c0000110001" }, { "CP_MYD": "01'", "LN_ZJXQ": "03", "DKJH": "02", "XW_DKJE": "6", "XW_DKQX": "2", "DBW": "04", "LSDK": "02", "LSDK_FL": "xx", "XCZXZL": "01", "XCZXZL_FL": "10", "LN_ZYYT": "01", "OTHER": "其他", "JRFWYX": "09", "KHJY": "客户建议2", "KHBLYX": "01", "CUSTNO": "c0000110002" }, { "CP_MYD": "02'", "LN_ZJXQ": "01", "DKJH": "02", "XW_DKJE": "66", "XW_DKQX": "1", "DBW": "04", "LSDK": "01", "LSDK_FL": "xx", "XCZXZL": "02", "XCZXZL_FL": "01", "LN_ZYYT": "01", "OTHER": "其他", "JRFWYX": "10", "KHJY": "客户建议3", "KHBLYX": "04", "CUSTNO": "c0000110003" }, { "CP_MYD": "01'", "LN_ZJXQ": "02", "DKJH": "03", "XW_DKJE": "60", "XW_DKQX": "3", "DBW": "03", "LSDK": "02", "LSDK_FL": "dd", "XCZXZL": "02", "XCZXZL_FL": "11", "LN_ZYYT": "02", "OTHER": "其他", "JRFWYX": "10", "KHJY": "客户建议4", "KHBLYX": "09", "CUSTNO": "c0000110004" }, { "CP_MYD": "01'", "LN_ZJXQ": "02", "DKJH": "03", "XW_DKJE": "9", "XW_DKQX": "3", "DBW": "02", "LSDK": "02", "LSDK_FL": "xx", "XCZXZL": "01", "XCZXZL_FL": "09", "LN_ZYYT": "01", "OTHER": "其他", "JRFWYX": "07", "KHJY": "客户建议5", "KHBLYX": "09", "CUSTNO": "c0000110005" }, { "CP_MYD": "03'", "LN_ZJXQ": "02", "DKJH": "03", "XW_DKJE": "60", "XW_DKQX": "7", "DBW": "05", "LSDK": "01", "LSDK_FL": "xx", "XCZXZL": "02", "XCZXZL_FL": "01", "LN_ZYYT": "02", "OTHER": "其他", "JRFWYX": "04", "KHJY": "客户建议6", "KHBLYX": "04", "CUSTNO": "c0000110006" }, { "CP_MYD": "02'", "LN_ZJXQ": "03", "DKJH": "03", "XW_DKJE": "30", "XW_DKQX": "1", "DBW": "02", "LSDK": "01", "LSDK_FL": "xx", "XCZXZL": "02", "XCZXZL_FL": "11", "LN_ZYYT": "02", "OTHER": "其他", "JRFWYX": "10", "KHJY": "客户建议7", "KHBLYX": "09", "CUSTNO": "c0000110007" } ] }

33、修改financial表数据

url:localhost:50002/services/put

{ "financial[]": [ { "id": "7", "CP_MYD": "01'", "LN_ZJXQ": "02", "DKJH": "03", "XW_DKJE": "60", "XW_DKQX": "7", "DBW": "05", "LSDK": "01", "LSDK_FL": "分类", "XCZXZL": "02", "XCZXZL_FL": "11", "LN_ZYYT": "03", "OTHER": "其他", "JRFWYX": "10", "KHJY": "客户建议7", "KHBLYX": "09", "CUSTNO": "c0000110001", "@content": "DKJH,XCZXZL_FL,LSDK_FL,LSDK,CP_MYD,LN_ZYYT,KHJY,OTHER,JRFWYX,XW_DKJE,KHBLYX,DBW,XW_DKQX,CUSTNO,LN_ZJXQ,XCZXZL" } ] }

34

34、金融需求查询

url:localhost:50002/services/get

{ "teller": { "role_type": "80", "@column": "entry_teller" }, "custom": { "entry_teller@": "teller/entry_teller", "@column": "JBXX108,CUSTNO" }, "financial": { "CUSTNO@": "custom/CUSTNO", "@column": "DKJH,XCZXZL_FL,LSDK_FL,LSDK,CP_MYD,LN_ZYYT,KHJY,OTHER,JRFWYX,XW_DKJE,KHBLYX,DBW,XW_DKQX,CUSTNO,LN_ZJXQ,XCZXZL" } }

35

待完成

url:localhost:50002/services/get

36

36、（新增–数据）

url:localhost:50002/services/post

{ "task[]": [ { "TASK_NAME": "省级活动任务", "TASK_STATUS": "1", "STATUS": "0", "PRODUCT_NUM": "100", "ACTIVITY_ID": "a00001", "BEGIN_DATE": "2020-08-12", "END_DATE": "2020-08-14", "CREATE_TELLER": "曹操经理", "TEMP_TYPE": "02", "ON_DATE": "2020-08-01", "OFF_DATE": "2020-08-03" }, { "TASK_NAME": "县级活动任务", "TASK_STATUS": "0", "STATUS": "0", "PRODUCT_NUM": "100", "ACTIVITY_ID": "a00002", "BEGIN_DATE": "2020-08-13", "END_DATE": "2020-08-15", "CREATE_TELLER": "孔明经理", "TEMP_TYPE": "01", "ON_DATE": "2020-08-13", "OFF_DATE": "2020-08-15" }, { "TASK_NAME": "乡级活动任务", "TASK_STATUS": "0", "STATUS": "1", "PRODUCT_NUM": "10", "ACTIVITY_ID": "a00003", "BEGIN_DATE": "2020-08-14", "END_DATE": "2020-08-16", "CREATE_TELLER": "刘备经理", "TEMP_TYPE": "01", "ON_DATE": "2020-08-15", "OFF_DATE": "2020-08-17" }, { "TASK_NAME": "特别级活动任务", "TASK_STATUS": "1", "STATUS": "0", "PRODUCT_NUM": "5", "ACTIVITY_ID": "a00004", "BEGIN_DATE": "2020-08-15", "END_DATE": "2020-08-17", "CREATE_TELLER": "刘邦经理", "TEMP_TYPE": "01", "ON_DATE": "2020-08-16", "OFF_DATE": "2020-08-18" }, { "TASK_NAME": "普通级活动任务", "TASK_STATUS": "0", "STATUS": "1", "PRODUCT_NUM": "8", "ACTIVITY_ID": "a00005", "BEGIN_DATE": "2020-08-16", "END_DATE": "2020-08-18", "CREATE_TELLER": "韩信", "TEMP_TYPE": "02", "ON_DATE": "2020-08-17", "OFF_DATE": "2020-08-19" }, { "TASK_NAME": "一级活动任务", "TASK_STATUS": "1", "STATUS": "0", "PRODUCT_NUM": "66", "ACTIVITY_ID": "a00006", "BEGIN_DATE": "2020-08-17", "END_DATE": "2020-08-19", "CREATE_TELLER": "萧何", "TEMP_TYPE": "01", "ON_DATE": "2020-08-18", "OFF_DATE": "2020-08-20" } ] }

36、任务列表的查询

url:localhost:50002/services/get

{ "teller": { "role_type": "90", "@column": "entry_teller" }, "activity": { "entry_teller@": "teller/entry_teller", "@column": "ACTIVITY_ID,ACTIVITY_NAME" }, "task": { "ACTIVITY_ID@": "activity/ACTIVITY_ID", "@column": "ACTIVITY_ID,STATUS,TASK_NAME,TASK_STATUS,PRODUCT_NUM,ACTIVITY_ID,BEGIN_DATE,END_DATE" } }

37

37、活动详情查询（新增）

url:localhost:50002/services/get

{ "teller": { "role_type": "90", "@column": "entry_teller" }, "activity": { "entry_teller@": "teller/entry_teller", "@column": "ACTIVITY_ID,ACTIVITY_NAME" }, "task": { "ACTIVITY_ID@": "activity/ACTIVITY_ID", "@column": "ACTIVITY_ID,CREATE_TELLER,TEMP_TYPE,PRODUCT_NUM,ON_DATE,OFF_DATE" } }

38

38、新增–数据

url:localhost:50002/services/post

{ "product[]": [ { "TASK_ID": "1", "PRODUCT_ID": "1", "PRODUCT_NAME": "长虹", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" }, { "TASK_ID": "2", "PRODUCT_ID": "2", "PRODUCT_NAME": "三星", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" }, { "TASK_ID": "3", "PRODUCT_ID": "3", "PRODUCT_NAME": "联通", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" }, { "TASK_ID": "4", "PRODUCT_ID": "5", "PRODUCT_NAME": "VIVO", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" }, { "TASK_ID": "5", "PRODUCT_ID": "5", "PRODUCT_NAME": "亿通", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" }, { "TASK_ID": "6", "PRODUCT_ID": "6", "PRODUCT_NAME": "苹果", "PRODUCT_NUM": "5000", "UNITS": "个", "TARGET": "8000", "FINISH_VAL": "3000", "FINISH_PERCENT": "60%", "BEGIN_DATE": "2020-01-01", "END_DATE": "2020-01-03" } ] }

38、产品列表查询（新增）

url:localhost:50002/services/get

{ "product": { "task_id": "1", "@column": "TARGET,FINISH_PERCENT,BEGIN_DATE,FINISH_VAL,PRODUCT_NUM,UNITS,END_DATE,PRODUCT_ID,PRODUCT_NAME,TASK_ID" } }

39

39、营销业绩汇总查询（新增）

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,CUSTMANAGER" }, "[]": { "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO" }, "marketing_performance": { "CUSTNO@": "custom/CUSTNO", "@column": "ORDER_TYPE,DQSXJE,CKKLH,DYCYXRQ,SCSXRQ,LCCPQYRQ,YXJE,SCCKYE,QUERY_TYPE,JDRQ,SCJDCKNRJ,LCCPJE" } } }

39、为表marketing_performance添加数据

url:localhost:50002/services/post

{ "marketing_performance[]": [ { "QUERY_TYPE": "02", "ORDER_TYPE": "排序", "JDRQ": "建档", "SCJDCKNRJ": "存款年日均增加", "SCCKYE": "6888.12", "CKKLH": "33", "DQSXJE": "66.66", "SCSXRQ": "6", "YXJE": "88.88", "DYCYXRQ": "9", "LCCPQYRQ": "6", "LCCPJE": "99.99", "BEGIN_DATE": "2020-01-16", "END_DATE": "2020-02-6", "CUSTNO": "c0000110001" }, { "QUERY_TYPE": "03", "ORDER_TYPE": "排序", "JDRQ": "建档", "SCJDCKNRJ": "存款年日均增加", "SCCKYE": "68.12", "CKKLH": "3", "DQSXJE": "6000.66", "SCSXRQ": "6", "YXJE": "8800.88", "DYCYXRQ": "9", "LCCPQYRQ": "6", "LCCPJE": "9900.99", "BEGIN_DATE": "2020-01-18", "END_DATE": "2020-02-4", "CUSTNO": "c0000110002" } ] }

40

40、营销业绩明细查询（新增）

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,CUSTMANAGER,CUSTMANAGER,CUSTMANAGERS,CUSTMANAGER_NAME" }, "[]": { "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO,JBXX101,JBXX107,JBXX108,PHONENO,JZDZ,CZDZ,SFZDZ,CUST_TYPE,CUSTTRADE" }, "operate": { "CUSTNO@": "custom/CUSTNO", "@column": "JYDZ" }, "marketing_performance": { "CUSTNO@": "custom/CUSTNO", "@column": "ORDER_TYPE,DQSXJE,CKKLH,DYCYXRQ,SCSXRQ,LCCPQYRQ,YXJE,SCCKYE,QUERY_TYPE,JDRQ,SCJDCKNRJ,LCCPJE,DQSXJE_START,DQSXJE_END,YXJE_START,YXJE_END,KHBLYWQY,JDRQ_DATE,DSCJKHXX,DGCJKHXX,SCSXJE,DQSXJE_NOW,SCSXRQ_DATE,DYCYXRQ_DATE,CSED,CKYE_SCCKYE,DKYE_SCJDDKYE,SJYHQYRQ,WSYHQYRQ,JHZFQYRQ,ETC,POSQYRQ,EBAIFUQYRQ,ZHCQY,XYKQYRQ,LCCPQYRQ_DATE,SBKJHRQ" } } }

40、添加新增字段的数据

url:localhost:50002/services/put

{ "marketing_performance[]": [ { "DQSXJE_START": "11.11", "DQSXJE_END": "22.22", "YXJE_START": "111.11", "YXJE_END": "33.33", "KHBLYWQY": "wsyhqyrq, lccpqyrq", "JDRQ_DATE": "2020-01-18", "DSCJKHXX": "2020-01-18", "DGCJKHXX": "2020-01-13", "SCSXJE": "555.22", "DQSXJE_NOW": "111.00", "SCSXRQ_DATE": "2020-01-19", "DYCYXRQ_DATE": "2020-01-11", "CSED": "888.89", "CKYE_SCCKYE": "1232.23", "DKYE_SCJDDKYE": "34.34", "SJYHQYRQ": "2020-01-13", "WSYHQYRQ": "2020-01-10", "JHZFQYRQ": "2020-01-18", "ETC": "2020-01-18", "POSQYRQ": "2020-01-18", "EBAIFUQYRQ": "2020-01-18", "ZHCQY": "2020-01-18", "XYKQYRQ": "2020-01-18", "LCCPQYRQ_DATE": "2020-01-18", "SBKJHRQ": "2020-01-18", "id": "1", "@content": "DQSXJE_START,DQSXJE_END,YXJE_START,YXJE_END,KHBLYWQY,JDRQ_DATE,DSCJKHXX,DGCJKHXX,SCSXJE,DQSXJE_NOW,SCSXRQ_DATE,DYCYXRQ_DATE,CSED,CKYE_SCCKYE,DKYE_SCJDDKYE,SJYHQYRQ,WSYHQYRQ,JHZFQYRQ,ETC,POSQYRQ,EBAIFUQYRQ,ZHCQY,XYKQYRQ,LCCPQYRQ_DATE,SBKJHRQ" }, { "DQSXJE_START": "11.11", "DQSXJE_END": "22.22", "YXJE_START": "111.11", "YXJE_END": "33.33", "KHBLYWQY": "sjyhqyrq", "JDRQ_DATE": "2020-01-18", "DSCJKHXX": "2020-01-18", "DGCJKHXX": "2020-01-13", "SCSXJE": "555.22", "DQSXJE_NOW": "111.00", "SCSXRQ_DATE": "2020-01-19", "DYCYXRQ_DATE": "2020-01-11", "CSED": "888.89", "CKYE_SCCKYE": "1232.23", "DKYE_SCJDDKYE": "34.34", "SJYHQYRQ": "2020-01-13", "WSYHQYRQ": "2020-01-10", "JHZFQYRQ": "2020-01-18", "ETC": "2020-01-18", "POSQYRQ": "2020-01-18", "EBAIFUQYRQ": "2020-01-18", "ZHCQY": "2020-01-18", "XYKQYRQ": "2020-01-18", "LCCPQYRQ_DATE": "2020-01-18", "SBKJHRQ": "2020-01-18", "id": "2", "@content": "DQSXJE_START,DQSXJE_END,YXJE_START,YXJE_END,KHBLYWQY,JDRQ_DATE,DSCJKHXX,DGCJKHXX,SCSXJE,DQSXJE_NOW,SCSXRQ_DATE,DYCYXRQ_DATE,CSED,CKYE_SCCKYE,DKYE_SCJDDKYE,SJYHQYRQ,WSYHQYRQ,JHZFQYRQ,ETC,POSQYRQ,EBAIFUQYRQ,ZHCQY,XYKQYRQ,LCCPQYRQ_DATE,SBKJHRQ" } ] }

41

41.营销业绩考评查询（新增）

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,BEL_UNIT_NAME" }, "activity": { "entry_teller@": "teller/entry_teller", "@column": "ACTIVITY_ID,ACTIVITY_NAME" }, "product": { "entry_teller@": "teller/entry_teller", "@column": "PRODUCT_ID,PRODUCT_NAME" }, "task": { "ACTIVITY_ID@": "activity/ACTIVITY_ID", "@column": "TIME_UNITS_DESC,MBZ,WCZ,WCB,DTADAT" } }

42

42、排行榜查询（新增）

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,BEL_UNIT_NAME,CUSTMANAGERS,CUSTMANAGER_NAME,XZJDS,ORDERNO" }, "marketing_performance": { "entry_teller@": "teller/entry_teller", "@column": "YXRQ" } }

43

43、活动影像下载（新增）___查询

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "ORDERNO": "1", "@column": "CUSTMANAGER" } }

44

44、产品明细查询（新增）

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,BEL_UNIT_NAME,CUSTMANAGERS,CUSTMANAGER_NAME" }, "task": { "entry_teller@": "/teller/entry_teller", "BEGIN_DATE{}": " > '2020-08-11'", "END_DATE{}": " < '2020-08-15'", "@column": "TIME_UNITS_DESC,MBZ,WCZ,WCB,DTADAT" }, "[]": { "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO,JBXX101,JBXX107,JBXX108,PHONENO,JZDZ,CZDZ,SFZDZ,CUST_TYPE,CUSTTRADE,YXZL" }, "product": { "entry_teller@": "teller/entry_teller", "@column": "PRODUCT_ID,PRODUCT_NAME" }, "marketing_performance": { "entry_teller@": "teller/entry_teller", "@column": "JDRQ,DSCJKHXX,DGCJKHXX,SCSXJE,DQSXJE,SCSXRQ,YXJE,DYCYXRQ,YXRQ,CSED,SCJDCKNRJ,DKYE_SCJDDKYE,LCCPJE,LCCPQYRQ_DATE,CKKLH,SCSXRQ,DYCYXRQ,WSYHQYRQ,SJYHQYRQ,POSQYRQ,EBAIFUQYRQ,ETC,JHZFQYRQ,XYKQYRQ,LCCPQYRQ,SBKJHRQ" } } }

45

45、添加数据

url:localhost:50002/services/post

{ "financial_map_data[]": [ { "ANCBRTCOD": "at10001", "DATEFLG": "1", "DTADAT": "2020-08-13", "OBJCOD": "oc0001", "OBJNUM": "6", "OBJCKZJE": "66.12", "OBJDKZJE": "88.88", "OBJXYZHL": "1.012", "OBJXYZHLPM": "5", "OBJSSJDNUM": "7", "OBJSSJDPM": "1", "OBJSSWCB": "3.33", "OBJJDNUMBSY": "6.601", "OBJJDNUMBNC": "9.202", "OBJSXFGL": "1.9910", "OBJWJDNUM": "16", "OBJWJDNUMBSY": "0.4411", "OBJWJDNUMBNC": "0.00123", "OBJYSXNUM": "69", "OBJYSXNUMBSY": "1.122", "OBJYSXNUMBNC": "0.001", "OBJWSXNUM": "32", "OBJWSXNUMBSY": "1.111", "OBJWSXNUMBNC": "1.111", "OBJYXHS": "55", "OBJYXHSBSY": "5.099", "OBJYXHSBNC": "1.0091", "OBJYXJE": "66.88", "OBJYXJEBSY": "1.909", "OBJYXJEBNC": "9.109", "OBJYXFGL": "0.9111", "OBJYXFGLBSY": "1.123", "OBJSXFGLBSY": "3.1122", "OBJSSWCBBSY": "2.222" }, { "ANCBRTCOD": "at10002", "DATEFLG": "2", "DTADAT": "2020-08-15", "OBJCOD": "oc0002", "OBJNUM": "5", "OBJCKZJE": "65.12", "OBJDKZJE": "87.88", "OBJXYZHL": "1.012", "OBJXYZHLPM": "6", "OBJSSJDNUM": "8", "OBJSSJDPM": "2", "OBJSSWCB": "4.33", "OBJJDNUMBSY": "6.601", "OBJJDNUMBNC": "8.202", "OBJSXFGL": "1.77910", "OBJWJDNUM": "15", "OBJWJDNUMBSY": "1.4411", "OBJWJDNUMBNC": "1.00123", "OBJYSXNUM": "68", "OBJYSXNUMBSY": "1.122", "OBJYSXNUMBNC": "0.001", "OBJWSXNUM": "31", "OBJWSXNUMBSY": "3.111", "OBJWSXNUMBNC": "2.111", "OBJYXHS": "54", "OBJYXHSBSY": "4.099", "OBJYXHSBNC": "2.0091", "OBJYXJE": "65.88", "OBJYXJEBSY": "1.909", "OBJYXJEBNC": "8.109", "OBJYXFGL": "0.9111", "OBJYXFGLBSY": "1.123", "OBJSXFGLBSY": "3.1122", "OBJSSWCBBSY": "2.222" } ] }

45、查询金融地图数据

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller" }, "financial_map_data": { "entry_teller@": "teller/entry_teller", "ANCBRTCOD": "at10001", "DATEFLG": "1", "@column": "DTADAT,OBJCOD,OBJNUM,OBJCKZJE,OBJDKZJE,OBJXYZHL,OBJXYZHLPM,OBJSSJDNUM,OBJSSJDPM,OBJSSWCB,OBJJDNUMBSY,OBJJDNUMBNC,OBJSXFGL,OBJWJDNUM,OBJWJDNUMBSY,OBJWJDNUMBNC,OBJYSXNUM,OBJYSXNUMBSY,OBJYSXNUMBNC,OBJWSXNUM,OBJWSXNUMBSY,OBJWSXNUMBNC,OBJYXHS,OBJYXHSBSY,OBJYXHSBNC,OBJYXJE,OBJYXJEBSY,OBJYXJEBNC,OBJYXFGL,OBJYXFGLBSY,OBJSXFGLBSY,OBJSSWCBBSY" } }

46

46、添加数据-模拟

url:localhost:50002/services/put

{ "financial_trend_map[]": [ { "OBJCOD": "ac10001", "DATEFLG": "1", "DTADAT": "2020-08-14", "BEGINDATE": "2020-08-13", "ENDDATE": "2020-08-16", "JDHS": "5", "JDHCKRJ": "15.12", "JDHDKYE": "16.13", "JDHKHZS": "6", "JDHSJYHQY": " 22", "JDHETCQY": "11", "JDHSBKJH": "33", "JDHJHZFQY": "12", "JDHEBFQY": "14", "JDHSBSY": "1.12", "JDHCKRJBSY": "2.123", "JDHDKYEBSY": "3.1223", "JDHKHZSBSY": "4.1211", "JDHSJYHQYBSY": "1.11", "JDHETCQYBSY": "2.222", "JDHSBKJHBSY": "3.333", "JDHJHZFQYBSY": "4.4444", "JDHEBFQYBSY": "5.55555", "flagmark": "43543", "signSum": "签约明细", "bnljjybs": "666666", "bnjyljjyje": "111111", "kh052": "6767657", "kh050": "6666666", "kh051": "7777777", "@content": "flagmark,signSum,bnljjybs,bnjyljjyje,kh052,kh050,kh051" }, { "OBJCOD": "ac10002", "DATEFLG": "2", "DTADAT": "2020-08-11", "BEGINDATE": "2020-08-12", "ENDDATE": "2020-08-16", "JDHS": "6", "JDHCKRJ": "14.12", "JDHDKYE": "15.13", "JDHKHZS": "4", "JDHSJYHQY": " 23", "JDHETCQY": "12", "JDHSBKJH": "23", "JDHJHZFQY": "21", "JDHEBFQY": "41", "JDHSBSY": "1.33", "JDHCKRJBSY": "2.6666", "JDHDKYEBSY": "3.2233", "JDHKHZSBSY": "4.777", "JDHSJYHQYBSY": "1.888", "JDHETCQYBSY": "2.999", "JDHSBKJHBSY": "3.2222", "JDHJHZFQYBSY": "4.333", "JDHEBFQYBSY": "5.6666", "flagmark": "43543", "signSum": "签约明细", "bnljjybs": "666666", "bnjyljjyje": "333333", "kh052": "6767657", "kh050": "6666666", "kh051": "7777777", "@content": "flagmark,signSum,bnljjybs,bnjyljjyje,kh052,kh050,kh051" } ] }

46、查询金融趋势图

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller" }, "financial_trend_map": { "entry_teller@": "teller/entry_teller", "OBJCOD": "ac10001", "DATEFLG": "1", "BEGINDATE{}": " > '2020-08-11'", "ENDDATE{}": " < '2020-08-18'", "@column": "ENDDATE,JDHS,JDHCKRJ,JDHDKYE,JDHKHZS,JDHSJYHQY,JDHETCQY,JDHSBKJH,JDHJHZFQY,JDHEBFQY,JDHSBSY,JDHCKRJBSY,JDHDKYEBSY,JDHKHZSBSY,JDHSJYHQYBSY,JDHETCQYBSY,JDHSBKJHBSY,JDHJHZFQYBSY,JDHEBFQYBSY" } }

47

47、查询金融饼状图

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller" }, "financial_map_data": { "entry_teller@": "teller/entry_teller", "@column": "ANCBRTCOD" }, "marketing_performance": { "entry_teller@": "teller/entry_teller", "@column": "JDRQ,SCCKYE,SCJDCKNRJ,CKKLH,DQSXJE,SCSXRQ,YXJE,DYCYXRQ,LCCPQYRQ,LCCPJE,SCJDDKYE,SCJDDKNRJ" } }

48

48、查询行内客户号（新增）

url:localhost:50002/services/get

{ "custom": { "JBXX108": "522732199610081017", "JBXX107": "居民身份证", "JBXX101": "居民", "@column": "CUSTNO" } }

49

插入两条征信

post

{ "CREDIT_ZX[]": [ { "CUSTID": "c0000110001", "SPASS": "01", "REPORTID": "bg001001", "REPORTSTS": "01", "RESIDESTAT": "无", "MARRIGE": "已婚", "EDULEV": "本科", "HOMEADDRE": "北京市", "COMPANY": "agree", "WORKADDRE": "来广营", "LOANPERNUM": "0", "LOANPERAMT": 0, "LOANCNT": 0, "LOANBLANCEAMT": 0, "DEBITCNT": 0, "DEBITAMT": 0, "LOAN60MAXCNT": 0, "LOAN60SUMCNT": 0, "LOAN24MONINFO": "正常", "DEBIT24MONINFO": "正常", "REDEBIT24MONINFO": "正常", "PLEDGEAMT": 0, "LOANAMT": 0, "GUARANTAMT": 0, "MAYPAY6MON": 0, "DEBITSTS": "02", "SEMINUM": 0, "SEMIAMT": 0, "DEBITBRNOCNT": 0, "DEBITGRANTAMT": 0, "DEBIT6MONAVANTAMT": 20000, "BADLOANCNT": 0, "BADLOANAMT": 0, "SPECIALCNT": 0, "TAXARREACNT": 0, "ACCFUNDINFO": "5|2000", "OVERDUESTATEB": "无", "BADLOANB": "无", "LOANSTATUSB": "无", "OVERDUESTATEP": "无", "BADLOANP": "无", "LOANSTATUSP": "无", "BAKUP1": "", "BAKUP2": "", "O2RLNAME": "1-100,100最佳", "O2RLVAUE": "100" }, { "CUSTID": "c0000110002", "SPASS": "01", "REPORTID": "bg001002", "REPORTSTS": "01", "RESIDESTAT": "无", "MARRIGE": "已婚", "EDULEV": "本科", "HOMEADDRE": "北京市", "COMPANY": "agree", "WORKADDRE": "来广营", "LOANPERNUM": "0", "LOANPERAMT": 0, "LOANCNT": 0, "LOANBLANCEAMT": 0, "DEBITCNT": 0, "DEBITAMT": 0, "LOAN60MAXCNT": 0, "LOAN60SUMCNT": 0, "LOAN24MONINFO": "正常", "DEBIT24MONINFO": "正常", "REDEBIT24MONINFO": "正常", "PLEDGEAMT": 0, "LOANAMT": 0, "GUARANTAMT": 0, "MAYPAY6MON": 0, "DEBITSTS": "02", "SEMINUM": 0, "SEMIAMT": 0, "DEBITBRNOCNT": 0, "DEBITGRANTAMT": 0, "DEBIT6MONAVANTAMT": 20000, "BADLOANCNT": 0, "BADLOANAMT": 0, "SPECIALCNT": 0, "TAXARREACNT": 0, "ACCFUNDINFO": "5|2000", "OVERDUESTATEB": "无", "BADLOANB": "无", "LOANSTATUSB": "无", "OVERDUESTATEP": "无", "BADLOANP": "无", "LOANSTATUSP": "无", "BAKUP1": "", "BAKUP2": "", "O2RLNAME": "1-100,100最佳", "O2RLVAUE": "100" } ] }

插入两条预授信细项明细

{ "CREDIT_INDEX[]": [ { "CUSTID": "c0000110001", "HEALTH": "良", "MARITALSTATUS": "已婚", "AGE": "25", "SS0011": "优", "SSZD0003": "5", "SSZD0004": "200000", "SSZD0005": "100000", "SSZD0006": "无", "SSZD0007": "2000", "SSZD0008": "5000", "SSZD0009": "良好", "SSZD0010": "良好", "SSZD0014": "小", "SSZD0015": "110000", "SSZD0016": "一般", "SSZD0017": "50000" }, { "CUSTID": "c0000110002", "HEALTH": "良", "MARITALSTATUS": "已婚", "AGE": "25", "SS0011": "优", "SSZD0003": "5", "SSZD0004": "200000", "SSZD0005": "100000", "SSZD0006": "无", "SSZD0007": "2000", "SSZD0008": "5000", "SSZD0009": "良好", "SSZD0010": "良好", "SSZD0014": "小", "SSZD0015": "110000", "SSZD0016": "一般", "SSZD0017": "50000" } ] }

插入一条准入请求

{ "credit_apply[]": [ { "CUSTID": "c0000110001", "APTYPE": "01", "CUSTNM": "李先生", "CUTSEX": "1", "CERTNO": "131122199310213410", "PHOENM": "13261914254", "LEGNID": "c001", "UNITID": "c001", "TELLERID": "t0001", "FLOWID": "f001", "COUNTRY": "中国", "HOUSES": "租房", "NATION": "汉", "HOMEADDRTOTAL": "北京市", "ISMARRIED": "已婚", "MONEYPERYEAR": "50000", "ISENTREPRENEUR": "否", "EDULEV": "本科", "TOPDEGREE": "硕士", "POLITY": "党员", "JOB": "IT", "TRADETYPE": "IT", "HEALTH": "优", "REDBLACKLIST": "无", "ISCORRELATSIGN": "是", "CORRELATNAME": "刘女士", "CORRELATIDCARD": "131122199310213411", "CORRELATTEL": "13261914253", "CORRELATIONTYPE": "亲属" } ] }

查询申请人征信

{ "apply[]": { "credit_zx": { "CERTNO":"131122199310213410", "@column":"CERTNO,SPASS,O2RLVAUE" } }, "re[]": { "credit_zx": { "CERTNO":"131122199310213411", "@column":"CERTNO,SPASS,O2RLVAUE" } } }

50

插入一条贷款申请

url:localhost:50002/services/post

{ "credit_post[]": [ { "CUSTID": "c0000110001", "TELLERID": "t0001", "UNITID": "c001", "CUSTOMERCLASSIFY": "白领", "LOANKINDCLASSIFY": "个人贷款", "ASSURETYPECLASSIFY": "现贷", "PRODUCTID": "p001", "TNFLAG": "TN01", "LOANUSECLASSIFY": "买房", "APPLYTERM": "800m'", "APPLYAMOUNT": 1040000, "LOANUSE": "buy house", "LOANFORM": "一次放清", "XHFLAG": "否", "JXCYCLE": "1month", "INTEREXMODEL": "等额本息", "INTEREST": "5", "EXEINTEREST": "5.01", "YQINTERFLOAT": "20", "FXFLAG": "yes", "INTERTZMODEL": "01", "rateType": "01" } ] }

插入一条调查信息

{ "credit_survey[]": [ { "CUSTID": "c0000110001", "DCTELLERS": "t0001", "DCMAINTELLER": "t0001", "MAINTELLER": "t0001", "FIRSTTELLER": "t0001", "DCYJ":"满足标准，通过", "ISGREEN": "n" } ] }

51

上传影像

{ "credit_image[]": [ { "ID": "f001", "CUSTOMERID": "c0000110001", "CUSTNM": "李先生", "ANCBRTCOD": "anc001", "JBXX108": "522732199610081017", "影像指标1": "zipai.png" } ] }

52

查询申请列表

{ "[]":{ "credit_apply":{ "CUSTID":"c0000110001", "CUSTNM":"李先生", "HANDL_STATUS":"02" } } }

53

流水号查询客户信贷信息

{ "[]":{ "credit_apply":{ "flow_id":"f001" }, "credit_post":{ "flow_id":"f001" }, "credit_survey":{ "flow_id":"f001" }, "credit_zx@cust":{ "CERTNO@":"/credit_apply/CERTNO" }, "credit_zx@corpe":{ "CERTNO@":"/credit_apply/CORRELATIDCARD" } } }

55

暂存申请、调查信息 50 中的两个post请求即可

56

增加三个产品

{ "credit_product[]": [ { "productId": "p01", "productName": "住房贷款一号产品", "xyFlag": "01", "ajFlag": "01", "txFlag": "01", "loanPricingBaseRateType": "1", "CUSTOMERCLASSIFY": "个体", "LOANKINDCLASSIFY": "购房", "ASSURETYPECLASSIFY": "一次放清", "UNITID": "u01" }, { "productId": "p02", "productName": "住房贷款二号产品", "xyFlag": "01", "ajFlag": "02", "txFlag": "01", "loanPricingBaseRateType": "0", "CUSTOMERCLASSIFY": "个体", "LOANKINDCLASSIFY": "购房", "ASSURETYPECLASSIFY": "一次放清", "UNITID": "u01" }, { "productId": "p03", "productName": "住房贷款三号产品", "xyFlag": "01", "ajFlag": "02", "txFlag": "01", "loanPricingBaseRateType": "1", "CUSTOMERCLASSIFY": "个体", "LOANKINDCLASSIFY": "购房", "ASSURETYPECLASSIFY": "分期放清", "UNITID": "u01" } ] }

查询产品列表

{ "[]": { "credit_product": { "CUSTOMERCLASSIFY": "个体", "LOANKINDCLASSIFY": "购房", "ASSURETYPECLASSIFY": "一次放清", "UNITID": "u01" } } }

57

执行利率查询

{ "credit_interest": { "INTEREST": "4.8", "LOANTERM": 300, "INTEREXMODEL": 3, "AJLOAN": "08", "@column": "rate" } }

插入一条执行利率信息

{ "credit_interest[]": [ { "INTEREST": "4.8", "LOANTERM": 300, "INTEREXMODEL": 3, "AJLOAN": "08", "RATE": "5.13" } ] }

58

查询责任人

{ "credit_post":{ "CUSTID":"c0000110001", "APPLYAMOUNT":"1040000", "LOANFORM":"一次放清", "UNITID":"c001", "CURDATE":"20200617", "@column":"tellerId" } }

59

根据柜员号查询机构号

url:localhost:50002/services/get

{ "teller": { "entry_teller":"t0001", "@column":"BEL_UNIT,BEL_UNIT_NAME,ANCBRTCOD,ANCBRTCOD_NAME" } }

65

65、添加数据-agency

url:localhost:50002/services/post

{ "agency[]": [ { "ANCBRTCOD": "act1001", "unitLvl": "初级机构", "OBJTYPE": "AI机构", "BEL_UNIT": "b001" }, { "ANCBRTCOD": "act1002", "unitLvl": "中级机构", "OBJTYPE": "保险机构", "BEL_UNIT": "b002" }, { "ANCBRTCOD": "act1003", "unitLvl": "高级机构", "OBJTYPE": "审计机构", "BEL_UNIT": "b003" }, ] }

65、（新增）获取CRM的角色信息

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT" }, "financial_map_data": { "entry_teller@": "teller/entry_teller", "@column": "ANCBRTCOD" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "ANCBRTCOD,unitLvl,OBJTYPE" } }

66

66、添加数据

url:localhost:50002/services/post

{ "level[]": [ { "CUSTNO": "c0000110001", "CHG_LEVEL_BEFORE": "初级VIP", "CHG_LEVEL_AFTER": "中级VIP", "FIRST_LEVEL_TIME": "2020-08-24 18:32:44", "MISS_BEFORE_CUST_LEVEL": "中级VIP", "MISS_TIME": "2020-08-24 17:19:14.056", "MEACOD": "MOBILE0006" }, { "CUSTNO": "c0000110002", "CHG_LEVEL_BEFORE": "初级VIP", "CHG_LEVEL_AFTER": "中级VIP", "FIRST_LEVEL_TIME": "2020-08-25 18:32:44", "MISS_BEFORE_CUST_LEVEL": "中级VIP", "MISS_TIME": "2020-08-28 17:19:14.056", "MEACOD": "MOBILE0004" }, { "CUSTNO": "c0000110003", "CHG_LEVEL_BEFORE": "高级VIP", "CHG_LEVEL_AFTER": "中级VIP", "FIRST_LEVEL_TIME": "2020-08-24 18:32:44", "MISS_BEFORE_CUST_LEVEL": "中级VIP", "MISS_TIME": "2020-06-24 17:19:14.056", "MEACOD": "MOBILE0005" }, { "CUSTNO": "c0000110004", "CHG_LEVEL_BEFORE": "初级VIP", "CHG_LEVEL_AFTER": "中级VIP", "FIRST_LEVEL_TIME": "2020-07-25 18:32:44", "MISS_BEFORE_CUST_LEVEL": "中级VIP", "MISS_TIME": "2020-08-28 17:19:14.056", "MEACOD": "MOBILE0004" } ] }

66、获取VIP客户变化和流失客户详细

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "BEL_UNIT" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "OBJTYPE,BEL_UNIT" }, "level": { "BEL_UNIT@": "agency/BEL_UNIT", "@column": "CHG_LEVEL_BEFORE,CHG_LEVEL_AFTER,FIRST_LEVEL_TIME,MISS_BEFORE_CUST_LEVEL,MISS_TIME,MEACOD" } }

67

67、客户基本信息接口(新增)

url:localhost:50002/services/get

{ "custom": { "CUSTNO": "c0000110001", "@column": "entry_teller,CUSTNO,JBXX101,CUSTSEX,JBXX107,JBXX108,jbxx112,jbxx113,JZDZ,PHONENO,kh060,KHZBHYDLB" }, "teller": { "entry_teller@": "custom/entry_teller", "@column": "BEL_UNIT,CUSTMANAGERS" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "OBJTYPE": "AI机构", "@column": "OBJTYPE,BEL_UNIT" }, "level": { "BEL_UNIT@": "agency/BEL_UNIT", "@column": "CHG_LEVEL_AFTER," }, "financial_trend_map": { "entry_teller@": "custom/entry_teller", "@column": "ckye,ckrj,dkkhyezrmb,lcck,flagmark,signSum,bnljjybs,bnjyljjyje,kh052,kh050,kh051" }, "product": { "entry_teller@": "custom/entry_teller", "@column": "PRODUCT_NUM,prd_name" } }

68

68、客户关联信息列表查询(新增)

url:localhost:50002/services/get

{ "custom@this_costom": { "CUSTNO": "c0000110001", "@column": "entry_teller,relation_id,relationShip,ralationMarriage,ralationCultural,healthy" }, "teller": { "entry_teller@": "this_costom/entry_teller", "@column": "entry_teller,BEL_UNIT" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "OBJTYPE" }, "custom@relation_costom": { "id@": "this_costom/relation_id", "@column": "CUSTNO,relation_id,JBXX101,CUST_TYPE,JBXX108,JBXX107,ADDRESS,relationJobUnit,CUSTSEX,jbxx112,CUSTTRADE,relationJobUnit,PHONENO,MONEYPERYEAR," } }

69

69、前十客户排名查询接口(新增)

url:localhost:50002/services/get

{ "teller": { "role_type": "90", "@column": "entry_teller" }, "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO,chname,custlevel,rank" }, "level":{ "CUSTNO@": "custom/CUSTNO", "@column": "MEACOD" } }

70

70、客户360视图客户列表查询

url:localhost:50002/services/get

{ "custom": { "JBXX108": "522732199610081017", "@column": "CUSTNO,JBXX101,CUSTSEX,JBXX107,JBXX108,entry_teller,flag" }, "level": { "CUSTNO@": "custom/CUSTNO", "@column": "CHG_LEVEL_AFTER" }, "teller": { "entry_teller@": "custom/entry_teller", "@column": "CUSTMANAGERS,BEL_UNIT" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "ANCBRTCOD": "act1001", "@column": "OBJTYPE" } }

71

71、客户分析信息查询

url:localhost:50002/services/get

{ "custom": { "CUSTNO": "c0000110001", "@column": "CUSTNO,entry_teller,JBXX101,JBXX108,CUSTSEX,PHONENO,ADDRESS,jbxx112,jbxx113,jbxx206,hx_rksx,hx_kh021,KHZBZCDLB,qdph" }, "teller": { "entry_teller@": "custom/entry_teller", "@column": "BEL_UNIT,CUSTMANAGERS" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "OBJTYPE" }, "level": { "CUSTNO@": "custom/CUSTNO", "@column": "CHG_LEVEL_AFTER" } }

72

72、ADD DATA

url:localhost:50002/services/post

{ "schedule[]": [ { "THEME": "日程名称", "BEG_DATE": "2020-07-11", "END_DATE": "2020-07-13", "START_TIME": "2020-08-25 18:00:46.908", "END_TIME": "2020-08-25 18:00:46.908", "CIRCLE": "周期循序", "CONTENT": "备注", "CUSTNO": "c0000110001" } ] }

72、查询出日程和生日提醒信息

url:localhost:50002/services/get

{ "teller": { "role_type": "90", "entry_teller": "t0001", "@column": "entry_teller" }, "custom": { "entry_teller@": "teller/entry_teller", "@column": "CUSTNO" }, "schedule": { "CUSTNO@": "custom/CUSTNO", "BEG_DATE{}": " > '2020-07-10'", "end_DATE{}": " < '2020-09-10'", "@column": "THEME,BEG_DATE,END_DATE,START_TIME,END_TIME,CIRCLE,CONTENT,CUSTNO" } }

73

73、查询出日程里面生日提醒的具体信息

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT,CUSTMANAGERS" }, "custom": { "entry_teller@": "teller/entry_teller", "jbxx112": "10月8日", "@column": "CUSTNO,CUSTSEX,jbxx113,jbxx112" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "OBJTYPE" } }

74

74、ADD DATA

url:localhost:50002/services/post

{ "decline[]": [ { "RANK": "1", "MEACOD": "KH085", "meavallstdaydec": "424.12", "meavallstmondec": "5534.11", "meavallstquarterdec": "54344.99", "meavalyearbgndec": "3232332.66", "CUSTNO": "c0000110001" }, { "RANK": "2", "MEACOD": "KH086", "meavallstdaydec": "466.12", "meavallstmondec": "8534.11", "meavallstquarterdec": "54664.99", "meavalyearbgndec": "355332.66", "CUSTNO": "c0000110002" }, { "RANK": "3", "MEACOD": "KH084", "meavallstdaydec": "466", "meavallstmondec": "8534", "meavallstquarterdec": "54664", "meavalyearbgndec": "355332", "CUSTNO": "c0000110003" } ] }

74、降幅十大客户列表排名查询接口(新增)

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller" }, "custom": { "entry_teller@": "teller/entry_teller", "jbxx112": "10月8日", "@column": "CUSTNO" }, "decline": { "CUSTNO@": "custom/CUSTNO", "MEACOD":"KH085", "@column": "RANK,MEACOD,meavallstdaydec,meavallstmondec,meavallstquarterdec,meavalyearbgndec" } }

75

75、查询出客户经理的VIP客户数，各个指标（3 4 5星级，升级，降级，流失）的当日客户数和较上年末接口(新增)

url:localhost:50002/services/post

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT" }, "level": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "MEACOD" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "OBJTYPE":"AI机构", "@column": "MEAVAL,MEAVAL_LASTYEAR" } }

76

76、查询登记簿客户列表信息

url:localhost:50002/services/get

{ "teller": { "entry_teller": "t0001", "@column": "entry_teller,BEL_UNIT" }, "agency": { "BEL_UNIT@": "teller/BEL_UNIT", "OBJTYPE": "AI机构", "@column": "OBJTYPE" }, "custom": { "entry_teller@": "teller/entry_teller", "JBXX101": "居民", "JZDZ": "贵州省三都水族自治县大河镇大河街上豪爵摩托专卖店", "PHONENO": "13885430234", "@column": "JBXX101,JZDZ,PHONENO,CUSTUUID,CREATE_TIME,UPDATE_TIME,LOAD_FLAG" } }

77

77、ADD DATA OF imageurl

url:localhost:50002/services/post

{ "imageurl[]": [ { "SS0033": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0035": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0339": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0037": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0036": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0090": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0366": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "CUSTNO": "c0000110001" }, { "SS0033": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0035": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0339": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0037": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0036": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0090": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0366": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "CUSTNO": "c0000110002" } ] }

77、查询登记簿客户详细信息

url:localhost:50002/services/get

{ "custom": { "CUSTUUID": "4e7a0001", "@column": "ENTRY_TELLER,CUSTNO,CUSTUUID,LOAD_FLAG,JBXX101,JBXX107,JBXX108,PHONENO,healthy,ralationMarriage,relationJobUnit,CUSTTRADE,LIVESITUATION,SS0011,SS0005,NHXX101,SS0319,SS0003,SS0031,SS0219,SFZDZ,JZDZ,CREATE_TIME,UPDATE_TIME" }, "OPERATE": { "CUSTNO@": "custom/CUSTNO", "@column": "JYDZ,SS0018,GTSH100,SS0129,BUSI_DESC,SS0019,SS0024,SS0120,SS0281,SS0107,SS0108,SS0131,SS0165,SS0166,SS0167,SS0168,INPUT_ADDRESS" }, "marketing_performance": { "ENTRY_TELLER@": "custom/ENTRY_TELLER", "@column": "JDRQ_DATE,JD_FLAG" }, "imageurl": { "CUSTNO@": "custom/CUSTNO", "@column": "SS0033,SS0035,SS0339,SS0037,SS0036,SS0090,SS0366" } }

78

78、修改登记簿客户信息

url:localhost:50002/services/put

{ "custom[]": [ { "CUSTUUID": "4e7a0001", "JBXX101": "灵图", "JBXX107": "居民身份证", "JBXX108": "522732199610081017", "PHONENO": "13885430234", "healthy": "良好", "ralationMarriage": "未婚", "LIVESITUATION": "已定居", "SS0011": "道德评价良好", "SS0005": "5", "NHXX101": "3", "SS0319": "贫困", "SS0003": "客户分类", "ralationCultural": "本科", "CUSTTRADE": "北美精算师", "relationJobUnit": "微软", "SS0031": "精算", "SS0219": "大师", "SFZDZ": "北京通州潞城镇胡各庄中路古月家园2号楼一单元888", "JZDZ": "贵州省三都水族自治县大河镇大河街上豪爵摩托专卖店", "CREATE_TIME": "2020-08-01", "UPDATE_TIME": "2020-08-12", "@content": "JBXX101,JBXX107,JBXX108,PHONENO,healthy,ralationMarriage,LIVESITUATION,SS0011,SS0005,NHXX101,SS0319,SS0003,ralationCultural,CUSTTRADE,relationJobUnit,SS0031,SS0219,SFZDZ,LIVESITUATION,SFZDZ,JZDZ,CREATE_TIME,UPDATE_TIME" } ], "OPERATE[]": [ { "CUSTNO": "c0000110001", "JYDZ": "北京朝阳立水桥", "SS0018": "店铺名称", "GTSH100": "CHN00012001", "SS0129": "经营所有权", "BUSI_DESC": "经营资料", "SS0019": "玉米类", "SS0024": "15", "SS0120": "66666.66", "SS0281": "123423.00", "SS0107": "任正非", "SS0108": "18285424279", "SS0131": "3000", "SS0165": "马云", "SS0166": "13312346078", "SS0167": "王宝强", "SS0168": "18847896930", "INPUT_ADDRESS": "北京朝阳来广营城萤中心", "@content": "JYDZ,SS0018,GTSH100,SS0129,BUSI_DESC,SS0019,SS0024,SS0120,SS0281,SS0107,SS0108,SS0131,SS0165,SS0166,SS0167,SS0168,INPUT_ADDRESS" } ], "marketing_performance[]": [ { "ENTRY_TELLER": "t0001", "JDRQ_DATE": "2020-01-18", "JD_FLAG": "001", "@content": "JDRQ_DATE,JD_FLAG" } ], "imageurl[]": [ { "CUSTNO": "c0000110001", "SS0033": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0035": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0339": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0037": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0036": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0090": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0366": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "@content": "SS0033,SS0035,SS0339,SS0037,SS0036,SS0090,SS0366" } ] }

79

79、新增登记簿客户影像信息

url:localhost:50002/services/post

{ "imageurl[]": [ { "SS0033": "'url':'<img src=\"https://abs.agree.com/img/07aa.jpg\" style=\"max-width: 100%;\"> '", "SS0035": "'url':'<img src=\"https://abs.agree.com/img/08aa.jpg\" style=\"max-width: 100%;\"> '", "SS0339": "'url':'<img src=\"https://abs.agree.com/img/09aa.jpg\" style=\"max-width: 100%;\"> '", "SS0037": "'url':'<img src=\"https://abs.agree.com/img/10dd.jpg\" style=\"max-width: 100%;\"> '", "SS0036": "'url':'<img src=\"https://abs.agree.com/img/11dd.jpg\" style=\"max-width: 100%;\"> '", "SS0090": "'url':'<img src=\"https://abs.agree.com/img/11ee.jpg\" style=\"max-width: 100%;\"> '", "SS0366": "'url':'<img src=\"https://abs.agree.com/img/12ff.jpg\" style=\"max-width: 100%;\"> '", "CUSTNO": "c0000110003", "CUSTUUID": "4e7a0003" } ] }

79、修改登记簿客户影像信息

url:localhost:50002/services/put

{ "imageurl[]": [ { "CUSTNO": "c0000110001", "SS0033": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0035": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0339": "'url':'<img src=\"https://abs.agree.com/img/01aa.jpg\" style=\"max-width: 100%;\"> '", "SS0037": "'url':'<img src=\"https://abs.agree.com/img/03cc.jpg\" style=\"max-width: 100%;\"> '", "SS0036": "'url':'<img src=\"https://abs.agree.com/img/04cc.jpg\" style=\"max-width: 100%;\"> '", "SS0090": "'url':'<img src=\"https://abs.agree.com/img/05cc.jpg\" style=\"max-width: 100%;\"> '", "SS0366": "'url':'<img src=\"https://abs.agree.com/img/06cc.jpg\" style=\"max-width: 100%;\"> '", "@content": "SS0033,SS0035,SS0339,SS0037,SS0036,SS0090,SS0366" } ] }

80

80、查询预授信额度模板

url:localhost:50002/services/get

{ "custom": { "JBXX108": "522732199610081017", "@column": "CUST_TYPE,entry_teller" }, "TELLER": { "entry_teller@": "custom/entry_teller", "@column": "ANCBRTCOD,BEL_UNIT" }, "level": { "BEL_UNIT@": "teller/BEL_UNIT", "@column": "MEACOD_ID" } }

81

81、修改预授信额度评分

url:localhost:50002/services/put

{ "credit_index[]": [ { "CUSTID": "c0000110001", "HEALTH": "良好", "MARITALSTATUS": "未婚", "AGE": "25", "SS0011": "优", "SSZD0003": "5", "SSZD0004": "200000", "SSZD0005": "100000", "SSZD0006": "无", "SSZD0007": "2000", "SSZD0008": "5000", "SSZD0009": "良好", "SSZD0010": "良好", "SSZD0014": "小", "SSZD0015": "110000", "SSZD0016": "一般", "SSZD0017": "50000", "FLOW_ID": "f001", "ANCBRTCOD": "an001", "@content": "HEALTH,MARITALSTATUS,AGE,SS0011,SSZD0003,SSZD0004,SSZD0005,SSZD0006,SSZD0007,SSZD0008,SSZD0009,SSZD0010,SSZD0014,SSZD0015,SSZD0016,SSZD0017,FLOW_ID,ANCBRTCOD" } ] }

82

82、查询登记簿批量标签

url:localhost:50002/services/get

{ "custom": { "CREATE_TIME{}": " >= '2020-08-01'", "UPDATE_TIME{}": " <= '2020-08-31'", "@column": "LOAD_FLAG" } }

83

83、小额信贷删除待办任务（新增）

url:localhost:50002/services/get

{ "credit_index": { "id":"9" } }

84

84、重载预授信额度评分_____预授信细项明细

url:localhost:50002/services/get

{ "credit_apply": { "CERTNO": "522732199610081017", "LEGNID": "c001", "UNITID": "c001", "FLOW_ID": "f001", "@column": "FLOW_ID" }, "credit_index": { "FLOW_ID@": "credit_apply/FLOW_ID", "@column": "HEALTH,MARITALSTATUS,AGE,SS0011,SSZD0003,SSZD0004,SSZD0005,SSZD0006,SSZD0007,SSZD0008,SSZD0009,SSZD0010,SSZD0014,SSZD0015,SSZD0016,SSZD0017" } }

84、重载预授信额度评分_预授信算分明细_添加预授信额度YSXED

url:localhost:50002/services/get

最新回复(0)

四扫客户接口——接口测试完成文档

文章目录

CREATE TABLE

1创建custom表

6新建活动表_ACTIVITY

7创建teller表

8、建立模板表

9、增加个性化模板表

10、建立客户与活动对应表

11、创建流水表

16、创建资产表ASSET

21 经营表operate

26 family表

31、创建业务表professional

33创建金融需求表_financial

36创建任务表–task

38创建产品表–product

39、创建营销业绩汇总表–marketing_performance

45、创建金融地图数据表financial_map_data

46、创建表金融趋势图financial_trend_map

49、小额信贷CREDIT_INDEX

65、创建机构表agency

66、创建一个级别 表level

72、创建日程信息表schedule

74、创建降幅表decline

77、创建”影像“表imageurl

1

1、给teller表添加角色

1、用户角色查询

2

2、客户四扫数据查询_根据客户号

2、客户四扫数据查询_根据证件号

3

3、客户行内数据查询

3、role

4

4、添加列“外部数据类型编码”

4、外部数据查询

5

5、图片上传影像

6

6、添加数据

6、四扫数据保存

7

7、为新增字段添加数据

7、四扫数据提交_获取数据

7、四扫数据提交

7、添加数据

8

柜员添加法人号

插入模板

查询模板

9

插入个性化模板数据

查询模板数据

10

客户营销活动

营销列表

11

新增客户

13

活动列表查询

14

活动文件列表

15

插入数据

16

16、为表ASSET添加数据

16、资产列表查询

17

17、资产明细查询

18

18、资产新增

19

19、资产明细编辑

20

20、资产明细删除

21

21、为经营operate表添加数据

21、经营列表查询

66、创建一个级别表level

24、经营明细编辑_根据编号ID来编辑_因为多个的经营种类会对应同一个客户号

42、排行榜查询（新增）