$name = "<a href=\"javascript:openAssignmentOverviewWindow(" . "{$user_id}, {$build_id}, {$args->tplan_id});\">{$names[$user_id]['login']}</a>";
$current_row[] = $name;
// total count of testcases assigned to this user on this build
$current_row[] = $statistics['total'];
// add count and percentage for each possible status
foreach ($statusCfg as $status => $code) {
$current_row[] = $statistics[$status]['count'];
$current_row[] = $statistics[$status]['percentage'];
}
$current_row[] = $statistics['progress'];
$current_row[] = minutes2HHMMSS($statistics['total_time']);
// add this row to the others
$rows[] = $current_row;
}
}
$columns = getTableHeader($statusCfg);
$smartTable = new tlExtTable($columns, $rows, 'tl_table_results_by_tester_per_build');
$smartTable->title = lang_get('results_by_tester_per_build');
$smartTable->setGroupByColumnName(lang_get('build'));
// enable default sorting by progress column
$smartTable->setSortByColumnName(lang_get('progress'));
//define toolbar
$smartTable->showToolbar = true;
$smartTable->toolbarExpandCollapseGroupsButton = true;
$smartTable->toolbarShowAllColumnsButton = true;
$gui->tableSet = array($smartTable);
// show warning message instead of table if table is empty
$gui->warning_message = count($rows) > 0 ? '' : lang_get('no_testers_per_build');
$smarty = new TLSmarty();
$smarty->assign('gui', $gui);
$smarty->display($templateCfg->template_dir . $templateCfg->default_template);
function ListR3($sql, $attr, $link, $conexion = null)
{
$atributosDefault = array('id' => '', 'class' => 'reporteA', 'checked' => '', 'paginador' => '', 'fieldTotal' => '');
$linkDefault = array('campos' => '', 'args' => '', 'panelId' => '', 'url' => '');
$linksUrl = array('head' => '', 'body' => '');
$atributos = defaultArrayValues($atributosDefault, $attr);
$paginador = explode(',', $atributos['paginador']);
$paginaStart = is_int((int) get('pagina-start')) && (int) get('pagina-start') > 0 ? get('pagina-start') : 1;
$start = ($paginaStart - 1) * $paginador[0];
$limit = ' LIMIT ' . $start . ', ' . $paginador[0];
$sql = filterSql($sql) . $limit;
$result = getResult($sql, $conexion);
$count = getResult("SELECT FOUND_ROWS() AS total", $conexion);
$row = mysql_fetch_object($count);
$countTotal = $row->total;
$pagitacionHtml = getPagination($paginaStart, $countTotal, $paginador[0], $paginador[1]);
if (!empty($link)) {
$linkArray = explode('}', $link);
if (isset($linkArray[1])) {
$linksUrl['body'] = defaultArrayValues($linkDefault, $linkArray[1]);
$linksUrl['head'] = defaultArrayValues($linkDefault, $linkArray[0]);
} else {
$linksUrl['body'] = defaultArrayValues($linkDefault, $linkArray[0]);
}
}
$fieldsName = getFieldsName($result);
$fieldsFilter = fieldsFilter($fieldsName, $linksUrl);
$tableHeader = getTableHeader($fieldsFilter, $atributos);
$tableBody = getTableBody($result, $fieldsFilter, $atributos, $countTotal);
$tabla .= "<table id=\"{$atributos['id']}\" class=\"{$atributos['class']}\" style=\"width:100%;clear: both;\">" . "{$tableHeader}{$tableBody}" . "</table>" . "</form>" . "{$pagitacionHtml}";
if ($atributos['checked'] == "checked") {
$tabla = "<form method=\"post\" id=\"frm-{$atributos['id']}\">" . $tabla;
$tabla .= "</form>";
}
return $tabla;
}
function ListR4($sql, $attr, $link, $SUMMARY_STYLE, $conexion = null)
{
## ARRAYS DEFAULT DC
$atributosDefault = array('id' => '', 'class' => 'reporteA', 'checked' => '', 'paginador' => '', 'fieldTotal' => '');
$linkDefault = array('campos' => '', 'args' => '', 'panelId' => '', 'url' => '');
$linksUrl = array('head' => '', 'body' => '');
$SUMMARY_STYLE_DEFAULT = array('columns_index' => '', 'summary_css' => '');
## CHANGING ARRAYS VALUES
$atributos = defaultArrayValues($atributosDefault, $attr);
$SUMMARY_COLS_CSS = defaultArrayValues($SUMMARY_STYLE_DEFAULT, $SUMMARY_STYLE);
$paginador = explode(',', $atributos['paginador']);
////CONSTRUYE PARTE DE LA URL DEL PAGINADOR
$urlSeg = explode('?', $paginador[1]);
$urlSegA = $urlSeg[1];
$urlSegB = explode('=', $urlSegA);
$urlSegUrl = $urlSegB[0];
$paginaStart = is_int((int) get('' . $urlSegUrl . 'pagina-start')) && (int) get('' . $urlSegUrl . 'pagina-start') > 0 ? get('' . $urlSegUrl . 'pagina-start') : 1;
$start = ($paginaStart - 1) * $paginador[0];
$limit = ' LIMIT ' . $start . ', ' . $paginador[0];
$sql = filterSql($sql);
## EXTRAYENDO EL TOTAL DE FILAS
getResult($sql, $conexion);
$count = getResult("SELECT FOUND_ROWS() AS total", $conexion);
$row = mysql_fetch_object($count);
$countTotal = $row->total;
$sql = $sql . $limit;
$result = getResult($sql, $conexion);
$pagitacionHtml = getPagination($paginaStart, $countTotal, $paginador[0], $paginador[1]);
if (!empty($link)) {
$linkArray = explode('}', $link);
if (isset($linkArray[1])) {
$linksUrl['body'] = defaultArrayValues($linkDefault, $linkArray[1]);
$linksUrl['head'] = defaultArrayValues($linkDefault, $linkArray[0]);
} else {
$linksUrl['body'] = defaultArrayValues($linkDefault, $linkArray[0]);
}
}
$fieldsName = getFieldsName($result);
$fieldsFilter = fieldsFilter($fieldsName, $linksUrl);
//vd($fieldsFilter);vd($atributos);
$tableHeader = getTableHeader($fieldsFilter, $atributos);
$tableBody = getTableBody($result, $fieldsFilter, $atributos, $countTotal, $SUMMARY_COLS_CSS);
$tabla .= "<table id=\"{$atributos['id']}\" class=\"{$atributos['class']}\" style=\"width:100%;clear: both;\">" . "{$tableHeader}{$tableBody}" . "</table>" . "</form>" . "{$pagitacionHtml}";
if ($atributos['checked'] == "checked") {
$tabla = "<form method=\"post\" id=\"frm-{$atributos['id']}\">" . $tabla;
$tabla .= "</form>";
}
return $tabla;
}
