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.mapper.TbCompanyMapper;
|
import com.hxzkmonitor.mapper.TbUserMapper;
|
import com.hxzkmonitor.pojo.TbCompany;
|
import com.hxzkmonitor.pojo.TbGuangbo;
|
import com.hxzkmonitor.mapper.TbGuangboMapper;
|
import com.hxzkmonitor.pojo.TbUser;
|
import com.hxzkmonitor.service.TbGuangboService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2025-04-09
|
*/
|
@Service
|
@RequiredArgsConstructor(onConstructor = @__(@Autowired))
|
public class TbGuangboServiceImpl extends ServiceImpl<TbGuangboMapper, TbGuangbo> implements TbGuangboService {
|
|
|
private final TbUserMapper tbUserMapper;
|
|
private final TbCompanyMapper tbCompanyMapper;
|
|
|
@Override
|
public List<TbGuangbo> getallguangbo(String username, String phone) {
|
QueryWrapper queryWrapperu = new QueryWrapper<>();
|
queryWrapperu.eq("username",username);
|
queryWrapperu.eq("adminphone",phone);
|
TbUser tbUser= tbUserMapper.selectOne(queryWrapperu);
|
QueryWrapper<TbGuangbo> queryWrapper = new QueryWrapper<>();
|
if (!Objects.equals(tbUser.getRole(), "超级管理员")){
|
queryWrapper.eq("company",tbUser.getCsname());
|
}
|
System.out.println(tbUser.getCaname());
|
List<TbGuangbo> guangbos = baseMapper.selectList(queryWrapper);
|
// queryWrapper.eq("type",1);
|
// queryWrapper.orderByDesc("jxtime");
|
// queryWrapper.last("LIMIT 20");
|
return baseMapper.selectList(queryWrapper);
|
|
}
|
|
|
|
@Override
|
public IPage<TbGuangbo> searchGuangbo(Page page, String keyword) {
|
QueryWrapper<TbGuangbo> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("tagid", keyword);
|
queryWrapper.orderByDesc("addtime");
|
IPage<TbGuangbo> ip = baseMapper.selectPage(page, queryWrapper);
|
return ip;
|
}
|
|
@Override
|
public Integer delGuangbo(Integer id) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("id", id);
|
return baseMapper.delete(queryWrapper);
|
}
|
|
@Override
|
public Integer addorupGuangbo(TbGuangbo tbGuangbo) {
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
tbGuangbo.setAddtime(formatter.format(date));
|
if (tbGuangbo.getId() != null) {
|
return baseMapper.updateById(tbGuangbo);
|
} else {
|
return baseMapper.insert(tbGuangbo);
|
}
|
}
|
|
@Override
|
public IPage<TbGuangbo> getGuangboPage(Page page) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.orderByDesc("addtime");
|
IPage<TbGuangbo> GuangboPage = baseMapper.selectPage(page, queryWrapper);
|
|
for (int i = 0; i < GuangboPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("id", GuangboPage.getRecords().get(i).getCompany());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
|
if (tbCompany != null) {
|
GuangboPage.getRecords().get(i).setCompanyname(tbCompany.getCompanyname());
|
}
|
}
|
return GuangboPage;
|
}
|
|
@Override
|
public List<String> getGuangbo(String query) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.like("tagid", query);
|
List<TbGuangbo> voicetips = baseMapper.selectList(queryWrapper);
|
List<String> strings = new ArrayList<>();
|
for (int i = 0; i < voicetips.size(); i++) {
|
strings.add(voicetips.get(i).getTagid());
|
}
|
|
return strings;
|
}
|
|
|
@Override
|
public List<String> getGuangbofive() {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.orderByDesc("addtime");
|
queryWrapper.last("LIMIT 5");
|
List<TbGuangbo> voicetips = baseMapper.selectList(queryWrapper);
|
List<String> strings = new ArrayList<>();
|
for (int i = 0; i < voicetips.size(); i++) {
|
strings.add(voicetips.get(i).getTagid());
|
}
|
|
return strings;
|
}
|
}
|
