{"id":121,"date":"2022-02-20T20:49:45","date_gmt":"2022-02-20T20:49:45","guid":{"rendered":"http:\/\/fuelfox.net\/customer\/?page_id=121"},"modified":"2022-02-21T16:47:41","modified_gmt":"2022-02-21T16:47:41","slug":"spend","status":"publish","type":"page","link":"https:\/\/fuelfox.net\/customer\/spend\/","title":{"rendered":"Spend Report"},"content":{"rendered":"\n<link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/select2@4.1.0-rc.0\/dist\/css\/select2.min.css\" \/>\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/select2@4.1.0-rc.0\/dist\/js\/select2.min.js\"><\/script>\n<link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/select2-bootstrap-5-theme@1.2.0\/dist\/select2-bootstrap-5-theme.min.css\" \/>\n\n<style>\n    tr.allwhite td { background-color: white !important; }\n<\/style>\n\n<h3>Spend Report<\/h3>\n<hr>\n<form method=\"post\" action=\"\/customer\/wp-json\/wp\/v2\/pages\/121\">\n    <div class=\"row\">\n        <div class=\"col-md-3\">\n            <label>Start Date<\/label>\n            <input type=\"date\" name=\"start\" class=\"form-control validate[required]\" value=\"2026-06-03\" \/>\n        <\/div>\n        <div class=\"col-md-3\">\n            <label>End Date<\/label>\n            <input type=\"date\" name=\"end\" class=\"form-control validate[required]\" value=\"2026-06-10\" \/>\n        <\/div>\n        <div class=\"col-md-3\">\n            <label>Fuel Type<\/label>\n            <select name=\"fuel\" class=\"form-control\">\n                <option value=\"\">All Fuel Types<\/option>\n                <option  value=\"10\">87 Octane<\/option>\n                <option  value=\"11\">93 Octane<\/option>\n                <option  value=\"12\">Diesel<\/option>\n                <option  value=\"14\">Dyed Diesel<\/option>\n                <option  value=\"13\">DEF<\/option>\n            <\/select>\n        <\/div>\n        <div class=\"col-md-3\">\n            <label>Vehicle Type<\/label>\n            <select name=\"vehtype\" class=\"form-control\">\n                <option value=\"\">All Vehicle Types<\/option>\n                <option >Car<\/option>\n                <option >Truck<\/option>\n                <option >Trailer<\/option>\n                <option >Generator<\/option>\n                <option >Grinder<\/option>\n                <option >Can<\/option>\n                <option >Tank<\/option>\n                <option >Semi Truck<\/option>\n                <option >Semi Trailer<\/option>\n                <option >Other<\/option>\n            <\/select>\n        <\/div>\n    <\/div>\n    <div class=\"spacer\"><\/div>\n    <div class=\"row\">\n        <div class=\"col-12\">\n            <label>Vehicle(s): (Leave blank for all)<\/label>\n            <select id=\"vehicle\" name=\"vehicle[]\" class=\"form-control\" multiple>\n                            <\/select>\n        <\/div>\n    <\/div>\n    <div class=\"spacer\"><\/div>\n    <div class=\"d-flex justify-content-center\">\n        <button type=\"submit\" class=\"btn btn-danger\">Show Report<\/button>\n    <\/div>\n<\/form>\n\n\n    <div class=\"spacer\"><\/div>\n\n    <table id=\"deliveries\" class=\"display nowrap responsive\" style=\"width: 100%;\">\n        <thead>\n        <tr>\n            <th>Service Date<\/th>\n            <th>Fuel Product<\/th>\n            <th>Dispensed<\/th>\n            <th>Price\/Gallon<\/th>\n            <th>Spend<\/th>\n            <th class=\"none\">Delivery Details<\/th>\n        <\/tr>\n        <\/thead>\n        <tbody>\n                <\/tbody>\n\n        <tfoot>\n            <tr>\n                <th colspan=\"3\"><\/th>\n                <th>Average: $0.000<\/th>\n                <th>Total: $0.00<\/th>\n                <th><\/th>\n            <\/tr>\n            <tr>\n                <th colspan=\"4\"><\/th>\n                <th colspan=\"2\">Average\/Svc: $0.00<\/th>\n            <\/tr>\n        <\/tfoot>\n\n    <\/table>\n\n\n<script>\n    $(document).ready(function() {\n\n        $('#vehicle').select2({\n            placeholder: 'Select to Filter',\n            theme: 'bootstrap-5'\n        });\n\n        $('#deliveries').DataTable({\n            order: [[ 0, 'desc' ]],\n            responsive: true,\n            rowGroup: {\n                dataSrc: 0,\n                endRender: function(rows, group) {\n                    let totalSpend = 0;\n                    let spends = rows.data().pluck(4);\n                    let totalDispensed = 0;\n                    let disps = rows.data().pluck(2);\n                    if (disps.length > 1) {\n                        disps.map(disp => totalDispensed += parseFloat(disp));\n                    }\n                    if (spends.length > 1) {\n                        spends.map(spend => totalSpend += parseFloat(spend.replace(\/[^\\d.]\/g, '')));\n                        let tr = $('<tr class=\"allwhite\"><td><\/td><td><strong>' + totalDispensed.toLocaleString(\"en-US\") + '<\/strong><\/td><td style=\"background-color: white; text-align: right;\">Service Total:<\/td><td>' + totalSpend.toLocaleString(\"en-US\", {\n                            style: \"currency\",\n                            currency: \"USD\",\n                            minimumFractionDigits: 2\n                        }) + '<\/td><\/tr>');\n                        return tr;\n                    }\n                }\n            },\n            columnDefs: [{\n                targets: [0],\n                visible: true\n            }]\n        });\n\n    });\n<\/script>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-121","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/pages\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":3,"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/pages\/121\/revisions"}],"predecessor-version":[{"id":127,"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/pages\/121\/revisions\/127"}],"wp:attachment":[{"href":"https:\/\/fuelfox.net\/customer\/wp-json\/wp\/v2\/media?parent=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}