Changeset 3324099

Timestamp:

07/08/2025 07:38:09 AM (8 months ago)

Author:

progressplanner

Message:

Update to version 1.4.0 from GitHub

Location:

aaa-option-optimizer

Files:

• assets/banner-1544x500.jpg (deleted)
• assets/banner-1544x500.png (added)
• assets/banner-772x250.jpg (deleted)
• assets/banner-772x250.png (added)
• assets/icon-128x128.png (modified) (previous)
• assets/icon-256x256.png (modified) (previous)
• assets/icon.svg (added)
• tags/1.4.0 (copied) (copied from aaa-option-optimizer/trunk)
• tags/1.4.0/aaa-option-optimizer.php (modified) (1 diff)
• tags/1.4.0/css/style.css (modified) (1 diff)
• tags/1.4.0/js/admin-script.js (modified) (2 diffs)
• tags/1.4.0/known-plugins/known-plugins.json (modified) (8 diffs)
• tags/1.4.0/package-lock.json (added)
• tags/1.4.0/package.json (added)
• tags/1.4.0/readme.txt (modified) (2 diffs)
• tags/1.4.0/src/class-admin-page.php (modified) (14 diffs)
• tags/1.4.0/src/class-rest.php (modified) (4 diffs)
• trunk/aaa-option-optimizer.php (modified) (1 diff)
• trunk/css/style.css (modified) (1 diff)
• trunk/js/admin-script.js (modified) (2 diffs)
• trunk/known-plugins/known-plugins.json (modified) (8 diffs)
• trunk/package-lock.json (added)
• trunk/package.json (added)
• trunk/readme.txt (modified) (2 diffs)
• trunk/src/class-admin-page.php (modified) (14 diffs)
• trunk/src/class-rest.php (modified) (4 diffs)

aaa-option-optimizer/tags/1.4.0/aaa-option-optimizer.php

@@ -8 +8 @@
  * Plugin URI: https://joost.blog/plugins/aaa-option-optimizer/
  * Description: Tracks autoloaded options usage and allows the user to optimize them.
- * Version: 1.3.2
+ * Version: 1.4.0
  * License: GPL-3.0+
  * Author: Joost de Valk

aaa-option-optimizer/tags/1.4.0/css/style.css

@@ -3 +3 @@
     border-spacing: 0;
 }
