/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = MemberWingJobPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setMemberId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setWingJobId($arr[$keys[2]]);
}
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(MemberWingJobPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(MemberWingJobPeer::DATABASE_NAME);
$criteria->add(MemberWingJobPeer::ID, $pks, Criteria::IN);
$objs = MemberWingJobPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this WingJob is new, it will return
* an empty collection; or if this WingJob has previously
* been saved, it will retrieve related MemberWingJobs from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in WingJob.
*/
public function getMemberWingJobsJoinMember($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
if ($criteria === null) {
$criteria = new Criteria(WingJobPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collMemberWingJobs === null) {
if ($this->isNew()) {
$this->collMemberWingJobs = array();
} else {
$criteria->add(MemberWingJobPeer::WING_JOB_ID, $this->id);
$this->collMemberWingJobs = MemberWingJobPeer::doSelectJoinMember($criteria, $con, $join_behavior);
}
} else {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(MemberWingJobPeer::WING_JOB_ID, $this->id);
if (!isset($this->lastMemberWingJobCriteria) || !$this->lastMemberWingJobCriteria->equals($criteria)) {
$this->collMemberWingJobs = MemberWingJobPeer::doSelectJoinMember($criteria, $con, $join_behavior);
}
}
$this->lastMemberWingJobCriteria = $criteria;
return $this->collMemberWingJobs;
}
/**
* Member add or edit
* CODE: member_create
*/
public function executeUpdate(sfWebRequest $request)
{
$new_pilot = false;
#Security
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Member'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
//FROM PERSON VIEW
if ($request->getParameter('id')) {
$member = MemberPeer::retrieveByPK($request->getParameter('id'));
$this->forward404Unless($member);
$this->title = 'Edit member';
$success = 'Member information has been successfully changed!';
$this->person = $member->getPerson();
} else {
$this->person = PersonPeer::retrieveByPK($request->getParameter('person_id'));
$this->forward404Unless($this->person);
$member = new Member();
$this->title = 'Add new member';
$success = 'Member information has been successfully created!';
}
$this->form = new MemberForm($member);
$this->back = $request->getReferer();
$this->member = $member;
if (strstr($request->getReferer(), 'person/view')) {
$this->f_back = 1;
} elseif (strstr($request->getReferer(), '/member/view/id')) {
$this->f_back = 3;
} elseif (strstr($request->getReferer(), '/member')) {
$this->f_back = 2;
}
if ($request->isMethod('post')) {
$this->referer = $request->getReferer();
$this->form->bind($request->getParameter('mem'));
if ($this->form->isValid() && $this->form->getValue('member_class_id') != 0 && $this->form->getValue('flight_status')) {
if ($request->getParameter('person_id')) {
$member->setPersonId($request->getParameter('person_id'));
}
$person = PersonPeer::retrieveByPK($request->getParameter('person_id'));
$member->setDateOfBirth($this->form->getValue('date_of_birth'));
$member->setWeight($this->form->getValue('weight'));
$member->setLanguages($this->form->getValue('languages'));
if ($this->form->getValue('wing_id') == 0) {
$member->setWingId(null);
} else {
$member->setWingId($this->form->getValue('wing_id'));
}
if ($this->form->getValue('secondary_wing_id') == 0) {
$member->setSecondaryWingId(null);
} else {
$member->setSecondaryWingId($this->form->getValue('secondary_wing_id'));
}
// setting external_id
$c = new Criteria();
$c->add(MemberPeer::EXTERNAL_ID, NULL, Criteria::ISNOTNULL);
$c->addDescendingOrderByColumn(MemberPeer::ID);
$external_member = MemberPeer::doSelectOne($c);
$external_id = $external_member->getExternalId();
$currentExternalId = $external_id + 1;
$member->setExternalId($currentExternalId);
$member->setJoinDate($this->form->getValue('join_date'));
$member->setMemberClassId($this->form->getValue('member_class_id'));
$member->setSpouseName($this->form->getValue('spouse_name'));
$member->setCoordinatorNotes($this->form->getValue('coordinator_notes'));
$member->setFlightStatus($this->form->getValue('flight_status'));
if ($this->form->getValue('co_pilot') == null) {
$member->setCoPilot(0);
} else {
$member->setCoPilot($this->form->getValue('co_pilot'));
}
$new_member = $member->isNew();
if ($new_member) {
$content = $this->getUser()->getName() . ' added new Member: ' . $person->getFirstName();
ActivityPeer::log($content);
}
$member->save();
//
$wing_jobs = $request->getParameter('wing_job1[]');
if ($request->getParameter('wing_job1')) {
$old_mem_wing_jobs = MemberWingJobPeer::getWingJob($member->getId());
foreach ($old_mem_wing_jobs as $old_mem_wing_job) {
$old_mem_wing_job->delete();
}
foreach ($wing_jobs as $wing_job) {
$member_wing_job = new MemberWingJob();
$member_wing_job->setMemberId($member->getId());
$member_wing_job->setWingJobId($wing_job);
$member_wing_job->save();
}
}
if (strtolower($member->getFlightStatus()) == 'command pilot') {
// if command-pilot then make pilot
$pilot = new Pilot();
$pilot->setMemberId($member->getId());
$pilot->setLicenseType('Default');
$pilot->setIfr(0);
$pilot->setMultiEngine(0);
$pilot->save();
$new_pilot = true;
} else {
$new_pilot = false;
}
$this->getUser()->setFlash('success', $success);
$last = $request->getParameter('back');
$back_url = 'member/index';
if (strstr($last, 'member/edit')) {
$back_url = 'member/index';
} elseif (strstr($last, 'person/view')) {
if (isset($this->person)) {
$back_url = '@person_view?id=' . $this->person->getId();
}
} elseif (strstr($last, 'member/view')) {
$back_url = '@member_view?id=' . $member->getId();
}
//with error validation back url
if (strstr($request->getReferer(), 'last/1')) {
$back_url = '@person_view?id=' . $this->person->getId();
} elseif (strstr($request->getReferer(), 'last/2')) {
$back_url = 'member/index';
} elseif (strstr($request->getReferer(), 'last/3')) {
$back_url = '@member_view?id=' . $member->getId();
}
// role for new member
if ($new_member) {
$role = '@Member';
$member_role = RolePeer::getByTitle($role);
if ($member_role) {
$person_role = new PersonRole();
$person_role->setPersonId($this->person->getId());
$person_role->setRoleId($member_role->getId());
$person_role->save();
} else {
$url = $this->generateUrl('default_index', array('module' => 'role'), true);
$this->getUser()->setFlash('warning', '"' . $role . '" role not found! Please navigate ' . $url . ' and fix.');
}
}
// role for new pilot
if ($new_pilot) {
$role = '@Pilot';
$pilot_role = RolePeer::getByTitle($role);
$is_true = PersonRolePeer::getIsTrue($this->person->getId(), $pilot_role->getId());
if (!$is_true) {
$person_role = new PersonRole();
$person_role->setPersonId($this->person->getId());
$person_role->setRoleId($pilot_role->getId());
$person_role->save();
} else {
$url = $this->generateUrl('default_index', array('module' => 'role'), true);
//$this->getUser()->setFlash('warning', '"'.$role.'" role not found! Please navigate '.$url.' and fix');
}
}
$this->redirect($back_url);
} else {
$this->getUser()->setFlash('warning', 'Please confirm flight status and choose the member class!');
}
} else {
# Set referer URL
$this->referer = $request->getReferer() ? $request->getReferer() : 'member/index';
}
$this->member = $member;
}
