| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.github.yulichang.query.MPJQueryWrapper; |
|---|
| | | import com.github.yulichang.wrapper.MPJAbstractLambdaWrapper; |
|---|
| | | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
|---|
| | | import com.github.yulichang.query.MPJQueryWrapper; |
|---|
| | | import com.mes.downstorage.entity.DownStorageCage; |
|---|
| | | |
|---|
| | | import com.mes.downstorage.entity.DownStorageCageDetails; |
|---|
| | | import com.mes.downstorage.mapper.DownStorageCageDetailsMapper; |
|---|
| | | import com.mes.downstorage.mapper.DownStorageCageMapper; |
|---|
| | | |
|---|
| | | import com.mes.downstorage.service.DownStorageCageDetailsService; |
|---|
| | | import com.mes.glassinfo.entity.GlassInfo; |
|---|
| | | import lombok.extern.slf4j.Slf4j; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | |
|---|
| | | import javax.annotation.Resource; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | @Slf4j |
|---|
| | | @Service |
|---|
| | | public class DownStorageCageDetailsServiceImpl extends ServiceImpl<DownStorageCageDetailsMapper, DownStorageCageDetails> implements DownStorageCageDetailsService { |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Autowired |
|---|
| | | private DownStorageCageDetailsMapper downStorageCageDetailsMapper; |
|---|
| | | @Override |
|---|
| | | public void addDownStorageCageDetails(DownStorageCageDetails details) { |
|---|
| | | this.save(details); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | //修改理片笼内信息 功能：对笼内栅格玻璃 【添加/删除/更换】 |
|---|
| | | public boolean updatedownStorageCageDetails(DownStorageCageDetails details){ |
|---|
| | | baseMapper.updateById(details); |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<DownStorageCageDetails> CacheOut(int start, int end) { |
|---|
| | | log.info("单片情况根据传入的工位查询符合按照大小出片的小片"); |
|---|
| | | return downStorageCageDetailsMapper.selectJoinList( |
|---|
| | | DownStorageCageDetails.class, new MPJQueryWrapper<DownStorageCageDetails>() |
|---|
| | | .select("t.*") |
|---|
| | | .leftJoin("(SELECT t1.* FROM down_storage_cage_details t1 " |
|---|
| | | + "JOIN (SELECT flow_card_id, MAX(width) AS max_width FROM glass_info GROUP BY flow_card_id) t " |
|---|
| | | + "ON t1.flow_card_id = t.flow_card_id WHERE t1.width = t.max_width) t3" |
|---|
| | | + " ON t.glass_id = t3.glass_id") |
|---|
| | | .leftJoin("down_workstation t4 ON t3.flow_card_id = t4.flow_card_id") |
|---|
| | | .isNull(Boolean.parseBoolean("t.glass_id"), "SELECT glass_id FROM down_glass_info") |
|---|
| | | .between("t4.workstation_id", start, end) |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
