Exemplo n.º 1
0
 /**
  * Processes the pending join conditions, used for dynamically add conditions 
  * to root component/joined components without interfering in the main dql
  * handling.
  * 
  * @param string $alias Component Alias
  * @return Processed pending conditions
  */
 protected function _processPendingJoinConditions($alias)
 {
     $parts = array();
     if ($alias !== null && isset($this->_pendingJoinConditions[$alias])) {
         $parser = new Doctrine_Query_JoinCondition($this, $this->_tokenizer);
         foreach ($this->_pendingJoinConditions[$alias] as $joinCondition) {
             $parts[] = $parser->parse($joinCondition);
         }
         // FIX #1860 and #1876: Cannot unset them, otherwise query cannot be reused later
         //unset($this->_pendingJoinConditions[$alias]);
     }
     return count($parts) > 0 ? '(' . implode(') AND (', $parts) . ')' : '';
 }
Exemplo n.º 2
0
 /**
  * _buildSqlFromPart
  * builds the from part of the query and returns it
  *
  * @return string   the query sql from part
  */
 protected function _buildSqlFromPart()
 {
     $q = '';
     foreach ($this->_sqlParts['from'] as $k => $part) {
         if ($k === 0) {
             $q .= $part;
             continue;
         }
         // preserve LEFT JOINs only if needed
         // Check if it's JOIN, if not add a comma separator instead of space
         if (!preg_match('/\\bJOIN\\b/i', $part) && !isset($this->_pendingJoinConditions[$k])) {
             $q .= ', ' . $part;
         } else {
             $e = explode(' ', $part);
             if (substr($part, 0, 9) === 'LEFT JOIN') {
                 $aliases = array_merge($this->_subqueryAliases, array_keys($this->_neededTables));
                 if (!in_array($e[3], $aliases) && !in_array($e[2], $aliases) && !empty($this->_pendingFields)) {
                     continue;
                 }
             }
             if (isset($this->_pendingJoinConditions[$k])) {
                 $parser = new Doctrine_Query_JoinCondition($this, $this->_tokenizer);
                 if (strpos($part, ' ON ') !== false) {
                     $part .= ' AND ';
                 } else {
                     $part .= ' ON ';
                 }
                 $part .= $parser->parse($this->_pendingJoinConditions[$k]);
                 unset($this->_pendingJoinConditions[$k]);
             }
             $componentAlias = $this->getComponentAlias($e[3]);
             $string = $this->getInheritanceCondition($componentAlias);
             if ($string) {
                 $q .= ' ' . $part . ' AND ' . $string;
             } else {
                 $q .= ' ' . $part;
             }
         }
         $this->_sqlParts['from'][$k] = $part;
     }
     return $q;
 }
Exemplo n.º 3
0
 /**
  * Processes the pending join conditions, used for dynamically add conditions 
  * to root component/joined components without interferring in the main dql
  * processment.
  * 
  * @param string $alias Component Alias
  * @return Processed pending conditions
  */
 protected function _processPendingJoinConditions($alias)
 {
     $part = '';
     if ($alias !== null && isset($this->_pendingJoinConditions[$alias])) {
         $parser = new Doctrine_Query_JoinCondition($this, $this->_tokenizer);
         $part = $parser->parse($this->_pendingJoinConditions[$alias]);
         unset($this->_pendingJoinConditions[$alias]);
     }
     return $part;
 }
Exemplo n.º 4
0
 /**
  * Processes the pending join conditions, used for dynamically add conditions 
  * to root component/joined components without interferring in the main dql
  * processment.
  * 
  * @param string $alias Component Alias
  * @return Processed pending conditions
  */
 protected function _processPendingJoinConditions($alias)
 {
     $part = '';
     if ($alias !== null && isset($this->_pendingJoinConditions[$alias])) {
         $parser = new Doctrine_Query_JoinCondition($this, $this->_tokenizer);
         $part = $parser->parse($this->_pendingJoinConditions[$alias]);
         // FIX #1860 and #1876: Cannot unset them, otherwise query cannot be reused later
         //unset($this->_pendingJoinConditions[$alias]);
     }
     return $part;
 }
Exemplo n.º 5
0
 /**
  * buildFromPart
  * builds the from part of the query and returns it
  *
  * @return string   the query sql from part
  */
 public function buildFromPart()
 {
     $q = '';
     foreach ($this->parts['from'] as $k => $part) {
         if ($k === 0) {
             $q .= $part;
             continue;
         }
         // preserve LEFT JOINs only if needed
         if (substr($part, 0, 9) === 'LEFT JOIN') {
             $e = explode(' ', $part);
             $aliases = array_merge($this->subqueryAliases, array_keys($this->neededTables));
             if (!in_array($e[3], $aliases) && !in_array($e[2], $aliases) && !empty($this->pendingFields)) {
                 continue;
             }
         }
         if (isset($this->_pendingJoinConditions[$k])) {
             $parser = new Doctrine_Query_JoinCondition($this);
             $part .= ' AND ' . $parser->parse($this->_pendingJoinConditions[$k]);
             unset($this->_pendingJoinConditions[$k]);
         }
         $q .= ' ' . $part;
         $this->parts['from'][$k] = $part;
     }
     return $q;
 }