function test_field_apply_filter($where_clause, $per_page, $order_by, $order_dir, $page_number, $csv_name) { global $db; $field_tbl = FIELD_TBL; $f_field_id = FIELD_TBL . "." . FIELD_ID; $f_field_name = FIELD_TBL . "." . FIELD_NAME; $f_fscreen_id = FIELD_TBL . "." . FIELD_SCREEN_ID; $f_description = FIELD_TBL . "." . FIELD_DESC; $f_field_order = FIELD_TBL . "." . FIELD_ORDER; $f_text_only = FIELD_TBL . "." . FIELD_TEXT_ONLY; $screen_tbl = SCREEN_TBL; $f_screen_id = SCREEN_TBL . "." . SCREEN_ID; $f_screen_name = SCREEN_TBL . "." . SCREEN_NAME; $q = "SELECT \n\t\t\t{$f_field_id}, {$f_field_name}, {$f_description}, {$f_field_order}, {$f_text_only}, {$f_screen_id}, {$f_screen_id}, {$f_screen_name}\n\t\t FROM \n\t\t\t{$field_tbl}, {$screen_tbl}\n\t\t WHERE\n\t\t\t{$f_fscreen_id} = {$f_screen_id}"; $order_clause = " ORDER BY {$order_by} {$order_dir}"; $where_clause = $where_clause . " GROUP BY {$f_field_name}"; $q .= $where_clause . $order_clause; if ($per_page != 0 && $page_number != 0) { $row_count = db_num_rows($db, db_query($db, $q)); $page_number = util_page_number($page_number, $row_count, $per_page); # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * $per_page; html_table_offset($row_count, $per_page, $page_number, $order_by, $order_dir, $csv_name); $q .= " LIMIT {$offset}, " . $per_page; } //print"$q<br>"; $rs = db_query($db, $q); return db_fetch_array($db, $rs); }
function results_apply_filter($project_id, $csv_export_page, $release_id, $build_id, $testset_id, $where_clause = null, $per_page, $order_by, $order_dir, $page_number, $javascript = null) { global $db; $test_tbl = TEST_TBL; $f_test_id = TEST_TBL . "." . TEST_ID; $f_project_id = TEST_TBL . "." . PROJECT_ID; $f_test_name = TEST_TBL . "." . TEST_NAME; $f_manual_tests = TEST_TBL . "." . TEST_MANUAL; $f_automated_tests = TEST_TBL . "." . TEST_AUTOMATED; $f_ba_owner = TEST_TBL . "." . TEST_BA_OWNER; $f_qa_owner = TEST_TBL . "." . TEST_QA_OWNER; $f_test_assigned_to = TEST_TBL . "." . TEST_ASSIGNED_TO; $f_test_load = TEST_TBL . "." . TEST_LR; $f_test_type = TEST_TBL . "." . TEST_TESTTYPE; $f_area_tested = TEST_TBL . "." . TEST_AREA_TESTED; $f_deleted = TEST_TBL . "." . TEST_DELETED; $f_archived = TEST_TBL . "." . TEST_ARCHIVED; $f_test_priority = TEST_TBL . "." . TEST_PRIORITY; $f_auto_pass = TEST_TBL . "." . TEST_AUTO_PASS; $ts_assoc_tbl = TEST_TS_ASSOC_TBL; $f_ts_assoc_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_ID; $f_ts_assoc_ts_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_TS_ID; $f_ts_assoc_test_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_TEST_ID; $f_ts_assoc_test_status = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_STATUS; $f_ts_assoc_assigned_to = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_ASSIGNED_TO; $f_ts_assoc_comments = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_COMMENTS; $results_tbl = TEST_RESULTS_TBL; $f_results_ts_id = $results_tbl . "." . TEST_RESULTS_TEST_SET_ID; $f_status = $results_tbl . "." . TEST_RESULTS_TEST_STATUS; $f_assigned_to = $results_tbl . "." . TEST_RESULTS_ASSIGNED_TO; $f_comments = $results_tbl . "." . TEST_RESULTS_COMMENTS; $limit_clause = ''; $q = "SELECT\n\t\t\t{$f_test_id},\n\t\t\t{$f_test_name},\n\t\t\t{$f_ba_owner},\n\t\t\t{$f_qa_owner},\n\t\t\t{$f_test_assigned_to},\n\t\t\t{$f_test_type},\n\t\t\t{$f_area_tested},\n\t\t\t{$f_ts_assoc_test_status},\n\t\t\t{$f_ts_assoc_assigned_to},\n\t\t\t{$f_ts_assoc_comments},\n\t\t\t{$f_test_priority},\n\t\t\t{$f_ts_assoc_id},\n\t\t\t{$f_manual_tests},\n\t\t\t{$f_automated_tests},\n\t\t\t{$f_test_load},\n\t\t\t{$f_auto_pass}\n\t\tFROM {$ts_assoc_tbl}\n\t\tINNER JOIN {$test_tbl} ON {$f_ts_assoc_test_id} = {$f_test_id}\n\t\tWHERE {$f_project_id} = '{$project_id}'\n\t\t\tAND {$f_ts_assoc_ts_id} = '{$testset_id}'\n\t\t\tAND {$f_deleted} = 'N'\n\t\t\tAND {$f_archived} = 'N'\n\t\t\t{$where_clause}\n\t\tGROUP BY {$f_test_id}\n\t\tORDER BY {$order_by} {$order_dir}"; if ($per_page != 0 && $page_number != 0) { $row_count = db_num_rows($db, db_query($db, $q)); # Make sure page count is at least 1 $page_count = ceil($row_count / $per_page); if ($page_count < 1) { $page_count = 1; } # Make sure page_number isn't past the last page. if ($page_number > $page_count) { $page_number = $page_count; } # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * $per_page; html_table_offset($row_count, $per_page, $page_number, $order_by, $order_dir, "results"); $q .= " LIMIT {$offset}, " . $per_page; } /* if( $per_page!=0 ) { # add a table header that includes the pages showing, export to csv, and links to other result pages # Add the limit clause to the query so that we only show n number of records per page html_table_offset( db_num_rows( $db, db_query($db, $q) ), $per_page, $page_number, $order_by, $order_dir, $csv_export_page ); $offset = ( ( $page_number - 1 ) * $per_page ); $q .= " LIMIT $offset, $per_page"; } */ //print"$q<br>"; return db_fetch_array($db, db_query($db, $q)); }
function requirement_get_edit_children($project_id, $req_id, $page_number = 0, $order_by = REQ_FILENAME, $order_dir = "ASC", $doc_type = "", $status = "", $area_covered = "", $functionality = "", $assign_release = "", $show_versions = "latest", $search = "", $priority = "", $per_page = null, $csv_name = null) { $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; $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_locked_by = $tbl_req . "." . REQ_LOCKED_BY; $f_req_locked_date = $tbl_req . "." . REQ_LOCKED_DATE; $f_req_parent = $tbl_req . "." . REQ_PARENT; $f_req_priority = $tbl_req . "." . REQ_PRIORITY; //$f_req_root = $tbl_req .".". REQ_ROOT; $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_latest = $tbl_req_ver . "." . REQ_VERS_LATEST; $tbl_functionality_assoc = REQ_FUNCT_ASSOC_TBL; $f_functionality_assoc_id = $tbl_functionality_assoc . "." . REQ_FUNCT_ASSOC_ID; $f_functionality_assoc_req_id = $tbl_functionality_assoc . "." . REQ_FUNCT_ASSOC_REQ_ID; $f_functionality_assoc_funct_id = $tbl_functionality_assoc . "." . REQ_FUNCT_ASSOC_FUNCT_ID; $release_tbl = RELEASE_TBL; $f_release_id = $release_tbl . "." . RELEASE_ID; $f_release_name = $release_tbl . "." . RELEASE_NAME; $tbl_req_ver_assoc_rel = REQ_VERS_ASSOC_REL; $f_req_ver_assoc_rel_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_ID; $f_req_ver_assoc_rel_req_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_REQ_ID; $f_req_ver_assoc_rel_rel_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_REL_ID; $tbl_req_doc_type = REQ_DOC_TYPE_TBL; $f_req_doc_type_name = $tbl_req_doc_type . "." . REQ_DOC_TYPE_NAME; $f_req_doc_type_id = $tbl_req_doc_type . "." . REQ_DOC_TYPE_ID; $f_req_doc_type_project_id = $tbl_req_doc_type . "." . REQ_DOC_TYPE_PROJ_ID; $f_req_doc_type_root_doc = $tbl_req_doc_type . "." . REQ_DOC_TYPE_ROOT_DOC; $tbl_req_area_covered = REQ_AREA_COVERAGE_TBL; $f_req_area_covered_name = $tbl_req_area_covered . "." . REQ_AREA_COVERAGE; $f_req_area_covered_id = $tbl_req_area_covered . "." . REQ_AREA_COVERAGE_ID; $f_req_area_covered_proj_id = $tbl_req_area_covered . "." . REQ_AREA_PROJ_ID; $where_clause = ""; if (!empty($doc_type)) { $where_clause .= "AND {$f_req_type} = '{$doc_type}' "; } if (!empty($status)) { $where_clause .= "AND {$f_req_ver_status} = '{$status}' "; } if (!empty($area_covered)) { $where_clause .= "AND {$f_req_area_covered} = '{$area_covered}' "; } if (!empty($functionality)) { $where_clause .= "AND {$f_functionality_assoc_funct_id} = '{$functionality}' "; } if (!empty($assign_release)) { $where_clause .= "AND {$f_req_ver_assoc_rel_rel_id} = '{$assign_release}'"; } if (!empty($priority)) { $where_clause .= "AND {$f_req_priority} = '{$priority}'"; } if ($show_versions == "latest") { $where_clause .= "AND {$f_req_ver_latest} = 'Y'"; } # SEARCH if (!empty($search)) { $where_clause = $where_clause . " AND ( ({$f_req_filename} LIKE '%{$search}%') OR ({$f_req_ver_detail} LIKE '%{$search}%') )"; } $where_clause = substr($where_clause, 3, strlen($where_clause)); if (!empty($where_clause)) { $where_clause = "WHERE {$where_clause}"; } $q = "\tSELECT DISTINCT\n\t\t\t\t{$f_req_id},\n\t\t\t\t{$f_req_area_covered_name},\n\t\t\t\t{$f_req_filename},\n\t\t\t\t{$f_req_doc_type_name},\n\t\t\t\t{$f_req_locked_by},\n\t\t\t\t{$f_req_locked_date},\n\t\t\t\t{$f_req_priority},\n\t\t\t\t{$f_req_ver_uid},\n\t\t\t\t{$f_req_ver_version},\n\t\t\t\t{$f_req_ver_detail},\n\t\t\t\t{$f_req_ver_status},\n\t\t\t\t{$f_req_ver_filename}\n\t\t\tFROM {$tbl_req}\n\t\t\tINNER JOIN {$tbl_req_ver}\n\t\t\t\tON {$f_req_ver_req_id} = {$f_req_id}\n\t\t\tLEFT JOIN {$tbl_req_doc_type}\n\t\t\t\tON {$f_req_doc_type_id} = {$f_req_type}\n\t\t\tLEFT JOIN {$tbl_req_area_covered}\n\t\t\t\tON {$f_req_area_covered_id} = {$f_req_area_covered}"; if (!empty($assign_release)) { $q .= "\tINNER JOIN {$tbl_req_ver_assoc_rel}\n\t\t\t\t\tON {$f_req_ver_assoc_rel_req_id} = {$f_req_ver_uid}\n\t\t\t\tINNER JOIN {$release_tbl}\n\t\t\t\t\tON {$f_release_id} = {$f_req_ver_assoc_rel_rel_id}"; } if (!empty($functionality)) { $q .= "\tINNER JOIN {$tbl_functionality_assoc}\n\t\t\t\t\tON {$f_functionality_assoc_req_id} = {$f_req_id}"; } $q .= "\t{$where_clause}\n\t\t\t\tAND {$f_req_proj_id} = {$project_id}\n\t\t\t\tAND ({$f_req_parent} = {$req_id} OR {$f_req_parent} = 0)\n\t\t\t\tAND {$f_req_id} != {$req_id}\n\t\t\tORDER BY {$order_by} {$order_dir}"; //print nl2br($q); global $db; //print$q; if (is_null($per_page)) { $s_properties = session_get_display_options("requirements"); $per_page = $s_properties['filter']['per_page']; } if ($per_page != 0 && $page_number != 0) { $row_count = db_num_rows($db, db_query($db, $q)); $page_number = util_page_number($page_number, $row_count, $per_page); # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * $per_page; html_table_offset($row_count, $per_page, $page_number, $order_by, $order_dir, $csv_name); $q .= " LIMIT {$offset}, " . $per_page; } //print$q;exit; $rows = db_fetch_array($db, db_query($db, $q)); return $rows; }
function admin_get_tests($project_id, $page_number = 0, $order_by = TEST_ID, $order_dir = "ASC") { global $db; $tbl_test = TEST_TBL; $f_name = TEST_NAME; $f_type = TEST_TESTTYPE; $f_priority = TEST_PRIORITY; $f_id = TEST_ID; $f_steps = TEST_MANUAL; $f_script = TEST_AUTOMATED; $f_status = TEST_STATUS; $f_area = TEST_AREA_TESTED; $f_deleted = TEST_DELETED; $f_archive = TEST_ARCHIVED; $f_area_tested = TEST_AREA_TESTED; $f_project_id = PROJECT_ID; $q = "\tSELECT\n\t\t\t\t{$f_id},\n\t\t\t\t{$f_name},\n\t\t\t\t{$f_type},\n\t\t\t\t{$f_priority},\n\t\t\t\t{$f_script},\n\t\t\t\t{$f_steps},\n\t\t\t\t{$f_status},\n\t\t\t\t{$f_area_tested},\n\t\t\t\t{$f_archive}\n\t\tFROM {$tbl_test}\n\t\tORDER BY {$order_by} {$order_dir}"; if ($page_number != 0) { # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * RECORDS_PER_PAGE_ARCHIVE_TESTS; html_table_offset(db_num_rows($db, db_query($db, $q)), RECORDS_PER_PAGE_ARCHIVE_TESTS, $page_number); $q .= " LIMIT {$offset}, " . RECORDS_PER_PAGE_ARCHIVE_TESTS; } return db_fetch_array($db, db_query($db, $q)); }
function user_get_all($order_by, $order_dir, $page_number, $deleted = 'Y') { global $db; $tbl_user = USER_TBL; $f_user_id = $tbl_user . "." . USER_ID; $f_user_name = $tbl_user . "." . USER_UNAME; $f_user_lname = $tbl_user . "." . USER_LNAME; $f_user_fname = $tbl_user . "." . USER_FNAME; $f_email = $tbl_user . "." . USER_EMAIL; $f_user_deleted = $tbl_user . "." . USER_DELETED; $f_user_default_project = $tbl_user . "." . USER_DEFAULT_PROJECT; $tbl_proj_user_assoc = PROJECT_USER_ASSOC_TBL; $f_proj_user_proj_id = $tbl_proj_user_assoc . "." . PROJ_USER_PROJ_ID; $f_proj_user_user_id = $tbl_proj_user_assoc . "." . PROJ_USER_USER_ID; $tbl_project = PROJECT_TBL; $f_proj_id = $tbl_project . "." . PROJ_ID; $q = "\tSELECT\t{$f_user_id},\n\t\t\t\t\t\t{$f_user_name},\n\t\t\t\t\t\t{$f_user_fname},\n\t\t\t\t\t\t{$f_user_lname},\n\t\t\t\t\t\t{$f_email},\n\t\t\t\t\t\t{$f_user_deleted}\n\t\t\t\tFROM\t{$tbl_user}\n\t\t\t\tORDER BY {$order_by} {$order_dir}"; //WHERE $f_user_deleted != '". $deleted ."' if (RECORDS_PER_PAGE_PROJECT_EDIT_USERS != 0) { # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * RECORDS_PER_PAGE_PROJECT_EDIT_USERS; html_table_offset(db_num_rows($db, db_query($db, $q)), RECORDS_PER_PAGE_PROJECT_EDIT_USERS, $page_number); $q .= " LIMIT {$offset}, " . RECORDS_PER_PAGE_PROJECT_EDIT_USERS; } $rs = db_query($db, $q); return db_fetch_array($db, $rs); }
function project_get_all_bug_components($project_id, $order_by = COMPONENT_NAME, $order_dir = "ASC", $page_number = null) { global $db; $component_tbl = BUG_COMPONENT_TBL; $f_id = $component_tbl . "." . COMPONENT_ID; $f_proj_id = $component_tbl . "." . COMPONENT_PROJECT_ID; $f_name = $component_tbl . "." . COMPONENT_NAME; $q = "SELECT\t{$f_id},\n\t\t\t\t\t{$f_proj_id},\n\t\t\t\t\t{$f_name}\n\t\t\tFROM\t{$component_tbl}\n\t\t\tWHERE\t{$f_proj_id} = {$project_id}\n\t\t\tORDER BY {$order_by} {$order_dir}"; if (!is_null($page_number)) { if (RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_CATEGORY != 0) { # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_COMPONENT; html_table_offset(db_num_rows($db, db_query($db, $q)), RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_COMPONENT, $page_number); $q .= " LIMIT {$offset}, " . RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_COMPONENT; } } $rows = db_fetch_array($db, db_query($db, $q)); return $rows; }
function report_get_failed_verifs($testset_id, $order_by = VERIFY_RESULTS_ID, $order_dir = "ASC", $page_number = 1, $bugs_only = false) { $tbl_ts_results = TEST_RESULTS_TBL; $f_ts_results_testset_id = $tbl_ts_results . "." . TEST_RESULTS_TEST_SET_ID; $f_ts_results_unique_run_id = $tbl_ts_results . "." . TEST_RESULTS_TS_UNIQUE_RUN_ID; $f_ts_results_ts = $tbl_ts_results . "." . TEST_RESULTS_TEST_SUITE; $f_ts_results_os = $tbl_ts_results . "." . TEST_RESULTS_OS; $tbl_testset = TS_TBL; $f_testset_id = $tbl_testset . "." . TS_ID; $f_testset_archive = $tbl_testset . "." . TS_ARCHIVE; $tbl_verify_results = VERIFY_RESULTS_TBL; $f_verify_results_id = $tbl_verify_results . "." . VERIFY_RESULTS_ID; $f_verify_test_status = $tbl_verify_results . "." . VERIFY_RESULTS_TEST_STATUS; $f_verify_unique_run = $tbl_verify_results . "." . VERIFY_RESULTS_TS_UNIQUE_RUN_ID; $f_verify_log_time = $tbl_verify_results . "." . VERIFY_RESULTS_LOG_TIME_STAMP; $f_verify_test_status = $tbl_verify_results . "." . VERIFY_RESULTS_TEST_STATUS; $f_verify_line_num = $tbl_verify_results . "." . VERIFY_RESULTS_LINE_NUMBER; $f_verify_tot_phy_mem = $tbl_verify_results . "." . VERIFY_RESULTS_TOTAL_PHY_MEM; $f_verify_free_phy_mem = $tbl_verify_results . "." . VERIFY_RESULTS_FREE_PHY_MEM; $f_verify_tot_vir_mem = $tbl_verify_results . "." . VERIFY_RESULTS_TOTAL_VIR_MEM; $f_verify_free_vir_mem = $tbl_verify_results . "." . VERIFY_RESULTS_FREE_VIR_MEM; $f_verify_cur_mem_util = $tbl_verify_results . "." . VERIFY_RESULTS_CUR_MEM_UTIL; $f_verify_tot_page_file = $tbl_verify_results . "." . VERIFY_RESULTS_TOTAL_PAGE_FILE; $f_verify_free_page_file = $tbl_verify_results . "." . VERIFY_RESULTS_FREE_PAGE_FILE; $f_verify_custom_1 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_1; $f_verify_custom_2 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_2; $f_verify_custom_3 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_3; $f_verify_custom_4 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_4; $f_verify_custom_5 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_5; $f_verify_custom_6 = $tbl_verify_results . "." . VERIFY_RESULTS_SHOW_CUSTOM_6; $f_verify_comment = $tbl_verify_results . "." . VERIFY_RESULTS_COMMENT; $f_verify_action = $tbl_verify_results . "." . VERIFY_RESULTS_ACTION; $f_verify_expected_result = $tbl_verify_results . "." . VERIFY_RESULTS_EXPECTED_RESULT; $f_verify_actual_result = $tbl_verify_results . "." . VERIFY_RESULTS_ACTUAL_RESULT; $f_verify_results_window = $tbl_verify_results . "." . VERIFY_RESULTS_WINDOW; $f_verify_object = $tbl_verify_results . "." . VERIFY_RESULTS_OBJ; $f_verify_object_type = $tbl_verify_results . "." . VERIFY_RESULTS_OBJ_TYPE; $f_verify_validation_id = $tbl_verify_results . "." . VERIFY_RESULTS_VAL_ID; $f_verify_ts_run_id = $tbl_verify_results . "." . VERIFY_RESULTS_TS_UNIQUE_RUN_ID; $f_verify_time = $tbl_verify_results . "." . VERIFY_RESULTS_TIMESTAMP; $f_verify_defect_id = $tbl_verify_results . "." . VERIFY_RESULTS_DEFECT_ID; $q = "\tSELECT\n\t\t\t\t{$f_ts_results_unique_run_id},\n\t\t\t\t{$f_ts_results_ts},\n\t\t\t\t{$f_ts_results_os},\n\t\t\t\t{$f_verify_action},\n\t\t\t\t{$f_verify_test_status},\n\t\t\t\t{$f_verify_time},\n\t\t\t\t{$f_verify_results_window},\n\t\t\t\t{$f_verify_object},\n\t\t\t\t{$f_verify_custom_1},\n\t\t\t\t{$f_verify_custom_2},\n\t\t\t\t{$f_verify_custom_3},\n\t\t\t\t{$f_verify_custom_4},\n\t\t\t\t{$f_verify_custom_5},\n\t\t\t\t{$f_verify_custom_6},\n\t\t\t\t{$f_verify_validation_id},\n\t\t\t\t{$f_verify_results_id},\n\t\t\t\t{$f_verify_actual_result},\n\t\t\t\t{$f_verify_expected_result},\n\t\t\t\t{$f_verify_defect_id}\n\t\t\tFROM {$tbl_verify_results}\n\t\t\tINNER JOIN {$tbl_ts_results}\n\t\t\t\tON {$f_verify_unique_run} = {$f_ts_results_unique_run_id}\n\t\t\tINNER JOIN {$tbl_testset}\n\t\t\t\tON {$f_testset_id} = {$f_ts_results_testset_id}\n\t\t\tWHERE\n\t\t\t\t{$f_testset_id} = {$testset_id}\n\t\t\t\tAND {$f_testset_archive} = 'N'"; if ($bugs_only) { $q .= " AND {$f_verify_defect_id} != 0"; } else { $q .= " AND {$f_verify_test_status} = 'FAIL'"; } $q .= "\tORDER BY {$order_by} {$order_dir}"; //print"$q<br>"; global $db; if (RECORDS_PER_PAGE_REPORT_FAILED_VERIFIS != 0) { # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * RECORDS_PER_PAGE_REPORT_FAILED_VERIFIS; html_table_offset(db_num_rows($db, db_query($db, $q)), RECORDS_PER_PAGE_REPORT_FAILED_VERIFIS, $page_number); $q .= " LIMIT {$offset}, " . RECORDS_PER_PAGE_REPORT_FAILED_VERIFIS; } $rows = db_fetch_array($db, db_query($db, $q)); return $rows; }
function bug_get($project_id, $page_number = 0, $order_by = BUG_ID, $order_dir = "DESC", $bug_status, $category = "", $component = "", $reported_by = "", $assigned_to = "", $assigned_to_developer = "", $found_in_release = "", $assigned_to_release = null, $per_page = null, $view_closed = 'No', $search = "", $jump = "", $csv_name = null) { global $db; $bug_tbl = BUG_TBL; $f_bug_id = $bug_tbl . "." . BUG_ID; $f_bug_project_id = $bug_tbl . "." . BUG_PROJECT_ID; $f_bug_category_id = $bug_tbl . "." . BUG_CATEGORY; $f_bug_component_id = $bug_tbl . "." . BUG_COMPONENT; $f_priority = $bug_tbl . "." . BUG_PRIORITY; $f_severity = $bug_tbl . "." . BUG_SEVERITY; $f_closed_reason_code = $bug_tbl . "." . BUG_CLOSED_REASON_CODE; $f_status = $bug_tbl . "." . BUG_STATUS; $f_reporter = $bug_tbl . "." . BUG_REPORTER; $f_reported_date = $bug_tbl . "." . BUG_REPORTED_DATE; $f_assigned_to = $bug_tbl . "." . BUG_ASSIGNED_TO; $f_assigned_to_developer = $bug_tbl . "." . BUG_ASSIGNED_TO_DEVELOPER; $f_closed = $bug_tbl . "." . BUG_CLOSED; $f_closed_date = $bug_tbl . "." . BUG_CLOSED_DATE; $f_verify_id = $bug_tbl . "." . BUG_TEST_VERIFY_ID; $f_req_version_id = $bug_tbl . "." . BUG_REQ_VERSION_ID; $f_found_in_release = $bug_tbl . "." . BUG_FOUND_IN_RELEASE; $f_assign_to_release = $bug_tbl . "." . BUG_ASSIGN_TO_RELEASE; $f_impl_in_release = $bug_tbl . "." . BUG_IMPLEMENTED_IN_RELEASE; $f_discovery_period = $bug_tbl . "." . BUG_DISCOVERY_PERIOD; $f_summary = $bug_tbl . "." . BUG_SUMMARY; $f_description = $bug_tbl . "." . BUG_DESCRIPTION; $f_assigned_to_release = $bug_tbl . "." . BUG_ASSIGN_TO_RELEASE; $category_tbl = BUG_CATEGORY_TBL; $f_category_id = $category_tbl . "." . CATEGORY_ID; $f_category_proj_id = $category_tbl . "." . CATEGORY_PROJECT_ID; $f_category_name = $category_tbl . "." . CATEGORY_NAME; $component_tbl = BUG_COMPONENT_TBL; $f_component_id = $component_tbl . "." . COMPONENT_ID; $f_component_proj_id = $component_tbl . "." . COMPONENT_PROJECT_ID; $f_component_name = $component_tbl . "." . COMPONENT_NAME; # Add Release Table $release_tbl = RELEASE_TBL; $where_clause = " WHERE {$f_bug_project_id} = '{$project_id}'"; # STATUS if (!empty($status) && $status != 'all') { $where_clause = $where_clause . " AND {$f_bug_status} = '{$status}'"; } # CATEGORY if (!empty($category) && $category != 'all') { $where_clause = $where_clause . " AND {$f_category_id} = '{$category}'"; } # COMPONENT if (!empty($component) && $component != 'all') { $where_clause = $where_clause . " AND {$f_component_id} = '{$component}'"; } # REPORTER if (!empty($reporter) && $reporter != 'all') { $where_clause = $where_clause . " AND {$f_reporter} = '{$reporter}'"; } # ASSIGNED TO if (!empty($assigned_to) && $assigned_to != 'all') { $where_clause = $where_clause . " AND {$f_assigned_to} = '{$assigned_to}'"; } # ASSIGNED TO DEVELOPER if (!empty($assigned_to_developer) && $assigned_to_developer != 'all') { $where_clause = $where_clause . " AND {$f_assigned_to_developer} = '{$assigned_to_developer}'"; } # FOUND IN RELEASE if (!empty($found_in_release) && $found_in_release != 'all') { $where_clause = $where_clause . " AND {$f_found_in_release} = '{$found_in_release}'"; } # ASSIGN TO RELEASE if (!empty($assigned_to_release) && $assigned_to_release != 'all') { $where_clause = $where_clause . " AND {$f_assigned_to_release} = '{$assigned_to_release}'"; } # VIEW CLOSED if ($view_closed == lang_get('no')) { $where_clause = $where_clause . " AND {$f_status} != 'Closed'"; } else { //print"view_closed = $view_closed<br>"; } # SEARCH if (!empty($search)) { $where_clause = $where_clause . " AND ( ({$f_summary} LIKE '%{$search}%') OR ({$f_description} LIKE '%{$search}%') )"; } //$where_clause = substr( $where_clause, 4, strlen($where_clause) ); //$where_clause .= $where_clause; $q = "\tSELECT\n\t\t\t\t{$f_bug_id},\n\t\t\t\t{$f_priority},\n\t\t\t\t{$f_severity},\n\t\t\t\t{$f_status},\n\t\t\t\t{$f_bug_category_id},\n\t\t\t\t{$f_reporter},\n\t\t\t\t{$f_assigned_to},\n\t\t\t\t{$f_assigned_to_developer},\n\t\t\t\t{$f_found_in_release},\n\t\t\t\t{$f_assign_to_release},\n\t\t\t\t{$f_description},\n\t\t\t\t{$f_summary},\n\t\t\t\t{$f_bug_project_id},\n\t\t\t\t{$f_bug_component_id},\n\t\t\t\t{$f_closed_reason_code},\n\t\t\t\t{$f_reported_date},\n\t\t\t\t{$f_closed},\n\t\t\t\t{$f_closed_date},\n\t\t\t\t{$f_verify_id},\n\t\t\t\t{$f_req_version_id},\n\t\t\t\t{$f_impl_in_release},\n\t\t\t\t{$f_discovery_period},\n\t\t\t\t{$f_category_id},\n\t\t\t\t{$f_category_name},\n\t\t\t\t{$f_component_id},\n\t\t\t\t{$f_component_name}\n\t\t\tFROM {$bug_tbl}\n\t\t\tLEFT JOIN {$category_tbl} ON {$f_bug_category_id} = {$f_category_id}\n\t\t\tLEFT JOIN {$component_tbl} ON {$f_bug_component_id} = {$f_component_id}"; $q .= "\t{$where_clause}\n\t\t\tORDER BY {$order_by} {$order_dir}"; #print"$q<br>"; if (is_null($per_page)) { $display_options = session_get_filter_options("bug"); $per_page = $display_options['per_page']; } if ($per_page != 0 && $page_number != 0) { $row_count = db_num_rows($db, db_query($db, $q)); $page_number = util_page_number($page_number, $row_count, $per_page); # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * $per_page; html_table_offset($row_count, $per_page, $page_number, $order_by, $order_dir, $csv_name); $q .= " LIMIT {$offset}, " . $per_page; } #print"$q<br>"; $rows = db_fetch_array($db, db_query($db, $q)); return $rows; }
function testset_filter_apply($where_clause, $project_id, $per_page, $order_by, $order_dir, $page_number) { global $db; $tbl_release = RELEASE_TBL; $tbl_build = BUILD_TBL; $tbl_testset = TS_TBL; $tbl_tsa = TEST_TS_ASSOC_TBL; $f_testset_id = $tbl_testset . "." . TS_ID; $f_testset_name = $tbl_testset . "." . TS_NAME; $f_test_ts_id = $tbl_tsa . "." . TEST_TS_ASSOC_TS_ID; $f_testset_build_id = $tbl_testset . "." . TS_BUILD_ID; $f_build_name = $tbl_build . "." . BUILD_NAME; $f_build_id = $tbl_build . "." . BUILD_ID; $f_build_release_id = $tbl_build . "." . BUILD_REL_ID; $f_release_id = $tbl_release . "." . RELEASE_ID; $f_project_id = $tbl_release . "." . RELEASE_PROJECT_ID; $f_release_name = $tbl_release . "." . RELEASE_NAME; $f_date_created = $tbl_testset . "." . TS_DATE_CREATED; $csv_name = null; $q = "SELECT {$f_testset_id}, {$f_date_created}, {$f_testset_name}, {$f_build_name}, {$f_release_name}, {$f_date_created} \t\t\n\t\tFROM {$tbl_testset}, {$tbl_build}, {$tbl_release}\n\t\tWHERE {$f_testset_build_id} = {$f_build_id} \n\t\tAND {$f_build_release_id} = {$f_release_id}\n\t\tAND {$f_project_id} = {$project_id} " . $where_clause . "\n\t\tGROUP BY {$f_testset_id}"; $order_clause = " ORDER BY {$order_by} {$order_dir}"; $q .= $order_clause; if ($per_page != 0 && $page_number != 0) { $row_count = db_num_rows($db, db_query($db, $q)); $page_number = util_page_number($page_number, $row_count, $per_page); # Add the limit clause to the query so that we only show n number of records per page $offset = ($page_number - 1) * $per_page; html_table_offset($row_count, $per_page, $page_number, $order_by, $order_dir, $csv_name); $q .= " LIMIT {$offset}, " . $per_page; } $rs = db_query($db, $q); return db_fetch_array($db, $rs); }