{"id":121,"date":"2021-07-06T13:25:14","date_gmt":"2021-07-06T13:25:14","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=121"},"modified":"2021-07-06T13:30:25","modified_gmt":"2021-07-06T13:30:25","slug":"bulk-delete","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/bulk-delete\/","title":{"rendered":"Bulk Delete"},"content":{"rendered":"\n<pre class=\"wp-block-code has-small-font-size\" style=\"background:#777;color:#ffffff\"><code><strong>&#91;xcrud]\n    $xcrud = Xcrud::get_instance();\n    $xcrud-&gt;table('million');\n    $xcrud-&gt;limit_list('20,50,100,1000'); \/\/ do not use 'all' for large tables\n    $xcrud-&gt;bulk_select_position('left'); \/\/It can be 'left' or 'right'\n    \/\/$xcrud-&gt;set_bulk_select(false);\n    $xcrud-&gt;set_bulk_select(false,'cd_key','=','EBGC57SXM-VW47I6AF-401X7DYM');\/\/Dont be able to select records with ID 287846\n    $xcrud-&gt;unset_remove(true,'cd_key','=','EBGC57SXM-VW47I6AF-401X7DYM');\n    $xcrud-&gt;create_action('bulk_delete', 'bulk_delete'); \/\/ action callback, function publish_action() in functions.php\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\">Million<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"c3bb277e6f62acb808f28e7a20ccababed24f70c\" \/><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=\"34273edbaf3a23295ebe9593bd93e15329aa9dff\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"list\" \/><\/p>\n<h2>Million<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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox-main\" name=\"million[]\" value=\"0\" \/><\/th>\n<th data-order=\"asc\" data-orderby=\"million.user_id\" class=\"xcrud-column xcrud-action\">User Id<\/th>\n<th data-order=\"asc\" data-orderby=\"million.cd_key\" class=\"xcrud-column xcrud-action\">Cd Key<\/th>\n<th data-order=\"asc\" data-orderby=\"million.sum\" class=\"xcrud-column xcrud-action\">Sum<\/th>\n<th data-order=\"asc\" data-orderby=\"million.activated\" class=\"xcrud-column xcrud-action\">Activated<\/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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"1000003\" \/><\/td>\n<td>0<\/td>\n<td><\/td>\n<td>0.00<\/td>\n<td>No<\/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=\"1000003\" 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=\"1000003\" 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=\"1000003\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"1000004\" \/><\/td>\n<td>0<\/td>\n<td><\/td>\n<td>0.00<\/td>\n<td>No<\/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=\"1000004\" 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=\"1000004\" 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=\"1000004\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"1000002\" \/><\/td>\n<td>269319<\/td>\n<td><\/td>\n<td>0.00<\/td>\n<td>No<\/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=\"1000002\" 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=\"1000002\" 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=\"1000002\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"762946\" \/><\/td>\n<td>444147<\/td>\n<td>WJ5ZKCEVI-8FHGCQ081-6PE5OW4BL<\/td>\n<td>1.26<\/td>\n<td>No<\/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=\"762946\" 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=\"762946\" 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=\"762946\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"497387\" \/><\/td>\n<td>269319<\/td>\n<td>4RSWV3NWN-P8KQC4YTY-7MDE0GGXN<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"497387\" 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=\"497387\" 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=\"497387\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"235243\" \/><\/td>\n<td>269319<\/td>\n<td>6AC6GMGJB-X8ZER52TY-A1GR37EXN<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"235243\" 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=\"235243\" 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=\"235243\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"333547\" \/><\/td>\n<td>269319<\/td>\n<td>7S32EZEEV-444EF9ETE-CFASL4W9N<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"333547\" 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=\"333547\" 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=\"333547\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"22251\" \/><\/td>\n<td>269319<\/td>\n<td>8NFOS5PCN-4KP9OA9HE-DTD7TUMXN<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"22251\" 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=\"22251\" 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=\"22251\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"251627\" \/><\/td>\n<td>269319<\/td>\n<td>8SH8KK2S7-4NDA3VATE-E1F5KLG9N<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"251627\" 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=\"251627\" 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=\"251627\" 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 class=\"xcrud-actions\"><input type=\"checkbox\" class=\"xcrud-bulk-checkbox\" name=\"million[]\" value=\"399083\" \/><\/td>\n<td>269319<\/td>\n<td>9GAHD5HX3-4ZYMQY85E-F3G6OCTLN<\/td>\n<td>1.44<\/td>\n<td>No<\/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=\"399083\" 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=\"399083\" 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=\"399083\" 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=\"20\">20<\/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=\"1000\">1000<\/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=\"999920\">99993<\/a><\/li>\n<li class=\"page-item\"><a href=\"javascript:;\" class=\"xcrud-action page-link\" data-start=\"999930\">99994<\/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-searchdata  input-small form-control\" name=\"phrase\" style=\"display:none\" data-type=\"bool\" data-fieldtype=\"bool\" type=\"select\"><option value=\"1\">Yes<\/option><option value=\"0\">No<\/option><\/select><select class=\"xcrud-data xcrud-columns-select input-small form-control\" name=\"column\"><option value=\"\">All fields<\/option><option value=\"million.user_id\" data-type=\"int\">User Id<\/option><option value=\"million.cd_key\" data-type=\"text\">Cd Key<\/option><option value=\"million.sum\" data-type=\"float\">Sum<\/option><option value=\"million.activated\" data-type=\"bool\">Activated<\/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<p><button class=\"btn btn-primary\" onclick=\"deleteItems();\">Delete Selected<\/button><\/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\/121"}],"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=121"}],"version-history":[{"count":4,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/121\/revisions"}],"predecessor-version":[{"id":126,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/121\/revisions\/126"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}