XLSExport
extends XLSExport
in package
Class created by Core/Internal/PluginsDeploy
Table of Contents
Constants
- LIST_LIMIT = 5000
Properties
- $numSheets : int
- $writer : XLSXWriter
Methods
- addBusinessDocPage() : bool
- Adds a new page with the document data.
- addListModelPage() : bool
- Adds a new page with a table listing all models data.
- addModelPage() : bool
- Adds a new page with the model data.
- addTablePage() : bool
- Adds a new page with the table.
- getDoc() : string
- Return the full document.
- newDoc() : mixed
- Blank document.
- setOrientation() : mixed
- Sets default orientation.
- show() : mixed
- Set headers and output document content to response.
- getColumnAlignments() : array<string|int, mixed>
- getColumnHeaders() : array<string|int, mixed>
- getColumnTitles() : array<string|int, mixed>
- getColumnWidgets() : array<string|int, mixed>
- getCursorData() : array<string|int, mixed>
- getCursorRawData() : array<string|int, mixed>
- getDocumentFormat() : FormatoDocumento
- getFileName() : string
- getModelColumnsData() : array<string|int, mixed>
- getModelFields() : array<string|int, mixed>
- getModelHeaders() : array<string|int, mixed>
- setFileName() : mixed
Constants
LIST_LIMIT
public
mixed
LIST_LIMIT
= 5000
Properties
$numSheets
protected
int
$numSheets
= 0
$writer
protected
XLSXWriter
$writer
Methods
addBusinessDocPage()
Adds a new page with the document data.
public
addBusinessDocPage(BusinessDocument $model) : bool
Parameters
- $model : BusinessDocument
Return values
booladdListModelPage()
Adds a new page with a table listing all models data.
public
addListModelPage(ModelClass $model, array<string|int, DataBaseWhere> $where, array<string|int, mixed> $order, int $offset, array<string|int, mixed> $columns[, string $title = '' ]) : bool
Parameters
- $model : ModelClass
- $where : array<string|int, DataBaseWhere>
- $order : array<string|int, mixed>
- $offset : int
- $columns : array<string|int, mixed>
- $title : string = ''
Return values
booladdModelPage()
Adds a new page with the model data.
public
addModelPage(ModelClass $model, array<string|int, mixed> $columns[, string $title = '' ]) : bool
Parameters
- $model : ModelClass
- $columns : array<string|int, mixed>
- $title : string = ''
Return values
booladdTablePage()
Adds a new page with the table.
public
addTablePage(array<string|int, mixed> $headers, array<string|int, mixed> $rows[, array<string|int, mixed> $options = [] ][, string $title = '' ]) : bool
Parameters
- $headers : array<string|int, mixed>
- $rows : array<string|int, mixed>
- $options : array<string|int, mixed> = []
- $title : string = ''
Return values
boolgetDoc()
Return the full document.
public
getDoc() : string
Return values
stringnewDoc()
Blank document.
public
newDoc(string $title, int $idformat, string $langcode) : mixed
Parameters
- $title : string
- $idformat : int
- $langcode : string
setOrientation()
Sets default orientation.
public
setOrientation(string $orientation) : mixed
Parameters
- $orientation : string
show()
Set headers and output document content to response.
public
show(Response &$response) : mixed
Parameters
- $response : Response
getColumnAlignments()
protected
getColumnAlignments(array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getColumnHeaders()
protected
getColumnHeaders(array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getColumnTitles()
protected
getColumnTitles(array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getColumnWidgets()
protected
getColumnWidgets(array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getCursorData()
protected
getCursorData(array<string|int, ModelClass> $cursor, array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $cursor : array<string|int, ModelClass>
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getCursorRawData()
protected
getCursorRawData(array<string|int, mixed> $cursor[, array<string|int, mixed> $fields = [] ]) : array<string|int, mixed>
Parameters
- $cursor : array<string|int, mixed>
- $fields : array<string|int, mixed> = []
Return values
array<string|int, mixed>getDocumentFormat()
protected
getDocumentFormat(BusinessDocument $model) : FormatoDocumento
Parameters
- $model : BusinessDocument
Return values
FormatoDocumentogetFileName()
protected
getFileName() : string
Return values
stringgetModelColumnsData()
protected
getModelColumnsData(mixed $model, array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $model : mixed
- $columns : array<string|int, mixed>
Return values
array<string|int, mixed>getModelFields()
protected
getModelFields(ModelClass $model) : array<string|int, mixed>
Parameters
- $model : ModelClass
Return values
array<string|int, mixed>getModelHeaders()
protected
getModelHeaders(ModelClass $model) : array<string|int, mixed>
Parameters
- $model : ModelClass
Return values
array<string|int, mixed>setFileName()
protected
setFileName(string $name) : mixed
Parameters
- $name : string