From 7d4d5f6000f09cf7e1b5e94e7873208b00315c61 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期三, 05 一月 2022 09:39:03 +0800
Subject: [PATCH] 数字商业街 订单管理
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/McsOrderApi.java | 80 +++++++++++
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/microCommercialStreet/McsOrderVO.java | 82 +++++++++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/McsOrder.java | 90 ++++++++++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/McsOrderServiceImpl.java | 38 +++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsOrderDao.java | 34 ++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/McsOrderService.java | 32 ++++
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsOrderMapper.xml | 43 ++++++
7 files changed, 399 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/microCommercialStreet/McsOrderVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/microCommercialStreet/McsOrderVO.java
new file mode 100644
index 0000000..8b43506
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/microCommercialStreet/McsOrderVO.java
@@ -0,0 +1,82 @@
+package com.panzhihua.common.model.vos.community.microCommercialStreet;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.Date;
+@Data
+@ApiModel("商业街订单表")
+public class McsOrderVO {
+ private Long id;
+
+ /**
+ * 订单编号
+ */
+ @ApiModelProperty(value = "订单编号")
+ private Long orderNo;
+
+ /**
+ * 支付配置id
+ */
+ @ApiModelProperty(value = "支付配置id")
+ private Long configId;
+
+ /**
+ * 数量
+ */
+ @ApiModelProperty(value = "数量")
+ private Integer num;
+
+ /**
+ * 支付状态 0 待支付 1已支付 2 已取消 3 已退款
+ */
+ @ApiModelProperty(value = "支付状态 0 待支付 1已支付 2 已取消 3 已退款")
+ private Integer status;
+
+ /**
+ * 支付金额
+ */
+ @ApiModelProperty(value = "支付金额")
+ private Double money;
+
+ /**
+ * 支付时间
+ */
+ @ApiModelProperty(value = "支付时间")
+ private Date payTime;
+
+ /**
+ * 商家id
+ */
+ @ApiModelProperty(value = "商家id")
+ private Long merchantId;
+
+ /**
+ * 支付流水号
+ */
+ @ApiModelProperty(value = "支付流水号")
+ private Long payNo;
+
+ /**
+ * 用户id
+ */
+ @ApiModelProperty(value = "用户id")
+ private Long userId;
+ /**
+ * 商家名称
+ */
+ @ApiModelProperty("商家名称")
+ private String merchantName;
+ /**
+ * 付费名称
+ */
+ @ApiModelProperty("付费名称")
+ private String payName;
+ /**
+ * 商家账号
+ */
+ @ApiModelProperty("商家账号")
+ private String merchantAccount;
+
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/McsOrderApi.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/McsOrderApi.java
new file mode 100644
index 0000000..3006d95
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/McsOrderApi.java
@@ -0,0 +1,80 @@
+package com.panzhihua.service_community.api;
+
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.api.ApiController;
+import com.panzhihua.common.model.vos.R;
+import com.panzhihua.common.model.dtos.property.CommonPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO;
+import com.panzhihua.service_community.entity.McsOrder;
+import com.panzhihua.service_community.service.McsOrderService;
+import org.springframework.beans.BeanUtils;
+import org.springframework.web.bind.annotation.*;
+
+import javax.annotation.Resource;
+import java.io.Serializable;
+import java.util.List;
+
+/**
+ * 商业街订单表(McsOrder)表控制层
+ *
+ * @author makejava
+ * @since 2022-01-04 16:10:07
+ */
+@RestController
+@RequestMapping("mcsOrder")
+public class McsOrderApi {
+ /**
+ * 服务对象
+ */
+ @Resource
+ private McsOrderService mcsOrderService;
+
+ /**
+ * 分页查询所有数据
+ *
+ * @param commonPage 查询实体
+ * @return 所有数据
+ */
+ @PostMapping("queryAll")
+ public R selectAll(@RequestBody CommonPage commonPage) {
+ return this.mcsOrderService.pageList(commonPage);
+ }
+
+ /**
+ * 通过主键查询单条数据
+ *
+ * @param id 主键
+ * @return 单条数据
+ */
+ @GetMapping("{id}")
+ public R selectOne(@PathVariable("id") Long id) {
+ return R.ok(this.mcsOrderService.getById(id));
+ }
+
+ /**
+ * 新增数据
+ *
+ * @param mcsOrderVO 实体对象
+ * @return 新增结果
+ */
+ @PostMapping
+ public R insert(@RequestBody McsOrderVO mcsOrderVO) {
+ return this.mcsOrderService.insert(mcsOrderVO);
+ }
+
+ /**
+ * 修改数据
+ *
+ * @param mcsOrderVO 实体对象
+ * @return 修改结果
+ */
+ @PostMapping("/update")
+ public R update(@RequestBody McsOrderVO mcsOrderVO) {
+ McsOrder mcsOrder=new McsOrder();
+ BeanUtils.copyProperties(mcsOrderVO,mcsOrder);
+ return R.ok(this.mcsOrderService.updateById(mcsOrder));
+ }
+
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsOrderDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsOrderDao.java
new file mode 100644
index 0000000..a373b12
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsOrderDao.java
@@ -0,0 +1,34 @@
+package com.panzhihua.service_community.dao;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.dtos.property.CommonPage;
+import com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO;
+import org.apache.ibatis.annotations.Mapper;
+import com.panzhihua.service_community.entity.McsOrder;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * 商业街订单表(McsOrder)表数据库访问层
+ *
+ * @author makejava
+ * @since 2022-01-04 16:10:06
+ */
+@Mapper
+public interface McsOrderDao extends BaseMapper<McsOrder> {
+ /**
+ * 分页查询
+ * @param page
+ * @param commonPage
+ * @return
+ */
+ IPage<McsOrderVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);
+
+ /**
+ * 详情接口
+ * @param id
+ * @return
+ */
+ McsOrderVO detail(Long id);
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/McsOrder.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/McsOrder.java
new file mode 100644
index 0000000..82e2440
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/McsOrder.java
@@ -0,0 +1,90 @@
+package com.panzhihua.service_community.entity;
+
+import java.util.Date;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.AllArgsConstructor;
+import lombok.Builder;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.io.Serializable;
+import java.util.Date;
+
+
+/**
+ * 商业街订单表(McsOrder)表实体类
+ *
+ * @author makejava
+ * @since 2022-01-04 16:10:06
+ */
+@Data
+@Builder
+@AllArgsConstructor
+@NoArgsConstructor
+@ApiModel("商业街订单表")
+public class McsOrder implements Serializable {
+
+ private static final long serialVersionUID = -92724536016243196L;
+
+ @TableId(type = IdType.AUTO)
+ private Long id;
+
+ /**
+ * 订单编号
+ */
+ @ApiModelProperty(value = "订单编号")
+ private Long orderNo;
+
+ /**
+ * 支付配置id
+ */
+ @ApiModelProperty(value = "支付配置id")
+ private Long configId;
+
+ /**
+ * 数量
+ */
+ @ApiModelProperty(value = "数量")
+ private Integer num;
+
+ /**
+ * 支付状态 0 待支付 1已支付 2 已取消 3 已退款
+ */
+ @ApiModelProperty(value = "支付状态 0 待支付 1已支付 2 已取消 3 已退款")
+ private Integer status;
+
+ /**
+ * 支付金额
+ */
+ @ApiModelProperty(value = "支付金额")
+ private Double money;
+
+ /**
+ * 支付时间
+ */
+ @ApiModelProperty(value = "支付时间")
+ private Date payTime;
+
+ /**
+ * 商家id
+ */
+ @ApiModelProperty(value = "商家id")
+ private Long merchantId;
+
+ /**
+ * 支付流水号
+ */
+ @ApiModelProperty(value = "支付流水号")
+ private Long payNo;
+
+ /**
+ * 用户id
+ */
+ @ApiModelProperty(value = "用户id")
+ private Long userId;
+
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/McsOrderService.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/McsOrderService.java
new file mode 100644
index 0000000..f9c84da
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/McsOrderService.java
@@ -0,0 +1,32 @@
+package com.panzhihua.service_community.service;
+
+import com.panzhihua.common.model.vos.R;
+import com.panzhihua.common.model.dtos.property.CommonPage;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO;
+import com.panzhihua.service_community.entity.McsOrder;
+
+/**
+ * 商业街订单表(McsOrder)表服务接口
+ *
+ * @author makejava
+ * @since 2022-01-04 16:10:07
+ */
+public interface McsOrderService extends IService<McsOrder> {
+ /**
+ * 分页查询
+ *
+ * @param commonPage
+ * @return
+ */
+ R pageList(CommonPage commonPage);
+
+ /**
+ * 创建订单
+ * @param mcsOrderVO
+ * @return
+ */
+ R insert(McsOrderVO mcsOrderVO);
+
+ R detail(Long id);
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/McsOrderServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/McsOrderServiceImpl.java
new file mode 100644
index 0000000..182f6c9
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/McsOrderServiceImpl.java
@@ -0,0 +1,38 @@
+package com.panzhihua.service_community.service.impl;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.panzhihua.common.model.dtos.property.CommonPage;
+import com.panzhihua.common.model.vos.R;
+import com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO;
+import com.panzhihua.service_community.entity.McsOrder;
+import com.panzhihua.service_community.dao.McsOrderDao;
+import com.panzhihua.service_community.service.McsOrderService;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Service;
+
+/**
+ * 商业街订单表(McsOrder)表服务实现类
+ *
+ * @author makejava
+ * @since 2022-01-04 16:10:07
+ */
+@Slf4j
+@Service
+public class McsOrderServiceImpl extends ServiceImpl<McsOrderDao, McsOrder> implements McsOrderService {
+
+ @Override
+ public R pageList(CommonPage commonPage) {
+ return R.ok(this.baseMapper.pageList(new Page(commonPage.getPage(),commonPage.getSize()),commonPage));
+ }
+
+ @Override
+ public R insert(McsOrderVO mcsOrderVO) {
+ return null;
+ }
+
+ @Override
+ public R detail(Long id) {
+ return R.ok(this.baseMapper.detail(id));
+ }
+}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsOrderMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsOrderMapper.xml
new file mode 100644
index 0000000..1009cbe
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsOrderMapper.xml
@@ -0,0 +1,43 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.panzhihua.service_community.dao.McsOrderDao">
+
+ <resultMap type="com.panzhihua.service_community.entity.McsOrder" id="McsOrderBaseResultMap">
+ <result property="id" column="id"/>
+ <result property="orderNo" column="order_no"/>
+ <result property="configId" column="config_id"/>
+ <result property="num" column="num"/>
+ <result property="status" column="status"/>
+ <result property="money" column="money"/>
+ <result property="payTime" column="pay_time"/>
+ <result property="merchantId" column="merchant_id"/>
+ <result property="payNo" column="pay_no"/>
+ <result property="userId" column="user_id"/>
+ </resultMap>
+
+ <select id="pageList" resultType="com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO">
+ select t.*,t1.`name` as payName,t2.name as merchantName,t2.account as merchantAccount from mcs_order t
+ left join mcs_config t1 on t.config_id = t1.id
+ left join mcs_merchant t2 on t.merchant_id = t2.id
+ <where>
+ <if test="commonPage.status !=null">
+ and t.status = #{commonPage.status}
+ </if>
+ <if test="commonPage.keyword !=null and commonPage.keyword !=''">
+ and t.order_no like concat('%',#{commonPage.keyword},'%')
+ </if>
+ <if test="commonPage.userId !=null">
+ and t.user_id = #{commonPage.userId}
+ </if>
+ </where>
+ order by t.create_time desc
+ </select>
+
+ <select id="detail" resultType="com.panzhihua.common.model.vos.community.microCommercialStreet.McsOrderVO">
+ select t.*,t1.`name` as payName,t2.name as merchantName,t2.account as merchantAccount from mcs_order t
+ left join mcs_config t1 on t.config_id = t1.id
+ left join mcs_merchant t2 on t.merchant_id = t2.id
+ where t.id =#{id}
+ </select>
+
+</mapper>
--
Gitblit v1.7.1