PHP kuserPeer::doSelectStmt方法代码示例

 /**
  * Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
  *
  * This will only work if the object has been saved and has a valid primary key set.
  *
  * @param      boolean $deep (optional) Whether to also de-associated any related objects.
  * @param      PropelPDO $con (optional) The PropelPDO connection to use.
  * @return     void
  * @throws     PropelException - if this object is deleted, unsaved or doesn't have pk match in db
  */
 public function reload($deep = false, PropelPDO $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("Cannot reload a deleted object.");
     }
     if ($this->isNew()) {
         throw new PropelException("Cannot reload an unsaved object.");
     }
     if ($con === null) {
         $con = Propel::getConnection(kuserPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     // We don't need to alter the object instance pool; we're just modifying this instance
     // already in the pool.
     kuserPeer::setUseCriteriaFilter(false);
     $stmt = kuserPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
     kuserPeer::setUseCriteriaFilter(true);
     $row = $stmt->fetch(PDO::FETCH_NUM);
     $stmt->closeCursor();
     if (!$row) {
         throw new PropelException('Cannot find matching row in the database to reload object values.');
     }
     $this->hydrate($row, 0, true);
     // rehydrate
     if ($deep) {
         // also de-associate any related objects?
         $this->collkshows = null;
         $this->lastkshowCriteria = null;
         $this->collentrys = null;
         $this->lastentryCriteria = null;
         $this->collcomments = null;
         $this->lastcommentCriteria = null;
         $this->collflags = null;
         $this->lastflagCriteria = null;
         $this->collfavorites = null;
         $this->lastfavoriteCriteria = null;
         $this->collKshowKusers = null;
         $this->lastKshowKuserCriteria = null;
         $this->collMailJobs = null;
         $this->lastMailJobCriteria = null;
         $this->collPuserKusers = null;
         $this->lastPuserKuserCriteria = null;
         $this->collPartners = null;
         $this->lastPartnerCriteria = null;
         $this->collmoderations = null;
         $this->lastmoderationCriteria = null;
         $this->collmoderationFlagsRelatedByKuserId = null;
         $this->lastmoderationFlagRelatedByKuserIdCriteria = null;
         $this->collmoderationFlagsRelatedByFlaggedKuserId = null;
         $this->lastmoderationFlagRelatedByFlaggedKuserIdCriteria = null;
         $this->collcategoryKusers = null;
         $this->lastcategoryKuserCriteria = null;
         $this->collUploadTokens = null;
         $this->lastUploadTokenCriteria = null;
         $this->collKuserToUserRoles = null;
         $this->lastKuserToUserRoleCriteria = null;
     }
     // if (deep)
 }

 public function getAllowedPartnerIds(partnerFilter $partnerFilter = null)
 {
     $currentLoginDataId = $this->getLoginDataId();
     if (!$currentLoginDataId) {
         return array($this->getPartnerId());
     }
     $c = new Criteria();
     $c->addSelectColumn(kuserPeer::PARTNER_ID);
     $c->addAnd(kuserPeer::LOGIN_DATA_ID, $currentLoginDataId, Criteria::EQUAL);
     $c->addAnd(kuserPeer::STATUS, KuserStatus::ACTIVE, Criteria::EQUAL);
     kuserPeer::setUseCriteriaFilter(false);
     $stmt = kuserPeer::doSelectStmt($c);
     $ids = $stmt->fetchAll(PDO::FETCH_COLUMN);
     kuserPeer::setUseCriteriaFilter(true);
     // apply filter on partner ids
     if ($partnerFilter) {
         $c = new Criteria();
         $c->addSelectColumn(PartnerPeer::ID);
         $partnerFilter->setIdIn($ids);
         $partnerFilter->attachToCriteria($c);
         $stmt = PartnerPeer::doSelectStmt($c);
         $ids = $stmt->fetchAll(PDO::FETCH_COLUMN);
     }
     return $ids;
 }

 /**
  * Method to do selects.
  *
  * @param      Criteria $criteria The Criteria object used to build the SELECT statement.
  * @param      PropelPDO $con
  * @return     array Array of selected Objects
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function doSelect(Criteria $criteria, PropelPDO $con = null)
 {
     return kuserPeer::populateObjects(kuserPeer::doSelectStmt($criteria, $con));
 }