/**
* 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 SubscriptionPeer::populateObjects(SubscriptionPeer::doSelectStmt($criteria, $con));
}
/**
* 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(SubscriptionPeer::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.
$stmt = SubscriptionPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
$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?
}
// if (deep)
}
public function getHoursPerWeek($activityId, $roomId)
{
if (!isset($this->hours_per_week_array[$activityId])) {
$c = SubscriptionPeer::getActiveCriteria();
$c = SubscriptionPeer::getHasRoomCriteria($roomId, $c);
$c->addAnd(SubscriptionPeer::CARD_ID, $this->getId(), Criteria::EQUAL);
$c->addAnd(SubscriptionPeer::ACTIVITY_ID, $activityId, Criteria::EQUAL);
$c->clearSelectColumns();
$c->addSelectColumn('MAX(' . SubscriptionPeer::HOURS_PER_WEEK . ')');
$c->setLimit(1);
$stmt = SubscriptionPeer::doSelectStmt($c);
if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$this->hours_per_week_array[$activityId] = $row[0];
return $row[0];
}
$this->hours_per_week_array[$activityId] = null;
return null;
} else {
return $this->hours_per_week_array[$activityId];
}
}
