PHP showpagenav Exemples

Exemple #1

Fichier : tarefa.php Projet : relson/AgendaRS

function select()
{
    global $a;
    global $showrecs;
    global $page;
    global $filter;
    global $filterfield;
    global $wholeonly;
    global $order;
    global $ordtype;
    if ($a == "reset") {
        $filter = "";
        $filterfield = "";
        $wholeonly = "";
        $order = "";
        $ordtype = "";
    }
    $checkstr = "";
    if ($wholeonly) {
        $checkstr = " checked";
    }
    if ($ordtype == "asc") {
        $ordtypestr = "desc";
    } else {
        $ordtypestr = "asc";
    }
    $res = sql_select();
    $count = sql_getrecordcount();
    if ($count % $showrecs != 0) {
        $pagecount = intval($count / $showrecs) + 1;
    } else {
        $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {
        mysql_data_seek($res, $startrec);
    }
    $reccount = min($showrecs * $page, $count);
    ?>
    <table class="bd" border="0" cellspacing="1" cellpadding="4">
        <tr><td>Cadastro: tarefa</td></tr>
        <tr><td>Exibindo registros <?php 
    echo $startrec + 1;
    ?>
 - <?php 
    echo $reccount;
    ?>
 of <?php 
    echo $count;
    ?>
</td></tr>
    </table>
    <hr size="1" noshade>
    <form action="tarefa.php" method="post">
        <table class="bd" border="0" cellspacing="1" cellpadding="4">
            <tr>
                <td><b>Filtros</b>&nbsp;</td>
                <td><input type="text" name="filter" value="<?php 
    echo $filter;
    ?>
"></td>
                <td><select name="filter_field">
                        <option value="">Todos os Campos</option>
                        <option value="<?php 
    echo "codigoTarefa";
    ?>
"<?php 
    if ($filterfield == "codigoTarefa") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Código");
    ?>
</option>
                        <option value="<?php 
    echo "lp_codigoTarefaStatus";
    ?>
"<?php 
    if ($filterfield == "lp_codigoTarefaStatus") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Status");
    ?>
</option>
                        <option value="<?php 
    echo "dataInicio";
    ?>
"<?php 
    if ($filterfield == "dataInicio") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Data de Inicio");
    ?>
</option>
                        <option value="<?php 
    echo "horaInicial";
    ?>
"<?php 
    if ($filterfield == "horaInicial") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Hora de Inicio");
    ?>
</option>
                        <option value="<?php 
    echo "dataLimite";
    ?>
"<?php 
    if ($filterfield == "dataLimite") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Data Limite");
    ?>
</option>
                        <option value="<?php 
    echo "horaLimite";
    ?>
"<?php 
    if ($filterfield == "horaLimite") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Hora Limite");
    ?>
</option>
                        <option value="<?php 
    echo "titulo";
    ?>
"<?php 
    if ($filterfield == "titulo") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Titulo");
    ?>
</option>
                        <option value="<?php 
    echo "descricao";
    ?>
"<?php 
    if ($filterfield == "descricao") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Descricao");
    ?>
</option>
                        <option value="<?php 
    echo "lp_codigoTarefaPrioridade";
    ?>
"<?php 
    if ($filterfield == "lp_codigoTarefaPrioridade") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Prioridade");
    ?>
</option>
                        <option value="<?php 
    echo "datahoracriacao";
    ?>
"<?php 
    if ($filterfield == "datahoracriacao") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Criado em");
    ?>
</option>
                    </select></td>
                <td><input type="checkbox" name="wholeonly"<?php 
    echo $checkstr;
    ?>
>Coincidir palavras completas</td>
                </td></tr>
            <tr>
                <td>&nbsp;</td>
                <td><input type="submit" name="action" value="Filtrar"></td>
                <td><a href="tarefa.php?a=reset">Limpar Filtro</a></td>
            </tr>
        </table>
    </form>
    <hr size="1" noshade>
        <?php 
    showpagenav($page, $pagecount);
    ?>
    <br>
    <table class="tbl" border="0" cellspacing="1" cellpadding="5"width="100%">
        <tr>
            <td class="hr">&nbsp;</td>
            <td class="hr">&nbsp;</td>
            <td class="hr">&nbsp;</td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "codigoTarefa";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Codigo");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "lp_codigoTarefaStatus";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Status");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "dataInicio";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Data de Inicio");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "horaInicial";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Hora de Inicio");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "dataLimite";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Data Limite");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "horaLimite";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Hora Limite");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "titulo";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Titulo");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "descricao";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Descricao");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "lp_codigoTarefaPrioridade";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Prioridade");
    ?>