+.aaa-option-optimizer-tabs .dt-layout-cell.dt-start:has(.dt-length) {
+    display: flex;
+    justify-content: flex-start;
+    gap: 20px;
+}
+
 .aaa_option_table td, .aaa_option_table th {
     padding: 5px 10px 5px 5px;

aaa-option-optimizer/tags/1.4.0/js/admin-script.js

@@ +1 @@
+/* global jQuery, aaaOptionOptimizer, Option, DataTable, alert */
+
 /**
  * JavaScript for the admin page.
  *
- * @package Emilia\OptionOptimizer
+ * @package
  */
 
@@ -8 +10 @@
  * Initializes the data tables and sets up event handlers.
  */
-jQuery( document ).ready(
-    function ($) {
-        /**
-         * Array of table selectors to initialize.
-         *
-         * @type {string[]}
-         */
-        const tablesToInitialize = [
-            '#unused_options_table',
-            '#used_not_autoloaded_table',
-            '#requested_do_not_exist_table',
+jQuery( document ).ready( function () {
+    /**
+     * Array of table selectors to initialize.
+     *
+     * @type {string[]}
+     */
+    const tablesToInitialize = [
+        '#unused_options_table',
+        '#used_not_autoloaded_table',
+        '#requested_do_not_exist_table',
+    ];
+
+    jQuery( '#all_options_table' ).hide();
+    jQuery( '#aaa_get_all_options' ).on( 'click', function ( e ) {
+        e.preventDefault();
+        jQuery( '#all_options_table' ).show();
+        initializeDataTable( '#all_options_table' );
+        jQuery( this ).hide();
+    } );
+
+    /**
+     * Generate row ID for an option name.
+     *
+     * @param {string} optionName - The option name.
+     * @return {string} The row ID.
+     */
+    function generateRowId( optionName ) {
+        return 'option_' + optionName.replace( /\./g, '_' );
+    }
+
+    /**
+     * Initializes the DataTable for the given selector.
+     *
+     * @param {string} selector - The table selector.
+     */
+    function initializeDataTable( selector ) {
+        const options = {
+            pageLength: 25,
+            autoWidth: false,
+            responsive: true,
+            columns: getColumns( selector ),
+            rowId( data ) {
+                return generateRowId( data.name );
+            },
+            initComplete() {
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            },
+            language: aaaOptionOptimizer.i18n,
+        };
+
+        if ( selector === '#unused_options_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/unused-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+            ( options.language = {
+                sZeroRecords: aaaOptionOptimizer.i18n.noAutoloadedButNotUsed,
+            } ),
+                ( options.initComplete = function () {
+                    getBulkActionsForm( selector, [ 'autoload-off' ] ).call(
+                        this
+                    );
+                    this.api()
+                        .columns( 'source:name' )
+                        .every( setupColumnFilters );
+                } );
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        if ( selector === '#used_not_autoloaded_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/used-not-autoloaded-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+            options.language = {
+                sZeroRecords: aaaOptionOptimizer.i18n.noUsedButNotAutoloaded,
+            };
+            options.initComplete = function () {
+                getBulkActionsForm( selector, [ 'autoload-on' ] ).call( this );
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            };
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        if ( selector === '#requested_do_not_exist_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/options-that-do-not-exist',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+        }
+
+        if ( selector === '#all_options_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/all-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.initComplete = function () {
+                getBulkActionsForm( selector, [
+                    'autoload-on',
+                    'autoload-off',
+                ] ).call( this );
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            };
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        new DataTable( selector, options ).columns.adjust().responsive.recalc();
+    }
+
+    /**
+     * Retrieves the columns configuration based on the selector.
+     *
+     * @param {string} selector - The table selector.
+     *
+     * @return {Object[]} - The columns configuration.
+     */
+    function getColumns( selector ) {
+        const commonColumns = [
+            {
+                name: 'checkbox',
+                data: 'name',
+                render: ( data, type, row ) => renderCheckboxColumn( row ),
+                orderable: false,
+                searchable: false,
+                className: 'select-all',
+            },
+            { name: 'name', data: 'name' },
+            { name: 'source', data: 'plugin' },
+            { name: 'size', data: 'size', searchable: false },
+            {
+                name: 'autoload',
+                data: 'autoload',
+                className: 'autoload',
+                searchable: false,
+                orderable: false,
+            },
+            {
+                name: 'value',
+                data: 'value',
+                render: ( data, type, row ) => renderValueColumn( row ),
+                orderable: false,
+                searchable: false,
+                className: 'actions',
+            },
         ];
-
-        $( '#all_options_table' ).hide();
-        $( '#aaa_get_all_options' ).on(
-            'click',
-            function (e) {
-                e.preventDefault();
-                $( '#all_options_table' ).show();
-                initializeDataTable( '#all_options_table' );
-                $( this ).hide();
-            }
-        );
-
-        /**
-         * Initializes the DataTable for the given selector.
-         *
-         * @param {string} selector - The table selector.
-         */
-        function initializeDataTable(selector) {
-            const options = {
-                pageLength: 25,
-                autoWidth: false,
-                responsive: true,
-                columns: getColumns( selector ),
-                initComplete: function () {
-                    this.api().columns( 'source:name' ).every( setupColumnFilters );
-                }
-            };
-
-            if (selector === '#all_options_table') {
-                options.ajax  = {
-                    url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/all-options',
-                    headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
-                    type: 'GET',
-                    dataSrc: 'data'
-                };
-                options.rowId = 'row_id';
-            }
-
-            options.language = aaaOptionOptimizer.i18n;
-
-            const dataTable = new DataTable( selector, options ).columns.adjust().responsive.recalc();;
-        }
-
-        /**
-         * Retrieves the columns configuration based on the selector.
-         *
-         * @param {string} selector - The table selector.
-         *
-         * @returns {Object[]} - The columns configuration.
-         */
-        function getColumns(selector) {
-            const commonColumns = [
-                { name: 'name' },
-                { name: 'source' },
-                { name: 'size', searchable: false },
-                { name: 'autoload', className: 'autoload', searchable: false },
-                { name: 'actions', searchable: false, orderable: false }
+        if ( selector === '#requested_do_not_exist_table' ) {
+            return [
+                { name: 'option', data: 'name' },
+                { name: 'source', data: 'plugin', searchable: false },
+                { name: 'calls', data: 'count', searchable: false },
+                {
+                    name: 'option_name',
+                    data: 'option_name',
+                    render: ( data, type, row ) =>
+                        renderNonExistingOptionsColumn( row ),
+                    searchable: false,
+                    orderable: false,
+                    className: 'actions',
+                },
             ];
-
-            if (selector === '#requested_do_not_exist_table') {
-                return [
-                    { name: 'name' },
-                    { name: 'source', searchable: false },
-                    { name: 'calls', searchable: false },
-                    { name: 'actions', searchable: false, orderable: false }
-                ];
-            } else if (selector === '#used_not_autoloaded_table') {
-                return [
-                    { name: 'name' },
-                    { name: 'source' },
-                    { name: 'size', searchable: false },
-                    { name: 'autoload', className: 'autoload', searchable: false },
-                    { name: 'calls', searchable: false },
-                    { name: 'actions', searchable: false, orderable: false }
-                ]
-            } else if (selector === '#all_options_table') {
-                return [
+        } else if ( selector === '#used_not_autoloaded_table' ) {
+            return [
+                {
+                    name: 'checkbox',
+                    data: 'name',
+                    render: ( data, type, row ) => renderCheckboxColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'select-all',
+                },
                 { name: 'name', data: 'name' },
                 { name: 'source', data: 'plugin' },
+                { name: 'size', data: 'size', searchable: false },
+                {
+                    name: 'autoload',
+                    data: 'autoload',
+                    className: 'autoload',
+                    searchable: false,
+                    orderable: false,
+                },
+                { name: 'calls', data: 'count', searchable: false },
+                {
+                    name: 'value',
+                    data: 'value',
+                    render: ( data, type, row ) => renderValueColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'actions',
+                },
+            ];
+        } else if ( selector === '#all_options_table' ) {
+            return [
+                {
+                    name: 'checkbox',
+                    data: 'name',
+                    render: ( data, type, row ) => renderCheckboxColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'select-all',
+                },
+                { name: 'name', data: 'name' },
+                { name: 'source', data: 'plugin' },
                 {
                     name: 'size',
                     data: 'size',
                     searchable: false,
-                    render: data => '<span class="num">' + data + '</span>'
-                },
-                { name: 'autoload', data: 'autoload', className: 'autoload', searchable: false },
+                    render: ( data ) => '<span class="num">' + data + '</span>',
+                },
+                {
+                    name: 'autoload',
+                    data: 'autoload',
+                    className: 'autoload',
+                    searchable: false,
+                },
                 {
                     name: 'value',
                     data: 'value',
-                    render: (data, type, row) => renderValueColumn( row ),
+                    render: ( data, type, row ) => renderValueColumn( row ),
                     orderable: false,
                     searchable: false,
-                    className: 'actions'
-                }
-                ];
+                    className: 'actions',
+                },
+            ];
+        }
+
+        return commonColumns;
+    }
+
+    /**
+     * Sets up the column filters for the DataTable.
+     */
+    function setupColumnFilters() {
+        const column = this;
+        const select = document.createElement( 'select' );
+        select.add(
+            new Option( aaaOptionOptimizer.i18n.filterBySource, '', true, true )
+        );
+        column.footer().replaceChildren( select );
+
+        select.addEventListener( 'change', function () {
+            column.search( select.value, { exact: true } ).draw();
+        } );
+
+        column
+            .data()
+            .unique()
+            .sort()
+            .each( function ( d ) {
+                select.add( new Option( d ) );
+            } );
+    }
+
+    /**
+     * Renders the value column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderValueColumn( row ) {
+        const popoverContent =
+            '<div id="popover_' +
+            row.name +
+            '" popover class="aaa-option-optimizer-popover">' +
+            '<button class="aaa-option-optimizer-popover__close" popovertarget="popover_' +
+            row.name +
+            '" popovertargetaction="hide">X</button>' +
+            '<p><strong>Value of <code>' +
+            row.name +
+            '</code></strong></p>' +
+            '<pre>' +
+            row.value +
+            '</pre>' +
+            '</div>';
+
+        const actions = [
+            '<button class="button dashicon" popovertarget="popover_' +
+                row.name +
+                '"><span class="dashicons dashicons-search"></span>' +
+                aaaOptionOptimizer.i18n.showValue +
+                '</button>',
+            popoverContent,
+            row.autoload === 'no'
+                ? '<button class="button dashicon add-autoload" data-option="' +
+                  row.name +
+                  '"><span class="dashicons dashicons-plus"></span>' +
+                  aaaOptionOptimizer.i18n.addAutoload +
+                  '</button>'
+                : '<button class="button dashicon remove-autoload" data-option="' +
+                  row.name +
+                  '"><span class="dashicons dashicons-minus"></span>' +
+                  aaaOptionOptimizer.i18n.removeAutoload +
+                  '</button>',
+            '<button class="button button-delete delete-option" data-option="' +
+                row.name +
+                '"><span class="dashicons dashicons-trash"></span>' +
+                aaaOptionOptimizer.i18n.deleteOption +
+                '</button >',
+        ];
+
+        return actions.join( '' );
+    }
+
+    /**
+     * Renders the value column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderNonExistingOptionsColumn( row ) {
+        return (
+            '<button class="button button-primary create-option-false" data-option="' +
+            row.name +
+            '">' +
+            aaaOptionOptimizer.i18n.createOptionFalse +
+            '</button>'
+        );
+    }
+
+    /**
+     * Renders the checkbox column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderCheckboxColumn( row ) {
+        return (
+            '<label for="select-option-' +
+            row.name +
+            '">' +
+            '<input type="checkbox" id="select-option-' +
+            row.name +
+            '" class="select-option" data-option="' +
+            row.name +
+            '">' +
+            '</label>'
+        );
+    }
+
+    jQuery( '#aaa-option-reset-data' ).on( 'click', function ( e ) {
+        e.preventDefault();
+        jQuery.ajax( {
+            url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/reset',
+            method: 'POST',
+            beforeSend: ( xhr ) =>
+                xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
+            success: (
+                response // eslint-disable-line no-unused-vars
+            ) =>
+                ( window.location =
+                    window.location.href + '&tracking_reset=true' ),
+            error: ( response ) =>
+                console.error( 'Failed to reset tracking.', response ), // eslint-disable-line no-console
+        } );
+    } );
+
+    /**
+     * Handles the table actions (add-autoload, remove-autoload, delete-option).
+     *
+     * @param {Event} e - The click event.
+     */
+    function handleTableActions( e ) {
+        e.preventDefault();
+        const button = jQuery( this );
+        const table = button.closest( 'table' ).DataTable();
+        const optionName = button.data( 'option' );
+
+        const requestData = { option_name: optionName };
+        let action = '';
+        let route = '';
+
+        if ( button.hasClass( 'create-option-false' ) ) {
+            action = route = 'create-option-false';
+        } else if ( button.hasClass( 'delete-option' ) ) {
+            action = route = 'delete-option';
+        } else {
+            action = button.hasClass( 'add-autoload' )
+                ? 'add-autoload'
+                : 'remove-autoload';
+            route = 'update-autoload';
+            requestData.autoload = action === 'add-autoload' ? 'yes' : 'no';
+        }
+
+        jQuery.ajax( {
+            url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/' + route,
+            method: 'POST',
+            beforeSend: ( xhr ) =>
+                xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
+            data: requestData,
+            success: ( response ) =>
+                updateRowOnSuccess( response, table, optionName, action ),
+            error: ( response ) =>
+                // eslint-disable-next-line no-console
+                console.error(
+                    'Failed to ' + action + ' for ' + optionName + '.',
+                    response
+                ),
+        } );
+    }
+
+    /**
+     * Updates the row on successful AJAX response.
+     *
+     * @param {Object}    response   - The AJAX response.
+     * @param {DataTable} table      - The DataTable instance.
+     * @param {string}    optionName - The option name.
+     * @param {string}    action     - The action performed.
+     */
+    function updateRowOnSuccess( response, table, optionName, action ) {
+        // Get the row ID for the option name.
+        const rowId = generateRowId( optionName );
+        if ( action === 'delete-option' || action === 'create-option-false' ) {
+            table
+                .row( 'tr#' + rowId )
+                .remove()
+                .draw( 'full-hold' );
+        } else if (
+            action === 'add-autoload' ||
+            action === 'remove-autoload'
+        ) {
+            const autoloadStatus = action === 'add-autoload' ? 'yes' : 'no';
+            const buttonHTML =
+                action === 'add-autoload'
+                    ? '<button class="button dashicon remove-autoload" data-option="' +
+                      optionName +
+                      '"><span class="dashicons dashicons-minus"></span>' +
+                      aaaOptionOptimizer.i18n.removeAutoload +
+                      '</button>'
+                    : '<button class="button dashicon add-autoload" data-option="' +
+                      optionName +
+                      '"><span class="dashicons dashicons-plus"></span>' +
+                      aaaOptionOptimizer.i18n.addAutoload +
+                      '</button>';
+
+            jQuery( 'tr#' + rowId )
+                .find( 'td.autoload' )
+                .text( autoloadStatus );
+            const oldButton =
+                'button.' +
+                ( action === 'add-autoload' ? 'add' : 'remove' ) +
+                '-autoload';
+            jQuery( 'tr#' + rowId + ' ' + oldButton ).replaceWith( buttonHTML );
+        }
+    }
+
+    // AJAX Event Handling (add-autoload, remove-autoload, delete-option).
+    jQuery( 'table tbody' ).on(
+        'click',
+        '.add-autoload, .remove-autoload, .delete-option, .create-option-false',
+        handleTableActions
+    );
+
+    // Select all options.
+    jQuery( '.select-all-checkbox' ).on( 'change', function () {
+        const table = jQuery( this ).closest( 'table' );
+        const selectValue = jQuery( this ).prop( 'checked' );
+        const selectedOptions = table.find( 'input.select-option' );
+        selectedOptions.prop( 'checked', selectValue );
+    } );
+
+    // Generates bulk actions form for DataTable.
+    function getBulkActionsForm( selector, options ) {
+        return function () {
+            const container = jQuery( this.api().table().container() );
+
+            const form = jQuery(
+                '<form class="aaaoo-bulk-form" action="#" method="post" style="display:flex;gap:10px;"></form>'
+            );
+
+            let selectOptions = '';
+
+            if ( options.includes( 'autoload-on' ) ) {
+                selectOptions =
+                    '<option value="autoload-on">' +
+                    aaaOptionOptimizer.i18n.addAutoload +
+                    '</option>';
             }
 
-            return commonColumns;
-        }
-
-        /**
-         * Sets up the column filters for the DataTable.
-         */
-        function setupColumnFilters() {
-            const column = this;
-            const select = document.createElement( 'select' );
-            select.add( new Option( aaaOptionOptimizer.i18n.filterBySource, '', true, true ) );
-            column.footer().replaceChildren( select );
-
-            select.addEventListener(
-                'change',
-                function () {
-                    column.search( select.value, { exact: true } ).draw();
-                }
+            if ( options.includes( 'autoload-off' ) ) {
+                selectOptions +=
+                    '<option value="autoload-off">' +
+                    aaaOptionOptimizer.i18n.removeAutoload +
+                    '</option>';
+            }
+
+            const select = jQuery(
+                '<select class="aaaoo-bulk-select"><option value="">' +
+                    aaaOptionOptimizer.i18n.bulkActions +
+                    selectOptions +
+                    '</option><option value="delete">' +
+                    aaaOptionOptimizer.i18n.delete +
+                    '</option></select>'
             );
 
-            column.data().unique().sort().each(
-                function (d) {
-                    select.add( new Option( d ) );
-                }
+            const button = jQuery(
+                '<button type="submit" class="button aaaoo-apply-bulk-action" data-table="' +
+                    selector +
+                    '">' +
+                    aaaOptionOptimizer.i18n.apply +
+                    '</button>'
             );
-        }
-
-        /**
-         * Renders the value column for a row.
-         *
-         * @param {Object} row - The row data.
-         *
-         * @returns {string} - The HTML for the value column.
-         */
-        function renderValueColumn(row) {
-            const popoverContent = '<div id="popover_' + row.name + '" popover class="aaa-option-optimizer-popover">' +
-            '<button class="aaa-option-optimizer-popover__close" popovertarget="popover_' + row.name + '" popovertargetaction="hide">X</button>' +
-            '<p><strong>Value of <code>' + row.name + '</code></strong></p>' +
-            '<pre>' + row.value + '</pre>' +
-            '</div>';
-
-            const actions = [
-                '<button class="button dashicon" popovertarget="popover_' + row.name + '"><span class="dashicons dashicons-search"></span>' + aaaOptionOptimizer.i18n.showValue + '</button>',
-                popoverContent,
-                row.autoload === 'no' ?
-                    '<button class="button dashicon add-autoload" data-option="' + row.name + '"><span class="dashicons dashicons-plus"></span>' + aaaOptionOptimizer.i18n.addAutoload + '</button>' :
-                    '<button class="button dashicon remove-autoload" data-option="' + row.name + '"><span class="dashicons dashicons-minus"></span>' + aaaOptionOptimizer.i18n.removeAutoload + '</button>',
-                    '<button class="button button-delete delete-option" data-option="' + row.name + '"><span class="dashicons dashicons-trash"></span>' + aaaOptionOptimizer.i18n.deleteOption + '</button >'
-            ];
-
-            return actions.join( '' );
-        }
-
-        $( '#aaa-option-reset-data' ).on(
-            'click',
-            function (e) {
-                e.preventDefault();
-                $.ajax(
-                    {
-                        url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/reset',
-                        method: 'POST',
-                        beforeSend: xhr => xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
-                        success: response => window.location = window.location.href + '&tracking_reset=true',
-                        error: response => console.error(
-                            'Failed to reset tracking.',
-                            response
-                        )
-                    }
-                );
+
+            form.append( select, button );
+
+            // Add the form to the .dt-start cell
+            container.find( '.dt-layout-cell.dt-start ' ).prepend( form );
+
+            // Move .dt-length to .dt-layout-cell.dt-end
+            // const lengthSelector = container.find(".dt-length"); // same as div.dt-length
+            // const targetEndCell = container.find(".dt-layout-cell.dt-end");
+            // if (lengthSelector.length && targetEndCell.length) {
+            //  targetEndCell.append(lengthSelector);
+            // }
+        };
+    }
+
+    // Apply bulk action.
+    jQuery( '.aaa-option-optimizer-tabs' ).on(
+        'click',
+        '.aaaoo-apply-bulk-action',
+        function ( e ) {
+            e.preventDefault();
+            const button = jQuery( this );
+            const select = jQuery( button ).siblings( '.aaaoo-bulk-select' );
+            const bulkAction = select.val();
+            const table = jQuery( button.data( 'table' ) );
+            const selectedOptions = table.find( 'input.select-option:checked' );
+
+            if ( ! bulkAction ) {
+                alert( aaaOptionOptimizer.i18n.noBulkActionSelected ); // eslint-disable-line no-alert
+                return;
             }
-        );
-
-        /**
-         * Handles the table actions (add-autoload, remove-autoload, delete-option).
-         *
-         * @param {Event} e - The click event.
-         */
-        function handleTableActions(e) {
-            e.preventDefault();
-            const button     = $( this );
-            const table      = button.closest( 'table' ).DataTable();
-            const optionName = button.data( 'option' );
-
-            let requestData = { option_name: optionName };
-            let action      = '';
-            let route       = '';
-
-            if ( button.hasClass( 'create-option-false' ) ) {
-                action = route = 'create-option-false';
-            } else if ( button.hasClass( 'delete-option' ) ) {
-                action = route = 'delete-option';
+
+            if ( selectedOptions.length === 0 ) {
+                alert( aaaOptionOptimizer.i18n.noOptionsSelected ); // eslint-disable-line no-alert
+                return;
+            }
+
+            // For now we only have delete in bulk action.
+
+            const requestData = {
+                option_names: Array.from( selectedOptions ).map( ( option ) =>
+                    option.getAttribute( 'data-option' )
+                ),
+            };
+
+            if ( bulkAction === 'delete' ) {
+                endpoint = 'delete-options';
             } else {
-                action               = button.hasClass( 'add-autoload' ) ? 'add-autoload' : 'remove-autoload';
-                route                = 'update-autoload';
-                requestData.autoload = ( action === 'add-autoload' ) ? 'yes' : 'no';
+                endpoint = 'set-autoload-options';
+                requestData.autoload =
+                    bulkAction === 'autoload-on' ? 'yes' : 'no';
             }
 
-            $.ajax(
-                {
-                    url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/' + route,
-                    method: 'POST',
-                    beforeSend: xhr => xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
-                    data: requestData,
-                    success: response => updateRowOnSuccess( response, table, optionName, action ),
-                    error: response => console.error(
-                        'Failed to ' + action + ' for ' + optionName + '.',
-                        response
-                    )
-                }
-            );
-        }
-
-        /**
-         * Updates the row on successful AJAX response.
-         *
-         * @param {Object} response - The AJAX response.
-         * @param {DataTable} table - The DataTable instance.
-         * @param {string} optionName - The option name.
-         * @param {string} action - The action performed.
-         */
-        function updateRowOnSuccess(response, table, optionName, action) {
-            if ( action === 'delete-option' || action === 'create-option-false' ) {
-                table.row( 'tr#option_' + optionName ).remove().draw( 'full-hold' );
-            } else if ( action === 'add-autoload' || action === 'remove-autoload' ) {
-                const autoloadStatus = action === 'add-autoload' ? 'yes' : 'no';
-                const buttonHTML     = action === 'add-autoload' ?
-                '<button class="button dashicon remove-autoload" data-option="' + optionName + '"><span class="dashicons dashicons-minus"></span>' + aaaOptionOptimizer.i18n.removeAutoload + '</button>':
-                '<button class="button dashicon add-autoload" data-option="' + optionName + '"><span class="dashicons dashicons-plus"></span>' + aaaOptionOptimizer.i18n.addAutoload + '</button>';
-
-                $( 'tr#option_' + optionName ).find( 'td.autoload' ).text( autoloadStatus );
-                const oldButton = 'button.' + ( action === 'add-autoload' ? 'add' : 'remove' ) + '-autoload';
-                $( 'tr#option_' + optionName + ' ' + oldButton ).replaceWith( buttonHTML );
-            }
-        }
-
-        // AJAX Event Handling (add-autoload, remove-autoload, delete-option).
-        $( 'table tbody' ).on( 'click', '.add-autoload, .remove-autoload, .delete-option, .create-option-false', handleTableActions );
-
-        // Initialize data tables.
-        tablesToInitialize.forEach(
-            function (selector) {
-                if ($( selector ).length) {
-                    initializeDataTable( selector );
-                }
-            }
-        );
-    }
-);
+            jQuery.ajax( {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/' +
+                    endpoint,
+                method: 'POST',
+                beforeSend: ( xhr ) =>
+                    xhr.setRequestHeader(
+                        'X-WP-Nonce',
+                        aaaOptionOptimizer.nonce
+                    ),
+                data: requestData,
+                success: () => {
+                    const dt = table.DataTable();
+
+                    requestData.option_names.forEach( ( optionName ) => {
+                        dt.row( 'tr#option_' + optionName ).remove();
+                    } );
+
+                    dt.draw( 'full-hold' );
+
+                    // Clear the select-all checkbox.
+                    table
+                        .find( '.select-all-checkbox' )
+                        .prop( 'checked', false );
+                },
+                error: ( response ) => {
+                    // eslint-disable-next-line no-console
+                    console.error( 'Failed to delete options.', response );
+                },
+            } );
+        }
+    );
+
+    // Initialize data tables.
+    tablesToInitialize.forEach( function ( selector ) {
+        if ( jQuery( selector ).length ) {
+            initializeDataTable( selector );
+        }
+    } );
+} );

aaa-option-optimizer/tags/1.4.0/known-plugins/known-plugins.json

@@ -36 +36 @@
         "option_prefixes": ["chaty_"]
     },
+    "comment_hacks": {
+        "name": "Comment Experience by Progress Planner",
+        "option_prefixes": ["comment_hacks"]
+    },
     "complianz": {
         "name": "Complianz GDPR",
@@ -56 +60 @@
         "option_prefixes": ["elementor_"]
     },
+    "enhanced-e-commerce-for-woocommerce-store": {
+        "name": "Conversios: Google Analytics 4 (GA4), Google Ads, Microsoft Ads, and Multi-Channel Conversion Tracking",
+        "option_prefixes": ["ee_"]
+    },
     "fewer-tags": {
         "name": "Fewer Tags",
@@ -72 +80 @@
         "option_prefixes": ["yst_"]
     },
+    "google-site-kit": {
+        "name": "Site Kit by Google",
+        "option_prefixes": ["googlesitekit_"]
+    },
     "gravity-forms": {
         "name": "Gravity Forms",
         "option_prefixes": ["gf_","gforms_"]
     },
+    "woo-billing-with-invoicexpress": {
+        "name": "Invoicing with InvoiceXpress for WooCommerce",
+        "option_prefixes": ["hd_wc_ie_"]
+    },
     "indeed-membership-pro": {
         "name": "Indeed Ultimate Membership Pro",
@@ -90 +106 @@
     "litespeed-cache": {
         "name": "LiteSpeed Cache",
-        "option_prefixes": ["litespeed-", "_litespeed_"]
+        "option_prefixes": ["litespeed-", "_litespeed_", "litespeed."]
     },
     "loginizer": {
@@ -96 +112 @@
         "option_prefixes": ["loginizer_"]
     },
+    "multibanco-ifthen-software-gateway-for-woocommerce": {
+        "name": "Multibanco, MB WAY, Credit card, Apple Pay, Google Pay, Payshop, Cofidis Pay, and PIX (ifthenpay) for WooCommerce",
+        "option_prefixes": ["cofidispay_ifthen_", "creditcard_ifthen_", "gateway_ifthen_", "mbway_ifthen_", "multibanco_ifthen_", "payshop_"]
+    },
     "perfmatters": {
         "name": "Perfmatters",
@@ -112 +132 @@
         "option_prefixes": ["porto_"]
     },
+    "product-assembly-cost": {
+        "name": "Product Assembly / Gift Wrap / ... Cost for WooCommerce",
+        "option_prefixes": ["product_assembly_"]
+    },
+    "progress-planner": {
+        "name": "Progress Planner",
+        "option_prefixes": ["progress_planner_"]
+    },
     "really-simple-ssl": {
         "name": "Really Simple SSL",
@@ -132 +160 @@
         "option_prefixes": ["rank_math_"]
     },
+    "shop-as-client": {
+        "name": "Shop as Client for WooCommerce",
+        "option_prefixes": ["shop_as_client"]
+    },
+    "simple-woo-checkout-blocks-cf": {
+        "name": "Simple Checkout Fields Manager for WooCommerce",
+        "option_prefixes": ["swcbcf_"]
+    },
+    "simple-woocommerce-order-approval": {
+        "name": "Simple WooCommerce Order Approval",
+        "option_prefixes": ["swoa_"]
+    },
     "updraft": {
         "name": "Updraft Plus",
@@ -140 +180 @@
         "option_prefixes": ["wpseo", "yoast_"]
     },
+    "feed-kuantokusta-for-woocommerce": {
+        "name": "Feed KuantoKusta for WooCommerce",
+        "option_prefixes": ["wc_feed_kuantokusta_"]
+    },
+    "woo-dpd-pickup": {
+        "name": "DPD / Geopost Pickup and Lockers network for WooCommerce",
+        "option_prefixes": ["woo_dpd_pickup"]
+    },
+    "woo-dpd-portugal": {
+        "name": "DPD Portugal for WooCommerce",
+        "option_prefixes": ["woo_dpd_portugal"]
+    },
     "woocommerce": {
         "name": "WooCommerce",
         "option_prefixes": ["wc_", "_transient__woocommerce_", "woocommerce_"]
+    },
+    "woocommerce-max-quantity": {
+        "name": "Maximum Quantity for WooCommerce Shops",
+        "option_prefixes": ["isa_woocommerce_"]
     },
     "wordfence": {

aaa-option-optimizer/tags/1.4.0/readme.txt

@@ -5 +5 @@
 Tested up to: 6.8
 Requires PHP: 7.4
-Stable tag: 1.3.2
+Stable tag: 1.4.0
 License: GPL3+
 License URI: https://www.gnu.org/licenses/gpl-3.0.en.html
@@ -54 +54 @@
 
 == Changelog ==
+
+= 1.4.0 =
+
+* Performance improvements.
+* Added bulk-actions to allow optimizing & deleting options in bulk.
+* Added more known plugins.
 
 = 1.3.2 =

aaa-option-optimizer/tags/1.4.0/src/class-admin-page.php

@@ -14 +14 @@
 
     /**
-     * The map plugin to options class.
-     *
-     * @var Map_Plugin_To_Options
-     */
-    private $map_plugin_to_options;
-
-    /**
      * Register hooks.
      *
@@ -26 +19 @@
      */
     public function register_hooks() {
-        $this->map_plugin_to_options = new Map_Plugin_To_Options();
-
         // Register a link to the settings page on the plugins overview page.
         \add_filter( 'plugin_action_links', [ $this, 'filter_plugin_actions' ], 10, 2 );
@@ -71 +62 @@
             'manage_options',
             'aaa-option-optimizer',
-            [ $this, 'render_admin_page' ]
+            [ $this, 'render_admin_page_ajax' ]
         );
     }
@@ -124 +115 @@
                 'nonce' => wp_create_nonce( 'wp_rest' ),
                 'i18n'  => [
-                    'filterBySource' => esc_html__( 'Filter by source', 'aaa-option-optimizer' ),
-                    'showValue'      => esc_html__( 'Show', 'aaa-option-optimizer' ),
-                    'addAutoload'    => esc_html__( 'Add autoload', 'aaa-option-optimizer' ),
-                    'removeAutoload' => esc_html__( 'Remove autoload', 'aaa-option-optimizer' ),
-                    'deleteOption'   => esc_html__( 'Delete', 'aaa-option-optimizer' ),
-
-                    'search'         => esc_html__( 'Search:', 'aaa-option-optimizer' ),
-                    'entries'        => [
+                    'filterBySource'         => esc_html__( 'Filter by source', 'aaa-option-optimizer' ),
+                    'showValue'              => esc_html__( 'Show', 'aaa-option-optimizer' ),
+                    'addAutoload'            => esc_html__( 'Add autoload', 'aaa-option-optimizer' ),
+                    'removeAutoload'         => esc_html__( 'Remove autoload', 'aaa-option-optimizer' ),
+                    'deleteOption'           => esc_html__( 'Delete', 'aaa-option-optimizer' ),
+                    'createOptionFalse'      => esc_html__( 'Create option with value false', 'aaa-option-optimizer' ),
+                    'noAutoloadedButNotUsed' => esc_html__( 'All autoloaded options are in use.', 'aaa-option-optimizer' ),
+                    'noUsedButNotAutoloaded' => esc_html__( 'All options that are used are autoloaded.', 'aaa-option-optimizer' ),
+                    'noOptionsSelected'      => esc_html__( 'No options selected.', 'aaa-option-optimizer' ),
+                    'bulkActions'            => esc_html__( 'Bulk actions', 'aaa-option-optimizer' ),
+                    'noBulkActionSelected'   => esc_html__( 'No action selected.', 'aaa-option-optimizer' ),
+                    'delete'                 => esc_html__( 'Delete', 'aaa-option-optimizer' ),
+                    'apply'                  => esc_html__( 'Apply', 'aaa-option-optimizer' ),
+
+                    'search'                 => esc_html__( 'Search:', 'aaa-option-optimizer' ),
+                    'entries'                => [
                         '_' => \esc_html__( 'entries', 'aaa-option-optimizer' ),
                         '1' => \esc_html__( 'entry', 'aaa-option-optimizer' ),
                     ],
-                    'sInfo'          => sprintf(
+                    'sInfo'                  => sprintf(
                         // translators: %1$s is the start, %2$s is the end, %3$s is the total, %4$s is the entries.
                         esc_html__( 'Showing %1$s to %2$s of %3$s %4$s', 'aaa-option-optimizer' ),
@@ -143 +142 @@
                         '_ENTRIES-TOTAL_'
                     ),
-                    'sInfoEmpty'     => esc_html__( 'Showing 0 to 0 of 0 entries', 'aaa-option-optimizer' ),
-                    'sInfoFiltered'  => sprintf(
+                    'sInfoEmpty'             => esc_html__( 'Showing 0 to 0 of 0 entries', 'aaa-option-optimizer' ),
+                    'sInfoFiltered'          => sprintf(
                         // translators: %1$s is the max, %2$s is the entries-max.
                         esc_html__( '(filtered from %1$s total %2$s)', 'aaa-option-optimizer' ),
@@ -150 +149 @@
                         '_ENTRIES-MAX_'
                     ),
-                    'sZeroRecords'   => esc_html__( 'No matching records found', 'aaa-option-optimizer' ),
-                    'oAria'          => [
+                    'sZeroRecords'           => esc_html__( 'No matching records found', 'aaa-option-optimizer' ),
+                    'oAria'                  => [
                         'orderable'        => esc_html__( ': Activate to sort', 'aaa-option-optimizer' ),
                         'orderableReverse' => esc_html__( ': Activate to invert sorting', 'aaa-option-optimizer' ),
@@ -198 +197 @@
                     echo '<th class="source">' . esc_html__( 'Source', 'aaa-option-optimizer' ) . '</th>';
                     break;
+                case 'select-all':
+                    echo '<th class="select-all"><input type="checkbox" class="select-all-checkbox" /></th>';
+                    break;
             }
         }
@@ -205 +207 @@
 
     /**
-     * Get the length of a value.
-     *
-     * @param mixed $value The input value.
-     *
-     * @return string
-     */
-    private function get_length( $value ) {
-        if ( empty( $value ) ) {
-            return '0.00';
-        }
-        if ( is_array( $value ) || is_object( $value ) ) {
-            // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize -- intended here.
-            $length = strlen( serialize( $value ) );
-        } elseif ( is_string( $value ) || is_numeric( $value ) ) {
-            $length = strlen( strval( $value ) );
-        }
-        if ( ! isset( $length ) ) {
-            return '0.00';
-        }
-        return number_format( ( $length / 1024 ), 2 );
-    }
-
-    /**
      * Renders the admin page.
      *
      * @return void
      */
-    public function render_admin_page() {
+    public function render_admin_page_ajax() {
         $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
-        $all_options      = wp_load_alloptions();
-        // Filter out transients.
-        $autoload_options = array_filter(
-            $all_options,
-            function ( $value, $key ) {
-                return strpos( $key, '_transient_' ) === false;
-            },
-            ARRAY_FILTER_USE_BOTH
-        );
-
-        $unused_options         = [];
-        $non_autoloaded_options = [];
-
-        // Get the autoloaded options that aren't used.
-        foreach ( $autoload_options as $option => $value ) {
-            if ( isset( $option_optimizer['used_options'][ $option ] ) ) {
-                continue;
-            }
-            $unused_options[ $option ] = $value;
-        }
-
-        // Determine the options that _are_ used, but not auto-loaded.
-        foreach ( $option_optimizer['used_options'] as $option => $count ) {
-            if ( isset( $autoload_options[ $option ] ) ) {
-                continue;
-            }
-            $non_autoloaded_options[ $option ] = $count;
-        }
-
-        // Some of the options that are used but not auto-loaded, may not exist.
-        if ( ! empty( $non_autoloaded_options ) ) {
-            $options_that_do_not_exist   = [];
-            $non_autoloaded_options_full = [];
-            foreach ( $non_autoloaded_options as $option => $count ) {
-                $value = get_option( $option, 'aaa-no-return-value' );
-                if ( $value === 'aaa-no-return-value' ) {
-                    $options_that_do_not_exist[ $option ] = $count;
-                    continue;
-                }
-                $non_autoloaded_options_full[ $option ] = [
-                    'count' => $count,
-                    'value' => $value,
-                ];
-            }
-        }
 
         // Start HTML output.
@@ -322 +256 @@
         <?php
         echo '<h2 id="unused-autoloaded">' . esc_html__( 'Unused, but autoloaded', 'aaa-option-optimizer' ) . '</h2>';
-        if ( ! empty( $unused_options ) ) {
-            echo '<p>' . esc_html__( 'The following options are autoloaded on each pageload, but AAA Option Optimizer has not been able to detect them being used.', 'aaa-option-optimizer' );
-            echo '<table style="width:100%" id="unused_options_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $unused_options as $option => $value ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '"><td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td><span class="num">' . esc_html( $this->get_length( $value ) ) . '</span></td>';
-                echo '<td class="autoload">yes</td>';
-                echo '<td class="actions">';
-                // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- output escaped in get_value_button.
-                echo $this->get_value_button( $option, $value );
-                echo '<button class="button button-primary remove-autoload" data-option="' . esc_attr( $option ) . '"><span class="dashicons dashicons-minus"></span> ' . esc_html__( 'Remove autoload', 'aaa-option-optimizer' ) . '</button> ';
-                echo ' <button class="button button-delete delete-option" data-option="' . esc_attr( $option ) . '"><span class="dashicons dashicons-trash"></span> ' . esc_html__( 'Delete', 'aaa-option-optimizer' ) . '</button>';
-                echo '</td></tr>';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'actions' ] );
-            echo '</table>';
-        } else {
-            echo '<p>' . esc_html__( 'All autoloaded options are in use.', 'aaa-option-optimizer' ) . '</p>';
-        }
-        ?>
+        echo '<p>' . esc_html__( 'The following options are autoloaded on each pageload, but AAA Option Optimizer has not been able to detect them being used.', 'aaa-option-optimizer' );
+        echo '<table style="width:100%" id="unused_options_table" class="aaa_option_table">';
+        $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] );
+        ?>
+        <tbody>
+        <tr>
+            <td class="select-all"></td>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td class="actions"></td>
+        </tr>
+        </tbody>
+        <?php
+        $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] );
+        ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-2"/>
@@ -352 +280 @@
         <?php
         // Render differences.
-        if ( ! empty( $non_autoloaded_options ) ) {
             echo '<h2 id="used-not-autoloaded">' . esc_html__( 'Used, but not autoloaded options', 'aaa-option-optimizer' ) . '</h2>';
             echo '<p>' . esc_html__( 'The following options are *not* autoloaded on each pageload, but AAA Option Optimizer has detected that they are being used. If one of the options below has been called a lot and is not very big, you might consider adding autoload to that option.', 'aaa-option-optimizer' );
             echo '<table style="width:100%;" id="used_not_autoloaded_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $non_autoloaded_options_full as $option => $arr ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '">';
-                echo '<td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td><span class="num">' . esc_html( $this->get_length( $arr['value'] ) ) . '</span></td>';
-                echo '<td class="autoload">no</td>';
-                echo '<td>' . esc_html( $arr['count'] ) . '</td>';
-                echo '<td class="actions">';
-                // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- output escaped in get_value_button.
-                echo $this->get_value_button( $option, $arr['value'] );
-                echo '<button class="button button-primary add-autoload" data-option="' . esc_attr( $option ) . '">' . esc_html__( 'Add autoload', 'aaa-option-optimizer' ) . '</button> ';
-                echo '</td></tr>';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
-            echo '</table>';
-        } else {
-            echo '<p>' . esc_html__( 'All options that are used are autoloaded.', 'aaa-option-optimizer' ) . '</p>';
-        }
-        ?>
+            $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
+        ?>
+            <tbody>
+            <tr>
+                <td class="select-all"></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td class="actions"></td>
+            </tr>
+            </tbody>
+            <?php $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] ); ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-3"/>
@@ -383 +303 @@
             <div class="panel">
         <?php
-        if ( ! empty( $options_that_do_not_exist ) ) {
-            echo '<h2 id="requested-do-not-exist">' . esc_html__( 'Requested options that do not exist', 'aaa-option-optimizer' ) . '</h2>';
-            echo '<p>' . esc_html__( 'The following options are requested sometimes, but AAA Option Optimizer has detected that they do not exist. If one of the options below has been called a lot, it might help to create it with a value of false.', 'aaa-option-optimizer' );
-            echo '<table width="100%" id="requested_do_not_exist_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'calls', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $options_that_do_not_exist as $option => $count ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '">';
-                echo '<td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td>' . esc_html( $count ) . '</td>';
-                echo '<td class="actions"><button class="button button-primary create-option-false" data-option="' . esc_attr( $option ) . '">' . esc_html__( 'Create option with value false', 'aaa-option-optimizer' ) . '</button> ';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'calls', 'actions' ] );
-            echo '</table>';
-        }
-        ?>
+        echo '<h2 id="requested-do-not-exist">' . esc_html__( 'Requested options that do not exist', 'aaa-option-optimizer' ) . '</h2>';
+        echo '<p>' . esc_html__( 'The following options are requested sometimes, but AAA Option Optimizer has detected that they do not exist. If one of the options below has been called a lot, it might help to create it with a value of false.', 'aaa-option-optimizer' );
+        echo '<table width="100%" id="requested_do_not_exist_table" class="aaa_option_table">';
+        $this->table_section( 'thead', [ 'option', 'source', 'calls', 'actions' ] );
+        ?>
+        <tbody>
+        <tr>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td class="actions"></td>
+        </tr>
+        </tbody>
+        <?php
+        $this->table_section( 'tfoot', [ 'option', 'source', 'calls', 'actions' ] );
+        ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-4"/>
@@ -408 +327 @@
             <button id="aaa_get_all_options" class="button button-primary"><?php esc_html_e( 'Get all options', 'aaa-option-optimizer' ); ?></button>
             <table class="aaa_option_table" id="all_options_table" style="display:none;">
-                <?php $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
+                <?php $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
                 <tbody>
                     <tr>
+                        <td class="select-all"></td>
                         <td></td>
                         <td></td>
@@ -416 +336 @@
                         <td></td>
                         <td class="actions"></td>
-                    </tr>   
+                    </tr>
                 </tbody>
-                <?php $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
+                <?php $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
             </table>
         </div>
@@ -424 +344 @@
         <?php
     }
