Please activate Contact Form plugin first.

Please update latest version for Contact Form plugin first.

'Delete' ); } $fid = intval($_GET['cf7_id']); $menu_url = menu_page_url('contact-form-listing',false); $url = $menu_url.'&cf7_id='.$fid; } //Get search related value $search = ''; if(isset($_POST['search_cf7_value']) && !empty($_POST['search_cf7_value'])){ $search = addslashes(addslashes(htmlspecialchars(sanitize_text_field($_POST['search_cf7_value'])))); } //Get all form names which entry store in DB global $wpdb; $sql = "SELECT `cf7_id` FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` GROUP BY `cf7_id`"; $data = $wpdb->get_results($sql,ARRAY_N); $arr_form_id = array(); if(!empty($data)){ foreach($data as $arrVal){ $arr_form_id[] = (int)$arrVal[0]; } } ?>

View Form Information

Select Form name
get_results("SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = " . (int)$fid . " ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : "")." GROUP BY `data_id`"); } //Check search field value empty and date filter active or not else if(isset($_POST['search_cf7_value']) && empty($_POST['search_cf7_value']) && isset($_POST['start_date']) && isset($_POST['end_date']) && !empty($_POST['start_date']) && !empty($_POST['end_date']) && $s_date !== false && $e_date !== false){ //Get start date information $start_date = date_format($s_date,"Y-m-d"); //Get end date information $end_date = date_format($e_date,"Y-m-d"); //Setup date parameter value in query $search_date_query = "AND `name` = 'submit_time' AND value between '".$start_date."' and '".$end_date." 23:59:59'"; $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." LIMIT ".$offset.",".$items_per_page." ) temp_table) ORDER BY " . $cf7d_entry_order_by; //Get total entries information $total_query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." ) temp_table) GROUP BY `data_id` ORDER BY " . $cf7d_entry_order_by; $arr_total = $wpdb->get_results($total_query); } //Check search field value not empty and date filter active or not else if(isset($_POST['search_cf7_value']) && !empty($_POST['search_cf7_value']) && isset($_POST['start_date']) && isset($_POST['end_date']) && !empty($_POST['start_date']) && !empty($_POST['end_date']) && $s_date !== false && $e_date !== false){ //Get start date information $start_date = date_format($s_date,"Y-m-d"); //Get end date information $end_date = date_format($e_date,"Y-m-d").' 23:59:59'; //Get date filter related entries information $date_query = "SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." AND `name` = 'submit_time' AND value between '".$start_date."' and '".$end_date."' GROUP BY `data_id` ORDER BY `data_id` DESC"; $rs_date = $wpdb->get_results($date_query); //Get all entries and setup a string $data_ids = ''; if(!empty($rs_date)){ foreach($rs_date as $objdata_id){ $data_ids .= $objdata_id->data_id .','; } $data_ids = rtrim($data_ids,','); } //get all entrise information $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query." ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : ""). " AND data_id IN (".$data_ids.") GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." LIMIT ".$offset.",".$items_per_page." ) temp_table) ORDER BY " . $cf7d_entry_order_by; //Get total entries information $total_query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query." ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : ""). " AND data_id IN (".$data_ids.") GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." ) temp_table) GROUP BY `data_id` ORDER BY " . $cf7d_entry_order_by; $arr_total = $wpdb->get_results($total_query); } //Call when any filter not active on Listing screen else{ if(isset($_GET["orderby"]) && isset($_GET["order"]) && !empty($_GET["orderby"]) && !empty($_GET["order"])){ $qry = "SELECT `data_id` FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND `name` = '".$_GET['orderby']."' AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." LIMIT ".$offset.",".$items_per_page." ) temp_table) ORDER BY `value` ".$_GET["order"]."," . $cf7d_entry_order_by; $idVals = $wpdb->get_results ( $qry ); $id_val = array(); if(!empty($idVals)){ foreach($idVals as $o_id){ $id_val[] = $o_id->data_id; } } $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." LIMIT ".$offset.",".$items_per_page." ) temp_table) ORDER BY FIELD(`data_id`, ". implode(',',$id_val) ." )"; } else{ $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN( SELECT * FROM ( SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." LIMIT ".$offset.",".$items_per_page." ) temp_table) ORDER BY " . $cf7d_entry_order_by; } //Get total entries information $arr_total = $wpdb->get_results("SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = " .$fid . " ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : "")." GROUP BY `data_id`"); } //Execute query here $data = $wpdb->get_results($query); //Get entry wise all fields information $data_sorted = vsz_cf7_sortdata($data); //get total count $total = count($arr_total); //Define bulk action array //Add filter for customize bulk action values $entry_actions = apply_filters('vsz_cf7_entry_actions', $entry_actions); //Form listing design structure start here ?>
Reset All
add_query_arg('cpage', '%#%'), 'format' => '', 'prev_text' => __('«'), 'next_text' => __('»'), 'total' => ceil($total / $items_per_page), 'current' => $page, ))); ?>

'; //Display Edit headion field if($edit == true){ do_action('vsz_cf7_admin_after_heading_field'); } //Define table header section here foreach ($fields as $k => $v){ echo ''; } ?> $v) { $k = (int)$k; echo ''; echo ''; $row_id = $k; //Display edit entry icon if($edit == true){ do_action('vsz_cf7_admin_after_body_field', $fid, $row_id); } foreach ($fields as $k2 => $v2) { //Get fields related values $_value = ((isset($v[$k2])) ? $v[$k2] : ' '); $_value1 = filter_var($_value, FILTER_SANITIZE_URL); //Check value is URL or not if (!filter_var($_value1, FILTER_VALIDATE_URL) === false) { $_value = esc_url($_value); //If value is url then setup anchor tag with value if(!empty($arr_field_type_info) && array_key_exists($k2,$arr_field_type_info) && $arr_field_type_info[$k2] == 'file'){ //Add download attributes in tag if field type is attachement $_value = ''.basename($_value).''; echo ''; } else{ $_value = ''.basename($_value).''; echo ''; } } else{ $_value = esc_html(html_entity_decode($_value)); //var_dump(($_value)); var_dump(strlen($_value)); exit; if(strlen($_value) > $display_character){ echo ''; }else{ echo ''; } } }//Close foreach echo ''; }//Close foreach } else{ ?>'; if($edit == true){ do_action('vsz_cf7_admin_after_heading_field'); } foreach ($fields as $k => $v){ echo ''; } ?>
'.vsz_cf7_admin_get_field_name($v).'
'.$_value.''.$_value.''.substr($_value, 0, $display_character).'...'.$_value.'
No records found.
'.vsz_cf7_admin_get_field_name($v).'
Currently not submission any form data.'; } }