@extends('layouts/layoutMaster')

@section('title', 'Rincian Arus Kas Bulanan')

@section('vendor-style')
@vite([
  'resources/assets/vendor/libs/datatables-bs5/datatables.bootstrap5.scss',
  'resources/assets/vendor/libs/select2/select2.scss'
])
@endsection

@section('vendor-script')
@vite([
  'resources/assets/vendor/libs/moment/moment.js',
  'resources/assets/vendor/libs/datatables-bs5/datatables.bootstrap5.js',
  'resources/assets/vendor/libs/select2/select2.js'
])
@endsection

@section('page-script')
<script>
    $(document).ready(function() {
        $('#transactionsTable').DataTable({
            pageLength: 25,
            order: [[0, 'desc']],
            language: {
                search: "Cari:",
                lengthMenu: "Tampilkan _MENU_ data",
                info: "Menampilkan _START_ sampai _END_ dari _TOTAL_ data",
                infoEmpty: "Menampilkan 0 sampai 0 dari 0 data",
                infoFiltered: "(disaring dari _MAX_ total data)",
                paginate: {
                    first: "Pertama",
                    last: "Terakhir",
                    next: "Selanjutnya",
                    previous: "Sebelumnya"
                }
            }
        });
    });
</script>
@endsection

@section('content')
<div class="container-xxl flex-grow-1 container-p-y">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <div class="d-flex justify-content-between align-items-center flex-wrap gap-3">
                        <div>
                            <h5 class="mb-0">
                                @if($category == 'operating')
                                    <span class="text-primary">AKTIVITAS OPERASI</span>
                                @elseif($category == 'investing')
                                    <span class="text-success">AKTIVITAS INVESTASI</span>
                                @elseif($category == 'financing')
                                    <span class="text-warning">AKTIVITAS PENDANAAN</span>
                                @endif
                                - {{ $monthName }}
                            </h5>
                            <small class="text-muted">{{ $transactions->count() }} transaksi</small>
                        </div>
                        <div>
                            <a href="{{ route('cashflow.report', ['branch_id' => $branchId, 'start_date' => $startDate, 'end_date' => $endDate]) }}" class="btn btn-sm btn-outline-secondary">
                                <i class="ri-arrow-left-line me-1"></i> Kembali ke Laporan
                            </a>
                            <button onclick="exportToExcel()" class="btn btn-sm btn-primary">
                                <i class="ri-file-excel-2-line me-1"></i> Ekspor Excel
                            </button>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <!-- Summary Card -->
                    <div class="row mb-4">
                        <div class="col-md-12">
                            <div class="card bg-light">
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <p class="mb-1">Total Transaksi</p>
                                            <h4>{{ $transactions->count() }}</h4>
                                        </div>
                                        <div class="col-md-4">
                                            <p class="mb-1">Total Grup</p>
                                            <h4>{{ $groupedTransactions->count() }}</h4>
                                        </div>
                                        <div class="col-md-4">
                                            <p class="mb-1">Jumlah {{ $transactions->sum('amount') >= 0 ? 'Masuk' : 'Keluar' }}</p>
                                            <h4 class="{{ $transactions->sum('amount') >= 0 ? 'text-success' : 'text-danger' }}">
                                                {{ rupiah_format(abs($transactions->sum('amount')), 0, ',', '.') }}
                                            </h4>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Grouped Transactions -->
                    <div class="mb-4">
                        <h6>Transaksi Berdasarkan Kelompok</h6>
                        <div class="table-responsive">
                            <table class="table table-bordered">
                                <thead class="table-light">
                                    <tr>
                                        <th style="width: 50%">Deskripsi</th>
                                        <th class="text-end">Jumlah</th>
                                        <th class="text-center">Transaksi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($groupedTransactions as $group)
                                        <tr>
                                            <td>{{ $group['description'] }}</td>
                                            <td class="text-end {{ $group['amount'] < 0 ? 'text-danger' : 'text-success' }}">
                                                {{ rupiah_format(abs($group['amount']), 0, ',', '.') }}
                                                <small class="text-muted ms-1">{{ $group['amount'] < 0 ? '(-)' : '(+)' }}</small>
                                            </td>
                                            <td class="text-center">{{ $group['count'] }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="3" class="text-center">Tidak ada data</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                <tfoot class="table-light">
                                    <tr>
                                        <th>Total</th>
                                        <th class="text-end {{ $transactions->sum('amount') < 0 ? 'text-danger' : 'text-success' }}">
                                            {{ rupiah_format(abs($transactions->sum('amount')), 0, ',', '.') }}
                                            <small class="text-muted ms-1">{{ $transactions->sum('amount') < 0 ? '(-)' : '(+)' }}</small>
                                        </th>
                                        <th class="text-center">{{ $transactions->count() }}</th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>

                    <!-- Detailed Transactions with DataTables -->
                    <div>
                        <h6>Rincian Transaksi</h6>
                        <div class="table-responsive">
                            <table id="transactionsTable" class="table table-striped">
                                <thead>
                                    <tr>
                                        <th>Tanggal</th>
                                        <th>Kode</th>
                                        <th>Deskripsi</th>
                                        <th>Akun</th>
                                        <th class="text-end">Jumlah</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($transactions as $transaction)
                                        <tr>
                                            <td>{{ \Carbon\Carbon::parse($transaction['date'])->format('d M Y') }}</td>
                                            <td>{{ $transaction['code'] }}</td>
                                            <td>{{ $transaction['description'] }}</td>
                                            <td>{{ $transaction['account'] ?? '-' }}</td>
                                            <td class="text-end {{ $transaction['amount'] < 0 ? 'text-danger' : 'text-success' }}">
                                                {{ rupiah_format(abs($transaction['amount']), 0, ',', '.') }}
                                                <small class="text-muted ms-1">{{ $transaction['amount'] < 0 ? '(-)' : '(+)' }}</small>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
// Export to Excel function
window.exportToExcel = function() {
    const params = new URLSearchParams({
        branch_id: '{{ $branchId }}',
        category: '{{ $category }}',
        month: '{{ $month }}',
        export: 'excel'
    });

    window.location.href = `/export-cash-flow-month?${params.toString()}`;
}
</script>
@endsection