3 * To change this license header, choose License Headers in Project Properties.
4 * To change this template file, choose Tools | Templates
5 * and open the template in the editor.
9 * Description of Repeat
13 class CRM_Event_Form_ManageEvent_Repeat
extends CRM_Event_Form_ManageEvent
{
16 * Parent Event Start Date.
18 protected $_parentEventStartDate = NULL;
21 * Parent Event End Date.
23 protected $_parentEventEndDate = NULL;
26 public function preProcess() {
28 $this->assign('currentEventId', $this->_id
);
30 $checkParentExistsForThisId = CRM_Core_BAO_RecurringEntity
::getParentFor($this->_id
, 'civicrm_event');
31 //If this ID has parent, send parent id
32 if ($checkParentExistsForThisId) {
34 * Get connected event information list
36 //Get all connected event ids
37 $allEventIdsArray = CRM_Core_BAO_RecurringEntity
::getEntitiesForParent($checkParentExistsForThisId, 'civicrm_event');
38 $allEventIds = array();
39 if (!empty($allEventIdsArray)) {
40 foreach ($allEventIdsArray as $key => $val) {
41 $allEventIds[] = $val['id'];
43 if (!empty($allEventIds)) {
48 WHERE id IN (" . implode(",", $allEventIds) . ")
49 ORDER BY start_date asc
52 $dao = CRM_Core_DAO
::executeQuery($query, $params, TRUE, 'CRM_Event_DAO_Event');
53 $permissions = CRM_Event_BAO_Event
::checkPermission();
54 while ($dao->fetch()) {
55 if (in_array($dao->id
, $permissions[CRM_Core_Permission
::VIEW
])) {
56 $manageEvent[$dao->id
] = array();
57 CRM_Core_DAO
::storeValues($dao, $manageEvent[$dao->id
]);
61 $this->assign('rows', $manageEvent);
65 $parentEventParams = array('id' => $this->_id
);
66 $parentEventValues = array();
67 $parentEventReturnProperties = array('start_date', 'end_date');
68 $parentEventAttributes = CRM_Core_DAO
::commonRetrieve('CRM_Event_DAO_Event', $parentEventParams, $parentEventValues, $parentEventReturnProperties);
69 $this->_parentEventStartDate
= $parentEventAttributes->start_date
;
70 $this->_parentEventEndDate
= $parentEventAttributes->end_date
;
74 * Set default values for the form. For edit/view mode
75 * the default values are retrieved from the database
80 public function setDefaultValues() {
83 //Always pass current event's start date by default
84 $currentEventStartDate = CRM_Core_DAO
::getFieldValue('CRM_Event_DAO_Event', $this->_id
, 'start_date', 'id');
85 list($defaults['repetition_start_date'], $defaults['repetition_start_date_time']) = CRM_Utils_Date
::setDateDefaults($currentEventStartDate, 'activityDateTime');
86 $recurringEntityDefaults = CRM_Core_Form_RecurringEntity
::setDefaultValues();
87 return array_merge($defaults, $recurringEntityDefaults);
90 public function buildQuickForm() {
91 CRM_Core_Form_RecurringEntity
::buildQuickForm($this);
94 public function postProcess() {
96 $params = $this->controller
->exportValues($this->_name
);
97 if ($this->_parentEventStartDate
&& $this->_parentEventEndDate
) {
98 $interval = CRM_Core_BAO_RecurringEntity
::getInterval($this->_parentEventStartDate
, $this->_parentEventEndDate
);
99 $params['intervalDateColumns'] = array('end_date' => $interval);
101 $params['dateColumns'] = array('start_date');
102 $params['excludeDateRangeColumns'] = array('start_date', 'end_date');
103 $params['entity_table'] = 'civicrm_event';
104 $params['entity_id'] = $this->_id
;
106 // CRM-16568 - check if parent exist for the event.
107 $parentId = CRM_Core_BAO_RecurringEntity
::getParentFor($this->_id
, 'civicrm_event');
108 $params['parent_entity_id'] = !empty($parentId) ?
$parentId : $params['entity_id'];
110 unset($params['id']);
112 $url = 'civicrm/event/manage/repeat';
113 $urlParams = "action=update&reset=1&id={$this->_id}";
115 $linkedEntities = array(
117 'table' => 'civicrm_price_set_entity',
118 'findCriteria' => array(
119 'entity_id' => $this->_id
,
120 'entity_table' => 'civicrm_event',
122 'linkedColumns' => array('entity_id'),
123 'isRecurringEntityRecord' => FALSE,
126 'table' => 'civicrm_uf_join',
127 'findCriteria' => array(
128 'entity_id' => $this->_id
,
129 'entity_table' => 'civicrm_event',
131 'linkedColumns' => array('entity_id'),
132 'isRecurringEntityRecord' => FALSE,
135 'table' => 'civicrm_tell_friend',
136 'findCriteria' => array(
137 'entity_id' => $this->_id
,
138 'entity_table' => 'civicrm_event',
140 'linkedColumns' => array('entity_id'),
141 'isRecurringEntityRecord' => TRUE,
144 'table' => 'civicrm_pcp_block',
145 'findCriteria' => array(
146 'entity_id' => $this->_id
,
147 'entity_table' => 'civicrm_event',
149 'linkedColumns' => array('entity_id'),
150 'isRecurringEntityRecord' => TRUE,
153 CRM_Core_Form_RecurringEntity
::postProcess($params, 'civicrm_event', $linkedEntities);
154 CRM_Utils_System
::redirect(CRM_Utils_System
::url($url, $urlParams));
157 CRM_Core_Error
::fatal("Could not find Event ID");
159 parent
::endPostProcess();
163 * This function gets the number of participant count for the list of related event ids.
165 * @param array $listOfRelatedEntities
166 * List of related event ids .
171 static public function getParticipantCountforEvent($listOfRelatedEntities = array()) {
172 $participantDetails = array();
173 if (!empty($listOfRelatedEntities)) {
174 $implodeRelatedEntities = implode(',', array_map(function ($entity) {
175 return $entity['id'];
176 }, $listOfRelatedEntities));
177 if ($implodeRelatedEntities) {
178 $query = "SELECT p.event_id as event_id,
179 concat_ws(' ', e.title, concat_ws(' - ', DATE_FORMAT(e.start_date, '%b %d %Y %h:%i %p'), DATE_FORMAT(e.end_date, '%b %d %Y %h:%i %p'))) as event_data,
180 count(p.id) as participant_count
181 FROM civicrm_participant p, civicrm_event e
182 WHERE p.event_id = e.id AND p.event_id IN ({$implodeRelatedEntities})
183 GROUP BY p.event_id";
184 $dao = CRM_Core_DAO
::executeQuery($query);
185 while ($dao->fetch()) {
186 $participantDetails['countByID'][$dao->event_id
] = $dao->participant_count
;
187 $participantDetails['countByName'][$dao->event_id
][$dao->event_data
] = $dao->participant_count
;
191 return $participantDetails;
195 * This function checks if there was any registraion for related event ids,
196 * and returns array of ids with no regsitrations
198 * @param string or int or object... $eventID
202 public static function checkRegistrationForEvents($eventID) {
203 $eventIdsWithNoRegistration = array();
205 $getRelatedEntities = CRM_Core_BAO_RecurringEntity
::getEntitiesFor($eventID, 'civicrm_event', TRUE);
206 $participantDetails = CRM_Event_Form_ManageEvent_Repeat
::getParticipantCountforEvent($getRelatedEntities);
207 //Check if participants exists for events
208 foreach ($getRelatedEntities as $key => $value) {
209 if (!CRM_Utils_Array
::value($value['id'], $participantDetails['countByID']) && $value['id'] != $eventID) {
210 //CRM_Event_BAO_Event::del($value['id']);
211 $eventIdsWithNoRegistration[] = $value['id'];
215 CRM_Core_BAO_RecurringEntity
::$_entitiesToBeDeleted = $eventIdsWithNoRegistration;
216 return CRM_Core_BAO_RecurringEntity
::$_entitiesToBeDeleted;