How to show which discount group?

[Ryk]

The client offers a range of trade discounts set up in Group Pricing. He would like his customers to be able to see their trade discount level (i.e. 15%, 20% or 25%) when logged in.

I understand that

if (isset($_SESSION['customer_id']))

determines the logged in state, but not being a programmer, I'm not at all sure of the syntax for now creating the following query against that customer_id:

IF a trade customer (ie in one of the 3 groups) DISPLAY the % allocated to that group.


Can anybody rattle off the syntax for me please?

[Ryk]

I've made a fair bit of progress using my standard trial and error technique, and I can get the results I want when I enter a known value of 'customer_id' into the SELECT command.

However, can someone please tell me how to SELECT using the variable value of $_SESSION['customer_id']?

if (isset($_SESSION['customer_id'])) {
				
	$show='SELECT * FROM zen_customers WHERE customers_id=WHAT GOES HERE PLEASE;

[Ajeh]

Try using:

$show="SELECT * FROM " . TABLE_CUSTOMERS . " WHERE customers_id='" . $_SESSION['customer_id'] . "'";

[Ryk]

THANK YOU!!

[MissterX]

Hi!

I'm not sure if it's the right place to follow up - but if I'm wrong, direct me.

Befor I even found this thread I made this file: it shows the price in a table after
"Product Price block" and before "free ship icon". Sorry for the quick hack...

1) Add this between <!--eof Product Price block --> <!--bof free ship icon --> in the file includes/templates/*my_template*/templates/tpl_product_info_display.php - it should be around line #80:

<!-- bof customers dicount info & price -->
<?php
echo display_group_pricings ((int)$_GET['products_id']);
?>
<!-- eof customers dicount info & price -->


2) Copy attached - and unzipped file - to includes/functions/extra_functions.

P.S.
Mind you, it might be some leftovers from the swedish language. If you do find such a word and do not the meaning of it - PM me and I'll answer back.

[dbrewster]

MissterX,

I like your suggestion. I'd like to include the group pricing group name in the display. I've been playing around with how to include it in the product info display page, using your product_info_group_pricing_discount.php function, but I am not having success. Have you worked it out?

This did not work:

$content .= $group_discount->fields['group_name'] . ' discount: <strong>' . 
            $group_pricing . '%</strong>.';

I also tried inserting this after
$group_pricing = (int)$q_sql->fields['g_p'];

$sql = 'SELECT group_name g_n FROM '.TABLE_GROUP_PRICING.' 
       WHERE group_id LIKE "'.$q_sql->fields['g_n'].'"';
$q_sql = $db->Execute($sql);
$group_name = $q_sql->fields['g_n'];

and then:

$content .= $group_name . ' discount: <strong>' . 
                 $group_pricing . '%</strong>.';

but that didn't work either. I'm just parroting what I see, I'm not a programmer .

---Diana

[MissterX]

MissterX,

I like your suggestion. I'd like to include the group pricing group name in the display. I've been playing around with how to include it in the product info display page, using your product_info_group_pricing_discount.php function, but I am not having success. Have you worked it out?

...

Hi D.

I think so.

File: includes/functions/extra_functions/product_info_group_pricing_discount.php
Line no: 8

$sql = 'SELECT group_percentage g_p FROM '.TABLE_GROUP_PRICING.' WHERE group_id LIKE "'.$q_sql->fields['cg_p'].'"';

should be change to:

$sql = 'SELECT group_percentage g_p, group_name g_n FROM '.TABLE_GROUP_PRICING.' WHERE group_id LIKE "'.$q_sql->fields['cg_p'].'"';

Line no: 14
Add after it:

$group_name = $q_sql->fields['g_n'];

Then you can put in the group name ($group_name) where you want.

[dbrewster]

Thank you MissterX, works like a charm!!

This is so good, it should be a part of ZC.

Here's my simplified display implementation, without the fancy tax calculation table:

$content .= '<div style="font-size:small; width:85%; background-color:#e9e9e9; 
padding: 0.5em; margin: 0.5em">';
$content .= $group_name . ' discount: <strong>' . $group_pricing . '%</strong>.';
$content .= '</div>';

---Diana

[haiopei]

Hi@ all, hi MissterX,

this workaround i have long searched for.

It works...but it seems to be not finally ?

I have it putted as you descripted.


All prices are rounded and looks crashed ":-":

Your Discount: 5%.

Total -16% MwSt MwSt
Price 81:- 70:- 11:-
-5% -4:- -4:-
Your 77:- 66:- 11:-
price

The original price i.e. was here 81,14.

Sorry for my bad english, im a german-user with some broken english in school and no good experience in programming.

CU

[haiopei]

@ all :

i forget some. i need two numbers behind komma :

i.e. 81,14

Who can i fix this ?

CU