function requirement_add_version($project_id, $req_id, $req_defect_id, $area_covered, $type, $record_or_file, $version, $status, $filename, $detail = "", $reason_for_change = "", $assign_to, $upload_by, $functionality, $priority, $release_id) { global $db; $tbl_req = REQ_TBL; $f_req_id = $tbl_req . "." . REQ_ID; $f_req_filename = $tbl_req . "." . REQ_FILENAME; $f_req_area_covered = $tbl_req . "." . REQ_AREA_COVERED; $f_req_type = $tbl_req . "." . REQ_TYPE; $f_req_parent = $tbl_req . "." . REQ_PARENT; $f_req_label = $tbl_req . "." . REQ_LABEL; $f_req_unique_id = $tbl_req . "." . REQ_UNIQUE_ID; $f_req_functionality = $tbl_req . "." . REQ_FUNCTIONALITY; $f_req_locked_by = $tbl_req . "." . REQ_LOCKED_BY; $f_req_locked_date = $tbl_req . "." . REQ_LOCKED_DATE; $f_req_priority = $tbl_req . "." . REQ_PRIORITY; $f_req_last_updated = $tbl_req . "." . REQ_LAST_UPDATED; $tbl_req_ver = REQ_VERS_TBL; $f_req_ver_uid = $tbl_req_ver . "." . REQ_VERS_UNIQUE_ID; $f_req_ver_req_id = $tbl_req_ver . "." . REQ_VERS_REQ_ID; $f_req_ver_version = $tbl_req_ver . "." . REQ_VERS_VERSION; $f_req_ver_timestamp = $tbl_req_ver . "." . REQ_VERS_TIMESTAMP; $f_req_ver_uploaded_by = $tbl_req_ver . "." . REQ_VERS_UPLOADED_BY; $f_req_ver_filename = $tbl_req_ver . "." . REQ_VERS_FILENAME; $f_req_ver_comments = $tbl_req_ver . "." . REQ_VERS_COMMENTS; $f_req_ver_status = $tbl_req_ver . "." . REQ_VERS_STATUS; $f_req_ver_shed_release = $tbl_req_ver . "." . REQ_VERS_SCHEDULED_RELEASE_IMP; $f_req_ver_shed_build = $tbl_req_ver . "." . REQ_VERS_SCHEDULED_BUILD_IMP; $f_req_ver_actual_release = $tbl_req_ver . "." . REQ_VERS_ACTUAL_RELEASE_IMP; $f_req_ver_actual_build = $tbl_req_ver . "." . REQ_VERS_ACTUAL_BUILD_IMP; $f_req_ver_detail = $tbl_req_ver . "." . REQ_VERS_DETAIL; $f_req_ver_release = $tbl_req_ver . "." . REQ_VERS_ASSIGN_RELEASE; $f_req_ver_latest = $tbl_req_ver . "." . REQ_VERS_LATEST; $f_req_ver_reason_change = $tbl_req_ver . "." . REQ_VERS_REASON_CHANGE; $f_req_ver_assigned = $tbl_req_ver . "." . REQ_VERS_ASSIGNED_TO; $f_req_ver_defect_id = $tbl_req_ver . "." . REQ_VERS_DEFECT_ID; $last_updated = date_get_short_dt(); if ($area_covered == '') { $area_covered = 0; } if ($type == '') { $type = 0; } $q = "\tUPDATE {$tbl_req_ver}\n\t\t\tSET\n\t\t\t\t{$f_req_ver_latest} = 'N'\n\t\t\tWHERE\n\t\t\t\t{$f_req_ver_req_id} = {$req_id}"; db_query($db, $q); $q = "\tUPDATE {$tbl_req}\n\t\t\tSET\n\t\t\t\t{$f_req_area_covered} = '{$area_covered}',\n\t\t\t\t{$f_req_type} = '{$type}',\n\t\t\t\t{$f_req_priority} = '{$priority}',\n\t\t\t\t{$f_req_last_updated} = '{$last_updated}'\n\t\t\tWHERE\n\t\t\t\t{$f_req_id} = {$req_id}"; db_query($db, $q); $q = "\tINSERT INTO {$tbl_req_ver}\n\t\t\t\t(\t{$f_req_ver_req_id},\n\t\t\t\t\t{$f_req_ver_defect_id},\n\t\t\t\t\t{$f_req_ver_version},\n\t\t\t\t\t{$f_req_ver_timestamp},\n\t\t\t\t\t{$f_req_ver_uploaded_by},\n\t\t\t\t\t{$f_req_ver_filename},\n\t\t\t\t\t{$f_req_ver_status},\n\t\t\t\t\t{$f_req_ver_detail},\n\t\t\t\t\t{$f_req_ver_reason_change},\n\t\t\t\t\t{$f_req_ver_assigned},\n\t\t\t\t\t{$f_req_ver_latest} )\n\t\t\tVALUES\n\t\t\t\t(\t{$req_id},\n\t\t\t\t '{$req_defect_id}',\n\t\t\t\t\t'{$version}',\n\t\t\t\t\t'{$last_updated}',\n\t\t\t\t\t'{$upload_by}',\n\t\t\t\t\t'{$filename}',\n\t\t\t\t\t'{$status}',\n\t\t\t\t\t'{$detail}',\n\t\t\t\t\t'{$reason_for_change}',\n\t\t\t\t\t'{$assign_to}',\n\t\t\t\t\t'Y' )"; db_query($db, $q); requirement_edit_functionality($req_id, $functionality); # update related tests statuses to "Review Requirement" $req_test_relationships = requirement_get_test_relationships($req_id); foreach ($req_test_relationships as $row_req_test_rels) { $test_id = $row_req_test_rels[TEST_ID]; test_update_field($project_id, $test_id, TEST_STATUS, "Review Requirement"); } # Get the req_version_id just inserted. $req_version_id = requirement_get_latest_version($req_id); # update requirment_release_assoc requirement_edit_release($req_version_id, $release_id); }
# requires that we update two fields, Steps and Script. # Else: we just need to update a single field in the db if( is_array($field_name) ) { foreach( $field_name as $db_field_name ){ test_update_field( $project_id, $test_id_str, $db_field_name, $value ); } } else { test_update_field( $project_id, $test_id_str, $field_name, $value ); } */ if ($field == "man_auto") { test_update_field_man_auto($project_id, $test_id_str, $manual, $auto); } else { test_update_field($project_id, $test_id_str, $field_name, $value); } } html_print_operation_successful("test_page", $redirect_page); # --------------------------------------------------------------------- # $Log: test_group_action.php,v $ # Revision 1.3 2008/07/01 11:44:47 peter_thal # disabled possibility to select,store and filter both options automated and manual in RTH test category # # Revision 1.2 2007/02/12 07:16:35 gth2 # adding email functionality on test update - gth # # Revision 1.1.1.1 2005/11/30 23:00:58 gth2 # importing initial version - gth # # ---------------------------------------------------------------------