</a></td>
            <td class="hr"><a class="hr" href="tarefa.php?order=<?php 
    echo "datahoracriacao";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Criado em");
    ?>
</a></td>
        </tr>
    <?php 
    for ($i = $startrec; $i < $reccount; $i++) {
        $row = mysql_fetch_assoc($res);
        $style = "dr";
        if ($i % 2 != 0) {
            $style = "sr";
        }
        ?>
            <tr>
                <td class="<?php 
        echo $style;
        ?>
"><a href="tarefa.php?a=view&recid=<?php 
        echo $i;
        ?>
">Ver</a></td>
                <td class="<?php 
        echo $style;
        ?>
"><a href="tarefa.php?a=edit&recid=<?php 
        echo $i;
        ?>
">Editar</a></td>
                <td class="<?php 
        echo $style;
        ?>
"><a href="tarefa.php?a=del&recid=<?php 
        echo $i;
        ?>
">Excluir</a></td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["codigoTarefa"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_codigoTarefaStatus"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["dataInicio"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["horaInicial"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["dataLimite"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["horaLimite"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["titulo"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["descricao"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_codigoTarefaPrioridade"]);
        ?>
</td>
                <td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["datahoracriacao"]);
        ?>
</td>
            </tr>
        <?php 
    }
    mysql_free_result($res);
    ?>
    </table>
    <br>
    <?php 
    showpagenav($page, $pagecount);
}

Exemple #2

Fichier : bancos_operaciones.raw.php Projet : Cywaithaka/S.A.F.E.-Open-Source-Microfinance-Suite

function select()
{
    global $a;
    global $showrecs;
    global $page;
    global $filter;
    global $filterfield;
    global $wholeonly;
    global $order;
    global $ordtype;
    if ($a == "reset") {
        $filter = "";
        $filterfield = "";
        $wholeonly = "";
        $order = "";
        $ordtype = "";
    }
    $checkstr = "";
    if ($wholeonly) {
        $checkstr = " checked";
    }
    if ($ordtype == "asc") {
        $ordtypestr = "desc";
    } else {
        $ordtypestr = "asc";
    }
    $res = sql_select();
    $count = sql_getrecordcount();
    if ($count % $showrecs != 0) {
        $pagecount = intval($count / $showrecs) + 1;
    } else {
        $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {
        mysql_data_seek($res, $startrec);
    }
    $reccount = min($showrecs * $page, $count);
    ?>
<table class="bd"     >
<tr><td>Origen de Datos: bancos_operaciones</td></tr>
<tr><td>Registros Mostrados <?php 
    echo $startrec + 1;
    ?>
 - <?php 
    echo $reccount;
    ?>
 of <?php 
    echo $count;
    ?>
</td></tr>
</table>
<hr size="1" noshade>
<form action="bancos_operaciones.raw.php" method="post">
<table class="bd"     >
<tr>
<td><b>Fltro Personal</b>&nbsp;</td>
<td><input type="text" name="filter" value="<?php 
    echo $filter;
    ?>
"></td>
<td><select name="filter_field">
<option value="">Todos los Registros</option>
<option value="<?php 
    echo "tipo_operacion";
    ?>
"<?php 
    if ($filterfield == "tipo_operacion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Tipo de Operacion");
    ?>
</option>
<option value="<?php 
    echo "numero_de_documento";
    ?>
"<?php 
    if ($filterfield == "numero_de_documento") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Documento");
    ?>
</option>
<option value="<?php 
    echo "lp_cuenta_bancaria";
    ?>
"<?php 
    if ($filterfield == "lp_cuenta_bancaria") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("cuenta_bancaria");
    ?>
</option>
<option value="<?php 
    echo "recibo_relacionado";
    ?>
"<?php 
    if ($filterfield == "recibo_relacionado") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Recibo Relacionado");
    ?>
</option>
<option value="<?php 
    echo "fecha_expedicion";
    ?>
"<?php 
    if ($filterfield == "fecha_expedicion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Fecha");
    ?>
</option>
<option value="<?php 
    echo "beneficiario";
    ?>
"<?php 
    if ($filterfield == "beneficiario") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("beneficiario");
    ?>
</option>
<option value="<?php 
    echo "monto_descontado";
    ?>
"<?php 
    if ($filterfield == "monto_descontado") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Monto Descontado");
    ?>
</option>
<option value="<?php 
    echo "monto_real";
    ?>
"<?php 
    if ($filterfield == "monto_real") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Monto Real");
    ?>
</option>
<option value="<?php 
    echo "estatus";
    ?>
"<?php 
    if ($filterfield == "estatus") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("estatus");
    ?>
</option>
<option value="<?php 
    echo "lp_idusuario";
    ?>
"<?php 
    if ($filterfield == "lp_idusuario") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("idusuario");
    ?>
</option>
<option value="<?php 
    echo "lp_usuario_autorizo";
    ?>
"<?php 
    if ($filterfield == "lp_usuario_autorizo") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("usuario_autorizo");
    ?>
</option>
</select></td>
<td><input type="checkbox" name="wholeonly"<?php 
    echo $checkstr;
    ?>
>Palabras Exactas solamente</td>
</td></tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="action" value="Aplicar Filtro"></td>
<td><a href="bancos_operaciones.raw.php?a=reset">Quitar Filtro</a></td>
</tr>
</table>
</form>
<hr size="1" noshade>
<?php 
    showpagenav($page, $pagecount);
    ?>
<br>
<table class="tbl"       >
<tr>
<td class="hr">&nbsp;</td>
<td class="hr">&nbsp;</td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "tipo_operacion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Tipo de Operacion");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "numero_de_documento";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Documento");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "lp_cuenta_bancaria";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("cuenta_bancaria");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "recibo_relacionado";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Recibo Relacionado");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "fecha_expedicion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Fecha");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "beneficiario";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("beneficiario");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "monto_descontado";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Monto Descontado");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "monto_real";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Monto Real");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "estatus";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("estatus");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "lp_idusuario";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("idusuario");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bancos_operaciones.raw.php?order=<?php 
    echo "lp_usuario_autorizo";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("usuario_autorizo");
    ?>
</a></td>
</tr>
<?php 
    for ($i = $startrec; $i < $reccount; $i++) {
        $row = mysql_fetch_assoc($res);
        $style = "dr";
        if ($i % 2 != 0) {
            $style = "sr";
        }
        ?>
<tr>
<td class="<?php 
        echo $style;
        ?>
"><a href="bancos_operaciones.raw.php?a=view&recid=<?php 
        echo $i;
        ?>
">Vista Previa</a></td>
<td class="<?php 
        echo $style;
        ?>
"><a href="bancos_operaciones.raw.php?a=edit&recid=<?php 
        echo $i;
        ?>
">Editar</a></td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["tipo_operacion"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["numero_de_documento"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_cuenta_bancaria"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["recibo_relacionado"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["fecha_expedicion"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["beneficiario"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["monto_descontado"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["monto_real"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["estatus"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_idusuario"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_usuario_autorizo"]);
        ?>
</td>
</tr>
<?php 
    }
    mysql_free_result($res);
    ?>
</table>
<br>
<?php 
    showpagenav($page, $pagecount);
}

Exemple #3

Fichier : general_structure.raw.php Projet : Cywaithaka/S.A.F.E.-Open-Source-Microfinance-Suite

function select()
{
    global $a;
    global $showrecs;
    global $page;
    global $filter;
    global $filterfield;
    global $wholeonly;
    global $order;
    global $ordtype;
    if ($a == "reset") {
        $filter = "";
        $filterfield = "";
        $wholeonly = "";
        $order = "";
        $ordtype = "";
    }
    $checkstr = "";
    if ($wholeonly) {
        $checkstr = " checked";
    }
    if ($ordtype == "asc") {
        $ordtypestr = "desc";
    } else {
        $ordtypestr = "asc";
    }
    $res = sql_select();
    $count = sql_getrecordcount();
    if ($count % $showrecs != 0) {
        $pagecount = intval($count / $showrecs) + 1;
    } else {
        $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {
        mysql_data_seek($res, $startrec);
    }
    $reccount = min($showrecs * $page, $count);
    ?>
<table class="bd"     >
<tr><td>Origen de Datos: general_structure</td></tr>
<tr><td>Registros Mostrados <?php 
    echo $startrec + 1;
    ?>
 - <?php 
    echo $reccount;
    ?>
 of <?php 
    echo $count;
    ?>
</td></tr>
</table>
<hr size="1" noshade>
<form action="general_structure.raw.php" method="post">
<table class="bd"     >
<tr>
<td><b>Fltro Personal</b>&nbsp;</td>
<td><input type="text" name="filter" value="<?php 
    echo $filter;
    ?>
"></td>
<td><select name="filter_field">
<option value="">Todos los Registros</option>
<option value="<?php 
    echo "index_struct";
    ?>
"<?php 
    if ($filterfield == "index_struct") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("index_struct");
    ?>
</option>
<option value="<?php 
    echo "tabla";
    ?>
"<?php 
    if ($filterfield == "tabla") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("tabla");
    ?>
</option>
<option value="<?php 
    echo "campo";
    ?>
"<?php 
    if ($filterfield == "campo") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("campo");
    ?>
</option>
<option value="<?php 
    echo "valor";
    ?>
"<?php 
    if ($filterfield == "valor") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("valor");
    ?>
</option>
<option value="<?php 
    echo "tipo";
    ?>
"<?php 
    if ($filterfield == "tipo") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("tipo");
    ?>
</option>
<option value="<?php 
    echo "longitud";
    ?>
"<?php 
    if ($filterfield == "longitud") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("longitud");
    ?>
</option>
<option value="<?php 
    echo "descripcion";
    ?>
"<?php 
    if ($filterfield == "descripcion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("descripcion");
    ?>
</option>
<option value="<?php 
    echo "titulo";
    ?>
"<?php 
    if ($filterfield == "titulo") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("titulo");
    ?>
</option>
<option value="<?php 
    echo "control";
    ?>
"<?php 
    if ($filterfield == "control") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("control");
    ?>
</option>
<option value="<?php 
    echo "sql_select";
    ?>
"<?php 
    if ($filterfield == "sql_select") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("sql_select");
    ?>
</option>
<option value="<?php 
    echo "orientacion";
    ?>
"<?php 
    if ($filterfield == "orientacion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("orientacion");
    ?>
</option>
<option value="<?php 
    echo "order_index";
    ?>
"<?php 
    if ($filterfield == "order_index") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("order_index");
    ?>
</option>
<option value="<?php 
    echo "script_field";
    ?>
"<?php 
    if ($filterfield == "script_field") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("JavaScript Evaluate Code");
    ?>
</option>
<option value="<?php 
    echo "help_text";
    ?>
"<?php 
    if ($filterfield == "help_text") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("help_text");
    ?>
</option>
</select></td>
<td><input type="checkbox" name="wholeonly"<?php 
    echo $checkstr;
    ?>
>Palabras Exactas solamente</td>
</td></tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="action" value="Aplicar Filtro"></td>
<td><a href="general_structure.raw.php?a=reset">Quitar Filtro</a></td>
</tr>
</table>
</form>
<hr size="1" noshade>
<?php 
    showpagenav($page, $pagecount);
    ?>
<br>
<table class="tbl"      >
<tr>
<td class="hr">&nbsp;</td>
<td class="hr">&nbsp;</td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "index_struct";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("index_struct");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "tabla";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("tabla");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "campo";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("campo");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "valor";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("valor");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "tipo";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("tipo");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "longitud";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("longitud");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "descripcion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("descripcion");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "titulo";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("titulo");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "control";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("control");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "sql_select";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("sql_select");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "orientacion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("orientacion");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "order_index";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("order_index");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "script_field";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("JavaScript Evaluate Code");
    ?>
</a></td>
<td class="hr"><a class="hr" href="general_structure.raw.php?order=<?php 
    echo "help_text";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("help_text");
    ?>
</a></td>
</tr>
<?php 
    for ($i = $startrec; $i < $reccount; $i++) {
        $row = mysql_fetch_assoc($res);
        $style = "dr";
        if ($i % 2 != 0) {
            $style = "sr";
        }
        ?>
<tr>
<td class="<?php 
        echo $style;
        ?>
"><a href="general_structure.raw.php?a=edit&recid=<?php 
        echo $i;
        ?>
">Editar</a></td>
<td class="<?php 
        echo $style;
        ?>
"><a href="general_structure.raw.php?a=del&recid=<?php 
        echo $i;
        ?>
">Eliminar</a></td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["index_struct"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["tabla"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["campo"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["valor"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["tipo"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["longitud"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["descripcion"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["titulo"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["control"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["sql_select"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["orientacion"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["order_index"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["script_field"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["help_text"]);
        ?>
</td>
</tr>
<?php 
    }
    mysql_free_result($res);
    ?>
</table>
<br>
<?php 
    showpagenav($page, $pagecount);
}

Exemple #4

Fichier : paso3.php Projet : joanlaga/MaxCodekaRev

function select()
{
    global $a;
    global $showrecs;
    global $page;
    $res = sql_select();
    $count = sql_getrecordcount();
    echo $count;
    if ($count == 0) {
        sql_insert();
    }
    echo $count;
    if ($count % $showrecs != 0) {
        $pagecount = intval($count / $showrecs) + 1;
    } else {
        $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {
        mysql_data_seek($res, $startrec);
    }
    $reccount = min($showrecs * $page, $count);
    ?>

<div id="frmBusqueda_PAR">
<table class="fuente8" width="98%" cellspacing="1" border=0>
<tr><td>Tabla de: Parametros</td>
<td>Registros <?php 
    echo $startrec + 1;
    ?>
 - <?php 
    echo $reccount;
    ?>
 of <?php 
    echo $count;
    ?>
</td></tr>
</table></div>
<br>
<div id="TablaLarga_PAR"> 
<table class="fuente8" width="100%" border="0" cellspacing="1" cellpadding=3>
<tr class="cabeceraTabla">
<td >&nbsp;</td>
<td ><?php 
    echo "Num. Factura";
    ?>
</td>
<td ><?php 
    echo "Set Num. Factura";
    ?>
</td>
<td ><?php 
    echo "Fondo Factura";
    ?>
</td>
<td ><?php 
    echo "Imagen de la Factura";
    ?>
</td>
<td ><?php 
    echo "Fondo Guia";
    ?>
</td>
<td ><?php 
    echo "Imagen Guia";
    ?>
</td>
<td ><?php 
    echo "Filas Detalle Fact.";
    ?>
</td>
<td ><?php 
    echo "IVA Imponible";
    ?>
</td>
<td ><?php 
    echo "Nom. Moneda";
    ?>
</td>
<td ><?php 
    echo "Simbolo Moneda";
    ?>
</td>
<td ><?php 
    echo "Cod. Moneda";
    ?>
</td>
<td ><?php 
    echo "Nombre Empresa";
    ?>
</td>
<td ><?php 
    echo "Giro";
    ?>
</td>
<td ><?php 
    echo "Fonos";
    ?>
</td>
<td ><?php 
    echo "Direccion";
    ?>
</td>
<td ><?php 
    echo "Comuna";
    ?>
</td>
<td ><?php 
    echo "Ciudad";
    ?>
</td>
<td ><?php 
    echo "Num. Fiscal";
    ?>
</td>
<td ><?php 
    echo "Resolucion SII";
    ?>
</td>
<td ><?php 
    echo "Rut Empresa";
    ?>
</td>
<td ><?php 
    echo "Giro 2";
    ?>
</td>
</tr>
<?php 
    for ($i = $startrec; $i < $reccount; $i++) {
        $row = mysql_fetch_assoc($res);
        $style = "dr";
        if ($i % 2 != 0) {
            $style = "sr";
        }
        ?>

<tr class="cabeceraTabla_PAR">
<td ><a href="paso3.php?a=edit&recid=<?php 
        echo $i;
        ?>
"><b>Editar</b></a></td>
<td ><?php 
        echo htmlspecialchars($row["numeracionfactura"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["setnumfac"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["fondofac"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["imagenfac"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["fondoguia"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["imagenguia"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["filasdetallefactura"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["ivaimp"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["nombremoneda"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["simbolomoneda"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["codigomoneda"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["nomempresa"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["giro"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["fonos"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["direccion"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["comuna"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["ciudadactual"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["numerofiscal"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["resolucionsii"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["rutempresa"]);
        ?>
</td>
<td ><?php 
        echo htmlspecialchars($row["giro2"]);
        ?>
</td>
</tr>
<?php 
    }
    mysql_free_result($res);
    ?>
</table> </div>
<br>
<?php 
    showpagenav($page, $pagecount);
}

Exemple #5

Fichier : bases_de_operaciones_integracion.raw.php Projet : Cywaithaka/S.A.F.E.-Open-Source-Microfinance-Suite

function select()
{
    global $a;
    global $showrecs;
    global $page;
    global $filter;
    global $filterfield;
    global $wholeonly;
    global $order;
    global $ordtype;
    if ($a == "reset") {
        $filter = "";
        $filterfield = "";
        $wholeonly = "";
        $order = "";
        $ordtype = "";
    }
    $checkstr = "";
    if ($wholeonly) {
        $checkstr = " checked";
    }
    if ($ordtype == "asc") {
        $ordtypestr = "desc";
    } else {
        $ordtypestr = "asc";
    }
    $res = sql_select();
    $count = sql_getrecordcount();
    if ($count % $showrecs != 0) {
        $pagecount = intval($count / $showrecs) + 1;
    } else {
        $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {
        mysql_data_seek($res, $startrec);
    }
    $reccount = min($showrecs * $page, $count);
    ?>
<table class="bd"     >
<tr><td>Origen de Datos: eacp_config_bases_de_integracion_miembros</td></tr>
<tr><td>Registros Mostrados <?php 
    echo $startrec + 1;
    ?>
 - <?php 
    echo $reccount;
    ?>
 of <?php 
    echo $count;
    ?>
</td></tr>
</table>
<hr size="1" noshade>
<form action="bases_de_operaciones_integracion.raw.php" method="post">
<table class="bd"     >
<tr>
<td><b>Fltro Personal</b>&nbsp;</td>
<td><input type="text" name="filter" value="<?php 
    echo $filter;
    ?>
"></td>
<td><select name="filter_field">
<option value="">Todos los Registros</option>
<option value="<?php 
    echo "ideacp_config_bases_de_integracion_miembros";
    ?>
"<?php 
    if ($filterfield == "ideacp_config_bases_de_integracion_miembros") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Codigo");
    ?>
</option>
<option value="<?php 
    echo "lp_codigo_de_base";
    ?>
"<?php 
    if ($filterfield == "lp_codigo_de_base") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Base");
    ?>
</option>
<option value="<?php 
    echo "lp_miembro";
    ?>
"<?php 
    if ($filterfield == "lp_miembro") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Operacion");
    ?>
</option>
<option value="<?php 
    echo "afectacion";
    ?>
"<?php 
    if ($filterfield == "afectacion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("afectacion");
    ?>
</option>
<option value="<?php 
    echo "descripcion_de_la_relacion";
    ?>
"<?php 
    if ($filterfield == "descripcion_de_la_relacion") {
        echo "selected";
    }
    ?>
><?php 
    echo htmlspecialchars("Descripcion de la Relacion");
    ?>
</option>
</select></td>
<td><input type="checkbox" name="wholeonly"<?php 
    echo $checkstr;
    ?>
>Palabras Exactas solamente</td>
</td></tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="action" value="Aplicar Filtro"></td>
<td><a href="bases_de_operaciones_integracion.raw.php?a=reset">Quitar Filtro</a></td>
</tr>
</table>
</form>
<hr size="1" noshade>
<?php 
    showpagenav($page, $pagecount);
    ?>
<br>
<table class="tbl"      >
<tr>
<td class="hr">&nbsp;</td>
<td class="hr">&nbsp;</td>
<td class="hr">&nbsp;</td>
<td class="hr"><a class="hr" href="bases_de_operaciones_integracion.raw.php?order=<?php 
    echo "ideacp_config_bases_de_integracion_miembros";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Codigo");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bases_de_operaciones_integracion.raw.php?order=<?php 
    echo "lp_codigo_de_base";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Base");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bases_de_operaciones_integracion.raw.php?order=<?php 
    echo "lp_miembro";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Operacion");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bases_de_operaciones_integracion.raw.php?order=<?php 
    echo "afectacion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("afectacion");
    ?>
</a></td>
<td class="hr"><a class="hr" href="bases_de_operaciones_integracion.raw.php?order=<?php 
    echo "descripcion_de_la_relacion";
    ?>
&type=<?php 
    echo $ordtypestr;
    ?>
"><?php 
    echo htmlspecialchars("Descripcion de la Relacion");
    ?>
</a></td>
</tr>
<?php 
    for ($i = $startrec; $i < $reccount; $i++) {
        $row = mysql_fetch_assoc($res);
        $style = "dr";
        if ($i % 2 != 0) {
            $style = "sr";
        }
        ?>
<tr>
<td class="<?php 
        echo $style;
        ?>
"><a href="bases_de_operaciones_integracion.raw.php?a=view&recid=<?php 
        echo $i;
        ?>
">Vista Previa</a></td>
<td class="<?php 
        echo $style;
        ?>
"><a href="bases_de_operaciones_integracion.raw.php?a=edit&recid=<?php 
        echo $i;
        ?>
">Editar</a></td>
<td class="<?php 
        echo $style;
        ?>
"><a href="bases_de_operaciones_integracion.raw.php?a=del&recid=<?php 
        echo $i;
        ?>
">Eliminar</a></td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["ideacp_config_bases_de_integracion_miembros"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_codigo_de_base"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["lp_miembro"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["afectacion"]);
        ?>
</td>
<td class="<?php 
        echo $style;
        ?>
"><?php 
        echo htmlspecialchars($row["descripcion_de_la_relacion"]);
        ?>
</td>
</tr>
<?php 
    }
    mysql_free_result($res);
    ?>
</table>
<br>
<?php 
    showpagenav($page, $pagecount);
}