Viewing File: /home/fshjisk/easyvie/wp-content/plugins/fusion-builder/inc/class-fusion-form-builder-table.php
<?php
/**
* Avada Form Builder Table.
*
* @package Fusion-Builder
* @subpackage Options
* @since 2.2
*/
// Do not allow directly accessing this file.
if ( ! defined( 'ABSPATH' ) ) {
exit( 'Direct script access denied.' );
}
// WP_List_Table is not loaded automatically so we need to load it in our application.
if ( ! class_exists( 'WP_List_Table' ) ) {
require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php';
}
/**
* Create a new table class that will extend the WP_List_Table.
*/
class Fusion_Form_Builder_Table extends WP_List_Table {
/**
* Data columns.
*
* @since 1.0
* @var array
*/
public $columns = [];
/**
* Class constructor.
*
* @since 1.0
* @access public
*/
public function __construct() {
parent::__construct(
[
'singular' => esc_html__( 'Form', 'fusion-builder' ), // Singular name of the listed records.
'plural' => esc_html__( 'Forms', 'fusion-builder' ), // Plural name of the listed records.
'ajax' => false, // This table doesn't support ajax.
'class' => 'fusion-form-builder-table',
]
);
$this->columns = $this->get_columns();
}
/**
* Set the custom classes for table.
*
* @since 1.0
* @access public
* @return array
*/
public function get_table_classes() {
return [ 'widefat', 'fixed', 'striped', 'fusion-form-builder-table' ];
}
/**
* Prepare the items for the table to process.
*
* @since 1.0
* @access public
* @return void
*/
public function prepare_items() {
$columns = $this->columns;
$per_page = 15;
$current_page = $this->get_pagenum();
$data = $this->table_data( $per_page, $current_page );
$hidden = $this->get_hidden_columns();
$sortable = $this->get_sortable_columns();
$total_items = count( $this->table_data() );
$this->set_pagination_args(
[
'total_items' => $total_items,
'per_page' => $per_page,
]
);
$this->_column_headers = [ $columns, $hidden, $sortable ];
$this->items = $data;
}
/**
* Override the parent columns method. Defines the columns to use in your listing table.
*
* @since 1.0
* @access public
* @return array
*/
public function get_columns() {
$columns = [
'cb' => '<input type="checkbox" />',
'title' => esc_html__( 'Title', 'fusion-builder' ),
'views' => __( 'Views', 'fusion-builder' ),
'submissions' => __( 'Entries', 'fusion-builder' ),
'conversions' => __( 'Conversion Rate', 'fusion-builder' ),
];
return apply_filters( 'manage_fusion_form_posts_columns', $columns );
}
/**
* Define which columns are hidden
*
* @since 1.0
* @access public
* @return array
*/
public function get_hidden_columns() {
return [];
}
/**
* Define the sortable columns
*
* @since 1.0
* @access public
* @return array
*/
public function get_sortable_columns() {
return [
'views' => [ 'views', true ],
'submissions' => [ 'submissions', true ],
'conversions' => [ 'conversions', true ],
];
}
/**
* Get the table data.
*
* @since 1.0
* @access public
* @param number $per_page Posts per page.
* @param number $current_page - Current page number.
* @return array
*/
private function table_data( $per_page = -1, $current_page = 0 ) {
$data = [];
$library_query = [];
$status = [ 'publish', 'draft' ];
// Make sure current-page and per-page are integers.
$per_page = (int) $per_page;
$current_page = (int) $current_page;
// phpcs:disable WordPress.Security.NonceVerification
if ( isset( $_GET['status'] ) ) {
$status = sanitize_text_field( wp_unslash( $_GET['status'] ) );
}
$args = [
'post_type' => [ 'fusion_form' ],
'posts_per_page' => $per_page,
'post_status' => $status,
'offset' => ( $current_page - 1 ) * $per_page,
];
// Add sorting.
if ( isset( $_GET['orderby'] ) ) {
$args['orderby'] = sanitize_text_field( wp_unslash( $_GET['orderby'] ) );
$args['order'] = ( isset( $_GET['order'] ) ) ? sanitize_text_field( wp_unslash( $_GET['order'] ) ) : 'ASC';
}
$library_query = new WP_Query( $args );
$fusion_forms = new Fusion_Form_DB_Forms();
// Check if there are items available.
if ( $library_query->have_posts() ) {
// The loop.
while ( $library_query->have_posts() ) :
$library_query->the_post();
$element_post_id = get_the_ID();
$terms = get_the_terms( $element_post_id, 'fusion_tb_category' );
$display_terms = '';
$form = $fusion_forms->get( [ 'where' => [ 'form_id' => $element_post_id ] ] );
$form_stats = [
'id' => '',
'submissions_count' => '',
'views' => '',
'conversions' => '',
];
if ( ! empty( $form ) && isset( $form[0] ) ) {
$form = $form[0];
$form_stats['submissions_count'] = isset( $form->submissions_count ) ? $form->submissions_count : '';
$form_stats['views'] = $form->views;
$form_stats['conversions'] = isset( $form->submissions_count ) ? round( ( $form->submissions_count * 100 / max( $form->views, 1 ) ), 2 ) . '%' : '-';
$form_stats['id'] = (int) $form->id;
}
$element_post = [
'title' => get_the_title(),
'id' => $element_post_id,
'date' => get_the_date( 'm/d/Y' ),
'time' => get_the_date( 'm/d/Y g:i:s A' ),
'status' => get_post_status(),
'submissions' => $form_stats['submissions_count'],
'views' => $form_stats['views'],
'conversions' => $form_stats['conversions'],
'form_id' => $form_stats['id'],
];
$data[] = $element_post;
endwhile;
}
// Restore original Post Data.
wp_reset_postdata();
return $data;
// phpcs:enable WordPress.Security.NonceVerification
}
/**
* Define what data to show on each column of the table
*
* @since 1.0
* @access public
* @param array $item Data.
* @param string $column_id - Current column id.
* @return string
*/
public function column_default( $item, $column_id ) {
do_action( 'manage_fusion_form_custom_column', $column_id, $item );
if ( isset( $item[ $column_id ] ) ) {
return $item[ $column_id ];
}
return '';
}
/**
* Set row actions for title column.
*
* @since 1.0
* @access public
* @param array $item Data.
* @return string
*/
public function column_title( $item ) {
$wpnonce = wp_create_nonce( 'fusion-form-builder' );
if ( isset( $_GET['status'] ) && 'trash' === $_GET['status'] ) { // phpcs:ignore WordPress.Security.NonceVerification
$actions['restore'] = sprintf( '<a href="?_wpnonce=%s&action=%s&post=%s">' . esc_html__( 'Restore', 'fusion-builder' ) . '</a>', esc_attr( $wpnonce ), 'fusion_restore_element', esc_attr( $item['id'] ) );
$actions['delete'] = sprintf( '<a href="?_wpnonce=%s&action=%s&post=%s">' . esc_html__( 'Delete Permanently', 'fusion-builder' ) . '</a>', esc_attr( $wpnonce ), 'fusion_delete_element', esc_attr( $item['id'] ) );
} else {
$live_editor = apply_filters( 'fusion_load_live_editor', true );
$actions['edit'] = sprintf( '<a href="post.php?post=%s&action=%s">' . esc_html__( 'Edit', 'fusion-builder' ) . '</a>', esc_attr( $item['id'] ), 'edit' );
if ( current_user_can( 'edit_others_posts' ) ) {
$actions['clone_section'] = '<a href="' . $this->get_section_clone_link( $item['id'] ) . '" title="' . esc_attr( __( 'Clone this form', 'fusion-builder' ) ) . '">' . __( 'Clone', 'fusion-builder' ) . '</a>';
}
if ( $live_editor ) {
/* translators: The title. */
$actions['fusion_builder_live'] = '<a href="' . esc_url_raw( add_query_arg( 'fb-edit', '1', get_the_permalink( $item['id'] ) ) ) . '" aria-label="' . sprintf( esc_attr__( 'Edit %s with Avada Live', 'fusion-builder' ), '“' . get_the_title( $item['id'] ) . '”' ) . '">' . esc_html__( 'Avada Live', 'fusion-builder' ) . '</a>';
}
$actions['trash'] = sprintf( '<a href="?_wpnonce=%s&action=%s&post=%s">' . esc_html__( 'Trash', 'fusion-builder' ) . '</a>', esc_attr( $wpnonce ), 'fusion_trash_element', esc_attr( $item['id'] ) );
}
$status = '';
if ( 'draft' === $item['status'] ) {
$status = ' — <span class="post-state">' . ucwords( $item['status'] ) . '</span>';
}
$title = '<strong><a href="post.php?post=' . esc_attr( $item['id'] ) . '&action=edit">' . esc_html( $item['title'] ) . '</a>' . $status . '</strong>';
return $title . ' ' . $this->row_actions( $actions );
}
/**
* Set bulk actions dropdown.
*
* @since 1.0
* @access public
* @return array
*/
public function get_bulk_actions() {
if ( isset( $_GET['status'] ) && 'trash' === $_GET['status'] ) { // phpcs:ignore WordPress.Security.NonceVerification
$actions = [
'fusion_restore_element' => esc_html__( 'Restore', 'fusion-builder' ),
'fusion_delete_element' => esc_html__( 'Delete Permanently', 'fusion-builder' ),
];
} else {
$actions = [
'fusion_trash_element' => esc_html__( 'Move to Trash', 'fusion-builder' ),
];
}
return $actions;
}
/**
* The submissions column.
*
* @since 2.3
* @access public
* @param array $item Data.
* @return string
*/
public function column_submissions( $item ) {
if ( 1 <= $item['submissions'] ) {
$url = admin_url( 'admin.php?page=avada-form-entries&form_id=' . $item['form_id'] );
$html = '<span class="counter">' . $item['submissions'] . '</span>';
$html .= '<a class="view-submissions" href="' . esc_url( $url ) . '">' . esc_html__( 'View Entries', 'fusion-builder' ) . '</a>';
return $html;
}
return '-';
}
/**
* Gets the link to clone a form.
*
* @access public
* @since 3.0
* @param int $id The item-id.
* @return string
*/
public function get_section_clone_link( $id ) {
$args = [
'_fusion_form_clone_nonce' => wp_create_nonce( 'clone_form' ),
'item' => $id,
'action' => 'clone_form',
];
$url = add_query_arg( $args, admin_url( 'admin.php' ) );
return $url;
}
/**
* Set checkbox for bulk selection and actions.
*
* @since 1.0
* @access public
* @param array $item Data.
* @return string
*/
public function column_cb( $item ) {
return "<input type='checkbox' name='post[]' value='{$item['id']}' />";
}
/**
* Display custom text if form builder is empty.
*
* @since 1.0
* @access public
* @return void
*/
public function no_items() {
if ( isset( $_GET['status'] ) && 'trash' === $_GET['status'] ) { // phpcs:ignore WordPress.Security.NonceVerification
esc_attr_e( 'No forms found in Trash.', 'fusion-builder' );
} else {
esc_attr_e( 'No forms have been created yet.', 'fusion-builder' );
}
}
/**
* Display status count with link.
*
* @since 1.0
* @access public
* @return void
*/
public function get_status_links() {
$post_status = [];
$count_posts = wp_count_posts( 'fusion_form' );
$count_posts = (array) $count_posts;
$post_status['all'] = $count_posts['publish'] + $count_posts['draft'];
if ( isset( $count_posts['publish'] ) && $count_posts['publish'] ) {
$post_status['publish'] = $count_posts['publish'];
}
if ( isset( $count_posts['draft'] ) && $count_posts['draft'] ) {
$post_status['draft'] = $count_posts['draft'];
}
if ( isset( $count_posts['trash'] ) && $count_posts['trash'] ) {
$post_status['trash'] = $count_posts['trash'];
}
?>
<ul class="subsubsub">
<?php $i = 0; ?>
<?php foreach ( $post_status as $status => $count ) : ?>
<?php
$i++;
$current_status = ( isset( $_GET['status'] ) ) ? sanitize_text_field( wp_unslash( $_GET['status'] ) ) : 'all'; // phpcs:ignore WordPress.Security.NonceVerification
$status_attr = ( 'all' !== $status ) ? '&status=' . $status : '';
$status_title = ( 'publish' === $status ) ? __( 'Published', 'fusion-builder' ) : $status;
?>
<li class="<?php echo esc_attr( $status ); ?>">
<a href="<?php echo esc_url( admin_url( 'admin.php?page=avada-forms' ) . $status_attr ); ?>"<?php echo ( $status === $current_status ) ? ' class="current" ' : ''; ?>>
<?php
printf(
/* Translators: 1: Status. 2: Count. */
esc_html__( '%1$s (%2$s)', 'fusion-builder' ),
esc_html( ucwords( $status_title ) ),
esc_html( $count )
);
?>
</a>
</li>
<?php
// Add separatorif needed.
if ( $i < count( $post_status ) ) {
echo ' | ';
}
?>
<?php endforeach; ?>
</ul>
<?php
}
}
Back to Directory
File Manager