package com.happy.dao.impl;

import com.happy.Model.Login;
import com.happy.Model.Users;
import com.happy.dao.UserDao;
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("userDao")
public class UserDaoImpl implements UserDao {

	@Autowired
	private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

	public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
		return namedParameterJdbcTemplate;
	}

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

	public List<Login> log(String card_number, String password){
		String sql="select * from login where card_number=:card_number and password=:password";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("card_number", card_number);
		sps.addValue("password", password);
		List<Login> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Login>(Login.class));
		if(list != null && list.size() >0){
			return list;
		}
		return null;
	}

	public int save(Login login){
        String sql = "update login set login_time=:login_time, expire_time=:expire_time, access_token=:access_token where card_number=:card_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("login_time", login.getLogin_time());
		sps.addValue("expire_time", login.getExpire_time());
		sps.addValue("access_token", login.getAccess_token());
		sps.addValue("card_number", login.getCard_number());
		int num = 0;
		try{
			num = namedParameterJdbcTemplate.update(sql, sps);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return num;
	}

	public List<Login> findByToken(String access_token){
		String sql = "select * from login where access_token=:access_token";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("access_token", access_token);
		List<Login> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Login>(Login.class));
		if(list != null && list.size() >0){
			return list;
		}
		return null;
	}

	public List<Users> selectByStu(String stu_number){
		String sql = "select * from users where stu_number=:stu_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("stu_number", stu_number);
		List<Users> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Users>(Users.class));
		if (list != null && list.size() > 0) {
			return list;
		}
		return null;
	}

	public List<Users> selectByCard_number(String card_number){
		String sql = "select * from users where card_number=:card_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("card_number", card_number);
		List<Users> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Users>(Users.class));
		if (list != null && list.size() > 0) {
			return list;
		}
		return null;
	}

    public int insertUser(Users users){
		String sql = "insert into users(card_number, stu_number, user_name, user_phone, campus, build, dom, id_card, openid) values(:card_number, :stu_number,:user_name, :user_phone, :campus, :build, :dom, :id_card, :openid)";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("card_number", users.getCard_number());
		sps.addValue("stu_number", users.getStu_number());
		sps.addValue("user_name", users.getUser_name());
		sps.addValue("user_phone", users.getUser_phone());
		sps.addValue("campus", users.getCampus());
		sps.addValue("build", users.getBuild());
		sps.addValue("dom", users.getDom());
		sps.addValue("id_card", users.getId_card());
		sps.addValue("openid", users.getOpenid());
		int num = 0;
		try{
			num = namedParameterJdbcTemplate.update(sql, sps);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return num;
	}

	public int delUser(String card_number){
		String sql = "delete from users where card_number=:card_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("card_number", card_number);
		int num = 0;
		try{
			num = namedParameterJdbcTemplate.update(sql, sps);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return num;
	}

	public int updateOpenid(String openid,String stu_number, String card_number){
		String sql = "update users set openid=:openid where stu_number=:stu_number and card_number=:card_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("openid", openid);
		sps.addValue("stu_number", stu_number);
		sps.addValue("card_number", card_number);
		int num = 0;
		try{
			num = namedParameterJdbcTemplate.update(sql, sps);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return num;
	}

	public List<Users> queryByopenid(String openid){
		String sql = "select * from users where openid=:openid";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("openid", openid);
		List<Users> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Users>(Users.class));
		if (list != null && list.size() > 0) {
			return list;
		}
		return null;
	}

	public int updateDom(String campus, String build, String dom, String stu_number){
		String sql = "update users set campus=:campus, build=:build, dom=:dom where stu_number=:stu_number";
		MapSqlParameterSource sps = new MapSqlParameterSource();
		sps.addValue("campus", campus);
		sps.addValue("build", build);
		sps.addValue("dom", dom);
		sps.addValue("stu_number", stu_number);
		int num = 0;
		try{
			num = namedParameterJdbcTemplate.update(sql, sps);
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return num;
	}
}