@@ -1,7 +1,7 @@ discard block |
||
| 1 | 1 | <div class="padding"> |
| 2 | 2 | <ul class="infolinks"> |
| 3 | 3 | <li> |
| 4 | - <?php echo '<a href="http://eventespresso.com/wiki/installation/" target="_blank">'.__('Installation', 'event_espresso') . '</a> & <a href="http://eventespresso.com/wiki/setting-up-event-espresso/" target="_blank">' . __('Usage Guide').'</a>'; ?> |
|
| 4 | + <?php echo '<a href="http://eventespresso.com/wiki/installation/" target="_blank">'.__('Installation', 'event_espresso').'</a> & <a href="http://eventespresso.com/wiki/setting-up-event-espresso/" target="_blank">'.__('Usage Guide').'</a>'; ?> |
|
| 5 | 5 | </li> |
| 6 | 6 | <li> |
| 7 | 7 | <a href="http://eventespresso.com/wiki/put-custom-templates/" target="_blank"> |
@@ -30,7 +30,7 @@ discard block |
||
| 30 | 30 | </a> |
| 31 | 31 | </li> |
| 32 | 32 | <li> |
| 33 | - <?php echo '<a href="http://eventespresso.com/pricing/" target="_blank">'.__('Plugins', 'event_espresso'). '</a> & <a href="http://eventespresso.com/add-ons/" target="_blank">' .__('Add-ons', 'event_espresso').'</a>'; ?><br /> |
|
| 33 | + <?php echo '<a href="http://eventespresso.com/pricing/" target="_blank">'.__('Plugins', 'event_espresso').'</a> & <a href="http://eventespresso.com/add-ons/" target="_blank">'.__('Add-ons', 'event_espresso').'</a>'; ?><br /> |
|
| 34 | 34 | <br /> |
| 35 | 35 | <ol> |
| 36 | 36 | <li> |
@@ -1,6 +1,6 @@ |
||
| 1 | 1 | <?php echo $before_list_table; ?> |
| 2 | 2 | <?php $list_table->display_views(); ?> |
| 3 | -<form id="<?php echo $list_table_class; ?>-table-frm" action="<?php echo $table_url;?>" method="get"> |
|
| 3 | +<form id="<?php echo $list_table_class; ?>-table-frm" action="<?php echo $table_url; ?>" method="get"> |
|
| 4 | 4 | <?php echo $sortable_list_table_form_fields; ?> |
| 5 | 5 | <?php echo $list_table->search_box($search['btn_label'], $current_page); ?> |
| 6 | 6 | <?php echo $list_table->display(); ?> |
@@ -1,6 +1,6 @@ |
||
| 1 | 1 | <?php //EEH_Debug_Tools::printr( $admin_reports, '$admin_reports' ); ?> |
| 2 | 2 | |
| 3 | -<?php foreach ( $admin_reports as $report) : ?> |
|
| 3 | +<?php foreach ($admin_reports as $report) : ?> |
|
| 4 | 4 | |
| 5 | 5 | <div id="<?php echo $report; ?>" class="admin-report-chart-dv" style="width:95%; min-height:420px; margin:20px 4% 40px 1%;"></div> |
| 6 | 6 | |
@@ -1,5 +1,5 @@ |
||
| 1 | 1 | <div class="padding"> |
| 2 | - <p><?php _e( 'We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso' ); ?></p> |
|
| 3 | - <p><?php _e( 'Rate it five stars today!', 'event_espresso' ); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span> |
|
| 4 | - <p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e( 'Rate It!', 'event_espresso' ); ?></a></p> |
|
| 2 | + <p><?php _e('We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso'); ?></p> |
|
| 3 | + <p><?php _e('Rate it five stars today!', 'event_espresso'); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span> |
|
| 4 | + <p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e('Rate It!', 'event_espresso'); ?></a></p> |
|
| 5 | 5 | </div> |
| 6 | 6 | \ No newline at end of file |
@@ -3,8 +3,8 @@ |
||
| 3 | 3 | <span id="localized_status_save"><?php echo $localized_status_save; ?></span> |
| 4 | 4 | <span id="cur_stat_id"><?php echo $cur_status; ?></span> |
| 5 | 5 | <select name='ee_post_status' id='ee_post_status'> |
| 6 | - <?php foreach ( $statuses as $status => $label ) : ?> |
|
| 7 | - <option<?php selected( $cur_status, $status ); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option> |
|
| 6 | + <?php foreach ($statuses as $status => $label) : ?> |
|
| 7 | + <option<?php selected($cur_status, $status); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option> |
|
| 8 | 8 | <?php |
| 9 | 9 | endforeach; |
| 10 | 10 | ?> |
@@ -121,11 +121,11 @@ |
||
| 121 | 121 | //ok now find this new registration's final price |
| 122 | 122 | if( isset( $this->_reg_final_price_per_tkt_line_item[ $line_item->ID() ] ) ) { |
| 123 | 123 | $final_price = $this->_reg_final_price_per_tkt_line_item[ $line_item->ID() ] ; |
| 124 | - }else{ |
|
| 124 | + } else{ |
|
| 125 | 125 | $message = sprintf( __( 'The ticket line item (ID:%1$d) had no entry in the reg_final_price_per_tkt_line_item array.', 'event_espresso' ), $line_item->ID() ); |
| 126 | 126 | if( WP_DEBUG ){ |
| 127 | 127 | throw new EE_Error( $message ); |
| 128 | - }else{ |
|
| 128 | + } else{ |
|
| 129 | 129 | EE_Log::instance()->log(__CLASS__, __FUNCTION__, $message ); |
| 130 | 130 | } |
| 131 | 131 | $final_price = $ticket->get_ticket_total_with_taxes(); |
@@ -1,5 +1,5 @@ discard block |
||
| 1 | 1 | <?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { exit('No direct script access allowed'); } |
| 2 | -EE_Registry::instance()->load_class( 'Processor_Base' ); |
|
| 2 | +EE_Registry::instance()->load_class('Processor_Base'); |
|
| 3 | 3 | |
| 4 | 4 | /** |
| 5 | 5 | * Class EE_Registration_Processor |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | */ |
| 61 | 61 | public static function instance() { |
| 62 | 62 | // check if class object is instantiated |
| 63 | - if ( ! self::$_instance instanceof EE_Registration_Processor ) { |
|
| 63 | + if ( ! self::$_instance instanceof EE_Registration_Processor) { |
|
| 64 | 64 | self::$_instance = new self(); |
| 65 | 65 | } |
| 66 | 66 | return self::$_instance; |
@@ -96,37 +96,37 @@ discard block |
||
| 96 | 96 | * @return \EE_Registration | null |
| 97 | 97 | * @throws \EE_Error |
| 98 | 98 | */ |
| 99 | - public function generate_ONE_registration_from_line_item( EE_Line_Item $line_item, EE_Transaction $transaction, $att_nmbr = 1, $total_ticket_count = 1 ) { |
|
| 99 | + public function generate_ONE_registration_from_line_item(EE_Line_Item $line_item, EE_Transaction $transaction, $att_nmbr = 1, $total_ticket_count = 1) { |
|
| 100 | 100 | // grab the related ticket object for this line_item |
| 101 | 101 | $ticket = $line_item->ticket(); |
| 102 | - if ( ! $ticket instanceof EE_Ticket ) { |
|
| 103 | - EE_Error::add_error( sprintf( __( "Line item %s did not contain a valid ticket", "event_espresso" ), $line_item->ID() ), __FILE__, __FUNCTION__, __LINE__ ); |
|
| 102 | + if ( ! $ticket instanceof EE_Ticket) { |
|
| 103 | + EE_Error::add_error(sprintf(__("Line item %s did not contain a valid ticket", "event_espresso"), $line_item->ID()), __FILE__, __FUNCTION__, __LINE__); |
|
| 104 | 104 | return null; |
| 105 | 105 | } |
| 106 | - $first_datetime = $ticket->get_first_related( 'Datetime' ); |
|
| 107 | - if ( ! $first_datetime instanceof EE_Datetime ) { |
|
| 108 | - EE_Error::add_error( sprintf( __( "The ticket (%s) is not associated with any valid datetimes.", "event_espresso" ), $ticket->name() ), __FILE__, __FUNCTION__, __LINE__ ); |
|
| 106 | + $first_datetime = $ticket->get_first_related('Datetime'); |
|
| 107 | + if ( ! $first_datetime instanceof EE_Datetime) { |
|
| 108 | + EE_Error::add_error(sprintf(__("The ticket (%s) is not associated with any valid datetimes.", "event_espresso"), $ticket->name()), __FILE__, __FUNCTION__, __LINE__); |
|
| 109 | 109 | return null; |
| 110 | 110 | } |
| 111 | - $event = $first_datetime->get_first_related( 'Event' ); |
|
| 112 | - if ( ! $event instanceof EE_Event ) { |
|
| 113 | - EE_Error::add_error( sprintf( __( "The ticket (%s) is not associated with a valid event.", "event_espresso" ), $ticket->name() ), __FILE__, __FUNCTION__, __LINE__ ); |
|
| 111 | + $event = $first_datetime->get_first_related('Event'); |
|
| 112 | + if ( ! $event instanceof EE_Event) { |
|
| 113 | + EE_Error::add_error(sprintf(__("The ticket (%s) is not associated with a valid event.", "event_espresso"), $ticket->name()), __FILE__, __FUNCTION__, __LINE__); |
|
| 114 | 114 | return null; |
| 115 | 115 | } |
| 116 | - $reg_url_link = $this->generate_reg_url_link( $att_nmbr, $line_item ); |
|
| 116 | + $reg_url_link = $this->generate_reg_url_link($att_nmbr, $line_item); |
|
| 117 | 117 | |
| 118 | - if( $this->_reg_final_price_per_tkt_line_item === null ) { |
|
| 119 | - $this->_reg_final_price_per_tkt_line_item = EEH_Line_Item::calculate_reg_final_prices_per_line_item( $transaction->total_line_item() ); |
|
| 118 | + if ($this->_reg_final_price_per_tkt_line_item === null) { |
|
| 119 | + $this->_reg_final_price_per_tkt_line_item = EEH_Line_Item::calculate_reg_final_prices_per_line_item($transaction->total_line_item()); |
|
| 120 | 120 | } |
| 121 | 121 | //ok now find this new registration's final price |
| 122 | - if( isset( $this->_reg_final_price_per_tkt_line_item[ $line_item->ID() ] ) ) { |
|
| 123 | - $final_price = $this->_reg_final_price_per_tkt_line_item[ $line_item->ID() ] ; |
|
| 124 | - }else{ |
|
| 125 | - $message = sprintf( __( 'The ticket line item (ID:%1$d) had no entry in the reg_final_price_per_tkt_line_item array.', 'event_espresso' ), $line_item->ID() ); |
|
| 126 | - if( WP_DEBUG ){ |
|
| 127 | - throw new EE_Error( $message ); |
|
| 128 | - }else{ |
|
| 129 | - EE_Log::instance()->log(__CLASS__, __FUNCTION__, $message ); |
|
| 122 | + if (isset($this->_reg_final_price_per_tkt_line_item[$line_item->ID()])) { |
|
| 123 | + $final_price = $this->_reg_final_price_per_tkt_line_item[$line_item->ID()]; |
|
| 124 | + } else { |
|
| 125 | + $message = sprintf(__('The ticket line item (ID:%1$d) had no entry in the reg_final_price_per_tkt_line_item array.', 'event_espresso'), $line_item->ID()); |
|
| 126 | + if (WP_DEBUG) { |
|
| 127 | + throw new EE_Error($message); |
|
| 128 | + } else { |
|
| 129 | + EE_Log::instance()->log(__CLASS__, __FUNCTION__, $message); |
|
| 130 | 130 | } |
| 131 | 131 | $final_price = $ticket->get_ticket_total_with_taxes(); |
| 132 | 132 | |
@@ -146,11 +146,11 @@ discard block |
||
| 146 | 146 | 'REG_url_link' => $reg_url_link |
| 147 | 147 | ) |
| 148 | 148 | ); |
| 149 | - $registration->set_reg_code( $this->generate_reg_code( $registration ) ); |
|
| 149 | + $registration->set_reg_code($this->generate_reg_code($registration)); |
|
| 150 | 150 | $registration->save(); |
| 151 | - $registration->_add_relation_to( $event, 'Event', array(), $event->ID() ); |
|
| 152 | - $registration->_add_relation_to( $line_item->ticket(), 'Ticket', array(), $line_item->ticket()->ID() ); |
|
| 153 | - $transaction->_add_relation_to( $registration, 'Registration' ); |
|
| 151 | + $registration->_add_relation_to($event, 'Event', array(), $event->ID()); |
|
| 152 | + $registration->_add_relation_to($line_item->ticket(), 'Ticket', array(), $line_item->ticket()->ID()); |
|
| 153 | + $transaction->_add_relation_to($registration, 'Registration'); |
|
| 154 | 154 | return $registration; |
| 155 | 155 | } |
| 156 | 156 | |
@@ -163,9 +163,9 @@ discard block |
||
| 163 | 163 | * @param EE_Line_Item | string $item |
| 164 | 164 | * @return string |
| 165 | 165 | */ |
| 166 | - public function generate_reg_url_link( $att_nmbr, $item ) { |
|
| 166 | + public function generate_reg_url_link($att_nmbr, $item) { |
|
| 167 | 167 | $reg_url_link = $item instanceof EE_Line_Item ? $item->code() : $item; |
| 168 | - $reg_url_link = $att_nmbr . '-' . md5( $reg_url_link . microtime() ); |
|
| 168 | + $reg_url_link = $att_nmbr.'-'.md5($reg_url_link.microtime()); |
|
| 169 | 169 | return $reg_url_link; |
| 170 | 170 | } |
| 171 | 171 | |
@@ -177,18 +177,18 @@ discard block |
||
| 177 | 177 | * @param \EE_Registration $registration |
| 178 | 178 | * @return string |
| 179 | 179 | */ |
| 180 | - public function generate_reg_code( EE_Registration $registration ) { |
|
| 180 | + public function generate_reg_code(EE_Registration $registration) { |
|
| 181 | 181 | // figure out where to start parsing the reg code |
| 182 | - $chars = strpos( $registration->reg_url_link(), '-' ) + 5; |
|
| 182 | + $chars = strpos($registration->reg_url_link(), '-') + 5; |
|
| 183 | 183 | // TXN_ID + TKT_ID + first 3 and last 3 chars of reg_url_link |
| 184 | 184 | $new_reg_code = array( |
| 185 | 185 | $registration->transaction_ID(), |
| 186 | 186 | $registration->ticket_ID(), |
| 187 | - substr( $registration->reg_url_link(), 0, $chars ) |
|
| 187 | + substr($registration->reg_url_link(), 0, $chars) |
|
| 188 | 188 | ); |
| 189 | 189 | // now put it all together |
| 190 | - $new_reg_code = implode( '-', $new_reg_code ); |
|
| 191 | - return apply_filters( 'FHEE__EE_Registration_Processor___generate_reg_code__new_reg_code', $new_reg_code, $registration ); |
|
| 190 | + $new_reg_code = implode('-', $new_reg_code); |
|
| 191 | + return apply_filters('FHEE__EE_Registration_Processor___generate_reg_code__new_reg_code', $new_reg_code, $registration); |
|
| 192 | 192 | } |
| 193 | 193 | |
| 194 | 194 | |
@@ -197,8 +197,8 @@ discard block |
||
| 197 | 197 | * @param int $REG_ID |
| 198 | 198 | * @return string |
| 199 | 199 | */ |
| 200 | - public function old_reg_status( $REG_ID ) { |
|
| 201 | - return isset( $this->_old_reg_status[ $REG_ID ] ) ? $this->_old_reg_status[ $REG_ID ] : null; |
|
| 200 | + public function old_reg_status($REG_ID) { |
|
| 201 | + return isset($this->_old_reg_status[$REG_ID]) ? $this->_old_reg_status[$REG_ID] : null; |
|
| 202 | 202 | } |
| 203 | 203 | |
| 204 | 204 | |
@@ -207,10 +207,10 @@ discard block |
||
| 207 | 207 | * @param int $REG_ID |
| 208 | 208 | * @param string $old_reg_status |
| 209 | 209 | */ |
| 210 | - public function set_old_reg_status( $REG_ID, $old_reg_status ) { |
|
| 210 | + public function set_old_reg_status($REG_ID, $old_reg_status) { |
|
| 211 | 211 | // only set the first time |
| 212 | - if ( ! isset( $this->_old_reg_status[ $REG_ID ] ) ) { |
|
| 213 | - $this->_old_reg_status[ $REG_ID ] = $old_reg_status; |
|
| 212 | + if ( ! isset($this->_old_reg_status[$REG_ID])) { |
|
| 213 | + $this->_old_reg_status[$REG_ID] = $old_reg_status; |
|
| 214 | 214 | } |
| 215 | 215 | } |
| 216 | 216 | |
@@ -220,8 +220,8 @@ discard block |
||
| 220 | 220 | * @param int $REG_ID |
| 221 | 221 | * @return string |
| 222 | 222 | */ |
| 223 | - public function new_reg_status( $REG_ID ) { |
|
| 224 | - return isset( $this->_new_reg_status[ $REG_ID ] ) ? $this->_new_reg_status[ $REG_ID ] : null; |
|
| 223 | + public function new_reg_status($REG_ID) { |
|
| 224 | + return isset($this->_new_reg_status[$REG_ID]) ? $this->_new_reg_status[$REG_ID] : null; |
|
| 225 | 225 | } |
| 226 | 226 | |
| 227 | 227 | |
@@ -230,8 +230,8 @@ discard block |
||
| 230 | 230 | * @param int $REG_ID |
| 231 | 231 | * @param string $new_reg_status |
| 232 | 232 | */ |
| 233 | - public function set_new_reg_status( $REG_ID, $new_reg_status ) { |
|
| 234 | - $this->_new_reg_status[ $REG_ID ] = $new_reg_status; |
|
| 233 | + public function set_new_reg_status($REG_ID, $new_reg_status) { |
|
| 234 | + $this->_new_reg_status[$REG_ID] = $new_reg_status; |
|
| 235 | 235 | } |
| 236 | 236 | |
| 237 | 237 | |
@@ -242,8 +242,8 @@ discard block |
||
| 242 | 242 | * @param int $REG_ID |
| 243 | 243 | * @return bool |
| 244 | 244 | */ |
| 245 | - public function reg_status_updated( $REG_ID ) { |
|
| 246 | - return $this->new_reg_status( $REG_ID ) !== $this->old_reg_status( $REG_ID ) ? true : false; |
|
| 245 | + public function reg_status_updated($REG_ID) { |
|
| 246 | + return $this->new_reg_status($REG_ID) !== $this->old_reg_status($REG_ID) ? true : false; |
|
| 247 | 247 | } |
| 248 | 248 | |
| 249 | 249 | |
@@ -257,19 +257,19 @@ discard block |
||
| 257 | 257 | * @param bool $save TRUE will save the registration if the status is updated, FALSE will leave that up to client code |
| 258 | 258 | * @return boolean |
| 259 | 259 | */ |
| 260 | - public function manually_update_registration_status( EE_Registration $registration, $new_reg_status = '', $save = true ) { |
|
| 260 | + public function manually_update_registration_status(EE_Registration $registration, $new_reg_status = '', $save = true) { |
|
| 261 | 261 | // set initial REG_Status |
| 262 | - $this->set_old_reg_status( $registration->ID(), $registration->status_ID() ); |
|
| 262 | + $this->set_old_reg_status($registration->ID(), $registration->status_ID()); |
|
| 263 | 263 | // set incoming REG_Status |
| 264 | - $this->set_new_reg_status( $registration->ID(), $new_reg_status ); |
|
| 264 | + $this->set_new_reg_status($registration->ID(), $new_reg_status); |
|
| 265 | 265 | // toggle reg status but only if it has changed and the user can do so |
| 266 | 266 | if ( |
| 267 | - $this->reg_status_updated( $registration->ID() ) && |
|
| 268 | - EE_Registry::instance()->CAP->current_user_can( 'ee_edit_registration', 'toggle_registration_status', $registration->ID() ) |
|
| 267 | + $this->reg_status_updated($registration->ID()) && |
|
| 268 | + EE_Registry::instance()->CAP->current_user_can('ee_edit_registration', 'toggle_registration_status', $registration->ID()) |
|
| 269 | 269 | ) { |
| 270 | 270 | // change status to new value |
| 271 | - if ( $registration->set_status( $this->new_reg_status( $registration->ID() ) )) { |
|
| 272 | - if ( $save ) { |
|
| 271 | + if ($registration->set_status($this->new_reg_status($registration->ID()))) { |
|
| 272 | + if ($save) { |
|
| 273 | 273 | $registration->save(); |
| 274 | 274 | } |
| 275 | 275 | } |
@@ -290,30 +290,30 @@ discard block |
||
| 290 | 290 | * @return void |
| 291 | 291 | * @throws \EE_Error |
| 292 | 292 | */ |
| 293 | - public function toggle_incomplete_registration_status_to_default( EE_Registration $registration, $save = TRUE ) { |
|
| 293 | + public function toggle_incomplete_registration_status_to_default(EE_Registration $registration, $save = TRUE) { |
|
| 294 | 294 | $existing_reg_status = $registration->status_ID(); |
| 295 | 295 | // set initial REG_Status |
| 296 | - $this->set_old_reg_status( $registration->ID(), $existing_reg_status ); |
|
| 296 | + $this->set_old_reg_status($registration->ID(), $existing_reg_status); |
|
| 297 | 297 | // is the registration currently incomplete ? |
| 298 | - if ( $registration->status_ID() === EEM_Registration::status_id_incomplete ) { |
|
| 298 | + if ($registration->status_ID() === EEM_Registration::status_id_incomplete) { |
|
| 299 | 299 | // grab default reg status for the event, if set |
| 300 | 300 | $event_default_registration_status = $registration->event()->default_registration_status(); |
| 301 | 301 | // if no default reg status is set for the event, then use the global value |
| 302 | - $STS_ID = ! empty( $event_default_registration_status ) |
|
| 302 | + $STS_ID = ! empty($event_default_registration_status) |
|
| 303 | 303 | ? $event_default_registration_status |
| 304 | 304 | : EE_Registry::instance()->CFG->registration->default_STS_ID; |
| 305 | 305 | // if the event default reg status is approved, then downgrade temporarily to payment pending to ensure that payments are triggered |
| 306 | 306 | $STS_ID = $STS_ID === EEM_Registration::status_id_approved ? EEM_Registration::status_id_pending_payment : $STS_ID; |
| 307 | 307 | // set incoming REG_Status |
| 308 | - $this->set_new_reg_status( $registration->ID(), $STS_ID ); |
|
| 309 | - $registration->set_status( $STS_ID ); |
|
| 310 | - if ( $save ) { |
|
| 308 | + $this->set_new_reg_status($registration->ID(), $STS_ID); |
|
| 309 | + $registration->set_status($STS_ID); |
|
| 310 | + if ($save) { |
|
| 311 | 311 | $registration->save(); |
| 312 | 312 | } |
| 313 | 313 | // don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor |
| 314 | - if ( ! EE_Processor_Base::$IPN ) { |
|
| 314 | + if ( ! EE_Processor_Base::$IPN) { |
|
| 315 | 315 | // otherwise, send out notifications |
| 316 | - add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 ); |
|
| 316 | + add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10); |
|
| 317 | 317 | } |
| 318 | 318 | // DEBUG LOG |
| 319 | 319 | //$this->log( |
@@ -337,25 +337,25 @@ discard block |
||
| 337 | 337 | * @param bool $save TRUE will save the registration if the status is updated, FALSE will leave that up to client code |
| 338 | 338 | * @return boolean |
| 339 | 339 | */ |
| 340 | - public function toggle_registration_status_for_default_approved_events( EE_Registration $registration, $save = TRUE ) { |
|
| 340 | + public function toggle_registration_status_for_default_approved_events(EE_Registration $registration, $save = TRUE) { |
|
| 341 | 341 | // set initial REG_Status |
| 342 | - $this->set_old_reg_status( $registration->ID(), $registration->status_ID() ); |
|
| 342 | + $this->set_old_reg_status($registration->ID(), $registration->status_ID()); |
|
| 343 | 343 | // if not already, toggle reg status to approved IF the event default reg status is approved |
| 344 | 344 | if ( |
| 345 | 345 | $registration->status_ID() !== EEM_Registration::status_id_approved && |
| 346 | 346 | $registration->event()->default_registration_status() == EEM_Registration::status_id_approved |
| 347 | 347 | ) { |
| 348 | 348 | // set incoming REG_Status |
| 349 | - $this->set_new_reg_status( $registration->ID(), EEM_Registration::status_id_approved ); |
|
| 349 | + $this->set_new_reg_status($registration->ID(), EEM_Registration::status_id_approved); |
|
| 350 | 350 | // toggle status to approved |
| 351 | - $registration->set_status( EEM_Registration::status_id_approved ); |
|
| 352 | - if ( $save ) { |
|
| 351 | + $registration->set_status(EEM_Registration::status_id_approved); |
|
| 352 | + if ($save) { |
|
| 353 | 353 | $registration->save(); |
| 354 | 354 | } |
| 355 | 355 | // don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor |
| 356 | - if ( ! EE_Processor_Base::$IPN ) { |
|
| 356 | + if ( ! EE_Processor_Base::$IPN) { |
|
| 357 | 357 | // otherwise, send out notifications |
| 358 | - add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 ); |
|
| 358 | + add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10); |
|
| 359 | 359 | } |
| 360 | 360 | // DEBUG LOG |
| 361 | 361 | //$this->log( |
@@ -383,19 +383,19 @@ discard block |
||
| 383 | 383 | * @return bool |
| 384 | 384 | * @throws \EE_Error |
| 385 | 385 | */ |
| 386 | - public function toggle_registration_status_if_no_monies_owing( EE_Registration $registration, $save = TRUE, $additional_details = array() ) { |
|
| 386 | + public function toggle_registration_status_if_no_monies_owing(EE_Registration $registration, $save = TRUE, $additional_details = array()) { |
|
| 387 | 387 | // set initial REG_Status |
| 388 | - $this->set_old_reg_status( $registration->ID(), $registration->status_ID() ); |
|
| 388 | + $this->set_old_reg_status($registration->ID(), $registration->status_ID()); |
|
| 389 | 389 | //EEH_Debug_Tools::printr( $additional_details, '$additional_details', __FILE__, __LINE__ ); |
| 390 | 390 | // was a payment just made ? |
| 391 | 391 | if ( |
| 392 | - isset( $additional_details[ 'payment_updates' ], $additional_details[ 'last_payment' ] ) && |
|
| 393 | - $additional_details[ 'payment_updates' ] && |
|
| 394 | - $additional_details[ 'last_payment' ] instanceof EE_Payment |
|
| 392 | + isset($additional_details['payment_updates'], $additional_details['last_payment']) && |
|
| 393 | + $additional_details['payment_updates'] && |
|
| 394 | + $additional_details['last_payment'] instanceof EE_Payment |
|
| 395 | 395 | ) { |
| 396 | - $payment = $additional_details[ 'last_payment' ]; |
|
| 396 | + $payment = $additional_details['last_payment']; |
|
| 397 | 397 | $total_paid = 0; |
| 398 | - foreach ( self::$_amount_paid as $reg => $amount_paid ) { |
|
| 398 | + foreach (self::$_amount_paid as $reg => $amount_paid) { |
|
| 399 | 399 | $total_paid += $amount_paid; |
| 400 | 400 | } |
| 401 | 401 | } else { |
@@ -419,30 +419,30 @@ discard block |
||
| 419 | 419 | $registration->transaction()->is_completed() || |
| 420 | 420 | $registration->transaction()->is_overpaid() || |
| 421 | 421 | $registration->transaction()->is_free() || |
| 422 | - apply_filters( 'FHEE__EE_Registration_Processor__toggle_registration_status_if_no_monies_owing', false, $registration ) |
|
| 422 | + apply_filters('FHEE__EE_Registration_Processor__toggle_registration_status_if_no_monies_owing', false, $registration) |
|
| 423 | 423 | ) || ( |
| 424 | 424 | $payment instanceof EE_Payment && |
| 425 | 425 | $payment->is_approved() && |
| 426 | 426 | // this specific registration has not yet been paid for |
| 427 | - ! isset( self::$_amount_paid[ $registration->ID() ] ) && |
|
| 427 | + ! isset(self::$_amount_paid[$registration->ID()]) && |
|
| 428 | 428 | // payment amount, less what we have already attributed to other registrations, is greater than this reg's final price |
| 429 | 429 | $payment->amount() - $total_paid >= $registration->final_price() |
| 430 | 430 | ) |
| 431 | 431 | ) |
| 432 | 432 | ) { |
| 433 | 433 | // mark as paid |
| 434 | - self::$_amount_paid[ $registration->ID() ] = $registration->final_price(); |
|
| 434 | + self::$_amount_paid[$registration->ID()] = $registration->final_price(); |
|
| 435 | 435 | // track new REG_Status |
| 436 | - $this->set_new_reg_status( $registration->ID(), EEM_Registration::status_id_approved ); |
|
| 436 | + $this->set_new_reg_status($registration->ID(), EEM_Registration::status_id_approved); |
|
| 437 | 437 | // toggle status to approved |
| 438 | - $registration->set_status( EEM_Registration::status_id_approved ); |
|
| 439 | - if ( $save ) { |
|
| 438 | + $registration->set_status(EEM_Registration::status_id_approved); |
|
| 439 | + if ($save) { |
|
| 440 | 440 | $registration->save(); |
| 441 | 441 | } |
| 442 | 442 | // don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor |
| 443 | - if ( ! EE_Processor_Base::$IPN ) { |
|
| 443 | + if ( ! EE_Processor_Base::$IPN) { |
|
| 444 | 444 | // otherwise, send out notifications |
| 445 | - add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 ); |
|
| 445 | + add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10); |
|
| 446 | 446 | } |
| 447 | 447 | // DEBUG LOG |
| 448 | 448 | //$this->log( |
@@ -468,19 +468,19 @@ discard block |
||
| 468 | 468 | * @param array $additional_details |
| 469 | 469 | * @return void |
| 470 | 470 | */ |
| 471 | - public function trigger_registration_update_notifications( $registration, $additional_details = array() ) { |
|
| 471 | + public function trigger_registration_update_notifications($registration, $additional_details = array()) { |
|
| 472 | 472 | try { |
| 473 | - if ( ! $registration instanceof EE_Registration ) { |
|
| 474 | - throw new EE_Error( __( 'An invalid registration was received.', 'event_espresso' ) ); |
|
| 473 | + if ( ! $registration instanceof EE_Registration) { |
|
| 474 | + throw new EE_Error(__('An invalid registration was received.', 'event_espresso')); |
|
| 475 | 475 | } |
| 476 | - EEH_Debug_Tools::log( __CLASS__, __FUNCTION__, __LINE__, array( $registration->transaction(), $additional_details ), false, 'EE_Transaction: ' . $registration->transaction()->ID() ); |
|
| 476 | + EEH_Debug_Tools::log(__CLASS__, __FUNCTION__, __LINE__, array($registration->transaction(), $additional_details), false, 'EE_Transaction: '.$registration->transaction()->ID()); |
|
| 477 | 477 | do_action( |
| 478 | 478 | 'AHEE__EE_Registration_Processor__trigger_registration_update_notifications', |
| 479 | 479 | $registration, |
| 480 | 480 | $additional_details |
| 481 | 481 | ); |
| 482 | - } catch( Exception $e ) { |
|
| 483 | - EE_Error::add_error( $e->getMessage(), $e->getFile(), 'unknown_function_from_exception', $e->getLine() ); |
|
| 482 | + } catch (Exception $e) { |
|
| 483 | + EE_Error::add_error($e->getMessage(), $e->getFile(), 'unknown_function_from_exception', $e->getLine()); |
|
| 484 | 484 | } |
| 485 | 485 | } |
| 486 | 486 | |
@@ -493,18 +493,18 @@ discard block |
||
| 493 | 493 | * @param array $additional_details |
| 494 | 494 | * @return bool |
| 495 | 495 | */ |
| 496 | - public function update_registration_after_checkout_or_payment( EE_Registration $registration, $additional_details = array() ) { |
|
| 496 | + public function update_registration_after_checkout_or_payment(EE_Registration $registration, $additional_details = array()) { |
|
| 497 | 497 | // set initial REG_Status |
| 498 | - $this->set_old_reg_status( $registration->ID(), $registration->status_ID() ); |
|
| 498 | + $this->set_old_reg_status($registration->ID(), $registration->status_ID()); |
|
| 499 | 499 | |
| 500 | 500 | // if the registration status gets updated, then save the registration |
| 501 | - if ( $this->toggle_registration_status_for_default_approved_events( $registration, false ) || $this->toggle_registration_status_if_no_monies_owing( $registration, false, $additional_details )) { |
|
| 501 | + if ($this->toggle_registration_status_for_default_approved_events($registration, false) || $this->toggle_registration_status_if_no_monies_owing($registration, false, $additional_details)) { |
|
| 502 | 502 | $registration->save(); |
| 503 | 503 | } |
| 504 | 504 | |
| 505 | 505 | // set new REG_Status |
| 506 | - $this->set_new_reg_status( $registration->ID(), $registration->status_ID() ); |
|
| 507 | - return $this->reg_status_updated( $registration->ID() ) && $this->new_reg_status( $registration->ID() ) == EEM_Registration::status_id_approved ? true : false; |
|
| 506 | + $this->set_new_reg_status($registration->ID(), $registration->status_ID()); |
|
| 507 | + return $this->reg_status_updated($registration->ID()) && $this->new_reg_status($registration->ID()) == EEM_Registration::status_id_approved ? true : false; |
|
| 508 | 508 | } |
| 509 | 509 | |
| 510 | 510 | /** |
@@ -514,19 +514,19 @@ discard block |
||
| 514 | 514 | * @param boolean $save_regs whether to immediately save registrations in this function or not |
| 515 | 515 | * @return void |
| 516 | 516 | */ |
| 517 | - public function update_registration_final_prices( $transaction, $save_regs = true ) { |
|
| 518 | - $reg_final_price_per_ticket_line_item = EEH_Line_Item::calculate_reg_final_prices_per_line_item( $transaction->total_line_item() ); |
|
| 519 | - foreach( $transaction->registrations() as $registration ) { |
|
| 520 | - $line_item = EEM_Line_Item::instance()->get_line_item_for_registration( $registration ); |
|
| 521 | - if( isset( $reg_final_price_per_ticket_line_item[ $line_item->ID() ] ) ) { |
|
| 522 | - $registration->set_final_price( $reg_final_price_per_ticket_line_item[ $line_item->ID() ] ); |
|
| 523 | - if( $save_regs ) { |
|
| 517 | + public function update_registration_final_prices($transaction, $save_regs = true) { |
|
| 518 | + $reg_final_price_per_ticket_line_item = EEH_Line_Item::calculate_reg_final_prices_per_line_item($transaction->total_line_item()); |
|
| 519 | + foreach ($transaction->registrations() as $registration) { |
|
| 520 | + $line_item = EEM_Line_Item::instance()->get_line_item_for_registration($registration); |
|
| 521 | + if (isset($reg_final_price_per_ticket_line_item[$line_item->ID()])) { |
|
| 522 | + $registration->set_final_price($reg_final_price_per_ticket_line_item[$line_item->ID()]); |
|
| 523 | + if ($save_regs) { |
|
| 524 | 524 | $registration->save(); |
| 525 | 525 | } |
| 526 | 526 | } |
| 527 | 527 | } |
| 528 | 528 | //and make sure there's no rounding problem |
| 529 | - $this->fix_reg_final_price_rounding_issue( $transaction ); |
|
| 529 | + $this->fix_reg_final_price_rounding_issue($transaction); |
|
| 530 | 530 | } |
| 531 | 531 | |
| 532 | 532 | /** |
@@ -542,7 +542,7 @@ discard block |
||
| 542 | 542 | * @param EE_Transaction $transaction |
| 543 | 543 | * @return boolean success verifying that there is NO difference after this method is done |
| 544 | 544 | */ |
| 545 | - public function fix_reg_final_price_rounding_issue( $transaction ) { |
|
| 545 | + public function fix_reg_final_price_rounding_issue($transaction) { |
|
| 546 | 546 | $reg_final_price_sum = EEM_Registration::instance()->sum( |
| 547 | 547 | array( |
| 548 | 548 | array( |
@@ -551,9 +551,9 @@ discard block |
||
| 551 | 551 | ), |
| 552 | 552 | 'REG_final_price' |
| 553 | 553 | ); |
| 554 | - $diff = $transaction->total() - floatval( $reg_final_price_sum ); |
|
| 554 | + $diff = $transaction->total() - floatval($reg_final_price_sum); |
|
| 555 | 555 | //ok then, just grab one of the registrations |
| 556 | - if( $diff != 0 ) { |
|
| 556 | + if ($diff != 0) { |
|
| 557 | 557 | $a_reg = EEM_Registration::instance()->get_one( |
| 558 | 558 | array( |
| 559 | 559 | array( |
@@ -562,7 +562,7 @@ discard block |
||
| 562 | 562 | )); |
| 563 | 563 | $success = $a_reg instanceof EE_Registration ? $a_reg->save( |
| 564 | 564 | array( |
| 565 | - 'REG_final_price' => ( $a_reg->final_price() + $diff ) |
|
| 565 | + 'REG_final_price' => ($a_reg->final_price() + $diff) |
|
| 566 | 566 | ) |
| 567 | 567 | ) : false; |
| 568 | 568 | return $success ? true : false; |
@@ -30,7 +30,7 @@ discard block |
||
| 30 | 30 | )); |
| 31 | 31 | */ |
| 32 | 32 | |
| 33 | -class EE_DMS_4_1_0_answers extends EE_Data_Migration_Script_Stage_Table{ |
|
| 33 | +class EE_DMS_4_1_0_answers extends EE_Data_Migration_Script_Stage_Table { |
|
| 34 | 34 | private $_new_answer_table; |
| 35 | 35 | private $_new_question_table; |
| 36 | 36 | function __construct() { |
@@ -47,13 +47,13 @@ discard block |
||
| 47 | 47 | $old_attendee_table = $wpdb->prefix."events_attendee"; |
| 48 | 48 | $new_reg_table = $wpdb->prefix."esp_registration"; |
| 49 | 49 | $regs = $this->get_migration_script()->get_mapping_new_pk($old_attendee_table, $old_row['attendee_id'], $new_reg_table); |
| 50 | - if( ! $regs){ |
|
| 51 | - $this->add_error(sprintf(__("Could not find new registrations for old attendee %d when creating answer %s", "event_espresso"),$old_row['attendee_id'], $this->_json_encode($old_row))); |
|
| 50 | + if ( ! $regs) { |
|
| 51 | + $this->add_error(sprintf(__("Could not find new registrations for old attendee %d when creating answer %s", "event_espresso"), $old_row['attendee_id'], $this->_json_encode($old_row))); |
|
| 52 | 52 | return false; |
| 53 | 53 | } |
| 54 | 54 | //as inefficient as this sounds, we create an answer per REGISTRATION, (even if the registrations use the same attendee) |
| 55 | - foreach($regs as $new_reg_id){ |
|
| 56 | - $new_answer_id = $this->_insert_new_answer($old_row,$new_reg_id); |
|
| 55 | + foreach ($regs as $new_reg_id) { |
|
| 56 | + $new_answer_id = $this->_insert_new_answer($old_row, $new_reg_id); |
|
| 57 | 57 | } |
| 58 | 58 | } |
| 59 | 59 | /** |
@@ -63,15 +63,15 @@ discard block |
||
| 63 | 63 | * @param int $new_reg_id |
| 64 | 64 | * @return int |
| 65 | 65 | */ |
| 66 | - private function _insert_new_answer($old_answer,$new_reg_id){ |
|
| 66 | + private function _insert_new_answer($old_answer, $new_reg_id) { |
|
| 67 | 67 | global $wpdb; |
| 68 | 68 | $old_question_table = $wpdb->prefix."events_question"; |
| 69 | 69 | $new_question_id = $this->get_migration_script()->get_mapping_new_pk($old_question_table, $old_answer['question_id'], $this->_new_question_table); |
| 70 | 70 | |
| 71 | 71 | $question_type = $this->_get_question_type($new_question_id); |
| 72 | - if(in_array($question_type,array('MULTIPLE'))){ |
|
| 73 | - $ans_value = serialize(explode(",",stripslashes($old_answer['answer']))); |
|
| 74 | - }else{ |
|
| 72 | + if (in_array($question_type, array('MULTIPLE'))) { |
|
| 73 | + $ans_value = serialize(explode(",", stripslashes($old_answer['answer']))); |
|
| 74 | + } else { |
|
| 75 | 75 | $ans_value = stripslashes($old_answer['answer']); |
| 76 | 76 | } |
| 77 | 77 | $cols_n_values = array( |
@@ -80,12 +80,12 @@ discard block |
||
| 80 | 80 | 'ANS_value'=>$ans_value |
| 81 | 81 | ); |
| 82 | 82 | $datatypes = array( |
| 83 | - '%d',//REG_ID |
|
| 84 | - '%d',//QST_ID |
|
| 85 | - '%s',//ANS_value |
|
| 83 | + '%d', //REG_ID |
|
| 84 | + '%d', //QST_ID |
|
| 85 | + '%s', //ANS_value |
|
| 86 | 86 | ); |
| 87 | - $success = $wpdb->insert($this->_new_answer_table,$cols_n_values,$datatypes); |
|
| 88 | - if ( ! $success){ |
|
| 87 | + $success = $wpdb->insert($this->_new_answer_table, $cols_n_values, $datatypes); |
|
| 88 | + if ( ! $success) { |
|
| 89 | 89 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_answer, $this->_new_answer_table, $cols_n_values, $datatypes)); |
| 90 | 90 | return 0; |
| 91 | 91 | } |
@@ -99,9 +99,9 @@ discard block |
||
| 99 | 99 | * @param type $question_id |
| 100 | 100 | * @return string |
| 101 | 101 | */ |
| 102 | - private function _get_question_type($question_id){ |
|
| 102 | + private function _get_question_type($question_id) { |
|
| 103 | 103 | global $wpdb; |
| 104 | - $type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1",$question_id)); |
|
| 104 | + $type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1", $question_id)); |
|
| 105 | 105 | return $type; |
| 106 | 106 | } |
| 107 | 107 | |
@@ -71,7 +71,7 @@ |
||
| 71 | 71 | $question_type = $this->_get_question_type($new_question_id); |
| 72 | 72 | if(in_array($question_type,array('MULTIPLE'))){ |
| 73 | 73 | $ans_value = serialize(explode(",",stripslashes($old_answer['answer']))); |
| 74 | - }else{ |
|
| 74 | + } else{ |
|
| 75 | 75 | $ans_value = stripslashes($old_answer['answer']); |
| 76 | 76 | } |
| 77 | 77 | $cols_n_values = array( |
@@ -84,9 +84,6 @@ |
||
| 84 | 84 | KEY `submitted` (`submitted`), |
| 85 | 85 | KEY `likes` (`likes`) |
| 86 | 86 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$ |
| 87 | - |
|
| 88 | - |
|
| 89 | - |
|
| 90 | 87 | * 4.1 Attendee tables and fields: |
| 91 | 88 | * $this->_tables = array( |
| 92 | 89 | 'Attendee_CPT'=> new EE_Primary_Table('posts', 'ID'), |
@@ -339,13 +339,13 @@ discard block |
||
| 339 | 339 | try{ |
| 340 | 340 | $new_country = $this->get_migration_script()->get_or_create_country(stripslashes($old_attendee['country_id'])); |
| 341 | 341 | $new_country_iso = $new_country['CNT_ISO']; |
| 342 | - }catch(EE_Error $exception){ |
|
| 342 | + } catch(EE_Error $exception){ |
|
| 343 | 343 | $new_country_iso = $this->get_migration_script()->get_default_country_iso(); |
| 344 | 344 | } |
| 345 | 345 | try{ |
| 346 | 346 | $new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']),$new_country_iso); |
| 347 | 347 | $new_state_id = $new_state['STA_ID']; |
| 348 | - }catch(EE_Error $exception){ |
|
| 348 | + } catch(EE_Error $exception){ |
|
| 349 | 349 | $new_state_id = 0; |
| 350 | 350 | } |
| 351 | 351 | $cols_n_values = array( |
@@ -459,7 +459,7 @@ discard block |
||
| 459 | 459 | |
| 460 | 460 | if( $wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table){ |
| 461 | 461 | $this->_mer_tables_exist = false; |
| 462 | - }else{ |
|
| 462 | + } else{ |
|
| 463 | 463 | $this->_mer_tables_exist = true; |
| 464 | 464 | } |
| 465 | 465 | } |
@@ -584,7 +584,7 @@ discard block |
||
| 584 | 584 | if( ! $success_update_dateimtes){ |
| 585 | 585 | $this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error)); |
| 586 | 586 | } |
| 587 | - }else{ |
|
| 587 | + } else{ |
|
| 588 | 588 | $this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error)); |
| 589 | 589 | } |
| 590 | 590 | return true; |
@@ -791,7 +791,7 @@ discard block |
||
| 791 | 791 | $new_id = $wpdb->insert_id; |
| 792 | 792 | return $new_id; |
| 793 | 793 | |
| 794 | - }else{ |
|
| 794 | + } else{ |
|
| 795 | 795 | return 0; |
| 796 | 796 | } |
| 797 | 797 | |
@@ -214,7 +214,7 @@ discard block |
||
| 214 | 214 | ) |
| 215 | 215 | ); |
| 216 | 216 | */ |
| 217 | -class EE_DMS_4_1_0_attendees extends EE_Data_Migration_Script_Stage_Table{ |
|
| 217 | +class EE_DMS_4_1_0_attendees extends EE_Data_Migration_Script_Stage_Table { |
|
| 218 | 218 | private $_new_attendee_cpt_table; |
| 219 | 219 | private $_new_attendee_meta_table; |
| 220 | 220 | private $_new_reg_table; |
@@ -237,7 +237,7 @@ discard block |
||
| 237 | 237 | global $wpdb; |
| 238 | 238 | $this->_pretty_name = __("Attendees", "event_espresso"); |
| 239 | 239 | $this->_old_table = $wpdb->prefix."events_attendee"; |
| 240 | - $this->_old_mer_table = $wpdb->prefix."events_multi_event_registration_id_group";; |
|
| 240 | + $this->_old_mer_table = $wpdb->prefix."events_multi_event_registration_id_group"; ; |
|
| 241 | 241 | $this->_new_attendee_cpt_table = $wpdb->posts; |
| 242 | 242 | $this->_new_attendee_meta_table = $wpdb->prefix."esp_attendee_meta"; |
| 243 | 243 | $this->_new_reg_table = $wpdb->prefix."esp_registration"; |
@@ -256,34 +256,34 @@ discard block |
||
| 256 | 256 | protected function _migrate_old_row($old_row) { |
| 257 | 257 | //first check if there's already a new attendee with similar characteristics |
| 258 | 258 | $new_att_id = $this->_find_attendee_cpt_matching($old_row); |
| 259 | - if( ! $new_att_id ){ |
|
| 259 | + if ( ! $new_att_id) { |
|
| 260 | 260 | $new_att_id = $this->_insert_new_attendee_cpt($old_row); |
| 261 | - if( ! $new_att_id){ |
|
| 261 | + if ( ! $new_att_id) { |
|
| 262 | 262 | //if we couldnt even make an attendee, abandon all hope |
| 263 | 263 | return false; |
| 264 | 264 | } |
| 265 | 265 | $new_att_meta_id = $this->_insert_attendee_meta_row($old_row, $new_att_id); |
| 266 | - if($new_att_meta_id){ |
|
| 266 | + if ($new_att_meta_id) { |
|
| 267 | 267 | $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_attendee_meta_table, $new_att_meta_id); |
| 268 | 268 | } |
| 269 | 269 | } |
| 270 | 270 | $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_attendee_cpt_table, $new_att_id); |
| 271 | 271 | |
| 272 | 272 | $txn_id = $this->_insert_new_transaction($old_row); |
| 273 | - if( ! $txn_id){ |
|
| 273 | + if ( ! $txn_id) { |
|
| 274 | 274 | //if we couldnt make the transaction, also abandon all hope |
| 275 | 275 | return false; |
| 276 | 276 | } |
| 277 | - $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_transaction_table, $txn_id);$pay_id = $this->_insert_new_payment($old_row,$txn_id); |
|
| 278 | - if($pay_id){ |
|
| 279 | - $this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_payment_table,$pay_id); |
|
| 277 | + $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_transaction_table, $txn_id); $pay_id = $this->_insert_new_payment($old_row, $txn_id); |
|
| 278 | + if ($pay_id) { |
|
| 279 | + $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_payment_table, $pay_id); |
|
| 280 | 280 | } |
| 281 | 281 | |
| 282 | 282 | |
| 283 | 283 | //even if there was no payment, we can go ahead with adding the reg |
| 284 | - $new_regs = $this->_insert_new_registrations($old_row,$new_att_id,$txn_id); |
|
| 285 | - if($new_regs){ |
|
| 286 | - $this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_reg_table,$new_regs); |
|
| 284 | + $new_regs = $this->_insert_new_registrations($old_row, $new_att_id, $txn_id); |
|
| 285 | + if ($new_regs) { |
|
| 286 | + $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_reg_table, $new_regs); |
|
| 287 | 287 | } |
| 288 | 288 | } |
| 289 | 289 | /** |
@@ -293,39 +293,39 @@ discard block |
||
| 293 | 293 | * @param array $old_attendee |
| 294 | 294 | * @return int |
| 295 | 295 | */ |
| 296 | - private function _find_attendee_cpt_matching($old_attendee){ |
|
| 296 | + private function _find_attendee_cpt_matching($old_attendee) { |
|
| 297 | 297 | global $wpdb; |
| 298 | - $existing_attendee_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_new_attendee_cpt_table." AS cpt INNER JOIN ".$this->_new_attendee_meta_table." AS meta ON cpt.ID = meta.ATT_ID WHERE meta.ATT_fname = %s AND meta.ATT_lname = %s AND meta.ATT_email = %s LIMIT 1",$old_attendee['fname'],$old_attendee['lname'],$old_attendee['email'])); |
|
| 298 | + $existing_attendee_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_new_attendee_cpt_table." AS cpt INNER JOIN ".$this->_new_attendee_meta_table." AS meta ON cpt.ID = meta.ATT_ID WHERE meta.ATT_fname = %s AND meta.ATT_lname = %s AND meta.ATT_email = %s LIMIT 1", $old_attendee['fname'], $old_attendee['lname'], $old_attendee['email'])); |
|
| 299 | 299 | return intval($existing_attendee_id); |
| 300 | 300 | } |
| 301 | - private function _insert_new_attendee_cpt($old_attendee){ |
|
| 301 | + private function _insert_new_attendee_cpt($old_attendee) { |
|
| 302 | 302 | global $wpdb; |
| 303 | 303 | $cols_n_values = array( |
| 304 | - 'post_title'=>stripslashes($old_attendee['fname']." ".$old_attendee['lname']),//ATT_full_name |
|
| 305 | - 'post_content'=>'',//ATT_bio |
|
| 306 | - 'post_name'=>sanitize_title($old_attendee['fname']."-".$old_attendee['lname']),//ATT_slug |
|
| 307 | - 'post_date'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),//ATT_created |
|
| 308 | - 'post_excerpt'=>'',//ATT_short_bio |
|
| 309 | - 'post_modified'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),//ATT_modified |
|
| 310 | - 'post_author'=>0,//ATT_author |
|
| 311 | - 'post_parent'=>0,//ATT_parent |
|
| 312 | - 'post_type'=>'espresso_attendees',//post_type |
|
| 304 | + 'post_title'=>stripslashes($old_attendee['fname']." ".$old_attendee['lname']), //ATT_full_name |
|
| 305 | + 'post_content'=>'', //ATT_bio |
|
| 306 | + 'post_name'=>sanitize_title($old_attendee['fname']."-".$old_attendee['lname']), //ATT_slug |
|
| 307 | + 'post_date'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), //ATT_created |
|
| 308 | + 'post_excerpt'=>'', //ATT_short_bio |
|
| 309 | + 'post_modified'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), //ATT_modified |
|
| 310 | + 'post_author'=>0, //ATT_author |
|
| 311 | + 'post_parent'=>0, //ATT_parent |
|
| 312 | + 'post_type'=>'espresso_attendees', //post_type |
|
| 313 | 313 | 'post_status'=>'publish'//status |
| 314 | 314 | ); |
| 315 | 315 | $datatypes = array( |
| 316 | - '%s',//ATT_full_name |
|
| 317 | - '%s',//ATT_bio |
|
| 318 | - '%s',//ATT_slug |
|
| 319 | - '%s',//ATT_created |
|
| 320 | - '%s',//ATT_short_bio |
|
| 321 | - '%s',//ATT_modified |
|
| 322 | - '%d',//ATT_author |
|
| 323 | - '%d',//ATT_parent |
|
| 324 | - '%s',//post_type |
|
| 325 | - '%s',//status |
|
| 316 | + '%s', //ATT_full_name |
|
| 317 | + '%s', //ATT_bio |
|
| 318 | + '%s', //ATT_slug |
|
| 319 | + '%s', //ATT_created |
|
| 320 | + '%s', //ATT_short_bio |
|
| 321 | + '%s', //ATT_modified |
|
| 322 | + '%d', //ATT_author |
|
| 323 | + '%d', //ATT_parent |
|
| 324 | + '%s', //post_type |
|
| 325 | + '%s', //status |
|
| 326 | 326 | ); |
| 327 | - $success = $wpdb->insert($this->_new_attendee_cpt_table,$cols_n_values,$datatypes); |
|
| 328 | - if ( ! $success){ |
|
| 327 | + $success = $wpdb->insert($this->_new_attendee_cpt_table, $cols_n_values, $datatypes); |
|
| 328 | + if ( ! $success) { |
|
| 329 | 329 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_cpt_table, $cols_n_values, $datatypes)); |
| 330 | 330 | return 0; |
| 331 | 331 | } |
@@ -333,19 +333,19 @@ discard block |
||
| 333 | 333 | return $new_id; |
| 334 | 334 | } |
| 335 | 335 | |
| 336 | - private function _insert_attendee_meta_row($old_attendee,$new_attendee_cpt_id){ |
|
| 336 | + private function _insert_attendee_meta_row($old_attendee, $new_attendee_cpt_id) { |
|
| 337 | 337 | global $wpdb; |
| 338 | 338 | //get the state and country ids from the old row |
| 339 | - try{ |
|
| 339 | + try { |
|
| 340 | 340 | $new_country = $this->get_migration_script()->get_or_create_country(stripslashes($old_attendee['country_id'])); |
| 341 | 341 | $new_country_iso = $new_country['CNT_ISO']; |
| 342 | - }catch(EE_Error $exception){ |
|
| 342 | + } catch (EE_Error $exception) { |
|
| 343 | 343 | $new_country_iso = $this->get_migration_script()->get_default_country_iso(); |
| 344 | 344 | } |
| 345 | - try{ |
|
| 346 | - $new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']),$new_country_iso); |
|
| 345 | + try { |
|
| 346 | + $new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']), $new_country_iso); |
|
| 347 | 347 | $new_state_id = $new_state['STA_ID']; |
| 348 | - }catch(EE_Error $exception){ |
|
| 348 | + } catch (EE_Error $exception) { |
|
| 349 | 349 | $new_state_id = 0; |
| 350 | 350 | } |
| 351 | 351 | $cols_n_values = array( |
@@ -362,20 +362,20 @@ discard block |
||
| 362 | 362 | 'ATT_phone'=>stripslashes($old_attendee['phone']), |
| 363 | 363 | ); |
| 364 | 364 | $datatypes = array( |
| 365 | - '%d',//ATT_ID |
|
| 366 | - '%s',//ATT_fname |
|
| 367 | - '%s',//ATT_lname |
|
| 368 | - '%s',//ATT_address |
|
| 369 | - '%s',//ATT_address2 |
|
| 370 | - '%s',//ATT_city |
|
| 371 | - '%d',//STA_ID |
|
| 372 | - '%s',//CNT_ISO |
|
| 373 | - '%s',//ATT_zip |
|
| 374 | - '%s',//ATT_email |
|
| 375 | - '%s',//ATT_phone |
|
| 365 | + '%d', //ATT_ID |
|
| 366 | + '%s', //ATT_fname |
|
| 367 | + '%s', //ATT_lname |
|
| 368 | + '%s', //ATT_address |
|
| 369 | + '%s', //ATT_address2 |
|
| 370 | + '%s', //ATT_city |
|
| 371 | + '%d', //STA_ID |
|
| 372 | + '%s', //CNT_ISO |
|
| 373 | + '%s', //ATT_zip |
|
| 374 | + '%s', //ATT_email |
|
| 375 | + '%s', //ATT_phone |
|
| 376 | 376 | ); |
| 377 | - $success = $wpdb->insert($this->_new_attendee_meta_table,$cols_n_values,$datatypes); |
|
| 378 | - if ( ! $success){ |
|
| 377 | + $success = $wpdb->insert($this->_new_attendee_meta_table, $cols_n_values, $datatypes); |
|
| 378 | + if ( ! $success) { |
|
| 379 | 379 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_meta_table, $cols_n_values, $datatypes)); |
| 380 | 380 | return 0; |
| 381 | 381 | } |
@@ -391,28 +391,28 @@ discard block |
||
| 391 | 391 | * @param type $old_attendee |
| 392 | 392 | * @return int new transaction id |
| 393 | 393 | */ |
| 394 | - private function _insert_new_transaction($old_attendee){ |
|
| 394 | + private function _insert_new_transaction($old_attendee) { |
|
| 395 | 395 | global $wpdb; |
| 396 | 396 | |
| 397 | 397 | //first: let's check for an existing transaction for this old attendee |
| 398 | - if( intval( $old_attendee[ 'is_primary' ] ) ) {//primary attendee, so create txn |
|
| 399 | - $txn_id = $this->get_migration_script()->get_mapping_new_pk( $this->_old_table, intval($old_attendee['id']), $this->_new_transaction_table ); |
|
| 398 | + if (intval($old_attendee['is_primary'])) {//primary attendee, so create txn |
|
| 399 | + $txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, intval($old_attendee['id']), $this->_new_transaction_table); |
|
| 400 | 400 | } else { //non-primary attendee, so find its primary attendee's transaction |
| 401 | - $primary_attendee_old_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_old_table." WHERE is_primary=1 and registration_id=%s",$old_attendee['registration_id'])); |
|
| 402 | - if( ! $primary_attendee_old_id){ |
|
| 401 | + $primary_attendee_old_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_old_table." WHERE is_primary=1 and registration_id=%s", $old_attendee['registration_id'])); |
|
| 402 | + if ( ! $primary_attendee_old_id) { |
|
| 403 | 403 | $primary_attendee = $this->_find_mer_primary_attendee_using_mer_tables($old_attendee['registration_id']); |
| 404 | 404 | $primary_attendee_old_id = is_array($primary_attendee) ? $primary_attendee['id'] : NULL; |
| 405 | 405 | } |
| 406 | 406 | $txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, intval($primary_attendee_old_id), $this->_new_transaction_table); |
| 407 | - if( ! $txn_id){ |
|
| 408 | - $this->add_error(sprintf(__("Could not find primary attendee's new transaction. Current attendee is: %s, we think the 3.1 primary attendee for it has id %d, but there's no 4.1 transaction for that primary attendee id.", "event_espresso"), $this->_json_encode($old_attendee),$primary_attendee_old_id)); |
|
| 407 | + if ( ! $txn_id) { |
|
| 408 | + $this->add_error(sprintf(__("Could not find primary attendee's new transaction. Current attendee is: %s, we think the 3.1 primary attendee for it has id %d, but there's no 4.1 transaction for that primary attendee id.", "event_espresso"), $this->_json_encode($old_attendee), $primary_attendee_old_id)); |
|
| 409 | 409 | $txn_id = 0; |
| 410 | 410 | } |
| 411 | 411 | } |
| 412 | 412 | //if there isn't yet a transaction row for this, create one |
| 413 | 413 | //(so even if it was a non-primary attendee with no EE3 primary attendee, |
| 414 | 414 | // it ought to have SOME transaction, so we'll make one) |
| 415 | - if( ! $txn_id ) { |
|
| 415 | + if ( ! $txn_id) { |
|
| 416 | 416 | //maps 3.1 payment stati onto 4.1 transaction stati |
| 417 | 417 | $txn_status_mapping = array( |
| 418 | 418 | 'Completed'=>'TCM', |
@@ -425,21 +425,21 @@ discard block |
||
| 425 | 425 | ); |
| 426 | 426 | $STS_ID = isset($txn_status_mapping[$old_attendee['payment_status']]) ? $txn_status_mapping[$old_attendee['payment_status']] : 'TIN'; |
| 427 | 427 | $cols_n_values = array( |
| 428 | - 'TXN_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']), |
|
| 428 | + 'TXN_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), |
|
| 429 | 429 | 'TXN_total'=>floatval($old_attendee['total_cost']), |
| 430 | 430 | 'TXN_paid'=>floatval($old_attendee['amount_pd']), |
| 431 | 431 | 'STS_ID'=>$STS_ID, |
| 432 | 432 | 'TXN_hash_salt'=>$old_attendee['hashSalt'] |
| 433 | 433 | ); |
| 434 | 434 | $datatypes = array( |
| 435 | - '%s',//TXN_timestamp |
|
| 436 | - '%f',//TXN_total |
|
| 437 | - '%f',//TXN_paid |
|
| 438 | - '%s',//STS_ID |
|
| 439 | - '%s',//TXN_hash_salt |
|
| 435 | + '%s', //TXN_timestamp |
|
| 436 | + '%f', //TXN_total |
|
| 437 | + '%f', //TXN_paid |
|
| 438 | + '%s', //STS_ID |
|
| 439 | + '%s', //TXN_hash_salt |
|
| 440 | 440 | ); |
| 441 | - $success = $wpdb->insert($this->_new_transaction_table,$cols_n_values,$datatypes); |
|
| 442 | - if ( ! $success){ |
|
| 441 | + $success = $wpdb->insert($this->_new_transaction_table, $cols_n_values, $datatypes); |
|
| 442 | + if ( ! $success) { |
|
| 443 | 443 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_transaction_table, $cols_n_values, $datatypes)); |
| 444 | 444 | return 0; |
| 445 | 445 | } |
@@ -453,13 +453,13 @@ discard block |
||
| 453 | 453 | * @global type $wpdb |
| 454 | 454 | * @return boolean |
| 455 | 455 | */ |
| 456 | - private function _mer_tables_exist(){ |
|
| 457 | - if( $this->_mer_tables_exist === NULL){ |
|
| 456 | + private function _mer_tables_exist() { |
|
| 457 | + if ($this->_mer_tables_exist === NULL) { |
|
| 458 | 458 | global $wpdb; |
| 459 | 459 | |
| 460 | - if( $wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table){ |
|
| 460 | + if ($wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table) { |
|
| 461 | 461 | $this->_mer_tables_exist = false; |
| 462 | - }else{ |
|
| 462 | + } else { |
|
| 463 | 463 | $this->_mer_tables_exist = true; |
| 464 | 464 | } |
| 465 | 465 | } |
@@ -473,10 +473,10 @@ discard block |
||
| 473 | 473 | * @param type $old_attendee_row |
| 474 | 474 | * @return string |
| 475 | 475 | */ |
| 476 | - private function _get_reg_status_for_old_payment_status($old_attendee_row){ |
|
| 476 | + private function _get_reg_status_for_old_payment_status($old_attendee_row) { |
|
| 477 | 477 | //need event default reg status and if pre_approval was required |
| 478 | 478 | global $wpdb; |
| 479 | - $event_required_pre_approval = $wpdb->get_var($wpdb->prepare("SELECT require_pre_approval FROM ".$wpdb->prefix."events_detail WHERE id = %d",$old_attendee_row['event_id'])); |
|
| 479 | + $event_required_pre_approval = $wpdb->get_var($wpdb->prepare("SELECT require_pre_approval FROM ".$wpdb->prefix."events_detail WHERE id = %d", $old_attendee_row['event_id'])); |
|
| 480 | 480 | return $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($old_attendee_row['payment_status'], |
| 481 | 481 | intval($event_required_pre_approval) && intval($old_attendee_row['pre_approve'])); |
| 482 | 482 | } |
@@ -489,19 +489,19 @@ discard block |
||
| 489 | 489 | * @param int $new_txn_id |
| 490 | 490 | * @return array of new registratio ids |
| 491 | 491 | */ |
| 492 | - private function _insert_new_registrations($old_attendee,$new_attendee_id,$new_txn_id){ |
|
| 492 | + private function _insert_new_registrations($old_attendee, $new_attendee_id, $new_txn_id) { |
|
| 493 | 493 | global $wpdb; |
| 494 | 494 | |
| 495 | 495 | $STS_ID = $this->_get_reg_status_for_old_payment_status($old_attendee); |
| 496 | 496 | $new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix.'events_detail', $old_attendee['event_id'], $wpdb->posts); |
| 497 | - if( ! $new_event_id){ |
|
| 498 | - $this->add_error(sprintf(__("Could not find NEW event CPT ID for old event '%d' on old attendee %s", "event_espresso"),$old_attendee['event_id'],$this->_json_encode($old_attendee))); |
|
| 497 | + if ( ! $new_event_id) { |
|
| 498 | + $this->add_error(sprintf(__("Could not find NEW event CPT ID for old event '%d' on old attendee %s", "event_espresso"), $old_attendee['event_id'], $this->_json_encode($old_attendee))); |
|
| 499 | 499 | } |
| 500 | 500 | |
| 501 | - $ticket_id = $this->_try_to_find_new_ticket_id($old_attendee,$new_event_id); |
|
| 502 | - if( ! $ticket_id){ |
|
| 503 | - $ticket_id = $this->_insert_new_ticket_because_none_found( $old_attendee, $new_event_id ); |
|
| 504 | - $this->add_error( sprintf( __( 'Could not find a ticket for old attendee with id %d for new event %d, so created a new ticket with id %d', 'event_espresso' ), $old_attendee['id'], $new_event_id, $ticket_id ) ); |
|
| 501 | + $ticket_id = $this->_try_to_find_new_ticket_id($old_attendee, $new_event_id); |
|
| 502 | + if ( ! $ticket_id) { |
|
| 503 | + $ticket_id = $this->_insert_new_ticket_because_none_found($old_attendee, $new_event_id); |
|
| 504 | + $this->add_error(sprintf(__('Could not find a ticket for old attendee with id %d for new event %d, so created a new ticket with id %d', 'event_espresso'), $old_attendee['id'], $new_event_id, $ticket_id)); |
|
| 505 | 505 | } |
| 506 | 506 | $regs_on_this_row = intval($old_attendee['quantity']); |
| 507 | 507 | $new_regs = array(); |
@@ -510,50 +510,50 @@ discard block |
||
| 510 | 510 | //Y old attendee_details rows with a quantity of 1 (no mer) joined by their common registration_id |
| 511 | 511 | //Y old attendee_details rows with a quantity of x (because of mer) |
| 512 | 512 | //Y old attendee_details rows with a quantity of 1 (because of mer) joined by wp_events_multi_event_registration_id_group |
| 513 | - for($count = 1; $count <= $regs_on_this_row; $count++){ |
|
| 513 | + for ($count = 1; $count <= $regs_on_this_row; $count++) { |
|
| 514 | 514 | //sum regs on older rows |
| 515 | - $regs_on_this_event_and_txn = $this->_sum_old_attendees_on_old_txn($old_attendee,true); |
|
| 515 | + $regs_on_this_event_and_txn = $this->_sum_old_attendees_on_old_txn($old_attendee, true); |
|
| 516 | 516 | $cols_n_values = array( |
| 517 | 517 | 'EVT_ID'=>$new_event_id, |
| 518 | 518 | 'ATT_ID'=>$new_attendee_id, |
| 519 | 519 | 'TXN_ID'=>$new_txn_id, |
| 520 | 520 | 'TKT_ID'=>$ticket_id, |
| 521 | 521 | 'STS_ID'=>$STS_ID, |
| 522 | - 'REG_date'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']), |
|
| 522 | + 'REG_date'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), |
|
| 523 | 523 | 'REG_final_price'=>$old_attendee['final_price'], |
| 524 | - 'REG_session'=> substr( $old_attendee['attendee_session'], 0, 44 ), |
|
| 524 | + 'REG_session'=> substr($old_attendee['attendee_session'], 0, 44), |
|
| 525 | 525 | 'REG_code'=>sanitize_key($old_attendee['registration_id']), |
| 526 | 526 | 'REG_url_link'=> sanitize_key($old_attendee['registration_id'].'-'.$count), |
| 527 | 527 | 'REG_count'=>$regs_on_this_event_and_txn + $count, |
| 528 | - 'REG_group_size'=>$this->_sum_old_attendees_on_old_txn($old_attendee,false), |
|
| 528 | + 'REG_group_size'=>$this->_sum_old_attendees_on_old_txn($old_attendee, false), |
|
| 529 | 529 | 'REG_att_is_going'=>true, |
| 530 | 530 | 'REG_deleted'=>false |
| 531 | 531 | ); |
| 532 | 532 | $datatypes = array( |
| 533 | - '%d',//EVT_ID |
|
| 534 | - '%d',//ATT_ID |
|
| 535 | - '%d',//TXN_ID |
|
| 536 | - '%d',//TKT_ID |
|
| 537 | - '%s',//STS_ID |
|
| 538 | - '%s',//REG_date |
|
| 539 | - '%f',//REG_final_price |
|
| 540 | - '%s',//REG_session |
|
| 541 | - '%s',//REG_code |
|
| 542 | - '%s',//REG_url_link |
|
| 543 | - '%d',//REG_count |
|
| 544 | - '%d',//REG_group_size |
|
| 545 | - '%d',//REG_att_is_going |
|
| 546 | - '%d',//REG_deleted |
|
| 533 | + '%d', //EVT_ID |
|
| 534 | + '%d', //ATT_ID |
|
| 535 | + '%d', //TXN_ID |
|
| 536 | + '%d', //TKT_ID |
|
| 537 | + '%s', //STS_ID |
|
| 538 | + '%s', //REG_date |
|
| 539 | + '%f', //REG_final_price |
|
| 540 | + '%s', //REG_session |
|
| 541 | + '%s', //REG_code |
|
| 542 | + '%s', //REG_url_link |
|
| 543 | + '%d', //REG_count |
|
| 544 | + '%d', //REG_group_size |
|
| 545 | + '%d', //REG_att_is_going |
|
| 546 | + '%d', //REG_deleted |
|
| 547 | 547 | ); |
| 548 | - $success = $wpdb->insert($this->_new_reg_table,$cols_n_values,$datatypes); |
|
| 549 | - if ( ! $success){ |
|
| 548 | + $success = $wpdb->insert($this->_new_reg_table, $cols_n_values, $datatypes); |
|
| 549 | + if ( ! $success) { |
|
| 550 | 550 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_reg_table, $cols_n_values, $datatypes)); |
| 551 | 551 | return 0; |
| 552 | 552 | } |
| 553 | 553 | $cols_n_values['REG_ID'] = $wpdb->insert_id; |
| 554 | 554 | $new_regs[] = $wpdb->insert_id; |
| 555 | 555 | } |
| 556 | - $this->_add_regs_to_ticket_and_datetimes($ticket_id,count($new_regs),$STS_ID); |
|
| 556 | + $this->_add_regs_to_ticket_and_datetimes($ticket_id, count($new_regs), $STS_ID); |
|
| 557 | 557 | return $new_regs; |
| 558 | 558 | } |
| 559 | 559 | |
@@ -569,23 +569,23 @@ discard block |
||
| 569 | 569 | * @param type $STS_ID |
| 570 | 570 | * @return boolean whether they were successfully updated or not |
| 571 | 571 | */ |
| 572 | - protected function _add_regs_to_ticket_and_datetimes($new_ticket_id,$quantity_sold,$STS_ID){ |
|
| 573 | - if($STS_ID != 'RAP'){ |
|
| 572 | + protected function _add_regs_to_ticket_and_datetimes($new_ticket_id, $quantity_sold, $STS_ID) { |
|
| 573 | + if ($STS_ID != 'RAP') { |
|
| 574 | 574 | return true; |
| 575 | 575 | } |
| 576 | 576 | global $wpdb; |
| 577 | - $success = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} SET TKT_sold=TKT_sold+%d WHERE TKT_ID=%d",$quantity_sold,$new_ticket_id)); |
|
| 578 | - if($success){ |
|
| 577 | + $success = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} SET TKT_sold=TKT_sold+%d WHERE TKT_ID=%d", $quantity_sold, $new_ticket_id)); |
|
| 578 | + if ($success) { |
|
| 579 | 579 | //get the ticket's datetimes, and increment them too |
| 580 | - $success_update_dateimtes = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} TKT |
|
| 580 | + $success_update_dateimtes = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} TKT |
|
| 581 | 581 | INNER JOIN {$this->_new_ticket_datetime_table} as DTK ON TKT.TKT_ID = DTK.TKT_ID |
| 582 | 582 | INNER JOIN {$this->_new_datetime_table} as DTT ON DTK.DTT_ID = DTT.DTT_ID |
| 583 | - SET DTT.DTT_sold = DTT.DTT_sold + %d WHERE TKT.TKT_ID = %d",$quantity_sold,$new_ticket_id)); |
|
| 584 | - if( ! $success_update_dateimtes){ |
|
| 585 | - $this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error)); |
|
| 583 | + SET DTT.DTT_sold = DTT.DTT_sold + %d WHERE TKT.TKT_ID = %d", $quantity_sold, $new_ticket_id)); |
|
| 584 | + if ( ! $success_update_dateimtes) { |
|
| 585 | + $this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"), $new_ticket_id, $quantity_sold, $wpdb->last_error)); |
|
| 586 | 586 | } |
| 587 | - }else{ |
|
| 588 | - $this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error)); |
|
| 587 | + } else { |
|
| 588 | + $this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"), $new_ticket_id, $quantity_sold, $wpdb->last_error)); |
|
| 589 | 589 | } |
| 590 | 590 | return true; |
| 591 | 591 | } |
@@ -597,7 +597,7 @@ discard block |
||
| 597 | 597 | * and lastly if none of that works, just use the first ticket for the event we find |
| 598 | 598 | * @param array $old_attendee |
| 599 | 599 | */ |
| 600 | - private function _try_to_find_new_ticket_id($old_attendee,$new_event_id){ |
|
| 600 | + private function _try_to_find_new_ticket_id($old_attendee, $new_event_id) { |
|
| 601 | 601 | global $wpdb; |
| 602 | 602 | $tickets_table = $this->_new_ticket_table; |
| 603 | 603 | $datetime_tickets_table = $this->_new_ticket_datetime_table; |
@@ -608,24 +608,24 @@ discard block |
||
| 608 | 608 | |
| 609 | 609 | $old_att_start_date = $old_attendee['start_date']; |
| 610 | 610 | $old_att_start_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']); |
| 611 | - $old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_start_date $old_att_start_time:00"); |
|
| 611 | + $old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_start_date $old_att_start_time:00"); |
|
| 612 | 612 | //add all conditions to an array from which we can SHIFT conditions off in order to widen our search |
| 613 | 613 | //the most important condition should be last, as it will be array_shift'ed off last |
| 614 | 614 | $conditions = array( |
| 615 | - $wpdb->prepare("$datetime_table.DTT_EVT_start = %s",$old_att_datetime),//times match? |
|
| 616 | - $wpdb->prepare("$tickets_table.TKT_price = %f",$old_att_price),//prices match? |
|
| 617 | - $wpdb->prepare("$tickets_table.TKT_name = %s",$old_att_price_option),//names match? |
|
| 618 | - $wpdb->prepare("$datetime_table.EVT_ID = %d",$new_event_id),//events match? |
|
| 615 | + $wpdb->prepare("$datetime_table.DTT_EVT_start = %s", $old_att_datetime), //times match? |
|
| 616 | + $wpdb->prepare("$tickets_table.TKT_price = %f", $old_att_price), //prices match? |
|
| 617 | + $wpdb->prepare("$tickets_table.TKT_name = %s", $old_att_price_option), //names match? |
|
| 618 | + $wpdb->prepare("$datetime_table.EVT_ID = %d", $new_event_id), //events match? |
|
| 619 | 619 | ); |
| 620 | 620 | $select_and_join_part = "SELECT $tickets_table.TKT_ID FROM $tickets_table INNER JOIN |
| 621 | 621 | $datetime_tickets_table ON $tickets_table.TKT_ID = $datetime_tickets_table.TKT_ID INNER JOIN |
| 622 | 622 | $datetime_table ON $datetime_tickets_table.DTT_ID = $datetime_table.DTT_ID"; |
| 623 | 623 | //start running queries, widening search each time by removing a condition |
| 624 | - do{ |
|
| 625 | - $full_query = $select_and_join_part." WHERE ".implode(" AND ",$conditions)." LIMIT 1"; |
|
| 624 | + do { |
|
| 625 | + $full_query = $select_and_join_part." WHERE ".implode(" AND ", $conditions)." LIMIT 1"; |
|
| 626 | 626 | $ticket_id_found = $wpdb->get_var($full_query); |
| 627 | 627 | array_shift($conditions); |
| 628 | - }while( ! $ticket_id_found && $conditions); |
|
| 628 | + }while ( ! $ticket_id_found && $conditions); |
|
| 629 | 629 | return $ticket_id_found; |
| 630 | 630 | |
| 631 | 631 | } |
@@ -636,23 +636,23 @@ discard block |
||
| 636 | 636 | * the new ticket to that datetime and price. |
| 637 | 637 | * @return int ticket id |
| 638 | 638 | */ |
| 639 | - private function _insert_new_ticket_because_none_found( $old_attendee, $new_event_id ) { |
|
| 639 | + private function _insert_new_ticket_because_none_found($old_attendee, $new_event_id) { |
|
| 640 | 640 | global $wpdb; |
| 641 | 641 | $old_att_price_option = $old_attendee['price_option']; |
| 642 | 642 | $old_att_price = floatval($old_attendee['orig_price']); |
| 643 | 643 | |
| 644 | 644 | $old_att_start_date = $old_attendee['start_date']; |
| 645 | 645 | $old_att_start_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']); |
| 646 | - $old_att_start_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_start_date $old_att_start_time:00"); |
|
| 646 | + $old_att_start_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_start_date $old_att_start_time:00"); |
|
| 647 | 647 | |
| 648 | 648 | |
| 649 | 649 | //insert new datetime unless we find one |
| 650 | - $datetime_id = $wpdb->get_var( $wpdb->prepare( "SELECT DTT_ID FROM " . $this->_new_datetime_table . " WHERE DTT_EVT_start=%s AND EVT_ID=%d LIMIT 1", $old_att_start_datetime, $new_event_id ), ARRAY_A ); |
|
| 651 | - if( ! $datetime_id ) { |
|
| 650 | + $datetime_id = $wpdb->get_var($wpdb->prepare("SELECT DTT_ID FROM ".$this->_new_datetime_table." WHERE DTT_EVT_start=%s AND EVT_ID=%d LIMIT 1", $old_att_start_datetime, $new_event_id), ARRAY_A); |
|
| 651 | + if ( ! $datetime_id) { |
|
| 652 | 652 | $old_att_end_date = $old_attendee['start_date']; |
| 653 | 653 | $old_att_end_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']); |
| 654 | - $old_att_end_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_end_date $old_att_end_time:00"); |
|
| 655 | - $wpdb->insert( $this->_new_datetime_table, |
|
| 654 | + $old_att_end_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_end_date $old_att_end_time:00"); |
|
| 655 | + $wpdb->insert($this->_new_datetime_table, |
|
| 656 | 656 | array( |
| 657 | 657 | 'EVT_ID' => $new_event_id, |
| 658 | 658 | 'DTT_EVT_start' => $old_att_start_datetime, |
@@ -660,44 +660,44 @@ discard block |
||
| 660 | 660 | 'DTT_deleted' => TRUE |
| 661 | 661 | ), |
| 662 | 662 | array( |
| 663 | - '%d',//EVT_ID |
|
| 664 | - '%s',//DTT_EVT_start |
|
| 665 | - '%s',//DTT_EVT_end |
|
| 666 | - '%d',//DTT_deleted |
|
| 663 | + '%d', //EVT_ID |
|
| 664 | + '%s', //DTT_EVT_start |
|
| 665 | + '%s', //DTT_EVT_end |
|
| 666 | + '%d', //DTT_deleted |
|
| 667 | 667 | )); |
| 668 | 668 | $datetime_id = $wpdb->insert_id; |
| 669 | 669 | } |
| 670 | 670 | |
| 671 | 671 | //insert new ticket |
| 672 | - $success = $wpdb->insert( $wpdb->prefix . 'esp_ticket', |
|
| 672 | + $success = $wpdb->insert($wpdb->prefix.'esp_ticket', |
|
| 673 | 673 | array( |
| 674 | 674 | 'TKT_name' => $old_att_price_option, |
| 675 | 675 | 'TKT_qty' => -1, |
| 676 | 676 | 'TKT_price' => $old_att_price, |
| 677 | - 'TKT_start_date' => $old_att_start_datetime,//we really have no clue what the time should be, but at least it was available when they attended |
|
| 677 | + 'TKT_start_date' => $old_att_start_datetime, //we really have no clue what the time should be, but at least it was available when they attended |
|
| 678 | 678 | 'TKT_end_date' => $old_att_end_datetime, |
| 679 | 679 | |
| 680 | 680 | ), |
| 681 | 681 | array( |
| 682 | - '%s',//name |
|
| 683 | - '%d',//qty |
|
| 684 | - '%d',//price |
|
| 685 | - '%s',//start_date |
|
| 686 | - '%s',//end_date |
|
| 682 | + '%s', //name |
|
| 683 | + '%d', //qty |
|
| 684 | + '%d', //price |
|
| 685 | + '%s', //start_date |
|
| 686 | + '%s', //end_date |
|
| 687 | 687 | )); |
| 688 | 688 | $ticket_id = $wpdb->insert_id; |
| 689 | 689 | //associate the ticket with the datetime we found earlier |
| 690 | - $wpdb->insert( $this->_new_datetime_ticket_table, |
|
| 690 | + $wpdb->insert($this->_new_datetime_ticket_table, |
|
| 691 | 691 | array( |
| 692 | 692 | 'DTT_ID' => $datetime_id, |
| 693 | 693 | 'TKT_ID' => $ticket_id |
| 694 | 694 | ), |
| 695 | 695 | array( |
| 696 | - '%d',//DTT_ID |
|
| 697 | - '%d',//TKT_ID |
|
| 696 | + '%d', //DTT_ID |
|
| 697 | + '%d', //TKT_ID |
|
| 698 | 698 | )); |
| 699 | 699 | //insert new price |
| 700 | - $wpdb->insert( $this->_new_price_table, |
|
| 700 | + $wpdb->insert($this->_new_price_table, |
|
| 701 | 701 | array( |
| 702 | 702 | 'PRC_amount' => $old_att_price, |
| 703 | 703 | 'PRT_ID' => EE_DMS_4_1_0_prices::price_type_base, |
@@ -705,22 +705,22 @@ discard block |
||
| 705 | 705 | 'PRC_deleted' => TRUE |
| 706 | 706 | ), |
| 707 | 707 | array( |
| 708 | - '%d',//PRC_amount |
|
| 709 | - '%d',//PRT_ID |
|
| 710 | - '%s',//PRC_name |
|
| 711 | - '%d',//PRC_deleted |
|
| 708 | + '%d', //PRC_amount |
|
| 709 | + '%d', //PRT_ID |
|
| 710 | + '%s', //PRC_name |
|
| 711 | + '%d', //PRC_deleted |
|
| 712 | 712 | )); |
| 713 | 713 | $price_id = $wpdb->insert_id; |
| 714 | 714 | //associate the price to the ticket |
| 715 | - $wpdb->insert( $this->_new_ticket_price_table, |
|
| 715 | + $wpdb->insert($this->_new_ticket_price_table, |
|
| 716 | 716 | array( |
| 717 | 717 | 'TKT_ID' => $ticket_id, |
| 718 | 718 | 'PRC_ID' => $price_id |
| 719 | 719 | ), |
| 720 | 720 | array( |
| 721 | - '%d',//TKT_ID |
|
| 722 | - '%d',//PRC_ID |
|
| 723 | - ) ); |
|
| 721 | + '%d', //TKT_ID |
|
| 722 | + '%d', //PRC_ID |
|
| 723 | + )); |
|
| 724 | 724 | return $ticket_id; |
| 725 | 725 | } |
| 726 | 726 | /** |
@@ -731,12 +731,12 @@ discard block |
||
| 731 | 731 | * @param boolean $count_only_older true if you want the running count (ie, the total up to this row), and false if you want ALL |
| 732 | 732 | * @return int |
| 733 | 733 | */ |
| 734 | - private function _sum_old_attendees_on_old_txn($old_attendee_row,$count_only_older = false){ |
|
| 734 | + private function _sum_old_attendees_on_old_txn($old_attendee_row, $count_only_older = false) { |
|
| 735 | 735 | global $wpdb; |
| 736 | - $count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d",$old_attendee_row['id']) : ''; |
|
| 737 | - $count = intval($wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM ".$this->_old_table." WHERE registration_id=%s $count_only_older_sql",$old_attendee_row['registration_id']))); |
|
| 736 | + $count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d", $old_attendee_row['id']) : ''; |
|
| 737 | + $count = intval($wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM ".$this->_old_table." WHERE registration_id=%s $count_only_older_sql", $old_attendee_row['registration_id']))); |
|
| 738 | 738 | |
| 739 | - if( $this->_mer_tables_exist()){ |
|
| 739 | + if ($this->_mer_tables_exist()) { |
|
| 740 | 740 | //if MER exists, then its a little tricky. |
| 741 | 741 | //when users registered by adding items to the cart, and it was a |
| 742 | 742 | //group registration requiring additional attendee INFO, then the attendee rows |
@@ -745,17 +745,17 @@ discard block |
||
| 745 | 745 | //BUT we want to count all the MER attendee rows for the same registration |
| 746 | 746 | $primary_attendee = $this->_find_mer_primary_attendee_using_mer_tables($old_attendee_row['registration_id']); |
| 747 | 747 | |
| 748 | - $count_using_mer_table = $wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM {$this->_old_table} att INNER JOIN {$this->_old_mer_table} mer ON att.registration_id = mer.registration_id WHERE att.event_id=%d AND mer.primary_registration_id = %s $count_only_older_sql",$old_attendee_row['event_id'],$primary_attendee['registration_id'])); |
|
| 749 | - $count = max($count_using_mer_table,$count); |
|
| 748 | + $count_using_mer_table = $wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM {$this->_old_table} att INNER JOIN {$this->_old_mer_table} mer ON att.registration_id = mer.registration_id WHERE att.event_id=%d AND mer.primary_registration_id = %s $count_only_older_sql", $old_attendee_row['event_id'], $primary_attendee['registration_id'])); |
|
| 749 | + $count = max($count_using_mer_table, $count); |
|
| 750 | 750 | } |
| 751 | 751 | return $count; |
| 752 | 752 | } |
| 753 | - private function _insert_new_payment($old_attendee,$new_txn_id){ |
|
| 753 | + private function _insert_new_payment($old_attendee, $new_txn_id) { |
|
| 754 | 754 | global $wpdb; |
| 755 | 755 | //only add a payment for primary attendees |
| 756 | - $old_pay_stati_indicating_no_payment = array('Pending','Incomplete','Not Completed'); |
|
| 756 | + $old_pay_stati_indicating_no_payment = array('Pending', 'Incomplete', 'Not Completed'); |
|
| 757 | 757 | //if this is for a primary 3.1 attendee which WASN'T free and has a completed, cancelled, or declined payment... |
| 758 | - if(intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)){ |
|
| 758 | + if (intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)) { |
|
| 759 | 759 | $pay_status_mapping = array( |
| 760 | 760 | 'Completed'=>'PAP', |
| 761 | 761 | 'Payment Declined'=>'PDC', |
@@ -763,41 +763,41 @@ discard block |
||
| 763 | 763 | 'Declined'=>'PDC' |
| 764 | 764 | ); |
| 765 | 765 | $by_admin = $old_attendee['payment'] == 'Admin'; |
| 766 | - $STS_ID = isset($pay_status_mapping[$old_attendee['payment_status']]) ? $pay_status_mapping[$old_attendee['payment_status']] : 'PFL';//IE, if we don't recognize the status, assume payment failed |
|
| 766 | + $STS_ID = isset($pay_status_mapping[$old_attendee['payment_status']]) ? $pay_status_mapping[$old_attendee['payment_status']] : 'PFL'; //IE, if we don't recognize the status, assume payment failed |
|
| 767 | 767 | $cols_n_values = array( |
| 768 | 768 | 'TXN_ID'=>$new_txn_id, |
| 769 | 769 | 'STS_ID'=>$STS_ID, |
| 770 | - 'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']), |
|
| 770 | + 'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), |
|
| 771 | 771 | 'PAY_method'=>'CART', |
| 772 | 772 | 'PAY_amount'=>$old_attendee['amount_pd'], |
| 773 | 773 | 'PAY_gateway'=>$old_attendee['txn_type'], |
| 774 | 774 | 'PAY_gateway_response'=>'', |
| 775 | - 'PAY_txn_id_chq_nmbr'=>substr( $old_attendee['txn_id'], 0, 32 ), |
|
| 775 | + 'PAY_txn_id_chq_nmbr'=>substr($old_attendee['txn_id'], 0, 32), |
|
| 776 | 776 | 'PAY_via_admin'=>$by_admin, |
| 777 | 777 | 'PAY_details'=>$old_attendee['transaction_details'] |
| 778 | 778 | |
| 779 | 779 | ); |
| 780 | 780 | $datatypes = array( |
| 781 | - '%d',//TXN_Id |
|
| 782 | - '%s',//STS_ID |
|
| 783 | - '%s',//PAY_timestamp |
|
| 784 | - '%s',//PAY_method |
|
| 785 | - '%f',//PAY_amount |
|
| 786 | - '%s',//PAY_gateway |
|
| 787 | - '%s',//PAY_gateway_response |
|
| 788 | - '%s',//PAY_txn_id_chq_nmbr |
|
| 789 | - '%d',//PAY_via_admin |
|
| 790 | - '%s',//PAY_details |
|
| 781 | + '%d', //TXN_Id |
|
| 782 | + '%s', //STS_ID |
|
| 783 | + '%s', //PAY_timestamp |
|
| 784 | + '%s', //PAY_method |
|
| 785 | + '%f', //PAY_amount |
|
| 786 | + '%s', //PAY_gateway |
|
| 787 | + '%s', //PAY_gateway_response |
|
| 788 | + '%s', //PAY_txn_id_chq_nmbr |
|
| 789 | + '%d', //PAY_via_admin |
|
| 790 | + '%s', //PAY_details |
|
| 791 | 791 | ); |
| 792 | - $success = $wpdb->insert($this->_new_payment_table,$cols_n_values,$datatypes); |
|
| 793 | - if ( ! $success){ |
|
| 792 | + $success = $wpdb->insert($this->_new_payment_table, $cols_n_values, $datatypes); |
|
| 793 | + if ( ! $success) { |
|
| 794 | 794 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_cpt_table, $cols_n_values, $datatypes)); |
| 795 | 795 | return 0; |
| 796 | 796 | } |
| 797 | 797 | $new_id = $wpdb->insert_id; |
| 798 | 798 | return $new_id; |
| 799 | 799 | |
| 800 | - }else{ |
|
| 800 | + } else { |
|
| 801 | 801 | return 0; |
| 802 | 802 | } |
| 803 | 803 | |
@@ -810,12 +810,12 @@ discard block |
||
| 810 | 810 | * @param type $old_registration_id |
| 811 | 811 | * @return array |
| 812 | 812 | */ |
| 813 | - private function _find_mer_primary_attendee_using_mer_tables($old_registration_id){ |
|
| 814 | - if (! $this->_mer_tables_exist()){ |
|
| 813 | + private function _find_mer_primary_attendee_using_mer_tables($old_registration_id) { |
|
| 814 | + if ( ! $this->_mer_tables_exist()) { |
|
| 815 | 815 | return false; |
| 816 | 816 | } |
| 817 | 817 | global $wpdb; |
| 818 | - $old_att_for_primary_reg = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$this->_old_mer_table} AS mer INNER JOIN {$this->_old_table} AS att ON mer.primary_registration_id = att.registration_id WHERE mer.registration_id=%s LIMIT 1",$old_registration_id),ARRAY_A); |
|
| 818 | + $old_att_for_primary_reg = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$this->_old_mer_table} AS mer INNER JOIN {$this->_old_table} AS att ON mer.primary_registration_id = att.registration_id WHERE mer.registration_id=%s LIMIT 1", $old_registration_id), ARRAY_A); |
|
| 819 | 819 | return $old_att_for_primary_reg; |
| 820 | 820 | } |
| 821 | 821 | |
@@ -6,16 +6,16 @@ discard block |
||
| 6 | 6 | * Authorize.net AIM, Bank, Check, Invoice, Paypal Pro and Paypal Standard. |
| 7 | 7 | * |
| 8 | 8 | */ |
| 9 | -class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage{ |
|
| 9 | +class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage { |
|
| 10 | 10 | private $_old_table; |
| 11 | 11 | private $_new_table; |
| 12 | 12 | private $_new_term_table; |
| 13 | -function _migration_step($num_items=50){ |
|
| 13 | +function _migration_step($num_items = 50) { |
|
| 14 | 14 | global $wpdb; |
| 15 | 15 | $start_at_record = $this->count_records_migrated(); |
| 16 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
| 16 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
| 17 | 17 | $items_actually_migrated = 0; |
| 18 | - foreach($rows as $category_detail_row){ |
|
| 18 | + foreach ($rows as $category_detail_row) { |
|
| 19 | 19 | $term_and_taxonomy_ids = wp_insert_term( |
| 20 | 20 | stripslashes($category_detail_row['category_name']), |
| 21 | 21 | 'espresso_event_categories', |
@@ -23,8 +23,8 @@ discard block |
||
| 23 | 23 | 'description'=> stripslashes($category_detail_row['category_desc']), |
| 24 | 24 | 'slug'=>$category_detail_row['category_identifier'] |
| 25 | 25 | )); |
| 26 | - if($term_and_taxonomy_ids instanceof WP_Error){ |
|
| 27 | - $this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"), $this->_json_encode($category_detail_row),$term_and_taxonomy_ids->get_error_message())); |
|
| 26 | + if ($term_and_taxonomy_ids instanceof WP_Error) { |
|
| 27 | + $this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"), $this->_json_encode($category_detail_row), $term_and_taxonomy_ids->get_error_message())); |
|
| 28 | 28 | $items_actually_migrated++; |
| 29 | 29 | continue; |
| 30 | 30 | } |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | $this->get_migration_script()->set_mapping($this->_old_table, $category_detail_row['id'], $this->_new_table, $term_taxonomy_id); |
| 35 | 35 | $items_actually_migrated++; |
| 36 | 36 | } |
| 37 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
| 37 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
| 38 | 38 | $this->set_completed(); |
| 39 | 39 | } |
| 40 | 40 | return $items_actually_migrated; |