{"id":26,"date":"2021-07-05T14:32:36","date_gmt":"2021-07-05T14:32:36","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=26"},"modified":"2021-07-06T14:06:24","modified_gmt":"2021-07-06T14:06:24","slug":"inline-edit","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/inline-edit\/","title":{"rendered":"Inline Edit"},"content":{"rendered":"\n<pre style=\"background:#777;color:#ffffff\" class=\"wp-block-code has-small-font-size\"><code><strong>&#91;xcrud]    \n    $xcrud = Xcrud::get_instance(); \n    $xcrud-&gt;table_name('Payments - Single click cell to edit!');\n    $xcrud-&gt;table('payments');\n    $xcrud-&gt;unset_remove();\n    $xcrud-&gt;fields_inline('customerNumber,checkNumber,paymentDate,amount');\/\/set the fields to allow inline editing\n    $xcrud-&gt;unset_edit();\n    $xcrud-&gt;set_logging(true);\n    echo $xcrud-&gt;render();\n&#91;\/xcrud]<\/strong><\/code><\/pre>\n\n\n<div class=\"xcrud\">\n<div style=\"display:none;\" class=\"xcrud-main-tab\">Payments &#8211; Single click cell to edit!<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"38b170a88057c5487da1cf9a800b106e63d1361a\" \/><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=\"cc7d8000185e58863b48428a0f4a670740f9f1e0\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"list\" \/><\/p>\n<h2>Payments &#8211; Single click cell to edit!<small> <\/small><\/h2>\n<div class=\"xcrud-top-actions\">\n<div class=\"btn-group pull-right\">\n                <a href=\"javascript:;\" data-task=\"print\" class=\"btn btn-light xcrud-in-new-window xcrud-action\"><i class=\"fa fa-print\"><\/i> Print<\/a><a href=\"javascript:;\" data-task=\"csv\" class=\"btn btn-light xcrud-in-new-window xcrud-action\"><i class=\"fa fa-file\"><\/i> Export into CSV<\/a>            <\/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 table table-striped table-hover table-bordered\">\n<thead>\n<tr class=\"xcrud-th\">\n<th class=\"xcrud-num\">&#35;<\/th>\n<th data-order=\"asc\" data-orderby=\"payments.customerNumber\" class=\"xcrud-column xcrud-action\">Customernumber<\/th>\n<th data-order=\"asc\" data-orderby=\"payments.checkNumber\" class=\"xcrud-column xcrud-action\">Checknumber<\/th>\n<th data-order=\"asc\" data-orderby=\"payments.paymentDate\" class=\"xcrud-column xcrud-action\">Paymentdate<\/th>\n<th data-order=\"asc\" data-orderby=\"payments.amount\" class=\"xcrud-column xcrud-action\">Amount<\/th>\n<th class=\"xcrud-actions\">&nbsp;<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">1<\/td>\n<td identifier=\"payments.customerNumber-9-sc-enter_button_only\">114<\/td>\n<td identifier=\"payments.checkNumber-9-sc-enter_button_only\">NP60385<\/td>\n<td identifier=\"payments.paymentDate-9-sc-enter_button_only\">31.05.2003 00:00:00<\/td>\n<td identifier=\"payments.amount-9-sc-enter_button_only\">7565<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">2<\/td>\n<td identifier=\"payments.customerNumber-12-sc-enter_button_only\">119<\/td>\n<td identifier=\"payments.checkNumber-12-sc-enter_button_only\">LN373447<\/td>\n<td identifier=\"payments.paymentDate-12-sc-enter_button_only\">13.08.2004 00:00:00<\/td>\n<td identifier=\"payments.amount-12-sc-enter_button_only\">47924.19<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">3<\/td>\n<td identifier=\"payments.customerNumber-14-sc-enter_button_only\">121<\/td>\n<td identifier=\"payments.checkNumber-14-sc-enter_button_only\">DB889831<\/td>\n<td identifier=\"payments.paymentDate-14-sc-enter_button_only\">16.02.2003 00:00:00<\/td>\n<td identifier=\"payments.amount-14-sc-enter_button_only\">50218.95<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">4<\/td>\n<td identifier=\"payments.customerNumber-15-sc-enter_button_only\">121<\/td>\n<td identifier=\"payments.checkNumber-15-sc-enter_button_only\">FD317790<\/td>\n<td identifier=\"payments.paymentDate-15-sc-enter_button_only\">28.10.2003 00:00:00<\/td>\n<td identifier=\"payments.amount-15-sc-enter_button_only\">1491.38<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">5<\/td>\n<td identifier=\"payments.customerNumber-17-sc-enter_button_only\">121<\/td>\n<td identifier=\"payments.checkNumber-17-sc-enter_button_only\">MA302151<\/td>\n<td identifier=\"payments.paymentDate-17-sc-enter_button_only\">28.11.2004 00:00:00<\/td>\n<td identifier=\"payments.amount-17-sc-enter_button_only\">34638.14<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">6<\/td>\n<td identifier=\"payments.customerNumber-18-sc-enter_button_only\">124<\/td>\n<td identifier=\"payments.checkNumber-18-sc-enter_button_only\">AE215433<\/td>\n<td identifier=\"payments.paymentDate-18-sc-enter_button_only\">05.03.2005 00:00:00<\/td>\n<td identifier=\"payments.amount-18-sc-enter_button_only\">101244.59<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">7<\/td>\n<td identifier=\"payments.customerNumber-19-sc-enter_button_only\">124<\/td>\n<td identifier=\"payments.checkNumber-19-sc-enter_button_only\">BG255406<\/td>\n<td identifier=\"payments.paymentDate-19-sc-enter_button_only\">28.08.2004 00:00:00<\/td>\n<td identifier=\"payments.amount-19-sc-enter_button_only\">85410.87<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">8<\/td>\n<td identifier=\"payments.customerNumber-20-sc-enter_button_only\">1246<\/td>\n<td identifier=\"payments.checkNumber-20-sc-enter_button_only\">CQ287967<\/td>\n<td identifier=\"payments.paymentDate-20-sc-enter_button_only\">11.04.2003 00:00:00<\/td>\n<td identifier=\"payments.amount-20-sc-enter_button_only\">11044.3<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">9<\/td>\n<td identifier=\"payments.customerNumber-21-sc-enter_button_only\">124<\/td>\n<td identifier=\"payments.checkNumber-21-sc-enter_button_only\">ET64396<\/td>\n<td identifier=\"payments.paymentDate-21-sc-enter_button_only\">16.04.2005 00:00:00<\/td>\n<td identifier=\"payments.amount-21-sc-enter_button_only\">83598.04<\/td>\n<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><\/span><\/td>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">10<\/td>\n<td identifier=\"payments.customerNumber-22-sc-enter_button_only\">124<\/td>\n<td identifier=\"payments.checkNumber-22-sc-enter_button_only\">HI366474<\/td>\n<td identifier=\"payments.paymentDate-22-sc-enter_button_only\">27.12.2004 00:00:00<\/td>\n<td identifier=\"payments.amount-22-sc-enter_button_only\">47142.7<\/td>\n<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><\/span><\/td>\n<\/tr>\n<\/tbody>\n<tfoot>\n                            <\/tfoot>\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=\"1777334400\" data-to=\"1777420799\">Today<\/option><option value=\"this_week_today\" data-from=\"1777248000\" data-to=\"1777420799\">This week up to today<\/option><option value=\"this_week_full\" data-from=\"1777248000\" data-to=\"1777852799\">This full week<\/option><option value=\"last_week\" data-from=\"1776643200\" data-to=\"1777247999\">Last week<\/option><option value=\"last_2weeks\" data-from=\"1776038400\" data-to=\"1776643199\">Last two weeks<\/option><option value=\"this_month\" data-from=\"1775001600\" data-to=\"1777420799\">This month<\/option><option value=\"last_month\" data-from=\"1772323200\" data-to=\"1777334399\">Last month<\/option><option value=\"last_3months\" data-from=\"1767225600\" data-to=\"1777334399\">Last 3 months<\/option><option value=\"last_6months\" data-from=\"1759276800\" data-to=\"1777334399\">Last 6 months<\/option><option value=\"this_year\" data-from=\"1767225600\" data-to=\"1777420799\">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.customerNumber\" data-type=\"int\">Customernumber<\/option><option value=\"payments.checkNumber\" data-type=\"text\">Checknumber<\/option><option value=\"payments.paymentDate\" data-type=\"datetime\">Paymentdate<\/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<\/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\/26"}],"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=26"}],"version-history":[{"count":3,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/26\/revisions"}],"predecessor-version":[{"id":149,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/26\/revisions\/149"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}