Update QueryShorter.php

skycoder026 · web-flow · commit fe87fcaa734d · 2022-03-07T21:37:00.000+06:00
diff --git a/src/QueryShorter.php b/src/QueryShorter.php
@@ -299,10 +299,10 @@ public function scopeSortby($query)
      | SELECT NAME [SELECT ONLY NAME FROM RELATIONAL TABLE AND APPEND AS AN ATTRIBUTE]
      |--------------------------------------------------------------------------
     */
-    public function scopeSelectName($query, $relation_name)
+    public function scopeSelectName($query, $relation_name, $name = 'name')
     {
-        $table = $relation_name . ' as ' . $relation_name .'_name';
+        $table = $relation_name . ' as ' . $relation_name .'_' . $name;
 
-        $query->withCount([$table => function($q) { $q->select(DB::raw('name')); }]);
+        $query->withCount([$table => function($q) use($name) { $q->select(DB::raw($name)); }]);
     }
 }

Original file line number	Diff line number	Diff line change
`@@ -299,10 +299,10 @@ public function scopeSortby($query)`
`299`	`299`	`\| SELECT NAME [SELECT ONLY NAME FROM RELATIONAL TABLE AND APPEND AS AN ATTRIBUTE]`
`300`	`300`	`\|--------------------------------------------------------------------------`
`301`	`301`	`*/`
`302`		`- public function scopeSelectName($query, $relation_name)`
	`302`	`+ public function scopeSelectName($query, $relation_name, $name = 'name')`
`303`	`303`	`{`
`304`		`- $table = $relation_name . ' as ' . $relation_name .'_name';`
	`304`	`+ $table = $relation_name . ' as ' . $relation_name .'_' . $name;`
`305`	`305`
`306`		`- $query->withCount([$table => function($q) { $q->select(DB::raw('name')); }]);`
	`306`	`+ $query->withCount([$table => function($q) use($name) { $q->select(DB::raw($name)); }]);`
`307`	`307`	`}`
`308`	`308`	`}`