<? 
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
include 'accesscontrol.php';
// css for menu
$styleManage = 'color:#ff6131;background-color:#fff;border-top:1px solid #c9c9c9;font-weight:bold;';
$adid=$_GET['adid'];
// check if advert beleongs to members
if(advert_check($adid,$memberid)===false){header('Location: index.html');exit();}
// for opening times
if($_GET['s']=='y'&&isset($_GET['revid'])){

$revid=$_GET['revid'];
$q3 = "UPDATE reviews SET rev_spam='1', rev_confirm='0'  WHERE rev_id='{$revid}'";
$r3 = $connect->query($q3) or die($connect->error);
$success=TRUE;
}

$r6 = $connect->query("SELECT review_on FROM ads WHERE adid ='{$adid}'");
$review_on=$r6->fetch_array();

if($review_on['review_on']=='1'){
	$rev_on_style='display:none;';
}else{
	$rev_off_style='display:none;';
}

$r7 = $connect->query("SELECT * FROM reviews WHERE rev_ad_id ='{$adid}' AND rev_confirm='1' AND rev_spam='0' ORDER BY rev_id DESC LIMIT 20");
$rev_numRow=$r7->num_rows;
		if($rev_numRow>0){
			while($rev_row = $r7->fetch_array()){
			if($rev_row['rev_spam']=='0'){$bgCol="background-color:#fafafa;";}else{$bgCol="background-color:#fff0f0;";}
				$reviewContent .= '<div style="'.$bgCol.'padding:0px 40px 20px;margin-top:20px;" class="curv7">';
				$reviewContent .= '<table class="revTbl" width="100%">';
				$ratings[] = $rev_row['rev_rating'];
				//if($rev_row['rev_reply']!=''){$revStyleCss1='border-bottom:1px solid #999;';}else{$revStyleCss='padding-bottom:40px;border-bottom:1px solid #999;';}
				$reviewContent .= '<tr><td valign="top" style="padding-top:20px;'.$revStyleCss.'">';
				$reviewContent .= '<div style="font-size:18pt;color:#294576;">'.$rev_row['rev_name'].'</div>';
				$reviewContent .= '<div style="margin-top:6px;font-size:10pt;color:#666;"><b>Review given on: </b>'.date('d/m/Y',$rev_row['rev_date']).'</div>';
				$reviewContent .= '<div class="curv7" style="margin-top:15px;background-color:#fff;padding:15px;border:1px solid #a8a8a8;">'.htmlentities($rev_row['rev_comment']).'</div></td>';
				$reviewContent .= '<td valign="middle" style="text-align:center;width:155px;padding-top:20px;padding-left:20px;'.$revStyleCss.'"><div style="font-size:20pt;font-weight:bold">';
				$reviewContent .= $rev_row['rev_rating'].'/5<br><img class="rate_'.$rev_row['rev_rating'].'" src="/img/img_trans.gif" width="1" height="1" /></div></td></tr>';
				
				if($rev_row['rev_reply']!=''){
					$reviewContent .= '<tr><td colspan="2" style="padding:20px 0px 0px 60px;'.$revStyleCss1.'">';
					$reviewContent .= '<div class="curv7" style="background-color:#eee;padding:15px;border:1px solid #a8a8a8;margin-right:30px"><b>Your Response ...</b><br>';
					$reviewContent .= htmlentities($rev_row['rev_reply']).'</div>';
					$reviewContent .='</td></tr>';
				}else{
					$reviewContent .= '<tr><td colspan="2" style="padding:20px 0px 5px;text-align:right;'.$revStyleCss1.'">';
					if($rev_row['rev_spam']=='0'){
					$reviewContent .= '<a href="review_reply.html?adid='.$adid.'&revid='.$rev_row['rev_id'].'" style="margin-top:10px;float:none;margin-right:10px;" class="blueBtn fancyBtn">Reply to this review >></a>';
					$reviewContent .= '<a onclick="return confirm(\'Are you sure you want to mark this review as spam?\');" href="review.html?adid='.$adid.'&s=y&revid='.$rev_row['rev_id'].'" style="margin-top:10px;float:none;" class="redBtn fancyBtn">Mark as Spam!</a>';
					}else{
					$reviewContent .= '<span style="color:#5d322c;font-weight:bold;">Marked as Spam</span>';
					}
					$reviewContent .='</td></tr>';
				}
				
				$revStyleCss='';$revStyleCss1='';$bgCol='';
				$reviewContent .= '</table></div>';
				}
			$arr_sum = array_sum($ratings);
			$mean = $arr_sum  / $rev_numRow;
			$average = round($mean*2)/2; // round to the nearest half
			$averageCss=str_replace(".","-",$average);
			$advert_rating='<img class="rate_'.$averageCss.'" src="/img/img_trans.gif" width="1" height="1" /><meta itemprop="rating" content="'.$average.'" /> ';
		}else{
			$reviewContent = '<div style="border-top:1px solid #ddd;padding-top:25px;font-weight:bold;text-align:center;color:#888;">You have no reviews for this advert.</div>';
		}
