33 lines
1009 B
PHP
33 lines
1009 B
PHP
<?php
|
|
|
|
namespace App\Services\Dashboard\Province\OperatorDialogues;
|
|
|
|
use App\Facades\DataTable\DataTableFacade;
|
|
use App\Models\OperatorDialogue;
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class DataTableService
|
|
{
|
|
public function index(Request $request)
|
|
{
|
|
$query = DB::table('asteriskcdrdb.cdr')
|
|
->leftJoin('roaddb.operator_dialogues', 'asteriskcdrdb.cdr.uniqueid', '=', 'roaddb.operator_dialogues.cdr_unique_id')
|
|
->select(
|
|
'asteriskcdrdb.cdr.*',
|
|
DB::raw("CONCAT('" . url('recordings') . "/', DATE_FORMAT(calldate, '%Y/%m/%d/'), recordingfile) AS recording_url")
|
|
)
|
|
->where('dst', '<>', '')
|
|
->where('lastapp', '=', 'Dial')
|
|
->where('duration', '>', 0)
|
|
->where('recordingfile', '<>', '');
|
|
|
|
return DataTableFacade::run(
|
|
$query,
|
|
$request,
|
|
allowedFilters: ['*'],
|
|
allowedSortings: ['*'],
|
|
);
|
|
}
|
|
}
|