@inject('widgetHelper', '\App\Helpers\OnDemandReportWidgetHelper')

@include('reports.on-demand.templates.incl_style')

@php
  $topCases = \App\Models\Cases::whereIn('status', [\App\Models\Cases::STATUS_OPEN, \App\Models\Cases::STATUS_INFORMATIVE])
      ->select('id', 'name', 'priority', 'updated_at', 'organization_id', 'control')
      ->where('organization_id', account()->id)
      ->where('control', 'Client')
      ->orderBy('priority', 'desc')
      ->orderBy('updated_at', 'desc')
      ->limit(10)
      ->get();
  $totalCasesOpened = \App\Models\Cases::where('organization_id', account()->id)
      ->where('status', \App\Models\Cases::STATUS_OPEN)
      ->where('control', 'Client')
      ->count();
  $totalCasesAnswered = \App\Models\Cases::where('organization_id', account()->id)
      ->whereIn('status', [\App\Models\Cases::STATUS_INFORMATIVE, \App\Models\Cases::STATUS_CLOSED, \App\Models\Cases::STATUS_SUSPENDED])
      ->whereDate('updated_at', '>', \Carbon\Carbon::today()->subDays(30))
      ->where('control', 'Client')
      ->with('caseTrackTimeMetrics')
      ->count();

  $caseTypeRemediation = \App\Models\SubTypeOfCase::where('name', 'REMEDIATION')->where('gmp_visibility',1)->first();
  $caseTypeRemediation=$caseTypeRemediation?$caseTypeRemediation->id:null;
  $total=[];
@endphp

<section style="page-break-inside: unset">
  <div style="float: left; width: 60%">
    <h1 style="font-family: 'Red Hat Display', Helvetica, sans-serif; margin: 0; padding: 0;
    font-weight: bold;
    font-size: 28px;
    color: #3A6E69;">TLP AMBER</h1>
    <span style="font-family: 'Red Hat Display', Helvetica, sans-serif;  margin: 0; padding: 0;
    font-size: 20px;
    color: #3A6E69;
    margin-bottom: 8px;">CYBERSECURITY SITUATION APPRAISAL REPORT</span>
  </div>
  <div style="float: left; width: 40%">
    <div style="padding: 20px;
    background: #2E3E4D;
        margin-left: 5mm;
    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;">
        This on-demand report provides a consolidated view of cybersecurity indicators and operational indicators for
        the organization during a period of time.
      </p>
    </div>
  </div>
</section>

<h1 class="report-tab-title">SECURITY INDICATORS</h1>
<!--  Notable events      -->
<section>
  <p class="report-widget-title">Notable Events Active For The Past 30 Days</p>
  <table style="width: 100%">
    <thead>
    <tr>
      <th>Notable Event Type</th>
      <th style="padding-left: 10px;">How Many #</th>
    </tr>
    </thead>
    <tbody>
    @forelse(\App\Models\NotableEvent::widgetData() 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>

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

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

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

<div class="report-cols">
  <div class="three-col">
    @include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>500])
  </div>
  <div class="three-col">
    @include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>501])
  </div>
  <div class="three-col">
    @include('reports.on-demand.templates.incl_splunk_widget',['widget_id'=>526])
  </div>
</div>

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

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

<section>
  <div>
    <p class="report-widget-title">Total Current Cases</p>
    <p style="font-family: 'Nunito Sans', Helvetica, sans-serif; font-size: 14px">Open: {{ $totalCasesOpened }} <br>
      Answered: {{ $totalCasesAnswered }}</p>
  </div>
  <div style="margin-top: 10px;">
    <p class="report-widget-title">Average Time to Address and Respond by Divisions</p>
    <table style="width: 100%">
      <thead>
      <tr>
        <th>Divisions</th>
        <th><!--AVG. Time To -->Address, H</th>
        <th><!--AVG. Time To -->Respond, H</th>
      </tr>
      </thead>
      <tbody>
      @foreach(\App\Models\CAD\AssetDivision::getForAccount() as $division)
        <tr>
          <td>{{ $division->name }}</td>
          <td>{{ time_to_h($division->casesRespondTime(true)) }}</td>
          <td>{{ time_to_h($division->casesRespondTime()) }}</td>
        </tr>
      @endforeach
      </tbody>
    </table>
  </div>
</section>

<section>
  <div>
    <p class="report-widget-title">Top 10 Cases:</p>
    <ul style="font-size: 12px;  color: #1f1f1f; font-family: 'Nunito Sans', Helvetica, sans-serif;">
      @forelse($topCases as $case)
        <li>
          <span class="top_cases">{{ $case->id }} {{ $case->name }}</span>
        </li>
      @empty
        <li>
          <p>n/a</p>
        </li>
      @endforelse
    </ul>
  </div>
</section>

<section>
  <div>
    <p class="report-widget-title">Total Remediation Cases By Stage</p>
    <table style="width: 100%">
      <thead>
      <tr>
        <th></th>
        @foreach(\App\Models\CAD\AssetDivision::getForAccount() as $division)
          <th>{{$division->name}}</th>
        @endforeach
      </tr>
      </thead>
      <tbody>
      @foreach(\App\Models\CasesInfo\Stage::getRemediationStage() as $stage)
        <tr>
          <td>{{$stage->name}}</td>
          @foreach(\App\Models\CAD\AssetDivision::getForAccount() as $division)
            <td style="padding-right: 8mm;">{{$s=$division->getCases($caseTypeRemediation)->where('stage_id',$stage->id)->count()}}</td>
            @php
              $total[$loop->index]=(isset($total[$loop->index])?$total[$loop->index]:0)+$s;
            @endphp
          @endforeach
        </tr>
      @endforeach
      <tr>
        <td>Total</td>
        @foreach(\App\Models\CAD\AssetDivision::getForAccount() as $division)
          <td>{{$total[$loop->index]}}</td>
        @endforeach
      </tr>
      </tbody>
    </table>
  </div>
</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: 0 1mm -1mm 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>