📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
b2be-ticaretscripti.demodesign.com.tr
/
boss_old
/
pages
📝
carihesapozeti.php
← Geri Dön
<?php if (isset($_GET['temizle'])) { $id = temizle($_GET['temizle']); $sayfasil = $ozy->prepare("delete from siparis where id='$id'"); $sayfasil->execute(array($id)); if ($sayfasil) { echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla veri silindi.", "Başarılı");});</script>'; } } if (isset($_POST['caridus'])) { $crtutar = temizle($_POST['crtutar']); $sipno = temizle($_POST['siparisno']); $ssno = $ozy->query("select * from siparis where siparisno='$sipno'")->fetch(PDO::FETCH_ASSOC); $nctutar = $ssno['caritutar']- $crtutar; $ocrtutar = $ssno['odenencari']+$crtutar; $stmtzzz = $ozy->prepare("UPDATE siparis SET caritutar = ? ,odenencari=? WHERE siparisno ='$sipno' and uye='$uyeid'"); $result2 = $stmtzzz->execute(array($nctutar,$ocrtutar)); if ($result2) { echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla cari hesaptan tutar düşümü sağlandı.", "Başarılı");});</script>'; header("Location: ".$ayar['siteurl']."/boss/bayi-siparisleri?uye=".$uyeid.""); } } ?> <div class="wrapper"> <div class="container-fluid"> <!-- Page-Title --> <div class="page-title-box"> <div class="row align-items-center"> <div class="col-sm-6"> <h4 class="page-title">Cari Hesap Özeti </h4> </div> <div class="col-sm-6"> <ol class="breadcrumb float-right"> <li class="breadcrumb-item"><a href="index.html">Anasayfa</a></li> <li class="breadcrumb-item active">Cari Hesap Özeti</li> </ol> </div> </div> <!-- end row --> </div> <div class="row"> <div class="col-12"> <div class="card m-b-30"> <div class="card-body"> <div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;"> <div class="card"> <div class="card-heading p-4"> <div class="mini-stat-icon float-right"> <i class="mdi mdi-cube-outline bg-primary text-white"></i> </div> <div> <h5 class="font-16">Siparişler (Bugün)</h5> </div> <h3 class="mt-4"> <?php $siparis1 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis where caritutar>'0' and tarihson = CURDATE();")->fetch(PDO::FETCH_ASSOC); foreach( $siparis1 as $siparis1x ){ echo $siparis1x = number_format($siparis1x, 2, '.', '');}?> TL </h3> <div class="progress mt-4" style="height: 4px;"> </div> <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php $say1 = $ozy->prepare("SELECT COUNT(*) FROM siparis where caritutar>'0' and tarihson = CURDATE();"); $say1->execute(); echo $siparis1 = $say1->fetchColumn();?> Adet</span></p> </div> </div> </div> <div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;"> <div class="card"> <div class="card-heading p-4"> <div class="mini-stat-icon float-right"> <i class="mdi mdi-briefcase-check bg-success text-white"></i> </div> <div> <h5 class="font-16">Siparişler (Bu hafta)</h5> </div> <h3 class="mt-4"> <?php $siparis12 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 7 day")->fetch(PDO::FETCH_ASSOC); foreach( $siparis12 as $siparis1xx ){ echo $siparis1xx = number_format($siparis1xx, 2, '.', '');}?> TL </h3> <div class="progress mt-4" style="height: 4px;"> </div> <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php $say12 = $ozy->prepare("SELECT COUNT(*) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 7 day"); $say12->execute(); echo $siparis12 = $say12->fetchColumn();?> Adet</span></p> </div> </div> </div> <div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;"> <div class="card"> <div class="card-heading p-4"> <div class="mini-stat-icon float-right"> <i class="mdi mdi-tag-text-outline bg-warning text-white"></i> </div> <div> <h5 class="font-16">Siparişler (Bu ay)</h5> </div> <h3 class="mt-4"> <?php $siparis123 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 month")->fetch(PDO::FETCH_ASSOC); foreach( $siparis123 as $siparis1xxx ){ echo $siparis1xxx = number_format($siparis1xxx, 2, '.', '');}?> TL </h3> <div class="progress mt-4" style="height: 4px;"> </div> <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php $say123 = $ozy->prepare("SELECT COUNT(*) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 month"); $say123->execute(); echo $siparis123 = $say123->fetchColumn();?> Adet</span></p> </div> </div> </div> <div class="col-sm-6 col-xl-3" style="float: left;margin-top: 6px;"> <div class="card"> <div class="card-heading p-4"> <div class="mini-stat-icon float-right"> <i class="mdi mdi-buffer bg-danger text-white"></i> </div> <div> <h5 class="font-16">Siparişler (Bu yıl)</h5> </div> <h3 class="mt-4"> <?php $siparis1234 = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 YEAR")->fetch(PDO::FETCH_ASSOC); foreach( $siparis1234 as $siparis1xxxx ){ echo $siparis1xxxx = number_format($siparis1xxxx, 2, '.', '');}?> TL </h3> <div class="progress mt-4" style="height: 4px;"> </div> <p class="text-muted mt-2 mb-0">Toplam Sipariş<span class="float-right"><?php $say1234 = $ozy->prepare("SELECT COUNT(*) FROM siparis WHERE caritutar>'0' and tarihson >= NOW() - INTERVAL 1 YEAR"); $say1234->execute(); echo $siparis1234 = $say1234->fetchColumn();?> Adet</span></p> </div> </div> </div> <?php $usepettoplami = $ozy->query("SELECT SUM(toplamtutar+caritutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC); foreach( $usepettoplami as $usepetbedeli ){ $usepetbedeli = number_format($usepetbedeli, 2, '.', ''); }?> <?php $cusepettoplami = $ozy->query("SELECT SUM(caritutar+odenencari) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC); foreach( $cusepettoplami as $cusepetbedeli ){ $cusepetbedeli = number_format($cusepetbedeli, 2, '.', ''); }?> <?php $ocusepettoplami = $ozy->query("SELECT SUM(toplamtutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC); foreach( $ocusepettoplami as $ocusepetbedeli ){ $ocusepetbedeli = number_format($ocusepetbedeli, 2, '.', ''); }?> <?php $cusepettoplamic = $ozy->query("SELECT SUM(odenencari) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC); foreach( $cusepettoplamic as $cusepetbedelic ){ $cusepetbedelic = number_format($cusepetbedelic, 2, '.', ''); }?> <?php $cusepettoplamic1 = $ozy->query("SELECT SUM(caritutar) FROM siparis WHERE caritutar>'0'")->fetch(PDO::FETCH_ASSOC); foreach( $cusepettoplamic1 as $cusepetbedelic1 ){ $cusepetbedelic1 = number_format($cusepetbedelic1, 2, '.', ''); }?> <div style="border: 1px solid #e0dbdb; font-size: 14px; padding-left: 20px; margin-bottom: 20px; padding-bottom: 30px;"> <div style="border: 1px solid #e0dbdb; font-size: 14px; padding-left: 20px; margin-bottom: 20px; padding-bottom: 30px;"> <b style="background: #247a06; color: white; padding: 10px;float: left;margin-right:10px;width: 18%; text-align: center; height: 75px; padding: 16px;">Toplam Sipariş Bedeli: <?php echo $usepetbedeli;?> TL</b></br></br> <b style="background: #0b012f; color: white; padding: 10px;float: left;margin-right:10px;width: 18%; text-align: center; height: 75px; padding: 16px;">Ödenen Tutar Bedeli: <?php echo $ocusepetbedeli;?> TL</b></br></br> <b style="background: #ca0912; color: white; padding: 10px;float: left;margin-right:10px;width: 18%; text-align: center; height: 75px; padding: 16px;">Toplam Cari Tutar Bedeli: <?php echo $cusepetbedeli;?> TL</b></br></br> <b style="background: #1832be; color: white; padding: 10px;float: left;margin-right:10px;width: 18%; text-align: center; height: 75px; padding: 16px;">Ödenen Cari Tutar Bedeli: <?php echo $cusepetbedelic;?> TL</b></br></br> <b style="background: #caac09; color: white; padding: 10px;float: left;margin-right:10px;width: 18%; text-align: center; height: 75px; padding: 16px;">Kalan Cari Tutar Bedeli: <?php echo $cusepetbedelic1;?> TL</b></br></br> </div> </br></br></br></br></br></br> <div> </div> </div> <form action="" method="POST" style="background: #f9f6f6;padding: 10px;"> <label style="width: 95%;">Sipariş Seçiniz:</label> <input name="uyeid" value="<?php echo temizle($_GET['uye']);?>" type="hidden"> <select name="siparisno" style="width: 50%;" class="form-control" onchange='this.form.submit()'> <?php $ekbimiz = $ozy->query("select * from siparis where caritutar>'0' order by id desc")->fetchAll(PDO::FETCH_ASSOC); foreach($ekbimiz as $ekibimiz){?> <option <?php echo $_GET['siparisno'] == $_POST['siparisno'] ? 'selected="selected"' : null; ?> value="<?php echo $ekibimiz['siparisno'];?>"><?php echo $ekibimiz['siparisno'];?> / Cari Tutar Miktarı : <?php echo $ekibimiz['caritutar'];?> TL</option> <?php }?> </select> <div style="margin-left: 53% !important;margin-top: -53px !important;"> <label style="width: 100%;">Cari Hesaptan Düşülecek Tutar: <input type="search" class="form-control" name="crtutar" placeholder="Sadece TL bazında düşüm yapılabilir. Rakam giriniz" required> </label> </div> <button type="submit" name="caridus" style="width: 100%;" class="btn btn-warning waves-effect waves-lightt"> Cari Hesaptan Düş </button> </div> </form> <table data-order='[[ 0, "desc" ]]' id="datatable" class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;"> <thead> <tr> <th>Sipariş No</th> <th>Bayi</th> <th>Toplam Sipariş Tutarı</th> <th>Sipariş Ödenenen Tutar</th> <th>Toplam Cari Tutar</th> <th>Ödenen Cari Tutar</th> <th>Kalan Cari Tutar</th> <th>Ödeme Tarihi</th> <th>Ödeme Tipi</th> <th>Durumu</th> <th>Sipariş Tarihi</th> <th>İşlem</th> </tr> </thead> <tbody> <?php $pr = $ozy->query("select * from siparis where caritutar>'0' ORDER BY id desc")->fetchAll(PDO::FETCH_ASSOC); foreach ($pr as $tr) {?> <tr> <td><?php echo $tr['siparisno']?></td> <?php $sipuyeid = $tr['uye']; $kargoid = $tr['kargoid']; $siparisuyebilgileri = $ozy->query("select * from users where id='$sipuyeid' and bayi='1'")->fetch(PDO::FETCH_ASSOC); $kargobilgileri = $ozy->query("select * from kargolar where id='$kargoid'")->fetch(PDO::FETCH_ASSOC);?> <td><a target="_blank" href="bayi-siparisleri?uye=<?php echo $tr['uye']?>"> <?php echo $siparisuyebilgileri['isim']?> </td> <?php if($tr['caritutar']=='0'){?> <td> <b><?php echo $tr['toplamtutar'];?> TL</b> </td> <?php } else { ?> <td> <b><?php echo $tr['toplamtutar']+$tr['caritutar'];?> TL</b> </td> <?php } ?> <td><b><?php echo $tr['toplamtutar']?> TL</b></td> <td> <?php echo $xtoplamcari = $tr['caritutar']+$tr['odenencari'];?> TL </td> <td><?php echo $tr['odenencari'];?> TL / <?php echo afiyatgoster($tr['odenencari'],$tr['para']);?></td> <td><?php echo $xkalancari = $tr['caritutar'];?> TL / <?php echo afiyatgoster($xkalancari,$tr['para']);?></td> <td> <?php echo $tr['caritarih'];?></td> <td><?php echo $tr['odemetipi']?></td> <td><span style="font-size: 13px;font-size: 13px;background: white;color: black;border: 1px solid #6975b6;border-radius: 0px;padding: 5px;" class="badge badge-success"><?php echo $tr['durum']?></td> </span> <td><?php echo $tr['tarih']?></td> <td> <a href="tel:<?php echo $tr['telefon']; ?>" target="_blank" onclick="return confirm('Telefon ile yanıt vermek istiyor musun ?')" class="btn btn-sm btn-danger" style="border: none;background: #4192e9;" data-toggle="tooltip" data-original-title="Telefon ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/tel.png"></img></a> <a href="https://api.whatsapp.com/send?phone=+9<?php echo $tr['telefon']; ?>&text=Merhaba iyi günler, <?php echo $ayar['siteadi'];?> olarak websitemizinden <?php echo $tr['siparisno']; ?> nolu siparişiniz için rahatsız ediyorum. Sipariş durumunuz <?php echo $tr['durum']; ?> olarak güncellenmiştir. <?php echo $tr['durum'] == 'Kargoya Verildi' ? 'Kargo Bilgileriniz : '.$kargobilgileri['adi'].' Takip Numaranız : '.$tr['takipno'].'' : null; ?> İyi günler dileriz." target="_blank" onclick="return confirm('WhatsApp ile yanıt vermek istiyor musun ?')" class="btn btn-sm btn-danger" style="border: #2ab200;background: #2ab200;" data-toggle="tooltip" data-original-title="WhatsApp ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/whatsap.jpg"></img></a> <a href="javascript:printDiv('divYazdir<?php echo $tr['id']?>');" style="background: #8a940b;color: white;" onclick="return confirm('Siparişi yazdırmak istediğine emin misin?')" class="btn btn-sm btn" data-toggle="tooltip" data-original-title="Yazdır"><i class="fa fa-print" aria-hidden="true"></i></a> <a href="bayi-siparisleri?temizle=<?php echo $tr['id']; ?>" onclick="return confirm('Silmek istediğinize emin misiniz ?')" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i class="ti-trash" aria-hidden="true"></i></a> <a href="siparis/duzenle/<?php echo $tr['id']?>" class="btn btn-sm btn-success" data-toggle="tooltip" data-original-title="Düzenle"><i class="fa fa-edit" aria-hidden="true"></i></a> </td> </tr> <div class="col-12" id="divYazdir<?php echo $tr['id']?>" style="display:none;"> <?php $adresdizi = $dizi = explode (" ",$tr['adres']);?> <div style="position:absolute;left:50%;margin-left:-420px;top:0px;width:841px;height:594px;border-style:outset;overflow:hidden"> <div style="position:absolute;left:0px;top:0px"> <img src="faturaback.jpg" width=841 height=594></div> <div style="position: absolute;left: 15%;top: 40.33px;" class="cls_002"><span class="cls_002"><img src="../resimler/siteayarlari/<?php echo $ayar['logo']; ?>" style="height: 40px !important"></span></div> <div style="position:absolute;left:41.76px;top:84.33px" class="cls_002"><span class="cls_002">Gönderici Bilgileri</span></div> <div style="position:absolute;left:41.76px;top:106.09px" class="cls_003"><span class="cls_003">Şirket İsmi</span></div> <div style="position:absolute;left:134.07px;top:106.09px" class="cls_003"><span class="cls_003"><?php echo $ayar['siteadi'];?></span></div> <div style="position:absolute;left:41.76px;top:127.85px" class="cls_003"><span class="cls_003">Şirket Telefon</span></div> <div style="position:absolute;left:134.07px;top:127.85px" class="cls_003"><span class="cls_003"><?php echo $ayar['tel'];?></span></div> <div style="position:absolute;left:41.76px;top:149.62px" class="cls_002"><span class="cls_002">Alıcı Bilgileri</span></div> <div style="position:absolute;left:41.76px;top:171.38px" class="cls_003"><span class="cls_003">Ad / Soyad</span></div> <div style="position:absolute;left:134.07px;top:171.38px" class="cls_003"><span class="cls_003"><?php echo $tr['adsoyad'];?></span></div> <div style="position:absolute;left:134.07px;top:193.15px" class="cls_003"><span class="cls_003"><?php echo $dizi[0];?> <?php echo $dizi[1];?> <?php echo $dizi[2];?> </span></div> <div style="position:absolute;left:41.76px;top:209.66px" class="cls_003"><span class="cls_003">Adres</span></div> <div style="position:absolute;left:134.07px;top:209.66px" class="cls_003"><span class="cls_003"><?php echo $dizi[3];?> <?php echo $dizi[4];?> <?php echo $dizi[5];?></span></div> <div style="position:absolute;left:134.07px;top:226.17px" class="cls_003"><span class="cls_003"><?php echo $dizi[6];?> <?php echo $dizi[7];?> <?php echo $dizi[8];?> <?php echo $dizi[9];?></span></div> <div style="position:absolute;left:41.76px;top:247.93px" class="cls_003"><span class="cls_003">İl / İlçe</span></div> <div style="position:absolute;left:134.07px;top:247.93px" class="cls_003"><span class="cls_003"><?php echo $tr['il'];?> / <?php echo $tr['ilce'];?></span></div> <div style="position:absolute;left:41.76px;top:269.69px" class="cls_003"><span class="cls_003">Telefon No</span></div> <div style="position:absolute;left:134.07px;top:269.69px" class="cls_003"><span class="cls_003"><?php echo $tr['telefon'];?></span></div> <div style="position:absolute;left:41.76px;top:291.46px" class="cls_003"><span class="cls_003">Cep Telefonu</span></div> <div style="position:absolute;left:134.07px;top:291.46px" class="cls_003"><span class="cls_003"><?php echo $tr['telefon'];?></span></div> <div style="position:absolute;left:41.76px;top:313.22px" class="cls_003"><span class="cls_003">Posta Kodu</span></div> <div style="position:absolute;left:134.07px;top:313.22px" class="cls_003"><span class="cls_003">90000</span></div> <div style="position:absolute;left:41.76px;top:334.99px" class="cls_002"><span class="cls_002">Satış Bilgileri</span></div> <div style="position:absolute;left:41.76px;top:356.75px" class="cls_003"><span class="cls_003">Kargo</span></div> <div style="position:absolute;left:41.76px;top:373.26px" class="cls_003"><span class="cls_003">Bilgileri</span></div> <div style="position:absolute;left:134.07px;top:352.69px" class="cls_003"><span class="cls_003"><?php echo $kargobilgileri['adi'];?></span></div> <div style="position:absolute;left:134.07px;top:372.69px" class="cls_003"><span class="cls_003"><?php echo $tr['takipno'];?></span></div> <div style="position:absolute;left:41.76px;top:395.02px" class="cls_003"><span class="cls_003">Durum : <?php echo $tr['durum'];?></span></div> <div style="position:absolute;left:41.76px;top:416.79px" class="cls_003"><span class="cls_003">Ödeme</span></div> <div style="position:absolute;left:134.07px;top:425.04px" class="cls_003"><span class="cls_003"><?php echo $tr['odemetipi'];?></span></div> <div style="position:absolute;left:41.76px;top:433.30px" class="cls_003"><span class="cls_003">Yöntemi</span></div> <div style="position:absolute;left:41.76px;top:455.06px" class="cls_003"><span class="cls_003">Sipariş Kodu</span></div> <div style="position:absolute;left:134.07px;top:455.06px" class="cls_003"><span class="cls_003"><?php echo $tr['siparisno'];?></span></div> </div> </div> <!-- SİPARİŞ YAZDIRMA ALANI --> <?php }?> </tbody> </table> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- end container-fluid --> <!-- end wrapper -->
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula