| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | 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; |
| | | |
| | |
| | | @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); |
| | |
| | | |
| | | //查询报工表内是否存在对应流程卡的数据 |
| | | Integer reportingWorkCount(String processId); |
| | | |
| | | Integer reportingWorkCountByOrderId(String orderId); |
| | | |
| | | //插入Flow_card表 |
| | | Boolean addFlowCardMp(String processId, Integer orderNumber, Integer landingSequence, Integer quantity, String productionId, String userName, Integer layer); |
| | |
| | | List<Map<String, String>> flowCardDetailMp(String processId, 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>> getPrimaryList(String processId, String technologyNumber, String glassChild, String process, String orderId); |
| | | |
| | | 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>> getDetailLists(String processId, String technologyNumber, String process,Integer orderNumber); |
| | | |
| | | List<Map<String, Object>> getProcessList(String processId, String technologyNumber); |
| | | |
| | | Boolean updateInventory(String processId, String orderNumber, String technologyNumber, Integer completedQuantity); |
| | | |
| | | Boolean updateComposing(String processId); |
| | | |
| | | Boolean updateProcessCardRack(String processId,String technologyNumber,String rack); |
| | | |
| | | List<Map<String, String>> getPrintLabel(String projectNo); |
| | | |
| | |
| | | |
| | | List<Map<String, Object>> getCustomLabelDetailMp(String name, String form, String id, FlowCard flowCard); |
| | | |
| | | List<Map<String, Object>> getPrintCustomData(String processId, String technologyNumber); |
| | | List<Map<String, Object>> getPrintCustomData(String processId, Integer orderNumber); |
| | | |
| | | List<Map<String, Object>> getPrintCustomData2(String processId); |
| | | |
| | | Integer getPrintLabelCount(String processId, String technologyNumber); |
| | | |
| | | List<Map<String, String>> selectReplenishPrintMp(Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | |
| | | List<Map<String, Object>> getRepairPrintCustomData(String processId, String technologyNumber, String reportingWorkId); |
| | | List<Map<String, Object>> getRepairPrintCustomData(String processId, String technologyNumber, String reportingWorkId, Integer orderNumber); |
| | | |
| | | List<Map<String, Object>> getGlassNumber(String technologyNumber, String processId); |
| | | |
| | |
| | | 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>> getDetailListMerge(String processId, String process); |
| | | |
| | | List<Map<String, Object>> getDetailListLikes(String processId, String technologyNumber, String process,String printProject,Integer quantity); |
| | | |
| | | List<Map<String, String>> getPrimaryListMergeRefund(String processId, String technologyNumber, Integer orderNumber, String orderId); |
| | | |
| | |
| | | |
| | | List<Map<String, String>> selectPrintNotMergeMp(String orderId); |
| | | |
| | | List<Map<String, String>> getRepairPrintCustomDataSemi(String processId, String technologyNumber, String reportingWorkId); |
| | | List<Map<String, String>> getRepairPrintCustomDataSemi(String processId, String technologyNumber, String reportingWorkId, Integer orderNumber); |
| | | |
| | | List<Map<String, String>> selectPrintAllMp(String orderId); |
| | | |
| | |
| | | Boolean updateFlowCardMerge(String processId,List<Integer> technologyNumbers,Integer index); |
| | | |
| | | Boolean deleteflowCardSort(String orderId, String processId); |
| | | Boolean deleteflowCardSortByOrderId(String orderId); |
| | | |
| | | List<Map<String, Object>> getPrintProjectDetailsMp(String projectNo); |
| | | |
| | |
| | | Boolean deleteProcessMp(String processId, String technologyNumber); |
| | | |
| | | Boolean updateOrderProcessMp(String orderId, String number, String technologyNumber, String orderprocess); |
| | | |
| | | List<FlowCard> getFlowCardListPrintProject(String printProject); |
| | | |
| | | Integer updateProjectLabelPrintCount(String projectNo); |
| | | |
| | | Integer selectProjectLabelPrintCount(String projectNo); |
| | | |
| | | Integer updateProjectProcessPrintCount(String projectNo); |
| | | |
| | | Integer selectProjectProcessPrintCount(String projectNo); |
| | | |
| | | 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(); |
| | | } |