Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */

class JsChart extends SugarChart
{
    public $id;
    protected $ss;
    public $xmlFile;
    public $jsonFilename;
    public $chartId;
    public $width;
    public $height;
    public $chartType;

public function __construct()
    {
        parent::__construct();
    }

public function isSupported($chartType)
    {
        $charts = [
            'stacked group by chart',
            'group by chart',
            'bar chart',
            'horizontal group by chart',
            'horizontal',
            'horizontal bar chart',
            'pie chart',
            'gauge chart',
            'funnel chart 3D',
            'line chart',
            'horizontal grouped bar chart',
            'vertical grouped bar chart',
            'donut chart',
            'treemap chart',
        ];

if (in_array($chartType, $charts)) {
            return true;
        } else {
            return false;
        }
    }

public function tab($str, $depth)
    {
        // $str = preg_replace('/(<\w+>)(.*)(<\/\w+>)/e', "'\\1'.htmlentities(from_html('\\2')).'\\3'", $str);
        return str_repeat("\t", $depth) . $str . "\n";
    }

public function display($name, $xmlFile, $width = '320', $height = '480', $resize = false)
    {

$this->chartId = $name;
        $this->height = $height;
        $this->width = $width;
        $this->xmlFile = $xmlFile;
        $this->chartType = $this->chart_properties['type'];

$style = [];
        $chartConfig = [];
        try {
            $xmlStr = $this->processXML($this->xmlFile);
            $json = $this->buildJson($xmlStr, true);
        } catch (Exception $e) {
            $GLOBALS['log']->fatal("Unable to return chart data, invalid xml for file {$this->xmlFile}");
            return '';
        }
        $this->saveJsonFile($json);
        $this->ss->assign('chartId', $this->chartId);
        $this->ss->assign('filename', $this->jsonFilename);
        global $mod_strings, $app_strings;
        if (isset($mod_strings['LBL_REPORT_SHOW_CHART'])) {
            $this->ss->assign('showchart', $mod_strings['LBL_REPORT_SHOW_CHART']);
        }

$dimensions = $this->getChartDimensions($xmlStr);
        $this->ss->assign('width', $dimensions['width']);
        $this->ss->assign('height', $dimensions['height']);
        $xmlStyles = $this->getConfigProperties();
        $style['gridLineColor'] = str_replace('0x', '#', $xmlStyles->gridLines);
        $style['font-family'] = $xmlStyles->labelFontFamily;
        $style['color'] = str_replace('0x', '#', $xmlStyles->labelFontColor);
        $this->ss->assign('css', $style);
        foreach ($this->getChartConfigParams($xmlStr) as $key => $value) {
            $chartConfig[$key] = $value;
        }
        $chartConfig['imageExportType'] = $this->image_export_type;
        $this->ss->assign('config', $chartConfig);
        $this->ss->assign('params', $this->chart_properties);
        if ($json == 'No Data') {
            $this->ss->assign('error', $app_strings['LBL_NO_DATA']);
        }

if (!$this->isSupported($this->chartType)) {
            $this->ss->assign('error', 'Unsupported Chart Type');
        }
    }

public function getDashletScript($id, $xmlFile = '')
    {

global $sugar_config, $current_user, $current_language;
        $this->id = $id;
        $this->chartId = $id;
        $this->xmlFile = (!$xmlFile) ? sugar_cached('xml/' . $current_user->getUserPrivGuid() . "_{$this->id}.xml") : $xmlFile;

$style = [];
        $chartConfig = [];
        $this->ss->assign('chartId', $this->chartId);
        $this->ss->assign('filename', str_replace('.xml', '.js', $this->xmlFile));
        $config = $this->getConfigProperties();
        $style['gridLineColor'] = str_replace('0x', '#', $config->gridLines);
        $style['font-family'] = $config->labelFontFamily;
        $style['color'] = str_replace('0x', '#', $config->labelFontColor);
        $this->ss->assign('css', $style);
        $xmlStr = $this->processXML($this->xmlFile);
        foreach ($this->getChartConfigParams($xmlStr) as $key => $value) {
            $chartConfig[$key] = $value;
        }

$chartConfig['imageExportType'] = $this->image_export_type;
        $this->ss->assign('config', $chartConfig);
    }

public function chartArray($chartsArray)
    {

$customChartsArray = [];
        $style = [];
        $chartConfig = [];
        foreach ($chartsArray as $id => $data) {
            $customChartsArray[$id] = [];
            $customChartsArray[$id]['chartId'] = $id;
            $customChartsArray[$id]['filename'] = str_replace('.xml', '.js', $data['xmlFile']);
            $customChartsArray[$id]['width'] = $data['width'];
            $customChartsArray[$id]['height'] = $data['height'];

$config = $this->getConfigProperties();
            $style['gridLineColor'] = str_replace('0x', '#', $config->gridLines);
            $style['font-family'] = (string)$config->labelFontFamily;
            $style['color'] = str_replace('0x', '#', $config->labelFontColor);
            $customChartsArray[$id]['css'] = $style;
            $xmlStr = $this->processXML($data['xmlFile']);
            $xml = new SimpleXMLElement($xmlStr);
            $params = $this->getChartConfigParams($xmlStr);
            $customChartsArray[$id]['supported'] = ($this->isSupported($xml->properties->type)) ? 'true' : 'false';
            foreach ($params as $key => $value) {
                $chartConfig[$key] = $value;
            }
            $chartConfig['imageExportType'] = $this->image_export_type;
            $customChartsArray[$id]['chartConfig'] = $chartConfig;
        }

return $customChartsArray;
    }

public function getChartConfigParams($xmlStr)
    {

$xml = new SimpleXMLElement($xmlStr);

$chartType = $xml->properties->type;
        if ($chartType == 'pie chart') {
            return ['pieType' => 'basic', 'tip' => 'name', 'chartType' => 'pieChart'];
        } elseif ($chartType == 'donut chart') {
            return [
                'pieType' => 'basic',
                'tip' => 'name',
                'chartType' => 'donutChart',
            ];
        } elseif ($chartType == 'treemap chart') {
            return [
                'treemapType' => 'basic',
                'tip' => 'name',
                'chartType' => 'treemapChart',
            ];
        } elseif ($chartType == 'line chart') {
            return ['lineType' => 'grouped', 'tip' => 'name', 'chartType' => 'lineChart'];
        } elseif ($chartType == 'funnel chart 3D') {
            return [
                'funnelType' => 'basic',
                'tip' => 'name',
                'chartType' => 'funnelChart',
                'maintainAspectRatio' => true,
                'aspectRatio' => 1,
            ];
        } elseif ($chartType == 'gauge chart') {
            return ['gaugeType' => 'basic', 'tip' => 'name', 'chartType' => 'gaugeChart'];
        } elseif ($chartType == 'stacked group by chart') {
            return ['orientation' => 'vertical', 'barType' => 'stacked', 'tip' => 'name', 'chartType' => 'barChart'];
        } elseif ($chartType == 'vertical grouped bar chart') {
            return ['orientation' => 'vertical', 'barType' => 'grouped', 'tip' => 'name', 'chartType' => 'barChart'];
        } elseif ($chartType == 'group by chart') {
            return ['orientation' => 'vertical', 'barType' => 'grouped', 'tip' => 'title', 'chartType' => 'barChart'];
        } elseif ($chartType == 'bar chart') {
            return ['orientation' => 'vertical', 'barType' => 'basic', 'tip' => 'label', 'chartType' => 'barChart'];
        } elseif ($chartType == 'horizontal group by chart') {
            return ['orientation' => 'horizontal', 'barType' => 'stacked', 'tip' => 'name', 'chartType' => 'barChart'];
        } elseif ($chartType == 'horizontal grouped bar chart') {
            return ['orientation' => 'horizontal', 'barType' => 'grouped', 'tip' => 'name', 'chartType' => 'barChart'];
        } elseif (in_array($chartType, ['horizontal bar chart', 'horizontal'])) {
            return ['orientation' => 'horizontal', 'barType' => 'basic', 'tip' => 'label', 'chartType' => 'barChart'];
        } else {
            return ['orientation' => 'vertical', 'barType' => 'stacked', 'tip' => 'name', 'chartType' => 'barChart'];
        }
    }

public function getChartDimensions($xmlStr)
    {
        if ($this->getNumNodes($xmlStr) > 9 &&
            !in_array($this->chartType, ['pie chart', 'donut chart', 'treemap chart'])
        ) {
            if ($this->chartType == 'horizontal group by chart' || $this->chartType == 'horizontal bar chart' ||
                $this->chartType == 'horizontal grouped bar chart') {
                $height = ($this->getNumNodes($xmlStr) * 40);
                return ['width' => $this->width, 'height' => ($height)];
            } else {
                return ['width' => $this->width, 'height' => $this->height];
            }
        } else {
            return ['width' => '100%', 'height' => $this->height];
        }
    }

public function checkData($xmlstr)
    {
        $xml = new SimpleXMLElement($xmlstr);
        if (sizeof($xml->data->group) > 0) {
            return true;
        } else {
            return false;
        }
    }

public function getNumNodes($xmlstr)
    {
        $xml = new SimpleXMLElement($xmlstr);
        return sizeof($xml->data->group);
    }

public function buildProperties($xmlstr)
    {
        $content = $this->tab("\"properties\": [\n", 1);
        $properties = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->properties->children() as $property) {
            $properties[] = $this->tab('"' . $property->getName() . '":' . '"' . $this->processSpecialChars($property) . '"', 2);
        }
        $content .= $this->tab("{\n", 1);
        $content .= join(",\n", $properties) . "\n";
        $content .= $this->tab("}\n", 1);
        $content .= $this->tab("],\n", 1);
        return $content;
    }

