public function executeDeleteregion()
{
$regionid = $this->getRequestParameter('id');
$c = new Criteria();
$c->add(ChapterregionPeer::REGION_ID, $regionid);
$chcount = ChapterregionPeer::doCount($c);
$chapterregion = ChapterregionPeer::doSelectOne($c);
if ($chapterregion) {
$this->setFlash('notice', 'Region cannot be deleted. <b>' . $chcount . '</b> chapters belong to this region.');
} else {
$region = RegionPeer::retrieveByPK($regionid);
$region->delete();
$this->setFlash('notice', 'Region deleted Successfully.');
}
$this->redirect('admin/regions');
}
public function getChapterregion()
{
$c = new Criteria();
$c->add(ChapterregionPeer::CHAPTER_ID, $this->id);
return ChapterregionPeer::doSelectOne($c);
}
<?php
foreach ($chapters as $chapter) {
$i++;
?>
<div class="<?php
if ($i % 2 == 0) {
echo 'evenRow';
} else {
echo 'oddRow';
}
?>
">
<?php
$c = new Criteria();
$c->add(ChapterregionPeer::CHAPTER_ID, $chapter->getId());
$cr = ChapterregionPeer::doSelectOne($c);
$c->clear();
$c->add(UserchapterregionPeer::CHAPTERREGION_ID, $cr->getId());
$ucount = UserchapterregionPeer::doCount($c);
?>
<div class="statColC1"><?php
echo $chapter->getName();
?>
</div>
<div class="statColC2"><?php
echo $cr->getRegion()->getName();
?>
</div>
<div class="statColC3"><?php
echo link_to($ucount, 'search/result?usertype=1&chapter=' . $chapter->getId(), array('title' => 'Click here to see a list of users from ' . $chapter->getName()));
?>
public function executeJoinchapter()
{
$userid = $this->getUser()->getAttribute('userid');
$rid = $this->getRequestParameter('region');
$cid = $this->getRequestParameter('chapter');
$c = new Criteria();
$c->add(ChapterregionPeer::REGION_ID, $rid);
$c->add(ChapterregionPeer::CHAPTER_ID, $cid);
$cr = ChapterregionPeer::doSelectOne($c);
$c->clear();
$c->add(UserchapterregionPeer::CHAPTERREGION_ID, $cr->getId());
$c->add(UserchapterregionPeer::USER_ID, $userid);
$ucr = UserchapterregionPeer::doSelectOne($c);
if ($ucr) {
$this->setFlash('notice', 'You are already a member of this chapter.');
} else {
$ucr = new Userchapterregion();
$ucr->setUserId($userid);
$ucr->setChapterregion($cr);
$ucr->save();
$this->setFlash('notice', 'Chapter joined successfully.');
}
$this->redirect('/address/show');
}