@extends('admin_dashboard')
@section('admin')

<div class="content">
    <div class="container-fluid">
        <div class="page-title-box">
            <h4 class="page-title">Products List (Land)</h4>
            @if(session('success'))
                <div class="alert alert-success">{{ session('success') }}</div>
            @endif
            @if($errors->any())
                <div class="alert alert-danger">{{ $errors->first() }}</div>
            @endif
        </div>

        <div class="row">
            <div class="col-12">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="mb-3">All Products Records (Grouped by Wings No)</h5>
                        <table id="grouped-wings-datatable" class="table table-bordered align-middle w-100">
                            <thead class="table-light">
                                <tr>
                                    <th>#</th>
                                    <th>Wings No</th>
                                    <th>Type of Product</th>
                                    <th>Flat/Plot No</th>
                                    <th>Quantity</th>
                                    <th>Status</th>
                                    <th>Update Status</th>
                                    <th>Group</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($wings as $w)
                                    <tr>
                                        <td>{{ $w->id }}</td>
                                        <td>
                                            @if($w->file_path)
                                                <a href="{{ asset('storage/'.$w->file_path) }}" target="_blank" class="text-primary">{{ $w->wings_no }}</a>
                                            @else
                                                {{ $w->wings_no }}
                                            @endif
                                        </td>
                                        <td>{{ $w->type }}</td>
                                        <td>{{ $w->flat_plot_no }}</td>
                                        <td>{{ $w->quantity }}</td>
                                        <td style="background-color: {{ $w->booking == 'খালি আছে' ? 'red' : ($w->booking == 'বুকিং হয়েছে' ? '#ffc107' : ($w->booking == 'বিক্রি হয়েছে' ? 'green' : '')) }}; color: white;">
                                            {{ $w->booking }}
                                        </td>
                                        <td>
                                            <form action="{{ route('product.booking.update', $w->id) }}" method="POST">
                                                @csrf
                                                @method('PUT')
                                                <div class="input-group input-group-sm">
                                                    <select name="booking" class="form-select form-select-sm">
                                                        @foreach($types as $status)
                                                            <option value="{{ $status }}" {{ $w->booking == $status ? 'selected' : '' }}>{{ $status }}</option>
                                                        @endforeach
                                                    </select>
                                                    <button type="submit" class="btn btn-primary">Update</button>
                                                </div>
                                            </form>
                                        </td>
                                        <td>{{ $w->wings_no }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection



@push('scripts')
<script>
    $(document).ready(function() {
        var table = $('#grouped-wings-datatable').DataTable({
            "order": [[ 7, 'asc' ]],
            "displayLength": 25,
            "columnDefs": [
                { "visible": false, "targets": 7 }
            ],
            "drawCallback": function ( settings ) {
                var api = this.api();
                var rows = api.rows( {page:'current'} ).nodes();
                var last = null;
    
                api.column(7, {page:'current'} ).data().each( function ( group, i ) {
                    if ( last !== group ) {
                        $(rows).eq( i ).before(
                            '<tr class="group table-secondary"><td colspan="7"><strong>Wings No: '+group+'</strong></td></tr>'
                        );
    
                        last = group;
                    }
                } );
            }
        });
    });
</script>
@endpush