public function executeDeletechapter()
{
$chapter = ChapterPeer::retrieveByPK($this->getRequestParameter('id'));
$cr = $chapter->getChapterregion();
$c = new Criteria();
$c->add(UserchapterregionPeer::CHAPTERREGION_ID, $cr->getId());
$ucount = UserchapterregionPeer::doCount($c);
$ucr = UserchapterregionPeer::doSelectOne($c);
if ($ucr) {
$this->setFlash('notice', 'Cannot delete chapter. <b>' . $ucount . '</b> user(s) are subscribed to this chapter.');
} else {
$chapter->delete();
$cr->delete();
$this->setFlash('notice', 'Chapter Deleted Successfully');
}
$this->redirect('admin/chapters');
}
?>
<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()));
?>
</div>
</div>
<?php
public function countUserchapterregions($criteria = null, $distinct = false, $con = null)
{
include_once 'lib/model/om/BaseUserchapterregionPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
$criteria->add(UserchapterregionPeer::CHAPTERREGION_ID, $this->getId());
return UserchapterregionPeer::doCount($criteria, $distinct, $con);
}
