/** * 修改指定的通讯费信息 * * @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 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; }
@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; }