// 付款确认收汇列表
@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";
}
// 查看收汇明细信息
@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";
}
/**
* 货款情况
*
* @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";
}
// 查看开票、支付明细信息
@SuppressWarnings("unchecked")
public String viewPayDetail() {
Map pm = getRequestParams();
List paymentDetail = erpService.findByList(pager, "shcb_erp_sql.getPaymentDetail", pm);
return ajaxJson(JSONArray.fromObject(paymentDetail).toString());
}
/**
* 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";
}
// 查看支付明细信息
@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";
}
/**
* 核销单延期超过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";
}
// 费用总额查询
@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));
}
// 查看订单跟踪明细信息
@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";
}
/**
* 导出方法（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);
}
/**
* 加载开票清单余额
*
* @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));
}
/**
* 费用情况
*
* @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";
}
@SuppressWarnings("unchecked")
public String protocol() throws SQLException {
Map map = (Map) erpService.getObject("msg.protocolAlarm", getRequestParams());
return ajaxJson(JacksonMapper.writeValueAsString(map));
}
// 付款确认收汇无主预收款列表
@SuppressWarnings("unchecked")
public String addShWZList() {
Map pm = getRequestParams();
List list = erpService.findByList(pager, "shcb_erp_sql.WZK", pm);
return ajaxJson(JacksonMapper.writeValueAsString(list));
}
// 订单总余额查询
public String getOrderTotalBalance() {
String path = ServletActionContext.getServletContext().getRealPath("/WEB-INF/classes/");
double balance = erpService.getOrderTotalBalance(path, "");
return ajaxText(balance + "");
}