| | |
|---|
| | | @Mapper |
|---|
| | | public interface HomeMapper { |
|---|
| | | //查询每个笼子的使用情况 |
|---|
| | | @Select("SELECT cage,ROUND(sum(case when state=1 or state=2 or state=3 then 1 else 0 end)/42*100) as cell,42-sum(case when state=1 or state=2 or state=3 then 1 else 0 end) as state FROM `storage_cage` group by cage") |
|---|
| | | @Select("select cage,round((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") |
|---|
| | | List<StorageCage> selectAll(); |
|---|
| | | |
|---|
| | | // 查询1-5笼内层格子状态 |
|---|
