wp-juggler-server/includes/class-wpjs-admin.php
2024-08-14 17:45:34 +02:00

650 lines
20 KiB
PHP

<?php
/**
* The dashboard-specific functionality of the plugin.
*
* Registers styles and scripts, adds the custom administration page,
* and processes user input on the "search/replace" form.
*
* @link https://wpjuggler.com
* @since 1.0.0
*
* @package WP_Juggler_Server
* @subpackage WP_Juggler_Server/includes
*/
// Prevent direct access.
if (! defined('WPJS_PATH')) exit;
class WPJS_Admin
{
/**
* The ID of this plugin.
*
* @since 1.0.0
* @access private
* @var string $wp_juggler_server The ID of this plugin.
*/
private $wp_juggler_server;
/**
* The version of this plugin.
*
* @since 1.0.0
* @access private
* @var string $version The current version of this plugin.
*/
private $version;
/**
* Initialize the class and set its properties.
*
* @since 1.0.0
* @var string $wp_juggler_server The name of this plugin.
* @var string $version The version of this plugin.
*/
public function __construct($wp_juggler_server, $version)
{
$this->wp_juggler_server = $wp_juggler_server;
$this->version = $version;
}
/**
* Register any CSS and JS used by the plugin.
* @since 1.0.0
* @access public
* @param string $hook Used for determining which page(s) to load our scripts.
*/
public function enqueue_scripts($hook)
{
if ('tools_page_wp-juggler-server' === $hook) {
$min = defined('SCRIPT_DEBUG') && SCRIPT_DEBUG ? '' : '.min';
wp_enqueue_style('wp-juggler-server', WPJS_URL . "assets/css/wp-juggler-server$min.css", array(), $this->version, 'all');
wp_enqueue_style('jquery-style', WPJS_URL . 'assets/css/jquery-ui.min.css', array(), $this->version, 'all');
wp_enqueue_script('jquery-ui-slider');
wp_enqueue_script('wp-juggler-server', WPJS_URL . "assets/js/wp-juggler-server$min.js", array('jquery'), $this->version, true);
wp_enqueue_style('thickbox');
wp_enqueue_script('thickbox');
wp_localize_script('wp-juggler-server', 'wpjs_object_vars', array(
'page_size' => get_option('wpjs_page_size') ? absint(get_option('wpjs_page_size')) : 20000,
'endpoint' => WPJS_AJAX::get_endpoint(),
'ajax_nonce' => wp_create_nonce('wpjs_ajax_nonce'),
'no_search' => __('No search string was defined, please enter a URL or string to search for.', 'wp-juggler-server'),
'no_tables' => __('Please select the tables that you want to update.', 'wp-juggler-server'),
'unknown' => __('An error occurred processing your request. Try decreasing the "Max Page Size", or contact support.', 'wp-juggler-server'),
'processing' => __('Processing...', 'wp-juggler-server')
));
}
}
/**
* Register any menu pages used by the plugin.
* @since 1.0.0
* @access public
*/
public function wpjs_menu_pages()
{
$cap = apply_filters('wpjs_capability', 'manage_options');
add_menu_page(
__('WP Juggler', 'wp-juggler-server'),
__('WP Juggler', 'wp-juggler-server'),
$cap,
"wp-juggler-server",
"",
"",
30
);
add_submenu_page(
'wp-juggler-server',
__('Settings', 'wp-juggler-server'),
__('Settings', 'wp-juggler-server'),
$cap,
"wp-juggler-server-settings",
[$this, 'wpjs_menu_pages_callback']
);
add_submenu_page(
'wp-juggler-server',
__('Control Panel', 'wp-juggler-server'),
__('Control Panel', 'wp-juggler-server'),
$cap,
'wp-juggler-server-panel',
[$this, 'render_admin_page']
);
//add_submenu_page('tools.php', __('Better Search Replace', 'wp-juggler-server'), __('Better Search Replace', 'wp-juggler-server'), $cap, 'wp-juggler-server', array($this, 'wpjs_menu_pages_callback'));
}
public function wpjs_cpt()
{
$labels = array(
'name' => __('Sites', 'wp-juggler-server'),
'singular_name' => __('Site', 'wp-juggler-server'),
'menu_name' => __('WP Juggler', 'wp-juggler-server'),
'all_items' => __('Sites', 'wp-juggler-server'),
'view_item' => __('View Site', 'wp-juggler-server'),
'add_new_item' => __('Add New Site', 'wp-juggler-server'),
'add_new' => __('Add New', 'wp-juggler-server'),
'edit_item' => __('Edit Site', 'wp-juggler-server'),
'update_item' => __('Update Site', 'wp-juggler-server'),
'search_items' => __('Search Sites', 'wp-juggler-server'),
'not_found' => __('Not Found', 'wp-juggler-server'),
'not_found_in_trash' => __('Not found in Trash', 'wp-juggler-server'),
);
$args = array(
'label' => __('sites', 'wp-juggler-server'),
'description' => __('Sites', 'wp-juggler-server'),
'labels' => $labels,
'supports' => array('title'),
'hierarchical' => false,
'public' => false,
'show_ui' => true,
'show_in_menu' => 'wp-juggler-server',
'show_in_nav_menus' => true,
'show_in_admin_bar' => true,
'menu_position' => 5,
'can_export' => true,
'has_archive' => false,
'exclude_from_search' => false,
'publicly_queryable' => false,
'capability_type' => 'post',
'capabilities' => array(
// todo Srediti prava za new i edit ako ikako moze, ako ne, ostaviti new
//'create_posts' => 'do_not_allow',
//'edit_posts' => 'allow'
),
'show_in_rest' => false,
);
register_post_type('wpjugglersites', $args);
}
public function wpjs_sites_metaboxes()
{
add_meta_box(
'wpjs_site_details',
__('Site Details', 'wp-juggler-server'),
array($this, 'render_juggler_sites_meta_box'),
'wpjugglersites',
'normal',
'high'
);
remove_meta_box('submitdiv', 'wpjugglersites', 'side');
add_meta_box(
'submitdiv',
__('Save', 'wp-juggler-server'),
array($this, 'render_juggler_sites_publish_meta_box'),
'wpjugglersites',
'side',
'high'
);
add_meta_box(
'wpjs_users', // ID
__('Assign Users', 'wp-juggler-server'), // Title
array($this, 'render_juggler_users_meta_box'),
'wpjugglersites', // Post type
'normal', // Context
'low' // Priority
);
}
public function render_juggler_sites_meta_box($post)
{
wp_nonce_field(basename(__FILE__), 'wp_juggler_server_nonce');
$site_url = get_post_meta($post->ID, 'wp_juggler_server_site_url', true);
$api_key = get_post_meta($post->ID, 'wp_juggler_api_key', true);
$automatic_login = get_post_meta($post->ID, 'wp_juggler_automatic_login', true);
$login_username = get_post_meta($post->ID, 'wp_juggler_login_username', true);
?>
<p>
<label for="wp_juggler_server_site_url">Site Url</label><br>
<input type="text" name="wp_juggler_server_site_url" id="wp_juggler_server_site_url" value="<?php echo esc_attr($site_url); ?>" size="60" />
</p>
<p>
<label for="wp_juggler_api_key">API Key</label><br>
<?php if (!empty($api_key)): ?>
<input type="text" name="wp_juggler_api_key" id="wp_juggler_api_key" value="<?php echo esc_attr($api_key); ?>" size="60" readonly />
<?php else: ?>
<input type="text" name="wp_juggler_api_key" id="wp_juggler_api_key" value="<?php echo wp_generate_uuid4(); ?>" size="60" readonly />
<?php endif; ?>
</p>
<p>
<label for="wp_juggler_automatic_login">Automatic Login</label><br>
<input type="checkbox" name="wp_juggler_automatic_login" id="wp_juggler_automatic_login" <?php checked($automatic_login, 'on'); ?> />
</p>
<p id="wp_juggler_login_username_paragraph">
<label for="wp_juggler_login_username">Remote Login Username</label><br>
<input type="text" name="wp_juggler_login_username" id="wp_juggler_login_username" value="<?php echo esc_attr($login_username); ?>" size="60" />
</p>
<style>
#wp_juggler_login_username_paragraph {
display: <?php echo $automatic_login === 'on' ? 'block' : 'none'; ?>;
}
</style>
<script>
document.getElementById('wp_juggler_automatic_login').addEventListener('change', function() {
document.getElementById('wp_juggler_login_username_paragraph').style.display = this.checked ? 'block' : 'none';
});
</script>
<?php
}
public function render_juggler_users_meta_box($post)
{
$saved_users = get_post_meta($post->ID, 'wp_juggler_login_users', true);
?>
<div id="juggler-users-container">
<?php
if (is_array($saved_users) && !empty($saved_users)) {
foreach ($saved_users as $user_id) {
$user = get_userdata($user_id);
echo '<div class="juggler-user-field">';
echo '<input type="text" class="regular-text juggler-user-autocomplete" name="juggler_users[]" value="' . esc_attr($user->user_login) . '" />';
echo '<button type="button" class="button juggler-remove-user">Remove</button>';
echo '</div>';
}
}
?>
</div>
<button type="button" class="button" id="juggler-add-user">Add User</button>
<script>
jQuery(document).ready(function($) {
function bindAutocomplete() {
$('.juggler-user-autocomplete').autocomplete({
source: function(request, response) {
var chosenValues = [];
$('.juggler-user-autocomplete').each(function() {
chosenValues.push($(this).val());
});
chosenValues.pop();
$.ajax({
url: ajaxurl,
data: {
action: 'juggler_user_search',
term: request.term,
wp_juggler_server_nonce: $('#wp_juggler_server_nonce').val()
},
success: function(data) {
var filteredData = $.grep(data, function(item) {
return $.inArray(item.value, chosenValues) === -1;
});
response(filteredData);
}
});
},
minLength: 2
});
}
bindAutocomplete();
$('#juggler-add-user').click(function() {
$('#juggler-users-container').append(
'<div class="juggler-user-field">' +
'<input type="text" class="regular-text juggler-user-autocomplete" name="juggler_users[]" value="" />' +
'<button type="button" class="button juggler-remove-user">Remove</button>' +
'</div>'
);
bindAutocomplete();
});
$(document).on('click', '.juggler-remove-user', function() {
$(this).closest('.juggler-user-field').remove();
});
});
</script>
<?php
}
public function render_juggler_sites_publish_meta_box($post)
{
global $action;
?>
<div class="submitbox" id="submitpost">
<div id="minor-publishing">
<div id="misc-publishing-actions">
<div class="misc-pub-section curtime misc-pub-curtime">
<span id="timestamp">
Publish on:
<b><?php echo get_the_date(); ?> at <?php echo get_the_time(); ?></b>
</span>
</div>
</div>
</div>
<div id="major-publishing-actions">
<?php
if (current_user_can("delete_post", $post->ID)) {
if (!EMPTY_TRASH_DAYS) : ?>
<div id="delete-action">
<a class="submitdelete deletion" href="<?php echo get_delete_post_link($post->ID); ?>">Move to Trash</a>
</div>
<?php else : ?>
<div id="delete-action">
<a class="submitdelete deletion" href="<?php echo get_delete_post_link($post->ID); ?>">Move to Trash</a>
</div>
<?php endif;
} ?>
<div id="publishing-action">
<span class="spinner"></span>
<input name="original_publish" type="hidden" id="original_publish" value="Publish">
<?php submit_button(__('Save'), 'primary', 'publish', false); ?>
</div>
<div class="clear"></div>
</div>
</div>
<?php
}
public function wpjs_user_search()
{
check_ajax_referer(basename(__FILE__), 'wp_juggler_server_nonce');
// Check for user capabilities
if (!current_user_can('edit_posts')) {
wp_send_json_error('You do not have permission to perform this action.');
wp_die();
}
$term = sanitize_text_field($_GET['term']);
$user_query = new WP_User_Query(array(
'search' => '*' . esc_attr($term) . '*',
'search_columns' => array('user_login', 'user_nicename', 'user_email', 'display_name'),
));
$users = $user_query->get_results();
$results = array();
foreach ($users as $user) {
$results[] = array(
'label' => $user->user_login,
'value' => $user->user_login,
);
}
wp_send_json($results);
}
public function wpjs_save_sites_meta_boxes($post_id)
{
if (!isset($_POST['wp_juggler_server_nonce']) || !wp_verify_nonce($_POST['wp_juggler_server_nonce'], basename(__FILE__))) {
return;
}
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return;
}
if (!current_user_can('edit_post', $post_id)) {
return;
}
if (isset($_POST['wp_juggler_server_site_url'])) {
update_post_meta($post_id, 'wp_juggler_server_site_url', sanitize_text_field($_POST['wp_juggler_server_site_url']));
}
if (isset($_POST['wp_juggler_api_key']) && !empty($_POST['wp_juggler_api_key'])) {
update_post_meta($post_id, 'wp_juggler_api_key', sanitize_text_field($_POST['wp_juggler_api_key']));
} else {
update_post_meta($post_id, 'wp_juggler_api_key', wp_generate_uuid4());
}
$automatic_login = isset($_POST['wp_juggler_automatic_login']) ? 'on' : 'off';
update_post_meta($post_id, 'wp_juggler_automatic_login', $automatic_login);
if (isset($_POST['wp_juggler_login_username'])) {
update_post_meta($post_id, 'wp_juggler_login_username', sanitize_text_field($_POST['wp_juggler_login_username']));
}
$users = array();
if (isset($_POST['juggler_users'])) {
foreach ($_POST['juggler_users'] as $user_login) {
$user = get_user_by('login', sanitize_text_field($user_login));
if ($user) {
$users[] = $user->ID;
}
}
}
update_post_meta($post_id, 'wp_juggler_login_users', $users);
}
public function wpjs_add_custom_column($columns) {
return array_merge(
array_slice($columns, 0, 2, true),
array('server_site_url' => 'Site URL'),
array_slice($columns, 2, null, true)
);
}
function wpjs_display_custom_column($column, $post_id) {
if ($column == 'server_site_url') {
echo esc_html(get_post_meta($post_id, 'wp_juggler_server_site_url', true));
}
}
/**
* The callback for creating a new submenu page under the "Tools" menu.
* @access public
*/
public function wpjs_menu_pages_callback()
{
require_once WPJS_PATH . 'includes/class-wpjs-templates-helper.php';
require_once WPJS_PATH . 'templates/wpjs-dashboard.php';
}
/**
* Renders the result or error onto the wp-juggler-server admin page.
* @access public
*/
public static function render_result()
{
if (isset($_GET['result']) && $result = get_transient('wpjs_results')) {
if (isset($result['dry_run']) && $result['dry_run'] === 'on') {
$msg = sprintf(
__('<p><strong>DRY RUN:</strong> <strong>%d</strong> tables were searched, <strong>%d</strong> cells were found that need to be updated, and <strong>%d</strong> changes were made.</p><p><a href="%s" class="thickbox" title="Dry Run Details">Click here</a> for more details, or use the form below to run the search/replace.</p>', 'wp-juggler-server'),
$result['tables'],
$result['change'],
$result['updates'],
get_admin_url() . 'admin-post.php?action=wpjs_view_details&TB_iframe=true&width=800&height=500'
);
} else {
$msg = sprintf(
__('<p>During the search/replace, <strong>%d</strong> tables were searched, with <strong>%d</strong> cells changed in <strong>%d</strong> updates.</p><p><a href="%s" class="thickbox" title="Search/Replace Details">Click here</a> for more details.</p>', 'wp-juggler-server'),
$result['tables'],
$result['change'],
$result['updates'],
get_admin_url() . 'admin-post.php?action=wpjs_view_details&TB_iframe=true&width=800&height=500'
);
}
echo '<div class="updated bsr-updated" style="display: none;">' . $msg . '</div>';
}
}
/**
* Prefills the given value on the search/replace page (dry run, live run, from profile).
* @access public
* @param string $value The value to check for.
* @param string $type The type of the value we're filling.
*/
public static function prefill_value($value, $type = 'text')
{
// Grab the correct data to prefill.
if (isset($_GET['result']) && get_transient('wpjs_results')) {
$values = get_transient('wpjs_results');
} else {
$values = array();
}
// Prefill the value.
if (isset($values[$value])) {
if ('checkbox' === $type && 'on' === $values[$value]) {
echo 'checked';
} else {
echo str_replace('#WPJS_BACKSLASH#', '\\', esc_attr(htmlentities($values[$value])));
}
}
}
/**
* Loads the tables available to run a search replace, prefilling if already
* selected the tables.
* @access public
*/
public static function load_tables()
{
// Get the tables and their sizes.
$tables = WPJS_DB::get_tables();
$sizes = WPJS_DB::get_sizes();
echo '<select id="bsr-table-select" name="select_tables[]" multiple="multiple" style="">';
foreach ($tables as $table) {
// Try to get the size for this specific table.
$table_size = isset($sizes[$table]) ? $sizes[$table] : '';
if (isset($_GET['result']) && get_transient('wpjs_results')) {
$result = get_transient('wpjs_results');
if (isset($result['table_reports'][$table])) {
echo "<option value='$table' selected>$table $table_size</option>";
} else {
echo "<option value='$table'>$table $table_size</option>";
}
} else {
echo "<option value='$table'>$table $table_size</option>";
}
}
echo '</select>';
}
/**
* Loads the result details (via Thickbox).
* @access public
*/
public function load_details()
{
if (get_transient('wpjs_results')) {
$results = get_transient('wpjs_results');
$min = (defined('SCRIPT_DEBUG') && true === SCRIPT_DEBUG) ? '' : '.min';
$wpjs_styles = WPJS_URL . 'assets/css/wp-juggler-server.css?v=' . WPJS_VERSION;
?>
<link href="<?php echo esc_url(get_admin_url(null, '/css/common' . $min . '.css')); ?>" rel="stylesheet" type="text/css" />
<link href="<?php echo esc_url($wpjs_styles); ?>" rel="stylesheet" type="text/css">
<div style="padding: 32px; background-color: var(--color-white); min-height: 100%;">
<table id="bsr-results-table" class="widefat">
<thead>
<tr>
<th class="bsr-first"><?php _e('Table', 'wp-juggler-server'); ?></th>
<th class="bsr-second"><?php _e('Changes Found', 'wp-juggler-server'); ?></th>
<th class="bsr-third"><?php _e('Rows Updated', 'wp-juggler-server'); ?></th>
<th class="bsr-fourth"><?php _e('Time', 'wp-juggler-server'); ?></th>
</tr>
</thead>
<tbody>
<?php
foreach ($results['table_reports'] as $table_name => $report) {
$time = $report['end'] - $report['start'];
if ($report['change'] != 0) {
$report['change'] = '<a class="tooltip">' . esc_html($report['change']) . '</a>';
$upgrade_link = sprintf(
__('<a href="%s" target="_blank">UPGRADE</a> to view details on the exact changes that will be made.', 'wp-juggler-server'),
'https://deliciousbrains.com/wp-juggler-server/upgrade/?utm_source=insideplugin&utm_medium=web&utm_content=tooltip&utm_campaign=bsr-to-migrate'
);
$report['change'] .= '<span class="helper-message right">' . $upgrade_link . '</span>';
}
if ($report['updates'] != 0) {
$report['updates'] = '<strong>' . esc_html($report['updates']) . '</strong>';
}
echo '<tr><td class="bsr-first">' . esc_html($table_name) . '</td><td class="bsr-second">' . $report['change'] . '</td><td class="bsr-third">' . $report['updates'] . '</td><td class="bsr-fourth">' . round($time, 3) . __(' seconds', 'wp-juggler-server') . '</td></tr>';
}
?>
</tbody>
</table>
</div>
<?php
}
}
/**
* Registers our settings in the options table.
* @access public
*/
public function register_option()
{
register_setting('wpjs_settings_fields', 'wpjs_page_size', 'absint');
}
/**
* Downloads the system info file for support.
* @access public
*/
public function download_sysinfo()
{
check_admin_referer('wpjs_download_sysinfo', 'wpjs_sysinfo_nonce');
$cap = apply_filters('wpjs_capability', 'manage_options');
if (! current_user_can($cap)) {
return;
}
nocache_headers();
header('Content-Type: text/plain');
header('Content-Disposition: attachment; filename="bsr-system-info.txt"');
echo wp_strip_all_tags($_POST['bsr-sysinfo']);
die();
}
/**
* Displays the link to upgrade to BSR Pro
* @access public
* @param array $links The links assigned to the plugin.
*/
public function meta_upgrade_link($links, $file)
{
$plugin = plugin_basename(WPJS_FILE);
if ($file == $plugin) {
return array_merge(
$links,
array('<a href="https://bettersearchreplace.com/?utm_source=insideplugin&utm_medium=web&utm_content=plugins-page&utm_campaign=pro-upsell">' . __('Upgrade to Pro', 'wp-juggler-server') . '</a>')
);
}
return $links;
}
}