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
AjaxLoadingImageTop
String AjaxLoadingImage
Get or set a pivot's ajax loading image.
Supported from version: 1.0.0.0
AllowFilteringTop
bool AllowFiltering
Enable or disable a pivot's filtering on fields.
Supported from version: 1.0.0.0
AllowReorderTop
bool AllowReorder
Enable or disable a pivot's reordering of fields.
Supported from version: 1.0.0.0
AllowSortingTop
bool AllowSorting
Enable or disable a pivot's sorting on fields.
Supported from version: 1.0.0.0
AllowSortingDataTop
bool AllowSortingData
Enable or disable a pivot's sorting on data.
Supported from version: 1.0.0.0
CacheTimeTop
Number CacheTime
Get or set a pivot's cache expired time.
Supported from version: 1.0.0.0
DataSourceTop
PivotDataSource DataSource
Get or set a pivot's data source.
Supported from version: 1.0.0.0
EmptyValueTop
String EmptyValue
Get or set a pivot's displaying value for empty cell.
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.
Supported from version: 1.0.0.0
EventHandlerTop
object EventHandler
Get or set a pivot's event handler object.
Supported from version: 1.0.0.0
ExportSettingsTop
Object ExportSettings
Get or set a pivot's export settings.
Supported from version: 1.0.0.0
HorizontalScrollingTop
bool HorizontalScrolling
Enable or disable a pivot's horizontal scrolling.
Supported from version: 1.0.0.0
KeepViewStateInSessionTop
bool KeepViewStateInSession
Enable or disable a pivot's viewstate to be save in SESSION global variable.
Supported from version: 1.0.0.0
LocalizationTop
object Localization
Get or set a pivot's localization property.
Supported from version: 1.0.0.0
RowHeaderMinWidthTop
Number RowHeaderMinWidth
Get or set a pivot's minimum row headers' width.
Supported from version: 1.0.0.0
scriptFolderTop
String scriptFolder
Get or set a pivot's script folder path.
Supported from version: 1.0.0.0
ShowColumnZoneTop
bool ShowColumnZone
Enable or disable a pivot's column fields zone.
Supported from version: 1.0.0.0
ShowDataZoneTop
bool ShowDataZone
Enable or disable a pivot's data fields zone.
Supported from version: 1.0.0.0
ShowFilterZoneTop
bool ShowFilterZone
Enable or disable a pivot's filter fields zone.
Supported from version: 1.0.0.0
ShowRowZoneTop
bool ShowRowZone
Enable or disable a pivot's row fields zone.
Supported from version: 1.0.0.0
ShowStatusTop
bool ShowStatus
Enable or disable a pivot's status zone.
Supported from version: 1.0.0.0
VerticalScrollingTop
bool VerticalScrolling
Enable or disable a pivot's vertical scrolling.
Supported from version: 1.0.0.0
Methods Detail
ConstructorTop
KoolPivotTable Constructor()
Create a KoolPivotTable object.
Supported from version: 1.0.0.0
GetDataFieldTop
PivotField GetDataField()
Get a data field from pivot.
Supported from version: 1.0.0.0
GetColumnFieldTop
PivotField GetColumnField()
Get a column field from pivot.
Supported from version: 1.0.0.0
GetFilterFieldTop
PivotField GetFilterField()
Get a filter field from pivot.
Supported from version: 1.0.0.0
SetDataFieldForSortingTop
void SetDataFieldForSorting()
Set a data field used for pivot's data sorting.
Supported from version: 1.0.0.0
SetInitSortedGroupTop
void SetInitSortedGroup()
Set an initial default group for pivot's data sorting.
Supported from version: 1.0.0.0
ProcessTop
void Process()
Process a pivot before rendering or exporting.
Supported from version: 1.0.0.0