SOLVED!
First, on
/www/includes/functions/extra_functions/reward_points_functions.php
I added a new function ,after the function GetRedeemRatio() :
PHP Code:
function GetRedeemGroup($customers_id)
{
global $db;
$sql = "SELECT gp.group_name
FROM ".TABLE_GROUP_PRICING." gp
LEFT JOIN (".TABLE_CUSTOMERS." as c)
ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id='".(int)$customers_id."'
ORDER BY gp.group_id
";
$result=$db->Execute($sql);
if($result)
return $result->fields['group_name'];
else
return 0;
}
and
on
/www/includes/templates/YOUR_TEMPLATE/sideboxes/tpl_reward_points.php
after $reward_points=GetRewardPoints($_SESSION['cart']->get_products()); (LINE AROUND 11)
add this :
PHP Code:
$group_name=GetRedeemGroup($_SESSION['customer_id']);
and one a line about 25, afther the if($reward_points>0) statement
change the line
PHP Code:
$content='<div class="cartBoxRewardPoints">'. .....
to :
PHP Code:
$content.='<div class="cartBoxRewardPoints">'. '<p style="color:green;text-align:center;font-size:12px;font-weight:bold;">My Level : ' . $group_name . '</p><br />' . $customers->fields['group_name'].(int)$reward_points.' '.REWARD_POINTS_IN_CART_TAG.'</div>';
This will make you able to show the customer's group name on the sidebox.
I was trying to build the customer's membership policy,
and now I finally can.
Thank you for this great module... that I can provide betther service to my customer.
Bookmarks