def get_report(): project_name = session['project_name'] if type(project_name) is list: return redirect(url_for('get_school_report')) jira_account = {} jira_account['username'] = str(session['username']) jira_account['password'] = str(session['password']) jira = JiraHelper(config.jira_options, jira_account) board_id = str(session.get('board_id')) sprint_name = session['choice_sprint'] qa = str(session['qa_resource']) sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id), sprint_name) sprint_status = jira.html_get_sprint_status(sprint_id, board_id) original_standard_task_id_list = jira.get_standard_tasks_id_by_sprint(sprint_id, project_name) original_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint(sprint_id, project_name) original_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint(sprint_id, board_id, project_name) original_planned_tasks_info = jira.get_planned_tasks_by_sprint(sprint_id, board_id, project_name) original_raw_bug_id_list = jira.get_bug_id_by_sprint(sprint_id, board_id, project_name) original_raw_bug_list = jira.get_bug_info_by_sprint(sprint_id, board_id, project_name) original_change_request_id_list = jira.get_change_request_id_by_sprint(sprint_id, project_name) original_raw_change_request_list = jira.get_change_request_info_by_sprint(sprint_id, project_name) original_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint(sprint_id, project_name) original_raw_live_defect_list = jira.get_live_defect_info_by_sprint(sprint_id, project_name) original_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint(sprint_id, board_id, project_name) original_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(sprint_id, board_id, project_name) if "quick_filter" in session: if str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components): standard_task_id_list = jira.get_filtered_task_id_by_component(original_standard_task_id_list, session["quick_filter"]) # standard_tasks_info_by_sprint = jira.get_filtered_task_info_by_component(original_standard_tasks_info_by_sprint, session["quick_filter"]) # unplanned_tasks_info = jira.get_filtered_task_info_by_component(original_unplanned_tasks_info, session["quick_filter"]) # planned_tasks_info = jira.get_filtered_task_info_by_component(original_planned_tasks_info, session["quick_filter"]) # raw_bug_id_list = jira.get_filtered_task_id_by_component(original_raw_bug_id_list, session["quick_filter"]) # raw_bug_list = jira.get_filtered_task_info_by_component(original_raw_bug_list, session["quick_filter"]) # change_request_id_list = jira.get_filtered_task_id_by_component(original_change_request_id_list, session["quick_filter"]) # raw_live_defect_id_list = jira.get_filtered_task_id_by_component(original_raw_live_defect_id_list, session["quick_filter"]) # raw_live_defect_list = jira.get_filtered_task_info_by_component(original_raw_live_defect_list, session["quick_filter"]) # bugs_opened_before_but_closed_in_sprint = jira.get_filtered_task_info_by_component(original_bugs_opened_before_but_closed_in_sprint, session["quick_filter"]) # raw_automation_bug_list = jira.get_filtered_task_info_by_component(original_raw_automation_bug_list, session["quick_filter"]) # raw_change_request_list = jira.get_filtered_task_info_by_component(original_raw_change_request_list, session["quick_filter"]) # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(sprint_id, board_id, project_name, session["quick_filter"]) else: standard_task_id_list = original_standard_task_id_list standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint raw_bug_id_list = original_raw_bug_id_list raw_bug_list = original_raw_bug_list change_request_id_list = original_change_request_id_list raw_live_defect_id_list = original_raw_live_defect_id_list raw_live_defect_list = original_raw_live_defect_list unplanned_tasks_info = original_unplanned_tasks_info planned_tasks_info = original_planned_tasks_info bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint raw_automation_bug_list = original_raw_automation_bug_list raw_change_request_list = original_raw_change_request_list filter_string_list = [] filter_string = ',' for item in config.quick_filter_choice[session["project_name"]]: if str(item[0]) != str(config.show_all_but_exclude_those_have_components) and str(item[0]) != str(config.show_all): filter_string_list.append(item[0]) filter_string = ',' + item[0] + filter_string filter_string = filter_string.strip(',') standard_task_id_list = jira.exclude_filtered_task_id_by_component(standard_task_id_list, filter_string_list) # standard_tasks_info_by_sprint = jira.exclude_filtered_task_info_by_component(standard_tasks_info_by_sprint, filter_string_list) # unplanned_tasks_info = jira.exclude_filtered_task_info_by_component(unplanned_tasks_info, filter_string_list) # planned_tasks_info = jira.exclude_filtered_task_info_by_component(planned_tasks_info, filter_string_list) # raw_bug_id_list = jira.exclude_filtered_task_id_by_component(raw_bug_id_list, filter_string_list) # raw_bug_list = jira.exclude_filtered_task_info_by_component(raw_bug_list, filter_string_list) # change_request_id_list = jira.exclude_filtered_task_id_by_component(change_request_id_list, filter_string_list) # raw_live_defect_id_list = jira.exclude_filtered_task_id_by_component(raw_live_defect_id_list, filter_string_list) # raw_live_defect_list = jira.exclude_filtered_task_info_by_component(raw_live_defect_list,filter_string_list) # bugs_opened_before_but_closed_in_sprint = jira.exclude_filtered_task_info_by_component(bugs_opened_before_but_closed_in_sprint, filter_string_list) # raw_automation_bug_list = jira.exclude_filtered_task_info_by_component(raw_automation_bug_list, filter_string_list) # raw_change_request_list = jira.exclude_filtered_task_info_by_component(raw_change_request_list, filter_string_list) # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_exclude_component_filter(sprint_id, board_id, project_name, filter_string) else: standard_task_id_list = original_standard_task_id_list standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint # unplanned_tasks_info = original_unplanned_tasks_info planned_tasks_info = original_planned_tasks_info # raw_bug_id_list = original_raw_bug_id_list raw_bug_list = original_raw_bug_list # change_request_id_list = original_change_request_id_list # raw_live_defect_id_list = original_raw_live_defect_id_list # raw_live_defect_list = original_raw_live_defect_list bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint # raw_automation_bug_list = original_raw_automation_bug_list # raw_change_request_list = original_raw_change_request_list # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(sprint_id, board_id, project_name) actual_points = jira.get_actual_story_points_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint) unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint(unplanned_tasks_info) unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(unplanned_tasks_info) planned_nest_lists = jira.html_get_planned_tasks_by_sprint(planned_tasks_info) release_tasks_with_fix_version_and_size = jira.get_filtered_task_info_by_fix_version(planned_tasks_info) t_size_number = jira.get_task_members_by_t_size(release_tasks_with_fix_version_and_size) nested_release_tasks_with_fix_version_and_size = jira.html_get_release_tasks_with_fix_version_and_size(release_tasks_with_fix_version_and_size) un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint) raw_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint) un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint(raw_completed_tasks_nest_lists) un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage(raw_completed_tasks_nest_lists, standard_tasks_info_by_sprint) sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list) previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks(bugs_opened_before_but_closed_in_sprint) sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(raw_automation_bug_list) sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage(raw_bug_id_list, raw_automation_bug_list) sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(raw_live_defect_list) sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(raw_live_defect_id_list, raw_bug_id_list ) sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks(raw_change_request_list) sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects(standard_task_id_list, change_request_id_list) # bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list) bug_priority_detail = jira.html_get_share_ratio_detail_by_priority(raw_bug_list) # story_list= jira.get_task_id_that_has_linked_task(raw_bug_id_list) story_share = jira.html_get_linked_issue_num_group_by_story(story_list) story_share_detail = jira.html_get_linked_issue_detail_group_by_story(story_list, raw_bug_id_list)[1] story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail) render = render_template('sprint_report.html', project_required=project_name, \ customized_component=session["quick_filter"] if "quick_filter" in session \ and str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components) else None, \ sprint_name_string=sprint_name, \ qa_resource = qa, \ sprint_status=sprint_status, actual_story_points=actual_points, \ unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \ planned_nest_lists =planned_nest_lists,\ un_finished_tasks_nest_lists=un_completed_tasks_nest_lists, \ un_completed_story_points = un_completed_story_points, \ un_completed_tasks_percentage=un_completed_tasks_percentage, \ un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \ sprint_bug_nested_lists=sprint_bug_nested_list, \ bug_priority_nested_lists=bug_priority_list, \ bug_priority_share_detail_info=bug_priority_detail, \ story_share_nested_lists=story_share, \ story_share_detail_info=story_share_detail, \ total_bug_and_opened_bug_pair_nested_list=bug_trends, \ sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \ sprint_automation_bug_percentage=sprint_automation_bug_percentage, \ previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint, sprint_live_defect_nested_lists=sprint_live_defect_nested_list, \ sprint_live_defect_percentage=sprint_live_defect_percentage, \ sprint_change_request_nested_lists=sprint_change_request_nested_list, \ sprint_change_request_percentage=sprint_change_request_percentage, \ t_size_number=t_size_number,\ release_tasks_with_fix_version_and_size=nested_release_tasks_with_fix_version_and_size ) global response response = make_response(render) session.clear() return render
def get_report(): project_name = session['project_name'] if type(project_name) is list: return redirect(url_for('get_school_report')) jira_account = {} jira_account['username'] = str(session['username']) jira_account['password'] = str(session['password']) jira = JiraHelper(config.jira_options, jira_account) board_id = str(session.get('board_id')) sprint_name = session['choice_sprint'] qa = str(session['qa_resource']) sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id), sprint_name) sprint_status = jira.html_get_sprint_status(sprint_id, board_id) original_standard_task_id_list = jira.get_standard_tasks_id_by_sprint( sprint_id, project_name) original_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint( sprint_id, project_name) original_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint( sprint_id, board_id, project_name) original_planned_tasks_info = jira.get_planned_tasks_by_sprint( sprint_id, board_id, project_name) original_raw_bug_id_list = jira.get_bug_id_by_sprint( sprint_id, board_id, project_name) original_raw_bug_list = jira.get_bug_info_by_sprint( sprint_id, board_id, project_name) original_change_request_id_list = jira.get_change_request_id_by_sprint( sprint_id, project_name) original_raw_change_request_list = jira.get_change_request_info_by_sprint( sprint_id, project_name) original_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint( sprint_id, project_name) original_raw_live_defect_list = jira.get_live_defect_info_by_sprint( sprint_id, project_name) original_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint( sprint_id, board_id, project_name) original_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint( sprint_id, board_id, project_name) if "quick_filter" in session: if str(session["quick_filter"]) != str( config.show_all_but_exclude_those_have_components): standard_task_id_list = jira.get_filtered_task_id_by_component( original_standard_task_id_list, session["quick_filter"]) # standard_tasks_info_by_sprint = jira.get_filtered_task_info_by_component( original_standard_tasks_info_by_sprint, session["quick_filter"]) # unplanned_tasks_info = jira.get_filtered_task_info_by_component( original_unplanned_tasks_info, session["quick_filter"]) # planned_tasks_info = jira.get_filtered_task_info_by_component( original_planned_tasks_info, session["quick_filter"]) # raw_bug_id_list = jira.get_filtered_task_id_by_component( original_raw_bug_id_list, session["quick_filter"]) # raw_bug_list = jira.get_filtered_task_info_by_component( original_raw_bug_list, session["quick_filter"]) # change_request_id_list = jira.get_filtered_task_id_by_component( original_change_request_id_list, session["quick_filter"]) # raw_live_defect_id_list = jira.get_filtered_task_id_by_component( original_raw_live_defect_id_list, session["quick_filter"]) # raw_live_defect_list = jira.get_filtered_task_info_by_component( original_raw_live_defect_list, session["quick_filter"]) # bugs_opened_before_but_closed_in_sprint = jira.get_filtered_task_info_by_component( original_bugs_opened_before_but_closed_in_sprint, session["quick_filter"]) # raw_automation_bug_list = jira.get_filtered_task_info_by_component( original_raw_automation_bug_list, session["quick_filter"]) # raw_change_request_list = jira.get_filtered_task_info_by_component( original_raw_change_request_list, session["quick_filter"]) # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint( sprint_id, board_id, project_name, session["quick_filter"]) else: standard_task_id_list = original_standard_task_id_list standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint raw_bug_id_list = original_raw_bug_id_list raw_bug_list = original_raw_bug_list change_request_id_list = original_change_request_id_list raw_live_defect_id_list = original_raw_live_defect_id_list raw_live_defect_list = original_raw_live_defect_list unplanned_tasks_info = original_unplanned_tasks_info planned_tasks_info = original_planned_tasks_info bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint raw_automation_bug_list = original_raw_automation_bug_list raw_change_request_list = original_raw_change_request_list filter_string_list = [] filter_string = ',' for item in config.quick_filter_choice[session["project_name"]]: if str(item[0]) != str( config.show_all_but_exclude_those_have_components ) and str(item[0]) != str(config.show_all): filter_string_list.append(item[0]) filter_string = ',' + item[0] + filter_string filter_string = filter_string.strip(',') standard_task_id_list = jira.exclude_filtered_task_id_by_component( standard_task_id_list, filter_string_list) # standard_tasks_info_by_sprint = jira.exclude_filtered_task_info_by_component( standard_tasks_info_by_sprint, filter_string_list) # unplanned_tasks_info = jira.exclude_filtered_task_info_by_component( unplanned_tasks_info, filter_string_list) # planned_tasks_info = jira.exclude_filtered_task_info_by_component( planned_tasks_info, filter_string_list) # raw_bug_id_list = jira.exclude_filtered_task_id_by_component( raw_bug_id_list, filter_string_list) # raw_bug_list = jira.exclude_filtered_task_info_by_component( raw_bug_list, filter_string_list) # change_request_id_list = jira.exclude_filtered_task_id_by_component( change_request_id_list, filter_string_list) # raw_live_defect_id_list = jira.exclude_filtered_task_id_by_component( raw_live_defect_id_list, filter_string_list) # raw_live_defect_list = jira.exclude_filtered_task_info_by_component( raw_live_defect_list, filter_string_list) # bugs_opened_before_but_closed_in_sprint = jira.exclude_filtered_task_info_by_component( bugs_opened_before_but_closed_in_sprint, filter_string_list) # raw_automation_bug_list = jira.exclude_filtered_task_info_by_component( raw_automation_bug_list, filter_string_list) # raw_change_request_list = jira.exclude_filtered_task_info_by_component( raw_change_request_list, filter_string_list) # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_exclude_component_filter( sprint_id, board_id, project_name, filter_string) else: standard_task_id_list = original_standard_task_id_list standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint # unplanned_tasks_info = original_unplanned_tasks_info planned_tasks_info = original_planned_tasks_info # raw_bug_id_list = original_raw_bug_id_list raw_bug_list = original_raw_bug_list # change_request_id_list = original_change_request_id_list # raw_live_defect_id_list = original_raw_live_defect_id_list # raw_live_defect_list = original_raw_live_defect_list bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint # raw_automation_bug_list = original_raw_automation_bug_list # raw_change_request_list = original_raw_change_request_list # bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint( sprint_id, board_id, project_name) actual_points = jira.get_actual_story_points_by_sprint( sprint_id, board_id, standard_tasks_info_by_sprint) unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint( unplanned_tasks_info) unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint( unplanned_tasks_info) planned_nest_lists = jira.html_get_planned_tasks_by_sprint( planned_tasks_info) release_tasks_with_fix_version_and_size = jira.get_filtered_task_info_by_fix_version( planned_tasks_info) t_size_number = jira.get_task_members_by_t_size( release_tasks_with_fix_version_and_size) nested_release_tasks_with_fix_version_and_size = jira.html_get_release_tasks_with_fix_version_and_size( release_tasks_with_fix_version_and_size) un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint( sprint_id, board_id, standard_tasks_info_by_sprint) raw_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint( sprint_id, board_id, standard_tasks_info_by_sprint) un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint( raw_completed_tasks_nest_lists) un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage( raw_completed_tasks_nest_lists, standard_tasks_info_by_sprint) sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list) previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks( bugs_opened_before_but_closed_in_sprint) sprint_automation_bug_list = jira.html_get_bug_list_by_tasks( raw_automation_bug_list) sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage( raw_bug_id_list, raw_automation_bug_list) sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks( raw_live_defect_list) sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects( raw_live_defect_id_list, raw_bug_id_list) sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks( raw_change_request_list) sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects( standard_task_id_list, change_request_id_list) # bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list) bug_priority_detail = jira.html_get_share_ratio_detail_by_priority( raw_bug_list) # story_list = jira.get_task_id_that_has_linked_task(raw_bug_id_list) story_share = jira.html_get_linked_issue_num_group_by_story(story_list) story_share_detail = jira.html_get_linked_issue_detail_group_by_story( story_list, raw_bug_id_list)[1] story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail) render = render_template('sprint_report.html', project_required=project_name, \ customized_component=session["quick_filter"] if "quick_filter" in session \ and str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components) else None, \ sprint_name_string=sprint_name, \ qa_resource = qa, \ sprint_status=sprint_status, actual_story_points=actual_points, \ unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \ planned_nest_lists =planned_nest_lists,\ un_finished_tasks_nest_lists=un_completed_tasks_nest_lists, \ un_completed_story_points = un_completed_story_points, \ un_completed_tasks_percentage=un_completed_tasks_percentage, \ un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \ sprint_bug_nested_lists=sprint_bug_nested_list, \ bug_priority_nested_lists=bug_priority_list, \ bug_priority_share_detail_info=bug_priority_detail, \ story_share_nested_lists=story_share, \ story_share_detail_info=story_share_detail, \ total_bug_and_opened_bug_pair_nested_list=bug_trends, \ sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \ sprint_automation_bug_percentage=sprint_automation_bug_percentage, \ previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint, sprint_live_defect_nested_lists=sprint_live_defect_nested_list, \ sprint_live_defect_percentage=sprint_live_defect_percentage, \ sprint_change_request_nested_lists=sprint_change_request_nested_list, \ sprint_change_request_percentage=sprint_change_request_percentage, \ t_size_number=t_size_number,\ release_tasks_with_fix_version_and_size=nested_release_tasks_with_fix_version_and_size ) global response response = make_response(render) session.clear() return render