AirLay backend

ReportByUsers extends Report
in package

Table of Contents

XLSX_ROW_LIMIT  = 50000
$config  : AirlayConfig
$end  : int
$organizationId  : ObjectId
$start  : int
__construct()  : mixed
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
createHeaders()  : array<string|int, string>
getDataFromDB()  : array<string|int, mixed>
Item of Traversable => [ 'user' => UserEntity, 'organization' => string, 'groups' => 'string', 'departments' => 'string', 'totalNumber' => 'int', 'create' => 'int', 'update' => 'int', 'delete' => 'int', 'send' => 'int', 'lastChange' => 'int' ]
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, ObjectId $organizationId, AirlayConfig $config) : mixed
Parameters
$start : int
$end : int
$organizationId : ObjectId
$config : AirlayConfig
Return values
mixed —

factory()

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

createHeaders()

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

getDataFromDB()

Item of Traversable => [ 'user' => UserEntity, 'organization' => string, 'groups' => 'string', 'departments' => 'string', 'totalNumber' => 'int', 'create' => 'int', 'update' => 'int', 'delete' => 'int', 'send' => 'int', 'lastChange' => 'int' ]

private getDataFromDB() : 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