@php use App\Http\Controllers\StatementsController; @endphp
@extends('layouts.nav')
@section('title')
Tax Report
@endsection
@section('content')



<div class="d-sm-flex align-items-center justify-content-between mb-4">
                        <h1 class="h3 mb-0 text-gray-800">Tax 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">Tax Report</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('fetchTax')}}" method="post"  id="accountTypeForm">
                            @csrf


                                <div class="form-group row">
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                    <h6 class="m-0 font-weight-bold text-secondary"   >Tax Description</h6>
                                    <select class="form-control form-control-user" id="tax" name="tax"  value="{{ old('tax') }}"  required>
                                        <option value="" disabled selected>Select Tax</option>
                                        <option value="All">All Tax</option>
                                        @foreach ($taxs as $tax)

                                        <option value="{{$tax->ID}}">{{ $tax->Rate.'% '.$tax->Name }}</option>

                                        @endforeach
                                    </select>
                                    </div>
                                    <div class="col-sm-4 mb-3 mb-sm-0">
                                    <h6 class="m-0 font-weight-bold text-secondary"  >From Period</h6>
                                        <input type="date" class="form-control form-control-user" id="pfrom" placeholder="pfrom" name="pfrom" value="{{ old('date', \Carbon\Carbon::now()->format('Y-m-d')) }}" required>
                                    </div>
                                    <div class="col-sm-4">
                                    <h6 class="m-0 font-weight-bold text-secondary"  >To Period</h6>
                                        <input type="date" class="form-control form-control-user" id="pto" placeholder="pto" name="pto"  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">
                                    <h6 class="m-0 font-weight-bold text-secondary"  >Select Currency</h6>
                                    <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 class="col-sm-4 mb-3 mb-sm-0">
                                    <h6 class="m-0 font-weight-bold text-secondary"  >From</h6>
                                    <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">
                                    <h6 class="m-0 font-weight-bold text-secondary" >To</h6>
                                    <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 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>

                                 <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>
                                        @php
                                        use Carbon\Carbon;
                                        $todayLongDate = Carbon::now()->format(' F j, Y');
                                        @endphp
                                        <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">

                            <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">

                @php
                use Illuminate\Support\Str;

                        $outputTrans = collect($trans)->filter(function ($tran) {
                            return strtolower($tran->Source) === 'customer' || strtolower($tran->Source) === 'tenant';

                        });

                        $inputTrans = collect($trans)->filter(function ($tran) {
                            return strtolower($tran->Source) === 'supplier';
                        });

                        function calculateTotals($transactions) {
                            $totals = [
                                'invoice' => 0,
                                'tax' => 0,
                                'incl' => 0,
                                'rate' => 0,
                            ];

                            foreach ($transactions as $tran) {
                                $invoiceAmount = $tran->Price * $tran->Qnty;
                                $taxAmount = $invoiceAmount * ($tran->Tax / 100);
                                $amountIncl = $invoiceAmount - $taxAmount;

                                $totals['invoice'] += $invoiceAmount;
                                $totals['tax'] += $taxAmount;
                                $totals['incl'] += $amountIncl;
                                $totals['rate'] += $tran->Tax;
                            }

                            return $totals;
                        }

                        $outputTotals = calculateTotals($outputTrans);
                        $inputTotals = calculateTotals($inputTrans);
                        @endphp

                        <!-- ✅ Output Tax Table -->
                        <h5 class="border-b-2 border-main pb-3 pl-2 bg-gray-100">Output Tax [Tenants]</h5>
                        <table class="w-full border-collapse border-spacing-0">
                        <thead>
                            <tr>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Date</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Name</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Inv No</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Inv Amount(USD)</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Tax%</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Tax Amount(USD)</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Total(incl)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($outputTrans as $tran)
                            @php
                                $invoiceAmount = $tran->Price * $tran->Qnty;
                                $taxAmount = $invoiceAmount * ($tran->Tax / 100);
                                $amountIncl = $invoiceAmount - $taxAmount;
                            @endphp
                            <tr>
                                <td class="border-b py-2 pl-2">{{ $tran->EntryDate }}</td>
                                <td class="border-b py-2 pl-2">{{ \App\Http\Controllers\StatementsController::getAccountName($tran->Source, $tran->AccSubCode) }}</td>
                                <td class="border-b py-2 pl-2">{{ $tran->Batch }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($invoiceAmount, 2) }}</td>
                                <td class="border-b py-2 pl-2">{{ $tran->Tax }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($taxAmount, 2) }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($amountIncl, 2) }}</td>
                            </tr>
                            @endforeach
                            <!-- ✅ Spacing Row -->
                            <tr>
                                <td colspan="7" style="padding-top: 5px;"></td>
                            </tr>
                            <!-- ✅ Total Input Tax Summary Aligned -->
                            <tr>
                            <td colspan="3" class="border-b p-2 pl-2 font-bold bg-gray-400">Total Output Tax</td> <!-- Spans Date, Name, Inv No -->
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($outputTotals['invoice'], 2) }} <!-- Inv Amount -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                              <!-- Tax % -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($outputTotals['tax'], 2) }} <!-- Tax Amount -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($outputTotals['incl'], 2) }} <!-- Total(incl) -->
                            </td>
                            </tr>
                        </tbody>
                        </table>

                        <!-- Spacer -->
                        <div style="height: 50px;"></div>

                        <!-- ✅ Input Tax Table -->
                        <h5 class="border-b-2 border-main pb-3 pl-2 bg-gray-100">Input Tax [Suppliers]</h5>
                       <table class="w-full border-collapse border-spacing-0">
                        <thead>
                            <tr>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Date</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Name</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Inv No</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Inv Amount(USD)</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Tax%</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Tax Amount(USD)</th>
                            <th class="border-b-2 border-main pb-3 pl-2 font-bold text-main">Total(incl)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($inputTrans as $tran)
                            @php
                                $invoiceAmount = $tran->Price * $tran->Qnty;
                                $taxAmount = $invoiceAmount * ($tran->Tax / 100);
                                $amountIncl = $invoiceAmount - $taxAmount;
                            @endphp
                            <tr>
                                <td class="border-b py-2 pl-2">{{ $tran->EntryDate }}</td>
                                <td class="border-b py-2 pl-2">{{ \App\Http\Controllers\StatementsController::getAccountName($tran->Source, $tran->AccSubCode) }}</td>
                                <td class="border-b py-2 pl-2">{{ $tran->Batch }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($invoiceAmount, 2) }}</td>
                                <td class="border-b py-2 pl-2">{{ $tran->Tax }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($taxAmount, 2) }}</td>
                                <td class="border-b py-2 pl-2">{{ number_format($amountIncl, 2) }}</td>
                            </tr>
                            @endforeach
                            <!-- ✅ Spacing Row -->
                            <tr>
                                <td colspan="7" style="padding-top: 5px;"></td>
                            </tr>
                            <!-- ✅ Total Input Tax Summary Aligned -->

                            <tr>
                            <td colspan="3" class="border-b p-2 pl-2 font-bold bg-gray-400">Total Input Tax</td> <!-- Spans Date, Name, Inv No -->
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($inputTotals['invoice'], 2) }} <!-- Inv Amount -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                <!-- Tax % -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($inputTotals['tax'], 2) }} <!-- Tax Amount -->
                            </td>
                            <td class="border-b p-2 pl-2 font-bold bg-gray-400">
                                {{ number_format($inputTotals['incl'], 2) }} <!-- Total(incl) -->
                            </td>
                            </tr>
                            <tr>
                                <td colspan="7" style="padding-top: 40px;"></td>
                            </tr>

                            <tr>
                                <td colspan="3" class="border-b p-2 pl-2 font-bold bg-main text-white">Net Tax</td>
                                <td class="border-b p-2 pl-2 font-bold bg-main text-white">USD{{ number_format($outputTotals['invoice'] - $inputTotals['invoice'], 2) }}</td>
                                <td class="border-b p-2 pl-2 font-bold bg-main text-white"></td>
                                <td class="border-b p-2 pl-2 font-bold bg-main text-white">USD{{ number_format($outputTotals['tax'] - $inputTotals['tax'], 2) }}</td>
                                <td class="border-b p-2 pl-2 font-bold bg-main text-white">USD{{ number_format($outputTotals['incl'] - $inputTotals['incl'], 2) }}</td>
                            </tr>
                        </tbody>`
                        </table>
                            </div>
                            </div>
                            </div>
                            </div>
                        </div>

                    </div>

                    <script>
                        document.getElementById('download-pdf').addEventListener('click', function () {
                            var element = document.querySelector('.py-4'); // Select the specific section you want to print
                            var opt = {
                                margin:       -0.3,
                                filename:     'TaxReport.pdf',
                                image:        { type: 'jpeg', quality: 0.98 },
                                html2canvas:  { scale: 2 },
                                jsPDF:        { unit: 'in', format: 'A4', orientation: 'portrait' }
                            };
                            html2pdf().from(element).set(opt).save();
                        });
                    </script>

                    @endsection