case "read":
$qry_sel = "SELECT u.iduser,u.username, ug.`name` AS groupname, u.iduser_group, u.fullname, u.email\n\t\t\tFROM `user` u\n\t\t\tLEFT JOIN `user_group` ug\n\t\t\t\tON(u.iduser_group = ug.iduser_group)";
echo json_encode($OBCrud->read($qry_sel));
break;
case "update":
$iduser = $_REQUEST["iduser"];
$username = $bfurn_db->quote(strtolower($_REQUEST["username"]));
$password = empty($_REQUEST["password"]) ? '' : $bfurn_db->quote(get_enc_password($_REQUEST["password"], ENC_PASSWORD));
$iduser_group_old = $_REQUEST["iduser_group_old"];
$iduser_group = $_REQUEST["iduser_group"];
$fullname = $bfurn_db->quote($_REQUEST["fullname"]);
$email = $bfurn_db->quote(!empty($_REQUEST["email"]) ? $_REQUEST["email"] : strtolower($_REQUEST["username"]) . '@' . $_SERVER["HTTP_HOST"]);
//BEGIN DELETE privilege_user_revoke FIRST===================================
if ($iduser_group_old != $iduser_group) {
$qry_del = "DELETE FROM privilege_user_revoke WHERE iduser={$iduser}";
$ret_del = $OBCrud->destroy($qry_del);
if (!$ret_del["success"]) {
echo json_encode($ret_del);
break;
}
}
//END DELETE privilege_user_revoke FIRST*****************************
$set_qry = "SET `username`={$username}, `iduser_group`={$iduser_group}, `fullname`={$fullname}, email={$email}";
if (!empty($password)) {
$set_qry .= ", `password`={$password}";
}
$qry_upd = "UPDATE `user` {$set_qry}\n\t\t\tWHERE `iduser`={$iduser} LIMIT 1";
echo json_encode($OBCrud->update($qry_upd));
break;
case "destroy":
$iduser = $_REQUEST["iduser"];
