1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

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