@php use App\Models\Cases;use App\Models\CasesInfo\Stage;use App\Services\Dashboard\DashboardService; @endphp
@inject('widgetHelper', '\App\Helpers\OnDemandReportWidgetHelper')
@include('reports.on-demand.templates.incl_style')

<section>
  <div style="float: left; width: 65%">
    <h1 style="font-family: 'Red Hat Display', Helvetica, sans-serif; margin: 0; padding: 0;
    font-weight: bold;
    font-size: 28px;
    color: #3A6E69;">TLP AMBER CISO</h1>
    <span style="font-family: 'Red Hat Display', Helvetica, sans-serif;  margin: 0; padding: 0;
    font-size: 24px;
    color: #3A6E69;
    margin-bottom: 8px;">EXECUTIVE REPORT</span>
    <div class="report-widget-comment" style="margin-top: 20px;">
      {{ $isLatam?'El informe incluye: RIESGO, Ciberseguridad e Información Operacional.':'The report includes: RISK, Cybersecurity and Operational information.' }}
    </div>
  </div>
  <div style="float: left; width: 35%">
    <div style="padding: 20px;
     margin-left: 5mm;
    background: #2E3E4D;
    border-radius: 5px;">
      <span style="font-family:'Red Hat Display', Helvetica, sans-serif;
      font-weight: bold;
      font-size: 13px;
      /*text-transform: uppercase;*/
      color: #ffffff;">{{ $isLatam?'Sobre este reporte':'About this report' }}</span>
      <p style="font-family: 'Nunito Sans', Helvetica, sans-serif;
       font-size: 12px;
       color: #ffffff;">
        {{ $isLatam?'Este informe a pedido proporciona información de nivel ejecutivo sobre el estado de la ciberseguridad para su organización, incluidos los principales indicadores de seguridad y rendimiento.':
'This on-demand report provides executive level information as of the state of Cybersecurity for your organization including top security indicators and performance.' }}</p>
    </div>
  </div>
</section>

<h1 class="report-tab-title">RISK</h1>
<section>
  <div style="float: left; width: 33%;">
    <div style="page-break-inside: avoid; padding-right: 7mm;">
      <p style="text-align: center"><strong class="report-widget-title">
          Actual Risk
        </strong></p>
      <div class="report-text-wrapper">
        {!! \App\Widgets\Dashboard\CurrentActualRiskWidget::renderBody() !!}
      </div>
    </div>
  </div>
  <div style="float: left; width: 33%;">
    <div style="page-break-inside: avoid; padding-left: 7mm;">
      <p style="text-align: center"><strong class="report-widget-title">
          Accepted Risk
        </strong></p>
      <div class="report-text-wrapper">
        {!! \App\Widgets\Dashboard\CurrentAcceptedRiskWidget::renderBody() !!}
      </div>
    </div>
  </div>
  <div style="float: left; width: 33%;">
    <div style="page-break-inside: avoid; padding-left: 7mm;">
      <p style="text-align: center"><strong class="report-widget-title">
          Confidence
        </strong></p>
      <div class="report-text-wrapper">
        {!! \App\Models\ServiceGroup::getRiskConfidence() !!}
      </div>
    </div>
  </div>
</section>

<section>
  <div style="page-break-inside: avoid;">
    <h3 class="report-widget-title">
      {{ \App\Widgets\Dashboard\OverallAcceptedRiskLevelWidget::renderTitle() }}
    </h3>
    <div>
      <img src="{{ route('generate-chart',['lineChart','report_id'=>$report->id,'widget_id'=>1000001]) }}"
           style="margin-bottom: -10mm;">
    </div>
  </div>
</section>

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>529])


<h1 class="report-tab-title">VULNERABILITY</h1>

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>179])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>520])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>528])

<h1 class="report-tab-title">THREATS</h1>
@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>515])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>518])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>521])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>522])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>523])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>524])

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>530])

