1. Hugh is now back at work, more or less full time, after a slower than expected recovery from his neck surgery early this month. Obviously we have a backlog of support to clear, and are working as hard as we can to take care of it. If you have an unanswered thread more than 3 days old, please post one (and only one) "bump" on it, to move it in to our "last 3 days" list. If you have an unanswered issue in a forum you no longer have access to due to subscriptions timing out, please use the Contact Us form, and provide us with the URL to the thread.

I would like to create a custom module on my

Discussion in 'Subscriber Support' started by steemer473, Mar 17, 2011.

  1. steemer473 Member

    Level: Community
    I would like to create a custom module on my joomla site where I can pull values from my fabrik tables; I would like to count records in a table (e.g. total count of records with pending status, etc.). How do I go about doing this? Module should look something like this:

    Transaction Statistics:Total Pending Transactions: 4*
    Total Closed Transactions:6*
    Total Closed Pending Approval Transactions:6*

    *The values are from my fabrik tables
  2. steemer473 Member

    Level: Community
    friendly bump...
  3. troester Well-Known Member

    Level: Standard
    I suggest
    create a fabrik form (without table) and 3 calculation elements with code
    Code (text):
    $db =& JFactory::getDBO();
    $q="select count(*) from your-table WHERE your-condition";
    $db->setQuery($q);
    $x= $db->loadResult();
    return $x;
    Create a fabrik form module.

Share This Page