<?php
/**
 *
 */

/**
 * handles all database updates for the plugin
 *
 * Class Thrive_Leads_Database_Manager
 */
class Thrive_Leads_Database_Manager {
	/**
	 * @var string version as xx.xx
	 */
	protected static $CURRENT_DB_VERSION;


	/**
	 * Get the current version of database tables
	 * If there is no version saved 0.0 is returned
	 * @return mixed|string|void
	 */
	public static function dbVersion() {
		if ( empty( self::$CURRENT_DB_VERSION ) ) {
			// check for previous version installed
			$existing = get_option( 'tve_leads_version', false );
			/**
			 * if there is no TL previously installed => run all queries
			 */
			if ( empty( $existing ) ) {
				$default = '0.0';
			} elseif ( version_compare( $existing, '1.12', '<' ) ) {
				/**
				 * if the current version is between 1.0 - 1.12, use that
				 */
				$default = $existing;
			} else {
				/**
				 * the 1.12 should be used when there is no tve_leads_db_version option
				 */
				$default = '1.12';
			}
			self::$CURRENT_DB_VERSION = get_option( 'tve_leads_db_version', $default );
		}

		return self::$CURRENT_DB_VERSION;
	}

	/**
	 * Compare db version with code version
	 * Runs all the scrips of old db version until the current code version
	 */
	public static function check() {
		if ( is_admin() && ! empty( $_REQUEST['tve_leads_db_reset'] ) ) {
			delete_option( 'tve_leads_db_version' );
			delete_option( 'tve_leads_version' );
		}

		if ( version_compare( self::dbVersion(), TVE_LEADS_DB_VERSION, '<' ) ) {

			$scripts = self::getScripts( self::dbVersion(), TVE_LEADS_DB_VERSION );

			if ( ! empty( $scripts ) ) {
				define( 'TVE_LEADS_DB_UPGRADE', true );
			}
			global $wpdb;
			$wpdb->suppress_errors();
			foreach ( $scripts as $file_path ) {
				require $file_path;
			}

			update_option( 'tve_leads_db_version', TVE_LEADS_DB_VERSION );
		}
	}

	/**
	 * get all DB update scripts from $fromVersion to $toVersion
	 *
	 * @param $fromVersion
	 * @param $toVersion
	 *
	 * @return array
	 */
	protected static function getScripts( $fromVersion, $toVersion ) {
		$scripts = array();
		$dir     = new DirectoryIterator( plugin_dir_path( __FILE__ ) . 'migrations/' );
		foreach ( $dir as $file ) {
			/**
			 * @var $file DirectoryIterator
			 */
			if ( $file->isDot() ) {
				continue;
			}
			$scriptVersion = self::getScriptVersion( $file->getFilename() );
			if ( empty( $scriptVersion ) ) {
				continue;
			}
			if ( version_compare( $scriptVersion, $fromVersion, '>' ) && version_compare( $scriptVersion, $toVersion, '<=' ) ) {
				$scripts[ $scriptVersion ] = $file->getPathname();
			}
		}

		/**
		 * sort the scripts in the correct version order
		 */
		uksort( $scripts, 'version_compare' );

		return $scripts;
	}

	/**
	 * Parse the scriptName and return the version
	 *
	 * @param string $scriptName in the following format {name}-{[\d+].[\d+]}.php
	 *
	 * @return string
	 */
	protected static function getScriptVersion( $scriptName ) {
		if ( ! preg_match( '/(.+?)-(\d+)\.(\d+)(.\d+)?\.php/', $scriptName, $m ) ) {
			return false;
		}

		return $m[2] . '.' . $m[3] . ( ! empty( $m[4] ) ? $m[4] : '' );
	}

}