package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.dto.Response;
import com.whyc.mapper.PageParamMapper;
import com.whyc.pojo.db_param.PageParam;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.Date;
import java.util.List;

@Service
public class PageParamService {

    @Resource
    private PageParamMapper mapper;

    public List<PageParam> getTempParmList() {
        QueryWrapper<PageParam> query = Wrappers.query();
        query.eq("category_id",1);
        query.orderByAsc("id");
        return mapper.selectList(query);
    }


    public Response updateById(PageParam param) {
        param.setUpdateTime(new Date());
        mapper.updateById(param);
        return new Response().setII(1,"修改完成");
    }

    /**
     * 活化周期,单位为 天
     * @return
     */
    public PageParam getActivatePeriod() {
        QueryWrapper<PageParam> query = Wrappers.query();
        query.eq("category_id",2);
        query.last(" limit 1");
        return mapper.selectOne(query);
    }
}