{"id":5,"date":"2021-07-03T19:10:19","date_gmt":"2021-07-03T19:10:19","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=5"},"modified":"2021-07-05T14:19:13","modified_gmt":"2021-07-05T14:19:13","slug":"xcrud-simple","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/xcrud-simple\/","title":{"rendered":"Simple CRUD"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n<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=\"83f0a92fdce56419328f9e2b5ac94d66cd531a69\" \/><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=\"03678fc6b59318a7567494c4f3d9a743cd0080be\" \/><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=\"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>114<\/td>\n<td>NP60385<\/td>\n<td>31.05.2003 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">2<\/td>\n<td>119<\/td>\n<td>LN373447<\/td>\n<td>13.08.2004 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">3<\/td>\n<td>121<\/td>\n<td>DB889831<\/td>\n<td>16.02.2003 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">4<\/td>\n<td>121<\/td>\n<td>FD317790<\/td>\n<td>28.10.2003 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">5<\/td>\n<td>121<\/td>\n<td>MA302151<\/td>\n<td>28.11.2004 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">6<\/td>\n<td>124<\/td>\n<td>AE215433<\/td>\n<td>05.03.2005 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">7<\/td>\n<td>124<\/td>\n<td>BG255406<\/td>\n<td>28.08.2004 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">8<\/td>\n<td>1246<\/td>\n<td>CQ287967<\/td>\n<td>11.04.2003 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-0\">\n<td class=\"xcrud-current xcrud-num\">9<\/td>\n<td>124<\/td>\n<td>ET64396<\/td>\n<td>16.04.2005 00:00:00<\/td>\n<td>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><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>\n<\/tr>\n<tr class=\"xcrud-row xcrud-row-1\">\n<td class=\"xcrud-current xcrud-num\">10<\/td>\n<td>124<\/td>\n<td>HI366474<\/td>\n<td>27.12.2004 00:00:00<\/td>\n<td>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><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>\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=\"1775606400\" data-to=\"1775692799\">Today<\/option><option value=\"this_week_today\" data-from=\"1775433600\" data-to=\"1775692799\">This week up to today<\/option><option value=\"this_week_full\" data-from=\"1775433600\" data-to=\"1776038399\">This full week<\/option><option value=\"last_week\" data-from=\"1774828800\" data-to=\"1775433599\">Last week<\/option><option value=\"last_2weeks\" data-from=\"1774224000\" data-to=\"1774828799\">Last two weeks<\/option><option value=\"this_month\" data-from=\"1775001600\" data-to=\"1775692799\">This month<\/option><option value=\"last_month\" data-from=\"1772323200\" data-to=\"1775606399\">Last month<\/option><option value=\"last_3months\" data-from=\"1767225600\" data-to=\"1775606399\">Last 3 months<\/option><option value=\"last_6months\" data-from=\"1759276800\" data-to=\"1775606399\">Last 6 months<\/option><option value=\"this_year\" data-from=\"1767225600\" data-to=\"1775692799\">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\n\n\n<p><\/p>\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\/5"}],"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=5"}],"version-history":[{"count":4,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/5\/revisions"}],"predecessor-version":[{"id":16,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/5\/revisions\/16"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}