| | |
|---|
| | | import com.github.pagehelper.PageHelper; |
|---|
| | | import com.github.pagehelper.PageInfo; |
|---|
| | | import com.whyc.dto.Response; |
|---|
| | | import com.whyc.mapper.AreaUserMapper; |
|---|
| | | import com.whyc.mapper.AuthiruzeInfMapper; |
|---|
| | | import com.whyc.mapper.LockInfMapper; |
|---|
| | | import com.whyc.mapper.UserInfMapper; |
|---|
| | | import com.whyc.pojo.db_area.AreaUser; |
|---|
| | | import com.whyc.pojo.db_area.AuthIdcard; |
|---|
| | | import com.whyc.pojo.db_area.AuthiruzeInf; |
|---|
| | | import com.whyc.pojo.db_area.LockInf; |
|---|
| | |
|---|
| | | |
|---|
| | | @Autowired(required = false) |
|---|
| | | private UserInfMapper uinfMapper; |
|---|
| | | |
|---|
| | | |
|---|
| | | //查询所有授权信息 |
|---|
| | | public Response getAllAuthInf( String uname, int areaId,int pageNum, int pageSize) { |
|---|
| | |
|---|
| | | //根据mac检测蓝牙锁是否有权限 |
|---|
| | | public Response getAuthByUidAndMac(String mac,String uname) { |
|---|
| | | UserInf uinf=uinfMapper.getUinfByUname(uname); |
|---|
| | | List areaList=areaInfService.getAllAreaUser(uinf.getUid(),uinf.getUrole()); |
|---|
| | | //List areaList=areaInfService.getAllAreaUser(uinf.getUid(),uinf.getUrole()); |
|---|
| | | //获取锁是否在人管理的区域下面 |
|---|
| | | QueryWrapper wrapper=new QueryWrapper(); |
|---|
| | | wrapper.eq("lock_mac",mac.toUpperCase(Locale.ROOT)); |
|---|
| | | wrapper.eq("lock_online",1); |
|---|
| | | wrapper.last("limit 1"); |
|---|
| | | wrapper.in("area_id",areaList); |
|---|
| | | LockInf linf=lockInfMapper.selectOne(wrapper); |
|---|
| | | if(linf==null){ |
|---|
| | | return new Response().set(1,false,"没有权限"); |
|---|
| | |
|---|
| | | return new Response().set(1,auth!=null,auth!=null?"有权限":"没有权限"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //普通用户登录查看自己授权记录-----app |
|---|
| | | //普通用户登录查看自己授权锁记录-----app |
|---|
| | | public Response getAuthByUid(String uname) { |
|---|
| | | UserInf uinf=uinfMapper.getUinfByUname(uname); |
|---|
| | | //UserInf uinf=uinfMapper.getUinfByUname(uname); |
|---|
| | | //查询普通用户对应的区域 |
|---|
| | | QueryWrapper wrapper=new QueryWrapper(); |
|---|
| | | wrapper.eq("uname",uinf.getUname()); |
|---|
| | | wrapper.select("distinct lock_id"); |
|---|
| | | wrapper.eq("uname",uname); |
|---|
| | | wrapper.eq("key_id",0);//蓝牙钥匙 |
|---|
| | | List<AuthiruzeInf> list=mapper.selectList(wrapper); |
|---|
| | | if(list!=null){ |
|---|
| | | for (AuthiruzeInf auth:list) { |
|---|
| | | //根据锁的id查询锁的记录 |
|---|
| | | LockInf linf=lockInfMapper.selectlinfByLockId(auth.getLockId()); |
|---|
| | | auth.setLinf(linf); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return new Response().setII(1,list!=null,list,"普通用户登录查看自己授权记录-----app"); |
|---|
| | | List<Integer> lockIds=list.stream().map(AuthiruzeInf::getLockId) // 提取id |
|---|
| | | .collect(Collectors.toList()); |
|---|
| | | //根据锁的lockIds查询锁的记录 |
|---|
| | | List<LockInf> linfs=lockInfMapper.selectlinfByLockIds(lockIds); |
|---|
| | | return new Response().setII(1,linfs!=null,linfs,"普通用户登录查看自己授权记录-----app"); |
|---|
| | | } |
|---|
| | | } |
|---|
