MainGrids.js

var options = {
    enableCellNavigation: true,
    enableColumnReorder: true,
    multiColumnSort: true,
    autoHeight: true,
};

var gridHC;
var columnsHC = [
    { id: "playerName", name: "Player", field: "playerName", sortable: true },
    { id: "AAnum", name: "# AA", field: "AAnum", sortable: true, minWidth: 42 },
    { id: "AAamount", name: "AA amount", field: "AAamount", sortable: true, minWidth: 42, toolTip: "amount won or lost with AA hole cards" },
    { id: "AAhandfreq", name: "AA freq", field: "AAhandfreq", sortable: true, minWidth: 42, toolTip: "frequency per hand AA is in hole cards" },
    { id: "AAnumCracked", name: "# AA cracked", field: "AAnumCracked", sortable: true, minWidth: 42, toolTip: "number of times pocket AA cracked" },
    { id: "AAamountLost", name: "AA lost", field: "AAamountLost", sortable: true, minWidth: 42, toolTip: "amount lost with cracked AA" },
    { id: "KKnum", name: "# KK", field: "KKnum", sortable: true, minWidth: 42 },
    { id: "KKamount", name: "KK amount", field: "KKamount", sortable: true, minWidth: 42, toolTip: "amount won or lost with KK hole cards" },
    { id: "KKhandfreq", name: "KK freq", field: "KKhandfreq", sortable: true, minWidth: 42, toolTip: "frequency per hand KK is in hole cards" },
    { id: "AKnum", name: "# AK", field: "AKnum", sortable: true, minWidth: 42 },
    { id: "AKamount", name: "AK amount", field: "AKamount", sortable: true, minWidth: 42, toolTip: "amount won or lost with AK hole cards" },
    { id: "AKhandfreq", name: "AK freq", field: "AKhandfreq", sortable: true, minWidth: 42, toolTip: "frequency per hand AK is in hole cards" },
    { id: "TSnum", name: "# 27", field: "TSnum", sortable: true, minWidth: 42 },
    { id: "TSamount", name: "27 amount", field: "TSamount", sortable: true, minWidth: 42, toolTip: "amount won or lost with 27 hole cards" },
    { id: "TShandfreq", name: "27 freq", field: "TShandfreq", sortable: true, minWidth: 42, toolTip: "frequency per hand 27 is in hole cards" },
];

gridHC = new Slick.Grid("#myGridHC", bigholecards, columnsHC, options);


gridHC.onSort.subscribe(function (e, args) {
    var cols = args.sortCols;

    bigholecards.sort(function (dataRow1, dataRow2) {
        for (var i = 0, l = cols.length; i < l; i++) {
            var field = cols[i].sortCol.field;
            var sign = cols[i].sortAsc ? 1 : -1;
            var value1 = dataRow1[field], value2 = dataRow2[field];
            var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
            if (result != 0) {
                return result;
            }
        }
        return 0;
    });

    gridHC.invalidate();
    gridHC.render();
});






var gridNH;
var columnsNH = [
    { id: "player", name: "Player", field: "player", sortable: true, minWidth: 50 },
    { id: "nemesisName", name: "Nemesis", field: "nemesisName", sortable: true, minWidth: 50 },
    { id: "nemesisAmount", name: "Amount", field: "nemesisAmount", sortable: true, minWidth: 42 },
    { id: "heroName", name: "Hero", field: "heroName", sortable: true, minWidth: 50 },
    { id: "heroAmount", name: "Amount", field: "heroAmount", sortable: true, minWidth: 42 },
];

gridNH = new Slick.Grid("#myGridNH", nhList, columnsNH, options);


gridNH.onSort.subscribe(function (e, args) {
    var cols = args.sortCols;

    nhList.sort(function (dataRow1, dataRow2) {
        for (var i = 0, l = cols.length; i < l; i++) {
            var field = cols[i].sortCol.field;
            var sign = cols[i].sortAsc ? 1 : -1;
            var value1 = dataRow1[field], value2 = dataRow2[field];
            var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
            if (result != 0) {
                return result;
            }
        }
        return 0;
    });

    gridNH.invalidate();
    gridNH.render();
});


