<?php

/**
 * Suppress "error - 0 - No summary was found for this file" on phpdoc generation
 *
 * @package WPDataAccess\Plugin_Table_Models
 */

namespace WPDataAccess\Plugin_Table_Models {

	use WPDataAccess\WPDA;

	/**
	 * Class WPDP_Page_Model
	 *
	 * Model for plugin table 'wpda_project_page'
	 *
	 * @author  Peter Schulz
	 * @since   2.6.0
	 */
	class WPDP_Page_Model extends WPDA_Plugin_Table_Base_Model {

		const BASE_TABLE_NAME = 'wpda_project_page';

		/**
		 * Method overwritten for different table name handling
		 *
		 * @return string Table name
		 */
		public static function get_base_table_name() {
			static::check_base_table_name();

			global $wpdb;
			return $wpdb->prefix . static::BASE_TABLE_NAME;
		}

		/**
		 * Get project page
		 *
		 * @param $project_id
		 * @param $page_id
		 *
		 * @return mixed
		 */
		public static function get_page( $project_id, $page_id ) {
			static::check_base_table_name();

			global $wpdb;
			return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
				$wpdb->prepare(
					'select * from `%1s` where project_id = %d and page_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
					array(
						WPDA::remove_backticks( static::get_base_table_name() ),
						$project_id,
						$page_id,
					)
				),
				'ARRAY_A'
			); 
		}

		/**
		 * Get project page
		 *
		 * @param $page_id
		 *
		 * @return mixed
		 */
		public static function get_page_from_page_id( $page_id ) {
			static::check_base_table_name();

			global $wpdb;
			return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
				$wpdb->prepare(
					'select * from `%1s` where page_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
					array(
						WPDA::remove_backticks( static::get_base_table_name() ),
						$page_id,
					)
				),
				'ARRAY_A'
			); 
		}

	}

}