File Manager Lite

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

[..]

PostDataTable.php (4.15 KB)

SchemeOneDataTable.php (3.4 KB)

SchoolDataTable.php (4.48 KB)

SchoolDataTable1.php (4.6 KB)

TransctionDataTable.php (3.45 KB)

UsersDataTable.php (3.7 KB)

Edit: SchoolDataTable.php

<?php

namespace App\DataTables;

use App\Models\Customer;
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 Carbon\Carbon;
use Auth;

class SchoolDataTable 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/print/'.encrypt($user->id).'" target="_blank" class="btn btn-sm btn-primary"></a> <a href="/admin/customer/edit/'.encrypt($user->id).'" class="btn btn-sm btn-success"></a> <a href="/admin/customer/delete/'.encrypt($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) {
 $years = Carbon::parse($user->dobo)->age;
 if ( $years >= 18)
 return '<a target="_blank" href="https://wa.me/91'.$user->mobile.'?text='.$user->name.' YOUR AADHAAR UPDATE APPLICATION SUBMITTED SUCCESSFULLY">WhatsApp</a>';
 
 return ' Under 18' ;
 
 
 
 })->escapeColumns('Status')
 ->addColumn('Mobile', function ($user) {
 
 return '<a href="tel:+91'.$user->mobile.'">'.$user->mobile.'</a>';
 })->escapeColumns('Mobile')
 
 
 
 ->addColumn('checkbox', '<input type="checkbox" name="selected_users[]" value="{{ $id }}">');
 
 }

/**
 * Get the query source of dataTable.
 */
 public function query(Customer $model): QueryBuilder
 {
 // return $model->newQuery();
 $createdByID = Auth::user()->id;
 if ($createdByID === 1) {
 return $model= Customer::where('role_id', '=' , 6)->where('close', '=', 0);
 }
 if($createdByID < 90) {
 return $model= Customer::where('role_id', '=' , 6)->where('close', '=', 0); 
 }
 else {
 return $model= Customer::where('role_id', '=' , 6)->where('close', '=', 0)->where('user_id', '=', $createdByID); 
 }
 }

/**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
                    ->setTableId('school-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('id')->sortable(true),
            Column::make('updated_at')->title('Date')->sortable(true),
            Column::make('name'),
            Column::make('idNumber')->title('Aadhaar'),
            Column::computed('Mobile'),
        //  Column::computed('Status'),
            Column::computed('Action')
                  ->exportable(false)
                  ->printable(false)
                  ->width(200)
                  ->addClass('text-center'),            
        ];
    }

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