@RemoteMethod
public ListRange findAll(
TemplateShareGroupDetailDto filter, SortField[] sortFields, int start, int limit) {
ListRange lr = new ListRange();
String hql =
"FROM TemplateShareGroupDetail WHERE templateShare.templateFile.id = ? AND "
+ BusinessConstant.FIND_NOT_INCLUDE_DELETE_HQL
+ " ORDER BY create_date DESC";
int count = 0;
List<TemplateShareGroupDetail> list =
templateShareGroupDetailDaoImpl.findAll(hql, start, limit, filter.getTemplateFileId());
List<TemplateShareGroupDetailDto> dtoList = new ArrayList<TemplateShareGroupDetailDto>();
for (TemplateShareGroupDetail templateShareGroupDetail : list) {
TemplateShareGroupDetailDto templateShareGroupDetailDto =
dozerAssembly.bean2Dto(templateShareGroupDetail, TemplateShareGroupDetailDto.class);
templateShareGroupDetailDto.setCreate_date(
DateUtils.DateToDateTimeString(templateShareGroupDetail.getCreate_date()));
if (templateShareGroupDetail.getAccount() != null
&& templateShareGroupDetail.getAccount().getPerson() != null)
templateShareGroupDetailDto.setPersonName(
templateShareGroupDetail.getAccount().getPerson().getName());
dtoList.add(templateShareGroupDetailDto);
}
count = templateShareGroupDetailDaoImpl.getCount(hql, filter.getTemplateFileId());
lr.setData(dtoList);
lr.setTotalSize(count);
return lr;
}
@RemoteMethod
public FileTransfer downloadFile(String id, HttpServletRequest request) {
TemplateShareGroupDetail shareGroupDetail = templateShareGroupDetailDaoImpl.findById(id);
String path =
formTemplateService.downLoadFilePath(
shareGroupDetail.getAccount(), shareGroupDetail.getCreate_date())
+ "/"
+ shareGroupDetail.getFilePath();
return FileDownLoadUtils.downloadFile(path, shareGroupDetail.getFileName());
}
public void saveGroupDetail(
String shareGroupDetailId,
String filePath,
User user,
String fileName,
TemplateShare templateShare) {
TemplateShareGroupDetail templateShareGroupDetail = null;
if (!StringUtils.isEmpty(shareGroupDetailId))
templateShareGroupDetail = templateShareGroupDetailDaoImpl.findById(shareGroupDetailId);
else templateShareGroupDetail = new TemplateShareGroupDetail();
templateShareGroupDetail.setAccount(user);
templateShareGroupDetail.setCreate_date(DateUtils.getCurrentDateTime());
templateShareGroupDetail.setFileName(fileName);
templateShareGroupDetail.setFilePath(filePath);
templateShareGroupDetail.setTemplateShare(templateShare);
templateShareGroupDetailDaoImpl.saveOrUpdate(templateShareGroupDetail);
if (StringUtils.isEmpty(shareGroupDetailId))
templateFileLogService.addOperationLog(
templateShare.getTemplateFile(), BusinessConstant.OPERATION_SHARE_GROUP_DETAIL_ADD, null);
else
templateFileLogService.addOperationLog(
templateShare.getTemplateFile(),
BusinessConstant.OPERATION_SHARE_GROUP_DETAIL_EDIT,
null);
}
/**
* saveMerage 合并多个excel文件
*
* @param args
* @return void
* @exception
*/
@RemoteMethod
public void saveMerage(List<String> args, String templateFileId) {
HSSFWorkbook hSSFtargetWorkbook = new HSSFWorkbook();
// XSSFWorkbook xSSFtargetWorkbook = new XSSFWorkbook();
Workbook workbook = null;
FileOutputStream out = null;
InputStream sourceStream = null;
try {
// 保存上传的合并文件
TemplateFile templateFile = templateFileDaoImpl.findById(templateFileId);
String uuid = UUID.randomUUID().toString();
String templateFilePath = getFilePath(templateFile);
String uploadFilePath =
formTemplateService.getUploadFilePath(null, BusinessConstant.FORM_UPLOAD)
+ "/"
+ uuid
+ FileUploadUtils.getFileType(templateFilePath);
templateFile.setGroupFileName(templateFile.getFileName());
templateFile.setGroupFilePath(uuid + FileUploadUtils.getFileType(templateFilePath));
templateFileDaoImpl.saveOrUpdate(templateFile);
for (String detaiId : args) {
TemplateShareGroupDetail templateShareGroupDetail =
templateShareGroupDetailDaoImpl.findById(detaiId);
String filePath =
formTemplateService.downLoadFilePath(
templateShareGroupDetail.getAccount(),
templateShareGroupDetail.getCreate_date())
+ "/"
+ templateShareGroupDetail.getFilePath();
sourceStream = new FileInputStream(filePath); // 每个实例的文件路径
workbook = WorkbookFactory.create(sourceStream);
if (".xls".equals(FileUploadUtils.getFileType(templateShareGroupDetail.getFilePath()))
|| ".et".equals(FileUploadUtils.getFileType(templateShareGroupDetail.getFilePath()))) {
out = new FileOutputStream(new File(uploadFilePath)); // 合并后的文件路径
PoiUtils.copySheet2003(
hSSFtargetWorkbook.createSheet(
templateShareGroupDetail.getAccount().getPerson().getName()),
(HSSFSheet) workbook.getSheetAt(0),
hSSFtargetWorkbook,
(HSSFWorkbook) workbook,
true,
true);
hSSFtargetWorkbook.write(out);
}
// 由于金格office编辑器在编辑07版本的excel时会将其内在格式转换为03版本，故poi无法将以.xlsx为后缀的excel读取为XSSFWorkBook对象，此功能暂注释
// else if
// (".xlsx".equals(getFileType(templateShareGroupDetail.getFilePath())))
// {// 2007
// out = new FileOutputStream(new File("d:\\hhh2.xlsx"));
// PoiUtils.copySheet2007(xSSFtargetWorkbook.createSheet(templateShareGroupDetail.getAccount().getPerson().getName()),
// (XSSFSheet) workbook.getSheetAt(0), xSSFtargetWorkbook,
// (XSSFWorkbook) workbook, true);
// xSSFtargetWorkbook.write(out);
// }
else throw new BusinessException(ERR_COMPONENT + "101");
}
templateFileLogService.addOperationLog(
templateFile, BusinessConstant.OPERATION_SHARE_GROUP_MODIFY, null);
} catch (Exception e) {
e.printStackTrace();
throw new BusinessException(ERR_COMPONENT + "101");
} finally {
try {
if (out != null) out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}