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