4 +--------------------------------------------------------------------+
5 | CiviCRM version 4.4 |
6 +--------------------------------------------------------------------+
7 | Copyright CiviCRM LLC (c) 2004-2013 |
8 +--------------------------------------------------------------------+
9 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
32 * @copyright CiviCRM LLC (c) 2004-2013
38 * Page for displaying list of Reprot templates available
40 class CRM_Report_Page_List
extends CRM_Core_Page
{
42 public static function &info() {
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
56 $dao = CRM_Core_DAO
::executeQuery($sql);
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}"
74 * run this page (figure out the action needed and perform it).
80 $this->assign('list', $rows);