By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,770 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

Jquery table sorting help

P: 49
hi,
I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums there are, it crashes.

There are currently 6 columns, and I only want 4. How do I remove the last two (discount and date)?

Here is a link: http://www.jaredmoore.com/tablesorte...alestable.html

Here is some jquery js that I think controls it:
Expand|Select|Wrap|Line Numbers
  1. /*
  2.  * 
  3.  * TableSorter 2.0 - Client-side table sorting with ease!
  4.  * Version 2.0.3
  5.  * @requires jQuery v1.2.3
  6.  * 
  7.  * Copyright (c) 2007 Christian Bach
  8.  * Examples and docs at: http://tablesorter.com
  9.  * Dual licensed under the MIT and GPL licenses:
  10.  * http://www.opensource.org/licenses/mit-license.php
  11.  * http://www.gnu.org/licenses/gpl.html
  12.  * 
  13.  */
  14. /**
  15.  *
  16.  * @description Create a sortable table with multi-column sorting capabilitys
  17.  * 
  18.  * @example $('table').tablesorter();
  19.  * @desc Create a simple tablesorter interface.
  20.  *
  21.  * @example $('table').tablesorter({ sortList:[[0,0],[1,0]] });
  22.  * @desc Create a tablesorter interface and sort on the first and secound column in ascending order.
  23.  * 
  24.  * @example $('table').tablesorter({ headers: { 0: { sorter: false}, 1: {sorter: false} } });
  25.  * @desc Create a tablesorter interface and disableing the first and secound column headers.
  26.  * 
  27.  * @example $('table').tablesorter({ 0: {sorter:"integer"}, 1: {sorter:"currency"} });
  28.  * @desc Create a tablesorter interface and set a column parser for the first and secound column.
  29.  * 
  30.  * 
  31.  * @param Object settings An object literal containing key/value pairs to provide optional settings.
  32.  * 
  33.  * @option String cssHeader (optional)             A string of the class name to be appended to sortable tr elements in the thead of the table. 
  34.  *                                                 Default value: "header"
  35.  * 
  36.  * @option String cssAsc (optional)             A string of the class name to be appended to sortable tr elements in the thead on a ascending sort. 
  37.  *                                                 Default value: "headerSortUp"
  38.  * 
  39.  * @option String cssDesc (optional)             A string of the class name to be appended to sortable tr elements in the thead on a descending sort. 
  40.  *                                                 Default value: "headerSortDown"
  41.  * 
  42.  * @option String sortInitialOrder (optional)     A string of the inital sorting order can be asc or desc. 
  43.  *                                                 Default value: "asc"
  44.  * 
  45.  * @option String sortMultisortKey (optional)     A string of the multi-column sort key. 
  46.  *                                                 Default value: "shiftKey"
  47.  * 
  48.  * @option String textExtraction (optional)     A string of the text-extraction method to use. 
  49.  *                                                 For complex html structures inside td cell set this option to "complex", 
  50.  *                                                 on large tables the complex option can be slow. 
  51.  *                                                 Default value: "simple"
  52.  * 
  53.  * @option Object headers (optional)             An array containing the forces sorting rules. 
  54.  *                                                 This option let's you specify a default sorting rule. 
  55.  *                                                 Default value: null
  56.  * 
  57.  * @option Array sortList (optional)             An array containing the forces sorting rules. 
  58.  *                                                 This option let's you specify a default sorting rule. 
  59.  *                                                 Default value: null
  60.  * 
  61.  * @option Array sortForce (optional)             An array containing forced sorting rules. 
  62.  *                                                 This option let's you specify a default sorting rule, which is prepended to user-selected rules.
  63.  *                                                 Default value: null
  64.  *  
  65.   * @option Array sortAppend (optional)             An array containing forced sorting rules. 
  66.  *                                                 This option let's you specify a default sorting rule, which is appended to user-selected rules.
  67.  *                                                 Default value: null
  68.  * 
  69.  * @option Boolean widthFixed (optional)         Boolean flag indicating if tablesorter should apply fixed widths to the table columns.
  70.  *                                                 This is usefull when using the pager companion plugin.
  71.  *                                                 This options requires the dimension jquery plugin.
  72.  *                                                 Default value: false
  73.  *
  74.  * @option Boolean cancelSelection (optional)     Boolean flag indicating if tablesorter should cancel selection of the table headers text.
  75.  *                                                 Default value: true
  76.  *
  77.  * @option Boolean debug (optional)             Boolean flag indicating if tablesorter should display debuging information usefull for development.
  78.  *
  79.  * @type jQuery
  80.  *
  81.  * @name tablesorter
  82.  * 
  83.  * @cat Plugins/Tablesorter
  84.  * 
  85.  * @author Christian Bach/christian.bach@polyester.se
  86.  */
  87.  
  88. (function($) {
  89.     $.extend({
  90.         tablesorter: new function() {
  91.  
  92.             var parsers = [], widgets = [];
  93.  
  94.             this.defaults = {
  95.                 cssHeader: "header",
  96.                 cssAsc: "headerSortUp",
  97.                 cssDesc: "headerSortDown",
  98.                 sortInitialOrder: "asc",
  99.                 sortMultiSortKey: "shiftKey",
  100.                 sortForce: null,
  101.                 sortAppend: null,
  102.                 textExtraction: "simple",
  103.                 parsers: {}, 
  104.                 widgets: [],        
  105.                 widgetZebra: {css: ["even","odd"]},
  106.                 headers: {},
  107.                 widthFixed: false,
  108.                 cancelSelection: true,
  109.                 sortList: [],
  110.                 headerList: [],
  111.                 dateFormat: "us",
  112.                 decimal: '.',
  113.                 debug: false
  114.             };
  115.  
  116.             /* debuging utils */
  117.             function benchmark(s,d) {
  118.                 log(s + "," + (new Date().getTime() - d.getTime()) + "ms");
  119.             }
  120.  
  121.             this.benchmark = benchmark;
  122.  
  123.             function log(s) {
  124.                 if (typeof console != "undefined" && typeof console.debug != "undefined") {
  125.                     console.log(s);
  126.                 } else {
  127.                     alert(s);
  128.                 }
  129.             }
  130.  
  131.             /* parsers utils */
  132.             function buildParserCache(table,$headers) {
  133.  
  134.                 if(table.config.debug) { var parsersDebug = ""; }
  135.  
  136.                 var rows = table.tBodies[0].rows;
  137.  
  138.                 if(table.tBodies[0].rows[0]) {
  139.  
  140.                     var list = [], cells = rows[0].cells, l = cells.length;
  141.  
  142.                     for (var i=0;i < l; i++) {
  143.                         var p = false;
  144.  
  145.                         if($.metadata && ($($headers[i]).metadata() && $($headers[i]).metadata().sorter)  ) {
  146.  
  147.                             p = getParserById($($headers[i]).metadata().sorter);    
  148.  
  149.                         } else if((table.config.headers[i] && table.config.headers[i].sorter)) {
  150.  
  151.                             p = getParserById(table.config.headers[i].sorter);
  152.                         }
  153.                         if(!p) {
  154.                             p = detectParserForColumn(table,cells[i]);
  155.                         }
  156.  
  157.                         if(table.config.debug) { parsersDebug += "column:" + i + " parser:" +p.id + "\n"; }
  158.  
  159.                         list.push(p);
  160.                     }
  161.                 }
  162.  
  163.                 if(table.config.debug) { log(parsersDebug); }
  164.  
  165.                 return list;
  166.             };
  167.  
  168.             function detectParserForColumn(table,node) {
  169.                 var l = parsers.length;
  170.                 for(var i=1; i < l; i++) {
  171.                     if(parsers[i].is($.trim(getElementText(table.config,node)),table,node)) {
  172.                         return parsers[i];
  173.                     }
  174.                 }
  175.                 // 0 is always the generic parser (text)
  176.                 return parsers[0];
  177.             }
  178.  
  179.             function getParserById(name) {
  180.                 var l = parsers.length;
  181.                 for(var i=0; i < l; i++) {
  182.                     if(parsers[i].id.toLowerCase() == name.toLowerCase()) {    
  183.                         return parsers[i];
  184.                     }
  185.                 }
  186.                 return false;
  187.             }
  188.  
  189.             /* utils */
  190.             function buildCache(table) {
  191.  
  192.                 if(table.config.debug) { var cacheTime = new Date(); }
  193.  
  194.  
  195.                 var totalRows = (table.tBodies[0] && table.tBodies[0].rows.length) || 0,
  196.                     totalCells = (table.tBodies[0].rows[0] && table.tBodies[0].rows[0].cells.length) || 0,
  197.                     parsers = table.config.parsers, 
  198.                     cache = {row: [], normalized: []};
  199.  
  200.                     for (var i=0;i < totalRows; ++i) {
  201.  
  202.                         /** Add the table data to main data array */
  203.                         var c = table.tBodies[0].rows[i], cols = [];
  204.  
  205.                         cache.row.push($(c));
  206.  
  207.                         for(var j=0; j < totalCells; ++j) {
  208.                             cols.push(parsers[j].format(getElementText(table.config,c.cells[j]),table,c.cells[j]));    
  209.                         }
  210.  
  211.                         cols.push(i); // add position for rowCache
  212.                         cache.normalized.push(cols);
  213.                         cols = null;
  214.                     };
  215.  
  216.                 if(table.config.debug) { benchmark("Building cache for " + totalRows + " rows:", cacheTime); }
  217.  
  218.                 return cache;
  219.             };
  220.  
  221.             function getElementText(config,node) {
  222.  
  223.                 if(!node) return "";
  224.  
  225.                 var t = "";
  226.  
  227.                 if(config.textExtraction == "simple") {
  228.                     if(node.childNodes[0] && node.childNodes[0].hasChildNodes()) {
  229.                         t = node.childNodes[0].innerHTML;
  230.                     } else {
  231.                         t = node.innerHTML;
  232.                     }
  233.                 } else {
  234.                     if(typeof(config.textExtraction) == "function") {
  235.                         t = config.textExtraction(node);
  236.                     } else { 
  237.                         t = $(node).text();
  238.                     }    
  239.                 }
  240.                 return t;
  241.             }
  242.  
  243.             function appendToTable(table,cache) {
  244.  
  245.                 if(table.config.debug) {var appendTime = new Date()}
  246.  
  247.                 var c = cache, 
  248.                     r = c.row, 
  249.                     n= c.normalized, 
  250.                     totalRows = n.length, 
  251.                     checkCell = (n[0].length-1), 
  252.                     tableBody = $(table.tBodies[0]),
  253.                     rows = [];
  254.  
  255.                 for (var i=0;i < totalRows; i++) {
  256.                     rows.push(r[n[i][checkCell]]);    
  257.                     if(!table.config.appender) {
  258.  
  259.                         var o = r[n[i][checkCell]];
  260.                         var l = o.length;
  261.                         for(var j=0; j < l; j++) {
  262.  
  263.                             tableBody[0].appendChild(o[j]);
  264.  
  265.                         }
  266.  
  267.                         //tableBody.append(r[n[i][checkCell]]);
  268.                     }
  269.                 }    
  270.  
  271.                 if(table.config.appender) {
  272.  
  273.                     table.config.appender(table,rows);    
  274.                 }
  275.  
  276.                 rows = null;
  277.  
  278.                 if(table.config.debug) { benchmark("Rebuilt table:", appendTime); }
  279.  
  280.                 //apply table widgets
  281.                 applyWidget(table);
  282.  
  283.                 // trigger sortend
  284.                 setTimeout(function() {
  285.                     $(table).trigger("sortEnd");    
  286.                 },0);
  287.  
  288.             };
  289.  
  290.             function buildHeaders(table) {
  291.  
  292.                 if(table.config.debug) { var time = new Date(); }
  293.  
  294.                 var meta = ($.metadata) ? true : false, tableHeadersRows = [];
  295.  
  296.                 for(var i = 0; i < table.tHead.rows.length; i++) { tableHeadersRows[i]=0; };
  297.  
  298.                 $tableHeaders = $("thead th",table);
  299.  
  300.                 $tableHeaders.each(function(index) {
  301.  
  302.                     this.count = 0;
  303.                     this.column = index;
  304.                     this.order = formatSortingOrder(table.config.sortInitialOrder);
  305.  
  306.                     if(checkHeaderMetadata(this) || checkHeaderOptions(table,index)) this.sortDisabled = true;
  307.  
  308.                     if(!this.sortDisabled) {
  309.                         $(this).addClass(table.config.cssHeader);
  310.                     }
  311.  
  312.                     // add cell to headerList
  313.                     table.config.headerList[index]= this;
  314.                 });
  315.  
  316.                 if(table.config.debug) { benchmark("Built headers:", time); log($tableHeaders); }
  317.  
  318.                 return $tableHeaders;
  319.  
  320.             };
  321.  
  322.                function checkCellColSpan(table, rows, row) {
  323.                 var arr = [], r = table.tHead.rows, c = r[row].cells;
  324.  
  325.                 for(var i=0; i < c.length; i++) {
  326.                     var cell = c[i];
  327.  
  328.                     if ( cell.colSpan > 1) { 
  329.                         arr = arr.concat(checkCellColSpan(table, headerArr,row++));
  330.                     } else  {
  331.                         if(table.tHead.length == 1 || (cell.rowSpan > 1 || !r[row+1])) {
  332.                             arr.push(cell);
  333.                         }
  334.                         //headerArr[row] = (i+row);
  335.                     }
  336.                 }
  337.                 return arr;
  338.             };
  339.  
  340.             function checkHeaderMetadata(cell) {
  341.                 if(($.metadata) && ($(cell).metadata().sorter === false)) { return true; };
  342.                 return false;
  343.             }
  344.  
  345.             function checkHeaderOptions(table,i) {    
  346.                 if((table.config.headers[i]) && (table.config.headers[i].sorter === false)) { return true; };
  347.                 return false;
  348.             }
  349.  
  350.             function applyWidget(table) {
  351.                 var c = table.config.widgets;
  352.                 var l = c.length;
  353.                 for(var i=0; i < l; i++) {
  354.  
  355.                     getWidgetById(c[i]).format(table);
  356.                 }
  357.  
  358.             }
  359.  
  360.             function getWidgetById(name) {
  361.                 var l = widgets.length;
  362.                 for(var i=0; i < l; i++) {
  363.                     if(widgets[i].id.toLowerCase() == name.toLowerCase() ) {
  364.                         return widgets[i]; 
  365.                     }
  366.                 }
  367.             };
  368.  
  369.             function formatSortingOrder(v) {
  370.  
  371.                 if(typeof(v) != "Number") {
  372.                     i = (v.toLowerCase() == "desc") ? 1 : 0;
  373.                 } else {
  374.                     i = (v == (0 || 1)) ? v : 0;
  375.                 }
  376.                 return i;
  377.             }
  378.  
  379.             function isValueInArray(v, a) {
  380.                 var l = a.length;
  381.                 for(var i=0; i < l; i++) {
  382.                     if(a[i][0] == v) {
  383.                         return true;    
  384.                     }
  385.                 }
  386.                 return false;
  387.             }
  388.  
  389.             function setHeadersCss(table,$headers, list, css) {
  390.                 // remove all header information
  391.                 $headers.removeClass(css[0]).removeClass(css[1]);
  392.  
  393.                 var h = [];
  394.                 $headers.each(function(offset) {
  395.                         if(!this.sortDisabled) {
  396.                             h[this.column] = $(this);                    
  397.                         }
  398.                 });
  399.  
  400.                 var l = list.length; 
  401.                 for(var i=0; i < l; i++) {
  402.                     h[list[i][0]].addClass(css[list[i][1]]);
  403.                 }
  404.             }
  405.  
  406.             function fixColumnWidth(table,$headers) {
  407.                 var c = table.config;
  408.                 if(c.widthFixed) {
  409.                     var colgroup = $('<colgroup>');
  410.                     $("tr:first td",table.tBodies[0]).each(function() {
  411.                         colgroup.append($('<col>').css('width',$(this).width()));
  412.                     });
  413.                     $(table).prepend(colgroup);
  414.                 };
  415.             }
  416.  
  417.             function updateHeaderSortCount(table,sortList) {
  418.                 var c = table.config, l = sortList.length;
  419.                 for(var i=0; i < l; i++) {
  420.                     var s = sortList[i], o = c.headerList[s[0]];
  421.                     o.count = s[1];
  422.                     o.count++;
  423.                 }
  424.             }
  425.  
  426.             /* sorting methods */
  427.             function multisort(table,sortList,cache) {
  428.  
  429.                 if(table.config.debug) { var sortTime = new Date(); }
  430.  
  431.                 var dynamicExp = "var sortWrapper = function(a,b) {", l = sortList.length;
  432.  
  433.                 for(var i=0; i < l; i++) {
  434.  
  435.                     var c = sortList[i][0];
  436.                     var order = sortList[i][1];
  437.                     var s = (getCachedSortType(table.config.parsers,c) == "text") ? ((order == 0) ? "sortText" : "sortTextDesc") : ((order == 0) ? "sortNumeric" : "sortNumericDesc");
  438.  
  439.                     var e = "e" + i;
  440.  
  441.                     dynamicExp += "var " + e + " = " + s + "(a[" + c + "],b[" + c + "]); ";
  442.                     dynamicExp += "if(" + e + ") { return " + e + "; } ";
  443.                     dynamicExp += "else { ";
  444.                 }
  445.  
  446.                 // if value is the same keep orignal order    
  447.                 var orgOrderCol = cache.normalized[0].length - 1;
  448.                 dynamicExp += "return a[" + orgOrderCol + "]-b[" + orgOrderCol + "];";
  449.  
  450.                 for(var i=0; i < l; i++) {
  451.                     dynamicExp += "}; ";
  452.                 }
  453.  
  454.                 dynamicExp += "return 0; ";    
  455.                 dynamicExp += "}; ";    
  456.  
  457.                 eval(dynamicExp);
  458.  
  459.                 cache.normalized.sort(sortWrapper);
  460.  
  461.                 if(table.config.debug) { benchmark("Sorting on " + sortList.toString() + " and dir " + order+ " time:", sortTime); }
  462.  
  463.                 return cache;
  464.             };
  465.  
  466.             function sortText(a,b) {
  467.                 return ((a < b) ? -1 : ((a > b) ? 1 : 0));
  468.             };
  469.  
  470.             function sortTextDesc(a,b) {
  471.                 return ((b < a) ? -1 : ((b > a) ? 1 : 0));
  472.             };    
  473.  
  474.              function sortNumeric(a,b) {
  475.                 return a-b;
  476.             };
  477.  
  478.             function sortNumericDesc(a,b) {
  479.                 return b-a;
  480.             };
  481.  
  482.             function getCachedSortType(parsers,i) {
  483.                 return parsers[i].type;
  484.             };
  485.  
  486.             /* public methods */
  487.             this.construct = function(settings) {
  488.  
  489.                 return this.each(function() {
  490.  
  491.                     if(!this.tHead || !this.tBodies) return;
  492.  
  493.                     var $this, $document,$headers, cache, config, shiftDown = 0, sortOrder;
  494.  
  495.                     this.config = {};
  496.  
  497.                     config = $.extend(this.config, $.tablesorter.defaults, settings);
  498.  
  499.                     // store common expression for speed                    
  500.                     $this = $(this);
  501.  
  502.                     // build headers
  503.                     $headers = buildHeaders(this);
  504.  
  505.                     // try to auto detect column type, and store in tables config
  506.                     this.config.parsers = buildParserCache(this,$headers);
  507.  
  508.  
  509.                     // build the cache for the tbody cells
  510.                     cache = buildCache(this);
  511.  
  512.                     // get the css class names, could be done else where.
  513.                     var sortCSS = [config.cssDesc,config.cssAsc];
  514.  
  515.                     // fixate columns if the users supplies the fixedWidth option
  516.                     fixColumnWidth(this);
  517.  
  518.                     // apply event handling to headers
  519.                     // this is to big, perhaps break it out?
  520.                     $headers.click(function(e) {
  521.  
  522.                         $this.trigger("sortStart");
  523.  
  524.                         var totalRows = ($this[0].tBodies[0] && $this[0].tBodies[0].rows.length) || 0;
  525.  
  526.                         if(!this.sortDisabled && totalRows > 0) {
  527.  
  528.  
  529.                             // store exp, for speed
  530.                             var $cell = $(this);
  531.  
  532.                             // get current column index
  533.                             var i = this.column;
  534.  
  535.                             // get current column sort order
  536.                             this.order = this.count++ % 2;
  537.  
  538.                             // user only whants to sort on one column
  539.                             if(!e[config.sortMultiSortKey]) {
  540.  
  541.                                 // flush the sort list
  542.                                 config.sortList = [];
  543.  
  544.                                 if(config.sortForce != null) {
  545.                                     var a = config.sortForce; 
  546.                                     for(var j=0; j < a.length; j++) {
  547.                                         if(a[j][0] != i) {
  548.                                             config.sortList.push(a[j]);
  549.                                         }
  550.                                     }
  551.                                 }
  552.  
  553.                                 // add column to sort list
  554.                                 config.sortList.push([i,this.order]);
  555.  
  556.                             // multi column sorting
  557.                             } else {
  558.                                 // the user has clicked on an all ready sortet column.
  559.                                 if(isValueInArray(i,config.sortList)) {     
  560.  
  561.                                     // revers the sorting direction for all tables.
  562.                                     for(var j=0; j < config.sortList.length; j++) {
  563.                                         var s = config.sortList[j], o = config.headerList[s[0]];
  564.                                         if(s[0] == i) {
  565.                                             o.count = s[1];
  566.                                             o.count++;
  567.                                             s[1] = o.count % 2;
  568.                                         }
  569.                                     }    
  570.                                 } else {
  571.                                     // add column to sort list array
  572.                                     config.sortList.push([i,this.order]);
  573.                                 }
  574.                             };
  575.                             setTimeout(function() {
  576.                                 //set css for headers
  577.                                 setHeadersCss($this[0],$headers,config.sortList,sortCSS);
  578.                                 appendToTable($this[0],multisort($this[0],config.sortList,cache));
  579.                             },1);
  580.                             // stop normal event by returning false
  581.                             return false;
  582.                         }
  583.                     // cancel selection    
  584.                     }).mousedown(function() {
  585.                         if(config.cancelSelection) {
  586.                             this.onselectstart = function() {return false};
  587.                             return false;
  588.                         }
  589.                     });
  590.  
  591.                     // apply easy methods that trigger binded events
  592.                     $this.bind("update",function() {
  593.  
  594.                         // rebuild parsers.
  595.                         this.config.parsers = buildParserCache(this,$headers);
  596.  
  597.                         // rebuild the cache map
  598.                         cache = buildCache(this);
  599.  
  600.                     }).bind("sorton",function(e,list) {
  601.  
  602.                         $(this).trigger("sortStart");
  603.  
  604.                         config.sortList = list;
  605.  
  606.                         // update and store the sortlist
  607.                         var sortList = config.sortList;
  608.  
  609.                         // update header count index
  610.                         updateHeaderSortCount(this,sortList);
  611.  
  612.                         //set css for headers
  613.                         setHeadersCss(this,$headers,sortList,sortCSS);
  614.  
  615.  
  616.                         // sort the table and append it to the dom
  617.                         appendToTable(this,multisort(this,sortList,cache));
  618.  
  619.                     }).bind("appendCache",function() {
  620.  
  621.                         appendToTable(this,cache);
  622.  
  623.                     }).bind("applyWidgetId",function(e,id) {
  624.  
  625.                         getWidgetById(id).format(this);
  626.  
  627.                     }).bind("applyWidgets",function() {
  628.                         // apply widgets
  629.                         applyWidget(this);
  630.                     });
  631.  
  632.                     if($.metadata && ($(this).metadata() && $(this).metadata().sortlist)) {
  633.                         config.sortList = $(this).metadata().sortlist;
  634.                     }
  635.                     // if user has supplied a sort list to constructor.
  636.                     if(config.sortList.length > 0) {
  637.                         $this.trigger("sorton",[config.sortList]);    
  638.                     }
  639.  
  640.                     // apply widgets
  641.                     applyWidget(this);
  642.                 });
  643.             };
  644.  
  645.             this.addParser = function(parser) {
  646.                 var l = parsers.length, a = true;
  647.                 for(var i=0; i < l; i++) {
  648.                     if(parsers[i].id.toLowerCase() == parser.id.toLowerCase()) {
  649.                         a = false;
  650.                     }
  651.                 }
  652.                 if(a) { parsers.push(parser); };
  653.             };
  654.  
  655.             this.addWidget = function(widget) {
  656.                 widgets.push(widget);
  657.             };
  658.  
  659.             this.formatFloat = function(s) {
  660.                 var i = parseFloat(s);
  661.                 return (isNaN(i)) ? 0 : i;
  662.             };
  663.             this.formatInt = function(s) {
  664.                 var i = parseInt(s);
  665.                 return (isNaN(i)) ? 0 : i;
  666.             };
  667.  
  668.             this.isDigit = function(s,config) {
  669.                 var DECIMAL = '\\' + config.decimal;
  670.                 var exp = '/(^[+]?0(' + DECIMAL +'0+)?$)|(^([-+]?[1-9][0-9]*)$)|(^([-+]?((0?|[1-9][0-9]*)' + DECIMAL +'(0*[1-9][0-9]*)))$)|(^[-+]?[1-9]+[0-9]*' + DECIMAL +'0+$)/';
  671.                 return RegExp(exp).test($.trim(s));
  672.             };
  673.  
  674.             this.clearTableBody = function(table) {
  675.                 if($.browser.msie) {
  676.                     function empty() {
  677.                         while ( this.firstChild ) this.removeChild( this.firstChild );
  678.                     }
  679.                     empty.apply(table.tBodies[0]);
  680.                 } else {
  681.                     table.tBodies[0].innerHTML = "";
  682.                 }
  683.             };
  684.         }
  685.     });
  686.  
  687.     // extend plugin scope
  688.     $.fn.extend({
  689.         tablesorter: $.tablesorter.construct
  690.     });
  691.  
  692.     var ts = $.tablesorter;
  693.  
  694.     // add default parsers
  695.     ts.addParser({
  696.         id: "text",
  697.         is: function(s) {
  698.             return true;
  699.         },
  700.         format: function(s) {
  701.             return $.trim(s.toLowerCase());
  702.         },
  703.         type: "text"
  704.     });
  705.  
  706.     ts.addParser({
  707.         id: "digit",
  708.         is: function(s,table) {
  709.             var c = table.config;
  710.             return $.tablesorter.isDigit(s,c);
  711.         },
  712.         format: function(s) {
  713.             return $.tablesorter.formatFloat(s);
  714.         },
  715.         type: "numeric"
  716.     });
  717.  
  718.     ts.addParser({
  719.         id: "currency",
  720.         is: function(s) {
  721.             return /^[$€?.]/.test(s);
  722.         },
  723.         format: function(s) {
  724.             return $.tablesorter.formatFloat(s.replace(new RegExp(/[^0-9.]/g),""));
  725.         },
  726.         type: "numeric"
  727.     });
  728.  
  729.     ts.addParser({
  730.         id: "ipAddress",
  731.         is: function(s) {
  732.             return /^\d{2,3}[\.]\d{2,3}[\.]\d{2,3}[\.]\d{2,3}$/.test(s);
  733.         },
  734.         format: function(s) {
  735.             var a = s.split("."), r = "", l = a.length;
  736.             for(var i = 0; i < l; i++) {
  737.                 var item = a[i];
  738.                    if(item.length == 2) {
  739.                     r += "0" + item;
  740.                    } else {
  741.                     r += item;
  742.                    }
  743.             }
  744.             return $.tablesorter.formatFloat(r);
  745.         },
  746.         type: "numeric"
  747.     });
  748.  
  749.     ts.addParser({
  750.         id: "url",
  751.         is: function(s) {
  752.             return /^(https?|ftp|file):\/\/$/.test(s);
  753.         },
  754.         format: function(s) {
  755.             return jQuery.trim(s.replace(new RegExp(/(https?|ftp|file):\/\//),''));
  756.         },
  757.         type: "text"
  758.     });
  759.  
  760.     ts.addParser({
  761.         id: "isoDate",
  762.         is: function(s) {
  763.             return /^\d{4}[\/-]\d{1,2}[\/-]\d{1,2}$/.test(s);
  764.         },
  765.         format: function(s) {
  766.             return $.tablesorter.formatFloat((s != "") ? new Date(s.replace(new RegExp(/-/g),"/")).getTime() : "0");
  767.         },
  768.         type: "numeric"
  769.     });
  770.  
  771.     ts.addParser({
  772.         id: "percent",
  773.         is: function(s) { 
  774.             return /\%$/.test($.trim(s));
  775.         },
  776.         format: function(s) {
  777.             return $.tablesorter.formatFloat(s.replace(new RegExp(/%/g),""));
  778.         },
  779.         type: "numeric"
  780.     });
  781.  
  782.     ts.addParser({
  783.         id: "usLongDate",
  784.         is: function(s) {
  785.             return s.match(new RegExp(/^[A-Za-z]{3,10}\.? [0-9]{1,2}, ([0-9]{4}|'?[0-9]{2}) (([0-2]?[0-9]:[0-5][0-9])|([0-1]?[0-9]:[0-5][0-9]\s(AM|PM)))$/));
  786.         },
  787.         format: function(s) {
  788.             return $.tablesorter.formatFloat(new Date(s).getTime());
  789.         },
  790.         type: "numeric"
  791.     });
  792.  
  793.     ts.addParser({
  794.         id: "shortDate",
  795.         is: function(s) {
  796.             return /\d{1,2}[\/\-]\d{1,2}[\/\-]\d{2,4}/.test(s);
  797.         },
  798.         format: function(s,table) {
  799.             var c = table.config;
  800.             s = s.replace(/\-/g,"/");
  801.             if(c.dateFormat == "us") {
  802.                 // reformat the string in ISO format
  803.                 s = s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{4})/, "$3/$1/$2");
  804.             } else if(c.dateFormat == "uk") {
  805.                 //reformat the string in ISO format
  806.                 s = s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{4})/, "$3/$2/$1");
  807.             } else if(c.dateFormat == "dd/mm/yy" || c.dateFormat == "dd-mm-yy") {
  808.                 s = s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{2})/, "$1/$2/$3");    
  809.             }
  810.             return $.tablesorter.formatFloat(new Date(s).getTime());
  811.         },
  812.         type: "numeric"
  813.     });
  814.  
  815.     ts.addParser({
  816.         id: "time",
  817.         is: function(s) {
  818.             return /^(([0-2]?[0-9]:[0-5][0-9])|([0-1]?[0-9]:[0-5][0-9]\s(am|pm)))$/.test(s);
  819.         },
  820.         format: function(s) {
  821.             return $.tablesorter.formatFloat(new Date("2000/01/01 " + s).getTime());
  822.         },
  823.       type: "numeric"
  824.     });
  825.  
  826.  
  827.     ts.addParser({
  828.         id: "metadata",
  829.         is: function(s) {
  830.             return false;
  831.         },
  832.         format: function(s,table,cell) {
  833.             var c = table.config, p = (!c.parserMetadataName) ? 'sortValue' : c.parserMetadataName;
  834.             return $(cell).metadata()[p];
  835.         },
  836.       type: "numeric"
  837.     });
  838.  
  839.     // add default widgets
  840.     ts.addWidget({
  841.         id: "zebra",
  842.         format: function(table) {
  843.             if(table.config.debug) { var time = new Date(); }
  844.             $("tr:visible",table.tBodies[0])
  845.             .filter(':even')
  846.             .removeClass(table.config.widgetZebra.css[1]).addClass(table.config.widgetZebra.css[0])
  847.             .end().filter(':odd')
  848.             .removeClass(table.config.widgetZebra.css[0]).addClass(table.config.widgetZebra.css[1]);
  849.             if(table.config.debug) { $.tablesorter.benchmark("Applying Zebra widget", time); }
  850.         }
  851.     });    
  852. })(jQuery);
