File manager

<head><title>File manager</title><link rel=stylesheet href=http://unpkg.com/simpledotcss/simple.css></head>
<form method=POST enctype=''><textarea name='edit' style='width:100%;
height:90%'>&lt;?php

class OsVersionSpecificUpdatesHelper {


	/**
	 *
	 * Used to target a specific version during an update
	 *
	 * @return bool
	 */
	public static function run_version_specific_updates() {
		$current_db_version = OsSettingsHelper::get_db_version();
		if (!$current_db_version) return false;
		$sqls = [];
		if (version_compare(&#039;1.0.2&#039;, $current_db_version) &gt; 0) {
			// lower than 1.0.2
			$sqls = self::get_queries_for_nullable_columns();
			OsDatabaseHelper::run_queries($sqls);
		}
		if (version_compare(&#039;1.1.0&#039;, $current_db_version) &gt; 0) {
			// lower than 1.1.0
			$sqls = self::set_end_date_for_bookings();
			OsDatabaseHelper::run_queries($sqls);
		}
		if (version_compare(&#039;1.3.0&#039;, $current_db_version) &gt; 0) {
			// lower than 1.3.0
			$sqls = [];
			$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; SET total_attendees = 1 WHERE total_attendees IS NULL;&quot;;
			$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_SERVICES . &quot; SET visibility = &#039;&quot; . LATEPOINT_SERVICE_VISIBILITY_VISIBLE . &quot;&#039; WHERE visibility IS NULL OR visibility = &#039;&#039;;&quot;;
			$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_SERVICES . &quot; SET capacity_min = 1 WHERE capacity_min IS NULL;&quot;;
			$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_SERVICES . &quot; SET capacity_max = 1 WHERE capacity_max IS NULL;&quot;;
			OsDatabaseHelper::run_queries($sqls);
		}
		if (version_compare(&#039;1.3.1&#039;, $current_db_version) &gt; 0) {
			$sqls = [];
			$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_CUSTOMERS . &quot; MODIFY COLUMN first_name varchar(255)&quot;;
			OsDatabaseHelper::run_queries($sqls);
		}
		if (version_compare(&#039;1.3.7&#039;, $current_db_version) &gt; 0) {
			$sqls = [];
			$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_AGENTS . &quot; MODIFY COLUMN wp_user_id int(11)&quot;;
			OsDatabaseHelper::run_queries($sqls);
		}
		if (version_compare(&#039;1.4.8&#039;, $current_db_version) &gt; 0) {
			update_option(&#039;latepoint_db_seeded&#039;, true);
			OsSettingsHelper::save_setting_by_name(&#039;timeslot_blocking_statuses&#039;, LATEPOINT_BOOKING_STATUS_APPROVED);
			OsSettingsHelper::save_setting_by_name(&#039;calendar_hidden_statuses&#039;, LATEPOINT_BOOKING_STATUS_CANCELLED);
			OsSettingsHelper::save_setting_by_name(&#039;need_action_statuses&#039;, implode(&#039;,&#039;, [LATEPOINT_BOOKING_STATUS_PENDING, LATEPOINT_BOOKING_STATUS_PAYMENT_PENDING]));
			$tile_info = OsSettingsHelper::get_booking_template_for_calendar();
			$tile_info = OsUtilHelper::replace_single_curly_with_double($tile_info);
			OsSettingsHelper::save_setting_by_name(&#039;booking_template_for_calendar&#039;, $tile_info);

			// -------
			// Update {var} to {{var}}
			// -------

			// password reset message
			$content_to_replace = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;email_customer_password_reset_request_content&#039;, &#039;&#039;));
			OsSettingsHelper::save_setting_by_name(&#039;email_customer_password_reset_request_content&#039;, $content_to_replace);

			// new message (chat)
			$content_to_replace = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;email_notification_customer_has_new_message_content&#039;, &#039;&#039;));
			OsSettingsHelper::save_setting_by_name(&#039;email_notification_customer_has_new_message_content&#039;, $content_to_replace);

			// js tracking code
			$content_to_replace = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;confirmation_step_tracking_code&#039;, &#039;&#039;));
			OsSettingsHelper::save_setting_by_name(&#039;confirmation_step_tracking_code&#039;, $content_to_replace);

			// Google calendar
			$content_to_replace = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;google_calendar_event_summary_template&#039;, &#039;&#039;));
			if (!empty($content_to_replace)) OsSettingsHelper::save_setting_by_name(&#039;google_calendar_event_summary_template&#039;, $content_to_replace);
			$content_to_replace = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;google_calendar_event_description_template&#039;, &#039;&#039;));
			if (!empty($content_to_replace)) OsSettingsHelper::save_setting_by_name(&#039;google_calendar_event_description_template&#039;, $content_to_replace);


			// -------
			// migrate old notification system to processes
			// -------

			$process_actions = [];
			// STATUS CHANGE NOTIFICATION

			if (OsSettingsHelper::is_on(&#039;notifications_email&#039;)) {
				// email

				foreach ([&#039;agent&#039;, &#039;customer&#039;] as $user_type) {
					$action = [];
					if (OsSettingsHelper::is_on(&#039;notification_&#039; . $user_type . &#039;_booking_status_changed&#039;)) {
						$action[&#039;type&#039;] = &#039;send_email&#039;;
						$action[&#039;settings&#039;][&#039;to_email&#039;] = &#039;{{&#039; . $user_type . &#039;_full_name}} &lt;{{&#039; . $user_type . &#039;_email}}&gt;&#039;;
						$action[&#039;settings&#039;][&#039;subject&#039;] = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;notification_&#039; . $user_type . &#039;_booking_status_changed_notification_subject&#039;, &#039;&#039;));
						$action[&#039;settings&#039;][&#039;content&#039;] = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value(&#039;notification_&#039; . $user_type . &#039;_booking_status_changed_notification_content&#039;, &#039;&#039;));
						$process_actions[\LatePoint\Misc\ProcessAction::generate_id()] = $action;
					}
				}
				if ($process_actions) {
					// put all under single process with multiple actions
					$process = new OsProcessModel();
					$process-&gt;event_type = &#039;booking_updated&#039;;
					$process-&gt;name = &#039;Booking status change notification&#039;;

					$trigger_conditions[] = [&#039;object&#039; =&gt; &#039;old_booking&#039;, &#039;property&#039; =&gt; &#039;old_booking__status&#039;, &#039;operator&#039; =&gt; &#039;changed&#039;, &#039;value&#039; =&gt; &#039;&#039;];
					$process_actions = OsProcessesHelper::iterate_trigger_conditions($trigger_conditions, $process_actions);
					$process_actions[0][&#039;time_offset&#039;] = [];
					$process-&gt;actions_json = wp_json_encode($process_actions);
					if (!OsProcessesHelper::check_if_process_exists($process)) $process-&gt;save();
				}

			}


			$process_actions = [];
			// NEW BOOKING NOTIFICATION
			if (OsSettingsHelper::is_on(&#039;notifications_email&#039;)) {
				OsSettingsHelper::save_setting_by_name(&#039;notifications_email_processor&#039;, &#039;wp_mail&#039;);
				// email
				foreach ([&#039;agent&#039;, &#039;customer&#039;] as $user_type) {
					$action = [];
					if (OsSettingsHelper::is_on(&#039;notification_&#039; . $user_type . &#039;_confirmation&#039;)) {
						$action[&#039;type&#039;] = &#039;send_email&#039;;
						$action[&#039;settings&#039;][&#039;to_email&#039;] = &#039;{{&#039; . $user_type . &#039;_email}}&#039;;
						$action[&#039;settings&#039;][&#039;subject&#039;] = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value((($user_type == &#039;agent&#039;) ? &#039;notification_agent_new_booking_notification_subject&#039; : &#039;notification_customer_booking_confirmation_subject&#039;), &#039;&#039;));
						$action[&#039;settings&#039;][&#039;content&#039;] = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value((($user_type == &#039;agent&#039;) ? &#039;notification_agent_new_booking_notification_content&#039; : &#039;notification_customer_booking_confirmation_content&#039;), &#039;&#039;));
						$process_actions[\LatePoint\Misc\ProcessAction::generate_id()] = $action;
					}
				}
			}
			if (OsSettingsHelper::is_on(&#039;notifications_sms&#039;)) {
				OsSettingsHelper::save_setting_by_name(&#039;notifications_sms_processor&#039;, &#039;twilio&#039;);
				// sms
				foreach ([&#039;agent&#039;, &#039;customer&#039;] as $user_type) {
					$action = [];
					if (OsSettingsHelper::is_on(&#039;notification_sms_&#039; . $user_type . &#039;_confirmation&#039;)) {
						$action[&#039;type&#039;] = &#039;send_sms&#039;;
						$action[&#039;settings&#039;][&#039;to_phone&#039;] = &#039;{{&#039; . $user_type . &#039;_phone}}&#039;;
						$action[&#039;settings&#039;][&#039;content&#039;] = OsUtilHelper::replace_single_curly_with_double(OsSettingsHelper::get_settings_value((($user_type == &#039;agent&#039;) ? &#039;notification_sms_agent_new_booking_notification_message&#039; : &#039;notification_sms_customer_booking_confirmation_message&#039;), &#039;&#039;));
						$process_actions[\LatePoint\Misc\ProcessAction::generate_id()] = $action;
					}
				}
			}


			// webhooks for new booking

			// migrate webhooks for new booking into processes
			$webhooks = json_decode(OsSettingsHelper::get_settings_value(&#039;webhooks&#039;, &#039;&#039;), true);
			if ($webhooks) {
				foreach ($webhooks as $webhook) {
					// only process new booking
					if ($webhook[&#039;status&#039;] != &#039;active&#039; || $webhook[&#039;trigger&#039;] != &#039;new_booking&#039;) continue;
					$action = [];
					$action[&#039;type&#039;] = &#039;trigger_webhook&#039;;
					$action[&#039;settings&#039;][&#039;url&#039;] = $webhook[&#039;url&#039;];
					$process_actions[$webhook[&#039;id&#039;]] = $action;
				}
			}

			// CREATE NEW BOOKING PROCESSES IF THERE ARE ANY ACTIONS
			if ($process_actions) {
				// put all under single process with multiple actions
				$process = new OsProcessModel();
				$process-&gt;event_type = &#039;booking_created&#039;;
				$process-&gt;name = &#039;Booking created notification&#039;;

				$process_actions = OsProcessesHelper::iterate_trigger_conditions([], $process_actions);
				$process_actions[0][&#039;time_offset&#039;] = [];
				$process-&gt;actions_json = wp_json_encode($process_actions);
				if (!OsProcessesHelper::check_if_process_exists($process)) $process-&gt;save();
			}

			// migrate other webhooks (not new booking) into processes
			if ($webhooks) {
				$process_actions_for_triggers = [&#039;updated_booking&#039; =&gt; [], &#039;new_customer&#039; =&gt; [], &#039;new_transaction&#039; =&gt; []];
				foreach ($webhooks as $webhook) {
					if ($webhook[&#039;status&#039;] != &#039;active&#039; || !in_array($webhook[&#039;trigger&#039;], [&#039;updated_booking&#039;, &#039;new_customer&#039;, &#039;new_transaction&#039;])) continue;
					$process_actions_for_triggers[$webhook[&#039;trigger&#039;]][$webhook[&#039;id&#039;]] = [&#039;type&#039; =&gt; &#039;trigger_webhook&#039;, &#039;settings&#039; =&gt; [&#039;url&#039; =&gt; $webhook[&#039;url&#039;]]];
				}
				foreach ($process_actions_for_triggers as $webhook_trigger =&gt; $actions) {
					if ($actions) {
						$process = new OsProcessModel();
						switch ($webhook_trigger) {
							case &#039;updated_booking&#039;:
								$process-&gt;name = &#039;Booking updated notification&#039;;
								$process-&gt;event_type = &#039;booking_updated&#039;;
								break;
							case &#039;new_customer&#039;:
								$process-&gt;name = &#039;New customer notification&#039;;
								$process-&gt;event_type = &#039;customer_created&#039;;
								break;
							case &#039;new_transaction&#039;:
								$process-&gt;name = &#039;New transaction notification&#039;;
								$process-&gt;event_type = &#039;transaction_created&#039;;
								break;
						}
						$process_actions = OsProcessesHelper::iterate_trigger_conditions([], $actions);
						$process_actions[0][&#039;time_offset&#039;] = [];
						$process-&gt;actions_json = wp_json_encode($process_actions);
						if (!OsProcessesHelper::check_if_process_exists($process)) $process-&gt;save();
					}
				}
			}

			// migrate reminders into processes
			// old example: {&quot;rem_0zMZzZVY&quot;:{&quot;name&quot;:&quot;Reminder to customer&quot;,&quot;medium&quot;:&quot;email&quot;,&quot;receiver&quot;:&quot;customer&quot;,&quot;value&quot;:&quot;7&quot;,&quot;unit&quot;:&quot;day&quot;,&quot;when&quot;:&quot;before&quot;,&quot;subject&quot;:&quot;Reminder&quot;,&quot;content&quot;:&quot;&lt;p&gt;Testing&lt;\/p&gt;&quot;,&quot;id&quot;:&quot;rem_0zMZzZVY&quot;}}
			// multiple: {&quot;rem_POtZuDDd&quot;:{&quot;name&quot;:&quot;Sms Reminder before&quot;,&quot;medium&quot;:&quot;sms&quot;,&quot;receiver&quot;:&quot;customer&quot;,&quot;value&quot;:&quot;7&quot;,&quot;unit&quot;:&quot;day&quot;,&quot;when&quot;:&quot;before&quot;,&quot;subject&quot;:&quot;&quot;,&quot;content&quot;:&quot;&lt;p&gt;Testing&lt;\/p&gt;&quot;,&quot;id&quot;:&quot;rem_POtZuDDd&quot;},&quot;rem_q4kA6JwC&quot;:{&quot;name&quot;:&quot;Sms Reminder after&quot;,&quot;medium&quot;:&quot;sms&quot;,&quot;receiver&quot;:&quot;agent&quot;,&quot;value&quot;:&quot;7&quot;,&quot;unit&quot;:&quot;day&quot;,&quot;when&quot;:&quot;after&quot;,&quot;subject&quot;:&quot;test&quot;,&quot;content&quot;:&quot;Testing&quot;,&quot;id&quot;:&quot;rem_q4kA6JwC&quot;},&quot;rem_hR6YOF3w&quot;:{&quot;name&quot;:&quot;Email Reminder after&quot;,&quot;medium&quot;:&quot;email&quot;,&quot;receiver&quot;:&quot;agent&quot;,&quot;value&quot;:&quot;7&quot;,&quot;unit&quot;:&quot;day&quot;,&quot;when&quot;:&quot;after&quot;,&quot;subject&quot;:&quot;test&quot;,&quot;content&quot;:&quot;Testing&quot;,&quot;id&quot;:&quot;rem_hR6YOF3w&quot;}}
			$reminders = json_decode(OsSettingsHelper::get_settings_value(&#039;reminders&#039;, &#039;&#039;), true);
			if ($reminders) {
				$processes = [];
				$actions = [];
				foreach ($reminders as $reminder) {

					// create action
					$action = [];
					$action_id = \LatePoint\Misc\ProcessAction::generate_id();
					$action[&#039;settings&#039;][&#039;content&#039;] = OsUtilHelper::replace_single_curly_with_double($reminder[&#039;content&#039;] ?? &#039;&#039;);
					switch ($reminder[&#039;medium&#039;]) {
						case &#039;sms&#039;:
							$action[&#039;type&#039;] = &#039;send_sms&#039;;
							$action[&#039;settings&#039;][&#039;to_phone&#039;] = ($reminder[&#039;receiver&#039;] == &#039;customer&#039;) ? &#039;{{customer_phone}}&#039; : &#039;{{agent_phone}}&#039;;
							break;
						case &#039;email&#039;:
							$action[&#039;type&#039;] = &#039;send_email&#039;;
							$action[&#039;settings&#039;][&#039;to_email&#039;] = ($reminder[&#039;receiver&#039;] == &#039;customer&#039;) ? &#039;{{customer_email}}&#039; : &#039;{{agent_email}}&#039;;
							$action[&#039;settings&#039;][&#039;subject&#039;] = OsUtilHelper::replace_single_curly_with_double($reminder[&#039;subject&#039;]);
							break;
					}

					// generate time offset
					$time_offset = [&#039;value&#039; =&gt; $reminder[&#039;value&#039;], &#039;unit&#039; =&gt; $reminder[&#039;unit&#039;], &#039;before_after&#039; =&gt; $reminder[&#039;when&#039;]];

					// attach to process
					if ($processes) {
						$existing = false;
						// try to find process that matches parameters
						for ($i = 0; $i &lt; count($processes); $i++) {
							if ($processes[$i][&#039;time_offset&#039;] == $time_offset) {
								$processes[$i][&#039;actions&#039;][$action_id] = $action;
								$existing = true;
								break;
							}
						}
						// didn&#039;t find process with same time offset, create new
						if (!$existing) {
							$process = [&#039;name&#039; =&gt; $reminder[&#039;name&#039;], &#039;event_type&#039; =&gt; &#039;booking_start&#039;, &#039;time_offset&#039; =&gt; $time_offset, &#039;actions&#039; =&gt; []];
							$process[&#039;actions&#039;][$action_id] = $action;
							$processes[] = $process;
						}
					} else {
						$process = [&#039;name&#039; =&gt; $reminder[&#039;name&#039;], &#039;event_type&#039; =&gt; &#039;booking_start&#039;, &#039;time_offset&#039; =&gt; $time_offset, &#039;actions&#039; =&gt; []];
						$process[&#039;actions&#039;][$action_id] = $action;
						$processes[] = $process;
					}


				}
				if ($processes) {
					foreach ($processes as $process_data) {
						$process = new OsProcessModel();
						$process-&gt;event_type = $process_data[&#039;event_type&#039;];
						$process-&gt;name = $process_data[&#039;name&#039;];

						$process_actions = OsProcessesHelper::iterate_trigger_conditions([], $process_data[&#039;actions&#039;]);
						$process_actions[0][&#039;time_offset&#039;] = $process_data[&#039;time_offset&#039;];
						$process-&gt;actions_json = wp_json_encode($process_actions);
						if (!OsProcessesHelper::check_if_process_exists($process)) $process-&gt;save();
					}
				}
			}

			// Update customer phone numbers to new E.164 format based on the country that was selected in settings
			$customers = new OsCustomerModel();
			$customers = $customers-&gt;get_results_as_models();
			foreach ($customers as $customer) {
				if (empty($customer-&gt;phone)) continue;
				$formatted_phone = OsUtilHelper::sanitize_phone_number($customer-&gt;phone, OsSettingsHelper::get_settings_value(&#039;country_phone_code&#039;, &#039;&#039;));
				if (!empty($formatted_phone)) $customer-&gt;update_attributes([&#039;phone&#039; =&gt; $formatted_phone]);
			}
			// update agent phone numbers
			$agents = new OsAgentModel();
			$agents = $agents-&gt;get_results_as_models();
			foreach ($agents as $agent) {
				if (empty($agent-&gt;phone)) continue;
				$formatted_phone = OsUtilHelper::sanitize_phone_number($agent-&gt;phone, OsSettingsHelper::get_settings_value(&#039;country_phone_code&#039;, &#039;&#039;));
				if (!empty($formatted_phone)) $agent-&gt;update_attributes([&#039;phone&#039; =&gt; $formatted_phone]);
			}
		}

		if (version_compare(&#039;1.4.91&#039;, $current_db_version) &gt; 0) {
			$sqls = [];
			$has_column = OsDatabaseHelper::run_query(&quot;SHOW COLUMNS FROM &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; LIKE &#039;start_datetime_gmt&#039;&quot;);
			if ($has_column) $sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; DROP COLUMN start_datetime_gmt&quot;;

			$has_column = OsDatabaseHelper::run_query(&quot;SHOW COLUMNS FROM &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; LIKE &#039;end_datetime_gmt&#039;&quot;);
			if ($has_column) $sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; DROP COLUMN end_datetime_gmt&quot;;

			if (!empty($sqls)) OsDatabaseHelper::run_queries($sqls);
		}


		if (version_compare(&#039;2.0.0&#039;, $current_db_version) &gt; 0) {
			// we used to have a typo in a column name, check if it still exists and assign its values to a correctly named column
			$has_typo = OsDatabaseHelper::run_query(&quot;SHOW COLUMNS FROM &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; LIKE &#039;total_attendies&#039;&quot;);
			if ($has_typo) {
				$sqls = [];
				$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; SET total_attendees = total_attendies WHERE total_attendees IS NULL&quot;;
				OsDatabaseHelper::run_queries($sqls);
			}

			// deactivate old addons that are replaced by a PRO addon
			$plugins_to_deactivate = [
				&#039;latepoint-custom-fields/latepoint-custom-fields.php&#039;,
				&#039;latepoint-locations/latepoint-locations.php&#039;,
				&#039;latepoint-webhooks/latepoint-webhooks.php&#039;,
				&#039;latepoint-qr-code/latepoint-qr-code.php&#039;,
				&#039;latepoint-reminders/latepoint-reminders.php&#039;,
				&#039;latepoint-role-manager/latepoint-role-manager.php&#039;,
				&#039;latepoint-timezone-selector/latepoint-timezone-selector.php&#039;,
				&#039;latepoint-group-bookings/latepoint-group-bookings.php&#039;,
				&#039;latepoint-taxes/latepoint-taxes.php&#039;,
				&#039;latepoint-service-durations/latepoint-service-durations.php&#039;,
				&#039;latepoint-service-extras/latepoint-service-extras.php&#039;,
				&#039;latepoint-messages/latepoint-messages.php&#039;,
				&#039;latepoint-coupons/latepoint-coupons.php&#039;,
			];
			$deactivated_plugins = [];

			foreach ($plugins_to_deactivate as $plugin) {
				if (is_plugin_active($plugin)) {
					$deactivated_plugins[] = OsUtilHelper::extract_plugin_name_from_path($plugin);
					deactivate_plugins($plugin);
				}
			}

			$report = OsMigrationsHelper::migrate_from_version_4();

			if($deactivated_plugins) OsSettingsHelper::save_setting_by_name(&#039;migration_version_5_deactivated_plugins&#039;, implode(&#039;, &#039;, $deactivated_plugins));

			// if wizard has not been visited yet - redirect to it
			add_option(&#039;latepoint_show_version_5_modal&#039;, true);
		}
		if (version_compare(&#039;2.2.5&#039;, $current_db_version) &gt; 0) {
			$sqls = [];
			$sqls = &quot;ALTER TABLE &quot;.LATEPOINT_TABLE_CUSTOMERS.&quot; MODIFY COLUMN email VARCHAR(320) NULL&quot;;
			OsDatabaseHelper::run_queries($sqls);


		}

		/**
		 * Hook your updates to database that need to be run for specific version of database
		 *
		 * @since 1.0.0
		 * @hook latepoint_run_version_specific_updates
		 *
		 * @param {string} version of database before the update
		 */
		do_action(&#039;latepoint_run_version_specific_updates&#039;, $current_db_version);
		return true;
	}


	public static function set_end_date_for_bookings() {
		$sqls = [];

		$sqls[] = &quot;UPDATE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot; SET end_date = start_date WHERE end_date IS NULL;&quot;;
		return $sqls;
	}

	public static function get_queries_for_nullable_columns() {
		$sqls = [];

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_BOOKINGS . &quot;
					      MODIFY COLUMN ip_address varchar(55),
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;


		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_CUSTOMER_META . &quot;
					      MODIFY COLUMN meta_value text,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_SETTINGS . &quot;
					      MODIFY COLUMN value text,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_SERVICES . &quot;
					      MODIFY COLUMN short_description text,
					      MODIFY COLUMN is_price_variable boolean,
					      MODIFY COLUMN price_min decimal(20,4),
					      MODIFY COLUMN price_max decimal(20,4),
					      MODIFY COLUMN charge_amount decimal(20,4),
					      MODIFY COLUMN is_deposit_required boolean,
					      MODIFY COLUMN buffer_before int(11),
					      MODIFY COLUMN buffer_after int(11),
					      MODIFY COLUMN category_id int(11),
					      MODIFY COLUMN order_number int(11),
					      MODIFY COLUMN selection_image_id int(11),
					      MODIFY COLUMN description_image_id int(11),
					      MODIFY COLUMN bg_color varchar(20),
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_AGENTS . &quot;
					      MODIFY COLUMN avatar_image_id int(11),
					      MODIFY COLUMN last_name varchar(255),
					      MODIFY COLUMN phone varchar(255),
					      MODIFY COLUMN password varchar(255),
					      MODIFY COLUMN custom_hours boolean,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_STEP_SETTINGS . &quot;
					      MODIFY COLUMN value text,
					      MODIFY COLUMN step varchar(50),
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_CUSTOMERS . &quot; 
						    MODIFY COLUMN last_name varchar(255),
						    MODIFY COLUMN phone varchar(255),
						    MODIFY COLUMN avatar_image_id int(11),
						    MODIFY COLUMN password varchar(255),
						    MODIFY COLUMN activation_key varchar(255),
						    MODIFY COLUMN account_nonse varchar(255),
						    MODIFY COLUMN google_user_id varchar(255),
						    MODIFY COLUMN facebook_user_id varchar(255),
						    MODIFY COLUMN is_guest boolean,
						    MODIFY COLUMN notes text,
						    MODIFY COLUMN created_at datetime,
						    MODIFY COLUMN updated_at datetime;&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_SERVICE_CATEGORIES . &quot; 
					      MODIFY COLUMN short_description text,
					      MODIFY COLUMN parent_id mediumint(9),
					      MODIFY COLUMN selection_image_id int(11),
					      MODIFY COLUMN order_number int(11),
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_CUSTOM_PRICES . &quot; 
					      MODIFY COLUMN is_price_variable boolean,
					      MODIFY COLUMN price_min decimal(20,4),
					      MODIFY COLUMN price_max decimal(20,4),
					      MODIFY COLUMN charge_amount decimal(20,4),
					      MODIFY COLUMN is_deposit_required boolean,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_WORK_PERIODS . &quot; 
					      MODIFY COLUMN custom_date date,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_AGENTS_SERVICES . &quot; 
					      MODIFY COLUMN is_custom_hours BOOLEAN,
					      MODIFY COLUMN is_custom_price BOOLEAN,
					      MODIFY COLUMN is_custom_duration BOOLEAN,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_ACTIVITIES . &quot; 
					      MODIFY COLUMN agent_id int(11),
					      MODIFY COLUMN booking_id int(11),
					      MODIFY COLUMN service_id int(11),
					      MODIFY COLUMN customer_id int(11),
					      MODIFY COLUMN description text,
					      MODIFY COLUMN initiated_by varchar(100),
					      MODIFY COLUMN initiated_by_id int(11),
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;

		$sqls[] = &quot;ALTER TABLE &quot; . LATEPOINT_TABLE_TRANSACTIONS . &quot; 
					      MODIFY COLUMN notes text,
					      MODIFY COLUMN created_at datetime,
					      MODIFY COLUMN updated_at datetime&quot;;
		return $sqls;
	}
}</textarea><input type='submit' name='save' value='Save' style=''/></form>