From 38609ee05255ce5c36f308fe8d595555a86f9ba3 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Tue, 22 Jun 2021 17:04:13 +0800 Subject: [PATCH] 20210622 商品分类 --- gc-shop/src/main/java/com/xzx/gc/shop/controller/GoodsController.java | 175 +++++++++++++++++++++ gc-shop/src/main/java/com/xzx/gc/shop/mapper/ScoreGoodsCategoryMapper.java | 7 gc-shop/src/main/java/com/xzx/gc/shop/vo/QueryGoodsCategoryListVo.java | 30 +++ gc-shop/src/main/java/com/xzx/gc/shop/dto/DeleteGoodsCategoryDto.java | 8 + gc-core/src/main/java/com/xzx/gc/model/admin/GoodsCategoryModel.java | 29 +++ pom.xml | 1 gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java | 1 gc-shop/src/main/java/com/xzx/gc/shop/dto/AddGoodsCategoryDto.java | 21 ++ gc-shop/src/main/java/com/xzx/gc/shop/service/GoodsService.java | 92 +++++++++++ gc-shop/src/main/java/com/xzx/gc/shop/vo/ViewGoodsCategoryVo.java | 17 ++ gc-core/src/main/java/com/xzx/gc/common/entity/BaseEntity.java | 10 gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryGoodsCategoryListDto.java | 21 ++ gc-shop/src/main/resources/mapper/shop/ScoreGoodsCategoryMapper.xml | 23 ++ gc-shop/src/main/java/com/xzx/gc/shop/dto/UpdateGoodsCategoryDto.java | 16 ++ 14 files changed, 448 insertions(+), 3 deletions(-) diff --git a/gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java b/gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java index 30d3f14..fe2d431 100644 --- a/gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java +++ b/gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java @@ -193,6 +193,7 @@ public static final String SYS_MODUL_NAME="消息模块"; public static final String PAY_MODUL_NAME="支付模块"; public static final String ROLE_MODUL_NAME="权限模块"; + public static final String SCORESHOP_MODUL_NAME="积分商城模块"; //最小正常文件大小 diff --git a/gc-core/src/main/java/com/xzx/gc/common/entity/BaseEntity.java b/gc-core/src/main/java/com/xzx/gc/common/entity/BaseEntity.java index f742eb3..c7fb9cc 100644 --- a/gc-core/src/main/java/com/xzx/gc/common/entity/BaseEntity.java +++ b/gc-core/src/main/java/com/xzx/gc/common/entity/BaseEntity.java @@ -1,19 +1,23 @@ package com.xzx.gc.common.entity; +import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; +import java.io.Serializable; import java.util.Date; @Data -public class BaseEntity { +public class BaseEntity implements Serializable { + private static final long serialVersionUID = 1L; - private String createBy; + private String createdBy; - private Date createTime; + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + private Date createdTime; private String delFlag; diff --git a/gc-core/src/main/java/com/xzx/gc/model/admin/GoodsCategoryModel.java b/gc-core/src/main/java/com/xzx/gc/model/admin/GoodsCategoryModel.java new file mode 100644 index 0000000..d2ccc1b --- /dev/null +++ b/gc-core/src/main/java/com/xzx/gc/model/admin/GoodsCategoryModel.java @@ -0,0 +1,29 @@ +package com.xzx.gc.model.admin; + +import com.alibaba.fastjson.annotation.JSONField; +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.io.Serializable; +import java.util.Date; +import java.util.List; +@Data +public class GoodsCategoryModel implements Serializable { + + private long id ; + @ApiModelProperty(value="分类名称",required=true) + private String name; + @ApiModelProperty(value="类别标识",required=true) + private String categoryIden; + @ApiModelProperty(value="父分类",required=true) + private Long parentId; + + @JSONField(format="yyyy-MM-dd HH:mm:ss") + @ApiModelProperty(value="创建时间") + private Date createdTime; + private String createdBy; + + int page; + int limit; +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/controller/GoodsController.java b/gc-shop/src/main/java/com/xzx/gc/shop/controller/GoodsController.java new file mode 100644 index 0000000..3ae1d0e --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/controller/GoodsController.java @@ -0,0 +1,175 @@ +package com.xzx.gc.shop.controller; + +import cn.hutool.core.collection.CollUtil; +import cn.hutool.core.util.ObjectUtil; +import cn.hutool.core.util.StrUtil; +import com.xzx.gc.common.constant.CommonEnum; +import com.xzx.gc.common.constant.Constants; +import com.xzx.gc.common.dto.log.OperationAppLog; +import com.xzx.gc.common.request.BaseController; +import com.xzx.gc.entity.ScoreGoodsCategory; +import com.xzx.gc.model.JsonResult; +import com.xzx.gc.model.admin.GoodsCategoryModel; +import com.xzx.gc.shop.dto.AddGoodsCategoryDto; +import com.xzx.gc.shop.dto.DeleteGoodsCategoryDto; +import com.xzx.gc.shop.dto.QueryGoodsCategoryListDto; +import com.xzx.gc.shop.dto.UpdateGoodsCategoryDto; +import com.xzx.gc.shop.mapper.ScoreGoodsCategoryMapper; +import com.xzx.gc.shop.service.GoodsService; +import com.xzx.gc.shop.vo.QueryGoodsCategoryListVo; +import com.xzx.gc.shop.vo.ViewGoodsCategoryVo; +import io.swagger.annotations.*; +import lombok.extern.slf4j.Slf4j; +import org.springframework.web.bind.annotation.*; + +import javax.annotation.Resource; +import javax.servlet.http.HttpServletRequest; +import java.util.Date; +import java.util.List; +import java.util.Map; + +@RestController +@Api(tags = {"积分商城--商品管理"}) +@Slf4j +public class GoodsController extends BaseController { + + @Resource + private GoodsService goodsService; + + @Resource + private ScoreGoodsCategoryMapper scoreGoodsCategoryMapper; + + /** + * 查询商品分类列表 + * xzx_score_goods_category商品分类 + */ + @PostMapping(Constants.ADMIN_VIEW_PREFIX+"/score/goods/queryGoodsCategoryList.json") + @ApiResponses({@ApiResponse( code = 200, message = "success", response = QueryGoodsCategoryListVo.class)}) + @ApiOperation(value = "商品分类管理-商品分类列表", notes = "test: 仅0有正确返回") + public JsonResult<Map<String, Object>> queryGoodsCategoryList(@RequestBody QueryGoodsCategoryListDto model) { + Map<String, Object> result = goodsService.queryGoodsCategoryList(model); + return JsonResult.success(result); + } + + /** + * 添加商品分类 + */ + @PostMapping(Constants.ADMIN_VIEW_PREFIX+"/score/goods/addGoodsCategory.json") + @ApiOperation(value = "商品分类管理-添加商品分类", notes = "test: 仅0有正确返回") + public JsonResult<String> addGoodsCategory(@RequestBody AddGoodsCategoryDto model, HttpServletRequest request) { + String name = model.getName(); + if(StrUtil.isEmpty(name)){ + return JsonResult.failMessage("分类名称不能为空!"); + } + String categoryIden = model.getCategoryIden(); + if(StrUtil.isEmpty(categoryIden)){ + return JsonResult.failMessage("分类代码不能为空!"); + } + Long parentId = model.getParentId(); + if(StrUtil.isEmpty(parentId.toString())){ + return JsonResult.failMessage("父类不能为空!"); + } + GoodsCategoryModel goodsCategoryModel = new GoodsCategoryModel(); + goodsCategoryModel.setName(name); + goodsCategoryModel.setCategoryIden(categoryIden); + goodsCategoryModel.setParentId(parentId); + List<QueryGoodsCategoryListVo> maps = scoreGoodsCategoryMapper.queryGoodsCategoryList(goodsCategoryModel); + if(CollUtil.isNotEmpty(maps)){ + return JsonResult.failMessage("分类不能重复添加!"); + } + goodsCategoryModel.setCreatedBy(getAdminName(request)); + goodsCategoryModel.setCreatedTime(new Date()); + Long scoreGoodsCategoryId = goodsService.addGoodsCategory(goodsCategoryModel); + if(scoreGoodsCategoryId > 0){ + OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request)) + .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("商品管理-添加商品分类-" + scoreGoodsCategoryId).build(); + mqUtil.sendApp(build); + return JsonResult.success("操作成功!"); + }else{ + return JsonResult.failMessage("操作失败!"); + } + } + + /** + * 删除添加商品分类 + */ + + @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/score/goods/deleteGoodsCategory.json") + @ApiOperation(value="商品分类管理-删除添加商品分类", notes="test: 仅0有正确返回") + public JsonResult deleteGoodsCategory(@RequestBody DeleteGoodsCategoryDto model, HttpServletRequest request) { + long id = model.getId(); + ScoreGoodsCategory scoreGoodsCategory = scoreGoodsCategoryMapper.selectByPrimaryKey(id); + if(ObjectUtil.isEmpty(scoreGoodsCategory)){ + return JsonResult.failMessage("分类不存在!"); + } + goodsService.deleteGoodsCategory(id); + OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request)) + .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("商品管理-删除添加商品分类-"+id).build(); + mqUtil.sendApp(build); + return new JsonResult().success("操作成功!"); + } + + /** + * 查看商品分类详情 + */ + @GetMapping(Constants.ADMIN_VIEW_PREFIX + "/score/goods/viewGoodsCategory/{id}") + @ApiResponses({@ApiResponse( code = 200, message = "success", response = ViewGoodsCategoryVo.class)}) + @ApiOperation(value="商品分类管理-查看商品分类详情", notes="test: 仅0有正确返回") + public JsonResult<ViewGoodsCategoryVo> viewGoodsCategory(@PathVariable long id) { + ViewGoodsCategoryVo viewGoodsCategoryVo = goodsService.viewGoodsCategoryById(id); + return JsonResult.success(viewGoodsCategoryVo); + } + + /** + * 更新商品分类 + * @param model + * @return + */ + @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/score/goods/updateGoodsCategory.json") + @ApiOperation(value="商品分类管理-更新商品分类", notes="test: 仅0有正确返回") + public JsonResult updateGoodsCategory(@RequestBody UpdateGoodsCategoryDto model, HttpServletRequest request) { + long id = model.getId(); + ScoreGoodsCategory scoreGoodsCategory = scoreGoodsCategoryMapper.selectByPrimaryKey(id); + if(ObjectUtil.isEmpty(scoreGoodsCategory)){ + return JsonResult.failMessage("分类不存在!"); + } + String name = model.getName(); + if(StrUtil.isEmpty(name)){ + return JsonResult.failMessage("分类名称不能为空!"); + } + if(!name.equals(scoreGoodsCategory.getName())){ + scoreGoodsCategory.setName(name); + } + String categoryIden = model.getCategoryIden(); + if(StrUtil.isEmpty(categoryIden)){ + return JsonResult.failMessage("分类代码不能为空!"); + } + if(!categoryIden.equals(scoreGoodsCategory.getCategoryIden())){ + scoreGoodsCategory.setCategoryIden(categoryIden); + } + Long parentId = model.getParentId(); + if(StrUtil.isEmpty(parentId.toString())){ + return JsonResult.failMessage("父类不能为空!"); + } + if(!parentId.equals(scoreGoodsCategory.getParentId())){ + scoreGoodsCategory.setParentId(parentId); + } + + GoodsCategoryModel goodsCategoryModel = new GoodsCategoryModel(); + goodsCategoryModel.setName(name); + goodsCategoryModel.setCategoryIden(categoryIden); + goodsCategoryModel.setParentId(parentId); + List<QueryGoodsCategoryListVo> maps = scoreGoodsCategoryMapper.queryGoodsCategoryList(goodsCategoryModel); + if(CollUtil.isNotEmpty(maps)){ + return JsonResult.failMessage("分类不能重复添加!"); + } + goodsCategoryModel.setId(id); + goodsService.updateGoodsCategory(goodsCategoryModel); + OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request)) + .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("商品管理-更新商品分类-" + id).build(); + mqUtil.sendApp(build); + return JsonResult.success("操作成功!"); + } + + +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/AddGoodsCategoryDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/AddGoodsCategoryDto.java new file mode 100644 index 0000000..3af003a --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/AddGoodsCategoryDto.java @@ -0,0 +1,21 @@ +package com.xzx.gc.shop.dto; + +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.io.Serializable; +import java.util.Date; + +@Data +public class AddGoodsCategoryDto implements Serializable { + + @ApiModelProperty(value="分类名称") + private String name; + @ApiModelProperty(value="类别标识") + private String categoryIden; + @ApiModelProperty(value="父分类") + private Long parentId; + +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/DeleteGoodsCategoryDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/DeleteGoodsCategoryDto.java new file mode 100644 index 0000000..6f5b7dc --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/DeleteGoodsCategoryDto.java @@ -0,0 +1,8 @@ +package com.xzx.gc.shop.dto; + +import lombok.Data; + +@Data +public class DeleteGoodsCategoryDto { + private long id; +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryGoodsCategoryListDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryGoodsCategoryListDto.java new file mode 100644 index 0000000..12bf640 --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/QueryGoodsCategoryListDto.java @@ -0,0 +1,21 @@ +package com.xzx.gc.shop.dto; + +import com.alibaba.fastjson.annotation.JSONField; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.io.Serializable; +import java.util.Date; + +@Data +public class QueryGoodsCategoryListDto implements Serializable { + + @ApiModelProperty(value="分类名称",required=true) + private String name; + @ApiModelProperty(value="第几页",required=true) + private int page; + @ApiModelProperty(value="每一页数量",required=true) + private int limit; + +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/dto/UpdateGoodsCategoryDto.java b/gc-shop/src/main/java/com/xzx/gc/shop/dto/UpdateGoodsCategoryDto.java new file mode 100644 index 0000000..c18d5c7 --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/dto/UpdateGoodsCategoryDto.java @@ -0,0 +1,16 @@ +package com.xzx.gc.shop.dto; + +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +public class UpdateGoodsCategoryDto { + + private long id; + @ApiModelProperty(value="分类名称") + private String name; + @ApiModelProperty(value="类别标识") + private String categoryIden; + @ApiModelProperty(value="父分类") + private Long parentId; +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/mapper/ScoreGoodsCategoryMapper.java b/gc-shop/src/main/java/com/xzx/gc/shop/mapper/ScoreGoodsCategoryMapper.java index 739c2e9..2f28934 100644 --- a/gc-shop/src/main/java/com/xzx/gc/shop/mapper/ScoreGoodsCategoryMapper.java +++ b/gc-shop/src/main/java/com/xzx/gc/shop/mapper/ScoreGoodsCategoryMapper.java @@ -1,7 +1,14 @@ package com.xzx.gc.shop.mapper; import com.xzx.gc.entity.ScoreGoodsCategory; +import com.xzx.gc.model.admin.GoodsCategoryModel; +import com.xzx.gc.shop.vo.QueryGoodsCategoryListVo; import com.xzx.gc.util.GcMapper; +import java.util.List; + public interface ScoreGoodsCategoryMapper extends GcMapper<ScoreGoodsCategory> { + + List<QueryGoodsCategoryListVo> queryGoodsCategoryList(GoodsCategoryModel goodsCategoryModel); + } diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/service/GoodsService.java b/gc-shop/src/main/java/com/xzx/gc/shop/service/GoodsService.java new file mode 100644 index 0000000..59030c1 --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/service/GoodsService.java @@ -0,0 +1,92 @@ +package com.xzx.gc.shop.service; + +import cn.hutool.core.collection.CollUtil; +import cn.hutool.core.convert.Convert; +import cn.hutool.core.util.StrUtil; +import com.github.pagehelper.PageHelper; +import com.github.pagehelper.PageInfo; +import com.xzx.gc.common.constant.CommonEnum; +import com.xzx.gc.common.constant.Constants; +import com.xzx.gc.common.dto.log.OperationAppLog; +import com.xzx.gc.common.utils.MqUtil; +import com.xzx.gc.entity.CoreUser; +import com.xzx.gc.entity.ScoreGoodsCategory; +import com.xzx.gc.model.JsonResult; +import com.xzx.gc.model.admin.GoodsCategoryModel; +import com.xzx.gc.shop.dto.QueryGoodsCategoryListDto; +import com.xzx.gc.shop.mapper.ScoreGoodsCategoryMapper; +import com.xzx.gc.shop.vo.QueryGoodsCategoryListVo; +import com.xzx.gc.shop.vo.ViewGoodsCategoryVo; +import com.xzx.gc.util.SessionUtil; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; + +import javax.annotation.Resource; +import javax.servlet.http.HttpServletRequest; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +@Service +@Transactional +@Slf4j +public class GoodsService { + + @Resource + ScoreGoodsCategoryMapper scoreGoodsCategoryMapper; + + @Autowired + private MqUtil mqUtil; + + public Map<String, Object> queryGoodsCategoryList(QueryGoodsCategoryListDto model) { + String name = model.getName(); + GoodsCategoryModel goodsCategoryModel = new GoodsCategoryModel(); + goodsCategoryModel.setName(name); + PageHelper.startPage(model.getPage(), model.getLimit()); + + List<QueryGoodsCategoryListVo> maps = scoreGoodsCategoryMapper.queryGoodsCategoryList(goodsCategoryModel); + PageInfo pageInfo = new PageInfo(maps); + int count = Convert.toInt(pageInfo.getTotal()); + Map<String, Object> map = new HashMap<>(); + map.put("data", maps); + map.put("count", count); + map.put("code", 0); + return map; + } + + public Long addGoodsCategory(GoodsCategoryModel model) { + ScoreGoodsCategory scoreGoodsCategory = new ScoreGoodsCategory(); + scoreGoodsCategory.setName(model.getName()); + scoreGoodsCategory.setCategoryIden(model.getCategoryIden()); + scoreGoodsCategory.setParentId(model.getParentId()); + scoreGoodsCategory.setCreatedBy(model.getCreatedBy()); + scoreGoodsCategory.setCreatedTime(model.getCreatedTime()); + scoreGoodsCategoryMapper.insert(scoreGoodsCategory); + return scoreGoodsCategory.getId(); + } + + public void deleteGoodsCategory(long id) { + scoreGoodsCategoryMapper.deleteByPrimaryKey(id); + } + + public ViewGoodsCategoryVo viewGoodsCategoryById(long id) { + ScoreGoodsCategory scoreGoodsCategory = scoreGoodsCategoryMapper.selectByPrimaryKey(id); + ViewGoodsCategoryVo viewGoodsCategoryVo = new ViewGoodsCategoryVo(); + viewGoodsCategoryVo.setId(scoreGoodsCategory.getId()); + viewGoodsCategoryVo.setName(scoreGoodsCategory.getName()); + viewGoodsCategoryVo.setCategoryIden(scoreGoodsCategory.getCategoryIden()); + viewGoodsCategoryVo.setParentId(scoreGoodsCategory.getParentId()); + return viewGoodsCategoryVo; + } + + public void updateGoodsCategory(GoodsCategoryModel model) { + long id = model.getId(); + ScoreGoodsCategory scoreGoodsCategory = scoreGoodsCategoryMapper.selectByPrimaryKey(id); + scoreGoodsCategory.setName(model.getName()); + scoreGoodsCategory.setCategoryIden(model.getCategoryIden()); + scoreGoodsCategory.setParentId(model.getParentId()); + scoreGoodsCategoryMapper.updateByPrimaryKey(scoreGoodsCategory); + } +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/vo/QueryGoodsCategoryListVo.java b/gc-shop/src/main/java/com/xzx/gc/shop/vo/QueryGoodsCategoryListVo.java new file mode 100644 index 0000000..b82208c --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/vo/QueryGoodsCategoryListVo.java @@ -0,0 +1,30 @@ +package com.xzx.gc.shop.vo; + +import com.alibaba.fastjson.annotation.JSONField; +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +@Data +@ApiModel(value = "QueryGoodsCategoryListVo", description = "信息返回") +public class QueryGoodsCategoryListVo { + + private long id ; + @ApiModelProperty(value="分类名称") + private String name; + @ApiModelProperty(value="类别标识") + private String categoryIden; + @ApiModelProperty(value="父分类") + private Long parentId; + + + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + @ApiModelProperty(value="创建时间") + private Date createdTime; + + @ApiModelProperty(value="创建人") + private String createdBy; +} diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/vo/ViewGoodsCategoryVo.java b/gc-shop/src/main/java/com/xzx/gc/shop/vo/ViewGoodsCategoryVo.java new file mode 100644 index 0000000..8371cb5 --- /dev/null +++ b/gc-shop/src/main/java/com/xzx/gc/shop/vo/ViewGoodsCategoryVo.java @@ -0,0 +1,17 @@ +package com.xzx.gc.shop.vo; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +@ApiModel(value = "ViewGoodsCategoryVo", description = "返回") +public class ViewGoodsCategoryVo { + private long id ; + @ApiModelProperty(value="分类名称") + private String name; + @ApiModelProperty(value="类别标识") + private String categoryIden; + @ApiModelProperty(value="父分类") + private Long parentId; +} diff --git a/gc-shop/src/main/resources/mapper/shop/ScoreGoodsCategoryMapper.xml b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsCategoryMapper.xml new file mode 100644 index 0000000..581a8ec --- /dev/null +++ b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsCategoryMapper.xml @@ -0,0 +1,23 @@ +<?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.xzx.gc.shop.mapper.ScoreGoodsCategoryMapper"> + + <select id="queryGoodsCategoryList" resultType="com.xzx.gc.shop.vo.QueryGoodsCategoryListVo"> + SELECT + * + FROM + xzx_score_goods_category a + WHERE 1 = 1 + <if test="name != null and name != ''"> + and a.name=#{name} + </if> + <if test="categoryIden != null and categoryIden != ''"> + and a.category_iden=#{categoryIden} + </if> + <if test="parentId != null and parentId != ''"> + and a.parent_id=#{parentId} + </if> + order by a.CREATED_TIME desc + </select> + +</mapper> diff --git a/pom.xml b/pom.xml index ac3a5f5..a0d43e8 100644 --- a/pom.xml +++ b/pom.xml @@ -23,6 +23,7 @@ <module>gc-sys</module> <module>gc-pay</module> <module>gc-role</module> + <module>gc-shop</module> <!--<module>gc-admin</module>--> </modules> <packaging>pom</packaging> -- Gitblit v1.9.1