<?php
/* Model for Call Log Module, it has all database related functions/calls. */
defined('BASEPATH') or exit('No direct script access allowed');

use Carbon\Carbon;

class Call_logs_model extends App_Model
{
    public function __construct()
    {
        parent::__construct();
    }

    /* Get the count for staff. */
    public function get_staff_counts($staffid){
        $count = 0;

        $sql = "SELECT count(`staffid`) as total_count
                from ".db_prefix()."call_logs where staffid= '".$staffid."' " ;
        $query = $this->db->query($sql);
        $row = $query->row();
        if (isset($row)){
            $count = $row->total_count;
        }

        return $count;
    }

    /**
     * @param  integer (optional)
     * @return object
     * Get single
     */
    public function get($id = '')
    {
        if (is_numeric($id)) {
            $this->db->where('id', $id);
            $call_log = $this->db->get(db_prefix() . 'call_logs')->row();
            $call_log->contact_name = '';
            $call_log->contact_email = '';
            if($call_log->contactid != ''){
                $this->load->model('clients_model');
                $contact = $this->clients_model->get_contact($call_log->contactid);
                if($contact){
                    $call_log->contact_name = $contact->firstname.' '.$contact->lastname;
                    $call_log->contact_email = $contact->email;
                }
                
            }
            return $call_log;
        }

        return $this->db->get(db_prefix() . 'call_logs')->result_array();
    }

    /* Get all call logs by staff members. */
    public function get_staff_call_logs($staff_id, $exclude_notified = true)
    {
        $this->db->where('staff_id', $staff_id);
        if ($exclude_notified) {
            $this->db->where('notified', 0);
        }

        $this->db->order_by('end_date', 'asc');
    }

    /**
     * Add new
     * @param mixed $data All $_POST dat
     * @return mixed
     */
    public function add($data)
    {
        unset($data['lead_id']);
        $data['datestart'] = date('Y-m-d');
        $data['staffid']      = $data['staffid'] == '' ? 0 : $data['staffid'];
        $data['call_start_time']    = to_sql_date($data['call_start_time'], true);
        $data['call_end_time']      = to_sql_date($data['call_end_time'], true);

        if($data['has_follow_up'] == 1) {
            $data['follow_up_schedule'] = to_sql_date($data['follow_up_schedule'], true);
        }else{
            $data['follow_up_schedule'] = 'NULL';
        }
        $data['dateadded'] = date('Y-m-d H:i:s');

        $diff = Carbon::parse($data['call_end_time'])->diffInHours(Carbon::parse($data['call_start_time'])) . ':' .  Carbon::parse($data['call_end_time'])->diff(Carbon::parse($data['call_start_time']))->format('%I:%S');
        $data['call_duration'] = $diff;

        $this->db->insert(db_prefix() . 'call_logs', $data);
        $insert_id = $this->db->insert_id();
        if ($insert_id) {
            log_activity('New Call Log Added [ID:' . $insert_id . ']');

            return $insert_id;
        }

        return false;
    }

    /**
     * Update
     * @param  mixed $data All $_POST data
     * @param  mixed $id    id
     * @return boolean
     */
    public function update($data, $id)
    {
        unset($data['lead_id']);
        $data['staffid']      = $data['staffid'] == '' ? 0 : $data['staffid'];
        $data['call_start_time']    = to_sql_date($data['call_start_time'], true);
        $data['call_end_time']      = to_sql_date($data['call_end_time'], true);
        if($data['has_follow_up'] == 1) {
            $data['follow_up_schedule'] = to_sql_date($data['follow_up_schedule'], true);
        }else{
            $data['follow_up_schedule'] = 'NULL';
        }
        $data['dateaupdated'] = date('Y-m-d H:i:s');

        $diff = Carbon::parse($data['call_end_time'])->diffInHours(Carbon::parse($data['call_start_time'])) . ':' .  Carbon::parse($data['call_end_time'])->diff(Carbon::parse($data['call_start_time']))->format('%I:%S');
        $data['call_duration'] = $diff;

        $this->db->where('id', $id);
        $this->db->update(db_prefix() . 'call_logs', $data);
        if ($this->db->affected_rows() > 0) {
            log_activity('Call Log Updated [ID:' . $id . ']');

            return true;
        }

        return false;
    }

