Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > Beginning PHP
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Beginning PHP Beginning-level PHP discussions. More advanced coders should post to the Pro PHP forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning PHP section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 15th, 2016, 11:39 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem (obviously)

Hello:
So, I am having a problem with my code (below). It is calculating fine untill it gets to the Technical Support and then it is calculating the open tickets as null. It calculates Overdue fine, but from Technical support on it is calculating it as a null when it is most definitely not a null. I printed out the array values, so that is how I know it is a null. Anyone have any thoughts on what to do?

Thanks in advance,
Bmorris

Quote:
"Help Desk":{"overdue":"2","open":"3","height":8},"Purch asing":{"overdue":"0","open":"1","height":3},"MIS" :{"overdue":"0","open":"1","height":3},"Technica l Support":{"overdue":"0","open":null,"height":0},"I nfrastructure":{"overdue":"1","open":null,"height" :0},"Client Services":{"overdue":"0","open":null,"height":0}," Web Apps":{"overdue":"0","open":null,"height":0},"Lab Supplies":{"overdue":"1","open":null,"height":0}," 1st Level Support":{"overdue":null,"open":null,"height":0}," 2nd Level Support":{"overdue":null,"open":null,"height":0},
Code:
<?php
//error_reporting(E_ALL);
error_reporting(0);

require_once 'statusboard/db_connect.php';
// **********************************
// *     Code by Matt Satorius      *
// *        www.sators.com          *
// **********************************

// Get the total number of tickets by status
$data = mysql_query("SELECT ticketstatusid, COUNT(*) AS totals FROM swtickets GROUP BY ticketstatusid") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
	$_ticketcnt[$temp['ticketstatusid']] = $temp['totals'];
}

// Save that in the final array
$totals["totalcounts"] = $_ticketcnt;

// Get all of the nonclosed counts
$data = mysql_query("SELECT SUM(CASE WHEN ticketstatusid !=3 THEN 1 ELSE 0 END ) AS nonclosed FROM swtickets WHERE ticketstatusid !=3") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
	$totalnonclosed = $temp['nonclosed'];
}

// The closed count
$totalclosed = $_ticketcnt["3"];


// Store Daily Total Ticket Counts for Comparison
$data = mysql_query("SELECT value1 AS lastupdated FROM statusboard WHERE type = 'tickettotalcomparedate'") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
	$lastupdateddate = $temp["lastupdated"];
}
$todaymidnight = date("U", mktime(0, 0, 0, date("m"), date("d"), date("Y")));
if ($lastupdateddate < $todaymidnight) 
{ 
	mysql_query("UPDATE statusboard SET value1 = ".time()." WHERE type = 'tickettotalcomparedate'");
	mysql_query("UPDATE statusboard SET value2 = ".$totalnonclosed." WHERE indexnumber =5");
	mysql_query("UPDATE statusboard SET value2 = ".$totalclosed." WHERE indexnumber =6");
}

// Do Ticket Comparison
$data = mysql_query("SELECT value1, value2 FROM statusboard WHERE type = 'ticketcount'") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) {
	$midnightcount[$temp['value1']] = $temp['value2'];
}
$closedbalance = $midnightcount["closed"] - $totalclosed;
$nonclosedbalance = $midnightcount["nonclosed"] - $totalnonclosed;
$balancedifference = $nonclosedbalance - $closedbalance;

$changepercent["total"] = round(((abs($balancedifference) / ($totalclosed + $totalnonclosed))*100), 2); 

if ( $balancedifference > 0 ) { 
	$changepercent["direction"] = "down"; 
} elseif ($balancedifference < 0){
	$changepercent["direction"] = "up"; 
} else {
	$changepercent["direction"] = "none"; 
}
$totals["tickettrend"] = $changepercent;

//Department Names
 $data = mysql_query("SELECT title FROM swdepartments WHERE departmentapp = 'tickets'") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
$_deptname [] = $temp['title'];
}

//Get Total Open Tickets by Department
 $data = mysql_query("SELECT SUM(CASE WHEN ticketstatusid = 1 THEN 1 ELSE 0 END) AS deptopen FROM swtickets WHERE ticketstatusid = 1 GROUP BY departmentid")or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
$_deptopen [] = $temp['deptopen'];
}

//Get Total Overdue Tickets by Department
 $data = mysql_query("SELECT SUM(CASE WHEN duetime < ".time()." AND duetime > 0 AND ticketstatusid = 1 THEN 1 ELSE 0 END) AS deptoverdue FROM swtickets GROUP BY departmentid ") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
$_deptoverdue [] = $temp['deptoverdue'];
}

// Set a top open ticket number for the dynamic column height of 100%.  We'll throw in 40, but only use 40 if no department has more than 40.  This way, if all departments only have a few open tickets, their columns are not all at 100% height
$_deptopen["maxoverride"] = 40;
$mostopentickets = max($_deptopen);

//Printing and Combining all to one array
foreach ($_deptname as $key => $title) 
{
	$totals[$title] = array('overdue' => $_deptoverdue[$key],  'open' => $_deptopen[$key], 'height' => round($_deptopen[$key]/$mostopentickets,2)*100);
}

// Last 5 Tickets
 $data = mysql_query("SELECT subject, dateline, duetime FROM swtickets WHERE ticketstatusid != 3 ORDER BY dateline DESC LIMIT 5") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) 
{
if (time() - $temp["dateline"] <= 3600) 
	{ $isnew = 1; } else { $isnew = 0; }
if ($temp["duetime"] < time() && $temp["duetime"] > 0) 
	{ $isoverdue = 1; } else { $isoverdue = 0; }
if( strlen($temp["subject"]) > 40) 
	{ $newsubject = substr($temp["subject"],0,40).'...'; } 
else 
	{ $newsubject = $temp["subject"];}
$_newtickets [] = array( 'subject' => $newsubject, 'isnew' => $isnew, 'isoverdue' => $isoverdue) ;
}

// Top 5 Overdue Tickets
 $data = mysql_query("SELECT subject FROM swtickets WHERE duetime < ".time()." AND duetime > 0 AND ticketstatusid = 1 ORDER BY dateline ASC LIMIT 5") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) {
if( strlen($temp["subject"]) > 40) { $newsubject = substr($temp["subject"],0,40).'...'; } else { $newsubject = $temp["subject"];}
$_overduetickets [] = $newsubject;
}

// Last 5 Changed Tickets -- depreciated
 $data = mysql_query("SELECT subject, dateline, duetime FROM swtickets ORDER BY lastactivity DESC LIMIT 5") or die(mysql_error()); 
while($temp = mysql_fetch_array( $data )) {
if (time() - $temp["dateline"] <= 3600) { $isnew = 1; } else { $isnew = 0; }
if ($temp["duetime"] < time() && $temp["duetime"] > 0) { $isoverdue = 1; } else { $isoverdue = 0; }
if( strlen($temp["subject"]) > 40) { $newsubject = substr($temp["subject"],0,40).'...'; } else { $newsubject = $temp["subject"];}
$_changedtickets [] = array( 'subject' => $newsubject, 'isnew' => $isnew, 'isoverdue' => $isoverdue) ;
}

//Totals packaging
$totals['newtickets'] = $_newtickets;
$totals['overduetickets'] = $_overduetickets;
$totals['changedtickets'] = $_changedtickets;

//JSON this guy
echo json_encode($totals); 

?>
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off



All times are GMT -4. The time now is 03:42 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.