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