function subtask_select(&$state, &$HTML, $rec = -1)
{
if ($rec < 0) {
//checking returned
if (!isset($_GET["row"])) {
return;
}
$rec = $_GET["row"];
//get row number
}
subtask_list($state);
//restore the record list
if (!array_key_exists($rec, $state->records)) {
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid subtask id " . $rec, true);
}
$record = $state->records[$rec];
if ($record[1] != "") {
$inactive = new DateTime($record[1]);
$diff = date_diff($state->from_date, $inactive)->days;
if ($diff < $state->columns[COL_INACTIVE]) {
$state->columns[COL_INACTIVE] = $diff;
$state->columns[COL_AGENT] = "subtask";
}
$record[0] .= "<br>(inactive as of " . $record[1] . ")";
}
$state->subtask_id = $rec;
$state->msgStatus = "";
$HTML .= "cell = document.getElementById('ST_" . $state->row . "');\n";
$HTML .= "cell.innerHTML = '" . $record[0] . "';\n";
}
function subtask_select($ID = -1)
{
global $_STATE;
if ($ID < 0) {
//not yet selected
subtask_list();
//restore the record list
if (!array_key_exists(strval($_POST["selSubtask"]), $_STATE->records)) {
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid subtask id " . $_POST["selSubtask"]);
//we're being spoofed
}
$ID = intval($_POST["selSubtask"]);
}
$_STATE->record_id = $ID;
}
function subtask_select($ID = -1)
{
global $_DB, $_STATE;
if ($ID < 0) {
//not yet selected
subtask_list();
//restore the record list
if (!array_key_exists(strval($_POST["selSubtask"]), $_STATE->records)) {
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid subtask id " . $_POST["selSubtask"]);
//we're being spoofed
}
$ID = intval($_POST["selSubtask"]);
}
$_STATE->record_id = $ID;
$sql = "SELECT name, description FROM " . $_DB->prefix . "a14_subtask\n\t\t\tWHERE subtask_id=" . $_STATE->record_id . ";";
$row = $_DB->query($sql)->fetchObject();
$_STATE->forwho = $row->name . ": " . $row->description;
//PROPERTIES wants to see this
}
function subtask_select(&$state, &$HTML, $rec = -1)
{
if ($rec < 0) {
//checking returned
if (!isset($_GET["row"])) {
return;
}
$rec = strval($_GET["row"]);
}
subtask_list($state);
//restore the record list
if (!array_key_exists($rec, $state->records)) {
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid subtask id " . $rec, true);
}
$record = $state->records[$rec];
if ($record[1] != "") {
$inactive = new DateTime($record[1]);
if ($inactive < $state->inactive_date) {
$state->inactive_date = $inactive;
$state->max_column = date_diff($state->from_date, $inactive)->days - 1;
//0 rel
}
$record[0] .= "<br>(inactive as of " . $record[1] . ")";
}
$state->subtask_id = $rec;
$state->msgStatus = "";
$HTML .= "cell = document.getElementById('ST_0');\n";
$HTML .= "cell.innerHTML = '" . $record[0] . "';\n";
}
function change_subtask(&$state)
{
global $_DB;
include_once "lib/callback/subtask.php";
subtask_list($state);
//restore the record list
if (!array_key_exists($state->subtask_id, $state->records)) {
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid subtask id " . $state->subtask_id, true);
}
log_list($state, $state->row);
//find this row's records
$record = reset($state->records);
if ($state->subtask_id == $record["subtask_id"]) {
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 subtask_idref=" . $state->subtask_id . " WHERE timelog_id=" . $ID . ";";
$_DB->exec($sql);
}
}
