<?php echo !defined("GUVENLIK") ? die("Erisim Engellendi!.") : null;?>
<?php 
$page = @intval($_GET['s']);
if(!$page) $page = 1;
$ttsorgu = $db->prepare("SELECT COUNT(*) FROM musteri_gorusleri WHERE durum = ?");
$ttsorgu->execute(array("1"));
$total = $ttsorgu->fetchColumn();
$limit= $limitayar['limit_sayfayorumlar'];
$page_count = ceil($total/$limit);
if($page > $page_count) $page = 1;
$show = $page * $limit - $limit;
$BSorgu = $db->prepare("SELECT * FROM musteri_gorusleri WHERE durum = ? ORDER BY id DESC LIMIT $show,$limit");
$BSorgu->execute(array("1"));
$Bislem = $BSorgu->fetchALL(PDO::FETCH_ASSOC);
$menubul 	= $db->query("SELECT * FROM menu WHERE menu_url = '".$htc['musteriurl']."' OR link = '".$htc['musteriurl']."' AND dil = '{$_SESSION['k_dil']}'")->fetch(PDO::FETCH_ASSOC);
$menubas 	= $db->query("SELECT * FROM menu WHERE id = '{$menubul['menu_ust']}' AND dil = '{$_SESSION['k_dil']}'")->fetch(PDO::FETCH_ASSOC);	
?>
<!-- Start main-content -->
<div class="main-content">

    <!-- Section: inner-header -->
    <section class="inner-header bg-lighter">
		<div class="container pt-10 pb-10">
			<!-- Section Content -->
			<div class="section-content">
				<div class="row d-ortala">
					<div class="col-md-11">
						<h3 class="font-30 mb-0 mt-10"><?=@$dil['txt133'];?></h3>
						<ol class="breadcrumb text-black mt-0 mb-10">
							<li><a href="<?php echo $htc['anaurl'];?><?php echo $html;?>"><?=@$dil['txt56'];?></a></li>
							<?php if($menubas['menu_isim'] != ""){?>
							<li><a href="<?php echo($menubas['menu_url'] == "0" ? $menubas['link'] : $menubas['menu_url'].$html);?>"><?php echo ilkbuyuk($menubas['menu_isim']);?></a></li>
							<?php }?>
							<li class="active text-theme-colored"><?=@$dil['txt133'];?></li>
						</ol>
					</div>
					<div class="col-md-1">
						<a href="javascript:history.back();" class="sayfa-geri"><span class="icon"><i class="fas fa-arrow-left"></i></span><?=@$dil['txt57'];?></a>
					</div>
				</div>
			</div>
		</div>
	</section>

    <!-- Section: About -->
    <section>
        <div class="container pt-50 pb-50">
            <div class="section-content">
                <div class="row">
					<div class="col-lg-12 col-md-12 text-right" style="margin-bottom:15px;">
						<a href="" data-remodal-target="musteri_gorusleri" class="btn btn-gray btn-theme-colored btn-circled btn-lg"><?=@$dil['txt134'];?></a>
					</div>
					<?php if($BSorgu->rowCount() != "0"){?>
					<?php foreach ( $Bislem as $BSonuc ){?>
					<!-- Testimonial Block Three -->
					<div class="testimonial-block-three style-two col-lg-<?php echo $limitayar['limit_yorum'];?> col-md-<?php echo $limitayar['limit_yorum'];?> col-sm-12">
						<div class="inner-box">
							<div class="upper-box">
								<div class="title"><?php echo tarih($BSonuc['tarih']);?></div>
								<div class="text"><?php echo $BSonuc['yorum'];?></div>
							</div>
							<div class="lower-box">
								<div class="lower-inner">
									<div class="author-image">
										<img src="<?php echo tema;?>/images/unnamed.png" alt="" />
									</div>
									<div class="designation"><?php echo $BSonuc['meslek'];?></div>
									<h3><?php echo $BSonuc['isim'];?></h3>
								</div>
							</div>
						</div>
					</div>
					<?php }?>
					<?php }else{?>	
					<div class="col-md-12">
						<div class="alert alert-warning text-left " style="width:100%;" role="alert">
							<p><strong><?=@$dil['txt59'];?></strong></p>
							<?=@$dil['txt60'];?></br>
							<?=@$dil['txt61'];?>
						</div>
					</div>
					<?php }?>
                </div>
				
				<div class="row">
					<div class="col-sm-12 mt-20">
						<p><?php echo $total;?> <?=@$dil['txt62'];?>  <?php echo $page;?> - <?php echo $limitayar['limit_sayfayorumlar'];?> <?=@$dil['txt63'];?></p>
						<nav>
							<ul class="pagination theme-colored xs-pull-center m-0">
							<?php
							if($limitayar['limit_sayfayorumlar'] < $total && $limitayar['limit_sayfayorumlar'] > 0){
							$showing = 3;
							if($page > 1){?>
							<?php $previous = $page - 1;?>
							<li><a href="<?php echo $htc['musteriurl'];?>/<?php echo $previous;?><?php echo $html;?>" aria-label="Previous"> <span aria-hidden="true">«</span> </a> </li>
							<?php }
							for($i= $page - $showing; $i < $page + $showing + 1; $i++){
							if($i > 0 and $i <= $page_count){
							if($i == $page){?>
							<li class="active"><a href="javascript:void(0);"><?php echo $i; ?></a></li>
							<?php }else{?>
							<li><a href="<?php echo $htc['musteriurl'];?>/<?php echo $i; ?><?php echo $html;?>"><?php echo $i; ?></a></li>
							<?php }
							}
							}
							if($page != $page_count){?>
							<?php  $next = $page +1;?>
							<li> <a href="<?php echo $htc['musteriurl'];?>/<?php echo $next; ?><?php echo $html;?>" aria-label="Next"> <span aria-hidden="true">»</span> </a> </li>
							<?php }} ?>	
							</ul>
						</nav>
					</div>
				</div>
            </div>
        </div>
    </section>

