package com.hxzk.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hxzk.mapper.VoiceTipDao;
import com.hxzk.pojo.TbUser;
import com.hxzk.pojo.TbVoicetip;
import com.hxzk.service.VoIceTipService;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class VoiceTipServiceImpl extends ServiceImpl<VoiceTipDao,TbVoicetip> implements VoIceTipService{
    @Override
    public PageInfo<TbVoicetip> findAll(Integer page, Integer limit) {
        QueryWrapper<TbVoicetip> queryWrapper = new QueryWrapper<>();
        queryWrapper.orderByDesc("addtime");
        PageHelper.startPage(page,limit);
        List<TbVoicetip> cardList = baseMapper.selectList(queryWrapper);
        PageInfo<TbVoicetip> info = new PageInfo<>(cardList);
        return info;
    }

    @Override
    public void addVoice(TbVoicetip voicetip) {
        baseMapper.insert(voicetip);
    }

    @Override
    public void upVoice(TbVoicetip voicetip) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("id",voicetip.getId());
        baseMapper.update(voicetip,queryWrapper);
    }

    @Override
    public void deVoice(Integer id) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("id",id);
        baseMapper.delete(queryWrapper);
    }

    @Override
    public int findTypeVoice(String type) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("warningtype",type);
         return Math.toIntExact(baseMapper.selectCount(queryWrapper));
    }

    @Override
    public TbVoicetip findTypeVoiceSMS(String type) {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("warningtype",type);
        return baseMapper.selectOne(queryWrapper);
    }
}