$map_status_code = $results_config['status_code'];
$map_code_status = $results_config['code_status'];
$map_status_label = $results_config['status_label'];
$map_statuscode_css = array();
foreach ($map_code_status as $code => $status) {
if (isset($map_status_label[$status])) {
$label = $map_status_label[$status];
$map_statuscode_css[$code] = array();
$map_statuscode_css[$code]['translation'] = lang_get($label);
$map_statuscode_css[$code]['css_class'] = $map_code_status[$code] . '_text';
}
}
// Get all test cases created by user in the current project
$options = new stdClass();
$options->mode = 'full_path';
$gui->resultSet = $tcase_mgr->get_created_per_user($args->tproject_id, $args->tplan_id, $options);
if ($doIt = !is_null($gui->resultSet)) {
$tables = tlObjectWithDB::getDBTables(array('nodes_hierarchy'));
$tplanSet = array_keys($gui->resultSet);
$sql = "SELECT name,id FROM {$tables['nodes_hierarchy']} " . "WHERE id IN (" . implode(',', $tplanSet) . ")";
$gui->tplanNames = $db->fetchRowsIntoMap($sql, 'id');
$optColumns = array('priority' => $args->priority_enabled);
foreach ($gui->resultSet as $tplan_id => $tcase_set) {
list($columns, $sortByColumn) = getColumnsDefinition($optColumns);
$rows = array();
foreach ($tcase_set as $tcase_platform) {
foreach ($tcase_platform as $tcase) {
$current_row = array();
$tcase_id = $tcase['testcase_id'];
$tcversion_id = $tcase['tcversion_id'];
$current_row[] = htmlspecialchars($tcase['login']);
/**
* initialize Gui
*/
function initializeGui(&$db, &$args, $dateFormat)
{
$gui = new stdClass();
$gui->glueChar = config_get('testcase_cfg')->glue_character;
$gui->tproject_id = $args->tproject_id;
$gui->tproject_name = $args->tproject_name;
$gui->warning_msg = '';
$gui->tableSet = null;
$history_img = TL_THEME_IMG_DIR . "history_small.png";
$exec_img = TL_THEME_IMG_DIR . "exec_icon.png";
$edit_img = TL_THEME_IMG_DIR . "edit_icon.png";
$l18n = init_labels(array('tcversion_indicator' => null, 'goto_testspec' => null, 'version' => null, 'testplan' => null, 'assigned_tc_overview' => null, 'testcases_created_per_user' => null, 'design' => null, 'execution' => null, 'execution_history' => null, 'low_priority' => null, 'medium_priority' => null, 'high_priority' => null));
$gui->pageTitle = sprintf($l18n['testcases_created_per_user'], $gui->tproject_name);
$results_config = config_get('results');
$map_status_code = $results_config['status_code'];
$map_code_status = $results_config['code_status'];
$map_status_label = $results_config['status_label'];
$map_statuscode_css = array();
foreach ($map_code_status as $code => $status) {
if (isset($map_status_label[$status])) {
$label = $map_status_label[$status];
$map_statuscode_css[$code] = array();
$map_statuscode_css[$code]['translation'] = lang_get($label);
$map_statuscode_css[$code]['css_class'] = $map_code_status[$code] . '_text';
}
}
$options = new stdClass();
// convert starttime to iso format for database usage
if (isset($args->selected_start_date) && sizeof($args->selected_start_date) > 0) {
$date_array = split_localized_date($args->selected_start_date[0], $dateFormat);
if ($date_array != null) {
// set date in iso format
$options->startTime = $date_array['year'] . "-" . $date_array['month'] . "-" . $date_array['day'];
}
}
// convert starttime to iso format for database usage
if (isset($args->selected_end_date) && sizeof($args->selected_end_date) > 0) {
$date_array = split_localized_date($args->selected_end_date[0], $dateFormat);
if ($date_array != null) {
// set date in iso format
$options->endTime = $date_array['year'] . "-" . $date_array['month'] . "-" . $date_array['day'];
}
}
$start_hour = isset($args->start_Hour) ? $args->start_Hour : "00";
$options->startTime = $options->startTime . " " . $start_hour . ":00:00";
$end_hour = isset($args->end_Hour) ? $args->end_Hour : "00";
$options->endTime = $options->endTime . " " . $end_hour . ":59:59";
$options->mode = 'full_path';
// TBD: remove it
$options->tplan_id = $args->tplan_id;
// used to retrieve test cases from
$tcase_mgr = new testcase($db);
$gui->resultSet = $tcase_mgr->get_created_per_user($args->user_id, $args->tproject_id, $options);
if (!is_null($gui->resultSet)) {
$tables = tlObjectWithDB::getDBTables(array('nodes_hierarchy'));
$tplanSet = array_keys($gui->resultSet);
$sql = "SELECT name,id FROM {$tables['nodes_hierarchy']} " . "WHERE id IN (" . implode(',', $tplanSet) . ")";
$gui->tplanNames = $db->fetchRowsIntoMap($sql, 'id');
$optColumns = array('priority' => $args->priority_enabled);
// For each test case set under a test plan ID, create the rows and columns
foreach ($gui->resultSet as $tplan_id => $tcase_set) {
list($columns, $sortByColumn) = getColumnsDefinition($optColumns);
$rows = array();
foreach ($tcase_set as $tcase_platform) {
foreach ($tcase_platform as $tcase) {
$current_row = array();
$tcase_id = $tcase['testcase_id'];
$tcversion_id = $tcase['tcversion_id'];
$current_row[] = htmlspecialchars($tcase['login']);
$current_row[] = htmlspecialchars($tcase['tcase_full_path']);
// Create linked icons
$exec_history_link = "<a href=\"javascript:openExecHistoryWindow({$tcase_id});\">" . "<img title=\"{$l18n['execution_history']}\" src=\"{$history_img}\" /></a> ";
$edit_link = "<a href=\"javascript:openTCEditWindow({$tcase_id});\">" . "<img title=\"{$l18n['design']}\" src=\"{$edit_img}\" /></a> ";
$current_row[] = "<!-- " . sprintf("%010d", $tcase['tc_external_id']) . " -->" . $exec_history_link . $edit_link . htmlspecialchars($tcase['prefix']) . $gui->glueChar . $tcase['tc_external_id'] . " : " . htmlspecialchars($tcase['name']) . sprintf($l18n['tcversion_indicator'], $tcase['version']);
$last_execution = $tcase_mgr->get_last_execution($tcase_id, $tcversion_id, $tplan_id, $tcase['build_id'], $tcase['platform_id']);
$status = $last_execution[$tcversion_id]['status'];
if (!$status) {
$status = $map_status_code['not_run'];
}
$current_row[] = array("value" => $status, "text" => $map_statuscode_css[$status]['translation'], "cssClass" => $map_statuscode_css[$status]['css_class']);
$current_row[] = $tcase['creation_ts'];
$current_row[] = $tcase['modification_ts'];
// add this row to the others
$rows[] = $current_row;
}
}
// Different table ID for different reports:
$table_id = "tl_table_tc_created_per_user_";
// Add test plan ID to table ID
$table_id .= $tplan_id;
$matrix = new tlExtTable($columns, $rows, $table_id);
$matrix->title = $l18n['testplan'] . ": " . htmlspecialchars($gui->tplanNames[$tplan_id]['name']);
// Default grouping by first column, which is user for overview, build otherwise
$matrix->setGroupByColumnName(lang_get($columns[0]['title_key']));
// Make table collapsible if more than 1 table is shown and surround by frame
if (count($tplanSet) > 1) {
$matrix->collapsible = true;
$matrix->frame = true;
}
// Define toolbar
$matrix->showToolbar = true;
$matrix->toolbarExpandCollapseGroupsButton = true;
$matrix->toolbarShowAllColumnsButton = true;
$matrix->setSortByColumnName($sortByColumn);
$matrix->sortDirection = 'DESC';
$gui->tableSet[$tplan_id] = $matrix;
}
}
return $gui;
}
