Completed
Branch FET/extra-logging-when-trashin... (b6e112)
by
unknown
36:04 queued 27:41
created
4_6_0_stages/EE_DMS_4_6_0_state_system_question.dmsstage.php 2 patches
Indentation   +41 added lines, -41 removed lines patch added patch discarded remove patch
@@ -14,48 +14,48 @@
 block discarded – undo
14 14
 
15 15
 
16 16
 
17
-    /**
18
-     * Just initializes the status of the migration
19
-     *
20
-     * @return EE_DMS_4_6_0_state_system_question
21
-     */
22
-    public function __construct()
23
-    {
24
-        global $wpdb;
25
-        $this->_pretty_name = __('State - System Question', 'event_espresso');
26
-        $this->_old_table = $wpdb->prefix.'esp_question';
27
-        $this->_extra_where_sql = "WHERE QST_system = 'state'";
28
-        parent::__construct();
29
-    }
17
+	/**
18
+	 * Just initializes the status of the migration
19
+	 *
20
+	 * @return EE_DMS_4_6_0_state_system_question
21
+	 */
22
+	public function __construct()
23
+	{
24
+		global $wpdb;
25
+		$this->_pretty_name = __('State - System Question', 'event_espresso');
26
+		$this->_old_table = $wpdb->prefix.'esp_question';
27
+		$this->_extra_where_sql = "WHERE QST_system = 'state'";
28
+		parent::__construct();
29
+	}
30 30
 
31 31
 
32 32
 
33
-    /**
34
-     * updates the question with the new question type
35
-     * @param array $question an associative array where keys are column names and values are their values.
36
-     * @return null
37
-     */
38
-    protected function _migrate_old_row($question)
39
-    {
40
-        if ($question['QST_ID'] && $question['QST_system'] == 'state') {
41
-            global $wpdb;
42
-            $success = $wpdb->update(
43
-                $this->_old_table,
44
-                array( 'QST_type' => 'STATE' ),  // data
45
-                array( 'QST_ID' => $question['QST_ID'] ),  // where
46
-                array( '%s' ),   // data format
47
-                array( '%d' )  // where format
48
-            );
49
-            if (! $success) {
50
-                $this->add_error(
51
-                    sprintf(
52
-                        __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'),
53
-                        wp_json_encode($question['QST_system']),
54
-                        $question['QST_ID'],
55
-                        $wpdb->last_error
56
-                    )
57
-                );
58
-            }
59
-        }
60
-    }
33
+	/**
34
+	 * updates the question with the new question type
35
+	 * @param array $question an associative array where keys are column names and values are their values.
36
+	 * @return null
37
+	 */
38
+	protected function _migrate_old_row($question)
39
+	{
40
+		if ($question['QST_ID'] && $question['QST_system'] == 'state') {
41
+			global $wpdb;
42
+			$success = $wpdb->update(
43
+				$this->_old_table,
44
+				array( 'QST_type' => 'STATE' ),  // data
45
+				array( 'QST_ID' => $question['QST_ID'] ),  // where
46
+				array( '%s' ),   // data format
47
+				array( '%d' )  // where format
48
+			);
49
+			if (! $success) {
50
+				$this->add_error(
51
+					sprintf(
52
+						__('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'),
53
+						wp_json_encode($question['QST_system']),
54
+						$question['QST_ID'],
55
+						$wpdb->last_error
56
+					)
57
+				);
58
+			}
59
+		}
60
+	}
61 61
 }
Please login to merge, or discard this patch.
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -41,12 +41,12 @@
 block discarded – undo
41 41
             global $wpdb;
42 42
             $success = $wpdb->update(
43 43
                 $this->_old_table,
44
-                array( 'QST_type' => 'STATE' ),  // data
45
-                array( 'QST_ID' => $question['QST_ID'] ),  // where
46
-                array( '%s' ),   // data format
47
-                array( '%d' )  // where format
44
+                array('QST_type' => 'STATE'), // data
45
+                array('QST_ID' => $question['QST_ID']), // where
46
+                array('%s'), // data format
47
+                array('%d')  // where format
48 48
             );
49
-            if (! $success) {
49
+            if ( ! $success) {
50 50
                 $this->add_error(
51 51
                     sprintf(
52 52
                         __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'),
Please login to merge, or discard this patch.
4_6_0_stages/EE_DMS_4_6_0_invoice_settings.dmsstage.php 2 patches
Indentation   +47 added lines, -47 removed lines patch added patch discarded remove patch
@@ -28,59 +28,59 @@
 block discarded – undo
28 28
 class EE_DMS_4_6_0_invoice_settings extends EE_Data_Migration_Script_Stage
29 29
 {
30 30
 
31
-    /**
32
-     * Just initializes the status of the migration
33
-     */
34
-    public function __construct()
35
-    {
36
-        $this->_pretty_name = __('Update Invoice Settings', 'event_espresso');
37
-        parent::__construct();
38
-    }
31
+	/**
32
+	 * Just initializes the status of the migration
33
+	 */
34
+	public function __construct()
35
+	{
36
+		$this->_pretty_name = __('Update Invoice Settings', 'event_espresso');
37
+		parent::__construct();
38
+	}
39 39
 
40 40
 
41 41
 
42
-    /**
43
-     * _count_records_to_migrate
44
-     * Counts the records to migrate; the public version may cache it
45
-     *
46
-     * @access protected
47
-     * @return int
48
-     */
49
-    protected function _count_records_to_migrate()
50
-    {
51
-        return 1;
52
-    }
42
+	/**
43
+	 * _count_records_to_migrate
44
+	 * Counts the records to migrate; the public version may cache it
45
+	 *
46
+	 * @access protected
47
+	 * @return int
48
+	 */
49
+	protected function _count_records_to_migrate()
50
+	{
51
+		return 1;
52
+	}
53 53
 
54 54
 
55 55
 
56
-    /**
57
-     *    _migration_step
58
-     *
59
-     * @access protected
60
-     * @param int $num_items
61
-     * @throws EE_Error
62
-     * @return int number of items ACTUALLY migrated
63
-     * @throws InvalidDataTypeException
64
-     */
65
-    protected function _migration_step($num_items = 1)
66
-    {
56
+	/**
57
+	 *    _migration_step
58
+	 *
59
+	 * @access protected
60
+	 * @param int $num_items
61
+	 * @throws EE_Error
62
+	 * @return int number of items ACTUALLY migrated
63
+	 * @throws InvalidDataTypeException
64
+	 */
65
+	protected function _migration_step($num_items = 1)
66
+	{
67 67
 
68
-        $templates_relative_path = 'modules/gateways/Invoice/lib/templates/';
69
-        $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true);
70
-        $overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true);
71
-        if ($overridden_invoice_body || $overridden_receipt_body) {
72
-            new PersistentAdminNotice(
73
-                'invoice_overriding_templates',
74
-                esc_html__(
75
-                    'Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overridden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.',
76
-                    'event_espresso'
77
-                ),
78
-                true
79
-            );
80
-        }
68
+		$templates_relative_path = 'modules/gateways/Invoice/lib/templates/';
69
+		$overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true);
70
+		$overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true);
71
+		if ($overridden_invoice_body || $overridden_receipt_body) {
72
+			new PersistentAdminNotice(
73
+				'invoice_overriding_templates',
74
+				esc_html__(
75
+					'Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overridden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.',
76
+					'event_espresso'
77
+				),
78
+				true
79
+			);
80
+		}
81 81
 
82
-        // regardless of whether it worked or not, we ought to continue the migration
83
-        $this->set_completed();
84
-        return 1;
85
-    }
82
+		// regardless of whether it worked or not, we ought to continue the migration
83
+		$this->set_completed();
84
+		return 1;
85
+	}
86 86
 }
Please login to merge, or discard this patch.
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -66,8 +66,8 @@
 block discarded – undo
66 66
     {
67 67
 
68 68
         $templates_relative_path = 'modules/gateways/Invoice/lib/templates/';
69
-        $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true);
70
-        $overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true);
69
+        $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path.'invoice_body.template.php', null, false, false, true);
70
+        $overridden_receipt_body = EEH_Template::locate_template($templates_relative_path.'receipt_body.template.php', null, false, false, true);
71 71
         if ($overridden_invoice_body || $overridden_receipt_body) {
72 72
             new PersistentAdminNotice(
73 73
                 'invoice_overriding_templates',
Please login to merge, or discard this patch.
data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_billing_info.dmsstage.php 2 patches
Indentation   +64 added lines, -64 removed lines patch added patch discarded remove patch
@@ -11,69 +11,69 @@
 block discarded – undo
11 11
  */
12 12
 class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table
13 13
 {
14
-    public function __construct()
15
-    {
16
-        global $wpdb;
17
-        $this->_old_table = $wpdb->postmeta;
18
-        $this->_pretty_name = __('Billing Info', 'event_espresso');
19
-        $this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'";
20
-        parent::__construct();
21
-    }
22
-    protected function _migrate_old_row($old_row)
23
-    {
24
-        $new_billing_info = array();
25
-        $old_billing_info = maybe_unserialize($old_row['meta_value']);
26
-        $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']);
27
-        $repetitive_prefix = '_reg-page-billing-';
28
-        $repetitive_suffix = "-" . $gateway_name;
29
-        foreach ($old_billing_info as $old_input_name => $input_value) {
30
-            $old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name);
14
+	public function __construct()
15
+	{
16
+		global $wpdb;
17
+		$this->_old_table = $wpdb->postmeta;
18
+		$this->_pretty_name = __('Billing Info', 'event_espresso');
19
+		$this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'";
20
+		parent::__construct();
21
+	}
22
+	protected function _migrate_old_row($old_row)
23
+	{
24
+		$new_billing_info = array();
25
+		$old_billing_info = maybe_unserialize($old_row['meta_value']);
26
+		$gateway_name = str_replace("billing_info_", '', $old_row['meta_key']);
27
+		$repetitive_prefix = '_reg-page-billing-';
28
+		$repetitive_suffix = "-" . $gateway_name;
29
+		foreach ($old_billing_info as $old_input_name => $input_value) {
30
+			$old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name);
31 31
 
32
-            switch ($old_input_name_important_part) {
33
-                case 'fname':
34
-                    $new_input_name = 'first_name';
35
-                    break;
36
-                case 'lname':
37
-                    $new_input_name = 'last_name';
38
-                    break;
39
-                case 'state':
40
-                    // we used to store the state's id ,but now we just store the name
41
-                    $new_input_name = $old_input_name_important_part;
42
-                    $input_value = $this->_get_state_name_by_ID($input_value);
43
-                    break;
44
-                case 'card-nmbr':
45
-                    $new_input_name = 'credit_card';
46
-                    break;
47
-                case 'card-type':// paypal pro only
48
-                    $new_input_name = 'credit_card_type';
49
-                    break;
50
-                case 'card-exp-date-mnth':
51
-                    $new_input_name = 'exp_month';
52
-                    $input_value = '';
53
-                    break;
54
-                case 'card-exp-date-year':
55
-                    $new_input_name = 'exp_year';
56
-                    $input_value = 0;
57
-                    break;
58
-                case 'ccv-code':
59
-                    $new_input_name = 'cvv';
60
-                    break;
61
-                default:
62
-                    $new_input_name = $old_input_name_important_part;
63
-            }
64
-            $new_billing_info[ $new_input_name ] = $input_value;
65
-        }
66
-        update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info);
67
-    }
68
-    /**
69
-     *
70
-     * @global type $wpdb
71
-     * @param int $id
72
-     * @return string
73
-     */
74
-    protected function _get_state_name_by_ID($id)
75
-    {
76
-        global $wpdb;
77
-        return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id));
78
-    }
32
+			switch ($old_input_name_important_part) {
33
+				case 'fname':
34
+					$new_input_name = 'first_name';
35
+					break;
36
+				case 'lname':
37
+					$new_input_name = 'last_name';
38
+					break;
39
+				case 'state':
40
+					// we used to store the state's id ,but now we just store the name
41
+					$new_input_name = $old_input_name_important_part;
42
+					$input_value = $this->_get_state_name_by_ID($input_value);
43
+					break;
44
+				case 'card-nmbr':
45
+					$new_input_name = 'credit_card';
46
+					break;
47
+				case 'card-type':// paypal pro only
48
+					$new_input_name = 'credit_card_type';
49
+					break;
50
+				case 'card-exp-date-mnth':
51
+					$new_input_name = 'exp_month';
52
+					$input_value = '';
53
+					break;
54
+				case 'card-exp-date-year':
55
+					$new_input_name = 'exp_year';
56
+					$input_value = 0;
57
+					break;
58
+				case 'ccv-code':
59
+					$new_input_name = 'cvv';
60
+					break;
61
+				default:
62
+					$new_input_name = $old_input_name_important_part;
63
+			}
64
+			$new_billing_info[ $new_input_name ] = $input_value;
65
+		}
66
+		update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info);
67
+	}
68
+	/**
69
+	 *
70
+	 * @global type $wpdb
71
+	 * @param int $id
72
+	 * @return string
73
+	 */
74
+	protected function _get_state_name_by_ID($id)
75
+	{
76
+		global $wpdb;
77
+		return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id));
78
+	}
79 79
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -25,9 +25,9 @@  discard block
 block discarded – undo
25 25
         $old_billing_info = maybe_unserialize($old_row['meta_value']);
26 26
         $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']);
27 27
         $repetitive_prefix = '_reg-page-billing-';
28
-        $repetitive_suffix = "-" . $gateway_name;
28
+        $repetitive_suffix = "-".$gateway_name;
29 29
         foreach ($old_billing_info as $old_input_name => $input_value) {
30
-            $old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name);
30
+            $old_input_name_important_part = str_replace(array($repetitive_prefix, $repetitive_suffix), array('', ''), $old_input_name);
31 31
 
32 32
             switch ($old_input_name_important_part) {
33 33
                 case 'fname':
@@ -61,7 +61,7 @@  discard block
 block discarded – undo
61 61
                 default:
62 62
                     $new_input_name = $old_input_name_important_part;
63 63
             }
64
-            $new_billing_info[ $new_input_name ] = $input_value;
64
+            $new_billing_info[$new_input_name] = $input_value;
65 65
         }
66 66
         update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info);
67 67
     }
@@ -74,6 +74,6 @@  discard block
 block discarded – undo
74 74
     protected function _get_state_name_by_ID($id)
75 75
     {
76 76
         global $wpdb;
77
-        return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id));
77
+        return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM ".$wpdb->prefix."esp_state WHERE STA_ID = %d", $id));
78 78
     }
79 79
 }
Please login to merge, or discard this patch.
4_6_0_stages/EE_DMS_4_6_0_question_types.dmsstage.php 2 patches
Indentation   +49 added lines, -49 removed lines patch added patch discarded remove patch
@@ -12,57 +12,57 @@
 block discarded – undo
12 12
 class EE_DMS_4_6_0_question_types extends EE_Data_Migration_Script_Stage_Table
