// breakdown.inc.php - Displays the incidents for a particular day and condition (i.e. closed, opened etc) // // SiT (Support Incident Tracker) - Support call tracking system // Copyright (C) 2000-2009 Salford Software Ltd. and Contributors // // This software may be used and distributed according to the terms // of the GNU General Public License, incorporated herein by reference. // // Author: Paul Heaney <paulheaney[at]users.sourceforge.net> // Included by ../statistics.php // Prevent script from being run directly (ie. it must always be included if (realpath(__FILE__) == realpath($_SERVER['SCRIPT_FILENAME'])) { exit; } $sql = get_sql_statement($startdate, $enddate, $query, FALSE); $result = mysql_query($sql); if (mysql_error()) { trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING); } $start_str = date("Y-m-d", $startdate); $end_str = date("Y-m-d", $enddate); switch ($query) { case 0: $type = 'opened'; break; case 1: $type = 'closed'; break; case 2: $type = 'updated';
/** * Show Open, Closed, Updated today, this week, this month etc. * @author Paul Heaney */ function count_incidents($startdate, $enddate) { // Counts the number of incidents opened between a start date and an end date // Returns an associative array // 0 $sql = get_sql_statement($startdate, $enddate, 0); $result = mysql_query($sql); list($count['opened']) = mysql_fetch_row($result); mysql_free_result($result); // 1 $sql = get_sql_statement($startdate, $enddate, 1); $result = mysql_query($sql); list($count['closed']) = mysql_fetch_row($result); mysql_free_result($result); // 2 $sql = get_sql_statement($startdate, $enddate, 2); $result = mysql_query($sql); list($count['updated']) = mysql_fetch_row($result); mysql_free_result($result); // 3 $sql = get_sql_statement($startdate, $enddate, 3); $result = mysql_query($sql); list($count['handled']) = mysql_fetch_row($result); mysql_free_result($result); // 4 $sql = get_sql_statement($startdate, $enddate, 4); $result = mysql_query($sql); if (mysql_error()) { trigger_error(mysql_error(), E_USER_WARNING); } list($count['updates'], $count['users']) = mysql_fetch_row($result); mysql_free_result($result); // 5 $sql = get_sql_statement($startdate, $enddate, 5); $result = mysql_query($sql); if (mysql_error()) { trigger_error(mysql_error(), E_USER_WARNING); } list($count['skills'], $count['owners']) = mysql_fetch_row($result); mysql_free_result($result); // 6 $sql = get_sql_statement($startdate, $enddate, 6); $result = mysql_query($sql); if (mysql_error()) { trigger_error(mysql_error(), E_USER_WARNING); } list($count['emailtx']) = mysql_fetch_row($result); mysql_free_result($result); // 7 $sql = get_sql_statement($startdate, $enddate, 7); $result = mysql_query($sql); if (mysql_error()) { trigger_error(mysql_error(), E_USER_WARNING); } list($count['emailrx']) = mysql_fetch_row($result); mysql_free_result($result); // 8 $sql = get_sql_statement($startdate, $enddate, 8); $result = mysql_query($sql); list($count['higherpriority']) = mysql_fetch_row($result); mysql_free_result($result); return $count; }