@extends('layouts.admin')


@push('styles')
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


<style type="text/css">
    .btn_mt {
        margin-top: 31px;
    }
</style>
@endpush


@section('content')
<!-- Main content -->
<section class="content">
    <div class="container-fluid pt-2">

        <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-info">
                <!-- form start -->
                <form method="GET" action="{{ route('product.product_update') }}">

                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label for="category_id">Category</label>
                                    <select id="category_id" name="category_id"
                                        class="form-control form-control-sm select2" value=""
                                        style="width: 100%;">
                                        <option value="">Select Category</option>

                                        @foreach ($categories as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($category_id) && $category_id == $v->id ? 'selected' : '' }}>
                                            {{ $v->cat_name }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label for="product_id">Product</label>

                                    <select multiple data-placeholder="Select Product" id="product_id"
                                        name="product_id[]" class="form-control form-control-sm select2"
                                        style="width: 100%;">

                                        @foreach ($products as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($product_id) && $product_id == $v->id ? 'selected' : '' }}>
                                            {{ $v->product_name }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>


                            <div class="col-md-4 col-sm-4">
                                <div class="form-group btn_mt">
                                    <button type="submit" style="margin-top: 0;"
                                        class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('product.product_update') }}" style="margin-top: 0;"
                                        class="btn btn-secondary btn-sm btn_mt">Refresh</a>
                                </div>
                            </div>

                        </div>
                    </div>
                </form>
            </div>
        </div>

        <!-- /.card -->

        <div class="row">
            <!-- left column -->
            <div class="col-md-12">

                <div class="card card-info">
                    <div class="card-header">
                        <h3 class="card-title">Product Update</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <form method="POST" action="{{ route('product.produpdated') }}">
                            @csrf
                            <table id="example1" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Category</th>
                                        <th>Product Name</th>
                                        <th>Code</th>
                                        <th>Unit</th>
                                        <th>Price</th>
                                        <th>Service Charge</th>
                                        <th>Vat(%)</th>
                                        <th>SD(%)</th>
                                        <th>Dis.</th>
                                        <th>F.Type</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $sl = 1;
                                    @endphp
                                    @foreach ($itemList as $val)
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $val->cat_name }}</td>
                                        <td>{{ $val->product_name }}</td>
                                        <td>{{ $val->product_code }}</td>
                                        <td>{{ $val->unit_name }}</td>
                                        <!-- <td>
                                            <input class="form-control form-control-sm" style="width:60px"
                                                value="{{ $val->opening_balance }}" name="balance_inhand[]"
                                                type="text">
                                        </td> -->
                                        <td>
                                            <input class="form-control form-control-sm" style="width:60px"
                                                value="{{ $val->sale_price }}" name="price[]" type="text">
                                        </td>
                                        <td>
                                            <input class="form-control form-control-sm" style="width:60px"
                                                value="{{ $val->scharge }}" name="scharge[]" type="text">
                                        </td>
                                        <td>
                                            <input class="form-control form-control-sm" style="width:60px"
                                                value="{{ $val->vat_rate }}" name="vat_status[]" type="text">
                                        </td>
                                        <td>
                                            <input class="form-control form-control-sm" style="width:60px"
                                                value="{{ $val->sd_rate }}" name="sd_status[]" type="text">
                                        </td>

                                        <td>
                                            <select style="width:60px" class="form-control form-control-sm"
                                                name="dis_status[]" id="">

                                                <option value="1"
                                                    {{ $val->dis_status == 1 ? 'selected' : '' }}>
                                                    Yes</option>

                                                <option value="0"
                                                    {{ $val->dis_status == 0 ? 'selected' : '' }}>
                                                    No</option>
                                            </select>
                                        </td>
                                        <td>
                                            <select id="type_id" name="type_id[]"
                                                class="form-control form-control-sm select2" value=""
                                                style="width: 100%;">
                                                <option value="">Type</option>

                                                @foreach ($foodType as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($val->food_type) && $val->food_type == $v->id ? 'selected' : '' }}>
                                                    {{ $v->type_name }}
                                                </option>
                                                @endforeach

                                            </select>
                                        </td>
                                        <td>
                                            <button type="button" class="btn btn-info btn-update" data-id="{{ $val->id }}">Update</button>
                                        </td>
                                        <input type="hidden" name="id[]" value="{{ $val->id }}">
                                    </tr>
                                    @endforeach

                                </tbody>
                                <tr>
                                    <!-- <td colspan="11">

                                    </td> -->
                                </tr>
                            </table>
                        </form>
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!--/.col (left) -->
            <!-- right column -->
            <div class="col-md-6">

            </div>
            <!--/.col (right) -->
        </div>
        <!-- /.row -->
    </div><!-- /.container-fluid -->
</section>
<!-- /.content -->
@endsection

@push('scripts')
<script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>


<script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>

<script>
    $(function() {
        $("#category_id").change(function() {

            if ($(this).val()) {

                var cat_id = $(this).val();

                var url = "{{ route('product.get_product', ':id') }}";
                url = url.replace(':id', cat_id);

                var jqxhr = $.get(url, function(data) {
                        if (!data) {
                            alert('No Product found!');
                        }
                    })
                    .done(function(data) {
                        var rows = data.rows;
                        $("#product_id").html(rows);

                    })
                    .fail(function() {

                    })
                    .always(function() {

                    });

                jqxhr.always(function() {

                });


            }

        });


        $('#formdate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('#todate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('.select2').select2()

        $('.select2bs4').select2({
            theme: 'bootstrap4'
        })


        $("#example1").DataTable({
            "responsive": true,
            "lengthChange": false,
            "autoWidth": false,
            "paging": false,
            buttons: [{
                    extend: 'excel',
                    title: 'Product List'
                },
                {
                    extend: 'pdf',
                    title: 'Product List'
                },
                {
                    extend: 'print',
                    title: 'Product List'
                },
                'colvis'
            ]

        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

        $('#example2').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });


        $(document).on('click', '.btn-update', function() {
            var row = $(this).closest('tr'); // current row
            var id = $(this).data('id');

            // Collect data from inputs/selects
            var price = row.find('input[name="price[]"]').val();
            var scharge = row.find('input[name="scharge[]"]').val();
            var vat = row.find('input[name="vat_status[]"]').val();
            var sd = row.find('input[name="sd_status[]"]').val();
            var dis = row.find('select[name="dis_status[]"]').val();
            var type = row.find('select[name="type_id[]"]').val();

            // Send AJAX request
            $.ajax({
                url: "{{ route('product.update_single') }}",
                type: "POST",
                data: {
                    _token: "{{ csrf_token() }}",
                    id: id,
                    price: price,
                    scharge: scharge,
                    vat_status: vat,
                    sd_status: sd,
                    dis_status: dis,
                    type_id: type
                },
                success: function(response) {
                    if (response.success) {
                        row.css('background-color', '#d4edda'); // highlight success
                        row.addClass('updated-row'); // optional: add a class for future CSS
                        alert('Product updated successfully!');
                    } else {
                        alert('Update failed!');
                    }
                },
                error: function(xhr) {
                    alert('Something went wrong!');
                }
            });
        });


    });
</script>
@endpush