{% extends 'base.html.twig' %}

{% block body %}

	<nav class="breadcrumb bg-white push">
		<a class="breadcrumb-item" href="{{ path('home')}}">{{ 'Início'|trans }}</a>
		<a class="breadcrumb-item" href="{{ path('transporte_index')}}">{{ 'Transportes'|trans }}</a>
		<span class="breadcrumb-item active">{{ 'Exportar'|trans }}</span>
	</nav>
	<div class="block">
        <div class="block-header block-header-default">
            <h3 class="block-title">{{ 'Exportar'|trans }}</h3>
        </div>
        <div class="block-content block-content-full">
            <div class="dataTables_wrapper dt-bootstrap4 no-footer">
                <div class="row">
                    <div class="col-sm-12 table-responsive">
                        <table id="t_exportar" class="table table-bordered table-striped table-vcenter" role="grid" aria-describedby="DataTables_Table_1_info">
							<thead>
								<tr>
									<th>{{ 'Estado'|trans }}</th>
									<th>{{ 'Ordem Cliente'|trans }}</th>
									<th>{{ 'Matrícula'|trans }}</th>
									<th>{{ 'Data de Carga'|trans }}</th>
									<th>{{ 'Data de Descarga'|trans }}</th>
									<th>{{ 'Local de Carga'|trans }}</th>
									<th>{{ 'Local de Descarga'|trans }}</th>
									<th>{{ 'Tempo de Trânsito'|trans }}</th>
									<th>{{ 'Fornecedor'|trans }}</th>
									<th>{{ 'Cliente'|trans }}</th>
								</tr>
							</thead>
							<tbody>
							{% for transporte in transportes %}
								{% if transporte.emCurso == 1 %}
									{% set dataDescarga = transporte.dataPrevista %}
								{% else %}
									{% set dataDescarga = transporte.dataDescarga %}
								{% endif %}
								{% set difference = date(dataDescarga).diff(date(transporte.dataCarga)) %}
								<tr>
									{% if transporte.emCurso == 1 %}
										{% if date(transporte.dataCarga) >= date() %}
											<td>{{ 'Em Espera'|trans }}</td>
										{% else %}										
											<td>{{ 'Em Trânsito'|trans }}</td>
										{% endif %}
									{% else %}
										<td>Concluído</td>
									{% endif %}
									<td>{{ transporte.ordemcli }}</td>
									<td>{{ transporte.matricula.matricula }}</td>
									<td>{{ transporte.dataCarga|date("Y-m-d H:i")}}</td>
									<td>{{ dataDescarga|date("Y-m-d H:i")}}</td>
            						<td>
            						{{ transporte.localCarga }}
            						{% if transporte.localCarga2 %}
            							<br>{{ transporte.localCarga2 }}
            						{% endif %}
            						</td>
            						<td>
            						{{ transporte.localDescarga }}
            						{% if transporte.localDescarga2 %}
            							<br>{{ transporte.localDescarga2 }}
            						{% endif %}
            						</td>
									<td>{{ transporte.tempoTransito }} horas</td>
									<td>Encontro de Margens</td>
									<td>{{ transporte.cliente.nome }}</td>													
								</tr>
							{% endfor %}
							</tbody>
						</table>					
                    </div>
                </div>
            </div>
        </div>
    </div>

{% endblock %}

{% block javascripts %}
<script>
$(document).ready(function() {
    $('.m_historico').addClass("open");
    $('.m_historico_exportar').addClass("active");
	
	var table = $('#t_exportar').DataTable( {
		"stateSave": true,
        "order": [[ 3, "desc" ]],
		dom: 'Bfrtip',
		language: {
			buttons: {
				colvisRestore: "Repor"
			}
		}, 
		buttons: [				
			{ extend: 'excel',
				exportOptions: {
					modifier : {
						order : 'index', // 'current', 'applied','index', 'original'
						page : 'all', // 'all', 'current'
						search : 'applied' // 'none', 'applied', 'removed'
					 },
					columns: ':visible'
				},				
				orientation: 'landscape',
			},
			{ extend: 'csv',
				exportOptions: {
					modifier : {
						order : 'index', // 'current', 'applied','index', 'original'
						page : 'all', // 'all', 'current'
						search : 'applied' // 'none', 'applied', 'removed'
					 },
					columns: ':visible'
				},				
				orientation: 'landscape',
			},
			{ extend: 'print',
				exportOptions: {
					modifier : {
						order : 'index', // 'current', 'applied','index', 'original'
						page : 'all', // 'all', 'current'
						search : 'applied' // 'none', 'applied', 'removed'
					 },
					columns: ':visible'
				},				
				orientation: 'landscape',
			},
			{ extend: 'pdf',
				exportOptions: {
					modifier : {
						order : 'index', // 'current', 'applied','index', 'original'
						page : 'all', // 'all', 'current'
						search : 'applied' // 'none', 'applied', 'removed'
					 },
					columns: ':visible'
				},				
				orientation: 'landscape',
			},			
			{ extend: 'colvis',
				text: "{{'Colunas'|trans}}",
				postfixButtons: [ 'colvisRestore' ]
			},	
        ],
		"language": {
            "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/{{'Linguagem'|trans}}.json"
        }
    });
} );
</script>
{% endblock %}

{% block stylesheets %}
{% endblock %}