FALSE,
'singular' => 'log',
'plural' => 'logs',
) );
$this->log = new Advanced_Form_Integration_Log();
}
/**
* Renders the columns.
*
* @since 1.0.0
*/
function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'id':
$value = $item['id'];
break;
case 'response_code':
$value = $item['response_code'];
break;
case 'integration_id':
$value = $item['integration_id'];
break;
case 'request_data':
$value = $item['request_data'];
break;
case 'response_data':
$value = $item['response_data'];
break;
case 'action':
$value = $item['action'];
break;
default:
$value = '';
}
return apply_filters( 'adfoin_log_table_column_value', $value, $item, $column_name );
}
/**
* Retrieve the table columns.
*
* @since 1.0.0
* @return array $columns Array of all the list table columns.
*/
function get_columns() {
$columns = array(
'cb' => '',
'response_code' => esc_html__( 'Code', 'advanced-form-integration' ),
'integration_id' => esc_html__( 'Integration', 'advanced-form-integration' ),
'request_data' => esc_html__( 'Request', 'advanced-form-integration' ),
'response_data' => esc_html__( 'Response', 'advanced-form-integration' ),
'actions' => esc_html__( 'Actions', 'advanced-form-integration' )
);
return apply_filters( 'adfoin_log_table_columns', $columns );
}
/**
* Render the checkbox column.
*
* @since 1.0.0
*
* @return string
*/
public function column_cb( $item ) {
return '';
}
public function column_integration_id( $item ) {
$int_id = $item['integration_id'];
$integration = new Advanced_Form_Integration_Integration();
$title = $integration->get_title( $int_id );
return sprintf( '%s', $title, $int_id );
}
/**
* Render the response code column
*/
public function column_response_code( $item ) {
$code = ! empty( $item['response_code'] ) ? $item['response_code'] : _e( 'Unknown', 'advanced-form-integration' );
$starting = substr((string) $code, 0, 1);
$class = 'code-200';
if( 4 == $starting ) {
$class = 'code-400';
}
if( 5 == $starting ) {
$class = 'code-500';
}
if ( ! is_numeric( $code ) ) {
$class = 'code-500';
}
if( isset( $item['response_message'] ) && ! empty( $item['response_message'] ) ) {
$code .= ' ' . $item['response_message'];
}
$date = date_i18n( 'Y/m/d h:i a', strtotime( $item['time'] ) );
$formatted_code = sprintf( '%s%s
', $class, esc_html__( $code ), esc_html( $item['time'] ), esc_html( $date ) );
// Build the row action links and return the value.
return $formatted_code;
}
/**
* Prepare sanitized preview for log values.
*
* @param mixed $raw_value Stored value.
* @return array{title:string, display:string}
*/
protected function prepare_log_preview( $raw_value ) {
if ( is_string( $raw_value ) ) {
$prepared = wp_unslash( $raw_value );
} else {
$prepared = wp_json_encode( $raw_value, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES );
}
if ( ! is_string( $prepared ) ) {
$prepared = '';
}
$stripped = trim( wp_strip_all_tags( $prepared ) );
if ( '' === $stripped ) {
return array(
'title' => '',
'display' => esc_html__( '(empty)', 'advanced-form-integration' ),
);
}
if ( function_exists( 'mb_substr' ) ) {
$snippet = mb_substr( $stripped, 0, 60 );
if ( mb_strlen( $stripped ) > 60 ) {
$snippet .= '…';
}
} else {
$snippet = substr( $stripped, 0, 60 );
if ( strlen( $stripped ) > 60 ) {
$snippet .= '…';
}
}
return array(
'title' => esc_attr( $stripped ),
'display' => esc_html( $snippet ),
);
}
/**
* Render the request data column
*/
public function column_request_data( $item ) {
$preview = $this->prepare_log_preview( $item['request_data'] );
printf( '%s', $preview['title'], $preview['display'] );
}
/**
* Render the response data column
*/
public function column_response_data( $item ) {
$preview = $this->prepare_log_preview( $item['response_data'] );
printf( '%s', $preview['title'], $preview['display'] );
}
/**
* Render the view column.
*/
public function column_actions( $item ) {
$full_log = json_encode(
array(
'integration_id' => $item['integration_id'],
'response_code' => $item['response_code'],
'response_message' => $item['response_message'],
'request_data' => json_decode( $item['request_data'], true ),
'response_data' => json_decode( $item['response_data'], true ),
'time' => $item['time']
));
$admin_url = admin_url( 'admin.php?page=advanced-form-integration-log' );
printf( '', $admin_url, $item['id'], esc_attr( $full_log ), $full_log );
}
/**
* Define bulk actions available for our table listing.
*
* @since 1.0.0
*
* @return array
*/
public function get_bulk_actions() {
$actions = array(
'delete' => esc_html__( 'Delete', 'advanced-form-integration' ),
);
return $actions;
}
/**
* Process the bulk actions.
*
* @since 1.0.0
*/
public function process_bulk_actions() {
$ids = isset( $_REQUEST['log_id'] ) ? $_REQUEST['log_id'] : array();
if ( ! is_array( $ids ) ) {
$ids = array( $ids );
}
$ids = array_map( 'absint', $ids );
$action = ! empty( $_REQUEST['action'] ) ? $_REQUEST['action'] : false;
if ( empty( $ids ) || empty( $action ) ) {
return;
}
// Delete one or multiple relations - both delete links and bulk actions.
if ( 'delete' === $this->current_action() ) {
if (
wp_verify_nonce( $_REQUEST['_wpnonce'], 'bulk-logs' ) ||
wp_verify_nonce( $_REQUEST['_wpnonce'], 'adfoin_delete_log_nonce' )
) {
foreach ( $ids as $id ) {
$this->log->delete( $id );
}
advanced_form_integration_redirect( admin_url( 'admin.php?page=advanced-form-integration-log' ) );
exit;
}
}
}
public function extra_tablenav( $which ) {
if ( $which == "top" ) {
// Output HTML for the filter above the table
$integration_id = isset( $_REQUEST['integration_id'] ) ? esc_attr( $_REQUEST['integration_id'] ) : '';
$response_code = isset( $_REQUEST['response_code'] ) ? esc_attr( $_REQUEST['response_code'] ) : '';
?>
" . esc_html__('All', 'advanced-form-integration') . "";
$response_codes = $this->get_response_codes();
foreach ($response_codes as $code) {
$class = ($current == $code ? ' class="current"' :'');
$url = esc_url(add_query_arg('response_code', $code));
$views[$code] = "" . esc_html($code) . "";
}
return $views;
}
public function get_response_codes() {
global $wpdb;
$relation_table = $wpdb->prefix.'adfoin_log';
$response_codes = $wpdb->get_col( "SELECT DISTINCT response_code FROM " . $relation_table );
return $response_codes;
}
public function get_bulk_response_codes() {
global $wpdb;
$relation_table = $wpdb->prefix.'adfoin_log';
$response_codes = $wpdb->get_col( "SELECT DISTINCT response_code FROM " . $relation_table );
$response_codes = array_merge(array('all'), $response_codes);
return $response_codes;
}
/**
* Sortable settings.
*/
function get_sortable_columns() {
return array(
'integration_id' => array( 'integration_id', TRUE )
);
}
public function fetch_table_data( $args = array() ) {
global $wpdb;
$defaults = array(
'number' => 20,
'offset' => 0,
'orderby' => 'id',
'order' => 'DESC',
'count' => false,
'integration_id' => '',
'response_code' => '',
);
$args = wp_parse_args( $args, $defaults );
$log = new Advanced_Form_Integration_Log();
// Build the base SQL query
$sql = "SELECT * FROM {$log->table}";
$where = array();
// Check if the row is to be searched
if ( isset( $args['s'] ) && ! empty( $args['s'] ) ) {
$arg_s = $args['s'];
$where[] = $wpdb->prepare( "(`response_message` LIKE %s OR `request_data` LIKE %s OR `response_data` LIKE %s)", '%' . $arg_s . '%', '%' . $arg_s . '%', '%' . $arg_s . '%' );
}
// Check if integration_id is set and not empty
if ( isset( $args['integration_id'] ) && ! empty( $args['integration_id'] ) ) {
$integration_id = sanitize_text_field( wp_unslash( $args['integration_id'] ) );
$where[] = $wpdb->prepare( "`integration_id` = %s", $integration_id );
}
// Check if response_code is set and not empty
if ( isset( $args['response_code'] ) && ! empty( $args['response_code'] ) ) {
$response_code = sanitize_text_field( wp_unslash( $args['response_code'] ) );
$where[] = $wpdb->prepare( "`response_code` = %s", $response_code );
}
// Combine WHERE conditions
if ( ! empty( $where ) ) {
$sql .= " WHERE " . implode( ' AND ', $where );
}
if ( ! empty( $args['orderby'] ) ) {
$sql .= ' ORDER BY ' . esc_sql( $args['orderby'] );
$sql .= ! empty( $args['order'] ) ? ' ' . esc_sql( $args['order'] ) : ' ASC';
}
// If it's a count query, execute it and return the count
if ( $args['count'] ) {
$count_sql = "SELECT COUNT(*) FROM {$log->table}";
// Add WHERE conditions from the main query
if ( ! empty( $where ) ) {
$count_sql .= " WHERE " . implode( ' AND ', $where );
}
$result = $log->get_var( $count_sql );
} else {
// Otherwise, continue with the main query
$sql .= " LIMIT {$args['number']}";
$sql .= ' OFFSET ' . $args['offset'];
$result = $log->get_results( $sql, 'ARRAY_A' );
}
return $result;
}
/*
* Handles connection count
*/
public function count() {
global $wpdb;
$args = array(
'count' => true,
);
// Filter for search
if ( isset( $_REQUEST['s'] ) && !empty( $_REQUEST['s'] ) ) {
$args['s'] = sanitize_text_field( wp_unslash( $_REQUEST['s'] ) );
}
// Filter for integration_id
if ( isset( $_REQUEST['integration_id'] ) && !empty( $_REQUEST['integration_id'] ) ) {
$args['integration_id'] = sanitize_text_field( wp_unslash( $_REQUEST['integration_id'] ) );
}
// Check if the response_code parameter is set in the URL
if ( isset( $_REQUEST['response_code'] ) && is_numeric( $_REQUEST['response_code'] ) ) {
$args['response_code'] = absint( $_REQUEST['response_code'] );
}
$count = $this->fetch_table_data( $args );
return $count;
}
//Query, filter data, handle sorting, pagination, and any other data-manipulation required prior to rendering
public function prepare_items() {
// Process bulk actions if found.
$this->process_bulk_actions();
$count = $this->count();
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
$this->admin_header();
$current_page = $this->get_pagenum();
// $per_page = 20;
$per_page = $this->get_items_per_page('adfoin_log_per_page', 20);
$offset = ( $current_page -1 ) * $per_page;
$args = array(
'offset' => $offset,
'number' => $per_page,
);
if ( isset( $_REQUEST['orderby'] ) && !empty( $_REQUEST['orderby'] ) ) {
$args['orderby'] = sanitize_text_field( wp_unslash( $_REQUEST['orderby'] ) );
}
if ( isset( $_REQUEST['order'] ) && !empty( $_REQUEST['order'] ) ) {
$args['order'] = sanitize_text_field( wp_unslash( $_REQUEST['order'] ) );
}
// Filter for search
if ( isset( $_REQUEST['s'] ) && !empty( $_REQUEST['s'] ) ) {
$args['s'] = sanitize_text_field( wp_unslash( $_REQUEST['s'] ) );
}
// Filter for integration_id
if ( isset( $_REQUEST['integration_id'] ) && !empty( $_REQUEST['integration_id'] ) ) {
$args['integration_id'] = sanitize_text_field( wp_unslash( $_REQUEST['integration_id'] ) );
}
// Check if the response_code parameter is set in the URL
if ( isset( $_REQUEST['response_code'] ) && is_numeric( $_REQUEST['response_code'] ) ) {
$args['response_code'] = absint( $_REQUEST['response_code'] );
}
$this->items = $this->fetch_table_data( $args );
$this->set_pagination_args(
array(
'total_items' => $count,
'per_page' => $per_page,
'total_pages' => ceil( $count / $per_page ),
)
);
}
/*
* Renders status column
*/
public function column_status($item) {
if ($item['status']) {
$actions = " " ;
}else{
$actions = " " ;
}
// print_r($item);
return $actions ;
}
/*
* Handles column width
*/
public function admin_header() {
$page = ( isset($_GET['page'] ) ) ? esc_attr( $_GET['page'] ) : false;
if( 'advanced-form-integration-log' != $page )
return;
echo '';
}
}