public function addStudentThesis(StudentThesis $l) { $this->collStudentThesiss[] = $l; $l->setAcademicCalendar($this); }
public function executeUpdateProfile() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); // add/update student_detail if ($action_type == $action_i18n || !$this->getRequestParameter('student_detail_id')) { $student_detail = new StudentDetail(); } else { $student_detail = StudentDetailPeer::retrieveByPk($this->getRequestParameter('student_detail_id')); #$this->forward404Unless($student_detail); } $student_detail->setId($this->getRequestParameter('student_detail_id')); $student_detail->setPob($this->getRequestParameter('pob')); if ($this->getRequestParameter('dob')) { $student_detail->setDob($this->getRequestParameter('dob')); } $student_detail->setSex($this->getRequestParameter('sex')); $student_detail->setAddress($this->getRequestParameter('address')); $student_detail->setRegionId($this->getRequestParameter('region_id')); $student_detail->setPostCode($this->getRequestParameter('post_code')); $student_detail->setParentName($this->getRequestParameter('parent_name')); $student_detail->setPhone($this->getRequestParameter('phone')); $student_detail->setCellphone($this->getRequestParameter('cellphone')); $student_detail->setReligionId($this->getRequestParameter('religion_id')); $student_detail->setSchoolOfOrigin($this->getRequestParameter('school_of_origin')); $student_detail->setGraduationYear($this->getRequestParameter('graduation_year')); $student_detail->setGraduationGrade($this->getRequestParameter('graduation_grade')); $student_detail->setCompany($this->getRequestParameter('company')); $student_detail->setJobTitle($this->getRequestParameter('job_title')); $student_detail->setCollegeOfOrigin($this->getRequestParameter('college_of_origin')); $student_detail->setDepartmentOfOrigin($this->getRequestParameter('department_of_origin')); $student_detail->setRegYear($this->getRequestParameter('reg_year')); $student_detail->setResidenceStatus($this->getRequestParameter('residence_status')); $student_detail->setHomeDistance($this->getRequestParameter('home_distance')); $student_detail->setTransport($this->getRequestParameter('transport')); $student_detail->setNativeLanguage($this->getRequestParameter('native_language')); $student_detail->setChildNumber($this->getRequestParameter('child_number')); $student_detail->setBloodSiblings($this->getRequestParameter('blood_siblings')); $student_detail->setStepSiblings($this->getRequestParameter('step_siblings')); $student_detail->setAdoptSiblings($this->getRequestParameter('adopt_siblings')); $student_detail->setOrphanageStatus($this->getRequestParameter('orphanage_status')); $student_detail->setNationality($this->getRequestParameter('nationality')); $student_detail->setShortName($this->getRequestParameter('short_name')); $student_detail->setIntelligency($this->getRequestParameter('intelligency')); if ($this->getRequestParameter('test_date') != '') { $student_detail->setTestDate($this->getRequestParameter('test_date')); } $student_detail->save(); ### Member Detail ### if ($action_type == $action_i18n || !$this->getRequestParameter('member_detail_id')) { $member_detail = new MemberDetail(); } else { $member_detail = MemberDetailPeer::retrieveByPk($this->getRequestParameter('member_detail_id')); #$this->forward404Unless($member_detail); } $member_detail->setId($this->getRequestParameter('member_detail_id')); $member_detail->setPob($this->getRequestParameter('pob')); if ($this->getRequestParameter('dob')) { $member_detail->setDob($this->getRequestParameter('dob')); } $member_detail->setSex($this->getRequestParameter('sex')); $member_detail->setAddress($this->getRequestParameter('address')); $member_detail->setRegionId($this->getRequestParameter('region_id')); $member_detail->setPostCode($this->getRequestParameter('post_code')); $member_detail->setPhone($this->getRequestParameter('phone')); $member_detail->setCellphone($this->getRequestParameter('cellphone')); $member_detail->setReligionId($this->getRequestParameter('religion_id')); $member_detail->setSchoolOfOrigin($this->getRequestParameter('school_of_origin')); $member_detail->setGraduationYear($this->getRequestParameter('graduation_year')); $member_detail->setGraduationGrade($this->getRequestParameter('graduation_grade')); $member_detail->setCompany($this->getRequestParameter('company')); $member_detail->setJobTitle($this->getRequestParameter('job_title')); $member_detail->setCollegeOfOrigin($this->getRequestParameter('college_of_origin')); $member_detail->setDepartmentOfOrigin($this->getRequestParameter('department_of_origin')); $member_detail->setRegYear($this->getRequestParameter('reg_year')); $member_detail->setResidenceStatus($this->getRequestParameter('residence_status')); $member_detail->setHomeDistance($this->getRequestParameter('home_distance')); $member_detail->setTransport($this->getRequestParameter('transport')); $member_detail->setNativeLanguage($this->getRequestParameter('native_language')); $member_detail->setChildNumber($this->getRequestParameter('child_number')); $member_detail->setBloodSiblings($this->getRequestParameter('blood_siblings')); $member_detail->setStepSiblings($this->getRequestParameter('step_siblings')); $member_detail->setAdoptSiblings($this->getRequestParameter('adopt_siblings')); $member_detail->setOrphanageStatus($this->getRequestParameter('orphanage_status')); $member_detail->setNationality($this->getRequestParameter('nationality')); $member_detail->setShortName($this->getRequestParameter('short_name')); $member_detail->setIntelligency($this->getRequestParameter('intelligency')); if ($this->getRequestParameter('test_date') != '') { $member_detail->setTestDate($this->getRequestParameter('test_date')); } $member_detail->save(); if ($action_type == $action_i18n || !$this->getRequestParameter('member_id')) { $member = new Member(); } else { $member = MemberPeer::retrieveByPk($this->getRequestParameter('member_id')); #$this->forward404Unless($member); } $member->setId($this->getRequestParameter('member_id')); $member->setCode($this->getRequestParameter('code')); $member->setName($this->getRequestParameter('name')); $old_status = $member->getStatus(); $member->setStatus($this->getRequestParameter('status')); $member->setType('1'); $member->setMemberDetail($member_detail); if ($this->getRequestParameter('password') != null && strlen($this->getRequestParameter('password')) > 0) { // password set $crypted = sha1(sfConfig::get('app_salt') . $this->getRequestParameter('password')); if ($member->getPassword() != $crypted && strlen($this->getRequestParameter('password')) > 0) { // password changed $member->setPassword($crypted); } } elseif ($member->getPassword() == null || $member->getPassword() == '') { // create $crypted = sha1(sfConfig::get('app_salt') . $this->getRequestParameter('code') . $member_detail->getDob('dm')); $member->setPassword($crypted); } $member->save(); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $student = new Student(); } else { $student = StudentPeer::retrieveByPk($this->getRequestParameter('id')); #$this->forward404Unless($student); } $student->setId($this->getRequestParameter('id')); $student->setCode($this->getRequestParameter('code')); $student->setCode2($this->getRequestParameter('code2')); $student->setName($this->getRequestParameter('name')); $student->setClassName($this->getRequestParameter('class_name')); $student->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $student->setClassGroupId($this->getRequestParameter('class_group_id')); $student->setTestApplicantId($this->getRequestParameter('test_applicant_id')); $old_status = $student->getStatus(); $student->setStatus($this->getRequestParameter('status')); $student->setStudentDetail($student_detail); $student->setMember($member); if ($this->getRequestParameter('password') != null && strlen($this->getRequestParameter('password')) > 0) { // password set $crypted = sha1(sfConfig::get('app_salt') . $this->getRequestParameter('password')); if ($student->getPassword() != $crypted && strlen($this->getRequestParameter('password')) > 0) { // password changed $student->setPassword($crypted); } } elseif ($student->getPassword() == null || $student->getPassword() == '') { // create $crypted = sha1(sfConfig::get('app_salt') . $student_detail->getDob('dmY')); $student->setPassword($crypted); } $student->save(); if ($student->getStatus() == Student::STATUS_FINAL) { $c = new Criteria(); $c->add(SubjectPeer::IS_COMPREHENSIVE_SUBJECT, true); $c->addJoin(SubjectPeer::ID, SubjectAccalPeer::SUBJECT_ID); $c->addJoin(SubjectAccalPeer::ID, StudentCoursePeer::SUBJECT_ACCAL_ID); $c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_ACTIVE); $c->add(StudentCoursePeer::STUDENT_ID, $student->getId()); $sc = StudentCoursePeer::doSelectOne($c); if ($sc) { $accal_id = $sc->getSubjectAccal()->getAcademicCalendarId(); $st = new StudentThesis(); $st->setStudentid($student->getId()); $st->setStatus(StudentThesis::STATUS_ACTIVE); $st->setAcademicCalendarId($accal_id); $st->save(); } else { $student->setStatus($old_status); $student->save(); } } elseif ($student->getStatus() == Student::STATUS_GRADUATE) { $student->setGraduationDate(date('Y/m/d')); $student->save(); } // save photo $photo_dir = sfConfig::get('sf_data_dir') . DIRECTORY_SEPARATOR . 'photos' . DIRECTORY_SEPARATOR; if ($this->hasRequestParameter('photoFile') && $this->getRequestParameter('photoFile') != '' && $this->getRequestParameter('photoFile') != null) { // get photo content $photo_file = $photo_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('photoFile'); $content = file_get_contents($photo_file); $im = imagecreatefromstring($content); list($w, $h) = getimagesize($photo_file); // generate photo $photo = imagecreatetruecolor(150, 195); imagecopyresized($photo, $im, 0, 0, 0, 0, 150, 195, $w, $h); // generate thumbnail $thumb = imagecreatetruecolor(100, 130); imagecopyresized($thumb, $im, 0, 0, 0, 0, 100, 130, $w, $h); // get photo record $c = new Criteria(); $c->add(StudentPhotoPeer::STUDENT_ID, $student->getId()); $student_photo = StudentPhotoPeer::doSelectOne($c); if ($student_photo == null) { $student_photo = new StudentPhoto(); $student_photo->setStudent($student); } // save photo imagepng($photo, $photo_file); $student_photo->setPhoto(base64_encode(file_get_contents($photo_file))); imagepng($thumb, $photo_file); $student_photo->setThumbnail(base64_encode(file_get_contents($photo_file))); $student_photo->save(); unlink($photo_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('photoFile')); } // save member photo $photo_dir = sfConfig::get('sf_data_dir') . DIRECTORY_SEPARATOR . 'photos' . DIRECTORY_SEPARATOR; if ($this->hasRequestParameter('photoFile') && $this->getRequestParameter('photoFile') != '' && $this->getRequestParameter('photoFile') != null) { // get photo content $photo_file = $photo_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('photoFile'); $content = file_get_contents($photo_file); $im = imagecreatefromstring($content); list($w, $h) = getimagesize($photo_file); // generate photo $photo = imagecreatetruecolor(150, 200); imagecopyresized($photo, $im, 0, 0, 0, 0, 150, 200, $w, $h); // generate thumbnail $thumb = imagecreatetruecolor(100, 150); imagecopyresized($thumb, $im, 0, 0, 0, 0, 100, 150, $w, $h); // get photo record $c = new Criteria(); $c->add(MemberPhotoPeer::MEMBER_ID, $member->getId()); $member_photo = MemberPhotoPeer::doSelectOne($c); if ($member_photo == null) { $member_photo = new MemberPhoto(); $member_photo->setMember($member); } // save photo imagepng($photo, $photo_file); $member_photo->setPhoto(base64_encode(file_get_contents($photo_file))); imagepng($thumb, $photo_file); $member_photo->setThumbnail(base64_encode(file_get_contents($photo_file))); $member_photo->save(); unlink($photo_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('photoFile')); } $filter_class = $this->getRequestParameter('filter_class'); $filter_name = $this->getRequestParameter('filter_name'); $filter_code = $this->getRequestParameter('filter_code'); $filter_code2 = $this->getRequestParameter('filter_code2'); if ($filter_class) { return $this->redirect('student/listProfile?filters[CLASS_NAME]=' . $filter_class); } elseif ($filter_name) { return $this->redirect('student/listProfile?filters[NAME]=' . $filter_name); } elseif ($filter_code) { return $this->redirect('student/listProfile?filters[CODE]=' . $filter_code); } elseif ($filter_code2) { return $this->redirect('student/listProfile?filters[CODE2]=' . $filter_code2); } else { return $this->redirect('student/listProfile'); } }