/** * Filter the query on the confirmation column * * @param mixed $confirmation The value to use as filter * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @return PrincipalArchiveQuery The current query, for fluid interface * @throws PropelException - if the value is not accepted by the enum. */ public function filterByConfirmation($confirmation = null, $comparison = null) { if (is_scalar($confirmation)) { $confirmation = PrincipalArchivePeer::getSqlValueForEnum(PrincipalArchivePeer::CONFIRMATION, $confirmation); } elseif (is_array($confirmation)) { $convertedValues = array(); foreach ($confirmation as $value) { $convertedValues[] = PrincipalArchivePeer::getSqlValueForEnum(PrincipalArchivePeer::CONFIRMATION, $value); } $confirmation = $convertedValues; if (null === $comparison) { $comparison = Criteria::IN; } } return $this->addUsingAlias(PrincipalArchivePeer::CONFIRMATION, $confirmation, $comparison); }
/** * 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 = PrincipalArchivePeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setUserId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setName($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setNameSlug($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setDescription($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setExcerpt($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setGovermentLicense($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setJoinAt($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setAddress1($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setAddress2($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setCity($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setZipcode($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setCountryId($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setStateId($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setPhone($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setFax($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setMobile($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setEmail($arr[$keys[17]]); } if (array_key_exists($keys[18], $arr)) { $this->setWebsite($arr[$keys[18]]); } if (array_key_exists($keys[19], $arr)) { $this->setLogo($arr[$keys[19]]); } if (array_key_exists($keys[20], $arr)) { $this->setStatus($arr[$keys[20]]); } if (array_key_exists($keys[21], $arr)) { $this->setIsPrincipal($arr[$keys[21]]); } if (array_key_exists($keys[22], $arr)) { $this->setConfirmation($arr[$keys[22]]); } if (array_key_exists($keys[23], $arr)) { $this->setSortableRank($arr[$keys[23]]); } if (array_key_exists($keys[24], $arr)) { $this->setCreatedAt($arr[$keys[24]]); } if (array_key_exists($keys[25], $arr)) { $this->setUpdatedAt($arr[$keys[25]]); } if (array_key_exists($keys[26], $arr)) { $this->setArchivedAt($arr[$keys[26]]); } }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @return PrincipalArchive[] * @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(PrincipalArchivePeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(PrincipalArchivePeer::DATABASE_NAME); $criteria->add(PrincipalArchivePeer::ID, $pks, Criteria::IN); $objs = PrincipalArchivePeer::doSelect($criteria, $con); } return $objs; }