package com.template.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
@Mapper
public interface ParkingMapper {


    @Select("select is_free,count(1) amount from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id group by pi2.is_free \n" +
            "union all \n" +
            "select 'all' ,count(1)  amount from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id\n")
    List<Map<String,String>> getParkingCount();

    @Select("select sum(pdfs.num_of_total) total,sum(pdfs.num_of_total)-sum(pdfs.number_of_remainder) busy, sum(pdfs.number_of_remainder) fre from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id ")
    List<Map<String,String>> getParkingSpace();

    @Select("select town,count(1) amount from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id group by pi2.town ")
    List<Map<String,String>> getParkingByTown();

    @Select("select pi2.id,pi2.name realname from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id ")
    List<Map<String,String>> getAllParkingInfo();

    @Select("select pi2.open_time,pi2.is_free ,pdfs.num_of_total,pdfs.number_of_remainder,pi2.name  " +
            "from disease_command.parking_data_for_server02 pdfs ,parking_info pi2 \n" +
            "where pdfs .third_open_id =pi2.third_open_id and pi2.id=#{id}")
    List<Map<String,String>> getParkingInfoById(@Param("id") String id);

    @Select("INSERT INTO parking_data_for_server_tmp (day_id,third_open_id,num_of_total,number_of_remainder, `status`,update_time) \n" +
            "SELECT #{dayId},third_open_id,num_of_total,number_of_remainder, `status`,update_time FROM \n" +
            "disease_command.parking_data_for_server02 \n")
    Integer getTrendByTime(@Param("dayId") String dayId);

    @Select("SELECT pdfs.day_id ,pdfs.num_of_total,pdfs.number_of_remainder,pdfs.third_open_id ,pi2.id\n" +
            "            FROM parking_data_for_server_tmp pdfs ,parking_info pi2 \n" +
            "            WHERE pdfs .third_open_id =pi2.third_open_id AND pi2.id=#{id}\n" +
            "            AND pdfs.day_id >#{startTime} AND pdfs.day_id <=#{endTime}")
    List<Map<String,String>> getParkingInfoHis(@Param("id") String id,@Param("startTime") String start,@Param("endTime") String endTime);

}