    /**
     * Delete
     * @param  mixed $id id
     * @return boolean
     */
    public function delete($id)
    {
        $this->db->where('id', $id);
        $this->db->delete(db_prefix() . 'call_logs');
        if ($this->db->affected_rows() > 0) {
            log_activity('Call log Deleted [ID:' . $id . ']');

            return true;
        }

        return false;
    }

    /* Display all logs, which has notification as true. Notification Queue. */
    public function get_notifiable_logs(){
        $this->db->where('is_completed', 0);
        $this->db->where('has_follow_up', 1);
        $this->db->where('notified', 0);
        $this->db->where('TIMESTAMPDIFF(MINUTE, CURRENT_TIMESTAMP(), follow_up_schedule) <=', '30');
        $result = $this->db->get(db_prefix() . 'call_logs')->result_array();

        return $result;
    }

    /**
     * Notify staff members
     * @param  mixed $id           id
     * @return boolean
     */
    public function notify_staff_members($id)
    {
        $callLog = $this->get($id);
        $callLog_desc = 'cl_follow_up_notification';

        if ($callLog->call_with_staffid > 0) {
            $this->load->model('staff_model');
            $staff = $this->staff_model->get('', ['active' => 1, 'staffid' => $callLog->call_with_staffid]);
        } else if ($callLog->staffid > 0) {
            $this->db->where('active', 1)
            ->where('staffid', $callLog->staffid);
            $staff = $this->db->get(db_prefix() . 'staff')->result_array();
        }else {
            $this->load->model('staff_model');
            $staff = $this->staff_model->get('', ['active' => 1]);
        }

        if($callLog->customer_type == 'customer') {
            $oClient = $this->clients_model->get($callLog->clientid);
            if (!$oClient) {
                return false;
            }
            $oCustomer = $this->clients_model->get_contacts($oClient->userid, ['is_primary' => true]);
            $contactName = '';
            if (isset($oCustomer[0])) {
                $contactName = $oCustomer[0]['firstname'] . ' ' . $oCustomer[0]['lastname'] . '<br>';
            }
            $contactName = $contactName . ' ' . $oClient->company;
        }else{
            $this->load->model('leads_model');
            $oCustomer = $this->leads_model->get($callLog->clientid);
            $contactName = $oCustomer->name;
        }
        $notifiedUsers = [];
        foreach ($staff as $member) {
            if (is_staff_member($member['staffid'])) {
                $notified = add_notification([
                    'fromcompany'     => 1,
                    'touserid'        => $member['staffid'],
                    'description'     => $callLog_desc,
                    'additional_data' => serialize([
                        $contactName,
                        _d($callLog->follow_up_schedule),
                    ]),
                ]);
                if ($notified) {
                    array_push($notifiedUsers, $member['staffid']);
                }
            }
        }

        pusher_trigger_notification($notifiedUsers);
        $this->db->where('id', $callLog->id);
        $this->db->update(db_prefix() . 'call_logs', [
            'notified' => 1,
        ]);

        if (count($staff) > 0 && $this->db->affected_rows() > 0) {
            return true;
        }

        return false;
    }


