/* global DataTable */ /* eslint-disable no-unused-vars */ const { columns, data } = getSampleData(); // Hero let datatable1 = new DataTable('.example-1 .target', { columns, data }); // Formatted Cells let datatable2 = new DataTable('.example-2', { columns: ['Name', 'Position', 'Office', 'Extn.', 'Start Date', { content: 'Salary', format: val => '$' + val, align: 'right' }], data }); // Inline Filters let datatable3 = new DataTable('.example-3', { columns, data, enableInlineFilters: true }); datatable3.showToastMessage('Click on a cell and press Ctrl/Cmd + F'); // Keyboard let datatable4 = new DataTable('.example-4', { columns, data }); datatable4.showToastMessage('Double click to edit'); // Tree Structured Rows let datatable5 = new DataTable('.example-5', getTreeData()); datatable5.showToastMessage('Expand/Collapse tree nodes'); function getSampleData(multiplier) { let columns = ['Name', 'Position', 'Office', 'Extn.', 'Start Date', 'Salary']; let data = [ ['Tiger Nixon', 'System Architect', 'Edinburgh', '5421', '2011/04/25', '320,800'], ['Garrett Winters', 'Accountant', 'Tokyo', '8422', '2011/07/25', '170,750'], ['Ashton Cox', 'Junior Technical Author', 'San Francisco', '1562', '2009/01/12', '86,000'], ['Cedric Kelly', 'Senior Javascript Developer', 'Edinburgh', '6224', '2012/03/29', '433,060'], ['Airi Satou', 'Accountant', 'Tokyo', '5407', '2008/11/28', '162,700'], ['Brielle Williamson', 'Integration Specialist', 'New York', '4804', '2012/12/02', '372,000'], ['Herrod Chandler', 'Sales Assistant', 'San Francisco', '9608', '2012/08/06', '137,500'], ['Rhona Davidson', 'Integration Specialist', 'Tokyo', '6200', '2010/10/14', '327,900'], ['Colleen Hurst', 'Javascript Developer', 'San Francisco', '2360', '2009/09/15', '205,500'], ['Sonya Frost', 'Software Engineer', 'Edinburgh', '1667', '2008/12/13', '103,600'], ['Jena Gaines', 'Office Manager', 'London', '3814', '2008/12/19', '90,560'], ['Quinn Flynn', 'Support Lead', 'Edinburgh', '9497', '2013/03/03', '342,000'], ['Charde Marshall', 'Regional Director', 'San Francisco', '6741', '2008/10/16', '470,600'], ['Haley Kennedy', 'Senior Marketing Designer', 'London', '3597', '2012/12/18', '313,500'], ['Tatyana Fitzpatrick', 'Regional Director', 'London', '1965', '2010/03/17', '385,750'], ['Michael Silva', 'Marketing Designer', 'London', '1581', '2012/11/27', '198,500'], ['Paul Byrd', 'Chief Financial Officer (CFO)', 'New York', '3059', '2010/06/09', '725,000'], ['Gloria Little', 'Systems Administrator', 'New York', '1721', '2009/04/10', '237,500'], ['Bradley Greer', 'Software Engineer', 'London', '2558', '2012/10/13', '132,000'], ['Dai Rios', 'Personnel Lead', 'Edinburgh', '2290', '2012/09/26', '217,500'], ['Jenette Caldwell', 'Development Lead', 'New York', '1937', '2011/09/03', '345,000'], ['Yuri Berry', 'Chief Marketing Officer (CMO)', 'New York', '6154', '2009/06/25', '675,000'], ['Caesar Vance', 'Pre-Sales Support', 'New York', '8330', '2011/12/12', '106,450'], ['Doris Wilder', 'Sales Assistant', 'Sidney', '3023', '2010/09/20', '85,600'], ['Angelica Ramos', 'Chief Executive Officer (CEO)', 'London', '5797', '2009/10/09', '1,200,000'], ['Gavin Joyce', 'Developer', 'Edinburgh', '8822', '2010/12/22', '92,575'], ['Jennifer Chang', 'Regional Director', 'Singapore', '9239', '2010/11/14', '357,650'], ['Brenden Wagner', 'Software Engineer', 'San Francisco', '1314', '2011/06/07', '206,850'], ['Fiona Green', 'Chief Operating Officer (COO)', 'San Francisco', '2947', '2010/03/11', '850,000'], ['Shou Itou', 'Regional Marketing', 'Tokyo', '8899', '2011/08/14', '163,000'], ['Michelle House', 'Integration Specialist', 'Sidney', '2769', '2011/06/02', '95,400'], ['Suki Burks', 'Developer', 'London', '6832', '2009/10/22', '114,500'], ['Prescott Bartlett', 'Technical Author', 'London', '3606', '2011/05/07', '145,000'], ['Gavin Cortez', 'Team Leader', 'San Francisco', '2860', '2008/10/26', '235,500'], ['Martena Mccray', 'Post-Sales support', 'Edinburgh', '8240', '2011/03/09', '324,050'], ['Unity Butler', 'Marketing Designer', 'San Francisco', '5384', '2009/12/09', '85,675'], ['Howard Hatfield', 'Office Manager', 'San Francisco', '7031', '2008/12/16', '164,500'], ['Hope Fuentes', 'Secretary', 'San Francisco', '6318', '2010/02/12', '109,850'], ['Vivian Harrell', 'Financial Controller', 'San Francisco', '9422', '2009/02/14', '452,500'], ['Timothy Mooney', 'Office Manager', 'London', '7580', '2008/12/11', '136,200'], ['Jackson Bradshaw', 'Director', 'New York', '1042', '2008/09/26', '645,750'], ['Olivia Liang', 'Support Engineer', 'Singapore', '2120', '2011/02/03', '234,500'], ['Bruno Nash', 'Software Engineer', 'London', '6222', '2011/05/03', '163,500'], ['Sakura Yamamoto', 'Support Engineer', 'Tokyo', '9383', '2009/08/19', '139,575'], ['Thor Walton', 'Developer', 'New York', '8327', '2013/08/11', '98,540'], ['Finn Camacho', 'Support Engineer', 'San Francisco', '2927', '2009/07/07', '87,500'], ['Serge Baldwin', 'Data Coordinator', 'Singapore', '8352', '2012/04/09', '138,575'], ['Zenaida Frank', 'Software Engineer', 'New York', '7439', '2010/01/04', '125,250'], ['Zorita Serrano', 'Software Engineer', 'San Francisco', '4389', '2012/06/01', '115,000'], ['Jennifer Acosta', 'Junior Javascript Developer', 'Edinburgh', '3431', '2013/02/01', '75,650'], ['Cara Stevens', 'Sales Assistant', 'New York', '3990', '2011/12/06', '145,600'], ['Hermione Butler', 'Regional Director', 'London', '1016', '2011/03/21', '356,250'], ['Lael Greer', 'Systems Administrator', 'London', '6733', '2009/02/27', '103,500'], ['Jonas Alexander', 'Developer', 'San Francisco', '8196', '2010/07/14', '86,500'], ['Shad Decker', 'Regional Director', 'Edinburgh', '6373', '2008/11/13', '183,000'], ['Michael Bruce', 'Javascript Developer', 'Singapore', '5384', '2011/06/27', '183,000'], ['Donna Snider', 'Customer Support', 'New York', '4226', '2011/01/25', '112,000'] ]; if (multiplier) { Array.from(new Array(multiplier - 1)).forEach(d => { data = data.concat(data); }); } return { columns, data }; } function getTreeData() { return { columns: [{ 'id': 'account', 'content': 'Account' }, { 'id': 'opening_debit', 'content': 'Opening (Dr)' }, { 'id': 'opening_credit', 'content': 'Opening (Cr)' }, // { // 'id': 'debit', // 'content': 'Debit' // }, // { // 'id': 'credit', // 'content': 'Credit' // }, { 'id': 'closing_debit', 'content': 'Closing (Dr)' }, { 'id': 'closing_credit', 'content': 'Closing (Cr)' }, { 'id': 'currency', 'content': 'Currency', 'hidden': 1 }], data: [{ 'account_name': 'Application of Funds (Assets)', 'account': 'Application of Funds (Assets)', 'parent_account': null, 'indent': 0, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 12023729.54, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 12023729.54, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Current Assets', 'account': 'Current Assets', 'parent_account': 'Application of Funds (Assets)', 'indent': 1, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 13960649.54, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 13960649.54, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Accounts Receivable', 'account': 'Accounts Receivable', 'parent_account': 'Current Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 742790.474, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 742790.474, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Debtors', 'account': 'Debtors', 'parent_account': 'Accounts Receivable', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 742790.474, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 742790.474, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Bank Accounts', 'account': 'Bank Accounts', 'parent_account': 'Current Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 280676.822, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 280676.822, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Corporation Bank', 'account': 'Corporation Bank', 'parent_account': 'Bank Accounts', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 290676.822, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 290676.822, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'HDFC Bank', 'account': 'HDFC Bank', 'parent_account': 'Bank Accounts', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 10000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 10000.0, 'has_value': true }, { 'account_name': 'Cash In Hand', 'account': 'Cash In Hand', 'parent_account': 'Current Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 229904.494, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 229904.494, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Cash', 'account': 'Cash', 'parent_account': 'Cash In Hand', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 229904.494, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 229904.494, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Stock Assets', 'account': 'Stock Assets', 'parent_account': 'Current Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 12707277.75, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 12707277.75, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'All Warehouses', 'account': 'All Warehouses', 'parent_account': 'Stock Assets', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 12707277.75, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 12707277.75, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Finished Goods', 'account': 'Finished Goods', 'parent_account': 'All Warehouses', 'indent': 4, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 87320.3, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 87320.3, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Retail Stores', 'account': 'Retail Stores', 'parent_account': 'All Warehouses', 'indent': 4, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 4540590.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 4540590.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Bandra Store', 'account': 'Bandra Store', 'parent_account': 'Retail Stores', 'indent': 5, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 3246800.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 3246800.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Central Warehouse', 'account': 'Central Warehouse', 'parent_account': 'Retail Stores', 'indent': 5, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 1236790.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 1236790.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Lower Parel Store', 'account': 'Lower Parel Store', 'parent_account': 'Retail Stores', 'indent': 5, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 57000.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 57000.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Stores', 'account': 'Stores', 'parent_account': 'All Warehouses', 'indent': 4, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 8016525.27, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 8016525.27, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Work In Progress', 'account': 'Work In Progress', 'parent_account': 'All Warehouses', 'indent': 4, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 62842.18, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 62842.18, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Fixed Assets', 'account': 'Fixed Assets', 'parent_account': 'Application of Funds (Assets)', 'indent': 1, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 19920.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 19920.0, 'has_value': true }, { 'account_name': 'Electronic Equipments', 'account': 'Electronic Equipments', 'parent_account': 'Fixed Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 80.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 80.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'Furnitures and Fixtures', 'account': 'Furnitures and Fixtures', 'parent_account': 'Fixed Assets', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 20000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 20000.0, 'has_value': true }, { 'account_name': 'Temporary Accounts', 'account': 'Temporary Accounts', 'parent_account': 'Application of Funds (Assets)', 'indent': 1, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 1917000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 1917000.0, 'has_value': true }, { 'account_name': 'Temporary Opening', 'account': 'Temporary Opening', 'parent_account': 'Temporary Accounts', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 1917000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 1917000.0, 'has_value': true }, { 'account_name': 'Source of Funds (Liabilities)', 'account': 'Source of Funds (Liabilities)', 'parent_account': null, 'indent': 0, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 2371628.002, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 2371628.002, 'has_value': true }, { 'account_name': 'Current Liabilities', 'account': 'Current Liabilities', 'parent_account': 'Source of Funds (Liabilities)', 'indent': 1, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 2371628.002, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 2371628.002, 'has_value': true }, { 'account_name': 'Accounts Payable', 'account': 'Accounts Payable', 'parent_account': 'Current Liabilities', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 368311.85, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 368311.85, 'has_value': true }, { 'account_name': 'Creditors', 'account': 'Creditors', 'parent_account': 'Accounts Payable', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 194871.85, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 194871.85, 'has_value': true }, { 'account_name': 'Salary Payable', 'account': 'Salary Payable', 'parent_account': 'Accounts Payable', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 173440.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 173440.0, 'has_value': true }, { 'account_name': 'Duties and Taxes', 'account': 'Duties and Taxes', 'parent_account': 'Current Liabilities', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 150146.822, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 150146.822, 'has_value': true }, { 'account_name': 'CGST', 'account': 'CGST', 'parent_account': 'Duties and Taxes', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 51479.591, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 51479.591, 'has_value': true }, { 'account_name': 'IGST', 'account': 'IGST', 'parent_account': 'Duties and Taxes', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 1944.0, 'opening_credit': 0.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 1944.0, 'closing_credit': 0.0, 'has_value': true }, { 'account_name': 'SGST', 'account': 'SGST', 'parent_account': 'Duties and Taxes', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 97711.231, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 97711.231, 'has_value': true }, { 'account_name': 'UGST', 'account': 'UGST', 'parent_account': 'Duties and Taxes', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 2900.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 2900.0, 'has_value': true }, { 'account_name': 'Stock Liabilities', 'account': 'Stock Liabilities', 'parent_account': 'Current Liabilities', 'indent': 2, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 1853169.33, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 1853169.33, 'has_value': true }, { 'account_name': 'Stock Received But Not Billed', 'account': 'Stock Received But Not Billed', 'parent_account': 'Stock Liabilities', 'indent': 3, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 1853169.33, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 1853169.33, 'has_value': true }, { 'account_name': 'Equity', 'account': 'Equity', 'parent_account': null, 'indent': 0, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 10000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 10000.0, 'has_value': true }, { 'account_name': 'Capital Stock', 'account': 'Capital Stock', 'parent_account': 'Equity', 'indent': 1, 'from_date': '2018-04-01', 'to_date': '2019-03-31', 'currency': 'INR', 'opening_debit': 0.0, 'opening_credit': 10000.0, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 0.0, 'closing_credit': 10000.0, 'has_value': true }, {}, { 'account': 'Total', 'account_name': 'Total', 'warn_if_negative': true, 'opening_debit': 32260956.43, 'opening_credit': 22618854.891999997, 'debit': 0.0, 'credit': 0.0, 'closing_debit': 32260956.43, 'closing_credit': 22618854.891999997, 'parent_account': null, 'indent': 0, 'has_value': true, 'currency': 'INR' }] }; }