/**
* 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(WatchlistPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = WatchlistQuery::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;
}
}
$w->filterByItem($item);
$w->filterByUser($user);
$w->delete();
}
return $app->redirect($app['url_generator']->generate('watchlist'));
})->assert('dataId', '\\d+')->bind('watchlistremovepost');
/**
* ----------------------
* route /watchlistremoveall POST
* ----------------------
*/
$app->get("/watchlist/removeall", function (Request $request) use($app) {
if (!($user = $app['user'])) {
return $app->redirect($app['url_generator']->generate('login'));
}
$w = WatchlistQuery::create();
$w->filterByUser($user);
$w->delete();
return $app->redirect($app['url_generator']->generate('watchlist'));
})->bind('watchlistremoveall');
/**
* ----------------------
* route /watchlist GET
* ----------------------
*/
$app->get("/watchlist/{page}", function (Request $request, $page) use($app) {
if (!($user = $app['user'])) {
return $app->redirect($app['url_generator']->generate('login'));
}
$itemIds = array();
if ($ws = $user->getWatchlists()) {
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this User is new, it will return
* an empty collection; or if this User has previously
* been saved, it will retrieve related Watchlists from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in User.
*
* @param Criteria $criteria optional Criteria object to narrow the query
* @param PropelPDO $con optional connection object
* @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN)
* @return PropelObjectCollection|Watchlist[] List of Watchlist objects
*/
public function getWatchlistsJoinItem($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$query = WatchlistQuery::create(null, $criteria);
$query->joinWith('Item', $join_behavior);
return $this->getWatchlists($query, $con);
}