AirLay backend

ReportByUsersDataSetsTools extends Report
in package

Table of Contents

XLSX_ROW_LIMIT  = 50000
$config  : AirlayConfig
$dataSetsIds  : array<string|int, mixed>
$end  : int
$format  : string
$organizationId  : ObjectId
$start  : int
$tools  : array<string|int, mixed>
$usersIds  : array<string|int, mixed>
__construct()  : mixed
ReportByUser constructor.
factory()  : array<string|int, mixed>
convertDataToRows()  : array<string|int, mixed>
createArchive()  : TmpArchive
createCsv()  : string
createPdf()  : TmpArchive
createSpreadsheet()  : Spreadsheet
formatDate()  : bool|int|float|string
isDateColumn()  : bool
saveXlsx()  : string
setDateFormatForRows()  : void
setStyleForSheet()  : void
createHeaders()  : array<string|int, mixed>
createTable()  : string
getDataFromDB()  : array<string|int, mixed>
Item of Traversable => [ '_id' => ObjectId(DatSetLogId), 'tool' => 'string', 'time' => absint of timeMilliseconds, 'dataSetId' => ObjectId, 'uniqueField' => 'string', 'customer' => [ 'id' => ObjectId, 'name' => 'string' ], 'totalNumber' => int, 'create' => String[] with uniqueValues, 'delete' => String[] with uniqueValues, 'update' => String[] with uniqueValues, 'send' => String[] with uniqueValues, 'sendInfo' => [ "name" => 'string', "status" => 'string', // success/fail, "code" => int // Код полученный от мастер системы ], 'user' => UserEntity, 'dataSet' => DataSetEntity ] ]
setAutoSizeForAllColumns()  : void
setBorderForHeadersAndRows()  : void
setDefaultStyles()  : void
setTextFormatForHeaders()  : void

Constants

XLSX_ROW_LIMIT

protected mixed XLSX_ROW_LIMIT = 50000

Properties

Methods

__construct()

ReportByUser constructor.

public __construct(int $start, int $end, array<string|int, ObjectId$dataSetsIds, array<string|int, string> $tools, array<string|int, ObjectId$usersIds, ObjectId $organizationId, AirlayConfig $config, string $format) : mixed
Parameters
$start : int
$end : int
$dataSetsIds : array<string|int, ObjectId>
$tools : array<string|int, string>
$usersIds : array<string|int, ObjectId>
$organizationId : ObjectId
$config : AirlayConfig
$format : string
Return values
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

createPdf()

protected createPdf(array<string|int, mixed> $header, array<string|int, mixed> $data) : TmpArchive
Parameters
$header : array<string|int, mixed>
$data : array<string|int, mixed>
Return values
TmpArchive

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

createTable()

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

getDataFromDB()

Item of Traversable => [ '_id' => ObjectId(DatSetLogId), 'tool' => 'string', 'time' => absint of timeMilliseconds, 'dataSetId' => ObjectId, 'uniqueField' => 'string', 'customer' => [ 'id' => ObjectId, 'name' => 'string' ], 'totalNumber' => int, 'create' => String[] with uniqueValues, 'delete' => String[] with uniqueValues, 'update' => String[] with uniqueValues, 'send' => String[] with uniqueValues, 'sendInfo' => [ "name" => 'string', "status" => 'string', // success/fail, "code" => int // Код полученный от мастер системы ], 'user' => UserEntity, 'dataSet' => DataSetEntity ] ]

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