<?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);
    }
}