From 871d4095b07cedacb7fbef4c38d64982f539c404 Mon Sep 17 00:00:00 2001 From: fei.wang <wf18701153496@163.com> Date: 星期四, 09 五月 2024 15:40:15 +0800 Subject: [PATCH] 测试提交 --- src/main/java/com/flow/service/impl/TbFuwuqiServiceImpl.java | 143 +++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 143 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/flow/service/impl/TbFuwuqiServiceImpl.java b/src/main/java/com/flow/service/impl/TbFuwuqiServiceImpl.java new file mode 100644 index 0000000..578713d --- /dev/null +++ b/src/main/java/com/flow/service/impl/TbFuwuqiServiceImpl.java @@ -0,0 +1,143 @@ +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); + } +} -- Gitblit v1.9.3