| | |
|---|
| | | 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.NewsInformation; |
|---|
| | | import com.ycl.service.NewsInformationService; |
|---|
| | | import org.springframework.web.bind.annotation.*; |
|---|
| | | |
|---|
| | | import javax.annotation.Resource; |
|---|
| | | import java.io.Serializable; |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 咨询表(NewsInformation)表控制层 |
|---|
| | | * |
|---|
| | | * @author makejava |
|---|
| | | * @since 2022-11-16 16:52:30 |
|---|
| | | */ |
|---|
| | | @RestController |
|---|
| | | @RequestMapping("newsInformation") |
|---|
| | | public class NewsInformationController extends ApiController { |
|---|
| | | /** |
|---|
| | | * 服务对象 |
|---|
| | | */ |
|---|
| | | @Resource |
|---|
| | | private NewsInformationService newsInformationService; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 分页查询所有数据 |
|---|
| | | * |
|---|
| | | * @param page 分页对象 |
|---|
| | | * @param newsInformation 查询实体 |
|---|
| | | * @return 所有数据 |
|---|
| | | */ |
|---|
| | | @GetMapping |
|---|
| | | public R selectAll(Page<NewsInformation> page, NewsInformation newsInformation) { |
|---|
| | | return success(this.newsInformationService.page(page, new QueryWrapper<>(newsInformation))); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 通过主键查询单条数据 |
|---|
| | | * |
|---|
| | | * @param id 主键 |
|---|
| | | * @return 单条数据 |
|---|
| | | */ |
|---|
| | | @GetMapping("{id}") |
|---|
| | | public R selectOne(@PathVariable Serializable id) { |
|---|
| | | return success(this.newsInformationService.getById(id)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 新增数据 |
|---|
| | | * |
|---|
| | | * @param newsInformation 实体对象 |
|---|
| | | * @return 新增结果 |
|---|
| | | */ |
|---|
| | | @PostMapping |
|---|
| | | public R insert(@RequestBody NewsInformation newsInformation) { |
|---|
| | | return success(this.newsInformationService.save(newsInformation)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 修改数据 |
|---|
| | | * |
|---|
| | | * @param newsInformation 实体对象 |
|---|
| | | * @return 修改结果 |
|---|
| | | */ |
|---|
| | | @PutMapping |
|---|
| | | public R update(@RequestBody NewsInformation newsInformation) { |
|---|
| | | return success(this.newsInformationService.updateById(newsInformation)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 删除数据 |
|---|
| | | * |
|---|
| | | * @param idList 主键结合 |
|---|
| | | * @return 删除结果 |
|---|
| | | */ |
|---|
| | | @DeleteMapping |
|---|
| | | public R delete(@RequestParam("idList") List<Long> idList) { |
|---|
| | | return success(this.newsInformationService.removeByIds(idList)); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | 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));
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
