| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Old Sites/modip/infosystem_v7/application/views/ |
Upload File : |
<?php
function manage_unit_classes($id_unit, $semester) {
if($semester==NULL||!semester_data($semester)||$semester>current_semester()) $semester=current_semester();
if(!permission_exists("manage_unit_classes", $id_unit)) {
$_SESSION['error_message']="Δεν έχετε τα απαραίτητα δικαιώματα να προβάλετε αυτή τη σελίδα.";
default_page();
return;
}
$_SESSION['title']="Διδασκόμενα μαθήματα <b>".unit_id_to_name_gen($id_unit)."</b> - ".semester_id_to_text($semester);
$all_classes_d=query("SELECT co.title, co.exam, co.coursecode, cl.id, co.id as cid, cl.active
FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
WHERE co.id_unit='".$id_unit."' AND cl.semester='".$semester."'
ORDER BY cl.active DESC, co.exam, co.title");
$all_semesters_d=query("SELECT * FROM __semesters WHERE semester<=".current_semester()." ORDER BY semester DESC");
$semester_options="";
while($all_semesters_i=mysql_fetch_array($all_semesters_d)) {
$semester_options.="<option value='?action=manageunitclasses&id_unit=".$id_unit."&semester=".$all_semesters_i['semester']."'".($all_semesters_i['semester']==$semester?" selected":"").">".semester_id_to_text($all_semesters_i['semester'])."</option>
";
}
$active_classes=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
WHERE co.id_unit='".$id_unit."' AND cl.semester='".$semester."' AND cl.active=1"));
$total_assignments=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
INNER JOIN __course_assignments ca ON ca.id_class=cl.id
WHERE co.id_unit='".$id_unit."' AND cl.semester='".$semester."' AND cl.active=1"));
$class_course_sheets=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
INNER JOIN __course_assignments ca ON ca.id_class=cl.id
WHERE co.id_unit='".$id_unit."' AND cl.semester='".$semester."' AND cl.active=1 AND course_sheet=1"));
$orphan_courses=$active_classes-$class_course_sheets;
$i=1;
$_SESSION['content']="";
if($orphan_courses>0 && $semester==current_semester()) {
$_SESSION['content'].="
<div class='message-cpanel'>
<div class='message-cpanel-img'><img src='themes/".CURRENT_TEMPLATE."/images/shared/warning.png' alt='' align='top' /></div>
Δεν έχει οριστεί υπεύθυνος σε <span class='font15'><b>".$orphan_courses."</b></span> ".($orphan_courses==1 ? "μάθημα" : "μαθήματα").".
</div>";
}
$_SESSION['content'].="
<table border='0' width='100%' cellpadding='0' cellspacing='0'>
<tr>
<td width=45%>
<table border='0' width='100%' height='100px' cellpadding='0' cellspacing='0' id='custom-table'>
<tr valign='middle'>
<td class='celltint2'>Ακαδημαϊκό Εξάμηνο: </td>
<td><select class='styledselect_form_1a' onchange=\"document.location.href=this.value;\">".$semester_options."</select></td>
</tr>
<tr valign='middle'>
<td class='celltint2'>Συνολικές αναθέσεις: </td>
<td class='font14'>".$total_assignments."</td>
</tr>
</table>
</td>
<td width=10%></td>
<td width=45%>
<table border='0' width='100%' height='100px' cellpadding='0' cellspacing='0' id='custom-table'>
<tr valign='middle'>
<td class='celltint2'>Ενεργά μαθήματα: </td>
<td class='font14'>".$active_classes."</td>
</tr>
<tr valign='middle'>
<td class='celltint2'>Υπεύθυνοι μαθημάτων: </td>
<td class='font14'>".$class_course_sheets.($orphan_courses==0 ? " <a title='Έχουν οριστεί υπεύθυνοι για<br />όλα τα ενεργά μαθήματα' class='info-tooltip'><img src='themes/".CURRENT_TEMPLATE."/images/forms/valid_icon.png' alt='' align='top' /></a>" : "")."</td>
</tr>
</table>
</td>
</tr>
</table>
<table border='0' width='100%' cellpadding='0' cellspacing='0' id='product-table'>
<thead>
<tr class='header'>
<th class='table-header'>Α/Α</th>
<th class='table-header'><a title='Τίτλος Μαθήματος<br />(σύμφωνα με το egram)' class='info-tooltip'>Τίτλος Μαθήματος</a></th>
<th class='table-header'><a title='Τυπικό Εξάμηνο Διδασκαλίας' class='info-tooltip'>Εξ.</a></th>
<th class='table-header'><a title='Κωδικός Μαθήματος<br />(σύμφωνα με το egram)' class='info-tooltip'>Κωδ.</a></th>
<th class='table-header'><a title='Υπεύθυνος Μαθήματος<br />(συμπληρώνει το Α.Δ. Μαθήματος)' class='info-tooltip'>Υπεύθυνος</a></th>
<th class='table-header'>Λοιποί διδάσκοντες</th>
<th class='table-header'><a title='Εργαλεία και ρυθμίσεις μαθημάτων' class='info-tooltip'>Εργ.</a></th>
</tr>
</thead>
<tbody>
";
if(mysql_num_rows($all_classes_d)==0) $_SESSION['content'].="<tr><td colspan=7>Δεν υπάρχουν διαθέσιμα μαθήματα για το τρέχον εξάμηνο</td></tr>";
else while($all_classes_i=mysql_fetch_array($all_classes_d)) {
$_SESSION['content'].=
($all_classes_i['active']==0?"<tr style='color:#bbbbbb;'>":"<tr>")."
<td style='font-size:10px;' align='center'>".$i."</td>
<td>".($all_classes_i['active']==0 ? "<div style='display:none;'>z</div><a title='Απενεργοποιημένο Μάθημα' class='info-tooltip'><img src='themes/".CURRENT_TEMPLATE."/images/shared/nav/blocked.png' align='top' /></a> ":"<div style='display:none;'>a</div>").$all_classes_i['title']."</td>
<td align='center'><span style='font-size:10px;'>".return_semester($all_classes_i['exam'])."</span></td>
<td align='center'><span style='font-size:11px; font-weight:bold; cursor:default;'><a title='Κωδικός τάξης: ".$all_classes_i['id']."' class='info-tooltip' ".($all_classes_i['active']==0 ? "style='color:#bbbbbb!important;'" : "").">".$all_classes_i['coursecode']."</a></span></td>
<td>".($all_classes_i['active']==0 ? "<div style='display:none;'>z</div>":"<div style='display:none;'>a</div>");
$user_head_i=mysql_fetch_array(query("SELECT u.id, u.first_name, u.last_name, ca.teaches
FROM __users u
INNER JOIN __relations r ON u.id=r.id_user
INNER JOIN __course_assignments ca ON ca.relation_chain=r.relation_chain
WHERE ca.id_class='".$all_classes_i['id']."'
AND ca.course_sheet=1"));
if($user_head_i['id']!=NULL) {
$_SESSION['content'].=($user_head_i['teaches']
? "<a title='Προβολή στοιχείων χρήστη ".$user_head_i['last_name']." ".$user_head_i['first_name']." σε νέο παράθυρο' class='info-tooltip' target='_blank' href='?action=viewuser&userid=".$user_head_i['id']."'>".$user_head_i['last_name']." ".$user_head_i['first_name']
: "<a title='ΔΕΝ ΔΙΔΑΣΚΕΙ ΤΟ ΜΑΘΗΜΑ - Προβολή στοιχείων χρήστη ".$user_head_i['last_name']." ".$user_head_i['first_name']." σε νέο παράθυρο' class='info-tooltip' target='_blank' href='?action=viewuser&userid=".$user_head_i['id']."'><span style='color:#aa0000;'>".$user_head_i['last_name']." ".$user_head_i['first_name']."</span>")."</a>";
}
else {
$_SESSION['content'].=($all_classes_i['active']==0 ? "-" : "<img src='themes/".CURRENT_TEMPLATE."/images/shared/status-yellow.png' align='top' /> <span class='text-yellow'>χωρίς υπεύθυνο</span>");
}
$_SESSION['content'].="</td>
<td>";
$user_tail_d=query("SELECT u.id, u.first_name, u.last_name, ca.teaches
FROM __users u
INNER JOIN __relations r ON u.id=r.id_user
INNER JOIN __course_assignments ca ON ca.relation_chain=r.relation_chain
WHERE ca.id_class='".$all_classes_i['id']."'
AND ca.course_sheet=0");
if(mysql_num_rows($user_tail_d)==0) {
$_SESSION['content'].="-";
}
else while($user_tail_i=mysql_fetch_array($user_tail_d)) {
$_SESSION['content'].="<a title='Προβολή στοιχείων χρήστη ".$user_tail_i['last_name']." ".$user_tail_i['first_name']." σε νέο παράθυρο' class='info-tooltip' target='_blank' href='?action=viewuser&userid=".$user_tail_i['id']."'>".$user_tail_i['last_name']." ".$user_tail_i['first_name']."</a>".(mysql_num_rows($user_tail_d)==1 ? "" : "<br />");
}
$_SESSION['content'].="</td>
<td align='center'>
<a style='cursor:pointer;' title='Επιλογές μαθήματος - ".$all_classes_i['title']."' class='info-tooltip'
onclick=\"$.msgbox('<div class=\'coursetitle\'><b>".$all_classes_i['title']."</b> (".$all_classes_i['coursecode'].")</div>".(current_semester()==$semester ? "<a href=\'?action=activatedeactivateclass&id=".$all_classes_i['id']."\' class=\'img-link\'><img class=\'cp-img\' src=\'themes/".CURRENT_TEMPLATE."/images/msgbox/".($all_classes_i['active']==1 ? "deactivate.png" : "activate.png")."\'/></a>" : "")."<a href=\'?action=viewcoursegrades&id=".$all_classes_i['cid']."&semester=".$semester."\' class=\'img-link\'><img class=\'cp-img\' src=\'themes/".CURRENT_TEMPLATE."/images/msgbox/grades.png\'/></a><a href=\'?action=coursesheets&course=".$all_classes_i['cid']."\' class=\'img-link\'><img class=\'cp-img\' src=\'themes/".CURRENT_TEMPLATE."/images/msgbox/course-sheets.png\' style=\'display:none\' /></a>', {type: 'toolbox'}); \" >
<img width=18 height=18 src='themes/".CURRENT_TEMPLATE."/images/ico/Light_Pools.png' />
</a>
</td>
".($all_classes_i['active']==0?"":"").
"</tr>";
$i++;
}
//TABLE SORTABLE
$_SESSION['content'].="</tbody></table>
<script>
$(document).ready(function() {
oTable = $('#product-table').dataTable({
'bJQueryUI': true,
'bPaginate': false,
'oLanguage': {
'sUrl': 'js/classes.txt'
},
'bStateSave': false,
'aoColumns': [
{'bSortable': true},
{'bSortable': true},
{'bSortable': true},
{'bSortable': true},
{'bSortable': true},
{'bSortable': false},
{'bSortable': false}
]
});
});
</script>
";
}
function view_course_grades($id_course, $semester) {
if($semester==NULL||!semester_data($semester)||$semester>current_semester()) $semester=current_semester();
if(!permission_exists("view_course_grades", $id_course)) {
$_SESSION['error_message']="Δεν έχετε τα απαραίτητα δικαιώματα να προβάλετε αυτή τη σελίδα.";
default_page();
return;
}
$course_data_i=mysql_fetch_array(query("SELECT c.id_unit, c.title, c.exam, u.name, u.name_gen FROM __courses as c INNER JOIN __units as u ON c.id_unit=u.id WHERE c.id='".$id_course ."'"));
$_SESSION['title']="Κατανομή βαθμολογίας μαθήματος <b>".$course_data_i['title']."</b>";
$_SESSION['content']="
<table border='0' width='100%' cellpadding='0' cellspacing='0' id='custom-table'>
<tr valign='middle'>
<td class='celltint2'>Μάθημα: </td>
<td ><b>".$course_data_i['title']."</b> - ".$course_data_i['name']."</td>
</tr>
<tr valign='middle'>
<td class='celltint2'>Τυπικό εξάμηνο: </td>
<td >".return_semester($course_data_i['exam'])."
</td>
</tr>
<tr valign='middle'>
<td class='celltint2'>Τελευταία ενημέρωση στοιχείων: </td>
<td >"."<i>Δευτέρα 26 Μαρτίου 2012</i>"."</td>
</tr>
</table>
<br />
<table border='0' width='100%' cellpadding='0' cellspacing='0' id='product-table'>
<tr class='header'>
<td align='center' rowspan='2'>Εξάμηνο</td>
<td colspan='12' align='center'>Κατανομή Βαθμών : % συμμετοχών <div class='sciworknum2'>πλήθος συμμετοχών</div> </td>
<td align='center' rowspan='2'>Σύνολο Δηλώσεων <span class='font10'>Εγγεγραμμένοι</span></td>
<td align='center' rowspan='2'>Σύνολο Συμμετοχών</td>
<td align='center' rowspan='2'>Πέρασαν</td>
<td align='center' rowspan='2'>Μέσος όρος Βαθμολογίας</td>
</tr>
<tr align='center' class='celltint'>
<td colspan='2'>0 - 3,9</td>
<td colspan='2'>4 - 4,9</td>
<td colspan='2'>5 - 5,9</td>
<td colspan='2'>6 - 6,9</td>
<td colspan='2'>7 - 8,4</td>
<td colspan='2'>8,5 - 10</td>
</tr>";
//if($semester%2==1) $start_year=(2000+substr($semester,0,-1))-1;
//else $start_year=(2000+substr($semester,0,-1));
$start_year=(2000+substr($semester,0,-1));
//αύξουσα σειρά για το γράφημα
for($ref_year=$start_year-4;$ref_year<=$start_year;$ref_year++) {
for($period=1; $period<=2; $period++) {
}
}
//φθίνουσα σειρά για τον πίνακα
for($ref_year=$start_year;$ref_year>$start_year-5;$ref_year--) {
for($period=2; $period>0; $period--) {
//if( (substr($ref_year,-2).$period)!=current_semester()){
if( (substr($ref_year,-2).$period)<current_semester()){
$grade_results=query("SELECT year, period, dist39, dist49, dist59, dist69, dist84, dist100, avg, registered FROM __course_grades WHERE id_course='".$id_course ."' AND year='".$ref_year."' AND period='".$period."'");
$grade_data=mysql_fetch_array($grade_results);
$sumgrades=$grade_data['dist39']+$grade_data['dist49']+$grade_data['dist59']+$grade_data['dist69']+$grade_data['dist84']+$grade_data['dist100'];
$success=$grade_data['dist59']+$grade_data['dist69']+$grade_data['dist84']+$grade_data['dist100'];
$graph_categories=($period==1 ? "'Χειμερινό " : "'Εαρινό ").$ref_year."-".($ref_year+1)."', ".$graph_categories;
$graph_avg=(10*$grade_data['avg']).", ".$graph_avg;
$graph_success=number_format(100*$success/$sumgrades,1).", ".$graph_success;
$graph_dist39=number_format(100*$grade_data['dist39']/$sumgrades,1).", ".$graph_dist39;
$graph_dist49=number_format(100*$grade_data['dist49']/$sumgrades,1).", ".$graph_dist49;
$graph_dist59=number_format(100*$grade_data['dist59']/$sumgrades,1).", ".$graph_dist59;
$graph_dist69=number_format(100*$grade_data['dist69']/$sumgrades,1).", ".$graph_dist69;
$graph_dist84=number_format(100*$grade_data['dist84']/$sumgrades,1).", ".$graph_dist84;
$graph_dist100=number_format(100*$grade_data['dist100']/$sumgrades,1).", ".$graph_dist100;
if(mysql_num_rows($grade_results)==0) {
$_SESSION['content'].="<tr align='center'>
<td class='celltint'><span class='font11'>";
if($period==1) $_SESSION['content'].="Χειμερινό<br />";
if($period==2) $_SESSION['content'].="Εαρινό<br />";
$_SESSION['content'].=$ref_year."-".($ref_year+1)."</span></td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td><td class='celltint'>-</td>
<td class='celnormal'>-</td>
<td class='celltint'><div class='sciworknum3'>-</div></td>
<td class='celnormal'>-</td>
<td class='celltint'>-</td>
</tr>";
continue;
}
$_SESSION['content'].="<tr align='center'>
<td class='celltint'><span class='font11'>";
if($period==1) $_SESSION['content'].="Χειμερινό<br />";
if($period==2) $_SESSION['content'].="Εαρινό<br />";
$_SESSION['content'].=$ref_year."-".($ref_year+1)."</span></td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist39']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist39']."</td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist49']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist49']."</td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist59']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist59']."</td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist69']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist69']."</td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist84']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist84']."</td>
<td class='celnormal font11'>".number_format(100*$grade_data['dist100']/$sumgrades,1)."%</td><td class='celltint'>".$grade_data['dist100']."</td>
<td class='celnormal'>".$grade_data['registered']."</td>
<td class='celltint'><div class='sciworknum3'>".$sumgrades."</div></td>
<td class='celnormal'>".$success."<br /><span class='font11'>(".number_format(100*$success/$sumgrades,1)."%)</span></td>
<td class='celltint'>".(10*$grade_data['avg'])."</td>
</tr>";
}
}
}
$_SESSION['content'].="
</table>
<br />
<span class='description'>
<b>Σημείωση:</b>
Τα δεδομένα του πίνακα προκύπτουν σύμφωνα με τις βαθμολογίες που έχουν υποβληθεί τα 5 τελευταία ακαδημαϊκά έτη μέχρι και την ημερομηνία τελευταίας ενημέρωσης.
Η κατανομή της βαθμολογίας υπολογίζεται με βάση τη ΣΥΜΜΕΤΟΧΗ των σπουδαστών στις εξετάσεις.
Κάθε εξάμηνο περιλαμβάνει την κανονική και την επαναληπτική εξεταστική περίοδο.
</span>
<br />
<br />
<br />
<div id='tabs'>
<ul>
<li><a href='#graph1'><span>Γράφημα Κατανομής Βαθμολογίας</span></a></li>
<li><a href='#graph2'><span>Γράφημα Επιτυχόντων και Μ.Ο.</span></a></li>
</ul>
<div id='graph1'>
<script type='text/javascript'>
var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'container1',
zoomType: 'y',
defaultSeriesType: 'column'
},
title: {
text: '".$course_data_i['title']."'
},
subtitle: {
text: '".$course_data_i['name']."<br />Κατανομή βαθμολογίας μαθήματος τελευταίας 5ετίας'
},
xAxis: [{
categories: [".$graph_categories."]
}],
yAxis: {
labels: {
formatter: function() {
return this.value +'%';
}
},
min: 0,
max:100,
tickInterval: 10,
title: {
text: 'Κατανομή βαθμολογίας'
}
},
credits: {
enabled: false
},
plotOptions: {
column: {
stacking: 'normal',
pointPadding: 0.05,
borderWidth: 0,
shadow: false
}
},
tooltip: {
formatter: function() {
return this.x+'<br />'+
'<span style=\"color:'+this.series.color+'\">'+this.series.name +'</span>: <b>'+ this.y+'</b>%';
},
crosshairs: true
},
legend: {
layout: 'horizontal',
align: 'center',
verticalAlign: 'bottom',
floating: false,
backgroundColor: '#FFFFFF'
},
series: [{
name: '0 - 3,9',
data: [".$graph_dist39."],
color: '#AA4643',
stack: 'under'
},{
name: '4 - 4,9',
data: [".$graph_dist49."],
color: '#DB843D',
stack: 'under'
},{
name: '5 - 5,9',
data: [".$graph_dist59."],
color: '#9982B4',
stack: 'over'
},{
name: '6 - 6,9',
data: [".$graph_dist69."],
color: '#4572A7',
stack: 'over'
},{
name: '7 - 8,4',
data: [".$graph_dist84."],
color: '#3D96AE',
stack: 'over'
},{
name: '8,5 - 10',
data: [".$graph_dist100."],
color: '#89A54E',
stack: 'over'
}]
});
});
</script>
<div id='container1' style='width: 99%; height: 500px; margin: 0 auto'></div>
</div>
<div id='graph2'>
<script type='text/javascript'>
var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'container2'
},
title: {
text: '".$course_data_i['title']."'
},
subtitle: {
text: '".$course_data_i['name']."<br />Μ.Ο. βαθμολογίας και ποσοστό επιτυχόντων μαθήματος τελευταίας 5ετίας'
},
xAxis: [{
categories: [".$graph_categories."]
}],
yAxis: [{ // Primary yAxis
labels: {
formatter: function() {
return this.value +'%';
},
style: {
color: '#4572A7'
}
},
title: {
text: 'Ποσοστό Επιτυχόντων',
style: {
color: '#4572A7'
}
},
max: 100,
min: 0,
tickInterval: 10
}, { // Secondary yAxis
title: {
text: 'Μ.Ο. Βαθμολογίας',
style: {
color: '#89A54E'
}
},
labels: {
formatter: function() {
return this.value;
},
style: {
color: '#89A54E'
}
},
opposite: true,
max: 10,
min: 0,
tickInterval: 1
}],
credits: {
enabled: false
},
tooltip: {
formatter: function() {
var s = this.x+'<br />';
$.each(this.points, function(i, point) {
s += '<span style=\"color:'+point.series.color+'\">'+point.series.name +'</span>: <b>'+ point.y+(this.series.name == 'Ποσοστό Επιτυχόντων' ? '%' : '')+'</b><br />';
});
return s;
},
shared: true,
crosshairs: true
},
legend: {
layout: 'vertical',
align: 'right',
x: -60,
verticalAlign: 'bottom',
y: -50,
floating: true,
backgroundColor: '#FFFFFF'
},
series: [{
name: 'Ποσοστό Επιτυχόντων',
color: '#4572A7',
type: 'column',
shadow: false,
yAxis: 0,
data: [".$graph_success."]
},{
name: 'Μ.Ο. Βαθμολογίας',
color: '#89A54E',
type: 'spline',
shadow: false,
yAxis: 1,
data: [".$graph_avg."]
}]
});
});
</script>
<div id='container2' style='width: 99%; height: 500px; margin: 0 auto'></div>
</div>
</div>
<script>
$(function() {
$( '#tabs' ).tabs({
cookie: {
// store cookie for a day, without, it would be a session cookie
expires: 1
}
});
});
</script>
<br />
<br />
<div align='center'><input type='button' value='Επιστροφή' class='form-reset' onclick=\"location.href='?action=manageunitclasses&id_unit=".$course_data_i['id_unit']."&semester=".$semester."'\" /></div>
";
}
function manage_unit_classes2($id_unit, $semester) {
if($semester==NULL||!semester_data($semester)||$semester>current_semester()) $semester=current_semester();
$_SESSION['title']="Διδασκόμενα μαθήματα <b>".unit_id_to_name_gen($id_unit)."</b> - ".semester_id_to_text($semester);
$all_classes_d=query("SELECT co.title, co.exam, co.coursecode, cl.id, co.id as cid, cl.active
FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
WHERE cl.semester='".$semester."'
ORDER BY cl.active DESC, co.exam, co.title");
$active_classes=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
WHERE cl.semester='".$semester."' AND cl.active=1"));
$total_assignments=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
INNER JOIN __course_assignments ca ON ca.id_class=cl.id
WHERE cl.semester='".$semester."' AND cl.active=1"));
$class_course_sheets=mysql_num_rows(query("SELECT * FROM __courses co
INNER JOIN __classes cl ON co.id=cl.id_course
INNER JOIN __course_assignments ca ON ca.id_class=cl.id
WHERE cl.semester='".$semester."' AND cl.active=1 AND course_sheet=1"));
$i=1;
$_SESSION['content']="";
while($all_classes_i=mysql_fetch_array($all_classes_d)) {
$user_head_i=mysql_fetch_array(query("SELECT u.id, u.first_name, u.last_name, u.email, ca.teaches
FROM __users u
INNER JOIN __relations r ON u.id=r.id_user
INNER JOIN __course_assignments ca ON ca.relation_chain=r.relation_chain
WHERE ca.id_class='".$all_classes_i['id']."'
AND ca.course_sheet=1"));
$_SESSION['content'].=$user_head_i['email']."<br>";
$user_tail_d=query("SELECT u.id, u.first_name, u.last_name, u.email, ca.teaches
FROM __users u
INNER JOIN __relations r ON u.id=r.id_user
INNER JOIN __course_assignments ca ON ca.relation_chain=r.relation_chain
WHERE ca.id_class='".$all_classes_i['id']."'
AND ca.course_sheet=0");
while($user_tail_i=mysql_fetch_array($user_tail_d)) $_SESSION['content'].=$user_tail_i['email']."<br>";
}
}
?>