if ($_GET["newTimeSheet_projectID"] && !$db->qr("SELECT * FROM projectPerson WHERE personID = %d AND projectID = %d", $current_user->get_id(), $_GET["newTimeSheet_projectID"])) {
alloc_error("You are not a member of the project (id:" . page::htmlentities($_GET["newTimeSheet_projectID"]) . "), please get a manager to add you to the project.");
}
$db->query($query);
while ($db->row()) {
$project_array[$db->f("projectID")] = $db->f("projectName");
}
$TPL["timeSheet_projectName"] = $project_array[$projectID];
$TPL["timeSheet_projectID"] = $projectID;
$TPL["taskID"] = $_GET["taskID"];
// Get the project record to determine which button for the edit status.
if ($projectID != 0) {
$project = new project();
$project->set_id($projectID);
$project->select();
$projectManagers = $project->get_timeSheetRecipients();
if (!$projectManagers) {
$TPL["managers"] = "N/A";
$TPL["timeSheet_dateSubmittedToManager"] = "N/A";
$TPL["timeSheet_approvedByManagerPersonID_username"] = "******";
} else {
count($projectManagers) > 1 and $TPL["manager_plural"] = "s";
$people =& get_cached_table("person");
foreach ($projectManagers as $pID) {
$TPL["managers"] .= $commar . $people[$pID]["name"];
$commar = ", ";
}
}
$clientID = $project->get_value("clientID");
$projectID = $project->get_id();
// Get client name
