@extends('layouts.root', ['menu_activo' => 'inicio'])

@section('contenido')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
  <!-- 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 text-dark">Dashboard</h1>
        </div><!-- /.col -->
        <div class="col-sm-6">
          <ol class="breadcrumb float-sm-right">
            <li class="breadcrumb-item"><a href="#">Home</a></li>
            <li class="breadcrumb-item active">Dashboard</li>
          </ol>
        </div><!-- /.col -->
      </div><!-- /.row -->
    </div><!-- /.container-fluid -->
  </div>
  <!-- /.content-header -->

  <!-- Main content -->
  <section class="content">
    <div class="container-fluid">
      <div class="row">
        <div class="col-12 text-right mb-3">
          <a href="{{url('recargar/dashboard/all')}}" class="btn btn-info">
            <i class="fa fa-sync"></i>
          </a>
        </div>
        <div class="col-12">
          <div class="card">
            <div class="card-header">
              <h5 class="card-title">
                Comprobación de publicaciones
              </h5>
            </div>
            <div class="card-body">
              @php
                $total        = \App\Models\DropPublicaciones::where('estado', 'publicado')
                                                              ->where('para_comprobar', '!=', 'no')
                                                              ->count();

                $comprobado   = \App\Models\DropPublicaciones::where('estado', 'publicado')
                                                              ->where('para_comprobar', '!=', 'no')
                                                              ->where('fecha_comprobar', 'SI')
                                                              ->count(); 
                if($total == 0)
                  $total = 1;
                  
                $porcentaje   = round(($comprobado * 100) / $total);

                $ultima       = \App\Models\RegistroComando::where('comando', 'eliminar_fecha_comprobar')->orderBy('id', 'desc')->first();

                if($ultima != null)
                  $ultima = $ultima->created_at->format('d/m/Y H:i');

              @endphp
              <div class="progress">
                <div class="progress-bar" role="progressbar" style="width: {{$porcentaje}}%;" aria-valuenow="{{$porcentaje}}" aria-valuemin="0" aria-valuemax="100">{{$porcentaje}}%</div>
              </div>
              <br>
              <p>Comprobado: {{$comprobado}} de {{$total}}</p>
              <p>Ultima comprobación total: {{$ultima}}</p>
            </div>
          </div>
        </div>
        <div class="col-12">
          <div class="card">
            <div class="card-header">
              <h5 class="card-title">
                Resumen empresas
              </h5>
            </div>
            <div class="card-body">
              <div class="table table-responsive">
                <table class="table table-striped">
                  <tr>
                    <th></th>
                    <th>Empresa</th>
                    <th>Estado</th>
                    <th>Sistema</th>
                    <th>Activas</th>
                    <th>Pausadas</th>
                    <th>Pendientes</th>
                    <th>Totales</th>
                    <th>Publicadas hoy</th>
                    <th>Eliminando</th>
                    <th>Errores</th>
                    <th>Catalogo</th>
                    <th>Revisión ML</th>
                    <th>Pausadas ML</th>
                    <th>Activas ML</th>
                    <th>Total ML</th>
                  </tr>
                  @foreach(App\Models\Dashboard::all() as $dashboard)
                  <tr>
                    <td>{{$dashboard->empresa->id}}</td>
                    <td>{{$dashboard->empresa->nombre}}</td>
                    <td>
                      @switch($dashboard->empresa->dropConfiguracion->estado_publicaciones)
                      @case("activo")
                      <div class="badge badge-success w100">
                        Activo
                      </div>
                      @break
                      @case("inactivo")
                      <div class="badge badge-danger w100">
                        Inactivo
                      </div>
                      @break
                      @endswitch
                    </td>
                    <td>{{$dashboard->sistema}}</td>
                    <td>{{$dashboard->activas}}</td>
                    <td>{{$dashboard->pausadas}}</td>
                    <td>{{$dashboard->pendientes}}</td>
                    <td>{{$dashboard->empresa->dropConfiguracion->publicaciones_totales}}</td>
                    <td>{{$dashboard->empresa->dropConfiguracion->publicaciones_diarias}}</td>
                    <td>{{$dashboard->eliminadas}}</td>
                    <td>{{$dashboard->errores}}</td>
                    <td>{{$dashboard->catalogo}}</td>
                    <td>{{$dashboard->ml_revision}}</td>
                    <td>{{$dashboard->ml_pausadas}}</td>
                    <td>{{$dashboard->ml_activas}}</td>
                    <td>{{$dashboard->ml_total}}</td>
                  </tr>
                  @endforeach
                </table>
              </div>
            </div>
          </div>
        </div>

        <div class="col-12">
          <div class="card">
            <div class="card-header">
              <h5 class="card-title">
                Historial publicaciones
              </h5>
            </div>
            <div class="card-body">
              
              <canvas id="historialPublicaciones" width="100%" height="500px"></canvas>
              <script>
                  var ctx = document.getElementById('historialPublicaciones').getContext('2d');
                  var taskChart = new Chart(ctx, {
                  type: 'line',
                  options: {
                      responsive: true,
                      maintainAspectRatio: false
                  },
                  data: {
                      labels: [
                        @for($i = 30; $i >=0 ; $i--)
                          "{{\Carbon\Carbon::now()->subDays($i)->format('d/m')}}",
                        @endfor
                          ],
                      datasets: [
                        @foreach(App\Models\Empresa::all() as $empresa)
                          {
                            label: "{{$empresa->nombre}}",
                            backgroundColor: "{{$empresa->color}}",
                            borderColor: "{{$empresa->color}}",                               
                            pointBorderColor: "{{$empresa->color}}",
                            pointBackgroundColor: "{{$empresa->color}}",
                            pointHoverBackgroundColor: "#fff",
                            pointHoverBorderColor: "{{$empresa->color}}",
                            pointBorderWidth: 1,
                            data: [
                              @for($i = 30; $i >= 0; $i--)
                                @if($empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first() != null)  
                                  "{{$empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first()->publicadas}}",  
                                @else
                                  "0",
                                @endif
                              @endfor
                            ]
                        },
                      @endforeach
                    ]
                  },
                });
              </script>
            </div>
          </div>
        </div>

        @foreach(\App\Models\Empresa::all() as $empresa)
          <div class="col-12 col-md-6">
            <div class="card">
              <div class="card-header">
                <h5 class="card-title">
                  {{$empresa->nombre}}
                </h5>
              </div>
              <div class="card-body">
                
                <canvas id="historialPublicacionesEmpresa_{{$empresa->id}}" width="100%" height="400px"></canvas>
                <script>
                    var ctx = document.getElementById('historialPublicacionesEmpresa_{{$empresa->id}}').getContext('2d');
                    var taskChart = new Chart(ctx, {
                    type: 'line',
                    options: {
                        responsive: true,
                        maintainAspectRatio: false
                    },
                    data: {
                        labels: [
                          @for($i = 30; $i >=0 ; $i--)
                            "{{\Carbon\Carbon::now()->subDays($i)->format('d/m')}}",
                          @endfor
                            ],
                        datasets: [
                        {
                          label: "Publicadas",
                          backgroundColor: "#46af66",
                          borderColor: "#46af66",                               
                          pointBorderColor: "#46af66",
                          pointBackgroundColor: "#46af66",
                          pointHoverBackgroundColor: "#fff",
                          pointHoverBorderColor: "#46af66",
                          pointBorderWidth: 1,
                          data: [
                            @for($i = 30; $i >= 0; $i--)
                              @if($empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first() != null)  
                              "{{$empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first()->publicadas}}",  
                              @else
                              "0",
                              @endif
                            @endfor
                          ]
                        },
                        {
                          label: "Eliminadas",
                          backgroundColor: "#c95656",
                          borderColor: "#c95656",                               
                          pointBorderColor: "#c95656",
                          pointBackgroundColor: "#c95656",
                          pointHoverBackgroundColor: "#fff",
                          pointHoverBorderColor: "#c95656",
                          pointBorderWidth: 1,
                          data: [
                            @for($i = 30; $i >= 0; $i--)
                              @if($empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first() != null)  
                              "{{$empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first()->eliminadas}}",  
                              @else
                              "0",
                              @endif
                            @endfor
                          ]
                        },
                        {
                          label: "Pausadas",
                          backgroundColor: "#a5a5a5",
                          borderColor: "#a5a5a5",                               
                          pointBorderColor: "#a5a5a5",
                          pointBackgroundColor: "#a5a5a5",
                          pointHoverBackgroundColor: "#fff",
                          pointHoverBorderColor: "#a5a5a5",
                          pointBorderWidth: 1,
                          data: [
                            @for($i = 30; $i >= 0; $i--)
                              @if($empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first() != null)  
                              "{{$empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first()->pausadas}}",  
                              @else
                              "0",
                              @endif
                            @endfor
                          ]
                        },
                        {
                          label: "Modificadas",
                          backgroundColor: "#2d5dbc",
                          borderColor: "#2d5dbc",                               
                          pointBorderColor: "#2d5dbc",
                          pointBackgroundColor: "#2d5dbc",
                          pointHoverBackgroundColor: "#fff",
                          pointHoverBorderColor: "#2d5dbc",
                          pointBorderWidth: 1,
                          data: [
                            @for($i = 30; $i >= 0; $i--)
                              @if($empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first() != null)  
                              "{{$empresa->dropHistorial->where('date', \Carbon\Carbon::now()->subDays($i)->format('Y-m-d'))->first()->modificadas}}",  
                              @else
                              "0",
                              @endif
                            @endfor
                          ]
                        },
                      ]
                    },
                  });
                </script>
              </div>
            </div>
          </div>
        @endforeach
      </div>
    </div>    
  </section>
</div>
@endsection