$row['activity_id'])); } $sql = 'DELETE FROM activities WHERE activity_id = ' . ((int) $args['id']); mysql_query($sql); } function process_sample_edit($args) { $sql = 'SELECT wc_id, activity_id, log_id, wc_offset FROM windowclassifications'; $res = mysql_query($sql); $acs = getActivityArray(); while ($row = mysql_fetch_assoc($res)) { $name = 'value_' . $row['log_id'] . '_' . $row['wc_offset']; if (isset($args[$name])) { if ((int) $args[$name] == (int) $row['activity_id']) { unset($args[$name]); } else { mysql_query('UPDATE windowclassifications SET activity_id = ' . ((int) $args[$name]) . ' WHERE wc_id = ' . $row['wc_id']); } } } foreach ($args as $name => $val) { if ($acs[$val] == 'UNCLASSIFIED/PENDING') { continue; } list($value, $log, $offset) = explode('_', $name); mysql_query('INSERT INTO windowclassifications (activity_id, log_id, wc_offset) VALUES ('. ((int) $val) . ', ' . ((int) $log) . ', ' . ((int) $offset) . ')'); } } function process_export($args) { $acs = getActivityArray(); $sql = 'SELECT wc_offset, activity_id, log_data FROM activities NATURAL JOIN windowclassifications NATURAL JOIN sensorlogger WHERE log_statuscode = 1 AND (0'; foreach ($acs as $id => $name) { if (substr($name, 0, 10) == 'CLASSIFIED') { $sql .= ' OR activity_id = ' . $id; } } $sql .= ')'; $res = mysql_query($sql); header('Content-type: text/plain'); header('Content-disposition: attachment; filename=data.txt'); while ($row = mysql_fetch_assoc($res)) { echo 'Activity: ', $acs[$row['activity_id']], "\n"; $data = array_slice(explode("\n", $row['log_data']), $row['wc_offset'], 128); echo implode("\n", $data); echo "\n"; } exit; } if (isset($_POST['action'])) { $args = array(); $action = str_replace('.', '_', $_POST['action']) . '_'; foreach ($_POST as $k => $v) { if (substr($k, 0, strlen($action)) == $action) { $args[substr($k, strlen($action))] = $v; } } call_user_func('process_' . str_replace('.', '_', $_POST['action']), $args); header('Location: /android/admin.php'); exit; } # ------------------- End of form handling ---------------------- $acs = getActivityArray(); ?>

Activity management

Add an activity

/

Delete an activity

Export

Sample management

'; while ($row = mysql_fetch_assoc($res)) { $sql2 = 'SELECT wc_offset, activity_id FROM windowclassifications WHERE log_id = ' . $row['log_id']; $res2 = mysql_query($sql2); $wcs = array(); while ($row2 = mysql_fetch_assoc($res2)) { $wcs[(int) $row2['wc_offset']] = (int) $row2['activity_id']; } $points = 0; echo ''; foreach ($row as $k => $v) { echo ''; } echo '
', $k, '', $k == 'log_data' ? ($points = count(explode("\n", $v))) . ' line(s)' : nl2br(htmlentities($v)), '
'; echo ''; echo ''; echo '
    '; for ($i = 0; $i + 128 < $points; $i += 128) { echo '
  1. '; echo ''; echo '
  2. '; } echo '
'; echo '
'; echo ''; echo '
'; echo '
'; echo '
    '; for ($i = 64; $i + 128 < $points; $i += 128) { echo '
  1. '; echo ''; echo '
  2. '; } echo '
'; echo ''; echo ''; } echo ''; ?>