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

{% block body %}

	<nav class="breadcrumb bg-white push">
		<a class="breadcrumb-item" href="{{ path('home')}}">Início</a>
		<a class="breadcrumb-item" href="{{ path('transporte_index')}}">Transportes</a>
		<span class="breadcrumb-item active">Exportar</span>
	</nav>
	<div class="block">
        <div class="block-header block-header-default">
            <h3 class="block-title">Exportar</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 class="table table-bordered table-striped table-vcenter" role="grid" aria-describedby="DataTables_Table_1_info">
							<thead>
								<tr>
									<th>Estado</th>
									<th>Ordem</th>
									<th>Matrícula</th>
									<th>Data Carga</th>
									<th>Data Descarga</th>
									<th>Local Carga</th>
									<th>Local Descarga</th>
									<th>Tempo Trânsito</th>
									<th>Fornecedor</th>
									<th>Cliente</th>
									<th>V.Fornecedor</th>
									<th>V.Cliente</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.cancelado == 1 %}
										<td>Cancelado</td>
									{% elseif transporte.emCurso == 1 %}
										{% if date(transporte.dataCarga) >= date() %}
											<td>Em Espera</td>
										{% else %}										
											<td>Em Trânsito</td>
										{% endif %}
									{% else %}
										<td>Concluído</td>
									{% endif %}
									<td>{{ transporte.ordem }}</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>{{ transporte.fornecedor.nome }}</td>
									<td>{{ transporte.cliente.nome }}</td>
									<td>{{ transporte.valorFornecedor }}</td>
									<td>{{ transporte.valorCliente }}</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 = $('.table').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",
				postfixButtons: [ 'colvisRestore' ]
			},	
        ]
    });
} );
</script>
{% endblock %}

{% block stylesheets %}
{% endblock %}