EasyUI项目之订单管理

2023-11-21 19:31:58

前言：继续讲解EasyUi项目《网上书城》之订单管理

码字不易，点个关注

转载请说明！

开发工具:eclipse，MySQL

思路

1.商家

2.买家

思维导图

思路

1.商家

商家订单前端代码listOrder1

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>商家订单页面</title>
    <link rel="stylesheet" type="text/css"
          href="${pageContext.request.contextPath}/static/js/easyui/themes/default/easyui.css">
    <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/static/js/easyui/themes/icon.css">
    <script src="https://cdn.bootcss.com/jquery/1.12.4/jquery.js"></script>
    <script type="text/javascript"
            src="${pageContext.request.contextPath}/static/js/easyui/jquery.easyui.min.js"></script>
    <script src="${pageContext.request.contextPath}/static/js/main.js"></script>
</head>
<body>
<table id="dg" style="style=" width:400px;height:200px;
"></table>

<script>

    $(function () {
        $('#dg').datagrid({
            url: '${pageContext.request.contextPath}/order.action?methodName=list&&orderState=1',
            fit: true,
            fitColumns: true,
            pagination: true,
            singleSelect: true,
            columns: [[
                // {field:'id',title:'id',width:100},
                {field: 'id', title: '书籍名称', hidden: true},
                {field: 'postalcode', title: '收货人邮编', hidden: true},
                {field: 'uid', title: '用户', width: 50},
                {field: 'consignee', title: '收货人', width: 50},
                {field: 'phone', title: '手机号', width: 50},
                {field: 'address', title: '收获人地址', width: 50},
                {field: 'orderPrice', title: '价格', width: 50},
                {field: 'sendTime', title: '发货时间', width: 50},
                {field: 'orderTime', title: '订单时间', width: 50},
                {
                    field: 'sendType', title: '发送方式', width: 50, formatter: function (value, row, index) {
                        if (row.sendType == 1) {
                            return "平邮";
                        } else if (row.sendType == 2) {
                            return "快递";
                        }
                    }
                },
                {
                    field: 'orderState', title: '订单状态', width: 100, formatter: function (value, row, index) {
                        if (row.orderState == 1) {
                            return "未发货";
                        } else if (row.orderState == 2) {
                            return "已发货";
                        } else if (row.orderState == 3) {
                            return "已签收";
                        } else if (row.orderState == 4) {
                            return "已撤单";
                        }
                    }
                },
                {
                    field: 'xxxx', title: '操作', width: 100, formatter: function (value, row, index) {
                        return '<a href="#" onclick="sendOrder();">发货</a>';

                    }
                }
            ]]
        });
    })
    
    function sendOrder() {
        var row = $('#dg').datagrid('getSelected');
        var id=0;
        if (row) {
            id = row.id;
        }else {
            alert("请勾选数据...");
            return;
        }
        $.messager.confirm('确认', '您确认想要发货吗？', function (r) {
            if (r) {
                $.ajax({
                    url: '${pageContext.request.contextPath}/order.action?methodName=cancelAndReceive&&orderState=2&id='+id,
                    success: function (data) {
                        $('#dg').datagrid('reload');
                    }
                });
            }
        })
    }
</script>
</body>
</html>

OrderDao

package com.zking.dao;

import java.util.List;

import com.zking.entity.Order;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;

public class OrderDao extends BaseDao<Order>{
	/**
	 * 购物车结算生成订单
	 * @param order
	 * @throws Exception
	 */
	public void add(Order order) throws Exception {
		String sql="insert into t_easyui_order(uid,orderTime,consignee,phone,postalcode,address,sendType,sendTime,orderPrice,orderState) values(?,now(),?,?,?,?,?,?,?,?)";
		super.executeUpdate(sql, order, new String[] {"uid","consignee","phone","postalcode","address","sendType","sendTime","orderPrice","orderState"});
	}
	
	/**
	 * 按照订单时间倒序查询
	 * @param order
	 * @param pageBean
	 * @return
	 * @throws Exception
	 */
	public List<Order> list( Order order, PageBean pageBean) throws Exception {
		String sql="select * from t_easyui_order order by orderTime desc";
		return super.executeQuery(sql, Order.class, pageBean);
	}
	
	/**
	 * 修改订单状态
	 * @param order
	 * @throws Exception
	 */
	public void editState(Order order) throws Exception {
		//如果是发货，那么还需要修改发货时间
		String sql="update t_easyui_order set orderState=? where id=?";
		int orderState = order.getOrderState();
		if(orderState==2) {
			sql="update t_easyui_order set orderState=?,sendTime=now() where id=?";
		}
		super.executeUpdate(sql, order, new String[] {"orderState","id"});
	}

}

OrderAction

package com.zking.web;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.zking.dao.OrderDao;
import com.zking.entity.Order;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;
import com.zking.util.PageBean;
import com.zking.util.R;
import com.zking.util.ResponseUtil;

public class OrderAction extends ActionSupport implements ModelDriver<Order> {

	private Order order=new Order();
	private OrderDao od=new OrderDao();

	public Order getModel() {
		return order;
	}

