webdivane / table

tbody.php

<?php

class tbody extends tfoot
{
    protected static function jsonGetBodyData()
    {
        $json = $outColumns = [];
        foreach (self::$cols as $c) {
            $outColumns[] = isset($c[1]) ? $c[1] : null;
        }
        if ((self::$t['rows'] = count(self::$data)) > 0) {
            foreach (self::$data as $row) {
                $rowData = [];
                foreach ($outColumns as $dbName) {
                    $rowData[] = array_key_exists($dbName, $row) ?
                            $row[$dbName] : '';
                }
                $json[] = $rowData;
            }
        } else {
            $attr = ['colspan' => count(self::$cols), 'class' => 'no-results'];
            $json[] = [[self::config('EMPTY_TABLE_MSG'), $attr]];
        }
        return $json;
    }
    
    protected static function rowsThead()
    {
        $trs = '';
        foreach (self::jsonGetBodyData() as $r) {
            if (isset($r[0][1], $r[0][1]['class']) &&
                    $r[0][1]['class'] === 'no-results'
            ) {
                $trs .= '<tr><td' . self::attributes($r[0][1]) . '>'
                        . $r[0][0] . '</td></tr>';
            } else {
                $trs .= '<tr><td>' . implode('</td><td>', $r)
                        . '</td></tr>';
            }
        }
        return $trs;
    }

    protected static function export()
    {
        $data = self::$exportDataAsDisplayed ?
                self::$data :
                self::select(self::$t['q']);
        $fnReplace = [];
        $fnReplace[':app'] = self::config('APP');
        $fnReplace[':items'] = self::$t['items'];
        $format = str_replace(':', '.', '%d.%m.%Y  %H:%i:%s');
        $timeQuery = 'SELECT DATE_FORMAT(Now(), "' . $format . '") AS `now`;';
        $fnReplace[':datetime'] = self::select($timeQuery);
        $outFilename = strtr(self::config('EXPORT_FILE_NAME'), $fnReplace);

It seems like self::config('EXPORT_FILE_NAME') can also be of type null; however, parameter $str of strtr() does only seem to accept string, maybe add an additional type check?

        $outColumns = $outHeader = [];
        foreach (self::$cols as $c) {
            if (isset($c[2]['sort']) && $c[2]['sort'] === false) {
                continue;
            }
            $outColumns[] = $c[1];
            $outHeader[] = $c[0];
        }
        $eData = [$outHeader];
        if (count($data) > 0) {
            foreach ($data as $row) {
                $rowData = [];
                foreach ($row as $dbName => $value) {
                    if (in_array($dbName, $outColumns)) {
                        $rowData[] = is_array($value) ? $value[0] : $value;
                    }
                }
                $eData[] = $rowData;
            }
        }
        self::export2file($eData, $outFilename);
    }

    private static function export2file($eData, $outFilename)
    {
        switch (self::$export) {
            case 'Excel':
            case 'CSV':
                $escape = function($v) {
                    return str_replace("\t", "	", $v);
                };
                header('Content-Type:application/csv');
                header('Content-Disposition:attachment; filename=' .
                        $outFilename . '.csv');

                if (($output = fopen('php://output', 'w'))) {
                    foreach ($eData as $v) {
                        self::$export === 'CSV' ?
                                        fputcsv($output, $v) :
                                        fputs($output, implode("\t", array_map($escape, $v)) . "\r\n");
                    }
                    fclose($output);
                }
                break;
        }
    }
}