var gridPla;
var columnsPla = [
  {id: "player", name: "Player", field: "player", sortable: true, formatter: htmlFormatter, minWidth:50},
  {id: "wonLost", name: "Won or Lost", field: "wonLost", sortable: true, formatter: wonLostFormatter, minWidth:42},
  {id: "numHands", name: "# Hands", field: "numHands", sortable: true, minWidth:42},
  {id: "numWins", name: "# Wins", field: "numWins", sortable: true, minWidth:42},
  {id: "pctUncalledWins", name: "% Uncalled Wins", field: "pctUncalledWins", sortable: true, minWidth:42},
  {id: "showedHoleCards", name: "SHC for UW", field: "showedHoleCards", sortable: true, toolTip: "% of showed hole cards for uncalled pot", minWidth:42},
  {id: "VPIP", name: "VPIP", field: "VPIP", sortable: true, toolTip: "% of calls and raises preflop", minWidth:42},
  {id: "PFR", name: "PFR", field: "PFR", sortable: true, toolTip: "% of raises preflop", minWidth:42},
  {id: "VPIPPFR", name: "PFR/VPIP", field: "VPIPPFR", sortable: true, toolTip: "", minWidth:42},
  { id: "AggFact", name: "Agg%", field: "AggFact", sortable: true, toolTip: "Postflop - ((Bets + All Raises) / (Bets + All Raises + Calls + Checks - CheckRaises))", minWidth: 42 },
  { id: "numFoldedWH", name: "# Daves", field: "numFoldedWH", sortable: true, toolTip: "Hand you folded preflop that would of won minimum of $5", minWidth: 42 },
  { id: "volFromAvg", name: "Volatility", field: "volFromAvg", sortable: true, toolTip: "% of player StdDev from Avg", minWidth: 42 },
  {id: "time", name: "Time (ms)", field: "time", sortable: true, toolTip: "time (ms) on average to take an action", minWidth: 42 },
  { id: "minPlayed", name: "Minutes Played", field: "minPlayed", sortable: true, toolTip: "total minutes played", minWidth: 60 },
  { id: "firstHand", name: "First Hand (EST)", field: "firstHand", sortable: true, toolTip: "time first hand was played", minWidth: 120 },
  { id: "lastHand", name: "Last Hand (EST)", field: "lastHand", sortable: true, toolTip: "time last hand was played", minWidth: 120 },
  
];

gridPla = new Slick.Grid("#myGridPla", dataPla, columnsPla, options);

  
gridPla.onSort.subscribe(function (e, args) {
  var cols = args.sortCols;

  dataPla.sort(function (dataRow1, dataRow2) {
    for (var i = 0, l = cols.length; i < l; i++) {
      var field = cols[i].sortCol.field;
      var sign = cols[i].sortAsc ? 1 : -1;
      var value1 = dataRow1[field], value2 = dataRow2[field];
      var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
      if (result != 0) {
        return result;
      }
    }
    return 0;
  });
  
  gridPla.invalidate();
  gridPla.render();
});


