@extends('pages.gnerc_user.tabs')

@section('data')

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


  <style>
     
.form-horizontal {
      padding:0%!important;

    }
    #myChart-wrapper{

      width:45%!important;
      height:100%!important;
    }
    .chart--container {
   
        
        /* width: 100%; */
        min-height: 240px!important;
  }
    .chart--container2 {
        height: 100%;
        /* width: 100%; */
        min-height: 350px!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.60rem!important;
}
  </style>
​
  ​<div class="container">
     <div class="row" >  

     <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-3" >
                    <select class="selectpicker  show-tick"  title="საიდი/საიფი" id="saidisaifi" name="saidisaifi" >
                        <option value="1"  {{'1' == app('request')->saidisaifi ? 'selected="selected"' : '' }} title="">საიდი/საიფი სერვისცენტრის მიხედვით</option> 
                        <option value="2"   title=""  {{'2' == app('request')->saidisaifi ? 'selected="selected"' : '' }}>საიდი/საიფი რეგიონის მიხედვით</option>
                        <option value="3"   title=""  {{'3' == app('request')->saidisaifi ? 'selected="selected"' : '' }}>საიდი/საიფი კომპანიის მიხედვით</option>
                      </select>
        </div>
   <div class="col-md-3" >
                    <select class="selectpicker  show-tick"  title="წელი" id="year" name="year" >
                        <option value="2020" {{'2020' == app('request')->year ? 'selected="selected"' : '' }}>2020</option>
                      </select>
        </div>
         <div class="col-md-3" >
              <select class="selectpicker  show-tick"  title="წყვეტის მიზეზი" id="break_reason" name="break_reason">      
                <option value="0" {{'0' == app('request')->break_reason ? 'selected="selected"' : '' }}>ყველა</option> 
                <option value="1" {{'1' == app('request')->break_reason ? 'selected="selected"' : '' }}>გარე</option>
                <option value="2" {{'2' == app('request')->break_reason ? 'selected="selected"' : '' }}>შიდა</option>
                <option value="3"   title=""  {{'3' == app('request')->break_reason ? 'selected="selected"' : '' }}>ფორსმაჟორი</option>
                    
          </select>
           </div>
           <div class="col-md-3" >
              <select class="selectpicker  show-tick"  title="მომსახურება" id="case_id" name="case_id">      
                <option value="0" {{'0' == app('request')->case_id ? 'selected="selected"' : '' }}>ყველა</option> 
                <option value="1"  {{'1' == app('request')->case_id ? 'selected="selected"' : '' }}>გეგმიური წყვეტა</option>
                <option value="2"   {{'2' == app('request')->case_id ? 'selected="selected"' : '' }}>არაგეგმიური წყვეტა</option>
                    
          </select>
           </div> 
           
         </div> 
        </form>
     </div>
     </div> 

  <div class="row">
   <div class="col-md-12" >
      
       <div id="myChart" class="chart--container" style="margin-top:10px;"> </div>
    </div> 
 <div class="col-md-12" >
      
       <div id="myChart2" class="chart--container" style="margin-top:10px;"> </div>
    </div> 
    <div class="col-sm-12" >
    <!--  <table class="table"  style="background:white;margin-top:10px; " id="dtBasicExample2"> -->
    
     <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">კომპანია</th>
            <th scope="th-sm w" class="r">რეგიონი</th>
            <th scope="th-sm w" class="r">სერვისცენტრი</th>
            <th class="th-sm w" class="r">მომსახურება</th>
            <th class="th-sm w" class="r">მიზეზი</th>
            <th class="th-sm w" class="r">საიდი</th>
            <th class="th-sm w" class="r">საიფი</th>
            <th class="th-sm w" class="r">რაოდენობა</th>
          </tr>
        </thead>
        <tbody>
   
          @foreach ($d22 as $d2)
                 <tr>
            <td style="text-align:left">{{$d2->company_name}}</th>
            <td style="text-align:left">{{$d2->region_name}}</th>
            <td style="text-align:left">{{$d2->service_center}}</th>
            <td style="text-align:left">{{$d2->case_name}}</th>
            <td style="text-align:left">{{$d2->break_reason_name}}</th>
            <td style="text-align:left"><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: d2 in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
