PHP Helpers and Utilities

function getCachedData(string $sql, array $params = [], ?string $cacheKey = null, int $ttl = 86400): array

// In Model or Controller

public function getMetrics()
{
    $sql = "SELECT
                p.productLine,
                SUM(od.quantityOrdered * od.priceEach) as Total
            FROM products p
            JOIN orderdetails od ON p.productCode = od.productCode
            GROUP BY p.productLine";

    // Cache result for 1 hour (3600 seconds) with specific key
    return getCachedData($sql, [], 'dashboard_metrics', 3600);
}

function queryToAssocArray(string $sql, string $index_key, string $column_key): array

// Get category list for Dropdown
$sql = "SELECT id, name FROM categories ORDER BY name ASC";
$options = queryToAssocArray($sql, 'id', 'name');

// Result: [1 => 'Electronics', 2 => 'Home', ...]

function arrayToXLSXFile(
    array $results,
    string $fileName = 'temp.xlsx',
    bool $download = true,
    string $sheetName = 'Sheet1',
    array $options = []
): bool

namespace App\Controllers;

class Sales extends BaseController
{
    public function exportExcel()
    {
        helper('App\ThirdParty\Ragnos\Helpers\xlsxfiles_helper');

        $db = \Config\Database::connect();
        $orders = $db->table('orders')
            ->select('orderNumber as OrderID, orderDate as Date, status as Status, customerNumber as Customer')
            ->get()
            ->getResultArray();

        // Direct download to user browser as 'sales_report.xlsx'
        arrayToXLSXFile($orders, 'sales_report.xlsx');
    }
}

helper('App\ThirdParty\Ragnos\Helpers\xlsxfiles_helper');

$data = [
    ['id' => 101, 'product' => '4K Monitor', 'price' => 450.00, 'stock' => 12, 'code' => '00123'],
    ['id' => 102, 'product' => 'Mechanical Keyboard', 'price' => 95.50, 'stock' => 30, 'code' => '00456'],
];

$targetPath = WRITEPATH . 'uploads/reports/inventory_' . date('Ymd_His') . '.xlsx';

// Passing download = false saves the file directly to server path
if (arrayToXLSXFile($data, $targetPath, false, 'Inventory')) {
    log_message('info', 'File successfully generated at: ' . $targetPath);
}

helper('App\ThirdParty\Ragnos\Helpers\xlsxfiles_helper');

$clients = [
    ['id' => 1, 'name' => 'Acme Corp', 'balance' => 15200.75, 'active' => true],
    ['id' => 2, 'name' => 'Globex Ltd', 'balance' => -350.00, 'active' => false],
];

arrayToXLSXFile($clients, 'vip_clients.xlsx', true, 'VIP Clients', [
    'header_bg'     => '107C41', // Excel-like green
    'header_color'  => 'FFFFFF', // White text
    'auto_filter'   => true,     // Excel dropdown filters
    'freeze_header' => true,     // Sticky header row
    'custom_widths' => ['A' => 10, 'B' => 35, 'C' => 18, 'D' => 12]
]);

function htmlToXLSXFile(
    string $html,
    string $fileName = 'reporte.xlsx',
    bool $download = true,
    string $sheetName = 'Reporte',
    array $options = []
): bool

helper('App\ThirdParty\Ragnos\Helpers\xlsxfiles_helper');

$reporte = new \App\ThirdParty\Ragnos\Controllers\RSimpleLevelReport();
$reporte->quickSetup('Top Employees', $datos, ['employeeNumber', 'Empleado', 'TotalVentasTrimestre'], ['Oficina' => ['label' => 'Office']]);

// Generate HTML and convert directly into a real .xlsx file
$html = $reporte->generate();
htmlToXLSXFile($html, 'top_employees.xlsx');

$reporte = new \App\ThirdParty\Ragnos\Controllers\RSimpleLevelReport();
$reporte->quickSetup('Margin by Line', $datos, ['productLine', 'MargenTotal']);

// Direct download to user browser
$reporte->exportToXLSX('margin_by_line.xlsx');

// Or save on server storage
$reporte->exportToXLSX(WRITEPATH . 'reports/margin.xlsx', false);

http://localhost/ragnos/content/index.php/tienda/reportes/mejoresempleados?export=xlsx

function buildZipPackage(string $outputPath, array $entries): bool

function arrayToCSVFile(
    array $results,
    $fileName = 'temp.csv',
    $download = true,
    $delimiter = ',',
    $enclosure = '"',
    $escape = '\\'
): bool

helper('App\ThirdParty\Ragnos\Helpers\csvfiles_helper');

$products = [
    ['id' => 1, 'name' => 'Gaming Laptop', 'price' => 1200.00],
    ['id' => 2, 'name' => 'USB Mouse', 'price' => 25.50],
];

// Direct browser download as Excel-compatible CSV
arrayToCSVFile($products, 'products_catalog.csv');

function dbgConsola($data, string $label = 'dbgConsola')

$users = $model->findAll();
dbgConsola($users, 'User List');
// Check Chrome/Firefox console (F12)

function dbgDie($data, int $statusCode = 200): never

function currency(float|int $number, bool $includeSymbol = true): string

echo currency(1500.50); // Shows "$1,500.50" (depending on config)

function returnAsJSON($data, $statusCode = 200)

if (!$user) {
    returnAsJSON(['error' => 'User not found'], 404);
}
returnAsJSON($user);