金汇商城商品模块

lidongdong

2023-10-18 55b84864019585f77a303715e02d564bce55159b

金汇商城商品模块

 springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/JinHuiCommnuityApi.java

@@ -478,4 +478,38 @@
        return jinhuiCommunityService.volunteeringExpurgateData(id);
    }


    /*********************************************************************************************************
     *
     *
     *            金汇商城商品
     *
     *
     *********************************************************************************************************/
    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @ApiOperation(value = "金汇商城商品列表表", response = JinhuiShoppingVO.class)
    @GetMapping("/shoppingGetList")
    public R shoppingGetList(@RequestParam("pageNum") int pageNum,
                             @RequestParam("pageSize") int pageSize,
                             @RequestParam(value = "goodName", required = false) String goodName,
                             @RequestParam(value = "goodType", required = false) String goodType,
                             @RequestParam(value = "id", required = false) String id)
    {
        return jinhuiCommunityService.shoppingGetList(pageNum,pageSize,goodName,goodType,id);
    }


    @ApiOperation(value = "金汇商城商品详情", response = JinhuiShoppingVO.class)
    @GetMapping("/shoppingGetDetails")
    public R shoppingGetDetails(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.shoppingGetDetails(id);
    }


}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiInterspaceApplyForVO.java

@@ -44,6 +44,9 @@
    @ApiModelProperty(value = "状态（1待处理  2未通过  3已通过）")
    private String state;

    @ApiModelProperty(value = "用处")
    private String content;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date creationTime;

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiShoppingVO.java

New file
@@ -0,0 +1,51 @@
package com.panzhihua.common.model.vos.jinhui;

import com.fasterxml.jackson.annotation.JsonFormat;
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;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("金汇商城商品表")
public class JinhuiShoppingVO implements Serializable {
    private static final long serialVersionUID = -70884515430727555L;

    @ApiModelProperty(value = "主键")
    private String id;

    @ApiModelProperty(value = "商品名称")
    private String goodName;

    @ApiModelProperty(value = "商品价格")
    private String goodPrice;

    @ApiModelProperty(value = "商品状态（0下架  1上架）")
    private String goodType;

    @ApiModelProperty(value = "商品封面")
    private String coverImgUrl;

    @ApiModelProperty(value = "商品详情内容")
    private String content;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date creationTime;

    @ApiModelProperty(value = "更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date updateTime;




}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/jinhui/JinhuiCommunityService.java

@@ -549,5 +549,48 @@
    public R volunteeringTypeExpurgateData(@RequestParam("id") String id);


    /*********************************************************************************************************
     *
     *
     *            金汇商城商品
     *
     *
     *********************************************************************************************************/
    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @GetMapping("/jinhuiShopping/shoppingGetList")
    public R shoppingGetList(@RequestParam("pageNum") int pageNum,
                             @RequestParam("pageSize") int pageSize,
                             @RequestParam(value = "goodName", required = false) String goodName,
                             @RequestParam(value = "goodType", required = false) String goodType,
                             @RequestParam(value = "id", required = false) String id);


    @GetMapping("/jinhuiShopping/shoppingGetDetails")
    public R shoppingGetDetails(@RequestParam("id") String id);

    /**
     * 新增
     *
     * @param
     * @return
     */
    @PostMapping("/jinhuiShopping/shoppingAddData")
    public R shoppingAddData(@RequestBody JinhuiShoppingVO item);


    @PostMapping("/jinhuiShopping/shoppingEditData")
    public R shoppingEditData(@RequestBody JinhuiShoppingVO item);

    @DeleteMapping("/jinhuiShopping/shoppingExpurgateData")
    public R shoppingExpurgateData(@RequestParam("id") String id);





}

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/JinhuiAppi.java

