@extends('layouts.app')
@section('content')
   <!-- Begin Page Content -->
    <div class="container-fluid">
        <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
			<div class="ps-3">
				<nav aria-label="breadcrumb">
					<ol class="breadcrumb mb-0 p-0">
						<li class="breadcrumb-item"><a href="{{ route('home') }}"><i class="fas fa-home"></i></a></li>
                        <li class="breadcrumb-item" aria-current="page">My Accounts</li>
						<li class="breadcrumb-item active" aria-current="page">Savings</li>
					</ol>
				</nav>
			</div>
			<div class="ms-auto"></div>
		</div>
		<!--end breadcrumb-->

        <div class="card" id="profile-card">
            <div class="card-body pt-3">
              <!-- Bordered Tabs -->
              <ul class="nav nav-tabs nav-tabs-bordered">
                <li class="nav-item">
                  <button class="nav-link active" data-bs-toggle="tab" data-bs-target="#fosa-details">Account Details</button>
                </li>
                <li class="nav-item">
                  <button class="nav-link" data-bs-toggle="tab" data-bs-target="#fosa-statement">Account Statement</button>
                </li>
              </ul>
              <div class="tab-content pt-2">
                <div class="tab-pane fade show active fosa-details" id="fosa-details">
                  <h5 class="card-title">Fosa Details</h5>
                  <div class="row">
                    <div class="col-lg-3 col-md-4 label">Member Number</div>
                    <div class="col-lg-9 col-md-8">{{Auth::user()->member_number}}</div>
                  </div>
                  <div class="row">
                    <div class="col-lg-3 col-md-4 label">Member Name</div>
                    <div class="col-lg-9 col-md-8">{{Auth::user()->fname}} {{Auth::user()->lname}}</div>
                  </div>
                  <div class="row">
                    <div class="col-lg-3 col-md-4 label">Member Status</div>
                    <div class="col-lg-9 col-md-8">{{Auth::user()->member ? Auth::user()->member->status : 'N/A' }}</div>
                  </div>
                  <div class="row">
                    <div class="col-lg-3 col-md-4 label">Account Balance</div>
                    <div class="col-lg-9 col-md-8">Ksh. {{number_format($totalBalance)}}</div>
                  </div>
                </div>

                <div class="tab-pane fade Fosa-statement" id="fosa-statement">
                  <br>
                  <div class="container">
                    <form id="search" role="form" style="border:0">
                      @csrf
                      <div class="row mb-3">
                        <div class="col-sm-7">
                          <label for="accountSelect" class="form-label">Select Account:</label>
                          <select id="accountSelect" name="accountId" class="form-select">
                            <option value="">All</option>
                            @foreach($accountTypes as $accountType)
                                <option value="{{ $accountType->id }}">{{ $accountType->name }}</option>
                            @endforeach
                          </select>
                        </div>
                      </div>
                    </form>
                   
                    <!-- Row -->
                    <!-- Generate FOSA Statement Form -->
                    <div class="row">
                      <div class="col-md-12 table-responsive">
                        <table border="0" cellspacing="5" cellpadding="5">
                          <tbody>
                            <tr>
                              <td><strong> From date:</strong></td>
                              <td><input type="text" id="min" name="min" class="form-control" value="01/01/2022"></td>
                          
                              <td><strong> To date: </strong></td>
                              <td><input type="text" id="max" name="max" class="form-control" value="31/01/2023"></td>
                          </tr>
                      </tbody></table>
                      <br>
                        <table class="table" id="fosastatement">
                          <thead>
                            <tr>
                              <th>Account Type</th>
                              <th>Date Posted</th>
                              <th>Debit Amount</th>
                              <th>Credit Amount</th>                              
                              <th>Balance</th>
                            </tr>
                          </thead>
                          <tbody id="transactionTableBody">
                            <!-- Transactions will be dynamically loaded here -->
                            
                            @php
                            $balance = 0; // Initialize the balance variable
                            $totalDebit = 0; // Initialize the total debit variable
                            $totalCredit = 0; // Initialize the total credit variable
                            
                            $minDate = ''; // Define and initialize the $minDate variable
                            $maxDate = ''; // Define and initialize the $maxDate variable
                            
                            // Check if the start_date and end_date are provided in the URL parameters
                            if (isset($_GET['start_date']) && isset($_GET['end_date'])) {
                                $minDate = $_GET['start_date']; // Assign the value from the start_date input field
                                $maxDate = $_GET['end_date']; // Assign the value from the end_date input field
                            } else {
                                // If no date range is provided, set the $minDate and $maxDate to cover all records
                                $minDate = '0000-00-00'; 
                                $maxDate = '9999-12-31'; 
                            }
                            @endphp
                            
                            <!-- Iterate over transactions and calculate balance -->
                            @foreach($transactions as $transaction)
                              @php
                                // Calculate the balance based on transaction type
                                if ($transaction->transaction_type === 'Debit') {
                                  $balance -= $transaction->transaction_amount; // Subtract debit amount
                                  $totalDebit += $transaction->transaction_amount; // Add debit amount to total
                                } elseif ($transaction->transaction_type === 'Credit') {
                                  $balance += $transaction->transaction_amount; // Add credit amount
                                  $totalCredit += $transaction->transaction_amount; // Add credit amount to total
                                }
                              @endphp
                            
                              <!-- Check if transaction is within the date range -->
                              @php
                                $transactionDate = strtotime($transaction->transaction_date);
                                $minDateFilter = strtotime($minDate);
                                $maxDateFilter = strtotime($maxDate);
                                $isWithinDateRange = ($minDateFilter <= $transactionDate) && ($transactionDate <= $maxDateFilter);
                              @endphp
                            
                              <!-- Display transaction row if within date range -->
                              @if ($isWithinDateRange)
                                <tr>
                                  <td>{{ $transaction->account->accountType->name }}</td>
                                  <td>{{ $transaction->transaction_date }}</td>
                                  <td>{{ $transaction->transaction_type === 'Debit' ? number_format($transaction->transaction_amount) : '' }}</td>
                                  <td>{{ $transaction->transaction_type === 'Credit' ? number_format($transaction->transaction_amount) : '' }}</td>
                                  <td>{{ number_format($balance) }}</td>
                                </tr>
                              @endif
                              
                            @endforeach
                            
                            <!-- Total row -->
                            <tr>
                              <td><strong>Totals</strong></td>
                              <td></td>
                              <td><strong>{{ number_format($totalDebit) }}</strong></td>
                              <td><strong>{{ number_format($totalCredit) }}</strong></td>
                              <td><strong>{{ number_format($balance) }}</strong></td>
                            </tr>
                                                       
                          </tbody>
                          <tfoot>
                            <tr>
                              <th>Search by Account Type</th>                          
                                
                            </tr>
                        </tfoot>
                        </table>
                      </div>
                    </div>
                    
                  </div>
                </div>
                
                </div>
              </div><!-- End Bordered Tabs -->
            </div>
          </div>
    </div>

