package com.cloud.user.service.impl;
|
|
//import com.cloud.common.utils.AppUserUtil;
|
import com.cloud.model.file.FileInfo;
|
import com.cloud.model.sys.BbEmployee;
|
import com.cloud.user.dao.BbFaceDao;
|
//import com.cloud.user.feign.FileUtilClient;
|
import com.cloud.user.model.BbFace;
|
import com.cloud.user.service.BbEmployeeService;
|
import com.cloud.user.service.ExcelService;
|
import com.cloud.user.utils.ExcelImportUtil;
|
import com.cloud.user.utils.FaceUtil;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.poi.ss.usermodel.PictureData;
|
import org.apache.poi.xssf.usermodel.XSSFSheet;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
import java.util.List;
|
import java.util.Map;
|
|
@Slf4j
|
@Service
|
public class ExcelServiceImpl implements ExcelService {
|
|
@Autowired
|
private BbEmployeeService service;
|
// @Autowired
|
// private FileUtilClient fileUtilClient;
|
// @Autowired
|
// private BbFaceDao bbFaceDao;
|
|
private ExcelImportUtil excelImportUtil;
|
|
@Override
|
public void getExcel(MultipartFile files, int index) {
|
excelImportUtil = new ExcelImportUtil();
|
try {
|
List<BbEmployee> list = excelImportUtil.readExcelBbEmployee(files,index);
|
if(list.size()>0){
|
readExcelSetBbEmployee(files,list);
|
for(int i=0;i<list.size();i++){
|
service.add(list.get(i));
|
}
|
}else {
|
log.info("Excel表格数据不正确！！！");
|
}
|
}catch (IOException e){
|
System.out.println(e.getMessage());
|
}
|
}
|
|
//获取图片赋值到集合
|
public List<BbEmployee> readExcelSetBbEmployee(MultipartFile file,List<BbEmployee> list ) throws IOException{
|
ExcelImportUtil excelImportUtil = new ExcelImportUtil();
|
//检查文件
|
// boolean checkFile = excelImportUtil.checkFile(file);
|
// if(checkFile) {
|
// //获得Workbook工作薄对象
|
// XSSFWorkbook workbook = excelImportUtil.getXSSFWorkbook(file);
|
// XSSFSheet sheet = workbook.getSheetAt(0);
|
// Map<String, PictureData> map = excelImportUtil.getSheetPictrues(sheet);
|
// for(int i=0;i<list.size();i++){
|
// byte[] bytes = map.get(i+"").getData();
|
// byte[] bytesFaces = bytes;
|
// try {
|
// //上传到服务器拿到路径
|
// FileInfo fileInfo = fileUtilClient.uploadByFile( list.get(i).getName(),bytes,"", AppUserUtil.getAccessToken());
|
// list.get(i).setPhotos(fileInfo.getUrl());
|
// //获取人脸特征
|
// String faces = FaceUtil.extractFeature(bytesFaces,null);
|
// //人脸特征不为空时
|
// if(!faces.isEmpty()){
|
// BbFace bbFace = new BbFace();
|
// bbFace.setOrgId(list.get(i).getOrgId());
|
// bbFace.setFeature(faces);
|
// bbFaceDao.save(bbFace);
|
// }
|
// //查询人脸表ID
|
// if(!faces.isEmpty()){
|
// Integer bbFaciId = bbFaceDao.findIdByFaces(faces);
|
// list.get(i).setFaceIds(bbFaciId.toString());
|
// }
|
// //查询人脸表ID
|
// if(!faces.isEmpty()){
|
// Integer bbFaciId = bbFaceDao.findIdByFaces(faces);
|
// list.get(i).setFaceIds(bbFaciId.toString());
|
// }
|
// }catch (Exception e){
|
// System.out.println(e.getMessage());
|
// }
|
//
|
// //生成到本地jpg图片文件
|
// //getFile(bytes,"d:\\img",i+".jpg");
|
// //File imgFile = byte2File(bytes,"d:\\img",i+".jpg");
|
// }
|
// }
|
return list;
|
}
|
}
|
