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