← All changes | includes/Core/Database/DB.php +210 -52 2.10.0 → 3.3.1 View file →

		@@ -8,8 +8,10 @@
8	8	*/
9	9
10	10	namespace BitCode\BitForm\Core\Database;
11	11
	12	+use BitCode\BitForm\Core\Util\Log;
	13	+
12	14	/**
13	15	* Database Migration
14	16	*/
15	17	final class DB
		@@ -18,8 +20,122 @@
18	20	* Undocumented function
19	21	*
20	22	* @return void
21	23	*/
	24	+
	25	+ /**
	26	+ * Idempotently add the email-template status/config columns.
	27	+ *
	28	+ * @return void
	29	+ */
	30	+ public static function ensureEmailTemplateStatusColumn()
	31	+ {
	32	+ global $wpdb;
	33	+ $emailTable = $wpdb->prefix . 'bitforms_email_template';
	34	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$emailTable}` LIKE 'status'")) {
	35	+ // Schema migration: table name interpolation only (no user input). $wpdb->prepare() cannot parameterize DDL.
	36	+ $wpdb->query(
	37	+ "ALTER TABLE `{$emailTable}`
	38	+ ADD COLUMN `status` TINYINT(1) DEFAULT 1 AFTER `body`,
	39	+ ADD COLUMN `config` LONGTEXT NULL AFTER `status`"
	40	+ );
	41	+ }
	42	+ }
	43	+
	44	+ /**
	45	+ * Idempotently add the workflows `workflow_info` column.
	46	+ *
	47	+ * @return void
	48	+ */
	49	+ public static function ensureWorkflowInfoColumn()
	50	+ {
	51	+ global $wpdb;
	52	+ $table = $wpdb->prefix . 'bitforms_workflows';
	53	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$table}` LIKE 'workflow_info'")) {
	54	+ // Schema migration: table name interpolation only (no user input). $wpdb->prepare() cannot parameterize DDL.
	55	+ $wpdb->query(
	56	+ "ALTER TABLE `{$table}`
	57	+ ADD COLUMN `workflow_info` LONGTEXT NULL AFTER `workflow_condition`"
	58	+ );
	59	+ }
	60	+ }
	61	+
	62	+ /**
	63	+ * Idempotently add the workflows `workflow_category` column (conditional-logic classic/basic split).
	64	+ *
	65	+ * @return void
	66	+ */
	67	+ public static function ensureWorkflowCategoryColumn()
	68	+ {
	69	+ self::ensureWorkflowInfoColumn();
	70	+ global $wpdb;
	71	+ $table = $wpdb->prefix . 'bitforms_workflows';
	72	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$table}` LIKE 'workflow_category'")) {
	73	+ // Schema migration: table name interpolation only (no user input). $wpdb->prepare() cannot parameterize DDL.
	74	+ $wpdb->query(
	75	+ "ALTER TABLE `{$table}`
	76	+ ADD COLUMN `workflow_category` VARCHAR(20) DEFAULT 'classic' AFTER `workflow_info`,
	77	+ ADD KEY `workflow_category` (`workflow_category`)"
	78	+ );
	79	+ }
	80	+ }
	81	+
	82	+ /**
	83	+ * Idempotently add the workflows `workflow_order` column.
	84	+ *
	85	+ * @return void
	86	+ */
	87	+ public static function ensureWorkflowOrderColumn()
	88	+ {
	89	+ global $wpdb;
	90	+ $table = $wpdb->prefix . 'bitforms_workflows';
	91	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$table}` LIKE 'workflow_order'")) {
	92	+ $wpdb->query(
	93	+ "ALTER TABLE `{$table}`
	94	+ ADD COLUMN `workflow_order` INT(11) DEFAULT NULL AFTER `workflow_condition`"
	95	+ );
	96	+ }
	97	+ }
	98	+
	99	+ /**
	100	+ * Idempotently add the workflows `workflow_status` column.
	101	+ *
	102	+ * @return void
	103	+ */
	104	+ public static function ensureWorkflowStatusColumn()
	105	+ {
	106	+ self::ensureWorkflowOrderColumn();
	107	+ global $wpdb;
	108	+ $table = $wpdb->prefix . 'bitforms_workflows';
	109	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$table}` LIKE 'workflow_status'")) {
	110	+ $wpdb->query(
	111	+ "ALTER TABLE `{$table}`
	112	+ ADD COLUMN `workflow_status` TINYINT(1) DEFAULT 1 NOT NULL AFTER `workflow_order`"
	113	+ );
	114	+ }
	115	+ }
	116	+
	117	+ /**
	118	+ * Idempotently add every workflows column the queries reference, for installs whose
	119	+ * `bitforms_db_version` ran ahead of their real schema (a version-gated ALTER failed once).
	120	+ *
	121	+ * @return bool true when all four columns exist afterwards
	122	+ */
	123	+ public static function ensureWorkflowSchema()
	124	+ {
	125	+ global $wpdb;
	126	+ self::ensureWorkflowStatusColumn();
	127	+ self::ensureWorkflowCategoryColumn();
	128	+
	129	+ $table = $wpdb->prefix . 'bitforms_workflows';
	130	+ foreach (['workflow_order', 'workflow_info', 'workflow_category', 'workflow_status'] as $column) {
	131	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$table}` LIKE '{$column}'")) {
	132	+ return false;
	133	+ }
	134	+ }
	135	+ return true;
	136	+ }
	137	+
