/**
* 导出已发箱结果
*
* @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;
}