<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  require_once "C:/Sybase/htdocs/nptAdmin/lib/viewer_functions.php";

  list($dms_home_pageRecords, $dms_home_pageMetaData) = getRecords(array(
    'tableName'   => 'dms_home_page',
    'perPage'     => '10',
  ));

?>


<!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>CCA</title>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
  <style type="text/css">
    body          { font-family: arial; }
    .searchblock { border: 3px solid #000; background-color: #EEE; padding: 10px; text-align: left; margin: 25px}
  </style>
 </head>
<body>


    <h1>CCA Search Results</h1>


    <div class="searchblock">
    <table cellpadding="3">
    	<?php $query="";
		foreach($_REQUEST as $key=>$value){
			if($key!="orderBy"){
			$query.="$key=$value&";
			}
			}
		?>

    	<th><a href="specialResults.php?<?php echo $query>orderBy=<?php echo (@$_REQUEST['orderBy']!="course_id")? "course_id" : "course_id DESC" ?>">Course ID</a></th>
    	<th><a href="specialResults.php?<?php echo $query>orderBy=<?php echo (@$_REQUEST['orderBy']!="title")? "title" : "title DESC" ?>">Course Description</a></th>
    	<th><a href="specialResults.php?<?php echo $query>orderBy=<?php echo (@$_REQUEST['orderBy']!="approval_date")? "approval_date" : "approval_date DESC" ?>">Approval Date</a></th>
    	<th>CCA</th>
    	<th>QSP Title</th>
    <?php foreach ($dms_home_pageRecords as $record): ?>
    	<tr>
    		<td><?php echo join(', ', getListLabels('dms_home_page', 'course_id', $record['course_id'])); ?></td>
   			<td><?php echo $record['title'] ?></td>
    		<td><?php echo date("d M Y", strtotime($record['approval_date'])) ?></td>
    		<td><?php echo $record['cca'] ?></td>
    		<td>
    			<?php foreach ($record['filename'] as $upload): ?>
    			<?php echo $upload['info1'] ?>
    			<?php endforeach ?>
    		</td>
		</tr>
    <?php endforeach ?>
	</table>

	<?php if (!$dms_home_pageRecords): ?>
	    No records were found!<br/><br/>
    <?php endif ?>
</div>
    <?php if ($dms_home_pageMetaData['invalidPageNum']): ?>
      Results page '<?php echo $dms_home_pageMetaData['page']?>' not found, <a href="<?php echo $dms_home_pageMetaData['firstPageLink'] ?>">start over &gt;&gt;</a>.<br/><br/>
    <?php elseif (!$dms_home_pageRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>

    <?php if ($dms_home_pageMetaData['prevPage']): ?>
      <a href="<?php echo $dms_home_pageMetaData['prevPageLink'] ?>">&lt;&lt; prev</a>
    <?php else: ?>
      &lt;&lt; prev
    <?php endif ?>

    - page <?php echo $dms_home_pageMetaData['page'] ?> of <?php echo $dms_home_pageMetaData['totalPages'] ?> -

    <?php if ($dms_home_pageMetaData['nextPage']): ?>
      <a href="<?php echo $dms_home_pageMetaData['nextPageLink'] ?>">next &gt;&gt;</a>
    <?php else: ?>
      next &gt;&gt;
    <?php endif ?>

<br /><br />
<a href="index.php">Return to CCA Report Page</a>

</body>
</html>
