Doctrine\DBAL\Query\QueryBuilder::join PHP Méthode

QueryBuilder Interface Documentation Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::join Afficher le fichier Open project: doctrine/dbal

join() public méthode


    $qb = $conn->createQueryBuilder()
        ->select('u.name')
        ->from('users', 'u')
        ->join('u', 'phonenumbers', 'p', 'p.is_primary = 1');

public join ( string $fromAlias, string $join, string $alias, string $condition = null )
$fromAlias	string	The alias that points to a from clause.
$join	string	The table name to join.
$alias	string	The alias of the join table.
$condition	string	The condition for the join.

    public function join($fromAlias, $join, $alias, $condition = null)
    {
        return $this->innerJoin($fromAlias, $join, $alias, $condition);
    }

Usage Example

Exemple #1

Afficher le fichier

Fichier : ChartQuery.php Projet : Yame-/mautic

 /**
  * Apply where filters to the query
  *
  * @param  QueryBuilder $query
  * @param  array        $filters
  */
 public function applyFilters(&$query, $filters)
 {
     if ($filters && is_array($filters)) {
         foreach ($filters as $column => $value) {
             $valId = $column . '_val';
             // Special case: Lead list filter
             if ($column === 'leadlist_id') {
                 $query->join('t', MAUTIC_TABLE_PREFIX . 'lead_lists_leads', 'lll', 'lll.lead_id = ' . $value['list_column_name']);
                 $query->andWhere('lll.leadlist_id = :' . $valId);
                 $query->setParameter($valId, $value['value']);
             } elseif (isset($value['expression']) && method_exists($query->expr(), $value['expression'])) {
                 $query->andWhere($query->expr()->{$value['expression']}($column));
                 if (isset($value['value'])) {
                     $query->setParameter($valId, $value['value']);
                 }
             } else {
                 if (is_array($value)) {
                     $query->andWhere('t.' . $column . ' IN(:' . $valId . ')');
                     $query->setParameter($valId, implode(',', $value));
                 } else {
                     $query->andWhere('t.' . $column . ' = :' . $valId);
                     $query->setParameter($valId, $value);
                 }
             }
         }
     }
 }

All Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::join

QueryBuilder

__clone

__construct

__toString

add

addGroupBy

addOrderBy

addSelect

andHaving

andWhere

createNamedParameter