88 lines
2.7 KiB
PHP
88 lines
2.7 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
namespace App\Repositories\Backend\Sangh;
|
||
|
|
|
||
|
|
use App\Models\Sangh;
|
||
|
|
use Exception;
|
||
|
|
use App\Services\BaseService;
|
||
|
|
use Illuminate\Support\Facades\Log;
|
||
|
|
use Yajra\DataTables\Facades\DataTables;
|
||
|
|
|
||
|
|
class SanghService extends BaseService
|
||
|
|
{
|
||
|
|
protected const MODEL = Sangh::class;
|
||
|
|
|
||
|
|
public function prepareSearchQuery($request)
|
||
|
|
{
|
||
|
|
$searchQuery = [];
|
||
|
|
|
||
|
|
try {
|
||
|
|
$searchQuery = $this->query()->with('dharma','sampraday');
|
||
|
|
$columns = ['id','name', 'sangh_type', 'dharma_id', 'sampraday_id','mobile_number', 'status'];
|
||
|
|
|
||
|
|
if (isset($request['name']) && $request['name'] != '') {
|
||
|
|
$searchQuery = $searchQuery->where('name', 'like', '%' . $request['name'] . '%');
|
||
|
|
}
|
||
|
|
|
||
|
|
if (isset($request['order']) && $request['order'] != "") {
|
||
|
|
$searchQuery = $searchQuery->orderBy(
|
||
|
|
$columns[$request['order'][0]['column']],
|
||
|
|
$request['order'][0]['dir']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
} catch (Exception $ex) {
|
||
|
|
Log::error($ex->getMessage());
|
||
|
|
}
|
||
|
|
|
||
|
|
return $searchQuery;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getListing($request)
|
||
|
|
{
|
||
|
|
$response = (object)[];
|
||
|
|
|
||
|
|
try {
|
||
|
|
$dataTableQuery = $this->prepareSearchQuery($request);
|
||
|
|
|
||
|
|
$response = Datatables::of($dataTableQuery)
|
||
|
|
->addColumn(
|
||
|
|
'checkbox_action',
|
||
|
|
function ($sangh) {
|
||
|
|
return $sangh->sangh_checkbox_action;
|
||
|
|
}
|
||
|
|
)
|
||
|
|
->addColumn('sangh_type', function ($sangh) {
|
||
|
|
return config('common-variables.sangh_types_label')[$sangh->sangh_type] ?? '-';
|
||
|
|
})
|
||
|
|
->addColumn('dharma',function($sangh){
|
||
|
|
return $sangh?->dharma?->name ?? '-';
|
||
|
|
})
|
||
|
|
->editColumn('mobile_number', function ($sangh) {
|
||
|
|
return $sangh?->mobile_number ?? '-';
|
||
|
|
})
|
||
|
|
->addColumn('sampraday',function($sangh){
|
||
|
|
return $sangh?->sampraday?->name ?? '-';
|
||
|
|
})
|
||
|
|
->addIndexColumn()
|
||
|
|
->addColumn(
|
||
|
|
'status',
|
||
|
|
function ($sangh) {
|
||
|
|
return $sangh->sangh_status_label;
|
||
|
|
}
|
||
|
|
)
|
||
|
|
->addColumn(
|
||
|
|
'action',
|
||
|
|
function ($sangh) {
|
||
|
|
return $sangh->action_buttons;
|
||
|
|
}
|
||
|
|
)->rawColumns(['status','action', 'checkbox_action'])
|
||
|
|
->make(true);
|
||
|
|
} catch (Exception $ex) {
|
||
|
|
Log::error($ex->getMessage());
|
||
|
|
}
|
||
|
|
|
||
|
|
return $response;
|
||
|
|
}
|
||
|
|
}
|