These demos provide examples of the script's date and numeric data support.
In this example, 3 date types are used and numeric data for currency columns
is formated differently:
var totRowIndex = tf_Tag(tf_Id('demo'),"tr").length;
var props = {
sort: true,
sort_config: { sort_col: [3,false] },
filters_row_index: 1,
alternate_rows: true,
rows_counter: true,
rows_counter_text: "Displayed rows: ",
btn_reset: true,
btn_reset_text: "Clear",
loader: true,
loader_html: '
',
loader_css_class: 'myLoader',
status_bar: true,
status_bar_target_id: 'lblStatus',
col_number_format: [null,null,null,'EU','US',null,null,null,null,'IpAddress'],
col_date_type: [null,null,null,null,null,null,'dmy','mdy','ddmmmyyyy',null],
rows_always_visible:[totRowIndex],
col_operation: {
id: ["sum1","sum2"],
col: [3,4],
operation: ["sum","sum"],
write_method: ["innerhtml",'innerhtml'],
exclude_row: [totRowIndex],
decimal_precision: [2,2],
tot_row_index: [totRowIndex]
},
on_after_operation: formatTotals,
on_filters_loaded: function(o){
o.SetFilterValue(3,'>1.000');
o.SetFilterValue(4,'<2,500');
o.SetFilterValue(6,'>23-01-95');
o.Filter();
}
}
var tf = setFilterGrid("demo",props);
| Email |
Id |
Phone |
€ |
US $ |
Url |
EU Date |
US Date |
DD-MMM-YYYY Date |
IP |
| Tot |
|
|
|
|
|
|
|
|
|
| devo@flexomat.com |
66672 |
941-964-8535 |
2.482,79 |
2,482.79 |
http://gmail.com |
14/12/1988 |
12/14/1988 |
14-Dec-1988 |
186.114.137.213 |
| henry@mountdev.net |
35889 |
941-964-9543 |
2.776,09 |
2,776.09 |
http://www.gmail.com |
19/1/1984 |
1/19/1984 |
19-Jan-1984 |
170.138.54.12 |
| christian@reno.gov |
60021 |
941-964-5617 |
2.743,41 |
2,743.41 |
http://www.dotnet.ca |
25/3/2000 |
3/25/2000 |
25-Mar-2000 |
219.115.156.141 |
| muffins@donuts.com |
17927 |
941-964-9511 |
2.998,18 |
2,998.18 |
http://google.se |
24/1/1993 |
1/24/1993 |
24-Jan-1993 |
252.253.244.189 |
| muffins@reno.gov |
76375 |
941-964-2757 |
1.836,09 |
1,836.09 |
http://www.samba.org |
4/4/1988 |
4/4/1988 |
4-Apr-1988 |
88.233.9.89 |
| mendez@gmail.com |
45834 |
941-964-2575 |
2.805,46 |
2,805.46 |
http://flexomat.com |
12/12/1985 |
12/12/1985 |
12-Dec-1985 |
88.233.9.89 |
| dev@gmail.com |
20022 |
941-964-4967 |
3.296,54 |
3,296.54 |
http://www.flexomat.com |
3/7/2002 |
7/3/2002 |
3-Jul-2002 |
219.115.156.145 |
| foo@polyester.se |
55987 |
941-964-745 |
2.953,73 |
2,953.73 |
http://www.donuts.com |
4/8/1987 |
8/4/1987 |
4-Aug-1987 |
88.233.9.87 |
| adam@aftonbladet.se |
38867 |
941-964-6302 |
1.949,27 |
1,949.27 |
http://flexomat.com |
27/7/1995 |
7/27/1995 |
27-Jul-1995 |
170.138.54.16 |
| devo@donuts.com |
51426 |
941-964-1234 |
1.067,00 |
1,067.00 |
http://www.polyester.se |
5/1/1986 |
1/5/1986 |
5-Jan-1986 |
252.253.244.186 |
| henry@samba.org |
40859 |
941-964-4856 |
3.401,19 |
3,401.19 |
http://www.flexomat.com |
7/3/1990 |
3/7/1990 |
7-Mar-1990 |
88.233.9.85 |
| found@dotnet.ca |
23986 |
941-964-2686 |
1.393,52 |
1,393.52 |
http://lostnfound.org |
22/7/1993 |
7/22/1993 |
22-Jul-1993 |
113.231.1.44 |
| carl@fish.org |
73392 |
941-964-5792 |
3.876,04 |
3,876.04 |
http://www.google.se |
14/7/1984 |
7/14/1984 |
14-Jul-1984 |
219.115.156.137 |
| found@mountdev.net |
03519 |
941-964-1599 |
1.176,48 |
1,176.48 |
http://donuts.com |
6/8/2000 |
8/6/2000 |
6-Aug-2000 |
88.233.9.86 |
| lost@fish.org |
36628 |
941-964-5985 |
822,23 |
822.23 |
http://www.gmail.com |
14/7/1994 |
7/14/1994 |
14-Jul-1994 |
252.253.244.184 |
| mendez@dotnet.ca |
90442 |
941-964-1649 |
1.985,72 |
1,975.72 |
http://reno.gov |
20/10/1997 |
10/20/1997 |
20-Oct-1997 |
113.231.1.79 |
| carl@donuts.com |
00412 |
941-964-6432 |
1.834,77 |
1,834.77 |
http://gmail.com |
23/8/1997 |
8/23/1997 |
23-Aug-1997 |
170.138.54.19 |
| foo@fish.org |
80653 |
941-964-1022 |
260,26 |
260.26 |
http://samba.org |
24/11/1991 |
11/24/1991 |
24-Nov-1991 |
88.233.9.89 |
| found@fish.org |
54635 |
941-964-6439 |
1.442,80 |
1,442.80 |
http://dotnet.ca |
12/7/1987 |
7/12/1987 |
12-Jul-1987 |
88.233.9.90 |
| found@flexomat.com |
20953 |
941-964-5544 |
575,42 |
575.42 |
http://gmail.com |
10/6/1988 |
6/10/1988 |
10-Jun-1988 |
88.233.19.89 |
Below an example of ISO date support (YMD). Use default_date_type
to set a date type for a whole table ('DMY','MDY','YMD').
var props2 = {
sort: true,
filters_row_index: 0,
alternate_rows: true,
rows_counter: true,
rows_counter_text: "Displayed rows: ",
btn_reset: true,
btn_reset_text: "Clear",
loader: true,
loader_html: '' +
'',
loader_css_class: 'myLoader',
status_bar: true,
status_bar_target_id: 'lblStatus2',
default_date_type: 'YMD',
on_filters_loaded: function(o){
o.SetFilterValue(5,'>95-05-18');
o.Filter();
}
}
var tf2 = setFilterGrid("demo2",props2);
| Email |
Id |
Phone |
Total |
Url |
ISO Date |
| found@mountdev.net |
03519 |
941-964-1599 |
$1176.48 |
http://donuts.com |
2000/8/6 |
| lost@fish.org |
36628 |
941-964-5975 |
$822.23 |
http://www.gmail.com |
1994/7/14 |
| mendez@dotnet.ca |
90442 |
941-964-1649 |
$1985.72 |
http://reno.gov |
1997/10/20 |
| carl@donuts.com |
00412 |
941-964-6432 |
$1834.77 |
http://gmail.com |
1998/8/23 |
| foo@fish.org |
80653 |
941-964-1022 |
$260.26 |
http://samba.org |
1991/11/24 |
| found@fish.org |
54635 |
941-964-6439 |
$1442.80 |
http://dotnet.ca |
1987/7/12 |
| found@flexomat.com |
20953 |
941-964-5544 |
$575.42 |
http://gmail.com |
1988/6/10 |
| lost@aftonbladet.se |
60810 |
941-964-8406 |
$1054.39 |
http://www.samba.org |
1988/5/18 |
| carl@reno.gov |
22666 |
941-964-104 |
$373.59 |
http://www.lostnfound.org |
1981/11/5 |
| carl@donuts.com |
82867 |
941-964-1031 |
$631.03 |
http://www.reno.gov |
1985/1/22 |
| foo@donuts.com |
11268 |
941-964-208 |
$3730.64 |
http://aftonbladet.se |
1989/8/4 |
| devo@google.se |
17059 |
941-964-2903 |
$1404.67 |
http://www.gmail.com |
1983/4/28 |
| muffins@flexomat.com |
90584 |
941-964-4640 |
$3706.01 |
http://www.fish.org |
1997/4/8 |
| foo@samba.org |
82966 |
941-964-7245 |
$1001.38 |
http://www.reno.gov |
1995/11/1 |
| foo@reno.gov |
03603 |
941-964-8942 |
$1677.07 |
http://www.flexomat.com |
1980/7/31 |
| found@flexomat.com |
84939 |
941-964-7004 |
$3916.83 |
http://www.fish.org |
1980/8/26 |
| henry@lostnfound.org |
76453 |
941-964-3084 |
$3875.88 |
http://www.fish.org |
2000/10/22 |
| sam@aftonbladet.se |
36274 |
941-964-7784 |
$73.43 |
http://www.dn.se |
1994/11/11 |
| dev@polyester.se |
15971 |
941-964-7527 |
$1855.18 |
http://www.flexomat.com |
1984/8/16 |
| devo@fish.org |
31734 |
941-964-9760 |
$3201.35 |
http://www.samba.org |
1989/3/4 |
| devo@reno.gov |
52074 |
941-964-2068 |
$3035.24 |
http://www.dn.se |
1998/2/24 |
| mendez@fish.org |
87800 |
941-964-7933 |
$618.59 |
http://www.dn.se |
1989/5/28 |
| muffins@reno.gov |
95926 |
941-964-147 |
$3897.91 |
http://www.flexomat.com |
2003/4/1 |
| carl@donuts.com |
74513 |
941-964-4507 |
$2150.68 |
http://www.fish.org |
1987/4/8 |
| sam@fish.org |
82420 |
941-964-2134 |
$3947.54 |
http://mountdev.net |
1990/11/26 |
| devo@mountdev.net |
81905 |
941-964-3535 |
$722.17 |
http://fish.org |
1985/12/28 |
| john@lostnfound.org |
93124 |
941-964-1508 |
$394.82 |
http://www.mountdev.net |
1989/12/10 |
| adam@google.se |
51938 |
941-964-5533 |
$3519.06 |
http://dotnet.ca |
1986/6/27 |
| carl@lostnfound.org |
51270 |
941-964-805 |
$2101.59 |
http://flexomat.com |
1987/10/25 |
| muffins@dotnet.ca |
44995 |
941-964-8299 |
$1708.57 |
http://fish.org |
1987/9/24 |
| adam@samba.org |
04065 |
941-964-8643 |
$1461.31 |
http://polyester.se |
1993/9/13 |
| carl@donuts.com |
01801 |
941-964-1839 |
$2434.33 |
http://www.google.se |
1987/7/8 |
| muffins@mountdev.net |
49570 |
941-964-877 |
$3273.22 |
http://polyester.se |
2000/4/23 |
| dev@google.se |
31947 |
941-964-3956 |
$1647.20 |
http://www.dn.se |
2006/9/25 |
| christian@fish.org |
05775 |
941-964-9882 |
$3203.96 |
http://flexomat.com |
1981/5/3 |
| henry@mountdev.net |
18946 |
941-964-5204 |
$3281.09 |
http://www.lostnfound.org |
1989/9/29 |
| carl@mountdev.net |
39096 |
941-964-5708 |
$1788.11 |
http://www.samba.org |
1983/2/7 |
| sam@dn.se |
45043 |
941-964-7175 |
$1254.08 |
http://google.se |
1981/3/30 |
| henry@dotnet.ca |
41456 |
941-964-4812 |
$1779.17 |
http://mountdev.net |
1980/9/11 |
| christian@polyester.se |
78584 |
941-964-6967 |
$3956.45 |
http://www.reno.gov |
1982/7/24 |
| muffins@flexomat.com |
56098 |
941-964-9399 |
$558.88 |
http://www.fish.org |
1981/3/1 |
| muffins@gmail.com |
92303 |
941-964-1958 |
$1094.38 |
http://www.fish.org |
1983/1/10 |
| christian@mountdev.net |
96564 |
941-964-3947 |
$3593.94 |
http://www.dn.se |
2004/11/26 |
| lost@polyester.se |
53352 |
941-964-7300 |
$1548.49 |
http://www.mountdev.net |
1989/7/22 |
| adam@flexomat.com |
17411 |
941-964-6808 |
$3744.57 |
http://www.lostnfound.org |
1998/4/17 |
| john@gmail.com |
55140 |
941-964-5592 |
$641.84 |
http://www.dn.se |
1989/12/15 |
| foo@google.se |
19355 |
941-964-5290 |
$3053.28 |
http://donuts.com |
1987/6/25 |
| dev@dn.se |
38729 |
941-964-1565 |
$1539.30 |
http://www.flexomat.com |
1989/3/13 |
| mendez@dn.se |
22531 |
941-964-4285 |
$18.39 |
http://google.se |
1996/8/19 |
| found@mountdev.net |
03979 |
941-964-3119 |
$2961.55 |
http://www.dotnet.ca |
2005/5/27 |
| foo@reno.gov |
59240 |
941-964-3593 |
$3039.37 |
http://www.lostnfound.org |
2005/8/27 |
| dev@polyester.se |
53160 |
941-964-8179 |
$468.97 |
http://www.samba.org |
1988/10/23 |
| christian@reno.gov |
96671 |
941-964-99 |
$994.56 |
http://gmail.com |
1984/4/22 |
| christian@gmail.com |
60247 |
941-964-341 |
$1358.07 |
http://www.donuts.com |
1987/11/20 |
| lost@dotnet.ca |
92437 |
941-964-6495 |
$3384.20 |
http://mountdev.net |
1982/10/14 |
| dev@flexomat.com |
08314 |
941-964-5549 |
$223.00 |
http://flexomat.com |
1985/12/6 |
| henry@lostnfound.org |
46306 |
941-964-8496 |
$3170.19 |
http://www.dotnet.ca |
1986/7/7 |
| foo@mountdev.net |
07328 |
941-964-3503 |
$2486.92 |
http://www.dn.se |
1999/7/24 |
| lost@flexomat.com |
66996 |
941-964-5705 |
$3333.71 |
http://www.aftonbladet.se |
1989/1/17 |
| henry@donuts.com |
83394 |
941-964-3776 |
$1808.67 |
http://dn.se |
1981/6/14 |
| muffins@fish.org |
76935 |
941-964-5150 |
$403.02 |
http://www.samba.org |
1986/7/13 |