From 6979228c55bc2f52c930e72ceec9313fcc7dfc6d Mon Sep 17 00:00:00 2001
From: Alain Benbassat <alain@businessandcode.eu>
Date: Mon, 4 Dec 2023 18:55:39 +0000
Subject: [PATCH] adds Manage Events

---
 .../ang/afsearchManageEvents.aff.html         |   8 +
 .../ang/afsearchManageEvents.aff.php          |  14 +
 .../managed/SavedSearch_Manage_Events.mgd.php | 487 ++++++++++++++++++
 3 files changed, 509 insertions(+)
 create mode 100644 ext/civicrm_search_ui/ang/afsearchManageEvents.aff.html
 create mode 100644 ext/civicrm_search_ui/ang/afsearchManageEvents.aff.php
 create mode 100644 ext/civicrm_search_ui/managed/SavedSearch_Manage_Events.mgd.php

diff --git a/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.html b/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.html
new file mode 100644
index 0000000000..be245b2fef
--- /dev/null
+++ b/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.html
@@ -0,0 +1,8 @@
+<div af-fieldset="">
+  <div class="af-container af-layout-inline">
+    <af-field name="title" />
+    <af-field name="start_date" defn="{input_type: 'Select', search_range: true, options: [{id: '{}', label: 'Choose Date Range'}, {id: 'this.day', label: 'Today'}, {id: 'this.week', label: 'This week'}, {id: 'this.month', label: 'This calendar month'}, {id: 'this.quarter', label: 'This quarter'}, {id: 'this.fiscal_year', label: 'This fiscal year'}, {id: 'this.year', label: 'This calendar year'}, {id: 'previous.day', label: 'Yesterday'}, {id: 'previous.week', label: 'Previous week'}, {id: 'previous.month', label: 'Previous calendar month'}, {id: 'previous.quarter', label: 'Previous quarter'}, {id: 'previous.fiscal_year', label: 'Previous fiscal year'}, {id: 'previous.year', label: 'Previous calendar year'}, {id: 'ending.week', label: 'Last 7 days including today'}, {id: 'ending_30.day', label: 'Last 30 days including today'}, {id: 'ending_60.day', label: 'Last 60 days including today'}, {id: 'ending_90.day', label: 'Last 90 days including today'}, {id: 'ending.year', label: 'Last 12 months including today'}, {id: 'ending_2.year', label: 'Last 2 years including today'}, {id: 'ending_3.year', label: 'Last 3 years including today'}, {id: 'starting.day', label: 'Tomorrow'}, {id: 'next.week', label: 'Next week'}, {id: 'next.month', label: 'Next calendar month'}, {id: 'next.quarter', label: 'Next quarter'}, {id: 'next.fiscal_year', label: 'Next fiscal year'}, {id: 'next.year', label: 'Next calendar year'}, {id: 'starting.week', label: 'Next 7 days including today'}, {id: 'starting.month', label: 'Next 30 days including today'}, {id: 'starting_2.month', label: 'Next 60 days including today'}, {id: 'starting.quarter', label: 'Next 90 days including today'}, {id: 'starting.year', label: 'Next 12 months including today'}, {id: 'current.week', label: 'Current week to-date'}, {id: 'current.month', label: 'Current calendar month to-date'}, {id: 'current.quarter', label: 'Current quarter to-date'}, {id: 'current.year', label: 'Current calendar year to-date'}, {id: 'earlier.day', label: 'To end of yesterday'}, {id: 'earlier.week', label: 'To end of previous week'}, {id: 'earlier.month', label: 'To end of previous calendar month'}, {id: 'earlier.quarter', label: 'To end of previous quarter'}, {id: 'earlier.year', label: 'To end of previous calendar year'}, {id: 'greater.day', label: 'From start of current day'}, {id: 'greater.week', label: 'From start of current week'}, {id: 'greater.month', label: 'From start of current calendar month'}, {id: 'greater.quarter', label: 'From start of current quarter'}, {id: 'greater.year', label: 'From start of current calendar year'}, {id: 'less.week', label: 'To end of current week'}, {id: 'less.month', label: 'To end of current calendar month'}, {id: 'less.quarter', label: 'To end of current quarter'}, {id: 'less.year', label: 'To end of current calendar year'}, {id: 'previous_2.day', label: 'Previous 2 days'}, {id: 'previous_2.week', label: 'Previous 2 weeks'}, {id: 'previous_2.month', label: 'Previous 2 calendar months'}, {id: 'previous_2.quarter', label: 'Previous 2 quarters'}, {id: 'previous_2.year', label: 'Previous 2 calendar years'}, {id: 'previous_2.fiscal_year', label: 'Previous 2 fiscal years'}, {id: 'previous_before.day', label: 'Day prior to yesterday'}, {id: 'previous_before.week', label: 'Week prior to previous week'}, {id: 'previous_before.month', label: 'Month prior to previous calendar month'}, {id: 'previous_before.quarter', label: 'Quarter prior to previous quarter'}, {id: 'previous_before.year', label: 'Year prior to previous calendar year'}, {id: 'previous_before.fiscal_year', label: 'Fiscal year prior to previous fiscal year'}, {id: 'greater_previous.week', label: 'From end of previous week'}, {id: 'greater_previous.month', label: 'From end of previous calendar month'}, {id: 'greater_previous.quarter', label: 'From end of previous quarter'}, {id: 'greater_previous.year', label: 'From end of previous calendar year'}], default_date_type: 'fixed', input_attrs: {}, afform_default: 'starting.year'}" />
+    <af-field name="event_type_id" defn="{input_attrs: {multiple: true}}" />
+  </div>
+  <crm-search-display-table search-name="Manage_Events" display-name="Manage_Events_Table_1"></crm-search-display-table>
+</div>
diff --git a/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.php b/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.php
new file mode 100644
index 0000000000..f3dfd2535a
--- /dev/null
+++ b/ext/civicrm_search_ui/ang/afsearchManageEvents.aff.php
@@ -0,0 +1,14 @@
+<?php
+use CRM_CivicrmSearchUi_ExtensionUtil as E;
+
+return [
+  'type' => 'search',
+  'title' => E::ts('Manage Events'),
+  'icon' => 'fa-list-alt',
+  'server_route' => 'civicrm/searchui/event/manage',
+  'permission' => [
+    'access CiviCRM',
+    'access CiviEvent',
+  ],
+  'modified_date' => '2023-12-04 18:48:01',
+];
diff --git a/ext/civicrm_search_ui/managed/SavedSearch_Manage_Events.mgd.php b/ext/civicrm_search_ui/managed/SavedSearch_Manage_Events.mgd.php
new file mode 100644
index 0000000000..6c4afcf5c3
--- /dev/null
+++ b/ext/civicrm_search_ui/managed/SavedSearch_Manage_Events.mgd.php
@@ -0,0 +1,487 @@
+<?php
+use CRM_CivicrmSearchUi_ExtensionUtil as E;
+
+return [
+  [
+    'name' => 'SavedSearch_Manage_Events',
+    'entity' => 'SavedSearch',
+    'cleanup' => 'unused',
+    'update' => 'unmodified',
+    'params' => [
+      'version' => 4,
+      'values' => [
+        'name' => 'Manage_Events',
+        'label' => E::ts('Manage Events'),
+        'api_entity' => 'Event',
+        'api_params' => [
+          'version' => 4,
+          'select' => [
+            'id',
+            'title',
+            'GROUP_CONCAT(DISTINCT Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01.city) AS GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_city',
+            'GROUP_CONCAT(DISTINCT Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01.state_province_id:label) AS GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_state_province_id_label',
+            'event_type_id:label',
+            'start_date',
+            'end_date',
+            'is_public',
+            'is_active',
+            'COUNT(DISTINCT Event_Participant_event_id_01.id) AS COUNT_Event_Participant_event_id_01_id',
+            'COUNT(Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01.id) AS COUNT_Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01_id',
+            'COUNT(Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02.id) AS COUNT_Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02_id',
+            'Event_Participant_event_id_01_Participant_Contact_contact_id_01.sort_name',
+          ],
+          'orderBy' => [],
+          'where' => [
+            [
+              'is_template',
+              '=',
+              FALSE,
+            ],
+          ],
+          'groupBy' => [
+            'id',
+          ],
+          'join' => [
+            [
+              'LocBlock AS Event_LocBlock_loc_block_id_01',
+              'LEFT',
+              [
+                'loc_block_id',
+                '=',
+                'Event_LocBlock_loc_block_id_01.id',
+              ],
+            ],
+            [
+              'Address AS Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01',
+              'LEFT',
+              [
+                'Event_LocBlock_loc_block_id_01.address_id',
+                '=',
+                'Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01.id',
+              ],
+              [
+                'Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01.is_primary',
+                '=',
+                TRUE,
+              ],
+            ],
+            [
+              'Participant AS Event_Participant_event_id_01',
+              'LEFT',
+              [
+                'id',
+                '=',
+                'Event_Participant_event_id_01.event_id',
+              ],
+            ],
+            [
+              'ParticipantStatusType AS Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01',
+              'LEFT',
+              [
+                'Event_Participant_event_id_01.status_id',
+                '=',
+                'Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01.id',
+              ],
+              [
+                'Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01.is_counted',
+                '=',
+                TRUE,
+              ],
+            ],
+            [
+              'ParticipantStatusType AS Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02',
+              'LEFT',
+              [
+                'Event_Participant_event_id_01.status_id',
+                '=',
+                'Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02.id',
+              ],
+              [
+                'Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02.is_counted',
+                '=',
+                FALSE,
+              ],
+            ],
+            [
+              'Contact AS Event_Participant_event_id_01_Participant_Contact_contact_id_01',
+              'LEFT',
+              [
+                'Event_Participant_event_id_01.contact_id',
+                '=',
+                'Event_Participant_event_id_01_Participant_Contact_contact_id_01.id',
+              ],
+              [
+                'Event_Participant_event_id_01_Participant_Contact_contact_id_01.is_deleted',
+                '=',
+                FALSE,
+              ],
+            ],
+          ],
+          'having' => [],
+        ],
+        'description' => E::ts('this replaces the current Manage Events screen'),
+      ],
+      'match' => [
+        'name',
+      ],
+    ],
+  ],
+  [
+    'name' => 'SavedSearch_Manage_Events_SearchDisplay_Manage_Events_Table_1',
+    'entity' => 'SearchDisplay',
+    'cleanup' => 'unused',
+    'update' => 'unmodified',
+    'params' => [
+      'version' => 4,
+      'values' => [
+        'name' => 'Manage_Events_Table_1',
+        'label' => E::ts('Manage Events Table 1'),
+        'saved_search_id.name' => 'Manage_Events',
+        'type' => 'table',
+        'settings' => [
+          'description' => NULL,
+          'sort' => [
+            [
+              'start_date',
+              'ASC',
+            ],
+          ],
+          'limit' => 50,
+          'pager' => [],
+          'placeholder' => 5,
+          'columns' => [
+            [
+              'type' => 'field',
+              'key' => 'id',
+              'dataType' => 'Integer',
+              'label' => E::ts('ID'),
+              'sortable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'title',
+              'dataType' => 'String',
+              'label' => E::ts('Event'),
+              'sortable' => TRUE,
+              'link' => [
+                'path' => 'civicrm/event/manage/settings?reset=1&action=update&id=[id]',
+                'entity' => '',
+                'action' => '',
+                'join' => '',
+                'target' => '',
+              ],
+              'title' => E::ts('Event info and settings'),
+            ],
+            [
+              'type' => 'field',
+              'key' => 'GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_city',
+              'dataType' => 'String',
+              'label' => E::ts('Location'),
+              'sortable' => TRUE,
+              'rewrite' => '{if \'[GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_state_province_id_label]\'} [GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_city] ([GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_state_province_id_label]) {else} [GROUP_CONCAT_Event_LocBlock_loc_block_id_01_LocBlock_Address_address_id_01_city] {/if}',
+            ],
+            [
+              'type' => 'field',
+              'key' => 'event_type_id:label',
+              'dataType' => 'Integer',
+              'label' => E::ts('Type'),
+              'sortable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'start_date',
+              'dataType' => 'Timestamp',
+              'label' => E::ts('Start Date'),
+              'sortable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'end_date',
+              'dataType' => 'Timestamp',
+              'label' => E::ts('End Date'),
+              'sortable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'is_public',
+              'dataType' => 'Boolean',
+              'label' => E::ts('Public?'),
+              'sortable' => TRUE,
+              'editable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'is_active',
+              'dataType' => 'Boolean',
+              'label' => E::ts('Active?'),
+              'sortable' => TRUE,
+              'editable' => TRUE,
+            ],
+            [
+              'type' => 'field',
+              'key' => 'COUNT_Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_01_id',
+              'dataType' => 'Integer',
+              'label' => E::ts('#Registered, Attended...'),
+              'sortable' => TRUE,
+              'link' => [
+                'path' => 'civicrm/event/search?reset=1&force=1&status=true&event=[id]',
+                'entity' => '',
+                'action' => '',
+                'join' => '',
+                'target' => '',
+              ],
+            ],
+            [
+              'type' => 'field',
+              'key' => 'COUNT_Event_Participant_event_id_01_Participant_ParticipantStatusType_status_id_02_id',
+              'dataType' => 'Integer',
+              'label' => E::ts('#Cancelled, No-show...'),
+              'sortable' => TRUE,
+              'link' => [
+                'path' => 'civicrm/event/search?reset=1&force=1&status=false&event=[id]',
+                'entity' => '',
+                'action' => '',
+                'join' => '',
+                'target' => '',
+              ],
+            ],
+            [
+              'text' => E::ts('Configure'),
+              'style' => 'default',
+              'size' => 'btn-xs',
+              'icon' => 'fa-bars',
+              'links' => [
+                [
+                  'path' => 'civicrm/event/manage/settings?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Info and Settings'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage/location?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Location'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Fees'),
+                  'style' => 'default',
+                  'path' => 'civicrm/event/manage/fee?reset=1&action=update&id=[id]',
+                  'task' => '',
+                  'condition' => [],
+                ],
+                [
+                  'path' => 'civicrm/event/manage/registration?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Online Registration'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage/reminder?reset=1&action=browse&setTab=1&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Schedule Reminders'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage/friend?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Tell a Friend'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage/pcp?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Personal Campaign Pages'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage/repeat?reset=1&action=update&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Repeat'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+              ],
+              'type' => 'menu',
+              'alignment' => '',
+            ],
+            [
+              'text' => E::ts('Event Links'),
+              'style' => 'default',
+              'size' => 'btn-xs',
+              'icon' => 'fa-bars',
+              'links' => [
+                [
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Register Participant'),
+                  'style' => 'default',
+                  'path' => 'civicrm/participant/add?reset=1&action=add&context=standalone&eid=[id]',
+                  'task' => '',
+                  'condition' => [],
+                ],
+                [
+                  'path' => '',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('View Event'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => 'Event',
+                  'action' => 'view',
+                  'join' => '',
+                  'target' => 'crm-popup',
+                ],
+                [
+                  'path' => 'civicrm/event/register?reset=1&action=preview&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Registration (Test-drive)'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/register?reset=1&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Registration (Live)'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/participant?reset=1&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Public Participant Listing'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+              ],
+              'type' => 'menu',
+              'alignment' => '',
+            ],
+            [
+              'text' => E::ts('More'),
+              'style' => 'default',
+              'size' => 'btn-xs',
+              'icon' => 'fa-bars',
+              'links' => [
+                [
+                  'path' => 'civicrm/event/manage?reset=1&action=copy&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Copy'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => '',
+                ],
+                [
+                  'path' => 'civicrm/event/manage?action=delete&id=[id]',
+                  'icon' => 'fa-external-link',
+                  'text' => E::ts('Delete'),
+                  'style' => 'default',
+                  'condition' => [],
+                  'task' => '',
+                  'entity' => '',
+                  'action' => '',
+                  'join' => '',
+                  'target' => 'crm-popup',
+                ],
+              ],
+              'type' => 'menu',
+              'alignment' => '',
+              'label' => '',
+            ],
+          ],
+          'actions' => TRUE,
+          'classes' => [
+            'table',
+            'table-striped',
+          ],
+          'toolbar' => [
+            [
+              'action' => 'add',
+              'entity' => 'Event',
+              'text' => E::ts('Add Event'),
+              'icon' => 'fa-plus',
+              'style' => 'primary',
+              'target' => '',
+              'join' => '',
+              'path' => '',
+              'task' => '',
+              'condition' => [],
+            ],
+          ],
+        ],
+      ],
+      'match' => [
+        'saved_search_id',
+        'name',
+      ],
+    ],
+  ],
+];
-- 
2.25.1