自动生成sql
package com.datahthx.credit.test;
import cn.hutool.core.collection.ListUtil;
import cn.hutool.core.date.DateTime;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.CharsetUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.crypto.asymmetric.KeyType;
import cn.hutool.crypto.asymmetric.RSA;
import cn.hutool.crypto.digest.DigestUtil;
import com.alibaba.excel.EasyExcel;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.datahthx.credit.controller.VariablePlatformController;
import com.datahthx.credit.util.MD5Util;
import com.datahthx.credit.util.RsaUtil;
import lombok.extern.slf4j.Slf4j;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.junit4.SpringRunner;
import java.io.;
import java.nio.charset.StandardCharsets;
import java.util.;
//@ActiveProfiles("dev")
//@SpringBootTest(classes={DataQccApplication.class})
@RunWith(SpringRunner.class)
@Slf4j
public class SecureTest {
@Test
public void shijianchuoTest2() throws Exception {
String fileName = "\r\n\r\n\r\n\t<meta name=\"robots\" content=\"noindex,nofollow\"/>\r\n\t<meta charset=\"utf-8\">\r\n\t<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n\t<link rel=\"shortcut icon\" href=\"favicon.png\">\r\n\t
\r\n\t\t查询机构:海通恒信国际融资租赁股份有限公司\r\n\t\r\n\r\n\t<div class=\"f-floatright f-txtleft\">\r\n\t\t报告时间:2022-10-18T16:44:57
\r\n\t\t查询原因:贷前(保前)审查\r\n\t\r\n\r\n\r\n\r\n\r\n<div class=\"m-repbody\">\r\n\t<div class=\"t1\">身份标识\r\n\r\n\t<table class=\"g-tab-bor\">\r\n\t\t\r\n\t\t\t<th style=\"width: 30%;\">企业名称\r\n\t\t\t<td class=\"f-txtleft \">杭州卓越绣品有限公司\r\n\t\t\r\n\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">中征码\r\n\t\t\t\t<td class=\"f-txtleft \">3301090012210304\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">统一社会信用代码\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">组织机构代码\r\n\t\t\t\t<td class=\"f-txtleft \">MA2B0PFR5\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">纳税人识别号(国税)\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">纳税人识别号(地税)\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\r\n\r\n\t\r\n\r\n\r\n\t<div class=\"m-repbody firstPage\">\r\n\t\t\r\n\t\t\r\n<div class=\"t1\">基本信息\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">基本概况信息\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">经济类型\r\n\t\t<td class=\"g-w-4 \">其他\r\n\t\t<th class=\"g-w-4\">组织机构类型\r\n\t\t<td class=\"g-w-4 \">企业\r\n\t\r\n\t\r\n\t\t企业规模\r\n\t\t<td class=\"\">微型企业\r\n\t\t所属行业\r\n\t\t<td class=\"\">窗帘、布艺类产品制造\r\n\t\r\n\t\r\n\t\t成立年份\r\n\t\t<td class=\"\">2018\r\n\t\t登记证书有效截止日期\r\n\t\t<td class=\"\">长期\r\n\t\r\n\t\r\n\t\t登记地址\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">浙江省杭州市萧山区衙前镇凤凰村\r\n\t\r\n\t\r\n\t\t办公/经营地址\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">浙江省杭州市萧山区衙前镇凤凰村\r\n\t\r\n\t\r\n\t\t存续状态\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">正常营业\r\n\t\r\n\r\n\t\t<ul class=\"u-msg-nonumlist\">\r\n\t\t\t\t\t\r\n\t\t\r\n\t\t\t\r\n<div class=\"g-tt-h3 f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">注册资本及主要出资人信息<span class=\"f-floatright tn\">注册资本折人民币合计200万元\r\n\r\n\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-5\">类型\r\n\t\t<th class=\"g-w-5\">出资方\r\n\t\t<th class=\"g-w-5\">身份标识类型\r\n\t\t<th class=\"g-w-5\">身份标识号码\r\n\t\t<th class=\"g-w-5\">出资比例\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t--\r\n\t\t\t\t\t\t\t--\r\n\t\t\t\t\t\t--\r\n\t\t\t--\r\n\t\t\t--\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t<td colspan=\"5\" class=\"f-txtright\">\r\n\t\t\t更新日期:2018-03-08\r\n\t\r\n\r\n\t\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">主要组成人员信息\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">职位\r\n\t\t<th class=\"g-w-4\">姓名\r\n\t\t<th class=\"g-w-4\">证件类型\r\n\t\t<th class=\"g-w-4\">证件号码\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t法定代表人/非法人组织负责人\r\n\t\t\t\t\t\t\t<a class=\"f-a-line\" onclick=\"popReportUrl('../redirectcreditreport/getReport.action?IDType=1&certTypeID=1014691&certCode=450325199006041312&certName=王明林')\"\r\n\t\t\t\t\t href=\"javascript:void(0);\">王明林\r\n\t\t\t\t\t\t身份证\r\n\t\t\t450325199006041312\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t<td colspan=\"4\" class=\"f-txtright\">\r\n\t\t\t更新日期:2021-11-05\r\n\t\r\n\r\n\t\r\n\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">实际控制人\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">名称\r\n\t\t<th class=\"g-w-4\">身份标识类型\r\n\t\t<th class=\"g-w-4\">身份标识号码\r\n\t\t<th class=\"g-w-4\">更新日期\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t\t\t\t\t<a class=\"f-a-line g-w-4\" onclick=\"popReportUrl('../redirectcreditreport/getReport.action?IDType=1&certTypeID=1014691&certCode=450325199006041312&certName=王明林')\"\r\n\t\t\t\t\t href=\"javascript:void(0);\">王明林\r\n\t\t\t\t\t\t<td class=\"g-w-4\">身份证\r\n\t\t\t<td class=\"g-w-4\">450325199006041312\r\n\t\t\t<td class=\"g-w-4\">2021-11-05\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n\t\r\n<div class=\"m-repbody\">\r\n\t<div class=\"t1\">信息概要\r\n\t\r\n\t<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th class=\"g-w-4\">首次有信贷交易的年份\r\n\t\t<th class=\"g-w-4\">发生信贷交易的机构数\r\n\t\t<th class=\"g-w-4\">当前有未结清信贷
交易的机构数\r\n\t\t<th class=\"g-w-4\">首次有相关还款
责任的年份\r\n\t\r\n\t\r\n\t\t2019\r\n\t\t2\r\n\t\t0\r\n\t\t--\r\n\t\r\n\r\n\r\n<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th colspan=\"2\" class=\"g-w-4\">借贷交易\r\n\t\t<th colspan=\"2\" class=\"f-txt-nowrap g-w-4\">担保交易\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\">余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\">余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t\r\n\t\t<th class=\"f-linheight f-txtleft\">其中:被追偿余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-linheight f-txtleft\">其中:关注类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\"> 关注类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\"> 不良类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\"> 不良类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\"> \r\n\t\t<td class=\"f-txtright\"> \r\n\t\r\n\r\n\r\n<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th class=\"g-w-5\">非信贷交易账户数\r\n\t\t<th class=\"g-w-5\">欠税记录条数\r\n\t\t<th class=\"g-w-5\">民事判决记录条数\r\n\t\t<th class=\"f-txt-nowrap g-w-5\">强制执行记录条数\r\n\t\t<th class=\"g-w-5\">行政处罚记录条数\r\n\t\r\n\t\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">已结清信贷信息概要\r\n\t\t\t<table class=\"g-tab-bor\">\r\n\t\t\r\n\t\t\t<td style=\"width:15%\"> \r\n\t\t\t<th style=\"width:20%\">正常类账户数\r\n\t\t\t<th style=\"width:20%\">关注类账户数\r\n\t\t\t<th style=\"width:20%\">不良类账户数\r\n\t\t\t<th style=\"width:20%\">合计\r\n\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t中长期借款\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t短期借款\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t合计\r\n\t\t\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">负债历史\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th rowspan=\"2\" style=\"width:10%\">\r\n\t\t<th colspan=\"2\" style=\"width:18%\">全部负债\r\n\t\t<th colspan=\"2\" style=\"width:18%\">关注类负债\r\n\t\t<th colspan=\"2\" style=\"width:18%\">不良类负债\r\n\t\t<th colspan=\"4\" style=\"width:36%\">逾期类负债\r\n\t\r\n\t\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">逾期
账户数\r\n\t\t<th style=\"width:9%\">逾期总额\r\n\t\t<th style=\"width:9%\">本金逾期
账户数\r\n\t\t<th style=\"width:9%\">逾期本金\r\n\t\r\n\t\t\t\r\n\t\t\t2022-06\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2022-03\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-12\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-09\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t14.67\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-06\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t28.99\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-03\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t38.35\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-12\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t52.10\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-09\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t84.73\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-06\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t93.50\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-03\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t97.83\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2019-12\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t110.62\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2019-09\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t103.91\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\r\n\r\n\r\n\r\n\t<div class=\"firstPage\">\r\n\t\t\r\n\t\t<div class=\"m-repbody\">\r\n\t<div class=\"t1\">报告说明\r\n\t
\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">1.本报告由中国人民银行征信中心出具,依据截止报告时间征信系统记录的信息生成。除征信中心标注外,信息均由相关数据提供机构和信息主体提供,征信中心不保证其真实性和准确性,但承诺在信息汇总、加工、整合的全过程中保持客观、中立的地位。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">2.本报告所展示的基本信息来自征信系统对不同数据来源提供的同一个信息主体基本信息进行整合后的结果。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">3.本报告中信贷交易包括借贷交易和担保交易。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">4.本报告中借贷交易包括各种形式的贷款,也包括以各种其他名义融资但实质上是借贷的行为,即融资方负有明确还款责任的交易。常见的交易形式包括:贷款、贸易融资、票据贴现、保理、透支、融资租赁、回购、垫款、黄金证券借贷、公司信用债等。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">5.本报告中担保交易指第三人和债权人约定,当债务人不履行债务时,第三人按约定履行债务的行为。包括名义上没有担保合同约定但当债务人违约时、第三人实质上要代偿的行为。常见的交易形式包括:银行承兑汇票、信用证、银行保函、融资担保公司提供的担保服务,保险公司提供的信用保证保险服务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">6.本报告中被追偿业务是指剩余本息处于催收状态(即债权人要求债务人尽快归还全部借款)的借贷交易。常见的产品种类包括:由资产管理公司处置的债务、垫款(含担保代偿)。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">7.本报告中的短期借款、中长期借款是指借贷交易中除被追偿业务、循环透支、贴现之外的业务,按照 “借款期限分类”划分,分别对应其中的短期、中期和长期。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">8.本报告中借贷交易的正常类是指除被追偿业务之外,五级分类为“正常”或者五级分类为“未分类”且逾期天数为0的业务;关注类是指除被追偿业务之外,五级分类为“关注”或者五级分类为“未分类”且逾期0至90天的业务;不良类是指除被追偿业务之外,五级分类为“次级”、“可疑”、“损失”、“违约”或者五级分类为“未分类”且逾期90天以上的业务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">9.本报告中担保交易的正常类、关注类、不良类分别对应五级分类为正常、关注和后三类的业务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">10.本报告中信息概要部分中的负债历史信息,其中负债是指由信贷交易所产生的债务;逾期总额、逾期本金是指除被追偿业务之外的借贷交易的逾期总额(含欠息)合计及逾期本金合计。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">11.本报告仅展示信息主体一定期限范围内的已结清信贷信息、非信贷信息、公共信息。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">12.如无特别说明,本报告中的金额类数据项单位均为万元。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">13.如无特别说明,本报告中的金额类汇总数据项均为人民币计价。外币折人民币的计算依据国家外汇管理局当月公布的各种货币对美元折算率表。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">14.如信息记录斜体展示,则说明信息主体对此条记录存在异议。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">15.数据提供机构说明是报数机构对报告中的信息记录或对信息主体所作的补充说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">16.征信中心说明是征信中心对报告中的信息记录或对信息主体所作的说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">17.信息主体声明是信息主体对报数机构提供的信息记录所作的简要说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">18.本报告仅供金融(授信)机构按照与信息主体的约定使用,请金融机构妥善保管,不得提供给信息主体和任何第三人。因保管使用不当而引起纠纷的,征信中心不承担相关责任。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\t\r\n\t\t\r\n\t
| 汇率(美元折人民币):6.89 有效期:2022-09 |
编号\r\n\t\t\t<th class=\"g-w-7\">授信机构\r\n\t\t\t<th class=\"g-w-7\">业务种类\r\n\t\t\t<th class=\"g-w-7\">开立日期\r\n\t\t\t<th class=\"g-w-7\">到期日\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">币种\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">借款金额\r\n\t\t\r\n\t\t\r\n\t\t\t<th class=\"g-w-7\">关闭日期\r\n\t\t\t<th class=\"g-w-7\">五级分类\r\n\t\t\t<th colspan=\"3\" class=\"g-w-7 g-cel-nobor\">\r\n\r\n\t\t\t\t\r\n\t\t\t\t\t<tr class=\"g-cel-nobor-ie\">\r\n\t\t\t\t\t\t<th class=\"g-w-2\">最后一次还款日期\r\n\t\t\t\t\t\t<th class=\"g-w-2 g-cel-nobor-ie\">最后一次还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t
认定日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"totOverdEnt\">逾期总额\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdPrincEnt\">逾期本金\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdueMonths\">逾期月数\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyDate\">最近一次约定
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyAmt\">最近一次
应还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyDate\">最近一次实际
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyAmt\">最近一次
实还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"rpmtType\">最近一次
还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\r\n\t\t\t<table class=\"g-subtab-bor\" listname=\"transactions\">\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t\t<th colspan=\"5\">特定交易提示\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transType\">交易类型\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"tranDate\">交易日期\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transAmountEnt\">交易金额\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"changeMonthNum\">到期日期变更月数\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"detailInfo\">交易明细信息\r\n\t\t\t\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\r\n\r\n\t\t\r\n\t\t<table class=\"g-tab-nobor\">\r\n\t\r\n\t\t<th class=\"tnt f-tleft f-mgtop\"><img\r\n\t\t\t\tsrc=\"../resources/product/e/images/hot_red_folder.gif\">短期借款\r\n\t\t\r\n\t\t<th class=\"f-tright\">共1笔\r\n\t\r\n\r\n
编号\r\n\t\t\t<th class=\"g-w-7\">授信机构\r\n\t\t\t<th class=\"g-w-7\">业务种类\r\n\t\t\t<th class=\"g-w-7\">开立日期\r\n\t\t\t<th class=\"g-w-7\">到期日\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">币种\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">借款金额\r\n\t\t\r\n\t\t\r\n\t\t\t<th class=\"g-w-7\">关闭日期\r\n\t\t\t<th class=\"g-w-7\">五级分类\r\n\t\t\t<th colspan=\"3\" class=\"g-w-7 g-cel-nobor\">\r\n\r\n\t\t\t\t\r\n\t\t\t\t\t<tr class=\"g-cel-nobor-ie\">\r\n\t\t\t\t\t\t<th class=\"g-w-2\">最后一次还款日期\r\n\t\t\t\t\t\t<th class=\"g-w-2 g-cel-nobor-ie\">最后一次还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t
认定日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"totOverdEnt\">逾期总额\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdPrincEnt\">逾期本金\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdueMonths\">逾期月数\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyDate\">最近一次约定
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyAmt\">最近一次
应还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyDate\">最近一次实际
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyAmt\">最近一次
实还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"rpmtType\">最近一次
还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\r\n\t\t\t<table class=\"g-subtab-bor\" listname=\"transactions\">\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t\t<th colspan=\"5\">特定交易提示\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transType\">交易类型\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"tranDate\">交易日期\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transAmountEnt\">交易金额\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"changeMonthNum\">到期日期变更月数\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"detailInfo\">交易明细信息\r\n\t\t\t\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\r\n\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t<div id=\"button\">\r\n\t\t<button onclick=\"more()\">查看明细页面\r\n\t\r\n\r\n\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\t/展示和隐藏内容/\r\n\tvar k = 50+1;\r\n\t$().ready(function () {\r\n\t\t$(\"table.creditDetail\").find(\">tbody:lt(\" + k + \")\").show();\r\n\r\n\t\t//屏蔽复制,粘贴,剪切\r\n\t\t//var bodyMains = document.getElementById('top' );\r\n\t\t//禁止复制\r\n\t\tdocument.oncopy = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止粘贴\r\n\t\tdocument.onpaste = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止剪切\r\n\t\tdocument.oncut = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止右键菜单\r\n\t\tdocument.oncontextmenu = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止文本选择\r\n\t\tdocument.onselectstart = function () {\r\n\t\t\treturn false;\r\n\t\t};\r\n\t});\r\n\r\n\t/合同跳转/\r\n\tfunction creditInfoShow(tmp) {\r\n\t\tvar m = $.trim($(tmp).text());\r\n\t\tlayer.closeAll();\r\n\t\tvar a = jQuery('a[id=\"UnClearedCreditInfoBankUnitVOs\"]');\r\n\t\tvar tbodys = a.parent(\"div\").parent(\"div\").children(\"table\").children(\"tbody:gt(\" + (k - 1) + \")\");\r\n\t\tif (a.attr(\"displayStatus\") == \"show\") {\r\n\t\t\ta.html(\"- 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"hide\");\r\n\t\t\ttbodys.show();\r\n\t\t}\r\n\t\tvar whref = window.location.href;\r\n\t\tif (whref.indexOf(\"#\") > -1) {\r\n\t\t\twhref = whref.substr(0, whref.indexOf(\"#\"));\r\n\t\t}\r\n\r\n\t\twindow.location.href = whref + \"#\" + m;\r\n\t};\r\n\r\n\tfunction showHideTable(aId) {\r\n\t\tvar a = $(\"#\" + aId);\r\n\t\tvar tbodys = a.parent(\"div\").parent(\"div\").children(\"table\").children(\"tbody:gt(\" + (k - 1) + \")\");\r\n\t\tif (a.attr(\"displayStatus\") == \"show\") {\r\n\t\t\ta.html(\"- 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"hide\");\r\n\t\t\ttbodys.show();\r\n\t\t} else {\r\n\t\t\ta.html(\"+ 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"show\");\r\n\t\t\ttbodys.hide();\r\n\t\t}\r\n\t}\r\n\r\n\t/* 一级展示和二级展示切换/\r\n\tfunction more() {\r\n\r\n\t\t$(\"div.secondPage\").show();\r\n\t\t$(\"div.firstPage\").hide();\r\n\t\t$(\"#button\").hide();\r\n\t\twindow.location.href = window.location.href + \"#top\";\r\n\r\n //用来修正嵌套的表格由于外单元高度过高导致内部的表格不能自动跟随100%高度的问题\r\n resetCelHeight();// 方法在静态资源的report.js里\r\n\t};\r\n\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\t//弹窗口按钮\r\n\tfunction popProvidentPayment(_this) {\r\n\t\t//获取模型和数据\r\n\t\tvar filterIdIn = jQuery(_this).attr('filterId').split(\" \");\r\n\t\tvar idToJudgeData = jQuery(_this).attr('idToJudgeData');\r\n\t\tvar modalElement = $('div.' + idToJudgeData).length == 0 ? '' : $('div.' + idToJudgeData);\r\n\t\tif (modalElement == '') {\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\t\tvar modalData = $.extend(true, {}, modalElement.data());\r\n\t\tmodalData.data = window[modalData.data];\r\n\t\tmodalData.modal = modalElement.clone();\r\n\t\tmodalData.filterName = modalData.filterName.split(\" \");\r\n\t\t$(document.body).append(modalData.modal);\r\n\t\tsecModalDialogForProvidentPayment(modalData, filterIdIn);\r\n\t};\r\n\r\n\r\n\t//弹出\r\n\tfunction secModalDialogForProvidentPayment(modalData, filterIdIn) {\r\n\t\t// 遍历数据集\r\n\t\tjQuery.each(modalData.data, function (index, data) {\r\n\t\t\tvar trHtml = \"\";\r\n\t\t\tvar flag = true;\r\n\t\t\t// 过滤条件\r\n\t\t\tjQuery.each(modalData.filterName, function (index, val) {\r\n\t\t\t\tif (data[modalData.filterName[index]] != filterIdIn[index]) {\r\n\t\t\t\t\tflag = false;\r\n\t\t\t\t}\r\n\t\t\t});\r\n\r\n\t\t\tif (flag) {\r\n\t\t\t\t// 遍历标题行\r\n\t\t\t\tjQuery(modalData.modal).find('.title').each(function () {\r\n\t\t\t\t\ttrHtml += \"\";\r\n\r\n\t\t\t\t\tjQuery(this).find('th').each(function () {\r\n\t\t\t\t\t\tvar modalName = jQuery(this).attr('modalName');\r\n\t\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\t\tvar colNum = jQuery(this).attr('colspan');\r\n\t\t\t\t\t\tvar dataName = data[modalName] || \"\";\r\n\r\n\t\t\t\t\t\tif (rowNum > 1 && colNum > 1) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else if (rowNum > 1 && !(colNum > 1)) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else if (!(rowNum > 1) && colNum > 1) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t});\r\n\t\t\t\t\ttrHtml += \"\";\r\n\t\t\t\t\tjQuery(modalData.modal).find('table').last().append(trHtml);\r\n\t\t\t\t\ttrHtml = '';\r\n\t\t\t\t});\r\n\t\t\t}\r\n\r\n\t\t});\r\n\r\n\t\tlayer.open({\r\n\t\t\ttype: 1,\r\n\t\t\ttitle: '',\r\n\t\t\t// skin: 'layui-layer-rim', //样式类名\r\n\t\t\tcloseBtn: 1,\r\n\t\t\t// scrollbar: false,\r\n\t\t\tarea: [modalData.width, '460px'],\r\n\t\t\tshadeClose: true, //点击遮罩关闭\r\n\t\t\tcontent: jQuery(modalData.modal),\r\n\t\t\tend: function () {\r\n\t\t\t\tmodalData.modal.remove();\r\n\t\t\t}\r\n\t\t});\r\n\t}\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\tfunction openProductModal(_this) {\r\n\r\n\t\tvar filterIdIn = jQuery(_this).attr('filterId').split(\" \");\r\n\t\t//获取模型和数据\r\n\t\tvar idToJudgeData = jQuery(_this).attr('idToJudgeData');\r\n\t\tvar modalElement = $('div.' + idToJudgeData).length == 0 ? '' : $('div.' + idToJudgeData);\r\n\t\tif (modalElement == '') {\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\t\tvar modalData = $.extend(true, {}, modalElement.data());\r\n\t\tmodalData.data = window[modalData.data];\r\n\t\tmodalData.modal = modalElement.clone();\r\n\r\n\t\tmodalData.filterName = modalData.filterName.split(\" \");\r\n\t\t$(document.body).append(modalData.modal);\r\n\t\tsecModalDialog(modalData, filterIdIn);\r\n\r\n\t}\r\n\r\n\t//最外层为单条或者多条情况统计\r\n\r\n\tfunction secModalDialog(modalData, filterIdIn) {\r\n\t\tvar notDataModal = modalData.modal.clone();\r\n\t\tvar popBizNumber = 0;\r\n\t\t// 遍历数据集\r\n\t\tjQuery.each(modalData.data, function (index, data) {\r\n\r\n\t\t\tvar flag = true;\r\n\t\t\t// 过滤条件\r\n\t\t\tjQuery.each(modalData.filterName, function (index, val) {\r\n\t\t\t\tif (data[modalData.filterName[index]] != filterIdIn[index]) {\r\n\t\t\t\t\tflag = false;\r\n\r\n\t\t\t\t}\r\n\t\t\t});\r\n\r\n\t\t\tif (flag) {\r\n\t\t\t\tpopBizNumber += 1;\r\n\t\t\t\tif (popBizNumber > 1) {\r\n\t\t\t\t\tmodalData.modal = modalData.modal.append(notDataModal.find('div.m-form-wrap').clone());\r\n\t\t\t\t}\r\n\t\t\t\t//加入编号\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('span[modalName = \"itemNumber\"]').html(popBizNumber);\r\n\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('span[modalName]').each(function () {\r\n\t\t\t\t\tvar spanModalName = $(this).attr('modalName');\r\n\t\t\t\t\tvar spanVal = data[spanModalName];\r\n\t\t\t\t\t$(this).html(spanVal);\r\n\t\t\t\t});\r\n\r\n\r\n\t\t\t\tvar trHtml = \"\";\r\n\t\t\t\ttrHtml += \"\";\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[entityname]').find('th[modalName]').each(function () {\r\n\t\t\t\t\tvar modalName = $(this).attr(\"modalName\");\r\n\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\tvar val = data[modalName] || \"\";\r\n\t\t\t\t\tif (rowNum > 1) {\r\n\t\t\t\t\t\ttrHtml += \"\" + val + \"\";\r\n\t\t\t\t\t} else {\r\n\t\t\t\t\t\tif (modalName == \"conCode\" && data.hasContract) {\r\n\t\t\t\t\t\t\ttrHtml += '<a class=\"f-a-line\" href=\"javascript:void(0)\" onclick=\"creditInfoShow(this)\" >' + val + '';\r\n\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + val + \"\";\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t}\r\n\t\t\t\t});\r\n\t\t\t\ttrHtml += \"\";\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[entityname]').append(trHtml);\r\n\t\t\t\ttrHtml = '';\r\n\r\n\t\t\t\tvar dataDetail = '';\r\n\t\t\t\tvar listElement = jQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[listname]');\r\n\t\t\t\tif (listElement.length == 0) {\r\n\t\t\t\t\treturn;\r\n\t\t\t\t}\r\n\r\n\t\t\t\tlistElement.each(function (index, singleListElement) {\r\n\t\t\t\t\tvar singleListElement = $(singleListElement);\r\n\t\t\t\t\tvar listName = singleListElement.attr('listname')\r\n\t\t\t\t\tdataDetail = data[listName];\r\n\t\t\t\t\t/ } /\r\n\t\t\t\t\tif (dataDetail == undefined || dataDetail.length == 0) {\r\n\t\t\t\t\t\t//定制化处理,如果是贴现(包含已结清以及未结清)弹窗,将标题隐藏\r\n\t\t\t\t\t\tif (jQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[themename=\"discount\"]').length > 0 && listName == 'details') {\r\n\t\t\t\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[themename=\"discount\"]').hide();\r\n\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t\tsingleListElement.remove();\r\n\t\t\t\t\t}\r\n\t\t\t\t\tif (dataDetail instanceof Array && dataDetail.length > 0) {\r\n\t\t\t\t\t\t$.each(dataDetail, function (index, dataInner) {\r\n\t\t\t\t\t\t\t// 遍历标题行\r\n\t\t\t\t\t\t\tsingleListElement.find('.title').each(function () {\r\n\t\t\t\t\t\t\t\ttrHtml += \"\";\r\n\r\n\t\t\t\t\t\t\t\tjQuery(this).find('th').each(function () {\r\n\t\t\t\t\t\t\t\t\tvar modalName = jQuery(this).attr('modalName');\r\n\t\t\t\t\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\t\t\t\t\tvar colspan = jQuery(this).attr('colspan');\r\n\t\t\t\t\t\t\t\t\tvar dataName = dataInner[modalName] || \"\";\r\n\t\t\t\t\t\t\t\t\tif (rowNum > 1) {\r\n\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\tif (modalName == \"conCode\" && dataInner.hasContract) {\r\n\t\t\t\t\t\t\t\t\t\t\ttrHtml += '<a class=\"f-a-line\" href=\"javascript:void(0)\" onclick=\"creditInfoShow(this)\" >' + dataName + '';\r\n\t\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\t\tif (colspan > 1) {\r\n\t\t\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\ttrHtml += \"\";\r\n\t\t\t\t\t\t\t\tsingleListElement.append(trHtml);\r\n\t\t\t\t\t\t\t\ttrHtml = '';\r\n\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t}\r\n\r\n\t\t\t\t});\r\n\t\t\t\tif (modalData.modal.find('div.m-form-wrap[fillData=\"false\"]')) {\r\n\t\t\t\t\tmodalData.modal.find('div.m-form-wrap').attr(\"fillData\", \"true\");\r\n\t\t\t\t}\r\n\t\t\t}\r\n\r\n\t\t});\r\n\r\n\t\tif (popBizNumber == 0) {\r\n\t\t\tmodalData.modal.remove();\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\r\n\t\t// jQuery(modalData.modal).closest('div');\r\n\t\tlayer.open({\r\n\t\t\ttype: 1,\r\n\t\t\ttitle: '',\r\n\t\t\t// skin: 'layui-layer-rim', //样式类名\r\n\t\t\tcloseBtn: 1,\r\n\t\t\t// scrollbar: false,\r\n\t\t\tarea: [modalData.width, '460px'],\r\n\t\t\tshadeClose: true, //点击遮罩关闭\r\n\t\t\tcontent: jQuery(modalData.modal),\r\n\t\t\tend: function () {\r\n\t\t\t\tmodalData.modal.remove();\r\n\r\n\t\t\t}\r\n\t\t});\r\n\t}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"";
String[] strs = fileName.split(",");
for (int i = 0; i < strs.length; i++) {
System.out.println(strs[i].toString());
}
}
@Test
public void shijianchuoTest1() throws Exception {
String fileName = "\r\n\r\n\r\n\t<meta name=\"robots\" content=\"noindex,nofollow\"/>\r\n\t<meta charset=\"utf-8\">\r\n\t<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n\t<link rel=\"shortcut icon\" href=\"favicon.png\">\r\n\t
\r\n\t\t查询机构:海通恒信国际融资租赁股份有限公司\r\n\t\r\n\r\n\t<div class=\"f-floatright f-txtleft\">\r\n\t\t报告时间:2022-10-18T16:44:57
\r\n\t\t查询原因:贷前(保前)审查\r\n\t\r\n\r\n\r\n\r\n\r\n<div class=\"m-repbody\">\r\n\t<div class=\"t1\">身份标识\r\n\r\n\t<table class=\"g-tab-bor\">\r\n\t\t\r\n\t\t\t<th style=\"width: 30%;\">企业名称\r\n\t\t\t<td class=\"f-txtleft \">杭州卓越绣品有限公司\r\n\t\t\r\n\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">中征码\r\n\t\t\t\t<td class=\"f-txtleft \">3301090012210304\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">统一社会信用代码\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">组织机构代码\r\n\t\t\t\t<td class=\"f-txtleft \">MA2B0PFR5\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">纳税人识别号(国税)\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t<th style=\"width: 30%;\">纳税人识别号(地税)\r\n\t\t\t\t<td class=\"f-txtleft \">91330109MA2B0PFR5U\r\n\t\t\t\r\n\t\t\t\r\n\r\n\t\r\n\r\n\r\n\t<div class=\"m-repbody firstPage\">\r\n\t\t\r\n\t\t\r\n<div class=\"t1\">基本信息\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">基本概况信息\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">经济类型\r\n\t\t<td class=\"g-w-4 \">其他\r\n\t\t<th class=\"g-w-4\">组织机构类型\r\n\t\t<td class=\"g-w-4 \">企业\r\n\t\r\n\t\r\n\t\t企业规模\r\n\t\t<td class=\"\">微型企业\r\n\t\t所属行业\r\n\t\t<td class=\"\">窗帘、布艺类产品制造\r\n\t\r\n\t\r\n\t\t成立年份\r\n\t\t<td class=\"\">2018\r\n\t\t登记证书有效截止日期\r\n\t\t<td class=\"\">长期\r\n\t\r\n\t\r\n\t\t登记地址\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">浙江省杭州市萧山区衙前镇凤凰村\r\n\t\r\n\t\r\n\t\t办公/经营地址\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">浙江省杭州市萧山区衙前镇凤凰村\r\n\t\r\n\t\r\n\t\t存续状态\r\n\t\t<td class=\"\"\r\n\t\t\tcolspan=\"3\">正常营业\r\n\t\r\n\r\n\t\t<ul class=\"u-msg-nonumlist\">\r\n\t\t\t\t\t\r\n\t\t\r\n\t\t\t\r\n<div class=\"g-tt-h3 f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">注册资本及主要出资人信息<span class=\"f-floatright tn\">注册资本折人民币合计200万元\r\n\r\n\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-5\">类型\r\n\t\t<th class=\"g-w-5\">出资方\r\n\t\t<th class=\"g-w-5\">身份标识类型\r\n\t\t<th class=\"g-w-5\">身份标识号码\r\n\t\t<th class=\"g-w-5\">出资比例\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t--\r\n\t\t\t\t\t\t\t--\r\n\t\t\t\t\t\t--\r\n\t\t\t--\r\n\t\t\t--\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t<td colspan=\"5\" class=\"f-txtright\">\r\n\t\t\t更新日期:2018-03-08\r\n\t\r\n\r\n\t\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">主要组成人员信息\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">职位\r\n\t\t<th class=\"g-w-4\">姓名\r\n\t\t<th class=\"g-w-4\">证件类型\r\n\t\t<th class=\"g-w-4\">证件号码\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t法定代表人/非法人组织负责人\r\n\t\t\t\t\t\t\t<a class=\"f-a-line\" onclick=\"popReportUrl('../redirectcreditreport/getReport.action?IDType=1&certTypeID=1014691&certCode=450325199006041312&certName=王明林')\"\r\n\t\t\t\t\t href=\"javascript:void(0);\">王明林\r\n\t\t\t\t\t\t身份证\r\n\t\t\t450325199006041312\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t<td colspan=\"4\" class=\"f-txtright\">\r\n\t\t\t更新日期:2021-11-05\r\n\t\r\n\r\n\t\r\n\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">实际控制人\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th class=\"g-w-4\">名称\r\n\t\t<th class=\"g-w-4\">身份标识类型\r\n\t\t<th class=\"g-w-4\">身份标识号码\r\n\t\t<th class=\"g-w-4\">更新日期\r\n\t\r\n\t\t\t<tbody class=\"\">\r\n\t\t\r\n\t\t\t\t\t\t\t<a class=\"f-a-line g-w-4\" onclick=\"popReportUrl('../redirectcreditreport/getReport.action?IDType=1&certTypeID=1014691&certCode=450325199006041312&certName=王明林')\"\r\n\t\t\t\t\t href=\"javascript:void(0);\">王明林\r\n\t\t\t\t\t\t<td class=\"g-w-4\">身份证\r\n\t\t\t<td class=\"g-w-4\">450325199006041312\r\n\t\t\t<td class=\"g-w-4\">2021-11-05\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n\t\r\n<div class=\"m-repbody\">\r\n\t<div class=\"t1\">信息概要\r\n\t\r\n\t<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th class=\"g-w-4\">首次有信贷交易的年份\r\n\t\t<th class=\"g-w-4\">发生信贷交易的机构数\r\n\t\t<th class=\"g-w-4\">当前有未结清信贷
交易的机构数\r\n\t\t<th class=\"g-w-4\">首次有相关还款
责任的年份\r\n\t\r\n\t\r\n\t\t2019\r\n\t\t2\r\n\t\t0\r\n\t\t--\r\n\t\r\n\r\n\r\n<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th colspan=\"2\" class=\"g-w-4\">借贷交易\r\n\t\t<th colspan=\"2\" class=\"f-txt-nowrap g-w-4\">担保交易\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\">余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\">余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t\r\n\t\t<th class=\"f-linheight f-txtleft\">其中:被追偿余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-linheight f-txtleft\">其中:关注类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\"> 关注类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\"> 不良类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\r\n\t\r\n\t\t<th class=\"f-txtleft\"> 不良类余额\r\n\t\t<td class=\"f-txtright\">0\r\n\t\t<th class=\"f-txtleft\"> \r\n\t\t<td class=\"f-txtright\"> \r\n\t\r\n\r\n\r\n<table class=\"g-tab-bor\">\r\n\t\r\n\t\t<th class=\"g-w-5\">非信贷交易账户数\r\n\t\t<th class=\"g-w-5\">欠税记录条数\r\n\t\t<th class=\"g-w-5\">民事判决记录条数\r\n\t\t<th class=\"f-txt-nowrap g-w-5\">强制执行记录条数\r\n\t\t<th class=\"g-w-5\">行政处罚记录条数\r\n\t\r\n\t\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\t0\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">已结清信贷信息概要\r\n\t\t\t<table class=\"g-tab-bor\">\r\n\t\t\r\n\t\t\t<td style=\"width:15%\"> \r\n\t\t\t<th style=\"width:20%\">正常类账户数\r\n\t\t\t<th style=\"width:20%\">关注类账户数\r\n\t\t\t<th style=\"width:20%\">不良类账户数\r\n\t\t\t<th style=\"width:20%\">合计\r\n\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t中长期借款\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t短期借款\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t合计\r\n\t\t\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n<div class=\"g-tt-h3 f-tleft f-mgtop\"><img src=\"../resources/product/e/images/146.gif\">负债历史\r\n<table class=\"g-tab-bor f-tab-nomargin\">\r\n\t\r\n\t\t<th rowspan=\"2\" style=\"width:10%\">\r\n\t\t<th colspan=\"2\" style=\"width:18%\">全部负债\r\n\t\t<th colspan=\"2\" style=\"width:18%\">关注类负债\r\n\t\t<th colspan=\"2\" style=\"width:18%\">不良类负债\r\n\t\t<th colspan=\"4\" style=\"width:36%\">逾期类负债\r\n\t\r\n\t\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">账户数\r\n\t\t<th style=\"width:9%\">余额\r\n\t\t<th style=\"width:9%\">逾期
账户数\r\n\t\t<th style=\"width:9%\">逾期总额\r\n\t\t<th style=\"width:9%\">本金逾期
账户数\r\n\t\t<th style=\"width:9%\">逾期本金\r\n\t\r\n\t\t\t\r\n\t\t\t2022-06\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2022-03\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-12\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-09\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t14.67\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-06\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t28.99\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2021-03\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t38.35\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-12\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t52.10\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-09\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t84.73\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-06\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t93.50\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2020-03\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t97.83\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2019-12\r\n\t\t\t\t\t\t\t2\r\n\t\t\t\t\t\t\t110.62\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\t\t\r\n\t\t\t2019-09\r\n\t\t\t\t\t\t\t1\r\n\t\t\t\t\t\t\t103.91\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\t\t0\r\n\t\t\t\t\t\r\n\t\r\n\r\n\r\n\r\n\t<div class=\"firstPage\">\r\n\t\t\r\n\t\t<div class=\"m-repbody\">\r\n\t<div class=\"t1\">报告说明\r\n\t
\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">1.本报告由中国人民银行征信中心出具,依据截止报告时间征信系统记录的信息生成。除征信中心标注外,信息均由相关数据提供机构和信息主体提供,征信中心不保证其真实性和准确性,但承诺在信息汇总、加工、整合的全过程中保持客观、中立的地位。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">2.本报告所展示的基本信息来自征信系统对不同数据来源提供的同一个信息主体基本信息进行整合后的结果。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">3.本报告中信贷交易包括借贷交易和担保交易。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">4.本报告中借贷交易包括各种形式的贷款,也包括以各种其他名义融资但实质上是借贷的行为,即融资方负有明确还款责任的交易。常见的交易形式包括:贷款、贸易融资、票据贴现、保理、透支、融资租赁、回购、垫款、黄金证券借贷、公司信用债等。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">5.本报告中担保交易指第三人和债权人约定,当债务人不履行债务时,第三人按约定履行债务的行为。包括名义上没有担保合同约定但当债务人违约时、第三人实质上要代偿的行为。常见的交易形式包括:银行承兑汇票、信用证、银行保函、融资担保公司提供的担保服务,保险公司提供的信用保证保险服务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">6.本报告中被追偿业务是指剩余本息处于催收状态(即债权人要求债务人尽快归还全部借款)的借贷交易。常见的产品种类包括:由资产管理公司处置的债务、垫款(含担保代偿)。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">7.本报告中的短期借款、中长期借款是指借贷交易中除被追偿业务、循环透支、贴现之外的业务,按照 “借款期限分类”划分,分别对应其中的短期、中期和长期。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">8.本报告中借贷交易的正常类是指除被追偿业务之外,五级分类为“正常”或者五级分类为“未分类”且逾期天数为0的业务;关注类是指除被追偿业务之外,五级分类为“关注”或者五级分类为“未分类”且逾期0至90天的业务;不良类是指除被追偿业务之外,五级分类为“次级”、“可疑”、“损失”、“违约”或者五级分类为“未分类”且逾期90天以上的业务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">9.本报告中担保交易的正常类、关注类、不良类分别对应五级分类为正常、关注和后三类的业务。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">10.本报告中信息概要部分中的负债历史信息,其中负债是指由信贷交易所产生的债务;逾期总额、逾期本金是指除被追偿业务之外的借贷交易的逾期总额(含欠息)合计及逾期本金合计。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">11.本报告仅展示信息主体一定期限范围内的已结清信贷信息、非信贷信息、公共信息。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">12.如无特别说明,本报告中的金额类数据项单位均为万元。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">13.如无特别说明,本报告中的金额类汇总数据项均为人民币计价。外币折人民币的计算依据国家外汇管理局当月公布的各种货币对美元折算率表。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">14.如信息记录斜体展示,则说明信息主体对此条记录存在异议。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">15.数据提供机构说明是报数机构对报告中的信息记录或对信息主体所作的补充说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">16.征信中心说明是征信中心对报告中的信息记录或对信息主体所作的说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">17.信息主体声明是信息主体对报数机构提供的信息记录所作的简要说明。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\t<table border=\"0\" width=\"100%\">\r\n\t\t\t\r\n\t\t\t\t<td style=\"vertical-align: top;\" width=\"100%\">18.本报告仅供金融(授信)机构按照与信息主体的约定使用,请金融机构妥善保管,不得提供给信息主体和任何第三人。因保管使用不当而引起纠纷的,征信中心不承担相关责任。\r\n\t\t\t\r\n\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\t\r\n\t\t\r\n\t
| 汇率(美元折人民币):6.89 有效期:2022-09 |
编号\r\n\t\t\t<th class=\"g-w-7\">授信机构\r\n\t\t\t<th class=\"g-w-7\">业务种类\r\n\t\t\t<th class=\"g-w-7\">开立日期\r\n\t\t\t<th class=\"g-w-7\">到期日\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">币种\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">借款金额\r\n\t\t\r\n\t\t\r\n\t\t\t<th class=\"g-w-7\">关闭日期\r\n\t\t\t<th class=\"g-w-7\">五级分类\r\n\t\t\t<th colspan=\"3\" class=\"g-w-7 g-cel-nobor\">\r\n\r\n\t\t\t\t\r\n\t\t\t\t\t<tr class=\"g-cel-nobor-ie\">\r\n\t\t\t\t\t\t<th class=\"g-w-2\">最后一次还款日期\r\n\t\t\t\t\t\t<th class=\"g-w-2 g-cel-nobor-ie\">最后一次还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t
认定日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"totOverdEnt\">逾期总额\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdPrincEnt\">逾期本金\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdueMonths\">逾期月数\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyDate\">最近一次约定
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyAmt\">最近一次
应还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyDate\">最近一次实际
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyAmt\">最近一次
实还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"rpmtType\">最近一次
还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\r\n\t\t\t<table class=\"g-subtab-bor\" listname=\"transactions\">\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t\t<th colspan=\"5\">特定交易提示\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transType\">交易类型\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"tranDate\">交易日期\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transAmountEnt\">交易金额\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"changeMonthNum\">到期日期变更月数\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"detailInfo\">交易明细信息\r\n\t\t\t\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\r\n\r\n\t\t\r\n\t\t<table class=\"g-tab-nobor\">\r\n\t\r\n\t\t<th class=\"tnt f-tleft f-mgtop\"><img\r\n\t\t\t\tsrc=\"../resources/product/e/images/hot_red_folder.gif\">短期借款\r\n\t\t\r\n\t\t<th class=\"f-tright\">共1笔\r\n\t\r\n\r\n
编号\r\n\t\t\t<th class=\"g-w-7\">授信机构\r\n\t\t\t<th class=\"g-w-7\">业务种类\r\n\t\t\t<th class=\"g-w-7\">开立日期\r\n\t\t\t<th class=\"g-w-7\">到期日\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">币种\r\n\t\t\t<th class=\"f-txt-nowrap g-w-7\">借款金额\r\n\t\t\r\n\t\t\r\n\t\t\t<th class=\"g-w-7\">关闭日期\r\n\t\t\t<th class=\"g-w-7\">五级分类\r\n\t\t\t<th colspan=\"3\" class=\"g-w-7 g-cel-nobor\">\r\n\r\n\t\t\t\t\r\n\t\t\t\t\t<tr class=\"g-cel-nobor-ie\">\r\n\t\t\t\t\t\t<th class=\"g-w-2\">最后一次还款日期\r\n\t\t\t\t\t\t<th class=\"g-w-2 g-cel-nobor-ie\">最后一次还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t
认定日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"totOverdEnt\">逾期总额\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdPrincEnt\">逾期本金\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"overdueMonths\">逾期月数\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyDate\">最近一次约定
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latAgrrRpyAmt\">最近一次
应还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyDate\">最近一次实际
还款日期\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"latRpyAmt\">最近一次
实还总额\r\n\t\t\t\t\t\r\n\t\t\t\t\t<th class=\"g-w-7\" modalName=\"rpmtType\">最近一次
还款形式\r\n\t\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\r\n\t\t\t<table class=\"g-subtab-bor\" listname=\"transactions\">\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t\t<th colspan=\"5\">特定交易提示\r\n\t\t\t\t\r\n\t\t\t\t<tr class=\"title\">\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transType\">交易类型\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"tranDate\">交易日期\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"transAmountEnt\">交易金额\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"changeMonthNum\">到期日期变更月数\r\n\t\t\t\t\t<th class=\"g-w-5\" modalName=\"detailInfo\">交易明细信息\r\n\t\t\t\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\r\n\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t<div id=\"button\">\r\n\t\t<button onclick=\"more()\">查看明细页面\r\n\t\r\n\r\n\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\t/展示和隐藏内容/\r\n\tvar k = 50+1;\r\n\t$().ready(function () {\r\n\t\t$(\"table.creditDetail\").find(\">tbody:lt(\" + k + \")\").show();\r\n\r\n\t\t//屏蔽复制,粘贴,剪切\r\n\t\t//var bodyMains = document.getElementById('top' );\r\n\t\t//禁止复制\r\n\t\tdocument.oncopy = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止粘贴\r\n\t\tdocument.onpaste = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止剪切\r\n\t\tdocument.oncut = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止右键菜单\r\n\t\tdocument.oncontextmenu = function () {\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\t//禁止文本选择\r\n\t\tdocument.onselectstart = function () {\r\n\t\t\treturn false;\r\n\t\t};\r\n\t});\r\n\r\n\t/合同跳转/\r\n\tfunction creditInfoShow(tmp) {\r\n\t\tvar m = $.trim($(tmp).text());\r\n\t\tlayer.closeAll();\r\n\t\tvar a = jQuery('a[id=\"UnClearedCreditInfoBankUnitVOs\"]');\r\n\t\tvar tbodys = a.parent(\"div\").parent(\"div\").children(\"table\").children(\"tbody:gt(\" + (k - 1) + \")\");\r\n\t\tif (a.attr(\"displayStatus\") == \"show\") {\r\n\t\t\ta.html(\"- 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"hide\");\r\n\t\t\ttbodys.show();\r\n\t\t}\r\n\t\tvar whref = window.location.href;\r\n\t\tif (whref.indexOf(\"#\") > -1) {\r\n\t\t\twhref = whref.substr(0, whref.indexOf(\"#\"));\r\n\t\t}\r\n\r\n\t\twindow.location.href = whref + \"#\" + m;\r\n\t};\r\n\r\n\tfunction showHideTable(aId) {\r\n\t\tvar a = $(\"#\" + aId);\r\n\t\tvar tbodys = a.parent(\"div\").parent(\"div\").children(\"table\").children(\"tbody:gt(\" + (k - 1) + \")\");\r\n\t\tif (a.attr(\"displayStatus\") == \"show\") {\r\n\t\t\ta.html(\"- 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"hide\");\r\n\t\t\ttbodys.show();\r\n\t\t} else {\r\n\t\t\ta.html(\"+ 查看更多...\")\r\n\t\t\ta.attr(\"displayStatus\", \"show\");\r\n\t\t\ttbodys.hide();\r\n\t\t}\r\n\t}\r\n\r\n\t/* 一级展示和二级展示切换/\r\n\tfunction more() {\r\n\r\n\t\t$(\"div.secondPage\").show();\r\n\t\t$(\"div.firstPage\").hide();\r\n\t\t$(\"#button\").hide();\r\n\t\twindow.location.href = window.location.href + \"#top\";\r\n\r\n //用来修正嵌套的表格由于外单元高度过高导致内部的表格不能自动跟随100%高度的问题\r\n resetCelHeight();// 方法在静态资源的report.js里\r\n\t};\r\n\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\t//弹窗口按钮\r\n\tfunction popProvidentPayment(_this) {\r\n\t\t//获取模型和数据\r\n\t\tvar filterIdIn = jQuery(_this).attr('filterId').split(\" \");\r\n\t\tvar idToJudgeData = jQuery(_this).attr('idToJudgeData');\r\n\t\tvar modalElement = $('div.' + idToJudgeData).length == 0 ? '' : $('div.' + idToJudgeData);\r\n\t\tif (modalElement == '') {\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\t\tvar modalData = $.extend(true, {}, modalElement.data());\r\n\t\tmodalData.data = window[modalData.data];\r\n\t\tmodalData.modal = modalElement.clone();\r\n\t\tmodalData.filterName = modalData.filterName.split(\" \");\r\n\t\t$(document.body).append(modalData.modal);\r\n\t\tsecModalDialogForProvidentPayment(modalData, filterIdIn);\r\n\t};\r\n\r\n\r\n\t//弹出\r\n\tfunction secModalDialogForProvidentPayment(modalData, filterIdIn) {\r\n\t\t// 遍历数据集\r\n\t\tjQuery.each(modalData.data, function (index, data) {\r\n\t\t\tvar trHtml = \"\";\r\n\t\t\tvar flag = true;\r\n\t\t\t// 过滤条件\r\n\t\t\tjQuery.each(modalData.filterName, function (index, val) {\r\n\t\t\t\tif (data[modalData.filterName[index]] != filterIdIn[index]) {\r\n\t\t\t\t\tflag = false;\r\n\t\t\t\t}\r\n\t\t\t});\r\n\r\n\t\t\tif (flag) {\r\n\t\t\t\t// 遍历标题行\r\n\t\t\t\tjQuery(modalData.modal).find('.title').each(function () {\r\n\t\t\t\t\ttrHtml += \"\";\r\n\r\n\t\t\t\t\tjQuery(this).find('th').each(function () {\r\n\t\t\t\t\t\tvar modalName = jQuery(this).attr('modalName');\r\n\t\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\t\tvar colNum = jQuery(this).attr('colspan');\r\n\t\t\t\t\t\tvar dataName = data[modalName] || \"\";\r\n\r\n\t\t\t\t\t\tif (rowNum > 1 && colNum > 1) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else if (rowNum > 1 && !(colNum > 1)) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else if (!(rowNum > 1) && colNum > 1) {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t});\r\n\t\t\t\t\ttrHtml += \"\";\r\n\t\t\t\t\tjQuery(modalData.modal).find('table').last().append(trHtml);\r\n\t\t\t\t\ttrHtml = '';\r\n\t\t\t\t});\r\n\t\t\t}\r\n\r\n\t\t});\r\n\r\n\t\tlayer.open({\r\n\t\t\ttype: 1,\r\n\t\t\ttitle: '',\r\n\t\t\t// skin: 'layui-layer-rim', //样式类名\r\n\t\t\tcloseBtn: 1,\r\n\t\t\t// scrollbar: false,\r\n\t\t\tarea: [modalData.width, '460px'],\r\n\t\t\tshadeClose: true, //点击遮罩关闭\r\n\t\t\tcontent: jQuery(modalData.modal),\r\n\t\t\tend: function () {\r\n\t\t\t\tmodalData.modal.remove();\r\n\t\t\t}\r\n\t\t});\r\n\t}\r\n\r\n\r\n\r\n<script type=\"text/javascript\">\r\n\tfunction openProductModal(_this) {\r\n\r\n\t\tvar filterIdIn = jQuery(_this).attr('filterId').split(\" \");\r\n\t\t//获取模型和数据\r\n\t\tvar idToJudgeData = jQuery(_this).attr('idToJudgeData');\r\n\t\tvar modalElement = $('div.' + idToJudgeData).length == 0 ? '' : $('div.' + idToJudgeData);\r\n\t\tif (modalElement == '') {\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\t\tvar modalData = $.extend(true, {}, modalElement.data());\r\n\t\tmodalData.data = window[modalData.data];\r\n\t\tmodalData.modal = modalElement.clone();\r\n\r\n\t\tmodalData.filterName = modalData.filterName.split(\" \");\r\n\t\t$(document.body).append(modalData.modal);\r\n\t\tsecModalDialog(modalData, filterIdIn);\r\n\r\n\t}\r\n\r\n\t//最外层为单条或者多条情况统计\r\n\r\n\tfunction secModalDialog(modalData, filterIdIn) {\r\n\t\tvar notDataModal = modalData.modal.clone();\r\n\t\tvar popBizNumber = 0;\r\n\t\t// 遍历数据集\r\n\t\tjQuery.each(modalData.data, function (index, data) {\r\n\r\n\t\t\tvar flag = true;\r\n\t\t\t// 过滤条件\r\n\t\t\tjQuery.each(modalData.filterName, function (index, val) {\r\n\t\t\t\tif (data[modalData.filterName[index]] != filterIdIn[index]) {\r\n\t\t\t\t\tflag = false;\r\n\r\n\t\t\t\t}\r\n\t\t\t});\r\n\r\n\t\t\tif (flag) {\r\n\t\t\t\tpopBizNumber += 1;\r\n\t\t\t\tif (popBizNumber > 1) {\r\n\t\t\t\t\tmodalData.modal = modalData.modal.append(notDataModal.find('div.m-form-wrap').clone());\r\n\t\t\t\t}\r\n\t\t\t\t//加入编号\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('span[modalName = \"itemNumber\"]').html(popBizNumber);\r\n\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('span[modalName]').each(function () {\r\n\t\t\t\t\tvar spanModalName = $(this).attr('modalName');\r\n\t\t\t\t\tvar spanVal = data[spanModalName];\r\n\t\t\t\t\t$(this).html(spanVal);\r\n\t\t\t\t});\r\n\r\n\r\n\t\t\t\tvar trHtml = \"\";\r\n\t\t\t\ttrHtml += \"\";\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[entityname]').find('th[modalName]').each(function () {\r\n\t\t\t\t\tvar modalName = $(this).attr(\"modalName\");\r\n\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\tvar val = data[modalName] || \"\";\r\n\t\t\t\t\tif (rowNum > 1) {\r\n\t\t\t\t\t\ttrHtml += \"\" + val + \"\";\r\n\t\t\t\t\t} else {\r\n\t\t\t\t\t\tif (modalName == \"conCode\" && data.hasContract) {\r\n\t\t\t\t\t\t\ttrHtml += '<a class=\"f-a-line\" href=\"javascript:void(0)\" onclick=\"creditInfoShow(this)\" >' + val + '';\r\n\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\ttrHtml += \"\" + val + \"\";\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t}\r\n\t\t\t\t});\r\n\t\t\t\ttrHtml += \"\";\r\n\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[entityname]').append(trHtml);\r\n\t\t\t\ttrHtml = '';\r\n\r\n\t\t\t\tvar dataDetail = '';\r\n\t\t\t\tvar listElement = jQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[listname]');\r\n\t\t\t\tif (listElement.length == 0) {\r\n\t\t\t\t\treturn;\r\n\t\t\t\t}\r\n\r\n\t\t\t\tlistElement.each(function (index, singleListElement) {\r\n\t\t\t\t\tvar singleListElement = $(singleListElement);\r\n\t\t\t\t\tvar listName = singleListElement.attr('listname')\r\n\t\t\t\t\tdataDetail = data[listName];\r\n\t\t\t\t\t/ } /\r\n\t\t\t\t\tif (dataDetail == undefined || dataDetail.length == 0) {\r\n\t\t\t\t\t\t//定制化处理,如果是贴现(包含已结清以及未结清)弹窗,将标题隐藏\r\n\t\t\t\t\t\tif (jQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[themename=\"discount\"]').length > 0 && listName == 'details') {\r\n\t\t\t\t\t\t\tjQuery(modalData.modal).find('div[fillData=\"false\"]').find('table[themename=\"discount\"]').hide();\r\n\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t\tsingleListElement.remove();\r\n\t\t\t\t\t}\r\n\t\t\t\t\tif (dataDetail instanceof Array && dataDetail.length > 0) {\r\n\t\t\t\t\t\t$.each(dataDetail, function (index, dataInner) {\r\n\t\t\t\t\t\t\t// 遍历标题行\r\n\t\t\t\t\t\t\tsingleListElement.find('.title').each(function () {\r\n\t\t\t\t\t\t\t\ttrHtml += \"\";\r\n\r\n\t\t\t\t\t\t\t\tjQuery(this).find('th').each(function () {\r\n\t\t\t\t\t\t\t\t\tvar modalName = jQuery(this).attr('modalName');\r\n\t\t\t\t\t\t\t\t\tvar rowNum = jQuery(this).attr('rowspan');\r\n\t\t\t\t\t\t\t\t\tvar colspan = jQuery(this).attr('colspan');\r\n\t\t\t\t\t\t\t\t\tvar dataName = dataInner[modalName] || \"\";\r\n\t\t\t\t\t\t\t\t\tif (rowNum > 1) {\r\n\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\tif (modalName == \"conCode\" && dataInner.hasContract) {\r\n\t\t\t\t\t\t\t\t\t\t\ttrHtml += '<a class=\"f-a-line\" href=\"javascript:void(0)\" onclick=\"creditInfoShow(this)\" >' + dataName + '';\r\n\t\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\t\tif (colspan > 1) {\r\n\t\t\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\t\t\t\ttrHtml += \"\" + dataName + \"\";\r\n\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\ttrHtml += \"\";\r\n\t\t\t\t\t\t\t\tsingleListElement.append(trHtml);\r\n\t\t\t\t\t\t\t\ttrHtml = '';\r\n\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t}\r\n\r\n\t\t\t\t});\r\n\t\t\t\tif (modalData.modal.find('div.m-form-wrap[fillData=\"false\"]')) {\r\n\t\t\t\t\tmodalData.modal.find('div.m-form-wrap').attr(\"fillData\", \"true\");\r\n\t\t\t\t}\r\n\t\t\t}\r\n\r\n\t\t});\r\n\r\n\t\tif (popBizNumber == 0) {\r\n\t\t\tmodalData.modal.remove();\r\n\t\t\talert(\"没有主业务对应的弹出数据\")\r\n\t\t\treturn;\r\n\t\t}\r\n\r\n\t\t// jQuery(modalData.modal).closest('div');\r\n\t\tlayer.open({\r\n\t\t\ttype: 1,\r\n\t\t\ttitle: '',\r\n\t\t\t// skin: 'layui-layer-rim', //样式类名\r\n\t\t\tcloseBtn: 1,\r\n\t\t\t// scrollbar: false,\r\n\t\t\tarea: [modalData.width, '460px'],\r\n\t\t\tshadeClose: true, //点击遮罩关闭\r\n\t\t\tcontent: jQuery(modalData.modal),\r\n\t\t\tend: function () {\r\n\t\t\t\tmodalData.modal.remove();\r\n\r\n\t\t\t}\r\n\t\t});\r\n\t}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"";
// 这里需要指定读用哪个class去读,然后读取第一个sheet 同步读取会自动finish
if (fileName.length() > 3000) {
List<VariablePlatformController.DemoDataGeRen> list = EasyExcel.read(fileName).head(VariablePlatformController.DemoDataGeRen.class).sheet().doReadSync();
List<List<VariablePlatformController.DemoDataGeRen>> groupList = ListUtil.split(list, 1000);
List
groupList.forEach(idCardList -> {
StringBuilder stringBuilder = new StringBuilder();
idCardList.forEach(data -> stringBuilder.append("'").append(data.getIdCard()).append("',"));
stringBuilder.deleteCharAt(stringBuilder.length() - 1);
// StringBuilder sb = new StringBuilder("select t.message from T_CRS_RPT_FEEDBACK t LEFT JOIN QUERY_PERSONAL_DETAIL q ON t.TASK_ID=q.DETAIL_ID WHERE DETAIL_CERTIFICATES_NUB in(");
StringBuilder sb = new StringBuilder("update AUTOMATIC_TASK_DETAIL set xml_content =xml_content||'xxx' where RELATION_TASK_ID='52a526e211c24edaa420c1614390f7fb'");
sb.append(stringBuilder);
sb.append(") AND t.message is not null");
idcList.add(sb.toString());
});
} else if (fileName.length() < 1000) {
List<VariablePlatformController.DemoDataGeRen> list = EasyExcel.read(fileName).head(VariablePlatformController.DemoDataGeRen.class).sheet().doReadSync();
List<List<VariablePlatformController.DemoDataGeRen>> groupList = ListUtil.split(list, 1000);
List
groupList.forEach(idCardList -> {
StringBuilder stringBuilder = new StringBuilder();
idCardList.forEach(data -> stringBuilder.append("'").append(data.getIdCard()).append("',"));
stringBuilder.deleteCharAt(stringBuilder.length() - 1);
// StringBuilder sb = new StringBuilder("select t.message from T_CRS_RPT_FEEDBACK t LEFT JOIN QUERY_PERSONAL_DETAIL q ON t.TASK_ID=q.DETAIL_ID WHERE DETAIL_CERTIFICATES_NUB in(");
StringBuilder sb = new StringBuilder("update AUTOMATIC_TASK_DETAIL set xml_content =xml_content||'xxx' where RELATION_TASK_ID='52a526e211c24edaa420c1614390f7fb'");
sb.append(stringBuilder);
sb.append(") AND t.message is not null");
idcList.add(sb.toString());
});
}
}
@Test
public void testGeneSql() {
try {
String ss = getFileContentTwo("D:\test\13json.txt");
JSONObject jo = JSONObject.parseObject(ss);
JSONArray ja = jo.getJSONArray("RECORDS");
System.out.println("JSONArray size = " + ja.size());
for (int i = 0; i < ja.size(); i++) {
String content = ja.getJSONObject(i).getString("XML_CONTENT");
System.out.println("i=" + i + ",size = " + content.length());
String taskId = ja.getJSONObject(i).getString("RELATION_TASK_ID");
System.out.println("taskId = " + taskId);
List
String sql = buildSql(splitArray, taskId);
System.out.println(sql);
}
} catch (Exception e) {
System.out.println("error!!!!!!!!!!!");
}
}
public String getFileContentTwo(String name) throws IOException {
File file = new File(name);
// 判断文件是否存在
if (file.isFile() && file.exists()) {
// 考虑到编码格式
InputStreamReader read =
new InputStreamReader(new FileInputStream(file), StandardCharsets.UTF_8.toString());
BufferedReader bufferedReader = new BufferedReader(read);
StringBuffer stringBuffer = new StringBuffer();
String lineTxt = null;
while ((lineTxt = bufferedReader.readLine()) != null) {
// System.out.println(lineTxt);
stringBuffer.append(lineTxt);
}
read.close();
return stringBuffer.toString();
} else {
System.out.println("该文件不存在");
return "";
}
}
//public List
public String buildSql(List
StringBuilder strb = new StringBuilder();
for (int i = 0; i < splitArray.size(); i++) {
if (0 == i) {
strb.append("update AUTOMATIC_TASK_DETAIL set xml_content = '").append(splitArray.get(i)).append("where RELATION_TASK_ID='" + taskId + "';\r\n");
} else {
strb.append("update AUTOMATIC_TASK_DETAIL set xml_content = '").append(splitArray.get(i)).append("where RELATION_TASK_ID='" + taskId + "';\r\n");
}
}
return strb.toString();
}
public List
List
int length = content.length();
if (length <= 3000) {
splitArray.add(content);
} else {
int index = 0;
while (index < length) {
String subContent = content.substring(index, index + 3000);
splitArray.add(subContent);
index += 3000;
}
}
return splitArray;
}
@Test
public void shijianchuoTest() throws Exception {
// 当前时间
DateTime date = DateUtil.date();
System.out.println("long时间:" + date.getTime());
String dateSecond = String.valueOf(DateUtil.dateSecond().getTime());
log.info(dateSecond);
//当前时间 忽略毫秒
System.out.println("long时间忽略毫秒:" + dateSecond);
log.info(DigestUtil.md5Hex(dateSecond));
log.info(MD5Util.MD5(dateSecond));
//当前时间 忽略毫秒部分
Date date4 = DateUtil.dateSecond();
log.info(MD5Util.getSecondTimestamp(new Date()) + "");
Assert.assertNotNull(date4);
}
@Test
public void rsaTest() throws Exception {
RSA rsa = new RSA();
//获得私钥
rsa.getPrivateKey();
rsa.getPrivateKeyBase64();
//获得公钥
rsa.getPublicKey();
rsa.getPublicKeyBase64();
//公钥加密,私钥解密
byte[] encrypt = rsa.encrypt(StrUtil.bytes("我是一段测试aaaa", CharsetUtil.CHARSET_UTF_8), KeyType.PublicKey);
byte[] decrypt = rsa.decrypt(encrypt, KeyType.PrivateKey);
//Junit单元测试
//Assert.assertEquals("我是一段测试aaaa", StrUtil.str(decrypt, CharsetUtil.CHARSET_UTF_8));
//私钥加密,公钥解密
byte[] encrypt2 = rsa.encrypt(StrUtil.bytes("我是一段测试aaaa", CharsetUtil.CHARSET_UTF_8), KeyType.PrivateKey);
byte[] decrypt2 = rsa.decrypt(encrypt2, KeyType.PublicKey);
//Junit单元测试
Assert.assertEquals("我是一段测试aaaa", StrUtil.str(decrypt2, CharsetUtil.CHARSET_UTF_8));
}
//"RSAPublicKey":"MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC0ORne5EhpZCfDsPqevHGItOIMzynQBiirpSqP\r\nD5Xlwq9ECfan/uOhHwId37hWxSNrHkbkXctCWzmO8VsDdaf5g6jZX/N+caJ5INYfrGkbPainZUpM\r\n2jMkDRe4roXUR7PLsta6AOcJrYWrzGMBTauRHjpq2uoPIqQUa7JMvQzzbQIDAQAB","RSAPrivateKey":"MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBALQ5Gd7kSGlkJ8Ow+p68cYi04gzP\r\nKdAGKKulKo8PleXCr0QJ9qf+46EfAh3fuFbFI2seRuRdy0JbOY7xWwN1p/mDqNlf835xonkg1h+s\r\naRs9qKdlSkzaMyQNF7iuhdRHs8uy1roA5wmthavMYwFNq5EeOmra6g8ipBRrsky9DPNtAgMBAAEC\r\ngYAEEiIedxjs9daGxLxJ0kcyPPu6Ka0acM6BtLULDuFmPjPdR+hVZRwugIJ4uvFGrHn0qnYUJHY5\r\n5SZIr0pMqrSvlBXBjeVOzQT0gdhe2ptWkzoLCpEYduM4Slzg9HcIEyFJ3TkONM6LGKkgF+dyWkDe\r\nAiC5wY6mDIy3ExdR83raYQJBAOWci22yqqf95hr0gwQAqnDmOzFYGEfvT0gSNMRfBg33b2eK3hil\r\nqEammkGyi1P8cQdDCYxnjmpa1hhFuql8RYkCQQDI73ykHGQEBX/N3y9s0+qe4fcxrJ9yjq5HCeYj\r\nru013lByOGqLQpuWcpDub7035v7UYAZ3p930ZIRISb71ZKnFAkAo/c2Wg/MbkqRl44kQSd4j0bZ3\r\nlLahAQQyZa2t8RjvnWDyJ0SHOevU0SFw4SMml0bGeR1XR5WRPy5BnxE3+MuhAkAlvgY1dTe8IaRN\r\n8TwhPvT0/xDFfd09UVue8FcQIM1hru6BZeNtYQeEjOR4RPjPxU3camUMmLVyMGdAhMmfolbZAkAa\r\n59gi1XCKCGOX8PZchhjX2BmqhuCIpzlxDNMKPthyz5Hloq58i9uZD6z+I8zc7eNsT7XQFyBPcmr1\r\nEw2JDlAc"
@Test
public void rsaTest1() throws Exception {
Map<String, Object> map = RsaUtil.generateKeyPair();
JSONObject jbt = new JSONObject(map);
log.info(jbt.toJSONString());
}
@Test
public void rsaTest2() throws Exception {
String publicKey = "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC0ORne5EhpZCfDsPqevHGItOIMzynQBiirpSqP\r\nD5Xlwq9ECfan/uOhHwId37hWxSNrHkbkXctCWzmO8VsDdaf5g6jZX/N+caJ5INYfrGkbPainZUpM\r\n2jMkDRe4roXUR7PLsta6AOcJrYWrzGMBTauRHjpq2uoPIqQUa7JMvQzzbQIDAQAB";
String privateKey = "MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBALQ5Gd7kSGlkJ8Ow+p68cYi04gzP\r\nKdAGKKulKo8PleXCr0QJ9qf+46EfAh3fuFbFI2seRuRdy0JbOY7xWwN1p/mDqNlf835xonkg1h+s\r\naRs9qKdlSkzaMyQNF7iuhdRHs8uy1roA5wmthavMYwFNq5EeOmra6g8ipBRrsky9DPNtAgMBAAEC\r\ngYAEEiIedxjs9daGxLxJ0kcyPPu6Ka0acM6BtLULDuFmPjPdR+hVZRwugIJ4uvFGrHn0qnYUJHY5\r\n5SZIr0pMqrSvlBXBjeVOzQT0gdhe2ptWkzoLCpEYduM4Slzg9HcIEyFJ3TkONM6LGKkgF+dyWkDe\r\nAiC5wY6mDIy3ExdR83raYQJBAOWci22yqqf95hr0gwQAqnDmOzFYGEfvT0gSNMRfBg33b2eK3hil\r\nqEammkGyi1P8cQdDCYxnjmpa1hhFuql8RYkCQQDI73ykHGQEBX/N3y9s0+qe4fcxrJ9yjq5HCeYj\r\nru013lByOGqLQpuWcpDub7035v7UYAZ3p930ZIRISb71ZKnFAkAo/c2Wg/MbkqRl44kQSd4j0bZ3\r\nlLahAQQyZa2t8RjvnWDyJ0SHOevU0SFw4SMml0bGeR1XR5WRPy5BnxE3+MuhAkAlvgY1dTe8IaRN\r\n8TwhPvT0/xDFfd09UVue8FcQIM1hru6BZeNtYQeEjOR4RPjPxU3camUMmLVyMGdAhMmfolbZAkAa\r\n59gi1XCKCGOX8PZchhjX2BmqhuCIpzlxDNMKPthyz5Hloq58i9uZD6z+I8zc7eNsT7XQFyBPcmr1\r\nEw2JDlAc";
String encryptkey = RsaUtil.encrypt("encryptkey", publicKey);
String encryptsecrectkey = RsaUtil.encrypt("encryptsecrectkey", publicKey);
log.info(encryptkey);
log.info(encryptsecrectkey);
log.info(RsaUtil.decrypt(encryptkey, privateKey));
log.info(RsaUtil.decrypt(encryptsecrectkey, privateKey));
}
@Test
public void testTime() throws Exception {
log.info(MD5Util.getSecondTimestamp(new Date()) + "");
}
}
浙公网安备 33010602011771号