[civicrm-core.git] / CRM / Report / Form / Event / Income.php

<?php

/*
 +--------------------------------------------------------------------+
 | CiviCRM version 4.6                                                |
 +--------------------------------------------------------------------+
 | Copyright CiviCRM LLC (c) 2004-2014                                |
 +--------------------------------------------------------------------+
 | This file is a part of CiviCRM.                                    |
 |                                                                    |
 | CiviCRM is free software; you can copy, modify, and distribute it  |
 | under the terms of the GNU Affero General Public License           |
 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
 |                                                                    |
 | CiviCRM is distributed in the hope that it will be useful, but     |
 | WITHOUT ANY WARRANTY; without even the implied warranty of         |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
 | See the GNU Affero General Public License for more details.        |
 |                                                                    |
 | You should have received a copy of the GNU Affero General Public   |
 | License and the CiviCRM Licensing Exception along                  |
 | with this program; if not, contact CiviCRM LLC                     |
 | at info[AT]civicrm[DOT]org. If you have questions about the        |
 | GNU Affero General Public License or the licensing of CiviCRM,     |
 | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
 +--------------------------------------------------------------------+
*/

/**
 *
 * @package CRM
 * @copyright CiviCRM LLC (c) 2004-2014
 * $Id$
 *
 */
class CRM_Report_Form_Event_Income extends CRM_Report_Form_Event {
  const ROW_COUNT_LIMIT = 2;

  protected $_summary = NULL;
  protected $_noFields = TRUE;

  protected $_add2groupSupported = FALSE;

  /**
   *
   */
  /**
   *
   */
  public function __construct() {

    $this->_columns = array(
      'civicrm_event' => array(
        'dao' => 'CRM_Event_DAO_Event',
        'filters' => array(
          'id' => array(
            'title' => ts('Event'),
            'operatorType' => CRM_Report_Form::OP_ENTITYREF,
            'type' => CRM_Utils_Type::T_INT,
            'attributes' => array('select' => array('minimumInputLength' => 0)),
          ),
        ),
      ),
    );

    parent::__construct();
  }

  public function preProcess() {
    $this->_csvSupported = FALSE;
    parent::preProcess();
  }

