Exemplo n.º 1
0
  /**
   * 자동SMS 월간 보고서 리스트
   *
   * @param req
   * @param res
   * @return
   */
  public ModelAndView autoSMSReportMonth(HttpServletRequest req, HttpServletResponse res)
      throws Exception {

    String year = ServletUtil.getParamString(req, "sSendedYear");
    String month = ServletUtil.getParamString(req, "sSendedMonth");
    String dateList = "";

    String sendTime = year + month;

    if (Integer.parseInt(month) < 13) {
      dateList = year + "년 " + month + "월";
    } else {
      dateList = year + "년 ";
    }

    int curPage = ServletUtil.getParamInt(req, "curPage", "1");
    if (this.sCurPage != null) {
      curPage = Integer.parseInt(this.sCurPage);
      this.sCurPage = null; // 다음 호출을 위해 초기화
    }
    if (curPage <= 0) curPage = 1;

    int rowHeight = ServletUtil.getCookieValue(req, "gecko").equals("Y") ? 31 : 38;
    int iLineCnt = 20; // 라인 갯수

    try {
      iLineCnt =
          (Integer.parseInt(ServletUtil.getParamStringDefault(req, "listHeight", "0"))
              / rowHeight); // 그리드의 크기
      if (iLineCnt > 2) iLineCnt--;
    } catch (Exception e) {
    }
    Map<String, Object> searchMap = new HashMap<String, Object>();
    searchMap.put("curPage", curPage);
    searchMap.put("iLineCnt", iLineCnt);
    searchMap.put("sendTime", sendTime);

    req.setAttribute("dateList", dateList);
    req.setAttribute("curPage", Integer.toString(curPage));
    req.setAttribute("iLineCnt", Integer.toString(iLineCnt));
    req.setAttribute("message", this.message);
    this.message = ""; // 다음 호출을 위해 초기화

    int iTotalCnt = autoSMSService.getTotalCountAutoSMSReportMonth(sendTime);
    req.setAttribute("iTotalCnt", Integer.toString(iTotalCnt));

    return new ModelAndView(
        "/pages/autosms/statistic/autosms_reportmonth_proc.jsp?method=list",
        "autoSMSReportMonthList",
        autoSMSService.autoSMSReportMonth(searchMap));
  }
Exemplo n.º 2
0
  /**
   * 이벤트sms 등록
   *
   * @param req
   * @param res
   * @return
   * @throws Exception
   */
  public ModelAndView update(HttpServletRequest req, HttpServletResponse res) throws Exception {
    int autosmsID = ServletUtil.getParamInt(req, "eAutosmsID", "0");
    String autosmsTitle = ServletUtil.getParamString(req, "eAutosmsTitle");
    String userID = LoginInfo.getUserID(req);
    String description = ServletUtil.getParamString(req, "eDescription");
    String templateSenderPhone = ServletUtil.getParamString(req, "eTemplateSenderPhone");
    String templateMsg = ServletUtil.getParamString(req, "smsMsg");
    String state = ServletUtil.getParamString(req, "eState");

    AutoSMSEvent autoSMSEvent = new AutoSMSEvent();
    autoSMSEvent.setAutosmsID(autosmsID);
    autoSMSEvent.setAutosmsTitle(autosmsTitle);
    autoSMSEvent.setDescription(description);
    autoSMSEvent.setUserID(userID);
    autoSMSEvent.setTemplateSenderPhone(templateSenderPhone);
    autoSMSEvent.setTemplateMsg(templateMsg);
    autoSMSEvent.setState(state);

    int resultVal = autoSMSService.updateAutoSMSEvent(autoSMSEvent);

    if (resultVal > 0) {
      this.sCurPage = "1";
      return list(req, res);
    }

    ServletUtil.messageGoURL(res, "저장에 실패했습니다", "");

    return null;
  }
