0)
$results_per_page = (int)$_GET['show'];
else
$results_per_page = 20;
// Confirm payments //
if (isset($_POST['xconfirm']) && $_POST['xconfirm'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$pid = (int)$v;
ConfirmPayment($pid);
}
header("Location: exchanges.php?".$params."msg=confirmed");
exit();
}
}
// Decline payments //
if (isset($_POST['decline']) && $_POST['decline'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$pid = (int)$v;
DeclinePayment($pid);
}
header("Location: exchanges.php?".$params."msg=declined");
exit();
}
}
// Delete payments //
if (isset($_POST['delete']) && $_POST['delete'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$pid = (int)$v;
//DeletePayment($pid);
smart_mysql_query("DELETE FROM exchangerix_exchanges WHERE exchange_id='$pid'");
}
header("Location: exchanges.php?".$params."msg=deleted");
exit();
}
}
////////////////// filter //////////////////////
if (isset($_GET['column']) && $_GET['column'] != "")
{
switch ($_GET['column'])
{
case "username": $rrorder = "user_id"; break;
case "email": $rrorder = "client_email"; break;
case "rate": $rrorder = "exchange_rate"; break;
case "from_currency": $rrorder = "from_currency"; break;
case "from_amount": $rrorder = "exchange_amount"; break;
case "to_amount": $rrorder = "receive_amount";
case "to_currency": $rrorder = "to_currency"; break;
case "amount": $rrorder = "amount"; break;
case "status": $rrorder = "status"; break;
case "ids": $rrorder = "exchange_id"; break;
default: $rrorder = "exchange_id"; break;
}
}
else
{
$rrorder = "exchange_id";
}
if (isset($_GET['order']) && $_GET['order'] != "")
{
switch ($_GET['order'])
{
case "asc": $rorder = "asc"; break;
case "desc": $rorder = "desc"; break;
default: $rorder = "asc"; break;
}
}
else
{
$rorder = "desc";
}
if (isset($_GET['action']) && $_GET['action'] == "filter")
{
$action = "filter";
$filter_by = "";
$filter = mysqli_real_escape_string($conn, trim(getGetParameter('filter')));
$start_date = mysqli_real_escape_string($conn, getGetParameter('start_date'));
$start_date = substr($start_date, 0, 16);
$end_date = mysqli_real_escape_string($conn, getGetParameter('end_date'));
$end_date = substr($end_date, 0, 16);
switch ($filter)
{
case PAYMENT_TYPE_WITHDRAWAL: $filter = "withdrawal"; break;
case PAYMENT_TYPE_FBONUS: $filter = "friend_bonus"; break;
case PAYMENT_TYPE_SBONUS: $filter = "signup_bonus"; break;
case PAYMENT_TYPE_RCOMMISSION: $filter = "referral_commission"; break;
}
if ($filter != "")
{
$search_by = " (reference_id='$filter' OR payment_type='$filter')";
switch ($_GET['search_type'])
{
case "reference_id": $search_by = "reference_id='".$filter."'"; break;
case "member": $search_by = "user_id='".$filter."'"; break;
case "email": $search_by = "client_email LIKE '%".$filter."%'"; break;
case "send_account": $search_by = "send_account='".$filter."'"; break;
case "receive_account": $search_by = "receive_account='".$filter."'"; break;
//case "amount": $filter = preg_replace("/[^0-9.]/", "", $filter); $search_by = "amount='".$filter."'"; break;
case "send_amount": $filter = preg_replace("/[^0-9.]/", "", $filter); $search_by = "send_amount='".$filter."'"; break;
case "receive_amount": $filter = preg_replace("/[^0-9.]/", "", $filter); $search_by = "receive_amount='".$filter."'"; break;
case "payment_type": $search_by = "payment_type='".$filter."'"; break;
}
$filter_by .= " AND ".$search_by;
}
if ($start_date != "") $filter_by .= " AND created>='$start_date 00:00:00'";
if ($end_date != "") $filter_by .= " AND created<='$end_date 23:59:59'";
$totitle = " - Search Results";
}
///////////////////////////////////////////////////////
if (isset($_GET['period']) && $_GET['period'] != "")
{
$today = date("Y-m-d");
$yesterday = date("Y-m-d", mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
if ($_GET['period'] == "today") { $filter_by .= " AND date(created)='$today' "; $totitle2 = "Today's"; }
if ($_GET['period'] == "yesterday") { $filter_by .= " AND date(created)='$yesterday' "; $totitle2 = "Yesterday's"; }
if ($_GET['period'] == "7days") { $filter_by .= " AND date_sub(curdate(), interval 7 day) <= created "; $totitle2 = "Last 7 Days"; }
if ($_GET['period'] == "30days") { $filter_by .= " AND date_sub(curdate(), interval 30 day) <= created "; $totitle2 = "Last 30 Days"; }
}
if (isset($_GET['from_filter']) && is_numeric($_GET['from_filter']))
{
$from_filter = (int)$_GET['from_filter'];
$filter_by .= " AND from_currency_id='$from_filter' ";
$title2 .= GetCurrencyName($from_filter);
$totitle2 .= " ".$title2;
}
if (isset($_GET['to_filter']) && is_numeric($_GET['to_filter']))
{
$to_filter = (int)$_GET['to_filter'];
$filter_by .= " AND to_currency_id='$to_filter' ";
$title2 = GetCurrencyName($to_filter);
$totitle2 .= " ".$title2;
}
if (isset($_GET['ft_filter']) && is_numeric($_GET['ft_filter']))
{
$ft_filter = (int)$_GET['ft_filter'];
$filter_by .= " AND (from_currency_id='$ft_filter' OR to_currency_id='$ft_filter') ";
$title2 = GetCurrencyName($ft_filter);
$totitle2 .= " ".$title2;
}
if (isset($_GET['status_filter']) && $_GET['status_filter'] != "")
{
$status_filter = mysqli_real_escape_string($conn, trim(getGetParameter('status_filter')));
$status_filter = substr($status_filter, 0, 16);
$filter_by .= " AND status='$status_filter' ";
//$title2 .= GetCurrencyName($status_filter);
}
if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; }
$from = ($page-1)*$results_per_page;
//smart_mysql_query("UPDATE exchangerix_exchanges SET viewed='1' WHERE viewed='0'"); //dev
//smart_mysql_query("UPDATE exchangerix_exchanges SET status='timeout' WHERE created != '0000-00-00 00:00:00' AND created <= NOW()");
smart_mysql_query("UPDATE exchangerix_exchanges SET status='timeout', updated=NOW() WHERE (created < (NOW() - INTERVAL 60 MINUTE) AND status='waiting')");
$query = "SELECT *, DATE_FORMAT(created, '".DATE_FORMAT."
%h:%i %p') AS payment_date FROM exchangerix_exchanges WHERE status!='request' $filter_by ORDER BY $rrorder $rorder LIMIT $from, $results_per_page";
$result = smart_mysql_query($query);
$total_on_page = mysqli_num_rows($result);
$query2 = "SELECT * FROM exchangerix_exchanges WHERE status!='request'".$filter_by;
$result2 = smart_mysql_query($query2);
$total = mysqli_num_rows($result2);
$total_declined = mysqli_num_rows(smart_mysql_query("SELECT * FROM exchangerix_exchanges WHERE 1=1 ".$where." AND (status='cancelled' OR status='timeout' OR status='declined')"));
// delete all calcelled payments //
if (isset($_GET['act']) && $_GET['act'] == "delete_cancelled")
{
smart_mysql_query("DELETE FROM exchangerix_exchanges WHERE status='expired' OR status='timeout' OR status='cancelled'");
header("Location: exchanges.php?msg=exp_deleted");
exit();
}
$cc = 0;
$title = "Exchanges";
require_once ("inc/header.inc.php");
?>
Exchanges 0) { ?>
0) { $total_amount = 0; ?>
Sorry, no exchanges found for your search criteria.
There are currently no exchanges.