@@ -526,4 +526,72 @@
    }



    /*********************************************************************************************************
     *
     *
     *            金汇商城商品
     *
     *
     *********************************************************************************************************/
    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @ApiOperation(value = "金汇商城商品列表表", response = JinhuiShoppingVO.class)
    @GetMapping("/shoppingGetList")
    public R shoppingGetList(@RequestParam("pageNum") int pageNum,
                             @RequestParam("pageSize") int pageSize,
                             @RequestParam(value = "goodName", required = false) String goodName,
                             @RequestParam(value = "goodType", required = false) String goodType,
                             @RequestParam(value = "id", required = false) String id)
    {
        return jinhuiCommunityService.shoppingGetList(pageNum,pageSize,goodName,goodType,id);
    }


    @ApiOperation(value = "金汇商城商品详情", response = JinhuiShoppingVO.class)
    @GetMapping("/shoppingGetDetails")
    public R shoppingGetDetails(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.shoppingGetDetails(id);
    }

    /**
     * 新增
     *
     * @param
     * @return
     */
    @ApiOperation(value = "金汇商城商品添加")
    @PostMapping("/shoppingAddData")
    public R shoppingAddData(@RequestBody JinhuiShoppingVO item)
    {
        return jinhuiCommunityService.shoppingAddData(item);
    }


    @ApiOperation(value = "金汇商城商品编辑")
    @PostMapping("/shoppingEditData")
    public R shoppingEditData(@RequestBody JinhuiShoppingVO item)
    {
        return jinhuiCommunityService.shoppingEditData(item);
    }

    @ApiOperation(value = "金汇商城商品删除")
    @DeleteMapping("/shoppingExpurgateData")
    public R shoppingExpurgateData(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.shoppingExpurgateData(id);
    }








}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/api/JinhuiMicroVolunteeringApi.java

@@ -36,8 +36,8 @@
    @GetMapping("/volunteering/getList")
    public R volunteeringGetList(@RequestParam("pageNum") int pageNum,
                                 @RequestParam("pageSize") int pageSize,
                                 @RequestParam(value = "userId", required = false)String userId,
                                 @RequestParam(value = "state", required = false)String state)
                                 @RequestParam(value = "userId", required = false) String userId,
                                 @RequestParam(value = "state", required = false) String state)
    {
        return recordService.getList(pageNum,pageSize,userId,state);
    }

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/api/JinhuiShoppingApi.java

New file
@@ -0,0 +1,71 @@
package com.panzhihua.service_jinhui_community.api;

import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiShoppingVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiShopping;
import com.panzhihua.service_jinhui_community.service.JinhuiShoppingService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;


/**
 * 金汇商城商品表
 */
@Slf4j
@RestController
@RequestMapping("/jinhuiShopping")
public class JinhuiShoppingApi extends BaseController {
    @Resource
    private JinhuiShoppingService shoppingService;


    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @GetMapping("/shoppingGetList")
    public R shoppingGetList(@RequestParam("pageNum") int pageNum,
                     @RequestParam("pageSize") int pageSize,
                     @RequestParam(value = "goodName", required = false) String goodName,
                     @RequestParam(value = "goodType", required = false) String goodType,
                     @RequestParam(value = "id", required = false) String id)
    {
        return shoppingService.getList(pageNum, pageSize, goodName, goodType, id);
    }


    @GetMapping("/shoppingGetDetails")
    public R shoppingGetDetails(@RequestParam("id") String id)
    {
        return R.ok(shoppingService.getDetails(id));
    }

    /**
     * 新增
     *
     * @param
     * @return
     */
    @PostMapping("/shoppingAddData")
    public R shoppingAddData(@RequestBody JinhuiShoppingVO item) {
        return shoppingService.addData(item);
    }


    @PostMapping("/shoppingEditData")
    public R shoppingEditData(@RequestBody JinhuiShoppingVO item) {
        return shoppingService.editData(item);
    }

    @DeleteMapping("/shoppingExpurgateData")
    public R shoppingExpurgateData(@RequestParam("id") String id)
    {
        return shoppingService.expurgateData(id);
    }

}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/dao/JinhuiShoppingDao.java

New file
@@ -0,0 +1,54 @@
package com.panzhihua.service_jinhui_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.vos.jinhui.JinhuiShoppingVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiShopping;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface JinhuiShoppingDao extends BaseMapper<JinhuiShopping>
{
    /**
     * 列表
     * @param
     * @return
     */
    IPage<JinhuiShopping> getList(Page page,
                                           @Param("goodName") String goodName,
                                           @Param("goodType") String goodType,
                                           @Param("id") String id);

    /**
     * 详情
     * @param id
     * @return
     */
    JinhuiShopping getDetails(@Param("id") String id);

    /**
     * 新增
     * @param
     * @return
     */
    int addData(@Param("item") JinhuiShoppingVO item);


    /**
     * 编辑
     * @param item
     * @return
     */
    int editData(@Param("item") JinhuiShoppingVO item);

    /**
     * 删除
     * @param id
     * @return
     */
    int expurgateData(@Param("id") String id);


}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/entity/JinhuiInterspaceApplyFor.java

