| " . $_LANG['affiliatessignupdate'] . " | " . $_LANG['affiliateshostingpackage'] . " | " . $_LANG['affiliatesamount'] . " | " . $_LANG['affiliatescommision'] . " | " . $_LANG['affiliatesstatus'] . " |
\n";
$numitems = get_query_val('tblaffiliatesaccounts', "COUNT(*)", array( 'affiliateid' => $affiliateid ), '', '', '', "tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid");
list($orderby, $sort, $limit) = clientAreaTableInit('affiliates', 'regdate', 'DESC', $numitems);
$smartyvalues['orderby'] = $orderby;
$smartyvalues['sort'] = strtolower($sort);
if( $orderby == 'product' )
{
$orderby = "tblproducts`.`name";
}
else
{
if( $orderby == 'amount' )
{
$orderby = "tblhosting`.`amount";
}
else
{
if( $orderby == 'billingcycle' )
{
$orderby = "tblhosting`.`billingcycle";
}
else
{
if( $orderby == 'status' )
{
$orderby = "tblhosting`.`domainstatus";
}
else
{
$orderby = "tblhosting`.`regdate";
}
}
}
}
$referrals = array( );
$result = select_query('tblaffiliatesaccounts', "tblaffiliatesaccounts.*,tblproducts.name,tblhosting.userid,tblhosting.domainstatus,tblhosting.amount,tblhosting.firstpaymentamount,tblhosting.regdate,tblhosting.billingcycle", array( 'affiliateid' => $affiliateid ), $orderby, $sort, $limit, "tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid");
while( $data = mysql_fetch_array($result) )
{
$affaccid = $data['id'];
$lastpaid = $data['lastpaid'];
$relid = $data['relid'];
$referralClientID = $data['userid'];
$firstpaymentamount = $data['firstpaymentamount'];
$amount = $data['amount'];
$date = $data['regdate'];
$service = $data['name'];
$billingcycle = $data['billingcycle'];
$status = $data['domainstatus'];
$date = fromMySQLDate($date);
$commission = calculateAffiliateCommission($affiliateid, $relid, $lastpaid);
if( !$domain )
{
$domain = '';
}
$lastpaid = $lastpaid == '0000-00-00' ? 'Never' : fromMySQLDate($lastpaid);
$status = $_LANG['clientarea' . strtolower($status)];
$billingcyclelang = strtolower($billingcycle);
$billingcyclelang = str_replace(" ", '', $billingcyclelang);
$billingcyclelang = str_replace('-', '', $billingcyclelang);
$billingcyclelang = $_LANG['orderpaymentterm' . $billingcyclelang];
$currency = getCurrency($referralClientID);
if( $billingcycle == 'Free' || $billingcycle == "Free Account" )
{
$amountdesc = $billingcyclelang;
}
else
{
if( $billingcycle == "One Time" )
{
$amountdesc = formatCurrency($firstpaymentamount) . " " . $billingcyclelang;
}
else
{
$amountdesc = $firstpaymentamount != $amount ? formatCurrency($firstpaymentamount) . " " . $_LANG['affiliatesinitialthen'] . " " : '';
$amountdesc .= formatCurrency($amount) . " " . $billingcyclelang;
}
}
$currency = getCurrency($affiliateClientID);
$referrals[] = array( 'id' => $affaccid, 'date' => $date, 'service' => $service, 'package' => $service, 'userid' => $referralClientID, 'amount' => $amount, 'billingcycle' => $billingcyclelang, 'amountdesc' => $amountdesc, 'commission' => formatCurrency($commission), 'lastpaid' => $lastpaid, 'status' => $status );
}
$smarty->assign('referrals', $referrals);
$smartyvalues = array_merge($smartyvalues, clientAreaTablePageNav($numitems));
$currency = getCurrency($affiliateClientID);
$commissionhistory = array( );
$result = select_query('tblaffiliateshistory', '', array( 'affiliateid' => $affiliateid ), 'id', 'DESC', '0,10');
while( $data = mysql_fetch_array($result) )
{
$historyid = $data['id'];
$date = $data['date'];
$affaccid = $data['affaccid'];
$amount = $data['amount'];
$date = fromMySQLDate($date);
$commissionhistory[] = array( 'date' => $date, 'referralid' => $affaccid, 'amount' => formatCurrency($amount) );
}
$smarty->assign('commissionhistory', $commissionhistory);
$withdrawalshistory = array( );
$result = select_query('tblaffiliateswithdrawals', '', array( 'affiliateid' => $id ), 'id', 'DESC');
while( $data = mysql_fetch_array($result) )
{
$historyid = $data['id'];
$date = $data['date'];
$amount = $data['amount'];
$date = fromMySQLDate($date);
$withdrawalshistory[] = array( 'date' => $date, 'amount' => formatCurrency($amount) );
}
$smarty->assign('withdrawalshistory', $withdrawalshistory);
$affiliatelinkscode = WHMCS_Input_Sanitize::decode($CONFIG['AffiliateLinks']);
$affiliatelinkscode = str_replace("[AffiliateLinkCode]", $CONFIG['SystemURL'] . "/aff.php?aff=" . $id, $affiliatelinkscode);
$affiliatelinkscode = str_replace("<(", "<", $affiliatelinkscode);
$affiliatelinkscode = str_replace(")>", ">", $affiliatelinkscode);
$smarty->assign('affiliatelinkscode', $affiliatelinkscode);
}
}
else
{
$goto = 'affiliates';
include("login.php");
}
if( $CONFIG['AffiliateEnabled'] != 'on' )
{
$smarty->assign('inactive', 'true');
}
outputClientArea($templatefile);