意见建议

zhangzeli

2021-11-09 6781628db9ee02f57dffc5cd5aba7a9f109ee246

意见建议

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SuggestController.java

New file
@@ -0,0 +1,77 @@
package cn.exrick.xboot.your.controller;

import cn.exrick.xboot.core.common.utils.PageUtil;
import cn.exrick.xboot.core.common.utils.ResultUtil;
import cn.exrick.xboot.core.common.vo.PageVo;
import cn.exrick.xboot.core.common.vo.Result;
import cn.exrick.xboot.your.entity.Suggest;
import cn.exrick.xboot.your.service.ISuggestService;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @author zhangzeli
 */
@Slf4j
@RestController
@Api(tags = "意见建议管理接口")
@RequestMapping("/xboot/suggest")
@Transactional
public class SuggestController {

    @Autowired
    private ISuggestService iSuggestService;

    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
    @ApiOperation(value = "通过id获取")
    public Result<Suggest> get(@PathVariable String id) {

        Suggest suggest = iSuggestService.getById(id);
        return new ResultUtil<Suggest>().setData(suggest);
    }

    @RequestMapping(value = "/getAll", method = RequestMethod.GET)
    @ApiOperation(value = "获取全部数据")
    public Result<List<Suggest>> getAll() {

        List<Suggest> list = iSuggestService.list();
        return new ResultUtil<List<Suggest>>().setData(list);
    }

    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
    @ApiOperation(value = "分页获取")
    public Result<IPage<Suggest>> getByPage(PageVo page) {

        IPage<Suggest> data = iSuggestService.page(PageUtil.initMpPage(page));
        return new ResultUtil<IPage<Suggest>>().setData(data);
    }

    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
    @ApiOperation(value = "编辑或更新数据")
    public Result<Suggest> saveOrUpdate(Suggest suggest) {

        if (iSuggestService.saveOrUpdate(suggest)) {
            return new ResultUtil<Suggest>().setData(suggest);
        }
        return new ResultUtil<Suggest>().setErrorMsg("操作失败");
    }

    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
    @ApiOperation(value = "批量通过id删除")
    public Result<Object> delAllByIds(@RequestParam String[] ids) {

        for (String id : ids) {
            iSuggestService.removeById(id);
        }
        return ResultUtil.success("批量通过id删除数据成功");
    }
}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Suggest.java

New file
@@ -0,0 +1,43 @@
package cn.exrick.xboot.your.entity;

import cn.exrick.xboot.core.base.XbootBaseEntity;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Entity;
import javax.persistence.Table;
import java.util.Date;

/**
 * @author Exrick
 */
@Data
@Entity
@DynamicInsert
@DynamicUpdate
@Table(name = "t_suggest")
@TableName("t_suggest")
@ApiModel(value = "维修记录")
public class Suggest extends XbootBaseEntity {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "意见分类字典表id")
    private String dictDataId;

    @ApiModelProperty(value = "内容")
    private String content;

    @ApiModelProperty(value = "商户ID")
    private String customerId;

    @ApiModelProperty(value = "司机或随车员id")
    private String userId;

}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/SuggestMapper.java

New file
@@ -0,0 +1,26 @@
package cn.exrick.xboot.your.mapper;

import cn.exrick.xboot.your.entity.CustomerReceive;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.exrick.xboot.your.entity.Suggest;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.type.JdbcType;

import java.util.List;

/**
 * 意见建议数据处理层
 * @author zhangzeli
 */
public interface SuggestMapper extends BaseMapper<Suggest> {
    @Select("SELECT a.*,b.name as temp FROM t_customer_receive a LEFT JOIN t_customer b ON a.customer_id=b.id ${ew.customSqlSegment} ORDER BY a.status ASC,a.create_time DESC")
    @Results({@Result(column="temp", property="customerName", jdbcType = JdbcType.VARCHAR)})
    IPage<CustomerReceive> page2(Page initMpPage, @Param(Constants.WRAPPER) QueryWrapper<CustomerReceive> wrapper);
}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/ISuggestService.java

New file
@@ -0,0 +1,18 @@
package cn.exrick.xboot.your.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import cn.exrick.xboot.your.entity.Suggest;

import java.util.List;

/**
 * 意见建议接口
 * @author zhangzeli
 */
public interface ISuggestService extends IService<Suggest> {

    IPage<Suggest> page2(Page initMpPage, QueryWrapper<Suggest> wrapper);
}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ISuggestServiceImpl.java

New file
@@ -0,0 +1,34 @@
package cn.exrick.xboot.your.serviceimpl;

import cn.exrick.xboot.your.mapper.SuggestMapper;
import cn.exrick.xboot.your.entity.Suggest;
import cn.exrick.xboot.your.service.ISuggestService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.List;

/**
 * 意见建议接口实现
 * @author zhangzeli
 */
@Slf4j
@Service
@Transactional
public class ISuggestServiceImpl extends ServiceImpl<SuggestMapper, Suggest> implements ISuggestService {

    @Autowired
    private SuggestMapper suggestMapper;

    @Override
    public IPage<Suggest> page2(Page initMpPage, QueryWrapper<Suggest> wrapper) {
        return null;
    }
}