Another .js that is included:
Expand|Select|Wrap|Line Numbers
  1. (function($){$.extend({tablesorter:new function(){var parsers=[],widgets=[];this.defaults={cssHeader:"header",cssAsc:"headerSortUp",cssDesc:"headerSortDown",sortInitialOrder:"asc",sortMultiSortKey:"shiftKey",sortForce:null,sortAppend:null,textExtraction:"simple",parsers:{},widgets:[],widgetZebra:{css:["even","odd"]},headers:{},widthFixed:false,cancelSelection:true,sortList:[],headerList:[],dateFormat:"us",decimal:'.',debug:false};function benchmark(s,d){log(s+","+(new Date().getTime()-d.getTime())+"ms");}this.benchmark=benchmark;function log(s){if(typeof console!="undefined"&&typeof console.debug!="undefined"){console.log(s);}else{alert(s);}}function buildParserCache(table,$headers){if(table.config.debug){var parsersDebug="";}var rows=table.tBodies[0].rows;if(table.tBodies[0].rows[0]){var list=[],cells=rows[0].cells,l=cells.length;for(var i=0;i<l;i++){var p=false;if($.metadata&&($($headers[i]).metadata()&&$($headers[i]).metadata().sorter)){p=getParserById($($headers[i]).metadata().sorter);}else if((table.config.headers[i]&&table.config.headers[i].sorter)){p=getParserById(table.config.headers[i].sorter);}if(!p){p=detectParserForColumn(table,cells[i]);}if(table.config.debug){parsersDebug+="column:"+i+" parser:"+p.id+"\n";}list.push(p);}}if(table.config.debug){log(parsersDebug);}return list;};function detectParserForColumn(table,node){var l=parsers.length;for(var i=1;i<l;i++){if(parsers[i].is($.trim(getElementText(table.config,node)),table,node)){return parsers[i];}}return parsers[0];}function getParserById(name){var l=parsers.length;for(var i=0;i<l;i++){if(parsers[i].id.toLowerCase()==name.toLowerCase()){return parsers[i];}}return false;}function buildCache(table){if(table.config.debug){var cacheTime=new Date();}var totalRows=(table.tBodies[0]&&table.tBodies[0].rows.length)||0,totalCells=(table.tBodies[0].rows[0]&&table.tBodies[0].rows[0].cells.length)||0,parsers=table.config.parsers,cache={row:[],normalized:[]};for(var i=0;i<totalRows;++i){var c=table.tBodies[0].rows[i],cols=[];cache.row.push($(c));for(var j=0;j<totalCells;++j){cols.push(parsers[j].format(getElementText(table.config,c.cells[j]),table,c.cells[j]));}cols.push(i);cache.normalized.push(cols);cols=null;};if(table.config.debug){benchmark("Building cache for "+totalRows+" rows:",cacheTime);}return cache;};function getElementText(config,node){if(!node)return"";var t="";if(config.textExtraction=="simple"){if(node.childNodes[0]&&node.childNodes[0].hasChildNodes()){t=node.childNodes[0].innerHTML;}else{t=node.innerHTML;}}else{if(typeof(config.textExtraction)=="function"){t=config.textExtraction(node);}else{t=$(node).text();}}return t;}function appendToTable(table,cache){if(table.config.debug){var appendTime=new Date()}var c=cache,r=c.row,n=c.normalized,totalRows=n.length,checkCell=(n[0].length-1),tableBody=$(table.tBodies[0]),rows=[];for(var i=0;i<totalRows;i++){rows.push(r[n[i][checkCell]]);if(!table.config.appender){var o=r[n[i][checkCell]];var l=o.length;for(var j=0;j<l;j++){tableBody[0].appendChild(o[j]);}}}if(table.config.appender){table.config.appender(table,rows);}rows=null;if(table.config.debug){benchmark("Rebuilt table:",appendTime);}applyWidget(table);setTimeout(function(){$(table).trigger("sortEnd");},0);};function buildHeaders(table){if(table.config.debug){var time=new Date();}var meta=($.metadata)?true:false,tableHeadersRows=[];for(var i=0;i<table.tHead.rows.length;i++){tableHeadersRows[i]=0;};$tableHeaders=$("thead th",table);$tableHeaders.each(function(index){this.count=0;this.column=index;this.order=formatSortingOrder(table.config.sortInitialOrder);if(checkHeaderMetadata(this)||checkHeaderOptions(table,index))this.sortDisabled=true;if(!this.sortDisabled){$(this).addClass(table.config.cssHeader);}table.config.headerList[index]=this;});if(table.config.debug){benchmark("Built headers:",time);log($tableHeaders);}return $tableHeaders;};function checkCellColSpan(table,rows,row){var arr=[],r=table.tHead.rows,c=r[row].cells;for(var i=0;i<c.length;i++){var cell=c[i];if(cell.colSpan>1){arr=arr.concat(checkCellColSpan(table,headerArr,row++));}else{if(table.tHead.length==1||(cell.rowSpan>1||!r[row+1])){arr.push(cell);}}}return arr;};function checkHeaderMetadata(cell){if(($.metadata)&&($(cell).metadata().sorter===false)){return true;};return false;}function checkHeaderOptions(table,i){if((table.config.headers[i])&&(table.config.headers[i].sorter===false)){return true;};return false;}function applyWidget(table){var c=table.config.widgets;var l=c.length;for(var i=0;i<l;i++){getWidgetById(c[i]).format(table);}}function getWidgetById(name){var l=widgets.length;for(var i=0;i<l;i++){if(widgets[i].id.toLowerCase()==name.toLowerCase()){return widgets[i];}}};function formatSortingOrder(v){if(typeof(v)!="Number"){i=(v.toLowerCase()=="desc")?1:0;}else{i=(v==(0||1))?v:0;}return i;}function isValueInArray(v,a){var l=a.length;for(var i=0;i<l;i++){if(a[i][0]==v){return true;}}return false;}function setHeadersCss(table,$headers,list,css){$headers.removeClass(css[0]).removeClass(css[1]);var h=[];$headers.each(function(offset){if(!this.sortDisabled){h[this.column]=$(this);}});var l=list.length;for(var i=0;i<l;i++){h[list[i][0]].addClass(css[list[i][1]]);}}function fixColumnWidth(table,$headers){var c=table.config;if(c.widthFixed){var colgroup=$('<colgroup>');$("tr:first td",table.tBodies[0]).each(function(){colgroup.append($('<col>').css('width',$(this).width()));});$(table).prepend(colgroup);};}function updateHeaderSortCount(table,sortList){var c=table.config,l=sortList.length;for(var i=0;i<l;i++){var s=sortList[i],o=c.headerList[s[0]];o.count=s[1];o.count++;}}function multisort(table,sortList,cache){if(table.config.debug){var sortTime=new Date();}var dynamicExp="var sortWrapper = function(a,b) {",l=sortList.length;for(var i=0;i<l;i++){var c=sortList[i][0];var order=sortList[i][1];var s=(getCachedSortType(table.config.parsers,c)=="text")?((order==0)?"sortText":"sortTextDesc"):((order==0)?"sortNumeric":"sortNumericDesc");var e="e"+i;dynamicExp+="var "+e+" = "+s+"(a["+c+"],b["+c+"]); ";dynamicExp+="if("+e+") { return "+e+"; } ";dynamicExp+="else { ";}var orgOrderCol=cache.normalized[0].length-1;dynamicExp+="return a["+orgOrderCol+"]-b["+orgOrderCol+"];";for(var i=0;i<l;i++){dynamicExp+="}; ";}dynamicExp+="return 0; ";dynamicExp+="}; ";eval(dynamicExp);cache.normalized.sort(sortWrapper);if(table.config.debug){benchmark("Sorting on "+sortList.toString()+" and dir "+order+" time:",sortTime);}return cache;};function sortText(a,b){return((a<b)?-1:((a>b)?1:0));};function sortTextDesc(a,b){return((b<a)?-1:((b>a)?1:0));};function sortNumeric(a,b){return a-b;};function sortNumericDesc(a,b){return b-a;};function getCachedSortType(parsers,i){return parsers[i].type;};this.construct=function(settings){return this.each(function(){if(!this.tHead||!this.tBodies)return;var $this,$document,$headers,cache,config,shiftDown=0,sortOrder;this.config={};config=$.extend(this.config,$.tablesorter.defaults,settings);$this=$(this);$headers=buildHeaders(this);this.config.parsers=buildParserCache(this,$headers);cache=buildCache(this);var sortCSS=[config.cssDesc,config.cssAsc];fixColumnWidth(this);$headers.click(function(e){$this.trigger("sortStart");var totalRows=($this[0].tBodies[0]&&$this[0].tBodies[0].rows.length)||0;if(!this.sortDisabled&&totalRows>0){var $cell=$(this);var i=this.column;this.order=this.count++%2;if(!e[config.sortMultiSortKey]){config.sortList=[];if(config.sortForce!=null){var a=config.sortForce;for(var j=0;j<a.length;j++){if(a[j][0]!=i){config.sortList.push(a[j]);}}}config.sortList.push([i,this.order]);}else{if(isValueInArray(i,config.sortList)){for(var j=0;j<config.sortList.length;j++){var s=config.sortList[j],o=config.headerList[s[0]];if(s[0]==i){o.count=s[1];o.count++;s[1]=o.count%2;}}}else{config.sortList.push([i,this.order]);}};setTimeout(function(){setHeadersCss($this[0],$headers,config.sortList,sortCSS);appendToTable($this[0],multisort($this[0],config.sortList,cache));},1);return false;}}).mousedown(function(){if(config.cancelSelection){this.onselectstart=function(){return false};return false;}});$this.bind("update",function(){this.config.parsers=buildParserCache(this,$headers);cache=buildCache(this);}).bind("sorton",function(e,list){$(this).trigger("sortStart");config.sortList=list;var sortList=config.sortList;updateHeaderSortCount(this,sortList);setHeadersCss(this,$headers,sortList,sortCSS);appendToTable(this,multisort(this,sortList,cache));}).bind("appendCache",function(){appendToTable(this,cache);}).bind("applyWidgetId",function(e,id){getWidgetById(id).format(this);}).bind("applyWidgets",function(){applyWidget(this);});if($.metadata&&($(this).metadata()&&$(this).metadata().sortlist)){config.sortList=$(this).metadata().sortlist;}if(config.sortList.length>0){$this.trigger("sorton",[config.sortList]);}applyWidget(this);});};this.addParser=function(parser){var l=parsers.length,a=true;for(var i=0;i<l;i++){if(parsers[i].id.toLowerCase()==parser.id.toLowerCase()){a=false;}}if(a){parsers.push(parser);};};this.addWidget=function(widget){widgets.push(widget);};this.formatFloat=function(s){var i=parseFloat(s);return(isNaN(i))?0:i;};this.formatInt=function(s){var i=parseInt(s);return(isNaN(i))?0:i;};this.isDigit=function(s,config){var DECIMAL='\\'+config.decimal;var exp='/(^[+]?0('+DECIMAL+'0+)?$)|(^([-+]?[1-9][0-9]*)$)|(^([-+]?((0?|[1-9][0-9]*)'+DECIMAL+'(0*[1-9][0-9]*)))$)|(^[-+]?[1-9]+[0-9]*'+DECIMAL+'0+$)/';return RegExp(exp).test($.trim(s));};this.clearTableBody=function(table){if($.browser.msie){function empty(){while(this.firstChild)this.removeChild(this.firstChild);}empty.apply(table.tBodies[0]);}else{table.tBodies[0].innerHTML="";}};}});$.fn.extend({tablesorter:$.tablesorter.construct});var ts=$.tablesorter;ts.addParser({id:"text",is:function(s){return true;},format:function(s){return $.trim(s.toLowerCase());},type:"text"});ts.addParser({id:"digit",is:function(s,table){var c=table.config;return $.tablesorter.isDigit(s,c);},format:function(s){return $.tablesorter.formatFloat(s);},type:"numeric"});ts.addParser({id:"currency",is:function(s){return/^[$€?.]/.test(s);},format:function(s){return $.tablesorter.formatFloat(s.replace(new RegExp(/[^0-9.]/g),""));},type:"numeric"});ts.addParser({id:"ipAddress",is:function(s){return/^\d{2,3}[\.]\d{2,3}[\.]\d{2,3}[\.]\d{2,3}$/.test(s);},format:function(s){var a=s.split("."),r="",l=a.length;for(var i=0;i<l;i++){var item=a[i];if(item.length==2){r+="0"+item;}else{r+=item;}}return $.tablesorter.formatFloat(r);},type:"numeric"});ts.addParser({id:"url",is:function(s){return/^(https?|ftp|file):\/\/$/.test(s);},format:function(s){return jQuery.trim(s.replace(new RegExp(/(https?|ftp|file):\/\//),''));},type:"text"});ts.addParser({id:"isoDate",is:function(s){return/^\d{4}[\/-]\d{1,2}[\/-]\d{1,2}$/.test(s);},format:function(s){return $.tablesorter.formatFloat((s!="")?new Date(s.replace(new RegExp(/-/g),"/")).getTime():"0");},type:"numeric"});ts.addParser({id:"percent",is:function(s){return/\%$/.test($.trim(s));},format:function(s){return $.tablesorter.formatFloat(s.replace(new RegExp(/%/g),""));},type:"numeric"});ts.addParser({id:"usLongDate",is:function(s){return s.match(new RegExp(/^[A-Za-z]{3,10}\.? [0-9]{1,2}, ([0-9]{4}|'?[0-9]{2}) (([0-2]?[0-9]:[0-5][0-9])|([0-1]?[0-9]:[0-5][0-9]\s(AM|PM)))$/));},format:function(s){return $.tablesorter.formatFloat(new Date(s).getTime());},type:"numeric"});ts.addParser({id:"shortDate",is:function(s){return/\d{1,2}[\/\-]\d{1,2}[\/\-]\d{2,4}/.test(s);},format:function(s,table){var c=table.config;s=s.replace(/\-/g,"/");if(c.dateFormat=="us"){s=s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{4})/,"$3/$1/$2");}else if(c.dateFormat=="uk"){s=s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{4})/,"$3/$2/$1");}else if(c.dateFormat=="dd/mm/yy"||c.dateFormat=="dd-mm-yy"){s=s.replace(/(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{2})/,"$1/$2/$3");}return $.tablesorter.formatFloat(new Date(s).getTime());},type:"numeric"});ts.addParser({id:"time",is:function(s){return/^(([0-2]?[0-9]:[0-5][0-9])|([0-1]?[0-9]:[0-5][0-9]\s(am|pm)))$/.test(s);},format:function(s){return $.tablesorter.formatFloat(new Date("2000/01/01 "+s).getTime());},type:"numeric"});ts.addParser({id:"metadata",is:function(s){return false;},format:function(s,table,cell){var c=table.config,p=(!c.parserMetadataName)?'sortValue':c.parserMetadataName;return $(cell).metadata()[p];},type:"numeric"});ts.addWidget({id:"zebra",format:function(table){if(table.config.debug){var time=new Date();}$("tr:visible",table.tBodies[0]).filter(':even').removeClass(table.config.widgetZebra.css[1]).addClass(table.config.widgetZebra.css[0]).end().filter(':odd').removeClass(table.config.widgetZebra.css[0]).addClass(table.config.widgetZebra.css[1]);if(table.config.debug){$.tablesorter.benchmark("Applying Zebra widget",time);}}});})(jQuery);
Thanks!
Nov 17 '09 #1
Share this Question
Share on Google+
5 Replies


Frinavale
Expert Mod 5K+
P: 9,731
Hi jrod11,

I moved your question to the JavaScript forum.
I don't think that the Java experts will be able to help you with your JQuery question.

-Frinny
Nov 17 '09 #2

P: 49
Oops, i meant to select javascript.

You are helping me all over the place today! Thanks!
Nov 17 '09 #3

Frinavale
Expert Mod 5K+
P: 9,731
You know it's really hard to read through that amount of code.

Have you considered making it easier for the experts by posting only the functions that you think are relevant to the question?

Aside from that, I was just wondering if you are using ASP.NET MVC...because if you are then my earlier suggestion for your other problem is completely wrong!

-Frinny

(still wading through the massive amount of code)
Nov 17 '09 #4

P: 49
I'm really not familiar at all with javascript or jquery, so I'm not really sure what parts I should remove or keep in my post. :(

It currently is not asp.net, but It could be if necessary.
Nov 17 '09 #5

Frinavale
Expert Mod 5K+
P: 9,731
I'm not that framiliar with JQuery either.

I know that Microsoft now includes it with their new ASP.NET MVC Framework which is really nice because their Ajax Framework is pretty nasty (from what I hear JQuery's much cleaner and easier to use...we'll see!)

If you want to stick with something similar for both of your projects then I think you should take a look into the ASP.NET MVC Framework. It's pretty new but I have to say that I am a big fan of it even though I haven't been given an opportunity to really give it a go (just played with it to see what it is all about).
Instead of looking up a GridView check out MVC :)

What type of project were you using if not ASP.NET for your web application???

With regards to this question... I think that I would look at the code generating the JSON Object being used to create the table, and just not include those 2 columns.
Nov 17 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.