better-payment / includes / Classes / Migrator.php

Migrator.php in Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More 2.4.1, at includes/Classes/Migrator.php

79 lines 2.4 KB

Raw Download Zip

1	<?php
2
3	namespace Better_Payment\Lite\Classes;
4
5	/**
6	* Exit if accessed directly
7	*/
8	if (!defined('ABSPATH')) {
9	exit;
10	}
11
12	/**
13	* The plugin migrator class
14	*
15	* @since 0.0.2
16	*/
17	class Migrator
18	{
19
20	/**
21	* Initialize the plugin
22	*
23	* @since 0.0.2
24	*/
25	public static function migrator() {
26	self::create_missing_tables();
27	self::update_tables();
28	}
29
30	/**
31	* Create any table added since this install was activated (dbDelta is
32	* idempotent). The migrator only runs once per version change, so an
33	* existing install picks up e.g. the better_payment_subscription_order table
34	* on its first load after an update — activation never re-runs there.
35	*
36	* Kept separate from update_tables(), which stays ALTER-only: the test
37	* environment rewrites CREATE TABLE to CREATE TEMPORARY TABLE, so a
38	* create inside a column-migration test would shadow the real table.
39	*
40	* @since 2.4.0
41	*/
42	public static function create_missing_tables() {
43	( new \Better_Payment\Lite\Installer() )->create_tables();
44	}
45
46	/**
47	* Update the plugin tables
48	*
49	* @since 0.0.2
50	*/
51	public static function update_tables() {
52	//Add column
53	// `refund_info` is Pro's: only Pro's refunds write it, and Better Payment Pro
54	// 1.4.4+ adds the column itself (Pro Installer::add_refund_info_column()). Lite
55	// still adds it, idempotently, as a data guard for Pro 1.4.3: that Pro relies
56	// on Lite for it, and on a fresh install its refund would reach the gateway
57	// and then fail to record, leaving a refunded row marked paid. Stop once no
58	// supported site can run Pro 1.4.3.
59	self::add_column( 'refund_info', 'longtext' );
60	self::add_column( 'campaign_id', 'text' );
61	}
62
63	private static function add_column( $column_name, $column_type ) {
64	global $wpdb;
65	$wpdb->hide_errors();
66	$table_name = "{$wpdb->prefix}better_payment";
67
68	// $row = $wpdb->get_results( "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name' AND column_name = '$column_name'" );
69
70	$columns = $wpdb->get_col( "DESC $table_name", 0 );
71
72	if (in_array($column_name, $columns)) {
73	return;
74	}
75
76	$wpdb->query($wpdb->prepare("ALTER TABLE $table_name ADD $column_name $column_type"));
77	}
78	}
79