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