@extends('layouts.appReportes')
@section('htmlheader_title','Reportes')
{{-- @endsection --}}
@section('contentheader_title', '')
{{-- @endsection --}}
@section('main-content')
<div class="container-fluid spark-screen">
    <div class="row">
        <div class="col-md-16 col-md-offset-0">
            <div class="box">
                <div class="box-header">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col">
                                <h3 class="box-title">reporte de cantidades</h3>
                                <a href="{{ route('reportes.ReporteExpress') }}" class="btn btn-success pull-right" style="margin-left: 5px;">
                                    <i class="fas fa-plus"></i> Nueva Consulta
                                </a>
                                <button class="btn btn-primary pull-right" type="button" data-toggle="collapse" data-target=".panels" aria-expanded="false" aria-controls="collapseExample">
                                    <div class="text-nowrap bd-highlight">
                                        <i class="fas fa-filter"></i> Segmentacion
                                    </div>
                                </button>
                                <button  style="margin-right: 5px; color:#3c8dbc;" class="btn btn-default pull-right" type="button" data-toggle="collapse" data-target=".filters" aria-expanded="false" aria-controls="collapseExample">
                                    <div class="text-nowrap bd-highlight">
                                        <i class="fas fa-filter"></i> Filtros
                                    </div>
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="box-body">
                    <table id="reporteTable" class=" table-compact table-bordered">
                        <thead>
                            <tr>
                                <th>RM</th>
                                <th># Solicitud</th>
                                <th>Fecha de Recepción</th>
                                <th>Cliente</th>
                                <th>Tipo Cliente</th>
                                <th>NIT Cliente</th>
                                <th>Generador</th>
                                <th>NIT Generador</th>
                                <th>Telefono</th>
                                <th>Dirección de servicio</th>
                                <th>Municipio</th>
                                <th>Localidad</th>
                                <th>Nombre de residuo</th>
                                <th>Estado</th>
                                <th>Corriente</th>
                                <th>Peligrosidad</th>
                                <th>Tratamiento</th>
                                <th>Gestor</th>
                                <th>Cantidad Declarada</th>
                                <th>Cantidad Recibida</th>
                                <th>Cantidad Conciliada</th>
                                <th>No. Certificado</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody id="readyTable">
                            @foreach ($servicios as $servicio)
                                @foreach ($servicio->SolicitudResiduo as $solres)
                                    <tr>
                                        <td>
                                            @if (isset($solres->SolResRM)&&is_array($solres->SolResRM))
                                                @foreach ($solres->SolResRM as $rm)
                                                    {{$rm}} <br>
                                                @endforeach
                                            @endif
                                        </td>
                                        <td>{{$servicio->ID_SolSer}}</td>
                                        <td>
                                        {{date('Y/m/d', strtotime($servicio->ProgVehSalida))}}
                                        </td>
                                        <td>{{$servicio->cliente->CliName}}</td>
                                        <td>
                                            @if($servicio->cliente->CliCategoria == 'Cliente')
                                                <span class="label label-primary">Regular</span>
                                            @elseif($servicio->cliente->CliCategoria == 'ClientePrepago')
                                                <span class="label label-warning">Express</span>
                                            @else
                                                <span class="label label-default">{{$servicio->cliente->CliCategoria ?? 'N/A'}}</span>
                                            @endif
                                        </td>
                                        <td>{{$servicio->cliente->CliNit}}</td>
                                        <td>{{$solres->generespel->gener_sedes->generadors->GenerName}} <br> ({{$solres->generespel->gener_sedes->GSedeName}})</td>
                                        <td>{{$solres->generespel->gener_sedes->generadors->GenerNit}}</td>
                                        <td>{{$solres->generespel->gener_sedes->GSedeCelular}}</td>
                                        <td>{{$solres->generespel->gener_sedes->GSedeAddress}}</td>
                                        <td>{{$solres->generespel->gener_sedes->municipio->MunName}}</td>
                                        <td>{{$solres->generespel->gener_sedes->GSedeMapLocalidad ?? 'N/A'}}</td>
                                        <td>{{$solres->generespel->respels->RespelName}}</td>                                        
                                        <td>{{$solres->generespel->respels->RespelEstado}}</td>
                                        <td>
                                            @if($solres->generespel->respels->YRespelClasf4741 <> null)
                                                {{$solres->generespel->respels->YRespelClasf4741}}
                                            @elseif($solres->generespel->respels->ARespelClasf4741 <> null)
                                                {{$solres->generespel->respels->ARespelClasf4741}}
                                            @else()
                                                {{'N/A'}}
                                            @endif
                                        </td>
                                        <td>{{$solres->generespel->respels->RespelIgrosidad}}</td>
                                        <td>{{$solres->requerimiento->tratamiento->TratName}}</td>
                                        <td>{{$solres->requerimiento->tratamiento->gestor->clientes->CliShortname}}</td>
                                        <td>{{$solres->SolResKgEnviado}}</td>
                                        <td>{{$solres->SolResKgRecibido}}</td>
                                        <td>{{$solres->SolResKgConciliado}}</td>
                                        @if ($solres->certdatoexpress)
                                        @if($solres->certdatoexpress->certificado->CertType == 0)
                                        <td>{{$solres->certdatoexpress->certificado->ID_Cert}}</td>
                                        @else
                                        <td>M{{$solres->certdatoexpress->certificado->CertManifNumero}}</td>
                                        @endif
                                    @else
                                        <td>Certificado no encontrado</td>
                                    @endif
                                        <td>{{$servicio->SolSerStatus}}</td>
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div> 
@endsection

@section('scripts')
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.10.24/af-2.3.5/b-1.7.0/b-colvis-1.7.0/b-html5-1.7.0/b-print-1.7.0/cr-1.5.3/date-1.0.3/kt-2.6.1/rr-1.2.7/sc-2.0.3/sb-1.0.1/sp-1.2.2/sl-1.3.3/datatables.min.js"></script>
<script src="{{asset('//cdn.datatables.net/plug-ins/1.10.24/api/sum().js')}}"></script>
<script>
    @switch(Auth::user()->UsRol)
        @case('Programador')
        @case('AdministradorBogota')
        @case('AdministradorPlanta')
        @case('AsistenteComercial')
        @case('JefeOperaciones')
        @case('Supervisor')
        @case('Tesorería')
        @case('AsistenteLogistica')
        @case('JefeLogistica')
            $(document).ready(function() {
                /*var rol defino el rol del usuario*/
                var rol = "<br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;Auth&quot; not found in C:\laragon\www\sispro.prosarc.com.co\resources\views\reportes\Express.blade.php:155
Stack trace:
#0 {main}
  thrown in <b>C:\laragon\www\sispro.prosarc.com.co\resources\views\reportes\Express.blade.php</b> on line <b>155</b><br />