package com.cloud.count.dao;
import com.cloud.count.model.Config;
import com.cloud.count.model.CountState;
import com.cloud.count.model.People;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;

@Repository
@Mapper
public interface CountDao {
    /**
     * 查询进出信息
     *
     * @return
     */
    @Select("select * from people where timestamp< #{end} and timestamp>#{begin}")
    List<People> listPeoples( @Param("begin") long begin,@Param("end") long end);

    /**
     * 统计进入人数
     *
     * @return
     */
//    @Select("select COALESCE(sum(enters),0) from people where  timestamp BETWEEN #{begin} AND #{end}")
    @Select("SELECT COALESCE(p2.enters-p1.enters,0) FROM (SELECT enters from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT enters from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countInPeople(@Param("begin") long begin,@Param("end") long end,@Param("todayStr") String todayStr);

    /**
     * 统计出去人数
     *
     * @return
     */
   // @Select("select COALESCE(sum(exits),0) from people where timestamp BETWEEN #{begin} AND #{end}")
    @Select("SELECT COALESCE(p2.exits-p1.exits,0) FROM (SELECT exits from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT exits from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countOutPeople( @Param("begin") long begin,@Param("end") long end,@Param("todayStr") String todayStr);

    /**
     * 插入一条People数据
     * @param people
     * @return
     */
    @Insert("INSERT INTO people(dateStr, startTime, endTime, enters,exits,timestamp) VALUES(#{dateStr},#{startTime},#{endTime},#{enters},#{exits},#{timestamp})")
    boolean savePeople(People people);

    @Update("update config set initialTime =#{initialTime},password=#{password},initialPeople=#{initialPeople},correctionPeople=#{correctionPeople},countStartTime=#{countStartTime},init=#{init},cor=#{cor} where id=1")
    boolean updateConfig(Config config);

    @Select("select * from config where id=1")
    Config getConfig();

    @Delete("truncate TABLE people")
    void reset();

//    @Update("update OldNew set oldin =#{oldin},oldout=#{oldout},realoldin=#{realoldin},realoldout=#{realoldout} where id=1")
//    boolean updateOldNew(OldNew OldNew);

//    @Select("select * from OldNew where id=1")
//    OldNew getOldNew();

    @Update("update countstate set baseEnters=#{baseEnters},baseExits=#{baseExits},totalEnters=#{totalEnters},totalExits=#{totalExits},realtimeBaseEnters=#{realtimeBaseEnters},realtimeBaseExits=#{realtimeBaseExits},errorCount=#{errorCount}, baseTime=#{baseTime} where id=1")
    boolean updateCountState(CountState state);

    @Select("select * from countstate where id=1")
    CountState getCountState();
}