{"id":214,"date":"2011-04-12T15:12:04","date_gmt":"2011-04-12T20:12:04","guid":{"rendered":"http:\/\/xlinesoft.com\/blog\/?p=214"},"modified":"2011-08-17T11:13:32","modified_gmt":"2011-08-17T16:13:32","slug":"adding-gantt-chart-to-phprunnerasprunnerpro-app","status":"publish","type":"post","link":"https:\/\/xlinesoft.com\/blog\/2011\/04\/12\/adding-gantt-chart-to-phprunnerasprunnerpro-app\/","title":{"rendered":"Adding GANTT chart to PHPRunner\/ASPRunnerPro app"},"content":{"rendered":"

A special thank you to Fred Blau who provided the original jsgantt integration sample<\/a>.<\/em><\/p>\n

A Gantt chart is a type of bar chart that illustrates a project schedule. Gantt charts illustrate the start and finish dates of the tasks that belong to this project. Some Gantt charts also show the dependency relationships between activities (tasks). Gantt charts can be used to show current schedule status using percent-complete shadings and a vertical “TODAY” line.<\/p>\n

\"Sample
\n
\nI’ll show you how to add to GANTT chart to your PHPRunner or ASPRunnerPro project. We are going to use free Javascript jsgantt<\/a> component for this purpose. You can download PHP and ASP version of all required files at the end of this article.<\/p>\n

Jsgantt provides an API to add tasks. It can also load tasks from external XML file which we plan to use in our project.<\/p>\n

Sample XML file:<\/p>\n

\r\n\r\n\t10<\/pID>\r\n\tWCF Changes<\/pName>\r\n\t<\/pStart>\r\n\t<\/pEnd>\r\n\t0000ff<\/pColor>\r\n\t<\/pLink>\r\n\t0<\/pMile>\r\n\t<\/pRes>\r\n\t0<\/pComp>\r\n\t1<\/pGroup>\r\n\t0<\/pParent>\r\n\t1<\/pOpen>\r\n\t\r\n<\/task>\r\n\r\n\t20<\/pID>\r\n\tMove to WCF from remoting<\/pName>\r\n\t8\/11\/2008<\/pStart>\r\n\t8\/15\/2008<\/pEnd>\r\n\t0000ff<\/pColor>\r\n\t<\/pLink>\r\n\t0<\/pMile>\r\n\tRich<\/pRes>\r\n\t10<\/pComp>\r\n\t0<\/pGroup>\r\n\t10<\/pParent>\r\n\t1<\/pOpen>\r\n\t<\/pDepend>\r\n<\/task>\r\n\r\n\t30<\/pID>\r\n\tadd Auditing<\/pName>\r\n\t8\/19\/2008<\/pStart>\r\n\t8\/21\/2008<\/pEnd>\r\n\t0000ff<\/pColor>\r\n\t<\/pLink>\r\n\t0<\/pMile>\r\n\tMal<\/pRes>\r\n\t50<\/pComp>\r\n\t0<\/pGroup>\r\n\t10<\/pParent>\r\n\t1<\/pOpen>\r\n\t20<\/pDepend>\r\n<\/task>\r\n<\/project><\/pre>\n
1.<\/strong> We are going to need two tables: tblProjects and tblTasks.<\/p>\n
tblProject<\/strong> contains basic project description.<\/p>\n
CREATE TABLE `tblProject` (\r\n`ProjectID` int(11) NOT NULL AUTO_INCREMENT,\r\n`ProjectName` varchar(40) DEFAULT NULL,\r\n`StartDate` datetime DEFAULT NULL,\r\n`EndDate` datetime DEFAULT NULL,\r\nPRIMARY KEY (`ProjectID`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;<\/pre>\n
tblTasks<\/strong> contains detailed description of each task. Some fields in this table are optional and not being used in our example.<\/p>\n
CREATE TABLE `tblTasks` (\r\n`TaskID` int(11) NOT NULL AUTO_INCREMENT,\r\n`ProjectID` int(11) DEFAULT NULL,\r\n`ParentID` int(11) DEFAULT '0',\r\n`TaskName` varchar(60) DEFAULT NULL,\r\n`TaskNumber` varchar(10) DEFAULT NULL,\r\n`AssignedTo` varchar(30) DEFAULT NULL,\r\n`SchedStart` datetime DEFAULT NULL,\r\n`SchedEnd` datetime DEFAULT NULL,\r\n`ActualStart` datetime DEFAULT NULL,\r\n`ActualEnd` datetime DEFAULT NULL,\r\n`EstHours` float DEFAULT NULL,\r\n`TaskStatus` int(11) DEFAULT NULL,\r\n`PercentComplete` tinyint(4) DEFAULT NULL,\r\n`Notes` longtext,\r\n`IsGroup` tinyint(4) DEFAULT '0',\r\n`BarColorHex` varchar(6) DEFAULT '0000FF',\r\n`DependentOn` varchar(10) DEFAULT NULL,\r\nPRIMARY KEY (`TaskID`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;<\/pre>\n
2.<\/strong> Add both tables to the project and link them as Master-Details using ProjectID as a link field in both tables. Check off ‘Display child records on View page’ option.<\/p>\n
We also choose ProjectID as a key column of tblProjects table.<\/p>\n
3. <\/strong>In Visual Editor proceed to the page where you want to display the GANTT chart. In our example we add GANTT chart to the tblProjects view page. Right-click where you want to add the chart and choose ‘Insert PHP code snippet’. Paste the following code there:<\/p>\n
$value =  \"Gantt
\";\r\n\r\n$myFile = \"gantt.php?ProjectID=\".$_REQUEST[\"editid1\"];\r\n\/\/$myFile=\"gantt.xml\";\r\n\r\n$value = $value.\"\";\r\n$value = $value.\"