/** * Filter the query on the organization_role column * * @param mixed $organizationRole The value to use as filter * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @return UserOrganizationQuery The current query, for fluid interface * @throws PropelException - if the value is not accepted by the enum. */ public function filterByOrganizationRole($organizationRole = null, $comparison = null) { if (is_scalar($organizationRole)) { $organizationRole = UserOrganizationPeer::getSqlValueForEnum(UserOrganizationPeer::ORGANIZATION_ROLE, $organizationRole); } elseif (is_array($organizationRole)) { $convertedValues = array(); foreach ($organizationRole as $value) { $convertedValues[] = UserOrganizationPeer::getSqlValueForEnum(UserOrganizationPeer::ORGANIZATION_ROLE, $value); } $organizationRole = $convertedValues; if (null === $comparison) { $comparison = Criteria::IN; } } return $this->addUsingAlias(UserOrganizationPeer::ORGANIZATION_ROLE, $organizationRole, $comparison); }
/** * Retrieve object using using composite pkey values. * @param int $user_id * @param string $organization_id * @param PropelPDO $con * @return UserOrganization */ public static function retrieveByPK($user_id, $organization_id, PropelPDO $con = null) { $_instancePoolKey = serialize(array((string) $user_id, (string) $organization_id)); if (null !== ($obj = UserOrganizationPeer::getInstanceFromPool($_instancePoolKey))) { return $obj; } if ($con === null) { $con = Propel::getConnection(UserOrganizationPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(UserOrganizationPeer::DATABASE_NAME); $criteria->add(UserOrganizationPeer::USER_ID, $user_id); $criteria->add(UserOrganizationPeer::ORGANIZATION_ID, $organization_id); $v = UserOrganizationPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
/** * 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 BasePeer::TYPE_PHPNAME * * @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 = UserOrganizationPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setUserId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setOrganizationId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setOrganizationRole($arr[$keys[2]]); } }