<?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 PHPMailer\PHPMailer\Exception;
	use WPDataAccess\WPDA;

	/**
	 * Class WPDA_Publisher_Model
	 *
	 * Model for plugin table 'menus'
	 *
	 * @author  Peter Schulz
	 * @since   2.6.0
	 */
	class WPDA_User_Menus_Model extends WPDA_Plugin_Table_Base_Model {

		const BASE_TABLE_NAME = 'wpda_menus';

		/**
		 * List of external menu items
		 *
		 * Used in {@see \WP_Data_Access_Admin::add_menu_my_tables()} to build user defined menus.
		 *
		 * Returns all external menu items. These menus are below a user defined menu.
		 *
		 * @return array List of menu items
		 * @since   1.0.0
		 */
		public static function list_external_menus() {
			global $wpdb;

			try {
				return $wpdb->get_results(
					$wpdb->prepare(
						'select * from `%1s` order by menu_name', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
						array(
							WPDA::remove_backticks( self::get_base_table_name() ),
						)
					)
				); // phpcs:ignore Standard.Category.SniffName.ErrorCode
			} catch( \Exception $e ) {
				return array();
			}
		}

		/**
		 * Get menus defined for a specific table
		 *
		 * @param string $menu_table_name Table name
		 * @param string $menu_schema_name Schema name
		 *
		 * @return array List of menus for the requested table name
		 */
		public static function get_table_menus( $menu_table_name, $menu_schema_name ) {
			global $wpdb;

			if ( self::table_exists() ) {
				return $wpdb->get_results(
					$wpdb->prepare(
						'select * from   `%1s` where menu_schema_name = %s and menu_table_name = %s order by menu_name', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
						array(
							WPDA::remove_backticks( self::get_base_table_name() ),
							$menu_schema_name,
							$menu_table_name,
						)
					),
					'ARRAY_A'
				); // phpcs:ignore Standard.Category.SniffName.ErrorCode
			} else {
				return array();
			}
		}

		/**
		 * Insert a record in the base table
		 *
		 * @param string $menu_table_name Table name
		 * @param string $menu_name Menu name
		 * @param string $menu_slug Menu slug
		 * @param string $menu_role Menu role(s)
		 * @param string $menu_schema_name Schema name
		 *
		 * @return bool TRUE = Insert was successful
		 */
		public static function insert( $menu_table_name, $menu_name, $menu_slug, $menu_role, $menu_schema_name ) {
			global $wpdb;

			if ( self::table_exists() ) {
				return ( 1 === $wpdb->insert(
						static::get_base_table_name(),
						array(
							'menu_schema_name' => $menu_schema_name,
							'menu_table_name'  => $menu_table_name,
							'menu_name'        => $menu_name,
							'menu_slug'        => $menu_slug,
							'menu_role'        => $menu_role,
						)
					)
				);
			}
		}

		/**
		 * Update a record in the base table
		 *
		 * @param int    $menu_id Menu id
		 * @param string $menu_table_name Table name
		 * @param string $menu_name Menu name
		 * @param string $menu_slug Menu slug
		 * @param string $menu_role Menu role(s)
		 * @param string $menu_schema_name Schema name
		 *
		 * @return mixed Transaction status
		 */
		public static function update( $menu_id, $menu_table_name, $menu_name, $menu_slug, $menu_role, $menu_schema_name ) {
			global $wpdb;

			return $wpdb->update(
				static::get_base_table_name(),
				array(
					'menu_schema_name' => $menu_schema_name,
					'menu_table_name'  => $menu_table_name,
					'menu_name'        => $menu_name,
					'menu_slug'        => $menu_slug,
					'menu_role'        => $menu_role,
				),
				array(
					'menu_id' => $menu_id,
				)
			);
		}

		/**
		 * Delete a record fro the base table
		 *
		 * @param int $menu_id Menu id
		 *
		 * @return mixed Transaction status
		 */
		public static function delete( $menu_id ) {
			global $wpdb;

			return $wpdb->delete(
				static::get_base_table_name(),
				array(
					'menu_id' => $menu_id,
				)
			);
		}

	}

}