$(document).ready(function() { $.fn.dataTable.ext.order['sortMln'] = function ( settings, col ) { return this.api().column( col, {order:'index'} ).nodes().map( function ( td ) { return 1*$(td).text().replace(' Mio.', ''); } ); }; $.fn.dataTable.ext.order['sortCountryFlag'] = function ( settings, col ) { return this.api().column( col, {order:'index'} ).nodes().map( function ( td ) { return $('i', td).attr('title'); } ); }; $.fn.dataTable.ext.order['sortMostPopular'] = function ( settings, col ) { return this.api().column( col, {order:'index'} ).nodes().map( function ( td ) { return 1*$(td).text().substr(0,$(td).text().indexOf("x")-1); } ); }; }); var countries = {"215":{"id":"215","country":"Scotland","countryCode":"SF","countryTr":"Schottland"},"1":{"id":"1","country":"China","countryCode":"CN","countryTr":"China"},"214":{"id":"214","country":"England","countryCode":"EN","countryTr":"England"},"76":{"id":"76","country":"Belgium","countryCode":"BE","countryTr":"Belgien"},"216":{"id":"216","country":"Wales","countryCode":"WL","countryTr":"Wales"},"51":{"id":"51","country":"Australia","countryCode":"AU","countryTr":"Australien"},"118":{"id":"118","country":"Ireland","countryCode":"IE","countryTr":"Irland"},"217":{"id":"217","country":"Northern Ireland","countryCode":"NIE","countryTr":"Nordirland"},"98":{"id":"98","country":"Hong Kong","countryCode":"HK","countryTr":"Hongkong"},"20":{"id":"20","country":"Thailand","countryCode":"TH","countryTr":"Thailand"},"112":{"id":"112","country":"Finland","countryCode":"FI","countryTr":"Finnland"},"117":{"id":"117","country":"Norway","countryCode":"NO","countryTr":"Norwegen"},"94":{"id":"94","country":"Swiss","countryCode":"CH","countryTr":"Schweiz"},"18":{"id":"18","country":"Iran","countryCode":"IR","countryTr":"Iran"},"159":{"id":"159","country":"Cyprus","countryCode":"CY","countryTr":"Zypern"}}; var teams = [{"id":0,"name":""}]; var sportsmen = [{"id":"5540","tem":"0","ctr":"214","nam":"O'Sullivan, Ronnie ","namorig":"O'Sullivan, Ronnie ","cat":"","pri":"15 Mio.","rat":0,"mw":"M","link":"O'Sullivan, Ronnie <\/a>","confirmed_b":1},{"id":"5544","tem":"0","ctr":"51","nam":"Robertson, Neil ","namorig":"Robertson, Neil ","cat":"","pri":"12,2 Mio.","rat":0,"mw":"M","link":"Robertson, Neil <\/a>","confirmed_b":1},{"id":"5552","tem":"0","ctr":"214","nam":"Selby, Mark ","namorig":"Selby, Mark ","cat":"","pri":"10,6 Mio.","rat":0,"mw":"M","link":"Selby, Mark <\/a>","confirmed_b":1},{"id":"5524","tem":"0","ctr":"214","nam":"Bingham, Stuart ","namorig":"Bingham, Stuart ","cat":"","pri":"8,7 Mio.","rat":0,"mw":"M","link":"Bingham, Stuart <\/a>","confirmed_b":1},{"id":"5530","tem":"0","ctr":"214","nam":"Murphy, Shaun ","namorig":"Murphy, Shaun ","cat":"","pri":"8,1 Mio.","rat":0,"mw":"M","link":"Murphy, Shaun <\/a>","confirmed_b":1},{"id":"5536","tem":"0","ctr":"214","nam":"Trump, Judd ","namorig":"Trump, Judd ","cat":"","pri":"7,9 Mio.","rat":0,"mw":"M","link":"Trump, Judd <\/a>","confirmed_b":1},{"id":"5522","tem":"0","ctr":"215","nam":"Higgins, John ","namorig":"Higgins, John ","cat":"","pri":"6,8 Mio.","rat":0,"mw":"M","link":"Higgins, John <\/a>","confirmed_b":1},{"id":"5548","tem":"0","ctr":"217","nam":"Allen, Mark ","namorig":"Allen, Mark ","cat":"","pri":"6,5 Mio.","rat":0,"mw":"M","link":"Allen, Mark <\/a>","confirmed_b":1},{"id":"7297","tem":"0","ctr":"214","nam":"Walden, Ricky ","namorig":"Walden, Ricky ","cat":"","pri":"6,2 Mio.","rat":0,"mw":"M","link":"Walden, Ricky <\/a>","confirmed_b":1},{"id":"5553","tem":"0","ctr":"214","nam":"Hawkins, Barry ","namorig":"Hawkins, Barry ","cat":"","pri":"5,7 Mio.","rat":0,"mw":"M","link":"Hawkins, Barry <\/a>","confirmed_b":1},{"id":"5527","tem":"0","ctr":"214","nam":"Perry, Joe ","namorig":"Perry, Joe ","cat":"","pri":"5,4 Mio.","rat":0,"mw":"M","link":"Perry, Joe <\/a>","confirmed_b":1},{"id":"5538","tem":"0","ctr":"216","nam":"Williams, Mark ","namorig":"Williams, Mark ","cat":"","pri":"5,1 Mio.","rat":0,"mw":"M","link":"Williams, Mark <\/a>","confirmed_b":1},{"id":"5528","tem":"0","ctr":"215","nam":"Maguire, Stephen ","namorig":"Maguire, Stephen ","cat":"","pri":"5 Mio.","rat":0,"mw":"M","link":"Maguire, Stephen <\/a>","confirmed_b":1},{"id":"5542","tem":"0","ctr":"214","nam":"Gould, Martin ","namorig":"Gould, Martin ","cat":"","pri":"4,8 Mio.","rat":0,"mw":"M","link":"Gould, Martin <\/a>","confirmed_b":1},{"id":"5551","tem":"0","ctr":"98","nam":"Fu, Marco ","namorig":"Fu, Marco ","cat":"","pri":"4,6 Mio.","rat":0,"mw":"M","link":"Fu, Marco <\/a>","confirmed_b":1},{"id":"7309","tem":"0","ctr":"216","nam":"White, Michael ","namorig":"White, Michael ","cat":"","pri":"4,5 Mio.","rat":0,"mw":"M","link":"White, Michael <\/a>","confirmed_b":1},{"id":"5546","tem":"0","ctr":"1","nam":"Junhui, Ding ","namorig":"Junhui, Ding ","cat":"","pri":"4,2 Mio.","rat":0,"mw":"M","link":"Junhui, Ding <\/a>","confirmed_b":1},{"id":"5523","tem":"0","ctr":"1","nam":"Wenbo, Liang ","namorig":"Wenbo, Liang ","cat":"","pri":"3,8 Mio.","rat":0,"mw":"M","link":"Wenbo, Liang <\/a>","confirmed_b":1},{"id":"10415","tem":"0","ctr":"214","nam":"Wilson, Kyren ","namorig":"Wilson, Kyren ","cat":"","pri":"3,7 Mio.","rat":0,"mw":"M","link":"Wilson, Kyren <\/a>","confirmed_b":1},{"id":"5547","tem":"0","ctr":"216","nam":"Day, Ryan ","namorig":"Day, Ryan ","cat":"","pri":"3,4 Mio.","rat":0,"mw":"M","link":"Day, Ryan <\/a>","confirmed_b":1},{"id":"7299","tem":"0","ctr":"214","nam":"Milkins, Robert ","namorig":"Milkins, Robert ","cat":"","pri":"3,3 Mio.","rat":0,"mw":"M","link":"Milkins, Robert <\/a>","confirmed_b":1},{"id":"5543","tem":"0","ctr":"214","nam":"Gilbert, David ","namorig":"Gilbert, David ","cat":"","pri":"3,1 Mio.","rat":0,"mw":"M","link":"Gilbert, David <\/a>","confirmed_b":1},{"id":"5526","tem":"0","ctr":"215","nam":"Dott, Graeme ","namorig":"Dott, Graeme ","cat":"","pri":"2,8 Mio.","rat":0,"mw":"M","link":"Dott, Graeme <\/a>","confirmed_b":1},{"id":"5534","tem":"0","ctr":"214","nam":"Carter, Ali ","namorig":"Carter, Ali ","cat":"","pri":"2,6 Mio.","rat":0,"mw":"M","link":"Carter, Ali <\/a>","confirmed_b":1},{"id":"7304","tem":"0","ctr":"214","nam":"Holt, Michael ","namorig":"Holt, Michael ","cat":"","pri":"2,4 Mio.","rat":0,"mw":"M","link":"Holt, Michael <\/a>","confirmed_b":1},{"id":"7311","tem":"0","ctr":"215","nam":"McManus, Alan ","namorig":"McManus, Alan ","cat":"","pri":"2,4 Mio.","rat":0,"mw":"M","link":"McManus, Alan <\/a>","confirmed_b":1},{"id":"5541","tem":"0","ctr":"214","nam":"Ebdon, Peter ","namorig":"Ebdon, Peter ","cat":"","pri":"2,2 Mio.","rat":0,"mw":"M","link":"Ebdon, Peter <\/a>","confirmed_b":1},{"id":"12326","tem":"0","ctr":"215","nam":"McGill, Anthony ","namorig":"McGill, Anthony ","cat":"","pri":"2,2 Mio.","rat":0,"mw":"M","link":"McGill, Anthony <\/a>","confirmed_b":1},{"id":"10419","tem":"0","ctr":"214","nam":"Williams, Robbie ","namorig":"Williams, Robbie ","cat":"","pri":"2 Mio.","rat":0,"mw":"M","link":"Williams, Robbie <\/a>","confirmed_b":1},{"id":"7313","tem":"0","ctr":"214","nam":"Baird, Sam ","namorig":"Baird, Sam ","cat":"","pri":"1,9 Mio.","rat":0,"mw":"M","link":"Baird, Sam <\/a>","confirmed_b":1},{"id":"12334","tem":"0","ctr":"1","nam":"Anda, Zhang ","namorig":"Anda, Zhang ","cat":"","pri":"1,6 Mio.","rat":0,"mw":"M","link":"Anda, Zhang <\/a>","confirmed_b":1},{"id":"15796","tem":"0","ctr":"214","nam":"Mann, Mitchell ","namorig":"Mann, Mitchell ","cat":"","pri":"1,5 Mio.","rat":0,"mw":"M","link":"Mann, Mitchell <\/a>","confirmed_b":1}]; var sportsmenTeams = []; var showTeams = 0; //*********************** //SPORTSMEN TABLE HEADERS //*********************** var headersTableSportsmen = [ { 'sTitle': 'Nr.' }, { 'sTitle': 'Gruppe' , 'bSearchable': false, 'bVisible': false }, { 'sTitle': 'Land', 'sSortDataType': 'sortCountryFlag', sType : "text" }, { 'sTitle': 'Snookerspieler'}, { 'sTitle': 'Wert', 'sSortDataType': 'sortMln', 'sType': 'numeric' }, { 'sTitle': 'Team' , 'bSearchable': false, 'bVisible': false }, { 'sTitle': 'M/F' , 'bSearchable': false, 'bVisible': false } ]; //*********************** //TEAMS TABLE HEADERS //*********************** var headersTableTeams = [ {'sTitle': 'Nr.'}, {'sTitle': '' , 'bSearchable': false, 'bVisible': false }, {'sTitle': 'Land' , 'sSortDataType': 'sortCountryFlag', sType : 'text' }, { 'sTitle': ''}, { 'sTitle': 'Wert', 'sSortDataType': 'sortMln', 'sType': 'numeric' } ]; //*********************** //SPORTSMEN TABLE CONTENT //*********************** var contentTableSportsmen = []; $.each(sportsmen, function(k, v) { contentTableSportsmen.push([ k + 1, v['cat'], getFlag(v['ctr']), v['link'], v['pri'], isset(teams[v['tem']])? teams[v['tem']]['name']:'', v['mw'] ]); }); //*********************** //TEAMS TABLE CONTENT //*********************** var contentTableTeams = []; $.each(sportsmenTeams, function(k, v) { contentTableTeams.push([ k + 1, "", getFlag(v['ctr']), v['nam'], v['pri'] ]); }); function isset (va) { return typeof va != 'undefined'; } $(document).ready(function() { $.fn.dataTable.ext.order['sortMln'] = function (settings, col) { return this.api().column(col, {order: 'index'}).nodes().map(function (td) { return parseFloat($(td).text().replace(' Mio.', '').replace(',', '.')); } ); }; if (sportsmen.length) { var sportsmenTable = $('#tblSportsmen').dataTable( { "bPaginate": false, "bFilter": true, "bInfo": false, "bAutoWidth": true, "aoColumns" : headersTableSportsmen, "aaData": contentTableSportsmen, "bAutoWidth": false } ); } if (sportsmenTeams.length) { var sportsmenTeamsTable = $('#tblTeams').dataTable( { "bPaginate": false, "bFilter": true, "bInfo": false, "bAutoWidth": true, "aoColumns" : headersTableTeams, "aaData": contentTableTeams, "bAutoWidth": false } ); $('#teamsOverview').show(); } } ); function getFlag(id, margin) { if (!id || typeof countries[id] === "undefined" ) return ""; if (typeof margin == 'undefined') margin = true; return ""; }