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.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 io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import org.apache.commons.io.IOUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.bind.annotation.*;
|
import sun.nio.ch.IOUtil;
|
|
import javax.annotation.Resource;
|
import java.io.Serializable;
|
import java.sql.SQLException;
|
import java.util.List;
|
|
/**
|
* 资讯表(NewsInformation)表控制层
|
*
|
* @author makejava
|
* @since 2022-11-17 11:38:27
|
*/
|
@RestController
|
@RequestMapping("newsInformation")
|
@Api(tags = "资讯管理")
|
public class NewsInformationController extends ApiController {
|
/**
|
* 服务对象
|
*/
|
@Resource
|
private NewsInformationService newsInformationService;
|
|
@Autowired
|
private NewsPoliceService policeService;
|
|
@Autowired
|
private NewsInformationPoliceService newsInformationPoliceService;
|
|
@Autowired
|
private NewsColumnInformationService newsColumnInformationService;
|
/**
|
* 分页查询所有数据
|
*
|
* @return 所有数据
|
*/
|
@GetMapping
|
@ApiOperation(value = "查询所有数据")
|
public R selectAll() {
|
return success(this.newsInformationService.selectAllInformation());
|
|
}
|
|
/**
|
* 通过主键查询单条数据
|
*
|
* @param id 主键
|
* @return 单条数据
|
*/
|
@GetMapping("{id}")
|
@ApiOperation(value = "按id查询数据")
|
public R selectOne(@PathVariable Integer id) {
|
return success(this.newsInformationService.selectInformationById(id));
|
}
|
|
/**
|
* 新增数据
|
*
|
* @param newsInformation 实体对象
|
* @return 新增结果
|
*/
|
@Transactional(rollbackFor = SQLException.class)
|
@PostMapping
|
@ApiOperation(value = "新增数据")
|
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
|
@ApiOperation(value = "修改数据")
|
@Transactional
|
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.updateInformationById(newsInformation));
|
return success(this.newsInformationService.updateInformationById(newsInformation));
|
}
|
|
/**
|
* 删除数据
|
*
|
* @param idList 主键结合
|
* @return 删除结果
|
*/
|
@DeleteMapping
|
@ApiOperation(value = "删除数据")
|
public R delete(@RequestParam("idList") List<Long> idList) {
|
if (idList==null||idList.size()==0){
|
return failed("请选择一个刹车农户对象");
|
}
|
for (long id:idList){
|
newsColumnInformationService.remove(new QueryWrapper<NewsColumnInformation>().eq("information_id",id));
|
}
|
return success(this.newsInformationService.removeByIds(idList));
|
}
|
}
|
|
