Commit | Line | Data |
---|---|---|
0479b4c8 | 1 | <?php |
0479b4c8 TO |
2 | /* |
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. | |
6 | */ | |
7 | ||
8 | /** | |
9 | * Description of Repeat | |
10 | * | |
11 | * @author Priyanka | |
12 | */ | |
13 | class CRM_Event_Form_ManageEvent_Repeat extends CRM_Event_Form_ManageEvent { | |
14 | ||
15 | /** | |
f9e31d7f | 16 | * Parent Event Start Date. |
0479b4c8 TO |
17 | */ |
18 | protected $_parentEventStartDate = NULL; | |
19 | ||
20 | /** | |
f9e31d7f | 21 | * Parent Event End Date. |
0479b4c8 TO |
22 | */ |
23 | protected $_parentEventEndDate = NULL; | |
24 | ||
25 | ||
26 | public function preProcess() { | |
27 | parent::preProcess(); | |
0479b4c8 TO |
28 | $this->assign('currentEventId', $this->_id); |
29 | ||
30 | $checkParentExistsForThisId = CRM_Core_BAO_RecurringEntity::getParentFor($this->_id, 'civicrm_event'); | |
31 | //If this ID has parent, send parent id | |
32 | if ($checkParentExistsForThisId) { | |
33 | /** | |
353ffa53 TO |
34 | * Get connected event information list |
35 | */ | |
0479b4c8 TO |
36 | //Get all connected event ids |
37 | $allEventIdsArray = CRM_Core_BAO_RecurringEntity::getEntitiesForParent($checkParentExistsForThisId, 'civicrm_event'); | |
38 | $allEventIds = array(); | |
39 | if (!empty($allEventIdsArray)) { | |
22e263ad | 40 | foreach ($allEventIdsArray as $key => $val) { |
0479b4c8 TO |
41 | $allEventIds[] = $val['id']; |
42 | } | |
43 | if (!empty($allEventIds)) { | |
44 | $params = array(); | |
45 | $query = " | |
46 | SELECT * | |
47 | FROM civicrm_event | |
92fcb95f | 48 | WHERE id IN (" . implode(",", $allEventIds) . ") |
0479b4c8 TO |
49 | ORDER BY start_date asc |
50 | "; | |
51 | ||
52 | $dao = CRM_Core_DAO::executeQuery($query, $params, TRUE, 'CRM_Event_DAO_Event'); | |
53 | $permissions = CRM_Event_BAO_Event::checkPermission(); | |
22e263ad | 54 | while ($dao->fetch()) { |
0479b4c8 TO |
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]); | |
58 | } | |
59 | } | |
60 | } | |
61 | $this->assign('rows', $manageEvent); | |
62 | } | |
63 | } | |
64 | ||
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; | |
71 | } | |
72 | ||
73 | /** | |
74 | * Set default values for the form. For edit/view mode | |
75 | * the default values are retrieved from the database | |
76 | * | |
77 | * | |
d2a4c29b | 78 | * @return array |
0479b4c8 TO |
79 | */ |
80 | public function setDefaultValues() { | |
81 | $defaults = array(); | |
82 | ||
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'); | |
0479b4c8 | 86 | $recurringEntityDefaults = CRM_Core_Form_RecurringEntity::setDefaultValues(); |
d2a4c29b | 87 | return array_merge($defaults, $recurringEntityDefaults); |
0479b4c8 TO |
88 | } |
89 | ||
90 | public function buildQuickForm() { | |
91 | CRM_Core_Form_RecurringEntity::buildQuickForm($this); | |
92 | } | |
93 | ||
94 | public function postProcess() { | |
95 | if ($this->_id) { | |
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); | |
100 | } | |
101 | $params['dateColumns'] = array('start_date'); | |
102 | $params['excludeDateRangeColumns'] = array('start_date', 'end_date'); | |
103 | $params['entity_table'] = 'civicrm_event'; | |
c65ce939 | 104 | $params['entity_id'] = $this->_id; |
0479b4c8 TO |
105 | //Unset event id |
106 | unset($params['id']); | |
107 | ||
108 | $url = 'civicrm/event/manage/repeat'; | |
109 | $urlParams = "action=update&reset=1&id={$this->_id}"; | |
110 | ||
111 | $linkedEntities = array( | |
112 | array( | |
353ffa53 TO |
113 | 'table' => 'civicrm_price_set_entity', |
114 | 'findCriteria' => array( | |
115 | 'entity_id' => $this->_id, | |
21dfd5f5 | 116 | 'entity_table' => 'civicrm_event', |
0479b4c8 TO |
117 | ), |
118 | 'linkedColumns' => array('entity_id'), | |
119 | 'isRecurringEntityRecord' => FALSE, | |
120 | ), | |
121 | array( | |
353ffa53 TO |
122 | 'table' => 'civicrm_uf_join', |
123 | 'findCriteria' => array( | |
124 | 'entity_id' => $this->_id, | |
21dfd5f5 | 125 | 'entity_table' => 'civicrm_event', |
0479b4c8 TO |
126 | ), |
127 | 'linkedColumns' => array('entity_id'), | |
128 | 'isRecurringEntityRecord' => FALSE, | |
129 | ), | |
130 | array( | |
353ffa53 TO |
131 | 'table' => 'civicrm_tell_friend', |
132 | 'findCriteria' => array( | |
133 | 'entity_id' => $this->_id, | |
21dfd5f5 | 134 | 'entity_table' => 'civicrm_event', |
0479b4c8 TO |
135 | ), |
136 | 'linkedColumns' => array('entity_id'), | |
137 | 'isRecurringEntityRecord' => TRUE, | |
138 | ), | |
139 | array( | |
353ffa53 TO |
140 | 'table' => 'civicrm_pcp_block', |
141 | 'findCriteria' => array( | |
142 | 'entity_id' => $this->_id, | |
21dfd5f5 | 143 | 'entity_table' => 'civicrm_event', |
0479b4c8 TO |
144 | ), |
145 | 'linkedColumns' => array('entity_id'), | |
146 | 'isRecurringEntityRecord' => TRUE, | |
147 | ), | |
148 | ); | |
149 | CRM_Core_Form_RecurringEntity::postProcess($params, 'civicrm_event', $linkedEntities); | |
150 | CRM_Utils_System::redirect(CRM_Utils_System::url($url, $urlParams)); | |
151 | } | |
152 | else { | |
153 | CRM_Core_Error::fatal("Could not find Event ID"); | |
154 | } | |
155 | parent::endPostProcess(); | |
156 | } | |
157 | ||
158 | /** | |
f9e31d7f | 159 | * This function gets the number of participant count for the list of related event ids. |
0479b4c8 | 160 | * |
d4dd1e85 TO |
161 | * @param array $listOfRelatedEntities |
162 | * List of related event ids . | |
0479b4c8 | 163 | * |
0479b4c8 TO |
164 | * |
165 | * @return array | |
166 | */ | |
167 | static public function getParticipantCountforEvent($listOfRelatedEntities = array()) { | |
c65ce939 | 168 | $participantDetails = array(); |
0479b4c8 | 169 | if (!empty($listOfRelatedEntities)) { |
353ffa53 | 170 | $implodeRelatedEntities = implode(',', array_map(function ($entity) { |
0479b4c8 TO |
171 | return $entity['id']; |
172 | }, $listOfRelatedEntities)); | |
173 | if ($implodeRelatedEntities) { | |
174 | $query = "SELECT p.event_id as event_id, | |
175 | 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, | |
176 | count(p.id) as participant_count | |
177 | FROM civicrm_participant p, civicrm_event e | |
178 | WHERE p.event_id = e.id AND p.event_id IN ({$implodeRelatedEntities}) | |
179 | GROUP BY p.event_id"; | |
180 | $dao = CRM_Core_DAO::executeQuery($query); | |
22e263ad | 181 | while ($dao->fetch()) { |
0479b4c8 TO |
182 | $participantDetails['countByID'][$dao->event_id] = $dao->participant_count; |
183 | $participantDetails['countByName'][$dao->event_id][$dao->event_data] = $dao->participant_count; | |
184 | } | |
185 | } | |
186 | } | |
187 | return $participantDetails; | |
188 | } | |
189 | ||
190 | /** | |
191 | * This function checks if there was any registraion for related event ids, | |
192 | * and returns array of ids with no regsitrations | |
7a9ab499 | 193 | * |
0479b4c8 | 194 | * @param string or int or object... $eventID |
7a9ab499 EM |
195 | * |
196 | * @return array | |
0479b4c8 TO |
197 | */ |
198 | public static function checkRegistrationForEvents($eventID) { | |
199 | $eventIdsWithNoRegistration = array(); | |
200 | if ($eventID) { | |
201 | $getRelatedEntities = CRM_Core_BAO_RecurringEntity::getEntitiesFor($eventID, 'civicrm_event', TRUE); | |
202 | $participantDetails = CRM_Event_Form_ManageEvent_Repeat::getParticipantCountforEvent($getRelatedEntities); | |
203 | //Check if participants exists for events | |
204 | foreach ($getRelatedEntities as $key => $value) { | |
205 | if (!CRM_Utils_Array::value($value['id'], $participantDetails['countByID']) && $value['id'] != $eventID) { | |
206 | //CRM_Event_BAO_Event::del($value['id']); | |
207 | $eventIdsWithNoRegistration[] = $value['id']; | |
208 | } | |
209 | } | |
210 | } | |
211 | CRM_Core_BAO_RecurringEntity::$_entitiesToBeDeleted = $eventIdsWithNoRegistration; | |
212 | return CRM_Core_BAO_RecurringEntity::$_entitiesToBeDeleted; | |
213 | } | |
96025800 | 214 | |
0479b4c8 | 215 | } |