PHP Doctrine_Query::whereIn方法代码示例

 public function modifyQuery(Doctrine_Query $query)
 {
     if (!$this->getNode()->isRoot()) {
         $nodes = $this->getNode()->getDescendants(null, true);
         if ($nodes) {
             $sectionIds = array();
             foreach ($nodes as $node) {
                 $sectionIds[] = $node->id;
             }
             $query->whereIn('t.talk_section_id', $sectionIds);
         }
     }
 }

 function buildQuery(Doctrine_Query $query)
 {
     $query->orderBy('swBlogComment.created_at ASC');
     $query->leftJoin('swBlogComment.swBlogPost');
     if ($this->getValue('moderated') == -2) {
         $query->whereIn('swBlogComment.moderated', array(swBlogComment::MODERATED_NONE, swBlogComment::MODERATED_OK));
     }
     if ($this->getValue('moderated') == -1) {
         $query->whereIn('swBlogComment.moderated', array(swBlogComment::MODERATED_NONE));
     }
     if ($this->getValue('moderated') == -3) {
         $query->whereIn('swBlogComment.moderated', array(swBlogComment::MODERATED_KO, swBlogComment::MODERATED_OK));
     }
     if ($this->getValue('moderated') == 1) {
         $query->whereIn('swBlogComment.moderated', array(swBlogComment::MODERATED_OK));
     }
     if ($this->getValue('moderated') === 0) {
         $query->whereIn('swBlogComment.moderated', array(swBlogComment::MODERATED_KO));
     }
     if (is_numeric($this->getValue('post_id'))) {
         $query->addWhere('swBlogComment.post_id = ?', $this->getValue('post_id'));
     }
     return $query;
 }

 public function linkInDb($alias, $ids)
 {
     $identifier = array_values($this->identifier());
     $identifier = array_shift($identifier);
     $rel = $this->getTable()->getRelation($alias);
     if ($rel instanceof Doctrine_Relation_Association) {
         $modelClassName = $rel->getAssociationTable()->getComponentName();
         $localFieldName = $rel->getLocalFieldName();
         $localFieldDef = $rel->getAssociationTable()->getColumnDefinition($localFieldName);
         if ($localFieldDef['type'] == 'integer') {
             $identifier = (int) $identifier;
         }
         $foreignFieldName = $rel->getForeignFieldName();
         $foreignFieldDef = $rel->getAssociationTable()->getColumnDefinition($foreignFieldName);
         if ($foreignFieldDef['type'] == 'integer') {
             for ($i = 0, $l = count($ids); $i < $l; $i++) {
                 $ids[$i] = (int) $ids[$i];
             }
         }
         foreach ($ids as $id) {
             $record = new $modelClassName();
             $record[$localFieldName] = $identifier;
             $record[$foreignFieldName] = $id;
             $record->save();
         }
     } else {
         if ($rel instanceof Doctrine_Relation_ForeignKey) {
             $q = new Doctrine_Query();
             $q->update($rel->getTable()->getComponentName())->set($rel->getForeign(), '?', array_values($this->identifier()));
             if (count($ids) > 0) {
                 $q->whereIn($rel->getTable()->getIdentifier(), $ids);
             }
             $q->execute();
         } else {
             if ($rel instanceof Doctrine_Relation_LocalKey) {
                 $q = new Doctrine_Query();
                 $q->update($this->getTable()->getComponentName())->set($rel->getLocalFieldName(), '?', $ids);
                 if (count($ids) > 0) {
                     $q->whereIn($rel->getTable()->getIdentifier(), array_values($this->identifier()));
                 }
                 $q->execute();
             }
         }
     }
     return $this;
 }

 /**
  * Create the query for selecting objects, eventually along with related
  * objects
  *
  * @param   array   $params  an array of criterions for the selection
  */
 public function addToQuery(Doctrine_Query $query, $params)
 {
     if (isset($sort)) {
         $query->orderBy($sort);
     }
     if (isset($params['id'])) {
         $values = explode(',', $params['id']);
         if (count($values) == 1) {
             $query->andWhere($this->model . '.id = ?', $values[0]);
         } else {
             $query->whereIn($this->model . '.id', $values);
         }
         unset($params['id']);
     }
     foreach ($params as $name => $value) {
         $query->andWhere($this->model . '.' . $name . ' = ?', $value);
     }
     return $query;
 }

 /**
  * Adds a new condition to the current query
  * $filter is the value to be filtered
  * $op is the opreand to be used: =,>=, like, llike,REGEX,
  * $completeField. use the index $completField['field'] to
  * specify the field, to avoid ambiguous
  *
  * @param $filter
  * @param $op
  * @param $completeField
  * @return Bvb_Grid_Source_Doctrine
  */
 public function addCondition($filter, $op, $completeField)
 {
     $field = $completeField['field'];
     /**
      * FIX : #218
      * We need to make sure to use HAVING when there is function
      * in the select, as you cannot use these selected fields in the
      * WHERE clause, and all others will use the WHERE clause
      */
     $func = 'addWhere';
     if (strpos($field, '(') !== false) {
         $func = 'addHaving';
     }
     switch (strtolower($op)) {
         case 'sqlexp':
             $this->_query->{$func}($filter);
             break;
         case 'isnull':
             $this->_query->{$func}($field . ' IS NULL ');
             break;
         case 'isnnotull':
             $this->_query->{$func}($field . ' IS NOT NULL ');
             break;
         case 'empty':
             $this->_query->{$func}($field . " =''");
             break;
         case 'equal':
         case '=':
             $this->_query->{$func}($field . ' = ?', $filter);
             break;
         case 'regex':
             $this->_query->{$func}($field . " REGEXP ?", $filter);
             break;
         case 'rlike':
             $this->_query->{$func}($field . " LIKE ?", $filter . "%");
             break;
         case 'llike':
             $this->_query->{$func}($field . " LIKE ?", "%" . $filter);
             break;
         case '>=':
             $this->_query->{$func}($field . " >= ?", $filter);
             break;
         case '>':
             $this->_query->{$func}($field . " > ?", $filter);
             break;
         case '<>':
         case '!=':
             $this->_query->{$func}($field . " <> ?", $filter);
             break;
         case '<=':
             $this->_query->{$func}($field . " <= ?", $filter);
             break;
         case '<':
             $this->_query->{$func}($field . " < ?", $filter);
             break;
         case 'in':
             $filter = explode(',', $filter);
             $this->_query->whereIn($field, $filter);
             break;
         case '&':
         case 'and':
         case 'AND':
         case 'flag':
         case 'FLAG':
             $this->_query->{$func}($field . " & ? <> 0", $filter);
             break;
         case 'range':
             $start = substr($filter, 0, strpos($filter, '<>'));
             $end = substr($filter, strpos($filter, '<>') + 2);
             $this->_query->{$func}($field . " between ? and ?", array($start, $end));
             break;
         case '||':
             $this->_query->orWhere($field . " LIKE ?", "%" . $filter . "%");
             break;
         case 'like':
         default:
             $this->_query->{$func}($field . " LIKE ?", "%" . $filter . "%");
             break;
     }
     return $this;
 }

 public function addTagsListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     } else {
         $values = array_keys($values);
     }
     if (!count($values)) {
         return;
     }
     $ids = Doctrine::getTable('tagging')->createQuery()->select('taggable_id')->leftJoin('tagging.Tag tag')->where('taggable_model = ?', $this->getModelName())->andWhereIn('tag.name', $values)->groupBy('taggable_id')->execute(array(), Doctrine::HYDRATE_SCALAR);
     $ids = array_map(create_function('$i', 'return $i["tagging_taggable_id"];'), $ids);
     if (empty($ids)) {
         $query->where('false');
     } else {
         $query->whereIn($query->getRootAlias() . '.id', $ids);
     }
 }

 /**
  * Applies the alarming attribute to a given query retrieving products.
  *
  * @param Doctrine_Query $query - query to have alarming attribute applied.
  * @param Integer $value - alarming?
  */
 public function applyDealIdFilter($query, $value)
 {
     $rootAlias = $query->getRootAlias();
     $dm = MongoManager::getDM();
     $yas = $dm->getRepository('Documents\\YiidActivity')->findBy(array('d_id' => intval($value)));
     $user_ids = array();
     foreach ($yas as $ya) {
         $user_ids[] = $ya->getUId();
     }
     $user_ids = array_unique($user_ids);
     if (count($user_ids) == 0) {
         $user_ids[] = -1;
     }
     $query->whereIn($rootAlias . '.id', $user_ids);
     return $query;
 }

 /**
  * unlink
  * removes links from this record to given records
  * if no ids are given, it removes all links
  *
  * @param string $alias     related component alias
  * @param array $ids        the identifiers of the related records
  * @return Doctrine_Record  this object
  */
 public function unlink($alias, $ids = array())
 {
     $ids = (array) $ids;
     $q = new Doctrine_Query();
     $rel = $this->getTable()->getRelation($alias);
     if ($rel instanceof Doctrine_Relation_Association) {
         $q->delete()->from($rel->getAssociationTable()->getComponentName())->where($rel->getLocal() . ' = ?', array_values($this->identifier()));
         if (count($ids) > 0) {
             $q->whereIn($rel->getForeign(), $ids);
         }
         $q->execute();
     } else {
         if ($rel instanceof Doctrine_Relation_ForeignKey) {
             $q->update($rel->getTable()->getComponentName())->set($rel->getForeign(), '?', array(null))->addWhere($rel->getForeign() . ' = ?', array_values($this->identifier()));
             if (count($ids) > 0) {
                 $q->whereIn($rel->getTable()->getIdentifier(), $ids);
             }
             $q->execute();
         }
     }
     if (isset($this->_references[$alias])) {
         foreach ($this->_references[$alias] as $k => $record) {
             if (in_array(current($record->identifier()), $ids)) {
                 $this->_references[$alias]->remove($k);
             }
         }
         $this->_references[$alias]->takeSnapshot();
     }
     return $this;
 }