__( '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;