<?= $site_name; ?> - <?= $lang["titles"]["my_proposal

query("SELECT SUM(comission) AS total FROM proposal_referrals where referrer_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 proposal_referrals where referrer_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 proposal_referrals where referrer_id='$login_seller_id' AND status='declined'"); $total = $select->fetch()->total; $total = $total > 0 || $total!==null ? $total : "0"; echo showPrice($total); ?>

select("proposal_referrals",array("referrer_id" => $login_seller_id),"DESC"); $count_referrals = $sel_referrals->rowCount(); if($count_referrals == 0){ echo " "; }else{ while($row_referrals = $sel_referrals->fetch()){ $proposal_id = $row_referrals->proposal_id; $seller_id = $row_referrals->seller_id; $buyer_id = $row_referrals->buyer_id; $comission = $row_referrals->comission; $date = $row_referrals->date; $status = $row_referrals->status; $select_seller = $db->select("sellers",array("seller_id" => $seller_id)); $row_seller = $select_seller->fetch(); $seller_user_name = $row_seller->seller_user_name; $select_buyer = $db->select("sellers",array("seller_id" => $buyer_id)); $row_buyer = $select_buyer->fetch(); $buyer_user_name = $row_buyer->seller_user_name; $select_proposals = $db->select("proposals",array("proposal_id" => $proposal_id)); $row_proposals = $select_proposals->fetch(); $proposal_title = $row_proposals->proposal_title; ?>


{$lang['proposal_referrals']['no_referrals']}
					">

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