@extends('layouts.master')
@section('style')
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ion-rangeslider/2.3.1/css/ion.rangeSlider.min.css" />
    <style>
        .select2-container--bootstrap5 .select2-selection--single.form-select-solid .select2-selection__placeholder {
            color: white !important;
        }

        .select2-container--bootstrap5 .select2-selection--single.form-select-solid .select2-selection__rendered {
            color: white !important;
        }

        /* ion range slider */
        .irs--flat.irs-with-grid {
            width: 180px !important;
        }

        .irs--flat .irs-from,
        .irs--flat .irs-to,
        .irs--flat .irs-single,
        .irs--flat .irs-bar,
        .irs--flat .irs-handle>i:first-child,
        .irs--flat .irs-from:before,
        .irs--flat .irs-to:before,
        .irs--flat .irs-single:before {
            background-color: var(--bs-primary) !important;
        }

        .irs--flat .irs-from:before,
        .irs--flat .irs-to:before,
        .irs--flat .irs-single:before {
            border-top-color: var(--bs-primary) !important;
        }

        .th-primary {
            background-color: #007bff !important; /* Bootstrap primary blue color */
            color: white !important; /* Text color to white */
           
        }
    </style>
@endsection
@section('content')
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <div id="kt_content_container" class="container-xxl">
            <div class="flex-lg-row-fluid">
                <div class="d-flex flex-wrap flex-stack pb-7">
                    <div class="d-flex flex-wrap align-items-center my-1">
                        <h3 class="fw-bold me-5 my-1">Daily Pricing
                        </h3>
                    </div>
                </div>

                <form action="" method="GET">
                    <div class="card mb-7" data-select2-id="select2-data-144-uoh6">
                        <div class="card-body" data-select2-id="select2-data-143-nqr2">
                            <div class="d-flex align-items-center">
                                <div class="position-relative w-md-400px me-md-2">
                                    <i
                                        class="ki-outline ki-magnifier fs-3 text-gray-500 position-absolute top-50 translate-middle ms-6"></i>
                                    <input type="text" class="form-control form-control-solid ps-10" name="search"
                                        value="" id="search" placeholder="Search">
                                </div>
                                <div class="d-flex align-items-center">
                                    <button type="button" id="submit"
                                        class="btn btn-primary btn-sm me-5" onclick="changeExport()">Search</button>
                                    <button type="button" id="clear" class="btn btn-primary btn-sm me-5">Clear</button>
                                    <a href="javascript:void(0);" id="kt_horizontal_search_advanced_link"
                                        class="btn btn-primary btn-sm me-5" data-bs-toggle="collapse"
                                        data-bs-target="#kt_advanced_search_form">Advanced Search</a>
                                    <a href="{{ route('carrierPricing.newIndex') }}"
                                        class="btn btn-primary btn-sm me-5">Vertical Layout</a>
                                    <a href="https://app.tmdashboard.com/price-search.php"
                                        class="btn btn-primary btn-sm me-5" target="_blank">Mobile search</a>
                                    <a href="https://app.tmdashboard.com/email_pricelist.php?email={{ getAuthMemberInfo()->email ?? '' }}"
                                        class="btn btn-primary btn-sm me-5 d-none" target="_blank">Email Alerts</a>
                                </div>
                            </div>

                            <div class="float-end mt-5">
                                <select name="downloadOptions"
                                    id="downloadOptions"class="form-select form-select-solid form-select-sm bg-primary"
                                    data-control="select2" data-hide-search="true" data-placeholder="Export">
                                    <option value="">Export</option>
                                    <option value="excel">Excel</option>
                                    <option value="csv">CSV</option>
                                    <option value="print">Print</option>
                                    <option value="reset">Reset</option>
                                    <option value="reload">Reload</option>
                                </select>
                            </div>

                            <div class="collapse" id="kt_advanced_search_form"
                                data-select2-id="select2-data-kt_advanced_search_form" style="">
                                <div class="separator separator-dashed mt-20 mb-6">

                                </div>
                                <div class="row g-12" data-select2-id="select2-data-142-0d2j">
                                    <div class="col-xxl-12">
                                        <div class="row g-12">
                                            <div class="col-lg-3 mt-2">
                                                <label class="fs-6 form-label fw-bold text-gray-900">DATE</label>
                                                <div id="range" class="form-control"
                                                    style="background: #fff; cursor: pointer; border: 1px solid #ccc; width: 100%">
                                                    <i class="fa fa-calendar"></i>&nbsp;
                                                    <span></span> <i class="fa fa-caret-down"></i>
                                                </div>
                                                <input type="hidden" class="form-control sm" name="start_date"
                                                    id="start_date">
                                                <input type="hidden" class="form-control sm" name="end_date"
                                                    id="end_date">
                                            </div>
                                            <div class="col-lg-3 mt-2">
                                                <label class="fs-6 form-label fw-bold text-gray-900">STORE NUM</label>
                                                <input type="text" class="form-control form-control form-control-solid"
                                                    name="STORE_NUM" id="STORE_NUM" value="">
                                            </div>
                                            <div class="col-lg-3 mt-2">
                                                <label class="fs-6 form-label fw-bold text-gray-900">State</label>
                                                <select class="form-select form-select-solid" data-control="select2"
                                                    data-hide-search="true" data-placeholder="Select a State" name="ST"
                                                    id="ST" multiple>
                                                    <option value="">Select State</option>
                                                    @php
                                                        $states = [
                                                            'AL',
                                                            'AK',
                                                            'AZ',
                                                            'AR',
                                                            'CA',
                                                            'CO',
                                                            'CT',
                                                            'DE',
                                                            'FL',
                                                            'GA',
                                                            'HI',
                                                            'ID',
                                                            'IL',
                                                            'IN',
                                                            'IA',
                                                            'KS',
                                                            'KY',
                                                            'LA',
                                                            'ME',
                                                            'MD',
                                                            'MA',
                                                            'MI',
                                                            'MN',
                                                            'MS',
                                                            'MO',
                                                            'MT',
                                                            'NE',
                                                            'NV',
                                                            'NH',
                                                            'NJ',
                                                            'NM',
                                                            'NY',
                                                            'NC',
                                                            'ND',
                                                            'OH',
                                                            'OK',
                                                            'OR',
                                                            'PA',
                                                            'RI',
                                                            'SC',
                                                            'SD',
                                                            'TN',
                                                            'TX',
                                                            'UT',
                                                            'VT',
                                                            'VA',
                                                            'WA',
                                                            'WV',
                                                            'WI',
                                                            'WY',
                                                        ];
                                                    @endphp

                                                    @foreach ($states as $state)
                                                        <option value="{{ $state }}">{{ $state }}</option>
                                                    @endforeach()
                                                </select>
                                            </div>
                                            <div class="col-lg-3 mt-2">
                                                <label class="fs-6 form-label fw-bold text-gray-900">TYPE</label>
                                                <select class="form-select form-control form-control-solid" name="TYPE"
                                                    id="TYPE" data-control="select2" data-hide-search="true"
                                                    data-placeholder="Select a TYPE" multiple>
                                                    <option value="">Select TYPE</option>
                                                    <option value="TA">TA</option>
                                                    <option value="PILOT">PILOT</option>
                                                </select>
                                            </div>
                                            <div class="col-lg-3 mt-5 mb-5">
                                                <label class="fs-6 form-label fw-bold text-gray-900">Discount</label>
                                                <div id="example">
                                                    <input type="hidden" id="from" step="0.001" name="from"
                                                        value="0.000">
                                                    <input type="hidden" id="to" name="to" step="0.001"
                                                        value="2.000">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </form>
                <h3 class="text-danger mb-5" style="text-align: center">RETAIL FUEL PRICES SUBJECT TO CHANGE</h3>
                <div class="tab-content">
                    <div id="kt_project_users_table_pane" class="tab-pane fade show active">
                        <div class="card card-flush">
                            <div class="pt-0">
                                <div class="table-responsive p-5">
                                       <div class="mb-15">
                                       <table class="table table-bordered fw-bold mt-5 mb-10" style="border: 1px solid black;" id="tableCount">
                                            <thead class="table-dark">
                                                <tr>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.10+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.20+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.30+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.40+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.50+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.60+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.70+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.80+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">0.90+</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary">1.0+</th>
                                                </tr>
                                               
                                            </thead>
                                            <tfoot  align="right" >    
                                                <tr>                                                
                                                    <td id = 'rebate2_0_10_plus_avg'></td>
                                                    <td id = 'rebate2_0_20_plus_avg'></td>
                                                    <td id = 'rebate2_0_30_plus_avg'></td>
                                                    <td id = 'rebate2_0_40_plus_avg'></td>
                                                    <td id = 'rebate2_0_50_plus_avg'></td>
                                                    <td id = 'rebate2_0_60_plus_avg'></td>
                                                    <td id = 'rebate2_0_70_plus_avg'></td>
                                                    <td id = 'rebate2_0_80_plus_avg'></td>
                                                    <td id = 'rebate2_0_90_plus_avg'></td>
                                                    <td id = 'rebate2_1_10_plus_avg'></td>
                                                </tr> 
                                                <tr class="table-dark">
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary" colspan="5" id="">Retail</th>
                                                    <th class="fs-7 text-gray-500 text-uppercase th-primary" colspan="5" id="">Discount</th>
                                                </tr>
                                                <tr>
                                                    <td class="" colspan="5" id="retailRow"></td>
                                                    <td class="" colspan="10" id="discRow"></td>
                                                </tr>
                                                <tr  style="background: lightgreen;">                                                
                                                    <td class="text-center" colspan="10" id = 'total'></td>
                                                    
                                                </tr>
                                            </tfoot>
                                           
                                        </table>
                                       </div> 

                                    {!! $dataTable->table() !!}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection()
