[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  /**
   4   * @package     Joomla.Administrator
   5   * @subpackage  mod_privacy_dashboard
   6   *
   7   * @copyright   (C) 2018 Open Source Matters, Inc. <https://www.joomla.org>
   8   * @license     GNU General Public License version 2 or later; see LICENSE.txt
   9   */
  10  
  11  namespace Joomla\Module\PrivacyDashboard\Administrator\Helper;
  12  
  13  use Joomla\CMS\Factory;
  14  use Joomla\Database\Exception\ExecutionFailureException;
  15  
  16  // phpcs:disable PSR1.Files.SideEffects
  17  \defined('_JEXEC') or die;
  18  // phpcs:enable PSR1.Files.SideEffects
  19  
  20  /**
  21   * Helper class for admin privacy dashboard module
  22   *
  23   * @since  3.9.0
  24   */
  25  class PrivacyDashboardHelper
  26  {
  27      /**
  28       * Method to retrieve information about the site privacy requests
  29       *
  30       * @return  array  Array containing site privacy requests
  31       *
  32       * @since   3.9.0
  33       */
  34      public static function getData()
  35      {
  36          $db    = Factory::getDbo();
  37          $query = $db->getQuery(true)
  38              ->select(
  39                  [
  40                      'COUNT(*) AS count',
  41                      $db->quoteName('status'),
  42                      $db->quoteName('request_type'),
  43                  ]
  44              )
  45              ->from($db->quoteName('#__privacy_requests'))
  46              ->group($db->quoteName('status'))
  47              ->group($db->quoteName('request_type'));
  48  
  49          $db->setQuery($query);
  50  
  51          try {
  52              return $db->loadObjectList();
  53          } catch (ExecutionFailureException $e) {
  54              return [];
  55          }
  56      }
  57  }