@extends('layouts.nav')
@section('title')
{{$Type}} Statement
@endsection
@section('content')               


<div class="d-sm-flex align-items-center justify-content-between mb-4">
                        <h1 class="h3 mb-0 text-gray-800">Accounting Report</h1>
                      </div>

                  
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary"   id="formHeader">{{$Type}} Statement</h6>
                        </div>
                        @if (session('success'))
                            <div class="alert alert-success" id="successMessage"  style="margin: 20px;">
                                {{ session('success') }}
                            </div>
                        @endif
                      
                        @if ($errors->any())

                                    <div class="form-group"  id="successMessage"  style="margin: 20px;">
                                        <div class="card bg-warning text-white shadow">
                                            <div class="card-body">
                                        
                                                @foreach ($errors->all() as $error)
                                                <div style="color: red; ">{{ $error }}</div>
                                                @endforeach
                                        
                                            </div>
                                        </div>
                                    </div>
                                    @endif
                            <form class="card-body" action="{{route('fetchTransactions')}}" method="post"  id="accountTypeForm">
                            @csrf
                            <input type="hidden" id="accountId" name="id" value="">
                            <input type="hidden" class="form-control form-control-user" id="Type" placeholder="" name="Type"  value="{{$Type}}" required >
                                    
                                <div class="form-group row">
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                    <select class="form-control form-control-user" id="account" name="account"  value="{{ old('account') }}">
                                        <option value="" disabled selected>{{$Type}} Account</option>
                                        <option value="all">All Accounts</option>

                                        @foreach ($Accounts as $Account)
                                        
                                        <option value="{{ $Account->AccCode.':'.$Account->AccSubCode }}">{{ $Account->AccSubCode.'/'.$Account->AccName }}</option>
                                          
                                        @endforeach
                                    </select>
                                    </div>
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                        <input type="date" class="form-control form-control-user" id="from" placeholder="from" name="from" value="{{ old('date', \Carbon\Carbon::now()->format('Y-m-d')) }}" required>
                                    </div>
                                    <div class="col-sm-4">
                                        <input type="date" class="form-control form-control-user" id="to" placeholder="to" name="to"  value="{{ old('date', \Carbon\Carbon::now()->format('Y-m-d')) }}" required>
                                    </div>
                                    
                                </div>
                                <div class="form-group row">
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                        <select class="form-control form-control-user" id="floor_from" name="floor_from" value="{{ old('floor_from') }}">
                                            <option value="" disabled selected>From Floor</option>
                                            <!-- Add dynamic floor numbers -->
                                            @foreach ($floors as $floor)
                                                <option value="{{ $floor->FloorNumber }}">{{ $floor->FloorNumber }}</option>
                                            @endforeach
                                        </select>
                                    </div>

                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                        <select class="form-control form-control-user" id="floor_to" name="floor_to" value="{{ old('floor_to') }}">
                                            <option value="" disabled selected>To Floor</option>
                                            <!-- Add dynamic floor numbers -->
                                            @foreach ($floors as $floor)
                                                <option value="{{ $floor->FloorNumber }}">{{ $floor->FloorNumber }}</option>
                                            @endforeach
                                        </select>
                                    </div>

                                    <div class="col-sm-4">
                                        <select class="form-control form-control-user" id="account_type" name="statement_type" value="{{ old('statement_type') }}">
                                            <option value="" disabled selected>Select Statement Type</option>
                                            <option value="1000">Rent Receivable</option>
                                            <option value="4200">Operational Costs</option>
                                            <option value="both">Both</option>
                                        </select>
                                    </div>  
                                </div>
                                

                                <div class="form-group row">
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                    <select class="form-control form-control-user" id="curr" name="curr"  value="{{ old('curr') }}"  required>
                                        <option value="" disabled selected>Select Currency</option>

                                        @foreach ($currencys as $currency)
                                        
                                        <option value="{{ $currency->ID}}">{{ $currency->Name }}</option>
                                          
                                        @endforeach
                                    </select>
                                    </div>
                                 
                                 
                                    
                                </div>

                               <div style="display: flex;">
                               <input type="submit" style="width: 100px;height: 40px; margin-right: 10px; margin-top: 6px" value="View" class="btn btn-primary btn-user btn-block" id="submitButton"/>

                                <input style="width: 100px;"    type="reset" value="Refresh" class="btn btn-secondary btn-user btn-block"  onclick="hideMessages()"/>
                                    
                               </div>
                                
                                <hr>
                             </form>
                   
                             @php
                            use Carbon\Carbon;
                            $todayLongDate = Carbon::now()->format(' F j, Y'); 
                            @endphp                     
                          
