<?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',
    'loadUploads' => '0',
    'allowSearch' => '0',

  ));

  list($ccaRecords, $ccaMetaData) = getRecords(array(
      'tableName'   => 'cca',
      'orderBy'     => 'title asc',
      'loadUploads' => '0',
      'allowSearch' => '0',
    ));

  list($mosRecords, $mosMetaData) = getRecords(array(
    'tableName'   => 'mos',
    'loadUploads' => '0',
    'orderBy'	  => 'title asc',
	'allowSearch' => '0',
  ));

  list($competencyRecords, $competencyMetaData) = getRecords(array(
    'tableName'   => 'competency',
    'loadUploads' => '0',
    'allowSearch' => '0',
  ));

  list($mite_course_idRecords, $mite_course_idMetaData) = getRecords(array(
    'tableName'   => 'mite_course_id',
    'loadUploads' => '0',
    'allowSearch' => '0',
  ));

  list($qualification_levelRecords, $qualification_levelMetaData) = getRecords(array(
      'tableName'   => 'qualification_level',
      'loadUploads' => '0',
      'allowSearch' => '0',
    ));

  list($developmental_periodRecords, $developmental_periodMetaData) = getRecords(array(
    'tableName'   => 'developmental_period',
    'loadUploads' => '0',
    'allowSearch' => '0',
  ));


?>
<!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>QSP Search</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>QSP Repository</h1>
<br />
<div class="searchblock">
<p><b>Instructions:</b>  You may search using any of the search criteria below.  If you use more than one criteria, be aware that
the search will be an "AND" search.  For example, if you choose an MOS and a CCA, the search will display all QSPs that belong to
that CCA and are for the specific MOS.</p>
<p>Specific reports are available on demand.  Please contact <a href="mailto:ragi.sekaly@forces.gc.ca">DMTE Technical Support</a> for assistance.</p>
<p>CCA QSP Report:
<form method="POST" action="specialResults.php">
	<select name="cca" value="" size="1" style="width: 120px;">
	<option value="" Select a CCA Report</option>
	<?php foreach ($ccaRecords as $record): ?>
	<option value="<?php echo $record['title'] ?>"><?php echo $record['title'] ?></option>
	<?php endforeach; ?>
	</select>
<input type="submit" name="submit" value="Search">
<input type="reset" value="Reset">
</form>
</div>
</br />
<div class="searchblock">
<table cellpadding="10">
	<tr>
		<td colspan="8">
			<b>Search for word in Course Name</b>
		</td>
	</tr>
	<tr>
    <form method="POST" action="searchResults.php">
    	<td colspan="8"><input type="text" name="title_keyword" value="" size="60"><br /></td>
    </tr>
    <tr>
  		<td align="center"><b>Enter Course ID:</b></td>
  		<td align="center"><b>Enter Competency:</b></td>
  		<td align="center"><b>Select MOS:</b></td>
  		<td align="center"><b>Select CCA:</b></td>
  		<td align="center"><b>Select Qualification Level:</b></td>
  		<td align="center"><b>Select Developmental Period:</b></td>
  		<td align="center"><b>Archive:</b></td>
  	</tr>
  	<tr>
  		<td><input type="text" name="course_id_match" value="" size="14"></td>
  		<td><input type="text" name="competency_match" value="" size="14"></td>
  		<td>
  			<select name="mos_id" value="" size="1" style="width: 120px;">
  			<option value="" Select an MOS</option>
  			<?php foreach ($mosRecords as $record): ?>
			<option value="<?php echo $record['mos_id'] ?>"><?php echo $record['title'] ?></option>
			<?php endforeach; ?>
			</select>
		</td>
		<td>
			<select name="cca" value="" size="1" style="width: 120px;">
			<option value="" Select a CCA</option>
		  	<?php foreach ($ccaRecords as $record): ?>
			<option value="<?php echo $record['title'] ?>"><?php echo $record['title'] ?></option>
			<?php endforeach; ?>
			</select>
		</td>
		<td>
			<select name="ql" value="" size="1" style="width: 120px;">
			<option value="" Select a QL</option>
			<?php foreach ($qualification_levelRecords as $record): ?>
			<option value="<?php echo $record['ql'] ?>"><?php echo $record['ql'] ?></option>
			<?php endforeach; ?>
			</select>
		</td>
		<td>
			<select name="dp" value="" size="1" style="width: 120px;">
			<option value="" Select a DP</option>
			<?php foreach ($developmental_periodRecords as $record): ?>
			<option value="<?php echo $record['dp'] ?>"><?php echo $record['dp'] ?></option>
			<?php endforeach; ?>
			</select>
		</td>
		<td align="center">
			<input type="checkbox" name="archive" value="">
		</td>
	</tr>
	<tr colspan="8">
  	<td><input type="submit" name="submit" value="Search">
  	<input type="reset" value="Reset">
	</form></td>
	</tr>
</table>

<br />

</div>





</body>
</html>