/home/edulekha/crm.edulekha.com/application/services/LeadProfileBadges.php
<?php
namespace app\services;
defined('BASEPATH') or exit('No direct script access allowed');
class LeadProfileBadges
{
protected $leadId;
protected $CI;
protected $staffId;
public function __construct($leadId)
{
$this->leadId = $leadId;
$this->staffId = get_staff_user_id();
$this->CI = &get_instance();
}
public function getCount($feature)
{
if (method_exists($this, $feature)) {
$count = $this->{$feature}();
}
$count = hooks()->apply_filters('lead_tab_badge_count', $count, [
'feature' => $feature,
'lead_id' => $this->leadId,
]);
return $count;
}
/**
* Get the total notes for the lead
*
* @return int
*/
public function notes()
{
$this->CI->db->where('rel_type', 'lead');
$this->CI->db->where('rel_id', $this->leadId);
return $this->CI->db->count_all_results('notes');
}
/**
* Get the total proposals for the lead staff has access to
*
* @return int
*/
public function proposals()
{
if (staff_cant('view', 'proposals')) {
$where = get_proposals_sql_where_staff($this->staffId);
$this->CI->db->where($where);
}
$this->CI->db->where_in('status', [1, 4, 6]);
$this->CI->db->where('rel_id', $this->leadId);
$this->CI->db->where('rel_type', 'lead');
return $this->CI->db->count_all_results('proposals');
}
/**
* Get the total attachments for the lead
*
* @return int
*/
public function attachments()
{
$this->CI->db->where('rel_id', $this->leadId);
$this->CI->db->where('rel_type', 'lead');
return $this->CI->db->count_all_results('files');
}
/**
* Get the total reminders for the lead for staff.
*
* @return int
*/
public function reminders()
{
$this->CI->db->where('rel_id', $this->leadId);
$this->CI->db->where('rel_type', 'lead');
$this->CI->db->where('staff', $this->staffId);
$this->CI->db->where('isnotified', 0);
return $this->CI->db->count_all_results('reminders');
}
public function tasks()
{
$this->CI->db->where('rel_id', $this->leadId);
$this->CI->db->where('rel_type', 'lead');
$this->CI->db->where('datefinished is NULL');
if (staff_cant('view', 'tasks')) {
$this->CI->db->where(get_tasks_where_string(false));
}
return $this->CI->db->count_all_results('tasks');
}
}