📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
b2be-ticaretscripti.demodesign.com.tr
/
boss
/
pages
📝
bayisiparisleri.php
← Geri Dön
<?php if (isset($_GET['temizle'])) { $id = temizle($_GET['temizle']); $sayfasil = $ozy->prepare("delete from siparis where id='$id'"); $sayfasil->execute([$id]); if ($sayfasil) { echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla veri silindi.", "Başarılı");});</script>'; } } $uyeid = temizle($_GET['uye']); $uyebilgim = $ozy->query("select * from users where id='$uyeid'")->fetch(PDO::FETCH_ASSOC); $bayiidm = $uyebilgim['bayigrup']; $oranbayim = $ozy->query("select * from bayigrup where id='$bayiidm'")->fetch(PDO::FETCH_ASSOC); 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([$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="container-fluid"> <div class="row page-title"> <div class="col-sm-6"> <h3><?php echo $uyebilgim['isim'];?> adlı bayiye ait Siparişler</br>(İndirim Oranı % <?php echo $oranbayim['oran'];?>)</h3> </div> <div class="col-sm-6"> <nav> <ol class="breadcrumb justify-content-sm-end align-items-center"> <li class="breadcrumb-item"> <a href="/boss/anasayfa.php"> <svg class="svg-color"> <use href="datas/svg/iconly-sprite.svg#Home"></use> </svg> </a> </li> <li class="breadcrumb-item active">Bayi Sipariş Detayı</li> </ol> </nav> </div> </div> </div> <div class="container-fluid ecommerce-dashboard"> <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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid' 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 uye='$uyeid'" ) ->fetch(PDO::FETCH_ASSOC); foreach ($usepettoplami as $usepetbedeli) { $usepetbedeli = number_format($usepetbedeli, 2, ".", ""); } ?> <?php $cusepettoplami = $ozy ->query( "SELECT SUM(caritutar+odenencari) FROM siparis WHERE uye='$uyeid'" ) ->fetch(PDO::FETCH_ASSOC); foreach ($cusepettoplami as $cusepetbedeli) { $cusepetbedeli = number_format($cusepetbedeli, 2, ".", ""); } ?> <?php $ocusepettoplami = $ozy ->query("SELECT SUM(toplamtutar) FROM siparis WHERE uye='$uyeid'") ->fetch(PDO::FETCH_ASSOC); foreach ($ocusepettoplami as $ocusepetbedeli) { $ocusepetbedeli = number_format($ocusepetbedeli, 2, ".", ""); } ?> <?php $cusepettoplamic = $ozy ->query("SELECT SUM(odenencari) FROM siparis WHERE uye='$uyeid'") ->fetch(PDO::FETCH_ASSOC); foreach ($cusepettoplamic as $cusepetbedelic) { $cusepetbedelic = number_format($cusepetbedelic, 2, ".", ""); } ?> <?php $cusepettoplamic1 = $ozy ->query("SELECT SUM(caritutar) FROM siparis WHERE uye='$uyeid'") ->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> <table id="tech-companies-1" class="table table-striped"> <thead> <tr> <th id="tech-companies-1-col-0">Sipariş No</th> <th data-priority="1" id="tech-companies-1-col-1">Toplam Cari Tutar Bedeli</th> <th data-priority="1" id="tech-companies-1-col-1">Ödenen Cari Tutar Bedeli</th> <th data-priority="1" id="tech-companies-1-col-1">Kalan Cari Tutar Bedeli</th> <th data-priority="3" id="tech-companies-1-col-2">Ödeme Tarihi</th> </tr> </thead> <tbody> <?php $ekbimiz = $ozy->query("select * from siparis where uye='$uyeid' and caritutar>'0' order by id desc")->fetchAll(PDO::FETCH_ASSOC); foreach ($ekbimiz as $ekibimiz) { ?> <tr> <th data-org-colspan="1" data-columns="tech-companies-1-col-0"><?php echo $ekibimiz["siparisno"]; ?></th> <td data-org-colspan="1" data-priority="1" data-columns="tech-companies-1-col-1"><?php echo $toplamcari =$ekibimiz["caritutar"] +$ekibimiz["odenencari"]; ?> TL / <?php echo afiyatgoster($toplamcari,$ekibimiz["para"]); ?></td> <td data-org-colspan="1" data-priority="1" data-columns="tech-companies-1-col-1"><?php echo $ekibimiz["odenencari"]; ?> TL / <?php echo afiyatgoster($ekibimiz["odenencari"],$ekibimiz["para"]); ?></td> <td data-org-colspan="1" data-priority="1" data-columns="tech-companies-1-col-1"><?php echo $kalancari =$ekibimiz["caritutar"]; ?> TL / <?php echo afiyatgoster($kalancari,$ekibimiz["para"]); ?></td> <td data-org-colspan="1" data-priority="3" data-columns="tech-companies-1-col-2"><?php echo $ekibimiz["caritarih"]; ?></td> </tr> <?php } ?> </tbody> </table> </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 uye='$uyeid' and 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="table_gets" class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;"> <thead> <tr> <th>Sipariş No</th> <th>Toplam Tutar</th> <th>Cari Tutar ve Tarih</th> <th>Ödenenen Tutar</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 uye='{$uyeid}' 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'") ->fetch(PDO::FETCH_ASSOC); $kargobilgileri = $ozy ->query("select * from kargolar where id='$kargoid'") ->fetch(PDO::FETCH_ASSOC); ?> <?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 } ?> <?php if ($tr["caritutar"] == "0") { ?> <td> <b>0 TL</b> </td> <?php } else { ?> <td> <b style="color:red;"><?php echo $tr["caritutar"]; ?> TL</b> </br> <b><?php echo $tr["caritarih"]; ?></b> </td> <?php } ?> <td><b><?php echo $tr["toplamtutar"]; ?> TL</b></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="fas fa-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> </div>
💾 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