/**
* @param page,rows,...
* @description 提供查询分页/模糊查询分页
* @return entityMap
* @type Json
*/
@Action(
value = "listBatchSendResult",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String listBatchSendResult() {
if (!StringUtil.isEmpty(batchId)) {
PageUtil pageUtil = new PageUtil();
pageUtil.setStart(page);
pageUtil.setPageSize(rows);
pageUtil.setBatchId(Long.valueOf(batchId));
try {
Users u = (Users) super.getSession().getAttribute(ApSmsConstants.SESSION_USER_INFO);
pageUtil.setMerchantPin(u.getMerchantPin());
if (!StringUtil.isEmpty(searchBycontacts)) {
pageUtil.setContactName(URLDecoder.decode(searchBycontacts, "UTF-8"));
}
if (!StringUtil.isEmpty(sendResult) && !sendResult.equals("4")) {
pageUtil.setSendResult(Integer.valueOf(sendResult));
}
Page page = mbnSmsHadSendService.batchPage(pageUtil);
if (page != null) {
@SuppressWarnings("unchecked")
List<MbnSmsHadSend> datas = (List<MbnSmsHadSend>) page.getData();
entityMap = new HashMap<String, Object>();
entityMap.put("total", page.getRecords());
if (datas == null) {
datas = new ArrayList<MbnSmsHadSend>();
}
entityMap.put("rows", datas);
entityMap.put("totalrecords", page.getTotal());
entityMap.put("currpage", page.getStart());
}
} catch (Exception e) {
e.printStackTrace();
return ERROR;
}
}
return SUCCESS;
}
/**
* 导出已发箱结果
*
* @return
*/
@Action(
value = "exportResult",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String exportResult() {
try {
PageUtil pageUtil = new PageUtil();
pageUtil.setColumn3("export"); // 用于判断，sql是否分页
pageUtil.setBatchId(Long.valueOf(batchId));
Users u = (Users) super.getSession().getAttribute(ApSmsConstants.SESSION_USER_INFO);
pageUtil.setMerchantPin(u.getMerchantPin());
if (!StringUtil.isEmpty(searchBycontacts)) {
pageUtil.setContactName(URLDecoder.decode(searchBycontacts, "UTF-8"));
}
if (!StringUtil.isEmpty(sendResult) && !sendResult.equals("4")) {
pageUtil.setSendResult(Integer.valueOf(sendResult));
}
Page page = mbnSmsHadSendService.batchPage(pageUtil);
if (page != null) {
@SuppressWarnings("unchecked")
List<MbnSmsHadSend> datas = (List<MbnSmsHadSend>) page.getData();
entityMap = new HashMap<String, Object>();
if (datas == null) {
datas = new ArrayList<MbnSmsHadSend>();
}
int size = datas.size();
String[][] billsInArr = new String[size][4];
for (int j = 0; j < size; j++) {
MbnSmsHadSend mbnSmsHadSend = datas.get(j);
int status = mbnSmsHadSend.getSendResult();
String smsStatus = "";
switch (status) {
case -1:
smsStatus = "取消发送";
break;
case 0:
smsStatus = "未发送";
break;
case 1:
smsStatus = "已提交网关";
break;
case 2:
smsStatus = "成功";
break;
case 3:
smsStatus = "失败";
break;
default:
smsStatus = "无";
break;
}
billsInArr[j][0] = mbnSmsHadSend.getTos(); // 手机号码
billsInArr[j][1] =
(mbnSmsHadSend.getTosName() == null || mbnSmsHadSend.getTosName() == ""
? "(未知)"
: mbnSmsHadSend.getTosName()); // 接收人姓名
billsInArr[j][2] = smsStatus; // 状态 -1取消发送,0未发送,1已提交网关,2成功,3失败
billsInArr[j][3] =
(mbnSmsHadSend.getFailReason() == null || mbnSmsHadSend.getFailReason() == ""
? "(无)"
: mbnSmsHadSend.getFailReason()); // 失败原因
}
String[] cols = {"手机号码", "接收人姓名", "发送结果", "失败原因"};
String downLoadPath =
ExportUtil.exportToExcel(getRequest(), "SMS_HADSEND_RESULT", cols, billsInArr);
entityMap.put("fileName", downLoadPath);
entityMap.put("message", "导出" + size + "条已发箱发送结果记录成功！");
entityMap.put("resultcode", SUCCESS);
}
} catch (Exception e) {
entityMap = new HashMap<String, Object>();
entityMap.put("resultcode", ERROR);
entityMap.put("message", "导出已发箱发送结果出错，请稍后再试");
e.printStackTrace();
return ERROR;
}
return SUCCESS;
}
/**
* 导出列表
*
* @return
*/
@Action(
value = "export",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String export() {
PageUtil pageUtil = new PageUtil();
pageUtil.setColumn3("export"); // 用于判断，sql是否分页
try {
MbnSmsOperationClass smsOperationClass =
mbnSmsOperationClassService.findByCoding(operationId);
pageUtil.setOperationId(smsOperationClass.getId());
Users u = (Users) super.getSession().getAttribute(ApSmsConstants.SESSION_USER_INFO);
pageUtil.setMerchantPin(u.getMerchantPin());
// 设定只查询自己发送的信息
boolean isQuerySelf = false;
if (!StringUtils.isBlank(
WebUtils.getPropertyByName(com.leadtone.mas.admin.common.ApSmsConstants.QUERYSELFINFO))) {
isQuerySelf =
Boolean.valueOf(
WebUtils.getPropertyByName(
com.leadtone.mas.admin.common.ApSmsConstants.QUERYSELFINFO));
if (isQuerySelf
&& u.getUserType()
== com.leadtone.mas.admin.common.ApSmsConstants.USER_TYPE_ENTERPRISE_NORMAL) {
pageUtil.setCreateBy(u.getId());
}
}
if (!StringUtil.isEmpty(searchBycontacts)) {
pageUtil.setContactName(URLDecoder.decode(searchBycontacts, "UTF-8"));
}
if (!StringUtil.isEmpty(searchBySmsTitle)) {
pageUtil.setSmsTitle(URLDecoder.decode(searchBySmsTitle, "UTF-8"));
}
if (!StringUtil.isEmpty(searchAct)) {
Timestamp endDate = new Timestamp(System.currentTimeMillis());
switch (Integer.valueOf(searchAct)) {
case 1: // all
break;
case 2: // 一天内
pageUtil.setEndDate(endDate);
Date startDateDay = DateUtil.oneDayAgo(endDate);
pageUtil.setStartDate(startDateDay);
break;
case 3: // 一周内 7天
pageUtil.setEndDate(endDate);
Date startDateWeek = DateUtil.oneWeekAgo(endDate);
pageUtil.setStartDate(startDateWeek);
break;
case 4: // 一月内 30天
pageUtil.setEndDate(endDate);
Date startDateMonth = DateUtil.oneMonthAgo(endDate);
pageUtil.setStartDate(startDateMonth);
break;
case 5: // 时间区间dateFrom
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
if (!StringUtil.isEmpty(dateTo)) {
pageUtil.setEndDate(format.parse(dateTo));
}
if (!StringUtil.isEmpty(dateFrom)) {
pageUtil.setStartDate(format.parse(dateFrom));
}
break;
}
}
Page page = mbnSmsHadSendService.extPortAll(pageUtil);
if (page != null) {
@SuppressWarnings("unchecked")
List<MbnSmsHadSendVO> datas = (List<MbnSmsHadSendVO>) page.getData();
entityMap = new HashMap<String, Object>();
if (datas == null) {
datas = new ArrayList<MbnSmsHadSendVO>();
}
String tunnelName = "";
int size = datas.size();
String[][] billsInArr = new String[size][7];
for (int j = 0; j < size; j++) {
MbnSmsHadSendVO mbnSmsHadSendVO = datas.get(j);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
switch (mbnSmsHadSendVO.getTunnelType()) {
case 1:
tunnelName = "话机";
break;
case 3:
tunnelName = "猫池";
break;
case 2:
tunnelName = "移动";
break;
case 4:
tunnelName = "联通";
break;
case 6:
tunnelName = "电信";
break;
default:
tunnelName = "无";
}
String smsStatus = "";
switch (mbnSmsHadSendVO.getSendResult()) {
case -1:
smsStatus = "取消发送";
break;
case 0:
smsStatus = "未发送";
break;
case 1:
smsStatus = "已提交网关";
break;
case 2:
smsStatus = "成功";
break;
case 3:
smsStatus = "失败";
break;
default:
smsStatus = "无";
break;
}
billsInArr[j][0] = mbnSmsHadSendVO.getTosName(); // 用户名称
billsInArr[j][1] = mbnSmsHadSendVO.getTos(); // 手机号码
billsInArr[j][2] = mbnSmsHadSendVO.getTitle(); // 短信标题
billsInArr[j][3] = mbnSmsHadSendVO.getContent(); // 短信内容
billsInArr[j][4] = smsStatus;
billsInArr[j][5] =
(null == mbnSmsHadSendVO.getReadySendTime()
? ""
: sdf.format(mbnSmsHadSendVO.getReadySendTime())); // 发送时间
billsInArr[j][6] = tunnelName;
// billsInArr[j][3] = ""+mbnSmsHadSendVO.getContent().length(); //短信长度
// billsInArr[j][5] = ""+mbnSmsHadSendVO.getReplyCount(); // 回复
}
String[] cols = {"用户名称", "用户手机号码", "短信标题", "短信内容", "发送状态", "发送时间", "发送通道名称"};
String downLoadPath =
ExportUtil.exportToExcel(getRequest(), "SMS_HADSEND", cols, billsInArr);
entityMap.put("fileName", downLoadPath);
entityMap.put("message", "导出" + size + "条已发箱记录成功！");
entityMap.put("resultcode", SUCCESS);
}
} catch (Exception e) {
entityMap = new HashMap<String, Object>();
entityMap.put("resultcode", ERROR);
entityMap.put("message", "导出已发箱出错，请稍后再试");
e.printStackTrace();
return ERROR;
}
return SUCCESS;
}
@Action(
value = "retry",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String retry() {
String result = SUCCESS;
entityMap = new HashMap<String, Object>();
if (!StringUtil.isEmpty(smsIds)) {
try {
// String[] stringArr = smsIds.split(",");
// Long[] ids = ConvertUtil.arrStringToLong(stringArr);
// List<MbnSmsHadSend> smsList = mbnSmsHadSendService.getByPks(ids);
PageUtil pageUtil = new PageUtil();
pageUtil.setBatchId(Long.parseLong(smsIds));
pageUtil.setSendResult(3);
List<MbnSmsHadSend> smsList = null;
Page batchTry = mbnSmsHadSendService.batchPage(pageUtil);
if (batchTry != null) {
smsList = (List<MbnSmsHadSend>) batchTry.getData();
}
if (smsList != null) {
ListIterator<MbnSmsHadSend> smsIterator = smsList.listIterator();
List<MbnSmsReadySend> smsRetry = new ArrayList<MbnSmsReadySend>();
long batchId = PinGen.getSerialPin();
while (smsIterator.hasNext()) {
MbnSmsHadSend tempSms = smsIterator.next();
MbnSmsReadySend tempTry = new MbnSmsReadySend();
tempTry.setBatchId(batchId);
tempTry.setContent(tempSms.getContent());
tempTry.setCreateBy(tempSms.getCreateBy());
tempTry.setCutApartNumber(tempSms.getCutApartNumber());
tempTry.setDescription(tempSms.getDescription());
tempTry.setId(PinGen.getSerialPin());
tempTry.setMerchantPin(tempSms.getMerchantPin());
tempTry.setOperationId(tempSms.getOperationId());
tempTry.setPriorityLevel(tempSms.getPriorityLevel());
tempTry.setProvince(tempSms.getProvince());
tempTry.setSelfMobile(tempSms.getSelfMobile());
tempTry.setSmsAccessNumber(tempSms.getSmsAccessNumber());
tempTry.setTaskNumber(tempSms.getTaskNumber());
tempTry.setTitle(tempSms.getTitle());
tempTry.setTos(tempSms.getTos());
tempTry.setTosName(tempSms.getTosName());
tempTry.setTunnelType(tempSms.getTunnelType());
tempTry.setWebService(tempSms.getWebService());
tempTry.setCompleteTime(null);
// retry
tempTry.setReadySendTime(new Date());
tempTry.setCommitTime(new Date());
tempTry.setSendResult(ApSmsConstants.SMS_READY_STATE);
tempTry.setFailReason("");
tempTry.setExpireTime(null);
smsRetry.add(tempTry);
}
mbnSmsReadySendService.batchSaveByList(smsRetry);
entityMap.put("resultcode", "success");
entityMap.put("message", "短信失败重发命令提交成功！请勿短时间内重复点击“重发失败项”按钮。");
} else {
entityMap.put("resultcode", "error");
entityMap.put("message", "未找到失败短信信息！");
}
} catch (Exception e) {
entityMap.put("resultcode", "error");
entityMap.put("message", "短信失败重发命令提交失败！请重试");
result = ERROR;
e.printStackTrace();
}
}
return result;
}
@Action(
value = "getReplyInfo",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String replyInfo() {
String result = SUCCESS;
try {
PageUtil pageUtil = new PageUtil();
pageUtil.setStart(page);
pageUtil.setBatchId(Long.parseLong(batchId));
pageUtil.setPageSize(rows);
if (!StringUtil.isEmpty(searchBycontacts)) {
pageUtil.setContactName(searchBycontacts);
}
if (!StringUtil.isEmpty(searchAct)) {
Timestamp endDate = new Timestamp(System.currentTimeMillis());
switch (Integer.valueOf(searchAct)) {
case 1: // all
break;
case 2: // 一天内
pageUtil.setEndDate(endDate);
Date startDateDay = DateUtil.oneDayAgo(endDate);
pageUtil.setStartDate(startDateDay);
break;
case 3: // 一周内 7天
pageUtil.setEndDate(endDate);
Date startDateWeek = DateUtil.oneWeekAgo(endDate);
pageUtil.setStartDate(startDateWeek);
break;
case 4: // 一月内 30天
pageUtil.setEndDate(endDate);
Date startDateMonth = DateUtil.oneMonthAgo(endDate);
pageUtil.setStartDate(startDateMonth);
break;
case 5: // 时间区间dateFrom
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
if (!StringUtil.isEmpty(dateTo)) {
pageUtil.setEndDate(format.parse(dateTo));
}
if (!StringUtil.isEmpty(dateFrom)) {
pageUtil.setStartDate(format.parse(dateFrom));
}
break;
}
}
Page m = mbnSmsHadSendService.replyPage(pageUtil);
if (m != null) {
@SuppressWarnings("unchecked")
List<MbnSmsHadSendVO> mshs = (List<MbnSmsHadSendVO>) m.getData();
entityMap = new HashMap<String, Object>();
entityMap.put("total", m.getRecords());
if (mshs == null) {
mshs = new ArrayList<MbnSmsHadSendVO>();
}
entityMap.put("rows", mshs);
entityMap.put("totalrecords", m.getTotal());
entityMap.put("currpage", m.getStart());
}
} catch (Exception e) {
e.printStackTrace();
result = ERROR;
}
return result;
}
/**
* @param page,rows,...
* @description 提供查询分页/模糊查询分页
* @return entityMap
* @type Json
*/
@Action(
value = "listHadSendSms",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String listHadSendSms() {
PageUtil pageUtil = new PageUtil();
pageUtil.setStart(page);
pageUtil.setPageSize(rows);
try {
MbnSmsOperationClass smsOperationClass =
mbnSmsOperationClassService.findByCoding(ApSmsConstants.SMS_OPERATION_CODE_HD);
pageUtil.setOperationId(smsOperationClass.getId());
Users u = (Users) super.getSession().getAttribute(ApSmsConstants.SESSION_USER_INFO);
// 设定只查询自己发送的信息
boolean isQuerySelf = false;
if (!StringUtils.isBlank(
WebUtils.getPropertyByName(com.leadtone.mas.admin.common.ApSmsConstants.QUERYSELFINFO))) {
isQuerySelf =
Boolean.valueOf(
WebUtils.getPropertyByName(
com.leadtone.mas.admin.common.ApSmsConstants.QUERYSELFINFO));
if (isQuerySelf
&& u.getUserType()
== com.leadtone.mas.admin.common.ApSmsConstants.USER_TYPE_ENTERPRISE_NORMAL) {
pageUtil.setCreateBy(u.getId());
}
}
pageUtil.setMerchantPin(u.getMerchantPin());
if (!StringUtil.isEmpty(searchBycontacts)) {
pageUtil.setContactName(URLDecoder.decode(searchBycontacts, "UTF-8"));
}
if (!StringUtil.isEmpty(searchBySmsTitle)) {
pageUtil.setSmsTitle(URLDecoder.decode(searchBySmsTitle, "UTF-8"));
}
if (!StringUtil.isEmpty(searchAct)) {
Timestamp endDate = new Timestamp(System.currentTimeMillis());
switch (Integer.valueOf(searchAct)) {
case 1: // all
break;
case 2: // 一天内
pageUtil.setEndDate(endDate);
Date startDateDay = DateUtil.oneDayAgo(endDate);
pageUtil.setStartDate(startDateDay);
break;
case 3: // 一周内 7天
pageUtil.setEndDate(endDate);
Date startDateWeek = DateUtil.oneWeekAgo(endDate);
pageUtil.setStartDate(startDateWeek);
break;
case 4: // 一月内 30天
pageUtil.setEndDate(endDate);
Date startDateMonth = DateUtil.oneMonthAgo(endDate);
pageUtil.setStartDate(startDateMonth);
break;
case 5: // 时间区间dateFrom
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
if (!StringUtil.isEmpty(dateTo)) {
pageUtil.setEndDate(format.parse(dateTo));
}
if (!StringUtil.isEmpty(dateFrom)) {
pageUtil.setStartDate(format.parse(dateFrom));
}
break;
}
}
Page page = mbnSmsHadSendService.pageVO(pageUtil);
// List<GroupUtil> groupBy = smsStatusService.groupPage(pageUtil);
if (page != null) {
@SuppressWarnings("unchecked")
List<MbnSmsHadSendVO> datas = (List<MbnSmsHadSendVO>) page.getData();
entityMap = new HashMap<String, Object>();
entityMap.put("total", page.getRecords());
if (datas == null) {
datas = new ArrayList<MbnSmsHadSendVO>();
}
entityMap.put("rows", datas);
entityMap.put("totalrecords", page.getTotal());
entityMap.put("currpage", page.getStart());
}
} catch (Exception e) {
e.printStackTrace();
return ERROR;
}
return SUCCESS;
}
/**
* 查询用户信息<未完成的，分页列表>
*
* @return
* @throws Exception
*/
@Action(
value = "query",
results = {
@Result(
type = "json",
params = {"root", "entityMap", "contentType", "text/html"})
})
public String query() {
try {
PageUtil pageUtil = new PageUtil();
pageUtil.setStart(page);
pageUtil.setPageSize(rows);
pageUtil.setMerchantPin(users.getMerchantPin());
if (portalUser != null) {
pageUtil.setAccount(portalUser.getAccount());
pageUtil.setMobile(portalUser.getMobile());
pageUtil.setEmail(portalUser.getEmail());
// Integer activeFlag =
// portalUser.getActiveFlag()== -99 ? null : portalUser.getActiveFlag();
pageUtil.setActiveFlag(portalUser.getActiveFlag());
String roleId = request.getParameter("roleId");
if (roleId != null && !"-99".equals(roleId)) pageUtil.setRoleId(Long.parseLong(roleId));
}
logger.info("role query portalUser:"******"role query pageUtil:" + pageUtil);
// REX@20130112 判断登陆用户类型
if (users.getUserType() == ApSmsConstants.USER_TYPE_SUPER_ADMIN) {
// 在省、地市 管理员的时候，不需要pin码
pageUtil.setMerchantPin(null);
String[] provArray = null;
List<Region> regionList = regionService.findProvinces();
if (regionList != null) {
provArray = new String[regionList.size()];
for (int i = 0; i < regionList.size(); i++) {
provArray[i] = String.valueOf(regionList.get(i).getId());
}
}
// 增加全省列表
pageUtil.setAreaRange(provArray);
// 设置用户类型为省管理员
pageUtil.setUserType(users.getUserType());
} else if (users.getUserType() == ApSmsConstants.USER_TYPE_PROVINCE_ADMIN) {
// 在省、地市 管理员的时候，不需要pin码
pageUtil.setMerchantPin(null);
Long provinceId = 0L;
provinceId = Long.parseLong(users.getProvince());
String[] cityArray = null;
List<Region> regionList = regionService.findCityByProvinceId(provinceId);
if (regionList != null) {
cityArray = new String[regionList.size()];
for (int i = 0; i < regionList.size(); i++) {
cityArray[i] = String.valueOf(regionList.get(i).getId());
}
}
// 增加地区列表
pageUtil.setAreaRange(cityArray);
// 设置用户类型为地市管理员
pageUtil.setUserType(users.getUserType());
} else if (users.getUserType() == ApSmsConstants.USER_TYPE_CITY_ADMIN) {
pageUtil.setMerchantPin(null);
// 增加地区列表
pageUtil.setAreaRange(new String[] {users.getCity()});
// 设置用户类型为企业管理员
pageUtil.setUserType(users.getUserType());
} else if (users.getUserType() == ApSmsConstants.USER_TYPE_ENTERPRISE_ADMIN) {
// 设置用户类型为企业管理员
pageUtil.setUserType(users.getUserType());
} else {
pageUtil.setUserType(users.getUserType());
}
Page page = userService.page(pageUtil);
if (page != null) {
@SuppressWarnings("unchecked")
List<UserVO> datas = (List<UserVO>) page.getData();
entityMap = new HashMap<String, Object>();
entityMap.put("total", page.getRecords());
if (datas == null) {
datas = new ArrayList<UserVO>();
}
entityMap.put("rows", datas);
entityMap.put("totalrecords", page.getTotal());
entityMap.put("currpage", page.getStart());
}
logger.info("query user page: " + entityMap);
} catch (Exception e) {
e.printStackTrace();
return ERROR;
}
return SUCCESS;
}