4 * To change this license header, choose License Headers in Project Properties.
5 * To change this template file, choose Tools | Templates
6 * and open the template in the editor.
10 * Description of Repeat
14 class CRM_Event_Form_ManageEvent_Repeat
extends CRM_Event_Form_ManageEvent
{
17 * Parent Event Start Date
19 protected $_parentEventStartDate = NULL;
22 * Parent Event End Date
24 protected $_parentEventEndDate = NULL;
27 public function preProcess() {
29 CRM_Core_Form_RecurringEntity
::preProcess('civicrm_event');
30 $this->assign('currentEventId', $this->_id
);
32 $checkParentExistsForThisId = CRM_Core_BAO_RecurringEntity
::getParentFor($this->_id
, 'civicrm_event');
33 //If this ID has parent, send parent id
34 if ($checkParentExistsForThisId) {
36 * Get connected event information list
38 //Get all connected event ids
39 $allEventIdsArray = CRM_Core_BAO_RecurringEntity
::getEntitiesForParent($checkParentExistsForThisId, 'civicrm_event');
40 $allEventIds = array();
41 if (!empty($allEventIdsArray)) {
42 foreach ($allEventIdsArray as $key => $val) {
43 $allEventIds[] = $val['id'];
45 if (!empty($allEventIds)) {
50 WHERE id IN (" . implode(",", $allEventIds) . ")
51 ORDER BY start_date asc
54 $dao = CRM_Core_DAO
::executeQuery($query, $params, TRUE, 'CRM_Event_DAO_Event');
55 $permissions = CRM_Event_BAO_Event
::checkPermission();
56 while ($dao->fetch()) {
57 if (in_array($dao->id
, $permissions[CRM_Core_Permission
::VIEW
])) {
58 $manageEvent[$dao->id
] = array();
59 CRM_Core_DAO
::storeValues($dao, $manageEvent[$dao->id
]);
63 $this->assign('rows', $manageEvent);
67 $parentEventParams = array('id' => $this->_id
);
68 $parentEventValues = array();
69 $parentEventReturnProperties = array('start_date', 'end_date');
70 $parentEventAttributes = CRM_Core_DAO
::commonRetrieve('CRM_Event_DAO_Event', $parentEventParams, $parentEventValues, $parentEventReturnProperties);
71 $this->_parentEventStartDate
= $parentEventAttributes->start_date
;
72 $this->_parentEventEndDate
= $parentEventAttributes->end_date
;
76 * Set default values for the form. For edit/view mode
77 * the default values are retrieved from the database
82 public function setDefaultValues() {
85 //Always pass current event's start date by default
86 $currentEventStartDate = CRM_Core_DAO
::getFieldValue('CRM_Event_DAO_Event', $this->_id
, 'start_date', 'id');
87 list($defaults['repetition_start_date'], $defaults['repetition_start_date_time']) = CRM_Utils_Date
::setDateDefaults($currentEventStartDate, 'activityDateTime');
88 $defaults['allowRepeatConfigToSubmit'] = 1;
89 $recurringEntityDefaults = array();
90 $recurringEntityDefaults = CRM_Core_Form_RecurringEntity
::setDefaultValues();
91 $defaults = array_merge($defaults, $recurringEntityDefaults);
95 public function buildQuickForm() {
96 CRM_Core_Form_RecurringEntity
::buildQuickForm($this);
99 public function postProcess() {
101 $params = $this->controller
->exportValues($this->_name
);
102 if ($this->_parentEventStartDate
&& $this->_parentEventEndDate
) {
103 $interval = CRM_Core_BAO_RecurringEntity
::getInterval($this->_parentEventStartDate
, $this->_parentEventEndDate
);
104 $params['intervalDateColumns'] = array('end_date' => $interval);
106 $params['dateColumns'] = array('start_date');
107 $params['excludeDateRangeColumns'] = array('start_date', 'end_date');
108 $params['entity_table'] = 'civicrm_event';
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 .
172 static public function getParticipantCountforEvent($listOfRelatedEntities = 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 $participantDetails = array();
186 while ($dao->fetch()) {
187 $participantDetails['countByID'][$dao->event_id
] = $dao->participant_count
;
188 $participantDetails['countByName'][$dao->event_id
][$dao->event_data
] = $dao->participant_count
;
192 return $participantDetails;
196 * This function checks if there was any registraion for related event ids,
197 * and returns array of ids with no regsitrations
198 * @param string or int or object... $eventID
200 public static function checkRegistrationForEvents($eventID) {
201 $eventIdsWithNoRegistration = array();
203 $getRelatedEntities = CRM_Core_BAO_RecurringEntity
::getEntitiesFor($eventID, 'civicrm_event', TRUE);
204 $participantDetails = CRM_Event_Form_ManageEvent_Repeat
::getParticipantCountforEvent($getRelatedEntities);
205 //Check if participants exists for events
206 foreach ($getRelatedEntities as $key => $value) {
207 if (!CRM_Utils_Array
::value($value['id'], $participantDetails['countByID']) && $value['id'] != $eventID) {
208 //CRM_Event_BAO_Event::del($value['id']);
209 $eventIdsWithNoRegistration[] = $value['id'];
213 CRM_Core_BAO_RecurringEntity
::$_entitiesToBeDeleted = $eventIdsWithNoRegistration;
214 return CRM_Core_BAO_RecurringEntity
::$_entitiesToBeDeleted;