/**
* Display a listing of the resource.
* @return Response
*/
public function index()
{
if ($terms = Cache::get('student_' . $this->student->id . '_api_grades')) {
return response(['grades' => $terms, 'gpas' => $this->calculateGpa($terms)], 200, [], JSON_NUMERIC_CHECK);
}
$terms = get_student_grades($this->student->id);
Cache::put('student_' . $this->student->id . '_api_terms', $terms, 600);
return response(['grades' => $terms, 'gpas' => $this->calculateGpa($terms)], 200, [], JSON_NUMERIC_CHECK);
}
public function record($student_id, Request $request)
{
if (!$student_id) {
return redirect()->rotue('students.students.index');
}
$terms = get_student_grades($student_id);
$student = Student::findOrFail($student_id);
if ($request->has('partial')) {
return view('students::grades._record_list', compact('terms', 'student'));
}
return view('students::grades.record', compact('terms', 'student'));
}
$info[$MAX] = 0;
$USER = $row['category_name'] . "_user_points";
$info[$USER] = 0;
$WEIGHT = $row['category_name'] . "_weight";
$info[$WEIGHT] = $row['category_weight'];
$COUNT = $row['category_name'] . "_count";
$info[$COUNT] = 0;
$AVG = $row['category_name'] . "_avg";
$info[$AVG] = 0;
$POSSIBLE = $row['category_name'] . "_possible";
$info[$POSSIBLE] = 0;
$WTD_AVG = $row['category_name'] . "_weighted_avg_sum";
$info[$WTD_AVG] = 0;
}
}
$result = get_student_grades($sid, $class_id);
$assigns = array();
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
array_push(${$row['category_name']}, $row);
array_push($assigns, $row);
}
$rcv = 0;
/** used for row shading **/
$total_cat_weights = 0;
foreach ($assigns as $grade) {
$cat = $grade['category_name'];
if ($grade['raw_score'] != "") {
/** Weighted average **/
$info[$cat . "_weighted_avg_sum"] += round($grade['raw_score'] / $grade['max_score'] * 100 * $grade['assignment_weight'], 1);
/** Assignment Weights **/
$info[$WEIGHT] = $row['category_weight'];
$COUNT = $row['category_name'] . "_count";
$info[$COUNT] = 0;
$AVG = $row['category_name'] . "_avg";
$info[$AVG] = 0;
$POSSIBLE = $row['category_name'] . "_possible";
$info[$POSSIBLE] = 0;
$WTD_AVG = $row['category_name'] . "_weighted_avg_sum";
$info[$WTD_AVG] = 0;
}
}
$assign_table = "";
$b = "";
$t = "Student Progress Report";
$t = "";
$result = get_student_grades($sid, $cid, $order_by);
$assigns = array();
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
array_push(${$row['category_name']}, $row);
array_push($assigns, $row);
}
/** Assignments Table **/
$assign_table = "\n\t\t\t<table class=\"grade_book_print\">\n\t\t\t<tr class=\"grade_header\">\n\t\t\t\t<th>Date</a></th>\n\t\t\t\t<th>Assignment</th>\n\t\t\t\t<th>Category</th>\n\t\t\t\t<th>Score</th>\n\t\t\t\t<th>Weight</th>\n\t\t\t\t<th>Avg.</th>\n\t\t\t</tr>";
$rcv = 0;
/** used for row shading **/
$total_cat_weights = 0;
/** Display the grades for each category **/
/**
commenting out the old way so I can try to implement sorting by date rather than category
foreach($cat_names_array as $cat){
private function getGrades()
{
// if ($terms = Cache::get('student_'.$this->student->id.'_api_grades')) {
// return ['grades'=>$terms, 'gpas'=>$this->calculateGpa($terms)];
// }
$terms = get_student_grades($this->student->id);
// Cache::put('student_'.$this->student->id.'_api_terms', $terms, 1200);
return ['grades' => $terms, 'gpas' => $this->calculateGpa($terms)];
}
public function getcompletedeplomesubCertificate($background = false)
{
$student = Student::select('students.*')->joinTermName()->findOrFail($this->student_id);
$semesters = get_student_grades($student->id);
if ($this->student_id == 1821) {
$gpa = 3.59;
} else {
$gpa = GPA($semesters);
}
// $year_id = $semesters = Semester::where('id', $student->histories->first()->academycycle_semester_id)->first()->id;
// dd($year_id);
// $year_name = Year::where('id', '=', $year_id - 1)->first()->name;
$pdf = $this->preparePdf($background);
$html = '<h2>إفادة بإكمال درجة</h2>';
$pdf->writeHTMLCell(210, 20, 10, 50, $html, 0, 0, false, true, "R");
$valuation = check_final_valuation($gpa);
$graduated_date = '';
$fourth = '';
if ($student->registration->fourth_name) {
$fourth = ' بن ' . $student->registration->fourth_name . ' ';
}
$pdf->SetFontSize(16, 'B');
if ($student->gender == 'f') {
$html = '<p>تشهد كلية العلوم الشرعية - التعليم عن بعد بأن:<br>' . $student->registration->first_name . ' بنت ' . $student->registration->second_name . ' بن ' . $student->registration->third_name . $fourth . $student->registration->last_name . '<br>الرقم الجامعي:' . $student->username . '<br>
الجنسيـة: ' . $student->registration->birthcountry->name . ' <br>
</p>';
$pdf->writeHTMLCell(100, 20, 10, 60, $html, 0, 0, false, true, "R");
$pdf->SetFontSize(16, 'B');
//'.$year_name.'
$html = '<p>قد أكملت متطلبات درجة الدبلوم في العلوم الشرعية <br>بمعدل تراكمي ' . $gpa . ' بتقدير ' . $valuation . '<br><br><br><br>وسوف تمنح الدرجة رسمياً بعد اعتمادها.
<p>';
$pdf->writeHTMLCell(100, 20, 10, 110, $html, 0, 0, false, true, "R");
} else {
$html = '<p>تشهد كلية العلوم الشرعية - التعليم عن بعد بأن:<br>' . $student->registration->first_name . ' بن ' . $student->registration->second_name . ' بن ' . $student->registration->third_name . $fourth . $student->registration->last_name . '<br> الرقم الجامعي:' . $student->username . '<br>
الجنسيـة: ' . $student->registration->birthcountry->name . '<br>
</p>';
//'.$year_name.'
$pdf->writeHTMLCell(100, 20, 10, 60, $html, 0, 0, false, true, "R");
$pdf->SetFontSize(16, 'B');
$html = '<p> قد أكمل متطلبات درجة الدبلوم في العلوم الشرعية
<br>في العام الأكاديمي:
<br>بمعدل تراكمي ' . $gpa . ' بتقدير ' . $valuation . '
<br><br>بتاريخ ' . $graduated_date . 'م
<br><br>وسوف تمنح الدرجة رسمياً بعد اعتمادها.
<p>';
$pdf->writeHTMLCell(100, 20, 10, 110, $html, 0, 0, false, true, "R");
}
$pdf->SetFontSize(20, 'B');
$html = 'المشرف العام على التعليم عن بعد<br>مستشار معالي وزير الأوقاف والشؤون الدينية';
$pdf->writeHTMLCell(210, 20, 0, 200, $html, 0, 0, false, true, "C");
$pdf->SetFontSize(16, 'B');
$html = '<table cellpadding="3">
<tr><td align="right">لمزيد من التفاصيل يمكن طلب كشف الدرجات الأصلي</td></tr>
</table>';
$pdf->writeHTMLCell(100, 20, 10, 250, $html, 0, 0, false, true, "R");
//English language
switch ($valuation) {
case 'امتياز':
$valuation = 'excellence';
break;
case 'امتياز مع مرتبة الشرف':
$valuation = 'excellent with honors';
break;
case 'جيد جدا':
$valuation = 'very good';
break;
case 'جيد':
$valuation = 'good';
break;
case 'مقبول':
$valuation = 'fairly good';
break;
default:
$valuation = '';
}
$html = '<h2>Notification of Degree Completion</h2>';
$pdf->writeHTMLCell(205, 20, 0, 50, $html, 0, 0, false, true, "L");
$pdf->SetFontSize(14, 'B');
$fourth = '';
if ($student->registration->fourth_name_latin) {
$fourth = ' bin ' . $student->registration->fourth_name_latin . ' ';
}
if ($student->gender == 'f') {
$html = '<p>College of Shari’a Sciences - Distance learning
<br>attests that:<br>' . $student->registration->first_name_latin . ' bint ' . $student->registration->second_name_latin . ' bin ' . $student->registration->third_name_latin . $fourth . $student->registration->last_name_latin . '
<br>Student ID: ' . $student->username . '<br> Nationality: ' . $student->registration->birthcountry->nationality_en . ' <br>
</p>';
} else {
$html = '<p>College of Shari’a Sciences - Distance learning
<br>attests that:<br>' . $student->registration->first_name_latin . ' bin ' . $student->registration->second_name_latin . ' bin <br>' . $student->registration->third_name_latin . $fourth . $student->registration->last_name_latin . '
<br>Student ID: ' . $student->username . '<br> Nationality: ' . $student->registration->birthcountry->nationality_en . ' <br>
</p>';
}
$pdf->writeHTMLCell(205, 10, 0, 60, $html, 0, 0, false, true, "L");
$pdf->SetFontSize(14, 'B');
$html = '<p>Has successfully fulfilled the graduation
<br>requirements of the Diploma degree in Sharia
<br>Sciences on the academic year $year_name with
<br>accumulative grade of ' . $gpa . ' ' . $valuation . '<br><br> on ' . $graduated_date . '
<br><br>The degree will be officially awarded after <br>the endorsement.</p>';
$pdf->writeHTMLCell(205, 10, 0, 110, $html, 0, 0, false, true, "L");
$pdf->SetFontSize(14, 'B');
$html = '<p>For more details, the official transcript could be<br>requested.</p>';
$pdf->writeHTMLCell(205, 10, 0, 250, $html, 0, 0, false, true, "L");
ob_clean();
return $pdf;
}
$info[$POSSIBLE] = 0;
$WTD_AVG = $row3['category_name'] . "_weighted_avg_sum";
$info[$WTD_AVG] = 0;
}
}
/** NOW LOOP OVER THE ARRAY OF STUDENTS **/
/** THE FOLLOWING SHOULD BE REPEATED FOR EACH STUDENT **/
//foreach($los as $sid=>$sname) {
$info[$MAX] = 0;
$info[$USER] = 0;
$info[$COUNT] = 0;
$info[$AVG] = 0;
$info[$POSSIBLE] = 0;
$info[$WTD_AVG] = 0;
$pageTitle = $year . "_" . $sname . "_" . $className . "_" . $termName . "_Progress_Reports.pdf";
$result4 = get_student_grades($sid, $cid);
$assigns = array();
if ($result4->num_rows > 0) {
$pdf = new FPDF('P', 'in', 'Letter');
$pdf->open();
$pdf->SetTitle($pageTitle);
while ($row4 = $result4->fetch_assoc()) {
array_push(${$row4['category_name']}, $row4);
array_push($assigns, $row4);
}
$rcv = 0;
/** used for row shading **/
$total_cat_weights = 0;
/** Display the grades for each category **/
$assignmentsArray = array();
foreach ($assigns as $grade) {
include_once 'init.php';
include_once 'include/students.php';
include_once 'include/classes.php';
include_once 'include/curriculums.php';
$renderArray = array();
$fromAjax = intval($_REQUEST['fromAjax']);
$template_name = 'index.html';
if ($fromAjax) {
$template_name = 'index-ajax.html';
$quarter_id = intval($_REQUEST['quarter_id']) or die('Invalid quarter_id');
$quarter = get_quarter($quarter_id) or die("No quarter for {$quarter_id}={$quarter_id}");
$date_from = $quarter['started'];
$date_to = $quarter['finished'];
$day_of_week = array(0 => 'Пн', 1 => 'Вт', 2 => 'Ср', 3 => 'Чт', 4 => 'Пт', 5 => 'Сб', 6 => 'Вс');
$class_id = get_student_class_id($student_id) or die('Unknown student');
$student_grades = get_student_grades($student_id, $date_from, $date_to);
$disciplines = get_disciplines_from_class($class_id);
$dates = array();
$grades = array();
foreach ($student_grades as $grade) {
$lesson_monthyear = $grade['lesson_month'] . '.' . $grade['lesson_year'];
$dates[$lesson_monthyear][$grade['lesson_date']] = array('lesson_weekday' => $grade['lesson_weekday'], 'lesson_weekday_w' => $day_of_week[$grade['lesson_weekday']], 'lesson_day' => $grade['lesson_day'], 'lesson_month' => $grade['lesson_month'], 'lesson_year' => $grade['lesson_year']);
$grades[$grade['discipline_id']][$grade['lesson_date']][] = array('grade' => $grade['grade'], 'topic' => $grade['topic'], 'lesson_id' => $grade['lesson_id'], 'lesson_type_id' => $grade['lesson_type_id'], 'lesson_type_name' => $grade['lesson_type_name']);
}
$quarter['started_date'] = date("d.m.Y", strtotime($quarter['started']));
$quarter['finished_date'] = date("d.m.Y", strtotime($quarter['finished']));
$renderArray['quarter'] = $quarter;
$renderArray['dates'] = $dates;
$renderArray['disciplines'] = $disciplines;
$renderArray['grades'] = $grades;
} else {
}
$bc = "";
$t = "Teacher Gradebook for " . $_SESSION[$_CONF['sess_name'] . '_myfName'] . " " . $_SESSION[$_CONF['sess_name'] . '_mylName'];
$b = "";
$sql = "SELECT courses.course_name, terms.term_name \n\t\t\t\tFROM classes, terms, courses\n\t\t\t\tWHERE courses.course_id=classes.course_id\n\t\t\t\tAND classes.class_id=" . $classID . " \n\t\t\t\tAND terms.term_id=classes.term_id";
$result = $db->query($sql);
$row = $result->fetch_assoc();
$courseName = $row['course_name'];
$termName = $row['term_name'];
/** get student info **/
$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'];
/** get the assignments for this student in this class **/
$result = get_student_grades($sid, $classID, "assignments.due_date,assignment_name");
if ($result->num_rows != 0) {
$b .= "\n\t\t\t\t\t<center>\n\t\t\t\t\t<form action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=gradebook method=POST id=\"myGradebook\">\n\t\t\t\t\t<table class=\"grade_book\" border=1 cellspacing=1 cellpadding=3 bgcolor=black id=\"gradeTable\">\n\t\t\t\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td valign=middle align=center colspan=3>\n\t\t\t\t\t\t<b><span style=white-space:nowrap>" . $studentName . "</span><br />\n\t\t\t\t\t\t<span style=white-space:nowrap>" . $courseName . " - " . $termName . "</span></b></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t<td align=center style=font-weight:bold>Assignment</td>\n\t\t\t\t\t<td align=center style=font-weight:bold>Grade</td>\n\t\t\t\t\t<td align=center style=font-weight:bold>Comment</td>\n\t\t\t\t\t</tr>";
if ($result) {
while ($row = $result->fetch_assoc()) {
$assignmentMaxScore = $row['max_score'];
$b .= "<tr class=\"assignment\">\n\t\t\t\t\t\t\t\t<td><span style=white-space:nowrap>" . $row['assignment_name'] . "</span></td>";
$b .= "<td align=center>\n\t\t\t\t\t\t\t\t<input name=assign_" . $row['assignment_id'] . "_" . $sid . " type=text size=4 class=\"grade_input\" maxlength=6 value=\"" . $row['raw_score'] . "\" onChange=\"validate_score(this," . $assignmentMaxScore . ",'" . $row['raw_score'] . "');\"";
if ($row['raw_score'] == 'mi') {
$b .= " style=\"background-color:#FFF0B2;\"";
}
$b .= "/>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<textarea rows=\"1\" cols=\"40\" name=comment_" . $row['assignment_id'] . "_" . $sid . ">" . $row['comment'] . "</textarea>\n\t\t\t\t\t\t\t\t</td>\n";
$b .= "</tr>";
}
}
$b .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan=3 align=center>\n\t\t\t\t\t\t<input type=submit class=submit name=update_grades value=Submit />\n\t\t\t\t\t\t<input type=hidden name=studentent_id value=" . $sid . " />\n\t\t\t\t\t\t<input type=hidden name=class_id value=" . $classID . " />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
