<?php $__env->startSection('index-content'); ?>
 

<style type="text/css">

	
.table-responsive {
	 width: 100%;
	 height: 76vh;
}
table th,
table td {
	 white-space: nowrap;
}
table tr td:first-child {
	 position: sticky;
	 width: 50px;
	 left: 0;
	 background: #b8daff;
	 color: #000;
	 z-index: 9;
}
table tr td:nth-child(2) {
	 position: sticky;
	 left: 47px;
	 background: #b8daff;
	 color: #000;
	 z-index: 9;
}
table tr th:first-child {
	 position: sticky;
	 width: 50px;
	 left: 0;
/*	 background: #fff;*/
	 color: #000;
	 z-index: 10;
}
table tr th:nth-child(2) {
	 position: sticky;
	 left: 47px;
/*	 background: #fff !important;*/
	 color: #000;
	 z-index: 10;
}
tr.table-warning,
tr.table-success,
tr.table-danger {
	 position: sticky;
	 left: 0;
	 z-index: 10;
	 background: #fff !important;
}
tr.table-success {
	 top: 0px !important;
	 position: sticky !important;
}
tr.table-warning {
	 top: 36px !important;
	 position: sticky !important;
}
tr.table-danger {
	 top: 72px !important;
	 position: sticky !important;
}
table tr th {
	 position: sticky;
	 top: 0;
	 /* z-index: 10;*/
	 background: #fff;
}
.table-danger, .table-danger>td, .table-danger>th {
    background-color: #f5c6cb;
}
.table-warning, .table-warning>td, .table-warning>th {
    background-color: #ffeeba !important;
}
.table-success, .table-success>td, .table-success>th {
    background-color: #c3e6cb;
}
.table-primary, .table-primary>td, .table-primary>th {
    background-color: #b8daff;
}

	
</style>
<section class="content-body p-3" style="top: 3px;padding-top: 0px !important;">
	<div class="col-xs-12 refresh">
		<div class="row">
			<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 pt-2 px-0 px-xs-3 px-sm-2">
				<div class="card bg1 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon text-primary">
							<img src="<?php echo e(asset('backend/assets/images/icons/districts.png')); ?>" alt="" class="img-fluid">
						</span>
						<div class="dash-count">
							<h3 class="my-0"><?php echo e($count); ?> / 7,90,000</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">No. Of LED'S Installed</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 pt-2 px-0 px-xs-3 px-sm-2">
				<div class="card bg2 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon">
							<img src="<?php echo e(asset('backend/assets/images/icons/mandals.png')); ?>" alt="" class="img-fluid">
						</span>
						
                        
						<div class="dash-count">

							<h3 class="my-0"><?php echo e($approved); ?> / 12758</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">No. Of Gram Panchayats Completed</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 pt-2 px-0 px-xs-3 px-sm-2">
				<div class="card bg3 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon">
							<img src="<?php echo e(asset('backend/assets/images/icons/gramam.png')); ?>" alt="" class="img-fluid">
						</span>
						<div class="dash-count">
							<h3 class="my-0"><?php echo e($on_going); ?> / 32</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">No. Of Districts (On Going)</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div>
			<!-- <div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 px-xs-3 px-sm-2">
				<div class="card bg4 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon">
							<img src="<?php echo e(asset('backend/assets/images/icons/1.png')); ?>" alt="" class="img-fluid">
						</span>
						<div class="dash-count">
							<h3 class="my-0">168</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">Total LED's Installed</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 px-xs-3 px-sm-2">
				<div class="card bg5 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon">
							<img src="<?php echo e(asset('backend/assets/images/icons/2.png')); ?>" alt="" class="img-fluid">
						</span>
						<div class="dash-count">
							<h3 class="my-0">168</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">Survey Installation</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div>
			<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4 px-xs-3 px-sm-2">
				<div class="card bg6 mb-3">
					<div class="dash-widget-header">
						<span class="dash-widget-icon">
							<img src="<?php echo e(asset('backend/assets/images/icons/3.png')); ?>" alt="" class="img-fluid">
						</span>
						<div class="dash-count">
							<h3 class="my-0">168</h3>
						</div>
					</div>
					<div class="dash-widget-info">
						<h5 class="text-white">DIC Installation</h5>
						<div class="progress progress-sm mb-0">
							<div class="progress-bar bg-primary w-50"></div>
						</div>
					</div>
				</div>
			</div> -->
		</div>
	</div>
	<?php if(session()->get('role')==0 or session()->get('role')==6): ?>

	<div class="col-xs-12 pt-4 pb-5 ">
	
		<div class="row">
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 px-3 py-3">
				<!--<a href="<?php echo e(url('panchayat_resolution')); ?>" class="catg">-->
				<a href="<?php echo e(url('pr_distict_view')); ?>?url=dashboard" class="catg">
					<div class="d-text">Panchayat Resolution</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/spot-billing.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('eesl')); ?>" class="catg">
					<div class="d-text">EESL</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/revenue-collection.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('inventory')); ?>?url=dashboard" class="catg">
					<div class="d-text">Inventory</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/journal-details.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('reports')); ?>?url=dashboard" class="catg">
					<div class="d-text">Reports</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/reports.gif')); ?>" alt="" class="img-fluid">	
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('/index')); ?>" class="catg">
					<div class="d-text">Finance</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/reports.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('/index')); ?>" class="catg">
					<div class="d-text">Complaint</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/spot-collection.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<!-- <div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">SE/DEs Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/consumer-management.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">Energy Audit</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/eaudit.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">Theft Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/theft.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">CSC Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/csc.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">CAT Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/cat.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">SAP PM Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/sap-pm.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">RIMS</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/slcc.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">SAP MM Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/mm.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">HTCSC Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/csc.gif')); ?>" alt="" class="img-fluid">
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<div class="d-text">SAP PS Reports</div>
				<img src="<?php echo e(asset('backend/assets/images/dashboard/reports.gif')); ?>" alt="" class="img-fluid">
			</div> -->
			
		<!-- 	<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('reports')); ?>?url=dashboard" class="catg">
					<div class="d-text">Reports</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/reports.gif')); ?>" alt="" class="img-fluid">	
				</a>
			</div> -->
          
		</div>
		

	</div>
	<?php endif; ?>

	<?php if(session()->get('role')==7 ): ?>

	<div class="col-xs-12 pt-4 pb-5 ">
	
		<div class="row">
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<!--<a href="<?php echo e(url('panchayat_resolution')); ?>" class="catg">-->
				<a href="<?php echo e(url('mandalstock_list')); ?>" class="catg">
					<div class="d-text">STOCK REGISTER</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/spot-billing.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('subvendor_inwardslights')); ?>" class="catg">
					<div class="d-text">INWARDS LIGHTS</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/revenue-collection.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('subvendor_inwardsarmsclamps')); ?>" class="catg">
					<div class="d-text">INWARDS ARMSCLAMPS</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/journal-details.gif')); ?>" alt="" class="img-fluid">
				</a>
			</div>
			<div class="col-xs-6 col-sm-6 col-md-3 col-lg-2 py-3">
				<a href="<?php echo e(url('subvendor_inwardsccms')); ?>" class="catg">
					<div class="d-text">INWARDS CCMS</div>
					<img src="<?php echo e(asset('backend/assets/images/dashboard/reports.gif')); ?>" alt="" class="img-fluid">	
				</a>
			</div>
		</div>
	</div>
	<?php endif; ?>

		<?php if(session()->get('role')==0 ): ?>

