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<PersonDao,TbPerson> implements PersonService{
|
|
@Autowired
|
PersonDao personDao;
|
|
@Override
|
public PageInfo<TbPerson> findAll(Integer page, Integer limit) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
PageHelper.startPage(page,limit);
|
List<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbPerson> findAllAPI() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
List<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<com.hxzk.deo.TbPerson> findpersonSearch(Integer page, Integer limit, com.hxzk.deo.TbPerson person) {
|
PageHelper.startPage(page,limit);
|
List<com.hxzk.deo.TbPerson> cardList = personDao.findAllsearch(person);
|
PageInfo<com.hxzk.deo.TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<com.hxzk.deo.TbPerson> findpersonSearchDepart(com.hxzk.deo.TbPerson person) {
|
List<com.hxzk.deo.TbPerson> cardList = personDao.findAllsearchDepart(person);
|
PageInfo<com.hxzk.deo.TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<com.hxzk.deo.TbPerson> findpersonSearchState(Integer page, Integer limit, com.hxzk.deo.TbPerson person) {
|
PageHelper.startPage(page,limit);
|
List<com.hxzk.deo.TbPerson> cardList = personDao.findAllsearchState(person);
|
PageInfo<com.hxzk.deo.TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<com.hxzk.deo.TbPerson> findAllRenYuanDaPing(Integer page, Integer limit) {
|
PageHelper.startPage(page,limit);
|
List<com.hxzk.deo.TbPerson> cardList = personDao.findAlls();
|
PageInfo<com.hxzk.deo.TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbPerson> findWuZiSearch(Integer page, Integer limit, TbPerson person) {
|
QueryWrapper<TbPerson> 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<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbPerson> findCheLiangSearch(Integer page, Integer limit, TbPerson person) {
|
QueryWrapper<TbPerson> 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<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbPerson> findAllRenYuan(Integer page, Integer limit) {
|
PageHelper.startPage(page,limit);
|
List<TbPerson> cardList = personDao.findPersonAll();
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
|
|
@Override
|
public PageInfo<TbPerson> findAllCheLiang(Integer page, Integer limit) {
|
QueryWrapper<TbPerson> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("baoliu19", "车载标签").or().eq("baoliu19", "车载带屏");
|
PageHelper.startPage(page,limit);
|
List<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbPerson> findAllWuZi(Integer page, Integer limit) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("baoliu19","物资标签");
|
PageHelper.startPage(page,limit);
|
List<TbPerson> cardList = baseMapper.selectList(queryWrapper);
|
PageInfo<TbPerson> 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<TbPersonAndDepartment> findSanWeiOnline() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
return personDao.findAllBuMen2();
|
}
|
|
@Override
|
public List<TbPersonAndDepartment> findSanWeiOffOnline() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
return personDao.findAllBuMen3();
|
}
|
|
@Override
|
public List<TbPersonAndDepartment> getGps() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
List<TbPersonAndDepartment> people = personDao.findAllBuMen();
|
return people;
|
}
|
|
@Override
|
public List<TbPersonAndDepartment> getGPSOffOnLine() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
List<TbPersonAndDepartment> people = personDao.findAllBuMenOffOnline();
|
return people;
|
}
|
|
@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
|
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<TbPerson> 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<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();
|
}
|
}
|
