rinvex / cortex-pages

src/DataTables/Adminarea/PagesDataTable.php

<?php

declare(strict_types=1);

namespace Cortex\Pages\DataTables\Adminarea;

use Cortex\Pages\Models\Page;
use Cortex\Foundation\DataTables\AbstractDataTable;
use Cortex\Pages\Transformers\Adminarea\PageTransformer;

class PagesDataTable extends AbstractDataTable
{
    /**
     * {@inheritdoc}
     */
    protected $model = Page::class;

    /**
     * {@inheritdoc}
     */
    protected $transformer = PageTransformer::class;

    /**
     * Get the query object to be processed by dataTables.
     *
     * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection

Consider making the return type a bit more specific; maybe use \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder.

     */
    public function query()
    {
        $locale = app()->getLocale();
        $query = app($this->model)->query()->orderBy('sort_order', 'ASC')->orderBy("title->\${$locale}", 'ASC');

        return $this->applyScopes($query);
    }

    /**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns(): array
    {
        $link = config('cortex.foundation.route.locale_prefix')
            ? '"<a href=\""+routes.route(\'adminarea.pages.edit\', {page: full.id, locale: \''.$this->request->segment(1).'\'})+"\">"+data+"</a>"'
            : '"<a href=\""+routes.route(\'adminarea.pages.edit\', {page: full.id})+"\">"+data+"</a>"';

        return [
            'title' => ['title' => trans('cortex/pages::common.title'), 'render' => $link.'+(full.is_active ? " <i class=\"text-success fa fa-check\"></i>" : " <i class=\"text-danger fa fa-close\"></i>")', 'responsivePriority' => 0],
            'uri' => ['title' => trans('cortex/pages::common.uri')],
            'domain' => ['title' => trans('cortex/pages::common.domain'), 'visible' => false],
            'route' => ['title' => trans('cortex/pages::common.route')],
            'view' => ['title' => trans('cortex/pages::common.view'), 'visible' => false],
            'middleware' => ['title' => trans('cortex/pages::common.middleware'), 'visible' => false],
            'sort_order' => ['title' => trans('cortex/pages::common.sort_order'), 'visible' => false],
            'created_at' => ['title' => trans('cortex/pages::common.created_at'), 'render' => "moment(data).format('YYYY-MM-DD, hh:mm:ss A')"],
            'updated_at' => ['title' => trans('cortex/pages::common.updated_at'), 'render' => "moment(data).format('YYYY-MM-DD, hh:mm:ss A')"],
        ];
    }
}