__( 'Log', 'ucare' ), 'plural' => __( 'Logs', 'ucare' ), 'ajax' => false ) ); $this->classes = array( 'i' => __( 'Info', 'ucare' ), 'd' => __( 'Debug', 'ucare' ), 'e' => __( 'Error', 'ucare' ), 'w' => __( 'Warning', 'ucare' ), ); apply_filters( 'support_default_log_classes', $this->classes ); } public function get_columns() { return array( 'uc_log_class' => __( 'Level', 'ucare' ), 'uc_log_tag' => __( 'Event', 'ucare' ), 'uc_log_message' => __( 'Message', 'ucare' ), 'uc_log_timestamp' => __( 'Timestamp', 'ucare' ) ); } public function get_sortable_columns() { return array( 'uc_log_class' => array( 'uc_log_class', true ), 'uc_log_tag' => array( 'uc_log_tag', true ), 'uc_log_timestamp' => array( 'uc_log_timestamp', true ) ); } public function no_items() { _e( 'No logs available.', 'ucare' ); } public function extra_tablenav( $which ) { if( $which == 'top' ) { ?>
classes ) ) { return $this->classes[ $item['uc_log_class'] ]; } else { return $item['uc_log_class']; } } public function column_uc_log_message( $item ) { return wp_trim_words( $item['uc_log_message'], 15 ); } public function column_uc_log_timestamp( $item ) { return get_date_from_gmt( $item['uc_log_timestamp'], get_option( 'date_format') . ' @ ' . get_option( 'time_format' ) ); } public function column_default( $item, $column_name ) { if( !empty( $item[ $column_name ] ) ) { return $item[ $column_name ]; } else { return '—'; } } public function prepare_items() { $this->_column_headers = array( $this->get_columns(), array(), $this->get_sortable_columns() ); $per_page = 15; $current_page = $this->get_pagenum(); $total_items = $this->record_count(); $this->set_pagination_args( array( 'total_items' => $total_items, 'per_page' => $per_page ) ); $this->items = $this->get_logs( $per_page, $current_page ); } private function record_count() { global $wpdb; return $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->prefix}ucare_logs" ); } private function get_logs( $per_page = 5, $page_number = 1 ) { global $wpdb; $offset = $offset = ( $page_number - 1 ) * $per_page; $vars = array(); $q = "SELECT class AS uc_log_class, tag AS uc_log_tag, event_timestamp AS uc_log_timestamp, message AS uc_log_message FROM {$wpdb->prefix}ucare_logs"; if( $this->verify_nonce() && isset( $_REQUEST['filter_action'] ) ) { $and = false; if( !empty( $_GET['level'] ) ) { $q .= ' WHERE class = %s '; $vars[] = $_GET['level']; $and = true; } if( !empty( $_GET['tag'] ) ) { $q .= ( $and ? ' AND ' : ' WHERE ' ). ' tag = %s '; $vars[] = $_GET['tag']; } } $q .= ' ORDER BY ' . ( !empty( $_REQUEST['orderby'] ) ? esc_sql( $_REQUEST['orderby'] ) : 'uc_log_timestamp' ) . ' '; $q .= isset( $_REQUEST['order'] ) ? esc_sql( $_REQUEST['order'] ) : ' DESC '; $q .= ' LIMIT %d OFFSET %d'; $vars[] = $per_page; $vars[] = $offset; $q = $wpdb->prepare( $q, $vars ); return $wpdb->get_results( $q, ARRAY_A ); } private function get_log_tags() { global $wpdb; return $wpdb->get_col( "SELECT DISTINCT tag FROM {$wpdb->prefix}ucare_logs", 0 ); } }