# [RESOLVED] adding custom table sorting procedure

• 04-30-2013, 10:56 AM
cmartino
[RESOLVED] adding custom table sorting procedure
I have a javascript file that is used to sort my html table. All of the standard data types are being sorted correctly. For example, I have columns of numbers, alphanumeric characters, and dates that are all being sorted correctly.

One of my columns displays data that needs to be sorted a different way. Example cells look like:

3 X 4
2 X 5
1 X 3

Does the above data fit this regular expression? /[0-9]\s[A-Z]\s[0-9]/
Or, is there a better one that I should use to match the data type?

After I match the data type, I move to the sorting function. What I want to do is compare to cells, and swap them if necessary based on a condition. So, if I have the following two cells (a) and (b):

a = 3 X 4
b = 4 X 3

first what I do is multiply the first number by the second. So, the product of a is 12 and the product of b is 12. Usually, I would want to sort by product, but when the product is the same I want to sort by whichever cell has the greatest second number (a in this case).

Here is my sorting function:

Code:

```sort_lxc: function(a,b) {     var a_array = str.split(" ");     var b_array = str.split(" ");     alert("a_array = " + a_array);     alert("b_array = " + b_array);     var lxc_product1 = a_array[0] * a_array[2];     var lxc_product2 = b_array[0] * b_array[2];     if (lxc_product1 == lxc_product2) {         if (a_array[2] > b_array[2]) {             return -1;         }         if (a_array[2] < b_array[2]) {             return 1;         }         if (a_array[2] == b_array[2]) {             return 0;         }     }     if (lxc_product1 < lxc_product2) return -1;     return 1;   }```
The above function doesn't seem to work and I can't figure out why. I am fairly new to javascript so any help is appreciated. Thanks!
• 04-30-2013, 03:56 PM
mrhoo
Where does str come from in your code, and why are you splitting it on a space instead of 'x' or ' x '?
• 05-01-2013, 09:03 AM
cmartino
Woops! str is supposed to be a and b respectively, and I guess it would be better to split on " X " instead of just the space.

Per your inquiries, I changed my code to this and it worked! Thanks for spotting that!

Code:

```sort_lxc: function(a,b) {     var a_array = a.split(" X ");     var b_array = b.split(" X ");     var lxc_product1 = a_array[0] * a_array[2];     var lxc_product2 = b_array[0] * b_array[2];     if (lxc_product1 == lxc_product2) {         if (a_array[2] > b_array[2]) {             return -1;         }         if (a_array[2] < b_array[2]) {             return 1;         }         if (a_array[2] == b_array[2]) {             return 0;         }     }     if (lxc_product1 < lxc_product2) return -1;     return 1;   }```

## X vBulletin 4.2.2 Debug Information

• Page Generation 0.25402 seconds
• Memory Usage 2,355KB
• Queries Executed 11 (?)
Template Usage (20):
• (2)bbcode_code_printable
• (1)footer
• (1)gobutton
• (1)navbar_moderation
• (1)navbar_noticebit
• (2)option
• (1)spacer_close
• (1)spacer_open

Phrase Groups Available (3):
• global
• postbit
Included Files (19):
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/config.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./includes/functions_calendar.php
• ./includes/class_bbcode_alt.php
• ./includes/class_bbcode.php
• ./includes/functions_bigthree.php
• ./includes/functions_notice.php

Hooks Called (41):
• init_startup
• init_startup_session_setup_start
• database_pre_fetch_array
• database_post_fetch_array
• init_startup_session_setup_complete
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• bbcode_fetch_tags
• bbcode_create
• bbcode_parse_start
• cache_templates
• cache_templates_process
• template_register_var
• template_render_output
• fetch_template_start
• fetch_template_complete
• parse_templates