?>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>YellowLeaf UK</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script src="js/ajax_review.js"></script>
<style>
.det_cnt{padding:30px;border-bottom:1px solid #cecece;}
.det_head{color:#15c;font-size:14pt;margin-bottom:5px;font-weight:bold;}
.det_info{color:#222;line-height:21px;}
.opTbl td{padding:10px}
.smlPic{width:130px;margin:0px;}
.imgShadd{-moz-box-shadow:0px 2px 3px 0px #666; -webkit-box-shadow: 0px 2px 3px 0px #666; box-shadow:0px 2px 3px 0px #666;}
.bxShadd{-moz-box-shadow:0px 2px 6px 0px #E4E4E4; -webkit-box-shadow:0px 2px 6px 0px #E4E4E4; box-shadow:0px 2px 6px 0px #E4E4E4;}
.picCn{height:80px;overflow:hidden;margin-bottom:15px;}
.promoTbl td{padding:20px 0px;<?=$promCss?>}
.rate_0{width:101px;height:19px;background:url(/img/stars.png) 0 0;}
.rate_0-5{width:101px;height:19px;background:url(/img/stars.png) 0 -20px;}
.rate_1{width:101px;height:19px;background:url(/img/stars.png) 0 -39px;}
.rate_1-5{width:101px;height:19px;background:url(/img/stars.png) 0 -58px;}
.rate_2{width:101px;height:19px;background:url(/img/stars.png) 0 -77px;}
.rate_2-5{width:101px;height:19px;background:url(/img/stars.png) 0 -96px;}
.rate_3{width:101px;height:19px;background:url(/img/stars.png) 0 -115px;}
.rate_3-5{width:101px;height:19px;background:url(/img/stars.png) 0 -134px;}
.rate_4{width:101px;height:19px;background:url(/img/stars.png) 0 -153px;}
.rate_4-5{width:101px;height:19px;background:url(/img/stars.png) 0 -172px;}
.rate_5{width:101px;height:19px;background:url(/img/stars.png) 0 -191px;}
.rev-settings-box{margin:15px 0;border:1px solid #aaa;overflow:hidden;background: rgb(247,247,247);background: -moz-linear-gradient(top,  rgba(247,247,247,1) 0%, rgba(240,240,240,1) 100%);background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(247,247,247,1)), color-stop(100%,rgba(240,240,240,1)));background: -webkit-linear-gradient(top,  rgba(247,247,247,1) 0%,rgba(240,240,240,1) 100%);background: -o-linear-gradient(top,  rgba(247,247,247,1) 0%,rgba(240,240,240,1) 100%);background: -ms-linear-gradient(top,  rgba(247,247,247,1) 0%,rgba(240,240,240,1) 100%);background: linear-gradient(to bottom,  rgba(247,247,247,1) 0%,rgba(240,240,240,1) 100%);filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#f7f7f7', endColorstr='#f0f0f0',GradientType=0 );}
.rev_btn_set{float:left;padding:8px;}
.rev_btn_set:hover{background:#b5d68e;cursor:pointer}
.rev_btn_set:active{background:#cbe8a8;}
</style>
</head>

<body>

<? include 'header.php'; ?>
<table class="tbwdth">
	<tr>
		<td valign="top" style="width:210px;"><? include 'member_menu.php'; ?>
		</td>
		<td valign="top" class="cnGrad">
		<?
		// business details
		$ad_sql = $connect->query("SELECT * FROM ads WHERE memberid ='{$memberid}' AND adid='{$adid}'");
		$ad_row=$ad_sql->fetch_array();
		?>
		<div class="cnHead" style="margin-bottom:3px;">Latest Reviews for <?=$ad_row['companyname']?></div>
		<div style="color:#666;font-size:11pt;font-weight:bold;margin-bottom:7px;">Showing upto 20 latest reviews</div>
		<div class="curv3 rev-settings-box">
			<div style="float:left;margin-right:10px;padding:8px 0 8px 8px;"><b>Show Reviews: </b></div>
			<div id="review_on" class="rev_btn_set" style="<?=$rev_on_style?>" onclick="review_change(<?=$adid?>,1)">Enable Reviews</div>
			<div id="review_off" class="rev_btn_set" style="<?=$rev_off_style?>" onclick="review_change(<?=$adid?>,0)">Disable Reviews</div>
		</div>
		<?if($rev_numRow!=0){?>
			<div style="float:left;display:inline;"><?=$advert_rating?></div>
			<div style="float:left;margin-top:2px;margin-left:9px;font-size:11pt;color:#444;font-weight:bold;" itemprop="rating" itemscope itemtype="http://data-vocabulary.org/Rating">
			  <span itemprop="average">Overall Rating <?=$average?></span> out of <span itemprop="best">5</span>. Based on <span itemprop="count"><?=$rev_numRow?></span> user reviews.
			</div>
		<?}?>
		<br><br>
		<?if($success==TRUE){?>
		<div style="margin-top:10px;" class="successDvBx">Review has been marked as spam.</div>
		<?}?>
		<div id="rev_content" style="<?=$rev_off_style?>">
		<?=$reviewContent?>
		</div>
		</td>
	</tr>
</table>
<? include 'footer.php'; ?>

</body>

</html>