vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   uCash & uShop (https://vborg.vbsupport.ru/forumdisplay.php?f=100)
-   -   Discount calculation improvements (https://vborg.vbsupport.ru/showthread.php?t=78135)

radicaledward 03-15-2005 01:28 AM
Discount calculation improvements
 
One of the big issues that I have had with the shop is that it didn't check secondary usergroups for discounts. Since members that donate to the site get a discount this is necessary on our board, and it has been necessary for me to write a fix for this issue. So to solve this problem I have written the following code - feel free to use it as you see fit. :)

In /includes/functions_uttstore.php:

Find in function calculate_discounted_price:
PHP Code:
// Generate Usergroup Discount
if ($permissions['uttstore_discount'] != "0") {
    $adiscountd = ($permissions['uttstore_discount'] / 100);
    $adiscount = ($adiscountd * $price);
    (isset($discount) ? $discount = ($discount - $adiscount) : $discount = ($price - $adiscount));
} 
Replace with:
PHP Code:
//------------------------------------------------------------------------
// Generate Discounts
//------------------------------------------------------------------------
// Get the list of groups and discounts
global $DB_site;
$groupdiscounts = $DB_site->query("SELECT usergroupid, uttstore_discount FROM usergroup WHERE uttstore_discount != '0'");
// Loop through the groups
if (!empty($groupdiscounts)) {
    while ($groupdiscount = $DB_site->fetch_array($groupdiscounts)) {
        // Check to see if the user is a member, if so then add the discount
        if (is_member_of($bbuserinfo, $groupdiscount['usergroupid'])) {
            $adiscountd += ($groupdiscount['uttstore_discount'] / 100);
        }
    }
}
// Determine the price
$adiscount = ($adiscountd * $price);
(isset($discount) ? $discount = ($discount - $adiscount) : $discount = ($price - $adiscount));
//------------------------------------------------------------------------ 
Find in function calculate_discount_percent:
PHP Code:
// Generate Usergroup Discount
if ($permissions['uttstore_discount'] != "0") {
    $adiscountd = ($permissions['uttstore_discount']);
    (isset($discount) ? $discount = ($discount + $adiscountd) : $discount = ($price + $adiscountd));
} 
Replace with:
PHP Code:
    //------------------------------------------------------------------------
// Generate Discount Percentage
//------------------------------------------------------------------------
// Get the list of groups and discounts
global $DB_site;
$groupdiscounts = $DB_site->query("SELECT usergroupid, uttstore_discount FROM usergroup WHERE uttstore_discount != '0'");
// Loop through the groups
if (!empty($groupdiscounts)) {
    while ($groupdiscount = $DB_site->fetch_array($groupdiscounts)) {
        // Check to see if the user is a member, if so then add the discount
        if (is_member_of($bbuserinfo, $groupdiscount['usergroupid'])) {
            $adiscountd += ($groupdiscount['uttstore_discount']);
        }
    }
}
// Determine the amount
(isset($discount) ? $discount = ($discount + $adiscountd) : $discount = ($price + $adiscountd));
//------------------------------------------------------------------------ 

Link14716 03-15-2005 03:14 AM
This might be a better solution. Instead of all that, in includes/init.php, find:
PHP Code:
    'pmsendmax'             => 0, 
Add under:
PHP Code:
    'uttstore_discount'     => 0, 
It won't loop through each usergroup and add the discounts, but it will take the highest value instead.

radicaledward 03-15-2005 04:29 AM
I thought of doing that, but our site is a bit unique in that we make extensive use of secondary groups for members. For example, my account has the following group memberships:

Administrators: 0% discount
Senior Members (been on the site for a long time): 5% discount
Friends of ACF (people that donated money to the site): 10% discount
Loyal member discount (registered on site for 365 days): 5% discount

Since the members were complaining about not getting all of the discounts this was judged to be the best course of action, as opposed to telling them that the highest discount is the total discount.


All times are GMT. The time now is 01:37 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01164 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete