public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(ScoreRulePeer::ID, $pks, Criteria::IN);
$objs = ScoreRulePeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeSavePreview()
{
$class_group1 = $this->getRequestParameter('class1');
$academic1 = $this->getRequestParameter('accal1');
$class_group2 = $this->getRequestParameter('class2');
$academic2 = $this->getRequestParameter('accal2');
$c = new Criteria();
$c->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $academic1);
$c->add(ScoreRulePeer::CLASS_GROUP_ID, $class_group1);
$s_rules = ScoreRulePeer::doSelect($c);
foreach ($s_rules as $s_rule) {
$score_rule = new ScoreRule();
$score_rule->setAcademicCalendarId($academic2);
$score_rule->setClassGroupId($class_group2);
$score_rule->setClassTypeId($s_rule->getClassTypeId());
$score_rule->setName($s_rule->getName());
$score_rule->setLanguage($s_rule->getLanguage());
$score_rule->setImage($s_rule->getImage());
$score_rule->setKkmFinal($s_rule->getKkmFinal());
$score_rule->setAvgScore($s_rule->getAvgScore());
$score_rule->setTeacher($s_rule->getTeacher());
$score_rule->setType($s_rule->getType());
$score_rule->setTotalScore($s_rule->getTotalScore());
$score_rule->setAvgClass($s_rule->getAvgClass());
$score_rule->setKkmSpec($s_rule->getKkmSpec());
$score_rule->save();
$cw = new Criteria();
$cw->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $s_rule->getId());
$c_objects = ScoreRuleObjectPeer::doSelect($cw);
foreach ($c_objects as $c_object) {
$score_rule_object = new ScoreRuleObject();
$score_rule_object->setScoreRule($score_rule);
$score_rule_object->setGradeSpecId($c_object->getGradeSpecId());
$score_rule_object->setPublished($c_object->getPublished());
$score_rule_object->setSequence($c_object->getSequence());
$score_rule_object->save();
}
$cr = new Criteria();
$cr->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_rule->getId());
$c_subjects = ScoreRuleSubjectPeer::doSelect($cr);
foreach ($c_subjects as $c_subject) {
$score_rule_subject = new ScoreRuleSubject();
$score_rule_subject->setScoreRule($score_rule);
$score_rule_subject->setSequence($c_subject->getPublished());
$score_rule_subject->setSubjectCurrId($c_subject->getSubjectCurrId());
$score_rule_subject->setSubjectType($c_subject->getSubjectType());
$score_rule_subject->setPublished($c_subject->getPublished());
$score_rule_subject->setParent($c_subject->getParent());
$score_rule_subject->save();
}
}
return $this->redirect('score_rule_new/list');
}
public function getScoreRules($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseScoreRulePeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collScoreRules === null) {
if ($this->isNew()) {
$this->collScoreRules = array();
} else {
$criteria->add(ScoreRulePeer::CLASS_GROUP_ID, $this->getId());
ScoreRulePeer::addSelectColumns($criteria);
$this->collScoreRules = ScoreRulePeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(ScoreRulePeer::CLASS_GROUP_ID, $this->getId());
ScoreRulePeer::addSelectColumns($criteria);
if (!isset($this->lastScoreRuleCriteria) || !$this->lastScoreRuleCriteria->equals($criteria)) {
$this->collScoreRules = ScoreRulePeer::doSelect($criteria, $con);
}
}
}
$this->lastScoreRuleCriteria = $criteria;
return $this->collScoreRules;
}
