<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Collabolator_model extends MY_Model
{
	
	protected $table_name = 'tblcollaborator';
	protected $id_name = 'id';

	function __construct()
	{
		parent::__construct();
	}
	function getCollaborator($data)
        {
            $sql="SELECT * FROM ".$this->table_name;
            $data['keyword']='';

            if ($data['keyword'])
            {
            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%') ";
            }
            return $this->db->query($sql." ORDER BY id DESC LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();

        }
        function isExist($data)
        {
            $sql="SELECT COUNT(id) as total FROM ".$this->table_name." WHERE ".$data['field']." = '".$data['value']."' LIMIT 1";
            if ($this->db->query($sql)->row_array()['total']==1)
            {
                return true;
            }
            else
            {
                return false;
            }
            
        }
        function countCollaborator($data)
        {
            $sql="SELECT COUNT(id) as total FROM ".$this->table_name;
            if (isset($data['keyword']))
            {
            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%') ";
            }

            return $this->db->query($sql)->row_array()['total'];
            
        }
}