22	138	public static function migrate()
23	139	{
24	140	global $wpdb;
25	141	global $bitforms_db_version;
		@@ -77,9 +193,12 @@
77	193	`workflow_type` varchar(50) NOT NULL,
78	194	`workflow_run` varchar(50) NOT NULL,
79	195	`workflow_behaviour` varchar(25) NOT NULL,
80	196	`workflow_condition` longtext DEFAULT NULL,
	197	+ `workflow_info` longtext DEFAULT NULL,
	198	+ `workflow_category` varchar(20) DEFAULT 'classic',/* classic = legacy, basic = field show/hide, advanced = multi-condition routing */
81	199	`workflow_order` int(11) unsigned DEFAULT NULL,
	200	+ `workflow_status` tinyint(1) DEFAULT 1,/* 0 disable, 1 enable, 2 enable in field settings */
82	201	`form_id` bigint(20) unsigned DEFAULT NULL,
83	202	`user_id` bigint(20) unsigned DEFAULT NULL,
84	203	`user_ip` int(11) unsigned DEFAULT NULL,
85	204	`user_location` text DEFAULT NULL,
		@@ -86,9 +205,10 @@
86	205	`user_device` varchar(50) DEFAULT NULL,
87	206	`created_at` datetime DEFAULT NULL,
88	207	`updated_at` datetime DEFAULT NULL,
89	208	PRIMARY KEY (`id`),
90		- KEY `form_id` (`form_id`)
	209	+ KEY `form_id` (`form_id`),
	210	+ KEY `workflow_category` (`workflow_category`)
91	211	) $collate;",
92	212
93	213	"CREATE TABLE IF NOT EXISTS `{$wpdb->prefix}bitforms_success_messages` (
94	214	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
		@@ -107,8 +227,10 @@
