/** * return the username of the owner * @return mixed */ public function getOwnerName() { $userObj = new User_Model($this->owner); return $userObj->getName(); }
public function index($userID = NULL) { $this->load->model('User_model', 'Curriculum_model'); $this->load->helper('url'); //Loader user from passed ID and advisor from session ID // If the session id isn't the passed user or an advisor for the user, immediantly fail. $user = new User_Model(); $user->loadPropertiesFromPrimaryKey($userID); $advisor = new User_Model(); if (!isset($_SESSION["UserID"])) { redirect('login'); } $advisor->loadPropertiesFromPrimaryKey($_SESSION["UserID"]); $flag = TRUE; foreach ($advisor->getAdvisees() as $student) { if ($student->getUserID() == $userID) { $flag = FALSE; } } if ($advisor->getUserID() == $user->getUserID()) { $flag = FALSE; } if ($flag == TRUE) { echo "YOU DON'T HAVE PERMISSION TO ACCESS THIS USER'S INFORMATION"; exit; } $curriculums = $user->getCurriculums(); $degree = FALSE; foreach ($curriculums as $c) { if ($c->getCurriculumType() == Curriculum_model::CURRICULUM_TYPE_DEGREE) { $degree = TRUE; } } if (!$degree) { echo "ERROR NO CURRICULUM SET FOR USER"; exit; } //Create excel file $Excel = new PHPExcel(); $Excel->getProperties()->setCreator("CSC 404 - 2015 App")->setLastModifiedBy("CSC 404 - 2015 App")->setTitle($user->getName() . " Checklist")->setSubject("Advising Checklist")->setDescription("Auto Generated Checklist")->setCategory("Advisee checklist file"); //Set global defaults $Excel->getDefaultStyle()->getFont()->setSize(10)->setName('Arial'); $Excel->removeSheetByIndex(0); //Generate course sheets $sheetnumber = 0; foreach ($curriculums as $c) { if ($c->getCurriculumType() == Curriculum_model::CURRICULUM_TYPE_DEGREE) { //Generate Checklist $checklist = $Excel->createSheet(NULL, $sheetnumber++); $checklist->setTitle("Checklist"); $this->generatechecklist($checklist, $user, $c, $curriculums); //Generate Quarter View $qview = $Excel->createSheet(NULL, $sheetnumber++); $qview->setTitle("Quarter View"); $this->generate_quarter_view($qview, $user, $c); break; } } //Generate advisor checklist sheet $advcheck = $Excel->createSheet(NULL, $sheetnumber++); $advcheck->setTitle("Advisor Checklist"); $this->generateadvchecklist($advcheck); //Download file object (PDF or XLS) $Excel->setActiveSheetIndex(0); $objWriter = PHPExcel_IOFactory::createWriter($Excel, 'Excel5'); header("Content-type: application/vnd.ms-exel"); header("Content-Disposition: attachment; filename=\"" . $user->getName() . " Checklist.xls\""); $objWriter->save('php://output'); }