function stopRecorder()
{
## stop running recording |
global $kga, $conn;
$table = $kga['server_prefix'] . "zef";
$last_task = get_event_last();
// aktuelle vorgangs-ID auslesen
$filter['zef_ID'] = $last_task['zef_ID'];
$rounded = roundTimespan($last_task['zef_in'], time(), $kga['conf']['roundPrecision']);
$values['zef_in'] = $rounded['start'];
$values['zef_out'] = $rounded['end'];
$values['zef_time'] = $values['zef_out'] - $values['zef_in'];
$query = MySQL::BuildSQLUpdate($table, $values, $filter);
logfile($query);
return $conn->Query($query);
}
/**
* performed when the stop buzzer is hit.
* Checks which record is currently recording and
* writes the end time into that entry.
* if the measured timevalue is longer than one calendar day
* it is split up and stored in the DB by days
*
* @global array $kga kimai-global-array
* @param integer $user ID of user
* @author th
*
*/
function stopRecorder()
{
## stop running recording
global $kga, $pdo_conn;
$p = $kga['server_prefix'];
$last_task = get_event_last();
// aktuelle vorgangs-ID auslesen
$zef_ID = $last_task['zef_ID'];
$rounded = roundTimespan($last_task['zef_in'], time(), $kga['conf']['roundPrecision']);
$difference = $rounded['end'] - $rounded['start'];
$pdo_query = $pdo_conn->prepare("UPDATE {$p}zef SET zef_in = ?, zef_out = ?, zef_time = ? WHERE zef_ID = ?;");
$pdo_query->execute(array($rounded['start'], $rounded['end'], $difference, $zef_ID));
}
