| | |
|---|
| | | @Select("SELECT case when tier=1 then cage else 0 end as cage,case when tier=1 then state else 0 end as state,sum(case when tier=1 then glasswidth/2750*2 else 0 end) as glasswidth,sum(case when tier=2 then glasswidth/2750*2 else 0 end) as width from storage_cage where cage<=5 group by cage,cell order by cage desc,cell desc") |
|---|
| | | List<StorageCage> selectRack4(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // 根据任务类型查询当前正在出片，进片的玻璃信息 |
|---|
| | | @Select("select * from storage_cage where state=#{task_type}") |
|---|
| | | List<StorageCage> selectinout(@Param("task_type") Integer task_type); |
|---|
| | |
|---|
| | | @Select("select ifnull(max(sequence),0)+1 from out_slice ") |
|---|
| | | Short SelectMaxSquence(); |
|---|
| | | //查询用户权限 |
|---|
| | | @Select("select rp.* from role_permission rp inner join user r on rp.role_id=r.role_id and r.username=#{username} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35)") |
|---|
| | | @Select("select rp.* from role_permission rp inner join user r on rp.role_id=r.role_id and r.username=#{username} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35 or permission_id=36)") |
|---|
| | | List<RolePermission> SelectPermissionByUserName(String username); |
|---|
| | | |
|---|
| | | //根据玻璃完成出片任务 |
|---|
