<?php
	global $filterAccYearID, $filterCurAccYearID, $filterCurSemester, $filterGradReason, $filterSurname, $filterForname;
	//var_dump($filterAccYearID);
	//var_dump($filterSurname);
	//var_dump($filterForname);
	//var_dump($filterAccYearID); 
?>
<!-- ###### -->
  <h2>@[PAGE_TITLE]</h2>
  
  
  <!-- jTable http://www.jtable.org -->
  <script type="text/javascript" src="@[URLROOT]/scripts/jtable.2.4.0/jquery.jtable.min.js"></script>
  <!-- <link rel="stylesheet" type="text/css" href="@[URLROOT]/scripts/jtable.2.4.0/themes/metro/blue/jtable.css" /> -->
  <link rel="stylesheet" type="text/css" href="@[URLROOT]/scripts/jtable.2.4.0/themes/lightcolor/blue/jtable.css" />
  
<style>
	#homepage #main_column{
		z-index: 1000;
	}	
</style>
  
  
  
<script type="text/javascript">
    $(document).ready(function () {
    	$('#PersonTableContainer').jtable({
            title: 'ΜΗΤΡΩΟ',
            loadingAnimationDelay: 200,
            paging: true, //Enable paging
            pageSize: 10, //Set page size (default: 10)
            sorting: true, //Enable sorting
            defaultSorting: 'Id DESC', //Set default sorting
            actions: {
                listAction: '@[URLROOT]/sources/registry_list.php?action=list'
                /*
                createAction: '/GettingStarted/CreatePerson',
                updateAction: '/GettingStarted/UpdatePerson',
                deleteAction: '/GettingStarted/DeletePerson'
                */
            },
            fields: {
                Id: {
                    key: true,
                    list: true,
                    title: 'Α.M.',
                    width: '5%',
                    display: function (data) {
     				   return data.record['Id'] + ' <a href="registry_showstudent.php?id=' + data.record['Id'] + '" title="άνοιγμα φακέλου φοιτητή"><img src="images/open.gif"></a>&nbsp;&nbsp;<a href="regcert.php?id=' + data.record['Id'] + '" target="_blank" title="βεβαίωση σπουδών"><img src="images/document.png" width="16"></a>';
    				}                	
                },
                Surname: {
                    title: 'Επώνυμο',                	
                    width: '10%',                	
                },
                Forname: {
                    title: 'Όνομα',                	
                    width: '10%',                	
                },
                RegAccYear: {
                    title: 'Εγγραφή',                	
                    width: '3%',                	
                    display: function (data) {
     				   return data.record['RegAccYearDesc'];
    				}                	
                },
                CurSemester: {
                    title: 'Εξ.',                	
                    width: '2%',
                    display: function (data) {
     				   return data.record['CurSemNumber'] + 'ο '; // + data.record['CurSemDescription'];
    				}
                },
                Contact: {
                	sorting: false,
                    title: 'Email',                	
                    width: '8%',                	
                    display: function (data) {
     				   return '<a href="mailto:' + data.record['Email'] + '" target="_blank">' + data.record['Email'] + '</a>'; //<br/>'  + data.record['Telephone'] + '<br/>' + data.record['Mobile'];
    				}
                },
                Telephone: {
                	sorting: false,
                    width: '6%',                	
                	title: 'Τηλ.'
                },
                Mobile: {
                	sorting: false,
                    width: '6%',                	
                	title: 'Κιν.'
                }
                /*
                numOfTripLegs: {
                    title: 'Ακαδημαϊκή Κατάσταση',                	
                    awidth: '4%',
                    display: function (data) {
     				   return 'Εγγραφή:&nbsp;' + data.record['RegAccYearDesc'] + '<br>Εξάμ:&nbsp;' + data.record['CurSemNumber'];
    				}
                },
                */
            }
    	});
    	
    	
	    $('#butSubmit').click(function (e) {
	        e.preventDefault();
	        
            $('#PersonTableContainer').jtable('load', {
            	filterAccYearID: $('#filterAccYearID').val(),            	
            	filterCurAccYearID: $('#filterCurAccYearID').val(),
            	filterCurSemester: $('#filterCurSemester').val(),
            	filterGradReason: $('#filterGradReason').val(),
            	filterSurname: $('#filterSurname').val(),
            	filterForname: $('#filterForname').val()                            
            });
	        
	    });
    	
	    $('#butClear').click(function (e) {
	        e.preventDefault();
	        
			$('#filterAccYearID').val("");
			$('#filterCurAccYearID').val("");
			$('#filterCurSemester').val("");
			$('#filterGradReason').val("");
			$('#filterSurname').val("");
			$('#filterForname').val("");
	
	    	$('#PersonTableContainer').jtable('load');
	    	
	    });
	    
	    $('#butSubmit').button();
	    $('#butClear').button();
    	
        //Load all records when page is first shown
        $('#butSubmit').click();        
    	
	});


