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

DivaVocals:

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..:smile:)

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.

DivaVocals:

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.

izar74:

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

I modified the code:

> 
> With:
> 
> ```php
<?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

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.

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.

Well it's a start :D

**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.

countrycharm:

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??

DivaVocals:

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.... :)

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?

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?

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.

New version now available in the plugins' area Version: 25.d

1.) Bug in the pagination code in admin-->customers_reward_points.php file - Fixed reset button to properly go back to all customers.
Thanks to Ajeh
2.) Updated the _doc folder to reflect these changes.
3.) Updated the version number from 2.5c to 2.5d.

Small problem that I figured out but will drive folks crazy.

If you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.

In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.

Thanks for you work on this!!

delia:

Small problem that I figured out but will drive folks crazy.

If you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.

In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.

Thanks for you work on this!!

you click on the edit button, the entire list of customers display but when you get back to the page the actual customer is on, it's open and editable. If you click on the line/customer name that doesn't happen.
Not quite understanding what you are pointing out here.

In addition, the reward points page only shows the what's enabled in admin - changing the number of customers that are supposed to display does not work.
Sure it does...

If you are talking about showing how many customers to view at one time on the reward points page You can set by using Admin->Configuration->Maximum Values->Maximum Display of Customers on Customers Page.

I tested it and it works....

If something is wrong with it, would you mind sharing so everybody else knows what going on and how to fix it, or send it to me and I will add it to the next release...

There are two ways to click on a customer on the rewards page. You can click on the customer's name or any of the text on that line or you can click on the green edit button. If you are on page 2 or more, clicking on the line instead of the green button works fine. If you click on the edit button, the screen refreshes and you go back to page one. When you go back to the page where the customer is, then you see the boxes open for that customer. So if the action is supposed to be the same - change the edit button to match the other.
button: customers_reward_points.php?id=80&action=edit
link: ustomers_reward_points.php?page=1&id=80&action=edit

in the configuration:
Limit Maximum Customers on Listings
Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.

Changing that does not change anything so what you say makes sense - about the maximum numbers. Which means it needs removing?

From what I can tell on line 325 the code in RED is missing:

                  <?php echo '<a href="' . zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS, [B]zen_get_all_get_params(array('id', 'action')) .[/B] 'id=' . $customers->fields['customers_id'] . '&action=edit') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . '</a>'; ?>

thank ajeh! I knew it was simple. Just didn't take time to look at the code.

No problem ... glad you caught that as I did not even notice the issue ... :lookaroun

One other change is for the Update button on line 355:

    $contents = array('form' => zen_draw_form('customer_reward_point_admin', FILENAME_ADMIN_CUSTOMER_REWARD_POINTS,[B] zen_get_all_get_params(array('id', 'action')) .[/B] 'id='.$current_customer['customers_id'].'&action=update', 'post'));

Another change would be around line 229:

  echo '<td class="dataTableRow" width="3%" align="center" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);" onclick="document.location.href=\''.zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS, zen_get_all_get_params(array('customer_sort_index', 'action', 'id'[B], 'page'[/B])) . 'customer_sort_index='.chr(65+$loop)).'\'">'.chr(65+$loop).'</td>';

I am having an issue with installing the sql patch for this mod. I am getting errors that state:
Cannot insert configuration_key "" because it already exists

This is happening on all of the "INSERT INTO configuration" statements. As of now, nothing appears on the "Configuration > Reward Point Configuration" page except the heading. I am running ZC 1.5.4. Any help will be greatly appreciated.