 

<!-- DataTables -->
    <link rel="stylesheet" href="./plugins/datatables/dataTables.bootstrap.css">


 <!-- DataTables -->
    <script src="./plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="./plugins/datatables/dataTables.bootstrap.min.js"></script>


<script language="javascript">
function confirmDel() {
 var agree=confirm("Bu içeriği silmek istediğinizden emin misiniz?\nBu işlem geri alınamaz!");
 if (agree) {
  return true ; }
 else {
  return false ;}
}
</script>





<!-- Add mousewheel plugin (this is optional) -->
<script type="text/javascript" src="fancybox/lib/jquery.mousewheel-3.0.6.pack.js"></script>

<!-- Add fancyBox -->
<link rel="stylesheet" href="fancybox/source/jquery.fancybox.css?v=2.1.5" type="text/css" media="screen" />
<script type="text/javascript" src="fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>

<!-- Optionally add helpers - button, thumbnail and/or media -->
<link rel="stylesheet" href="fancybox/source/helpers/jquery.fancybox-buttons.css?v=1.0.5" type="text/css" media="screen" />
<script type="text/javascript" src="fancybox/source/helpers/jquery.fancybox-buttons.js?v=1.0.5"></script>
<script type="text/javascript" src="fancybox/source/helpers/jquery.fancybox-media.js?v=1.0.6"></script>

<link rel="stylesheet" href="fancybox/source/helpers/jquery.fancybox-thumbs.css?v=1.0.7" type="text/css" media="screen" />
<script type="text/javascript" src="fancybox/source/helpers/jquery.fancybox-thumbs.js?v=1.0.7"></script>






<script type="text/javascript">
	$(document).ready(function() {
	$(".various").fancybox({
		maxWidth	: 800,
		maxHeight	: 600,
		fitToView	: false,
		width		: '70%',
		height		: '70%',
		autoSize	: false,
		closeClick	: false,
		openEffect	: 'none',
		closeEffect	: 'none'
	});
});
</script>

<div class="box-body">
<div class="row">
<div class="col-xs-3">
<form action="admin.php?target=arama4" method="post" >
<div class="input-group">
<label> Tarihe Göre Arama </label>
<input type="text" name="search" class="form-control" placeholder="01.01.2014"/>
<input type="text" name="search2" class="form-control" placeholder="02.01.2014"/>
                       <span class="input-group-btn">
                                <button type='submit' name='searchs' id='search-btn' class="btn btn-flat"><i class="fa fa-search"></i></button>
                            </span>
                        </div>
                    </form>

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

 <div class="box">
                <div class="box-header">
                  <h3 class="box-title">Görüşme Listesi</h3>
                </div><!-- /.box-header -->






                <div class="box-body">
                  <table id="example1" class="table table-bordered table-striped">
                      <thead>
                      <tr>

                        <th>Görüşme Tarihi </th>
						<th>Görüşme Temsilcisi </th>
                        <th>Doktor Adı</th>
 						<th>Doktor Kurum</th>

                 		<th>Görüşme Notu</th>       
                 		<th>Planlanan Görüşme Notu</th>     
			     		<th>Detay</th>   
						<th>Düzenle</th> 	
						<th>Sil</th> 
                		</tr>
                   		</thead>
                    




<tbody>





<?php
include("baglan.php");
	
$gosterim=10000;
 $sayfa=@$_GET['sayfa'];
 
if(empty($sayfa) || !is_numeric($sayfa)){$sayfa=1;}

 
$k_sayisi=mysql_num_rows(mysql_query("Select GORUSME_ID From gorusme"));
 
$s_sayisi=ceil($k_sayisi/$gosterim);
 
$ilk_kayit=($sayfa*$gosterim)-$gosterim;
	
	
$sorumlu_kodu=$_SESSION["kullanici_adi"];	

 
  $sql = mysql_query("SELECT * FROM gorusme WHERE GORUSME_YETKILI='$sorumlu_kodu' Order By GORUSME_ID DESC Limit $ilk_kayit,$gosterim");
 $i = 0; 
    $sutun    = 1;  
$s    = 0; 
    
 

	while($veri = mysql_fetch_assoc($sql)) 

    

	
    { 
	
$i++; 

    
$doktorbul = mysql_fetch_assoc(mysql_query("SELECT * FROM doktorlar WHERE DOKTOR_ID='".$veri['DOKTOR_ID']."'"));
	$temsilcibul = mysql_fetch_assoc(mysql_query("SELECT * FROM personel WHERE PERSONEL_MAIL='".$veri['GORUSME_YETKILI']."'"));	
        echo ' 
      	

<tr>

	<td><b>',$veri["GORUSME_TARIH"],'</b></td>
	<td><b>',$temsilcibul["PERSONEL_ADI"],'</b></td>
	<td>',$doktorbul["DOKTOR_ADI"],'</td>
	<td>',$doktorbul["DOKTOR_KURUMU"],'</td>
    <td>',$veri["GORUSME_NOT"],'</td>
    <td>',$veri["GORUSME_BIR_SONRAKI_NOT"],'</td>


    <td><a class="various fancybox.iframe" href="hedef/gorusme_detay.php?GORUSME_ID=',$veri["GORUSME_ID"],'"> 
    <button  class="btn btn-primary btn-flat"><i class="fa fa-fw fa-eye"></i></button></a> </td>

<td><a href="admin.php?target=gorusmeduzenle&?&GORUSME_ID=',$veri["GORUSME_ID"],'"> 
    <button  class="btn bg-purple btn-flat"><i class="fa fa-fw fa-edit"></i></button></a> </td>

 
			
<td><a href="admin.php?target=gorusmesil-islem&?&GORUSME_ID=',$veri["GORUSME_ID"],'" onclick="return confirmDel();"> 
    <button  class="btn bg-red btn-flat"><i class="fa fa-fw fa-remove"></i></button></a> </td>
				
				
		 </tr>	 
				'; 
		
		
        if ($i % $sutun == 0) 
        { 
        echo ' 
 

 
   '; 
        } 
    } 

if($sayfa!=1){
   
}

for($i=1;$i<=$s_sayisi;$i++){
    

}


if($sayfa!=$s_sayisi){
  

} 
?>
                    </tbody>
                    
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->


 








            </div><!-- /.col -->
          </div><!-- /.row -->

