package org.springblade.modules.workreport.controller;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import lombok.AllArgsConstructor;
|
import org.springblade.common.utils.arg;
|
import org.springblade.core.mp.support.Condition;
|
import org.springblade.core.mp.support.Query;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.utils.Func;
|
import org.springblade.modules.FTP.FtpUtil;
|
import org.springblade.modules.system.entity.Dept;
|
import org.springblade.modules.system.entity.User;
|
import org.springblade.modules.system.service.IDeptService;
|
import org.springblade.modules.system.service.IUserService;
|
import org.springblade.modules.workreport.entity.WorkReport;
|
import org.springblade.modules.workreport.service.WorkReportService;
|
import org.springblade.modules.workreport.vo.WorkReportVo;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.sql.Wrapper;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* @author zhongrj
|
* @time 2021-07-12
|
* @desc 工作汇报管理控制层
|
*/
|
@RestController
|
@AllArgsConstructor
|
@RequestMapping("/workReport")
|
public class WorkReportController {
|
|
private final WorkReportService workReportService;
|
|
private final IUserService userService;
|
|
private final IDeptService deptService;
|
|
/**
|
* 自定义分页
|
* @param query page,size
|
* @param workReport 工作汇报信息对象
|
*/
|
@GetMapping("/page")
|
public R<IPage<WorkReportVo>> page(WorkReportVo workReport, Query query) {
|
IPage<WorkReportVo> pages = workReportService.selectWorkReportPage(Condition.getPage(query), workReport);
|
List<WorkReportVo> records = pages.getRecords();
|
for (WorkReportVo record : records) {
|
record.setReplyRealName(getReplyRealName(record));
|
record.setReplyDeptName(getReplyDeptName(record));
|
}
|
return R.data(pages);
|
}
|
|
|
/**
|
* 自定义分页--接收到的汇报信息page
|
* @param query page,size
|
* @param workReport 工作汇报信息对象
|
*/
|
@GetMapping("/pageReply")
|
public R<IPage<WorkReportVo>> pageReply(WorkReportVo workReport, Query query) {
|
IPage<WorkReportVo> pages = workReportService.selectWorkReplyPage(Condition.getPage(query), workReport);
|
return R.data(pages);
|
}
|
|
/**
|
* 新增
|
* @param workReport 工作汇报信息对象
|
*/
|
@PostMapping("/save")
|
@ApiOperation(value = "新增", notes = "传入workReport")
|
public R save(@RequestBody WorkReport workReport) {
|
return R.status(workReportService.save(workReport));
|
}
|
|
/**
|
* 修改
|
* @param workReport 工作汇报信息对象
|
*/
|
@PostMapping("/update")
|
public R update(@RequestBody WorkReport workReport) {
|
return R.status(workReportService.updateById(workReport));
|
}
|
|
/**
|
* 新增或修改
|
* @param workReport 工作汇报信息对象
|
*/
|
@PostMapping("/submit")
|
public R submit(@RequestBody WorkReport workReport){
|
boolean status = false;
|
if (null==workReport.getId()){
|
workReport.setReportTime(new Date());
|
workReport.setReplyDeptIds(getReplyDeptIds(workReport.getReceivedIds()));
|
//新增
|
status = workReportService.save(workReport);
|
|
//数据同步
|
String s1 =
|
"insert into sys_work_report(id,type,content,work_desc,report_time,received_ids,dept_id,reply_dept_ids,category,user_id) " +
|
"values(" + "'" + workReport.getId() + "'" + "," +
|
"'" + workReport.getType() + "'" + "," +
|
"'" + workReport.getContent() + "'" + "," +
|
"'" + workReport.getWorkDesc() + "'" + "," +
|
"'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(workReport.getReportTime()) + "'" + "," +
|
"'" + workReport.getReceivedIds() + "'" + "," +
|
"'" + workReport.getDeptId() + "'" + "," +
|
"'" + workReport.getReplyDeptIds() + "'" + "," +
|
"'" + workReport.getCategory() + "'" + "," +
|
"'" +workReport.getUserId() + "'" + ")";
|
FtpUtil.sqlFileUpload(s1);
|
}else {
|
workReport.setReplyDeptIds(getReplyDeptIds(workReport.getReceivedIds()));
|
if (null==workReport.getReplyTime()){
|
workReport.setReplyTime(new Date());
|
}
|
|
//修改
|
status = workReportService.updateById(workReport);
|
|
//内网同步
|
String s1 =
|
"update sys_work_report set type = " + "'" + workReport.getType() + "'" +
|
",content = " + "'" + workReport.getContent() + "'" +
|
",work_desc = " + "'" + workReport.getWorkDesc() + "'" +
|
",received_ids = " + "'" + workReport.getReceivedIds() + "'" +
|
",reply_content = " + "'" + workReport.getReplyContent() + "'" +
|
",reply_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(workReport.getReplyTime()) + "'" +
|
",dept_id = " + "'" + workReport.getDeptId() + "'" +
|
",reply_dept_ids = " + "'" + workReport.getReplyDeptIds() + "'" +
|
",category = " + "'" + workReport.getCategory() + "'" +
|
",user_id = " + "'" + workReport.getUserId() + "'" +
|
" " +"where id = " + "'" + workReport.getId() + "'";
|
FtpUtil.sqlFileUpload(s1);
|
}
|
return R.status(status);
|
}
|
|
/**
|
* 删除
|
* @param ids 工作汇报信息ids 数组
|
*/
|
@PostMapping("/remove")
|
public R remove(@ApiParam(value = "主键集合") @RequestParam String ids) {
|
//内网删除
|
List<Long> list = Func.toLongList(ids);
|
list.forEach(id ->{
|
//内网同步
|
String s1 = "delete from sys_work_report where id = " + "'" + id + "'";
|
FtpUtil.sqlFileUpload(s1);
|
});
|
return R.status(workReportService.removeByIds(Func.toLongList(ids)));
|
}
|
|
/**
|
* 详情
|
* @param workReport 工作汇报信息对象
|
*/
|
@GetMapping("/detail")
|
@ApiOperation(value = "详情", notes = "传入workReport")
|
public R<WorkReportVo> detail(WorkReport workReport) {
|
//查询工作汇报详情
|
WorkReportVo detail = workReportService.selectWorkReportInfo(workReport);
|
detail.setReplyRealName(getReplyRealName(detail));
|
detail.setReplyDeptName(getReplyDeptName(detail));
|
//查询接收人单位（名称）信息
|
return R.data(detail);
|
}
|
|
/**
|
* 获取接收人的单位信息
|
* @param detail 汇报详情
|
* @return
|
*/
|
private String getReplyDeptName(WorkReportVo detail) {
|
|
if (null!=detail.getReplyDeptIds() && detail.getReplyDeptIds()!="" && !detail.getReplyDeptIds().isEmpty()) {
|
List<String> replyDeptIds = Arrays.asList(detail.getReplyDeptIds().split(","));
|
StringBuilder replyDeptNameInfo = new StringBuilder();
|
if (replyDeptIds.size()>0) {
|
for (String deptId : replyDeptIds) {
|
//查询接收人单位信息
|
Dept deptDetail = deptService.getById(Long.parseLong(deptId));
|
if (null!= deptDetail) {
|
replyDeptNameInfo = replyDeptNameInfo.append(deptDetail.getDeptName()).append(",");
|
}
|
}
|
if (replyDeptNameInfo.length()>0) {
|
//截取
|
return replyDeptNameInfo.substring(0, replyDeptNameInfo.length() - 1);
|
}
|
}
|
}
|
return null;
|
}
|
|
/**
|
* 获取接收人的单位id(dept)信息
|
* @param
|
* @return
|
*/
|
private String getReplyDeptIds(String detail) {
|
List<String> userIds = Arrays.asList(detail.split(","));
|
List<String> list = new ArrayList<>();
|
for (String userId : userIds) {
|
//查询接收人单位信息
|
User userDetail = userService.getById(userId);
|
if (null!=userDetail){
|
list.add(userDetail.getDeptId());
|
}
|
}
|
//去重
|
List<String> collect = list.stream().distinct().collect(Collectors.toList());
|
//截取
|
return String.join(",",collect);
|
}
|
|
/**
|
* 查询接收人姓名信息
|
*
|
* @param detail 汇报详情
|
* @return
|
*/
|
private String getReplyRealName(WorkReportVo detail){
|
List<String> userIds = Arrays.asList(detail.getReceivedIds().split(","));
|
StringBuilder replyRealNameInfo = new StringBuilder();
|
for (String userId : userIds) {
|
//查询接收人姓名信息
|
// User user = new User();
|
// user.setCardid(idCardNo);
|
// User userDetail = userService.getOne(Condition.getQueryWrapper(user));
|
User userDetail = userService.getById(userId);
|
if(null!=userDetail) {
|
replyRealNameInfo = replyRealNameInfo.append(userDetail.getRealName()).append(",");
|
}
|
|
}
|
//截取
|
if (replyRealNameInfo.toString().length()>0) {
|
return replyRealNameInfo.substring(0, replyRealNameInfo.length() - 1);
|
}
|
return null;
|
}
|
|
}
|
