# # $RCSfile: test_csv_export.php,v $ $Revision: 1.3 $ # --------------------------------------------------------------------- include "./api/include_api.php"; auth_authenticate_user(); header('Content-Type: text/plain; name=data.csv'); header('Content-Transfer-Encoding: BASE64;'); header('Content-Disposition: attachment; filename=data.csv'); global $db; $deleted = TEST_TBL . "." . TEST_DELETED; $archived = TEST_TBL . "." . TEST_ARCHIVED; $test_tbl = TEST_TBL; # get filter and sort options off the session $s_test_form_filter_options = session_get_filter_options("test"); $s_test_table_display_options = session_get_display_options("test"); $where_clause = test_filter_generate_where_clause($s_test_form_filter_options['manauto'], $s_test_form_filter_options['baowner'], $s_test_form_filter_options['qaowner'], $s_test_form_filter_options['test_type'], $s_test_form_filter_options['test_area']); $order_clause = ' ORDER BY ' . $s_test_table_display_options['order_by'] . ' ' . $s_test_table_display_options['order_dir']; # set table headers print "Test ID, M/A, File Type, Auto Pass, Test Name, BA Owner, QA Owner, Test Type, Area Tested\r" . NEWLINE; $q = "SELECT * FROM {$test_tbl} WHERE {$deleted} = 'N' AND {$archived} = 'N'"; $q = $q . $where_clause . $order_clause; $rs =& db_query($db, $q); while ($row = db_fetch_row($db, $rs)) { extract($row, EXTR_PREFIX_ALL, 'v'); $test_id = ${'v_' . TEST_ID}; $test_name = ${'v_' . TEST_NAME}; $ba_owner = ${'v_' . TEST_BA_OWNER}; $qa_owner = ${'v_' . TEST_QA_OWNER}; $tester = ${'v_' . TEST_TESTER}; $test_type = ${'v_' . TEST_TESTTYPE}; $manual = ${'v_' . TEST_MANUAL};
function test_copy_filter_rows($project_id, $release_id, $build_id, $testset_id, $filter_man_auto, $filter_ba_owner, $filter_qa_owner, $filter_tester, $filter_test_type, $filter_area_tested, $filter_priority, $per_page, $test_search, $order_by, $order_dir, $page_number) { $where_clause = test_filter_generate_where_clause($filter_man_auto, $filter_ba_owner, $filter_qa_owner, $filter_tester, $filter_test_type, $filter_area_tested, $test_status = "", $filter_priority, $test_search); $row = test_copy_apply_filter($project_id, $release_id, $build_id, $testset_id, $per_page, $order_by, $order_dir, $page_number, $where_clause); return $row; }