protected function execute($arguments = array(), $options = array()) { $this->createContextInstance('backend'); // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $c = new Criteria(); $c->add(CourseSubjectStudentExaminationPeer::EXAMINATION_SUBJECT_ID, null, Criteria::ISNULL); foreach (CourseSubjectStudentExaminationPeer::doSelect($c) as $csse) { $csse->setExaminationSubject(ExaminationSubjectPeer::retrieveByCourseSubjectStudentExamination($csse)); $csse->saveForTask(); } // add your code here }
public function executeComponent_marks_info() { $this->course_subject_student = $this->getVar('course_subject_student'); $this->marks = $this->course_subject_student->getAvailableCourseSubjectStudentMarks(); $c = new Criteria(); $c->add(CourseSubjectStudentExaminationPeer::COURSE_SUBJECT_STUDENT_ID, $this->course_subject_student->getId()); $criterion = $c->getNewCriterion(CourseSubjectStudentExaminationPeer::MARK, null, Criteria::ISNOTNULL); $criterion->addOr($c->getNewCriterion(CourseSubjectStudentExaminationPeer::IS_ABSENT, true)); $c->add($criterion); $c->addAscendingOrderByColumn(CourseSubjectStudentExaminationPeer::EXAMINATION_NUMBER); $this->course_subject_student_examinations = CourseSubjectStudentExaminationPeer::doSelect($c); $c = new Criteria(); $c->add(StudentRepprovedCourseSubjectPeer::COURSE_SUBJECT_STUDENT_ID, $this->course_subject_student->getId() . Criteria::INNER_JOIN); $c->addJoin(StudentExaminationRepprovedSubjectPeer::STUDENT_REPPROVED_COURSE_SUBJECT_ID, StudentRepprovedCourseSubjectPeer::ID, Criteria::INNER_JOIN); $c->addJoin(StudentExaminationRepprovedSubjectPeer::EXAMINATION_REPPROVED_SUBJECT_ID, ExaminationRepprovedSubjectPeer::ID, Criteria::INNER_JOIN); $c->addJoin(ExaminationRepprovedSubjectPeer::EXAMINATION_REPPROVED_ID, ExaminationRepprovedPeer::ID, Criteria::INNER_JOIN); $c->addAscendingOrderByColumn(ExaminationRepprovedPeer::EXAMINATION_NUMBER); $criterion = $c->getNewCriterion(StudentExaminationRepprovedSubjectPeer::MARK, null, Criteria::ISNOTNULL); $criterion->addOr($c->getNewCriterion(StudentExaminationRepprovedSubjectPeer::IS_ABSENT, true)); $c->add($criterion); $this->student_examination_repproved_subjects = StudentExaminationRepprovedSubjectPeer::doSelect($c); //$this->pathway_mark = $this->course_subject_student->getCourseSubjectStudentPathwayMark()->getMark(); }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $this->createContextInstance(); $criteria = new Criteria(); $criteria->addJoin(CourseSubjectStudentPeer::ID, CourseSubjectStudentExaminationPeer::COURSE_SUBJECT_STUDENT_ID); $criteria->add(CourseSubjectStudentExaminationPeer::MARK, null, Criteria::ISNOTNULL); $criteria->addAnd(CourseSubjectStudentExaminationPeer::MARK, 6, Criteria::GREATER_EQUAL); $criteria->add(CourseSubjectStudentPeer::STUDENT_ID, 728); $array_csse = CourseSubjectStudentExaminationPeer::doSelect($criteria); $connection->beginTransaction(); try { /* @var $csse CourseSubjectStudentExamination */ foreach ($array_csse as $csse) { $sacs = StudentApprovedCareerSubjectPeer::retrieveByCourseSubjectStudent($csse->getCourseSubjectStudent()); if (is_null($sacs)) { $this->closeCourseSubjectStudentExamination($csse, $connection); } } $connection->commit(); } catch (Exception $e) { $connection->rollback(); throw $e; } }