Logs diplomas acracb

26 de abril de 2015
{source}<?php
$offset = 100;
$maxpag = 13;
$db = JFactory::getDbo();

$dir_articulo = ‘/index.php?option=com_content&view=article&id=831’;
//$dir_articulo=’/acracb/index.php/acracb-prueba’;
$dir_imagenes_corto = ‘/images/’;
$dir_imagenes = $dir_imagenes_corto . ‘bancomu/’;

$dir_rankings = ‘/index.php?option=com_content&view=article&id=832’;
$dir_logs = ‘/index.php?option=com_content&view=article&id=831’;
$dir_actividades_validadas = ‘/index.php?option=com_content&view=article&id=1390’;
$dir_bases = ‘/index.php?option=com_content&view=article&id=1391’;

$dir_desafio = ‘/index.php?option=com_content&view=article&id=1385’;

if (!isset($_POST[«acracb_form_logs_pag»])) {$pagina = «»;} else { $pagina = $db->escape($_POST[«acracb_form_logs_pag»]);}
if (!isset($_POST[«acracb_form_logs_valor»])) {$valor = «-1»;} else { $valor = $db->escape($_POST[«acracb_form_logs_valor»]);}
if (!isset($_POST[«acracb_form_logs_buscar»])) {$buscar = «»;} else { $buscar = $db->escape($_POST[«acracb_form_logs_buscar»]);}

if (!isset($_POST[«acracb_form_logs_buscar_modo»])) {$modo = «HF»;} else { $modo = $db->escape($_POST[«acracb_form_logs_buscar_modo»]);}

if (isset($_GET[«query»])) {$query = $db->escape($_GET[«query»]);}
$query = str_replace(‘%’, », $query);
if (strlen($query) > 0) {$valor = $query;}

if (strlen($pagina) <= 0) {
$inicio = 0;
$pagina = 1;
} else {
$inicio = ($pagina – 1) * $offset;
}

?>

<script language=»javascript» type=»text/javascript»>
function ir_articulo_bases()
{
var url='<?php echo $dir_bases; ?>&query=<?php echo $valor; ?>’;
window.location.href=url;
}
function ir_articulo_desafio()
{
var url='<?php echo $dir_desafio; ?>’;
window.location.href=url;
}
function ir_articulo_actividades_validadas()
{
var url='<?php echo $dir_actividades_validadas; ?>&query=<?php echo $valor; ?>’;
window.location.href=url;
}
function ir_articulo_rankings(qrz = »)
{
var url='<?php echo $dir_rankings; ?>&query=<?php echo $valor; ?>’;
if (qrz.length > 0) {
url = url + ‘&query2=’ + qrz;
}
window.location.href=url;
}
function ir_articulo_logs()
{
var url='<?php echo $dir_logs; ?>&query=<?php echo $valor; ?>’;
window.location.href=url;
}
</script>

<script language=»javascript» type=»text/javascript»>

function accion(pag)
{
document.getElementById(«acracb_form_logs_pag»).value = pag;
document.getElementById(«acracb_form_logs»).submit();
}
function cambiar()
{
var indice;
var valor_indice;

indice = document.getElementById(«acracb_form_logs_cambio»).selectedIndex;
valor_indice = document.getElementById(«acracb_form_logs_cambio»).options[indice].value;
document.getElementById(«acracb_form_logs_valor»).value = valor_indice;

<?php
if (in_array($valor, array(‘2’, ‘3’))) {?>
indice = document.getElementById(«acracb_form_logs_buscar_modo»).selectedIndex;
valor_indice = document.getElementById(«acracb_form_logs_buscar_modo»).options[indice].value;
document.getElementById(«acracb_form_logs_modo»).value = valor_indice;
<?php }?>

document.getElementById(«acracb_form_logs_pag»).value=1;
document.getElementById(«acracb_form_logs»).submit();
}

</script>

<?php

if (in_array($valor, array(’19’))) {
?>
<center>
<p align=’center’ style=»font-size:19px»>
<a href=»javascript:ir_articulo_desafio()»><b>Volver al Desafio</b></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=»javascript:ir_articulo_bases()»><b>Bases del desafío</b></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=»javascript:ir_articulo_actividades_validadas()»><b>Actividades</b></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=»javascript:ir_articulo_rankings()»><b>Rankings</b></a>&nbsp;&nbsp;&nbsp;&nbsp;
</p>
<br>
</center>
<?php
}

?>

<form name=»acracb_form_logs» id=»acracb_form_logs» action=»<?php echo $dir_articulo; ?>» method=post>
<input size=25 type=hidden id=»acracb_form_logs_pag» name=»acracb_form_logs_pag» value=»<?php echo $pagina; ?>»>
<input size=25 type=hidden id=»acracb_form_logs_valor» name=»acracb_form_logs_valor» value=»<?php echo $valor; ?>»>
<input size=25 type=hidden id=»acracb_form_logs_modo» name=»acracb_form_logs_modo» value=»<?php echo $modo; ?>»>

<table border=»0″ cellspacing=»0″ cellpadding=»2″ align=»center» width=»100%»>
<tr><td>
<p align=’center’>
<font size=»3″>
<b>Puede filtrar el ranking por las distintas opciones siguientes </b> &nbsp;
<select id=»acracb_form_logs_cambio» name=»acracb_form_logs_cambio» onchange=»cambiar();»>
<?php
$sql = ‘SELECT codigo,descripcion FROM acracb_lista_diplomas’;
$db->setQuery($sql);
$rows = $db->loadObjectList();
foreach ($rows as $row) {
$codigo = $row->codigo;
$descripcion = $row->descripcion;
?>
<option value=»<?php echo $codigo; ?>» <?php if ($codigo == $valor) {echo » selected»;}?> ><?php echo $descripcion; ?></option>
<?php
}
?>
</select>
</font>
</p>
</td></tr>

<tr><td>
<p align=’center’>
<font size=»3″>
Filtrar un indicativo&nbsp;<input size=8 type=text id=»acracb_form_logs_buscar» name=»acracb_form_logs_buscar» value=»<?php echo $buscar; ?>»>
&nbsp;&nbsp;
<?php if (in_array($valor, array(‘2’, ‘3’))) {?>
Modos&nbsp;&nbsp;<select id=»acracb_form_logs_buscar_modo» name=»acracb_form_logs_buscar_modo» onchange=»cambiar();»>
<option value=»HF» <?php if (‘HF’ == $modo) {echo » selected»;}?> >Dioploma HF</option>
<option value=»VHF» <?php if (‘VHF’ == $modo) {echo » selected»;}?> >Diploma VHF</option>
<option value=»CB» <?php if (‘CB’ == $modo) {echo » selected»;}?> >Diploma CB</option>
<option value=»DMR» <?php if (‘DMR’ == $modo) {echo » selected»;}?> >Diploma DMR</option>
</select>&nbsp;&nbsp;
<?php }?>
<input type=»button» value=»Buscar» onclick=»cambiar()»>&nbsp&nbsp;
</font>
</p>
</td></tr>

</table>
<br>
</form>

<?php
$sql = «select * FROM logs WHERE tipo_diploma=’$valor’ and length(Qrz)>0 «;
if (strlen($buscar) > 0) {
$sql .= » AND (Qrz LIKE ‘$buscar’ or Qrz LIKE ‘$buscar/%’)»;
}
if (strlen($modo) > 0 and (in_array($valor, array(‘2’, ‘3’)))) {
if ($modo == ‘DMR’) {
$sql .= » AND (modo in (‘DMR’))»;
} elseif ($modo == ‘VHF’) {
$sql .= » AND (modo in (‘VHF’,’FM’))»;
} elseif ($modo == ‘CB’) {
$sql .= » AND (modo in (‘CB’,’AM’))»;
} else {
$sql .= » AND (modo not in (‘DMR’,’VHF’,’FM’,’CB’,’AM’))»;
}
}
$sql_total = $sql . » ORDER BY ano DESC, mes DESC, dia DESC, Actividad DESC LIMIT $inicio,$offset»;

?>