  /**
   * @param $eventIDs
   */
  public function buildEventReport($eventIDs) {

    $this->assign('events', $eventIDs);

    $eventID = implode(',', $eventIDs);

    $participantStatus  = CRM_Event_PseudoConstant::participantStatus(NULL, "is_counted = 1");
    $participantRole    = CRM_Event_PseudoConstant::participantRole();
    $paymentInstruments = CRM_Contribute_PseudoConstant::paymentInstrument();

    $rows = $eventSummary = $roleRows = $statusRows = $instrumentRows = $count = array();

    $optionGroupDAO = new CRM_Core_DAO_OptionGroup();
    $optionGroupDAO->name = 'event_type';
    $optionGroupId = NULL;
    if ($optionGroupDAO->find(TRUE)) {
      $optionGroupId = $optionGroupDAO->id;
    }
    //show the income of active participant status (Counted = filter = 1)
    $activeParticipantStatusIDArray = $activeParticipantStatusLabelArray = array();
    foreach ($participantStatus as $id => $label) {
      $activeParticipantStatusIDArray[] = $id;
      $activeParticipantStatusLabelArray[] = $label;
    }
    $activeParticipantStatus = implode(',', $activeParticipantStatusIDArray);
    $activeparticipnatStutusLabel = implode(', ', $activeParticipantStatusLabelArray);
    $activeParticipantClause = " AND civicrm_participant.status_id IN ( $activeParticipantStatus ) ";

    $sql = "
            SELECT  civicrm_event.id                    as event_id,
                    civicrm_event.title                 as event_title,
                    civicrm_event.max_participants      as max_participants,
                    civicrm_event.start_date            as start_date,
                    civicrm_event.end_date              as end_date,
                    civicrm_option_value.label          as event_type,
                    civicrm_participant.fee_currency    as currency,
                    SUM(civicrm_participant.fee_amount) as total,
                    COUNT(civicrm_participant.id)       as participant

            FROM       civicrm_event
            LEFT JOIN  civicrm_option_value
                   ON  ( civicrm_event.event_type_id = civicrm_option_value.value AND
                         civicrm_option_value.option_group_id = {$optionGroupId} )
            LEFT JOIN  civicrm_participant ON ( civicrm_event.id = civicrm_participant.event_id
                       {$activeParticipantClause} AND civicrm_participant.is_test  = 0 )

            WHERE      civicrm_event.id IN( {$eventID})

            GROUP BY   civicrm_event.id
            ";

    $eventDAO = CRM_Core_DAO::executeQuery($sql);
    $currency = array();
    while ($eventDAO->fetch()) {
      $eventSummary[$eventDAO->event_id]['Title'] = $eventDAO->event_title;
      $eventSummary[$eventDAO->event_id]['Max Participants'] = $eventDAO->max_participants;
      $eventSummary[$eventDAO->event_id]['Start Date'] = CRM_Utils_Date::customFormat($eventDAO->start_date);
      $eventSummary[$eventDAO->event_id]['End Date'] = CRM_Utils_Date::customFormat($eventDAO->end_date);
      $eventSummary[$eventDAO->event_id]['Event Type'] = $eventDAO->event_type;
      $eventSummary[$eventDAO->event_id]['Event Income'] = CRM_Utils_Money::format($eventDAO->total, $eventDAO->currency);
      $eventSummary[$eventDAO->event_id]['Registered Participant'] = "{$eventDAO->participant} ({$activeparticipnatStutusLabel})";
      $currency[$eventDAO->event_id] = $eventDAO->currency;
    }
    $this->assign_by_ref('summary', $eventSummary);

    //Total Participant Registerd for the Event
    $pariticipantCount = "
            SELECT COUNT(civicrm_participant.id ) as count, civicrm_participant.event_id as event_id

            FROM     civicrm_participant

            WHERE    civicrm_participant.event_id IN( {$eventID}) AND
                     civicrm_participant.is_test  = 0
                     {$activeParticipantClause}
            GROUP BY civicrm_participant.event_id
             ";

    $counteDAO = CRM_Core_DAO::executeQuery($pariticipantCount);
    while ($counteDAO->fetch()) {
      $count[$counteDAO->event_id] = $counteDAO->count;
    }

    //Count the Participant by Role ID for Event
    $role = "
            SELECT civicrm_participant.role_id         as ROLEID,
                   COUNT( civicrm_participant.id )     as participant,
                   SUM(civicrm_participant.fee_amount) as amount,
                   civicrm_participant.event_id        as event_id,
                   civicrm_participant.fee_currency    as currency
            FROM     civicrm_participant

            WHERE    civicrm_participant.event_id IN ( {$eventID}) AND
                     civicrm_participant.is_test  = 0
                     {$activeParticipantClause}
            GROUP BY civicrm_participant.role_id, civicrm_participant.event_id
            ";

    $roleDAO = CRM_Core_DAO::executeQuery($role);

    while ($roleDAO->fetch()) {
      // fix for multiple role, CRM-6507
      $roles = explode(CRM_Core_DAO::VALUE_SEPARATOR, $roleDAO->ROLEID);
      foreach ($roles as $roleId) {
        if (!isset($roleRows[$roleDAO->event_id][$participantRole[$roleId]])) {
          $roleRows[$roleDAO->event_id][$participantRole[$roleId]]['total'] = 0;
          $roleRows[$roleDAO->event_id][$participantRole[$roleId]]['round'] = 0;
          $roleRows[$roleDAO->event_id][$participantRole[$roleId]]['amount'] = 0;
        }
        $roleRows[$roleDAO->event_id][$participantRole[$roleId]]['total'] += $roleDAO->participant;
        $roleRows[$roleDAO->event_id][$participantRole[$roleId]]['amount'] += $roleDAO->amount;
      }
    }

    foreach ($roleRows as $eventId => $roleInfo) {
      foreach ($participantRole as $roleName) {
        if (isset($roleInfo[$roleName])) {
          $roleRows[$eventId][$roleName]['round'] = round(($roleRows[$eventId][$roleName]['total'] / $count[$eventId]) * 100, 2);
        }
        if (!empty($roleRows[$eventId][$roleName])) {
          $roleRows[$eventId][$roleName]['amount'] = CRM_Utils_Money::format($roleRows[$eventId][$roleName]['amount'], $currency[$eventId]);
        }
      }
    }

    $rows['Role'] = $roleRows;

    //Count the Participant by status ID for Event
    $status = "
            SELECT civicrm_participant.status_id       as STATUSID,
                   COUNT( civicrm_participant.id )     as participant,
                   SUM(civicrm_participant.fee_amount) as amount,
                   civicrm_participant.event_id        as event_id

            FROM     civicrm_participant

            WHERE    civicrm_participant.event_id IN ({$eventID}) AND
                     civicrm_participant.is_test  = 0
                     {$activeParticipantClause}
            GROUP BY civicrm_participant.status_id, civicrm_participant.event_id
            ";

    $statusDAO = CRM_Core_DAO::executeQuery($status);

    while ($statusDAO->fetch()) {
      $statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['total'] = $statusDAO->participant;
      $statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['round'] = round(($statusDAO->participant / $count[$statusDAO->event_id]) * 100, 2);
      $statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['amount'] = CRM_Utils_Money::format($statusDAO->amount, $currency[$statusDAO->event_id]);
    }

    $rows['Status'] = $statusRows;

    //Count the Participant by payment instrument ID for Event
    //e.g. Credit Card, Check,Cash etc
    $paymentInstrument = "
            SELECT c.payment_instrument_id               as INSTRUMENT,
                   COUNT( civicrm_participant.id )       as participant,
                   SUM( civicrm_participant.fee_amount ) as amount,
                   civicrm_participant.event_id          as event_id

            FROM      civicrm_participant,
            civicrm_participant_payment pp
            LEFT JOIN civicrm_contribution c ON ( pp.contribution_id = c.id)

            WHERE     civicrm_participant.event_id IN ( {$eventID} )
                      AND civicrm_participant.is_test  = 0
                      {$activeParticipantClause}
                      AND ((pp.participant_id = civicrm_participant.id )
                           OR (pp.participant_id = civicrm_participant.registered_by_id ))
            GROUP BY  c.payment_instrument_id, civicrm_participant.event_id
            ";

    $instrumentDAO = CRM_Core_DAO::executeQuery($paymentInstrument);

    while ($instrumentDAO->fetch()) {
      //allow only if instrument is present in contribution table
      if ($instrumentDAO->INSTRUMENT) {
        $instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['total'] = $instrumentDAO->participant;
        $instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['round'] = round(($instrumentDAO->participant / $count[$instrumentDAO->event_id]) * 100, 2);
        $instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['amount'] = CRM_Utils_Money::format($instrumentDAO->amount, $currency[$instrumentDAO->event_id]);
      }
    }
    $rows['Payment Method'] = $instrumentRows;

    $this->assign_by_ref('rows', $rows);
    if (!$this->_setVariable) {
      $this->_params['id_value'] = NULL;
    }
    $this->assign('statistics', $this->statistics($eventIDs));
  }