<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: Trying to get property 'saidi' of non-object in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
<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: d2 in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
<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: Trying to get property 'saidi' of non-object in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
<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: d2 in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
<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: Trying to get property 'saidi' of non-object in C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php on line <i>142</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.0123</td><td bgcolor='#eeeeec' align='right'>420600</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\cportal\resources\views\pages\gnerc_user\saidi_saifi.blade.php' bgcolor='#eeeeec'>...\saidi_saifi.blade.php<b>:</b>0</td></tr>
</table></font>
0:0</th>
            <td style="text-align:left">{{round($d2->saifi,2)}}</th>
            <td style="text-align:left">{{$d2->cnt}}</th>
          </tr>
         @endforeach
        </tbody>
        
    </table>
  </div>
  
  </div>
</div>
<hr>
  <div class="row" >  

     <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-3" >
                    <select class="selectpicker  show-tick"  title="წელი" id="year2" name="year2" >
                        <option value="2020" {{'2020' == app('request')->year2 ? 'selected="selected"' : '' }}>2020</option>
                        <option value="2021"{{'2021' == app('request')->year2 ? 'selected="selected"' : '' }}>2021</option>
                      </select>
        </div>
         </div> 
        </form>
     </div>
     </div>   
   <div class="row"  style="margin-top:11px">  

     
  </div>    


