<!-- 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">
                <div class="box-header">
                  <h3 class="box-title">Eczane Listesi</h3>
                </div><!-- /.box-header -->
                <div class="box-body"> 

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

                        <th>Eczane Adı</th>

<th>İl</th>
                       
<th>İlçe</th>

<th>Konsinye Ekle</th>
     <th>Konsinye Düşür</th>                 
 
     <th>Satışa Çevir</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 DOKTOR_ID From eczane"));
 
$s_sayisi=ceil($k_sayisi/$gosterim);
 
$ilk_kayit=($sayfa*$gosterim)-$gosterim;
	
	
	
 $sorumlu_kodu=$_SESSION["kullanici_adi"];
 
  $sql = mysql_query("SELECT * FROM eczane  WHERE DOKTOR_SORUMLU_KODU='$sorumlu_kodu' and DOKTOR_DURUM='Aktif'  Order By DOKTOR_ID desc Limit $ilk_kayit,$gosterim");
 $i = 0; 
    $sutun    = 1;  
$s    = 0; 
    
    


	while($veri = mysql_fetch_assoc($sql)) 
	
    { 
	
$i++; 

    

	
        echo ' 
      	

<tr>

	<td><b>',$veri["DOKTOR_ADI"],'</b></td>
 	<td  >',$veri["DOKTOR_IL"],'</td>
 <td  >',$veri["DOKTOR_ILCE"],'</td>
 


<td><a   class="various fancybox.iframe" href="hedef/konsinyeekle2.php?DOKTOR_ID=',$veri["DOKTOR_ID"],'"> 

<button  class="btn btn-block btn-primary" ><i class="fa fa-fw fa-edit"></i>Konsinye Ekle</button></a></td>





 

 <td><a class="various fancybox.iframe"  href="hedef/stokgor.php?DOKTOR_ADI=',$veri["DOKTOR_ADI"],'"> 

<button  class="btn btn-block btn-danger"><i class="fa fa-fw fa-edit"></i>Kalan Stoklar</button></a></td>
 

 <td><a class="various fancybox.iframe"  href="hedef/konsinye_eczane.php?DOKTOR_ADI=',$veri["DOKTOR_ADI"],'"> 

<button  class="btn btn-block btn-danger"><i class="fa fa-fw fa-edit"></i>Satışa Çevir</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 -->

    <script>
      $(function () {
     
        $('#example1').DataTable({
          "paging": true,
          "lengthChange": true,
          "searching": true,
          "ordering": true,
          "info": true,
          "autoWidth": true

        });
      });
    </script>