<? 
include 'header.php';
?>



<style>
th,td{
    text-align:center;
}

.tr_background:hover{
    background:#7c99d33b;    
}
    .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('filtrele')==1){   
     
     
    if(p('durum')==1){
        $mesai=" and mesai=0  ";
    }elseif(p('durum')==2 ){ 
         $mesai=" and mesai=1  ";
    } 
    
    
    
if(p('aylik')){
     
    $ay=p('aylik');  
     
    $aylik_sql=" and  ay='".p('aylik')."' and yil='".date('Y')."' ";    
}

     

  $row = "select * from a_prim_tablosu where id<>0 and uye_id<>3315 and uye_id<>107 $mesai $aylik_sql ";
$row=$func->query($row);
$row=$row->fetchAll();
 
 }
 
 
?>



<div class="page-wrapper">
        <!-- Page header -->
        <div class="page-header d-print-none">
          <div class="container-xl">
            <div class="row g-2 align-items-center">
              <div class="col">
                <h2 class="page-title">
                  Teknikservis Prim Sistemi
                </h2>
              </div>
            </div>
          </div>
        </div>
        <!-- Page body -->
        <div class="page-body">
          <div class="container-xl">



                     <form class="card" action="" method="post">
                        <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">Aylık</label>
                                <select name="aylik" class="form-control" required>
                                    <option hidden>Hızlı Tarih</option>
                                    <? 
                                    $aylar=array('Ocak','Şubat','Mart','Nisan','Mayıs','Haziran','Temmuz','Ağustos','Eylül','Ekim','Kasım','Aralık');
                                    for($i=0;$i<=11;$i++){?>
                                    <option value="<?=$i+1?>" <? if(p('aylik')==$i+1){ echo "selected";}?>><?=$aylar[$i]?> <?=date('Y')?></option>
                                    <?}?>
                                </select>
                              </div>
                            </div>  
                            <div class="col-sm-6 col-md-3">
                              <div class="mb-3">
                                <label class="form-label">Durum</label>
                                <select name="durum" class="form-control" required>
                	             <option hidden>Seçiniz</option> 
                	               <option value="1" <? if(p('durum')==1 or !p('durum')){ echo "selected"; }?>>Çalışma Saatleri</option>
                	               <option value="2" <? if(p('durum')==2 ){ echo "selected"; }?>>Mesai</option>
                	         </select>
                              </div>
                            </div>
                          </div> 
                          
                           
                        </div>
                        <div class="card-footer text-end"> 
                          <button type="submit" class="btn btn-primary" value="1" name="filtrele">Filtrele</button>
                        </div>
    </form>
               
 
         
   
<? if(p('filtrele')==1){?> 




                <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>Personel</th> 
                                              <th>BuybackT</th>
                                              <th>BuybackG</th>
                                              <th>Onarım</th>
                                              <th>Yenileme<br>Yenileme + Onarım</th>
                                              <th>Bayi Yenileme</th> 
                                              <th>Bayi Onarım+Yenileme</th> 
                                              <th>Toplam Adet</th>
                                              <th>Geri Dönüş Adeti</th>
                                              <th>Geri Dönüş Oranı(%)</th>
                                              <th>BuybackT</th>
                                              <th>BuybackG</th>
                                              <th>Onarım</th>
                                              <th>Yenileme</th> 
                                              <th>Bayi Yenileme</th> 
                                              <th>Bayi Onarım+Yenileme</th> 
                                              <th>Toplam Prim</th>
                                              <th>Geri Dönüş Kesintisi</th>
                                              <th>Havuz Kesintisi(25%)</th>
                                              <th>Hesaplanan Prim</th>
                                              <th>Nihani Prim</th> 
                                        </tr>
                                        </thead>
                                        <tbody>
                                            
                                        <? foreach($row as $rs){?>
                                        
                                        <tr class="tr_background">  
                                        
                                              <td><?=$func->uyegetir($rs->uye_id)?></td> 
                                              <td><?=$rs->BuybackT?></td>
                                              <td><?=$rs->BuybackG?></td>
                                              <td><?=$rs->Onarim?></td>
                                              <td><?=$rs->Onarim_Yenileme?></td>
                                              <td><?=$rs->Bayi_Yenileme?></td>
                                              <td><?=$rs->Bayi_Yenileme_Onarim?></td> 
                                              <td><?=$rs->Toplam_Adet?></td> 
                                              <td><?=$rs->Geri_Dönüs_Adet?></td> 
                                              <td><?=$rs->Geri_Donus_Orani?></td> 
                                              <td><?=$rs->BuybackT_Tutar?></td> 
                                              <td><?=$rs->BuybackG_Tutar?></td> 
                                              <td><?=$rs->Onarim_Tutar?></td> 
                                              <td><?=$rs->Yenileme_Tutar?></td> 
                                              <td><?=$rs->Bayi_Yenileme_Tutar?></td> 
                                              <td><?=$rs->Bayi_Yenileme_Onarim_Tutar?></td> 
                                              <td><?=$rs->Toplam_Prim?></td> 
                                              <td><?=$rs->Geri_Donus_Kesintisi?></td> 
                                              <td><?=$rs->Havuz_Kesintisi?></td> 
                                              <td><?=$rs->Hesaplanan_Prim?></td> 
                                              <td><?=$rs->Nihai_Prim?></td> 
                                              
                                              
                                              
                                        </tr>
                                        <?}?>
                                        
                                        
                                        </tbody> 
                                    </table>

</div>
</div>


<?}?>  

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