Tag: oracle

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!

Wow that was one long ass night.

Lets see… Yesterday at work was ok… Nothing exciting as per usual. I’ve been working on this project, and someone else completed it before me.. It’s like, why were we both working on this? I meah of COURSE he was going to finish it before me beacuse he’s oracle trained, and I’m just guessing and leaning this shit as I go.

I feel like I’m not doing a very good job right now.

Whatever.. So I came home and hung out. Robert came over and picked me up at 6 and we went to the theaters and met Patrick there. We saw She’s the Man. And for being a total chick flick, it was really very funny and of course the hot boys did help! They had an amazing redo of the Mary Tyler Moore Theme song, “Love is all around”. I’ve been trying to buy it all morning on iTunes, but it keeps telling me the song has moved! Gah!

After that we went down to Laguna Beach and ate dinner at the Koffee Klatch… About 11 we headed over to the Boom and met up with two other people, who I can’t really remember their names right now. But we all had a really good time I had two long island ice teas and a jack and coke and a huge jack and coke at the Klatch.. So I was pretty wasted. And for some reason I was really in the mood to start a bar fight. If only a certian someone had shown up with. haha.

I also tipped the dancer and got a nice dance from him. The place was pretty dead. but there was this REALLY cute boy in a green shirt, sadly come to find out he had a boyfriend. 🙁 And the boy who was all over me last week was there too, and I kept trying to get his attention, but he was ignoring me this time… I shoulda just made a move.

Tonight I’m supposed to be going out with this guy. But I’m not sure I really want too. I’m getting so socially drained, and last time we hung out he tried making moves on me, and I’m really not in a mood to deal with that right now.

Ugh, and that’s life.