{"id":216,"date":"2019-07-03T08:55:03","date_gmt":"2019-07-03T08:55:03","guid":{"rendered":"http:\/\/bossakov.eu\/wpdemo\/?page_id=216"},"modified":"2023-03-30T01:33:36","modified_gmt":"2023-03-30T01:33:36","slug":"discount-codes-example","status":"publish","type":"page","link":"https:\/\/bossakov.eu\/wpdemo\/pvb-cf7-calculator-pro\/discount-codes-example\/","title":{"rendered":"Discount codes example"},"content":{"rendered":"

This is a very simple example of how you can implement discount codes managed in a separate Excel file on the server.<\/p>\n

Try these codes:<\/p>\n

TESTPERCENT<\/strong> – percentage discount, 20%
\nTESTFIXED<\/strong> – fixed discount of $5<\/p>\n

You can download the Excel spreadsheet here<\/a>.<\/p>\n\n

\n

<\/p>

    <\/ul><\/div>\n
    \n
    \n<\/fieldset>\n

    \n<\/p>\n

    \n\n\n\t

    [spreadsheet_reference raw_discount cf7-hide field:discount-code sheet:1 cells:A1-B10 \"http:\/\/bossakov.eu\/wpdemo\/wp-content\/uploads\/2019\/07\/discounts.xlsx\"]
    \n[spreadsheet_reference raw_discount_2 cf7-hide field:second-discount-code sheet:1 cells:A1-B10 \"http:\/\/bossakov.eu\/wpdemo\/wp-content\/uploads\/2019\/07\/discounts.xlsx\"]\n\t<\/p>\n\n\n\t

    <\/span>
    \n\n\t<\/p>\n\n\n\t


    \n\n\t<\/p>\n<\/div>\n\n\n

    <\/div>\n<\/form>\n<\/div>\n\n

    Source code for this form:<\/h2>\n
    <label>Subtotal ($):\n$ [text subtotal \"1000\"]<\/label>\n\n<label>Discount code:\n[text discount-code]<\/label>\n\n<label>Second discount code:\n[text second-discount-code]<\/label>\n\n[calculate_button calculate_button-1 \"Calculate\"]\n\n<div style=\"display:none\">\n\n<!-- Look up the discount code and match it to a number -->\n[spreadsheet_reference raw_discount cf7-hide field:discount-code sheet:1 cells:A1-B10 \"https:\/\/bossakov.eu\/wpdemo\/wp-content\/uploads\/2019\/07\/discounts.xlsx\"]\n[spreadsheet_reference raw_discount_2 cf7-hide field:second-discount-code sheet:1 cells:A1-B10 \"https:\/\/bossakov.eu\/wpdemo\/wp-content\/uploads\/2019\/07\/discounts.xlsx\"]\n\n<!-- We need to apply some behind-the-scenes number transformations to see if the discount is a fixed amount or a percentage. If the number is >= 1, then it is a fixed discount, otherwise we assume it is a percentage -->\n\n<!-- First, round down to the nearest integer -->\n[calculation temp cf7-hide precision:0 rounddown \"raw_discount\"]\n[calculation temp_2 cf7-hide precision:0 rounddown \"raw_discount_2\"]\n\n<!-- Then, normalize to either 0 or 1 -->\n[calculation is_fixed cf7-hide min:0 max:1 \"temp\"]\n[calculation is_fixed_2 cf7-hide min:0 max:1 \"temp_2\"]\n<\/div>\n\n<!-- Calculate discount -->\n<label>Discount: $ [calculation discount \"raw_discount * is_fixed + (subtotal * raw_discount * (1-is_fixed)) + raw_discount_2 * is_fixed_2 + (subtotal * raw_discount_2 * (1-is_fixed_2))\"]<\/label>\n\n<!-- Calculate total -->\n<label>Total: $ [calculation total \"subtotal - discount\"]\n<\/label>\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
    This is a very simple example of how you can implement discount codes managed in a separate Excel file on the server. Try these codes: TESTPERCENT – percentage discount, 20% TESTFIXED – fixed discount of $5 You can download the Excel spreadsheet here. Source code for this form: <label>Subtotal ($): $ [text subtotal “1000”]<\/label> <label>Discount […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-216","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/comments?post=216"}],"version-history":[{"count":7,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/216\/revisions"}],"predecessor-version":[{"id":519,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/216\/revisions\/519"}],"up":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/2"}],"wp:attachment":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/media?parent=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}