A couple of months ago I built a site where I had to create event registration functionality for 4 separate events. It was my first foray into the world of Ubercart. I needed to collect information from the user for their registration. I dreamed of a webform/ubercart hybrid solution and Voilå, here it is!
Thank you.

This has some fairly basic improvements, including the ability to use one rego form for multiple different tickets, listing unpaid/paid as a hidden field in the webform, so that it can be viewed in the table, and not hardcoding the unique id number (ie. cid=15):

This bit goes in the webform "Additional Processing" section

//Get data from form submission. Form also needs a hidden "rego_paid" form, that defaults to "unpaid"
$rego_name   = $form_state['values']['submitted_tree']['rego_name'];
$rego_group  = $form_state['values']['submitted_tree']['rego_group'];
$rego_ticket = $form_state['values']['submitted_tree']['rego_ticket'];
$webform_id  = $form_state['values']['details']['nid'];
 
//Only add one rego to cart
$quantity = 1;
 
//nicify the regoname, as a safe token, and make a date+name based unique submission id
$rego_id = $rego_name . " (" . $rego_group . ")";
$rego_key = date('YmdHis') . preg_replace("/[^a-zA-Z]/", "", $rego_name);
<?php //DO NOT INCLUDE <?php tags 
//Push the unique id back into the form, so that the webform submission can be fround from the product
$new_key = array_pop(array_keys($form_state['values']['submitted'])) + 1;
$form_state['values']['submitted'][$new_key] = $rego_key;
 
//Node id of the corresponding product for this event's fees, depends on the "ticket price" drop-down. 
//KEYS NEED TO MATCH!
//One day
if ($rego_ticket == "one_day") {
  $nid = 15; }
//Two Day
elseif ($rego_ticket == "two_day") {
  $nid = 16; }
 
//attributes: 1 = rego name, 2 = webformID, 3=unique key
$data = array('attributes' => array(1 => $rego_id, 2 => $rego_key, 3 => $webform_id));
 
//UC API call
uc_cart_add_item($nid, $quantity, $data);

Conditional Action:
Predicate: on payment received
Condition: if order balance

Action:

foreach ($order->products as $item) {
  if ($item->data['attributes']['Booking for']) {
    $nid = $item->data['attributes']['webform_id'][0];
    $reg = $item->data['attributes']['Booking ID'][0];
 
   //Get the webform submission ID for the product
    $result = db_query("SELECT `sid` FROM `webform_submitted_data` WHERE `nid` = %d AND `data` = '%s' LIMIT 1", $nid, $reg);
    $sid = db_result($result);
 
   //get the field ID (cid) for rego_paid field for the webform
    $result = db_query("SELECT `cid` FROM `webform_component` WHERE `nid` = %d AND `form_key` = '%s' LIMIT 1", $nid, 'rego_paid');
    $cid = db_result($result);
 
    db_query("UPDATE `webform_submitted_data` SET `data` = '%s' WHERE `nid` = %d AND `sid` = %d AND `cid` = %d", 'paid', $nid, $sid, $cid);
 
    drupal_set_message("Your registration fees have been paid. Thank you.");
  }
}

also, if you're not going to include <br /> tags in your filter html input format for comments, you should include automatic line breaks!

Hi guys,

I'm in a similar, but different situation. My ubercart install is Drupal 5 and my webform content is on a D6 site. So, I used your approach in conjunction with the cart links ubercart trickery, and thought I'd post the code here.

My D6 webforms now must contain 2 hidden fields to allow the 2 drupal systems to communicate:

- rego_form_build_id

- rego_paid

The advanced processing PHP snippet is:

// Get some internal webform values.
$webform_id = $form_values['details']['nid'];
$build_id = str_replace('form-','', $form_values['form_build_id']); // remove 'form-' from the front so cart links dont get confused by the hyphen.

// Save the save these values to a hidden form component (WHICH YOU ADD YOURSELF) called 'rego_form_build_id.
// This stores the value in the database, so the external CART system can retrieve the correct submission.
$build_component_cid = 8; // Customise this component id depending on which component it is in your form.

$form_values['submitted'][$build_component_cid] = $build_id; // Save this val with the form submission.

// Build the hidden attributes portion of the cart link URL. syntax = _a#o#_
// Attribute IDs 1 and 2 are defined as follows, respectively, in the external CART system:
// uc_attribute id 1 = 'webform_nid'
// uc_attribute id 2 = 'webform_token' (or build id)
$cart_link_attrs = 'a1o'. $webform_id. '_a2o'. $build_id;

// CUSTOMISE FORM LOGIC TO ADD APPROPRIATE TICKET/ATTRIBUTE TO USERS CART

if ($form_values['submitted_tree']['ticket_type'] == 'VAL01') {
$node->webform['confirmation'] = 'http://www.domain.com/bookshop/cart/add/e-p150_q1_'. $cart_link_attrs .'_iCARTLINK1?destination=cart';
}
else {
$node->webform['confirmation'] = 'http://www.domain.com/bookshop/cart/add/e-p151_q1_'. $cart_link_attrs .'_iCARTLINK2?destination=cart';
}

?>

The action on the ubercart system presumes the existance of these attributes (like the other scripts on this page).
Conditional Action: Predicate: on payment received Condition: if order balance

foreach ($order->products as $item) {
if ($item->data['attributes']['Webform ID']) {

$nid = $item->data['attributes']['Webform ID'];
$build = $item->data['attributes']['Form build ID'];

// Get the webform submission ID for the product
$result = db_query("SELECT `sid` FROM `webform_submitted_data` WHERE `nid` = %d AND `data` = '%s' LIMIT 1", $nid, $build);
$sid = db_result($result);

// Get the field ID (cid) for rego_paid field for the webform
$result = db_query("SELECT `cid` FROM `webform_component` WHERE `nid` = %d AND `form_key` = '%s' LIMIT 1", $nid, 'rego_paid');
$cid = db_result($result);

db_query("UPDATE `webform_submitted_data` SET `data` = '%s' WHERE `nid` = %d AND `sid` = %d AND `cid` = %d", 'yes', $nid, $sid, $cid);

}

} // end for

?>

I encountered a few problems with this approach. First problem was with the cart links module. The version I'm using only accepts integers as attribute values and options. The form ID worked, but the form build ID didn't. So I applied this patch (http://drupal.org/node/560358) to allow the cart links module to accept strings as options. Now my form_build_id was passed properly through the cark link module.

Next problem was with the default display of product attributes in ubercart. I'm not sure of the severity of this as a security risk (?), but I didn't really want the hidden attributes visible to the users for aesthetic reasons, so I added a javascript which loads only on the /cart page as follows (drupal 5):

$(document).ready(function() {
 $(".cart-options > li:contains('Webform ID')").hide();
 $(".cart-options > li:contains('Form build ID')").hide();
});

I was lucky in that both of my drual instances use table prefixing in the same database and I could execute PHP directly from the action. However, I couldn't think what the solution would be for people who have 2 completely separate instances and databases?Would they need to write a module to expose the webform API via the Services module? switch databases and perform queries or is there a preferred way to bootstrap another drupal instance from a PHP snippet?

Marty