where('(start_date >= CURDATE() || end_date >= CURDATE())'); } $events = _civicrm_api3_basic_get(_civicrm_api3_get_BAO(__FUNCTION__), $params, FALSE, 'Event', $sql, TRUE); $options = _civicrm_api3_get_options_from_params($params, TRUE); if ($options['is_count']) { return civicrm_api3_create_success($events, $params, 'Event', 'get'); } foreach ($events as $id => $event) { if (!empty($options['return']['is_full'])) { _civicrm_api3_event_getisfull($events, $id); } _civicrm_api3_event_get_legacy_support_42($events, $id); if (!empty($options['return']['price_set_id'])) { $events[$id]['price_set_id'] = CRM_Price_BAO_PriceSet::getFor('civicrm_event', $id); } } return civicrm_api3_create_success($events, $params, 'Event', 'get'); } /** * Adjust Metadata for Get action. * * The metadata is used for setting defaults, documentation & validation. * * @param array $params * Array of parameters determined by getfields. */ function _civicrm_api3_event_get_spec(&$params) { $params['financial_type_id']['api.aliases'] = ['contribution_type_id']; } /** * Support for schema changes made in 4.2. * * The main purpose of the API is to provide integrators a level of stability not provided by * the core code or schema - this means we have to provide support for api calls (where possible) * across schema changes. * * @param array $event * @param int $event_id */ function _civicrm_api3_event_get_legacy_support_42(&$event, $event_id) { if (!empty($event[$event_id]['payment_processor'])) { $processors = explode(CRM_Core_DAO::VALUE_SEPARATOR, $event[$event_id]['payment_processor']); if (count($processors) == 3) { $event[$event_id]['payment_processor_id'] = $processors[1]; } } } /** * Delete an existing Event. * * This API is used for deleting a event given its id. * * @param array $params * * @return array */ function civicrm_api3_event_delete($params) { return CRM_Event_BAO_Event::del($params['id']) ? civicrm_api3_create_success() : civicrm_api3_create_error(ts('Error while deleting event')); } /** * Add 'is_full' & 'available_seats' to the return array. * * (this might be better in the BAO) * Default BAO function returns a string if full rather than a Bool - which is more appropriate to a form * * @param array $event * Return array of the event. * @param int $event_id * Id of the event to be updated. */ function _civicrm_api3_event_getisfull(&$event, $event_id) { $eventFullResult = CRM_Event_BAO_Participant::eventFull($event_id, 1); if (!empty($eventFullResult) && is_int($eventFullResult)) { $event[$event_id]['available_places'] = $eventFullResult; } elseif (is_null($eventFullResult)) { return $event[$event_id]['is_full'] = 0; } else { $event[$event_id]['available_places'] = 0; } $event[$event_id]['is_full'] = $event[$event_id]['available_places'] == 0 ? 1 : 0; } /** * Get event list parameters. * * @see _civicrm_api3_generic_getlist_params * * @param array $request */ function _civicrm_api3_event_getlist_params(&$request) { $fieldsToReturn = ['start_date', 'event_type_id', 'title', 'summary']; $request['params']['return'] = array_unique(array_merge($fieldsToReturn, $request['extra'])); $request['params']['options']['sort'] = 'start_date DESC'; if (empty($request['params']['id'])) { $request['params'] += [ 'is_template' => 0, 'is_active' => 1, ]; } } /** * Get event list output. * * @see _civicrm_api3_generic_getlist_output * * @param array $result * @param array $request * * @return array */ function _civicrm_api3_event_getlist_output($result, $request) { $output = []; if (!empty($result['values'])) { foreach ($result['values'] as $row) { $data = [ 'id' => $row[$request['id_field']], 'label' => $row[$request['label_field']], 'description' => [ CRM_Core_PseudoConstant::getLabel('CRM_Event_BAO_Event', 'event_type_id', $row['event_type_id']), ], ]; if (!empty($row['start_date'])) { $data['description'][0] .= ': ' . CRM_Utils_Date::customFormat($row['start_date']); } if (!empty($row['summary'])) { $data['description'][] = $row['summary']; } // Add repeating info $repeat = CRM_Core_BAO_RecurringEntity::getPositionAndCount($row['id'], 'civicrm_event'); $data['extra']['is_recur'] = FALSE; if ($repeat) { $data['suffix'] = ts('(%1 of %2)', [1 => $repeat[0], 2 => $repeat[1]]); $data['extra']['is_recur'] = TRUE; } $output[] = $data; } } return $output; }