Ordering Tariffs

1 year 7 months ago #46622 by webaza
Ordering Tariffs was created by webaza
There are any way to order the tariff (advanced micromanage tariffs) from date to ?

If i create 3 tariff
They show in this order in frontend but after if i create a tariff like April
the tariff finish at the end, but i need to show before may.

There are any solutions?


Please Log in or Create an account to join the conversation.

1 year 7 months ago #46623 by Mirko
Replied by Mirko on topic Ordering Tariffs
Hi, try to edit the j06000show_property_tariffs.class.php:
$query = 'SELECT `rates_uid`,`rate_title`,`rate_description`,`validfrom`,`validto`,`roomrateperday`,`mindays`,`maxdays`,`minpeople`,`maxpeople`,`roomclass_uid`,
			`ignore_pppn`,`allow_ph`,`allow_we`	FROM #__jomres_rates WHERE property_uid = ' .$property_uid.' ORDER BY rate_title,roomclass_uid,validto';
and edit the ORDER BY to your requirements (eg. ORDER BY validto).
And don't forget to copy it to remote_plugins/custom_code

Please Log in or Create an account to join the conversation.

1 year 7 months ago #46624 by webaza
Replied by webaza on topic Ordering Tariffs
Thanks a lot Mirko,
i forgot that i have the file in the custom_code folder and when i try to change the db order they not changing.
Now is ok.

Please Log in or Create an account to join the conversation.


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.