/**
* Initialization function, similar to __construct()
*
* @since 0.60
*
* @return void
*/
public static function initialize()
{
MLATest::$wp_3dot5 = version_compare(get_bloginfo('version'), '3.5.0', '>=') && version_compare(get_bloginfo('version'), '3.5.99', '<=');
MLATest::$wp_4dot3_plus = version_compare(get_bloginfo('version'), '4.2.99', '>=');
/*
* This is the earliest effective place to change error_reporting
*/
//error_reporting( E_ALL | E_STRICT | E_DEPRECATED | E_USER_DEPRECATED | E_USER_ERROR | E_USER_WARNING );
//error_reporting( E_ALL | E_STRICT );
MLA::$original_php_reporting = sprintf('0x%1$04X', error_reporting());
$php_reporting = trim(MLAOptions::mla_get_option(MLAOptions::MLA_DEBUG_REPLACE_PHP_REPORTING));
if (!empty($php_reporting)) {
@error_reporting(0 + $php_reporting);
}
/*
* This is the earliest effective place to localize values in other plugin components
*/
MLAOptions::mla_localize_option_definitions_array();
MLASettings::mla_localize_tablist();
MLA_List_Table::mla_localize_default_columns_array();
MLA_Upload_List_Table::mla_localize_default_columns_array();
MLA_Upload_Optional_List_Table::mla_localize_default_columns_array();
MLA_View_List_Table::mla_localize_default_columns_array();
}
/**
* Filters taxonomy updates by language for Bulk Edit during Add New Media
* and the Media/Edit Media screen
*
* @since 2.11
*
* @param integer ID of the current post
*/
public static function edit_attachment($post_id)
{
static $already_updating = 0;
MLACore::mla_debug_add(__LINE__ . " MLA_WPML::edit_attachment( {$post_id} ) _REQUEST = " . var_export($_REQUEST, true), MLACore::MLA_DEBUG_CATEGORY_LANGUAGE);
/*
* mla_update_single_item may call this action again, and
* nothing should happen while updating duplicate items
*/
if ($already_updating == $post_id || self::$updating_duplicates) {
return;
} else {
$already_updating = $post_id;
}
/*
* Check for Bulk Edit during Add New Media
*/
if (!empty($_REQUEST['mlaAddNewBulkEditFormString'])) {
if (!empty(self::$bulk_edit_request['tax_input'])) {
$tax_inputs = self::$bulk_edit_request['tax_input'];
if ('checked' == MLACore::mla_get_option('term_assignment', false, false, MLA_WPML::$mla_language_option_definitions)) {
self::_build_tax_input($post_id, $tax_inputs, self::$bulk_edit_request['tax_action']);
$tax_inputs = self::_apply_tax_input($post_id);
}
} else {
$tax_inputs = NULL;
}
$updates = MLA::mla_prepare_bulk_edits($post_id, self::$bulk_edit_request, self::$bulk_edit_map);
unset($updates['tax_input']);
unset($updates['tax_action']);
MLAData::mla_update_single_item($post_id, $updates, $tax_inputs);
return;
}
// Upload New Media Bulk Edit
/*
* For the Bulk Edit action on the Media/Assistant screen, only synchronization is needed
*/
if (!(isset($_REQUEST['bulk_action']) && 'bulk_edit' == $_REQUEST['bulk_action'])) {
/*
* This is the Media/Edit Media screen.
* The category taxonomy (edit screens) is a special case because
* post_categories_meta_box() changes the input name
*/
if (isset($_REQUEST['tax_input'])) {
$tax_inputs = $_REQUEST['tax_input'];
} else {
$tax_inputs = array();
}
if (isset($_REQUEST['post_category'])) {
$tax_inputs['category'] = $_REQUEST['post_category'];
}
if (isset($_REQUEST['tax_action'])) {
$tax_actions = $_REQUEST['tax_action'];
} else {
$tax_actions = NULL;
}
if (!empty($tax_inputs) && 'checked' == MLACore::mla_get_option('term_assignment', false, false, MLA_WPML::$mla_language_option_definitions)) {
self::_build_tax_input($post_id, $tax_inputs, $tax_actions);
$tax_inputs = self::_apply_tax_input($post_id);
}
if (!empty($tax_inputs)) {
MLAData::mla_update_single_item($post_id, array(), $tax_inputs);
}
}
// Media/Edit Media screen, NOT Bulk Edit
}
/**
* Filters taxonomy updates by language for Bulk Edit during Add New Media
* and the Media/Edit Media screen
*
* @since 2.11
*
* @param integer ID of the current post
*/
public static function edit_attachment($post_id)
{
static $already_updating = 0;
/*
* mla_update_single_item eventually calls this action again
*/
if ($already_updating == $post_id) {
return;
} else {
$already_updating = $post_id;
}
/*
* Check for Bulk Edit during Add New Media
*/
if (is_array(self::$upload_bulk_edit_args)) {
if (!empty(self::$upload_bulk_edit_args['tax_input'])) {
$tax_inputs = self::$upload_bulk_edit_args['tax_input'];
if ('checked' == MLAOptions::mla_get_option('term_assignment', false, false, MLA_WPML::$mla_language_option_definitions)) {
self::_build_tax_input($post_id, $tax_inputs, self::$upload_bulk_edit_args['tax_action']);
$tax_inputs = self::_apply_tax_input($post_id);
}
} else {
$tax_inputs = NULL;
}
$updates = MLA::mla_prepare_bulk_edits($post_id, self::$upload_bulk_edit_args, self::$upload_bulk_edit_map);
unset($updates['tax_input']);
unset($updates['tax_action']);
MLAData::mla_update_single_item($post_id, $updates, $tax_inputs);
/*
* Synchronize the changes to all other translations - NOT NEEDED
*/
if (false && 'checked' == MLAOptions::mla_get_option('term_synchronization', false, false, MLA_WPML::$mla_language_option_definitions)) {
foreach (self::$tax_input as $language => $tax_inputs) {
/*
* Skip 'tax_input_post_id' and the language we've already updated
*/
if (!isset(self::$existing_terms[$language]) || self::$existing_terms['language_code'] == $language) {
continue;
}
// Other translations have no existing terms, so we don't need _apply_synch_input()
$translation = self::$existing_terms[$language];
$tax_inputs = self::_apply_tax_input($translation['element_id'], $language);
$already_updating = $translation['element_id'];
// prevent recursion
MLAData::mla_update_single_item($translation['element_id'], $updates, $tax_inputs);
$already_updating = $post_id;
}
// translation
}
// do synchronization
return;
}
// Upload New Media Bulk Edit
/*
* For the Bulk Edit action on the Media/Assistant screen, only synchronization is needed
*/
if (!(isset($_REQUEST['bulk_action']) && 'bulk_edit' == $_REQUEST['bulk_action'])) {
/*
* The category taxonomy (edit screens) is a special case because
* post_categories_meta_box() changes the input name
*/
if (isset($_REQUEST['tax_input'])) {
$tax_inputs = $_REQUEST['tax_input'];
} else {
$tax_inputs = array();
}
if (isset($_REQUEST['post_category'])) {
$tax_inputs['category'] = $_REQUEST['post_category'];
}
if (isset($_REQUEST['tax_action'])) {
$tax_actions = $_REQUEST['tax_action'];
} else {
$tax_actions = NULL;
}
if (!empty($tax_inputs) && 'checked' == MLAOptions::mla_get_option('term_assignment', false, false, MLA_WPML::$mla_language_option_definitions)) {
self::_build_tax_input($post_id, $tax_inputs, $tax_actions);
$tax_inputs = self::_apply_tax_input($post_id);
}
if (!empty($tax_inputs)) {
MLAData::mla_update_single_item($post_id, array(), $tax_inputs);
}
}
// NOT Bulk Edit
/*
* Synchronize the changes to all other translations
*/
if ('checked' == MLAOptions::mla_get_option('term_synchronization', false, false, MLA_WPML::$mla_language_option_definitions)) {
/*
* Update terms because they have changed
*/
$terms_before = self::_update_existing_terms($post_id);
// $tax_input is a convenient source of language codes; ignore $tax_inputs
foreach (self::$tax_input as $language => $tax_inputs) {
/*
* Skip 'tax_input_post_id' and the language we've already updated
*/
if (!isset(self::$existing_terms[$language]) || self::$existing_terms['language_code'] == $language) {
continue;
}
$tax_inputs = self::_apply_synch_input($language);
if (!empty($tax_inputs)) {
$translation = self::$existing_terms[$language]['element_id'];
$already_updating = $translation;
// prevent recursion
MLAData::mla_update_single_item($translation, array(), $tax_inputs);
$already_updating = $post_id;
}
}
// translation
}
// do synchronization
}
/**
* Renders the Parent Info meta box on the Edit Media page.
* Declared public because it is a callback function.
*
* @since 0.80
*
* @param object current post
*
* @return void echoes the HTML markup for the meta box content
*/
public static function mla_parent_info_handler($post)
{
if (is_null(self::$mla_references)) {
self::$mla_references = MLAQuery::mla_fetch_attachment_references($post->ID, $post->post_parent);
}
if (is_array(self::$mla_references)) {
if (empty(self::$mla_references['parent_title'])) {
$parent_info = self::$mla_references['parent_errors'];
} else {
$flag = ', ';
switch (self::$mla_references['parent_status']) {
case 'future':
$flag .= __('Scheduled');
break;
case 'pending':
$flag .= _x('Pending', 'post state');
break;
case 'draft':
$flag .= __('Draft');
break;
default:
$flag = '';
}
$parent_info = sprintf('%1$s (%2$s%3$s) %4$s', self::$mla_references['parent_title'], self::$mla_references['parent_type'], $flag, self::$mla_references['parent_errors']);
}
} else {
$parent_info = '';
}
$parent_info = apply_filters('mla_parent_info_meta_box', $parent_info, self::$mla_references, $post);
echo '<label class="screen-reader-text" for="mla_post_parent">' . __('Post Parent', 'media-library-assistant') . '</label><input name="mla_post_parent" id="mla_post_parent" type="text" value="' . $post->post_parent . "\" />\n";
echo '<label class="screen-reader-text" for="mla_parent_info">' . __('Select Parent', 'media-library-assistant') . '</label><input name="post_parent_set" id="mla_set_parent" class="button-primary parent" type="button" value="' . __('Select', 'media-library-assistant') . '" />';
echo '<label class="screen-reader-text" for="mla_parent_info">' . __('Parent Info', 'media-library-assistant') . '</label><input name="mla_parent_info" id="mla_parent_info" type="text" readonly="readonly" disabled="disabled" value="' . esc_attr($parent_info) . "\" /></span>\n";
echo MLA::mla_set_parent_form(false);
}
/**
* Creates new items from the "Bulk Translate" list.
*
* @since 2.11
*
* @param array $item_content NULL, to indicate no handler.
* @param string $bulk_action the requested action.
* @param integer $post_id the affected attachment.
*
* @return object updated $item_content. NULL if no handler, otherwise
* ( 'message' => error or status message(s), 'body' => '' )
*/
public static function mla_list_table_custom_bulk_action($item_content, $bulk_action, $post_id)
{
global $polylang;
MLA::mla_debug_add(__LINE__ . " MLA_Polylang::mla_list_table_bulk_action_item_request( {$bulk_action}, {$post_id} )", MLA::MLA_DEBUG_CATEGORY_LANGUAGE);
if ('pll-translate' == $bulk_action) {
$translations = array();
if (isset($_REQUEST['bulk_tr_languages'])) {
$bulk_tr_languages = $_REQUEST['bulk_tr_languages'];
// Expand All Languages selection
if (isset($bulk_tr_languages['all'])) {
foreach ($polylang->model->get_languages_list() as $language) {
$bulk_tr_languages[$language->slug] = 'translate';
}
unset($bulk_tr_languages['all']);
}
// Process language selection(s)
foreach ($bulk_tr_languages as $language => $action) {
$new_id = MLA_Polylang::_get_translation($post_id, $language);
$translations[] = $new_id;
}
}
// Clear all the "Filter-by" parameters
if (isset($_REQUEST['bulk_tr_options']['clear_filters'])) {
MLA::mla_clear_filter_by();
}
if (empty($translations)) {
$item_content = array('message' => "Item {$post_id}, no translations.");
} else {
$_REQUEST['heading_suffix'] = __('Bulk Translations', 'media-library-assistant');
MLA_Polylang::$bulk_action_includes = array_merge(MLA_Polylang::$bulk_action_includes, $translations);
$translations = implode(',', $translations);
$item_content = array('message' => "Item {$post_id}, translation(s): {$translations}.");
}
}
return $item_content;
}
/**
* Flush debug information and clear buffer
*
* @since 2.12
*
* @param string $destination Destination: 'buffer' (default), 'console', 'log' or 'none'
* @param boolean $stop_collecting true (default) to stop, false to continue collection
*
* @return string debug content if $destination == 'buffer' else empty string
*/
public static function mla_debug_flush($destination = 'buffer', $stop_collecting = true)
{
$results = '';
switch ($destination) {
case 'buffer':
$results = self::mla_debug_content();
break;
case 'console':
foreach (self::$mla_debug_messages as $message) {
trigger_error($message, E_USER_WARNING);
}
break;
case 'log':
foreach (self::$mla_debug_messages as $message) {
self::_debug_log($message);
}
break;
}
self::$mla_debug_messages = array();
if ($stop_collecting) {
self::$mla_debug_mode = 'none';
}
return $results;
}
/**
* End an MLA_List_Table bulk action
*
* Add the query arguments required for the "Generated Thumbnails" filter.
*
* @since 2.13
*
* @param array $item_content NULL, to indicate no handler.
* @param string $bulk_action the requested action.
*/
public static function mla_list_table_end_bulk_action($item_content, $bulk_action)
{
if (self::MLA_GFI_ACTION != $bulk_action) {
return $item_content;
}
if (!empty(MLA_Thumbnail::$bulk_action_includes)) {
MLA::mla_clear_filter_by(array('ids'));
// Reset the current view to "All" to ensure that thumbnails are displayed
unset($_REQUEST['post_mime_type']);
unset($_POST['post_mime_type']);
unset($_GET['post_mime_type']);
unset($_REQUEST['meta_query']);
unset($_GET['meta_query']);
unset($_REQUEST['meta_slug']);
unset($_GET['meta_slug']);
// Clear the "extra_nav" controls and the Search Media box, too
unset($_REQUEST['m']);
unset($_POST['m']);
unset($_GET['m']);
unset($_REQUEST['mla_filter_term']);
unset($_POST['mla_filter_term']);
unset($_GET['mla_filter_term']);
unset($_REQUEST['s']);
unset($_POST['s']);
unset($_GET['s']);
$_REQUEST['ids'] = MLA_Thumbnail::$bulk_action_includes;
$_REQUEST['heading_suffix'] = __('Generated Thumbnails', 'media-library-assistant');
}
return $item_content;
}
/**
* Retrieve the terms in one or more taxonomies.
*
* Alternative to WordPress /wp-includes/taxonomy.php function get_terms() that provides
* an accurate count of attachments associated with each term.
*
* taxonomy - string containing one or more (comma-delimited) taxonomy names
* or an array of taxonomy names. Default 'post_tag'.
*
* post_mime_type - MIME type(s) of the items to include in the term-specific counts. Default 'all'.
*
* post_type - The post type(s) of the items to include in the term-specific counts.
* The default is "attachment".
*
* post_status - The post status value(s) of the items to include in the term-specific counts.
* The default is "inherit".
*
* ids - A comma-separated list of attachment ID values for an item-specific cloud.
*
* include - An array, comma- or space-delimited string of term ids to include
* in the return array.
*
* exclude - An array, comma- or space-delimited string of term ids to exclude
* from the return array. If 'include' is non-empty, 'exclude' is ignored.
*
* parent - term_id of the terms' immediate parent; 0 for top-level terms.
*
* minimum - minimum number of attachments a term must have to be included. Default 0.
*
* no_count - 'true', 'false' (default) to suppress term-specific attachment-counting process.
*
* number - maximum number of term objects to return. Terms are ordered by count,
* descending and then by term_id before this value is applied. Default 0.
*
* orderby - 'count', 'id', 'name' (default), 'none', 'random', 'slug'
*
* order - 'ASC' (default), 'DESC'
*
* no_orderby - 'true', 'false' (default) to suppress ALL sorting clauses else false.
*
* preserve_case - 'true', 'false' (default) to make orderby case-sensitive.
*
* pad_counts - 'true', 'false' (default) to to include the count of all children in their parents' count.
*
* limit - final number of term objects to return, for pagination. Default 0.
*
* offset - number of term objects to skip, for pagination. Default 0.
*
* @since 1.60
*
* @param array taxonomies to search and query parameters
*
* @return array array of term objects, empty if none found
*/
public static function mla_get_terms($attr)
{
global $wpdb;
/*
* Make sure $attr is an array, even if it's empty
*/
if (empty($attr)) {
$attr = array();
} elseif (is_string($attr)) {
$attr = shortcode_parse_atts($attr);
}
/*
* Merge input arguments with defaults
*/
$attr = apply_filters('mla_get_terms_query_attributes', $attr);
$arguments = shortcode_atts(self::$mla_get_terms_parameters, $attr);
$arguments = apply_filters('mla_get_terms_query_arguments', $arguments);
/*
* Build an array of individual clauses that can be filtered
*/
$clauses = array('fields' => '', 'join' => '', 'where' => '', 'order' => '', 'orderby' => '', 'limits' => '');
/*
* If we're not counting attachments per term, strip
* post fields out of list and adjust the orderby value
*/
if ($no_count = 'true' == (string) $arguments['no_count']) {
$field_array = explode(',', $arguments['fields']);
foreach ($field_array as $index => $field) {
if (false !== strpos($field, 'p.')) {
unset($field_array[$index]);
}
}
$arguments['fields'] = implode(',', $field_array);
$arguments['minimum'] = 0;
$arguments['post_mime_type'] = 'all';
if ('count' == strtolower($arguments['orderby'])) {
$arguments['orderby'] = 'none';
}
}
$clauses['fields'] = $arguments['fields'];
$clause = array('INNER JOIN `' . $wpdb->term_taxonomy . '` AS tt ON t.term_id = tt.term_id');
$clause_parameters = array();
if (!$no_count) {
$clause[] = 'LEFT JOIN `' . $wpdb->term_relationships . '` AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id';
$clause[] = 'LEFT JOIN `' . $wpdb->posts . '` AS p ON tr.object_id = p.ID';
/*
* Add type and status constraints
*/
if (is_array($arguments['post_type'])) {
$post_types = $arguments['post_type'];
} else {
$post_types = array($arguments['post_type']);
}
$placeholders = array();
foreach ($post_types as $post_type) {
$placeholders[] = '%s';
$clause_parameters[] = $post_type;
}
$clause[] = 'AND p.post_type IN (' . join(',', $placeholders) . ')';
if (is_array($arguments['post_status'])) {
$post_stati = $arguments['post_status'];
} else {
$post_stati = array($arguments['post_status']);
}
$placeholders = array();
foreach ($post_stati as $post_status) {
if ('private' != $post_status || is_user_logged_in()) {
$placeholders[] = '%s';
$clause_parameters[] = $post_status;
}
}
$clause[] = 'AND p.post_status IN (' . join(',', $placeholders) . ')';
}
$clause = join(' ', $clause);
$clauses['join'] = $wpdb->prepare($clause, $clause_parameters);
/*
* Start WHERE clause with a taxonomy constraint
*/
if (is_array($arguments['taxonomy'])) {
$taxonomies = $arguments['taxonomy'];
} else {
$taxonomies = array($arguments['taxonomy']);
}
foreach ($taxonomies as $taxonomy) {
if (!taxonomy_exists($taxonomy)) {
$error = new WP_Error('invalid_taxonomy', __('Invalid taxonomy', 'media-library-assistant'), $taxonomy);
return $error;
}
}
$clause_parameters = array();
$placeholders = array();
foreach ($taxonomies as $taxonomy) {
$placeholders[] = '%s';
$clause_parameters[] = $taxonomy;
}
$clause = array('tt.taxonomy IN (' . join(',', $placeholders) . ')');
/*
* The "ids" parameter can build an item-specific cloud.
* Compile a list of all the terms assigned to the items.
*/
if (!empty($arguments['ids']) && empty($arguments['include'])) {
$ids = wp_parse_id_list($arguments['ids']);
$placeholders = implode("','", $ids);
$clause[] = "AND p.ID IN ( '{$placeholders}' )";
$includes = array();
foreach ($ids as $id) {
foreach ($taxonomies as $taxonomy) {
$terms = get_the_terms($id, $taxonomy);
if (is_array($terms)) {
foreach ($terms as $term) {
$includes[$term->term_id] = $term->term_id;
}
// terms
}
}
// taxonomies
}
// ids
/*
* If there are no terms we want an empty cloud
*/
if (empty($includes)) {
$arguments['include'] = (string) 0x7fffffff;
} else {
ksort($includes);
$arguments['include'] = implode(',', $includes);
}
}
/*
* Add include/exclude and parent constraints to WHERE cluse
*/
if (!empty($arguments['include'])) {
$placeholders = implode("','", wp_parse_id_list($arguments['include']));
$clause[] = "AND t.term_id IN ( '{$placeholders}' )";
} elseif (!empty($arguments['exclude'])) {
$placeholders = implode("','", wp_parse_id_list($arguments['exclude']));
$clause[] = "AND t.term_id NOT IN ( '{$placeholders}' )";
}
if ('' !== $arguments['parent']) {
$parent = (int) $arguments['parent'];
$clause[] = "AND tt.parent = '{$parent}'";
}
if ('all' !== strtolower($arguments['post_mime_type'])) {
$where = str_replace('%', '%%', wp_post_mime_type_where($arguments['post_mime_type'], 'p'));
if (0 == absint($arguments['minimum'])) {
$clause[] = ' AND ( p.post_mime_type IS NULL OR ' . substr($where, 6);
} else {
$clause[] = $where;
}
}
$clause = join(' ', $clause);
$clauses['where'] = $wpdb->prepare($clause, $clause_parameters);
/*
* For the inner/initial query, always select the most popular terms
*/
if ($arguments['no_orderby']) {
$arguments['orderby'] = 'count';
$arguments['order'] = 'DESC';
}
/*
* Add sort order
*/
$orderby = strtolower($arguments['orderby']);
$order = strtoupper($arguments['order']);
if ('DESC' != $order) {
$order = 'ASC';
}
$clauses['order'] = $order;
$clauses['orderby'] = "ORDER BY {$orderby}";
/*
* Count, Descending, is the default order so no further work
* is needed unless a different order is specified
*/
if ('count' != $orderby || 'DESC' != $order) {
if ('true' == strtolower($arguments['preserve_case'])) {
$binary_keys = array('name', 'slug');
} else {
$binary_keys = array();
}
$allowed_keys = array('empty_orderby_default' => 'name', 'count' => 'count', 'id' => 'term_id', 'name' => 'name', 'random' => 'RAND()', 'slug' => 'slug');
$clause = 'ORDER BY ' . self::_validate_sql_orderby($arguments, '', $allowed_keys, $binary_keys);
$clauses['orderby'] = substr($clause, 0, strrpos($clause, ' ' . $order));
}
// add ORDER BY
/*
* Add pagination
*/
$clauses['limits'] = '';
$offset = absint($arguments['offset']);
$limit = absint($arguments['limit']);
if (0 < $offset && 0 < $limit) {
$clauses['limits'] = "LIMIT {$offset}, {$limit}";
} elseif (0 < $limit) {
$clauses['limits'] = "LIMIT {$limit}";
} elseif (0 < $offset) {
$clause_parameters = 0x7fffffff;
$clauses['limits'] = "LIMIT {$offset}, {$clause_parameters}";
}
$clauses = apply_filters('mla_get_terms_clauses', $clauses);
/*
* Build the final query
*/
$query = array('SELECT');
$query[] = $clauses['fields'];
$query[] = 'FROM `' . $wpdb->terms . '` AS t';
$query[] = $clauses['join'];
$query[] = 'WHERE (';
$query[] = $clauses['where'];
$query[] = ') GROUP BY tt.term_taxonomy_id';
$clause_parameters = absint($arguments['minimum']);
if (0 < $clause_parameters) {
$query[] = "HAVING count >= {$clause_parameters}";
}
/*
* If specifically told to omit the ORDER BY clause or the COUNT,
* supply a sort order for the initial/inner query only
*/
if (!($arguments['no_orderby'] || $no_count)) {
$query[] = 'ORDER BY count DESC, t.term_id ASC';
}
/*
* Limit the total number of terms returned
*/
$terms_limit = absint($arguments['number']);
if (0 < $terms_limit) {
$query[] = "LIMIT {$terms_limit}";
}
/*
* $final_clauses, if present, require an SQL subquery
*/
$final_clauses = array();
if ('count' != $orderby || 'DESC' != $order) {
$final_clauses[] = $clauses['orderby'];
$final_clauses[] = $clauses['order'];
}
if ('' !== $clauses['limits']) {
$final_clauses[] = $clauses['limits'];
}
/*
* If we're limiting the final results, we need to get an accurate total count first
*/
if (!$no_count && (0 < $offset || 0 < $limit)) {
$count_query = 'SELECT COUNT(*) as count FROM (' . join(' ', $query) . ' ) as subQuery';
$count = $wpdb->get_results($count_query);
$found_rows = $count[0]->count;
}
if (!empty($final_clauses)) {
if (!$no_count) {
array_unshift($query, 'SELECT * FROM (');
$query[] = ') AS subQuery';
}
$query = array_merge($query, $final_clauses);
}
$query = join(' ', $query);
$tags = $wpdb->get_results($query);
if (!isset($found_rows)) {
$found_rows = $wpdb->num_rows;
}
if (self::$mla_debug) {
MLA::mla_debug_add('<strong>' . __('mla_debug query arguments', 'media-library-assistant') . '</strong> = ' . var_export($arguments, true));
MLA::mla_debug_add('<strong>' . __('mla_debug last_query', 'media-library-assistant') . '</strong> = ' . var_export($wpdb->last_query, true));
MLA::mla_debug_add('<strong>' . __('mla_debug last_error', 'media-library-assistant') . '</strong> = ' . var_export($wpdb->last_error, true));
MLA::mla_debug_add('<strong>' . __('mla_debug num_rows', 'media-library-assistant') . '</strong> = ' . var_export($wpdb->num_rows, true));
MLA::mla_debug_add('<strong>' . __('mla_debug found_rows', 'media-library-assistant') . '</strong> = ' . var_export($found_rows, true));
}
if ('true' == strtolower(trim($arguments['pad_counts']))) {
self::_pad_term_counts($tags, reset($taxonomies), $post_types, $post_stati);
}
$tags['found_rows'] = $found_rows;
$tags = apply_filters('mla_get_terms_query_results', $tags);
return $tags;
}
/**
* Get ALL markup templates from $mla_templates, including 'default'
*
* @since 0.80
*
* @return array|null name => value for all markup templates or null if no templates
*/
public static function mla_get_markup_templates()
{
if (!is_array(self::$mla_option_templates)) {
MLA::mla_debug_add('<strong>mla_debug mla_get_markup_templates()</strong> ' . __('no templates exist', 'media-library-assistant'));
return null;
}
$templates = array();
foreach (self::$mla_option_templates as $key => $value) {
// Note order: -row-open must precede -open!
$tail = strrpos($key, '-row-open-markup');
if (!(false === $tail)) {
$name = substr($key, 0, $tail);
$templates[$name]['row-open'] = $value;
continue;
}
$tail = strrpos($key, '-open-markup');
if (!(false === $tail)) {
$name = substr($key, 0, $tail);
$templates[$name]['open'] = $value;
continue;
}
$tail = strrpos($key, '-item-markup');
if (!(false === $tail)) {
$name = substr($key, 0, $tail);
$templates[$name]['item'] = $value;
continue;
}
$tail = strrpos($key, '-row-close-markup');
if (!(false === $tail)) {
$name = substr($key, 0, $tail);
$templates[$name]['row-close'] = $value;
continue;
}
$tail = strrpos($key, '-close-markup');
if (!(false === $tail)) {
$name = substr($key, 0, $tail);
$templates[$name]['close'] = $value;
}
}
// foreach
return $templates;
}
/**
* Build the hidden row templates for inline editing (quick and bulk edit)
*
* inspired by inline_edit() in wp-admin\includes\class-wp-posts-list-table.php.
*
* @since 0.20
*
* @param object MLA List Table object
*
* @return string HTML <form> markup for hidden rows
*/
private static function _build_inline_edit_form($MLAListTable)
{
$taxonomies = get_object_taxonomies('attachment', 'objects');
$hierarchical_taxonomies = array();
$flat_taxonomies = array();
foreach ($taxonomies as $tax_name => $tax_object) {
if ($tax_object->hierarchical && $tax_object->show_ui && MLACore::mla_taxonomy_support($tax_name, 'quick-edit')) {
$hierarchical_taxonomies[$tax_name] = $tax_object;
} elseif ($tax_object->show_ui && MLACore::mla_taxonomy_support($tax_name, 'quick-edit')) {
$flat_taxonomies[$tax_name] = $tax_object;
}
}
$page_template_array = MLAData::mla_load_template('admin-inline-edit-form.tpl');
if (!is_array($page_template_array)) {
/* translators: 1: ERROR tag 2: function name 3: non-array value */
error_log(sprintf(_x('%1$s: %2$s non-array "%3$s"', 'error_log', 'media-library-assistant'), __('ERROR', 'media-library-assistant'), 'MLA::_build_inline_edit_form', var_export($page_template_array, true)), 0);
return '';
}
if ($authors = self::mla_authors_dropdown()) {
$authors_dropdown = ' <label class="inline-edit-author">' . "\n";
$authors_dropdown .= ' <span class="title">' . __('Author', 'media-library-assistant') . '</span>' . "\n";
$authors_dropdown .= $authors . "\n";
$authors_dropdown .= ' </label>' . "\n";
} else {
$authors_dropdown = '';
}
$custom_fields = '';
foreach (MLACore::mla_custom_field_support('quick_edit') as $slug => $details) {
$page_values = array('slug' => $slug, 'label' => esc_attr($details['name']));
$custom_fields .= MLAData::mla_parse_template($page_template_array['custom_field'], $page_values);
}
/*
* The middle column contains the hierarchical taxonomies, e.g., Attachment Category
*/
$quick_middle_column = '';
$bulk_middle_column = '';
if (count($hierarchical_taxonomies)) {
$quick_category_blocks = '';
$bulk_category_blocks = '';
foreach ($hierarchical_taxonomies as $tax_name => $tax_object) {
if (current_user_can($tax_object->cap->assign_terms)) {
ob_start();
wp_terms_checklist(NULL, array('taxonomy' => $tax_name));
$tax_checklist = ob_get_contents();
ob_end_clean();
$page_values = array('tax_html' => esc_html($tax_object->labels->name), 'more' => __('more', 'media-library-assistant'), 'less' => __('less', 'media-library-assistant'), 'tax_attr' => esc_attr($tax_name), 'tax_checklist' => $tax_checklist, 'Add' => __('Add', 'media-library-assistant'), 'Remove' => __('Remove', 'media-library-assistant'), 'Replace' => __('Replace', 'media-library-assistant'));
$category_block = MLAData::mla_parse_template($page_template_array['category_block'], $page_values);
$taxonomy_options = MLAData::mla_parse_template($page_template_array['taxonomy_options'], $page_values);
$quick_category_blocks .= $category_block;
$bulk_category_blocks .= $category_block . $taxonomy_options;
}
// current_user_can
}
// foreach $hierarchical_taxonomies
$page_values = array('category_blocks' => $quick_category_blocks);
$quick_middle_column = MLAData::mla_parse_template($page_template_array['category_fieldset'], $page_values);
$page_values = array('category_blocks' => $bulk_category_blocks);
$bulk_middle_column = MLAData::mla_parse_template($page_template_array['category_fieldset'], $page_values);
}
// count( $hierarchical_taxonomies )
/*
* The right-hand column contains the flat taxonomies, e.g., Attachment Tag
*/
$quick_right_column = '';
$bulk_right_column = '';
if (count($flat_taxonomies)) {
$quick_tag_blocks = '';
$bulk_tag_blocks = '';
foreach ($flat_taxonomies as $tax_name => $tax_object) {
if (current_user_can($tax_object->cap->assign_terms)) {
$page_values = array('tax_html' => esc_html($tax_object->labels->name), 'tax_attr' => esc_attr($tax_name), 'Add' => __('Add', 'media-library-assistant'), 'Remove' => __('Remove', 'media-library-assistant'), 'Replace' => __('Replace', 'media-library-assistant'));
$tag_block = MLAData::mla_parse_template($page_template_array['tag_block'], $page_values);
$taxonomy_options = MLAData::mla_parse_template($page_template_array['taxonomy_options'], $page_values);
$quick_tag_blocks .= $tag_block;
$bulk_tag_blocks .= $tag_block . $taxonomy_options;
}
// current_user_can
}
// foreach $flat_taxonomies
$page_values = array('tag_blocks' => $quick_tag_blocks);
$quick_right_column = MLAData::mla_parse_template($page_template_array['tag_fieldset'], $page_values);
$page_values = array('tag_blocks' => $bulk_tag_blocks);
$bulk_right_column = MLAData::mla_parse_template($page_template_array['tag_fieldset'], $page_values);
}
// count( $flat_taxonomies )
if ($authors = self::mla_authors_dropdown(-1)) {
$bulk_authors_dropdown = ' <label class="inline-edit-author alignright">' . "\n";
$bulk_authors_dropdown .= ' <span class="title">' . __('Author', 'media-library-assistant') . '</span>' . "\n";
$bulk_authors_dropdown .= $authors . "\n";
$bulk_authors_dropdown .= ' </label>' . "\n";
} else {
$bulk_authors_dropdown = '';
}
$bulk_custom_fields = '';
foreach (MLACore::mla_custom_field_support('bulk_edit') as $slug => $details) {
$page_values = array('slug' => $slug, 'label' => esc_attr($details['name']));
$bulk_custom_fields .= MLAData::mla_parse_template($page_template_array['custom_field'], $page_values);
}
$set_parent_form = MLA::mla_set_parent_form();
$page_values = array('colspan' => $MLAListTable->get_column_count(), 'Quick Edit' => __('Quick Edit', 'media-library-assistant'), 'Title' => __('Title', 'media-library-assistant'), 'Name/Slug' => __('Name/Slug', 'media-library-assistant'), 'Caption' => __('Caption', 'media-library-assistant'), 'Description' => __('Description', 'media-library-assistant'), 'ALT Text' => __('ALT Text', 'media-library-assistant'), 'Parent ID' => __('Parent ID', 'media-library-assistant'), 'Select' => __('Select', 'media-library-assistant'), 'Menu Order' => __('Menu Order', 'media-library-assistant'), 'authors' => $authors_dropdown, 'custom_fields' => $custom_fields, 'quick_middle_column' => $quick_middle_column, 'quick_right_column' => $quick_right_column, 'Cancel' => __('Cancel', 'media-library-assistant'), 'Reset' => __('Reset', 'media-library-assistant'), 'Update' => __('Update', 'media-library-assistant'), 'Bulk Edit' => __('Bulk Edit', 'media-library-assistant'), 'bulk_middle_column' => $bulk_middle_column, 'bulk_right_column' => $bulk_right_column, 'bulk_authors' => $bulk_authors_dropdown, 'Comments' => __('Comments', 'media-library-assistant'), 'Pings' => __('Pings', 'media-library-assistant'), 'No Change' => __('No Change', 'media-library-assistant'), 'Allow' => __('Allow', 'media-library-assistant'), 'Do not allow' => __('Do not allow', 'media-library-assistant'), 'bulk_custom_fields' => $bulk_custom_fields, 'Map IPTC/EXIF metadata' => __('Map IPTC/EXIF metadata', 'media-library-assistant'), 'Map Custom Field metadata' => __('Map Custom Field metadata', 'media-library-assistant'), 'Bulk Waiting' => __('Waiting', 'media-library-assistant'), 'Bulk Running' => __('In-process', 'media-library-assistant'), 'Bulk Complete' => __('Complete', 'media-library-assistant'), 'Refresh' => __('Refresh', 'media-library-assistant'), 'set_parent_form' => $set_parent_form);
$page_values = apply_filters('mla_list_table_inline_values', $page_values);
$page_template = apply_filters('mla_list_table_inline_template', $page_template_array['page']);
$parse_value = MLAData::mla_parse_template($page_template, $page_values);
return apply_filters('mla_list_table_inline_parse', $parse_value, $page_template, $page_values);
}
/**
* Log debug information
*
* @since 2.12
*
* @param string $message Error message.
*/
private static function _mla_debug_add($message)
{
if (self::$mla_debug) {
if (class_exists('MLA')) {
MLA::mla_debug_add($message);
} else {
error_log($message, 0);
}
}
}
/**
* Filters all clauses for shortcode queries, post caching plugins
*
* This is for debug purposes only.
* Defined as public because it's a filter.
*
* @since 1.80
*
* @param array query clauses before modification
*
* @return array query clauses after modification (none)
*/
public static function mla_query_posts_clauses_request_filter($pieces)
{
/* translators: 1: DEBUG tag 2: SQL clauses */
MLA::mla_debug_add(sprintf(_x('%1$s: mla_query_posts_clauses_request_filter = "%2$s".', 'error_log', 'media-library-assistant'), __('DEBUG', 'media-library-assistant'), var_export($pieces, true)));
return $pieces;
}
