@extends('include.sidebar')
@section('content')
<div class="col-lg-12 layout-spacing">
                                        <div class="statbox widget box box-shadow mb-4">
                                            <div class="widget-header">
                                                <div class="row">
                                                    <div class="col-xl-12 col-md-12 col-sm-12 col-12">
                                                        
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="widget-content widget-content-area">
                                                <div class="form-group row">
                                                    <div class="col-lg-12 col-md-12 col-sm-12">
                                                        <form id="form_shiba" class="needs-validation"  action="{{route('user_account_report_submit')}}" method="post" enctype="multipart/form-data">
                                                            
                                                            @csrf
                                                            <div class="form-row">
                                                            <div class="col-md-3 mb-3">
                                                                <input  type="text" class="form-control flatpickr flatpickr-input" type="text" placeholder="Enter Mobile Number" name="mobile_number" required>
                                                            </div>    
                                                            <div class="col-md-3 mb-3">
                                                                <input  id="basicExample" class="form-control flatpickr flatpickr-input" type="text" value="{{$date_from}}" name="date_from" required>
                                                            </div>
                                                             <div class="col-md-3 mb-3">
                                                                <input  id="minDate" class="form-control flatpickr flatpickr-input" type="text" value="{{$date_to}}" name="date_to" required>
                                                                    
                                                            </div>
                                                                
                                                                <div class="col-md-3 mb-3">
                                                                    <button class="btn btn-block btn-lg btn-primary" type="submit">Submit</button>
                                                                    
                                                                </div>
                                                            </div>
                                                                                                                        
                                                           
                                                        </form>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-xl-12 col-lg-12 col-sm-12  layout-spacing">
                                        <div class="widget-content widget-content-area br-6">
                                            

                                            <div class="table-responsive mb-4">
                                                <table id="export-dt" class="table table-hover" style="width:100%">
                                                    <thead>
                                                        <tr>
                                                            <th>#</th>
                                                            <th>Order Details</th>
                                                            <th>Credit By</th>
                                                            <th>Debit By</th>
                                                            <th>Remark</th>
                                                            <th>Amount</th>
                                                            <th>Total Amount</th>
                                                            <th>Type</th>
                                                            <th>Opening</th>
                                                            <th>Closing</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                    @foreach ($result as $list)
                                                        <tr>
                                                            <td>{{$list->id}}</td>
                                                            
                                                            <td>
                                                                <h6 style="color: #5c1ac3;"> Date : {{$list->created_at}} </h6>
                                                                <h6>Order Id : {{$list->order_id}} </h6>
                                                                <span class="badge badge-info">
                                                                {{$list->transaction_type}}</span>
                                                               
                                                            </td>
                                                            <td>
                                                                @if($list->credit_user_id==0)
                                                                    <h6>-</h6>
                                                                @else
                                                                  <h6>{{ \App\Models\User::find($list->credit_user_id)->first_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->credit_user_id)->last_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->credit_user_id)->outlet_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->credit_user_id)->mobile_number }}</h6>  
                                                                @endif
                                                            </td>
                                                            <td>
                                                                @if($list->debit_user_id==0)
                                                                    <h6>-</h6>
                                                                @else
                                                                  <h6>{{ \App\Models\User::find($list->debit_user_id)->first_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->debit_user_id)->last_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->debit_user_id)->outlet_name }}</h6>
                                                                  <h6>{{ \App\Models\User::find($list->debit_user_id)->mobile_number }}</h6>
                                                                @endif
                                                            </td>
                                                             <td><h6>{{$list->remark}}</h6></td>
                                                             <td><h6>{{$list->amount}}</h6></td>
                                                            <td><h6>{{$list->total_amount}}</h6></td>
                                                            @if($list->fund_type=="Credit")                                                           
                                                            <td><span class="badge badge-success">{{$list->fund_type}}</span></td>
                                                            @else
                                                            <td><span class="badge badge-danger">{{$list->fund_type}}</span></td>
                                                            @endif
                                                            <td><h6>{{$list->opening_balance}} </h6></td>
                                                            <td><h6>{{$list->closing_balance}} </h6></td>
                                                        </tr>
                                                    @endforeach  
                                                    </tbody>
                                                    
                                                </table>
                                            </div>
                                        </div>
                                    </div>
@endsection