模块管理员功能

到了我们的大熊猫国家公园的最后的一次迭代任务了，我需要做的是管理员的模块，需要的功能是人工的文章审核，文章的查询。那么思路其实也很明确了，首先我们先创建好pojo类。然后也是老样子，写Mapper和Service，我们的思路就是从数据库中获取待审核文章的list，文章待审核的话会有一个Review属性为1，我们直接就使用查询语句来写，大概得操作语句如下：

文章类：

package panda.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;

import java.util.Date;
import java.util.List;

@TableName("tb_article")
public class Article {

    @TableId(type = IdType.AUTO)
    private Integer fid;

    private Integer uid;

    private String username;

    private String userProfilePhoto;

    private String title;

    private String context;

    private Integer process;

    private Integer ban;

    private String releaseAddress;

    @TableField(select = false)
    private List<ArticleResource> resources;

    private Date releaseTime;

    private Integer resourceNum;

    private Integer complete;

    private Integer draft;

    public Integer getResourceNum() {
        return resourceNum;
    }

    @Override
    public String toString() {
        return "Article{" +
                "fid=" + fid +
                ", uid=" + uid +
                ", username='" + username + '\'' +
                ", userProfilePhoto='" + userProfilePhoto + '\'' +
                ", title='" + title + '\'' +
                ", context='" + context + '\'' +
                ", process=" + process +
                ", ban=" + ban +
                ", releaseAddress='" + releaseAddress + '\'' +
                ", resources=" + resources +
                ", releaseTime=" + releaseTime +
                ", resourceNum=" + resourceNum +
                ", complete=" + complete +
                ", draft=" + draft +
                '}';
    }

    public Integer getDraft() {
        return draft;
    }

    public void setDraft(Integer draft) {
        this.draft = draft;
    }

    public void setResourceNum(Integer resourceNum) {
        this.resourceNum = resourceNum;
    }

    public Integer getComplete() {
        return complete;
    }

    public void setComplete(Integer complete) {
        this.complete = complete;
    }

    public Integer getFid() {
        return fid;
    }

    public void setFid(Integer fid) {
        this.fid = fid;
    }

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getUserProfilePhoto() {
        return userProfilePhoto;
    }

    public void setUserProfilePhoto(String userProfilePhoto) {
        this.userProfilePhoto = userProfilePhoto;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getContext() {
        return context;
    }

    public void setContext(String context) {
        this.context = context;
    }

    public Integer getProcess() {
        return process;
    }

    public void setProcess(Integer process) {
        this.process = process;
    }

    public Integer getBan() {
        return ban;
    }

    public void setBan(Integer ban) {
        this.ban = ban;
    }

    public String getReleaseAddress() {
        return releaseAddress;
    }

    public void setReleaseAddress(String releaseAddress) {
        this.releaseAddress = releaseAddress;
    }

    public List<ArticleResource> getResources() {
        return resources;
    }

    public void setResources(List<ArticleResource> resources) {
        this.resources = resources;
    }

    public Date getReleaseTime() {
        return releaseTime;
    }

    public void setReleaseTime(Date releaseTime) {
        this.releaseTime = releaseTime;
    }
}

Service类

package panda.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.stereotype.Service;
import panda.mapper.ArticleMapper;
import panda.pojo.Article;
import panda.service.AuditService;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author Kate
 * @date 2023/6/24 09:59
 * 概述:
 * 1、
 */
@Service
public class AuditServiceImpl implements AuditService {

    @Resource
    ArticleMapper articleMapper;

    @Override
    public List<Article> list(Integer offset){
        return articleMapper.listForAudit(offset);
    }


}

Controller类

package panda.controller;

import commonapi.util.CommonResult;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import panda.pojo.Article;
import panda.service.AuditService;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * @author Kate
 * @date 2023/6/24 09:44
 * 概述:
 * 1、
 */
@RestController
@RequestMapping("/audit")
public class AuditController {

    @Resource
    AuditService auditService;

    @GetMapping("/list/{offset}")
    public CommonResult list(HttpServletRequest request, @PathVariable Integer offset){
        List<Article> list = auditService.list(offset);
        return CommonResult.success().data("list",list);
    }


}

大概就实现了管理员的功能了。