@if(!empty($trans))
                        <div class="card-body">
                            <div class="table-responsive">
                            <button id="download-pdf" style="float: right; margin: 5px;" class="btn btn-primary">Download PDF</button>
 
                             <div>
                                    <div class="py-4">
                                      <div class="px-14 py-6">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <tbody>
                                            <tr>
                                              <td class="w-full align-top">
                                              <div style="display: flex;">
                                                    <img style="width: 100px; height: 100px;" src="{!! asset('img/logo.png') !!}" class="h-12" />
                                                    <p class="whitespace-nowrap font-bold text-main text-10xl ml-4" style="margin-top: 30px; font: 30px;">{{$name}} Statement</p>
                                                </div>
                                              </td>

                                              <td class="align-top">
                                                <div class="text-sm">
                                                  <table class="border-collapse border-spacing-0">
                                                    <tbody>
                                                      <tr>
                                                        <td class="border-r pr-4">
                                                          <div>
                                                            <p class="whitespace-nowrap text-slate-400 text-right">Date</p>
                                                          
                                                            <p class="whitespace-nowrap font-bold text-main text-right">{{$todayLongDate}}</p>
                                                          </div>
                                                        </td>
                                                        <td class="pl-4">
                                                          <div>
                                                            <p class="whitespace-nowrap text-slate-400 text-right">Account</p>
                                                            <p class="whitespace-nowrap font-bold text-main text-right">{{$code}}</p>
                                                          </div>
                                                        </td>
                                                      </tr>
                                                    </tbody>
                                                  </table>
                                                </div>
                                              </td>
                                            </tr>
                                          </tbody>
                                        </table>
                                      </div>
                                      <div class="bg-slate-100 px-14 py-6 text-sm">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <tbody>
                                          <tr>
                                              <td class="w-1/2 align-top">
                                                <div class="text-sm text-neutral-600">
                                                @foreach ($pdetails as $pdetail)
                                              
                                                  <p class="font-bold">{{ $pdetail->Name}}</p>
                                                  <p>{{ $pdetail->Address}}</p>
                                                  <p>{{ $pdetail->Email}}</p>
                                                  <p>{{ $pdetail->Phone}}</p>
                                                  
                                                  @endforeach
                                              
                                                </div>
                                              </td>
                                              <td class="w-1/2 align-top text-right">
                                                <div class="text-sm text-neutral-600">
                                                @foreach ($cst as $cs)
                                                
                                                  <p class="font-bold">{{ $cs->Name}}</p>
                                                  <p>{{ $cs->Address}}</p>
                                                  <p>{{ $cs->Email}}</p>
                                                  <p>{{ $cs->Contact}}</p>
                                                
                                                
                                                
                                                  @endforeach
                                                </div>
                                              </td>
                                            </tr>
                                            <tr>
                                              <td class="w-1/2 align-top">
                                                <div class="text-sm text-neutral-600">
                                                
                                                <p class="font-bold">Currency: {{$currnames}}</p>
                                                  <p>From: {{$from}} To: {{$to}}</p>


                                              
                                                </div>
                                              </td>
                                              <td class="w-1/2 align-top text-right">
                                                <div class="text-sm text-neutral-600">
                                              


                                                

                                                </div>
                                              </td>
                                            </tr>
                                          </tbody>
                                        </table>
                                      </div>

                                      <div class="px-14 py-10 text-sm text-neutral-700">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <thead>
                                            <tr>
                                          
                                              <td class="border-b-2 border-main pb-3 pl-2 font-bold text-main">EntryDate</td> 
                                              <td class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Description</td> 
                                              <td class="border-b-2 border-main pb-3 pl-2 text-right font-bold text-main">Refference</td>
                                            
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">DR</td>
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">CR</td>
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">Balance</td>
                                            </tr>
                                          </thead>
                                          <tbody>
                                    @php
                                        $b = $openingBalance; // Initialize $b
                                        $dr=0;
                                        $cr=0;
                                    @endphp


                                    <tr>

                                    <td class="border-b py-3 pl-2">{{$from}}</td>
                                    <td class="border-b py-3 pl-2">Opening Balance</td>
                                    <td class="border-b py-3 pl-2 text-right"></td>
                                    @php
                                    if($b=="Supplier")
                                    {

                                    if($b<0)
                                    {
                                      $dr=$b;
                                      $cr=0;
                                    
                                    }
                                    else
                                    {
                                      $dr=0;
                                      $cr=$b;
                                    
                                    }

                                    
                                    }
                                    else
                                    {
                                    
                                      if($b<0)
                                    {
                                      
                                      $dr=0;
                                      $cr=$b*(-1);
                                    }
                                    else
                                    {
                                      $dr=$b;
                                      $cr=0;
                                    

                                    }
                                    }

                                    @endphp
                                    <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($dr, 2) }}</td>
                                    <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($cr, 2) }}</td>

                                    <td class="border-b py-3 pl-2 pr-3 text-right">
                                        @if($b < 0)
                                            ({{ number_format(abs($b), 2) }})
                                        @else
                                            {{ number_format($b, 2) }}
                                        @endif
                                    </td>

                                    </tr>

                            @foreach ($trans as $tran)
                              <tr>
                                
                            
                                
                                <td class="border-b py-3 pl-2">{{$tran->EntryDate}}</td>
                                <td class="border-b py-3 pl-2">{{$tran->MNarration}}</td>
                                @php
                                if($Type=="Supplier")
                                {
                                
                                  $b = $b+ ($tran->DR-$tran->CR);
                                  }
                                  else
                                  {
                                    $b = $b+ ($tran->CR-$tran->DR);
                                  }
                                  @endphp
                                    
                                <td class="border-b py-3 pl-2 text-right">{{$tran->Batch}}</td>
                                @php
                                if($Type=="Supplier")
                                {
                                $dr=$tran->DR;
                                $cr=$tran->CR;
                                }
                                else
                                {
                                
                                  $dr=$tran->CR;
                                  $cr=$tran->DR;
                                }

                                @endphp
                                <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($dr, 2) }}</td>
                                <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($cr, 2) }}</td>
                                <td class="border-b py-3 pl-2 pr-3 text-right">
                                    @if($b < 0)
                                        ({{ number_format(abs($b), 2) }})
                                    @else
                                        {{ number_format($b, 2) }}
                                    @endif
                                </td>

                              </tr>
                              @endforeach


                              <tr>
                                <td colspan="9">
                                  <table class="w-full border-collapse border-spacing-0">
                                    <tbody>
                                      <tr>
                                        <td class="w-full"></td>
                                        <td>
                                          <table class="w-full border-collapse border-spacing-0">
                                            <tbody>
                                          
                                              
                                              <tr>
                                                <td class="bg-main p-3">
                                                  <div class="whitespace-nowrap font-bold text-white">Balance:</div>
                                                </td>
                                                <td class="bg-main p-3 text-right">
                                                  <div class="whitespace-nowrap font-bold text-white"> @if($b < 0)
                                                    ({{ number_format(abs($b), 2) }})
                                                @else
                                                    {{ number_format($b, 2) }}
                                                @endif</div>
                                                </td>
                                              </tr>
                                            </tbody>
                                          </table>
                                        </td>
                                      </tr>
                                    </tbody>
                                  </table>
                                </td>
                              </tr>
                            </tbody>
                          </table>
                    
                        </div>

                      
                      
                        
                      </div>
                    </div>
                    
                    
                    
                  </div>
                </div>