13 13
 {
14 14
 
15
-    protected $_question_type_conversions = array();
15
+	protected $_question_type_conversions = array();
16 16
 
17 17
 
18 18
 
19
-    /**
20
-     * Just initializes the status of the migration
21
-     *
22
-     * @return EE_DMS_4_6_0_question_types
23
-     */
24
-    public function __construct()
25
-    {
26
-        global $wpdb;
27
-        $this->_pretty_name = __('Question Types', 'event_espresso');
28
-        $this->_old_table = $wpdb->prefix.'esp_question';
29
-        $this->_question_type_conversions = array(
30
-            'MULTIPLE'          => 'CHECKBOX',
31
-            'SINGLE'                => 'RADIO_BTN'
32
-        );
33
-        // when fetching rows, because we automatically use a limit and offset
34
-        // rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted
35
-        // so we need to include both the migrated rows as well as the non-migrated rows
36
-        $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions);
37
-        $this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ;
38
-        parent::__construct();
39
-    }
19
+	/**
20
+	 * Just initializes the status of the migration
21
+	 *
22
+	 * @return EE_DMS_4_6_0_question_types
23
+	 */
24
+	public function __construct()
25
+	{
26
+		global $wpdb;
27
+		$this->_pretty_name = __('Question Types', 'event_espresso');
28
+		$this->_old_table = $wpdb->prefix.'esp_question';
29
+		$this->_question_type_conversions = array(
30
+			'MULTIPLE'          => 'CHECKBOX',
31
+			'SINGLE'                => 'RADIO_BTN'
32
+		);
33
+		// when fetching rows, because we automatically use a limit and offset
34
+		// rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted
35
+		// so we need to include both the migrated rows as well as the non-migrated rows
36
+		$QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions);
37
+		$this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ;
38
+		parent::__construct();
39
+	}
40 40
 
41
-    /**
42
-     * @param array $question an associative array where keys are column names and values are their values.
43
-     * @return null
44
-     */
45
-    protected function _migrate_old_row($question)
46
-    {
47
-        global $wpdb;
48
-        if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) {
49
-            $success = $wpdb->update(
50
-                $this->_old_table,
51
-                array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ),  // data
52
-                array( 'QST_ID' => $question['QST_ID'] ),  // where
53
-                array( '%s' ),   // data format
54
-                array( '%d' )  // where format
55
-            );
56
-            if (! $success) {
57
-                $this->add_error(
58
-                    sprintf(
59
-                        __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'),
60
-                        wp_json_encode($question['QST_type']),
61
-                        $question['QST_ID'],
62
-                        $wpdb->last_error
63
-                    )
64
-                );
65
-            }
66
-        }
67
-    }
41
+	/**
42
+	 * @param array $question an associative array where keys are column names and values are their values.
43
+	 * @return null
44
+	 */
45
+	protected function _migrate_old_row($question)
46
+	{
47
+		global $wpdb;
48
+		if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) {
49
+			$success = $wpdb->update(
50
+				$this->_old_table,
51
+				array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ),  // data
52
+				array( 'QST_ID' => $question['QST_ID'] ),  // where
53
+				array( '%s' ),   // data format
54
+				array( '%d' )  // where format
55
+			);
56
+			if (! $success) {
57
+				$this->add_error(
58
+					sprintf(
59
+						__('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'),
60
+						wp_json_encode($question['QST_type']),
61
+						$question['QST_ID'],
62
+						$wpdb->last_error
63
+					)
64
+				);
65
+			}
66
+		}
67
+	}
68 68
 }
Please login to merge, or discard this patch.
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
         // rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted
35 35
         // so we need to include both the migrated rows as well as the non-migrated rows
36 36
         $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions);
37
-        $this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ;
37
+        $this->_extra_where_sql = "WHERE QST_type IN ('".implode("', '", $QST_types_to_count)."')";
38 38
         parent::__construct();
39 39
     }
40 40
 
@@ -45,15 +45,15 @@  discard block
 block discarded – undo
45 45
     protected function _migrate_old_row($question)