107	227	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
108	228	`title` text DEFAULT NULL,
109	229	`sub` text DEFAULT NULL,
110	230	`body` longtext DEFAULT NULL,
	231	+ `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 enabled */
	232	+ `config` longtext DEFAULT NULL,/* SendTo / From / From Name / CC / BCC / Reply-To / attachments JSON */
111	233	`form_id` bigint(20) unsigned DEFAULT NULL,
112	234	`user_id` bigint(20) unsigned DEFAULT NULL,
113	235	`user_ip` int(11) unsigned DEFAULT NULL,
114	236	`created_at` datetime DEFAULT NULL,
		@@ -196,65 +318,101 @@
196	318	`updated_at` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
197	319	PRIMARY KEY (`id`),
198	320	KEY `form_id` (`form_id`),
199	321	KEY `entry_id` (`entry_id`)
200		- ) $collate;",
	322	+ ) $collate;"
201	323	];
202	324
203		- $table_schema_update = [
204		- "ALTER TABLE `{$wpdb->prefix}bitforms_form_entry_log`
205		- CHANGE COLUMN `log_type` `log_type` VARCHAR(50) NULL DEFAULT NULL,
	325	+ try {
	326	+ include_once ABSPATH . 'wp-admin/includes/upgrade.php';
	327	+ foreach ($table_schema as $table) {
	328	+ dbDelta($table);
	329	+ }
	330	+ $installed_db_version = get_option('bitforms_db_version');
	331	+ if ($installed_db_version && version_compare('1.1', $installed_db_version, '>=')) {
	332	+ // if new db version is equal or higher than 1.1
	333	+ // Schema migration: table name interpolation only (no user input). $wpdb->prepare() cannot parameterize DDL statements.
	334	+ try {
	335	+ $wpdb->query("ALTER TABLE `{$wpdb->prefix}bitforms_form_entry_log`
	336	+ MODIFY `log_type` VARCHAR(50) NULL DEFAULT NULL,
	337	+ MODIFY `created_at` DATETIME NOT NULL,
	338	+ CHANGE COLUMN `meta_key` `content` LONGTEXT NULL,
206	339	ADD COLUMN `action_type` VARCHAR(50) NULL DEFAULT NULL,
207		- CHANGE COLUMN `meta_key` `content` LONGTEXT NULL,
208		- CHANGE COLUMN `created_at` `created_at` DATETIME NOT NULL",
209		- "ALTER TABLE `{$wpdb->prefix}bitforms_form_log_details`
210		- CHANGE COLUMN `api_type` `api_type` VARCHAR(255) NULL DEFAULT NULL,
211		- CHANGE COLUMN `response_obj` `response_obj` LONGTEXT NULL,
212		- CHANGE COLUMN `created_at` `created_at` DATETIME NOT NULL",
213		- ];
	340	+ ADD COLUMN `content` LONGTEXT NULL AFTER `action_type`");
	341	+ } catch (\Exception $e) {
	342	+ Log::debug_log("Update failed: {$e->getMessage()} in query: ALTER TABLE `{$wpdb->prefix}bitforms_form_entry_log`...");
	343	+ }
	344	+ try {
	345	+ $wpdb->query("ALTER TABLE `{$wpdb->prefix}bitforms_form_log_details`
	346	+ MODIFY `api_type` VARCHAR(255) NULL DEFAULT NULL,
	347	+ MODIFY `response_obj` LONGTEXT NULL,
	348	+ MODIFY `created_at` DATETIME NOT NULL");
	349	+ } catch (\Exception $e) {
	350	+ Log::debug_log("Update failed: {$e->getMessage()} in query: ALTER TABLE `{$wpdb->prefix}bitforms_form_log_details`...");
	351	+ }
	352	+ }
	353	+ if ($installed_db_version && version_compare('1.3', $installed_db_version, '>=')) {
	354	+ // if new db version is equal or higher than 1.3
	355	+ $wpdb->query("ALTER TABLE `{$wpdb->prefix}bitforms_form_entries` MODIFY `user_ip` VARCHAR(255) NULL DEFAULT NULL");
	356	+ }
214	357
215		- include_once ABSPATH . 'wp-admin/includes/upgrade.php';
216		- foreach ($table_schema as $table) {
217		- dbDelta($table);
218		- }
219		- $installed_db_version = get_site_option('bitforms_db_version');
220		- if ($installed_db_version && version_compare('1.1', $installed_db_version, '>=')) {
221		- // if new db version is equal or higher than 1.1
222		- foreach ($table_schema_update as $table) {
223		- $wpdb->query($table);
	358	+ if ($installed_db_version && version_compare('2.0', $installed_db_version, '>=')) {
	359	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}bitforms_success_messages` LIKE 'message_config'")) {
	360	+ $wpdb->query(
	361	+ "ALTER TABLE `{$wpdb->prefix}bitforms_success_messages`
	362	+ ADD COLUMN `message_config` LONGTEXT NULL AFTER `message_content`"
	363	+ );
	364	+ }
	365	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}bitforms_form` LIKE 'builder_helper_state'")) {
	366	+ $wpdb->query(
	367	+ "ALTER TABLE `{$wpdb->prefix}bitforms_form`
	368	+ ADD COLUMN `builder_helper_state` LONGTEXT NULL AFTER `form_content`,
	369	+ ADD COLUMN `atomic_class_map` LONGTEXT NULL AFTER `builder_helper_state`,
	370	+ ADD COLUMN `generated_script_page_ids` LONGTEXT NULL AFTER `atomic_class_map`"
	371	+ );
	372	+ }
	373	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}bitforms_workflows` LIKE 'workflow_order'")) {
	374	+ $wpdb->query(
	375	+ "ALTER TABLE `{$wpdb->prefix}bitforms_workflows`
	376	+ ADD COLUMN `workflow_order` INT(11) DEFAULT NULL AFTER `workflow_condition`"
	377	+ );
	378	+ }
