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']) != "") {