The DHX Gantt Chart control is independently owned, licensed, and maintained by DHX. License terms, pricing, and the DHX Gantt documentation can be found on the DHX Gantt web site.
After purchasing ACDS Gantt, you will receive an email with a link for downloading the installer as well as your license key. You will need the key to install. There is a video that shows the installation process located at: http://www.a5customsolutions.com/gantt_video.html
The Gantt chart requires two tables, a tasks table and a links table. Below are the minimum requirements for the table structure for use in the ACDS Gantt control. Note that these requirements may not the same as those posted on the DHX website's Gantt documentation. Due to the many variables in making a product for use by the masses I decided to make the "open" and "type" columns required.
The links table will only ever have four columns. In both tables the first column must be the primary key, auto increment. The data types of the required columns is important. Column names are not as important, although some names may conflict with the dhtmlxGantt code.
/* MySQL format */ CREATE TABLE `gantt_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `source` int(11) NOT NULL, `target` int(11) NOT NULL, `type` varchar(1) NOT NULL, PRIMARY KEY (`id`) )
The tasks table can use either a duration interval, or an end date, for the time span of a task. Up to five custom columns, in addition to the required columns can be added for additional data. See the section on user defined columns for more detail. An example of the table structures in MySQL is below. Adjust the column types for your database.
/* For duration based tasks - MySQL format */ CREATE TABLE `gantt_tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `text` varchar(255) NOT NULL, `start_date` datetime NOT NULL, `duration` int(11) NOT NULL, `progress` float NOT NULL, `sortorder` int(11) NOT NULL, `parent` int(11) NOT NULL, `open` tinyint(1)DEFAULT 0 NOT NULL, `type` varchar(255)DEFAULT 'TASK' NOT NULL, PRIMARY KEY (`id`) )
/* For end date based tasks - MySQL format */ CREATE TABLE `gantt_tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `text` varchar(255) NOT NULL, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `progress` float NOT NULL, `sortorder` int(11) NOT NULL, `parent` int(11) NOT NULL, `open` tinyint(1) DEFAULT 0 NOT NULL, `type` varchar(255)DEFAULT 'TASK' NOT NULL, PRIMARY KEY (`id`) )
The ACDS Gantt component builder allows for the use of up to five additional columns in the tasks table. These can be most data types. The data in the columns will be sent to the client and can be used in the Gantt Chart. Changes made to the values of the custom columns are persisted back to the database when their values are changed in the Gantt Chart. See the video on custom task columns for more information. http://www.a5customsolutions.com/gantt_video.html
For a detailed overview of creating your first ACDS Gantt there is a video located at: http://www.a5customsolutions.com/gantt_video.html
Copyright © 2014 Alpha Custom Database Solutions, LLC