'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
?>