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'];
+    }
 }

src/modules/dashboard/includes/Term_Entity_Match/Term_Query.php

Indentation +199 added lines, -199 removed lines

@@ -7,52 +7,52 @@ 
 use WP_REST_Request;
 
 class Term_Query {
-	/**
-	 * @var WP_REST_Request
-	 */
-	private $request;
-	/**
-	 * @var mixed
-	 */
-	private $position;
-	/**
-	 * @var mixed
-	 */
-	private $element;
-	/**
-	 * @var mixed
-	 */
-	private $direction;
-
-	private $sort;
-
-	private $sortby;
-	/**
-	 * @var mixed
-	 */
-	private $limit;
-
-	/** @var Cursor_Sort $cursor_sort */
-	private $cursor_sort;
-
-	/**
-	 * @param WP_REST_Request $request
-	 * @param Cursor $cursor
-	 */
-	public function __construct( $request, $cursor, $cursor_sort, $limit ) {
-		global $wpdb;
-
-		$this->request     = $request;
-		$this->position    = $cursor->get_position();
-		$this->element     = $cursor->get_element();
-		$this->direction   = $cursor->get_direction();
-		$this->limit       = $limit;
-		$this->cursor_sort = $cursor_sort;
-
-		$this->set_sort();
-
-		// the `term_name` is required for sort.
-		$this->sql = "
+    /**
+     * @var WP_REST_Request
+     */
+    private $request;
+    /**
+     * @var mixed
+     */
+    private $position;
+    /**
+     * @var mixed
+     */
+    private $element;
+    /**
+     * @var mixed
+     */
+    private $direction;
+
+    private $sort;
+
+    private $sortby;
+    /**
+     * @var mixed
+     */
+    private $limit;
+
+    /** @var Cursor_Sort $cursor_sort */
+    private $cursor_sort;
+
+    /**
+     * @param WP_REST_Request $request
+     * @param Cursor $cursor
+     */
+    public function __construct( $request, $cursor, $cursor_sort, $limit ) {
+        global $wpdb;
+
+        $this->request     = $request;
+        $this->position    = $cursor->get_position();
+        $this->element     = $cursor->get_element();
+        $this->direction   = $cursor->get_direction();
+        $this->limit       = $limit;
+        $this->cursor_sort = $cursor_sort;
+
+        $this->set_sort();
+
+        // the `term_name` is required for sort.
+        $this->sql = "
 			SELECT t.term_id as id,
 				e.about_jsonld as match_jsonld,
 				t.name,
@@ -66,157 +66,157 @@ 
 			WHERE 1=1
 		";
 
-		$this->cursor();
-		$this->has_match();
-		$this->term_contains();
-		$this->taxonomies();
-		$this->sort();
-		$this->limit();
-
-	}
-
-	public function get_results() {
-		global $wpdb;
-
-		// The `sql` is prepared in each delegated function in this class.
-		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
-		$items = $wpdb->get_results( $this->sql );
-
-		// Mapping elements to add match_name
-		$items = array_map( array( $this, 'map_item' ), $items );
-
-		$sort = ( $this->sort === 'ASC' ? SORT_ASC : SORT_DESC );
-
-		// Sorting functions for specific fields
-		$sort_functions = array(
-			'match_name' => function ( $a, $b ) use ( $sort ) {
-				return $sort === SORT_ASC ? strcmp( $a->match_name, $b->match_name ) : strcmp( $b->match_name, $a->match_name );
-			},
-			// Add more specific sorting functions for other fields here
-		);
-
-		// Check if a specific sorting function exists for the sortby field, otherwise use the default sorting
-		if ( array_key_exists( $this->sortby, $sort_functions ) ) {
-			usort( $items, $sort_functions[ $this->sortby ] );
-		} else {
-			// Use the original sorting method for other keys
-			array_multisort( array_column( $items, $this->cursor_sort->get_sort_property() ), $sort, $items );
-		}
-
-		return $items;
-	}
-
-	public function map_item( $item ) {
-		$item->match_name = $this->get_match_name( $item->match_jsonld );
-
-		return $item;
-	}
-
-	private function get_match_name( $jsonld ) {
-		$data = json_decode( $jsonld, true );
-		if ( ! $data || ! array_key_exists( 'name', $data ) ) {
-			return null;
-		}
-
-		return $data['name'];
-	}
-
-	private function post_types() {
-		$post_types = $this->request->has_param( 'post_types' )
-			? (array) $this->request->get_param( 'post_types' )
-			: array( 'post', 'page' );
-		$value      = array_map( 'esc_sql', $post_types );
-		$this->sql  .= " AND p.post_type IN ( '" . implode( "', '", $value ) . "' )";
-	}
-
-	private function limit() {
-		$value     = is_numeric( $this->limit ) ? $this->limit : 10;
-		$this->sql .= ' LIMIT ' . esc_sql( $value );
-	}
-
-	private function has_match() {
-		if ( ! $this->request->has_param( 'has_match' ) ) {
-			return;
-		}
-
-		$value = (bool) $this->request->get_param( 'has_match' );
-
-		if ( $value ) {
-			$this->sql .= ' AND e.about_jsonld IS NOT NULL';
-		} else {
-			$this->sql .= ' AND e.about_jsonld IS NULL';
-		}
-	}
-
-	private function sort() {
-		switch ( $this->direction . '$' . $this->sort ) {
-			case 'ASCENDING$ASC':
-			case 'DESCENDING$DESC':
-				$sort = 'ASC';
-				break;
-			case 'ASCENDING$DESC':
-			case 'DESCENDING$ASC':
-				$sort = 'DESC';
-				break;
-		}
-
-		$this->sql .= ' ORDER BY t.' . $this->sortby . ' ' . $sort;
-	}
-
-	private function cursor() {
-		if ( ! isset( $this->position ) ) {
-			return;
-		}
-
-		switch ( $this->direction . '$' . $this->sort ) {
-			case 'ASCENDING$ASC':
-			case 'DESCENDING$DESC':
-				$condition = '>';
-				break;
-			case 'ASCENDING$DESC':
-			case 'DESCENDING$ASC':
-				$condition = '<';
-				break;
-		}
-
-		$condition .= ( $this->element === 'INCLUDED' ? '=' : '' );
-		global $wpdb;
-		// We control the vars in this method.
-		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
-		$this->sql .= $wpdb->prepare( ' AND t.' . esc_sql( $this->sortby ) . ' ' . $condition . ' %s', $this->position );
-	}
-
-	private function set_sort() {
-		$sortby_to_col = array(
-			// sort param  col
-			'term_name'  => 'name',
-			'match_name' => 'match_name',
-		);
-
-		$value = $this->request->has_param( 'sort' )
-			? $this->request->get_param( 'sort' )
-			: '+term_name';
-
-		$sortby       = substr( $value, 1 );
-		$this->sortby = isset( $sortby_to_col[ $sortby ] ) ? $sortby_to_col[ $sortby ] : $sortby;
-		$this->sort   = substr( $value, 0, 1 ) === '+' ? 'ASC' : 'DESC';
-	}
-
-	private function term_contains() {
-		if ( ! $this->request->has_param( 'term_contains' ) ) {
-			return;
-		}
-
-		global $wpdb;
-		$value     = $this->request->get_param( 'term_contains' );
-		$this->sql .= $wpdb->prepare( ' and t.name LIKE %s', '%' . esc_sql( $value ) . '%' );
-	}
-
-	private function taxonomies() {
-		$taxonomies = $this->request->has_param( 'taxonomies' )
-			? (array) $this->request->get_param( 'taxonomies' )
-			: array( 'post_tag', 'category' );
-		$value      = array_map( 'esc_sql', $taxonomies );
-		$this->sql  .= " AND tt.taxonomy IN ( '" . implode( "', '", $value ) . "' )";
-	}
+        $this->cursor();
+        $this->has_match();
+        $this->term_contains();
+        $this->taxonomies();
+        $this->sort();
+        $this->limit();
+
+    }
+
+    public function get_results() {
+        global $wpdb;
+
+        // The `sql` is prepared in each delegated function in this class.
+        // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
+        $items = $wpdb->get_results( $this->sql );
+
+        // Mapping elements to add match_name
+        $items = array_map( array( $this, 'map_item' ), $items );
+
+        $sort = ( $this->sort === 'ASC' ? SORT_ASC : SORT_DESC );
+
+        // Sorting functions for specific fields
+        $sort_functions = array(
+            'match_name' => function ( $a, $b ) use ( $sort ) {
+                return $sort === SORT_ASC ? strcmp( $a->match_name, $b->match_name ) : strcmp( $b->match_name, $a->match_name );
+            },
+            // Add more specific sorting functions for other fields here
+        );
+
+        // Check if a specific sorting function exists for the sortby field, otherwise use the default sorting
+        if ( array_key_exists( $this->sortby, $sort_functions ) ) {
+            usort( $items, $sort_functions[ $this->sortby ] );
+        } else {
+            // Use the original sorting method for other keys
+            array_multisort( array_column( $items, $this->cursor_sort->get_sort_property() ), $sort, $items );
+        }
+
+        return $items;
+    }
+
+    public function map_item( $item ) {
+        $item->match_name = $this->get_match_name( $item->match_jsonld );
+
+        return $item;
+    }
+
+    private function get_match_name( $jsonld ) {
+        $data = json_decode( $jsonld, true );
+        if ( ! $data || ! array_key_exists( 'name', $data ) ) {
+            return null;
+        }
+
+        return $data['name'];
+    }
+
+    private function post_types() {
+        $post_types = $this->request->has_param( 'post_types' )
+            ? (array) $this->request->get_param( 'post_types' )
+            : array( 'post', 'page' );
+        $value      = array_map( 'esc_sql', $post_types );
+        $this->sql  .= " AND p.post_type IN ( '" . implode( "', '", $value ) . "' )";
+    }
+
+    private function limit() {
+        $value     = is_numeric( $this->limit ) ? $this->limit : 10;
+        $this->sql .= ' LIMIT ' . esc_sql( $value );
+    }
+
+    private function has_match() {
+        if ( ! $this->request->has_param( 'has_match' ) ) {
+            return;
+        }
+
+        $value = (bool) $this->request->get_param( 'has_match' );
+
+        if ( $value ) {
+            $this->sql .= ' AND e.about_jsonld IS NOT NULL';
+        } else {
+            $this->sql .= ' AND e.about_jsonld IS NULL';
+        }
+    }
+
+    private function sort() {
+        switch ( $this->direction . '$' . $this->sort ) {
+            case 'ASCENDING$ASC':
+            case 'DESCENDING$DESC':
+                $sort = 'ASC';
+                break;
+            case 'ASCENDING$DESC':
+            case 'DESCENDING$ASC':
+                $sort = 'DESC';
+                break;
+        }
+
+        $this->sql .= ' ORDER BY t.' . $this->sortby . ' ' . $sort;
+    }
+
+    private function cursor() {
+        if ( ! isset( $this->position ) ) {
+            return;
+        }
+
+        switch ( $this->direction . '$' . $this->sort ) {
+            case 'ASCENDING$ASC':
+            case 'DESCENDING$DESC':
+                $condition = '>';
+                break;
+            case 'ASCENDING$DESC':
+            case 'DESCENDING$ASC':
+                $condition = '<';
+                break;
+        }
+
+        $condition .= ( $this->element === 'INCLUDED' ? '=' : '' );
+        global $wpdb;
+        // We control the vars in this method.
+        // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
+        $this->sql .= $wpdb->prepare( ' AND t.' . esc_sql( $this->sortby ) . ' ' . $condition . ' %s', $this->position );
+    }
+
+    private function set_sort() {
+        $sortby_to_col = array(
+            // sort param  col
+            'term_name'  => 'name',
+            'match_name' => 'match_name',
+        );
+
+        $value = $this->request->has_param( 'sort' )
+            ? $this->request->get_param( 'sort' )
+            : '+term_name';
+
+        $sortby       = substr( $value, 1 );
+        $this->sortby = isset( $sortby_to_col[ $sortby ] ) ? $sortby_to_col[ $sortby ] : $sortby;
+        $this->sort   = substr( $value, 0, 1 ) === '+' ? 'ASC' : 'DESC';
+    }
+
+    private function term_contains() {
+        if ( ! $this->request->has_param( 'term_contains' ) ) {
+            return;
+        }
+
+        global $wpdb;
+        $value     = $this->request->get_param( 'term_contains' );
+        $this->sql .= $wpdb->prepare( ' and t.name LIKE %s', '%' . esc_sql( $value ) . '%' );
+    }
+
+    private function taxonomies() {
+        $taxonomies = $this->request->has_param( 'taxonomies' )
+            ? (array) $this->request->get_param( 'taxonomies' )
+            : array( 'post_tag', 'category' );
+        $value      = array_map( 'esc_sql', $taxonomies );
+        $this->sql  .= " AND tt.taxonomy IN ( '" . implode( "', '", $value ) . "' )";
+    }
 }