</div>
<!-- end main-content -->
<!--Müşteri Görüşleri -->
<div class="remodal p-0 popupform" data-remodal-id="musteri_gorusleri" data-remodal-options="hashTracking: false, closeOnOutsideClick: false">
    <a data-remodal-action="close" class="remodal-close bg-white"></a>
    <form action="_class/site_islem.php" class="form-column yorum-form mb-0" method="post" autocomplete="off">
        <div class="inner-column mt-0 rounded-0">
			<h2><?=@$dil['txt134'];?></h2>
			<!--Default Form-->
			<div class="default-form">
				<div class="row clearfix">

					<div class="form-group col-md-12 col-sm-12 col-xs-12">
						<input type="text" name="isim" placeholder="<?=@$dil['txt107'];?>" required="">
					</div>

					<div class="form-group col-md-6 col-sm-6 col-xs-12">
						<input type="text" name="meslek" placeholder="<?=@$dil['txt135'];?>">
					</div>

					<div class="form-group col-md-6 col-sm-6 col-xs-12">
						<input type="text" name="sehir" placeholder="<?=@$dil['txt136'];?>">
					</div>

					<div class="form-group col-md-12 col-sm-12 col-xs-12">
						<textarea name="yorum" placeholder="<?=@$dil['txt137'];?>" required=""></textarea>
					</div>

					<div class="form-group text-center btn-column col-md-12 col-sm-12 col-xs-12">
						<input type="hidden" name="kontrol" value="" id="kontrol">	
						<input type="hidden" name="yorumurl" value="<?php echo $sayfalink;?>" />
						<button type="submit" name="yorumbtn" class="btn btn-gray btn-theme-colored btn-circled btn-lg"><span class="txt"><?=@$dil['txt80'];?></span></button>
					</div>

				</div>
			</div>

		</div>
    </form>
</div>