<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  require_once "/home/content/a/l/a/alameda582/html/_rtc2009/lib/viewer_functions.php";

  list($citationsRecords, $citationsMetaData) = getRecords(array(
    'tableName'   => 'citations',
    'perPage'     => '10',
    'loadUploads' => '0',
  ));

  // return mysql format date "1899-02-09 15:00:27" in this format "Dec 31, 1969" 
  function formatMysqlDate($mysqlDate) {
  list($year, $monthNum, $zeroPaddedDay) = preg_split("/[- ]/", $mysqlDate);
     $shortMonthName = date('M', mktime(0,0,0,$monthNum,1));   
     $longMonthName  = date('F', mktime(0,0,0,$monthNum,1));   
     $dayNum         = (int) $zeroPaddedDay;    
     echo "$shortMonthName $dayNum, $year"; 
   } 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
  <link rel="stylesheet" type="text/css" href="styles/stylemain.css">
 </head>
<body>
<center><img border="0" src="images/title.gif" width="501" height="96"><br/><br/>

<center><h2>Citation Search Results</h2>

  <?php if ($citationsMetaData['totalPages'] > "1"): ?>
    <?php if ($citationsMetaData['prevPage']): ?>
      <a href="<?php echo $citationsMetaData['prevPageLink'] ?>">&lt;&lt; prev</a>
    <?php else: ?>
      &lt;&lt; prev
  <?php endif ?>

    - page <?php echo $citationsMetaData['page'] ?> of <?php echo $citationsMetaData['totalPages'] ?> -

    <?php if ($citationsMetaData['nextPage']): ?>
      <a href="<?php echo $citationsMetaData['nextPageLink'] ?>">next &gt;&gt;</a>
    <?php else: ?>
      next &gt;&gt;
    <?php endif ?>
    <br/>
  <?php endif ?><br/>
  <a href="<?php echo $citationsMetaData['_listPage']; ?>">&lt;&lt; Back to Index page &gt;&gt;</a>
</center>

<div align="center">
	<table width="800" id="table1" border="1px" style="border-collapse: collapse">
		<tr><b>
      		<td bgcolor="#000000" style="color: #FFFF00">Cite #</td>
      		<td bgcolor="#000000" style="color: #FFFF00">Date/Time</td>
      		<td bgcolor="#000000" style="color: #FFFF00">Weekday</td>
      		<td bgcolor="#000000" style="color: #FFFF00">Last Name</td>
      		<td bgcolor="#000000" style="color: #FFFF00">DL/ID</td>
      		<td bgcolor="#000000" style="color: #FFFF00">DOB</td>
      		<td bgcolor="#000000" style="color: #FFFF00">Vehicle Lic/VIN</td></b>
      	</tr>
    <?php foreach ($citationsRecords as $record): ?>
      	<tr>
      	<td width="80"><b><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a></b></td>	
      	<td width="160"><?php echo date("M jS, Y g:i:s a", strtotime($record['date_time_of_violation'])) ?></td>
		<td width="70"><?php echo date("l", strtotime($record['date_time_of_violation'])) ?></td>
		<td width="150"><?php echo $record['last_name'] ?></td>
		<td width="80"><?php echo $record['dl_number'] ?></td>
		<td width="80"><?php formatMysqlDate($record['birthdate']) ?></td>
		<td><?php echo $record['vehicle_license_or_vin'] ?></td>
		</tr><br/>
	</table>

    <p>&nbsp;</p>
      
  <?php endforeach; ?>
</div>
    <?php if ($citationsMetaData['invalidPageNum']): ?>
      Results page '<?php echo $citationsMetaData['page']?>' not found, <a href="<?php echo $citationsMetaData['firstPageLink'] ?>">start over &gt;&gt;</a>.<br/><br/>
    <?php elseif (!$citationsRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>

  <?php if ($citationsMetaData['totalPages'] > "1"): ?>
    <?php if ($citationsMetaData['prevPage']): ?>
      <a href="<?php echo $citationsMetaData['prevPageLink'] ?>">&lt;&lt; prev</a>
    <?php else: ?>
      &lt;&lt; prev
  <?php endif ?>

    - page <?php echo $citationsMetaData['page'] ?> of <?php echo $citationsMetaData['totalPages'] ?> -

    <?php if ($citationsMetaData['nextPage']): ?>
      <a href="<?php echo $citationsMetaData['nextPageLink'] ?>">next &gt;&gt;</a>
    <?php else: ?>
      next &gt;&gt;
    <?php endif ?>
    <br/>
  <?php endif ?>

</body>
</html>
