Creating a Map

It is now possible to create a map using the following code:

<?php
   $chart = array(
      '#chart_id' => 'test_chart',
      '#type' => CHART_TYPE_MAP,         //Map Type
      '#countries' => array(MG,KE,TN),   //Array of ISO country codes (2 letter codes)
      '#georange' => africa,                    //Geographic Range of the Map - continent name or 'world'
      '#data' => array(10,50,100),        //Value affects intensity of colours which will be in the range defined by #data_colours second and third elements
      '#data_colors' => array('ffffff', 'edf0d4', '13390a') //3 values for the colour (all other countries, start colour and end colour)
    );
echo chart_render($chart);
?>

This results in:

Here's a scatter plot of Drupal Userpoints (anonymous) by member!

Here's the code!

http://snippets.dzone.com/posts/show/5985

This examples don't work in drupal. Do I need to install a module, where can I download the module from?

You need Drupal module from this project: http://drupal.org/project/chart

$chart = array(

'#chart_id' => 'test_chart', '#title' => t('Servings'), '#type' => CHART_TYPE_PIE_3D,

);

$chart['#data']['fruits'] = 3; $chart['#data']['meats'] = 2; $chart['#data']['dairy'] = 5;

echo chart_render($chart);

hha "This examples don't work in drupal. Do I need to install a module, where can I download the module from?"

this is why I left Drupal, to many people have no clue what they are doing... PHP makes me barf :P

The simplest way to use it : 1. Activate into administer -> site building -> Modules -> PHP filter module 2. Create block in administer -> site building -> Blocks -> Add block 3. Change input format for the block into "PHP code" 4. Insert example php code into your block between <?php "example code goes here" ?> 5. Place your block in any egion of your page. 6. Look and feel happy :)

you can download module from www.drupal.org

Question. Can I use database queries as input?

great!

Keep in mind that the module itself will be calling out to Google's API. This API is served on an HTTP site and will cause error dialogs within IE if being called from an HTTPS site. These errors get old very quick and changing the settings within IE to ignore that error is not a preferred method.

Great! I'll try the module for sure... Is there any workaround for using https without IE warnings? I'm just curious. Maybe modifying the code and loading these libraries from my local server?

Thanks for the module :)

Thanks for the module, works great. There's a bit to get ones head around but the functionality is there :)

Here's an example of how to graph statistics about your Drupal website:

<?php

function gen_cumulative_table($table = 'node', $id = 'nid', $qfragment = '', $points = 0, $timestamp = 0) {
  $data = array();
  $nbars = 15;
  
  $key = in_array($table, array('node', 'users')) ? 'created' : 'timestamp';
  $timestamp = $timestamp ? $timestamp : db_result(db_query('SELECT MIN(%s) FROM {%s} WHERE %s != 0', $key, $table, $id));
  if ($timestamp) {
    // one point per week (at least 15 points)
    if (!$points) {
      $points = max((time() - $timestamp) / (60*60*24*7), 15);
      while ($points > $nbars) {
        $points /= 2;
      }
    }
    $interval = round((time() - $timestamp) / ($points - 1), 0);
    $time = $timestamp;
    for ($i = 0; $i < $points; $i++) {
	  $data['date'][$i] = format_date($time, 'custom', 'm/d') ;	
      $data['count'][$i] = db_result(db_query('SELECT COUNT(DISTINCT(%s)) FROM {%s} WHERE %s <= %d AND %s != 0 %s', $id, $table, $key, $time, $id, $qfragment));
      $time += $interval;
    }
  }

  return $data;
}

$chart1data = array(  'data' => gen_cumulative_table());
$chart1max = max($chart1data[data][count]);
$chart1 = array(
  '#chart_id' => 'chart_h_nodes',
  '#title' => t($chart1max .' Recipies, menus, and other posts'),
  '#type' =>  CHART_TYPE_BAR_V_GROUPED,
  '#size' => chart_size(500, 200),
  '#chart_fill' => chart_fill('bg', 'f4f7e700'),   
  '#adjust_resolution' => TRUE,
);
$chart1['#data_colors'][] = '94CE18';    
$chart1['#data']['Actual'] = $chart1data[data][count];
$chart1['#mixed_axis_labels'][CHART_AXIS_Y_LEFT][0][] = chart_mixed_axis_range_label(0, $chart1max);
$chart1['#mixed_axis_labels'][CHART_AXIS_X_BOTTOM][0][] =  chart_mixed_axis_label($chart1data[data][date]);
print chart_render($chart1);