</script>  
  
  
<div style="background-color: #fff;	z-index: 2000; width: 920px; min-height: 850px">  

<form method="POST">  
<div id="effect" aclass="ui-widget-content ui-corner-all ui-buttonset" style="border-radius: 3px; border: 1px solid #2B5177; box-shadow: inset 0 1px 0 0 rgba(255, 255, 255, 0.5); background: linear-gradient(to bottom, #e0eeff 0%, #b0cff0 100%); margin: 10px 0px; display: block; background-position: initial initial; background-repeat: initial initial;">
	<form name="protocol_form" method="post">
		<input type="hidden" name="action" value="search" />
	<table>
		<tbody>
		<tr>
			<td colspan="4" align="center" style="font-weight: bold; font-size: 12pt">Φίλτρα</td>
		</tr>
		<tr>
			<td style="width: 159px; font-weight: bold; text-align: right;">Ακαδ. Έτος Εγγραφής:</td>
			<td width="280">
				<select name="filterAccYearID" id="filterAccYearID">
					<option value="">(όλα)</option>
					<?php
						$accYears = DBUtils::getObjects("SELECT * FROM `msc_accyears`", "Id");
						foreach ($accYears as $accYearId => $curAccYear) {
							$selected = ($filterAccYearID == $curAccYear->Id) ? " selected" : "";
							Utils::prline("<option value=\"{$curAccYear->Id}\"{$selected}>{$curAccYear->Description}</option>");
						}
					?>
				</select>
			</td>
			
			<td style="width: 159px; font-weight: bold; text-align: right;">Τρέχον Ακαδ. Έτος:</td>
			<td width="280">
				<select name="filterCurAccYearID" id="filterCurAccYearID">
					<option value="">(όλα)</option>
					<?php
						$accYears = DBUtils::getObjects("SELECT * FROM `msc_accyears`", "Id");
						foreach ($accYears as $accYearId => $curAccYear) {
							$selected = ($filterCurAccYearID == $curAccYear->Id) ? " selected" : "";
							Utils::prline("<option value=\"{$curAccYear->Id}\"{$selected}>{$curAccYear->Description}</option>");
						}
					?>
				</select>
			</td>			
		</tr>
		<tr>
			<td style="font-weight: bold; text-align: right;">Τρέχον Εξάμηνο:</td>
			<td>
				<select name="filterCurSemester" id="filterCurSemester">
					<option value="">(όλα)</option>
					<?php
						$accYears = DBUtils::getObjects("SELECT * FROM `msc_semesters`", "Id");
						foreach ($accYears as $accYearId => $curAccYear) {
							$selected = ($filterCurSemester == $curAccYear->Id) ? " selected" : "";
							Utils::prline("<option value=\"{$curAccYear->Id}\"{$selected}>{$curAccYear->Description}</option>");
						}
					?>
				</select>
			</td>

			<td style="font-weight: bold; text-align: right;">Αποφοίτηση:</td>
			<td>				
				<select name="filterGradReason" id="filterGradReason">
					<option value="">(όλοι)</option>
					
					<?php $selected = ($filterGradReason == "0") ? " selected" : ""; ?>
					<option value="0" <?php echo $selected; ?>>ΕΝΕΡΓΟΙ</option>
					<?php
						$accYears = DBUtils::getObjects("SELECT * FROM `msc_gradreasons`", "Id");
						foreach ($accYears as $accYearId => $curAccYear) {
							$selected = ($filterGradReason == $curAccYear->Id) ? " selected" : "";
							Utils::prline("<option value=\"{$curAccYear->Id}\"{$selected}>{$curAccYear->Description}</option>");
						}
					?>
				</select>
			</td>
		</tr>
		<tr>
			<td style="font-weight: bold; text-align: right;">Επώνυμο:</td>
			<td colspan="3"><input type="text" name="filterSurname" id="filterSurname" style="width: 729px" value="<?php echo $filterSurname; ?>"></td>
		</tr>
		<tr>
			<td style="font-weight: bold; text-align: right;">Όνομα:</td>
			<td colspan="3"><input type="text" name="filterForname" id="filterForname" style="width: 729px" value="<?php echo $filterForname; ?>"></td>
		</tr>
		<tr>
			<td>&nbsp;</td>
			<td>
				<input type="submit" name="butSubmit" id="butSubmit" value="Αναζήτηση">
			</td>
			<td>
			</td>
			<td>
				<input type="submit" name="butClear" id="butClear" value="Καθαρισμός">
			</td>
		</tr>
	</tbody></table>
	</form>
</div>  
</form>

<div id="PersonTableContainer"></div>
  

</div>