function test_workflow_filter_rows($project_id, $manauto, $test_type, $baowner, $qaowner, $tester, $area_tested, $test_status, $priority, $per_page, $test_search, $orderby, $order_dir, $page_number, $csv_name = null) { $where_clause = test_workflow_filter_generate_where_clause($manauto, $test_type, $baowner, $qaowner, $tester, $area_tested, $test_status, $priority, $test_search); $row = test_apply_filter($project_id, $where_clause, $per_page, $orderby, $order_dir, $page_number, $csv_name); return $row; }
# # $RCSfile: test_workflow_csv_export.php,v $ $Revision: 1.2 $ # --------------------------------------------------------------------- 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_workflow_form_filter_options = session_get_filter_options("test_workflow"); $s_test_workflow_table_display_options = session_get_display_options("test_workflow"); $where_clause = test_workflow_filter_generate_where_clause($s_test_workflow_form_filter_options['manauto'], $s_test_workflow_form_filter_options['baowner'], $s_test_workflow_form_filter_options['qaowner'], $s_test_workflow_form_filter_options['test_status']); $order_clause = ' ORDER BY ' . $s_test_workflow_table_display_options['order_by'] . ' ' . $s_test_workflow_table_display_options['order_dir']; # set table headers print "Test ID, M/A, Test Name, Test Status, Priority, BA Owner, QA Owner, Date Assigned, Date Expected, Date Complete, BA Sign Off Date, Info\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_status = ${'v_' . TEST_STATUS}; $test_priority = ${'v_' . TEST_PRIORITY};