/**
  * @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;
 }
Example #7
0
  /**
   * 查询用户信息<未完成的,分页列表>
   *
   * @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;
  }