    /**
     * Notify staff members about calls goal achieived
     * @return boolean
     */
    public function notify_staff_members_calls_goal_acheived()
    {
        ini_set('display_errors', 1);
        ini_set('display_startup_errors', 1);
        error_reporting(E_ALL);

        $callLog_daily_goal_notification = 'cl_daily_calls_target_notification';
        $callLog_monthly_goal_notification = 'cl_monthly_calls_target_notification';

        $cl_calls_daily_goal = get_option('staff_members_daily_calls_target');
        $cl_calls_monthly_goal = get_option('staff_members_monthly_calls_target');

        $sql = "SELECT distinct staffid as staff
                from `" . db_prefix() . "call_logs` where staffid > 0 
                union 
                SELECT distinct call_with_staffid as staff
                from `" . db_prefix() . "call_logs` where call_with_staffid > 0 
                ";
        $query = $this->db->query($sql);
        $staffIds = $query->result_array();
        foreach ($staffIds as $staffId){
            $notifiedUsers = [];

            /** Daily Goal Notify */
            $todayDate =  Carbon::now()->format('Y-m-d');
            $sql = "SELECT count(`id`) as totalCalls
                from ".db_prefix()."call_logs where DATE_FORMAT(`call_start_time`,'%Y-%m-%d') between '".$todayDate."' AND '".$todayDate."' 
                AND (`staffid` = ".$staffId['staff']." || `call_with_staffid` = ".$staffId['staff'].") 
                " ;
            $query = $this->db->query($sql);
            $rowDaily = $query->row();
            if((int) $cl_calls_daily_goal > 0 && $rowDaily->totalCalls > 0 && $rowDaily->totalCalls >= $cl_calls_daily_goal)  {
                $sql = "SELECT *
                from ".db_prefix()."call_logs_goals_notified where DATE_FORMAT(`notify_date`,'%Y-%m-%d') between '".$todayDate."' AND '".$todayDate."' 
                AND `staffid` = ".$staffId['staff']." AND goal_type = 'daily' 
                " ;
                $query = $this->db->query($sql);
                $rowNotify = $query->row();
                if(!$rowNotify){
                    $data = [
                        'staffid'   => $staffId['staff'],
                        'goal_type'   => 'daily',
                        'notify_date'   => date('Y-m-d H:i:s'),
                    ];
                    $this->db->insert(db_prefix() . 'call_logs_goals_notified', $data);

                    $notified = add_notification([
                        'fromcompany' => 1,
                        'touserid' => $staffId['staff'],
                        'description' => $callLog_daily_goal_notification,
                        'additional_data' => serialize([
                            $cl_calls_daily_goal
                        ]),
                    ]);
                    if ($notified) {
                        array_push($notifiedUsers, $staffId['staff']);
                    }
                }
            }
            /** End Daily Goal Notify */

            /** Monthly Goal Notify */
            $currentMonth = Carbon::now()->format('m');

            $sql = "SELECT count(`id`) as totalCalls
                from ".db_prefix()."call_logs where DATE_FORMAT(`call_start_time`,'%m') = '".$currentMonth."'  
                AND (`staffid` = ".$staffId['staff']." || `call_with_staffid` = ".$staffId['staff'].") 
                " ;
            $query = $this->db->query($sql);
            $rowMonthly = $query->row();
            if((int) $cl_calls_monthly_goal > 0 && $rowMonthly->totalCalls > 0 && $rowMonthly->totalCalls >= $cl_calls_monthly_goal)  {
                $sql = "SELECT *
                from ".db_prefix()."call_logs_goals_notified where DATE_FORMAT(`notify_date`,'%m') = '".$currentMonth."'  
                AND `staffid` = ".$staffId['staff']." AND goal_type = 'monthly' 
                " ;
                $query = $this->db->query($sql);
                $rowNotify = $query->row();
                if(!$rowNotify){
                    $data = [
                        'staffid'   => $staffId['staff'],
                        'goal_type'   => 'monthly',
                        'notify_date'   => date('Y-m-d H:i:s'),
                    ];
                    $this->db->insert(db_prefix() . 'call_logs_goals_notified', $data);

                    $notified = add_notification([
                        'fromcompany' => 1,
                        'touserid' => $staffId['staff'],
                        'description' => $callLog_monthly_goal_notification,
                        'additional_data' => serialize([
                            $cl_calls_monthly_goal
                        ]),
                    ]);
                    if ($notified) {
                        array_push($notifiedUsers, $staffId['staff']);
                    }
                }
            }
            /** End Monthly Goal Notify */
            if(sizeof($notifiedUsers)) {
                pusher_trigger_notification($notifiedUsers);
            }
        }

        return true;
    }

    /* Count the total inbound and outbound calls. */
    public function count_inbound_outbound_calls($start_date, $end_date, $staffid){
        $result['inbound']  = 0;
        $result['outbound'] = 0;

        $sql = "SELECT count(`call_direction`) as inbound
                from ".db_prefix()."call_logs where call_direction = 1 AND DATE_FORMAT(`call_start_time`,'%Y-%m-%d') between '".$start_date."' AND '".$end_date."' 
                AND (`staffid` = ".$staffid." || `call_with_staffid` = ".$staffid.") 
                " ;
        $query = $this->db->query($sql);
        $row = $query->row();
        if (isset($row)){
            $result['inbound'] = $row->inbound;
        }

        $sql = "SELECT count(`call_direction`) as outbound
                from `".db_prefix()."call_logs` where call_direction = 2 AND DATE_FORMAT(`call_start_time`,'%Y-%m-%d') between '".$start_date."' AND '".$end_date."' 
                AND (`staffid` = ".$staffid." || `call_with_staffid` = ".$staffid.") 
                " ;
        $query = $this->db->query($sql);
        $row = $query->row();
        if (isset($row)){
            $result['outbound'] = $row->outbound;
        }

        return $result;
    }

    /* Get the inbound report for the overview tab. */
    public function get_inbound_outbound_report($start_date, $end_date, $staffid){
        $date_labels  = [];
        $total_inbound = [];
        $total_outbound   = [];
        $i              = 0;

        $daysDiff = Carbon::parse($end_date)->diffInDays(Carbon::parse($start_date));

        for ($d = 0; $d <= $daysDiff; $d++) {
            $filterDate =  Carbon::parse($start_date)->addDays($d)->format("Y-m-d");
            array_push($date_labels, _l(Carbon::parse($filterDate)->format('d M Y')));

            $inbound = 0;
            $outbound = 0;

            $sql = "SELECT count(`call_direction`) as inbound
                from ".db_prefix()."call_logs where call_direction = 1 AND DATE_FORMAT(`call_start_time`,'%Y-%m-%d') between '".$filterDate."' AND '".$filterDate."' 
                AND (`staffid` = ".$staffid." || `call_with_staffid` = ".$staffid.") 
                " ;
            $query = $this->db->query($sql);
            $row = $query->row();
            if (isset($row)){
                $inbound = $row->inbound;
            }

            if (!isset($total_inbound[$i])) {
                $total_inbound[$i] = [];
            }
            $total_inbound[$i] = $inbound;

            $sql = "SELECT count(`call_direction`) as outbound
                from `".db_prefix()."call_logs` where call_direction = 2 AND DATE_FORMAT(`call_start_time`,'%Y-%m-%d') between '".$filterDate."' AND '".$filterDate."' 
                AND (`staffid` = ".$staffid." || `call_with_staffid` = ".$staffid.") 
                " ;
            $query = $this->db->query($sql);
            $row = $query->row();
            if (isset($row)){
                $outbound = $row->outbound;
            }

            if (!isset($total_outbound[$i])) {
                $total_outbound[$i] = [];
            }
            $total_outbound[$i] = $outbound;

            $i++;
        }

        $chart = [
            'labels'   => $date_labels,
            'datasets' => [
                [
                    'label'           => _l('cl_report_inbound_calls'),
                    'backgroundColor' => 'rgba(51, 122, 183,0.8)',
                    'borderColor'     => '#337ab7',
                    'borderWidth'     => 1,
                    'tension'         => false,
                    'data'            => $total_inbound,
                ],
                [
                    'label'           => _l('cl_report_outbound_calls'),
                    'backgroundColor' => 'rgba(60, 118, 61,0.8)',
                    'borderColor'     => '#3c763d',
                    'borderWidth'     => 1,
                    'tension'         => false,
                    'data'            => $total_outbound,
                ],
            ],
        ];

        return $chart;
    }


    public function _search_proposals($q, $rel_type = '', $rel_id = 0, $limit =0)
    {
        $result = [
            'result'         => [],
            'type'           => 'proposals',
            'search_heading' => _l('proposals'),
        ];

        $has_permission_view_proposals     = has_permission('proposals', '', 'view');
        $has_permission_view_proposals_own = has_permission('proposals', '', 'view_own');

        if ($has_permission_view_proposals || $has_permission_view_proposals_own || get_option('allow_staff_view_proposals_assigned') == '1') {
            if (is_numeric($q)) {
                $q = trim($q);
                $q = ltrim($q, '0');
            } elseif (startsWith($q, get_option('proposal_number_prefix'))) {
                $q = strafter($q, get_option('proposal_number_prefix'));
                $q = trim($q);
                $q = ltrim($q, '0');
            }

            $noPermissionQuery = get_proposals_sql_where_staff(get_staff_user_id());

            // Proposals
            $this->db->select('*,' . db_prefix() . 'proposals.id as id');
            $this->db->from(db_prefix() . 'proposals');
            $this->db->join(db_prefix() . 'currencies', db_prefix() . 'currencies.id = ' . db_prefix() . 'proposals.currency');

            if (!$has_permission_view_proposals) {
                $this->db->where($noPermissionQuery);
            }

            if($rel_id !=0 && $rel_type != ''){
                $this->db->where('rel_type', $rel_type);
                $this->db->where('rel_id', $rel_id);
            }

            $this->db->where('(
                ' . db_prefix() . 'proposals.id LIKE "' . $q . '%"
                OR ' . db_prefix() . 'proposals.subject LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.content LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.proposal_to LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.address LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.email LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR ' . db_prefix() . 'proposals.phone LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                )');

            $this->db->order_by(db_prefix() . 'proposals.id', 'desc');
            if ($limit != 0) {
                $this->db->limit($limit);
            }
            $result['result'] = $this->db->get()->result_array();
        }

        return $result;
    }


