KoolPivotTable class [PHP]

Summary

Properties Description
AjaxEnabled Enable or disable a pivot's ajax.
AjaxLoadingImage Get or set a pivot's ajax loading image.
AllowCaching Enable or disable a pivot's cache.
AllowFiltering Enable or disable a pivot's filtering on fields.
AllowReorder Enable or disable a pivot's reordering of fields.
AllowSorting Enable or disable a pivot's sorting on fields.
AllowSortingData Enable or disable a pivot's sorting on data.
CacheFolder Get or set a pivot's cache folder.
CacheTime Get or set a pivot's cache expired time.
CharSet Get or set a pivot's charset.
DataSource Get or set a pivot's data source.
EmptyValue Get or set a pivot's displaying value for empty cell.
ErrorValue Get or set a pivot's displaying value for cell when aggregating on data fails.
EventHandler Get or set a pivot's event handler object.
ExportSettings Get or set a pivot's export settings.
Height Get or set height of a pivot.
HorizontalScrolling Enable or disable a pivot's horizontal scrolling.
id Get or set a pivot's id.
KeepViewStateInSession Enable or disable a pivot's viewstate to be save in SESSION global variable.
Localization Get or set a pivot's localization property.
Pager Get or set chart's pager object.
RowHeaderMinWidth Get or set a pivot's minimum row headers' width.
scriptFolder Get or set a pivot's script folder path.
ShowColumnZone Enable or disable a pivot's column fields zone.
ShowDataZone Enable or disable a pivot's data fields zone.
ShowFilterZone Enable or disable a pivot's filter fields zone.
ShowRowZone Enable or disable a pivot's row fields zone.
ShowStatus Enable or disable a pivot's status zone.
Status Get or set a pivot's status bar.
styleFolder Get or set a pivot's style.
VerticalScrolling Enable or disable a pivot's vertical scrolling.
Width Get or set width of a pivot.
Methods Description
Constructor Create a KoolPivotTable object.
AddDataField Add a data field to pivot.
AddRowField Add a row field to pivot.
AddColumnField Add a column field to pivot.
AddFilterField Add a filter field to pivot.
GetDataField Get a data field from pivot.
GetRowField Get a row field from pivot.
GetColumnField Get a column field from pivot.
GetFilterField Get a filter field from pivot.
SetDataFieldForSorting Set a data field used for pivot's data sorting.
SetInitSortedGroup Set an initial default group for pivot's data sorting.
ExportToHTML Export a pivot HTML file.
ExportToPDF Export a pivot PDF file.
ExportToExcel Export a pivot Excel file.
ExportToWord Export a pivot Word file.
Process Process a pivot before rendering or exporting.
Render Render pivot.

Properties Detail

AjaxEnabledTop

Bool AjaxEnabled

Enable or disable a pivot's ajax.

Show/Hide Code

Supported from version: 1.0.0.0

AjaxLoadingImageTop

String AjaxLoadingImage

Get or set a pivot's ajax loading image.

Show/Hide Code

Supported from version: 1.0.0.0

AllowCachingTop

bool AllowCaching

Enable or disable a pivot's cache.

Show/Hide Code

Supported from version: 1.0.0.0

AllowFilteringTop

bool AllowFiltering

Enable or disable a pivot's filtering on fields.

Show/Hide Code

Supported from version: 1.0.0.0

AllowReorderTop

bool AllowReorder

Enable or disable a pivot's reordering of fields.

Show/Hide Code

Supported from version: 1.0.0.0

AllowSortingTop

bool AllowSorting

Enable or disable a pivot's sorting on fields.

Show/Hide Code

Supported from version: 1.0.0.0

AllowSortingDataTop

bool AllowSortingData

Enable or disable a pivot's sorting on data.

Show/Hide Code

Supported from version: 1.0.0.0

CacheFolderTop

String CacheFolder

Get or set a pivot's cache folder.

Show/Hide Code

Supported from version: 1.0.0.0

CacheTimeTop

Number CacheTime

Get or set a pivot's cache expired time.

Show/Hide Code

Supported from version: 1.0.0.0

CharSetTop

String CharSet

Get or set a pivot's charset.

Show/Hide Code

Supported from version: 1.0.0.0

DataSourceTop

PivotDataSource DataSource

Get or set a pivot's data source.

Show/Hide Code

Supported from version: 1.0.0.0

EmptyValueTop

String EmptyValue

Get or set a pivot's displaying value for empty cell.

Show/Hide Code

Supported from version: 1.0.0.0

ErrorValueTop

String ErrorValue

Get or set a pivot's displaying value for cell when aggregating on data fails.

Show/Hide Code

Supported from version: 1.0.0.0

EventHandlerTop

object EventHandler

Get or set a pivot's event handler object.

Show/Hide Code

Supported from version: 1.0.0.0

ExportSettingsTop

Object ExportSettings

Get or set a pivot's export settings.

Show/Hide Code

Supported from version: 1.0.0.0