46 46
     {
47 47
         global $wpdb;
48
-        if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) {
48
+        if ($question['QST_ID'] && isset($this->_question_type_conversions[$question['QST_type']])) {
49 49
             $success = $wpdb->update(
50 50
                 $this->_old_table,
51
-                array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ),  // data
52
-                array( 'QST_ID' => $question['QST_ID'] ),  // where
53
-                array( '%s' ),   // data format
54
-                array( '%d' )  // where format
51
+                array('QST_type' => $this->_question_type_conversions[$question['QST_type']]), // data
52
+                array('QST_ID' => $question['QST_ID']), // where
53
+                array('%s'), // data format
54
+                array('%d')  // where format
55 55
             );
56
-            if (! $success) {
56
+            if ( ! $success) {
57 57
                 $this->add_error(
58 58
                     sprintf(
59 59
                         __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'),
Please login to merge, or discard this patch.
core/data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_gateways.dmsstage.php 2 patches
Indentation   +256 added lines, -256 removed lines patch added patch discarded remove patch
@@ -14,277 +14,277 @@
 block discarded – undo
14 14
 class EE_DMS_4_6_0_gateways extends EE_Data_Migration_Script_Stage
15 15
 {
16 16
 
17
-    protected $_new_table_name;
18
-    protected $_extra_meta_table_name;
19
-    protected $_currency_table_name;
20
-    protected $_currency_payment_method_table_name;
17
+	protected $_new_table_name;
18
+	protected $_extra_meta_table_name;
19
+	protected $_currency_table_name;
20
+	protected $_currency_payment_method_table_name;
21 21
 
22
-    /**
23
-     * each key is the name of a 4.1-style gateway we know how to migrate to 4.6
24
-     * @var array
25
-     */
26
-    protected $_gateway_we_know_to_migrate = array(
27
-        'Aim',
28
-        'Bank',
29
-        'Check',
30
-        'Invoice',
31
-        'Mijireh',
32
-        'Paypal_Pro',
33
-        'Paypal_Standard',
34
-    );
22
+	/**
23
+	 * each key is the name of a 4.1-style gateway we know how to migrate to 4.6
24
+	 * @var array
25
+	 */
26
+	protected $_gateway_we_know_to_migrate = array(
27
+		'Aim',
28
+		'Bank',
29
+		'Check',
30
+		'Invoice',
31
+		'Mijireh',
32
+		'Paypal_Pro',
33
+		'Paypal_Standard',
34
+	);
35 35
 
36 36
 
37 37
 
38
-    /**
39
-     * Just initializes the status of the migration
40
-     */
41
-    public function __construct()
42
-    {
43
-        global $wpdb;
44
-        $this->_new_table_name = $wpdb->prefix."esp_payment_method";
45
-        $this->_extra_meta_table_name = $wpdb->prefix."esp_extra_meta";
46
-        $this->_currency_table_name = $wpdb->prefix."esp_currency";
47
-        $this->_currency_payment_method_table_name = $wpdb->prefix."esp_currency_payment_method";
48
-        $this->_pretty_name = __('Gateways', 'event_espresso');
49
-        parent::__construct();
50
-    }
38
+	/**
39
+	 * Just initializes the status of the migration
40
+	 */
41
+	public function __construct()
42
+	{
43
+		global $wpdb;
44
+		$this->_new_table_name = $wpdb->prefix."esp_payment_method";
45
+		$this->_extra_meta_table_name = $wpdb->prefix."esp_extra_meta";
46
+		$this->_currency_table_name = $wpdb->prefix."esp_currency";
47
+		$this->_currency_payment_method_table_name = $wpdb->prefix."esp_currency_payment_method";
48
+		$this->_pretty_name = __('Gateways', 'event_espresso');
49
+		parent::__construct();
50
+	}
51 51
 
52 52
 
53 53
 
54
-    /**
55
-     * Counts the records to migrate; the public version may cache it
56
-     * @return int
57
-     */
58
-    protected function _count_records_to_migrate()
59
-    {
60
-        return count(EE_Config::instance()->gateway->payment_settings);
61
-    }
54
+	/**
55
+	 * Counts the records to migrate; the public version may cache it
56
+	 * @return int
57
+	 */
58
+	protected function _count_records_to_migrate()
59
+	{
60
+		return count(EE_Config::instance()->gateway->payment_settings);
61
+	}
62 62
 
63 63
 
64 64
 
65
-    /**
66
-     * IMPORTANT: if an error is encountered, or everything is finished, this stage should update its status property accordingly.
67
-     * Note: it should not alter the count of items migrated. That is done in the public function that calls this.
68
-     * IMPORTANT: The count of items migrated should ONLY be less than $num_items_to_migrate when it's the last migration step, otherwise it
69
-     * should always return $num_items_to_migrate. (Eg, if we're migrating attendees rows from the database, and $num_items_to_migrate is set to 50,
70
-     * then we SHOULD actually migrate 50 rows,but at very least we MUST report/return 50 items migrated)
71
-     * @param int $num_items_to_migrate
72
-     * @return int number of items ACTUALLY migrated
73
-     */
74
-    protected function _migration_step($num_items_to_migrate = 50)
75
-    {
76
-        $items_actually_migrated = 0;
77
-        $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings, $this->count_records_migrated(), $num_items_to_migrate);
78
-        foreach ($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings) {
79
-            if (in_array($old_gateway_slug, $this->_gateway_we_know_to_migrate)) {
80
-                if (! $old_gateway_settings) {
81
-                    // no settings existed for this gateway anyways... weird...
82
-                    $items_actually_migrated++;
83
-                    continue;
84
-                }
85
-                // now prepare the settings to make sure they're in the 4.1 format
86
-                $success = $this->_convert_gateway_settings(
87
-                    $old_gateway_slug,
88
-                    $old_gateway_settings,
89
-                    isset(EE_Config::instance()->gateway->active_gateways[ $old_gateway_slug ])
90
-                );
91
-                if ($success) {
92
-                    EE_Config::instance()->gateway->payment_settings[ $old_gateway_slug ] = 'Deprecated';
93
-                }
94
-            }
95
-            $items_actually_migrated++;
96
-        }
65
+	/**
66
+	 * IMPORTANT: if an error is encountered, or everything is finished, this stage should update its status property accordingly.
67
+	 * Note: it should not alter the count of items migrated. That is done in the public function that calls this.
68
+	 * IMPORTANT: The count of items migrated should ONLY be less than $num_items_to_migrate when it's the last migration step, otherwise it
69
+	 * should always return $num_items_to_migrate. (Eg, if we're migrating attendees rows from the database, and $num_items_to_migrate is set to 50,
70
+	 * then we SHOULD actually migrate 50 rows,but at very least we MUST report/return 50 items migrated)
71
+	 * @param int $num_items_to_migrate
72
+	 * @return int number of items ACTUALLY migrated
73
+	 */
74
+	protected function _migration_step($num_items_to_migrate = 50)
75
+	{
76
+		$items_actually_migrated = 0;
77
+		$gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings, $this->count_records_migrated(), $num_items_to_migrate);
78
+		foreach ($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings) {
79
+			if (in_array($old_gateway_slug, $this->_gateway_we_know_to_migrate)) {
80
+				if (! $old_gateway_settings) {
81
+					// no settings existed for this gateway anyways... weird...
82
+					$items_actually_migrated++;
83
+					continue;
84
+				}
85
+				// now prepare the settings to make sure they're in the 4.1 format
86
+				$success = $this->_convert_gateway_settings(
87
+					$old_gateway_slug,
88
+					$old_gateway_settings,
89
+					isset(EE_Config::instance()->gateway->active_gateways[ $old_gateway_slug ])
90
+				);
91
+				if ($success) {
92
+					EE_Config::instance()->gateway->payment_settings[ $old_gateway_slug ] = 'Deprecated';
93
+				}
94
+			}
95
+			$items_actually_migrated++;
96
+		}
97 97
 
98
-        EE_Config::instance()->update_espresso_config(false, false);
99
-        if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
100
-            $this->set_completed();
101
-        }
102
-        return $items_actually_migrated;
103
-    }
98
+		EE_Config::instance()->update_espresso_config(false, false);
99
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
100
+			$this->set_completed();
101
+		}
102
+		return $items_actually_migrated;
103
+	}
104 104
 
105
-    /**
106
-     * Converts the 4.1-style gateway to a 4.6-style payment method and saves it to the DB
107
-     * @param string $old_gateway_slug
108
-     * @param array $old_gateway_settings
109
-     * @param boolean $active indicates the gateway is currently active
110
-     * @return boolean success
111
-     */
112
-    protected function _convert_gateway_settings($old_gateway_slug, $old_gateway_settings, $active)
113
-    {
114
-        switch ($old_gateway_slug) {
115
-            case 'Aim':
116
-                $extra_meta_key_values = array(
117
-                    'login_id'=>$old_gateway_settings['authnet_aim_login_id'],
118
-                    'transaction_key'=>$old_gateway_settings['authnet_aim_transaction_key'],
119
-                    'test_transactions'=>$old_gateway_settings['test_transactions']
120
-                );
121
-                $desc = __('Please provide the following billing information.', 'event_espresso');
122
-                break;
123
-            case 'Bank':
124
-                $extra_meta_key_values = array(
125
-                    'page_title'=>$old_gateway_settings['page_title'],
126
-                    'payment_instructions'=>
127
-                    sprintf(__('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'], $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address']) );
128
-                $desc = __('Make payment using an electronic funds transfer from your bank.', 'event_espresso');
129
-                break;
130
-            case 'Check':
131
-                $extra_meta_key_values = array(
132
-                    'check_title'=> $old_gateway_settings['check_title'],
133
-                    'payment_instructions'=>$old_gateway_settings['check_instructions'],
134
-                    'address_to_send_payment'=>$old_gateway_settings['payment_address']
135
-                );
136
-                $desc = __('On the next page you will be given instructions on how to make a payment by check.', 'event_espresso');
137
-                break;
138
-            case 'Invoice':
139
-                $extra_meta_key_values = array(
140
-                    'pdf_payee_name' => $old_gateway_settings['template_invoice_payee_name'],
141
-                    'pdf_payee_email' => $old_gateway_settings['template_invoice_email'],
142
-                    'pdf_payee_tax_number' => $old_gateway_settings['template_invoice_tax_number'],
143
-                    'pdf_payee_address' => $old_gateway_settings['template_invoice_address'],
144
-                    'pdf_instructions' => $old_gateway_settings['template_payment_instructions'],
145
-                    'pdf_logo_image' => $old_gateway_settings['invoice_logo_url'],
146
-                    'page_confirmation_text' => isset($old_gateway_settings['page_instructions']) ? $old_gateway_settings['page_instructions'] : '',
147
-                    'page_extra_info' => isset($old_gateway_settings['payment_address']) ? $old_gateway_settings['payment_address'] : '',
148
-                    'legacy_invoice_css' => $old_gateway_settings['invoice_css']
149
-                );
150
-                // if they didnt want the invoiec gateway to show, pretend it was inactive
151
-                if (! $old_gateway_settings['show']) {
152
-                    $active = false;
153
-                }
154
-                $desc = __('On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso');
155
-                break;
156
-            case 'Mijireh':
157
-                $extra_meta_key_values = array(
158
-                    'access_key' => $old_gateway_settings['access_key']
159
-                );
160
-                $desc =  __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso');
161
-                break;
162
-            case 'Paypal_Pro':
163
-                $extra_meta_key_values = array(
164
-                    'username'=>$old_gateway_settings['username'],
165
-                    'password'=>$old_gateway_settings['password'],
166
-                    'signature'=>$old_gateway_settings['signature'],
167
-                    'credit_card_types'=>$old_gateway_settings['credit_cards'],
168
-                );
169
-                $desc = __('Please provide the following billing information.', 'event_espresso');
170
-                break;
171
-            case 'Paypal_Standard':
172
-                $extra_meta_key_values = array(
173
-                    'paypal_id' => $old_gateway_settings['paypal_id'],
174
-                    'image_url' => $old_gateway_settings['image_url'],
175
-                    'shipping_details' => isset($old_gateway_settings['no_shipping']) ? $old_gateway_settings['no_shipping'] : false,
105
+	/**
106
+	 * Converts the 4.1-style gateway to a 4.6-style payment method and saves it to the DB
107
+	 * @param string $old_gateway_slug
108
+	 * @param array $old_gateway_settings
109
+	 * @param boolean $active indicates the gateway is currently active
110
+	 * @return boolean success
111
+	 */
112
+	protected function _convert_gateway_settings($old_gateway_slug, $old_gateway_settings, $active)
113
+	{
114
+		switch ($old_gateway_slug) {
115
+			case 'Aim':
116
+				$extra_meta_key_values = array(
117
+					'login_id'=>$old_gateway_settings['authnet_aim_login_id'],
118
+					'transaction_key'=>$old_gateway_settings['authnet_aim_transaction_key'],
119
+					'test_transactions'=>$old_gateway_settings['test_transactions']
120
+				);
121
+				$desc = __('Please provide the following billing information.', 'event_espresso');
122
+				break;
123
+			case 'Bank':
124
+				$extra_meta_key_values = array(
125
+					'page_title'=>$old_gateway_settings['page_title'],
126
+					'payment_instructions'=>
127
+					sprintf(__('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'], $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address']) );
128
+				$desc = __('Make payment using an electronic funds transfer from your bank.', 'event_espresso');
129
+				break;
130
+			case 'Check':
131
+				$extra_meta_key_values = array(
132
+					'check_title'=> $old_gateway_settings['check_title'],
133
+					'payment_instructions'=>$old_gateway_settings['check_instructions'],
134
+					'address_to_send_payment'=>$old_gateway_settings['payment_address']
135
+				);
136
+				$desc = __('On the next page you will be given instructions on how to make a payment by check.', 'event_espresso');
137
+				break;
138
+			case 'Invoice':
139
+				$extra_meta_key_values = array(
140
+					'pdf_payee_name' => $old_gateway_settings['template_invoice_payee_name'],
141
+					'pdf_payee_email' => $old_gateway_settings['template_invoice_email'],
142
+					'pdf_payee_tax_number' => $old_gateway_settings['template_invoice_tax_number'],
143
+					'pdf_payee_address' => $old_gateway_settings['template_invoice_address'],
144
+					'pdf_instructions' => $old_gateway_settings['template_payment_instructions'],
145
+					'pdf_logo_image' => $old_gateway_settings['invoice_logo_url'],
146
+					'page_confirmation_text' => isset($old_gateway_settings['page_instructions']) ? $old_gateway_settings['page_instructions'] : '',
147
+					'page_extra_info' => isset($old_gateway_settings['payment_address']) ? $old_gateway_settings['payment_address'] : '',
148
+					'legacy_invoice_css' => $old_gateway_settings['invoice_css']
149
+				);
150
+				// if they didnt want the invoiec gateway to show, pretend it was inactive
151
+				if (! $old_gateway_settings['show']) {
152
+					$active = false;
153
+				}
154
+				$desc = __('On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso');
155
+				break;
156
+			case 'Mijireh':
157
+				$extra_meta_key_values = array(
158
+					'access_key' => $old_gateway_settings['access_key']
159
+				);
160
+				$desc =  __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso');
161
+				break;
162
+			case 'Paypal_Pro':
163
+				$extra_meta_key_values = array(
164
+					'username'=>$old_gateway_settings['username'],
165
+					'password'=>$old_gateway_settings['password'],
166
+					'signature'=>$old_gateway_settings['signature'],
167
+					'credit_card_types'=>$old_gateway_settings['credit_cards'],
168
+				);
169
+				$desc = __('Please provide the following billing information.', 'event_espresso');
170
+				break;
171
+			case 'Paypal_Standard':
172
+				$extra_meta_key_values = array(
173
+					'paypal_id' => $old_gateway_settings['paypal_id'],
174
+					'image_url' => $old_gateway_settings['image_url'],
175
+					'shipping_details' => isset($old_gateway_settings['no_shipping']) ? $old_gateway_settings['no_shipping'] : false,
176 176
 
177
-                );
178
-                $desc = sprintf(__('After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso'), '<strong>', '</strong>');
179
-                break;
180
-            default:
181
-                // if we don't recognize the payment method, just put everything in it into extra meta. At least this way its preserved somewhere
182
-                $extra_meta_key_values = $old_gateway_settings;
183
-                $desc = '';
184
-        }
185
-        $pretty_name = isset($old_gateway_settings['display_name']) ? $old_gateway_settings['display_name'] : $old_gateway_slug;
186
-        $offline_gateways = array( 'Bank', 'Check', 'Invoice' );
187
-        if ($active && in_array($old_gateway_slug, $offline_gateways)) {
188
-            $scope = array( 'CART', 'ADMIN');
189
-        } elseif ($active && ! in_array($old_gateway_slug, $offline_gateways)) {
190
-            $scope = array( 'CART' );
191
-        } elseif (! $active && in_array($old_gateway_slug, $offline_gateways)) {
192
-            $scope = array( 'ADMIN' );
193
-        } else {
194
-            $scope = array();
195
-        }
196
-        $payment_method_col_values = array(
197
-            'PMD_type' => $old_gateway_slug,
198
-            'PMD_name' => $pretty_name,
199
-            'PMD_desc' => $desc,
200
-            'PMD_admin_name' => $pretty_name,
201
-            'PMD_slug' => sanitize_key($old_gateway_slug),
202
-            'PMD_debug_mode' => isset($old_gateway_settings['use_sandbox']) ? $old_gateway_settings['use_sandbox'] : false,
203
-            'PMD_button_url' => isset($old_gateway_settings['button_url']) ? $old_gateway_settings['button_url'] : null,
204
-            'PMD_scope' =>  serialize($scope)
205
-        );
206
-        $db_types = array(
207
-            '%s',// PMD_type
208
-            '%s',// PMD_name
209
-            '%s',// PMD_desc
210
-            '%s',// PMD_admin_name
211
-            '%s',// PMD_slug
212
-            '%d',// PMD_debug_mode
213
-            '%s',// PMD_button_url
214
-            '%s',// PMD_scope
215
-        );
216
-        global $wpdb;
217
-        // first: check if it already exists
218
-        $id = $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values['PMD_slug']));
219
-        if ($id) {
220
-            // just update that payment method instead of creating a new one
221
-            $success = $wpdb->update(
222
-                $this->_new_table_name,
223
-                $payment_method_col_values,
224
-                array(
225
-                        'PMD_ID'=>$id
226
-                    ),
227
-                $db_types,
228
-                array(
229
-                        '%d',// PMD_ID
230
-                    )
231
-            );
232
-            if (! $success) {
233
-                $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"), $id, wp_json_encode($payment_method_col_values), $wpdb->last_error));
234
-            }
235
-        } else {
236
-            $success = $wpdb->insert(
237
-                $this->_new_table_name,
238
-                $payment_method_col_values,
239
-                $db_types
240
-            );
241
-            if (! $success) {
242
-                $this->add_error($wpdb->last_error);
243
-                return false;
244
-            } else {
245
-                $id = $wpdb->insert_id;
246
-            }
247
-        }
177
+				);
178
+				$desc = sprintf(__('After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso'), '<strong>', '</strong>');
179
+				break;
180
+			default:
181
+				// if we don't recognize the payment method, just put everything in it into extra meta. At least this way its preserved somewhere
182
+				$extra_meta_key_values = $old_gateway_settings;
183
+				$desc = '';
184
+		}
185
+		$pretty_name = isset($old_gateway_settings['display_name']) ? $old_gateway_settings['display_name'] : $old_gateway_slug;
186
+		$offline_gateways = array( 'Bank', 'Check', 'Invoice' );
187
+		if ($active && in_array($old_gateway_slug, $offline_gateways)) {
188
+			$scope = array( 'CART', 'ADMIN');
189
+		} elseif ($active && ! in_array($old_gateway_slug, $offline_gateways)) {
190
+			$scope = array( 'CART' );
191
+		} elseif (! $active && in_array($old_gateway_slug, $offline_gateways)) {
192
+			$scope = array( 'ADMIN' );
193
+		} else {
194
+			$scope = array();
195
+		}
196
+		$payment_method_col_values = array(
197
+			'PMD_type' => $old_gateway_slug,
198
+			'PMD_name' => $pretty_name,
199
+			'PMD_desc' => $desc,
200
+			'PMD_admin_name' => $pretty_name,
201
+			'PMD_slug' => sanitize_key($old_gateway_slug),
202
+			'PMD_debug_mode' => isset($old_gateway_settings['use_sandbox']) ? $old_gateway_settings['use_sandbox'] : false,
203
+			'PMD_button_url' => isset($old_gateway_settings['button_url']) ? $old_gateway_settings['button_url'] : null,
204
+			'PMD_scope' =>  serialize($scope)
205
+		);
206
+		$db_types = array(
207
+			'%s',// PMD_type
208
+			'%s',// PMD_name
209
+			'%s',// PMD_desc
210
+			'%s',// PMD_admin_name
211
+			'%s',// PMD_slug
212
+			'%d',// PMD_debug_mode
213
+			'%s',// PMD_button_url
214
+			'%s',// PMD_scope
215
+		);
216
+		global $wpdb;
217
+		// first: check if it already exists
218
+		$id = $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values['PMD_slug']));
219
+		if ($id) {
220
+			// just update that payment method instead of creating a new one
221
+			$success = $wpdb->update(
222
+				$this->_new_table_name,
223
+				$payment_method_col_values,
224
+				array(
225
+						'PMD_ID'=>$id
226
+					),
227
+				$db_types,
228
+				array(
229
+						'%d',// PMD_ID
230
+					)
231
+			);
232
+			if (! $success) {
233
+				$this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"), $id, wp_json_encode($payment_method_col_values), $wpdb->last_error));
234
+			}
235
+		} else {
236
+			$success = $wpdb->insert(
237
+				$this->_new_table_name,
238
+				$payment_method_col_values,
239
+				$db_types
240
+			);
241
+			if (! $success) {
242
+				$this->add_error($wpdb->last_error);
243
+				return false;
244
+			} else {
245
+				$id = $wpdb->insert_id;
246
+			}
247
+		}
248 248
 
249
-        if ($id) {
250
-            $this->_convert_extra_meta_values($id, $extra_meta_key_values);
251
-            $this->get_migration_script()->set_mapping('EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id);
252
-            return true;
253
-        }
254
-        return false;
255
-    }
249
+		if ($id) {
250
+			$this->_convert_extra_meta_values($id, $extra_meta_key_values);
251
+			$this->get_migration_script()->set_mapping('EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id);
252
+			return true;
253
+		}
254
+		return false;
255
+	}
256 256
 
257 257
 
258 258
 
259
-    /**
260
-     * Converts old gateway settings which don't map onto the Payment_Method model
261
-     * to extra meta fields
262
-     * @param int $id
263
-     * @param array $extra_meta_key_values
264
-     */
265
-    private function _convert_extra_meta_values($id, $extra_meta_key_values)
266
-    {
267
-        global $wpdb;
268
-        foreach ($extra_meta_key_values as $key => $value) {
269
-            $exm_args = array(
270
-                'OBJ_ID'=>$id,
271
-                'EXM_type'=>'Payment_Method',
272
-                'EXM_key'=>$key,
273
-                'EXM_value'=> maybe_serialize($value)
274
-            );
275
-            $success = $wpdb->insert(
276
-                $this->_extra_meta_table_name,
277
-                $exm_args,
278
-                array(
279
-                        '%d',// OBJ_ID
280
-                        '%s',// EXM_type
281
-                        '%s',// EXM_key
282
-                        '%s',// EXM_value
283
-                    )
284
-            );
285
-            if (! $success) {
286
-                $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"), wp_json_encode($exm_args), $wpdb->last_error));
287
-            }
288
-        }
289
-    }
259
+	/**
260
+	 * Converts old gateway settings which don't map onto the Payment_Method model
261
+	 * to extra meta fields
262
+	 * @param int $id
263
+	 * @param array $extra_meta_key_values
264
+	 */
265
+	private function _convert_extra_meta_values($id, $extra_meta_key_values)
266
+	{
267
+		global $wpdb;
268
+		foreach ($extra_meta_key_values as $key => $value) {
269
+			$exm_args = array(
270
+				'OBJ_ID'=>$id,
271
+				'EXM_type'=>'Payment_Method',
272
+				'EXM_key'=>$key,
273
+				'EXM_value'=> maybe_serialize($value)
274
+			);
275
+			$success = $wpdb->insert(
276
+				$this->_extra_meta_table_name,
277
+				$exm_args,
278
+				array(
279
+						'%d',// OBJ_ID
280
+						'%s',// EXM_type
281
+						'%s',// EXM_key
282
+						'%s',// EXM_value
283
+					)
284
+			);
285
+			if (! $success) {
286
+				$this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"), wp_json_encode($exm_args), $wpdb->last_error));
287
+			}
288
+		}
289
+	}
290 290
 }
Please login to merge, or discard this patch.
Spacing   +26 added lines, -26 removed lines patch added patch discarded remove patch
@@ -77,7 +77,7 @@  discard block
 block discarded – undo
77 77
         $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings, $this->count_records_migrated(), $num_items_to_migrate);
78 78
         foreach ($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings) {
79 79
             if (in_array($old_gateway_slug, $this->_gateway_we_know_to_migrate)) {
80
-                if (! $old_gateway_settings) {
80
+                if ( ! $old_gateway_settings) {
81 81
                     // no settings existed for this gateway anyways... weird...
82 82
                     $items_actually_migrated++;
83 83
                     continue;
@@ -86,10 +86,10 @@  discard block
 block discarded – undo
86 86
                 $success = $this->_convert_gateway_settings(
87 87
                     $old_gateway_slug,
88 88
                     $old_gateway_settings,
89
-                    isset(EE_Config::instance()->gateway->active_gateways[ $old_gateway_slug ])
89
+                    isset(EE_Config::instance()->gateway->active_gateways[$old_gateway_slug])
90 90
                 );
91 91
                 if ($success) {
92
-                    EE_Config::instance()->gateway->payment_settings[ $old_gateway_slug ] = 'Deprecated';
92
+                    EE_Config::instance()->gateway->payment_settings[$old_gateway_slug] = 'Deprecated';
93 93
                 }
94 94
             }
95 95
             $items_actually_migrated++;
@@ -148,7 +148,7 @@  discard block
 block discarded – undo
148 148
                     'legacy_invoice_css' => $old_gateway_settings['invoice_css']
149 149
                 );
150 150
                 // if they didnt want the invoiec gateway to show, pretend it was inactive
151
-                if (! $old_gateway_settings['show']) {
151
+                if ( ! $old_gateway_settings['show']) {
152 152
                     $active = false;
153 153
                 }
154 154
                 $desc = __('On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso');
@@ -157,7 +157,7 @@  discard block
 block discarded – undo
157 157
                 $extra_meta_key_values = array(
158 158
                     'access_key' => $old_gateway_settings['access_key']
159 159
                 );
160
-                $desc =  __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso');
160
+                $desc = __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso');
161 161
                 break;
162 162
             case 'Paypal_Pro':
163 163
                 $extra_meta_key_values = array(
@@ -183,13 +183,13 @@  discard block
 block discarded – undo
183 183
                 $desc = '';
184 184
         }
185 185
         $pretty_name = isset($old_gateway_settings['display_name']) ? $old_gateway_settings['display_name'] : $old_gateway_slug;
186
-        $offline_gateways = array( 'Bank', 'Check', 'Invoice' );
186
+        $offline_gateways = array('Bank', 'Check', 'Invoice');
187 187
         if ($active && in_array($old_gateway_slug, $offline_gateways)) {
188
-            $scope = array( 'CART', 'ADMIN');
188
+            $scope = array('CART', 'ADMIN');
189 189
         } elseif ($active && ! in_array($old_gateway_slug, $offline_gateways)) {
190
-            $scope = array( 'CART' );
191
-        } elseif (! $active && in_array($old_gateway_slug, $offline_gateways)) {
192
-            $scope = array( 'ADMIN' );
190
+            $scope = array('CART');
191
+        } elseif ( ! $active && in_array($old_gateway_slug, $offline_gateways)) {
192
+            $scope = array('ADMIN');
193 193
         } else {
194 194
             $scope = array();
195 195
         }
@@ -204,14 +204,14 @@  discard block
 block discarded – undo
204 204
             'PMD_scope' =>  serialize($scope)
205 205
         );
206 206
         $db_types = array(
207
-            '%s',// PMD_type
208
-            '%s',// PMD_name
209
-            '%s',// PMD_desc
210
-            '%s',// PMD_admin_name
211
-            '%s',// PMD_slug
212
-            '%d',// PMD_debug_mode
213
-            '%s',// PMD_button_url
214
-            '%s',// PMD_scope
207
+            '%s', // PMD_type
208
+            '%s', // PMD_name
209
+            '%s', // PMD_desc
210
+            '%s', // PMD_admin_name
211
+            '%s', // PMD_slug
212
+            '%d', // PMD_debug_mode
213
+            '%s', // PMD_button_url
214
+            '%s', // PMD_scope
215 215
         );
216 216
         global $wpdb;
217 217
         // first: check if it already exists
@@ -226,10 +226,10 @@  discard block
 block discarded – undo
226 226
                     ),
227 227
                 $db_types,
228 228
                 array(
229
-                        '%d',// PMD_ID
229
+                        '%d', // PMD_ID
230 230
                     )
231 231
             );
232
-            if (! $success) {
232
+            if ( ! $success) {
233 233
                 $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"), $id, wp_json_encode($payment_method_col_values), $wpdb->last_error));
234 234
             }
235 235
         } else {
@@ -238,7 +238,7 @@  discard block
 block discarded – undo
238 238
                 $payment_method_col_values,
239 239
                 $db_types
240 240
             );
241
-            if (! $success) {
241
+            if ( ! $success) {
242 242
                 $this->add_error($wpdb->last_error);
243 243
                 return false;
244 244
             } else {
@@ -276,13 +276,13 @@  discard block
 block discarded – undo
276 276
                 $this->_extra_meta_table_name,
277 277
                 $exm_args,
278 278
                 array(
279
-                        '%d',// OBJ_ID
280
-                        '%s',// EXM_type
281
-                        '%s',// EXM_key
282
-                        '%s',// EXM_value
279
+                        '%d', // OBJ_ID
280
+                        '%s', // EXM_type
281
+                        '%s', // EXM_key
282
+                        '%s', // EXM_value
283 283
                     )
284 284
             );
285
-            if (! $success) {
285
+            if ( ! $success) {
286 286
                 $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"), wp_json_encode($exm_args), $wpdb->last_error));
287 287
             }
288 288
         }
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Registration_Payments.dmsstage.php 2 patches
Indentation   +221 added lines, -221 removed lines patch added patch discarded remove patch
@@ -12,225 +12,225 @@
 block discarded – undo
12 12
 class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table
13 13
 {
14 14
 
15
-    protected $_payment_table;
16
-
17
-    protected $_registration_table;
18
-
19
-    protected $_registration_payment_table;
20
-
21
-    public function __construct()
22
-    {
23
-        /** @type WPDB $wpdb */
24
-        global $wpdb;
25
-        $this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso');
26
-        // define tables
27
-        $this->_old_table                                   = $wpdb->prefix . 'esp_transaction';
28
-        $this->_payment_table                       = $wpdb->prefix . 'esp_payment';
29
-        $this->_registration_table                  = $wpdb->prefix . 'esp_registration';
30
-        $this->_registration_payment_table  = $wpdb->prefix . 'esp_registration_payment';
31
-        // build SQL WHERE clauses
32
-        $this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'";
33
-        parent::__construct();
34
-    }
35
-
36
-
37
-
38
-    /**
39
-     * @param array $transaction
40
-     * @return void
41
-     */
42
-    protected function _migrate_old_row($transaction)
43
-    {
44
-        /** @type WPDB $wpdb */
45
-        global $wpdb;
46
-        $TXN_ID = absint($transaction['TXN_ID']);
47
-        if (! $TXN_ID) {
48
-            $this->add_error(
49
-                sprintf(
50
-                    __('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'),
51
-                    $TXN_ID,
52
-                    $wpdb->last_error
53
-                )
54
-            );
55
-            return;
56
-        }
57
-        // get all payments for the TXN
58
-        $payments = $this->_get_payments($TXN_ID);
59
-        if (empty($payments)) {
60
-            return;
61
-        }
62
-        // then the registrants
63
-        $registrations = $this->_get_registrations($TXN_ID);
64
-        if (empty($registrations)) {
65
-            return;
66
-        }
67
-        // now loop thru each payment and apply it to each of the registrations
68
-        foreach ($payments as $PAY_ID => $payment) {
69
-            if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) {
70
-                $this->_process_registration_payments($payment, $registrations);
71
-            }
72
-        }
73
-    }
74
-
75
-
76
-
77
-    /**
78
-     * _get_registrations
79
-     *
80
-     * @param int $TXN_ID
81
-     * @return array
82
-     */
83
-    protected function _get_registrations($TXN_ID)
84
-    {
85
-        /** @type WPDB $wpdb */
86
-        global $wpdb;
87
-        $SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )";
88
-        return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K);
89
-    }
90
-
91
-
92
-
93
-    /**
94
-     * _get_payments
95
-     *
96
-     * @param int $TXN_ID
97
-     * @return array
98
-     */
99
-    protected function _get_payments($TXN_ID)
100
-    {
101
-        /** @type WPDB $wpdb */
102
-        global $wpdb;
103
-        return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K);
104
-    }
105
-
106
-
107
-
108
-    /**
109
-     * _get_possibly_updated_REG_paid
110
-     *
111
-     * @param int $REG_ID
112
-     * @return array
113
-     */
114
-    protected function _get_possibly_updated_REG_paid($REG_ID)
115
-    {
116
-        /** @type WPDB $wpdb */
117
-        global $wpdb;
118
-        return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID));
119
-    }
120
-
121
-
122
-
123
-    /**
124
-     * _process_registration_payments
125
-     *
126
-     * basically a copy of the "Sequential Registration Payment Application Strategy"  logic
127
-     * currently in EE_Payment_Processor::process_registration_payments()
128
-     *
129
-     * @param stdClass $payment
130
-     * @param array $registrations
131
-     * @return bool
132
-     */
133
-    protected function _process_registration_payments($payment, $registrations = array())
134
-    {
135
-        // how much is available to apply to registrations?
136
-        $available_payment_amount = $payment->PAY_amount;
137
-        foreach ($registrations as $REG_ID => $registration) {
138
-            // nothing left, then we are done here?
139
-            if (! $available_payment_amount > 0) {
140
-                break;
141
-            }
142
-            // ensure REG_final_price has a valid value, and skip if it turns out to be zero
143
-            $registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00;
144
-            if (! $registration->REG_final_price > 0) {
145
-                continue;
146
-            }
147
-            // because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db
148
-            $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID);
149
-            if (is_float($possibly_updated_REG_paid)) {
150
-                $registration->REG_paid = $possibly_updated_REG_paid;
151
-            }
152
-            // and ensure REG_paid has a valid value
153
-            $registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00;
154
-            // calculate amount owing, and skip if it turns out to be zero
155
-            $owing = $registration->REG_final_price - $registration->REG_paid;
156
-            if (! $owing > 0) {
157
-                continue;
158
-            }
159
-            // don't allow payment amount to exceed the available payment amount, OR the amount owing
160
-            $payment_amount = min($available_payment_amount, $owing);
161
-            // update $available_payment_amount
162
-            $available_payment_amount = $available_payment_amount - $payment_amount;
163
-            // add relation between registration and payment and set amount
164
-            if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) {
165
-                // calculate and set new REG_paid
166
-                $registration->REG_paid = $registration->REG_paid + $payment_amount;
167
-                $this->_update_registration_paid($registration->REG_ID, $registration->REG_paid);
168
-            }
169
-        }
170
-    }
171
-
172
-
173
-
174
-    /**
175
-     * _insert_registration_payment
176
-     *
177
-     * @param int $REG_ID
178
-     * @param int $PAY_ID
179
-     * @param float $PAY_amount
180
-     * @return bool
181
-     */
182
-    protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00)
183
-    {
184
-        /** @type WPDB $wpdb */
185
-        global $wpdb;
186
-        $success = $wpdb->insert(
187
-            $this->_registration_payment_table,
188
-            array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ),  // data
189
-            array( '%f' )   // data format
190
-        );
191
-        if ($success === false) {
192
-            $this->add_error(
193
-                sprintf(
194
-                    __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
195
-                    $REG_ID,
196
-                    $wpdb->last_error
197
-                )
198
-            );
199
-            return false;
200
-        }
201
-        return true;
202
-    }
203
-
204
-
205
-
206
-    /**
207
-     * _update_registration_paid
208
-     *
209
-     * @param int $REG_ID
210
-     * @param float $REG_paid
211
-     * @return bool
212
-     */
213
-    protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00)
214
-    {
215
-        /** @type WPDB $wpdb */
216
-        global $wpdb;
217
-        $success = $wpdb->update(
218
-            $this->_registration_table,
219
-            array( 'REG_paid' => $REG_paid ),  // data
220
-            array( 'REG_ID' => $REG_ID ),  // where
221
-            array( '%f' ),   // data format
222
-            array( '%d' )  // where format
223
-        );
224
-        if ($success === false) {
225
-            $this->add_error(
226
-                sprintf(
227
-                    __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
228
-                    $REG_ID,
229
-                    $wpdb->last_error
230
-                )
231
-            );
232
-            return false;
233
-        }
234
-        return true;
235
-    }
15
+	protected $_payment_table;
16
+
17
+	protected $_registration_table;
18
+
19
+	protected $_registration_payment_table;
20
+
21
+	public function __construct()
22
+	{
23
+		/** @type WPDB $wpdb */
24
+		global $wpdb;
25
+		$this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso');
26
+		// define tables
27
+		$this->_old_table                                   = $wpdb->prefix . 'esp_transaction';
28
+		$this->_payment_table                       = $wpdb->prefix . 'esp_payment';
29
+		$this->_registration_table                  = $wpdb->prefix . 'esp_registration';
30
+		$this->_registration_payment_table  = $wpdb->prefix . 'esp_registration_payment';
31
+		// build SQL WHERE clauses
32
+		$this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'";
33
+		parent::__construct();
34
+	}
35
+
36
+
37
+
38
+	/**
39
+	 * @param array $transaction
40
+	 * @return void
41
+	 */
42
+	protected function _migrate_old_row($transaction)
43
+	{
44
+		/** @type WPDB $wpdb */
45
+		global $wpdb;
46
+		$TXN_ID = absint($transaction['TXN_ID']);
47
+		if (! $TXN_ID) {
48
+			$this->add_error(
49
+				sprintf(
50
+					__('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'),
51
+					$TXN_ID,
52
+					$wpdb->last_error
53
+				)
54
+			);
55
+			return;
56
+		}
57
+		// get all payments for the TXN
58
+		$payments = $this->_get_payments($TXN_ID);
59
+		if (empty($payments)) {
60
+			return;
61
+		}
62
+		// then the registrants
63
+		$registrations = $this->_get_registrations($TXN_ID);
64
+		if (empty($registrations)) {
65
+			return;
66
+		}
67
+		// now loop thru each payment and apply it to each of the registrations
68
+		foreach ($payments as $PAY_ID => $payment) {
69
+			if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) {
70
+				$this->_process_registration_payments($payment, $registrations);
71
+			}
72
+		}
73
+	}
74
+
75
+
76
+
77
+	/**
78
+	 * _get_registrations
79
+	 *
80
+	 * @param int $TXN_ID
81
+	 * @return array
82
+	 */
83
+	protected function _get_registrations($TXN_ID)
84
+	{
85
+		/** @type WPDB $wpdb */
86
+		global $wpdb;
87
+		$SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )";
88
+		return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K);
89
+	}
90
+
91
+
92
+
93
+	/**
94
+	 * _get_payments
95
+	 *
96
+	 * @param int $TXN_ID
97
+	 * @return array
98
+	 */
99
+	protected function _get_payments($TXN_ID)
100
+	{
101
+		/** @type WPDB $wpdb */
102
+		global $wpdb;
103
+		return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K);
104
+	}
105
+
106
+
107
+
108
+	/**
109
+	 * _get_possibly_updated_REG_paid
110
+	 *
111
+	 * @param int $REG_ID
112
+	 * @return array
113
+	 */
114
+	protected function _get_possibly_updated_REG_paid($REG_ID)
115
+	{
116
+		/** @type WPDB $wpdb */
117
+		global $wpdb;
118
+		return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID));
119
+	}
120
+
121
+
122
+
123
+	/**
124
+	 * _process_registration_payments
125
+	 *
126
+	 * basically a copy of the "Sequential Registration Payment Application Strategy"  logic
127
+	 * currently in EE_Payment_Processor::process_registration_payments()
128
+	 *
129
+	 * @param stdClass $payment
130
+	 * @param array $registrations
131
+	 * @return bool
132
+	 */
133
+	protected function _process_registration_payments($payment, $registrations = array())
134
+	{
135
+		// how much is available to apply to registrations?
136
+		$available_payment_amount = $payment->PAY_amount;
137
+		foreach ($registrations as $REG_ID => $registration) {
138
+			// nothing left, then we are done here?
139
+			if (! $available_payment_amount > 0) {
140
+				break;
141
+			}
142
+			// ensure REG_final_price has a valid value, and skip if it turns out to be zero
143
+			$registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00;
144
+			if (! $registration->REG_final_price > 0) {
145
+				continue;
146
+			}
147
+			// because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db
148
+			$possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID);
149
+			if (is_float($possibly_updated_REG_paid)) {
150
+				$registration->REG_paid = $possibly_updated_REG_paid;
151
+			}
152
+			// and ensure REG_paid has a valid value
153
+			$registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00;
154
+			// calculate amount owing, and skip if it turns out to be zero
155
+			$owing = $registration->REG_final_price - $registration->REG_paid;
156
+			if (! $owing > 0) {
157
+				continue;
158
+			}
159
+			// don't allow payment amount to exceed the available payment amount, OR the amount owing
160
+			$payment_amount = min($available_payment_amount, $owing);
161
+			// update $available_payment_amount
162
+			$available_payment_amount = $available_payment_amount - $payment_amount;
163
+			// add relation between registration and payment and set amount
164
+			if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) {
165
+				// calculate and set new REG_paid
166
+				$registration->REG_paid = $registration->REG_paid + $payment_amount;
167
+				$this->_update_registration_paid($registration->REG_ID, $registration->REG_paid);
168
+			}
169
+		}
170
+	}
171
+
172
+
173
+
174
+	/**
175
+	 * _insert_registration_payment
176
+	 *
177
+	 * @param int $REG_ID
178
+	 * @param int $PAY_ID
179
+	 * @param float $PAY_amount
180
+	 * @return bool
181
+	 */
182
+	protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00)
183
+	{
184
+		/** @type WPDB $wpdb */
185
+		global $wpdb;
186
+		$success = $wpdb->insert(
187
+			$this->_registration_payment_table,
188
+			array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ),  // data
189
+			array( '%f' )   // data format
190
+		);
191
+		if ($success === false) {
192
+			$this->add_error(
193
+				sprintf(
194
+					__('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
195
+					$REG_ID,
196
+					$wpdb->last_error
197
+				)
198
+			);
199
+			return false;
200
+		}
201
+		return true;
202
+	}
203
+
204
+
205
+
206
+	/**
207
+	 * _update_registration_paid
208
+	 *
209
+	 * @param int $REG_ID
210
+	 * @param float $REG_paid
211
+	 * @return bool
212
+	 */
213
+	protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00)
214
+	{
215
+		/** @type WPDB $wpdb */
216
+		global $wpdb;
217
+		$success = $wpdb->update(
218
+			$this->_registration_table,
219
+			array( 'REG_paid' => $REG_paid ),  // data
220
+			array( 'REG_ID' => $REG_ID ),  // where
221
+			array( '%f' ),   // data format
222
+			array( '%d' )  // where format
223
+		);
224
+		if ($success === false) {
225
+			$this->add_error(
226
+				sprintf(
227
+					__('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
228
+					$REG_ID,
229
+					$wpdb->last_error
230
+				)
231
+			);
232
+			return false;
233
+		}
234
+		return true;
235
+	}
236 236
 }
