} $done = false; $data = array(); $errors = array(); $title = 'iSENSE Management'; $action_template = 'admin/index.tpl'; $tmpusr = $session->getUser(); if ($tmpusr['administrator'] == 1) { switch ($action) { case "fixvisualizationexp": $sql = "SELECT * FROM visualizationSessionMap"; $maps = $db->query($sql); foreach ($maps as $map) { $sid = $map['session_id']; $vid = $map['vis_id']; $eid = getSessionExperimentId($sid); $sqlUp = "UPDATE visualizations SET experiment_id = '{$eid}' WHERE vis_id = '{$vid}'"; $r = $db->query($sqlUp); } break; case "fixsessionescape": $sql = "SELECT sessions.session_id, sessions.name, sessions.description FROM sessions"; $data = $db->query($sql); $fixes = array(); foreach ($data as $datum) { $sid = $datum['session_id']; $title = $datum['name']; $desc = $datum['description']; if (strpos($title, "\\") !== FALSE || strpos($desc, "\\") !== FALSE) { while (strstr($title, '\\')) { $title = stripslashes($title);
} $values = array('name' => safeString($_POST['session_name']), 'description' => safeString($_POST['session_description']), 'city' => $city, 'street' => $street, 'finalized' => $hidden_val); if ($city != $org_values['city'] || $street != $org_values['street']) { $cords = getLatAndLon($street, $city, "United States"); $lat = $cords[1]; $lon = $cords[0]; $values['latitude'] = $lat; $values['longitude'] = $lon; } updateSession($sid, $values); $created = true; $title = "Successfully Edited Session"; } // Process the images for displayi global $db; $images = array(); $images = getImagesForSession($sid); $image_urls = array(); if ($images) { foreach ($images as $img) { array_push($image_urls, array('source' => $img['provider_url'], 'set_url' => $img['provider_url'])); } } $smarty->assign('pictures', $image_urls); $smarty->assign('sid', $sid); $smarty->assign('id', getSessionExperimentId($sid)); $smarty->assign('created', $created); $smarty->assign('user', $session->getUser()); $smarty->assign('title', $title); $smarty->assign('content', $smarty->fetch('session-edit.tpl')); $smarty->display('skeleton.tpl');
$flot_enabled = isset($_GET['flot']) ? $_GET['flot'] : false; $state = ""; if (isset($_GET['state'])) { $state = $_GET['state']; } if (isset($_GET['sessions'])) { $aid = isset($_GET['aid']) ? safeString($_GET['aid']) : -1; $sessionIds = explode(" ", $_GET['sessions']); if ($flot_enabled == false) { // Get experiment Id for each session foreach ($sessionIds as $sid) { $eid = getSessionExperimentId($sid); $data[] = array('experimentId' => $aid != -1 ? $aid : $eid, 'sessionId' => $sid, 'fields' => getFields($eid), 'meta' => array(getSession($sid)), 'data' => getData($eid, $sid)); } } else { $eid = getSessionExperimentId($sessionIds[0]); $data['id'] = $eid; $data['meta'] = getExperiment($eid); $data['sessions'] = array(); foreach ($sessionIds as $sid) { $x = array(); $x['id'] = $sid; $x['meta'] = array(getSession($sid)); $x['data'] = getData($eid, $sid); $x['fields'] = getFields($eid); $x['visibility'] = true; $data['sessions'][] = $x; } } } else { if (isset($_GET['vsessions'])) {
} public function is_visible() { return $this->visibility; } public function setVisibility($v) { $this->visibility = $v; } } if (isset($_REQUEST['sessions'])) { //Create Data object $data = new Data(); //Load session data $sessions = explode(" ", $_REQUEST['sessions']); $data->eid = getSessionExperimentId($sessions[0]); //Load fields into Data object $fields = getFields($data->eid); //print_r($fields); foreach ($fields as $index => $field) { $data->fields[$index] = new Field($field['field_id'], $field['field_name'], $field['type_id'], $field['unit_id'], $field['type_name'], $field['unit_name'], $field['unit_abbreviation']); } //Determine witch vises are relevant $data->setRelVis(); //Load sessions into Data object foreach ($sessions as $index => $ses) { $data->sessions[$index] = new Ses(); $data->sessions[$index]->sid = $ses; $data->sessions[$index]->meta = getSession($ses); $data->sessions[$index]->data = getData($data->eid, $ses); }