source: pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php @ 371

<?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']."%') ";
            }
            $order="";
            if ($data['sorting_order'] != "sorting")
            {
                if ($data['sorting_field'] != "money")
                {
                $sort="DESC";
                if ($data['sorting_order']=="sorting_asc") $sort = "ASC";
                $order="ORDER BY ".$data['sorting_field']." ".$sort;
                }
            }
           
            return $this->db->query($sql." ".$order." 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'];
            
        }
}