AirLay backend

ReportByErrors extends Report
in package

Table of Contents

XLSX_ROW_LIMIT  = 50000
$dataSetIds  : array<string|int, mixed>
$end  : int
$filter  : string|null
$limit  : int
$start  : int
$translator  : ErrorTranslator|null
$values  : array<string|int, mixed>|null
__construct()  : mixed
__serialize()  : array<string|int, mixed>
__unserialize()  : void
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
convertCountDataToRows()  : array<string|int, mixed>
convertErrorsDataToRows()  : array<string|int, mixed>
createHeadersForCount()  : array<string|int, mixed>
createHeadersForErrors()  : array<string|int, mixed>
createSheetWithCount()  : Worksheet
createSheetWithErrors()  : Worksheet
getDataFromDB()  : array<string|int, mixed>
getDataSets()  : array<string|int, DataSetEntity>
getErrorMessage()  : string
getErrorsCount()  : int
getFilter()  : array<string|int, mixed>
getRelatedDataSet()  : RelatedDataSet
mergeData()  : array<string|int, mixed>
setAutoSizeForAllColumns()  : void
setBorderForHeadersAndRows()  : void
setDefaultStyles()  : void
setTextFormatForHeaders()  : void

Constants

XLSX_ROW_LIMIT

protected mixed XLSX_ROW_LIMIT = 50000

Properties

Methods

__construct()

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

__serialize()

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

__unserialize()

public __unserialize(array<string|int, mixed> $data) : void
Parameters
$data : array<string|int, mixed>
Return values
void —

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 —

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 —

convertCountDataToRows()

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

convertErrorsDataToRows()

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

createHeadersForCount()

private createHeadersForCount() : array<string|int, mixed>
Return values
array<string|int, mixed> —

createHeadersForErrors()

private createHeadersForErrors() : array<string|int, mixed>
Return values
array<string|int, mixed> —

createSheetWithCount()

private createSheetWithCount(Worksheet $sheet, array<string|int, mixed> $data) : Worksheet
Parameters
$sheet : Worksheet
$data : array<string|int, mixed>
Return values
Worksheet —

createSheetWithErrors()

private createSheetWithErrors(Worksheet $sheet, array<string|int, mixed> $data) : Worksheet
Parameters
$sheet : Worksheet
$data : array<string|int, mixed>
Return values
Worksheet —

getDataFromDB()

private getDataFromDB() : array<string|int, mixed>
Return values
array<string|int, mixed> —

getErrorsCount()

private getErrorsCount(stdClass $errors) : int
Parameters
$errors : stdClass
Return values
int —

mergeData()

private mergeData(array<string|int, mixed> $result) : array<string|int, mixed>
Parameters
$result : array<string|int, mixed>
Return values
array<string|int, mixed> —

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