1<?php 2# --------------------------------------------------------------------- 3# rth is a requirement, test, and bugtracking system 4# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net 5# This program is distributed under the terms and conditions of the GPL 6# See the README and LICENSE files for details 7#---------------------------------------------------------------------- 8# --------------------------------------------------------------------- 9# Requirement Version View Page 10# 11# $RCSfile: requirement_version_view.php,v $ $Revision: 1.2 $ 12# --------------------------------------------------------------------- 13 14include"./api/include_api.php"; 15 16 17$page = basename(__FILE__); 18#### Change to page that form is submitted to or hyperlinks link to #### 19$action_page = 'requirement_action.php'; 20$num = 0; 21$project_properties = session_get_project_properties(); 22$project_name = $project_properties['project_name']; 23 24html_window_title(); 25 26auth_authenticate_user(); 27 28html_print_body(); 29html_page_title($project_name ." - REQUIREMENTS"); 30html_page_header( $db, $project_name ); 31html_print_menu(); 32 33#### Change to api submenu function for this page type #### 34requirement_menu_print ($page); 35 36error_report_check( $_GET ); 37 38print"<br>"; 39 40$tbl_req = REQ_TBL; 41$f_req_id = $tbl_req .".". REQ_ID; 42$f_req_filename = $tbl_req .".". REQ_FILENAME; 43$f_req_area_covered = $tbl_req .".". REQ_AREA_COVERED; 44$f_req_type = $tbl_req .".". REQ_TYPE; 45 46$tbl_req_ver = REQ_VERS_TBL; 47$f_req_ver_uid = $tbl_req_ver .".". REQ_VERS_UNIQUE_ID; 48$f_req_ver_req_id = $tbl_req_ver .".". REQ_VERS_REQ_ID; 49$f_req_ver_version = $tbl_req_ver .".". REQ_VERS_VERSION; 50$f_req_ver_timestamp = $tbl_req_ver .".". REQ_VERS_TIMESTAMP; 51$f_req_ver_uploaded_by = $tbl_req_ver .".". REQ_VERS_UPLOADED_BY; 52$f_req_ver_filename = $tbl_req_ver .".". REQ_VERS_FILENAME; 53$f_req_ver_comments = $tbl_req_ver .".". REQ_VERS_COMMENTS; 54$f_req_ver_status = $tbl_req_ver .".". REQ_VERS_STATUS; 55$f_req_ver_detail = $tbl_req_ver .".". REQ_VERS_DETAIL; 56 57 58$query = "SELECT $f_req_filename, $f_req_id, $f_req_area_covered, $f_req_ver_status, $f_req_type, $f_req_ver_version, $f_req_ver_uploaded_by, $f_req_ver_timestamp, $f_req_ver_uid, $f_req_ver_filename, $f_req_ver_comments, $f_req_ver_detail FROM $tbl_req INNER JOIN $tbl_req_ver ON $f_req_id = $f_req_ver_req_id WHERE $f_req_ver_uid = '$req_version_id'"; 59#print("query= $query"); 60$recordSet = $db->Execute($query); 61$row = $recordSet->FetchRow(); 62$num = $recordSet->NumRows(); 63 64if( $num ) { 65 66 print"<br>"; 67 68 $req_filename = $row[REQ_FILENAME]; 69 $req_area = $row[REQ_AREA_COVERED]; 70 $req_type = $row[REQ_TYPE]; 71 $req_status = $row[REQ_VERS_STATUS]; 72 $req_version = $row[REQ_VERS_VERSION]; 73 $req_uploaded_by = $row[REQ_VERS_UPLOADED_BY]; 74 $req_timestamp = $row[REQ_VERS_TIMESTAMP]; 75 $req_detail = $row[REQ_VERS_DETAIL]; 76 77 print"<TABLE cols=2 border=1 rules=all WIDTH=80% cellspacing=0 cellpadding=2 ALIGN=CENTER>"; 78 79 //<!-- Title --> 80 print"<TR><TD align=left colspan=4 bgcolor=#99CCFF bordercolor=#FFFFFF><B>Req Version</B></TD></TR>"; 81 82 //<!-- REQUIREMENT NAME--> 83 print"<TR>"; 84 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF NOWRAP>Requirement Name</TD>"; 85 print"<TD align=left>$req_filename</TD>"; 86 print"</TR>"; 87 88 print"<TR>"; 89 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Area Covered</TD>"; 90 print"<TD align=left>$req_area</TD>"; 91 print"</TR>"; 92 93 print"<TR>"; 94 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Requirement Type</TD>"; 95 print"<TD align=left>$req_type</TD>"; 96 print"</TR>"; 97 98 print"<TR>"; 99 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Requirement Status</TD>"; 100 print"<TD align=left>$req_status</TD>"; 101 print"</TR>"; 102 103 print"<TR>"; 104 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Version</TD>"; 105 print"<TD align=left>$req_version</TD>"; 106 print"</TR>"; 107 108 print"<TR>"; 109 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Author</TD>"; 110 print"<TD align=left>$req_uploaded_by</TD>"; 111 print"</TR>"; 112 113 print"<TR>"; 114 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>TimeStamp</TD>"; 115 print"<TD align=left>$req_timestamp</TD>"; 116 print"</TR>"; 117 118 119 print"<TR>"; 120 print"<TD ALIGN=right bgcolor=#99CCFF bordercolor=#FFFFFF>Detail</TD>"; 121 print"<TD>$req_detail</TD>"; 122 print"</TR>"; 123 124 print"</table>"; 125 126} 127else{ 128 print("<H3>There are either no Requirements that meet your search criteria or none associated to $s_project_name.</H3>\n"); 129} 130 131# --------------------------------------------------------------------- 132# $Log: requirement_version_view.php,v $ 133# Revision 1.2 2006/02/24 11:33:08 gth2 134# minor bug fixes and enhancements for 1.5.1 release - gth 135# 136# Revision 1.1.1.1 2005/11/30 23:00:58 gth2 137# importing initial version - gth 138# 139# --------------------------------------------------------------------- 140?>