How to change customer information/status after product order?

[delia]

I'm listed this as customer information because it's really just the outline I need. Actually, I'm wanting to change the permission status from the Category Specific Access Restriction plugin.

This will make the site a members site where they have to pay to get access. There's only one product - the subscription fee and once they pay the permission status would change automatically.

I'm thinking this could be done at the checkout success stage and would only take a couple of lines of an sql query.

On an additional note, that change would not normally be inserted into the session so that the customer would have to log out and log back in so adding to the existing session would also be of help.

If there is a better place to do this in the checkout process, let me know. If you happen to have some code, better still.

Thanks in advance.

[delia]

I do love answering my own questions and here's part of it

in the header_php.php for checkout_success I added these lines:

$customerID = $_SESSION['customer_id'];

$permissions_query = "UPDATE " . TABLE_CUSTOMERS . "
SET customers_privileges = 1
WHERE customers_id = '$customerID'";
$permissions = $db->Execute($permissions_query);

That worked to insert the correct permission. Then the next was to change the session variable so that they don't have to log out and log back in:

$_SESSION["customers_privileges"] = "1";

This has worked - my php skills may not be the greatest so if this needs tweaking, please tell me!

This can be used to change the person authorization level as well by substituting customers_authorization for customers_privileges.

[DrByte]

How about an observer class like this:

<?php
/**
 * observer class to set customer subscription status after purchase
 *
 * @package classes
 * @copyright Copyright 2003-2016 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Should work on zc v1.5 and 1.6 $
 */
class updateCustomerSubscriptionStatusAfterPurchase extends base {

 /**  
   * Attach observer class to the global $zco_notifier and watch for a single notifier event.
   */
  function __construct() {
    // Using NOTIFY_CHECKOUT_PROCESS_HANDLE_AFFILIATES because the $_SESSION['order_summary']['products_ordered_ids'] is set just before that.
    $this->attach($this, array('NOTIFY_CHECKOUT_PROCESS_HANDLE_AFFILIATES')); 

    $this->subscription_product_id = 77; // set the product_id of your subscription product here
    $this->subscribed_privilege_level = 1; // set the permission level to be granted by this product here
  }


 /**   
  * Actual Method that does the desired activity
  * Called by observed class when any of the notifiable events occur
  *
  * @param object $class
  * @param string $eventID
  * @param array $paramsArray
  */
  function update(&$class, $eventID, $paramsArray = array())
  {
    global $db;
    $customer_id = $_SESSION['customer_id'];
    $purchased_products_array = explode('|', $_SESSION['order_summary']['products_ordered_ids']);
    if (in_array($this->subscription_product_id, $purchased_products_array)) {
      $sql = "update " . TABLE_CUSTOMERS . "
              set customers_privileges = " . $this->subscribed_privilege_level . "
              where customers_id = " . (int)$customer_id;
      $db->Execute($sql);
      $_SESSION['customers_privileges'] = (int)$this->subscribed_privilege_level;
    }
  }

}

[delia]

Oh, my word!!!

Now that's elegant and I never ever would have gone there. That would go into classes > observers? Man, that's valuable info!

[DrByte]

Ya. /includes/classes/observers/class.updateCustomerSubscriptionStatusAfterPurchase.php

You'd need a config file for it too, depending what version of ZC you're using:
/includes/auto_loaders/config.updateCustomerSubscriptionStatusAfterPurchase.php

<?php/**
 * autoloader for updateCustomerSubscriptionStatusAfterPurchase observer
 *
 * @copyright Copyright 2003-2016 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
  */
$autoLoadConfig[190][] = array('autoType'=>'class',
                              'loadFile'=>'observers/class.updateCustomerSubscriptionStatusAfterPurchase.php');
$autoLoadConfig[190][] = array('autoType'=>'classInstantiate',
                              'className'=>'updateCustomerSubscriptionStatusAfterPurchase',
                              'objectName'=>'updateCustomerSubscriptionStatusAfterPurchase');

Related example: https://www.zen-cart.com/showthread....74#post1147074

[delia]

Good deal. l will try to make time to package up a mod for this. Super cool!