    public function _search_estimates($q, $rel_type = '', $rel_id = 0, $limit =0)
    {
        $result = [
            'result'         => [],
            'type'           => 'estimates',
            'search_heading' => _l('estimates'),
        ];

        $has_permission_view_estimates     = has_permission('estimates', '', 'view');
        $has_permission_view_estimates_own = has_permission('estimates', '', 'view_own');

        if ($has_permission_view_estimates || $has_permission_view_estimates_own || get_option('allow_staff_view_estimates_assigned') == '1') {
            if (is_numeric($q)) {
                $q = trim($q);
                $q = ltrim($q, '0');
            } elseif (startsWith($q, get_option('estimate_prefix'))) {
                $q = strafter($q, get_option('estimate_prefix'));
                $q = trim($q);
                $q = ltrim($q, '0');
            }
            // Estimates
            $estimates_fields  = prefixed_table_fields_array(db_prefix() . 'estimates');
            $clients_fields    = prefixed_table_fields_array(db_prefix() . 'clients');
            $noPermissionQuery = get_estimates_where_sql_for_staff(get_staff_user_id());

            $this->db->select(implode(',', $estimates_fields) . ',' . implode(',', $clients_fields) . ',' . db_prefix() . 'estimates.id as estimateid,' . get_sql_select_client_company());
            $this->db->from(db_prefix() . 'estimates');
            $this->db->join(db_prefix() . 'clients', db_prefix() . 'clients.userid = ' . db_prefix() . 'estimates.clientid', 'left');
            $this->db->join(db_prefix() . 'currencies', db_prefix() . 'currencies.id = ' . db_prefix() . 'estimates.currency');
            $this->db->join(db_prefix() . 'contacts', db_prefix() . 'contacts.userid = ' . db_prefix() . 'clients.userid AND is_primary = 1', 'left');

            if (!$has_permission_view_estimates) {
                $this->db->where($noPermissionQuery);
            }

            if($rel_id !=0 && $rel_type == 'customer'){
                $this->db->where('clientid', $rel_id);
            }

            $this->db->where('(
                ' . db_prefix() . 'estimates.number LIKE "' . $this->db->escape_like_str($q) . '"
                OR
                ' . db_prefix() . 'clients.company LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.clientnote LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.vat LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.phonenumber LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                address LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.adminnote LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.billing_street LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.billing_city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.billing_state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.billing_zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.shipping_street LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.shipping_city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.shipping_state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'estimates.shipping_zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.billing_street LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.billing_city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.billing_state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.billing_zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.shipping_street LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.shipping_city LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.shipping_state LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                OR
                ' . db_prefix() . 'clients.shipping_zip LIKE "%' . $this->db->escape_like_str($q) . '%" ESCAPE \'!\'
                )');

            $this->db->order_by('number,YEAR(date)', 'desc');
            if ($limit != 0) {
                $this->db->limit($limit);
            }
            $result['result'] = $this->db->get()->result_array();
        }

        return $result;
    }

    /**
     * @param  integer (optional)
     * @return object
     * Get Call logs rel types
     */
    public function get_rel_types($id = '')
    {
        if (is_numeric($id)) {
            $this->db->where('id', $id);

            return $this->db->get(db_prefix() . 'call_logs_rel_types')->row();
        }

        return $this->db->get(db_prefix() . 'call_logs_rel_types')->result_array();
    }

