package com.flow.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.flow.mapper.CardMapper;
|
import com.flow.mapper.TbFuwuqiMapper;
|
import com.flow.pojo.Card;
|
import com.flow.pojo.OperationLog;
|
import com.flow.pojo.TbFuwuqi;
|
import com.flow.service.OperationLogService;
|
import com.flow.service.TbFuwuqiService;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.DateFormat;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.Calendar;
|
import java.util.Date;
|
import java.util.List;
|
|
import static com.baomidou.mybatisplus.extension.toolkit.SimpleQuery.selectList;
|
|
@Service
|
public class TbFuwuqiServiceImpl extends ServiceImpl<TbFuwuqiMapper, TbFuwuqi> implements TbFuwuqiService {
|
|
@Autowired
|
TbFuwuqiMapper tbFuwuqiMapper;
|
|
@Autowired
|
OperationLogService operationLogService;
|
|
@Override
|
public PageInfo<TbFuwuqi> FindTbFuwuqi(Integer page, Integer limit) {
|
PageHelper.startPage(page, limit);
|
List<TbFuwuqi> cardList = this.tbFuwuqiMapper.findAllUsers();
|
PageInfo<TbFuwuqi> info = new PageInfo(cardList);
|
return info;
|
}
|
|
public PageInfo<TbFuwuqi> findTbFuwuqiZi(String Zong, Integer page, Integer limit) {
|
|
PageHelper.startPage(page, limit);
|
List<TbFuwuqi> tbFuwuqiistList = this.tbFuwuqiMapper.findTbFuwuqiZi(Zong);
|
PageInfo<TbFuwuqi> info = new PageInfo(tbFuwuqiistList);
|
return info;
|
}
|
|
public int addTbFuwuqi(TbFuwuqi tbFuwuqi) {
|
OperationLog operationLog = new OperationLog();
|
operationLog.setCaozuotype("新增");
|
operationLog.setCaozuocontent("新增服务器："+tbFuwuqi.getServername());
|
operationLog.setCaozuoname(tbFuwuqi.getCaozuoname());
|
|
operationLogService.addOperationLog(operationLog);
|
return ((TbFuwuqiMapper) this.baseMapper).insert(tbFuwuqi);
|
}
|
|
public int UpdateTbFuwuqi(TbFuwuqi tbFuwuqi) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("id", tbFuwuqi.getId());
|
TbFuwuqi tbFuwuqi1 = (TbFuwuqi)((TbFuwuqiMapper)this.baseMapper).selectOne(queryWrapper);
|
// OperationLog operationLog = new OperationLog();
|
// operationLog.setCaozuotype("修改");
|
// operationLog.setCaozuocontent("修改服务器："+tbFuwuqi1.getServername());
|
// operationLogService.addOperationLog(operationLog);
|
|
return ((TbFuwuqiMapper) this.baseMapper).update(tbFuwuqi, queryWrapper);
|
}
|
|
public int DeleteTbFuwuqi(String id ,String caozuoname) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("id", id);
|
TbFuwuqi tbFuwuqi = new TbFuwuqi();
|
tbFuwuqi.setNone("1");
|
TbFuwuqi tbFuwuqi1 = (TbFuwuqi)((TbFuwuqiMapper)this.baseMapper).selectOne(queryWrapper);
|
OperationLog operationLog = new OperationLog();
|
operationLog.setCaozuotype("删除");
|
operationLog.setCaozuocontent("删除服务器："+tbFuwuqi1.getServername());
|
operationLog.setCaozuoname(caozuoname);
|
|
operationLogService.addOperationLog(operationLog);
|
return ((TbFuwuqiMapper) this.baseMapper).update(tbFuwuqi, queryWrapper);
|
}
|
|
|
public PageInfo<TbFuwuqi> tableSearch(TbFuwuqi tbFuwuqi, int page, int limit) throws Exception {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
PageHelper.startPage(page, limit);
|
PageInfo<TbFuwuqi> info = null;
|
if (tbFuwuqi.getCompany() != "") {
|
if (tbFuwuqi.getCompany().equals("华星智控")) {
|
info = new PageInfo(this.tbFuwuqiMapper.FindSearch(tbFuwuqi.getCompany(),tbFuwuqi.getServername()));
|
} else {
|
queryWrapper.like("company", tbFuwuqi.getCompany());
|
queryWrapper.eq("none", 0);
|
info = new PageInfo(((TbFuwuqiMapper) this.baseMapper).selectList(queryWrapper));
|
}
|
} else {
|
queryWrapper.eq("company", tbFuwuqi.getCompany());
|
queryWrapper.eq("none", 0);
|
info = new PageInfo(((TbFuwuqiMapper) this.baseMapper).selectList(queryWrapper));
|
}
|
|
return info;
|
}
|
|
public List<TbFuwuqi> proxyfindTbFuwuqi() {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("none", 0);
|
|
return ((TbFuwuqiMapper) this.baseMapper).selectList(queryWrapper);
|
}
|
|
public int Updatefuwuqi(TbFuwuqi tbFuwuqi) throws ParseException {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("company", tbFuwuqi.getCompany());
|
TbFuwuqi tbFuwuqi1 = ((TbFuwuqiMapper) this.baseMapper).selectOne(queryWrapper);
|
DateFormat df=new SimpleDateFormat("yyyy-MM-dd");// date format
|
Date date=df.parse(tbFuwuqi1.getEnddate());// parse String to date
|
Calendar calendar=Calendar.getInstance();
|
calendar.setTime(date); // set calender instance to date value
|
calendar.add(Calendar.YEAR,1); // add one year to current
|
System.out.println(df.format(calendar.getTime()));
|
tbFuwuqi.setEnddate(df.format(calendar.getTime()));
|
SimpleDateFormat date2 = new SimpleDateFormat("yyyy-MM-dd");
|
Date endDay = date2.parse(df.format(calendar.getTime()));//结束时间
|
Long starTime = date.getTime();
|
Long endTime = endDay.getTime();
|
Long num11 = endTime - starTime;//时间戳
|
tbFuwuqi.setRemainingdays(+num11/24/60/60/1000+"天");
|
return ((TbFuwuqiMapper)this.baseMapper).update(tbFuwuqi, queryWrapper);
|
}
|
|
public TbFuwuqi ifFuwuqi(TbFuwuqi tbFuwuqi) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("servername", tbFuwuqi.getServername());
|
queryWrapper.eq("none", 0);
|
return (TbFuwuqi)((TbFuwuqiMapper)this.baseMapper).selectOne(queryWrapper);
|
}
|
}
|
