@extends('layouts.app')
@section('title', __('re_order.edit'))

@php
    use App\Product;
    use App\StockReOrderProducts;
    use Illuminate\Support\Facades\DB;
@endphp

@section('content')
    <style>
        .table-responsive {
            width: 100%;
            height: 500px;
            overflow-y: auto;
            overflow-x: auto;
        }

        table {
            width: 100%;
            border-collapse: collapse;
        }

        thead th {
            position: sticky;
            top: 0;
            background-color: #2fb3a1;
            box-shadow: 0 2px 2px -1px rgba(0, 0, 0, 0.4);
        }

        tbody tr:nth-child(even) {
            background-color: #f2f2f2;
        }

        th,
        td {
            text-align: left;
            padding: 8px;
            border: 1px solid #ddd;
        }
    </style>
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <br>
        <h1>@lang('re_order.edit')</h1>
    </section>

    <!-- Main content -->
    <section class="content no-print">
        {!! Form::open([
            'url' => action('StockReOrderController@update', [$stock_re_order->id]),
            'method' => 'put',
            'id' => 'stock_re_order_form',
        ]) !!}
        <div class="box box-solid">
            <div class="box-body">
                <div class="row">
                    <div class="col-sm-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            {{-- {!! Form::select('select_location_id', $business_locations, $stock_re_order->location_from, [
                                'class' => 'form-control select2',
                                'id' => 'select_location_id',
                                'disabled',
                                'required',
                            ]) !!} --}}
                            <select class="form-control select2" name="select_location_id" id="select_location_id" disabled>
                                @foreach ($business_locations as $business_location)
                                    @if ($stock_re_order->location_from == $business_location->id)
                                        <option value="{{ $business_location->id }}" selected>{{ $business_location->name }}
                                            ({{ $business_location->location_id }})
                                        </option>
                                    @endif
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-sm-3">
                        <div class="form-group">
                            {!! Form::label('ref_no', __('purchase.ref_no') . ':') !!}
                            @show_tooltip(__('lang_v1.leave_empty_to_autogenerate'))
                            {!! Form::text('ref_no', $stock_re_order->re_order_ref, ['class' => 'form-control']) !!}
                        </div>
                    </div>
                    <div class="col-sm-3">
                        <div class="form-group">
                            {!! Form::label('transaction_date', __('messages.date') . ':*') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-calendar"></i>
                                </span>
                                {!! Form::text('transaction_date', @format_datetime($stock_re_order->re_order_date), [
                                    'class' => 'form-control',
                                    'readonly',
                                    'required',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <div class="col-sm-3">
                        <div class="form-group">
                            {!! Form::label('re_order_status', __('re_order.status') . ':') !!}
                            {!! Form::select('re_order_status', $re_order_status, $stock_re_order->re_order_status, [
                                'class' => 'form-control select2',
                                'id' => 're_order_status',
                            ]) !!}
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--box end-->
        <div class="box box-solid">
            <div class="box-header">
                <h3 class="box-title">{{ __('stock_adjustment.search_products') }}</h3>
            </div>
            <div class="box-body">
                <div class="row">
                    <div class="col-sm-4 col-sm-offset-2 @if (!session('business.enable_brand')) hide @endif">
                        <div class="form-group">
                            {!! Form::select('brand_id', $brands, null, [
                                'placeholder' => 'Select Brand',
                                'class' => 'form-control select2 brand_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-sm-4 @if (!session('business.enable_category')) hide @endif">
                        <div class="form-group">
                            {!! Form::select('category_id', $categories, null, [
                                'placeholder' => 'Select Category',
                                'class' => 'form-control select2 category_id',
                            ]) !!}
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="col-sm-8 col-sm-offset-2">
                        <div class="form-group">
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-search"></i>
                                </span>
                                {!! Form::text('search_product', null, [
                                    'class' => 'form-control',
                                    'id' => 'search_product_for_stock_reorder',
                                    'placeholder' => __('re_order.search_product'),
                                    'autofocus',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="col-sm-12">
                        <input type="hidden" id="location_count" value="{{ count($locations_for_table_headers) - 1 }}">
                        <input type="hidden" id="total_amount" name="final_total" value="0">
                        <div class="table-responsive">
                            <table class="table table-bordered table-striped table-condensed"
                                id="stock_reorder_product_table">
                                <thead>
                                    <tr class="bg-green">
                                        <th class="col-sm-4 text-center"
                                            style="position: sticky;
                                        top: 0;
                                        z-index: 999;">
                                            @lang('sale.product')
                                        </th>
                                        <th class="col-sm-2 text-center"
                                            style="position: sticky;
                                        top: 0;
                                        z-index: 999;">
                                            @lang('re_order.current_stock')
                                        </th>
                                        @foreach ($locations_for_table_headers as $business_location)
                                            @if ($is_admin)
                                                @if ($stock_re_order->location_from != $business_location->id)
                                                    <th class="col-sm-2 text-center"
                                                        style="position: sticky;
                                                top: 0;
                                                z-index: 999;">
                                                        {{ $business_location->name }}
                                                @endif
                                                </th>
                                            @else
                                                <th class="col-sm-2 text-center"
                                                    style="position: sticky;
                                                top: 0;
                                                z-index: 999;">
                                                    {{ $business_location->location->name }}
                                                </th>
                                            @endif
                                        @endforeach
                                        <th class="col-sm-2 text-center"
                                            style="position: sticky;
                                        top: 0;
                                        z-index: 999;">
                                            <i class="fa fa-trash" aria-hidden="true"></i>
                                        </th>
                                        <th hidden
                                            style="position: sticky;
                                        top: 0;
                                        z-index: 999;">
                                            #</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($order_product_groups as $product)
                                        <tr>
                                            @php
                                                $main_product = DB::table('product_locations')
                                                    ->where('product_id', $product->product_id)
                                                    ->where('location_id', $stock_re_order->location_from)
                                                    ->first();

                                                $total_re_order_qty = StockReOrderProducts::where(
                                                    're_order_id',
                                                    $stock_re_order->id,
                                                )
                                                    ->where('product_id', $product->product_id)
                                                    ->where('variation_id', $product->variation_id)
                                                    ->sum('re_order_quantity');
                                                $av_qty = App\VariationLocationDetails::where(
                                                    'product_id',
                                                    $product->product_id,
                                                )
                                                    ->where('variation_id', $product->variation_id)
                                                    ->where('location_id', $stock_re_order->location_from)
                                                    ->first();
                                            @endphp
                                            <td>
                                                <span id="span_prodcut_name">{{ $product->product_name }}
                                                    ({{ $product->sub_sku }})</span>
                                                <br>
                                                <small><strong>Re-order level:</strong>
                                                    {{ $main_product->product_re_order_level }}
                                                    {{ $product->unit }}</small>
                                                <input type="hidden" name="" id="product_id"
                                                    value="{{ $product->product_id }}">
                                                <input type="hidden" name="" id="variation_id"
                                                    value="{{ $product->variation_id }}">
                                                <input type="hidden" name="" id="location_from_current_stock"
                                                    value="{{ $av_qty->qty_available }}">
                                                <input type="hidden" class="form-control" name=""
                                                    id="re_order_level" value="{{ $main_product->product_re_order_level }}"
                                                    disabled>
                                            </td>
                                            <td>
                                                <span
                                                    class="qty_available_column">{{ number_format($av_qty->qty_available - $total_re_order_qty, 2) }}</span>
                                                <span>{{ $product->unit }}</span>
                                            </td>
                                            @php
                                                $StockReOrderProducts = StockReOrderProducts::where(
                                                    'stock_re_order_products.re_order_id',
                                                    $stock_re_order->id,
                                                )
                                                    ->where(
                                                        'stock_re_order_products.variation_id',
                                                        $product->variation_id,
                                                    )
                                                    ->join(
                                                        'business_locations',
                                                        'stock_re_order_products.location_id',
                                                        '=',
                                                        'business_locations.id',
                                                    )
                                                    ->orderBy('stock_re_order_products.id', 'ASC')
                                                    ->get();
                                            @endphp
                                            @foreach ($StockReOrderProducts as $product_location)
                                                <td>
                                                    <div class="input-group input-number">
                                                        <span class="input-group-btn"><button type="button"
                                                                class="btn btn-default btn-flat qty_down"><i
                                                                    class="fa fa-minus text-danger"></i></button></span>
                                                        <input type="text" data-min="0"
                                                            class="form-control reorder_quantity input_number mousetrap"
                                                            name="reorder_quantity[]"
                                                            value="{{ number_format($product_location->re_order_quantity, 2) }}"
                                                            style="min-width: 100px;">
                                                        <span class="input-group-btn"><button type="button"
                                                                class="btn btn-default btn-flat qty_up"><i
                                                                    class="fa fa-plus text-success"></i></button></span>
                                                    </div>
                                                    @php
                                                        $qty_available = Product::leftJoin(
                                                            'variation_location_details as VLD',
                                                            'VLD.product_id',
                                                            '=',
                                                            'products.id',
                                                        )
                                                            ->where('VLD.product_id', $product->product_id)
                                                            ->where('VLD.location_id', $product_location->id)
                                                            ->sum('VLD.qty_available');

                                                        $product_has_location = DB::table('product_locations')
                                                            ->where('product_id', $product->product_id)
                                                            ->where('location_id', $product_location->id)
                                                            ->first();

                                                        $total_curr_stock =
                                                            $qty_available + $product_location->re_order_quantity;

                                                        $color = 'red';
                                                        if (!empty($product_location->product_max_order_level)) {
                                                            $product_max_order_level =
                                                                $product_location->product_max_order_level;
                                                        } else {
                                                            $product_max_order_level = 0;
                                                        }
                                                        if (!empty($product_location->product_re_order_level)) {
                                                            $product_re_order_level =
                                                                $product_location->product_re_order_level;
                                                        } else {
                                                            $product_re_order_level = 0;
                                                        }

                                                        if (
                                                            $total_curr_stock <= $product_max_order_level &&
                                                            $total_curr_stock >= $product_re_order_level
                                                        ) {
                                                            $color = 'green';
                                                        }
                                                    @endphp

                                                    <input type="hidden" id="previous_quantity"
                                                        value="{{ number_format($qty_available, 2) }}">

                                                    <small class="text_color"
                                                        style="font-weight: bold; color: {{ $color }}"><strong>Current
                                                            Stock:</strong>
                                                        {{ number_format($total_curr_stock, 2) }}
                                                        {{ $product->unit }}</small>
                                                    <br>
                                                    <small><strong>Re-order level:</strong>
                                                        <span class="span_re_order_level">
                                                            @if (!empty($product_has_location->product_re_order_level))
                                                                {{ $product_has_location->product_re_order_level }}
                                                            @endif
                                                        </span>
                                                        {{ $product->unit }}</small>
                                                    <br>
                                                    <small><strong>Max-order level:</strong> <span
                                                            class="span_max_order_level">
                                                            @if (!empty($product_has_location->product_max_order_level))
                                                                {{ $product_has_location->product_max_order_level }}
                                                            @endif
                                                        </span>
                                                        {{ $product->unit }}</small>
                                                    <br>

                                                    @php
                                                        $requirement = 0;

                                                        if ($product_re_order_level > $qty_available) {
                                                            $requirement =
                                                                $product_re_order_level -
                                                                $qty_available -
                                                                $product_location->re_order_quantity;
                                                        }
                                                    @endphp
                                                    <small><strong>Requirement:</strong>
                                                        {{ number_format($requirement, 2) }}
                                                        {{ $product->unit }}
                                                    </small>
                                                    <input type="hidden" name="location_id[]" id=""
                                                        value="{{ $product_location->id }}">
                                                    <input type="hidden" name="product_id[]"
                                                        value="{{ $product->product_id }}">
                                                    <input type="hidden" name="variation_id[]"
                                                        value="{{ $product->variation_id }}">
                                                    <input type="hidden" name="last_purchased_price[]" id=""
                                                        value="{{ $product_location->last_purchase_price }}">
                                                </td>

                                                @php
                                                    // $maximum_release = 0;
                                                    // $maximum_release =
                                                    //     $product->qty_available - $main_product->product_re_order_level;
                                                    $total_reorder_quantity = StockReOrderProducts::where(
                                                        'stock_re_order_products.re_order_id',
                                                        $stock_re_order->id,
                                                    )
                                                        ->where(
                                                            'stock_re_order_products.variation_id',
                                                            $product->variation_id,
                                                        )
                                                        ->sum('re_order_quantity');
                                                @endphp
                                            @endforeach
                                            <td class="text-center">
                                                <i class="fa fa-trash remove_product_row cursor-pointer"
                                                    aria-hidden="true"></i>
                                            </td>
                                            <td>
                                                {{-- <input type="hidden" id="row_valid"
                                                    value="@if ($main_product->product_re_order_level > $product->qty_available || $total_reorder_quantity > $maximum_release) 0 @else 1 @endif"> --}}
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <br><br>
                <div class="row action_area">
                    {!! Form::hidden('is_save_and_print_1', 0, ['id' => 'is_save_and_print_1']) !!}
                    {!! Form::hidden('is_save_and_print_2', 0, ['id' => 'is_save_and_print_2']) !!}
                    <div class="col-sm-12 text-center">
                        <button type="button" id="submit-form"
                            class="btn btn-primary btn-big">@lang('messages.save')</button>
                        <button type="button" id="save-and-print_1" class="btn btn-success btn-big print-invoice">Save
                            and
                            print 1</button>
                        <button type="button" id="save-and-print_2" class="btn btn-success btn-big print-invoice">Save
                            and
                            print 2</button>
                    </div>
                </div>
                <div class="row redirect_area hide">
                    <div class="col-sm-12 text-center">
                        <a href="{{ action('StockReOrderController@index') }}" class="btn btn-primary btn-big">Go
                            Back</a>
                    </div>
                </div>
            </div>
        </div>
        <!--box end-->
        {!! Form::close() !!}
    </section>
    <!-- This will be printed -->
    <section class="invoice print_section" id="receipt_section">
    </section>
@stop
@section('javascript')
    <script src="{{ asset('js/stock_reorder.js?v=' . $asset_v) }}"></script>
    <script type="text/javascript">
        $(document).ready(function() {
            __page_leave_confirmation('#stock_re_order_form');
        });
    </script>
@endsection