Example #1
0
 // 付款确认收汇列表
 @SuppressWarnings("unchecked")
 public String addShList() {
   Map pm = getRequestParams();
   List shDetailList = erpService.findByList(pager, "shcb_erp_sql.paymentPrint", pm);
   List wzkList = erpService.findByList(pager, "shcb_erp_sql.WZK", pm);
   request.setAttribute("list", shDetailList);
   request.setAttribute("wzkList", wzkList);
   return "add-sh-list";
 }
Example #2
0
 // 查看收汇明细信息
 @SuppressWarnings("unchecked")
 public String viewShDetail() {
   String invcode = request.getParameter("invcode");
   List shDetail = erpService.findByList("shcb_erp_sql.getSHDetail", invcode);
   request.setAttribute("shDetail", shDetail);
   return "order-sh-detail";
 }
Example #3
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 #4
0
  // 查看开票、支付明细信息
  @SuppressWarnings("unchecked")
  public String viewPayDetail() {
    Map pm = getRequestParams();
    List paymentDetail = erpService.findByList(pager, "shcb_erp_sql.getPaymentDetail", pm);

    return ajaxJson(JSONArray.fromObject(paymentDetail).toString());
  }
Example #5
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 #6
0
 // 查看支付明细信息
 @SuppressWarnings("unchecked")
 public String viewFkDetail() {
   Map pm = getRequestParams();
   List fkDetail = erpService.findByList(pager, "shcb_erp_sql.getFkDetail", pm);
   request.setAttribute("fkDetail", fkDetail);
   return "fk-detail";
 }
Example #7
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 #8
0
 // 费用总额查询
 @SuppressWarnings("unchecked")
 public String getFyDetailTotalBalance() {
   Map pm = getRequestParams();
   if (pager != null) {
     pm.put(pager.getProperty(), pager.getKeyword());
   }
   List list = erpService.getTotalBalance("shcb_erp_sql.getFyDetailTotalBalance", pm);
   return ajaxJson(JacksonMapper.writeValueAsString(list));
 }
Example #9
0
 // 查看订单跟踪明细信息
 @SuppressWarnings("unchecked")
 public String viewDetail() {
   String userAgent = request.getHeader("User-Agent");
   if (StringUtils.containsIgnoreCase(userAgent, "MSIE")) {
     browseType = BROWSE_TYPE_IE;
   }
   String salordicode = request.getParameter("salordicode");
   // List mainInfo = erpService.findByList("shcb_erp_sql.getOrderBaseInfo", salordicode);
   List shipperInfos = erpService.findByList("shcb_erp_sql.getShipperInfo", salordicode);
   List customers = erpService.findByList("shcb_erp_sql.getCustomInfo", salordicode);
   List shs = erpService.findByList("shcb_erp_sql.getShInfo", salordicode);
   List hks = erpService.findByList("shcb_erp_sql.getHkInfo", salordicode);
   List fys = erpService.findByList("shcb_erp_sql.getFyInfo", salordicode);
   // request.setAttribute("mainInfo", mainInfo);
   request.setAttribute("shippers", shipperInfos);
   request.setAttribute("customers", customers);
   request.setAttribute("shs", shs);
   request.setAttribute("hks", hks);
   request.setAttribute("fys", fys);
   return "order-view-detail";
 }
Example #10
0
 /**
  * 导出方法(excel)
  *
  * @param pager 分页参数
  * @param map 参数
  * @param xlsName excel文件名
  */
 @SuppressWarnings("unchecked")
 @InputConfig(resultName = "error")
 public void export2Excel(
     Pager pager, Map map, String xlsName, String templateName, String sqlMapId) {
   List list = erpService.findByList(pager, sqlMapId, map);
   if (list == null || list.size() == 0) {
     addActionError("导出记录不能为空。");
     return;
   }
   Map beans = new HashMap();
   beans.put("list", list);
   this.setResponseHeaderForExport(templateName, xlsName, beans);
 }
Example #11
0
 /**
  * 加载开票清单余额
  *
  * @return
  */
 @SuppressWarnings("unchecked")
 public String loadPaymentDetailBalance() {
   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());
   //		}
   List list = erpService.findByList(pager, "shcb_erp_sql.loadPaymentDetailBalance", map);
   return ajaxJson(JacksonMapper.writeValueAsString(list));
 }
Example #12
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 #13
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 #14
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 #15
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 #16
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";
 }
Example #17
0
 @SuppressWarnings("unchecked")
 public String protocol() throws SQLException {
   Map map = (Map) erpService.getObject("msg.protocolAlarm", getRequestParams());
   return ajaxJson(JacksonMapper.writeValueAsString(map));
 }
Example #18
0
 // 付款确认收汇无主预收款列表
 @SuppressWarnings("unchecked")
 public String addShWZList() {
   Map pm = getRequestParams();
   List list = erpService.findByList(pager, "shcb_erp_sql.WZK", pm);
   return ajaxJson(JacksonMapper.writeValueAsString(list));
 }
Example #19
0
 // 订单总余额查询
 public String getOrderTotalBalance() {
   String path = ServletActionContext.getServletContext().getRealPath("/WEB-INF/classes/");
   double balance = erpService.getOrderTotalBalance(path, "");
   return ajaxText(balance + "");
 }