/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aBoardMember !== null) {
if ($this->aBoardMember->isModified() || $this->aBoardMember->isNew()) {
$affectedRows += $this->aBoardMember->save($con);
}
$this->setBoardMember($this->aBoardMember);
}
if ($this->aCommittee !== null) {
if ($this->aCommittee->isModified() || $this->aCommittee->isNew()) {
$affectedRows += $this->aCommittee->save($con);
}
$this->setCommittee($this->aCommittee);
}
if ($this->isNew()) {
$this->modifiedColumns[] = BoardCommitteePeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = BoardCommitteePeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += BoardCommitteePeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Create/Edit board member
* CODE: board_member_create
*/
public function executeBoardMember(sfWebRequest $request)
{
#Security
if (!$this->getUser()->hasCredential(array('Administrator'), 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->person = PersonPeer::retrieveByPK($b_member->getPersonId());
$this->personID = $this->person->getId();
$this->title = 'Edit board member';
$query = "SELECT * FROM board_member ";
$query .= "WHERE person_id =" . $this->personID . " order by id desc";
$con = Propel::getConnection();
$stmt = $con->prepare($query);
$stmt->execute();
while ($rs = $stmt->fetch()) {
$this->flag = $rs['startyear'];
$this->setendyear = $rs['endyear'];
$this->ID = $rs['id'];
break;
}
$success = 'Board Member information successfully edited!';
$this->person = PersonPeer::retrieveByPK($b_member->getPersonId());
} else {
$b_member = new BoardMember();
$this->title = 'Add new board member';
$success = 'New Board Member information successfully created!';
$this->title1 = 'Board member served history';
$this->person = PersonPeer::retrieveByPK($request->getParameter('person_id'));
$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;
}
}
$this->form = new BoardMemberForm($b_member);
if ($request->isMethod('post')) {
$this->referer = $request->getReferer();
$this->form->bind($request->getParameter('bmem'));
if ($this->form->isValid() && $this->form->getValue('startyear') && $this->form->getValue('endyear') && $request->getParameter('person_id')) {
if ($request->getParameter('person_id')) {
$b_member->setPersonId($this->person->getId());
}
if ($request->getParameter('id')) {
$b_member->setId($request->getParameter('id'));
}
$b_member->setStartyear($this->form->getValue('startyear'));
$b_member->setEndyear($this->form->getValue('endyear'));
$b_member->save();
$this->getUser()->setFlash('success', $success);
$this->redirect('@person_view?id=' . $this->person->getId());
} else {
$this->getUser()->setFlash('warning', 'Please choise start year and end year!');
}
} else {
# Set referer URL
$this->referer = $request->getReferer() ? $request->getReferer() : 'member/index';
}
$this->b_member = $b_member;
}
