Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

[countrycharm]

So doing some testing and found myself having to explain this to my client:

Advanced mode: Set the order status items that will trigger a transfer of the reward points between pending and earned. Points are transfered when the status changes between the "Pending" and "Earned". Status items set to "Ignore" will have no effect if the Order Status changes to it.

Honestly this is truly as clear as mud.. I changed it on my client's shop to read:

Advanced mode: Allows you to select the order status that will trigger a transfer of reward points from pending to earned. Points are transferred when the status changes between status items set to "Pending" and status items set to "Earned". Status items set to "Ignore" will have no effect on Order Status changes to it.

Wanted to share in case someone wants to make a similar change.. (or understand better what this means..)

Diva if you don't mind I'm using your suggesting in changing the words for the Reward Point Status Track advance mode settings in the Reward_Points_Full_Install.sql.

[countrycharm]

Reinstalling this as part of a v1.5.4 upgrade for a client.. Can someone explain WHY the upgrade SQL contains the admin page delete statements only to RE-INSERT the same entries again later in the script??

/*
zencart 1.5 mods
*/
DELETE FROM admin_pages WHERE page_key='configRewardPoints';
DELETE FROM admin_pages WHERE page_key='GroupRewardRedeem';
DELETE FROM admin_pages WHERE page_key='RewardPoints';
DELETE FROM admin_pages WHERE page_key='CustomerRewardPoints';

SELECT @cgi:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Reward Points';

INSERT INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRewardPoints','BOX_CONFIGURATION_REWARD_POINTS','FILENAME_CONFIGURATION',CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);  
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35); 
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36); 
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37); 

As far as I can see the only REAL "upgrade/change" is the addition of one more configuration option.. Am I missing something here?????

This has been updated in the next release.

[countrycharm]

Dunno if this could help, i'm still trying to figure it out, but Diva's mumbling made me mumble a lot .. so i found this kind of solution...

I modified the code:

<?php
    for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
      echo '              <tr>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
           '              </tr>' . "\n";
    }
?>

With:

<?php
    for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
      if ($order_total['class'] = "ot_reward_points_display") {
      echo '              <tr>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
           '              </tr>' . "\n";
       } else {
            echo '              <tr>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
           '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .
           '              </tr>' . "\n";
           }
    }
?>

It seem to work... still testing

This will be add in the next release. Thank you izar74

[countrycharm]

There will be a pagination on the Reward Points page too. It is not great but it will better than what came stock with reward points.

[izar74]

There will be a pagination on the Reward Points page too. It is not great but it will better than what came stock with reward points.

Well it's a start

[countrycharm]

Reward Point Full Suite - Version: 2.5c
Now available in the Plugins and Addons Directory

1.) Changes Added: Change the wording for Reward Point Status Track advance mode settings Admin->Configurations->Reward Points Configuration to better understand how to use the setting. Updated the Reward_Points_Full_Install.sql statement to reflect that change. ( Thanks to DivaVocals for suggestion this change. )

2.) Changes Added: Updated the Upgrade-to-2.5c.sql at the top because it deleted the Reward Points Admin page, only to RE-INSERT the same entries again later in the script. ( Thanks to DivaVocals for pointing this out. )

3.) Changes Added: Updated the admin/orders.php file to preserves the currency symbol for actual currency values, while displaying points as whole numbers. ( Thanks to izar74 for the code they suggested. )

4.) Changes Added: Added pagination on the Reward Points page. It is not great but it will better than what came stock with reward points.

5.) Files Added: ZC1.5.4 - Admin Plugin Backward Compatibility Plugin. We included this plugin created by lat9 into Reward Points to solve a compatibility issue once for all in zen cart v1.5.0, v1.5.1, v1.5.2, v1.5.3. ( Thanks to lat9. )

6.) Changes Added: Updated the _doc folder to reflect these changes.

7.) Changes Added: Updated the version number from 2.5b to 2.5c.

No major changes but would update the admin/orders.php file if you haven't already. It was really a bandaid solution to get Reward Point to show in admin/orders but now the right code has been implemented thanks to izar74.

If your Reward Points is working and you are happy live it as is..... :) If you have to upgrade your zen cart later on then look at using this version of Reward Points v2.5c.

[DivaVocals]

4.) Changes Added: Added pagination on the Reward Points page. It is not great but it will better than what came stock with reward points.

Does this resolve the issue of the Rewards Points page NOT showing all customers?? For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J".. I assume the pagination will now allow me to page through ALL the results??

[countrycharm]

Does this resolve the issue of the Rewards Points page NOT showing all customers?? For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J".. I assume the pagination will now allow me to page through ALL the results??

For example, I click on the "J" and the module currently will not bring in ALL the customers whose last name begins with "J

Yes it seems to. The only thing that need working on is looking up a last name or a first name from the search results. It still brings in last or first name results for whatever name you are looking for. I'll look into fixing that later.

The other little pet pea is how many Reward Points page customers to view per page results. You have to set it from by using Admin->Configuration->Maximum Values->Maximum Display of Customers on Customers Page. This is how it is done for now.

I know a bandaid solution but it does work for now.... :)

[LAWebDev]

I have installed Rewards Points (v 2.5b) for a client running Zen Cart v 1.5.1. Just one odd issue I'm having in the Admin configuration. The "Select mode:" and "Award points for new accounts?" boxes both fail to update the configuration.

In the browser dev tools Console, the error message is "Uncaught TypeError: Cannot set property 'value' of undefined." This happens in Chrome and IE 11. I am able to update other configuration settings successfully.

No one else seems to have mentioned an issue like this. Any thoughts on what could be going on?

[countrycharm]

I have installed Rewards Points (v 2.5b) for a client running Zen Cart v 1.5.1. Just one odd issue I'm having in the Admin configuration. The "Select mode:" and "Award points for new accounts?" boxes both fail to update the configuration.

In the browser dev tools Console, the error message is "Uncaught TypeError: Cannot set property 'value' of undefined." This happens in Chrome and IE 11. I am able to update other configuration settings successfully.

No one else seems to have mentioned an issue like this. Any thoughts on what could be going on?

I don't see that running a stock zen cart 1.5.4. Everything works correctly.
If I have time I will check it out on a clean version of 1.5.1.