aDriv4 website!

Linux server290.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
162.0.232.252

File Name : tickets.php

<?php

defined('BASEPATH') or exit('No direct script access allowed');

$this->ci->load->model('tickets_model');
$statuses = $this->ci->tickets_model->get_ticket_status();
$this->ci->load->model('departments_model');

$rules = [
    App_table_filter::new('subject', 'TextRule')->label(_l('ticket_dt_subject')),
    App_table_filter::new('department', 'SelectRule')->label(_l('ticket_dt_department'))->options(function ($ci) {
        return collect($ci->departments_model->get())->map(fn ($dep) => [
            'value' => $dep['departmentid'],
            'label' => $dep['name']
        ])->all();
    })->isVisible(fn () => is_admin()),
    App_table_filter::new('status', 'MultiSelectRule')->label(_l('ticket_dt_status'))->options(function ($ci) use ($statuses) {
        return collect($statuses)->map(fn ($status) => [
            'value' => $status['ticketstatusid'],
            'label' => ticket_status_translate($status['ticketstatusid'])
        ])->all();
    }),
    App_table_filter::new('priority', 'SelectRule')->label(_l('ticket_dt_priority'))->options(function ($ci) {
        return collect($ci->tickets_model->get_priority())->map(fn ($priority) => [
            'value' => $priority['priorityid'],
            'label' => ticket_priority_translate($priority['priorityid'])
        ])->all();
    }),
    App_table_filter::new('service', 'SelectRule')->label(_l('ticket_dt_service'))->options(function ($ci) use ($statuses) {
        return collect($ci->tickets_model->get_service())->map(fn ($service) => [
            'value' => $service['serviceid'],
            'label' => $service['name']
        ])->all();
    }),
    App_table_filter::new('merged', 'BooleanRule')->label(_l('merged'))->raw(function ($value) {
        return $value == "1" ? 'merged_ticket_id IS NOT NULL' : 'merged_ticket_id IS NULL';
    }),
    App_table_filter::new('my_tickets', 'BooleanRule')->label(_l('my_tickets_assigned'))->raw(function ($value) {
        return $value == "1" ? 'assigned = ' . get_staff_user_id() : 'assigned != ' . get_staff_user_id();
    }),
];

$rules[] = App_table_filter::new('assigned', 'SelectRule')->label(_l('ticket_assigned'))
    ->withEmptyOperators()
    ->emptyOperatorValue(0)
    ->isVisible(fn () => is_admin())
    ->options(function ($ci) {
        $staff = $ci->staff_model->get('', ['active' => 1]);

return collect($staff)->map(function ($staff) {
            return [
                'value' => $staff['staffid'],
                'label' => $staff['firstname'] . ' ' . $staff['lastname']
            ];
        })->all();
    });