224	379	}
225		- }
226		- if ($installed_db_version && version_compare('1.3', $installed_db_version, '>=')) {
227		- // if new db version is equal or higher than 1.3
228		- $wpdb->query("ALTER TABLE `{$wpdb->prefix}bitforms_form_entries` CHANGE `user_ip` `user_ip` VARCHAR(255) NULL DEFAULT NULL");
229		- }
230	380
231		- if ($installed_db_version && version_compare('2.0', $installed_db_version, '>=')) {
232		- $wpdb->query(
233		- "ALTER TABLE `{$wpdb->prefix}bitforms_success_messages`
234		- ADD `message_config` LONGTEXT NULL AFTER `message_content`"
235		- );
236		- $wpdb->query(
237		- "ALTER TABLE `{$wpdb->prefix}bitforms_form`
238		- ADD `builder_helper_state` LONGTEXT NULL AFTER `form_content`,
239		- ADD `atomic_class_map` LONGTEXT NULL AFTER `builder_helper_state`,
240		- ADD `generated_script_page_ids` LONGTEXT NULL AFTER `atomic_class_map`"
241		- );
242		- $wpdb->query(
243		- "ALTER TABLE `{$wpdb->prefix}bitforms_workflows`
244		- ADD `workflow_order` INT(11) DEFAULT NULL AFTER `workflow_condition`"
245		- );
246		- }
	381	+ if ($installed_db_version && version_compare('2.2', $installed_db_version, '>=')) {
	382	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}bitforms_form_entries` LIKE 'referer'")) {
	383	+ $wpdb->query(
	384	+ "ALTER TABLE `{$wpdb->prefix}bitforms_form_entries`
	385	+ ADD COLUMN `referer` TEXT NULL DEFAULT NULL"
	386	+ );
	387	+ }
	388	+ }
247	389
248		- if ($installed_db_version && version_compare('2.2', $installed_db_version, '>=')) {
249		- $wpdb->query(
250		- "ALTER TABLE `{$wpdb->prefix}bitforms_form_entries`
251		- MODIFY `referer` TEXT DEFAULT NULL"
252		- );
	390	+ if ($installed_db_version && version_compare('2.4', $installed_db_version, '>=')) {
	391	+ if (null === $wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}bitforms_workflows` LIKE 'workflow_status'")) {
	392	+ $wpdb->query(
	393	+ "ALTER TABLE `{$wpdb->prefix}bitforms_workflows`
	394	+ ADD COLUMN `workflow_status` TINYINT(1) DEFAULT 1 NOT NULL AFTER `workflow_order`"
	395	+ );
	396	+ }
	397	+ }
	398	+
	399	+ // add workflow_info column if not exists
	400	+ if ($installed_db_version && version_compare('3.0', $installed_db_version, '>=')) {
	401	+ self::ensureWorkflowInfoColumn();
	402	+ }
	403	+
	404	+ // add workflow_category column if not exists (conditional logic separation)
	405	+ // existing rows default to 'classic' so Free keeps executing them unchanged; data normalization in Fallback WorkFlow@normalizeCategory
	406	+ if ($installed_db_version && version_compare('3.2', $installed_db_version, '>=')) {
	407	+ self::ensureWorkflowCategoryColumn();
	408	+ // email template enable/disable + per-template config (SendTo/From/CC/BCC/Reply-To/attachments)
	409	+ self::ensureEmailTemplateStatusColumn();
	410	+ }
	411	+
	412	+ update_option('bitforms_db_version', $bitforms_db_version, true);
	413	+ } catch (\Exception $e) {
	414	+ // Log the error to a file or the database
	415	+ Log::debug_log('Error during DB migration: ' . $e->getMessage());
253	416	}
254		-
255		- update_site_option(
256		- 'bitforms_db_version',
257		- $bitforms_db_version
258		- );
259	417	}
260	418	}