<?php

class Membership_m extends CI_Model {


    function __construct()

    {

        // Call the Model constructor

        parent::__construct();

    }

    
	function invoices_reminder()

	{		

		$sql = 'SELECT * from invoices WHERE datetime_reminder_sent2 is not NULL AND no_reminder is NULL';

	
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function get_old_reminder($company_name='')

	{		

		$sql = 'SELECT * from members_update WHERE  company = "'.$company_name.'"';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->row_array();   	

	    }

		
		return $result;

	}

	
	function updates()

	{		

		$sql = 'SELECT * from imas_membership2 WHERE member_type in (1,2) AND STATUS = 0 AND to_hide = 0 ORDER BY datetime_profile_last_modified DESC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function pcs_updates()

	{		

		$sql = 'SELECT * from imas_membership2 WHERE member_type in (1,2) AND STATUS = 0 AND to_hide = 0 ORDER BY datetime_profile_last_modified DESC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function active_listing()

	{		

		$sql = 'SELECT * from imas_membership2 WHERE status = 0 ORDER BY company ASC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function listing()

	{		

		$sql = 'SELECT * from imas_membership2 ORDER BY company ASC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function info($id)

	{		

		$sql = 'SELECT * from imas_membership2 WHERE id = '.$id;

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->row_array();   	

	    }

		
		return $result;

	}

	
	function check_if_exist($companyid,$email)

	{		

		$sql = 'SELECT * from members WHERE companyid = '.$companyid.' AND email = "'.$email.'"';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->row_array();   	

	    }

		
		return $result;

	}

	
	function membersinfo($companyid)

	{		

		$sql = 'SELECT * from members WHERE companyid = '.$companyid.' ORDER BY name ASC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function membersinfo_by_domain($domain)

	{		

	
		$domains = explode(',',$domain);

	
		if(sizeof($domains) > 1)

		{

			foreach($domains as $dd)

			{

				if($dd != '')

					$q[] = ' email LIKE "%'.$dd.'%" ';

			}

			
			$qq = implode(' OR ',$q);

			
			$sql = 'SELECT * from members WHERE  '.$qq.' ORDER BY name ASC';

			
		} else {

			$sql = 'SELECT * from members WHERE email LIKE "%'.$domain.'%" ORDER BY name ASC';

			
		}

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function membersinfo_count($companyid)

	{		

		$sql = 'SELECT count(id) as total from members WHERE companyid = '.$companyid;

	
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->row_array();   	

	    }

		
		return $result;

	}

	
	function add($data = '') {


		$status = $this->db->insert('imas_membership2', $data);

		
		if ($status) {

			return $this->db->insert_id();

		} else {

			return false;

		}

	}	

	
	function add_member($data = '') {


		$status = $this->db->insert('members', $data);

		
		if ($status) {

			return $this->db->insert_id();

		} else {

			return false;

		}

	}	

		
	function update($id = '', $data = '') {


		$this->db->where('id', $id);


		$status = $this->db->update('imas_membership2', $data);


		if ($status) {

			return true;

		} else {

			return false;

		}

	}

	  
	function update_member($id = '', $data = '') {


		$this->db->where('id', $id);


		$status = $this->db->update('members', $data);


		if ($status) {

			return true;

		} else {

			return false;

		}

	}

	  
	function delete_member($id) {

		
		if($id == '')

			return false;


		$sql = 'DELETE FROM members where id = '.$id;

		
		$query = $this->db->query($sql);

	}

	
	function get_value()

	{		

		$sql = 'SELECT * from member_field_values WHERE meta_key = 7';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function get_company_info($id)

	{		

		$sql = 'SELECT * from imas_membership2 WHERE id = '.$id;

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->row_array();   	

	    }

		
		return $result;

	}

	
	function add_data1($data = '') {


		$status = $this->db->insert('imas_membership2', $data);


		if ($status) {

			return $this->db->insert_id();

		} else {

			return false;

		}


	}

		
	function add_data2($data = '') {


		$status = $this->db->insert('member_field_values', $data);


		if ($status) {

			return $this->db->insert_id();

		} else {

			return false;

		}


	}

	
	function add_data3($data = '') {


		$status = $this->db->insert('members', $data);


		if ($status) {

			return $this->db->insert_id();

		} else {

			return false;

		}


	}

	
	function remove_field($company_id = '',$meta_key) {


		if($company_id != '')

		{			

			$sql = 'DELETE FROM member_field_values where company_id = '.$company_id.' AND meta_key = '.$meta_key;

		}

		
		$query = $this->db->query($sql);


	}

	
	function update_company($id = '', $data = '') {


		$this->db->where('id', $id);


		$status = $this->db->update('imas_membership2', $data);


		if ($status) {

			return true;

		} else {

			return false;

		}

		
	}

	
	function get_company_value($company_id)

	{		

		$sql = 'SELECT * from member_field_values WHERE company_id = '.$company_id.' ORDER BY meta_key+0 ASC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function listing_type($member_type)

	{		

		$sql = 'SELECT * from imas_membership2 WHERE member_type = '.$member_type.' ORDER BY company ASC';

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function designated_admin($companyid)

	{		

		$sql = 'SELECT * from members WHERE permission = 1 AND companyid = '.$companyid;

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
	function get_all_values($company_id)

	{		

		$sql = 'SELECT * from member_field_values WHERE company_id = '.$company_id;

		
		$query = $this->db->query($sql);

	
        if($query->num_rows() == 0)

        {

            $result = array(); 

        }        

        else

        {

            $result = $query->result_array();   	

	    }

		
		return $result;

	}

	
}

?>