Create link to submission from order and vice versa

Agreed - This would be very useful from my user's perspective.

+1
my users really need some way to see which submissions correspond to which orders, preferably by uc order id.

Here's a patch:

• Add join table {uc_event_registration_submissions} with an update to hook_schema and relevant hook_update_N
• Add hook_order ( uc_event_registration_order() ) to keep join table up to date when order is updated.

I have purposely left out a script that populates the join table from existing orders, because for sites with a great number of orders this could be inefficient and cause the update script to timeout or memory out or fail otherwise. If people are interested in this, i'd suggest a drush script or similar that populates the data. (I'll be writing one of these for my own use case that i will post.)

To dos:

• expose order id on webform submissions
• expose submission id on orders
• expose these data to views through webform views and uc views

Thanks for the patch.
However, for me i need this for reporting, so just sticking an anchor in the product description is not sufficient.
I need the uc order id exposed to webform views or in the default webform reports,
and i need the submission id exposed to uc views or in the default ubercart reports.

... So the issue was:

The users need to see the actual order from the webform results list. Has this been accomplished? I really don't care as much about listing the submission from order.. The users don't care about that. They want to see if someoneone who registered fro an event checked out and paid.. !

does the patch actually accomplish that?

@AndyF:
I see the link "View containing order" on the webform´s submission page. I can click it and go to admin/store/orders/%.
But here I cannot see the link "View submitted form data".

Where should it be?

(Have the latest dev)

Thanks!

The idea was: Instead of just paid / unpaid status (not actual order status, btw, confusing) on the webform results.. there was supposed to be a link from the webform result tab line item.. to the order.. or at the least, the order id so you could track down the order..

Uh - so there still isn't a link from webform results to the actual order, correct? How is this then fixed / closed?

@warpedrive: in case you´re answering my comment: the link from the webform result to the order is OK but not "vice versa". That is the link from the order to the webform result. It´s simply not there.

Thanks AndyF for your response.
I checked everything as you told me, but still no link in the order screen to the webform submission.
You say the link should appear in the product column at the end of the description - I have only the title of the product here. Maybe I´m missing something?
A screenshot with a functional link would perhaps open my eyes...

Thanks again

Well.. I installed and ran the latest -dev update.. and the updater crashed.. got a number of warnings, and..
Still no link or even a listing of an order id in the webform results table.. or anywhere else.
Did seem to add an attendee attributes field to some - but not all - of the existing classes.
Going to have to say that this is open , and the updater isn't in good shape..

AndyF,

1. fetched your new version (checked that)
2. updated database --> OK
3. updated schema definition of table uc_event_registration_submissions with your query
4. cleared all caches
5. ordered a new product of content type "paidevent"

Still no link from the order screen to the webform submission. Everything remained as before the update...

Thanks again!

@AndiF,
did the whole thing once again and switched step 3 and 2 - sorry - no difference - no matter whether old or new orders..
Here are the results of your queries:

Query: SELECT * FROM uc_orders WHERE order_id = $order_id;
Result:

"order_id";"uid";"order_status";"order_total";"product_count";"primary_email";"delivery_first_name";"delivery_last_name";"delivery_phone";"delivery_company";"delivery_street1";"delivery_street2";"delivery_city";"delivery_zone";"delivery_postal_code";"delivery_country";"billing_first_name";"billing_last_name";"billing_phone";"billing_company";"billing_street1";"billing_street2";"billing_city";"billing_zone";"billing_postal_code";"billing_country";"payment_method";"data";"created";"modified";"host";"currency"
"7";"1";"pending";"200.00000";"1";;;;;;;;;"0";;"840";;;;;;;;"0";;"840";"check";"a:1:{s:13:\"complete_sale\";s:9:\"logged_in\";}";"1340798667";"1340798671";"...";"USD"

Query: SELECT * FROM uc_order_products WHERE order_id = $order_id;
Result:

"order_product_id";"order_id";"nid";"title";"manufacturer";"model";"qty";"cost";"price";"weight";"data"
"16";"7";"195";"Kunden-Finder-Analyse";;"KFA";"1";"0.00000";"200.00000";"0";"a:3:{s:10:\"attributes\";a:0:{}s:21:\"uc_event_registration\";a:1:{s:3:\"sid\";s:3:\"262\";}s:6:\"module\";s:10:\"uc_product\";}"

Query: SELECT * FROM uc_event_registration_submissions WHERE order_id = $order_id;
Result:

"sid";"order_id";"order_product_id"
"262";"7";"16"

Query: DESCRIBE uc_event_registration_submissions;
Result:

"Field","Type","Null","Key","Default","Extra",,
"sid","int(10) unsigned","NO","PRI","NULL",,," "
"order_id","int(10) unsigned","NO"," ","NULL",,," "
"order_product_id","int(10) unsigned","NO","PRI","NULL",,," "

Hope that helps...

AndiF,
JavaScript Console says "zero".

Here´s the message after applying the patch and reloading the order screen of order 7:

product =>

... (Object) stdClass
order_product_id (String, 2 characters ) 16
order_id (String, 1 characters ) 7
nid (String, 3 characters ) 195
title (String, 21 characters ) Kunden-Finder-Analyse
manufacturer (String, 0 characters )
model (String, 3 characters ) KFA
qty (String, 1 characters ) 1
cost (String, 7 characters ) 0.00000
price (String, 9 characters ) 200.00000
weight (String, 1 characters ) 0
data (Array, 3 elements)
order_uid (String, 1 characters ) 1
Called from /var/customers/webs/Leicht/entwicklung/sites/all/modules/uc_event_registration/uc_event_registration.module, line 297  

submission =>

... (Object) stdClass
sid (String, 3 characters ) 262
nid (String, 3 characters ) 195
submitted (String, 10 characters ) 1340798654
remote_addr (String, 14 characters ) 188.194.41.210
uid (String, 1 characters ) 1
name (String, 8 characters ) wbdesign
is_draft (String, 1 characters ) 0
data (Array, 5 elements)
Called from /var/customers/webs/Leicht/entwicklung/sites/all/modules/uc_event_registration/uc_event_registration.module, line 302  

And of course:
Success

"display-related UC modules"? examples?
Patch didn´t change anything - no error, no message, except those of devel ;-)
I´m actually using Garland...
Sorry for not having positive news.

AndiF,
thanks for your hint concerning display-related modules.
It´s definitely the ECO - module that causes the disappearing of the link.
Found the hook_product_description_alter() in the file eco.module. I did not try to switch module weights. I simply uninstalled ECO - and the Link "View submitted form data" appeared.
Don´t know whether swtiching module weight would make both modules work together? (I don´t really need ECO anymore as soon as uc_event_registration works... - and don´t know how to switch the weight of modules...)
If there´s something I can still do for you, let me now (eg. switch module´s weights?)
Thanks for your support!
Wiegand