-
-    /**
-     * Get html to show a popover.
-     *
-     * @param string $name  The name of the option, used in the id of the popover.
-     * @param mixed  $value The value to show.
-     *
-     * @return string
-     */
-    private function get_value_button( string $name, $value ): string {
-        $string = is_string( $value ) ? $value : wp_json_encode( $value );
-        $id     = 'aaa-option-optimizer-' . esc_attr( $name );
-        return '
-        <button class="button" popovertarget="' . $id . '"><span class="dashicons dashicons-search"></span> ' . esc_html__( 'Show', 'aaa-option-optimizer' ) . '</button>
-        <div id="' . $id . '" popover class="aaa-option-optimizer-popover">
-        <button class="aaa-option-optimizer-popover__close" popovertarget="' . $id . '" popovertargetaction="hide">X</button>' .
-        // translators: %s is the name of the option.
-        '<p><strong>' . sprintf( esc_html__( 'Value of %s', 'aaa-option-optimizer' ), '<code>' . esc_html( $name ) . '</code>' ) . '</strong></p>
-        <pre>' . htmlentities( $string, ENT_QUOTES | ENT_SUBSTITUTE ) . '</pre>
-        </div>';
-    }
-
-    /**
-     * Find plugin in known plugin prefixes list.
-     *
-     * @param string $option The option name.
-     *
-     * @return string
-     */
-    private function get_plugin_name( $option ) {
-        return $this->map_plugin_to_options->get_plugin_name( $option );
-    }
 }

