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

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

class Collabolator_model extends MY_Model
{
        
        protected $table_name = 'tblcollabolator';
        protected $id_name = 'id';

        function __construct()
        {
                parent::__construct();
        }
        function getCollaborator($data)
        {
            $sql="SELECT * FROM tblcollaborator";
            $data['keyword']='';

            if ($data['keyword'])
            {
            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
            }
            return $this->db->query($sql." LIMIT ".$data['start'].", ".$data['perpage']."")->result_array();

        }
        function countCollaborator($data)
        {
            $sql="SELECT COUNT(id) as total FROM tblcollaborator";
            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'];
            
        }
}