return App_table::find('tickets')
    ->outputUsing(function ($params) use ($statuses) {
        extract($params);

$aColumns = [
            '1', // bulk actions
            'ticketid',
            'subject',
            '(SELECT GROUP_CONCAT(name SEPARATOR ",") FROM ' . db_prefix() . 'taggables JOIN ' . db_prefix() . 'tags ON ' . db_prefix() . 'taggables.tag_id = ' . db_prefix() . 'tags.id WHERE rel_id = ' . db_prefix() . 'tickets.ticketid and rel_type="ticket" ORDER by tag_order ASC) as tags',
            db_prefix() . 'departments.name as department_name',
            db_prefix() . 'services.name as service_name',
            'CONCAT(' . db_prefix() . 'contacts.firstname, \' \', ' . db_prefix() . 'contacts.lastname) as contact_full_name',
            'status',
            'priority',
            'lastreply',
            db_prefix() . 'tickets.date',
        ];

$contactColumn = 6;
        $tagsColumns   = 3;

$additionalSelect = [
            'adminread',
            'ticketkey',
            db_prefix() . 'tickets.userid',
            'statuscolor',
            db_prefix() . 'tickets.name as ticket_opened_by_name',
            db_prefix() . 'tickets.email',
            db_prefix() . 'tickets.userid',
            'assigned',
            db_prefix() . 'clients.company',
        ];

$join = [
            'LEFT JOIN ' . db_prefix() . 'contacts ON ' . db_prefix() . 'contacts.id = ' . db_prefix() . 'tickets.contactid',
            'LEFT JOIN ' . db_prefix() . 'services ON ' . db_prefix() . 'services.serviceid = ' . db_prefix() . 'tickets.service',
            'LEFT JOIN ' . db_prefix() . 'departments ON ' . db_prefix() . 'departments.departmentid = ' . db_prefix() . 'tickets.department',
            'LEFT JOIN ' . db_prefix() . 'tickets_status ON ' . db_prefix() . 'tickets_status.ticketstatusid = ' . db_prefix() . 'tickets.status',
            'LEFT JOIN ' . db_prefix() . 'clients ON ' . db_prefix() . 'clients.userid = ' . db_prefix() . 'tickets.userid',
            'LEFT JOIN ' . db_prefix() . 'tickets_priorities ON ' . db_prefix() . 'tickets_priorities.priorityid = ' . db_prefix() . 'tickets.priority',
        ];

$custom_fields = get_table_custom_fields('tickets');
        foreach ($custom_fields as $key => $field) {
            $selectAs = (is_cf_date($field) ? 'date_picker_cvalue_' . $key : 'cvalue_' . $key);
            array_push($customFieldsColumns, $selectAs);
            array_push($aColumns, 'ctable_' . $key . '.value as ' . $selectAs);
            array_push($join, 'LEFT JOIN ' . db_prefix() . 'customfieldsvalues as ctable_' . $key . ' ON ' . db_prefix() . 'tickets.ticketid = ctable_' . $key . '.relid AND ctable_' . $key . '.fieldto="' . $field['fieldto'] . '" AND ctable_' . $key . '.fieldid=' . $field['id']);
        }

$where  = [];

if ($filtersWhere = $this->getWhereFromRules()) {
            $where[] = $filtersWhere;
        }

if (isset($userid) && $userid != '') {
            array_push($where, 'AND ' . db_prefix() . 'tickets.userid = ' . $this->ci->db->escape_str($userid));
        } elseif (isset($by_email)) {
            array_push($where, 'AND ' . db_prefix() . 'tickets.email = "' . $this->ci->db->escape_str($by_email) . '"');
        }

if (isset($via_ticket)) {
            array_push($where, 'AND ' . db_prefix() . 'tickets.ticketid != ' . $this->ci->db->escape_str($via_ticket));
        }

if ($project_id = $this->ci->input->post('project_id')) {
            array_push($where, 'AND project_id = ' . $this->ci->db->escape_str($project_id));
        }

// If userid is set, the the view is in client profile, should be shown all tickets
        if (!is_admin()) {
            if (get_option('staff_access_only_assigned_departments') == 1) {
                $staff_deparments_ids = $this->ci->departments_model->get_staff_departments(get_staff_user_id(), true);
                $departments_ids      = [];
                if (count($staff_deparments_ids) == 0) {
                    $departments = $this->ci->departments_model->get();
                    foreach ($departments as $department) {
                        array_push($departments_ids, $department['departmentid']);
                    }
                } else {
                    $departments_ids = $staff_deparments_ids;
                }
                if (count($departments_ids) > 0) {
                    array_push($where, 'AND department IN (SELECT departmentid FROM ' . db_prefix() . 'staff_departments WHERE departmentid IN (' . implode(',', $departments_ids) . ') AND staffid="' . get_staff_user_id() . '")');
                }
            }
        }

$sIndexColumn = 'ticketid';
        $sTable       = db_prefix() . 'tickets';

// Fix for big queries. Some hosting have max_join_limit
        if (count($custom_fields) > 4) {
            @$this->ci->db->query('SET SQL_BIG_SELECTS=1');
        }

$result = data_tables_init($aColumns, $sIndexColumn, $sTable, $join, $where, $additionalSelect);

$output  = $result['output'];
        $rResult = $result['rResult'];

foreach ($rResult as $aRow) {
            $row = [];
            for ($i = 0; $i < count($aColumns); $i++) {
                if (strpos($aColumns[$i], 'as') !== false && !isset($aRow[$aColumns[$i]])) {
                    $_data = $aRow[strafter($aColumns[$i], 'as ')];
                } else {
                    $_data = $aRow[$aColumns[$i]];
                }

if ($aColumns[$i] == '1') {
                    $_data = '<div class="checkbox"><input type="checkbox" value="' . $aRow['ticketid'] . '" data-name="' . $aRow['subject'] . '" data-status="' . $aRow['status'] . '"><label></label></div>';
                } elseif ($aColumns[$i] == 'lastreply') {
                    if ($aRow[$aColumns[$i]] == null) {
                        $_data = _l('ticket_no_reply_yet');
                    } else {
                        $_data = e(_dt($aRow[$aColumns[$i]]));
                    }
                } elseif ($aColumns[$i] == 'subject' || $aColumns[$i] == 'ticketid') {
                    // Ticket is assigned
                    if ($aRow['assigned'] != 0) {
                        if ($aColumns[$i] != 'ticketid') {
                            $_data .= '<a href="' . admin_url('profile/' . $aRow['assigned']) . '" data-toggle="tooltip" title="' . e(get_staff_full_name($aRow['assigned'])) . '" class="pull-left mright5">' . staff_profile_image($aRow['assigned'], [
                                'staff-profile-image-xs',
                            ]) . '</a>';
                        } else {
                            $_data = e($_data);
                        }
                    } else {
                        $_data = e($_data);
                    }

$url   = admin_url('tickets/ticket/' . $aRow['ticketid']);
                    $_data = '<a href="' . $url . '" class="valign">' . $_data . '</a>';
                    if ($aColumns[$i] == 'subject') {
                        $_data .= '<div class="row-options">';
                        $_data .= '<a href="' . $url . '">' . _l('view') . '</a>';
                        $_data .= ' | <a href="' . $url . '?tab=settings">' . _l('edit') . '</a>';
                        $_data .= ' | <a href="' . get_ticket_public_url($aRow) . '" target="_blank">' . _l('view_public_form') . '</a>';
                        if (can_staff_delete_ticket()) {
                            $_data .= ' | <a href="' . admin_url('tickets/delete/' . $aRow['ticketid']) . '" class="text-danger _delete">' . _l('delete') . '</a>';
                        }
                        $_data .= '</div>';
                    }
                } elseif ($i == $tagsColumns) {
                    $_data = render_tags($_data);
                } elseif ($i == $contactColumn) {
                    if ($aRow['userid'] != 0) {
                        $_data = '<a href="' . admin_url('clients/client/' . $aRow['userid'] . '?group=contacts') . '">' . e($aRow['contact_full_name']);
                        if (!empty($aRow['company'])) {
                            $_data .= ' (' . e($aRow['company']) . ')';
                        }
                        $_data .= '</a>';
                    } else {
                        $_data = e($aRow['ticket_opened_by_name']);
                    }
                } elseif ($aColumns[$i] == 'status') {
                    $_data = '<span class="label ticket-status-' . $aRow['status'] . '" style="border:1px solid ' . adjust_hex_brightness($aRow['statuscolor'], 0.4) . '; color:' . $aRow['statuscolor'] . ';background: ' . adjust_hex_brightness($aRow['statuscolor'], 0.04) . ';">' . e(ticket_status_translate($aRow['status'])) . '</span>';
                } elseif ($aColumns[$i] == db_prefix() . 'tickets.date') {
                    $_data = e(_dt($_data));
                } elseif (strpos($aColumns[$i],'service_name') !== false) {
                    $_data = e($_data);
                } elseif ($aColumns[$i] == 'priority') {
                    $_data = e(ticket_priority_translate($aRow['priority']));
                } else {
                    if (strpos($aColumns[$i], 'date_picker_') !== false) {
                        $_data = (strpos($_data, ' ') !== false ? _dt($_data) : _d($_data));
                    }
                }

$row[] = $_data;

if ($aRow['adminread'] == 0) {
                    $row['DT_RowClass'] = 'text-danger';
                }
            }

if (isset($row['DT_RowClass'])) {
                $row['DT_RowClass'] .= ' has-row-options';
            } else {
                $row['DT_RowClass'] = 'has-row-options';
            }

$row = hooks()->apply_filters('admin_tickets_table_row_data', $row, $aRow);
            $output['aaData'][] = $row;
        }

return $output;
    })->setRules($rules);

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	panaxpaw/panaxpaw	0755	2026-01-31 04:30:06
..	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:11:17
includes	dir	-	panaxpaw/panaxpaw	0755	2026-01-31 04:30:06
.htaccess	text/plain	127 B	panaxpaw/panaxpaw	0444	2026-01-31 04:30:06
activity_log.php	text/x-php	923 B	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
all_contacts.php	text/x-php	6.38 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
all_reminders.php	text/x-php	4.94 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
announcements.php	text/x-php	2.36 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
api_keys.php	text/x-php	1.23 KB	panaxpaw/panaxpaw	0644	2019-03-12 01:19:06
clients.php	text/x-php	13.91 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
contacts.php	text/x-php	4.96 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
contract_types.php	text/x-php	1.5 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
contracts.php	text/x-php	8.15 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
credit_notes.php	text/x-php	6.97 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
currencies.php	text/x-php	2.39 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
custom_fields.php	text/x-php	1.94 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
customers_groups.php	text/x-php	1.26 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
departments.php	text/x-php	2.64 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
estimate_request.php	text/x-php	6.18 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
estimate_request_form.php	text/x-php	1.68 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
estimates.php	text/x-php	9.21 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
expenses.php	text/x-php	10.18 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
expenses_categories.php	text/x-php	1.72 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
expenses_detailed_report.php	text/x-php	7.32 KB	panaxpaw/panaxpaw	0644	2024-04-28 05:07:00
index.html	text/html	131 B	panaxpaw/panaxpaw	0644	2017-08-11 07:16:10
invoice_items.php	text/x-php	3.88 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
invoices.php	text/x-php	9.78 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
kb_articles.php	text/x-php	3.15 KB	panaxpaw/panaxpaw	0644	2024-01-04 06:36:32
leads.php	text/x-php	13.87 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
milestones.php	text/x-php	2.24 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
payment_modes.php	text/x-php	2.89 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
payments.php	text/x-php	3.95 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
project_discussions.php	text/x-php	2.29 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
project_expenses.php	text/x-php	6.1 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
projects.php	text/x-php	8.37 KB	panaxpaw/panaxpaw	0644	2024-02-19 02:37:12
proposals.php	text/x-php	9.31 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
proposals_relations.php	text/x-php	3.71 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
recurring_invoices.php	text/x-php	6.27 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
reminders.php	text/x-php	2.27 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
roles.php	text/x-php	1.51 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
staff.php	text/x-php	4.53 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
staff_projects.php	text/x-php	1.82 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
staff_reminders.php	text/x-php	4.18 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
staff_timesheets.php	text/x-php	16.12 KB	panaxpaw/panaxpaw	0644	2024-02-19 02:37:12
subscriptions.php	text/x-php	4.95 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
tasks.php	text/x-php	16.33 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
tasks_relations.php	text/x-php	13.84 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
taxes.php	text/x-php	2.24 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
ticket_pipe_log.php	text/x-php	1.03 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
tickets.php	text/x-php	12.52 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
timesheets.php	text/x-php	9.41 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26
web_to_lead.php	text/x-php	1.52 KB	panaxpaw/panaxpaw	0644	2024-02-13 11:13:26

For more Private tool come to me!

https://t.me/aDriv4vz