$pdf->line($XPos2 + 2, $YPos3, $XPos2 + 2, $YPos - 16, $style); $pdf->line($XPos2 + 80, $YPos3, $XPos2 + 80, $YPos - 16, $style); $pdf->starttransform(); $pdf->xy($XPos, 332); $pdf->rotate(90); $LeftOvers = $pdf->addTextWrap($XPos2 - 54, $YPos2 - 124, 300, $FontSize, _('Grade')); $pdf->stoptransform(); $pdf->line($XPos2 + 30, $YPos3, $XPos2 + 30, $YPos - 16, $style); $LeftOvers = $pdf->addTextWrap($XPos2 + 85, $YPos2 - 40, 300, $FontSize, _('Remarks')); $pdf->line($XPos2 + 60, $YPos3, $XPos2 + 60, $YPos - 16, $style); $pdf->line(60, $YPos3, 60, $YPos - 16, $style); $pdf->line(540, $YPos3, 540, $YPos - 16, $style); $pdf->line(60, $YPos + $line_height + 1, $Page_Width - $Right_Margin - 25, $YPos + $line_height + 1, $style); $XPos3 = 220; foreach ($status_array as $r => $s) { $total_marks = mode_marks($myrowclass['student_id'], $_POST['period_id'], $s['id'], $db); $position = get_student_position($myrowclass['student_id'], $_POST['period_id'], $s['id'], $db); $LeftOvers = $pdf->addTextWrap($XPos3 - 10, $YPos + 1, 300, $FontSize, $total_marks); $LeftOvers = $pdf->addTextWrap($XPos3 - 10, $YPos - 15, 300, $FontSize, number_format($position, 0)); $XPos3 += 40; } //end of ssubjects array foreach $LeftOvers = $pdf->addTextWrap(70, $YPos + 1, 300, $FontSize, _('Total')); $pdf->line(60, $YPos - 3, $Page_Width - $Right_Margin - 25, $YPos - 3, $style); $LeftOvers = $pdf->addTextWrap(70, $YPos - 13, 300, $FontSize, _('Class Position')); $pdf->line(60, $YPos - 16, $Page_Width - $Right_Margin - 25, $YPos - 16, $style); $LeftOvers = $pdf->addTextWrap($XPos3 + 45, $YPos + 1, 300, $FontSize, number_format($marks, 0)); $LeftOvers = $pdf->addTextWrap($XPos3 + 15, $YPos - 15, 300, $FontSize, $class_rank); $YPos -= 2 * $line_height; $LeftOvers = $pdf->addTextWrap(40, $YPos - 10, 300, $FontSize, _('Total Subjects') . ' :' . $count); $LeftOvers = $pdf->addTextWrap(150, $YPos - 10, 300, $FontSize, _('Total Points') . ' :' . number_format($marks, 0));
$rank_ties2 = 0; } $stude2 = $myrowrank2['student_id']; $sqlgenerate2 = "UPDATE exam_ranks\n\t\t\t\tSET rank='" . $ranked2 . "'\n\t\t\t\tWHERE student_id='" . $stude2 . "'\n\t\t\t\tAND period_id='" . $_POST['period_id'] . "'\n\t\t\t\tAND class_id='" . $myrowclass['id'] . "'\n\t\t\t\tAND exam_id='" . $myrow['id'] . "'"; $generate2 = DB_query($sqlgenerate2, $db); $previous_marks2 = $myrowrank2['mean']; } } } // end of if($stud_array>0) } //end of foreach($exams as $exms=>$ex) } else { foreach ($exams as $exms => $ex) { $exam_rank = 0; $stud_array = mode_marks($myrowclass['id'], $_POST['period_id'], $ex['id'], $db); if ($stud_array > 0) { foreach ($stud_array as $studs => $stds) { $subjects_taken_by_student = 0; $total_per_exam_marks = 0; $subject_points_per_exam = 0; $sqlsub = "select sm.actual_marks,sub.department_id from subjects sub INNER JOIN studentsmarks sm ON\n\t\t\t sm.subject_id=sub.id\n\t\t\tWHERE sm.student_id='" . $stds['id'] . "'\n\t\t\tAND sm.period_id='" . $_POST['period_id'] . "'\n\t\t\tAND sm.exam_mode='" . $ex['id'] . "'"; $resultsub = DB_query($sqlsub, $db); while ($rowsub = DB_fetch_array($resultsub)) { $subjects_taken_by_student = $subjects_taken_by_student + 1; $total_per_exam_marks = $total_per_exam_marks + $rowsub['actual_marks']; if ($rowsub['department_id'] == 1) { $sqlmean = "SELECT title FROM reportcardgrades\n\t\t\t\t\t\tWHERE range_from <= '" . $rowsub['actual_marks'] . "'\n\t\t\t\t\t\tAND range_to >='" . $rowsub['actual_marks'] . "'\n\t\t\t\t\t\tAND grading LIKE 'MATHS'"; $resultmean = DB_query($sqlmean, $db); $myrowmean = DB_fetch_row($resultmean); $points = $myrowmean[0];