city_graph.php

<?php
/**
 * @package city_graph.php
 * @author John Doe <john.doe@example.com>
 * @since version
 * @version 2013-10-05
 */
/*
10/5/2013 complete rewrite; simplification based on using SQL COUNT/GROUP-BY
*/

require_once './incs/functions.inc.php';		//7/28/10
extract($_GET);

$where = " WHERE `problemstart` > '{$p1}' AND `problemstart` < '{$p2}' ";
$query = "SELECT `city`, COUNT(*) AS `nr`
    FROM `$GLOBALS[mysql_prefix]ticket` `t`
    {$where}
    AND  `t`.`status` != {$GLOBALS['STATUS_RESERVED']}
    GROUP BY `city`
    ORDER BY `nr` DESC
    LIMIT 5";				// limit is a BAACHART issue

$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), __FILE__, __LINE__);

if (mysql_num_rows($result) > 0) {
    $temp = explode ("/", get_variable('pie_charts'));
    $type_diam = (count($temp)> 0 )? intval($temp[2]) : "450";		//
    $width = isset($img_width)? $img_width: $type_diam;	// 3/21/10

    include 'baaChart.php';
    $mygraph = new baaChart($width);
    $incidents_capt = get_text("incidents");
    $mygraph->setTitle("{$incidents_capt} by City","");

    while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {			//
        $row ['city']  = ( @strlen( @trim ( $row ['city'] ) )> 0 ) ? $row ['city'] : " ? " ;	// possible null/empty
        $mygraph->addDataSeries('P',PIE_CHART_PCENT + PIE_LEGEND_VALUE, $row ['nr'] , $row ['city'] );
        }
    $mygraph->setBgColor(0,0,0,1);  //transparent background
    $mygraph->setChartBgColor(0,0,0,1);  //as background
    $mygraph->drawGraph();
    }
else {		// a WTF situation?
    $err_arg = basename(__FILE__) . "/" . __LINE__;
    do_log ($GLOBALS['LOG_ERROR'], 0, 0, $err_arg);		// log error message
    }
?>