@@ -46,6 +46,9 @@
    @ApiModelProperty(value = "状态（1待处理  2未通过  3已通过）")
    private String state;

    @ApiModelProperty(value = "用处")
    private String content;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date creationTime;

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/entity/JinhuiShopping.java

New file
@@ -0,0 +1,51 @@
package com.panzhihua.service_jinhui_community.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
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;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("金汇商城商品表")
public class JinhuiShopping implements Serializable {
    private static final long serialVersionUID = -70884515430727555L;

    @ApiModelProperty(value = "主键")
    private String id;

    @ApiModelProperty(value = "商品名称")
    private String goodName;

    @ApiModelProperty(value = "商品价格")
    private String goodPrice;

    @ApiModelProperty(value = "商品状态（0下架  1上架）")
    private String goodType;

    @ApiModelProperty(value = "商品封面")
    private String coverImgUrl;

    @ApiModelProperty(value = "商品详情内容")
    private String content;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date creationTime;

    @ApiModelProperty(value = "更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date updateTime;




}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/JinhuiShoppingService.java

New file
@@ -0,0 +1,29 @@
package com.panzhihua.service_jinhui_community.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiShoppingVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiShopping;

public interface JinhuiShoppingService extends IService<JinhuiShopping>
{
    /**
     * 分页查询
     * @param
     * @return
     */
    R getList(int pageNum,int pageSize,
              String goodName, String goodType, String id);

    JinhuiShopping getDetails(String id);
    /**
     * 新增
     * @param
     * @return
     */
    R addData(JinhuiShoppingVO item);

    R editData(JinhuiShoppingVO item);

