public String updateUserqq() {
JSONObject obj = new JSONObject();
String qq = SqlInfusion.FilteSqlInfusion(paramMap.get("qq"));
long userId = Integer.parseInt(paramMap.get("userId"));
long result = -1L;
result = userManageServic.updateUserqq(userId, qq);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
try {
if (result >= 1) {
operationLogService.addOperationLog(
"t_person",
admin.getUserName(),
IConstants.UPDATE,
admin.getLastIP(),
0,
"更新用户基本信息（QQ）",
2);
obj.put("msg", "1");
JSONUtils.printObject(obj);
return null;
} else {
obj.put("msg", "操作失败");
JSONUtils.printObject(obj);
return null;
}
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/** 添加债权转让 */
public String addAssignmentDebt() throws IOException {
long userId = this.getUserId();
// double auctionBasePrice = Convert.strToDouble(paramMap.get("auctionBasePrice"), -1);
// double debtSum = Convert.strToDouble(paramMap.get("debtSum"), -1);
// double lowerPrice = debtSum*0.5;
// if(auctionBasePrice < lowerPrice || auctionBasePrice > debtSum){
// JSONUtils.printStr2("转让价格范围错误");
// return null;
// }
paramMap.put("alienatorId", userId + "");
paramMap.put("applyTime", DateUtil.dateToString(new Date()));
long reslut = -1;
try {
reslut = assignmentDebtService.addAssignmentDebt(paramMap);
// JSONObject json = JSONObject.fromObject(ChinaPnRInterface.creditAssign(OrdId, SellCustId,
// CreditAmt, CreditDealAmt, BidDetails, Fee, DivDetails, BuyCustId, OrdDate);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
}
try {
if (reslut != -1) {
JSONUtils.printStr("1");
} else {
JSONUtils.printStr("-1");
}
} catch (IOException e) {
log.error(e);
e.printStackTrace();
}
return null;
}
/**
* 更新代理人账户类型
*
* @return
* @throws SQLException
* @throws DataException
*/
public String updateUserAccountType() throws SQLException, DataException {
JSONObject obj = new JSONObject();
long userId = Integer.parseInt(request("id"));
long result = -1L;
result = userManageServic.updateUserAccountType(userId);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
try {
if (result >= 1) {
operationLogService.addOperationLog(
"t_user",
admin.getUserName(),
IConstants.UPDATE,
admin.getLastIP(),
0,
"更新用户基本信息（代理人账户类型）",
2);
obj.put("msg", "Y");
JSONUtils.printObject(obj);
return SUCCESS;
} else {
obj.put("msg", "N");
JSONUtils.printObject(obj);
return SUCCESS;
}
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return SUCCESS;
}
/**
* 分页显示成功故事列表
*
* @return
* @throws SQLException
* @throws DataException
* @throws IOException
*/
public String frontQuerySuccessStoryListPage() throws SQLException, DataException, IOException {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
// successStoryService.querySuccessStoryPage(pageBean);
publicModelService.querySuccessStoryPage(pageBean);
jsonMap.put("pageBean", pageBean);
jsonMap.put("error", "-1");
jsonMap.put("msg", "成功");
JSONUtils.printObject(jsonMap);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
jsonMap.put("msg", "1");
jsonMap.put("msg", "未知异常");
JSONUtils.printObject(jsonMap);
}
return null;
}
public String cellPhoneregsinit() throws IOException {
String cellphone = SqlInfusion.FilteSqlInfusion(paramMap.get("cellphone"));
String pageId = SqlInfusion.FilteSqlInfusion(paramMap.get("pageId")); // 验证码
String code = (String) session().getAttribute(pageId + "_checkCode");
String _code = SqlInfusion.FilteSqlInfusion(paramMap.get("code").toString().trim());
if (code == null || !_code.equals(code)) {
JSONUtils.printStr("2"); // 2为验证码错误
return null;
}
if (StringUtils.isBlank(cellphone)) {
JSONUtils.printStr("3"); // 3为手机验证码为空
return null;
}
try {
Map<String, String> phonemap = beVipService.queryIsPhoneonUser(cellphone);
Map<String, String> cellMap = cellPhoneService.queryCellPhone(cellphone);
if (phonemap != null || cellMap != null) { // 判断手机号码是都否存在
JSONUtils.printStr("5"); // 5为 手机号码已存在
return null;
}
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
JSONUtils.printStr("2"); //
return null;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
JSONUtils.printStr("2"); //
return null;
}
request().setAttribute("cellphone", cellphone);
JSONUtils.printStr("1"); // 1通过校验
return null;
}
/**
* 根据Id获取成功故事详情
*
* @return
* @throws SQLException
* @throws DataException
* @throws IOException
*/
public String frontQuerySuccessStoryById() throws SQLException, DataException, IOException {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
Map<String, String> infoMap = this.getAppInfoMap();
Long id = Convert.strToLong(infoMap.get("id"), -1);
// 上一条
// previousDate=successStoryService.getSuccessStoryById(id-1);
previousDate = publicModelService.getSuccessStoryById(id - 1);
// 下一条
// lastDate=successStoryService.getSuccessStoryById(id+1);
lastDate = publicModelService.getSuccessStoryById(id + 1);
// paramMap=successStoryService.getSuccessStoryById(id);
paramMap = publicModelService.getSuccessStoryById(id);
// 浏览次数增加
// successStoryService.updateSuccessStory(id, null, null, null, null, null,
// Convert.strToLong(paramMap.get("browseNum"),-1)+1, null);
publicModelService.updateSuccessStory(
id,
null,
null,
null,
null,
null,
Convert.strToLong(paramMap.get("browseNum"), -1) + 1,
null);
jsonMap.put("previousDate", previousDate);
jsonMap.put("lastDate", lastDate);
jsonMap.put("paramMap", paramMap);
jsonMap.put("error", "-1");
jsonMap.put("msg", "成功");
JSONUtils.printObject(jsonMap);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
jsonMap.put("msg", "1");
jsonMap.put("msg", "未知异常");
JSONUtils.printObject(jsonMap);
}
return null;
}
/**
* 查询网站成功故事列表(每次显示二条)
*
* @return String
* @throws SQLException
* @throws DataException
* @throws IOException
* @throws UnsupportedEncodingException
*/
@SuppressWarnings("unchecked")
public String frontQuerySuccessStoryList() throws SQLException, DataException, IOException {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Map<String, Object>> newsList = new ArrayList<Map<String, Object>>();
pageBean.setPageSize(2);
// successStoryService.querySuccessStoryPage(pageBean);
publicModelService.querySuccessStoryPage(pageBean);
newsList = pageBean.getPage();
pageBean.setPage(null);
// request().setAttribute("storyList", newsList);
jsonMap.put("newsList", newsList);
jsonMap.put("error", "-1");
jsonMap.put("msg", "成功");
JSONUtils.printObject(jsonMap);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
jsonMap.put("msg", "1");
jsonMap.put("msg", "未知异常");
JSONUtils.printObject(jsonMap);
}
return null;
}
/**
* 弹出框初始添加信用积分
*
* @return
* @throws SQLException
* @throws IOException
* @throws DataException
*/
public String addintegralreal() throws SQLException, IOException, DataException {
Long userId = Convert.strToLong(paramMap.get("id"), -1L);
Integer type = Convert.strToInt(paramMap.get("type"), -1);
if (type == -1) {
JSONUtils.printStr("0");
return null;
}
String scoreStr = paramMap.get("s");
if (StringUtils.isBlank(scoreStr)) {
JSONUtils.printStr("1");
return null;
}
if (!StringUtils.isNumeric(scoreStr)) {
JSONUtils.printStr("5");
return null;
}
String remark = paramMap.get("remark");
if (StringUtils.isBlank(remark)) {
JSONUtils.printStr("2");
return null;
}
String typeStr = null;
Long result = -1L;
if (type == 1) {
typeStr = "信用积分";
}
if (type == 2) {
typeStr = "会员积分";
}
/*
* DateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String
* time=format.format(new Date());
*/
String changetype = "增加"; // 先设置为增加类型
Integer score = Convert.strToInt(scoreStr, -1);
result = userManageServic.addIntervalDelt(userId, score, type, typeStr, remark, changetype);
Admin admin = (Admin) session().getAttribute(IConstants.SESSION_ADMIN);
operationLogService.addOperationLog(
"t_user/t_userintegraldetail",
admin.getUserName(),
IConstants.INSERT,
admin.getLastIP(),
0,
"添加信用积分及其明细",
2);
if (result > 0) {
JSONUtils.printStr("3");
return null;
} else {
JSONUtils.printStr("4");
return null;
}
}
/**
* add by houli 获得用户资金信息
*
* @return
* @throws DataException
* @throws SQLException
* @throws IOException
*/
public String queryUserCashInfo() throws SQLException, DataException, IOException {
try {
Long userId = Convert.strToLong(request("userId"), -100);
Map<String, String> map = userManageServic.queryUserCashInfo(userId);
if (map != null) {
// request().setAttribute("map_", map);
JSONObject obj = new JSONObject();
obj.put("map_", map);
JSONUtils.printObject(obj);
}
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
} catch (DataException e) {
log.error(e);
e.printStackTrace();
} catch (IOException e) {
log.error(e);
e.printStackTrace();
}
return null;
}
/**
* 通过手机更改用户登录密码
*
* @return
* @throws IOException
*/
public String cellphoneforgetinfo() throws IOException {
JSONObject obj = new JSONObject();
String sign = SqlInfusion.FilteSqlInfusion(paramMap.get("cellphone"));
String mdKey = sign.substring(0, 10);
String mdValue = sign.substring(10, sign.length());
String mdCompare = Encrypt.MD5(mdValue + IConstants.BBS_SES_KEY).substring(0, 10);
String valAll = Encrypt.decryptSES(mdValue, IConstants.BBS_SES_KEY);
if (!mdKey.equals(mdCompare)) {
JSONUtils.printStr("签名错误");
return null;
}
String[] keys = valAll.split("-");
String cellphone = keys[0].toString();
String dateTime = keys[1].toString();
long curTime = new Date().getTime();
// 当用户点击注册时间大于于1分钟
if (curTime - Long.valueOf(dateTime) >= 60 * 1000) {
obj.put("mailAddress", "已超时");
JSONUtils.printObject(obj);
return null;
}
String phonecode = null;
try {
Object obje = session().getAttribute("phone");
if (obje != null) {
phonecode = obje.toString();
} else {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
} catch (Exception e) {
e.printStackTrace();
}
if (phonecode != null) {
if (!phonecode.trim().equals(cellphone.trim())) {
obj.put("mailAddress", "与获取验证码手机号不一致");
JSONUtils.printObject(obj);
return null;
}
}
// 验证码
String vilidataNum = SqlInfusion.FilteSqlInfusion(paramMap.get("cellcode"));
if (StringUtils.isBlank(vilidataNum)) {
obj.put("mailAddress", "请填写验证码");
JSONUtils.printObject(obj);
return null;
}
String randomCode = null;
Object objec = session().getAttribute("randomCode");
if (objec != null) {
randomCode = objec.toString();
} else {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
if (randomCode != null) {
if (!randomCode.trim().equals(vilidataNum.trim())) {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
}
String password = SqlInfusion.FilteSqlInfusion(paramMap.get("password")); // 用户密码
if (StringUtils.isBlank(password)) {
obj.put("mailAddress", "1");
JSONUtils.printObject(obj);
return null;
}
// 控制长度
if (password.length() < 6 || password.length() > 20) {
obj.put("mailAddress", "2");
JSONUtils.printObject(obj);
return null;
}
String confirmPassword = SqlInfusion.FilteSqlInfusion(paramMap.get("confirmPassword")); // 用户密码
if (StringUtils.isBlank(confirmPassword)) {
obj.put("mailAddress", "3");
JSONUtils.printObject(obj);
return null;
}
// 检查用户是否存在通过手机号码]
Map<String, String> phonemap = null;
try {
phonemap = beVipService.queryIsPhoneonUser(cellphone);
} catch (SQLException e1) {
e1.printStackTrace();
} catch (DataException e1) {
e1.printStackTrace();
}
if (phonemap == null) {
obj.put("mailAddress", "6");
JSONUtils.printObject(obj);
return null;
}
Long resutl = -1L;
try {
resutl = cellPhoneService.updatepasswordBycellphone(cellphone, password);
if (resutl <= 0) {
obj.put("mailAddress", "4");
JSONUtils.printObject(obj);
return null;
} else {
obj.put("mailAddress", "5");
JSONUtils.printObject(obj);
AccountUserDo user = this.getUser();
bbsRegisterService.doUpdatePwdByAsynchronousMode(user.getUsername(), password, password, 2);
return null;
}
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* * 手机注册
*
* @return
* @throws Exception
*/
public String cellreginfo() throws Exception {
JSONObject obj = new JSONObject();
// 判断手机验证码是否正确 start
/** 判定用户是否已存在记录 */
// 验证手机的唯一性
String cellphone = SqlInfusion.FilteSqlInfusion(paramMap.get("cellphone"));
Map<String, String> phonemap = null;
Map<String, String> cellMap = null;
try {
phonemap = beVipService.queryIsPhoneonUser(cellphone);
cellMap = cellPhoneService.queryCellPhone(cellphone);
if (phonemap != null && cellMap != null) {
obj.put("mailAddress", "手机已存在");
JSONUtils.printObject(obj);
return null;
}
if (phonemap == null) {
String phonecode = null;
try {
Object obje = session().getAttribute("phone");
if (obje != null) {
phonecode = obje.toString();
} else {
if ("2".equals(IConstants.ISDEMO)) {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
}
} catch (Exception e) {
e.printStackTrace();
}
if (phonecode != null) {
if (!phonecode.trim().equals(cellphone.trim())) {
obj.put("mailAddress", "与获取验证码手机号不一致");
JSONUtils.printObject(obj);
return null;
}
}
if (!"1".equals(IConstants.ISDEMO)) {
// 验证码
String vilidataNum = SqlInfusion.FilteSqlInfusion(paramMap.get("cellcode"));
if (StringUtils.isBlank(vilidataNum)) {
obj.put("mailAddress", "请填写验证码");
JSONUtils.printObject(obj);
return null;
}
String randomCode = null;
Object objec = session().getAttribute("randomCode");
if (objec != null) {
randomCode = objec.toString();
} else {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
if (randomCode != null) {
if (!randomCode.trim().equals(vilidataNum.trim())) {
obj.put("mailAddress", "请输入正确的验证码");
JSONUtils.printObject(obj);
return null;
}
}
}
}
String userName = SqlInfusion.FilteSqlInfusion(paramMap.get("userName")); // 用户名
if (userName.length() < 2 || userName.length() > 20) {
obj.put("mailAddress", "18");
JSONUtils.printObject(obj);
return null;
}
if (StringUtils.isBlank(userName)) {
obj.put("mailAddress", "13");
JSONUtils.printObject(obj);
return null;
}
// 验证用户名木含有特殊字符串处理第一个字符不可以是下划线开始 ^[^@\/\'\\\"#$%&\^\*]+$
if (userName.replaceAll("^[\u4E00-\u9FA5A-Za-z0-9_]+$", "").length() != 0) {
obj.put("mailAddress", "20");
JSONUtils.printObject(obj);
return null;
}
// 判断第一个字符串不能使以下划线开头的
String fristChar = userName.substring(0, 1);
if (fristChar.equals("_")) {
obj.put("mailAddress", "21");
JSONUtils.printObject(obj);
return null;
}
String password = SqlInfusion.FilteSqlInfusion(paramMap.get("password")); // 用户密码
String md5Password = password;
if (StringUtils.isBlank(password)) {
obj.put("mailAddress", "14");
JSONUtils.printObject(obj);
return null;
}
String confirmPassword =
SqlInfusion.FilteSqlInfusion(paramMap.get("confirmPassword")); // 用户密码
if (StringUtils.isBlank(confirmPassword)) {
obj.put("mailAddress", "15");
JSONUtils.printObject(obj);
return null;
}
String refferee = SqlInfusion.FilteSqlInfusion(paramMap.get("refferee"));
@SuppressWarnings("unused")
String param = SqlInfusion.FilteSqlInfusion(paramMap.get("param")); // 邀请好友链接携带的参数
Map<String, Object> map = null;
long recommendUserId = -1;
if (StringUtils.isNotBlank(refferee)) {
Map<String, String> userIdMap = userService.queryIdByUser(refferee); // 根据用户查询用户明细
if (userIdMap != null) {
recommendUserId = Convert.strToLong(userIdMap.get("id"), -1);
}
map = relationService.isPromoter(refferee);
if (map == null) {
refferee = null;
}
if (userIdMap == null && map == null) {
obj.put("mailAddress", "5");
JSONUtils.printObject(obj);
return null;
}
}
// 判断密码是否一致
if (!password.equals(confirmPassword)) {
obj.put("mailAddress", "1");
JSONUtils.printObject(obj);
return null;
}
Long userId = -1L;
Long result = userService.isExistEmailORUserName(null, userName);
boolean isExist = adminService.isExistUserName(userName);
if (result > 0 || isExist) { // 用户名重复
obj.put("mailAddress", "2");
JSONUtils.printObject(obj);
return null;
}
int typelen = -1;
Map<String, String> lenMap = null;
lenMap = userService.querymaterialsauthtypeCount(); // 查询证件类型主表有多少种类型
if (lenMap != null && lenMap.size() > 0) {
typelen = Convert.strToInt(lenMap.get("cccc"), -1);
// 调用service
if (typelen != -1) {
// 判断是否使用了加密字符串
if ("1".equals(IConstants.ENABLED_PASS)) {
md5Password = com.shove.security.Encrypt.MD5(md5Password.trim());
} else {
md5Password = com.shove.security.Encrypt.MD5(md5Password.trim() + IConstants.PASS_KEY);
}
userId =
cellPhoneService.usercellRegister(
cellphone, userName, md5Password, refferee, map, typelen); // 注册用户 和 初始化图片资料
}
}
if (userId < 0) { // 注册失败
obj.put("mailAddress", "4");
JSONUtils.printObject(obj);
return null;
} else {
// 添加通知默认方法
homeInfoSettingService.addNotes(userId, true, false, false);
homeInfoSettingService.addNotesSetting(
userId, true, true, true, true, true, false, false, false, false, false, false, false,
false, false, false);
// ====
obj.put("mailAddress", "注册成功"); // 注册成功
JSONUtils.printObject(obj);
}
// 修改之前的推荐
try {
if (recommendUserId > 0) { // 判断是否为空
List<Map<String, Object>> list =
recommendUserService.queryRecommendUser(null, userId, null); // 查询用户是否已经存在关系了。
if (list != null && list.size() > 0) { // 判断之前是否已经有关系了。
return null;
}
recommendUserService.addRecommendUser(userId, recommendUserId);
}
} catch (Exception e) {
log.error(e);
e.printStackTrace();
}
AccountUserDo user = new AccountUserDo();
user.setUsername(userName);
user.setPassword(password);
user.setEmail("*****@*****.**");
bbsRegisterService.doRegisterByAsynchronousMode(user);
} catch (Exception e) {
obj.put("mailAddress", "16");
JSONUtils.printObject(obj);
e.printStackTrace();
throw e;
}
return null;
}
/**
* 更新用户信息
*
* @return
* @throws Exception
*/
public String userManageUpd() throws Exception {
// String username = paramMap.get("username");
String userid = SqlInfusion.FilteSqlInfusion(paramMap.get("id"));
String realName = SqlInfusion.FilteSqlInfusion(paramMap.get("realName"));
String highestEdu = SqlInfusion.FilteSqlInfusion(paramMap.get("highestEdu"));
if (highestEdu.equals("-1")) highestEdu = "";
String idNo = SqlInfusion.FilteSqlInfusion(paramMap.get("idNo"));
String address = SqlInfusion.FilteSqlInfusion(paramMap.get("address"));
String sex = SqlInfusion.FilteSqlInfusion(paramMap.get("sex"));
// String email = paramMap.get("email");
String birthday = SqlInfusion.FilteSqlInfusion(paramMap.get("birthday"));
String cellPhone = SqlInfusion.FilteSqlInfusion(paramMap.get("cellPhone"));
Long returnupd1 =
userManageServic.updateUserAllInfo(
Long.parseLong(userid), realName, highestEdu, idNo, address, sex, birthday, cellPhone);
if (returnupd1 < 0) {
JSONUtils.printStr("0");
return "success";
}
String usrCustId = paramMap.get("usrCustId");
if (returnupd1 == 1) {
// String cmdId = "AcctModify";
// 账户信息修改
String html = ChinaPnRInterface.AccountUpdate(usrCustId);
JSONUtils.printStr("1");
sendHtml(html);
}
String work_id = SqlInfusion.FilteSqlInfusion(paramMap.get("work_id"));
if (work_id.equals("")) work_id = "0";
String job = SqlInfusion.FilteSqlInfusion(paramMap.get("job"));
String monthlyIncome = SqlInfusion.FilteSqlInfusion(paramMap.get("monthlyIncome"));
String orgName = SqlInfusion.FilteSqlInfusion(paramMap.get("orgName"));
String companyTel = SqlInfusion.FilteSqlInfusion(paramMap.get("companyTel"));
String companyType = SqlInfusion.FilteSqlInfusion(paramMap.get("companyType"));
String workEmail = SqlInfusion.FilteSqlInfusion(paramMap.get("workEmail"));
String companyScale = SqlInfusion.FilteSqlInfusion(paramMap.get("companyScale"));
String companyAddress = SqlInfusion.FilteSqlInfusion(paramMap.get("companyAddress"));
String workYear = SqlInfusion.FilteSqlInfusion(paramMap.get("workYear"));
Long returnupd2 =
userManageServic.updUserWorkAllInfo(
Long.parseLong(work_id),
Long.parseLong(userid),
job,
monthlyIncome,
orgName,
companyTel,
companyType,
workEmail,
companyScale,
companyAddress,
workYear);
if (returnupd2 < 0) {
JSONUtils.printStr("0");
return "success";
}
JSONUtils.printStr("1");
return "success";
}