field_table_name = $wpdb->prefix . 'visual_form_builder_fields';
$this->form_table_name = $wpdb->prefix . 'visual_form_builder_forms';
$this->entries_table_name = $wpdb->prefix . 'visual_form_builder_entries';
/* Set parent defaults */
parent::__construct( array(
'singular' => 'entry',
'plural' => 'entries',
'ajax' => false
) );
}
/**
* Display column names. We'll handle the Form column separately.
*
* @since 1.2
* @returns $item string Column name
*/
function column_default($item, $column_name){
switch ( $column_name ) {
case 'subject':
case 'sender_name':
case 'sender_email':
case 'emails_to':
case 'date':
case 'ip_address':
return $item[ $column_name ];
}
}
/**
* Builds the on:hover links for the Form column
*
* @since 1.2
*/
function column_form($item){
/* Build row actions */
$actions = array(
'view' => sprintf( 'View', $_REQUEST['page'], $_REQUEST['view'], 'view', $item['entry_id'] ),
'delete' => sprintf( 'Delete', $_REQUEST['page'], $_REQUEST['view'], 'delete', $item['entry_id'] ),
);
/* Build the form's data for display only */
$data = '' . __( 'Cancel' , 'visual-form-builder') . '
';
/* Hide the data intially */
$hidden_div = '' . $data . '
';
return sprintf( '%1$s %2$s %3$s', $item['form'], $this->row_actions( $actions ), $hidden_div );
}
/**
* Used for checkboxes and bulk editing
*
* @since 1.2
*/
function column_cb($item){
return sprintf( '', $this->_args['singular'], $item['entry_id'] );
}
/**
* Builds the actual columns
*
* @since 1.2
*/
function get_columns(){
$columns = array(
'cb' => '', //Render a checkbox instead of text
'form' => __( 'Form' , 'visual-form-builder'),
'subject' => __( 'Email Subject' , 'visual-form-builder'),
'sender_name' => __( 'Sender Name' , 'visual-form-builder'),
'sender_email' => __( 'Sender Email' , 'visual-form-builder'),
'emails_to' => __( 'Emailed To' , 'visual-form-builder'),
'ip_address' => __( 'IP Address' , 'visual-form-builder'),
'date' => __( 'Date Submitted' , 'visual-form-builder')
);
return $columns;
}
/**
* A custom function to get the entries and sort them
*
* @since 1.2
* @returns array() $cols SQL results
*/
function get_entries( $orderby = 'date', $order = 'ASC' ){
global $wpdb;
switch ( $orderby ) {
case 'date':
$order_col = 'date_submitted';
break;
case 'form':
$order_col = 'form_title';
break;
case 'subject':
case 'ip_address':
case 'sender_name':
case 'sender_email':
$order_col = $orderby;
break;
}
$where = '';
/* If the form filter dropdown is used */
if ( $this->current_filter_action() )
$where = 'WHERE forms.form_id = ' . $this->current_filter_action();
$sql_order = sanitize_sql_orderby( "$order_col $order" );
$query = "SELECT forms.form_title, entries.* FROM $this->form_table_name AS forms INNER JOIN $this->entries_table_name AS entries ON entries.form_id = forms.form_id $where ORDER BY $sql_order";
$cols = $wpdb->get_results( $query );
return $cols;
}
/**
* Setup which columns are sortable. Default is by Date.
*
* @since 1.2
* @returns array() $sortable_columns Sortable columns
*/
function get_sortable_columns() {
$sortable_columns = array(
'form' => array( 'form', false ),
'subject' => array( 'subject', false ),
'sender_name' => array( 'sender_name', false ),
'sender_email' => array( 'sender_email', false ),
'date' => array( 'date', true )
);
return $sortable_columns;
}
/**
* Define our bulk actions
*
* @since 1.2
* @returns array() $actions Bulk actions
*/
function get_bulk_actions() {
$actions = array(
'delete' => __( 'Delete' , 'visual-form-builder'),
'export-all' => __( 'Export All' , 'visual-form-builder'),
'export-selected' => __( 'Export Selected' , 'visual-form-builder')
);
return $actions;
}
/**
* Process our bulk actions
*
* @since 1.2
*/
function process_bulk_action() {
$entry_id = ( is_array( $_REQUEST['entry'] ) ) ? $_REQUEST['entry'] : array( $_REQUEST['entry'] );
if ( 'delete' === $this->current_action() ) {
global $wpdb;
foreach ( $entry_id as $id ) {
$id = absint( $id );
$wpdb->query( "DELETE FROM $this->entries_table_name WHERE entries_id = $id" );
}
}
}
/**
* Handle the entries CSV export
*
* @since 1.4
*/
function export_entries( $selected = NULL ) {
global $wpdb;
/* Setup our query to accept selected entry IDs */
if ( is_array( $selected ) && !empty( $selected ) )
$selected = " WHERE entries.entries_id IN (" . implode( ',', $selected ) . ")";
$entries = $wpdb->get_results( "SELECT entries.*, forms.form_title FROM $this->entries_table_name AS entries JOIN $this->form_table_name AS forms USING(form_id) $selected ORDER BY entries_id DESC" );
/* If there's entries returned, do our CSV stuff */
if ( $entries ) :
/* Setup our default columns */
$cols = array(
'entries_id' => array(
'header' => __( 'Entries ID' , 'visual-form-builder'),
'data' => array()
),
'form_title' => array(
'header' => __( 'Form' , 'visual-form-builder'),
'data' => array()
),
'date_submitted' => array(
'header' => __( 'Date Submitted' , 'visual-form-builder'),
'data' => array()
),
'ip_address' => array(
'header' => __( 'IP Address' , 'visual-form-builder'),
'data' => array()
),
'subject' => array(
'header' => __( 'Email Subject' , 'visual-form-builder'),
'data' => array()
),
'sender_name' => array(
'header' => __( 'Sender Name' , 'visual-form-builder'),
'data' => array()
),
'sender_email' => array(
'header' => __( 'Sender Email' , 'visual-form-builder'),
'data' => array()
),
'emails_to' => array(
'header' => __( 'Emailed To' , 'visual-form-builder'),
'data' => array()
)
);
/* Initialize row index at 0 */
$row = 0;
/* Loop through all entries */
foreach ( $entries as $entry ) {
/* Loop through each entry and its fields */
foreach ( $entry as $key => $value ) {
/* Handle each column in the entries table */
switch ( $key ) {
case 'entries_id':
case 'form_title':
case 'date_submitted':
case 'ip_address':
case 'subject':
case 'sender_name':
case 'sender_email':
$cols[ $key ][ 'data' ][ $row ] = $value;
break;
case 'emails_to':
$cols[ $key ][ 'data' ][ $row ] = implode( ',', maybe_unserialize( $value ) );
break;
case 'data':
/* Unserialize value only if it was serialized */
$fields = maybe_unserialize( $value );
/* Loop through our submitted data */
foreach ( $fields as $field_key => $field_value ) {
if ( !is_array( $field_value ) ) {
/* Replace quotes for the header */
$header = str_replace( '"', '""', ucwords( $field_key ) );
/* Replace all spaces for each form field name */
$field_key = preg_replace( '/(\s)/i', '', $field_key );
/* Find new field names and make a new column with a header */
if ( !array_key_exists( $field_key, $cols ) ) {
$cols[$field_key] = array(
'header' => $header,
'data' => array()
);
}
/* Get rid of single quote entity */
$field_value = str_replace( ''', "'", $field_value );
/* Load data, row by row */
$cols[ $field_key ][ 'data' ][ $row ] = str_replace( '"', '""', stripslashes( html_entity_decode( $field_value ) ) );
}
else {
/* Cast each array as an object */
$obj = (object) $field_value;
switch ( $obj->type ) {
case 'fieldset' :
case 'section' :
case 'instructions' :
case 'submit' :
break;
default :
/* Replace quotes for the header */
$header = str_replace( '"', '""', $obj->name );
/* Find new field names and make a new column with a header */
if ( !array_key_exists( $obj->name, $cols ) ) {
$cols[$obj->name] = array(
'header' => $header,
'data' => array()
);
}
/* Get rid of single quote entity */
$obj->value = str_replace( ''', "'", $obj->value );
/* Load data, row by row */
$cols[ $obj->name ][ 'data' ][ $row ] = str_replace( '"', '""', stripslashes( html_entity_decode( $obj->value ) ) );
break;
}
}
}
break;
}
}
$row++;
}
/* Setup our CSV vars */
$csv_headers = NULL;
$csv_rows = array();
/* Loop through each column */
foreach ( $cols as $data ) {
/* End our header row, if needed */
if ( $csv_headers )
$csv_headers .= ',';
/* Build our headers */
$csv_headers .= "{$data['header']}";
/* Loop through each row of data and add to our CSV */
for ( $i = 0; $i < $row; $i++ ) {
/* End our row of data, if needed */
if ( $csv_rows[$i] )
$csv_rows[$i] .= ',';
/* Add a starting quote for this row's data */
$csv_rows[$i] .= '"';
/* If there's data at this point, add it to the row */
if ( array_key_exists( $i, $data['data'] ) )
$csv_rows[$i] .= $data['data'][$i];
/* Add a closing quote for this row's data */
$csv_rows[$i] .= '"';
}
}
/* Change our header so the browser spits out a CSV file to download */
header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="' . date( 'Y-m-d' ) . '-entries.csv"');
ob_clean();
/* Print headers for the CSV */
echo $csv_headers . "\n";
/* Print each row of data for the CSV */
foreach ( $csv_rows as $row ) {
echo $row . "\n";
}
die();
endif;
}
/**
* Adds our forms filter dropdown
*
* @since 1.2
*/
function extra_tablenav( $which ) {
global $wpdb;
$query = "SELECT DISTINCT forms.form_title, forms.form_id FROM $this->form_table_name AS forms ORDER BY forms.form_title ASC";
$cols = $wpdb->get_results( $query );
/* Only display the dropdown on the top of the table */
if ( 'top' == $which ) {
echo '
';
}
}
/**
* Set our forms filter action
*
* @since 1.2
* @returns int Form ID
*/
function current_filter_action() {
if ( isset( $_REQUEST['form-filter'] ) && -1 != $_REQUEST['form-filter'] )
return $_REQUEST['form-filter'];
return false;
}
/**
* Prepares our data for display
*
* @since 1.2
*/
function prepare_items() {
global $wpdb;
/* Get screen options from the wp_options table */
$options = get_option( 'visual-form-builder-screen-options' );
/* Get the date/time format that is saved in the options table */
$date_format = get_option('date_format');
$time_format = get_option('time_format');
/* How many to show per page */
$per_page = $options['per_page'];
/* Get column headers */
$columns = $this->get_columns();
$hidden = array();
/* Get sortable columns */
$sortable = $this->get_sortable_columns();
/* Build the column headers */
$this->_column_headers = array($columns, $hidden, $sortable);
/* Handle our bulk actions */
$this->process_bulk_action();
/* Set our ORDER BY and ASC/DESC to sort the entries */
$orderby = ( !empty( $_REQUEST['orderby'] ) ) ? $_REQUEST['orderby'] : 'date';
$order = ( !empty( $_REQUEST['order'] ) ) ? $_REQUEST['order'] : 'desc';
/* Get the sorted entries */
$entries = $this->get_entries( $orderby, $order );
$data = array();
/* Loop trough the entries and setup the data to be displayed for each row */
foreach ( $entries as $entry ) {
$data[] =
array(
'entry_id' => $entry->entries_id,
'form' => stripslashes( $entry->form_title ),
'subject' => stripslashes( $entry->subject ),
'sender_name' => stripslashes( $entry->sender_name ),
'sender_email' => stripslashes( $entry->sender_email ),
'emails_to' => implode( ',', unserialize( stripslashes( $entry->emails_to ) ) ),
'date' => date( "$date_format $time_format", strtotime( $entry->date_submitted ) ),
'ip_address' => $entry->ip_address,
'data' => unserialize( $entry->data )
);
}
/* What page are we looking at? */
$current_page = $this->get_pagenum();
/* How many entries do we have? */
$total_items = count( $entries );
/* Calculate pagination */
$data = array_slice( $data, ( ( $current_page - 1 ) * $per_page ), $per_page );
/* Add sorted data to the items property */
$this->items = $data;
/* Register our pagination */
$this->set_pagination_args( array(
'total_items' => $total_items,
'per_page' => $per_page,
'total_pages' => ceil( $total_items / $per_page )
) );
}
}
?>