FileMaster

Edit File: SizeFunction.php

<?php
declare (strict_types=1);
namespace MailPoetVendor\Doctrine\ORM\Query\AST\Functions;
if (!defined('ABSPATH')) exit;
use MailPoetVendor\Doctrine\ORM\Mapping\ClassMetadata;
use MailPoetVendor\Doctrine\ORM\Query\AST\PathExpression;
use MailPoetVendor\Doctrine\ORM\Query\Parser;
use MailPoetVendor\Doctrine\ORM\Query\SqlWalker;
use MailPoetVendor\Doctrine\ORM\Query\TokenType;
use function assert;
class SizeFunction extends FunctionNode
{
 public $collectionPathExpression;
 public function getSql(SqlWalker $sqlWalker)
 {
 assert($this->collectionPathExpression->field !== null);
 $entityManager = $sqlWalker->getEntityManager();
 $platform = $entityManager->getConnection()->getDatabasePlatform();
 $quoteStrategy = $entityManager->getConfiguration()->getQuoteStrategy();
 $dqlAlias = $this->collectionPathExpression->identificationVariable;
 $assocField = $this->collectionPathExpression->field;
 $class = $sqlWalker->getMetadataForDqlAlias($dqlAlias);
 $assoc = $class->associationMappings[$assocField];
 $sql = 'SELECT COUNT(*) FROM ';
 if ($assoc['type'] === ClassMetadata::ONE_TO_MANY) {
 $targetClass = $entityManager->getClassMetadata($assoc['targetEntity']);
 $targetTableAlias = $sqlWalker->getSQLTableAlias($targetClass->getTableName());
 $sourceTableAlias = $sqlWalker->getSQLTableAlias($class->getTableName(), $dqlAlias);
 $sql .= $quoteStrategy->getTableName($targetClass, $platform) . ' ' . $targetTableAlias . ' WHERE ';
 $owningAssoc = $targetClass->associationMappings[$assoc['mappedBy']];
 $first = \true;
 foreach ($owningAssoc['targetToSourceKeyColumns'] as $targetColumn => $sourceColumn) {
 if ($first) {
 $first = \false;
 } else {
 $sql .= ' AND ';
 }
 $sql .= $targetTableAlias . '.' . $sourceColumn . ' = ' . $sourceTableAlias . '.' . $quoteStrategy->getColumnName($class->fieldNames[$targetColumn], $class, $platform);
 }
 } else {
 // many-to-many
 $targetClass = $entityManager->getClassMetadata($assoc['targetEntity']);
 $owningAssoc = $assoc['isOwningSide'] ? $assoc : $targetClass->associationMappings[$assoc['mappedBy']];
 $joinTable = $owningAssoc['joinTable'];
 // SQL table aliases
 $joinTableAlias = $sqlWalker->getSQLTableAlias($joinTable['name']);
 $sourceTableAlias = $sqlWalker->getSQLTableAlias($class->getTableName(), $dqlAlias);
 // join to target table
 $sql .= $quoteStrategy->getJoinTableName($owningAssoc, $targetClass, $platform) . ' ' . $joinTableAlias . ' WHERE ';
 $joinColumns = $assoc['isOwningSide'] ? $joinTable['joinColumns'] : $joinTable['inverseJoinColumns'];
 $first = \true;
 foreach ($joinColumns as $joinColumn) {
 if ($first) {
 $first = \false;
 } else {
 $sql .= ' AND ';
 }
 $sourceColumnName = $quoteStrategy->getColumnName($class->fieldNames[$joinColumn['referencedColumnName']], $class, $platform);
 $sql .= $joinTableAlias . '.' . $joinColumn['name'] . ' = ' . $sourceTableAlias . '.' . $sourceColumnName;
 }
 }
 return '(' . $sql . ')';
 }
 public function parse(Parser $parser)
 {
 $parser->match(TokenType::T_IDENTIFIER);
 $parser->match(TokenType::T_OPEN_PARENTHESIS);
 $this->collectionPathExpression = $parser->CollectionValuedPathExpression();
 $parser->match(TokenType::T_CLOSE_PARENTHESIS);
 }
}

Back