$pdf->Cell($catw, $cath, $cat, 0, 2, 'C', 1);
$pdf->Cell($catw, $cath, $weight . "%", 0, 0, 'C', 1);
$x_coord += $catw;
$pdf->SetXY($x_coord, $y_coord);
}
/** Overall Average **/
$pdf->Cell($overallavw, 2 * $cath, 'Overall Avg.', 0, 1, 'C', 1);
$x_coord = $lm;
$y_coord += 2 * $cath;
$pdf->SetXY($x_coord, $y_coord);
$pdf->SetFillColor(255, 255, 255);
$pdf->SetTextColor(0, 0, 0);
$rcv = 0;
/** used for row shading **/
/** get the list of students in this class **/
$students = get_students_for_class($class_id);
$reports = getReportForStudent("all", $tid, $class_id);
/** Loop for each student in this class **/
foreach ($reports as $sid => $report) {
$rcv++;
if ($rcv % 2) {
$pdf->SetFillColor(255, 255, 255);
} else {
$pdf->SetFillColor(238, 238, 238);
}
/** Now for the calculations. Remember to deal with no assigns in a category... **/
$pdf->Cell($studentw, $cath, $students[$sid], 0, 0, 'L', 1);
$x_coord += $studentw;
foreach ($cat_names_array as $cat => $weight) {
$pdf->Cell($catw, $cath, $report['summary'][$cat]['value'], 0, 0, 'C', 1);
$x_coord += $catw;
<?php
define('FPDF_FONTPATH', 'fpdf_fonts/');
require 'fpdf.php';
include '_includeSessionConfig.php';
$loginError = check_auth($_SESSION[$_CONF['sess_name'] . '_username'], $_SESSION[$_CONF['sess_name'] . '_password']);
if (!$loginError['error_value']) {
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
$los = array();
/** used to hold the list of students to print report for **/
$sid = -1;
$download = false;
if (isset($_POST['all'])) {
$sid = 'all';
$los = get_students_for_class($cid);
$download = true;
} else {
$sid = $_SESSION[$_CONF['sess_name'] . '_selected_student'];
$sql = "SELECT first_name, last_name from users where user_id=" . $sid;
$result = $db->query($sql);
$row = $result->fetch_assoc();
$studentName = $row['first_name'] . " " . $row['last_name'];
$los[$sid] = $studentName;
$download = false;
}
include 'newProgressReports.php';
$cid = $_SESSION[$_CONF['sess_name'] . '_selected_class'];
//$sid = $_SESSION[$_CONF['sess_name'].'_selected_student'];
$tid = $_SESSION[$_CONF['sess_name'] . '_myUID'];
$reports = getReportForStudent($sid, $tid, $cid);
//$reports = $reportsResults;
$val['comment'] = $row1['comment'];
$grade_array[$key] = $val;
}
}
/** Now get any locked grades for this class **/
$sql = "SELECT * from lockedGrades where class_id=" . $classID;
$result = $db->query($sql);
$lockedGradesArray = array();
if ($result) {
while ($row = $result->fetch_assoc()) {
$lockedGradesArray[$row['student_id']] = $row['lockedGrade'];
}
}
/** get the list of students in this class and the list of assignments for this class **/
/** get_students_for_class($classID) returns id=>First_Last **/
$studList = get_students_for_class($classID);
/** assignments.due_date asc, assignments.assignment_name"; **/
$sql2 = "SELECT assignments.assignment_id, assignments.assignment_name, assignments.due_date,\n assignments.max_score, assignment_note, categories.category_name\n\t\t\t\tFROM categories, assignments\n\t\t\t\tWHERE assignments.category_id=categories.category_id AND categories.class_id=" . $classID . "\n ORDER by " . $order_by . ",assignment_name";
$result2 = $db->query($sql2);
$numAssigns = $result2->num_rows;
$colSpan = $numAssigns + 1;
$assign_array = array();
/**
* Now build the table (Gradebook)
*/
if ($numAssigns != 0) {
$left = "\n\t\t\t\t<table class=\"grade_book\" border=0 cellspacing=1 cellpadding=3 bgcolor=black id=\"gradeTable\">\n\t\t\t\t<thead>\n\t\t\t\t <tr valign=middle align=center class=\"gradeBookAssignmentHead\">\n\t\t\t\t\t<td>\n <b><span style=white-space:nowrap>" . $className . "</span><br />\n <span style=white-space:nowrap>" . $termName . "</span></b>\n\t\t\t\t\t</td>\n <td width=20px;><img src=\"make_assigns.php?a=Lock Grade&d=N/A&c=N/A&t=n&l=red\" alt=\"\" border=0 /></td>\n\t\t\t\t </tr>\n\t\t\t\t <tr align=right class=\"gradeBookStudentHead\">\n <td><b>Max Score</b></td>\n <td width=20px; style=\"text-align:center;color:red;\"><span>100</span></td>\n\t\t\t\t </tr>\n\t\t\t\t</thead>";
$right = "\n\t\t\t\t<table class=\"grade_book\" border=0 cellspacing=1 cellpadding=3 bgcolor=black id=\"gradeTable\">\n\t\t\t\t<thead>\n\t\t\t\t <tr class=\"gradeBookAssignmentHead\">";
$assign_count = 1;
while ($row2 = $result2->fetch_assoc()) {
$assign_array[$assign_count] = $row2['assignment_id'];
if ($classID != -1 || isset($_POST['update_s2c'])) {
$t = "Class Roster";
$b = "<font color=red><center>If you remove a student here and he/she has grades in the database for this class, the grades are removed also.</center></font>";
$b .= "\n\t\t<br />\n\t\t<center>\n\t\t<TABLE width=350 border=0 cellspacing=0 cellpadding=2 bgcolor=white>\n\t\t<tr><th colspan=2>Schedule Students</th></tr>";
// get class name, term_name...
$sql = "SELECT course_name, term_name\n\t\t\t\tFROM classes, terms, courses\n\t\t\t\tWHERE class_id=" . $classID . "\n\t\t\t\t\tAND courses.course_id=classes.course_id\n\t\t\t\t\tAND terms.term_id=classes.term_id";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$className = $row['course_name'] . " : " . $row['term_name'];
$b .= $hiddenTerm . "\n\t\t<tr><th colspan=2>Scheduling Class : " . $className . "</th></tr>";
/** display the list of students... **/
$students = get_users_for_center($_SESSION[$_CONF['sess_name'] . '_myCenter'], 'isStudent', 'Y', "users.last_name, users.first_name");
$studentList = make_selection_list($students, -1, 'student_id', 'studentList', 'Student', "off");
/** need to get students that ONLY go to my school **/
$b .= "\n\t\t<tr>\n\t\t\t<td bgcolor=white align=center>\n\t\t\t\t<form action=\"\" id=studentListForm name=studentListForm method=post>" . $studentList . "\n\t\t\t</td>\n\t\t\t<td>\n\t\t\t\t<input id=addToRoster type=submit class=submit name=addToRoster value=Add />\n\t\t\t\t<input type=hidden name=class_id id=class_id value=" . $classID . " />\n\t\t\t\t</form>\n\t\t\t</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td colspan=2 bgcolor=white align=center>\n\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . " name=studentList method=post>\n\t\t\t\t<input id=copyFrom type=submit class=submit name=copy_from value=\"Copy From Another Class\" />\n\t\t\t\t</form>\n\t\t\t</td>\n\t\t</tr>\n\t\t</form>\n\t\t</table>";
/**
now for the new way of adding/removing students. Use a selection list with "Add" button
Then use checkboxes next to names and a remove button. Keep the copy from
**/
$registered = get_students_for_class($classID);
$b .= "\n\t\t<div id=enrolledStudentsDiv><h2>Current Enrollment</h2>\n\t\t<form id=enrolledStudentsForm name=enrolledStudentsForm action=\"\" method=post>\n\t\t<table id=\"enrollmentTable\" background=white cellspacing=1 cellpadding=3>\n\t\t<thead><tr><th colspan=2></th></tr></thead>\n\t\t<tbody id=\"enrollmentTableBody\">";
foreach ($registered as $id => $name) {
$b .= "\n\t\t\t<tr><td><input type=checkbox id=s_" . $id . " name=s_" . $id . " class=studentCheckbox></td><td>" . $name . "</td></tr>";
}
$b .= "\n\t\t</tbody>\n\t\t<tfoot>\n\t\t<tr>\n\t\t\t<td colspan=2>\n\t\t\t\t<input type=submit id=removeFromRoster name=removeFromRoster value=Remove />\n\t\t\t\t<input type=hidden name=class_id id=class_id value=" . $classID . " />\n\t\t\t</td>\n\t\t</tr>\n\t\t</tfoot>\n\t\t</table>\n\t\t</form>\n\t\t</div>\n\t\t";
$b .= "\n\t\t</center>";
$main .= make_box($t, $b);
}
} else {
$main .= login_error();
}
