window.open('login','_self')"; } $login_seller_user_name = $_SESSION['seller_user_name']; $select_login_seller = $db->select("sellers",array("seller_user_name" => $login_seller_user_name)); $row_login_seller = $select_login_seller->fetch(); $login_seller_id = $row_login_seller->seller_id; $login_seller_referral = $row_login_seller->seller_referral; $referral_money = $row_general_settings->referral_money; ?> <?= $site_name; ?> - <?= $lang["titles"]["my_referrals"]; ?>

?referral=

query("SELECT SUM(comission) AS total FROM referrals where seller_id='$login_seller_id' AND status='approved'"); $total = $select->fetch()->total; $total = $total > 0 || $total!==null ? $total : "0"; echo showPrice($total); ?>
query("SELECT SUM(comission) AS total FROM referrals where seller_id='$login_seller_id' AND status='pending'"); $total = $select->fetch()->total; $total = $total > 0 || $total!==null ? $total : "0"; echo showPrice($total); ?>
query("SELECT SUM(comission) AS total FROM referrals where seller_id='$login_seller_id' AND status='declined'"); $total = $select->fetch()->total; $total = $total > 0 || $total!==null ? $total : "0"; echo showPrice($total); ?>
select("referrals",array("seller_id" => $login_seller_id),"DESC"); $count_referrals = $sel_referrals->rowCount(); if($count_referrals == 0){ echo " "; }else{ while($row_referrals = $sel_referrals->fetch()){ $referred_id = $row_referrals->referred_id; $comission = $row_referrals->comission; $date = $row_referrals->date; $status = $row_referrals->status; $select_seller = $db->select("sellers",array("seller_id" => $referred_id)); $row_seller = $select_seller->fetch(); $seller_user_name = $row_seller->seller_user_name; ?>

{$lang['my_referrals']['no_referrals']}

">