/** * Fct加载付款明细 * * @return * @throws SQLException */ @SuppressWarnings("unchecked") public String loadFctPaymentDetail() { Map map = getRequestParams(); // String odatefrom = (String) map.get("odatefrom"); // String odateto = (String) map.get("odateto"); map.put("userflags", WebUtils.getUser().getFlags()); // if((odatefrom==null || StringUtils.isEmpty(odatefrom)) && (odateto==null || // StringUtils.isEmpty(odateto))){ // map.put("odatefrom", DateUtil.getCurrFirstDate()); // map.put("odateto", DateUtil.getCurrLastDate()); // } if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.loadPaymentDetail"); return ERROR; } try { pager = erpService.findByPager(pager, "shcb_erp_sql.loadPaymentDetail", map); } catch (SQLException e) { return ERROR; } request.setAttribute("params", map); return "fct-invk"; }
/** * 货款情况 * * @throws SQLException */ @InputConfig(resultName = "error") @SuppressWarnings("unchecked") public String payment() throws SQLException { Map map = getRequestParams(); // String odatefrom = (String) map.get("odatefrom"); // String odateto = (String) map.get("odateto"); // if((odatefrom==null || StringUtils.isEmpty(odatefrom)) && (odateto==null || // StringUtils.isEmpty(odateto))){ // map.put("odatefrom", DateUtil.getCurrFirstDate()); // map.put("odateto", DateUtil.getCurrLastDate()); // } if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } map.put("flag", "all"); if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.getCostDetail"); return ERROR; } pager = erpService.findByPager(pager, "shcb_erp_sql.getCostDetail", map); System.out.println("Here Request is =============\t" + (request == null)); request.setAttribute("params", map); System.out.println("map is =============\t" + (map)); return "payment-list"; }
/** * 核销单延期超过60天未退订单 * * @throws SQLException */ @SuppressWarnings("unchecked") public String expfccheckList() throws SQLException { if (pager == null) { pager = new Pager(); } Map map = getRequestParams(); pager = erpService.findByPager(pager, "erp.getExpfccheckList", map); return "expfccheck-list"; }
/** * 费用情况 * * @throws SQLException */ @SuppressWarnings("unchecked") public String fy() throws SQLException { Map map = getRequestParams(); if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.getFyDetail"); return ERROR; } pager = erpService.findByPager(pager, "shcb_erp_sql.getFyDetail", map); request.setAttribute("params", map); return "fy-list"; }
/** * 出口数量统计 * * @throws SQLException */ @SuppressWarnings("unchecked") public String qtySum() throws SQLException { Map map = getRequestParams(); System.out.println("map:\t" + map); if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.getQtyStatistical"); return ERROR; } pager = erpService.findByPager(pager, "shcb_erp_sql.getQtyStatistical", map); System.out.println("request is null2:\t" + (request == null)); request.setAttribute("params", map); return "qty-list"; }
/** * 收汇明细账 * * @throws SQLException */ @SuppressWarnings("unchecked") public String detail1() throws SQLException { if (pager == null) { pager = new Pager(); } pager.setPageSize(20); String invicode = request.getParameter("invicode"); Map map = getRequestParams(); String s = request.getParameter("sum"); double sum = 0d; if (StringUtils.isNotEmpty(s)) { sum = Double.valueOf(s); } pager = erpService.findByPager(pager, "shcb_erp_sql.getSHDetail1", map); request.setAttribute("invicode", invicode); request.setAttribute("sum", sum); return "detail-list"; }
/** * 收汇总账 * * @throws SQLException */ @SuppressWarnings("unchecked") public String sh() throws SQLException { Map map = getRequestParams(); if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.getShTotal"); // List list = erpService.findByList(pager,"shcb_erp_sql.getShTotal", map); // Map beans = new HashMap(); // beans.put("list", list); // this.setResponseHeaderForExport("sh",xlsName, beans); return ERROR; } pager = erpService.findByPager(pager, "shcb_erp_sql.getShTotal", map); request.setAttribute("params", map); return "sh-list"; }
/** * 订单跟踪 * * @throws SQLException */ @SuppressWarnings("unchecked") public String orderTrack() throws SQLException { Map map = getRequestParams(); if (pager != null) { map.put(pager.getProperty(), pager.getKeyword()); } if (!isSelectAction) { if (map.get("financefinis") == null) { map.put("financefinis", 0); } } if (xlsName != null || StringUtils.isNotEmpty(xlsName)) { this.export2Excel(pager, map, xlsName, xlsName, "shcb_erp_sql.mainDataQuery"); return ERROR; } // pager = erpService.findByPager(pager, "shcb_erp_sql.getSalorderInfo", map); pager = erpService.findByPager(pager, "shcb_erp_sql.mainDataQuery", map); request.setAttribute("params", map); return "order-track"; }