File: //home/ekspardev/.trash/data-table-depolar.php
<? 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;
}
}
}
</style>
<style>
@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;
}
</style>
<div class="col-md-6 col-lg-3" style="width:99%;height:50px;">
<div class="page-body">
<div class="container-xl">
<div class="row row-deck row-cards">
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=89";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">HAM DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=89','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=95";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">2. EL DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=95','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=88";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">TEŞHİR DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=88','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=85";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">SIFIR DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=85','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=86";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">BUYBACK YENİLENMİŞ DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=86','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=93";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">NOTEBOOK DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=93','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=87";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">HURDA DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=87','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<?
$row = "select sum(depo_alis_fiyati) as total_alis_fiyati,count(id) as adet from urunler where sil=0 and durum=94";
$row = $func->query($row);
$row=$row->fetch();
$total_maliyet=$total_maliyet+$row->total_alis_fiyati;
$total_adet=$total_adet+$row->adet;
?>
<div class="col-sm-6 col-lg-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="subheader">HURDA DEPO</div>
<div class="ms-auto lh-1">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-depolar-detay.php?durum=94','mywindow','width=800,height=400')" >
<svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-file-text" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
<path d="M14 3v4a1 1 0 0 0 1 1h4"></path>
<path d="M17 21h-10a2 2 0 0 1 -2 -2v-14a2 2 0 0 1 2 -2h7l5 5v11a2 2 0 0 1 -2 2z"></path>
<path d="M9 9l1 0"></path>
<path d="M9 13l6 0"></path>
<path d="M9 17l6 0"></path>
</svg>
</a></div>
</div>
</div>
<div class="h1 mb-3"><?=$row->adet?> ADET</div>
<div class="d-flex mb-2">Alış Maliyeti: <?=trfiyat($row->total_alis_fiyati)?></div>
</div>
</div>
</div>
<div class="col-12">
<div class="row row-cards">
<div class="col-sm-6 col-lg-6">
<div class="card card-sm">
<div class="card-body">
<div class="row align-items-center">
<div class="col-auto">
<span class="bg-primary text-white avatar"><!-- Download SVG icon from http://tabler-icons.io/i/currency-dollar -->
<svg xmlns="http://www.w3.org/2000/svg" class="icon" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round"><path stroke="none" d="M0 0h24v24H0z" fill="none"/><path d="M16.7 8a3 3 0 0 0 -2.7 -2h-4a3 3 0 0 0 0 6h4a3 3 0 0 1 0 6h-4a3 3 0 0 1 -2.7 -2" /><path d="M12 3v3m0 12v3" /></svg>
</span>
</div>
<div class="col">
<div class="font-weight-medium">
<?=trfiyat($total_maliyet)?>
</div>
<div class="text-muted">
MALİYET
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-6">
<div class="card card-sm">
<div class="card-body">
<div class="row align-items-center">
<div class="col-auto">
<span class="bg-green text-white avatar"><!-- Download SVG icon from http://tabler-icons.io/i/shopping-cart -->
<svg xmlns="http://www.w3.org/2000/svg" class="icon" width="24" height="24" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round"><path stroke="none" d="M0 0h24v24H0z" fill="none"/><path d="M6 19m-2 0a2 2 0 1 0 4 0a2 2 0 1 0 -4 0" /><path d="M17 19m-2 0a2 2 0 1 0 4 0a2 2 0 1 0 -4 0" /><path d="M17 17h-11v-14h-2" /><path d="M6 5l14 1l-1 7h-13" /></svg>
</span>
</div>
<div class="col">
<div class="font-weight-medium">
<?=$total_adet?>
</div>
<div class="text-muted">
ADET
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<? include 'footer.php'; ?>