zhangherong
2025-03-25 801a6ba1bce0de51a75256bc1a2d45e2f61d5056
lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java
@@ -2,9 +2,13 @@
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;
@@ -13,6 +17,7 @@
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;
@@ -91,6 +96,55 @@
        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(包含所有上级)
     */