@if(userCan('ChartOfAccounts-show')==0) @php header("Location: " . URL::to('errors.403'), true, 302); exit(); @endphp @endphp @endif
@extends('layouts.default')
@php $pageTitle = 'Account Balance Sheet'; @endphp
@section('title',$pageTitle)
@section('PageHead')


@php
 $Date1= app('request')->input('date1');
 $Date2= app('request')->input('date2');
@endphp


<!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-5">
            <h3 class="card-title">{{$pageTitle}}</h3>
          </div><!-- /.col -->
          <div class="col-sm-7">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="/">Dashboard</a></li>
              <li class="breadcrumb-item"><a href="/Reports">Reports</a></li>
              <li class="breadcrumb-item"><a href="/settings/ChartOfAccounts">Chart of Account</a></li>
              <li class="breadcrumb-item "><a href="?"> {{$pageTitle}} </a></li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

 @stop

@section('content')

    


   
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- /.col -->
          <div class="col-md-12">
            <!-- /.card -->

            <div class="card">
              <!-- <div class="card-header">
                <h3 class="card-title">Employee List</h3>
              </div>  -->
              <!-- /.card-header -->

              <div class="card-body table-sm p-0">
                <div align="center">
                  <h2>{{ config('app.appFullName', 'Business Name') }}</h2>                  
                  Balance Sheet<br/>
                  @if(intval(@$info['date1'])>0)  As of
                    {{date('F d, Y',strtotime($info['date1']))}}  
                  @endif
                  <span class="print-on-date">Print On: {{date('d/m/Y h:iA')}}</span> 
                 
                </div>
                 <br>
@php 
  $openingBalance = @$info['openingTotal']; $crTotal = $drTotal = $accBalance = 0; $accBalance += $openingBalance;  
  $totalRoot = $totalType = $totalDetails = 0; 
@endphp
                <table class="table table-sm no-border">
                  <tbody>
                    <tr style="border-top: 2px solid #999; border-bottom: 2px solid #999;">
                      <td colspan="2" align="right">Total</td>
                    </tr>
                    
                    @foreach($accRoots as $root)
                    @php  $totalRoot += $totalType = $totalDetails = $balance =  0; @endphp 
                    @if((RootAccountTypeBalance($root->rootID)) !=0)
                    <tr>
                      <td> 
                        {{$root->rootName}}

                      </td>
                      <td align="right" title="{{RootAccountTypeBalance($root->rootID)}} ">  </td>
                    </tr>
                        @foreach($root->AccountTypes as $type)
                        @if((TypeAccountBalance(@$type->account_type_ID)) !=0)
                        <tr>
                          <td> 
                            <div style="width:30px;float:left;"> &nbsp; </div> 
                            <!-- {{@$type->account_type_ID}}   -->
                            {{@$type->account_type_name}}  </td>
                          <td align="right" title="{{TypeAccountBalance(@$type->account_type_ID)}}">   </td>
                        </tr>
                          @foreach($type->AccountDetailsTypes as $details)
                            @if((DetailsAccountBalance(@$details->detail_type_id)) !=0)

                          <tr>
                            <td> 
                              <div style="width:30px;float:left;"> &nbsp; </div>  
                              <div style="width:30px;float:left;"> &nbsp; </div> 
                              {{@$details->detail_type_name}}  </td>
                            <td align="right" title="{{DetailsAccountBalance(@$details->detail_type_id)}}"> </td>
                          </tr>
                            @foreach($details->AccountName as $account)
                              @if((@$account->DrTotalByAccID->total - @$account->CrTotalByAccID->total) !=0)

                              @php if($account->sense==1) 
                                 $balance = (@$account->DrTotalByAccID->total - @$account->CrTotalByAccID->total);
                              elseif($account->sense==2) 
                                $balance = (@$account->CrTotalByAccID->total - @$account->DrTotalByAccID->total);
                                $totalRoot +=$balance;
                                $totalType +=$balance;
                                $totalDetails +=$balance;
                              @endphp

                              @php  //$totalRoot = $totalType = $totalDetails = 0; @endphp 
                            <tr>
                              <td> 
                                <div style="width:30px;float:left;"> &nbsp; </div>  
                                <div style="width:30px;float:left;"> &nbsp; </div> 
                                <div style="width:30px;float:left;"> &nbsp; </div> 
                              <!-- {{@$account->account_number}}   -->
                              {{@$account->account_name}}  </td>
                              <td align="right" title="{{$account->sense==1}} DR: {{@$account->DrTotalByAccID->total}}, CR: {{@$account->CrTotalByAccID->total}}" > 
                                {{number_format($balance,2)}}
                              </td>
                            </tr>
                            @endif
                            <!-- end account -->
                            @endforeach

                          <tr style="border-top:2px solid;">
                            <td> 
                              <div style="width:30px;float:left;"> &nbsp; </div>  
                              <div style="width:30px;float:left;"> &nbsp; </div> 
                              <b> Total {{@$details->detail_type_name}}   </b></td>
                            <td align="right">  <b>{{number_format($totalDetails,2)}} </b></td>
                          </tr>
                          @php  $totalDetails = $balance =  0; @endphp 
                            @endif 
                            <!-- end details -->
                          @endforeach

                          <tr style="border-top:2px solid;">
                            <td> 
                              <div style="width:30px;float:left;"> &nbsp; </div>  
                              <b> Total {{@$type->account_type_name}}  </b></td>
                            <td align="right">  <b>{{number_format($totalType,2)}} </b></td>
                          </tr>
                          @php  $totalType = $totalDetails = $balance =  0; @endphp 
                          @endif
                          <!-- end type -->
                        @endforeach

                        <tr style="border-top:2px solid;">
                            <td> 
                              <b> Total {{$root->rootName}}  </b></td>
                            <td align="right">  <b>{{number_format($totalRoot,2)}} </b></td>
                          </tr>
                        @php  $totalRoot =  0; @endphp 
                      @endif
                      <!-- end root -->
                    @endforeach
      
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
       
        
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
 
@stop