public function buildLabelsBarChartStacked($xmlstr)
    {
        $content = $this->tab("\"label\": [\n", 1);
        $labels = [];
        $xml = new SimpleXMLElement($xmlstr);
        if (isset($xml->data->group)) {
            foreach ($xml->data->group[0]->subgroups->group as $group) {
                $labels[] = $this->tab('"' . $this->processSpecialChars($group->title) . '"', 2);
            }

$content .= join(",\n", $labels) . "\n";
        }
        $content .= $this->tab("],\n", 1);
        return $content;
    }

public function buildLabelsBarChart($xmlstr)
    {

$xml = new SimpleXMLElement($xmlstr);

$content = $this->tab("\"label\": [\n", 1);
        $labels = [];

foreach ($xml->data->group as $group) {
            $labels[] = $this->tab('"' . $this->processSpecialChars($group->title) . '"', 2);
        }
        $labelStr = join(",\n", $labels) . "\n";
        $content .= $labelStr;
        $content .= $this->tab("],\n", 1);
        return $content;
    }

public function buildDataBarChartStacked($xmlstr)
    {
        $content = $this->tab("\"values\": [\n", 1);
        $data = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->data->group as $group) {
            $groupcontent = $this->tab("{\n", 1);
            $groupcontent .= $this->tab('"label": "' . $this->processSpecialChars($group->title) . "\",\n", 2);
            $groupcontent .= $this->tab("\"gvalue\": \"{$group->value}\",\n", 2);
            $groupcontent .= $this->tab("\"gvaluelabel\": \"{$group->label}\",\n", 2);
            $subgroupValues = [];
            $subgroupValueLabels = [];
            $subgroupLinks = [];
            foreach ($group->subgroups->group as $subgroups) {
                $subgroupValues[] = $this->tab(($subgroups->value == 'NULL') ? 0 : $subgroups->value, 3);
                $subgroupValueLabels[] = $this->tab('"' . $this->processSpecialChars($subgroups->label) . '"', 3);
                $subgroupLinks[] = $this->tab('"' . $subgroups->link . '"', 3);
            }
            $subgroupValuesStr = join(",\n", $subgroupValues) . "\n";
            $subgroupValueLabelsStr = join(",\n", $subgroupValueLabels) . "\n";
            $subgroupLinksStr = join(",\n", $subgroupLinks) . "\n";

$groupcontent .= $this->tab("\"values\": [\n" . $subgroupValuesStr, 2);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"valuelabels\": [\n" . $subgroupValueLabelsStr, 2);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"links\": [\n" . $subgroupLinksStr, 2);
            $groupcontent .= $this->tab("]\n", 2);
            $groupcontent .= $this->tab('}', 1);
            $data[] = $groupcontent;
        }
        $content .= join(",\n", $data) . "\n";
        $content .= $this->tab(']', 1);
        return $content;
    }

