XLSExport
extends ExportBase
in package
XLS export data.
Tags
Table of Contents
- LIST_LIMIT = 5000
- $numSheets : int
- $writer : XLSXWriter
- $fileName : string
- 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
- toolBox() : ToolBox
Constants
LIST_LIMIT
public
mixed
LIST_LIMIT
= 5000
Properties
$numSheets
protected
int
$numSheets
= 0
$writer
protected
XLSXWriter
$writer
$fileName
private
string
$fileName
Methods
addBusinessDocPage()
Adds a new page with the document data.
public
addBusinessDocPage(BusinessDocument $model) : bool
Parameters
- $model : BusinessDocument
Return values
bool —addListModelPage()
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
bool —addModelPage()
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
bool —addTablePage()
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
bool —getDoc()
Return the full document.
public
getDoc() : string
Return values
string —newDoc()
Blank document.
public
newDoc(string $title, int $idformat, string $langcode) : mixed
Parameters
- $title : string
- $idformat : int
- $langcode : string
Return values
mixed —setOrientation()
Sets default orientation.
public
setOrientation(string $orientation) : mixed
Parameters
- $orientation : string
Return values
mixed —show()
Set headers and output document content to response.
public
show(Response &$response) : mixed
Parameters
- $response : Response
Return values
mixed —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
FormatoDocumento —getFileName()
protected
getFileName() : string
Return values
string —getModelColumnsData()
protected
getModelColumnsData(ModelClass $model, array<string|int, mixed> $columns) : array<string|int, mixed>
Parameters
- $model : ModelClass
- $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
Return values
mixed —toolBox()
protected
toolBox() : ToolBox