Skip to content

Instantly share code, notes, and snippets.

@hakkbulutsereme
Created July 31, 2018 17:22
Post edilen üye idi'sini sorgulayıp yetkileri varsa sıralandırıyoruz ve yanına saha önce eklediğimiz atanabilecek yetkileri listeliyoruz. Burada php yetki() fonksiyonu, yetki id değerinin karşılığını işliyor.
<?php
include 'baglan.php';
function yetki($value)
{global $db;
if (!empty($value)) {
$uye=$db->prepare("SELECT * FROM yetkiler WHERE id=?");
$uye->execute(array($value));
$getir=$uye->fetch(PDO::FETCH_ASSOC);
echo '<li id="'.$getir["id"].'" > '.$getir["yetki_ad"].' <i style="float:right" onclick="'."sil('".$getir['id']."')".'" class="fa fa-close bg-black"></i></li>';
}
};
function yetkiler()
{global $db;
$uye=$db->prepare("SELECT * FROM yetkiler ");
$uye->execute();
$getir=$uye->fetchAll(PDO::FETCH_ASSOC);
foreach ($getir as $key ) {
echo '<li id="'.$key["id"].'" class="draggable" ><i style="float:left" class="fa fa-circle-o text-aqua"></i>'.$key["yetki_ad"].'</li>';}
}
if (isset($_POST["uye"])) {
$uye=$db->prepare("SELECT * FROM bt_uyeler WHERE uye_id=?");
$uye->execute(array($_POST['uye']));
$getir=$uye->fetch(PDO::FETCH_ASSOC);
echo '<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span></button>
<h4 class="modal-title">'.$getir["uye_ad"].'</h4>
</div>
<div class="modal-body">';
$yetki = explode(',', $getir["uye_yetki_id"]);
## Virgülleri ayırarak dizi haline getirdik ##
echo "<h4>Yetkiler</h4><div class='row' id='kayitli_yetki'>";
echo "<div class='col-md-3' ><label class='label label-btn bg-green' onclick='".'listsil("'.$getir["uye_id"].'")'."'>Sil</label><ul id='sortable' before='".$getir['uye_yetki_id']."' class='yetkilenmis'>";
foreach( $yetki as $anahtar => $deger ){
yetki($deger);}
echo '</ul></div><div class="col-md-3" ><ul class="yetkiler">';
yetkiler();
echo '</ul></div>';
?>
<script>
$( function() {
$( "#sortable" ).sortable({
revert: true
});
$( ".draggable" ).draggable({
connectToSortable: "#sortable",
helper:"clone",
stop:function (event, ui) {
var id = $(this).attr("id");
var yetkiler = $("#sortable").attr("before");
cartAction("ekle",id,"<?php echo $_POST['uye'];?>",yetkiler);
}
});
$( "#sortable" ).droppable({
hoverClass: "set"
});
});
$( "ul, li" ).disableSelection(function(argument) {
});
function cartAction(action,product_code,uye,yetki) {
var queryString = "";
if(action != "") {
switch(action) {
case "ekle":
queryString = 'action='+action+'&yetki='+ product_code+'&uye='+uye+'&yetkiler='+yetki;
break;
case "sil":
queryString = 'action='+action+'&yetki='+ product_code+'&uye='+uye+'&yetkiler='+yetki;
break;
case "empty":
queryString = 'action='+action;
break;
}
}
jQuery.ajax({
url: "yetki_ekle.php",
data:queryString,
type: "POST",
success:function(data){
$("#kayitli_yetki").html("");
$("#kayitli_yetki").html(data);
},
error:function (){}
});
}
</script>
<?php
echo '</div>';
echo'</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div> ';
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment