1. Registered User
Join Date
Apr 2012
Posts
19

## [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(" ");

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!

2. Registered User+
Join Date
Feb 2006
Posts
2,930
Where does str come from in your code, and why are you splitting it on a space instead of 'x' or ' x '?
Last edited by mrhoo; 04-30-2013 at 03:58 PM. Reason: it

3. Registered User
Join Date
Apr 2012
Posts
19
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;
}

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

"

"

## X vBulletin 4.2.2 Debug Information

• Page Generation 0.12288 seconds
• Memory Usage 2,845KB
• Queries Executed 13 (?)
Template Usage (33):
• (2)bbcode_code
• (1)footer
• (1)forumjump
• (1)forumrules
• (1)gobutton
• (3)memberaction_dropdown
• (1)navbar
• (1)navbar_moderation
• (1)navbar_noticebit
• (1)navbar_tabs
• (2)option
• (3)postbit
• (3)postbit_onlinestatus
• (3)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (26):
• ./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/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/functions_notice.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php

Hooks Called (70):
• init_startup
• friendlyurl_resolve_class
• 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
• strip_bbcode
• friendlyurl_clean_fragment
• friendlyurl_geturl
• forumjump
• cache_templates
• cache_templates_process
• template_register_var
• template_render_output
• fetch_template_start
• fetch_template_complete
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete
• forumrules
• navbits
• navbits_complete