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.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 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); List cardList = personDao.findPersonAll(); 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); 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 findSanWeiOnline() { QueryWrapper queryWrapper = new QueryWrapper<>(); return personDao.findAllBuMen2(); } @Override public List findSanWeiOffOnline() { QueryWrapper queryWrapper = new QueryWrapper<>(); return personDao.findAllBuMen3(); } @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 List FindFidPersons(String[] FID) { LambdaQueryWrapper queryWrapper = Wrappers.lambdaQuery(TbPerson.class); // 构造查询条件 queryWrapper.in(TbPerson::getBaoliu39, FID); // 查询数据库 List resultList = baseMapper.selectList(queryWrapper); return resultList; } @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 findSanWeiFloorPerson(String baoliu38) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("baoliu39",baoliu38); queryWrapper.eq("p_online","1"); return baseMapper.selectList(queryWrapper); } @Override public List FindShowJianZhu() { return personDao.FindShowJianZhu(); } @Override public List FindShowJianZhuStop() { return personDao.FindShowJianZhuStop(); } }