Premium Advanced Contact Form 7 Database
Upgrade this plugin with new features offered by our premium version:
- All Free Version Features Included
- Custom Fields
- Add unlimited custom fields to your submission
- Edit each custom field from submission edit page.
- Pie Chart Reports for Custom Fields
- Chart Lines With Submissions by months
- Export Charts as jpg/png or print
- Export Custom Fields as Excel,PDF or CSV.
Get this plugin
prefix.'advanced_cf7_data';
$columns = $this->get_columns();
$hidden = $this->get_hidden_columns();
$data = $this->table_data();
$perPage = 10;
$currentPage = $this->get_pagenum();
$count_forms = wp_count_posts('wpcf7_contact_form');
if(empty((array) $count_forms)){
$totalItems = 0;
}else{
$totalItems = $count_forms->publish;
}
$this->set_pagination_args( array(
'total_items' => $totalItems,
'per_page' => $perPage
) );
$this->_column_headers = array($columns, $hidden );
$this->items = $data;
}
/**
* Override the parent columns method. Defines the columns to use in your listing table
*
* @return Array
*/
public function get_columns(){
$columns = array(
'name' => 'Name',
'count'=> 'Count'
);
return $columns;
}
/**
* Define which columns are hidden
*
* @return Array
*/
public function get_hidden_columns(){
return array();
}
/**
* Get the table data
*
* @return Array
*/
private function table_data(){
global $wpdb;
$cfdb = apply_filters( 'cfdb7_database', $wpdb );
$data = array();
$table_name = $cfdb->prefix.'advanced_cf7_data';
$page = $this->get_pagenum();
$page = $page - 1;
$start = $page * 10;
$args = array(
'post_type'=> 'wpcf7_contact_form',
'order' => 'ASC',
'posts_per_page' => 10,
'offset' => $start
);
$the_query = new WP_Query( $args );
while ( $the_query->have_posts() ) : $the_query->the_post();
$form_post_id = get_the_id();
$totalItems = $cfdb->get_var("SELECT COUNT(*) FROM $table_name WHERE form_post_id = $form_post_id");
$title = get_the_title();
$link = "