package com.hxzkappboot.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.hxzkappboot.mapper.TbPersonMapper;
import com.hxzkappboot.pojo.*;
import com.hxzkappboot.service.TbPersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
*
* 服务实现类
*
*
* @author wangfei
* @since 2024-03-08
*/
@Service
public class TbPersonServiceImpl extends ServiceImpl implements TbPersonService {
@Autowired
TbPersonMapper personDao;
@Override
public TbPerson findIdPerson(String name,String company) {
// QueryWrapper queryWrapper = new QueryWrapper<>();
//
// queryWrapper.eq("p_name",name);
return personDao.findOnePerson(name,company);
}
@Override
public TbPerson upTag() {
// QueryWrapper queryWrapper = new QueryWrapper<>();
// queryWrapper.eq("id",id);
return personDao.upTag();
// return baseMapper.selectOne(queryWrapper);
}
@Override
public TbPerson acquisition(String baoliu3,String company) {
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.eq("p_tagid",baoliu3);
queryWrapper.eq("company",company);
return baseMapper.selectOne(queryWrapper);
}
@Override
public TbPerson upperson(String baoliu3,String baoliu38,String phone) {
// TbPerson tbPerson = new TbPerson();
QueryWrapper queryWrapper = new QueryWrapper<>();
System.out.println("打印数据===========》》》》》》》》》》》》》》");
System.out.println(baoliu3);
queryWrapper.eq("p_tagid",baoliu3);
TbPerson tbPerson = baseMapper.selectOne(queryWrapper);
System.out.println(tbPerson);
tbPerson.setBaoliu38(baoliu38);
tbPerson.setPPhone(phone);
baseMapper.updateById(tbPerson);
return tbPerson;
}
@Override
public List getGps(String company) {
List people = personDao.findAllBuMen(company);
return people;
}
@Override
public List getGPSCesium(String company) {
List people = personDao.findAllBuMenCesium(company);
return people;
}
@Override
public IPage findAll(Page page, String objectid,String company) {
QueryWrapper queryWrapper = new QueryWrapper<>();
// queryWrapper.eq("status","未处理");
if (objectid!=null){
String output = objectid.toUpperCase();//将小写字母转成大写字母
queryWrapper.eq("p_tagid",output);
}
queryWrapper.eq("company",company);
queryWrapper.orderByDesc("p_addtiem");
IPage CompanyPage = baseMapper.selectPage(page, queryWrapper);
return CompanyPage;
}
@Override
public Integer findonline(String company) {
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.eq("company",company);
queryWrapper.eq("p_online",1);
List CompanyPage = baseMapper.selectList(queryWrapper);
return CompanyPage.size();
}
@Override
public Integer findoffline(String company) {
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.eq("company",company);
queryWrapper.ne("p_online",1);
List CompanyPage = baseMapper.selectList(queryWrapper);
return CompanyPage.size();
}
@Override
public TbPerson findtagidPerson(String id) {
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.eq("p_tagid",id);
return baseMapper.selectOne(queryWrapper);
}
}