/**
* Function to get participant count
*
* @param boolean $considerStatus consider status for participant count.
* @param boolean $status consider counted participant.
* @param boolean $considerRole consider role for participant count.
* @param boolean $role consider counted( is filter role) participant.
* @param array $eventIds consider participants from given events.
* @param boolean $countWithStatus retrieve participant count w/ each participant status.
*
* @access public
* @return array array with count of participants for each event based on status/role
*/
function getParticipantCount($considerStatus = true, $status = true, $considerRole = true, $role = true, $eventIds = array(), $countWithStatus = false)
{
// consider both role and status for counted participants, CRM-4924.
require_once 'CRM/Event/PseudoConstant.php';
require_once 'CRM/Event/BAO/Participant.php';
$operator = " AND ";
// not counted participant.
if ($considerStatus && $considerRole && !$status && !$role) {
$operator = " OR ";
}
$clause = array();
if ($considerStatus) {
$statusTypes = CRM_Event_PseudoConstant::participantStatus(null, 'is_counted = 1');
$statusClause = 'NOT IN';
if ($status) {
$statusClause = 'IN';
}
$status = implode(',', array_keys($statusTypes));
if (empty($status)) {
$status = 0;
}
$clause[] = "civicrm_participant.status_id {$statusClause} ( {$status} ) ";
}
if ($considerRole) {
$roleTypes = CRM_Event_PseudoConstant::participantRole(null, 'filter = 1');
$roleClause = 'NOT IN';
if ($role) {
$roleClause = 'IN';
}
$roles = implode(',', array_keys($roleTypes));
if (empty($roles)) {
$roles = 0;
}
$clause[] = "civicrm_participant.role_id {$roleClause} ( {$roles} )";
}
$sqlClause = '';
if (!empty($clause)) {
$sqlClause = ' AND ( ' . implode($operator, $clause) . ' )';
}
$eventLimit = 10;
if (is_array($eventIds) && !empty($eventIds)) {
$eventLimit = null;
$sqlClause .= ' AND civicrm_event.id IN (' . implode(',', $eventIds) . ')';
}
$select = '
SELECT civicrm_event.id as id,
civicrm_participant.id as participantId';
$from = '
FROM civicrm_event
INNER JOIN civicrm_participant ON ( civicrm_event.id = civicrm_participant.event_id )
INNER JOIN civicrm_contact contact ON ( contact.id = civicrm_participant.contact_id AND contact.is_deleted = 0 )';
if ($countWithStatus) {
$select .= ', status_id as statusId, status_type.class as statusClass';
$from .= '
INNER JOIN civicrm_participant_status_type status_type ON ( civicrm_participant.status_id = status_type.id )';
}
$where = "\n WHERE ( civicrm_participant.is_test = 0 OR civicrm_participant.is_test IS NULL ) \n AND civicrm_event.is_active = 1\n {$sqlClause}";
$orderBy = 'Order By civicrm_event.end_date DESC';
$participantIds = $participantCount = array();
$query = "{$select} {$from} {$where} {$orderBy}";
$event = CRM_Core_DAO::executeQuery($query);
while ($event->fetch()) {
//we are interested in first 10 events only.
if ($eventLimit && count(array_keys($participantIds)) > $eventLimit) {
break;
}
if ($countWithStatus) {
$participantIds[$event->id][$event->statusId]['pIds'][$event->participantId] = $event->participantId;
$participantIds[$event->id][$event->statusId]['statusClass'] = $event->statusClass;
} else {
$participantIds[$event->id][$event->participantId] = $event->participantId;
}
}
//poped last 11th events participants.
if ($eventLimit && count(array_keys($participantIds)) > $eventLimit) {
array_pop($participantIds);
}
//pickup event seats
foreach ($participantIds as $eventId => $pInfo) {
$pIds = $pInfo;
if ($countWithStatus) {
foreach ($pInfo as $statusId => $values) {
$participantCount[$eventId][$statusId]['count'] = CRM_Event_BAO_Participant::totalEventSeats($values['pIds']);
$participantCount[$eventId][$statusId]['class'] = $values['statusClass'];
}
} else {
$participantCount[$eventId] = CRM_Event_BAO_Participant::totalEventSeats($pIds);
}
}
return $participantCount;
}
/**
* Build the form
*
* @access public
* @return void
*/
function buildQuickForm()
{
$this->addElement('text', 'sort_name', ts('Participant Name or Email'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'sort_name'));
require_once 'CRM/Event/BAO/Query.php';
CRM_Event_BAO_Query::buildSearchForm($this);
/*
* add form checkboxes for each row. This is needed out here to conform to QF protocol
* of all elements being declared in builQuickForm
*/
$rows = $this->get('rows');
if (is_array($rows)) {
$lineItems = $participantIds = array();
require_once 'CRM/Event/BAO/Event.php';
require_once 'CRM/Event/BAO/Participant.php';
if (!$this->_single) {
$this->addElement('checkbox', 'toggleSelect', null, null, array('onclick' => "toggleTaskAction( true ); return toggleCheckboxVals('mark_x_',this);"));
}
foreach ($rows as $row) {
$participantIds[] = $row['participant_id'];
if (!$this->_single) {
$this->addElement('checkbox', $row['checkbox'], null, null, array('onclick' => "toggleTaskAction( true ); return checkSelectedBox('" . $row['checkbox'] . "', '" . $this->getName() . "');"));
}
if (CRM_Event_BAO_Event::usesPriceSet($row['event_id'])) {
// add line item details if applicable
require_once 'CRM/Price/BAO/LineItem.php';
$lineItems[$row['participant_id']] = CRM_Price_BAO_LineItem::getLineItems($row['participant_id']);
}
}
$participantCount = CRM_Event_BAO_Participant::totalEventSeats($participantIds);
$this->assign('participantCount', $participantCount);
$this->assign('lineItems', $lineItems);
$total = $cancel = 0;
require_once "CRM/Core/Permission.php";
$permission = CRM_Core_Permission::getPermission();
require_once 'CRM/Event/Task.php';
$tasks = array('' => ts('- actions -')) + CRM_Event_Task::permissionedTaskTitles($permission);
if (isset($this->_ssID)) {
if ($permission == CRM_Core_Permission::EDIT) {
require_once "CRM/Contact/Task.php";
$tasks = $tasks + CRM_Event_Task::optionalTaskTitle();
}
$savedSearchValues = array('id' => $this->_ssID, 'name' => CRM_Contact_BAO_SavedSearch::getName($this->_ssID, 'title'));
$this->assign_by_ref('savedSearch', $savedSearchValues);
$this->assign('ssID', $this->_ssID);
}
$this->add('select', 'task', ts('Actions:') . ' ', $tasks);
$this->add('submit', $this->_actionButtonName, ts('Go'), array('class' => 'form-submit', 'id' => 'Go', 'onclick' => "return checkPerformAction('mark_x', '" . $this->getName() . "', 0);"));
$this->add('submit', $this->_printButtonName, ts('Print'), array('class' => 'form-submit', 'onclick' => "return checkPerformAction('mark_x', '" . $this->getName() . "', 1);"));
// need to perform tasks on all or selected items ? using radio_ts(task selection) for it
$this->addElement('radio', 'radio_ts', null, '', 'ts_sel', array('checked' => 'checked'));
$this->addElement('radio', 'radio_ts', null, '', 'ts_all', array('onclick' => $this->getName() . ".toggleSelect.checked = false; toggleCheckboxVals('mark_x_',this); toggleTaskAction( true );"));
}
// add buttons
$this->addButtons(array(array('type' => 'refresh', 'name' => ts('Search'), 'isDefault' => true)));
}
