|
<%
//if($tabID=='2'){$tab_galeria=" TAB.tabID='2' and ";}//solo para galerías
//busco los que ya fueron asociados con adrOrden=0 y adrOrden=1 ya que los
//debo excluir en la próxima consulta
$sql="select count(*) as cant,A.advID,B.advID,A.adrOrden,B.adrOrden
from ADVF_Vinculante A,ADVF_Vinculante B
where A.advID=B.advID and
A.tabID=B.tabID and
A.fgnID=B.fgnID and
A.tabID='$tabID' and
A.fgnID='$accID' and
A.adrOrden<>B.adrOrden
group by A.advID having cant>1";
$rsaux=$conn->execute($sql);
$numrows=$rsaux->numrows;
$notin="";
while(!$rsaux->eof){
$notin.=$rsaux->field(advID);
if($t<$numrows-1){$notin.=",";}
$t++;
$rsaux->movenext();
}
if($notin!=""){$notin=" and A.advID not in (".$notin.")";}
if($ListaUser=="ls_usuario"){$filtro_usuario=" A.advAutor='$usradID' and ";}
else if($ListaUser=="ls_todos"){$filtro_usuario="";}
$sqabc = "select UPPER(SUBSTRING(A.advTitulo,1,1)) As Letras from ADVF A,Tablas TAB
left join ADVF_Vinculante B on (A.advID=B.advID and B.tabID='$tabID' and B.fgnID='$accID')
where (B.advID is null or (B.adrOrden='0' $notin)) and $filtro_usuario A.advTipo='$tipo' group by Letras";
//echo $sqabc;
$qrabc = $conn->execute($sqabc);
if(!$qrabc)
{
showError("Error XM32659","javascript: window.history.back()","Back",1);
}
if(!$qrabc->eof)
{
if(!$c){$c = $qrabc->field("Letras");}
if($qrabc->field("Letras")==$c)
{
echo "".$qrabc->field("Letras")."";
}
else{
echo "".$qrabc->field("Letras")."";
}
$qrabc->movenext();
}
while(!$qrabc->eof)
{
if($qrabc->field("Letras")==$c)
{
echo" I ".$qrabc->field("Letras")."";
}else{
echo" I ".$qrabc->field("Letras")."";
}
$qrabc->movenext();
}
%>
<% //aca listo los elementos de esa letra if(!$order || $order=="advFecha"){$order="advFecha desc";} $c = addslashes($c); $sqelem = "select A.advID,A.advTitulo,OP.usradUsuario, CAT.catNombre,A.advFecha,A.advLink from ADVF A,segUsuariosAdmin OP,ADVF_Categorias CAT left join ADVF_Vinculante B on (A.advID=B.advID and B.tabID='$tabID' and B.fgnID='$accID') where (B.advID is null or (B.adrOrden='0' $notin)) and A.advTipo='$tipo' and A.advAutor=OP.usradID and A.catID=CAT.catID and $filtro_usuario A.advTitulo like '$c%' order by $order"; //echo "$sqelem"; $rselem = $conn->execute($sqelem); if(!$rselem) { showError("Error XM32660","javascript: window.history.back()","Back",1); } if($rselem->numrows) { %> <%=$I_therearenotavailable%> <%=$err1%>
<%}%> |