@extends('layouts.app')

@section('content')
<div class="page-wrapper">
    <div class="row page-titles">
        <div class="col-md-5 align-self-center">
            <h3 class="text-themecolor">{{trans('lang.reports_sale')}}</h3>
        </div>

        <div class="col-md-7 align-self-center">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="{{url('/dashboard')}}">{{trans('lang.dashboard')}}</a></li>
                <li class="breadcrumb-item"><a href="{{url('/reports/sales')}}">{{trans('lang.report_plural')}}</a>
                </li>
                <li class="breadcrumb-item active">{{trans('lang.reports_sale')}}</li>
            </ol>
        </div>
    </div>
    <div class="container-fluid">
        <div class="card  pb-4">

            <div class="card-body">
                <div id="data-table_processing" class="dataTables_processing panel panel-default"
                    style="display: none;">{{trans('lang.processing')}}</div>
                <div class="error_top"></div>

                <div class="row restaurant_payout_create">
                    <div class="restaurant_payout_create-inner">
                        <fieldset>
                            <legend>{{trans('lang.reports_sale')}}</legend>

                            <div class="form-group row width-50">
                                <label class="col-3 control-label">{{trans('lang.select_restaurant')}}</label>
                                <div class="col-7">
                                    <select class="form-control restaurant">
                                        <option value="">{{trans('lang.all')}}</option>
                                    </select>
                                </div>
                            </div>

                            <div class="form-group row width-50">
                                <label class="col-3 control-label">{{trans('lang.select_driver')}}</label>
                                <div class="col-7">
                                    <select class="form-control driver">
                                        <option value="">{{trans('lang.all')}}</option>
                                    </select>
                                </div>
                            </div>

                            <div class="form-group row width-50">
                                <label class="col-3 control-label">{{trans('lang.select_user')}}</label>
                                <div class="col-7">
                                    <select class="form-control customer">
                                        <option value="">{{trans('lang.all')}}</option>
                                    </select>
                                </div>
                            </div>

                            <div class="form-group row width-50">
                                <label class="col-3 control-label">{{trans('lang.select_category')}}</label>
                                <div class="col-7">
                                    <select class="form-control category">
                                        <option value="">{{trans('lang.all')}}</option>
                                    </select>
                                </div>
                            </div>

                            {{-- <div class="form-group row width-50">
                                     <label class="col-3 control-label">{{trans('lang.select_payment_method')}}</label>
                            <div class="col-7">
                                <select class="form-control payment_method">
                                    <option value="">{{trans('lang.all')}}</option>

                                </select>
                            </div>
                    </div>--}}

                    <div class="form-group row width-100">
                        <label class="col-3 control-label">{{trans('lang.select_date')}}</label>
                        <div class="col-7">
                            <div id="reportrange"
                                style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 100%">
                                <i class="fa fa-calendar"></i>&nbsp;
                                <span></span> <i class="fa fa-caret-down"></i>
                            </div>
                        </div>
                    </div>

                    <div class="form-group row width-100">
                        <label class="col-3 control-label">{{trans('lang.file_format')}}<span
                                class="required-field"></span></label>
                        <div class="col-7">
                            <select class="form-control file_format">
                                <option value="">{{trans('lang.file_format')}}</option>
                                <option value="csv">{{trans('lang.csv')}}</option>
                                <option value="pdf">{{trans('lang.pdf')}}</option>
                            </select>
                        </div>
                    </div>

                    </fieldset>
                </div>
            </div>

            <div class="form-group col-12 text-center btm-btn">
                <button type="submit" class="btn btn-primary do-not-download"><i
                        class="fa fa-save"></i> {{ trans('lang.download')}}</button>
            </div>

        </div>

    </div>
</div>
</div>
@endsection

@section('scripts')
<script src="{{ asset('js/helpers.js') }}"></script>

<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />

