Sign in to follow this  
Gantt Charts

Gantt Charts Display Logic Code Ignitor

Recommended Posts

Hi..Below is my code.I have struggled for months on how to display the data from the Data Base but not succeeded

Even go-ogled but not getting any results.Kindly assist

 

 

<script src="Learning/firstchart/fusioncharts/FusionCharts.js" type="text/javascript"></script>

<?php

$path= base_url()."Learning/FusionCharts.php";

echo $path;

include "Learning/FusionCharts.php";

 

$string='<chart manageResize="1" dateFormat="dd/mm/yyyy" outputDateFormat="ddds mns yy" ganttWidthPercent="65" canvasBorderColor="999999" canvasBorderThickness="0" gridBorderColor="4567aa" gridBorderAlpha="20" ganttPaneDuration="3" ganttPaneDurationUnit="m" >\n\

<categories bgColor="009999">\n\

<category start="1/3/2008" end="31/8/2008" label="Residential Construction" fontColor="ffffff" fontSize="16" />\n\

</categories>\n\

<categories bgColor="4567aa" fontColor="ff0000">\n\

<category start="1/3/2008" end="31/8/2008" label="Months" alpha="" font="Verdana" fontColor="ffffff" fontSize="16" />\n\

</categories>\n\

<categories bgColor="ffffff" fontColor="1288dd" fontSize="10" isBold="1" align="center">\n\

<category start="1/3/2008" end="31/3/2008" label="March" />\n\

<category start="1/4/2008" end="30/4/2008" label="April" />\n\

<category start="1/5/2008" end="31/5/2008" label="May" />\n\

<category start="1/6/2008" end="30/6/2008" label="June" />\n\

<category start="1/7/2008" end="31/7/2008" label="July" />\n\

<category start="1/8/2008" end="31/8/2008" label="August" />\n\

</categories>\n\

<processes headerText="Task" fontColor="000000" fontSize="11" isAnimated="1" bgColor="4567aa" headerVAlign="bottom" headerAlign="left" headerbgColor="4567aa" headerFontColor="ffffff" headerFontSize="12" align="left" isBold="1" bgAlpha="25">\n\

 

<process label="Writing" id="1" />\n\

<process label="Signing" id="2" />\n\

<process label="Financing" id="3" />\n\

<process label="Permission" id="4" />\n\

<process label="Plumbing" id="5" />\n\

<process label="Terrace" id="6" />\n\

<process label="Inspection" id="7" />\n\

<process label="Wood Work" id="8" />\n\

<process label="Interiors" id="9" />\n\

<process label="Shifting" id="10" />\n\

</processes>\n\

<dataTable showProcessName="1" nameAlign="left" fontColor="000000" fontSize="10" vAlign="right" align="center" headerVAlign="bottom" headerAlign="left" headerbgColor="4567aa" headerFontColor="ffffff" headerFontSize="12" >\n\

<dataColumn bgColor="eeeeee" headerText="Start" >\n\

<text label="7/3/2008" />\n\

<text label="6/4/2008" />\n\

<text label="1/5/2008" />\n\

<text label="13/5/2008" />\n\

<text label="2/5/2008" />\n\

<text label="1/6/2008" />\n\

<text label="15/6/2008" />\n\

<text label="22/6/2008" />\n\

<text label="18/6/2008" />\n\

<text label="15/7/2008" />\n\

</dataColumn>\n\

<dataColumn bgColor="eeeeee" headerText="Finish">\n\

<text label="22/4/2008" />\n\

<text label="12/5/2008" />\n\

<text label="2/6/2008" />\n\

<text label="19/6/2008" />\n\

<text label="19/6/2008" />\n\

<text label="19/7/2008" />\n\

<text label="11/8/2008" />\n\

<text label="5/8/2008" />\n\

<text label="22/7/2008" />\n\

<text label="11/8/2008" />\n\

</dataColumn>\n\

<dataColumn bgColor="eeeeee" headerText="Hrs">\n\

<text label="150" />\n\

<text label="340" />\n\

<text label="60" />\n\

<text label="20" />\n\

<text label="30" />\n\

<text label="45" />\n\

<text label="40" />\n\

<text label="102" />\n\

<text label="60" />\n\

<text label="30" />\n\

<text label="90" />\n\

<text label="30" />\n\

</dataColumn>\n\

<dataColumn align="right" bgColor="4567aa" bgAlpha="25" headerText="Cost" isBold="1">\n\

<text label="$4100" />\n\

<text label="$8290" />\n\

<text label="$12340" />\n\

