studiomado / query-bundle

src/Mado/QueryBundle/Repositories/BaseRepository.php

Braces +3 added lines, -1 removed lines

@@ -483,7 +483,9 @@
 
         $c = 0;
         foreach($updateFields as $column => $value) {
-            if($c>0)$sql .= ", ";
+            if($c>0) {
+                $sql .= ", ";
+            }
             $sql .= '`'.$column . "` = '". $value."'";
             $c++;
         }

Spacing +16 added lines, -16 removed lines

@@ -49,8 +49,8 @@ 
 
         $this->fields = array_keys($this->getClassMetadata()->fieldMappings);
 
-        $entityName = explode('\\', strtolower($this->getEntityName()) );
-        $entityName = $entityName[count($entityName)-1];
+        $entityName = explode('\\', strtolower($this->getEntityName()));
+        $entityName = $entityName[count($entityName) - 1];
         $entityAlias = $entityName[0];
         $this->entityAlias = $entityAlias;
 
@@ -132,7 +132,7 @@ 
         foreach ($orFilters as $key => $filter) {
             if (is_array($filter)) {
                 foreach ($filter as $keyInternal => $internal) {
-                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
+                    $filterOrCorrected[$keyInternal . '|' . $count] = $internal;
                     $count = $count + 1;
                 }
             } else {
@@ -184,7 +184,7 @@ 
         foreach ($orFilters as $key => $filter) {
             if (is_array($filter)) {
                 foreach ($filter as $keyInternal => $internal) {
-                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
+                    $filterOrCorrected[$keyInternal . '|' . $count] = $internal;
                     $count = $count + 1;
                 }
             } else {
@@ -231,7 +231,7 @@ 
         foreach ($orFilters as $key => $filter) {
             if (is_array($filter)) {
                 foreach ($filter as $keyInternal => $internal) {
-                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
+                    $filterOrCorrected[$keyInternal . '|' . $count] = $internal;
                     $count = $count + 1;
                 }
             } else {
@@ -288,7 +288,7 @@ 
         $pagerAdapter = new DoctrineORMAdapter($queryBuilder);
 
         $query = $pagerAdapter->getQuery();
-        if(isset($this->use_result_cache) and $this->use_result_cache){
+        if (isset($this->use_result_cache) and $this->use_result_cache) {
             $query->useResultCache(true, 600);
         }
 
@@ -327,7 +327,7 @@ 
             $params[$itemValue] = $this->queryOptions->get($itemValue);
         }
 
-        if(!isset($this->route_name)){
+        if (!isset($this->route_name)) {
             $this->route_name = $this->queryOptions->get('_route');
         }
 
@@ -338,7 +338,7 @@ 
     public function noExistsJoin($prevEntityAlias, $currentEntityAlias)
     {
         $needle = $prevEntityAlias . "_" . $currentEntityAlias;
-        return ! in_array($needle, $this->joins);
+        return !in_array($needle, $this->joins);
     }
 
     /** @deprecate use QueryBuilderFatory instead */
@@ -446,8 +446,8 @@ 
 
     public function getEntityAlias(string $entityName) : string
     {
-        $arrayEntityName = explode('\\', strtolower($entityName) );
-        $entityAlias = $arrayEntityName[count($arrayEntityName)-1];
+        $arrayEntityName = explode('\\', strtolower($entityName));
+        $entityAlias = $arrayEntityName[count($arrayEntityName) - 1];
         return $entityAlias;
     }
 
@@ -532,16 +532,16 @@ 
 
         $table = $this->getEntityManager()->getClassMetadata($this->getEntityName())->getTableName();
 
-        $sql = 'INSERT INTO '.$table;
-        $sql .= '('. $list_keys . ') ';
+        $sql = 'INSERT INTO ' . $table;
+        $sql .= '(' . $list_keys . ') ';
         //$sql .= 'VALUES("'.implode('","', $insertFields).'") ';
-        $sql .= "VALUES(". $list_values.") ";
+        $sql .= "VALUES(" . $list_values . ") ";
         $sql .= 'ON DUPLICATE KEY UPDATE ';
 
         $c = 0;
-        foreach($updateFields as $column => $value) {
-            if($c>0)$sql .= ", ";
-            $sql .= '`'.$column . "` = '". $value."'";
+        foreach ($updateFields as $column => $value) {
+            if ($c > 0)$sql .= ", ";
+            $sql .= '`' . $column . "` = '" . $value . "'";
             $c++;
         }
 

src/Mado/QueryBundle/DependencyInjection/MadoQueryExtension.php

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
         $configuration = new Configuration();
         $config = $this->processConfiguration($configuration, $configs);
 
-        $loader = new Loader\YamlFileLoader($container, new FileLocator(__DIR__.'/../Resources/config'));
+        $loader = new Loader\YamlFileLoader($container, new FileLocator(__DIR__ . '/../Resources/config'));
         $loader->load('services.yml');
     }
 }

src/Mado/QueryBundle/Queries/QueryBuilderFactory.php

Spacing +24 added lines, -24 removed lines

@@ -107,7 +107,7 @@ 
 
         $needle = $prevEntityAlias . "_" . $currentEntityAlias;
 
-        return ! in_array($needle, $this->joins);
+        return !in_array($needle, $this->joins);
     }
 
     private function storeJoin($prevEntityAlias, $currentEntityAlias)
@@ -213,13 +213,13 @@ 
     private function applyFilterAnd($filter, $value)
     {
         $whereCondition = null;
-        $filterAndOperator = explode('|',$filter);
+        $filterAndOperator = explode('|', $filter);
 
         $fieldName = $filterAndOperator[0];
         $fieldName = $this->parser->camelize($fieldName);
 
         $operator = $this->getValueAvailableFilters()[self::DEFAULT_OPERATOR];
-        if(isset($filterAndOperator[1])){
+        if (isset($filterAndOperator[1])) {
             $operator = $this->getValueAvailableFilters()[$filterAndOperator[1]];
         }
 
@@ -239,10 +239,10 @@ 
             // $filterAndOperator[1] = 'bar'
             if (isset($filterAndOperator[1])) {
                 if ('list' == $filterAndOperator[1]) {
-                    $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' (:field_'.$fieldName . $salt . ')';
+                    $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' (:field_' . $fieldName . $salt . ')';
                 } else if ('field_eq' == $filterAndOperator[1]) {
                     $whereCondition =
-                        $this->entityAlias . '.' . $fieldName . ' '.
+                        $this->entityAlias . '.' . $fieldName . ' ' .
                         $operator['meta'] . '' .
                         $this->entityAlias . '.' . $value
                         ;
@@ -251,10 +251,10 @@ 
                     //'Oops! Eccezzione'
                     //);
                 } else {
-                    $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' :field_'.$fieldName . $salt;
+                    $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' :field_' . $fieldName . $salt;
                 }
             } else {
-                $whereCondition = $this->entityAlias.'.'.$fieldName.' = :field_'.$fieldName . $salt;
+                $whereCondition = $this->entityAlias . '.' . $fieldName . ' = :field_' . $fieldName . $salt;
             }
 
             $this->qBuilder->andWhere($whereCondition);
@@ -275,7 +275,7 @@ 
         } else {
             $isNotARelation = 0 !== strpos($fieldName, 'Embedded.');
             if ($isNotARelation) {
-                $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' ' . $this->entityAlias . '.' . $value;
+                $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' ' . $this->entityAlias . '.' . $value;
                 $this->qBuilder->andWhere($whereCondition);
             }
         }
@@ -288,7 +288,7 @@ 
             $relationEntityAlias = $this->getRelationEntityAlias();
 
             $embeddedFields = explode('.', $fieldName);
-            $fieldName = $this->parser->camelize($embeddedFields[count($embeddedFields)-1]);
+            $fieldName = $this->parser->camelize($embeddedFields[count($embeddedFields) - 1]);
 
             $salt = '';
             foreach ($this->qBuilder->getParameters() as $parameter) {
@@ -298,9 +298,9 @@ 
             }
 
             if (isset($filterAndOperator[1]) && 'list' == $filterAndOperator[1]) {
-                $whereCondition = $relationEntityAlias.'.'.$fieldName.' '.$operator['meta'].' (:field_'.$fieldName . $salt . ')';
+                $whereCondition = $relationEntityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' (:field_' . $fieldName . $salt . ')';
             } else {
-                $whereCondition = $relationEntityAlias.'.'.$fieldName.' '.$operator['meta'].' :field_'.$fieldName . $salt;
+                $whereCondition = $relationEntityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' :field_' . $fieldName . $salt;
             }
 
             $this->qBuilder->andWhere($whereCondition);
@@ -323,13 +323,13 @@ 
     private function applyFilterOr($filter, $value, $orCondition)
     {
         $whereCondition = null;
-        $filterAndOperator = explode('|',$filter);
+        $filterAndOperator = explode('|', $filter);
 
         $fieldName = $filterAndOperator[0];
         $fieldName = $this->parser->camelize($fieldName);
 
         $operator = $this->getValueAvailableFilters()[self::DEFAULT_OPERATOR];
-        if(isset($filterAndOperator[1])){
+        if (isset($filterAndOperator[1])) {
             $operator = $this->getValueAvailableFilters()[$filterAndOperator[1]];
         }
 
@@ -353,10 +353,10 @@ 
             // $filterAndOperator[1] = 'bar'
             if (isset($filterAndOperator[1])) {
                 if ('list' == $filterAndOperator[1]) {
-                    $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' (:field_'.$fieldName . $salt . ')';
+                    $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' (:field_' . $fieldName . $salt . ')';
                 } else if ('field_eq' == $filterAndOperator[1]) {
                     $whereCondition =
-                        $this->entityAlias . '.' . $fieldName . ' '.
+                        $this->entityAlias . '.' . $fieldName . ' ' .
                         $operator['meta'] . '' .
                         $this->entityAlias . '.' . $value
                     ;
@@ -365,10 +365,10 @@ 
                     //'Oops! Eccezzione'
                     //);
                 } else {
-                    $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' :field_'.$fieldName . $salt;
+                    $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' :field_' . $fieldName . $salt;
                 }
             } else {
-                $whereCondition = $this->entityAlias.'.'.$fieldName.' = :field_'.$fieldName . $salt;
+                $whereCondition = $this->entityAlias . '.' . $fieldName . ' = :field_' . $fieldName . $salt;
             }
 
             if ($orCondition['orCondition'] != null) {
@@ -396,7 +396,7 @@ 
         } else {
             $isNotARelation = 0 !== strpos($fieldName, 'Embedded.');
             if ($isNotARelation) {
-                $whereCondition = $this->entityAlias.'.'.$fieldName.' '.$operator['meta'].' ' . $this->entityAlias . '.' . $value;
+                $whereCondition = $this->entityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' ' . $this->entityAlias . '.' . $value;
                 if ($orCondition['orCondition'] != null) {
                     $orCondition['orCondition'] .= ' OR ' . $whereCondition;
                 } else {
@@ -413,7 +413,7 @@ 
             $relationEntityAlias = $this->getRelationEntityAlias();
 
             $embeddedFields = explode('.', $fieldName);
-            $fieldName = $this->parser->camelize($embeddedFields[count($embeddedFields)-1]);
+            $fieldName = $this->parser->camelize($embeddedFields[count($embeddedFields) - 1]);
 
             $salt = '';
             foreach ($this->qBuilder->getParameters() as $parameter) {
@@ -427,9 +427,9 @@ 
             }
 
             if (isset($filterAndOperator[1]) && 'list' == $filterAndOperator[1]) {
-                $whereCondition = $relationEntityAlias.'.'.$fieldName.' '.$operator['meta'].' (:field_'.$fieldName . $salt . ')';
+                $whereCondition = $relationEntityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' (:field_' . $fieldName . $salt . ')';
             } else {
-                $whereCondition = $relationEntityAlias.'.'.$fieldName.' '.$operator['meta'].' :field_'.$fieldName . $salt;
+                $whereCondition = $relationEntityAlias . '.' . $fieldName . ' ' . $operator['meta'] . ' :field_' . $fieldName . $salt;
             }
 
             if ($orCondition['orCondition'] != null) {
@@ -480,7 +480,7 @@ 
 
             if (in_array($fieldName, $this->fields)) {
                 $direction = ($val === self::DIRECTION_AZ) ? self::DIRECTION_AZ : self::DIRECTION_ZA;
-                $this->qBuilder->addOrderBy($this->entityAlias .'.'. $fieldName, $direction);
+                $this->qBuilder->addOrderBy($this->entityAlias . '.' . $fieldName, $direction);
             }
 
             if (strstr($sort, '_embedded.')) {
@@ -491,7 +491,7 @@ 
                 $fieldName = $this->parser->camelize($embeddedFields[2]);
                 $direction = ($val === self::DIRECTION_AZ) ? self::DIRECTION_AZ : self::DIRECTION_ZA;
 
-                $this->qBuilder->addOrderBy($relationEntityAlias.'.'.$fieldName, $direction);
+                $this->qBuilder->addOrderBy($relationEntityAlias . '.' . $fieldName, $direction);
             }
 
         }
@@ -579,7 +579,7 @@ 
         return $this->pageLength;
     }
 
-    public function setSelect( $select) : QueryBuilderFactory
+    public function setSelect($select) : QueryBuilderFactory
     {
         $this->select = $select;
 

tests/Mado/QueryBundle/Objects/QueryBuilderFactoryTest.php

Spacing +7 added lines, -7 removed lines

@@ -15,7 +15,7 @@ 
             'path' => __DIR__ . '/../../data/db.sqlite',
         ),
         \Doctrine\ORM\Tools\Setup::createAnnotationMetadataConfiguration(
-            array(__DIR__."/src"),
+            array(__DIR__ . "/src"),
             true
         ));
     }
@@ -23,8 +23,8 @@ 
     public function testProvideOneSingleResult()
     {
         $queryBuilderFactory = new QueryBuilderFactory($this->manager);
-        $queryBuilderFactory->setFields([ 'id' ]);
-        $queryBuilderFactory->setFilters([ 'id|eq' => 33 ]);
+        $queryBuilderFactory->setFields(['id']);
+        $queryBuilderFactory->setFilters(['id|eq' => 33]);
         $queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
         $queryBuilderFactory->filter();
 
@@ -40,8 +40,8 @@ 
     public function testSampleQueryMakedWithQueryBuilderFactory()
     {
         $queryBuilderFactory = new QueryBuilderFactory($this->manager);
-        $queryBuilderFactory->setFields([ 'id' ]);
-        $queryBuilderFactory->setFilters([ 'id|eq' => 33 ]);
+        $queryBuilderFactory->setFields(['id']);
+        $queryBuilderFactory->setFilters(['id|eq' => 33]);
         $queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
         $queryBuilderFactory->filter();
 
@@ -59,8 +59,8 @@ 
     public function testOneToManyQueryMakedHandly()
     {
         $queryBuilderFactory = new QueryBuilderFactory($this->manager);
-        $queryBuilderFactory->setFields([ 'id' ]);
-        $queryBuilderFactory->setRel([ 'group' ]);
+        $queryBuilderFactory->setFields(['id']);
+        $queryBuilderFactory->setRel(['group']);
         $queryBuilderFactory->setFilters([
             '_embedded.group.name|contains|1' => 'ad',
             '_embedded.group.name|contains|2' => 'ns',