__( 'Submission', 'frontend-admin' ), // singular name of the listed records 'plural' => __( 'Submissions', 'frontend-admin' ), // plural name of the listed records 'ajax' => false, // does this table support ajax? ) ); } /** * * Text displayed when no submission data is available */ public function no_items() { esc_html_e( 'No submissions avaliable.', 'frontend-admin' ); } function column_cb( $item ) { return sprintf( '', $item['id'] ); } /** * 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 ) { switch ( $column_name ) { case 'created_at': $time_format = get_option( 'date_format' ) . ' ' . get_option( 'time_format' ); return gmdate( $time_format, strtotime( $item[ $column_name ] ) ); case 'title': if ( $item[ $column_name ] ) { $title = $item[ $column_name ]; } else { $title = sprintf( 'Submission #%d', $item['id'] ); } $page = 'fea-settings-submissions'; $title = sprintf( '%s', $page, 'edit', $item['id'], $title ); $actions = array( 'edit' => sprintf( '%s', $page, 'edit', $item['id'], __( 'Review', 'frontend-admin' ) ), 'delete' => sprintf( '%s', $page, 'delete', $item['id'], wp_create_nonce( 'frontend_admin_delete_submission' ), __( 'Delete', 'frontend-admin' ) ), ); return sprintf( '%1$s %2$s', $title, $this->row_actions( $actions ) ); case 'user': $user = get_user_by( 'ID', $item[ $column_name ] ); if ( is_object( $user ) ) { $title = $user->display_name . ' (' . $user->user_login . ')'; } else { $title = __( 'Anonymous', 'frontend-admin' ); } return $title; case 'status': $statuses = explode( ',', $item[ $column_name ] ); $states = ''; foreach ( $statuses as $status ) { $state = fea_instance()->submissions_handler->get_status_label( $status ) . '
'; $state = apply_filters( 'frontend_admin/submissions_list/status_label', $state, $item ); $states .= $state; } return $states; case 'form': $form = fea_instance()->form_display->get_form( $item[ $column_name ] ); if ( isset( $form['ID'] ) ) { $form_post = get_post( $form['ID'] ); if( is_wp_error( $form_post ) ){ return $form_post->get_error_message(); } $form_title = $form_post->post_title; $permalink = 'href="' . get_edit_post_link( $form['ID'] ) . '"'; //get status of the form $form_status = $form_post->post_status; if ( 'trash' === $form_status ) { $permalink = ''; $form_title = '' . $form_title . ' (Trashed)'; } return '' . $form_title . ''; } return __( 'Form not found', 'frontend-admin' ); default: if ( isset( $item[ $column_name ] ) ) { return $item[ $column_name ]; } else { return apply_filters( 'frontend_admin/submissions/admin_column_render', $item, $column_name ); } } } function get_bulk_actions() { $actions = array( 'bulk-delete' => __( 'Delete', 'frontend-admin' ), 'bulk-approve' => __( 'Approve', 'frontend-admin' ), ); return $actions; } /** * Gets the name of the default primary column. * * @since 4.3.0 * * @return string Name of the default primary column, in this case, 'title'. */ protected function get_default_primary_column_name() { return 'title'; } public function get_sortable_columns() { return array( 'created_at' => array( 'created_at', false ), 'title' => array( 'title', false ), 'form' => array( 'form', false ), 'user' => array( 'user', false ), ); } /** * Associative array of columns * * @return array */ function get_columns() { $columns = array( 'cb' => '', 'title' => __( 'Title', 'frontend-admin' ), 'user' => __( 'Submitted By', 'frontend-admin' ), 'form' => __( 'Form', 'frontend-admin' ), 'status' => __( 'Status', 'frontend-admin' ), 'created_at' => __( 'Date', 'frontend-admin' ), ); $columns = apply_filters( 'frontend_admin/submissions/admin_columns', $columns ); return $columns; } /** * 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(); $perpage = $this->get_items_per_page( 'submissions_per_page', 20 ); $current_page = $this->get_pagenum(); $total_items = fea_instance()->submissions_handler->record_count(); if ( $total_items ) { $submits_count = get_option( 'frontend_admin_submissions_all_time', 0 ); if ( ! $submits_count ) { $submits_count = $total_items; update_option( 'frontend_admin_submissions_all_time', $submits_count ); } } $this->set_pagination_args( array( 'total_items' => $total_items, // WE have to calculate the total number of items 'per_page' => $perpage, // WE have to determine how many items to show on a page ) ); $this->items = fea_instance()->submissions_handler->get_submissions( array( 'per_page' => $perpage, 'current_page' => $current_page, ) ); $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array( $columns, $hidden, $sortable ); } public function process_bulk_action() { if ( empty( $_POST['submissions'] ) ) { return; } $submissions = sanitize_post( $_POST['submissions'] ); // If the delete bulk action is triggered if ( ( isset( $_POST['action'] ) && $_POST['action'] == 'bulk-delete' ) || ( isset( $_POST['action2'] ) && $_POST['action2'] == 'bulk-delete' ) ) { // loop over the array of record IDs and delete them foreach ( esc_sql( $submissions ) as $id ) { fea_instance()->submissions_handler->delete_submission( absint( $id ) ); } } if ( ( isset( $_POST['action'] ) && $_POST['action'] == 'bulk-approve' ) || ( isset( $_POST['action2'] ) && $_POST['action2'] == 'bulk-approve' ) ) { // loop over the array of record IDs and delete them foreach ( esc_sql( $submissions ) as $id ) { fea_instance()->submissions_handler->approve_submission( absint( $id ) ); } } } } fea_instance()->submissions_list = new Submissions_List(); endif;