{"id":78,"date":"2021-07-06T12:29:59","date_gmt":"2021-07-06T12:29:59","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=78"},"modified":"2021-07-06T12:29:59","modified_gmt":"2021-07-06T12:29:59","slug":"sub-select-sum-row","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/sub-select-sum-row\/","title":{"rendered":"Sub select &#038; sum row"},"content":{"rendered":"<div class=\"xcrud\">\n<div style=\"display:none;\" class=\"xcrud-main-tab\">Customers<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"adebae6248eff79d28201166c6b8aa532d8d1756\" \/><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=\"afe26c859bc2c205a057f9e19c7c362c85dd4b14\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"list\" \/><\/p>\n<h2>Customers<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=\"customers.customerName\" class=\"xcrud-column xcrud-action\">Customername<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.city\" class=\"xcrud-column xcrud-action\">City<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.creditLimit\" class=\"xcrud-column xcrud-action\">Creditlimit<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.Paid\" class=\"xcrud-column xcrud-action\">Paid<\/th>\n<th data-order=\"asc\" data-orderby=\"customers.Profit\" class=\"xcrud-column xcrud-action\">Profit<\/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>La Rochelle Gifts<\/td>\n<td>Nantes<\/td>\n<td>118200<\/td>\n<td>47924.19<\/td>\n<td>$-70,275.81<\/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=\"119\" 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=\"119\" 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=\"119\" 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>Baane Mini Imports<\/td>\n<td>Stavern<\/td>\n<td>81700<\/td>\n<td>86348.47<\/td>\n<td>$4,648.47<\/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=\"121\" 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=\"121\" 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=\"121\" 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>Zbyszek Zbyszek Piestrzeniewicz<\/td>\n<td>Warszawa<\/td>\n<td>1230<\/td>\n<td><\/td>\n<td>$0.00<\/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=\"125\" 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=\"125\" 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=\"125\" 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>Blauer See Auto, Co.<\/td>\n<td>Frankfurt<\/td>\n<td>59700<\/td>\n<td>68471.44<\/td>\n<td>$8,771.44<\/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=\"128\" 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=\"128\" 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=\"128\" 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>Land of Toys Inc.<\/td>\n<td>NYC<\/td>\n<td>114900<\/td>\n<td>72317.97<\/td>\n<td>$-42,582.03<\/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=\"131\" 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=\"131\" 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=\"131\" 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>Euro+ Shopping Channel<\/td>\n<td>Madrid<\/td>\n<td>227600<\/td>\n<td>679486.64<\/td>\n<td>$451,886.64<\/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=\"141\" 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=\"141\" 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=\"141\" 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>Volvo Model Replicas, Co<\/td>\n<td>Lule\u00c3\u00a5<\/td>\n<td>53100<\/td>\n<td>43680.65<\/td>\n<td>$-9,419.35<\/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=\"144\" 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=\"144\" 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=\"144\" 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>Danish Wholesale Imports<\/td>\n<td>Kobenhavn<\/td>\n<td>83400<\/td>\n<td>142768.47<\/td>\n<td>$59,368.47<\/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=\"145\" 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=\"145\" 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=\"145\" 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>Saveley &#038; Henriot, Co.<\/td>\n<td>Lyon<\/td>\n<td>123900<\/td>\n<td>80691<\/td>\n<td>$-43,209.00<\/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=\"146\" 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=\"146\" 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=\"146\" 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>Dragon Souveniers, Ltd.<\/td>\n<td>Singapore<\/td>\n<td>103800<\/td>\n<td>156251.03<\/td>\n<td>$52,451.03<\/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=\"148\" 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=\"148\" 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=\"148\" 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<tr class=\"xcrud-tf\">\n<td class=\"xcrud-num\">&Sigma;<\/td>\n<td class=\"xcrud-sum\">&nbsp;<\/td>\n<td class=\"xcrud-sum\">&nbsp;<\/td>\n<td class=\"xcrud-sum\">7945330.12<\/td>\n<td class=\"xcrud-sum\">7709057.830000002<\/td>\n<td class=\"xcrud-sum\">$157.71<\/td>\n<td class=\"xcrud-actions\">&nbsp;<\/td>\n<\/tr>\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=\"110\">12<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"120\">13<\/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-data xcrud-columns-select input-small form-control\" name=\"column\"><option value=\"\">All fields<\/option><option value=\"customers.customerName\" data-type=\"text\">Customername<\/option><option value=\"customers.city\" data-type=\"text\">City<\/option><option value=\"customers.creditLimit\" data-type=\"float\">Creditlimit<\/option><option value=\"customers.Paid\" data-type=\"none\">Paid<\/option><option value=\"customers.Profit\" data-type=\"price\">Profit<\/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\/78"}],"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=78"}],"version-history":[{"count":1,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/78\/revisions"}],"predecessor-version":[{"id":79,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/78\/revisions\/79"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}