<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class dangnhap_model extends CI_Model
{
	function __construct()
	{
        parent::__construct();
	}
	
	public function member_info($user)
	{
		$this->db->where('bl_active',1);	
		$this->db->where('username',$user);
		$query = $this->db->get('member');
		return $query->row();
	}
	
	public function user_login($email='')
	{
		$this->db->where('lb_email',$email);
		$this->db->where('bl_active',1);	
		$query = $this->db->get('member');
		return $query->row();
	}
	
	public function last_login($member_id,$user_ip)
	{
		$data['dt_login'] = date('Y-m-d H:i:s');
		$data['user_ip'] = $user_ip ;
		$this->db->where('member_id', $member_id) ;
		$this->db->update('member', $data) ;
	}
	
	function mapinfo($rs)
	{
		$user = new stdClass();
		$user->mid = $rs->member_id;
		$user->username = $rs->username;
		$user->fullname = $rs->fullname;
		$user->address = $rs->address;
		$user->phone = $rs->nb_phone;
		$user->image = $rs->lb_image;
		$user->yahoo = $rs->lb_yahoo;
		$user->skype = $rs->lb_skype;
		$user->msn = $rs->lb_msn;
		$user->facebook = $rs->lb_fbook;
		$user->email = $rs->lb_email;
		$user->website = $rs->lb_website;
		$user->gender = $rs->gender;
		$user->last_login = date('Y-m-d');
		$user->ip = rm_duplicate($rs->user_ip);
		$user->level = $rs->nb_level;
		$user->nb_news = $rs->nb_news;
		$user->level = $rs->nb_level;
		$user->town = $rs->town_id;
		$user->is_active = $rs->is_active;
		
		return $user;	
	}
	
	function add_fb_user($id,$email,$name,$link,$gender,$birthday)
	{
		//check user facebook exists
		$this->db->where("fb_id",$id);
		$query = $this->db->get("member");
		$rs = $query->row(); 
		//neu co user, lay info và set login
		if($rs)
		{
			return $rs ;
		}
		else
		{
			//chưa lưu thì lưu lại sau do set login
			$data['fb_id'] = $id;	
			$data['lb_email'] = $email;	
			$data['fullname'] = $name;	
			$data['lb_fbook'] = $link;	
			$data['gender'] = $gender=="male"? 1 : 0;
			$data['dt_create'] = date('Y-m-d H:i:s');
			$data['dt_login'] = date('Y-m-d H:i:s');
			$data['dt_modify'] = date('Y-m-d H:i:s');
			$data['username'] = cr_username($name);	
			$data['password'] = cr_password();	
			$data['user_ip'] = $this->input->ip_address();
			$data['bl_active'] = 1;
			$this->db->insert("member", $data);
			
			//get info user
			$this->db->where("fb_id",$id);
			$query = $this->db->get("member");
			$rs = $query->row();
			return $rs ;
		}
	}
	
	/*function chk_username()
	{
		$this->db->where("fb_id",$id);
		$query = $this->db->get("member");
		$rs = $query->row(); 
	}*/
}
?>