<?php
/*
 Reportico - PHP Reporting Tool
 Copyright (C) 2010-2014 Peter Deed

 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 as published by the Free Software Foundation; either version 2
 of the License, or (at your option) any later version.
 
 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

 * File:        swgraph_nvd3.php
 *
 * Contains functionality for generating inline report
 * graphs. The Reportico engine will either - depending
 * on the output format - generate URL string to create
 * the graph or generate the graph itself using these
 * classes.
 *
 * @link http://www.reportico.org/
 * @copyright 2010-2014 Peter Deed
 * @author Peter Deed <info@reportico.org>
 * @package Reportico
 * @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
 * @version $Id: swgraph_nvd3.php,v 1.3 2014/05/17 15:12:31 peter Exp $
 */


error_reporting(E_ALL);

if ( function_exists( "imagecreatefromstring" ) )
{
    //include("pChart/class/pData.class.php");
    //include("pChart/class/pDraw.class.php");
    //include("pChart/class/pImage.class.php");
    //include("pChart/class/pPie.class.php");
    include("pChart/pChart.class");
    include("pChart/pData.class");
    include("pChart/pCache.class");

    $fontpath = find_best_location_in_include_path( "pChart/fonts" );
    define ( "PCHARTFONTS_DIR", $fontpath."/" );
}
else
{
    echo "GD not installed ( imagecreatefromstring function does not exist )";
    die;
}
require_once('swutil.php');



/**
 * Class reportico_graph
 *
 * Storage and generation of report graphs. Holds
 * everything necessary such as titles, axis formatting, 
 * graph type, colours etc
 */
class reportico_graph
{
	var $calling_mode = "INTERNAL";
	var $graph_column = "";
	var $title = "Set Title";
	var $title_actual = "Set Title";
	var $xtitle = "Set Title";
	var $ytitle = "Set Title";
	var $xtitle_actual = "Set Title";
	var $ytitle_actual = "Set Title";
	var $graphcolor = ".DEFAULT";
	var $width = ".DEFAULT";
	var $height = ".DEFAULT";
	var $width_actual = 400;
	var $height_actual = 200;
	var $width_pdf_actual = 400;
	var $height_pdf_actual = 200;
	var $xtickinterval_actual = 1;
	var $xticklabelinterval_actual = 1;
	var $xaxiscolor_actual = "black";
	var $ytickinterval_actual = 1;
	var $yticklabelinterval_actual = 1;
	var $yaxiscolor_actual = "black";
	var $graphcolor_actual = "white";
	var $margincolor_actual;
	var $marginleft_actual;
	var $marginright_actual;
	var $margintop_actual;
	var $marginbottom_actual;
	var $gridpos_actual = ".DEFAULT";
	var $xgriddisplay_actual = ".DEFAULT";
	var $xgridcolor_actual = ".DEFAULT";
	var $ygriddisplay_actual = ".DEFAULT";
	var $ygridcolor_actual = ".DEFAULT";
	var $titlefont_actual = "";
	var $titlefontstyle_actual = "";
	var $titlefontsize_actual = ".DEFAULT";
	var $titlecolor_actual = ".DEFAULT";
	var $xtitlefont_actual = "";
	var $xtitlefontstyle_actual = "";
	var $xtitlefontsize_actual = ".DEFAULT";
	var $xtitlecolor_actual = ".DEFAULT";
	var $ytitlefont_actual = "";
	var $ytitlefontstyle_actual = "";
	var $ytitlefontsize_actual = ".DEFAULT";
	var $ytitlecolor_actual = ".DEFAULT";
	var $xaxisfont_actual = "";
	var $xaxisfontstyle_actual = "";
	var $xaxisfontsize_actual = ".DEFAULT";
	var $xaxisfontcolor_actual = ".DEFAULT";
	var $yaxisfont_actual = "";
	var $yaxisfontstyle_actual = "";
	var $yaxisfontsize_actual = ".DEFAULT";
	var $yaxisfontcolor_actual = ".DEFAULT";

	var $width_pdf = ".DEFAULT";
	var $height_pdf = ".DEFAULT";
	var $titlefont = ".DEFAULT";
	var $titlefontstyle = ".DEFAULT";
	var $titlefontsize = ".DEFAULT";

	var $gridpos = ".DEFAULT";
	var $xgriddisplay = ".DEFAULT";
	var $xgridcolor = ".DEFAULT";
	var $ygriddisplay = ".DEFAULT";
	var $ygridcolor = ".DEFAULT";

