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> </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> </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"> </td>
<td class="hr"> </td>
<td class="hr"> </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);
}
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> </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> </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"> </td>
<td class="hr"> </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);
}
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> </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> </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"> </td>
<td class="hr"> </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);
}
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 > </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);
}
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> </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> </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"> </td>
<td class="hr"> </td>
<td class="hr"> </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);
}
