- Posts: 12
- Thank you received: 0
Add Location and Coupon code in Emails and confirm
- Antonio Grazioli
- Topic Author
- Offline
- New Member
Less
More
10 years 1 month ago #42456
by Antonio Grazioli
Add Location and Coupon code in Emails and confirm was created by Antonio Grazioli
My company has several sites in Italy
It's quite important to see in the list of registrants which location they registered to (location_id)
and also which coupon code they used.
I wpould klike to add Location and Coupon to registrant info in the backend area and confirmation emails, so our employees can see where the user registered and which coupon he used...
i am fiddling with the confirmation pages and complete views, but no luck so far....
any help?
It's quite important to see in the list of registrants which location they registered to (location_id)
and also which coupon code they used.
I wpould klike to add Location and Coupon to registrant info in the backend area and confirmation emails, so our employees can see where the user registered and which coupon he used...
i am fiddling with the confirmation pages and complete views, but no luck so far....
any help?
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Online
- Administrator
10 years 1 month ago #42467
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Add Location and Coupon code in Emails and confirm
Hi Antonio
1. Go to Events Booking -> Configuration, find the config option Show Coupon code in Registrants List, set it to Yes. After that, coupon code will be showed on Registrants Management from back-end.
2. For location , find the config option Show Event Location in Email, set it to Yes and It will be showed in email.
That's all we can have at the moment (if you don't have these features, you might need to download latest version and upgrade it to yours site).
If you want to have other information displayed somewhere, you will need to find out how to customize code.
Regards,
Tuan
1. Go to Events Booking -> Configuration, find the config option Show Coupon code in Registrants List, set it to Yes. After that, coupon code will be showed on Registrants Management from back-end.
2. For location , find the config option Show Event Location in Email, set it to Yes and It will be showed in email.
That's all we can have at the moment (if you don't have these features, you might need to download latest version and upgrade it to yours site).
If you want to have other information displayed somewhere, you will need to find out how to customize code.
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Antonio Grazioli
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
10 years 1 month ago - 10 years 1 month ago #42471
by Antonio Grazioli
Replied by Antonio Grazioli on topic Add Location and Coupon code in Emails and confirm
SOLVED as well
Thanks a lot.
in the meantime I had found the two options named "Show Coupon code in Registrants List" and "Show Event Location in Email"
I missed them somehow
Then I made some edits in "/emailtemplates/individual_details.php" for the coupon code on email messages:
<?php
$db = JFactory::getDBO();
$sql = "SELECT c.code FROM #__eb_registrants r JOIN #__eb_coupons c ON r.coupon_id=c.id WHERE r.transaction_id='".$this->row->transaction_id."'";
$db->setQuery($sql);
$rowCoupon = $db->loadObject() ;
?>
<tr>
<td class="title_cell">
<?php echo 'Coupon' ?>
</td>
<td class="field_cell">
<?php echo $rowCoupon->code; ?>
</td>
</tr>
then, to get the Location in the admin pages ("Registrants List"):
I slightly modified the "registrants" model and its view to include the "city" field of the location, that's enough for us...
Thanks a lot.
in the meantime I had found the two options named "Show Coupon code in Registrants List" and "Show Event Location in Email"
I missed them somehow
Then I made some edits in "/emailtemplates/individual_details.php" for the coupon code on email messages:
<?php
$db = JFactory::getDBO();
$sql = "SELECT c.code FROM #__eb_registrants r JOIN #__eb_coupons c ON r.coupon_id=c.id WHERE r.transaction_id='".$this->row->transaction_id."'";
$db->setQuery($sql);
$rowCoupon = $db->loadObject() ;
?>
<tr>
<td class="title_cell">
<?php echo 'Coupon' ?>
</td>
<td class="field_cell">
<?php echo $rowCoupon->code; ?>
</td>
</tr>
then, to get the Location in the admin pages ("Registrants List"):
I slightly modified the "registrants" model and its view to include the "city" field of the location, that's enough for us...
Last edit: 10 years 1 month ago by Antonio Grazioli.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Online
- Administrator
10 years 1 month ago #42473
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Add Location and Coupon code in Emails and confirm
hehe, great. Congratulations !
Please Log in or Create an account to join the conversation.
- Antonio Grazioli
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
10 years 1 month ago - 10 years 1 month ago #42475
by Antonio Grazioli
Replied by Antonio Grazioli on topic Add Location and Coupon code in Emails and confirm
thanks ,
you can see it in action on:
www.pipeline.it/it/912-moc-10777-impleme...soft-sql-server-2012
there's a custom field called "Bring Your Own Device" (students can save 100 euros if they bring their notebook in classroom)
It triggers a special logo on event page
They have to use a special Coupon Code "BYOD". This code applies to every course that has this custom field enabled.
When they register to the course the code and location gets emailed
attachment: screenshot of Admin Area showing City and Coupon field in backend
you can see it in action on:
www.pipeline.it/it/912-moc-10777-impleme...soft-sql-server-2012
there's a custom field called "Bring Your Own Device" (students can save 100 euros if they bring their notebook in classroom)
It triggers a special logo on event page
They have to use a special Coupon Code "BYOD". This code applies to every course that has this custom field enabled.
When they register to the course the code and location gets emailed
attachment: screenshot of Admin Area showing City and Coupon field in backend
Last edit: 10 years 1 month ago by Antonio Grazioli.
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.