insideout10 / wordlift-plugin

src/classes/content/wordpress/class-abstract-wordpress-content-service.php

Indentation +120 added lines, -120 removed lines

@@ -11,143 +11,143 @@
 // phpcs:ignore WordPress.WP.CapitalPDangit.MisspelledClassName
 abstract class Abstract_Wordpress_Content_Service implements Content_Service {
 
-	protected function __construct() {
+    protected function __construct() {
 
-	}
+    }
 
-	protected function get_dataset_uri() {
-		return trailingslashit( Wordlift_Configuration_Service::get_instance()->get_dataset_uri() );
-	}
+    protected function get_dataset_uri() {
+        return trailingslashit( Wordlift_Configuration_Service::get_instance()->get_dataset_uri() );
+    }
 
-	protected function is_absolute( $uri ) {
-		return 1 === preg_match( '@^https?://@', $uri );
-	}
+    protected function is_absolute( $uri ) {
+        return 1 === preg_match( '@^https?://@', $uri );
+    }
 
-	protected function is_internal( $uri ) {
-		$dataset_uri = $this->get_dataset_uri();
+    protected function is_internal( $uri ) {
+        $dataset_uri = $this->get_dataset_uri();
 
-		return ! empty( $dataset_uri ) && 0 === strpos( $uri, $dataset_uri );
-	}
+        return ! empty( $dataset_uri ) && 0 === strpos( $uri, $dataset_uri );
+    }
 
-	protected function make_absolute( $uri ) {
-		Assertions::not_empty( $this->get_dataset_uri(), '`dataset_uri` cannot be empty.' );
+    protected function make_absolute( $uri ) {
+        Assertions::not_empty( $this->get_dataset_uri(), '`dataset_uri` cannot be empty.' );
 
-		if ( 1 !== preg_match( '@^https?://@', $uri ) ) {
-			return $this->get_dataset_uri() . $uri;
-		}
+        if ( 1 !== preg_match( '@^https?://@', $uri ) ) {
+            return $this->get_dataset_uri() . $uri;
+        }
 
-		return $uri;
-	}
+        return $uri;
+    }
 
-	protected function make_relative( $uri ) {
-		$dataset_uri = $this->get_dataset_uri();
-		if ( 0 === strpos( $uri, $dataset_uri ) ) {
-			return substr( $uri, strlen( $dataset_uri ) );
-		}
+    protected function make_relative( $uri ) {
+        $dataset_uri = $this->get_dataset_uri();
+        if ( 0 === strpos( $uri, $dataset_uri ) ) {
+            return substr( $uri, strlen( $dataset_uri ) );
+        }
 
-		return $uri;
-	}
+        return $uri;
+    }
 
-	/**
-	 * @param Wordpress_Content_Id $content_id
-	 *
-	 * @return string|null
-	 */
-	public function get_about_jsonld( $content_id ) {
-		global $wpdb;
+    /**
+     * @param Wordpress_Content_Id $content_id
+     *
+     * @return string|null
+     */
+    public function get_about_jsonld( $content_id ) {
+        global $wpdb;
 
-		return $wpdb->get_var(
-			$wpdb->prepare(
-				"
+        return $wpdb->get_var(
+            $wpdb->prepare(
+                "
 			SELECT about_jsonld FROM {$wpdb->prefix}wl_entities
 			WHERE content_id = %d AND content_type = %d
 			",
-				$content_id->get_id(),
-				$content_id->get_type()
-			)
-		);
-	}
-
-	/**
-	 * @param Wordpress_Content_Id $content_id
-	 * @param string $value
-	 *
-	 * @throws Exception If the 'match_name' column does not exist in the database table.
-	 */
-	public function set_about_jsonld( $content_id, $value ) {
-		global $wpdb;
-
-		// Cleanup value.
-		$value      = ( is_string( $value ) && strlen( $value ) > 2 ) ? $value : null;
-		$match_name = "NULL";
-
-		if ( $value ) {
-			// Check if the 'match_name' column exists in the database table
-			$columns = $wpdb->get_col_info( 'name', 0 );
-			if ( in_array( 'match_name', $columns ) ) {
-				$match_name = $this->get_match_name( $value );
-			}
-		}
-
-		// This `hack` is necessary to ensure the entity exists in the entities table, but we
-		// should revise how this works really.
-		//
-		// This is currently needed because rel_uri is required in the table.
-		switch ( $content_id->get_type() ) {
-			case Object_Type_Enum::POST:
-				Wordpress_Dataset_Content_Service_Hooks::insert_post( $content_id->get_id() );
-				break;
-			case Object_Type_Enum::TERM:
-				Wordpress_Dataset_Content_Service_Hooks::created_term( $content_id->get_id() );
-				break;
-			case Object_Type_Enum::USER:
-				Wordpress_Dataset_Content_Service_Hooks::user_register( $content_id->get_id() );
-				break;
-		}
-
-		/**
-		 * As of May 16 2023, $wpdb:prepare doesnt support null
-		 * values in about_jsonld, this results in NULL values being populated
-		 * as `null` if we directly pass it to the prepare function(). So its necessary
-		 * to make the query conditional based on the $value
-		 */
-		if ( null === $value ) {
-			return $wpdb->query(
-				$wpdb->prepare(
-					"UPDATE {$wpdb->prefix}wl_entities
+                $content_id->get_id(),
+                $content_id->get_type()
+            )
+        );
+    }
+
+    /**
+     * @param Wordpress_Content_Id $content_id
+     * @param string $value
+     *
+     * @throws Exception If the 'match_name' column does not exist in the database table.
+     */
+    public function set_about_jsonld( $content_id, $value ) {
+        global $wpdb;
+
+        // Cleanup value.
+        $value      = ( is_string( $value ) && strlen( $value ) > 2 ) ? $value : null;
+        $match_name = "NULL";
+
+        if ( $value ) {
+            // Check if the 'match_name' column exists in the database table
+            $columns = $wpdb->get_col_info( 'name', 0 );
+            if ( in_array( 'match_name', $columns ) ) {
+                $match_name = $this->get_match_name( $value );
+            }
+        }
+
+        // This `hack` is necessary to ensure the entity exists in the entities table, but we
+        // should revise how this works really.
+        //
+        // This is currently needed because rel_uri is required in the table.
+        switch ( $content_id->get_type() ) {
+            case Object_Type_Enum::POST:
+                Wordpress_Dataset_Content_Service_Hooks::insert_post( $content_id->get_id() );
+                break;
+            case Object_Type_Enum::TERM:
+                Wordpress_Dataset_Content_Service_Hooks::created_term( $content_id->get_id() );
+                break;
+            case Object_Type_Enum::USER:
+                Wordpress_Dataset_Content_Service_Hooks::user_register( $content_id->get_id() );
+                break;
+        }
+
+        /**
+         * As of May 16 2023, $wpdb:prepare doesnt support null
+         * values in about_jsonld, this results in NULL values being populated
+         * as `null` if we directly pass it to the prepare function(). So its necessary
+         * to make the query conditional based on the $value
+         */
+        if ( null === $value ) {
+            return $wpdb->query(
+                $wpdb->prepare(
+                    "UPDATE {$wpdb->prefix}wl_entities
 					SET about_jsonld = NULL, match_name = %s
 					WHERE content_id = %d AND content_type = %d",
-					$match_name,
-					$content_id->get_id(),
-					$content_id->get_type()
-				)
-			);
-		}
-
-		return $wpdb->query(
-			$wpdb->prepare(
-				"UPDATE {$wpdb->prefix}wl_entities
+                    $match_name,
+                    $content_id->get_id(),
+                    $content_id->get_type()
+                )
+            );
+        }
+
+        return $wpdb->query(
+            $wpdb->prepare(
+                "UPDATE {$wpdb->prefix}wl_entities
 				SET about_jsonld = %s, match_name = %s
 				WHERE content_id = %d AND content_type = %d",
-				$value,
-				$match_name,
-				$content_id->get_id(),
-				$content_id->get_type()
-			)
-		);
-	}
-
-	/**
-	 * @param $jsonld
-	 *
-	 * @return mixed|null
-	 */
-	public function get_match_name( $jsonld ) {
-		$data = json_decode( $jsonld, true );
-		if ( ! $data || ! array_key_exists( 'name', $data ) ) {
-			return "NULL";
-		}
-
-		return $data['name'];
-	}
+                $value,
+                $match_name,
+                $content_id->get_id(),
+                $content_id->get_type()
+            )
+        );
+    }
+
+    /**
+     * @param $jsonld
+     *
+     * @return mixed|null
+     */
+    public function get_match_name( $jsonld ) {
+        $data = json_decode( $jsonld, true );
+        if ( ! $data || ! array_key_exists( 'name', $data ) ) {
+            return "NULL";
+        }
+
+        return $data['name'];
+    }
 }

