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