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