	/**
	 * 订单管理未发货页面显示
	 * @param req
	 * @param resp
	 */
	public void list(HttpServletRequest req, HttpServletResponse resp) {
		PageBean pageBean=new PageBean();
		pageBean.setRequest(req);
		try {
			List<Order> list = od.list(order, pageBean);
			ResponseUtil.writeJson(resp,new R().data("total", pageBean.getTotal())
					.data("rows", list));
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 关于发货、撤单、签收共用的方法
	 * @param req
	 * @param resp
	 */
	public void cancelAndReceive(HttpServletRequest req, HttpServletResponse resp) {
		//order就已经包含了，将要修改的状态以及对应的订单id
		try {
			od.editState(order);
			ResponseUtil.writeJson(resp, 1);
		} catch (Exception e) {
			e.printStackTrace();
			try {
				ResponseUtil.writeJson(resp, 0);
			} catch (Exception e1) {
				e1.printStackTrace();
			}
		}
	}
 

}

xml配置

<action path="/order" type="com.zking.web.OrderAction">
	</action>

2.买家

买家订单前端代码listOrder2

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>商家订单页面</title>
    <link rel="stylesheet" type="text/css"
          href="${pageContext.request.contextPath}/static/js/easyui/themes/default/easyui.css">
    <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/static/js/easyui/themes/icon.css">
    <script src="https://cdn.bootcss.com/jquery/1.12.4/jquery.js"></script>
    <script type="text/javascript"
            src="${pageContext.request.contextPath}/static/js/easyui/jquery.easyui.min.js"></script>
    <script src="${pageContext.request.contextPath}/static/js/main.js"></script>
</head>
<body>
<table id="dg" style="style=" width:400px;height:200px;
"></table>

<script>

    $(function () {
        $('#dg').datagrid({
            url: '${pageContext.request.contextPath}/order.action?methodName=list&&orderState=2',
            fit: true,
            fitColumns: true,
            pagination: true,
            singleSelect: true,
            columns: [[
                // {field:'id',title:'id',width:100},
                {field: 'id', title: '书籍名称', hidden: true},
                {field: 'postalcode', title: '收货人邮编', hidden: true},
                {field: 'uid', title: '用户', width: 50},
                {field: 'consignee', title: '收货人', width: 50},
                {field: 'phone', title: '手机号', width: 50},
                {field: 'address', title: '收获人地址', width: 50},
                {field: 'orderPrice', title: '价格', width: 50},
                {field: 'sendTime', title: '发货时间', width: 50},
                {field: 'orderTime', title: '订单时间', width: 50},
                {
                    field: 'sendType', title: '发送方式', width: 50, formatter: function (value, row, index) {
                        if (row.sendType == 1) {
                            return "平邮";
                        } else if (row.sendType == 2) {
                            return "快递";
                        }
                    }
                },
                {
                    field: 'orderState', title: '订单状态', width: 100, formatter: function (value, row, index) {
                        if (row.orderState == 1) {
                            return "未发货";
                        } else if (row.orderState == 2) {
                            return "已发货";
                        } else if (row.orderState == 3) {
                            return "已签收";
                        } else if (row.orderState == 4) {
                            return "已撤单";
                        }
                    }
                }
            ]]
        });
    })
    
</script>
</body>
</html>

OrderItemDao

package com.zking.dao;

import java.util.List;

import com.zking.entity.OrderItem;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;

public class OrderItemDao extends BaseDao<OrderItem>{

	public void add(OrderItem t) throws Exception {
		String sql="insert into t_easyui_orderitem(oid,bid,quantity) values(?,?,?)";
		super.executeUpdate(sql, t, new String[] {"oid","bid","quantity"});
	}
	
	public List<OrderItem> list(OrderItem orderItem, PageBean pageBean) throws Exception {
		String sql = "select * from t_easyui_orderitem where 1=1";
		// oid是订单项的外键，关联了订单表的主键
		long oid = orderItem.getOid();
		if (oid != 0) {
			sql += " and oid=" + oid;
		}
		return super.executeQuery(sql, OrderItem.class, pageBean);
	}

}

OrderItemAction

package com.zking.web;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.zking.dao.OrderItemDao;
import com.zking.entity.OrderItem;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;
import com.zking.util.PageBean;
import com.zking.util.R;
import com.zking.util.ResponseUtil;

public class OrderItemAction extends ActionSupport implements ModelDriver<OrderItem> {

	private OrderItem orderItem = new OrderItem();
	private OrderItemDao oid = new OrderItemDao();

	public OrderItem getModel() {
		return orderItem;
	}

	public void list(HttpServletRequest req, HttpServletResponse resp) {
		PageBean pageBean = new PageBean();
		pageBean.setRequest(req);
		try {
			List<OrderItem> list = oid.list(orderItem, pageBean);
			ResponseUtil.writeJson(resp, new R().data("total", pageBean.getTotal()).data("rows", list));
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

配置xml

<action path="/orderItem" type="com.zking.web.OrderItemAction">
	</action>
</config>

到这里就结束了，欢迎大佬指点

码农公寓

思路

1.商家

2.买家

相关文章