function load() { include 'model/discussion.php'; $arrMessage = discussion_get(); $results = array('arrMessage' => $arrMessage['discussions']); return $results; }
function load() { $params = array(); $params['discussion_id'] = $_GET['id']; include 'model/discussion.php'; include 'model/comment.php'; $arrMessage = discussion_get($params); $arrComment = comment_get($params); $results = array('arrMessage' => $arrMessage['discussions']); $results['creator'] = $arrMessage['users'][0]['first_name'] . " " . $arrMessage['users'][0]['last_name']; $results['arrComment'] = array(); for ($i = 0; $i < count($arrComment['comments']); $i++) { $results['arrComment'][$i] = $arrComment['comments'][$i]; $results['arrComment'][$i]['name'] = $arrComment['users'][$i]['first_name'] . " " . $arrComment['users'][$i]['last_name']; } return $results; }
function requirement_email($project_id, $req_id, $recipients, $action, $discussion_id = null) { $display_generic_info = true; $display_generic_url = true; # Link to the req detail page $generic_url = RTH_URL . "login.php?project_id={$project_id}&page=requirement_detail_page.php&req_id={$req_id}"; $username = session_get_username(); $project_name = session_get_project_name(); $req_id = util_pad_id($req_id); $user_details = user_get_name_by_username($username); $first_name = $user_details[USER_FNAME]; $last_name = $user_details[USER_LNAME]; $rows_requirement = requirement_get_detail($project_id, $req_id); $row_requirement = $rows_requirement[0]; $req_version_id = $row_requirement[REQ_VERS_UNIQUE_ID]; $req_rec_or_file = $row_requirement[REQ_REC_FILE]; $req_name = $row_requirement[REQ_FILENAME]; $req_detail = $row_requirement[REQ_VERS_DETAIL]; $req_reason_for_change = $row_requirement[REQ_VERS_REASON_CHANGE]; $req_version_status = $row_requirement[REQ_VERS_STATUS]; $req_area_covered = $row_requirement[REQ_AREA_COVERAGE]; $req_doc_type = $row_requirement[REQ_DOC_TYPE_NAME]; $req_version = $row_requirement[REQ_VERS_VERSION]; # REQ FUNCTIONALITY $rows_functions = requirement_get_functionality($project_id, $req_id); $req_functionality = ""; foreach ($rows_functions as $function) { $req_functionality .= $function . ", "; } $req_functionality = trim($req_functionality, ", "); # CREATE EMAIL SUBJECT AND MESSAGE switch ($action) { case "updated": $subject = "RTH: Requirement Updated in {$project_name}"; $message = "Requirement {$req_name} has been updated by {$first_name} {$last_name}\n" . NEWLINE; break; case "new_version": $subject = "RTH: Requirement Updated in {$project_name}"; $message = "A new version of Requirement {$req_name} has been created by {$first_name} {$last_name}\n" . NEWLINE; break; case "delete": $display_generic_info = false; $display_generic_url = false; $url = RTH_URL . "login.php?project_id={$project_id}&page=requirement_page.php"; $subject = "RTH: Requirement Deleted in {$project_name}"; $message = "Requirement {$req_name} has been deleted by {$first_name} {$last_name}\n" . NEWLINE; $message .= "Click the following link to view Requirements in {$project_name}:" . NEWLINE; $message .= "{$url}\n" . NEWLINE; break; case "lock": $subject = "RTH: Requirement Locked in {$project_name}"; $message = "Requirement {$req_name} has been locked by {$first_name} {$last_name}\n" . NEWLINE; break; case "unlock": $subject = "RTH: Requirement Unlocked in {$project_name}"; $message = "Requirement {$req_name} has been unlocked by {$first_name} {$last_name}\n" . NEWLINE; break; case "edit_children": # Get requirement children //$rows_children = requirement_get_children($req_id); $generic_url .= "&tab=1"; $subject = "RTH: Requirement Updated in {$project_name}"; $message = "The children of Requirement {$req_name} have been edited by {$first_name} {$last_name}\n" . NEWLINE; break; case "edit_test_assoc": # Get related tests //$assoc_tests = requirement_get_test_relationships($req_id); $generic_url .= "&tab=2"; $subject = "RTH: Requirement Updated in {$project_name}"; $message = "The Tests related to Requirement {$req_name} have been edited by {$first_name} {$last_name}\n" . NEWLINE; break; case "edit_release_assoc": # Get related releases //requirement_get_assoc_releases($s_req_version_id) $generic_url .= "&tab=4"; $subject = "RTH: Requirement Updated in {$project_name}"; $message = "The Releases related to Requirement {$req_name} have been edited by {$first_name} {$last_name}\n" . NEWLINE; break; case "new_discussion": # GET LAST DISCUSSION $rows_discussion = discussion_get($req_id); foreach ($rows_discussion as $row_discussion) { $discussion_subject = $row_discussion[DISC_SUBJECT]; } $generic_url .= "&tab=3"; $subject = "RTH: New Requirement Discussion in {$project_name}"; $message = "A new discussion has been added to Requirement {$req_name} by {$first_name} {$last_name}\n" . NEWLINE; $message .= "" . lang_get("subject") . ": {$discussion_subject}\n" . NEWLINE; break; case "new_post": # GET DISCUSSION $row_discussion = discussion_get_detail($discussion_id); $discussion_subject = $row_discussion[DISC_SUBJECT]; $url = RTH_URL . "login.php?project_id={$project_id}&page=requirement_discussion_page.php&discussion_id={$discussion_id}"; $subject = "RTH: Discussion {$discussion_subject} in {$project_name}"; $message = "A new post has been added to Discussion {$discussion_subject} by {$first_name} {$last_name}\n" . NEWLINE; $message .= "Click the following link to view the discussion:\n" . NEWLINE; $message .= "{$url}\n" . NEWLINE; break; case "close_discussion": $display_generic_info = false; $display_generic_url = false; # GET DISCUSSION $row_discussion = discussion_get_detail($discussion_id); $discussion_subject = $row_discussion[DISC_SUBJECT]; $url = RTH_URL . "login.php?project_id={$project_id}&page=requirement_discussion_page.php&discussion_id={$discussion_id}"; $subject = "RTH: Discussion {$discussion_subject} in {$project_name}"; $message = "Discussion {$discussion_subject} has been closed by {$first_name} {$last_name}\n" . NEWLINE; $message .= "Click the following link to view the discussion:" . NEWLINE; $message .= "{$url}\n" . NEWLINE; break; } # Generic link to requirement detail page if the $url variable has been set if ($display_generic_url) { $message .= "Click the following link to view the Requirement:" . NEWLINE; $message .= "{$generic_url}\n" . NEWLINE; } if ($display_generic_info) { $message .= "" . lang_get("project_name") . ": {$project_name}" . NEWLINE; $message .= "" . lang_get("req_id") . ": {$req_id}" . NEWLINE; $message .= "" . lang_get("req_version") . ": {$req_version}" . NEWLINE; $message .= "" . lang_get("req_name") . ": {$req_name}" . NEWLINE; $message .= "" . lang_get("req_detail") . ": {$req_detail}" . NEWLINE; $message .= "" . lang_get("req_status") . ": {$req_version_status}" . NEWLINE; $message .= "" . lang_get("req_area_covered") . ": {$req_area_covered}" . NEWLINE; $message .= "" . lang_get("req_functionality") . ": {$req_functionality}" . NEWLINE; $message .= "" . lang_get("req_doc_type") . ": {$req_doc_type}\n" . NEWLINE; } # Convert any html entities stored in the DB back to characters. $message = util_unhtmlentities($message); email_send($recipients, $subject, $message); }
print "</tr>" . NEWLINE; } print "</table>" . NEWLINE; } else { print "<div align=center>" . NEWLINE; print lang_get('no_related_tests'); print "</div>" . NEWLINE; } print "</td>" . NEWLINE; print "</tr>" . NEWLINE; print "</table>" . NEWLINE; break; # DISCUSSIONS # DISCUSSIONS case 3: $rows_discussion = discussion_get($s_req_id); if (!empty($rows_discussion)) { print "<table class=width100 rules=cols>" . NEWLINE; print "<tr>" . NEWLINE; print "<th>" . lang_get('subject') . "</th>" . NEWLINE; print "<th>" . lang_get('author') . "</th>" . NEWLINE; print "<th>" . lang_get('date_started') . "</th>" . NEWLINE; print "<th>" . lang_get('num_posts') . "</th>" . NEWLINE; print "<th>" . lang_get('status') . "</th>" . NEWLINE; print "</tr>" . NEWLINE; foreach ($rows_discussion as $row_discussion) { $row_style = html_tbl_alternate_bgcolor($row_style); print "<tr class='{$row_style}'>" . NEWLINE; print "<td><a href='requirement_discussion_page.php?discussion_id=" . $row_discussion[DISC_ID] . "'>" . $row_discussion[DISC_SUBJECT] . "</a></td>" . NEWLINE; print "<td>" . $row_discussion[DISC_AUTHOR] . "</td>" . NEWLINE; print "<td>" . $row_discussion[DISC_DATE] . "</td>" . NEWLINE;