| | |
| | | package com.hxzk.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.github.pagehelper.PageHelper; |
| | | import com.github.pagehelper.PageInfo; |
| | | import com.hxzk.deo.TbPersonAndDepartment; |
| | | import com.hxzk.mapper.PersonDao; |
| | | import com.hxzk.pojo.PowerPerson; |
| | | import com.hxzk.pojo.TbPerson; |
| | | import com.hxzk.pojo.TbTag; |
| | | import com.hxzk.pojo.TbWarning; |
| | | import com.hxzk.service.PersonService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | |
| | | @Service |
| | |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | List<TbPerson> cardList = baseMapper.selectList(queryWrapper); |
| | | PageInfo<TbPerson> info = new PageInfo<>(cardList); |
| | | return info; |
| | | } |
| | | |
| | | @Override |
| | | public PageInfo<PowerPerson> findPowerPerson(Integer page, Integer limit) { |
| | | PageHelper.startPage(page,limit); |
| | | List<PowerPerson> cardList = personDao.findPowerPerson(); |
| | | PageInfo<PowerPerson> info = new PageInfo<>(cardList); |
| | | return info; |
| | | } |
| | | |
| | |
| | | @Override |
| | | public PageInfo<TbPerson> findAllRenYuan(Integer page, Integer limit) { |
| | | PageHelper.startPage(page,limit); |
| | | QueryWrapper<TbPerson> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("baoliu19", "融合终端").or().eq("baoliu19", "系统默认").or().eq("baoliu19","lora标签"); |
| | | List<TbPerson> cardList = baseMapper.selectList(queryWrapper); |
| | | List<TbPerson> cardList = personDao.findPersonAll(); |
| | | PageInfo<TbPerson> info = new PageInfo<>(cardList); |
| | | return info; |
| | | } |
| | |
| | | |
| | | @Override |
| | | public TbPerson findtagidPerson(Integer id) { |
| | | QueryWrapper<TbPerson> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("p_tagid",id).or().eq("p_name",id); |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("p_tagid",id); |
| | | return baseMapper.selectOne(queryWrapper); |
| | | } |
| | | |
| | | // @Override |
| | | // public TbPerson findtNamePerson(Integer id) { |
| | | // QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | // queryWrapper.eq("p_name",id); |
| | | // List<TbPerson> personList = baseMapper.selectList(queryWrapper); |
| | | // System.out.println(personList); |
| | | // return baseMapper.selectOne(queryWrapper); |
| | | // } |
| | | @Override |
| | | public Integer findTagOnline() { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPersonAndDepartment> findSanWei() { |
| | | public List<TbPersonAndDepartment> findSanWeiOnline() { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | return personDao.findAllBuMen2(); |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPersonAndDepartment> findSanWeiOffOnline() { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | return personDao.findAllBuMen3(); |
| | | } |
| | | |
| | | @Override |
| | |
| | | @Override |
| | | public List<TbPersonAndDepartment> findfloor(String floor) { |
| | | return personDao.findAllBuMen1(floor); |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPerson> FindFidPersons(String[] FID) { |
| | | LambdaQueryWrapper<TbPerson> queryWrapper = Wrappers.lambdaQuery(TbPerson.class); |
| | | // 构造查询条件 |
| | | queryWrapper.in(TbPerson::getBaoliu39, FID); |
| | | |
| | | // 查询数据库 |
| | | List<TbPerson> resultList = baseMapper.selectList(queryWrapper); |
| | | return resultList; |
| | | } |
| | | |
| | | @Override |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPerson> findpersonAll() { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | return baseMapper.selectList(queryWrapper); |
| | | } |
| | | @Override |
| | | public List<TbPerson> findSanWeiFloorPerson(String baoliu38) { |
| | | QueryWrapper queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("baoliu39",baoliu38); |
| | | queryWrapper.eq("p_online","1"); |
| | | return baseMapper.selectList(queryWrapper); |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPerson> FindShowJianZhu() { |
| | | return personDao.FindShowJianZhu(); |
| | | } |
| | | |
| | | @Override |
| | | public List<TbPerson> FindShowJianZhuStop() { |
| | | return personDao.FindShowJianZhuStop(); |
| | | } |
| | | } |