invoiceninja/app/Ninja/Datatables/ClientDatatable.php

<?php

namespace App\Ninja\Datatables;

use Auth;
use URL;
use Utils;

class ClientDatatable extends EntityDatatable
{
    public $entityType = ENTITY_CLIENT;
    public $sortCol = 4;
    public $fieldToSum = 'balance';

    public function columns()
    {
        return [
            [
                'name',
                function ($model) {
                    $str = link_to("clients/{$model->public_id}", $model->name ?: '')->toHtml();
                    return $this->addNote($str, $model->private_notes);
                },
            ],
            [
                'contact',
                function ($model) {
                    return link_to("clients/{$model->public_id}", $model->contact ?: '')->toHtml();
                },
            ],
            [
                'email',
                function ($model) {
                    return link_to("clients/{$model->public_id}", $model->email ?: '')->toHtml();
                },
            ],
            [
                'id_number',
                function ($model) {
                    return $model->id_number;
                },
                Auth::user()->account->clientNumbersEnabled()
            ],
            [
                'custom_client1::' . Auth::user()->account->customLabel('client1'),
                function ($model) {
                    return $model->custom_value1    ;
                },
                Auth::user()->account->customFieldsOption('client1_filter')
            ],
            [
                'custom_client2::' . Auth::user()->account->customLabel('client2'),
                function ($model) {
                    return $model->custom_value2;
                },
                Auth::user()->account->customFieldsOption('client2_filter')
            ],

            [
                'client_created_at',
                function ($model) {
                    return Utils::timestampToDateString(strtotime($model->created_at));
                },
            ],
            [
                'last_login',
                function ($model) {
                    return Utils::timestampToDateString(strtotime($model->last_login));
                },
            ],
            [
                'balance',
                function ($model) {
                    return Utils::formatMoney($model->balance, $model->currency_id, $model->country_id);
                },
            ],
        ];
    }

    public function actions()
    {
        return [
            [
                trans('texts.edit_client'),
                function ($model) {
                    if(Auth::user()->can('edit', [ENTITY_CLIENT, $model]))
                        return URL::to("clients/{$model->public_id}/edit");
                    elseif(Auth::user()->can('view', [ENTITY_CLIENT, $model]))
                        return URL::to("clients/{$model->public_id}");
                },
            ],
            [
                '--divider--', function () {
                    return false;
                },
                function ($model) {
                    return Auth::user()->can('edit', [ENTITY_CLIENT, $model]);
                },
            ],
            [
                trans('texts.new_task'),
                function ($model) {
                    return URL::to("tasks/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->can('createEntity', ENTITY_TASK);
                },
            ],
            [
                trans('texts.new_invoice'),
                function ($model) {
                    return URL::to("invoices/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->can('createEntity', ENTITY_INVOICE);
                },
            ],
            [
                trans('texts.new_quote'),
                function ($model) {
                    return URL::to("quotes/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->hasFeature(FEATURE_QUOTES) && Auth::user()->can('createEntity', ENTITY_QUOTE);
                },
            ],
            [
                '--divider--', function () {
                    return false;
                },
                function ($model) {
                    return (Auth::user()->can('createEntity', ENTITY_TASK) || Auth::user()->can('createEntity', ENTITY_INVOICE)) && (Auth::user()->can('createEntity', ENTITY_PAYMENT) || Auth::user()->can('createEntity', ENTITY_CREDIT) || Auth::user()->can('createEntity', ENTITY_EXPENSE));
                },
            ],
            [
                trans('texts.enter_payment'),
                function ($model) {
                    return URL::to("payments/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->can('createEntity', ENTITY_PAYMENT);
                },
            ],
            [
                trans('texts.enter_credit'),
                function ($model) {
                    return URL::to("credits/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->can('createEntity', ENTITY_CREDIT);
                },
            ],
            [
                trans('texts.enter_expense'),
                function ($model) {
                    return URL::to("expenses/create/{$model->public_id}");
                },
                function ($model) {
                    return Auth::user()->can('createEntity', ENTITY_EXPENSE);
                },
            ],
        ];
    }
}