	var $yaxiscolor = ".DEFAULT";
	var $yaxisfont = ".DEFAULT";
	var $yaxisfontstyle = ".DEFAULT";
	var $yaxisfontsize = ".DEFAULT";
	var $yaxisfontcolor = ".DEFAULT";
	var $xaxiscolor = ".DEFAULT";
	var $xaxisfont = ".DEFAULT";
	var $xaxisfontstyle = ".DEFAULT";
	var $xaxisfontsize = ".DEFAULT";
	var $xaxisfontcolor = ".DEFAULT";
	var $xtitlefont = ".DEFAULT";
	var $xtitlefontstyle = ".DEFAULT";
	var $xtitlefontsize = ".DEFAULT";
	var $xtitlecolor = ".DEFAULT";
	var $xtickinterval = ".DEFAULT";
	var $xticklabelinterval = ".DEFAULT";
	var $ytitlefont = ".DEFAULT";
	var $ytitlefontstyle = ".DEFAULT";
	var $ytitlefontsize = ".DEFAULT";
	var $ytitlecolor = ".DEFAULT";
	var $ytickinterval = ".DEFAULT";
	var $yticklabelinterval = ".DEFAULT";
	var $titlecolor = ".DEFAULT";
	var $margincolor = ".DEFAULT";
	var $marginleft = ".DEFAULT";
	var $marginright = ".DEFAULT";
	var $margintop = ".DEFAULT";
	var $marginbottom = ".DEFAULT";
	var $xlabel_column = "";
	var $ylabel_column = "";
	var $xlabels = array();
	var $ylabels = array();
	var $plot = array();
	var $reportico = false;

	function __construct(&$reportico, $in_mode, $in_val = "")
	{
		$this->reportico = $reportico;
		$this->calling_mode = $in_mode;
		$this->graph_column = $in_val;
	}

	function &create_plot($in_query)
	{
        	$pl = array(
                "number" => count($this->plot),
                "name" => $in_query,
                "type" => "LINE",
                "fillcolor" => "",
                "linecolor" => "",
                "datatype" => "number",
                "legend" => "",
                "data" => array()
            );
        $this->plot[] =& $pl;

		return ( $pl );
	}

	function clear_data()
	{
		foreach ( $this->plot as $k => $v )
		{
			$this->plot[$k]["data"] = array();
		}
		$this->xlabels = array();
		$this->ylabels = array();
	}

	function add_xlabel($in_val)
	{
		$in_val = @preg_replace("/&/", "+", $in_val);
		$this->xlabels[] = $in_val;
	}

	function add_plot_value($in_query, $plot_no, $in_val)
	{
		$in_val = trim($in_val);
		$in_val = str_replace(",", "", $in_val);
		if ( !$in_val )
			$in_val = 0;
		foreach ( $this->plot as $k => $v )
		{
			if ( $v["name"] == $in_query && $v["number"] == $plot_no  )
			{
				switch ( $v["datatype"] )
				{
					case "hhmmss":
						$this->plot[$k]["data"][] = hhmmss_to_seconds($in_val);
						break;

					default:
						$this->plot[$k]["data"][] = $in_val;
				}
			}
		}
	}

	function convert_special_chars($intext)
	{
		$outtext = preg_replace("/&/", "<AMPERSAND>", $intext);
		return $outtext;
	}

