/**
* Returns a new CategoryQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param CategoryQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return CategoryQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof CategoryQuery) {
return $criteria;
}
$query = new CategoryQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
public function viewAction()
{
$request = $this->getRequest();
$key = $request->getParam('url_key');
$this->view->category = CategoryQuery::create()->findOneByUrlKey($key);
$this->view->products = $this->view->category->getProducts();
}
</td>
</tr>
<?php
}
?>
<?php
if ($header == null) {
?>
<tr>
<td colspan="2" style="font-weight: bold;">Pending official rating</td>
</tr>
<?php
} else {
?>
<?php
$categories = CategoryQuery::create()->orderBySequence()->find();
$values = $header->getRatingValuesJoinCategoryOption();
?>
<th>Category</th>
<th colspan="1">Marks</th>
<?php
foreach ($categories as $category) {
?>
<?php
$first = true;
?>
<?php
foreach ($values as $value) {
?>
<?php
if ($value->getCategoryOption()->getCategoryId() == $category->getId() && $value->getCategoryOption()->getParentId() == null) {
/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @throws Exception
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(CategoryPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = CategoryQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}
public function updateLoanCategories(Loan $loan, $data)
{
$category = CategoryQuery::create()->findOneById($data['category']);
$secondaryCategory = CategoryQuery::create()->findOneById($data['secondaryCategory']);
$loan->setCategory($category)->setSecondaryCategory($secondaryCategory);
$loan->save();
}
public function preDispatch()
{
$this->view->categories = CategoryQuery::create()->find();
}
/**
* Get the associated Category object
*
* @param PropelPDO $con Optional Connection object.
* @param $doQuery Executes a query to get the object if required
* @return Category The associated Category object.
* @throws PropelException
*/
public function getCategory(PropelPDO $con = null, $doQuery = true)
{
if ($this->aCategory === null && $this->category_id !== null && $doQuery) {
$this->aCategory = CategoryQuery::create()->findPk($this->category_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->aCategory->addProducts($this);
*/
}
return $this->aCategory;
}