public function executeShowArchive(sfWebRequest $request)
{
$c = new Criteria();
$year = $request->getParameter('year');
$month = $request->getParameter('month');
$nextMonth = mktime(0, 0, 0, $month + 1, 0, $year);
$thisMonth = mktime(0, 0, 0, $month, 0, $year);
$c->add(ArticlePeer::CREATED_AT, $nextMonth, Criteria::LESS_THAN);
$c->addAnd(ArticlePeer::CREATED_AT, $thisMonth, Criteria::GREATER_THAN);
// $c->addAnd(ArticlePeer::CREATED_AT,$thisMonth,'GREATERTHAN');
$this->posts = ArticlePeer::doSelect($c);
}
/**
* Gets an array of Article 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 Book has previously been saved, it will retrieve
* related Articles from storage. If this Book 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 Article[]
* @throws PropelException
*/
public function getArticles($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(BookPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collArticles === null) {
if ($this->isNew()) {
$this->collArticles = array();
} else {
$criteria->add(ArticlePeer::BOOK_ID, $this->id);
ArticlePeer::addSelectColumns($criteria);
$this->collArticles = ArticlePeer::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(ArticlePeer::BOOK_ID, $this->id);
ArticlePeer::addSelectColumns($criteria);
if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) {
$this->collArticles = ArticlePeer::doSelect($criteria, $con);
}
}
}
$this->lastArticleCriteria = $criteria;
return $this->collArticles;
}
/**
* 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(ArticlePeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(ArticlePeer::DATABASE_NAME);
$criteria->add(ArticlePeer::ID, $pks, Criteria::IN);
$objs = ArticlePeer::doSelect($criteria, $con);
}
return $objs;
}
public function getArticles($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseArticlePeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collArticles === null) {
if ($this->isNew()) {
$this->collArticles = array();
} else {
$criteria->add(ArticlePeer::CATEGORY_ID, $this->getId());
ArticlePeer::addSelectColumns($criteria);
$this->collArticles = ArticlePeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(ArticlePeer::CATEGORY_ID, $this->getId());
ArticlePeer::addSelectColumns($criteria);
if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) {
$this->collArticles = ArticlePeer::doSelect($criteria, $con);
}
}
}
$this->lastArticleCriteria = $criteria;
return $this->collArticles;
}
public function getArticles($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(CategoryPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collArticles === null) {
if ($this->isNew()) {
$this->collArticles = array();
} else {
$criteria->add(ArticlePeer::CATEGORY_ID, $this->id);
ArticlePeer::addSelectColumns($criteria);
$this->collArticles = ArticlePeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(ArticlePeer::CATEGORY_ID, $this->id);
ArticlePeer::addSelectColumns($criteria);
if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) {
$this->collArticles = ArticlePeer::doSelect($criteria, $con);
}
}
}
$this->lastArticleCriteria = $criteria;
return $this->collArticles;
}
/**
* @WSMethod(name='getFixtureModel')
*
* @return Article[] All articles loaded from the database.
*/
public function executeGetFixtureModel(sfWebRequest $request)
{
$this->result = ArticlePeer::doSelect(new Criteria());
return sfView::SUCCESS;
}
public function executeArchiveList()
{
$c = new Criteria();
$c->addDescendingOrderByColumn('created_at');
$this->posts = ArticlePeer::doSelect($c);
}
public function executeShoppingCart2(sfWebRequest $request)
{
$this->categories = CategoryPeer::getActiveCategories();
$this->paths = array();
$promoter = $promoter = PromoterPeer::getPromoterByUserId($this->getUser()->getId());
$this->state = $promoter->getIdState();
$this->articles = ArticlePeer::doSelect(new Criteria());
if ($request->isMethod('post')) {
$cart = $this->createCartIfNotExists();
foreach ($this->articles as $key => $article) {
$value = $request->getParameter($article->getId());
if ($value > 0) {
$this->createCartArticle($cart, $article, $value);
}
}
}
$cart = CartPeer::getCart($promoter->getClientId());
if (!isset($cart)) {
$cart = new Cart();
}
$this->cart_articles = $cart->getCartArticles();
//sacar articulos mayor a 1 mes en el carrito
foreach ($this->cart_articles as $cart_article) {
$fecha = $this->dateadd($cart_article->getUpdatedAt(), 0, 1, 0, 0, 0, 0);
$date1 = new DateTime("now");
$date2 = new DateTime($fecha);
if ($date1 > $date2) {
$cart_article->delete();
$cart_article->save();
}
}
$this->total = 0;
foreach ($this->cart_articles as $cart_article) {
$this->total += $cart_article->getPrice() * $cart_article->getQuantity();
}
}
