prefix . 'sr_referrals'; if (isset($_POST['swiftreviews_export_all_referrals']) && wp_verify_nonce($_POST['swiftreviews_export_all_referrals'], 'swiftreviews_export_all_referrals')) { $export_ref_results = $wpdb->get_results("SELECT * FROM `$table_referrals`", ARRAY_A); if (!empty($export_ref_results)) { export_referrals_to_csv($export_ref_results); } } /* * Pagination */ $pagenum = isset($_GET['pagenum']) ? sanitize_text_field(absint($_GET['pagenum'])) : 1; $limit = 30; // number of rows in page $offset = ( $pagenum - 1 ) * $limit; $total_records = $wpdb->get_var("SELECT COUNT(`ref_id`) FROM $table_referrals"); $num_of_pages = ceil($total_records / $limit); $get_ref_results = $wpdb->get_results("SELECT * FROM `$table_referrals` LIMIT $offset, $limit"); ?>

Referrals

Setting updated successfully.

ref_date_time); ?>
add_query_arg('pagenum', '%#%'), 'format' => '', 'prev_text' => __('«', 'swift-cloud'), 'next_text' => __('»', 'swift-cloud'), 'total' => $num_of_pages, 'current' => $pagenum )); if ($page_links) { if ($total_filtered_log > $limit) { echo '
' . $page_links . '
'; } } } } function export_referrals_to_csv($ref_data) { ob_end_clean(); $filename = 'Swift_Reviews_Referrals_List' . date('Y-m-d-H-i-s') . '.csv'; header('Content-Disposition: attachment; filename=' . $filename); header('Content-Type: text/csv', true); $headers = array("Name", "Phone", "Email", "Referred By", "Date"); echo implode(',', $headers) . "\n"; foreach ($ref_data as $ID => $log) { $log_arr = array(); $dt = explode(" ", $log['ref_date_time']); $log_arr[] = '"' . str_replace('"', '""', $log['ref_name']) . '"'; $log_arr[] = '"' . str_replace('"', '""', $log['ref_phone']) . '"'; $log_arr[] = '"' . str_replace('"', '""', $log['ref_email']) . '"'; $log_arr[] = '"' . str_replace('"', '""', $log['ref_referred_by_name'] . " (" . $log['ref_referred_by_email'] . ")") . '"'; $log_arr[] = '"' . str_replace('"', '""', $dt[0]) . '"'; echo @implode(",", $log_arr) . "\n"; } exit; }