| | |
|---|
| | | @Mapper |
|---|
| | | public interface HomeMapper { |
|---|
| | | //查询每个笼子的使用情况 |
|---|
| | | @Select("select cage,round(100-(21-sum(state))/21*100) as cell,21-sum(state) as state from (select cage,cell,max(state) as state from storage_cage group by cage,cell) as cages group by cage") |
|---|
| | | @Select("select cage,round(100-(21-sum(if(state>0,1,state)))/21*100) as cell,21-sum(if(state>0,1,state)) as state from (select cage,cell,max(state) as state from storage_cage group by cage,cell) as cages group by cage") |
|---|
| | | List<StorageCage> selectAll(); |
|---|
| | | |
|---|
| | | // 查询10-6笼内层格子状态 |
|---|
