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);
}
}
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);
}
}
}
