booktics / base / installer.php

installer.php in Booktics – Appointment Booking Calendar for Service Businesses 1.0.0, at base/installer.php

193 lines 7.9 KB

Raw Download Zip

1	<?php
2
3	namespace Booktics;
4
5	use Booktics\Dummy_Data\Dummy_Data_Manager;
6
7	class Installer {
8	/**
9	* Initializes the Booktics plugin by performing necessary setup tasks.
10	*
11	* This method performs the following setup operations:
12	* - Creates or updates required database tables
13	* - Initializes user roles and capabilities
14	* - Generates initial onboarding data using dummy data manager
15	*/
16	public static function run(): void {
17	self::create_tables();
18	( new Role() )->init();
19	( new Dummy_Data_Manager() )->generate_onboarding_data();
20	}
21
22	/**
23	* Creates and updates database tables required for the Booktics plugin.
24	*
25	* Creates the following tables if they don't exist:
26	* - booktics_schedules: Stores scheduling information for team members and services
27	* - booktics_carts: Stores shopping cart information
28	* - booktics_cart_items: Stores individual items in shopping carts
29	* - booktics_orders: Stores order information and payment details
30	* - booktics_payments: Stores payment transaction records
31	*
32	* Also handles table structure updates by adding missing columns to existing tables
33	* and performing necessary column modifications.
34	*/
35	private static function create_tables(): void {
36	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
37
38	global $wpdb;
39	$charset_collate = $wpdb->get_charset_collate();
40
41	$table_schema = array(
42	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}booktics_schedules (
43	id mediumint(9) NOT NULL AUTO_INCREMENT,
44	team_member_id int(11) NOT NULL,
45	service_id int(11) NOT NULL,
46	location_id int(11) NOT NULL,
47	start_time varchar(100) NOT NULL,
48	end_time varchar(100) NOT NULL,
49	week_day varchar(100) NOT NULL,
50	custom_date varchar(100) NOT NULL,
51	created_at datetime DEFAULT NULL,
52	updated_at datetime DEFAULT NULL,
53	PRIMARY KEY (id)
54	) $charset_collate;",
55
56	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}booktics_carts (
57	id mediumint(9) NOT NULL AUTO_INCREMENT,
58	uuid varchar(36) NOT NULL,
59	user_id int(11) NOT NULL,
60	coupon_code varchar(100) DEFAULT NULL,
61	total decimal(10,2) DEFAULT NULL,
62	created_at datetime DEFAULT NULL,
63	updated_at datetime DEFAULT NULL,
64	PRIMARY KEY (id)
65	) $charset_collate;",
66
67	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}booktics_cart_items (
68	id mediumint(9) NOT NULL AUTO_INCREMENT,
69	uuid varchar(36) NOT NULL,
70	cart_id mediumint(9) NOT NULL,
71	team_member_id int(11) DEFAULT NULL,
72	service_id int(11) DEFAULT NULL,
73	date date DEFAULT NULL,
74	start_time varchar(100) DEFAULT NULL,
75	end_time varchar(100) DEFAULT NULL,
76	price VARCHAR(100) DEFAULT NULL,
77	created_at datetime DEFAULT NULL,
78	updated_at datetime DEFAULT NULL,
79	PRIMARY KEY (id)
80	) $charset_collate;",
81
82	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}booktics_orders (
83	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
84	order_no VARCHAR(100) NOT NULL,
85	customer_id BIGINT UNSIGNED NOT NULL,
86	customer_note VARCHAR(100) DEFAULT NULL,
87	status VARCHAR(50) DEFAULT 'pending',
88	payment_status VARCHAR(50) DEFAULT NULL,
89	timezone VARCHAR(50) DEFAULT 'UTC',
90	price_breakdown JSON DEFAULT NULL,
91	tax_total VARCHAR(100) DEFAULT NULL,
92	coupon_code VARCHAR(100) DEFAULT NULL,
93	coupon_discount VARCHAR(100) DEFAULT NULL,
94	subtotal VARCHAR(100) DEFAULT 0,
95	total VARCHAR(100) DEFAULT 0,
96	payment_method VARCHAR(50) DEFAULT NULL,
97	payment_intent_id VARCHAR(250) DEFAULT NULL,
98	payment_transaction_id VARCHAR(250) DEFAULT NULL,
99	created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
100	updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
101	PRIMARY KEY (id),
102	INDEX (order_no)
103	) $charset_collate;",
104
105	"CREATE TABLE IF NOT EXISTS {$wpdb->prefix}booktics_payments (
106	id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
107	order_id BIGINT UNSIGNED NOT NULL,
108	customer_id BIGINT UNSIGNED NOT NULL,
109	amount VARCHAR(20) NOT NULL,
110	currency VARCHAR(10) DEFAULT 'usd',
111	intent_id VARCHAR(255),
112	transaction_id VARCHAR(255),
113	status varchar(100) NOT NULL DEFAULT 'pending',
114	payment_method VARCHAR(50) NOT NULL,
115	refunded_amount VARCHAR(20) DEFAULT '0.00',
116	failure_reason TEXT,
117	date DATE NOT NULL,
118	date_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
119	INDEX (order_id),
120	INDEX (customer_id),
121	INDEX (intent_id),
122	INDEX (transaction_id)
123	) $charset_collate;",
124	);
125
126	foreach ( $table_schema as $table_sql ) {
127	dbDelta( $table_sql );
128	}
129
130	// Add missing columns to booktics_orders table
131	$orders_table = "{$wpdb->prefix}booktics_orders";
132	$orders_columns = $wpdb->get_col( 'DESC `' . esc_sql( $orders_table ) . '`', 0 );
133
134	$orders_columns_to_add = array(
135	'payment_method' => 'VARCHAR(50) DEFAULT NULL',
136	'payment_intent_id' => 'VARCHAR(250) DEFAULT NULL',
137	'payment_transaction_id' => 'VARCHAR(250) DEFAULT NULL',
138	);
139
140	foreach ( $orders_columns_to_add as $column => $definition ) {
141	if ( ! in_array( $column, $orders_columns, true ) ) {
142	$query = sprintf(
143	'ALTER TABLE `%s` ADD COLUMN `%s` %s',
144	esc_sql( $orders_table ),
145	esc_sql( $column ),
146	$definition
147	);
148	$wpdb->query( $query );
149	}
150	}
151
152	// Handle booktics_cart_items table
153	$cart_items_table = "{$wpdb->prefix}booktics_cart_items";
154	$cart_items_columns = $wpdb->get_col( 'DESC `' . esc_sql( $cart_items_table ) . '`', 0 );
155
156	// Rename sub_total to subtotal if exists
157	if ( in_array( 'sub_total', $cart_items_columns, true ) ) {
158	$wpdb->query(
159	sprintf(
160	'ALTER TABLE `%s` CHANGE COLUMN `sub_total` `subtotal` VARCHAR(20) NOT NULL',
161	esc_sql( $cart_items_table )
162	)
163	);
164	} elseif ( ! in_array( 'subtotal', $cart_items_columns, true ) ) {
165	$wpdb->query(
166	sprintf(
167	'ALTER TABLE `%s` ADD COLUMN `subtotal` VARCHAR(20) NOT NULL',
168	esc_sql( $cart_items_table )
169	)
170	);
171	}
172
173	$cart_items_columns_to_add = array(
174	'extra_services' => 'TEXT DEFAULT NULL',
175	'total' => 'VARCHAR(20) NOT NULL',
176	'additional_duration_id' => 'VARCHAR(100) NOT NULL',
177	'group_booking' => 'TEXT DEFAULT NULL',
178	);
179
180	foreach ( $cart_items_columns_to_add as $column => $definition ) {
181	if ( ! in_array( $column, $cart_items_columns, true ) ) {
182	$query = sprintf(
183	'ALTER TABLE `%s` ADD COLUMN `%s` %s',
184	esc_sql( $cart_items_table ),
185	esc_sql( $column ),
186	$definition
187	);
188	$wpdb->query( $query );
189	}
190	}
191	}
192	}
193