|
bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 0
|
|
Hello,
I have a problem with the plugin arijtablesorter (with ari sqltable).
I have 13 columns and automatically the last 6 are sortable ??
When sorting = "true" -> all columns are sortable
When sorting = "false" -> only last 6 columns are sortable
What is happening?
Regards
|
|
|
|
|
|
|
Re:bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 748
|
|
Hello,
Provide code that you use, please.
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 0
|
Of course,
| Code: |
{arijtablesorter}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn alias="N°" virtual="true"}
{coltemplate}{$N°}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Joueurs visitйs" virtual="true"}
{coltemplate}{$nom}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias=" " virtual="true"}
{coltemplate}<div align="center">{$indice_a}</div>{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="N° RIL" virtual="true"}
{coltemplate}{$afril}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Points" virtual="true"}
{coltemplate}{$idval}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Class." virtual="true"}
{coltemplate}{$clasril}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias=" " virtual="true" }
{coltemplate}{$Vs}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Joueurs visiteurs" virtual="true"}
{coltemplate}{$nom_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias=" " virtual="true"}
{coltemplate}<div align="center">{$indice_b}</div>{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="N° RIL" virtual="true"}
{coltemplate}{$afril_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Points" virtual="true"}
{coltemplate}{$idval_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Class." virtual="true"}
{coltemplate}{$clasril_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Set1" virtual="true"}
{coltemplate}{$set1}/{$set1_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Set2" virtual="true"}
{coltemplate}{$set2}/{$set2_b}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Pt. visitй" virtual="true"}
{coltemplate}{$pm}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn alias="Pt. visiteur" virtual="true"}
{coltemplate}{$pm2}{/coltemplate}
{/arisqltablecolumn}
{arisqltablecolumn id="N°" alias="N°" hidden="true"}
{arisqltablecolumn id="nom" alias="Nom visiteur" hidden="true"}
{arisqltablecolumn id="afril" alias="N° RIL" hidden="true"}
{arisqltablecolumn id="idval" alias="Points" hidden="true"}
{arisqltablecolumn id="clasril" alias="Class." hidden="true"}
{arisqltablecolumn id="Vs" alias="Vs" hidden="true"}
{arisqltablecolumn id="nom_b" alias="Nom visitй" hidden="true"}
{arisqltablecolumn id="afril_b" alias="N° RIL" hidden="true"}
{arisqltablecolumn id="idval_b" alias="Pointsb" hidden="true"}
{arisqltablecolumn id="clasril_b" alias="Class.b" hidden="true"}
{arisqltablecolumn id="set1" alias="Set1a" hidden="true"}
{arisqltablecolumn id="set1_b" alias="Set1b" hidden="true"}
{arisqltablecolumn id="set2" alias="Set2a" hidden="true"}
{arisqltablecolumn id="set2_b" alias="Set2b" hidden="true"}
{arisqltablecolumn id="pm" alias="pma" hidden="true"}
{arisqltablecolumn id="pm2" alias="pm2b" hidden="true"}
{arisqltablecolumn id="indice_a" alias="indice_a" hidden="true"}
{arisqltablecolumn id="indice_b" alias="indice_b" hidden="true"}
{/arisqltablecolumns}
{arisqltablequery saveTags="true"}
SELECT
substr(a.ref,11,1) as N°,
if(convert(a.nvxp,signed) > convert(a.ancp,signed),concat('<img src="images/stories/up.png" title="Gagne ',a.nvxp-a.ancp,' pts">'),if(convert(a.nvxp,signed) = convert(a.ancp,signed), concat('<img src="images/stories/equal.png" title="Statu quo (',a.nvxp-a.ancp,' pt)">'),concat('<img src="images/stories/down.png" title="Perd ',a.nvxp-a.ancp,' pts">'))) as indice_a,
if(convert(b.nvxp,signed) > convert(b.ancp,signed),concat('<img src="images/stories/up.png" title="Gagne ',b.nvxp-b.ancp,' pts">'),if(convert(b.nvxp,signed) = convert(b.ancp,signed), concat('<img src="images/stories/equal.png" title="Statu quo (',b.nvxp-b.ancp,' pt)">'),concat('<img src="images/stories/down.png" title="Perd ',b.nvxp-b.ancp,' pts">'))) as indice_b,
a.nom,
a.afril,
a.idval,
a.clasril,
concat('Vs') as Vs,
b.nom as nom_b,
b.afril as afril_b,
b.idval as idval_b,
b.clasril as clasril_b,
substr(a.set1,1,1) as set1,
substr(b.set1,1,1) as set1_b,
substr(a.set2,1,1) as set2,
substr(b.set2,1,1) as set2_b,
a.pm,
b.pm as pm2
FROM
<?php echo $pref_db; ?> as a,
<?php echo $pref_db; ?> as b
WHERE
substr(a.ref,1,7) = substr(b.ref,1,7)
and substr(a.ref,9,1) = '1'
and substr(b.ref,9,1) = '2'
and substr(a.ref,1,7) = <?php echo $p3; ?>
and a.type='S'
and b.type='S'
and substr(a.ref,11,1) = substr(b.ref,11,1)
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}
|
|
|
|
|
|
|
|
Re:bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 748
|
Could you provide SQL dump for tables from which you load data by email? This requires the study of this issue on our test server, because the code is big, and it is difficult to say what the problem without investigating.
Regards,
ARI Soft |
|
|
|
|
|
|
Re:bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 0
|
|
SQL dump is sent.
Table 'a' and table 'b' in sqlquery are the same table.
Regards
|
|
|
|
Last Edit: 2010/02/18 13:48 By benbet.
|
|
|
Re:bug with arijtablesorter ? 14 Years, 3 Months ago
|
Karma: 748
|
|
Add colCount="20" attribute to {arijtablesorter} tag, please. It should resolve this issue.
Regards,
ARI Soft
|
|
|
|
|
|
|
