| | |
| | | package com.example.erp.mapper.pp; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.example.erp.dto.pp.FlowCardDTO; |
| | | import com.example.erp.entity.pp.FlowCard; |
| | | import com.example.erp.entity.sd.OrderDetail; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.sql.Date; |
| | | import java.time.LocalDate; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | |
| | | @Mapper |
| | | public interface FlowCardMapper extends BaseMapper<FlowCard> { |
| | | //流程卡管理查询 |
| | | List<FlowCard> selectFlowCard(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | List<FlowCard> selectFlowCard(Integer offset, Integer pageSize, String selectTime1, String selectTime2, FlowCard flowCard); |
| | | |
| | | //分页查询 |
| | | Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, String selectTime1, String selectTime2, FlowCard flowCard); |
| | | |
| | | //分架数据查询 |
| | | List<FlowCard> selectFlowCardMp(Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | |
| | | Boolean deleteReportingWork(String processId); |
| | | Boolean deleteReportingWorkByOrderId(String orderId); |
| | | |
| | | List<Map<String, String>> selectPrintFlowCardMp(Date selectTime1, Date selectTime2, String orderId, String project, FlowCard flowCard); |
| | | List<Map<String, String>> selectPrintFlowCardMp(Date selectTime1, Date selectTime2, String orderId, String project, Integer state, FlowCard flowCard); |
| | | |
| | | List<Map<String, String>> selectPrintFlowCard(Date selectTime1, Date selectTime2); |
| | | |
| | |
| | | |
| | | List<Map<String, String>> getPrimaryLists(String processId, String technologyNumber, String glassChild, String process, String orderId,Integer quantity); |
| | | |
| | | List<Map<String, Object>> getDetailList(String processId, String technologyNumber, String process); |
| | | List<Map<String, Object>> getDetailList(String processId, String technologyNumber, String process, String flashback, String landingSequence); |
| | | |
| | | List<Map<String, Object>> getDetailLists(String processId, String technologyNumber, String process,Integer orderNumber); |
| | | |
| | |
| | | |
| | | Boolean updateComposing(String processId); |
| | | |
| | | Boolean updateProcessCardRack(String processId,String technologyNumber,Integer orderNumber,String rack); |
| | | Boolean updateProcessCardRack(String processId,String technologyNumber,String rack); |
| | | |
| | | List<Map<String, String>> getPrintLabel(String projectNo); |
| | | |
| | |
| | | |
| | | List<Map<String, String>> selectReworkPrintMp(Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | |
| | | List<Map<String, Object>> getDetailListLike(String processId, String technologyNumber, String process); |
| | | List<Map<String, Object>> getDetailListLike(String processId, String technologyNumber, String process, String flashback, String landingSequence); |
| | | |
| | | List<Map<String, Object>> getDetailListMerge(String processId, String process); |
| | | List<Map<String, Object>> getDetailListMerge(String processId, String process, String flashback, String landingSequence); |
| | | |
| | | List<Map<String, Object>> getDetailListLikes(String processId, String technologyNumber, String process,String printProject,Integer quantity); |
| | | |
| | |
| | | int flowCardToOptimizeCount(String orderId); |
| | | |
| | | List<Map<String, Object>> getFlowCardDetail(String processId); |
| | | |
| | | Map<String,Object> getGlassThicknessByProdutionId(String orderId,String productionId); |
| | | |
| | | List<OrderDetail> getOrderDetailByProductionId(String orderId, String productionId, String type, Float inLenMax, Float inLenMin, Float inShortMax, Float inShortMin, Float glassThickness); |
| | | |
| | | Boolean revokeComposing(String processId); |
| | | |
| | | Integer selectProjectNo(String processId); |
| | | |
| | | List<Map<String, String>> selectPrintDetailsMp2(String orderId); |
| | | |
| | | List<Map<String, Object>> getPrintOrderDataDetails(String orderId, Integer orderNumber, Integer printQuantity); |
| | | |
| | | Boolean updatePrintNumberMp(String processId, Integer orderNumber); |
| | | |
| | | String getOrderIdByProcessId(String processId); |
| | | |
| | | Boolean updateFlowCardIsMerge(String processId); |
| | | |
| | | Integer flowCardDetailMergeMp(String processId); |
| | | |
| | | String getProcessName(String processSub); |
| | | |
| | | List<Map<String, Object>> getProcessNameList(); |
| | | |
| | | List<FlowCardDTO> exportDateProcessMp(List<LocalDate> date); |
| | | |
| | | Integer getSumQuantity(String orderId); |
| | | |
| | | List<Map<String, Object>> getDetailCompoundList(String processId, String technologyNumber, String process, String flashback, String compound, String landingSequence); |
| | | |
| | | List<Map<String, Object>> getDetailListLikeCompound(String processId, String s, String process, String flashback, String compound, String landingSequence); |
| | | } |