staudenmeir / eloquent-eager-limit-x-laravel-adjacency-list

src/Query/Grammars/SqlServerGrammar.php

Indentation +16 added lines, -16 removed lines

@@ -6,22 +6,22 @@
 
 class SqlServerGrammar extends Base implements EagerLimitGrammar
 {
-	/**
-	 * Compile an initial path. TODO
-	 *
-	 * @param string $column
-	 * @return string
-	 */
-	public function compileFirstPathSegment($column)
-	{
-		$column = $this->wrap($column);
+    /**
+     * Compile an initial path. TODO
+     *
+     * @param string $column
+     * @return string
+     */
+    public function compileFirstPathSegment($column)
+    {
+        $column = $this->wrap($column);
 
-		return "left($column, charindex(?, $column) - 1)";
-	}
+        return "left($column, charindex(?, $column) - 1)";
+    }
 
-	// TODO
-	public function getFirstPathSegmentBindings($pathSeparator)
-	{
-		return [$pathSeparator];
-	}
+    // TODO
+    public function getFirstPathSegmentBindings($pathSeparator)
+    {
+        return [$pathSeparator];
+    }
 }

src/Eloquent/Relations/Bloodline.php

Indentation +13 added lines, -13 removed lines

@@ -23,11 +23,11 @@ 
         } else {
             $grammar = $this->getEagerLimitGrammar();
 
-	        $sql = $grammar->compileFirstPathSegment(
-		        $this->related->qualifyColumn(
-			        $this->related->getPathName()
-		        )
-	        );
+            $sql = $grammar->compileFirstPathSegment(
+                $this->related->qualifyColumn(
+                    $this->related->getPathName()
+                )
+            );
 
             $column = new Expression($sql);
 
@@ -38,14 +38,14 @@ 
 
             $this->query->groupLimit($value, $column);
 
-	        $this->query->getQuery()->addBinding(
-		        array_fill(
-			        0,
-			        substr_count($sql, '?'),
-			        $this->related->getPathSeparator()
-		        ),
-		        'groupBy'
-	        );
+            $this->query->getQuery()->addBinding(
+                array_fill(
+                    0,
+                    substr_count($sql, '?'),
+                    $this->related->getPathSeparator()
+                ),
+                'groupBy'
+            );
         }
 
         return $this;

src/Eloquent/Relations/Ancestors.php

Indentation +9 added lines, -9 removed lines

@@ -27,12 +27,12 @@ 
         } else {
             $grammar = $this->getEagerLimitGrammar();
 
-			// TODO
-			$sql = $grammar->compileFirstPathSegment(
-				$this->related->qualifyColumn(
-					$this->related->getPathName()
-				)
-			);
+            // TODO
+            $sql = $grammar->compileFirstPathSegment(
+                $this->related->qualifyColumn(
+                    $this->related->getPathName()
+                )
+            );
 
             $column = new Expression($sql);
 
@@ -45,9 +45,9 @@ 
 
             $this->query->getQuery()->addBinding(
                 array_fill(
-					0,
-					substr_count($sql, '?'),
-					$this->related->getPathSeparator()
+                    0,
+                    substr_count($sql, '?'),
+                    $this->related->getPathSeparator()
                 ),
                 'groupBy'
             );

src/Eloquent/Relations/Descendants.php

Indentation +14 added lines, -14 removed lines

@@ -25,13 +25,13 @@ 
             if ($this->andSelf) {
                 $grammar = $this->getEagerLimitGrammar();
 
-	            $sql = $grammar->compileFirstPathSegment(
-		            $this->related->qualifyColumn(
-			            $this->related->getPathName()
-		            )
-	            );
+                $sql = $grammar->compileFirstPathSegment(
+                    $this->related->qualifyColumn(
+                        $this->related->getPathName()
+                    )
+                );
 
-	            $column = new Expression($sql);
+                $column = new Expression($sql);
 
                 // TODO
                 //		    if ($grammar instanceof MySqlGrammar && $grammar->useLegacyGroupLimit($this->query->getQuery())) {
@@ -40,14 +40,14 @@ 
 
                 $this->query->groupLimit($value, $column);
 
-	            $this->query->getQuery()->addBinding(
-		            array_fill(
-			            0,
-			            substr_count($sql, '?'),
-			            $this->related->getPathSeparator()
-		            ),
-		            'groupBy'
-	            );
+                $this->query->getQuery()->addBinding(
+                    array_fill(
+                        0,
+                        substr_count($sql, '?'),
+                        $this->related->getPathSeparator()
+                    ),
+                    'groupBy'
+                );
             } else {
                 throw new RuntimeException('Eager loading limits are not supported on Descendants relationships.');
             }