订单相关的业务学习
首先,我们先整体看一下com.macro.mall 包下面的结构,不知道大家之前有没有学习过mvc 模式或者开发过项目,感觉和自己项目的整体结构还是有些类似的,我们接下来仔细看看。
mall-admin 后台商城管理系统接口
com.macro.mall
├── bo -- 工具类及通用代码
├── component -- 切面组件
├── config -- 配置层
├── controller -- 控制层
├── dao -- (data access object 数据访问对象,访问数据库的接口)
├── dto --(data transfer object 数据传输对象,接口之间传递的数据封装,具体的可以看参考文章)
├── service -- 服务层
└── validator -- 校验层
DTO
我们先来认识一下订单业务相关的DTO。
你会发现这个文件夹下的所有类的变量只是后台数据库表中的一部分,其实这就是DTO的产生的意义,一是提高了数据传输的速度(减少了传输字段),二是隐藏了后端表的结构。
OmsMoneyInfoParam修改订单费用信息参数(oms_order)
/**
* 修改订单费用信息参数
* Created by macro on 2018/10/29.
*/
@Getter
@Setter
public class OmsMoneyInfoParam {
@ApiModelProperty("订单ID")
private Long orderId;
@ApiModelProperty("运费金额")
private BigDecimal freightAmount;
@ApiModelProperty("管理员后台调整订单使用的折扣金额")
private BigDecimal discountAmount;
@ApiModelProperty("订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单")
private Integer status;
}
OmsOrderDeliveryParam订单发货参数(oms_order)
/**
* 订单发货参数
* Created by macro on 2018/10/12.
*/
@Getter
@Setter
public class OmsOrderDeliveryParam {
@ApiModelProperty("订单id")
private Long orderId;
@ApiModelProperty("物流公司")
private String deliveryCompany;
@ApiModelProperty("物流单号")
private String deliverySn;
}
OmsOrderDetail订单详情信息(oms_order_item、oms_order_operate_history)
/**
* 订单详情信息
* Created by macro on 2018/10/11.
*/
public class OmsOrderDetail extends OmsOrder {
@Getter
@Setter
@ApiModelProperty("订单商品列表")
private List<OmsOrderItem> orderItemList;
@Getter
@Setter
@ApiModelProperty("订单操作记录列表")
private List<OmsOrderOperateHistory> historyList;
}
OmsOrderQueryParam 订单查询参数(oms_order)
/**
* 订单查询参数
* Created by macro on 2018/10/11.
*/
@Getter
@Setter
public class OmsOrderQueryParam {
@ApiModelProperty(value = "订单编号")
private String orderSn;
@ApiModelProperty(value = "收货人姓名/号码")
private String receiverKeyword;
@ApiModelProperty(value = "订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单")
private Integer status;
@ApiModelProperty(value = "订单类型:0->正常订单;1->秒杀订单")
private Integer orderType;
@ApiModelProperty(value = "订单来源:0->PC订单;1->app订单")
private Integer sourceType;
@ApiModelProperty(value = "订单提交时间")
private String createTime;
}
OmsReceiverInfoParam订单修改收货人信息参数(oms_order)
**
* 订单修改收货人信息参数
* Created by macro on 2018/10/29.
*/
@Getter
@Setter
public class OmsReceiverInfoParam {
@ApiModelProperty(value = "订单ID")
private Long orderId;
@ApiModelProperty(value = "收货人姓名")
private String receiverName;
@ApiModelProperty(value = "收货人电话")
private String receiverPhone;
@ApiModelProperty(value = "收货人邮编")
private String receiverPostCode;
@ApiModelProperty(value = "详细地址")
private String receiverDetailAddress;
@ApiModelProperty(value = "省份/直辖市")
private String receiverProvince;
@ApiModelProperty(value = "城市")
private String receiverCity;
@ApiModelProperty(value = "区")
private String receiverRegion;
@ApiModelProperty(value = "订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单")
private Integer status;
}
OmsOrderReturnApplyResult 申请信息封装(oms_order_return_apply)
**
* 申请信息封装
* Created by macro on 2018/10/18.
*/
public class OmsOrderReturnApplyResult extends OmsOrderReturnApply {
@Getter
@Setter
@ApiModelProperty(value = "公司收货地址")
private OmsCompanyAddress companyAddress;
}
OmsReturnApplyQueryParam订单退货申请查询参数(oms_order_return_apply)
/**
* 订单退货申请查询参数
* Created by macro on 2018/10/18.
*/
@Getter
@Setter
public class OmsReturnApplyQueryParam {
@ApiModelProperty("服务单号")
private Long id;
@ApiModelProperty(value = "收货人姓名/号码")
private String receiverKeyword;
@ApiModelProperty(value = "申请状态:0->待处理;1->退货中;2->已完成;3->已拒绝")
private Integer status;
@ApiModelProperty(value = "申请时间")
private String createTime;
@ApiModelProperty(value = "处理人员")
private String handleMan;
@ApiModelProperty(value = "处理时间")
private String handleTime;
}
上面这些DTO,大家可以仔细的看看,后面具体的功能会大部分用到这些对象。
下面来具体聊聊订单相关的功能,先看看他们在前台的位置
以及代码里的位置:
订单列表功能
整体页面效果:(index.vue)
筛选搜索&数据列表
前台代码
index.vue
可以看到查询是调的fechList 方法,这个方法在哪里写的呢?
# 调用路径
import {fetchList,closeOrder,deleteOrder} from '@/api/order'
import request from '@/utils/request'
export function fetchList(params) {
return request({
url:'/order/list',
method:'get',
params:params
})
}
export function closeOrder(params) {
return request({
url:'/order/update/close',
method:'post',
params:params
})
}
export function deleteOrder(params) {
return request({
url:'/order/delete',
method:'post',
params:params
})
}
export function deliveryOrder(data) {
return request({
url:'/order/update/delivery',
method:'post',
data:data
});
}
export function getOrderDetail(id) {
return request({
url:'/order/'+id,
method:'get'
});
}
export function updateReceiverInfo(data) {
return request({
url:'/order/update/receiverInfo',
method:'post',
data:data
});
}
export function updateMoneyInfo(data) {
return request({
url:'/order/update/moneyInfo',
method:'post',
data:data
});
}
export function updateOrderNote(params) {
return request({
url:'/order/update/note',
method:'post',
params:params
})
}
可以看到以上的API请求,具体我们可以到swagger 上看详细的在线文档,可以通过swagger在线文档访问。
具体效果:
这里前后台实现数据交互的时候会有跨域的问题,可以查看
后台代码
OmsOrderController
@Controller
@Api(tags = "OmsOrderController", description = "订单管理")
@RequestMapping("/order")
public class OmsOrderController {
@ApiOperation("查询订单")
@RequestMapping(value = "/list", method = RequestMethod.GET)
@ResponseBody
public CommonResult<CommonPage<OmsOrder>> list(OmsOrderQueryParam queryParam,
@RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize,
@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum) {
List<OmsOrder> orderList = orderService.list(queryParam, pageSize, pageNum);
return CommonResult.success(CommonPage.restPage(orderList));
}
}
OmsOrderService
public interface OmsOrderService {
/**
* 订单查询
*/
List<OmsOrder> list(OmsOrderQueryParam queryParam, Integer pageSize, Integer pageNum);
}
OmsOrderServiceImpl
@Service
public class OmsOrderServiceImpl implements OmsOrderService
@Override
public List<OmsOrder> list(OmsOrderQueryParam queryParam, Integer pageSize, Integer pageNum) {
PageHelper.startPage(pageNum, pageSize);
return orderDao.getList(queryParam);
}
}
OmsOrderDao
public interface OmsOrderDao {
/**
* 条件查询订单
*/
List<OmsOrder> getList(@Param("queryParam") OmsOrderQueryParam queryParam);
}
OmsOrderDao.xml
<mapper namespace="com.macro.mall.dao.OmsOrderDao">
<resultMap id="orderDetailResultMap" type="com.macro.mall.dto.OmsOrderDetail" extends="com.macro.mall.mapper.OmsOrderMapper.BaseResultMap">
<collection property="orderItemList" resultMap="com.macro.mall.mapper.OmsOrderItemMapper.BaseResultMap" columnPrefix="item_"/>
<collection property="historyList" resultMap="com.macro.mall.mapper.OmsOrderOperateHistoryMapper.BaseResultMap" columnPrefix="history_"/>
</resultMap>
<select id="getList" resultMap="com.macro.mall.mapper.OmsOrderMapper.BaseResultMap">
SELECT *
FROM
oms_order
WHERE
delete_status = 0
<if test="queryParam.orderSn!=null and queryParam.orderSn!=''">
AND order_sn = #{queryParam.orderSn}
</if>
<if test="queryParam.status!=null">
AND `status` = #{queryParam.status}
</if>
<if test="queryParam.sourceType!=null">
AND source_type = #{queryParam.sourceType}
</if>
<if test="queryParam.orderType!=null">
AND order_type = #{queryParam.orderType}
</if>
<if test="queryParam.createTime!=null and queryParam.createTime!=''">
AND create_time LIKE concat(#{queryParam.createTime},"%")
</if>
<if test="queryParam.receiverKeyword!=null and queryParam.receiverKeyword!=''">
AND (
receiver_name LIKE concat("%",#{queryParam.receiverKeyword},"%")
OR receiver_phone LIKE concat("%",#{queryParam.receiverKeyword},"%")
)
</if>
</select>
<mapper>
至此,就完成了一次搜索查询,从前台到后台,思路是不是清晰了一些。
查看订单
效果图
前台代码
<el-table-column label="操作" width="200" align="center">
<template slot-scope="scope">
<el-button
size="mini"
@click="handleViewOrder(scope.$index, scope.row)"
>查看订单</el-button>
</template>
</el-table-column>
scope.$index→拿到每一行的index
scope.$row→拿到每一行的数据
handleViewOrder(index, row){
this.$router.push({path:'/oms/orderDetail',query:{id:row.id}})
},
export function getOrderDetail(id) {
return request({
url:'/order/'+id,
method:'get'
});
}
后台代码
OmsOrderController
@Controller
@Api(tags = "OmsOrderController", description = "订单管理")
@RequestMapping("/order")
public class OmsOrderController {
@ApiOperation("获取订单详情:订单信息、商品信息、操作记录")
@RequestMapping(value = "/{id}", method = RequestMethod.GET)
@ResponseBody
public CommonResult<OmsOrderDetail> detail(@PathVariable Long id) {
OmsOrderDetail orderDetailResult = orderService.detail(id);
return CommonResult.success(orderDetailResult);
}
}
OmsOrderService
public interface OmsOrderService {
/**
* 获取指定订单详情
*/
OmsOrderDetail detail(Long id);
}
OmsOrderServiceImpl
@Service
public class OmsOrderServiceImpl implements OmsOrderService{
@Override
public OmsOrderDetail detail(Long id) {
return orderDao.getDetail(id);
}
}
OmsOrderDao
public interface OmsOrderDao {
/**
* 获取订单详情
*/
OmsOrderDetail getDetail(@Param("id") Long id);
}
}
OmsOrderDao.xml
<mapper namespace="com.macro.mall.dao.OmsOrderDao">
<resultMap id="orderDetailResultMap" type="com.macro.mall.dto.OmsOrderDetail" extends="com.macro.mall.mapper.OmsOrderMapper.BaseResultMap">
<collection property="orderItemList" resultMap="com.macro.mall.mapper.OmsOrderItemMapper.BaseResultMap" columnPrefix="item_"/>
<collection property="historyList" resultMap="com.macro.mall.mapper.OmsOrderOperateHistoryMapper.BaseResultMap" columnPrefix="history_"/>
</resultMap>
<select id="getDetail" resultMap="orderDetailResultMap">
SELECT o.*,
oi.id item_id,
oi.product_id item_product_id,
oi.product_sn item_product_sn,
oi.product_pic item_product_pic,
oi.product_name item_product_name,
oi.product_brand item_product_brand,
oi.product_price item_product_price,
oi.product_quantity item_product_quantity,
oi.product_attr item_product_attr,
oh.id history_id,
oh.operate_man history_operate_man,
oh.create_time history_create_time,
oh.order_status history_order_status,
oh.note history_note
FROM
oms_order o
LEFT JOIN oms_order_item oi ON o.id = oi.order_id
LEFT JOIN oms_order_operate_history oh ON o.id = oh.order_id
WHERE
o.id = #{id}
ORDER BY oi.id ASC,oh.create_time DESC
</select>
<mapper>
至此,订单详情完成。
删除订单& 批量删除
效果图
前台代码
<el-table-column label="操作" width="200" align="center">
<template slot-scope="scope">
<el-button
size="mini"
type="danger"
@click="handleDeleteOrder(scope.$index, scope.row)"
v-show="scope.row.status===4">删除订单</el-button>
</template>
</el-table-column>
handleDeleteOrder(index, row){
let ids=[];
ids.push(row.id);
this.deleteOrder(ids);
},
deleteOrder(ids){
this.$confirm('是否要进行该删除操作?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
let params = new URLSearchParams();
params.append("ids",ids);
deleteOrder(params).then(response=>{
this.$message({
message: '删除成功!',
type: 'success',
duration: 1000
});
this.getList();
});
})
},
export function deleteOrder(params) {
return request({
url:'/order/delete',
method:'post',
params:params
})
}
后台代码
OmsOrderController
@Controller
@Api(tags = "OmsOrderController", description = "订单管理")
@RequestMapping("/order")
public class OmsOrderController {
@ApiOperation("批量删除订单")
@RequestMapping(value = "/delete", method = RequestMethod.POST)
@ResponseBody
public CommonResult delete(@RequestParam("ids") List<Long> ids) {
int count = orderService.delete(ids);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderService
public interface OmsOrderService {
/**
* 批量删除订单
*/
int delete(List<Long> ids);
}
OmsOrderServiceImpl
@Service
public class OmsOrderServiceImpl implements OmsOrderService{
@Override
public int delete(List<Long> ids) {
OmsOrder record = new OmsOrder();
record.setDeleteStatus(1);
OmsOrderExample example = new OmsOrderExample();
example.createCriteria().andDeleteStatusEqualTo(0).andIdIn(ids);
return orderMapper.updateByExampleSelective(record, example);
}
}
OmsOrderExample和orderMapper
这两个文件是myBatis generate ,逆向工程。
至此,删除订单完成。
订单发货&保存历史操作
效果图
前台代码
<el-table-column label="操作" width="200" align="center">
<template slot-scope="scope">
<el-button
size="mini"
@click="handleDeliveryOrder(scope.$index, scope.row)"
v-show="scope.row.status===1">订单发货</el-button>
</template>
</el-table-column>
handleDeliveryOrder(index, row){
let listItem = this.covertOrder(row);
this.$router.push({path:'/oms/deliverOrderList',query:{list:[listItem]}})
},
export function deliveryOrder(data) {
return request({
url:'/order/update/delivery',
method:'post',
data:data
});
}
methods:{
cancel(){
this.$router.back();
},
confirm(){
this.$confirm('是否要进行发货操作?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
deliveryOrder(this.list).then(response=>{
this.$router.back();
this.$message({
type: 'success',
message: '发货成功!'
});
});
}).catch(() => {
this.$message({
type: 'info',
message: '已取消发货'
});
});
}
}
后台代码
OmsOrderController
@Controller
@Api(tags = "OmsOrderController", description = "订单管理")
@RequestMapping("/order")
public class OmsOrderController {
@ApiOperation("批量发货")
@RequestMapping(value = "/update/delivery", method = RequestMethod.POST)
@ResponseBody
public CommonResult delivery(@RequestBody List<OmsOrderDeliveryParam> deliveryParamList) {
int count = orderService.delivery(deliveryParamList);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderService
public interface OmsOrderService {
/**
* 批量发货
*/
@Transactional
int delivery(List<OmsOrderDeliveryParam> deliveryParamList);
}
OmsOrderServiceImpl
@Service
public class OmsOrderServiceImpl implements OmsOrderService{
@Override
public int delivery(List<OmsOrderDeliveryParam> deliveryParamList) {
//批量发货
int count = orderDao.delivery(deliveryParamList);
//添加操作记录
List<OmsOrderOperateHistory> operateHistoryList = deliveryParamList.stream()
.map(omsOrderDeliveryParam -> {
OmsOrderOperateHistory history = new OmsOrderOperateHistory();
history.setOrderId(omsOrderDeliveryParam.getOrderId());
history.setCreateTime(new Date());
history.setOperateMan("后台管理员");
history.setOrderStatus(2);
history.setNote("完成发货");
return history;
}).collect(Collectors.toList());
orderOperateHistoryDao.insertList(operateHistoryList);
return count;
}
}
这里是使用的stream() 的map方法 ,为集合创建串行流,并为集合中每个对象修改发货完成的状态信息。
具体用法参考:
map 方法用于映射每个元素到对应的结果,以下代码片段使用 map 输出了元素对应的平方数:
List<Integer> numbers = Arrays.asList(3, 2, 2, 3, 7, 3, 5);
// 获取对应的平方数
List<Integer> squaresList = numbers.stream().map( i -> i*i).distinct().collect(Collectors.toList());
OmsOrderDao
public interface OmsOrderDao {
/**
* 批量发货
*/
int delivery(@Param("list") List<OmsOrderDeliveryParam> deliveryParamList);
}
OmsOrderOperateHistoryDao
public interface OmsOrderOperateHistoryDao {
/**
* 批量创建
*/
int insertList(@Param("list") List<OmsOrderOperateHistory> orderOperateHistoryList);
}
OmsOrderDao.xml
<mapper namespace="com.macro.mall.dao.OmsOrderDao">
<resultMap id="orderDetailResultMap" type="com.macro.mall.dto.OmsOrderDetail" extends="com.macro.mall.mapper.OmsOrderMapper.BaseResultMap">
<collection property="orderItemList" resultMap="com.macro.mall.mapper.OmsOrderItemMapper.BaseResultMap" columnPrefix="item_"/>
<collection property="historyList" resultMap="com.macro.mall.mapper.OmsOrderOperateHistoryMapper.BaseResultMap" columnPrefix="history_"/>
</resultMap>
<update id="delivery">
UPDATE oms_order
SET
delivery_sn = CASE id
<foreach collection="list" item="item">
WHEN #{item.orderId} THEN #{item.deliverySn}
</foreach>
END,
delivery_company = CASE id
<foreach collection="list" item="item">
WHEN #{item.orderId} THEN #{item.deliveryCompany}
</foreach>
END,
delivery_time = CASE id
<foreach collection="list" item="item">
WHEN #{item.orderId} THEN now()
</foreach>
END,
`status` = CASE id
<foreach collection="list" item="item">
WHEN #{item.orderId} THEN 2
</foreach>
END
WHERE
id IN
<foreach collection="list" item="item" separator="," open="(" close=")">
#{item.orderId}
</foreach>
AND `status` = 1
</update>
<mapper>
OmsOrderOperateHistoryDao.xml
<mapper namespace="com.macro.mall.dao.OmsOrderOperateHistoryDao">
<insert id="insertList">
INSERT INTO oms_order_operate_history (order_id, operate_man, create_time, order_status, note) VALUES
<foreach collection="list" separator="," item="item" index="index">
(#{item.orderId},
#{item.operateMan},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.orderStatus},
#{item.note})
</foreach>
</insert>
</mapper>
至此,订单发货以及历史记录操作保存功能完成。
订单跟踪
效果图
前台代码
<el-table-column label="操作" width="200" align="center">
<template slot-scope="scope">
<el-button
size="mini"
@click="handleViewLogistics(scope.$index, scope.row)"
v-show="scope.row.status===2||scope.row.status===3">订单跟踪</el-button>
</template>
</el-table-column>
handleViewLogistics(index, row){
this.logisticsDialogVisible=true;
},
一开始是隐藏的效果,只有点击订单跟踪这个按钮后,就会显示订单这个详情框。
<el-dialog title="订单跟踪"
:visible.sync="visible"
:before-close="handleClose"
width="40%">
<el-steps direction="vertical"
:active="6"
finish-status="success"
space="50px">
<el-step v-for="item in logisticsList"
:key="item.name"
:title="item.name"
:description="item.time"></el-step>
</el-steps>
</el-dialog>
</template>
<script>
const defaultLogisticsList=[
{name: '订单已提交,等待付款',time:'2017-04-01 12:00:00 '},
{name: '订单付款成功',time:'2017-04-01 12:00:00 '},
{name: '在北京市进行下级地点扫描,等待付款',time:'2017-04-01 12:00:00 '},
{name: '在分拨中心广东深圳公司进行卸车扫描,等待付款',time:'2017-04-01 12:00:00 '},
{name: '在广东深圳公司进行发出扫描',time:'2017-04-01 12:00:00 '},
{name: '到达目的地网点广东深圳公司,快件将很快进行派送',time:'2017-04-01 12:00:00 '},
{name: '订单已签收,期待再次为您服务',time:'2017-04-01 12:00:00 '}
];
export default {
name:'logisticsDialog',
props: {
value: Boolean
},
computed:{
visible: {
get() {
return this.value;
},
set(visible){
this.value=visible;
}
}
},
data() {
return {
logisticsList:Object.assign({},defaultLogisticsList)
}
},
methods:{
emitInput(val) {
this.$emit('input', val)
},
handleClose(){
this.emitInput(false);
}
}
}
</script>
后台代码
开源项目中写的是静态代码,没有保存到数据库。
关闭订单
效果图
前台代码
<el-table-column label="操作" width="200" align="center">
<template slot-scope="scope">
<el-button
size="mini"
@click="handleCloseOrder(scope.$index, scope.row)"
v-show="scope.row.status===0">关闭订单</el-button>
</template>
</el-table-column>
<el-dialog
title="关闭订单"
:visible.sync="closeOrder.dialogVisible" width="30%">
<span style="vertical-align: top">操作备注:</span>
<el-input
style="width: 80%"
type="textarea"
:rows="5"
placeholder="请输入内容"
v-model="closeOrder.content">
</el-input>
<span slot="footer" class="dialog-footer">
<el-button @click="closeOrder.dialogVisible = false">取 消</el-button>
<el-button type="primary" @click="handleCloseOrderConfirm">确 定</el-button>
</span>
</el-dialog>
handleCloseOrderConfirm() {
if (this.closeOrder.content == null || this.closeOrder.content === '') {
this.$message({
message: '操作备注不能为空',
type: 'warning',
duration: 1000
});
return;
}
let params = new URLSearchParams();
params.append('ids', this.closeOrder.orderIds);
params.append('note', this.closeOrder.content);
closeOrder(params).then(response=>{
this.closeOrder.orderIds=[];
this.closeOrder.dialogVisible=false;
this.getList();
this.$message({
message: '修改成功',
type: 'success',
duration: 1000
});
});
},
export function closeOrder(params) {
return request({
url:'/order/update/close',
method:'post',
params:params
})
}
后台代码
OmsOrderController
@Controller
@Api(tags = "OmsOrderController", description = "订单管理")
@RequestMapping("/order")
public class OmsOrderController {
@ApiOperation("批量关闭订单")
@RequestMapping(value = "/update/close", method = RequestMethod.POST)
@ResponseBody
public CommonResult close(@RequestParam("ids") List<Long> ids, @RequestParam String note) {
int count = orderService.close(ids, note);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderService
public interface OmsOrderService {
/**
* 批量关闭订单
*/
@Transactional
int close(List<Long> ids, String note);
}
OmsOrderServiceImpl
@Service
public class OmsOrderServiceImpl implements OmsOrderService{
@Override
public int close(List<Long> ids, String note) {
OmsOrder record = new OmsOrder();
record.setStatus(4);
OmsOrderExample example = new OmsOrderExample();
example.createCriteria().andDeleteStatusEqualTo(0).andIdIn(ids);
int count = orderMapper.updateByExampleSelective(record, example);
List<OmsOrderOperateHistory> historyList = ids.stream().map(orderId -> {
OmsOrderOperateHistory history = new OmsOrderOperateHistory();
history.setOrderId(orderId);
history.setCreateTime(new Date());
history.setOperateMan("后台管理员");
history.setOrderStatus(4);
history.setNote("订单关闭:"+note);
return history;
}).collect(Collectors.toList());
orderOperateHistoryDao.insertList(historyList);
return count;
}
}
orderMapper
mybatis 逆向自动生成的
OmsOrderOperateHistoryDao.xml
<mapper namespace="com.macro.mall.dao.OmsOrderOperateHistoryDao">
<insert id="insertList">
INSERT INTO oms_order_operate_history (order_id, operate_man, create_time, order_status, note) VALUES
<foreach collection="list" separator="," item="item" index="index">
(#{item.orderId},
#{item.operateMan},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.orderStatus},
#{item.note})
</foreach>
</insert>
</mapper>
分页
效果图
前台代码
<div class="pagination-container">
<el-pagination
background
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
layout="total, sizes,prev, pager, next,jumper"
:current-page.sync="listQuery.pageNum"
:page-size="listQuery.pageSize"
:page-sizes="[5,10,15]"
:total="total">
</el-pagination>
</div>
handleSizeChange(val){
this.listQuery.pageNum = 1;
this.listQuery.pageSize = val;
this.getList();
},
handleCurrentChange(val){
this.listQuery.pageNum = val;
this.getList();
},
后台代码
用的是mybatis 中pagehelper 插件.
@Override
public List<OmsOrder> list(OmsOrderQueryParam queryParam, Integer pageSize, Integer pageNum) {
PageHelper.startPage(pageNum, pageSize);
return orderDao.getList(queryParam);
}
下面是配置文件:
#pagehelper分页插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
订单设置功能
效果图
前台代码
<template>
<el-card class="form-container" shadow="never">
<el-form :model="orderSetting"
ref="orderSettingForm"
:rules="rules"
label-width="150px">
<el-form-item label="秒杀订单超过:" prop="flashOrderOvertime">
<el-input v-model="orderSetting.flashOrderOvertime" class="input-width">
<template slot="append">分</template>
</el-input>
<span class="note-margin">未付款,订单自动关闭</span>
</el-form-item>
<el-form-item label="正常订单超过:" prop="normalOrderOvertime">
<el-input v-model="orderSetting.normalOrderOvertime" class="input-width">
<template slot="append">分</template>
</el-input>
<span class="note-margin">未付款,订单自动关闭</span>
</el-form-item>
<el-form-item label="发货超过:" prop="confirmOvertime">
<el-input v-model="orderSetting.confirmOvertime" class="input-width">
<template slot="append">天</template>
</el-input>
<span class="note-margin">未收货,订单自动完成</span>
</el-form-item>
<el-form-item label="订单完成超过:" prop="finishOvertime">
<el-input v-model="orderSetting.finishOvertime" class="input-width">
<template slot="append">天</template>
</el-input>
<span class="note-margin">自动结束交易,不能申请售后</span>
</el-form-item>
<el-form-item label="订单完成超过:" prop="commentOvertime">
<el-input v-model="orderSetting.commentOvertime" class="input-width">
<template slot="append">天</template>
</el-input>
<span class="note-margin">自动五星好评</span>
</el-form-item>
<el-form-item>
<el-button
@click="confirm('orderSettingForm')"
type="primary">提交</el-button>
</el-form-item>
</el-form>
</el-card>
</template>
<script>
import {getOrderSetting,updateOrderSetting} from '@/api/orderSetting';
const defaultOrderSetting = {
id: null,
flashOrderOvertime: 0,
normalOrderOvertime: 0,
confirmOvertime: 0,
finishOvertime: 0,
commentOvertime: 0
};
const checkTime = (rule, value, callback) => {
if (!value) {
return callback(new Error('时间不能为空'));
}
console.log("checkTime",value);
let intValue = parseInt(value);
if (!Number.isInteger(intValue)) {
return callback(new Error('请输入数字值'));
}
callback();
};
export default {
name: 'orderSetting',
data() {
return {
orderSetting: Object.assign({}, defaultOrderSetting),
rules: {
flashOrderOvertime:{validator: checkTime, trigger: 'blur' },
normalOrderOvertime:{validator: checkTime, trigger: 'blur' },
confirmOvertime: {validator: checkTime, trigger: 'blur' },
finishOvertime: {validator: checkTime, trigger: 'blur' },
commentOvertime:{validator: checkTime, trigger: 'blur' }
}
}
},
created(){
this.getDetail();
},
methods:{
confirm(formName){
this.$refs[formName].validate((valid) => {
if (valid) {
this.$confirm('是否要提交修改?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
updateOrderSetting(1,this.orderSetting).then(response=>{
this.$message({
type: 'success',
message: '提交成功!',
duration:1000
});
})
});
} else {
this.$message({
message: '提交参数不合法',
type: 'warning'
});
return false;
}
});
},
getDetail(){
getOrderSetting(1).then(response=>{
this.orderSetting=response.data;
})
}
}
}
</script>
<style scoped>
.input-width {
width: 50%;
}
.note-margin {
margin-left: 15px;
}
</style>
有数据校验功能,主要是对空值以及非数值的检验。
export function getOrderSetting(id) {
return request({
url:'/orderSetting/'+id,
method:'get',
})
}
export function updateOrderSetting(id,data) {
return request({
url:'/orderSetting/update/'+id,
method:'post',
data:data
})
}
后台代码
OmsOrderSettingController
@Controller
@Api(tags = "OmsOrderSettingController", description = "订单设置管理")
@RequestMapping("/orderSetting")
public class OmsOrderSettingController {
@Autowired
private OmsOrderSettingService orderSettingService;
@ApiOperation("获取指定订单设置")
@RequestMapping(value = "/{id}", method = RequestMethod.GET)
@ResponseBody
public CommonResult<OmsOrderSetting> getItem(@PathVariable Long id) {
OmsOrderSetting orderSetting = orderSettingService.getItem(id);
return CommonResult.success(orderSetting);
}
@ApiOperation("修改指定订单设置")
@RequestMapping(value = "/update/{id}", method = RequestMethod.POST)
@ResponseBody
public CommonResult update(@PathVariable Long id, @RequestBody OmsOrderSetting orderSetting) {
int count = orderSettingService.update(id,orderSetting);
if(count>0){
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderSettingService
public interface OmsOrderSettingService {
/**
* 获取指定订单设置
*/
OmsOrderSetting getItem(Long id);
/**
* 修改指定订单设置
*/
int update(Long id, OmsOrderSetting orderSetting);
}
OmsOrderSettingServiceImpl
@Service
public class OmsOrderSettingServiceImpl implements OmsOrderSettingService {
@Autowired
private OmsOrderSettingMapper orderSettingMapper;
@Override
public OmsOrderSetting getItem(Long id) {
return orderSettingMapper.selectByPrimaryKey(id);
}
@Override
public int update(Long id, OmsOrderSetting orderSetting) {
orderSetting.setId(id);
return orderSettingMapper.updateByPrimaryKey(orderSetting);
}
}
OmsOrderSettingMapper
public interface OmsOrderSettingMapper {
long countByExample(OmsOrderSettingExample example);
int deleteByExample(OmsOrderSettingExample example);
int deleteByPrimaryKey(Long id);
int insert(OmsOrderSetting record);
int insertSelective(OmsOrderSetting record);
List<OmsOrderSetting> selectByExample(OmsOrderSettingExample example);
OmsOrderSetting selectByPrimaryKey(Long id);
int updateByExampleSelective(@Param("record") OmsOrderSetting record, @Param("example") OmsOrderSettingExample example);
int updateByExample(@Param("record") OmsOrderSetting record, @Param("example") OmsOrderSettingExample example);
int updateByPrimaryKeySelective(OmsOrderSetting record);
int updateByPrimaryKey(OmsOrderSetting record);
}
退货申请处理功能
效果图
前台代码
export function fetchList(params) {
return request({
url:'/returnApply/list',
method:'get',
params:params
})
}
export function deleteApply(params) {
return request({
url:'/returnApply/delete',
method:'post',
params:params
})
}
export function updateApplyStatus(id,data) {
return request({
url:'/returnApply/update/status/'+id,
method:'post',
data:data
})
}
export function getApplyDetail(id) {
return request({
url:'/returnApply/'+id,
method:'get'
})
}
后台代码
OmsOrderReturnApplyController
@Controller
@Api(tags = "OmsOrderReturnApplyController", description = "订单退货申请管理")
@RequestMapping("/returnApply")
public class OmsOrderReturnApplyController {
@Autowired
private OmsOrderReturnApplyService returnApplyService;
@ApiOperation("分页查询退货申请")
@RequestMapping(value = "/list", method = RequestMethod.GET)
@ResponseBody
public CommonResult<CommonPage<OmsOrderReturnApply>> list(OmsReturnApplyQueryParam queryParam,
@RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize,
@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum) {
List<OmsOrderReturnApply> returnApplyList = returnApplyService.list(queryParam, pageSize, pageNum);
return CommonResult.success(CommonPage.restPage(returnApplyList));
}
@ApiOperation("批量删除申请")
@RequestMapping(value = "/delete", method = RequestMethod.POST)
@ResponseBody
public CommonResult delete(@RequestParam("ids") List<Long> ids) {
int count = returnApplyService.delete(ids);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
@ApiOperation("获取退货申请详情")
@RequestMapping(value = "/{id}", method = RequestMethod.GET)
@ResponseBody
public CommonResult getItem(@PathVariable Long id) {
OmsOrderReturnApplyResult result = returnApplyService.getItem(id);
return CommonResult.success(result);
}
@ApiOperation("修改申请状态")
@RequestMapping(value = "/update/status/{id}", method = RequestMethod.POST)
@ResponseBody
public CommonResult updateStatus(@PathVariable Long id, @RequestBody OmsUpdateStatusParam statusParam) {
int count = returnApplyService.updateStatus(id, statusParam);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderReturnApplyService
public interface OmsOrderReturnApplyService {
/**
* 分页查询申请
*/
List<OmsOrderReturnApply> list(OmsReturnApplyQueryParam queryParam, Integer pageSize, Integer pageNum);
/**
* 批量删除申请
*/
int delete(List<Long> ids);
/**
* 修改申请状态
*/
int updateStatus(Long id, OmsUpdateStatusParam statusParam);
/**
* 获取指定申请详情
*/
OmsOrderReturnApplyResult getItem(Long id);
}
OmsOrderReturnApplyServiceImpl
@Service
public class OmsOrderReturnApplyServiceImpl implements OmsOrderReturnApplyService {
@Autowired
private OmsOrderReturnApplyDao returnApplyDao;
@Autowired
private OmsOrderReturnApplyMapper returnApplyMapper;
@Override
public List<OmsOrderReturnApply> list(OmsReturnApplyQueryParam queryParam, Integer pageSize, Integer pageNum) {
PageHelper.startPage(pageNum,pageSize);
return returnApplyDao.getList(queryParam);
}
@Override
public int delete(List<Long> ids) {
OmsOrderReturnApplyExample example = new OmsOrderReturnApplyExample();
example.createCriteria().andIdIn(ids).andStatusEqualTo(3);
return returnApplyMapper.deleteByExample(example);
}
@Override
public int updateStatus(Long id, OmsUpdateStatusParam statusParam) {
Integer status = statusParam.getStatus();
OmsOrderReturnApply returnApply = new OmsOrderReturnApply();
if(status.equals(1)){
//确认退货
returnApply.setId(id);
returnApply.setStatus(1);
returnApply.setReturnAmount(statusParam.getReturnAmount());
returnApply.setCompanyAddressId(statusParam.getCompanyAddressId());
returnApply.setHandleTime(new Date());
returnApply.setHandleMan(statusParam.getHandleMan());
returnApply.setHandleNote(statusParam.getHandleNote());
}else if(status.equals(2)){
//完成退货
returnApply.setId(id);
returnApply.setStatus(2);
returnApply.setReceiveTime(new Date());
returnApply.setReceiveMan(statusParam.getReceiveMan());
returnApply.setReceiveNote(statusParam.getReceiveNote());
}else if(status.equals(3)){
//拒绝退货
returnApply.setId(id);
returnApply.setStatus(3);
returnApply.setHandleTime(new Date());
returnApply.setHandleMan(statusParam.getHandleMan());
returnApply.setHandleNote(statusParam.getHandleNote());
}else{
return 0;
}
return returnApplyMapper.updateByPrimaryKeySelective(returnApply);
}
@Override
public OmsOrderReturnApplyResult getItem(Long id) {
return returnApplyDao.getDetail(id);
}
}
退货原因设置功能
效果图
前台代码
export function fetchList(params) {
return request({
url:'/returnReason/list',
method:'get',
params:params
})
}
export function deleteReason(params) {
return request({
url:'/returnReason/delete',
method:'post',
params:params
})
}
export function updateStatus(params) {
return request({
url:'/returnReason/update/status',
method:'post',
params:params
})
}
export function addReason(data) {
return request({
url:'/returnReason/create',
method:'post',
data:data
})
}
export function getReasonDetail(id) {
return request({
url:'/returnReason/'+id,
method:'get'
})
}
export function updateReason(id,data) {
return request({
url:'/returnReason/update/'+id,
method:'post',
data:data
})
}
后台代码
OmsOrderReturnReasonController
@Controller
@Api(tags = "OmsOrderReturnReasonController", description = "退货原因管理")
@RequestMapping("/returnReason")
public class OmsOrderReturnReasonController {
@Autowired
private OmsOrderReturnReasonService orderReturnReasonService;
@ApiOperation("添加退货原因")
@RequestMapping(value = "/create", method = RequestMethod.POST)
@ResponseBody
public CommonResult create(@RequestBody OmsOrderReturnReason returnReason) {
int count = orderReturnReasonService.create(returnReason);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
@ApiOperation("修改退货原因")
@RequestMapping(value = "/update/{id}", method = RequestMethod.POST)
@ResponseBody
public CommonResult update(@PathVariable Long id, @RequestBody OmsOrderReturnReason returnReason) {
int count = orderReturnReasonService.update(id, returnReason);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
@ApiOperation("批量删除退货原因")
@RequestMapping(value = "/delete", method = RequestMethod.POST)
@ResponseBody
public CommonResult delete(@RequestParam("ids") List<Long> ids) {
int count = orderReturnReasonService.delete(ids);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
@ApiOperation("分页查询全部退货原因")
@RequestMapping(value = "/list", method = RequestMethod.GET)
@ResponseBody
public CommonResult<CommonPage<OmsOrderReturnReason>> list(@RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize,
@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum) {
List<OmsOrderReturnReason> reasonList = orderReturnReasonService.list(pageSize, pageNum);
return CommonResult.success(CommonPage.restPage(reasonList));
}
@ApiOperation("获取单个退货原因详情信息")
@RequestMapping(value = "/{id}", method = RequestMethod.GET)
@ResponseBody
public CommonResult<OmsOrderReturnReason> getItem(@PathVariable Long id) {
OmsOrderReturnReason reason = orderReturnReasonService.getItem(id);
return CommonResult.success(reason);
}
@ApiOperation("修改退货原因启用状态")
@RequestMapping(value = "/update/status", method = RequestMethod.POST)
@ResponseBody
public CommonResult updateStatus(@RequestParam(value = "status") Integer status,
@RequestParam("ids") List<Long> ids) {
int count = orderReturnReasonService.updateStatus(ids, status);
if (count > 0) {
return CommonResult.success(count);
}
return CommonResult.failed();
}
}
OmsOrderReturnReasonService
public interface OmsOrderReturnReasonService {
/**
* 添加订单原因
*/
int create(OmsOrderReturnReason returnReason);
/**
* 修改退货原因
*/
int update(Long id, OmsOrderReturnReason returnReason);
/**
* 批量删除退货原因
*/
int delete(List<Long> ids);
/**
* 分页获取退货原因
*/
List<OmsOrderReturnReason> list(Integer pageSize, Integer pageNum);
/**
* 批量修改退货原因状态
*/
int updateStatus(List<Long> ids, Integer status);
/**
* 获取单个退货原因详情信息
*/
OmsOrderReturnReason getItem(Long id);
}
OmsOrderReturnReasonServiceImpl
@Service
public class OmsOrderReturnReasonServiceImpl implements OmsOrderReturnReasonService {
@Autowired
private OmsOrderReturnReasonMapper returnReasonMapper;
@Override
public int create(OmsOrderReturnReason returnReason) {
returnReason.setCreateTime(new Date());
return returnReasonMapper.insert(returnReason);
}
@Override
public int update(Long id, OmsOrderReturnReason returnReason) {
returnReason.setId(id);
return returnReasonMapper.updateByPrimaryKey(returnReason);
}
@Override
public int delete(List<Long> ids) {
OmsOrderReturnReasonExample example = new OmsOrderReturnReasonExample();
example.createCriteria().andIdIn(ids);
return returnReasonMapper.deleteByExample(example);
}
@Override
public List<OmsOrderReturnReason> list(Integer pageSize, Integer pageNum) {
PageHelper.startPage(pageNum,pageSize);
OmsOrderReturnReasonExample example = new OmsOrderReturnReasonExample();
example.setOrderByClause("sort desc");
return returnReasonMapper.selectByExample(example);
}
@Override
public int updateStatus(List<Long> ids, Integer status) {
if(!status.equals(0)&&!status.equals(1)){
return 0;
}
OmsOrderReturnReason record = new OmsOrderReturnReason();
record.setStatus(status);
OmsOrderReturnReasonExample example = new OmsOrderReturnReasonExample();
example.createCriteria().andIdIn(ids);
return returnReasonMapper.updateByExampleSelective(record,example);
}
@Override
public OmsOrderReturnReason getItem(Long id) {
return returnReasonMapper.selectByPrimaryKey(id);
}
}
相关表
oms_order订单表
CREATE TABLE `oms_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单id',
`member_id` bigint(20) NOT NULL COMMENT '会员id',
`coupon_id` bigint(20) DEFAULT NULL COMMENT '优惠券id',
`order_sn` varchar(64) DEFAULT NULL COMMENT '订单编号',
`create_time` datetime DEFAULT NULL COMMENT '提交时间',
`member_username` varchar(64) DEFAULT NULL COMMENT '用户帐号',
`total_amount` decimal(10,2) DEFAULT NULL COMMENT '订单总金额',
`pay_amount` decimal(10,2) DEFAULT NULL COMMENT '应付金额(实际支付金额)',
`freight_amount` decimal(10,2) DEFAULT NULL COMMENT '运费金额',
`promotion_amount` decimal(10,2) DEFAULT NULL COMMENT '促销优化金额(促销价、满减、阶梯价)',
`integration_amount` decimal(10,2) DEFAULT NULL COMMENT '积分抵扣金额',
`coupon_amount` decimal(10,2) DEFAULT NULL COMMENT '优惠券抵扣金额',
`discount_amount` decimal(10,2) DEFAULT NULL COMMENT '管理员后台调整订单使用的折扣金额',
`pay_type` int(1) DEFAULT NULL COMMENT '支付方式:0->未支付;1->支付宝;2->微信',
`source_type` int(1) DEFAULT NULL COMMENT '订单来源:0->PC订单;1->app订单',
`status` int(1) DEFAULT NULL COMMENT '订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单',
`order_type` int(1) DEFAULT NULL COMMENT '订单类型:0->正常订单;1->秒杀订单',
`delivery_company` varchar(64) DEFAULT NULL COMMENT '物流公司(配送方式)',
`delivery_sn` varchar(64) DEFAULT NULL COMMENT '物流单号',
`auto_confirm_day` int(11) DEFAULT NULL COMMENT '自动确认时间(天)',
`integration` int(11) DEFAULT NULL COMMENT '可以获得的积分',
`growth` int(11) DEFAULT NULL COMMENT '可以活动的成长值',
`promotion_info` varchar(100) DEFAULT NULL COMMENT '活动信息',
`bill_type` int(1) DEFAULT NULL COMMENT '发票类型:0->不开发票;1->电子发票;2->纸质发票',
`bill_header` varchar(200) DEFAULT NULL COMMENT '发票抬头',
`bill_content` varchar(200) DEFAULT NULL COMMENT '发票内容',
`bill_receiver_phone` varchar(32) DEFAULT NULL COMMENT '收票人电话',
`bill_receiver_email` varchar(64) DEFAULT NULL COMMENT '收票人邮箱',
`receiver_name` varchar(100) NOT NULL COMMENT '收货人姓名',
`receiver_phone` varchar(32) NOT NULL COMMENT '收货人电话',
`receiver_post_code` varchar(32) DEFAULT NULL COMMENT '收货人邮编',
`receiver_province` varchar(32) DEFAULT NULL COMMENT '省份/直辖市',
`receiver_city` varchar(32) DEFAULT NULL COMMENT '城市',
`receiver_region` varchar(32) DEFAULT NULL COMMENT '区',
`receiver_detail_address` varchar(200) DEFAULT NULL COMMENT '详细地址',
`note` varchar(500) DEFAULT NULL COMMENT '订单备注',
`confirm_status` int(1) DEFAULT NULL COMMENT '确认收货状态:0->未确认;1->已确认',
`delete_status` int(1) NOT NULL DEFAULT '0' COMMENT '删除状态:0->未删除;1->已删除',
`use_integration` int(11) DEFAULT NULL COMMENT '下单时使用的积分',
`payment_time` datetime DEFAULT NULL COMMENT '支付时间',
`delivery_time` datetime DEFAULT NULL COMMENT '发货时间',
`receive_time` datetime DEFAULT NULL COMMENT '确认收货时间',
`comment_time` datetime DEFAULT NULL COMMENT '评价时间',
`modify_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单表,需要注意的是订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单。';
oms_order_return_apply 订单退货申请表
CREATE TABLE `oms_order_return_apply` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`company_address_id` bigint(20) DEFAULT NULL COMMENT '收货地址表id',
`product_id` bigint(20) DEFAULT NULL COMMENT '退货商品id',
`order_sn` varchar(64) DEFAULT NULL COMMENT '订单编号',
`create_time` datetime DEFAULT NULL COMMENT '申请时间',
`member_username` varchar(64) DEFAULT NULL COMMENT '会员用户名',
`return_amount` decimal(10,2) DEFAULT NULL COMMENT '退款金额',
`return_name` varchar(100) DEFAULT NULL COMMENT '退货人姓名',
`return_phone` varchar(100) DEFAULT NULL COMMENT '退货人电话',
`status` int(1) DEFAULT NULL COMMENT '申请状态:0->待处理;1->退货中;2->已完成;3->已拒绝',
`handle_time` datetime DEFAULT NULL COMMENT '处理时间',
`product_pic` varchar(500) DEFAULT NULL COMMENT '商品图片',
`product_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
`product_brand` varchar(200) DEFAULT NULL COMMENT '商品品牌',
`product_attr` varchar(500) DEFAULT NULL COMMENT '商品销售属性:颜色:红色;尺码:xl;',
`product_count` int(11) DEFAULT NULL COMMENT '退货数量',
`product_price` decimal(10,2) DEFAULT NULL COMMENT '商品单价',
`product_real_price` decimal(10,2) DEFAULT NULL COMMENT '商品实际支付单价',
`reason` varchar(200) DEFAULT NULL COMMENT '原因',
`description` varchar(500) DEFAULT NULL COMMENT '描述',
`proof_pics` varchar(1000) DEFAULT NULL COMMENT '凭证图片,以逗号隔开',
`handle_note` varchar(500) DEFAULT NULL COMMENT '处理备注',
`handle_man` varchar(100) DEFAULT NULL COMMENT '处理人员',
`receive_man` varchar(100) DEFAULT NULL COMMENT '收货人',
`receive_time` datetime DEFAULT NULL COMMENT '收货时间',
`receive_note` varchar(500) DEFAULT NULL COMMENT '收货备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单退货申请表,主要用于存储会员退货申请信息,需要注意的是订单退货申请表的四种状态:0->待处理;1->退货中;2->已完成;3->已拒绝。';
oms_order_item订单商品列表表
CREATE TABLE `oms_order_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`order_sn` varchar(64) DEFAULT NULL COMMENT '订单编号',
`product_id` bigint(20) DEFAULT NULL COMMENT '商品id',
`product_pic` varchar(500) DEFAULT NULL COMMENT '商品图片',
`product_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
`product_brand` varchar(200) DEFAULT NULL COMMENT '商品品牌',
`product_sn` varchar(64) DEFAULT NULL COMMENT '商品条码',
`product_price` decimal(10,2) DEFAULT NULL COMMENT '销售价格',
`product_quantity` int(11) DEFAULT NULL COMMENT '购买数量',
`product_sku_id` bigint(20) DEFAULT NULL COMMENT '商品sku编号',
`product_sku_code` varchar(50) DEFAULT NULL COMMENT '商品sku条码',
`product_category_id` bigint(20) DEFAULT NULL COMMENT '商品分类id',
`sp1` varchar(100) DEFAULT NULL COMMENT '商品的销售属性1',
`sp2` varchar(100) DEFAULT NULL COMMENT '商品的销售属性2',
`sp3` varchar(100) DEFAULT NULL COMMENT '商品的销售属性3',
`promotion_name` varchar(200) DEFAULT NULL COMMENT '商品促销名称',
`promotion_amount` decimal(10,2) DEFAULT NULL COMMENT '商品促销分解金额',
`coupon_amount` decimal(10,2) DEFAULT NULL COMMENT '优惠券优惠分解金额',
`integration_amount` decimal(10,2) DEFAULT NULL COMMENT '积分优惠分解金额',
`real_amount` decimal(10,2) DEFAULT NULL COMMENT '该商品经过优惠后的分解金额',
`gift_integration` int(11) NOT NULL DEFAULT '0' COMMENT '商品赠送积分',
`gift_growth` int(11) NOT NULL DEFAULT '0' COMMENT '商品赠送成长值',
`product_attr` varchar(500) DEFAULT NULL COMMENT '商品销售属性:[{"key":"颜色","value":"颜色"},{"key":"容量","value":"4G"}]',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单中包含的商品信息,一个订单中会有多个订单商品信息。';
oms_order_operate_history订单操作记录表
CREATE TABLE `oms_order_operate_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`operate_man` varchar(100) DEFAULT NULL COMMENT '操作人:用户;系统;后台管理员',
`create_time` datetime DEFAULT NULL COMMENT '操作时间',
`order_status` int(1) DEFAULT NULL COMMENT '订单状态:0->待付款;1->待发货;2->已发货;3->已完成;4->已关闭;5->无效订单',
`note` varchar(500) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单操作记录表,当订单状态发生改变时,用于记录订单的操作信息。';
部分ER图
相关ER图