insideout10 / wordlift-plugin

		return $this->jsonld_using_post_id( array( 'id' => $post->ID, ) );

	}

	public function jsonld_using_get_page_by_path( $request ) {

		$post_name = $request['post_name'];

		$post_type = $request['post_type'];

		global $wpdb;

		$sql = "

			SELECT ID

			FROM $wpdb->posts

			WHERE post_name = %s

			 AND post_type = %s

		";

		$post_id = $wpdb->get_var( $wpdb->prepare( $sql, $post_name, $post_type ) );

		if ( is_null( $post_id ) ) {

			return new WP_REST_Response( esc_html( "$post_name of type $post_type not found." ), 404, array( 'Content-Type' => 'text/html' ) );

		}

		return $this->jsonld_using_post_id( array( 'id' => $post_id, ) );

	}

	/**

	 * @param WP_REST_Request $request

	 * @return WP_REST_Response

	 * @throws \Exception

	 */

	public function jsonld_using_post_meta( $request ) {

		$meta_key   = $request['meta_key'];

		$meta_value = current( $request->get_query_params( 'meta_value' ) );

		global $wpdb;

		$sql = "

			SELECT post_id AS ID

			FROM $wpdb->postmeta

			WHERE meta_key = %s

			 AND meta_value = %s

			LIMIT 1

		";

		$post_id = $wpdb->get_var( $wpdb->prepare( $sql, $meta_key, $meta_value ) );

		if ( is_null( $post_id ) ) {

			return new WP_REST_Response( esc_html( "Post with meta key $meta_key and value $meta_value not found." ), 404, array( 'Content-Type' => 'text/html' ) );

		}

		return $this->jsonld_using_post_id( array( 'id' => $post_id, ) );

	}

}