@section('script')
    <script src="https://cdnjs.cloudflare.com/ajax/libs/ion-rangeslider/2.3.1/js/ion.rangeSlider.min.js"></script>
    <script>
        function addEmailAlert(email, locationId, vendorId, id) {
            var url = "{{ route('carrierAddEmailAlert') }}";
            $.ajax({
                url: url,
                method: 'POST',
                data: {
                    email: email,
                    locationId: locationId,
                    vendorId: vendorId,
                    id: id,
                    _token: "{{ csrf_token() }}"
                },
                success: function(res) {
                    toastr.success('Email Alert Added Successfully');
                    $('#setbuttons' + id).html(res);
                },
                error: function(error) {
                    toastr.error(error);
                }
            });
        }

        function removeEmailAlert(email, locationId, vendorId, id) {
            var url = "{{ route('carrierRemoveEmailAlert') }}";
            $.ajax({
                url: url,
                method: 'GET',
                data: {
                    email: email,
                    locationId: locationId,
                    vendorId: vendorId,
                    id: id
                },
                success: function(res) {
                    toastr.success('Email Alert Removed Successfully');
                    $('#setbuttons' + id).html(res);
                },
                error: function(error) {
                    toastr.error(error);
                }
            });
        }
    </script>
    <script>
        $(function() {
            var start = moment();
            var end = moment();

            function cb(start, end) {
                $('#range span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
                $("#start_date").val(start.format('YYYY-MM-DD'));
                $("#end_date").val(end.format('YYYY-MM-DD'));
            }

            $('#range').daterangepicker({
                startDate: start,
                endDate: end,
                ranges: {
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()]
                }
            }, cb);
            cb(start, end);

            const table = $('#carrierpricing-table');

            table.on('preXhr.dt', function(e, setting, data) {
                data.search = $('#search').val();
                data.start_date = $('#start_date').val();
                data.end_date = $('#end_date').val();
                data.STORE_NUM = $('#STORE_NUM').val();
                data.ST = $('#ST').val();
                data.TYPE = $('#TYPE').val();
                data.status = $('#STATUS').prop('checked') ? 'ACTIVE' : 'INACTIVE';
                data.to = $('#to').val();
                data.from = $('#from').val();
            });

             const tableCount = $('#tableCount');

            tableCount.on('preXhr.dt', function(e, setting, count) {
                count.search = $('#search').val();
                count.start_date = $('#start_date').val();
                count.end_date = $('#end_date').val();
                count.STORE_NUM = $('#STORE_NUM').val();
                count.ST = $('#ST').val();
                count.TYPE = $('#TYPE').val();
                count.to = $('#to').val();
                count.from = $('#from').val();
            });

            $('#submit').on('click', function() {
                table.DataTable().ajax.reload();
                tableCount.DataTable().ajax.reload();

                return false;
            });

            $('#downloadOptions').on('change', function() {
                var downloadOptions = this.value;
                $(".buttons-" + downloadOptions).click();
            });

            $('#clear').on('click', function() {
                $('#search, #STORE_NUM').val('');
                $('#ST').val([]).trigger('change');
                $('#TYPE').val([]).trigger('change');

                var start = moment();
                var end = moment();
                $('#range').data('daterangepicker').setStartDate(start);
                $('#range').data('daterangepicker').setEndDate(end);
        
                $('#range span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));

                $("#start_date").val(start.format('YYYY-MM-DD'));
                $("#end_date").val(end.format('YYYY-MM-DD'));

                var slider = $("#example").data("ionRangeSlider");
                slider.update({
                    from: 0,
                    to: 2
                });
                $('#from').val('0');
                $('#to').val('2');

                table.DataTable().ajax.reload();
                // location.reload();
            });
        });
    </script>

    {!! $dataTable->scripts() !!}

    <script>
        $(document).ready(function() {

            
               $('#tableCount').DataTable({
                dom: 'Bfrt',
               // buttons: ['csv', 'excel', 'print', 'reset', 'reload'],
                processing: true,
                serverSide: true,
                ajax: '{!! route('carrierPricing.carrierPricingCount') !!}',
                data: {
                    formName: 'afscpMcn',
                    action: 'search',
                },
                pageLength: 25,
                order: [
                    [0, 'desc']
                ],
                footerCallback: function(tfoot, data, start, end, display) {                  
                    var rebate2_0_10_plus_avg = data[0].rebate2_0_10_plus_avg ? data[0].rebate2_0_10_plus_avg : '0%';
                    var rebate2_0_20_plus_avg = data[0].rebate2_0_20_plus_avg ? data[0].rebate2_0_20_plus_avg : '0%';
                    var rebate2_0_30_plus_avg = data[0].rebate2_0_30_plus_avg ? data[0].rebate2_0_30_plus_avg : '0%';
                    var rebate2_0_40_plus_avg = data[0].rebate2_0_40_plus_avg ? data[0].rebate2_0_40_plus_avg : '0%';
                    var rebate2_0_50_plus_avg = data[0].rebate2_0_50_plus_avg ? data[0].rebate2_0_50_plus_avg : '0%';
                    var rebate2_0_60_plus_avg = data[0].rebate2_0_60_plus_avg ? data[0].rebate2_0_60_plus_avg : '0%';
                    var rebate2_0_70_plus_avg = data[0].rebate2_0_70_plus_avg ? data[0].rebate2_0_70_plus_avg : '0%';
                    var rebate2_0_80_plus_avg = data[0].rebate2_0_80_plus_avg ? data[0].rebate2_0_80_plus_avg : '0%';
                    var rebate2_0_90_plus_avg = data[0].rebate2_0_90_plus_avg ? data[0].rebate2_0_90_plus_avg : '0%';
                    var rebate2_1_10_plus_avg = data[0].rebate2_1_10_plus_avg ? data[0].rebate2_1_10_plus_avg : '0%';
                    var minRetail = data[0].minRetail ? data[0].minRetail : 0;
                    var maxRetail = data[0].maxRetail ? data[0].maxRetail : 0;
                    var avgRetail = data[0].avgRetail ? data[0].avgRetail : 0;
                    var mindisc = data[0].mindisc ? data[0].mindisc : 0;
                    var maxdisc = data[0].maxdisc ? data[0].maxdisc : 0;
                    var avgdisc = data[0].avgdisc ? data[0].avgdisc : 0;

                    $("#rebate2_0_10_plus_avg").html(rebate2_0_10_plus_avg);
                    $("#rebate2_0_20_plus_avg").html(rebate2_0_20_plus_avg);
                    $("#rebate2_0_30_plus_avg").html(rebate2_0_30_plus_avg);
                    $("#rebate2_0_40_plus_avg").html(rebate2_0_40_plus_avg);
                    $("#rebate2_0_50_plus_avg").html(rebate2_0_50_plus_avg);
                    $("#rebate2_0_60_plus_avg").html(rebate2_0_60_plus_avg);
                    $("#rebate2_0_70_plus_avg").html(rebate2_0_70_plus_avg);
                    $("#rebate2_0_80_plus_avg").html(rebate2_0_80_plus_avg);
                    $("#rebate2_0_90_plus_avg").html(rebate2_0_90_plus_avg);
                    $("#rebate2_1_10_plus_avg").html(rebate2_1_10_plus_avg);
                    $("#total").html('Total : '+data[0].rebate2_total_count+' (TA: '+data[0].rebate2_total_ta_count+', PILOT: '+data[0].rebate2_total_pilot_count+')');
                    // $("#retailRow").html('MIN: '+minRetail+' MAX: '+maxRetail+' AVG: '+avgRetail);
                    $("#retailRow").html('Low: ' + minRetail + '<br>High: ' + maxRetail + '<br>Avg: ' + avgRetail);
                    $("#discRow").html('Low: '+mindisc+' <br>High: '+maxdisc+'<br>Avg: '+avgdisc); 
                 
                    

                },
                columns: [{
                        data: 'rebate2_0_10_plus',
                        name: '0.10+'
                    },
                    {
                        data: 'rebate2_0_20_plus',
                        name: '0.20+'
                    },
                    {
                        data: 'rebate2_0_30_plus',
                        name: '0.30+'
                    },
                    {
                        data: 'rebate2_0_40_plus',
                        name: '0.40+'
                    },
                    {
                        data: 'rebate2_0_50_plus',
                        name: '0.50+'
                    },
                    {
                        data: 'rebate2_0_60_plus',
                        name: '0.60+'
                    },
                    {
                        data: 'rebate2_0_70_plus',
                        name: '0.70+'
                    },
                    {
                        data: 'rebate2_0_80_plus',
                        name: '0.80+'
                    },
                    {
                        data: 'rebate2_0_90_plus',
                        name: '0.90+'
                    },
                    {
                        data: 'rebate2_1_00_plus',
                        name: '1.0+'
                    },
                ],
                "createdRow": function(row, data, dataIndex) {
                    $(row).addClass("fs-6");
                },
            });

            var slider = $("#example").ionRangeSlider({
                type: "double",
                min: 0,
                max: 2,
                from: 0,
                to: 2,
                step: 0.001,
                grid: true,
                onFinish: function(data) {
                    $('#from').val(data.from);
                    $('#to').val(data.to);
                }
            }).data("ionRangeSlider");

            $('#from').val(slider.result.from);
            $('#to').val(slider.result.to);
        });
          function changeExport(){
          var value =   $("#downloadOptions").val();
           if(value != "" ){           
             console.log("inside");
            $('#downloadOptions option[value=""]').prop('selected', true);
            $('#downloadOptions').trigger('change');
            //  $("#downloadOptions").val("");
           }
           console.log("outside",value);

        }
    </script>
@endsection()