File: /home/ekspardev/.trash/data-table-karlilik-detay.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;
}
}
}
@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('baslangic')){
$baslangic_sql=" and fatura_giris_tarih>=".p('baslangic');
}
if(p('bitis')){
$bitis_sql=" and fatura_giris_tarih<=".p('bitis');
}
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' ";
}
$ekle_sql=$baslangic_sql.$bitis_sql.$aylik_sql;
$row = "select *, 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,pazaryeri.pazaryeri as pazaryeri_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 grade_tipleri on urunler.grade_tipi=grade_tipleri.id
left join tedarikci_firma on urunler.tedarikci_firma=tedarikci_firma.id
left join pazaryeri on urunler.f_pazaryeri=pazaryeri.id
where urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and siparis_id=0 and (urunler.teslim_nedeni=5 or urunler.teslim_nedeni=7 or urunler.teslim_nedeni=8 or urunler.teslim_nedeni=9 or urunler.teslim_nedeni=10) $ekle_sql order by urunler.id desc ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Tedarikçi Firma</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Durum</th>
<th>Grade</th>
<th>Fatura No</th>
<th>Fatura Tarih</th>
<th>Depo Alış Fiyatı</th>
<th>Parça Maliyet</th>
<th>Pazaryeri</th>
<th>Pazaryeri Komisyon</th>
<th>Depo Satış Fiyatı</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? 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->tedarikci_firma_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->durum_text?></td>
<td><?=$rs->grade_text?></td>
<td><?=$rs->fatura_no?></td>
<td><?=$rs->fatura_giris_tarih?></td>
<td><?=$rs->depo_alis_fiyati?></td>
<td><?=$rs->asil_maliyet*1.18?></td>
<td><?=$rs->pazaryeri_text?></td>
<td><?=$rs->pazaryeri_komisyon?></td>
<td><?=$rs->buyback_satis_onaylanan_fiyat?></td>
<td><?=$rs->buyback_satis_onaylanan_fiyat-$rs->depo_alis_fiyati-($rs->asil_maliyet*1.18)-$rs->dis_servis_ucreti-($rs->buyback_satis_onaylanan_fiyat*$rs->pazaryeri_komisyon/100)?></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
<?}?>
<?if(p('filtrele')==2){
if(p('baslangic')){
$baslangic_sql=" and fatura_giris_tarih>=".p('baslangic');
}
if(p('bitis')){
$bitis_sql=" and fatura_giris_tarih<=".p('bitis');
}
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' ";
}
$ekle_sql=$baslangic_sql.$bitis_sql.$aylik_sql;
$row = "select *, uyeler.unvan as unvan_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,pazaryeri.pazaryeri as pazaryeri_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 grade_tipleri on urunler.grade_tipi=grade_tipleri.id
left join uyeler on urunler.bayi_id=uyeler.id
left join pazaryeri on urunler.f_pazaryeri=pazaryeri.id
where urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and siparis_id=0 and fatura_no!='' and (urunler.teslim_nedeni=5 or urunler.teslim_nedeni=3 or urunler.teslim_nedeni=12 or urunler.teslim_nedeni=14 or urunler.teslim_nedeni=15) $ekle_sql order by urunler.id desc ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Bayi</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Durum</th>
<th>Grade</th>
<th>Fatura No</th>
<th>Fatura Tarih</th>
<th>İşçillik</th>
<th>Parça Maliyet</th>
<th>Müşteriden Alınan Tutar</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? 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->unvan_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->durum_text?></td>
<td><?=$rs->grade_text?></td>
<td><?=$rs->fatura_no?></td>
<td><?=$rs->fatura_giris_tarih?></td>
<td><?=$rs->iscilik?></td>
<td><?=$rs->asil_maliyet-300?></td>
<td><?=$rs->onaylanan_fiyat?></td>
<td><?=$rs->onaylanan_fiyat-((($rs->asil_maliyet-300)+$rs->dis_servis_ucreti)*1.18)?></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
<?}?>
<?if(p('filtrele')==3){
if(p('baslangic')){
$baslangic_sql=" and fatura_giris_tarih>=".p('baslangic');
}
if(p('bitis')){
$bitis_sql=" and fatura_giris_tarih<=".p('bitis');
}
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' ";
}
$ekle_sql=$baslangic_sql.$bitis_sql.$aylik_sql;
$row = "select *, uyeler.unvan as unvan_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,pazaryeri.pazaryeri as pazaryeri_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 grade_tipleri on urunler.grade_tipi=grade_tipleri.id
left join uyeler on urunler.bayi_id=uyeler.id
left join pazaryeri on urunler.f_pazaryeri=pazaryeri.id
where urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and siparis_id=0 and fatura_no!='' and urunler.teslim_nedeni=1 $ekle_sql order by urunler.id desc ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Bayi</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Durum</th>
<th>Grade</th>
<th>Fatura No</th>
<th>Fatura Tarih</th>
<th>İşçillik</th>
<th>Parça Maliyet</th>
<th>Müşteriden Alınan Tutar</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? 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->unvan_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->durum_text?></td>
<td><?=$rs->grade_text?></td>
<td><?=$rs->fatura_no?></td>
<td><?=$rs->fatura_giris_tarih?></td>
<td><?=$rs->iscilik?></td>
<td><?=$rs->asil_maliyet?></td>
<td><?=$rs->onaylanan_fiyat?></td>
<td><?=$rs->onaylanan_fiyat-((($rs->asil_maliyet)+$rs->dis_servis_ucreti)*1.18)?></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
<?}?>
<?if(p('filtrele')==4){
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=$aylik_bayi_siparis_sql;
$row = "select *, uyeler.unvan as unvan_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 grade_tipleri on urunler.grade_tipi=grade_tipleri.id
left join uyeler on urunler.bayi_id=uyeler.id
left join bayi_siparis on urunler.siparis_id=bayi_siparis.id
where urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and siparis_id<>0 and bayi_siparis.fatura_no!='' $ekle_sql order by urunler.id desc ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>SİPARİS ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Bayi</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Durum</th>
<th>Grade</th>
<th>Fatura No</th>
<th>Fatura Tarih</th>
<th>İşçillik</th>
<th>Parça Maliyet</th>
<th>Müşteriden Alınan Tutar</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? foreach($row as $rs){?>
<tr>
<td><?=$rs->isemri?></td>
<td><?=$rs->siparis_id?></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->unvan_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->durum_text?></td>
<td><?=$rs->grade_text?></td>
<td><?=$rs->fatura_no?></td>
<td><?=$rs->fatura_giris_tarih?></td>
<td><?=$rs->iscilik?></td>
<td><?=$rs->asil_maliyet?></td>
<td><?=$rs->fatura_edilen_tutar?></td>
<td><?=$rs->fatura_edilen_tutar-((($rs->asil_maliyet)+$rs->dis_servis_ucreti)*1.18)?></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
<?}?>
<?if(p('filtrele')==5){
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=$taksitlisatis_baslangic_sql.$taksitlisatis_bitis_sql.$aylik_taksilisatis_sql;
$row = "select *, uyeler.unvan as unvan_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 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 uyeler on urunler.bayi_id=uyeler.id
right join bayi_satislari on bayi_satislari.bsatis_id=urunler.bayisatis_id
where bsatis_id<>0 and urunler.sil=0 and bayi_satislari.mst_odeme_yapti<>0 $ekle_sql order by urunler.id desc ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Bayi</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Tarih</th>
<th>Müşteriden Alınan Tutar</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? 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->unvan_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->mst_odeme_yapti_tarih?></td>
<td><?=$rs->mst_alinacak_tutar?></td>
<td><?=$rs->mst_alinacak_tutar*0.98?></td>
</tr>
<?}?>
</tbody>
</table>
</div>
</div>
<?}?>
<?if(p('filtrele')==6){
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;
$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, hafiza.tip as hafiza_turu 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
where urunler.id<>0 and urunler.sil=0 and urunler.durum=150 and fatura_no!='' $ekle_sql ";
$row = $func->query($row);
$row=$row->fetchAll();
?>
<div class="card container col-12">
<div class="card-body" style="height: 900px; overflow-x: scroll; overflow-y: scroll;font-size:8px">
<table id="myTable" class="table table-responsive">
<thead>
<tr>
<th>ID</th>
<th>Cihaz</th>
<th>Teslim Nedeni</th>
<th>Bayi</th>
<th>IMEI</th>
<th>Seri No</th>
<th>Tarih</th>
<th>Alış</th>
<th>Satış</th>
<th>Kar</th>
</tr>
</thead>
<tbody>
<? 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->unvan_text?></td>
<td><?=$rs->imei?></td>
<td><?=$rs->seri_no?></td>
<td><?=$rs->fatura_giris_tarih?></td>
<?
$alis_satis="select sum(tutar) as alis,sum(depo_satis_fiyati) as satis from depo_yedekparca right join a_parca_iscilik on depo_yedekparca.id=a_parca_iscilik.depo_id where a_parca_iscilik.urun_id='$rs->isemri'";
$alis_satis = $func->query($alis_satis);
$alis_satis=$alis_satis->fetch();
?>
<td><?=$alis_satis->alis?></td>
<td><?=$alis_satis->satis?></td>
<td><?=$alis_satis->satis-$alis_satis->alis?></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';
?>