package cn.besteam.modules.medical.service.impl;
|
|
import cn.besteam.modules.medical.dto.ServicePeriodLogDTO;
|
import cn.besteam.modules.medical.dto.ServicePeriodLogListDTO;
|
import cn.besteam.modules.medical.entity.MwServicePeriodLog;
|
import cn.besteam.modules.medical.mapper.MwServicePeriodLogMapper;
|
import cn.besteam.modules.medical.service.IMwServicePeriodLogService;
|
import cn.besteam.modules.system.vo.CollectAppletAuthorizationListVO;
|
import cn.besteam.modules.system.vo.MonthlySmsAuthorizationListVO;
|
import cn.hutool.poi.excel.ExcelWriter;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.apache.poi.ss.usermodel.HorizontalAlignment;
|
import org.apache.poi.ss.usermodel.VerticalAlignment;
|
import org.apache.poi.ss.util.CellRangeAddress;
|
import org.apache.poi.xssf.usermodel.*;
|
import org.springframework.stereotype.Service;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.net.URLEncoder;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class MwServicePeriodLogServiceImpl extends ServiceImpl<MwServicePeriodLogMapper, MwServicePeriodLog> implements IMwServicePeriodLogService {
|
|
@Override
|
public IPage<ServicePeriodLogListDTO> getServicePeriodLog(ServicePeriodLogDTO dto, Integer pageNo, Integer pageSize) {
|
pageNo = dto.getPageNo();
|
pageSize = dto.getPageSize();
|
Page<ServicePeriodLogListDTO> pageParam = new Page<>(pageNo, pageSize);
|
if(dto.getServiceType() != null && dto.getServiceType()==0){
|
dto.setServiceType(null);
|
}
|
if(dto.getDepartmentId()!=-1) {
|
IPage<ServicePeriodLogListDTO> servicePeriodLog = this.baseMapper.getServicePeriodLog(pageParam, dto);
|
return servicePeriodLog;
|
}else {
|
IPage<ServicePeriodLogListDTO> servicePeriodLog = this.baseMapper.getServicePeriodLog1(pageParam, dto);
|
return servicePeriodLog;
|
}
|
|
}
|
|
@Override
|
public void exportServicePeriodLog(ServicePeriodLogDTO dto, HttpServletResponse response) throws Exception{
|
ExcelWriter excelWriter = new ExcelWriter(exportServicePeriodLog(dto, "服务期操作记录"), "服务期操作记录");
|
if (excelWriter != null) {
|
response.setContentType("application/octet-stream;charset=utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("服务期操作记录", "UTF-8") + ".xlsx");
|
excelWriter.flush(response.getOutputStream(), true);
|
excelWriter.close();
|
}
|
}
|
|
@Override
|
public void saveLog(Integer valueOf, Double serviceCharge, Date expireDate, Integer reminderDays, Integer serviceUnit, String note, Integer userId,Integer i) {
|
this.baseMapper.saveLog(valueOf,serviceCharge,expireDate,reminderDays,serviceUnit,note,userId,i);
|
}
|
|
|
private XSSFWorkbook exportServicePeriodLog(ServicePeriodLogDTO dto, String fileName){
|
IPage<ServicePeriodLogListDTO> servicePeriodLog = getServicePeriodLog(dto, 1, 100000);
|
List<ServicePeriodLogListDTO> records = servicePeriodLog.getRecords();
|
XSSFWorkbook workbook = new XSSFWorkbook();
|
XSSFSheet sheet = workbook.createSheet(fileName);
|
XSSFCellStyle cellStyle = createDefaultCellStyle(workbook);
|
|
XSSFRow row = sheet.createRow(0);//表头
|
XSSFCell cell = row.createCell(0);
|
cell.setCellStyle(cellStyle);
|
cell.setCellValue("服务期操作记录");
|
sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 7));
|
|
XSSFRow row2 = sheet.createRow(0);//表头
|
|
XSSFCell cel20 = row2.createCell(0);
|
cel20.setCellValue("操作时间");
|
cel20.setCellStyle(cellStyle);
|
|
XSSFCell cel21 = row2.createCell(1);
|
cel21.setCellValue("区域");
|
cel21.setCellStyle(cellStyle);
|
|
XSSFCell cel22 = row2.createCell(2);
|
cel22.setCellValue("医院名称");
|
cel22.setCellStyle(cellStyle);
|
|
XSSFCell cel23 = row2.createCell(3);
|
cel23.setCellValue("操作内容");
|
cel23.setCellStyle(cellStyle);
|
|
XSSFCell cel24 = row2.createCell(4);
|
cel24.setCellValue("操作前");
|
cel24.setCellStyle(cellStyle);
|
|
XSSFCell cel25 = row2.createCell(5);
|
cel25.setCellValue("操作后");
|
cel25.setCellStyle(cellStyle);
|
|
XSSFCell cel26 = row2.createCell(6);
|
cel26.setCellValue("备注");
|
cel26.setCellStyle(cellStyle);
|
|
XSSFCell cel27 = row2.createCell(7);
|
cel27.setCellValue("操作人");
|
cel27.setCellStyle(cellStyle);
|
|
for (int i = 1; i < records.size(); i++) {
|
XSSFRow row1 = sheet.createRow(i);//表头
|
XSSFCell cel2 = row1.createCell(0);
|
cel2.setCellStyle(cellStyle);
|
cel2.setCellValue(records.get(i).getOperationTime());
|
cel2.setCellStyle(cellStyle);
|
|
XSSFCell cel3 = row1.createCell(1);
|
cel3.setCellValue(records.get(i).getDepartmentName());
|
cel3.setCellStyle(cellStyle);
|
|
XSSFCell cel4 = row1.createCell(2);
|
cel4.setCellValue(records.get(i).getHospital());
|
cel4.setCellStyle(cellStyle);
|
|
XSSFCell cel5 = row1.createCell(3);
|
cel5.setCellValue(records.get(i).getServiceType() == 1 ? "修改到期时间" : "修改服务费");
|
cel5.setCellStyle(cellStyle);
|
|
XSSFCell cel6 = row1.createCell(4);
|
cel6.setCellValue(records.get(i).getHistoricalData());
|
cel6.setCellStyle(cellStyle);
|
|
XSSFCell cel7 = row1.createCell(5);
|
cel7.setCellValue(records.get(i).getCurrentData());
|
cel7.setCellStyle(cellStyle);
|
|
XSSFCell cel8 = row1.createCell(6);
|
cel8.setCellValue(records.get(i).getNote());
|
cel8.setCellStyle(cellStyle);
|
|
XSSFCell cel9 = row1.createCell(7);
|
cel9.setCellValue(records.get(i).getOperator());
|
cel9.setCellStyle(cellStyle);
|
}
|
return workbook;
|
}
|
|
|
private XSSFCellStyle createDefaultCellStyle(XSSFWorkbook workbook) {
|
|
XSSFCellStyle cellStyle = workbook.createCellStyle();
|
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
|
cellStyle.setAlignment(HorizontalAlignment.CENTER);
|
XSSFFont font = workbook.createFont();
|
font.setFontName("宋体");
|
font.setFontHeightInPoints((short) 12);
|
cellStyle.setFont(font);
|
return cellStyle;
|
}
|
|
private XSSFCellStyle createDefaultLeftCellStyle(XSSFWorkbook workbook) {
|
|
XSSFCellStyle cellStyle = workbook.createCellStyle();
|
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
|
cellStyle.setAlignment(HorizontalAlignment.LEFT);
|
XSSFFont font = workbook.createFont();
|
font.setFontName("宋体");
|
font.setFontHeightInPoints((short) 12);
|
cellStyle.setFont(font);
|
return cellStyle;
|
}
|
|
private XSSFCellStyle createDefaultRightCellStyle(XSSFWorkbook workbook) {
|
|
XSSFCellStyle cellStyle = workbook.createCellStyle();
|
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
|
cellStyle.setAlignment(HorizontalAlignment.RIGHT);
|
XSSFFont font = workbook.createFont();
|
font.setFontName("宋体");
|
font.setFontHeightInPoints((short) 12);
|
cellStyle.setFont(font);
|
return cellStyle;
|
}
|
}
|
