function commandRouter($action)
{
switch ($action) {
case 'login':
loginUser();
break;
case 'createUser':
createUser();
break;
case 'getUser':
getUser();
break;
case 'deleteUser':
deleteUser();
break;
case 'updateUser':
updateUser();
break;
case 'addTab':
addTab();
break;
case 'delTab':
delTab();
break;
case 'editTab':
editTab();
break;
case 'getTabs':
getTabs();
break;
case 'addNote':
addNote();
break;
case 'delNote':
delNote();
break;
case 'editNote':
editNote();
break;
case 'getNotes':
getNotes();
break;
default:
break;
}
}
case 'edit_event_category':
TOOLBAR_spidercalendar::_NEW_event_category();
break;
case 'event_category':
TOOLBAR_spidercalendar::_DEFAULT_event_category();
break;
case 'plugin':
TOOLBAR_spidercalendar::_DEFAULT_plugin();
break;
default:
TOOLBAR_spidercalendar::_DEFAULT_calendar();
break;
}
switch ($task) {
case 'add_event':
addNote();
break;
case 'cancel_event':
cancelNote();
break;
case 'apply_event':
case 'save_event':
saveNote();
break;
case 'edit_event':
editNote();
break;
case 'event':
showNote(JRequest::getVar('calendar', 0, '', 'int'));
break;
case 'event_save_show':
function manejarSesionActiva($module_name, &$smarty, $sDirLocalPlantillas)
{
$sAction = '';
$sContenido = '';
$sAction = getParameter('action');
if (!in_array($sAction, array('', 'checkStatus', 'agentLogout', 'hangup', 'break', 'unbreak', 'transfer', 'confirm_contact', 'schedule', 'saveforms', 'call2phone', 'addCustomer', 'addNote', 'addDelivery', 'viewDelivery', 'addExternalNote', 'viewNote', 'show_call_history', 'update_customer', 'callOut', 'checkDeliveryPermission', 'viewCustomer', 'disableDelivery', 'enableDelivery', 'changePassword'))) {
$sAction = '';
}
// Se verifica si el agente sigue logoneado en la cola de Asterisk
$sAgente = $_SESSION['callcenter']['agente'];
$sExtension = $_SESSION['callcenter']['extension'];
$oPaloConsola = new PaloSantoConsola($sAgente);
$estado = $oPaloConsola->estadoAgenteLogoneado($sExtension);
if ($estado['estadofinal'] != 'logged-in') {
// Se marca el final de la sesión del agente en las tablas de auditoría
$oPaloConsola->logoutAgente();
$_SESSION['callcenter'] = generarEstadoInicial();
}
switch ($sAction) {
case 'checkStatus':
$sContenido = manejarSesionActiva_checkStatus($module_name, $smarty, $sDirLocalPlantillas, $oPaloConsola, $estado);
break;
case 'hangup':
$sContenido = manejarSesionActiva_hangup($oPaloConsola);
break;
case 'agentLogout':
$sContenido = manejarSesionActiva_agentLogout($oPaloConsola);
break;
case 'break':
$sContenido = manejarSesionActiva_agentBreak($oPaloConsola);
break;
case 'unbreak':
$sContenido = manejarSesionActiva_agentUnBreak($oPaloConsola);
break;
case 'transfer':
//$sContenido = manejarSesionActiva_agentTransfer($oPaloConsola);
$sContenido = agentTransfer($oPaloConsola);
break;
case 'viewDelivery':
$sContenido = view_delivery();
break;
case 'viewCustomer':
$sContenido = view_customer();
break;
case 'confirm_contact':
$sContenido = manejarSesionActiva_confirmContact($oPaloConsola, $estado);
break;
case 'schedule':
$sContenido = manejarSesionActiva_scheduleCall($oPaloConsola);
break;
case 'saveforms':
$sContenido = manejarSesionActiva_saveForms($oPaloConsola, $estado);
break;
case 'call2phone':
$sContenido = call2phone();
break;
case 'addCustomer':
$sContenido = addCustomer();
break;
case 'addNote':
$sContenido = addNote();
break;
case 'addExternalNote':
$sContenido = addExternalNote();
break;
case 'viewNote':
$sContenido = viewNote();
break;
case 'addDelivery':
$sContenido = addDelivery();
break;
case 'checkDeliveryPermission':
$sContenido = checkDeliveryPermission();
break;
case 'disableDelivery':
$sContenido = disableDelivery();
break;
case 'enableDelivery':
$sContenido = enableDelivery();
break;
case 'changePassword':
$sContenido = changePassword();
break;
case 'update_customer':
$sContenido = update_customer_HTML($sDirLocalPlantillas);
break;
case 'callOut':
$sContenido = callOut_HTML($sDirLocalPlantillas);
break;
case 'show_call_history':
$sContenido = refreshCallHistory();
break;
default:
if ($estado['estadofinal'] != 'logged-in') {
// Para agente no logoneado, se redirecciona a la página de login
Header('Location: ?menu=' . $module_name);
$sContenido = '';
} else {
$sContenido = manejarSesionActiva_HTML($module_name, $smarty, $sDirLocalPlantillas, $oPaloConsola, $estado);
}
break;
}
$oPaloConsola->desconectarTodo();
return $sContenido;
}
// valideerite väljad
if (empty($_POST["title"])) {
$title_error = "See väli on kohustuslik";
} else {
$title = cleanInput($_POST["title"]);
}
if (empty($_POST["note"])) {
$note_error = "See väli on kohustuslik";
} else {
$note = cleanInput($_POST["note"]);
}
// mõlemad on kohustuslikud
if ($note_error == "" && $title_error == "") {
//salvestate ab'i fn kaudu addNote
//message funktioonist
$msg = addNote($title, $note);
if ($msg != "") {
//õnnestus, teeme inputi väljad tühjaks
$title = "";
$note = "";
echo $msg;
}
}
}
function cleanInput($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
// юникод utf-8
const MIN_ID = 1000000;
const MAX_ID = 9999999;
$datadir = dirname(__FILE__) . '/notes';
switch (getParam('method')) {
case "list":
$response = readNotesList($datadir);
break;
case "get":
$response = readNote($datadir, getParam('id'), true);
break;
case "update":
$response = writeNote($datadir, getParam('id'), getParam('title'), getParam('text'));
break;
case "add":
$response = addNote($datadir, getParam('title'), getParam('text'));
break;
case "delete":
$response = deleteNote($datadir, getParam('id'));
break;
default:
error('Unknown method');
}
echo json_encode($response);
exit;
function readNotesList($datadir)
{
$notes = array();
$handle = opendir($datadir);
if ($handle) {
while (($filename = readdir($handle)) !== false) {
$input = json_decode(file_get_contents("php://input"));
//var_dump($input);
//$user_id = $_SESSION['user_id'];
//$employeeType = $_SESSION['employee_type'];
$employeeType = 'cem';
$user_id = 6;
$SR_id = intval($route['2']);
if ($route[2] == 'picked' || $route[2] == 'match' || $route[2] == 'meeting' || $route[2] == 'demo' || $route[2] == 'done' || $route[2] == 'open' || $route[2] == '24hours') {
$status = $route['2'];
serviceRequestView($status, $user_id, $db_handle);
} elseif (is_int($SR_id)) {
if ($route['3'] == 'pick') {
pickServiceRequest($SR_id, $user_id, $db_handle);
} elseif ($route['3'] == 'add_note') {
addNote($input, $SR_id, $user_id, $db_handle, $employeeType);
} elseif ($route['3'] == 'change_status') {
changeStatus($input, $SR_id, $user_id, $db_handle);
} elseif ($route['3'] == 'add_meeting') {
addMeeting($input, $SR_id, $user_id, $db_handle);
} elseif ($route['3'] == 'add_worker') {
$workerFName = $input->root->first_name;
$workerAge = $input->root->age;
$workerPhone = $input->root->phone;
$sql = "SELECT id, first_name, last_name, phone FROM bluenethack_v0.workers WHERE age='{$workerAge}' AND phone = '{$workerPhone}' AND first_name = '{$workerFName}' ;";
$worker = mysqli_query($db_handle, $sql);
$workerRow = mysqli_fetch_array($worker);
if (mysqli_num_rows($workerRow) == 0) {
//echo getcwd(); die();
include_once "/var/www/html/api_bluenet/apis/inc_workers/add_worker_function.php";
$new_worker_id = addNewWorker($input, $user_id, $db_handle);
<?php
/**
* Created by PhpStorm.
* User: Karlos
* Date: 3/10/2016
* Time: 9:00 PM
*/
session_start();
include 'Connection.php';
include '_database_access.php';
if (isset($_SESSION['username'])) {
if (isset($_POST['action'])) {
switch ($_POST['action']) {
case 'create':
addNote($conn);
break;
case 'delete':
deleteNote($conn);
break;
default:
break;
}
}
}
in service of view.php
Contains utilities for deleting and editing annotations
*******************************************************************/
include 'dbsetup.php';
include 'util.php';
if ($_GET['event'] == 'delete-tag') {
deleteTag($_GET['tag'], $_GET['highlight']);
} else {
if ($_GET['event'] == 'delete-note') {
deleteNote($_GET['note'], $_GET['highlight']);
} else {
if ($_GET['event'] == 'edit-note') {
editNote($_GET['note'], mysql_real_escape_string($_GET['text']));
} else {
if ($_GET['event'] == 'add-note') {
addNote(mysql_real_escape_string($_GET['text']), $_GET['highlight'], $_GET['user']);
} else {
if ($_GET['event'] == 'add-tags') {
addTags(mysql_real_escape_string($_GET['tags']), $_GET['highlight'], $_GET['user']);
} else {
if ($_GET['event'] == 'delete-annotation') {
deleteAnnotation($_GET['highlight']);
}
}
}
}
}
}
/** delete a tag **/
function deleteTag($tagID, $highlightID)
{
<?php
$include_path = get_include_path();
include_once $include_path . '/includes/db_functions.php';
include_once $include_path . '/includes/session_functions.php';
include_once $include_path . '/public_html/classes/AllClasses.php';
include_once $include_path . '/public_html/requests/core.php';
$requestType = filter_input(INPUT_POST, 'type', FILTER_SANITIZE_STRING);
$studentId = filter_input(INPUT_POST, 'stuid', FILTER_SANITIZE_NUMBER_INT);
$staffId = filter_input(INPUT_POST, 'staffid', FILTER_SANITIZE_NUMBER_INT);
$setId = filter_input(INPUT_POST, 'setid', FILTER_SANITIZE_NUMBER_INT);
$note = filter_input(INPUT_POST, 'note', FILTER_SANITIZE_STRING);
switch ($requestType) {
case "ADD_NOTE":
addNote($studentId, $staffId, $setId, $note);
break;
case "GET_NOTES_STAFF":
getNotesForStaff($staffId);
break;
default:
break;
}
function addNote($studentId, $staffId, $setId, $note)
{
try {
$query = "INSERT INTO TREPORTNOTES (StudentID, StaffID, GroupID, Note, Date) " . "VALUES ({$studentId}, {$staffId}, {$setId}, '{$note}', NOW())";
db_insert_query_exception($query);
} catch (Exception $ex) {
failRequest($ex->getMessage());
}
succeedRequest();
function returnBike($userId, $bike, $stand, $note = "", $force = FALSE)
{
global $db;
$bikeNum = intval($bike);
$stand = strtoupper($stand);
if ($force == FALSE) {
$result = $db->query("SELECT bikeNum FROM bikes WHERE currentUser={$userId} ORDER BY bikeNum");
$bikenumber = $result->num_rows;
if ($bikenumber == 0) {
response(_('You currently have no rented bikes.'), ERROR);
}
}
if ($force == FALSE) {
$result = $db->query("SELECT currentCode FROM bikes WHERE currentUser={$userId} and bikeNum={$bikeNum}");
} else {
$result = $db->query("SELECT currentCode FROM bikes WHERE bikeNum={$bikeNum}");
}
$row = $result->fetch_assoc();
$currentCode = sprintf("%04d", $row["currentCode"]);
$result = $db->query("SELECT standId FROM stands WHERE standName='{$stand}'");
$row = $result->fetch_assoc();
$standId = $row["standId"];
$result = $db->query("UPDATE bikes SET currentUser=NULL,currentStand={$standId} WHERE bikeNum={$bikeNum} and currentUser={$userId}");
if ($note) {
addNote($userId, $bikeNum, $note);
}
$message = '<h3>' . _('Bike') . ' ' . $bikeNum . ': <span class="label label-primary">' . _('Lock with code') . ' ' . $currentCode . '.</span></h3>';
$message .= '<br />' . _('Please') . ', <strong>' . _('rotate the lockpad to') . ' <span class="label label-default">0000</span></strong> ' . _('when leaving') . '.';
if ($note) {
$message .= '<br />' . _('You have also reported this problem:') . ' ' . $note . '.';
}
if ($force == FALSE) {
$creditchange = changecreditendrental($bikeNum, $userId);
if (iscreditenabled() and $creditchange) {
$message .= '<br />' . _('Credit change') . ': -' . $creditchange . getcreditcurrency() . '.';
}
$result = $db->query("INSERT INTO history SET userId={$userId},bikeNum={$bikeNum},action='RETURN',parameter={$standId}");
} else {
$result = $db->query("INSERT INTO history SET userId={$userId},bikeNum={$bikeNum},action='FORCERETURN',parameter={$standId}");
}
response($message);
}
{
$user_id_data = $model->getUserId($field, $value);
return $user_id_data['user_id'];
}
if (isset($_SESSION['id'])) {
$item = new Item();
if (isset($_POST['new_item_name'])) {
$list_id = $_POST['list_id'];
$user_id = userId(new Lists(), 'list_id', $list_id);
$item_name = ucwords(strtolower(rtrim($_POST['new_item_name'])));
$quantity = rtrim($_POST['new_item_quantity']) != "" ? $quantity = $_POST['new_item_quantity'] : 1;
$item->create($list_id, $user_id, $item_name, $quantity);
if ($item_name != "") {
$item_id = $item->save();
if (isset($_POST['new_item_note']) && rtrim($_POST['new_item_note']) != "") {
addNote($item_id, $user_id, $_POST['new_item_note']);
}
echo json_encode(['name' => $item_name, 'list_id' => $list_id, 'quantity' => $quantity, 'id' => $item_id]);
}
}
if (isset($_POST['delete_item'])) {
$item_id = $_POST['item_id'];
$user_id = userId($item, 'item_id', $item_id);
if ($item->delete($item_id, $user_id, $_SESSION['id'])) {
echo "true";
} else {
$_SESSION['error_message'] = "Permissions for that list have changed. Could not delete item.";
echo "false";
}
}
if (isset($_POST['edit_item']) && rtrim($_POST['edit_item_name']) != "") {
