'questions',
'singular' => 'question',
'ajax' => false,
'screen' => null,
)
);
}
/**
* Message to be displayed when there are no items
*
* @since 2.7.2
* @access public
*/
public function no_items() {
esc_html_e( 'No questions found.', 'rsvp' );
}
/**
* Prepare our data
*
* @param array $data
*
* @since 2.7.2
*/
public function prepare_items( $data = array() ) {
global $wpdb;
if ( isset( $_GET['s'] ) ) {
$sql = 'SELECT id, question, sortOrder, permissionLevel FROM ' . QUESTIONS_TABLE . " WHERE question LIKE '%%%s%%' ORDER BY sortOrder ASC";
$data = $wpdb->get_results( $wpdb->prepare( $sql, sanitize_text_field( wp_unslash( $_GET['s'] ) ) ) );
} else {
$sql = 'SELECT id, question, sortOrder, permissionLevel FROM ' . QUESTIONS_TABLE . ' ORDER BY sortOrder ASC';
$data = $wpdb->get_results( $sql );
}
$columns = $this->get_columns();
$hidden = $this->get_hidden_columns();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array( $columns, $hidden, $sortable );
// Sort the list
if ( isset( $_GET['orderby'] ) ) {
usort( $data, array( &$this, 'usort_reorder' ) );
}
$this->items = $this->prepare_questions( $data );
}
/**
* Question columns
*
* @return array
* @Since 2.7.2
*/
public function get_columns() {
$columns = array(
'cb' => __( 'ID', 'rsvp' ),
'question' => __( 'Question', 'rsvp' ),
'private_import_key' => __( 'Private Import Key', 'rsvp' ),
);
return $columns;
}
public function get_hidden_columns() {
return array();
}
/**
* Sortable columns
*
* @return array[]
* @since 2.7.2
*/
public function get_sortable_columns() {
return array(
'question' => array( 'id', false ),
);
}
/**
* Sor our questions
*
* @param $a
* @param $b
*
* @return int|lt
* @since 2.7.2
*/
public function usort_reorder( $a, $b ) {
// If no order, default to asc
$order = ( ! empty( $_GET['order'] ) ) ? sanitize_text_field( wp_unslash( $_GET['order'] ) ) : 'asc';
$result = strcasecmp( $a['question'], $b['question'] );
// Send final sort direction to usort
return ( $order === 'asc' ) ? $result : - $result;
}
/**
* Question column
*
* @param $item
*
* @since 2.7.2
*/
public function column_question( $item ) {
// Edit link
$edit_link = add_query_arg(
array(
'page' => 'rsvp-admin-questions',
'action' => 'add',
'id' => $item['id'],
),
admin_url( 'admin.php' )
);
// Delete link
$delete_link = add_query_arg(
array(
'action' => 'delete-rsvp-question',
'id' => absint( $item['id'] ),
),
admin_url( 'admin.php' )
);
echo '' . esc_html( $item['question'] ) . '';
// Assemble links
$actions = array();
$actions['edit'] = '' . __( 'Edit', 'rsvp' ) . '';
$actions['delete'] = "" . __( 'Delete', 'rsvp' ) . '';
$actions = apply_filters( 'rsvp_questions_actions', $actions, $item );
echo wp_kses_post( $this->row_actions( $actions ) );
}
/**
* Default column
*
* @param $item
* @param $column_name
*
* @return mixed|void
* @since 2.7.2
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'question':
$text = $item[ $column_name ];
break;
case 'private_import_key':
$text = isset( $item[ $column_name ] ) ? $item[ $column_name ] : '';
break;
default:
$text = $item[ $column_name ];
}
return apply_filters( "rsvp_question_list_column_$column_name", $text, $item );
}
/**
* Display the table
*
* @since 2.7.2
* @access public
*/
public function display() {
$singular = $this->_args['singular'];
$this->prepare_items();
$screen_options = get_user_meta( get_current_user_id(), 'rsvp_screen_options' );
if ( $screen_options && isset( $screen_options[0]['pagesize'] ) ) {
$pagesize = $screen_options[0]['pagesize'];
} else {
$pagesize = 25;
}
?>
id ] = array(
'id' => $view->id,
'question' => $view->question,
);
}
return $return;
}
/**
* Handles the checkbox column output.
*
* @param $item
*
* @since 2.7.2
*/
public function column_cb( $item ) {
?>
__( 'Delete', 'rsvp' ),
);
return $actions;
}
}