springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/microCommercialStreet/McsOrderVO.java
New file @@ -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; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/McsOrderApi.java
New file @@ -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)); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsOrderDao.java
New file @@ -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); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/McsOrder.java
New file @@ -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; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/McsOrderService.java
New file @@ -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); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/McsOrderServiceImpl.java
New file @@ -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)); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsOrderMapper.xml
New file @@ -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>
