public function getParentName() { $parent = CatSubjectPeer::retrieveByPK($this->getParent()); if ($parent != null) { return $parent->getName(); } else { return '-'; } }
public function getCatSubject($con = null) { include_once 'lib/model/om/BaseCatSubjectPeer.php'; if ($this->aCatSubject === null && $this->cat_subject_id !== null) { $this->aCatSubject = CatSubjectPeer::retrieveByPK($this->cat_subject_id, $con); } return $this->aCatSubject; }
public static function doSelectJoinAllExceptPublisher(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } CatalogPeer::addSelectColumns($c); $startcol2 = CatalogPeer::NUM_COLUMNS - CatalogPeer::NUM_LAZY_LOAD_COLUMNS + 1; CatLanguagePeer::addSelectColumns($c); $startcol3 = $startcol2 + CatLanguagePeer::NUM_COLUMNS; CatCategoryPeer::addSelectColumns($c); $startcol4 = $startcol3 + CatCategoryPeer::NUM_COLUMNS; CatSubjectPeer::addSelectColumns($c); $startcol5 = $startcol4 + CatSubjectPeer::NUM_COLUMNS; $c->addJoin(CatalogPeer::CAT_LANGUAGE_ID, CatLanguagePeer::ID); $c->addJoin(CatalogPeer::CAT_CATEGORY_ID, CatCategoryPeer::ID); $c->addJoin(CatalogPeer::CAT_SUBJECT_ID, CatSubjectPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = CatalogPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = CatLanguagePeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getCatLanguage(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addCatalog($obj1); break; } } if ($newObject) { $obj2->initCatalogs(); $obj2->addCatalog($obj1); } $omClass = CatCategoryPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getCatCategory(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addCatalog($obj1); break; } } if ($newObject) { $obj3->initCatalogs(); $obj3->addCatalog($obj1); } $omClass = CatSubjectPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getCatSubject(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addCatalog($obj1); break; } } if ($newObject) { $obj4->initCatalogs(); $obj4->addCatalog($obj1); } $results[] = $obj1; } return $results; }
public static function doSelectFiltered(Criteria $criteria, $con = null) { return CatSubjectPeer::doSelect($criteria); }
<?php foreach ($rows as $cat_subject) { $c = new Criteria(); $c->add(CatSubjectPeer::PARENT, $cat_subject->getId()); $cat_subject->child = CatSubjectPeer::doCount($c); $code_level = ''; for ($i = 0; $i < $level; $i++) { $code_level .= '• '; } ?> <tr id='cs_<?php echo $cat_subject->getId(); ?> ' class="list<?php ++$i; if ($i % 2 == 0) { echo ' even'; } ?> <?php echo $parent_class; ?> cs_<?php echo $parent_id; ?> _child"> <td id='cs_<?php echo $cat_subject->getId(); ?> _expand'>
public function executeGetListName() { if ($this->hasRequestParameter('cat_subject_name') && $this->getRequestParameter('cat_subject_name') != '') { $c = new Criteria(); $cton1 = $c->getNewCriterion(CatSubjectPeer::NAME, '%' . $this->getRequestParameter('cat_subject_name') . '%', Criteria::LIKE); $cton2 = $c->getNewCriterion(CatSubjectPeer::CODE, '%' . $this->getRequestParameter('cat_subject_name') . '%', Criteria::LIKE); //$c->add(CatSubjectPeer::NAME, '%'.$this->getRequestParameter('cat_subject_name').'%', Criteria::LIKE); $cton1->addOr($cton2); $c->add($cton1); //$this->rows = CatSubjectPeer::doSelect($c); $this->rows = CatSubjectPeer::doSelect($c); } }
public function executeGetChild() { $id = $this->getRequestParameter('id'); $this->forward404Unless($id); $level = $this->getRequestParameter('level'); if ($level == null) { $level = 0; } $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $c = new Criteria(); $c->add(CatSubjectPeer::PARENT, $id); $c->addAscendingOrderByColumn(CatSubjectPeer::CODE); $this->rows = CatSubjectPeer::doSelect($c); $this->level = $level + 1; $this->parent_id = $id; $this->parent_class = $this->getRequestParameter('parent_class'); }
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(CatSubjectPeer::ID, $pks, Criteria::IN); $objs = CatSubjectPeer::doSelect($criteria, $con); } return $objs; }
public function countCatSubjectsRelatedByParent($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseCatSubjectPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(CatSubjectPeer::PARENT, $this->getId()); return CatSubjectPeer::doCount($criteria, $distinct, $con); }