<?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;
use WPDataAccess\Connection\WPDADB;
/**
 * Class WPDA_Publisher_Model
 *
 * Model for plugin table 'publisher'
 *
 * @author  Peter Schulz
 * @since   2.6.0
 */
class WPDA_Publisher_Model extends WPDA_Plugin_Table_Base_Model {
    const BASE_TABLE_NAME = 'wpda_publisher';

    // Old plugin table name: do NOT change!
    /**
     * Return the data table for a specific publication id
     *
     * @param int $pub_id Publication id
     *
     * @return bool|array
     */
    public static function get_publication( $pub_id ) {
        global $wpdb;
        // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
        $dataset = $wpdb->get_results( 
            $wpdb->prepare( 'SELECT * FROM `%1s` WHERE pub_id = %d', array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_id) ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
        return ( 1 === $wpdb->num_rows ? $dataset : false );
    }

    /**
     * Return the publication for a specific publication name
     *
     * @param int $pub_name Publication name
     *
     * @return bool|array
     */
    public static function get_publication_by_name( $pub_name ) {
        global $wpdb;
        // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
        $dataset = $wpdb->get_results( 
            $wpdb->prepare( 'SELECT * FROM `%1s` WHERE pub_name = %s', array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_name) ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
        return ( 1 === $wpdb->num_rows ? $dataset : false );
    }

    public static function get_publication_list() {
        global $wpdb;
        // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
        return $wpdb->get_results( 
            $wpdb->prepare( 'SELECT * FROM `%1s` ORDER BY pub_name', array(WPDA::remove_backticks( self::get_base_table_name() )) ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
    }

    public static function get_temporary_table_from_custom_query( $database, $query ) {
        $response = array(
            'data' => array(),
            'msg'  => '',
        );
    }

}