@extends('layouts.app')

@section('content')
<div class="container">
    <h2>Account Ledger Report</h2>

    <form method="POST" action="{{ route('account.report.filter') }}">
        @csrf
        <div class="row mb-3">
            <div class="col">
                <label>From Date:</label>
                <input type="date" name="fromDate" class="form-control" value="{{ request('fromDate') }}" required>
            </div>
            <div class="col">
                <label>To Date:</label>
                <input type="date" name="toDate" class="form-control" value="{{ request('toDate') }}" required>
            </div>
            <div class="col">
                <label>Account:</label>
                <select name="account_id" class="form-control" required>
                    <option value="">Select Account</option>
                    @foreach($accounts as $acc)
                        <option value="{{ $acc->Account_ID }}" {{ request('account_id') == $acc->Account_ID ? 'selected' : '' }}>
                            {{ strtoupper($acc->Account_Title) }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col">
                <label>&nbsp;</label>
                <button type="submit" class="btn btn-primary form-control">Generate</button>
            </div>
        </div>
    </form>

    @isset($data)
    <div class="mb-3 text-end">
        <a href="{{ route('account.index') }}" class="btn btn-secondary">Back</a>
        <button onclick="window.print()" class="btn btn-dark">Print</button>

        <a href="{{ route('account.report.export.pdf', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id')
        ]) }}" class="btn btn-danger">Export PDF</a>

        <a href="{{ route('account.report.export.excel', [
            'fromDate'   => request('fromDate'),
            'toDate'     => request('toDate'),
            'account_id' => request('account_id')
        ]) }}" class="btn btn-success">Export To Excel</a>

        <a href="#" class="btn btn-info">Crystal Report</a>
    </div>

   <div class="printableArea">
    @if(count($data) > 0)
        <div class="text-center mb-4">
            <h5 class="mb-1">{{ $data[0]->Account_Title }}</h5>
            <strong>{{ $data[0]->DatePeriod }}</strong>
        </div>
    @endif

    <div class="table-responsive">


    <div class="table-responsive printableArea">
        <table class="table table-bordered table-striped table-sm">
            <thead class="thead-dark">
                <tr>
                    <th>Voucher</th>
                    <th>Date</th>
                    <th>Remarks</th>
                    <th>Site</th>
                    <th>Other Account</th>
                    <th class="align-right">Debit</th>
                    <th class="align-right">Credit</th>
                    <th class="align-right">Cl. Balance</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $balance = 0;
                    $totalDebit = 0;
                    $totalCredit = 0;
                @endphp
                @foreach($data as $row)
                    @php
                        $amount = floatval($row->Amount);
                        $balance += $amount;
                        if ($amount > 0) $totalDebit += $amount;
                        if ($amount < 0) $totalCredit += abs($amount);
                    @endphp
                    <tr>
                        <td>{{ $row->Voucher ?? '' }}</td>
<td>{{ \Carbon\Carbon::parse($row->Voucher_Date)->format('d-m-Y') }}</td>
                        <td>{{ $row->Remarks }}</td>
                        <td>{{ $row->Cheque_No }}</td>
                        <td>{{ $row->Other_Account ?? 'N/A' }}</td>
                        <td class="align-right">{{ $amount > 0 ? number_format($amount, 0) : '' }}</td>
                        <td class="align-right">{{ $amount < 0 ? number_format(abs($amount), 0) : '' }}</td>
                        <td class="align-right">{{ $balance < 0 ? '(' . number_format(abs($balance), 0) . ')' : number_format($balance, 0) }}</td>
                    </tr>
                @endforeach
                <tr class="fw-bold">
                    <td colspan="5" class="align-right">Totals</td>
                    <td class="align-right">{{ number_format($totalDebit, 0) }}</td>
                    <td class="align-right">{{ number_format($totalCredit, 0) }}</td>
                    <td class="align-right">
                        {{ $balance < 0 ? '(' . number_format(abs($balance), 0) . ')' : number_format($balance, 0) }}
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
    @endisset
</div>

<style>
    /* Font size 9pt for the report */
    .table, .table th, .table td {
        font-size: 9pt !important;
    }

    .align-right {
        text-align: right !important;
    }

    @media print {
        body * {
            visibility: hidden;
        }
        .printableArea, .printableArea * {
            visibility: visible;
        }
        .printableArea {
            position: absolute;
            left: 0;
            top: 0;
            width: 100%;
        }
    }
</style>
@endsection