Author: Cj B

Can I just say that how fucking amazing it is to have the black pearl in my back yard!

Had a dentist appointment the other day, painful. 🙁 I’ve been putting it off for like 2 years, easy to do really. Cause I hate the dentist… The woman was very nice and kinda funny cause she kept swearing.

Working in Newport two days this week, the damn DSL thing up north doesn’t really work that well. I found out that the MIS guys are streaming music over it.. Gee, wonder why it’s so slow… I also had to go talk to the MIS guys the other day, whoever it was, didn’t have a clue about what he was doing.

BTW, thanks to all who helped out with the problem I had the other day… Ended up with a solution somewhat like this (Yes, it’s a MESS):

 $row['TicketID'],

						  "Summed" => $row['Summed'],

						  "Description" => $row['RangeName']);

		$row = dbi_fetch_row($results);

	}



//print_r($Tickets);

//die();

//	print("COUNT TICKETS: " .  count($Tickets) . "
");



	$j = 0;

	for ($i = 0; $i < count($Tickets); $i++) {

		$Total = 0;

		$Total_New = 0;

		$varName = $Tickets[$i]['Description'];

		$Ticket_Avg[$varName]['Range'] = $varName;

		if ($j-1 != -1) {

			$TempJ = $j - 1;

		} else {

			$TempJ = 0;

		}

		if ($Ranges[$TempJ] != $varName) {

			$Ranges[$j] = $varName;

			$j++;

		}

		if ($Tickets[$i]['ID'] != '') {

			$sql = "SELECT UNIX_TIMESTAMP(Created) AS Created,

						OldValue,

						NewValue

					FROM Transactions

					WHERE Type = 'Status'

						AND (OldValue LIKE 'pend%' OR NewValue LIKE 'pend%')

						AND ObjectID = " . $Tickets[$i]['ID'] . "

					ORDER BY ObjectID, Created";

			$results = 	dbi_query($sql);

			$row = dbi_fetch_row($results);



			$Difference = 0;

			while ($row) {

				$FirstValue = 0;

				$SecondValue = 0;



				$FirstValue = $row['Created'];



				$row = dbi_fetch_row($results);

				if ($row) {

					$SecondValue = $row['Created'];

				}



				if ($SecondValue > 0) {

					$Difference = $Difference + ($SecondValue - $FirstValue)/60/60;

				}

		//		print("First: $FirstValue Second: $SecondValue Difference: $Difference 
");

				$row = dbi_fetch_row($results);

			}



			$Total = $Tickets[$i]['Summed'];

			if ($Difference > 0) {

				$Total_New = $Total - $Difference;

				$Tickets[$i]['Summed'] = $Total_New;

			}

			$Ticket_Avg[$varName]['Count'] = $Ticket_Avg[$varName]['Count'] + 1;

			$Ticket_Avg[$varName]['Total'] = $Ticket_Avg[$varName]['Total'] + $Tickets[$i]['Summed'];

//		print("Total: $Total Total_New: $Total_New 
 
");

		}

	}



//	print_r($Ranges);



	for($i = 0; $i < count($Ranges); $i++) {

		if ( $Ticket_Avg[$Ranges[$i]]['Total'] > 0) {

			$ydata[] = $Ticket_Avg[$Ranges[$i]]['Total']/$Ticket_Avg[$Ranges[$i]]['Count'];

		} else {

			$ydata[] = 0;

		}

	//	print("DateRange: " . $Ticket_Avg[$Ranges[$i]]['Range'] . "

	//			Average: " . $Ticket_Avg[$Ranges[$i]]['Total']/$Ticket_Avg[$Ranges[$i]]['Count'] . "
");

	}



	$datax = $Ranges;



//	print_r($ydata);

//	print("
");

//	print_r($datax);

//	die();



/*	$results = 	dbi_query($sql);

	$num_results = mysql_num_rows($results);

	for ($j = 0; $j < $num_results; $j++) {

		$row = dbi_fetch_row($results);

		$ydata[] = $row['Summed'];

//		print("Phone $j: " . $row['Summed'] . " Range: " . $row['RangeName']. "
");

		$datax[] = $row['RangeName'];

	} */

?>

I’m sure it’s not the _BEST_ way to do it, but it works! 🙂

I have no plans so far for the long weekend… Got a work event on Friday, other then that nothing.. Blah. Hopefully something will present itself. If not, my clock innards should be here this Friday, so maybe I can finish that up!

Check out this cool graphs of home prices:

Hopefully for me, home prices will crash a bit…. 🙂 Not good for everyone else, or probably the economy in general really.

Adios all!