📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
belediyescripti.demodesign.com.tr
/
yonetim
/
data
📝
gelen_bagislar.php
← Geri Dön
<?php if (!empty($_SERVER["HTTP_X_REQUESTED_WITH"]) && strtolower($_SERVER["HTTP_X_REQUESTED_WITH"]) == "xmlhttprequest") { session_start(); require_once "../../_class/baglan.php"; require_once "../../_class/fonksiyon.php"; $_SESSION["guvenlik"] = ["gelen_bagisdurum" => kod(), "gelen_bagis_tumu" => kod(), "gelen_bagissil" => kod()]; $request = $_REQUEST; $col = ["id", "spno", "adi", "tarih", "fiyat", "durum", "islem"]; $sql = "SELECT * FROM bagis_odeme"; $totalFilter = $db->query($sql)->rowCount(); $sql = "SELECT * FROM bagis_odeme WHERE 1=1"; if (!empty($request["search"]["value"])) { $sql .= " AND (id LIKE '" . $request["search"]["value"] . "%' "; $sql .= " OR adi LIKE '" . $request["search"]["value"] . "%' "; $sql .= " OR spno LIKE '" . $request["search"]["value"] . "%' "; $sql .= " OR tel LIKE '" . $request["search"]["value"] . "%' "; $sql .= " OR email LIKE '" . $request["search"]["value"] . "%' "; $sql .= " OR tarih LIKE '" . $request["search"]["value"] . "%' )"; } $totalData = $db->query($sql)->rowCount(); $sql .= " ORDER BY " . $col[$request["order"][0]["column"]] . " " . $request["order"][0]["dir"] . " LIMIT " . $request["start"] . " ," . $request["length"] . " "; $query = $db->prepare($sql); $query->execute(); $islem = $query->fetchALL(PDO::FETCH_ASSOC); $data = []; $say = $request["start"] + 1; foreach ($islem as $row) { if ($row["paytronay"] == 0) { $durum = "<div class=\"badge badge-outline-warning\">Ödeme Onaylanmadı</div>"; } if ($row["paytronay"] == 1) { $durum = "<div class=\"badge badge-outline-success\">Ödeme Onaylandı</div>"; } $sepet = ""; foreach (json_decode($row["sepet"]) as $k => $v) { $sepet .= "<tr>\r\n\t\t\t\t\t<td>" . $k . "</td>\r\n\t\t\t\t\t<td>" . $v->adi . "</td>\r\n\t\t\t\t\t<td>" . $v->tutar . " TL</td>\r\n\t\t\t\t\t<td>" . $v->tutar . " TL</td>\r\n\t\t\t\t</tr>"; } $subdata = []; $subdata[] = "<div class=\"form-check mb-0 mt-0\"><label class=\"form-check-label\"><input type=\"checkbox\" name=\"id[]\" value=\"" . $row["id"] . "\" class=\"form-check-input\"><i class=\"input-helper\"></i></label></div>"; $subdata[] = $row["spno"]; $subdata[] = $row["adi"]; $subdata[] = $row["tarih"]; $subdata[] = $row["fiyat"] . " TL"; $subdata[] = $durum; $subdata[] = "<a href=\"\" data-role=\"update\" class=\"btn btn-inverse-primary btn-sm\" data-toggle=\"modal\" data-target=\"#gelen_bagis-" . $row["id"] . "\" data-id=\"" . $row["id"] . "\" title=\"Sipariş Detayı\"><i class=\"ti-eye\"></i></a>\r\n\t\t\t\t\t<a href=\"../_class/yonetim_islem.php?gelen_bagissil=ok&id=" . $row["id"] . "\" class=\"btn btn-inverse-danger btn-sm popconfirm\" title=\"Sil\"><i class=\"ti-trash\"></i></a>\r\n\t\t\t\t\t<div class=\"modal fade\" id=\"gelen_bagis-" . $row["id"] . "\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"ModalLabel\" aria-hidden=\"true\">\r\n\t\t\t\t\t\t<div class=\"modal-dialog\" role=\"document\" style=\"transform: translate(0, 0%);\">\r\n\t\t\t\t\t\t\t<div class=\"modal-content\">\r\n\t\t\t\t\t\t\t\t<div class=\"modal-header p-2 pl-2\">\r\n\t\t\t\t\t\t\t\t\t<h5 class=\"modal-title\" id=\"ModalLabel\">Bağış Detayları</h5>\r\n\t\t\t\t\t\t\t\t\t<p class=\"pt-2 pb-0 mb-0 text-right\">\r\n\t\t\t\t\t\t\t\t\t\tIP Adresi: <strong>" . $row["ip"] . "</strong> Bağış Tarihi: <strong>" . $row["tarih"] . "</strong>\r\n\t\t\t\t\t\t\t\t\t</p>\r\n\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t<form role=\"form\" action=\"\" method=\"POST\">\r\n\t\t\t\t\t\t\t\t<div class=\"modal-body text-left\">\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Bağış No</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"spno\" value=\"" . $row["spno"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Bağış Durumu</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t" . $durum . "\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Adı Soyadı</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"adsoyad\" value=\"" . $row["adi"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">E-Posta</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"email\" value=\"" . $row["email"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Telefon</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"telefon\" value=\"" . $row["tel"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Cep</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"il\" value=\"" . $row["cep"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">T.C. No</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"ilce\" value=\"" . $row["tc"] . "\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Adres</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<textarea class=\"form-control form-control-sm\" name=\"adres\" disabled>" . $row["adres"] . "</textarea>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label class=\"col-md-3 col-form-label text-right pt-2\">Toplam Tutar</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"text\" class=\"form-control form-control-sm\" name=\"fiyat\" value=\"" . $row["fiyat"] . " TL\" disabled>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<div class=\"form-group row mb-1\">\r\n\t\t\t\t\t\t\t\t\t\t<label for=\"aciklama\" class=\"col-md-3 col-form-label text-right pt-2\">Bağış Notunuz</label>\r\n\t\t\t\t\t\t\t\t\t\t<div class=\"col-md-9\">\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t<textarea class=\"form-control form-control-sm\" name=\"aciklama\">" . $row["aciklama"] . "</textarea>\r\n\t\t\t\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\r\n\t\t\t\t\t\t\t\t\t<div class=\"modal-header p-2\">\r\n\t\t\t\t\t\t\t\t\t\t<h4 class=\"modal-title mt-0\">Bağış Bilgileri</h4>\r\n\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t<table class=\"table table-hover mails\" style=\"margin-bottom:20px;\">\r\n\t\t\t\t\t\t\t\t\t\t<thead>\r\n\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<th>#</th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Bağış</th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Fiyat</th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Toplam</th>\r\n\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t</thead>\r\n\r\n\t\t\t\t\t\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t\t\t\t\t\t" . $sepet . "\r\n\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<td colspan=\"3\" class=\"text-right\">GENEL TOPLAM</td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<td>" . $row["fiyat"] . " TL</td>\r\n\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t</tbody>\r\n\t\t\t\t\t\t\t\t\t</table>\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t<div class=\"modal-footer\">\r\n\t\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"sid\" value=\"" . $row["id"] . "\" />\r\n\t\t\t\t\t\t\t\t\t<a href=\"../_class/yonetim_islem.php?gelen_bagissil=ok&id=" . $row["id"] . "\" class=\"btn btn-outline-danger btn-icon-text p-2 popconfirm\" title=\"Sil\"><i class=\"ti-trash\"></i> Sil</a>\r\n\t\t\t\t\t\t\t\t\t<button type=\"button\" data-dismiss=\"modal\" class=\"btn btn-outline-default btn-icon-text p-2\"><i class=\"fa fa-times\" aria-hidden=\"true\"></i> Kapat</button>\r\n\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t</form>\r\n\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t</div>"; $data[] = $subdata; } $json_data = ["draw" => intval($request["draw"]), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFilter), "data" => $data]; echo json_encode($json_data); } else { exit("Erişim engellendi"); } ?>
💾 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