// Convert Date to a timestamp
$_CLEAN['start_date'] = pm_convertdate($_CLEAN['start_date']);
$_CLEAN['estimated_end_date'] = pm_convertdate($_CLEAN['estimated_end_date']);
$_CLEAN['actual_end_date'] = pm_convertdate($_CLEAN['actual_end_date']);
$_CLEAN['planned_end_date'] = pm_convertdate($_CLEAN['planned_end_date']);
$_CLEAN['last_updated_date'] = pm_getdate();
$_CLEAN['tid'] = $id;
$parent_task = DB_getItem($_TABLES['prj_tasks'], 'parent_task', "tid={$id}");
$_CLEAN['progress'] = $_CLEAN['progress'] < 0 ? 0 : $_CLEAN['progress'] > 100 ? 100 : $_CLEAN['progress'];
prj_updateTask($_CLEAN);
// Update the new record values
if (!empty($resource)) {
DB_query("DELETE FROM {$_TABLES['prj_task_users']} WHERE tid={$id} AND role='o'");
DB_query("INSERT INTO {$_TABLES['prj_task_users']} (tid, uid, role) VALUES ({$id}, {$_CLEAN['resource']}, 'o')");
}
prj_statuslog($pid, $_USER[uid], $id, $_CLEAN['changelog_entry'], $_CLEAN['last_updated_date'], "{$_TABLES['prj_statuslog']}");
$logentry = "Task ID-" . $id . " was editted";
prg_updateAuditLog($logentry);
$results = DB_query("SELECT parent_task FROM {$_TABLES['prj_tasks']} WHERE tid={$id}");
$nrows = DB_numRows($results);
if ($nrows != "0") {
list($newtid) = DB_fetchArray($results);
DB_query("UPDATE {$_TABLES['prj_tasks']} SET last_updated_date={$_CLEAN['last_updated_date']} WHERE tid={$newtid}");
}
DB_query("UPDATE {$_TABLES['prj_tasks']} SET last_updated_date={$_CLEAN['last_updated_date']} WHERE tid={$id}");
DB_query("UPDATE {$_TABLES['prj_projects']} SET last_updated_date={$_CLEAN['last_updated_date']} WHERE pid={$pid}");
if ($_CLEAN['make_private_enabled_flag'] != 'on') {
prj_addTrickleDownTaskPerms($pid, $id);
} else {
prj_addTeamMemberTaskPerms($pid, $id);
}
//add 1 week to the start date...
}
if ($estimateddate < $startdate) {
$estimateddate = $startdate + 604800;
//add 1 week to the start date...
}
$sql = "UPDATE {$_TABLES['prj_projects']} SET name='{$_CLEAN['name']}', ";
$sql .= "description='{$_CLEAN['description']}', is_private_project_flag='{$_CLEAN['private']}', ";
$sql .= "is_template_project_flag='{$_CLEAN['template']}', keywords='{$_CLEAN['keywords']}', ";
$sql .= "priority_id={$_CLEAN['priority']}, status_id={$_CLEAN['status']}, ";
$sql .= "objective_id={$_CLEAN['objective']}, progress_id={$_CLEAN['progress']}, ";
$sql .= "start_date={$startdate}, estimated_end_date={$estimateddate}, percent_completion={$_CLEAN['percent']}, ";
$sql .= "last_updated_date={$lastupdated}, actual_end_date={$actualdate}, ";
$sql .= "notification_enabled_flag='{$_CLEAN['notification']}' WHERE pid={$id}";
DB_query($sql);
prj_statuslog($id, $uid, '', $_CLEAN['changelog_entry'], $lastupdated, "{$_TABLES['prj_statuslog']}");
// Instead of trying to determine what items have changed - delete all and create new ones
if (is_array($_CLEAN['department'])) {
DB_query("DELETE FROM {$_TABLES['prj_department']} WHERE pid={$id}");
for ($i = 0; $i < count($_CLEAN['department']); $i++) {
DB_query("INSERT INTO {$_TABLES['prj_department']} (pid, department_id) VALUES ({$id}, {$_CLEAN['department'][$i]})");
}
}
if (is_array($_CLEAN['location'])) {
DB_query("DELETE FROM {$_TABLES['prj_location']} WHERE pid={$id}");
for ($i = 0; $i < count($_CLEAN['location']); $i++) {
DB_query("INSERT INTO {$_TABLES['prj_location']} (pid, location_id) VALUES ({$id}, {$_CLEAN['location'][$i]})");
}
}
if (is_array($_CLEAN['category'])) {
DB_query("DELETE FROM {$_TABLES['prj_category']} WHERE pid={$id}");