<!--   @yield('chart') -->

 
  <script>
 
      
    var url_string = window.location.href; //       
    var url = new URL(url_string);          
  
    var y = url.searchParams.get("year");
    var b = url.searchParams.get("break_reason");
    var c = url.searchParams.get("case_id");
    var s = url.searchParams.get("saidisaifi");

 $( "#break_reason" ).change(function() 
  {     
   //var year1 = $("#year").val();
   
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "saidi_saifi/1/4",
      
        data: 'break_reason='+$(this).val(),
        success:function(data){
          console.log('$(this).val()');
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'saidi_saifi/1/4?break_reason='+$(this).val()+'&year='+y+'&case_id='+c+'&saidisaifi='+s;
    });

  $( "#case_id" ).change(function() 
  {     
   //var year1 = $("#year").val();
   
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "saidi_saifi/1/4",
      
        data: 'case_id='+$(this).val(),
        success:function(data){
          console.log('$(this).val()');
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'saidi_saifi/1/4?case_id='+$(this).val()+'&year='+y+'&break_reason='+b+'&saidisaifi='+s;
    });
 
 $( "#saidisaifi" ).change(function() 
  {     
   //var year1 = $("#year").val();
   
     $.ajax({
        type:"get",
        dataType: 'json',
        url: "saidi_saifi/1/4",
      
        data: 'saidisaifi='+$(this).val(),
        success:function(data){
          alert($(this).val());
        // $('#requested_volume').append($('<option>').html('აირჩიეთ სიმძლავრე').attr('value', '0'));
         
        }
       });
     window.location.href = 'saidi_saifi/1/4?saidisaifi='+$(this).val()+'&year='+y+'&break_reason='+b+'&case_id='+c;
    });


 let chartConfig = {
      type: 'hbar',
      stacked: true,
      title: {
        text: 'SAIDI',
        adjustLayout: true
      },
      legend: {
        align: 'center',
        layout: 'x3',
        toggleAction: 'remove',
        verticalAlign: 'bottom'
      },
      plot: {
                decimals:2,
        valueBox: {
          text: '%total',
          thousandsSeparator: ',',
          rules: [{
            rule: '%stack-top == 0',
            visible: false
          }]
        },
        offsetY: '-1px',
        rules: [{
          offsetY: '1px',
          rule: '%v <= 0'
        }]
      },
      plotarea: {
        margin: 'dynamic'
      },
     scaleX: {

        values: ['სს ენერგო-პრო ჯორჯია','სს თელასი'],
        guide: {
          visible: false
        },
        item: {
          fontColor: '#999'
        },
        lineColor: 'none',
        lineWidth: '0px',
        tick: {
          visible: false
        }
      },
      scaleY: {
        format: '%v',
        guide: {
          items: [{
              backgroundColor: '#f5f5f5'
            },
            {
              backgroundColor: '#eeeeee'
            }
          ]
        },
        multiplier: true,
        // negation: 'currency',
        refLine: {
          lineColor: '#212121',
          lineWidth: '2px'
        }
      },
      tooltip: {
        text: '%v',
        align: 'left',
        borderRadius: '3px',
        decimals: 2,
        fontColor: '#ffffff',
        negation: 'currency'
      },
      series: [{
          text: 'შიდა',
            values: [39.32, 8.03, 0],
          backgroundColor: '#70cfeb',
          stack: 1
        },
        {
          text: 'გარე',
          values: [12.30,2.32,0],
          backgroundColor: '#4d80a6',
          stack: 1
        }
       
      ]
    };
  chartConfig.plot.animation = {
      method: 'LINEAR',
      delay: 0,
      effect: 'ANIMATION_EXPAND_VERTICAL',
      sequence: 'ANIMATION_BY_PLOT_AND_NODE',
      speed: 10
    }
    // RENDER CHARTS
    // -----------------------------
    zingchart.render({
      id: 'myChart',
      data: chartConfig,
      height: '100%',
      width: '100%',
    });


   let chartConfig2 = {
      type: 'hbar',
      stacked: true,
      title: {
        text: 'SAIFI',
        adjustLayout: true
      },
      legend: {
        align: 'center',
        layout: 'x3',
        toggleAction: 'remove',
        verticalAlign: 'bottom'
      },
      plot: {
decimals:2,
        valueBox: {
          text: '%total',
          thousandsSeparator: ',',
          rules: [{
            rule: '%stack-top == 0',
            visible: false
          }]
        },
        offsetY: '-1px',
        rules: [{
          offsetY: '1px',
          rule: '%v <= 0'
        }]
      },
      plotarea: {
        margin: 'dynamic'
      },
     scaleX: {

        values: ['სს ენერგო-პრო ჯორჯია','სს თელასი'],
        guide: {
          visible: false
        },
        item: {
          fontColor: '#999'
        },
        lineColor: 'none',
        lineWidth: '0px',
        tick: {
          visible: false
        }
      },
      scaleY: {
        format: '%v',
        guide: {
          items: [{
              backgroundColor: '#f5f5f5'
            },
            {
              backgroundColor: '#eeeeee'
            }
          ]
        },
        multiplier: true,
        // negation: 'currency',
        refLine: {
          lineColor: '#212121',
          lineWidth: '2px'
        }
      },
      tooltip: {
        text: '%v',
        align: 'left',
        borderRadius: '3px',
        decimals: 2,
        fontColor: '#ffffff',
        negation: 'currency'
      },
      series: [{
          text: 'შიდა',
            values: [21.55, 5.7, 0],
          backgroundColor: '#70cfeb',
          stack: 1
        },
        {
          text: 'გარე',
          values: [8.46,2.06,0],
          backgroundColor: '#4d80a6',
          stack: 1
        }
       
      ]
    };
  chartConfig2.plot.animation = {
      method: 'LINEAR',
      delay: 0,
      effect: 'ANIMATION_EXPAND_VERTICAL',
      sequence: 'ANIMATION_BY_PLOT_AND_NODE',
      speed: 10
    }
    // RENDER CHARTS
    // -----------------------------
    zingchart.render({
      id: 'myChart2',
      data: chartConfig2,
      height: '100%',
      width: '100%',
    }); 
  </script>
@endsection