/**
* 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";
}