<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class ItemTable extends Doctrine_Table
{
    /*
     * Lucene fulltext
     */
    static public function getLuceneIndex() {
        ProjectConfiguration::registerZend();

        if (file_exists($index = self::getLuceneIndexFile())) {
            return Zend_Search_Lucene::open($index);
        } else {
            return Zend_Search_Lucene::create($index);
        }
    }

    static public function getLuceneIndexFile() {
        return sfConfig::get('sf_data_dir').'/lucene/item.index';
    }

    public function getForLuceneQuery($query) {
        $index = $this->getLuceneIndex();
        $hits = $index->find($query);

        $pks = array();
        foreach ($hits as $hit) {
            $pks[] = $hit->pk;
        }

        if (empty($pks)) {
            return array();
        }

        $q = $this->createQuery('p')
                  ->whereIn('p.id', $pks)
                  ->andWhere('p.is_published = 1')
                  ->andWhere('time_start < NOW()')
                  ->andWhere('time_end > NOW()')
                  ->andWhere('is_finished = 0')
                  ->limit(20);

        return $q->execute();
    }
}