File: /www/wwwroot/www.ycfawu.com/wp-content/plugins/database-for-wpforms/inc/class-sub-page.php
<?php
/**
* WPFormsDB Admin subpage
*/
if (!defined( 'ABSPATH')) exit;
/**
* WPFormsDB_Wp_List_Table class will create the page to load the table
*/
class WPFormsDB_Wp_Sub_Page
{
private $form_post_id;
private $search;
/**
* Constructor start subpage
*/
public function __construct()
{
$this->form_post_id = (int) $_GET['fid'];
$this->list_table_page();
}
/**
* Display the list table page
*
* @return Void
*/
public function list_table_page()
{
$ListTable = new WPFormsDB_List_Table();
$ListTable->prepare_items();
?>
<div class="wrap">
<div id="icon-users" class="icon32"></div>
<h2><?php echo get_the_title( $this->form_post_id ); ?></h2>
<form method="post" action="">
<?php $ListTable->search_box('Search', 'search'); ?>
<?php $ListTable->display(); ?>
</form>
</div>
<?php
}
}
// 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 WPFormsDB_List_Table extends WP_List_Table
{
private $form_post_id;
private $column_titles;
public function __construct() {
parent::__construct(
array(
'singular' => 'contact_form',
'plural' => 'contact_forms',
'ajax' => false
)
);
}
/**
* Prepare the items for the table to process
*
* @return Void
*/
public function prepare_items()
{
$this->form_post_id = (int) $_GET['fid'];
$search = empty( $_REQUEST['s'] ) ? false : esc_sql( $_POST['s'] );
echo esc_html( $this->search );
$form_post_id = $this->form_post_id;
global $wpdb;
$this->process_bulk_action();
$cfdb = apply_filters( 'WPFormsDB_database', $wpdb );
$table_name = $cfdb->prefix.'wpforms_db';
$columns = $this->get_columns();
$hidden = $this->get_hidden_columns();
$sortable = $this->get_sortable_columns();
$data = $this->table_data();
//usort( $data, array( &$this, 'sort_data' ) );
$perPage = 100;
$currentPage = $this->get_pagenum();
if ( ! empty($search) ) {
$totalItems = $cfdb->get_var("SELECT COUNT(*) FROM $table_name WHERE form_value LIKE '%$search%' AND form_post_id = '$form_post_id' ");
}else{
$totalItems = $cfdb->get_var("SELECT COUNT(*) FROM $table_name WHERE form_post_id = '$form_post_id'");
}
$this->set_pagination_args( array(
'total_items' => $totalItems,
'per_page' => $perPage
) );
$this->_column_headers = array($columns, $hidden ,$sortable);
$this->items = $data;
}
/**
* Override the parent columns method. Defines the columns to use in your listing table
*
* @return Array
*/
public function get_columns()
{
$form_post_id = $this->form_post_id;
global $wpdb;
$cfdb = apply_filters( 'WPFormsDB_database', $wpdb );
$table_name = $cfdb->prefix.'wpforms_db';
$results = $cfdb->get_results( "SELECT * FROM $table_name
WHERE form_post_id = $form_post_id ORDER BY form_id DESC LIMIT 1", OBJECT );
$first_row = isset($results[0]) ? unserialize( $results[0]->form_value ): 0 ;
$columns = array();
if( !empty($first_row) ){
//$columns['form_id'] = $results[0]->form_id;
$columns['cb'] = '<input type="checkbox" />';
foreach ($first_row as $key => $value) {
if ( $key == 'WPFormsDB_status' ) continue;
$key_val = str_replace( array('your-', 'WPFormsDB_file'), '', $key);
$columns[$key] = ucfirst( $key_val );
$this->column_titles[] = $key_val;
if ( sizeof($columns) > 4) break;
}
$columns['form-date'] = 'Date';
}
return $columns;
}
/**
* Define check box for bulk action (each row)
* @param $item
* @return checkbox
*/
public function column_cb($item){
return sprintf(
'<input type="checkbox" name="%1$s[]" value="%2$s" />',
$this->_args['singular'],
$item['form_id']
);
}
/**
* Define which columns are hidden
*
* @return Array
*/
public function get_hidden_columns()
{
return array('form_id');
}
/**
* Define the sortable columns
*
* @return Array
*/
public function get_sortable_columns()
{
return array('form-date' => array('form-date', true));
}
/**
* Define bulk action
* @return Array
*/
public function get_bulk_actions() {
return array(
'read' => __( 'Read', 'contact-form-WPFormsDB' ),
'unread' => __( 'Unread', 'contact-form-WPFormsDB' ),
'delete' => __( 'Delete', 'contact-form-WPFormsDB' )
);
}
/**
* Get the table data
*
* @return Array
*/
private function table_data()
{
$data = array();
global $wpdb;
$cfdb = apply_filters( 'WPFormsDB_database', $wpdb );
$search = empty( $_REQUEST['s'] ) ? false : esc_sql( $_POST['s'] );
$table_name = $cfdb->prefix.'wpforms_db';
$page = $this->get_pagenum();
$page = $page - 1;
$start = $page * 100;
$form_post_id = $this->form_post_id;
$orderby = isset($_GET['orderby']) ? 'form_date' : 'form_id';
$order = isset($_GET['order']) && $_GET['order'] == 'asc' ? 'ASC' : 'DESC';
if ( ! empty($search) ) {
$results = $cfdb->get_results( "SELECT * FROM $table_name WHERE form_value LIKE '%$search%'
AND form_post_id = '$form_post_id'
ORDER BY $orderby $order
LIMIT $start,100", OBJECT );
}else{
$results = $cfdb->get_results( "SELECT * FROM $table_name WHERE form_post_id = $form_post_id
ORDER BY $orderby $order
LIMIT $start,100", OBJECT );
}
foreach ( $results as $result ) {
$form_value = unserialize( $result->form_value );
$link = "<b><a href=admin.php?page=wp-forms-db-list.php&fid=%s&ufid=%s>%s</a></b>";
if(isset($form_value['WPFormsDB_status']) && ( $form_value['WPFormsDB_status'] === 'read' ) )
$link = "<a href=admin.php?page=wp-forms-db-list.php&fid=%s&ufid=%s>%s</a>";
$fid = $result->form_post_id;
$form_values['form_id'] = $result->form_id;
foreach ( $this->column_titles as $col_title) {
$form_value[ $col_title ] = isset( $form_value[ $col_title ] ) ?
$form_value[ $col_title ] : '';
}
foreach ($form_value as $k => $value) {
$ktmp = $k;
$can_foreach = is_array($value) || is_object($value);
if ( $can_foreach ) {
foreach ($value as $k_val => $val):
$val = esc_html( $val );
$form_values[$ktmp] = ( strlen($val) > 150 ) ? substr($val, 0, 150).'...': $val;
$form_values[$ktmp] = sprintf($link, $fid, $result->form_id, $form_values[$ktmp]);
endforeach;
}else{
$value = esc_html( $value );
$form_values[$ktmp] = ( strlen($value) > 150 ) ? substr($value, 0, 150).'...': $value;
$form_values[$ktmp] = sprintf($link, $fid, $result->form_id, $form_values[$ktmp]);
}
}
$form_values['form-date'] = sprintf($link, $fid, $result->form_id, $result->form_date );
$data[] = $form_values;
}
return $data;
}
/**
* Define bulk action
*
*/
public function process_bulk_action(){
global $wpdb;
$cfdb = apply_filters( 'WPFormsDB_database', $wpdb );
$table_name = $cfdb->prefix.'wpforms_db';
$action = $this->current_action();
if ( isset( $_POST['_wpnonce'] ) && ! empty( $_POST['_wpnonce'] ) ) {
$nonce = filter_input( INPUT_POST, '_wpnonce', FILTER_SANITIZE_STRING );
$nonce_action = 'bulk-' . $this->_args['plural'];
if ( !wp_verify_nonce( $nonce, $nonce_action ) ){
wp_die( 'Not valid..!!' );
}
}
$form_ids = isset( $_POST['contact_form'] ) ? $_POST['contact_form'] : array();
if( 'delete' === $action ) {
foreach ($form_ids as $form_id):
$form_id = (int) $form_id;
$results = $cfdb->get_results( "SELECT * FROM $table_name WHERE form_id = $form_id LIMIT 1", OBJECT );
$result_value = $results[0]->form_value;
$result_values = unserialize($result_value);
$upload_dir = wp_upload_dir();
$WPFormsDB_dirname = $upload_dir['basedir'].'/WPFormsDB_uploads';
foreach ($result_values as $key => $result) {
if ( ( strpos($key, 'WPFormsDB_file') !== false ) &&
file_exists($WPFormsDB_dirname.'/'.$result) ) {
unlink($WPFormsDB_dirname.'/'.$result);
}
}
$cfdb->delete(
$table_name ,
array( 'form_id' => $form_id ),
array( '%d' )
);
endforeach;
}else if( 'read' === $action ){
foreach ($form_ids as $form_id):
$form_id = (int) $form_id;
$results = $cfdb->get_results( "SELECT * FROM $table_name WHERE form_id = '$form_id' LIMIT 1", OBJECT );
$result_value = $results[0]->form_value;
$result_values = unserialize( $result_value );
$result_values['WPFormsDB_status'] = 'read';
$form_data = serialize( $result_values );
$cfdb->query(
"UPDATE $table_name SET form_value = '$form_data' WHERE form_id = '$form_id'"
);
endforeach;
}else if( 'unread' === $action ){
foreach ($form_ids as $form_id):
$form_id = (int) $form_id;
$results = $cfdb->get_results( "SELECT * FROM $table_name WHERE form_id = '$form_id' LIMIT 1", OBJECT );
$result_value = $results[0]->form_value;
$result_values = unserialize( $result_value );
$result_values['WPFormsDB_status'] = 'unread';
$form_data = serialize( $result_values );
$cfdb->query(
"UPDATE $table_name SET form_value = '$form_data' WHERE form_id = '$form_id'"
);
endforeach;
}
}
/**
* 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 ];
}
/**
* Allows you to sort the data by the variables set in the $_GET
*
* @return Mixed
*/
private function sort_data( $a, $b )
{
// Set defaults
$orderby = 'form_date';
$order = 'asc';
// If orderby is set, use this as the sort column
if(!empty($_GET['orderby']))
{
$orderby = $_GET['orderby'] === 'form_id' ? 'form_id' : 'form_date';
}
// If order is set use this as the order
if(!empty($_GET['order']))
{
$order = $_GET['order'] === 'asc' ? 'ASC' : 'DESC';
}
$result = strcmp( $a[$orderby], $b[$orderby] );
if($order === 'asc')
{
return $result;
}
return -$result;
}
/**
* Display the bulk actions dropdown.
*
* @since 3.1.0
* @access protected
*
* @param string $which The location of the bulk actions: 'top' or 'bottom'.
* This is designated as optional for backward compatibility.
*/
protected function bulk_actions( $which = '' ) {
if ( is_null( $this->_actions ) ) {
$this->_actions = $this->get_bulk_actions();
/**
* Filters the list table Bulk Actions drop-down.
*
* The dynamic portion of the hook name, `$this->screen->id`, refers
* to the ID of the current screen, usually a string.
*
* This filter can currently only be used to remove bulk actions.
*
* @since 3.5.0
*
* @param array $actions An array of the available bulk actions.
*/
$this->_actions = apply_filters( "bulk_actions-{$this->screen->id}", $this->_actions );
$two = '';
} else {
$two = '2';
}
if ( empty( $this->_actions ) )
return;
echo '<label for="bulk-action-selector-' . esc_attr( $which ) . '" class="screen-reader-text">' . __( 'Select bulk action', 'contact-form-WPFormsDB' ) . '</label>';
echo '<select name="action' . esc_attr( $two ) . '" id="bulk-action-selector-' . esc_attr( $which ) . "\">\n";
echo '<option value="-1">' . __( 'Bulk Actions', 'contact-form-WPFormsDB' ) . "</option>\n";
foreach ( $this->_actions as $name => $title ) {
$class = 'edit' === $name ? ' class="hide-if-no-js"' : '';
echo "\t" . '<option value="' . esc_attr( $name ) . '"' . esc_attr( $class ) . '>' . esc_html( $title ) . "</option>\n";
}
echo "</select>\n";
submit_button( __( 'Apply', 'contact-form-WPFormsDB' ), 'action', '', false, array( 'id' => "doaction$two" ) );
echo "\n";
$nonce = wp_create_nonce( 'dnonce' );
echo "<a href='".$_SERVER['REQUEST_URI']."&wpforms-csv=true&nonce=".$nonce."' style='float:right; margin:0;' class='button'>";
_e( 'Export CSV', 'contact-form-WPFormsDB' );
echo '</a>';
do_action('WPFormsDB_after_export_button');
}
}