Esempio n. 1
0
 /**
  * $request is the web request, for historical bc reasons. $options can currently
  * contain 'blogItemsOnly' => true to avoid returning the associated pages, useful
  * when we are just making a calendar with no titles etc.
  */
 protected function buildQuery($request, $options = array())
 {
     // We already know what page ids are relevant, now we're fetching author
     // information etc. per post. There's another method implicitly called later to populate
     // all of the blog content for the posts
     $q = Doctrine::getTable($this->modelClass)->createQuery()->leftJoin($this->modelClass . '.Author a');
     $blogItemsOnly = isset($options['blogItemsOnly']) && $options['blogItemsOnly'];
     if (count($this->info['pageIds'])) {
         // We have page ids, so we need a join to figure out which blog items we want.
         // Doctrine doesn't have a withIn mechanism that takes a nice clean array, but we
         // know these are clean IDs
         $q->innerJoin($this->modelClass . '.Page p WITH p.id IN (' . implode(',', $this->info['pageIds']) . ')');
         $q->leftJoin($this->modelClass . '.Categories c');
         // Oops: there is NO ordering with an IN clause alone, you must make that explicit
         if ($blogItemsOnly) {
             $q->select($q->getRootAlias() . '.*');
         }
         aDoctrine::orderByList($q, $this->info['pageIds'], 'p');
         // When you call aDoctrine::orderByList you must have an explicit select clause of your own as the
         // default 'select everything' behavior of Doctrine goes away as soon as that method calls addSelect
         if (!$blogItemsOnly) {
             $q->addSelect($q->getRootAlias() . '.*, a.*, p.*, c.*');
         }
     } else {
         $q->where('0 <> 0');
     }
     return $q;
 }
 public function getQuery()
 {
     // Explicit select() mandatory with orderByList
     $q = Doctrine::getTable($this->modelClass)->createQuery()->leftJoin($this->modelClass . '.Author a')->leftJoin($this->modelClass . '.Categories c')->select($this->modelClass . '.*, a.*, c.*');
     Doctrine::getTable($this->modelClass)->addPublished($q);
     if (isset($this->values['title_or_tag']) && $this->values['title_or_tag'] === 'title') {
         $this->handSelected = true;
         if (isset($this->values['blog_posts']) && count($this->values['blog_posts'])) {
             $q->andWhereIn('id', $this->values['blog_posts']);
             $q = aDoctrine::orderByList($q, $this->values['blog_posts']);
         } else {
             $q->andWhere('0 <> 0');
         }
         // Works way better when you actually return it!
         return $q;
     } else {
         if (isset($this->values['categories_list']) && count($this->values['categories_list']) > 0) {
             $q->andWhereIn('c.id', $this->values['categories_list']);
         }
         if (isset($this->values['tags_list']) && strlen($this->values['tags_list']) > 0) {
             PluginTagTable::getObjectTaggedWithQuery($q->getRootAlias(), $this->values['tags_list'], $q, array('nb_common_tags' => 1));
         }
         if (!isset($this->values['count'])) {
             $this->values['count'] = 3;
         }
         $q->limit($this->values['count']);
         $q->orderBy('published_at desc');
         return $q;
     }
 }