var gridTab;
var columnsTab = [
  {id: "table", name: "Table", field: "table", sortable: true, formatter: addLinkToTable, minWidth:50},
  {id: "player", name: "Player", field: "player", sortable: true, formatter: addLinkToPlayer, minWidth:50},
  {id: "wonLost", name: "Won or Lost", field: "wonLost", sortable: true, formatter: wonLostFormatter, minWidth:42},
  {id: "numHands", name: "# Hands", field: "numHands", sortable: true, minWidth:42},
  {id: "numWins", name: "# Wins", field: "numWins", sortable: true, minWidth:42},
  {id: "pctUncalledWins", name: "% Uncalled Wins", field: "pctUncalledWins", sortable: true, minWidth:42},
  { id: "consecutiveHandsWOWin", name: "W/O Win", toolTip: "# Hands with out Win", field: "consecutiveHandsWOWin", sortable: true, minWidth: 42 },
  {id: "biggestWin", name: "Biggest Win", field: "biggestWin", sortable: true, formatter: addLinkToBiggestWinHand, minWidth:42},
  {id: "biggestLoss", name: "Biggest Loss", field: "biggestLoss", sortable: true, formatter: addLinkToBiggestLossHand, minWidth:42},
  {id: "showedHoleCards", name: "SHC for UW", field: "showedHoleCards", sortable: true, toolTip: "% of showed hole cards for uncalled pot", minWidth:42},
  {id: "VPIP", name: "VPIP", field: "VPIP", sortable: true, toolTip: "% of calls and raises preflop", minWidth:42},
  {id: "PFR", name: "PFR", field: "PFR", sortable: true, toolTip: "% of raises preflop", minWidth:42},
  {id: "VPIPPFR", name: "PFR/VPIP", field: "VPIPPFR", sortable: true, toolTip: "", minWidth:42},
  { id: "AggFact", name: "Agg%", field: "AggFact", sortable: true, toolTip: "Postflop - ((Bets + All Raises) / (Bets + All Raises + Calls + Checks - CheckRaises))", minWidth: 42 },
  { id: "numFoldedWH", name: "# Daves", field: "numFoldedWH", sortable: true, toolTip: "Hand you folded preflop that would of won minimum of $5", minWidth: 42 },
  { id: "biggestLosingHand", name: "Biggest Losing Hand", field: "biggestLosingHand", sortable: false, toolTip: "Must use both hole cards",formatter: addLinkToBiggestLosingHand, minWidth: 120 },
  
];


  gridTab = new Slick.Grid("#myGridTab", dataTab, columnsTab, options);
  
  gridTab.onSort.subscribe(function (e, args) {
    var cols = args.sortCols;

    dataTab.sort(function (dataRow1, dataRow2) {
      for (var i = 0, l = cols.length; i < l; i++) {
        var field = cols[i].sortCol.field;
        var sign = cols[i].sortAsc ? 1 : -1;
        var value1 = dataRow1[field], value2 = dataRow2[field];
        var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
        if (result != 0) {
          return result;
        }
      }
      return 0;
    });
    gridTab.invalidate();
    gridTab.render();
  });


//

  var gridStreak;
  var columnsStreak = [
      { id: "name", name: "Player", field: "name", sortable: true, minWidth: 50 },
      { id: "tableName", name: "Table", field: "tableName", sortable: true, minWidth: 50 },
      { id: "handTotal", name: "LMF Score", field: "handTotal", toolTip: "LMF score for streak", sortable: true, formatter: addLinkToStartStreak, width: 82 },
      { id: "amountWon", name: "LMF Won", field: "amountWon", toolTip: "Total money for won any hands won", sortable: true, width: 82 },
      { id: "totalWonLost", name: "Amt Won/Lost", field: "totalWonLost", toolTip: "Total money/lost during streak", sortable: true, width: 82 },
      { id: "numHandsWon", name: "# Won", field: "numHandsWon", toolTip: "# Hands won during streak", sortable: true, width: 82 },
      { id: "numShowedHC", name: "# HC Showed", field: "numShowedHC", toolTip: "# Hands won where hole cards were shown", sortable: true, width: 82 },
      { id: "luckestHandPoints", name: "Best LMF Hand", field: "luckestHandPoints", toolTip: "Hand with highest LMF score", sortable: true, formatter: addLinkToLuckestHand, width: 82 },

  ];


  gridStreak = new Slick.Grid("#myStreak", streakList, columnsStreak, options);

  gridStreak.onSort.subscribe(function (e, args) {
      var cols = args.sortCols;

      streakList.sort(function (dataRow1, dataRow2) {
          for (var i = 0, l = cols.length; i < l; i++) {
              var field = cols[i].sortCol.field;
              var sign = cols[i].sortAsc ? 1 : -1;
              var value1 = dataRow1[field], value2 = dataRow2[field];
              var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
              if (result != 0) {
                  return result;
              }
          }
          return 0;
      });
      gridStreak.invalidate();
      gridStreak.render();
  });