<script>
    var database = firebase.firestore();
    var refCurrency = database.collection('currencies').where('isActive', '==', true).limit('1');
    var restaurantRef = database.collection('vendors').orderBy('createdAt').orderBy('title');
    var driverUserRef = database.collection('users').where('role', '==', 'driver').orderBy('createdAt').orderBy('firstName');
    var customerRef = database.collection('users').where('role', '==', 'customer').orderBy('createdAt').orderBy('firstName');
    var categoryRef = database.collection('vendor_categories').orderBy('title');
    var paymentMethodRef = database.collection('settings').doc('payment');

    setDate();

    function setDate() {
        var start = moment().subtract(29, 'days');
        var end = moment();

        function cb(start, end) {
            $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
        }

        $('#reportrange').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()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
            }
        }, cb);

        cb(start, end);
    }

    var decimal_degits = 0;
    var symbolAtRight = false;
    var currentCurrency = '';
    refCurrency.get().then(async function(snapshots) {

        var currencyData = snapshots.docs[0].data();
        currentCurrency = currencyData.symbol;
        decimal_degits = currencyData.decimalDigits;

        if (currencyData.symbolAtRight) {
            symbolAtRight = true;
        }
    });

    categoryRef.get().then(function(snapShots) {

        if (snapShots.docs.length > 0) {

            snapShots.docs.forEach((listval) => {
                var data = listval.data();

                $('.category').append('<option value="' + data.id + '">' + data.title + '</option>');
            });

        }
    });

    paymentMethodRef.get().then(function(snapShots) {

        var data = snapShots.data();
        Object.keys(data).forEach((listval) => {

            $('.payment_method').append($("<option value='" + data[listval].name + "'>" + data[listval].name + "</option>"));
        });
    });

    customerRef.get().then(function(snapShots) {

        if (snapShots.docs.length > 0) {

            snapShots.docs.forEach((listval) => {
                var data = listval.data();

                $('.customer').append('<option value="' + data.id + '">' + data.firstName + ' ' + data.lastName + '</option>');
            });

        }
    });

    restaurantRef.get().then(function(snapShots) {

        if (snapShots.docs.length > 0) {

            snapShots.docs.forEach((listval) => {
                var data = listval.data();

                $('.restaurant').append('<option value="' + data.id + '">' + data.title + '</option>');
            });

        }
    });

    driverUserRef.get().then(function(snapShots) {

        if (snapShots.docs.length > 0) {

            snapShots.docs.forEach((listval) => {
                var data = listval.data();

                $('.driver').append('<option value="' + data.id + '">' + data.firstName + ' ' + data.lastName + '</option>');
            });

        }
    });

    async function generateReport(orderData, headers, fileFormat) {

        if ((fileFormat == "pdf") ? document.title = "sales-report" : "");

        objectExporter({
            type: fileFormat,
            exportable: orderData,
            headers: headers,
            fileName: 'sales-report',
            columnSeparator: ',',
            headerStyle: 'font-weight: bold; padding: 5px; border: 1px solid #dddddd;',
            cellStyle: 'border: 1px solid lightgray; margin-bottom: -1px;',
            sheetName: 'sales-report',
            documentTitle: '',
        });

    }

    async function getReportData(orderSnapshots, fileFormat) {

        var orderData = [];

        await Promise.all(orderSnapshots.docs.map(async (order) => {

            var orderObj = order.data();
            var orderId = orderObj.id;
            var finalOrderObject = {};

            var driverData = ((orderObj.driver && orderObj.driver != null) ? orderObj.driver : '');
            var userData = ((orderObj.author && orderObj.author != null) ? orderObj.author : '');
            var vendorData = ((orderObj.vendor && orderObj.vendor != null) ? orderObj.vendor : '');
            var date = orderObj.createdAt.toDate();

            var distanceType = ((orderObj.distanceType && orderObj.distanceType != "" && orderObj.distanceType != null) ? orderObj.distanceType : "");

            finalOrderObject['Order ID'] = orderId;
            finalOrderObject['Restaurant Name'] = ((vendorData.title) ? vendorData.title : "");

            finalOrderObject['Driver Name'] = ((driverData.firstName) ? ((driverData.lastName) ? driverData.firstName + ' ' + driverData.lastName : driverData.firstName) : "");

            finalOrderObject['Driver Email'] = ((driverData.email) ? shortEmail(driverData.email) : "");
            if (driverData.phoneNumber != "" && driverData.phoneNumber != null) {
                var phoneNumber = shortEditNumber(driverData.phoneNumber);
            } else {
                var phoneNumber = "";
            }
            finalOrderObject['Driver Phone'] = phoneNumber;


            finalOrderObject['User Name'] = ((userData.firstName) ? ((userData.lastName) ? userData.firstName + ' ' + userData.lastName : userData.firstName) : "");
            finalOrderObject['User Email'] = ((userData.email) ? shortEmail(userData.email) : "");

            if (userData.phoneNumber != "" && userData.phoneNumber != null) {
                var phoneNo = shortEditNumber(userData.phoneNumber);
            } else {
                var phoneNo = "";
            }
            finalOrderObject['User Phone'] = phoneNo;

            finalOrderObject['Date'] = moment(date).format('ddd MMM DD YYYY h:mm:ss A');

            finalOrderObject['Category'] = ((vendorData.categoryTitle) ? vendorData.categoryTitle : "");
            finalOrderObject['Payment Method'] = orderObj.payment_method;

            var total_amount = getProductsTotal(orderObj);

            var adminCommission = 0;

            if (orderObj.adminCommission != undefined && orderObj.adminCommissionType != undefined) {

                if (orderObj.adminCommissionType == "Percent") {
                    adminCommission = (total_amount * parseFloat(orderObj.adminCommission)) / 100;
                } else {
                    adminCommission = parseFloat(orderObj.adminCommission);
                }
            } else if (orderObj.adminCommission != undefined) {
                adminCommission = parseFloat(orderObj.adminCommission);
            }


            if (symbolAtRight) {
                total_amount = convertNumber(parseFloat(total_amount).toFixed(decimal_degits)) + "" + currentCurrency;
                adminCommission = convertNumber(parseFloat(adminCommission).toFixed(decimal_degits)) + "" + currentCurrency;
            } else {
                total_amount = currentCurrency + "" + convertNumber(parseFloat(total_amount).toFixed(decimal_degits));
                adminCommission = currentCurrency + "" + convertNumber(parseFloat(adminCommission).toFixed(decimal_degits));
            }

            finalOrderObject['Total'] = (total_amount);
            finalOrderObject['Admin Commission'] = adminCommission;

            orderData.push(finalOrderObject);
        }));

        return orderData;
    }

    function getProductsTotal(snapshotsProducts) {

        var adminCommission = snapshotsProducts.adminCommission;
        var discount = snapshotsProducts.discount;
        var couponCode = snapshotsProducts.couponCode;
        var extras = snapshotsProducts.extras;
        var extras_price = snapshotsProducts.extras_price;
        var rejectedByDrivers = snapshotsProducts.rejectedByDrivers;
        var takeAway = snapshotsProducts.takeAway;
        var tip_amount = snapshotsProducts.tip_amount;
        var status = snapshotsProducts.status;
        var products = snapshotsProducts.products;
        var deliveryCharge = snapshotsProducts.deliveryCharge;
        var totalProductPrice = 0;
        var total_price = 0;
        var specialDiscount = snapshotsProducts.specialDiscount;

        var intRegex = /^\d+$/;
        var floatRegex = /^((\d+(\.\d *)?)|((\d*\.)?\d+))$/;

        if (products) {

            products.forEach((product) => {

                var val = product;
                if (val.price) {
                    price_item = parseFloat(val.price).toFixed(2);

                    extras_price_item = 0;
                    if (val.extras_price && !isNaN(extras_price_item) && !isNaN(val.quantity)) {
                        extras_price_item = (parseFloat(val.extras_price) * parseInt(val.quantity)).toFixed(2);
                    }
                    if (!isNaN(price_item) && !isNaN(val.quantity)) {
                        totalProductPrice = parseFloat(price_item) * parseInt(val.quantity);
                    }
                    var extras_price = 0;
                    if (parseFloat(extras_price_item) != NaN && val.extras_price != undefined) {
                        extras_price = extras_price_item;
                    }
                    totalProductPrice = parseFloat(extras_price) + parseFloat(totalProductPrice);
                    totalProductPrice = parseFloat(totalProductPrice).toFixed(2);
                    if (!isNaN(totalProductPrice)) {
                        total_price += parseFloat(totalProductPrice);
                    }


                }

            });
        }

        if (intRegex.test(discount) || floatRegex.test(discount)) {

            discount = parseFloat(discount).toFixed(decimal_degits);
            total_price -= parseFloat(discount);

        }
        var special_discount = 0;
        if (specialDiscount != undefined) {
            special_discount = parseFloat(specialDiscount.special_discount).toFixed(2);

            total_price = total_price - special_discount;
        }
        tax = 0;
        if (snapshotsProducts.hasOwnProperty('taxSetting')) {
            var total_tax_amount = 0;
            for (var i = 0; i < snapshotsProducts.taxSetting.length; i++) {
                var data = snapshotsProducts.taxSetting[i];

                if (data.type && data.tax) {
                    if (data.type == "percentage") {
                        tax = (data.tax * total_price) / 100;
                    } else {
                        tax = data.tax;
                    }
                }
                total_tax_amount += parseFloat(tax);
            }
            total_price = parseFloat(total_price) + parseFloat(total_tax_amount);
        }


        if ((intRegex.test(deliveryCharge) || floatRegex.test(deliveryCharge)) && !isNaN(deliveryCharge)) {

            deliveryCharge = parseFloat(deliveryCharge).toFixed(decimal_degits);
            total_price += parseFloat(deliveryCharge);
        }

        if (intRegex.test(tip_amount) || floatRegex.test(tip_amount) && !isNaN(tip_amount)) {

            tip_amount = parseFloat(tip_amount).toFixed(decimal_degits);
            total_price += parseFloat(tip_amount);
            total_price = parseFloat(total_price).toFixed(decimal_degits);
        }

        return total_price;
    }

    $(document).on('click', '.do-not-download', function() {

        var restaurant = $(".restaurant :selected").val();
        var driver = $(".driver :selected").val();
        var customer = $(".customer :selected").val();
        var category = $(".category :selected").val();
        var payment_method = $(".payment_method :selected").val();
        var fileFormat = $(".file_format :selected").val();
        let start_date = moment($('#reportrange').data('daterangepicker').startDate).toDate();
        let end_date = moment($('#reportrange').data('daterangepicker').endDate).toDate();

        var headerArray = ['Order ID', 'Restaurant Name', 'Driver Name', 'Driver Email', 'Driver Phone', 'User Name', 'User Email', 'User Phone', 'Date', 'Category', 'Payment Method', 'Total', 'Admin Commission'];

        var headers = [];

        $(".error_top").html("");

        if (fileFormat == 'xls' || fileFormat == 'csv') {
            headers = headerArray;
            var script = document.createElement("script");
            script.setAttribute("src", "https://unpkg.com/object-exporter@3.2.1/dist/objectexporter.min.js");

            var head = document.head;
            head.insertBefore(script, head.firstChild);
        } else {
            for (var k = 0; k < headerArray.length; k++) {
                headers.push({
                    alias: headerArray[k],
                    name: headerArray[k],
                    flex: 1,
                });
            }

            var script = document.createElement("script");
            script.setAttribute("src", "{{ asset('js/objectexporter.min.js') }}");
            script.setAttribute("async", "false");
            var head = document.head;
            head.insertBefore(script, head.firstChild);

        }

        if (fileFormat == '') {
            $(".error_top").show();
            $(".error_top").html("");
            $(".error_top").append("<p>{{trans('lang.file_format_error')}}</p>");
            window.scrollTo(0, 0);
        } else {
            jQuery("#overlay").show();

            var ordersRef = database.collection('restaurant_orders').where('status', 'in', ["Order Completed"]).orderBy('createdAt', 'desc');

            if (restaurant != "") {
                ordersRef = ordersRef.where('vendorID', '==', restaurant)
            }

            if (driver != "") {
                ordersRef = ordersRef.where('driverID', '==', driver)
            }
            if (customer != "") {
                ordersRef = ordersRef.where('authorID', '==', customer)
            }

            if (category != "") {
                ordersRef = ordersRef.where('vendor.categoryID', '==', category)
            }


            if (start_date != "") {
                ordersRef = ordersRef.where('createdAt', '>=', start_date)
            }

            if (end_date != "") {
                ordersRef = ordersRef.where('createdAt', '<=', end_date)
            }

            ordersRef.get().then(async function(orderSnapshots) {

                if (orderSnapshots.docs.length > 0) {
                    var reportData = await getReportData(orderSnapshots, fileFormat);


                    generateReport(reportData, headers, fileFormat);

                    jQuery("#overlay").hide();
                    setDate();
                    $('.file_format').val('').trigger('change');
                    $('.driver').val('').trigger('change');
                    $('.customer').val('').trigger('change');
                    $('.service').val('').trigger('change');
                    $('.status').val('').trigger('change');
                    $('.payment_method').val('').trigger('change');
                    $('.payment_status').val('').trigger('change');

                } else {
                    jQuery("#overlay").hide();
                    setDate();
                    $(".error_top").show();
                    $(".error_top").html("");
                    $(".error_top").append("<p>{{trans('lang.not_found_data_error')}}</p>");
                    window.scrollTo(0, 0);

                }

            }).catch((error) => {

                jQuery("#overlay").show();

                console.log("Error getting documents: ", error);
                $(".error_top").show();
                $(".error_top").html(error);
                window.scrollTo(0, 0);
            });
        }
    });
</script>
@endsection