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