aaa-option-optimizer/tags/1.4.0/src/class-rest.php

@@ -122 +122 @@
             ]
         );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/unused-options',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_unused_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/used-not-autoloaded-options',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_used_not_autoloaded_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/options-that-do-not-exist',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_options_that_do_not_exist' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/delete-options',
+            [
+                'methods'             => 'POST',
+                'callback'            => [ $this, 'delete_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/set-autoload-options',
+            [
+                'methods'             => 'POST',
+                'callback'            => [ $this, 'set_autoload_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
     }
 
@@ -148 +208 @@
             $output[] = [
                 'name'     => $option->option_name,
-                'plugin'   => $this->map_plugin_to_options->get_plugin_name( $option->option_name ),
+                'plugin'   => $this->get_plugin_name( $option->option_name ),
                 'value'    => htmlentities( $option->option_value, ENT_QUOTES | ENT_SUBSTITUTE ),
-                'size'     => number_format( strlen( $option->option_value ) / 1024, 2 ),
+                'size'     => $this->get_length( $option->option_value ),
+                'raw_size' => strlen( $option->option_value ),
                 'autoload' => $option->autoload,
-                'row_id'   => 'option_' . $option->option_name,
             ];
         }
         return new \WP_REST_Response( [ 'data' => $output ], 200 );
+    }
+
+    /**
+     * Get unused options.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_unused_options() {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options from option_optimizer.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        $query = "
+            SELECT option_name
+            FROM {$wpdb->options}
+            WHERE autoload IN ( '" . implode( "', '", esc_sql( \wp_autoload_values_to_autoload() ) ) . "' )
+            AND option_name NOT LIKE '%_transient_%'
+        ";
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $query .= " AND option_name LIKE '%" . esc_sql( $search ) . "%'";
+        }
+
+        // Get autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            $query // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
+        );
+
+        // Find unused autoloaded option names.
+        $autoload_option_keys = array_fill_keys( $autoloaded_option_names, true );
+        $unused_keys          = array_diff_key( $autoload_option_keys, $used_options );
+        $total_unused         = count( $unused_keys );
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+        $paged_option_names = array_keys( $unused_keys );
+
+        // Optimize by slicing early for default sort, since we can sort $autoloaded_option_names in advance.
+        if ( 'name' === $order_column && SORT_ASC === $order_dir ) {
+            $paged_option_names = array_slice( $paged_option_names, $offset, $limit );
+        }
+
+        $response_data = [];
+
+        if ( ! empty( $paged_option_names ) ) {
+            $placeholders = implode( ',', array_fill( 0, count( $paged_option_names ), '%s' ) );
+            $value_query  = "
+                SELECT option_name, option_value
+                FROM {$wpdb->options}
+                WHERE option_name IN ( {$placeholders} )
+            ";
+
+            $results = $wpdb->get_results( $wpdb->prepare( $value_query, ...$paged_option_names ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
+
+            // Format output.
+            foreach ( $results as $row ) {
+                $response_data[] = [
+                    'name'     => $row->option_name,
+                    'plugin'   => $this->get_plugin_name( $row->option_name ),
+                    'value'    => htmlentities( $row->option_value, ENT_QUOTES | ENT_SUBSTITUTE ),
+                    'size'     => $this->get_length( $row->option_value ),
+                    'raw_size' => strlen( $row->option_value ),
+                    'autoload' => 'yes',
+                ];
+            }
+
+            // Sorting, skip if "name" column is sorted in ascending order since that is the default.
+            if ( ! ( 'name' === $order_column && SORT_ASC === $order_dir ) ) {
+                $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+
+                // Now we can slice after sort.
+                $response_data = array_slice( $response_data, $offset, $limit );
+            }
+        }
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_unused,
+                'recordsFiltered' => $total_unused,
+                'data'            => $response_data,
+            ],
+            200
+        );
+    }
+
+    /**
+     * Get used, but not autoloaded options.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_used_not_autoloaded_options() {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options from option_optimizer.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        if ( empty( $used_options ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Get all autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
+            "
+                SELECT option_name
+                FROM {$wpdb->options}
+                WHERE autoload IN ( '" . implode( "', '", esc_sql( wp_autoload_values_to_autoload() ) ) . "' )
+                AND option_name NOT LIKE '%_transient_%'
+                ORDER BY option_name ASC
+            "
+        );
+        $autoload_option_keys    = array_fill_keys( $autoloaded_option_names, true );
+
+        // Find used options that are not autoloaded.
+        $non_autoloaded_used_keys = array_diff_key( $used_options, $autoload_option_keys );
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $non_autoloaded_used_keys = array_filter(
+                $non_autoloaded_used_keys,
+                function ( $option_name ) use ( $search ) {
+                    return false !== stripos( $option_name, $search );
+                },
+                ARRAY_FILTER_USE_KEY
+            );
+        }
+
+        if ( empty( $non_autoloaded_used_keys ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+
+        // We can't slice early here, because we can't sort $used_options in advance.
+        $paged_option_names = array_keys( $non_autoloaded_used_keys );
+
+        $response_data = [];
+
+        // $paged_option_names is not empty.
+        // Fetch values directly from DB without using get_option().
+        $placeholders = implode( ',', array_fill( 0, count( $paged_option_names ), '%s' ) );
+        $sql          = "
+            SELECT option_name, option_value
+            FROM {$wpdb->options}
+            WHERE option_name IN ( {$placeholders} )"; // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+
+        $results = $wpdb->get_results( $wpdb->prepare( $sql, ...$paged_option_names ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+
+        foreach ( $results as $row ) {
+            $response_data[] = [
+                'name'     => $row->option_name,
+                'plugin'   => $this->get_plugin_name( $row->option_name ),
+                'value'    => htmlentities( maybe_serialize( $row->option_value ), ENT_QUOTES | ENT_SUBSTITUTE ),
+                'size'     => $this->get_length( $row->option_value ),
+                'raw_size' => strlen( $row->option_value ),
+                'autoload' => 'no',
+                'count'    => $used_options[ $row->option_name ] ?? 0,
+            ];
+        }
+
+        $total_filtered = count( $response_data );
+
+        // Sort and slice after.
+        $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+        $response_data = array_slice( $response_data, $offset, $limit );
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_filtered,
+                'recordsFiltered' => $total_filtered,
+                'data'            => $response_data,
+            ],
+            200
+        );
+    }
+
+    /**
+     * Get options that do not exist.
+     * Some of the options that are used but not auto-loaded, may not exist.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_options_that_do_not_exist() {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        if ( empty( $used_options ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Get autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            "
+            SELECT option_name
+            FROM {$wpdb->options}
+            WHERE autoload IN ('yes', 'on', 'true', '1')
+            AND option_name NOT LIKE '%_transient_%'
+        "
+        );
+        $autoload_option_keys    = array_fill_keys( $autoloaded_option_names, true );
+
+        // Get used options that are not autoloaded.
+        $non_autoloaded_keys = array_diff_key( $used_options, $autoload_option_keys );
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $non_autoloaded_keys = array_filter(
+                $non_autoloaded_keys,
+                function ( $option_name ) use ( $search ) {
+                    return stripos( $option_name, $search ) !== false;
+                },
+                ARRAY_FILTER_USE_KEY
+            );
+        }
+
+        if ( empty( $non_autoloaded_keys ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Check which of them actually exist in the options table.
+        $option_names = array_keys( $non_autoloaded_keys );
+        $placeholders = implode( ',', array_fill( 0, count( $option_names ), '%s' ) );
+
+        $existing_option_names = $wpdb->get_col(  // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            $wpdb->prepare(
+                "SELECT option_name FROM {$wpdb->options} WHERE option_name IN ($placeholders)", // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
+                ...$option_names
+            )
+        );
+        $existing_keys         = array_fill_keys( $existing_option_names, true );
+
+        // Filter only those that do NOT exist.
+        $response_data = [];
+        foreach ( $non_autoloaded_keys as $option => $count ) {
+            if ( ! isset( $existing_keys[ $option ] ) ) {
+                $response_data[] = [
+                    'name'        => $option,
+                    'plugin'      => $this->get_plugin_name( $option ),
+                    'count'       => $count,
+                    'option_name' => $option,
+                ];
+            }
+        }
+
+        $total_filtered = count( $response_data );
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Sort and slice after.
+        $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+        $response_data = array_slice( $response_data, $offset, $limit );
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_filtered,
+                'recordsFiltered' => $total_filtered,
+                'data'            => $response_data,
+            ],
+            200
+        );
     }
 
@@ -208 +601 @@
 
     /**
+     * Delete multiple options.
+     *
+     * @param \WP_REST_Request $request The REST request object.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function delete_options( $request ) {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        $option_names = $request['option_names'];
+        foreach ( $option_names as $option_name ) {
+            delete_option( $option_name );
+        }
+        return new \WP_REST_Response( [ 'success' => true ], 200 );
+    }
+
+    /**
+     * Set autoload status of multiple options.
+     *
+     * @param \WP_REST_Request $request The REST request object.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function set_autoload_options( $request ) {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        $autoload = \sanitize_text_field( \wp_unslash( $request['autoload'] ) );
+
+        if ( ! in_array( $autoload, [ 'yes', 'on', 'no', 'off','auto', 'auto-on', 'auto-off' ], true ) ) {
+            return new \WP_Error( 'invalid_autoload_value', 'Invalid autoload value', [ 'status' => 400 ] );
+        }
+
+        $autoload_values = \wp_autoload_values_to_autoload();
+        $bool_autoload   = false;
+        if ( in_array( $autoload, $autoload_values, true ) ) {
+            $bool_autoload = true;
+        }
+
+        $option_names = $request['option_names'];
+
+        foreach ( $option_names as $option_name ) {
+            $option_value = get_option( $option_name );
+
+            // If the option does not exist, skip it.
+            if ( false === $option_value ) {
+                continue;
+            }
+
+            delete_option( $option_name );
+            add_option( $option_name, $option_value, '', $bool_autoload );
+        }
+        return new \WP_REST_Response( [ 'success' => true ], 200 );
+    }
+
+    /**
      * Create an option with a false value.
      *
@@ -221 +673 @@
         return new \WP_Error( 'option_not_created', 'Option could not be created', [ 'status' => 400 ] );
     }
+
+    /**
+     * Sort response data array by given column and direction.
+     *
+     * @param array<int, array<string, mixed>> $data        The data array to sort.
+     * @param string                           $column      The column key to sort by.
+     * @param int                              $direction   SORT_ASC or SORT_DESC.
+     *
+     * @return array<int, array<string, mixed>> The sorted array.
+     */
+    protected function sort_response_data_by_column( array $data, string $column, int $direction ): array {
+
+        usort(
+            $data,
+            function ( $a, $b ) use ( $column, $direction ) {
+                $val_a = $a[ "raw_$column" ] ?? $a[ $column ] ?? '';
+                $val_b = $b[ "raw_$column" ] ?? $b[ $column ] ?? '';
+
+                if ( is_numeric( $val_a ) && is_numeric( $val_b ) ) {
+                    $val_a = floatval( $val_a );
+                    $val_b = floatval( $val_b );
+
+                    return $direction === SORT_DESC ? $val_b <=> $val_a : $val_a <=> $val_b;
+                }
+
+                return $direction === SORT_DESC
+                    ? strnatcasecmp( $val_b, $val_a )
+                    : strnatcasecmp( $val_a, $val_b );
+            }
+        );
+
+        return $data;
+    }
+
+    /**
+     * Get pagination parameters from $_GET.
+     *
+     * @return array{0: int, 1: int} {
+     *     @type int $offset Pagination offset.
+     *     @type int $limit  Number of items per page.
+     * }
+     */
+    protected function get_pagination_params(): array {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return [ 0, 25 ]; // Fallback default.
+        }
+
+        $offset = isset( $_GET['start'] ) ? intval( $_GET['start'] ) : 0;
+        $limit  = isset( $_GET['length'] ) ? intval( $_GET['length'] ) : 25;
+
+        return [ $offset, $limit ];
+    }
+
+    /**
+     * Get sort column and direction from DataTables-style request.
+     *
+     * @return array{0: string, 1: int} [ string $column, int $direction (SORT_ASC|SORT_DESC) ]
+     */
+    public function get_sort_params(): array {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return [ 'name', SORT_ASC ]; // Fallback default.
+        }
+
+        if (
+            ! isset( $_GET['order'][0]['column'], $_GET['columns'] )
+            || ! is_array( $_GET['columns'] )
+            || ! isset( $_GET['columns'][ $_GET['order'][0]['column'] ]['data'] )
+        ) {
+            return [ 'name', SORT_ASC ]; // Fallback default.
+        }
+
+        $column_index = isset( $_GET['order'][0]['column'] ) ? intval( $_GET['order'][0]['column'] ) : 0;
+        $column_data  = isset( $_GET['columns'][ $column_index ]['data'] ) ? \sanitize_text_field( \wp_unslash( $_GET['columns'][ $column_index ]['data'] ) ) : 'name';
+
+        $dir      = strtolower( \sanitize_text_field( \wp_unslash( $_GET['order'][0]['dir'] ?? 'asc' ) ) );
+        $dir_flag = $dir === 'desc' ? SORT_DESC : SORT_ASC;
+
+        return [ $column_data, $dir_flag ];
+    }
+
+    /**
+     * Get the length of a value.
+     *
+     * @param mixed $value The input value.
+     *
+     * @return string
+     */
+    private function get_length( $value ) {
+        if ( empty( $value ) ) {
+            return '0.00';
+        }
+        if ( is_array( $value ) || is_object( $value ) ) {
+            // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize -- intended here.
+            $length = strlen( serialize( $value ) );
+        } elseif ( is_string( $value ) || is_numeric( $value ) ) {
+            $length = strlen( strval( $value ) );
+        }
+        if ( ! isset( $length ) ) {
+            return '0.00';
+        }
+        return number_format( ( $length / 1024 ), 2 );
+    }
+
+    /**
+     * Find plugin in known plugin prefixes list.
+     *
+     * @param string $option The option name.
+     *
+     * @return string
+     */
+    private function get_plugin_name( $option ) {
+        return $this->map_plugin_to_options->get_plugin_name( $option );
+    }
 }

aaa-option-optimizer/trunk/aaa-option-optimizer.php

@@ -8 +8 @@
  * Plugin URI: https://joost.blog/plugins/aaa-option-optimizer/
  * Description: Tracks autoloaded options usage and allows the user to optimize them.
- * Version: 1.3.2
+ * Version: 1.4.0
  * License: GPL-3.0+
  * Author: Joost de Valk

aaa-option-optimizer/trunk/css/style.css

@@ -3 +3 @@
     border-spacing: 0;
 }
