appointment-booked.php
2 years ago
appointment-booking-status-changed.php
2 years ago
appointment-cancelled.php
2 years ago
appointment-rescheduled.php
2 years ago
event-attendee.php
2 months ago
event-booking-status-changed.php
1 year ago
event-cancelled.php
1 year ago
event-rescheduled.php
1 year ago
package-purchase-status-updated.php
7 months ago
package-purchased.php
7 months ago
event-attendee.php
233 lines
| 1 | <?php |
| 2 | /** |
| 3 | * EventAttendee. |
| 4 | * php version 5.6 |
| 5 | * |
| 6 | * @category EventAttendee |
| 7 | * @package SureTriggers |
| 8 | * @author BSF <username@example.com> |
| 9 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3 |
| 10 | * @link https://www.brainstormforce.com/ |
| 11 | * @since 1.0.0 |
| 12 | */ |
| 13 | |
| 14 | namespace SureTriggers\Integrations\Amelia\Triggers; |
| 15 | |
| 16 | use SureTriggers\Controllers\AutomationController; |
| 17 | use SureTriggers\Integrations\WordPress\WordPress; |
| 18 | use SureTriggers\Traits\SingletonLoader; |
| 19 | |
| 20 | if ( ! class_exists( 'EventAttendee' ) ) : |
| 21 | |
| 22 | /** |
| 23 | * EventAttendee |
| 24 | * |
| 25 | * @category EventAttendee |
| 26 | * @package SureTriggers |
| 27 | * @author BSF <username@example.com> |
| 28 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3 |
| 29 | * @link https://www.brainstormforce.com/ |
| 30 | * @since 1.0.0 |
| 31 | * |
| 32 | * @psalm-suppress UndefinedTrait |
| 33 | */ |
| 34 | class EventAttendee { |
| 35 | |
| 36 | /** |
| 37 | * Integration type. |
| 38 | * |
| 39 | * @var string |
| 40 | */ |
| 41 | public $integration = 'Amelia'; |
| 42 | |
| 43 | /** |
| 44 | * Trigger name. |
| 45 | * |
| 46 | * @var string |
| 47 | */ |
| 48 | public $trigger = 'amelia_new_event_attendee'; |
| 49 | |
| 50 | use SingletonLoader; |
| 51 | |
| 52 | /** |
| 53 | * Constructor |
| 54 | * |
| 55 | * @since 1.0.0 |
| 56 | */ |
| 57 | public function __construct() { |
| 58 | add_filter( 'sure_trigger_register_trigger', [ $this, 'register' ] ); |
| 59 | } |
| 60 | |
| 61 | /** |
| 62 | * Register action. |
| 63 | * |
| 64 | * @param array $triggers trigger data. |
| 65 | * @return array |
| 66 | */ |
| 67 | public function register( $triggers ) { |
| 68 | $triggers[ $this->integration ][ $this->trigger ] = [ |
| 69 | 'label' => __( 'New Event Attendee', 'suretriggers' ), |
| 70 | 'action' => $this->trigger, |
| 71 | 'common_action' => 'AmeliaBookingAddedBeforeNotify', |
| 72 | 'function' => [ $this, 'trigger_listener' ], |
| 73 | 'priority' => 10, |
| 74 | 'accepted_args' => 2, |
| 75 | ]; |
| 76 | return $triggers; |
| 77 | } |
| 78 | |
| 79 | /** |
| 80 | * Trigger listener |
| 81 | * |
| 82 | * @param array $args Event Data. |
| 83 | * @since 1.0.0 |
| 84 | * |
| 85 | * @return void |
| 86 | */ |
| 87 | public function trigger_listener( $args ) { |
| 88 | if ( empty( $args ) ) { |
| 89 | return; |
| 90 | } |
| 91 | |
| 92 | if ( 'event' !== $args['type'] ) { |
| 93 | return; |
| 94 | } |
| 95 | |
| 96 | global $wpdb; |
| 97 | $event_periods_result = $wpdb->get_results( |
| 98 | $wpdb->prepare( |
| 99 | 'SELECT id |
| 100 | FROM ' . $wpdb->prefix . 'amelia_events_periods |
| 101 | WHERE eventId = %d', |
| 102 | [ $args['event']['id'] ] |
| 103 | ), |
| 104 | ARRAY_A |
| 105 | ); |
| 106 | if ( ! empty( $event_periods_result ) ) { |
| 107 | $ids = wp_list_pluck( $event_periods_result, 'id' ); |
| 108 | } |
| 109 | $query = 'SELECT * |
| 110 | FROM ' . $wpdb->prefix . 'amelia_customer_bookings as customer |
| 111 | INNER JOIN ' . $wpdb->prefix . 'amelia_customer_bookings_to_events_periods as event_period |
| 112 | ON customer.id = event_period.customerBookingId'; |
| 113 | if ( ! empty( $ids ) ) { |
| 114 | $query .= $wpdb->prepare( |
| 115 | ' WHERE event_period.customerBookingId = ( Select max(id) From ' . $wpdb->prefix . 'amelia_customer_bookings ) AND event_period.eventPeriodId IN (%s)', |
| 116 | implode( ',', $ids ) |
| 117 | ); |
| 118 | } else { |
| 119 | $query .= $wpdb->prepare( |
| 120 | ' WHERE event_period.customerBookingId = ( Select max(id) From ' . $wpdb->prefix . 'amelia_customer_bookings ) AND event_period.eventPeriodId = %d', |
| 121 | [ $args['event']['id'] ] |
| 122 | ); |
| 123 | } |
| 124 | $result = $wpdb->get_row( $query, ARRAY_A ); //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared |
| 125 | $result = isset( $result ) ? $result : []; |
| 126 | |
| 127 | $event = $wpdb->get_row( |
| 128 | $wpdb->prepare( |
| 129 | 'SELECT * FROM ' . $wpdb->prefix . 'amelia_events WHERE id = %d', |
| 130 | [ $args['event']['id'] ] |
| 131 | ), |
| 132 | ARRAY_A |
| 133 | ); |
| 134 | $event = isset( $event ) ? $event : []; |
| 135 | $event_tags = $wpdb->get_results( |
| 136 | $wpdb->prepare( |
| 137 | 'SELECT * FROM ' . $wpdb->prefix . 'amelia_events_tags WHERE eventId = %d', |
| 138 | [ $args['event']['id'] ] |
| 139 | ), |
| 140 | ARRAY_A |
| 141 | ); |
| 142 | $tags = []; |
| 143 | if ( ! empty( $event_tags ) ) { |
| 144 | foreach ( $event_tags as $key => $tag ) { |
| 145 | $tags['event_tag'][ $key ] = $tag['name']; |
| 146 | } |
| 147 | } else { |
| 148 | $tags = []; |
| 149 | } |
| 150 | |
| 151 | $customer_result = $wpdb->get_row( |
| 152 | $wpdb->prepare( |
| 153 | 'SELECT * FROM ' . $wpdb->prefix . 'amelia_users WHERE id = %d', |
| 154 | [ $args['booking']['customerId'] ] |
| 155 | ), |
| 156 | ARRAY_A |
| 157 | ); |
| 158 | $customer_result = isset( $customer_result ) ? $customer_result : []; |
| 159 | |
| 160 | if ( $args['booking']['couponId'] ) { |
| 161 | $coupon_result = $wpdb->get_row( |
| 162 | $wpdb->prepare( |
| 163 | 'SELECT code AS couponCode, expirationDate AS couponExpirationDate FROM ' . $wpdb->prefix . 'amelia_coupons WHERE id = %d', |
| 164 | [ $args['booking']['couponId'] ] |
| 165 | ), |
| 166 | ARRAY_A |
| 167 | ); |
| 168 | } else { |
| 169 | $coupon_result = []; |
| 170 | } |
| 171 | |
| 172 | if ( ! empty( $result['customFields'] ) ) { |
| 173 | $custom_fields = json_decode( $result['customFields'], true ); |
| 174 | |
| 175 | $fields_arr = []; |
| 176 | foreach ( (array) $custom_fields as $fields ) { |
| 177 | if ( is_array( $fields ) ) { |
| 178 | $fields_arr[ $fields['label'] ] = $fields['value']; |
| 179 | } |
| 180 | } |
| 181 | unset( $result['customFields'] ); |
| 182 | } else { |
| 183 | $fields_arr = []; |
| 184 | } |
| 185 | |
| 186 | $event_period_data = []; |
| 187 | if ( ! empty( $result['eventPeriodId'] ) ) { |
| 188 | $period_row = $wpdb->get_row( |
| 189 | $wpdb->prepare( |
| 190 | 'SELECT periodStart, periodEnd FROM ' . $wpdb->prefix . 'amelia_events_periods WHERE id = %d', |
| 191 | [ $result['eventPeriodId'] ] |
| 192 | ), |
| 193 | ARRAY_A |
| 194 | ); |
| 195 | if ( ! empty( $period_row ) ) { |
| 196 | $event_period_data = $period_row; |
| 197 | } |
| 198 | } |
| 199 | |
| 200 | $payment_data = []; |
| 201 | if ( ! empty( $result['customerBookingId'] ) ) { |
| 202 | $amount_paid = $wpdb->get_var( |
| 203 | $wpdb->prepare( |
| 204 | 'SELECT SUM(amount) FROM ' . $wpdb->prefix . 'amelia_payments WHERE customerBookingId = %d AND status = %s', |
| 205 | [ $result['customerBookingId'], 'paid' ] |
| 206 | ) |
| 207 | ); |
| 208 | $payment_data = [ |
| 209 | 'amountPaid' => null !== $amount_paid ? $amount_paid : '0', |
| 210 | ]; |
| 211 | } |
| 212 | |
| 213 | $context = array_merge( $result, $fields_arr, $event, $customer_result, $coupon_result, $tags, $event_period_data, $payment_data ); |
| 214 | $context['amelia_events_list'] = $args['event']['id']; |
| 215 | |
| 216 | AutomationController::sure_trigger_handle_trigger( |
| 217 | [ |
| 218 | 'trigger' => $this->trigger, |
| 219 | 'context' => $context, |
| 220 | ] |
| 221 | ); |
| 222 | } |
| 223 | } |
| 224 | |
| 225 | /** |
| 226 | * Ignore false positive |
| 227 | * |
| 228 | * @psalm-suppress UndefinedMethod |
| 229 | */ |
| 230 | EventAttendee::get_instance(); |
| 231 | |
| 232 | endif; |
| 233 |