// tableSort.jsx 
// A script of Peter Kahrel 
// http://www.adobeforums.com/cgi-bin/webx?14@@.3bbdde0d/2 
 
tablesort(); 
 
function tablesort()  
{  
	if( app.selection[0].constructor.name != 'InsertionPoint' && app.selection[0].parent.parent.constructor.name != 'Table' )  
	{  
		alert( 'Place cursor in cell--do not select anything')  
		exit()  
	}  
	var temp = new Array()  
	//get a handle on the selected table  
	var tbl = app.selection[0].parent.parent  
	//get the selected column number  
	col = +app.selection[0].parent.name.split(':')[0]  
	//push row contents into temp  
	for( var k = 0; k < tbl.rows.length; k++ )  
		temp.push( tbl.rows[k].contents )  
	quicksortMulti( temp, col, 0, temp.length-1 )  
	//replace table contents  
	for( var k = 0; k < tbl.rows.length; k++ )  
		tbl.rows[k].contents = temp[k]  
}  
 
function quicksortMulti( _array, dim, first, last )  
{  
	var k, j, pivot, temp  
	k = first; j = last;  
	pivot =_array[ Math.floor( ( first + last ) / 2)][dim].toLowerCase()  
	while( k < j )  
	{  
		while( _array[k][dim].toLowerCase() < pivot )   
			k++;  
		while( pivot < _array[j][dim].toLowerCase() )   
			j-- ;  
		if( k <= j )  
		{  
			temp =_array[k];  
			_array[k] = _array[j];  
			_array[j] = temp;  
			k++;  
			j--;  
		}  
	}  
	if( first < j )   
		quicksortMulti( _array, dim, first, j );  
	if( k < last )   
		quicksortMulti( _array, dim, k, last );  
} 

// Description: Sort table 
// Peter Kahrel 
// Place the cursor in the column to be sorted. 
// You can indicate header and footer rows that should be ignored 
// and whether the sort should be ascending or descending. 
// The script recognises numerical data and deals with that correctly. 
 
var tbl = getTable(); 
var params = getParams(); 
 
var sortType = params[0];	// 'ascend' or 'descend' 
var alphanum = params[1];	// 'alpha' or 'num' 
var hdrLines = params[2];	// a number 
var ftrLines = params[3];	// a number 
 
tablesort( tbl, sortType, alphanum, hdrLines, ftrLines ); 
 
//----------------------------------------------------- 
 
function tablesort( tbl, sortType, alphanum, hdr, ftr ) 
{ 
var temp = []; 
var col = app.selection[0].parent.parentColumn.index; 
for( var k = hdr; k < tbl.rows.length-ftr; k++ ) 
	temp.push( tbl.rows[k].contents ); 
switch( sortType+alphanum ) 
	{ 
	case 'ascendalpha' : sortMultiAscendingText( temp, col ) ; break; 
	case 'descendalpha' : sortMultiDescendingText( temp, col ); break; 
	case 'ascendnum' : sortMultiAscendingNum( temp, col ) ; break; 
	case 'descendnum' : sortMultiDescendingNum( temp, col ); 
	} 
for( var k = hdr; k < tbl.rows.length-ftr; k++ ) 
	tbl.rows[k].contents = temp[k-hdr] 
} 
 
//----------------------------------------------------- 
 
function sortMultiAscendingText( array, col ) 
{ 
	function sortAscend( a, b ) 
	{ return a[col] > b[col] } 
return array.sort( sortAscend ) 
} 
 
function sortMultiDescendingText( array, col ) 
{ 
	function sortDescend( a, b ) 
	{ return a[col] < b[col] } 
return array.sort( sortDescend ) 
} 
 
//----------------------------------------------------- 
 
function sortMultiAscendingNum( array, col ) 
{ 
	function sortAscend( a, b ) 
	{ return a[col] - b[col] } 
return array.sort( sortAscend ) 
} 
 
 
function sortMultiDescendingNum( array, col ) 
{ 
	function sortDescend( a, b ) 
	{ return b[col] - a[col] } 
return array.sort( sortDescend ) 
} 
 
 
 
//----------------------------------------------------- 
 
function getParams() 
{ 
var sortTypeButtons; 
var dlg = app.dialogs.add( { name : 'Table sort' } ); 
with( dlg ) 
	{ 
	with( dialogColumns.add() ) 
		{ 
		with( borderPanels.add() ) 
			with( sortTypeButtons = radiobuttonGroups.add( ) ) 
				{ 
				radiobuttonControls.add(  
					{ staticLabel : 'Ascending sort' ,  
						checkedState : true} ); 
				radiobuttonControls.add(  
					{ staticLabel : 'Descending sort' } ) 
				} 
		with( borderPanels.add() ) 
			{ 
			with( dialogColumns.add() ) 
				{ 
				staticTexts.add(  
					{ staticLabel : 'Number of header rows:' } ); 
				staticTexts.add(  
					{ staticLabel : 'Number of footer rows:' } ) 
				} 
			with( dialogColumns.add() ) 
				{ 
				var hdrLines = integerEditboxes.add(  
					{ editValue : 0,  
						minimumValue : 0,  
						maximumValue : 10,  
						smallNudge : 1 } ); 
				var ftrLines = integerEditboxes.add(  
					{ editValue : 0,  
						minimumValue : 0,  
						maximumValue : 10,  
						smallNudge : 1,  
						largeNudge : 5 } ) 
				} 
			} 
		} 
	} 
if( dlg.show() == false ) 
	{ 
	dlg.destroy() 
	exit() 
	}; 
var alphanum = isNumber( app.selection[0].parent.contents ) 
var sortType = ['ascend','descend'][sortTypeButtons.selectedButton]; 
var hdrL = hdrLines.editValue; 
var ftrL = ftrLines.editValue; 
dlg.destroy(); 
return [ sortType, alphanum, hdrL, ftrL ]; 
} 
 
//----------------------------------------------------- 
 
function getTable() 
{ 
if( app.selection.length > 0 ) 
	if( app.selection[0].parent instanceof Table ) 
		{ 
		// if selection is Cell, select cell's insertion point 
		app.selection[0].insertionPoints[0].select(); 
		return app.selection[0].parent.parent; 
		} 
	else if( app.selection[0].parent.parent instanceof Table ) 
		return app.selection[0].parent.parent; 
errorM( 'Cursor not in a table\ror illegal selection' ); 
} 
 
 
function errorM( m ) 
{ 
alert( m ); 
exit(); 
} 
 
 
function isNumber( x ) 
{  
if( isNaN( parseInt( x )) == false ) 
	return 'num'; 
else 
	return 'alpha'; 
}