package com.ycl.controller;
|
|
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.api.ApiController;
|
import com.baomidou.mybatisplus.extension.api.R;
|
import com.baomidou.mybatisplus.extension.conditions.query.QueryChainWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ycl.entity.NewsColumnInformation;
|
import com.ycl.entity.NewsInformation;
|
import com.ycl.entity.NewsInformationPolice;
|
import com.ycl.entity.NewsPolice;
|
import com.ycl.service.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.annotation.Resource;
|
import java.io.Serializable;
|
import java.sql.SQLException;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* 资讯表(NewsInformation)表控制层
|
*
|
* @author makejava
|
* @since 2022-11-17 11:38:27
|
*/
|
@RestController
|
@RequestMapping("newsInformation")
|
public class NewsInformationController extends ApiController {
|
/**
|
* 服务对象
|
*/
|
@Resource
|
private NewsInformationService newsInformationService;
|
|
@Autowired
|
private NewsPoliceService policeService;
|
|
@Autowired
|
private NewsInformationPoliceService newsInformationPoliceService;
|
|
@Autowired
|
private NewsColumnInformationService newsColumnInformationService;
|
/**
|
* 分页查询所有数据
|
*
|
* @param page 分页对象
|
* @param newsInformation 查询实体
|
* @return 所有数据
|
*/
|
@GetMapping
|
public R selectAll(Page<NewsInformation> page, NewsInformation newsInformation) {
|
return success(this.newsInformationService.page(page, new QueryWrapper<>(newsInformation).orderByDesc("publish_time")));
|
}
|
|
/**
|
* 通过主键查询单条数据
|
*
|
* @param id 主键
|
* @return 单条数据
|
*/
|
@GetMapping("{id}")
|
public R selectOne(@PathVariable Serializable id) {
|
return success(this.newsInformationService.getById(id));
|
}
|
|
/**
|
* 新增数据
|
*
|
* @param newsInformation 实体对象
|
* @return 新增结果
|
*/
|
@Transactional(rollbackFor = SQLException.class)
|
@PostMapping
|
public R insert(@RequestBody NewsInformation newsInformation) {
|
Integer saveResult = this.newsInformationService.insertOneInformation(newsInformation);
|
Integer informationId=newsInformation.getId();
|
if (newsInformation.getIsSign()==0){
|
List<String> departmentIds = newsInformation.getDepartmentId();
|
for (String departmentId:departmentIds){
|
QueryWrapper<NewsPolice> wrapper = new QueryWrapper();
|
wrapper.eq("news_department_id",departmentId);
|
List<NewsPolice> list = policeService.list(wrapper);
|
if (!list.isEmpty()){
|
for (NewsPolice newsPolice:list){
|
newsInformationPoliceService.save(NewsInformationPolice.builder().newsPoliceId(newsPolice.getId()).newsInformationId(informationId).isSign(0).build());
|
}
|
}
|
}
|
}
|
|
for (String columnId:newsInformation.getColumnId()){
|
newsColumnInformationService.save(NewsColumnInformation.builder().columnId(Integer.parseInt(columnId)).informationId(informationId).build());
|
}
|
return success(saveResult);
|
}
|
|
/**
|
* 修改数据
|
*
|
* @param newsInformation 实体对象
|
* @return 修改结果
|
*/
|
@PutMapping
|
public R update(@RequestBody NewsInformation newsInformation) {
|
Integer informationId = newsInformation.getId();
|
if (newsInformation.getIsSign()==0){
|
newsInformationPoliceService.remove(new QueryWrapper<NewsInformationPolice>().eq("news_information_id",informationId));
|
List<String> departmentIds = newsInformation.getDepartmentId();
|
for (String departmentId:departmentIds){
|
QueryWrapper<NewsPolice> wrapper = new QueryWrapper();
|
wrapper.eq("news_department_id",departmentId);
|
List<NewsPolice> list = policeService.list(wrapper);
|
if (!list.isEmpty()){
|
for (NewsPolice newsPolice:list){
|
newsInformationPoliceService.save(NewsInformationPolice.builder().newsPoliceId(newsPolice.getId()).newsInformationId(informationId).isSign(0).build());
|
}
|
}
|
}
|
}
|
newsColumnInformationService.remove(new QueryWrapper<NewsColumnInformation>().eq("information_id",informationId));
|
for (String columnId:newsInformation.getColumnId()){
|
newsColumnInformationService.save(NewsColumnInformation.builder().columnId(Integer.parseInt(columnId)).informationId(informationId).build());
|
}
|
return success(this.newsInformationService.updateById(newsInformation));
|
}
|
|
/**
|
* 删除数据
|
*
|
* @param idList 主键结合
|
* @return 删除结果
|
*/
|
@DeleteMapping
|
public R delete(@RequestParam("idList") List<Long> idList) {
|
return success(this.newsInformationService.removeByIds(idList));
|
}
|
}
|
|
