+--------------------------------------------------------------------+
| CiviCRM version 4.7 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2016 |
+ | Copyright CiviCRM LLC (c) 2004-2017 |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
/**
*
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2016
- * $Id$
- *
+ * @copyright CiviCRM LLC (c) 2004-2017
*/
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
protected $_customGroupExtends = array('Case');
/**
- */
- /**
+ * Class constructor.
*/
public function __construct() {
$this->case_types = CRM_Case_PseudoConstant::caseType();
'fields' => array(
'client_name' => array(
'name' => 'sort_name',
- 'title' => ts('Client'),
+ 'title' => ts('Contact Name'),
'required' => TRUE,
),
'id' => array(
'required' => TRUE,
),
),
+ 'order_bys' => array(
+ 'client_name' => array(
+ 'title' => ts('Contact Name'),
+ 'name' => 'sort_name'
+ ),
+ ),
+ 'grouping' => 'case-fields',
),
'civicrm_case' => array(
'dao' => 'CRM_Case_DAO_Case',
'default' => 0,
),
),
+ 'order_bys' => array(
+ 'start_date' => array(
+ 'title' => ts('Start Date'),
+ ),
+ 'end_date' => array(
+ 'title' => ts('End Date'),
+ ),
+ 'status_id' => array(
+ 'title' => ts('Status'),
+ ),
+ ),
+ 'grouping' => 'case-fields'
),
'civicrm_contact' => array(
'dao' => 'CRM_Contact_DAO_Contact',
}
}
}
+ $this->_selectClauses = $select;
$this->_select = "SELECT " . implode(', ', $select) . " ";
}