芝麻web文件管理V1.00

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

<?php

namespace App\DataTables\Admin;

use Yajra\DataTables\Services\DataTable;
use App\Http\Helpers\Common;
use App\Models\Currency;
use Config;

use Illuminate\Http\JsonResponse;
class CurrenciesDataTable extends DataTable
{
    public function ajax(): JsonResponse
    {
        return datatables()
            ->eloquent($this->query())

->editColumn('name', function ($currency) {
 return (isset($currency->cryptoAssetSetting) && !empty($currency->cryptoAssetSetting)) ? $currency->name . ' (' . $currency->cryptoAssetSetting->cryptoProvider->name . ')' : $currency->name;
 })
 ->editColumn('type', function ($currency) {
 return str_contains($currency->type, '_') ? ucwords(str_replace('_', ' ', $currency->type)) : ucfirst($currency->type);
 })
 ->editColumn('rate', function ($currency) {
 return $currency->rate != 0 ? (float) ($currency->rate) : '-';
 })
 ->editColumn('logo', function ($currency) {
 return '<td><img src="' . image($currency->logo, 'currency') . '" class="img-w64"></td>';
 })
 ->editColumn('status', function ($currency) {
 if ($currency->default == 1) {
 return 'Default Currency';
 } else {
 return getStatusLabel($currency->status);
 }
 })
 ->addColumn('action', function ($currency) {
 $edit = $delete = $feesLimit = $pm = '';
 $type = $currency->type == 'fiat' ? 'stripe' : 'coinpayments';

if ($currency->type == 'crypto_asset') {
 $edit = (Common::has_permission(auth('admin')->user()->id, 'edit_currency')) ? '<a href="' . url(config('adminPrefix').'/blockio/edit/' . encrypt($currency->code)) . '" class="btn btn-xs btn-primary"></a> ' : '';
 } else {
 $edit = (Common::has_permission(auth('admin')->user()->id, 'edit_currency')) ? '<a href="' . url(config('adminPrefix').'/settings/edit_currency/' . $currency->id) . '" class="btn btn-xs btn-primary"></a> ' : '';
 }

$delete = (Common::has_permission(auth('admin')->user()->id, 'delete_currency')) && (($currency->type == 'fiat') || ($currency->type == 'crypto')) ? '<a href="' . url(config('adminPrefix').'/settings/delete_currency/' . $currency->id) . '" class="btn btn-xs btn-danger delete-warning"></a> ' : '';

$feesLimit = (Common::has_permission(auth('admin')->user()->id, 'edit_currency') && $currency->status == 'Active') && (($currency->type == 'fiat') || ($currency->type == 'crypto')) ? '<a href="' . url(config('adminPrefix').'/settings/feeslimit/deposit/' . $currency->id) . '" class="btn btn-xs btn-success">

Fees</a> ' : '';
 $pm = (Common::has_permission(auth('admin')->user()->id, 'edit_currency')) && $currency->status == 'Active' && (($currency->type == 'fiat') || ($currency->type == 'crypto')) ? '<a href="' . url(config('adminPrefix').'/settings/payment-methods/'.$type.'/' . $currency->id) . '" class="btn btn-xs btn-primary">
 Payment-Methods</a> ' : '';

return $edit . $delete . $feesLimit . $pm;
            })
            ->rawColumns(['name', 'logo', 'status', 'action'])
            ->make(true);
    }

public function query()
    {
        $query = Currency::with('cryptoAssetSetting:id,currency_id,crypto_provider_id', 'cryptoAssetSetting.cryptoProvider:id,name')->select('id', 'type', 'name', 'code', 'symbol', 'rate', 'logo', 'status', 'default')->orderBy('id', 'desc');
        return $this->applyScopes($query);
    }

public function html()
    {
        return $this->builder()
            ->addColumn(['data' => 'id', 'name' => 'currencies.id', 'title' => __('ID'), 'searchable' => false, 'visible' => false])
            ->addColumn(['data' => 'name', 'name' => 'currencies.name', 'title' => __('Name')])
            ->addColumn(['data' => 'name', 'name' => 'cryptoAssetSetting.cryptoProvider.name', 'title' => __('Name'), 'visible' => false])
            ->addColumn(['data' => 'code', 'name' => 'currencies.code', 'title' => __('Code')])
            ->addColumn(['data' => 'symbol', 'name' => 'currencies.symbol', 'title' => __('Symbol')])
            ->addColumn(['data' => 'type', 'name' => 'currencies.type', 'title' => __('Type')])
            ->addColumn(['data' => 'rate', 'name' => 'currencies.rate', 'title' => __('Rate')])
            ->addColumn(['data' => 'logo', 'name' => 'currencies.logo', 'title' => __('Logo')])
            ->addColumn(['data' => 'status', 'name' => 'currencies.status', 'title' => __('Status')])
            ->addColumn(['data' => 'action', 'name' => 'action', 'title' => __('Action'), 'orderable' => false, 'searchable' => false])
            ->parameters(dataTableOptions([
                "columnDefs" => [
                    [
                        "className" => "dt-center",
                        "targets" => "_all"
                    ]
                ]
            ]));
    }
}