Thanks a lot Jarry, I was assuming this but could/cannot solve it in my code.
I also introduced a sorter function in the table with just these 2 columns,
but the sort function is always showing the values of the first column for comparison.
Any idea???
QUOTE/CODE
<table id="dg" class="easyui-datagrid" title="Multiple Sorting" style="width:1000px;height:400px"
data-options="
singleSelect:true,
collapsible:true,
remoteSort:false,
multiSort:true
">
<thead>
<tr>
<th data-options="field:'productname',width:100,sortable:true,sorter:MMRDatagridSorter">ProductName</th>
<th data-options="field:'listprice',width:80,align:'right',sortable:true,sorter:MMRDatagridSorter">List Price</th>
</tr>
</thead>
</table>
<div id="mrrconsole"></div>
<script type="text/javascript" src="includes/JS/mrr-main.js"></script>
<script>
//var gDEBUG_LEVEL = 0;
function MMRDatagridSorter(a,b)
{
var a_pure = strip(a);
var b_pure = strip(b);
logconsole("MMRDatagridSorter(): a_pure=["+a_pure+"] b_pure=["+b_pure+"]");
if ( (a_pure.length == 10) && (a_pure.substr(2,1) == '.') && (a_pure.substr(5,1) == '.') &&
(b_pure.length == 10) && (b_pure.substr(2,1) == '.') && (b_pure.substr(5,1) == '.')
)
{
logconsole(' => date');
a = a_pure.split('.');
b = b_pure.split('.');
logconsole(' => date a=['+a+'] b=['+b+']');
if (a[2] == b[2])
{
logconsole(" => (a[2] == b[2]) TRUE" );
if (a[1] == b[1])
{
logconsole(" => (a[1] == b[1]) TRUE return=" + (a[0]>b[0]?1:-1) );
return (a[0]>b[0]?1:-1);
} else
{
logconsole(" => (a[1] == b[1]) FALSE return=" + (a[1]>b[1]?1:-1) );
return (a[1]>b[1]?1:-1);
}
} else
{
logconsole(" => (a[2] == b[2]) FALSE return=" + (a[2]>b[2]?1:-1) );
return (a[2]>b[2]?1:-1);
}
}
else if ( !isNaN(a_pure) && !isNaN(b_pure) )
{
logconsole(' => both numbers return=' + ( (parseFloat(a_pure)>parseFloat(b_pure))? 1: -1) );
return ( (parseFloat(a_pure)>parseFloat(b_pure))? 1: -1);
}
else
{
logconsole(' => neither date nor numbers return=' + (a_pure>b_pure?1:-1) );
return (a_pure>b_pure?1:-1);
}
}
UNQUOTE/CODE
Show Posts
