package com.huajun.pageoffice.controller;
import com.alibaba.fastjson.JSON;
import com.huajun.common.core.domain.R;
import com.huajun.common.core.utils.DateUtils;
import com.huajun.common.core.utils.IdUtils;
import com.huajun.common.core.utils.SecurityUtils;
import com.huajun.common.core.utils.StringUtils;
import com.huajun.common.core.web.domain.AjaxResult;
import com.huajun.common.core.web.page.TableDataInfo;
import com.huajun.duty.api.RemoteDutyReportService;
import com.huajun.duty.api.domain.DutyReport;
import com.huajun.event.api.RemoteEventPlanSelectedService;
import com.huajun.event.api.RemoteEventService;
import com.huajun.event.api.RemoteEvnMaterialScheduleService;
import com.huajun.event.api.RemoteEvnTeamScheduleService;
import com.huajun.event.api.domain.EvnMaterialSchedule;
import com.huajun.pageoffice.config.PageofficeConfig;
import com.huajun.system.api.*;
import com.huajun.system.api.domain.SysFile;
import com.huajun.system.api.domain.SysFileInfo;
import com.huajun.system.api.domain.SysTemplate;
import com.zhuozhengsoft.pageoffice.*;
import com.zhuozhengsoft.pageoffice.wordwriter.DataRegion;
import com.zhuozhengsoft.pageoffice.wordwriter.Table;
import com.zhuozhengsoft.pageoffice.wordwriter.WdAutoFitBehavior;
import com.zhuozhengsoft.pageoffice.wordwriter.WordDocument;
import org.apache.http.util.TextUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.http.ResponseEntity;
import org.springframework.mock.web.MockMultipartFile;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import com.huajun.event.api.domain.EvnPlanSelected;
import com.huajun.system.api.domain.SysDictData;
import com.huajun.event.api.domain.EvnEvent;
import com.huajun.common.core.domain.R;
/**
* @author yangwt
*/
@RestController
public class PageofficeController {
@Autowired
private PageofficeConfig pageofficeConfig;
@Autowired
private RemoteFileService remoteFileService;
@Autowired
private RemoteFileInfoService fileInfoService;
@Autowired
private RemoteTemplateService templateService;
@Autowired
private RemoteDutyReportService dutyReportService;
@Autowired
private RemoteEventService remoteEventService;
@Autowired
RemoteEventPlanSelectedService remoteEventPlanSelectedService;
@Autowired
RemoteCategoryService remoteCategoryService;
@Autowired
RemoteDictDataService remoteDictDataService;
@Autowired
RemoteEvnMaterialScheduleService remoteEvnMaterialScheduleService;
@Autowired
RemoteEvnTeamScheduleService remoteEvnTeamScheduleService;
/**
* 文件上传
*/
@RequestMapping("/save")
public void upload(HttpServletRequest request, HttpServletResponse response) {
FileSaver fs = new FileSaver(request, response);
try {
MultipartFile file = new MockMultipartFile(fs.getFileName(), fs.getFileName(), "application/octet-stream", fs.getFileStream());
remoteFileService.upload(file);
fs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 文件下载
*/
@RequestMapping("/download")
public Object download(String file) {
ResponseEntity<byte[]> entity = remoteFileService.download(file);
return entity;
}
@RequestMapping(value = "/word", method = RequestMethod.GET)
public ModelAndView showWord(HttpServletRequest request, Map<String, Object> map, String file) {
PageOfficeCtrl poCtrl = new PageOfficeCtrl(request);
// 加按钮
poCtrl.addCustomToolButton("保存", "Save", 1);//添加自定义保存按钮
poCtrl.addCustomToolButton("盖章", "AddSeal", 2);//添加自定义盖章按钮
poCtrl.addCustomToolButton("关闭并刷新父页面", "ClosePage", 21);//添加关闭按钮
poCtrl.setServerPage("/poserver.zz");//设置服务页面
poCtrl.setSaveFilePage("/save");//设置处理文件保存的请求方法
// 演示替换数据标签
WordDocument doc = new WordDocument();
doc.openDataRegion("PO_TITLE").setEditing(false);// 不可编辑
doc.openDataRegion("PO_TITLE").setValue("这是一个标题");// 设置值，可从前端传，可从接口中获取
poCtrl.setWriter(doc);
//打开word
poCtrl.webOpen("/download?file=" + file, OpenModeType.docAdmin, SecurityUtils.getNickname());
map.put("pageoffice", poCtrl.getHtmlCode("PageOfficeCtrl1"));
ModelAndView mv = new ModelAndView("Word");
return mv;
}
/**
* 模板编辑页面跳转
* <p>
* 为什么要在jsp页面传过来userName，而不是直接session获取呢？
* 因为本页面跳转，不需要登录，原因是为了适配谷歌等浏览器，因为谷歌浏览器打开本页面是用ie打开的，这时候该方法这时候就获取不到登录用户信息了
*
* @return
*/
@RequestMapping(value = "/goTemplateModel", method = RequestMethod.GET)
public ModelAndView goTemplateModel(HttpServletRequest request, Map<String, Object> map) {
String type = request.getParameter("type");
String mesId = request.getParameter("mesId");
String filePath = fileInfoService.filelist(mesId);
String eventId = request.getParameter("eventId");
//模板id ,调用模板库时，不能为空值；
String modelId = request.getParameter("modelId");
PageOfficeCtrl poCtrl = new PageOfficeCtrl(request);
// 隐藏菜单栏
poCtrl.setMenubar(false);
// 添加按钮
poCtrl.setTimeSlice(30);
poCtrl.addCustomToolButton("保存", "Save()", 1);
poCtrl.addCustomToolButton("打印", "PrintFile()", 6);
poCtrl.addCustomToolButton("全屏/还原", "IsFullScreen()", 4);
poCtrl.addCustomToolButton("关闭", "CloseFile()", 21);
poCtrl.setServerPage("poserver.zz");
poCtrl.setSaveFilePage("/saveTemplateModel?type=" + type + "&mesId=" + mesId);
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setCaption("模板编辑");
if (TextUtils.isEmpty(filePath)) {
// 新建
if (!TextUtils.isEmpty(modelId)) {
// 没有文件，打开模板
SysTemplate template = templateService.getDetail(type);
if (template.getId() != null) {
// 替换数据标签
WordDocument doc = new WordDocument();
SimpleDateFormat format = new SimpleDateFormat("YYYY-MM-dd");
switch (type) {
case "1"://值班报告
DutyReport report = dutyReportService.getDetail(mesId);
doc.openDataRegion("PO_ISSUENUM").setValue(report.getIssueNum() + "");
doc.openDataRegion("PO_ISSUENUM").setEditing(false);
doc.openDataRegion("PO_CALLEDTIME").setValue(format.format(report.getCreateTime()));
doc.openDataRegion("PO_CALLEDTIME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(report.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_DUTYER").setValue(report.getCreateName() + "");
doc.openDataRegion("PO_DUTYER").setEditing(false);
doc.openDataRegion("PO_SUBJECT").setValue(report.getTitle() + "");
doc.openDataRegion("PO_SUBJECT").setEditing(false);
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "2"://突发事件
DutyReport event = dutyReportService.getDetail(mesId);
doc.openDataRegion("PO_ISSUENUM").setValue(event.getIssueNum() + "");
doc.openDataRegion("PO_ISSUENUM").setEditing(false);
doc.openDataRegion("PO_DATE").setValue(format.format(event.getCreateTime()));
doc.openDataRegion("PO_DATE").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(event.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_REPORTORG").setValue(event.getReportUnitName() + "");
doc.openDataRegion("PO_REPORTORG").setEditing(false);
doc.openDataRegion("PO_REPORTER").setValue(event.getCreateName() + "");
doc.openDataRegion("PO_REPORTER").setEditing(false);
doc.openDataRegion("PO_TITLE").setValue(event.getTitle() + "");
doc.openDataRegion("PO_TITLE").setEditing(false);
doc.openDataRegion("PO_TEL").setValue("65655555");
doc.openDataRegion("PO_TEL").setEditing(false);
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "emergency_command_plan"://应急指挥方案
EvnEvent eventInfo = getEventInfo(eventId);
String planName = "";
EvnPlanSelected planSelected = getPlan(eventId);
if (planSelected != null) {
planName = Optional.ofNullable(planSelected.getPlanName()).orElse("");
doc.openDataRegion("PO_PLANNAME").setValue(planName + "");
doc.openDataRegion("PO_PLANNAME").setEditing(false);
}
String eventTypeName = "";
String eventType = String.valueOf(eventInfo.getEventType());//事件类型代码
if (eventType.equals("null") && StringUtils.isEmpty(eventType)) {
//doing nothing
} else {
eventTypeName = getCategory(eventType);
}
String dictName = "";
String eventGrade = String.valueOf(eventInfo.getEventGrade());//事件等级代码
if (eventGrade.equals("null") && StringUtils.isEmpty(eventGrade)) {
//doing nothing
} else {
dictName = getDictName("event_grade", eventGrade);
}
doc.openDataRegion("PO_NAME").setValue(eventInfo.getName() + "");
doc.openDataRegion("PO_NAME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(eventInfo.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_CONTACTS").setValue(eventInfo.getContacts() + "");
doc.openDataRegion("PO_CONTACTS").setEditing(false);
doc.openDataRegion("PO_EVENTTIME").setValue(DateUtils.dateTime(eventInfo.getEventTime()));
doc.openDataRegion("PO_EVENTTIME").setEditing(false);
doc.openDataRegion("PO_EVENTTYPE").setValue(eventTypeName + "");
doc.openDataRegion("PO_EVENTTYPE").setEditing(false);
doc.openDataRegion("PO_EVENTGRADE").setValue(dictName + "");
doc.openDataRegion("PO_EVENTGRADE").setEditing(false);
doc.openDataRegion("PO_ADDRESS").setValue(eventInfo.getAddress() + "");
doc.openDataRegion("PO_ADDRESS").setEditing(false);
doc.openDataRegion("PO_EVENTCAUSE").setValue(eventInfo.getEventCause() + "");
doc.openDataRegion("PO_EVENTCAUSE").setEditing(false);
DataRegion dataRegion = doc.openDataRegion("PO_TESTONE");
Table table = dataRegion.openTable(1); //index代表当前书签中table位置的索引，从1开始
table.openCellRC(2, 1).setValue("A公司");//openCellRC(行, 列)，索引从1开始
table.openCellRC(2, 2).setValue("开发部");
table.openCellRC(2, 3).setValue("李清");
table.openCellRC(2, 4).setValue("于吉利");
//插入一行，insertRowAfter方法中的参数代表在哪个单元格下面插入一个空行
table.insertRowAfter(table.openCellRC(2, 4));
table.openCellRC(3, 1).setValue("B公司");
table.openCellRC(3, 2).setValue("销售部");
table.openCellRC(3, 3).setValue("张三丰");
table.openCellRC(3, 4).setValue("李清照");
// Table table1 = doc.openDataRegion("PO_TESTONE").createTable(3, 4, WdAutoFitBehavior.wdAutoFitWindow);
// //给表格table1中剩余的单元格赋值
// for (int i = 1; i < 4; i++) {
// table1.openCellRC(i, 1).setValue("AA" + String.valueOf(i));
// table1.openCellRC(i, 2).setValue("BB" + String.valueOf(i));
// table1.openCellRC(i, 3).setValue("CC" + String.valueOf(i));
// table1.openCellRC(i, 4).setValue("DD" + String.valueOf(i));
// }
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "resource_guarantee_plan"://资源保障方案
EvnEvent eventInfoResource = getEventInfo(eventId);
String planNameResource = "";
EvnPlanSelected planSelectedResource = getPlan(eventId);
if (planSelectedResource != null) {
planNameResource = planSelectedResource.getPlanName();//得到预案名称
doc.openDataRegion("PO_PLANNAME").setValue(planNameResource + "");
doc.openDataRegion("PO_PLANNAME").setEditing(false);
}
String eventTypeNameResource = "";
String eventTypeResource = String.valueOf(eventInfoResource.getEventType());//事件类型代码
if (eventTypeResource.equals("null") && StringUtils.isEmpty(eventTypeResource)) {
//doing nothing
} else {
eventTypeNameResource = getCategory(eventTypeResource);
}
String dictNameResource = "";
String eventGradeResource = String.valueOf(eventInfoResource.getEventGrade());//事件等级代码
if (eventGradeResource.equals("null") && StringUtils.isEmpty(eventGradeResource)) {
//doing nothing
} else {
dictNameResource = getDictName("event_grade", eventGradeResource);
}
doc.openDataRegion("PO_NAME").setValue(eventInfoResource.getName() + "");
doc.openDataRegion("PO_NAME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(eventInfoResource.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_CONTACTS").setValue(eventInfoResource.getContacts() + "");
doc.openDataRegion("PO_CONTACTS").setEditing(false);
doc.openDataRegion("PO_EVENTTIME").setValue(DateUtils.dateTime(eventInfoResource.getEventTime()));
doc.openDataRegion("PO_EVENTTIME").setEditing(false);
doc.openDataRegion("PO_EVENTTYPE").setValue(eventTypeNameResource + "");
doc.openDataRegion("PO_EVENTTYPE").setEditing(false);
doc.openDataRegion("PO_EVENTGRADE").setValue(dictNameResource + "");
doc.openDataRegion("PO_EVENTGRADE").setEditing(false);
doc.openDataRegion("PO_ADDRESS").setValue(eventInfoResource.getAddress() + "");
doc.openDataRegion("PO_ADDRESS").setEditing(false);
doc.openDataRegion("PO_EVENTCAUSE").setValue(eventInfoResource.getEventCause() + "");
doc.openDataRegion("PO_EVENTCAUSE").setEditing(false);
//物资调度信息
TableDataInfo evnMaterial = remoteEvnMaterialScheduleService.list(eventId, "1", "10000");
if (evnMaterial != null && evnMaterial.getRows() != null && evnMaterial.getRows().size() > 0) {
List<EvnMaterialSchedule> listEvnMaterial = (List<EvnMaterialSchedule>) evnMaterial.getRows();
Table tableMaterial = doc.openDataRegion("PO_MATERIAL").createTable(listEvnMaterial.size(), 5, WdAutoFitBehavior.wdAutoFitWindow);
for (int i = 0; i < listEvnMaterial.size(); i++) {
EvnMaterialSchedule evnMaterialSchedule = JSON.parseObject(JSON.toJSONString(listEvnMaterial.get(i)), EvnMaterialSchedule.class);
tableMaterial.openCellRC(i, 1).setValue("AA" + String.valueOf(i));
tableMaterial.openCellRC(i, 2).setValue("BB" + String.valueOf(i));
tableMaterial.openCellRC(i, 3).setValue("CC" + String.valueOf(i));
tableMaterial.openCellRC(i, 4).setValue("DD" + String.valueOf(i));
tableMaterial.openCellRC(i, 5).setValue("ee" + String.valueOf(i));
}
} else {
//doing nothing
}
//队伍调度信息
TableDataInfo evnTeam = remoteEvnTeamScheduleService.list(eventId, "1", "10000");
if (evnTeam != null && evnTeam.getRows() != null && evnTeam.getRows().size() > 0) {
} else {
//doing nothing
}
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
break;
case "rescue_disposal_plan"://救援处置方案
EvnEvent eventInfoRescue = getEventInfo(eventId);
String planNameRescue = "";
EvnPlanSelected planSelectedRescue = getPlan(eventId);
if (planSelectedRescue != null) {
planNameRescue = planSelectedRescue.getPlanName();//得到预案名称
doc.openDataRegion("PO_PLANNAME").setValue(planNameRescue + "");
doc.openDataRegion("PO_PLANNAME").setEditing(false);
}
String eventTypeNameRescue = "";
String eventTypeRescue = String.valueOf(eventInfoRescue.getEventType());//事件类型代码
if (eventTypeRescue.equals("null") && StringUtils.isEmpty(eventTypeRescue)) {
//doing nothing
} else {
eventTypeNameRescue = getCategory(eventTypeRescue);
}
String dictNameRescue = "";
String eventGradeRescue = String.valueOf(eventInfoRescue.getEventGrade());//事件等级代码
if (eventGradeRescue.equals("null") && StringUtils.isEmpty(eventGradeRescue)) {
//doing nothing
} else {
dictNameRescue = getDictName("event_grade", eventGradeRescue);
}
doc.openDataRegion("PO_NAME").setValue(eventInfoRescue.getName() + "");
doc.openDataRegion("PO_NAME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(eventInfoRescue.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_CONTACTS").setValue(eventInfoRescue.getContacts() + "");
doc.openDataRegion("PO_CONTACTS").setEditing(false);
doc.openDataRegion("PO_EVENTTIME").setValue(DateUtils.dateTime(eventInfoRescue.getEventTime()));
doc.openDataRegion("PO_EVENTTIME").setEditing(false);
doc.openDataRegion("PO_EVENTTYPE").setValue(eventTypeNameRescue + "");
doc.openDataRegion("PO_EVENTTYPE").setEditing(false);
doc.openDataRegion("PO_EVENTGRADE").setValue(dictNameRescue + "");
doc.openDataRegion("PO_EVENTGRADE").setEditing(false);
doc.openDataRegion("PO_ADDRESS").setValue(eventInfoRescue.getAddress() + "");
doc.openDataRegion("PO_ADDRESS").setEditing(false);
doc.openDataRegion("PO_EVENTCAUSE").setValue(eventInfoRescue.getEventCause() + "");
doc.openDataRegion("PO_EVENTCAUSE").setEditing(false);
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "emergency_work_plan"://应急工作方案
EvnEvent eventInfoEmergency = getEventInfo(eventId);
String planNameEmergency = "";
EvnPlanSelected planSelectedEmergency = getPlan(eventId);
if (planSelectedEmergency != null) {
//得到预案名称
planNameEmergency = planSelectedEmergency.getPlanName();
doc.openDataRegion("PO_PLANNAME").setValue(planNameEmergency + "");
doc.openDataRegion("PO_PLANNAME").setEditing(false);
}
String eventTypeNameEmergency = "";
//事件类型代码
String eventTypeEmergency = String.valueOf(eventInfoEmergency.getEventType());
if (eventTypeEmergency.equals("null") && StringUtils.isEmpty(eventTypeEmergency)) {
//doing nothing
} else {
eventTypeNameEmergency = getCategory(eventTypeEmergency);
}
String dictNameEmergency = "";
String eventGradeEmergency = String.valueOf(eventInfoEmergency.getEventGrade());//事件等级代码
if (eventGradeEmergency.equals("null") && StringUtils.isEmpty(eventGradeEmergency)) {
//doing nothing
} else {
dictNameEmergency = getDictName("event_grade", eventGradeEmergency);
}
doc.openDataRegion("PO_PLANNAME").setValue(planNameEmergency + "");
doc.openDataRegion("PO_PLANNAME").setEditing(false);
doc.openDataRegion("PO_NAME").setValue(eventInfoEmergency.getName() + "");
doc.openDataRegion("PO_NAME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(eventInfoEmergency.getContent() + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_CONTACTS").setValue(eventInfoEmergency.getContacts() + "");
doc.openDataRegion("PO_CONTACTS").setEditing(false);
doc.openDataRegion("PO_EVENTTIME").setValue(DateUtils.dateTime(eventInfoEmergency.getEventTime()));
doc.openDataRegion("PO_EVENTTIME").setEditing(false);
doc.openDataRegion("PO_EVENTTYPE").setValue(eventTypeNameEmergency + "");
doc.openDataRegion("PO_EVENTTYPE").setEditing(false);
doc.openDataRegion("PO_EVENTGRADE").setValue(dictNameEmergency + "");
doc.openDataRegion("PO_EVENTGRADE").setEditing(false);
doc.openDataRegion("PO_ADDRESS").setValue(eventInfoEmergency.getAddress() + "");
doc.openDataRegion("PO_ADDRESS").setEditing(false);
doc.openDataRegion("PO_EVENTCAUSE").setValue(eventInfoEmergency.getEventCause() + "");
doc.openDataRegion("PO_EVENTCAUSE").setEditing(false);
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "env_disaster_evaluation"://灾害快速评估专报
R<AjaxResult> ajaxResult = remoteEventService.getEventInfo(eventId);//夸服务调用时报没有权限，暂时把事件的权限去掉
if (StringUtils.isNull(ajaxResult) || StringUtils.isNull(ajaxResult.getData())) {
} else {
String name = String.valueOf(ajaxResult.getData().get("name"));
name = StringUtils.isNotNull(name) ? name : "";
String content = String.valueOf(ajaxResult.getData().get("content"));
content = StringUtils.isNotNull(content) ? content : "";
String contacts = String.valueOf(ajaxResult.getData().get("contacts"));
contacts = StringUtils.isNotNull(ajaxResult.getData().get("contacts")) ? contacts : "";
String eventTypeDis = String.valueOf(ajaxResult.getData().get("eventType"));
eventTypeDis = StringUtils.isNotNull(eventTypeDis) ? eventTypeDis : "";
String eventTime = String.valueOf(ajaxResult.getData().get("eventTime"));
eventTime = StringUtils.isNotNull(eventTime) ? eventTime : "";
String address = String.valueOf(ajaxResult.getData().get("address"));
address = StringUtils.isNotNull(address) ? address : "";
String eventCause = String.valueOf(ajaxResult.getData().get("eventCause"));
eventCause = StringUtils.isNotNull(eventCause) ? eventCause : "";
doc.openDataRegion("PO_NAME").setValue(name + "");
doc.openDataRegion("PO_NAME").setEditing(false);
doc.openDataRegion("PO_CONTENT").setValue(content + "");
doc.openDataRegion("PO_CONTENT").setEditing(true);
doc.openDataRegion("PO_CONTACTS").setValue(contacts + "");
doc.openDataRegion("PO_CONTACTS").setEditing(false);
doc.openDataRegion("PO_EVENTTIME").setValue(eventTime);
doc.openDataRegion("PO_EVENTTIME").setEditing(false);
doc.openDataRegion("PO_EVENTGRADE").setValue(address + "");
doc.openDataRegion("PO_EVENTGRADE").setEditing(false);
doc.openDataRegion("PO_ADDRESS").setValue(address + "");
doc.openDataRegion("PO_ADDRESS").setEditing(false);
doc.openDataRegion("PO_EVENTCAUSE").setValue(eventCause + "");
doc.openDataRegion("PO_EVENTCAUSE").setEditing(false);
}
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
case "env_sop"://标准作业流程SOP
poCtrl.setTheme(ThemeType.Office2007);
poCtrl.setBorderStyle(BorderStyleType.BorderThin);
poCtrl.setWriter(doc);
break;
}
poCtrl.webOpen("/downloadFile?mesId=" + template.getId(), OpenModeType.docAdmin, SecurityUtils.getNickname());
} else {
//暂无模板
}
} else {
//新建模板
poCtrl.webCreateNew(SecurityUtils.getUsername(), DocumentVersion.Word2003);
}
} else {// 打开
//打开word
poCtrl.webOpen("/downloadFile?mesId=" + mesId, OpenModeType.docAdmin, SecurityUtils.getNickname());
}
map.put("pageoffice", poCtrl.getHtmlCode("PageOfficeCtrl1"));
return new ModelAndView("Word");
}
/**
* 得到事件信息
* 于吉利 2021-10-15
*
* @param eventId
* @return
*/
public EvnEvent getEventInfo(String eventId) {
EvnEvent evnEvent = null;
R<AjaxResult> ajaxResultEventInfo = remoteEventService.getEventInfo(eventId);//夸服务调用时报没有权限，暂时把事件的权限去掉
if (StringUtils.isNull(ajaxResultEventInfo) || StringUtils.isNull(ajaxResultEventInfo.getData())) {
} else {
//evnEvent=JSON.parseObject(JSON.toJSONString(ajaxResultEventInfo.getData()), EvnEvent.class);//去掉此种方法返回值，先处理null值
evnEvent = new EvnEvent();
String id = String.valueOf(ajaxResultEventInfo.getData().get("id"));
evnEvent.setId(id);
String name = String.valueOf(ajaxResultEventInfo.getData().get("name"));
name = name.equals("null") ? "" : name;
evnEvent.setName(name);
String content = String.valueOf(ajaxResultEventInfo.getData().get("content"));
content = content.equals("null") ? "" : content;
evnEvent.setContent(content);
String reportName = String.valueOf(ajaxResultEventInfo.getData().get("reportName"));
reportName = reportName.equals("null") ? "" : reportName;
evnEvent.setReportName(reportName);
String reportUnit = String.valueOf(ajaxResultEventInfo.getData().get("reportUnit"));
reportUnit = reportUnit.equals("null") ? "" : reportUnit;
evnEvent.setReportUnit(reportUnit);
String reportUnitTel = String.valueOf(ajaxResultEventInfo.getData().get("reportUnitTel"));
reportUnitTel = reportUnitTel.equals("null") ? "" : reportUnitTel;
evnEvent.setReportUnitTel(reportUnitTel);
String reportTime = String.valueOf(ajaxResultEventInfo.getData().get("reportTime"));
//reportTime = reportTime.equals("null") ? "" : reportTime;
if (reportTime.equals("null")) {
} else {
evnEvent.setReportTime(DateUtils.parseDate(reportTime));
}
String contacts = String.valueOf(ajaxResultEventInfo.getData().get("contacts"));
contacts = contacts.equals("null") ? "" : contacts;
evnEvent.setContacts(contacts);
String dutyReportId = String.valueOf(ajaxResultEventInfo.getData().get("dutyReportId"));
dutyReportId = dutyReportId.equals("null") ? "" : dutyReportId;
evnEvent.setDutyReportId(dutyReportId);
String eventType = String.valueOf(ajaxResultEventInfo.getData().get("eventType"));
eventType = eventType.equals("null") ? "" : eventType;
evnEvent.setEventType(eventType);
String eventGrade = String.valueOf(ajaxResultEventInfo.getData().get("eventGrade"));
eventGrade = eventGrade.equals("null") ? "" : eventGrade;
evnEvent.setEventGrade(eventGrade);
String eventTime = String.valueOf(ajaxResultEventInfo.getData().get("eventTime"));
//eventTime = eventTime.equals("null") ? "" : eventTime;
if (eventTime.equals("null")) {
} else {
evnEvent.setEventTime(DateUtils.parseDate(eventTime));
}
String longitude = String.valueOf(ajaxResultEventInfo.getData().get("longitude"));
longitude = longitude.equals("null") ? "" : longitude;
evnEvent.setLongitude(longitude);
String latitude = String.valueOf(ajaxResultEventInfo.getData().get("latitude"));
latitude = latitude.equals("null") ? "" : latitude;
evnEvent.setLatitude(latitude);
String address = String.valueOf(ajaxResultEventInfo.getData().get("address"));
address = address.equals("null") ? "" : address;
evnEvent.setAddress(address);
String districts = String.valueOf(ajaxResultEventInfo.getData().get("districts"));
districts = districts.equals("null") ? "" : districts;
evnEvent.setDistricts(districts);
String eventCause = String.valueOf(ajaxResultEventInfo.getData().get("eventCause"));
eventCause = eventCause.equals("null") ? "" : eventCause;
evnEvent.setEventCause(eventCause);
String eventDesc = String.valueOf(ajaxResultEventInfo.getData().get("eventDesc"));
eventDesc = districts.equals("null") ? "" : eventDesc;
evnEvent.setEventDesc(eventDesc);
String signLeader = String.valueOf(ajaxResultEventInfo.getData().get("signLeader"));
signLeader = signLeader.equals("null") ? "" : signLeader;
evnEvent.setSignLeader(signLeader);
String disasterDesc = String.valueOf(ajaxResultEventInfo.getData().get("disasterDesc"));
disasterDesc = disasterDesc.equals("null") ? "" : disasterDesc;
evnEvent.setDisasterDesc(disasterDesc);
String takeSteps = String.valueOf(ajaxResultEventInfo.getData().get("takeSteps"));
takeSteps = takeSteps.equals("null") ? "" : takeSteps;
evnEvent.setTakeSteps(takeSteps);
String rescueSituation = String.valueOf(ajaxResultEventInfo.getData().get("rescueSituation"));
rescueSituation = rescueSituation.equals("null") ? "" : rescueSituation;
evnEvent.setRescueSituation(rescueSituation);
String supportRequest = String.valueOf(ajaxResultEventInfo.getData().get("supportRequest"));
supportRequest = supportRequest.equals("null") ? "" : supportRequest;
evnEvent.setSupportRequest(supportRequest);
String securityLevel = String.valueOf(ajaxResultEventInfo.getData().get("securityLevel"));
securityLevel = securityLevel.equals("null") ? "" : securityLevel;
evnEvent.setSecurityLevel(securityLevel);
String eventSource = String.valueOf(ajaxResultEventInfo.getData().get("eventSource"));
eventSource = eventSource.equals("null") ? "" : eventSource;
evnEvent.setEventSource(eventSource);
String eventFocuson = String.valueOf(ajaxResultEventInfo.getData().get("eventFocuson"));
eventFocuson = eventFocuson.equals("null") ? "" : eventFocuson;
evnEvent.setEventFocuson(eventFocuson);
}
return evnEvent;
}
/**
* 查询匹配后的预案信息
* 于吉利 2021-10-15
*
* @param eventId
* @return
*/
// public EvnPlanSelected getPlan(String eventId) {
// EvnPlanSelected planSelected = null;
// TableDataInfo plan = remoteEventPlanSelectedService.list(eventId);//得到匹配后的预案信息
// if (plan != null && plan.getRows() != null && plan.getRows().size() > 0) {
// planSelected = JSON.parseObject(JSON.toJSONString(plan.getRows().get(0)), EvnPlanSelected.class);
// } else {
// //doing nothing
// }
// return planSelected;
// }
public EvnPlanSelected getPlan(String eventId) {
EvnPlanSelected planSelected = null;
TableDataInfo plan = remoteEventPlanSelectedService.list(eventId);//得到匹配后的预案信息
if (plan != null && plan.getRows() != null && plan.getRows().size() > 0) {
planSelected = JSON.parseObject(JSON.toJSONString(plan.getRows().get(0)), EvnPlanSelected.class);
} else {
//doing nothing
}
return planSelected;
}
/**
* 根据字典值得到字典名称
*
* @param dictType
* @param dictValue
* @return
*/
public String getDictName(String dictType, String dictValue) {
TableDataInfo dictData = remoteDictDataService.getlist(dictType, dictValue);
SysDictData sysDictData = null;
if (dictData != null && dictData.getRows() != null && dictData.getRows().size() > 0) {
sysDictData = JSON.parseObject(JSON.toJSONString(dictData.getRows().get(0)), SysDictData.class);
} else {
//doing nothing
}
return sysDictData.getDictLabel();//得到字典名称
}
/**
* 得到分类字典
*
* @param categoryValue
* @return
*/
public String getCategory(String categoryValue) {
String categoryName = "";
R<AjaxResult> eventtype = remoteCategoryService.getInfo(categoryValue);
if (StringUtils.isNull(eventtype) || StringUtils.isNull(eventtype.getData())) {
//doing nothing
} else {
String name = String.valueOf(eventtype.getData().get("name"));
categoryName = name.equals("null") ? "" : name;
}
return categoryName;
}
/**
* 文件上传
*/
@RequestMapping("/saveTemplateModel")
public void uploadModel(HttpServletRequest request, HttpServletResponse response) {
String type = request.getParameter("type");
String mesId = request.getParameter("mesId");
String filepath = fileInfoService.filelist(mesId);
String fileType = "";
String path = "";
switch (type) {
case "0"://模板管理
if (TextUtils.isEmpty(filepath)) {
path = "system/template/";
SimpleDateFormat format = new SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒");
path = path + format.format(new Date()) + "模板.doc";
} else {
path = filepath;
}
fileType = "120000";
break;
case "1"://值班报告
case "2"://突发事件
if (TextUtils.isEmpty(filepath)) {
path = "duty/report/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "150000";
break;
case "emergency_command_plan"://应急指挥方案
if (TextUtils.isEmpty(filepath)) {
path = "disposalplan/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "160000";
break;
case "resource_guarantee_plan"://资源保障方案
if (TextUtils.isEmpty(filepath)) {
path = "disposalplan/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "160001";
break;
case "rescue_disposal_plan"://救援处置方案
if (TextUtils.isEmpty(filepath)) {
path = "disposalplan/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "160002";
break;
case "emergency_work_plan"://应急工作方案
if (TextUtils.isEmpty(filepath)) {
path = "disposalplan/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "160003";
break;
case "env_disaster_evaluation"://灾害快速评估专报
if (TextUtils.isEmpty(filepath)) {
path = "disasterevaluation/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "200000";
break;
case "env_sop"://标准作业流程SOP
if (TextUtils.isEmpty(filepath)) {
path = "sop/";
path = path + DateUtils.datePath() + "/" + IdUtils.fastUUID() + ".doc";
} else {
path = filepath;
}
fileType = "210000";
break;
}
FileSaver fs = new FileSaver(request, response);
try {
MultipartFile file = new MockMultipartFile(fs.getFileName(), path, "application/octet-stream", fs.getFileStream());
remoteFileService.upload(file);
//删除原来的关联数据
int f = fileInfoService.delFile(mesId);
//存储文件
SysFileInfo files = new SysFileInfo();
files.setFilePath(path);
files.setName(path.substring(path.lastIndexOf("/") + 1));
files.setType(fileType);
files.setResId(mesId);
fileInfoService.addFile(files);
fs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 文件下载
*/
@RequestMapping("/downloadFile")
public Object downloadFile(String mesId) {
String file = fileInfoService.filelist(mesId);
ResponseEntity<byte[]> entity = remoteFileService.download(file);
return entity;
}
@RequestMapping(value = "/excel", method = RequestMethod.GET)
public ModelAndView showExcel(HttpServletRequest request, Map<String, Object> map, String file) {
PageOfficeCtrl poCtrl = new PageOfficeCtrl(request);
// 加按钮
poCtrl.addCustomToolButton("保存", "Save", 1);//添加自定义保存按钮
poCtrl.addCustomToolButton("盖章", "AddSeal", 2);//添加自定义盖章按钮
poCtrl.setServerPage("/poserver.zz");//设置服务页面
poCtrl.setSaveFilePage("/save");//设置处理文件保存的请求方法
//打开excel
poCtrl.webOpen("/download?file=" + file, OpenModeType.xlsNormalEdit, SecurityUtils.getNickname());
map.put("pageoffice", poCtrl.getHtmlCode("PageOfficeCtrl1"));
ModelAndView mv = new ModelAndView("Excel");
return mv;
}
/**
* 添加PageOffice的服务器端授权程序Servlet（必须）
*
* @return
*/
@Bean
public ServletRegistrationBean servletRegistrationBean() {
com.zhuozhengsoft.pageoffice.poserver.Server poserver = new com.zhuozhengsoft.pageoffice.poserver.Server();
poserver.setSysPath(pageofficeConfig.getPosyspath());//设置PageOffice注册成功后,license.lic文件存放的目录
ServletRegistrationBean srb = new ServletRegistrationBean(poserver);
srb.addUrlMappings("/poserver.zz");
srb.addUrlMappings("/posetup.exe");
srb.addUrlMappings("/pageoffice.js");
srb.addUrlMappings("/jquery.min.js");
srb.addUrlMappings("/pobstyle.css");
srb.addUrlMappings("/sealsetup.exe");
return srb;
}
/**
* 添加印章管理程序Servlet（可选）
*
* @return
*/
@Bean
public ServletRegistrationBean servletRegistrationBean2() {
com.zhuozhengsoft.pageoffice.poserver.AdminSeal adminSeal = new com.zhuozhengsoft.pageoffice.poserver.AdminSeal();
adminSeal.setAdminPassword(pageofficeConfig.getPopassword());//设置印章管理员admin的登录密码
adminSeal.setSysPath(pageofficeConfig.getPosyspath());//设置印章数据库文件poseal.db存放的目录
ServletRegistrationBean srb = new ServletRegistrationBean(adminSeal);
srb.addUrlMappings("/adminseal.zz");
srb.addUrlMappings("/sealimage.zz");
srb.addUrlMappings("/loginseal.zz");
return srb;
}
}
