/** * Returns a new UserProductQuery object. * * @param string $modelAlias The alias of a model in the query * @param UserProductQuery|Criteria $criteria Optional Criteria to build the query from * * @return UserProductQuery */ public static function create($modelAlias = null, $criteria = null) { if ($criteria instanceof UserProductQuery) { return $criteria; } $query = new UserProductQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * 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(UserProductPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = UserProductQuery::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; } }
error('io-error', $e->getMessage()); } } else { return error('unknown-product', 'Product not found'); } }); }); $app->put('/products/:id/users', function ($id) use($app) { if_is_admin(function () use($app, $id) { $product = ProductQuery::create()->findPk($id); if ($product) { $data = json_decode($app->request()->getBody(), true); $res = array(); try { foreach ($data as $relation) { $op = UserProductQuery::create()->filterByProductId($id)->filterByUserId($relation['id'])->findOne(); $op->setExpires($relation['expires']); $op->save(); } ok($res); } catch (Exception $e) { error('io-error', $e->getMessage()); } } else { return error('unknown-product', 'Product not found'); } }); }); $app->delete('/products/:id/users', function ($id) use($app) { if_is_admin(function () use($app, $id) { $product = ProductQuery::create()->findPk($id);
/** * 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 UserProducts 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|UserProduct[] List of UserProduct objects */ public function getUserProductsJoinProduct($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $query = UserProductQuery::create(null, $criteria); $query->joinWith('Product', $join_behavior); return $this->getUserProducts($query, $con); }
public function hasActiveUser() { return UserProductQuery::create()->filterByProduct($this)->filterByExpires('now', Criteria::GREATER_EQUAL)->count() > 0; }