@extends('adminlte.app')

@section('content')
   
<div class="content-wrapper pb-3">
    <!-- Content Header (Page header) -->
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">
                        Encomendas
                    </h1>
                </div>
                <div class="col-sm-6">
            
                </div>
            </div>
        </div>
    </div>

    @if ($message = Session::get('success'))
    <div class="alert alert-success">
        <p>{!! $message !!}</p>
    </div>
    @endif
    @if ($message = Session::get('error'))
        <div class="alert alert-danger">
            <p>{{ $message }}</p>
        </div>
    @endif
    
     <div class="card mx-3 mt-3">
        <div class="card-header">
            <div class="row">  
                <div class="col-3">
                    Filtros
                </div>
                <div class="col-9 text-right">
                    @if($permissoes->criar_encomenda)
                        <a href="#" >
                            <button class="btn btn-primary" id="btnImportarEncomendas" data-toggle="modal" data-target="#modalImportarEncomendas">Importar Encomendas</button>
                        </a>
                    @endif
                </div>
            </div>
        </div>
        <div class="row m-2">
            <div class="col-12">
                <form id="formFiltrosEncomendas" method="GET" action="{{ route('encomendas_index') }}">
                    <div class="form-row">
                         <div class="form-group col-md-3">
                            <label for="filtroDataInicial">Data Inicial</label>
                            <input type="date" class="form-control" id="filtroDataInicial" name="filtroDataInicial" value="{{ request('filtroDataInicial') ?? date('Y-m-01') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroDataFinal">Data Final</label>
                            <input type="date" class="form-control" id="filtroDataFinal" name="filtroDataFinal" value="{{ request('filtroDataFinal') ?? date('Y-m-t') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroTipoDoc">Tipo Doc</label>
                            <input type="text" class="form-control" id="filtroTipoDoc" name="filtroTipoDoc" value="{{ request('filtroTipoDoc') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroNomeCliente">Nome do Cliente</label>
                            <input type="text" class="form-control" id="filtroNomeCliente" name="filtroNomeCliente" value="{{ request('filtroNomeCliente') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroArtigo">Artigo</label>
                            <input type="text" class="form-control" id="filtroArtigo" name="filtroArtigo" value="{{ request('filtroArtigo') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroContribuinte">Número Contribuinte</label>
                            <input type="text" class="form-control" id="filtroContribuinte" name="filtroContribuinte" value="{{ request('filtroContribuinte') }}">
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroEstado">Estado</label>
                            <select class="form-control" id="filtroEstado" name="filtroEstado">
                                <option value="" {{ request('filtroEstado') == '' ? 'selected' : '' }}>Todos</option>
                                <option value="Transformado" {{ request('filtroEstado') == 'Transformado' ? 'selected' : '' }}>Transformado</option>
                                <option value="Pendente" {{ request('filtroEstado') == 'Pendente' ? 'selected' : '' }}>Pendente</option>
                            </select>
                        </div>
                        <div class="form-group col-md-3">
                            <label for="filtroGestor">Gestor Clientes</label>
                            <select class="form-control" id="filtroGestor" name="filtroGestor">
                                <option value="" {{ request('filtroGestor') == '' ? 'selected' : '' }}>Todos</option>
                                @foreach($gestores as $gestor)
                                    <option value="{{ $gestor->id }}" {{ request('filtroGestor') == $gestor->id ? 'selected' : '' }}>{{ $gestor->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-12 align-self-end text-center">
                            <button type="submit" class="btn btn-primary">Aplicar Filtros</button>
                            <a href="{{ route('encomendas_index') }}" class="btn btn-secondary">Limpar Filtros</a>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <div class="card mx-3 mt-3">
        <div class="card-header">
            <div class="row">  
                <div class="col-3">
                    Lista de Encomendas
                </div>

            </div>
        </div>
        <div class="row m-2">
            <div class="col-12 table-responsive">
                <table id="tabelashow" class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Tipo Doc</th>
                            <th>Série</th>
                            <th>Número Doc</th>
                            <th>Data</th>
                            <th>Entidade</th>
                            <th>Nome</th>
                            <th>Número Contribuinte</th>
                            <th>Artigo</th>
                            <th>Quantidade</th>
                            <th>Preço Sem IVA</th>
                            <th>Total Documento</th>
                            <th>Total IVA</th>
                            <th>Doc Dest</th>
                            <th>Série Dest</th>
                            <th>Número Doc Dest</th>
                            <th>Número Guia Remessa</th>
                            <th>Data Doc Dest</th>
                            <th>Art Des</th>
                            <th>Qtd Dest</th>
                            <th>Prec Dest Com IVA</th>
                            <th>Estado</th>
                            <th>Anulado</th>
                            <th>Fechado</th>
                            <th>CDU Preço Unitario Fornecedor</th>
                            <th>Vendedor</th>
                            <th>Local Carga</th>

                            
                        </tr>
                    </thead>
                    <tbody>

                        @foreach ($encomendas as $encomenda)
                            <tr>
                                <td>{{ $encomenda->id }}</td>
                                <td>{{ $encomenda->programacao_tipo_doc }}</td>
                                <td>{{ $encomenda->programacao_serie }}</td>
                                <td>{{ $encomenda->programacao_num_doc }}</td>
                                <td>{{ $encomenda->data ? date('d/m/Y', strtotime($encomenda->data)) : '' }}</td>
                                <td>{{ $encomenda->entidade }}</td>
                                <td>{{ $encomenda->nome }}</td>
                                <td>{{ $encomenda->num_contribuinte }}</td>
                                <td>{{ $encomenda->artigo }}</td>
                                <td>{{ number_format( $encomenda->qtd, 2, ',', '.') }}</td>
                                <td>{{ number_format($encomenda->preco_sem_iva, 2, ',', '.') }}</td>
                                <td>{{ number_format($encomenda->total_documento, 2, ',', '.') }}</td>
                                <td>{{ number_format($encomenda->total_iva, 2, ',', '.') }}</td>
                                <td>{{ $encomenda->doc_dest }}</td>
                                <td>{{ $encomenda->serie_dest }}</td>
                                <td>{{ $encomenda->num_doc_dest }}</td>
                                <td>{{ $encomenda->num_guia_remessa }}</td>
                                 <td>{{ $encomenda->data_doc_dest ? date('d/m/Y', strtotime($encomenda->data_doc_dest)) : '' }}</td>
                                <td>{{ $encomenda->art_des }}</td>
                                <td>{{ number_format($encomenda->qtd_dest, 2, ',', '.') }}</td>
                                <td>{{ number_format($encomenda->prec_dest_com_iva, 2, ',', '.') }}</td>
                                <td>{{ $encomenda->estado }}</td>
                                <td>{{ $encomenda->anulado ? 'Sim' : 'Não' }}</td>
                                <td>{{ $encomenda->fechado ? 'Sim' : 'Não' }}</td>
                                <td>{{ number_format($encomenda->cdu_preco_unitario_fornecedor, 4, ',', '.') }}</td>
                                <td>{{ $encomenda->vendedor_name }}</td>
                                <td>{{ $encomenda->local_carga }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

{{-- modal importar encomendas. Um form com um input file para importar um arquivo CSV --}}
<div class="modal fade" id="modalImportarEncomendas" tabindex="-1" role="dialog" aria-labelledby="modalImportarEncomendasLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="modalImportarEncomendasLabel">Importar Encomendas</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form id="formImportarEncomendas" action="{{ route('encomendas_importar') }}" method="POST" enctype="multipart/form-data">
                    @csrf
                    <div class="form-group">
                        <label for="arquivoCSV">Selecione o arquivo CSV:</label>
                        <input type="file" class="form-control-file" id="arquivoCSV" name="arquivoCSV" accept=".csv" required>
                    </div>
                    <button type="submit" class="btn btn-primary">Importar</button>
                </form>
            </div>
        </div>
    </div>
</div>

<!-- DataTables  & Plugins -->
<script src={{ asset('/plugins/datatables/jquery.dataTables.min.js') }}></script>
<script src={{ asset('/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}></script>
<script src={{ asset('/plugins/datatables-responsive/js/dataTables.responsive.min.js') }}></script>
<script src={{ asset('/plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}></script>
<script src={{ asset('/plugins/datatables-buttons/js/dataTables.buttons.min.js') }}></script>
<script src={{ asset('/plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}></script>
<script src={{ asset('/plugins/jszip/jszip.min.js') }}></script>
<script src={{ asset('/plugins/pdfmake/pdfmake.min.js') }}></script>
<script src={{ asset('/plugins/pdfmake/vfs_fonts.js') }}></script>
<script src={{ asset('/plugins/datatables-buttons/js/buttons.html5.min.js') }}></script>
<script src={{ asset('/plugins/datatables-buttons/js/buttons.print.min.js') }}></script>
<script src={{ asset('/plugins/datatables-buttons/js/buttons.colVis.min.js') }}></script>

<script>
    $('#tabelashow').DataTable( {
        
          "paging": true,
          "lengthChange": true,
          "searching": false,
          "ordering": true,
          "info": true,
          "autoWidth": false,
          "responsive": false,
          "order": [[0, "asc"]],
          "buttons": [ "csv", "excel", "pdf", {"extend":"print","text":"Imprimir"}, {"extend":"colvis","text":"Colunas"}],
          "lengthMenu": [[8, 10, 20, 25, 50, -1], [8, 10, 20, 25, 50, "All"]],
          "pageLength": 5,
                    "bJQueryUI": true,
                    "oLanguage": {
                        "sProcessing":   "Processando...",
                        "sLengthMenu":   "Registros _MENU_ ",
                        "sZeroRecords":  "Não foram encontrados resultados",
                        "sInfo":         "Mostrando de _START_ até _END_ de _TOTAL_ registros",
                        "sInfoEmpty":    "Mostrando de 0 até 0 de 0 registros",
                        "sInfoFiltered": "",
                        "sInfoPostFix":  "",
                        "sSearch":       "Buscar:",
                        "sUrl":          "",
                        "oPaginate": {
                            "sFirst":    "Primeiro",
                            "sPrevious": "Anterior",
                            "sNext":     "Seguinte",
                            "sLast":     "Último"
                        }
                    }
    
        } ).buttons().container().appendTo('#tabelashow_wrapper .col-md-6:eq(0)');
    
    
</script>
@endsection