	function generate_url_params($target_format, $session_placeholder=false)
	{
		$this->apply_defaults();


		$result = "";
        $url = "";
		$url .= "&graphcolor=".$this->graphcolor_actual;
		$url .= "&gridposition=".$this->gridpos_actual;
		$url .= "&xgriddisplay=".$this->xgriddisplay_actual;
		$url .= "&xgridcolor=".$this->xgridcolor_actual;
		$url .= "&ygriddisplay=".$this->ygriddisplay_actual;
		$url .= "&ygridcolor=".$this->ygridcolor_actual;
		$url .= "&titlefont=".$this->titlefont_actual;
		$url .= "&titlefontstyle=".$this->titlefontstyle_actual;
		$url .= "&titlefontsize=".$this->titlefontsize_actual;
		$url .= "&titlecolor=".$this->titlecolor_actual;
		$url .= "&xaxiscolor=".$this->xaxiscolor_actual;
		$url .= "&xaxisfont=".$this->xaxisfont_actual;
		$url .= "&xaxisfontstyle=".$this->xaxisfontstyle_actual;
		$url .= "&xaxisfontsize=".$this->xaxisfontsize_actual;
		$url .= "&xaxisfontcolor=".$this->xaxisfontcolor_actual;
		$url .= "&yaxiscolor=".$this->yaxiscolor_actual;
		$url .= "&yaxisfont=".$this->yaxisfont_actual;
		$url .= "&yaxisfontstyle=".$this->yaxisfontstyle_actual;
		$url .= "&yaxisfontsize=".$this->yaxisfontsize_actual;
		$url .= "&yaxisfontcolor=".$this->yaxisfontcolor_actual;
		$url .= "&xtitlefont=".$this->xtitlefont_actual;
		$url .= "&xtitlefontstyle=".$this->xtitlefontstyle_actual;
		$url .= "&xtitlefontsize=".$this->xtitlefontsize_actual;
		$url .= "&xtitlecolor=".$this->xtitlecolor_actual;
		$url .= "&xtickint=".$this->xtickinterval_actual;
		$url .= "&xticklabint=".$this->xticklabelinterval_actual;
		$url .= "&ytitlefont=".$this->ytitlefont_actual;
		$url .= "&ytitlefontstyle=".$this->ytitlefontstyle_actual;
		$url .= "&ytitlefontsize=".$this->ytitlefontsize_actual;
		$url .= "&ytitlecolor=".$this->ytitlecolor_actual;
		$url .= "&ytickint=".$this->ytickinterval_actual;
		$url .= "&yticklabint=".$this->yticklabelinterval_actual;
		$url .= "&margincolor=".$this->margincolor_actual;
		$url .= "&marginleft=".$this->marginleft_actual;
		$url .= "&marginright=".$this->marginright_actual;
		$url .= "&margintop=".$this->margintop_actual;
		$url .= "&marginbottom=".$this->marginbottom_actual;
		$url .= "&xlabels=".implode(",",$this->xlabels);


		foreach ( $this->plot as $k => $v )
		{
			$str = implode(",",$v["data"]);
			$url .= "&plotname$k=".$v["name"];
			$url .= "&plotdata$k=$str";
			$url .= "&plottype$k=".$v["type"];
			$url .= "&plotlinecolor$k=".$v["linecolor"];
			if ( $v["legend"] )
				$url .= "&plotlegend$k=".$v["legend"];
			if ( $v["fillcolor"] )
				$url .= "&plotfillcolor$k=".$v["fillcolor"];
		}
	
        global $g_session_namespace;
		$session_placeholder = $session_placeholder."_".$g_session_namespace;

        $js = "";
        $js .= "<div class=\"reportico-chart-container\" style=\"width: ".$this->width_actual."px;height: ".$this->height_actual."px\"> ".$this->convert_special_chars($this->title_actual);
        //$js .= "<div id=\"reportico_chart$session_placeholder\" class=\"reportico-chart-placeholder\"></div> </div>\n";

        $js .= "<div class=\"reportico-chart-placeholder\" id=\"reportico_chart$session_placeholder\" style=\"overflow-y: none; width: 100%; height:100%\"><svg style=\"width:100%;height:100%;\"></svg></div></div>";
        $js .= "<script>\n";
        $js .= "var placeholder = 'reportico_chart$session_placeholder';\n";
        $plotct = 0;
        $labels = "";
        foreach ( $this->plot as $k => $v )
        {
            if ( $v["legend"] )
                continue;
            if ( $plotct > 0 )
                $labels .= ",";
            $labels .= "\"111".$v["legend"]."\"";
            $plotct++;
        }
        $js .= "var xlabels = [$labels];\n";
        $js .= "var reportico_datasets". $session_placeholder." = [];\n";


        $plotct = 0;
        $chartType = "MULTICHART";
        
        // Work out what combinations o type we have
        $has_plot_types = array();
        $showLegend = false;
        $datasetct = 0;
        for ( $k = 0; $k < count($this->plot); $k++ )
        {
            $v = $this->plot[$k];
            //if ( $k == 0 ) $v["type"] = "SCATTER";
            //if ( $k == 1 ) $v["type"] = "SCATTER";
            //if ( $k == 2 ) $v["type"] = "SCATTER";

            $label = "";
            if ( $v["legend"] )
            {
                $showLegend = true;
                $label = $v["legend"];
            }

            $js .= "values = [";

            $plotct1 = 0;
            foreach ( $v["data"] as $k1 => $v1 )
            {
                if ( $plotct1 > 0 )
                    $js .= ",";
                $xlabel = $this->xlabels[$k1];
                $key = $k1;
                if ( $v["type"] == "SCATTER" && $k < count($this->plot) - 1)
                {
                    $yvalue = $this->plot[$k+1]["data"][$k1];
                    $js .= "{index: $k1, series: 0, x: $v1, y: $yvalue, label: \"$xlabel\", value: $v1}";
                }
                else
                    $js .= "{index: $k1, series: 0, x: $key, y: $v1, label: \"$xlabel\", value: $v1}";
                $plotct1++;
            }
            $js .= "];\n";

            if ( $v["type"] == "OVERLAYBAR" ) $type = "bar";
            if ( $v["type"] == "STACKEDBAR" ) $type = "bar";
            if ( $v["type"] == "BAR" ) $type = "bar";
            if ( $v["type"] == "LINE" ) $type = "line";
            if ( $v["type"] == "AREACHART" ) $type = "area";
            if ( $v["type"] == "SCATTER" ) $type = "scatter";
            if ( $v["type"] == "PIE" ) $type = "pie";
            if ( $v["type"] == "PIE3D" ) $type = "pie";
            $has_plot_types[$v["type"]] = true;
            //$type = "bar";
            //echo $v["type"]." = $type <BR>";

            
            $js .= "reportico_datasets". $session_placeholder."[$datasetct] = { type: \"$type\", yAxis: 1, key: \"$label\", originalKey: \"$label\", values: values};\n";
            //$js .= "reportico_datasets". $session_placeholder."[$k][\"type\"] = \"line\";\n";
            $plotct++;

            $datasetct++;
            if ( $v["type"] == "SCATTER" )
            {
                $k++;
                continue;
            }
        }

        // NVD3 - we dont support overlay bar, just use regular bar
        if ( isset($has_plot_types["OVERLAYBAR"]) )
        {
            unset($has_plot_types["OVERLAYBAR"]);
            $has_plot_types["BAR"] = true;
        }

        // With any plot specified as stacked, we will stack them all as specified in stacked variable
        $stacked = false;
        if ( isset($has_plot_types["STACKEDBAR"]) )
        {
            $stacked = true;
            unset($has_plot_types["STACKEDBAR"]);
            $has_plot_types["BAR"] = true;
        }

        $chartType = "MULTICHART";
        // Decide what chart type to use. NVD3 cant mix stacked bars and lines in multichart, so if we have stacked bars only use multibar,
        // lines only use multiline otherwise use multichart. Unless of course we have PIE chart specified in which case use PIE.
        // 
        if ( isset($has_plot_types["PIE"]) ||  isset($has_plot_types["PIE3D"] )  )
        {
            $chartType = "PIE";
        }
        else
        if ( isset($has_plot_types["SCATTER"]) )
        {
            $chartType = "SCATTER";
        }
        else
        {
            // Chart contains only one type ( just lines, just areas, just bars so use relevant
            // but use multiBar chart if more than one
            if ( count($has_plot_types) == 1 )
            {
                foreach ( $has_plot_types as $k => $v )
                {
                    if ( $plotct > 1 )
                        $chartType = "MULTI".$k;
                    else
                        $chartType = $k;
                }
            }
        }



        $js .= "
    function reportico_chart_$session_placeholder() 
    {
        var colorrange = d3.scale.category10().range();
        ";


        $labct = count($this->plot[0]["data"]);
        if ( $this->xticklabelinterval_actual )
        {
            if ( $this->xticklabelinterval_actual  == "AUTO" )
            {
                $this->xticklabelinterval_actual = floor ($labct / 40 ) + 1 ;
            }
            $js .= "labelInterval = $this->xticklabelinterval_actual;";
        }
        else
            $js .= "labelInterval = false;";

        $js .= "rotateLabels = -30;";

        $labct = ( $labct / $this->xticklabelinterval_actual ) + 1;
        $labct = floor ( $labct );
        
        $js .= "labelCount = $labct;";

        if ( $stacked )
            $js .= "stacked = true;";
        else
            $js .= "stacked = false;";

        if ( $showLegend )
            $js .= "showLegend = true;";
        else
            $js .= "showLegend = false;";

        $plotct = 0;
        foreach ( $this->plot as $k => $v )
        {
            if ( $v["linecolor"] )
                $js .= "colorrange[$k] = '".$v["linecolor"]."';\n";
            $plotct++;
        }

        if ( $chartType == "PIE" )
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.pieChart()
            //.margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .margin({top: 2, right: 0, bottom: 8, left: 0})
            .color(colorrange)
                .showLabels(!showLegend)
                .showLegend(showLegend)
                //.labelType(\"value\")
                .donut(false)
                .x(function (d) 
                { 
                    return d.label;
                })
                .y(function (d) 
                { 
                    return d.value;
                })
                ;
    
    
            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder."[0].values)
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            //d3.selectAll(\"nv-legend\")
                //.style(\"display\", function (d, i) { //d is the data bound to the svg element
                    //return \"none\" ; 
                //});
            ";


            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        if ( $chartType == "DISCRETEBAR" )
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.discreteBarChart()
            .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .color(colorrange)
            ;

            chart".$session_placeholder.".xAxis
                .axisLabel('".$this->xtitle."')
                .rotateLabels (rotateLabels)
                .showMaxMin(false)
                //.staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
                .tickFormat(function (d, i, j) 
                { 
                    if ( reportico_datasets". $session_placeholder."[0].values[d] )
                    {
                        return reportico_datasets". $session_placeholder."[0].values[d].label;
                    }
                    else
                    {
                        return i;
                    }
                })
                ;
    
    
            chart".$session_placeholder.".yAxis
                .axisLabel('".$this->ytitle."')
                .tickFormat(d3.format(',.1f'));

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        if ( $chartType == "SCATTER" )
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.scatterChart()
                .showDistX(false)    //showDist, when true, will display those little distribution lines on the axis.
                .showDistY(false)
                .transitionDuration(350)
                .color(d3.scale.category10().range())
                .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
                .color(colorrange)
                ;


            //Configure how the tooltip looks.
            chart".$session_placeholder.".tooltipContent(function(key) {
                return '<h3>' + key + '</h3>';
            });

            //Axis settings
            chart".$session_placeholder.".xAxis.tickFormat(d3.format('.02f'));
            chart".$session_placeholder.".yAxis.tickFormat(d3.format('.02f'));

            //We want to show shapes other than circles.
            chart".$session_placeholder.".scatter.onlyCircles(false);

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        if ( $chartType == "BAR" || $chartType == "MULTIBAR" )
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.multiBarChart()
            .reduceXTicks (labelInterval)
            .labelCount(labelCount)
            .stacked(stacked)
            .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .color(colorrange)
            ;

            chart".$session_placeholder.".xAxis
                .axisLabel('".$this->xtitle."')
                .rotateLabels (rotateLabels)
                .showMaxMin(false)
                //.staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
                .tickFormat(function (d, i, j) 
                { 
                    if ( reportico_datasets". $session_placeholder."[0].values[d] )
                    {
                        return reportico_datasets". $session_placeholder."[0].values[d].label;
                    }
                    else
                    {
                        return i;
                    }
                })
                ;
    
    
            chart".$session_placeholder.".yAxis
                .axisLabel('".$this->ytitle."')
                .tickFormat(d3.format(',.1f'));

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })

            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        if ( $chartType == "AREACHART" || $chartType == "MULTIAREACHART" )
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.stackedAreaChart()
            .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .labelCount(labelCount)
            .color(colorrange)
            ;

            chart".$session_placeholder.".xAxis
                .axisLabel('".$this->xtitle."')
                .rotateLabels (rotateLabels)
                .showMaxMin(false)
                //.staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
                .tickFormat(function (d, i, j) 
                { 
                    if ( reportico_datasets". $session_placeholder."[0].values[d] )
                    {
                        return reportico_datasets". $session_placeholder."[0].values[d].label;
                    }
                    else
                    {
                        return i;
                    }
                })
                ;
    
    
            chart".$session_placeholder.".yAxis
                .axisLabel('".$this->ytitle."')
                .tickFormat(d3.format(',.1f'));

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        if ( $chartType == "LINE"  || $chartType == "MULTILINE")
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.lineChart()
            .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .tickInterval($this->xticklabelinterval_actual)
            .labelCount(labelCount)
            .color(colorrange)
            ;

            chart".$session_placeholder.".xAxis
                .axisLabel('".$this->xtitle."')
                .rotateLabels (rotateLabels)
                .showMaxMin(false)
                //.staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
                .tickFormat(function (d, i, j) 
                { 
                    if ( reportico_datasets". $session_placeholder."[0].values[d] )
                    {
                        return reportico_datasets". $session_placeholder."[0].values[d].label;
                    }
                    else
                    {
                        return i;
                    }
                })
                ;
    
    
            chart".$session_placeholder.".yAxis
                .axisLabel('".$this->ytitle."')
                .tickFormat(d3.format(',.1f'));

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }
        else
        {
            $js .= "
            var chart".$session_placeholder." = nv.models.multiChart()
            .margin({top: ".$this->margintop_actual.", right: ".$this->marginright_actual.", bottom: ".$this->marginbottom_actual.", left: ".$this->marginleft_actual." + 10})
            .labelCount(labelCount)
            .color(colorrange)
            ;

            chart".$session_placeholder.".xAxis
                .axisLabel('".$this->xtitle."')
                .rotateLabels (rotateLabels)
                .showMaxMin(false)
                //.staggerLabels(true)    //Too many bars and not enough room? Try staggering labels.
                .tickFormat(function (d, i, j) 
                { 
                    if ( reportico_datasets". $session_placeholder."[0].values[d] )
                    {
                        return reportico_datasets". $session_placeholder."[0].values[d].label;
                    }
                    else
                    {
                        return i;
                    }
                })
                ;
    
    
            chart".$session_placeholder.".yAxis1
                .axisLabel('".$this->ytitle."')
                .tickFormat(d3.format(',.1f'));

            d3.select(\"#reportico_chart". $session_placeholder." svg\")
            .datum(reportico_datasets". $session_placeholder.")
            .transition().duration(0)
            .call(chart".$session_placeholder.");
    
            d3.selectAll(\"rect.nv-bar\")
                .style(\"fill-opacity\", function (d, i) { //d is the data bound to the svg element
                    return .5 ; 
                })

            d3.selectAll(\".tick line\")
                .style(\"opacity\", function (d, i) { //d is the data bound to the svg element
                    return .2 ; 
                })
    
    
            nv.utils.windowResize(chart".$session_placeholder.".update);
            ";

            if ( $this->xgriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".x * * .tick line\").css(\"display\", \"none\"); ";
            if ( $this->ygriddisplay_actual == "none" )
                $js .= " reportico_jquery(\".y1 * * .tick line\").css(\"display\", \"none\"); ";
        }

        $js .= "
        }
    nv.addGraph(reportico_chart_$session_placeholder(this));

";
        $js .= "</script>\n";

		$result = $js;


		return $result;
	}

	function set_graph_color($in_col)
	{
		$this->graphcolor = $in_col;
	}
	function set_graph_column($in_val)
	{
		$this->graph_column = $in_val;
	}
	function set_title($in_title)
	{
		$this->title = $in_title;
	}
	function set_xtitle($in_xtitle)
	{
		$this->xtitle = $in_xtitle;
	}
	function set_ytitle($in_ytitle)
	{
		$this->ytitle = $in_ytitle;
	}
	function set_width_pdf($in_width)
	{
		$this->width_pdf = $in_width;
	}
	function set_height_pdf($in_height)
	{
		$this->height_pdf = $in_height;
	}
	function set_width($in_width)
	{
		$this->width = $in_width;
	}
	function set_height($in_height)
	{
		$this->height = $in_height;
	}
	function set_grid($in_pos,$in_xdisplay, $in_xcolor, $in_ydisplay, $in_ycolor)
	{
			$this->gridpos = $in_pos;
			$this->xgriddisplay = $in_xdisplay;
			$this->xgridcolor = $in_xcolor;
			$this->ygriddisplay = $in_ydisplay;
			$this->ygridcolor = $in_ycolor;
	}
	function set_xlabel_column($in_xlabel_column)
	{
		$this->xlabel_column = $in_xlabel_column;
	}
	function set_ylabel_column($in_ylabel_column)
	{
		$this->ylabel_column = $in_ylabel_column;
	}


	function set_title_font($in_font, $in_style, $in_size, $in_col)
	{
			$this->titlefont = $in_font;
			$this->titlefontstyle = $in_style;
			$this->titlefontsize = $in_size;
			$this->titlecolor = $in_col;
	}

	function set_xtitle_font($in_font, $in_style, $in_size, $in_col)
	{
			$this->xtitlefont = $in_font;
			$this->xtitlefontstyle = $in_style;
			$this->xtitlefontsize = $in_size;
			$this->xtitlecolor = $in_col;
	}

	function set_ytitle_font($in_font, $in_style, $in_size, $in_col)
	{
			$this->ytitlefont = $in_font;
			$this->ytitlefontstyle = $in_style;
			$this->ytitlefontsize = $in_size;
			$this->ytitlecolor = $in_col;
	}

	function set_xaxis_font($in_font, $in_style, $in_size, $in_col)
	{
			$this->xaxisfont = $in_font;
			$this->xaxisfontstyle = $in_style;
			$this->xaxisfontsize = $in_size;
			$this->xaxisfontcolor = $in_col;
	}

	function set_yaxis_font($in_font, $in_style, $in_size, $in_col)
	{
			$this->yaxisfont = $in_font;
			$this->yaxisfontstyle = $in_style;
			$this->yaxisfontsize = $in_size;
			$this->yaxisfontcolor = $in_col;
	}

	function set_xaxis($in_tic,$in_lab_tic,$in_col)
	{
			$this->xtickinterval = $in_tic;
			$this->xticklabelinterval = $in_lab_tic;
			$this->xaxiscolor = $in_col;
	}

	function set_yaxis($in_tic,$in_lab_tic,$in_col)
	{
			$this->ytickinterval = $in_tic;
			$this->yticklabelinterval = $in_lab_tic;
			$this->yaxiscolor = $in_col;

	}

	function set_margin_color($in_col)
	{
			$this->margincolor = $in_col;
	}

	function set_margins($in_lt, $in_rt, $in_tp, $in_bt)
	{
			$this->marginleft = $in_lt;
			$this->marginright = $in_rt;
			$this->margintop = $in_tp;
			$this->marginbottom = $in_bt;
	}


	function apply_defaults ()
	{
		$this->width_actual = check_for_default("GraphWidth", $this->width);
		$this->height_actual = check_for_default("GraphHeight", $this->height);
		$this->width_pdf_actual = check_for_default("GraphWidthPDF", $this->width_pdf);
		$this->height_pdf_actual = check_for_default("GraphHeightPDF", $this->height_pdf);
		$this->xaxiscolor_actual = check_for_default("XAxisColor", $this->xaxiscolor);
		$this->xticklabelinterval_actual = check_for_default("XTickLabelInterval", $this->xticklabelinterval);
		$this->xtickinterval_actual = check_for_default("XTickInterval", $this->xtickinterval);
		$this->yaxiscolor_actual = check_for_default("YAxisColor", $this->yaxiscolor);
		$this->yticklabelinterval_actual = check_for_default("YTickLabelInterval", $this->yticklabelinterval);
		$this->ytickinterval_actual = check_for_default("YTickInterval", $this->ytickinterval);
		$this->graphcolor_actual = check_for_default("GraphColor", $this->graphcolor);
		$this->marginbottom_actual = check_for_default("MarginBottom", $this->marginbottom);
		$this->margintop_actual = check_for_default("MarginTop", $this->margintop);
		$this->marginleft_actual = check_for_default("MarginLeft", $this->marginleft);
		$this->marginright_actual = check_for_default("MarginRight", $this->marginright);
		$this->margincolor_actual = check_for_default("MarginColor", $this->margincolor);
		$this->gridpos_actual = check_for_default("GridPosition", $this->gridpos);
		$this->xgriddisplay_actual = check_for_default("XGridDisplay", $this->xgriddisplay);
		$this->xgridcolor_actual = check_for_default("XGridColor", $this->xgridcolor);
		$this->ygriddisplay_actual = check_for_default("YGridDisplay", $this->ygriddisplay);
		$this->ygridcolor_actual = check_for_default("YGridColor", $this->ygridcolor);

		$this->titlefont_actual = check_for_default("TitleFont", $this->titlefont);
		$this->titlefontstyle_actual = check_for_default("TitleFontStyle", $this->titlefontstyle);
		$this->titlefontsize_actual = check_for_default("TitleFontSize", $this->titlefontsize);
		$this->titlecolor_actual = check_for_default("TitleColor", $this->titlecolor);
		$this->xtitlefont_actual = check_for_default("XTitleFont", $this->xtitlefont);
		$this->xtitlefontstyle_actual = check_for_default("XTitleFontStyle", $this->xtitlefontstyle);
		$this->xtitlefontsize_actual = check_for_default("XTitleFontSize", $this->xtitlefontsize);
		$this->xtitlecolor_actual = check_for_default("XTitleColor", $this->xtitlecolor);
		$this->ytitlefont_actual = check_for_default("YTitleFont", $this->ytitlefont);
		$this->ytitlefontstyle_actual = check_for_default("YTitleFontStyle", $this->ytitlefontstyle);
		$this->ytitlefontsize_actual = check_for_default("YTitleFontSize", $this->ytitlefontsize);
		$this->ytitlecolor_actual = check_for_default("YTitleColor", $this->ytitlecolor);
		$this->xaxisfont_actual = check_for_default("XAxisFont", $this->xaxisfont);
		$this->xaxisfontstyle_actual = check_for_default("XAxisFontStyle", $this->xaxisfontstyle);
		$this->xaxisfontsize_actual = check_for_default("XAxisFontSize", $this->xaxisfontsize);
		$this->xaxisfontcolor_actual = check_for_default("XAxisFontColor", $this->xaxisfontcolor);
		$this->xaxiscolor_actual = check_for_default("XAxisColor", $this->xaxiscolor);
		$this->yaxisfont_actual = check_for_default("YAxisFont", $this->yaxisfont);
		$this->yaxisfontstyle_actual = check_for_default("YAxisFontStyle", $this->yaxisfontstyle);
		$this->yaxisfontsize_actual = check_for_default("YAxisFontSize", $this->yaxisfontsize);
		$this->yaxisfontcolor_actual = check_for_default("YAxisFontColor", $this->yaxisfontcolor);
		$this->yaxiscolor_actual = check_for_default("YAxisColor", $this->yaxiscolor);

	}

	function apply_defaults_internal ()
	{
		$this->graphcolor = check_for_default("GraphColor", $this->graphcolor);
		$this->xaxiscolor = check_for_default("XAxisColor", $this->xaxiscolor);
		$this->xticklabelinterval = check_for_default("XTickLabelInterval", $this->xticklabelinterval);
		$this->xtickinterval = check_for_default("XTickInterval", $this->xtickinterval);
		$this->yaxiscolor = check_for_default("YAxisColor", $this->yaxiscolor);
		$this->yticklabelinterval = check_for_default("YTickLabelInterval", $this->yticklabelinterval);
		$this->ytickinterval = check_for_default("YTickInterval", $this->ytickinterval);
		$this->graphcolor = check_for_default("GraphColor", $this->graphcolor);
		$this->marginbottom = check_for_default("MarginBottom", $this->marginbottom);
		$this->margintop = check_for_default("MarginTop", $this->margintop);
		$this->marginleft = check_for_default("MarginLeft", $this->marginleft);
		$this->marginright = check_for_default("MarginRight", $this->marginright);
		$this->margincolor = check_for_default("MarginColor", $this->margincolor);
		$this->gridpos = check_for_default("GridPosition", $this->gridpos);
		$this->xgriddisplay = check_for_default("XGridDisplay", $this->xgriddisplay);
		$this->xgridcolor = check_for_default("XGridColor", $this->xgridcolor);
		$this->ygriddisplay = check_for_default("YGridDisplay", $this->ygriddisplay);
		$this->ygridcolor = check_for_default("YGridColor", $this->ygridcolor);

		$this->titlefont = check_for_default("TitleFont", $this->titlefont);
		$this->titlefontstyle = check_for_default("TitleFontStyle", $this->titlefontstyle);
		$this->titlefontsize = check_for_default("TitleFontSize", $this->titlefontsize);
		$this->titlecolor = check_for_default("TitleColor", $this->titlecolor);
		$this->xtitlefont = check_for_default("XTitleFont", $this->xtitlefont);
		$this->xtitlefontstyle = check_for_default("XTitleFontStyle", $this->xtitlefontstyle);
		$this->xtitlefontsize = check_for_default("XTitleFontSize", $this->xtitlefontsize);
		$this->xtitlecolor = check_for_default("XTitleColor", $this->xtitlecolor);
		$this->ytitlefont = check_for_default("YTitleFont", $this->ytitlefont);
		$this->ytitlefontstyle = check_for_default("YTitleFontStyle", $this->ytitlefontstyle);
		$this->ytitlefontsize = check_for_default("YTitleFontSize", $this->ytitlefontsize);
		$this->ytitlecolor = check_for_default("YTitleColor", $this->ytitlecolor);
		$this->xaxisfont = check_for_default("XAxisFont", $this->xaxisfont);
		$this->xaxisfontstyle = check_for_default("XAxisFontStyle", $this->xaxisfontstyle);
		$this->xaxisfontsize = check_for_default("XAxisFontSize", $this->xaxisfontsize);
		$this->xaxisfontcolor = check_for_default("XAxisFontColor", $this->xaxisfontcolor);
		$this->xaxiscolor = check_for_default("XAxisColor", $this->xaxiscolor);
		$this->yaxisfont = check_for_default("YAxisFont", $this->yaxisfont);
		$this->yaxisfontstyle = check_for_default("YAxisFontStyle", $this->yaxisfontstyle);
		$this->yaxisfontsize = check_for_default("YAxisFontSize", $this->yaxisfontsize);
		$this->yaxisfontcolor = check_for_default("YAxisFontColor", $this->yaxisfontcolor);
		$this->yaxiscolor = check_for_default("YAxisColor", $this->yaxiscolor);

	}

	function generate_graph_image ($outputfile)
	{
        return false;
    }
}


function minmaxValueOfSeries($data, &$min, &$max )
{
    $min = "undef";
    $max = "undef";

    foreach ( $data as $v )
    {
        if ( $min == "undef" || $v < $min )
            $min = $v;

        if ( $max == "undef" || $v > $max )
            $max = $v;
    }
}

function disableAllSeries($plot, &$graphData)
{
    foreach ( $plot as $k => $v )
    {
        $series = $v["name"].$k;
        $graphData->RemoveSerie($series);
    }
}

function setSerieDrawable($plot, $graphData, $inseries,$flag)
{
    foreach ( $plot as $k => $v )
    {
        $series = $v["name"].$k;
	    if ( $inseries == $series )
        {
            if ( $flag )
            {
	            $graphData->AddSerie($series);
	            $graphData->SetSerieName($v["legend"], $series);
            }
            else
	            $graphData->RemoveSerie($series);
        }
    }
}


?>