function show_timeSheetItems($template_name) { global $date_to_view; $current_user =& singleton("current_user"); global $TPL; $query = prepare("SELECT * \n FROM timeSheetItem \n LEFT JOIN timeSheet ON timeSheetItem.timeSheetID = timeSheet.timeSheetID\n LEFT JOIN project ON timeSheet.projectID = project.projectID\n WHERE dateTimeSheetItem='%s'\n AND timeSheet.personID=%d", date("Y-m-d", $date_to_view), $current_user->get_id()); $db = new db_alloc(); $db->query($query); while ($db->next_record()) { $timeSheetItem = new timeSheetItem(); $timeSheetItem->read_db_record($db); $timeSheetItem->set_values(); if ($timeSheetItem->get_value("unit") == "Hour") { $TPL["daily_hours_total"] += $timeSheetItem->get_value("timeSheetItemDuration"); } $project = new project(); $project->read_db_record($db); $project->set_values(); if ($project->get_value("projectShortName")) { $TPL["item_description"] = $project->get_value("projectShortName"); } else { $TPL["item_description"] = $project->get_value("projectName"); } include_template($template_name); } }
$project->set_id($projectID); $project->select() || alloc_error("Could not load project {$projectID}"); } else { // Creating a new record $project->read_globals(); $projectID = $project->get_id(); $project->select(); } // Comments $TPL["comment_buttons"] = "<input type=\"submit\" name=\"comment_save\" value=\"Save Comment\">"; // if someone uploads an attachment if ($_POST["save_attachment"]) { move_attachment("project", $projectID); alloc_redirect($TPL["url_alloc_project"] . "projectID=" . $projectID . "&sbs_link=attachments"); } $project->set_values("project_"); $db = new db_alloc(); $clientID = $project->get_value("clientID") or $clientID = $_GET["clientID"]; $client = new client(); $client->set_id($clientID); $client->select(); $client->set_tpl_values("client_"); // If a client has been chosen if ($clientID) { $query = prepare("SELECT * \n FROM clientContact\n WHERE clientContact.clientID = %d AND clientContact.primaryContact = true", $clientID); $db->query($query); $cc = new clientContact(); $cc->read_db_record($db); $one = $client->format_address("postal"); $two = $client->format_address("street"); $thr = $cc->format_contact();