DataTable

Creates a new DataTable

Create a new DataCell for a value in a Row

v: The cell value. The data type should match the column data type. If null, the whole object should be empty and have neither v nor f properties.

f: [Optional] A string version of the v value, formatted for display. The values should match, so if you specify Date(2008, 0, 1) for v, you should specify "January 1, 2008" or some such string for this property. This value is not checked against the v value. The visualization will not use this value for calculation, only as a label for display. If omitted, a string version of v will be used.

p: [Optional] An object that is a map of custom values applied to the cell. These values can be of any JavaScript type. If your visualization supports any cell-level properties, it will describe them; otherwise, this property will be ignored. Example: p:{style: 'border: 1px solid green;'}.

Parses a string of JSON data into a DataTable.

Most google examples can be passed to this method with some tweaks. PHP requires that only double quotes are used on identifiers. For example: - {label: 'Team'} would be invalid - {"label": "Team"} would be accepted.

Sets the Timezone that Carbon will use when parsing dates This will use the passed timezone, falling back to the default from php.ini, and falling back from that to America/Los_Angeles

Returns the current timezone used in the DataTable

Sets the format to be used by Carbon::createFromFormat()

This method is used to set the format to be used to parse a string passed to a cell in a date column, that was parsed incorrectly by Carbon::parse()

Returns the set DateTime format.

Returns a bare clone of the DataTable.

This method clone the DataTable and strip the rows off. Useful when loading charts via ajax, and you need the initial DataTable structure to pre-load the chart's format.

Adds a column to the DataTable

First signature has the following parameters: type - A string with the data type of the values of the column. The type can be one of the following: 'string' 'number' 'bool' 'date' 'datetime' 'timeofday'.

columnLabel - [Optional] A string with the label of the column. The column label is typically displayed as part of the visualization, for example as a column header in a table, or as a legend label in a pie chart. If not value is specified, an empty string is assigned. optId - [Optional] A string with a unique identifier for the column. If not value is specified, an empty string is assigned.

Adds multiple columns to the DataTable

Supplemental function to add a boolean column with less params.

Supplemental function to add a string column with less params.

Supplemental function to add a date column with less params.

Supplemental function to add a datetime column with less params.

Supplemental function to add a timeofday column with less params.

Supplemental function to add a number column with less params.

Adds a new column for defining a data role.

Drops a column and its data from the DataTable

Sets the format of the column.

Sets the format of multiple columns.

Add a row to the DataTable

Each cell in the table is described by an array with the following properties:

v [Optional] The cell value. The data type should match the column data type. If null, the whole object should be empty and have neither v nor f properties.

f [Optional] A string version of the v value, formatted for display. The values should match, so if you specify Date(2008, 0, 1) for v, you should specify "January 1, 2008" or some such string for this property. This value is not checked against the v value. The visualization will not use this value for calculation, only as a label for display. If omitted, a string version of v will be used.

p [Optional] An object that is a map of custom values applied to the cell. These values can be of any JavaScript type. If your visualization supports any cell-level properties, it will describe them; otherwise, this property will be ignored. Example: p:{style: 'border: 1px solid green;'}.

Cells in the row array should be in the same order as their column descriptions in cols. To indicate a null cell, you can specify null. To indicate a row with null for the first two cells, you would specify [null, null, {cell_val}].

Adds multiple rows to the DataTable.

Returns the rows array from the DataTable

Returns the number of rows in the DataTable

Returns a column based on it's index.

Returns the column array from the DataTable

Returns the columns whos type match the given value.

Returns the number of columns in the DataTable

Returns the label of a column based on it's index.

Returns the type of a column based on it's index.

Returns the types of columns currently defined.

Returns the labels of columns currently defined.

Returns the column array from the DataTable

Boolean value if there are any formatted columns

Convert the DataTable to JSON

Custom serialization of the DataTable.