package com.hxzkmonitor.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
//import cn.hutool.db.Page;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import com.hxzkmonitor.controller.TbEvrydayweiyi2024Controller;
|
import com.hxzkmonitor.mapper.TbCompanyMapper;
|
import com.hxzkmonitor.mapper.TbEquipmentMapper;
|
import com.hxzkmonitor.mapper.TbUserMapper;
|
import com.hxzkmonitor.pojo.*;
|
import com.hxzkmonitor.mapper.TbEvrydayweiyi2024Mapper;
|
import com.hxzkmonitor.service.TbEvrydayweiyi2024Service;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.hxzkmonitor.util.DateUtil;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.security.core.parameters.P;
|
import org.springframework.stereotype.Service;
|
|
import java.util.*;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-08-05
|
*/
|
@Service
|
@RequiredArgsConstructor(onConstructor = @__(@Autowired))
|
public class TbEvrydayweiyi2024ServiceImpl extends ServiceImpl<TbEvrydayweiyi2024Mapper, TbEvrydayweiyi2024> implements TbEvrydayweiyi2024Service {
|
private final TbEvrydayweiyi2024Mapper tbEvrydayweiyi2024Mapper;
|
|
private final TbUserMapper tbUserMapper;
|
|
private final TbEquipmentMapper tbEquipmentMapper;
|
|
private final TbCompanyMapper tbCompanyMapper;
|
|
// @Override
|
// public PageInfo<TbEvrydayweiyi2024> geteveryday(Integer page, Integer limit) {
|
// PageHelper.startPage(page,limit);
|
// QueryWrapper queryWrapper = new QueryWrapper<>();
|
//// queryWrapper.eq("phone",phone);
|
// List<TbEvrydayweiyi2024> list = baseMapper.selectList(queryWrapper);
|
// PageInfo<TbEvrydayweiyi2024> info = new PageInfo<>(list);
|
// return info;
|
//// return baseMapper.selectList(queryWrapper);
|
// }
|
|
@Override
|
public IPage<TbEvrydayweiyi2024> geteveryday(Page page, String keyword, String username, String time, String isdp) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
|
int i1 = (Integer.parseInt(datey.split("-")[2])) - 1;
|
String s = datey.split("-")[0] + "-" + datey.split("-")[1] + "-" + i1;
|
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
if (isdp == "true") {
|
queryWrapper.eq("filename", s);
|
}
|
// if (keyword!=null){
|
// queryWrapper.eq("filename",keyword );
|
// queryWrapper.or("filename",keyword );
|
// }
|
queryWrapper.orderByDesc("addtime");
|
|
IPage<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectPage(page, queryWrapper);
|
for (int i = 0; i < userPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", userPage.getRecords().get(i).getTagid());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
|
if (tbEquipment.size() > 0) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
|
}
|
}
|
}
|
return userPage;
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
|
|
int tb24jiancedataIPagesize = 13;
|
long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
|
long taol = 0;
|
List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
|
for (int i = 0; i < tbEquipment.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
if (isdp == "true") {
|
queryWrapper1.eq("filename", s);
|
}
|
|
// queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
// queryWrapper1.orderByDesc("addtime");
|
userPage = tbEvrydayweiyi2024Mapper.listall(tbUser.getCsname());
|
tb24jiancedataIPagesize+= tbEvrydayweiyi2024Mapper.selectList(queryWrapper1).size();
|
for (int j = 0; j < page.getSize() && curIdx + j < userPage.size(); j++) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.get((int) (curIdx + j)).setCompany(tbCompany.getCompanyname());
|
}
|
// if (tb24jiancedataIPage.size()<page.getSize()){
|
|
// }
|
// tb24jiancedataIPagesize.add(userPage.get((int) (curIdx + j)));
|
|
|
if (Objects.equals(userPage.get((int) (curIdx + j)).getTagid(), tbEquipment.get(i).getTagid())) {
|
tb24jiancedataIPage.add(userPage.get((int) (curIdx + j)));
|
|
}
|
}
|
|
|
if (taol == 0) {
|
taol = userPage.size();
|
}
|
|
}
|
// System.out.println(userPage.size());
|
|
page.setTotal(taol);
|
page.setRecords(tb24jiancedataIPage);
|
return page;
|
}
|
}
|
|
@Override
|
public List<TbEvrydayweiyi2024> geteverydaydp(String username) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
|
int i1 = (Integer.parseInt(datey.split("-")[2])) - 1;
|
String s = datey.split("-")[0] + "-" + datey.split("-")[1] + "-" + i1;
|
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("filename", s);
|
|
queryWrapper.orderByDesc("addtime");
|
|
List<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper);
|
if (userPage.size() > 0) {
|
for (int i = 0; i < userPage.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", userPage.get(i).getTagid());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
|
if (tbEquipment.size() > 0) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.get(i).setCompany(tbCompany.getCompanyname());
|
}
|
userPage.get(i).setOnlie(tbEquipment.get(0).getOnlie());
|
userPage.get(i).setWinmax(tbUser.getWinmax());
|
userPage.get(i).setWinmin(tbUser.getWinmin());
|
|
}
|
}
|
return userPage;
|
} else {
|
QueryWrapper queryWrapper5 = new QueryWrapper<>();
|
queryWrapper5.orderByDesc("addtime");
|
List<TbEvrydayweiyi2024> userPage3 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper5);
|
|
// queryWrapper5.
|
QueryWrapper queryWrapper4 = new QueryWrapper<>();
|
queryWrapper4.eq("filename", userPage3.get(0).getFilename());
|
|
queryWrapper4.orderByDesc("addtime");
|
|
List<TbEvrydayweiyi2024> userPage2 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper4);
|
for (int i = 0; i < userPage2.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", userPage2.get(i).getTagid());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
|
if (tbEquipment.size() > 0) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage2.get(i).setCompany(tbCompany.getCompanyname());
|
}
|
userPage2.get(i).setOnlie(tbEquipment.get(0).getOnlie());
|
userPage2.get(i).setWinmax(tbUser.getWinmax());
|
userPage2.get(i).setWinmin(tbUser.getWinmin());
|
}
|
}
|
return userPage2;
|
}
|
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
|
// long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
|
// long taol = 0;
|
List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
|
|
if (tb24jiancedataIPage.size() == 0) {
|
for (int i = 0; i < tbEquipment.size(); i++) {
|
QueryWrapper queryWrapper5 = new QueryWrapper<>();
|
queryWrapper5.eq("tagid", tbEquipment.get(i).getTagid());
|
queryWrapper5.orderByDesc("addtime");
|
List<TbEvrydayweiyi2024> userPage3 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper5);
|
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
if (userPage3.size() > 0) {
|
queryWrapper1.eq("filename", userPage3.get(0).getFilename());
|
// queryWrapper1.eq("filename",s );
|
queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
queryWrapper.orderByDesc("addtime");
|
|
userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper1);
|
|
for (int j = 0; j < userPage.size(); j++) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.get(j).setCompany(tbCompany.getCompanyname());
|
}
|
userPage.get(j).setOnlie(tbEquipment.get(0).getOnlie());
|
userPage.get(j).setWinmax(tbUser.getWinmax());
|
userPage.get(j).setWinmin(tbUser.getWinmin());
|
tb24jiancedataIPage.add(userPage.get(j));
|
}
|
}
|
|
}
|
return tb24jiancedataIPage;
|
} else {
|
return tb24jiancedataIPage;
|
}
|
|
}
|
}
|
|
@Override
|
public TbEvrydayweiyi2024 getonedesc(String date, String tagid) {
|
return tbEvrydayweiyi2024Mapper.getonedesc(date, tagid);
|
}
|
|
|
@Override
|
public List<TbEvrydayweiyi2024> listx2(String datey, String username, String date1, String date2) {
|
if (username != null) {
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
return tbEvrydayweiyi2024Mapper.listx2(datey, date1, date2);
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
|
long taol = 0;
|
List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
|
for (int i = 0; i < tbEquipment.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
userPage = tbEvrydayweiyi2024Mapper.listx3(datey, tbEquipment.get(i).getTagid(), date1, date2);
|
for (int j = 0; j < userPage.size(); j++) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.get(j).setCompany(tbCompany.getCompanyname());
|
}
|
tb24jiancedataIPage.add(userPage.get(j));
|
}
|
}
|
return tb24jiancedataIPage;
|
}
|
} else {
|
return tbEvrydayweiyi2024Mapper.listx2(datey, date1, date2);
|
}
|
|
}
|
|
@Override
|
public List<TbEvrydayweiyi2024> listx3(String datey, String username, String date1, String date2, String tagid) {
|
if (username != null) {
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
// if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
return tbEvrydayweiyi2024Mapper.listx3(datey, tagid, date1, date2);
|
// }else{
|
// QueryWrapper queryWrapper = new QueryWrapper<>();
|
// queryWrapper.eq("companyid", tbUser.getCsname());
|
// List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
// List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
|
// long taol = 0;
|
// List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
|
// for (int i = 0; i < tbEquipment.size(); i++) {
|
// QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
// queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
// userPage = tbEvrydayweiyi2024Mapper.listx3(datey,tbEquipment.get(i).getTagid(), date1, date2);
|
// for (int j = 0; j < userPage.size(); j++) {
|
// QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
// queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
|
// TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
// if (tbCompany != null) {
|
// userPage.get(j).setCompany(tbCompany.getCompanyname());
|
// }
|
// tb24jiancedataIPage.add(userPage.get(j));
|
// }
|
// }
|
// return tb24jiancedataIPage;
|
// }
|
} else {
|
return tbEvrydayweiyi2024Mapper.listx3(datey, tagid, date1, date2);
|
}
|
|
}
|
|
@Override
|
public IPage<TbEvrydayweiyi2024> searcheveryday(Page page, String keyword, String username, String time) {
|
|
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
if (keyword != null) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("anchorname", keyword);
|
List<TbEquipment> anchorname1 = baseMapper.selectList(queryWrapper3);
|
QueryWrapper queryWrapper4 = new QueryWrapper<>();
|
queryWrapper4.eq("tagid", keyword);
|
List<TbEvrydayweiyi2024> tagid1 = baseMapper.selectList(queryWrapper4);
|
if (tagid1.size() > 0) {
|
|
queryWrapper.eq("tagid", keyword);
|
} else {
|
queryWrapper.eq("anchorname", keyword);
|
}
|
}
|
if (time != null) {
|
int i1 = (Integer.parseInt(time.split("-")[2])) - 1;
|
String s = time.split("-")[0] + "-" + time.split("-")[1] + "-" + i1;
|
queryWrapper.eq("filename", s);
|
|
}
|
queryWrapper.orderByDesc("addtime");
|
IPage<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectPage(page, queryWrapper);
|
for (int i = 0; i < userPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", userPage.getRecords().get(i).getTagid());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
|
if (tbEquipment.size() > 0) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
|
}
|
}
|
}
|
return userPage;
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
|
long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
|
long taol = 0;
|
List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
|
for (int i = 0; i < tbEquipment.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
// queryWrapper.eq("anchorname", keyword);
|
// queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
// QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
if (keyword != null) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("anchorname", keyword);
|
List<TbEquipment> anchorname1 = baseMapper.selectList(queryWrapper3);
|
QueryWrapper queryWrapper4 = new QueryWrapper<>();
|
queryWrapper4.eq("tagid", keyword);
|
List<TbEvrydayweiyi2024> tagid1 = baseMapper.selectList(queryWrapper4);
|
if (tagid1.size() > 0) {
|
|
queryWrapper1.eq("tagid", keyword);
|
} else {
|
queryWrapper1.eq("anchorname", keyword);
|
}
|
}
|
if (time != null) {
|
int i1 = (Integer.parseInt(time.split("-")[2])) - 1;
|
String s = time.split("-")[0] + "-" + time.split("-")[1] + "-" + i1;
|
queryWrapper1.eq("filename", s);
|
}
|
queryWrapper1.orderByDesc("addtime");
|
userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper1);
|
for (int j = 0; j < page.getSize() && curIdx + j < userPage.size(); j++) {
|
QueryWrapper queryWrapper3 = new QueryWrapper<>();
|
queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
|
if (tbCompany != null) {
|
userPage.get((int) (curIdx + j)).setCompany(tbCompany.getCompanyname());
|
}
|
if (Objects.equals(userPage.get((int) (curIdx + j)).getTagid(), tbEquipment.get(i).getTagid())) {
|
tb24jiancedataIPage.add(userPage.get((int) (curIdx + j)));
|
}
|
}
|
if (taol == 0) {
|
taol = userPage.size();
|
}
|
}
|
page.setTotal(taol);
|
page.setRecords(tb24jiancedataIPage);
|
return page;
|
}
|
|
// QueryWrapper<TbEvrydayweiyi2024> queryWrapper = new QueryWrapper<>();
|
// queryWrapper.eq("ip", keyword);
|
// IPage<TbEvrydayweiyi2024> ip = baseMapper.selectPage(page, queryWrapper);
|
// return ip;
|
|
}
|
|
|
}
|
