";
print "$login_cnt Logins, Last Login $last_login from $from_ip
";
print "Affiliate Since $created
";
?>
| Quick Stats for |
|---|
Raw
Clicks | Raw
Submits | Approvals | Denials | Cancels | Refunds | MTD
Earnings |
|---|
";
$result = db_query($query,__LINE__ ,__FILE__);
list($clicks,$submits,$approves,$denials,$cancels,$refunds) = mysql_fetch_row($result);
$pay = 0;
$query = "SELECT merch_id, payout_id, amount, affil_code, trans_type, ref_trans_id, payout_type, payout_pps_fix, payout_pps_pct, payout_rcr_fix, payout_rcr_pct FROM trans WHERE (trans_type='S' || trans_type='R' || trans_type='D') and YEAR(trans_date)=YEAR(CURRENT_DATE) and MONTH(trans_date)=MONTH(CURRENT_DATE) and ($where)";
$result = db_query($query,__LINE__ ,__FILE__);
$number = MYSQL_NUMROWS($result);
$i = 0;
while ($i < $number) {
list($merch_id, $payout_id, $amount, $affcode, $trans_type, $ref_trans_id, $payout_type, $payout_pps_fix, $payout_pps_pct, $payout_rcr_fix, $payout_rcr_pct) = mysql_fetch_row($result);
if($trans_type == 'D') {
$query = "SELECT merch_id, payout_id, amount, trans_type, payout_type, payout_pps_fix, payout_pps_pct, payout_rcr_fix, payout_rcr_pct FROM trans WHERE trans_id='$ref_trans_id'";
$result3 = db_query($query,__LINE__ ,__FILE__);
list($mid, $pid, $amt, $ttype, $ptype, $ppsfix, $ppspct, $rcrfix, $rcrpct) = mysql_fetch_row($result3);
$pay = calc_affil_payout($amt,$ttype,$ptype,$ppsfix,$ppspct,$rcrfix,$rcrpct);
$pay = -$pay;
} else {
$pay = calc_affil_payout($amount,$trans_type,$payout_type,$payout_pps_fix,$payout_pps_pct,$payout_rcr_fix,$payout_rcr_pct);
}
$totpay += $pay;
$i++;
}
$totpay = sprintf("%1.2f", $totpay);
print "| $clicks | $submits | $approves | $denials | $cancels | $refunds | $totpay |
|---|
";
print "
";
do_footer('A');
?>