$chart2data = array(  'data' => gen_cumulative_table('users', 'uid'));
$chart2max = max($chart2data[data][count]);
$chart2 = array(
  '#chart_id' => 'chart_h_users',
  '#title' => t($chart2max.' Users'),
  '#type' =>  CHART_TYPE_BAR_V_GROUPED,
  '#size' => chart_size(500, 200),
  '#chart_fill' => chart_fill('bg', 'f4f7e700'),   
  '#adjust_resolution' => TRUE,
);
$chart2['#data_colors'][] = '94CE18';    
$chart2['#data']['Actual'] = $chart2data[data][count];
$chart2['#mixed_axis_labels'][CHART_AXIS_Y_LEFT][0][] = chart_mixed_axis_range_label(0, $chart2max);
$chart2['#mixed_axis_labels'][CHART_AXIS_X_BOTTOM][0][] =  chart_mixed_axis_label($chart2data[data][date]);
print chart_render($chart2);


$chart3data = array(  'data' => gen_cumulative_table('comments', 'cid'));
$chart3max = max($chart3data[data][count]);
$chart3 = array(
  '#chart_id' => 'chart_h_comments',
  '#title' => t($chart3max .' Comments'),
  '#type' =>  CHART_TYPE_BAR_V_GROUPED,
  '#size' => chart_size(500, 200),
  '#chart_fill' => chart_fill('bg', 'f4f7e700'),   
  '#adjust_resolution' => TRUE,
);
$chart3['#data_colors'][] = '94CE18';    
$chart3['#data']['Actual'] = $chart3data[data][count];
$chart3['#mixed_axis_labels'][CHART_AXIS_Y_LEFT][0][] = chart_mixed_axis_range_label(0, $chart3max);
$chart3['#mixed_axis_labels'][CHART_AXIS_X_BOTTOM][0][] =  chart_mixed_axis_label($chart3data[data][date]);
print chart_render($chart3);

?>

cool

This module is fantastic, and I've been busy creating several graphs. Only one issue - the graphs are generated as PNGs (no problem with that) without any alt text (which I have a slight problem with). Is there any way of setting the alternative text? I have a function which generates the graphs, so I'd love to be able to pass in the value of the alt text...

How can I populate chart's labels? I'm using a mysql resultset and could fill in the data part.

$chart = array(
		'#chart_id' => 'Grafico_Prueba',
		'#title' => t('Categorías'),
		'#type' => CHART_TYPE_PIE_3D,
		);
		
while ($row=mssql_fetch_array($result)) {
		$c1=utf8_encode($row['Categoria']);
		$c2=$row['Total'];
		
		$chart['#data'][t("'" & $c1 & "'")] = $c2;
		$chart['#labels'][] = '"' & $c1 & '"'; 
		
	}

echo chart_render($chart);

Using this line for labels:

$chart['#labels'][] = '"' & $c1 & '"';

rendered chart has no labels at all.

Using this other, (") swap by (')

$chart['#labels'][] = "'" & $c1 & "'";

rendered chart has only one label with "0".

If I try this other one:

$chart['#labels'][] = t("'" & $c1 & "'");

same rendered chart with only one "0" label.

On every case, the rendered chart has the right portions with each size according to data. At the moment I couldn't display labels nor legends. I tried both with same results.

Any help would be appreciated. As you already should know, I'm just starting with PHP. Thanks for your time.

How can i generate a chart, that compare 2 differents data range?

Hi

I think i found a little bug in the module.

I was trying to create a SCATTER type chart, and i wasn't able to change the color the 'legends' adding this:

$chart['#data_colors'][]=chart_unique_color($nodes[$i]->nid);

Then i realized that this added $chco=color1,color2,color3 to the url instead of $chco=color1|color2|color3, and without the '|' caracter the color doesn't change. So I entered the '|' character by myself and it worked. (something like this:

for($i=0;$i<$nodeCount;$i++){
    	$color .= chart_unique_color($nodes[$i]->nid);
    	if($i!=$nodeCount-1) $color .= '|';
	$chart['#legends'][]=t($nodes[$i]->title);
}
$chart['#data_colors'][] = $color;

I hope someone finds this useful. Thank you for your work!

"Is there any workaround for using https without IE warnings?"

Yes, the same workaround as is requird for any HTTPS website referencing an external image - reference the image via HTTPS instead of HTTP.

Sorry, where should I put this peace of code?

Thank you

code is awesome http://drupal.org/sandbox/er_gaurav_sharma/1192808

For Drupal 7 you should not use the last function: echo chart_render($chart); It returns a error.

But following: echo theme('chart', array('chart' => $chart));

For Drupal 7 you can use return theme('chart', array('chart' => $chart));

Are there any plans to make the map chart show individual towns using geolocation for example?

Is it possible to get plots with unequally spaced data inserting something like cht=lxy chd=t:10,20,40,80,90,95,99|20,30,40,50,60,70,80|

-1|5,10,22,35,85

Drupal - The cowards never started -- and the weak died along the way.