How do I make Invoice-Only Customers not see PayPal as a payment choice?

[scottmcclean]

Dear all,

I use two types of payment method - Invoice Only and PayPal Express.

I would like customers who belong to the "Invoice" group just to get the option of "invoice". Currently Invoice customers are getting the additional option of using paypal and I dont want this.

Is there a way of being able to not show paypal as a payment method for Invoice only customers? I am not a coder so if there is a possible solution to this I would really appreciate the help.


Many thanks

[DrByte]

I would like customers who belong to the "Invoice" group just to get the option of "invoice".

How are you telling Zen Cart that these customers are "invoice only"?

[scottmcclean]

Hi DrByte,
I use the Invoice Payment Module for ZenCart 1.3 in conjunction with the Group Pricing Per Item Module. All the elements working brilliantly I just dont want the customers who are assigned to the Invoice group to see the paypal option.

I have attached some images to better illustrate.

[swguy]

The invoice payment module has logic in it to only enable it for customers in a group whose name starts with "invoice". Copy this logic to paypal and invert it so that paypal only appears to customers who are NOT in a group whose name starts with invoice.

[scottmcclean]

Hi - what you say makes sense, but I have no idea what I would need to do to make it happen.

could i get some help with the code?

[scottmcclean]

Hi is anyone able to assist with this?

[DrByte]

Simple to do:
a) I downloaded the invoice plugin
b) I looked at the update_status() code
c) I copied the code there that handles the group detection
d) I changed the final check for false to true, since you're looking for the opposite effect
e) the end result when added to the PayPal EC module is:

  function update_status() {
    global $order, $db;
    if ($this->enabled && (int)$this->zone > 0) {
      $check_flag = false;
      $sql = "SELECT zone_id
              FROM " . TABLE_ZONES_TO_GEO_ZONES . "
              WHERE geo_zone_id = :zoneId
              AND zone_country_id = :countryId
              ORDER BY zone_id";
      $sql = $db->bindVars($sql, ':zoneId', $this->zone, 'integer');
      $sql = $db->bindVars($sql, ':countryId', $order->billing['country']['id'], 'integer');
      $check = $db->Execute($sql);
      while (!$check->EOF) {
        if ($check->fields['zone_id'] < 1) {
          $check_flag = true;
          break;
        } elseif ($check->fields['zone_id'] == $order->billing['zone_id']) {
          $check_flag = true;
          break;
        }
        $check->MoveNext();
      }

      if (!$check_flag) {
        $this->enabled = false;
      }

      // module cannot be used for purchase > $10,000 USD
      $order_amount = $this->calc_order_amount($order->info['total'], 'USD');
      if ($order_amount > 10000) $this->enabled = false;
      if ($order->info['total'] == 0) $this->enabled = false;
      
      // disable for invoice-only customers
      $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
      if ($this->enabled == true) {
        $check_flag_group = false;
        $check = $db->Execute("select group_name from " . TABLE_GROUP_PRICING . " where group_id = '" . $group_query->fields['customers_group_pricing'] . "'");
        if ($check->RecordCount() ==  1) {
          $invoice_prefix = "invoice";
          $check_prefix = substr($check->fields['group_name'], 0, strlen($invoice_prefix));
          if (strcasecmp($check_prefix, $invoice_prefix) == 0) {
            $check_flag_group = true;
          }
        }
        if ($check_flag_group == true) {
          $this->enabled = false;
        }
      }
      
    }
  }

Shameless reminder: Donations always welcome: www.zen-cart.com/donate

[scottmcclean]

Dr Byte, thank you very much for taking the time to help, much appreciated.

I have copied this code to the paypalwpp.php and paypaldp.php pages which were the only ones I could find with the code: ( // module cannot be used for purchase > $10,000 USD). I have uploaded the pages but I am still getting the paypal payment option.

Clearly I am doing somthing wrong. Are the 2 pages I updated the correct ones?

[DrByte]

The code I quoted was tested successfully in, and copied-and-posted-from the paypalwpp.php file (which is the express checkout module).

And the paypaldp.php file (payments pro) should work by making the same change.

[scottmcclean]

Hi Dr Byte,
thanks for your reply. I have zero doubts that you are right it, I just cant figure out what I may have done wrong.

I have attached the code I have added in to the paypalwpp.php file - I just copied/paste. I would appreciate your thoughts - could it be a difference in a database field name or something like that?