gistfile1.php

    $filters = $this->getUser()->getAttribute('organization.filters',
        null, 'admin_module');
    $configuration = new organizationGeneratorConfiguration();
    $filtersObj = $configuration->getFilterForm($filters);

    $tableMethod = $configuration->getTableMethod();
                    
    $filtersObj->setTableMethod($tableMethod);
                    
    $query = $filtersObj->buildQuery($filters);
    $alias = $query->getRootAlias();
    $query->InnerJoin("$alias.BookOrders o WITH o.organization_id = $alias.id");
    $query->addSelect("SUM(o.total) AS total_sales");
    $query->addSelect("SUM(o.commission_total) AS total_commission");