@@ -42,11 +42,11 @@ |
||
42 | 42 | if($version_string <= '4.5.0' && $version_string >= '4.3.0' ){ |
43 | 43 | // echo "$version_string can be migrated from"; |
44 | 44 | return true; |
45 | - }elseif( ! $version_string ){ |
|
45 | + } elseif( ! $version_string ){ |
|
46 | 46 | // echo "no version string provided: $version_string"; |
47 | 47 | //no version string provided... this must be pre 4.3 |
48 | 48 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
49 | - }else{ |
|
49 | + } else{ |
|
50 | 50 | // echo "$version_string doesnt apply"; |
51 | 51 | return false; |
52 | 52 | } |
@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | * -adds DTT_name and DTT_description to the datetime table; |
10 | 10 | * -adds users onto prices, price types, question groups, and tickets |
11 | 11 | */ |
12 | -class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base{ |
|
12 | +class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base { |
|
13 | 13 | |
14 | 14 | |
15 | 15 | |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | * @param TableAnalysis $table_analysis |
21 | 21 | * @throws \EE_Error |
22 | 22 | */ |
23 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) { |
|
23 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
24 | 24 | $this->_load_script_stages(); |
25 | 25 | $this->_pretty_name = __("Data Migration to Event Espresso 4.5.0.P", "event_espresso"); |
26 | 26 | $this->_priority = 10; |
@@ -31,21 +31,21 @@ discard block |
||
31 | 31 | new EE_DMS_4_5_0_update_wp_user_for_question_groups(), |
32 | 32 | new EE_DMS_4_5_0_invoice_settings(), |
33 | 33 | ); |
34 | - parent::__construct( $table_manager, $table_analysis ); |
|
34 | + parent::__construct($table_manager, $table_analysis); |
|
35 | 35 | } |
36 | 36 | |
37 | 37 | |
38 | 38 | |
39 | 39 | public function can_migrate_from_version($version_array) { |
40 | 40 | $version_string = $version_array['Core']; |
41 | - if($version_string <= '4.5.0' && $version_string >= '4.3.0' ){ |
|
41 | + if ($version_string <= '4.5.0' && $version_string >= '4.3.0') { |
|
42 | 42 | // echo "$version_string can be migrated from"; |
43 | 43 | return true; |
44 | - }elseif( ! $version_string ){ |
|
44 | + }elseif ( ! $version_string) { |
|
45 | 45 | // echo "no version string provided: $version_string"; |
46 | 46 | //no version string provided... this must be pre 4.3 |
47 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | - }else{ |
|
47 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | + } else { |
|
49 | 49 | // echo "$version_string doesnt apply"; |
50 | 50 | return false; |
51 | 51 | } |
@@ -55,14 +55,14 @@ discard block |
||
55 | 55 | } |
56 | 56 | public function schema_changes_before_migration() { |
57 | 57 | //relies on 4.1's EEH_Activation::create_table |
58 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
59 | - $table_name='esp_answer'; |
|
60 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
58 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
59 | + $table_name = 'esp_answer'; |
|
60 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
61 | 61 | REG_ID INT UNSIGNED NOT NULL, |
62 | 62 | QST_ID INT UNSIGNED NOT NULL, |
63 | 63 | ANS_value TEXT NOT NULL, |
64 | 64 | PRIMARY KEY (ANS_ID)"; |
65 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
65 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
66 | 66 | |
67 | 67 | $table_name = 'esp_attendee_meta'; |
68 | 68 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | CNT_is_EU TINYINT(1) DEFAULT '0', |
102 | 102 | CNT_active TINYINT(1) DEFAULT '0', |
103 | 103 | PRIMARY KEY (CNT_ISO)"; |
104 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
104 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
105 | 105 | |
106 | 106 | $table_name = 'esp_datetime'; |
107 | 107 | $sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -122,7 +122,7 @@ discard block |
||
122 | 122 | |
123 | 123 | |
124 | 124 | |
125 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
125 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
126 | 126 | $table_name = 'esp_event_meta'; |
127 | 127 | $sql = " |
128 | 128 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -139,41 +139,41 @@ discard block |
||
139 | 139 | EVT_external_URL VARCHAR(200) NULL, |
140 | 140 | EVT_donations TINYINT(1) NULL, |
141 | 141 | PRIMARY KEY (EVTM_ID)"; |
142 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
142 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
143 | 143 | |
144 | 144 | |
145 | 145 | |
146 | - $table_name='esp_event_question_group'; |
|
147 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
146 | + $table_name = 'esp_event_question_group'; |
|
147 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
148 | 148 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
149 | 149 | QSG_ID INT UNSIGNED NOT NULL, |
150 | 150 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
151 | 151 | PRIMARY KEY (EQG_ID)"; |
152 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
152 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
153 | 153 | |
154 | 154 | |
155 | 155 | |
156 | - $table_name='esp_event_venue'; |
|
157 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
156 | + $table_name = 'esp_event_venue'; |
|
157 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
158 | 158 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
159 | 159 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
161 | 161 | PRIMARY KEY (EVV_ID)"; |
162 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
162 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
163 | 163 | |
164 | 164 | |
165 | 165 | |
166 | - $table_name='esp_extra_meta'; |
|
167 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
166 | + $table_name = 'esp_extra_meta'; |
|
167 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
168 | 168 | OBJ_ID INT(11) DEFAULT NULL, |
169 | 169 | EXM_type VARCHAR(45) DEFAULT NULL, |
170 | 170 | EXM_key VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_value TEXT, |
172 | 172 | PRIMARY KEY (EXM_ID)"; |
173 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
173 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
174 | 174 | |
175 | - $table_name='esp_line_item'; |
|
176 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
175 | + $table_name = 'esp_line_item'; |
|
176 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
177 | 177 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
178 | 178 | TXN_ID INT(11) DEFAULT NULL, |
179 | 179 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | OBJ_ID INT(11) DEFAULT NULL, |
190 | 190 | OBJ_type VARCHAR(45)DEFAULT NULL, |
191 | 191 | PRIMARY KEY (LIN_ID)"; |
192 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
192 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
193 | 193 | |
194 | 194 | $table_name = 'esp_message_template'; |
195 | 195 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -201,7 +201,7 @@ discard block |
||
201 | 201 | KEY GRP_ID (GRP_ID)"; |
202 | 202 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
203 | 203 | |
204 | - $this->_get_table_manager()->dropIndex( 'esp_message_template_group', 'EVT_ID' ); |
|
204 | + $this->_get_table_manager()->dropIndex('esp_message_template_group', 'EVT_ID'); |
|
205 | 205 | |
206 | 206 | $table_name = 'esp_message_template_group'; |
207 | 207 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
217 | 217 | PRIMARY KEY (GRP_ID), |
218 | 218 | KEY MTP_user_id (MTP_user_id)"; |
219 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
219 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | 220 | |
221 | 221 | $table_name = 'esp_event_message_template'; |
222 | 222 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -225,7 +225,7 @@ discard block |
||
225 | 225 | PRIMARY KEY (EMT_ID), |
226 | 226 | KEY EVT_ID (EVT_ID), |
227 | 227 | KEY GRP_ID (GRP_ID)"; |
228 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
228 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | 229 | |
230 | 230 | |
231 | 231 | $table_name = 'esp_payment'; |
@@ -275,8 +275,8 @@ discard block |
||
275 | 275 | PRIMARY KEY (TTM_ID)"; |
276 | 276 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
277 | 277 | |
278 | - $table_name='esp_question'; |
|
279 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
278 | + $table_name = 'esp_question'; |
|
279 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
280 | 280 | QST_display_text TEXT NOT NULL, |
281 | 281 | QST_admin_label VARCHAR(255) NOT NULL, |
282 | 282 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -288,27 +288,27 @@ discard block |
||
288 | 288 | QST_wp_user BIGINT UNSIGNED NULL, |
289 | 289 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
290 | 290 | PRIMARY KEY (QST_ID)'; |
291 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
291 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
292 | 292 | |
293 | - $table_name='esp_question_group_question'; |
|
294 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
293 | + $table_name = 'esp_question_group_question'; |
|
294 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
295 | 295 | QSG_ID INT UNSIGNED NOT NULL, |
296 | 296 | QST_ID INT UNSIGNED NOT NULL, |
297 | 297 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
298 | 298 | PRIMARY KEY (QGQ_ID) "; |
299 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
299 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
300 | 300 | |
301 | 301 | |
302 | 302 | |
303 | - $table_name='esp_question_option'; |
|
304 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
303 | + $table_name = 'esp_question_option'; |
|
304 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
305 | 305 | QSO_value VARCHAR(255) NOT NULL, |
306 | 306 | QSO_desc TEXT NOT NULL, |
307 | 307 | QST_ID INT UNSIGNED NOT NULL, |
308 | 308 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
309 | 309 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
310 | 310 | PRIMARY KEY (QSO_ID)"; |
311 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
311 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
312 | 312 | |
313 | 313 | |
314 | 314 | |
@@ -341,8 +341,8 @@ discard block |
||
341 | 341 | |
342 | 342 | |
343 | 343 | |
344 | - $table_name='esp_checkin'; |
|
345 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
344 | + $table_name = 'esp_checkin'; |
|
345 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
346 | 346 | REG_ID INT(10) UNSIGNED NOT NULL, |
347 | 347 | DTT_ID INT(10) UNSIGNED NOT NULL, |
348 | 348 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -430,7 +430,7 @@ discard block |
||
430 | 430 | PRC_wp_user BIGINT UNSIGNED NULL, |
431 | 431 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
432 | 432 | PRIMARY KEY (PRC_ID)"; |
433 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
433 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
434 | 434 | |
435 | 435 | $table_name = "esp_price_type"; |
436 | 436 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -467,12 +467,12 @@ discard block |
||
467 | 467 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
468 | 468 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
469 | 469 | PRIMARY KEY (TKT_ID)"; |
470 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
470 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
471 | 471 | |
472 | - $this->_get_table_manager()->dropIndex( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
472 | + $this->_get_table_manager()->dropIndex('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
473 | 473 | |
474 | 474 | $table_name = 'esp_question_group'; |
475 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
475 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
476 | 476 | QSG_name VARCHAR(255) NOT NULL, |
477 | 477 | QSG_identifier VARCHAR(100) NOT NULL, |
478 | 478 | QSG_desc TEXT NULL, |
@@ -484,7 +484,7 @@ discard block |
||
484 | 484 | QSG_wp_user BIGINT UNSIGNED NULL, |
485 | 485 | PRIMARY KEY (QSG_ID), |
486 | 486 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
487 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
487 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
488 | 488 | |
489 | 489 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
490 | 490 | |
@@ -508,7 +508,7 @@ discard block |
||
508 | 508 | return true; |
509 | 509 | } |
510 | 510 | |
511 | - public function migration_page_hooks(){ |
|
511 | + public function migration_page_hooks() { |
|
512 | 512 | |
513 | 513 | } |
514 | 514 | |
@@ -522,21 +522,21 @@ discard block |
||
522 | 522 | global $wpdb; |
523 | 523 | $price_type_table = $wpdb->prefix."esp_price_type"; |
524 | 524 | |
525 | - if ( $this->_get_table_analysis()->tableExists( $price_type_table ) ) { |
|
525 | + if ($this->_get_table_analysis()->tableExists($price_type_table)) { |
|
526 | 526 | |
527 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
528 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
527 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
528 | + $price_types_exist = $wpdb->get_var($SQL); |
|
529 | 529 | |
530 | - if ( ! $price_types_exist ) { |
|
530 | + if ( ! $price_types_exist) { |
|
531 | 531 | $user_id = EEH_Activation::get_default_creator_id(); |
532 | 532 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_wp_user, PRT_deleted ) VALUES |
533 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, $user_id, 0), |
|
534 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, $user_id, 0), |
|
535 | - (3, '" . __('Dollar Discount', 'event_espresso') . "', 2, 0, 30, $user_id, 0), |
|
536 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, $user_id, 0), |
|
537 | - (5, '" . __('Dollar Surcharge', 'event_espresso') . "', 3, 0, 50, $user_id, 0);"; |
|
538 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL ); |
|
539 | - $wpdb->query( $SQL ); |
|
533 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, $user_id, 0), |
|
534 | + (2, '".__('Percent Discount', 'event_espresso')."', 2, 1, 20, $user_id, 0), |
|
535 | + (3, '".__('Dollar Discount', 'event_espresso')."', 2, 0, 30, $user_id, 0), |
|
536 | + (4, '".__('Percent Surcharge', 'event_espresso')."', 3, 1, 40, $user_id, 0), |
|
537 | + (5, '".__('Dollar Surcharge', 'event_espresso')."', 3, 0, 50, $user_id, 0);"; |
|
538 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL); |
|
539 | + $wpdb->query($SQL); |
|
540 | 540 | } |
541 | 541 | } |
542 | 542 | } |
@@ -556,17 +556,17 @@ discard block |
||
556 | 556 | global $wpdb; |
557 | 557 | $price_table = $wpdb->prefix."esp_price"; |
558 | 558 | |
559 | - if ( $this->_get_table_analysis()->tableExists( $price_table ) ) { |
|
559 | + if ($this->_get_table_analysis()->tableExists($price_table)) { |
|
560 | 560 | |
561 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
562 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
561 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
562 | + $prices_exist = $wpdb->get_var($SQL); |
|
563 | 563 | |
564 | - if ( ! $prices_exist ) { |
|
564 | + if ( ! $prices_exist) { |
|
565 | 565 | $user_id = EEH_Activation::get_default_creator_id(); |
566 | 566 | $SQL = "INSERT INTO $price_table |
567 | 567 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_wp_user, PRC_order, PRC_deleted, PRC_parent ) VALUES |
568 | 568 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, $user_id, 0, 0, 0);"; |
569 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL ); |
|
569 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL); |
|
570 | 570 | $wpdb->query($SQL); |
571 | 571 | } |
572 | 572 | } |
@@ -584,35 +584,35 @@ discard block |
||
584 | 584 | |
585 | 585 | global $wpdb; |
586 | 586 | $ticket_table = $wpdb->prefix."esp_ticket"; |
587 | - if ( $this->_get_table_analysis()->tableExists( $ticket_table ) ) { |
|
587 | + if ($this->_get_table_analysis()->tableExists($ticket_table)) { |
|
588 | 588 | |
589 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
589 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
590 | 590 | $tickets_exist = $wpdb->get_var($SQL); |
591 | 591 | |
592 | - if ( ! $tickets_exist ) { |
|
592 | + if ( ! $tickets_exist) { |
|
593 | 593 | $user_id = EEH_Activation::get_default_creator_id(); |
594 | 594 | $SQL = "INSERT INTO $ticket_table |
595 | 595 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_wp_user, TKT_deleted ) VALUES |
596 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
597 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL ); |
|
596 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
597 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL); |
|
598 | 598 | $wpdb->query($SQL); |
599 | 599 | } |
600 | 600 | } |
601 | 601 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
602 | 602 | |
603 | - if ( $this->_get_table_analysis()->tableExists( $ticket_price_table ) ) { |
|
603 | + if ($this->_get_table_analysis()->tableExists($ticket_price_table)) { |
|
604 | 604 | |
605 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
605 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
606 | 606 | $ticket_prc_exist = $wpdb->get_var($SQL); |
607 | 607 | |
608 | - if ( ! $ticket_prc_exist ) { |
|
608 | + if ( ! $ticket_prc_exist) { |
|
609 | 609 | |
610 | 610 | $SQL = "INSERT INTO $ticket_price_table |
611 | 611 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
612 | 612 | ( 1, 1, 1 ) |
613 | 613 | "; |
614 | 614 | |
615 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
615 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
616 | 616 | $wpdb->query($SQL); |
617 | 617 | } |
618 | 618 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if($version_string <= '4.6.0' && $version_string >= '4.5.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * @author Mike Nelson |
14 | 14 | * @since 4.6.0 |
15 | 15 | */ |
16 | -class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base{ |
|
16 | +class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base { |
|
17 | 17 | |
18 | 18 | /** |
19 | 19 | * return EE_DMS_Core_4_6_0 |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | * @param TableAnalysis $table_analysis |
23 | 23 | * @throws \EE_Error |
24 | 24 | */ |
25 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) { |
|
25 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
26 | 26 | $this->_load_script_stages(); |
27 | 27 | $this->_pretty_name = __("Data Migration to Event Espresso 4.6.0.P", "event_espresso"); |
28 | 28 | $this->_priority = 10; |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | new EE_DMS_4_6_0_payments(), |
38 | 38 | new EE_DMS_4_6_0_invoice_settings() |
39 | 39 | ); |
40 | - parent::__construct( $table_manager, $table_analysis ); |
|
40 | + parent::__construct($table_manager, $table_analysis); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | |
@@ -48,14 +48,14 @@ discard block |
||
48 | 48 | */ |
49 | 49 | public function can_migrate_from_version($version_array) { |
50 | 50 | $version_string = $version_array['Core']; |
51 | - if($version_string <= '4.6.0' && $version_string >= '4.5.0' ){ |
|
51 | + if ($version_string <= '4.6.0' && $version_string >= '4.5.0') { |
|
52 | 52 | // echo "$version_string can be migrated from"; |
53 | 53 | return true; |
54 | - }elseif( ! $version_string ){ |
|
54 | + }elseif ( ! $version_string) { |
|
55 | 55 | // echo "no version string provided: $version_string"; |
56 | 56 | //no version string provided... this must be pre 4.3 |
57 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
58 | - }else{ |
|
57 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
58 | + } else { |
|
59 | 59 | // echo "$version_string doesnt apply"; |
60 | 60 | return false; |
61 | 61 | } |
@@ -77,14 +77,14 @@ discard block |
||
77 | 77 | */ |
78 | 78 | public function schema_changes_before_migration() { |
79 | 79 | //relies on 4.1's EEH_Activation::create_table |
80 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
81 | - $table_name='esp_answer'; |
|
82 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
80 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
81 | + $table_name = 'esp_answer'; |
|
82 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
83 | 83 | REG_ID INT UNSIGNED NOT NULL, |
84 | 84 | QST_ID INT UNSIGNED NOT NULL, |
85 | 85 | ANS_value TEXT NOT NULL, |
86 | 86 | PRIMARY KEY (ANS_ID)"; |
87 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
87 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
88 | 88 | |
89 | 89 | $table_name = 'esp_attendee_meta'; |
90 | 90 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | CNT_is_EU TINYINT(1) DEFAULT '0', |
124 | 124 | CNT_active TINYINT(1) DEFAULT '0', |
125 | 125 | PRIMARY KEY (CNT_ISO)"; |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | |
128 | 128 | $table_name = 'esp_currency'; |
129 | 129 | $sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL, |
@@ -133,7 +133,7 @@ discard block |
||
133 | 133 | CUR_dec_plc VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT '2', |
134 | 134 | CUR_active TINYINT(1) DEFAULT '0', |
135 | 135 | PRIMARY KEY (CUR_code)"; |
136 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
136 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
137 | 137 | |
138 | 138 | |
139 | 139 | $table_name = 'esp_currency_payment_method'; |
@@ -163,7 +163,7 @@ discard block |
||
163 | 163 | |
164 | 164 | |
165 | 165 | |
166 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
166 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
167 | 167 | $table_name = 'esp_event_meta'; |
168 | 168 | $sql = " |
169 | 169 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -180,41 +180,41 @@ discard block |
||
180 | 180 | EVT_external_URL VARCHAR(200) NULL, |
181 | 181 | EVT_donations TINYINT(1) NULL, |
182 | 182 | PRIMARY KEY (EVTM_ID)"; |
183 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
183 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
184 | 184 | |
185 | 185 | |
186 | 186 | |
187 | - $table_name='esp_event_question_group'; |
|
188 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
187 | + $table_name = 'esp_event_question_group'; |
|
188 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
189 | 189 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
190 | 190 | QSG_ID INT UNSIGNED NOT NULL, |
191 | 191 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
192 | 192 | PRIMARY KEY (EQG_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | |
196 | 196 | |
197 | - $table_name='esp_event_venue'; |
|
198 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
197 | + $table_name = 'esp_event_venue'; |
|
198 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
199 | 199 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
200 | 200 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
201 | 201 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
202 | 202 | PRIMARY KEY (EVV_ID)"; |
203 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
203 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
204 | 204 | |
205 | 205 | |
206 | 206 | |
207 | - $table_name='esp_extra_meta'; |
|
208 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
207 | + $table_name = 'esp_extra_meta'; |
|
208 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
209 | 209 | OBJ_ID INT(11) DEFAULT NULL, |
210 | 210 | EXM_type VARCHAR(45) DEFAULT NULL, |
211 | 211 | EXM_key VARCHAR(45) DEFAULT NULL, |
212 | 212 | EXM_value TEXT, |
213 | 213 | PRIMARY KEY (EXM_ID)"; |
214 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
214 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
215 | 215 | |
216 | - $table_name='esp_line_item'; |
|
217 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
216 | + $table_name = 'esp_line_item'; |
|
217 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
218 | 218 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
219 | 219 | TXN_ID INT(11) DEFAULT NULL, |
220 | 220 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | OBJ_ID INT(11) DEFAULT NULL, |
231 | 231 | OBJ_type VARCHAR(45)DEFAULT NULL, |
232 | 232 | PRIMARY KEY (LIN_ID)"; |
233 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
233 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
234 | 234 | |
235 | 235 | $table_name = 'esp_log'; |
236 | 236 | $sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT, |
@@ -253,7 +253,7 @@ discard block |
||
253 | 253 | KEY GRP_ID (GRP_ID)"; |
254 | 254 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
255 | 255 | |
256 | - $this->_get_table_manager()->dropIndex( 'esp_message_template_group', 'EVT_ID' ); |
|
256 | + $this->_get_table_manager()->dropIndex('esp_message_template_group', 'EVT_ID'); |
|
257 | 257 | |
258 | 258 | $table_name = 'esp_message_template_group'; |
259 | 259 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -268,7 +268,7 @@ discard block |
||
268 | 268 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
269 | 269 | PRIMARY KEY (GRP_ID), |
270 | 270 | KEY MTP_user_id (MTP_user_id)"; |
271 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
271 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
272 | 272 | |
273 | 273 | $table_name = 'esp_event_message_template'; |
274 | 274 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -277,7 +277,7 @@ discard block |
||
277 | 277 | PRIMARY KEY (EMT_ID), |
278 | 278 | KEY EVT_ID (EVT_ID), |
279 | 279 | KEY GRP_ID (GRP_ID)"; |
280 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
280 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
281 | 281 | |
282 | 282 | |
283 | 283 | $table_name = 'esp_payment'; |
@@ -345,8 +345,8 @@ discard block |
||
345 | 345 | PRIMARY KEY (TTM_ID)"; |
346 | 346 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
347 | 347 | |
348 | - $table_name='esp_question'; |
|
349 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
348 | + $table_name = 'esp_question'; |
|
349 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
350 | 350 | QST_display_text TEXT NOT NULL, |
351 | 351 | QST_admin_label VARCHAR(255) NOT NULL, |
352 | 352 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -358,27 +358,27 @@ discard block |
||
358 | 358 | QST_wp_user BIGINT UNSIGNED NULL, |
359 | 359 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
360 | 360 | PRIMARY KEY (QST_ID)'; |
361 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
361 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
362 | 362 | |
363 | - $table_name='esp_question_group_question'; |
|
364 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
363 | + $table_name = 'esp_question_group_question'; |
|
364 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
365 | 365 | QSG_ID INT UNSIGNED NOT NULL, |
366 | 366 | QST_ID INT UNSIGNED NOT NULL, |
367 | 367 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
368 | 368 | PRIMARY KEY (QGQ_ID) "; |
369 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
369 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
370 | 370 | |
371 | 371 | |
372 | 372 | |
373 | - $table_name='esp_question_option'; |
|
374 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | + $table_name = 'esp_question_option'; |
|
374 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
375 | 375 | QSO_value VARCHAR(255) NOT NULL, |
376 | 376 | QSO_desc TEXT NOT NULL, |
377 | 377 | QST_ID INT UNSIGNED NOT NULL, |
378 | 378 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
379 | 379 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
380 | 380 | PRIMARY KEY (QSO_ID)"; |
381 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
381 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
382 | 382 | |
383 | 383 | |
384 | 384 | |
@@ -411,8 +411,8 @@ discard block |
||
411 | 411 | |
412 | 412 | |
413 | 413 | |
414 | - $table_name='esp_checkin'; |
|
415 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
414 | + $table_name = 'esp_checkin'; |
|
415 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
416 | 416 | REG_ID INT(10) UNSIGNED NOT NULL, |
417 | 417 | DTT_ID INT(10) UNSIGNED NOT NULL, |
418 | 418 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -501,7 +501,7 @@ discard block |
||
501 | 501 | PRC_wp_user BIGINT UNSIGNED NULL, |
502 | 502 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
503 | 503 | PRIMARY KEY (PRC_ID)"; |
504 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
504 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
505 | 505 | |
506 | 506 | $table_name = "esp_price_type"; |
507 | 507 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -538,12 +538,12 @@ discard block |
||
538 | 538 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
539 | 539 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
540 | 540 | PRIMARY KEY (TKT_ID)"; |
541 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
541 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
542 | 542 | |
543 | - $this->_get_table_manager()->dropIndex( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
543 | + $this->_get_table_manager()->dropIndex('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
544 | 544 | |
545 | 545 | $table_name = 'esp_question_group'; |
546 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
546 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
547 | 547 | QSG_name VARCHAR(255) NOT NULL, |
548 | 548 | QSG_identifier VARCHAR(100) NOT NULL, |
549 | 549 | QSG_desc TEXT NULL, |
@@ -555,7 +555,7 @@ discard block |
||
555 | 555 | QSG_wp_user BIGINT UNSIGNED NULL, |
556 | 556 | PRIMARY KEY (QSG_ID), |
557 | 557 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
558 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
558 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
559 | 559 | |
560 | 560 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
561 | 561 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -583,15 +583,15 @@ discard block |
||
583 | 583 | return true; |
584 | 584 | } |
585 | 585 | |
586 | - public function migration_page_hooks(){ |
|
586 | + public function migration_page_hooks() { |
|
587 | 587 | |
588 | 588 | } |
589 | 589 | |
590 | - public function add_default_admin_only_payments(){ |
|
590 | + public function add_default_admin_only_payments() { |
|
591 | 591 | global $wpdb; |
592 | 592 | $table_name = $wpdb->prefix."esp_payment_method"; |
593 | 593 | $user_id = EEH_Activation::get_default_creator_id(); |
594 | - if ( $this->_get_table_analysis()->tableExists( $table_name ) ) { |
|
594 | + if ($this->_get_table_analysis()->tableExists($table_name)) { |
|
595 | 595 | |
596 | 596 | $SQL = "SELECT COUNT( * ) FROM $table_name"; |
597 | 597 | $existing_payment_methods = $wpdb->get_var($SQL); |
@@ -612,11 +612,11 @@ discard block |
||
612 | 612 | //so admins can record payments for them from the admin page |
613 | 613 | |
614 | 614 | |
615 | - foreach($default_admin_only_payment_methods as $nicename => $description){ |
|
615 | + foreach ($default_admin_only_payment_methods as $nicename => $description) { |
|
616 | 616 | $slug = sanitize_key($nicename); |
617 | 617 | //check that such a payment method exists |
618 | - $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s",$slug)); |
|
619 | - if( ! $exists){ |
|
618 | + $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s", $slug)); |
|
619 | + if ( ! $exists) { |
|
620 | 620 | $values = array( |
621 | 621 | 'PMD_type'=>'Admin_Only', |
622 | 622 | 'PMD_name'=>$nicename, |
@@ -630,17 +630,17 @@ discard block |
||
630 | 630 | $table_name, |
631 | 631 | $values, |
632 | 632 | array( |
633 | - '%s',//PMD_type |
|
634 | - '%s',//PMD_name |
|
635 | - '%s',//PMD_admin_name |
|
636 | - '%s',//PMD_admin_desc |
|
637 | - '%s',//PMD_slug |
|
638 | - '%d',//PMD_wp_user |
|
639 | - '%s',//PMD_scope |
|
633 | + '%s', //PMD_type |
|
634 | + '%s', //PMD_name |
|
635 | + '%s', //PMD_admin_name |
|
636 | + '%s', //PMD_admin_desc |
|
637 | + '%s', //PMD_slug |
|
638 | + '%d', //PMD_wp_user |
|
639 | + '%s', //PMD_scope |
|
640 | 640 | ) |
641 | 641 | ); |
642 | - if( ! $success ){ |
|
643 | - $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"),$this->_json_encode($values))); |
|
642 | + if ( ! $success) { |
|
643 | + $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"), $this->_json_encode($values))); |
|
644 | 644 | } |
645 | 645 | } |
646 | 646 | } |
@@ -658,11 +658,11 @@ discard block |
||
658 | 658 | |
659 | 659 | global $wpdb; |
660 | 660 | $currency_table = $wpdb->prefix."esp_currency"; |
661 | - if ( $this->_get_table_analysis()->tableExists( $currency_table ) ) { |
|
661 | + if ($this->_get_table_analysis()->tableExists($currency_table)) { |
|
662 | 662 | |
663 | 663 | $SQL = "SELECT COUNT('CUR_code') FROM $currency_table"; |
664 | 664 | $countries = $wpdb->get_var($SQL); |
665 | - if ( ! $countries ) { |
|
665 | + if ( ! $countries) { |
|
666 | 666 | $SQL = "INSERT INTO $currency_table |
667 | 667 | ( CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active) VALUES |
668 | 668 | ( 'EUR', 'Euro', 'Euros', '€', 2,1), |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -715,7 +715,7 @@ |
||
715 | 715 | } |
716 | 716 | } |
717 | 717 | } |
718 | - } |
|
718 | + } |
|
719 | 719 | /** |
720 | 720 | * addresses https://events.codebasehq.com/projects/event-espresso/tickets/8731 |
721 | 721 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
@@ -16,7 +16,7 @@ discard block |
||
16 | 16 | * @author Mike Nelson |
17 | 17 | * @since 4.6.0 |
18 | 18 | */ |
19 | -class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base{ |
|
19 | +class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base { |
|
20 | 20 | |
21 | 21 | /** |
22 | 22 | * return EE_DMS_Core_4_8_0 |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | * @param TableAnalysis $table_analysis |
26 | 26 | * @throws \EE_Error |
27 | 27 | */ |
28 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) { |
|
28 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
29 | 29 | $this->_load_script_stages(); |
30 | 30 | $this->_pretty_name = __("Data Migration to Event Espresso 4.8.0.P (for promotions)", "event_espresso"); |
31 | 31 | $this->_priority = 10; |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | new EE_DMS_4_8_0_pretax_totals(), |
34 | 34 | new EE_DMS_4_8_0_event_subtotals(), |
35 | 35 | ); |
36 | - parent::__construct( $table_manager, $table_analysis ); |
|
36 | + parent::__construct($table_manager, $table_analysis); |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | |
@@ -48,14 +48,14 @@ discard block |
||
48 | 48 | */ |
49 | 49 | public function can_migrate_from_version($version_array) { |
50 | 50 | $version_string = $version_array['Core']; |
51 | - if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
|
51 | + if ($version_string <= '4.8.0' && $version_string >= '4.7.0') { |
|
52 | 52 | // echo "$version_string can be migrated from"; |
53 | 53 | return true; |
54 | - }elseif( ! $version_string ){ |
|
54 | + }elseif ( ! $version_string) { |
|
55 | 55 | // echo "no version string provided: $version_string"; |
56 | 56 | //no version string provided... this must be pre 4.3 |
57 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
58 | - }else{ |
|
57 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
58 | + } else { |
|
59 | 59 | // echo "$version_string doesnt apply"; |
60 | 60 | return false; |
61 | 61 | } |
@@ -76,19 +76,19 @@ discard block |
||
76 | 76 | * @return bool |
77 | 77 | */ |
78 | 78 | public function schema_changes_before_migration() { |
79 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
80 | - $now_in_mysql = current_time( 'mysql', true ); |
|
79 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
80 | + $now_in_mysql = current_time('mysql', true); |
|
81 | 81 | |
82 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
83 | - $table_name='esp_answer'; |
|
84 | - $sql=" ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
82 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
83 | + $table_name = 'esp_answer'; |
|
84 | + $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
85 | 85 | REG_ID int(10) unsigned NOT NULL, |
86 | 86 | QST_ID int(10) unsigned NOT NULL, |
87 | 87 | ANS_value text NOT NULL, |
88 | 88 | PRIMARY KEY (ANS_ID), |
89 | 89 | KEY REG_ID (REG_ID), |
90 | 90 | KEY QST_ID (QST_ID)"; |
91 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
91 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
92 | 92 | |
93 | 93 | $table_name = 'esp_attendee_meta'; |
94 | 94 | $sql = "ATTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
@@ -128,7 +128,7 @@ discard block |
||
128 | 128 | CNT_is_EU tinyint(1) DEFAULT '0', |
129 | 129 | CNT_active tinyint(1) DEFAULT '0', |
130 | 130 | PRIMARY KEY (CNT_ISO)"; |
131 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
131 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
132 | 132 | |
133 | 133 | $table_name = 'esp_currency'; |
134 | 134 | $sql = "CUR_code varchar(6) collate utf8_bin NOT NULL, |
@@ -138,7 +138,7 @@ discard block |
||
138 | 138 | CUR_dec_plc varchar(1) collate utf8_bin NOT NULL DEFAULT '2', |
139 | 139 | CUR_active tinyint(1) DEFAULT '0', |
140 | 140 | PRIMARY KEY (CUR_code)"; |
141 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
141 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
142 | 142 | |
143 | 143 | |
144 | 144 | $table_name = 'esp_currency_payment_method'; |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | KEY EVT_ID (EVT_ID), |
169 | 169 | KEY DTT_is_primary (DTT_is_primary)"; |
170 | 170 | |
171 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
171 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
172 | 172 | |
173 | 173 | $table_name = 'esp_event_meta'; |
174 | 174 | $sql = " |
@@ -187,41 +187,41 @@ discard block |
||
187 | 187 | EVT_donations tinyint(1) NULL, |
188 | 188 | PRIMARY KEY (EVTM_ID), |
189 | 189 | KEY EVT_ID (EVT_ID)"; |
190 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
190 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
191 | 191 | |
192 | 192 | |
193 | 193 | |
194 | - $table_name='esp_event_question_group'; |
|
195 | - $sql="EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
194 | + $table_name = 'esp_event_question_group'; |
|
195 | + $sql = "EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
196 | 196 | EVT_ID bigint(20) unsigned NOT NULL, |
197 | 197 | QSG_ID int(10) unsigned NOT NULL, |
198 | 198 | EQG_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
199 | 199 | PRIMARY KEY (EQG_ID), |
200 | 200 | KEY EVT_ID (EVT_ID), |
201 | 201 | KEY QSG_ID (QSG_ID)"; |
202 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
202 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
203 | 203 | |
204 | 204 | |
205 | 205 | |
206 | - $table_name='esp_event_venue'; |
|
207 | - $sql="EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
206 | + $table_name = 'esp_event_venue'; |
|
207 | + $sql = "EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
208 | 208 | EVT_ID bigint(20) unsigned NOT NULL, |
209 | 209 | VNU_ID bigint(20) unsigned NOT NULL, |
210 | 210 | EVV_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
211 | 211 | PRIMARY KEY (EVV_ID)"; |
212 | - $this->_table_has_not_changed_since_previous($table_name,$sql, 'ENGINE=InnoDB'); |
|
212 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
213 | 213 | |
214 | 214 | |
215 | 215 | |
216 | - $table_name='esp_extra_meta'; |
|
217 | - $sql="EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
216 | + $table_name = 'esp_extra_meta'; |
|
217 | + $sql = "EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
218 | 218 | OBJ_ID int(11) DEFAULT NULL, |
219 | 219 | EXM_type varchar(45) DEFAULT NULL, |
220 | 220 | EXM_key varchar(45) DEFAULT NULL, |
221 | 221 | EXM_value text, |
222 | 222 | PRIMARY KEY (EXM_ID), |
223 | 223 | KEY EXM_type (EXM_type,OBJ_ID,EXM_key)"; |
224 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
224 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
225 | 225 | |
226 | 226 | $table_name = 'esp_extra_join'; |
227 | 227 | $sql = "EXJ_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -234,8 +234,8 @@ discard block |
||
234 | 234 | KEY second_model (EXJ_second_model_name,EXJ_second_model_id)"; |
235 | 235 | $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB '); |
236 | 236 | |
237 | - $table_name='esp_line_item'; |
|
238 | - $sql="LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
237 | + $table_name = 'esp_line_item'; |
|
238 | + $sql = "LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
239 | 239 | LIN_code varchar(245) NOT NULL DEFAULT '', |
240 | 240 | TXN_ID int(11) DEFAULT NULL, |
241 | 241 | LIN_name varchar(245) NOT NULL DEFAULT '', |
@@ -254,7 +254,7 @@ discard block |
||
254 | 254 | PRIMARY KEY (LIN_ID), |
255 | 255 | KEY LIN_code (LIN_code(191)), |
256 | 256 | KEY TXN_ID (TXN_ID)"; |
257 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
257 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
258 | 258 | |
259 | 259 | $table_name = 'esp_log'; |
260 | 260 | $sql = "LOG_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | MTP_is_active tinyint(1) NOT NULL DEFAULT '1', |
294 | 294 | PRIMARY KEY (GRP_ID), |
295 | 295 | KEY MTP_user_id (MTP_user_id)"; |
296 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
296 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
297 | 297 | |
298 | 298 | $table_name = 'esp_event_message_template'; |
299 | 299 | $sql = "EMT_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
@@ -302,7 +302,7 @@ discard block |
||
302 | 302 | PRIMARY KEY (EMT_ID), |
303 | 303 | KEY EVT_ID (EVT_ID), |
304 | 304 | KEY GRP_ID (GRP_ID)"; |
305 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
305 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
306 | 306 | |
307 | 307 | |
308 | 308 | $table_name = 'esp_payment'; |
@@ -375,8 +375,8 @@ discard block |
||
375 | 375 | PRIMARY KEY (TTM_ID)"; |
376 | 376 | $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
377 | 377 | |
378 | - $table_name='esp_question'; |
|
379 | - $sql='QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
378 | + $table_name = 'esp_question'; |
|
379 | + $sql = 'QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
380 | 380 | QST_display_text text NOT NULL, |
381 | 381 | QST_admin_label varchar(255) NOT NULL, |
382 | 382 | QST_system varchar(25) NOT NULL DEFAULT "", |
@@ -390,22 +390,22 @@ discard block |
||
390 | 390 | QST_deleted tinyint(2) unsigned NOT NULL DEFAULT 0, |
391 | 391 | PRIMARY KEY (QST_ID), |
392 | 392 | KEY QST_order (QST_order)'; |
393 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
393 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
394 | 394 | |
395 | - $table_name='esp_question_group_question'; |
|
396 | - $sql="QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
395 | + $table_name = 'esp_question_group_question'; |
|
396 | + $sql = "QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
397 | 397 | QSG_ID int(10) unsigned NOT NULL, |
398 | 398 | QST_ID int(10) unsigned NOT NULL, |
399 | 399 | QGQ_order int(10) unsigned NOT NULL DEFAULT 0, |
400 | 400 | PRIMARY KEY (QGQ_ID), |
401 | 401 | KEY QST_ID (QST_ID), |
402 | 402 | KEY QSG_ID_order (QSG_ID,QGQ_order)"; |
403 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
403 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
404 | 404 | |
405 | 405 | |
406 | 406 | |
407 | - $table_name='esp_question_option'; |
|
408 | - $sql="QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
407 | + $table_name = 'esp_question_option'; |
|
408 | + $sql = "QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
409 | 409 | QSO_value varchar(255) NOT NULL, |
410 | 410 | QSO_desc text NOT NULL, |
411 | 411 | QST_ID int(10) unsigned NOT NULL, |
@@ -415,7 +415,7 @@ discard block |
||
415 | 415 | PRIMARY KEY (QSO_ID), |
416 | 416 | KEY QST_ID (QST_ID), |
417 | 417 | KEY QSO_order (QSO_order)"; |
418 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
418 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
419 | 419 | |
420 | 420 | |
421 | 421 | |
@@ -461,8 +461,8 @@ discard block |
||
461 | 461 | |
462 | 462 | |
463 | 463 | |
464 | - $table_name='esp_checkin'; |
|
465 | - $sql="CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
464 | + $table_name = 'esp_checkin'; |
|
465 | + $sql = "CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
466 | 466 | REG_ID int(10) unsigned NOT NULL, |
467 | 467 | DTT_ID int(10) unsigned NOT NULL, |
468 | 468 | CHK_in tinyint(1) unsigned NOT NULL DEFAULT 1, |
@@ -557,7 +557,7 @@ discard block |
||
557 | 557 | PRC_parent int(10) unsigned DEFAULT 0, |
558 | 558 | PRIMARY KEY (PRC_ID), |
559 | 559 | KEY PRT_ID (PRT_ID)"; |
560 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
560 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
561 | 561 | |
562 | 562 | $table_name = "esp_price_type"; |
563 | 563 | $sql = "PRT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT, |
@@ -595,10 +595,10 @@ discard block |
||
595 | 595 | TKT_deleted tinyint(1) NOT NULL DEFAULT '0', |
596 | 596 | PRIMARY KEY (TKT_ID), |
597 | 597 | KEY TKT_start_date (TKT_start_date)"; |
598 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
598 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
599 | 599 | |
600 | 600 | $table_name = 'esp_question_group'; |
601 | - $sql='QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
601 | + $sql = 'QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
602 | 602 | QSG_name varchar(255) NOT NULL, |
603 | 603 | QSG_identifier varchar(100) NOT NULL, |
604 | 604 | QSG_desc text NULL, |
@@ -611,7 +611,7 @@ discard block |
||
611 | 611 | PRIMARY KEY (QSG_ID), |
612 | 612 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier), |
613 | 613 | KEY QSG_order (QSG_order)'; |
614 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
614 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
615 | 615 | |
616 | 616 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
617 | 617 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -647,7 +647,7 @@ discard block |
||
647 | 647 | return $script_4_7_defaults->schema_changes_after_migration(); |
648 | 648 | } |
649 | 649 | |
650 | - public function migration_page_hooks(){ |
|
650 | + public function migration_page_hooks() { |
|
651 | 651 | |
652 | 652 | } |
653 | 653 | |
@@ -661,19 +661,19 @@ discard block |
||
661 | 661 | //CNT_ISO, CNT_ISO3, RGN_ID, CNT_name, CNT_cur_code, CNT_cur_single, CNT_cur_plural, CNT_cur_sign, CNT_cur_sign_b4, CNT_cur_dec_plc, CNT_tel_code, CNT_is_EU, CNT_active |
662 | 662 | //('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
663 | 663 | $newer_countries = array( |
664 | - array( 'AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0 ), |
|
665 | - array( 'BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
666 | - array( 'CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0 ), |
|
667 | - array( 'GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0 ), |
|
668 | - array( 'IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
669 | - array( 'JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
670 | - array( 'MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
671 | - array( 'ME', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0 ), |
|
672 | - array( 'RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0 ), |
|
673 | - array( 'SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0 ), |
|
674 | - array( 'SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0 ), |
|
675 | - array( 'XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0 ), |
|
676 | - array( 'YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0 ), |
|
664 | + array('AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0), |
|
665 | + array('BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
666 | + array('CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0), |
|
667 | + array('GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0), |
|
668 | + array('IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
669 | + array('JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
670 | + array('MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
671 | + array('ME', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0), |
|
672 | + array('RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0), |
|
673 | + array('SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0), |
|
674 | + array('SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0), |
|
675 | + array('XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0), |
|
676 | + array('YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0), |
|
677 | 677 | ); |
678 | 678 | global $wpdb; |
679 | 679 | $country_table = $wpdb->prefix."esp_country"; |
@@ -692,14 +692,14 @@ discard block |
||
692 | 692 | "CNT_is_EU" => '%d', |
693 | 693 | "CNT_active" => '%d', |
694 | 694 | ); |
695 | - if ( $this->_get_table_analysis()->tableExists( $country_table ) ) { |
|
696 | - foreach( $newer_countries as $country ) { |
|
697 | - $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1" ; |
|
695 | + if ($this->_get_table_analysis()->tableExists($country_table)) { |
|
696 | + foreach ($newer_countries as $country) { |
|
697 | + $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1"; |
|
698 | 698 | $countries = $wpdb->get_var($SQL); |
699 | - if ( ! $countries ) { |
|
699 | + if ( ! $countries) { |
|
700 | 700 | |
701 | - $wpdb->insert( $country_table, |
|
702 | - array_combine( array_keys( $country_format), $country ), |
|
701 | + $wpdb->insert($country_table, |
|
702 | + array_combine(array_keys($country_format), $country), |
|
703 | 703 | $country_format |
704 | 704 | ); |
705 | 705 | } |
@@ -717,7 +717,7 @@ discard block |
||
717 | 717 | // CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active |
718 | 718 | //( 'EUR', 'Euro', 'Euros', '€', 2,1), |
719 | 719 | $newer_currencies = array( |
720 | - array( 'RSD', 'Dinar', 'Dinars', '', 3, 1 ), |
|
720 | + array('RSD', 'Dinar', 'Dinars', '', 3, 1), |
|
721 | 721 | ); |
722 | 722 | global $wpdb; |
723 | 723 | $currency_table = $wpdb->prefix."esp_currency"; |
@@ -729,14 +729,14 @@ discard block |
||
729 | 729 | "CUR_dec_plc" => '%d', |
730 | 730 | "CUR_active" => '%d', |
731 | 731 | ); |
732 | - if ( $this->_get_table_analysis()->tableExists( $currency_table ) ) { |
|
733 | - foreach( $newer_currencies as $currency ) { |
|
734 | - $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1" ; |
|
732 | + if ($this->_get_table_analysis()->tableExists($currency_table)) { |
|
733 | + foreach ($newer_currencies as $currency) { |
|
734 | + $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1"; |
|
735 | 735 | $countries = $wpdb->get_var($SQL); |
736 | - if ( ! $countries ) { |
|
736 | + if ( ! $countries) { |
|
737 | 737 | |
738 | - $wpdb->insert( $currency_table, |
|
739 | - array_combine( array_keys( $currency_format), $currency ), |
|
738 | + $wpdb->insert($currency_table, |
|
739 | + array_combine(array_keys($currency_format), $currency), |
|
740 | 740 | $currency_format |
741 | 741 | ); |
742 | 742 | } |
@@ -748,9 +748,9 @@ discard block |
||
748 | 748 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
749 | 749 | * we should be able to stop doing this in 4.9 |
750 | 750 | */ |
751 | - public function fix_non_default_taxes(){ |
|
751 | + public function fix_non_default_taxes() { |
|
752 | 752 | global $wpdb; |
753 | - $query = $wpdb->prepare( "UPDATE |
|
753 | + $query = $wpdb->prepare("UPDATE |
|
754 | 754 | {$wpdb->prefix}esp_price p INNER JOIN |
755 | 755 | {$wpdb->prefix}esp_price_type pt ON p.PRT_ID = pt.PRT_ID |
756 | 756 | SET |
@@ -758,7 +758,7 @@ discard block |
||
758 | 758 | WHERE |
759 | 759 | p.PRC_is_default = 0 AND |
760 | 760 | pt.PBT_ID = %d |
761 | - ", EEM_Price_Type::base_type_tax ); |
|
762 | - $wpdb->query( $query ); |
|
761 | + ", EEM_Price_Type::base_type_tax); |
|
762 | + $wpdb->query($query); |
|
763 | 763 | } |
764 | 764 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | protected $_old_table; |
22 | 22 | |
23 | 23 | /** |
24 | - * Set in the constructor to add this sql to both the counting query in |
|
25 | - * EE_Data_Migration_Script_Stage_Table::_count_records_to_migrate() and |
|
26 | - * EE_Data_Migration_Script_Stage_Table::_get_rows(). |
|
27 | - * Eg "where column_name like '%some_value%'" |
|
28 | - * @var string |
|
29 | - */ |
|
24 | + * Set in the constructor to add this sql to both the counting query in |
|
25 | + * EE_Data_Migration_Script_Stage_Table::_count_records_to_migrate() and |
|
26 | + * EE_Data_Migration_Script_Stage_Table::_get_rows(). |
|
27 | + * Eg "where column_name like '%some_value%'" |
|
28 | + * @var string |
|
29 | + */ |
|
30 | 30 | protected $_extra_where_sql; |
31 | 31 | |
32 | 32 |
@@ -41,14 +41,14 @@ discard block |
||
41 | 41 | * @param int $num_items |
42 | 42 | * @return int number of items ACTUALLY migrated |
43 | 43 | */ |
44 | - function _migration_step($num_items=50){ |
|
45 | - $rows = $this->_get_rows( $num_items ); |
|
44 | + function _migration_step($num_items = 50) { |
|
45 | + $rows = $this->_get_rows($num_items); |
|
46 | 46 | $items_actually_migrated = 0; |
47 | - foreach($rows as $old_row){ |
|
47 | + foreach ($rows as $old_row) { |
|
48 | 48 | $this->_migrate_old_row($old_row); |
49 | 49 | $items_actually_migrated++; |
50 | 50 | } |
51 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
51 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
52 | 52 | $this->set_completed(); |
53 | 53 | } |
54 | 54 | return $items_actually_migrated; |
@@ -60,11 +60,11 @@ discard block |
||
60 | 60 | * @param int $limit |
61 | 61 | * @return array of arrays like $wpdb->get_results($sql, ARRAY_A) |
62 | 62 | */ |
63 | - protected function _get_rows( $limit ){ |
|
63 | + protected function _get_rows($limit) { |
|
64 | 64 | global $wpdb; |
65 | 65 | $start_at_record = $this->count_records_migrated(); |
66 | - $query = "SELECT * FROM {$this->_old_table} {$this->_extra_where_sql} " . $wpdb->prepare("LIMIT %d, %d",$start_at_record,$limit); |
|
67 | - return $wpdb->get_results($query,ARRAY_A); |
|
66 | + $query = "SELECT * FROM {$this->_old_table} {$this->_extra_where_sql} ".$wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit); |
|
67 | + return $wpdb->get_results($query, ARRAY_A); |
|
68 | 68 | } |
69 | 69 | |
70 | 70 | |
@@ -75,8 +75,8 @@ discard block |
||
75 | 75 | */ |
76 | 76 | function _count_records_to_migrate() { |
77 | 77 | global $wpdb; |
78 | - $query = "SELECT COUNT(*) FROM {$this->_old_table} {$this->_extra_where_sql}"; |
|
79 | - $count = $wpdb->get_var( $query ); |
|
78 | + $query = "SELECT COUNT(*) FROM {$this->_old_table} {$this->_extra_where_sql}"; |
|
79 | + $count = $wpdb->get_var($query); |
|
80 | 80 | return $count; |
81 | 81 | } |
82 | 82 |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -31,9 +31,9 @@ discard block |
||
31 | 31 | * @param array $props_n_values |
32 | 32 | * @return EE_Answer |
33 | 33 | */ |
34 | - public static function new_instance( $props_n_values = array() ) { |
|
35 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__ ); |
|
36 | - return $has_object ? $has_object : new self( $props_n_values ); |
|
34 | + public static function new_instance($props_n_values = array()) { |
|
35 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__); |
|
36 | + return $has_object ? $has_object : new self($props_n_values); |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | |
@@ -43,8 +43,8 @@ discard block |
||
43 | 43 | * @param array $props_n_values |
44 | 44 | * @return EE_Answer |
45 | 45 | */ |
46 | - public static function new_instance_from_db( $props_n_values = array() ) { |
|
47 | - return new self( $props_n_values, TRUE ); |
|
46 | + public static function new_instance_from_db($props_n_values = array()) { |
|
47 | + return new self($props_n_values, TRUE); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | |
@@ -55,8 +55,8 @@ discard block |
||
55 | 55 | * @access public |
56 | 56 | * @param int $QST_ID |
57 | 57 | */ |
58 | - public function set_question( $QST_ID = 0 ) { |
|
59 | - $this->set( 'QST_ID', $QST_ID ); |
|
58 | + public function set_question($QST_ID = 0) { |
|
59 | + $this->set('QST_ID', $QST_ID); |
|
60 | 60 | } |
61 | 61 | |
62 | 62 | |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | * @access public |
68 | 68 | * @param int $REG_ID |
69 | 69 | */ |
70 | - public function set_registration( $REG_ID = 0 ) { |
|
71 | - $this->set( 'REG_ID', $REG_ID ); |
|
70 | + public function set_registration($REG_ID = 0) { |
|
71 | + $this->set('REG_ID', $REG_ID); |
|
72 | 72 | } |
73 | 73 | |
74 | 74 | |
@@ -79,8 +79,8 @@ discard block |
||
79 | 79 | * @access public |
80 | 80 | * @param mixed $ANS_value |
81 | 81 | */ |
82 | - public function set_value( $ANS_value = '' ) { |
|
83 | - $this->set( 'ANS_value', $ANS_value ); |
|
82 | + public function set_value($ANS_value = '') { |
|
83 | + $this->set('ANS_value', $ANS_value); |
|
84 | 84 | } |
85 | 85 | |
86 | 86 | |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | * @return int |
93 | 93 | */ |
94 | 94 | public function registration_ID() { |
95 | - return $this->get( 'REG_ID' ); |
|
95 | + return $this->get('REG_ID'); |
|
96 | 96 | } |
97 | 97 | |
98 | 98 | |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | * @return int |
105 | 105 | */ |
106 | 106 | public function question_ID() { |
107 | - return $this->get( 'QST_ID' ); |
|
107 | + return $this->get('QST_ID'); |
|
108 | 108 | } |
109 | 109 | |
110 | 110 | |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | * @return string |
117 | 117 | */ |
118 | 118 | public function value() { |
119 | - return $this->get( 'ANS_value' ); |
|
119 | + return $this->get('ANS_value'); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | |
@@ -126,8 +126,8 @@ discard block |
||
126 | 126 | * @param null $schema |
127 | 127 | * @return string |
128 | 128 | */ |
129 | - public function pretty_value( $schema = NULL ) { |
|
130 | - return $this->get_pretty( 'ANS_value', $schema ); |
|
129 | + public function pretty_value($schema = NULL) { |
|
130 | + return $this->get_pretty('ANS_value', $schema); |
|
131 | 131 | } |
132 | 132 | |
133 | 133 | |
@@ -136,8 +136,8 @@ discard block |
||
136 | 136 | * Echoes out a pretty value (even for multi-choice options) |
137 | 137 | * @param string $schema |
138 | 138 | */ |
139 | - public function e_value( $schema = NULL ) { |
|
140 | - $this->e( 'ANS_value', $schema ); |
|
139 | + public function e_value($schema = NULL) { |
|
140 | + $this->e('ANS_value', $schema); |
|
141 | 141 | } |
142 | 142 | |
143 | 143 | |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | * @return EE_Question |
148 | 148 | */ |
149 | 149 | public function question() { |
150 | - return $this->get_first_related( 'Question' ); |
|
150 | + return $this->get_first_related('Question'); |
|
151 | 151 | } |
152 | 152 | |
153 | 153 | |
@@ -157,7 +157,7 @@ discard block |
||
157 | 157 | * @return EE_Registration |
158 | 158 | */ |
159 | 159 | public function registration() { |
160 | - return $this->get_first_related( 'Registration' ); |
|
160 | + return $this->get_first_related('Registration'); |
|
161 | 161 | } |
162 | 162 | } |
163 | 163 |
@@ -77,7 +77,7 @@ |
||
77 | 77 | * Set Answer value |
78 | 78 | * |
79 | 79 | * @access public |
80 | - * @param mixed $ANS_value |
|
80 | + * @param string $ANS_value |
|
81 | 81 | */ |
82 | 82 | public function set_value( $ANS_value = '' ) { |
83 | 83 | $this->set( 'ANS_value', $ANS_value ); |
@@ -1,7 +1,8 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | +} |
|
5 | 6 | |
6 | 7 | /** |
7 | 8 | * Event Espresso |
@@ -152,7 +153,7 @@ discard block |
||
152 | 153 | $is_model_name = EE_Registry::instance()->is_model_name($model_name_of_related_obj); |
153 | 154 | if( ! $is_model_name ){ |
154 | 155 | return null; |
155 | - }else{ |
|
156 | + } else{ |
|
156 | 157 | return $this->get_first_related($model_name_of_related_obj); |
157 | 158 | } |
158 | 159 | } |
@@ -169,13 +170,13 @@ discard block |
||
169 | 170 | if($object instanceof EE_Base_Class){ |
170 | 171 | $this->set_OBJ_type($object->get_model()->get_this_model_name()); |
171 | 172 | $this->set_OBJ_ID($object->ID()); |
172 | - }else{ |
|
173 | + } else{ |
|
173 | 174 | $this->set_OBJ_type(NULL); |
174 | 175 | $this->set_OBJ_ID(NULL); |
175 | 176 | } |
176 | 177 | if($save){ |
177 | 178 | return $this->save(); |
178 | - }else{ |
|
179 | + } else{ |
|
179 | 180 | return NULL; |
180 | 181 | } |
181 | 182 | } |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | |
6 | 6 | /** |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | * |
26 | 26 | * ------------------------------------------------------------------------ |
27 | 27 | */ |
28 | -class EE_Change_Log extends EE_Base_Class{ |
|
28 | +class EE_Change_Log extends EE_Base_Class { |
|
29 | 29 | |
30 | 30 | /** |
31 | 31 | * |
@@ -36,9 +36,9 @@ discard block |
||
36 | 36 | * date_format and the second value is the time format |
37 | 37 | * @return EE_Attendee |
38 | 38 | */ |
39 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
40 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
41 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
39 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
40 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
41 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | |
@@ -49,8 +49,8 @@ discard block |
||
49 | 49 | * the website will be used. |
50 | 50 | * @return EE_Attendee |
51 | 51 | */ |
52 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
53 | - return new self( $props_n_values, TRUE, $timezone ); |
|
52 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
53 | + return new self($props_n_values, TRUE, $timezone); |
|
54 | 54 | } |
55 | 55 | /** |
56 | 56 | * Gets message |
@@ -147,12 +147,12 @@ discard block |
||
147 | 147 | * Gets the model object attached to this log |
148 | 148 | * @return EE_Base_Class |
149 | 149 | */ |
150 | - function object(){ |
|
150 | + function object() { |
|
151 | 151 | $model_name_of_related_obj = $this->OBJ_type(); |
152 | 152 | $is_model_name = EE_Registry::instance()->is_model_name($model_name_of_related_obj); |
153 | - if( ! $is_model_name ){ |
|
153 | + if ( ! $is_model_name) { |
|
154 | 154 | return null; |
155 | - }else{ |
|
155 | + } else { |
|
156 | 156 | return $this->get_first_related($model_name_of_related_obj); |
157 | 157 | } |
158 | 158 | } |
@@ -165,17 +165,17 @@ discard block |
||
165 | 165 | * @param boolean $save |
166 | 166 | * @return boolean if $save=true, NULL is $save=false |
167 | 167 | */ |
168 | - function set_object($object, $save = TRUE ) { |
|
169 | - if($object instanceof EE_Base_Class){ |
|
168 | + function set_object($object, $save = TRUE) { |
|
169 | + if ($object instanceof EE_Base_Class) { |
|
170 | 170 | $this->set_OBJ_type($object->get_model()->get_this_model_name()); |
171 | 171 | $this->set_OBJ_ID($object->ID()); |
172 | - }else{ |
|
172 | + } else { |
|
173 | 173 | $this->set_OBJ_type(NULL); |
174 | 174 | $this->set_OBJ_ID(NULL); |
175 | 175 | } |
176 | - if($save){ |
|
176 | + if ($save) { |
|
177 | 177 | return $this->save(); |
178 | - }else{ |
|
178 | + } else { |
|
179 | 179 | return NULL; |
180 | 180 | } |
181 | 181 | } |
@@ -47,7 +47,7 @@ |
||
47 | 47 | * @param array $props_n_values incoming values from the database |
48 | 48 | * @param string $timezone incoming timezone as set by the model. If not set the timezone for |
49 | 49 | * the website will be used. |
50 | - * @return EE_Attendee |
|
50 | + * @return EE_Change_Log |
|
51 | 51 | */ |
52 | 52 | public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
53 | 53 | return new self( $props_n_values, TRUE, $timezone ); |
@@ -1,4 +1,6 @@ |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
3 | 5 | /** |
4 | 6 | * Event Espresso |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | -do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | +do_action('AHEE_log', __FILE__, __FUNCTION__, ''); |
|
3 | 3 | /** |
4 | 4 | * Event Espresso |
5 | 5 | * |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | * @subpackage includes/classes/EE_Checkin.class.php |
24 | 24 | * @author Darren Ethier |
25 | 25 | */ |
26 | -class EE_Checkin extends EE_Base_Class{ |
|
26 | +class EE_Checkin extends EE_Base_Class { |
|
27 | 27 | |
28 | 28 | /** |
29 | 29 | * |
@@ -34,9 +34,9 @@ discard block |
||
34 | 34 | * date_format and the second value is the time format |
35 | 35 | * @return EE_Checkin |
36 | 36 | */ |
37 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
38 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
39 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
37 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
38 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
39 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | |
@@ -47,8 +47,8 @@ discard block |
||
47 | 47 | * the website will be used. |
48 | 48 | * @return EE_Checkin |
49 | 49 | */ |
50 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
51 | - return new self( $props_n_values, TRUE, $timezone ); |
|
50 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
51 | + return new self($props_n_values, TRUE, $timezone); |
|
52 | 52 | } |
53 | 53 | |
54 | 54 |
@@ -708,12 +708,10 @@ |
||
708 | 708 | if ( date( 'm', $this->get_raw( 'DTT_EVT_start' ) ) != date( 'm', $this->get_raw( 'DTT_EVT_end' ) ) ) { |
709 | 709 | $display_date = $this->start_date( 'M j\, Y g:i a' ) . ' - ' . $this->end_date( 'M j\, Y g:i a' ); |
710 | 710 | //next condition is if its the same month but different day |
711 | - } |
|
712 | - else { |
|
711 | + } else { |
|
713 | 712 | if ( date( 'm', $this->get_raw( 'DTT_EVT_start' ) ) == date( 'm', $this->get_raw( 'DTT_EVT_end' ) ) && date( 'd', $this->get_raw( 'DTT_EVT_start' ) ) != date( 'd', $this->get_raw( 'DTT_EVT_end' ) ) ) { |
714 | 713 | $display_date = $this->start_date( 'M j\, g:i a' ) . ' - ' . $this->end_date( 'M j\, g:i a Y' ); |
715 | - } |
|
716 | - else { |
|
714 | + } else { |
|
717 | 715 | $display_date = $this->start_date( 'F j\, Y' ) . ' @ ' . $this->start_date( 'g:i a' ) . ' - ' . $this->end_date( 'g:i a' ); |
718 | 716 | } |
719 | 717 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -74,9 +74,9 @@ discard block |
||
74 | 74 | * date_format and the second value is the time format |
75 | 75 | * @return EE_Datetime |
76 | 76 | */ |
77 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
78 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
79 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
77 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
78 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
79 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
80 | 80 | } |
81 | 81 | |
82 | 82 | |
@@ -87,8 +87,8 @@ discard block |
||
87 | 87 | * the website will be used. |
88 | 88 | * @return EE_Datetime |
89 | 89 | */ |
90 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
91 | - return new self( $props_n_values, TRUE, $timezone ); |
|
90 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
91 | + return new self($props_n_values, TRUE, $timezone); |
|
92 | 92 | } |
93 | 93 | |
94 | 94 | |
@@ -96,8 +96,8 @@ discard block |
||
96 | 96 | /** |
97 | 97 | * @param $name |
98 | 98 | */ |
99 | - public function set_name( $name ) { |
|
100 | - $this->set( 'DTT_name', $name ); |
|
99 | + public function set_name($name) { |
|
100 | + $this->set('DTT_name', $name); |
|
101 | 101 | } |
102 | 102 | |
103 | 103 | |
@@ -105,8 +105,8 @@ discard block |
||
105 | 105 | /** |
106 | 106 | * @param $description |
107 | 107 | */ |
108 | - public function set_description( $description ) { |
|
109 | - $this->set( 'DTT_description', $description ); |
|
108 | + public function set_description($description) { |
|
109 | + $this->set('DTT_description', $description); |
|
110 | 110 | } |
111 | 111 | |
112 | 112 | |
@@ -119,8 +119,8 @@ discard block |
||
119 | 119 | * @access public |
120 | 120 | * @param string $date a string representation of the event's date ex: Dec. 25, 2025 or 12-25-2025 |
121 | 121 | */ |
122 | - public function set_start_date( $date ) { |
|
123 | - $this->_set_date_for( $date, 'DTT_EVT_start' ); |
|
122 | + public function set_start_date($date) { |
|
123 | + $this->_set_date_for($date, 'DTT_EVT_start'); |
|
124 | 124 | } |
125 | 125 | |
126 | 126 | |
@@ -133,8 +133,8 @@ discard block |
||
133 | 133 | * @access public |
134 | 134 | * @param string $time a string representation of the event time ex: 9am or 7:30 PM |
135 | 135 | */ |
136 | - public function set_start_time( $time ) { |
|
137 | - $this->_set_time_for( $time, 'DTT_EVT_start' ); |
|
136 | + public function set_start_time($time) { |
|
137 | + $this->_set_time_for($time, 'DTT_EVT_start'); |
|
138 | 138 | } |
139 | 139 | |
140 | 140 | |
@@ -147,8 +147,8 @@ discard block |
||
147 | 147 | * @access public |
148 | 148 | * @param string $date a string representation of the event's date ex: Dec. 25, 2025 or 12-25-2025 |
149 | 149 | */ |
150 | - public function set_end_date( $date ) { |
|
151 | - $this->_set_date_for( $date, 'DTT_EVT_end' ); |
|
150 | + public function set_end_date($date) { |
|
151 | + $this->_set_date_for($date, 'DTT_EVT_end'); |
|
152 | 152 | } |
153 | 153 | |
154 | 154 | |
@@ -161,8 +161,8 @@ discard block |
||
161 | 161 | * @access public |
162 | 162 | * @param string $time a string representation of the event time ex: 9am or 7:30 PM |
163 | 163 | */ |
164 | - public function set_end_time( $time ) { |
|
165 | - $this->_set_time_for( $time, 'DTT_EVT_end' ); |
|
164 | + public function set_end_time($time) { |
|
165 | + $this->_set_time_for($time, 'DTT_EVT_end'); |
|
166 | 166 | } |
167 | 167 | |
168 | 168 | |
@@ -175,8 +175,8 @@ discard block |
||
175 | 175 | * @access public |
176 | 176 | * @param int $reg_limit |
177 | 177 | */ |
178 | - public function set_reg_limit( $reg_limit ) { |
|
179 | - $this->set( 'DTT_reg_limit', $reg_limit ); |
|
178 | + public function set_reg_limit($reg_limit) { |
|
179 | + $this->set('DTT_reg_limit', $reg_limit); |
|
180 | 180 | } |
181 | 181 | |
182 | 182 | |
@@ -187,10 +187,10 @@ discard block |
||
187 | 187 | * @access public |
188 | 188 | * @param int $sold |
189 | 189 | */ |
190 | - public function set_sold( $sold ) { |
|
190 | + public function set_sold($sold) { |
|
191 | 191 | // sold can not go below zero |
192 | - $sold = max( 0, $sold ); |
|
193 | - $this->set( 'DTT_sold', $sold ); |
|
192 | + $sold = max(0, $sold); |
|
193 | + $this->set('DTT_sold', $sold); |
|
194 | 194 | } |
195 | 195 | |
196 | 196 | |
@@ -199,9 +199,9 @@ discard block |
||
199 | 199 | * increments sold by amount passed by $qty |
200 | 200 | * @param int $qty |
201 | 201 | */ |
202 | - function increase_sold( $qty = 1 ) { |
|
202 | + function increase_sold($qty = 1) { |
|
203 | 203 | $sold = $this->sold() + $qty; |
204 | - $this->set_sold( $sold ); |
|
204 | + $this->set_sold($sold); |
|
205 | 205 | } |
206 | 206 | |
207 | 207 | |
@@ -210,9 +210,9 @@ discard block |
||
210 | 210 | * decrements (subtracts) sold amount passed by $qty |
211 | 211 | * @param int $qty |
212 | 212 | */ |
213 | - function decrease_sold( $qty = 1 ) { |
|
213 | + function decrease_sold($qty = 1) { |
|
214 | 214 | $sold = $this->sold() - $qty; |
215 | - $this->set_sold( $sold ); |
|
215 | + $this->set_sold($sold); |
|
216 | 216 | } |
217 | 217 | |
218 | 218 | |
@@ -222,7 +222,7 @@ discard block |
||
222 | 222 | * @return string |
223 | 223 | */ |
224 | 224 | public function name() { |
225 | - return $this->get( 'DTT_name' ); |
|
225 | + return $this->get('DTT_name'); |
|
226 | 226 | } |
227 | 227 | |
228 | 228 | |
@@ -232,7 +232,7 @@ discard block |
||
232 | 232 | * @return string |
233 | 233 | */ |
234 | 234 | public function description() { |
235 | - return $this->get( 'DTT_description' ); |
|
235 | + return $this->get('DTT_description'); |
|
236 | 236 | } |
237 | 237 | |
238 | 238 | |
@@ -242,7 +242,7 @@ discard block |
||
242 | 242 | * @return boolean TRUE if is primary, FALSE if not. |
243 | 243 | */ |
244 | 244 | public function is_primary() { |
245 | - return $this->get( 'DTT_is_primary' ); |
|
245 | + return $this->get('DTT_is_primary'); |
|
246 | 246 | } |
247 | 247 | |
248 | 248 | |
@@ -252,7 +252,7 @@ discard block |
||
252 | 252 | * @return int The order of the datetime for this event. |
253 | 253 | */ |
254 | 254 | public function order() { |
255 | - return $this->get( 'DTT_order' ); |
|
255 | + return $this->get('DTT_order'); |
|
256 | 256 | } |
257 | 257 | |
258 | 258 | |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | * @return int |
263 | 263 | */ |
264 | 264 | public function parent() { |
265 | - return $this->get( 'DTT_parent' ); |
|
265 | + return $this->get('DTT_parent'); |
|
266 | 266 | } |
267 | 267 | |
268 | 268 | |
@@ -278,10 +278,10 @@ discard block |
||
278 | 278 | * @param bool $echo - whether we echo or return (note echoing uses "pretty" formats, otherwise we use the standard formats) |
279 | 279 | * @return string|bool|void string on success, FALSE on fail |
280 | 280 | */ |
281 | - private function _show_datetime( $date_or_time = NULL, $start_or_end = 'start', $dt_frmt = '', $tm_frmt = '', $echo = FALSE ) { |
|
281 | + private function _show_datetime($date_or_time = NULL, $start_or_end = 'start', $dt_frmt = '', $tm_frmt = '', $echo = FALSE) { |
|
282 | 282 | $field_name = "DTT_EVT_{$start_or_end}"; |
283 | - $dtt = $this->_get_datetime( $field_name, $dt_frmt, $tm_frmt, $date_or_time, $echo ); |
|
284 | - if ( ! $echo ) { |
|
283 | + $dtt = $this->_get_datetime($field_name, $dt_frmt, $tm_frmt, $date_or_time, $echo); |
|
284 | + if ( ! $echo) { |
|
285 | 285 | return $dtt; |
286 | 286 | } |
287 | 287 | return ''; |
@@ -297,8 +297,8 @@ discard block |
||
297 | 297 | * @param null $dt_frmt - string representation of date format defaults to 'F j, Y' |
298 | 298 | * @return mixed string on success, FALSE on fail |
299 | 299 | */ |
300 | - public function start_date( $dt_frmt = NULL ) { |
|
301 | - return $this->_show_datetime( 'D', 'start', $dt_frmt ); |
|
300 | + public function start_date($dt_frmt = NULL) { |
|
301 | + return $this->_show_datetime('D', 'start', $dt_frmt); |
|
302 | 302 | } |
303 | 303 | |
304 | 304 | |
@@ -307,8 +307,8 @@ discard block |
||
307 | 307 | * Echoes start_date() |
308 | 308 | * @param string $dt_frmt |
309 | 309 | */ |
310 | - public function e_start_date( $dt_frmt = NULL ) { |
|
311 | - $this->_show_datetime( 'D', 'start', $dt_frmt, NULL, TRUE ); |
|
310 | + public function e_start_date($dt_frmt = NULL) { |
|
311 | + $this->_show_datetime('D', 'start', $dt_frmt, NULL, TRUE); |
|
312 | 312 | } |
313 | 313 | |
314 | 314 | |
@@ -321,8 +321,8 @@ discard block |
||
321 | 321 | * @param null $dt_frmt - string representation of date format defaults to 'F j, Y' |
322 | 322 | * @return mixed string on success, FALSE on fail |
323 | 323 | */ |
324 | - public function end_date( $dt_frmt = NULL ) { |
|
325 | - return $this->_show_datetime( 'D', 'end', $dt_frmt ); |
|
324 | + public function end_date($dt_frmt = NULL) { |
|
325 | + return $this->_show_datetime('D', 'end', $dt_frmt); |
|
326 | 326 | } |
327 | 327 | |
328 | 328 | |
@@ -331,8 +331,8 @@ discard block |
||
331 | 331 | * Echoes the end date. See end_date() |
332 | 332 | * @param string $dt_frmt |
333 | 333 | */ |
334 | - public function e_end_date( $dt_frmt = NULL ) { |
|
335 | - $this->_show_datetime( 'D', 'end', $dt_frmt, NULL, TRUE ); |
|
334 | + public function e_end_date($dt_frmt = NULL) { |
|
335 | + $this->_show_datetime('D', 'end', $dt_frmt, NULL, TRUE); |
|
336 | 336 | } |
337 | 337 | |
338 | 338 | |
@@ -345,11 +345,11 @@ discard block |
||
345 | 345 | * @param string $conjunction - conjunction junction what's your function ? this string joins the start date with the end date ie: Jan 01 "to" Dec 31 |
346 | 346 | * @return mixed string on success, FALSE on fail |
347 | 347 | */ |
348 | - public function date_range( $dt_frmt = NULL, $conjunction = ' - ' ) { |
|
349 | - $dt_frmt = ! empty( $dt_frmt ) ? $dt_frmt : $this->_dt_frmt; |
|
350 | - $start = str_replace( ' ', ' ', $this->get_i18n_datetime( 'DTT_EVT_start', $dt_frmt ) ); |
|
351 | - $end = str_replace( ' ', ' ', $this->get_i18n_datetime( 'DTT_EVT_end', $dt_frmt ) ); |
|
352 | - return $start != $end ? $start . $conjunction . $end : $start; |
|
348 | + public function date_range($dt_frmt = NULL, $conjunction = ' - ') { |
|
349 | + $dt_frmt = ! empty($dt_frmt) ? $dt_frmt : $this->_dt_frmt; |
|
350 | + $start = str_replace(' ', ' ', $this->get_i18n_datetime('DTT_EVT_start', $dt_frmt)); |
|
351 | + $end = str_replace(' ', ' ', $this->get_i18n_datetime('DTT_EVT_end', $dt_frmt)); |
|
352 | + return $start != $end ? $start.$conjunction.$end : $start; |
|
353 | 353 | } |
354 | 354 | |
355 | 355 | |
@@ -358,8 +358,8 @@ discard block |
||
358 | 358 | * @param null $dt_frmt |
359 | 359 | * @param string $conjunction |
360 | 360 | */ |
361 | - public function e_date_range( $dt_frmt = NULL, $conjunction = ' - ' ) { |
|
362 | - echo $this->date_range( $dt_frmt, $conjunction ); |
|
361 | + public function e_date_range($dt_frmt = NULL, $conjunction = ' - ') { |
|
362 | + echo $this->date_range($dt_frmt, $conjunction); |
|
363 | 363 | } |
364 | 364 | |
365 | 365 | |
@@ -371,8 +371,8 @@ discard block |
||
371 | 371 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
372 | 372 | * @return mixed string on success, FALSE on fail |
373 | 373 | */ |
374 | - public function start_time( $tm_format = NULL ) { |
|
375 | - return $this->_show_datetime( 'T', 'start', NULL, $tm_format ); |
|
374 | + public function start_time($tm_format = NULL) { |
|
375 | + return $this->_show_datetime('T', 'start', NULL, $tm_format); |
|
376 | 376 | } |
377 | 377 | |
378 | 378 | |
@@ -380,8 +380,8 @@ discard block |
||
380 | 380 | /** |
381 | 381 | * @param null $tm_format |
382 | 382 | */ |
383 | - public function e_start_time( $tm_format = NULL ) { |
|
384 | - $this->_show_datetime( 'T', 'start', NULL, $tm_format, TRUE ); |
|
383 | + public function e_start_time($tm_format = NULL) { |
|
384 | + $this->_show_datetime('T', 'start', NULL, $tm_format, TRUE); |
|
385 | 385 | } |
386 | 386 | |
387 | 387 | |
@@ -393,8 +393,8 @@ discard block |
||
393 | 393 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
394 | 394 | * @return mixed string on success, FALSE on fail |
395 | 395 | */ |
396 | - public function end_time( $tm_format = NULL ) { |
|
397 | - return $this->_show_datetime( 'T', 'end', NULL, $tm_format ); |
|
396 | + public function end_time($tm_format = NULL) { |
|
397 | + return $this->_show_datetime('T', 'end', NULL, $tm_format); |
|
398 | 398 | } |
399 | 399 | |
400 | 400 | |
@@ -402,8 +402,8 @@ discard block |
||
402 | 402 | /** |
403 | 403 | * @param null $tm_format |
404 | 404 | */ |
405 | - public function e_end_time( $tm_format = NULL ) { |
|
406 | - $this->_show_datetime( 'T', 'end', NULL, $tm_format, TRUE ); |
|
405 | + public function e_end_time($tm_format = NULL) { |
|
406 | + $this->_show_datetime('T', 'end', NULL, $tm_format, TRUE); |
|
407 | 407 | } |
408 | 408 | |
409 | 409 | |
@@ -416,12 +416,12 @@ discard block |
||
416 | 416 | * @param string $conjunction - conjunction junction what's your function ? this string joins the start date with the end date ie: Jan 01 "to" Dec 31 |
417 | 417 | * @return mixed string on success, FALSE on fail |
418 | 418 | */ |
419 | - public function time_range( $tm_format = NULL, $conjunction = ' - ' ) { |
|
420 | - $tm_format = !empty( $tm_format ) ? $tm_format : $this->_tm_frmt; |
|
419 | + public function time_range($tm_format = NULL, $conjunction = ' - ') { |
|
420 | + $tm_format = ! empty($tm_format) ? $tm_format : $this->_tm_frmt; |
|
421 | 421 | |
422 | - $start = str_replace( ' ', ' ', $this->get_i18n_datetime( 'DTT_EVT_start', $tm_format ) ); |
|
423 | - $end = str_replace( ' ', ' ', $this->get_i18n_datetime( 'DTT_EVT_end', $tm_format ) ); |
|
424 | - return $start != $end ? $start . $conjunction . $end : $start; |
|
422 | + $start = str_replace(' ', ' ', $this->get_i18n_datetime('DTT_EVT_start', $tm_format)); |
|
423 | + $end = str_replace(' ', ' ', $this->get_i18n_datetime('DTT_EVT_end', $tm_format)); |
|
424 | + return $start != $end ? $start.$conjunction.$end : $start; |
|
425 | 425 | } |
426 | 426 | |
427 | 427 | |
@@ -430,8 +430,8 @@ discard block |
||
430 | 430 | * @param null $tm_format |
431 | 431 | * @param string $conjunction |
432 | 432 | */ |
433 | - public function e_time_range( $tm_format = NULL, $conjunction = ' - ' ) { |
|
434 | - echo $this->time_range( $tm_format, $conjunction ); |
|
433 | + public function e_time_range($tm_format = NULL, $conjunction = ' - ') { |
|
434 | + echo $this->time_range($tm_format, $conjunction); |
|
435 | 435 | } |
436 | 436 | |
437 | 437 | |
@@ -444,8 +444,8 @@ discard block |
||
444 | 444 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
445 | 445 | * @return mixed string on success, FALSE on fail |
446 | 446 | */ |
447 | - public function start_date_and_time( $dt_format = NULL, $tm_format = NULL ) { |
|
448 | - return $this->_show_datetime( '', 'start', $dt_format, $tm_format ); |
|
447 | + public function start_date_and_time($dt_format = NULL, $tm_format = NULL) { |
|
448 | + return $this->_show_datetime('', 'start', $dt_format, $tm_format); |
|
449 | 449 | } |
450 | 450 | |
451 | 451 | |
@@ -454,8 +454,8 @@ discard block |
||
454 | 454 | * @param null $dt_frmt |
455 | 455 | * @param null $tm_format |
456 | 456 | */ |
457 | - public function e_start_date_and_time( $dt_frmt = NULL, $tm_format = NULL ) { |
|
458 | - $this->_show_datetime( '', 'start', $dt_frmt, $tm_format, TRUE ); |
|
457 | + public function e_start_date_and_time($dt_frmt = NULL, $tm_format = NULL) { |
|
458 | + $this->_show_datetime('', 'start', $dt_frmt, $tm_format, TRUE); |
|
459 | 459 | } |
460 | 460 | |
461 | 461 | |
@@ -469,11 +469,11 @@ discard block |
||
469 | 469 | * @param bool $round_up |
470 | 470 | * @return float|int|mixed |
471 | 471 | */ |
472 | - public function length( $units = 'seconds', $round_up = FALSE ) { |
|
473 | - $start = $this->get_raw( 'DTT_EVT_start' ); |
|
474 | - $end = $this->get_raw( 'DTT_EVT_end' ); |
|
472 | + public function length($units = 'seconds', $round_up = FALSE) { |
|
473 | + $start = $this->get_raw('DTT_EVT_start'); |
|
474 | + $end = $this->get_raw('DTT_EVT_end'); |
|
475 | 475 | $length_in_units = $end - $start; |
476 | - switch ( $units ) { |
|
476 | + switch ($units) { |
|
477 | 477 | //NOTE: We purposefully don't use "break;" in order to chain the divisions |
478 | 478 | /** @noinspection PhpMissingBreakStatementInspection */ |
479 | 479 | case 'days': |
@@ -486,10 +486,10 @@ discard block |
||
486 | 486 | $length_in_units /= 60; |
487 | 487 | case 'seconds': |
488 | 488 | default: |
489 | - $length_in_units = ceil( $length_in_units ); |
|
489 | + $length_in_units = ceil($length_in_units); |
|
490 | 490 | } |
491 | - if ( $round_up ) { |
|
492 | - $length_in_units = max( $length_in_units, 1 ); |
|
491 | + if ($round_up) { |
|
492 | + $length_in_units = max($length_in_units, 1); |
|
493 | 493 | } |
494 | 494 | return $length_in_units; |
495 | 495 | } |
@@ -504,8 +504,8 @@ discard block |
||
504 | 504 | * @param bool | string $tm_format - string representation of time format defaults to 'g:i a' |
505 | 505 | * @return mixed string on success, FALSE on fail |
506 | 506 | */ |
507 | - public function end_date_and_time( $dt_frmt = FALSE, $tm_format = FALSE ) { |
|
508 | - return $this->_show_datetime( '', 'end', $dt_frmt, $tm_format ); |
|
507 | + public function end_date_and_time($dt_frmt = FALSE, $tm_format = FALSE) { |
|
508 | + return $this->_show_datetime('', 'end', $dt_frmt, $tm_format); |
|
509 | 509 | } |
510 | 510 | |
511 | 511 | |
@@ -514,8 +514,8 @@ discard block |
||
514 | 514 | * @param bool $dt_frmt |
515 | 515 | * @param bool $tm_format |
516 | 516 | */ |
517 | - public function e_end_date_and_time( $dt_frmt = FALSE, $tm_format = FALSE ) { |
|
518 | - $this->_show_datetime( '', 'end', $dt_frmt, $tm_format, TRUE ); |
|
517 | + public function e_end_date_and_time($dt_frmt = FALSE, $tm_format = FALSE) { |
|
518 | + $this->_show_datetime('', 'end', $dt_frmt, $tm_format, TRUE); |
|
519 | 519 | } |
520 | 520 | |
521 | 521 | |
@@ -527,7 +527,7 @@ discard block |
||
527 | 527 | * @return int |
528 | 528 | */ |
529 | 529 | public function start() { |
530 | - return $this->get_raw( 'DTT_EVT_start' ); |
|
530 | + return $this->get_raw('DTT_EVT_start'); |
|
531 | 531 | } |
532 | 532 | |
533 | 533 | |
@@ -539,7 +539,7 @@ discard block |
||
539 | 539 | * @return int |
540 | 540 | */ |
541 | 541 | public function end() { |
542 | - return $this->get_raw( 'DTT_EVT_end' ); |
|
542 | + return $this->get_raw('DTT_EVT_end'); |
|
543 | 543 | } |
544 | 544 | |
545 | 545 | |
@@ -551,7 +551,7 @@ discard block |
||
551 | 551 | * @return mixed int on success, FALSE on fail |
552 | 552 | */ |
553 | 553 | public function reg_limit() { |
554 | - return $this->get_raw( 'DTT_reg_limit' ); |
|
554 | + return $this->get_raw('DTT_reg_limit'); |
|
555 | 555 | } |
556 | 556 | |
557 | 557 | |
@@ -563,7 +563,7 @@ discard block |
||
563 | 563 | * @return mixed int on success, FALSE on fail |
564 | 564 | */ |
565 | 565 | public function sold() { |
566 | - return $this->get_raw( 'DTT_sold' ); |
|
566 | + return $this->get_raw('DTT_sold'); |
|
567 | 567 | } |
568 | 568 | |
569 | 569 | |
@@ -592,15 +592,15 @@ discard block |
||
592 | 592 | * the spaces remaining for this particular datetime, hence the flag. |
593 | 593 | * @return int |
594 | 594 | */ |
595 | - public function spaces_remaining( $consider_tickets = FALSE ) { |
|
595 | + public function spaces_remaining($consider_tickets = FALSE) { |
|
596 | 596 | // tickets remaining available for purchase |
597 | 597 | //no need for special checks for infinite, because if DTT_reg_limit == EE_INF, then EE_INF - x = EE_INF |
598 | 598 | $dtt_remaining = $this->reg_limit() - $this->sold(); |
599 | - if ( ! $consider_tickets ) { |
|
599 | + if ( ! $consider_tickets) { |
|
600 | 600 | return $dtt_remaining; |
601 | 601 | } |
602 | 602 | $tickets_remaining = $this->tickets_remaining(); |
603 | - return min( $dtt_remaining, $tickets_remaining ); |
|
603 | + return min($dtt_remaining, $tickets_remaining); |
|
604 | 604 | } |
605 | 605 | |
606 | 606 | |
@@ -611,19 +611,19 @@ discard block |
||
611 | 611 | * @param array $query_params like EEM_Base::get_all's |
612 | 612 | * @return int |
613 | 613 | */ |
614 | - public function tickets_remaining( $query_params = array() ) { |
|
614 | + public function tickets_remaining($query_params = array()) { |
|
615 | 615 | $sum = 0; |
616 | - $tickets = $this->tickets( $query_params ); |
|
617 | - if ( ! empty( $tickets ) ) { |
|
618 | - foreach ( $tickets as $ticket ) { |
|
619 | - if ( $ticket instanceof EE_Ticket ) { |
|
616 | + $tickets = $this->tickets($query_params); |
|
617 | + if ( ! empty($tickets)) { |
|
618 | + foreach ($tickets as $ticket) { |
|
619 | + if ($ticket instanceof EE_Ticket) { |
|
620 | 620 | // get the actual amount of tickets that can be sold |
621 | - $qty = $ticket->qty( 'saleable' ); |
|
622 | - if ( $qty === EE_INF ) { |
|
621 | + $qty = $ticket->qty('saleable'); |
|
622 | + if ($qty === EE_INF) { |
|
623 | 623 | return EE_INF; |
624 | 624 | } |
625 | 625 | // no negative ticket quantities plz |
626 | - if ( $qty > 0 ) { |
|
626 | + if ($qty > 0) { |
|
627 | 627 | $sum += $qty; |
628 | 628 | } |
629 | 629 | } |
@@ -640,8 +640,8 @@ discard block |
||
640 | 640 | * @param array $query_params like EEM_Base::get_all's |
641 | 641 | * @return int |
642 | 642 | */ |
643 | - public function sum_tickets_initially_available( $query_params = array() ) { |
|
644 | - return $this->sum_related( 'Ticket', $query_params, 'TKT_qty' ); |
|
643 | + public function sum_tickets_initially_available($query_params = array()) { |
|
644 | + return $this->sum_related('Ticket', $query_params, 'TKT_qty'); |
|
645 | 645 | } |
646 | 646 | |
647 | 647 | |
@@ -653,7 +653,7 @@ discard block |
||
653 | 653 | * @return int |
654 | 654 | */ |
655 | 655 | public function total_tickets_available_at_this_datetime() { |
656 | - return $this->spaces_remaining( true ); |
|
656 | + return $this->spaces_remaining(true); |
|
657 | 657 | } |
658 | 658 | |
659 | 659 | |
@@ -664,7 +664,7 @@ discard block |
||
664 | 664 | * @return boolean |
665 | 665 | */ |
666 | 666 | public function is_upcoming() { |
667 | - return ( $this->get_raw( 'DTT_EVT_start' ) > time() ); |
|
667 | + return ($this->get_raw('DTT_EVT_start') > time()); |
|
668 | 668 | } |
669 | 669 | |
670 | 670 | |
@@ -674,7 +674,7 @@ discard block |
||
674 | 674 | * @return boolean |
675 | 675 | */ |
676 | 676 | public function is_active() { |
677 | - return ( $this->get_raw( 'DTT_EVT_start' ) < time() && $this->get_raw( 'DTT_EVT_end' ) > time() ); |
|
677 | + return ($this->get_raw('DTT_EVT_start') < time() && $this->get_raw('DTT_EVT_end') > time()); |
|
678 | 678 | } |
679 | 679 | |
680 | 680 | |
@@ -684,7 +684,7 @@ discard block |
||
684 | 684 | * @return boolean |
685 | 685 | */ |
686 | 686 | public function is_expired() { |
687 | - return ( $this->get_raw( 'DTT_EVT_end' ) < time() ); |
|
687 | + return ($this->get_raw('DTT_EVT_end') < time()); |
|
688 | 688 | } |
689 | 689 | |
690 | 690 | |
@@ -695,16 +695,16 @@ discard block |
||
695 | 695 | */ |
696 | 696 | public function get_active_status() { |
697 | 697 | $total_tickets_for_this_dtt = $this->total_tickets_available_at_this_datetime(); |
698 | - if ( $total_tickets_for_this_dtt !== FALSE && $total_tickets_for_this_dtt < 1 ) { |
|
698 | + if ($total_tickets_for_this_dtt !== FALSE && $total_tickets_for_this_dtt < 1) { |
|
699 | 699 | return EE_Datetime::sold_out; |
700 | 700 | } |
701 | - if ( $this->is_expired() ) { |
|
701 | + if ($this->is_expired()) { |
|
702 | 702 | return EE_Datetime::expired; |
703 | 703 | } |
704 | - if ( $this->is_upcoming() ) { |
|
704 | + if ($this->is_upcoming()) { |
|
705 | 705 | return EE_Datetime::upcoming; |
706 | 706 | } |
707 | - if ( $this->is_active() ) { |
|
707 | + if ($this->is_active()) { |
|
708 | 708 | return EE_Datetime::active; |
709 | 709 | } |
710 | 710 | return NULL; |
@@ -718,24 +718,24 @@ discard block |
||
718 | 718 | * @param boolean $use_dtt_name if TRUE then we'll use DTT->name() if its not empty. |
719 | 719 | * @return string |
720 | 720 | */ |
721 | - public function get_dtt_display_name( $use_dtt_name = FALSE ) { |
|
722 | - if ( $use_dtt_name ) { |
|
721 | + public function get_dtt_display_name($use_dtt_name = FALSE) { |
|
722 | + if ($use_dtt_name) { |
|
723 | 723 | $dtt_name = $this->name(); |
724 | - if ( !empty( $dtt_name ) ) { |
|
724 | + if ( ! empty($dtt_name)) { |
|
725 | 725 | return $dtt_name; |
726 | 726 | } |
727 | 727 | } |
728 | 728 | //first condition is to see if the months are different |
729 | - if ( date( 'm', $this->get_raw( 'DTT_EVT_start' ) ) != date( 'm', $this->get_raw( 'DTT_EVT_end' ) ) ) { |
|
730 | - $display_date = $this->start_date( 'M j\, Y g:i a' ) . ' - ' . $this->end_date( 'M j\, Y g:i a' ); |
|
729 | + if (date('m', $this->get_raw('DTT_EVT_start')) != date('m', $this->get_raw('DTT_EVT_end'))) { |
|
730 | + $display_date = $this->start_date('M j\, Y g:i a').' - '.$this->end_date('M j\, Y g:i a'); |
|
731 | 731 | //next condition is if its the same month but different day |
732 | 732 | } |
733 | 733 | else { |
734 | - if ( date( 'm', $this->get_raw( 'DTT_EVT_start' ) ) == date( 'm', $this->get_raw( 'DTT_EVT_end' ) ) && date( 'd', $this->get_raw( 'DTT_EVT_start' ) ) != date( 'd', $this->get_raw( 'DTT_EVT_end' ) ) ) { |
|
735 | - $display_date = $this->start_date( 'M j\, g:i a' ) . ' - ' . $this->end_date( 'M j\, g:i a Y' ); |
|
734 | + if (date('m', $this->get_raw('DTT_EVT_start')) == date('m', $this->get_raw('DTT_EVT_end')) && date('d', $this->get_raw('DTT_EVT_start')) != date('d', $this->get_raw('DTT_EVT_end'))) { |
|
735 | + $display_date = $this->start_date('M j\, g:i a').' - '.$this->end_date('M j\, g:i a Y'); |
|
736 | 736 | } |
737 | 737 | else { |
738 | - $display_date = $this->start_date( 'F j\, Y' ) . ' @ ' . $this->start_date( 'g:i a' ) . ' - ' . $this->end_date( 'g:i a' ); |
|
738 | + $display_date = $this->start_date('F j\, Y').' @ '.$this->start_date('g:i a').' - '.$this->end_date('g:i a'); |
|
739 | 739 | } |
740 | 740 | } |
741 | 741 | return $display_date; |
@@ -749,8 +749,8 @@ discard block |
||
749 | 749 | *@param array $query_params see EEM_Base::get_all() |
750 | 750 | * @return EE_Ticket[] |
751 | 751 | */ |
752 | - public function tickets( $query_params = array() ) { |
|
753 | - return $this->get_many_related( 'Ticket', $query_params ); |
|
752 | + public function tickets($query_params = array()) { |
|
753 | + return $this->get_many_related('Ticket', $query_params); |
|
754 | 754 | } |
755 | 755 | |
756 | 756 | |
@@ -760,21 +760,21 @@ discard block |
||
760 | 760 | * @param array $query_params like EEM_Base::get_all's |
761 | 761 | * @return EE_Ticket[] |
762 | 762 | */ |
763 | - public function ticket_types_available_for_purchase( $query_params = array() ) { |
|
763 | + public function ticket_types_available_for_purchase($query_params = array()) { |
|
764 | 764 | // first check if datetime is valid |
765 | - if ( ! ( $this->is_upcoming() || $this->is_active() ) || $this->sold_out() ) { |
|
765 | + if ( ! ($this->is_upcoming() || $this->is_active()) || $this->sold_out()) { |
|
766 | 766 | return array(); |
767 | 767 | } |
768 | - if ( empty( $query_params ) ) { |
|
768 | + if (empty($query_params)) { |
|
769 | 769 | $query_params = array( |
770 | 770 | array( |
771 | - 'TKT_start_date' => array( '<=', EEM_Ticket::instance()->current_time_for_query( 'TKT_start_date' ) ), |
|
772 | - 'TKT_end_date' => array( '>=', EEM_Ticket::instance()->current_time_for_query( 'TKT_end_date' ) ), |
|
771 | + 'TKT_start_date' => array('<=', EEM_Ticket::instance()->current_time_for_query('TKT_start_date')), |
|
772 | + 'TKT_end_date' => array('>=', EEM_Ticket::instance()->current_time_for_query('TKT_end_date')), |
|
773 | 773 | 'TKT_deleted' => false |
774 | 774 | ) |
775 | 775 | ); |
776 | 776 | } |
777 | - return $this->tickets( $query_params ); |
|
777 | + return $this->tickets($query_params); |
|
778 | 778 | } |
779 | 779 | |
780 | 780 | |
@@ -784,7 +784,7 @@ discard block |
||
784 | 784 | * @return EE_Event |
785 | 785 | */ |
786 | 786 | public function event() { |
787 | - return $this->get_first_related( 'Event' ); |
|
787 | + return $this->get_first_related('Event'); |
|
788 | 788 | } |
789 | 789 | |
790 | 790 | |
@@ -796,13 +796,13 @@ discard block |
||
796 | 796 | */ |
797 | 797 | public function update_sold() { |
798 | 798 | $count_regs_for_this_datetime = EEM_Registration::instance()->count( |
799 | - array( array( |
|
799 | + array(array( |
|
800 | 800 | 'STS_ID' => EEM_Registration::status_id_approved, |
801 | 801 | 'REG_deleted' => 0, |
802 | 802 | 'Ticket.Datetime.DTT_ID' => $this->ID(), |
803 | - ) ) |
|
803 | + )) |
|
804 | 804 | ); |
805 | - $this->set( 'DTT_sold', $count_regs_for_this_datetime ); |
|
805 | + $this->set('DTT_sold', $count_regs_for_this_datetime); |
|
806 | 806 | $this->save(); |
807 | 807 | return $count_regs_for_this_datetime; |
808 | 808 | } |
@@ -276,7 +276,7 @@ discard block |
||
276 | 276 | * @param string $dt_frmt |
277 | 277 | * @param string $tm_frmt |
278 | 278 | * @param bool $echo - whether we echo or return (note echoing uses "pretty" formats, otherwise we use the standard formats) |
279 | - * @return string|bool|void string on success, FALSE on fail |
|
279 | + * @return null|string string on success, FALSE on fail |
|
280 | 280 | */ |
281 | 281 | private function _show_datetime( $date_or_time = NULL, $start_or_end = 'start', $dt_frmt = '', $tm_frmt = '', $echo = FALSE ) { |
282 | 282 | $field_name = "DTT_EVT_{$start_or_end}"; |
@@ -294,8 +294,8 @@ discard block |
||
294 | 294 | * last-used format, or '' to use the default date format |
295 | 295 | * |
296 | 296 | * @access public |
297 | - * @param null $dt_frmt - string representation of date format defaults to 'F j, Y' |
|
298 | - * @return mixed string on success, FALSE on fail |
|
297 | + * @param string $dt_frmt - string representation of date format defaults to 'F j, Y' |
|
298 | + * @return null|string string on success, FALSE on fail |
|
299 | 299 | */ |
300 | 300 | public function start_date( $dt_frmt = NULL ) { |
301 | 301 | return $this->_show_datetime( 'D', 'start', $dt_frmt ); |
@@ -318,8 +318,8 @@ discard block |
||
318 | 318 | * last-used format, or '' to use the default date format |
319 | 319 | * |
320 | 320 | * @access public |
321 | - * @param null $dt_frmt - string representation of date format defaults to 'F j, Y' |
|
322 | - * @return mixed string on success, FALSE on fail |
|
321 | + * @param string $dt_frmt - string representation of date format defaults to 'F j, Y' |
|
322 | + * @return null|string string on success, FALSE on fail |
|
323 | 323 | */ |
324 | 324 | public function end_date( $dt_frmt = NULL ) { |
325 | 325 | return $this->_show_datetime( 'D', 'end', $dt_frmt ); |
@@ -343,7 +343,7 @@ discard block |
||
343 | 343 | * @access public |
344 | 344 | * @param null $dt_frmt - string representation of date format defaults to WP settings |
345 | 345 | * @param string $conjunction - conjunction junction what's your function ? this string joins the start date with the end date ie: Jan 01 "to" Dec 31 |
346 | - * @return mixed string on success, FALSE on fail |
|
346 | + * @return string string on success, FALSE on fail |
|
347 | 347 | */ |
348 | 348 | public function date_range( $dt_frmt = NULL, $conjunction = ' - ' ) { |
349 | 349 | $dt_frmt = ! empty( $dt_frmt ) ? $dt_frmt : $this->_dt_frmt; |
@@ -369,7 +369,7 @@ discard block |
||
369 | 369 | * |
370 | 370 | * @access public |
371 | 371 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
372 | - * @return mixed string on success, FALSE on fail |
|
372 | + * @return null|string string on success, FALSE on fail |
|
373 | 373 | */ |
374 | 374 | public function start_time( $tm_format = NULL ) { |
375 | 375 | return $this->_show_datetime( 'T', 'start', NULL, $tm_format ); |
@@ -391,7 +391,7 @@ discard block |
||
391 | 391 | * |
392 | 392 | * @access public |
393 | 393 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
394 | - * @return mixed string on success, FALSE on fail |
|
394 | + * @return null|string string on success, FALSE on fail |
|
395 | 395 | */ |
396 | 396 | public function end_time( $tm_format = NULL ) { |
397 | 397 | return $this->_show_datetime( 'T', 'end', NULL, $tm_format ); |
@@ -414,7 +414,7 @@ discard block |
||
414 | 414 | * @access public |
415 | 415 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
416 | 416 | * @param string $conjunction - conjunction junction what's your function ? this string joins the start date with the end date ie: Jan 01 "to" Dec 31 |
417 | - * @return mixed string on success, FALSE on fail |
|
417 | + * @return string string on success, FALSE on fail |
|
418 | 418 | */ |
419 | 419 | public function time_range( $tm_format = NULL, $conjunction = ' - ' ) { |
420 | 420 | $tm_format = !empty( $tm_format ) ? $tm_format : $this->_tm_frmt; |
@@ -442,7 +442,7 @@ discard block |
||
442 | 442 | * @access public |
443 | 443 | * @param string $dt_format - string representation of date format defaults to 'F j, Y' |
444 | 444 | * @param string $tm_format - string representation of time format defaults to 'g:i a' |
445 | - * @return mixed string on success, FALSE on fail |
|
445 | + * @return null|string string on success, FALSE on fail |
|
446 | 446 | */ |
447 | 447 | public function start_date_and_time( $dt_format = NULL, $tm_format = NULL ) { |
448 | 448 | return $this->_show_datetime( '', 'start', $dt_format, $tm_format ); |
@@ -502,7 +502,7 @@ discard block |
||
502 | 502 | * @access public |
503 | 503 | * @param bool | string $dt_frmt- string representation of date format defaults to 'F j, Y' |
504 | 504 | * @param bool | string $tm_format - string representation of time format defaults to 'g:i a' |
505 | - * @return mixed string on success, FALSE on fail |
|
505 | + * @return null|string string on success, FALSE on fail |
|
506 | 506 | */ |
507 | 507 | public function end_date_and_time( $dt_frmt = FALSE, $tm_format = FALSE ) { |
508 | 508 | return $this->_show_datetime( '', 'end', $dt_frmt, $tm_format ); |
@@ -22,9 +22,9 @@ discard block |
||
22 | 22 | * @param null $timezone |
23 | 23 | * @return EE_Event_Message_Template|mixed |
24 | 24 | */ |
25 | - public static function new_instance( $props_n_values = array(), $timezone = NULL ) { |
|
26 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone ); |
|
27 | - return $has_object ? $has_object : new self( $props_n_values, FALSE, $timezone ); |
|
25 | + public static function new_instance($props_n_values = array(), $timezone = NULL) { |
|
26 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone); |
|
27 | + return $has_object ? $has_object : new self($props_n_values, FALSE, $timezone); |
|
28 | 28 | } |
29 | 29 | |
30 | 30 | |
@@ -34,8 +34,8 @@ discard block |
||
34 | 34 | * @param null $timezone |
35 | 35 | * @return EE_Event_Message_Template |
36 | 36 | */ |
37 | - public static function new_instance_from_db ( $props_n_values = array(), $timezone = NULL ) { |
|
38 | - return new self( $props_n_values, TRUE, $timezone ); |
|
37 | + public static function new_instance_from_db($props_n_values = array(), $timezone = NULL) { |
|
38 | + return new self($props_n_values, TRUE, $timezone); |
|
39 | 39 | } |
40 | 40 | |
41 | 41 | } |
@@ -1,4 +1,6 @@ |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * Contains definition for EE_Event_Message_Template model object |
4 | 6 | * @package Event Espresso |