{"id":9,"date":"2021-07-03T19:15:10","date_gmt":"2021-07-03T19:15:10","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=9"},"modified":"2021-07-03T19:15:10","modified_gmt":"2021-07-03T19:15:10","slug":"tabulator-simple","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/tabulator-simple\/","title":{"rendered":"Tabulator Simple"},"content":{"rendered":"<div class=\"xcrud\">\n<div style=\"display:none;\" class=\"xcrud-main-tab\">Payments<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"dc51536efbba2051c7247e5a040edc29c0fdcf6f\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"orderby\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"order\" value=\"asc\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"start\" value=\"0\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"limit\" value=\"10\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"instance\" value=\"c1fc5086733bf95d36d9514dc8b57bdbf8278cce\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"list\" \/><\/p>\n<h2>Payments<small> <\/small><\/h2>\n<div class=\"xcrud-top-actions\">\n<div class=\"dropdown pull-right\">\n\t\t\t <!-- <button class=\"btn btn-secondary dropdown-toggle\" type=\"button\" id=\"dropdownMenuButton\" data-toggle=\"dropdown\" aria-haspopup=\"true\" aria-expanded=\"false\">\n\t\t\t    <i class=\"fa fa-print\"><\/i> Print\/Download \n\t\t\t  <\/button>--><\/p>\n<div class=\"dropdown-menu\" aria-labelledby=\"dropdownMenuButton\">\n\t\t\t  \t<a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"print-table\">Print Table<\/a><br \/>\n\t\t\t    <a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"download-csv\">Download CSV<\/a><br \/>\n\t\t\t    <a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"download-json\">Download JSON<\/a><br \/>\n\t\t\t    <a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"download-xlsx\">Download XLSX<\/a><br \/>\n\t\t\t    <a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"download-pdf\">Download PDF<\/a><br \/>\n\t\t\t    <a class=\"dropdown-item\" href=\"javascript:void(0);\" id=\"download-html\">Download HTML<\/a>\n\t\t\t  <\/div>\n<\/p><\/div>\n<p>        <a href=\"javascript:;\" data-task=\"create\" class=\"btn btn-success xcrud-action\"><i class=\"fa fa-plus\"><\/i> Add<\/a>        <\/p>\n<div class=\"clearfix\"><\/div>\n<\/p><\/div>\n<div class=\"row\" style=\"margin: 0!important;overflow-x: scroll;\">\n<div class=\"xcrud-list-container \">\n<table class=\"xcrud-list-2 table table-striped table-hover table-bordered\">\n<thead>\n                            <\/thead>\n<\/table>\n<table class=\"xcrud-list table table-striped table-hover table-bordered\" style=\"width:100%;\">\n<\/table><\/div>\n<p>        <!-- Side Edit Mode --><\/p>\n<div class=\"xcrud-nav form-inline\">\n<div class=\"btn-group xcrud-limit-buttons\" data-toggle=\"buttons-radio\"><button type=\"button\" class=\"btn btn-secondary active xcrud-action\" data-limit=\"10\">10<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"25\">25<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"50\">50<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"100\">100<\/button><button type=\"button\" class=\"btn btn-secondary xcrud-action\" data-limit=\"all\">All<\/button><\/div>\n<ul class=\"pagination\">\n<li class=\"page-item active\"><span class=\"page-link xcrud-action\">1<\/span><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"10\">2<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"20\">3<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"30\">4<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"40\">5<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"50\">6<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"60\">7<\/a><\/li>\n<li class=\"page-item active\"><span class=\"page-link xcrud-action\">&#133;<\/span><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"270\">28<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"280\">29<\/a><\/li>\n<\/ul>\n<p>            <a class=\"xcrud-search-toggle btn btn-secondary\" href=\"javascript:;\">Search<\/a><span class=\"xcrud-search form-inline\" style=\"display:none;\"><input class=\"xcrud-searchdata xcrud-search-active input-small form-control\" name=\"phrase\" data-type=\"text\" style=\"\" data-fieldtype=\"default\" type=\"text\" value=\"\" \/><select class=\"xcrud-daterange xcrud-searchdata input-small form-control\" name=\"range\" data-fieldtype=\"date\" style=\"display:none\"><option value=\"\">&#8211; choose range &#8211;<\/option><option value=\"next_year\" data-from=\"1798761600\" data-to=\"1830297599\">Next year<\/option><option value=\"next_month\" data-from=\"1777593600\" data-to=\"1780185599\">Next month<\/option><option value=\"today\" data-from=\"1775952000\" data-to=\"1776038399\">Today<\/option><option value=\"this_week_today\" data-from=\"1775433600\" data-to=\"1776038399\">This week up to today<\/option><option value=\"this_week_full\" data-from=\"1775433600\" data-to=\"1776643199\">This full week<\/option><option value=\"last_week\" data-from=\"1774828800\" data-to=\"1776038399\">Last week<\/option><option value=\"last_2weeks\" data-from=\"1774224000\" data-to=\"1775433599\">Last two weeks<\/option><option value=\"this_month\" data-from=\"1775001600\" data-to=\"1776038399\">This month<\/option><option value=\"last_month\" data-from=\"1772323200\" data-to=\"1775951999\">Last month<\/option><option value=\"last_3months\" data-from=\"1767225600\" data-to=\"1775951999\">Last 3 months<\/option><option value=\"last_6months\" data-from=\"1759276800\" data-to=\"1775951999\">Last 6 months<\/option><option value=\"this_year\" data-from=\"1767225600\" data-to=\"1776038399\">This year<\/option><option value=\"last_year\" data-from=\"1735689600\" data-to=\"1767225599\">Last year<\/option><\/select><input class=\"xcrud-searchdata xcrud-datepicker-from  input-small form-control\" name=\"phrase][from\" style=\"display:none\" data-type=\"datetime\" data-fieldtype=\"date\" type=\"text\" value=\"\" \/><input class=\"xcrud-searchdata xcrud-datepicker-to  input-small form-control\" name=\"phrase][to\" style=\"display:none\" data-type=\"datetime\" data-fieldtype=\"date\" type=\"text\" value=\"\" \/><select class=\"xcrud-data xcrud-columns-select input-small form-control\" name=\"column\"><option value=\"\">All fields<\/option><option value=\"payments.paymentDate\" data-type=\"datetime\">Payment Date<\/option><option value=\"payments.customerNumber\" data-type=\"int\">Customer Number<\/option><option value=\"payments.checkNumber\" data-type=\"text\">Check No<\/option><option value=\"payments.amount\" data-type=\"float\">Amount<\/option><\/select><span class=\"btn-group\"><a class=\"xcrud-action btn btn-primary\" href=\"javascript:;\" data-search=\"1\">Go<\/a><\/span><\/span>\n        <\/div>\n<pre>\r\n<script>\r\n\t\t\r\n\t\ttry{renderTabulatorMain();}catch(e){}\t\t\t\t\r\n\t\tdocument.addEventListener(\"DOMContentLoaded\", function() {renderTabulatorMain();});\r\n\r\n\t\tfunction renderTabulatorMain(){\r\n\t\t\t\tvar table = \"\";\r\n\t\t\t\t\tvar tableData = [{\"paymentDate\":\"31.05.2003 00:00:00\",\"customerNumber\":\"114\",\"checkNumber\":\"NP60385\",\"amount\":\"7565\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"13.08.2004 00:00:00\",\"customerNumber\":\"119\",\"checkNumber\":\"LN373447\",\"amount\":\"47924.19\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"16.02.2003 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"DB889831\",\"amount\":\"50218.95\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.10.2003 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"FD317790\",\"amount\":\"1491.38\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.11.2004 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"MA302151\",\"amount\":\"34638.14\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"05.03.2005 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"AE215433\",\"amount\":\"101244.59\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.08.2004 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"BG255406\",\"amount\":\"85410.87\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"11.04.2003 00:00:00\",\"customerNumber\":\"1246\",\"checkNumber\":\"CQ287967\",\"amount\":\"11044.3\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"16.04.2005 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"ET64396\",\"amount\":\"83598.04\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"27.12.2004 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"HI366474\",\"amount\":\"47142.7\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"}]; \r\n\t\t\t\t\tconsole.log(tableData);\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\ttable = new Tabulator(\".xcrud-list\", {\r\n\t\t\t\t\t\t\t\tcolumns:[{\"field\":\"paymentDate\",\"title\":\"Payment Date\",\"action\":\"Action\",\"width\":\"25%\",\"number\":{\"class\":\"xcrud-current\"},\"order\":\"27.12.2004 00:00:00<td data-order=\\\"asc\\\" data-orderby=\\\"payments.paymentDate\\\" class=\\\"xcrud-column xcrud-action\\\">\",\"tooltips\":\"\",\"row_class\":\"\"},{\"field\":\"customerNumber\",\"title\":\"Customer Number\",\"action\":\"Action\",\"number\":{\"class\":\"xcrud-current\"},\"order\":\"124<td data-order=\\\"asc\\\" data-orderby=\\\"payments.customerNumber\\\" class=\\\"xcrud-column xcrud-action\\\">\",\"tooltips\":\"\",\"row_class\":\"\"},{\"field\":\"checkNumber\",\"title\":\"Check No\",\"action\":\"Action\",\"width\":\"35%\",\"number\":{\"class\":\"xcrud-current\"},\"order\":\"HI366474<td data-order=\\\"asc\\\" data-orderby=\\\"payments.checkNumber\\\" class=\\\"xcrud-column xcrud-action\\\">\",\"tooltips\":\"\",\"row_class\":\"\"},{\"field\":\"amount\",\"title\":\"Amount\",\"action\":\"Action\",\"number\":{\"class\":\"xcrud-current\"},\"order\":\"47142.7<td data-order=\\\"asc\\\" data-orderby=\\\"payments.amount\\\" class=\\\"xcrud-column xcrud-action\\\">\",\"tooltips\":\"\",\"row_class\":\"\"}],\t\r\n\t\t\t\t\t\t\t\tformatterm: function(cell, formatterParams) {\r\n\t\t\t\t\t\t\t\tconsole.log(\"called\");\t\r\n\t\t\t\t\t\t\t\tvar cellValue = cell.getValue();\r\n\t\t\t\t\t\t\t\tif (cellValue !== \"\") {\r\n\t\t\t\t\t\t\t\t\tcell.getRow().getElement().css({\r\n\t\t\t\t\t\t\t\t\t\"background-color\": \"red\"\r\n\t\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\t\treturn cellValue;\r\n\t\t\t\t\t\t\t\t} else {\r\n\t\t\t\t\t\t\t\t\tcell.getRow().getElement().css({\r\n\t\t\t\t\t\t\t\t\t\"background-color\": \"transparent\"\r\n\t\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\t\treturn cellValue;\r\n\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\tdataLoaded:function(data){ \/\/freeze first row on data load\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\/\/var e = Xcrud.stringToHTML(data[\"action\"]);\r\n\t\t\t\t\t\t\t\t\t\/\/table.addColumn({title:\"Age\", field:\"age\"}, false, \"name\");\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t\n\t\t                              movableColumns: true,\n\t\t                              headerVisible:true,\n\t\t                              width: \"100%\",\n\t\t                              height: \"400px\",\n\t\t                              groupStartOpen:true,\n\t\t                              placeholder:\"No Data Available\",\n\t\t                              tooltipsHeader:true,\n\t\t\t\t\t\t\t\t\t  tooltips:true,\r\n\t\t\t\t\t\t\t\trowFormatter: function(row) {\r\n\t\t\t\t\t\t\t\t\tvar element = row.getElement(),\r\n\t\t\t\t\t\t\t\t\t\tdata = row.getData(),\r\n\t\t\t\t\t\t\t\t\t\twidth = '10px', \/\/element.element.offsetWidth,\r\n\t\t\t\t\t\t\t\t\t\trowTable, cellContents;\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\tvar cells = row.getCells();\r\n\t\t\t\t\t\t\t\t\t\tconsole.log(data.rowClass);\r\n\t\t\t\t\t\t\t\t\t\t\/\/element.css({\"background-color\":\"#A6A6DF\"});\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\tvar elemT = row.getElement(); \t\t\t\t                \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                 \t\r\n\t\t\t\t\t\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\t\t\t\t\/\/\/row.css({\"background-color\":\"#FFA6DF\"});\r\n\t\t\t\t\t\t\t\t\t\t\t\/\/elemT.css({\"background-color\":\"#A6A6DF\"});\t\t\t\t                 \t\t\r\n\t\t\t\t\t\t\t\t\t\t\tvar e = Xcrud.stringToHTML(data[\"action\"],false);\t\t\t\t\t\t\t\t      \r\n\t\t\t\t\t\t\t\t\t\t\t\/\/tabulator-frozen-right\r\n\t\t\t\t\t\t\t\t\t\t\telemT.append(e);\t\t\t\t                      \r\n\t\t\t\t\t\t\t\t\t\t\t\/\/cells = table.getElementsByTagName('td');\t\r\n\t\t\t\t\t\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t}\t\t\t\t\t\t\t\t      \t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t}\t\t\t\t            \r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\tdocument.getElementById(\"print-table\").addEventListener(\"click\", function(){\r\n\t\t\t\t\t\t\ttable.print(false, true);\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\/\/\/trigger download of data.csv file\r\n\t\t\t\t\t\t\tdocument.getElementById(\"download-csv\").addEventListener(\"click\", function(){\r\n\t\t\t\t\t\t\t\ttable.download(\"csv\", \"data.csv\");\r\n\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\/\/\/trigger download of data.csv file\r\n\t\t\t\t\t\t\t\/\/trigger download of data.json file\r\n\t\t\t\t\t\tdocument.getElementById(\"download-json\").addEventListener(\"click\", function(){\r\n\t\t\t\t\t\t\ttable.download(\"json\", \"data.json\");\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\t\t\t   \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\/\/\/trigger download of data.csv file\r\n\t\t\t\t\t\t\t\/\/trigger download of data.json file\r\n\t\t\t\t\t\t\tdocument.getElementById(\"download-xlsx\").addEventListener(\"click\", function(){\r\n\t\t\t\t\t\t\ttable.download(\"xlsx\", \"data.xlsx\", {sheetName:\"My Data\"});\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\/\/\/tr\r\n\t\t\t\t\t\t\t\/\/trigger download of data.pdf file\r\n\t\t\t\t\t\t\tdocument.getElementById(\"download-pdf\").addEventListener(\"click\", function(){\r\n\t\t\t\t\t\t\t\ttable.download(\"pdf\", \"data.pdf\", {\r\n\t\t\t\t\t\t\t\t\torientation:\"portrait\", \/\/set page orientation to portrait\r\n\t\t\t\t\t\t\t\t\ttitle:\"Example Report\", \/\/add title to report\r\n\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t})\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tfunction renderTabulator(){\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\ttableData = [{\"paymentDate\":\"31.05.2003 00:00:00\",\"customerNumber\":\"114\",\"checkNumber\":\"NP60385\",\"amount\":\"7565\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"9\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"13.08.2004 00:00:00\",\"customerNumber\":\"119\",\"checkNumber\":\"LN373447\",\"amount\":\"47924.19\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"12\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"16.02.2003 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"DB889831\",\"amount\":\"50218.95\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"14\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.10.2003 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"FD317790\",\"amount\":\"1491.38\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"15\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.11.2004 00:00:00\",\"customerNumber\":\"121\",\"checkNumber\":\"MA302151\",\"amount\":\"34638.14\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"17\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"05.03.2005 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"AE215433\",\"amount\":\"101244.59\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"18\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"28.08.2004 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"BG255406\",\"amount\":\"85410.87\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"19\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"11.04.2003 00:00:00\",\"customerNumber\":\"1246\",\"checkNumber\":\"CQ287967\",\"amount\":\"11044.3\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"20\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"16.04.2005 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"ET64396\",\"amount\":\"83598.04\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"21\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"},{\"paymentDate\":\"27.12.2004 00:00:00\",\"customerNumber\":\"124\",\"checkNumber\":\"HI366474\",\"amount\":\"47142.7\",\"action\":\"<td class=\\\"xcrud-current xcrud-actions xcrud-fix\\\"><span class=\\\"btn-group\\\"><a class=\\\"xcrud-action btn btn-info btn-sm\\\" title=\\\"View\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"view\\\"><i class=\\\"fa fa-search\\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-warning btn-sm\\\" title=\\\"Edit\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"edit\\\"><i class=\\\"fa fa-edit \\\"><\\\/i><\\\/a><a class=\\\"xcrud-action btn btn-danger btn-sm\\\" title=\\\"Remove\\\" href=\\\"javascript:;\\\" data-primary=\\\"22\\\" data-task=\\\"remove\\\" data-confirm=\\\"Do you really want remove this entry?\\\"><i class=\\\"fa fa-remove\\\"><\\\/i><\\\/a><\\\/span><\\\/td>\",\"rowClass\":\"\"}];  \r\n\t\t\t\t\t\t\tconsole.log(tableData);\r\n\t\t\t\t\t\t\ttable.setData(tableData);\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t$(function() {\r\n\t\t\t\t\t\t\ttry{\r\n\t\t\t\t\t\t\t\ttable.setData(tableData)\r\n\t\t\t\t\t\t\t\t.then(function(){\r\n\t\t\t\t\t\t\t\t\t\/\/run code after table has been successfuly updated\r\n\t\t\t\t\t\t\t\t})\r\n\t\t\t\t\t\t\t\t.catch(function(error){\r\n\t\t\t\t\t\t\t\t\t\/\/handle error loading data\r\n\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t}catch(e){\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t}        \t\r\n\t\t\t\t\t\t});\r\n\t\t\t\t\r\n\t\t\t}\r\n        <\/script><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"xcrud-overlay\"><\/div>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/9"}],"collection":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":2,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":12,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/9\/revisions\/12"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}