@extends('layouts.app')
@section('title', __('lang_v1.product_sell_report'))

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header no-print">
        <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">{{ __('lang_v1.product_sell_report') }}</h1>
    </section>

    <!-- Main content -->
    <section class="content no-print">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    {!! Form::open([
                        'url' => action([\App\Http\Controllers\ReportController::class, 'getStockReport']),
                        'method' => 'get',
                        'id' => 'product_sell_report_form',
                    ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('search_product', __('lang_v1.search_product') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-search"></i>
                                </span>
                                <input type="hidden" value="" id="variation_id">
                                {!! Form::text('search_product', null, [
                                    'class' => 'form-control',
                                    'id' => 'search_product',
                                    'placeholder' => __('lang_v1.search_product_placeholder'),
                                    'autofocus',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('customer_id', __('contact.customer') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-user"></i>
                                </span>
                                {!! Form::select('customer_id', $customers, null, [
                                    'class' => 'form-control select2',
                                    'placeholder' => __('messages.please_select'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('psr_customer_group_id', __('lang_v1.customer_group_name') . ':') !!}
                            {!! Form::select('psr_customer_group_id', $customer_group, null, [
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'psr_customer_group_id',
                            ]) !!}
                        </div>
                    </div>
                    @if (request()->session()->get('business.district') == '1')
                        <div class="col-md-3">
                            <div class="form-group">
                                {!! Form::label('district_id', __('lang_v1.districts') . ':') !!}
                                {!! Form::select('district_id', $districts, null, [
                                    'class' => 'form-control select2',
                                    'id' => 'district_id',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    @endif
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('user_filter', __('report.user') . ':') !!}
                            {!! Form::select('user_filter', $usersFilter, null, [
                                'class' => 'form-control select2',
                                'id' => 'user_filter',
                                'placeholder' => __('lang_v1.all'),
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-map-marker"></i>
                                </span>
                                {!! Form::select('location_id', $business_locations, null, [
                                    'class' => 'form-control select2',
                                    'placeholder' => __('messages.please_select'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('category_id', __('product.category') . ':') !!}
                            {!! Form::select('category_id', $categories, null, [
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'psr_filter_category_id',
                                'placeholder' => __('lang_v1.all'),
                            ]) !!}
                        </div>
                    </div>
                    @if (in_array('drivers', $enabled_modules))
                        <div class="col-md-3">
                            <div class="form-group">
                                {!! Form::label('driver_id', __('lang_v1.drivers') . ':') !!}
                                {!! Form::select('driver_id', $drivers, null, [
                                    'class' => 'form-control select2',
                                    'style' => 'width:100%',
                                    'id' => 'driver_id',
                                    'placeholder' => __('lang_v1.all'),
                                ]) !!}
                            </div>
                        </div>
                    @endif
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('brand_id', __('product.brand') . ':') !!}
                            {!! Form::select('brand_id', $brands, null, [
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'psr_filter_brand_id',
                                'placeholder' => __('lang_v1.all'),
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('product_sr_date_filter', __('report.date_range') . ':') !!}
                            {!! Form::text('date_range', null, [
                                'placeholder' => __('lang_v1.select_a_date_range'),
                                'class' => 'form-control',
                                'id' => 'product_sr_date_filter',
                                'readonly',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        {!! Form::label('product_sr_start_time', __('lang_v1.time_range') . ':') !!}
                        @php
                            $startDay = Carbon::now()->startOfDay();
                            $endDay = $startDay->copy()->endOfDay();
                        @endphp
                        <div class="form-group">
                            {!! Form::text('start_time', @format_time($startDay), [
                                'style' => __('lang_v1.select_a_date_range'),
                                'class' => 'form-control width-50 f-left',
                                'id' => 'product_sr_start_time',
                            ]) !!}
                            {!! Form::text('end_time', @format_time($endDay), [
                                'class' => 'form-control width-50 f-left',
                                'id' => 'product_sr_end_time',
                            ]) !!}
                        </div>
                    </div>
                    {!! Form::close() !!}
                @endcomponent
            </div>
        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="nav-tabs-custom">
                    <ul class="nav nav-tabs">
                        <li class="active">
                            <a href="#psr_detailed_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-list"
                                    aria-hidden="true"></i> @lang('lang_v1.detailed')</a>
                        </li>
                        <li>
                            <a href="#psr_detailed_with_purchase_tab" data-toggle="tab" aria-expanded="true"><i
                                    class="fa fa-list" aria-hidden="true"></i> @lang('lang_v1.detailed_with_purchase')</a>
                        </li>
                        <li>
                            <a href="#psr_grouped_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-bars"
                                    aria-hidden="true"></i> @lang('lang_v1.grouped')</a>
                        </li>
                        <li>
                            <a href="#psr_by_cat_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-bars"
                                    aria-hidden="true"></i> @lang('lang_v1.by_category')</a>
                        </li>
                        <li>
                            <a href="#psr_by_brand_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-bars"
                                    aria-hidden="true"></i> @lang('lang_v1.by_brand')</a>
                        </li>
                    </ul>
                    <div class="tab-content">
                        <div class="tab-pane active" id="psr_detailed_tab">
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped" id="product_sell_report_table">
                                    <thead>
                                        <tr>
                                            <th>@lang('sale.product')</th>

                                            <th>@lang('product.sku')</th>
                                            <th id="psr_product_custom_field1">{{ $product_custom_field1 }}</th>
                                            <th id="psr_product_custom_field2">{{ $product_custom_field2 }}</th>
                                            <th>@lang('sale.customer_name')</th>
                                            @if (request()->session()->get('business.district') == 1)
                                                <th>@lang('lang_v1.district_name')</th>
                                                <th>@lang('lang_v1.district_code')</th>
                                            @endif
                                            <th>@lang('lang_v1.contact_id')</th>
                                            <th>@lang('lang_v1.customer_group')</th>
                                            <th>@lang('sale.invoice_no')</th>
                                            <th>@lang('messages.date')</th>
                                            <th>@lang('sale.qty')</th>
                                            @if (request()->session()->get('business.enable_sub_units') == 1)
                                                <th>@lang('sale.sub_unit')</th>
                                            @endif
                                            <th>@lang('sale.unit_price')</th>
                                            <th>@lang('sale.discount')</th>
                                            <th>@lang('sale.tax')</th>
                                            <th>@lang('sale.price_inc_tax')</th>
                                            <th>@lang('sale.total')</th>
                                            <th>@lang('lang_v1.payment_method')</th>
                                            <th>@lang('lang_v1.created_by')</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr class="bg-gray font-17 footer-total text-center">
                                            <td><strong>@lang('sale.total'):</strong></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            @if (request()->session()->get('business.district') == 1)
                                                <td></td>
                                                <td></td>
                                            @endif
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td id="footer_total_sold"></td>
                                            @if (request()->session()->get('business.enable_sub_units') == 1)
                                                <td class="footer_total_stock_sub_unit"></td>
                                            @endif
                                            <td></td>
                                            <td></td>
                                            <td id="footer_tax"></td>
                                            <td></td>
                                            <td><span class="display_currency" id="footer_subtotal"
                                                    data-currency_symbol ="true"></span></td>
                                            <td></td>
                                            <td></td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        <div class="tab-pane" id="psr_detailed_with_purchase_tab">
                            <div class="table-responsive">
                                @if (session('business.enable_lot_number'))
                                    <input type="hidden" id="lot_enabled">
                                @endif
                                <table class="table table-bordered table-striped"
                                    id="product_sell_report_with_purchase_table" style="width: 100%;">
                                    <thead>
                                        <tr>
                                            <th>@lang('sale.product')</th>
                                            <th>@lang('product.sku')</th>
                                            <th>@lang('sale.customer_name')</th>
                                            @if (request()->session()->get('business.district') == 1)
                                                <th>@lang('lang_v1.district_name')</th>
                                                <th>@lang('lang_v1.district_code')</th>
                                            @endif
                                            <th>@lang('sale.invoice_no')</th>
                                            <th>@lang('messages.date')</th>
                                            <th>@lang('lang_v1.purchase_ref_no')</th>
                                            <th>@lang('lang_v1.lot_number')</th>
                                            <th>@lang('lang_v1.supplier_name')</th>
                                            <th>@lang('sale.qty')</th>
                                            @if (request()->session()->get('business.enable_sub_units') == 1)
                                                <th>@lang('sale.sub_unit')</th>
                                            @endif
                                            <th>@lang('lang_v1.created_by')</th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>

                        <div class="tab-pane" id="psr_grouped_tab">
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped" id="product_sell_grouped_report_table"
                                    style="width: 100%;">
                                    <thead>
                                        <tr>
                                            <th>@lang('sale.product')</th>
                                            <th>@lang('product.sku')</th>
                                            <th>@lang('lang_v1.product_image')</th>

                                            <th>@lang('report.current_stock')</th>
                                            <th>@lang('report.total_unit_sold')</th>
                                            @if (request()->session()->get('business.enable_sub_units') == 1)
                                                <th>@lang('sale.sub_unit')</th>
                                            @endif
                                            <th>@lang('sale.total')</th>
                                            @if (request()->session()->get('business.enable_product_custom_fields') == 1)
                                                <th>@lang('sale.custom_field_1')</th>
                                                <th>@lang('sale.custom_field_2')</th>
                                                <th>@lang('sale.custom_field_3')</th>
                                                <th>@lang('sale.custom_field_4')</th>
                                            @endif
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr class="bg-gray font-17 footer-total text-center">
                                            <td><strong>@lang('sale.total'):</strong></td>
                                            <td></td>

                                            <td></td>
                                            <td></td>
                                            <td id="footer_total_grouped_sold"></td>
                                            @if (request()->session()->get('business.enable_sub_units') == 1)
                                                <td class="footer_total_stock_sub_unit_sold"></td>
                                            @endif
                                            <td><span class="display_currency" id="footer_grouped_subtotal"
                                                    data-currency_symbol ="true"></span></td>
                                            @if (request()->session()->get('business.enable_product_custom_fields') == 1)
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                            @endif
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        @include('report.partials.product_sell_report_by_category')

                        @include('report.partials.product_sell_report_by_brand')
                    </div>
                </div>
            </div>
        </div>
        <div class="modal fade" id="imageModal" tabindex="-1" role="dialog" aria-hidden="true">
            <div class="modal-dialog modal-dialog-centered modal-lg" role="document">
                <div class="modal-content">
                    <div class="modal-body text-center">
                        <img src="" id="modalImage" class="img-fluid" alt="Product Image">
                    </div>
                </div>
            </div>
        </div>

    </section>
    <!-- /.content -->
    <div class="modal fade view_register" tabindex="-1" role="dialog" aria-labelledby="gridSystemModalLabel">
    </div>

    <!-- مودال Bootstrap -->
    <div class="modal fade" id="stockDetailsModal" tabindex="-1" role="dialog" aria-labelledby="stockDetailsLabel"
        aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="stockDetailsLabel">@lang('lang_v1.stock_details')</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="@lang('messages.close')">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <table class="table table-bordered" id="stock-details-table">
                        <thead>
                            <tr style="background-color: #3498db; color: white;">
                                <th>@lang('lang_v1.location')</th>
                                <th>@lang('lang_v1.qty')</th>
                                <th>@lang('lang_v1.unit')</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td colspan="3" class="text-center">@lang('lang_v1.loading')</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>


@endsection

@section('javascript')
    <script src="{{ asset('js/report.js?v=' . $asset_v) }}"></script>
    <script type="text/javascript">
        $(document).on('click', '.open-image-modal', function(e) {
            e.preventDefault();
            var imageUrl = $(this).data('image');
            $('#modalImage').attr('src', imageUrl);
            $('#imageModal').modal('show');
        });
        ////// stock modal 
        function openStockModal(variationId, productName) {
            $('#stockDetailsLabel').text(productName);
            $('#stock-details-table tbody').html('<tr><td colspan="3" class="text-center">جاري التحميل...</td></tr>');
            $('#stockDetailsModal').modal('show');

            $.get('/get-stock-details/' + variationId, function(data) {
                if (data.length === 0) {
                    $('#stock-details-table tbody').html(
                        '<tr><td colspan="3" class="text-center">لا توجد بيانات</td></tr>');
                    return;
                }

                let rows = '';
                data.forEach(function(row) {
                    rows += `<tr>
                        <td>${row.name}</td>
                        <td>${row.qty}</td>
                        <td>${row.unit}</td>
                    </tr>`;
                });
                $('#stock-details-table tbody').html(rows);
            }).fail(function() {
                $('#stock-details-table tbody').html(
                    '<tr><td colspan="3" class="text-danger text-center">حدث خطأ أثناء التحميل.</td></tr>');
            });
        }


        ///// product stock
        $(document).on('mouseenter', '.product-name-tooltip', function() {
            const variationId = $(this).data('variation-id');
            const el = $(this);

            if (!el.data('loaded')) {
                $.get('/get-stock-details/' + variationId, function(data) {
                    let content = '<div style="direction: rtl; text-align: right;">';
                    data.forEach(d => {
                        content += `<div><strong>${d.name}:</strong> ${d.qty} ${d.unit}</div>`;
                    });
                    content += '</div>';

                    el.tooltip({
                        title: content,
                        html: true,
                        placement: 'left',
                        trigger: 'manual',
                        container: 'body'
                    }).tooltip('show');

                    el.data('loaded', true);
                });
            } else {
                el.tooltip('show');
            }
        });

        $(document).on('mouseleave', '.product-name-tooltip', function() {
            $(this).tooltip('hide');
        });


        $(document).on('mouseleave', '.product-name-tooltip', function() {
            $(this).tooltip('hide');
        });


        //////////////

        $(
            '#product_sell_report_form #location_id, #product_sell_report_form #customer_id, #psr_filter_brand_id, #psr_filter_category_id, #driver_id, #psr_customer_group_id'
        ).change(function() {
            $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab');
        });
        $(document).ready(function() {
            $('a[data-toggle="tab"]').on('shown.bs.tab', function(e) {
                var target = $(e.target).attr('href');
                if (target == '#psr_by_cat_tab') {
                    if (typeof product_sell_report_by_category_datatable == 'undefined') {
                        product_sell_report_by_category_datatable = $(
                            'table#product_sell_report_by_category').DataTable({
                            processing: true,
                            serverSide: true,
                            fixedHeader: false,
                            ajax: {
                                url: '/reports/product-sell-grouped-by',
                                data: function(d) {
                                    var start = '';
                                    var end = '';
                                    var start_time = $('#product_sr_start_time').val();
                                    var end_time = $('#product_sr_end_time').val();
                                    if ($('#product_sr_date_filter').val()) {
                                        start = $('input#product_sr_date_filter')
                                            .data('daterangepicker')
                                            .startDate.format('YYYY-MM-DD');
                                        end = $('input#product_sr_date_filter')
                                            .data('daterangepicker')
                                            .endDate.format('YYYY-MM-DD');

                                        start = moment(start + " " + start_time, "YYYY-MM-DD" +
                                            " " + moment_time_format).format(
                                            'YYYY-MM-DD HH:mm');
                                        end = moment(end + " " + end_time, "YYYY-MM-DD" + " " +
                                            moment_time_format).format('YYYY-MM-DD HH:mm');
                                    }
                                    d.start_date = start;
                                    d.end_date = end;
                                    d.group_by = 'category';
                                    d.category_id = $('select#psr_filter_category_id').val();
                                    d.driver_id = $('select#driver_id').val();
                                    d.brand_id = $('select#psr_filter_brand_id').val();
                                    d.customer_id = $('select#customer_id').val();
                                    d.location_id = $('select#location_id').val();
                                    d.customer_group_id = $('#psr_customer_group_id').val();
                                },
                            },
                            columns: [{
                                    data: 'category_name',
                                    name: 'cat.name'
                                },
                                {
                                    data: 'current_stock',
                                    name: 'current_stock',
                                    searchable: false,
                                    orderable: false
                                },
                                {
                                    data: 'total_qty_sold',
                                    name: 'total_qty_sold',
                                    searchable: false
                                },
                                {
                                    data: 'subtotal',
                                    name: 'subtotal',
                                    searchable: false
                                },
                            ],
                            fnDrawCallback: function(oSettings) {
                                $('#footer_psr_by_cat_total_sell').text(
                                    sum_table_col($('#product_sell_report_by_category'),
                                        'row_subtotal')
                                );
                                $('#footer_psr_by_cat_total_sold').html(
                                    __sum_stock($('#product_sell_report_by_category'),
                                        'sell_qty')
                                );

                                $('#footer_psr_by_cat_total_stock').html(
                                    __sum_stock($('#product_sell_report_by_category'),
                                        'current_stock')
                                );
                                __currency_convert_recursively($(
                                    '#product_sell_report_by_category'));
                            },
                        });
                    } else {
                        product_sell_report_by_category_datatable.ajax.reload();
                    }
                } else if (target == '#psr_by_brand_tab') {
                    if (typeof product_sell_report_by_brand_datatable == 'undefined') {
                        product_sell_report_by_brand_datatable = $('table#product_sell_report_by_brand')
                            .DataTable({
                                processing: true,
                                serverSide: true,
                                fixedHeader: false,
                                ajax: {
                                    url: '/reports/product-sell-grouped-by',
                                    data: function(d) {
                                        var start = '';
                                        var end = '';
                                        var start_time = $('#product_sr_start_time').val();
                                        var end_time = $('#product_sr_end_time').val();
                                        if ($('#product_sr_date_filter').val()) {
                                            start = $('input#product_sr_date_filter')
                                                .data('daterangepicker')
                                                .startDate.format('YYYY-MM-DD');
                                            end = $('input#product_sr_date_filter')
                                                .data('daterangepicker')
                                                .endDate.format('YYYY-MM-DD');

                                            start = moment(start + " " + start_time, "YYYY-MM-DD" +
                                                " " + moment_time_format).format(
                                                'YYYY-MM-DD HH:mm');
                                            end = moment(end + " " + end_time, "YYYY-MM-DD" + " " +
                                                moment_time_format).format('YYYY-MM-DD HH:mm');
                                        }
                                        d.start_date = start;
                                        d.end_date = end;
                                        d.driver_id = $('select#driver_id').val();
                                        d.group_by = 'brand';
                                        d.category_id = $('select#psr_filter_category_id').val();
                                        d.brand_id = $('select#psr_filter_brand_id').val();
                                        d.customer_id = $('select#customer_id').val();
                                        d.location_id = $('select#location_id').val();
                                        d.customer_group_id = $('#psr_customer_group_id').val();
                                    },
                                },
                                columns: [{
                                        data: 'brand_name',
                                        name: 'b.name'
                                    },
                                    {
                                        data: 'current_stock',
                                        name: 'current_stock',
                                        searchable: false,
                                        orderable: false
                                    },
                                    {
                                        data: 'total_qty_sold',
                                        name: 'total_qty_sold',
                                        searchable: false
                                    },
                                    {
                                        data: 'subtotal',
                                        name: 'subtotal',
                                        searchable: false
                                    },
                                ],
                                fnDrawCallback: function(oSettings) {
                                    $('#footer_psr_by_brand_total_sell').text(
                                        sum_table_col($('#product_sell_report_by_brand'),
                                            'row_subtotal')
                                    );
                                    $('#footer_psr_by_brand_total_sold').html(
                                        __sum_stock($('#product_sell_report_by_brand'),
                                            'sell_qty')
                                    );

                                    $('#footer_psr_by_cat_total_stock').html(
                                        __sum_stock($('#product_sell_report_by_brand'),
                                            'current_stock')
                                    );
                                    __currency_convert_recursively($(
                                        '#product_sell_report_by_brand'));
                                },
                            });
                    } else {
                        product_sell_report_by_brand_datatable.ajax.reload();
                    }
                }
            });
        });
    </script>
    <script>
        window.APP_SETTINGS = {
            enableFields: {{ request()->session()->get('business.enable_product_custom_fields') === 1 ? 'true' : 'false' }},
            enableImage: {{ request()->session()->get('business.enable_product_image') == 1 ? 'true' : 'false' }},
            enableTooltip: {{ request()->session()->get('business.enable_product_tooltip') == 1 ? 'true' : 'false' }}

        };
        var enable_sub_units =
        {{ !empty(session('business.enable_sub_units')) ? session('business.enable_sub_units') : 0 }};
        var enable_district = {{ !empty(session('business.district')) ? session('business.district') : 0 }};
    </script>

@endsection