<text label="$2330" />\n\

<text label="$4550" />\n\

<text label="$15720" />\n\

<text label="$1780" />\n\

<text label="$32330" />\n\

<text label="$9890" />\n\

<text label="$1110" />\n\

<text label="$1260" />\n\

<text label="$4260" />\n\

 

</dataColumn>\n\

</dataTable>\n\

<tasks>\n\

<task label="Planned" processId="1" start="7/3/2008" end="18/4/2008" id="1-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="1" start="9/3/2008" end="22/4/2008" id="1" color="EEEEEE" alpha="100" topPadding="56%" height="32%" />\n\

<task label="Planned" processId="8" start="22/6/2008" end="29/7/2008" id="2-1" color="4567aa" alpha="100" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="8" start="22/6/2008" end="5/8/2008" id="2" color="EEEEEE" alpha="100" height="32%" topPadding="56%" percentComplete="78"/>\n\

<task label="Planned" processId="2" start="6/4/2008" end="2/5/2008" id="3-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="2" start="6/4/2008" end="12/5/2008" id="3" color="EEEEEE" alpha="100" isAnimated="1" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="9" start="18/6/2008" end="21/7/2008" id="4-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="9" start="18/6/2008" end="22/7/2008" id="4" color="EEEEEE" alpha="100" isAnimated="1" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="3" start="1/5/2008" end="2/6/2008" id="5-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="3" start="1/5/2008" end="2/6/2008" id="5" color="EEEEEE" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="4" start="11/5/2008" end="12/6/2008" id="6-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="4" start="13/5/2008" end="19/6/2008" id="6" color="EEEEEE" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="5" start="1/5/2008" end="12/6/2008" id="7-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="5" start="2/5/2008" end="19/6/2008" id="7" color="EEEEEE" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="6" start="1/6/2008" end="12/7/2008" id="8-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="6" start="1/6/2008" end="19/7/2008" Id="8" color="EEEEEE" height="32%" topPadding="56%" percentComplete="91"/>\n\

<task label="Planned" processId="7" start="11/6/2008" end="7/8/2008" Id="9-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="7" start="15/6/2008" end="11/8/2008" Id="9" color="EEEEEE" height="32%" topPadding="56%"/>\n\

<task label="Planned" processId="10" start="11/7/2008" end="7/8/2008" Id="10-1" color="4567aa" height="32%" topPadding="12%" />\n\

<task label="Actual" processId="10" start="15/7/2008" end="11/8/2008" Id="10" color="EEEEEE" height="32%" topPadding="56%"/>\n\

</tasks>\n\

<connectors>\n\

<connector fromTaskId="3" toTaskId="5" color="4567aa" thickness="2" fromTaskConnectStart="1"/>\n\

<connector fromTaskId="8" toTaskId="2" color="4567aa" thickness="2" fromTaskConnectStart="1"/>\n\

</connectors>\n\

<milestones>\n\

<milestone date="7/8/2008" taskId="10-1" color="2E4472" shape="star" toolText="Original moving date" />\n\

<milestone date="21/8/2008" taskId="10" color="999999" shape="star" toolText="New estimated moving date" />\n\

</milestones>\n\

<legend>\n\

<item label="Planned" color="4567aa" />\n\

<item label="Actual" color="999999" />\n\

<item label="Slack (Delay)" color="FF5E5E" />\n\

</legend>\n\

<styles>\n\

<definition>\n\

<style type="Font" name="legendFont" size="12" />\n\

</definition>\n\

<application>\n\

<apply toObject="LEGEND" styles="legendFont" />\n\

</application>\n\

</styles>\n\

</chart>';

 

 

echo renderChart("".base_url()."Learning/firstchart/fusioncharts/Gantt.swf", "",rawurlencode($string), "myChartId", 800, 500, false, false);

 

?>

$strXML .= "<set label='" . $ors['FactoryName'] . "' value='" . $ors2['TotOutput'] . "' />";

 

 

The code just displays the original template..Don't even have a clue on where or how to place the loops.

Note its in code ignitor

 

Share this post


Link to post
Share on other sites
Guest Sashibhusan

Hi,

 

Welcome to FusionCharts Forum.

 

To plot the data from the database using FusionCharts, you would need to build the XML string in the format which FusionCharts support for the Gantt chart.

 

For more information on "Step by Step tutorial on FusionCharts with PHP and MySQL", please visit the blog link: http://blog.fusioncharts.com/2012/03/javascript-charts-using-php-and-mysql-with-fusioncharts-xt-part-2/

 

Hope this helps!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this