/**
* CODE: board member_view
*/
public function executeBoardMemberView(sfWebRequest $request)
{
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Volunteer', 'Member'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
if ($request->getParameter('person_id')) {
$this->person = PersonPeer::retrieveByPK($request->getParameter('person_id'));
}
if ($request->getParameter('id')) {
$b_member = BoardMemberPeer::retrieveByPK($request->getParameter('id'));
$this->title = 'View board member';
$this->person = PersonPeer::retrieveByPK($b_member->getPersonId());
$this->personID = $this->person->getId();
$query = "SELECT * FROM board_member ";
$query .= "WHERE person_id =" . $this->personID;
$con = Propel::getConnection();
$stmt = $con->prepare($query);
$stmt->execute();
$this->value = array();
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
$this->value[] = $rs;
}
}
}
