|
package org.springblade.mdm.program.controller;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import lombok.AllArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springblade.core.tenant.annotation.NonDS;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.mdm.program.service.ProgramOnMachineService;
|
import org.springblade.mdm.program.vo.*;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
/**
|
* mdm导入接口,工控网功能
|
*
|
* @author yangys
|
*/
|
@NonDS
|
@RestController
|
@RequestMapping("/program/mdmimport/")
|
@AllArgsConstructor
|
@Tag(name = "MDM导入", description = "工控网MDM导入接口")
|
@Slf4j
|
public class ProgramOnMachineImportController {
|
|
private final ProgramOnMachineService programOnMachineService;
|
|
@PostMapping("import-prog-on-machine")
|
@ApiOperationSupport(order = 1)
|
@Operation(summary = "工控网导入现场编制数据", description = "工控网导入现场编制数据")
|
public R<Integer> upload(@RequestParam MultipartFile file) {
|
if(file == null || file.isEmpty() || file.getOriginalFilename() ==null){
|
return R.fail("文件不能为空");
|
}
|
String filename = file.getOriginalFilename().toLowerCase();
|
if(!StringUtils.endsWithAny(filename,".xlsx",".xls")){
|
return R.fail("文件必须为Excel文件");
|
}
|
try {
|
return R.data(programOnMachineService.importData(file));
|
}catch (Exception e){
|
log.error("导入错误",e);
|
return R.fail(e.getMessage());
|
}
|
}
|
|
@Operation(summary = "工控网下场编程记录分页查询", description = "工控网下场编程记录分页查询")
|
@GetMapping("/program-on-machine-page")
|
public R<IPage<ProgramOnMachineVO>> page(ProgramOnMachineRecordQueryVO queryVO) {
|
return R.data(programOnMachineService.pageQuery(queryVO));
|
}
|
|
}
|