Esempio n. 3
0
 public function configure()
 {
     // ADD YOUR FIELDS HERE
     $this->widgetSchema['count'] = new sfWidgetFormInput(array(), array('size' => 2));
     $this->validatorSchema['count'] = new sfValidatorNumber(array('min' => 1, 'max' => 10));
     $this->widgetSchema->setHelp('count', '<span class="a-help-arrow"></span> Set the number of events to display – 10 max.');
     if (!$this->hasDefault('count')) {
         $this->setDefault('count', 3);
     }
     $choices = array('title' => 'By Title', 'tags' => 'By Category And Tag');
     $this->setWidget('title_or_tag', new sfWidgetFormChoice(array('choices' => $choices)));
     if (!$this->hasDefault('title_or_tag')) {
         $this->setDefault('title_or_tag', 'tags');
     }
     $this->setValidator('title_or_tag', new sfValidatorChoice(array('choices' => array_keys($choices))));
     // We'll progressively enhance this with autocomplete so no data is needed here...
     // except that we do need choices matching the previously saved values, otherwise
     // the Symfony widget has no idea how to render them
     // On the rendering pass we fetch the event titles already selected.
     // On the validation pass there will be no defaults, so we won't have to,
     // and shouldn't do a bad whereIn query that matches everything etc.
     $ids = $this->getDefault('blog_posts');
     $choices = array();
     if (count($ids)) {
         $q = Doctrine::getTable('aBlogItem')->createQuery('p')->select('p.*')->whereIn('p.id', $ids);
         aDoctrine::orderByList($q, $ids);
         $items = $q->execute();
         // Crucial to get the latest versions of titles and avoid expensive single queries
         aBlogItemTable::populatePages($items);
         foreach ($items as $item) {
             $choices[$item->id] = $item->getTitle();
         }
     }
     $this->setWidget('blog_posts', new sfWidgetFormChoice(array('multiple' => true, 'expanded' => false, 'choices' => $choices)));
     // TODO: really should be specific to events, requires adding a custom query
     $this->validatorSchema['blog_posts'] = new sfValidatorDoctrineChoice(array('model' => 'aBlogItem', 'multiple' => true, 'required' => false));
     $this->widgetSchema['categories_list'] = new sfWidgetFormDoctrineChoice(array('multiple' => true, 'model' => 'aCategory'));
     $this->validatorSchema['categories_list'] = new sfValidatorDoctrineChoice(array('model' => 'aCategory', 'multiple' => true, 'required' => false));
     $this->widgetSchema->setHelp('categories_list', '<span class="a-help-arrow"></span> Filter Events by Category');
     $this->getWidget('categories_list')->setOption('query', Doctrine::getTable('aCategory')->createQuery()->orderBy('aCategory.name asc'));
     $this->widgetSchema['tags_list'] = new sfWidgetFormInput(array(), array('class' => 'tag-input', 'autocomplete' => 'off'));
     $this->validatorSchema['tags_list'] = new sfValidatorString(array('required' => false));
     $this->widgetSchema->setHelp('tags_list', '<span class="a-help-arrow"></span> Filter Events by Tag');
     // Ensures unique IDs throughout the page
     $this->widgetSchema->setNameFormat('slot-form-' . $this->id . '[%s]');
     // You don't have to use our form formatter, but it makes things nice
     $this->widgetSchema->setFormFormatterName('aAdmin');
 }
 public function executeEdit(sfRequest $request)
 {
     $this->logMessage("====== in aSlideshowSlotActions::executeEdit", "info");
     if ($request->getParameter('aMediaCancel')) {
         return $this->redirectToPage();
     }
     $this->editSetup();
     $ids = preg_split('/,/', $request->getParameter('aMediaIds'));
     $q = Doctrine::getTable('aMediaItem')->createQuery('m')->select('m.*')->whereIn('m.id', $ids)->andWhere('m.type = "image"');
     // Let the query preserve order for us
     $items = aDoctrine::orderByList($q, $ids)->execute();
     $this->slot->unlink('MediaItems');
     $links = aArray::getIds($items);
     $this->slot->link('MediaItems', $links);
     // Save just the order in the value field. Use a hash so we can add
     // other metadata later
     $this->slot->value = serialize(array('order' => $links));
     $this->editSave();
 }
 public function getQuery()
 {
     // Explicit select() mandatory with orderByList
     $q = Doctrine::getTable($this->modelClass)->createQuery()->leftJoin($this->modelClass . '.Author a')->leftJoin($this->modelClass . '.Categories c')->select($this->modelClass . '.*, a.*, c.*');
     Doctrine::getTable($this->modelClass)->addPublished($q);
     if (isset($this->values['title_or_tag']) && $this->values['title_or_tag'] === 'title') {
         $this->handSelected = true;
         if (isset($this->values['blog_posts']) && count($this->values['blog_posts'])) {
             $q->andWhereIn('id', $this->values['blog_posts']);
             $q = aDoctrine::orderByList($q, $this->values['blog_posts']);
         } else {
             $q->andWhere('0 <> 0');
         }
         // Works way better when you actually return it!
         return $q;
     } else {
         if (isset($this->values['categories_list']) && count($this->values['categories_list']) > 0) {
             // This doesn't cut it because we wind up not knowing about the
             // other categories of each post, which breaks our "link to best page
             // for this post" algorithm
             // $q->andWhereIn('c.id', $this->values['categories_list']);
             // This would be nice but Doctrine croaks parsing it
             // $q->andWhere($this->modelClass . '.id IN (SELECT iblog.id FROM ' . $this->modelClass . ' iblog INNER JOIN iblog.Categories ic WITH ic.id IN ?)', array($this->values['categories_list']));
             // Let's cheat and use aMysql to pull the blog item IDs that have the relevant categories in a lightweight way,
             // then do a whereIn clause. It's not ideal, but it works well in practice
             $sql = new aMysql();
             $blogItemsForCategories = $sql->queryScalar('SELECT i.id FROM a_blog_item i INNER JOIN a_blog_item_to_category ic ON i.id = ic.blog_item_id AND ic.category_id IN :category_ids', array('category_ids' => $this->values['categories_list']));
             // So we use this after all, but we'll fetch all the categories for the posts in a second pass, sigh
             $q->andWhereIn($this->modelClass . '.id', $blogItemsForCategories);
         }
         if (isset($this->values['tags_list']) && strlen($this->values['tags_list']) > 0) {
             PluginTagTable::getObjectTaggedWithQuery($q->getRootAlias(), $this->values['tags_list'], $q, array('nb_common_tags' => 1));
         }
         if (!isset($this->values['count'])) {
             $this->values['count'] = 3;
         }
         $q->limit($this->values['count']);
         $q->orderBy('published_at desc');
         return $q;
     }
 }
 /**
  * DOCUMENT ME
  * @param sfRequest $request
  * @return mixed
  */
 public function executeEdit(sfRequest $request)
 {
     $this->logMessage("====== in aSlideshowSlotActions::executeEdit", "info");
     if ($request->getParameter('aMediaCancel')) {
         return $this->redirectToPage();
     }
     $this->editSetup();
     if ($request->hasParameter('aMediaIds')) {
         $ids = preg_split('/,/', $request->getParameter('aMediaIds'));
         $q = Doctrine::getTable('aMediaItem')->createQuery('m')->select('m.*')->whereIn('m.id', $ids)->andWhere('m.type = "image"');
         // Let the query preserve order for us
         $items = aDoctrine::orderByList($q, $ids)->execute();
         $this->slot->unlink('MediaItems');
         $links = aArray::getIds($items);
         $this->slot->link('MediaItems', $links);
         // This isn't a normal form submission, but the act of selecting items for a
         // slideshow implies we picked the 'selected' radio button, so just save 'form' as if
         // that choice had been saved normally
         $this->slot->value = serialize(array('form' => array('type' => 'selected'), 'order' => $links));
         return $this->editSave();
     }
 }
 public function executeEdit(sfRequest $request)
 {
     $this->logMessage("====== in aSlideshowSlotActions::executeEdit", "info");
     if ($request->getParameter('aMediaCancel')) {
         return $this->redirectToPage();
     }
     $this->editSetup();
     $ids = preg_split('/,/', $request->getParameter('aMediaIds'));
     $q = Doctrine::getTable('aMediaItem')->createQuery('m')->select('m.*')->whereIn('m.id', $ids)->andWhere('m.type = "image"');
     // Let the query preserve order for us
     $items = aDoctrine::orderByList($q, $ids)->execute();
     $this->slot->unlink('MediaItems');
     $links = aArray::getIds($items);
     $this->slot->link('MediaItems', $links);
     // Save just the order in the value field. Use a hash so we can add
     // other metadata later
     // Use getArrayValue and setArrayValue so that any additional fields that have been
     // added at the app level don't get smooshed
     $value = $this->slot->getArrayValue();
     $value['order'] = $links;
     $this->slot->setArrayValue($value);
     $this->editSave();
 }
