Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes

严智鑫

2024-07-25 8a76767b0a7ad271c8487a02063590b956deb5df

 hangzhoumesParent/moduleService/GlassStorageModule/src/main/java/com/mes/shelfrack/service/impl/ShelfRackServiceImpl.java

@@ -1,14 +1,20 @@
package com.mes.shelfrack.service.impl;



import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.core.toolkit.Wrappers;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import com.github.yulichang.toolkit.JoinWrappers;

import com.mes.common.config.Const;

import com.mes.rawusage.entity.RawUsage;

import com.mes.shelfrack.mapper.ShelfRackMapper;

import com.mes.shelfrack.entity.ShelfRack;

import com.mes.shelfrack.service.ShelfRackService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;



import java.util.List;

import java.util.Map;



/**

 * @author system

@@ -26,6 +32,29 @@
        return shelfRackMapper.selectList(query);

    }



//

//    public void yourMethodName() {

//        List<Map<String, Object>> resultList = shelfRackMapper.selectMaps(

//                new LambdaQueryWrapper<ShelfRack>()

//                        .select(ShelfRack::getNumber, RawUsage::getRawType, RawUsage::getRawWidth,

//                                RawUsage::getRawHeight, RawUsage::getRawThickness, ShelfRack::getModTime,

//                                ShelfRack::getEnableState, RawUsage::getPieces, RawUsage::getLeftPieces,

//                                "(datediff(now(), raw_usage.create_time)) as rukuTime",

//                                "(concat(if(ROUND(raw_usage.left_pieces / #{param1} * 100, 0) < 20, 20, ROUND(raw_usage.left_pieces / #{param1} * 100, 0)), '%')) as bfb")

//                        .leftJoin(RawUsage.class, RawUsage::getId, ShelfRack::getRawPackageId)

//                        .orderByAsc(ShelfRack::getNumber)

//        );

//

//        // Process resultList as needed

//    }







    @Override

    public  List<Map<String, Object>> selectshelf_rack() {

        return baseMapper.selectshelf_rack();

    }







}