public function getRequirementList($studentID, $signatoryID, $sysemID) { $stud_model = new Student_Model(); $stud_model->queryStudent_Info($studentID); $t_deptID = $stud_model->getStud_DeptID(); $t_courseID = $stud_model->getStud_CourseID(); $t_yl = $stud_model->getStud_Yearlevel(); $t_program = $stud_model->getStud_Program(); $arrayTemp = array(); $this->query = mysql_query("select Requirement_ID, Title, Description, Requirement_Type, Prerequisite_Signatory from requirements \r\n where Signatory_ID='{$signatoryID}' and SY_SEM_ID='{$sysemID}' and \r\n (Visibility='All' or Department_ID='{$t_deptID}' or Course_ID='{$t_courseID}' or Year_Level='{$t_yl}' or Program='{$t_program}')"); /* var_dump("select Requirement_ID, Title, Description from requirements where Signatory_ID='$signatoryID' and SY_SEM_ID='$sysemID' and (Visibility='All' or Department_ID='$t_deptID' or Course_ID='$t_courseID' or Year_Level='$t_yl' or Program='$t_program')"); */ while ($row = mysql_fetch_array($this->query)) { if ($row['Requirement_Type'] == 'Textual') { $status = $this->getRequirementClearanceStatus($studentID, $row['Requirement_ID']); } else { $sigID = $row['Prerequisite_Signatory']; if ($this->isStudentUnderSpecifiedSignatory($studentID, $sigID)) { $status = $this->getOverallSignatoryClearanceStatus($studentID, $sigID, $sysemID); if ($status == "No Requirements") { $status = "Cleared"; } } } array_push($arrayTemp, array($row['Requirement_ID'], $row['Title'], $row['Description'], $status, $row['Requirement_Type'])); } return $arrayTemp; }
$current_sy = $sy_model->getCurSchool_Year(); $current_sem = $sy_model->getCurSemester(); if ($current_sem != "Summer") { $current_sem .= " Semester"; } $current_sysemID = $_GET["sy_sem_id"]; $stud_status = $_GET['status'] == "Grad" ? "Graduate" : "Under Graduate"; $student_model = new Student_Model(); $stud_id = Session::get_user(); $student_model->queryStudent_Info($stud_id); $stud_name = $student_model->getStud_Name(); $stud_gender = $student_model->getStud_Gender(); $stud_year = $student_model->getStud_Yearlevel(); $stud_course = $student_model->getStud_Course(); $stud_dept = $student_model->getStud_DeptName(); $stud_deptID = $student_model->getStud_DeptID(); $signatorial_model = new SignatorialList_Model(); $signatorial_model->getListofSignatoryByDept($stud_deptID, $stud_status); $listOfSignatories["name"] = $signatorial_model->getSign_Name(); $listOfSignatories["id"] = $signatorial_model->getSign_ID(); $clearance_model = new ClearanceStatus(); foreach ($listOfSignatories["id"] as $key => $value) { $status = $clearance_model->getOverallSignatoryClearanceStatus($stud_id, $value, $current_sysemID); if ($status == "No Requirements") { $status = "Cleared"; } $listOfSignatories["status"][$key] = $status; } //var_dump($listOfSignatories); $fpdf = new FPDF('P', 'mm', 'Legal'); $fpdf->SetDisplayMode('fullpage', 'continuous');