Paying for events and memberships with Ubercart

Interesting. And where does the webform_civicrm module come into this? Or does it?

hi jt - very interested in this idea as a client is wanting to stick with selling Memberships via U/C even after we wire them in to CiviCRM.
We had tried out uc_civicrm_product but I found I wasn't getting full integration with civi eg contacts were being created not updated if they exists, but seemed to get around that by also using uc_civicrm. So odd that both you and merlise seem to be functioning without uc_civicrm - but that discussion belongs on another thread.
Your module may be the missing link since I wasn't able to include Custom Data fields with the above modules.
Let me know how/when we can help with testing etc.

We did something similar- using Webform-civicrm to register participants for an event, then using ubercart to allow them to pay for it. We didn't use uc_civicrm_product (since it appears that it won't work quite for event registrations yet). Note that this is for D6, civi 3.46 , not the D7 version that this issue is categorized as.

Here's how:
1. Build a civicrm-enabled webform with all the fields you need.

2. Create a product representing payment for your event. Give it an option/attribute "Participant ID" ( I also gave mine 2 other options: the participants name, and the event name).

3. After submitting the form, send the user to a custom url (in the 'webform settings' tab):
apply/process/%sid

4. using hook_menu within a custom module, map this url to a function:

  $items['apply/process/%'] = array(  
    'title' => " Create Cart ", 
    'description' => 'Create Cart', 
    'page callback' => 'custommodule_apply_process',
    'page arguments' => array(1),
    'access arguments' => array('access content'),
    'weight' => -11,
  );  

5. Create a 'custommodule_apply_process' function like this. It adds an item to the cart:
( I used cart links, but I think you can also use UC's cart_add funtion.)
Populate the Participant ID field with CiviEvent's participant_id ( other attribute fields too, if you like).

  $submission = webform_menu_submission_load($sid, '3292');  // this is the nid of my civicrm_webform
  $cid1 = $submission->data[11]['value'][0];  // 11 is the component id of the cid of the contact- a hidden field on the form
  $params = array('version' => 3, 'contact_id' => $cid1, 'sequential'=>1 ,'participant_status_id' =>5); // 5 = payment pending

  civicrm_initialize(true);
  include_once('api/api.php');
  $participant = civicrm_api('Participant', 'get', $params); // Fetching the participant record

  $person_name = rawurlencode($participant['values'][0]['display_name']);  //  These three are the options
  $event_name = rawurlencode($participant['values'][0]['event_title']);         //   in the UC product:
  $participant_id = $participant['values'][0]['id'];                                          // participantID, name, event


  $product_string= "p3254_a1o".$person_name."_a2o".$event_name."_a3o".$participant_id;  // Add to cart

  drupal_goto('cart/add/'.$product_string,'destination=cart/checkout/'.$sid);  //send the user to the cart to pay!

6. Last step: switch the participant registration Status from "Payment Pending" to "Registered" using conditional actions. Our trigger was 'payment is entered' , the conditions were "Order balance is 0 or less" ; and for the action, we required a 'Custom PHP' type action:

foreach ($order->products as $deposit_item ){  // We actually only collect a deposit from event registrants
  if ($participant_id = $deposit_item->data['attributes']['Participant ID'][0]){
    civicrm_initialize(true);
    include_once('api/api.php');
    $results=civicrm_api("Participant","create", array ('version' =>'3', 'id' =>$participant_id, 'participant_status_id' =>'1'));

     if (!$results['error']) {
        drupal_set_message('Payment accepted, '.$deposit_item->data['attributes']["Participant Name"][0].' successfully registered for VISIONS '.$deposit_item->data['attributes']["Program"][0]." Program");
     }else {
        drupal_set_message('Error: '.$results['error_message']);
    }
  }
}

This gets around webform_civi not handling payment for events.

Edit: this part in strikeout doesn't work, see Coleman's note below:
The only dicey part is in step 5, where it uses the contact_id and registration status (payment pending) to fetch the participant ID. If the user somehow several events that they have registered for but are in 'payment pending' status for both of them, this method could retrieve the wrong record. This can be resolved by defining a webform field:
civicrm_1_participant_1_participant_participant_id
( see your admin/help/webform_civicrm "ANATOMY OF A FORM KEY - for geeks only" to see how this works)
... and then, in step 5, use this participant ID instead of contact ID + registration status to retrieve the record.

I hope this can work for anyone needing it.

Nice writeup, thanks for sharing.
Re the last point: unfortunately, fields that aren't defined in the webform_civicrm_fields() function won't be processed, so you can't just add your own element and have everything work, even if you name it properly.
Perhaps in future we can work on that.

You're right, using "civicrm_1_participant_1_participant_participant_id" instead of contact_id component wasn't working. So we have to rely on there not being duplicate participant registrations for the same contact with the same participant_status.

Unfortunately that field wouldn't be simple to add, because it can be multivalued (we allow the event form element to be checkboxes/multiselect).
I think a better solution would be to use the civicrm post hook. Everything you need should be available there (check if it's your webform submission with : if ($_GET['q'] == 'node/3292')
And this way you could handle more than one event.

hi joseph - not sure whether to comment here or http://drupal.org/project/uc_webform

I finally got around to trialling this

What we had was
uc_civicrm
uc_civicrm_product

outcome was, products (memberships) bought via ubercart did add/update memberships in civicrm

but now we need to collect other data when purchasing the membership and i thought of trying the uc_webform module

outcome: webform does indeed result in the product (which had been set up with civicrm membership) being added to the cart, but upon completion of payment nothing is being added to civicrm - unlike when we just start with a civicrm-ised product

any thoughts where to start pulling things apart?

do you still have this working since you said "Memberships have worked perfectly in our testing"

When i put the product in to my cart via both routes, i get the following

as a civicrm-ised Product

a:5:{s:10:"civimember";a:5:{s:18:"membership_type_id";s:1:"1";s:4:"pfid";s:1:"5";s:3:"nid";s:4:"4056";s:20:"membership_status_id";s:1:"1";s:6:"uccmid";s:1:"2";}s:10:"attributes";a:0:{}s:9:"shippable";s:1:"0";s:13:"donate_amount";N;s:6:"module";s:10:"uc_product";}

as a civicrm-ised webform product

a:5:{s:11:"webform_sid";s:1:"3";s:11:"webform_nid";s:4:"4060";s:13:"webform_ctype";s:7:"product";s:11:"webform_cid";s:1:"1";s:6:"module";s:10:"uc_product";}

Thanks Joseph - i think we concluded much the same and went the track of doing some custom code to accomplish this via Attributes in the Product where we were able to pull/push data from/to civicrm successfully and get Membership created/renewed and get Address details updated.

Is there any update here for CiviCRM on D7, possibly with Drupal Commerce?

What about the Commerce Webform Module, would this help? https://drupal.org/project/commerce_webform

Not aware of D7 for this - my sense is this project is 'in limbo' - in terms of Commerce_webform - there would be a bunch of work required in a new module to set up all the API stuff afaik

Thanks for the answer.

Has anyone created a stand alone webform that sends data to CiviCRM-events with price sets, then?

I have some complex needs for a webform design, where CiviCRM kinda lacks finesse. Was hoping I could leverage webform, but then the payment end of it is messed up.

Any work on payments would be welcome. Kind of the missing link with webform and events. Commerce definitely has a lot more momentum than Ubercart these days. Another approach might be to build off the entity work that is going on: http://civicrm.org/blogs/eileen/civicrm-entities-drupal-entities

I think we can close this issue in favor of http://civicrm.org/make-it-happen#Drupal%20Webform%20Payment%20Integration