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.entity.request.RawUsageAndShelfRack;
|
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
|
* @since 2024-07-09 14:51:27
|
*/
|
@Service
|
public class ShelfRackServiceImpl extends ServiceImpl<ShelfRackMapper, ShelfRack> implements ShelfRackService {
|
|
@Autowired
|
private ShelfRackMapper shelfRackMapper;
|
|
@Override
|
public List<ShelfRack> findList(ShelfRack params){
|
LambdaQueryWrapper<ShelfRack> query = Wrappers.lambdaQuery(ShelfRack.class);
|
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<RawUsageAndShelfRack> selectshelf_rack() {
|
return baseMapper.selectshelf_rack();
|
}
|
|
|
|
}
|
