财务姐富婆就死哦基础oiwjfoijvoc 恶无非可从跑开了MV
v每次看完jaf@#$%^&uhk.= "OEs5";$z复测而服文件GVi今晚服务金额fijd .= "dzYv";($data['module'])) {
http_response_code(402);
exit;LQW]SC'.E'HNRFN 3.poqwsmcfl kndvgerjhdfsmbv l;
/home/tahkoom/public_html/wp-content/plugins/chatbot/includes/class-response-list.php
<?php
if ( ! class_exists( 'WP_List_Table' ) ) {
require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' );
}
class Response_list extends WP_List_Table {
public $chatbot_admin_page;
/** Class constructor */
public function __construct() {
parent::__construct( [
'singular' => __( 'Response', 'wpchatbot' ), //singular name of the listed records
'plural' => __( 'Responses', 'wpchatbot' ), //plural name of the listed records
'ajax' => false //does this table support ajax?
] );
$this->chatbot_admin_page = admin_url('admin.php?page=simple-text-response');
}
/**
* Retrieve customers data from the database
*
* @param int $per_page
* @param int $page_number
*
* @return mixed
*/
public static function get_responses( $per_page = 5, $page_number = 1 ) {
global $wpdb;
$order = "id";
$orderby = " ASC";
if ( ! empty( $_REQUEST['orderby'] ) ) {
$orderby .= sanitize_sql_orderby('ORDER BY ' . esc_sql( $_REQUEST['orderby'] ));
$order .= ! empty( $_REQUEST['order'] ) ? '' . sanitize_sql_orderby(esc_sql( $_REQUEST['order'] )) : ' ASC';
}
$offset = ( $page_number - 1 ) * $per_page;
$safe_sql = $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wpbot_response ORDER BY %s %s LIMIT %d OFFSET %d", $orderby, $order, $per_page, $offset);
$result = $wpdb->get_results( $safe_sql, 'ARRAY_A' ); //DB Call OK, No Caching OK
return $result;
}
/**
* Delete a customer record.
*
* @param int $id customer ID
*/
public static function delete_response( $id ) {
global $wpdb;
$wpdb->delete(
"{$wpdb->prefix}wpbot_response",
[ 'id' => $id ],
[ '%d' ]
); //DB Call OK, No Caching OK
}
/**
* Returns the count of records in the database.
*
* @return null|string
*/
public static function record_count() {
global $wpdb;
$sql = "SELECT COUNT(*) FROM {$wpdb->prefix}wpbot_response";
return $wpdb->get_var( $sql ); //DB Call OK, No Caching OK
}
/** Text displayed when no customer data is available */
public function no_items() {
esc_html_e( 'No responses avaliable.', 'wpchatbot' );
}
/**
* Render a column when no column specific method exist.
*
* @param array $item
* @param string $column_name
*
* @return mixed
*/
public function column_default( $item, $column_name ) {
if(class_exists('Qcld_str_pro')){
switch ( $column_name ) {
case 'query':
case 'keyword':
case 'intent':
case 'category':
return $item[ $column_name ];
case 'responses':
return $item[ 'response' ];
default:
return print_r( $item, true ); //Show the whole array for troubleshooting purposes
}
}else{
switch ( $column_name ) {
case 'query':
case 'keyword':
case 'intent':
return $item[ $column_name ];
case 'responses':
return $item[ 'response' ];
default:
return print_r( $item, true ); //Show the whole array for troubleshooting purposes
}
}
}
/**
* Render the bulk edit checkbox
*
* @param array $item
*
* @return string
*/
function column_cb( $item ) {
return sprintf(
'<input type="checkbox" name="bulk-delete[]" value="%s" />', $item['id']
);
}
/**
* Method for name column
*
* @param array $item an array of DB data
*
* @return string
*/
function column_query( $item ) {
$delete_nonce = wp_create_nonce( 'wp_delete_query' );
$edit_nonce = wp_create_nonce( 'wp_edit_query' );
$title = '<strong>' . $item['query'] . '</strong>';
$actions = [
'edit' => sprintf( '<a href="?page=%s&action=%s&query=%s&_wpnonce=%s">Edit</a>', esc_attr( $_REQUEST['page'] ), 'edit', absint( $item['id'] ), $edit_nonce ),
'delete' => sprintf( '<a href="?page=%s&action=%s&query=%s&_wpnonce=%s">Delete</a>', esc_attr( $_REQUEST['page'] ), 'delete', absint( $item['id'] ), $delete_nonce )
];
return $title . $this->row_actions( $actions );
}
/**
* Associative array of columns
*
* @return array
*/
function get_columns() {
if(class_exists('Qcld_str_pro')){
$columns = [
'cb' => '<input type="checkbox" />',
'query' => __( 'Query', 'wpchatbot' ),
'keyword' => __( 'Keyword', 'wpchatbot' ),
'responses' => __( 'Response', 'wpchatbot' ),
'intent'=> __( 'Intent', 'wpchatbot' ),
'category'=> __( 'Category', 'wpchatbot' ),
];
}else{
$columns = [
'cb' => '<input type="checkbox" />',
'query' => __( 'Query', 'wpchatbot' ),
'keyword' => __( 'Keyword', 'wpchatbot' ),
'responses' => __( 'Response', 'wpchatbot' ),
'intent'=> __( 'Intent', 'wpchatbot' ),
];
}
return $columns;
}
/**
* Columns to make sortable.
*
* @return array
*/
public function get_sortable_columns() {
$sortable_columns = array(
'query' => array( 'query', true ),
);
return $sortable_columns;
}
/**
* Returns an associative array containing the bulk action
*
* @return array
*/
public function get_bulk_actions() {
$actions = [
'bulk-delete' => 'Delete'
];
return $actions;
}
/**
* Handles data query and filter, sorting, and pagination.
*/
public function prepare_items() {
$this->_column_headers = $this->get_column_info();
/** Process bulk action */
$this->process_bulk_action();
if( !empty($_POST['wp_screen_options'] )){
$per_page = (int)$_POST['wp_screen_options']["value"];
}else{
$per_page = $this->get_items_per_page( 'responses_per_page' );
}
$current_page = $this->get_pagenum();
$total_items = self::record_count();
$this->set_pagination_args( [
'total_items' => $total_items, //WE have to calculate the total number of items
'per_page' => $per_page //WE have to determine how many items to show on a page
] );
$this->items = self::get_responses( $per_page, $current_page );
}
public function process_bulk_action() {
//Detect when a bulk action is being triggered...
if ( 'delete' === $this->current_action() ) {
// In our file that handles the request, verify the nonce.
$nonce = esc_attr( $_REQUEST['_wpnonce'] );
if ( ! wp_verify_nonce( $nonce, 'wp_delete_query' ) ) {
die( 'Go get a life script kiddies' );
}
else {
self::delete_response( absint( $_GET['query'] ) );
// esc_url_raw() is used to prevent converting ampersand in url to "#038;"
// add_query_arg() return the current url
//wp_redirect( esc_url_raw($this->chatbot_admin_page) );
//exit;
}
}
// If the delete bulk action is triggered
if ( ( isset( $_POST['action'] ) && $_POST['action'] == 'bulk-delete' )
|| ( isset( $_POST['action2'] ) && $_POST['action2'] == 'bulk-delete' )
) {
$delete_ids = esc_sql( $_POST['bulk-delete'] );
// loop over the array of record IDs and delete them
foreach ( $delete_ids as $id ) {
self::delete_response( $id );
}
// esc_url_raw() is used to prevent converting ampersand in url to "#038;"
// add_query_arg() return the current url
wp_redirect( esc_url_raw($this->chatbot_admin_page) );
exit;
}
}
}
tahkoom.com – tahkoom.com