  /**
   * @param $eventIDs
   *
   * @return array
   */
  public function statistics(&$eventIDs) {
    $statistics = array();
    $count = count($eventIDs);
    $this->countStat($statistics, $count);
    if ($this->_setVariable) {
      $this->filterStat($statistics);
    }

    return $statistics;
  }

  /**
   * @param int $rowCount
   */
  public function limit($rowCount = self::ROW_COUNT_LIMIT) {
    parent::limit($rowCount);

    //modify limit
    $pageId = $this->get(CRM_Utils_Pager::PAGE_ID);

    //if pageId is greator than last page then display last page.
    if ((($pageId * self::ROW_COUNT_LIMIT) - 1) > $this->_rowsFound) {
      $pageId = ceil((float) $this->_rowsFound / (float) self::ROW_COUNT_LIMIT);
      $this->set(CRM_Utils_Pager::PAGE_ID, $pageId);
    }
    $this->_limit = ($pageId - 1) * self::ROW_COUNT_LIMIT;
  }

  /**
   * @param int $rowCount
   */
  public function setPager($rowCount = self::ROW_COUNT_LIMIT) {
    $params = array(
      'total' => $this->_rowsFound,
      'rowCount' => self::ROW_COUNT_LIMIT,
      'status' => ts('Records %%StatusMessage%%'),
      'buttonBottom' => 'PagerBottomButton',
      'buttonTop' => 'PagerTopButton',
      'pageID' => $this->get(CRM_Utils_Pager::PAGE_ID),
    );

    $pager = new CRM_Utils_Pager($params);
    $this->assign_by_ref('pager', $pager);
  }

