cs_footer_generics_admin.php

</div>
		</div>
	<!--	<div class="span3">		
			<div id="blog-sidebar" role="complementary">
				<ul id="sidebar-widgets">
					<li id="text-5" class="widget widget_text">
						<h2 class="widget-title" >Last Week</h2>			
						<div class="textwidget">
							<h4>Generic Types</h4>
						   	<table id="yesterday">
								<tr>
									<th class="col1">Type</th>
									<th class="col2">#</th>
								</tr>
									<?php
										/*mysql_connect($dbhost,$dbuser,$dbpass);
										@mysql_select_db($dbname) or die("Unable to select database");

										$start_past = strtotime("last week"); 
										$end_past = strtotime("+6 day",$start_past);

										$start_past_qry = date("Y-m-d",$start_past);
										$end_past_qry = date("Y-m-d",$end_past);

										$generic_types_array = array("Transfer","Dropped Call","No File","Misc");
										for ($i=0; $i<sizeof($generic_types_array); $i++) {
											//$query_lastweek = "SELECT COUNT(*) as total_count FROM `cs_generics` WHERE (`type` = '$generic_types_array[$i]') ";
											$query_lastweek = "SELECT COUNT(*) as total_count 
																FROM `cs_generics` 
																WHERE (DATE(time) BETWEEN '$start_past_qry' AND '$end_past_qry') 
																	AND (`type` = '$generic_types_array[$i]') ";
											$result_lastweek = mysql_query($query_lastweek);
											$row_lastweek = mysql_fetch_array($result_lastweek);
											echo "<tr><td>" . $generic_types_array[$i] . "</td><td>" . $row_lastweek['total_count'] . "</td></tr>";

										}
										echo "</table><br />";
										echo "<h4>Transfers</h4>
											  <table id='yesterday'>
												<tr>
													<th class='col1'>Transfer To</th>
													<th class='col2'>#</th>
												</tr>";
						 				
										$generic_transfers_array = array("Admissions","Athletics","Bursar","Perkins","Counselor","Schol/StudentEmp","Admin/Loans","Registrar","Reslife","OSSA","UITS","Veterans","Other");
										for ($i=0; $i<sizeof($generic_transfers_array); $i++) {
											$query_lastweek_transfer = "SELECT COUNT(*) as total_count 
																		FROM `cs_generics` 
																		WHERE (DATE(time) BETWEEN '$start_past_qry' AND '$end_past_qry') 
																			AND (`transfer_to` = '$generic_transfers_array[$i]') 
																			AND (`type` = 'Transfer')";
											$result_lastweek_transfer = mysql_query($query_lastweek_transfer);
											$row_lastweek_transfer = mysql_fetch_array($result_lastweek_transfer);
											echo "<tr><td>" . $generic_transfers_array[$i] . "</td><td>" . $row_lastweek_transfer['total_count'] . "</td></tr>";

										}
										mysql_close();
*/
										
									?>
							</table>                                                            
						</div>
					</li>
				</ul>
			</div>
		</div>-->
	</div>
</div><!--#uc-main-->
<div id="uc-footer">
	<div class="container">
		<ul id="uc-footer-links" class="clearfix">
			<li>
				© <a href="http://uconn.edu">University of Connecticut</a>
			</li>
			<li>
				<a href="http://uconn.edu/disclaimers-and-copyrights.php">Disclaimers, Privacy &amp; Copyright</a>
			</li>
			<li>
				<a href="http://financialaid.uconn.edu/wp-admin/">Webmaster Login</a>
			</li>
			<li id="menu-item-2208" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2208">
				<a href="http://financialaid.uconn.edu/student-consumer-information/">Student Consumer Information</a>
			</li>
			
		</ul>
	</div>
</div>
</body>
</html>