@extends('pages.gnerc_user.tabs')

@section('data')

@section('breadcrumbs')
  {{ Breadcrumbs::render('newconnection') }}
@endsection
  <script src="js/zingchart.min.js"></script>

  <style>
     
/*    .chart--container {
      height: 100%;
      width: 100%;
      min-height: 530px;
    }*/
    .form-horizontal {
      padding:0%!important;

    }
    #myChart-wrapper{

      width:45%!important;
      height:100%!important;
    }
    .chart--container {
   
        
        /* width: 100%; */
        min-height: 540px!important;
  }
    .chart--container2 {
        height: 100%;
        /* width: 100%; */
        min-height: 340px!important;
  }
    td {
  text-align: center;
}
.bootstrap-select>.dropdown-toggle{
  background: white!important;
}

.r{
  text-align:center;

 } 
.dr{

   margin-top:10%
  
}
tr:hover {
    background-color: #dee2e6;
}
.table th{
  font-size:12px;
}
.td{
   font-size:12px!important;
}

.w{
   padding: 0.05rem!important;
}
</style>


​
  ​<div class="container">
      <div class="row" >
         <div class="col-md-3" >
            <form class="needs-validation form-horizontal" action="search/sms" id="Myform" method="get">
                @csrf
                <input type="hidden" id="sector_id" name="sector_id" value="{{app('request')->sector_id}}" />
              
                      <select class="selectpicker  show-tick"  title="წელი" id="year" name="year" >
                         <option value="2020" {{'2020' == app('request')->year ? 'selected="selected"' : '' }}>2020</option>
                        <option value="2021"{{'2021' == app('request')->year ? 'selected="selected"' : '' }}>2021</option>
                        <option value="2022"{{'2022' == app('request')->year ? 'selected="selected"' : '' }}>2022</option>
                        <option value="2023"{{'2023' == app('request')->year ? 'selected="selected"' : '' }}>2023</option>
                        <option value="2024"{{'2024' == app('request')->year ? 'selected="selected"' : '' }}>2024</option>
                      </select>
                  
               </form>
          </div>
       </div> 
  <div class="row">
   <div class="col-md-5" >
      
       <div id="myChart" class="chart--container" style="margin-top:10px;" title="სტანდარტის შესრულება: დროულად დასრულებული მიერთებები/(ვადაგადაცილებით დასრულებული მიერთებები + რეაგირების გარეშე)  გაანგარიშებაში მონაწილეობას არ იღებს მიმდინარე, დახარვეზებული  და მომხმარებლის მიერ გაუქმებული განაცხადები"> </div>
    </div> 

    <div class="col-md-6" >
     <table class="table"  style="background:white;margin-top:10px; " id="dtBasicExample2">
        <thead style="background:#cfd9e2; ">
          <tr>
            <th class="th-sm w" style="height:74px!important;">&nbsp;&nbsp;&nbsp;კომპანია</th>
            <th class="th-sm w" class="r">სულ</th>
            <th class="th-sm w" class="r">დროულად დასრულებული</th>
            <th class="th-sm w" class="r" style="text-align: center;">ვადაგადაცილებით დასრულებული</th>
            <th class="th-sm w" class="r">დახარვეზებული </th>
            <th class="th-sm w" class="r"  style="text-align: center;">მომხმარებლის უარი </th>
            <th class="th-sm w" class="r">მიმდინარე</th>
            <th class="th-sm w" class="r"  style="text-align: center;">რეაგირების გარეშე</th>
          </tr>
        </thead>
        <tbody>
          @foreach ($cmp as $data)
          <tr class="dr">
            <td style="text-align:left">{{$data->company_name}}</td>
            <td class="r" style="text-align:right">{{number_format($data->b)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->a)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->c)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->d)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->e)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->f)}}</td>
            <td class="r" style="text-align:right">{{number_format($data->g)}}</td>
          </tr>
         @endforeach
        </tbody>
            <tfoot> 
            <tr style="background: #eaeaea; font-weight:bold">
              <td class="col-3" style="text-align:left">სულ</td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
            </tr>
        </tfoot> 
    </table>
  </div>
  </div>

   <div class="row" >  
     <div class="col-md-5" >  

      <table class="table"  style="background:white;margin-top:40px;">
        <thead style="background:#cfd9e2; font-size:11px">
            <th class="th-sm">ადმინისტრაციული ორგანო</th>

            <th class="th-sm">კომპანია</th>
            <th class="th-sm">მიერთებების რაოდენობა</th>
            <th class="th-sm">საშუალო დღეები</th>
        </thead>

         @foreach ($adm as $a) 

            <tr >
              <td class="td" style="text-align: left">{{$a->name}}</td>
              <td class="td" style="text-align: left">{{$a->company_name}}</td>
              <td class="td r">{{number_format($a->cnt)}}</td>
              <td class="td r" >{{round($a->a)}}</td>
            </tr>

            
         @endforeach 
      </table>
    </div>

    <div class="col-md-7" >
        <div id="myChart5" class="chart--container2"></div>
    </div>
