select("favorites",array("seller_id" => $login_seller_id));
while($row_favorites = $get_favorites->fetch()){
$favorite_proposal_id = $row_favorites->proposal_id;
$get_proposals = $db->select("proposals",array("proposal_id" => $favorite_proposal_id));
$row_proposals = $get_proposals->fetch();
$proposal_id = $row_proposals->proposal_id;
$proposal_title = $row_proposals->proposal_title;
$proposal_price = $row_proposals->proposal_price;
if($proposal_price == 0){
$get_p_1 = $db->select("proposal_packages",array("proposal_id" => $proposal_id,"package_name" => "Basic"));
$proposal_price = $get_p_1->fetch()->price;
}
$proposal_img1 = getImageUrl2("proposals","proposal_img1",$row_proposals->proposal_img1);
$proposal_video = $row_proposals->proposal_video;
$proposal_seller_id = $row_proposals->proposal_seller_id;
$proposal_rating = $row_proposals->proposal_rating;
$proposal_url = $row_proposals->proposal_url;
$proposal_featured = $row_proposals->proposal_featured;
$proposal_enable_referrals = $row_proposals->proposal_enable_referrals;
$proposal_referral_money = $row_proposals->proposal_referral_money;
if(empty($proposal_video)){
$video_class = "";
}else{
$video_class = "video-img";
}
$get_seller = $db->select("sellers",array("seller_id" => $proposal_seller_id));
$row_seller = $get_seller->fetch();
$seller_user_name = $row_seller->seller_user_name;
$seller_image = getImageUrl2("sellers","seller_image",$row_seller->seller_image);
$seller_level = $row_seller->seller_level;
$seller_status = $row_seller->seller_status;
if(empty($seller_image)){
$seller_image = "empty-image.png";
}
// Select Proposal Seller Level
@$seller_level = $db->select("seller_levels_meta",array("level_id"=>$seller_level,"language_id"=>$siteLanguage))->fetch()->title;
$proposal_reviews = array();
$select_buyer_reviews = $db->select("buyer_reviews",array("proposal_id" => $proposal_id));
$count_reviews = $select_buyer_reviews->rowCount();
while($row_buyer_reviews = $select_buyer_reviews->fetch()){
$proposal_buyer_rating = $row_buyer_reviews->buyer_rating;
array_push($proposal_reviews,$proposal_buyer_rating);
}
$total = array_sum($proposal_reviews);
@$average_rating = $total/count($proposal_reviews);
$count_favorites = $db->count("favorites",array("proposal_id" => $proposal_id,"seller_id" => $login_seller_id));
if($count_favorites == 0){
$show_favorite_class = "proposal-favorite";
}else{
$show_favorite_class = "proposal-unfavorite";
}
?>
