Fix indentation

[civicrm-core.git] / CRM / Report / Form / Contribute / Lybunt.php

diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php
index c819ed9bfe023e55d2eb3d323d70da5cb6ac9e0d..46328672380e73b8c45ba5771f2835e61f59c2d9 100644 (file)
--- a/CRM/Report/Form/Contribute/Lybunt.php
+++ b/CRM/Report/Form/Contribute/Lybunt.php
@@ -46,7 +46,9 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form {
   public $_drilldownReport = array('contribute/detail' => 'Link to Detail Report');
 
   protected $lifeTime_from = NULL;
-  protected $lifeTime_where = NULL; function __construct() {
+  protected $lifeTime_where = NULL;
+
+  function __construct() {
     $yearsInPast   = 10;
     $yearsInFuture = 1;
     $date          = CRM_Core_SelectValues::date('custom', NULL, $yearsInPast, $yearsInFuture);
@@ -139,7 +141,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form {
             'options' => $optionYear,
             'default' => date('Y'),
           ),
-          'financial_type_id' => array( 
+          'financial_type_id' => array(
             'title' => ts('Financial Type'),
             'operatorType' => CRM_Report_Form::OP_MULTISELECT,
             'options' => CRM_Contribute_PseudoConstant::financialType(),
@@ -226,13 +228,13 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form {
 
     $this->_from = "
         FROM  civicrm_contribution  {$this->_aliases['civicrm_contribution']}
-              INNER JOIN civicrm_contact {$this->_aliases['civicrm_contact']} 
+              INNER JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
                       ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_contribution']}.contact_id
               {$this->_aclFrom}
-              LEFT  JOIN civicrm_email  {$this->_aliases['civicrm_email']} 
+              LEFT  JOIN civicrm_email  {$this->_aliases['civicrm_email']}
                       ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_email']}.contact_id AND
-                         {$this->_aliases['civicrm_email']}.is_primary = 1 
-              LEFT  JOIN civicrm_phone  {$this->_aliases['civicrm_phone']} 
+                         {$this->_aliases['civicrm_email']}.is_primary = 1
+              LEFT  JOIN civicrm_phone  {$this->_aliases['civicrm_phone']}
                       ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND
                          {$this->_aliases['civicrm_phone']}.is_primary = 1 ";
   }
@@ -249,8 +251,8 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form {
           $clause = NULL;
           if ($fieldName == 'yid') {
             $clause = "contribution_civireport.contact_id NOT IN
-(SELECT distinct contri.contact_id FROM civicrm_contribution contri 
- WHERE contri.is_test = 0 AND " . self::fiscalYearOffset('contri.receive_date') . " = $current_year) AND contribution_civireport.contact_id IN (SELECT distinct contri.contact_id FROM civicrm_contribution contri 
+(SELECT distinct contri.contact_id FROM civicrm_contribution contri
+ WHERE contri.is_test = 0 AND " . self::fiscalYearOffset('contri.receive_date') . " = $current_year) AND contribution_civireport.contact_id IN (SELECT distinct contri.contact_id FROM civicrm_contribution contri
  WHERE " . self::fiscalYearOffset('contri.receive_date') . " = $previous_year AND contri.is_test = 0)";
           }
           elseif (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE) {
@@ -300,7 +302,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form {
     $statistics = parent::statistics($rows);
     if (!empty($rows)) {
       $select = "
-                      SELECT 
+                      SELECT
                             SUM({$this->_aliases['civicrm_contribution']}.total_amount ) as amount ";
 
       $sql = "{$select} {$this->_from} {$this->_where}";