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.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.hxzkmonitor.mapper.*;
|
import com.hxzkmonitor.pojo.*;
|
import com.hxzkmonitor.service.TbTestdata20240706Service;
|
import com.hxzkmonitor.util.DateUtil;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-08-05
|
*/
|
@Service
|
@RequiredArgsConstructor(onConstructor = @__(@Autowired))
|
public class TbTestdata20240706ServiceImpl extends ServiceImpl<TbTestdata20240706Mapper, TbTestdata20240706> implements TbTestdata20240706Service {
|
private final TbTestdata20240706Mapper TbTestdata20240706Mapper;
|
|
private final TbUserMapper tbUserMapper;
|
|
private final TbEquipmentMapper tbEquipmentMapper;
|
|
private final TbCompanyMapper tbCompanyMapper;
|
|
// @Override
|
// public PageInfo<TbTestdata20240706> geteveryday(Integer page, Integer limit) {
|
// PageHelper.startPage(page,limit);
|
// QueryWrapper queryWrapper = new QueryWrapper<>();
|
//// queryWrapper.eq("phone",phone);
|
// List<TbTestdata20240706> list = baseMapper.selectList(queryWrapper);
|
// PageInfo<TbTestdata20240706> info = new PageInfo<>(list);
|
// return info;
|
//// return baseMapper.selectList(queryWrapper);
|
// }
|
|
@Override
|
public IPage<TbTestdata20240706> everydayxs(Page page, String keyword, String username, String time, String isdp) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyyMMdd");
|
Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
|
IPage<TbTestdata20240706> userPage = TbTestdata20240706Mapper.listall(pages,datey);
|
for (int i = 0; i < userPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
|
if (tbCompany != null) {
|
userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
|
}
|
}
|
return userPage;
|
|
|
}
|
|
@Override
|
public List<TbTestdata20240706> 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<TbTestdata20240706> userPage = TbTestdata20240706Mapper.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());
|
}
|
|
|
}
|
}
|
return userPage;
|
} else {
|
QueryWrapper queryWrapper5 = new QueryWrapper<>();
|
queryWrapper5.orderByDesc("addtime");
|
List<TbTestdata20240706> userPage3 = TbTestdata20240706Mapper.selectList(queryWrapper5);
|
|
// queryWrapper5.
|
QueryWrapper queryWrapper4 = new QueryWrapper<>();
|
queryWrapper4.eq("filename", userPage3.get(0).getAddtime());
|
|
queryWrapper4.orderByDesc("addtime");
|
|
List<TbTestdata20240706> userPage2 = TbTestdata20240706Mapper.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());
|
}
|
}
|
}
|
return userPage2;
|
}
|
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
|
// long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
|
// long taol = 0;
|
List<TbTestdata20240706> 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<TbTestdata20240706> userPage3 = TbTestdata20240706Mapper.selectList(queryWrapper5);
|
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
if (userPage3.size() > 0) {
|
queryWrapper1.eq("filename", userPage3.get(0).getAddtime());
|
// queryWrapper1.eq("filename",s );
|
queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
queryWrapper.orderByDesc("addtime");
|
|
userPage = TbTestdata20240706Mapper.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());
|
}
|
tb24jiancedataIPage.add(userPage.get(j));
|
}
|
}
|
|
}
|
return tb24jiancedataIPage;
|
} else {
|
return tb24jiancedataIPage;
|
}
|
|
}
|
}
|
|
@Override
|
public TbTestdata20240706 getonedesc(String date, String tagid) {
|
return TbTestdata20240706Mapper.getonedesc(date, tagid);
|
}
|
|
|
@Override
|
public List<TbTestdata20240706> listx2(String datey, String username) {
|
if (username != null) {
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
return TbTestdata20240706Mapper.listx2(datey);
|
} else {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("companyid", tbUser.getCsname());
|
List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
|
long taol = 0;
|
List<TbTestdata20240706> userPage = new ArrayList<>();
|
for (int i = 0; i < tbEquipment.size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
userPage = TbTestdata20240706Mapper.listx3(datey, tbEquipment.get(i).getTagid());
|
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 TbTestdata20240706Mapper.listx2(datey);
|
}
|
|
}
|
|
@Override
|
public List<TbTestdata20240706> listx3(String datey, String username,String tagid) {
|
if (username != null) {
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
// if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
return TbTestdata20240706Mapper.listx3(datey, tagid);
|
// }else{
|
// QueryWrapper queryWrapper = new QueryWrapper<>();
|
// queryWrapper.eq("companyid", tbUser.getCsname());
|
// List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
|
// List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
|
// long taol = 0;
|
// List<TbTestdata20240706> userPage = new ArrayList<>();
|
// for (int i = 0; i < tbEquipment.size(); i++) {
|
// QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
// queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
|
// userPage = TbTestdata20240706Mapper.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 TbTestdata20240706Mapper.listx3(datey, tagid);
|
}
|
|
}
|
|
@Override
|
public TbTestdata20240706 getweiyi( String tagid) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy");
|
// Calendar date = Calendar.getInstance();
|
// String date1 = DateUtil.formatDate(calendar.getTime(), "yyyy-MM-dd");
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
|
|
// Calendar calendar = Calendar.getInstance();
|
String dated = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
|
int i1 = (Integer.parseInt(dated.split("-")[2])-1) ;
|
String s = dated.split("-")[0] + "-" + dated.split("-")[1] + "-" + i1;
|
return TbTestdata20240706Mapper.getweiyi(datey, tagid, s);
|
}
|
|
@Override
|
public Map<String, Object> gettagidweiyi( String tagid) {
|
// List<TbTestdata20240706> TbTestdata20240706s = new ArrayList<>();
|
Map<String, Object> result = new HashMap<>();
|
String[] hd = new String[tagid.split(",").length];
|
String[] ed = new String[tagid.split(",").length];
|
String[] nd = new String[tagid.split(",").length];
|
String[] x = new String[tagid.split(",").length];
|
for (int i = 0; i < tagid.split(",").length; i++) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy");
|
// Calendar date = Calendar.getInstance();
|
// String date1 = DateUtil.formatDate(calendar.getTime(), "yyyy-MM-dd");
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
|
|
// Calendar calendar = Calendar.getInstance();
|
String dated = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
|
int i1 = (Integer.parseInt(dated.split("-")[2])-1) ;
|
String s = dated.split("-")[0] + "-" + dated.split("-")[1] + "-" + i1;
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("tagid", tagid.split(",")[i]);
|
TbEquipment tbEquipment = tbEquipmentMapper.selectOne(queryWrapper);
|
|
if (tbEquipment!=null){
|
|
hd[i] = tbEquipment.getHdmm();
|
ed[i] = tbEquipment.getEdmm();
|
nd[i] =tbEquipment.getNdmm();
|
// x[i] = TbTestdata20240706Mapper.getweiyi(datey, tagid.split(",")[i], s).getFilename();
|
}else{
|
hd[i] = "0";
|
ed[i] = "0";
|
nd[i] ="0";
|
// x[i] = "0";
|
}
|
}
|
result.put("ed", ed);
|
result.put("nd", nd);
|
result.put("hd", hd);
|
// result.put("x", x);
|
return result;
|
}
|
|
@Override
|
public IPage<TbTestdata20240706> searcheveryxsday(Page page, String keyword, String username, String time) {
|
Calendar calendar = Calendar.getInstance();
|
String datey = DateUtil.formatDate4(calendar.getTime(), "yyyyMMdd");
|
|
QueryWrapper queryWrapper2 = new QueryWrapper<>();
|
queryWrapper2.eq("username", username);
|
TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
|
if (Objects.equals(tbUser.getRole(), "超级管理员")) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
queryWrapper.orderByDesc("addtime");
|
Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
|
IPage<TbTestdata20240706> userPage = TbTestdata20240706Mapper.seachlistall(pages,datey,keyword);
|
for (int i = 0; i < userPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
|
if (tbCompany != null) {
|
userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
|
}
|
}
|
return userPage;
|
} else {
|
Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
|
IPage<TbTestdata20240706> userPage = TbTestdata20240706Mapper.seachlistallname(pages,datey,keyword, String.valueOf(tbUser.getCsname()));
|
for (int i = 0; i < userPage.getRecords().size(); i++) {
|
QueryWrapper queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
|
TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
|
if (tbCompany != null) {
|
userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
|
}
|
}
|
return userPage;
|
}
|
|
}
|
|
}
|
