@extends('pages.gnerc_user.tabs')

@section('data')

@section('breadcrumbs')
  {{ Breadcrumbs::render('data') }}
@endsection
<style>
.modal-content{
  margin-top:35%!important;

}.
.modal-dialog.modal-notify.modal-warning .modal-header{
  background-color: #009688!important;
}
.font-weight-bold {
    font-weight: 569!important;
}
.pb-2, .py-2 {
     padding-bottom: .0rem!important; 
     font-size: 14px;
}

</style> 

<form class="needs-validation form-horizontal" action="abonentslistgnerc/2" id="Myform" method="get">
  @csrf

  <div class="row align-items-center">
    <div class="col-md-3">
      <select class="selectpicker show-tick" title="სექტორი" id="direction_id" name="direction_id">
        <option value="1" {{'1' == app('request')->direction_id ? 'selected="selected"' : '' }}>ელექტრომომარაგება</option>
        <option value="2"{{'2' == app('request')->direction_id ? 'selected="selected"' : '' }}>გაზმომარაგება</option>
        <option value="3"{{'3' == app('request')->direction_id ? 'selected="selected"' : '' }}>წყალმომარაგება</option>
      </select>
    </div>

    <div class="col-md-3">
      <select class="selectpicker show-tick" data-live-search="true" title="კომპანია" id="company_id" name="company_id">
        <optgroup label="ელექტრომომარაგება">
          @foreach ($cl_companies1 as $company)
            <option value="{{$company->company_id}}" {{$company->company_id == app('request')->company_id ? 'selected="selected"' : '' }} title="{{$company->company_name}}">{{$company->company_name}}</option>
          @endforeach
        </optgroup>
        <optgroup label="გაზმომარაგება">
          @foreach ($cl_companies2 as $company)
            <option value="{{$company->company_id}}" {{$company->company_id == app('request')->company_id ? 'selected="selected"' : '' }} title="{{$company->company_name}}">{{$company->company_name}}</option>
          @endforeach
        </optgroup>
        <optgroup label="წყალმომარაგება">
          @foreach ($cl_companies3 as $company)
            <option value="{{$company->company_id}}" {{$company->company_id == app('request')->company_id ? 'selected="selected"' : '' }} title="{{$company->company_name}}">{{$company->company_name}}</option>
          @endforeach
        </optgroup>
      </select>
    </div>

    <div class="col-md-3">
      <button type="submit" class="btn filter-btn" style="color:white; background: #279ab8;">ფილტრაცია</button>
      <a href="/public/abonentslistgnerc/{{app('request')->sector_id}}" style="color:black;">ფილტრაციის გაუქმება</a>
    </div>
  </div>
  <button type="submit" name="export" value="excel" class="btn btn-success">
        ექსპორტი Excel-ში
    </button>

</form>




<table id="dtBasicExample" class="table  list" cellspacing="0" width="100%">
  <thead>
    <tr>
      <th class="th-sm">კომპანია</th>
      <th class="th-sm">მუნიციპალიტეტი</th>
        @foreach ($years as $year)  <th class="th-sm">
        {{ $year }}
        </th>
    @endforeach
      
    </tr>
  </thead>

  <tbody>
            @foreach ($results as $row)
                <tr>
                    <td>{{ $row->company_name }}</td>
                    <td>{{ $row->name }}</td>
                    @foreach ($years as $year)
                        <!-- აქ, $row->{$year} ნიშნავს, რომ ვცდილობთ დინამიურად წლების სახელით ველში მონაცემის მიღებას -->
                        <td>{{ $row->{$year} ?? '' }}</td>
                    @endforeach
                </tr>
            @endforeach
        </tbody>
</table>



@endsection