芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/kwesioben.com/paymoney/app/DataTables/Admin/MoneyTransfersDataTable.php

<?php

namespace App\DataTables\Admin;

use Yajra\DataTables\Services\DataTable;
use Config, Auth, Common;
use App\Models\Transfer;

use Illuminate\Http\JsonResponse;
class MoneyTransfersDataTable extends DataTable
{
    public function ajax(): JsonResponse
    {
        return datatables()
            ->eloquent($this->query())
            ->editColumn('created_at', function ($transfer) {
                return dateFormat($transfer->created_at);
            })->addColumn('sender', function ($transfer) {
                $sender = getColumnValue($transfer->sender);
                if ($sender <> '-' && Common::has_permission(auth('admin')->user()->id, 'edit_user')) {
                    return '<a href="' . url(config('adminPrefix') . '/users/edit/' . $transfer->sender->id) . '">' . $sender . '</a>';
                }
                return $sender;
            })->editColumn('amount', function ($transfer) {
                return formatNumber($transfer->amount, $transfer->currency_id);
            })->editColumn('fee', function ($transfer) {
                return ($transfer->fee == 0) ? '-' : formatNumber($transfer->fee, $transfer->currency_id);
            })->addColumn('total', function ($transfer) {
                return '<td><span class="text-' . (($transfer->amount + $transfer->fee > 0) ? 'green">+' : 'red">-') . formatNumber($transfer->amount + $transfer->fee, $transfer->currency_id) . '</span></td>';
            })->editColumn('currency_id', function ($transfer) {
                return isset($transfer->currency->code) && !empty($transfer->currency->code) ? $transfer->currency->code : '';
            })->addColumn('receiver', function ($transfer) {
                if (isset($transfer->receiver->first_name) && !empty($transfer->receiver->first_name)) {
                    $receiver = $transfer->receiver->first_name . ' ' .$transfer->receiver->last_name;
                    $receiverWithLink = (Common::has_permission(auth('admin')->user()->id, 'edit_user')) ? '<a href="' . url(config('adminPrefix') . '/users/edit/' . $transfer->receiver->id) . '">' . $receiver . '</a>' : $receiver;
                } else {
                    if (!empty($transfer->email)) {
                        $receiver         = $transfer->email;
                        $receiverWithLink = $receiver;
                    } elseif (!empty($transfer->phone)) {
                        $receiver         = $transfer->phone;
                        $receiverWithLink = $receiver;
                    } else {
                        $receiver         = '-';
                        $receiverWithLink = $receiver;
                    }
                }
                return $receiverWithLink;
            })->editColumn('status', function ($transfer) {
                return getStatusLabel($transfer->status);
            })->addColumn('action', function ($transfer) {
                return (Common::has_permission(auth('admin')->user()->id, 'edit_transfer')) ? '<a href="' . url(config('adminPrefix') . '/transfers/edit/' . $transfer->id) . '" class="btn btn-xs btn-primary"><i class="fa fa-edit"></i></a> ' : '';
            })
            ->rawColumns(['sender', 'receiver', 'total', 'status', 'action'])
            ->make(true);
    }

public function query()
    {
        $status   = isset(request()->status) ? request()->status : 'all';
        $currency = isset(request()->currency) ? request()->currency : 'all';
        $user     = isset(request()->user_id) ? request()->user_id : null;
        $from     = isset(request()->from) ? setDateForDb(request()->from) : null;
        $to       = isset(request()->to) ? setDateForDb(request()->to) : null;
        $query    = (new Transfer())->getTransfersList($from, $to, $status, $currency, $user);

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

public function html()
    {
        return $this->builder()
            ->addColumn(['data' => 'id', 'name' => 'transfers.id', 'title' => __('ID'), 'searchable' => false, 'visible' => false])
            ->addColumn(['data' => 'uuid', 'name' => 'transfers.uuid', 'title' => __('UUID'), 'visible' => false])
            ->addColumn(['data' => 'sender', 'name' => 'sender.last_name', 'title' => __('Last Name'), 'visible' => false])
            ->addColumn(['data' => 'receiver', 'name' => 'receiver.last_name', 'title' => __('Last Name'), 'visible' => false])
            ->addColumn(['data' => 'created_at', 'name' => 'transfers.created_at', 'title' => __('Date')])
            ->addColumn(['data' => 'sender', 'name' => 'sender.first_name', 'title' => __('User')])
            ->addColumn(['data' => 'amount', 'name' => 'transfers.amount', 'title' => __('Amount')])
            ->addColumn(['data' => 'fee', 'name' => 'transfers.fee', 'title' => __('Fees')])
            ->addColumn(['data' => 'total', 'name' => 'total', 'title' => __('Total'), 'searchable' => false])
            ->addColumn(['data' => 'currency_id', 'name' => 'currency.code', 'title' => __('Currency')])
            ->addColumn(['data' => 'receiver', 'name' => 'receiver.first_name', 'title' => __('Receiver')])
            ->addColumn(['data' => 'status', 'name' => 'transfers.status', 'title' => __('Status')])
            ->addColumn(['data' => 'action', 'name' => 'action', 'title' => __('Action'), 'orderable' => false, 'searchable' => false])
            ->parameters(dataTableOptions());
    }
}