@extends('layouts.app')

@section('content')

<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
            <h4 class="mb-sm-0 font-size-18">Product Group Pricing</h4>

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboards</a></li>
                    <li class="breadcrumb-item active">Product Group Pricing</li>
                </ol>
            </div>

        </div>
    </div>
</div>
<!-- end page title -->

@include('validate')

<div class="row">
    <div class="col-lg-12">
        <div class="card">
            <div class="card-body">
                <h4 class="card-title mb-4">Product Group Pricing</h4>


                <form method="POST" action="{{ route('productgrouppricing.search') }}">
                <div class="row mt-3 mb-3">
                    <div class="col-md-4 mb-3">
                        <select class="form-control select2" name="product_id" id="product_id">
                            <option value="">Product</option>
                            @foreach ($productsData as $product)
                            <option value="{{ $product->id }}">{{ $product->product_name }}</option>    
                            @endforeach
                        </select>
                      </div>

                      <div class="col-md-4 mb-3">  
                            <select class="form-control select2" name="category_id" id="category_id">
                               <option value="">Category</option>
                               @foreach ($categoryData as $category)
                               <option value="{{ $category->id }}">{{ $category->category_name }}</option>
                               @foreach ($category->subcategories as $subcategories)
                               <option value="{{ $subcategories->id }}"> -- {{ $subcategories->category_name }}</option>
                               @endforeach      
                               @endforeach
                            </select>  
                    </div>

                    <div class="col-md-4 mb-3">
                        @csrf
                        <button class="btn btn-info" type="submit">SEARCH</button>
                      </div>


                </div>
            </form>



              <form method="POST" action="{{ route('productgrouppricing.store') }}">
                <div class="row mb-4"> 
                    <div class="col-md-12">

                        <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Product Name</th>
                                <th>Product Code</th>
                                <th>Sale Price</th>
                                @foreach ($groupData as $group)
                                <th>{{ $group->group_name }}</th> 
                                @endforeach
                                
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($productsData as $products)
                            <tr>
                              <td>{{ $products->product_name }}</td>
                              <td>{{ $products->product_code }}</td>
                              <td>{{ round($products->sale_price,2) }}</td>
                              @foreach ($groupData as $group)
                              @php
                              $pricing = $pricingData
                                  ->where('product_id', $products->id)
                                  ->where('customer_group_id', $group->id)
                                  ->first();
                              @endphp
                              <td><input type="number" class="form-control" name="pricing[{{ $products->id }}][{{ $group->id }}]"
                                value="{{ $pricing ? round($pricing->price,2) : 0 }}"> </td> 
                              @endforeach
                            </tr>
                            @endforeach
                            
                        </tbody> 
                        </table>
                     
                        
                    </div> 
                </div>
                <div class="row mt-4"> 
                    <div class="col-md-12 "> 
                        @csrf
                        <button type="submit" class="btn btn-primary w-md float-end">UPDATE</button>
                    </div>
                </div>
            </form>
                

            </div>
        </div>
    </div><!--end col-->
</div>



@endsection


@push('scripts')

<script>

$('.select2').select2();  
 


</script>

@endpush