$test_type = $row[TEST_TESTTYPE];
$area_tested = $row[TEST_AREA_TESTED];
$priority = $row[TEST_PRIORITY];
$test_ts_assoc_id = $row[TEST_TS_ASSOC_ID];
$assigned_to = $row[TEST_TS_ASSOC_ASSIGNED_TO];
$comments = $row[TEST_TS_ASSOC_COMMENTS];
$testset_assoc_status = $row[TEST_TS_ASSOC_STATUS];
# Build list of records
if (empty($records)) {
$records = "{$test_id} => '{$testset_assoc_status}'";
} else {
$records .= ", {$test_id} => '{$testset_assoc_status}'";
}
$row_style = html_tbl_alternate_bgcolor($row_style);
print "<tr class='{$row_style}'>" . NEWLINE;
if (session_records_ischecked("testset_copy", $test_id, $testset_assoc_status)) {
print "<td><input type='checkbox' name='row_{$test_id}' value='{$testset_assoc_status}' checked></td>" . NEWLINE;
} else {
print "<td><input type='checkbox' name='row_{$test_id}' value='{$testset_assoc_status}'></td>" . NEWLINE;
}
print "<td align='center'>{$display_test_id}</td>" . NEWLINE;
print "<td class='left' nowrap>" . html_print_testtype_icon($manual, $automated) . "</td>" . NEWLINE;
print "<td class='left' nowrap>{$test_name}</td>" . NEWLINE;
print "<td class='left'>{$ba_owner}</td>" . NEWLINE;
print "<td class='left'>{$qa_owner}</td>" . NEWLINE;
print "<td class='left'>{$tester}</td>" . NEWLINE;
print "<td class='left' nowrap>{$test_type}</td>" . NEWLINE;
print "<td class='left' nowrap>{$area_tested}</td>" . NEWLINE;
print "<td class='left' nowrap>{$testset_assoc_status}</td>" . NEWLINE;
print "<td class='center'><a href='{$test_page}?test_id={$test_id}' target='_blank'>" . lang_get('docs_link') . "</a></td>" . NEWLINE;
print "<td class='center'><a href='{$results_test_run_page}?test_id={$test_id}&testset_menu_testset_id={$_GET['testset_menu_testset_id']}'>" . lang_get('results_link') . "</a></td>" . NEWLINE;
print "<th></th>";
html_tbl_print_header(lang_get('req_id'), REQ_ID, $order_by, $order_dir);
html_tbl_print_header("");
html_tbl_print_header(lang_get('req_name'), REQ_FILENAME, $order_by, $order_dir);
html_tbl_print_header(lang_get('req_detail'), REQ_VERS_DETAIL, $order_by, $order_dir);
html_tbl_print_header(lang_get('req_type'), REQ_DOC_TYPE_NAME, $order_by, $order_dir);
html_tbl_print_header(lang_get('status'), REQ_VERS_STATUS, $order_by, $order_dir);
html_tbl_print_header(lang_get('req_area'), REQ_AREA_COVERAGE, $order_by, $order_dir);
html_tbl_print_header(lang_get('functionality'));
html_tbl_print_header(lang_get('req_locked_by'), REQ_LOCKED_BY, $order_by, $order_dir);
html_tbl_print_header(lang_get('req_locked_date'), REQ_LOCKED_DATE, $order_by, $order_dir);
print "</tr>" . NEWLINE;
foreach ($rows_requirement as $row_requirement) {
$req_id = $row_requirement[REQ_ID];
$req_version_id = $row_requirement[REQ_VERS_UNIQUE_ID];
if (session_records_ischecked("requirement_requirement_assoc", $req_id)) {
$checked = "checked";
} else {
$checked = "";
}
# Build list of records
if (empty($records)) {
$records = $req_id . " => ''";
} else {
$records .= ", " . $req_id . " => ''";
}
$row_style = html_tbl_alternate_bgcolor($row_style);
$rows_functions = requirement_get_functionality($project_id, $row_requirement[REQ_ID]);
# Rows
print "<tr class='{$row_style}'>" . NEWLINE;
print "<td><input type='checkbox' name=row_{$req_id} {$checked}></td>";
html_tbl_print_header(lang_get('area_tested'));
html_tbl_print_header(lang_get('status'));
html_tbl_print_header_not_sortable(lang_get('archive'));
print "</tr>" . NEWLINE;
print "</thead>" . NEWLINE;
print "<tbody>" . NEWLINE;
foreach ($row as $test_row) {
#$row_style = html_tbl_alternate_bgcolor($row_style);
#print"<tr class='$row_style'>". NEWLINE;
print "<tr>" . NEWLINE;
print "<td>" . html_print_testtype_icon($test_row[TEST_MANUAL], $test_row[TEST_AUTOMATED]) . "</td>" . NEWLINE;
print "<td>" . $test_row[TEST_NAME] . "</td>" . NEWLINE;
print "<td>" . $test_row[TEST_TESTTYPE] . "</td>" . NEWLINE;
print "<td>" . $test_row[TEST_AREA_TESTED] . "</td>" . NEWLINE;
print "<td>" . $test_row[TEST_STATUS] . "</td>" . NEWLINE;
if (session_records_ischecked("archive_tests", $test_row[TEST_ID])) {
$checked = "checked";
} else {
$checked = "";
}
if (empty($records)) {
$records = $test_row[TEST_ID] . " => ''";
} else {
$records .= ", " . $test_row[TEST_ID] . " => ''";
}
print "<td><input type=checkbox name=row_" . $test_row[TEST_ID] . " {$checked}></td>" . NEWLINE;
print "</tr>" . NEWLINE;
}
print "</tbody>" . NEWLINE;
print "</table>" . NEWLINE;
print "<br>" . NEWLINE;
function test_edit_assoc_requirements($test_id, $session_records_name, $pc_covered_text_input_name)
{
global $db;
$tbl_req = REQ_TBL;
$f_req_proj_id = $tbl_req . "." . REQ_PROJECT_ID;
$f_req_id = $tbl_req . "." . REQ_ID;
$f_req_filename = $tbl_req . "." . REQ_FILENAME;
$tbl_test_req_assoc = TEST_REQ_ASSOC_TBL;
$f_test_req_assoc_req_id = $tbl_test_req_assoc . "." . TEST_REQ_ASSOC_REQ_ID;
$f_test_req_assoc_test_id = $tbl_test_req_assoc . "." . TEST_REQ_ASSOC_TEMPEST_TEST_ID;
$f_test_req_assoc_covered = $tbl_test_req_assoc . "." . TEST_REQ_ASSOC_PERCENT_COVERED;
$tbl_test = TEST_TBL;
$f_test_name = $tbl_test . "." . TEST_NAME;
$f_test_id = $tbl_test . "." . TEST_ID;
$s_project_properties = session_get_project_properties();
$project_id = $s_project_properties['project_id'];
$req_ids = requirement_get_all_ids($project_id);
foreach ($req_ids as $row) {
$req_id = $row[REQ_ID];
$q = "\tSELECT {$f_test_req_assoc_req_id}\n\t\t\t\tFROM {$tbl_test_req_assoc}\n\t\t\t\tWHERE {$f_test_req_assoc_req_id} = {$req_id}\n\t\t\t\t\tAND\t{$f_test_req_assoc_test_id} = {$test_id}";
$rs = db_query($db, $q);
$record_exists = db_num_rows($db, $rs);
if (session_records_ischecked($session_records_name, $req_id)) {
$pc_covered = session_validate_form_get_field($pc_covered_text_input_name . $req_id);
if ($pc_covered == '') {
$pc_covered = 0;
}
//print"pc_covered = $pc_covered<br>";
if (!$record_exists) {
# Add new record
$q = "\tINSERT INTO {$tbl_test_req_assoc}\n\t\t\t\t\t\t\t({$f_test_req_assoc_req_id}, {$f_test_req_assoc_test_id}, {$f_test_req_assoc_covered})\n\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t({$req_id}, {$test_id}, '{$pc_covered}')";
} else {
# Update current record
$q = "\tUPDATE {$tbl_test_req_assoc}\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t{$f_test_req_assoc_covered} = '{$pc_covered}'\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t{$f_test_req_assoc_req_id} = {$req_id}\n\t\t\t\t\t\t\tAND {$f_test_req_assoc_test_id} = {$test_id}";
}
} else {
if ($record_exists) {
$q = "\tDELETE FROM {$tbl_test_req_assoc}\n\t\t\t\t\t\tWHERE {$f_test_req_assoc_req_id} = {$req_id}\n\t\t\t\t\t\t\tAND\t{$f_test_req_assoc_test_id} = {$test_id}";
}
}
db_query($db, $q);
}
}
html_tbl_print_sortable_header(lang_get('functionality'));
html_tbl_print_sortable_header(lang_get('req_locked_by'), REQ_TBL . "." . REQ_LOCKED_BY, $order_by, $order_dir);
html_tbl_print_sortable_header(lang_get('req_locked_date'), REQ_TBL . "." . REQ_LOCKED_DATE, $order_by, $order_dir);
print "</tr>" . NEWLINE;
foreach ($rows_requirement as $row_requirement) {
$req_id = $row_requirement[REQ_ID];
$req_version_id = $row_requirement[REQ_VERS_UNIQUE_ID];
# Name of the % covered text input
$pc_covered_input_name = "percent_covered_" . $req_id;
# Get the % covered from db
$percent_covered = test_requirement_get_pc_covered($s_test_id, $req_id);
# Save and get the % covered from the session
$percent_covered = session_validate_form_get_field($pc_covered_input_name, $percent_covered);
$row_style = html_tbl_alternate_bgcolor($row_style);
$rows_functions = requirement_get_functionality($s_project_id, $row_requirement[REQ_ID]);
if (session_records_ischecked("test_req_assoc", $req_id)) {
$checked = "checked";
} else {
$checked = "";
}
# Build list of records
if (empty($records)) {
$records = $req_id . " => ''";
} else {
$records .= ", " . $req_id . " => ''";
}
# Rows
print "<tr class='{$row_style}'>" . NEWLINE;
print "<td><input type='checkbox' name='row_{$req_id}' {$checked}></td>";
print "<td><input type=text name={$pc_covered_input_name} size=3 maxlength=3 value='{$percent_covered}'></td>";
print "<td>" . util_pad_id($row_requirement[REQ_ID]) . "</td>" . NEWLINE;
#$row_style = html_tbl_alternate_bgcolor($row_style);
if ($row_test_detail[TEST_AUTO_PASS] == "Y") {
$autopass = "******";
} else {
$autopass = "******";
}
# Build list of records
if (empty($records)) {
$records = $test_id . " => '" . $test_type . "'";
} else {
$records .= ", " . $test_id . " => '" . $test_type . "'";
}
# Rows
#print"<tr class='$row_style'>". NEWLINE;
print "<tr>" . NEWLINE;
if (session_records_ischecked("testset_edit", $test_id, $test_type)) {
print "<td><input type=checkbox name=row_" . $test_id . " value='" . $test_type . "' checked></td>" . NEWLINE;
} else {
print "<td><input type=checkbox name=row_" . $test_id . " value='" . $test_type . "'></td>" . NEWLINE;
}
print "<td class='left'>{$display_test_id}</td>" . NEWLINE;
print "<td class='tbl-l'>" . html_print_testtype_icon($manual, $automated) . "</td>" . NEWLINE;
print "<td class='tbl-l'>{$autopass}</td>" . NEWLINE;
print "<td class='tbl-l'>{$test_name}</td>" . NEWLINE;
print "<td class='tbl-l'>{$ba_owner}</td>" . NEWLINE;
print "<td class='tbl-l'>{$qa_owner}</td>" . NEWLINE;
print "<td class='tbl-l'>{$tester}</td>" . NEWLINE;
print "<td class='tbl-l'>{$test_type}</td>" . NEWLINE;
print "<td class='tbl-l'>{$area_tested}</td>" . NEWLINE;
print "<td class='tbl-l'>{$priority}</td>" . NEWLINE;
print "</tr>" . NEWLINE;
html_tbl_print_sortable_header("email");
html_tbl_print_sortable_header(lang_get('req_id'), REQ_ID, $order_by, $order_dir);
html_tbl_print_sortable_header(lang_get('req_name'), REQ_FILENAME, $order_by, $order_dir);
print "</tr>" . NEWLINE;
foreach ($rows_requirement as $row_requirement) {
$req_id = $row_requirement[REQ_ID];
$req_name = $row_requirement[REQ_FILENAME];
if (empty($records)) {
$records = $row_requirement[REQ_ID] . " => ''";
} else {
$records .= ", " . $row_requirement[REQ_ID] . " => ''";
}
$row_style = html_tbl_alternate_bgcolor($row_style);
# Rows
print "<tr class='{$row_style}'>" . NEWLINE;
if (session_records_ischecked("requirements_notification", $req_id)) {
print "<td><input type=checkbox name=row_{$req_id} value='' checked></td>" . NEWLINE;
} else {
print "<td><input type=checkbox name=row_{$req_id} value=''></td>" . NEWLINE;
}
print "<td class='tbl-1'>" . util_pad_id($req_id) . "</td>" . NEWLINE;
print "<td class='tbl-l'>{$req_name}</td>" . NEWLINE;
print "</tr>" . NEWLINE;
}
print "</table>" . NEWLINE;
print "</div>" . NEWLINE;
print "<div align=center>" . NEWLINE;
print "<table class=hide60>" . NEWLINE;
print "<tr>" . NEWLINE;
print "<td align=left>" . NEWLINE;
if (session_use_javascript()) {
function user_edit_requirement_notifications($project_id, $user_id, $s_variable)
{
$tbl_notify = REQ_NOTIFY_TBL;
$f_id = REQ_NOTIFY_TBL . "." . REQ_NOTIFY_ID;
$f_req_id = REQ_NOTIFY_TBL . "." . REQ_NOTIFY_REQ_ID;
$f_user_id = REQ_NOTIFY_TBL . "." . REQ_NOTIFY_USER_ID;
global $db;
$req_ids = requirement_get_all_ids($project_id);
foreach ($req_ids as $row) {
if (session_records_ischecked($s_variable, $row[REQ_ID])) {
# Check for associations between TestSet and the Test
$query_check = "\n\t\t\t\tSELECT {$f_id}\n\t\t\t\tFROM {$tbl_notify}\n\t\t\t\tWHERE\n\t\t\t\t\t{$f_user_id} = {$user_id}\n\t\t\t\t\tAND {$f_req_id} = " . $row[REQ_ID];
$num_check = db_num_rows($db, db_query($db, $query_check));
if ($num_check == 0) {
$query_Assoc = "\n\t\t\t\t\tINSERT INTO\t{$tbl_notify}\n\t\t\t\t\t\t({$f_user_id}, {$f_req_id} )\n\t\t\t\t\tVALUES\n\t\t\t\t\t\t({$user_id}, " . $row[REQ_ID] . ")";
db_query($db, $query_Assoc);
}
} else {
$query_Assoc = "\n\t\t\t\tDELETE FROM {$tbl_notify}\n\t\t\t\tWHERE\n\t\t\t\t\t{$f_req_id} = " . $row[REQ_ID] . "\n\t\t\t\t\tAND {$f_user_id} = {$user_id}";
db_query($db, $query_Assoc);
}
}
}
$tester = $row_test_detail[TEST_TESTER];
$test_type = $row_test_detail[TEST_TESTTYPE];
$manual = $row_test_detail[TEST_MANUAL];
$automated = $row_test_detail[TEST_AUTOMATED];
$area_tested = $row_test_detail[TEST_AREA_TESTED];
$priority = $row_test_detail[TEST_PRIORITY];
$autopass = $row_test_detail[TEST_AUTO_PASS];
# Name of the % covered text input
$pc_covered_input_name = "percent_covered_{$test_id}";
# Get the % covered from db
$percent_covered = requirement_test_get_pc_covered($s_req_id, $test_id);
# Save and get the % covered from the session
$percent_covered = session_validate_form_get_field($pc_covered_input_name, $percent_covered);
$display_test_id = util_pad_id($test_id);
$row_style = html_tbl_alternate_bgcolor($row_style);
if (session_records_ischecked("requirement_tests_assoc", $test_id)) {
$checked = "checked";
} else {
$checked = "";
}
# Build list of records
if (empty($records)) {
$records = $test_id . " => '" . $test_type . "'";
} else {
$records .= ", " . $test_id . " => '" . $test_type . "'";
}
print "<tr class='{$row_style}'>" . NEWLINE;
print "<td><input type='checkbox' name=row_{$test_id} {$checked}></td>" . NEWLINE;
print "<td><input type='text' name={$pc_covered_input_name} size=3 maxlength=3 value='{$percent_covered}'></td>" . NEWLINE;
print "<td class='tbl-l'>{$display_test_id}</td>" . NEWLINE;
print "<td class='tbl-l'>" . html_print_testtype_icon($manual, $automated) . "</td>" . NEWLINE;
function project_archive_tests($project_id)
{
global $db;
$tbl_test = TEST_TBL;
$f_name = $tbl_test . "." . TEST_NAME;
$f_type = $tbl_test . "." . TEST_TESTTYPE;
$f_priority = $tbl_test . "." . TEST_PRIORITY;
$f_id = $tbl_test . "." . TEST_ID;
$f_steps = $tbl_test . "." . TEST_MANUAL;
$f_script = $tbl_test . "." . TEST_AUTOMATED;
$f_status = $tbl_test . "." . TEST_STATUS;
$f_area = $tbl_test . "." . TEST_AREA_TESTED;
$f_deleted = $tbl_test . "." . TEST_DELETED;
$f_archive = $tbl_test . "." . TEST_ARCHIVED;
$f_area_tested = $tbl_test . "." . TEST_AREA_TESTED;
$f_project_id = $tbl_test . "." . PROJECT_ID;
foreach (admin_get_tests($project_id) as $row_test) {
if (session_records_ischecked("archive_tests", $row_test[TEST_ID])) {
$q = "\tUPDATE {$tbl_test}\n\t\t\t\t\tSET\n\t\t\t\t\t\t{$f_archive} = 'Y'\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t{$f_id} = " . $row_test[TEST_ID];
db_query($db, $q);
} else {
$q = "\tUPDATE {$tbl_test}\n\t\t\t\t\tSET\n\t\t\t\t\t\t{$f_archive} = 'N'\n\t\t\t\t\tWHERE\n\t\t\t\t\t\t{$f_id} = " . $row_test[TEST_ID];
db_query($db, $q);
}
}
}
function testset_add_tests_from_session($testset_properties, $f_status, $property_set)
{
$checked_tests = array();
$project_id = session_get_project_id();
$s_user_properties = session_get_user_properties();
$s_project_properties = session_get_project_properties();
$testset_id = $testset_properties['testset_id'];
$testset_name = admin_get_testset_name($testset_id);
$build_id = $testset_properties['build_id'];
$build_name = admin_get_build_name($build_id);
$release_id = $testset_properties['release_id'];
$release_name = admin_get_release_name($release_id);
global $db;
$testsuite_tbl = TEST_TBL;
$f_test_id = TEST_TBL . "." . TEST_ID;
$f_project_id = TEST_TBL . "." . PROJECT_ID;
$f_deleted = TEST_TBL . "." . TEST_DELETED;
$f_archived = TEST_TBL . "." . TEST_ARCHIVED;
$ts_assoc_tbl = TEST_TS_ASSOC_TBL;
$f_ts_assoc_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_ID;
$f_ts_assoc_test_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_TEST_ID;
$q = "SELECT {$f_test_id},\n\t\t\t{$f_ts_assoc_id},\n\t\t\t{$f_status}\n\t FROM {$ts_assoc_tbl}\n\t RIGHT JOIN {$testsuite_tbl} ON {$f_ts_assoc_test_id} = {$f_test_id}\n\t WHERE {$f_project_id} = {$project_id}\n\t AND {$f_archived} = 'N'\n\t AND {$f_deleted} = 'N'\n\t GROUP BY {$f_test_id}";
$rs = db_query($db, $q);
while ($row = db_fetch_row($db, $rs)) {
if (isset($row[$f_status])) {
# If the checkbox is ticked, then form an association between Test/TestSet
if (session_records_ischecked($property_set, $row[TEST_ID], $row[$f_status])) {
$checked_tests[$row[TEST_ID]] = "on";
}
}
}
testset_edit($testset_id, $checked_tests);
}
