Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Conditionally totals in Submission Directory

Conditionally totals in Submission Directory 4 years 11 months ago #40188

  • rubenl
  • rubenl's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
Hi,

We created a form to make a reservation on a specific date. Now we would like to see the total when we log in to de directory front end. Found a script to see totals:
$db = JFactory::getDBO();
 
$db->setQuery("SELECT SUM((`FieldValue`))  FROM XXXXX_rsform_submission_values WHERE `FieldName`='Aantal' AND `FormId`='3'");
$directoryLayout.="  Totaal aantal reserveringen:  " . "" . $db->loadResult() . "<br/>";

There's also a fieldname 'Date' I would like to see how many people (can make a reservation for mare than 1) we can expect. Is there a way to add a condition to a query?

[Edit]It would be even greater if de shown totals are the totals of the list showed; the search field could be used as filter. Anybody an idea[/edit]
Last Edit: 4 years 11 months ago by rubenl. Reason: Filter
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!