package com.happy.dao.impl;

import com.happy.Model.Build_elec;
import com.happy.Model.Consume;
import com.happy.dao.ElecDao;
import org.apache.commons.fileupload.util.LimitedInputStream;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository("ElecDao")
public class ElecDaoImpl implements ElecDao {

    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
        return namedParameterJdbcTemplate;
    }

    public void setNamedParameterJdbcTemplate(
            NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

    public List<Build_elec> querySchool(){
        String sql = "select distinct school as school from `build_elec`;";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        List<Build_elec> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Build_elec>(Build_elec.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

    public List<Build_elec> queryBuild(String school){
        String sql = "select distinct build as build from `build_elec` where school=:school;";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("school", school);
        List<Build_elec> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Build_elec>(Build_elec.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

    public List<Build_elec> queryFloors(String school, String build){
        String sql = "select distinct floors as floors from `build_elec` where school=:school and build=:build;";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("school", school);
        sps.addValue("build", build);
        List<Build_elec> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Build_elec>(Build_elec.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

    public List<Build_elec> queryDom(String school, String build, String floors){
        String sql = "select distinct dom as dom from `build_elec` where school=:school and build=:build and floors=:floors;";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("school", school);
        sps.addValue("build", build);
        sps.addValue("floors", floors);
        List<Build_elec> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Build_elec>(Build_elec.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

    public List<Build_elec> queryUser_id(String school, String dom){
        String sql = "select * from `build_elec` where school=:school and dom=:dom;";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("school", school);
        sps.addValue("dom", dom);
        List<Build_elec> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Build_elec>(Build_elec.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }
}