'Delete' ); } $lang = isset($_GET['lang']) ? sanitize_text_field( wp_unslash( $_GET['lang'] ) ) : ''; $translated_id = apply_filters('wpml_object_id', $fid, 'wpcf7_contact_form', false, $lang); $menu_url = menu_page_url('contact-form-listing',false); if ($translated_id != $fid) { $fid = ''; $url = $menu_url; } else { $fid = $translated_id; $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(wp_unslash($_POST['search_cf7_value']))))); } //Get all form names which entry store in DB global $wpdb; //Get table name for data entry $data_entry_table_name = sanitize_text_field(VSZ_CF7_DATA_ENTRY_TABLE_NAME); $data = vsz_cached_get_results("SELECT `cf7_id` FROM {$wpdb->prefix}cf7_vdata_entry GROUP BY `cf7_id`", 'vsz_cf7', 300 ); $arr_form_id = array(); if(!empty($data)){ foreach($data as $row){ $arr_form_id[] = (int)$row->cf7_id; } } ?>

cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `value` LIKE %s GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d ) temp_table) ORDER BY {$cf7d_entry_order_by}", $fid, $fid, '%' . $wpdb->esc_like($search) . '%', $offset, $items_per_page, 'vsz_cf7', 300 ); $arr_total = $this->cached_get_results("SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND `value` LIKE %s GROUP BY `data_id`", $fid, '%' . $wpdb->esc_like($search) . '%', 'vsz_cf7', 300 ); } //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"); $query_end_date = $end_date." 23:59:59"; $query = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `name` = 'submit_time' AND value between %s and %s GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d ) temp_table) ORDER BY {$cf7d_entry_order_by}", $fid, $fid, $start_date, $query_end_date, $offset, $items_per_page, 'vsz_cf7', 300 ); //Get total entries information $arr_total = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `name` = 'submit_time' AND value between %s and %s GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} ) temp_table) GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by}", $fid, $fid, $start_date, $query_end_date, 'vsz_cf7', 300 ); } //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 = $this->cached_get_results("SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `name` = 'submit_time' AND value between %s and %s GROUP BY `data_id` ORDER BY `data_id` DESC", $fid, $start_date, $end_date, 'vsz_cf7', 300 ); $rs_date = $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 = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `value` LIKE %s AND FIND_IN_SET(data_id, %s) GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d ) temp_table) ORDER BY {$cf7d_entry_order_by}", $fid, $fid, '%' . $wpdb->esc_like($search) . '%', $data_ids, $offset, $items_per_page, 'vsz_cf7', 300 ); //Get total entries information $arr_total = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d AND `value` LIKE %s AND FIND_IN_SET(data_id, %s) GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} ) temp_table) GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by}", $fid, $fid, '%' . $wpdb->esc_like($search) . '%', $data_ids, 'vsz_cf7', 300 ); } //Call when any filter not active on Listing screen else{ if(isset($_GET["orderby"]) && isset($_GET["order"]) && !empty($_GET["orderby"]) && !empty($_GET["order"]) && (strtolower(sanitize_text_field(wp_unslash($_GET["order"]))) == 'asc' || strtolower(sanitize_text_field(wp_unslash($_GET["order"]))) == 'desc')){ $order = esc_sql(sanitize_text_field(wp_unslash($_GET['order']))); $orderby = esc_sql(sanitize_text_field(wp_unslash($_GET['orderby']))); $qry = $this->cached_get_results("SELECT `data_id` FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND `name` = %s AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d ) temp_table) ORDER BY `value` {$order}, {$cf7d_entry_order_by}", $fid, $orderby, $fid, $offset, $items_per_page, 'vsz_cf7', 300 ); $idVals = $qry; $id_val = array(); if(!empty($idVals)){ foreach($idVals as $o_id){ $id_val[] = $o_id->data_id; } } $id_val_str = ""; if(!empty($id_val)){ $id_val_str = implode(',',$id_val); } $query = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN( SELECT * FROM ( SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE 1 = 1 AND `cf7_id` = %d GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d ) temp_table) ORDER BY FIELD(`data_id`, %s )", $fid, $fid, $offset, $items_per_page, $id_val_str, 'vsz_cf7', 300 ); } else{ $query = $this->cached_get_results("SELECT * FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND data_id IN (SELECT * FROM (SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d GROUP BY `data_id` ORDER BY {$cf7d_entry_order_by} LIMIT %d,%d) temp_table) ORDER BY {$cf7d_entry_order_by}", $fid, $fid, $offset, $items_per_page, 'vsz_cf7', 300 ); } //Get total entries information if(!empty($search)){ $arr_total = $this->cached_get_results("SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d AND `value` LIKE %s GROUP BY `data_id`", $fid, '%' . $wpdb->esc_like($search) . '%', 'vsz_cf7', 300 ); }else{ $arr_total = $this->cached_get_results("SELECT data_id FROM {$wpdb->prefix}cf7_vdata_entry WHERE `cf7_id` = %d GROUP BY `data_id`", $fid, 'vsz_cf7', 300 ); } } // phpcs:enable //Execute query here $data = $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 = (array) apply_filters('vsz_cf7_entry_actions', $entry_actions); //define nonce for get entry details $getDatanonce = wp_create_nonce( 'vsz-cf7-get-entry-nonce-'.$fid ); //Form listing design structure start here ?>
add_query_arg('cpage', '%#%'), 'format' => '', 'prev_text' => __('«', 'advanced-cf7-db'), 'next_text' => __('»', 'advanced-cf7-db'), '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){ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped 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,$getDatanonce); } foreach ($fields as $k2 => $v2) { //Get fields related values $_value = ((isset($v[$k2])) ? $v[$k2] : ' '); /* Date format as per the wordpress setting 2026-09-08*/ if($k2 === 'submit_time' && $_value !== ' '){ $submit_datetime = date_create_from_format('Y-m-d H:i:s', $_value); if($submit_datetime instanceof DateTimeInterface){ $_value = date_format($submit_datetime, get_option('date_format') . ' ' . get_option('time_format')); } } $_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 ?> $display_character){ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped echo ''; }else{ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped echo ''; } } }//Close foreach echo ''; }//Close foreach } else{ ?>'; if($edit == true){ do_action('vsz_cf7_admin_after_heading_field'); } foreach ($fields as $k => $v){ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped echo ''; } ?>
'.vsz_cf7_admin_get_field_name($v).'
'.esc_html(substr($_value, 0, $display_character)).'...'.esc_html($_value).'
'.vsz_cf7_admin_get_field_name($v).'