package com.hxzkmonitor.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.hxzkmonitor.pojo.TbDuanxin;
|
import com.hxzkmonitor.pojo.TbDuanxin;
|
import com.hxzkmonitor.mapper.TbDuanxinMapper;
|
import com.hxzkmonitor.pojo.TbGuangbo;
|
import com.hxzkmonitor.service.TbDuanxinService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import org.springframework.stereotype.Service;
|
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-08-22
|
*/
|
@Service
|
public class TbDuanxinServiceImpl extends ServiceImpl<TbDuanxinMapper, TbDuanxin> implements TbDuanxinService {
|
@Override
|
public IPage<TbDuanxin> searchDuanxin(Page page, String keyword) {
|
QueryWrapper<TbDuanxin> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("type", keyword);
|
queryWrapper.orderByDesc("addtime");
|
QueryWrapper<TbDuanxin> queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("manager", keyword);
|
queryWrapper.orderByDesc("addtime");
|
List<TbDuanxin> tagid1 = baseMapper.selectList(queryWrapper);
|
List<TbDuanxin> alarmname1 = baseMapper.selectList(queryWrapper2);
|
|
if (tagid1.size() > 0) {
|
IPage<TbDuanxin> tagid = baseMapper.selectPage(page, queryWrapper);
|
return tagid;
|
} else if (alarmname1.size() > 0) {
|
IPage<TbDuanxin> alarmname = baseMapper.selectPage(page, queryWrapper2);
|
return alarmname;
|
} else {
|
return null;
|
}
|
|
}
|
|
@Override
|
public Integer delDuanxin(Integer id) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("id", id);
|
return baseMapper.delete(queryWrapper);
|
}
|
|
@Override
|
public Integer addorupDuanxin(TbDuanxin tbDuanxin) {
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
tbDuanxin.setAddtime(formatter.format(date));
|
if (tbDuanxin.getId() != null) {
|
return baseMapper.updateById(tbDuanxin);
|
} else {
|
return baseMapper.insert(tbDuanxin);
|
}
|
}
|
|
@Override
|
public IPage<TbDuanxin> getDuanxinPage(Page page) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.orderByDesc("addtime");
|
IPage<TbDuanxin> userPage = baseMapper.selectPage(page, queryWrapper);
|
return userPage;
|
}
|
|
@Override
|
public List<String> getDuanxin(String query) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.like("phone", query);
|
List<TbDuanxin> voicetips = baseMapper.selectList(queryWrapper);
|
List<String> strings = new ArrayList<>();
|
for (int i = 0; i < voicetips.size(); i++) {
|
strings.add(voicetips.get(i).getPhone());
|
}
|
|
return strings;
|
}
|
|
@Override
|
public List<String> getDuanxinfive( ) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
// queryWrapper.like("phone", query);
|
queryWrapper.orderByDesc("addtime");
|
queryWrapper.last("LIMIT 5");
|
List<TbDuanxin> voicetips = baseMapper.selectList(queryWrapper);
|
List<String> strings = new ArrayList<>();
|
for (int i = 0; i < voicetips.size(); i++) {
|
strings.add(voicetips.get(i).getPhone());
|
}
|
|
return strings;
|
}
|
}
|
