function populate_mbdb_book_columns($column, $post_id)
{
// get the book for the current row
$book = MBDB()->books->get($post_id);
// if the book is invalid, exit
if ($book == null) {
return;
}
// if this is the genre or series column (taxonomies)
// just get the term list and display that delimited by commas
// and then exit. No further processing necessary
if ($column == 'mbdb_genre' || $column == 'mbdb_series') {
do_action('mbdb_book_pre_' . $column . '_column');
echo apply_filters('mbdb_book_' . $column . '_column', get_the_term_list($post_id, $column, '', ', '));
do_action('mbdb_book_post_' . $column . '_column');
return;
}
// if the column is a property of book, grab that data
if (property_exists($book, $column)) {
$data = $book->{$column};
} else {
$data = '';
}
switch ($column) {
// book cover: display as an image
case 'cover':
do_action('mbdb_book_pre_mbdb_cover_column', $column, $data, $book);
if ($data != '') {
$alt = mbdb_get_alt_text($book->cover_id, __('Book Cover:', 'mooberry-book-manager') . ' ' . get_the_title($post_id));
echo apply_filters('mbdb_book_mbdb_cover_column', '<IMG SRC="' . esc_url($data) . '" width="100" ' . $alt . ' />', $column, $data, $book);
}
do_action('mbdb_book_post_mbdb_cover_column', $column, $data, $book);
break;
// release date: use short format
// release date: use short format
case 'release_date':
do_action('mbdb_book_pre_mbdb_published_column', $column, $data, $book);
if (!empty($data)) {
// TO DO validate data to be a date??
/* translators: short date format. see http://php.net/date */
echo apply_filters('mbdb_book_mbdb_published_column', date(__('m/d/Y'), strtotime($data)), $column, $data, $book);
}
do_action('mbdb_book_post_mbdb_published_column', $column, $data, $book);
break;
// publisher: display publisher name
// does not come from book object
// publisher: display publisher name
// does not come from book object
case 'publisher_id':
$publisher = mbdb_get_publisher_info($data);
do_action('mbdb_book_pre_mbdb_publisher_column', $column, $publisher, $book);
echo apply_filters('mbdb_book_mbdb_publisher_column', $publisher['name'], $column, $publisher, $book);
do_action('mbdb_book_post_mbdb_publisher_column', $column, $publisher, $book);
break;
default:
do_action('mbdb_book_pre_mbdb_' . $column . '_column', $column, $data, $book);
echo apply_filters('mbdb_book_mbdb_' . $column . '_column', $data, $book, $post_id, $column);
do_action('mbdb_book_post_mbdb_' . $column . '_column', $column, $data, $book);
}
}
public function get_ordered_selection($selection, $selection_ids, $sort, $book_ids = null, $taxonomy = null)
{
// selection_ids = book_ids if selection = "custom"
// = tax_ids if selection is a taxonomy
// = publisher_ids if selection = "publisher"
// should be null otherwise
// book_ids is an optional, additional filtering of book ids
// taxonmy: array of taxonomy and id(s) to filter on. Also includes publisher.
// Examples:
// { series => 24 }
// { genre => { 20, 21 } }
// { publisher => 15 } // publisher is expected to be a single value. If it's an array, only the 1st is selected
// $sort = titleA, titleD, pubdateA, pubdateD, series_order
// OR { field, direction } ie { release_date, DESC }
// validate inputs
// SORT VARIABLES
//if an array is passed in, separate into field, direction
if (is_array($sort)) {
list($sort, $order) = $sort;
} else {
// otherwise, set field, direction based on value
list($sort, $order) = $this->get_sort_fields($sort);
}
// if getting books by series, the sort should be by series aascending
if ($taxonomy == null && $selection == 'series') {
$sort = 'series_order';
$order = 'ASC';
} else {
if ($taxonomy != null && array_key_exists('series', $taxonomy)) {
$sort = 'series_order';
$order = 'ASC';
}
}
// ensure that the sort field is a column in the table
// and that the direction is either ASC or DESC
$sort = $this->validate_orderby($sort);
$order = $this->validate_order($order);
// SELECTION VARIABLES
// default to all books
$book_selection_options = mbdb_book_grid_selection_options();
if (!array_key_exists($selection, $book_selection_options)) {
$selection = 'all';
}
$taxonomies = array('genre', 'series', 'tag', 'illustrator', 'editor', 'cover_artist');
// if custom, genre, series, tag, illustrator, editor, cover artist, or publisher and no selection ids are passed, default to all books
// otherwise if selection ids is not an array, make it an array
if (in_array($selection, array_merge(array('custom', 'publisher'), $taxonomies))) {
if ($selection_ids == null || $selection_ids == '') {
$selection = 'all';
} else {
if (!is_array($selection_ids)) {
$selection_ids = array($selection_ids);
}
}
}
// TAXONOMY ARRAY
// if taxonomy is supplied, the keys must be one of the options
if ($taxonomy) {
$tax_options = array_keys(mbdb_book_grid_group_by_options());
foreach ($taxonomy as $tax => $tax_ids) {
if (!in_array($tax, $tax_options)) {
unset($taxonomy[$tax]);
}
}
if (count($taxonomy) == 0) {
$taxonomy = null;
}
}
$select = 'SELECT DISTINCT ';
$join = ' JOIN ' . $this->prefix() . 'posts p ON p.id = b.book_id ';
$where = ' WHERE p.post_status = "publish" ';
$orderby = ' ORDER BY ';
// if book_ids are sent, filter by them
if ($book_ids != null) {
if (!is_array($book_ids)) {
$book_ids = array($book_ids);
}
$book_ids = array_map('absint', $book_ids);
$where .= ' AND (book_id in (' . implode(', ', $book_ids) . ') ) ';
}
// set the where clause
switch ($selection) {
case 'all':
// no change
// this is included only so it doesn't fall into the "default"
$where .= '';
break;
case 'published':
$where .= ' AND ( release_date <= CURRENT_DATE() ) ';
break;
case 'unpublished':
$where .= ' AND ( release_date > CURRENT_DATE() OR release_date IS NULL ) ';
break;
case 'custom':
$selection_ids = array_map('absint', $selection_ids);
$where .= ' AND (book_id in (' . implode(', ', $selection_ids) . ') ) ';
break;
case 'publisher':
$selection_ids = array_map('esc_sql', $selection_ids);
$where .= ' AND ( b.publisher_id in ( "' . implode('", "', $selection_ids) . '" ) ) ';
break;
default:
// anything else is a taxonomy, a type handled by another add-on, or an
// invalid input
// if it's a taxonomy, add where and join
if (in_array($selection, $taxonomies)) {
$selection_ids = array_map('absint', $selection_ids);
$where .= ' AND ( tt.taxonomy = "mbdb_' . $selection . '"
AND tt.term_id in ( ' . implode(', ', $selection_ids) . ' )
AND p.post_type = "mbdb_book" ) ';
$join .= ' JOIN ' . $this->prefix() . 'term_relationships AS tr ON tr.object_id = b.book_id
JOIN ' . $this->prefix() . 'term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id ';
}
break;
}
// add in taxonomy filtering
if ($taxonomy != null) {
$tax_level = 2;
foreach ($taxonomy as $tax => $tax_ids) {
switch ($tax) {
case 'none':
// no additional filtering needed, this is the innermost level
break 2;
case 'publisher':
//if -1 then get books that don't have a publisher
if ($tax_ids == -1) {
$select .= '"" AS name' . $tax_level . ', ';
$where .= ' AND (b.publisher_id IS NULL) ';
} else {
if (is_array($tax_ids)) {
$tax_ids = $tax_ids[0];
}
$publisher = mbdb_get_publisher_info($tax_ids);
if ($publisher != null && array_key_exists('name', $publisher)) {
$select .= '"' . $publisher['name'] . '" as name' . $tax_level . ', ';
$where .= ' AND (b.publisher_id ="' . esc_sql($tax_ids) . '") ';
}
}
break;
// anything left is a taxonomy
// anything left is a taxonomy
default:
if (in_array($tax, $taxonomies)) {
// if -1 then get books that are NOT in any of this taxonomny
if ($tax_ids == -1) {
$select .= ' "" AS name' . $tax_level . ', ';
$where .= ' and b.book_id not in (select book_id from ' . $this->table_name . ' as b
join ' . $this->prefix() . 'term_relationships as tr3 on tr3.object_id = b.book_id
join ' . $this->prefix() . 'term_taxonomy tt3 on tt3.term_taxonomy_id = tr3.term_taxonomy_id
where tt3.taxonomy = "mbdb_' . $tax . '" ) ';
} else {
if (!is_array($tax_ids)) {
$tax_ids = array($tax_ids);
}
$tax_ids = array_map('absint', $tax_ids);
$select .= 't' . $tax_level . '.name AS name' . $tax_level . ', ';
$where .= ' AND (tt' . $tax_level . '.taxonomy = "mbdb_' . $tax . '" AND tt' . $tax_level . '.term_id in (' . implode(',', $tax_ids) . ') ) ';
$join .= ' JOIN ' . $this->prefix() . 'term_relationships AS tr' . $tax_level . ' ON tr' . $tax_level . '.object_id = b.book_id
JOIN ' . $this->prefix() . 'term_taxonomy AS tt' . $tax_level . ' ON tt' . $tax_level . '.term_taxonomy_id = tr' . $tax_level . '.term_taxonomy_id
JOIN ' . $this->prefix() . 'terms AS t' . $tax_level . ' ON t' . $tax_level . '.term_id = tt' . $tax_level . '.term_id';
}
}
break;
}
$tax_level++;
}
}
// set the order
switch ($sort) {
case 'release_date':
// sort null dates last
$orderby .= ' CASE WHEN release_date IS NULL THEN 1 ELSE 0 END, release_date ';
break;
case 'series_order':
// sort null orders last
$orderby .= ' CASE WHEN series_order IS NULL THEN 999 ELSE 0 END, series_order ';
break;
default:
$orderby .= ' post_title ';
break;
}
$select = apply_filters('mbdb_book_get_ordered_selection_select', $select);
$join = apply_filters('mbdb_book_get_ordered_selection_join', $join);
$where = apply_filters('mbdb_book_get_ordered_selection_where', $where, $selection_ids, $selection, $book_ids);
$orderby = apply_filters('mbdb_book_get_ordered_selection_orderby', $orderby, $sort, $order);
$sql = "{$select} b.book_id, p.post_title, b.cover, b.release_date, b.cover_id FROM {$this->table_name} as b {$join} {$where} {$orderby} {$order} ";
$books = $this->run_sql($sql);
return apply_filters('mbdb_book_get_ordered_selection', $books, $selection, $selection_ids, $sort, $order, $taxonomy, $book_ids);
}
/**
*
* Get the book's publisher
*
*
* @since 2.0
* @since 3.0 use custom table column name instead of post_meta
*
* @return mixed data or false if book couldn't be found or if data was blank
* ( make sure to test with === false when calling this function )
*
* @access public
*
*/
function mbdb_get_publisher_data($book = '')
{
$publisherID = mbdb_get_book_data('publisher_id', $book);
if ($publisherID === false) {
return false;
}
$publisher = mbdb_get_publisher_info($publisherID);
if ($publisher == null) {
return false;
} else {
return $publisher;
}
}
