/**
* 根据ID查询短信详细
*
* @return
*/
@Action(
value = "edit",
results = {
@Result(name = SUCCESS, location = "/sms/smssend/jsp/sms_write.jsp"),
@Result(name = ERROR, location = "/error.jsp")
})
public String edit() {
String result = SUCCESS;
if (!StringUtil.isEmpty(selectedId)) {
try {
mbnSmsHadSendVO = mbnSmsHadSendService.queryByPk(Long.parseLong(selectedId));
this.getRequest()
.setAttribute(
"smsText", StringEscapeUtils.escapeJavaScript(mbnSmsHadSendVO.getContent()));
this.getRequest().setAttribute("title", mbnSmsHadSendVO.getTitle());
Users loginUser = (Users) super.getSession().getAttribute(ApSmsConstants.SESSION_USER_INFO);
List<SmsMbnTunnelVO> tunnelList = getTunnelList(loginUser.getMerchantPin());
this.getRequest().setAttribute("tunnelList", tunnelList);
} catch (Exception e) {
e.printStackTrace();
result = ERROR;
}
}
return result;
}
/**
* 导出列表
*
* @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;
}