Drupal Commerce Need Function To Retrieve Customer Profile Fields From Commerce Order

Question

I want to display some info from the Customer Profile (Customer Number, Contact Number) whenever the shopping cart view displays. I can see these fields in 'People' but obviously they are -extended- fields... when I run this:

$my_user = user_load( $user->uid );

...I get the field names for the data I want, but not the values.

I -thought- I could do this...

$order = commerce_cart_order_load($user->uid);

...and then somehow get to the customer_profile like so:

commerce_customer_profile_load ($profile_id);

...but I have no idea how to connect the $order or the global $user->uid with the $profile_id

How does one do this?

Again, I just need to retrieve the string values of Customer Number and Contact Number.

TIA,

---JC

Answer 1

There are probably a few different ways to bridge that gap but here are the first 2 that spring to mind:

1. Use commerce_customer_profile_load_multiple instead, and make use of the $conditions parameter, e.g.

   $profiles = commerce_customer_profile_load_multiple(array(), array('uid' => $order->uid));
   
   foreach ($profiles as $profile) {
     // Make sure this is the correct profile (users can have multiple profiles)
     // and extract the field values as you would with any entity (field_get_items())
   }
   

   But the $conditions array is deprecated for core entities so probably will be for commerce entities too at some point.

2. Use an EntityFieldQuery to get the profiles, e.g.

   $query = new EntityFieldQuery();
   $query->entityCondition('entity_type', 'commerce_customer_profile')
     ->propertyCondition('uid', $order->uid);
   
   $results = $query->execute();
   
   if (!empty($results['commerce_customer_profile'])) {
     $profiles = commerce_customer_profile_load_multiple(array_keys($results['commerce_customer_profile']));
   
     foreach ($profiles as $profile) {
       // ...
     }
   }
   

Answer 2

You can also use entity_metadata_wrappers:

$order = commerce_cart_order_load($user->uid);
$order_wrapper = entity_metadata_wrapper('commerce_order', $order);
$billing_profile_wrapper = $order_wrapper->commerce_customer_billing;

So now you have your profile wrapped in an entity_metadata_wrapper in the var $billing_profile_wrapper. Since it's a entity_metadata_wrapper, we can access it's field really easy:

$billing_profile_wrapper->field_name_you_need->value();

More info on entity_metadata_wrapper's:

• http://www.pixelite.co.nz/article/how-use-entity-metadata-wrappers-drupal-7/
• http://www.mediacurrent.com/blog/entity-metadata-wrapper

Feel free to add more links, these are just the ones I like the most

Answer 3

If you have the $order object, then...

$profile_id = $order->commerce_customer_billing[LANGUAGE_NONE][0]['profile_id'];

Answer 4

You may need this information outside the context of a commerce order. I worked this out to get the profile ID associated to a User. You will need to loop through results if you get more than one:

NOTE: field_profile is the name of the Customer reference profile field on my User accounts.

<?php

  global $user;
  $uid = $user->uid;
  $query = db_select("field_data_field_profile","p");
  $query->fields("p",array("field_profile_profile_id"));
  $query->condition("entity_id",$uid);
  $output = $query->execute()->fetchObject();

  $profile_id = $output->field_profile_profile_id;
  if(!empty($profile_id)){
    $profile_info = commerce_customer_profile_load ($profile_id);
  }