public function buildDataBarChartGrouped($xmlstr)
    {
        $content = $this->tab("\"values\": [\n", 1);
        $data = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->data->group as $group) {
            $groupcontent = $this->tab("{\n", 1);
            $groupcontent .= $this->tab('"label": "' . $this->processSpecialChars($group->title) . "\",\n", 2);
            $groupcontent .= $this->tab("\"gvalue\": \"{$group->value}\",\n", 2);
            $groupcontent .= $this->tab("\"gvaluelabel\": \"{$group->label}\",\n", 2);
            $subgroupValues = [];
            $subgroupValueLabels = [];
            $subgroupLinks = [];
            $subgroupTitles = [];
            foreach ($group->subgroups->group as $subgroups) {
                $subgroupValues[] = $this->tab(($subgroups->value == 'NULL') ? 0 : $subgroups->value, 3);
                $subgroupValueLabels[] = $this->tab('"' . $subgroups->label . '"', 3);
                $subgroupLinks[] = $this->tab('"' . $subgroups->link . '"', 3);
                $subgroupTitles[] = $this->tab('"' . $this->processSpecialChars($subgroups->title) . '"', 3);
            }
            $subgroupValuesStr = join(",\n", $subgroupValues) . "\n";
            $subgroupValueLabelsStr = join(",\n", $subgroupValueLabels) . "\n";
            $subgroupLinksStr = join(",\n", $subgroupLinks) . "\n";
            $subgroupTitlesStr = join(",\n", $subgroupTitles) . "\n";

$groupcontent .= $this->tab("\"values\": [\n" . $subgroupValuesStr, 2);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"valuelabels\": [\n" . $subgroupValueLabelsStr, 2);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"links\": [\n" . $subgroupLinksStr, 2);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"titles\": [\n" . $subgroupTitlesStr, 2);
            $groupcontent .= $this->tab("]\n", 2);
            $groupcontent .= $this->tab('}', 1);
            $data[] = $groupcontent;
        }
        $content .= join(",\n", $data) . "\n";
        $content .= $this->tab(']', 1);
        return $content;
    }

