deniskoronets / Laravel-GridView

src/GridViewHelper.php

Indentation +142 added lines, -142 removed lines

@@ -25,146 +25,146 @@
 
 class GridViewHelper
 {
-    /**
-     * A list of grid aliases
-     * @var array
-     */
-    private static $aliases = [
-        'column' => [
-            'attribute' => AttributeColumn::class,
-            'raw' => CallbackColumn::class,
-            'callback' => CallbackColumn::class,
-            'actions' => ActionsColumn::class,
-            'view' => ViewColumn::class,
-        ],
-        'formatter' => [
-            'email' => EmailFormatter::class,
-            'image' => ImageFormatter::class,
-            'text' => TextFormatter::class,
-            'url' => UrlFormatter::class,
-            'raw' => RawFormatter::class,
-            'currency' => CurrencyFormatter::class,
-            'number' => NumberFormatter::class,
-        ],
-        'filter' => [
-            'text' => TextFilter::class,
-            'dropdown' => DropdownFilter::class,
-        ],
-        'renderer' => [
-            'default' => DefaultRenderer::class,
-        ],
-        'action' => [
-            'delete' => DeleteAction::class,
-            'update' => EditAction::class,
-            'edit' => EditAction::class,
-            'show' => ShowAction::class,
-            'view' => ShowAction::class,
-            'action' => Action::class,
-        ]
-    ];
-
-    private function __construct() {}
-
-    /**
-     * Useful in case you want to register a new alias for your project
-     * @param string $context
-     * @param string $alias
-     * @param string $aliasTo
-     */
-    public static function registerAlias(string $context, string $alias, string $aliasTo)
-    {
-        self::$aliases[$context][$alias] = $aliasTo;
-    }
-
-    /**
-     * Allows to resolve class name by its alias
-     * @param string $context
-     * @param string $alias
-     * @return mixed
-     */
-    public static function resolveAlias(string $context, string $alias)
-    {
-        return self::$aliases[$context][$alias] ?? $alias;
-    }
-
-    /**
-     * Allows to convert options array to html string
-     * @param array $htmlOptions
-     * @param array $context - context is variables, which are allowed to use when property value calculated dynamically
-     * @return string
-     */
-    public static function htmlOptionsToString(array $htmlOptions, array $context = []) : string
-    {
-        if (empty($htmlOptions)) {
-            return '';
-        }
-
-        $out = [];
-
-        foreach ($htmlOptions as $k => $v) {
-
-            if ($v instanceof \Closure) {
-                $v = call_user_func_array($v, $context);
-            }
-
-            $out[] = htmlentities($k) . '="' . htmlentities($v, ENT_COMPAT) . '"';
-        }
-
-        return implode(' ', $out);
-    }
-
-    /**
-     * Allows to make column title by it key or attribute name
-     * @param string|int $key
-     * @return string
-     */
-    public static function columnTitle($key) : string
-    {
-        if (is_numeric($key)) {
-            return 'Column';
-        }
-
-        return ucwords(
-            trim(
-                preg_replace_callback(
-                    '/([A-Z]|_|\.)/',
-                    function($word) {
-                        $word = $word[0];
-
-                        if ($word == '_' || $word == '.') {
-                            return ' ';
-                        }
-
-                        return ' ' . strtolower($word);
-                    },
-                    $key
-                )
-            )
-        );
-    }
-
-    /**
-     * Helper for internal purposes
-     * @param $id
-     * @param $component
-     * @return string
-     */
-    public static function gridIdFormatter($id, $component)
-    {
-        if ($id == 0) {
-            return $component;
-        }
-
-        return 'grid[' . $id . '][' . $component . ']';
-    }
-
-    /**
-     * Generates page url with all requested params from request
-     * @param $gridId
-     * @param $page
-     */
-    public static function pageUrl($gridId, $page)
-    {
-        return url()->current() . '?' . Arr::query([\Woo\GridView\GridViewHelper::gridIdFormatter($gridId, 'page') => $page] + request()->query());
-    }
+	/**
+	 * A list of grid aliases
+	 * @var array
+	 */
+	private static $aliases = [
+		'column' => [
+			'attribute' => AttributeColumn::class,
+			'raw' => CallbackColumn::class,
+			'callback' => CallbackColumn::class,
+			'actions' => ActionsColumn::class,
+			'view' => ViewColumn::class,
+		],
+		'formatter' => [
+			'email' => EmailFormatter::class,
+			'image' => ImageFormatter::class,
+			'text' => TextFormatter::class,
+			'url' => UrlFormatter::class,
+			'raw' => RawFormatter::class,
+			'currency' => CurrencyFormatter::class,
+			'number' => NumberFormatter::class,
+		],
+		'filter' => [
+			'text' => TextFilter::class,
+			'dropdown' => DropdownFilter::class,
+		],
+		'renderer' => [
+			'default' => DefaultRenderer::class,
+		],
+		'action' => [
+			'delete' => DeleteAction::class,
+			'update' => EditAction::class,
+			'edit' => EditAction::class,
+			'show' => ShowAction::class,
+			'view' => ShowAction::class,
+			'action' => Action::class,
+		]
+	];
+
+	private function __construct() {}
+
+	/**
+	 * Useful in case you want to register a new alias for your project
+	 * @param string $context
+	 * @param string $alias
+	 * @param string $aliasTo
+	 */
+	public static function registerAlias(string $context, string $alias, string $aliasTo)
+	{
+		self::$aliases[$context][$alias] = $aliasTo;
+	}
+
+	/**
+	 * Allows to resolve class name by its alias
+	 * @param string $context
+	 * @param string $alias
+	 * @return mixed
+	 */
+	public static function resolveAlias(string $context, string $alias)
+	{
+		return self::$aliases[$context][$alias] ?? $alias;
+	}
+
+	/**
+	 * Allows to convert options array to html string
+	 * @param array $htmlOptions
+	 * @param array $context - context is variables, which are allowed to use when property value calculated dynamically
+	 * @return string
+	 */
+	public static function htmlOptionsToString(array $htmlOptions, array $context = []) : string
+	{
+		if (empty($htmlOptions)) {
+			return '';
+		}
+
+		$out = [];
+
+		foreach ($htmlOptions as $k => $v) {
+
+			if ($v instanceof \Closure) {
+				$v = call_user_func_array($v, $context);
+			}
+
+			$out[] = htmlentities($k) . '="' . htmlentities($v, ENT_COMPAT) . '"';
+		}
+
+		return implode(' ', $out);
+	}
+
+	/**
+	 * Allows to make column title by it key or attribute name
+	 * @param string|int $key
+	 * @return string
+	 */
+	public static function columnTitle($key) : string
+	{
+		if (is_numeric($key)) {
+			return 'Column';
+		}
+
+		return ucwords(
+			trim(
+				preg_replace_callback(
+					'/([A-Z]|_|\.)/',
+					function($word) {
+						$word = $word[0];
+
+						if ($word == '_' || $word == '.') {
+							return ' ';
+						}
+
+						return ' ' . strtolower($word);
+					},
+					$key
+				)
+			)
+		);
+	}
+
+	/**
+	 * Helper for internal purposes
+	 * @param $id
+	 * @param $component
+	 * @return string
+	 */
+	public static function gridIdFormatter($id, $component)
+	{
+		if ($id == 0) {
+			return $component;
+		}
+
+		return 'grid[' . $id . '][' . $component . ']';
+	}
+
+	/**
+	 * Generates page url with all requested params from request
+	 * @param $gridId
+	 * @param $page
+	 */
+	public static function pageUrl($gridId, $page)
+	{
+		return url()->current() . '?' . Arr::query([\Woo\GridView\GridViewHelper::gridIdFormatter($gridId, 'page') => $page] + request()->query());
+	}
 }