@endif                     
@if(!empty($allTransactions))
<div class="col-12">
<button id="download-pdf" style="float: right; margin: 5px;" class="btn btn-primary">Download PDF</button>

</div>

@foreach($allTransactions as $obj)
                        <div class="card-body">
                            <div class="table-responsive">
 
                             <div>
                                    <div class="py-4">
                                      <div class="px-14 py-6">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <tbody>
                                            <tr>
                                              <td class="w-full align-top">
                                              <div style="display: flex;">
                                                    <img style="width: 100px; height: 100px;" src="{!! asset('img/logo.png') !!}" class="h-12" />
                                                    <p class="whitespace-nowrap font-bold text-main text-10xl ml-4" style="margin-top: 30px; font: 30px;">{{$obj["name"]}} Statement</p>
                                                </div>
                                              </td>

                                              <td class="align-top">
                                                <div class="text-sm">
                                                  <table class="border-collapse border-spacing-0">
                                                    <tbody>
                                                      <tr>
                                                        <td class="border-r pr-4">
                                                          <div>
                                                            <p class="whitespace-nowrap text-slate-400 text-right">Date</p>
                                                          
                                                            <p class="whitespace-nowrap font-bold text-main text-right">{{$todayLongDate}}</p>
                                                          </div>
                                                        </td>
                                                        <td class="pl-4">
                                                          <div>
                                                            <p class="whitespace-nowrap text-slate-400 text-right">Account</p>
                                                            <p class="whitespace-nowrap font-bold text-main text-right">{{$obj["name"]}}</p>
                                                          </div>
                                                        </td>
                                                      </tr>
                                                    </tbody>
                                                  </table>
                                                </div>
                                              </td>
                                            </tr>
                                          </tbody>
                                        </table>
                                      </div>
                                      <div class="bg-slate-100 px-14 py-6 text-sm">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <tbody>
                                          <tr>
                                              <td class="w-1/2 align-top">
                                                <div class="text-sm text-neutral-600">
                                                @foreach ($pdetails as $pdetail)
                                              
                                                  <p class="font-bold">{{ $pdetail->Name}}</p>
                                                  <p>{{ $pdetail->Address}}</p>
                                                  <p>{{ $pdetail->Email}}</p>
                                                  <p>{{ $pdetail->Phone}}</p>
                                                  
                                                  @endforeach
                                              
                                                </div>
                                              </td>
                                              <td class="w-1/2 align-top text-right">
                                                <div class="text-sm text-neutral-600">
                                                @foreach ($cst as $cs)
                                                
                                                  <p class="font-bold">{{ $cs->Name}}</p>
                                                  <p>{{ $cs->Address}}</p>
                                                  <p>{{ $cs->Email}}</p>
                                                  <p>{{ $cs->Contact}}</p>
                                                
                                                
                                                
                                                  @endforeach
                                                </div>
                                              </td>
                                            </tr>
                                            <tr>
                                              <td class="w-1/2 align-top">
                                                <div class="text-sm text-neutral-600">
                                                
                                                <p class="font-bold">Currency: {{$currnames}}</p>
                                                  <p>From: {{$from}} To: {{$to}}</p>


                                              
                                                </div>
                                              </td>
                                              <td class="w-1/2 align-top text-right">
                                                <div class="text-sm text-neutral-600">
                                              


                                                

                                                </div>
                                              </td>
                                            </tr>
                                          </tbody>
                                        </table>
                                      </div>

                                      <div class="px-14 py-10 text-sm text-neutral-700">
                                        <table class="w-full border-collapse border-spacing-0">
                                          <thead>
                                            <tr>
                                          
                                              <td class="border-b-2 border-main pb-3 pl-2 font-bold text-main">EntryDate</td> 
                                              <td class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Description</td> 
                                              <td class="border-b-2 border-main pb-3 pl-2 text-right font-bold text-main">Refference</td>
                                            
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">DR</td>
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">CR</td>
                                              <td class="border-b-2 border-main pb-3 pl-2 pr-3 text-right font-bold text-main">Balance</td>
                                            </tr>
                                          </thead>
                                          <tbody>
                                    @php
                                        $b = $openingBalance; // Initialize $b
                                        $dr=0;
                                        $cr=0;
                                    @endphp


                                    <tr>

                                    <td class="border-b py-3 pl-2">{{$from}}</td>
                                    <td class="border-b py-3 pl-2">Opening Balance</td>
                                    <td class="border-b py-3 pl-2 text-right"></td>
                                    @php
                                    if($b=="Supplier")
                                    {

                                    if($b<0)
                                    {
                                      $dr=$b;
                                      $cr=0;
                                    
                                    }
                                    else
                                    {
                                      $dr=0;
                                      $cr=$b;
                                    
                                    }

                                    
                                    }
                                    else
                                    {
                                    
                                      if($b<0)
                                    {
                                      
                                      $dr=0;
                                      $cr=$b*(-1);
                                    }
                                    else
                                    {
                                      $dr=$b;
                                      $cr=0;
                                    

                                    }
                                    }

                                    @endphp
                                    <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($dr, 2) }}</td>
                                    <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($cr, 2) }}</td>

                                    <td class="border-b py-3 pl-2 pr-3 text-right">
                                        @if($b < 0)
                                            ({{ number_format(abs($b), 2) }})
                                        @else
                                            {{ number_format($b, 2) }}
                                        @endif
                                    </td>

                                    </tr>

                            @foreach ($obj["transactions"] as $tran)
                              <tr>
                                
                            
                                
                                <td class="border-b py-3 pl-2">{{$tran->EntryDate}}</td>
                                <td class="border-b py-3 pl-2">{{$tran->MNarration}}</td>
                                @php
                                if($Type=="Supplier")
                                {
                                
                                  $b = $b+ ($tran->DR-$tran->CR);
                                  }
                                  else
                                  {
                                    $b = $b+ ($tran->CR-$tran->DR);
                                  }
                                  @endphp
                                    
                                <td class="border-b py-3 pl-2 text-right">{{$tran->Batch}}</td>
                                @php
                                if($Type=="Supplier")
                                {
                                $dr=$tran->DR;
                                $cr=$tran->CR;
                                }
                                else
                                {
                                
                                  $dr=$tran->CR;
                                  $cr=$tran->DR;
                                }

                                @endphp
                                <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($dr, 2) }}</td>
                                <td class="border-b py-3 pl-2 pr-3 text-right">{{ number_format($cr, 2) }}</td>
                                <td class="border-b py-3 pl-2 pr-3 text-right">
                                    @if($b < 0)
                                        ({{ number_format(abs($b), 2) }})
                                    @else
                                        {{ number_format($b, 2) }}
                                    @endif
                                </td>

                              </tr>
                              @endforeach


                              <tr>
                                <td colspan="9">
                                  <table class="w-full border-collapse border-spacing-0">
                                    <tbody>
                                      <tr>
                                        <td class="w-full"></td>
                                        <td>
                                          <table class="w-full border-collapse border-spacing-0">
                                            <tbody>
                                          
                                              
                                              <tr>
                                                <td class="bg-main p-3">
                                                  <div class="whitespace-nowrap font-bold text-white">Balance:</div>
                                                </td>
                                                <td class="bg-main p-3 text-right">
                                                  <div class="whitespace-nowrap font-bold text-white"> @if($b < 0)
                                                    ({{ number_format(abs($b), 2) }})
                                                @else
                                                    {{ number_format($b, 2) }}
                                                @endif</div>
                                                </td>
                                              </tr>
                                            </tbody>
                                          </table>
                                        </td>
                                      </tr>
                                    </tbody>
                                  </table>
                                </td>
                              </tr>
                            </tbody>
                          </table>
                    
                        </div>

                      
                      
                        
                      </div>
                    </div>
                    
                    
                    
                  </div>
                </div>
                @endforeach
@endif                     
                    
                    
                    </div>

                    <script>
    document.getElementById('download-pdf').addEventListener('click', function () {
      var element = document.querySelector('.py-4'); // Select the section to print

   

      var opt = {
          margin:       -0.3,
          filename:     '{{$Type}}Statement.pdf',
          image:        { type: 'jpeg', quality: 0.98 },
          html2canvas:  { scale: 2 },
          jsPDF:        { unit: 'in', format: 'A4', orientation: 'portrait' }
      };

      // Generate the PDF with the footer included
      html2pdf().from(element).set(opt).save();
    });

</script>


                    @endsection