Example #1
0
function load()
{
    include 'model/discussion.php';
    $arrMessage = discussion_get();
    $results = array('arrMessage' => $arrMessage['discussions']);
    return $results;
}
Example #2
0
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;