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;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-03-08
|
*/
|
@Service
|
public class TbPersonServiceImpl extends ServiceImpl<TbPersonMapper, TbPerson> 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<TbPersonAndDepartment> getGps(String company) {
|
List<TbPersonAndDepartment> people = personDao.findAllBuMen(company);
|
return people;
|
}
|
|
@Override
|
public List<PersonCesium> getGPSCesium(String company) {
|
List<PersonCesium> people = personDao.findAllBuMenCesium(company);
|
return people;
|
}
|
|
@Override
|
public IPage<TbPerson> 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<TbPerson> 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<TbAchor> 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<TbAchor> 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);
|
}
|
}
|
