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/FlowCardMapper.java | 80 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 80 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java
new file mode 100644
index 0000000..42d2719
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/FlowCardMapper.java
@@ -0,0 +1,80 @@
+package com.example.erp.mapper.pp;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.example.erp.entity.pp.FlowCard;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.sql.Date;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @author SNG-016
+ */
+@Mapper
+public interface FlowCardMapper extends BaseMapper<FlowCard> {
+ //娴佺▼鍗＄鐞嗘煡璇�
+ List<FlowCard> selectFlowCard(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard);
+
+ //鍒嗛〉鏌ヨ
+ Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard);
+
+ //鍒嗘灦鏁版嵁鏌ヨ
+ List<FlowCard> selectFlowCardMp(Date selectTime1, Date selectTime2, FlowCard flowCard);
+
+ //鍒嗘灦鏄庣粏鏌ヨ
+ List<Map<String, String>> detailsSelectMp(String orderId, FlowCard flowCard);
+
+ //鍒犻櫎娴佺▼鍗�
+ Boolean deleteFlowCardMp(String orderId, String processId);
+
+ //鍒嗘灦鏂板鏄庣粏鏌ヨ
+ List<Map<String, String>> selectNoCardMp(String orderId, String productionId, FlowCard flowCard);
+
+ //淇敼鎺掔増鐘舵��
+ Boolean updateLayoutStatusMp(String processId,Integer state);
+
+ Integer selectLayoutStatus(String processId);
+
+ //鏌ヨ鎶ュ伐琛ㄥ唴鏄惁瀛樺湪瀵瑰簲娴佺▼鍗＄殑鏁版嵁
+ Integer reportingWorkCount(String processId);
+
+ //鎻掑叆Flow_card琛�
+ Boolean addFlowCardMp(String processId, Integer orderNumber, Integer landingSequence, Integer quantity, String productionId, String userName, Integer layer);
+
+ Boolean updateFlowState(String productionId, Integer orderNumber);
+
+ Integer selectFlowCount(String productionId);
+
+
+ Boolean updateProcessingCard(String productionId, int state);
+
+ Boolean updateDeleteState(String orderId, String processId);
+
+ List<FlowCard> selectOkSchedulingMp(String selectTime1, String selectTime2, String orderId, String processes, FlowCard flowCard);
+
+ List<FlowCard> selectNoSchedulingMp(String selectTime1, String selectTime2, String orderId, String processes, FlowCard flowCard);
+
+ List<Map<String, String>> selectLastSchedulingMp(String selectTime1, String selectTime2, FlowCard flowCard);
+
+ Integer selectLayer(String productionId, Integer orderNumber);
+
+
+ Integer selectFlowCardCount(String orderId);
+
+ List<Map<String, String>> flowCardDetailMp(String processId, FlowCard flowCard);
+
+ Boolean deleteReportingWork(String processId);
+
+ List<Map<String, String>> selectPrintFlowCardMp(Date selectTime1, Date selectTime2, String orderId, String project, FlowCard flowCard);
+
+ List<Map<String, String>> selectPrintMp(String orderId, FlowCard flowCard);
+
+ List<Map<String, String>> getPrimaryList(String processId, Integer technologyNumber);
+
+ List<Map<String, Object>> getDetailList(String processId, Integer technologyNumber);
+
+ List<Map<String, Object>> getProcessList(String processId, Integer technologyNumber);
+
+ Boolean updateInventory(String processId, String orderNumber, String technologyNumber, int completedQuantity);
+}
--
Gitblit v1.8.0