<h1 class="report-tab-title">OPERATIONAL</h1>
<section>
  <div style="page-break-inside: avoid;">

    <p class="report-widget-title">Total Number of Cases</p>
    <table class="table table-chrome table-striped result-table">
      <tbody>
      <tr>
        <td>Open</td>
        <td>{{ Cases::countByStatus([Cases::STATUS_OPEN]) }}</td>
      </tr>
      <tr>
        <td>Answered</td>
        <td>{{ Cases::countByStatus([Cases::STATUS_INFORMATIVE, Cases::STATUS_SUSPENDED]) }}</td>
      </tr>
      <tr>
        <td>Closed</td>
        <td>{{ Cases::countByStatus([Cases::STATUS_CLOSED]) }}</td>
      </tr>
      </tbody>
    </table>
  </div>
</section>

<section>
  <p class="report-widget-title">Notable Events</p>
  <table style="margin: 10px auto; width: 100%">
    <thead>
    <tr>
      <th>Notable Event Type</th>
      <th style="padding-left: 10px;">How Many #</th>
    </tr>
    </thead>
    <tbody>
    @forelse($report->data['notableTypes'] ?? [] as $type => $qty)
      <tr>
        <td>{{ $type }}</td>
        <td style="padding-left: 10px;">{{ $qty }}</td>
      </tr>
    @empty
      <tr>
        <td></td>
        <td style="padding-left: 10px;">N/A</td>
      </tr>
    @endforelse
    </tbody>
  </table>
</section>

<section>
  <p class="report-widget-title">Total Remediation Cases by Stage</p>
  @php
    $groupedByStageAndQueueCases=$report->data['groupedByStageAndQueueCases'] ?? [];
  @endphp
  <table style="margin: 10px auto; width: 100%">
    <thead>
    <tr>
      <th></th>
      @php
        $rStages=\App\Models\CasesInfo\Stage::getRemediationStage();
        $queues = \App\Models\Queue::getSkywatchList();
      @endphp
      @foreach($rStages as $stage)
        <th>{{ $stage->name }}</th>
      @endforeach
    </tr>
    </thead>
    <tbody>
    @php
      $totals = array_fill(0, count($rStages), 0);
    @endphp
    @foreach($groupedByStageAndQueueCases as $queue=>$casesByStages)
      <tr>
        @if(isset($queues[$queue]))
          only skywatch queues
          <td>{{ $queues[$queue] }}</td>
          @foreach($rStages as $index => $stage)
            <td>
              @php
                $caseCount = $casesByStages[$stage->name] ?? 0;
                $totals[$index] += $caseCount;
              @endphp
              {{ $caseCount }}
            </td>
          @endforeach
        @endif
      </tr>
    @endforeach
    <tr style="font-weight: bold">
      <td>Total</td>
      @foreach($totals as $total)
        <td>{{ $total }}</td>
      @endforeach
    </tr>
    </tbody>
  </table>
</section>

<section>
  <div style="page-break-inside: avoid;">
    <h3 class="report-widget-title">
      Vulnerabilities Resolved Over Time
    </h3>
    <div>
      <img src="{{ route('generate-chart',['lineChart','report_id'=>$report->id,'widget_id'=>1000005]) }}"
           style="margin-bottom: -10mm;">
    </div>
  </div>
</section>

<section>
  <div style="page-break-inside: avoid;">
    <h3 class="report-widget-title">
      Vulnerabilities: Average Time to Resolve
    </h3>
    <div>
      <img src="{{ route('generate-chart',['lineChart','report_id'=>$report->id,'widget_id'=>1000006]) }}"
           style="margin-bottom: -10mm;">
    </div>
  </div>
</section>

