|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/laciasmara.com/public_html/shop/application/models/ |
Upload File : |
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Subscriber_group_m extends MY_Model
{
protected $table = 'subscriber_groups';
protected $fillable = array('name', 'description', 'status');
public function get_all_with_count()
{
$this->db->select('sg.*, COUNT(sgm.subscriber_id) as subscriber_count');
$this->db->from($this->table . ' sg');
$this->db->join('subscriber_group_members sgm', 'sg.id = sgm.group_id', 'left');
$this->db->group_by('sg.id');
$query = $this->db->get();
return $query->result_array();
}
/**
* Get group member count
*/
public function get_member_count($group_id)
{
$this->db->where('group_id', $group_id);
return $this->db->count_all_results('subscriber_group_members');
}
}