set('orderby', 'date');
$query->set('order', 'DESC');
}
}
/**
* Change the default quick post links
*/
public function views($views)
{
if (isset($views['publish'])) {
$views['publish'] = str_replace(__('Published', 'contact-form-submissions'), __('Submitted', 'contact-form-submissions'), $views['publish']);
}
$keep_views = array('all', 'publish', 'trash');
// remove others
foreach (array_keys($views) as $key) {
if (!in_array($key, $keep_views)) {
unset($views[$key]);
}
}
return $views;
}
/**
* Add dropdowns to filter the posts
*/
public function filters()
{
//execute only on the 'post' content type
global $post_type;
if ($post_type == 'wpcf7s') {
$args = array(
'post_type' =>'wpcf7_contact_form',
'posts_per_page' => '-1'
);
$forms = get_posts($args); ?>
''.__('View', 'contact-form-submissions').''), $actions);
}
return $actions;
}
/**
* Query posts by a specific form
*/
public function admin_posts($query)
{
global $post_type;
if ($query->is_admin && 'wpcf7s' === $post_type && $query->is_main_query()) {
if(isset($_GET['wpcf7_contact_form'])){
$form_id = filter_var($_GET['wpcf7_contact_form'], FILTER_SANITIZE_NUMBER_INT);
}
if (!empty($form_id)) {
$query->set('meta_query', array(
array(
'key' => 'form_id',
'value' => $form_id,
'compare' => '='
)
));
}
}
}
/**
* Change the default table columns
*/
public function set_columns($columns)
{
$columns = array(
'cb' => '',
'submission' => __('Submission', 'contact-form-submissions'),
'form' => __('Contact Form', 'contact-form-submissions')
);
// dynamically add cols if the user selects a form
if (isset($_GET['wpcf7_contact_form']) && !empty($_GET['wpcf7_contact_form'])) {
$form_id = filter_var($_GET['wpcf7_contact_form'], FILTER_SANITIZE_NUMBER_INT);
$wpcf7s_columns = $this->get_available_columns($form_id);
foreach ($wpcf7s_columns as $meta_key) {
$columns[$meta_key] = str_replace('wpcf7s_posted-', '', $meta_key);
}
}
$columns['date'] = __('Date', 'contact-form-submissions');
return $columns;
}
/**
* Output values in custom columns
*/
public function column($column, $post_id)
{
$form_id = get_post_meta($post_id, 'form_id', true);
$post_parent = wp_get_post_parent_id($post_id);
$nested = ($post_parent > 0) ? '— ' : '';
switch ($column) {
case 'form':
?>
get_mail_files($post_id);
if(!empty($files)){
add_meta_box('wpcf7s_files', __('Files', 'contact-form-submissions'), array($this, 'files_meta_box'), 'wpcf7s', 'normal');
}
}
/**
* Output for the mail metabox
*/
public function mail_meta_box($post)
{
$form_id = get_post_meta($post->ID, 'form_id', true);
$sender = esc_html(get_post_meta($post->ID, 'sender', true));
$sender_mailto = preg_replace('/([a-zA-Z0-9_\-\.]*@\\S+\\.\\w+)/', '$1', $sender);
$recipient = esc_html(get_post_meta($post->ID, 'recipient', true));
$recipient_mailto = preg_replace('/([a-zA-Z0-9_\-\.]*@\\S+\\.\\w+)/', '$1', $recipient);
$subject = esc_html(get_post_meta($post->ID, 'subject', true));
$body = apply_filters('the_content', esc_html($post->post_content));
$additional_headers = esc_html(get_post_meta($post->ID, 'additional_headers', true)); ?>
get_mail_posted_fields($post->ID); ?>
$value) {
// check if the value is serialized and unserialize it
$posted_field = is_serialized($value[0]) ? implode(', ', unserialize($value[0])) : $value[0];
$posted_field = esc_html($posted_field);
?>
get_var("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = 'form_id' AND meta_value = $form_id LIMIT 1;");
$columns = $wpdb->get_col("SELECT meta_key FROM $wpdb->postmeta WHERE post_id = $post_id AND meta_key LIKE '%wpcf7s_%' GROUP BY meta_key");
return $columns;
}
/**
* Add an export button to the wp-list-table view
*
* @param string $which top or bottom of the table
*
*/
public function extra_tablenav()
{
$screen = get_current_screen();
if ('wpcf7s' === $screen->post_type){
?>
query_vars, array('posts_per_page' => '-1', 'fields' => 'ids'));
$submissions = get_posts($args);
$csv_rows = array();
$columns = array();
foreach($submissions as $post_id) {
$values = $this->get_mail_posted_fields($post_id);
foreach($values as $key => $value) {
// Fix serialize field (select/radio inputs)
if(!empty($value)){
foreach ($value as &$single){
if(is_serialized($single)){
$single=implode(', ', unserialize($single));
}
}
}
if(is_array($value)){
$value = implode(', ', $value);
}
$value = sanitize_text_field($value);
if(function_exists('mb_convert_encoding')){
$value = mb_convert_encoding($value, $charset);
}
$values[$key] = $value;
// if we havent already stored this column, save it now
if(!in_array($key, $columns)){
$columns[] = $key;
}
}
// add file attachments
$files=array();
$files_key =$this->get_mail_files($post_id);
$upload_dir = wp_upload_dir();
$upload_dir = $upload_dir['baseurl'];
if(!empty($files_key)){
foreach($files_key as $keyFile => $valueFile) {
$files=array();
if(!empty($valueFile)){
foreach ($valueFile as $singleFile){
$files[] = "$upload_dir/wpcf7-submissions/$post_id/$singleFile";
}
}
$files = implode(',', $files);
if(function_exists('mb_convert_encoding')){
$value = mb_convert_encoding($files, $charset);
}
$values[$keyFile] = $files;
// if we havent already stored this column, save it now
if(!in_array($keyFile, $columns)){
$columns[] = $keyFile;
}
}
}
$contact_form_id = get_post_meta($post_id, 'form_id', true);
$csv_rows[] = array_merge(array('id'=> $post_id, 'submission_date'=> get_the_date('Y-m-d H:i:s', $post_id), 'form_name' => get_the_title($contact_form_id)), $values);
}
// add default columns
$pretty_columns = $columns = array_merge( array("id", "submission_date", "form_name"), $columns);
foreach($pretty_columns as $key => $column) {
// remove the plugin's prepended keys
$pretty_columns[$key] = str_replace(array('wpcf7s_posted-', 'wpcf7s_file-'), '', $column);
}
fputcsv($output,$pretty_columns);
foreach($csv_rows as $key => $row){
foreach($columns as $column){
$row_values[$column] = $row[$column];
}
fputcsv($output,$row_values);
}
fclose($output);
exit();
}
}
}