package com.template.services.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.template.mapper.SmartWarningMapper; import com.template.model.pojo.SmartWarning; import com.template.model.pojo.SmartWarning; import com.template.mapper.SmartWarningMapper; import com.template.model.result.PageUtils; import com.template.services.SmartWarningService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.StringUtils; import java.time.LocalDate; import java.time.format.DateTimeFormatter; import java.util.List; /** *

* 服务实现类 *

* * @author ceshi * @since 2023-12-04 */ @Service public class SmartWarningServiceImpl extends ServiceImpl implements SmartWarningService { @Autowired private SmartWarningMapper smartWarningMapper; @Override public int insertSmartWarning(SmartWarning sa) { int result = smartWarningMapper.insert(sa); return result; } @Override public int updateSmartWarning(SmartWarning sa) { int result = smartWarningMapper.updateById(sa); return result; } @Override public PageUtils queryPageSmartWarnings(int currentPage, int pageCount, String name,String state) { Page page = new Page<>(currentPage, pageCount); LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.like(ObjectUtils.isNotEmpty(name),SmartWarning::getLocation,name) .eq(ObjectUtils.isNotEmpty(state),SmartWarning::getStatu,state); IPage result = smartWarningMapper.selectPage(page, queryWrapper); return new PageUtils<>(result); } @Override public int deleteSmartWarningById(int id) { int result = smartWarningMapper.deleteById(id); return result; } @Override public SmartWarning getSmartById(int id) { SmartWarning result = smartWarningMapper.selectById(id); return result; } @Override public List warningType() { return smartWarningMapper.warningType(); } @Override public PageUtils pageWarning(int currentPage, int pageCount, String type, String dateTime) { DateTimeFormatter dateTimeFormatter2 = DateTimeFormatter.ofPattern("yyyy-MM-dd"); LocalDate state = LocalDate.parse(dateTime, dateTimeFormatter2); LocalDate end = state.plusDays(1); Page page = new Page<>(currentPage, pageCount); LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); if (!"全部".equals(type)) { queryWrapper.eq(SmartWarning::getType,type); } queryWrapper.between(SmartWarning::getDateTime,state,end) .eq(SmartWarning::getStatu,0) .orderByDesc(SmartWarning::getDateTime); IPage result = smartWarningMapper.selectPage(page, queryWrapper); return new PageUtils<>(result); } }