KoolTreeGrid

KoolTreeGrid - Great PHP TreeGridFullVersion 1.0.0.0 released on 05/22/2014

Data Types - KoolTreeGrid using array data

Property	Default Value	Example Value	Type	Description
KoolChart Id Width Height scriptFolder Transitions BackgroundColor NumberFormat DecimalNumber DecimalSeparator ThousandSeparator Padding Pad BarGapRatio CategoryGapRatio FontColor FontFamily FontSize FontStyle FontWeight Title Text Appearance Visible Position Aligh BackgroundColor FontColor FontFamily FontSize FontStyle FontWeight Legend Appearance Visible Position BackgroundColor PlotArea Appearance BackgroundColor XAxis Title Visible Color MajorTickSize MajorTickType MinorTickSize MinorTickType MaxValue MinValue MajorStep MinorStep TitleAppearance Visible Position RotationAngle SelfTranslate FullyVisible FontColor FontFamily FontSize FontStyle FontWeight LabelsAppearance Visible DataFormatString RotationAngle SelfTranslate FullyVisible FontColor FontFamily FontSize FontStyle FontWeight MajorGridLines Visible Color Width MinorGridLines Visible Color Width Items Category item 0 Text Category item 1 Text Category item 2 Text Category item 3 Text YAxis Title Visible Color MajorTickSize MajorTickType MinorTickSize MinorTickType MaxValue MinValue MajorStep MinorStep TitleAppearance Visible Position RotationAngle SelfTranslate FullyVisible FontColor FontFamily FontSize FontStyle FontWeight LabelsAppearance Visible DataFormatString RotationAngle SelfTranslate FullyVisible FontColor FontFamily FontSize FontStyle FontWeight MajorGridLines Visible Color Width MinorGridLines Visible Color Width Items Category item 0 Text Category item 1 Text Category item 2 Text Category item 3 Text ListOfSeries Series 0 ChartType Name MissingValue Stacked Appearance BackgroundColor LabelsAppearance Visible DataFormatString Position RotationAngle FontColor FontFamily FontSize FontStyle FontWeight MarkersAppearance Visible MarkersType BackgroundColor TooltipsAppearance Visible DataFormatString BackgroundColor FontColor FontFamily FontSize FontStyle FontWeight Items Series item 0 YValue Series item 1 YValue Series item 2 YValue Series item 3 YValue ClientEvents OnItemOver OnItemClick OnItemDblClick			Object
	<user input>		String	Chart's id
	800		Number	Chart's width
	500		Number	Chart's height
	null		String	Path to KoolChart's control
	true		Bool	Enable chart's transition effects or not
	#ffffff		String	Set chart's background color
	true		Bool	Set whether number in series and axis will be formatted
	0		Number	Number of numbers after decimal point
	.		String	Decimal point
	,		String	Thousand separator
	20		Number	Set's one value for chart's top, bottom, left and right padding
	null		Array	Set's each value for chart's top, bottom, left and right padding
	1/2		Number	Set's gap over bar width ratio
			Number	Set's gap over category width ratio
	#3c4c30		String	Set chart's font color
	Arial,Helvetica,sans-serif		String	Set chart's font family
	12px		String	Set chart's font size
	normal		String	Set chart's font style
	normal		String	Set chart's font weight
			Object	Chart's title
	Chart Title		String	Title's text
			Object	Title's appearance
	true		Bool	Set title visible or not
	top		String	Set title's position
	center		String	Set title's alignment
	<empty string>		String	Set title's background color
	<empty string>		String	Set title's font color
	<empty string>		String	Set title's font family
	16px		String	Set title's font size
	<empty string>		String	Set title's font style
<empty string>		String	Set title's font weight
		Object	Chart's legend
		Object	Title's appearance
TRUE		Bool	Set legend visible or not
top		String	Set legend's position
<empty string>		String	Set legend's background color
		Object	Chart's plot area
		Object	Plot area's appearance
<empty string>		String	Set plot area's background color
		Object	Plot area's X axis
<empty string>		String	X axis' title
TRUE		Bool	Set X axis' visibility
#b3b3b3		String	Set X axis' color
2		Number	Set X axis' major tick size
outside		String	Set X axis' major tick type
1		Number	Set X axis' minor tick size
outside		String	Set X axis' minor tick type
null		Number	Set X axis' max value
null		Number	Set X axis' min value
null		Number	Set X axis' major step
null		Number	Set X axis' minor step
		Object	X axis' title appearance
TRUE		Bool	Set X axis' title visibility
<empty string>		String	Set X axis' title's position
0		Number	X axis' title's initial angle
null		Array	X axis' title's initial translation by each one's length and height
null		Bool	Automatically adjust plot area to make room for X long title or not
<empty string>		String	Set X axis' title's font color
<empty string>		String	Set X axis' title's font family
16px		String	Set X axis' title's font size
<empty string>		String	Set X axis' title's font style
<empty string>		String	Set X axis' title's font weight
		Object	X axis' label appearance
