| 1 |
<?php |
| 2 |
|
| 3 |
/** |
| 4 |
* Suppress "error - 0 - No summary was found for this file" on phpdoc generation |
| 5 |
* |
| 6 |
* @package WPDataAccess\Plugin_Table_Models |
| 7 |
*/ |
| 8 |
namespace WPDataAccess\Plugin_Table_Models; |
| 9 |
|
| 10 |
use WPDataAccess\WPDA; |
| 11 |
use WPDataAccess\Connection\WPDADB; |
| 12 |
/** |
| 13 |
* Class WPDA_Publisher_Model |
| 14 |
* |
| 15 |
* Model for plugin table 'publisher' |
| 16 |
* |
| 17 |
* @author Peter Schulz |
| 18 |
* @since 2.6.0 |
| 19 |
*/ |
| 20 |
class WPDA_Publisher_Model extends WPDA_Plugin_Table_Base_Model { |
| 21 |
const BASE_TABLE_NAME = 'wpda_publisher'; |
| 22 |
|
| 23 |
// Old plugin table name: do NOT change! |
| 24 |
/** |
| 25 |
* Return the data table for a specific publication id |
| 26 |
* |
| 27 |
* @param int $pub_id Publication id |
| 28 |
* |
| 29 |
* @return bool|array |
| 30 |
*/ |
| 31 |
public static function get_publication( $pub_id ) { |
| 32 |
global $wpdb; |
| 33 |
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table |
| 34 |
$dataset = $wpdb->get_results( |
| 35 |
$wpdb->prepare( 'SELECT * FROM `%1s` WHERE pub_id = %d', array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_id) ), |
| 36 |
// db call ok; no-cache ok. |
| 37 |
'ARRAY_A' |
| 38 |
); |
| 39 |
// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders |
| 40 |
return ( 1 === $wpdb->num_rows ? $dataset : false ); |
| 41 |
} |
| 42 |
|
| 43 |
/** |
| 44 |
* Return the publication for a specific publication name |
| 45 |
* |
| 46 |
* @param int $pub_name Publication name |
| 47 |
* |
| 48 |
* @return bool|array |
| 49 |
*/ |
| 50 |
public static function get_publication_by_name( $pub_name ) { |
| 51 |
global $wpdb; |
| 52 |
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table |
| 53 |
$dataset = $wpdb->get_results( |
| 54 |
$wpdb->prepare( 'SELECT * FROM `%1s` WHERE pub_name = %s', array(WPDA::remove_backticks( self::get_base_table_name() ), $pub_name) ), |
| 55 |
// db call ok; no-cache ok. |
| 56 |
'ARRAY_A' |
| 57 |
); |
| 58 |
// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders |
| 59 |
return ( 1 === $wpdb->num_rows ? $dataset : false ); |
| 60 |
} |
| 61 |
|
| 62 |
public static function get_publication_list() { |
| 63 |
global $wpdb; |
| 64 |
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table |
| 65 |
return $wpdb->get_results( |
| 66 |
$wpdb->prepare( 'SELECT * FROM `%1s` ORDER BY pub_name', array(WPDA::remove_backticks( self::get_base_table_name() )) ), |
| 67 |
// db call ok; no-cache ok. |
| 68 |
'ARRAY_A' |
| 69 |
); |
| 70 |
// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders |
| 71 |
} |
| 72 |
|
| 73 |
public static function get_temporary_table_from_custom_query( $database, $query ) { |
| 74 |
$response = array( |
| 75 |
'data' => array(), |
| 76 |
'msg' => '', |
| 77 |
); |
| 78 |
} |
| 79 |
|
| 80 |
} |
| 81 |
|
