AirLay backend

ReportByMedia extends Report
in package

Table of Contents

XLSX_ROW_LIMIT  = 50000
$dataSetIds  : array<string|int, mixed>
$fileNameField  : string|null
$filesystem  : Filesystem
$filter  : string|null
$values  : array<string|int, mixed>|null
__construct()  : mixed
factory()  : array<string|int, mixed>
convertDataToRows()  : array<string|int, mixed>
createArchive()  : TmpArchive
createCsv()  : string
createSpreadsheet()  : Spreadsheet
formatDate()  : bool|int|float|string
getCollection()  : RelationsCollection|FeaturesCollection
getDataFromDB()  : array<string|int, mixed>
getDataSets()  : array<string|int, DataSetEntity>
isDateColumn()  : bool
saveXlsx()  : string
setDateFormatForRows()  : void
setStyleForSheet()  : void
getExtension()  : string
getMediaPaths()  : array<string|int, mixed>
setAutoSizeForAllColumns()  : void
setBorderForHeadersAndRows()  : void
setDefaultStyles()  : void
setTextFormatForHeaders()  : void

Constants

XLSX_ROW_LIMIT

protected mixed XLSX_ROW_LIMIT = 50000

Properties

$dataSetIds read-only

private array<string|int, mixed> $dataSetIds

$fileNameField read-only

private string|null $fileNameField = null

$values read-only

private array<string|int, mixed>|null $values = null

Methods

__construct()

public __construct(array<string|int, mixed> $dataSetIds[, string|null $filter = null ][, array<string|int, mixed>|null $values = null ][, string|null $fileNameField = null ]) : mixed
Parameters
$dataSetIds : array<string|int, mixed>
$filter : string|null = null
$values : array<string|int, mixed>|null = null
$fileNameField : string|null = null
Return values
mixed —

factory()

public factory() : array<string|int, mixed>
Tags
throws
Exception
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 —

getDataFromDB()

protected getDataFromDB() : array<string|int, mixed>
Tags
throws
Exception
Return values
array<string|int, mixed> —

isDateColumn()

protected 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 —

getExtension()

private getExtension(mixed $url) : string
Parameters
$url : mixed
Return values
string —

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