| | |
|---|
| | | @Mapper |
|---|
| | | public interface HomeMapper { |
|---|
| | | //查询每个笼子的使用情况 |
|---|
| | | @Select("SELECT cage,round(round(sum(state)/42,2)*100) as cell,42-sum(state) as state FROM storage_cage group by cage") |
|---|
| | | @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") |
|---|
| | | List<StorageCage> selectAll(); |
|---|
| | | |
|---|
| | | // 查询1-5笼内层格子状态 |
|---|
| | |
|---|
| | | void UpdateCageTask2(@Param("cell") Integer cell); |
|---|
| | | |
|---|
| | | //获取报警信息 |
|---|
| | | @Select("select * from alarmmg where endTime is null") |
|---|
| | | @Select("select id,content,timeon as timeons,endTime from alarmmg where endTime is null") |
|---|
| | | List<alarmmg> SelectAlarmmgInfo(); |
|---|
| | | } |
|---|
