function getTableBody($result, stdClass $fieldsFilter, array $atributos, $totalRegistros) { $return = $footer = $html = ''; $groupId = 0; $subgroupId = 0; if (isResult($result) && !empty($fieldsFilter->head['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { if ($groupId != $row['groupId'] && $subgroupId != $row['subgroupId']) { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); if ($groupId > 0 && $subgroupId > 0) { $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); } $groupId = $row['groupId']; $subgroupId = $row['subgroupId']; $dataRowHead = getDataRow($row, $fieldsFilter->head['campos'], $fieldsFilter->head['args'], $colspans['head']); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $eventHead = !empty($dataRowHead['args']) && !empty($fieldsFilter->head['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->head['url']}&{$dataRowHead['args']}\",\"{$fieldsFilter->head['panel']}\");" : ''; $html .= "{$footer}<tr {$eventHead} >{$dataRowHead['html']}</tr>"; $total = $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } else { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $total += $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); $return = '<tbody>' . $html . $footer . '</tbody>'; } elseif (isResult($result) && !empty($fieldsFilter->body['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { $i .= '1'; $checked = getChecked($row, $atributos['checked']); $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$checked}{$dataRowBody['html']}</tr>"; $total += $dataRowBody['value']; } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, $atributos['checked'], 'tfoot', $totalRegistros); $return = '<tbody>' . $html . '</tbody>' . $footer; } return $return; }
function getTableBody($result, stdClass $fieldsFilter, array $atributos, $totalRegistros, $SUMMARY_COLS_CSS = null) { ## DEFINIENDO la variable GET pagina-start para la url de los registros $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; ## FIN DEFINICIÓN la variable GET pagina-start para la url de los registros $return = $footer = $html = ''; $groupId = 0; if (isResult($result) && !empty($fieldsFilter->head['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { if ($groupId != $row['groupId']) { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); if ($groupId > 0) { $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); } $groupId = $row['groupId']; $dataRowHead = getDataRow($row, $fieldsFilter->head['campos'], $fieldsFilter->head['args'], $colspans['head']); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $eventHead = !empty($dataRowHead['args']) && !empty($fieldsFilter->head['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->head['url']}&{$dataRowHead['args']}\",\"{$fieldsFilter->head['panel']}\");" : ''; $html .= "{$footer}<tr {$eventHead} >{$dataRowHead['html']}</tr>"; $total = $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } else { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $total += $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); // var_dump($total); $return = '<tbody>' . $html . $footer . '</tbody>'; } elseif (isResult($result) && !empty($fieldsFilter->body['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { $checked = getChecked($row, $atributos['checked']); $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$checked}{$dataRowBody['html']}</tr>"; $total += $dataRowBody['value']; } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, $atributos['checked'], 'tfoot', $totalRegistros); $return = '<tbody>' . $html . '</tbody>' . $footer; } return $return; }