File Manager Lite

Dir: /home/u540325668/domains/mccsociety.org/Composer.error.public_html/app/DataTables

[..]

CustomerDataTable.php (4.03 KB)

DonationDataTable.php (3.16 KB)

PaymentDataTable.php (3.15 KB)

PostDataTable.php (4.15 KB)

UsersDataTable.php (3.54 KB)

Edit: PaymentDataTable.php

<?php

namespace App\DataTables;

use App\Payment;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;
use App\Admission;

class PaymentDataTable extends DataTable
{
    /**
     * Build DataTable class.
     *
     * @param mixed $query Results from query() method.
     * @return \Yajra\DataTables\DataTableAbstract
     */
    public function dataTable($query)
    {
        return datatables()
        ->eloquent($query)->addColumn('Action', function ($payment) {
            return '<a href="/admin/payment/edit/'.$payment->id.'"class="btn btn-sm btn-success"><span class="fa fa-edit"></span></a>  '.'<a href="/admin/payment/delete/'.$payment->id.'"class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure to delete this Payment\')" ><span class="fa fa-trash"></span></a>';
        })
        ->escapeColumns('Action')
            ->addColumn('user_id', function ($payment) {
                return $payment->user->name."-".$payment->user_id;
            })
            /* ->addColumn('rollNumber', function ($rollNumber) {
                return $rollNumber->admission->rollNumber;
            })*/;
            
    }

/**
     * Get query source of dataTable.
     *
     * @param \App\App\Payment $model
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function query(Payment $model)
    {
        // return $model->newQuery();
        return $model->with('user:id,name')->select('payments.*')->with('admission:id,rollNumber')->select('payments.*')->newQuery();
    }

/**
     * Optional method if you want to use html builder.
     *
     * @return \Yajra\DataTables\Html\Builder
     */
    public function html()
    {
        return $this->builder()
                    ->setTableId('payment-table')
                    ->columns($this->getColumns())
                    ->minifiedAjax()
                    ->orderBy(0)
                    ->buttons(
                        Button::make('create'),
                        Button::make('export'),
                        Button::make('print'),
                        Button::make('reset'),
                        Button::make('reload')
                    );
    }

/**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {
        return [            
            Column::make('id'),
            Column::make('user.name')->title("Student"),
            Column::make('admission.rollNumber')->title("Roll Number"),
            Column::make('monthOfPayment')->title('Month Of Payment'),
            Column::make('amount'),
            Column::make('paymentType')->title('Payment Type'),
            Column::make('date')->title('Date of Payment'),          
            Column::computed('Action')
                  ->exportable(false)
                  ->printable(false)
                  ->width(120)
                  ->addClass('text-center'),
        ];
    }

/**
     * Get filename for export.
     *
     * @return string
     */
    protected function filename()
    {
        return 'Payment_' . date('YmdHis');
    }
}