| | |
| | | |
| | | import cn.hutool.core.collection.CollectionUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.jeecg.common.constant.CommonConstant; |
| | | import org.jeecg.modules.base.entity.Factory; |
| | |
| | | } |
| | | return newProductionWorkOrderList; |
| | | } |
| | | |
| | | @Override |
| | | public IPage<MesProductionWorkOrder> queryPageList(Page<MesProductionWorkOrder> page, Map<String, String[]> parameterMap) { |
| | | QueryWrapper<MesProductionWorkOrder> queryWrapper = Wrappers.query(); |
| | | String[] factoryIds = parameterMap.get("factoryId"); |
| | | if (factoryIds != null && factoryIds.length > 0) { |
| | | queryWrapper.eq("t1.factory_id", factoryIds[0]); |
| | | } |
| | | String[] startDates = parameterMap.get("startDate"); |
| | | String[] endDates = parameterMap.get("endDate"); |
| | | if (startDates != null && startDates.length > 0) { |
| | | queryWrapper.ge("t1.work_order_date", startDates[0]); |
| | | } |
| | | if (endDates != null && endDates.length > 0) { |
| | | queryWrapper.le("t1.work_order_date", endDates[0]); |
| | | } |
| | | String[] workOrderStatuses = parameterMap.get("workOrderStatus"); |
| | | if (workOrderStatuses != null && workOrderStatuses.length > 0) { |
| | | queryWrapper.eq("t1.work_order_status", workOrderStatuses[0]); |
| | | } |
| | | queryWrapper.eq("t1.del_flag", CommonConstant.DEL_FLAG_0); |
| | | queryWrapper.orderByAsc("t1.work_order_date"); |
| | | return this.baseMapper.queryPageList(page, queryWrapper); |
| | | } |
| | | } |