<div class="panel-body pt-5">
			<!-- <table class="table table-bordered table-striped mb-none mt-0 ml-0"  style="width:65%;">
       <thead>
         <tr>
          <th>S.NO</th>
           <th>Make Names</th>
           <th>Total</th>
         </tr>
       </thead>
       <tbody>
       	  <?php $i=1; $sum=0; $wattages=["Bajaj","Crompton","Florida","flux lite","HQ Lamps","Orient","Other","shubah","Surya"];?>

                 <?php $__currentLoopData = $wattages; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $value): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> 
                                <?php $counts= DB::select("SELECT maker_name,    
                                         ROUND (   
                                    (
                                        LENGTH(maker_name)
                                        - LENGTH( REPLACE ( maker_name, '".$value."', '') )
                                    ) / LENGTH('".$value."')        
                                ) AS count FROM survey_infos ");
                    $count=array_sum(array_column($counts,'count'));
                     ?>  
                    
                        <tr>
                            <td><?php echo e($i); ?></td>
                            <td><?php echo e($value); ?></td>
                            <td><?php echo e($count); ?></td>
                        </tr>
                        <?php $i++; $sum=$sum+$count;?>
                          <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                        <tr>              
                            <td></td>
                            <td><b>Total</b></td>
                            <td><b><?php echo e($sum); ?></b></td> 
                        </tr>
        
       
      
     </tbody>
   </table> -->
   		<div class="col-12">
<div class="table-responsive">
           <table class="table table-bordered table-striped mb-none mt-0 ml-0" >
            <thead>
                <!-- Row 1 -->
                <tr class="table-primary">
                    <td class="text-left heading head_class" colspan="29">TSREDCO&nbsp;-&nbsp;MATERIAL&nbsp; STOCK&nbsp;REGISTER</td>
                </tr>

                <!-- Row 2 -->
                <tr class="table-success ">
                   
                    <th></th>
                     <th></th>
                    <th class="heading"  colspan="17">Lights&nbsp;</th>
                    <th class="heading" colspan="10">Arms&nbsp;Clamps&nbsp;Set</th>
                    <th class="heading" colspan="6">CCMS&nbsp;(1-PH&nbsp;&&nbsp3-PH)</th>
                </tr>

                <!-- Row 3 -->
                <tr class="table-warning">

                    <td colspan=""></td>
                     <td colspan=""></td>
                    <td class="heading" colspan="6" align="center">Received&nbsp;Quantity</td>
                    <td class="heading" colspan="6">Installed</td>
                     <td class="heading" colspan="6">Balance</td>

                     <td class="heading" colspan="4" align="center">Received&nbsp;Quantity</td>
                    <td class="heading" colspan="4">Installed</td>
                     <td class="heading" colspan="4">Balance</td>

                     <td class="heading" colspan="" align="center">Received&nbsp;Quantity</td>
                    <td class="heading" colspan="">Installed</td>
                     <td class="heading" colspan="">Balance</td>

                </tr>
                <tr class="table-danger">
                   
                    <th rowspan="" class="sub-heading">S.no</th>
                    <th rowspan="" class="sub-heading">Districts</th>
                    <th rowspan="" class="sub-heading">18w</th>
                    <th rowspan="" class="sub-heading">35w</th>
                    <th rowspan="" class="sub-heading">70w</th>
                    <th rowspan="" class="sub-heading">110w</th>
                    <th rowspan="" class="sub-heading">190w</th>
                    <th rowspan="" class="sub-heading">Total</th>

                    <th rowspan="" class="sub-heading">18w</th>
                    <th rowspan="" class="sub-heading">35w</th>
                    <th rowspan="" class="sub-heading">70w</th>
                    <th rowspan="" class="sub-heading">110w</th>
                    <th rowspan="" class="sub-heading">190w</th>
                    <th rowspan="" class="sub-heading">Total</th>

                    <th rowspan="" class="sub-heading">18w</th>
                    <th rowspan="" class="sub-heading">35w</th>
                    <th rowspan="" class="sub-heading">70w</th>
                    <th rowspan="" class="sub-heading">110w</th>
                    <th rowspan="" class="sub-heading">190w</th>
                    <th rowspan="" class="sub-heading">Total</th>
                    
                     <th rowspan="" class="sub-heading">25mm</th>
                    <th rowspan="" class="sub-heading">32mm</th>
                    <th rowspan="" class="sub-heading">40mm</th>
                    <th rowspan="" class="sub-heading">Total</th>

                    <th rowspan="" class="sub-heading">25mm</th>
                    <th rowspan="" class="sub-heading">32mm</th>
                    <th rowspan="" class="sub-heading">40mm</th>
                    <th rowspan="" class="sub-heading">Total</th>

                    <th rowspan="" class="sub-heading">25mm</th>
                    <th rowspan="" class="sub-heading">32mm</th>
                    <th rowspan="" class="sub-heading">40mm</th>
                    <th rowspan="" class="sub-heading">Total</th>
                    
                    <th rowspan="" class="sub-heading">Received&nbsp;Quantity</th>
                    <th rowspan="" class="sub-heading">Installed</th>
                    <th rowspan="" class="sub-heading">Balance</th>
                    
                </tr>
            </thead> 
             <tbody>

                 <?php $ts1=0;$ts2=0;$ts3=0;$ts4=0;$ts5=0; 
                      $tw1=0;$tw2=0;$tw3=0;$tw4=0;$tw5=0;
                      $tb1=0;$tb2=0;$tb3=0;$tb4=0;$tb5=0;
                      $tas1=0;$tas2=0;$tas3=0;$tas4=0;$tas5=0;
                      $ta1=0;$ta2=0;$ta3=0;
                      $tba1=0;$tba2=0;$tba3=0;
                      $tsc1=0;$tsc2=0;$tsc3=0;


                      $sum=0; $sum1=0;$sum2=0;$sum3=0;$sum4=0;$sum5=0; $i=0;?>
        <?php $__currentLoopData = $districtwise_report; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $report): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
        <?php  
                $list=[]; $i++;  $arms=["18 W","35 W","70 W","110 W","190 W"];
               
        ?>
                        <?php $__currentLoopData = $arms; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $value): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> 
                        <?php $counts= DB::select("SELECT LED_wattage,    
                            ROUND (
                                (
                                    LENGTH(LED_wattage)
                                    - LENGTH( REPLACE ( LED_wattage, '".$value."', '') ) 
                                ) / LENGTH('".$value."')
                            ) AS count    
                            FROM survey_infos where approve_status=1 and jilla_id=".$report->id);
                        
                         $count=array_sum(array_column($counts,'count'));
                         $list[]=$count;
                        ?>
                        <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>

                        <?php $arm_list=[];  $sumofarm=0; $arms=["25mm","32mm","40mm"]?>
                         <?php $__currentLoopData = $arms; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $value): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> 
                        <?php $arm_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 approve_status=1 and jilla_id=".$report->id);
                        
                            $arm_count=array_sum(array_column($arm_counts,'count'));
                            $arm_list[]=$arm_count;

                            $cable_used2 = DB::select("SELECT cable_user  
                                AS sum    
                                FROM survey_infos where jilla_id=".$report->id);
                            $cable_used2_count=array_sum(array_column($cable_used2,'sum'));
                            
                        ?>  
                        <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
                        <?php 

                        $query="";
         if($request->session()->get('role')==6){
            $query=" AND vendor_id=".$request->session()->get('id');
         }
         
                        $ccmstypes = DB::select("SELECT install_qty AS instal,supply_qty AS supply FROM ccms_types where district_id=".$report->id);

                            $cable_used2_count=array_sum(array_column($ccmstypes,'instal'));
                            $ccms_info = DB::select("SELECT ccms_ph_receive_quantity  
                                AS ccmsph
                                FROM inwardccmstypes where jilla_id=".$report->id."".$query);
                            $supplied_ccms_count=array_sum(array_column($ccms_info,'ccmsph'));
                            $blc_ccms_count=$supplied_ccms_count-$cable_used2_count;

 
    
                          $inward_info = DB::select("SELECT rcv_qty_18w  
                                AS r18w,rcv_qty_35w  
                                AS r35w,rcv_qty_70w AS r70w,rcv_qty_110w AS r110w,rcv_qty_190w AS r190w
                                FROM inwards  where jilla_id=".$report->id."".$query);

                          $supplied_18w_count=array_sum(array_column($inward_info,'r18w'));
                          $supplied_35w_count=array_sum(array_column($inward_info,'r35w'));
                          $supplied_70w_count=array_sum(array_column($inward_info,'r70w'));
                          $supplied_110w_count=array_sum(array_column($inward_info,'r110w'));
                          $supplied_190w_count=array_sum(array_column($inward_info,'r190w'));
                          $balance_18w_count=$supplied_18w_count-$list[0];
                          $balance_35w_count=$supplied_35w_count-$list[1];
                          $balance_70w_count=$supplied_70w_count-$list[2];
                          $balance_110w_count=$supplied_110w_count-$list[3];
                          $balance_190w_count=$supplied_190w_count-$list[4];


                           $armsclamps_info = DB::select("SELECT received_arms_dia_inner_32  
                                AS arms_32,received_arms_dia_inner_40  
                                AS arms_40,received_arms_dia_25 AS arms_25
                                FROM armsclamps where jilla_id=".$report->id."".$query);

                        $supplied_25_count=array_sum(array_column($armsclamps_info,'arms_25'));
                        $supplied_32_count=array_sum(array_column($armsclamps_info,'arms_32'));
                        $supplied_40_count=array_sum(array_column($armsclamps_info,'arms_40'));
                    
                          $balance_25_count=$supplied_25_count-$arm_list[0];
                          $balance_32_count=$supplied_32_count-$arm_list[1];
                          $balance_40_count=$supplied_40_count-$arm_list[2];

                            


                            ?>
                        <tr>
                           
                            <td><?php echo e($i); ?></td>
                            <td><?php echo e($report->area_name); ?></td>
                            <td><?php $s1=isset($supplied_18w_count)?$supplied_18w_count:0?><?php echo e($s1); ?></td>
                            <td ><?php $s2=isset($supplied_35w_count)?$supplied_35w_count:0?><?php echo e($s2); ?></td>
                            <td><?php $s3=isset($supplied_70w_count)?$supplied_70w_count:0?><?php echo e($s3); ?></td>
                            <td><?php $s4=isset($supplied_110w_count)?$supplied_110w_count:0?><?php echo e($s4); ?></td>
                            <td><?php $s5=isset($supplied_190w_count)?$supplied_190w_count:0?><?php echo e($s5); ?></td>
                            <td class="font-weight-bold"><?php $counts=$s1+$s2+$s3+$s4+$s5;?><?php echo e($counts); ?></td>
                            <td><?php $w1=isset($list[0])?$list[0]:0?><?php echo e($w1); ?></td>
                            <td><?php $w2=isset($list[1])?$list[1]:0?><?php echo e($w2); ?></td>
                            <td><?php $w3=isset($list[2])?$list[2]:0?><?php echo e($w3); ?></td>
                            <td><?php $w4=isset($list[3])?$list[3]:0?><?php echo e($w4); ?></td>
                            <td><?php $w5=isset($list[4])?$list[4]:0?><?php echo e($w5); ?></td>
                            <td class="font-weight-bold"><?php $installed_counts=$w1+$w2+$w3+$w4+$w5;?><?php echo e($installed_counts); ?></td>
                            <td><?php $b1=isset($balance_18w_count)?$balance_18w_count:0?><?php echo e($b1); ?></td>
                            <td><?php $b2=isset($balance_35w_count)?$balance_35w_count:0?><?php echo e($b2); ?></td>
                            <td><?php $b3=isset($balance_70w_count)?$balance_70w_count:0?><?php echo e($b3); ?></td>
                            <td><?php $b4=isset($balance_110w_count)?$balance_110w_count:0?><?php echo e($b4); ?></td>
                            <td><?php $b5=isset($balance_190w_count)?$balance_190w_count:0?><?php echo e($b5); ?></td>
                            <td class="font-weight-bold"><?php $balance_counts=$b1+$b2+$b3+$b4+$b5;?><?php echo e($balance_counts); ?></td>
                            <td><?php $as1=isset($supplied_25_count)?$supplied_25_count:0?><?php echo e($as1); ?></td>
                            <td><?php $as2=isset($supplied_32_count)?$supplied_32_count:0?><?php echo e($as2); ?></td>
                            <td ><?php $as3=isset($supplied_40_count)?$supplied_40_count:0?><?php echo e($as3); ?></td>
                            <td class="font-weight-bold"><?php $received_counts=$as1+$as2+$as3;?><?php echo e($received_counts); ?></td>
                            <td><?php $a1=isset($arm_list[0])?$arm_list[0]:0?><?php echo e($a1); ?></td>
                            <td><?php $a2=isset($arm_list[1])?$arm_list[1]:0?><?php echo e($a2); ?></td>
                            <td><?php $a3=isset($arm_list[2])?$arm_list[2]:0?><?php echo e($a3); ?></td>
                            <td class="font-weight-bold"><?php $insta_counts=$a1+$a2+$a3;?><?php echo e($insta_counts); ?></td>
                            <td><?php $ab1=isset($balance_25_count)?$balance_25_count:0?><?php echo e($ab1); ?></td>
                            <td><?php $ab2=isset($balance_32_count)?$balance_32_count:0?><?php echo e($ab2); ?></td>
                            <td><?php $ab3=isset($balance_40_count)?$balance_40_count:0?><?php echo e($ab3); ?></td>
                            <td class="font-weight-bold"><?php $bal_counts=$ab1+$ab2+$ab3;?><?php echo e($bal_counts); ?></td>
                            <td><?php $cs1=isset($supplied_ccms_count)?$supplied_ccms_count:0?><?php echo e($cs1); ?></td>
                            <td><?php $cs2=isset($cable_used2_count)?$cable_used2_count:0?><?php echo e($cs2); ?></td>
                            <td><?php $cs3=isset($blc_ccms_count)?$blc_ccms_count:0?><?php echo e($cs3); ?></td>
                      </tr>
                      <?php
                                $ts1=$s1+$ts1;
                                $ts2=$s2+$ts2;
                                $ts3=$s3+$ts3;
                                $ts4=$s4+$ts4;
                                $ts5=$s5+$ts5;
                                $sum = $ts1+$ts2+$ts3+$ts4+$ts5;
                                  
                                $tw1=$w1+$tw1;
                                $tw2=$w2+$tw2;
                                $tw3=$w3+$tw3;
                                $tw4=$w4+$tw4;
                                $tw5=$w5+$tw5;
                                $sum1 = $tw1+$tw2+$tw3+$tw4+$tw5;

                                $tb1=$b1+$tb1;
                                $tb2=$b2+$tb2;
                                $tb3=$b3+$tb3;
                                $tb4=$b4+$tb4;
                                $tb5=$b5+$tb5;
                                $sum2 = $tb1+$tb2+$tb3+$tb4+$tb5;

                                $tas1=$as1+$tas1;
                                $tas2=$as2+$tas2;
                                $tas3=$as3+$tas3;
                                $sum3 = $tas1+$tas2+$tas3;

                                $ta1=$a1+$ta1;
                                $ta2=$a2+$ta2;
                                $ta3=$a3+$ta3;
                                $sum4 = $ta1+$ta2+$ta3;

                                $tba1=$ab1+$tba1;
                                $tba2=$ab2+$tba2;
                                $tba3=$ab3+$tba3;
                                $sum5 = $tba1+$tba2+$tba3;

                                 $tsc1=$cs1+$tsc1;
                                $tsc2=$cs2+$tsc2;
                                $tsc3=$cs3+$tsc3;


                       
                    
                       ?>

                       <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>

                       <tr>

                        <td></td>
                        <td><b>Total</b></td>
                        <td><b><?php echo e($ts1); ?></b></td>
                        <td><b><?php echo e($ts2); ?></b></td>
                        <td><b><?php echo e($ts3); ?></b></td>
                        <td><b><?php echo e($ts4); ?></b></td>
                        <td><b><?php echo e($ts5); ?></b></td>
                        <td><b><?php echo e($sum); ?></b></td>
                        <td><b><?php echo e($tw1); ?></b></td>
                        <td><b><?php echo e($tw2); ?></b></td>
                        <td><b><?php echo e($tw3); ?></b></td>
                        <td><b><?php echo e($tw4); ?></b></td>
                        <td><b><?php echo e($tw5); ?></b></td>
                        <td><b><?php echo e($sum1); ?></b></td>
                        <td><b><?php echo e($tb1); ?></b></td>
                         <td><b><?php echo e($tb2); ?></b></td>
                        <td><b><?php echo e($tb3); ?></b></td>
                        <td><b><?php echo e($tb4); ?></b></td>
                         <td><b><?php echo e($tb5); ?></b></td>
                        <td><b><?php echo e($sum2); ?></b></td>
                        <td><b><?php echo e($tas1); ?></b></td>
                        <td><b><?php echo e($tas2); ?></b></td>
                        <td><b><?php echo e($tas3); ?></b></td>
                        <td><b><?php echo e($sum3); ?></b></td>
                        <td><b><?php echo e($ta1); ?></b></td>
                        <td><b><?php echo e($ta2); ?></b></td>
                        <td><b><?php echo e($ta3); ?></b></td>
                        <td><b><?php echo e($sum4); ?></b></td>
                        <td><b><?php echo e($tba1); ?></b></td>
                        <td><b><?php echo e($tba2); ?></b></td>
                        <td><b><?php echo e($tba3); ?></b></td>
                        <td><b><?php echo e($sum5); ?></b></td>
                        <td><b><?php echo e($tsc1); ?></b></td>
                        <td><b><?php echo e($tsc2); ?></b></td>
                        <td><b><?php echo e($tsc3); ?></b></td>

                       </tr>
    
              </tbody>
 
        </table>
    </div>
</div>
</div>
<?php endif; ?>

	<!-- <div class="col-xs-12">
		<footer class="container-fluid pl-lg-0 pr-lg-0 " style="background: #4DC97E !important;">
            <div class="container pl-lg-0 pr-lg-0 py-2">
                <div class="row pt-lg-3 pb-lg-3 pt-3 pb-3" style="background: #4DC97E !important;">
                    <div class="col-lg-6 text-lg-left pl-lg-0" style="padding-top: 4px;">
                        <p class="text-white mb-0 small">© 2021 TSREDCO. All Rights Reserved</p>
                    </div>
                    <div class="col-lg-6 text-lg-right pr-lg-0">
                        <a href="http://www.paccore.com/" class="text-white text-decoration-none small" target="_blank">www.paccore.com</a>
                    </div>
                </div>
            </div>
        </footer>
	</div> -->
</section>
<script type="text/javascript">
    setInterval("my_function();",30000); 
    function my_function(){
      $('.refresh').load(location.href + ' .refresh');
    }
  </script>

<?php $__env->stopSection(); ?>




<?php echo $__env->make('backend.header', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /home/neefc25/public_html/tgredco.fovea.in/resources/views/backend/index.blade.php ENDPATH**/ ?>