  public function postProcess() {
    $this->beginPostProcess();
    $this->_setVariable = TRUE;

    $noSelection = FALSE;
    if (empty($this->_params['id_value'])) {
      $this->_params['id_value'] = array();
      $this->_setVariable = FALSE;

      $events = CRM_Event_PseudoConstant::event(NULL, NULL,
        "is_template = 0"
      );
      if (empty($events)) {
        return FALSE;
      }
      foreach ($events as $key => $dnt) {
        $this->_params['id_value'][] = $key;
      }
      $noSelection = TRUE;
    }
    elseif (!is_array($this->_params['id_value'])) {
      $this->_params['id_value'] = explode(',', $this->_params['id_value']);
    }

    $this->_rowsFound = count($this->_params['id_value']);

    //set pager and limit if output mode is html
    if ($this->_outputMode == 'html') {
      $this->limit();
      $this->setPager();

      $showEvents = array();
      $count      = 0;
      $numRows    = $this->_limit;

      if (CRM_Utils_Array::value('id_op', $this->_params, 'in') == 'in' || $noSelection) {
        while ($count < self::ROW_COUNT_LIMIT) {
          if (!isset($this->_params['id_value'][$numRows])) {
            break;
          }

          $showEvents[] = $this->_params['id_value'][$numRows];
          $count++;
          $numRows++;
        }
      } elseif ($this->_params['id_op'] == 'notin') {
        $events = CRM_Event_PseudoConstant::event(NULL, NULL,
          "is_template = 0"
        );

        $showEvents = array_diff(array_keys($events), $this->_params['id_value']);
      }

      $this->buildEventReport($showEvents);

    }
    else {
      $this->buildEventReport($this->_params['id_value']);
    }

    parent::endPostProcess();
  }
}
Commit	Line	Data
6a488035	1	<?php
6a488035 TO	2
	3	/*
	4	+--------------------------------------------------------------------+
39de6fd5	5	\| CiviCRM version 4.6 \|
6a488035	6	+--------------------------------------------------------------------+
06b69b18	7	\| Copyright CiviCRM LLC (c) 2004-2014 \|
6a488035 TO	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
06b69b18	32	* @copyright CiviCRM LLC (c) 2004-2014
6a488035 TO	33	* $Id$
	34	*
	35	*/
	36	class CRM_Report_Form_Event_Income extends CRM_Report_Form_Event {
7da04cde	37	const ROW_COUNT_LIMIT = 2;
6a488035 TO	38
	39	protected $_summary = NULL;
	40	protected $_noFields = TRUE;
a5611c8e DL	41
	42	protected $_add2groupSupported = FALSE;
	43
74cf4551 EM	44	/**
	45	*
	46	*/
	47	/**
	48	*
	49	*/
00be9182	50	public function __construct() {
6a488035 TO	51
6a488035 TO	52	$this->_columns = array(
2107cde9	53	'civicrm_event' => array(
6a488035	54	'dao' => 'CRM_Event_DAO_Event',
2107cde9 CW	55	'filters' => array(
	56	'id' => array(
	57	'title' => ts('Event'),
	58	'operatorType' => CRM_Report_Form::OP_ENTITYREF,
6a488035	59	'type' => CRM_Utils_Type::T_INT,
2107cde9	60	'attributes' => array('select' => array('minimumInputLength' => 0)),
6a488035 TO	61	),
	62	),
	63	),
	64	);
a5611c8e	65
6a488035 TO	66	parent::__construct();
	67	}
	68
00be9182	69	public function preProcess() {
6a488035 TO	70	$this->_csvSupported = FALSE;
	71	parent::preProcess();
	72	}
	73
74cf4551 EM	74	/**
	75	* @param $eventIDs
	76	*/
00be9182	77	public function buildEventReport($eventIDs) {
6a488035 TO	78
	79	$this->assign('events', $eventIDs);
	80
	81	$eventID = implode(',', $eventIDs);
	82
	83	$participantStatus = CRM_Event_PseudoConstant::participantStatus(NULL, "is_counted = 1");
	84	$participantRole = CRM_Event_PseudoConstant::participantRole();
	85	$paymentInstruments = CRM_Contribute_PseudoConstant::paymentInstrument();
	86
	87	$rows = $eventSummary = $roleRows = $statusRows = $instrumentRows = $count = array();
	88
	89	$optionGroupDAO = new CRM_Core_DAO_OptionGroup();
	90	$optionGroupDAO->name = 'event_type';
	91	$optionGroupId = NULL;
	92	if ($optionGroupDAO->find(TRUE)) {
	93	$optionGroupId = $optionGroupDAO->id;
	94	}
	95	//show the income of active participant status (Counted = filter = 1)
	96	$activeParticipantStatusIDArray = $activeParticipantStatusLabelArray = array();
	97	foreach ($participantStatus as $id => $label) {
	98	$activeParticipantStatusIDArray[] = $id;
	99	$activeParticipantStatusLabelArray[] = $label;
	100	}
	101	$activeParticipantStatus = implode(',', $activeParticipantStatusIDArray);
	102	$activeparticipnatStutusLabel = implode(', ', $activeParticipantStatusLabelArray);
	103	$activeParticipantClause = " AND civicrm_participant.status_id IN ( $activeParticipantStatus ) ";
	104
	105	$sql = "
	106	SELECT civicrm_event.id as event_id,
	107	civicrm_event.title as event_title,
a5611c8e	108	civicrm_event.max_participants as max_participants,
6a488035	109	civicrm_event.start_date as start_date,
a5611c8e DL	110	civicrm_event.end_date as end_date,
a5611c8e DL	111	civicrm_option_value.label as event_type,
33207fc5	112	civicrm_participant.fee_currency as currency,
6a488035 TO	113	SUM(civicrm_participant.fee_amount) as total,
	114	COUNT(civicrm_participant.id) as participant
	115
	116	FROM civicrm_event
a5611c8e	117	LEFT JOIN civicrm_option_value
6a488035 TO	118	ON ( civicrm_event.event_type_id = civicrm_option_value.value AND
6a488035 TO	119	civicrm_option_value.option_group_id = {$optionGroupId} )
a5611c8e	120	LEFT JOIN civicrm_participant ON ( civicrm_event.id = civicrm_participant.event_id
6a488035 TO	121	{$activeParticipantClause} AND civicrm_participant.is_test = 0 )
6a488035 TO	122
a5611c8e DL	123	WHERE civicrm_event.id IN( {$eventID})
a5611c8e DL	124
6a488035 TO	125	GROUP BY civicrm_event.id
6a488035 TO	126	";
33207fc5	127
6a488035	128	$eventDAO = CRM_Core_DAO::executeQuery($sql);
7baf6261	129	$currency = array();
6a488035 TO	130	while ($eventDAO->fetch()) {
	131	$eventSummary[$eventDAO->event_id]['Title'] = $eventDAO->event_title;
	132	$eventSummary[$eventDAO->event_id]['Max Participants'] = $eventDAO->max_participants;
	133	$eventSummary[$eventDAO->event_id]['Start Date'] = CRM_Utils_Date::customFormat($eventDAO->start_date);
	134	$eventSummary[$eventDAO->event_id]['End Date'] = CRM_Utils_Date::customFormat($eventDAO->end_date);
	135	$eventSummary[$eventDAO->event_id]['Event Type'] = $eventDAO->event_type;
33207fc5	136	$eventSummary[$eventDAO->event_id]['Event Income'] = CRM_Utils_Money::format($eventDAO->total, $eventDAO->currency);
6a488035	137	$eventSummary[$eventDAO->event_id]['Registered Participant'] = "{$eventDAO->participant} ({$activeparticipnatStutusLabel})";
7baf6261	138	$currency[$eventDAO->event_id] = $eventDAO->currency;
6a488035 TO	139	}
	140	$this->assign_by_ref('summary', $eventSummary);
	141
	142	//Total Participant Registerd for the Event
	143	$pariticipantCount = "
	144	SELECT COUNT(civicrm_participant.id ) as count, civicrm_participant.event_id as event_id
	145
	146	FROM civicrm_participant
	147
a5611c8e DL	148	WHERE civicrm_participant.event_id IN( {$eventID}) AND
a5611c8e DL	149	civicrm_participant.is_test = 0
6a488035 TO	150	{$activeParticipantClause}
	151	GROUP BY civicrm_participant.event_id
	152	";
	153
	154	$counteDAO = CRM_Core_DAO::executeQuery($pariticipantCount);
	155	while ($counteDAO->fetch()) {
	156	$count[$counteDAO->event_id] = $counteDAO->count;
	157	}
	158
	159	//Count the Participant by Role ID for Event
	160	$role = "
a5611c8e DL	161	SELECT civicrm_participant.role_id as ROLEID,
a5611c8e DL	162	COUNT( civicrm_participant.id ) as participant,
6a488035	163	SUM(civicrm_participant.fee_amount) as amount,
7baf6261	164	civicrm_participant.event_id as event_id,
7baf6261	165	civicrm_participant.fee_currency as currency
6a488035 TO	166	FROM civicrm_participant
	167
	168	WHERE civicrm_participant.event_id IN ( {$eventID}) AND
a5611c8e	169	civicrm_participant.is_test = 0
6a488035 TO	170	{$activeParticipantClause}
	171	GROUP BY civicrm_participant.role_id, civicrm_participant.event_id
	172	";
	173
	174	$roleDAO = CRM_Core_DAO::executeQuery($role);
	175
	176	while ($roleDAO->fetch()) {
	177	// fix for multiple role, CRM-6507
	178	$roles = explode(CRM_Core_DAO::VALUE_SEPARATOR, $roleDAO->ROLEID);
	179	foreach ($roles as $roleId) {
	180	if (!isset($roleRows[$roleDAO->event_id][$participantRole[$roleId]])) {
	181	$roleRows[$roleDAO->event_id][$participantRole[$roleId]]['total'] = 0;
	182	$roleRows[$roleDAO->event_id][$participantRole[$roleId]]['round'] = 0;
	183	$roleRows[$roleDAO->event_id][$participantRole[$roleId]]['amount'] = 0;
	184	}
	185	$roleRows[$roleDAO->event_id][$participantRole[$roleId]]['total'] += $roleDAO->participant;
	186	$roleRows[$roleDAO->event_id][$participantRole[$roleId]]['amount'] += $roleDAO->amount;
	187	}
	188	}
	189
	190	foreach ($roleRows as $eventId => $roleInfo) {
	191	foreach ($participantRole as $roleName) {
	192	if (isset($roleInfo[$roleName])) {
	193	$roleRows[$eventId][$roleName]['round'] = round(($roleRows[$eventId][$roleName]['total'] / $count[$eventId]) * 100, 2);
	194	}
a38dd72d RK	195	if (!empty($roleRows[$eventId][$roleName])) {
	196	$roleRows[$eventId][$roleName]['amount'] = CRM_Utils_Money::format($roleRows[$eventId][$roleName]['amount'], $currency[$eventId]);
	197	}
6a488035 TO	198	}
6a488035 TO	199	}
2f4c2f5d	200
6a488035 TO	201	$rows['Role'] = $roleRows;
	202
	203	//Count the Participant by status ID for Event
	204	$status = "
a5611c8e DL	205	SELECT civicrm_participant.status_id as STATUSID,
a5611c8e DL	206	COUNT( civicrm_participant.id ) as participant,
6a488035 TO	207	SUM(civicrm_participant.fee_amount) as amount,
	208	civicrm_participant.event_id as event_id
	209
	210	FROM civicrm_participant
	211
	212	WHERE civicrm_participant.event_id IN ({$eventID}) AND
a5611c8e	213	civicrm_participant.is_test = 0
6a488035 TO	214	{$activeParticipantClause}
	215	GROUP BY civicrm_participant.status_id, civicrm_participant.event_id
	216	";
	217
	218	$statusDAO = CRM_Core_DAO::executeQuery($status);
	219
	220	while ($statusDAO->fetch()) {
	221	$statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['total'] = $statusDAO->participant;
	222	$statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['round'] = round(($statusDAO->participant / $count[$statusDAO->event_id]) * 100, 2);
7baf6261	223	$statusRows[$statusDAO->event_id][$participantStatus[$statusDAO->STATUSID]]['amount'] = CRM_Utils_Money::format($statusDAO->amount, $currency[$statusDAO->event_id]);
6a488035 TO	224	}
	225
	226	$rows['Status'] = $statusRows;
	227
	228	//Count the Participant by payment instrument ID for Event
	229	//e.g. Credit Card, Check,Cash etc
	230	$paymentInstrument = "
a5611c8e	231	SELECT c.payment_instrument_id as INSTRUMENT,
9341d544 DL	232	COUNT( civicrm_participant.id ) as participant,
9341d544 DL	233	SUM( civicrm_participant.fee_amount ) as amount,
6a488035 TO	234	civicrm_participant.event_id as event_id
6a488035 TO	235
9341d544 DL	236	FROM civicrm_participant,
9341d544 DL	237	civicrm_participant_payment pp
6a488035 TO	238	LEFT JOIN civicrm_contribution c ON ( pp.contribution_id = c.id)
6a488035 TO	239
9341d544 DL	240	WHERE civicrm_participant.event_id IN ( {$eventID} )
9341d544 DL	241	AND civicrm_participant.is_test = 0
6a488035	242	{$activeParticipantClause}
9341d544 DL	243	AND ((pp.participant_id = civicrm_participant.id )
9341d544 DL	244	OR (pp.participant_id = civicrm_participant.registered_by_id ))
6a488035 TO	245	GROUP BY c.payment_instrument_id, civicrm_participant.event_id
	246	";
	247
	248	$instrumentDAO = CRM_Core_DAO::executeQuery($paymentInstrument);
	249
	250	while ($instrumentDAO->fetch()) {
	251	//allow only if instrument is present in contribution table
	252	if ($instrumentDAO->INSTRUMENT) {
	253	$instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['total'] = $instrumentDAO->participant;
	254	$instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['round'] = round(($instrumentDAO->participant / $count[$instrumentDAO->event_id]) * 100, 2);
9341d544	255	$instrumentRows[$instrumentDAO->event_id][$paymentInstruments[$instrumentDAO->INSTRUMENT]]['amount'] = CRM_Utils_Money::format($instrumentDAO->amount, $currency[$instrumentDAO->event_id]);
6a488035 TO	256	}
	257	}
	258	$rows['Payment Method'] = $instrumentRows;
	259
	260	$this->assign_by_ref('rows', $rows);
	261	if (!$this->_setVariable) {
	262	$this->_params['id_value'] = NULL;
	263	}
	264	$this->assign('statistics', $this->statistics($eventIDs));
	265	}
	266
74cf4551 EM	267	/**
	268	* @param $eventIDs
	269	*
	270	* @return array
	271	*/
00be9182	272	public function statistics(&$eventIDs) {
6a488035 TO	273	$statistics = array();
	274	$count = count($eventIDs);
	275	$this->countStat($statistics, $count);
	276	if ($this->_setVariable) {
	277	$this->filterStat($statistics);
	278	}
	279
	280	return $statistics;
	281	}
	282
74cf4551 EM	283	/**
	284	* @param int $rowCount
	285	*/
00be9182	286	public function limit($rowCount = self::ROW_COUNT_LIMIT) {
6a488035 TO	287	parent::limit($rowCount);
	288
	289	//modify limit
	290	$pageId = $this->get(CRM_Utils_Pager::PAGE_ID);
	291
	292	//if pageId is greator than last page then display last page.
	293	if ((($pageId * self::ROW_COUNT_LIMIT) - 1) > $this->_rowsFound) {
84178120	294	$pageId = ceil((float) $this->_rowsFound / (float) self::ROW_COUNT_LIMIT);
6a488035 TO	295	$this->set(CRM_Utils_Pager::PAGE_ID, $pageId);
	296	}
	297	$this->_limit = ($pageId - 1) * self::ROW_COUNT_LIMIT;
	298	}
	299
74cf4551 EM	300	/**
	301	* @param int $rowCount
	302	*/
00be9182	303	public function setPager($rowCount = self::ROW_COUNT_LIMIT) {
6a488035 TO	304	$params = array(
	305	'total' => $this->_rowsFound,
	306	'rowCount' => self::ROW_COUNT_LIMIT,
	307	'status' => ts('Records %%StatusMessage%%'),
	308	'buttonBottom' => 'PagerBottomButton',
	309	'buttonTop' => 'PagerTopButton',
	310	'pageID' => $this->get(CRM_Utils_Pager::PAGE_ID),
	311	);
	312
	313	$pager = new CRM_Utils_Pager($params);
	314	$this->assign_by_ref('pager', $pager);
	315	}
	316
00be9182	317	public function postProcess() {
6a488035 TO	318	$this->beginPostProcess();
	319	$this->_setVariable = TRUE;
	320
	321	$noSelection = FALSE;
2107cde9	322	if (empty($this->_params['id_value'])) {
6a488035 TO	323	$this->_params['id_value'] = array();
	324	$this->_setVariable = FALSE;
	325
	326	$events = CRM_Event_PseudoConstant::event(NULL, NULL,
99f13d8d	327	"is_template = 0"
6a488035 TO	328	);
	329	if (empty($events)) {
	330	return FALSE;
	331	}
	332	foreach ($events as $key => $dnt) {
	333	$this->_params['id_value'][] = $key;
	334	}
	335	$noSelection = TRUE;
a5611c8e	336	}
7c55abd7 BS	337	elseif (!is_array($this->_params['id_value'])) {
	338	$this->_params['id_value'] = explode(',', $this->_params['id_value']);
	339	}
a5611c8e	340
6a488035 TO	341	$this->_rowsFound = count($this->_params['id_value']);
	342
	343	//set pager and limit if output mode is html
	344	if ($this->_outputMode == 'html') {
	345	$this->limit();
	346	$this->setPager();
a5611c8e	347
6a488035 TO	348	$showEvents = array();
	349	$count = 0;
	350	$numRows = $this->_limit;
	351
	352	if (CRM_Utils_Array::value('id_op', $this->_params, 'in') == 'in' \|\| $noSelection) {
	353	while ($count < self::ROW_COUNT_LIMIT) {
	354	if (!isset($this->_params['id_value'][$numRows])) {
	355	break;
	356	}
a5611c8e	357
6a488035 TO	358	$showEvents[] = $this->_params['id_value'][$numRows];
	359	$count++;
	360	$numRows++;
	361	}
	362	} elseif ($this->_params['id_op'] == 'notin') {
	363	$events = CRM_Event_PseudoConstant::event(NULL, NULL,
99f13d8d	364	"is_template = 0"
6a488035	365	);
a5611c8e	366
6a488035 TO	367	$showEvents = array_diff(array_keys($events), $this->_params['id_value']);
	368	}
	369
	370	$this->buildEventReport($showEvents);
a5611c8e	371
6a488035 TO	372	}
	373	else {
	374	$this->buildEventReport($this->_params['id_value']);
	375	}
	376
	377	parent::endPostProcess();
	378	}
	379	}