@extends('layouts.app', ['stock_report' => true])

@section('title', __('Stock Report '))

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>{{ __('report.stock_report') }}</h1>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    {!! Form::open([
                        'url' => action('ReportController@getNewStockReport'),
                        'method' => 'get',
                        'id' => '',
                    ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            {!! Form::select('location_id', $business_locations, null, [
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('category_id', __('category.category') . ':') !!}
                            {!! Form::select('category', $categories, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'category_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('sub_category_id', __('product.sub_category') . ':') !!}
                            {!! Form::select('sub_category', [], null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'sub_category_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('brand', __('product.brand') . ':') !!}
                            {!! Form::select('brand', $brands, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('active_state', 'Active Status:') !!}
                            <select class="form-control select2" name="active_state" id="active_state">
                                <option value="">All</option>
                                <option value="active" selected>Active</option>
                                <option value="inactive" {{ request()->input('active_state') == 'inactive' ? 'selected' : '' }}>
                                    Inactive</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('unit', __('product.unit') . ':') !!}
                            {!! Form::select('unit', $units, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Product Search</label>
                            <div class="input-group input-group-sm">
                                <input id="product_list_filter_product_search" name="product_list_filter_product_search"
                                    value="" type="text" class="form-control">
                                <span class="input-group-btn">
                                    <button id="product_search_button" type="button" class="btn btn-info btn-flat"><i
                                            class="fa fa-search"></i></button>
                                </span>
                            </div>
                            <!-- /input-group -->
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Show entries</label>
                            <select class="form-control select2" name="per_page" id="per_page">
                                <option value="10" {{ request()->input('per_page') == 10 ? 'selected' : '' }}>10</option>
                                <option value="50" {{ request()->input('per_page') == 50 ? 'selected' : '' }}>50</option>
                                <option value="100" {{ request()->input('per_page') == 100 ? 'selected' : '' }}>100</option>
                            </select>
                        </div>
                    </div>
                    @if ($show_manufacturing_data)
                        <div class="col-md-3">
                            <div class="form-group">
                                <br>
                                <div class="checkbox">
                                    <label>
                                        {!! Form::checkbox('only_mfg', 1, false, ['class' => 'input-icheck', 'id' => 'only_mfg_products']) !!} {{ __('manufacturing::lang.only_mfg_products') }}
                                    </label>
                                </div>
                            </div>
                        </div>
                    @endif
                </div>

                <button type="submit" class="btn bg-blue submit_product_form"
                    style="margin-left: 40px;">@lang('Filter')</button>
                <a href="{{ url('/new/stock-report') }}" class="btn bg-maroon" style="margin-left: 10px;">
                    @lang('Reset')
                </a>

                {!! Form::close() !!}
            @endcomponent
        </div>
        @can('view_product_stock_value')
            <div class="row">
                <div class="col-md-12">
                    @component('components.widget', ['class' => 'box-solid'])
                        <table class="table no-border">
                            <tr>
                                <td>@lang('report.closing_stock') (@lang('lang_v1.by_purchase_price'))</td>
                                <td>@lang('report.closing_stock') (@lang('lang_v1.by_sale_price'))</td>
                                <td>@lang('lang_v1.potential_profit')</td>
                                <td>@lang('lang_v1.profit_margin')</td>
                            </tr>
                            <tr>
                                <td>
                                    <h3 id="closing_stock_by_pp" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    <h3 id="closing_stock_by_sp" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    <h3 id="potential_profit" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    <h3 id="profit_margin" class="mb-0 mt-0"></h3>
                                </td>
                            </tr>
                        </table>
                    @endcomponent
                </div>
            </div>
        @endcan
        <div class="row">
            <div class="col-md-12">
                @component('components.widget', ['class' => 'box-solid'])
                    <div class="row">
                        <div class="col-md-12">
                            <table class="table table-bordered table-striped" id="stock_report_table">
                                <thead>
                                    <tr>
                                        <th>SKU</th>
                                        <th>@lang('business.product')</th>
                                        <th>@lang('product.category')</th>
                                        <th>@lang('sale.location')</th>
                                        <th>@lang('purchase.unit_selling_price')</th>
                                        <th>@lang('report.current_stock')</th>
                                        @can('view_product_stock_value')
                                            <th class="stock_price">@lang('lang_v1.total_stock_price') <br>
                                                <small>(@lang('lang_v1.by_purchase_price'))</small>
                                            </th>
                                            <th>@lang('lang_v1.total_stock_price') <br>
                                                <small>(@lang('lang_v1.by_sale_price'))</small>
                                            </th>
                                            <th>@lang('lang_v1.potential_profit')</th>
                                        @endcan
                                        <th>@lang('report.total_unit_sold')</th>
                                        <th>@lang('lang_v1.total_unit_transfered')</th>
                                        <th>@lang('lang_v1.total_unit_adjusted')</th>
                                        @if ($show_manufacturing_data)
                                            <th class="current_stock_mfg">@lang('manufacturing::lang.current_stock_mfg')
                                                @show_tooltip(__('manufacturing::lang.mfg_stock_tooltip'))</th>
                                        @endif
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $current_stock = 0;
                                        $total_mfg_stock = 0;
                                        $current_stock_value = 0;
                                        $stock_price = 0;
                                        $current_stock_sell_value = 0;
                                        $total_potential_profit = 0;
                                        $total_total_sold = 0;
                                        $total_total_transfered = 0;
                                        $total_total_adjusted = 0;
                                    @endphp
                                    @foreach ($products as $product)
                                        <tr>
                                            <td>{{ $product->sku }}</td>
                                            <td>{{ $product->category_name }}</td>
                                            <td>{{ $product->category }}</td>
                                            <td>{{ $product->location_name }}</td>
                                            <td>{{ $transactionUtil->num_f($product->unit_price) }}</br>
                                                <button type="button" class="btn btn-primary btn-xs btn-modal no-print"
                                                    data-container=".view_modal"
                                                    data-href="{{ action('ProductController@viewGroupPrice', [$product->product_id]) }}">@lang('lang_v1.view_group_prices')
                                                </button>
                                            </td>
                                            <td>{{ $transactionUtil->num_f($product->stock) }} {{ $product->unit }}</td>
                                            @can('view_product_stock_value')
                                                <td>{{ $transactionUtil->num_f($product->stock_price) }}</td>
                                                <td>
                                                    @php
                                                        $stock = $product->stock ? $product->stock : 0;
                                                        $unit_selling_price =
                                                            (float) $product->group_price > 0
                                                                ? $product->group_price
                                                                : $product->unit_price;
                                                        $selling_stock_price = $stock * $unit_selling_price;
                                                    @endphp
                                                    {{ $transactionUtil->num_f($selling_stock_price) }}</td>
                                                <td>
                                                    @php
                                                        $stock = $product->stock ? $product->stock : 0;
                                                        $unit_selling_price =
                                                            (float) $product->group_price > 0
                                                                ? $product->group_price
                                                                : $product->unit_price;
                                                        $stock_price_by_sp = $stock * $unit_selling_price;
                                                        $potential_profit =
                                                            (float) $stock_price_by_sp - (float) $product->stock_price;
                                                    @endphp
                                                    {{ $transactionUtil->num_f($potential_profit) }}</td>
                                            @endcan
                                            <td>{{ $transactionUtil->num_f($product->total_sold) }} {{ $product->unit }}</td>
                                            <td>{{ $transactionUtil->num_f($product->total_transfered) }}
                                                {{ $product->unit }}</td>
                                            <td>{{ $transactionUtil->num_f($product->total_adjusted) }} {{ $product->unit }}
                                            </td>
                                            @if ($show_manufacturing_data)
                                                <td>
                                                    @php
                                                        $total_mfg_stock = 0;
                                                        if ($product->total_mfg_stock) {
                                                            $total_mfg_stock = (float) $product->total_mfg_stock;
                                                        }
                                                    @endphp
                                                    {{ $transactionUtil->num_f($total_mfg_stock) }}</td>
                                            @endif
                                        </tr>
                                        @php
                                            $current_stock += $stock;
                                            $total_mfg_stock += $total_mfg_stock;
                                            $current_stock_value += $stock_price;
                                            $current_stock_sell_value += $selling_stock_price;
                                            $total_potential_profit += $potential_profit;
                                            $total_total_sold += $product->total_sold;
                                            $total_total_transfered += $product->total_transfered;
                                            $total_total_adjusted += $product->total_adjusted;

                                        @endphp
                                    @endforeach
                                </tbody>
                                <tfoot>
                                    <tr class="bg-gray font-17 text-center footer-total">
                                        <td colspan="5"><strong>@lang('sale.total'):</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($current_stock) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($current_stock_value) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($current_stock_sell_value) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($total_potential_profit) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($total_total_sold) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($total_total_transfered) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($total_total_adjusted) }}</strong></td>
                                        <td><strong>{{ $transactionUtil->num_f($total_mfg_stock) }}</strong></td>
                                    </tr>
                                </tfoot>
                            </table>
                            <!-- Pagination -->
                            <div class="d-flex justify-content-between align-items-center mt-3">
                                <div>
                                    Showing {{ $products->firstItem() }} to {{ $products->lastItem() }} of
                                    {{ $products->total() }}
                                    entries
                                </div>
                                <div class="d-flex justify-content-end" style="text-align: right;">
                                    {{ $products->appends(request()->input())->links() }}
                                </div>
                            </div>
                        </div>
                    </div>
                @endcomponent
            </div>
        </div>
    </section>
    <!-- /.content -->

@endsection

@section('javascript')
    <script type="text/javascript">
    </script>

@endsection