Esempi in PHP per test_workflow_filter_generate_where_clause

Esempio n. 1

File: test_api.php Progetto: nourchene-benslimane/rth_backup

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

Esempio n. 2

File: test_workflow_csv_export.php Progetto: nourchene-benslimane/rth_backup

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