public static function getInstance(Student $a_student)
{
if (isset(self::$analyticals[$a_student->getId()])) {
return self::$analyticals[$a_student->getId()];
}
$behavior = ucwords(sfConfig::get("nc_flavor_flavors_current", "demo"));
$clazz = $behavior . "AnalyticalBehaviour";
return self::$analyticals[$a_student->getId()] = new $clazz($a_student);
}
public static function retrieveCurrentForStudentCriteria(Student $student, Criteria $c = null)
{
$c = is_null($c) ? new Criteria() : $c;
$c->add(self::SCHOOL_YEAR_ID, SchoolYearPeer::retrieveCurrent()->getId());
$c->addJoin(self::ID, StudentCareerSchoolYearPeer::CAREER_SCHOOL_YEAR_ID);
$c->add(StudentCareerSchoolYearPeer::STUDENT_ID, $student->getId());
return $c;
}
public function contains(Student $student)
{
foreach ($this->students as $s) {
if ($s->getId() == $student->getId()) {
return true;
}
}
return false;
}
public function executeNew(sfWebRequest $request)
{
$programSectionId = $request->getParameter('sectionId');
$this->sectionDetail = Doctrine_Core::getTable('ProgramSection')->findOneById($programSectionId);
$this->forward404Unless($this->sectionDetail);
## New Form
$this->studentForm = new FrontendStudentForm();
if ($request->isMethod('POST')) {
$this->studentForm->bind($request->getParameter('studentform'));
if ($this->studentForm->isValid()) {
$formData = $this->studentForm->getValues();
$student = new Student();
$name = $formData['name'];
$fathersName = $formData['fathers_name'];
$grandfathersName = $formData['grandfathers_name'];
$motherName = $formData['mother_name'];
$dateOfBirth = $formData['date_of_birth'];
$sex = $formData['sex'];
$nationality = $formData['nationality'];
$birthLocation = $formData['birth_location'];
$residenceCity = $formData['residence_city'];
$residenceWoreda = $formData['residence_woreda'];
$residenceKebele = $formData['residence_kebele'];
$residenceHourseNumber = $formData['residence_house_number'];
$ethnicity = $formData['ethnicity'];
$telephone = $formData['telephone'];
$email = $formData['email'];
$student->setName($name);
$student->setFathersName($fathersName);
$student->setGrandfathersName($grandfathersName);
$student->setMotherName($motherName);
$student->setDateOfBirth($dateOfBirth);
$student->setSex($sex);
$student->setAdmissionYear(date('Y'));
$student->setNationality($nationality);
$student->setBirthLocation($birthLocation);
$student->setResidenceCity($residenceCity);
$student->setResidenceWoreda($residenceWoreda);
$student->setResidenceKebele($residenceKebele);
$student->setResidenceHouseNumber($residenceHourseNumber);
$student->setEthinicity($ethnicity);
$student->setTelephone($telephone);
$student->setEmail($email);
$student->save();
$enrollment = new EnrollmentInfo();
$enrollment->makeEnrollment(null, null, null, null, $programSectionId, sfConfig::get('app_transfer_enrollment'), $student->getId());
$auditlog = new AuditLog();
$auditlog->addNewLogInfo($this->getUser()->getAttribute('userId'), 'Performed Enrollment of Transfered Student');
$this->getUser()->setFlash('notice', 'Transfer Enrollment Was Successful ');
$this->redirect('transfer/sectiondetail/?id=' . $programSectionId);
} else {
$this->getUser()->setFlash('error', 'Error with Transfer Enrollment Form');
}
}
}
public static function retrieveForStudentAndCareerSchoolYear(Student $student, CareerSchoolYear $career_school_year, PropelPDO $con = null)
{
$con = is_null($con) ? Propel::getConnection() : $con;
$c = new Criteria();
$c->addJoin(self::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID);
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $student->getId());
$c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID);
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
$c->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId());
return self::doSelect($c, $con);
}
function test_getId()
{
//Arrange
$name = "Joleen";
$enrollment = "8/25/2015";
$id = 1;
$test_student = new Student($name, $enrollment, $id);
//Act
$result = $test_student->getId();
//Assert
$this->assertEquals($id, $result);
}
function test_student_getId()
{
//Arrange
$name = "Bobby";
$id = 1;
$enroll = "2015-10-10";
$test_student = new Student($name, $id, $enroll);
//Act
$result = $test_student->getId();
//Assert
$this->assertEquals(1, $result);
}
function test_find()
{
$name = "Mike";
$enrollment_date = "2015-12-12";
$test_student = new Student($name, $enrollment_date);
$test_student->save();
$name2 = "The Same Exact Name";
$enrollment_date2 = "2015-12-12";
$test_student2 = new Student($name2, $enrollment_date2);
$test_student2->save();
$result = Student::find($test_student->getId());
$this->assertEquals($test_student, $result);
}
function testFind()
{
$name = "Bob";
$enrollment_date = "2015-01-01";
$test_student = new Student($name, $enrollment_date);
$test_student->save();
$name2 = "Kevin";
$enrollment_date2 = "2015-02-01";
$test_student2 = new Student($name, $enrollment_date);
$test_student2->save();
$result = Student::find($test_student->getId());
$this->assertEquals($test_student, $result);
}
function testGetId()
{
$name = "Coding 101";
$enrollment_date = '0000-00-00';
$id = 1;
$test_course = new Course($name, $id);
$test_course->save();
$student_name = "Aladdin";
$course_id = $test_course->getId();
$test_student = new Student($student_name, $id, $enrollment_date, $course_id);
$result = $test_student->getId();
$this->assertEquals(1, $result);
}
function test_find()
{
$student_name = "Abe Lincoln";
$enroll_date = "06-15-2015";
$test_student = new Student($student_name, $enroll_date);
$test_student->save();
$student_name2 = "George Washington";
$enroll_date2 = "05-30-2015";
$test_student2 = new Student($student_name2, $enroll_date2);
$test_student2->save();
$result = Student::find($test_student->getId());
$this->assertEquals($test_student, $result);
}
/**
* Counts the repproved course subjects for the given student and career.
*
* @param Student $student
* @param Career $career
* @param PropelPDO $con
* @return Criteria
*/
public static function retrieveCriteriaRepprovedForStudentAndCareer(Student $student, Career $career, PropelPDO $con = null)
{
$c = new Criteria();
$c->add(self::STUDENT_APPROVED_CAREER_SUBJECT_ID, null, Criteria::ISNULL);
$c->addJoin(self::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID);
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $student->getId());
$c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID);
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
$c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID);
$c->add(CareerSchoolYearPeer::CAREER_ID, $career->getId());
$excluded_subjects = SchoolBehaviourFactory::getEvaluatorInstance()->getExcludeRepprovedSubjects();
$c->add(CareerSchoolYearPeer::ID, $excluded_subjects, Criteria::NOT_IN);
return $c;
}
public static function retrieveByDateAndStudent($date, Student $student, $course_subject_id, $career_school_year_id = null)
{
$c = new Criteria();
$c->add(self::DAY, $date);
$c->add(self::STUDENT_ID, $student->getId());
if (is_null($course_subject_id)) {
$c->add(self::COURSE_SUBJECT_ID, null, Criteria::ISNULL);
} else {
$c->add(self::COURSE_SUBJECT_ID, $course_subject_id);
}
if (!is_null($career_school_year_id)) {
$c->add(self::CAREER_SCHOOL_YEAR_ID, $career_school_year_id);
}
return self::doSelectOne($c);
}
public static function retrieveCriteriaByCareerSchoolYearAndStudent(CareerSchoolYear $career_school_year, Student $student, PropelPDO $con = null, $approved = false)
{
if (is_null($con)) {
$con = Propel::getConnection();
}
$c = new Criteria();
$c->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId());
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
$c->addJoin(CourseSubjectPeer::ID, self::COURSE_SUBJECT_ID);
$c->add(self::STUDENT_ID, $student->getId());
if ($approved) {
$c->add(self::STUDENT_APPROVED_COURSE_SUBJECT_ID, null, Criteria::ISNOTNULL);
}
$c->addGroupByColumn(self::COURSE_SUBJECT_ID);
return $c;
}
function test_find()
{
//Arrange
$test_department = new Department("Biology", "346 Stupid Avenue");
$test_department->save();
$name = "Ashlin Aronin";
$enrollment_date = "2015-08-24";
$test_student = new Student($name, $enrollment_date, $test_department->getId());
$test_student->save();
$name2 = "John Nolastname";
$enrollment_date2 = "2015-07-20";
$test_student2 = new Student($name, $enrollment_date, $test_department->getId());
$test_student2->save();
//Act
$result = Student::find($test_student2->getId());
//Assert
$this->assertEquals($test_student2, $result);
}
function testFind()
{
//Arrange
$name = "Sandra Maley";
$enrollment_date = "2016-04-29";
$name2 = "Margaret Sinclair";
$enrollment_date2 = "2017-11-30";
$test_student = new Student($name, $enrollment_date);
$test_student->save();
$test_student2 = new Student($name2, $enrollment_date2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
function test_getStudents()
{
//Arrange
$name3 = "Psychology 101";
$course_number = "PSY101";
$test_course = new Course($name3, $course_number);
$test_course->save();
$name = "bob";
$date_of_enrollment = "2015-09-16";
$test_student = new Student($name, $date_of_enrollment);
$test_student->save();
$name2 = "bill";
$date_of_enrollment2 = "2015-09-15";
$test_student2 = new Student($name2, $date_of_enrollment2);
$test_student2->save();
//Act
$test_course->addStudent($test_student->getId());
$test_course->addStudent($test_student2->getId());
//Assert
$result = $test_course->getStudents();
$this->assertEquals([$test_student, $test_student2], $result);
}
function testFind()
{
//Arrange
$name = "Elliot Michaels";
$date = "2015-08-03";
$id = 1;
$test_student = new Student($name, $date, $id);
$test_student->save();
$name2 = "Drake Michaels";
$date2 = "2011-02-02";
$id2 = 2;
$test_student2 = new Student($name2, $date2, $id2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
private function evaluateHistoriaDelArteCareerSchoolYearStudent(CareerSchoolYear $career_school_year, Student $student, PropelPDO $con)
{
$c = new Criteria();
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $student->getId());
$c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID, Criteria::INNER_JOIN);
$c->add(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, $this->getCurrentHistoriaDelArte()->getId());
$course_subject_students = CourseSubjectStudentPeer::doSelect($c);
if (empty($course_subject_students) || count($course_subject_students) == 1) {
return false;
}
$course_result_1 = $course_subject_students[0]->getCourseResult();
$course_result_2 = $course_subject_students[1]->getCourseResult();
if (is_null($course_result_1) || is_null($course_result_2)) {
return false;
}
//APROBO LAS DOS
if ($course_result_1 instanceof StudentApprovedCourseSubject && $course_result_2 instanceof StudentApprovedCourseSubject) {
$student_approved_career_subject = new StudentApprovedCareerSubject();
$student_approved_career_subject->setCareerSubject($course_result_1->getCourseSubject($con)->getCareerSubject($con));
$student_approved_career_subject->setStudent($student);
$student_approved_career_subject->setSchoolYear($course_result_1->getSchoolYear($con));
$avg = ($course_result_1->getMark() + $course_result_2->getMark()) / 2;
$avg = sprintf('%.4s', $avg);
$student_approved_career_subject->setMark($avg);
$course_result_1->setStudentApprovedCareerSubject($student_approved_career_subject);
$course_result_2->setStudentApprovedCareerSubject($student_approved_career_subject);
$student_approved_career_subject->save($con);
$course_result_1->save($con);
$course_result_2->save($con);
###liberando memoria###
$student_approved_career_subject->clearAllReferences(true);
unset($student_approved_career_subject);
unset($course_result_1);
unset($course_result_2);
########################
} else {
if ($course_result_1 instanceof StudentDisapprovedCourseSubject && $course_result_2 instanceof StudentDisapprovedCourseSubject) {
$course_subject_student = $course_result_1->getExaminationNumber() > $course_result_2->getExaminationNumber() ? $course_subject_students[0] : $course_subject_students[1];
$this->createCourseSubjectStudentExamination($course_subject_student, $con);
} elseif ($course_result_1 instanceof StudentDisapprovedCourseSubject) {
$this->createCourseSubjectStudentExamination($course_subject_students[0], $con);
} elseif ($course_result_2 instanceof StudentDisapprovedCourseSubject) {
$this->createCourseSubjectStudentExamination($course_subject_students[1], $con);
}
}
unset($course_subject_students);
}
function test_deleteAllStudents()
{
//Arrange
$name = "Wesley Pong";
$enrollment_date = "2015-09-09";
$id = 1;
$test_student = new Student($name, $enrollment_date, $id);
$test_student->save();
$name2 = "Billy Bodega";
$enrollment_date2 = "2015-09-09";
$id2 = 1;
$test_student2 = new Student($name2, $enrollment_date2, $id2);
$test_student2->save();
$course_name = "History";
$id2 = 2;
$course_number = 'HIST:101';
$test_course = new Course($course_name, $course_number, $id2);
$test_course->save();
$test_course->addStudent($test_student->getId());
$test_course->addStudent($test_student2->getId());
//Act
$test_course->deleteAllStudents($test_student->getId());
$result = $test_course->getStudents();
//Assert
$this->assertEquals([], $result);
}
function testFind()
{
//Arrange
$name = "Math";
$date = '0000-00-00';
$id = null;
$test_course = new Course($name, $id);
$test_course->save();
$student_name = "Student1";
$id = 1;
$course_id = $test_course->getId();
$test_student = new Student($student_name, $id, $date, $course_id);
$test_student->save();
$student_name2 = "Student2";
$id2 = 2;
$course_id2 = $test_course->getId();
$test_student2 = new Student($student_name2, $id2, $date, $course_id2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
function test_find()
{
//Arrange
$student_name = "Paco";
$enrollment_date = "2015-08-22";
$id1 = 1;
$test_Student = new Student($student_name, $id1, $enrollment_date);
$test_Student->save();
$student_name2 = "Pablo";
$enrollment_date2 = "2015-08-25";
$id2 = 2;
$test_Student2 = new Student($student_name2, $id2, $enrollment_date2);
$test_Student2->save();
//Act
$id = $test_Student->getId();
$result = Student::find($id);
//Assert
$this->assertEquals($test_Student, $result);
}
/**
* Set the current student for the session of this
* user to $student.
*
* @param Student $student The student to set as current.
*
* @return myUser This object, for fluent interface.
*/
public function setCurrentStudent(Student $student)
{
return $this->setCurrentStudentId($student->getId());
}
/**
* This method returns all the divisions of the SchoolYear passed fot the student given
*
* @param Student $student
* @param SchoolYear $school_year
* @return <array> Division
*/
public static function retrieveStudentSchoolYearDivisions($school_year, $student)
{
$criteria = new Criteria();
$criteria->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $school_year->getId());
$criteria->addJoin(self::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID);
$criteria->addJoin(self::ID, DivisionStudentPeer::DIVISION_ID);
$criteria->add(DivisionStudentPeer::STUDENT_ID, $student->getId());
$criteria->addAscendingOrderByColumn(self::YEAR);
return self::doSelect($criteria);
}
public static function getLastStudentCareerSchoolYear(Student $student, CareerSchoolYear $career_school_year)
{
$c = new Criteria();
$c->add(self::STUDENT_ID, $student->getId());
$c->addDescendingOrderByColumn(self::YEAR);
return self::doSelectOne($c);
}
function testFind()
{
//Arrange
$id = null;
$name = "Micah";
$enrollment_date = "2015-08-28";
$test_student = new Student($id, $name, $enrollment_date);
$test_student->save();
$name2 = "Phil";
$enrollment_date2 = "2015-04-01";
$test_student2 = new Student($id, $name2, $enrollment_date2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
function test_find()
{
//Arrange
$student_name = "Bob";
$enroll_date = "2012-10-20";
$id = null;
$test_student = new Student($student_name, $enroll_date, $id);
$test_student->save();
$student_name2 = "Sue";
$enroll_date2 = "2013-09-09";
$test_student2 = new Student($student_name2, $enroll_date2, $id);
$test_student2->save();
//Act
$id = $test_student->getId();
$result = Student::find($id);
//Assert
$this->assertEquals($test_student, $result);
}
function test_find()
{
//Arrange
$name = "Jack";
$date_of_enrollment = "2012-02-12";
$name2 = "Billy";
$date_of_enrollment2 = "2011-04-14";
$id = 1;
$id2 = 2;
$test_student = new Student($name, $date_of_enrollment, $id);
$test_student->save();
$test_student2 = new Student($name2, $date_of_enrollment2, $id2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
function test_find()
{
//Arange
$name = "Steve Beekman";
$date = "2015-08-23";
$test_student = new Student($name, $date);
$test_student->save();
$name2 = "Fred Flintstone";
$date2 = "0001-01-01";
$test_student2 = new Student($name2, $date2);
$test_student2->save();
//Act
$result = Student::find($test_student->getId());
//Assert
$this->assertEquals($test_student, $result);
}
/**
* This method check if the student has approved all the correlatives for the careerSubject.
*
* @param CareerSubject $career_subject
* @param Student $student
* @return boolean
*/
public function canAddEquivalenceFor(CareerSubject $career_subject, Student $student)
{
foreach ($career_subject->getCorrelativeCareerSubjects() as $cs) {
$c = new Criteria();
$c->add(StudentApprovedCareerSubjectPeer::STUDENT_ID, $student->getId());
$c->add(StudentApprovedCareerSubjectPeer::CAREER_SUBJECT_ID, $cs->getId());
if (StudentApprovedCareerSubjectPeer::doCount($c) == 0) {
return false;
}
}
return true;
}
