/**
* Renders the MLA Gallery in 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_mla_gallery_in_handler($post)
{
if (is_null(self::$mla_references)) {
self::$mla_references = MLAData::mla_fetch_attachment_references($post->ID, $post->post_parent);
}
$galleries = '';
if (is_array(self::$mla_references)) {
foreach (self::$mla_references['mla_galleries'] as $gallery_id => $gallery) {
if ($gallery_id == $post->post_parent) {
$parent = __('PARENT', 'media-library-assistant') . ' ';
} else {
$parent = '';
}
$galleries .= sprintf('%1$s (%2$s %3$s), %4$s', $parent, $gallery['post_type'], $gallery_id, $gallery['post_title']) . "\n";
}
// foreach $feature
}
$galleries = apply_filters('mla_mla_gallery_in_meta_box', array('galleries' => $galleries, 'rows' => 5, 'cols' => 80), self::$mla_references, $post);
$html = '<label class="screen-reader-text" for="mla_mla_gallery_in">' . __('MLA Gallery in', 'media-library-assistant') . '</label><textarea class="readonly" id="mla_mla_gallery_in" rows="' . absint($galleries['rows']) . '" cols="' . absint($galleries['cols']) . '" readonly="readonly" name="mla_mla_gallery_in" >' . esc_textarea($galleries['galleries']) . "</textarea>\n";
echo apply_filters('mla_mla_gallery_in_meta_box_html', $html, $galleries, self::$mla_references, $post);
}
/**
* Evaluate custom field mapping data source
*
* @since 1.10
*
* @param integer post->ID of attachment
* @param string category/scope to evaluate against: custom_field_mapping or single_attachment_mapping
* @param array data source specification ( name, *data_source, *keep_existing, *format, mla_column, quick_edit, bulk_edit, *meta_name, *option, no_null )
* @param array (optional) _wp_attachment_metadata, default NULL (use current postmeta database value)
*
* @return string|array data source value
*/
private static function _evaluate_data_source($post_id, $category, $data_value, $attachment_metadata = NULL)
{
global $wpdb;
static $upload_dir, $intermediate_sizes = NULL, $wp_attached_files = NULL, $wp_attachment_metadata = NULL;
static $current_id = 0, $file_info = NULL, $parent_info = NULL, $references = NULL, $alt_text = NULL;
if ('none' == $data_value['data_source']) {
return '';
}
$data_source = $data_value['data_source'];
/*
* Do this once per page load; cache attachment metadata if mapping all attachments
*/
if (NULL == $intermediate_sizes) {
$upload_dir = wp_upload_dir();
$upload_dir = $upload_dir['basedir'] . '/';
$intermediate_sizes = get_intermediate_image_sizes();
if ('custom_field_mapping' == $category) {
if (!($table = _get_meta_table('post'))) {
$wp_attached_files = array();
$wp_attachment_metadata = array();
} else {
$wp_attachment_metadata = $wpdb->get_results("SELECT post_id, meta_value FROM {$table} WHERE meta_key = '_wp_attachment_metadata'", OBJECT_K);
$wp_attached_files = $wpdb->get_results("SELECT post_id, meta_value FROM {$table} WHERE meta_key = '_wp_attached_file'", OBJECT_K);
}
}
// custom_field_mapping, i.e., mapping all attachments
}
// first call after page load
/*
* Do this once per post. Simulate SQL results for $wp_attached_files and $wp_attachment_metadata.
*/
if ($current_id != $post_id) {
$current_id = $post_id;
$parent_info = NULL;
$references = NULL;
$alt_text = NULL;
if ('single_attachment_mapping' == $category) {
$metadata = get_metadata('post', $post_id, '_wp_attached_file');
if (isset($metadata[0])) {
$wp_attached_files = array($post_id => (object) array('post_id' => $post_id, 'meta_value' => $metadata[0]));
} else {
$wp_attached_files = array();
}
if (NULL == $attachment_metadata) {
$metadata = get_metadata('post', $post_id, '_wp_attachment_metadata');
if (isset($metadata[0])) {
$attachment_metadata = $metadata[0];
}
}
if (empty($attachment_metadata)) {
$attachment_metadata = array();
}
$wp_attachment_metadata = array($post_id => (object) array('post_id' => $post_id, 'meta_value' => serialize($attachment_metadata)));
}
$file_info = self::_evaluate_file_information($upload_dir, $wp_attached_files, $wp_attachment_metadata, $post_id);
}
$size_info = array('file' => '', 'width' => '', 'height' => '');
$match_count = preg_match('/(.+)\\[(.+)\\]/', $data_source, $matches);
if (1 == $match_count) {
$data_source = $matches[1] . '[size]';
if (isset($file_info['sizes'][$matches[2]])) {
$size_info = $file_info['sizes'][$matches[2]];
}
}
$result = '';
switch ($data_source) {
case 'meta':
$attachment_metadata = isset($wp_attachment_metadata[$post_id]->meta_value) ? maybe_unserialize($wp_attachment_metadata[$post_id]->meta_value) : array();
$result = MLAData::mla_find_array_element($data_value['meta_name'], $attachment_metadata, $data_value['option'], $data_value['keep_existing']);
break;
case 'template':
if (in_array($data_value['option'], array('single', 'export', 'array', 'multi'))) {
$default_option = 'array';
} else {
$default_option = 'text';
}
/*
* Go through the template and expand the non-prefixed elements
* as Data Sources
*/
$item_values = array();
$placeholders = MLAData::mla_get_template_placeholders($data_value['meta_name'], $default_option);
foreach ($placeholders as $key => $placeholder) {
if (empty($placeholder['prefix'])) {
$field_value = $data_value;
$field_value['data_source'] = $placeholder['value'];
$field_value['meta_name'] = '';
$field_value['option'] = $placeholder['option'];
$field_value = self::_evaluate_data_source($post_id, $category, $field_value, $attachment_metadata);
$item_values[$key] = MLAData::mla_apply_field_level_format($field_value, $placeholder);
}
// Data Source
}
// foreach placeholder
/*
* Now expand the template using the above Data Source values
*/
$template = '[+template:' . $data_value['meta_name'] . '+]';
$item_values = MLAData::mla_expand_field_level_parameters($template, NULL, $item_values, $post_id, $data_value['keep_existing'], $default_option);
if ('array' == $default_option) {
$result = MLAData::mla_parse_array_template($template, $item_values);
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
} else {
$result = MLAData::mla_parse_template($template, $item_values);
}
break;
case 'parent':
$data_source = 'post_parent';
/* fallthru */
/* fallthru */
case 'ID':
case 'post_id':
case 'post_author':
case 'post_parent':
case 'menu_order':
case 'comment_count':
$result = absint(self::_evaluate_post_information($post_id, $category, $data_source));
break;
case 'alt_text':
if (NULL == $alt_text) {
$metadata = get_metadata('post', $post_id, '_wp_attachment_image_alt');
if (is_array($metadata)) {
if (count($metadata) == 1) {
$alt_text = maybe_unserialize($metadata[0]);
} else {
$alt_text = array();
foreach ($metadata as $single_key => $single_value) {
$alt_text[$single_key] = maybe_unserialize($single_value);
}
}
}
}
if (!empty($alt_text)) {
$result = self::_evaluate_array_result($alt_text, $data_value['option'], $data_value['keep_existing']);
}
break;
case 'mime_type':
$data_source = 'post_mime_type';
/* fallthru */
/* fallthru */
case 'post_date':
case 'post_date_gmt':
case 'post_content':
case 'post_title':
case 'post_excerpt':
case 'post_status':
case 'comment_status':
case 'ping_status':
case 'post_name':
case 'post_modified':
case 'post_modified_gmt':
case 'post_content_filtered':
case 'guid':
case 'post_mime_type':
$result = self::_evaluate_post_information($post_id, $category, $data_source);
break;
case 'absolute_path':
case 'absolute_file_name':
case 'base_file':
case 'path':
case 'file_name':
case 'name_only':
case 'extension':
case 'width':
case 'height':
case 'orientation':
case 'hwstring_small':
case 'aperture':
case 'credit':
case 'camera':
case 'caption':
case 'created_timestamp':
case 'copyright':
case 'focal_length':
case 'iso':
case 'shutter_speed':
case 'title':
if (isset($file_info[$data_source])) {
$result = $file_info[$data_source];
}
break;
case 'file_size':
$filesize = @filesize($file_info['absolute_file_name_raw']);
if (!(false === $filesize)) {
$result = $filesize;
}
break;
case 'upload_date':
$result = self::_evaluate_post_information($post_id, $category, 'post_date');
break;
case 'dimensions':
$result = $file_info['width'] . 'x' . $file_info['height'];
if ('x' == $result) {
$result = '';
}
break;
case 'pixels':
$result = absint((int) $file_info['width'] * (int) $file_info['height']);
if (0 == $result) {
$result = '';
} else {
$result = (string) $result;
}
break;
case 'size_keys':
$result = array();
foreach ($file_info['sizes'] as $key => $value) {
$result[] = $key;
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
break;
case 'size_names':
$result = array();
foreach ($file_info['sizes'] as $key => $value) {
$result[] = $value['file'];
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
break;
case 'size_bytes':
$result = array();
foreach ($file_info['sizes'] as $key => $value) {
$filesize = @filesize($file_info['absolute_path_raw'] . $value['file']);
if (false === $filesize) {
$result[] = '?';
} else {
switch ($data_value['format']) {
case 'commas':
if (is_numeric($filesize)) {
$filesize = number_format((double) $filesize);
}
break;
default:
// no change
}
// format
$result[] = $filesize;
}
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
break;
case 'size_pixels':
$result = array();
foreach ($file_info['sizes'] as $key => $value) {
$pixels = absint((int) $value['width'] * (int) $value['height']);
switch ($data_value['format']) {
case 'commas':
if (is_numeric($pixels)) {
$pixels = number_format((double) $pixels);
}
break;
default:
// no change
}
// format
$result[] = $pixels;
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
break;
case 'size_dimensions':
$result = array();
foreach ($file_info['sizes'] as $key => $value) {
$result[] = $value['width'] . 'x' . $value['height'];
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
break;
case 'size_name[size]':
$result = $size_info['file'];
break;
case 'size_bytes[size]':
$result = @filesize($file_info['absolute_path_raw'] . $size_info['file']);
if (false === $result) {
$result = '?';
}
break;
case 'size_pixels[size]':
$result = absint((int) $size_info['width'] * (int) $size_info['height']);
break;
case 'size_dimensions[size]':
$result = $size_info['width'] . 'x' . $size_info['height'];
if ('x' == $result) {
$result = '';
}
break;
case 'parent_date':
case 'parent_type':
case 'parent_title':
if (is_null($parent_info)) {
$parent_info = MLAData::mla_fetch_attachment_parent_data(self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (isset($parent_info[$data_source])) {
$result = $parent_info[$data_source];
}
break;
case 'parent_issues':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['parent_errors'])) {
$result = $references['parent_errors'];
/*
* Remove (ORPHAN...
*/
$orphan_certain = '(' . __('ORPHAN', 'media-library-assistant') . ')';
$orphan_possible = '(' . __('ORPHAN', 'media-library-assistant') . '?)';
if (false !== strpos($result, $orphan_certain)) {
$result = trim(substr($result, strlen($orphan_certain)));
} elseif (false !== strpos($result, $orphan_possible)) {
$result = trim(substr($result, strlen($orphan_possible)));
}
}
break;
case 'reference_issues':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['parent_errors'])) {
$result = $references['parent_errors'];
}
break;
case 'featured_in':
case 'featured_in_title':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['features'])) {
$result = array();
foreach ($references['features'] as $ID => $value) {
if ('featured_in' == $data_source) {
$result[] = sprintf('%1$s (%2$s %3$d)', $value->post_title, $value->post_type, $ID);
} else {
$result[] = $value->post_title;
}
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
} else {
$result = '';
}
break;
case 'inserted_in':
case 'inserted_in_title':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['inserts'])) {
$result = array();
foreach ($references['inserts'] as $base_file => $inserts) {
foreach ($inserts as $value) {
if ('inserted_in' == $data_source) {
$result[] = sprintf('%1$s (%2$s %3$d)', $value->post_title, $value->post_type, $value->ID);
} else {
$result[] = $value->post_title;
}
}
}
ksort($result);
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
} else {
$result = '';
}
break;
case 'gallery_in':
case 'gallery_in_title':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['galleries'])) {
$result = array();
foreach ($references['galleries'] as $ID => $value) {
if ('gallery_in' == $data_source) {
$result[] = sprintf('%1$s (%2$s %3$d)', $value['post_title'], $value['post_type'], $ID);
} else {
$result[] = $value['post_title'];
}
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
} else {
$result = '';
}
break;
case 'mla_gallery_in':
case 'mla_gallery_in_title':
if (is_null($references)) {
$references = MLAData::mla_fetch_attachment_references($post_id, self::_evaluate_post_information($post_id, $category, 'post_parent'));
}
if (!empty($references['mla_galleries'])) {
$result = array();
foreach ($references['mla_galleries'] as $ID => $value) {
if ('mla_gallery_in' == $data_source) {
$result[] = sprintf('%1$s (%2$s %3$d)', $value['post_title'], $value['post_type'], $ID);
} else {
$result[] = $value['post_title'];
}
}
$result = self::_evaluate_array_result($result, $data_value['option'], $data_value['keep_existing']);
} else {
$result = '';
}
break;
default:
return '';
}
// switch $data_source
switch ($data_value['format']) {
case 'raw':
return $result;
case 'commas':
if (is_numeric($result)) {
$result = str_pad(number_format((double) $result), 15, ' ', STR_PAD_LEFT);
}
break;
case 'native':
default:
/*
* Make some numeric values sortable as strings, make all value non-empty
*/
if (in_array($data_source, array('file_size', 'pixels', 'width', 'height'))) {
$result = str_pad($result, 15, ' ', STR_PAD_LEFT);
} elseif (empty($result)) {
$result = ' ';
}
}
// format
return $result;
}
/**
* Renders the Gallery in 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_mla_gallery_in_handler($post)
{
if (is_null(self::$mla_references)) {
self::$mla_references = MLAData::mla_fetch_attachment_references($post->ID, $post->post_parent);
}
$galleries = '';
if (is_array(self::$mla_references)) {
foreach (self::$mla_references['mla_galleries'] as $gallery_id => $gallery) {
if ($gallery_id == $post->post_parent) {
$parent = 'PARENT ';
} else {
$parent = '';
}
$galleries .= sprintf('%1$s (%2$s %3$s), %4$s', $parent, $gallery['post_type'], $gallery_id, $gallery['post_title']) . "\r\n";
}
// foreach $feature
}
echo '<label class="screen-reader-text" for="mla_mla_gallery_in">MLA Gallery in</label><textarea class="readonly" id="mla_mla_gallery_in" rows="5" cols="80" readonly="readonly" name="mla_mla_gallery_in" >' . esc_textarea($galleries) . "</textarea>\r\n";
}
/**
* WordPress Shortcode; renders a complete list of all attachments and references to them
*
* @since 0.1
*
* @return void echoes HTML markup for the attachment list
*/
public static function mla_attachment_list_shortcode()
{
global $wpdb;
/* extract(shortcode_atts(array(
'item_type'=>'attachment',
'organize_by'=>'title',
), $atts)); */
/*
* Process the where-used settings option
*/
if ('checked' == MLAOptions::mla_get_option(MLAOptions::MLA_EXCLUDE_REVISIONS)) {
$exclude_revisions = "(post_type <> 'revision') AND ";
} else {
$exclude_revisions = '';
}
$attachments = $wpdb->get_results("\r\n\t\t\t\tSELECT ID, post_title, post_name, post_parent\r\n\t\t\t\tFROM {$wpdb->posts}\r\n\t\t\t\tWHERE {$exclude_revisions}post_type = 'attachment' \r\n\t\t\t\t");
foreach ($attachments as $attachment) {
$references = MLAData::mla_fetch_attachment_references($attachment->ID, $attachment->post_parent);
echo ' <br><h3>' . $attachment->ID . ', ' . esc_attr($attachment->post_title) . ', Parent: ' . $attachment->post_parent . '<br>' . esc_attr($attachment->post_name) . '<br>' . esc_html($references['base_file']) . "</h3>\r\n";
/*
* Look for the "Featured Image(s)"
*/
if (empty($references['features'])) {
echo " not featured in any posts.<br>\r\n";
} else {
echo " Featured in<br>\r\n";
foreach ($references['features'] as $feature_id => $feature) {
echo ' ';
if ($feature_id == $attachment->post_parent) {
echo 'PARENT ';
$found_parent = true;
}
echo $feature_id . ' (' . $feature->post_type . '), ' . esc_attr($feature->post_title) . "<br>\r\n";
}
}
/*
* Look for item(s) inserted in post_content
*/
if (empty($references['inserts'])) {
echo " no inserts in any post_content.<br>\r\n";
} else {
foreach ($references['inserts'] as $file => $inserts) {
echo ' ' . $file . " inserted in<br>\r\n";
foreach ($inserts as $insert) {
echo ' ';
if ($insert->ID == $attachment->post_parent) {
echo 'PARENT ';
$found_parent = true;
}
echo $insert->ID . ' (' . $insert->post_type . '), ' . esc_attr($insert->post_title) . "<br>\r\n";
}
// foreach $insert
}
// foreach $file
}
$errors = '';
if (!$references['found_reference']) {
$errors .= '(ORPHAN) ';
}
if ($references['is_unattached']) {
$errors .= '(UNATTACHED) ';
} else {
if (!$references['found_parent']) {
if (isset($references['parent_title'])) {
$errors .= '(BAD PARENT) ';
} else {
$errors .= '(INVALID PARENT) ';
}
}
}
if (!empty($errors)) {
echo ' ' . $errors . "<br>\r\n";
}
}
// foreach attachment
echo "<br>----- End of Report -----\r\n";
}
