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;
}
}
