<html>
<head>
    <title>
      Gram panchayat Report
  </title>
   <link href="https://fonts.googleapis.com/css2?family=Lato&display=swap" rel="stylesheet">

  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
  <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
  <script src="https://cdn.jsdelivr.net/npm/popper.js@1.12.9/dist/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.0.0/dist/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>


  <!-- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
   <link rel="stylesheet" href="//code.jquery.com/ui/1.13.2/themes/base/jquery-ui.css">
   <script src="https://code.jquery.com/ui/1.13.2/jquery-ui.js"></script> -->
  <style>
    body{
        font-family: 'Times New Roman';
        font-size: 20px;
    }
    @media print {
      @page {
        size: A4 potrait;
    }
                /*.head_class{
                    position: fixed;
                    }*/
                    .print_action{display: none;}
                    .page-break
                    {
                        page-break-before:always;
                    } 
                }

                p{
                    font-size: 20px;
                    margin-bottom: 0px;
                    font-weight: 500;
                    text-align: justify;
                    -moz-text-align-last: justify;
                }

                button#dashboard {
                    background-color: #008CBA;;
                    padding:10px 24px;
                    border:none;
                    font-weight: normal;
                    margin-top : 10px;
                }


                button#print {
                    margin-top: 10px;
                    background-color: #008CBA;;
                    padding:10px 24px;
                    border:none;
                    text-decoration:none;
                    color:white;
                    cursor:pointer;
                    font-weight: normal;
                }

                .vertical-text {
                    writing-mode: vertical-rl;
                    transform: rotate(-180deg);
                }

                p{
                    font-size: 20px !important;
                    margin-bottom: 0px;
                    font-weight: 500;
                }

                .table-bordered td, .table-bordered th, .table-bordered thead td, .table-bordered thead th{
                    vertical-align: middle;
                    font-size: 17.5px !important;
                }

                .table{
                  text-align: center;
                }

                .table thead th {
                    border-bottom: 1px solid #000000 !important;
                }

                .table-bordered td, .table-bordered th {
                    border: 1px solid #000000 !important;
                }

                .table-bordered {
                    border: 1px solid #000000 !important;
                }

            </style>

        </head>

        <body>
        

            <div class="container mt-4">
                <div class="row px-5">
                    <div class="col-3 pl-5 my-auto">
                        <div class="pl-3">
                            <button class="btn btn-primary print_action" id="dashboard"><a href="{{url('/gp_completion_list')}}" style="text-decoration:none;color:white;">Back To Dashboard</a></button>
                        </div>
                    </div>
                    <div class="col-6 offset-1" style="margin-top: 13px;">
					<?php if(isset($_GET['pedding']) && $_GET['pedding']!=""){}else{?>
                    <form action="{{url('grampanchayat_completion')}}" class="print_action mb-0" method="get">
                        <div class="row">
                            <div class="col-9 pr-2">
                                <input type="hidden" name="id" value="{{Request::get('id')}}">
                                 <select class="form-control" name="phase_no">
                                    <option value="">All Phases</option>
                                    @foreach($phase as $ph)
                                    <option value="{{$ph->phase_no}}" @if($request['phase_no']==$ph->phase_no) Selected @endif>Phase-{{$ph->phase_no}}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-3 pl-2">
                                <button class="btn btn-primary print_action" type="submit">Search</button>
                            </div>
                        </div>
                    </form>
					<?php } ?>
               
					</div>
                    <div class="col-2 pl-5 my-auto">
                        <div class="text-right pr-4">
                            <button onclick="window.print();return false;" class="btn btn-primary print_action" id="print">Print</button> 
                        </div>
                    </div>
                
                    <div class="col-12 mt-5">
                        <h5 align="center" class="font-weight-bold">Office of the {{$area_list->area_name??""}} Gram Panchayat</h5>
                        <h5 align="center" class="font-weight-bold">{{$area_list->parent_details->area_name??""}} Mandal, {{$area_list->super_details->area_name??""}} District, Telangana -506</h5>
                    </div>
                    <div class="col-12 mt-4">
                        <div class="row px-5 mt-2">
                            <div class="col-6">
                                <div>
                                    <div class="font-weight-bold" align="left">From</div>
                                    <div class="font-weight-bold" align="left">Sri -</div>
                                    <div class="font-weight-bold" align="left">Panchayat Secretary,</div>
                                    <div class="font-weight-bold" align="left">{{$area_list->area_name??""}} (V),</div>
                                    <div class="font-weight-bold" align="left">{{$area_list->parent_details->area_name??""}} (M),</div>
                                    <div class="font-weight-bold" align="left">{{$area_list->super_details->area_name??""}} (D),</div>
                                    <div class="font-weight-bold" align="left">Telangana - 506</div>
                                </div>
                            </div>
                            <div class="col-6">
                              <div class="font-weight-bold" align="left">To</div>
                              <div class="font-weight-bold" align="left">The General Manger (Technical)</div>
                              <div class="font-weight-bold" align="left">Energy Efficiency Services Ltd (EESL)</div>
                              <div class="font-weight-bold" align="left">Buddha Bhavan, 3rd Floor,</div>
                              <div class="font-weight-bold" align="left">North Block</div>
                              <div class="font-weight-bold" align="left">Ranigunj, Secunderabad,</div>
                              <div class="font-weight-bold" align="left">Telangana - 500003</div>
                          </div>
                      </div>
                      <div class="row px-5">
                        <div class="col-9 mt-4">
                            <div>
                                <h5 align="left">Roc No: ________________________________________________</h5>
                            </div>
                          </div>
                          <div class="col-3 mt-4">
                            <div>
                                <h5 align="left">Dated: __________</h5>
                            </div>
                        </div>
                      </div>
                  </div>
                </div>
            </div>


            <div class="container mt-3">
                <div class="row px-5">
                    <div class="col-12">
                        <div class="px-5 font-weight-bold">Sir,</div>
                        <div class="row px-5 mt-3">
                            <div class="col-1">
                                <div class="font-weight-bold">Sub: </div>
                            </div>
                            <div class="col-11 pl-0">
                                <p class="font-weight-bold">Issuance of the Completion Certificate (CC) for LED Street Lights installation project along with Centralized Control and Monitoring System (CCMS) in {{$area_list->area_name??""}} Gram Panchayat Reg.</p>
                            </div>
                        </div>
                        <div class="row px-5 mt-4">
                            <div class="col-1">
                                <div class="font-weight-bold">Ref: </div>
                            </div>
                            <div class="col-11 pl-0">
                                <p class="font-weight-bold">1. Bi-Lateral Agreement Signed between EESL and {{$area_list->super_details->area_name??""}} District Panchayat Officers of Telangana State for implementation of LED street light project in {{$area_list->area_name??""}} Gram Panchayat in Telangana State signed on 28.10.2020.</p>
                            </div>
                        </div>
                    </div>
                     <?php $sum=0; $wattages=["18 W","35 W","70 W","110 W","190 W"];
                     $query="";
                     if($request->phase_no){
                        $query=" and phase_no=".$request->phase_no;
                     }
                     ?>
                      @foreach($wattages as $value) 

                      <?php $counts= DB::select("SELECT created_at,LED_wattage,    
                        ROUND (   
                        (
                        LENGTH(LED_wattage)
                        - LENGTH( REPLACE ( LED_wattage, '".$value."', '') ) 
                        ) / LENGTH('".$value."')        
                        ) AS count    
                        FROM survey_infos where gram_id=".$area_list->id.$query);
                      $count=0;
                      foreach ($counts as $key => $values) {
                        $count=(int)$values->count+$count;
                        $date= $values->created_at;
                    }
                   // where approve_status=1 and
                    $sum=$sum+$count;
                    ?>  
                    @endforeach

                    <div class="col-12 mt-1">
                        <p class="text-center">******</p>
                    </div>

                    <div class="col-12 mt-1">
                        
                        <p class="px-5">With reference to 1st Cited above, Bi-Lateral agreement signed between EESL and {{$area_list->super_details->area_name??""}} District Panchayat Officer for implementation of LED Street light project in Gram Panchayat under {{$area_list->super_details->area_name??""}} District. In this regard, it is to inform that M/S EESL has supplied {{$sum}} Nos. of LED Lights and completed the installation of {{$sum}} Nos. of LED Street Lights. The complete details of LED Street Lights Supplied & installed in {{$area_list->area_name??""}} Gram Panchayat as on date are mentioned below:</p>
                    </div>
                </div>
            </div>


            <div class="container pt-5">
                <div class="row px-5 mx-5">
                    <div class="col-12 px-0">
                        <table class="table table-bordered mb-0">
                            <thead>
                                <tr>
                                   <th scope="col" >S.No</th>
                                   <th scope="col" width="150"> Type of LED</th>
                                   <th scope="col" >Survey Qty. (Nos.)</th>
                                   <th scope="col">Supplied Qty. (Nos.)</th>
                                   <th scope="col">Installed Qty. (Nos.)</th>
                                   <th scope="col">Balance Qty. to be installed (Nos.)</th>
                                   <th scope="col">Balance Qty. to be supplied (Nos.)</th>
                                   <th scope="col">Last date of Installation (DD/MM/YYYY)</th>
                               </tr>
                           </thead>

                            <tbody>
                                <?php $date=""; $i=1; $sum=0; $wattages=["18 W","35 W","70 W","110 W","190 W"];
                     $query="";
                     if($request->phase_no){
                        $query=" and phase_no=".$request->phase_no;
                    }?>
                              
                                <?php 
                                $counts= collect(DB::select("SELECT count(*) as count , pole_maker_name,Max(s.created_at) as last_date, 
count(case pole_led_wattage  when '18 W'then 1 else null end)as w_18 ,
count(case pole_led_wattage  when '35 W'then 1 else null end)as w_35 ,
count(case pole_led_wattage  when '70 W'then 1 else null end)as w_70 ,
count(case pole_led_wattage  when '110 W'then 1 else null end)as w_110 ,
count(case pole_led_wattage  when '190 W'then 1 else null end)as w_190,
count(case pole_type_of_arms  when '25mm Dia 1.2mt'then 1 else null end)as arm_25 ,
count(case pole_type_of_arms  when '32mm Dia 1.2mt'then 1 else null end)as arm_32 ,
count(case pole_type_of_arms  when '40mm Dia 1.2mt'then 1 else null end)as arm_40 
FROM  survey_infos s INNER join pole_details b on s.id=b.pole_id  where s.gram_id=".$area_list->id." and s.approve_status = 1 ".$query."  GROUP by s.gram_id order by last_date DESC"))->first();

                                ?>  
                                <tr>   
                                    <td><?php $i=1;?>{{$i}}</td>
                                    <td>18 W&nbsp;LED&nbsp;SL</td>
                                    <td><?php $w1=isset($counts->w_18)?$counts->w_18:0?>{{$w1}}</td>
                                    <td><?php $w1=isset($counts->w_18)?$counts->w_18:0?>{{$w1}}</td>
                                    <td><?php $w1=isset($counts->w_18)?$counts->w_18:0?>{{$w1}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                    @if($i==1 && !empty($counts->last_date))
                                    <td rowspan="6" style="border-right: 1px solid #000;border-bottom: 1px solid #000;">{{ (isset($counts->last_date))?Carbon\Carbon::parse($counts->last_date)->format('d/m/Y'):''}}</td>
                                    @endif
                                </tr>
                                <tr>   
                                    <td>2</td>
                                    <td>35 W&nbsp;LED&nbsp;SL</td>
                                    <td><?php $w2=isset($counts->w_35)?$counts->w_35:0?>{{$w2}}</td>
                                    <td><?php $w2=isset($counts->w_35)?$counts->w_35:0?>{{$w2}}</td>
                                    <td><?php $w2=isset($counts->w_35)?$counts->w_35:0?>{{$w2}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                </tr>
                                <tr>   
                                    <td>3</td>
                                    <td>70 W&nbsp;LED&nbsp;SL</td>
                                    <td><?php $w3=isset($counts->w_70)?$counts->w_70:0?>{{$w3}}</td>
                                    <td><?php $w3=isset($counts->w_70)?$counts->w_70:0?>{{$w3}}</td>
                                    <td><?php $w3=isset($counts->w_70)?$counts->w_70:0?>{{$w3}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                </tr>
                                <tr>   
                                    <td>4</td>
                                    <td>110 W&nbsp;LED&nbsp;SL</td>
                                    <td><?php $w4=isset($counts->w_110)?$counts->w_110:0?>{{$w4}}</td>
                                    <td><?php $w4=isset($counts->w_110)?$counts->w_110:0?>{{$w4}}</td>
                                    <td><?php $w4=isset($counts->w_110)?$counts->w_110:0?>{{$w4}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                </tr>
                                <tr>   
                                    <td>5</td>
                                    <td>190 W&nbsp;LED&nbsp;SL</td>
                                    <td><?php $w5=isset($counts->w_190)?$counts->w_190:0?>{{$w5}}</td>
                                    <td><?php $w5=isset($counts->w_190)?$counts->w_190:0?>{{$w5}}</td>
                                    <td><?php $w5=isset($counts->w_190)?$counts->w_190:0?>{{$w5}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                </tr>
                         

                                <tr >              
                                    <td></td>
                                    <td><b>Total</b></td>
                                    <td><?php $sumofmake=isset($counts->count)?$counts->count:0?>{{$sumofmake}}</td>
                                    <td><?php $sumofmake=isset($counts->count)?$counts->count:0?>{{$sumofmake}}</td>
                                    <td><?php $sumofmake=isset($counts->count)?$counts->count:0?>{{$sumofmake}}</td>
                                    <td>0</td>
                                    <td>0</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <div class="container pt-5 pb-4">
                <div class="row px-5 mx-5">
                    <div class="col-12 px-0">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                   <th scope="col">S.No</th>
                                   <th scope="col"> Type of CCMS</th>
                                   <th scope="col">Survey Qty. (Nos.)</th>
                                   <th scope="col">Supplied Qty. (Nos.)</th>
                                   <th scope="col">Installed Qty. (Nos.)</th>
                                   <th scope="col">Balance Qty. to be installed (Nos.)</th>
                                   <th scope="col">Balance Qty. to be supplied (Nos.)</th>
                               </tr>
                           </thead>
                           <tbody>
                            
                            <?php $i=1;?>
                             @foreach($ccms_ty as $ccms)

                               <tr>
                                <td>{{$i}}</td>
                                <td>{{$ccms->ccms_type??""}}</td>
                                <td>{{$ccms->survey??"0"}}</td>
                                <td>{{$ccms->supply??"0"}}</td>
                                <td>{{$ccms->insta??"0"}}</td>
                                <td>{{$ccms->balance_qty??"0"}}</td>
                                <td>{{$ccms->balance_qty_s??"0"}}</td>
                            </tr>
                            <?php $i++; ?>
                            @endforeach
                            <tr>
                                <td></td>
                                <td><b>Total</b></td>
                                <td><b>{{array_sum(array_column(json_decode($ccms_ty),'survey'))}}</b></td>
                                <td><b>{{array_sum(array_column(json_decode($ccms_ty),'supply'))}}</b></td>
                                <td><b>{{array_sum(array_column(json_decode($ccms_ty),'insta'))}}</b></td>
                                <td><b>{{array_sum(array_column(json_decode($ccms_ty),'balance_qty'))}}</b></td>
                                <td><b>{{array_sum(array_column(json_decode($ccms_ty),'balance_qty_s'))}}</b></td>
                            </tr>
                           

                        </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <div class="container">
                <div class="row px-5 mx-5">
                    <div class="col-12 px-0">
                        <p>The break-up of additional infrastructural materials used for the above installations of LED streetlights is as below:</p>
                    </div>
                    <div class="col-12 mt-5 mb-4 px-0">
                     <?php $list=[]; $i=1; $sum=0; $arms=["25mm","32mm","40mm"];
                     $query="";
                     if($request->phase_no){
                        $query=" and phase_no=".$request->phase_no;
                    }?>
                 
                        <?php $counts= DB::select("SELECT types_of_arms,    
                            ROUND (   
                            (
                            LENGTH(types_of_arms)
                            - LENGTH( REPLACE ( types_of_arms, '".$value."', '') ) 
                            ) / LENGTH('".$value."')        
                            ) AS count    
                            FROM survey_infos where gram_id=".$area_list->id.$query);
                            //dd($request->phase_no);
                        
                         $count=array_sum(array_column($counts,'count'));
                         $list[]=$count;
                         
                 

                        $counts= collect(DB::select("SELECT count(*) as count , pole_maker_name,Max(s.created_at) as last_date, 

count(case pole_type_of_arms  when '25mm Dia 1.2mt'then 1 else null end)as arm_25 ,
count(case pole_type_of_arms  when '32mm Dia 1.2mt'then 1 else null end)as arm_32 ,
count(case pole_type_of_arms  when '40mm Dia 1.2mt'then 1 else null end)as arm_40 
FROM  survey_infos s INNER join pole_details b on s.id=b.pole_id  where s.gram_id=".$area_list->id." and s.approve_status = 1 ".$query."  GROUP by s.gram_id order by last_date DESC"))->first();
                        ?> 
                        <table class="table table-bordered">
                             <thead>
                                    <tr>
                                       <th scope="col">S.No</th>
                                       <th scope="col">Particulars</th>
                                       <th scope="col">Unit</th>
                                       <th scope="col">Qty. in Nos.</th>
                                   </tr>
                               </thead>

                               <tbody>
                                  <tr>             
                                    <td>1</td>
                                    <td>Arms & Clamps Set 25mm Inner dia.</td>
                                    <td>Nos.</td>
                                    <td><?php $w11=isset($counts->arm_25)?$counts->arm_25:0?>{{$w11}}</td>
                                </tr>
                                <tr>              
                                    <td>2</td>
                                    <td>Arms & Clamps Set 32mm Inner dia.</td>
                                    <td>Nos.</td>
                                    <td><?php $w12=isset($counts->arm_32)?$counts->arm_32:0?>{{$w12}}</td>
                                </tr>
                                <tr>                
                                    <td>3</td>
                                    <td>Arms & Clamps Set 40mm Inner dia.</td>
                                    <td>Nos.</td>
                                    <td><?php $w13=isset($counts->arm_40)?$counts->arm_40:0?>{{$w13}}</td>   
                                </tr>
                               <!--  <tr>                   
                                    <td>4</td>
                                    <td>1C x 1.5 Sq.mm Aluminum cable for LED installation</td>
                                    <td>Meter</td>
                                    <td>0</td>   
                                </tr> -->
                                <tr>                   
                                    <td>4</td>
                                    <td>1C x 10 Sq.mm Aluminum cable for CCMS installation</td>
                                    <td>Meter</td>
                                    <td>{{$ccms_cable}}</td>   
                                </tr>
                            </tbody>
                        </table>
                    </div>

                    <div class="col-12 px-0">
                        <p>Further the details of installed lights with wattage wise and make wise are placed below:.</p>
                    </div>

                       <div class="col-12 pt-5 pb-4 px-0">
                         <table class="table table-bordered">
       <thead>
         <tr>
          <th>S.No</th>
           
           <th>Make Name</th>
           <th>18 W</th>
           <th>35 W</th>
           <th>70 W</th>
           <th>110 W</th>
           <th>190 W</th>
           <th>Total</th>
          
           
         </tr>
       </thead>
       <tbody>
        <?php $tvw1=0;$tvw2=0;$tvw3=0;$tvw4=0;$tvw5=0; $tcountvw=0;$countvw=0; $i=0;?>

        <?php $ww1=0;$ww2=0;$ww3=0;$ww4=0;$ww5=0; ?>
        <?php  
        //$list=[]; $i++;  $arms=["18 W","35 W","70 W","110 W","190 W"]; $rowspan = []; $data = [];
        
        $query="";
        if($request->phase_no){
                        $query=" and phase_no=".$request->phase_no;
                     }
        if(Request::get('selected_date')){
          $query = " and DATE(updated_at) >='".date('Y-m-d',strtotime(Request::get('selected_date')))."' and DATE(updated_at) <='".date('Y-m-d',strtotime(Request::get('to_date')))."'";
        }?>
                        <?php $counts= DB::select("SELECT count(*) as count , pole_maker_name, 
count(case pole_led_wattage  when '18 W'then 1 else null end)as w_18 ,
count(case pole_led_wattage  when '35 W'then 1 else null end)as w_35 ,
count(case pole_led_wattage  when '70 W'then 1 else null end)as w_70 ,
count(case pole_led_wattage  when '110 W'then 1 else null end)as w_110 ,
count(case pole_led_wattage  when '190 W'then 1 else null end)as w_190 
FROM `pole_details` p INNER join survey_infos s on s.id=p.pole_id   where approve_status=1  and gram_id=".$area_list->id.$query." GROUP by pole_maker_name order by pole_maker_name");
                        
                        
        $c = 1 ; $i++; $vw1=0;$vw2=0;$vw3=0;$vw4=0;$vw5=0;$j=0;$e=0;$f=0;$z=1;

                        ?>  
         <tr> 
           
                            <!-- <td rowspan="{{count($counts)+1}}">{{$i}}</td>  -->
                            
                          </tr>
                          
                         @foreach($counts as $value) 
         
      <?php $sum=$value->w_18+$value->w_35+$value->w_70+$value->w_110+$value->w_190; 
      ?>
        @if($sum>0 )
      <?php $f++; ?>
      @endif

       @if($sum>0)
                               
       <tr>
                            <td>{{$z}}</td> 
                            <td>{{$value->pole_maker_name}}</td>
                            <td><?php $w1=isset($value->w_18)?$value->w_18:0?>{{$w1}}</td>
                            <td><?php $w2=isset($value->w_35)?$value->w_35:0?>{{$w2}}</td>
                            <td><?php $w3=isset($value->w_70)?$value->w_70:0?>{{$w3}}</td>
                            <td><?php $w4=isset($value->w_110)?$value->w_110:0?>{{$w4}}</td>
                            <td><?php $w5=isset($value->w_190)?$value->w_190:0?>{{$w5}}</td>
                                          
                            <td><?php $sumofmake=$w1+$w2+$w3+$w4+$w5;?>{{$sumofmake}}</td>
                           @if($e == '0')
                               <?php $e++;?>
                              
                              
                              @endif
                          </tr>
                            <?php 
                                $vw1=$w1+$vw1;
                                $vw2=$w2+$vw2;
                                $vw3=$w3+$vw3;
                                $vw4=$w4+$vw4;
                                $vw5=$w5+$vw5;
                                $countvw= $vw1+$vw2+$vw3+$vw4+$vw5;
                                  $z++;

                                 
                            ?>
                          @endif
                        @endforeach
                        <?php 
                        $tvw1=$vw1+$tvw1;
                                $tvw2=$vw2+$tvw2;
                                $tvw3=$vw3+$tvw3;
                                $tvw4=$vw4+$tvw4;
                                $tvw5=$vw5+$tvw5;
                                $tcountvw= $tvw1+$tvw2+$tvw3+$tvw4+$tvw5; ?>
                        <tr>

                             <td></td>
            
                            <td><b>Total</b></td>
                            <td><b>{{$vw1}}</b></td>
                            <td><b>{{$vw2}}</b></td>
                            <td><b>{{$vw3}}</b></td>
                            <td><b>{{$vw4}}</b></td>
                            <td><b>{{$vw5}}</b></td>
                            <td><b>{{$countvw}}</b></td>
                            
                        </tr>

        
                           </tbody>
                     </table>
                    </div>
                      
        
                    <div class="col-12 px-0">
                        <p>The above details are in line with the daily installation reports of LED street lights installed and can be considered as the completion certificate.</p>
                    </div>
                    <div class="col-12 mt-4 px-0">
                        <p>Accordingly, EESL is requested to take up the maintenance work with immediate effect.</p>
                    </div>
                </div>
            </div>
       
            <div class="col-12 my-5 pt-4">
            <div class="container">
                <div class="row px-5 mx-5">
                   
                    <div class="col-6 pl-0">
                        <div class="font-weight-bold" align="left">Yours faithfully,</div>
                        <div class="font-weight-bold mt-2" align="left">Sri -</div>
                        <div class="font-weight-bold" align="left">Sarpanch,</div>
                        <div align="left"><span class="font-weight-bold">Gram Panchayat Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->area_name??""}} (V),</span></div>
                        <div align="left"><span class="font-weight-bold">Mandal Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->parent_details->area_name??""}} (M),</span></div>
                        <div align="left"><span class="font-weight-bold">District Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->super_details->area_name??""}} (D),</span></div>
                        <div class="font-weight-bold" align="left">Telangana - 506</div>
                    </div>


                    <div class="col-6">
                        <div class="font-weight-bold" align="left">Yours faithfully,</div>
                        <div class="font-weight-bold mt-2" align="left">Sri -</div>
                        <div class="font-weight-bold" align="left">Panchayat Secretary,</div>
                        <div align="left"><span class="font-weight-bold">Gram Panchayat Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->area_name??""}} (V),</span></div>
                        <div align="left"><span class="font-weight-bold">Mandal Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->parent_details->area_name??""}} (M),</span></div>
                        <div align="left"><span class="font-weight-bold">District Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$area_list->super_details->area_name??""}} (D),</span></div>
                        <div class="font-weight-bold" align="left">Telangana - 506</div>
                    </div>

                </div>
            </div>
        </div>
</body>
</html>