package com.fdkankan.manage.test; import cn.hutool.core.io.FileUtil; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.fdkankan.common.util.FileUtils; import com.fdkankan.fyun.face.FYunFileServiceInterface; import com.fdkankan.manage.common.OssPath; import com.fdkankan.manage.common.ResultCode; import com.fdkankan.manage.common.ResultData; import com.fdkankan.common.util.SecurityUtil; import com.fdkankan.manage.common.FilePath; import com.fdkankan.manage.exception.BusinessException; import com.fdkankan.manage.httpClient.service.LaserService; import com.fdkankan.manage.service.ICameraService; import com.fdkankan.manage.service.IScenePlusService; import com.fdkankan.manage.service.ISceneProService; import com.fdkankan.manage.util.Dateutils; import com.fdkankan.manage.util.ExcelUtil; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.multipart.MultipartFile; import java.io.IOException; import java.util.*; @Slf4j @RestController @RequestMapping("/test") public class TestController { @Autowired ISceneProService sceneProService; @Autowired FYunFileServiceInterface fYunFileServiceInterface; @Autowired ICameraService cameraService; @RequestMapping("/test") public ResultData test(@RequestParam(required = false) String oldSnCode, @RequestParam(required = false)String newSnCode, @RequestParam(required = false)String dataSource){ return ResultData.ok(); } /** * 重置相机容量 */ @RequestMapping("/testCameraSpace") public ResultData testCameraSpace(@RequestParam(required = false) Long userId){ cameraService.initAllCameraSpace(userId); return ResultData.ok(); } /** * 导入excel * type 0 入库模板, 1出库模板 ,2 客户关联模板 */ @PostMapping("/uploadExcel") public ResultData uploadExcel(@RequestParam(required = false) MultipartFile file) throws IOException { String originalFilename = file.getOriginalFilename(); assert originalFilename != null; String fileType=originalFilename.substring(originalFilename.lastIndexOf(".")+1); if (!fileType.equalsIgnoreCase("xlsx")) { throw new BusinessException(ResultCode.FILE_TYPE_ERROR); } List> excelRowList = new ArrayList<>(); try { excelRowList = ExcelUtil.getExcelRowList(file); }catch (Exception e){ throw new BusinessException(ResultCode.TEMPLATE_TYPE_ERROR); } System.out.println(excelRowList); return ResultData.ok(); } }