<? 
include 'header.php';
?>



<style>
    .dataTables_filter{
        display:none; 
    }
    .paginate_button {
        padding-right:15px;
    }
    
    	.multiselect-native-select {
		position: relative;
		select {
			border: 0 !important;
			clip: rect(0 0 0 0) !important;
			height: 1px !important;
			margin: -1px -1px -1px -3px !important;
			overflow: hidden !important;
			padding: 0 !important;
			position: absolute !important;
			width: 1px !important;
			left: 50%;
			top: 30px;
		}
	}
	.multiselect-container {
		position: absolute;
		list-style-type: none;
		margin: 0;
		padding: 0;
		.input-group {
			margin: 5px;
		}
		li {
			padding: 0;
			.multiselect-all {
				label {
					font-weight: 700;
				}
			}
			a {
				padding: 0;
				label {
					margin: 0;
					height: 100%;
					cursor: pointer;
					font-weight: 400;
					padding: 3px 20px 3px 40px;
					input[type=checkbox] {
						margin-bottom: 5px;
					}
				}
				label.radio {
					margin: 0;
				}
				label.checkbox {
					margin: 0;
				}
			}
		}
		li.multiselect-group {
			label {
				margin: 0;
				padding: 3px 20px 3px 20px;
				height: 100%;
				font-weight: 700;
			}
		}
		li.multiselect-group-clickable {
			label {
				cursor: pointer;
			}
		}
	}
	 
    @import url('https://fonts.googleapis.com/css?family=Quicksand:400,500,700&subset=latin-ext');

 
.multiSelect {
    width: 300px;
    position: relative;
}

.multiSelect *, .multiSelect *::before, .multiSelect *::after {
    box-sizing: border-box;
}

.multiSelect_dropdown {
    font-size: 14px;
    min-height: 35px;
    line-height: 35px;
    border-radius: 4px;
    box-shadow: none;
    outline: none;
    background-color: #fff;
    color: #444f5b;
    border: 1px solid #d9dbde;
    font-weight: 400;
    padding: 0.5px 13px;
    margin: 0;
    transition: .1s border-color ease-in-out;  
    cursor: pointer;
}

.multiSelect_dropdown.-hasValue {
    padding: 5px 30px 5px 5px;
    cursor: default;
}

.multiSelect_dropdown.-open {
    box-shadow: none;
    outline: none;
    padding: 4.5px 29.5px 4.5px 4.5px;
    border: 1.5px solid #4073FF;
}

.multiSelect_arrow::before,
.multiSelect_arrow::after {
    content: '';
    position: absolute;
    display: block;
    width: 2px;
    height: 8px;
    border-radius: 20px;
    border-bottom: 8px solid #99A3BA;
    top: 40%;
    transition: all .15s ease;
}

.multiSelect_arrow::before {
    right: 18px;
    -webkit-transform: rotate(-50deg);
    transform: rotate(-50deg);
}

.multiSelect_arrow::after {
    right: 13px;
    -webkit-transform: rotate(50deg);
    transform: rotate(50deg);
}

.multiSelect_list {
    margin: 0;
    margin-bottom: 25px;
    padding: 0;
    list-style: none;
    opacity: 0;
    visibility: hidden;
    position: absolute;
    max-height: calc(10 * 31px);
    top: 28px;
    left: 0;
    z-index: 9999;
    right: 0;
    background: #fff;
    border-radius: 4px;
    overflow-x: hidden;
    overflow-y: auto;
    -webkit-transform-origin: 0 0;
    transform-origin: 0 0;
    transition: opacity 0.1s ease, visibility 0.1s ease, -webkit-transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
    transition: opacity 0.1s ease, visibility 0.1s ease, transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
    transition: opacity 0.1s ease, visibility 0.1s ease, transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32), -webkit-transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
    -webkit-transform: scale(0.8) translate(0, 4px);
    transform: scale(0.8) translate(0, 4px);
    border: 1px solid #d9dbde;
    box-shadow: 0px 10px 20px 0px rgba(0, 0, 0, 0.12);
}

.multiSelect_option {
    margin: 0;
    padding: 0;
    opacity: 0;
    -webkit-transform: translate(6px, 0);
    transform: translate(6px, 0);
    transition: all .15s ease;
}

.multiSelect_option.-selected {
    display: none;
}

.multiSelect_option:hover .multiSelect_text {
    color: #fff;
    background: #4d84fe;
}

.multiSelect_text {
    cursor: pointer;
    display: block;
    padding: 5px 13px;
    color: #525c67;
    font-size: 14px;
    text-decoration: none;
    outline: none;
    position: relative;
    transition: all .15s ease;
}

.multiSelect_list.-open {
    opacity: 1;
    visibility: visible;
    -webkit-transform: scale(1) translate(0, 12px);
    transform: scale(1) translate(0, 12px);
    transition: opacity 0.15s ease, visibility 0.15s ease, -webkit-transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
    transition: opacity 0.15s ease, visibility 0.15s ease, transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
    transition: opacity 0.15s ease, visibility 0.15s ease, transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32), -webkit-transform 0.15s cubic-bezier(0.4, 0.6, 0.5, 1.32);
}

.multiSelect_list.-open + .multiSelect_arrow::before {
    -webkit-transform: rotate(-130deg);
    transform: rotate(-130deg);
}

