ProgramController.java
4.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
package com.hui.iqiyi.controller;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hui.iqiyi.Util.ReturnBean;
import com.hui.iqiyi.entity.Content;
import com.hui.iqiyi.entity.Program;
import com.hui.iqiyi.excel.jlSheetExcel;
import com.hui.iqiyi.excel.jujiExecl;
import com.hui.iqiyi.request.*;
import com.hui.iqiyi.response.*;
import com.hui.iqiyi.service.IContentService;
import com.hui.iqiyi.service.IProgramService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.List;
/**
* <p>
* 前端控制器
* </p>
*
* @author jobob
* @since 2021-06-03
*/
@Api(tags = "添加关注")
@RestController
@RequestMapping("/iqiyi/program")
public class ProgramController {
@Resource
private IProgramService iProgramService;
@Autowired
private IContentService iContentService;
@PostMapping("/addFollow")
@ApiOperation("添加关注")
public ReturnBean addFollow(@RequestBody List<ByIdsRequest> requests) {
return iProgramService.updateByProgramIds(requests);
}
// @PostMapping("/selectFollow")
// @ApiOperation("查看关注")
// public Object selectProMov(@RequestBody String platFormInfo, int PageNo, int PageSize) {
// return iProgramService.selectProMov(new Program().setPlatformInfo(platFormInfo), PageNo, PageSize);
// }
// @GetMapping("/selectAllSingle")
// @ApiOperation("查询单集")
// @ResponseBody
// public PageInfo<ProgramResponse> selectAllSingle(ProgramRequest request) {
// PageHelper.startPage(request.getPageNo(), request.getPageSize());
// return new PageInfo(iProgramService.selectProgramDloadList(request));
// }
@GetMapping("/selectAllSeven")
@ApiOperation("近七日下载情况")
@ResponseBody
public List<ProgramXRespone> selectAllSeven(ProRequest proRequest) {
return iProgramService.selectAllSeven(proRequest);
}
//
// @GetMapping("/selectAllProgramCount")
// @ApiOperation("关注平台数据")
// @ResponseBody
// public ProgramSyResponse selectAllProgramCount() {
// return iProgramService.selectAllProgramCount();
// }
@GetMapping("/selectAllmonolithic")
@ApiOperation("查询全部单片信息")
@ResponseBody
public PageInfo<Program> selectAllIqIy(ContentRequest contentRequest) {
PageHelper.startPage(contentRequest.getPageNo(), contentRequest.getPageSize());
return new PageInfo(iProgramService.selectAllProgra(contentRequest));
}
@GetMapping("/selectAllExcel")
@ApiOperation("导出关注单片信息")
@ResponseBody
public void selectAllExcel() {
try {
String path = "D:\\java\\吉林关注剧集片单.xlsx\\";
//新建ExcelWriter
ExcelWriter excelWriter = EasyExcel.write(path).build();
//获取sheet0对象
WriteSheet mainSheet = EasyExcel.writerSheet(0, "吉林关注单片").head(jlSheetExcel.class).build();
//向sheet0写入数据 传入空list这样只导出表头
excelWriter.write(iProgramService.selectAllExcel(), mainSheet);
//新建ExcelWriter
ExcelWriter excelWriter1 = EasyExcel.write(path).build();
//获取sheet0对象
WriteSheet mainSheet1 = EasyExcel.writerSheet(1, "吉林关注剧集").head(jujiExecl.class).build();
//向sheet0写入数据 传入空list这样只导出表头
excelWriter.write(iContentService.selectAllDramaExcel(), mainSheet1);
//关闭流
excelWriter.finish();
} catch (Exception e) {
System.out.println("导出异常" + e.getMessage());
}
}
@GetMapping("/selectAllmonolithicsss")
@ApiOperation("查询全部单片ss")
@ResponseBody
public List<ProgramExcelRequest> selectAllIqIy11() {
return iProgramService.selectAllExcel();
}
}