    R expurgateData(String id);
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/impl/JinhuiShoppingServiceImpl.java

New file
@@ -0,0 +1,67 @@
package com.panzhihua.service_jinhui_community.service.impl;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiMicroVolunteeringVO;
import com.panzhihua.common.model.vos.jinhui.JinhuiShoppingVO;
import com.panzhihua.service_jinhui_community.dao.JinhuiMicroVolunteeringDao;
import com.panzhihua.service_jinhui_community.dao.JinhuiShoppingDao;
import com.panzhihua.service_jinhui_community.entity.JinhuiMicroVolunteering;
import com.panzhihua.service_jinhui_community.entity.JinhuiShopping;
import com.panzhihua.service_jinhui_community.service.JinhuiMicroVolunteeringService;
import com.panzhihua.service_jinhui_community.service.JinhuiShoppingService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;


@Slf4j
@Service
public class JinhuiShoppingServiceImpl extends ServiceImpl<JinhuiShoppingDao,
        JinhuiShopping> implements JinhuiShoppingService
{

    @Override
    public R getList(int pageNum,int pageSize,String goodName, String goodType, String id)
    {
        Page page = new Page<JinhuiShopping>(pageNum,pageSize);
        return R.ok(baseMapper.getList(page,goodName,goodType,id));
    }

    @Override
    public JinhuiShopping getDetails(String id) {
        return baseMapper.getDetails(id);
    }


    @Override
    public R addData(JinhuiShoppingVO item)
    {
        int num= baseMapper.addData(item);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }

    @Override
    public R editData(JinhuiShoppingVO item) {
        int num= baseMapper.editData(item);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }

    @Override
    public R expurgateData(String id) {
        int num= baseMapper.expurgateData(id);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiInterspaceApplyForMapper.xml

@@ -12,6 +12,7 @@
        <result property="state" column="state" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
        <result property="content" column="content" />
    </resultMap>


@@ -27,7 +28,8 @@
            jiaf.user_phone,
            jiaf.state,
            jiaf.creation_time,
            jiaf.update_time
            jiaf.update_time,
            jiaf.content
        from jinhui_interspace_apply_for as jiaf
        LEFT JOIN jinhui_interspace as ji ON ji.id = jiaf.interspace_id
        <where>
@@ -63,7 +65,8 @@
            jiaf.user_phone,
            jiaf.state,
            jiaf.creation_time,
            jiaf.update_time
            jiaf.update_time,
            jiaf.content
        from jinhui_interspace_apply_for as jiaf
        LEFT JOIN jinhui_interspace as ji ON ji.id = jiaf.interspace_id
        where
@@ -94,6 +97,9 @@
            <if test="item.state != null and item.state != '' ">
                `state`,
            </if>
            <if test="item.content != null and item.content != '' ">
                content,
            </if>
            creation_time
        </trim>
        values
@@ -118,6 +124,9 @@
            </if>
            <if test="item.state != null and item.state != '' ">
                #{item.state},
            </if>
            <if test="item.content != null and item.content != '' ">
                #{item.content},
            </if>
            sysdate()
        </trim>
@@ -147,6 +156,9 @@
            <if test="item.state != null and item.state != '' ">
                `state`=#{item.state},
            </if>
            <if test="item.content != null and item.content != '' ">
                content=#{item.content},
            </if>
            update_time=sysdate()
        </set>
        where id = #{item.id}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiShoppingMapper.xml

New file
@@ -0,0 +1,140 @@
<?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_jinhui_community.dao.JinhuiShoppingDao">

    <resultMap type="com.panzhihua.service_jinhui_community.entity.JinhuiShopping" id="itemMap">
        <result property="id" column="id" />
        <result property="goodName" column="good_name" />
        <result property="goodPrice" column="good_price" />
        <result property="goodType" column="good_type" />
        <result property="coverImgUrl" column="cover_img_url" />
        <result property="content" column="content" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
    </resultMap>





    <!-- 分页查询 -->
    <select id="getList" resultMap="itemMap">
        select
            id,
            good_name,
            good_price,
            good_type,
            cover_img_url,
            content,
            creation_time,
            update_time
        from jinhui_shopping
        <where>
            1=1
            <if test="goodName !=null and goodName !='' ">
                and good_name LIKE CONCAT('%', #{goodName}, '%')
            </if>
            <if test="goodType !=null and goodType !='' ">
                and good_type=#{goodType}
            </if>
            <if test="id !=null and id !='' ">
                and id=#{id}
            </if>
        </where>
        order by creation_time desc
    </select>


    <select id="getDetails" resultMap="itemMap">
        select
            id,
            good_name,
            good_price,
            good_type,
            cover_img_url,
            content,
            creation_time,
            update_time
        from jinhui_shopping
        where
            id=#{id}
    </select>

    <insert id="addData">
        insert into jinhui_shopping
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="item.id != null and item.id != '' ">
                id,
            </if>
            <if test="item.goodName != null and item.goodName != '' ">
                good_name,
            </if>
            <if test="item.goodPrice != null and item.goodPrice != '' ">
                good_price,
            </if>
            <if test="item.goodType != null and item.goodType != '' ">
                good_type,
            </if>
            <if test="item.coverImgUrl != null and item.coverImgUrl != '' ">
                cover_img_url,
            </if>
            <if test="item.content != null and item.content != '' ">
                content,
            </if>
            creation_time
        </trim>
        values
        <trim prefix="("  suffix=")" suffixOverrides=",">
            <if test="item.id != null and item.id != '' ">
                #{item.id},
            </if>
            <if test="item.goodName != null and item.goodName != '' ">
                #{item.goodName},
            </if>
            <if test="item.goodPrice != null and item.goodPrice != '' ">
                #{item.goodPrice},
            </if>
            <if test="item.goodType != null and item.goodType != '' ">
                #{item.goodType},
            </if>
            <if test="item.coverImgUrl != null and item.coverImgUrl != '' ">
                #{item.coverImgUrl},
            </if>
            <if test="item.content != null and item.content != '' ">
                #{item.content},
            </if>
            sysdate()
        </trim>
    </insert>

    <update id="editData">
        update jinhui_shopping
        <set>
            <if test="item.id != null and item.id != '' ">
                id=#{item.id},
            </if>
            <if test="item.goodName != null and item.goodName != '' ">
                good_name=#{item.goodName},
            </if>
            <if test="item.goodPrice != null and item.goodPrice != '' ">
                good_price=#{item.goodPrice},
            </if>
            <if test="item.goodType != null and item.goodType != '' ">
                good_type=#{item.goodType},
            </if>
            <if test="item.coverImgUrl != null and item.coverImgUrl != '' ">
                cover_img_url=#{item.coverImgUrl},
            </if>
            <if test="item.content != null and item.content != '' ">
                content=#{item.content},
            </if>
            update_time=sysdate()
        </set>
        where id = #{item.id}
    </update>

    <delete id="expurgateData" parameterType="String">
        delete from jinhui_shopping where id=#{id}
    </delete>

</mapper>