Пример #1
0
  @SuppressWarnings("unchecked")
  public String search() {
    pageBean = (PageBean) request.getSession().getAttribute("pageBean");
    if (pageBean == null) {
      pageBean = new PageBean();
      request.getSession().setAttribute("pageBean", pageBean);
    }
    if (this.getPageNo() <= 0) pageBean.setCurrentPage(1);
    else pageBean.setCurrentPage(this.getPageNo());

    Organization org = (Organization) request.getSession().getAttribute("currentOrganization");
    if (!orgCode.equals("")) {
      org = orgDAO.findById(orgCode);
    }

    // 构造查询
    String queryStr = "";
    String countStr = "";
    int min = 0, max = 10000000;
    if (!minMount.equals("")) {
      min = Integer.valueOf(minMount);
    }
    if (!maxMount.equals("")) {
      max = Integer.valueOf(maxMount);
    }
    String db_startDate = AppCommonVarRegiter.getXun(startDate, start_xun);
    String db_endDate = AppCommonVarRegiter.getXun(endDate, end_xun);
    String orgField = "";
    if (org.getOrgType().equals("00")) orgField = "orgInnerCode01";
    else if (org.getOrgType().equals("01")) orgField = "orgInnerCode02";
    else orgField = "orgInnerCode03";
    String matchCode = (String) orgDAO.getOrgInnerInfo(org)[0];
    String db_itemuid = "";
    String db_termno = "";
    String db_termseq = "";
    if (itemUids != null
        && !itemUids.equals("")
        && !itemUids.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
        && !itemUids.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
      db_itemuid = itemUids;
    }
    if (termnos != null
        && !termnos.equals("")
        && !termnos.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
        && !termnos.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
      db_termno = termnos;
    }
    if (termSeqs != null
        && !termSeqs.equals("")
        && !termSeqs.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
        && !termSeqs.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
      db_termseq = termSeqs.trim();
    }
    queryStr =
        "select m from TranStatXun m, Terminfo t where t.delflag is null and t.registType = '1' and t.termno = m.id.termno and t.termSeq = m.id.termseq and t."
            + orgField
            + " like '"
            + matchCode
            + "%' and t.itemUid like '"
            + db_itemuid
            + "%' and m.id.termno like '"
            + db_termno
            + "%' and m.id.termseq like '"
            + db_termseq
            + "%' and m.id.statDate >= '"
            + db_startDate
            + "' and m.id.statDate <= '"
            + db_endDate
            + "' and m.id.sourceTag = '"
            + sourceTag
            + "' and m.tranAmount >= "
            + min
            + " and m.tranAmount <= "
            + max
            + " order by m.id.statDate,m.id.termno,m.tranAmount";
    countStr =
        "select count(*) from TranStatXun m, Terminfo t where t.delflag is null and t.registType = '1' and t.termno = m.id.termno and t.termSeq = m.id.termseq and t."
            + orgField
            + " like '"
            + matchCode
            + "%' and t.itemUid like '"
            + db_itemuid
            + "%' and m.id.termno like '"
            + db_termno
            + "%' and m.id.termseq like '"
            + db_termseq
            + "%' and m.id.statDate >= '"
            + db_startDate
            + "' and m.id.statDate <= '"
            + db_endDate
            + "' and m.id.sourceTag = '"
            + sourceTag
            + "' and m.tranAmount >= "
            + min
            + " and m.tranAmount <= "
            + max;
    xunStatList.addAll(xunStatDAO.findByPageSupport(countStr, queryStr, pageBean));
    if (xunStatList.size() > 0) {
      // 翻译业务码
      for (TranStatXun data : xunStatList) {
        data.setTradeType(TranTypeLib.trantypeHs.get(data.getTradeType()));
      }
    }
    return SUCCESS;
  }
Пример #2
0
 @SuppressWarnings("unchecked")
 public String excelReport() {
   // 从session中获取当前机构及当前用户
   Authuser user = (Authuser) request.getSession().getAttribute("currentUser");
   Organization org = null;
   if (!orgCode.equals("")) {
     org = orgDAO.findById(orgCode);
   } else {
     org = (Organization) request.getSession().getAttribute("currentOrganization");
   }
   String db_startDate = AppCommonVarRegiter.getXun(startDate, start_xun);
   String db_endDate = AppCommonVarRegiter.getXun(endDate, end_xun);
   // 构造查询
   String matchCode = (String) orgDAO.getOrgInnerInfo(org)[0];
   // 计算机构下终端总数
   int totalTerm = termDAO.countOrgTerms(matchCode, org.getOrgType());
   String orgField = "";
   if (org.getOrgType().equals("00")) orgField = "orgInnerCode01";
   else if (org.getOrgType().equals("01")) orgField = "orgInnerCode02";
   else orgField = "orgInnerCode03";
   int min = 0, max = 10000000;
   if (!minMount.equals("")) {
     min = Integer.valueOf(minMount);
   }
   if (!maxMount.equals("")) {
     max = Integer.valueOf(maxMount);
   }
   String db_itemuid = "";
   String db_termno = "";
   String db_termseq = "";
   if (itemUids != null
       && !itemUids.equals("")
       && !itemUids.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
       && !itemUids.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
     db_itemuid = itemUids;
   }
   if (termnos != null
       && !termnos.equals("")
       && !termnos.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
       && !termnos.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
     db_termno = termnos;
   }
   if (termSeqs != null
       && !termSeqs.equals("")
       && !termSeqs.equals(AppCommonVarRegiter.ALL_VALUE_TAG)
       && !termSeqs.equals(AppCommonVarRegiter.NULL_VALUE_TAG)) {
     db_termseq = termSeqs.trim();
   }
   xunStatList.addAll(
       xunStatDAO.findByQuery(
           orgField,
           matchCode,
           db_itemuid,
           db_termno,
           db_termseq,
           db_startDate,
           db_endDate,
           sourceTag,
           min,
           max));
   if (xunStatList.size() > 0) {
     // 总交易笔数
     int totalTrade = 0;
     // 翻译业务码
     for (TranStatXun data : xunStatList) {
       data.setTradeType(TranTypeLib.trantypeHs.get(data.getTradeType()));
       // 交易笔数汇总
       totalTrade = totalTrade + data.getTranAmount();
       // 填写地址信息
       data.setAddress(
           termDAO.getAddresOfTerm(data.getId().getTermno(), data.getId().getTermseq()));
     }
     // 模板位置
     String templetFile = "";
     templetFile = context.getRealPath(File.separator + templateFileName);
     fileName = org.getOrgNameCn() + "交易旬累计汇总报表_" + startDate + "_" + endDate + ".xls";
     // 构造参数Beans
     Map beans = new HashMap();
     beans.put("orgName", org.getOrgNameCn());
     beans.put("dataList", xunStatList);
     beans.put("authorUser", user.getRealName());
     SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
     String makeDate = df.format(new Date());
     beans.put("createDate", makeDate);
     // 总台数
     beans.put("termNum", totalTerm);
     // 交易总笔数
     beans.put("tradeNum", totalTrade);
     float avg = 0.0f;
     if (totalTerm > 0) avg = totalTrade / totalTerm;
     beans.put("avg", avg);
     excelStream = new ExcelReport().makeReportFromTemplet(templetFile, beans);
     if (excelStream == null) {
       message = "报表模板文件不存在,请确认报表模板文件已放入指定位置!";
       request.getSession().setAttribute("ERRORMEG", message);
       return INPUT;
     }
     return "excel";
   }
   message = org.getOrgNameCn() + "在" + startDate + "-" + endDate + "期间没有旬累计汇总数据!";
   return SUCCESS;
 }