#
# $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;
}
