@extends('layouts.app')
@section('title', __('lang_v1.smart_root_discount_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.smart_root_discount_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' => 'smart_root_discount_report_form',
                    ]) !!}
                    <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>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('user_filter', __('report.user') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-user"></i>
                                </span>
                                {!! Form::select('user_filter', $usersFilter, null, [
                                    'class' => 'form-control select2',
                                    'placeholder' => __('report.user'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                     <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('smart_discount_name', __('report.smart_discount_name') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-user"></i>
                                </span>
                                {!! Form::select('smart_discount_name', $smartRootDiscountNames, null, [
                                    'class' => 'form-control select2',
                                    'placeholder' => __('report.smart_discount_name'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                     <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('smart_discount_type', __('report.smart_discount_type') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-user"></i>
                                </span>
                                {!! Form::select('smart_discount_type', $smartRootDiscountTypes, null, [
                                    'class' => 'form-control select2',
                                    'placeholder' => __('report.smart_discount_type'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </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>
                    {!! 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="#srd_detailed_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-list"
                                    aria-hidden="true"></i> @lang('lang_v1.detailed')</a>
                        </li>
                    </ul>
                    <div class="tab-content">
                        <div class="tab-pane active" id="srd_detailed_tab">
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped" id="smart_root_discounts_report_table">
                                    <thead>
                                        <tr>
                                       
                                            <th>@lang('sale.customer_name')</th>
                                            <th>@lang('sale.invoice_no')</th>
                                            <th>@lang('messages.date')</th>
                                                                         
                                             <th>@lang('lang_v1.created_by')</th>
                                             <th>@lang('lang_v1.root_discount_type1')</th>
                                             <th>@lang('lang_v1.root_discount_type2')</th>
                                             <th>@lang('lang_v1.root_discount_type3')</th>
                                            
                                           
                                            <th>@lang('sale.total')</th>
                                            <th>@lang('sale.free_products')</th>
                                            <th>@lang('sale.offer_cost')</th>
                                             <th>@lang('sale.free_products_cost')</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>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td class="footer_total_offer_cost"></td>
                                            <td class="footer_total_free_products_cost"></td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </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>
$(document).ready(function() {
    // Initialize date range picker with proper settings
    $('#product_sr_date_filter').daterangepicker(
        {
            locale: {
                format: moment_date_format,
                applyLabel: 'Apply',
                cancelLabel: 'Clear',
            },
            ranges: dateRangeSettings.ranges, // Use predefined ranges if available
            startDate: moment().startOf('day'),
            endDate: moment().endOf('day'),
            showDropdowns: true,
            alwaysShowCalendars: true,
            autoUpdateInput: false // Important for proper clear functionality
        },
        function(start, end) {
            // This function runs when dates are selected
            $('#product_sr_date_filter').val(
                start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
            );
            reloadSmartRootDiscountReport();
        }
    );

    // Handle clear button
    $('#product_sr_date_filter').on('cancel.daterangepicker', function() {
        $(this).val('');
        reloadSmartRootDiscountReport();
    });

    // Initialize DataTable
    var smart_root_discount_report = $('table#smart_root_discounts_report_table').DataTable({
        processing: true,
        serverSide: true,
        fixedHeader: false,
        aaSorting: [[3, 'desc']], // Sort by date descending (column index 3)
        ajax: {
            url: '/reports/smart-root-discount-report',
            data: function(d) {
                // Get date range values
                var dateRange = $('#product_sr_date_filter').val();
                var start = '';
                var end = '';
                
                if (dateRange) {
                    var dates = dateRange.split(' ~ ');
                    start = moment(dates[0], moment_date_format).format('YYYY-MM-DD');
                    end = moment(dates[1], moment_date_format).format('YYYY-MM-DD');
                }
                
                // Add all filter values to the request
                return {
                    start_date: start,
                    end_date: end,
                    customer_id: $('#customer_id').val(),
                    user_filter: $('#user_filter').val(),
                    customer_group_id: $('#psr_customer_group_id').val(),
                    smart_discount_type: $('#smart_discount_type').val(),
                    smart_discount_name: $('#smart_discount_name').val(),
                };
            }
        },
        columns: [
            { data: 'customer', name: 'c.name' },
            { data: 'invoice_no', name: 't.invoice_no' },
            { data: 'transaction_date', name: 't.transaction_date' },
            { data: 'created_by', name: 'user.username' },
            { data: 'root_discount_type1', name: 't.status_of_smart_root_discount_id' },
            { data: 'root_discount_type2', name: 'transaction_sell_lines.applied_discount_ids_type_two' },
            { data: 'root_discount_type3', name: 'transaction_sell_lines.applied_discount_ids_type_three' },
            { data: 'subtotal', name: 'subtotal', searchable: false },
            { data: 'free_products', name: 'free_products' },
             { data: 'offer_cost', name: 'offer_cost' },
              { data: 'free_products_cost', name: 'free_products_cost' },
        ],
        footerCallback: function(row, data, start, end, display) {
            // This will now use the client-side data to update totals
            calculateFooterTotals(data);
        },
        drawCallback: function(settings) {
            // Make sure footer is always visible
            $('table#smart_root_discounts_report_table tfoot').show();
        }
    });
             // Function to calculate and display footer totals
    function calculateFooterTotals(data) {
        var offerCostTotal = 0;
        var freeProductsCostTotal = 0;

        // Sum up all values
        $.each(data, function(index, row) {
            offerCostTotal += parseCurrency(row.offer_cost);
            freeProductsCostTotal += parseCurrency(row.free_products_cost);
        });

        // Update footer cells
        $('.footer_total_offer_cost').html(formatCurrency(offerCostTotal));
        $('.footer_total_free_products_cost').html(formatCurrency(freeProductsCostTotal));
    }

    // Enhanced currency parsing function
    function parseCurrency(value) {
        if (value === null || typeof value === 'undefined') return 0;
        if (typeof value === 'number') return value;
        
        // Handle string values
        var strValue = value.toString().trim();
        
        // Remove all non-numeric characters except decimal point and minus
        var numericString = strValue.replace(/[^0-9.-]/g, '');
        
        // Parse to float
        var num = parseFloat(numericString);
        
        // Return 0 if parsing fails
        return isNaN(num) ? 0 : num;
    }

    // Enhanced currency formatting function
    function formatCurrency(amount) {
        var num = typeof amount === 'number' ? amount : parseFloat(amount) || 0;
        return num.toLocaleString(undefined, {
            minimumFractionDigits: 2,
            maximumFractionDigits: 2
        });
    }

     

    // Function to reload the report
    function reloadSmartRootDiscountReport() {
        smart_root_discount_report.ajax.reload();
    }

    // Handle filter changes
    $('#customer_id, #psr_customer_group_id, #user_filter , #smart_discount_type , #smart_discount_name').change(function() {
        reloadSmartRootDiscountReport();
    });

    // Prevent form submission
    $('#smart_root_discount_report_form').on('submit', function(e) {
        e.preventDefault();
        reloadSmartRootDiscountReport();
    });
});
</script>
   

@endsection