use of com.itrus.portal.db.PersonalServiceAuthentication in project portal by ixinportal.
the class PersonalNameController method show.
// 显示详情
@RequestMapping(value = "/{id}", produces = "text/html")
public String show(@PathVariable("id") Long id, Model uiModel) {
PersonalName personalname = personalnameservice.selectById(id);
uiModel.addAttribute("personalname", personalname);
// uiModel.addAttribute("personalname", personalname);
PersonalServiceAuthentication peraonalservice = personalServiceAuthenticationService.selectById(personalname.getPersonalServiceAuthentication());
String ss = peraonalservice.getServiceAuthenticationItem();
String sdk = peraonalservice.getServiceAuthenticationSdkItem();
uiModel.addAttribute("peraonalservice", peraonalservice);
AppService appService = appServiceImpl.selectById(peraonalservice.getAppService());
uiModel.addAttribute("appService", appService);
Bankcardelements bank = sqlSession.selectOne("com.itrus.portal.db.BankcardelementsMapper.selectByPrimaryKey", personalname.getBankcardelements());
FaceMatching facemat = null;
FaceMatching facema = null;
FaceMatching faceMatchin = null;
List<FaceMatching> faceMatching = null;
FaceMatchingExample face = new FaceMatchingExample();
FaceMatchingExample.Criteria faceMat = face.createCriteria();
faceMat.andPersonalNameEqualTo(personalname.getId());
faceMatching = sqlSession.selectList("com.itrus.portal.db.FaceMatchingMapper.selectByExample", face);
if (faceMatching != null && faceMatching.size() >= 1) {
facema = faceMatching.get(0);
}
if (faceMatching != null && faceMatching.size() >= 2) {
facemat = faceMatching.get(1);
} else if (facema != null) {
FaceMatchingExample faceM = new FaceMatchingExample();
FaceMatchingExample.Criteria faceMat1 = faceM.createCriteria();
faceMat1.andPhotoTypeEqualTo(0);
faceMat1.andCreateTimeLessThanOrEqualTo(facema.getCreateTime());
faceMat1.andPersonIdEqualTo(facema.getPersonId());
if (facema.getSource().equals("6")) {
faceMat1.andSourceEqualTo("3");
}
faceMat1.andBelievableFaceIsNotNull();
faceM.setOrderByClause("create_time desc");
faceM.setLimit(1);
faceMatchin = sqlSession.selectOne("com.itrus.portal.db.FaceMatchingMapper.selectByExample", faceM);
}
if (ss != null && ss != "") {
// 银行卡3,4要素
if (ss.indexOf("4") != -1 || ss.indexOf("5") != -1) {
uiModel.addAttribute("organition", bank);
} else {
uiModel.addAttribute("organition", 1);
}
// 身份证人像核验
if (ss.indexOf("2") != -1) {
uiModel.addAttribute("personal", 1);
}
if (ss.indexOf("3") != -1) {
if (faceMatching != null && faceMatching.size() >= 1) {
if (facema.getPhotoType() != 0) {
uiModel.addAttribute("face", facemat);
} else {
uiModel.addAttribute("face", facema);
}
}
} else {
uiModel.addAttribute("face", 1);
}
if (ss.indexOf("6") != -1 || ss.indexOf("7") != -1) {
if (faceMatching != null && faceMatching.size() >= 1) {
if (facema.getPhotoType() == 0) {
uiModel.addAttribute("faceM", facema);
} else if (facema.getPhotoType() == 1) {
uiModel.addAttribute("faceM1", facema);
}
}
/*System.out.println(facema.getId());
System.out.println(facemat.getId());*/
if (faceMatching != null && faceMatching.size() >= 2) {
if (facemat.getPhotoType() == 0) {
uiModel.addAttribute("faceM", facemat);
} else if (facemat.getPhotoType() == 1) {
uiModel.addAttribute("faceM1", facemat);
}
} else {
uiModel.addAttribute("faceMa", faceMatchin);
}
} else {
uiModel.addAttribute("faceM", 1);
}
// 身份证间项
if (ss.indexOf("1") != -1) {
uiModel.addAttribute("persona", 1);
}
}
// uiModel.addAttribute("face", faceMatching);
if (sdk != null && sdk != "") {
// 银行卡OCR
if (sdk.indexOf("3") != -1) {
uiModel.addAttribute("BankOCR", bank);
} else {
uiModel.addAttribute("BankOCR", 1);
}
// 身份证OCR
if (sdk.indexOf("1") != -1) {
uiModel.addAttribute("OCR", 1);
}
// 活体检验
if (sdk.indexOf("2") != -1) {
uiModel.addAttribute("HUO", 1);
}
}
ApplicationInfo applicationInfo = applicationInfoService.selectById(personalname.getApplicationInfo());
uiModel.addAttribute("applicationInfo", applicationInfo);
return "personalname/show";
}
use of com.itrus.portal.db.PersonalServiceAuthentication in project portal by ixinportal.
the class PersonalServiceAuthenticationController method delete.
// 删除处理
@RequestMapping(value = "/{id}", method = RequestMethod.DELETE, produces = "text/html")
@ResponseBody
public String delete(@PathVariable("id") Long id, HttpServletRequest request, Model uiModel) {
PersonalServiceAuthentication personalServiceAuthentication = personalServiceAuthenticationService.selectById(id);
if (personalServiceAuthentication == null) {
// uiModel.addAttribute("message", "未找到要删除的实名认证服务");
return "未找到要删除的实名认证服务";
}
AppService appService = appServiceImpl.selectById(personalServiceAuthentication.getAppService());
int count = appServiceImpl.selectAppInfoConuntById(appService.getId());
if (count > 0) {
// uiModel.addAttribute("message", "此条服务与计费配置存在关联,不能删除");
return "此条服务与计费配置存在关联,不能删除";
}
try {
personalServiceAuthenticationService.deleteAppServiceAuthentication(appService.getId(), personalServiceAuthentication.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.PersonalServiceAuthentication in project portal by ixinportal.
the class PersonalServiceAuthenticationController method show.
// 显示详情
@RequestMapping(value = "/{id}", produces = "text/html")
public String show(@PathVariable("id") Long id, Model uiModel) {
PersonalServiceAuthentication personalServiceAuthentication = personalServiceAuthenticationService.selectById(id);
uiModel.addAttribute("personalServiceAuthentication", personalServiceAuthentication);
AppService appService = appServiceImpl.selectById(personalServiceAuthentication.getAppService());
uiModel.addAttribute("appService", appService);
return "personalserviceauthentication/show";
}
use of com.itrus.portal.db.PersonalServiceAuthentication in project portal by ixinportal.
the class AuthenticationstatisticsController method list.
@RequestMapping(produces = "text/html")
public String list(@RequestParam(value = "applyname", required = false) String applyname, @RequestParam(value = "Statistics", required = false) Integer Statistics, @RequestParam(value = "year1", required = false) Integer year1, @RequestParam(value = "year2", required = false) Integer year2, @RequestParam(value = "page", required = false) Integer page, @RequestParam(value = "size", required = false) Integer size, @RequestParam(value = "serviceclass", required = false) Long serviceclass, @RequestParam(value = "appServiceName", required = false) String appServiceName, @RequestParam(value = "serviceAuthenticationItem", required = false) String serviceAuthenticationItem, @RequestParam(value = "serviceAuthentication", required = false) String serviceAuthentication, @RequestParam(value = "authenticationResultMessage", required = false) Integer authenticationResultMessage, @RequestParam(value = "checkNumber", required = false) Double checkNumber, Model uiModel) throws Exception {
Map param = new HashMap();
Map param2 = new HashMap();
Integer year3 = null;
if (year1 != null) {
year3 = year1;
}
List<Map<Integer, Integer>> list = new ArrayList<Map<Integer, Integer>>();
java.util.Date nowdate = new java.util.Date();
String[] monthList = { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12" };
String[] seasonList = { "S1", "S2", "S3", "S4" };
String month = null;
String season = null;
String year = null;
Calendar calendar = Calendar.getInstance();
Calendar calendar2 = Calendar.getInstance();
String applyname1 = null;
String serviceAuthentication11 = null;
List<Map> realNameList = new ArrayList<>();
if (null != Statistics && Statistics == 12) {
while (year1 <= year2) {
for (int j = 0; j <= 11; j++) {
calendar.set(Calendar.YEAR, year1);
calendar.set(Calendar.MONTH, j);
calendar.set(Calendar.DAY_OF_MONTH, 1);
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
calendar.set(Calendar.MILLISECOND, 0);
Date dt1 = calendar.getTime();
calendar2.set(Calendar.YEAR, year1);
calendar2.set(Calendar.MONTH, j + 1);
calendar2.set(Calendar.DAY_OF_MONTH, 1);
calendar2.set(Calendar.HOUR_OF_DAY, 0);
calendar2.set(Calendar.MINUTE, 0);
calendar2.set(Calendar.SECOND, 0);
calendar2.set(Calendar.MILLISECOND, 0);
Date dt2 = calendar2.getTime();
if (applyname != null && !"0".equals(applyname)) {
param.put("applyname", applyname);
}
if (StringUtils.isNotEmpty(appServiceName)) {
param.put("appServiceName", appServiceName);
}
if (serviceclass == 0) {
if (serviceAuthenticationItem != null && !"0".equals(serviceAuthenticationItem)) {
param.put("serviceAuthenticationItem", "%" + serviceAuthenticationItem + "%");
}
} else if (serviceclass == 1) {
if (serviceAuthentication != null && !"0".equals(serviceAuthentication)) {
param.put("serviceAuthenticationItem", "%" + serviceAuthentication + "%");
}
}
if (authenticationResultMessage != null && authenticationResultMessage >= 0) {
param.put("authenticationResultMessage", authenticationResultMessage);
} else {
param.put("authenticationResultMessage", null);
}
if (checkNumber != null && checkNumber > 0) {
param.put("checkNumber", checkNumber);
} else {
param.put("checkNumber", null);
}
if (serviceclass >= 0) {
param.put("serviceclass", serviceclass);
}
param.put("serviceclass", null);
month = year1 + "-" + monthList[j];
param2.put("month", month);
param.put("queryDate1", dt1);
param.put("queryDate2", dt2);
Integer count1 = null;
Integer count = null;
if (serviceclass == 0) {
count = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
realNameList = realNameService.selectListByRealNameRecordEnt1(param);
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 1) {
count = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
realNameList = personalNameService.selectListByRealNameRecordEnt1(param);
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 2) {
Integer rcount1 = null;
Integer rcount = null;
Integer pcount1 = null;
Integer pcount = null;
rcount = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
rcount1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
pcount = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
pcount1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
count = rcount + pcount;
count1 = rcount1 + pcount1;
}
Map<Integer, Integer> map = new HashMap<Integer, Integer>();
map.put(1, year1);
map.put(2, count);
map.put(3, count1);
list.add(map);
// }
}
year1++;
}
}
if (null != Statistics && Statistics == 4) {
while (year1 <= year2) {
for (int j = 0; j <= 9; j = j + 3) {
calendar.set(Calendar.YEAR, year1);
calendar.set(Calendar.MONTH, j);
calendar.set(Calendar.DAY_OF_MONTH, 1);
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
calendar.set(Calendar.MILLISECOND, 0);
Date dt1 = calendar.getTime();
calendar2.set(Calendar.YEAR, year1);
calendar2.set(Calendar.MONTH, j + 3);
calendar2.set(Calendar.DAY_OF_MONTH, 1);
calendar2.set(Calendar.HOUR_OF_DAY, 0);
calendar2.set(Calendar.MINUTE, 0);
calendar2.set(Calendar.SECOND, 0);
calendar2.set(Calendar.MILLISECOND, 0);
Date dt2 = calendar2.getTime();
if (applyname != null && !"0".equals(applyname)) {
param.put("applyname", applyname);
}
if (StringUtils.isNotEmpty(appServiceName)) {
param.put("appServiceName", appServiceName);
}
if (serviceAuthenticationItem != null && !"0".equals(serviceAuthenticationItem)) {
param.put("serviceAuthenticationItem", "%" + serviceAuthenticationItem + "%");
} else {
param.put("serviceAuthenticationItem", null);
}
if (authenticationResultMessage != null && authenticationResultMessage >= 0) {
param.put("authenticationResultMessage", authenticationResultMessage);
} else {
param.put("authenticationResultMessage", null);
}
if (checkNumber != null && checkNumber > 0) {
param.put("checkNumber", checkNumber);
} else {
param.put("checkNumber", null);
}
if (serviceclass >= 0) {
param.put("serviceclass", serviceclass);
}
param.put("serviceclass", null);
season = year1 + "-" + monthList[j / 3];
param2.put("season", season);
param.put("queryDate1", dt1);
param.put("queryDate2", dt2);
Integer count1 = null;
Integer count = null;
if (serviceclass == 0) {
count = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
realNameList = realNameService.selectListByRealNameRecordEnt1(param);
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 1) {
count = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
realNameList = personalNameService.selectListByRealNameRecordEnt1(param);
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 2) {
Integer rcount1 = null;
Integer rcount = null;
Integer pcount1 = null;
Integer pcount = null;
rcount = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
rcount1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
pcount = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
pcount1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
count = rcount + pcount;
count1 = rcount1 + pcount1;
}
Map<Integer, Integer> map = new HashMap<Integer, Integer>();
map.put(1, year1);
map.put(2, count);
map.put(3, count1);
list.add(map);
}
year1++;
}
}
if (null != Statistics && Statistics == 1) {
while (year1 <= year2) {
calendar.set(Calendar.YEAR, year1);
calendar.set(Calendar.MONTH, 0);
calendar.set(Calendar.DAY_OF_MONTH, 1);
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
calendar.set(Calendar.MILLISECOND, 0);
Date dt1 = calendar.getTime();
calendar2.set(Calendar.YEAR, year1 + 1);
calendar2.set(Calendar.MONTH, 0);
calendar2.set(Calendar.DAY_OF_MONTH, 1);
calendar2.set(Calendar.HOUR_OF_DAY, 0);
calendar2.set(Calendar.MINUTE, 0);
calendar2.set(Calendar.SECOND, 0);
calendar2.set(Calendar.MILLISECOND, 0);
Date dt2 = calendar2.getTime();
if (applyname != null && !"0".equals(applyname)) {
param.put("applyname", applyname);
}
if (StringUtils.isNotEmpty(appServiceName)) {
param.put("appServiceName", appServiceName);
}
if (serviceAuthenticationItem != null && !"0".equals(serviceAuthenticationItem)) {
param.put("serviceAuthenticationItem", "%" + serviceAuthenticationItem + "%");
} else {
param.put("serviceAuthenticationItem", null);
}
if (authenticationResultMessage != null && authenticationResultMessage >= 0) {
param.put("authenticationResultMessage", authenticationResultMessage);
} else {
param.put("authenticationResultMessage", null);
}
if (checkNumber != null && checkNumber > 0) {
param.put("checkNumber", checkNumber);
} else {
param.put("checkNumber", null);
}
if (serviceclass >= 0) {
param.put("serviceclass", serviceclass);
}
param.put("serviceclass", null);
year = year + "Y";
param2.put("year", year);
param.put("queryDate1", dt1);
param.put("queryDate2", dt2);
Integer count1 = null;
Integer count = null;
if (serviceclass == 0) {
count = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
realNameList = realNameService.selectListByRealNameRecordEnt1(param);
if (!"0".equals(serviceAuthenticationItem)) {
for (int j = 0; j < realNameList.size(); j++) {
serviceAuthenticationItem = realNameList.get(j).get("service_authentication_item").toString();
}
}
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 1) {
count = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
count1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
realNameList = personalNameService.selectListByRealNameRecordEnt1(param);
// uiModel.addAttribute("RealNameList", RealNameList);
} else if (serviceclass == 2) {
Integer rcount1 = null;
Integer rcount = null;
Integer pcount1 = null;
Integer pcount = null;
rcount = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod", param);
rcount1 = sqlSession.selectOne("com.itrus.portal.db.RealNameRecordMapper.selectCountByPeriod1", param);
pcount = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod", param);
pcount1 = sqlSession.selectOne("com.itrus.portal.db.PersonalNameMapper.selectCountByPeriod1", param);
count = rcount + pcount;
count1 = rcount1 + pcount1;
}
Map<Integer, Integer> map = new HashMap<Integer, Integer>();
map.put(1, year1);
map.put(2, count);
map.put(3, count1);
list.add(map);
year1++;
}
}
List appservice = applicationInfoService.selectByExample(new ApplicationInfoExample());
uiModel.addAttribute("appservice", appservice);
if (null == applyname || "0".equals(applyname)) {
applyname = "所有应用";
}
Map param3 = new HashMap();
if (null == appServiceName || "" == appServiceName) {
appServiceName = "所有服务";
} else {
if ("0".equals(serviceAuthenticationItem) && "0".equals(serviceAuthentication) && checkNumber == 0.0 && authenticationResultMessage == -1) {
if (serviceclass == 0) {
param3.put("appServiceName", appServiceName);
AppServiceAuthentication appService = sqlSession.selectOne("com.itrus.portal.db.AppServiceAuthenticationMapper.selectByAppServiceAutToPersonal", param3);
if (appService != null) {
uiModel.addAttribute("appService", appService);
if (null != serviceAuthenticationItem || !"0".equals(serviceAuthenticationItem)) {
uiModel.addAttribute("serviceAuthenticationItem", serviceAuthenticationItem);
} else {
uiModel.addAttribute("serviceAuthenticationItem", 0);
}
} else {
uiModel.addAttribute("appService", 1);
}
} else if (serviceclass == 1) {
param3.put("appServiceName", appServiceName);
PersonalServiceAuthentication personalService = sqlSession.selectOne("com.itrus.portal.db.PersonalServiceAuthenticationMapper.selectByToPersonal", param3);
if (personalService != null) {
uiModel.addAttribute("personalService", personalService);
if (null != serviceAuthenticationItem || !"0".equals(serviceAuthenticationItem)) {
uiModel.addAttribute("serviceAuthenticationItem", serviceAuthenticationItem);
} else {
uiModel.addAttribute("serviceAuthenticationItem", 0);
}
} else {
uiModel.addAttribute("personalService", 1);
}
}
} else {
uiModel.addAttribute("appService", 1);
uiModel.addAttribute("personalService", 1);
}
}
uiModel.addAttribute("list", list);
// System.out.println(list);
uiModel.addAttribute("year1", year3);
uiModel.addAttribute("applyname1", applyname1);
uiModel.addAttribute("year2", year2);
uiModel.addAttribute("Statistics", Statistics);
uiModel.addAttribute("authenticationResultMessage", authenticationResultMessage);
uiModel.addAttribute("checkNumber", checkNumber);
uiModel.addAttribute("applyname", applyname);
uiModel.addAttribute("serviceclass", serviceclass);
uiModel.addAttribute("appServiceName", appServiceName);
if (null != serviceAuthenticationItem || !"0".equals(serviceAuthenticationItem)) {
uiModel.addAttribute("serviceAuthenticationItem", serviceAuthenticationItem);
} else {
uiModel.addAttribute("serviceAuthenticationItem", 0);
}
if (null != serviceAuthentication || !"0".equals(serviceAuthentication)) {
uiModel.addAttribute("serviceAuthentication", serviceAuthentication);
} else {
uiModel.addAttribute("serviceAuthentication", 0);
}
return "authenticationstatistics/list";
}
use of com.itrus.portal.db.PersonalServiceAuthentication in project portal by ixinportal.
the class AppServiceExtImpl method selectServiceObjectByAppServiceId.
/**
* 得到对应的服务配置
* @param appId
* 应用id
* @return
*/
public Object selectServiceObjectByAppServiceId(Long appId) {
AppServiceAuthenticationExample appServiceAuthenticationExample = new AppServiceAuthenticationExample();
AppServiceAuthenticationExample.Criteria aec = appServiceAuthenticationExample.createCriteria();
aec.andAppServiceEqualTo(appId);
AppServiceAuthentication appServiceAuthentication = sqlSession.selectOne("com.itrus.portal.db.AppServiceAuthenticationMapper.selectByExample", appServiceAuthenticationExample);
if (appServiceAuthentication != null) {
return appServiceAuthentication;
}
PersonalServiceAuthenticationExample personalServiceAuthenticationExample = new PersonalServiceAuthenticationExample();
PersonalServiceAuthenticationExample.Criteria pec = personalServiceAuthenticationExample.createCriteria();
pec.andAppServiceEqualTo(appId);
PersonalServiceAuthentication personalServiceAuthentication = sqlSession.selectOne("com.itrus.portal.db.PersonalServiceAuthenticationMapper.selectByExample", personalServiceAuthenticationExample);
if (personalServiceAuthentication != null) {
return personalServiceAuthentication;
}
return null;
}
Aggregations