| | |
| | | |
| | | 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.extension.service.impl.ServiceImpl; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.apache.shiro.SecurityUtils; |
| | | import org.jeecg.common.constant.CommonConstant; |
| | | import org.jeecg.common.system.vo.LoginUser; |
| | | import org.jeecg.modules.eam.aspect.annotation.EquipmentHistoryLog; |
| | | import org.jeecg.modules.eam.constant.AssetStatusEnum; |
| | | import org.jeecg.modules.eam.constant.EquipmentMaintenanceStatus; |
| | |
| | | import org.jeecg.modules.eam.entity.EamEquipment; |
| | | import org.jeecg.modules.eam.entity.EamEquipmentExtend; |
| | | import org.jeecg.modules.eam.mapper.EamEquipmentMapper; |
| | | import org.jeecg.modules.eam.request.EamEquipmentQuery; |
| | | import org.jeecg.modules.eam.service.IEamEquipmentExtendService; |
| | | import org.jeecg.modules.eam.service.IEamEquipmentService; |
| | | import org.jeecg.modules.eam.tree.FindsEquipmentProductionUtil; |
| | |
| | | return treeList; |
| | | } |
| | | |
| | | @Override |
| | | public IPage<EamEquipment> queryPageList(IPage<EamEquipment> page, EamEquipmentQuery eamEquipment) { |
| | | QueryWrapper<EamEquipment> queryWrapper = new QueryWrapper<>(); |
| | | //用户权限 |
| | | LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); |
| | | if(sysUser == null){ |
| | | return page; |
| | | } |
| | | queryWrapper.exists("select 1 from mdc_user_production t where t.user_id=? and t.pro_id=e.org_id", sysUser.getId()); |
| | | if(eamEquipment != null){ |
| | | if(StringUtils.isNotBlank(eamEquipment.getEquipmentCode())){ |
| | | queryWrapper.like("e.equipment_code", eamEquipment.getEquipmentCode()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getEquipmentName())){ |
| | | queryWrapper.like("e.equipment_name", eamEquipment.getEquipmentName()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getEquipmentImportance())){ |
| | | queryWrapper.eq("e.equipment_importance", eamEquipment.getEquipmentImportance()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getAssetStatus())){ |
| | | queryWrapper.like("e.asset_status", eamEquipment.getAssetStatus()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getTechnologyStatus())){ |
| | | queryWrapper.like("e.technology_status", eamEquipment.getTechnologyStatus()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getOperationSystem())){ |
| | | queryWrapper.like("e.operation_system", eamEquipment.getOperationSystem()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getOrgId())){ |
| | | queryWrapper.like("e.org_id", eamEquipment.getOrgId()); |
| | | } |
| | | if(StringUtils.isNotBlank(eamEquipment.getEquipmentCategory())){ |
| | | queryWrapper.like("e.equipment_category", eamEquipment.getEquipmentCategory()); |
| | | } |
| | | //排序 |
| | | if(StringUtils.isNotBlank(eamEquipment.getColumn()) && StringUtils.isNotBlank(eamEquipment.getOrder())){ |
| | | //queryWrapper.like("column", eamEquipment.getColumn()); |
| | | queryWrapper.orderByDesc("e.create_time"); |
| | | }else { |
| | | queryWrapper.orderByDesc("e.create_time"); |
| | | } |
| | | }else { |
| | | queryWrapper.orderByDesc("e.create_time"); |
| | | } |
| | | |
| | | IPage<EamEquipment> ipage = eamEquipmentMapper.queryPageList(page, queryWrapper); |
| | | return ipage; |
| | | } |
| | | |
| | | /** |
| | | * 获取所有的产线id(包含所有上级) |
| | | */ |