";
$script_grafico2 = "
";
// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- Chart.js configuration with pre-escaped values
echo $script_grafico2;
echo '';
} else {
echo '
', esc_html__('No forms submitted', 'contact-forms'), '
';
} ?>
's.`afs_submitted`',
'email' => '`email`',
'afs_referrer' => 's.`afs_referrer`',
'afs_uri' => 's.`afs_uri`',
'afs_lead_status' => 's.`afs_lead_status`',
);
// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Read-only sort parameter
$orderby_raw = isset( $_GET['orderby'] ) ? sanitize_key( wp_unslash( $_GET['orderby'] ) ) : '';
$orderby_key = isset( $allowed_orderby[ $orderby_raw ] ) ? $orderby_raw : 'afs_submitted';
// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Read-only sort parameter
$order_raw = isset( $_GET['order'] ) ? sanitize_key( wp_unslash( $_GET['order'] ) ) : 'desc';
$order = in_array( strtoupper( $order_raw ), array( 'ASC', 'DESC' ), true ) ? strtoupper( $order_raw ) : 'DESC';
$order_clause = $allowed_orderby[ $orderby_key ] . ' ' . $order;
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Safe: $order_clause built from allowlist
$data_last_submissions = $wpdb->get_results(
"SELECT s.`afs_id`, s.`afs_submitted`, s.`afs_uri`, s.`afs_referrer`, s.`afs_lead_status`,
COALESCE(v.`afsv_value`, '') AS `email`
FROM `{$wpdb->prefix}accua_forms_submissions` s
LEFT JOIN `{$wpdb->prefix}accua_forms_submissions_values` v
ON v.`afsv_sub_id` = s.`afs_id` AND v.`afsv_field_id` = 'email'
WHERE s.`afs_status` >= 0
ORDER BY {$order_clause} LIMIT 10"
);
if ($data_last_submissions) {
$base_url = admin_url( 'admin.php?page=accua_forms' );
$columns = array(
'afs_submitted' => __( 'Submitted', 'contact-forms' ),
'email' => __( 'Email', 'contact-forms' ),
'afs_referrer' => __( 'Referrer', 'contact-forms' ),
'afs_uri' => __( 'Page', 'contact-forms' ),
'afs_lead_status' => __( 'Lead Status', 'contact-forms' ),
);
?>
$col_label ) {
$is_current = ( $orderby_key === $col_key );
$next_order = ( $is_current && $order === 'ASC' ) ? 'desc' : 'asc';
$class = $is_current ? 'sorted ' . strtolower( $order ) : 'sortable desc';
$sort_url = add_query_arg( array( 'orderby' => $col_key, 'order' => $next_order ), $base_url );
?>
|
|
|
afs_id ) );
$trash_url = wp_nonce_url( admin_url( 'admin.php?page=accua_forms_submissions_list&action=delete&submission[]=' . absint( $row->afs_id ) ), 'bulk-submissions' );
$date = new DateTime( $row->afs_submitted );
$date_formatted = ( get_locale() === 'it_IT' ) ? $date->format( 'j M Y' ) : $date->format( 'M j, Y' );
?>
|
email ); ?> |
afs_referrer ) {
// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- Helper returns fully escaped HTML
echo _accua_forms_dashboard_expandable_link( $row->afs_referrer, $row->afs_referrer );
}
?> |
afs_uri ) {
// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- Helper returns fully escaped HTML
echo _accua_forms_dashboard_expandable_link( $row->afs_uri, home_url( $row->afs_uri ) );
}
?> |
afs_id, $row->afs_lead_status );
?> |
|
|
afs_lead_status === -1 ) {
$unspam_url = wp_nonce_url( admin_url( 'admin.php?page=accua_forms_submissions_list&lead_status=-1&action=unspam&submission[]=' . absint( $row->afs_id ) ), 'bulk-submissions' );
?>
afs_id ) ), 'bulk-submissions' );
?>
|
n ) ? absint( $num_submissions_per_lead_status[-1]->n ) : 0;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- No user input
$trash_n = (int) $wpdb->get_var( "SELECT COUNT(*) FROM `{$wpdb->prefix}accua_forms_submissions` WHERE afs_status < 0" );
$goto_items = array();
$goto_items[] = '
' . esc_html__( 'Active', 'contact-forms' ) . ' (' . number_format_i18n( max( 0, (int) $num_submissions - $spam_n ) ) . ')';
foreach ( accua_forms_get_lead_statuses() as $ls_id => $ls_label ) {
$ls_id = (int) $ls_id;
if ( $ls_id === -1 || empty( $num_submissions_per_lead_status[ $ls_id ]->n ) ) {
continue;
}
$goto_items[] = '
' . esc_html( $ls_label ) . ' (' . number_format_i18n( absint( $num_submissions_per_lead_status[ $ls_id ]->n ) ) . ')';
}
$goto_items[] = '
' . esc_html__( 'Spam', 'contact-forms' ) . ' (' . number_format_i18n( $spam_n ) . ')';
$goto_items[] = '
' . esc_html__( 'Trash', 'contact-forms' ) . ' (' . number_format_i18n( $trash_n ) . ')';
?>