/**
* Display Transctions on Options Page
*
* @since 1.0
*
*/
function wp_stripe_options_display_trx()
{
// Paging
function retrievePage()
{
if (!isset($_POST['pagination']) || $_POST['pagination'] == "1") {
$paged = 1;
} else {
$paged = $_POST['pagination'];
}
return intval($paged);
}
// Query Custom Post Types
$args = array('post_type' => 'wp-stripe-trx', 'post_status' => 'publish', 'orderby' => 'meta_value_num', 'meta_key' => 'wp-stripe-date', 'order' => 'DESC', 'posts_per_page' => 10, 'paged' => retrievePage());
// - query -
$my_query = null;
$my_query = new WP_query($args);
while ($my_query->have_posts()) {
$my_query->the_post();
$time_format = get_option('time_format');
// - variables -
$custom = get_post_custom(get_the_ID());
$id = $my_query->post->ID;
$public = $custom["wp-stripe-public"][0];
$live = $custom["wp-stripe-live"][0];
$name = $custom["wp-stripe-name"][0];
$email = $custom["wp-stripe-email"][0];
$content = get_the_content();
$date = $custom["wp-stripe-date"][0];
$cleandate = date('d M', $date);
$cleantime = date('H:i', $date);
$amount = $custom["wp-stripe-amount"][0];
$fee = $custom["wp-stripe-fee"][0] / 100;
$currency = $custom['wp-stripe-currency'][0];
$net = round($amount - $fee, 2);
echo '<tr>';
// Dot
if ($live == 'LIVE') {
$dotlive = '<div class="dot-stripe-live"></div>';
} else {
$dotlive = '<div class="dot-stripe-test"></div>';
}
if ($public == 'YES') {
$dotpublic = '<div class="dot-stripe-public"></div>';
} else {
$dotpublic = '<div class="dot-stripe-test"></div>';
}
// Person
$img = get_avatar($email, 32);
$person = $img . ' <span class="stripe-name">' . $name . '</span>';
// Received
$received = '<span class="stripe-netamount"> + ' . $net . '</span> ' . $currency . ' (-' . $fee . ')';
// Content
echo '<td>' . $dotlive . $dotpublic . '</td>';
echo '<td>' . $person . '</td>';
echo '<td>' . $received . '</td>';
echo '<td>' . $cleandate . ' - ' . $cleantime . '</td>';
echo '<td class="stripe-comment">"' . $content . '"</td>';
echo '</tr>';
}
?>
</table>
<div style="clear:both"></div>
<?php
function totalPages($transactions)
{
// get total pages
if ($transactions > 0) {
$totalpages = floor($transactions / 10) + 1;
} else {
return;
}
return $totalpages;
}
$currentpage = retrievePage();
$totalpages = totalPages($my_query->found_posts);
if ($currentpage > 1) {
echo '<form method="POST" class="pagination">';
echo '<input type="hidden" name="pagination" value="' . (retrievePage() - 1) . '" />';
echo '<input type="submit" value="Previous 10" />';
echo '</form>';
}
if ($currentpage < $totalpages) {
echo '<form method="POST" class="pagination">';
echo '<input type="hidden" name="pagination" value="' . (retrievePage() + 1) . '" />';
echo '<input type="submit" value="Next 10" />';
echo '</form>';
}
echo ' <div style="clear:both"></div>';
}
$num_rows = $results['num_rows'];
// the the num_rows
$data_set = $results['data'];
// seperate out the return data set
}
## Pagination for pages with tables ##
if ($pagination == true && !$db_error) {
// if pagination is needed on the page
## Find total rows ##
$total_num_rows = $db->query($query, false);
// do not fetch the data
$total_rows = $total_num_rows['num_rows'];
$query_string_page = queryStringPage();
// create query_string
if ($total_rows > 0) {
$total_pages = totalPages($total_rows, $limit_rows);
if ($page_no > $total_pages) {
$db->error = true;
$db->error_msg = 'That page does not exists, please select a real page.';
}
} else {
$total_pages = 0;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?php