コード例 #1
0
  /**
   * 修改指定的通讯费信息
   *
   * @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;
  }
コード例 #2
0
  /**
   * 添加通讯费支付信息
   *
   * @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;
  }
コード例 #3
0
  @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;
  }