📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
paketsatisscripti.demodesign.com.tr
/
admin
📝
paketler.php
← Geri Dön
<?php include("header.php"); if($user["yetki"]!="1"){ header("Location: index.php"); exit; } if(@$_POST["servis"]!=Null && @$_POST["kate"]!=Null && @$_POST["fiyat"]!=Null && @$_POST["adet"]!=Null && @$_POST["id"]==Null) { $id=$_SESSION["yetkili_id"]; $servis = $_POST['servis']; $servis=htmlentities($servis, ENT_QUOTES, "UTF-8"); $kate = $_POST['kate']; $kate=htmlentities($kate, ENT_QUOTES, "UTF-8"); $fiyat = $_POST['fiyat']; $fiyat=htmlentities($fiyat, ENT_QUOTES, "UTF-8"); $adet = $_POST['adet']; $adet=htmlentities($adet, ENT_QUOTES, "UTF-8"); $tip = $_POST['tip']; $tip=htmlentities($tip, ENT_QUOTES, "UTF-8"); $aciklama = $_POST['aciklama']; $aciklama=htmlentities($aciklama, ENT_QUOTES, "UTF-8"); $alt_baslik=htmlentities($_POST['alt_baslik'], ENT_QUOTES, "UTF-8"); if($tip==1){ $max="1"; $min="1"; } if($_POST['mod']=="Api"){ $api = $_POST['api']; $api=htmlentities($api, ENT_QUOTES, "UTF-8"); $servisid=htmlentities($_POST['servisid'], ENT_QUOTES, "UTF-8"); } else{ $api="Manuel"; $servisid="0"; } $url=str_slug($_POST["servis"]); $data2=mysqli_query($baglanti,"select * from service where url='$url'"); $data=mysqli_fetch_array($data2); if($data["id"]!=Null){ $url=$url."-".rand(1,999); } if ($baglanti->query("INSERT INTO service (servisid, servis, kate, fiyat, adet, api, ortalama,tip,aciklama,url,alt_baslik) VALUES ('$servisid','$servis','$kate', '$fiyat', '$adet', '$api', '','$tip','$aciklama','$url','$alt_baslik')")) { header("Location: ?is=bas"); exit; } } if(@$_POST["servis"]!=Null && @$_POST["kate"]!=Null && @$_POST["fiyat"]!=Null && @$_POST["adet"]!=Null && @$_POST["id"]!=Null) { $id=$_SESSION["yetkili_id"]; $servis = $_POST['servis']; $servis=htmlentities($servis, ENT_QUOTES, "UTF-8"); $kate = $_POST['kate']; $kate=htmlentities($kate, ENT_QUOTES, "UTF-8"); $fiyat = $_POST['fiyat']; $fiyat=htmlentities($fiyat, ENT_QUOTES, "UTF-8"); $adet = $_POST['adet']; $adet=htmlentities($adet, ENT_QUOTES, "UTF-8"); $aciklama = $_POST['aciklama']; $aciklama=htmlentities($aciklama, ENT_QUOTES, "UTF-8"); $tip = $_POST['tip']; $tip=htmlentities($tip, ENT_QUOTES, "UTF-8"); $durum = $_POST['durum']; $durum=htmlentities($durum, ENT_QUOTES, "UTF-8"); $alt_baslik=htmlentities($_POST['alt_baslik'], ENT_QUOTES, "UTF-8"); $sira=htmlentities($_POST['sira'], ENT_QUOTES, "UTF-8"); if($_POST['mod']=="Api"){ $api = $_POST['api']; $api=htmlentities($api, ENT_QUOTES, "UTF-8"); } else{ $api="Manuel"; } $id = $_POST['id']; $id=htmlentities($id, ENT_QUOTES, "UTF-8"); $sorgu = @mysqli_query($baglanti,"select * from service where id ='$id'"); $sonuc = $sorgu->fetch_assoc(); $servisid = $_POST['servisid']; $servisid=htmlentities($servisid, ENT_QUOTES, "UTF-8"); if($servisid==Null){$servisid=0;} $url=str_slug($_POST["servis"]); $data2=mysqli_query($baglanti,"select * from service where url='$url' and id!='$id'"); $data2=mysqli_fetch_array($data2); if($data2["id"]!=Null){ $url=$url."-".rand(1,999); } if ($baglanti->query("UPDATE service SET servisid='$servisid',servis='$servis',kate='$kate',fiyat='$fiyat',adet='$adet',aciklama='$aciklama',api='$api',tip='$tip',durum='$durum',url='$url',alt_baslik='$alt_baslik',sira='$sira' WHERE id='$id'")) { header("Location: ?is=bas2"); exit; } } if(@$_POST["silid"]!=Null){ $silid=htmlentities($_POST["silid"], ENT_QUOTES, "UTF-8"); $baglanti->query("DELETE FROM service WHERE id='$silid'"); header("Location: ?is=bas3"); exit; } ?> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.4/jquery.min.js" integrity="sha512-pumBsjNRGGqkPzKHndZMaAG+bir374sORyzM3uulLV14lN5LyykqNk8eEeUlUkB3U0M4FApyaHraT65ihJhDpQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script> <div class="page-content-wrapper"> <div class="page-content-wrapper-inner"> <div class="content-viewport"> <div class="row"> <div class="col-12 py-5"> <h4>Paketler <button type="button" class="btn btn-info btn-sm" data-toggle="modal" data-target="#myModal" style="float:right;">Paket Ekle</button></h4> <div id="myModal" class="modal fade" role="dialog"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <div class="modal-header"> <h4 class="modal-title">Paket Ekle</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <div class="modal-body m-3"> <form method="post" action=""> <div class="form-group"> <label for="subject" class="control-label">Paket Ad</label> <input type="text" class="form-control" required="" name="servis"> </div> <div class="form-group"> <label for="subject" class="control-label">Paket Alt Başlık</label> <input type="text" class="form-control" required="" name="alt_baslik"> </div> <div class="form-group"> <label for="inputEmail1">Açıklama</label> <textarea type="text" name="aciklama" rows="7" class="form-control" id="summernote"></textarea> </div> <input type="hidden" name="tip" value="1"> <!-- <div class="form-group"> <label for="subject" class="control-label">Paket Tipi</label> <select name="tip" class="form-control" required=""> <option value="1">Paket</option> <option value="2">Yorum</option> <option value="3">Yorum Beğeni</option> </select> </div> --> <div class="form-group"> <label for="subject" class="control-label">Mod</label> <select name="mod" class="form-control" required="" onchange="modcek(this.value)"> <option value="Manuel">Manuel</option> <option value="Api">Api</option> </select> </div> <div id="mod"></div> <div id="servis"></div> <div class="form-group"> <label for="subject" class="control-label">Kategori</label> <select name="kate" class="form-control"> <?php $destekcek=mysqli_query($baglanti,"select * from kategori ORDER BY id DESC"); while($satir=mysqli_fetch_array($destekcek)) { $dataid=$satir["platform"]; $data=mysqli_query($baglanti,"select * from platform where id='$dataid' ORDER BY id DESC"); $data=mysqli_fetch_array($data); echo '<option value="'.$satir['id'].'">'.$satir['ad'].' ('.$data["ad"].')</option>'; } ?> </select> </div> <div id="fiyat"> <div class="form-group"> <label for="subject" class="control-label">Paket Fiyatı</label> <input type="text" class="form-control" pattern="[0-9.]*" required="" name="fiyat"> </div> <div class="form-group"> <label for="subject" class="control-label">Paket Miktar</label> <input type="number" class="form-control" required="" name="adet"> </div> </div> <button type="submit" class="btn btn-sm btn-primary">Paket Oluştur</button> </form> </div> </div> </div> </div> </div> </div> <div class="row"> <div class="col-md-12 equel-grid"> <div class="grid"> <p class="grid-header">Paket Listesi</p> <div class="grid-body"> <?php if(@$_GET["is"]=="bas"){ echo '<div class="alert alert-success m-2">Paket başarıyla eklendi.</div>'; } if(@$_GET["is"]=="bas2"){ echo '<div class="alert alert-success m-2">Paket başarıyla güncellendi.</div>'; } if(@$_GET["is"]=="bas3"){ echo '<div class="alert alert-success m-2">Paket başarıyla silindi.</div>'; } ?> <div class="table-responsive"> <table class="table table-hover table-sm"> <thead> <tr class="solid-header"> <th class="service-block__id">ID</th> <th>Platform Adı</th> <th>Kategori Adı</th> <th class="service-block__service">Paket Ad </th> <th class="service-block__provider">Sağlayıcı</th> <th class="service-block__rate">Fiyat</th> <th class="service-block__minorder">Adet</th> <th class="service-block__minorder">Durum</th> <th class="service-block__action">İşlem</th> </tr> </thead> <tbody> <?php $destekcek=mysqli_query($baglanti,"select * from service ORDER BY sira ASC"); while($satir=mysqli_fetch_array($destekcek)) { $dataaid=$satir["kate"]; $dataa=mysqli_query($baglanti,"select * from kategori where id='$dataaid' ORDER BY id DESC"); $dataa=mysqli_fetch_array($dataa); $dataid=$dataa["platform"]; $data=mysqli_query($baglanti,"select * from platform where id='$dataid' ORDER BY id DESC"); $data=mysqli_fetch_array($data); $servis=$satir["id"]; $api=$satir["api"]; if($api=="Manuel"){ $apiad="Manuel"; } elseif($satir["secim"]=="1"){ $apiad="Abonelik"; } else{ $api=$satir["api"]; $katecek=mysqli_query($baglanti,"select * from api where id='$api' "); $katecek=mysqli_fetch_array($katecek); $apiad=$katecek["ad"]; $say=0; } echo ' <tr id="serviceshowcategory-'.$satir["id"].'" class="ui-state-default " data-category="category-'.$satir["id"].'" data-id="'.$satir['id'].'" data-service="servv"> <td class="service-block__id">'.$satir['id'].'</td> <td class="service-block__id">'.$data['ad'].'</td> <td class="service-block__id">'.$dataa['ad'].'</td> <td class="service-block__service">'.$satir['servis'].'</td> <td class="service-block__provider">'. $apiad.'</td> <td class="service-block__rate"> <div style="color: green">'.$satir['fiyat'].' TL</div> </td> <td class="service-block__minorder"> <div>'.$satir['adet'].'</div> </td> <td class="service-block__minorder"> '; if($satir["durum"]=="1"){ echo'<div style="color:green;">Aktif</div>';} if($satir["durum"]=="0"){ echo'<div style="color:red;">Pasif</div>';} echo' </td> <td><button type="button" class="btn btn-info btn-sm" id="goruntule'.$satir["id"].'" data-toggle="modal" data-target="#myModal'.$satir['id'].'">Görüntüle</button> <button type="button" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#myModalsil'.$satir['id'].'">Sil</button></td> </tr> '; echo ' </tr> <div id="myModal'.$satir['id'].'" class="modal fade" role="dialog"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <div class="modal-header"> <h4 class="modal-title">Paket Düzenle</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <div class="modal-body m-3"> <form method="post" action=""> <input type="hidden" value="'.$satir['id'].'" name="id"> '; ?><div class="row"> <div class="col-md-4"> <div class="form-group"> <label for="subject" class="control-label">Paket Ad</label> <input type="text" class="form-control" required="" value="<?php echo $satir["servis"]; ?>" name="servis"> </div> </div> <div class="col-md-4"> <div class="form-group"> <label for="subject" class="control-label">Paket Alt Başlık</label> <input type="text" class="form-control" required="" value="<?php echo $satir["alt_baslik"]; ?>" name="alt_baslik"> </div> </div> <div class="col-md-4"> <div class="form-group"> <label for="subject" class="control-label">Paket Sıra</label> <input type="number" class="form-control" required="" value="<?php echo $satir["sira"]; ?>" name="sira"> </div> </div> </div> <div class="form-group"> <label for="inputEmail1">Açıklama</label> <textarea type="text" name="aciklama" rows="7" class="form-control" id="summernote<?php echo $satir["id"];?>"><?php echo html_entity_decode($satir["aciklama"]); ?></textarea> </div> <input type="hidden" name="tip" value="1"> <!-- <div class="form-group"> <label for="subject" class="control-label">Paket Tipi</label> <select name="tip" class="form-control" required=""> <?php if($satir["tip"]=="2"){ echo ' <option value="2">Yorum</option> <option value="1">Paket</option> <option value="3">Yorum Beğeni</option>'; } elseif($satir["tip"]=="3"){ echo ' <option value="3">Yorum Beğeni</option> <option value="1">Paket</option> <option value="2">Yorum</option>'; } else{ echo ' <option value="1">Paket</option> <option value="2">Yorum</option> <option value="3">Yorum Beğeni</option>'; } ?> </select> </div>--> <div class="form-group"> <label for="subject" class="control-label">Durum</label> <select name="durum" class="form-control" required=""> <?php if($satir["durum"]=="0"){ echo ' <option value="0">Pasif</option> <option value="1">Aktif</option>'; } else{ echo ' <option value="1">Aktif</option> <option value="0">Pasif</option>'; } ?> </select> </div> <div class="form-group"> <label for="subject" class="control-label">Mod</label> <select name="mod" class="form-control" required="" onchange="modceka<?php echo $satir["id"];?>(this.value)"> <?php if($satir["api"]=="Manuel"){ echo ' <option value="Manuel">Manuel</option> <option value="Api">Api</option>'; } else{ echo ' <option value="Api">Api</option> <option value="Manuel">Manuel</option>'; } ?> </select> </div> <div id="moda<?php echo $satir["id"];?>"> <?php if($satir["api"]!="Manuel"){ ?> <div class="form-group"> <label for="subject" class="control-label">Api</label> <select name="api" class="form-control" onchange="servisceka<?php echo $satir["id"];?>(this.value)"> <?php $kate= $satir["api"]; $destekceka=mysqli_query($baglanti,"select * from api where id='$kate'"); $satira=mysqli_fetch_array($destekceka); echo '<optgroup label="Sağlayıcılar">'; $destekceka=mysqli_query($baglanti,"select * from api ORDER BY id DESC"); while($satira=mysqli_fetch_array($destekceka)) { if ($satir["id"] == $satira["id"]) { echo '<option value="'.$satira['id'].'" selected>'.$satira['ad'].'</option>'; } else { echo '<option value="'.$satira['id'].'">'.$satira['ad'].'</option>'; } }echo '</optgroup>'; ?> </select> </div> <?php } ?> </div> <script> $('#goruntule<?php echo $satir['id']; ?>').click(function() { $.ajax({ url: "ajax.php", type: "POST", data: { servis: "<?=$satir["api"]?>", ek: "a<?=$satir["id"]?>", ok: "<?=$satir["servisid"]?>" }, success: function(data) { $("#servisa<?=$satir['id']?>").html(data); $("[onchange='servisfiyata<?=satir["id"]?>(this.value)']").val("<?=$satir['id']?>"); } }) }) </script> <div id="servisa<?php echo $satir["id"];?>"> <?php if($satir["api"]!="Manuel"){ $servis=$satir["api"]; $sorgu2 = @mysqli_query($baglanti,"select * from api where id ='$servis'"); $sonuc2 = $sorgu2->fetch_assoc(); if($sonuc2["id"]==Null){ echo '<div class="alert alert-danger text-center">Bu servisin apisi silinmiş!</div>'; } else{ $api = new Api($sonuc2['api'], $sonuc2['anahtar']); $services = (array)$api->services(); $say=0; echo' <div class="form-group"> <label for="subject" class="control-label">Sağlayıcı Servis ID</label> <div id="servisa'; echo $satir["id"]; echo'"></div> <select name="servisid" class="form-control"> '; while(@$services[$say]->service!=Null){ if($satir["api"]==$services[$say]->service){ echo '<option value="'.$services[$say]->service.'">'.$services[$say]->name.'</option>'; break; } $say++; } $say=0; echo '<optgroup label="Servisler">'; while(@$services[$say]->service!=Null){ echo '<option value="'.$services[$say]->service.'">'.$services[$say]->name.'</option>'; $say++; } echo '</optgroup>'; echo '</select></div>';} } ?> </div> <div class="form-group"> <label for="subject" class="control-label">Kategori</label> <select name="kate" class="form-control"> <?php $kate= $satir["kate"]; $destekceka=mysqli_query($baglanti,"select * from kategori where id='$kate'"); $satira=mysqli_fetch_array($destekceka); $dataid=$satira["platform"]; $data=mysqli_query($baglanti,"select * from platform where id='$dataid' ORDER BY id DESC"); $data=mysqli_fetch_array($data); echo '<option value="'.$satira['id'].'">'.$satira['ad'].' ('.$data["ad"].')</option><optgroup label="Kategoriler">'; $destekceka=mysqli_query($baglanti,"select * from kategori ORDER BY id DESC"); while($satira=mysqli_fetch_array($destekceka)) { $dataid=$satira["platform"]; $data=mysqli_query($baglanti,"select * from platform where id='$dataid' ORDER BY id DESC"); $data=mysqli_fetch_array($data); echo '<option value="'.$satira['id'].'">'.$satira['ad'].' ('.$data["ad"].')</option>'; }echo '</optgroup>'; ?> </select> </div> <div class="form-group"> <label for="subject" class="control-label">Paket Fiyatı</label> <input type="text" class="form-control" required="" pattern="[0-9.]*" value="<?php echo $satir["fiyat"] ?>" name="fiyat"> </div> <div class="form-group"> <label for="subject" class="control-label">Paket Miktar</label> <input type="number" class="form-control" required="" value="<?php echo $satir["adet"] ?>" name="adet"> </div> <?php echo ' <button type="submit" class="btn btn-sm btn-primary">Güncelle</button> </form> </div> </div> </div> </div> <div id="myModalsil'.$satir['id'].'" class="modal fade" role="dialog"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <h4 class="modal-title">Paket Sil</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <div class="modal-body m-3"> <div class="alert alert-warning">'.$satir['ad'].' isimli paketi silmek istediğinize emin misiniz?</div> <form method="post" action=""> <input type="hidden" value="'.$satir['id'].'" name="silid"> <button type="submit" class="btn btn-sm btn-block btn-danger">Paket Sil</button> </form> </div> </div> </div> </div>'; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <?php include("footer.php"); ?> <script> function serviscek(secid) { $.post("ajax.php", { 'servis': secid }, function (donenVeri) { $("#servis").html(donenVeri); $("#fiyat").html(""); }); } function tipcek(secid) { $.post("ajax.php", { 'tip': secid }, function (donenVeri) { $("#tip").html(donenVeri); }); } function servisfiyat(secid) { api=document.getElementById("apidata").value; $.post("ajax.php", { 'fiyat': secid, 'api' : api }, function (donenVeri) { $("#fiyat").html(donenVeri); }); } function serviscek2(secid) { $.post("ajax.php", { 'servis2': secid }, function (donenVeri) { $("#servis2").html(donenVeri); }); } function modcek(secid) { $.post("ajax.php", { 'mod': secid }, function (donenVeri) { if(donenVeri==0){ $.post("ajax.php", { 'ozel': "1" }, function (donenVeri) { $("#ozel").html(donenVeri); $("#mod").html(""); $("#servis").html(""); $("#fiyat").html(""); $.post("ajax.php", { 'fiyat': "0" }, function (donenVeri) { $("#fiyat").html(donenVeri); }); }); } else{ $("#mod").html(donenVeri); $("#servis").html(""); $("#ozel").html(""); $("#fiyat").html(""); } }); } <?php $destekcek=mysqli_query($baglanti,"select * from service ORDER BY id DESC"); while($satir=mysqli_fetch_array($destekcek)) { ?> function servisceka<?php echo $satir["id"];?>(secid) { $.post("ajax.php", { 'servis': secid, 'ek': 'a<?php echo $satir["id"];?>' }, function (donenVeri) { $("#servisa<?php echo $satir["id"];?>").html(donenVeri); $("#fiyata<?php echo $satir["id"];?>").html(""); }); } function tipceka<?php echo $satir["id"];?>(secid) { $.post("ajax.php", { 'tip': secid }, function (donenVeri) { $("#tipa<?php echo $satir["id"];?>").html(donenVeri); }); } function servisfiyata<?php echo $satir["id"];?>(secid) { api=document.getElementById("apidata").value; $.post("ajax.php", { 'fiyat': secid, 'api' : api }, function (donenVeri) { $("#fiyata<?php echo $satir["id"];?>").html(donenVeri); }); } function serviscek2a<?php echo $satir["id"];?>(secid) { $.post("ajax.php", { 'servis2': secid }, function (donenVeri) { $("#servis2a<?php echo $satir["id"];?>").html(donenVeri); }); } function modceka<?php echo $satir["id"];?>(secid) { $.post("ajax.php", { 'moda2': secid, 'ek': 'a<?php echo $satir["id"];?>' }, function (donenVeri) { if(donenVeri==0){ $.post("ajax.php", { 'ozel': "1" }, function (donenVeri) { $("#ozela<?php echo $satir["id"];?>").html(donenVeri); $("#moda<?php echo $satir["id"];?>").html(""); $("#servisa<?php echo $satir["id"];?>").html(""); $("#fiyata<?php echo $satir["id"];?>").html(""); $.post("ajax.php", { 'fiyat': "0" }, function (donenVeri) { $("#fiyata<?php echo $satir["id"];?>").html(donenVeri); }); }); } else{ $("#moda<?php echo $satir["id"];?>").html(donenVeri); $("#servisa<?php echo $satir["id"];?>").html(""); $("#ozela<?php echo $satir["id"];?>").html(""); $("#fiyata<?php echo $satir["id"];?>").html(""); } }); } <?php } ?> </script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script> <link href="https://cdn.jsdelivr.net/npm/summernote@0.8.18/dist/summernote.min.css" rel="stylesheet"> <script src="https://cdn.jsdelivr.net/npm/summernote@0.8.18/dist/summernote.min.js"></script> <script> $(function () { $('#summernote').summernote({ height:200, callbacks: { onImageUpload: function(files, editor, welEditable) { sendFile(files[0], editor, welEditable); } } }); function sendFile(file, editor, welEditable) { data = new FormData(); data.append("file", file); $.ajax({ data: data, type: "POST", url: "<?=$site;?>admin/upload.php", cache: false, contentType: false, processData: false, success: function(url) { $('#summernote').summernote('insertImage', url); } }); } }) </script> <?php $destekcek=mysqli_query($baglanti,"select * from service ORDER BY id DESC"); while($satir=mysqli_fetch_array($destekcek)) { ?> <script> $(function () { $('#summernote<?php echo $satir["id"];?>').summernote({ height:200, callbacks: { onImageUpload: function(files, editor, welEditable) { sendFile<?php echo $satir["id"];?>(files[0], editor, welEditable); } } }); function sendFile<?php echo $satir["id"];?>(file, editor, welEditable) { data = new FormData(); data.append("file", file); $.ajax({ data: data, type: "POST", url: "<?=$site;?>admin/upload.php", cache: false, contentType: false, processData: false, success: function(url) { $('#summernote<?php echo $satir["id"];?>').summernote('insertImage', url); } }); } }) </script> <?php } ?>
💾 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