<center>
<table border=»0″ cellspacing=»0″ cellpadding=»0″ align=»center» width=»100%» class=’tabla_acracb’>
<tr class=’tr_cab_acracb’>
<td width=16% align=’center’><b>Actividad</b></td>
<td width=16% align=’center’><b>Fecha</b></td>
<td width=9% align=’center’><b>Banda</b></td>
<td width=9% align=’center’><b>Modo</b></td>
<td width=17% align=’center’><b><?php if ($valor == ‘1’) {?> Referencia <?php } else {?> Puntos <?php }?></b></td>
<td <?php if (in_array($valor, array(‘2’, ‘3’))) {echo ‘style=»display:none»‘;}?> width=16% align=’center’><b>DME</b></td>
<td width=17% align=’center’><b>Indicativo</b></td>
</tr>
<?php
$i = 0;
$tr_impar = ‘tr_impar_acracb’;
$tr_par = ‘tr_par_acracb’;

$db->setQuery($sql_total);
$rows = $db->loadObjectList();
foreach ($rows as $row) {
$pref = $row->pref;
$Actividad = $row->Actividad;
$act = $row->act;
$act2 = $row->act2;
$Qrz = $row->Qrz;
$ref = $row->ref;
$banda = $row->banda;
$modo = $row->modo;
$dia = $row->dia;
$mes = $row->mes;
$ano = $row->ano;
$altre = $row->altre;

$tr_class = ($i % 2) ? $tr_impar : $tr_par;
$i++;
?>
<tr class='<?php echo $tr_class; ?>’>
<td width=16%><center><b><?php echo $pref . $Actividad . $act . $act2; ?></b></center></td>
<td width=16%><center><?php echo $dia . «/» . $mes . «/» . $ano; ?></center></td>
<td width=9%><center><?php echo $banda; ?></center></td>
<td width=9%><center><?php echo $modo; ?></center></td>
<td width=17%>
<center><b><u><?php echo $ref; ?></u></b></center>
</td>
<td <?php if (in_array($valor, array(‘2’, ‘3’))) {echo ‘style=»display:none»‘;}?> width=16%>
<center>
<?php
$sql_dme = «SELECT dme FROM directorio where refe=’$ref'»;
$db->setQuery($sql_dme);
$rows2 = $db->loadObjectList();
foreach ($rows2 as $row2) {
$dme = $row2->dme;
printf($dme);
}
?>
</center>
</td>
<td width=17%><center><?php echo $Qrz; ?></center></td>
</tr>
<?php
}
?>
</table>
</center>
<br>

<table border=»0″ cellspacing=»0″ cellpadding=»0″ align=»center» width=»100%»>
<tr><td>
<?php

$sql_pag = «SELECT count(*) as total FROM ( » . $sql . «) ttt»;
$db->setQuery($sql_pag);
$total = $db->loadResult();
$paginillas = ceil($total / $offset);
?>
<p align=’center’>
<b>Número de registros encontrados:&nbsp;&nbsp;<?php echo $total; ?></b><br>
<b>Se muestran&nbsp;<?php echo $paginillas; ?>&nbsp;páginas de&nbsp;<?php echo $offset; ?>&nbsp;registros cada una</b><br>
<b>Mostrando la página&nbsp;<?php echo $pagina; ?>&nbsp;de&nbsp;<?php echo $paginillas; ?> </b>
</p>
</td></tr>
</table>
<p align=’center’>
<?php
if ($paginillas > 1) {
$j = 0;
for ($i = 1; $i <= $paginillas; $i++) {
if ($pagina == $i) {
//si muestro el índice de la página actual, no coloco enlace
?>
<b><u><?php echo $pagina; ?></u></b>&nbsp;
<?php
} else {
//si el índice no corresponde con la página mostrada actualmente, coloco el enlace para ir a esa página
?>
<a href=»javascript:accion(‘<?php echo $i; ?>’);»><font size=2><b><?php echo $i; ?></b></a>&nbsp;
<?php
if ($j == $maxpag) {echo «<br>»;
$j = 0;}
$j = $j + 1;
}
}
}
?>
</p>

<?php

?>{/source}

Scroll al inicio