修改看板大屏，动态获取数据

huang

2025-06-12 e206ea8f7dbb655c0d8868996dae8ff1ff5ed11a

 JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/md/controller/TaskingLogController.java

@@ -1,12 +1,14 @@
package com.mes.md.controller;


import com.mes.md.service.TaskingLogService;
import com.mes.utils.Result;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.*;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
@@ -23,6 +25,57 @@

    @Autowired
    TaskingLogService taskingLogService;

    @ApiOperation("查询报表")
    @PostMapping("/mechanicalReport")
    @ResponseBody
    public Result mechanicalReport(
            @RequestParam(required = false) Integer dayCount,
            @RequestParam(required = false) @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") Date startDate,
            @RequestParam(required = false) @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") Date endDate,
            @RequestParam(required = false) String taskType,
            @RequestParam(required = false) String operationRecord,
            @RequestParam(required = false) String lineType) {
        try {
            List<Map> result = taskingLogService.selectMechanicalReport(
                dayCount,
                startDate,
                endDate,
                taskType,
                operationRecord,
                lineType
            );
            return Result.build(200, "查询成功", result);
        } catch (Exception e) {
            return Result.build(199, "查询异常", null);
        }
    }

   @ApiOperation("查询单小时产量")
   @PostMapping("/findHourlyOutput")
   @ResponseBody
   public Result findHourlyOutput(@RequestBody Map<String, String> map) {
       try {
           int dayCount = Integer.valueOf(map.get("dayCount").toString());
           Map<String, Object> result = taskingLogService.findHourlyOutput(dayCount);
           return Result.build(200, "查询成功", result);
       } catch (Exception e) {
           return Result.build(199, "查询失败: " + e.getMessage(), null);
       }
   }

   @ApiOperation("查询库位数据")
   @PostMapping("/selectWareHouse")
   @ResponseBody
   public Result selectWareHouse(@RequestBody Map<String, String> map) {
       try {
           int dayCount = Integer.valueOf(map.get("dayCount").toString());
           List<Map<String, Object>> result = taskingLogService.selectWareHouse(dayCount);
           return Result.build(200, "查询成功", result);
       } catch (Exception e) {
           return Result.build(199, "查询失败: " + e.getMessage(), null);
       }
   }

    @ApiOperation("提交日志以及报工数据到九牧数据库")
    @PostMapping("/reportTaskingLog")
@@ -59,6 +112,5 @@
            return Result.build(199,"提交异常",map);
        }
    }

}