</div>
   <div class="row" >  
     <div class="col-md-5" >  

      <table class="table"  style="background:white;margin-top:40px;"  id="dtBasicExample3">
        <thead style="background:#cfd9e2; font-size:11px">
            <th class="th-sm">კომპანია</th>
            <th class="th-sm">სულ</th>
            <th class="th-sm">მიერთებით დასრულდა</th>
            <th class="th-sm">ჯამში რამდენი აბონენტი მიერთდა</th>
        </thead>

         @foreach ($tbl as $a) 

            <tr >
              <td class="td" style="text-align: left">{{$a->company_name}}</td>
              <td class="td" style="text-align: right">{{number_format($a->a)}}</td>
              <td class="td" style="text-align: right">{{number_format($a->b)}}</td>
              <td class="td r"  style="text-align: right">{{number_format($a->c)}}</td>
            </tr>

            
         @endforeach 
           <tfoot> 
            <tr style="background: #eaeaea; font-weight:bold">
             <td class="col-3" style="text-align:left">სულ</td>
              <td class="col-3"  style="text-align:right"></td>
              <td class="col-3"  style="text-align:right"></td>
               <td class="col-3"  style="text-align:right"></td>
            </tr>
        </tfoot>  
      </table>
    </div>
    </div>
<hr>
  <div class="row" >
         <div class="col-md-12" > 
  <form class="needs-validation form-horizontal" action="search/sms" id="Myform" method="get" >
        @csrf
        <input type="hidden" id="sector_id" name="sector_id" value="{{app('request')->sector_id}}" />
        <div class="row" >
           <div class="col-md-3" >
              <select class="selectpicker  show-tick"  title="კომპანია" id="company_id" name="company_id">
                      @foreach ($cmp as $c)
                          <option value="{{$c->company_id}}"  {{$c->company_id == app('request')->company_id ? 'selected="selected"' : '' }} title="{{$c->company_name}}">{{$c->company_name}}</option>
                      @endforeach
          </select>
           </div>
  <div class="col-md-3">
         
          <input type="text" name="daterange"  id="created_date" placeholder="პერიოდი" class="form-control" value="{{app('request')->created_date}}" autocomplete="off" style="background: white"/>


 </div>
         </div> 
        </form>
      </div>
      </div>
  <div class="row"  style="margin-top:35px">  

     <div class="col-sm" >
      
       
            <form class="needs-validation form-horizontal" action="search/sms" id="Myform" method="get">
                @csrf
                <input type="hidden" id="sector_id" name="sector_id" value="{{app('request')->sector_id}}" />
                 <div class="row" >
                  <div class="col-md-6" >
                     <select class="selectpicker  show-tick"  title="მოთხოვნა" id="customer_request" name="customer_request" >
                      @foreach ($cust_req as $c)
                          <option value="{{$c->id}}"  {{$c->id == app('request')->customer_request ? 'selected="selected"' : '' }} title="{{$c->name}}">{{$c->name}}</option>
                      @endforeach
                      </select>
                   </div>
                     <div class="col-md-6" >
                      
                        <select class="selectpicker  show-tick"  title="მუნიციპალიტეტი" id="location" name="location" >
                       @foreach ($location as $cl)
                          <option value="{{$cl->id}}"  {{$cl->id == app('request')->location ? 'selected="selected"' : '' }} title="{{$cl->name}}">{{$cl->name}}</option>
                      @endforeach
                      </select>
                   </div> 
                    </div> 
               </form>
         
      
      <div id="myChart2" class="chart--container2"></div>
    </div>

    <div class="col-sm" >
      <div id="myChart4" class="chart--container2"></div>
  </div>
</div>    

   <div class="row" style="margin-top:80px">  

     <div class="col-sm" >
        <div id="myChart6" class="chart--container2"></div>
  </div>
   <div class="col-sm" >
 <div id="myChart7" class="chart--container2"></div>
 
  </div>
  </div>   
