AirLay backend

Report
in package
implements ReportInterface

Interfaces, Classes, Traits and Enums

ReportInterface

Table of Contents

XLSX_ROW_LIMIT  = 50000
factory()  : array<string|int, mixed>
convertDataToRows()  : array<string|int, mixed>
createArchive()  : TmpArchive
createCsv()  : string
createSpreadsheet()  : Spreadsheet
formatDate()  : bool|int|float|string
isDateColumn()  : bool
saveXlsx()  : string
setDateFormatForRows()  : void
setStyleForSheet()  : void
setAutoSizeForAllColumns()  : void
setBorderForHeadersAndRows()  : void
setDefaultStyles()  : void
setTextFormatForHeaders()  : void

Constants

XLSX_ROW_LIMIT

protected mixed XLSX_ROW_LIMIT = 50000

Methods

factory()

public abstract factory() : array<string|int, mixed>
Return values
array<string|int, mixed> —

convertDataToRows()

protected convertDataToRows(array<string|int, mixed> $data) : array<string|int, mixed>
Parameters
$data : array<string|int, mixed>
Return values
array<string|int, mixed> —

createArchive()

protected createArchive(array<string|int, mixed> $data, array<string|int, mixed> $headers) : TmpArchive
Parameters
$data : array<string|int, mixed>
$headers : array<string|int, mixed>
Return values
TmpArchive —

createCsv()

protected createCsv(array<string|int, mixed> $header, array<string|int, mixed> $rows) : string
Parameters
$header : array<string|int, mixed>
$rows : array<string|int, mixed>
Return values
string —

createSpreadsheet()

protected createSpreadsheet(array<string|int, mixed> $headers, array<string|int, mixed> $rows) : Spreadsheet
Parameters
$headers : array<string|int, mixed>
$rows : array<string|int, mixed>
Return values
Spreadsheet —

formatDate()

protected formatDate(int $date, string $format) : bool|int|float|string
Parameters
$date : int
$format : string
Return values
bool|int|float|string —

isDateColumn()

protected abstract isDateColumn(string $header) : bool
Parameters
$header : string
Return values
bool —

saveXlsx()

protected saveXlsx(Spreadsheet $content, string $filename) : string
Parameters
$content : Spreadsheet
$filename : string
Return values
string —

setDateFormatForRows()

protected setDateFormatForRows(Worksheet $sheet, array<string|int, mixed> $headers, array<string|int, mixed> $rows) : void
Parameters
$sheet : Worksheet
$headers : array<string|int, mixed>
$rows : array<string|int, mixed>
Return values
void —

setStyleForSheet()

protected setStyleForSheet(Worksheet $sheet, array<string|int, mixed> $headers, array<string|int, mixed> $rows) : void
Parameters
$sheet : Worksheet
$headers : array<string|int, mixed>
$rows : array<string|int, mixed>
Return values
void —

setAutoSizeForAllColumns()

private setAutoSizeForAllColumns(Worksheet $sheet, array<string|int, mixed> $headers) : void
Parameters
$sheet : Worksheet
$headers : array<string|int, mixed>
Return values
void —

setBorderForHeadersAndRows()

private setBorderForHeadersAndRows(Worksheet $sheet, array<string|int, mixed> $headers, array<string|int, mixed> $rows) : void
Parameters
$sheet : Worksheet
$headers : array<string|int, mixed>
$rows : array<string|int, mixed>
Return values
void —

setDefaultStyles()

private setDefaultStyles(Spreadsheet $spreadsheet) : void
Parameters
$spreadsheet : Spreadsheet
Return values
void —

setTextFormatForHeaders()

private setTextFormatForHeaders(Worksheet $sheet, array<string|int, mixed> $headers) : void
Parameters
$sheet : Worksheet
$headers : array<string|int, mixed>
Return values
void —

Search results