$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]);