<section>
  <div style="page-break-inside: avoid;">
    <p class="report-widget-title">Operational Metrics per Queue Over Time</p>
    <table style="margin: 10px auto; width: 100%">
      <thead>
      <tr>
        <th>Divisions</th>
        <th>AVG. Time To Resolve, H</th>
        <th>AVG. Time To Respond, H</th>
      </tr>
      </thead>
      <tbody>
      @php
        $timeByQueue=$report->data['timeByQueue'] ?? []
      @endphp
      @foreach(\App\Models\Queue::getSkywatchList() as $qId=>$qName)
        <tr>
          <td>{{ $qName }}</td>
          <td
            style="text-align: center">{{ time_to_h(isset($timeByQueue[$qId])?(isset($timeByQueue[$qId]['time_to_resolve'])?$timeByQueue[$qId]['time_to_resolve']:0):0) }}</td>
          <td
            style="text-align: center">{{ time_to_h(isset($timeByQueue[$qId])?(isset($timeByQueue[$qId]['time_to_respond'])?$timeByQueue[$qId]['time_to_respond']:0):0) }}</td>
        </tr>
      @endforeach
      </tbody>
    </table>
  </div>
</section>

<section>
  <div style="page-break-inside: avoid;">
    <h3 class="report-widget-title">
      Monthly Average Time per Department
    </h3>
    <div>
      <img src="{{ route('generate-chart',['lineChart','report_id'=>$report->id,'widget_id'=>1000004]) }}"
           style="margin-bottom: -10mm;">
    </div>
  </div>
</section>

<section>
  @php
    $groupedStages = Stage::query()
                        ->select('id', 'group', 'case_type_id')
                        ->groupBy(['case_type_id'])
                        ->with('caseType')
                        ->get();

              function formatSecondsBlade($seconds): string
              {
                  $seconds = (int)$seconds;
                  $d = floor($seconds / 86400);
                  $seconds %= 86400;
                  $h = floor($seconds / 3600);
                  $seconds %= 3600;
                  $m = floor($seconds / 60);
                  $s = $seconds % 60;
                  return "{$d}d {$h}h {$m}m {$s}s";
              }

  @endphp

  @foreach($groupedStages as $stage)
    <section style="page-break-inside: avoid;">
      <h2>{{$stage->group}}</h2>
      @php
        $additionalDashboardData = DashboardService::init()->handle($stage->case_type_id);
        $stages = $additionalDashboardData['stages'];
        $averageTimeRemediatePerStage = $additionalDashboardData['averageTimeRemediatePerStage'];
        $countCasesPerStage = $additionalDashboardData['countCasesPerStage'];
      @endphp
      <h3>Average Time to Remediate</h3>
      <table style="margin: 0 auto 14px; width: 100%">
        <thead>
        <tr>
          <th>Stages</th>
          <th>How Many #</th>
        </tr>
        </thead>
        <tbody>
        @php
          $lastStage = $stages->last();
        @endphp
        @foreach($stages as $stage)
          <tr>
            @if($stage->id !== $lastStage->id)
              <span></span>
              <td>{!! $stage->name !!}</td>
              <td>{{ formatSecondsBlade($averageTimeRemediatePerStage->get($stage->id)) }}</td>
            @endif
          </tr>
        @endforeach
        </tbody>
      </table>
      <h3>Workload</h3>
      <table style="margin: 0 auto 14px; width: 100%">
        <thead>
        <tr>
          <th>Stages</th>
          <th>How Many #</th>
        </tr>
        </thead>
        <tbody>
        @php
          $lastStage = $stages->last();
        @endphp
        @foreach($stages as $stage)
          <tr>
              <td>{!! $stage->name !!}</td>
              <td>{{ $countCasesPerStage->get($stage->id) ?? 0 }}</td>
          </tr>
        @endforeach
        </tbody>
      </table>

    </section>

  @endforeach


</section>

<div style="page-break-inside: avoid;">
  <h1 class="report-tab-title" >DAILYBRIEF</h1>
</div>

