<html>
<head>
<script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<link href="//cdnjs.cloudflare.com/ajax/libs/select2/4.0.10/css/select2.min.css" rel="stylesheet" type="text/css" />
<script src="//cdnjs.cloudflare.com/ajax/libs/select2/4.0.10/js/select2.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>
<link href="https://nightly.datatables.net/buttons/css/buttons.dataTables.css?_=c6b24f8a56e04fcee6105a02f4027462.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/buttons/js/dataTables.buttons.js?_=c6b24f8a56e04fcee6105a02f4027462"></script>
<link href="https://nightly.datatables.net/select/css/select.dataTables.css?_=9a6592f8d74f8f520ff7b22342fa1183.css" rel="stylesheet" type="text/css" />
<script src="https://nightly.datatables.net/select/js/dataTables.select.js?_=9a6592f8d74f8f520ff7b22342fa1183"></script>
<link href="https://editor.datatables.net/extensions/Editor/css/editor.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://editor.datatables.net/extensions/Editor/js/dataTables.editor.min.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>Name</th>
<th>Position</th>
<th>Office value</th>
<th>Office label</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office value</th>
<th>Office label</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</tfoot>
<tbody>
<tr id="1">
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>1</td>
<td>Edinburgh</td>
<td>2011/04/25</td>
<td>$3,120</td>
</tr>
<tr id="2">
<td>Garrett Winters</td>
<td>Director</td>
<td>1</td>
<td>Edinburgh</td>
<td>2011/07/25</td>
<td>$5,300</td>
</tr>
<tr id="3">
<td>Ashton Cox</td>
<td>Technical Author</td>
<td>2</td>
<td>San Francisco</td>
<td>2009/01/12</td>
<td>$4,800</td>
</tr>
<tr id="4">
<td>Cedric Kelly</td>
<td>Javascript Developer</td>
<td>1</td>
<td>Edinburgh</td>
<td>2012/03/29</td>
<td>$3,600</td>
</tr>
<tr id="5">
<td>Jenna Elliott</td>
<td>Financial Controller</td>
<td>2</td>
<td>San Francisco</td>
<td>2008/11/28</td>
<td>$5,300</td>
</tr>
<tr id="6">
<td>Brielle Williamson</td>
<td>Integration Specialist</td>
<td>3</td>
<td>New York</td>
<td>2012/12/02</td>
<td>$4,525</td>
</tr>
</tbody>
</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;
}
(function( factory ){
if ( typeof define === 'function' && define.amd ) {
// AMD
define( ['jquery', 'datatables', 'datatables-editor'], factory );
}
else if ( typeof exports === 'object' ) {
// Node / CommonJS
module.exports = function ($, dt) {
if ( ! $ ) { $ = require('jquery'); }
factory( $, dt || $.fn.dataTable || require('datatables') );
};
}
else if ( jQuery ) {
// Browser standard
factory( jQuery, jQuery.fn.dataTable );
}
}(function( $, DataTable ) {
'use strict';
if ( ! DataTable.ext.editorFields ) {
DataTable.ext.editorFields = {};
}
var _fieldTypes = DataTable.Editor ?
DataTable.Editor.fieldTypes :
DataTable.ext.editorFields;
_fieldTypes.select2 = {
_addOptions: function ( conf, opts ) {
var elOpts = conf._input[0].options;
elOpts.length = 0;
if ( opts ) {
DataTable.Editor.pairs( opts, conf.optionsPair, function ( val, label, i ) {
elOpts[i] = new Option( label, val );
} );
}
},
create: function ( conf ) {
conf._input = $('<select/>')
.attr( $.extend( {
id: DataTable.Editor.safeId( conf.id )
}, conf.attr || {} ) );
var options = $.extend( {
width: '100%'
}, conf.opts );
_fieldTypes.select2._addOptions( conf, conf.options || conf.ipOpts );
conf._input.select2( options );
var open;
conf._input
.on( 'select2:open', function () {
open = true;
} )
.on( 'select2:close', function () {
open = false;
} );
// On open, need to have the instance update now that it is in the DOM
this.one( 'open.select2-'+DataTable.Editor.safeId( conf.id ), function () {
conf._input.select2( options );
if ( open ) {
conf._input.select2( 'open' );
}
} );
return conf._input[0];
},
get: function ( conf ) {
var val = conf._input.val();
val = conf._input.prop('multiple') && val === null ?
[] :
val;
return conf.separator ?
val.join( conf.separator ) :
val;
},
set: function ( conf, val ) {
if ( conf.separator && ! $.isArray( val ) ) {
val = val.split( conf.separator );
}
// Clear out any existing tags
if ( conf.opts && conf.opts.tags ) {
conf._input.val([]);
}
// The value isn't present in the current options list, so we need to add it
// in order to be able to select it. Note that this makes the set action async!
// It doesn't appear to be possible to add an option to select2, then change
// its label and update the display
var needAjax = false;
if ( conf.opts && conf.opts.ajax ) {
if ( $.isArray( val ) ) {
for ( var i=0, ien=val.length ; i<ien ; i++ ) {
if ( conf._input.find('option[value="'+val[i]+'"]').length === 0 ) {
needAjax = true;
break;
}
}
}
else {
if ( conf._input.find('option[value="'+val+'"]').length === 0 ) {
needAjax = true;
}
}
}
if ( needAjax && val ) {
$.ajax( $.extend( {
beforeSend: function ( jqXhr, settings ) {
// Add an initial data request to the server, but don't
// override `data` since the dev might be using that
var initData = 'initialValue=true&value='+
JSON.stringify(val);
if ( typeof conf.opts.ajax.url === 'function' ) {
settings.url = conf.opts.ajax.url();
}
if ( settings.type === 'GET' ) {
settings.url += settings.url.indexOf('?') === -1 ?
'?'+initData :
'&'+initData;
}
else {
settings.data = settings.data ?
settings.data +'&'+ initData :
initData;
}
},
success: function ( json ) {
var addOption = function ( option ) {
if ( conf._input.find('option[value="'+option.id+'"]').length === 0 ) {
$('<option/>')
.attr('value', option.id)
.text( option.text )
.appendTo( conf._input );
}
};
if ( $.isArray( json ) ) {
for ( var i=0, ien=json.length ; i<ien ; i++ ) {
addOption( json[i] );
}
}
else if ( json.results && $.isArray( json.results ) ) {
for ( var i=0, ien=json.results.length ; i<ien ; i++ ) {
addOption( json.results[i] );
}
}
else {
addOption( json );
}
conf._input
.val( val )
.trigger( 'change', {editor: true} );
}
}, conf.opts.ajax ) );
}
else {
conf._input
.val( val )
.trigger( 'change', {editor: true} );
}
},
enable: function ( conf ) {
$(conf._input).removeAttr( 'disabled' );
},
disable: function ( conf ) {
$(conf._input).attr( 'disabled', 'disabled' );
},
// Non-standard Editor methods - custom to this plug-in
inst: function ( conf ) {
var args = Array.prototype.slice.call( arguments );
args.shift();
return conf._input.select2.apply( conf._input, args );
},
update: function ( conf, data ) {
var val = _fieldTypes.select2.get( conf );
_fieldTypes.select2._addOptions( conf, data );
// Restore null value if it was, to let the placeholder show
if ( val === null ) {
_fieldTypes.select2.set( conf, null );
}
$(conf._input).trigger('change', {editor: true} );
},
focus: function ( conf ) {
if ( conf._input.is(':visible') && conf.onFocus === 'focus' ) {
conf._input.select2('open');
}
},
owns: function ( conf, node ) {
if ( $(node).closest('.select2-container').length || $(node).closest('.select2').length || $(node).hasClass('select2-selection__choice__remove') ) {
return true;
}
return false;
}
};
}));
$(document).ready(function() {
var editor = new $.fn.dataTable.Editor({
table: "#example",
fields: [
{
label: "Name:",
name: "name"
},
{
label: "Position:",
name: "position"
},
{
label: "Office:",
name: "office_value",
type: "select2",
options: [
{ label: "Edinburgh", value: 1 },
{ label: "San Francisco", value: 2 },
{ label: "New York", value: 3 }
]
},
{
name: "office_label",
type: "hidden"
},
{
label: "Start date:",
name: "start_date",
type: "datetime"
},
{
label: "Salary:",
name: "salary"
}
]
});
// For demo
editor.dependent("office_value", function() {
var label = editor
.field("office_value")
.input()
.find("option:selected")
.text();
editor.val("office_label", label);
return {};
});
// For demo
editor.on('preSubmit', function (e, data, action) {
console.log('Data to submit for', action, data);
});
$("#example").DataTable({
dom: "Bfrtip",
columns: [
{ data: "name" },
{ data: "position" },
{
data: "office_value"
//, visible: false
},
{ data: "office_label" },
{ data: "start_date" },
{ data: "salary" }
],
select: true,
buttons: [
{ extend: "create", editor: editor },
{ extend: "edit", editor: editor },
{ extend: "remove", editor: editor }
]
});
});
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. |