public function buildDataBarChart($xmlstr)
    {
        $content = $this->tab("\"values\": [\n", 1);
        $data = [];
        $xml = new SimpleXMLElement($xmlstr);
        $groupcontent = '';
        $groupcontentArr = [];

foreach ($xml->data->group as $group) {
            $groupcontent = $this->tab("{\n", 1);
            $groupcontent .= $this->tab("\"label\": [\n", 2);
            $groupcontent .= $this->tab('"' . $this->processSpecialChars($group->title) . "\"\n", 3);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"values\": [\n", 2);
            $groupcontent .= $this->tab(($group->value == 'NULL') ? 0 : $group->value . "\n", 3);
            $groupcontent .= $this->tab("],\n", 2);
            if ($group->label) {
                $groupcontent .= $this->tab("\"valuelabels\": [\n", 2);
                $groupcontent .= $this->tab("\"{$group->label}\"\n", 3);
                $groupcontent .= $this->tab("],\n", 2);
            }
            $groupcontent .= $this->tab("\"links\": [\n", 2);
            $groupcontent .= $this->tab("\"{$group->link}\"\n", 3);
            $groupcontent .= $this->tab("]\n", 2);
            $groupcontent .= $this->tab('}', 1);
            $groupcontentArr[] = $groupcontent;
        }
        $content .= join(",\n", $groupcontentArr) . "\n";
        $content .= $this->tab(']', 1);
        return $content;
    }

