File Manager Lite

Dir: /home/u540325668/domains/sostabazar.in/public_html/websites/sonarSonsar/app/DataTables

[..]

PostDataTable.php (4.15 KB)

TransctionDataTable.php (3.45 KB)

UsersDataTable.php (3.7 KB)

Edit: TransctionDataTable.php

<?php

namespace App\DataTables;

use App\Models\Transction;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
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 Auth;

class TransctionDataTable extends DataTable
{
    /**
     * Build the DataTable class.
     *
     * @param QueryBuilder $query Results from query() method.
     */
    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))

->addColumn('Action', function ($user) {
 return '<a href="/admin/customer/info/'.$user->id.'" class="btn btn-sm btn-primary"></a>.<a href="/admin/customer/edit/'.$user->id.'" class="btn btn-sm btn-success"></a>.<a href="/admin/customer/delete/'.$user->id.'"class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure to delete this Post\')" ></a>';
 })
 ->escapeColumns('Action') 
 ->addColumn('Status', function ($user) {
 return $user->close == 0 ? '' : '';
 })->escapeColumns('Status')
 ->addColumn('checkbox', '<input type="checkbox" name="selected_users[]" value="{{ $id }}">');
 }

/**
     * Get the query source of dataTable.
     */
    public function query(Transction $model): QueryBuilder
    {
      //  return $model->newQuery();
      $user_id = Auth::user()->id;
      return $model= Transction::where('user_id', '=', $user_id);
    }

/**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
                    ->setTableId('schooluc-table')
                    ->columns($this->getColumns())
                    ->minifiedAjax()
                    //->dom('Bfrtip')
                    ->orderBy(1)
                    ->selectStyleSingle()
                    ->buttons([
                        Button::make('excel'),
                        Button::make('csv'),
                        Button::make('pdf'),
                        Button::make('print'),
                        Button::make('reset'),
                        Button::make('reload')
                    ]);
    }

/**
     * Get the dataTable columns definition.
     */
    public function getColumns(): array
    {
        return [
            Column::computed('checkbox')
            ->title('')
            ->orderable(false)
            ->searchable(false)
            ->exportable(false)
            ->printable(false)
            ->width(5)
            ->addClass('text-center'),
             Column::make('created_at')
      ->title('Date & Time'),
      Column::make('user_id'),
      Column::make('job_id'),
      Column::make('desc')->title('Remarks'),
      Column::make('ob')->title('Opening'),
      Column::make('credit')
      ->title('Credit'),
      Column::make('debit')
      ->title('Debit'),
      Column::computed('balance')->title('Balance'),            
  ];
    }

/**
     * Get the filename for export.
     */
    protected function filename(): string
    {
        return 'SchoolUc_' . date('YmdHis');
    }
}