I think I almost have it but need a bit of help. My client wants the referral ID showing on the invoice page. I've been taking stabs at it with limited success. In the admin/invoice.php file, I added a row below the payment method as follows:

The referral code did not show up but the "Key Code" label did. I tried adding the "coupon_code" to the $db->Execute above that to see if that helped but still no luck. Since I'm running out of guesses, I need help from someone who knows what they are doing <grin>.

How can I display the referral code?

Thanks,

Jim Smith

PS, BTW, nice new look to the Zen-cart.com web site!

Find the select statement in the /admin/invoice.php

      $order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
                                    customers_suburb, customers_city, customers_postcode,
                                    customers_state, customers_country, customers_telephone,
                                    customers_email_address, customers_address_format_id, delivery_name,
                                    delivery_company, delivery_street_address, delivery_suburb,
                                    delivery_city, delivery_postcode, delivery_state, delivery_country,
                                    delivery_address_format_id, billing_name, billing_company,
                                    billing_street_address, billing_suburb, billing_city, billing_postcode,
                                    billing_state, billing_country, billing_address_format_id,
                                    payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
                                    currency_value, date_purchased, orders_status, last_modified
                             from " . TABLE_ORDERS . "
                             where orders_id = '" . (int)$oID . "'");

coupon_code is not in there ... you need to add the field then you can call the Coupon Code used for that order with:

$order_check->fields['coupon_code']

Ajeh,
That took care of it. The same thing worked for adding the referral code to the packing slip if anyone is looking for that as well. Thanks!

Regards,

Jim Smith

Oops! I spoke too soon. What I wanted to show up on the invoice is the referral code, not the coupon code. I unsuccessfully tried a few variations like this:

While you could get the customer's referal code ... would this really have a desired effect as once the referral code is assigned to a customer it remains always the same ...

It would be easier to make a function to look-up the customers_referral from the customers table based on the orders customers_id ...

Then, you could just echo the function on the invoice.php ...

Ajeh:

While you could get the customer's referal code ... would this really have a desired effect as once the referral code is assigned to a customer it remains always the same ...

Yes it seems odd on the surface but this client prints each invoice as his record for sales. The referral code tells him which organization gets credit for that order. His staffers look at each day's invoices and generate a manual report based upon that. The Reports/Customer Referral report will be helpful for him to reconcile these reports but he still wants it to appear on each invoice as well.

Ajeh:

It would be easier to make a function to look-up the customers_referral from the customers table based on the orders customers_id ...

Then, you could just echo the function on the invoice.php ...

That's what I need some help with. I've tried to guess at it but coming up empty. Can I get some help putting that together?

Thanks,

Jim Smith

Ajeh:

It would be easier to make a function to look-up the customers_referral from the customers table based on the orders customers_id ...

Then, you could just echo the function on the invoice.php ...

Here's the closest unsuccessful guess I've hobbled together so far if that makes it easier:

===================

Thanks. js

Add a function to a new file and put it in the /admin/includes/functions/extra_functions

  function zen_get_orders_customers_referral($orders_id) {
    global $db;
    $sql = "SELECT customers_id from " . TABLE_ORDERS . " where orders_id='" . $orders_id . "'";
    $check_orders = $db->Execute($sql);
    $check_customers_id = $check_orders->fields['customers_id'];
    $sql = "SELECT customers_referral from " . TABLE_CUSTOMERS . " where customers_id='" . $check_customers_id . "'";
    $check_customers_referral = $db->Execute($sql);
    return $check_customers_referral->fields['customers_referral'];
  }

Then to see the results in /admin/invoice.php stick this inside a php area:

echo 'I SEE ' . zen_get_orders_customers_referral((int)$oID) . '<br>';

Ajeh,
That took care of it. Thanks!

Jim Smith

Glad that the new code could work for you ... thanks for the update ... :smile: