projects
/
civicrm-core.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
CRM-20368 case summary report
[civicrm-core.git]
/
CRM
/
Report
/
Form
/
Case
/
Summary.php
diff --git
a/CRM/Report/Form/Case/Summary.php
b/CRM/Report/Form/Case/Summary.php
index a5b625463ba1600c843fd6e864a9c61f47c6578f..2482254f3c32f2457dca4efd1532428e075f1218 100644
(file)
--- a/
CRM/Report/Form/Case/Summary.php
+++ b/
CRM/Report/Form/Case/Summary.php
@@
-3,7
+3,7
@@
+--------------------------------------------------------------------+
| CiviCRM version 4.7 |
+--------------------------------------------------------------------+
+--------------------------------------------------------------------+
| CiviCRM version 4.7 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-201
6
|
+ | Copyright CiviCRM LLC (c) 2004-201
7
|
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
@@
-28,9
+28,7
@@
/**
*
* @package CRM
/**
*
* @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 {
*/
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
@@
-41,8
+39,7
@@
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
protected $_customGroupExtends = array('Case');
/**
protected $_customGroupExtends = array('Case');
/**
- */
- /**
+ * Class constructor.
*/
public function __construct() {
$this->case_types = CRM_Case_PseudoConstant::caseType();
*/
public function __construct() {
$this->case_types = CRM_Case_PseudoConstant::caseType();
@@
-64,7
+61,7
@@
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
'fields' => array(
'client_name' => array(
'name' => 'sort_name',
'fields' => array(
'client_name' => array(
'name' => 'sort_name',
- 'title' => ts('C
lient
'),
+ 'title' => ts('C
ontact Name
'),
'required' => TRUE,
),
'id' => array(
'required' => TRUE,
),
'id' => array(
@@
-72,6
+69,13
@@
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
'required' => TRUE,
),
),
'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',
),
'civicrm_case' => array(
'dao' => 'CRM_Case_DAO_Case',
@@
-142,6
+146,18
@@
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
'default' => 0,
),
),
'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',
),
'civicrm_contact' => array(
'dao' => 'CRM_Contact_DAO_Contact',
@@
-215,6
+231,7
@@
class CRM_Report_Form_Case_Summary extends CRM_Report_Form {
}
}
}
}
}
}
+ $this->_selectClauses = $select;
$this->_select = "SELECT " . implode(', ', $select) . " ";
}
$this->_select = "SELECT " . implode(', ', $select) . " ";
}