contact form 7 plugin.' );
}
$fid = empty($_GET['fid']) ? 0 : (int) $_GET['fid'];
$ufid = empty($_GET['ufid']) ? 0 : (int) $_GET['ufid'];
if ( !empty($fid) && empty($_GET['ufid']) ) {
new CFDB7_Wp_Sub_Page();
return;
}
if( !empty($ufid) && !empty($fid) ){
new CFDB7_Form_Details();
return;
}
$ListTable = new CFDB7_Main_List_Table();
$ListTable->prepare_items();
?>
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');
$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', 'contact-form-cfdb7' ),
'count'=> __( 'Count', 'contact-form-cfdb7' )
);
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.'db7_forms';
$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 = "%s";
$data_value['name'] = sprintf( $link, $title );
$data_value['count'] = sprintf( $link, $totalItems );
$data[] = $data_value;
endwhile;
return $data;
}
/**
* Define what data to show on each column of the table
*
* @param Array $item Data
* @param String $column_name - Current column name
*
* @return Mixed
*/
public function column_default( $item, $column_name )
{
return $item[ $column_name ];
}
}