public function getChapterregions($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseChapterregionPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collChapterregions === null) {
if ($this->isNew()) {
$this->collChapterregions = array();
} else {
$criteria->add(ChapterregionPeer::CHAPTER_ID, $this->getId());
ChapterregionPeer::addSelectColumns($criteria);
$this->collChapterregions = ChapterregionPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(ChapterregionPeer::CHAPTER_ID, $this->getId());
ChapterregionPeer::addSelectColumns($criteria);
if (!isset($this->lastChapterregionCriteria) || !$this->lastChapterregionCriteria->equals($criteria)) {
$this->collChapterregions = ChapterregionPeer::doSelect($criteria, $con);
}
}
}
$this->lastChapterregionCriteria = $criteria;
return $this->collChapterregions;
}
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(ChapterregionPeer::ID, $pks, Criteria::IN);
$objs = ChapterregionPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeGetchapters()
{
$rid = $this->getRequestParameter('rid');
$c = new Criteria();
$c->add(ChapterregionPeer::REGION_ID, $rid);
$crs = ChapterregionPeer::doSelect($c);
$chapterlist = array();
if ($crs) {
$chapterlist[] = "Select a chapter";
foreach ($crs as $cr) {
$chapterlist[$cr->getChapterId()] = $cr->getChapter()->getName();
}
} else {
$chapterlist[] = "No Chapters";
}
$this->chapterlist = $chapterlist;
$this->rid = $rid;
}
