Go Back   CodingForums.com > :: Client side development > JavaScript programming

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 12-28-2005, 11:10 AM   PM User | #1
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Question Dynamic table with javascript

Hello!

Well, I need to make a table with javascript. But, this table must be dynamic.

The heading must be a filter and when I click in the filter, the table change the order in accordance with the filter.

Somebody help me.

Sorry, because my english not is good

William
willjs is offline   Reply With Quote
Old 12-28-2005, 11:57 AM   PM User | #2
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
Something like this (see also attachment):
PHP Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<
html>
<
head>
<
title>Sortare ascendenta/descendenta pe coloane</title>
<
meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<
meta http-equiv="Content-Style-Type" content="text/css">
<
meta http-equiv="Content-Script-Type" content="text/javascript">
<
style type="text/css">
<!--
tr {
    
background-color#CCCCCC;
}
.
tr1 {
    
background-color#F5F5F5;
}
.
tr2 {
    
background-color#E5E5E5;
}
-->
</
style>
<
script type="text/JavaScript">
//Genuine code by Corneliu Lucian 'KOR' Rusu  -- mailto:cornel@mc.ro
function sortIt(w){
var 
r=w.parentNode.parentNode.parentNode.getElementsByTagName('tr');
var 
oRows = new Array()//colectia de clone linii
var iRows = new Array()//matricea indexurilor liniilor
for(var i=1;i<r.length;i++){
oRows[i]=r[i].cloneNode(true);//cloneaza liniile
iRows[i]=r[i].rowIndex;
}
var 
q=w.parentNode.cellIndex;
var 
oCol = new Array()
var 
vCol = new Array()
for(var 
i=0;i<iRows.length;i++){
var 
r[i].cells[q].firstChild.nodeValue;
if(
parseInt(v)){v=parseInt(v)}
oCol[i]=[v,iRows[i]];
vCol[i]=[v,iRows[i]];
}
oCol.shift();
vCol.shift();
sCol oCol.sort(function(oCol,sCol){return oCol[0] == sCol[0] ? : (oCol[0] < sCol[0] ? -1)});
if(
vCol.toString()==sCol.toString()){sCol.reverse()}// switcher descendent/ascendent
var q=1;
for(var 
i=1;i<r.length;i++){//rescrie liniile
r[i].parentNode.replaceChild(oRows[sCol[i-1][1]],r[i]);
//START pastreaza alternata bg linii 
q=(q>2)?1:q
r
[i].className='tr'+q;q++;
// END pastreaza alternata bg linii
}
//schimba sagetile descendent/ascendent
var =['desc.gif','cres.gif'];//url-ul relativ al sagetilor
var allS =r[0].getElementsByTagName('img');
var 
sag w.getElementsByTagName('img')[0];
var 
url =(sag.getAttribute('src').indexOf(s[0])>-1)?s[1]:s[0];
sag.setAttribute('src',url);
for(var 
i=0;i<allS.length;i++){//initializeaza celelalte sageti
if(allS[i]!=sag){allS[i].setAttribute('src',s[0])}
}
}
</script>
</head>
<body>
<table width="400" border="0" cellspacing="2" cellpadding="2">
<tbody>
<tr> 
<td width="33%"><strong>Firma</strong> <a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td width="33%"><strong>Localitatea</strong> <a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td width="34%"><strong>Niste cifre</strong> <a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
</tr>
<tr class="tr1"> 
<td>Boul zbucuimat</td>
<td>Draganesti-Olt</td>
<td>40 de euroi</td>
</tr>
<tr class="tr2"> 
<td>Albina cretina</td>
<td>Craiova</td>
<td>20 coco</td>
</tr>
<tr class="tr1"> 
<td>Calul prepuelnic</td>
<td>Baia Mare</td>
<td>1000</td>
</tr>
<tr class="tr2"> 
<td>Dinozaurul vesel</td>
<td>Arad</td>
<td>30</td>
</tr>
<tr class="tr2">
<td>Boul nezbucuimat</td>
<td>Baia Mica</td>
<td>500</td>
</tr>
</tbody>
</table>
</body>
</html> 
Sorry, the comments are in my language, in Romanian, I had no time to translate them, but they are not important.
Attached Files
File Type: zip exemple.zip (1.8 KB, 130 views)
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Kor is offline   Reply With Quote
Old 12-28-2005, 01:40 PM   PM User | #3
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Thumbs up

