@extends('layouts.admin')
@push('css')
@endpush
@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                @include('admin.withdraw.withdraw_report_topbar')
                <div class="card">
                    <div class="card-header">
                        <div class="row">
                            <div class="col-md-6">
                                <h5>Multiple Withdraw Request</h5>
                            </div>

                            <div class="col-md-6 text-right">
                                <a href="{{ route('member.searching') }}" class="btn btn-secondary btn-sm">Create Withdraw Request</a>
                            </div>
                        </div>

                    </div>
                    <form action="{{ route('withdraw_report.multiple_withdraw_store') }}" method="post">
                        @csrf
                    <div class="card-body">

                        <div class="row">
                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="issue_date" class="col-form-label pt-0">Issue Date <span class="text-danger">*</span></label>
                                    <input class="form-control" type="text" name="issue_date" autocomplete="off" id="issue_date" placeholder="Issue Date" value="{{ old('issue_date') }}">
                                    @if ($errors->has('issue_date'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('issue_date') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="cheque_bank_id" class="col-form-label pt-0">Select Bank<span class="text-danger">*</span></label>
                                    <select name="cheque_bank_id" id="cheque_bank_id" class=" form-control">
                                        <option value="">Select Option</option>
                                        @foreach($bank_cash_accounts as $account)
                                            <option {{ old('cheque_bank_id') == $account->id ? 'selected' : '' }} value="{{ $account->id }}">{{ $account->account_name }}</option>
                                        @endforeach
                                    </select>
                                    @if ($errors->has('cheque_bank_id'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('cheque_bank_id') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="type" class="col-form-label pt-0">Select Type<span class="text-danger">*</span></label>
                                    <select name="type" id="type" class=" form-control">
                                        <option {{ old('type') == 'By_Bank_Account_Cheque' ? 'selected' : '' }} value="By_Bank_Account_Cheque">By Bank Account Cheque</option>
                                    </select>
                                    @if ($errors->has('type'))
                                        <span class="text-danger" role="alert">
                                            <strong>{{ $errors->first('type') }}</strong>
                                        </span>
                                    @endif
                                </div>
                            </div>

                        </div>

                        <div class="dropdown-divider"></div>
                        <div class="table-responsive">
                            <table id="datatable-buttons-alllist" class="table table-striped table-bordered w-100">
                                <thead>
                                <tr>
                                    <th>Sl.</th>
                                    <th>Name</th>
                                    <th>Amount</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                $total = 0;
                                @endphp

                                @foreach($statements as $key => $user_id)

                                    @php
                                        $transactions = model('Transaction')::with('agent')->whereIn('for_report', ['agent_commission','agent_investment'])
                                        ->where('agent_id', $user_id)->where('amount' , '>', '0')
                                        ->where('type', 'Monthly Business Profit')
                                        ->whereDate('trans_date', '=', \Carbon\Carbon::now()->startOfMonth())
                                        ->get();
                                        $user = \App\Models\User::find($user_id);
                                        $total = $transactions->sum('amount');

                                    @endphp
                                    @if(!empty($user))
                                    <tr>
                                        <td>{{ $key+1 }}</td>
                                        <td>{{ @$transactions[0]->agent->name }} ({{ @$transactions[0]->agent->user_id }})</td>
                                        <td>{{ $total }}</td>
                                        <input type="hidden" name="agent_id[]" value="{{ @$transactions[0]->agent_id }}">
                                        <input type="hidden" name="total[]" value="{{ $total }}">
                                    </tr>
                                    @endif
                                @endforeach
                                </tbody>
                            </table>
                            <div class="float-right mt-2">

                                <button type="submit" class="btn btn-primary">Submit Request</button>
                            </div>
                        </div>
                    </div>
                    </form>
                </div>
            </div>

        </div><!--end row-->

    </div> <!-- container-fluid -->
    @push('alljs')
        <script>
            $('#issue_date').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
        </script>
    @endpush
@endsection