<?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;
        $dataset = $wpdb->get_results( 
            $wpdb->prepare( 
                'SELECT * FROM `%1s` WHERE pub_id = %d',
                // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
                array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_id)
             ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:ignore Standard.Category.SniffName.ErrorCode
        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;
        $dataset = $wpdb->get_results( 
            $wpdb->prepare( 
                'SELECT * FROM `%1s` WHERE pub_name = %s',
                // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
                array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_name)
             ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:ignore Standard.Category.SniffName.ErrorCode
        return ( 1 === $wpdb->num_rows ? $dataset : false );
    }

    public static function get_publication_list() {
        global $wpdb;
        return $wpdb->get_results( 
            $wpdb->prepare( 
                'SELECT * FROM `%1s` ORDER BY pub_name',
                // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
                array(WPDA::remove_backticks( self::get_base_table_name() ))
             ),
            // db call ok; no-cache ok.
            'ARRAY_A'
         );
        // phpcs:ignore Standard.Category.SniffName.ErrorCode
    }

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

}