Example #1
0
 /**
  * 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";
 }
Example #2
0
 /**
  * 货款情况
  *
  * @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";
 }
Example #3
0
 /**
  * 核销单延期超过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";
 }
Example #4
0
 /**
  * 费用情况
  *
  * @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";
 }
Example #5
0
  /**
   * 出口数量统计
   *
   * @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";
  }
Example #6
0
 /**
  * 收汇明细账
  *
  * @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";
 }
Example #7
0
 /**
  * 收汇总账
  *
  * @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";
 }
Example #8
0
 /**
  * 订单跟踪
  *
  * @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";
 }