//
function addLinkToLuckestHand(row, cell, value, columnDef, dataContext) {
    var rtn = "<a href='" + dataContext.tableName + "-Details.html?hand=" + dataContext.luckestHandNumber + "'>" + dataContext.luckestHandPoints + "</a>";
    return rtn;
  }

function addLinkToStartStreak(row, cell, value, columnDef, dataContext) {
    var rtn = "<a href='" + dataContext.tableName + "-Details.html?hand=" + dataContext.startHandNum + "'>" + dataContext.handTotal + " (# " + dataContext.startHandNum + ")" + "</a>";
    return rtn;
}

function addLinkToBiggestLossHand (row, cell, value, columnDef, dataContext) { 
   var rtn = "<a href='" + dataContext.table + "-Details.html?hand=" + dataContext.biggestLossHand + "'>" + dataContext.biggestLoss + "</a>";
   return rtn;
}

function addLinkToTable (row, cell, value, columnDef, dataContext) { 
    var rtn = "<a href='" + dataContext.table + "-Details.html'>" + value + "</a>";
    return rtn;
}

function addLinkToBB(row, cell, value, columnDef, dataContext) {
    var rtn = "<a href='" + dataContext.link + "'>" + value + "</a>";
    return rtn;
}

function addLinkToBiggestWinHand (row, cell, value, columnDef, dataContext) { 
   var rtn = "<a href='" + dataContext.table + "-Details.html?hand=" + dataContext.biggestWinHand + "'>" + dataContext.biggestWin + "</a>";
   return rtn;
}

function addLinkToBiggestLosingHand(row, cell, value, columnDef, dataContext) {
    var rtn = "<a href='" + dataContext.table + "-Details.html?hand=" + dataContext.biggestLosingHandNum + "'>" + dataContext.biggestLosingHand + "</a>";
    return rtn;
}

function addLinkToPlayer (row, cell, value, columnDef, dataContext) { 
    var rtn = "<a href='" + dataContext.player + "-" + dataContext.table + "-Details.html'>" + dataContext.player + "</a>";
    return rtn;
 }
 
function wonLostFormatter(row, cell, value, columnDef, dataContext) {
    var rtn = { text: value, removeClasses: 'cellGood cellBad' };
    if (value !== null || value !== "") {
      if (value < 0) {
        rtn.addClasses = "cellBad";
      } else {
        rtn.addClasses =  "cellGood";
      }
    }
    return rtn;
}	

function htmlFormatter (row, cell, value, columnDef, dataContext) { 
  if (value == null) return ''; 

   return value.toString(); 
}   

// start of ff
function CreateAddlHeaderRow() {
    var $preHeaderPanel = $(gridFF.getPreHeaderPanel())
        .empty()
        .addClass("slick-header-columns")
        .css('left', '-1000px')
        .width(gridFF.getHeadersWidth());
    $preHeaderPanel.parent().addClass("slick-header");

    var headerColumnWidthDiff = gridFF.getHeaderColumnWidthDiff();
    var m, header, lastColumnGroup = '', widthTotal = 0;

    for (var i = 0; i < columnsFF.length; i++) {
        m = columnsFF[i];
        if (lastColumnGroup === m.columnGroup && i > 0) {
            widthTotal += m.width;
            header.width(widthTotal - headerColumnWidthDiff)
        } else {
            widthTotal = m.width;
            header = $("<div class='ui-state-default slick-header-column' />")
                .html("<span class='slick-column-name'>" + (m.columnGroup || '') + "</span>")
                .width(m.width - headerColumnWidthDiff)
                .appendTo($preHeaderPanel);
        }
        lastColumnGroup = m.columnGroup;
    }
}