Esempio n. 8
0
 public static function addSearchQueryWithScores(Doctrine_Table $table, Doctrine_Query $q = null, $luceneQuery, $culture, &$scores)
 {
     $name = $table->getOption('name');
     if (is_null($q)) {
         $q = Doctrine_Query::create()->from($name);
     }
     $scores = $table->searchLuceneWithScores($luceneQuery, $culture);
     $results = array_keys($scores);
     if (count($results)) {
         $alias = $q->getRootAlias();
         // Contrary to Jobeet the above is NOT enough, the results will
         // not be in Lucene result order. Use aDoctrine::orderByList to fix
         // that up in a portable way with a SQL92-compatible CASE statement.
         // Call addSelect so that we don't trash existing queries.
         $q->addSelect($alias . '.*');
         aDoctrine::orderByList($q, $results);
         $q->whereIn($alias . '.id', $results);
         $q->orderBy('field');
     } else {
         // Don't just let everything through when there are no hits!
         // Don't use just 'false', that is not guaranteed to be cross-database compatible.
         $q->andWhere('0 = 1');
     }
     return $q;
 }
Esempio n. 9
0
 /**
  * Retrieves media items matching the supplied array of ids, in the same order as the ids
  * (a simple whereIn does not do this). We must use an explicit select when using
  * aDoctrine::orderByList.
  * @param mixed $ids
  * @return mixed
  */
 public function findByIdsInOrder($ids)
 {
     if (empty($ids)) {
         // Doctrine doesn't generate any clause at all for WHERE IN if an array if false. This is a bug, but
         // it doesn't seem to be getting fixed at the Doctrine level
         return Doctrine::getTable('aMediaItem')->createQuery('m')->select('m.*')->where('1 = 0');
     }
     $q = Doctrine::getTable('aMediaItem')->createQuery('m')->select('m.*')->whereIn('m.id', $ids);
     // Don't forget to put them in order!
     return aDoctrine::orderByList($q, $ids)->execute();
 }