use of com.itrus.portal.db.AppServiceAuthentication in project portal by ixinportal.
the class RealNameCordController method show.
// 显示详情
@RequestMapping(value = "/{id}", produces = "text/html")
public String show(@PathVariable("id") Long id, Model uiModel) {
RealNameRecord realName = realnameservice.selectById(id);
uiModel.addAttribute("realName", realName);
AppServiceAuthentication appServiceauthentication = appServiceAuthenticationService.selectById(realName.getAppServiceAuthentication());
uiModel.addAttribute("appServiceauthentication", appServiceauthentication);
AppService appService = appServiceImpl.selectById(appServiceauthentication.getAppService());
uiModel.addAttribute("appService", appService);
/*
* LicenseinformationExample licensecriteria = new
* LicenseinformationExample(); LicenseinformationExample.Criteria
* licenseinformation=licensecriteria.or();
* licenseinformation.andRealNameRecordEqualTo(id);
* List<Licenseinformation> sysRess= sqlSession.selectList(
* "com.itrus.portal.db.LicenseinformationMapper.selectByExample",
* licensecriteria);
*/
Licenseinformation licen = sqlSession.selectOne("com.itrus.portal.db.LicenseinformationMapper.selectByPrimaryKey", realName.getLicenseinformation());
String ss = appServiceauthentication.getServiceAuthenticationItem();
/*
* OrganizationExample organition = new OrganizationExample();
* OrganizationExample.Criteria organitonex=organition.or();
* organitonex.andRealNameRecordEqualTo(id); List<Organization> organ=
* sqlSession.selectList(
* "com.itrus.portal.db.OrganizationMapper.selectByExample",
* organition);
*/
Organization orgen = sqlSession.selectOne("com.itrus.portal.db.OrganizationMapper.selectByPrimaryKey", realName.getOrganization());
/*
* CorporateinformationExample corporatein = new
* CorporateinformationExample(); CorporateinformationExample.Criteria
* corporateinform=corporatein.or();
* corporateinform.andRealNameRecordEqualTo(id);
* List<Corporateinformation> cor= sqlSession.selectList(
* "com.itrus.portal.db.CorporateinformationMapper.selectByExample",
* corporatein);
*/
Corporateinformation core = sqlSession.selectOne("com.itrus.portal.db.CorporateinformationMapper.selectByPrimaryKey", realName.getCorporateinformation());
/*
* AgentinformationExample agentinformation = new
* AgentinformationExample(); AgentinformationExample.Criteria
* agentincrite=agentinformation.or();
* agentincrite.andRealNameRecordEqualTo(id); List<Agentinformation> age
* = null; age= sqlSession.selectList(
* "com.itrus.portal.db.AgentinformationMapper.selectByExample",
* agentinformation);
*/
Agentinformation agee = sqlSession.selectOne("com.itrus.portal.db.AgentinformationMapper.selectByPrimaryKey", realName.getAgentinformation());
/*
* EnterprisebankExample enterise = new EnterprisebankExample();
* EnterprisebankExample.Criteria enterpr=enterise.or();
* enterpr.andRealNameRecordEqualTo(id); List<Enterprisebank> ent=
* sqlSession.selectList(
* "com.itrus.portal.db.EnterprisebankMapper.selectByExample",
* enterise);
*/
Enterprisebank entt = sqlSession.selectOne("com.itrus.portal.db.EnterprisebankMapper.selectByPrimaryKey1", realName.getEnterprisebank());
if (null != ss && "" != ss) {
if (ss.indexOf("1") != -1) {
uiModel.addAttribute("licenseinformation", licen);
} else {
uiModel.addAttribute("licenseinformation", 1);
}
if (ss.indexOf("2") != -1) {
uiModel.addAttribute("organition", orgen);
} else {
uiModel.addAttribute("organition", 1);
}
if (ss.indexOf("3") != -1) {
uiModel.addAttribute("corporateinformation", core);
} else {
uiModel.addAttribute("corporateinformation", 1);
}
if (ss.indexOf("4") != -1) {
uiModel.addAttribute("corporateinformatio", core);
} else {
uiModel.addAttribute("corporateinformatio", 1);
}
if (ss.indexOf("5") != -1) {
uiModel.addAttribute("agentinformation", agee);
} else {
uiModel.addAttribute("agentinformation", 1);
}
if (ss.indexOf("6") != -1) {
uiModel.addAttribute("agentinformatio", agee);
} else {
uiModel.addAttribute("agentinformatio", 1);
}
if (ss.indexOf("7") != -1) {
uiModel.addAttribute("enterprise", entt);
} else if (ss.indexOf("8") != -1) {
uiModel.addAttribute("enterprise", entt);
} else {
uiModel.addAttribute("enterprise", 1);
}
}
ApplicationInfo applicationInfo = applicationInfoService.selectById(realName.getApplicationInfo());
uiModel.addAttribute("applicationInfo", applicationInfo);
return "realnamerecord/show";
}
use of com.itrus.portal.db.AppServiceAuthentication in project portal by ixinportal.
the class AppServiceAuthenticationController method delete.
// 删除处理
@RequestMapping(value = "/{id}", method = RequestMethod.DELETE, produces = "text/html")
@ResponseBody
public String delete(@PathVariable("id") Long id, HttpServletRequest request, Model uiModel) {
AppServiceAuthentication appServiceAuthentication = appServiceAuthenticationService.selectById(id);
if (appServiceAuthentication == null) {
// uiModel.addAttribute("message", "未找到要删除的实名认证服务");
return "未找到要删除的实名认证服务";
}
AppService appService = appServiceImpl.selectById(appServiceAuthentication.getAppService());
int count = appServiceImpl.selectAppInfoConuntById(appService.getId());
if (count > 0) {
// uiModel.addAttribute("message", "此条服务与计费配置存在关联,不能删除");
return "此条服务与计费配置存在关联,不能删除";
}
try {
appServiceAuthenticationService.deleteAppServiceAuthentication(appService.getId(), appServiceAuthentication.getId());
String oper = "删除实名认证服务(企业)";
String info = "实名认证服务名称: " + appService.getAppServiceName();
LogUtil.adminlog(sqlSession, oper, info);
return null;
} catch (Exception e) {
// + "】存在关联,无法删除");
return "要删除应用【" + appService.getAppServiceName() + "】存在关联,无法删除";
}
}
use of com.itrus.portal.db.AppServiceAuthentication in project portal by ixinportal.
the class BasicInformationController method show1.
/**
* 身份认证详情
*
* @param id
* @param uiModel
* @return
*/
@RequestMapping(value = "/identity/{id}", produces = "text/html")
public String show1(@PathVariable("id") Long id, Model uiModel) {
// 得到证据详情
EvidenceBasicInformation basicinfor = sqlSession.selectOne("com.itrus.portal.db.EvidenceBasicInformationMapper.selectByPrimaryKey", id);
List<EvidenceMainInformation> mlist = new ArrayList<EvidenceMainInformation>();
// 得到主体身份信息
EvidenceSubjectIdentityExample subjectExample = new EvidenceSubjectIdentityExample();
EvidenceSubjectIdentityExample.Criteria identity = subjectExample.createCriteria();
identity.andBasicInformationEqualTo(basicinfor.getEvidenceSn());
List<EvidenceSubjectIdentity> subjectIdentity = sqlSession.selectList("com.itrus.portal.db.EvidenceSubjectIdentityMapper.selectByExample", subjectExample);
for (int i = 0; i < subjectIdentity.size(); i++) {
// 得到主体信息
/*List<EvidenceMainInformation> mainInfo = sqlSession.selectList(
"com.itrus.portal.db.EvidenceMainInformationMapper.selectByPrimaryKey",
subjectIdentity.get(i).getMainInformation());*/
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));
}
// mlist.add(mainInfo);
}
// 得到身份意愿鉴别
EvidenceDesireIdentifyExample desireid = new EvidenceDesireIdentifyExample();
EvidenceDesireIdentifyExample.Criteria desireidentitfy = desireid.createCriteria();
desireidentitfy.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
EvidenceDesireIdentify desire = sqlSession.selectOne("com.itrus.portal.db.EvidenceDesireIdentifyMapper.selectByExample", desireid);
// 得到证据附件信息,用于查询服务委托人等信息
EvidenceEnclosureExample enclou = new EvidenceEnclosureExample();
EvidenceEnclosureExample.Criteria sure = enclou.createCriteria();
// sure.andBasicInformationEqualTo(id);
sure.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
sure.andPdfTypeEqualTo("1");
EvidenceEnclosure enclosure = sqlSession.selectOne("com.itrus.portal.db.EvidenceEnclosureMapper.selectByExample", enclou);
if (enclosure != null) {
// 服务委托人签名信息
EvidenceClientSignatureExample client = new EvidenceClientSignatureExample();
EvidenceClientSignatureExample.Criteria signat = client.createCriteria();
signat.andEvidenceSnEqualTo(enclosure.getEvidenceSn());
signat.andNameEqualTo("0");
EvidenceClientSignature cliensig = sqlSession.selectOne("com.itrus.portal.db.EvidenceClientSignatureMapper.selectByExample", client);
// 天威签名信息
EvidenceClientSignatureExample cilentsign = new EvidenceClientSignatureExample();
EvidenceClientSignatureExample.Criteria signature = cilentsign.createCriteria();
signature.andEvidenceSnEqualTo(enclosure.getEvidenceSn());
signature.andNameEqualTo("1");
EvidenceClientSignature cilentsignature = sqlSession.selectOne("com.itrus.portal.db.EvidenceClientSignatureMapper.selectByExample", cilentsign);
if (cilentsignature != null) {
// 天威证书信息
/*EvidenceCertExample certE = new EvidenceCertExample();
EvidenceCertExample.Criteria evidenceCertE = certE.createCriteria();
evidenceCertE.andClientSignatureEqualTo(cilentsignature.getId());*/
EvidenceCert oneCert = sqlSession.selectOne("com.itrus.portal.db.EvidenceCertMapper.selectByPrimaryKey", cilentsignature.getCertId());
// 天威核验信息
EvidenceCheckExample checkE = new EvidenceCheckExample();
EvidenceCheckExample.Criteria evidenceCheckE = checkE.createCriteria();
evidenceCheckE.andClientSignatureEqualTo(cilentsignature.getId());
EvidenceCheck oneCheck = sqlSession.selectOne("com.itrus.portal.db.EvidenceCheckMapper.selectByExample", checkE);
// 天威证书信息
uiModel.addAttribute("oneCert", oneCert);
// 天威核验信息
uiModel.addAttribute("oneCheck", oneCheck);
}
// 服务委托人时间戳信息
EvidenceClientTimeStampExample clientTime = new EvidenceClientTimeStampExample();
EvidenceClientTimeStampExample.Criteria stamp = clientTime.createCriteria();
stamp.andEvidenceSnEqualTo(enclosure.getEvidenceSn());
stamp.andNameEqualTo("0");
EvidenceClientTimeStamp clientTimestamp = sqlSession.selectOne("com.itrus.portal.db.EvidenceClientTimeStampMapper.selectByExample", clientTime);
// 天威时间戳信息
EvidenceClientTimeStampExample tclientTime = new EvidenceClientTimeStampExample();
EvidenceClientTimeStampExample.Criteria tstamp = tclientTime.createCriteria();
tstamp.andEvidenceSnEqualTo(enclosure.getEvidenceSn());
tstamp.andNameEqualTo("1");
EvidenceClientTimeStamp tclientTimestamp = sqlSession.selectOne("com.itrus.portal.db.EvidenceClientTimeStampMapper.selectByExample", tclientTime);
EvidenceCheck listCheck = new EvidenceCheck();
List<EvidenceCert> listCert = new ArrayList<EvidenceCert>();
if (cliensig != null && cliensig.getId() != null) {
// 服务委托人证书信息
/*EvidenceCertExample certEx = new EvidenceCertExample();
EvidenceCertExample.Criteria evidenceCert = certEx.createCriteria();
evidenceCert.andClientSignatureEqualTo(cliensig.getId());*/
listCert = sqlSession.selectList("com.itrus.portal.db.EvidenceCertMapper.selectByPrimaryKey", cliensig.getCertId());
// 服务委托人核验信息
EvidenceCheckExample checkEx = new EvidenceCheckExample();
EvidenceCheckExample.Criteria evidenceCheck = checkEx.createCriteria();
evidenceCheck.andClientSignatureEqualTo(cliensig.getId());
listCheck = sqlSession.selectOne("com.itrus.portal.db.EvidenceCheckMapper.selectByExample", checkEx);
}
Map<Long, EvidenceCheck> mapCheck = new HashMap<Long, EvidenceCheck>();
// 服务委托人证书核验信息
for (EvidenceCert c : listCert) {
EvidenceCheckExample certcheckEx = new EvidenceCheckExample();
EvidenceCheckExample.Criteria certCheck = certcheckEx.createCriteria();
certCheck.andEvidenceCertEqualTo(c.getId());
EvidenceCheck listCertCheck = sqlSession.selectOne("com.itrus.portal.db.EvidenceCheckMapper.selectByExample", certcheckEx);
mapCheck.put(c.getId(), listCertCheck);
}
// 服务委托人证书信息
uiModel.addAttribute("listCert", listCert);
// 服务委托人核验信息
uiModel.addAttribute("listCheck", listCheck);
// 服务委托人证书核验信息
uiModel.addAttribute("mapCheck", mapCheck);
// 服务委托人签名信息
uiModel.addAttribute("cliensig", cliensig);
// 天威签名信息
uiModel.addAttribute("cilentsignature", cilentsignature);
// 服务委托人时间戳信息
uiModel.addAttribute("clientTimestamp", clientTimestamp);
// 天威时间戳信息
uiModel.addAttribute("tclientTimestamp", tclientTimestamp);
}
// 身份实名认证信息
EvidenceRealNameExample realnameE = new EvidenceRealNameExample();
EvidenceRealNameExample.Criteria realnameEx = realnameE.createCriteria();
// realnameEx.andMainInformationEqualTo(m.getId());
// realnameEx.andBasicInformationEqualTo(id);
realnameEx.andEvidenceSnEqualTo(basicinfor.getEvidenceSn());
EvidenceRealName erealname = sqlSession.selectOne("com.itrus.portal.db.EvidenceRealNameMapper.selectByExample", realnameE);
Map<Long, AppService> rappService = new HashMap<Long, AppService>();
if (erealname != null) {
uiModel.addAttribute("erealname", erealname);
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 companiesSubmit = sqlSession.selectOne("com.itrus.portal.db.EvidenceCompaniesSubmitMapper.selectByExample", evidenceCompanies);
if (companiesSubmit != null && companiesSubmit.getRepresentative() != null) {
// 法定代表人
EvidenceRepresentativeExample representaioce = new EvidenceRepresentativeExample();
EvidenceRepresentativeExample.Criteria evidenceRepresent = representaioce.createCriteria();
evidenceRepresent.andIdCodeEqualTo(companiesSubmit.getRepresentative());
EvidenceRepresentative representative = sqlSession.selectOne("com.itrus.portal.db.EvidenceRepresentativeMapper.selectByExample", representaioce);
uiModel.addAttribute("representative", representative);
}
if (companiesSubmit != null && companiesSubmit.getTheAgent() != null) {
// 代理人
EvidenceTheAgentExample evidenceTheAgent = new EvidenceTheAgentExample();
EvidenceTheAgentExample.Criteria theAgentEx = evidenceTheAgent.createCriteria();
theAgentEx.andIdCodeEqualTo(companiesSubmit.getTheAgent());
EvidenceTheAgent theagent = sqlSession.selectOne("com.itrus.portal.db.EvidenceTheAgentMapper.selectByExample", evidenceTheAgent);
uiModel.addAttribute("theagent", theagent);
}
uiModel.addAttribute("companiesSubmit", companiesSubmit);
} else {
// 天威
EvidenceIndividualExample evidenceIndividual = new EvidenceIndividualExample();
EvidenceIndividualExample.Criteria individual = evidenceIndividual.createCriteria();
individual.andIdCodeEqualTo(erealname.getIndividual());
EvidenceIndividual indiv = sqlSession.selectOne("com.itrus.portal.db.EvidenceIndividualMapper.selectByExample", evidenceIndividual);
uiModel.addAttribute("indiv", indiv);
}
} 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);
for (RealNameRecord real : listReal) {
AppServiceAuthentication authent = sqlSession.selectOne("com.itrus.portal.db.AppServiceAuthenticationMapper.selectByPrimaryKey", real.getAppServiceAuthentication());
// 得到服务编码
AppService appservice = appService.selectById(authent.getAppService());
rappService.put(real.getId(), appservice);
}
// 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);
uiModel.addAttribute("listPersonal", listPersonal);
// personalName.put(m.getId(), listPersonal);
}
}
}
uiModel.addAttribute("enclosure", enclosure);
uiModel.addAttribute("rappService", rappService);
uiModel.addAttribute("listReal", listReal);
uiModel.addAttribute("desire", desire);
uiModel.addAttribute("mainInfo", mlist);
uiModel.addAttribute("basicinfor", basicinfor);
return "basicinformation/show1";
}
use of com.itrus.portal.db.AppServiceAuthentication in project portal by ixinportal.
the class AppServiceAuthenticationServiceImpl method updateAppServiceAuthentication.
/**
* 修改实名认证服务
* @param appServiceAuthentication
* @param appService
* @param id
* @return
*/
public void updateAppServiceAuthentication(AppServiceAuthentication appServiceAuthentication, AppService appService, Long id) {
DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
TransactionStatus status = transactionManager.getTransaction(def);
try {
// 修改实名认证服务配置表
AppServiceAuthentication appServiceAuthentication0 = selectById(appServiceAuthentication.getId());
appServiceAuthentication.setAppService(appServiceAuthentication0.getAppService());
sqlSession.update("com.itrus.portal.db.AppServiceAuthenticationMapper.updateByPrimaryKey", appServiceAuthentication);
// 修改应用服务表
AppService appService0 = appServiceImpl.selectById(appService.getId());
appService.setCreator(appService0.getCreator());
appService.setCreateTime(appService0.getCreateTime());
appService.setType(appService0.getType());
appService.setServiceConfigName(appService0.getServiceConfigName());
appService.setServiceConfigId(appService0.getServiceConfigId());
appService.setModifyTime(new Date());
appService.setModifier(id);
appService.setIsDelete(appService0.getIsDelete());
sqlSession.update("com.itrus.portal.db.AppServiceMapper.updateByPrimaryKey", appService);
transactionManager.commit(status);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
if (!status.isCompleted())
transactionManager.rollback(status);
}
}
Aggregations