1. The forums have been upgraded to XenForo 1.4. Please post any issues or comments here.
  2. Our hosting provider will be performing some scheduled maintenance and upgrading during the early morning (US time) of Tue 28th July, starting at approx 2am EST, which will require some down time of the server.

I would like to create a custom module on my

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

  1. steemer473

    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

    steemer473 Member

    Level: Community
    friendly bump...
     
  3. troester

    troester Well-Known Member Staff 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