package com.hxzk.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; 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.TbPerson; import com.hxzk.pojo.TbTag; import com.hxzk.service.PersonService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class PersonServiceImpl extends ServiceImpl implements PersonService{ @Autowired PersonDao personDao; @Override public PageInfo findAll(Integer page, Integer limit) { QueryWrapper queryWrapper = new QueryWrapper<>(); PageHelper.startPage(page,limit); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findAllAPI() { QueryWrapper queryWrapper = new QueryWrapper<>(); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findpersonSearch(Integer page, Integer limit, com.hxzk.deo.TbPerson person) { PageHelper.startPage(page,limit); List cardList = personDao.findAllsearch(person); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findpersonSearchDepart(com.hxzk.deo.TbPerson person) { List cardList = personDao.findAllsearchDepart(person); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findpersonSearchState(Integer page, Integer limit, com.hxzk.deo.TbPerson person) { PageHelper.startPage(page,limit); List cardList = personDao.findAllsearchState(person); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findAllRenYuanDaPing(Integer page, Integer limit) { PageHelper.startPage(page,limit); List cardList = personDao.findAlls(); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findWuZiSearch(Integer page, Integer limit, TbPerson person) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu19", "物资标签").and(qw -> qw.like("p_tagid", person.getPTagid()).or().like("p_name", person.getPTagid())); PageHelper.startPage(page,limit); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findCheLiangSearch(Integer page, Integer limit, TbPerson person) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.and(qw -> qw.eq("baoliu19", "车载带屏").or().eq("baoliu19", "车载标签")).and(qw -> qw.like("p_tagid", person.getPTagid()).or().like("p_name", person.getPTagid())); PageHelper.startPage(page,limit); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findAllRenYuan(Integer page, Integer limit) { PageHelper.startPage(page,limit); QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu19", "融合终端").or().eq("baoliu19", "系统默认").or().eq("baoliu19","lora标签"); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findAllCheLiang(Integer page, Integer limit) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu19", "车载标签").or().eq("baoliu19", "车载带屏"); PageHelper.startPage(page,limit); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public PageInfo findAllWuZi(Integer page, Integer limit) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu19","物资标签"); PageHelper.startPage(page,limit); List cardList = baseMapper.selectList(queryWrapper); PageInfo info = new PageInfo<>(cardList); return info; } @Override public TbPerson findIdPerson(Integer id) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("id",id); return baseMapper.selectOne(queryWrapper); } @Override public TbPerson findtagidPerson(Integer id) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("p_tagid",id).or().eq("p_name",id); return baseMapper.selectOne(queryWrapper); } // @Override // public TbPerson findtNamePerson(Integer id) { // QueryWrapper queryWrapper = new QueryWrapper<>(); // queryWrapper.eq("p_name",id); // List personList = baseMapper.selectList(queryWrapper); // System.out.println(personList); // return baseMapper.selectOne(queryWrapper); // } @Override public Integer findTagOnline() { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("p_online",1); return Math.toIntExact(baseMapper.selectCount(queryWrapper)); } @Override public List findSanWei() { QueryWrapper queryWrapper = new QueryWrapper<>(); return personDao.findAllBuMen2(); } @Override public List getGps() { QueryWrapper queryWrapper = new QueryWrapper<>(); List people = personDao.findAllBuMen(); return people; } @Override public List getGPSOffOnLine() { QueryWrapper queryWrapper = new QueryWrapper<>(); List people = personDao.findAllBuMenOffOnline(); return people; } @Override public List findfloor(String floor) { return personDao.findAllBuMen1(floor); } @Override public int findTagidPerson(String tagid) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("p_tagid",tagid); return Math.toIntExact(baseMapper.selectCount(queryWrapper)); } @Override public int TeShuUpdate(TbPerson person) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("p_tagid",person.getPTagid()); return baseMapper.update(person,queryWrapper); } @Override public int updateBuMenIcon(TbPerson person) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("p_department",person.getPDepartment()); return baseMapper.update(person,queryWrapper); } @Override public List findpergather() { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.gt("baoliu35",0); return baseMapper.selectList(queryWrapper); } @Override public TbPersonAndDepartment findOnePerson(TbPersonAndDepartment person) { return personDao.findOnePerson(person); } @Override public List findpersonAll() { QueryWrapper queryWrapper = new QueryWrapper<>(); return baseMapper.selectList(queryWrapper); } @Override public List findSanWeiFloorPerson(String baoliu38) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu39",baoliu38); queryWrapper.eq("p_online","1"); return baseMapper.selectList(queryWrapper); } }