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);
    }
}