<?php

$academics_id=$_POST["aid"];
$implementation_start_date_start=$_POST["isds"];
$implementation_start_date_end=$_POST["isde"];

$eisigisi_d=mysql_query("SELECT DISTINCT(".DB_PREFIX."registered_students.student_number), ".DB_PREFIX."registered_students.greek_first_name, ".DB_PREFIX."registered_students.greek_last_name, ".DB_PREFIX."registered_students.epoptis_melos_ep, ".DB_PREFIX."providers.provider_city, ".DB_PREFIX."providers.name, ".DB_PREFIX."providers.contact_responsible, DATE(".DB_PREFIX."positions.implementation_start_date) AS implementation_start_date, DATE(".DB_PREFIX."positions.implementation_end_date) AS implementation_end_date
FROM ".DB_PREFIX."registered_students
INNER JOIN ".DB_PREFIX."positions ON ".DB_PREFIX."positions.assigned_student_id=".DB_PREFIX."registered_students.id
INNER JOIN ".DB_PREFIX."position_groups ON ".DB_PREFIX."position_groups.id=".DB_PREFIX."positions.group_id
INNER JOIN ".DB_PREFIX."providers ON ".DB_PREFIX."providers.id=".DB_PREFIX."position_groups.provider_id
WHERE ".DB_PREFIX."positions.implementation_start_date BETWEEN '".$implementation_start_date_start."' AND '".$implementation_start_date_end."'
AND ".DB_PREFIX."registered_students.academic_id='".$academics_id."'
ORDER BY ".DB_PREFIX."positions.implementation_start_date DESC");

$statistics_html="
<table border='1'>
	<tr>
		<th>Α/Α</th>
		<th>ΑΕΜ</th>
		<th>ΟΝΟΜΑ/ΠΩΝΥΜΟ ΣΠΟΥΔΑΣΤΗ/ΣΤΡΙΑΣ</th>
		<th>ΕΠΟΠΤΗΣ ΜΕΛΟΣ ΕΠ</th>
		<th>ΠΟΛΗ ΦΟΡΕΑ</th>
		<th>ΦΟΡΕΑΣ</th>
		<th>ΕΠΟΠΤΗΣ ΦΟΡΕΑ</th>
		<th>ΗΜ.ΕΝΑΡΞΗΣ Π.Α</th>
		<th>ΗΜ.ΛΗΞΗΣ Π.Α</th>
	</tr>
";

$i=1;
while($eisigisi_i=mysql_fetch_array($eisigisi_d)) $statistics_html.="
	<tr>
		<td>".$i++."</td>
		<td>".$eisigisi_i["student_number"]."</td>
		<td>".$eisigisi_i["greek_first_name"]." ".$eisigisi_i["greek_last_name"]."</td>
		<td>".$eisigisi_i["epoptis_melos_ep"]."</td>
		<td>".$eisigisi_i["provider_city"]."</td>
		<td>".$eisigisi_i["name"]."</td>
		<td>".$eisigisi_i["contact_responsible"]."</td>
		<td>".$eisigisi_i["implementation_start_date"]."</td>
		<td>".$eisigisi_i["implementation_end_date"]."</td>
	</tr>";
$statistics_html.="</table>";

?>

<h2>Εισήγηση</h2>

<form action="#" method="post" class="niceform">
	<fieldset>
		<dl>
			<dt><label>Τμήμα:</label></dt>
			<dd><select name="aid">
				<?php
					$academics_d=mysql_query("SELECT id, department FROM ".DB_PREFIX."academics WHERE institution_id='41' ORDER BY department ASC");
					while($academics_i=mysql_fetch_array($academics_d)) echo"<option value='".$academics_i["id"]."'>".$academics_i["department"]."</option>
					";
				?>
			</select></dd>
		</dl>
		<dl>
			<dt><label>Ημερομηνία έναρξης (αρχή):</label></dt>
			<dd><input type="date" name="isds" value="<?php echo date("Y-m-d"); ?>" /></dd>
		</dl>
		<dl>
			<dt><label>Ημερομηνία έναρξης (λήξη):</label></dt>
			<dd><input type="date" name="isde" value="<?php echo date("Y-m-d"); ?>" /></dd>
		</dl>
		<dl class="submit">
			<input type="submit" name="submit" value="Επιλογή παραμέτρων" />
		</dl>
	</fieldset>
</form>

<iframe style="width: 100%; height: 500px;" srcdoc="<?php echo $statistics_html; ?>"></iframe>