File: //home/ekspardev/.trash/data-table-karlilik.php
<?
include 'header.php';
if(p('filtrele')==1){
if(p('baslangic')){
$baslangic_sql=" and fatura_giris_tarih>=".p('baslangic');
$taksitlisatis_baslangic_sql=" and mst_odeme_yapti_tarih>=".p('baslangic');
$bayisiparis_baslangic_sql=" and bayi_siparis.fatura_kesildi_tarih>=".p('baslangic');
}
if(p('bitis')){
$bitis_sql=" and fatura_giris_tarih<=".p('bitis');
$taksitlisatis_bitis_sql=" and mst_odeme_yapti_tarih<=".p('baslangic');
$bayisiparis_bitis_sql=" and bayi_siparis.fatura_kesildi_tarih<=".p('baslangic');
}
if(p('aylik')){
$takvim = CAL_GREGORIAN;
$ay=p('aylik');
$yil=date('Y');
$gunSayisi=cal_days_in_month($takvim, $ay,$yil);
$baslangic=date('Y')."-".p('aylik')."-"."01";
$bitis=date('Y')."-".p('aylik')."-".$gunSayisi;
$aylik_sql=" and fatura_giris_tarih>='".$baslangic." 00:00:00' and fatura_giris_tarih<='".$bitis." 00:00:00' ";
$aylik_taksilisatis_sql=" and mst_odeme_yapti_tarih>='".$baslangic." 00:00:00' and mst_odeme_yapti_tarih<='".$bitis." 00:00:00' ";
$aylik_bayi_siparis_sql=" and bayi_siparis.fatura_kesildi_tarih>='".$baslangic." 00:00:00' and bayi_siparis.fatura_kesildi_tarih<='".$bitis." 00:00:00' ";
}
$ekle_sql=$baslangic_sql.$bitis_sql.$aylik_sql;
$total_ciro=0;
$total_maliyet=0;
//online satış
$s1="select sum(buyback_satis_onaylanan_fiyat) as total_satis,sum((pazaryeri_komisyon*buyback_satis_onaylanan_fiyat)/100) as total_pazaryeri_komisyon, sum(asil_maliyet) as total_maliyet, sum(dis_servis_ucreti) as total_dis_servis_ucreti,sum(iscilik) as total_iscilik, sum(depo_alis_fiyati) as total_alis_fiyati from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=5 or teslim_nedeni=7 or teslim_nedeni=8 or teslim_nedeni=9 or teslim_nedeni=10) and satinalma_id<>0 $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$onlinesatis_ciro=$t->total_satis;
$onlinesatis_maliyet=$t->total_maliyet+$rs->total_iscilik+$rs->total_dis_servis_ucreti;
$onlinesatis_maliyet=($onlinesatis_maliyet*1.18)+$t->total_alis_fiyati + $t->total_pazaryeri_komisyon;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=5 or teslim_nedeni=7 or teslim_nedeni=8 or teslim_nedeni=9 or teslim_nedeni=10) and satinalma_id<>0 $ekle_sql";
$q = $func->query($s1);
$onlinesatis_adet=$q->rowCount();
$total_ciro=$total_ciro+$onlinesatis_ciro;
$total_maliyet=$total_maliyet+$onlinesatis_maliyet;
//yenileme
$s1="select sum(onaylanan_fiyat) as total_satis,sum(((asil_maliyet-300)+dis_servis_ucreti)*1.18) as total_maliyet from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=3 or teslim_nedeni=12 or teslim_nedeni=14 or teslim_nedeni=15) $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$yenileme_ciro=$t->total_satis;
$yenileme_maliyet=$t->total_maliyet;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=3 or teslim_nedeni=12 or teslim_nedeni=14 or teslim_nedeni=15) $ekle_sql";
$q = $func->query($s1);
$yenileme_adet=$q->rowCount();
$total_ciro=$total_ciro+$yenileme_ciro;
$total_maliyet=$total_maliyet+$yenileme_maliyet;
//onarım
$s1="select sum(onaylanan_fiyat+iscilik) as total_satis,sum((asil_maliyet*dis_servis_ucreti)*1.18) as total_maliyet from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and teslim_nedeni=1 $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$onarim_ciro=$t->total_satis;
$onarim_maliyet=$t->total_maliyet;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and teslim_nedeni=1 $ekle_sql";
$q = $func->query($s1);
$onarim_adet=$q->rowCount();
$total_ciro=$total_ciro+$onarim_ciro;
$total_maliyet=$total_maliyet+$onarim_maliyet;
//bayi sipariş satış
$s1="select sum(fatura_edilen_tutar) as total_satis, sum(asil_maliyet) as total_maliyet, sum(dis_servis_ucreti) as total_dis_servis_ucreti,sum(iscilik) as total_iscilik, sum(depo_alis_fiyati) as total_alis_fiyati from urunler join bayi_siparis on urunler.siparis_id=bayi_siparis.id where urunler.id<>0 and sil=0 and durum=150 and bayi_siparis.fatura_no!='' and siparis_id<>0 $aylik_bayi_siparis_sql";
$q = $func->query($s1);
$t = $q->fetch();
$bayisiparis_ciro=$t->total_satis;
$bayisiparis_maliyet=$t->total_maliyet+$t->total_dis_servis_ucreti+$t->total_iscilik;
$bayisiparis_maliyet=($bayisiparis_maliyet*1.18)+$t->total_alis_fiyati ;
$s1="select * from urunler join bayi_siparis on urunler.siparis_id=bayi_siparis.id where urunler.id<>0 and sil=0 and durum=150 and bayi_siparis.fatura_no!='' and siparis_id<>0 $aylik_bayi_siparis_sql ";
$q = $func->query($s1);
$bayisiparis_adet=$q->rowCount();
$total_ciro=$total_ciro+$bayisiparis_ciro;
$total_maliyet=$total_maliyet+$bayisiparis_maliyet;
//bayi taksitli satıs
$taksitlisatis = "select sum(mst_alinacak_tutar) as taksitlisatis_ciro,count(*) as taksitli_satis_adet from bayi_satislari right join urunler on bayi_satislari.bsatis_id=urunler.bayisatis_id where bsatis_id<>0 and sil=0 and mst_odeme_yapti<>0 $taksitlisatis_baslangic_sql $taksitlisatis_bitis_sql $aylik_taksilisatis_sql";
$taksitlisatis = $func->query($taksitlisatis);
$taksitlisatis = $taksitlisatis->fetch();
$taksitlisatis_ciro=$taksitlisatis->taksitlisatis_ciro;
$taksitlisatis_adet=$taksitlisatis->taksitli_satis_adet;
$taksitlisatis_maliyet=0;
$taksitlisatis_kar=$taksitlisatis_ciro*0.02;
$total_ciro=$total_ciro+$taksitlisatis_ciro;
$total_maliyet=$total_maliyet+$taksitlisatis_maliyet;
//yedekparca
$yedekparca= "select sum(tutar) as alis,sum(depo_yedekparca.depo_satis_fiyati*1.18) as satis,count(*) as adet from urunler right join depo_yedekparca on urunler.id=depo_yedekparca.urun_id where kullanildi=1 and urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and fatura_no!='' $ekle_sql";
$yedekparca = $func->query($yedekparca);
$yedekparca = $yedekparca->fetch();
$yedekparca_ciro=$yedekparca->satis;
$yedekparca_maliyet=$yedekparca->alis;
$yedekparca_adet=$yedekparca->adet;
$yedekparca_kar= $yedekparca_ciro-$yedekparca_maliyet;
$s8= "select sum(total_maliyet) as asil_maliyet,sum(onaylanan_fiyat) as total_onarim_bedeli,count(*) as adet from urunler where id<>0 and sil=0 and garanti=1 and dis_teknikservis_id!='' and durum=150 $ekle_sql";
$q = $func->query($s8);
$t = $q->fetch();
$dts_garantidahili_maliyet=$t->asil_maliyet;
$dts_garantidahili_ciro=$t->total_onarim_bedeli;
$dts_garantidahili_adet=$t->adet;
$dts_garantidahili_kar=$dts_garantidahili_ciro-$dts_garantidahili_maliyet;
$total_ciro=$total_ciro+$dts_garantidahili_ciro;
$total_maliyet=$total_maliyet+$dts_garantidahili_maliyet;
$s8= "select sum(dis_servis_ucreti) as asil_maliyet,sum(onaylanan_fiyat) as total_onarim_bedeli,count(*) as adet from urunler where id<>0 and sil=0 and garanti<>1 and dis_teknikservis_id!='' and durum=150 and satinalma_id=0 $ekle_sql";
$q = $func->query($s8);
$t = $q->fetch();
$dts_garantiharici_maliyet=$t->asil_maliyet;
$dts_garantiharici_ciro=$t->total_onarim_bedeli;
$dts_garantiharici_adet=$t->adet;
$dts_garantiharici_kar=$dts_garantiharici_ciro-$dts_garantiharici_maliyet;
$total_ciro=$total_ciro+$dts_garantiharici_ciro;
$total_maliyet=$total_maliyet+$dts_garantiharici_maliyet;
}
?>
<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>
<div class="col-md-6 col-lg-3" style="width:99%;height:50px;">
<form class="card" action="" method="post">
<div class="card-body" style="float:left">
<h3 class="card-title">Fitrele</h3>
<div class="row row-cards"style=" width:100%">
<div class="col-sm-6 col-md-3" style="float:left;">
<div class="mb-3">
<label class="form-label">Aylık</label>
<select name="aylik" class="form-control">
<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 class=""style="float:right" >
<button type="submit" class="btn btn-primary"style="float:right" value="1" name="filtrele">Filtrele</button>
</div>
</div>
</div>
</div>
</div>
</form>
<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>
<? if(p('filtrele')==1){ ?>
<div class="page-body">
<div class="container-l">
<div class="row row-deck row-cards">
<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">Online Satış(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($onlinesatis_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($onlinesatis_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$onlinesatis_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($onlinesatis_ciro-$onlinesatis_maliyet)?> </div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=1','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$onlinesatis_adet?>/500
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$onlinesatis_adet*100/500?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">YENİLEME(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($yenileme_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($yenileme_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$yenileme_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($yenileme_ciro-$yenileme_maliyet)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=2','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$yenileme_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$yenileme_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">ONARIM(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($onarim_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($onarim_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$onarim_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($onarim_ciro-$onarim_maliyet)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=3','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$onarim_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$onarim_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">BAYİ SATIŞ(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($bayisiparis_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($bayisiparis_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$bayisiparis_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($bayisiparis_ciro-$bayisiparis_maliyet)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=4','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$bayisiparis_adet?>/500
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$bayisiparis_adet*100/500?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">BAYİ TAKSİTLİ SATIŞ(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($taksitlisatis_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($taksitlisatis_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$taksitlisatis_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($taksitlisatis_kar)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=5','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$taksitlisatis_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$taksitlisatis_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">YEDEKPARÇA (Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($yedekparca_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($yedekparca_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$yedekparca_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($yedekparca_kar)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=6','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$yedekparca_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$yedekparca_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">DTS GARANTİ DAHİLİ(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($dts_garantidahili_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($dts_garantidahili_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$dts_garantidahili_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($dts_garantidahili_kar)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=7','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$dts_garantidahili_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$dts_garantidahili_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<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">DTS GARANTİ HARİCİ(Kar)</div>
<div class="ms-auto lh-1">
<div class="dropdown">
<a class="dropdown-toggle text-muted" href="#" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"></a>
<div class="dropdown-menu dropdown-menu-end">
<a class="dropdown-item active" href="#">Ciro: <?=trfiyat($dts_garantiharici_ciro)?></a>
<a class="dropdown-item" href="#">Maliyet: <?=trfiyat($dts_garantiharici_maliyet)?></a>
<a class="dropdown-item" href="#"><?=$dts_garantiharici_adet?> Adet</a>
</div>
</div>
</div>
</div>
<div class="h1 mb-3"><?=trfiyat($dts_garantiharici_kar)?></div>
<div class="d-flex mb-2">
<div><a href="#" onClick="window.open('https://rapor.garantili.com.tr/rapor/panel/data-table-karlilik-detay.php?aylik=<?=p('aylik')?>&filtrele=8','mywindow','width=800,height=400')" >Detay</a></div>
<div class="ms-auto">
<span class="text-green d-inline-flex align-items-center lh-1">
<?=$dts_garantiharici_adet?>
<svg xmlns="http://www.w3.org/2000/svg" class="icon ms-1" 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="M3 17l6 -6l4 4l8 -8" /><path d="M14 7l7 0l0 7" /></svg>
</span>
</div>
</div>
<div class="progress progress-sm">
<div class="progress-bar bg-primary" style="width: <?=$dts_garantiharici_adet?>%" role="progressbar" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100" aria-label="75% Complete">
<span class="visually-hidden">75% Complete</span>
</div>
</div>
</div>
</div>
</div>
<div class="col-12">
<div class="row row-cards">
<div class="col-sm-6 col-lg-4">
<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_ciro)?>
</div>
<div class="text-muted">
CİRO
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<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">
<?=trfiyat($total_maliyet)?>
</div>
<div class="text-muted">
MALİYET
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-sm-6 col-lg-4">
<div class="card card-sm">
<div class="card-body">
<div class="row align-items-center">
<div class="col-auto">
<span class="text-white avatar"><!-- Download SVG icon from http://tabler-icons.io/i/brand-twitter -->
<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_ciro-$total_maliyet)?>
</div>
<div class="text-muted">
KAR
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<div id="chart-combination"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?}?>
</div>
<?
/*
$total_maliyet=0;
$total_ciro=0;
$aylar_TR = array("Ocak","Şubat","Mart","Nisan","Mayıs","Haziran","Temmuz","Ağustos","Eylül","Ekim","Kasım","Aralık");
for($i=1;$i<=p('aylik');$i++){
$takvim = CAL_GREGORIAN;
$ay=$i;
$yil=date('Y');
$gunSayisi=cal_days_in_month($takvim, $ay,$yil);
echo $baslangic=date('Y')."-".$i."-"."01";
echo $bitis=date('Y')."-".$i."-".$gunSayisi;
$aylik_sql=" and fatura_giris_tarih>='".$baslangic." 00:00:00' and fatura_giris_tarih<='".$bitis." 00:00:00' ";
$aylik_taksilisatis_sql=" and mst_odeme_yapti_tarih>='".$baslangic." 00:00:00' and mst_odeme_yapti_tarih<='".$bitis." 00:00:00' ";
$aylik_bayi_siparis_sql=" and bayi_siparis.fatura_kesildi_tarih>='".$baslangic." 00:00:00' and bayi_siparis.fatura_kesildi_tarih<='".$bitis." 00:00:00' ";
$ekle_sql=$baslangic_sql.$bitis_sql.$aylik_sql;
$total_maliyet=0;
$total_ciro=0;
//online satış
$s1="select sum(buyback_satis_onaylanan_fiyat) as total_satis,sum((total_maliyet*1.18)+depo_alis_fiyati+dis_servis_ucreti) as total_maliyet from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=5 or teslim_nedeni=7 or teslim_nedeni=8 or teslim_nedeni=9 or teslim_nedeni=10) $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$onlinesatis_ciro=$t->total_satis;
$onlinesatis_maliyet=$t->total_maliyet;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=5 or teslim_nedeni=7 or teslim_nedeni=8 or teslim_nedeni=9 or teslim_nedeni=10) $ekle_sql";
$q = $func->query($s1);
$onlinesatis_adet=$q->rowCount();
$total_ciro=$total_ciro+$onlinesatis_ciro;
$total_maliyet=$total_maliyet+$onlinesatis_maliyet;
//yenileme
$s1="select sum(onaylanan_fiyat) as total_satis,sum((total_maliyet-300)*1.18+dis_servis_ucreti) as total_maliyet from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=3 or teslim_nedeni=12 or teslim_nedeni=14 or teslim_nedeni=15) $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$yenileme_ciro=$t->total_satis;
$yenileme_maliyet=$t->total_maliyet;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and (teslim_nedeni=3 or teslim_nedeni=12 or teslim_nedeni=14 or teslim_nedeni=15) $ekle_sql";
$q = $func->query($s1);
$yenileme_adet=$q->rowCount();
$total_ciro=$total_ciro+$yenileme_ciro;
$total_maliyet=$total_maliyet+$yenileme_maliyet;
//onarım
$s1="select sum(onaylanan_fiyat+iscilik) as total_satis,sum(total_maliyet*1.18+dis_servis_ucreti) as total_maliyet from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and teslim_nedeni=1 $ekle_sql";
$q = $func->query($s1);
$t = $q->fetch();
$onarim_ciro=$t->total_satis;
$onarim_maliyet=$t->total_maliyet;
$s1="select id from urunler where id<>0 and sil=0 and durum=150 and fatura_no!='' and siparis_id=0 and teslim_nedeni=1 $ekle_sql";
$q = $func->query($s1);
$onarim_adet=$q->rowCount();
$total_ciro=$total_ciro+$onarim_ciro;
$total_maliyet=$total_maliyet+$onarim_maliyet;
//bayi sipariş satış
$s1="select sum(fatura_edilen_tutar) as total_satis,sum((total_maliyet*1.18)+depo_alis_fiyati+dis_servis_ucreti) as total_maliyet from urunler join bayi_siparis on urunler.siparis_id=bayi_siparis.id where urunler.id<>0 and sil=0 and durum=150 and bayi_siparis.fatura_no!='' and siparis_id<>0 $aylik_bayi_siparis_sql";
$q = $func->query($s1);
$t = $q->fetch();
$bayisiparis_ciro=$t->total_satis;
$bayisiparis_maliyet=$t->total_maliyet;
$s1="select * from urunler join bayi_siparis on urunler.siparis_id=bayi_siparis.id where urunler.id<>0 and sil=0 and durum=150 and bayi_siparis.fatura_no!='' and siparis_id<>0 $aylik_bayi_siparis_sql ";
$q = $func->query($s1);
$bayisiparis_adet=$q->rowCount();
$total_ciro=$total_ciro+$bayisiparis_ciro;
$total_maliyet=$total_maliyet+$bayisiparis_maliyet;
//bayi taksitli satıs
$taksitlisatis = "select sum(mst_alinacak_tutar) as taksitlisatis_ciro,count(*) as taksitli_satis_adet from bayi_satislari right join urunler on bayi_satislari.bsatis_id=urunler.bayisatis_id where bsatis_id<>0 and sil=0 and mst_odeme_yapti<>0 $taksitlisatis_baslangic_sql $taksitlisatis_bitis_sql $aylik_taksilisatis_sql";
$taksitlisatis = $func->query($taksitlisatis);
$taksitlisatis = $taksitlisatis->fetch();
$taksitlisatis_ciro=$taksitlisatis->taksitlisatis_ciro;
$taksitlisatis_adet=$taksitlisatis->taksitli_satis_adet;
$taksitlisatis_maliyet=0;
$taksitlisatis_kar=$taksitlisatis_ciro*0.02;
$total_ciro=$total_ciro+$taksitlisatis_ciro;
$total_maliyet=$total_maliyet+$taksitlisatis_maliyet;
//yedekparca
$yedekparca= "select sum(tutar) as alis,sum(depo_yedekparca.depo_satis_fiyati*1.18) as satis,count(*) as adet from urunler right join depo_yedekparca on urunler.id=depo_yedekparca.urun_id where kullanildi=1 and urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and fatura_no!='' $ekle_sql";
$yedekparca = $func->query($yedekparca);
$yedekparca = $yedekparca->fetch();
$yedekparca_ciro=$yedekparca->satis;
$yedekparca_maliyet=$yedekparca->alis;
$yedekparca_adet=$yedekparca->adet;
$yedekparca_kar= $yedekparca_ciro-$yedekparca_maliyet;
$s8= "select sum(total_maliyet) as toplam_maliyet,sum(onaylanan_fiyat) as total_onarim_bedeli,count(*) as adet from urunler where id<>0 and sil=0 and garanti=1 and dis_teknikservis_id!='' and durum=150 $ekle_sql";
$q = $func->query($s8);
$t = $q->fetch();
$dts_garantidahili_maliyet=$t->toplam_maliyet;
$dts_garantidahili_ciro=$t->total_onarim_bedeli;
$dts_garantidahili_adet=$t->adet;
$dts_garantidahili_kar=$dts_garantidahili_ciro-$dts_garantidahili_maliyet;
$total_ciro=$total_ciro+$dts_garantidahili_ciro;
$total_maliyet=$total_maliyet+$dts_garantidahili_maliyet;
$s8= "select sum(dis_servis_ucreti) as toplam_maliyet,sum(onaylanan_fiyat) as total_onarim_bedeli,count(*) as adet from urunler where id<>0 and sil=0 and garanti<>1 and dis_teknikservis_id!='' and durum=150 and satinalma_id=0 $ekle_sql";
$q = $func->query($s8);
$t = $q->fetch();
$dts_garantiharici_maliyet=$t->toplam_maliyet;
$dts_garantiharici_ciro=$t->total_onarim_bedeli;
$dts_garantiharici_adet=$t->adet;
$dts_garantiharici_kar=$dts_garantiharici_ciro-$dts_garantiharici_maliyet;
$total_ciro=$total_ciro+$dts_garantiharici_ciro;
$total_maliyet=$total_maliyet+$dts_garantiharici_maliyet;
echo $ay1_ciro=$ay1_ciro.number_format($total_ciro, 2, '.', '').",";
echo $ay1_kar=$ay1_kar.number_format(($total_ciro-$total_maliyet), 2, '.', '').",";
$ay_text=$ay_text.'"'.$aylar_TR[$i-1].'",';
}
//ay 2
?>
<script>
// @formatter:off
document.addEventListener("DOMContentLoaded", function () {
window.ApexCharts && (new ApexCharts(document.getElementById('chart-combination'), {
chart: {
type: "bar",
fontFamily: 'inherit',
height: 240,
parentHeightOffset: 0,
toolbar: {
show: false,
},
animations: {
enabled: false
},
},
plotOptions: {
bar: {
columnWidth: '50%',
}
},
dataLabels: {
enabled: false,
},
fill: {
opacity: 1,
},
series: [{
name: "Ciro",
data: [<?=$ay1_ciro?>]
},{
name: "Kar",
data: [<?=$ay1_kar?>]
}],
tooltip: {
theme: 'dark'
},
grid: {
padding: {
top: -20,
right: 0,
left: -4,
bottom: -4
},
strokeDashArray: 4,
},
xaxis: {
labels: {
padding: 0,
},
tooltip: {
enabled: false
},
axisBorder: {
show: false,
},
categories: [<?=$ay_text?>],
},
yaxis: {
labels: {
padding: 4
},
},
colors: [ tabler.getColor("pink"),tabler.getColor("green")],
legend: {
show: false,
},
})).render();
});
// @formatter:on
</script>
<?
**/
include 'footer.php';
?>