45 lines
1.4 KiB
PHP
45 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers\Integracao\Bnafar;
|
|
|
|
use App\Http\Controllers\Controller;
|
|
use App\Services\Integracao\Bnafar\GerenciamentoEnvioService;
|
|
use Illuminate\Http\Response;
|
|
|
|
class GerenciamentoEnvioController extends Controller
|
|
{
|
|
protected $modulo = 'integracao';
|
|
protected $funcionalidade = 'bnafar-gerenciamento-bnafar';
|
|
|
|
public function index()
|
|
{
|
|
return response()->json(GerenciamentoEnvioService::index(), Response::HTTP_OK);
|
|
}
|
|
|
|
public function show($id)
|
|
{
|
|
return response()->json(GerenciamentoEnvioService::show($id), Response::HTTP_OK);
|
|
}
|
|
|
|
public function datatable()
|
|
{
|
|
return datatables()
|
|
->of(GerenciamentoEnvioService::datatable())
|
|
->filterColumn('integracao_bnafar_protocolo.data_protocolo', function ($query, $keyword) {
|
|
|
|
$query
|
|
->whereRaw("DATE_FORMAT(integracao_bnafar_protocolo.data_protocolo, '%d/%m/%Y') like ?", ["%{$keyword}%"])
|
|
->orWhereRaw(
|
|
"CONCAT(
|
|
SUBSTR(integracao_bnafar_protocolo.data_protocolo,9,2),
|
|
SUBSTR(integracao_bnafar_protocolo.data_protocolo,6,2),
|
|
SUBSTR(integracao_bnafar_protocolo.data_protocolo,1,4)
|
|
) like ?",
|
|
["%{$keyword}%"]
|
|
);
|
|
})
|
|
->skipTotalRecords()
|
|
->make(true);
|
|
}
|
|
}
|