Exemplo n.º 3
0
 /**
  * 자동메일 수정창으로 이동한다.
  *
  * @param req
  * @param res
  * @return
  * @throws Exception
  */
 public ModelAndView edit(HttpServletRequest req, HttpServletResponse res) throws Exception {
   int autosmsID = ServletUtil.getParamInt(req, "eAutosmsID", "0");
   return new ModelAndView(
       "/pages/autosms/write/autosms_write_proc.jsp?method=edit",
       "autosmsEvent",
       autoSMSService.viewAutoSMSEvent(autosmsID));
 }
Exemplo n.º 4
0
  /**
   * 자동메일 목록
   *
   * @param req
   * @param res
   * @return
   * @throws Exception
   */
  public ModelAndView list(HttpServletRequest req, HttpServletResponse res) throws Exception {

    int curPage = ServletUtil.getParamInt(req, "curPage", "1");
    if (this.sCurPage != null) {
      curPage = Integer.parseInt(this.sCurPage);
      this.sCurPage = null; // 다음 호출을 위해 초기화
    }
    if (curPage <= 0) curPage = 1;

    // int countPerPage = ServletUtil.getParamInt(req,"countPerPage","10");
    int rowHeight = ServletUtil.getCookieValue(req, "gecko").equals("Y") ? 31 : 38;
    int iLineCnt = 20; // 라인 갯수

    try {
      iLineCnt =
          (Integer.parseInt(ServletUtil.getParamStringDefault(req, "listHeight", "0"))
              / rowHeight); // 그리드의 크기
      if (iLineCnt > 2) iLineCnt--;
    } catch (Exception e) {
    }

    req.setAttribute("curPage", Integer.toString(curPage));
    req.setAttribute("iLineCnt", Integer.toString(iLineCnt));
    req.setAttribute("message", this.message);
    this.message = ""; // 다음 호출을 위해 초기화

    String sSearchType = ServletUtil.getParamString(req, "sSearchType");
    String sSearchText = ServletUtil.getParamString(req, "sSearchText");

    // 페이지조건과 검색조건을 모두 map에 담아 사용하자
    Map<String, String> searchMap = new HashMap<String, String>();
    searchMap.put("sSearchType", sSearchType);
    searchMap.put("sSearchText", sSearchText);

    // 총카운트
    int iTotalCnt = autoSMSService.getTotalCountAutoSMSEvent(searchMap);
    req.setAttribute("iTotalCnt", Integer.toString(iTotalCnt));

    // ModelAndView 파라미터1: jsp 경로, 파라미터2: List 객체, 파라미터3 : service 메소드
    return new ModelAndView(
        "/pages/autosms/write/autosms_write_proc.jsp?method=list",
        "autosmsEventList",
        autoSMSService.selectAutoSMSEventList(curPage, iLineCnt, searchMap));
  }
Exemplo n.º 5
0
  /**
   * 자동메일 삭제(관련 통계 및 발송데이타를 전체 삭제한다)
   *
   * @param req
   * @param res
   * @return
   * @throws Exception
   */
  public ModelAndView delete(HttpServletRequest req, HttpServletResponse res) throws Exception {

    int autosmsID = ServletUtil.getParamInt(req, "eAutosmsID", "0");

    if (autosmsID == 0) {
      ServletUtil.messageGoURL(res, "[파라미터 오류] 삭제할 파라미터정보가 없습니다.", "");
      return null;
    }
    autoSMSService.deleteAutoSMSEventAll(autosmsID);

    return list(req, res);
  }
Exemplo n.º 6
0
  /**
   * 자동SMS 월단위 총합
   *
   * @param req
   * @param res
   * @return
   */
  public ModelAndView autoSMSReportMonthAll(HttpServletRequest req, HttpServletResponse res)
      throws Exception {

    String year = ServletUtil.getParamString(req, "sSendedYear");
    String month = ServletUtil.getParamString(req, "sSendedMonth");

    String sendTime = year + month;

    return new ModelAndView(
        "/pages/autosms/statistic/autosms_reportmonth_proc.jsp?method=countall",
        "smsStatistic",
        autoSMSService.autoSMSReportMonthAll(sendTime));
  }
