public static function isNew($modelName)
{
$c = new Criteria();
$c->add(ModelPeer::MODEL_NAME, $modelName, Criteria::EQUAL);
$models = ModelPeer::doSelect($c);
if (count($models) > 0) {
return false;
} else {
return true;
}
}
public function execute($request)
{
$seriesName = $this->getRequestParameter('series');
$query = $this->getRequestParameter('query');
//load series
$cSeries = new Criteria();
$cSeries->add(SeriesPeer::SERIES_NAME, $seriesName, Criteria::EQUAL);
$series = SeriesPeer::doSelectOne($cSeries);
//get models for this series
$cModel = new Criteria();
$cModel->add(ModelPeer::SERIES_ID, $series->getId());
$cModel->add(ModelPeer::MODEL_NAME, $query . '%', Criteria::LIKE);
$cModel->addGroupByColumn(ModelPeer::MODEL_NAME);
$cModel->addAscendingOrderByColumn(ModelPeer::MODEL_NAME);
$cModel->setLimit(15);
$this->models = ModelPeer::doSelect($cModel);
$this->getResponse()->setContentType('application/json');
}
public function executeListMoveDown(sfWebRequest $request)
{
$id = $request->getParameter('id');
$current = ModelPeer::retrieveByPK($id);
$items = ModelPeer::doSelect(new Criteria());
for ($i = count($items) - 2; $i >= 0; $i--) {
//echo $items[$i];
if ($items[$i]->getId() == $id) {
$tmp = $items[$i + 1]->getWeight();
$items[$i + 1]->setWeight($tmp != $items[$i]->getWeight() ? $items[$i]->getWeight() : $items[$i]->getWeight() + 1);
$items[$i]->setWeight($tmp);
$items[$i]->save();
$items[$i + 1]->save();
break;
}
}
$this->redirect('model');
}
/**
* Gets an array of Model objects which contain a foreign key that references this object.
*
* If this collection has already been initialized with an identical Criteria, it returns the collection.
* Otherwise if this Score has previously been saved, it will retrieve
* related Models from storage. If this Score is new, it will return
* an empty collection or the current collection, the criteria is ignored on a new object.
*
* @param PropelPDO $con
* @param Criteria $criteria
* @return array Model[]
* @throws PropelException
*/
public function getModels($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(ScorePeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collModels === null) {
if ($this->isNew()) {
$this->collModels = array();
} else {
$criteria->add(ModelPeer::SCORE_ID, $this->id);
ModelPeer::addSelectColumns($criteria);
$this->collModels = ModelPeer::doSelect($criteria, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(ModelPeer::SCORE_ID, $this->id);
ModelPeer::addSelectColumns($criteria);
if (!isset($this->lastModelCriteria) || !$this->lastModelCriteria->equals($criteria)) {
$this->collModels = ModelPeer::doSelect($criteria, $con);
}
}
}
$this->lastModelCriteria = $criteria;
return $this->collModels;
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @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(ModelPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(ModelPeer::DATABASE_NAME);
$criteria->add(ModelPeer::ID, $pks, Criteria::IN);
$objs = ModelPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeGetModels(sfWebRequest $request)
{
$c = new Criteria();
$c->add(ModelPeer::SERIES_ID, $request->getGetParameter('series_id'));
$this->models = ModelPeer::doSelect($c);
}
