$pdf->line(195, 832, 195, $YPos - 11, $style);
$pdf->line(19, $YPos + 31, 19, $YPos - 24, $style);
$pdf->line($XPos2 + 50, $YPos + 31, $XPos2 + 50, $YPos - 11, $style);
$pdf->line($XPos2 + 14, $YPos + 31, $XPos2 + 14, $YPos - 11, $style);
$pdf->line(210, $YPos + 31, 210, $YPos - 11, $style);
$pdf->line(566, $YPos + 31, 566, $YPos - 11, $style);
}
$subjects_taken_by_student = students_subjects_class($st['student_id'], $_POST['year'], $_POST['term'], $db);
if ($subjects_taken_by_student > 0) {
$subjects_count = $student_total2 / $subjects_taken_by_student;
$sql = "SELECT grade FROM reportcardgrades\n\t\tWHERE range_from <= '" . $subjects_count . "'\n\t\tAND range_to >='" . $subjects_count . "'\n\t\tAND grading LIKE 'other'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
$grade = $myrow[0];
}
$totalmarks_array = $bus_report->total_marks($st['student_id'], $_POST['year'], $_POST['term'], $db);
$LeftOvers = $pdf->addTextWrap($XPos2 - 10, $YPos + 10, 300, $FontSize, $student_total2);
$LeftOvers = $pdf->addTextWrap($XPos2 + 30, $YPos + 10, 300, $FontSize, $grade);
//$LeftOvers = $pdf->addTextWrap($XPos2+65,$YPos+10,300,$FontSize,$rank);
$grand_total = $grand_total + $student_total2;
}
$XPos3 = 212;
/*
foreach ($subjects_array as $r => $s) {
$bus_report_class= new bus_report_class($_POST['class_id'],$_POST['period_id'],$s['id'],$db);
$count=0;
$total_marks=0;
$total_marks2=0;
foreach ($bus_report_class->scheduled_students as $a => $b) {
$total_marks=total_marks_class($b['student_id'],$_POST['period_id'],$s['id'],$db);
$total_marks2=$total_marks2+$total_marks;
$totalmarks_array = $bus_report_stream->total_marks_stream($st['student_id'], $_POST['period_id'], $db);
$LeftOvers = $pdf->addTextWrap($XPos2 - 10, $YPos + 10, 300, $FontSize, number_format($st['marks'], 0));
$LeftOvers = $pdf->addTextWrap($XPos2 + 30, $YPos + 10, 300, $FontSize, $grade);
$LeftOvers = $pdf->addTextWrap($XPos2 + 65, $YPos + 10, 300, $FontSize, $st['rank']);
$grand_total = $grand_total + $st['marks'];
}
//end of scheduled students
$XPos3 = 212;
foreach ($subjects_array as $r => $s) {
$bus_report2 = new bus_report2($_POST['class_id'], $_POST['period_id'], $s['id'], $db);
$count = 0;
$total_marks = 0;
$total_marks2 = 0;
foreach ($bus_report2->scheduled_students as $a => $b) {
$bus_report = new bus_report($b['student_id'], $_POST['period_id'], $db);
$totalmarks_array = $bus_report->total_marks($s['id'], $b['student_id'], $_POST['period_id'], $b['id'], $db);
$total_marks2 = $total_marks2 + $totalmarks_array;
$count = $count + 1;
}
if ($count > 0) {
$subject_mean = $total_marks2 / $count;
} else {
$subject_mean = 0;
}
$LeftOvers = $pdf->addTextWrap($XPos3 - 1, $YPos + 1, 300, 9, $total_marks2);
$LeftOvers = $pdf->addTextWrap($XPos3, $YPos - 10, 300, 9, number_format($subject_mean, 1));
$XPos3 += 0.5 * $line_width;
}
//end of ssubjects array foreach
if ($no_of_students > 0) {
$mean_class = $grand_total / $no_of_students;
$count = $row[0];
$scheduled = new scheduled($b['subject_id'], $db);
$scheduled->set_calendar_vars($b['id'], $b['subject_id'], $myrowclass['student_id'], $_POST['period_id'], $db);
$LeftOvers = $pdf->addTextWrap(70, $YPos + 1, 300, $FontSize, $scheduled->subject_name);
$pdf->line(60, $YPos + $line_height, $Page_Width - $Right_Margin - 25, $YPos + $line_height, $style);
$status_array = tep_get_status($_POST['period_id'], $myrowclass['student_id'], $db);
$XPos2 = 200;
$YPos -= 1 * $line_height;
foreach ($scheduled->status as $y => $z) {
$i++;
$LeftOvers = $pdf->addTextWrap($XPos2 + 10, $YPos + 15, 300, $FontSize, $z['marks']);
$pdf->line($XPos2, $YPos3, $XPos2, $YPos - 16, $style);
$XPos2 += 40;
}
$cat_marks = $bus_report->average_cat_marks($b['subject_id'], $myrowclass['student_id'], $_POST['period_id'], $b['id'], $db);
$totalmarks_array = $bus_report->total_marks($b['subject_id'], $myrowclass['student_id'], $_POST['period_id'], $b['id'], $db);
$sql = "SELECT grade,comment FROM reportcardgrades\n\t\t\tWHERE range_from <= '" . $totalmarks_array . "'\n\t\t\tAND range_to >='" . $totalmarks_array . "'\n\t\t\tAND grading LIKE '" . $scheduled->grading . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
$LeftOvers = $pdf->addTextWrap($XPos2 + 10, $YPos + 15, 300, $FontSize, number_format($cat_marks, 0));
$LeftOvers = $pdf->addTextWrap($XPos2 + 40, $YPos + 15, 300, $FontSize, $totalmarks_array);
$LeftOvers = $pdf->addTextWrap($XPos2 + 62, $YPos + 15, 300, $FontSize, $myrow[0]);
$LeftOvers = $pdf->addTextWrap($XPos2 + 81, $YPos + 15, 300, $FontSize, $myrow[1]);
$totalmarks_array2 = $totalmarks_array2 + $totalmarks_array;
}
$pdf->starttransform();
$pdf->xy($XPos, 332);
$pdf->rotate(90);
$LeftOvers = $pdf->addTextWrap($XPos2 - 54, $YPos2 - 70, 300, $FontSize, _('CAT(AVG)'));
$LeftOvers = $pdf->addTextWrap($XPos2 - 54, $YPos2 - 100, 300, $FontSize, _('TOTAL(%)'));
$pdf->stoptransform();
}
echo "<td>" . _('Total(%)') . "</td>";
echo "<td>" . _('Grade') . "</td>";
echo "<td>" . _('Comment') . "</td>";
echo "</tr>";
foreach ($bus_report->scheduled_subjects as $a => $b) {
$count = $count + 1;
$scheduled = new scheduled($b['subject_id'], $db);
$scheduled->set_calendar_vars($b['id'], $db);
echo "<tr><td>" . $scheduled->subject_name . "</td>";
$status_array = tep_get_status($db);
foreach ($scheduled->status as $y => $z) {
$i++;
echo "<td>" . $z['marks'] . "</td>";
}
$totalmarks_array = $bus_report->total_marks($_POST['student_id'], $b['id'], $b['subject_id'], $db);
$sql = "SELECT title,comment FROM reportcardgrades\n\tWHERE range_from <= '" . $totalmarks_array . "'\n\tAND range_to >='" . $totalmarks_array . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
echo "<td>" . $totalmarks_array . "</td>";
echo "<td>" . $myrow[0] . "</td>";
echo "<td>" . $myrow[1] . "</td>";
$totalmarks_array2 = $totalmarks_array2 + $totalmarks_array;
}
echo "</tr><tr><td>" . _('Total Subjects') . _(' ') . $count . "</td>";
echo "<td>" . _('Total Marks') . _(' ') . $totalmarks_array2 . "</td>";
$out_of = 100 * $count;
echo "<td>" . _('Out of') . _(' ') . $out_of . "</td></tr>";
$mean_grade = $totalmarks_array2 / $count;
$sql = "SELECT title,comment FROM reportcardgrades\n\t\tWHERE range_from <= '" . $mean_grade . "'\n\t\tAND range_to >='" . $mean_grade . "'";
$result = DB_query($sql, $db);
}
echo "<td class=\"visible\">" . _('Total(%)') . "</td>";
echo "<td class=\"visible\">" . _('Points') . "</td>";
echo "<td class=\"visible\">" . _('Grade') . "</td>";
echo "</tr>";
foreach ($bus_report->scheduled_subjects as $a => $b) {
$count = $count + 1;
$scheduled = new scheduled($b['subject_id'], $db);
$scheduled->set_calendar_vars($b['id'], $db);
echo "<tr><td class=\"visible\">" . $scheduled->subject_name . "</td>";
$status_array = tep_get_status($db);
foreach ($scheduled->status as $y => $z) {
$i++;
echo "<td class=\"visible\">" . $z['marks'] . "</td>";
}
$totalmarks_array = $bus_report->total_marks($_SESSION['UserID'], $b['id'], $b['subject_id'], $db);
$sql = "SELECT title,comment FROM reportcardgrades\n\tWHERE range_from <= '" . $totalmarks_array . "'\n\tAND range_to >='" . $totalmarks_array . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
echo "<td class=\"visible\">" . $totalmarks_array . "</td>";
echo "<td class=\"visible\">" . $myrow[0] . "</td>";
echo "<td class=\"visible\">" . $myrow[1] . "</td>";
$totalmarks_array2 = $totalmarks_array2 + $totalmarks_array;
}
echo "</tr><tr><td class=\"visible\">" . _('Total Subjects') . _(' ') . $count . "</td>";
echo "<td class=\"visible\">" . _('Total Marks') . _(' ') . $totalmarks_array2 . "</td>";
$out_of = 100 * $count;
echo "<td class=\"visible\">" . _('Out of') . _(' ') . $out_of . "</td>";
$mean_grade = $totalmarks_array2 / $count;
$sql = "SELECT title,comment FROM reportcardgrades\n\t\tWHERE range_from <= '" . $mean_grade . "'\n\t\tAND range_to >='" . $mean_grade . "'";
$result = DB_query($sql, $db);
foreach ($status_array as $r => $s) {
$LeftOvers = $pdf->addTextWrap($XPos + 45, $YPos, 300, $FontSize, $s['title']);
$XPos += 1 * $line_width;
}
$YPos = 620;
$count = $count + 1;
$LeftOvers = $pdf->addTextWrap(50, $YPos, 300, $FontSize, $scheduled->subject_name);
$status_array = tep_get_status($db);
$XPos2 = 180;
$YPos -= 2 * $line_height;
foreach ($scheduled->status as $y => $z) {
$i++;
$LeftOvers = $pdf->addTextWrap($XPos2 + 25, $YPos + 25, 300, $FontSize, $z['marks']);
$XPos2 += 1 * $line_width;
}
$totalmarks_array = $bus_report->total_marks($b['id'], $b['subject_id'], $db);
$sql = "SELECT title,comment FROM reportcardgrades\n\t\tWHERE range_from <= '" . $totalmarks_array . "'\n\t\tAND range_to >='" . $totalmarks_array . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
$LeftOvers = $pdf->addTextWrap($XPos2, $YPos + 28, 300, $FontSize, $totalmarks_array);
$LeftOvers = $pdf->addTextWrap($XPos2 + 50, $YPos + 28, 300, $FontSize, $myrow[0]);
$LeftOvers = $pdf->addTextWrap($XPos2 + 100, $YPos + 28, 300, $FontSize, $myrow[1]);
$totalmarks_array2 = $totalmarks_array2 + $totalmarks_array;
$pdf->line($Left_Margin, $YPos + $line_height, $Page_Width - $Right_Margin, $YPos + $line_height);
$mean_grade = $totalmarks_array2 / $count;
$ReportCard == 2;
} elseif ($ReportCard == 2) {
$PageNumber++;
if ($PageNumber > 1) {
$pdf->newPage();
$YPos = $Page_Height - $Top_Margin;
$scheduled->set_calendar_vars($b['id'], $db);
$LeftOvers = $pdf->addTextWrap(45, $YPos, 300, $FontSize, $count);
$FontSize = 6;
$LeftOvers = $pdf->addTextWrap(70, $YPos, 300, $FontSize, $scheduled->subject_name);
$FontSize = 8;
$pdf->line($Left_Margin, $YPos + $line_height, $Page_Width - $Right_Margin, $YPos + $line_height, $style);
$status_array = tep_get_status($db);
$XPos2 = 240;
$YPos -= 1.2 * $line_height;
foreach ($scheduled->status as $y => $z) {
$i++;
$LeftOvers = $pdf->addTextWrap($XPos2 + 20, $YPos + 15, 300, $FontSize, $z['marks']);
$pdf->line($XPos2 + 10, $YPos2, $XPos2 + 10, $YPos + $line_height * 1, $style);
$XPos2 += 0.5 * $line_width;
}
$totalmarks_array = $bus_report->total_marks($myrowclass['student_id'], $b['id'], $b['subject_id'], $_POST['term'], $_POST['year'], $db);
$sql = "SELECT cs.course_code FROM courses cs\nINNER JOIN debtorsmaster dm ON dm.course_id=cs.id\nWHERE dm.debtorno= '" . $myrowclass['student_id'] . "'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
$course_code = $myrow[0];
if ($course_code == 2429) {
$sql = "SELECT title,comment FROM reportcardgrades\n\t\tWHERE range_from <= '" . $totalmarks_array . "'\n\t\tAND range_to >='" . $totalmarks_array . "'\n\t\tAND grading LIKE 'pharmacy'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
} else {
$sql = "SELECT title,comment FROM reportcardgrades\n\t\tWHERE range_from <= '" . $totalmarks_array . "'\n\t\tAND range_to >='" . $totalmarks_array . "'\n\t\tAND grading LIKE 'default'";
$result = DB_query($sql, $db);
$myrow = DB_fetch_row($result);
}
$LeftOvers = $pdf->addTextWrap($XPos2 + 30, $YPos + 15, 300, $FontSize, $totalmarks_array);
$LeftOvers = $pdf->addTextWrap($XPos2 + 70, $YPos + 15, 300, $FontSize, $myrow[0]);
