1. Hugh (cheesegrits) here. Thank you for all the good wishes. My back surgery was a success, post-op recovery is going well, and I'm getting stronger and feeling better every day. I hope to be getting back in the saddle and working support again over the next few days.
  2. IMPORTANT NOTE - we have made some changes in our github branch naming. The 'master' branch no longer exists, and is now called 'joomla25' (which is Fabrik 3.0). The 'joomla3' branch (which is Fabrik 3.2) remains unchanged. We have also removed all the other testing branches which had accuulated over the last few years. I have posted a thread in the Community forum for 3.0 with some more information, feel free to as questions there.

I would like to create a custom module on my

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

  1. steemer473 New 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 New 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