function activity_select(&$state, &$HTML) { if (!isset($_GET["row"])) { return; } $rec = strval($_GET["row"]); $state->activity_id = $rec; $state->msgStatus = ""; if ($rec != 0) { activity_list($state); //restore the record list if (!array_key_exists($rec, $state->records)) { throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid activity " . $rec, true); } $HTML .= "cell = document.getElementById('AT_0');\n"; $HTML .= "cell.innerHTML = '" . $state->records[$rec] . "';\n"; } }
function change_activity(&$state) { global $_DB; if ($state->activity_id == 0) { //creating a new one add_activity($state); } else { activity_list($state); //restore the record list if (!array_key_exists($state->activity_id, $state->records)) { throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid activity id " . $state->activity_id, true); } } log_list($state, $state->row); //find this row's records $record = reset($state->records); $old_activity = $record["activity_id"]; if ($state->activity_id == $old_activity) { return; } foreach ($state->records as $ID => $record) { if ($record["column"] < $state->columns[COL_OPEN]) { continue; } $sql = "UPDATE " . $_DB->prefix . "b00_timelog\n\t\t\t\tSET activity_idref=" . $state->activity_id . " WHERE timelog_id=" . $ID . ";"; $_DB->exec($sql); } $sql = "SELECT COUNT(*) AS count FROM " . $_DB->prefix . "b00_timelog WHERE activity_idref=" . $old_activity . ""; $stmt = $_DB->query($sql); if ($stmt->fetchObject()->count == 0) { $sql = "DELETE FROM " . $_DB->prefix . "b02_activity WHERE activity_id=" . $old_activity . ""; $_DB->exec($sql); } $stmt->closeCursor(); }