@section('title','Profits and Loss')
@extends('layout.app')
@section('content')


<div id="profit_report">
 <div class="row">
   <div class="col-12">
      <div class="card hide-filter-on-print">
         <div class="card-header bg-transparent header-elements-inline">
            <span class="text-uppercase font-size-sm font-weight-semibold">Filter</span>
            <div class="header-elements">
               <div class="list-icons"><a data-action="collapse" class="list-icons-item"></a></div>
            </div>
         </div>
         <div class="card-body">
            <form action="{{route('report.profit_nd_loss')}}" method="GET" id="get_form">
               <div class="form-group d-flex align-items-center">
                <input type="hidden" name="start_date" id="start_date" class="form-control" value="">
                <input type="hidden" name="end_date" id="end_date" class="form-control" value="">
                  <input type="text" name="date_filter" id="reportrange" class="form-control">
                  <button type="submit" class="btn btn-sm btn-primary ml-2">Filter</button>
               </div>
            </form>
         </div>
      </div>
   </div>
</div>

   <div class="row mt-2" >
      <div class="col-12">
         <div class="card">
            <div class="card-header bg-transparent header-elements-inline">
               <span class="text-uppercase font-size-sm font-weight-semibold">Profit-Loss</span> 
               <div class="header-elements">
                  <div class="list-icons"><a onclick="printSection()" class="btn btn-sm btn-success"><i class="icon-printer2 mr-2"></i>Print</a></div>
               </div>
            </div>
            <div id="print_section" class="card-body">
               <div class="row">
                  <div class="col-6">
                     <h3 class="text-center">Income</h3>
                     <table class="table table-bordered">
                        <tbody>
                            <thead>
                                <tr>
                                    <th>Income Category</th>
                                    <th>Total Price</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if ($incomes->isEmpty())
                                    <tr>
                                        <td rowspan="2"> No Income Available.</td>
                                    </tr>
                                 @else
                                    @foreach ($incomes as $income)
                                        <tr>
                                            <td>{{ $income->account_heading }}</td>
                                            <td>{{ number_format($income->total_price, 2) }}</td>
                                        </tr>
                                    @endforeach
                                    <tr>
                                        <td><strong>Total Income</strong></td>
                                        <td><strong>{{ number_format($totalIncome, 2) }}</strong></td>
                                    </tr>
                                @endif
                            </tbody>
                        </tbody>
                     </table>
                  </div>
                  <div class="col-6">
                     <h3 class="text-center">Expenses</h3>
                     <table class="table table-bordered">
                        <thead>
                                <tr>
                                    <th>Expense Category</th>
                                    <th>Total Price</th>
                                </tr>
                            </thead>
                        <tbody>
                            @if ($expenses->isEmpty())
                                <tr>
                                   <td rowspan="2">No Expence Available.</td> 
                                </tr>
                            @else
                            @foreach ($expenses as $expense)
                                    <tr>
                                        <td>{{ $expense->account_heading }}</td>
                                        <td>{{ number_format($expense->total_price, 2) }}</td>
                                    </tr>
                                @endforeach
                                <tr>
                                    <td><strong>Total Income</strong></td>
                                    <td><strong>{{ number_format($totalExpense, 2) }}</strong></td>
                                </tr>
                           @endif
                        </tbody>
                     </table>
                  </div>
                  <div class="col-6 offset-3">
                     <table class="table table-custom-tw table-sm table-bordered table-bordered-report">
                        <tbody>
                           <tr>
                              <th>Final Balance</th>
                              <td>
                                 {{ number_format($totalIncome -$totalExpense, 2)  }}
                              </td>
                           </tr>
                        </tbody>
                     </table>
                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>
</div>
<script>
    function printSection() {
    var printContents = document.getElementById("print_section").innerHTML;
    var originalContents = document.body.innerHTML;

    document.body.innerHTML = printContents;
    window.print();
    document.body.innerHTML = originalContents;
}
</script>
@endsection