src/install/class-wordlift-install-3-49-1.php

Indentation +68 added lines, -68 removed lines

@@ -7,85 +7,85 @@
  */
 class Wordlift_Install_3_49_1 extends Wordlift_Install {
 
-	/**
-	 * {@inheritdoc}
-	 */
-	protected static $version = '3.49.1';
+    /**
+     * {@inheritdoc}
+     */
+    protected static $version = '3.49.1';
 
-	/**
-	 * Is column exists
-	 *
-	 * @param $column_name
-	 *
-	 * @return mixed
-	 */
-	public static function is_column_exists( $column_name ) {
-		global $wpdb;
+    /**
+     * Is column exists
+     *
+     * @param $column_name
+     *
+     * @return mixed
+     */
+    public static function is_column_exists( $column_name ) {
+        global $wpdb;
 
-		return $wpdb->get_results(
-			$wpdb->prepare(
-				"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name ='{$wpdb->prefix}wl_relation_instances' AND column_name = %s",
-				$column_name
-			)
-		);
-	}
+        return $wpdb->get_results(
+            $wpdb->prepare(
+                "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name ='{$wpdb->prefix}wl_relation_instances' AND column_name = %s",
+                $column_name
+            )
+        );
+    }
 
-	/**
-	 * Install
-	 *
-	 * @return void
-	 */
-	public function install() {
-		global $wpdb;
+    /**
+     * Install
+     *
+     * @return void
+     */
+    public function install() {
+        global $wpdb;
 
-		// Check if 'match_name' column exists
-		if ( self::is_column_exists( 'match_name' ) ) {
-			return;
-		}
+        // Check if 'match_name' column exists
+        if ( self::is_column_exists( 'match_name' ) ) {
+            return;
+        }
 
-		// Add new 'match_name' column
-		$wpdb->query(
-			"ALTER TABLE {$wpdb->prefix}wl_relation_instances
+        // Add new 'match_name' column
+        $wpdb->query(
+            "ALTER TABLE {$wpdb->prefix}wl_relation_instances
 					ADD match_name VARCHAR(255) AFTER about_jsonld;"
-		);
+        );
 
-		// Get all rows with 'about_jsonld'
-		$results = $wpdb->get_results(
-			"SELECT id, about_jsonld FROM {$wpdb->prefix}wl_relation_instances WHERE about_jsonld IS NOT NULL",
-			ARRAY_A
-		);
+        // Get all rows with 'about_jsonld'
+        $results = $wpdb->get_results(
+            "SELECT id, about_jsonld FROM {$wpdb->prefix}wl_relation_instances WHERE about_jsonld IS NOT NULL",
+            ARRAY_A
+        );
 
-		// Update 'match_name' for each row
-		foreach ( $results as $row ) {
-			$match_name = $this->get_match_name( $row['about_jsonld'] );
+        // Update 'match_name' for each row
+        foreach ( $results as $row ) {
+            $match_name = $this->get_match_name( $row['about_jsonld'] );
 
-			if ( is_null( $match_name ) ) {
-				continue;
-			}
+            if ( is_null( $match_name ) ) {
+                continue;
+            }
 
-			$wpdb->update(
-				"{$wpdb->prefix}wl_relation_instances",
-				array( 'match_name' => $match_name ),
-				array( 'id' => $row['id'] )
-			);
-		}
+            $wpdb->update(
+                "{$wpdb->prefix}wl_relation_instances",
+                array( 'match_name' => $match_name ),
+                array( 'id' => $row['id'] )
+            );
+        }
 
-		Ttl_Cache::flush_all();
-	}
+        Ttl_Cache::flush_all();
+    }
 
-	/**
-	 * Get match name
-	 *
-	 * @param $jsonld
-	 *
-	 * @return mixed|null
-	 */
-	public function get_match_name( $jsonld ) {
-		$data = json_decode( $jsonld, true );
-		if ( ! $data || ! array_key_exists( 'name', $data ) ) {
-			return null;
-		}
+    /**
+     * Get match name
+     *
+     * @param $jsonld
+     *
+     * @return mixed|null
+     */
+    public function get_match_name( $jsonld ) {
+        $data = json_decode( $jsonld, true );
+        if ( ! $data || ! array_key_exists( 'name', $data ) ) {
+            return null;
+        }
 
-		return $data['name'];
-	}
+        return $data['name'];
+    }
 }