src/DataProviders/EloquentDataProvider.php

Indentation +101 added lines, -101 removed lines

@@ -9,105 +9,105 @@
 
 class EloquentDataProvider extends BaseDataProvider
 {
-    protected $filters = true;
-    protected $ordering = true;
-
-    protected $query;
-
-    /**
-     * EloquentDataProvider constructor.
-     * @param Builder $query
-     */
-    public function __construct(Builder $query)
-    {
-        $this->query = clone $query;
-    }
-
-    /**
-     * Applies filter to a column
-     * @param \Closure| $filter
-     * @param string $fieldName
-     * @param Builder $query
-     * @param mixed $value
-     * @return void
-     */
-    private function applyFilter($filter, string $fieldName, Builder $query, $value)
-    {
-        if (is_callable($filter)) {
-           $filter($query, $value);
-           return;
-        }
-
-        switch ($filter) {
-            case '=':
-                $query->where($fieldName, '=', $value);
-                break;
-
-            case 'like':
-                $query->where($fieldName, 'LIKE', '%' . $value . '%');
-                break;
-
-            default:
-                throw new GridViewConfigException('Unknown filter type: ' . $filter);
-        }
-    }
-
-    /**
-     * @param GridViewRequest $request
-     * @return Builder
-     */
-    protected function baseQuery(GridViewRequest $request)
-    {
-        $query = clone $this->query;
-
-        if ($this->filters !== false) {
-            foreach ($request->filters as $field => $value) {
-                if ($this->filters === true || in_array($field, $this->filters)) {
-                    // Check if the $field is a real column in the table
-                    if (Schema::hasColumn($query->from, $field)) {
-                        // $field exists in the table, apply a WHERE clause
-                        $query->where($field, 'LIKE', '%' . $value . '%');
-                    } else {
-                        // $field does not exist in the table, it must be an alias, apply a HAVING clause
-                        $query->having($field, 'LIKE', '%' . $value . '%');
-                    }
-                } elseif (!empty($this->filters[$field])) {
-                    $this->applyFilter($this->filters[$field], $field, $query, $value);
-                }
-            }
-        }
-
-        if ($request->sortColumn && ($this->ordering === true || in_array($request->sortColumn, $this->ordering))) {
-            $query->reorder($request->sortColumn, $request->sortOrder);
-        }
-
-        return $query;
-    }
-
-    /**
-     * @inheritdoc
-     */
-    public function getCount(GridViewRequest $request) : int
-    {
-        $query = $this->baseQuery($request);
-        $query->reorder(null);
-
-        return $query->count();
-    }
-
-    /**
-     * @inheritdoc
-     */
-    public function getData(GridViewRequest $request)
-    {
-        $query = $this->baseQuery($request);
-
-        if ($request->perPage == 0) {
-            return $query->get();
-        }
-
-        return $query->offset(($request->page - 1) * $request->perPage)
-            ->limit($request->perPage)
-            ->get();
-    }
+	protected $filters = true;
+	protected $ordering = true;
+
+	protected $query;
+
+	/**
+	 * EloquentDataProvider constructor.
+	 * @param Builder $query
+	 */
+	public function __construct(Builder $query)
+	{
+		$this->query = clone $query;
+	}
+
+	/**
+	 * Applies filter to a column
+	 * @param \Closure| $filter
+	 * @param string $fieldName
+	 * @param Builder $query
+	 * @param mixed $value
+	 * @return void
+	 */
+	private function applyFilter($filter, string $fieldName, Builder $query, $value)
+	{
+		if (is_callable($filter)) {
+		   $filter($query, $value);
+		   return;
+		}
+
+		switch ($filter) {
+			case '=':
+				$query->where($fieldName, '=', $value);
+				break;
+
+			case 'like':
+				$query->where($fieldName, 'LIKE', '%' . $value . '%');
+				break;
+
+			default:
+				throw new GridViewConfigException('Unknown filter type: ' . $filter);
+		}
+	}
+
+	/**
+	 * @param GridViewRequest $request
+	 * @return Builder
+	 */
+	protected function baseQuery(GridViewRequest $request)
+	{
+		$query = clone $this->query;
+
+		if ($this->filters !== false) {
+			foreach ($request->filters as $field => $value) {
+				if ($this->filters === true || in_array($field, $this->filters)) {
+					// Check if the $field is a real column in the table
+					if (Schema::hasColumn($query->from, $field)) {
+						// $field exists in the table, apply a WHERE clause
+						$query->where($field, 'LIKE', '%' . $value . '%');
+					} else {
+						// $field does not exist in the table, it must be an alias, apply a HAVING clause
+						$query->having($field, 'LIKE', '%' . $value . '%');
+					}
+				} elseif (!empty($this->filters[$field])) {
+					$this->applyFilter($this->filters[$field], $field, $query, $value);
+				}
+			}
+		}
+
+		if ($request->sortColumn && ($this->ordering === true || in_array($request->sortColumn, $this->ordering))) {
+			$query->reorder($request->sortColumn, $request->sortOrder);
+		}
+
+		return $query;
+	}
+
+	/**
+	 * @inheritdoc
+	 */
+	public function getCount(GridViewRequest $request) : int
+	{
+		$query = $this->baseQuery($request);
+		$query->reorder(null);
+
+		return $query->count();
+	}
+
+	/**
+	 * @inheritdoc
+	 */
+	public function getData(GridViewRequest $request)
+	{
+		$query = $this->baseQuery($request);
+
+		if ($request->perPage == 0) {
+			return $query->get();
+		}
+
+		return $query->offset(($request->page - 1) * $request->perPage)
+			->limit($request->perPage)
+			->get();
+	}
 }