| | |
| | | package com.example.erp.mapper.pp; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.example.erp.entity.pp.FlowCard; |
| | | import com.example.erp.entity.sd.Order; |
| | | import com.example.erp.entity.sd.OrderDetail; |
| | | import com.example.erp.entity.sd.OrderGlassDetail; |
| | | 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 { |
| | | public interface FlowCardMapper extends BaseMapper<FlowCard> { |
| | | //流程卡管理查询 |
| | | List<FlowCard> selectFlowCard(Date selectTime1, Date selectTime2,FlowCard 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<FlowCard> DetailsSelectMp(String orderId, FlowCard flowCard); |
| | | List<Map<String, String>> detailsSelectMp(String orderId, FlowCard flowCard); |
| | | |
| | | Boolean DeleteFlowCardMp(String orderId, String processId); |
| | | //删除流程卡 |
| | | Boolean deleteFlowCardMp(String orderId, String processId); |
| | | |
| | | List<FlowCard> SelectNoCardMp(String orderId, String productionId, FlowCard flowCard); |
| | | //分架新增明细查询 |
| | | 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); |
| | | } |