CRM/Report/Page/List.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 4.4                                                |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2013                                |
   8  +--------------------------------------------------------------------+
   9  | This file is a part of CiviCRM.                                    |
  10  |                                                                    |
  11  | CiviCRM is free software; you can copy, modify, and distribute it  |
  12  | under the terms of the GNU Affero General Public License           |
  13  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  14  |                                                                    |
  15  | CiviCRM is distributed in the hope that it will be useful, but     |
  16  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  17  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  18  | See the GNU Affero General Public License for more details.        |
  19  |                                                                    |
  20  | You should have received a copy of the GNU Affero General Public   |
  21  | License and the CiviCRM Licensing Exception along                  |
  22  | with this program; if not, contact CiviCRM LLC                     |
  23  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  24  | GNU Affero General Public License or the licensing of CiviCRM,     |
  25  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  26  +--------------------------------------------------------------------+
  27 */
  28
  29 /**
  30  *
  31  * @package CRM
  32  * @copyright CiviCRM LLC (c) 2004-2013
  33  * $Id$
  34  *
  35  */
  36
  37 /**
  38  * Page for displaying list of Reprot templates available
  39  */
  40 class CRM_Report_Page_List extends CRM_Core_Page {
  41
  42   public static function &info() {
  43     $sql = "
  44 SELECT  v.id, v.value, v.label, v.description, v.component_id,
  45         inst.id as instance_id, ifnull( SUBSTRING(comp.name, 5), 'Contact' ) as component_name
  46 FROM    civicrm_option_value v
  47 INNER JOIN civicrm_option_group g
  48         ON (v.option_group_id = g.id AND g.name = 'report_list')
  49 LEFT  JOIN civicrm_report_instance inst
  50         ON v.value = inst.report_id
  51 LEFT  JOIN civicrm_component comp
  52         ON v.component_id = comp.id
  53 WHERE     v.is_active = 1
  54 ORDER BY  v.weight";
  55
  56     $dao = CRM_Core_DAO::executeQuery($sql);
  57     $rows = array();
  58     while ($dao->fetch()) {
  59       $url = 'civicrm/report/';
  60       $rows[$dao->component_name][$dao->value]['title'] = $dao->label;
  61       $rows[$dao->component_name][$dao->value]['description'] = $dao->description;
  62       $rows[$dao->component_name][$dao->value]['url'] = CRM_Utils_System::url('civicrm/report/' . trim($dao->value, '/'), 'reset=1');
  63       if ($dao->instance_id) {
  64         $rows[$dao->component_name][$dao->value]['instanceUrl'] = CRM_Utils_System::url('civicrm/report/instance/list',
  65           "reset=1&ovid={$dao->id}"
  66         );
  67       }
  68     }
  69
  70     return $rows;
  71   }
  72
  73   /**
  74    * run this page (figure out the action needed and perform it).
  75    *
  76    * @return void
  77    */
  78   function run() {
  79     $rows = self::info();
  80     $this->assign('list', $rows);
  81
  82     return parent::run();
  83   }
  84 }
  85