.multiSelect_list.-open + .multiSelect_arrow::after {
    -webkit-transform: rotate(130deg);
    transform: rotate(130deg);
}

.multiSelect_list.-open .multiSelect_option {
    opacity: 1;
    -webkit-transform: translate(0, 0);
    transform: translate(0, 0);
}

.multiSelect_list.-open .multiSelect_option:nth-child(1) {
  transition-delay: 10ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(2) {
  transition-delay: 20ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(3) {
  transition-delay: 30ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(4) {
  transition-delay: 40ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(5) {
  transition-delay: 50ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(6) {
  transition-delay: 60ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(7) {
  transition-delay: 70ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(8) {
  transition-delay: 80ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(9) {
  transition-delay: 90ms;
}

.multiSelect_list.-open .multiSelect_option:nth-child(10) {
  transition-delay: 100ms;
}

.multiSelect_choice {
    background: rgba(77, 132, 254, 0.1);
    color: #444f5b;
    padding: 4px 8px;
    line-height: 17px;
    margin: 5px;
    display: inline-block;
    font-size: 13px;
    border-radius: 30px;
    cursor: pointer;
    font-weight: 500;
}

.multiSelect_deselect {
    width: 12px;
    height: 12px;
    display: inline-block;
    stroke: #b2bac3;
    stroke-width: 4px;
    margin-top: -1px;
    margin-left: 2px;
    vertical-align: middle;
}

.multiSelect_choice:hover .multiSelect_deselect {
    stroke: #a1a8b1;
}

.multiSelect_noselections {
    text-align: center;
    padding: 7px;
    color: #b2bac3;
    font-weight: 450;
    margin: 0;
}

.multiSelect_placeholder {
    position: absolute;
    left: 20px;
    font-size: 14px;
    top: 8px;
    padding: 0 4px;
    background-color: #fff;
    color: #b8bcbf;
    pointer-events: none;
    transition: all .1s ease;
}

.multiSelect_dropdown.-open + .multiSelect_placeholder,
.multiSelect_dropdown.-open.-hasValue + .multiSelect_placeholder {
    top: -11px;
    left: 17px;
    color: #4073FF;
    font-size: 13px;
}

.multiSelect_dropdown.-hasValue + .multiSelect_placeholder {
    top: -11px;
    left: 17px;
    color: #6e7277;
    font-size: 13px;
} 
    .paginate_button{
        margin:3px;
    } 
    .dt-buttons{
        margin-bottom:30px;
        
    }
    .buttons-html5,.buttons-print{
        font-size:10px;
        padding:5px;
    }
#products-table
{
     width: 200px;
    height: 400px;
    overflow:scroll;
}
</style>
 
 
 
<?
        if(p('durum')){
            
            $durum_sql=" and urunler.durum='".p('durum')."'";
        }
         $ekle_sql=$durum_sql;
         
         
         $row = "select *,a_satinal_talep.kayit_tarih as alis_tarih,tedarikci_firma.tedarikci_firma as tedarikci_firma_text,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 
        left join markalar on urunler.marka=markalar.id  
        left join modeller on urunler.model=modeller.id 
        left join hafiza on urunler.hafiza=hafiza.id
        left join renk on urunler.renk=renk.id
        left join teslim_nedeni on urunler.teslim_nedeni=teslim_nedeni.id
        left join turler on urunler.cihaz_turu=turler.id
        left join durum on urunler.durum=durum.id
        left join tedarikci_firma on urunler.tedarikci_firma=tedarikci_firma.id
        left join grade_tipleri on urunler.grade_tipi=grade_tipleri.id
        left join a_satinal_talep on urunler.satinalma_id=a_satinal_talep.id
        where urunler.id<>0 and urunler.sil=0  $ekle_sql order by urunler.id desc ";
		$row = $func->query($row); 
		$row=$row->fetchAll();


?>
               

                <div class="card">
                  <div class="card-body"  style="height: 1200px;height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px"> 
 
           
                                    <table id="myTable" class="table table-responsive">
                                        <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Alış Tarihi</th> 
                                            <th>Cihaz</th> 
                                            <th>Teslim Nedeni</th>  
                                            <th>IMEI</th> 
                                            <th>Seri No</th> 
                                            <th>Durum</th> 
                                            <th>Grade</th> 
                                            <th>Parça Maliyet</th>
                                            <th>İşçilik</th>
                                            <th>Alış</th>
                                            <th>Tedarikci Firma</th>
                                            <th>Rezerve</th>
                                            <th>Sipariş ID</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        <? foreach($row as $rs){?>
                                        <tr>
                                            <td><?=$rs->isemri?></td>
                                            <td><?=$rs->alis_tarih?></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->imei?></td>
                                            <td><?=$rs->seri_no?></td>
                                            <td><?=$rs->durum_text?></td>
                                            <td><?=$rs->grade_text?></td> 
                                            <td><?=$rs->iscilik?></td> 
                                            <td><?=$rs->asil_maliyet?></td> 
                                            <td><?=$rs->depo_alis_fiyati?></td> 
                                            <td><?=$rs->tedarikci_firma_text?></td> 
                                            <td><?=$rs->rezerve_id?></td> 
                                            <td><?=$rs->siparis_id?></td> 
                                        </tr>
                                        <?}?>
                                        </tbody> 
                                    </table>

</div>
</div>
  


































</div>
 
 
 
  
<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';
?>