public function saveUserFilterMissionTypesList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['user_filter_mission_types_list'])) { // somebody has unset this widget return; } if (is_null($con)) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(UserFilterMissionTypesPeer::USER_FILTER_ID, $this->object->getPrimaryKey()); UserFilterMissionTypesPeer::doDelete($c, $con); $values = $this->getValue('user_filter_mission_types_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new UserFilterMissionTypes(); $obj->setUserFilterId($this->object->getPrimaryKey()); $obj->setMissionTypeId($value); $obj->save(); } } }
/** * This is a method for emulating ON DELETE CASCADE for DBs that don't support this * feature (like MySQL or SQLite). * * This method is not very speedy because it must perform a query first to get * the implicated records and then perform the deletes by calling those Peer classes. * * This method should be used within a transaction if possible. * * @param Criteria $criteria * @param PropelPDO $con * @return int The number of affected rows (if supported by underlying database driver). */ protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con) { // initialize var to track total num of affected rows $affectedRows = 0; // first find the objects that are implicated by the $criteria $objects = MissionTypePeer::doSelect($criteria, $con); foreach ($objects as $obj) { // delete related UserFilterMissionTypes objects $c = new Criteria(UserFilterMissionTypesPeer::DATABASE_NAME); $c->add(UserFilterMissionTypesPeer::MISSION_TYPE_ID, $obj->getId()); $affectedRows += UserFilterMissionTypesPeer::doDelete($c, $con); } return $affectedRows; }
/** * 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 = UserFilterMissionTypesPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setUserFilterId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setMissionTypeId($arr[$keys[1]]); } }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this MissionType is new, it will return * an empty collection; or if this MissionType has previously * been saved, it will retrieve related UserFilterMissionTypess 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 MissionType. */ public function getUserFilterMissionTypessJoinUserFilter($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(MissionTypePeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collUserFilterMissionTypess === null) { if ($this->isNew()) { $this->collUserFilterMissionTypess = array(); } else { $criteria->add(UserFilterMissionTypesPeer::MISSION_TYPE_ID, $this->id); $this->collUserFilterMissionTypess = UserFilterMissionTypesPeer::doSelectJoinUserFilter($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(UserFilterMissionTypesPeer::MISSION_TYPE_ID, $this->id); if (!isset($this->lastUserFilterMissionTypesCriteria) || !$this->lastUserFilterMissionTypesCriteria->equals($criteria)) { $this->collUserFilterMissionTypess = UserFilterMissionTypesPeer::doSelectJoinUserFilter($criteria, $con, $join_behavior); } } $this->lastUserFilterMissionTypesCriteria = $criteria; return $this->collUserFilterMissionTypess; }
/** * Retrieve object using using composite pkey values. * @param int $user_filter_id @param int $mission_type_id * @param PropelPDO $con * @return UserFilterMissionTypes */ public static function retrieveByPK($user_filter_id, $mission_type_id, PropelPDO $con = null) { $key = serialize(array((string) $user_filter_id, (string) $mission_type_id)); if (null !== ($obj = UserFilterMissionTypesPeer::getInstanceFromPool($key))) { return $obj; } if ($con === null) { $con = Propel::getConnection(UserFilterMissionTypesPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(UserFilterMissionTypesPeer::DATABASE_NAME); $criteria->add(UserFilterMissionTypesPeer::USER_FILTER_ID, $user_filter_id); $criteria->add(UserFilterMissionTypesPeer::MISSION_TYPE_ID, $mission_type_id); $v = UserFilterMissionTypesPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
public function executeSaveFilterForm(sfWebRequest $request) { //get all filters $f_date_range1 = $request->getParameter('date_range1'); $f_date_range2 = $request->getParameter('date_range2'); $weekdays = $request->getParameter('weekdays', array()); $f_wing = $request->getParameter('wing_id'); $f_ident = $request->getParameter('ident'); $f_city = $request->getParameter('city'); $f_zipcode = $request->getParameter('zipcode'); $f_state = $request->getParameter('state'); $f_location_type = $request->getParameter('location_type'); $f_origin = $request->getParameter('origin'); $f_dest = $request->getParameter('dest'); $needs_pilot = $request->getParameter('needs_pilot'); $co_pilot = $request->getParameter('co_pilot'); $ifr = $request->getParameter('ifr'); //mission types selected by default $arr = array(); if (sizeof($this->mission_types) > 0) { foreach ($this->mission_types as $ru) { $arr[] = $ru->getId(); } } $selected_types = $request->getParameter('selected_types[]', $arr); $f_filled = $request->getParameter('filled'); $f_open = $request->getParameter('open'); $f_maxpass = $request->getParameter('max_pass'); $f_maxwei = $request->getParameter('max_weight'); $f_maxdist = $request->getParameter('max_distance'); $f_mineff = $request->getParameter('min_efficiency'); $ignore_availability = $request->getParameter('ignore_availability'); $member_id = $request->getParameter('member_id'); #save filter $is_filter_saved = UserFilterPeer::getByPersonId($this->getUser()->getId()); if (!$is_filter_saved || !$is_filter_saved instanceof UserFilter) { $is_filter_saved = new UserFilter(); } $is_filter_saved->setPersonId($this->getUser()->getId()); $is_filter_saved->setDateRange1($f_date_range1); $is_filter_saved->setDateRange2($f_date_range2); $is_filter_saved->setDay1($weekdays[0] ? 1 : 0); $is_filter_saved->setDay2($weekdays[1] ? 1 : 0); $is_filter_saved->setDay3($weekdays[2] ? 1 : 0); $is_filter_saved->setDay4($weekdays[3] ? 1 : 0); $is_filter_saved->setDay5($weekdays[4] ? 1 : 0); $is_filter_saved->setDay6($weekdays[5] ? 1 : 0); $is_filter_saved->setDay7($weekdays[6] ? 1 : 0); $is_filter_saved->setWing($f_wing); $is_filter_saved->setIdent($f_ident); $is_filter_saved->setCity($f_city); $is_filter_saved->setZipcode($f_zipcode); $is_filter_saved->setState($f_state); $is_filter_saved->setOrgin($f_origin); $is_filter_saved->setDest($f_dest); $is_filter_saved->setIsPilot($needs_pilot); $is_filter_saved->setIsMa($co_pilot); $is_filter_saved->setIfrBackup($ifr); $is_filter_saved->setFilled($f_filled); $is_filter_saved->setOpen($f_open); $is_filter_saved->setMaxPassenger($f_maxpass); $is_filter_saved->setMaxWeight($f_maxwei); $is_filter_saved->setMaxDistance($f_maxdist); $is_filter_saved->setMaxEffciency($f_mineff); $is_filter_saved->setAvailability($ignore_availability); $is_filter_saved->save(); //now save selected mission types //before delete all previous mission types saved $c = new Criteria(); $c->add(UserFilterMissionTypesPeer::USER_FILTER_ID, $is_filter_saved->getId()); foreach (UserFilterMissionTypesPeer::doSelect($c) as $rUs) { $rUs->delete(); } //now add foreach ($selected_types as $key => $value) { $rUs = new UserFilterMissionTypes(); $rUs->setUserFilterId($is_filter_saved->getId()); $rUs->setMissionTypeId($value); $is_filter_saved->addUserFilterMissionTypes($rUs); } $is_filter_saved->save(); $this->getUser()->setFlash('success', 'Your current filters has saved!'); }