<section>
  <div class="report-cols" style="text-align: center">
    <h3>Active High-Severity Items</h3>
    <div>
      @php
        $caseAccountStatistic = $report->data['caseAccountStatistic'] ?? [];
        $openCaseCountStatistic = $caseAccountStatistic['open_cases_count'] ?? 0;
        $countOpenMssIntCases = $report->data['countOpenMssIntCases'] ?? 0;

        if($countOpenMssIntCases - $openCaseCountStatistic > 0){
          $class = 'red-color';
          $arrow = '&uarr;';
        } elseif ($countOpenMssIntCases - $openCaseCountStatistic < 0) {
          $class = 'green-color';
          $arrow = '&darr;';
        } else {
          $class = 'grey-color';
          $arrow = '';
        }
      @endphp
      <div class="value" style="color: black; font-size: 24px; font-weight: bold;">
        {{$countOpenMssIntCases}}
      </div>
      <div class="trend {{$class}}" style="font-size: 18px;">
        <span>
          {!! $arrow !!}
          {{ ($countOpenMssIntCases - $openCaseCountStatistic) > 0 ? '+' : '' }}{{$countOpenMssIntCases - $openCaseCountStatistic}}
        </span>
      </div>
    </div>
  </div>

  <div style="text-align: center">
    <h3>Executive Action Required</h3>
    <div>
      @php
        $executiveActionRequiredCaseIds = $report->data['executiveActionRequiredCaseIds'] ?? [];
      @endphp
      @if(!empty($executiveActionRequiredCaseIds))
        <div>
          <span style="color: red; font-size: 25px">&#9650;</span>

          <div>
            {{ count($executiveActionRequiredCaseIds) }}
            {{ count($executiveActionRequiredCaseIds) === 1 ? 'item' : 'items' }}
            pending executive awareness or decision
          </div>
        </div>
      @else
        <span style="color: green; font-size: 25px">&#10003;</span>
        <div>
          No executive action required today
        </div>
      @endif
    </div>
  </div>
</section>

@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>680])
@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>681])
@include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>682])

<section>
  <h3 class="report-widget-title">
    Ongoing cases
  </h3>
  <table style="margin: 0 auto 14px; width: 100%">
    <thead>
    <tr>
      <th>Case #</th>
      <th>Service</th>
      <th>Priority</th>
      <th>Hours</th>
      <th>Status</th>
    </tr>
    </thead>
    <tbody>
    @foreach($report->data['cases'] ?? [] as $case)
      <tr>
        <td>{{ $case['id'] . ' ' . $case['name']  }}</td>
        <td>{{ $case['service']['short_name'] ?? '' }}</td>
        <td>{{ \App\Models\Cases::getPriorityName($case['priority']) ?? '' }}</td>
        <td>{{ \App\Models\Cases::getTimeCase($case['id']) ?? '' }}</td>
        <td>{{ \App\Models\Cases::getStatusName($case['status']) ?? '' }}</td>
      </tr>
    @endforeach
    </tbody>
  </table>
</section>

<section>
  <h3 class="report-widget-title">
    Cybersecurity News
  </h3>
  <table style="margin: 0 auto 14px; width: 100%">
    <thead>
    <tr>
      <th>Title</th>
      <th>Categories</th>
      <th>Industries</th>
    </tr>
    </thead>
    <tbody>
    @foreach($report->data['news']['data'] ?? [] as $new)
      <tr>
        <td>{{ $new['title']}}</td>
        <td>{{ implode(', ', array_column($new['categories'] ?? [], 'name')) }}</td>
        <td>{{ implode(', ', array_column($new['industries'] ?? [], 'name')) }}</td>
      </tr>
    @endforeach
    </tbody>
  </table>
</section>

<section>
  <div style="height: 1px; width: 100%; clear: both; margin-top: 10px;"></div>
  <p style="font-family: 'Nunito Sans', Helvetica, sans-serif;
    font-size: 14px; padding-top: 0;">
    <img src="/theme/assets/images/on-demand-report/tlpamber.jpg"
         style="float: left; width: 20mm; margin-bottom: -2px; margin-top: 0;"> = Limited disclosure, restricted to
    participants’ organizations.
    Sources may use TLP:AMBER when information requires support to be effectively acted upon, yet
    carries risks to privacy, reputation, or operations if shared outside of the organizations involved.
    Recipients may only share TLP:AMBER information with members of their own organization, and
    with clients or customers who need to know the information to protect themselves or prevent
    further harm. <strong>Sources are at liberty to specify additional intended limits of the sharing: these
      must be adhered to.</strong>
  </p>
</section>