@endsection
@pushOnce('scripts')
@auth

<script>
  var minDate, maxDate;

  // Custom filtering function which will search data in column four between two values
  $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
    var min = minDate.val();
    var max = maxDate.val();
    var date = new Date(data[1]);

    if (
      (min === null && max === null) ||
      (min === null && date <= max) ||
      (min <= date && max === null) ||
      (min <= date && date <= max)
    ) {
      return true;
    }
    return false;
  });

  $(document).ready(function() {
    // Create date inputs
    minDate = new DateTime($('#min'), {
      format: 'MMMM Do YYYY'
    });
    maxDate = new DateTime($('#max'), {
      format: 'MMMM Do YYYY'
    });

    var table = $('#fosastatement').DataTable({
      lengthChange: false,
      buttons: [
        {
          extend: 'copy',
          exportOptions: {
            columns: [0, 1, 2, 3, 4] // Customized columns included in the export
          }
        },
        {
          extend: 'csv',
          exportOptions: {
            columns: [0, 1, 2, 3, 4]
          }
        },
        {
          extend: 'excel',
          exportOptions: {
            columns: [0, 1, 2, 3, 4]
          }
        },
        {
          extend: 'pdf',
          title: 'Account Statement ',
          exportOptions: {
            columns: [0, 1, 2, 3, 4]
          },
          customize: function(doc) {

            var colCount = new Array();
            $('#fosastatement').find('tbody tr:first-child td').each(function(){
                if($(this).attr('colspan')){
                    for(var i=1;i<=$(this).attr('colspan');$i++){
                        colCount.push("*");
                    }
                }else{ colCount.push("*"); }
            });
            doc.content[1].table.widths = colCount;

            // Convert logo image to data URL
            
            doc.content.splice( 0, 0, {
                margin: [ 0, 0, 0, 5 ],
                width: 100,
                alignment: 'center',
                image: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOEAAADhCAMAAAAJbSJIAAABEVBMVEX///8XabP2cSL2aAAAYbD1ZQAAYK/2bx32bBMAZLH1YwD2aw72bx72bRgAXa4QZ7L/+fX6upv6tZUAW63+8+z5poD7y7P7/f71XgD93c396N38z7v3jVTn8Pfu9PkAV6wAT6n4lWn2dSj4lmOqw9/7wqf+7ubX5PG6zuX+9fD95Nf3h0v5oHX3fDL2djBOhcDI2OqWtdiuxeCRstb5rYp6os46e7xmlshCfLsdb7bB1Oh2oM1ZjMP4nW7o+Pz7yKz3ilH3gUFEfrJpj7Raibb4pXRBdaHV5vT4q4D74M0QY6R+qcz3jlEzcay7zNn4xK5ec53jva2ar8IAXaMAZsDa3eCrkI3UcD3uq4H6tJkASKYTwol+AAAaqUlEQVR4nO1dCXvixpYtKO0LEqsshMBhE2Aw+2ZD2mSZdqeTeN7LZJb3/3/IVEksktCGANP9Pp8vaXcbEHV06y5Vde8VAB/4wAc+8IHvDeWyfoBy69FcEkpZrw/Hq4XEbkEQBDubz6fDoV6+9eDORnkw7C8lliJYVpKkxB6StGP6PNRvPcjYUEbPy0qKkBzUXEBMqcRsMR58d8JUnp5nEsH6U3OwlIhUqj/+jkjq9ecZxQZIzpMnsZzNW7ceeiQMxiwVTXhHJNnsavStG9nycJGNR28nyezK+IZJ6l9Z4gx6W5LUcviNciw/X4CfyZFNDG9NxgP6UIo4PaU9Ajj2p9+YaVXGWSKcF4u8AkVIy9lisZjNlsslRWGvz7Iebydm35RhHS49BmkDS1CIV386xiHpTjiKouiD+nA4n69SFEW5JSpRs8FNSdkw6B8Nzz7hiGx2Xh8FTjrdGLSQQF3ClLKLb2OqTglfAUoStVjV9WiR52A0fk45r8UmRlcefAQYM18FRNH2sn7i1cbzJWUnSa1uPVWHWZ8JKlGJ51irQL0+RdN1f1WWGl980CfA6Ht7CIlN9UfxV0X6dHXgKFH922ljPeGtgdRsfO4i3rCFD2zi6TLjPRnzlKf8Usv6JW56ebzYm+jsTWaqMfc0Manl5W74eLGbq9T8/UPVgaeTJy48oVpL4lYUW15RJZu9+EJdGcxS5jex7+z9Rx4qKFHTq9znp6Vpc9iEcY2r+2CYOpKgxF4tjCxPJawRkvR+JnV8LEG20rqiougLypwk7xXfjBNH64DU/Mq7ni1kxBJS5cQgMCbqRysJlrj+mrw8RV8rLd9j+7iVdQuQ6L+LDWgtCETx+hN1dEQwMb/6l1ooz1m0HLv23Ry4N5uk7Dsub1r4+OO6E1Vfugm+73aK3qfY2TVdv+K2ohL7zidHeMvrilqhrFyxKLt8/6VbnU1Nr3dxykVw9Z6B1A7GMnut3ZvB0kVwcZvDzfLy/jrWreyyMtLsVqe3yuo6nn/m2s28gQ7usXi+wkVHTiWUbjRFLZSv4KQM17Zh6sb7mJc3cjMHwXf3g0fQ5xdWEteiPnX7Az7lspNId27LXDOsuBGeHXZUumpoeBMYzng0e4tQ5rr4yUHwtmclV4HucIVs/9bjuTycIkz9+83Rvx0bF8TXW4/n8vjZbkil2a2Hc0An/Spf4jp//uUQ4ftsWYaiWZhseJ6cXOJav7h8Yf3mOVltNV1KQoZOJulN+/zLGa6DbIlajG9pa2S1xkNeFJImSO38K/5ydE4osanxbVYWcjFdqvJi8gA+c/5Vf/PKRWCJxeC9J6usrTfcXnhbCJvcudd1LXwPgkxVTkuuKw+mz/P5c9wz/kYPQhc7S4iv8a63hzLzT+giEs9RT/QU4zmRMksRqFS8DYiNeMwOg96c6TAG7mMKl0LOo1idp+dlameviFQ8d5NnvBkmSTXW9faohyRVIo4hVzDGs31itERJJr+cpjUsFDQ1ggzQWxq8D0PmzGnaD8uKJQIXGsZwltqd5UhsdjlEWth5LVUhhDwG/lktvWp+LNtF7dderwpfQQH6MBSqZ03TgY+dOUzUgKMgfdynDolNlDTFE7qd4RinxRBEBvbWk4xTmLKafl3Xqjxy7IIglkDBhyCapoVzGI6DM2PRwJHdGM48dtn1er9yOIkjKladQS5d9ZxtiCUPk+u0hjDJ5/PrB+TVGXF3K4ReTt7Q15imQZbUAmUABcnnP5xGVR+tDkm/yB4treImdc3zHgb/QBPPWsggiC46sAjWPsY0ST+cwdAIsqSmCFfmeQ1yAj/vZ6teX7GHo36WXa6eTPEVaqTfIEPBa6Dg92GBbsZnGGZJsQjxTqqEI4Bf/vz844+f66uKvWQmOzdjn1xmgxx2XH7JpPgKmr4fh2fEpquQSYoXi60UtjdYWn9R2WzKkeEr4TQ3pamVeN5Pi6KB3gD5we8SYi02wXKYJSVQAP4Tm/CrnDAPUDsPkD9DehaEnuyviPjFmBiE1VAskar+5StnafEjkLvM2fQwCfoLyPj5/CQf21+MQxjiRKGf/f1JBRmfEgwwnieAmQQwZH6Ny3Ae5g3LQP/N90UKBWhd31GdCPpB1nwng/hDTIJh3hDvun31r7VAVqjAXYgg9ojy7xc3NXpwqZZE6EDx1UKJeAJy9TwL6mDYAWm/5UVsnx8SlJre3leEBArnMn7RcgzwaaD6Tnkx5gpqGGxo8N73H74iXADw5YIEkyj4/uLLEL7FYzgNNDRYz/70rEdIWDNYTrrMqGCBtlZNzGlGFs3EDr5jVa8X+ZgMg00p0fLah9u9iPzI2nHLBYZJVk28ZN4QtMxpSipUr2BqAuvNsQh9FZVdKSBDOkfxWsy1Tewu/+U0imIBZPxMTVyGgQsLvLb/yUeEONWm41RCmHdcWvkbBVpfmFMoIhZfqj4zG4WtcaAEEcQH3QO/OYpskPzoGD1TAuDv/1wucS8MExTe3yn6baB5Qajmcj0/3YWxdk1b/QCG7NhfT6mpWwnFRxmUf3OE6BIxV0DnlInKF4Hv8iIewyc/Q4mR1YHho4VsXwENhxKKjzlQnrnvB9HHuhhdioihr6mBsRbBTwEOn537OhMpoQPNoYRiMgd0jzIpnO1b7EWmyHdAw8/UXIGh4RvTYfIOJeQ3iODC63awCwXkIusiUwAdP58Pi3EY+p1YYDmhCTb2eZkagaI94Ca7bR+CeIl8grkRfwVtP2PKN+IwDAjaUi1QPiqc2TFEkcCBIU02gOcU3VKcKZEnqtBDy02ft16aobRU/FfHOJzpQWuaCnCDYuKB383A715FtqhCsgMmPooYj6H/RhuFSPiOOYHcfa6xgebWZxrgnYKg2IhYoeggmutHNNI+inhphgnF3GHzgVUQUVT/8Q9s4HTvamE7RTxR/YykHcwrCoPehSH29u66BMfriX3/Lt0qHQyn+BBBF+mNLG92pqZatb8Ub/nkxxCvjEI2w4nEdKTr+tM0UscaAi2lc1HMDfJ6Ge+3wVi7bSMfhvgwJmyPSmKpbCWbitixJipF5PPV3TSlabsQYzL0c3gD8PmcXlCeFJHrDw/gkOHq7BgKooNhrI39ljdDHLM8hyrXqRTRRTuhFNE6/7C8cMgw3lH3U8VTUFkUsIWYx5gUv/RCnAZa5x/29u0Ek2S846fh0pNJ6BZVPIrY9Xulk9gBPx08ooMhF/OArdxKHHXXwd4+9Nw0DqhnvDsXLEXk9hqeG3gxZYjRWhEOg48DtgBvfy7FYjBF5PNVT5/PnJMZpU8TNo7sNEJ+RkykpgpQA2NUZGqaXjsZQvK83C9lMCO2micR5cB143nAu1sqHaCLNPfFcydDLJ1FEHPU61nzaB57+2uJMGHt8Kjepzk4i4HZ1Irg1WOaMpdIpFVaCxSiVAwAokYqUSC5orosouixfhAYvpTWtC/4rNfrrOASOZgYxnyJs9hbc/e4YoP9+uSyy9RX5ehAh+Z7jYOtlBkzKcUxV2GspQUKFY9+o1g5pXq0iDocUl8xnDvrEl5ATxxSZH4vOEby+NLQVLVmD4DIL/EYav6hkD68DEcUyrgqjqTsEz6WO5gbuuS609axQNemjgIdN1Uh6DRAHztXfjH5psZHFHGPloMu8iXv0dtNavysqOqnoFeN+SXESNXdFBMskmJ6u6XMr308nV1X4xua15DN8qc/LhCgVkbAcFWJU09bKQrkq0+1gWpnCDtxGap3Icsu5Z/bapOgdqthyI7Ak/NOSakWNjcCzWT8FMyRMszHzzB97IW9o2Wm8v/12x9//JaKu2hM1dFa9FgXJ3DjbyJf7GoYOkp/5Ll02Fv0P/6L/a31o6L8OPg5bjhXabn7+pgWte0vmpw9tjsncy8Nk6EToPzLVyVXyGQKKhh41maEQ0K2xbXDLCUCa1Yc+VHwjFz2IowULTRrJE4+KMmfA5rRBlMcgWdXR4PAlg12NRQez0n03tAw/OONqvV9/MNR95PoFAfK3PlZIqAuw7EZIK7PIIhsNp8Pe4+2D0BgGifYSCwR+syAI9MrEQPgopj6HDAs+ySNmWpioQOTXIgetw+p2/QL+GeK+mlYH/6yDBSmtOwfdStCiufsphlQ5+A4oIHnEARAFMJscdHme6H650+fgdxpAmUUtJ0vrcpf3cGCtBwoK/svcVaZN2S7JY2dmLiFxoctTTqHI3uBQYuczu9VkvlBAz+uAk5Yl3UwdvdeZJdlpW+jyPpW4zgt6ZkViHJSEEJit8N2PMzgW4KtgMjzquLdwtUCVVeOTt3YvmL/jG+XxI59F0A4w91bQDE8E2xscrvTP9iVc/ucYJpJHzXOskuRGipHHTSR+VR2h3GSf2ddh51h4qexb/EJqRkXHNmmH80omV+DnD1nHaqfCRywej+tREKLipbb3GRbAPHGj6Yh/FsxOtIVYmZDOZAUQtPG1DwDeboBio6tQH4C/vhrsVqt+gmvQEBCttK1wDdzNsHnYX+5GPuXU71emuEbjBAX5Qp5FcjOAzImL//zbzmXk0F5uGXicJMSNQYDl+NMWcSCCnCdW/9xd2jskKGZUxbhna4Ndybf+ZLuVmH15b/LZgocMXS1V05N3avfCB0pHMc3lxChtS8kRinyc24D0ptGo4RLdwWR/5+iWVnTL+vO3C/q2ZWJEs7QWYcY7/zeDXM5HcVkOXO9kunXfS4QXwMLCbuDst4nXBQNG2lcohICZ5EevEDDAbRyMBOR+NCVonMCkZO0LdmJKZpZAaykg2fHuU4KSfEwUbOhNcLObPZL7QRbiYZkOMXOPkQVYKZgv9tQG6TMR8uwBvjqiHWoKZqolu8PcIE7NDm7mRHEizT+ALtcKzJ8v0fblqgJ1ULOsWULC5/ZxWwpERJbB19TbopTliIoahZe5b12HFrACPMqGtqmEMWX8DumbXAKvggL4JNjOkHN3C7Xx6agHN2yJewh9NGw/hTei8BprcVzikddsG4dEyUE/ERC+FB0bqQkxV67rZV6LwW5RSWyQzCyx2upyA0CO87UxHNjbjualoJFSomXZSzqpiM6TnYAdhwi3OC8W2Ku1G2ePrje3Q5nmSbTjU/oGNvjoOjL6aY9DRqm23lr0sLi54qZ//x0kGLkVsvOAxucFX1JbA0jGdXD5u5sQ1nLk60C8f+r4ACOmJWfdvvcODMgEgrOAg7+oiLcr8noTdQN9O7elPKl4o4giuTKppVhZ+XPSzMel6iIaug6/haqZ1Rwe2Ib0dORM1do8xAThWzd4qe9CeQbP1Ys5ZuDcp2gUik2YiMQV1h/keZCTuS2+ZH0JuKlm50Nx3HM+ne5c0hs55rbbDkrPtMHkZuEPjiP78Wzl/bHUAVrloh85OnRzuVybdlmIZAx3kahqRM7E+adVubsrjSe2CkTnTwx1XFf4yXyuCYTLeFPbsm9dh3tX36OmnjZThT6VDv9dmf6U/iCF9L6dDF7PrFZWNpF8NJ2dAc5udUngTsxppfTPAm52Ekv7kK/M5oohEDdVYUK/keXPiiqauyD2olLgsIZeXpheN3fTFg7u4tYVKxdGUQCE/teRUB+fzvFc07tTkCu5s6BCj+1PQsb/nArL7JHEoLjSgwYehh2Jg5rUIE86+AuEtSjri/8mQcx4WgnD9/JiNfUCIQJ507F5F+u+40YRVuRksD9epHNLm80u0dpiMwFl/X+KNqDfD55NYOjJo8ySSPtMlziqzmbcghc7RohIpDXRzM0yVwlGvWCs2CQoa9gvrVjAeJMiHeD7ChvEfi4vUX8oE7cDdswwfcLMhDaTjclkJdccecynEdbkPewog68OO0cDXsXkqPc5b0KRc8/6z15IGlXjyuafLhAkNPUeK+2LsKVQzVvZNxDoSEzOVNV0tCzN5h4aUWPCPWoD6LAQL4hxwwCcmqe9C5khpvLbo1Gh5fPEtAgGzH2GJoZkfQuYxbgRRqvx0TBo2GgIPDk5gftFElq+RL06/sphqWdXRmdjWe1HC3C6kO+GEUrm281Evq2HqS5hytGvpEgT3zaWgo0A5neptZQbUpk11FZlhvdlyof1DdS7F159RIJxap/b0SaFnlIbhBKk9d8vvv7S7dbW3cRSj0saCaoUg03nbi1AC3IDe/mwDaeiKnVPJcWEdBfRFEQQkpiBXi9dcvJaOfPaTDrDV68hZP3R+6MJsEeEBgucysf6Au1xl2KI/Kp3ettiZ6BZsk75joRNC/e0sUHQy0w5yokQ27S77WSjwfkv09qpeeAyHPdKE8SuDE6kw0T1HrdDzTk1t+eefFBLv0I3c9LCZMe3ATUrH6LKBZqVTJKk1JBECGE3fT3Ij0HtLcJT0IUVnuHLzjQ4clqr6t+B7rnC7ndecvXerTZ+gvyOHRjeAhJBPj4WJpkOt8xOTtymqaqKpIpRrqhdjBuPSg/qD/U3tcidDS/ZWZTi32X2ua9njS8qGRIGH6K35w89Db5M+5EZzLZflq7Ixnv98gkvItLscAx5nNuyOrxBmGaD8891pDGoc/fxaeY4chtvkWDFDlvXW1y5g6HrGmnB7EFmKxueklS9DgFjcAwxwnMw6RLh5WCByDN72qRcrUXv2VU/mUtYyFzpyefFKBZ89Zcw+NsxAgM0zz9gn824vu4A8NQaDDyWw/YMsTdJwRLCdR8qWTp1Y6hti7VMul0OocPUmro74ep0mVsDWPkt26p1N2lUTVqpbUl2Q7+0C7IbqfRPya2G3Jg2J7k8VSc5IugUCtN2uiba6W8+WXpPBpJoyvSL400VshcBl19mwIrZ2pB5wB7hm3eaoXW5ZAL47n8gWGNhCR+KtVdAbxw5gOquL3WTXjcHs+CSppNMEnzZKxIQ6SfHJ75eQ7pOXKNmvV96B+8dX03Q5WD6LPNOzKNYnqRp5s1Dv0wk+vumDu5fceYIS26pRoeJCTNQ8amyOMcs3CG4IHGhRYZUixpWo/G6WQWwwbJrNW0KDy+dHIcRMJ8EQ/Fph0uKcCuxXHCVbvpSVIg38xDObG6fiA3+IoCs85vRAF3AFY5gS+9lnibStgYQrpk5hwjdj0ep3OKG95KgSaTpCwncfJ3VWygb6Wrb/iBS/gGPogCE9Ra6cAwzzCvQIZ0FUuAx/2YLIY188B5wuPfWwuCqnAweXlSSDJWUpHa2F5wjYvEzKdqql2QgwKvWjcQ3fwXEf+J+0Qkgxi+tHEBsLhpgoz1TszQvHYXP5mtJpr9MR5omAMdUuADHYmLoQoZU/UeaX7H8MXMGUjz3N4bv9C2ZKwGXu0zh44cTRLnopXEXaI4+gLzDmtQ6IE2FGi8ayjD5P5yxwxNTogoLp/P8Uluz3BraeRtmdeEgSr+eLB9PTCsiWiWpnmh2kMQBG7HMM/wBbnYsyq+1MlLr+dqC9dAM8pMc5Ub6w36KGZYFXZVKZmtuSoiUkhVtw1mqsI+0eqYIf2IL8aZpduyKBwxbMJkEg8SXURDwwvphnlgaL4/wydpc7uTSe4YovsOk7zI4Tm4RuqNT/1cCXVdBjeh7uC1ESOa+YS0QG7NJbpBppNrYoYatJwL6J3FkMTPX8CjRBfpMiHFGHuGGhpBGzR4ZiLnMOQdwzRfrXJcD1/mjaQ3nZz8QLtTBjlshzcin2m2VWjJcMcgsyXQgYKIZChYZYTi/g7EkiG9yVnAUzWkbm/HsEgji4e/xNbyzWQoYwsh72QFLaOxZ1gwX8khnSnmeFM7iqYe1kTLTxax2DZbpmtzPhQtuvDwLScwFLHOyVXh0KemAUOa1BXQvNG0tzUviCK2AeirsW9upgs7hmhS5jONBn40Y968X5p4mKVVOqMWtQ0tbkCbEaptIK9FzBAFg8wnubhmcCMGPi/LGiNgd1sSxYcmKG5Mw7pjSJfeGo3GWzhDFRkqnL26ZkRsvdvaxNRvfhIUUaGh0Kb6wEfzbW8czTO9Kold8tYf8gJ2r5DRTG9WK3H8gWEPB+2QNq13jacff0ARrpnXixwZ5EgeazOHz4uhYMbXRU5EoQCk+cPjxdJI9XHwfyeHMkRTQMAevwlFEfZ6aLkAzMRwhgxgqN5xCLBX2xkkrYfiFpLD/cfTd3cZ7Lv4db67EWk0M9Lopbvap7u7HcPOAw5kyBL+d/uBgxxs1O4wQ7mGL2Nmwr8l0XtIurH9AA6LYPewhiiYI+A4xPCOe8A1OByNL3BHYmoyyd2hH3fkHf7EJ/TRO3Sh5os5yKRpw/A3BTDEZ3tWhdYeRbRKt5xVsYijEEujNjSWU1vT0O+aNkOTU3fvNj8pA7loXa2p7VetHc22gEW/dz2lU96NoWl+NGddIFc0z9va5o/29gi2vbsS+lptNzeL523dNaD1eJ6eEO+5C98+NKRG+UZ6I8J3T+QJReQynGBM8IznSHi5wgdltFr5dFKY9o/f7X2RMgDG/YWe/N4spP8vXbhcLp0yqzyPZ8dUMMZHfVyUpWdBmJ41Lsfw0hhXcKFlGYyMcR0Yz/MRMMYKaLXQK/qgBZ4GrTkiZTw/DzG3OruqA2U8HyOh1efjoQFa86kOvmanT0ZlNMXPRB/MT6w8ujaWfVDW9TLoU7OxcT+fVsb6v56ARCjGv/T5AjynFqv7AWDH9QrukPXMzqZgthwuE4jsUz9hjCr1eUVfEf26kZWeqTkYVIbfGEN2DoaVygr0ZwDMl+b/y6lOZI1hAsz7YJoAIFtX7g0Ft8EFioQEjRgP7gfTFRjPwGJloL/r93iWPoHpDMxnRtTq23fCDDFD4wR9pHN9/BgbSZkuhvP+cPVsMpwBhaiDhbTE7wNlxLB1rwP9vjWozCotsFz2+33DuLf0EL27v1x5K/XNMKzgVuiI4QrPQQX0F2BALev1hPRkMkRipepIPubjhUGZHSIqIzC61+fzJ2SBFyYdG8P57LZ8PDCvLJeVOSYJjOxyhgyPUrnXjfuKAlZID5fon0MlwSYk8yHgC6oPVtk+Usp6NiEtlKdKf04oSoqdGv8a4PthVGZhz7V/dxj1OhKQgV1iuV7HPwzD+l838H/AKLfuEV2zvrZcR1r2hP9AJse4bwG9XsdvGRqKoZjv1kcRK4y/KbTup+OKq4HUYjnsU+ENJ74XGPWh258ro+Ho34fgBz7wgQ984AMf+MAHPvCBbxD/D9u5oWlIsw8+AAAAAElFTkSuQmCC'
            } );
                        
            // Add user details to the PDF
            doc.content.splice(2, 0, {
              text: 'Member Name: {{ auth()->user()->fname }} {{ auth()->user()->lname }}',
              fontSize: 12,
              margin: [0, 0, 0, 5]
            });
            doc.content.splice(3, 0, {
              text: 'Email: {{ auth()->user()->email }}',
              fontSize: 12,
              margin: [0, 0, 0, 5]
            });
            doc.content.splice(4, 0, {
              text: 'Member Number: {{ auth()->user()->member_number }}',
              fontSize: 12,
              margin: [0, 0, 0, 5]
            });
            
          }
        },
        {
          extend: 'print',
          exportOptions: {
            columns: [0, 1, 2, 3, 4]
          }
        }
      ],
      initComplete: function () {
              this.api().columns().every(function () {
                  var column = this;
                  var title = $(column.footer()).text();

                  // Create input element
                  var input = document.createElement('input');
                  $(input).attr('placeholder', title);

                  $(input).on('keyup change', function () {
                      if (column.search() !== this.value) {
                          column.search(this.value).draw();
                      }
                  });

                  $(column.footer()).html(input);
              });
          }
    });

    table.buttons().container().appendTo('#fosastatement_wrapper .col-md-6:eq(0)');

    // Custom filtering function for account type
    $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
      var accountTypeFilter = $('#accountSelect').val();

      if (accountTypeFilter === '' || accountTypeFilter === data[0]) {
        return true;
      }

      return false;
    });

    // Trigger table redraw when account type filter changes
    $('#accountSelect').on('change', function() {
      table.draw();
    });

    // Refilter the table
    $('#min, #max').on('change', function() {
      table.draw();
    });
  });
</script>
@endauth

    
@endPushOnce