/**
   * 修改指定的通讯费信息
   *
   * @return String
   */
  public String comsPayCommunicationUpdate() {
    ComsPayCommunication ComsPayCommunication =
        (ComsPayCommunication) request.getSession().getAttribute("ComsPayCommunication");
    Authuser user = (Authuser) request.getSession().getAttribute("currentUser");

    ComsPayCommunication.setReimbursedNum(reimbursedNum);
    ComsPayCommunication.setReimbursedMoney(reimbursedMoney);
    ComsPayCommunication.setReimbursedType(reimbursedType);
    ComsPayCommunication.setInvoiceCode(invoiceCode);
    ComsPayCommunication.setTermid(termid);
    ComsPayCommunication.setTermno(termnos);
    ComsPayCommunication.setTermseq(termSeqs);
    ComsPayCommunication.setAddress(address);
    ComsPayCommunication.setItemUid(addItemUid); // 从终端表取得项目编号
    ComsPayCommunication.setCostTypeCode("100016");
    ComsPayCommunication.setRealCost(realCost);

    ComsPayCommunication.setOrgInnerCode01(orgInnerCode01);
    ComsPayCommunication.setOrgInnerCode02(orgInnerCode02);
    ComsPayCommunication.setOrgInnerCode03(orgInnerCode03);

    ComsPayCommunication.setRemark(remark);
    ComsPayCommunication.setPayState("1");
    ComsPayCommunication.setTransactionPerson(tsPerson);
    ComsPayCommunication.setUserid(user.getUserid());
    ComsPayCommunication.setSubmitDate(DateConvert.Date2String(new java.util.Date()));
    ComsPayCommunication.setCostDate(startCostDate);

    try {
      // 修改通讯费
      comsPayCommunicationService.updateComsPayCommunication(ComsPayCommunication);
      // 加上审计日志
      new LogAssistant(
              user.getUsername().trim(),
              request.getRemoteAddr() + ":" + TrackOpterationEnum.UPDATE.getOperation(),
              "修改通讯费[" + payUid + "]成功")
          .logUserOpt();
      this.message = "修改通讯费信息成功!";
    } catch (RuntimeException re) {
      message = "发生内部异常,修改通讯费[" + payUid + "]失败!请与管理员联系";
      log.error(message + ",Error Message:" + re.getMessage());
    }

    return SUCCESS;
  }
  /**
   * 批量删除通讯费属性信息
   *
   * @return String
   */
  public String comsPayCommunicationDelete() {
    Authuser user = (Authuser) request.getSession().getAttribute("currentUser");

    // 获得要删除的对象ID集
    String[] idListstr = request.getParameter("ComsPayCommunicationIds").split(",");

    if (idListstr != null && idListstr.length > 0) {
      try {
        HashMap batchMap = new HashMap();
        for (String id : idListstr) {
          batchMap.put(id.trim(), id.trim());
        }
        List<String> batchList = comsPayCommunicationService.findByBatchMap(batchMap);
        if (batchList != null && batchList.size() > 0) {
          for (String id : batchList) {
            // 删除通讯费
            comsPayCommunicationService.removeComsPayCommunication(id.trim());
            // 加上审计日志
            new LogAssistant(
                    user.getUsername().trim(),
                    request.getRemoteAddr() + ":" + TrackOpterationEnum.DELETE.getOperation(),
                    "删除通讯费[" + id.trim() + "]成功")
                .logUserOpt();
            message = this.getText("il8n.app.optSuccess");
          }
        }
      } catch (BeInUseException e) {
        // message = "要删除通讯费失败,请联系系统管理员";
        this.setErrMessage("要删除通讯费失败,请联系系统管理员");
      }
      message = "删除通讯费成功";
    } else {
      // message = "删除通讯费失败,请重新操作";
      this.setErrMessage("删除通讯费失败,请重新操作");
    }
    return SUCCESS;
  }
  @SuppressWarnings("unchecked")
  public String makeReport() {
    String sql = "";
    if (getItemUids() != null
        && (!getItemUids().trim().equals(""))
        && (!getItemUids().trim().equals(AppCommonVarRegiter.ALL_VALUE_TAG))
        && (!getItemUids().trim().equals(AppCommonVarRegiter.NULL_VALUE_TAG))) {
      sql += " and v.itemUid like '" + getItemUids().trim() + "%'";
    }
    Organization orgSelected = null;
    if (getOrgCode() != null && !getOrgCode().trim().equals("")) {
      orgSelected = orgDao.findByOrgId(getOrgCode());
      String innercodeSelected = (String) orgDao.getOrgInnerInfo(orgSelected)[0];
      if (orgSelected.getOrgType().trim().equals("00"))
        sql += " and v.orgInnerCode01 like '" + innercodeSelected + "%'";
      else if (orgSelected.getOrgType().trim().equals("01"))
        sql += " and v.orgInnerCode02 like '" + innercodeSelected + "%'";
      else if (orgSelected.getOrgType().trim().equals("02"))
        sql += " and v.orgInnerCode03 like '" + innercodeSelected + "%'";
    }
    if (getTermSeqs() != null
        && (!getTermSeqs().trim().equals(""))
        && (!getTermSeqs().trim().equals(AppCommonVarRegiter.ALL_VALUE_TAG))
        && (!getTermSeqs().trim().equals(AppCommonVarRegiter.NULL_VALUE_TAG))) {
      sql += " and v.termseq = '" + getTermSeqs().trim() + "'";
    }
    if (getTermnos() != null
        && (!getTermnos().trim().equals(""))
        && (!getTermnos().trim().equals(AppCommonVarRegiter.ALL_VALUE_TAG))
        && (!getTermnos().trim().equals(AppCommonVarRegiter.NULL_VALUE_TAG))) {
      sql += " and v.termno = '" + getTermnos().trim() + "'";
    }
    if (this.getSearchStartDate() != null && !getSearchStartDate().equals("")) {
      sql =
          sql
              + " and v.costDate >='"
              + DateConvert.convertAtoB(getSearchStartDate(), "yyyy-MM", "yyyyMM")
              + "'";
    }
    if (this.getSearchEndDate() != null && !getSearchEndDate().equals("")) {
      sql =
          sql
              + " and v.costDate <='"
              + DateConvert.convertAtoB(getSearchEndDate(), "yyyy-MM", "yyyyMM")
              + "'";
    }
    String state = this.getSearchPayState();
    if (state != null && !state.equals("")) {
      if (state != "0" && !state.equals("0")) {
        sql = sql + " and v.payState ='" + state + "'";
      }
    }

    // 构造查询
    String queryStr =
        " select v from ComsPayCommunication v where 1=1 " + sql + " order by v.termno,v.costDate";
    List<ComsPayCommunication> dataList = new ArrayList<ComsPayCommunication>();
    dataList.addAll(comsPayCommunicationDao.getAllDataByQuery(queryStr));
    if (dataList != null && dataList.size() > 0) {
      // 翻译
      for (ComsPayCommunication pay : dataList) {
        pay.setCostDate(
            AppCommonVarRegiter.changeTimeStyle("yyyyMM", pay.getCostDate(), "yyyy-MM"));
        // 运营机构
        pay.setOrgInnerCode01(orgDao.findByInnerCode(pay.getOrgInnerCode01()).getOrgNameCn());
        // 项目
        pay.setItemUid(comsProjectDao.findById(pay.getItemUid()).getItemName());
      }
      Authuser authuser = (Authuser) request.getSession().getAttribute("currentUser");
      filename = "通讯费支付历史明细报表.xls";

      Map beans = new HashMap();
      beans.put("orgName", orgSelected.getOrgNameCn());
      beans.put("authorUser", authuser.getRealName());
      Date createDate = new Date();
      beans.put("createDate", createDate);
      beans.put("dataList", dataList);
      HSSFWorkbook wb = new HSSFWorkbook();
      Configuration config = new Configuration();
      XLSTransformer transformer = new XLSTransformer(config);
      InputStream is = null;
      try {
        is = new FileInputStream(request.getRealPath("/WEB-INF") + filepath);
        wb = transformer.transformXLS(is, beans);
        // 产生POI输出流
        ByteArrayOutputStream os = new ByteArrayOutputStream();
        wb.write(os);
        excelStream = new ByteArrayInputStream(os.toByteArray());
      } catch (IOException e) {
        e.printStackTrace();
      }
      message = "生成报表:" + filename;
      new LogAssistant(
              authuser.getUsername().trim(),
              request.getRemoteAddr() + ":" + TrackOpterationEnum.MAKEREPORT.getOperation(),
              message)
          .logUserOpt();
      return "excel";
    } else {
      message = "没有通讯费支付记录!";
    }
    return SUCCESS;
  }
  /**
   * 添加通讯费支付信息
   *
   * @return String
   */
  public String comsPayCommunicationAdd() {
    Authuser user = (Authuser) request.getSession().getAttribute("currentUser");
    /** 得到支付期间 */
    Date startDate = DateConvert.Convert(startCostDate + "-01");
    Date endDate = DateConvert.Convert(endCostDate + "-01");

    int months = AppCommonVarRegiter.countMonthSpace(startDate, endDate);
    double realPayCost = 0;
    // 如果有多个月份需要平分支付金额
    if (payTotalMoney != 0 && months != 0 && (sTermNo != null && sTermNo.length > 0)) {
      realPayCost = payTotalMoney / (months * sTermNo.length);
    }
    String batchNum = UUID.randomUUID().toString();
    List<ComsPayCommunication> addList = new ArrayList<ComsPayCommunication>();

    if (sTermNo != null && sTermNo.length > 0) {
      for (int j = 0; j < sTermNo.length; j++) {
        String termBatchNum = UUID.randomUUID().toString();
        for (int i = 0; i < months; i++) {
          String date = DateConvert.getNextMonth(startDate, i, "yyyyMM");
          ComsPayCommunication ComsPayCommunication = new ComsPayCommunication();
          ComsPayCommunication.setReimbursedNum(reimbursedNum);
          ComsPayCommunication.setReimbursedMoney(reimbursedMoney);
          ComsPayCommunication.setReimbursedType(reimbursedType);
          ComsPayCommunication.setInvoiceCode(invoiceCode);
          ComsPayCommunication.setTermid(Integer.parseInt(sTermInfoId[j].trim()));
          ComsPayCommunication.setTermno(sTermNo[j].trim());
          ComsPayCommunication.setTermseq(sTermSeq[j].trim());
          ComsPayCommunication.setAddress(sAddress[j].trim());
          ComsPayCommunication.setItemUid(sItemUid[j].trim()); // 从终端表取得项目编号
          ComsPayCommunication.setOrgInnerCode01(sOrgInnerCode01[j]);
          ComsPayCommunication.setOrgInnerCode02(sOrgInnerCode02[j]);
          ComsPayCommunication.setOrgInnerCode03(sOrgInnerCode03[j]);
          ComsPayCommunication.setRemark(remark);
          ComsPayCommunication.setCostTypeCode("100016");
          ComsPayCommunication.setPayState("1");
          ComsPayCommunication.setTransactionPerson(tsPerson);
          ComsPayCommunication.setUserid(user.getUserid());
          ComsPayCommunication.setSubmitDate(DateConvert.Date2String(new java.util.Date()));
          ComsPayCommunication.setCostDate(date);
          ComsPayCommunication.setRealCost(realPayCost);
          ComsPayCommunication.setPayTotalMoney(payTotalMoney);
          ComsPayCommunication.setBatchNum(batchNum);
          ComsPayCommunication.setTermBatchNum(termBatchNum);
          addList.add(ComsPayCommunication);
        }
      }
    }
    // 添加通讯费支付
    String errMessage = comsPayCommunicationService.batchSave(addList);
    // 加上审计日志
    if (errMessage != null) {
      this.setErrMessage(errMessage);
      return INPUT;
    } else {
      String msg =
          "添加通讯费支付终端号为["
              + termnos
              + "],终端序列号为["
              + termSeqs
              + "],"
              + "支付成本期从["
              + startCostDate
              + "]到["
              + endCostDate
              + "] 成功";
      new LogAssistant(
              user.getUsername().trim(),
              request.getRemoteAddr() + ":" + TrackOpterationEnum.ADD.getOperation(),
              msg)
          .logUserOpt();
      this.message = "添加通讯费支付登记成功!";
    }

    return SUCCESS;
  }
示例#5
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;
 }