@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>Product 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">Product Name</label>
                                     <select name="product_id" class="form-control">
                                        <option disabled="" selected="" value="">Select One</option>
                                       {{ create_option("products","id","name",old('product_id'),'ORDER BY id desc') }} 
                                    </select>
                                    {{-- <input class="form-control" type="text" name="product_name" id="name" placeholder="Product Name" value="{{ old('product_name') }}"> --}}
                                </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('productWise.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>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>{{@$productWiseInfo->product->name}}</td>
                                      <td>{{@$productWiseInfo->product->code}}</td>
                                      <td class="text-right">{{$productWiseInfo->quantity}}</td>
                                      <td class="text-right">{{$productWiseInfo->price}}/=</td>
                                      <td>{{@$productWiseInfo->purchaseInfo->purchase_no}}</td>
                                      <td>{{@$productWiseInfo->purchaseInfo->created_at}}</td>
                                      <td class="text-right">{{$productWiseInfo->total}}/=</td>
                                     
                                  </tr>
                                @endforeach
                               
                               
                                
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        </div><!--end row-->
        
        </div> <!-- container-fluid -->
        @push('alljs')
  
        
        @endpush
        @endsection