TRUE		Bool	Set X axis' label's visibility
{0}		String	Set the format of X axis' labels
0		Number	X axis' label's initial angle
null		Array	X axis' label's initial translation by each one's length and height
null		Bool	Automatically adjust plot area to make room for X long labels or not
<empty string>		String	Set X axis' label's font color
<empty string>		String	Set X axis' label's font family
<empty string>		String	Set X axis' label's font size
<empty string>		String	Set X axis' label's font style
<empty string>		String	Set X axis' label's font weight
		Object	X axis' major grid line appearance
true		Bool	Set X axis' major grid line's visibility
#efefef		String	Set X axis' major grid line's color
1		Number	Set X axis' major grid line's width
		Object	X axis' minor grid line appearance
true		Bool	Set X axis' minor grid line's visibility
#f7f7f7		String	Set X axis' minor grid line's color
1		Number	Set X axis' minor grid line's width
<empty array>		Array	X axis' array of category items
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
		Object	Plot area's Y axis
<empty string>		String	Y axis' title
TRUE		Bool	Set Y axis' visibility
#b3b3b3		String	Set Y axis' color
2		Number	Set Y axis' major tick size
outside		String	Set Y axis' major tick type
1		Number	Set Y axis' minor tick size
outside		String	Set Y axis' minor tick type
null		Number	Set Y axis' max value
null		Number	Set Y axis' min value
null		Number	Set Y axis' major step
null		Number	Set Y axis' minor step
		Object	Y axis' title appearance
TRUE		Bool	Set Y axis' title's visibility
<empty string>		String	Set Y axis' title's position
0		Number	Y axis' title's initial angle
null		Array	Y axis' title's initial translation by each one's length and height
null		Bool	Automatically adjust plot area to make room for X long title or not
<empty string>		String	Set Y axis' title's font color
<empty string>		String	Set Y axis' title's font family
16px		String	Set Y axis' title's font size
<empty string>		String	Set Y axis' title's font style
<empty string>		String	Set Y axis' title's font weight
		Object	Y axis' label appearance
TRUE		Bool	Set Y axis' label's visibility
{0}		String	Set the format of Y axis' labels
0		Number	Y axis' label's initial angle
null		Array	Y axis' label's initial translation by each one's length and height
null		Bool	Automatically adjust plot area to make room for Y long labels or not
<empty string>		String	Set Y axis' label's font color
<empty string>		String	Set Y axis' label's font family
<empty string>		String	Set Y axis' label's font size
<empty string>		String	Set Y axis' label's font style
<empty string>		String	Set Y axis' label's font weight
		Object	Y axis' major grid line appearance
true		Bool	Set Y axis' major grid line's visibility
#efefef		String	Set Y axis' major grid line's color
1		Number	Set Y axis' major grid line's width
		Object	Y axis' minor grid line appearance
true		Bool	Set Y axis' minor grid line's visibility
#f7f7f7		String	Set Y axis' minor grid line's color
1		Number	Set Y axis' minor grid line's width
<empty array>		Array	Y axis' array of category items
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
null		Object	Category item
null		String	Category item's text
<empty array>		Array	Array of chart series
null		Object	Chart series
null		String	Set chart type
null		String	Set series' name
null		String	Set replacement for missing values
null		Bool	Set true to make series a stacked chart
null		Object	Series' appearance
null		String	Set series' background color
null		Object	Series' label appearance
null		Bool	Set series' label's visibility
null		String	Set the format of series' labels
null		String	Set the position of series' labels
null		Number	series' label's initial angle
null		String	Set series' label's font color
null		String	Set series' label's font family
null		String	Set series' label's font size
null		String	Set series' label's font style
null		String	Set series' label's font weight
null		Object	Series' marker appearance
null		Bool	Set series' marker's visibility
null		String	Set the type of series' markers
null		String	Set the background color of series' markers
null		Object	Series' tooltip appearance
null		Bool	Set series' label's visibility
null		String	Set the format of series' labels
null		String	Set the background color of series' markers
null		String	Set series' label's font color
null		String	Set series' label's font family
null		String	Set series' label's font size
null		String	Set series' label's font style
null		String	Set series' label's font weight
null		Array	Array of series' items
null		Object	Series' item
null		Number	Set the value of the item
null		Object	Series' item
null		Number	Set the value of the item
null		Object	Series' item
null		Number	Set the value of the item
null		Object	Series' item
null		Number	Set the value of the item
<empty array>		Object	Chart's client events
null		String	Set handler of client event mouse over item
null		String	Set handler of client event item clicked
null		String	Set handler of client event item double clicked

Description & Sample code

Description Example.php Documentation

To use an table array as data for KoolTreeGrid, you must provide an id field and parent field for each row which is used to construct the tree relation between rows.
A meta field is optional that will provide options like row expanding or not, displaying type for each cell, etc.
For example:

  
    $arr = array(
        array('id' => '1', 'parent' => '' , 'type' => 'Captain', 'level' => '1'),
        array('id' => '2', 'parent' => '1', 'type' => 'Crew member', 'level' => '2'),
        array('id' => '3', 'parent' => '2', 'type' => 'Apprentice', 'level' => '3'),
    );
    $treeGrid = KoolTreeGrid::newTreeGrid(array(
        'ArrayData' => $arr,
        'idField' => 'id',
        'parentField' => 'parent',
        'columns' => array(
            array(
                'field' => 'type',
            ),
            array(
                'field' => 'level',
            ),
        ),
    ));