Please login to merge, or discard this patch.
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -24,10 +24,10 @@  discard block
 block discarded – undo
24 24
         global $wpdb;
25 25
         $this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso');
26 26
         // define tables
27
-        $this->_old_table                                   = $wpdb->prefix . 'esp_transaction';
28
-        $this->_payment_table                       = $wpdb->prefix . 'esp_payment';
29
-        $this->_registration_table                  = $wpdb->prefix . 'esp_registration';
30
-        $this->_registration_payment_table  = $wpdb->prefix . 'esp_registration_payment';
27
+        $this->_old_table = $wpdb->prefix.'esp_transaction';
28
+        $this->_payment_table                       = $wpdb->prefix.'esp_payment';
29
+        $this->_registration_table                  = $wpdb->prefix.'esp_registration';
30
+        $this->_registration_payment_table = $wpdb->prefix.'esp_registration_payment';
31 31
         // build SQL WHERE clauses
32 32
         $this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'";
33 33
         parent::__construct();
@@ -44,7 +44,7 @@  discard block
 block discarded – undo
44 44
         /** @type WPDB $wpdb */
45 45
         global $wpdb;
46 46
         $TXN_ID = absint($transaction['TXN_ID']);
47
-        if (! $TXN_ID) {
47
+        if ( ! $TXN_ID) {
48 48
             $this->add_error(
49 49
                 sprintf(
50 50
                     __('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'),
@@ -136,12 +136,12 @@  discard block
 block discarded – undo
136 136
         $available_payment_amount = $payment->PAY_amount;
137 137
         foreach ($registrations as $REG_ID => $registration) {
138 138
             // nothing left, then we are done here?
139
-            if (! $available_payment_amount > 0) {
139
+            if ( ! $available_payment_amount > 0) {
140 140
                 break;
141 141
             }
142 142
             // ensure REG_final_price has a valid value, and skip if it turns out to be zero
143 143
             $registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00;
144
-            if (! $registration->REG_final_price > 0) {
144
+            if ( ! $registration->REG_final_price > 0) {
145 145
                 continue;
146 146
             }
147 147
             // because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db
@@ -153,7 +153,7 @@  discard block
 block discarded – undo
153 153
             $registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00;
154 154
             // calculate amount owing, and skip if it turns out to be zero
155 155
             $owing = $registration->REG_final_price - $registration->REG_paid;
156
-            if (! $owing > 0) {
156
+            if ( ! $owing > 0) {
157 157
                 continue;
158 158
             }
159 159
             // don't allow payment amount to exceed the available payment amount, OR the amount owing
@@ -185,8 +185,8 @@  discard block
 block discarded – undo
185 185
         global $wpdb;
186 186
         $success = $wpdb->insert(
187 187
             $this->_registration_payment_table,
188
-            array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ),  // data
189
-            array( '%f' )   // data format
188
+            array('REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount,), // data
189
+            array('%f')   // data format
190 190
         );
191 191
         if ($success === false) {
192 192
             $this->add_error(
@@ -216,10 +216,10 @@  discard block
 block discarded – undo
216 216
         global $wpdb;
217 217
         $success = $wpdb->update(
218 218
             $this->_registration_table,
219
-            array( 'REG_paid' => $REG_paid ),  // data
220
-            array( 'REG_ID' => $REG_ID ),  // where
221
-            array( '%f' ),   // data format
222
-            array( '%d' )  // where format
219
+            array('REG_paid' => $REG_paid), // data
220
+            array('REG_ID' => $REG_ID), // where
221
+            array('%f'), // data format
222
+            array('%d')  // where format
223 223
         );
224 224
         if ($success === false) {
225 225
             $this->add_error(
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price.dmsstage.php 2 patches
Indentation   +200 added lines, -200 removed lines patch added patch discarded remove patch
@@ -12,73 +12,73 @@  discard block
 block discarded – undo
12 12
 class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table
13 13
 {
14 14
 
15
-    protected $_ticket_table;
16
-
17
-    protected $_line_item_table;
18
-
19
-    public function __construct()
20
-    {
21
-        /** @type WPDB $wpdb */
22
-        global $wpdb;
23
-        $this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso');
24
-        // define tables
25
-        $this->_old_table               = $wpdb->prefix . 'esp_registration';
26
-        $this->_ticket_table            = $wpdb->prefix . 'esp_ticket';
27
-        $this->_line_item_table     = $wpdb->prefix . 'esp_line_item';
28
-        parent::__construct();
29
-    }
30
-
31
-
32
-
33
-    /**
34
-     * @return string
35
-     */
36
-    protected function _get_rest_of_sql_for_query()
37
-    {
38
-        $SQL = "FROM {$this->_old_table} AS reg ";
39
-        $SQL .= "JOIN {$this->_ticket_table} as tkt ON reg.TKT_ID = tkt.TKT_ID ";
40
-        $SQL .= "JOIN {$this->_line_item_table} as line ON reg.TXN_ID = line.TXN_ID ";
41
-        $SQL .= "WHERE tkt.TKT_taxable = 1 ";
42
-        $SQL .= "AND line.LIN_code = 'total' ";
43
-        $SQL .= "AND reg.REG_final_price > 0 ";
44
-        return $SQL;
45
-    }
46
-
47
-
48
-
49
-    /**
50
-     * Counts the records to migrate; the public version may cache it
51
-     * @return int
52
-     */
53
-    public function _count_records_to_migrate()
54
-    {
55
-        /** @type WPDB $wpdb */
56
-        global $wpdb;
57
-        $SQL = "SELECT count( reg.REG_ID ) ";
58
-        $SQL .= $this->_get_rest_of_sql_for_query();
59
-        $count = $wpdb->get_var($SQL);
60
-        return $count;
61
-    }
62
-
63
-
64
-
65
-    /**
66
-     * Gets data for all registrations with taxable tickets in the esp_line_item table
67
-     * @global wpdb $wpdb
68
-     * @param int $limit
69
-     * @return array of arrays like $wpdb->get_results($sql, ARRAY_A)
70
-     */
71
-    protected function _get_rows($limit)
72
-    {
73
-        /** @type WPDB $wpdb */
74
-        global $wpdb;
75
-        $start_at_record = $this->count_records_migrated();
76
-        $SQL = "SELECT reg.REG_ID,  reg.REG_final_price, line.LIN_ID ";
77
-        $SQL .= $this->_get_rest_of_sql_for_query();
78
-        $SQL .= $wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit);
79
-
80
-        // produces something like:
81
-        /*
15
+	protected $_ticket_table;
16
+
17
+	protected $_line_item_table;
18
+
19
+	public function __construct()
20
+	{
21
+		/** @type WPDB $wpdb */
22
+		global $wpdb;
23
+		$this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso');
24
+		// define tables
25
+		$this->_old_table               = $wpdb->prefix . 'esp_registration';
26
+		$this->_ticket_table            = $wpdb->prefix . 'esp_ticket';
27
+		$this->_line_item_table     = $wpdb->prefix . 'esp_line_item';
28
+		parent::__construct();
29
+	}
30
+
31
+
32
+
33
+	/**
34
+	 * @return string
35
+	 */
36
+	protected function _get_rest_of_sql_for_query()
37
+	{
38
+		$SQL = "FROM {$this->_old_table} AS reg ";
39
+		$SQL .= "JOIN {$this->_ticket_table} as tkt ON reg.TKT_ID = tkt.TKT_ID ";
40
+		$SQL .= "JOIN {$this->_line_item_table} as line ON reg.TXN_ID = line.TXN_ID ";
41
+		$SQL .= "WHERE tkt.TKT_taxable = 1 ";
42
+		$SQL .= "AND line.LIN_code = 'total' ";
43
+		$SQL .= "AND reg.REG_final_price > 0 ";
44
+		return $SQL;
45
+	}
46
+
47
+
48
+
49
+	/**
50
+	 * Counts the records to migrate; the public version may cache it
51
+	 * @return int
52
+	 */
53
+	public function _count_records_to_migrate()
54
+	{
55
+		/** @type WPDB $wpdb */
56
+		global $wpdb;
57
+		$SQL = "SELECT count( reg.REG_ID ) ";
58
+		$SQL .= $this->_get_rest_of_sql_for_query();
59
+		$count = $wpdb->get_var($SQL);
60
+		return $count;
61
+	}
62
+
63
+
64
+
65
+	/**
66
+	 * Gets data for all registrations with taxable tickets in the esp_line_item table
67
+	 * @global wpdb $wpdb
68
+	 * @param int $limit
69
+	 * @return array of arrays like $wpdb->get_results($sql, ARRAY_A)
70
+	 */
71
+	protected function _get_rows($limit)
72
+	{
73
+		/** @type WPDB $wpdb */
74
+		global $wpdb;
75
+		$start_at_record = $this->count_records_migrated();
76
+		$SQL = "SELECT reg.REG_ID,  reg.REG_final_price, line.LIN_ID ";
77
+		$SQL .= $this->_get_rest_of_sql_for_query();
78
+		$SQL .= $wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit);
79
+
80
+		// produces something like:
81
+		/*
82 82
             SELECT
83 83
               reg.REG_ID,
84 84
               reg.REG_final_price,
@@ -95,137 +95,137 @@  discard block
 block discarded – undo
95 95
             LIMIT 1, 50
96 96
          */
97 97
 
98
-        return $wpdb->get_results($SQL, ARRAY_A);
99
-    }
100
-
101
-
102
-
103
-    /**
104
-     * @param array $row
105
-     * @return void
106
-     */
107
-    protected function _migrate_old_row($row)
108
-    {
109
-        /** @type WPDB $wpdb */
110
-        global $wpdb;
111
-        // ensure all required values are present
112
-        if (! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) {
113
-            $this->add_error(
114
-                sprintf(
115
-                    __('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'),
116
-                    '<br />',
117
-                    isset($row['REG_ID']) ? $row['REG_ID'] : '',
118
-                    isset($row['REG_final_price']) ? $row['REG_final_price'] : '',
119
-                    isset($row['LIN_ID']) ? $row['LIN_ID'] : '',
120
-                    $wpdb->last_error
121
-                )
122
-            );
123
-            return;
124
-        }
125
-        // get tax subtotal
126
-        $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']);
127
-        if (! $tax_subtotal_line_item_ID) {
128
-            $this->add_error(
129
-                sprintf(
130
-                    __('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'),
131
-                    $wpdb->last_error
132
-                )
133
-            );
134
-            return;
135
-        }
136
-        // now get taxes
137
-        $taxes = $this->_get_tax_amounts($tax_subtotal_line_item_ID);
138
-        // apply taxes to registration final price
139
-        $this->_apply_taxes($row['REG_ID'], $row['REG_final_price'], $taxes);
140
-    }
141
-
142
-
143
-
144
-    /**
145
-     * _get_tax_subtotal
146
-     *
147
-     * @param int $LIN_ID
148
-     * @return int
149
-     */
150
-    protected function _get_line_item_ID_for_tax_subtotal($LIN_ID)
151
-    {
152
-        /** @type WPDB $wpdb */
153
-        global $wpdb;
154
-        $SQL = "SELECT LIN_ID ";
155
-        $SQL .= "FROM {$this->_line_item_table} ";
156
-        $SQL .= "WHERE LIN_parent = %d ";
157
-        $SQL .= "AND LIN_code = 'taxes'";
158
-        return $wpdb->get_var($wpdb->prepare($SQL, $LIN_ID));
159
-    }
160
-
161
-
162
-
163
-    /**
164
-     * _get_tax_subtotal
165
-     *
166
-     * @param int $LIN_ID
167
-     * @return array
168
-     */
169
-    protected function _get_tax_amounts($LIN_ID)
170
-    {
171
-        /** @type WPDB $wpdb */
172
-        global $wpdb;
173
-        $SQL = "SELECT LIN_percent ";
174
-        $SQL .= "FROM {$this->_line_item_table} ";
175
-        $SQL .= "WHERE LIN_parent = %d";
176
-        return $wpdb->get_results($wpdb->prepare($SQL, $LIN_ID), OBJECT_K);
177
-    }
178
-
179
-
180
-
181
-    /**
182
-     * _apply_taxes
183
-     *
184
-     * @param int $REG_ID
185
-     * @param float $final_price
186
-     * @param array $taxes
187
-     * @return void
188
-     */
189
-    protected function _apply_taxes($REG_ID = 0, $final_price = 0.00, $taxes = array())
190
-    {
191
-        if (is_array($taxes) && ! empty($taxes)) {
192
-            $total_taxes = 0;
193
-            foreach ($taxes as $tax) {
194
-                $total_taxes += $final_price * ( $tax->LIN_percent / 100 );
195
-            }
196
-            $final_price += $total_taxes;
197
-            $this->_update_registration_final_price($REG_ID, $final_price);
198
-        }
199
-    }
200
-
201
-
202
-
203
-    /**
204
-     * _update_registration_final_price
205
-     *
206
-     * @param int $REG_ID
207
-     * @param float $REG_final_price
208
-     * @return void
209
-     */
210
-    protected function _update_registration_final_price($REG_ID = 0, $REG_final_price = 0.00)
211
-    {
212
-        /** @type WPDB $wpdb */
213
-        global $wpdb;
214
-        $success = $wpdb->update(
215
-            $this->_old_table,
216
-            array( 'REG_final_price' => $REG_final_price ),  // data
217
-            array( 'REG_ID' => $REG_ID ),  // where
218
-            array( '%f' ),   // data format
219
-            array( '%d' )  // where format
220
-        );
221
-        if ($success === false) {
222
-            $this->add_error(
223
-                sprintf(
224
-                    __('Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso'),
225
-                    $REG_ID,
226
-                    $wpdb->last_error
227
-                )
228
-            );
229
-        }
230
-    }
98
+		return $wpdb->get_results($SQL, ARRAY_A);
99
+	}
100
+
101
+
102
+
103
+	/**
104
+	 * @param array $row
105
+	 * @return void
106
+	 */
107
+	protected function _migrate_old_row($row)
108
+	{
109
+		/** @type WPDB $wpdb */
110
+		global $wpdb;
111
+		// ensure all required values are present
112
+		if (! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) {
113
+			$this->add_error(
114
+				sprintf(
115
+					__('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'),
116
+					'<br />',
117
+					isset($row['REG_ID']) ? $row['REG_ID'] : '',
118
+					isset($row['REG_final_price']) ? $row['REG_final_price'] : '',
119
+					isset($row['LIN_ID']) ? $row['LIN_ID'] : '',
120
+					$wpdb->last_error
121
+				)
122
+			);
123
+			return;
124
+		}
125
+		// get tax subtotal
126
+		$tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']);
127
+		if (! $tax_subtotal_line_item_ID) {
128
+			$this->add_error(
129
+				sprintf(
130
+					__('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'),
131
+					$wpdb->last_error
132
+				)
133
+			);
134
+			return;
135
+		}
136
+		// now get taxes
137
+		$taxes = $this->_get_tax_amounts($tax_subtotal_line_item_ID);
138
+		// apply taxes to registration final price
139
+		$this->_apply_taxes($row['REG_ID'], $row['REG_final_price'], $taxes);
140
+	}
141
+
142
+
143
+
144
+	/**
145
+	 * _get_tax_subtotal
146
+	 *
147
+	 * @param int $LIN_ID
148
+	 * @return int
149
+	 */
150
+	protected function _get_line_item_ID_for_tax_subtotal($LIN_ID)
151
+	{
152
+		/** @type WPDB $wpdb */
153
+		global $wpdb;
154
+		$SQL = "SELECT LIN_ID ";
155
+		$SQL .= "FROM {$this->_line_item_table} ";
156
+		$SQL .= "WHERE LIN_parent = %d ";
157
+		$SQL .= "AND LIN_code = 'taxes'";
158
+		return $wpdb->get_var($wpdb->prepare($SQL, $LIN_ID));
159
+	}
160
+
161
+
162
+
163
+	/**
164
+	 * _get_tax_subtotal
165
+	 *
166
+	 * @param int $LIN_ID
167
+	 * @return array
168
+	 */
169
+	protected function _get_tax_amounts($LIN_ID)
170
+	{
171
+		/** @type WPDB $wpdb */
172
+		global $wpdb;
173
+		$SQL = "SELECT LIN_percent ";
174
+		$SQL .= "FROM {$this->_line_item_table} ";
175
+		$SQL .= "WHERE LIN_parent = %d";
176
+		return $wpdb->get_results($wpdb->prepare($SQL, $LIN_ID), OBJECT_K);
177
+	}
178
+
179
+
180
+
181
+	/**
182
+	 * _apply_taxes
183
+	 *
184
+	 * @param int $REG_ID
185
+	 * @param float $final_price
186
+	 * @param array $taxes
187
+	 * @return void
188
+	 */
189
+	protected function _apply_taxes($REG_ID = 0, $final_price = 0.00, $taxes = array())
190
+	{
191
+		if (is_array($taxes) && ! empty($taxes)) {
192
+			$total_taxes = 0;
193
+			foreach ($taxes as $tax) {
194
+				$total_taxes += $final_price * ( $tax->LIN_percent / 100 );
195
+			}
196
+			$final_price += $total_taxes;
197
+			$this->_update_registration_final_price($REG_ID, $final_price);
198
+		}
199
+	}
200
+
201
+
202
+
203
+	/**
204
+	 * _update_registration_final_price
205
+	 *
206
+	 * @param int $REG_ID
207
+	 * @param float $REG_final_price
208
+	 * @return void
209
+	 */
210
+	protected function _update_registration_final_price($REG_ID = 0, $REG_final_price = 0.00)
211
+	{
212
+		/** @type WPDB $wpdb */
213
+		global $wpdb;
214
+		$success = $wpdb->update(
215
+			$this->_old_table,
216
+			array( 'REG_final_price' => $REG_final_price ),  // data
217
+			array( 'REG_ID' => $REG_ID ),  // where
218
+			array( '%f' ),   // data format
219
+			array( '%d' )  // where format
220
+		);
221
+		if ($success === false) {
222
+			$this->add_error(
223
+				sprintf(
224
+					__('Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso'),
225
+					$REG_ID,
226
+					$wpdb->last_error
227
+				)
228
+			);
229
+		}
230
+	}
231 231
 }
Please login to merge, or discard this patch.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -22,9 +22,9 @@  discard block
 block discarded – undo
22 22
         global $wpdb;
23 23
         $this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso');
24 24
         // define tables
25
-        $this->_old_table               = $wpdb->prefix . 'esp_registration';
26
-        $this->_ticket_table            = $wpdb->prefix . 'esp_ticket';
27
-        $this->_line_item_table     = $wpdb->prefix . 'esp_line_item';
25
+        $this->_old_table               = $wpdb->prefix.'esp_registration';
26
+        $this->_ticket_table            = $wpdb->prefix.'esp_ticket';
27
+        $this->_line_item_table = $wpdb->prefix.'esp_line_item';
28 28
         parent::__construct();
29 29
     }
30 30
 
@@ -109,7 +109,7 @@  discard block
 block discarded – undo
109 109
         /** @type WPDB $wpdb */
110 110
         global $wpdb;
111 111
         // ensure all required values are present
112
-        if (! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) {
112
+        if ( ! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) {
113 113
             $this->add_error(
114 114
                 sprintf(
115 115
                     __('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'),
@@ -124,7 +124,7 @@  discard block
 block discarded – undo
124 124
         }
125 125
         // get tax subtotal
126 126
         $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']);
127
-        if (! $tax_subtotal_line_item_ID) {
127
+        if ( ! $tax_subtotal_line_item_ID) {
128 128
             $this->add_error(
129 129
                 sprintf(
130 130
                     __('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'),
@@ -191,7 +191,7 @@  discard block
 block discarded – undo
191 191
         if (is_array($taxes) && ! empty($taxes)) {
192 192
             $total_taxes = 0;
193 193
             foreach ($taxes as $tax) {
194
-                $total_taxes += $final_price * ( $tax->LIN_percent / 100 );
194
+                $total_taxes += $final_price * ($tax->LIN_percent / 100);
195 195
             }
196 196
             $final_price += $total_taxes;
197 197
             $this->_update_registration_final_price($REG_ID, $final_price);
@@ -213,10 +213,10 @@  discard block
 block discarded – undo
213 213
         global $wpdb;
214 214
         $success = $wpdb->update(
215 215
             $this->_old_table,
216
-            array( 'REG_final_price' => $REG_final_price ),  // data
217
-            array( 'REG_ID' => $REG_ID ),  // where
218
-            array( '%f' ),   // data format
219
-            array( '%d' )  // where format
216
+            array('REG_final_price' => $REG_final_price), // data
217
+            array('REG_ID' => $REG_ID), // where
218
+            array('%f'), // data format
219
+            array('%d')  // where format
220 220
         );
221 221
         if ($success === false) {
222 222
             $this->add_error(
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Unknown_1_0_0.core.php 1 patch
Indentation   +40 added lines, -40 removed lines patch added patch discarded remove patch
@@ -18,44 +18,44 @@
 block discarded – undo
18 18
 class EE_DMS_Unknown_1_0_0 extends EE_Data_Migration_Script_Base
19 19
 {
20 20
 
21
-    /**
22
-     * Returns whether or not this data migration script can operate on the given version of the database.
23
-     * Eg, if this migration script can migrate from 3.1.26 or higher (but not anything after 4.0.0), and
24
-     * it's passed a string like '3.1.38B', it should return true
25
-     *
26
-     * @param string $version_string
27
-     * @return boolean
28
-     */
29
-    public function can_migrate_from_version($version_string)
30
-    {
31
-        return false;
32
-    }
33
-
34
-    public function schema_changes_after_migration()
35
-    {
36
-        return;
37
-    }
38
-
39
-    public function schema_changes_before_migration()
40
-    {
41
-        return;
42
-    }
43
-
44
-
45
-    /**
46
-     * All children of this must call parent::__construct() at the end of their constructor or suffer the consequences!
47
-     *
48
-     * @param TableManager  $table_manager
49
-     * @param TableAnalysis $table_analysis
50
-     */
51
-    public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null)
52
-    {
53
-        $this->_migration_stages = array();
54
-        $this->_pretty_name = __("Fatal Uncatchable Error Occurred", "event_espresso");
55
-        parent::__construct($table_manager, $table_analysis);
56
-    }
57
-
58
-    public function migration_page_hooks()
59
-    {
60
-    }
21
+	/**
22
+	 * Returns whether or not this data migration script can operate on the given version of the database.
23
+	 * Eg, if this migration script can migrate from 3.1.26 or higher (but not anything after 4.0.0), and
24
+	 * it's passed a string like '3.1.38B', it should return true
25
+	 *
26
+	 * @param string $version_string
27
+	 * @return boolean
28
+	 */
29
+	public function can_migrate_from_version($version_string)
30
+	{
31
+		return false;
32
+	}
33
+
34
+	public function schema_changes_after_migration()
35
+	{
36
+		return;
37
+	}
38
+
39
+	public function schema_changes_before_migration()
40
+	{
41
+		return;
42
+	}
43
+
44
+
45
+	/**
46
+	 * All children of this must call parent::__construct() at the end of their constructor or suffer the consequences!
47
+	 *
48
+	 * @param TableManager  $table_manager
49
+	 * @param TableAnalysis $table_analysis
50
+	 */
51
+	public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null)
52
+	{
53
+		$this->_migration_stages = array();
54
+		$this->_pretty_name = __("Fatal Uncatchable Error Occurred", "event_espresso");
55
+		parent::__construct($table_manager, $table_analysis);
56
+	}
57
+
58
+	public function migration_page_hooks()
59
+	{
60
+	}
61 61
 }
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_7_0.dms.php 2 patches
Indentation   +180 added lines, -181 removed lines patch added patch discarded remove patch
@@ -9,7 +9,6 @@  discard block
 block discarded – undo
9 9
  * and recalculates esp_registration.REG_final_price to actually be the final price
10 10
  * for that registration (before this it was just the ticket's price, NOT including
11 11
  * taxes or other price modifiers)
12
-
13 12
  */
14 13
 // make sure we have all the stages loaded too
15 14
 // unfortunately, this needs to be done upon INCLUSION of this file,
@@ -18,9 +17,9 @@  discard block
 block discarded – undo
18 17
 $stages = glob(EE_CORE . 'data_migration_scripts/4_7_0_stages/*');
19 18
 $class_to_filepath = array();
20 19
 foreach ($stages as $filepath) {
21
-    $matches = array();
22
-    preg_match('~4_7_0_stages/(.*).dmsstage.php~', $filepath, $matches);
23
-    $class_to_filepath[ $matches[1] ] = $filepath;
20
+	$matches = array();
21
+	preg_match('~4_7_0_stages/(.*).dmsstage.php~', $filepath, $matches);
22
+	$class_to_filepath[ $matches[1] ] = $filepath;
24 23
 }
25 24
 // give addons a chance to autoload their stages too
26 25
 $class_to_filepath = apply_filters('FHEE__EE_DMS_4_7_0__autoloaded_stages', $class_to_filepath);
@@ -39,71 +38,71 @@  discard block
 block discarded – undo
39 38
 class EE_DMS_Core_4_7_0 extends EE_Data_Migration_Script_Base
40 39
 {
41 40
 
42
-    /**
43
-     * return EE_DMS_Core_4_7_0
44
-     *
45
-     * @param TableManager  $table_manager
46
-     * @param TableAnalysis $table_analysis
47
-     */
48
-    public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null)
49
-    {
50
-        $this->_pretty_name = __("Data Update to Event Espresso 4.7.0", "event_espresso");
51
-        $this->_priority = 10;
52
-        $this->_migration_stages = array(
53
-            new EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price(),
54
-            new EE_DMS_4_7_0_Registration_Payments(),
55
-        );
56
-        parent::__construct($table_manager, $table_analysis);
57
-    }
41
+	/**
42
+	 * return EE_DMS_Core_4_7_0
43
+	 *
44
+	 * @param TableManager  $table_manager
45
+	 * @param TableAnalysis $table_analysis
46
+	 */
47
+	public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null)
48
+	{
49
+		$this->_pretty_name = __("Data Update to Event Espresso 4.7.0", "event_espresso");
50
+		$this->_priority = 10;
51
+		$this->_migration_stages = array(
52
+			new EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price(),
53
+			new EE_DMS_4_7_0_Registration_Payments(),
54
+		);
55
+		parent::__construct($table_manager, $table_analysis);
56
+	}
58 57
 
59 58
 
60 59
 
61
-    /**
62
-     * @param array $version_array
63
-     * @return bool
64
-     */
65
-    public function can_migrate_from_version($version_array)
66
-    {
67
-        $version_string = $version_array['Core'];
68
-        if ((
69
-                version_compare($version_string, '4.7.0', '<=')
70
-                && version_compare($version_string, '4.6.0', '>=')
71
-            )
72
-            || (
73
-                version_compare($version_string, '4.7.0', '>=')
74
-                && ! $this->_get_table_analysis()->tableExists('esp_registration_payment')
75
-                && $this->_get_table_analysis()->tableExists('esp_registration')
76
-            )
77
-        ) {
78
-            return true;
79
-        } elseif (! $version_string) {
80
-            // no version string provided... this must be pre 4.3
81
-            return false;// changed mind. dont want people thinking they should migrate yet because they cant
82
-        } else {
83
-            return false;
84
-        }
85
-    }
60
+	/**
61
+	 * @param array $version_array
62
+	 * @return bool
63
+	 */
64
+	public function can_migrate_from_version($version_array)
65
+	{
66
+		$version_string = $version_array['Core'];
67
+		if ((
68
+				version_compare($version_string, '4.7.0', '<=')
69
+				&& version_compare($version_string, '4.6.0', '>=')
70
+			)
71
+			|| (
72
+				version_compare($version_string, '4.7.0', '>=')
73
+				&& ! $this->_get_table_analysis()->tableExists('esp_registration_payment')
74
+				&& $this->_get_table_analysis()->tableExists('esp_registration')
75
+			)
76
+		) {
77
+			return true;
78
+		} elseif (! $version_string) {
79
+			// no version string provided... this must be pre 4.3
80
+			return false;// changed mind. dont want people thinking they should migrate yet because they cant
81
+		} else {
82
+			return false;
83
+		}
84
+	}
86 85
 
87 86
 
88 87
 
89
-    /**
90
-     * @return bool
91
-     */
92
-    public function schema_changes_before_migration()
93
-    {
94
-        // relies on 4.1's EEH_Activation::create_table
95
-        require_once(EE_HELPERS . 'EEH_Activation.helper.php');
96
-        $table_name = 'esp_answer';
97
-        $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
88
+	/**
89
+	 * @return bool
90
+	 */
91
+	public function schema_changes_before_migration()
92
+	{
93
+		// relies on 4.1's EEH_Activation::create_table
94
+		require_once(EE_HELPERS . 'EEH_Activation.helper.php');
95
+		$table_name = 'esp_answer';
96
+		$sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
98 97
 					REG_ID INT UNSIGNED NOT NULL,
99 98
 					QST_ID INT UNSIGNED NOT NULL,
100 99
 					ANS_value TEXT NOT NULL,
101 100
 					PRIMARY KEY  (ANS_ID),
102 101
 					KEY REG_ID (REG_ID),
103 102
 					KEY QST_ID (QST_ID)";
104
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
105
-        $table_name = 'esp_attendee_meta';
106
-        $sql = "ATTM_ID INT(10) UNSIGNED NOT	NULL AUTO_INCREMENT,
103
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
104
+		$table_name = 'esp_attendee_meta';
105
+		$sql = "ATTM_ID INT(10) UNSIGNED NOT	NULL AUTO_INCREMENT,
107 106
 						ATT_ID BIGINT(20) UNSIGNED NOT NULL,
108 107
 						ATT_fname VARCHAR(45) NOT NULL,
109 108
 						ATT_lname VARCHAR(45) NOT	NULL,
@@ -120,9 +119,9 @@  discard block
 block discarded – undo
120 119
 								KEY ATT_email (ATT_email),
121 120
 								KEY ATT_lname (ATT_lname),
122 121
 								KEY ATT_fname (ATT_fname)";
123
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
124
-        $table_name = 'esp_country';
125
-        $sql = "CNT_ISO VARCHAR(2) COLLATE utf8_bin NOT NULL,
122
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
123
+		$table_name = 'esp_country';
124
+		$sql = "CNT_ISO VARCHAR(2) COLLATE utf8_bin NOT NULL,
126 125
 					  CNT_ISO3 VARCHAR(3) COLLATE utf8_bin NOT NULL,
127 126
 					  RGN_ID TINYINT(3) UNSIGNED DEFAULT NULL,
128 127
 					  CNT_name VARCHAR(45) COLLATE utf8_bin NOT NULL,
@@ -138,25 +137,25 @@  discard block
 block discarded – undo
138 137
 					  CNT_is_EU TINYINT(1) DEFAULT '0',
139 138
 					  CNT_active TINYINT(1) DEFAULT '0',
140 139
 					  PRIMARY KEY  (CNT_ISO)";
141
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
142
-        $table_name = 'esp_currency';
143
-        $sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL,
140
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
141
+		$table_name = 'esp_currency';
142
+		$sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL,
144 143
 				CUR_single VARCHAR(45) COLLATE utf8_bin DEFAULT 'dollar',
145 144
 				CUR_plural VARCHAR(45) COLLATE utf8_bin DEFAULT 'dollars',
146 145
 				CUR_sign VARCHAR(45) COLLATE utf8_bin DEFAULT '$',
147 146
 				CUR_dec_plc VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT '2',
148 147
 				CUR_active TINYINT(1) DEFAULT '0',
149 148
 				PRIMARY KEY  (CUR_code)";
150
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
151
-        $table_name = 'esp_currency_payment_method';
152
-        $sql = "CPM_ID INT(11) NOT NULL AUTO_INCREMENT,
149
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
150
+		$table_name = 'esp_currency_payment_method';
151
+		$sql = "CPM_ID INT(11) NOT NULL AUTO_INCREMENT,
153 152
 				CUR_code  VARCHAR(6) COLLATE utf8_bin NOT NULL,
154 153
 				PMD_ID INT(11) NOT NULL,
155 154
 				PRIMARY KEY  (CPM_ID),
156 155
 				KEY PMD_ID (PMD_ID)";
157
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
158
-        $table_name = 'esp_datetime';
159
-        $sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
156
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
157
+		$table_name = 'esp_datetime';
158
+		$sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
160 159
 				  EVT_ID BIGINT(20) UNSIGNED NOT NULL,
161 160
 				  DTT_name VARCHAR(255) NOT NULL DEFAULT '',
162 161
 				  DTT_description TEXT NOT NULL,
@@ -172,9 +171,9 @@  discard block
 block discarded – undo
172 171
 						KEY DTT_EVT_start (DTT_EVT_start),
173 172
 						KEY EVT_ID (EVT_ID),
174 173
 						KEY DTT_is_primary (DTT_is_primary)";
175
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
176
-        $table_name = 'esp_event_meta';
177
-        $sql = "
174
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
175
+		$table_name = 'esp_event_meta';
176
+		$sql = "
178 177
 			EVTM_ID INT NOT NULL AUTO_INCREMENT,
179 178
 			EVT_ID BIGINT(20) UNSIGNED NOT NULL,
180 179
 			EVT_display_desc TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
@@ -190,34 +189,34 @@  discard block
 block discarded – undo
190 189
 			EVT_donations TINYINT(1) NULL,
191 190
 			PRIMARY KEY  (EVTM_ID),
192 191
 			KEY EVT_ID (EVT_ID)";
193
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
194
-        $table_name = 'esp_event_question_group';
195
-        $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
192
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
193
+		$table_name = 'esp_event_question_group';
194
+		$sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
196 195
 					EVT_ID BIGINT(20) UNSIGNED NOT NULL,
197 196
 					QSG_ID INT UNSIGNED NOT NULL,
198 197
 					EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
199 198
 					PRIMARY KEY  (EQG_ID),
200 199
 					KEY EVT_ID (EVT_ID),
201 200
 					KEY QSG_ID (QSG_ID)";
202
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
203
-        $table_name = 'esp_event_venue';
204
-        $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
201
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
202
+		$table_name = 'esp_event_venue';
203
+		$sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
205 204
 				EVT_ID BIGINT(20) UNSIGNED NOT NULL,
206 205
 				VNU_ID BIGINT(20) UNSIGNED NOT NULL,
207 206
 				EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
208 207
 				PRIMARY KEY  (EVV_ID)";
209
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
210
-        $table_name = 'esp_extra_meta';
211
-        $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
208
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
209
+		$table_name = 'esp_extra_meta';
210
+		$sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
212 211
 				OBJ_ID INT(11) DEFAULT NULL,
213 212
 				EXM_type VARCHAR(45) DEFAULT NULL,
214 213
 				EXM_key VARCHAR(45) DEFAULT NULL,
215 214
 				EXM_value TEXT,
216 215
 				PRIMARY KEY  (EXM_ID),
217 216
 				KEY EXM_type (EXM_type, OBJ_ID, EXM_key(45))";
218
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
219
-        $table_name = 'esp_line_item';
220
-        $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
217
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
218
+		$table_name = 'esp_line_item';
219
+		$sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
221 220
 				LIN_code VARCHAR(245) NOT NULL DEFAULT '',
222 221
 				TXN_ID INT(11) DEFAULT NULL,
223 222
 				LIN_name VARCHAR(245) NOT NULL DEFAULT '',
@@ -235,9 +234,9 @@  discard block
 block discarded – undo
235 234
 				PRIMARY KEY  (LIN_ID),
236 235
 				KEY LIN_code (LIN_code(191)),
237 236
 				KEY TXN_ID (TXN_ID)";
238
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
239
-        $table_name = 'esp_log';
240
-        $sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT,
237
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
238
+		$table_name = 'esp_log';
239
+		$sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT,
241 240
 				LOG_time DATETIME DEFAULT NULL,
242 241
 				OBJ_ID VARCHAR(45) DEFAULT NULL,
243 242
 				OBJ_type VARCHAR(45) DEFAULT NULL,
@@ -248,18 +247,18 @@  discard block
 block discarded – undo
248 247
 				KEY LOG_time (LOG_time),
249 248
 				KEY OBJ (OBJ_type,OBJ_ID),
250 249
 				KEY LOG_type (LOG_type)";
251
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
252
-        $table_name = 'esp_message_template';
253
-        $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
250
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
251
+		$table_name = 'esp_message_template';
252
+		$sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
254 253
 					GRP_ID INT(10) UNSIGNED NOT NULL,
255 254
 					MTP_context VARCHAR(50) NOT NULL,
256 255
 					MTP_template_field VARCHAR(30) NOT NULL,
257 256
 					MTP_content TEXT NOT NULL,
258 257
 					PRIMARY KEY  (MTP_ID),
259 258
 					KEY GRP_ID (GRP_ID)";
260
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
261
-        $table_name = 'esp_message_template_group';
262
-        $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
259
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
260
+		$table_name = 'esp_message_template_group';
261
+		$sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
263 262
 					MTP_user_id INT(10) NOT NULL DEFAULT '1',
264 263
 					MTP_name VARCHAR(245) NOT NULL DEFAULT '',
265 264
 					MTP_description VARCHAR(245) NOT NULL DEFAULT '',
@@ -271,17 +270,17 @@  discard block
 block discarded – undo
271 270
 					MTP_is_active TINYINT(1) NOT NULL DEFAULT '1',
272 271
 					PRIMARY KEY  (GRP_ID),
273 272
 					KEY MTP_user_id (MTP_user_id)";
274
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
275
-        $table_name = 'esp_event_message_template';
276
-        $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
273
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
274
+		$table_name = 'esp_event_message_template';
275
+		$sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
277 276
 					EVT_ID BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
278 277
 					GRP_ID INT(10) UNSIGNED NOT NULL DEFAULT 0,
279 278
 					PRIMARY KEY  (EMT_ID),
280 279
 					KEY EVT_ID (EVT_ID),
281 280
 					KEY GRP_ID (GRP_ID)";
282
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
283
-        $table_name = 'esp_payment';
284
-        $sql = "PAY_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
281
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
282
+		$table_name = 'esp_payment';
283
+		$sql = "PAY_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
285 284
 					TXN_ID INT(10) UNSIGNED DEFAULT NULL,
286 285
 					STS_ID VARCHAR(3) COLLATE utf8_bin DEFAULT NULL,
287 286
 					PAY_timestamp DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -298,9 +297,9 @@  discard block
 block discarded – undo
298 297
 					PRIMARY KEY  (PAY_ID),
299 298
 					KEY PAY_timestamp (PAY_timestamp),
300 299
 					KEY TXN_ID (TXN_ID)";
301
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB ');
302
-        $table_name = 'esp_payment_method';
303
-        $sql = "PMD_ID INT(11) NOT NULL AUTO_INCREMENT,
300
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB ');
301
+		$table_name = 'esp_payment_method';
302
+		$sql = "PMD_ID INT(11) NOT NULL AUTO_INCREMENT,
304 303
 				PMD_type VARCHAR(124) DEFAULT NULL,
305 304
 				PMD_name VARCHAR(255) DEFAULT NULL,
306 305
 				PMD_desc TEXT,
@@ -316,32 +315,32 @@  discard block
 block discarded – undo
316 315
 				PRIMARY KEY  (PMD_ID),
317 316
 				UNIQUE KEY PMD_slug_UNIQUE (PMD_slug),
318 317
 				KEY PMD_type (PMD_type)";
319
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
320
-        $table_name = "esp_ticket_price";
321
-        $sql = "TKP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
318
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
319
+		$table_name = "esp_ticket_price";
320
+		$sql = "TKP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
322 321
 					  TKT_ID INT(10) UNSIGNED NOT NULL,
323 322
 					  PRC_ID INT(10) UNSIGNED NOT NULL,
324 323
 					  PRIMARY KEY  (TKP_ID),
325 324
 					  KEY TKT_ID (TKT_ID),
326 325
 					  KEY PRC_ID (PRC_ID)";
327
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
328
-        $table_name = "esp_datetime_ticket";
329
-        $sql = "DTK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
326
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
327
+		$table_name = "esp_datetime_ticket";
328
+		$sql = "DTK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
330 329
 					  DTT_ID INT(10) UNSIGNED NOT NULL,
331 330
 					  TKT_ID INT(10) UNSIGNED NOT NULL,
332 331
 					  PRIMARY KEY  (DTK_ID),
333 332
 					  KEY DTT_ID (DTT_ID),
334 333
 					  KEY TKT_ID (TKT_ID)";
335
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
336
-        $table_name = "esp_ticket_template";
337
-        $sql = "TTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
334
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
335
+		$table_name = "esp_ticket_template";
336
+		$sql = "TTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
338 337
 					  TTM_name VARCHAR(45) NOT NULL,
339 338
 					  TTM_description TEXT,
340 339
 					  TTM_file VARCHAR(45),
341 340
 					  PRIMARY KEY  (TTM_ID)";
342
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
343
-        $table_name = 'esp_question';
344
-        $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
341
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
342
+		$table_name = 'esp_question';
343
+		$sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
345 344
 					QST_display_text TEXT NOT NULL,
346 345
 					QST_admin_label VARCHAR(255) NOT NULL,
347 346
 					QST_system VARCHAR(25) DEFAULT NULL,
@@ -354,18 +353,18 @@  discard block
 block discarded – undo
354 353
 					QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0,
355 354
 					PRIMARY KEY  (QST_ID),
356 355
 					KEY QST_order (QST_order)';
357
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
358
-        $table_name = 'esp_question_group_question';
359
-        $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
356
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
357
+		$table_name = 'esp_question_group_question';
358
+		$sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
360 359
 					QSG_ID INT UNSIGNED NOT NULL,
361 360
 					QST_ID INT UNSIGNED NOT NULL,
362 361
 					QGQ_order INT UNSIGNED NOT NULL DEFAULT 0,
363 362
 					PRIMARY KEY  (QGQ_ID),
364 363
 					KEY QST_ID (QST_ID),
365 364
 					KEY QSG_ID_order (QSG_ID, QGQ_order)";
366
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
367
-        $table_name = 'esp_question_option';
368
-        $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
365
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
366
+		$table_name = 'esp_question_option';
367
+		$sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
369 368
 					QSO_value VARCHAR(255) NOT NULL,
370 369
 					QSO_desc TEXT NOT NULL,
371 370
 					QST_ID INT UNSIGNED NOT NULL,
@@ -374,9 +373,9 @@  discard block
 block discarded – undo
374 373
 					PRIMARY KEY  (QSO_ID),
375 374
 					KEY QST_ID (QST_ID),
376 375
 					KEY QSO_order (QSO_order)";
377
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
378
-        $table_name = 'esp_registration';
379
-        $sql = "REG_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
376
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
377
+		$table_name = 'esp_registration';
378
+		$sql = "REG_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
380 379
 					  EVT_ID BIGINT(20) UNSIGNED NOT NULL,
381 380
 					  ATT_ID BIGINT(20) UNSIGNED NOT NULL,
382 381
 					  TXN_ID INT(10) UNSIGNED NOT NULL,
@@ -400,18 +399,18 @@  discard block
 block discarded – undo
400 399
 					  KEY TKT_ID (TKT_ID),
401 400
 					  KEY EVT_ID (EVT_ID),
402 401
 					  KEY STS_ID (STS_ID)";
403
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
404
-        $table_name = 'esp_registration_payment';
405
-        $sql = "RPY_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
402
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
403
+		$table_name = 'esp_registration_payment';
404
+		$sql = "RPY_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
406 405
 					  REG_ID INT(10) UNSIGNED NOT NULL,
407 406
 					  PAY_ID INT(10) UNSIGNED NULL,
408 407
 					  RPY_amount DECIMAL(10,3) NOT NULL DEFAULT '0.00',
409 408
 					  PRIMARY KEY  (RPY_ID),
410 409
 					  KEY REG_ID (REG_ID),
411 410
 					  KEY PAY_ID (PAY_ID)";
412
-        $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
413
-        $table_name = 'esp_checkin';
414
-        $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
411
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB ');
412
+		$table_name = 'esp_checkin';
413
+		$sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
415 414
 					REG_ID INT(10) UNSIGNED NOT NULL,
416 415
 					DTT_ID INT(10) UNSIGNED NOT NULL,
417 416
 					CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
@@ -419,9 +418,9 @@  discard block
 block discarded – undo
419 418
 					PRIMARY KEY  (CHK_ID),
420 419
 					KEY REG_ID (REG_ID),
421 420
 					KEY DTT_ID (DTT_ID)";
422
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
423
-        $table_name = 'esp_state';
424
-        $sql = "STA_ID smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
421
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
422
+		$table_name = 'esp_state';
423
+		$sql = "STA_ID smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
425 424
 					  CNT_ISO VARCHAR(2) COLLATE utf8_bin NOT NULL,
426 425
 					  STA_abbrev VARCHAR(24) COLLATE utf8_bin NOT NULL,
427 426
 					  STA_name VARCHAR(100) COLLATE utf8_bin NOT NULL,
@@ -429,9 +428,9 @@  discard block
 block discarded – undo
429 428
 					  PRIMARY KEY  (STA_ID),
430 429
 					  KEY STA_abbrev (STA_abbrev),
431 430
 					  KEY CNT_ISO (CNT_ISO)";
432
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
433
-        $table_name = 'esp_status';
434
-        $sql = "STS_ID VARCHAR(3) COLLATE utf8_bin NOT NULL,
431
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
432
+		$table_name = 'esp_status';
433
+		$sql = "STS_ID VARCHAR(3) COLLATE utf8_bin NOT NULL,
435 434
 					  STS_code VARCHAR(45) COLLATE utf8_bin NOT NULL,
436 435
 					  STS_type set('event','registration','transaction','payment','email') COLLATE utf8_bin NOT NULL,
437 436
 					  STS_can_edit TINYINT(1) NOT NULL DEFAULT 0,
@@ -439,9 +438,9 @@  discard block
 block discarded – undo
439 438
 					  STS_open TINYINT(1) NOT NULL DEFAULT 1,
440 439
 					  UNIQUE KEY STS_ID_UNIQUE (STS_ID),
441 440
 					  KEY STS_type (STS_type)";
442
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
443
-        $table_name = 'esp_transaction';
444
-        $sql = "TXN_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
441
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
442
+		$table_name = 'esp_transaction';
443
+		$sql = "TXN_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
445 444
 					  TXN_timestamp DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
446 445
 					  TXN_total DECIMAL(10,3) DEFAULT '0.00',
447 446
 					  TXN_paid DECIMAL(10,3) NOT NULL DEFAULT '0.00',
@@ -453,9 +452,9 @@  discard block
 block discarded – undo
453 452
 					  PRIMARY KEY  (TXN_ID),
454 453
 					  KEY TXN_timestamp (TXN_timestamp),
455 454
 					  KEY STS_ID (STS_ID)";
456
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
457
-        $table_name = 'esp_venue_meta';
458
-        $sql = "VNUM_ID INT(11) NOT NULL AUTO_INCREMENT,
455
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB');
456
+		$table_name = 'esp_venue_meta';
457
+		$sql = "VNUM_ID INT(11) NOT NULL AUTO_INCREMENT,
459 458
 			VNU_ID BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
460 459
 			VNU_address VARCHAR(255) DEFAULT NULL,
461 460
 			VNU_address2 VARCHAR(255) DEFAULT NULL,
@@ -474,10 +473,10 @@  discard block
 block discarded – undo
474 473
 			KEY VNU_ID (VNU_ID),
475 474
 			KEY STA_ID (STA_ID),
476 475
 			KEY CNT_ISO (CNT_ISO)";
477
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
478
-        // modified tables
479
-        $table_name = "esp_price";
480
-        $sql = "PRC_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
476
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
477
+		// modified tables
478
+		$table_name = "esp_price";
479
+		$sql = "PRC_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
481 480
 					  PRT_ID TINYINT(3) UNSIGNED NOT NULL,
482 481
 					  PRC_amount DECIMAL(10,3) NOT NULL DEFAULT '0.00',
483 482
 					  PRC_name VARCHAR(245) NOT NULL,
@@ -490,9 +489,9 @@  discard block
 block discarded – undo
490 489
 					  PRC_parent INT(10) UNSIGNED DEFAULT 0,
491 490
 					  PRIMARY KEY  (PRC_ID),
492 491
 					  KEY PRT_ID (PRT_ID)";
493
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
494
-        $table_name = "esp_price_type";
495
-        $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
492
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
493
+		$table_name = "esp_price_type";
494
+		$sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
496 495
 				  PRT_name VARCHAR(45) NOT NULL,
497 496
 				  PBT_ID TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
498 497
 				  PRT_is_percent TINYINT(1) NOT NULL DEFAULT '0',
@@ -501,9 +500,9 @@  discard block
 block discarded – undo
501 500
 				  PRT_deleted TINYINT(1) NOT NULL DEFAULT '0',
502 501
 				  UNIQUE KEY PRT_name_UNIQUE (PRT_name),
503 502
 				  PRIMARY KEY  (PRT_ID)";
504
-        $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB ');
505
-        $table_name = "esp_ticket";
506
-        $sql = "TKT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
503
+		$this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB ');
504
+		$table_name = "esp_ticket";
505
+		$sql = "TKT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
507 506
 					  TTM_ID INT(10) UNSIGNED NOT NULL,
508 507
 					  TKT_name VARCHAR(245) NOT NULL DEFAULT '',
509 508
 					  TKT_description TEXT NOT NULL,
@@ -525,9 +524,9 @@  discard block
 block discarded – undo
525 524
 					  TKT_deleted TINYINT(1) NOT NULL DEFAULT '0',
526 525
 					  PRIMARY KEY  (TKT_ID),
527 526
 					  KEY TKT_start_date (TKT_start_date)";
528
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
529
-        $table_name = 'esp_question_group';
530
-        $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
527
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
528
+		$table_name = 'esp_question_group';
529
+		$sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
531 530
 					QSG_name VARCHAR(255) NOT NULL,
532 531
 					QSG_identifier VARCHAR(100) NOT NULL,
533 532
 					QSG_desc TEXT NULL,
@@ -540,38 +539,38 @@  discard block
 block discarded – undo
540 539
 					PRIMARY KEY  (QSG_ID),
541 540
 					UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier),
542 541
 					KEY QSG_order (QSG_order)';
543
-        $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
544
-        /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */
545
-        $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0');
546
-        // (because many need to convert old string states to foreign keys into the states table)
547
-        $script_4_1_defaults->insert_default_states();
548
-        $script_4_1_defaults->insert_default_countries();
549
-        /** @var EE_DMS_Core_4_5_0 $script_4_5_defaults */
550
-        $script_4_5_defaults = EE_Registry::instance()->load_dms('Core_4_5_0');
551
-        $script_4_5_defaults->insert_default_price_types();
552
-        $script_4_5_defaults->insert_default_prices();
553
-        $script_4_5_defaults->insert_default_tickets();
554
-        /** @var EE_DMS_Core_4_6_0 $script_4_6_defaults */
555
-        $script_4_6_defaults = EE_Registry::instance()->load_dms('Core_4_6_0');
556
-        $script_4_6_defaults->add_default_admin_only_payments();
557
-        $script_4_6_defaults->insert_default_currencies();
558
-        return true;
559
-    }
542
+		$this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
543
+		/** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */
544
+		$script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0');
545
+		// (because many need to convert old string states to foreign keys into the states table)
546
+		$script_4_1_defaults->insert_default_states();
547
+		$script_4_1_defaults->insert_default_countries();
548
+		/** @var EE_DMS_Core_4_5_0 $script_4_5_defaults */
549
+		$script_4_5_defaults = EE_Registry::instance()->load_dms('Core_4_5_0');
550
+		$script_4_5_defaults->insert_default_price_types();
551
+		$script_4_5_defaults->insert_default_prices();
552
+		$script_4_5_defaults->insert_default_tickets();
553
+		/** @var EE_DMS_Core_4_6_0 $script_4_6_defaults */
554
+		$script_4_6_defaults = EE_Registry::instance()->load_dms('Core_4_6_0');
555
+		$script_4_6_defaults->add_default_admin_only_payments();
556
+		$script_4_6_defaults->insert_default_currencies();
557
+		return true;
558
+	}
560 559
 
561 560
 
562 561
 
563
-    /**
564
-     * @return boolean
565
-     */
566
-    public function schema_changes_after_migration()
567
-    {
568
-        return true;
569
-    }
562
+	/**
563
+	 * @return boolean
564
+	 */
565
+	public function schema_changes_after_migration()
566
+	{
567
+		return true;
568
+	}
570 569
 
571 570
 
572 571
 
573
-    public function migration_page_hooks()
574
-    {
575
-    }
572
+	public function migration_page_hooks()
573
+	{
574
+	}
576 575
 }
577 576
 // end of file: /core/data_migration_scripts/EE_DMS_Core_4_7_0.dms.php
Please login to merge, or discard this patch.
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -15,12 +15,12 @@  discard block
 block discarded – undo
15 15
 // unfortunately, this needs to be done upon INCLUSION of this file,
16 16
 // instead of construction, because it only gets constructed on first page load
17 17
 // (all other times it gets resurrected from a wordpress option)
18
-$stages = glob(EE_CORE . 'data_migration_scripts/4_7_0_stages/*');
18
+$stages = glob(EE_CORE.'data_migration_scripts/4_7_0_stages/*');
19 19
 $class_to_filepath = array();
20 20
 foreach ($stages as $filepath) {
21 21
     $matches = array();
22 22
     preg_match('~4_7_0_stages/(.*).dmsstage.php~', $filepath, $matches);
23
-    $class_to_filepath[ $matches[1] ] = $filepath;
23
+    $class_to_filepath[$matches[1]] = $filepath;
24 24
 }
25 25
 // give addons a chance to autoload their stages too
26 26
 $class_to_filepath = apply_filters('FHEE__EE_DMS_4_7_0__autoloaded_stages', $class_to_filepath);
@@ -76,9 +76,9 @@  discard block
 block discarded – undo
76 76
             )
77 77
         ) {
78 78
             return true;
79
-        } elseif (! $version_string) {
79
+        } elseif ( ! $version_string) {
80 80
             // no version string provided... this must be pre 4.3
81
-            return false;// changed mind. dont want people thinking they should migrate yet because they cant
81
+            return false; // changed mind. dont want people thinking they should migrate yet because they cant
82 82
         } else {
83 83
             return false;
84 84
         }
@@ -92,7 +92,7 @@  discard block
 block discarded – undo
92 92
     public function schema_changes_before_migration()
93 93
     {
94 94
         // relies on 4.1's EEH_Activation::create_table
95
-        require_once(EE_HELPERS . 'EEH_Activation.helper.php');
95
+        require_once(EE_HELPERS.'EEH_Activation.helper.php');
96 96
         $table_name = 'esp_answer';
97 97
         $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
98 98
 					REG_ID INT UNSIGNED NOT NULL,
Please login to merge, or discard this patch.