@extends('layouts.admin')
@section('content')
@push('css')
@endpush

 <div class="row">
        <div class="container-fluid">

        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <div class="row">
                        <div class="col-md-6">
                            <h5>Member Wise Report</h5>
                        </div>
                        
                    </div>
                    
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ url()->current() }}">
                        <div class="row mb-3">
                            <div class="col-md-1"></div>
                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="name" class="col-form-label pt-0">Member Name</label>
                                    <select name="member_name" class="form-control select2">
                                        <option disabled="" selected value="">Select One</option>
                                        @foreach ($members as $member)
                                            <option value="{{ $member->id }}" >{{ $member->name }}-{{$member->user_id}}-{{$member->phone_number}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2">
                               <div class="form-group ">
                                    <label for="product_code" class="col-form-label pt-0">Purchase No</label>
                                    <input class="form-control" type="text" name="purchase_no" id="product_code" placeholder="Product No" value="{{old('purchase_no')}}">
                                </div>
                            </div>
                              <div class="col-md-2">
                              <div class="form-group ">
                                    <label for="start_date" class="col-form-label pt-0">Search Date</label>
                                    <input class="datepicker1 form-control" type="text" name="start_date" id="start_date" placeholder="Search Date" value="{{old('start_date')}}" autocomplete="off">
                                </div>
                            </div>
                              <div class="col-md-2">
                                <div class="form-group ">
                                    <label for="end_date" class="col-form-label pt-0">End Date</label>
                                    <input class="datepicker1 form-control" type="text" name="end_date" id="end_date" placeholder="End Date" value="{{old('end_date')}}" autocomplete="off">
                                </div>
                            </div>
                            <div class="col-md-2 mt-4">
                                <button class="btn btn-primary">Search</button>
                                
                               <a href="{{ route('memberWise.report') }}" class="btn btn-danger">Clear</a>
                            </div>
                        </div>
                    </form>
                    <div class="table-responsive">
                        <table id="datatable-buttons-alllist-offasc" class="table table-striped table-bordered w-100">
                            <thead>
                                <tr>
                                    
                                    <th>Member Name</th>
                                    <th>Product Name</th>
                                    <th>Product Code</th>
                                    <th>Product Quantity</th>
                                    <th>Product Price</th>
                                    <th>Purchase No</th>
                                    <th>Purchase Date</th>
                                    <th>Grand Total</th>
                                   
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($productWiseInfos as $productWiseInfo)
                                  <tr>
                                      <td><a href="{{ route('memberWiseReport.details',$productWiseInfo->user->id) }}">{{$productWiseInfo->user->name}}</a></td>
                                      <td>{{$productWiseInfo->purchaseData->product->name}}</td>
                                      <td>{{$productWiseInfo->purchaseData->product->code}}</td>
                                      <td class="text-right">{{$productWiseInfo->purchaseData->quantity}}</td>
                                      <td class="text-right">{{$productWiseInfo->purchaseData->price}}/=</td>
                                      <td>{{$productWiseInfo->purchase_no}}</td>
                                      <td>{{$productWiseInfo->purchase_date}}</td>
                                      <td class="text-right">{{$productWiseInfo->purchaseData->total}}/=</td>
                                     
                                  </tr>
                                @endforeach
                               
                               
                                
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        </div><!--end row-->
        
        </div> <!-- container-fluid -->
        @push('alljs')
  
        
        @endpush
        @endsection