<!--   @yield('chart') -->

 
  <script>

  $(document).ready(function() {

      $('#dtBasicExample2 thead th').each(function(i) {
          calculateColumn(i);
      });
       $('#dtBasicExample3 thead th').each(function(i) {
          calculateColumn3(i);
      });
     
    });
       function calculateColumn(index) {;
            var total = 0;
            $('#dtBasicExample2 tr').each(function() {
                var value = parseInt($('td', this).eq(index).text());
                if (!isNaN(value)) {
                    total += value;
                }
            });
            $('#dtBasicExample2 tfoot td').eq(index).text(total);
             $('#dtBasicExample2 tfoot td:first-child').text('სულ').css('font-size','12px');
        }

function calculateColumn3(index) {;
            var total = 0;
            $('#dtBasicExample3 tr').each(function() {
                var value = parseInt($('td', this).eq(index).text());
                if (!isNaN(value)) {
                    total += value;
                }
            });
            $('#dtBasicExample3 tfoot td').eq(index).text(total);
             $('#dtBasicExample3 tfoot td:first-child').text('სულ').css('font-size','12px');
        }  
    $(function() {
      $('input[name="daterange"]').daterangepicker({
        opens: 'left'
      }, function(start, end, label) {

        console.log("A new date selection was made: " + start.format('DD-MM-YYYY') + '-' + end.format('DD-MM-YYYY'));

  });
});

var url_string = window.location.href; //
var url = new URL(url_string);
var yr1 = url.searchParams.get("year");
var cmp1 = url.searchParams.get("company_id");
var loc1 = url.searchParams.get("location");
var cstm1 = url.searchParams.get("customer_request");
var crtdt1 = url.searchParams.get("created_date");

$('#created_date').on('apply.daterangepicker', function(ev, picker) {
    $.ajax({
        type:"get",
        dataType: 'json',
        url: "newconnection3/3",
      
        data: 'created_date='+$(this).val(),
        success:function(data){
          console.log('$(this).val()');
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'newconnection3/3?created_date='+$(this).val()+'&company_id='+cmp1+'&location='+loc1+'&customer_request='+cstm1+'&year='+yr1;
});

$( "#year" ).change(function() 
  {     
   //var year1 = $("#year").val();
   
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "newconnection3/3",
      
        data: 'year='+$(this).val(),
        success:function(data){
          console.log('$(this).val()');
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'newconnection3/3?year='+$(this).val()+'&company_id='+cmp1+'&location='+loc1+'&customer_request='+cstm1+'&created_date='+crtdt1;
    });
 $( "#company_id" ).change(function() 
  {    alert(); 
   //var year1 = $("#year").val();
   
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "newconnection3/3",
      
        data: 'company_id='+$(this).val(),
        success:function(data){
          console.log('$(this).val()');
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'newconnection3/3?company_id='+$(this).val()+'&year='+yr1+'&location='+loc1+'&customer_request='+cstm1+'&created_date='+crtdt1;
    });
 $( "#location" ).change(function() 
  { 
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "newconnection3/3",
      
        data: 'location='+$(this).val(),
        success:function(data){
        }
       });
     window.location.href = 'newconnection3/3?location='+$(this).val()+'&year='+yr1+'&company_id='+cmp1+'&customer_request='+cstm1+'&created_date='+crtdt1;
    });

  $( "#customer_request" ).change(function() 
  { 
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "newconnection3/3",
      
        data: 'customer_request='+$(this).val(),
        success:function(data){
          alert('1');
        }
       });
     window.location.href = 'newconnection3/3?customer_request='+$(this).val()+'&year='+yr1+'&company_id='+cmp1+'&location='+loc1+'&created_date='+crtdt1;
    });
  var company =  [<br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Undefined variable: cmp in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php on line <i>407</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0131</td><td bgcolor='#eeeeec' align='right'>462712</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php' bgcolor='#eeeeec'>...\newconnection3.blade.php<b>:</b>0</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: Invalid argument supplied for foreach() in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php on line <i>407</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0131</td><td bgcolor='#eeeeec' align='right'>462712</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php' bgcolor='#eeeeec'>...\newconnection3.blade.php<b>:</b>0</td></tr>
</table></font>
];
  var year =  [<br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Undefined variable: year in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php on line <i>411</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0131</td><td bgcolor='#eeeeec' align='right'>462712</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php' bgcolor='#eeeeec'>...\newconnection3.blade.php<b>:</b>0</td></tr>
</table></font>
"",];    
  var cm =  [<br />
<font size='1'><table class='xdebug-error xe-uncaught-exception' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Uncaught Error: Class 'App\Models\cl_companies' not found in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php on line <i>414</i></th></tr>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Error: Class 'App\Models\cl_companies' not found in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php on line <i>414</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0131</td><td bgcolor='#eeeeec' align='right'>462712</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\newconnection3.blade.php' bgcolor='#eeeeec'>...\newconnection3.blade.php<b>:</b>0</td></tr>
</table></font>