custom-fields-table-display.php

<?php
/*
Plugin Name: Custom fields table display
Plugin URI: http://wordpress.org/extend/plugins/custom-fields-display/
Description: Display custom metadata as a table in post content. Ability to select specific custom fields; in any theme.
Version: 0.1
Author: Adam McGreggor after Shambhu Prasad Patnaik
*/



add_action('admin_menu', 'custom_fields_table_display_menus');

if (!function_exists('custom_fields_table_display_menus')):
function custom_fields_table_display_menus()
{
 add_menu_page('Custom Fields Table Display', 'Custom Fields Table Display', 8, __FILE__, 'custom_fields_table_display_admin_page');
}
endif;

if (!function_exists('custom_fields_table_display_admin_page')):
function custom_fields_table_display_admin_page()
{
 $plugin_page= plugin_basename(__FILE__);
 $action_url=admin_url('admin.php?page='.$plugin_page);
 $myCsseUrl = plugins_url('stylesheet.css', __FILE__);
global $wpdb;
$limit = (int) apply_filters( 'postmeta_form_limit', 30 );
$keys = $wpdb->get_col( "
		SELECT meta_key
		FROM $wpdb->postmeta
		GROUP BY meta_key
		HAVING meta_key NOT LIKE '\_%'
		ORDER BY meta_key
		LIMIT $limit" );
if ($keys)
natcasesort($keys);
 $select_field =array();
 $action = stripslashes_deep($_POST['update']); 

 if($action=='Show Now')
 {
  $default_option =array();
  if(isset($_POST['check_box']))
  {
   $field_check = stripslashes_deep($_POST['check_box']);
   foreach($field_check as $key =>$value)
   $select_field[] = $value;
  }
  foreach($keys as $key)
  {
   $field_id = stripslashes_deep($key);
   $field_label = stripslashes_deep($_POST['field_'.$field_id]);
   if($field_label=='')
   $field_label = stripslashes_deep($field['label']);

   $default_option[$field_id] =$field_label; 
  }
  $data =array('default_option' => $default_option,'select_field' =>$select_field);
  $data=json_encode($data);
  update_option('custom_fields_table_display_option',$data); 
  update_option('custom_fields_table_display_message','Successfully Updated.');
  echo "<meta http-equiv='refresh' content='0;url=".$action_url."&message=update' />"; 
 }
 echo'<link rel="stylesheet" type="text/css" href="'.$myCsseUrl.'">';
 echo'<div class="wrap">
      <div id="icon-generic" class="icon32 "></div>      
      <h2>Custom Fields Table Display</h2><br>
	  <div>';

  if($custom_fields_table_display_message = get_option('custom_fields_table_display_message') && !isset($_POST['update']))
 {
  $custom_fields_table_display_message = get_option('custom_fields_table_display_message');
  echo' <div class="updated_setting"><p>'.$custom_fields_table_display_message.'</p></div>&nbsp;';
  update_option('custom_fields_table_display_message','');
 }

 $data = json_decode(get_option('custom_fields_table_display_option'));
 //print_r($data);die();
 $default_option  = (array)$data->default_option;
 $default_select  = (array)$data->select_field;
?>
 <h3 class="title">About</h3>
 <p>Display custom metadata as a table in post content. Ability to select specific custom fields; in any theme.</p>
<SCRIPT LANGUAGE="JavaScript">
<!--
jQuery(document).ready(function(){
  "use strict";
jQuery( "#field_order_box" ).sortable({placeholder: "field_content-highlight"});
 
});
//-->
</SCRIPT>
<?php
 wp_enqueue_script("jquery-ui-sortable");
echo'<div><form method="post" action="'.$action_url.'"  onsubmit="return ValidateForm(this)"><table border="0" width="98%" cellspacing="1" cellpadding="4"   class="middle_table1">       
       <tbody id="field_order_box" >
      <tr class="dataTableHeadingRow">
       <th colspan="2">Show fields</th>
       <th>Display Label</th>
       <th>Order</th>
      </tr>';
 
 $i =0;
 $data1 =array();
 $total_record =count($keys);
 foreach($default_select as  $key =>$value)
 {
  if(in_array($value,$keys))
  $data1[]=array('key_name'=>$value,'volume'=>$key); 
 }
 foreach($keys as $key)
 {
  $field_id          = $key;
  if(!in_array($field_id,$default_select))
  {
   $data1[]=array('key_name'=>$field_id,'volume'=>$total_record); 
  }  
 }
 foreach ($data1 as $key => $row) {
   $volume[$key]  = $row['volume'];
   $name[$key] = $row['key_name'];
 }
 if($data1)
 array_multisort($volume, SORT_ASC, $name, SORT_ASC, $data1);
 foreach($data1 as $key =>$value)
 {
  $field_id          = $value['key_name'];
  $field_label       = $field_id;
  if(isset($default_option[$field_id]))
  $field_value       = $default_option[$field_id];
  else 
  $field_value       = $field_id;
  if(in_array($field_id,$default_select))
  $fild_checkbox = custom_fields_table_display_checkbox_field('check_box[]',$field_id, true,'', ' id="check_'.$field_id.'" '); 
  else
  $fild_checkbox = custom_fields_table_display_checkbox_field('check_box[]',$field_id, false,'', ' id="check_'.$field_id.'" '); 

  echo '<tr id="'.$field_id.'" class="field_content" >
       <td valign="top" >'.$fild_checkbox.'</td>
       <td valign="top" width="30%"><nobr><label for="check_'.$field_id.'" >'.$field_label.'</label></nobr></td>
       <td valign="top"><input type="text"  name ="field_'.$field_id.'" value="'.esc_attr($field_value).'" size="40"></td>
	   <td><span class="ui-icon ui-icon-arrowthick-2-n-s"></span></td>
    </tr>';

 }
 echo' <tr>
        <td colspan="5"  align="center"><input type="submit" name="update" value="Show Now" class="button button-primary button-large"></td>
       </tr></tbody>
	 </table></form></div>';
 echo'</div></div>';

}
endif;

if (!function_exists('custom_fields_table_display_activate')):
function custom_fields_table_display_activate()
{
 update_option('custom_fields_table_display_option','');
}
endif;

if (!function_exists('custom_fields_table_display_checkbox_field')):
function custom_fields_table_display_checkbox_field($name, $value = '', $checked = false, $compare = '', $parameter = '')
{
 $str = '<input type="checkbox" name="' . $name . '"';
 if ($value != '') 
 {
  $str .= ' value="' . $value . '"';
 }
 if ( ($checked == true) || ($value && ($value == $compare)) ) 
 {
  $str .= ' CHECKED';
 }
 if ($parameter != '') 
 {
  $str .= ' ' . $parameter;
 }   
 $str .= '>';
 return $str;

}
endif;

//add_action( 'init', 'custom_fields_table_display_init' );
//function custom_fields_table_display_init()
{
 add_filter( 'the_content', 'custom_fields_table_display_content_filter', 20 );
}

register_deactivation_hook(__FILE__, 'custom_fields_table_display_deactivate');
register_activation_hook(__FILE__, 'custom_fields_table_display_activate');

if (!function_exists('custom_fields_table_display_deactivate')):
function custom_fields_table_display_deactivate()
{
 update_option('custom_fields_table_display_option','');
}
endif;

if ( ! function_exists( 'custom_fields_table_display_content_filter' ) ) :
function custom_fields_table_display_content_filter( $content )
{
 global $post;
 $data = json_decode(get_option('custom_fields_table_display_option'));
 $default_option  = (array)$data->default_option;
 $default_select  = (array)$data->select_field;
 $add_content='';
 if ( is_single() ):
 if(count($default_select) > 0)
 { 
  $add_content ='<table class=\'post-meta\'>';
  foreach($default_select as $key)
  {
   $string = get_post_meta($post->ID,$key,true);
   $value = make_clickable( $string );
   if($value !='')
   {
    $add_content .='<tr>';
    if(isset($default_option[$key]) &&  $value!='' )
    $add_content .='<td><span class=\'post-meta-key\'>'.($default_option[$key]).'</span></td> ';
    $add_content .='</td><td>';
    $add_content .='<td>'.($value).'</tr>';
   }
  }
  $add_content .='</table>';
 }
 endif;

 return $add_content.$content;
}
endif;
?>