@extends('layouts.app')

@section('title')

Monthly Recovery Sheet      From {{$from_date}}  To  {{$to_date}}



@stop
@section('css')
<style type="text/css" media="print">
  @page {
    size: landscape;
   }


</style>

<style>

    .us_table_bdr>td, .us_table_bdr>th, .us_table_bdr>td, .us_table_bdr>th {
        border: 1px solid black !important;
    }
</style>

<!-- <link href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css" rel="stylesheet"> -->
<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css"  rel="stylesheet">
@stop


@section('breadcrumb')
<ol class="breadcrumb pull-right no-print">
        <li><a href="{{route('home')}}"><i class="fa fa-dashboard"></i> Home</a></li>

        <li class="active">Account Statement</li>
      </ol>
@stop
@section('content')

<div class="container-fluid">
                <div class="row ">
                  <div class="col-lg-12  ">
                    <div class="white-box">
                        <div class="text-center">
                            <h3><strong>@foreach($project_names as $key => $project_name)
                                {{ $project_name }}
                                @if($key < count($project_names) - 1)
                                    , 
                                @endif
                            @endforeach</strong></h3>
                            <h4><strong>Monthly Recovery Sheet</strong></h4>
                        </div>
                        <div class="pull-left">
                        <span>Recovery Sheet(Due, Received & OS As On)</span><br>
                            <span><b>FROM&nbsp;&nbsp;{{$from_date}}&nbsp;&nbsp;To&nbsp;&nbsp;{{$to_date}}</b></span>
                        </div>

                        <div class="pull-right" style="    margin-bottom: 2rem;padding-right: 3rem;" >
                            <span>Date: <b>{{date('d-m-y')}}</b></span><br>
                        <!--<span>Report No: &nbsp;202030</span><br>-->
                            <span>User ID: &nbsp; {{Auth::user()->name}}</span>
                        </div>

                <br>
                 <br>
                  <br>
                    <div class="table-responsive" style="clear: both;position: relative;bottom: 0rem;">
                                <div style="overflow-y: scroll;height: 565px;">

                      
                                    
                         
                                    
                                <table id="example1"  class="table bdr table-responsive table-bordered" style="border: 1px solid black;">
                                    <thead>
                                        
                                     
                                        <tr >
                            
                            
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Sr No.</th>
                           
                           <th style="border-top: 1px solid;border-bottom: 1px solid;">Month</th>

                            <th style="border-top: 1px solid;border-bottom: 1px solid;">No of Units</th>
                            
                
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Booked(Gross)</th>

                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Discount</th>
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Booked Net</th>
                            
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Recovery</th>
                            
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Balance Receivables</th>
                         
                            
                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Cancelled Unit</th>

                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Cancel Unit Refunded</th>


                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Transfer Unit</th>

                            <th style="border-top: 1px solid;border-bottom: 1px solid;">Transfer Unit Refunded</th>
                             
                            </tr>
                                                  
                        </thead>
                    <tbody>
                    
                            
                         
                        
                            
                        @foreach ($period as $key=> $parentDT)