    /**
     * @param  integer (optional)
     * @return object
     * Get Call logs call directions
     */
    public function get_call_directions($id = '')
    {
        if (is_numeric($id)) {
            $this->db->where('id', $id);

            return $this->db->get(db_prefix() . 'call_logs_directions')->row();
        }

        return $this->db->get(db_prefix() . 'call_logs_directions')->result_array();
    }

    /* Call Logs Type start */

    /**
     * Get type
     * @param  mixed $id id (Optional)
     * @return mixed     object or array
     */
    public function get_cl_type($id = '')
    {
        if (is_numeric($id)) {
            $this->db->where('id', $id);

            return $this->db->get(db_prefix() . 'call_logs_rel_types')->row();
        }
        $this->db->order_by('name', 'asc');

        return $this->db->get(db_prefix() . 'call_logs_rel_types')->result_array();
    }

    /**
     * Add new  type
     * @param mixed $data All $_POST data
     * @return boolean
     */
    public function add_cl_type($data)
    {
        $data['key'] = url_title($data['name'], 'underscore', true);

        $this->db->insert(db_prefix() . 'call_logs_rel_types', $data);
        $insert_id = $this->db->insert_id();
        if ($insert_id) {
            log_activity('New Type Added [ID: ' . $insert_id . ']');

            return $insert_id;
        }

        return false;
    }

    /**
     * Update Type
     * @param  mixed $data All $_POST data
     * @param  mixed $id   id to update
     * @return boolean
     */
    public function update_cl_type($data, $id)
    {
        $data['key'] = url_title($data['name'], 'underscore', true);
        $this->db->where('id', $id);
        $this->db->update(db_prefix() . 'call_logs_rel_types', $data);
        if ($this->db->affected_rows() > 0) {
            log_activity('Type Updated [ID: ' . $id . ']');

            return true;
        }

        return false;
    }

    /**
     * @param  integer ID
     * @return mixed
     * Delete type from database, if used return array with key referenced
     */
    public function delete_cl_type($id)
    {
        if (is_reference_in_table('rel_type', db_prefix() . 'call_logs', $id)) {
            return [
                'referenced' => true,
            ];
        }
        $this->db->where('id', $id);
        $this->db->delete(db_prefix() . 'call_logs_rel_types');
        if ($this->db->affected_rows() > 0) {
            log_activity('Type Deleted [' . $id . ']');

            return true;
        }

        return false;
    }


    /* Call Logs Call Direction start */

    /**
     * Get Call Direction
     * @param  mixed $id id (Optional)
     * @return mixed     object or array
     */
    public function get_call_direction($id = '')
    {
        if (is_numeric($id)) {
            $this->db->where('id', $id);

            return $this->db->get(db_prefix() . 'call_logs_directions')->row();
        }
        $this->db->order_by('name', 'asc');

        return $this->db->get(db_prefix() . 'call_logs_directions')->result_array();
    }

    /**
     * Add new  Call Direction
     * @param mixed $data All $_POST data
     * @return boolean
     */
    public function add_call_direction($data)
    {
        $this->db->insert(db_prefix() . 'call_logs_directions', $data);
        $insert_id = $this->db->insert_id();
        if ($insert_id) {
            log_activity('New Call Type Added [ID: ' . $insert_id . ']');

            return $insert_id;
        }

        return false;
    }

    /**
     * Update Call Direction
     * @param  mixed $data All $_POST data
     * @param  mixed $id   id to update
     * @return boolean
     */
    public function update_call_direction($data, $id)
    {
        $this->db->where('id', $id);
        $this->db->update(db_prefix() . 'call_logs_directions', $data);
        if ($this->db->affected_rows() > 0) {
            log_activity('Call Type Updated [ID: ' . $id . ']');

            return true;
        }

        return false;
    }

    /**
     * @param  integer ID
     * @return mixed
     * Delete type from database, if used return array with key referenced
     */
    public function delete_call_direction($id)
    {
        if (is_reference_in_table('call_direction', db_prefix() . 'call_logs', $id)) {
            return [
                'referenced' => true,
            ];
        }
        $this->db->where('id', $id);
        $this->db->delete(db_prefix() . 'call_logs_directions');
        if ($this->db->affected_rows() > 0) {
            log_activity('Call Type Deleted [' . $id . ']');

            return true;
        }

        return false;
    }
}