public function buildLabelsPieChart($xmlstr)
    {
        $content = $this->tab("\"label\": [\n", 1);
        $labels = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->data->group as $group) {
            $labels[] = $this->tab('"' . $this->processSpecialChars($group->title) . '"', 2);
        }
        $labelStr = join(",\n", $labels) . "\n";
        $content .= $labelStr;
        $content .= $this->tab("],\n", 1);
        return $content;
    }

public function buildDataPieChart($xmlstr)
    {
        $content = $this->tab("\"values\": [\n", 1);
        $data = [];
        $xml = new SimpleXMLElement($xmlstr);
        $groupcontent = '';
        $groupcontentArr = [];

foreach ($xml->data->group as $group) {
            $groupcontent = $this->tab("{\n", 1);
            $groupcontent .= $this->tab("\"label\": [\n", 2);
            $groupcontent .= $this->tab('"' . $this->processSpecialChars($group->title) . "\"\n", 3);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"values\": [\n", 2);
            $groupcontent .= $this->tab("{$group->value}\n", 3);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"valuelabels\": [\n", 2);
            $groupcontent .= $this->tab("\"{$group->label}\"\n", 3);
            $groupcontent .= $this->tab("],\n", 2);
            $groupcontent .= $this->tab("\"links\": [\n", 2);
            $groupcontent .= $this->tab("\"{$group->link}\"\n", 3);
            $groupcontent .= $this->tab("]\n", 2);
            $groupcontent .= $this->tab('}', 1);
            $groupcontentArr[] = $groupcontent;
        }

$content .= join(",\n", $groupcontentArr) . "\n";
        $content .= $this->tab("\n]", 1);
        return $content;
    }

public function buildLabelsGaugeChart($xmlstr)
    {
        $content = $this->tab("\"label\": [\n", 1);
        $labels = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->data->group as $group) {
            $labels[] = $this->tab('"' . $this->processSpecialChars($group->title) . '"', 2);
        }
        $labelStr = join(",\n", $labels) . "\n";
        $content .= $labelStr;
        $content .= $this->tab("],\n", 1);
        return $content;
    }

public function buildDataGaugeChart($xmlstr)
    {
        $content = $this->tab("\"values\": [\n", 1);
        $data = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->data->group as $group) {
            $groupcontent = $this->tab("{\n", 1);
            $groupcontent .= $this->tab('"label": "' . $this->processSpecialChars($group->title) . "\",\n", 2);
            $groupcontent .= $this->tab("\"gvalue\": \"{$group->value}\",\n", 2);
            $finalComma = ($group->title != 'GaugePosition') ? ',' : '';
            $groupcontent .= $this->tab("\"gvaluelabel\": \"{$group->label}\"{$finalComma}\n", 2);
            $subgroupTitles = [];
            $subgroupValues = [];
            $subgroupValueLabels = [];
            $subgroupLinks = [];

if (is_object($group->subgroups->group)) {
                foreach ($group->subgroups->group as $subgroups) {
                    $subgroupTitles[] = $this->tab('"' . $subgroups->title . '"', 3);
                    //$subgroupValues[] = $this->tab($subgroups->value,3);
                    $subgroupValues[] = $subgroups->value;
                    $subgroupValueLabels[] = $this->tab('"' . $subgroups->label . '"', 3);
                    $subgroupLinks[] = $this->tab('"' . $subgroups->link . '"', 3);
                }
                $subgroupTitlesStr = join(",\n", $subgroupTitles) . "\n";
                $subgroupValuesStr = join(",\n", $subgroupValues) . "\n";
                $subgroupValueLabelsStr = join(",\n", $subgroupValueLabels) . "\n";
                $subgroupLinksStr = join(",\n", $subgroupLinks) . "\n";

//$groupcontent .= $this->tab("\"labels\": [\n".$subgroupTitlesStr,2);
                //$groupcontent .= $this->tab("],\n",2);
                $val = ((int)$subgroupValues[1] == (int)$subgroupValues[0]) ? $this->tab($subgroupValues[1], 3) . "\n" : $this->tab($subgroupValues[1] - $subgroupValues[0], 3) . "\n";

$groupcontent .= $this->tab("\"values\": [\n" . $val, 2);
                $groupcontent .= $this->tab("],\n", 2);
                $groupcontent .= $this->tab("\"valuelabels\": [\n" . $subgroupValueLabelsStr, 2);
                $groupcontent .= $this->tab("]\n", 2);
                //$groupcontent .= $this->tab("\"links\": [\n".$subgroupLinksStr,2);
                //$groupcontent .= $this->tab("]\n",2);
            }

$groupcontent .= $this->tab('}', 1);
            $data[] = $groupcontent;
        }

