/** 定期处理会员过期 */
public static void vipExpiredJob() {
String sql = "select user_id from t_user_vip_records where status = 1 and expiry_date <= NOW()";
List<Long> user_ids = null;
try {
user_ids = t_user_vip_records.find(sql).fetch();
} catch (Exception e) {
e.printStackTrace();
Logger.info("定时任务处理过期vip时（查询）：" + e.getMessage());
return;
}
if (user_ids == null || user_ids.size() == 0) {
return;
}
String idStr = StringUtils.join(user_ids, ",");
String updateSql =
"update t_user_vip_records set status = 0 where user_id in ( " + idStr + " )";
int rows = 0;
try {
rows = JpaHelper.execute(updateSql).executeUpdate();
} catch (Exception e) {
e.printStackTrace();
Logger.info("定时任务处理过期vip时（更新vip记录）：" + e.getMessage());
return;
}
if (rows == 0) {
return;
}
String updateSql2 = "update t_users set vip_status = 0 where id in ( " + idStr + " )";
try {
JpaHelper.execute(updateSql2).executeUpdate();
} catch (Exception e) {
JPA.setRollbackOnly();
e.printStackTrace();
Logger.info("定时任务处理过期vip时（更新用户vip状态）：" + e.getMessage());
return;
}
}
/** 完善邮箱 */
public static void doFinishEmail(String email) {
User user = User.currUser();
if (user.getIpsStatus() != IpsCheckStatus.EMAILISNULL) {
check();
}
flash.put("email", email);
user.email = email;
if (StringUtils.isBlank(email)) {
flash.error("邮箱不能为空");
finishEmail();
}
if (!RegexUtils.isEmail(email)) {
flash.error("请填写正确的邮箱地址");
finishEmail();
}
ErrorInfo error = new ErrorInfo();
User.isEmailExist(email, error);
String sql = "update t_users set email = ? where id = ?";
int rows = 0;
try {
rows = JpaHelper.execute(sql, email, user.id).executeUpdate();
} catch (Exception e) {
JPA.setRollbackOnly();
e.printStackTrace();
Logger.info("更新用户邮箱时：" + e.getMessage());
error.code = -1;
error.msg = "对不起，由于平台出现故障，此次更新邮箱失败！";
}
if (rows == 0) {
JPA.setRollbackOnly();
error.code = -1;
error.msg = "数据未更新";
}
if (error.code < 0) {
flash.error(error.msg);
finishEmail();
}
checkEmail();
}
/**
* @param time 申请vip的时长，月为单位
* @param user
* @param info
* @return
*/
public int renewal(User user, ErrorInfo error) {
error.clear();
BackstageSet backstageSet = BackstageSet.getCurrentBackstageSet();
int vipMinTimeType = backstageSet.vipMinTimeType;
int vipMinTime = backstageSet.vipMinTimeLength;
int vipTimeType = backstageSet.vipTimeType;
double vipFee = backstageSet.vipFee;
if (vipMinTimeType != 1) {
vipMinTime *= 12;
}
if (this.serviceTime < vipMinTime) {
error.code = -3;
error.msg = "vip开通不能少于最少时长";
return error.code;
}
int timeLen = this.serviceTime;
double fee = 0;
if (vipTimeType == 1) {
fee = vipFee * timeLen;
} else if (vipTimeType == 0) {
fee = Arith.mul(vipFee, serviceTime / 12);
}
fee = fee * backstageSet.vipDiscount / 10;
fee = Arith.round(fee, 2);
DataSafety data = new DataSafety();
data.id = user.id;
if (!data.signCheck(error)) {
JPA.setRollbackOnly();
return error.code;
}
v_user_for_details forDetail = DealDetail.queryUserBalance(user.id, error);
if (error.code < 0) {
return error.code;
}
if (Constants.IPS_ENABLE) {
switch (Constants.PAY_TYPE_VIP) {
// 平台内部进行转账
case PayType.INNER:
error.code = -1;
error.msg = "资金托管模式下，不能以平台内部进行转账的方式支付";
return error.code;
// 通过独立普通网关
case PayType.INDEPENDENT:
if (fee > user.balance2) {
error.code = Constants.BALANCE_NOT_ENOUGH;
error.msg = "对不起，您可用余额不足";
Map<String, Object> map = new HashMap<String, Object>();
map.put("rechargeType", RechargeType.VIP);
map.put("serviceTime", timeLen);
map.put("fee", fee);
Cache.set("rechargePay" + user.id, map, IPSConstants.CACHE_TIME);
return error.code;
}
break;
// 通过共享资金托管账户网关
case PayType.SHARED:
// 资金托管网关
case PayType.IPS:
if (this.isPay) {
break;
}
if (fee > user.balance) {
error.code = Constants.BALANCE_NOT_ENOUGH;
error.msg = "对不起，您可用余额不足";
return error.code;
}
if (fee > 0) {
error.code = Constants.BALANCE_PAY_ENOUGH;
error.msg = "请前去支付VIP费用";
Map<String, Object> map = new HashMap<String, Object>();
map.put("rechargeType", RechargeType.VIP);
map.put("serviceTime", timeLen);
map.put("fee", fee);
Cache.set("rechargePay" + user.id, map, IPSConstants.CACHE_TIME);
return error.code;
}
break;
}
} else {
if (fee > user.balance) {
error.code = Constants.BALANCE_NOT_ENOUGH;
error.msg = "对不起，您可用余额不足";
Map<String, Object> map = new HashMap<String, Object>();
map.put("rechargeType", RechargeType.VIP);
map.put("serviceTime", timeLen);
map.put("fee", fee);
Cache.set("rechargePay" + user.id, map, IPSConstants.CACHE_TIME);
return error.code;
}
}
t_user_vip_records vipRecord = new t_user_vip_records();
t_user_vip_records record = null;
int rows = 0;
if (user.vipStatus) {
try {
record = t_user_vip_records.find("user_id = ? and status = 1", user.id).first();
rows =
JpaHelper.execute(
"update t_user_vip_records set status = 0 where user_id = ? and status = 1")
.setParameter(1, user.id)
.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
Logger.info("申请vip时，查询系统设置中的vip设置时" + e.getMessage());
error.code = -1;
error.msg = "申请vip失败";
return error.code;
}
if (rows == 0) {
JPA.setRollbackOnly();
error.code = -1;
error.msg = "数据未更新，vip申请失败";
return error.code;
}
vipRecord.start_time = record.expiry_date;
vipRecord.expiry_date = DateUtil.dateAddMonth(record.expiry_date, this.serviceTime);
} else {
vipRecord.start_time = new Date();
vipRecord.expiry_date = DateUtil.dateAddMonth(new Date(), this.serviceTime);
}
vipRecord.user_id = user.id;
vipRecord.time = new Date();
vipRecord.service_fee = fee;
vipRecord.status = true;
try {
JpaHelper.execute("update t_user_vip_records set status = 0 where user_id = ? and status = 1")
.setParameter(1, user.id)
.executeUpdate();
vipRecord.save();
rows =
JpaHelper.execute("update t_users set vip_status = true where id = ?", user.id)
.executeUpdate();
} catch (Exception e) {
JPA.setRollbackOnly();
e.printStackTrace();
Logger.info("申请vip时，查询系统设置中的vip设置时" + e.getMessage());
error.code = -5;
error.msg = "申请vip失败";
return error.code;
}
if (rows == 0) {
JPA.setRollbackOnly();
error.code = -1;
error.msg = "数据未更新";
return error.code;
}
// 更新用户资金
if (Constants.PAY_TYPE_VIP == PayType.INDEPENDENT) {
error.code = DealDetail.minusUserFund2(user.id, fee);
} else {
error.code = DealDetail.minusUserFund(user.id, fee);
}
if (error.code < 0) {
JPA.setRollbackOnly();
return error.code;
}
DealDetail dealDetail = null;
forDetail = DealDetail.queryUserBalance(user.id, error);
/* 添加交易记录 */
if (Constants.PAY_TYPE_VIP == PayType.INDEPENDENT) {
dealDetail =
new DealDetail(
user.id,
DealType.CHARGE_VIP,
fee,
vipRecord.id,
forDetail.user_amount2,
forDetail.freeze,
forDetail.receive_amount,
"vip扣费");
dealDetail.addDealDetail2(error);
} else {
dealDetail =
new DealDetail(
user.id,
DealType.CHARGE_VIP,
fee,
vipRecord.id,
forDetail.user_amount,
forDetail.freeze,
forDetail.receive_amount,
"vip扣费");
dealDetail.addDealDetail(error);
}
if (error.code < 0) {
JPA.setRollbackOnly();
return error.code;
}
data.id = user.id;
data.updateSign(error);
if (error.code < 0) {
JPA.setRollbackOnly();
return error.code;
}
DealDetail.addPlatformDetail(
DealType.VIP_FEE, vipRecord.id, user.id, -1, DealType.ACCOUNT, fee, 1, "vip费用", error);
if (error.code < 0) {
JPA.setRollbackOnly();
return error.code;
}
DealDetail.userEvent(this.id, UserEvent.VIP, "申请vip", error);
if (error.code < 0) {
JPA.setRollbackOnly();
return error.code;
}
// vip申请站内信
TemplateStation station = new TemplateStation();
station.id = Templets.M_VIP_SUCCESS;
if (station.status) {
TemplateStation.addMessageTask(
userId, station.title, station.content.replace("vipFee", fee + ""));
}
// 发送邮件
TemplateEmail email = new TemplateEmail();
email.id = Templets.E_VIP_SUCCESS;
if (email.status) {
TemplateEmail.addEmailTask(
user.email, email.title, email.content.replace("vipFee", fee + ""));
}
// 发送短信
TemplateSms sms = new TemplateSms();
if (StringUtils.isNotBlank(user.mobile)) {
sms.id = Templets.S_VIP_SUCCESS;
if (sms.status) {
TemplateSms.addSmsTask(
user.mobile,
sms.content
.replace("vipFee", fee + "")
.replace("userName", user.name)
.replace("date", DateUtil.dateToString(new Date())));
}
}
if (Constants.IPS_ENABLE) {
user.balance2 = forDetail.user_amount2 - fee;
} else {
user.balance = forDetail.user_amount - fee;
}
user.vipStatus = true;
User.setCurrUser(user);
error.code = 0;
error.msg = "申请vip成功！";
return error.code;
}