Exemplo n.º 7
0
  /**
   * 자동SMS 월별 통계 리스트
   *
   * @param req
   * @param res
   * @return
   * @throws Exception
   */
  public ModelAndView statisticMonthlyList(HttpServletRequest req, HttpServletResponse res)
      throws Exception {
    int autosmsID = ServletUtil.getParamInt(req, "autosmsID", "0");
    String year = ServletUtil.getParamString(req, "sYear");
    String month = ServletUtil.getParamString(req, "sMonth");
    if (month.length() == 1) month = "0" + month;

    Map<String, Object> searchMap = new HashMap<String, Object>();
    searchMap.put("autosmsID", autosmsID);
    searchMap.put("year", year);
    searchMap.put("month", month);

    return new ModelAndView(
        "/pages/autosms/statistic/autosms_statistic_proc.jsp?method=statisticlist",
        "statisticList",
        autoSMSService.statisticMonthlyList(searchMap));
  }
Exemplo n.º 8
0
  /**
   * 자동SMS 대상자 미리보기
   *
   * @param req
   * @param res
   * @return
   */
  public ModelAndView personPreview(HttpServletRequest req, HttpServletResponse res)
      throws Exception {

    int curPage = ServletUtil.getParamInt(req, "curPage", "1");
    if (this.sCurPage != null) {
      curPage = Integer.parseInt(this.sCurPage);
      this.sCurPage = null; // 다음 호출을 위해 초기화
    }
    if (curPage <= 0) curPage = 1;

    int rowHeight = ServletUtil.getCookieValue(req, "gecko").equals("Y") ? 31 : 38;
    int iLineCnt = 20; // 라인 갯수
    try {
      iLineCnt =
          (Integer.parseInt(ServletUtil.getParamStringDefault(req, "listHeight", "0"))
              / rowHeight); // 그리드의 크기
      if (iLineCnt > 2) iLineCnt--;
    } catch (Exception e) {
    }

    int autosmsID = ServletUtil.getParamInt(req, "autosmsID", "0");
    String year = ServletUtil.getParamString(req, "sYear");
    String month = ServletUtil.getParamString(req, "sMonth");

    if (month.length() == 1) month = "0" + month;
    String day = ServletUtil.getParamString(req, "sDay");
    if (day.length() == 1) day = "0" + day;
    String standard = ServletUtil.getParamString(req, "standard");
    String type = ServletUtil.getParamString(req, "type");
    String key = ServletUtil.getParamString(req, "key");
    String sSearchType = ServletUtil.getParamString(req, "sSearchType");
    String sSearchText = ServletUtil.getParamString(req, "sSearchText");

    Map<String, Object> searchMap = new HashMap<String, Object>();
    searchMap.put("searchType", sSearchType);
    searchMap.put("searchText", sSearchText);
    searchMap.put("curPage", curPage);
    searchMap.put("iLineCnt", iLineCnt);
    searchMap.put("autosmsID", autosmsID);
    searchMap.put("year", year);
    searchMap.put("month", month);
    searchMap.put("day", day);
    searchMap.put("standard", standard);
    searchMap.put("type", type);
    searchMap.put("key", key);

    List<AutoSMSPerson> autoSMSPersonList = autoSMSService.personPreview(searchMap);

    // 총카운트 받아오기 위해
    searchMap.put("curPage", 0);
    searchMap.put("iLineCnt", 0);
    int iTotalCnt = autoSMSService.totalPorsonPreview(searchMap);
    req.setAttribute("iTotalCnt", Integer.toString(iTotalCnt));
    req.setAttribute("curPage", Integer.toString(curPage));
    req.setAttribute("iLineCnt", Integer.toString(iLineCnt));
    req.setAttribute("standard", standard);
    req.setAttribute("message", this.message);

    return new ModelAndView(
        "/pages/autosms/statistic/autosms_statistic_proc.jsp?method=personpreviewlist",
        "personPreview",
        autoSMSPersonList);
  }