public function getCourseModelRecurs()
{
if (!$this->getCourseModel()) {
if ($this->getParent()) {
$p = VAcademicCalendarPeer::retrieveByPK($this->getParent());
return $p->getCourseModelRecurs();
}
return self::CM_CUSTOM;
}
return $this->getCourseModel();
}
public function filter($c, $filters)
{
$filters_key = array_keys($filters);
foreach ($filters_key as $key) {
$value = $filters[$key];
if ($value == '' || $value == null) {
continue;
}
$column = VAcademicCalendarPeer::getTableMap()->getColumn($key);
$name = $column->getFullyQualifiedName();
$creoleType = $column->getCreoleType();
if ($creoleType == CreoleTypes::TIMESTAMP) {
$c->add($name, $value, Criteria::EQUAL);
} else {
if ($creoleType == CreoleTypes::INTEGER) {
$c->add($name, $value, Criteria::EQUAL);
} else {
if ($creoleType == CreoleTypes::VARCHAR) {
$c->add($name, "%{$value}%", Criteria::LIKE);
}
}
}
}
}
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(VAcademicCalendarPeer::ID, $pks, Criteria::IN);
$objs = VAcademicCalendarPeer::doSelect($criteria, $con);
}
return $objs;
}
public function getVAcademicCalendarsJoinDepartment($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseVAcademicCalendarPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collVAcademicCalendars === null) {
if ($this->isNew()) {
$this->collVAcademicCalendars = array();
} else {
$criteria->add(VAcademicCalendarPeer::PARENT, $this->getId());
$this->collVAcademicCalendars = VAcademicCalendarPeer::doSelectJoinDepartment($criteria, $con);
}
} else {
$criteria->add(VAcademicCalendarPeer::PARENT, $this->getId());
if (!isset($this->lastVAcademicCalendarCriteria) || !$this->lastVAcademicCalendarCriteria->equals($criteria)) {
$this->collVAcademicCalendars = VAcademicCalendarPeer::doSelectJoinDepartment($criteria, $con);
}
}
$this->lastVAcademicCalendarCriteria = $criteria;
return $this->collVAcademicCalendars;
}
protected static function doOnDeleteCascade(Criteria $criteria, Connection $con)
{
$affectedRows = 0;
$objects = AcademicCalendarPeer::doSelect($criteria, $con);
foreach ($objects as $obj) {
include_once 'lib/model/VAcademicCalendar.php';
$c = new Criteria();
$c->add(VAcademicCalendarPeer::PARENT, $obj->getId());
$affectedRows += VAcademicCalendarPeer::doDelete($c, $con);
}
return $affectedRows;
}
public static function doSelectByDepartment(Criteria $criteria, $con = null)
{
$sa_id = sfContext::getInstance()->getRequest()->getParameter('subject_accal_id');
$sa = SubjectAccalPeer::retrieveByPK($sa_id);
if ($sa == null) {
return array();
}
$dept_id = $sa->getDepartmentId();
$criteria->add(VAcademicCalendarPeer::ID, $dept_id, Criteria::IN);
$tmp_depts = VAcademicCalendarPeer::doSelect($criteria);
$depts = array();
foreach ($tmp_depts as $key => $val) {
$pi = $val->getParentalIndex();
$prefix = '';
for ($i = 0; $i < $val->level - 1; $i++) {
$prefix .= ParamsPeer::retrieveByCode('tree_node_mark')->getValue();
}
$val->setName($prefix . $val->getName());
$val->setCode($prefix . $val->getCode());
$depts[$pi] = $val;
}
ksort($depts);
$result = array();
foreach ($depts as $r) {
$result[] = $r;
}
return $result;
}
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = VAcademicCalendarPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setCode($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setName($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setParent($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setCurriculumId($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setClassGroupId($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setCurrSystemId($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setDepartmentId($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setStart($arr[$keys[8]]);
}
if (array_key_exists($keys[9], $arr)) {
$this->setEnd($arr[$keys[9]]);
}
if (array_key_exists($keys[10], $arr)) {
$this->setCourseModel($arr[$keys[10]]);
}
if (array_key_exists($keys[11], $arr)) {
$this->setTotalSubject($arr[$keys[11]]);
}
if (array_key_exists($keys[12], $arr)) {
$this->setYear($arr[$keys[12]]);
}
if (array_key_exists($keys[13], $arr)) {
$this->setTotalCredit($arr[$keys[13]]);
}
}
