/**
* Get the associated Product object
*
* @param PropelPDO $con Optional Connection object.
* @param $doQuery Executes a query to get the object if required
* @return Product The associated Product object.
* @throws PropelException
*/
public function getProduct(PropelPDO $con = null, $doQuery = true)
{
if ($this->aProduct === null && $this->product_id !== null && $doQuery) {
$this->aProduct = ProductQuery::create()->findPk($this->product_id, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aProduct->addProductAssignments($this);
*/
}
return $this->aProduct;
}
/**
* Adds $delta to all Rank values that are >= $first and <= $last.
* '$delta' can also be negative.
*
* @param int $delta Value to be shifted by, can be negative
* @param int $first First node to be shifted
* @param int $last Last node to be shifted
* @param PropelPDO $con Connection to use.
*/
public static function shiftRank($delta, $first = null, $last = null, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(ProductPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$whereCriteria = ProductQuery::create();
if (null !== $first) {
$whereCriteria->add(ProductPeer::RANK_COL, $first, Criteria::GREATER_EQUAL);
}
if (null !== $last) {
$whereCriteria->addAnd(ProductPeer::RANK_COL, $last, Criteria::LESS_EQUAL);
}
$valuesCriteria = new Criteria(ProductPeer::DATABASE_NAME);
$valuesCriteria->add(ProductPeer::RANK_COL, array('raw' => ProductPeer::RANK_COL . ' + ?', 'value' => $delta), Criteria::CUSTOM_EQUAL);
BasePeer::doUpdate($whereCriteria, $valuesCriteria, $con);
ProductPeer::clearInstancePool();
}
/**
* Returns the number of related Product objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related Product objects.
* @throws PropelException
*/
public function countProducts(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
$partial = $this->collProductsPartial && !$this->isNew();
if (null === $this->collProducts || null !== $criteria || $partial) {
if ($this->isNew() && null === $this->collProducts) {
return 0;
}
if ($partial && !$criteria) {
return count($this->getProducts());
}
$query = ProductQuery::create(null, $criteria);
if ($distinct) {
$query->distinct();
}
return $query->filterByPrincipal($this)->count($con);
}
return count($this->collProducts);
}
/**
* Move the object to the bottom of the list
*
* @param PropelPDO $con optional connection
*
* @return integer the old object's rank
*/
public function moveToBottom(PropelPDO $con = null)
{
if ($this->isLast($con)) {
return false;
}
if ($con === null) {
$con = Propel::getConnection(ProductPeer::DATABASE_NAME);
}
$con->beginTransaction();
try {
$bottom = ProductQuery::create()->getMaxRankArray($con);
$res = $this->moveToRank($bottom, $con);
$con->commit();
return $res;
} catch (Exception $e) {
$con->rollback();
throw $e;
}
}
