<?php

/**
 * user actions.
 *
 * @package    aukce
 * @subpackage user
 * @author     Your name here
 * @version    SVN: $Id: actions.class.php 12474 2008-10-31 10:41:27Z fabien $
 */
class winnerActions extends sfActions
{
  public function executeIndex(sfWebRequest $request)
  {
      /*
       * uzavreni pripadnych neoznacenych aukci
       */
      $items_to_close = Doctrine::getTable('Item')
                            ->createQuery()
                            ->where('time_end < NOW()')
                            ->andWhere('is_finished = 0 OR is_finished IS NULL')
                            ->execute();
      if (count($items_to_close)) {
          foreach($items_to_close AS $item) {
              $item->is_finished = 1;
              $item->save();

              $user = $item->getuser();
              if (!empty($user)) {
                  $mailer = new itemMailer();
                  $mailer->emailWinner($item, $user);
              }
          }
      }


   $this->filtr = new ItemSoldFormFilter();
   $filtr_values = $request->getParameter($this->filtr->getName());

   $auctions_query = Doctrine::getTable('Item')->createQuery("a");
   $auctions_query->where('is_finished = 1');
   
   $this->filtr->bind($filtr_values);
   if (!empty($filtr_values) && $this->filtr->isValid()) {
        $date = explode(" - ",$filtr_values['time_end']['text']);
        
        if(isset($date[0]) && !empty($date[0])){
            $auctions_query = $this->auctions->andWhere("a.time_end >= '".date("Y-m-d",strtotime($date[0]))." 00:00:00'");
        }
        if(isset($date[1]) && !empty($date[1])){
            $auctions_query = $this->auctions->andWhere("a.time_end <= '".date("Y-m-d",strtotime($date[1]))." 23:59:59'");
        }
        $auctions_query = $this->auctions->execute();

   }


   $auctions_query->orderBy('time_end DESC');
    $this->auctions = $auctions_query->execute();
   
  }

  public function executeDone(sfWebRequest $request){
      $auction = Doctrine::getTable('Item')->find($request->getParameter('id'));
      $auction->status = 1;
      $auction->save();

      $this->redirect('winner/index');
  }

    public function executeRunning(sfWebRequest $request) {
        $this->auctions = Doctrine::getTable('Item')
                            ->createQuery()
                            ->where('time_start < NOW()')
                            ->andWhere('time_end > NOW()')
                            ->andWhere('is_finished = 0')
                            ->andWhere('price_actual > price_start')
                            ->orderBy('price_actual DESC')
                            ->execute();
    }
}