<html>
<head>
	<title>Report</title>
	<meta name="csrf-token" content="{{ csrf_token() }}" />
	<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>
  <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;
                    } 
                }


                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;
                    text-align: justify;
                    -moz-text-align-last: justify;
                
                }

                .table-bordered td, .table-bordered th, .table-bordered thead td, .table-bordered thead th{
                    vertical-align: middle;
                    font-size: 15px !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;
                }
                .table td, .table th {
               padding: 5px;
                  }

            </style>

        </head>

        <body>
        

            <div class="container pt-3">
                <div class="row px-5">
                    <div class="col-6 pl-5">
                        <div>
                            <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 pr-5">
                        <div class="text-right">
                            <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 {{strtoupper($gram_details->area_name??"")}} MUNICIPALITY </h5>
                        <h5 align="center" class="font-weight-bold"> {{strtoupper($gram_details->super_details->area_name??"")}} DISTRICT</h5>
                    </div>
                    <div class="col-12 mt-5">
                        <div class="row px-5">
                            <div class="col-6">
                                <div>
                                    <div class="font-weight-bold" align="left">From sri-</div>
                                    <div class="font-weight-bold" align="left">Panchayat Secretary,{{$gram_details->area_name??""}}(V),</div>
                                    <div class="font-weight-bold" align="left">{{$gram_details->parent_details->area_name??""}} (M),</div>
                                    <div class="font-weight-bold" align="left">{{$gram_details->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-5">
                            <div>
                                <h5 align="left">Roc No: ________________________________________________</h5>
                            </div>
                          </div>
                          <div class="col-3 mt-5">
                            <div>
                                <h5 align="left">Dated: __________</h5>
                            </div>
                        </div>
                      </div>
                  </div>
                </div>
            </div>


            <div class="container mt-5">
                <div class="row px-5">
                    <div class="col-12">
                        <div class="px-5 font-weight-bold">Sir,</div>
                        <div class="row px-5 mt-4">
                            <div class="col-1">
                                <div class="font-weight-bold">Sub: </div>
                            </div>
                            <div class="col-11 pl-0">
                                <p class="font-weight-bold">
                                    Sub: Issuance of the Completion Certificate (CC) for LED Street Lights installation project along with Centralized Control and Monitoring System (CCMS)in{{$gram_details->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 Warangal District Panchayat Officersof Telangana State for implementation of LED streetlight project in {{$gram_details->area_name??""}} Gram Panchayat in Telangana State signed on 05.03.2023.</p>
                               
                            </div>
                        </div>
                    </div>
                     

                   

                    <div class="col-12 mt-4">
                        
                        <p class="px-5">This is with reference to above, the {{$gram_details->area_name??""}} Municipality has requested to supply the light through vide reference no. (1&2). {{$gram_details->area_name??""}} Municipality raised the requisition of 5120 no. of lights through Initial Agreement and Supplementary Agreements, against which EESL has supplied 3520 No's of lights and Installed 3520 No's as per infrastructure availability with all required IDC components. EESL has also supplied and Installed 85 No's of CCMS.</p>
                    </div>
                    <div class="col-12 mt-4">
                        
                        <p class="px-5">The complete details of Previous CC from {{$gram_details->area_name??""}} Municipality 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 rowspan="2" colspan="2">Details of Agreement</th>
                                    @foreach($phaselist as $list)
                                   <th colspan="2">CC{{$list->phase_no}}</th>
                                   @endforeach
                                   <th></th>
                               </tr>
                                <tr>

                                    @foreach($phaselist as $list)
                                  
                                    <th colspan="2">Date : {{date('d.m.Y',strtotime($list->created_at))}}</th>
                                   @endforeach
                                   
                                  
                                   
                                   <th></th>
                               </tr>
                              
                               <tr>
                                   <th colspan="2" rowspan="2">Type of LED</th>
                                   <!-- <th>Agreement Quantity</th> -->
                                   @foreach($phaselist as $list)
                                   <th>Suppllied Quantity</th>
                                   <th>Installed Quantity</th>
                                   @endforeach
                                   <th>Total&nbsp;CC&nbsp;Quantity</th>
                               </tr>
                           </thead>

                            <tbody>
                                 <tr>
                                   <td colspan="2">18 W LED SL</td>
                                 
                                   <?php $total=0; $allphasetotal=0;?>
                                   @foreach($phaselist as $list)

                                    <?php $phasetotal=0; $counts= DB::select("SELECT LED_wattage,    
                                         ROUND (  (  LENGTH(LED_wattage)
                                        - LENGTH( REPLACE ( LED_wattage, '18 W', '') )
                                    ) / LENGTH('18 W')        
                                ) AS count FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id); $count=array_sum(array_column($counts,'count')); ?>  
                                   <td>{{$count}}</td>
                                   <td>{{$count}} </td>
                                   <?php $total= $total+$count; $phasetotal = $phasetotal+$total;?>
                                   @endforeach
                                   <td>{{$total}} </td>
                               </tr>
                               <tr>
                                   <td colspan="2">35 W LED SL</td>
                                
                                   <?php $total=0; ?>
                                   @foreach($phaselist as $list)
                                    <?php $counts= DB::select("SELECT LED_wattage,    
                                         ROUND (  (  LENGTH(LED_wattage)
                                        - LENGTH( REPLACE ( LED_wattage, '35 W', '') )
                                    ) / LENGTH('35 W')        
                                ) AS count FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id); $count=array_sum(array_column($counts,'count')); ?>  
                                   <td>{{$count}}</td>
                                   <td>{{$count}} </td>
                                   <?php $total= $total+$count; $phasetotal = $phasetotal+$total; ?>
                                   @endforeach
                                   <td>{{$total}} </td>
                               </tr>
                             
                               <tr>
                                   <td colspan="2">70 W LED SL</td>
                                
                                   <?php $total=0; ?>
                                   @foreach($phaselist as $list)
                                    <?php $counts= DB::select("SELECT LED_wattage,    
                                         ROUND (  (  LENGTH(LED_wattage)
                                        - LENGTH( REPLACE ( LED_wattage, '70 W', '') )
                                    ) / LENGTH('70 W')        
                                ) AS count FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id); $count=array_sum(array_column($counts,'count')); ?>  
                                   <td>{{$count}}</td>
                                   <td>{{$count}} </td>
                                   <?php $total= $total+$count; $phasetotal = $phasetotal+$total; ?>
                                   @endforeach
                                   <td>{{$total}} </td>
                               </tr>
                              
                                <tr>
                                   <td colspan="2">110 W LED SL</td>
                                 
                                   <?php $total=0; ?>
                                   @foreach($phaselist as $list)
                                    <?php $counts= DB::select("SELECT LED_wattage,    
                                         ROUND (  (  LENGTH(LED_wattage)
                                        - LENGTH( REPLACE ( LED_wattage, '110 W', '') )
                                    ) / LENGTH('110 W')        
                                ) AS count FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id); $count=array_sum(array_column($counts,'count')); ?>  
                                   <td>{{$count}}</td>
                                   <td>{{$count}} </td>
                                   <?php $total= $total+$count; $phasetotal = $phasetotal+$total;?>
                                   @endforeach
                                   <td>{{$total}} </td>
                               </tr>
                                <tr>
                                   <td colspan="2">190 W LED SL</td>
                                 
                                   <?php $total=0; ?>
                                   @foreach($phaselist as $list)
                                    <?php $counts= DB::select("SELECT LED_wattage,    
                                         ROUND (  (  LENGTH(LED_wattage)
                                        - LENGTH( REPLACE ( LED_wattage, '190 W', '') )
                                    ) / LENGTH('190 W')        
                                ) AS count FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id); $count=array_sum(array_column($counts,'count')); ?>  
                                   <td>{{$count}}</td>
                                   <td>{{$count}} </td>
                                   <?php $total= $total+$count; $phasetotal = $phasetotal+$total;?>
                                   @endforeach
                                   <td>{{$total}} </td>
                               </tr>
                              
                              <tr>

                                  
                                   <td colspan="2" >Total</td>
                                 
                                   
                                   @foreach($phaselist as $list)
                                    <?php $total3=0;  $total= DB::select("SELECT LED_wattage,    
                                        SUM(ROUND ((LENGTH(LED_wattage)- LENGTH( REPLACE ( LED_wattage, '110 W', '') ) ) / LENGTH('110 W'))) AS w_110,
                                        SUM(ROUND ((LENGTH(LED_wattage)- LENGTH( REPLACE ( LED_wattage, '18 W', '') ) ) / LENGTH('18 W'))) AS w_18,
                                       SUM(ROUND ((LENGTH(LED_wattage)- LENGTH( REPLACE ( LED_wattage, '35 W', '') ) ) / LENGTH('35 W'))) AS w_35,
                                      SUM(ROUND ((LENGTH(LED_wattage)- LENGTH( REPLACE ( LED_wattage, '110 W', '') ) ) / LENGTH('70 W'))) AS w_70,
                                     SUM(ROUND ((LENGTH(LED_wattage)- LENGTH( REPLACE ( LED_wattage, '190 W', '') ) ) / LENGTH('190 W'))) AS w_190     
                                 FROM survey_infos where phase_no= $list->phase_no and approve_status!=2 and gram_id=".$gram_details->id);

                                     foreach ($total as $key => $values) {
                        $sum3=$values->w_190+$values->w_110+$values->w_18+$values->w_35+$values->w_70;
                          }
                           
                               
                     ?>
                                
                                   <td>{{$sum3??'0'}} </td>
                                   <td>{{$sum3??'0'}}   </td>
                                   <?php $total3= $total3+$sum3; ?>
                                   @endforeach

                                   <td>0 </td>
                               </tr>
                             
                            </tbody>
                        </table>

                        <table class="table table-bordered mb-0">
                            <thead>
                                <tr>
                                    <th rowspan="2" colspan="2" style="width: 144.5px;"></th>
                                    @foreach($phaselist as $list)
                                   <th colspan="2">CC{{$list->phase_no}}</th>
                                   @endforeach
                                   <th></th>
                               </tr>
                                <tr>

                                    @foreach($phaselist as $list)
                                  
                                    
                                   @endforeach
                                   
                                   
                               </tr>
                              
                               <tr>
                                   <th colspan="2" rowspan="2">Types of CCMS </th>
                                   <!-- <th>Agreement Quantity</th> -->
                                   @foreach($phaselist as $list)
                                   <th>Suppllied Quantity</th>
                                   <th>Installed Quantity</th>
                                   @endforeach
                                   <th>Total&nbsp;CC&nbsp;Quantity</th>
                               </tr>
                           </thead>

                            <tbody>
                                 
                               <tr>

                                <td colspan="2">{{$ccms_ty->ccms_type??""}}</td>
                                    <?php $ctotal=0; ?>
                                   @foreach($phaselist as $list)
                                   <td>{{$ccms_ty->supply??"0"}} </td>
                                   <td>{{$w1=$ccms_ty->insta??"0"}} </td>
                                   <?php $ctotal=$w1+$ctotal;?>
                                   @endforeach
                                   <td>{{$ctotal}}</td>
                               </tr>

                                 <tr>
                                   <td colspan="2" >Total</td>
                                   
                                   @foreach($phaselist as $list)
                                   <td>{{$ccms_ty->supply??"0"}}</td>
                                   <td>{{$w1=$ccms_ty->insta??"0"}}</td>
                                   @endforeach
                                   <td>{{$ctotal}}</td>
                               </tr>
                             
                            </tbody>
                        </table>

                         
                    </div>
                </div>
            </div>
             <div class="container  mt-5">
                <div class="row px-5 mx-5 ">
                    <div class="col-12 px-0  ">
                      <div class="col-11 pl-0">
                                <p >The break-up additional infrastructural materials used for the above above installations of LED streetlights is as below:</p>
                            </div>
                        </div>
                    </div>            
                </div>

            <div class="container  mt-5 mb-4">
                <div class="row px-5 mx-5 ">
                    <div class="col-12 px-0  ">
                        <table class="table table-bordered pt-5">
                            <thead>
                                <tr>
                                   <th scope="col">Particulars</th>
                                         <td>Unit</td>
                                  
                                    @foreach($phaselist as $list)
                                     <th>CC{{$list->phase_no}}</th>
                                 
                                   @endforeach
                                   <th>Total&nbsp;CC&nbsp;Quantity</th>
                               </tr>
                           </thead>
                           <tbody>

                            
                             <tr>
                                <td>Arms & Clamps Set 25mm Inner dia.</td>
                                <td>Nos.</td>
                                <?php $atotal = 0; ?>
                                 @foreach($phaselist as $list)
                                 <?php $counts= DB::select("SELECT types_of_arms,    
                            ROUND (   
                            (
                            LENGTH(types_of_arms)
                            - LENGTH( REPLACE ( types_of_arms, '25mm', '') ) 
                            ) / LENGTH('25mm')        
                            ) AS count    
                            FROM survey_infos where phase_no=".$list->phase_no." and gram_id=".$gram_details->id);
                            //dd($request->phase_no);
                        
                         $count=array_sum(array_column($counts,'count'));

                          $atotal = $atotal+$count;
                        
                        ?>  
                        <td>{{$count}}</td>
                                  @endforeach
                                  <td>{{$atotal}}</td>
                              </tr>

                              <tr>
                                <td>Arms & Clamps Set 32mm Inner dia..</td>
                          
                                   <td>Nos.</td>
                                <?php $atotal = 0; ?>
                                 @foreach($phaselist as $list)
                                 <?php $counts= DB::select("SELECT types_of_arms,    
                            ROUND (   
                            (
                            LENGTH(types_of_arms)
                            - LENGTH( REPLACE ( types_of_arms, '32mm', '') ) 
                            ) / LENGTH('32mm')        
                            ) AS count    
                            FROM survey_infos where phase_no=".$list->phase_no." and gram_id=".$gram_details->id);
                            //dd($request->phase_no);
                        
                         $count=array_sum(array_column($counts,'count'));

                          $atotal = $atotal+$count;
                        
                        ?>  
                        <td>{{$count}}</td>
                                  @endforeach
                                  <td>{{$atotal}}</td>
                            </tr>


                                 <tr>
                                <td>Arms & Clamps Set 40mm Inner dia.</td>
                                   <td>Nos.</td>
                                <?php $atotal = 0; ?>
                                 @foreach($phaselist as $list)
                                 <?php $counts= DB::select("SELECT types_of_arms,    
                            ROUND (   
                            (
                            LENGTH(types_of_arms)
                            - LENGTH( REPLACE ( types_of_arms, '40mm', '') ) 
                            ) / LENGTH('40mm')        
                            ) AS count    
                            FROM survey_infos where phase_no=".$list->phase_no." and gram_id=".$gram_details->id);
                            //dd($request->phase_no);
                        
                         $count=array_sum(array_column($counts,'count'));

                          $atotal = $atotal+$count;
                        
                        ?>  
                        <td>{{$count}}</td>
                                  @endforeach
                                  <td>{{$atotal}}</td>
                              </tr>

                             <!--  <tr>
                                <td>1C x 1.5 Sq.mm Aluminum cable for LED installation.</td>
                                <td>Meter</td>
                                <?php $atotal = 0; ?>
                                 @foreach($phaselist as $list)
                                 <?php 
                          
                                  $counts = DB::select("SELECT install_qty  
                                AS count 
                                FROM ccms_types inner JOIN area_masters m on m.id=ccms_types.gram_id  where phase_no=".$list->phase_no." and gram_id=".$gram_details->id);
                        
                         $count=array_sum(array_column($counts,'count'));

                          $atotal = $atotal+$count;
                        
                        ?>  
                        <td>{{$count}}</td>
                                  @endforeach
                                  <td>{{$atotal}}</td>
                              </tr>
 -->
                               <tr>
                                <td>1C x 10 Sq.mm Aluminum cable for CCMS installation.</td>
                                <td>Meter</td>
                                <?php $atotal = 0; ?>
                                 @foreach($phaselist as $list)
                                 <?php 
                          
                                  $counts = DB::select("SELECT cable_used  
                                AS count 
                                FROM ccms_types inner JOIN area_masters m on m.id=ccms_types.gram_id  where phase_no=".$list->phase_no." and gram_id=".$gram_details->id);
                        
                         $count=array_sum(array_column($counts,'count'));

                          $atotal = $atotal+$count;
                        
                        ?>  
                        <td>{{$count}}</td>
                                  @endforeach
                                  <td>{{$atotal}}</td>
                              </tr>


                           
                         

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

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

         <div class="container  mt-5">
                <div class="row px-5 mx-5 ">
                    <div class="col-12 px-0  ">
                        <table class="table table-bordered pt-5">
       <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; $i=0;?>

        <?php $ww1=0;$ww2=0;$ww3=0;$ww4=0;$ww5=0; ?>
       
                        <?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=".$gram_details->id." 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>
            </div>
                       
                       
                      

            <div class="container mt-4">
                <div class="row px-5 mx-5">
                    <div class="col-12 px-0">
                        <p>The above details are in line with the daily installation reports of LED street lights 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 maintainance work with immediate effect.</p>
                    </div>
                </div>
            </div>

           <!--  <div class="container mt-5 pt-5 mb-5">
                <div class="row px-5 mb-5 pb-5">
                    <div class="col-8"></div>
                    <div class="col-4">
                        <div class="font-weight-bold" align="left">Yours faithfully,</div>
                        
                        <div align="left"><span class="font-weight-bold">DPO:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal"> {{$gram_details->area_name??""}} </span></div>
                        <div align="left"><span class="font-weight-bold">DPO:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal"> {{$gram_details->area_name??""}} </span></div>
                        <div align="left"><span class="font-weight-bold">DPO:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal"> {{$gram_details->area_name??""}} </span></div>
                        <div align="left"><span class="font-weight-bold">DPO:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal"> {{$gram_details->area_name??""}} </span></div>
                        <div align="left"><span class="font-weight-bold">DPO:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal"> {{$gram_details->area_name??""}} </span></div>
                       
                    </div>
                </div>
            </div>
 -->
    <div class="col-12 mt-5 py-5">
             <div class="container mt-5">
                <div class="row px-5 mx-5">
                    <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">Sarpanch,</div>
                        <div align="left"><span class="font-weight-bold">Gram Panchayat Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$gram_details->area_name??""}} (V),</span></div>
                        <div align="left"><span class="font-weight-bold">Mandal Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$gram_details->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">{{$gram_details->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">{{$gram_details->area_name??""}} (V),</span></div>
                        <div align="left"><span class="font-weight-bold">Mandal Name:</span>&nbsp;&nbsp;&nbsp;<span class="font-weight-normal">{{$gram_details->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">{{$gram_details->super_details->area_name??""}} (D),</span></div>
                        <div class="font-weight-bold" align="left">Telangana - 506.</div>
                    </div>
                </div>
            </div>
        </div>


           
</body>
</html>