/** * 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; }