<?php
//Connection statement
require_once('../Connections/guest_acct.php');

// begin Recordset
$query_fees = "
SELECT *, cost-old_cost as increase FROM pricelist 
  where type != 'flatrate' 
  and type != 'backups'
  and name != 'Adjustments'
  and cost != '0'
  ORDER BY service_code ASC";
$fees = $guest_acct->SelectLimit($query_fees) or die($guest_acct->ErrorMsg());
$totalRows_fees = $fees->RecordCount();
// end Recordset

//PHP ADODB document - made with PHAkt 2.8.2
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>PCS Fee Schedule</title>
<link href="/~pcs/css/genericblue.css" rel="stylesheet" type="text/css">
</head>

<body>
<div id="superheader">
	| <a href="http://www.physics.utoronto.ca/services/pcs">PCS Group</a> 
	| <a href="http://www.physics.utoronto.ca/">Physics Department</a> 
	| <a href="http://www.artsci.utoronto.ca/">Arts and Science</a> 
	| <a href="http://www.utoronto.ca/">University of Toronto</a>
	|</div>
<div id="outer">
<div id="hdr">
	
<h1>PCS Fee Schedule</h1>
<p>Fee schedule for the Physics Computing Services as of May 2014.</p>
</div>
<div id="bodyblock">
<!--
<h2>Announcement of Fee Changes!</h2>  

<p>Please note that the fees for the services provided by PCS have been
increased by 10% as of June 2012</p>
-->
<h2>Fee Schedule</h2>
<table>
	<tr class="lines">
		<th class="lines">Name</th>
		<th class="lines">before May 2014</th>
		<th class="lines">increase</th>
		<th class="lines">since May 2014</th>
		<th class="lines">per year</th>
		<th class="lines">Type</th>
	</tr>
<?php while(!$fees->EOF){ ?>
	<tr valign="top">
		<td class="lines">
			<?php echo $fees->Fields('name')?><br />
			<span class="info"><?php echo $fees->Fields('serv_notes')?></span>
		</td class="lines">
		<td class="lines" align="right">
			$<?php echo $fees->Fields('old_cost')?> / 
			<?php echo $fees->Fields('unit_month')?>
		</td>
		<td class="lines" align="right">
			$<?php echo $fees->Fields('increase')?> / 
			<?php echo $fees->Fields('unit_month')?>
		</td>
		<td class="lines" align="right">
			$<?php echo $fees->Fields('cost')?> / 
			<?php echo $fees->Fields('unit_month')?>
		</td>
		<td class="lines" align="right">
			$<?php echo $fees->Fields('cost')*12?> / 
			<?php echo $fees->Fields('unit_month')?>
		</td>
		<td class="lines"><?php echo $fees->Fields('type')?></td>
	</tr>
<?php $fees->MoveNext();
	  }
	  $fees->MoveFirst();
	?>
</table>
</div>
<div id="ftr">2008 Physics Computing Services</div>
</div>
</body>
</html>
<?php
$fees->Close();
?>