$content .= join(",\n", $data) . "\n";

$content .= $this->tab(']', 1);
        return $content;
    }

public function getConfigProperties()
    {
        $path = SugarThemeRegistry::current()->getImageURL('sugarColors.xml', false);

if (!file_exists($path)) {
            $GLOBALS['log']->debug("Cannot open file ($path)");
        }
        $xmlstr = file_get_contents($path);
        $xml = new SimpleXMLElement($xmlstr);
        return $xml->charts;
    }

public function buildChartColors()
    {

$content = $this->tab("\"color\": [\n", 1);
        $colorArr = [];
        $xml = $this->getConfigProperties();
        $colors = ($this->chartType == 'gauge chart') ? $xml->gaugeChartElementColors->color : $xml->chartElementColors->color;
        foreach ($colors as $color) {
            $colorArr[] = $this->tab('"' . str_replace('0x', '#', $color) . '"', 2);
        }
        $content .= join(",\n", $colorArr) . "\n";
        $content .= $this->tab("],\n", 1);

return $content;
    }

public function buildJson($xmlstr, $ignore_datacheck = false)
    {
        // make sure chartType is set if we buildJson() instead of going thru display()
        if (!isset($this->chartType)) {
            $this->chartType = $this->chart_properties['type'];
        }

if ($this->checkData($xmlstr) || $ignore_datacheck === true) {
            $content = "{\n";
            if (in_array($this->chartType, ['pie chart', 'funnel chart 3D', 'donut chart', 'treemap chart'])) {
                $content .= $this->buildProperties($xmlstr);
                $content .= $this->buildLabelsPieChart($xmlstr);
                $content .= $this->buildChartColors();
                $content .= $this->buildDataPieChart($xmlstr);
            } elseif ($this->chartType == 'gauge chart') {
                $content .= $this->buildProperties($xmlstr);
                $content .= $this->buildLabelsGaugeChart($xmlstr);
                $content .= $this->buildChartColors();
                $content .= $this->buildDataGaugeChart($xmlstr);
            } elseif ($this->chartType == 'horizontal bar chart' || $this->chartType == 'bar chart') {
                $content .= $this->buildProperties($xmlstr);
                $content .= $this->buildLabelsBarChart($xmlstr);
                $content .= $this->buildChartColors();
                $content .= $this->buildDataBarChart($xmlstr);
            } elseif ($this->chartType == 'group by chart') {
                $content .= $this->buildProperties($xmlstr);
                $content .= $this->buildLabelsBarChartStacked($xmlstr);
                $content .= $this->buildChartColors();
                $content .= $this->buildDataBarChartGrouped($xmlstr);
            } else {
                $content .= $this->buildProperties($xmlstr);
                $content .= $this->buildLabelsBarChartStacked($xmlstr);
                $content .= $this->buildChartColors();
                $content .= $this->buildDataBarChartStacked($xmlstr);
            }
            $content .= "\n}";

// fix-up the json since it's not valid json for JS or PHP
            $content = str_replace(["\t", "\n", "\'"], ['', '', "'"], $content);

return $content;
        } else {
            return 'No Data';
        }
    }

