package com.sp2p.action.admin;
import java.io.IOException;
import java.math.BigDecimal;
import java.net.URLDecoder;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Vector;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import net.sf.json.JSONObject;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import com.shove.Convert;
import com.shove.data.DataException;
import com.shove.util.SqlInfusion;
import com.shove.web.action.BasePageAction;
import com.shove.web.util.ExcelUtils;
import com.shove.web.util.JSONUtils;
import com.sp2p.constants.IAmountConstants;
import com.sp2p.constants.IConstants;
import com.sp2p.entity.Admin;
import com.sp2p.service.BeVipService;
import com.sp2p.service.RegionService;
import com.sp2p.service.UserService;
import com.sp2p.service.ValidateService;
import com.sp2p.service.admin.CountWorkStatusService;
@SuppressWarnings({ "serial", "unchecked", "rawtypes" })
public class ValidateAction extends BasePageAction {
public static Log log = LogFactory.getLog(ValidateAction.class);
private ValidateService validateService;
private UserService userService;
private RegionService regionService;
private CountWorkStatusService countWorkStatusService;
private BeVipService beVipService;
private long workPro;
private long cityId;
private List<Map<String, Object>> provinceList;
private List<Map<String, Object>> cityList;
@SuppressWarnings("unused")
private List<Map<String, Object>> areaList;
@SuppressWarnings("unused")
private List<Map<String, Object>> typeList;//
public void setCountWorkStatusService(CountWorkStatusService countWorkStatusService) {
this.countWorkStatusService = countWorkStatusService;
}
public List<Map<String, Object>> getProvinceList() {
return provinceList;
}
public void setProvinceList(List<Map<String, Object>> provinceList) {
this.provinceList = provinceList;
}
public List<Map<String, Object>> getCityList() {
return cityList;
}
public void setCityList(List<Map<String, Object>> cityList) {
this.cityList = cityList;
}
public void setRegionService(RegionService regionService) {
this.regionService = regionService;
}
public void setValidateService(ValidateService validateService) {
this.validateService = validateService;
}
public void setUserService(UserService userService) {
this.userService = userService;
}
public String queryWorkDataById() {
return SUCCESS;
}
public ValidateService getValidateService() {
return validateService;
}
public UserService getUserService() {
return userService;
}
/**
* 后台-> 个人基本信息审核列表 和 根据名字在去数据库统计//后台统计待审核的用户数量为 X 个。总的待审核的认证数量为XX个
*
* @return
* @throws SQLException
* @throws SQLException
* @throws DataException
* @throws DataException
*/
public String queryUserCredit() throws SQLException, DataException {
String userName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("userName")), null);
String realName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("realName")), null);
String adminName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("adminName")), null);
Integer auditStatus = Convert.strToInt(paramMap.get("auditStatus"), -1);
Integer certificateName = Convert.strToInt(paramMap.get("certificateName"), -1);
validateService.queryUserCredit(pageBean, userName, realName, auditStatus, adminName, certificateName);
List<Map<String, Object>> countList = null;
@SuppressWarnings("unused")
Map<String, String> byNamemap = null;
countList = validateService.queryUserCreditCount(userName, realName, auditStatus, adminName, certificateName);// 获取到这个集合上面pagebean的相同集合
@SuppressWarnings("unused")
Vector<Long> list = new Vector<Long>();
// 获取这个集合的username的值
long countAll = 0;// 待审核的认证数量为XX个
long userAll = 0;
boolean flag = false;
if (countList != null && countList.size() > 0) {
for (int i = 0; i < countList.size(); i++) {
int tmIdentityauditStatus = Convert.strToInt(
countList.get(i).get("tmIdentityauditStatus") == null ? "" : countList.get(i).get("tmIdentityauditStatus").toString(), 0);// 得到结果集
// fileUrl的值
int tmworkauditStatus = Convert.strToInt(
countList.get(i).get("tmworkauditStatus") == null ? "" : countList.get(i).get("tmworkauditStatus").toString(), 0);// 得到结果集
// fileUrl的值
int tmaddressauditStatus = Convert.strToInt(
countList.get(i).get("tmaddressauditStatus") == null ? "" : countList.get(i).get("tmaddressauditStatus").toString(), 0);// 得到结果集
// fileUrl的值
int tmresponseauditStatus = Convert.strToInt(
countList.get(i).get("tmresponseauditStatus") == null ? "" : countList.get(i).get("tmresponseauditStatus").toString(), 0);// 得到结果集
// fileUrl的值
int tmincomeeauditStatus = Convert.strToInt(
countList.get(i).get("tmincomeeauditStatus") == null ? "" : countList.get(i).get("tmincomeeauditStatus").toString(), 0);// 得到结果集
// fileUrl的值
if (tmIdentityauditStatus == 1) {
countAll++;
flag = true;
}
if (tmworkauditStatus == 1) {
countAll++;
flag = true;
}
if (tmaddressauditStatus == 1) {
countAll++;
flag = true;
}
if (tmresponseauditStatus == 1) {
countAll++;
flag = true;
}
if (tmincomeeauditStatus == 1) {
countAll++;
flag = true;
}
if (flag) {
userAll++;
}
flag = false;
}
}
request().setAttribute("byNamemap", countAll);
request().setAttribute("usercount", userAll);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 后台-> 个人信息审核列表
*/
public String queryPerUserCredit() throws SQLException {
Long userId = Convert.strToLong(request().getParameter("userId"), -1L);
validateService.queryPerUserCredit(pageBean, userId);
List<Map<String, Object>> list = pageBean.getPage();
if (list == null)
return SUCCESS;
// 必填认证
List<Map<String, Object>> must = new ArrayList<Map<String, Object>>();
// 财力(可选)认证
List<Map<String, Object>> fince = new ArrayList<Map<String, Object>>();
for (Map<String, Object> map : list) {
if (Convert.strToInt(map.get("sort") + "", 0) == 4) {// 可选认证
fince.add(map);
continue;
}
if (Convert.strToInt(map.get("sort") + "", 0) == 3) {// 必填认证
must.add(map);
continue;
}
if (Convert.strToInt(map.get("sort") + "", 0) == 2) {// 工作资料认证
request().setAttribute("workStatus", map.get("auditStatus"));
continue;
}
if (Convert.strToInt(map.get("sort") + "", 0) == 1) {// 基本个人资料认证
request().setAttribute("personStatus", map.get("auditStatus"));
continue;
}
}
request().setAttribute("must", must);
request().setAttribute("fince", fince);
return SUCCESS;
}
/**
* 查询用户的图片情况(5大证件)
*
* @return
* @throws SQLException
* @throws DataException
*/
public String queryPerUserPicturMsg() throws SQLException, DataException {
Map<String, String> map1 = new HashMap<String, String>();
Map<String, String> materialsauthMap = null;
Long userId = -1L;
String strUserId = SqlInfusion.FilteSqlInfusion(paramMap.get("userId"));
Integer materAuthTypeIdStr = Convert.strToInt(paramMap.get("materAuthTypeId"), -1);
if (strUserId != null) {
userId = Convert.strToLong(strUserId, -1L);
validateService.queryPerUserPicturMsg(pageBean, userId, materAuthTypeIdStr);
List<Map<String, Object>> pMap = null;
pMap = pageBean.getPage();// 获取到page集合
Long tmId = -1L;
if (pMap != null && pMap.size() > 0) {
for (int i = 0; i < pMap.size(); i++) {
String fileUrl = pMap.get(i).get("tmid").toString();// 得到结果集
// fileUrl的值
String[] fileUrls = fileUrl.split(";");// 截取;符号 放入String数组
if (fileUrls != null && fileUrls.length > 0) {
tmId = Convert.strToLong(fileUrls[0], -1);
}
}
}
if (tmId != -1) {
request().setAttribute("tmId", tmId);
}
map1 = validateService.queryUserNameById(userId);
materialsauthMap = validateService.querymaterialsauth(userId, materAuthTypeIdStr);// 查询证件类型
}
request().setAttribute("userId", userId);
request().setAttribute("materAuthTypeIdStr", materAuthTypeIdStr);
if (map1 != null && map1.size() > 0) {
request().setAttribute("username", map1.get("username").toString());
}
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
// 查询审核记录
list = validateService.queryAdminCheckList(userId, materAuthTypeIdStr);
request().setAttribute("checkList", list);
request().setAttribute("materAuthTypeIdStr", materAuthTypeIdStr);// 将类型传值到后台
request().setAttribute("materialsauthMap", materialsauthMap);
return SUCCESS;
}
public String queryPerUserPicturMsginit() throws SQLException, DataException {
Long userId = Convert.strToLong(request().getParameter("userId"), -1L);
Long TypeId = Convert.strToLong(request().getParameter("materAuthTypeId"), -1L);
request().setAttribute("userId", userId);
request().setAttribute("TypeId", TypeId);
selectvalue = TypeId;// 复制给select标签的默认值
return SUCCESS;
}
/**
* 查看五大证件单个证件类型
*
* @return
* @throws SQLException
*/
public String queryPersonPictureDate() throws SQLException {
Map<String, String> map = new HashMap<String, String>();
String strUserId = SqlInfusion.FilteSqlInfusion(request().getParameter("userId"));
int TypeId = Convert.strToInt(request().getParameter("TypeId"), -1);
Long tmdid = Convert.strToLong(request().getParameter("adf"), -1);
Long userId = -1L;
if (strUserId != null) {
userId = Convert.strToLong(strUserId, -1L);
if (userId != -1 && TypeId != -1) {
map = validateService.queryPerPictruMsgCallBack(userId, TypeId, tmdid);
}
}
request().setAttribute("map", map);
return SUCCESS;
}
/**
* 查看可选证件单个证件类型
*
* @return
* @throws SQLException
*/
public String queryPersonSelectPictureDate() throws SQLException {
Map<String, String> map = new HashMap<String, String>();
String strUserId = SqlInfusion.FilteSqlInfusion(request().getParameter("userId"));
int TypeId = Convert.strToInt(request().getParameter("TypeId"), -1);
Long tmdid = Convert.strToLong(request().getParameter("adf"), -1);
Long userId = -1L;
if (strUserId != null) {
userId = Convert.strToLong(strUserId, -1L);
if (userId != -1 && TypeId != -1) {
map = validateService.queryPerPictruMsgCallBack(userId, TypeId, tmdid);
}
}
request().setAttribute("map", map);
return SUCCESS;
}
/**
* 删除单个证件
*
* @return
* @throws SQLException
*/
public String delcertificate() throws SQLException {
Long tmdid = Convert.strToLong(paramMap.get("tmdid"), -1);
validateService.deletecertificate(tmdid);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("t_materialimagedetal", admin.getUserName(), IConstants.DELETE, admin.getLastIP(), 0, "删除单个证件", 2);
return null;
}
/**
* 查看图片状况但不可审核
*
* @return
* @throws SQLException
*/
public String queryPersonPictureDate_() throws SQLException {
Map<String, String> map = new HashMap<String, String>();
String strUserId = SqlInfusion.FilteSqlInfusion(request().getParameter("userId"));
int TypeId = Convert.strToInt(request().getParameter("TypeId"), -1);
Long userId = -1L;
if (strUserId != null) {
userId = Convert.strToLong(strUserId, -1L);
if (userId != -1 && TypeId != -1) {
}
}
request().setAttribute("map", map);
return SUCCESS;
}
/**
* 用户可选资料验证
*
* @return
*/
public String queryselectInit() {
String types = Convert.strToStr(request("types"), "-1");
request().setAttribute("types", types);
return SUCCESS;
}
/**
* 用户可选资料验证跳转详情
*
* @return
* @throws SQLException
* @throws DataException
*/
public String queryselect() throws SQLException, DataException {
String username = SqlInfusion.FilteSqlInfusion(paramMap.get("userName"));
String tausername = SqlInfusion.FilteSqlInfusion(paramMap.get("tausername"));
String realName = SqlInfusion.FilteSqlInfusion(paramMap.get("realName"));
String materAuthTypeId = SqlInfusion.FilteSqlInfusion(paramMap.get("materAuthTypeId"));
Integer maId = -1;
if (StringUtils.isNotBlank(materAuthTypeId)) {
maId = Convert.strToInt(materAuthTypeId, -1);
}
validateService.queryselect(pageBean, null, username, realName, tausername, maId);
List<Map<String, Object>> lists = null;
@SuppressWarnings("unused")
Vector<Long> list = new Vector<Long>();
lists = validateService.queryselect1(null, username, realName, tausername, maId);// 获取集合
long allCount = 0;
long userCount = 0;
boolean flag = false;
if (lists.size() > 0 && lists != null) {
for (int i = 0; i < lists.size(); i++) {
int tmIdentityauditStatus = Convert.strToInt(lists.get(i).get("wait") == null ? "" : lists.get(i).get("wait").toString(), 0);// 得到结果集
// fileUrl的值
allCount += tmIdentityauditStatus;
if (tmIdentityauditStatus > 0) {
flag = true;
}
if (flag) {
userCount++;
}
flag = false;
}
}
request().setAttribute("byNamemap", allCount);
request().setAttribute("usercount", userCount);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 可选初始化
*
* @return
*/
private Long selectvalue;
public Long getSelectvalue() {
return selectvalue;
}
public void setSelectvalue(Long selectvalue) {
this.selectvalue = selectvalue;
}
/**
* 查询可选认证图片
*
* @return
*/
public String queryselectindexMethod() {
Long userId = Convert.strToLong(request().getParameter("userId"), -1L);
Long TypeId = Convert.strToLong(request().getParameter("TypeId"), -1L);
request().setAttribute("userId", userId);
request().setAttribute("TypeId", TypeId);
selectvalue = TypeId;
return SUCCESS;
}
/**
* 可选认证的图片展示
*
* @return
* @throws SQLException
* @throws Exception
*/
public String queryselectinoforMethod() throws SQLException, Exception {
@SuppressWarnings("unused")
List<Map<String, Object>> map = new ArrayList<Map<String, Object>>();
Map<String, String> map1 = new HashMap<String, String>();
Map<String, String> materialsauthMap = null;
Long userId = -1L;
String strUserId = SqlInfusion.FilteSqlInfusion(paramMap.get("userId"));
Integer materAuthTypeIdStr = Convert.strToInt(paramMap.get("materAuthTypeId"), -1);
if (strUserId != null) {
userId = Convert.strToLong(strUserId, -1L);
validateService.querySelectPictureDate(pageBean, userId, materAuthTypeIdStr);
List<Map<String, Object>> pMap = null;
pMap = pageBean.getPage();// 获取到page集合
Long tmId = -1L;
if (pMap != null && pMap.size() > 0) {
for (int i = 0; i < pMap.size(); i++) {
String fileUrl = (pMap.get(i).get("tmid")) == null ? "" : (pMap.get(i).get("tmid")).toString();// 得到结果集
// fileUrl的值
String[] fileUrls = fileUrl.split(";");// 截取;符号 放入String数组
if (fileUrls != null && fileUrls.length > 0) {
tmId = Convert.strToLong(fileUrls[0], -1);
}
}
}
if (tmId != -1) {
request().setAttribute("tmId", tmId);
}
map1 = validateService.queryUserNameById(userId);
materialsauthMap = validateService.querymaterialsauth(userId, materAuthTypeIdStr);// 查询证件类型
}
request().setAttribute("userId", userId);
request().setAttribute("materAuthTypeIdStr", materAuthTypeIdStr);
if (map1 != null && map1.size() > 0) {
request().setAttribute("username", map1.get("username").toString());
}
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
// 查询审核记录
list = validateService.queryAdminCheckList(userId, materAuthTypeIdStr);
request().setAttribute("checkList", list);
request().setAttribute("materAuthTypeIdStr", materAuthTypeIdStr);// 将类型传值到后台
request().setAttribute("materialsauthMap", materialsauthMap);
return SUCCESS;
}
public String querycreditindexMethod() {
String types = Convert.strToStr(request("types"), "-1");
request().setAttribute("types", types);
return SUCCESS;
}
public String querycreditinoforMethod() throws SQLException, DataException {
String username = SqlInfusion.FilteSqlInfusion(paramMap.get("userName"));
String starttime = SqlInfusion.FilteSqlInfusion(paramMap.get("starttime"));
String endtime = SqlInfusion.FilteSqlInfusion(paramMap.get("endtime"));
Integer austatus = Convert.strToInt(paramMap.get("austatus"), -1);
validateService.querycreditLimitApply(pageBean, username, austatus, starttime, endtime);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 申请信用额度的详情
*
* @return
* @throws SQLException
* @throws DataException
*/
public String querycreditMsgMethod() throws DataException, SQLException {
@SuppressWarnings("unused")
Long userId = Convert.strToLong(request().getParameter("uId"), -1L);
Long ti = Convert.strToLong(request().getParameter("ti"), -1L);// 审核表中这条记录的唯一id号
Map<String, String> map = null;
map = validateService.queryrequestCredit(ti);
request().setAttribute("map", map);
request().setAttribute("ti", ti);
return SUCCESS;
}
/**
* 申请额度处理
*
* @return
* @throws DataException
* @throws SQLException
* @throws IOException
*/
public String updateUserCreditLimitMethod() throws SQLException, DataException, IOException {
Long userId = Convert.strToLong(paramMap.get("userId"), -1L);
Integer validp = Convert.strToInt(paramMap.get("validp"), -1);
Long ti = Convert.strToLong(paramMap.get("ti"), -1L);// 额度审核表中唯一id号
// 审核状态
if (validp == null || validp == -1) {
JSONUtils.printStr("0");
return null;
}
String preAmountStr = paramMap.get("preAmount");
if (StringUtils.isBlank(preAmountStr)) {
JSONUtils.printStr("4");
return null;
}
// 申请额度
String applyAmountStr = paramMap.get("applyAmount");
if (StringUtils.isBlank(applyAmountStr)) {
JSONUtils.printStr("1");
return null;
}
// 正则表达式 判断是否为数字 包括 负数 /^-?(?:\d+|\d{1,3}(?:,\d{3})+)(?:\.\d+)?$/
Pattern pattern = Pattern.compile("^-?(?:\\d+|\\d{1,3}(?:,\\d{3})+)(?:\\.\\d+)?$");
Matcher m = pattern.matcher(paramMap.get("applyAmount"));
if (!m.matches()) {
JSONUtils.printStr("8");
return null;
}
// 审核原因
String content = Convert.strToStr(paramMap.get("content"), null);
if (StringUtils.isBlank(content)) {
JSONUtils.printStr("2");
return null;
}
Integer Creditstatus = null;
if (StringUtils.isNotBlank(applyAmountStr) && validp != null && validp != -1) {
BigDecimal applyAmount = new BigDecimal(applyAmountStr);
@SuppressWarnings("unused")
BigDecimal preAmount = new BigDecimal(preAmountStr);
/*
* if (applyAmount.compareTo(preAmount) == 1) {
* JSONUtils.printStr("5"); return null; }
*/
if (validp == 1) {
Creditstatus = 3;
} else if (validp == 0) {
Creditstatus = 2;
} else {
Creditstatus = 1;
}
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
Long reslut = -1L;
if (admin != null) {
reslut = validateService.updateUserCreditLimit(userId, Creditstatus, applyAmount, content, admin.getId(), ti);
operationLogService
.addOperationLog("t_user/t_crediting", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "用户额度审核处理", 2);
if (reslut <= 0) {
JSONUtils.printStr("7");
return null;
} else {
JSONUtils.printStr("6");
return null;
}
}
}
return null;
}
/**
* 查询用户的资料详情
*
* @return
*/
public String queryPictureDateCount() {
return SUCCESS;
}
public String queryDateCountinfo() throws SQLException {
String userName = SqlInfusion.FilteSqlInfusion(paramMap.get("userName"));
String realName = SqlInfusion.FilteSqlInfusion(paramMap.get("realName"));
Integer materAuthTypeId = Convert.strToInt(paramMap.get("materAuthTypeId"), -1);
Long roleId = Convert.strToLong(paramMap.get("roleId"), -1);
validateService.queryPictureDateCount(pageBean, roleId, materAuthTypeId, userName, realName);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 总审核
*
* @return
* @throws Exception
*/
public String updateallcheckMethod() throws Exception {
String flag = SqlInfusion.FilteSqlInfusion(paramMap.get("flag"));
if (StringUtils.isBlank(flag)) {
JSONUtils.printStr("0");
return null;
}
Integer score = 0;
Integer checkStatus = 2;// 审核失败
if (flag.equals("a")) {
// 正则表达式 判断是否为数字 包括 负数 /^-?(?:\d+|\d{1,3}(?:,\d{3})+)(?:\.\d+)?$/
Pattern pattern = Pattern.compile("^-?(?:\\d+|\\d{1,3}(?:,\\d{3})+)(?:\\.\\d+)?$");
Matcher m = pattern.matcher(paramMap.get("score"));
if (!m.matches()) {
JSONUtils.printStr("6");
return null;
}
/*
* if(!StringUtils.isNumeric(paramMap.get("score"))){
* JSONUtils.printStr("6"); return null; }
*/
score = Convert.strToInt(paramMap.get("score"), -10000);
if (null != score && score == -10000) {
JSONUtils.printStr("3");
return null;
}
checkStatus = 3;
}
if (score > 20 || score < -10) {
JSONUtils.printStr("130");
return null;
}
String content = paramMap.get("content");
if (StringUtils.isBlank(content)) {
JSONUtils.printStr("4");
return null;
}
Long tmId = Convert.strToLong(paramMap.get("tmId"), -1L);
if (tmId == -1L) {
JSONUtils.printStr("0");
return null;
}
Long userId = Convert.strToLong(paramMap.get("userId"), -1L);
if (userId == -1L) {
JSONUtils.printStr("0");
return null;
}
// 必须是先全部图片都是通过审核之后才能够进行总审核 不然进行不了总审核(只有这样才能有失效时间才能确定)
Map<String, String> countMap = null;
int countcheck = 0;
if (tmId != -1) {
countMap = validateService.queryCheckCount(tmId);// 统计管理员未审核的证件明细个数
if (countMap.size() > 0 && countMap != null) {
countcheck = Convert.strToInt(countMap.get("cccc"), 0);
}
} else {
return null;
}
if (countcheck != 0) {
JSONUtils.printStr("5");
return null;
}
Integer materAuthTypeIdStr = Convert.strToInt(paramMap.get("materAuthTypeIdStr"), -1);// 获取到类型
if (materAuthTypeIdStr == -1) {
JSONUtils.printStr("0");
return null;
}
if (userId != -1 && materAuthTypeIdStr != -1) {
// 获取管理员的信息
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
Long adminId = admin.getId();// 获取id
Long result = -1L;
// 在更新单个证件的信用积分之前查询更新前的信用积分
Integer cCriditing = 0;// 单个证件的信用总分
Map<String, String> cmap = countWorkStatusService.queryC(userId, materAuthTypeIdStr);
if (cmap != null && cmap.size() > 0) {
cCriditing = Convert.strToInt(cmap.get("criditing"), 0);
}
if (admin != null) {
// 学历认证扣费
if (materAuthTypeIdStr == 9) {// 学历认证的type为9
Map<String, Object> platformCostMap = getPlatformCost();
double eduAuthFee = Convert.strToDouble(platformCostMap.get(IAmountConstants.EDU_AUTH_FEE) + "", 0);
result = validateService.addeducationcost(userId, eduAuthFee + "");// 每次审核2块的手续费
if (result <= 0) {
JSONUtils.printStr("0");
return null;
}
}
result = validateService.Updatecreditrating(userId, content, score, adminId, materAuthTypeIdStr, checkStatus);
operationLogService.addOperationLog("t_user/t_materialsauth", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0,
"更新信用积分和插入审核列表", 2);
}
if (result > 0) {
// 添加审核记录
validateService.addCheckRecord(userId, content, score, adminId, materAuthTypeIdStr, cCriditing);
JSONUtils.printStr("1");
return null;
} else {
JSONUtils.printStr("0");
return null;
}
}
return null;
}
/**
* 审核用户的上传资料
*
* @return
* @throws IOException
* @throws SQLException
* @throws ParseException
* @throws DataException
*/
public String Updatematerialsauth() throws IOException, SQLException, ParseException, DataException {
Long userId = Convert.strToLong(paramMap.get("userId"), -1L);
Long valid = Convert.strToLong(paramMap.get("valid"), -1L);// 0 1
Integer visiable = Convert.strToInt(paramMap.get("visiable"), 2);// 0 1
Long tmdid = Convert.strToLong(paramMap.get("tmdid"), -1L);
Long tmid = Convert.strToLong(paramMap.get("tmid"), -1L);
Long materAuthTypeId = Convert.strToLong(paramMap.get("materAuthTypeId"), -1L);
String option = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("option")), null);
if (valid == -1L) {
JSONUtils.printStr("1");
return null;
}
if (option == null) {
JSONUtils.printStr("0");
return null;
}
if (userId != -1L && materAuthTypeId != -1L && valid != -1L && tmdid != -1L && tmid != -1L) {
Integer auditStatus = null;
if (valid == 0) {
auditStatus = 2;
}
if (valid == 1) {
auditStatus = 3;
}
Long result = -1L;
result = validateService.Updatematerialsauth(tmid, userId, materAuthTypeId, option, auditStatus, tmdid, visiable);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("t_materialimagedetal", admin.getUserName(), IConstants.INSERT, admin.getLastIP(), 0, "审核用户的上传资料", 2);
if (result > 0) {
if (materAuthTypeId <= 5) {
JSONUtils.printStr("2");// 为成功审核
} else {
JSONUtils.printStr("4");// 为成功审核可选认证
}
return null;
} else {
JSONUtils.printStr("3");
return null;
}
}
return null;
}
/**
* 手机变更初始化
*
* @return
* @throws SQLException
* @throws DataException
*/
public String updatephonex() {
return SUCCESS;
}
/**
* 手机变更数据 第一个标签
*
* @return
* @throws SQLException
* @throws DataException
* @throws Exception
*/
public String updatephonexf() throws Exception {
String username = SqlInfusion.FilteSqlInfusion(paramMap.get("username"));
String starttime = SqlInfusion.FilteSqlInfusion(paramMap.get("starttime"));
String endtime = SqlInfusion.FilteSqlInfusion(paramMap.get("endtime"));
// List<Map<String,Object>> tellist = null;
// tellist = validateService.querytelphone(null);
validateService.querytelphonePage(null, pageBean, username, starttime, endtime);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 手机绑定导出excel
*
* @return
*/
public String exportupdatephonex() {
pageBean.pageNum = 1;
pageBean.setPageSize(100000);
try {
String username = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("username")), null);
if (StringUtils.isNotBlank(username)) {
username = URLDecoder.decode(username, "UTF-8"); // 中文乱码转换
}
String starttime = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("starttime")), null);
String endtime = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("endtime")), null);
// 手机绑定列表
validateService.querytelphonePage(null, pageBean, username, starttime, endtime);
if (pageBean.getPage() == null) {
getOut().print("<script>alert(' 导出记录条数不能为空! ');window.history.go(-1);</script>");
return null;
}
if (pageBean.getPage().size() > IConstants.EXCEL_MAX) {
getOut().print("<script>alert(' 导出记录条数不能大于50000条 ');window.history.go(-1);</script>");
return null;
}
HSSFWorkbook wb = ExcelUtils.exportExcel("手机绑定列表", pageBean.getPage(), new String[] { "用户名", "真是姓名", "手机号码", "投标总额", "申请时间" },
new String[] { "username", "realName", "cellPhone", "amountall", "requsetTime", });
this.export(wb, new Date().getTime() + ".xls");
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("v_t_phone_banding_review", admin.getUserName(), IConstants.EXCEL, admin.getLastIP(), 0, "导出手机绑定列表",
2);
} catch (SQLException e) {
e.printStackTrace();
} catch (DataException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public String updatephonexChange() {
String types = Convert.strToStr(request("types"), "-1");
request().setAttribute("types", types);
return SUCCESS;
}
/**
* 手机变更第二个标签
*
* @return
* @throws SQLException
* @throws Exception
*/
public String updatephonexfChange() throws SQLException, Exception {
String username = SqlInfusion.FilteSqlInfusion(paramMap.get("username"));
String starttime = SqlInfusion.FilteSqlInfusion(paramMap.get("starttime"));
String endtime = SqlInfusion.FilteSqlInfusion(paramMap.get("endtime"));
Integer statuss = Convert.strToInt(paramMap.get("statss"), -1);
validateService.querytelphonePage2(null, pageBean, username, starttime, endtime, statuss);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 导出已还款列表
*
* @return
*/
public String exportupdatephonexfChange() {
pageBean.pageNum = 1;
pageBean.setPageSize(100000);
try {
String username = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("username")), null);
if (StringUtils.isNotBlank(username)) {
username = URLDecoder.decode(username, "UTF-8");
}
String starttime = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("starttime")), null);
String endtime = Convert.strToStr(SqlInfusion.FilteSqlInfusion(request().getParameter("endtime")), null);
int statuss = Convert.strToInt(request().getParameter("statss"), -1);
// 已还款记录列表
validateService.querytelphonePage2(null, pageBean, username, starttime, endtime, statuss);
if (pageBean.getPage() == null) {
getOut().print("<script>alert(' 导出记录条数不能为空! ');window.history.go(-1);</script>");
return null;
}
if (pageBean.getPage().size() > IConstants.EXCEL_MAX) {
getOut().print("<script>alert(' 导出记录条数不能大于50000条 ');window.history.go(-1);</script>");
return null;
}
List<Map<String, Object>> list = pageBean.getPage();
if (list != null) {
for (Map<String, Object> map : list) {
if (map.get("tpStatus").toString().equals("1")) {
map.put("tpStatus", "成功");
} else if (map.get("tpStatus").toString().equals("2")) {
map.put("tpStatus", "审核中");
} else if (map.get("tpStatus").toString().equals("3")) {
map.put("tpStatus", "取消");
} else if (map.get("tpStatus").toString().equals("4")) {
map.put("tpStatus", "失败");
}
}
}
HSSFWorkbook wb = ExcelUtils.exportExcel("手机变更列表", pageBean.getPage(),
new String[] { "用户名", "真实姓名", "手机号码", "申请手机", "投标总额", "申请时间", "状态" }, new String[] { "username", "realName", "cellPhone",
"mobilePhone", "amountall", "requsetTime", "tpStatus", });
this.export(wb, new Date().getTime() + ".xls");
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("t_phone_binding_info", admin.getUserName(), IConstants.EXCEL, admin.getLastIP(), 0, "导出手机变更列表", 2);
} catch (SQLException e) {
e.printStackTrace();
} catch (DataException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* 查看用户手机详情和审核手机更改状态
*
* @return
* @throws SQLException
*/
public String queryUserTelMethod() throws SQLException {
Map<String, String> map = null;
Long userId = -1L;
String userIdStr = SqlInfusion.FilteSqlInfusion(request().getParameter("id"));
String tpdiidStr = SqlInfusion.FilteSqlInfusion(request().getParameter("tpdiid"));
if (StringUtils.isNotBlank(userIdStr)) {
userId = Convert.strToLong(userIdStr, -1);
Long tpdiid = Convert.strToLong(tpdiidStr, -1);
map = validateService.queryUserTelMsg(userId, tpdiid);
}
request().setAttribute("map", map);
return SUCCESS;
}
/**
* 审核和更改用户的手机号码
*
* @return
* @throws SQLException
* @throws IOException
*/
@SuppressWarnings("null")
public String updateUserPhoneMethod() throws SQLException, IOException {
Long result = -1L;
String userStr = SqlInfusion.FilteSqlInfusion(paramMap.get("id"));
String tpiidStr = SqlInfusion.FilteSqlInfusion(paramMap.get("tpiid"));
Long userId = -1L;
if (StringUtils.isNotBlank(userStr)) {
userId = Convert.strToLong(userStr, -1L);
} else {
JSONUtils.printStr("0");
return null;
}
Long tpiid = -1L;
if (StringUtils.isNotBlank(tpiidStr)) {
tpiid = Convert.strToLong(tpiidStr, -1L);
} else {
JSONUtils.printStr("0");
return null;
}
Integer auditStatus = Convert.strToInt(paramMap.get("vali"), -1);
if (auditStatus == null ) {
// if (auditStatus == null && auditStatus != -1) {
JSONUtils.printStr("1");
return null;
}
String option = SqlInfusion.FilteSqlInfusion(paramMap.get("content"));
if (StringUtils.isBlank(option)) {
JSONUtils.printStr("2");
return null;
}
String newTelNumber = SqlInfusion.FilteSqlInfusion(paramMap.get("newPhone"));
if (StringUtils.isBlank(newTelNumber)) {
JSONUtils.printStr("3");
return null;
}
// 查询用户经过基本资料审核后已经绑定的手机号码
Map<String, String> phoneMap = null;
try {
phoneMap = beVipService.queryPUser(userId);
} catch (DataException e) {
e.printStackTrace();
}
String personCellPhone = "";
if (phoneMap.size() > 0 && phoneMap != null) {
personCellPhone = Convert.strToStr(phoneMap.get("cellphone"), "");// 获取基本绑定的手机号码
if (personCellPhone == "") {
JSONUtils.printStr("5");
return null;
}
} else {
JSONUtils.printStr("5");
return null;
}
result = validateService.updateUserPhoneService(userId, auditStatus, option, newTelNumber, tpiid, personCellPhone);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("t_person", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "审核和更改用户手机号码", 2);
if (result >= 0) {
JSONUtils.printStr("4");
return null;
} else {
JSONUtils.printStr("5");
return null;
}
}
/**
* 查询可选认证中的个人信息
*
* @return
* @throws SQLException
* @throws DataException
*/
public String queryselectMethod() throws SQLException, DataException {
Long userId = Convert.strToLong(request().getParameter("userId"), -1L);
Map<String, String> map = null;
Map<String, String> totalPass = null;
Map<String, String> SelectPassTotal = null;
Map<String, String> SelectCledit = null;
// List<Map<String,Object>> SelectCledit = null;
if (userId != null) {
request().setAttribute("id", userId);
map = validateService.queryselectpicture(userId);
totalPass = validateService.queryTotaPass(userId);
SelectPassTotal = validateService.querySelectPassTotal(userId);
SelectCledit = validateService.querySelectCledit(userId);
// SelectCledit = validateService.querySelectCleditList(userId);
request().setAttribute("SelectPassTotal", SelectPassTotal);
request().setAttribute("map", map);
request().setAttribute("totalPass", totalPass);
request().setAttribute("SelectCledit", SelectCledit);
}
return SUCCESS;
}
public String queryPersonInfo() throws Exception {
String userName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("userName")), null);
String realName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("realName")), null);
String phone = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("phone")), null);
String idNo = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("idNo")), null);
int source = Convert.strToInt(paramMap.get("source"), -1);
validateService.queryPersonInfo(pageBean, userName, realName, phone, idNo, source);
// 获取各种认证的审核状态
List<Map<String, Object>> countList = validateService.queryUserCreditCount(userName, realName, phone, idNo);
// 待审核的认证数量
long countAll = 0;
long userAll = 0;
boolean flag = false;
if (countList != null && countList.size() > 0)
for (int i = 0; i < countList.size(); i++) {
// 必填认证 身份认证
int tmIdentityauditStatus = Convert.strToInt(
countList.get(i).get("tmIdentityauditStatus") == null ? "" : countList.get(i).get("tmIdentityauditStatus").toString(), 0);
// 必填认证 工作认证
int tmworkauditStatus = Convert.strToInt(
countList.get(i).get("tmworkauditStatus") == null ? "" : countList.get(i).get("tmworkauditStatus").toString(), 0);
// 必填认证 居住地认证
int tmaddressauditStatus = Convert.strToInt(
countList.get(i).get("tmaddressauditStatus") == null ? "" : countList.get(i).get("tmaddressauditStatus").toString(), 0);
// 必填认证 信用认证
int tmresponseauditStatus = Convert.strToInt(
countList.get(i).get("tmresponseauditStatus") == null ? "" : countList.get(i).get("tmresponseauditStatus").toString(), 0);
// 必填认证 收入认证
int tmincomeeauditStatus = Convert.strToInt(
countList.get(i).get("tmincomeeauditStatus") == null ? "" : countList.get(i).get("tmincomeeauditStatus").toString(), 0);
if (tmIdentityauditStatus == 1) {
countAll++;
flag = true;
}
if (tmworkauditStatus == 1) {
countAll++;
flag = true;
}
if (tmaddressauditStatus == 1) {
countAll++;
flag = true;
}
if (tmresponseauditStatus == 1) {
countAll++;
flag = true;
}
if (tmincomeeauditStatus == 1) {
countAll++;
flag = true;
}
if (flag) {
userAll++;
}
flag = false;
}
request().setAttribute("byNamemap", countAll);
request().setAttribute("usercount", userAll);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
public String queryPersonAuditStatusInfo() throws SQLException, DataException {
Integer auditStatus = Convert.strToInt(paramMap.get("auditStatus"), -1);
String userName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("userName")), null);
String realName = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("realName")), null);// 真实姓名
String cellPhone = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("cellPhone")), null);
String idNo = Convert.strToStr(SqlInfusion.FilteSqlInfusion(paramMap.get("idNo")), null);// 真实姓名
validateService.queryPersonAuditStatusInfo(pageBean, userName, realName, auditStatus, cellPhone, idNo);
int pageNum = (int) (pageBean.getPageNum() - 1) * pageBean.getPageSize();
request().setAttribute("pageNum", pageNum);
return SUCCESS;
}
/**
* 查询个人的工作的详细情况
*
* @return
* @throws SQLException
* @throws DataException
*/
public String queryWork() throws Exception {
long id = Convert.strToLong(request().getParameter("uid"), -1L);
request().setAttribute("uid", id);
Map<String, String> map = new HashMap<String, String>();
map = validateService.queryWorkDataById(id);
if (map == null) {// 如果工作信息为空的话
request().setAttribute("flagw", "1");
}
if (map != null && map.size() > 0) {
workPro = Convert.strToLong(map.get("workPro").toString(), -1L);
cityId = Convert.strToLong(map.get("workCity").toString(), -1L);
}
request().setAttribute("id", id);
provinceList = regionService.queryRegionList(-1L, 1L, 1);
if (workPro > 0) {
cityList = regionService.queryRegionList(-1L, workPro, 2);
}
if (cityId == 0) {
request().setAttribute("map", map);
request().setAttribute("provinceList", provinceList);
cityList = regionService.queryRegionList(-1L, 1L, 1);
request().setAttribute("cityList", cityList);
} else {
request().setAttribute("map", map);
request().setAttribute("provinceList", provinceList);
request().setAttribute("cityList", cityList);
}
return SUCCESS;
}
public long getWorkPro() {
return workPro;
}
public void setWorkPro(long workPro) {
this.workPro = workPro;
}
public long getCityId() {
return cityId;
}
public void setCityId(long cityId) {
this.cityId = cityId;
}
/**
* 更新用户工作状态
*
* @return
* @throws SQLException
* @throws IOException
* @throws DataException
*/
public String updateworkStatus() throws SQLException, IOException, DataException {
JSONObject json = new JSONObject();
Long flag = Convert.strToLong(paramMap.get("flag").toString(), -1);
Long userId = Convert.strToLong(paramMap.get("userId"), -1L);
int auditStatus = -1;
if (flag == 1)
auditStatus = 3;
else if (flag == 0)
auditStatus = 2;
else {
json.put("msg", "出错啦");
JSONUtils.printObject(json);
return null;
}
Long resulId = -1L;
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
try {
resulId = validateService.updateworkStatus(userId, auditStatus, null, null, null, admin.getId());
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
}
if (resulId > 0) {
operationLogService.addOperationLog("t_workauth", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "更新用户工作状态成功", 2);
json.put("msg", "审核成功");
JSONUtils.printObject(json);
} else {
operationLogService.addOperationLog("t_workauth", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "更新用户工作状态失败", 2);
json.put("msg", "审核失败");
JSONUtils.printObject(json);
}
return null;
}
/**
* 后台根据收索来统计数量
*
* @return
* @throws SQLException
* @throws IOException
*/
public String dataInfoM() throws SQLException, IOException {
Long resulId = -1L;
Long userId = Convert.strToLong(paramMap.get("userId").toString(), -1L);
Integer servicePersonId = Convert.strToInt(paramMap.get("selectid").toString(), -1);
try {
resulId = validateService.updataUserServiceMan(userId, servicePersonId);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
}
if (resulId > 0) {
JSONUtils.printStr("1");
return null;
} else {
JSONUtils.printStr("0");
return null;
}
}
/**
* 更新用户的跟踪人
*
* @return
* @throws SQLException
* @throws IOException
*/
public String updataUserServiceMan() throws SQLException, IOException {
Long resulId = -1L;
Long userId = Convert.strToLong(paramMap.get("userId").toString(), -1L);
Integer servicePersonId = Convert.strToInt(paramMap.get("selectid").toString(), -2);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
try {
resulId = validateService.updataUserServiceMan(userId, servicePersonId);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
}
if (resulId > 0) {
operationLogService.addOperationLog("t_user", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "更新用户的跟踪人成功", 2);
JSONUtils.printStr("1");
return null;
} else {
operationLogService.addOperationLog("t_user", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "更新用户的跟踪人失败", 2);
JSONUtils.printStr("0");
return null;
}
}
public String updateUserServiceMans() throws SQLException, IOException {
String ids = SqlInfusion.FilteSqlInfusion(paramMap.get("ids"));
String admins = SqlInfusion.FilteSqlInfusion(paramMap.get("admins"));
String[] allIds = ids.split(",");
String[] allAdmins = admins.split(",");
if (allIds.length != allAdmins.length) {
JSONUtils.printStr("1");
return INPUT;
}
if (allIds.length > 0 && allAdmins.length > 0) {
long tempId = 0;
for (String str : allIds) {
tempId = Convert.strToLong(str, -1);
if (tempId == -1) {
JSONUtils.printStr("1");
return INPUT;
}
}
for (String str : allAdmins) {
tempId = Convert.strToLong(str, -2);
if (tempId == -2) {
JSONUtils.printStr("1");
return INPUT;
}
}
} else {
JSONUtils.printStr("1");
return INPUT;
}
long resultId = validateService.updataUserServiceMans(ids, admins);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog("t_user", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0, "更新用户客服", 2);
if (resultId <= 0) {
JSONUtils.printStr("2");
return INPUT;
}
return null;
}
public String queryPersonInfoindex() {
String types = Convert.strToStr(request("types"), "-1");
request().setAttribute("types", types);
return SUCCESS;
}
public String querynewUserCheckindex() {
return SUCCESS;
}
public void setBeVipService(BeVipService beVipService) {
this.beVipService = beVipService;
}
/**
* 合和年 审核单个可选认证信息
*
* @return
*/
public String updateCheckByType() throws Exception {
int materAuthTypeIdStr = Convert.strToInt(paramMap.get("typeId"), -1);
long userId = Convert.strToLong(paramMap.get("userId"), -1);
int status = Convert.strToInt(paramMap.get("status"), 3);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
Long adminId = admin.getId();
long result = -1L;
if (admin != null) {
result = validateService.Updatecreditrating(userId, "", 0, adminId, materAuthTypeIdStr, status);// 3表示通过审核
operationLogService.addOperationLog("t_user/t_materialsauth", admin.getUserName(), IConstants.UPDATE, admin.getLastIP(), 0,
"更新信用积分和插入审核列表", 2);
}
if (result > 0) {
JSONUtils.printStr("1");
} else {
JSONUtils.printStr("0");
}
return null;
}
/**
* 和合年 查询财富认证
*
* @return
* @throws Exception
*/
public String queryFinanceById() {
Long userId = Convert.strToLong(request("uid"), -1L);
if (userId <= 0)
return SUCCESS;
List<Map<String, Object>> list;
try {
list = validateService.queryUserSelectMsg(false, userId);
List<Map<String, Object>> map1 = new ArrayList<Map<String, Object>>();
List<Map<String, Object>> map2 = new ArrayList<Map<String, Object>>();
float size = list.size();
for (int i = 0; i < size; i++) {
if (i < size / 2)
map1.add(list.get(i));
else
map2.add(list.get(i));
}
request().setAttribute("map1", map1);
request().setAttribute("map2", map2);
} catch (SQLException e) {
e.printStackTrace();
}
return SUCCESS;
}
/**
* 合和年 查询用户5必填证件
*
* @return
* @throws SQLException
* @throws DataException
*/
public String queryUserMustMsg() {
Long userId = Convert.strToLong(request("uid"), -1L);
if (userId <= 0)
return SUCCESS;
List<Map<String, Object>> map;
try {
map = validateService.queryUserSelectMsg(true, userId);
Map<String, String> map1 = validateService.queryUserNameById(userId);
request().setAttribute("map", map);
if (map1 != null && map1.size() > 0) {
request().setAttribute("realName", map1.get("realName"));
}
} catch (Exception e) {
e.printStackTrace();
}
return SUCCESS;
}
/**
* 合和年 根据 用户id 认证id 查询认证图片
*/
public String queryMaterialsauthImg() {
long userId = Convert.strToLong(request("userId"), -1);
long materTypeId = Convert.strToLong(request("typeId"), -1);
if (materTypeId <= 0 || userId <= 0)
return SUCCESS;
try {
validateService.querymaterialsauthImg(pageBean, userId, materTypeId);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
}
return SUCCESS;
}
}