Example 6 with EvidenceOutTemplate
use of com.itrus.portal.db.EvidenceOutTemplate in project portal by ixinportal.
the class BasicInformationController method show.
/**
* 查看详情
*
* @param id
* @param uiModel
* @return
*/
@RequestMapping(value = "/{id}", produces = "text/html")
public String show(@PathVariable("id") Long id, Model uiModel) {
Date time = new Date();
// 得到方法开始的时间
log.error("---------------------------" + time);
basid = id;
int coutn = 0;
int size = 0;
int cousize = 0;
EvidenceBasicInformation basicinfor = sqlSession.selectOne("com.itrus.portal.db.EvidenceBasicInformationMapper.selectByPrimaryKey", id);
List<EvidenceMainInformation> mlist = new ArrayList<EvidenceMainInformation>();
Map<Long, EvidenceCompaniesSubmit> companiesSubmit = new HashMap<Long, EvidenceCompaniesSubmit>();
Map<Long, List<RealNameRecord>> realnameRecor = new HashMap<Long, List<RealNameRecord>>();
Map<Long, List<PersonalName>> personalName = new HashMap<Long, List<PersonalName>>();
Map<Long, EvidenceIndividual> denceid = new HashMap<Long, EvidenceIndividual>();
Map<Long, EvidenceRealName> realName = new HashMap<Long, EvidenceRealName>();
// 事件对象认证
Map<Long, EvidenceTrustedIdentity> trustedidentit = new HashMap<Long, EvidenceTrustedIdentity>();
// 事件时间认证
Map<Long, EvidenceEventTime> meventime = new HashMap<Long, EvidenceEventTime>();
// 事件行为认证
Map<Long, EvidenceEventBehavior> eventbehacior = new HashMap<Long, EvidenceEventBehavior>();
// 无主体 事件对象认证
Map<Integer, EvidenceTrustedIdentity> maintrustedidentit = new HashMap<Integer, EvidenceTrustedIdentity>();
// 无主体事件时间认证
Map<Integer, EvidenceEventTime> mainmeventime = new HashMap<Integer, EvidenceEventTime>();
// 无主体事件行为认证
Map<Integer, EvidenceEventBehavior> maineventbehacior = new HashMap<Integer, EvidenceEventBehavior>();
// 事件意愿认证
Map<Long, EvidenceEventDesire> meventdesire = new HashMap<Long, EvidenceEventDesire>();
// 事件网络地址
Map<Long, EvidenceEventNetworkAddress> networkaddress = new HashMap<Long, EvidenceEventNetworkAddress>();
// 得到主体身份信息
EvidenceSubjectIdentityExample subjectExample = new EvidenceSubjectIdentityExample();
EvidenceSubjectIdentityExample.Criteria identity = subjectExample.createCriteria();
// subjectExample.isDistinct();
identity.andBasicInformationEqualTo(basicinfor.getEvidenceSn());
List<EvidenceSubjectIdentity> subjectIdentity = sqlSession.selectList("com.itrus.portal.db.EvidenceSubjectIdentityMapper.selectByExample", subjectExample);
for (int i = 0; i < subjectIdentity.size(); i++) {
// 得到主体信息
EvidenceMainInformationExample infomationE = new EvidenceMainInformationExample();
EvidenceMainInformationExample.Criteria tionE = infomationE.createCriteria();
tionE.andIdentificationEqualTo(subjectIdentity.get(i).getMainInformation());
// infomationE.isDistinct();
if (subjectIdentity.get(i).getMainName() != null) {
tionE.andSubjectNameEqualTo(subjectIdentity.get(i).getMainName());
}
List<EvidenceMainInformation> mainInfo = sqlSession.selectList("com.itrus.portal.db.EvidenceMainInformationMapper.selectByExample", infomationE);
if (mainInfo.size() != 0) {
mlist.add(mainInfo.get(0));
}
}
for (int i = 0; i < mlist.size() - 1; i++) {
for (int j = mlist.size() - 1; j > i; j--) {
if (mlist.get(j).getIdentification().equals(mlist.get(i).getIdentification()) && mlist.get(j).getSubjectName().equals(mlist.get(i).getSubjectName())) {
mlist.remove(j);
}
}
}
log.error("主题数量**********" + mlist.size());
// 得到主题的时间
Date time1 = new Date();
Long Ltime = time1.getTime() - time.getTime();
log.error("得到主题身份的毫秒数，Ltime" + Ltime);
// 得到身份可信标识
EvidenceTrustedIdentityExample trusten = new EvidenceTrustedIdentityExample();
EvidenceTrustedIdentityExample.Criteria identityex = trusten.createCriteria();
identityex.andBasicInformationEqualTo(basicinfor.getEvidenceSn());
identityex.andEventContentIsNull();
Map<Long, EvidenceTrustedIdentity> trustedidentity = sqlSession.selectMap("com.itrus.portal.db.EvidenceTrustedIdentityMapper.selectByExample", trusten, "mainInformation");
// 得到主题的时间
Date time2 = new Date();
Long Ltime1 = time2.getTime() - time.getTime();
log.error("得到身份可信标识的毫秒数，Ltime1=" + Ltime1);
// 身份意愿map
Map<Long, EvidenceDesireIdentify> desire = new HashMap<Long, EvidenceDesireIdentify>();
// 证据基本信息map
Map<Long, EvidenceBasicInformation> basi = new HashMap<Long, EvidenceBasicInformation>();
EvidenceRealName erealname = new EvidenceRealName();
// 循环主题信息
for (EvidenceMainInformation m : mlist) {
// 判断可信身份标识是否为空
if (/*trustedidentity!=null && trustedidentity.size()!=0&&*/
trustedidentity.get(m.getId()) != null && trustedidentity.get(m.getId()).getEvidenceSn() != null) {
// 得到可信身份标识关联的身份证据编号
String evidenceSn = trustedidentity.get(m.getId()).getEvidenceSn().toString();
if (StringUtils.isNotEmpty(evidenceSn)) {
EvidenceBasicInformationExample basicinforE = new EvidenceBasicInformationExample();
EvidenceBasicInformationExample.Criteria critbasic = basicinforE.createCriteria();
critbasic.andEvidenceSnEqualTo(evidenceSn);
EvidenceBasicInformation basicinfor1 = sqlSession.selectOne("com.itrus.portal.db.EvidenceBasicInformationMapper.selectByExample", basicinforE);
// 得到身份意愿信息
EvidenceDesireIdentifyExample desireIdentify = new EvidenceDesireIdentifyExample();
EvidenceDesireIdentifyExample.Criteria desireExample = desireIdentify.createCriteria();
desireExample.andEvidenceSnEqualTo(basicinfor1.getEvidenceSn());
EvidenceDesireIdentify desire1 = sqlSession.selectOne("com.itrus.portal.db.EvidenceDesireIdentifyMapper.selectByExample", desireIdentify);
desire.put(m.getId(), desire1);
// 将身份认证信息放入map
basi.put(m.getId(), basicinfor1);
// 得到实名认证信息
EvidenceRealNameExample realnameE = new EvidenceRealNameExample();
EvidenceRealNameExample.Criteria realnameEx = realnameE.createCriteria();
realnameEx.andMainInformationEqualTo(m.getSubjectName() + ";" + m.getIdentification());
// realnameEx.andBasicInformationEqualTo(basicinfor1.getId());
realnameEx.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
erealname = sqlSession.selectOne("com.itrus.portal.db.EvidenceRealNameMapper.selectByExample", realnameE);
realName.put(m.getId(), erealname);
}
if (erealname != null) {
if ("2".equals(erealname.getEventVerifierType()) || "3".equals(erealname.getEventVerifierType())) {
if ("1".equals(erealname.getType())) {
EvidenceCompaniesSubmitExample evidenceCompanies = new EvidenceCompaniesSubmitExample();
EvidenceCompaniesSubmitExample.Criteria submit = evidenceCompanies.createCriteria();
submit.andIdCodeEqualTo(erealname.getCompaniesSubmit());
EvidenceCompaniesSubmit companiesSubmit1 = sqlSession.selectOne("com.itrus.portal.db.EvidenceCompaniesSubmitMapper.selectByExample", evidenceCompanies);
companiesSubmit.put(m.getId(), companiesSubmit1);
} else {
// 天威
EvidenceIndividualExample evidenceIndividual = new EvidenceIndividualExample();
EvidenceIndividualExample.Criteria individual = evidenceIndividual.createCriteria();
individual.andIdCodeEqualTo(erealname.getIndividual());
EvidenceIndividual dic = sqlSession.selectOne("com.itrus.portal.db.EvidenceIndividualMapper.selectByExample", evidenceIndividual);
denceid.put(m.getId(), dic);
}
} else if ("1".equals(erealname.getEventVerifierType())) {
// 天威
if ("1".equals(erealname.getType())) {
// 获取流水号
String serialnamber = erealname.getSerialnumber();
// 将多个流水号以逗号分隔成一个数组
String[] namber = serialnamber.split(",");
// 声明一个list存储流水号
List<String> listString = new ArrayList<String>();
for (int i = 0; i < namber.length; i++) {
// 将数组中的流水号放入list中
listString.add(namber[i]);
}
// 查询实名认证信息
RealNameRecordExample realname = new RealNameRecordExample();
RealNameRecordExample.Criteria recor = realname.createCriteria();
recor.andSerialnumberIn(listString);
realname.setOrderByClause("returntime");
listReal = sqlSession.selectList("com.itrus.portal.db.RealNameRecordMapper.selectByExample", realname);
realnameRecor.put(m.getId(), listReal);
} else {
String serialnamber = erealname.getSerialnumber();
String[] namber = serialnamber.split(",");
List<String> listString = new ArrayList<String>();
for (int i = 0; i < namber.length; i++) {
listString.add(namber[i]);
// listReal.add(realnameRecor1);
}
PersonalNameExample personal = new PersonalNameExample();
PersonalNameExample.Criteria personalname = personal.createCriteria();
personalname.andSerialnumberIn(listString);
personal.setOrderByClause("returntime");
listPersonal = sqlSession.selectList("com.itrus.portal.db.PersonalNameMapper.selectByExample", personal);
personalName.put(m.getId(), listPersonal);
}
}
}
}
}
// 得到身份的时间
Date time3 = new Date();
Long Ltime2 = time3.getTime() - time.getTime();
log.error("得到身份信息的毫秒数，Ltime2=" + Ltime2);
// 事件内容
/*EvidenceEventContentExample evencontent = new EvidenceEventContentExample();
EvidenceEventContentExample.Criteria countent = evencontent.createCriteria();
//countent.andBasicInformationEqualTo(id);
countent.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
EvidenceEventContent mevencontent = sqlSession
.selectOne("com.itrus.portal.db.EvidenceEventContentMapper.selectByExample", evencontent);*/
EvidenceEventContent mevencontent = sqlSession.selectOne("com.itrus.portal.db.EvidenceEventContentMapper.selecttId", basicinfor.getEvidenceSn());
// 得到事件内容的时间
Date time4 = new Date();
Long Ltime3 = time4.getTime() - time.getTime();
log.error("得到事件内容的毫秒数，Ltime3=" + Ltime3);
if (mevencontent != null && mevencontent.getIdCode() != null) {
// 事件对象认证
EvidenceTrustedIdentityExample trustenid = new EvidenceTrustedIdentityExample();
EvidenceTrustedIdentityExample.Criteria identitye = trustenid.createCriteria();
identitye.andEventContentEqualTo(mevencontent.getIdCode());
trustedidentit = sqlSession.selectMap("com.itrus.portal.db.EvidenceTrustedIdentityMapper.selectByExample", trustenid, "mainInformation");
// 事件时间认证
EvidenceEventTimeExample eventime = new EvidenceEventTimeExample();
EvidenceEventTimeExample.Criteria eventimeEx = eventime.createCriteria();
eventimeEx.andEventContentEqualTo(mevencontent.getIdCode());
meventime = sqlSession.selectMap("com.itrus.portal.db.EvidenceEventTimeMapper.selectByExample", eventime, "mainInformation");
// 事件行为认证
EvidenceEventBehaviorExample eventbehaciorEx = new EvidenceEventBehaviorExample();
EvidenceEventBehaviorExample.Criteria eventbe = eventbehaciorEx.createCriteria();
eventbe.andEventContentEqualTo(mevencontent.getIdCode());
eventbehacior = sqlSession.selectMap("com.itrus.portal.db.EvidenceEventBehaviorMapper.selectByExample", eventbehaciorEx, "mainInformation");
// 事件意愿认证
EvidenceEventDesireExample desireEx = new EvidenceEventDesireExample();
EvidenceEventDesireExample.Criteria eventdesire = desireEx.createCriteria();
eventdesire.andEventContenteEqualTo(mevencontent.getIdCode());
meventdesire = sqlSession.selectMap("com.itrus.portal.db.EvidenceEventDesireMapper.selectByExample", desireEx, "mainInformation");
// 事件网络地址
EvidenceEventNetworkAddressExample network = new EvidenceEventNetworkAddressExample();
EvidenceEventNetworkAddressExample.Criteria address = network.createCriteria();
address.andEventContentEqualTo(mevencontent.getIdCode());
networkaddress = sqlSession.selectMap("com.itrus.portal.db.EvidenceEventNetworkAddressMapper.selectByExample", network, "mainInformation");
// 得到证据附件表，用于获取信息
EvidenceEnclosure envlosure = sqlSession.selectOne("com.itrus.portal.db.EvidenceEnclosureMapper.selectByPrimaryKey", mevencontent.getEvidenceEnclosure());
uiModel.addAttribute("enclosure", envlosure);
}
// 得到事件的时间
Date time5 = new Date();
Long Ltime4 = time5.getTime() - time.getTime();
log.error("得到事件详情的毫秒数，Ltime4=" + Ltime4);
// 得到证据附件信息，用于查询服务委托人等信息
EvidenceEnclosureExample enclou = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria sure = enclou.createCriteria();
sure.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
;
sure.andPdfTypeEqualTo("1");
List<EvidenceEnclosure> enclosure = sqlSession.selectList("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclou);
// 得到事件的时间
Date qtime = new Date();
Long qLtime = qtime.getTime() - time5.getTime();
log.error("***得到证据附件信息1的毫秒数，qLtime=" + qLtime);
EvidenceEnclosureExample enclouE = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria sureEX = enclouE.createCriteria();
sureEX.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
;
sureEX.andPdfTypeEqualTo("3");
EvidenceEnclosure enclosurepdf = sqlSession.selectOne("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclouE);
// 得到事件的时间
Date wtime = new Date();
Long wLtime = wtime.getTime() - qtime.getTime();
log.error("---得到证据附件信息2的毫秒数，wLtime=" + wLtime);
// 得到无主题信息的数量
int evencount = 0;
if (trustedidentit.size() > 0) {
evencount = trustedidentit.size();
} else if (meventime.size() > 0) {
evencount = meventime.size();
} else if (maineventbehacior.size() > 0) {
evencount = maineventbehacior.size();
}
Map<Integer, Integer> mapcoune = new HashMap<Integer, Integer>();
// 用于得到无主题信息和数量
for (int g = 0; g < evencount; g++) {
int intsize = 0;
// 得到无主题信息的key
long z = g - evencount;
String s = String.valueOf(z);
// 将long类型转换为int类型，作为map的key进行重组
int f = Integer.parseInt(s);
if (trustedidentit.get(z) != null) {
// System.out.println(trustedidentit.get(z).getMainInformation());
// if(trustedidentit.get(z).getMainInformation()<0){
maintrustedidentit.put(f, trustedidentit.get(z));
cousize++;
intsize++;
// }
}
if (meventime.get(z) != null) {
// if(meventime.get(z).getMainInformation()<0){
mainmeventime.put(f, meventime.get(z));
cousize++;
intsize++;
// }
}
if (eventbehacior.get(z) != null) {
// if(eventbehacior.get(z).getMainInformation()<0){
maineventbehacior.put(f, eventbehacior.get(z));
cousize++;
intsize++;
// }
}
mapcoune.put(f, intsize);
}
uiModel.addAttribute("mapcoune", mapcoune);
uiModel.addAttribute("enclosurepdf", enclosurepdf);
uiModel.addAttribute("maintrustedidentit", maintrustedidentit);
uiModel.addAttribute("mainmeventime", mainmeventime);
uiModel.addAttribute("maineventbehacior", maineventbehacior);
// 得到事件的时间
Date time6 = new Date();
Long Ltime5 = time6.getTime() - time.getTime();
log.error("得到无主题信息的毫秒数，Ltime5=" + Ltime5);
// 服务委托人签名信息
Map<Long, EvidenceClientSignature> cilentsignat = new HashMap<Long, EvidenceClientSignature>();
// 天威签名信息
Map<Long, EvidenceClientSignature> cilentsignature = new HashMap<Long, EvidenceClientSignature>();
// 服务委托人时间戳信息
Map<Long, EvidenceClientTimeStamp> clientTimestamp = new HashMap<Long, EvidenceClientTimeStamp>();
// 天威时间戳信息
Map<Long, EvidenceClientTimeStamp> tclientTimestamp = new HashMap<Long, EvidenceClientTimeStamp>();
// 服务委托人证书信息
Map<Long, List<EvidenceCert>> listcert = new HashMap<Long, List<EvidenceCert>>();
// 服务委托人核验信息
Map<Long, EvidenceCheck> check = new HashMap<Long, EvidenceCheck>();
// 天威核验信息
Map<Long, EvidenceCheck> tcheck = new HashMap<Long, EvidenceCheck>();
int ensize = 0;
Map<Long, Integer> mint = new HashMap<Long, Integer>();
// 循环附件信息取得服务委托人和天威签名时间戳信息
for (EvidenceEnclosure en : enclosure) {
Date time11 = new Date();
int encount = 0;
// 服务委托人签名信息
/*EvidenceClientSignatureExample cilent = new EvidenceClientSignatureExample();
EvidenceClientSignatureExample.Criteria signat = cilent.createCriteria();
signat.andEvidenceSnEqualTo(en.getEvidenceSn());*/
// signat.andNameEqualTo("0");
List<EvidenceClientSignature> listclient = sqlSession.selectList("com.itrus.portal.db.EvidenceClientSignatureMapper.selectcertId", en.getEvidenceSn());
EvidenceClientSignature clien1 = new EvidenceClientSignature();
EvidenceClientSignature clien2 = new EvidenceClientSignature();
for (int i = 0; i < listclient.size(); i++) {
if ("0".equals(listclient.get(i).getName())) {
clien1 = listclient.get(i);
}
if ("1".equals(listclient.get(i).getName())) {
clien2 = listclient.get(i);
}
}
cilentsignat.put(en.getId(), clien1);
if (clien1.getId() != null) {
ensize++;
encount++;
// 服务委托人证书信息
/*EvidenceCertExample certEx = new EvidenceCertExample();
EvidenceCertExample.Criteria evidenceCert = certEx.createCriteria();
evidenceCert.andClientSignatureEqualTo(listclient.getId());*/
List<EvidenceCert> listCert = sqlSession.selectList("com.itrus.portal.db.EvidenceCertMapper.selectByPrimaryKey", clien1.getCertId());
listcert.put(en.getId(), listCert);
// 服务委托人核验信息
EvidenceCheckExample checkEx = new EvidenceCheckExample();
EvidenceCheckExample.Criteria evidenceCheck = checkEx.createCriteria();
evidenceCheck.andClientSignatureEqualTo(clien1.getId());
EvidenceCheck listCheck = sqlSession.selectOne("com.itrus.portal.db.EvidenceCheckMapper.selectByExample", checkEx);
check.put(en.getId(), listCheck);
}
Date time12 = new Date();
Long gettime = time12.getTime() - time11.getTime();
log.error("-----------gettime0--------------" + gettime);
// 天威签名信息
/*EvidenceClientSignatureExample cilentsign = new EvidenceClientSignatureExample();
EvidenceClientSignatureExample.Criteria signature = cilentsign.createCriteria();
signature.andEvidenceSnEqualTo(en.getEvidenceSn());
signature.andNameEqualTo("1");
EvidenceClientSignature clientlist = sqlSession
.selectOne("com.itrus.portal.db.EvidenceClientSignatureMapper.selectByExample", cilentsign);*/
cilentsignature.put(en.getId(), clien2);
if (clien2.getId() != null) {
ensize++;
encount++;
// 服务委托人核验信息
EvidenceCheckExample checkEx = new EvidenceCheckExample();
EvidenceCheckExample.Criteria evidenceCheck = checkEx.createCriteria();
evidenceCheck.andClientSignatureEqualTo(clien2.getId());
EvidenceCheck listCheck = sqlSession.selectOne("com.itrus.portal.db.EvidenceCheckMapper.selectByExample", checkEx);
tcheck.put(en.getId(), listCheck);
}
Date time13 = new Date();
Long gettime1 = time13.getTime() - time12.getTime();
log.error("-----------gettime1--------------" + gettime1);
// 服务委托人时间戳信息
/*EvidenceClientTimeStampExample clientTime = new EvidenceClientTimeStampExample();
EvidenceClientTimeStampExample.Criteria stamp = clientTime.createCriteria();
stamp.andEvidenceSnEqualTo(en.getEvidenceSn());*/
// stamp.andNameEqualTo("0");
log.error("证据编号=======" + en.getEvidenceSn());
List<EvidenceClientTimeStamp> listtime = sqlSession.selectList("com.itrus.portal.db.EvidenceClientTimeStampMapper.selectTimeStamp", en.getEvidenceSn());
EvidenceClientTimeStamp timestamp1 = new EvidenceClientTimeStamp();
EvidenceClientTimeStamp timestamp2 = new EvidenceClientTimeStamp();
log.error("时间戳listtime==--**" + listtime);
for (int j = 0; j < listtime.size(); j++) {
if ("0".equals(listtime.get(j).getName())) {
timestamp1 = listtime.get(j);
log.error("服务委托人时间-----------" + timestamp1);
}
/*else if("1".equals(listtime.get(j).getName())){
timestamp2 = listtime.get(j);
}*/
log.error("服务委托人时间***********" + listtime.get(j).getName());
if ("1".equals(listtime.get(j).getName())) {
timestamp2 = listtime.get(j);
log.error("服务委托人时间-----------" + timestamp2);
}
/*else if("0".equals(listtime.get(j).getName())){
timestamp1 = listtime.get(j);
}*/
}
clientTimestamp.put(en.getId(), timestamp1);
if (timestamp1 != null) {
ensize++;
encount++;
}
Date time14 = new Date();
Long gettime2 = time14.getTime() - time13.getTime();
log.error("-----------gettime2--------------" + gettime2);
// 天威时间戳信息
/*EvidenceClientTimeStampExample tclientTime = new EvidenceClientTimeStampExample();
EvidenceClientTimeStampExample.Criteria tstamp = tclientTime.createCriteria();
tstamp.andEvidenceSnEqualTo(en.getEvidenceSn());
tstamp.andNameEqualTo("1");
EvidenceClientTimeStamp timelist = sqlSession
.selectOne("com.itrus.portal.db.EvidenceClientTimeStampMapper.selectByExample", tclientTime);*/
tclientTimestamp.put(en.getId(), timestamp2);
if (timestamp2 != null) {
ensize++;
encount++;
}
mint.put(en.getId(), encount);
Date time15 = new Date();
Long gettime3 = time15.getTime() - time14.getTime();
log.error("-----------gettime3--------------" + gettime3);
}
// 得到事件的时间
Date time7 = new Date();
Long Ltime6 = time7.getTime() - time.getTime();
log.error("得到证据申请信息和申请时间戳的毫秒数，Ltime6=" + Ltime6);
Long Ltime10 = time7.getTime() - time6.getTime();
log.error("+++++++++++*********---------，Ltime10++++++++++++++=" + Ltime10);
uiModel.addAttribute("ensize", ensize);
uiModel.addAttribute("mint", mint);
List<EvidenceHisCertificate> hisCertificete = new ArrayList<EvidenceHisCertificate>();
EvidenceHisRelationshipExample relation = new EvidenceHisRelationshipExample();
EvidenceHisRelationshipExample.Criteria hisreation = relation.createCriteria();
hisreation.andBasicInformationEqualTo(id);
List<EvidenceHisRelationship> hisRelation = sqlSession.selectList("com.itrus.portal.db.EvidenceHisRelationshipMapper.selectByExample", relation);
for (int g = 0; g < hisRelation.size(); g++) {
// 得到证据基本信息
/*EvidenceBasicInformation basic = sqlSession.selectOne(
"com.itrus.portal.db.EvidenceBasicInformationMapper.selectByPrimaryKey",
hisRelation.get(g).getBasicInformation());*/
EvidenceHisCertificate eh = sqlSession.selectOne("com.itrus.portal.db.EvidenceHisCertificateMapper.selectByPrimaryKey", hisRelation.get(g).getHisCertificate());
hisCertificete.add(eh);
}
// 出证信息
// List<Map<String, Object>> hisCertificete = hiscertificate.selectHisCertificateEnt();
Map<Long, EvidenceOutTemplate> mout = new HashMap<Long, EvidenceOutTemplate>();
Map<Long, EvidenceEnclosure> closure = new HashMap<Long, EvidenceEnclosure>();
Map<Long, List<EvidenceBasicInformation>> mbasilist = new HashMap<Long, List<EvidenceBasicInformation>>();
// ArrayList<EvidenceBasicInformation>();
for (int j = 0; j < hisCertificete.size(); j++) {
List<EvidenceBasicInformation> blist = new ArrayList<EvidenceBasicInformation>();
Long hidId = hisCertificete.get(j).getId();
String serialnumber = hisCertificete.get(j).getSerialnumber();
if (hisCertificete.get(j).getHisAppService() != null && hisCertificete.get(j).getHisAppService() > 0) {
Long appServiceId = hisCertificete.get(j).getHisAppService();
// 得到服务编码
AppService happservice = appService.selectById(appServiceId);
// 得到出证服务配置
EvidenceOutServiceConfigExample outsaveService = new EvidenceOutServiceConfigExample();
EvidenceOutServiceConfigExample.Criteria saveServiceEx = outsaveService.createCriteria();
saveServiceEx.andAppServiceEqualTo(happservice.getId());
EvidenceOutServiceConfig outService = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutServiceConfigMapper.selectByExample", outsaveService);
// 得到出证模板信息
EvidenceOutTemplate outtemp = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutTemplateMapper.selectByPrimaryKey", outService.getSaveRetTemplate());
mout.put(hidId, outtemp);
// 获取证据附件表
EvidenceEnclosureExample envlosureE = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria envlosureEx = envlosureE.createCriteria();
envlosureEx.andSerialnumberEqualTo(serialnumber);
envlosureEx.andPdfTypeEqualTo("4");
EvidenceEnclosure envlosure = sqlSession.selectOne("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", envlosureE);
closure.put(hidId, envlosure);
}
uiModel.addAttribute("closure", closure);
/*long hid = Long.parseLong(hisCertificete.get(j).get("id").toString());
EvidenceHisRelationshipExample relation = new EvidenceHisRelationshipExample();
EvidenceHisRelationshipExample.Criteria hisreation = relation.createCriteria();
hisreation.andHisCertificateEqualTo(hid);
List<EvidenceHisRelationship> hisRelation = sqlSession
.selectList("com.itrus.portal.db.EvidenceHisRelationshipMapper.selectByExample", relation);
for (int g = 0; g < hisRelation.size(); g++) {
// 得到证据基本信息
EvidenceBasicInformation basic = sqlSession.selectOne(
"com.itrus.portal.db.EvidenceBasicInformationMapper.selectByPrimaryKey",
hisRelation.get(g).getBasicInformation());
blist.add(basic);
}
mbasilist.put(hidId, blist);*/
}
uiModel.addAttribute("basi", basi);
uiModel.addAttribute("check", check);
uiModel.addAttribute("listcert", listcert);
uiModel.addAttribute("realName", realName);
uiModel.addAttribute("mbasilist", mbasilist);
uiModel.addAttribute("mout", mout);
uiModel.addAttribute("envlosure", enclosure);
uiModel.addAttribute("hisCertificete", hisCertificete);
uiModel.addAttribute("basicinfor", basicinfor);
uiModel.addAttribute("tclientTimestamp", tclientTimestamp);
uiModel.addAttribute("clientTimestamp", clientTimestamp);
uiModel.addAttribute("cilentsignature", cilentsignature);
uiModel.addAttribute("cilentsignat", cilentsignat);
uiModel.addAttribute("networkaddress", networkaddress);
uiModel.addAttribute("meventdesire", meventdesire);
uiModel.addAttribute("eventbehacior", eventbehacior);
uiModel.addAttribute("meventime", meventime);
uiModel.addAttribute("trustedidentit", trustedidentit);
uiModel.addAttribute("mevencontent", mevencontent);
uiModel.addAttribute("trustedidentity", trustedidentity);
uiModel.addAttribute("companiesSubmit", companiesSubmit);
uiModel.addAttribute("realnameRecor", realnameRecor);
uiModel.addAttribute("denceid", denceid);
uiModel.addAttribute("personalName", personalName);
uiModel.addAttribute("mainInfo", mlist);
uiModel.addAttribute("milist", mlist);
Map<Long, Integer> msize = new HashMap<Long, Integer>();
// 得到认证数量
for (EvidenceMainInformation m : mlist) {
int showsize = 0;
// 身份认证
if (companiesSubmit.get(m.getId()) != null) {
coutn++;
}
if (realnameRecor.get(m.getId()) != null) {
coutn++;
}
if (personalName.get(m.getId()) != null) {
coutn++;
}
if (desire.get(m.getId()) != null) {
coutn++;
}
if (trustedidentity.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
coutn++;
}
if (denceid.get(m.getId()) != null) {
coutn++;
}
// 事件认证
if (trustedidentit.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
size++;
showsize++;
}
if (meventime.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
size++;
showsize++;
}
if (eventbehacior.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
size++;
showsize++;
}
if (meventdesire.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
size++;
showsize++;
}
if (networkaddress.get(m.getSubjectName() + ";" + m.getIdentification()) != null) {
size++;
showsize++;
}
msize.put(m.getId(), showsize);
}
uiModel.addAttribute("cousize", cousize);
uiModel.addAttribute("rowsize", size + 1 + cousize);
uiModel.addAttribute("showsize", msize);
uiModel.addAttribute("rowcoutn", coutn);
uiModel.addAttribute("desire", desire);
// 得到事件的时间
Date time8 = new Date();
// 方法结束时间
log.error("******************time8=" + time8);
Long Ltime7 = time8.getTime() - time.getTime();
log.error("方法结束的毫秒数，Ltime7=" + Ltime7);
return "basicinformation/show";
}
Also used :
EvidenceSubjectIdentityExample(com.itrus.portal.db.EvidenceSubjectIdentityExample)
PersonalNameExample(com.itrus.portal.db.PersonalNameExample)
ArrayList(java.util.ArrayList)
EvidenceRealName(com.itrus.portal.db.EvidenceRealName)
EvidenceCompaniesSubmitExample(com.itrus.portal.db.EvidenceCompaniesSubmitExample)
EvidenceEventNetworkAddressExample(com.itrus.portal.db.EvidenceEventNetworkAddressExample)
EvidenceDesireIdentify(com.itrus.portal.db.EvidenceDesireIdentify)
EvidenceEventBehaviorExample(com.itrus.portal.db.EvidenceEventBehaviorExample)
EvidenceOutServiceConfigExample(com.itrus.portal.db.EvidenceOutServiceConfigExample)
EvidenceSubjectIdentity(com.itrus.portal.db.EvidenceSubjectIdentity)
EvidenceEnclosureExample(com.itrus.portal.db.EvidenceEnclosureExample)
RealNameRecord(com.itrus.portal.db.RealNameRecord)
EvidenceEventNetworkAddress(com.itrus.portal.db.EvidenceEventNetworkAddress)
EvidenceIndividualExample(com.itrus.portal.db.EvidenceIndividualExample)
EvidenceRealNameExample(com.itrus.portal.db.EvidenceRealNameExample)
EvidenceBasicInformation(com.itrus.portal.db.EvidenceBasicInformation)
EvidenceHisCertificate(com.itrus.portal.db.EvidenceHisCertificate)
EvidenceEnclosure(com.itrus.portal.db.EvidenceEnclosure)
EvidenceOutServiceConfig(com.itrus.portal.db.EvidenceOutServiceConfig)
PersonalName(com.itrus.portal.db.PersonalName)
EvidenceOutTemplate(com.itrus.portal.db.EvidenceOutTemplate)
EvidenceCompaniesSubmit(com.itrus.portal.db.EvidenceCompaniesSubmit)
EvidenceClientSignature(com.itrus.portal.db.EvidenceClientSignature)
EvidenceCheck(com.itrus.portal.db.EvidenceCheck)
EvidenceEventBehavior(com.itrus.portal.db.EvidenceEventBehavior)
EvidenceIndividual(com.itrus.portal.db.EvidenceIndividual)
HashMap(java.util.HashMap)
EvidenceClientTimeStamp(com.itrus.portal.db.EvidenceClientTimeStamp)
ArrayList(java.util.ArrayList)
List(java.util.List)
EvidenceEventDesire(com.itrus.portal.db.EvidenceEventDesire)
EvidenceHisRelationship(com.itrus.portal.db.EvidenceHisRelationship)
EvidenceCheckExample(com.itrus.portal.db.EvidenceCheckExample)
EvidenceCert(com.itrus.portal.db.EvidenceCert)
EvidenceEventTime(com.itrus.portal.db.EvidenceEventTime)
EvidenceMainInformation(com.itrus.portal.db.EvidenceMainInformation)
EvidenceDesireIdentifyExample(com.itrus.portal.db.EvidenceDesireIdentifyExample)
EvidenceEventDesireExample(com.itrus.portal.db.EvidenceEventDesireExample)
EvidenceEventTimeExample(com.itrus.portal.db.EvidenceEventTimeExample)
EvidenceEventContent(com.itrus.portal.db.EvidenceEventContent)
AppService(com.itrus.portal.db.AppService)
Date(java.util.Date)
EvidenceHisRelationshipExample(com.itrus.portal.db.EvidenceHisRelationshipExample)
EvidenceBasicInformationExample(com.itrus.portal.db.EvidenceBasicInformationExample)
EvidenceTrustedIdentity(com.itrus.portal.db.EvidenceTrustedIdentity)
EvidenceMainInformationExample(com.itrus.portal.db.EvidenceMainInformationExample)
RealNameRecordExample(com.itrus.portal.db.RealNameRecordExample)
EvidenceTrustedIdentityExample(com.itrus.portal.db.EvidenceTrustedIdentityExample)
RequestMapping(org.springframework.web.bind.annotation.RequestMapping)
Example 7 with EvidenceOutTemplate
use of com.itrus.portal.db.EvidenceOutTemplate in project portal by ixinportal.
the class EvidenceOutTask method outBody.
/**
* 自动出证
* @param hisCertificate
* @param orderNumber
*/
private void outBody(String orderNumber, EvidenceOutServiceConfig outServiceConfig, ApplicationInfo applicationInfo, AppService appService, String evidenceSns, String businessSn, Date date, String code, Integer count) {
try {
// 定义错误原因字段
String hisCauseFailure = null;
// 得到出证模板信息
EvidenceOutTemplateExample outTemplateExample = new EvidenceOutTemplateExample();
EvidenceOutTemplateExample.Criteria tec = outTemplateExample.createCriteria();
tec.andIdEqualTo(outServiceConfig.getOutReportTemplate());
EvidenceOutTemplate outTemplate = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutTemplateMapper.selectByExample", outTemplateExample);
// 整合证书需要的要素
String[] factorArr = outTemplate.getFactor().split(",");
// 整合出证信息表
EvidenceHisCertificate hisCertificate = new EvidenceHisCertificate();
hisCertificate.setServiceRequestPlatform(applicationInfo.getName());
hisCertificate.setApplicationInfo(applicationInfo.getId());
hisCertificate.setSisServiceName(appService.getAppServiceName());
hisCertificate.setSerialnumber(orderNumber);
hisCertificate.setHisAppService(appService.getId());
hisCertificate.setApplicationTime(date);
hisCertificate.setHisApplicant(code);
hisCertificate.setHisState("1");
hisCertificate.setOutState(0);
hisCertificate.setOutTemplate(outServiceConfig.getOutReportTemplate());
hisCertificate.setHisway(outServiceConfig.getOutWay().toString());
sqlSession.insert("com.itrus.portal.db.EvidenceHisCertificateMapper.insert", hisCertificate);
sqlSession.flushStatements();
// int count = 0;
if (StringUtils.isNotEmpty(evidenceSns)) {
String[] evidenceSnArr = evidenceSns.split(",");
for (String evidenceSn : evidenceSnArr) {
// 获得对应证据编号的信息
EvidenceBasicInformation basicInformation = basicInformationService.getInformationBySn(evidenceSn, 2);
if (basicInformation == null) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "提交的" + evidenceSn + "证据编号为无效的证据编码";
else
hisCauseFailure = hisCauseFailure + "," + "提交的" + evidenceSn + "证据编号为无效的证据编码";
continue;
}
// count++;
if (basicInformation.getEvidenceStatus() == 0 || StringUtils.isNotEmpty(basicInformation.getLackMainContent())) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据编号:" + evidenceSn + "核验未通过,不满足出证要求";
else
hisCauseFailure = hisCauseFailure + "," + "证据编号:" + evidenceSn + "核验未通过,不满足出证要求";
}
// 得到证据附件信息
EvidenceEnclosureExample enclosureExample = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria eec = enclosureExample.createCriteria();
eec.andEvidenceSnEqualTo(evidenceSn);
eec.andPdfTypeEqualTo("1");
List<EvidenceEnclosure> enclosures = sqlSession.selectList("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclosureExample);
// 核验事件证据提交的要素
String subFactor = null;
String lackFactor = null;
for (EvidenceEnclosure enclosure : enclosures) {
if (StringUtils.isEmpty(subFactor))
subFactor = enclosure.getSaveFactor();
else
subFactor = subFactor + "," + enclosure.getSaveFactor();
}
for (String factor : factorArr) {
if (!subFactor.contains(factor) && !(factor.contains("主体身份") || factor.contains("身份实名认证") || factor.contains("身份意愿鉴别"))) {
if (StringUtils.isEmpty(lackFactor))
lackFactor = factor;
else
lackFactor = lackFactor + "," + factor;
}
}
if (StringUtils.isNotEmpty(lackFactor)) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据编号:" + evidenceSn + ",缺少必要要素信息：" + lackFactor;
else
hisCauseFailure = hisCauseFailure + "," + "证据编号:" + evidenceSn + ",缺少必要要素信息：" + lackFactor;
}
// 核验身份提交的要素
String idFactor = null;
for (String factor : factorArr) {
if (factor.contains("主体身份") || factor.contains("身份实名认证") || factor.contains("身份意愿鉴别")) {
if (StringUtils.isEmpty(idFactor))
idFactor = factor;
else
idFactor = idFactor + "," + factor;
}
}
log.debug("idFactor__ : " + idFactor);
if (StringUtils.isNotEmpty(idFactor)) {
EvidenceTrustedIdentityExample trustedIdentityExample = new EvidenceTrustedIdentityExample();
EvidenceTrustedIdentityExample.Criteria ttc = trustedIdentityExample.createCriteria();
ttc.andBasicInformationEqualTo(basicInformation.getId().toString());
ttc.andEventContentIsNull();
List<EvidenceTrustedIdentity> trustedIdentities = sqlSession.selectList("com.itrus.portal.db.EvidenceTrustedIdentityMapper.selectByExample", trustedIdentityExample);
if (trustedIdentities == null || trustedIdentities.isEmpty()) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据编号:" + evidenceSn + ",缺少必要要素信息：可信身份标识";
else
hisCauseFailure = hisCauseFailure + "," + "证据编号:" + evidenceSn + ",缺少必要要素信息：可信身份标识";
} else {
for (EvidenceTrustedIdentity trustedIdentity : trustedIdentities) {
// 得到主体身份信息
EvidenceMainInformationExample informationExample = new EvidenceMainInformationExample();
EvidenceMainInformationExample.Criteria iec = informationExample.createCriteria();
// iec.andIdEqualTo(trustedIdentity.getMainInformation());
EvidenceMainInformation mainInformation = sqlSession.selectOne("com.itrus.portal.db.EvidenceMainInformationMapper.selectByExample", informationExample);
// 整合没关联主体身份证据的信息
if (StringUtils.isEmpty(trustedIdentity.getEvidenceSn())) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据主体:" + mainInformation.getSubjectName() + ",编号:" + evidenceSn + ",缺少必要要素信息：" + idFactor;
else
hisCauseFailure = hisCauseFailure + "," + "证据主体:" + mainInformation.getSubjectName() + ",编号:" + evidenceSn + ",缺少必要要素信息：" + idFactor;
} else {
// 得到证据附件信息
EvidenceEnclosureExample enclosureExample1 = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria eec1 = enclosureExample1.createCriteria();
eec1.andEvidenceSnEqualTo(trustedIdentity.getEvidenceSn());
eec1.andPdfTypeEqualTo("1");
List<EvidenceEnclosure> enclosures1 = sqlSession.selectList("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclosureExample1);
String subFactorId = null;
String lackFactorId = null;
for (EvidenceEnclosure enclosure : enclosures1) {
if (StringUtils.isEmpty(subFactorId))
subFactorId = enclosure.getSaveFactor();
else
subFactorId = subFactorId + "," + enclosure.getSaveFactor();
}
log.debug("subFactorId__ : " + subFactorId);
String[] factorIdArr = idFactor.split(",");
for (String factor : factorIdArr) {
if (!subFactorId.contains(factor)) {
if (StringUtils.isEmpty(lackFactorId))
lackFactorId = factor;
else
lackFactorId = lackFactorId + "," + factor;
}
}
log.debug("lackFactorId__ : " + lackFactorId);
if (StringUtils.isNotEmpty(lackFactorId)) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据主体:" + mainInformation.getSubjectName() + ",编号:" + evidenceSn + ",缺少必要要素信息：" + lackFactorId;
else
hisCauseFailure = hisCauseFailure + "," + "证据主体:" + mainInformation.getSubjectName() + ",编号:" + evidenceSn + ",缺少必要要素信息：" + lackFactorId;
}
}
}
}
}
// 存储出证与证据关系
EvidenceHisRelationship hisRelationship = new EvidenceHisRelationship();
hisRelationship.setBasicInformation(basicInformation.getId());
hisRelationship.setHisCertificate(hisCertificate.getId());
sqlSession.insert("com.itrus.portal.db.EvidenceHisRelationshipMapper.insert", hisRelationship);
}
} else {
List<EvidenceBasicInformation> basicInformations = basicInformationService.getInformationByBusinessSn(businessSn, 2);
if (basicInformations == null || basicInformations.isEmpty()) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "提交的业务单号有误";
else
hisCauseFailure = hisCauseFailure + "," + "提交的业务单号有误";
}
for (EvidenceBasicInformation basicInformation : basicInformations) {
// 得到证据附件信息
EvidenceEnclosureExample enclosureExample = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria eec = enclosureExample.createCriteria();
eec.andBasicInformationEqualTo(basicInformation.getId());
eec.andPdfTypeEqualTo("1");
List<EvidenceEnclosure> enclosures = sqlSession.selectList("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclosureExample);
// 得到提交的要素
String subFactor = null;
String lackFactor = null;
for (EvidenceEnclosure enclosure : enclosures) {
if (StringUtils.isEmpty(subFactor))
subFactor = enclosure.getSaveFactor();
else
subFactor = subFactor + "," + enclosure.getSaveFactor();
}
for (String factor : factorArr) {
if (!subFactor.contains(factor)) {
if (StringUtils.isEmpty(lackFactor))
lackFactor = factor;
else
lackFactor = lackFactor + "," + factor;
}
}
if (StringUtils.isNotEmpty(lackFactor)) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据编号:" + basicInformation.getEvidenceSn() + ",缺少必要要素信息：" + lackFactor;
else
hisCauseFailure = hisCauseFailure + "," + "证据编号:" + basicInformation.getEvidenceSn() + ",缺少必要要素信息：" + lackFactor;
}
// count++;
if (basicInformation.getEvidenceStatus() == 0 || StringUtils.isNotEmpty(basicInformation.getLackMainContent())) {
if (StringUtils.isEmpty(hisCauseFailure))
hisCauseFailure = "证据编号:" + basicInformation.getEvidenceSn() + ",不满足出证要求";
else
hisCauseFailure = hisCauseFailure + "," + "证据编号:" + basicInformation.getEvidenceSn() + ",不满足出证要求";
}
// 存储出证与证据关系
EvidenceHisRelationship hisRelationship = new EvidenceHisRelationship();
hisRelationship.setBasicInformation(basicInformation.getId());
hisRelationship.setHisCertificate(hisCertificate.getId());
sqlSession.insert("com.itrus.portal.db.EvidenceHisRelationshipMapper.insert", hisRelationship);
}
}
// 判断出证模式
if (count == 1)
hisCertificate.setHis("0");
else
hisCertificate.setHis("1");
// 判断出证是否有错
if (StringUtils.isNotEmpty(hisCauseFailure)) {
// hisCertificate.setHisway("3");
hisCertificate.setOutState(1);
hisCertificate.setHisCauseFailure(hisCauseFailure);
}
sqlSession.update("com.itrus.portal.db.EvidenceHisCertificateMapper.updateByPrimaryKey", hisCertificate);
sqlSession.flushStatements();
// 判断是否为自动出证
if ("1".equals(hisCertificate.getHisway()) && hisCertificate.getOutState() == 0) {
String oper1 = "出证接口";
String info1 = "出证申请成功,流水号：" + orderNumber;
LogUtil.evidencelog(sqlSession, null, oper1, info1);
Map<String, Object> mapRet = null;
// 生成出证报告
try {
mapRet = reportTemplate.certificationReport(hisCertificate.getSerialnumber());
} catch (Exception e) {
StackTraceElement stackTraceElement = e.getStackTrace()[e.getStackTrace().length - 3];
String infoErr = stackTraceElement.getClassName() + stackTraceElement.getLineNumber() + e.toString();
String oper = "出证接口";
String info = "生成出证报告失败,流水号：" + orderNumber + ",失败原因：" + infoErr;
LogUtil.evidencelog(sqlSession, null, oper, info);
e.printStackTrace();
}
// 判断出证报告是否生成成功
if (mapRet != null) {
if ((int) mapRet.get("status") == 0) {
// hisCertificate.setOutState(0);
String oper = "出证接口";
String info = "生成出证报告成功,流水号：" + orderNumber;
LogUtil.evidencelog(sqlSession, null, oper, info);
hisCertificate.setHisState("0");
} else {
// hisCertificate.setOutState(1);
String oper = "出证接口";
String info = null;
if (mapRet.get("message") != null) {
info = "生成出证报告失败,流水号：" + orderNumber + ",失败原因：" + mapRet.get("message").toString();
// hisCertificate.setHisCauseFailure(mapRet.get("message").toString());
} else {
info = "生成出证报告失败,流水号：" + orderNumber;
// hisCertificate.setHisCauseFailure("出证失败");
}
LogUtil.evidencelog(sqlSession, null, oper, info);
}
}
} else {
String oper = "出证接口";
String info = "出证失败,流水号：" + orderNumber;
// 判断为自动出证失败后 转人工出证
if (hisCertificate.getHisway().equals("1")) {
hisCertificate.setHisway("3");
info = info + ",已自动转人工出证";
}
LogUtil.evidencelog(sqlSession, null, oper, info);
}
sqlSession.update("com.itrus.portal.db.EvidenceHisCertificateMapper.updateByPrimaryKeySelective", hisCertificate);
// 出证计费加流水
takeChargingService.takeCharing(appService.getServiceConfigName(), appService.getServiceConfigId(), applicationInfo, appService, hisCertificate.getId(), "EvidenceHisCertificate", count, applicationInfo.getName(), hisCertificate.getHisApplicant());
} catch (Exception e) {
e.printStackTrace();
StackTraceElement stackTraceElement = e.getStackTrace()[e.getStackTrace().length - 3];
String info = "出证失败,错误详情：" + stackTraceElement.getClassName() + stackTraceElement.getLineNumber() + e.toString();
String oper = "出证接口";
LogUtil.evidencelog(sqlSession, null, oper, info);
}
}
Also used :
EvidenceBasicInformation(com.itrus.portal.db.EvidenceBasicInformation)
EvidenceHisRelationship(com.itrus.portal.db.EvidenceHisRelationship)
EvidenceHisCertificate(com.itrus.portal.db.EvidenceHisCertificate)
EvidenceEnclosureExample(com.itrus.portal.db.EvidenceEnclosureExample)
EvidenceEnclosure(com.itrus.portal.db.EvidenceEnclosure)
EvidenceMainInformation(com.itrus.portal.db.EvidenceMainInformation)
EvidenceOutTemplateExample(com.itrus.portal.db.EvidenceOutTemplateExample)
EvidenceTrustedIdentity(com.itrus.portal.db.EvidenceTrustedIdentity)
EvidenceOutTemplate(com.itrus.portal.db.EvidenceOutTemplate)
EvidenceMainInformationExample(com.itrus.portal.db.EvidenceMainInformationExample)
EvidenceTrustedIdentityExample(com.itrus.portal.db.EvidenceTrustedIdentityExample)
Example 8 with EvidenceOutTemplate
use of com.itrus.portal.db.EvidenceOutTemplate in project portal by ixinportal.
the class HisCertificateController method show.
/**
* 查看详情
*
* @param id
* @param type
* @param uiModel
* @return
*/
@RequestMapping(value = "/{id}/{type}", produces = "text/html")
public String show(@PathVariable("id") Long id, @PathVariable("type") int type, Model uiModel) {
EvidenceHisCertificate hisCertificate = hiscertificate.selectById(id);
// 出征流水号
contractNumber = hisCertificate.getSerialnumber();
// 得到服务编码
AppService appservice = appService.selectById(hisCertificate.getHisAppService());
// 得到出证服务配置
EvidenceOutServiceConfigExample saveService = new EvidenceOutServiceConfigExample();
EvidenceOutServiceConfigExample.Criteria saveServiceEx = saveService.createCriteria();
saveServiceEx.andAppServiceEqualTo(appservice.getId());
EvidenceOutServiceConfig outService = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutServiceConfigMapper.selectByExample", saveService);
// 得到出证模板信息
EvidenceOutTemplate outtemp = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutTemplateMapper.selectByPrimaryKey", outService.getSaveRetTemplate());
uiModel.addAttribute("hisCertificate", hisCertificate);
uiModel.addAttribute("outtemp", outtemp);
// 获取证据附件表
EvidenceEnclosureExample envlosureE = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria envlosureEx = envlosureE.createCriteria();
envlosureEx.andSerialnumberEqualTo(hisCertificate.getSerialnumber());
envlosureEx.andPdfTypeEqualTo("4");
EvidenceEnclosure envlosure = sqlSession.selectOne("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", envlosureE);
uiModel.addAttribute("envlosure", envlosure);
Map<Long, List<EvidenceMainInformation>> minfo = new HashMap<Long, List<EvidenceMainInformation>>();
// Map<Long, List<EvidenceBasicInformation>> mbasi = new HashMap<Long,
// List<EvidenceBasicInformation>>();
List<EvidenceBasicInformation> blists = new ArrayList<EvidenceBasicInformation>();
// 得到出证关联表信息
EvidenceHisRelationshipExample relation = new EvidenceHisRelationshipExample();
EvidenceHisRelationshipExample.Criteria hisreation = relation.createCriteria();
hisreation.andHisCertificateEqualTo(hisCertificate.getId());
List<EvidenceHisRelationship> hisRelation = sqlSession.selectList("com.itrus.portal.db.EvidenceHisRelationshipMapper.selectByExample", relation);
for (int j = 0; j < hisRelation.size(); j++) {
List<EvidenceMainInformation> mlist = new ArrayList<EvidenceMainInformation>();
// 得到证据基本信息
EvidenceBasicInformation basic = sqlSession.selectOne("com.itrus.portal.db.EvidenceBasicInformationMapper.selectByPrimaryKey", hisRelation.get(j).getBasicInformation());
blists.add(basic);
// 得到证据身份主题关联信息
EvidenceSubjectIdentityExample subjectExample = new EvidenceSubjectIdentityExample();
EvidenceSubjectIdentityExample.Criteria identity = subjectExample.createCriteria();
identity.andBasicInformationEqualTo(basic.getEvidenceSn());
List<EvidenceSubjectIdentity> subjectIdentity = sqlSession.selectList("com.itrus.portal.db.EvidenceSubjectIdentityMapper.selectByExample", subjectExample);
for (int g = 0; g < subjectIdentity.size(); g++) {
// 得到主题身份信息
EvidenceMainInformation mainInfo = sqlSession.selectOne("com.itrus.portal.db.EvidenceMainInformationMapper.selectByPrimaryKey", subjectIdentity.get(g).getMainInformation());
mlist.add(mainInfo);
}
minfo.put(basic.getId(), mlist);
}
uiModel.addAttribute("mainInfo", minfo);
uiModel.addAttribute("blists", blists);
if (type == 1) {
// 待出证
return "hiscertificate/show";
} else if (type == 2) {
// 已出证
return "hiscertificate/show1";
}
return null;
}
Also used :
EvidenceSubjectIdentityExample(com.itrus.portal.db.EvidenceSubjectIdentityExample)
HashMap(java.util.HashMap)
EvidenceBasicInformation(com.itrus.portal.db.EvidenceBasicInformation)
ArrayList(java.util.ArrayList)
EvidenceHisCertificate(com.itrus.portal.db.EvidenceHisCertificate)
EvidenceEnclosure(com.itrus.portal.db.EvidenceEnclosure)
EvidenceMainInformation(com.itrus.portal.db.EvidenceMainInformation)
EvidenceOutServiceConfig(com.itrus.portal.db.EvidenceOutServiceConfig)
EvidenceOutTemplate(com.itrus.portal.db.EvidenceOutTemplate)
ArrayList(java.util.ArrayList)
List(java.util.List)
AppService(com.itrus.portal.db.AppService)
EvidenceOutServiceConfigExample(com.itrus.portal.db.EvidenceOutServiceConfigExample)
EvidenceHisRelationship(com.itrus.portal.db.EvidenceHisRelationship)
EvidenceEnclosureExample(com.itrus.portal.db.EvidenceEnclosureExample)
EvidenceSubjectIdentity(com.itrus.portal.db.EvidenceSubjectIdentity)
EvidenceHisRelationshipExample(com.itrus.portal.db.EvidenceHisRelationshipExample)
RequestMapping(org.springframework.web.bind.annotation.RequestMapping)
Example 9 with EvidenceOutTemplate
use of com.itrus.portal.db.EvidenceOutTemplate in project portal by ixinportal.
the class OutServiceConfigController method update.
// 修改处理
@RequestMapping(method = RequestMethod.PUT, produces = "text/html")
public String update(@ModelAttribute("evidenceOutServiceConfig") EvidenceOutServiceConfig evidenceOutServiceConfig, @ModelAttribute("appService") AppService appService, @RequestParam(required = false, value = "id1") Long id1, @RequestParam(required = false, value = "type1") Integer type1, @RequestParam(required = false, value = "keyword1") String keyword1, @RequestParam(required = false, value = "page1") String page1, @RequestParam(required = false, value = "distanceToLeft1") String distanceToLeft1, @RequestParam(required = false, value = "distanceToDown1") String distanceToDown1, @RequestParam(required = false, value = "heightOfImage1") String heightOfImage1, @RequestParam(required = false, value = "widthOfImage1") String widthOfImage1, @RequestParam(required = false, value = "id2") Long id2, @RequestParam(required = false, value = "type2") Integer type2, @RequestParam(required = false, value = "keyword2") String keyword2, @RequestParam(required = false, value = "page2") String page2, @RequestParam(required = false, value = "distanceToLeft2") String distanceToLeft2, @RequestParam(required = false, value = "distanceToDown2") String distanceToDown2, @RequestParam(required = false, value = "heightOfImage2") String heightOfImage2, @RequestParam(required = false, value = "widthOfImage2") String widthOfImage2, @RequestParam(required = false, value = "id3") Long id3, @RequestParam(required = false, value = "type3") Integer type3, @RequestParam(required = false, value = "keyword3") String keyword3, @RequestParam(required = false, value = "page3") String page3, @RequestParam(required = false, value = "distanceToLeft3") String distanceToLeft3, @RequestParam(required = false, value = "distanceToDown3") String distanceToDown3, @RequestParam(required = false, value = "heightOfImage3") String heightOfImage3, @RequestParam(required = false, value = "widthOfImage3") String widthOfImage3, BindingResult bindingResult, Model uiModel, HttpServletRequest httpServletRequest) {
if (bindingResult.hasErrors()) {
Map<String, Object> param = new HashMap<String, Object>();
param.put("id", evidenceOutServiceConfig.getId());
List<Map<String, Object>> outServiceConfig = outServiceConfigService.selectOutServiceConfigByList(param);
uiModel.addAttribute("outServiceConfig", outServiceConfig.get(0));
// 得到对应的签章位置配置信息
List<EvidenceSignetPlaceConfig> signetPlaceConfigList = signetPlaceConfigService.selectSignetPlaceConfigByList(evidenceOutServiceConfig.getId());
for (int i = 0; i < signetPlaceConfigList.size(); i++) {
uiModel.addAttribute("signetPlaceConfig_" + (i + 1), signetPlaceConfigList.get(i));
}
List<EvidenceOutTemplate> outTemplateList = outServiceConfigService.selectOutTemplateByList();
uiModel.addAttribute("outTemplateList", outTemplateList);
List<EvidenceCertificate> certificateList = certificateService.getSignatureList();
uiModel.addAttribute("certificateList", certificateList);
return "outserviceconfig/update";
}
if (evidenceOutServiceConfig.getOutWay() == 0) {
evidenceOutServiceConfig.setOutWay(null);
}
if (evidenceOutServiceConfig.getOutReportTemplate() == 0) {
evidenceOutServiceConfig.setOutReportTemplate(null);
}
if (evidenceOutServiceConfig.getSaveRetTemplate() == 0) {
evidenceOutServiceConfig.setSaveRetTemplate(null);
}
if (evidenceOutServiceConfig.getEvidenceCertificate() == 0) {
evidenceOutServiceConfig.setEvidenceCertificate(null);
}
EvidenceSignetPlaceConfig signetPlaceConfigOne = null;
EvidenceSignetPlaceConfig signetPlaceConfigTwo = null;
EvidenceSignetPlaceConfig signetPlaceConfigThree = null;
if (type1 != null && type1 != 0) {
if (id1 != null) {
signetPlaceConfigOne = signetPlaceConfigService.selectById(id1);
} else {
signetPlaceConfigOne = new EvidenceSignetPlaceConfig();
}
signetPlaceConfigOne.setType(type1);
signetPlaceConfigOne.setKeyword(keyword1);
signetPlaceConfigOne.setPage(page1);
signetPlaceConfigOne.setDistanceToLeft(distanceToLeft1);
signetPlaceConfigOne.setDistanceToDown(distanceToDown1);
signetPlaceConfigOne.setHeightOfImage(heightOfImage1);
signetPlaceConfigOne.setWidthOfImage(widthOfImage1);
} else {
if (id1 != null) {
sqlSession.delete("com.itrus.portal.db.EvidenceSignetPlaceConfigMapper.deleteByPrimaryKey", id1);
}
}
if (type2 != null && type2 != 0) {
if (id2 != null) {
signetPlaceConfigTwo = signetPlaceConfigService.selectById(id2);
} else {
signetPlaceConfigTwo = new EvidenceSignetPlaceConfig();
}
signetPlaceConfigTwo.setType(type2);
signetPlaceConfigTwo.setKeyword(keyword2);
signetPlaceConfigTwo.setPage(page2);
signetPlaceConfigTwo.setDistanceToLeft(distanceToLeft2);
signetPlaceConfigTwo.setDistanceToDown(distanceToDown2);
signetPlaceConfigTwo.setHeightOfImage(heightOfImage2);
signetPlaceConfigTwo.setWidthOfImage(widthOfImage2);
} else {
if (id2 != null) {
sqlSession.delete("com.itrus.portal.db.EvidenceSignetPlaceConfigMapper.deleteByPrimaryKey", id2);
}
}
if (type3 != null && type3 != 0) {
if (id3 != null) {
signetPlaceConfigThree = signetPlaceConfigService.selectById(id3);
} else {
signetPlaceConfigThree = new EvidenceSignetPlaceConfig();
}
signetPlaceConfigThree.setType(type3);
signetPlaceConfigThree.setKeyword(keyword3);
signetPlaceConfigThree.setPage(page3);
signetPlaceConfigThree.setDistanceToLeft(distanceToLeft3);
signetPlaceConfigThree.setDistanceToDown(distanceToDown3);
signetPlaceConfigThree.setHeightOfImage(heightOfImage3);
signetPlaceConfigThree.setWidthOfImage(widthOfImage3);
} else {
if (id3 != null) {
sqlSession.delete("com.itrus.portal.db.EvidenceSignetPlaceConfigMapper.deleteByPrimaryKey", id3);
}
}
outServiceConfigService.updateOutServiceConfigeService(evidenceOutServiceConfig, appService, signetPlaceConfigOne, signetPlaceConfigTwo, signetPlaceConfigThree, getAdmin().getId());
String oper = "修改出证服务";
String info = "出证服务名称: " + appService.getAppServiceName();
LogUtil.evidencelog(sqlSession, null, oper, info);
return "redirect:outserviceconfig/" + evidenceOutServiceConfig.getId();
}
Also used :
EvidenceSignetPlaceConfig(com.itrus.portal.db.EvidenceSignetPlaceConfig)
HashMap(java.util.HashMap)
EvidenceCertificate(com.itrus.portal.db.EvidenceCertificate)
EvidenceOutTemplate(com.itrus.portal.db.EvidenceOutTemplate)
HashMap(java.util.HashMap)
Map(java.util.Map)
RequestMapping(org.springframework.web.bind.annotation.RequestMapping)
Example 10 with EvidenceOutTemplate
use of com.itrus.portal.db.EvidenceOutTemplate in project portal by ixinportal.
the class OutServiceConfigController method loadImg.
// 获得图片
@RequestMapping(value = "/img/{id}")
public String loadImg(@PathVariable("id") Long id, HttpServletResponse response) {
String img = null;
OutputStream os = null;
FileInputStream fis = null;
File file = null;
try {
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
EvidenceOutTemplate outTemplate = sqlSession.selectOne("com.itrus.portal.db.EvidenceOutServiceConfigMapper.selectByPrimaryKey", id);
if (outTemplate == null) {
return "status403";
}
img = outTemplate.getName();
file = filePathUtils.getBillFile(outTemplate.getFile());
if (img == null) {
return "status403";
}
if (!file.exists()) {
file.mkdir();
}
String imgPng = img + ".1.0.0.png";
File imgFile = new File(file, imgPng);
// 文件不存在
if (!imgFile.exists()) {
Pdf.pdf2png(new File(file, img).getPath());
}
fis = new FileInputStream(imgFile);
byte[] bb = IOUtils.toByteArray(fis);
os = response.getOutputStream();
os.write(bb);
os.flush();
} catch (IOException e) {
// 未找到
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
// 关闭流！
try {
if (null != fis) {
fis.close();
}
if (null != os) {
os.close();
}
} catch (IOException e) {
}
}
return null;
}
Also used :
OutputStream(java.io.OutputStream)
EvidenceOutTemplate(com.itrus.portal.db.EvidenceOutTemplate)
IOException(java.io.IOException)
File(java.io.File)
FileInputStream(java.io.FileInputStream)
IOException(java.io.IOException)
RequestMapping(org.springframework.web.bind.annotation.RequestMapping)
Aggregations
EvidenceOutTemplate (com.itrus.portal.db.EvidenceOutTemplate)11
RequestMapping (org.springframework.web.bind.annotation.RequestMapping)10
HashMap (java.util.HashMap)7
EvidenceBasicInformation (com.itrus.portal.db.EvidenceBasicInformation)6
EvidenceHisCertificate (com.itrus.portal.db.EvidenceHisCertificate)5
ArrayList (java.util.ArrayList)5
AppService (com.itrus.portal.db.AppService)4
EvidenceEnclosure (com.itrus.portal.db.EvidenceEnclosure)4
EvidenceEnclosureExample (com.itrus.portal.db.EvidenceEnclosureExample)4
EvidenceHisRelationship (com.itrus.portal.db.EvidenceHisRelationship)4
EvidenceMainInformation (com.itrus.portal.db.EvidenceMainInformation)4
EvidenceOutServiceConfig (com.itrus.portal.db.EvidenceOutServiceConfig)4
EvidenceOutServiceConfigExample (com.itrus.portal.db.EvidenceOutServiceConfigExample)4
List (java.util.List)4
Map (java.util.Map)4
EvidenceHisRelationshipExample (com.itrus.portal.db.EvidenceHisRelationshipExample)3
EvidenceSubjectIdentity (com.itrus.portal.db.EvidenceSubjectIdentity)3
EvidenceSubjectIdentityExample (com.itrus.portal.db.EvidenceSubjectIdentityExample)3
Calendar (java.util.Calendar)3
Date (java.util.Date)3
