package com.example.springboot.mapper;
|
import org.apache.ibatis.annotations.*;
|
|
import com.example.springboot.common.Result;
|
import com.example.springboot.entity.StorageCage;
|
import com.example.springboot.entity.StorageTask;
|
import com.example.springboot.entity.StorageCage;
|
|
import java.util.List;
|
|
@Mapper
|
|
public interface SpianMapper {
|
//判断相邻笼子是否有空格
|
@Select("select COUNT(if(a.state1=0,cell,null))as cell from (select *,max(state)as state1 from storage_cage a GROUP BY cage,cell)as a where (a.cage=#{cage1}-1 or a.cage=#{cage1}+1)and if(#{cage1}<6,a.cage>0 and a.cage<6,a.cage>5) GROUP BY cage ORDER BY cell desc LIMIT 1")
|
int selectCage(int cage1);
|
|
//@Select("(select*from storage_cage as a where a.state=0 and cage%2=0 ORDER BY id LIMIT 1)union (select a.* from storage_cage a inner join (select cage,if(shu2=1,shu3,shu5) as gezi from ( select cage, count(case when state1=1 and state2=0 then cell else null end)as shu1, count(case when state1=0 then cell else null end) as shu2, min(case when state1=1 and state2=0 then cell else null end) as shu3, min(case when state1=0 then cell else null end) as shu4, min(case when state1=0 or state2=0 then cell else null end) as shu5 from (select *,max(state) as state1,min(state) as state2 from storage_cage group by cage,cell) as a where cage%2!=0 GROUP BY cage HAVING shu2>1 or (shu2=1 and shu1>0) ) as sss limit 1)as b on a.cage=b.cage and a.cell=b.gezi and a.state=0 order by tier limit 1) ORDER BY id LIMIT 1;")
|
//获取订单号排序的空订单笼子
|
@Select("select cage,COUNT(if(order_id=#{glassid},order_id,null))as orderid from storage_cage where (order_id=#{glassid} or ''='') GROUP BY cage ORDER BY orderid desc; ")
|
List<StorageCage> selectAll(String glassid);
|
|
//判断该笼子是否有合适宽度空格
|
@Select("select COUNT(*),cage,cell,tier from storage_cage where cage=#{cage1} and state=0 and width>=1500 ORDER BY cell,tier")
|
StorageCage selectCage1(int cage1);
|
|
//@Update("update longzi set glass_id = #{glass_id}, width = #{width}, state = #{state} where cell = #{cell}")
|
@Update("update longzi set glass_id =123, width =1600, state =1 where cell =24")
|
void update();
|
|
@Insert("insert into storage_task(task_type,task_state,shelf_rack,load_rack)values(#{storage_task},#{task_state},#{shelf_rack},#{load_rack})")
|
void insert(StorageTask storageTask);
|
|
//出片任务查询
|
@Select("select cage,cell,tier,glasswidth from storage_cage as a where a.order_id=#{orderId} and state=1 order by cage desc,tier desc,cell desc LIMIT 1")
|
StorageCage selectOut(String orderId);
|
//判断出片为1时，是否可直接出片
|
@Select("select state from storage_cage where cage=#{cage} and cell=#{cell} and tier=2;")
|
int selectGlassState(int cage,int cell);
|
//判断该调拨的笼子
|
@Select("select cage,cell,max(state)as shu from storage_cage where width>=#{width} and cage>#{cage1} and cage<#{cage2} GROUP BY cage,cell HAVING shu=0 order by abs(#{cage} - cage) limit 1;")
|
StorageCage selectGlassCage(int cage,double width,int cage1,int cage2);
|
|
// @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})")
|
// void insert (Spian spian);
|
|
}
|
