class-give-db-sequential-ordering.php — GiveWP – Donation Plugin and Fundraising Platform 2.2.0

give / includes / class-give-db-sequential-ordering.php

give / includes Last commit date

class-give-db-sequential-ordering.php

149 lines

1	<?php
2	/**
3	* Sequential Donation DB
4	*
5	* @package Give
6	* @subpackage Classes/Give_DB_Sequential_Ordering
7	* @copyright Copyright (c) 2018, WordImpress
8	* @license https://opensource.org/licenses/gpl-license GNU Public License
9	* @since 2.1.0
10	*/
11
12	// Exit if accessed directly.
13	if ( ! defined( 'ABSPATH' ) ) {
14	exit;
15	}
16
17	/**
18	* Give_DB_Sequential_Ordering Class
19	*
20	* This class is for interacting with the sequential donation database table.
21	*
22	* @since 2.1.0
23	*/
24	class Give_DB_Sequential_Ordering extends Give_DB {
25
26	/**
27	* Give_DB_Sequential_Ordering constructor.
28	*
29	* Set up the Give DB Donor class.
30	*
31	* @since 2.1.0
32	* @access public
33	*/
34	public function __construct() {
35	/* @var WPDB $wpdb */
36	global $wpdb;
37
38	$this->table_name = $wpdb->prefix . 'give_sequential_ordering';
39	$this->primary_key = 'id';
40	$this->version = '1.0';
41
42	// Install table.
43	$this->register_table();
44
45	parent::__construct();
46	}
47
48	/**
49	* Get columns and formats
50	*
51	* @since 2.1.0
52	* @access public
53	*
54	* @return array Columns and formats.
55	*/
56	public function get_columns() {
57	return array(
58	'id' => '%d',
59	'payment_id' => '%s',
60	);
61	}
62
63	/**
64	* Get default column values
65	*
66	* @since 2.1.0
67	* @access public
68	*
69	* @return array Default column values.
70	*/
71	public function get_column_defaults() {
72	return array(
73	'id' => 0,
74	'payment_id' => '',
75	);
76	}
77
78
79	/**
80	* Create the table
81	*
82	* @since 2.1.0
83	* @access public
84	*
85	* @return void
86	*/
87	public function create_table() {
88	global $wpdb;
89	$charset_collate = $wpdb->get_charset_collate();
90
91	// Calculate auto increment number.
92	$payment_ID = $wpdb->get_var(
93	$wpdb->prepare(
94	"
95	SELECT ID
96	FROM $wpdb->posts
97	WHERE post_type=%s
98	ORDER By ID desc
99	LIMIT 1
100	",
101	'give_payment'
102	)
103	);
104
105	$sql = "CREATE TABLE {$this->table_name} (
106	id bigint(20) NOT NULL AUTO_INCREMENT,
107	payment_id bigint(20) NOT NULL,
108	PRIMARY KEY (id)
109	) {$charset_collate};";
110
111	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
112	dbDelta( $sql );
113
114	if ( ! empty( $payment_ID ) ) {
115	$auto_increment = $payment_ID + 1;
116	$wpdb->query( "ALTER TABLE {$this->table_name} AUTO_INCREMENT={$auto_increment};" );
117	give_update_option( 'sequential-ordering_number', $auto_increment );
118	} else {
119	give_update_option( 'sequential-ordering_number', 1 );
120	}
121
122	update_option( $this->table_name . '_db_version', $this->version, false );
123	}
124
125
126	/**
127	* Get id auto increment next value.
128	*
129	* @since 2.1.0
130	* @return null\|string
131	*/
132	public function get_id_auto_increment_val() {
133	global $wpdb;
134
135	return $wpdb->get_var(
136	$wpdb->prepare(
137	"
138	SELECT AUTO_INCREMENT
139	FROM INFORMATION_SCHEMA.TABLES
140	WHERE TABLE_SCHEMA=%s
141	AND TABLE_NAME=%s
142	",
143	DB_NAME,
144	$this->table_name
145	)
146	);
147	}
148	}
149