Tks my friend!
You helped a lot!
Will
willjs is offline   Reply With Quote
Old 12-28-2005, 03:42 PM   PM User | #4
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
If any adjustments, I am ready for some help. I forgot that Portuguese is very close with Romanian (in fact I have not noticed that u are from Brasil), so that you migth have understood the comments...
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Last edited by Kor; 12-28-2005 at 03:50 PM..
Kor is offline   Reply With Quote
Old 12-29-2005, 12:55 PM   PM User | #5
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Tks again... lol...
So, I believe that we can to talk about programming, Romania and Brasil more times.
My msn is: william_js@msn.com
__________________
Tks
William
willjs is offline   Reply With Quote
Old 12-29-2005, 03:44 PM   PM User | #6
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Hi,

I've had a problem with the filters that you sent me. The fields type date, currency and hyperlink do not function.

Do you know what I have to do?

Tks
Will
__________________
Tks
William
willjs is offline   Reply With Quote
Old 12-29-2005, 03:53 PM   PM User | #7
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
put the code here
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Kor is offline   Reply With Quote
Old 12-29-2005, 04:09 PM   PM User | #8
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Look the code.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Sugestão de Compra</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Style-Type" content="text/css">
<meta http-equiv="Content-Script-Type" content="text/javascript">
<style type="text/css">
<!--
tr {
background-color: #CCCCCC;
}
.tr1 {
background-color: #F5F5F5;
}
.tr2 {
background-color: #E5E5E5;
}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; }
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9; }
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; font-weight:bold }
-->
</style>
<script type="text/JavaScript">
//Genuine code by Corneliu Lucian 'KOR' Rusu -- mailto:cornel@mc.ro
function sortIt(w){
var r=w.parentNode.parentNode.parentNode.getElementsByTagName('tr');
var oRows = new Array()//colectia de clone linii
var iRows = new Array()//matricea indexurilor liniilor
for(var i=1;i<r.length;i++){
oRows[i]=r[i].cloneNode(true);//cloneaza liniile
iRows[i]=r[i].rowIndex;
}
var q=w.parentNode.cellIndex;
var oCol = new Array()
var vCol = new Array()
for(var i=0;i<iRows.length;i++){
var v = r[i].cells[q].firstChild.nodeValue;
if(parseInt(v)){v=parseInt(v)}
oCol[i]=[v,iRows[i]];
vCol[i]=[v,iRows[i]];
}
oCol.shift();
vCol.shift();
sCol = oCol.sort(function(oCol,sCol){return oCol[0] == sCol[0] ? 0 : (oCol[0] < sCol[0] ? -1 : 1)});
if(vCol.toString()==sCol.toString()){sCol.reverse()}// switcher descendent/ascendent
var q=1;
for(var i=1;i<r.length;i++){//rescrie liniile
r[i].parentNode.replaceChild(oRows[sCol[i-1][1]],r[i]);
//START pastreaza alternata bg linii
q=(q>2)?1:q
r[i].className='tr'+q;q++;
// END pastreaza alternata bg linii
}
//schimba sagetile descendent/ascendent
var s =['desc.gif','cres.gif'];//url-ul relativ al sagetilor
var allS =r[0].getElementsByTagName('img');
var sag = w.getElementsByTagName('img')[0];
var url =(sag.getAttribute('src').indexOf(s[0])>-1)?s[1]:s[0];
sag.setAttribute('src',url);
for(var i=0;i<allS.length;i++){//initializeaza celelalte sageti
if(allS[i]!=sag){allS[i].setAttribute('src',s[0])
}
}
}
</script>
</head>
<body>
<table width="400" border="0" cellspacing="2" cellpadding="2">
<tbody>
<tr>
<td class="style9">Iten<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Descricao<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Fantasia<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Embalagem<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Preço de Venda</td>
<td class="style9">Disponivel<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Reserva<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Futuro</td>
<td class="style9">MDV<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Disponível<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Max.<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Min.<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DT ULT ENT</a></td>
<td class="style9">QTD ULT ENT<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Qtde Comprar<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+1<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+2<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+3<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+4<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+5<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+6<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+7<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+8<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+9<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+10<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
</tr>
<%
v_contador = 0
While Not rs.eof
If v_contador MOD 2 = 0 Then
vcor = "tr" + "1"
Else
vcor = "tr" + "2"
End if
%>
<tr class="<%=vcor%>">
<td class="style3"><%=rs("coditprod")%></td>
<td class="style3"><%=rs("descricao")%></td>
<td class="style3"><%=rs("fantasia")%></td>
<td class="style3"><%=rs("embalagem")%></td>
<td class="style3"><%=replace(formatcurrency(rs("preco_venda"),2),",",".")%></td>
<td class="style3"><%=replace(formatnumber(rs("disponivel"),3),",",".")%></td>
<td class="style3"><%=replace(formatnumber(rs("resfis"),3),",",".")%></td>
<td class="style3">
<%
If formatnumber(rs("futuro"),3) > 0 Then
%>
<a href="javascript:abrir('<%=rs("coditprod")%>');"><%=replace(formatnumber(rs("futuro"),3),",",".")%></a>
<%
Else
%>
<%=replace(formatnumber(rs("futuro"),3),",",".")%>
<%
End If
%>
</td>
<td class="style3"><%=replace(formatnumber(rs("mdv"),3),",",".")%></td>
<td class="style3"><%=replace(formatnumber(rs("ddv_disponivel"),3),",",".")%></td>
<td class="style3"><%=replace(rs("maxddv"),",",".")%></td>
<td class="style3"><%=replace(rs("minddv"),",",".")%></td>
<td class="style3"><%=replace(rs("DTULTENT"),",",".")%></td>
<td class="style3"><%=replace(formatnumber(rs("QTDULTENT"),3),",",".")%></td>
<td class="style3"><%=replace(formatnumber(rs("qtde_comprar"),3),",",".")%></td>
<%if formatnumber(rs("d1"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d1"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d2"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d2"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d3"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d3"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d4"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d4"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d5"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d5"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d6"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d6"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d7"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d7"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d8"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d8"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d9"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d9"),0),",",".")%></td>
<%end if%>
<%if formatnumber(rs("d10"),0) = "0" then%>
<td class="style3">&nbsp;</td>
<%else%>
<td class="style3"><%=replace(formatnumber(rs("d10"),0),",",".")%></td>
<%end if%>
</tr>
<%
v_contador = v_contador + 1
rs.Movenext
Wend
%>
</tbody>
</table>
<br>
<center>
<input type='button' value='Voltar' onclick="javascript:location.href='rel_sugestao_compra.asp';">
</center>
</Form>
</body>
</html>
__________________
Tks
William
willjs is offline   Reply With Quote
Old 01-02-2006, 11:56 AM   PM User | #9
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Unhappy

I've cleaned this code. The asp codes are between < >. I've had a few problems with currency, hyperlink and date files. My comments about this files are between <!-- -->.

Can somebody help me?

--------------------------------------------------------------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Sugestão de Compra</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Style-Type" content="text/css">
<meta http-equiv="Content-Script-Type" content="text/javascript">
<style type="text/css">
<!--
tr {
background-color: #CCCCCC;
}
.tr1 {
background-color: #F5F5F5;
}
.tr2 {
background-color: #E5E5E5;
}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; }
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9; }
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; font-weight:bold }
-->
</style>
<script type="text/JavaScript">
//Genuine code by Corneliu Lucian 'KOR' Rusu -- mailto:cornel@mc.ro
function sortIt(w){
var r=w.parentNode.parentNode.parentNode.getElementsByTagName('tr');
var oRows = new Array()//colectia de clone linii
var iRows = new Array()//matricea indexurilor liniilor
for(var i=1;i<r.length;i++){
oRows[i]=r[i].cloneNode(true);//cloneaza liniile
iRows[i]=r[i].rowIndex;
}
var q=w.parentNode.cellIndex;
var oCol = new Array()
var vCol = new Array()
for(var i=0;i<iRows.length;i++){
var v = r[i].cells[q].firstChild.nodeValue;
if(parseInt(v)){v=parseInt(v)}
oCol[i]=[v,iRows[i]];
vCol[i]=[v,iRows[i]];
}
oCol.shift();
vCol.shift();
//sCol = oCol.sort(function(oCol,sCol){return oCol[0] == sCol[0] ? 0 : (oCol[0] < sCol[0] ? -1 : 1)});
sCol = oCol.sort(function(oCol,sCol){return oCol[0] == sCol[0] ? 0 : (oCol[0] < sCol[0] ? -1 : 1)});
if(vCol.toString()==sCol.toString()){sCol.reverse()}// switcher descendent/ascendent
var q=1;
for(var i=1;i<r.length;i++){//rescrie liniile
r[i].parentNode.replaceChild(oRows[sCol[i-1][1]],r[i]);
//START pastreaza alternata bg linii
q=(q>2)?1:q
r[i].className='tr'+q;q++;
// END pastreaza alternata bg linii
}
//schimba sagetile descendent/ascendent
var s =['desc.gif','cres.gif'];//url-ul relativ al sagetilor
var allS =r[0].getElementsByTagName('img');
var sag = w.getElementsByTagName('img')[0];
var url =(sag.getAttribute('src').indexOf(s[0])>-1)?s[1]:s[0];
sag.setAttribute('src',url);
for(var i=0;i<allS.length;i++){//initializeaza celelalte sageti
if(allS[i]!=sag){allS[i].setAttribute('src',s[0])
}
}

</script>
</head>
<body>
<table width="400" border="0" cellspacing="2" cellpadding="2">
<tbody>
<tr>
<td class="style9">Iten<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Descricao<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Fantasia<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Embalagem<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>

<td class="style9">Preço de Venda</td> <!-- filter don't function -->

<td class="style9">Disponivel<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Reserva<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>

<td class="style9">Futuro</td> <!-- filter don't function -->

<td class="style9">MDV<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Disponível<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Max.<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DDV Min.<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">DT ULT ENT</a></td>
<td class="style9">QTD ULT ENT<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">Qtde Comprar<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+1<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+2<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+3<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+4<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+5<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+6<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+7<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+8<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+9<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
<td class="style9">D+10<a href="#" onclick="sortIt(this);return false"><img src="desc.gif" border="0"></a></td>
</tr>

<tr class="<%=asp code%>">
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><a href="javascriptpenPopup('<asp code>');"><asp code></a></td> <!-- Put the hyperlink -->
<td class="style3"><%asp code%>/td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3"><%asp code%></td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
<td class="style3">&nbsp;</td>
</tbody>
</table>
<br>
<center>
<input type='button' value='Voltar' onclick="javascript:location.href='rel_sugestao_compra.asp';">
</center>
</Form>
</body>
</html>
__________________
Tks
William

Last edited by willjs; 01-02-2006 at 12:05 PM..
willjs is offline   Reply With Quote
Old 01-03-2006, 10:41 AM   PM User | #10
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
So... the problem is that you have a hypelink in one of the cells?
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Kor is offline   Reply With Quote
Old 01-03-2006, 11:58 AM   PM User | #11
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Yes,

This is one of problems. The cells with hyperlink, currency and date the filters don't function very well.
__________________
Tks
William
willjs is offline   Reply With Quote
Old 01-04-2006, 05:15 PM   PM User | #12
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
ok now... Here's what I have done so far... The currency is not sorted ok, so that I need to know how all your currency strings will appear on cell. Will they be xx NNNNN or xxx NNNNN ... I need to know that:

Now, so far here's the code:
PHP Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<
html>
<
head>
<
title>Sortare ascendenta/descendenta pe coloane</title>
<
meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<
meta http-equiv="Content-Style-Type" content="text/css">
<
meta http-equiv="Content-Script-Type" content="text/javascript">
<
style type="text/css">
<!--
tr {
    
background-color#CCCCCC;
}
.
tr1 {
    
background-color#F5F5F5;
}
.
tr2 {
    
background-color#E5E5E5;
}
-->
</
style>
<
script type="text/JavaScript">
//Genuine code by Corneliu Lucian 'KOR' Rusu  -- mailto:cornel@mc.ro
function sortIt(w){
var 
r=w.parentNode.parentNode.parentNode.getElementsByTagName('tr');
var 
oRows = new Array()//colectia de clone linii
var iRows = new Array()//matricea indexurilor liniilor
for(var i=1;i<r.length;i++){
oRows[i]=r[i].cloneNode(true);//cloneaza liniile
iRows[i]=r[i].rowIndex;
}
var 
q=w.parentNode.cellIndex;
var 
oCol = new Array()
var 
vCol = new Array()
for(var 
i=1;i<iRows.length;i++){
var 
kid r[i].cells[q].firstChild;
if(
r[i].cells[q].firstChild.nodeType==1){
var 
vkid.firstChild.nodeValue;
}
else{
var 
kid.nodeValue;
if(
v.indexOf('/')!=-1){
v=v.split('/');
= new Date(v[2],v[1],v[0])
}
if(
Number(v)){v=Number(v)}
}
oCol[i]=[v,iRows[i]];
vCol[i]=[v,iRows[i]];
}
oCol.shift();
vCol.shift();
sCol oCol.sort(function(oCol,sCol){return oCol[0] == sCol[0] ? : (oCol[0] < sCol[0] ? -1)});
if(
vCol.toString()==sCol.toString()){sCol.reverse()}// switcher descendent/ascendent
var q=1;
for(var 
i=1;i<r.length;i++){//rescrie liniile
r[i].parentNode.replaceChild(oRows[sCol[i-1][1]],r[i]);
//START pastreaza alternata bg linii 
q=(q>2)?1:q
r
[i].className='tr'+q;q++;
// END pastreaza alternata bg linii
}
//schimba sagetile descendent/ascendent
var =['desc.gif','cres.gif','none.gif'];//url-ul relativ al sagetilor
var allS =r[0].getElementsByTagName('img');
var 
sag w.getElementsByTagName('img')[0];
var 
url =(sag.getAttribute('src').indexOf(s[1])>-1||sag.getAttribute('src').indexOf(s[2])>-1)?s[0]:s[1];
sag.setAttribute('src',url);
for(var 
i=0;i<allS.length;i++){//initializeaza celelalte sageti
if(allS[i]!=sag){allS[i].setAttribute('src',s[2])}
}
}
</script>
</head>
<body>
<table width="600" border="0" cellspacing="2" cellpadding="2">
<tbody>
<tr> 
<td width="33%" height="27"><strong>String</strong> <a href="#" onclick="sortIt(this);return false"><img src="none.gif" border="0"></a></td>
<td width="33%"><strong>Currency</strong> <a href="#" onclick="sortIt(this);return false"><img src="none.gif" border="0"></a></td>
<td width="34%"><strong>Date(dd/mm/yy)</strong> <a href="#" onclick="sortIt(this);return false"><img src="none.gif" border="0"></a></td>
<td width="34%"><strong>URL</strong> <a href="#" onclick="sortIt(this);return false"><img src="none.gif" border="0"></a></td>
</tr>
<tr class="tr1"> 
<td>Boul zbucuimat</td>
<td>$d 1000.89</td>
<td>30/01/2005</td>
<td><a href="http://www.google.com">Google</a></td>
</tr>
<tr class="tr2"> 
<td>Albina cretina</td>
<td>$d 500.21</td>
<td>11/03/2006</td>
<td><a href="http://www.mc.ro">Media Concept</a></td>
</tr>
<tr class="tr1"> 
<td>Calul prepuelnic</td>
<td>$d 1200.01</td>
<td>06/12/1999</td>
<td><a href="http://www.altavista.com">Altavista</a></td>
</tr>
<tr class="tr2"> 
<td>Dinozaurul vesel</td>
<td>$d 300.54</td>
<td>11/05/2000</td>
<td><a href="http://www.yahoo.com">Yahoo</a></td>
</tr>
<tr class="tr1"> 
<td>Boul nezbucuimat</td>
<td>$d 80.19</td>
<td>29/01/2005</td>
<td><a href="http://www.cnn.com">CNN</a></td>
</tr>
</tbody>
</table>
</body>
</html> 
The currecy problem remained to be solve, so I wait for the details.
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Last edited by Kor; 01-04-2006 at 05:21 PM..
Kor is offline   Reply With Quote
Old 01-04-2006, 06:57 PM   PM User | #13
SpirtOfGrandeur
Regular Coder

 
Join Date: May 2005
Location: Michigan, USA
Posts: 566
Thanks: 0
Thanked 0 Times in 0 Posts
SpirtOfGrandeur is an unknown quantity at this point
I would like to take a quick time out to say good job Kor for helping this guy out!
__________________
Note: I do not test code. I just write it off the top of my head. There might be bugs in it! But if any thing I gave you the overall theory of what you need to accomplish. Also there are plenty of other ways to accomplish this same thing. I just gave one example of it. Other ways might be faster and more efficient.
SpirtOfGrandeur is offline   Reply With Quote
Old 01-04-2006, 07:02 PM   PM User | #14
willjs
New Coder

 
Join Date: Dec 2005
Location: São Paulo, Brasil
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
willjs is an unknown quantity at this point
Question

I haven't more problems with date and hyperlinks files. About currency, I'll show below more details.

Examples - I can have:

-4
-359,25
0,00
12,00
1.050,13
352.653,25

Can I use the symbol R$ before the numbers?
__________________
Tks
William
willjs is offline   Reply With Quote
Old 01-05-2006, 08:47 AM   PM User | #15
Kor
Red Devil Mod


 
Kor's Avatar
 
Join Date: Apr 2003
Location: Bucharest, ROMANIA
Posts: 8,478
Thanks: 58
Thanked 379 Times in 375 Posts
Kor has a spectacular aura aboutKor has a spectacular aura about
Ok, one more question: will every currency have R$ in front?
I mean... there will be always?

R$ -4
R$ -359,25
R$ 0,00
R$ 12,00
R$ 1.050,13
R$ 352.653,25

(in fact I guess that is not quite important... Important is that I have to remove the dot and to replace comma with a dot, in my array's elements, to be able to sort the values... Still it will be useful for me to know that)
__________________
KOR
Offshore programming
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Kor is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:59 AM.


Advertisement
Log in to turn off these ads.