}
$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);
}
