<html>
<head>
<script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
<meta charset=utf-8 />
<title>DataTables - JS Bin</title>
</head>
<body>
<div class="container">
<table id="example" class="display nowrap" width="100%">
<thead>
<tr>
<th>Lead Record Flag</th>
<th>Multiple Record Flag</th>
<th>Button</th>
<th>Name</th>
<th>Active Ind</th>
<th>Office</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
<th>Show Other</th>
</tr>
</thead>
</table>
</div>
</body>
</html>
body {
font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
margin: 0;
padding: 0;
color: #333;
background-color: #fff;
}
$(document).ready( function () {
$.fn.dataTable.ext.search.push(
function(settings, data, dataIndex) {
return data[0] == 1 || data[9] == 1 ? true : false;
}
);
var table = $('#example').DataTable( {
"data": [[1,1,"Garrett Winters","Y","Edinburgh",61,"2011/04/25","$6,100",0],[0,1,"Garrett Winters","N","Edinburgh",60,"2010/04/25","$5,300",0]],
"order": [],
"columns": [
{ "data": 0 },
{ "data": 1 },
{
render: function (data, type, row, meta) {
return '<div style="display:inline-block; width:9.5rem"> <input type="button" value="+" name="view_history" style="width:1.5rem; background-color:#7fbf7f; color:white; font-weight:normal; border:1px solid #979797; margin-right:.1rem"/> </div>';}
},
{ "data": 2 },
{ "data": 3 },
{ "data": 4 },
{ "data": 5 },
{ "data": 6 },
{ "data": 7 },
{ "data": 8 }
],
//"columnDefs": [
//{"type": "html-input", "targets": [4,5,6,7,8,9]},
//{ "visible": false, "targets": [0,1,9]},
//{"orderable": false, "targets": "_all"}
//],
"deferRender": true
});
function updateShowActive(name, flag) {
// Iterate all rows where Name column equals name clicked
table.rows( function ( idx, data, node ) {
return data[3] === name ? true : false;
} )
.every( function ( rowIdx, tableLoop, rowLoop ) {
// Get the data for the row
var data = this.data();
// Get the row's Show Other column cell data
var cell = table.cell(this.index(), 9);
var cellData = cell.data();
// If not a lead record then change the Show Other column value
if (data[0] == 0) {
cellData = flag;
cell.data( cellData ); // Update the cell data
}
} );
}
$('#example tbody').on('click', "input[value='+']", function() {
var clickedButton = event.target;
clickedButton.value = '-';
clickedButton.style.backgroundColor = "#DB4C4C";
clickedButton.style.fontWeight = "bold";
// Get row clicked
var row = $(this).closest('tr');
// Get name
var name = table.row( row ).data()[3];
// Update to show
updateShowActive(name, 1);
table.draw(false);
});
$('#example tbody').on('click', "input[value='-']", function() {
var clickedButton = event.target;
clickedButton.value = '+';
clickedButton.style.backgroundColor = "#7fbf7f";
clickedButton.style.fontWeight = "normal";
// Get row clicked
var row = $(this).closest('tr');
// Get name
var name = table.row( row ).data()[3];
// Update to hide
updateShowActive(name, 0);
table.draw(false);
});
} );
You can jump to the latest bin by adding /latest
to your URL
Shortcut | Action |
---|---|
ctrl + [num] | Toggle nth panel |
ctrl + 0 | Close focused panel |
ctrl + enter | Re-render output. If console visible: run JS in console |
Ctrl + l | Clear the console |
ctrl + / | Toggle comment on selected lines |
ctrl + [ | Indents selected lines |
ctrl + ] | Unindents selected lines |
tab | Code complete & Emmet expand |
ctrl + s | Save & lock current Bin from further changes |
ctrl + shift + s | Clone Bin |
ctrl + y | Archive Bin |
Complete list of JS Bin shortcuts |
URL | Action |
---|---|
/ | Show the full rendered output. This content will update in real time as it's updated from the /edit url. |
/edit | Edit the current bin |
/watch | Follow a Code Casting session |
/embed | Create an embeddable version of the bin |
/latest | Load the very latest bin (/latest goes in place of the revision) |
/[username]/last | View the last edited bin for this user |
/[username]/last/edit | Edit the last edited bin for this user |
/[username]/last/watch | Follow the Code Casting session for the latest bin for this user |
/quiet | Remove analytics and edit button from rendered output |
.js | Load only the JavaScript for a bin |
.css | Load only the CSS for a bin |
Except for username prefixed urls, the url may start with http://jsbin.com/abc and the url fragments can be added to the url to view it differently. |