<div id="my-table"></div>
<!-- include -->
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script src="https://rawgit.com/tweeeety/tableMagic/master/js/jquery.tablemagic.js"></script>
<!-- main -->
<script>
$(function(){
// title行の順番を指定
var titleOrderArr = ['totaled_date', 'entry', 'dau','invite','mau','sales','sales_dau','sales_mau','sales_uu'];
// title行の文字列を指定
var titleHash = {
dau: 'dau',
entry: '登録者',
invite: '招待者',
mau: 'mau',
sales: '売上',
sales_dau: '売上day',
sales_mau: '売上mau',
sales_uu: '売上uu',
totaled_date: "日付"
};
// オプション指定
// renderNameとlabelを指定
var opt = {
titleOrderArr : titleOrderArr,
titleHash : titleHash,
renderName : "normal",
addThead : true,
trHeaderClassName : "trHeader",
tdHeaderClassName : "tdHeader",
firstRowTd2Th : true,
firstColTd2Th : true,
};
if( opt && !opt.callback ) opt.callback = function() { lineMarker($(".my-table"), opt) };
$("#my-table").tableMagic(sampleData, opt);
});
</script>
<!-- callback -->
<script>
var lineMarker = function(tableContent, opt){
var rowMarkerClass = 'cellRow';
var colMarkerClass = 'cellCol';
// mark row
tableContent.find("."+opt.tdHeaderClassName).each(function(){
$(this).on("click", function(){
$(this).toggleClass(rowMarkerClass);
$(this).parent("tr").find("td").toggleClass(rowMarkerClass);
});
});
// mark col
var tdOrTh = opt.firstRowTd2Th ? 'th' : 'td';
tableContent.find("."+opt.trHeaderClassName).find(tdOrTh).each(function(){
$(this).on("click", function(){
var index = $(this).parent("tr").find(tdOrTh).index(this);
var trElements;
if(opt.addThead){
trElements = $(this).parent("tr").parent("thead").parent('table').find('tr');
}else{
trElements = $(this).parent("tr").parent('table').find('tr');
}
trElements.each(function(){
$(this).children().eq(index).toggleClass(colMarkerClass);
});
});
});
};
</script>
<!-- sample data -->
<script>
var sampleData = [
{"totaled_date":"2014-01-16","entry":"2","invite":"0","sales":"65422","sales_dau":3,"sales_mau":33,"sales_uu":0,"mau":37,"dau":14},
{"totaled_date":"2014-01-17","entry":"2","invite":"0","sales":"2039","sales_dau":2,"sales_mau":33,"sales_uu":1,"mau":37,"dau":14},
{"totaled_date":"2014-01-24","entry":"3","invite":"0","sales":"348120","sales_dau":8,"sales_mau":37,"sales_uu":0,"mau":43,"dau":0},
{"totaled_date":"2014-01-25","entry":"1","invite":"0","sales":"14570","sales_dau":4,"sales_mau":39,"sales_uu":1,"mau":45,"dau":0},
{"totaled_date":"2014-01-26","entry":"4","invite":"0","sales":"14600","sales_dau":1,"sales_mau":39,"sales_uu":0,"mau":45,"dau":0}
];
</script>
table.my-table .cellRow {
background-color: #ff0000;
}
table.my-table .cellCol {
background-color: #ff0000;
}