public function buildHTMLLegend($xmlFile)
    {
        $xmlstr = $this->processXML($xmlFile);

if (empty($xmlstr)) {
            return '';
        }

$xml = new SimpleXMLElement($xmlstr);
        $this->chartType = $xml->properties->type;
        $html = '<table align="left" cellpadding="2" cellspacing="2">';

if ($this->chartType == 'group by chart'
            || $this->chartType == 'horizontal group by chart'
            || $this->chartType == 'line chart'
            || $this->chartType == 'stacked group by chart'
            || $this->chartType == 'horizontal grouped bar chart'
            || $this->chartType == 'vertical grouped bar chart'
        ) {
            $groups = $xml->data->group[0]->subgroups->group;
            $items = (sizeof($xml->data->group[0]->subgroups->group) <= 5) ? 5 : sizeof($xml->data->group[0]->subgroups->group);
        } else {
            if ($this->chartType == 'funnel chart 3D') {
                // reverse legend
                $groups = [];
                foreach ($xml->data->group as $group) {
                    array_unshift($groups, $group);
                }
            } else {
                $groups = $xml->data->group;
            }
            $items = (sizeof($xml->data->group) <= 5) ? 5 : sizeof($xml->data->group);
        }

$rows = ceil($items / 5);
        $fullItems = $rows * 5;
        $remainder = ($items < $fullItems) ? $fullItems - $items : 0;
        $i = 0;
        $x = 0;

$colorArr = [];
        $xmlColors = $this->getConfigProperties();
        $colors = ($this->chartType == 'gauge chart') ? $xmlColors->gaugeChartElementColors->color : $xmlColors->chartElementColors->color;

foreach ($colors as $color) {
            $colorArr[] = str_replace('0x', '#', $color);
        }

$isTrClosed = false;
        foreach ($groups as $group) {
            if ($i == 5) {
                $i = 0;
            }
            $html .= ($i == 0) ? '<tr>' : '';
            $html .= '<td width="50">';
            $html .= '<div style="background-color:' . $colorArr[$x] . ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>';
            $html .= '</td>';
            $html .= '<td>';
            $html .= $group->title;
            $html .= '</td>';
            $html .= ($x + 1 == $items) ? '<td colspan=' . ($remainder * 2) . '></td>' : '';
            if ($i == 4) {
                $html .= '</tr>';
                $isTrClosed = true;
            } else {
                $isTrClosed = false;
            }
            $x++;
            $i++;
        }
        if ($isTrClosed == false) {
            $html .= '</tr>';
        }

$html .= '</table>';
        return $html;
    }

public function saveJsonFile($jsonContents)
    {
        $this->jsonFilename = str_replace('.xml', '.js', $this->xmlFile);
        //$jsonContents = $GLOBALS['locale']->translateCharset($jsonContents, 'UTF-8', 'UTF-16LE');

// open file
        if (!$fh = sugar_fopen($this->jsonFilename, 'w')) {
            $GLOBALS['log']->debug("Cannot open file ($this->jsonFilename)");
            return;
        }

// write the contents to the file
        if (fwrite($fh, $jsonContents) === false) {
            $GLOBALS['log']->debug("Cannot write to file ($this->jsonFilename)");
            return false;
        }

$GLOBALS['log']->debug("Success, wrote ($jsonContents) to file ($this->jsonFilename)");

fclose($fh);
        return true;
    }

public function get_image_cache_file_name($xmlFile, $ext = '.png')
    {
        $filename = str_replace('/xml/', '/images/', str_replace('.xml', $ext, $xmlFile));

return $filename;
    }

public function getXMLChartProperties($xmlStr)
    {
        $xmlstr = null;
        $props = [];
        $xml = new SimpleXMLElement($xmlstr);
        foreach ($xml->properties->children() as $properties) {
            $props[$properties->getName()] = $properties;
        }
        return $props;
    }

public function processSpecialChars($str)
    {
        return addslashes(html_entity_decode($str, ENT_QUOTES));
    }

public function processXML($xmlFile)
    {

if (!file_exists($xmlFile)) {
            $GLOBALS['log']->debug("Cannot open file ($xmlFile)");
            return '';
        }

$pattern = [];
        $content = file_get_contents($xmlFile);
        $content = $GLOBALS['locale']->translateCharset($content, 'UTF-16LE', 'UTF-8');
        $pattern[] = '/\<link\>([a-zA-Z0-9#?&%.;\[\]\/=+_\-\s]+)\<\/link\>/';

return preg_replace_callback($pattern, function ($m) {
            return '<link>' . urlencode($m[1]) . '</link>';
        }, $content);
    }
}