<?

include 'header.php';
 
?>

<style>
    .paginate_button{
        margin:3px;
    }
</style>


<form class="card">
                    <div class="card-body">
                      <h3 class="card-title">Fitrele</h3>
                      <div class="row row-cards"> 
                        <div class="col-sm-6 col-md-3">
                          <div class="mb-3">
                            <label class="form-label">Ara</label>
                            <input type="text" class="form-control" placeholder="İşemri,imei" value="<?=p('ara')?>">
                          </div>
                        </div>  
                      </div>
                    </div>
                    <div class="card-footer text-end">
                      <button type="submit" class="btn btn-primary">Filtrele</button>
                    </div>
</form>
                  
                  
                  
<table id="myTable" class="table table-responsive">
    <thead>
    <tr>
        <th>ID</th>
        <th>Cihaz</th> 
        <th>Teslim Nedeni</th> 
        <th>Takip No</th> 
        <th>IMEI</th> 
        <th>Seri No</th> 
        <th>Durum</th> 
        <th>Grade</th>
        <th></th>
    </tr>
    </thead>
    <tbody>
    <?
        $row = "select *,markalar.marka as marka_text,modeller.model as model_text,hafiza.hafiza as hafiza_text,renk.renk as renk_text,urunler.id as isemri,teslim_nedeni.teslim_nedeni as tn_text,turler.tur as tur_text , hafiza.tip as hafiza_turu,durum.durum as durum_text,grade_tipleri.grade as grade_text from urunler 
        join markalar on urunler.marka=markalar.id  
        join modeller on urunler.model=modeller.id 
        join hafiza on urunler.hafiza=hafiza.id
        join renk on urunler.renk=renk.id
        join teslim_nedeni on urunler.teslim_nedeni=teslim_nedeni.id
        join turler on urunler.cihaz_turu=turler.id
        join durum on urunler.durum=durum.id
        join grade_tipleri on urunler.grade_tipi=grade_tipleri.grade
        
        where urunler.id<>0 order by urunler.id desc limit 50";
		$row = $func->query($row);
		$row=$row->fetchAll();
		
		foreach($row as $rs){
    ?>    
    <tr>
        <td><?=$rs->isemri?></td>
        <td> <?=$rs->tur_text?> <?=$rs->marka_text?> <?=$rs->model_text?> <?=$rs->renk_text?> <?=$rs->hafiza_text?> <?=$rs->hafiza_turu?></td>
        <td><?=$rs->tn_text?></td>
        <td><?=$rs->takip_no?></td>
        <td><?=$rs->imei?></td>
        <td><?=$rs->seri_no?></td>
        <td><?=$rs->durum_text?></td>
        <td><?=$rs->grade_text?></td>
        <td>Barkod</td>
        
        
    </tr>
    <?}?>
    
   
    
    </tbody>
</table>


<script type="text/javascript" src="https://cdn.datatables.net/v/bs-3.3.7/jq-2.2.4/jszip-3.1.3/pdfmake-0.1.27/dt-1.10.15/b-1.3.1/b-html5-1.3.1/b-print-1.3.1/r-2.1.1/rg-1.0.0/datatables.min.js"></script>


<script>
        $('#myTable').DataTable({
            language: {
                info: "_TOTAL_ kayıttan _START_ - _END_ kayıt gösteriliyor.",
                infoEmpty:      "Gösterilecek hiç kayıt yok.",
                loadingRecords: "Kayıtlar yükleniyor.",
                zeroRecords: "Tablo boş",
                search: "Arama:",
                infoFiltered:   "(toplam _MAX_ kayıttan filtrelenenler)",
                buttons: {
                    copyTitle: "Panoya kopyalandı.",
                    copySuccess:"Panoya %d satır kopyalandı",
                    copy: "Kopyala",
                    print: "Yazdır",
                },

                paginate: {
                    first: "İlk",
                    previous: "Önceki",
                    next: "Sonraki",
                    last: "Son"
                },
            },
            dom: 'Bfrtip',
            buttons: [
                'copy', 'excel', 'pdf', 'print'
            ],
            responsive: true
        });
</script>


 

<?
include 'footer.php';
?>