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
8 months ago
package-purchased.php
8 months ago
event-booking-status-changed.php
208 lines
| 1 | <?php |
| 2 | /** |
| 3 | * EventBookingStatusChanged. |
| 4 | * php version 5.6 |
| 5 | * |
| 6 | * @category EventBookingStatusChanged |
| 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( 'EventBookingStatusChanged' ) ) : |
| 21 | |
| 22 | /** |
| 23 | * EventBookingStatusChanged |
| 24 | * |
| 25 | * @category EventBookingStatusChanged |
| 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 EventBookingStatusChanged { |
| 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_event_booking_status_changed'; |
| 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' => __( 'Event Booking Status Changed', 'suretriggers' ), |
| 70 | 'action' => $this->trigger, |
| 71 | 'common_action' => 'AmeliaEventBookingStatusUpdated', |
| 72 | 'function' => [ $this, 'trigger_listener' ], |
| 73 | 'priority' => 10, |
| 74 | 'accepted_args' => 1, |
| 75 | ]; |
| 76 | return $triggers; |
| 77 | } |
| 78 | |
| 79 | /** |
| 80 | * Trigger listener |
| 81 | * |
| 82 | * @param array $args Appointment 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['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['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['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['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 | end( $args['bookings'] ); |
| 151 | $customer_id = key( $args['bookings'] ); |
| 152 | $customer_result = $wpdb->get_row( |
| 153 | $wpdb->prepare( |
| 154 | 'SELECT * FROM ' . $wpdb->prefix . 'amelia_users WHERE id = %d', |
| 155 | [ $args['bookings'][ $customer_id ]['customerId'] ] |
| 156 | ), |
| 157 | ARRAY_A |
| 158 | ); |
| 159 | $customer_result = isset( $customer_result ) ? $customer_result : []; |
| 160 | |
| 161 | if ( $args['bookings'][ $customer_id ]['couponId'] ) { |
| 162 | $coupon_result = $wpdb->get_row( |
| 163 | $wpdb->prepare( |
| 164 | 'SELECT code AS couponCode, expirationDate AS couponExpirationDate FROM ' . $wpdb->prefix . 'amelia_coupons WHERE id = %d', |
| 165 | [ $args['bookings'][ $customer_id ]['couponId'] ] |
| 166 | ), |
| 167 | ARRAY_A |
| 168 | ); |
| 169 | } else { |
| 170 | $coupon_result = []; |
| 171 | } |
| 172 | |
| 173 | if ( ! empty( $result['customFields'] ) ) { |
| 174 | $custom_fields = json_decode( $result['customFields'], true ); |
| 175 | |
| 176 | $fields_arr = []; |
| 177 | foreach ( (array) $custom_fields as $fields ) { |
| 178 | if ( is_array( $fields ) ) { |
| 179 | $fields_arr[ $fields['label'] ] = $fields['value']; |
| 180 | } |
| 181 | } |
| 182 | unset( $result['customFields'] ); |
| 183 | } else { |
| 184 | $fields_arr = []; |
| 185 | } |
| 186 | |
| 187 | $context = array_merge( $result, $fields_arr, $event, $customer_result, $coupon_result, $tags ); |
| 188 | $context['amelia_events_list'] = $args['id']; |
| 189 | $context['event_booking_status'] = $args['status']; |
| 190 | |
| 191 | AutomationController::sure_trigger_handle_trigger( |
| 192 | [ |
| 193 | 'trigger' => $this->trigger, |
| 194 | 'context' => $context, |
| 195 | ] |
| 196 | ); |
| 197 | } |
| 198 | } |
| 199 | |
| 200 | /** |
| 201 | * Ignore false positive |
| 202 | * |
| 203 | * @psalm-suppress UndefinedMethod |
| 204 | */ |
| 205 | EventBookingStatusChanged::get_instance(); |
| 206 | |
| 207 | endif; |
| 208 |