plugin to create a new booking field which is also displayed in List Bookings

8 months 3 weeks ago #46907 by pauldrijs
I wanted to add a field to the booking form that would also be displayed in the “list bookings” display but could not find an existing way of doing it. Custom Fields came close but put the value in the “notes” tab and not in the “list bookings" display.

I created a plugin to do what I need which basically uses Custom Fields to allow the user to enter the additional booking data but at the point where it writes the info to the “notes" tab I also write it to the appropriate jomres_contracts booking table (in j03020insertbooking.class.php).

I have attached it in case it is useful to anybody else. It works for me but I am no expert so if you use it then try it out on a non production system first and check it is ok for your needs.

Before using this plugin YOU MUST:

1. Manually create a column named “my_spare_column_1" of type TEXT in your __jomres_contracts SQL database table. You can use phpMyAdmin to do this.
2. You must also use the jomres backend/administrator control panel to create a custom field with the exact same name as is in this plugins en-GB language file (default is “ My_spare_column_1_custom_field_name").

There is a downside that I believe if you do an “Amend Booking” then that will not allow you to ammend the new field as the “notes” update is not done when ammending a booking. I can live with that. You may not.

It overrides some important booking core jomres files so feel free to re-apply the plugin changes to newer versions of jomres as they come and re-issue the plugin. The version name of the plugin reflects also the jomres version I applied it to. I have applied it to 9.10.1.

If you know of any easier way of achieving the same then let me know. Or if any of the jomres team think it is a bad idea to overried these jomres files in a plugin then just say so.


File Attachment:

File Name:
File Size:38 KB
The following user(s) said Thank You: Vince Wooll, donnacha
8 months 3 weeks ago #46911 by Vince Wooll
Thank you Paul.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files
8 months 3 weeks ago #46915 by donnacha
Sounds like very useful functionality.
8 months 3 weeks ago #46916 by Vince Wooll
That's reminded me to Sticky this post, don't want to lose it.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files
4 months 3 days ago #47128 by pauldrijs
Hi Vince et al,

See attached the plugin applied and now works with the current latest Jomres 9.12.0 version files.



Vince portrait smallaladar

Developed and maintained by Vince Wooll and Aladar Barthi, Jomres was initially conceived in early 2005 as a Mambo based solution to a client’s hotel management needs. While it wasn't originally expected to be an online booking system it quickly morphed into one as users requested more and more features.

As the number of feature requests grew Vince knew that he would need to dedicate more time to the project and in July 2005 Jomres was formally released as a commercial project. Since then, Jomres has become one of Mambo’s, and now Joomla’s, longest running projects. It has survived various versions of Mambo, then Joomla 1.0, 1.5, 1.6, 1.7, 2.5 and 3.

Aladar joined the project in 2010 after using Jomres for his own projects. He was active on the forum, helping other members of the community and eventually Vince invited him to join the team. He has since become an integral part of the project and has contributed significantly to it's development over the years.

Whilst not formally part of the Jomres project, Rodrigo Rocco and the team have become firm friends. Rod is a freelancer who specialises in doing custom work for Jomres users and developing custom plugins for the system that take advantage of it's modular design. He has built many useful extensions including his fabulous new Valentina Template Package.


Jomres and the Jomres Logo is trademarked and can't be used without written consent from the owner. is not affiliated with or endorsed by the Joomla! Project, Open Source Matters or the WordPress project. The Joomla! & WordPress names and logos are used under a limited license granted by Open Source Matters and the WordPress Projects.

© Copyright 2005 - 2018 Woollyinwales IT.