<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Customer {
	protected $CI;

	public function __construct() {
		$CI =& get_instance();
		if(!$CI->session->userdata('session_id')){
			$CI->session->set_userdata('session_id', md5(time().rand().time()));
		}
		if(!$CI->session->userdata('currency')){
			$this->setCurrency($id = 1);
		}
	}

	public function login($username, $password){
		 $CI =& get_instance();
		$customer_query = $CI->db->query("SELECT * FROM customer WHERE (email = '" . $CI->db->escape_str($username) . "' OR mobile = '" . $CI->db->escape_str($username) . "') AND password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $CI->db->escape_str($password) . "'))))) AND status = '1'");
		if ($customer_query->num_rows()) {
			$row = $customer_query->row();
			$CI->session->set_userdata('customer_id', $row->id);
			$CI->session->set_userdata('customer_name', $row->name);
			$this->customer_id = $row->id;
			$CI->db->query("UPDATE customer SET ip = '" . $_SERVER['REMOTE_ADDR'] . "' WHERE id = '" . (int)$this->customer_id . "'");

			return true;
		} else {
			return false;
		}
	}

	public function logout() {
		$CI =& get_instance();
		$CI->session->unset_userdata('customer_id');				
		$CI->session->unset_userdata('customer_name');
		$this->customer_id = '';
	}

	public function getId(){
		$CI =& get_instance();
		$customer_id = $CI->session->userdata('customer_id');
		if (!empty($customer_id))
		{
			return (int)$customer_id;
		}
		else{
			return null;
		}
	}

	public function isLogged(){
	 $CI =& get_instance();
		return (bool) $CI->session->userdata('customer_id');
	}

	public function addSession(){
		$CI =& get_instance();
		$CI->session->set_userdata('session_id', md5(time().rand().time()));
	}

	public function getSessionId(){
		$CI =& get_instance();
		$session_id = $CI->session->userdata('session_id');
		if (!empty($session_id)){
			return $session_id;
		}
		return false;
	}

	public function isCategory($slug){
		$CI =& get_instance();
		$customer_query = $CI->db->query("SELECT id, name,catimage, icon, image, banner_image, short_description, description, metatitle, metadescription, metakeyword, canonical,tags,parent_id,Requirement,Deployment,Prototype ,Maintenance FROM category WHERE slug = '" . $slug . "'");
		if ($customer_query->num_rows()) {
		$id = $customer_query->row();
			$data['id'] = $id->id;
			$data['name'] = $id->name;
			$data['heading'] = $id->tags;
			$data['parent_id'] = $id->parent_id;
			$data['short_description'] = $id->short_description;
			$data['description'] = $id->description;
			
				$data['Requirement'] = $id->Requirement;
					$data['Prototype'] = $id->Prototype;
						$data['Deployment'] = $id->Deployment;
							$data['Maintenance'] = $id->Maintenance;
			
			$data['icon'] = $id->icon;
			$data['image'] = $id->image;
				$data['catimage'] = $id->catimage;
			$data['banner_image'] = $id->banner_image;
			$data['metatitle'] = $id->metatitle;
			$data['metadescription'] = $id->metadescription;
			$data['metakeyword'] = $id->metakeyword;
			return $data;
		}
		else{
			return false;
		}
	}

	public function isProduct($slug){
		 $CI =& get_instance();
		$customer_query = $CI->db->query("SELECT id, meta_title, meta_description, meta_keyword FROM rooms WHERE seo = '" . $slug . "'");
		if ($customer_query->num_rows()) {
		$id = $customer_query->row();
			$data['id'] = $id->id;
			$data['metatitle'] = $id->meta_title;
			$data['metadescription'] = $id->meta_description;
			$data['metakeyword'] = $id->meta_keyword;
			return $data;
		}
		else{
			return false;
		}
	}

	public function isPage($slug){
		 $CI =& get_instance();
		$customer_query = $CI->db->query("SELECT id FROM cms WHERE slug = '" . $slug . "'");
		if ($customer_query->num_rows()) {
		$id = $customer_query->row();
			$id = $id->id;
			return $id;
		}
		else{
			return false;
		}
	}

	public function isBlog($slug){
		 $CI =& get_instance();
		$customer_query = $CI->db->query("SELECT id FROM blog WHERE slug = '" . $slug . "'");
		if ($customer_query->num_rows()) {
		$id = $customer_query->row();
			$id = $id->id;
			return $id;
		}
		else{
			return false;
		}
	}

	public function getInfo(){
		$CI =& get_instance();
		$info = $CI->session->userdata('info');
		if (!empty($info)){
			return $info;
		}
		else{
		return null;
		}
	}

	public function removeInfo(){
		$CI =& get_instance();
		$CI->session->unset_userdata('info');
	}

	public function getCategoryTree(){
		$CI =& get_instance();
		$data['categories'] = array();
		$sql = "SELECT id, name, parent_id, image, slug as seo FROM category WHERE parent_id = '0' AND is_addon != '1' AND Cat_type='web' ORDER BY id ASC";
		$query = $CI->db->query($sql);
		if($query->num_rows()){
			foreach($query->result() as $query){
			$children_data = array();
			$children = $CI->db->query("SELECT id, name, image, parent_id, slug as seo FROM category WHERE parent_id = '" .$query->id."' AND Cat_type='web' ORDER BY id ASC");
				foreach($children->result() as $child) {
					$sub_children_data = array();
					$sub_children = $CI->db->query("SELECT id, name, image, parent_id, slug as seo FROM category WHERE parent_id = '" .$child->id."' AND Cat_type='web' ORDER BY id ASC");
					foreach($sub_children->result() as $sub_child) {
						// Level 3
						$sub_children_data[] = array(
							'name'     => $sub_child->name,
							'href'     => $sub_child->seo
						);
					}
					// Level 2
					$children_data[] = array(
						'name'     => $child->name,
						'href'     => $child->seo,
						'children' => $sub_children_data
					);
				}
				// Level 1
				$data['categories'][] = array(
					'name'     => $query->name,
					'children' => $children_data,
					'href'     => $query->seo
				);
		  	}
		}
		return $data['categories'];
	}
	
	
	
	
	public function getCategorygrapTree(){
		$CI =& get_instance();
		$data['categories'] = array();
		$sql = "SELECT id, name, parent_id, image, slug as seo FROM category WHERE parent_id = '0' AND is_addon != '1'  ORDER BY id ASC";
		$query = $CI->db->query($sql);
		if($query->num_rows()){
			foreach($query->result() as $query){
			$children_data = array();
			$children = $CI->db->query("SELECT id, name, image, parent_id, slug as seo FROM category WHERE parent_id = '" .$query->id."' AND Cat_type='grap' ORDER BY id ASC");
				foreach($children->result() as $child) {
					$sub_children_data = array();
					$sub_children = $CI->db->query("SELECT id, name, image, parent_id, slug as seo FROM category WHERE parent_id = '" .$child->id."' AND Cat_type='grap' ORDER BY id ASC");
					foreach($sub_children->result() as $sub_child) {
						// Level 3
						$sub_children_data[] = array(
							'name'     => $sub_child->name,
							'href'     => $sub_child->seo
						);
					}
					// Level 2
					$children_data[] = array(
						'name'     => $child->name,
						'href'     => $child->seo,
						'children' => $sub_children_data
					);
				}
				// Level 1
				$data['categories'][] = array(
					'name'     => $query->name,
					'children' => $children_data,
					'href'     => $query->seo
				);
		  	}
		}
		return $data['categories'];
	}
	
	
	
	
	public function getSubCategory(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT name,slug,image,id FROM category WHERE parent_id = 1 AND status = '1'")->result_array();
		return $query;
	}
	
	public function inCart(){
		$CI =& get_instance();
		$w = $CI->db->query("SELECT COUNT(id) as total FROM cart WHERE (customer_id = '" . (int)$this->getId() . "' AND customer_id != 0) OR session_id = '" . $CI->db->escape_str($this->getSessionId()) . "'")->row();
		return $w->total;
	}
	
	public function inWishlist(){
		$CI =& get_instance();
		$wishlist = $CI->db->query("SELECT COUNT(id) as total FROM wishlist WHERE customer_id = '" . (int)$this->getId() . "'")->row();
		return $wishlist->total;
	}

	public function getAllCurrency(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM currency WHERE status = '1'")->result();
		return $query;
	}
    
    function get_footer_prod(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM product WHERE featured = '1' ORDER BY id DESC LIMIT 8");
		return $query->result();
	}
	
	function get_footer(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM `footer_cont` WHERE id = 1");
		return $query->row();
	}
	
	function get_contact_info(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM `contact_cms` WHERE id = 1");
		return $query->row();
	}
	
	function get_clients(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM `clients`");
		return $query->result();
	}
	
	function get_blogs(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM blog WHERE status = '1' ORDER BY created DESC LIMIT 5");
		return $query->result();
	}
	
	function get_quotes(){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM `quotes` WHERE status ='1'");
		return $query->result();
	}
	
	public function setCurrency($id){
		$CI =& get_instance();
		$query = $CI->db->query("SELECT * FROM currency WHERE id = '" . (int)$id . "'");
		if($query->num_rows()){
			$q = $query->row();
			$CI->session->set_userdata("currency", $id);
			$CI->session->set_userdata("currency_icon", $q->icon);
			$CI->session->set_userdata("currency_rate", $q->price);
			$CI->session->set_userdata("currency_name", $q->name);
			$CI->session->set_userdata("currency_flag", $q->flag);
		}
		else{
			$CI->session->set_userdata("currency", 1);
			$CI->session->set_userdata("currency_icon", '<i class="fa fa-inr"></i>');
			$CI->session->set_userdata("currency_rate", 1);
			$CI->session->set_userdata("currency_name", 'INR');
			$CI->session->set_userdata("currency_flag", '<img src="images/india-flag.jpg">');
		}
		return $CI->session->userdata("currency_name");
	}

	public function getRealRate($price){
		$CI =& get_instance();
		if($CI->session->userdata("currency") == 1){
			$rate = $CI->session->userdata("currency_icon").ceil($price * $CI->session->userdata('currency_rate'));
		} else{
			$rate = $CI->session->userdata("currency_icon").number_format($price * $CI->session->userdata('currency_rate'), 2);
		}
		return $rate;
	}

	public function checkPassword($old){
		$CI =& get_instance();
		$customer_query = $CI->db->query("SELECT * FROM customer WHERE id = '" . $this->getId() . "' AND password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $CI->db->escape_str($old) . "')))))");
		if($customer_query->num_rows()){
			return true;
		}
		else{
			return false;
		}
	}

	function getResizeImage($filename, $width, $height){
		$CI =& get_instance();
		if($filename){
		$filename = explode('/',$filename);
		$directory = $filename[0];
		$filename = $filename[1];
		if(file_exists("thumb/thumb" . $width . "X" . $height . "/" .$filename)){
			$path = "thumb/thumb" . $width. "X" . $height . "/" . $filename;
		}
		else{
			copy($directory."/" . $filename,  "thumb/thumb" . $width . "X" . $height . "/" .$filename);
			$go['source_image'] = "thumb/thumb" . $width . "X" . $height . "/" .$filename;
				$go['maintain_ratio'] = TRUE;
				$go['width'] = $width;
				$go['height'] = $height;
					$CI->image_lib->initialize($go);
					$CI->image_lib->resize();
					$CI->image_lib->clear();
					$path = "thumb/thumb" . $width . "X" . $height . "/" .$filename;
		}
			return $path;
		}
		else{
			return "";
		}
	}
	
	function random_strings($length_of_string) 
	{ 
		// String of all alphanumeric character 
		$str_result = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'; 
	  
		// Shufle the $str_result and returns substring 
		// of specified length 
		return substr(str_shuffle($str_result), 0, $length_of_string); 
	}

	public function getToken($id){
		$CI =& get_instance();
		$customer_query = $CI->db->query("SELECT * FROM customer WHERE id = '". (int)$id ."'");
		foreach($customer_query->result() as $row){
			$this->token = $row->salt;
		}
		if ($this->token)
		{
			return $this->token;
		}
		else{
			return null;
		}
	}
		public function pageMetas($slug){
    $CI =& get_instance();
    $meta_query = $CI->db->query("SELECT * FROM metas WHERE url = '" . $slug . "'")->row();
     if ($meta_query) {
    $metas = $meta_query;
    return $metas;
     }
      else{
        return false;
    }
}
    
	
}
