ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / app / DataTables

<?php

namespace App\DataTables;

use App\DataTables\DataTable;
use Illuminate\Support\Facades\Auth;
use Spatie\Activitylog\Models\Activity;
use App\Traits\ModelTraits\{Filterable, FormatDateTime};

class UserActivityDataTable extends DataTable
{
    use Filterable, FormatDateTime;

protected $propertiesArray = [];

/*
    * DataTable Ajax
    *
    * @return \Yajra\DataTables\DataTableAbstract|\Yajra\DataTables\DataTables
    */
    public function ajax()
    {
        $activities = $this->query();

return datatables()
            ->of($activities)
            ->addColumn('log_name', function ($activity) {
                return str_replace('USER ', '', $activity->log_name);
            })
            ->addColumn('description', function ($activity) {
                return $activity->description;
            })
            ->addColumn('browser', function ($activity) {
                $this->propertiesArray = json_decode($activity->properties, true);
                return $this->propertiesArray['browser'] . ' ' . $this->propertiesArray['browser_version'];
            })
            ->addColumn('platform', function($activity) {
                return $this->propertiesArray['platform'];
            })
            ->addColumn('ip', function($activity) {
                return $this->propertiesArray['ip_address'];
            })
            ->addColumn('created_at', function ($activity) {
                return $this->formatDateTime($activity->created_at);
            })
            ->rawColumns(['log_name', 'description', 'browser', 'platform', 'ip', 'created_at'])
            ->make(true);
    }

/*
    * DataTable Query
    *
    * @return mixed
    */
    public function query()
    {
        $activities = Activity::query()
            ->where('log_name', 'LIKE', '%user%')
            ->where('causer_id', '=', Auth::id());

if (count(request()->query()) > 0) {
            $activities = $this->scopeFilter($activities, 'App\\Filters\\UserActivityLogFilter');
        }

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

/*
    * DataTable HTML
    *
    * @return \Yajra\DataTables\Html\Builder
    */
    public function html()
    {
        return $this->builder()
            ->addColumn(['data' => 'log_name', 'name' => 'log_name', 'title' => __('Type'), 'orderable' => false, 'searchable' => false])
            ->addColumn(['data' => 'description', 'name' => 'description', 'title' => __('Description'), 'orderable' => false])
            ->addColumn(['data' => 'browser', 'name' => 'browser', 'title' => __('Browser'), 'orderable' => false])
            ->addColumn(['data' => 'platform', 'name' => 'platform', 'title' => __('Platform'), 'orderable' => false, 'width' => '5%'])
            ->addColumn(['data' => 'ip', 'name' => 'ip', 'title' => __('IP'), 'orderable' => false])
            ->addColumn(['data' => 'created_at', 'name' => 'created_at', 'title' => __('Created at'), 'orderable' => false])
            ->parameters(dataTableOptions());
    }
}

[-] VendorOrderDataTable.php [edit]
[-] ReviewListDataTable.php [edit]
[-] EmailTemplateListDataTable.php [edit]
[-] VendorListDataTable.php [edit]
[+] ..
[-] UserWalletDataTable.php [edit]
[-] VendorProductDataTable.php [edit]
[-] RoleListDataTable.php [edit]
[-] BrandListDataTable.php [edit]
[-] UsersActivityDataTable.php [edit]
[-] AttributeGroupDataTable.php [edit]
[-] VendorReviewListDataTable.php [edit]
[-] DataTable.php [edit]
[-] UserListDataTable.php [edit]
[-] ProductDataTable.php [edit]
[-] WithdrawalHistoryDataTable.php [edit]
[-] OrderDataTable.php [edit]
[-] AttributeDataTable.php [edit]
[-] VendorTransactionDataTable.php [edit]
[-] UserActivityDataTable.php [edit]
[-] WithdrawalListDataTable.php [edit]
[-] TransactionListDataTable.php [edit]