From ef5a518c3e2c1fe41aa60f56ca31ddafa0cb1561 Mon Sep 17 00:00:00 2001 From: guoyuji <guoyujie@ng.com> Date: 星期四, 23 五月 2024 08:32:36 +0800 Subject: [PATCH] 添加产品汇总报表 --- north-glass-erp/src/main/java/com/example/erp/mapper/pp/DeviceMaintenanceMapper.java | 37 +++++++++++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/DeviceMaintenanceMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/DeviceMaintenanceMapper.java new file mode 100644 index 0000000..1fd51f5 --- /dev/null +++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/DeviceMaintenanceMapper.java @@ -0,0 +1,37 @@ +package com.example.erp.mapper.pp; + +import com.example.erp.entity.pp.DeviceMaintenance; +import org.apache.ibatis.annotations.Mapper; + +import java.sql.Date; +import java.time.LocalDateTime; +import java.util.List; +import java.util.Map; + +@Mapper +public interface DeviceMaintenanceMapper { + + + String getBasicData(String process); + Boolean addMachineMp(String basicId, String basicName); + + List<Map<String,String>> selectProcessMp(); + + List<Map<String,String>> selectDeviceMp(); + + String getDeviceData(String deviceName); + + Boolean saveMaintenanceAndRepairMp(String deviceId, String deviceName, String type, LocalDateTime faultTime, + String faultReason, LocalDateTime maintenanceTime, String maintenanceIllustrate, + LocalDateTime stopTime, LocalDateTime startTime,String process, String personnel, String cost); + + List<DeviceMaintenance> selectMaintenanceMp(Date selectTime1, Date selectTime2); + + Boolean deleteMaintenanceMp(String id); + + List<DeviceMaintenance> selectMachineMp(); + + List<Map<String,String>> openSelectIdMp(String id); + + Boolean updateMaintenanceMp(Integer id, String deviceName, String type, LocalDateTime faultTime, String faultReason, LocalDateTime maintenanceTime, String maintenanceIllustrate, LocalDateTime stopTime, LocalDateTime startTime, String process, String personnel, String cost); +} -- Gitblit v1.8.0