+.aaa-option-optimizer-tabs .dt-layout-cell.dt-start:has(.dt-length) {
+    display: flex;
+    justify-content: flex-start;
+    gap: 20px;
+}
+
 .aaa_option_table td, .aaa_option_table th {
     padding: 5px 10px 5px 5px;

aaa-option-optimizer/trunk/js/admin-script.js

@@ +1 @@
+/* global jQuery, aaaOptionOptimizer, Option, DataTable, alert */
+
 /**
  * JavaScript for the admin page.
  *
- * @package Emilia\OptionOptimizer
+ * @package
  */
 
@@ -8 +10 @@
  * Initializes the data tables and sets up event handlers.
  */
-jQuery( document ).ready(
-    function ($) {
-        /**
-         * Array of table selectors to initialize.
-         *
-         * @type {string[]}
-         */
-        const tablesToInitialize = [
-            '#unused_options_table',
-            '#used_not_autoloaded_table',
-            '#requested_do_not_exist_table',
+jQuery( document ).ready( function () {
+    /**
+     * Array of table selectors to initialize.
+     *
+     * @type {string[]}
+     */
+    const tablesToInitialize = [
+        '#unused_options_table',
+        '#used_not_autoloaded_table',
+        '#requested_do_not_exist_table',
+    ];
+
+    jQuery( '#all_options_table' ).hide();
+    jQuery( '#aaa_get_all_options' ).on( 'click', function ( e ) {
+        e.preventDefault();
+        jQuery( '#all_options_table' ).show();
+        initializeDataTable( '#all_options_table' );
+        jQuery( this ).hide();
+    } );
+
+    /**
+     * Generate row ID for an option name.
+     *
+     * @param {string} optionName - The option name.
+     * @return {string} The row ID.
+     */
+    function generateRowId( optionName ) {
+        return 'option_' + optionName.replace( /\./g, '_' );
+    }
+
+    /**
+     * Initializes the DataTable for the given selector.
+     *
+     * @param {string} selector - The table selector.
+     */
+    function initializeDataTable( selector ) {
+        const options = {
+            pageLength: 25,
+            autoWidth: false,
+            responsive: true,
+            columns: getColumns( selector ),
+            rowId( data ) {
+                return generateRowId( data.name );
+            },
+            initComplete() {
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            },
+            language: aaaOptionOptimizer.i18n,
+        };
+
+        if ( selector === '#unused_options_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/unused-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+            ( options.language = {
+                sZeroRecords: aaaOptionOptimizer.i18n.noAutoloadedButNotUsed,
+            } ),
+                ( options.initComplete = function () {
+                    getBulkActionsForm( selector, [ 'autoload-off' ] ).call(
+                        this
+                    );
+                    this.api()
+                        .columns( 'source:name' )
+                        .every( setupColumnFilters );
+                } );
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        if ( selector === '#used_not_autoloaded_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/used-not-autoloaded-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+            options.language = {
+                sZeroRecords: aaaOptionOptimizer.i18n.noUsedButNotAutoloaded,
+            };
+            options.initComplete = function () {
+                getBulkActionsForm( selector, [ 'autoload-on' ] ).call( this );
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            };
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        if ( selector === '#requested_do_not_exist_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/options-that-do-not-exist',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.serverSide = true;
+            options.processing = true;
+        }
+
+        if ( selector === '#all_options_table' ) {
+            options.ajax = {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/all-options',
+                headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
+                type: 'GET',
+                dataSrc: 'data',
+            };
+            options.initComplete = function () {
+                getBulkActionsForm( selector, [
+                    'autoload-on',
+                    'autoload-off',
+                ] ).call( this );
+                this.api().columns( 'source:name' ).every( setupColumnFilters );
+            };
+            options.order = [ [ 1, 'asc' ] ]; // Order by 2nd column, first column is checkbox.
+        }
+
+        new DataTable( selector, options ).columns.adjust().responsive.recalc();
+    }
+
+    /**
+     * Retrieves the columns configuration based on the selector.
+     *
+     * @param {string} selector - The table selector.
+     *
+     * @return {Object[]} - The columns configuration.
+     */
+    function getColumns( selector ) {
+        const commonColumns = [
+            {
+                name: 'checkbox',
+                data: 'name',
+                render: ( data, type, row ) => renderCheckboxColumn( row ),
+                orderable: false,
+                searchable: false,
+                className: 'select-all',
+            },
+            { name: 'name', data: 'name' },
+            { name: 'source', data: 'plugin' },
+            { name: 'size', data: 'size', searchable: false },
+            {
+                name: 'autoload',
+                data: 'autoload',
+                className: 'autoload',
+                searchable: false,
+                orderable: false,
+            },
+            {
+                name: 'value',
+                data: 'value',
+                render: ( data, type, row ) => renderValueColumn( row ),
+                orderable: false,
+                searchable: false,
+                className: 'actions',
+            },
         ];
-
-        $( '#all_options_table' ).hide();
-        $( '#aaa_get_all_options' ).on(
-            'click',
-            function (e) {
-                e.preventDefault();
-                $( '#all_options_table' ).show();
-                initializeDataTable( '#all_options_table' );
-                $( this ).hide();
-            }
-        );
-
-        /**
-         * Initializes the DataTable for the given selector.
-         *
-         * @param {string} selector - The table selector.
-         */
-        function initializeDataTable(selector) {
-            const options = {
-                pageLength: 25,
-                autoWidth: false,
-                responsive: true,
-                columns: getColumns( selector ),
-                initComplete: function () {
-                    this.api().columns( 'source:name' ).every( setupColumnFilters );
-                }
-            };
-
-            if (selector === '#all_options_table') {
-                options.ajax  = {
-                    url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/all-options',
-                    headers: { 'X-WP-Nonce': aaaOptionOptimizer.nonce },
-                    type: 'GET',
-                    dataSrc: 'data'
-                };
-                options.rowId = 'row_id';
-            }
-
-            options.language = aaaOptionOptimizer.i18n;
-
-            const dataTable = new DataTable( selector, options ).columns.adjust().responsive.recalc();;
-        }
-
-        /**
-         * Retrieves the columns configuration based on the selector.
-         *
-         * @param {string} selector - The table selector.
-         *
-         * @returns {Object[]} - The columns configuration.
-         */
-        function getColumns(selector) {
-            const commonColumns = [
-                { name: 'name' },
-                { name: 'source' },
-                { name: 'size', searchable: false },
-                { name: 'autoload', className: 'autoload', searchable: false },
-                { name: 'actions', searchable: false, orderable: false }
+        if ( selector === '#requested_do_not_exist_table' ) {
+            return [
+                { name: 'option', data: 'name' },
+                { name: 'source', data: 'plugin', searchable: false },
+                { name: 'calls', data: 'count', searchable: false },
+                {
+                    name: 'option_name',
+                    data: 'option_name',
+                    render: ( data, type, row ) =>
+                        renderNonExistingOptionsColumn( row ),
+                    searchable: false,
+                    orderable: false,
+                    className: 'actions',
+                },
             ];
-
-            if (selector === '#requested_do_not_exist_table') {
-                return [
-                    { name: 'name' },
-                    { name: 'source', searchable: false },
-                    { name: 'calls', searchable: false },
-                    { name: 'actions', searchable: false, orderable: false }
-                ];
-            } else if (selector === '#used_not_autoloaded_table') {
-                return [
-                    { name: 'name' },
-                    { name: 'source' },
-                    { name: 'size', searchable: false },
-                    { name: 'autoload', className: 'autoload', searchable: false },
-                    { name: 'calls', searchable: false },
-                    { name: 'actions', searchable: false, orderable: false }
-                ]
-            } else if (selector === '#all_options_table') {
-                return [
+        } else if ( selector === '#used_not_autoloaded_table' ) {
+            return [
+                {
+                    name: 'checkbox',
+                    data: 'name',
+                    render: ( data, type, row ) => renderCheckboxColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'select-all',
+                },
                 { name: 'name', data: 'name' },
                 { name: 'source', data: 'plugin' },
+                { name: 'size', data: 'size', searchable: false },
+                {
+                    name: 'autoload',
+                    data: 'autoload',
+                    className: 'autoload',
+                    searchable: false,
+                    orderable: false,
+                },
+                { name: 'calls', data: 'count', searchable: false },
+                {
+                    name: 'value',
+                    data: 'value',
+                    render: ( data, type, row ) => renderValueColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'actions',
+                },
+            ];
+        } else if ( selector === '#all_options_table' ) {
+            return [
+                {
+                    name: 'checkbox',
+                    data: 'name',
+                    render: ( data, type, row ) => renderCheckboxColumn( row ),
+                    orderable: false,
+                    searchable: false,
+                    className: 'select-all',
+                },
+                { name: 'name', data: 'name' },
+                { name: 'source', data: 'plugin' },
                 {
                     name: 'size',
                     data: 'size',
                     searchable: false,
-                    render: data => '<span class="num">' + data + '</span>'
-                },
-                { name: 'autoload', data: 'autoload', className: 'autoload', searchable: false },
+                    render: ( data ) => '<span class="num">' + data + '</span>',
+                },
+                {
+                    name: 'autoload',
+                    data: 'autoload',
+                    className: 'autoload',
+                    searchable: false,
+                },
                 {
                     name: 'value',
                     data: 'value',
-                    render: (data, type, row) => renderValueColumn( row ),
+                    render: ( data, type, row ) => renderValueColumn( row ),
                     orderable: false,
                     searchable: false,
-                    className: 'actions'
-                }
-                ];
+                    className: 'actions',
+                },
+            ];
+        }
+
+        return commonColumns;
+    }
+
+    /**
+     * Sets up the column filters for the DataTable.
+     */
+    function setupColumnFilters() {
+        const column = this;
+        const select = document.createElement( 'select' );
+        select.add(
+            new Option( aaaOptionOptimizer.i18n.filterBySource, '', true, true )
+        );
+        column.footer().replaceChildren( select );
+
+        select.addEventListener( 'change', function () {
+            column.search( select.value, { exact: true } ).draw();
+        } );
+
+        column
+            .data()
+            .unique()
+            .sort()
+            .each( function ( d ) {
+                select.add( new Option( d ) );
+            } );
+    }
+
+    /**
+     * Renders the value column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderValueColumn( row ) {
+        const popoverContent =
+            '<div id="popover_' +
+            row.name +
+            '" popover class="aaa-option-optimizer-popover">' +
+            '<button class="aaa-option-optimizer-popover__close" popovertarget="popover_' +
+            row.name +
+            '" popovertargetaction="hide">X</button>' +
+            '<p><strong>Value of <code>' +
+            row.name +
+            '</code></strong></p>' +
+            '<pre>' +
+            row.value +
+            '</pre>' +
+            '</div>';
+
+        const actions = [
+            '<button class="button dashicon" popovertarget="popover_' +
+                row.name +
+                '"><span class="dashicons dashicons-search"></span>' +
+                aaaOptionOptimizer.i18n.showValue +
+                '</button>',
+            popoverContent,
+            row.autoload === 'no'
+                ? '<button class="button dashicon add-autoload" data-option="' +
+                  row.name +
+                  '"><span class="dashicons dashicons-plus"></span>' +
+                  aaaOptionOptimizer.i18n.addAutoload +
+                  '</button>'
+                : '<button class="button dashicon remove-autoload" data-option="' +
+                  row.name +
+                  '"><span class="dashicons dashicons-minus"></span>' +
+                  aaaOptionOptimizer.i18n.removeAutoload +
+                  '</button>',
+            '<button class="button button-delete delete-option" data-option="' +
+                row.name +
+                '"><span class="dashicons dashicons-trash"></span>' +
+                aaaOptionOptimizer.i18n.deleteOption +
+                '</button >',
+        ];
+
+        return actions.join( '' );
+    }
+
+    /**
+     * Renders the value column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderNonExistingOptionsColumn( row ) {
+        return (
+            '<button class="button button-primary create-option-false" data-option="' +
+            row.name +
+            '">' +
+            aaaOptionOptimizer.i18n.createOptionFalse +
+            '</button>'
+        );
+    }
+
+    /**
+     * Renders the checkbox column for a row.
+     *
+     * @param {Object} row - The row data.
+     *
+     * @return {string} - The HTML for the value column.
+     */
+    function renderCheckboxColumn( row ) {
+        return (
+            '<label for="select-option-' +
+            row.name +
+            '">' +
+            '<input type="checkbox" id="select-option-' +
+            row.name +
+            '" class="select-option" data-option="' +
+            row.name +
+            '">' +
+            '</label>'
+        );
+    }
+
+    jQuery( '#aaa-option-reset-data' ).on( 'click', function ( e ) {
+        e.preventDefault();
+        jQuery.ajax( {
+            url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/reset',
+            method: 'POST',
+            beforeSend: ( xhr ) =>
+                xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
+            success: (
+                response // eslint-disable-line no-unused-vars
+            ) =>
+                ( window.location =
+                    window.location.href + '&tracking_reset=true' ),
+            error: ( response ) =>
+                console.error( 'Failed to reset tracking.', response ), // eslint-disable-line no-console
+        } );
+    } );
+
+    /**
+     * Handles the table actions (add-autoload, remove-autoload, delete-option).
+     *
+     * @param {Event} e - The click event.
+     */
+    function handleTableActions( e ) {
+        e.preventDefault();
+        const button = jQuery( this );
+        const table = button.closest( 'table' ).DataTable();
+        const optionName = button.data( 'option' );
+
+        const requestData = { option_name: optionName };
+        let action = '';
+        let route = '';
+
+        if ( button.hasClass( 'create-option-false' ) ) {
+            action = route = 'create-option-false';
+        } else if ( button.hasClass( 'delete-option' ) ) {
+            action = route = 'delete-option';
+        } else {
+            action = button.hasClass( 'add-autoload' )
+                ? 'add-autoload'
+                : 'remove-autoload';
+            route = 'update-autoload';
+            requestData.autoload = action === 'add-autoload' ? 'yes' : 'no';
+        }
+
+        jQuery.ajax( {
+            url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/' + route,
+            method: 'POST',
+            beforeSend: ( xhr ) =>
+                xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
+            data: requestData,
+            success: ( response ) =>
+                updateRowOnSuccess( response, table, optionName, action ),
+            error: ( response ) =>
+                // eslint-disable-next-line no-console
+                console.error(
+                    'Failed to ' + action + ' for ' + optionName + '.',
+                    response
+                ),
+        } );
+    }
+
+    /**
+     * Updates the row on successful AJAX response.
+     *
+     * @param {Object}    response   - The AJAX response.
+     * @param {DataTable} table      - The DataTable instance.
+     * @param {string}    optionName - The option name.
+     * @param {string}    action     - The action performed.
+     */
+    function updateRowOnSuccess( response, table, optionName, action ) {
+        // Get the row ID for the option name.
+        const rowId = generateRowId( optionName );
+        if ( action === 'delete-option' || action === 'create-option-false' ) {
+            table
+                .row( 'tr#' + rowId )
+                .remove()
+                .draw( 'full-hold' );
+        } else if (
+            action === 'add-autoload' ||
+            action === 'remove-autoload'
+        ) {
+            const autoloadStatus = action === 'add-autoload' ? 'yes' : 'no';
+            const buttonHTML =
+                action === 'add-autoload'
+                    ? '<button class="button dashicon remove-autoload" data-option="' +
+                      optionName +
+                      '"><span class="dashicons dashicons-minus"></span>' +
+                      aaaOptionOptimizer.i18n.removeAutoload +
+                      '</button>'
+                    : '<button class="button dashicon add-autoload" data-option="' +
+                      optionName +
+                      '"><span class="dashicons dashicons-plus"></span>' +
+                      aaaOptionOptimizer.i18n.addAutoload +
+                      '</button>';
+
+            jQuery( 'tr#' + rowId )
+                .find( 'td.autoload' )
+                .text( autoloadStatus );
+            const oldButton =
+                'button.' +
+                ( action === 'add-autoload' ? 'add' : 'remove' ) +
+                '-autoload';
+            jQuery( 'tr#' + rowId + ' ' + oldButton ).replaceWith( buttonHTML );
+        }
+    }
+
+    // AJAX Event Handling (add-autoload, remove-autoload, delete-option).
+    jQuery( 'table tbody' ).on(
+        'click',
+        '.add-autoload, .remove-autoload, .delete-option, .create-option-false',
+        handleTableActions
+    );
+
+    // Select all options.
+    jQuery( '.select-all-checkbox' ).on( 'change', function () {
+        const table = jQuery( this ).closest( 'table' );
+        const selectValue = jQuery( this ).prop( 'checked' );
+        const selectedOptions = table.find( 'input.select-option' );
+        selectedOptions.prop( 'checked', selectValue );
+    } );
+
+    // Generates bulk actions form for DataTable.
+    function getBulkActionsForm( selector, options ) {
+        return function () {
+            const container = jQuery( this.api().table().container() );
+
+            const form = jQuery(
+                '<form class="aaaoo-bulk-form" action="#" method="post" style="display:flex;gap:10px;"></form>'
+            );
+
+            let selectOptions = '';
+
+            if ( options.includes( 'autoload-on' ) ) {
+                selectOptions =
+                    '<option value="autoload-on">' +
+                    aaaOptionOptimizer.i18n.addAutoload +
+                    '</option>';
             }
 
-            return commonColumns;
-        }
-
-        /**
-         * Sets up the column filters for the DataTable.
-         */
-        function setupColumnFilters() {
-            const column = this;
-            const select = document.createElement( 'select' );
-            select.add( new Option( aaaOptionOptimizer.i18n.filterBySource, '', true, true ) );
-            column.footer().replaceChildren( select );
-
-            select.addEventListener(
-                'change',
-                function () {
-                    column.search( select.value, { exact: true } ).draw();
-                }
+            if ( options.includes( 'autoload-off' ) ) {
+                selectOptions +=
+                    '<option value="autoload-off">' +
+                    aaaOptionOptimizer.i18n.removeAutoload +
+                    '</option>';
+            }
+
+            const select = jQuery(
+                '<select class="aaaoo-bulk-select"><option value="">' +
+                    aaaOptionOptimizer.i18n.bulkActions +
+                    selectOptions +
+                    '</option><option value="delete">' +
+                    aaaOptionOptimizer.i18n.delete +
+                    '</option></select>'
             );
 
-            column.data().unique().sort().each(
-                function (d) {
-                    select.add( new Option( d ) );
-                }
+            const button = jQuery(
+                '<button type="submit" class="button aaaoo-apply-bulk-action" data-table="' +
+                    selector +
+                    '">' +
+                    aaaOptionOptimizer.i18n.apply +
+                    '</button>'
             );
-        }
-
-        /**
-         * Renders the value column for a row.
-         *
-         * @param {Object} row - The row data.
-         *
-         * @returns {string} - The HTML for the value column.
-         */
-        function renderValueColumn(row) {
-            const popoverContent = '<div id="popover_' + row.name + '" popover class="aaa-option-optimizer-popover">' +
-            '<button class="aaa-option-optimizer-popover__close" popovertarget="popover_' + row.name + '" popovertargetaction="hide">X</button>' +
-            '<p><strong>Value of <code>' + row.name + '</code></strong></p>' +
-            '<pre>' + row.value + '</pre>' +
-            '</div>';
-
-            const actions = [
-                '<button class="button dashicon" popovertarget="popover_' + row.name + '"><span class="dashicons dashicons-search"></span>' + aaaOptionOptimizer.i18n.showValue + '</button>',
-                popoverContent,
-                row.autoload === 'no' ?
-                    '<button class="button dashicon add-autoload" data-option="' + row.name + '"><span class="dashicons dashicons-plus"></span>' + aaaOptionOptimizer.i18n.addAutoload + '</button>' :
-                    '<button class="button dashicon remove-autoload" data-option="' + row.name + '"><span class="dashicons dashicons-minus"></span>' + aaaOptionOptimizer.i18n.removeAutoload + '</button>',
-                    '<button class="button button-delete delete-option" data-option="' + row.name + '"><span class="dashicons dashicons-trash"></span>' + aaaOptionOptimizer.i18n.deleteOption + '</button >'
-            ];
-
-            return actions.join( '' );
-        }
-
-        $( '#aaa-option-reset-data' ).on(
-            'click',
-            function (e) {
-                e.preventDefault();
-                $.ajax(
-                    {
-                        url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/reset',
-                        method: 'POST',
-                        beforeSend: xhr => xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
-                        success: response => window.location = window.location.href + '&tracking_reset=true',
-                        error: response => console.error(
-                            'Failed to reset tracking.',
-                            response
-                        )
-                    }
-                );
+
+            form.append( select, button );
+
+            // Add the form to the .dt-start cell
+            container.find( '.dt-layout-cell.dt-start ' ).prepend( form );
+
+            // Move .dt-length to .dt-layout-cell.dt-end
+            // const lengthSelector = container.find(".dt-length"); // same as div.dt-length
+            // const targetEndCell = container.find(".dt-layout-cell.dt-end");
+            // if (lengthSelector.length && targetEndCell.length) {
+            //  targetEndCell.append(lengthSelector);
+            // }
+        };
+    }
+
+    // Apply bulk action.
+    jQuery( '.aaa-option-optimizer-tabs' ).on(
+        'click',
+        '.aaaoo-apply-bulk-action',
+        function ( e ) {
+            e.preventDefault();
+            const button = jQuery( this );
+            const select = jQuery( button ).siblings( '.aaaoo-bulk-select' );
+            const bulkAction = select.val();
+            const table = jQuery( button.data( 'table' ) );
+            const selectedOptions = table.find( 'input.select-option:checked' );
+
+            if ( ! bulkAction ) {
+                alert( aaaOptionOptimizer.i18n.noBulkActionSelected ); // eslint-disable-line no-alert
+                return;
             }
-        );
-
-        /**
-         * Handles the table actions (add-autoload, remove-autoload, delete-option).
-         *
-         * @param {Event} e - The click event.
-         */
-        function handleTableActions(e) {
-            e.preventDefault();
-            const button     = $( this );
-            const table      = button.closest( 'table' ).DataTable();
-            const optionName = button.data( 'option' );
-
-            let requestData = { option_name: optionName };
-            let action      = '';
-            let route       = '';
-
-            if ( button.hasClass( 'create-option-false' ) ) {
-                action = route = 'create-option-false';
-            } else if ( button.hasClass( 'delete-option' ) ) {
-                action = route = 'delete-option';
+
+            if ( selectedOptions.length === 0 ) {
+                alert( aaaOptionOptimizer.i18n.noOptionsSelected ); // eslint-disable-line no-alert
+                return;
+            }
+
+            // For now we only have delete in bulk action.
+
+            const requestData = {
+                option_names: Array.from( selectedOptions ).map( ( option ) =>
+                    option.getAttribute( 'data-option' )
+                ),
+            };
+
+            if ( bulkAction === 'delete' ) {
+                endpoint = 'delete-options';
             } else {
-                action               = button.hasClass( 'add-autoload' ) ? 'add-autoload' : 'remove-autoload';
-                route                = 'update-autoload';
-                requestData.autoload = ( action === 'add-autoload' ) ? 'yes' : 'no';
+                endpoint = 'set-autoload-options';
+                requestData.autoload =
+                    bulkAction === 'autoload-on' ? 'yes' : 'no';
             }
 
-            $.ajax(
-                {
-                    url: aaaOptionOptimizer.root + 'aaa-option-optimizer/v1/' + route,
-                    method: 'POST',
-                    beforeSend: xhr => xhr.setRequestHeader( 'X-WP-Nonce', aaaOptionOptimizer.nonce ),
-                    data: requestData,
-                    success: response => updateRowOnSuccess( response, table, optionName, action ),
-                    error: response => console.error(
-                        'Failed to ' + action + ' for ' + optionName + '.',
-                        response
-                    )
-                }
-            );
-        }
-
-        /**
-         * Updates the row on successful AJAX response.
-         *
-         * @param {Object} response - The AJAX response.
-         * @param {DataTable} table - The DataTable instance.
-         * @param {string} optionName - The option name.
-         * @param {string} action - The action performed.
-         */
-        function updateRowOnSuccess(response, table, optionName, action) {
-            if ( action === 'delete-option' || action === 'create-option-false' ) {
-                table.row( 'tr#option_' + optionName ).remove().draw( 'full-hold' );
-            } else if ( action === 'add-autoload' || action === 'remove-autoload' ) {
-                const autoloadStatus = action === 'add-autoload' ? 'yes' : 'no';
-                const buttonHTML     = action === 'add-autoload' ?
-                '<button class="button dashicon remove-autoload" data-option="' + optionName + '"><span class="dashicons dashicons-minus"></span>' + aaaOptionOptimizer.i18n.removeAutoload + '</button>':
-                '<button class="button dashicon add-autoload" data-option="' + optionName + '"><span class="dashicons dashicons-plus"></span>' + aaaOptionOptimizer.i18n.addAutoload + '</button>';
-
-                $( 'tr#option_' + optionName ).find( 'td.autoload' ).text( autoloadStatus );
-                const oldButton = 'button.' + ( action === 'add-autoload' ? 'add' : 'remove' ) + '-autoload';
-                $( 'tr#option_' + optionName + ' ' + oldButton ).replaceWith( buttonHTML );
-            }
-        }
-
-        // AJAX Event Handling (add-autoload, remove-autoload, delete-option).
-        $( 'table tbody' ).on( 'click', '.add-autoload, .remove-autoload, .delete-option, .create-option-false', handleTableActions );
-
-        // Initialize data tables.
-        tablesToInitialize.forEach(
-            function (selector) {
-                if ($( selector ).length) {
-                    initializeDataTable( selector );
-                }
-            }
-        );
-    }
-);
+            jQuery.ajax( {
+                url:
+                    aaaOptionOptimizer.root +
+                    'aaa-option-optimizer/v1/' +
+                    endpoint,
+                method: 'POST',
+                beforeSend: ( xhr ) =>
+                    xhr.setRequestHeader(
+                        'X-WP-Nonce',
+                        aaaOptionOptimizer.nonce
+                    ),
+                data: requestData,
+                success: () => {
+                    const dt = table.DataTable();
+
+                    requestData.option_names.forEach( ( optionName ) => {
+                        dt.row( 'tr#option_' + optionName ).remove();
+                    } );
+
+                    dt.draw( 'full-hold' );
+
+                    // Clear the select-all checkbox.
+                    table
+                        .find( '.select-all-checkbox' )
+                        .prop( 'checked', false );
+                },
+                error: ( response ) => {
+                    // eslint-disable-next-line no-console
+                    console.error( 'Failed to delete options.', response );
+                },
+            } );
+        }
+    );
+
+    // Initialize data tables.
+    tablesToInitialize.forEach( function ( selector ) {
+        if ( jQuery( selector ).length ) {
+            initializeDataTable( selector );
+        }
+    } );
+} );

aaa-option-optimizer/trunk/known-plugins/known-plugins.json

@@ -36 +36 @@
         "option_prefixes": ["chaty_"]
     },
+    "comment_hacks": {
+        "name": "Comment Experience by Progress Planner",
+        "option_prefixes": ["comment_hacks"]
+    },
     "complianz": {
         "name": "Complianz GDPR",
@@ -56 +60 @@
         "option_prefixes": ["elementor_"]
     },
+    "enhanced-e-commerce-for-woocommerce-store": {
+        "name": "Conversios: Google Analytics 4 (GA4), Google Ads, Microsoft Ads, and Multi-Channel Conversion Tracking",
+        "option_prefixes": ["ee_"]
+    },
     "fewer-tags": {
         "name": "Fewer Tags",
@@ -72 +80 @@
         "option_prefixes": ["yst_"]
     },
+    "google-site-kit": {
+        "name": "Site Kit by Google",
+        "option_prefixes": ["googlesitekit_"]
+    },
     "gravity-forms": {
         "name": "Gravity Forms",
         "option_prefixes": ["gf_","gforms_"]
     },
+    "woo-billing-with-invoicexpress": {
+        "name": "Invoicing with InvoiceXpress for WooCommerce",
+        "option_prefixes": ["hd_wc_ie_"]
+    },
     "indeed-membership-pro": {
         "name": "Indeed Ultimate Membership Pro",
@@ -90 +106 @@
     "litespeed-cache": {
         "name": "LiteSpeed Cache",
-        "option_prefixes": ["litespeed-", "_litespeed_"]
+        "option_prefixes": ["litespeed-", "_litespeed_", "litespeed."]
     },
     "loginizer": {
@@ -96 +112 @@
         "option_prefixes": ["loginizer_"]
     },
+    "multibanco-ifthen-software-gateway-for-woocommerce": {
+        "name": "Multibanco, MB WAY, Credit card, Apple Pay, Google Pay, Payshop, Cofidis Pay, and PIX (ifthenpay) for WooCommerce",
+        "option_prefixes": ["cofidispay_ifthen_", "creditcard_ifthen_", "gateway_ifthen_", "mbway_ifthen_", "multibanco_ifthen_", "payshop_"]
+    },
     "perfmatters": {
         "name": "Perfmatters",
@@ -112 +132 @@
         "option_prefixes": ["porto_"]
     },
+    "product-assembly-cost": {
+        "name": "Product Assembly / Gift Wrap / ... Cost for WooCommerce",
+        "option_prefixes": ["product_assembly_"]
+    },
+    "progress-planner": {
+        "name": "Progress Planner",
+        "option_prefixes": ["progress_planner_"]
+    },
     "really-simple-ssl": {
         "name": "Really Simple SSL",
@@ -132 +160 @@
         "option_prefixes": ["rank_math_"]
     },
+    "shop-as-client": {
+        "name": "Shop as Client for WooCommerce",
+        "option_prefixes": ["shop_as_client"]
+    },
+    "simple-woo-checkout-blocks-cf": {
+        "name": "Simple Checkout Fields Manager for WooCommerce",
+        "option_prefixes": ["swcbcf_"]
+    },
+    "simple-woocommerce-order-approval": {
+        "name": "Simple WooCommerce Order Approval",
+        "option_prefixes": ["swoa_"]
+    },
     "updraft": {
         "name": "Updraft Plus",
@@ -140 +180 @@
         "option_prefixes": ["wpseo", "yoast_"]
     },
+    "feed-kuantokusta-for-woocommerce": {
+        "name": "Feed KuantoKusta for WooCommerce",
+        "option_prefixes": ["wc_feed_kuantokusta_"]
+    },
+    "woo-dpd-pickup": {
+        "name": "DPD / Geopost Pickup and Lockers network for WooCommerce",
+        "option_prefixes": ["woo_dpd_pickup"]
+    },
+    "woo-dpd-portugal": {
+        "name": "DPD Portugal for WooCommerce",
+        "option_prefixes": ["woo_dpd_portugal"]
+    },
     "woocommerce": {
         "name": "WooCommerce",
         "option_prefixes": ["wc_", "_transient__woocommerce_", "woocommerce_"]
+    },
+    "woocommerce-max-quantity": {
+        "name": "Maximum Quantity for WooCommerce Shops",
+        "option_prefixes": ["isa_woocommerce_"]
     },
     "wordfence": {

aaa-option-optimizer/trunk/readme.txt

@@ -5 +5 @@
 Tested up to: 6.8
 Requires PHP: 7.4
-Stable tag: 1.3.2
+Stable tag: 1.4.0
 License: GPL3+
 License URI: https://www.gnu.org/licenses/gpl-3.0.en.html
@@ -54 +54 @@
 
 == Changelog ==
+
+= 1.4.0 =
+
+* Performance improvements.
+* Added bulk-actions to allow optimizing & deleting options in bulk.
+* Added more known plugins.
 
 = 1.3.2 =

aaa-option-optimizer/trunk/src/class-admin-page.php

@@ -14 +14 @@
 
     /**
-     * The map plugin to options class.
-     *
-     * @var Map_Plugin_To_Options
-     */
-    private $map_plugin_to_options;
-
-    /**
      * Register hooks.
      *
@@ -26 +19 @@
      */
     public function register_hooks() {
-        $this->map_plugin_to_options = new Map_Plugin_To_Options();
-
         // Register a link to the settings page on the plugins overview page.
         \add_filter( 'plugin_action_links', [ $this, 'filter_plugin_actions' ], 10, 2 );
@@ -71 +62 @@
             'manage_options',
             'aaa-option-optimizer',
-            [ $this, 'render_admin_page' ]
+            [ $this, 'render_admin_page_ajax' ]
         );
     }
@@ -124 +115 @@
                 'nonce' => wp_create_nonce( 'wp_rest' ),
                 'i18n'  => [
-                    'filterBySource' => esc_html__( 'Filter by source', 'aaa-option-optimizer' ),
-                    'showValue'      => esc_html__( 'Show', 'aaa-option-optimizer' ),
-                    'addAutoload'    => esc_html__( 'Add autoload', 'aaa-option-optimizer' ),
-                    'removeAutoload' => esc_html__( 'Remove autoload', 'aaa-option-optimizer' ),
-                    'deleteOption'   => esc_html__( 'Delete', 'aaa-option-optimizer' ),
-
-                    'search'         => esc_html__( 'Search:', 'aaa-option-optimizer' ),
-                    'entries'        => [
+                    'filterBySource'         => esc_html__( 'Filter by source', 'aaa-option-optimizer' ),
+                    'showValue'              => esc_html__( 'Show', 'aaa-option-optimizer' ),
+                    'addAutoload'            => esc_html__( 'Add autoload', 'aaa-option-optimizer' ),
+                    'removeAutoload'         => esc_html__( 'Remove autoload', 'aaa-option-optimizer' ),
+                    'deleteOption'           => esc_html__( 'Delete', 'aaa-option-optimizer' ),
+                    'createOptionFalse'      => esc_html__( 'Create option with value false', 'aaa-option-optimizer' ),
+                    'noAutoloadedButNotUsed' => esc_html__( 'All autoloaded options are in use.', 'aaa-option-optimizer' ),
+                    'noUsedButNotAutoloaded' => esc_html__( 'All options that are used are autoloaded.', 'aaa-option-optimizer' ),
+                    'noOptionsSelected'      => esc_html__( 'No options selected.', 'aaa-option-optimizer' ),
+                    'bulkActions'            => esc_html__( 'Bulk actions', 'aaa-option-optimizer' ),
+                    'noBulkActionSelected'   => esc_html__( 'No action selected.', 'aaa-option-optimizer' ),
+                    'delete'                 => esc_html__( 'Delete', 'aaa-option-optimizer' ),
+                    'apply'                  => esc_html__( 'Apply', 'aaa-option-optimizer' ),
+
+                    'search'                 => esc_html__( 'Search:', 'aaa-option-optimizer' ),
+                    'entries'                => [
                         '_' => \esc_html__( 'entries', 'aaa-option-optimizer' ),
                         '1' => \esc_html__( 'entry', 'aaa-option-optimizer' ),
                     ],
-                    'sInfo'          => sprintf(
+                    'sInfo'                  => sprintf(
                         // translators: %1$s is the start, %2$s is the end, %3$s is the total, %4$s is the entries.
                         esc_html__( 'Showing %1$s to %2$s of %3$s %4$s', 'aaa-option-optimizer' ),
@@ -143 +142 @@
                         '_ENTRIES-TOTAL_'
                     ),
-                    'sInfoEmpty'     => esc_html__( 'Showing 0 to 0 of 0 entries', 'aaa-option-optimizer' ),
-                    'sInfoFiltered'  => sprintf(
+                    'sInfoEmpty'             => esc_html__( 'Showing 0 to 0 of 0 entries', 'aaa-option-optimizer' ),
+                    'sInfoFiltered'          => sprintf(
                         // translators: %1$s is the max, %2$s is the entries-max.
                         esc_html__( '(filtered from %1$s total %2$s)', 'aaa-option-optimizer' ),
@@ -150 +149 @@
                         '_ENTRIES-MAX_'
                     ),
-                    'sZeroRecords'   => esc_html__( 'No matching records found', 'aaa-option-optimizer' ),
-                    'oAria'          => [
+                    'sZeroRecords'           => esc_html__( 'No matching records found', 'aaa-option-optimizer' ),
+                    'oAria'                  => [
                         'orderable'        => esc_html__( ': Activate to sort', 'aaa-option-optimizer' ),
                         'orderableReverse' => esc_html__( ': Activate to invert sorting', 'aaa-option-optimizer' ),
@@ -198 +197 @@
                     echo '<th class="source">' . esc_html__( 'Source', 'aaa-option-optimizer' ) . '</th>';
                     break;
+                case 'select-all':
+                    echo '<th class="select-all"><input type="checkbox" class="select-all-checkbox" /></th>';
+                    break;
             }
         }
@@ -205 +207 @@
 
     /**
-     * Get the length of a value.
-     *
-     * @param mixed $value The input value.
-     *
-     * @return string
-     */
-    private function get_length( $value ) {
-        if ( empty( $value ) ) {
-            return '0.00';
-        }
-        if ( is_array( $value ) || is_object( $value ) ) {
-            // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize -- intended here.
-            $length = strlen( serialize( $value ) );
-        } elseif ( is_string( $value ) || is_numeric( $value ) ) {
-            $length = strlen( strval( $value ) );
-        }
-        if ( ! isset( $length ) ) {
-            return '0.00';
-        }
-        return number_format( ( $length / 1024 ), 2 );
-    }
-
-    /**
      * Renders the admin page.
      *
      * @return void
      */
-    public function render_admin_page() {
+    public function render_admin_page_ajax() {
         $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
-        $all_options      = wp_load_alloptions();
-        // Filter out transients.
-        $autoload_options = array_filter(
-            $all_options,
-            function ( $value, $key ) {
-                return strpos( $key, '_transient_' ) === false;
-            },
-            ARRAY_FILTER_USE_BOTH
-        );
-
-        $unused_options         = [];
-        $non_autoloaded_options = [];
-
-        // Get the autoloaded options that aren't used.
-        foreach ( $autoload_options as $option => $value ) {
-            if ( isset( $option_optimizer['used_options'][ $option ] ) ) {
-                continue;
-            }
-            $unused_options[ $option ] = $value;
-        }
-
-        // Determine the options that _are_ used, but not auto-loaded.
-        foreach ( $option_optimizer['used_options'] as $option => $count ) {
-            if ( isset( $autoload_options[ $option ] ) ) {
-                continue;
-            }
-            $non_autoloaded_options[ $option ] = $count;
-        }
-
-        // Some of the options that are used but not auto-loaded, may not exist.
-        if ( ! empty( $non_autoloaded_options ) ) {
-            $options_that_do_not_exist   = [];
-            $non_autoloaded_options_full = [];
-            foreach ( $non_autoloaded_options as $option => $count ) {
-                $value = get_option( $option, 'aaa-no-return-value' );
-                if ( $value === 'aaa-no-return-value' ) {
-                    $options_that_do_not_exist[ $option ] = $count;
-                    continue;
-                }
-                $non_autoloaded_options_full[ $option ] = [
-                    'count' => $count,
-                    'value' => $value,
-                ];
-            }
-        }
 
         // Start HTML output.
@@ -322 +256 @@
         <?php
         echo '<h2 id="unused-autoloaded">' . esc_html__( 'Unused, but autoloaded', 'aaa-option-optimizer' ) . '</h2>';
-        if ( ! empty( $unused_options ) ) {
-            echo '<p>' . esc_html__( 'The following options are autoloaded on each pageload, but AAA Option Optimizer has not been able to detect them being used.', 'aaa-option-optimizer' );
-            echo '<table style="width:100%" id="unused_options_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $unused_options as $option => $value ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '"><td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td><span class="num">' . esc_html( $this->get_length( $value ) ) . '</span></td>';
-                echo '<td class="autoload">yes</td>';
-                echo '<td class="actions">';
-                // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- output escaped in get_value_button.
-                echo $this->get_value_button( $option, $value );
-                echo '<button class="button button-primary remove-autoload" data-option="' . esc_attr( $option ) . '"><span class="dashicons dashicons-minus"></span> ' . esc_html__( 'Remove autoload', 'aaa-option-optimizer' ) . '</button> ';
-                echo ' <button class="button button-delete delete-option" data-option="' . esc_attr( $option ) . '"><span class="dashicons dashicons-trash"></span> ' . esc_html__( 'Delete', 'aaa-option-optimizer' ) . '</button>';
-                echo '</td></tr>';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'actions' ] );
-            echo '</table>';
-        } else {
-            echo '<p>' . esc_html__( 'All autoloaded options are in use.', 'aaa-option-optimizer' ) . '</p>';
-        }
-        ?>
+        echo '<p>' . esc_html__( 'The following options are autoloaded on each pageload, but AAA Option Optimizer has not been able to detect them being used.', 'aaa-option-optimizer' );
+        echo '<table style="width:100%" id="unused_options_table" class="aaa_option_table">';
+        $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] );
+        ?>
+        <tbody>
+        <tr>
+            <td class="select-all"></td>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td class="actions"></td>
+        </tr>
+        </tbody>
+        <?php
+        $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] );
+        ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-2"/>
@@ -352 +280 @@
         <?php
         // Render differences.
-        if ( ! empty( $non_autoloaded_options ) ) {
             echo '<h2 id="used-not-autoloaded">' . esc_html__( 'Used, but not autoloaded options', 'aaa-option-optimizer' ) . '</h2>';
             echo '<p>' . esc_html__( 'The following options are *not* autoloaded on each pageload, but AAA Option Optimizer has detected that they are being used. If one of the options below has been called a lot and is not very big, you might consider adding autoload to that option.', 'aaa-option-optimizer' );
             echo '<table style="width:100%;" id="used_not_autoloaded_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $non_autoloaded_options_full as $option => $arr ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '">';
-                echo '<td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td><span class="num">' . esc_html( $this->get_length( $arr['value'] ) ) . '</span></td>';
-                echo '<td class="autoload">no</td>';
-                echo '<td>' . esc_html( $arr['count'] ) . '</td>';
-                echo '<td class="actions">';
-                // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- output escaped in get_value_button.
-                echo $this->get_value_button( $option, $arr['value'] );
-                echo '<button class="button button-primary add-autoload" data-option="' . esc_attr( $option ) . '">' . esc_html__( 'Add autoload', 'aaa-option-optimizer' ) . '</button> ';
-                echo '</td></tr>';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
-            echo '</table>';
-        } else {
-            echo '<p>' . esc_html__( 'All options that are used are autoloaded.', 'aaa-option-optimizer' ) . '</p>';
-        }
-        ?>
+            $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] );
+        ?>
+            <tbody>
+            <tr>
+                <td class="select-all"></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td></td>
+                <td class="actions"></td>
+            </tr>
+            </tbody>
+            <?php $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'calls', 'actions' ] ); ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-3"/>
@@ -383 +303 @@
             <div class="panel">
         <?php
-        if ( ! empty( $options_that_do_not_exist ) ) {
-            echo '<h2 id="requested-do-not-exist">' . esc_html__( 'Requested options that do not exist', 'aaa-option-optimizer' ) . '</h2>';
-            echo '<p>' . esc_html__( 'The following options are requested sometimes, but AAA Option Optimizer has detected that they do not exist. If one of the options below has been called a lot, it might help to create it with a value of false.', 'aaa-option-optimizer' );
-            echo '<table width="100%" id="requested_do_not_exist_table" class="aaa_option_table">';
-            $this->table_section( 'thead', [ 'option', 'source', 'calls', 'actions' ] );
-            echo '<tbody>';
-            foreach ( $options_that_do_not_exist as $option => $count ) {
-                echo '<tr id="option_' . esc_attr( str_replace( ':', '', str_replace( '.', '', $option ) ) ) . '">';
-                echo '<td>' . esc_html( $option ) . '</td>';
-                echo '<td>' . esc_html( $this->get_plugin_name( $option ) ) . '</td>';
-                echo '<td>' . esc_html( $count ) . '</td>';
-                echo '<td class="actions"><button class="button button-primary create-option-false" data-option="' . esc_attr( $option ) . '">' . esc_html__( 'Create option with value false', 'aaa-option-optimizer' ) . '</button> ';
-            }
-            echo '</tbody>';
-            $this->table_section( 'tfoot', [ 'option', 'source', 'calls', 'actions' ] );
-            echo '</table>';
-        }
-        ?>
+        echo '<h2 id="requested-do-not-exist">' . esc_html__( 'Requested options that do not exist', 'aaa-option-optimizer' ) . '</h2>';
+        echo '<p>' . esc_html__( 'The following options are requested sometimes, but AAA Option Optimizer has detected that they do not exist. If one of the options below has been called a lot, it might help to create it with a value of false.', 'aaa-option-optimizer' );
+        echo '<table width="100%" id="requested_do_not_exist_table" class="aaa_option_table">';
+        $this->table_section( 'thead', [ 'option', 'source', 'calls', 'actions' ] );
+        ?>
+        <tbody>
+        <tr>
+            <td></td>
+            <td></td>
+            <td></td>
+            <td class="actions"></td>
+        </tr>
+        </tbody>
+        <?php
+        $this->table_section( 'tfoot', [ 'option', 'source', 'calls', 'actions' ] );
+        ?>
+        </table>
         </div>
         <input class="input" name="tabs" type="radio" id="tab-4"/>
@@ -408 +327 @@
             <button id="aaa_get_all_options" class="button button-primary"><?php esc_html_e( 'Get all options', 'aaa-option-optimizer' ); ?></button>
             <table class="aaa_option_table" id="all_options_table" style="display:none;">
-                <?php $this->table_section( 'thead', [ 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
+                <?php $this->table_section( 'thead', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
                 <tbody>
                     <tr>
+                        <td class="select-all"></td>
                         <td></td>
                         <td></td>
@@ -416 +336 @@
                         <td></td>
                         <td class="actions"></td>
-                    </tr>   
+                    </tr>
                 </tbody>
-                <?php $this->table_section( 'tfoot', [ 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
+                <?php $this->table_section( 'tfoot', [ 'select-all', 'option', 'source', 'size', 'autoload', 'actions' ] ); ?>
             </table>
         </div>
@@ -424 +344 @@
         <?php
     }
-
-    /**
-     * Get html to show a popover.
-     *
-     * @param string $name  The name of the option, used in the id of the popover.
-     * @param mixed  $value The value to show.
-     *
-     * @return string
-     */
-    private function get_value_button( string $name, $value ): string {
-        $string = is_string( $value ) ? $value : wp_json_encode( $value );
-        $id     = 'aaa-option-optimizer-' . esc_attr( $name );
-        return '
-        <button class="button" popovertarget="' . $id . '"><span class="dashicons dashicons-search"></span> ' . esc_html__( 'Show', 'aaa-option-optimizer' ) . '</button>
-        <div id="' . $id . '" popover class="aaa-option-optimizer-popover">
-        <button class="aaa-option-optimizer-popover__close" popovertarget="' . $id . '" popovertargetaction="hide">X</button>' .
-        // translators: %s is the name of the option.
-        '<p><strong>' . sprintf( esc_html__( 'Value of %s', 'aaa-option-optimizer' ), '<code>' . esc_html( $name ) . '</code>' ) . '</strong></p>
-        <pre>' . htmlentities( $string, ENT_QUOTES | ENT_SUBSTITUTE ) . '</pre>
-        </div>';
-    }
-
-    /**
-     * Find plugin in known plugin prefixes list.
-     *
-     * @param string $option The option name.
-     *
-     * @return string
-     */
-    private function get_plugin_name( $option ) {
-        return $this->map_plugin_to_options->get_plugin_name( $option );
-    }
 }

aaa-option-optimizer/trunk/src/class-rest.php

@@ -122 +122 @@
             ]
         );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/unused-options',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_unused_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/used-not-autoloaded-options',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_used_not_autoloaded_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/options-that-do-not-exist',
+            [
+                'methods'             => 'GET',
+                'callback'            => [ $this, 'get_options_that_do_not_exist' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/delete-options',
+            [
+                'methods'             => 'POST',
+                'callback'            => [ $this, 'delete_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
+
+        \register_rest_route(
+            'aaa-option-optimizer/v1',
+            '/set-autoload-options',
+            [
+                'methods'             => 'POST',
+                'callback'            => [ $this, 'set_autoload_options' ],
+                'permission_callback' => function () {
+                    return current_user_can( 'manage_options' );
+                },
+            ]
+        );
     }
 
@@ -148 +208 @@
             $output[] = [
                 'name'     => $option->option_name,
-                'plugin'   => $this->map_plugin_to_options->get_plugin_name( $option->option_name ),
+                'plugin'   => $this->get_plugin_name( $option->option_name ),
                 'value'    => htmlentities( $option->option_value, ENT_QUOTES | ENT_SUBSTITUTE ),
-                'size'     => number_format( strlen( $option->option_value ) / 1024, 2 ),
+                'size'     => $this->get_length( $option->option_value ),
+                'raw_size' => strlen( $option->option_value ),
                 'autoload' => $option->autoload,
-                'row_id'   => 'option_' . $option->option_name,
             ];
         }
         return new \WP_REST_Response( [ 'data' => $output ], 200 );
+    }
+
+    /**
+     * Get unused options.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_unused_options() {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options from option_optimizer.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        $query = "
+            SELECT option_name
+            FROM {$wpdb->options}
+            WHERE autoload IN ( '" . implode( "', '", esc_sql( \wp_autoload_values_to_autoload() ) ) . "' )
+            AND option_name NOT LIKE '%_transient_%'
+        ";
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $query .= " AND option_name LIKE '%" . esc_sql( $search ) . "%'";
+        }
+
+        // Get autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            $query // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
+        );
+
+        // Find unused autoloaded option names.
+        $autoload_option_keys = array_fill_keys( $autoloaded_option_names, true );
+        $unused_keys          = array_diff_key( $autoload_option_keys, $used_options );
+        $total_unused         = count( $unused_keys );
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+        $paged_option_names = array_keys( $unused_keys );
+
+        // Optimize by slicing early for default sort, since we can sort $autoloaded_option_names in advance.
+        if ( 'name' === $order_column && SORT_ASC === $order_dir ) {
+            $paged_option_names = array_slice( $paged_option_names, $offset, $limit );
+        }
+
+        $response_data = [];
+
+        if ( ! empty( $paged_option_names ) ) {
+            $placeholders = implode( ',', array_fill( 0, count( $paged_option_names ), '%s' ) );
+            $value_query  = "
+                SELECT option_name, option_value
+                FROM {$wpdb->options}
+                WHERE option_name IN ( {$placeholders} )
+            ";
+
+            $results = $wpdb->get_results( $wpdb->prepare( $value_query, ...$paged_option_names ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
+
+            // Format output.
+            foreach ( $results as $row ) {
+                $response_data[] = [
+                    'name'     => $row->option_name,
+                    'plugin'   => $this->get_plugin_name( $row->option_name ),
+                    'value'    => htmlentities( $row->option_value, ENT_QUOTES | ENT_SUBSTITUTE ),
+                    'size'     => $this->get_length( $row->option_value ),
+                    'raw_size' => strlen( $row->option_value ),
+                    'autoload' => 'yes',
+                ];
+            }
+
+            // Sorting, skip if "name" column is sorted in ascending order since that is the default.
+            if ( ! ( 'name' === $order_column && SORT_ASC === $order_dir ) ) {
+                $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+
+                // Now we can slice after sort.
+                $response_data = array_slice( $response_data, $offset, $limit );
+            }
+        }
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_unused,
+                'recordsFiltered' => $total_unused,
+                'data'            => $response_data,
+            ],
+            200
+        );
+    }
+
+    /**
+     * Get used, but not autoloaded options.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_used_not_autoloaded_options() {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options from option_optimizer.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        if ( empty( $used_options ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Get all autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
+            "
+                SELECT option_name
+                FROM {$wpdb->options}
+                WHERE autoload IN ( '" . implode( "', '", esc_sql( wp_autoload_values_to_autoload() ) ) . "' )
+                AND option_name NOT LIKE '%_transient_%'
+                ORDER BY option_name ASC
+            "
+        );
+        $autoload_option_keys    = array_fill_keys( $autoloaded_option_names, true );
+
+        // Find used options that are not autoloaded.
+        $non_autoloaded_used_keys = array_diff_key( $used_options, $autoload_option_keys );
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $non_autoloaded_used_keys = array_filter(
+                $non_autoloaded_used_keys,
+                function ( $option_name ) use ( $search ) {
+                    return false !== stripos( $option_name, $search );
+                },
+                ARRAY_FILTER_USE_KEY
+            );
+        }
+
+        if ( empty( $non_autoloaded_used_keys ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+
+        // We can't slice early here, because we can't sort $used_options in advance.
+        $paged_option_names = array_keys( $non_autoloaded_used_keys );
+
+        $response_data = [];
+
+        // $paged_option_names is not empty.
+        // Fetch values directly from DB without using get_option().
+        $placeholders = implode( ',', array_fill( 0, count( $paged_option_names ), '%s' ) );
+        $sql          = "
+            SELECT option_name, option_value
+            FROM {$wpdb->options}
+            WHERE option_name IN ( {$placeholders} )"; // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+
+        $results = $wpdb->get_results( $wpdb->prepare( $sql, ...$paged_option_names ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+
+        foreach ( $results as $row ) {
+            $response_data[] = [
+                'name'     => $row->option_name,
+                'plugin'   => $this->get_plugin_name( $row->option_name ),
+                'value'    => htmlentities( maybe_serialize( $row->option_value ), ENT_QUOTES | ENT_SUBSTITUTE ),
+                'size'     => $this->get_length( $row->option_value ),
+                'raw_size' => strlen( $row->option_value ),
+                'autoload' => 'no',
+                'count'    => $used_options[ $row->option_name ] ?? 0,
+            ];
+        }
+
+        $total_filtered = count( $response_data );
+
+        // Sort and slice after.
+        $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+        $response_data = array_slice( $response_data, $offset, $limit );
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_filtered,
+                'recordsFiltered' => $total_filtered,
+                'data'            => $response_data,
+            ],
+            200
+        );
+    }
+
+    /**
+     * Get options that do not exist.
+     * Some of the options that are used but not auto-loaded, may not exist.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function get_options_that_do_not_exist() {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        global $wpdb;
+
+        // Load used options.
+        $option_optimizer = get_option( 'option_optimizer', [ 'used_options' => [] ] );
+        $used_options     = $option_optimizer['used_options'];
+
+        if ( empty( $used_options ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Get autoloaded, non-transient option names.
+        $autoloaded_option_names = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            "
+            SELECT option_name
+            FROM {$wpdb->options}
+            WHERE autoload IN ('yes', 'on', 'true', '1')
+            AND option_name NOT LIKE '%_transient_%'
+        "
+        );
+        $autoload_option_keys    = array_fill_keys( $autoloaded_option_names, true );
+
+        // Get used options that are not autoloaded.
+        $non_autoloaded_keys = array_diff_key( $used_options, $autoload_option_keys );
+
+        // Search.
+        $search = isset( $_GET['search']['value'] ) ? trim( \sanitize_text_field( \wp_unslash( $_GET['search']['value'] ) ) ) : '';
+        if ( '' !== $search ) {
+            $non_autoloaded_keys = array_filter(
+                $non_autoloaded_keys,
+                function ( $option_name ) use ( $search ) {
+                    return stripos( $option_name, $search ) !== false;
+                },
+                ARRAY_FILTER_USE_KEY
+            );
+        }
+
+        if ( empty( $non_autoloaded_keys ) ) {
+            return new \WP_REST_Response(
+                [
+                    'draw'            => intval( $_GET['draw'] ?? 0 ),
+                    'recordsTotal'    => 0,
+                    'recordsFiltered' => 0,
+                    'data'            => [],
+                ],
+                200
+            );
+        }
+
+        // Check which of them actually exist in the options table.
+        $option_names = array_keys( $non_autoloaded_keys );
+        $placeholders = implode( ',', array_fill( 0, count( $option_names ), '%s' ) );
+
+        $existing_option_names = $wpdb->get_col(  // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
+            $wpdb->prepare(
+                "SELECT option_name FROM {$wpdb->options} WHERE option_name IN ($placeholders)", // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
+                ...$option_names
+            )
+        );
+        $existing_keys         = array_fill_keys( $existing_option_names, true );
+
+        // Filter only those that do NOT exist.
+        $response_data = [];
+        foreach ( $non_autoloaded_keys as $option => $count ) {
+            if ( ! isset( $existing_keys[ $option ] ) ) {
+                $response_data[] = [
+                    'name'        => $option,
+                    'plugin'      => $this->get_plugin_name( $option ),
+                    'count'       => $count,
+                    'option_name' => $option,
+                ];
+            }
+        }
+
+        $total_filtered = count( $response_data );
+
+        // Pagination.
+        [ $offset, $limit ] = $this->get_pagination_params();
+
+        // Sort order.
+        [ $order_column, $order_dir ] = $this->get_sort_params();
+
+        // Sort and slice after.
+        $response_data = $this->sort_response_data_by_column( $response_data, $order_column, $order_dir );
+        $response_data = array_slice( $response_data, $offset, $limit );
+
+        // Return response.
+        return new \WP_REST_Response(
+            [
+                'draw'            => intval( $_GET['draw'] ?? 0 ),
+                'recordsTotal'    => $total_filtered,
+                'recordsFiltered' => $total_filtered,
+                'data'            => $response_data,
+            ],
+            200
+        );
     }
 
@@ -208 +601 @@
 
     /**
+     * Delete multiple options.
+     *
+     * @param \WP_REST_Request $request The REST request object.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function delete_options( $request ) {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        $option_names = $request['option_names'];
+        foreach ( $option_names as $option_name ) {
+            delete_option( $option_name );
+        }
+        return new \WP_REST_Response( [ 'success' => true ], 200 );
+    }
+
+    /**
+     * Set autoload status of multiple options.
+     *
+     * @param \WP_REST_Request $request The REST request object.
+     *
+     * @return \WP_Error|\WP_REST_Response
+     */
+    public function set_autoload_options( $request ) {
+        if ( ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) || ! \wp_verify_nonce( \sanitize_text_field( \wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' ) ) {
+            return new \WP_REST_Response( [ 'error' => 'Invalid nonce' ], 403 );
+        }
+
+        $autoload = \sanitize_text_field( \wp_unslash( $request['autoload'] ) );
+
+        if ( ! in_array( $autoload, [ 'yes', 'on', 'no', 'off','auto', 'auto-on', 'auto-off' ], true ) ) {
+            return new \WP_Error( 'invalid_autoload_value', 'Invalid autoload value', [ 'status' => 400 ] );
+        }
+
+        $autoload_values = \wp_autoload_values_to_autoload();
+        $bool_autoload   = false;
+        if ( in_array( $autoload, $autoload_values, true ) ) {
+            $bool_autoload = true;
+        }
+
+        $option_names = $request['option_names'];
+
+        foreach ( $option_names as $option_name ) {
+            $option_value = get_option( $option_name );
+
+            // If the option does not exist, skip it.
+            if ( false === $option_value ) {
+                continue;
+            }
+
+            delete_option( $option_name );
+            add_option( $option_name, $option_value, '', $bool_autoload );
+        }
+        return new \WP_REST_Response( [ 'success' => true ], 200 );
+    }
+
+    /**
      * Create an option with a false value.
      *
@@ -221 +673 @@
         return new \WP_Error( 'option_not_created', 'Option could not be created', [ 'status' => 400 ] );
     }
+
+    /**
+     * Sort response data array by given column and direction.
+     *
+     * @param array<int, array<string, mixed>> $data        The data array to sort.
+     * @param string                           $column      The column key to sort by.
+     * @param int                              $direction   SORT_ASC or SORT_DESC.
+     *
+     * @return array<int, array<string, mixed>> The sorted array.
+     */
+    protected function sort_response_data_by_column( array $data, string $column, int $direction ): array {
+
+        usort(
+            $data,
+            function ( $a, $b ) use ( $column, $direction ) {
+                $val_a = $a[ "raw_$column" ] ?? $a[ $column ] ?? '';
+                $val_b = $b[ "raw_$column" ] ?? $b[ $column ] ?? '';
+
+                if ( is_numeric( $val_a ) && is_numeric( $val_b ) ) {
+                    $val_a = floatval( $val_a );
+                    $val_b = floatval( $val_b );
+
+                    return $direction === SORT_DESC ? $val_b <=> $val_a : $val_a <=> $val_b;
+                }
+
+                return $direction === SORT_DESC
+                    ? strnatcasecmp( $val_b, $val_a )
+                    : strnatcasecmp( $val_a, $val_b );
+            }
+        );
+
+        return $data;
+    }
+
+    /**
+     * Get pagination parameters from $_GET.
+     *
+     * @return array{0: int, 1: int} {
+     *     @type int $offset Pagination offset.
+     *     @type int $limit  Number of items per page.
+     * }
+     */
+    protected function get_pagination_params(): array {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return [ 0, 25 ]; // Fallback default.
+        }
+
+        $offset = isset( $_GET['start'] ) ? intval( $_GET['start'] ) : 0;
+        $limit  = isset( $_GET['length'] ) ? intval( $_GET['length'] ) : 25;
+
+        return [ $offset, $limit ];
+    }
+
+    /**
+     * Get sort column and direction from DataTables-style request.
+     *
+     * @return array{0: string, 1: int} [ string $column, int $direction (SORT_ASC|SORT_DESC) ]
+     */
+    public function get_sort_params(): array {
+        if (
+            ! isset( $_SERVER['HTTP_X_WP_NONCE'] ) ||
+            ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_SERVER['HTTP_X_WP_NONCE'] ) ), 'wp_rest' )
+        ) {
+            return [ 'name', SORT_ASC ]; // Fallback default.
+        }
+
+        if (
+            ! isset( $_GET['order'][0]['column'], $_GET['columns'] )
+            || ! is_array( $_GET['columns'] )
+            || ! isset( $_GET['columns'][ $_GET['order'][0]['column'] ]['data'] )
+        ) {
+            return [ 'name', SORT_ASC ]; // Fallback default.
+        }
+
+        $column_index = isset( $_GET['order'][0]['column'] ) ? intval( $_GET['order'][0]['column'] ) : 0;
+        $column_data  = isset( $_GET['columns'][ $column_index ]['data'] ) ? \sanitize_text_field( \wp_unslash( $_GET['columns'][ $column_index ]['data'] ) ) : 'name';
+
+        $dir      = strtolower( \sanitize_text_field( \wp_unslash( $_GET['order'][0]['dir'] ?? 'asc' ) ) );
+        $dir_flag = $dir === 'desc' ? SORT_DESC : SORT_ASC;
+
+        return [ $column_data, $dir_flag ];
+    }
+
+    /**
+     * Get the length of a value.
+     *
+     * @param mixed $value The input value.
+     *
+     * @return string
+     */
+    private function get_length( $value ) {
+        if ( empty( $value ) ) {
+            return '0.00';
+        }
+        if ( is_array( $value ) || is_object( $value ) ) {
+            // phpcs:ignore WordPress.PHP.DiscouragedPHPFunctions.serialize_serialize -- intended here.
+            $length = strlen( serialize( $value ) );
+        } elseif ( is_string( $value ) || is_numeric( $value ) ) {
+            $length = strlen( strval( $value ) );
+        }
+        if ( ! isset( $length ) ) {
+            return '0.00';
+        }
+        return number_format( ( $length / 1024 ), 2 );
+    }
+
+    /**
+     * Find plugin in known plugin prefixes list.
+     *
+     * @param string $option The option name.
+     *
+     * @return string
+     */
+    private function get_plugin_name( $option ) {
+        return $this->map_plugin_to_options->get_plugin_name( $option );
+    }
 }