var gridFF;
var optionsFF = {
    enableCellNavigation: true,
    enableColumnReorder: false,
    createPreHeaderPanel: true,
    showPreHeaderPanel: true,
    preHeaderPanelHeight: 23,
    explicitInitialization: true,
    autoHeight: true,
    multiColumnSort: true,
};


var columnsFF = [
    { id: "name", name: "Name", field: "name", sortable: true, minWidth: 50 },
    { id: "preflopPercentSeen", name: "% seen", field: "preflopPercentSeen", sortable: true, width: 65, columnGroup: "Preflop" },
    { id: "preflopPercentFolded", name: "% folded", field: "preflopPercentFolded", sortable: true, width: 65, columnGroup: "Preflop" },
    { id: "preflopPercentWon", name: "% won", field: "preflopPercentWon", sortable: true, width: 65, columnGroup: "Preflop" },
    { id: "preflopAmountWonPerHand", name: "BB amt", field: "preflopAmountWonPerHand", sortable: true, width: 65, columnGroup: "Preflop" },

    { id: "flopPercentSeen", name: "% seen", field: "flopPercentSeen", sortable: true, width: 65, columnGroup: "Flop" },
    { id: "flopPercentFolded", name: "% folded", field: "flopPercentFolded", sortable: true, width: 65, columnGroup: "Flop" },
    { id: "flopPercentWon", name: "% won", field: "flopPercentWon", sortable: true, width: 65, columnGroup: "Flop" },
    { id: "flopAmountWonPerHand", name: "BB amt", field: "flopAmountWonPerHand", sortable: true, width: 65, columnGroup: "Flop" },

    { id: "turnPercentSeen", name: "% seen", field: "turnPercentSeen", sortable: true, width: 65, columnGroup: "Turn" },
    { id: "turnPercentFolded", name: "% folded", field: "turnPercentFolded", sortable: true, width: 65, columnGroup: "Turn" },
    { id: "turnPercentWon", name: "% won", field: "turnPercentWon", sortable: true, width: 65, columnGroup: "Turn" },
    { id: "turnAmountWonPerHand", name: "BB amt", field: "turnAmountWonPerHand", sortable: true, width: 65, columnGroup: "Turn" },

    { id: "riverPercentSeen", name: "% seen", field: "riverPercentSeen", sortable: true, width: 65, columnGroup: "River" },
    { id: "riverPercentFolded", name: "% folded", field: "riverPercentFolded", sortable: true, width: 65, columnGroup: "River" },
    { id: "riverPercentWon", name: "% won", field: "riverPercentWon", sortable: true, width: 65, columnGroup: "River" },
    { id: "riverAmountWonPerHand", name: "BB amt", field: "riverAmountWonPerHand", sortable: true, width: 65, columnGroup: "River" },
];

$(function () {
    gridFF = new Slick.Grid("#myGridFF", ffList, columnsFF, optionsFF);


    // start sort
    gridFF.onSort.subscribe(function (e, args) {
        var cols = args.sortCols;

        ffList.sort(function (dataRow1, dataRow2) {
            for (var i = 0, l = cols.length; i < l; i++) {
                var field = cols[i].sortCol.field;
                var sign = cols[i].sortAsc ? 1 : -1;
                var value1 = dataRow1[field], value2 = dataRow2[field];
                var result = (value1 == value2 ? 0 : (value1 > value2 ? 1 : -1)) * sign;
                if (result != 0) {
                    return result;
                }
            }
            return 0;
        });

        gridFF.invalidate();
        gridFF.render();
    });

    // end of sort

    gridFF.init();

    gridFF.onColumnsResized.subscribe(function (e, args) {
        CreateAddlHeaderRow();
    });

    CreateAddlHeaderRow();

    gridFF.invalidate();
    gridFF.render();
    // end of with out dataView

})
// end of ff