HeightTop

Number Height

Get or set height of a pivot.

Show/Hide Code

Supported from version: 1.0.0.0

HorizontalScrollingTop

bool HorizontalScrolling

Enable or disable a pivot's horizontal scrolling.

Show/Hide Code

Supported from version: 1.0.0.0

idTop

String id

Get or set a pivot's id

Show/Hide Code

Supported from version: 1.0.0.0

KeepViewStateInSessionTop

bool KeepViewStateInSession

Enable or disable a pivot's viewstate to be save in SESSION global variable.

Show/Hide Code

Supported from version: 1.0.0.0

LocalizationTop

object Localization

Get or set a pivot's localization property.

Show/Hide Code

Supported from version: 1.0.0.0

PagerTop

Object Pager

Get or set chart's pager object.

Show/Hide Code

Supported from version: 1.0.0.0

RowHeaderMinWidthTop

Number RowHeaderMinWidth

Get or set a pivot's minimum row headers' width.

Show/Hide Code

Supported from version: 1.0.0.0

scriptFolderTop

String scriptFolder

Get or set a pivot's script folder path.

Show/Hide Code

Supported from version: 1.0.0.0

ShowColumnZoneTop

bool ShowColumnZone

Enable or disable a pivot's column fields zone.

Show/Hide Code

Supported from version: 1.0.0.0

ShowDataZoneTop

bool ShowDataZone

Enable or disable a pivot's data fields zone.

Show/Hide Code

Supported from version: 1.0.0.0

ShowFilterZoneTop

bool ShowFilterZone

Enable or disable a pivot's filter fields zone.

Show/Hide Code

Supported from version: 1.0.0.0

ShowRowZoneTop

bool ShowRowZone

Enable or disable a pivot's row fields zone.

Show/Hide Code

Supported from version: 1.0.0.0

ShowStatusTop

bool ShowStatus

Enable or disable a pivot's status zone.

Show/Hide Code

Supported from version: 1.0.0.0

StatusTop

Object Status

Get or set a pivot's status bar.

Show/Hide Code

Supported from version: 1.0.0.0

styleFolderTop

String styleFolder

Get or set a pivot's style.

Show/Hide Code

Supported from version: 1.0.0.0

VerticalScrollingTop

bool VerticalScrolling

Enable or disable a pivot's vertical scrolling.

Show/Hide Code

Supported from version: 1.0.0.0

WidthTop

Number Width

Get or set width of a pivot.

Show/Hide Code

Supported from version: 1.0.0.0

Methods Detail

ConstructorTop

KoolPivotTable Constructor()

Create a KoolPivotTable object.

Show/Hide Code

Supported from version: 1.0.0.0

AddDataFieldTop

void AddDataField()

Add a data field to pivot.

Show/Hide Code

Supported from version: 1.0.0.0

AddRowFieldTop

void AddRowField()

Add a row field to pivot.

Show/Hide Code

Supported from version: 1.0.0.0

AddColumnFieldTop

void AddColumnField()

Add a column field to pivot.

Show/Hide Code

Supported from version: 1.0.0.0

AddFilterFieldTop

void AddFilterField()

Add a filter field to pivot.

Show/Hide Code

Supported from version: 1.0.0.0

GetDataFieldTop

PivotField GetDataField()

Get a data field from pivot.

Show/Hide Code

Supported from version: 1.0.0.0

GetRowFieldTop

PivotField GetRowField()

Get a row field from pivot.

Show/Hide Code

Supported from version: 1.0.0.0

GetColumnFieldTop

PivotField GetColumnField()

Get a column field from pivot.

Show/Hide Code

Supported from version: 1.0.0.0

GetFilterFieldTop

PivotField GetFilterField()

Get a filter field from pivot.

Show/Hide Code

Supported from version: 1.0.0.0

SetDataFieldForSortingTop

void SetDataFieldForSorting()

Set a data field used for pivot's data sorting.

Show/Hide Code

Supported from version: 1.0.0.0

SetInitSortedGroupTop

void SetInitSortedGroup()

Set an initial default group for pivot's data sorting.

Show/Hide Code

Supported from version: 1.0.0.0

ExportToHTMLTop

void ExportToHTML()

Export a pivot HTML file.

Show/Hide Code

Supported from version: 1.0.0.0

ExportToPDFTop

void ExportToPDF()

Export a pivot PDF file.

Show/Hide Code

Supported from version: 1.0.0.0

ExportToExcelTop

void ExportToExcel()

Export a pivot Excel file.

Show/Hide Code

Supported from version: 1.0.0.0

ExportToWordTop

void ExportToWord()

Export a pivot Word file.

Show/Hide Code

Supported from version: 1.0.0.0

ProcessTop

void Process()

Process a pivot before rendering or exporting.

Show/Hide Code

Supported from version: 1.0.0.0

RenderTop

void Render()

Render pivot.

Show/Hide Code

Supported from version: 1.0.0.0