PluginProbe
MxChat – AI Chatbot & Content Generation for WordPress / 3.1.4
MxChat – AI Chatbot & Content Generation for WordPress v3.1.4
3.2.21 3.2.20 3.2.19 3.2.18 3.2.17 3.2.16 3.2.15 3.2.14 3.2.12 3.2.13 3.2.11 3.2.10 3.2.9 3.2.8 3.2.7 3.2.6 3.2.5 3.2.4 3.2.3 3.2.2 3.2.1 2.0.3 2.0.4 2.0.5 2.0.6 All 152 releases
← All changes | includes/class-mxchat-admin.php +339 -2507 3.2.12 → 3.1.4 View file →
@@ -37,22 +37,11 @@
37 37 }
38 38
39 39 // Add admin menu and initialize settings
40 40 add_action('admin_menu', array($this, 'mxchat_add_plugin_page'));
41 - // Pro & Extensions registers at priority 30 so it always lands last in
42 - // the sidebar — below API Access (priority 20) and below any other
43 - // submenu that hooks at default priority 10.
44 - add_action('admin_menu', array($this, 'mxchat_add_pro_extensions_page'), 30);
45 - // Onboarding visibility — runs LAST so it can remove the submenu after every
46 - // other add_submenu_page() call. The page stays reachable by direct URL.
47 - add_action('admin_menu', array($this, 'mxchat_apply_onboarding_visibility'), 999);
48 41 add_action('admin_init', array($this, 'mxchat_page_init'));
49 42 add_action('admin_init', array($this, 'mxchat_prompts_page_init'));
50 43 add_action('admin_enqueue_scripts', array($this, 'mxchat_enqueue_admin_assets'));
51 - // Add body class for the Onboarding wizard (plan-905439) so the
52 - // chrome-surgery CSS in admin-onboarding-wizard.css can scope its
53 - // WP-sidebar collapse to this page only.
54 - add_filter('admin_body_class', array($this, 'mxchat_add_onboarding_body_class'));
55 44 add_action('wp_ajax_mxchat_delete_chat_history', array($this, 'mxchat_delete_chat_history'));
56 45 add_action('admin_post_mxchat_delete_prompt', array($this, 'mxchat_handle_delete_prompt'));
57 46 add_action('wp_ajax_mxchat_fetch_chat_history', array($this, 'mxchat_fetch_chat_history'));
58 47 add_action('wp_ajax_nopriv_mxchat_fetch_chat_history', array($this, 'mxchat_fetch_chat_history'));
@@ -65,14 +54,8 @@
65 54 add_action('admin_post_mxchat_add_intent', array($this, 'mxchat_handle_add_intent'));
66 55 add_action('admin_post_mxchat_delete_intent', array($this, 'mxchat_handle_delete_intent'));
67 56 add_action('admin_post_mxchat_edit_intent', array($this, 'mxchat_handle_edit_intent'));
68 57 add_action('wp_ajax_mxchat_export_transcripts', array($this, 'export_chat_transcripts'));
69 -
70 - // Leads tab (inside Transcripts)
71 - add_action('wp_ajax_mxchat_fetch_leads', array($this, 'mxchat_fetch_leads'));
72 - add_action('wp_ajax_mxchat_delete_leads', array($this, 'mxchat_delete_leads'));
73 - add_action('wp_ajax_mxchat_export_leads', array($this, 'mxchat_export_leads'));
74 -
75 58 add_action('admin_init', array($this, 'mxchat_transcripts_page_init'));
76 59 add_action('wp_ajax_dismiss_live_agent_notice', array($this, 'dismiss_live_agent_notice'));
77 60 add_action('wp_ajax_dismiss_theme_migration_notice', array($this, 'dismiss_theme_migration_notice'));
78 61 add_action('mxchat_cleanup_old_transcripts', array($this, 'cleanup_old_transcripts'));
@@ -96,12 +79,8 @@
96 79 add_action('wp_ajax_mxchat_bulk_delete_actions', array($this, 'mxchat_bulk_delete_actions'));
97 80 add_action('wp_ajax_mxchat_add_intent_ajax', array($this, 'mxchat_add_intent_ajax'));
98 81 add_action('wp_ajax_mxchat_edit_intent_ajax', array($this, 'mxchat_edit_intent_ajax'));
99 82 add_action('wp_ajax_mxchat_delete_intent_ajax', array($this, 'mxchat_delete_intent_ajax'));
100 - add_action('wp_ajax_mxchat_add_phrase', array($this, 'mxchat_add_phrase_ajax'));
101 - add_action('wp_ajax_mxchat_delete_phrase', array($this, 'mxchat_delete_phrase_ajax'));
102 - add_action('wp_ajax_mxchat_get_phrases', array($this, 'mxchat_get_phrases_ajax'));
103 - add_action('wp_ajax_mxchat_delete_legacy_phrases', array($this, 'mxchat_delete_legacy_phrases_ajax'));
104 83
105 84 // Slack test connection
106 85 add_action('wp_ajax_mxchat_test_slack_connection', array($this, 'mxchat_test_slack_connection'));
107 86
@@ -107,149 +86,16 @@
107 86
108 87 // Translation handlers
109 88 add_action('wp_ajax_mxchat_translate_messages', array($this, 'mxchat_translate_messages'));
110 89 add_action('wp_ajax_mxchat_get_transcript_translation', array($this, 'mxchat_get_transcript_translation'));
111 -
112 - // 3.2.3: Embedding model switch protection
113 - add_action('wp_ajax_mxchat_check_embedding_switch', array($this, 'mxchat_check_embedding_switch_ajax'));
114 - add_action('wp_ajax_mxchat_dismiss_embedding_mismatch', array($this, 'mxchat_dismiss_embedding_mismatch_ajax'));
115 - add_action('admin_notices', array($this, 'mxchat_embedding_mismatch_notice'));
116 90 }
117 91
118 - /**
119 - * 3.2.3: Preflight check before allowing the embedding model dropdown to
120 - * switch. Pure option comparison — no counts, no DB queries beyond the
121 - * cached options. The dialog is shown whenever the user has previously
122 - * embedded with a different model than the one they're switching to.
123 - */
124 - public function mxchat_check_embedding_switch_ajax() {
125 - check_ajax_referer('mxchat_admin_nonce', 'security');
126 - if (!current_user_can('manage_options')) {
127 - wp_send_json_error(__('Unauthorized', 'mxchat'));
128 - }
129 -
130 - $new_model = isset($_POST['new_model']) ? sanitize_text_field(wp_unslash($_POST['new_model'])) : '';
131 - $active_model = MxChat_Utils::get_active_embedding_model();
132 -
133 - $is_mismatch = !empty($active_model) && !empty($new_model) && $active_model !== $new_model;
134 -
135 - $active_dims = MxChat_Utils::embedding_model_dimensions($active_model);
136 - $new_dims = MxChat_Utils::embedding_model_dimensions($new_model);
137 -
138 - wp_send_json_success(array(
139 - 'is_mismatch' => $is_mismatch,
140 - 'active_model' => $active_model,
141 - 'active_label' => MxChat_Utils::embedding_model_label($active_model),
142 - 'new_model' => $new_model,
143 - 'new_label' => MxChat_Utils::embedding_model_label($new_model),
144 - 'dims_differ' => ($active_dims > 0 && $new_dims > 0 && $active_dims !== $new_dims),
145 - 'active_dims' => $active_dims,
146 - 'new_dims' => $new_dims,
147 - ));
148 - }
149 -
150 - /**
151 - * 3.2.3: Dismiss the persistent mismatch banner. Tied to the active+selected
152 - * pair so the banner reappears on the next switch event.
153 - */
154 - public function mxchat_dismiss_embedding_mismatch_ajax() {
155 - check_ajax_referer('mxchat_admin_nonce', 'security');
156 - if (!current_user_can('manage_options')) {
157 - wp_send_json_error(__('Unauthorized', 'mxchat'));
158 - }
159 -
160 - $options = get_option('mxchat_options', array());
161 - $selected = $options['embedding_model'] ?? '';
162 - $active = MxChat_Utils::get_active_embedding_model();
163 - update_option('mxchat_dismissed_embedding_mismatch', $active . '|' . $selected, false);
164 - wp_send_json_success();
165 - }
166 -
167 - /**
168 - * 3.2.3: Persistent admin banner shown whenever the active embedding model
169 - * (last used to actually embed something) differs from the currently
170 - * selected model. Pure option comparison — no DB queries on every page
171 - * load. The banner auto-clears once both match again, i.e. after a delete
172 - * + re-embed cycle.
173 - */
174 - public function mxchat_embedding_mismatch_notice() {
175 - if (!current_user_can('manage_options')) {
176 - return;
177 - }
178 -
179 - $options = get_option('mxchat_options', array());
180 - $selected = $options['embedding_model'] ?? '';
181 - $active = MxChat_Utils::get_active_embedding_model();
182 -
183 - if (empty($active) || empty($selected) || $active === $selected) {
184 - return;
185 - }
186 -
187 - $dismissed = get_option('mxchat_dismissed_embedding_mismatch', '');
188 - if ($dismissed === $active . '|' . $selected) {
189 - return;
190 - }
191 -
192 - $active_label = MxChat_Utils::embedding_model_label($active);
193 - $selected_label = MxChat_Utils::embedding_model_label($selected);
194 - $active_dims = MxChat_Utils::embedding_model_dimensions($active);
195 - $selected_dims = MxChat_Utils::embedding_model_dimensions($selected);
196 - $dims_differ = ($active_dims > 0 && $selected_dims > 0 && $active_dims !== $selected_dims);
197 -
198 - $kb_url = admin_url('admin.php?page=mxchat-prompts');
199 - $actions_url = admin_url('admin.php?page=mxchat-actions');
200 -
201 - ?>
202 - <div class="notice notice-error is-dismissible mxchat-embedding-mismatch-notice"
203 - data-active="<?php echo esc_attr($active); ?>"
204 - data-selected="<?php echo esc_attr($selected); ?>">
205 - <p><strong><?php esc_html_e('MxChat: Embedding model mismatch detected', 'mxchat'); ?></strong></p>
206 - <p>
207 - <?php
208 - printf(
209 - /* translators: 1: previously-used model name, 2: currently-selected model name */
210 - esc_html__('Your knowledge base and actions were embedded with %1$s, but %2$s is now selected. Similarity matching will return inaccurate or empty results until you delete all existing embeddings and re-embed your content with the new model.', 'mxchat'),
211 - '<code>' . esc_html($active_label) . '</code>',
212 - '<code>' . esc_html($selected_label) . '</code>'
213 - );
214 - ?>
215 - </p>
216 - <?php if ($dims_differ) : ?>
217 - <p>
218 - <strong><?php esc_html_e('Dimension mismatch:', 'mxchat'); ?></strong>
219 - <?php
220 - printf(
221 - /* translators: 1: old dim count, 2: new dim count */
222 - esc_html__('Existing vectors are %1$d-dimensional but the new model produces %2$d-dimensional vectors. If you use Pinecone, your index will reject queries entirely until re-embedded.', 'mxchat'),
223 - (int) $active_dims,
224 - (int) $selected_dims
225 - );
226 - ?>
227 - </p>
228 - <?php endif; ?>
229 - <p>
230 - <?php esc_html_e('To fix this:', 'mxchat'); ?>
231 - <a href="<?php echo esc_url($kb_url); ?>"><?php esc_html_e('Delete all knowledge base entries', 'mxchat'); ?></a> ·
232 - <a href="<?php echo esc_url($actions_url); ?>"><?php esc_html_e('Delete all actions', 'mxchat'); ?></a> ·
233 - <?php esc_html_e('then re-import / re-add them with the new model selected.', 'mxchat'); ?>
234 - </p>
235 - </div>
236 - <script>
237 - (function($){
238 - $(document).on('click', '.mxchat-embedding-mismatch-notice .notice-dismiss', function(){
239 - $.post(ajaxurl, {
240 - action: 'mxchat_dismiss_embedding_mismatch',
241 - security: '<?php echo esc_js(wp_create_nonce('mxchat_admin_nonce')); ?>'
242 - });
243 - });
244 - })(jQuery);
245 - </script>
246 - <?php
247 - }
248 -
249 92 private function is_license_active() {
93 + // Get the raw value without translation
250 94 $license_status = get_option('mxchat_license_status', 'inactive');
251 - return ($license_status === 'active');
95 +
96 + // Check against multiple possible values, bypassing translation issues
97 + return ($license_status === 'active' || $license_status === esc_html__('active', 'mxchat'));
252 98 }
253 99
254 100 private function initialize_default_options() {
255 101 $default_options = array(
@@ -298,14 +144,9 @@
298 144 'post_type_visibility_mode' => 'all', // 'all', 'include', 'exclude'
299 145 'post_type_visibility_list' => array(), // Array of post type slugs
300 146 'contextual_awareness_toggle' => 'off',
301 147 'citation_links_toggle' => 'on',
302 - 'satisfaction_rating_enabled' => 'off',
303 - 'satisfaction_rating_idle_seconds' => 60,
304 - 'satisfaction_rating_question' => '',
305 - 'satisfaction_rating_thanks' => '',
306 - 'satisfaction_rating_placeholder' => '',
307 - 'satisfaction_rating_saved' => '',
148 + 'show_frontend_debugger' => 'on',
308 149 'close_button_color' => esc_html__('#fff', 'mxchat'),
309 150 'chatbot_bg_color' => esc_html__('#fff', 'mxchat'),
310 151 'user_message_bg_color' => esc_html__('#fff', 'mxchat'),
311 152 'user_message_font_color' => esc_html__('#212121', 'mxchat'),
@@ -384,55 +225,26 @@
384 225 $this->options = $merged_options;
385 226 }
386 227
387 228 public function mxchat_add_plugin_page() {
388 - // Onboarding lifecycle helpers (admin_init redirect + ajax handlers live in the file).
389 - require_once plugin_dir_path(__FILE__) . 'admin-onboarding-page.php';
390 -
391 - // Main menu page — `mxchat-max` remains the parent slug for every MxChat submenu
392 - // (Settings, Knowledge, Transcripts, …). Hitting `?page=mxchat-max` directly now
393 - // dispatches to the Onboarding page (or Settings if the user has dismissed onboarding).
229 + // Main menu page
394 230 add_menu_page(
231 + esc_html__('MxChat Settings', 'mxchat'),
395 232 esc_html__('MxChat', 'mxchat'),
396 - esc_html__('MxChat', 'mxchat'),
397 233 'manage_options',
398 234 'mxchat-max',
399 - array($this, 'mxchat_create_dashboard_page'),
235 + array($this, 'mxchat_create_admin_page'),
400 236 'dashicons-testimonial',
401 237 6
402 238 );
403 239
404 - // Onboarding submenu — first child under MxChat (plan-d14e89).
405 - // First registration uses menu_slug === parent slug 'mxchat-max' →
406 - // WP-canonical override of the auto-duplicate "MxChat" entry. Result: the
407 - // first child shows as "Onboarding" instead of a redundant pair.
240 + // Rename the first submenu item from "MxChat" to "Settings"
408 241 add_submenu_page(
409 242 'mxchat-max',
410 - esc_html__('MxChat Onboarding', 'mxchat'),
411 - esc_html__('Onboarding', 'mxchat'),
412 - 'manage_options',
413 - 'mxchat-max',
414 - array($this, 'mxchat_create_dashboard_page')
415 - );
416 - // Hidden route for `?page=mxchat-onboarding` (Settings "Show again" link
417 - // + legacy redirects still target this slug). Parent === null keeps it
418 - // out of the menu while remaining accessible by URL.
419 - add_submenu_page(
420 - null,
421 - esc_html__('MxChat Onboarding', 'mxchat'),
422 - esc_html__('Onboarding', 'mxchat'),
423 - 'manage_options',
424 - 'mxchat-onboarding',
425 - array($this, 'mxchat_create_dashboard_page')
426 - );
427 -
428 - // Settings submenu — same callback as before, just at a new slug.
429 - add_submenu_page(
430 - 'mxchat-max',
431 243 esc_html__('MxChat Settings', 'mxchat'),
432 244 esc_html__('Settings', 'mxchat'),
433 245 'manage_options',
434 - 'mxchat-settings',
246 + 'mxchat-max',
435 247 array($this, 'mxchat_create_admin_page')
436 248 );
437 249
438 250 // Submenu page for Knowledge
@@ -472,16 +284,9 @@
472 284 'mxchat-content',
473 285 array($this, 'mxchat_create_content_page')
474 286 );
475 287
476 -}
477 -
478 -/**
479 - * Register the Pro & Extensions submenu on a later admin_menu priority so it
480 - * always renders as the bottom-most item in the MxChat sidebar — below
481 - * configuration pages like API Access (priority 20).
482 - */
483 -public function mxchat_add_pro_extensions_page() {
288 + // Consolidated Pro & Extensions page (replaces separate Add Ons and Pro Upgrade pages)
484 289 add_submenu_page(
485 290 'mxchat-max',
486 291 esc_html__('Pro & Extensions', 'mxchat'),
487 292 esc_html__('Pro & Extensions', 'mxchat'),
@@ -1069,54 +874,8 @@
1069 874 </div>
1070 875 <?php
1071 876 }
1072 877 }
1073 -/**
1074 - * Render the Onboarding page. Delegates to the procedural renderer in
1075 - * includes/admin-onboarding-page.php. Wired to both `?page=mxchat-max`
1076 - * (legacy top-level URL) and `?page=mxchat-onboarding` (the canonical
1077 - * Onboarding submenu).
1078 - *
1079 - * When the user has dismissed onboarding and lands on `mxchat-max` (the
1080 - * legacy URL, since the Onboarding submenu has been removed), redirect to
1081 - * Settings instead — the page is "graduated" and we shouldn't dump them
1082 - * back onto it. They can still navigate here directly via the unhide link.
1083 - */
1084 -public function mxchat_create_dashboard_page() {
1085 - require_once plugin_dir_path(__FILE__) . 'admin-onboarding-page.php';
1086 -
1087 - $current = isset($_GET['page']) ? sanitize_key($_GET['page']) : '';
1088 - if ($current === 'mxchat-max' && function_exists('mxchat_onboarding_is_dismissed') && mxchat_onboarding_is_dismissed()) {
1089 - wp_safe_redirect(admin_url('admin.php?page=mxchat-settings'));
1090 - exit;
1091 - }
1092 -
1093 - if (function_exists('mxchat_render_onboarding_page')) {
1094 - mxchat_render_onboarding_page();
1095 - return;
1096 - }
1097 - // Defensive: if the include failed to load, fall back to the old Settings page
1098 - // so the top-level menu never lands on an empty screen.
1099 - $this->mxchat_create_admin_page();
1100 -}
1101 -
1102 -/**
1103 - * Hide the Onboarding submenu when the user has dismissed it (either
1104 - * manually or via auto-graduation). The page itself remains routable so
1105 - * the Settings "Show MxChat Onboarding again" link can navigate back to it.
1106 - */
1107 -public function mxchat_apply_onboarding_visibility() {
1108 - if (!function_exists('mxchat_onboarding_is_dismissed')) {
1109 - return;
1110 - }
1111 - if (mxchat_onboarding_is_dismissed()) {
1112 - // The first MxChat child is the same-slug-as-parent registration
1113 - // (slug 'mxchat-max', labelled "Onboarding") added in plan-d14e89.
1114 - // Remove it so the menu opens straight to Settings after dismiss.
1115 - remove_submenu_page('mxchat-max', 'mxchat-max');
1116 - }
1117 -}
1118 -
1119 878 public function mxchat_create_admin_page() {
1120 879 $this->add_live_agent_nonce();
1121 880 $this->add_theme_migration_nonce();
1122 881
@@ -1358,11 +1117,8 @@
1358 1117 $chart_messages[] = 0;
1359 1118 }
1360 1119 }
1361 1120
1362 - // Satisfaction rating rollup — last 30 days, grouped by bot (plan-a5b006).
1363 - $satisfaction_stats = $this->get_satisfaction_rating_stats(30);
1364 -
1365 1121 // Prepare page data for the template
1366 1122 $page_data = array(
1367 1123 'total_chats' => $total_chats,
1368 1124 'total_messages' => $total_messages,
@@ -1377,9 +1133,8 @@
1377 1133 'busiest_hour' => $busiest_hour,
1378 1134 'chart_labels' => $chart_labels,
1379 1135 'chart_chats' => $chart_chats,
1380 1136 'chart_messages' => $chart_messages,
1381 - 'satisfaction_stats' => $satisfaction_stats,
1382 1137 );
1383 1138
1384 1139 // Include and render the new template
1385 1140 require_once plugin_dir_path(__FILE__) . 'admin-transcripts-page.php';
@@ -1386,50 +1141,8 @@
1386 1141 mxchat_render_transcripts_page($this, $page_data);
1387 1142 }
1388 1143
1389 1144 /**
1390 - * Per-bot satisfaction rating rollup over the last $days days. Used by the
1391 - * Satisfaction card on the Transcripts dashboard (plan-a5b006).
1392 - *
1393 - * @param int $days Window in days.
1394 - * @return array Each entry: ['bot_id', 'total', 'positive', 'negative', 'positive_pct', 'negative_pct'].
1395 - */
1396 -public function get_satisfaction_rating_stats($days = 30) {
1397 - global $wpdb;
1398 - $table = $wpdb->prefix . 'mxchat_session_ratings';
1399 - if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table)) !== $table) {
1400 - return array();
1401 - }
1402 - $days = max(1, (int) $days);
1403 - $rows = $wpdb->get_results($wpdb->prepare(
1404 - "SELECT bot_id,
1405 - COUNT(*) AS total,
1406 - SUM(CASE WHEN rating_value = 1 THEN 1 ELSE 0 END) AS positive,
1407 - SUM(CASE WHEN rating_value = -1 THEN 1 ELSE 0 END) AS negative
1408 - FROM {$table}
1409 - WHERE created_at >= DATE_SUB(NOW(), INTERVAL %d DAY)
1410 - GROUP BY bot_id
1411 - ORDER BY total DESC",
1412 - $days
1413 - ));
1414 - $out = array();
1415 - foreach ((array) $rows as $row) {
1416 - $total = (int) $row->total;
1417 - $positive = (int) $row->positive;
1418 - $negative = (int) $row->negative;
1419 - $out[] = array(
1420 - 'bot_id' => $row->bot_id ?: 'default',
1421 - 'total' => $total,
1422 - 'positive' => $positive,
1423 - 'negative' => $negative,
1424 - 'positive_pct' => $total > 0 ? (int) round(($positive / $total) * 100) : 0,
1425 - 'negative_pct' => $total > 0 ? (int) round(($negative / $total) * 100) : 0,
1426 - );
1427 - }
1428 - return $out;
1429 -}
1430 -
1431 -/**
1432 1145 * Get chart data for transcripts page
1433 1146 * Used by both page render and script localization
1434 1147 *
1435 1148 * @return array Chart data with labels, chats, and messages arrays
@@ -1541,39 +1254,8 @@
1541 1254 </p>
1542 1255 <?php
1543 1256 }
1544 1257
1545 -/**
1546 - * Custom retention-days input. When > 0 it overrides the bucket dropdown above
1547 - * and deletes transcripts older than the given number of days. Set to 0 to fall
1548 - * back to the dropdown (or "Never" if the dropdown is also Never).
1549 - *
1550 - * Devs can override the final day count via the `mxchat_transcript_retention_days`
1551 - * filter — runs in `cleanup_old_transcripts()` after this option is read.
1552 - *
1553 - * (plan-mxchat-20260509-9b80b1)
1554 - */
1555 -public function mxchat_retention_days_callback() {
1556 - $options = get_option('mxchat_transcripts_options', array());
1557 - $days = isset($options['mxchat_retention_days']) ? (int) $options['mxchat_retention_days'] : 0;
1558 - ?>
1559 - <input type="number"
1560 - id="mxchat_retention_days"
1561 - name="mxchat_transcripts_options[mxchat_retention_days]"
1562 - value="<?php echo esc_attr($days); ?>"
1563 - min="0"
1564 - max="3650"
1565 - step="1"
1566 - style="width: 90px;" />
1567 - <p class="description">
1568 - <?php esc_html_e('Number of days to retain transcripts. When set to a value greater than 0, this overrides the dropdown above. Set to 0 to use the dropdown. Maximum 3650 (10 years). A daily wp-cron task removes anything older, cascading to translations and click-tracking rows.', 'mxchat'); ?>
1569 - <br>
1570 - <code>apply_filters( 'mxchat_transcript_retention_days', $days )</code>
1571 - <?php esc_html_e('lets developers override the final day count programmatically.', 'mxchat'); ?>
1572 - </p>
1573 - <?php
1574 -}
1575 -
1576 1258 public function mxchat_auto_email_transcript_callback() {
1577 1259 $options = get_option('mxchat_transcripts_options', array());
1578 1260 $enabled = isset($options['mxchat_auto_email_transcript_enabled']) ? $options['mxchat_auto_email_transcript_enabled'] : 0;
1579 1261 $delay = isset($options['mxchat_auto_email_transcript_delay']) ? $options['mxchat_auto_email_transcript_delay'] : '30';
@@ -1649,29 +1331,15 @@
1649 1331 } else {
1650 1332 $sanitized['mxchat_auto_delete_transcripts'] = 'never';
1651 1333 }
1652 1334
1653 - // Sanitize custom retention-days override (plan-9b80b1).
1654 - if (isset($input['mxchat_retention_days'])) {
1655 - $days = (int) $input['mxchat_retention_days'];
1656 - $sanitized['mxchat_retention_days'] = max(0, min(3650, $days));
1657 - } else {
1658 - $sanitized['mxchat_retention_days'] = 0;
1659 - }
1660 -
1661 - // Get old values to check if auto-delete or retention-days changed.
1335 + // Get old value to check if auto-delete setting changed
1662 1336 $old_options = get_option('mxchat_transcripts_options');
1663 1337 $old_interval = isset($old_options['mxchat_auto_delete_transcripts']) ? $old_options['mxchat_auto_delete_transcripts'] : 'never';
1664 - $old_retention = isset($old_options['mxchat_retention_days']) ? (int) $old_options['mxchat_retention_days'] : 0;
1665 -
1666 - // If either setting changed, reschedule the cron job. The schedule_transcript_cleanup
1667 - // helper now treats "any active retention" (dropdown != never OR custom days > 0) as a
1668 - // reason to keep the daily cron registered.
1669 - $interval_changed = ($old_interval !== $sanitized['mxchat_auto_delete_transcripts']);
1670 - $retention_changed = ($old_retention !== $sanitized['mxchat_retention_days']);
1671 - if ($interval_changed || $retention_changed) {
1672 - $any_active = ($sanitized['mxchat_auto_delete_transcripts'] !== 'never') || ($sanitized['mxchat_retention_days'] > 0);
1673 - $this->schedule_transcript_cleanup($any_active ? 'active' : 'never');
1338 +
1339 + // If the auto-delete setting changed, reschedule the cron job
1340 + if ($old_interval !== $sanitized['mxchat_auto_delete_transcripts']) {
1341 + $this->schedule_transcript_cleanup($sanitized['mxchat_auto_delete_transcripts']);
1674 1342 }
1675 1343
1676 1344 // Sanitize auto-email transcript settings
1677 1345 $sanitized['mxchat_auto_email_transcript_enabled'] = isset($input['mxchat_auto_email_transcript_enabled']) ? 1 : 0;
@@ -1699,13 +1367,10 @@
1699 1367 $timestamp = wp_next_scheduled('mxchat_cleanup_old_transcripts');
1700 1368 if ($timestamp) {
1701 1369 wp_unschedule_event($timestamp, 'mxchat_cleanup_old_transcripts');
1702 1370 }
1703 -
1704 - // Schedule new event whenever retention is active. "active" is the canonical
1705 - // value passed by sanitize_transcripts_options when either the dropdown != never
1706 - // OR the custom retention-days > 0; "never" turns the cron off. Any other value
1707 - // (the legacy "1week" / "2weeks" / "1month" strings) is also treated as active.
1371 +
1372 + // Schedule new event if not set to "never"
1708 1373 if ($interval !== 'never') {
1709 1374 // Schedule to run daily at 3 AM
1710 1375 $next_run = strtotime('tomorrow 3:00 AM');
1711 1376 wp_schedule_event($next_run, 'daily', 'mxchat_cleanup_old_transcripts');
@@ -1715,74 +1380,58 @@
1715 1380 /**
1716 1381 * Delete old transcripts based on the configured interval
1717 1382 */
1718 1383 public function cleanup_old_transcripts() {
1719 - $options = get_option('mxchat_transcripts_options', array());
1720 - $interval = isset($options['mxchat_auto_delete_transcripts']) ? $options['mxchat_auto_delete_transcripts'] : 'never';
1721 - $custom_days = isset($options['mxchat_retention_days']) ? (int) $options['mxchat_retention_days'] : 0;
1722 -
1723 - // Custom retention-days (plan-9b80b1) takes precedence over the bucket dropdown.
1384 + $options = get_option('mxchat_transcripts_options', array());
1385 + $interval = isset($options['mxchat_auto_delete_transcripts']) ? $options['mxchat_auto_delete_transcripts'] : 'never';
1386 +
1387 + // If set to never, don't delete anything
1388 + if ($interval === 'never') {
1389 + return;
1390 + }
1391 +
1392 + // Calculate the cutoff date
1724 1393 $days = 0;
1725 - if ($custom_days > 0) {
1726 - $days = $custom_days;
1727 - } else {
1728 - switch ($interval) {
1729 - case '1week': $days = 7; break;
1730 - case '2weeks': $days = 14; break;
1731 - case '1month': $days = 30; break;
1732 - case 'never':
1733 - default:
1734 - $days = 0;
1735 - }
1394 + switch ($interval) {
1395 + case '1week':
1396 + $days = 7;
1397 + break;
1398 + case '2weeks':
1399 + $days = 14;
1400 + break;
1401 + case '1month':
1402 + $days = 30;
1403 + break;
1404 + default:
1405 + return; // Invalid interval, don't delete anything
1736 1406 }
1737 -
1738 - // Devs can override the final day count programmatically.
1739 - $days = (int) apply_filters('mxchat_transcript_retention_days', $days);
1740 -
1741 - if ($days <= 0) {
1742 - return; // Retention disabled — bail.
1743 - }
1744 -
1407 +
1745 1408 global $wpdb;
1746 - $transcripts_table = $wpdb->prefix . 'mxchat_chat_transcripts';
1409 + $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
1747 1410 $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
1748 - $url_clicks_table = $wpdb->prefix . 'mxchat_url_clicks';
1749 1411
1750 - // Defensive: if the main table doesn't exist (fresh-ish install), bail.
1751 - if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $transcripts_table)) !== $transcripts_table) {
1752 - return;
1753 - }
1412 + // Calculate the cutoff timestamp
1413 + $cutoff_date = date('Y-m-d H:i:s', strtotime("-{$days} days"));
1754 1414
1755 - $cutoff_date = gmdate('Y-m-d H:i:s', time() - ($days * DAY_IN_SECONDS));
1756 -
1757 - // Cap at 5000 session_ids per run so a large unattended site doesn't OOM —
1758 - // the cron will pick up where it left off on the next tick (within hours).
1759 - $batch_cap = (int) apply_filters('mxchat_transcript_retention_batch_cap', 5000);
1760 -
1415 + // First, get the session IDs that will be deleted (to clean up translations too)
1761 1416 $sessions_to_delete = $wpdb->get_col(
1762 1417 $wpdb->prepare(
1763 - "SELECT DISTINCT session_id FROM {$transcripts_table} WHERE timestamp IS NOT NULL AND timestamp < %s LIMIT %d",
1764 - $cutoff_date,
1765 - $batch_cap
1418 + "SELECT DISTINCT session_id FROM {$table_name} WHERE timestamp < %s",
1419 + $cutoff_date
1766 1420 )
1767 1421 );
1768 1422
1769 - if (empty($sessions_to_delete)) {
1770 - return;
1771 - }
1772 -
1773 - $placeholders = implode(',', array_fill(0, count($sessions_to_delete), '%s'));
1774 -
1775 - // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
1776 - // $placeholders is a server-built list of literal "%s" tokens.
1777 - $deleted_transcripts = (int) $wpdb->query(
1423 + // Delete transcripts older than the cutoff date
1424 + $deleted = $wpdb->query(
1778 1425 $wpdb->prepare(
1779 - "DELETE FROM {$transcripts_table} WHERE session_id IN ($placeholders)",
1780 - $sessions_to_delete
1426 + "DELETE FROM {$table_name} WHERE timestamp < %s",
1427 + $cutoff_date
1781 1428 )
1782 1429 );
1783 1430
1784 - if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $translations_table)) === $translations_table) {
1431 + // Also delete any translations for the deleted sessions
1432 + if (!empty($sessions_to_delete) && $wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table) {
1433 + $placeholders = implode(',', array_fill(0, count($sessions_to_delete), '%s'));
1785 1434 $wpdb->query(
1786 1435 $wpdb->prepare(
1787 1436 "DELETE FROM {$translations_table} WHERE session_id IN ($placeholders)",
1788 1437 $sessions_to_delete
@@ -1789,20 +1438,12 @@
1789 1438 )
1790 1439 );
1791 1440 }
1792 1441
1793 - if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $url_clicks_table)) === $url_clicks_table) {
1794 - $wpdb->query(
1795 - $wpdb->prepare(
1796 - "DELETE FROM {$url_clicks_table} WHERE session_id IN ($placeholders)",
1797 - $sessions_to_delete
1798 - )
1799 - );
1442 + // Log the cleanup action
1443 + if ($deleted !== false && $deleted > 0) {
1444 + //error_log(sprintf('MXChat: Auto-deleted %d transcripts older than %d days', $deleted, $days));
1800 1445 }
1801 - // phpcs:enable
1802 -
1803 - update_option('mxchat_retention_last_swept_at', time(), false);
1804 - update_option('mxchat_retention_rows_last_deleted', $deleted_transcripts, false);
1805 1446 }
1806 1447
1807 1448 public function export_chat_transcripts() {
1808 1449 if (!current_user_can('manage_options')) {
@@ -1863,763 +1504,9 @@
1863 1504 fclose($output);
1864 1505 wp_die();
1865 1506 }
1866 1507
1867 -// ============================================================================
1868 -// Leads tab (inside Transcripts)
1869 -//
1870 -// Leads are derived from existing data — no dedicated table. Primary source:
1871 -// wp_mxchat_chat_transcripts rows where user_email is populated. Secondary
1872 -// source: wp_options entries `mxchat_email_{session_id}` / `mxchat_name_{sid}`
1873 -// for "orphan" leads who submitted the pre-chat form but never chatted.
1874 -// ============================================================================
1875 -
1876 1508 /**
1877 - * Fetch leads: dedup-by-email rows, stats strip, and top pages in one call.
1878 - */
1879 -public function mxchat_fetch_leads() {
1880 - if (!current_user_can('manage_options')) {
1881 - wp_send_json_error(['message' => 'Insufficient permissions']);
1882 - wp_die();
1883 - }
1884 -
1885 - global $wpdb;
1886 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
1887 -
1888 - $page = isset($_POST['page']) ? max(1, absint($_POST['page'])) : 1;
1889 - $per_page = isset($_POST['per_page']) ? min(100, max(10, absint($_POST['per_page']))) : 25;
1890 - $offset = ($page - 1) * $per_page;
1891 - $search = isset($_POST['search']) ? sanitize_text_field(wp_unslash($_POST['search'])) : '';
1892 - $date_range = isset($_POST['date_range']) ? sanitize_key($_POST['date_range']) : 'all';
1893 - $status = isset($_POST['status']) ? sanitize_key($_POST['status']) : 'all';
1894 - $page_filter = isset($_POST['page_url']) ? esc_url_raw(wp_unslash($_POST['page_url'])) : '';
1895 - $sort = isset($_POST['sort']) ? sanitize_key($_POST['sort']) : 'last_seen';
1896 - $sort_dir = (isset($_POST['sort_dir']) && $_POST['sort_dir'] === 'asc') ? 'ASC' : 'DESC';
1897 -
1898 - $date_cutoff = self::mxchat_leads_date_cutoff($date_range);
1899 - $has_page_url_column = !empty($wpdb->get_results("SHOW COLUMNS FROM $table LIKE 'originating_page_url'"));
1900 -
1901 - // Base WHERE for transcripts leads.
1902 - $where_clauses = ["user_email IS NOT NULL", "user_email != ''"];
1903 - $where_params = [];
1904 -
1905 - if ($date_cutoff) {
1906 - $where_clauses[] = 'timestamp >= %s';
1907 - $where_params[] = $date_cutoff;
1908 - }
1909 - if ($page_filter && $has_page_url_column) {
1910 - $where_clauses[] = 'originating_page_url = %s';
1911 - $where_params[] = $page_filter;
1912 - }
1913 - if ($search !== '') {
1914 - $like = '%' . $wpdb->esc_like($search) . '%';
1915 - $where_clauses[] = '(user_email LIKE %s OR user_name LIKE %s)';
1916 - $where_params[] = $like;
1917 - $where_params[] = $like;
1918 - }
1919 - $where_sql = 'WHERE ' . implode(' AND ', $where_clauses);
1920 -
1921 - // Aggregate query grouped by email.
1922 - $select_sql = $has_page_url_column
1923 - ? "SELECT user_email, MAX(timestamp) AS last_seen, MIN(timestamp) AS first_seen,
1924 - COUNT(DISTINCT session_id) AS conversation_count"
1925 - : "SELECT user_email, MAX(timestamp) AS last_seen, MIN(timestamp) AS first_seen,
1926 - COUNT(DISTINCT session_id) AS conversation_count";
1927 -
1928 - $order_column = in_array($sort, ['last_seen', 'conversation_count', 'first_seen'], true) ? $sort : 'last_seen';
1929 - $group_order_limit = " GROUP BY user_email ORDER BY {$order_column} {$sort_dir} LIMIT %d OFFSET %d";
1930 -
1931 - $transcripts_sql = $wpdb->prepare(
1932 - "{$select_sql} FROM {$table} {$where_sql}{$group_order_limit}",
1933 - array_merge($where_params, [$per_page, $offset])
1934 - );
1935 - $transcript_rows = $wpdb->get_results($transcripts_sql);
1936 -
1937 - // Count of unique transcript-based leads under the same filters.
1938 - $count_sql = $wpdb->prepare(
1939 - "SELECT COUNT(DISTINCT user_email) FROM {$table} {$where_sql}",
1940 - $where_params
1941 - );
1942 - $transcripts_lead_count = (int) $wpdb->get_var($count_sql);
1943 -
1944 - // Hydrate each row: name, latest_session_id, top page.
1945 - $leads = [];
1946 - foreach ($transcript_rows as $row) {
1947 - $detail = $has_page_url_column
1948 - ? $wpdb->get_row($wpdb->prepare(
1949 - "SELECT session_id, user_name, originating_page_url, originating_page_title
1950 - FROM {$table} WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1951 - $row->user_email
1952 - ))
1953 - : $wpdb->get_row($wpdb->prepare(
1954 - "SELECT session_id, user_name FROM {$table}
1955 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1956 - $row->user_email
1957 - ));
1958 -
1959 - $leads[] = [
1960 - 'email' => $row->user_email,
1961 - 'name' => isset($detail->user_name) ? (string) $detail->user_name : '',
1962 - 'conversation_count' => (int) $row->conversation_count,
1963 - 'last_seen' => $row->last_seen,
1964 - 'last_seen_display' => self::mxchat_leads_format_relative($row->last_seen),
1965 - 'first_seen' => $row->first_seen,
1966 - 'latest_session_id' => isset($detail->session_id) ? $detail->session_id : '',
1967 - 'top_page_url' => isset($detail->originating_page_url) ? $detail->originating_page_url : '',
1968 - 'top_page_title' => isset($detail->originating_page_title) ? $detail->originating_page_title : '',
1969 - 'is_orphan' => false,
1970 - 'status' => 'active',
1971 - ];
1972 - }
1973 -
1974 - // Non-transcript lead sources. Built once here, then filtered/merged based on the
1975 - // status filter below. Deduplication priority when the same email appears in multiple
1976 - // sources: transcripts > chat_deleted > orphan.
1977 - $transcripts_emails_seen = array_flip(array_map(
1978 - function ($r) { return strtolower($r['email']); },
1979 - $leads
1980 - ));
1981 -
1982 - // Chat-deleted leads: had a conversation that an admin removed. Preserved via
1983 - // mxchat_lead_del_* options, with timestamps so they respect date filters.
1984 - $chat_deleted_leads_all = [];
1985 - if ($status === 'all' || $status === 'chat_deleted') {
1986 - $chat_deleted_leads_all = self::mxchat_collect_chat_deleted_leads($search, $date_cutoff);
1987 - // Dedup: drop any chat_deleted row whose email is already in the transcripts set.
1988 - $chat_deleted_leads_all = array_values(array_filter(
1989 - $chat_deleted_leads_all,
1990 - function ($row) use ($transcripts_emails_seen) {
1991 - return !isset($transcripts_emails_seen[strtolower($row['email'])]);
1992 - }
1993 - ));
1994 - foreach ($chat_deleted_leads_all as $row) {
1995 - $transcripts_emails_seen[strtolower($row['email'])] = true;
1996 - }
1997 - }
1998 -
1999 - // Orphans: pre-chat form captures with no conversation. No timestamp, so skipped
2000 - // when a date filter is active.
2001 - $orphan_leads_all = [];
2002 - if (($status === 'all' || $status === 'orphan') && !$date_cutoff && !$page_filter) {
2003 - $orphan_leads_all = self::mxchat_collect_orphan_leads($search);
2004 - $orphan_leads_all = array_values(array_filter(
2005 - $orphan_leads_all,
2006 - function ($row) use ($transcripts_emails_seen) {
2007 - return !isset($transcripts_emails_seen[strtolower($row['email'])]);
2008 - }
2009 - ));
2010 - }
2011 -
2012 - // Apply status filter to the transcripts-derived list.
2013 - if ($status === 'orphan' || $status === 'chat_deleted') {
2014 - $leads = [];
2015 - $transcripts_lead_count = 0;
2016 - }
2017 -
2018 - // Stitch the current page from the three buckets in priority order.
2019 - $total_count = $transcripts_lead_count + count($chat_deleted_leads_all) + count($orphan_leads_all);
2020 - $remaining_slots = $per_page - count($leads);
2021 -
2022 - if ($remaining_slots > 0 && !empty($chat_deleted_leads_all)) {
2023 - $start = max(0, ($page - 1) * $per_page - $transcripts_lead_count);
2024 - if ($start < count($chat_deleted_leads_all)) {
2025 - $leads = array_merge($leads, array_slice($chat_deleted_leads_all, $start, $remaining_slots));
2026 - $remaining_slots = $per_page - count($leads);
2027 - }
2028 - }
2029 -
2030 - if ($remaining_slots > 0 && !empty($orphan_leads_all)) {
2031 - $before = $transcripts_lead_count + count($chat_deleted_leads_all);
2032 - $start = max(0, ($page - 1) * $per_page - $before);
2033 - if ($start < count($orphan_leads_all)) {
2034 - $leads = array_merge($leads, array_slice($orphan_leads_all, $start, $remaining_slots));
2035 - }
2036 - }
2037 -
2038 - $total_pages = $per_page > 0 ? (int) ceil($total_count / $per_page) : 1;
2039 -
2040 - // Stats strip: always computed over full dataset, unaffected by filters.
2041 - $stats = self::mxchat_leads_stats($table, $has_page_url_column);
2042 -
2043 - // Top pages: top 5 by distinct emails captured.
2044 - $top_pages = [];
2045 - if ($has_page_url_column) {
2046 - $top_pages_rows = $wpdb->get_results(
2047 - "SELECT originating_page_url AS url,
2048 - MAX(originating_page_title) AS title,
2049 - COUNT(DISTINCT user_email) AS lead_count
2050 - FROM {$table}
2051 - WHERE user_email IS NOT NULL AND user_email != ''
2052 - AND originating_page_url IS NOT NULL AND originating_page_url != ''
2053 - GROUP BY originating_page_url
2054 - ORDER BY lead_count DESC, url ASC
2055 - LIMIT 5"
2056 - );
2057 - foreach ($top_pages_rows as $p) {
2058 - $top_pages[] = [
2059 - 'url' => $p->url,
2060 - 'title' => $p->title ?: $p->url,
2061 - 'lead_count' => (int) $p->lead_count,
2062 - ];
2063 - }
2064 - }
2065 -
2066 - wp_send_json([
2067 - 'success' => true,
2068 - 'leads' => $leads,
2069 - 'page' => $page,
2070 - 'per_page' => $per_page,
2071 - 'total_count' => $total_count,
2072 - 'total_pages' => $total_pages,
2073 - 'showing_start' => $total_count === 0 ? 0 : ($offset + 1),
2074 - 'showing_end' => min($offset + $per_page, $total_count),
2075 - 'stats' => $stats,
2076 - 'top_pages' => $top_pages,
2077 - ]);
2078 - wp_die();
2079 -}
2080 -
2081 -/**
2082 - * Delete one or more leads by email. Removes every transcripts row for that
2083 - * email and cleans up related wp_options (mxchat_email_{sid}, mxchat_name_{sid},
2084 - * mxchat_history_{sid}) and any orphan option entries matching the email.
2085 - */
2086 -public function mxchat_delete_leads() {
2087 - if (!current_user_can('manage_options')) {
2088 - wp_send_json_error(['message' => 'Insufficient permissions']);
2089 - wp_die();
2090 - }
2091 - check_ajax_referer('mxchat_delete_leads', 'security');
2092 -
2093 - $emails_raw = isset($_POST['emails']) ? (array) wp_unslash($_POST['emails']) : [];
2094 - $emails = [];
2095 - foreach ($emails_raw as $e) {
2096 - $clean = sanitize_email((string) $e);
2097 - if ($clean) {
2098 - $emails[] = $clean;
2099 - }
2100 - }
2101 - if (empty($emails)) {
2102 - wp_send_json_error(['message' => 'No emails provided']);
2103 - wp_die();
2104 - }
2105 -
2106 - $summary = self::mxchat_wipe_leads_by_email($emails);
2107 -
2108 - wp_send_json([
2109 - 'success' => true,
2110 - 'deleted_leads' => count($emails),
2111 - 'deleted_sessions' => $summary['deleted_sessions'],
2112 - 'deleted_rows' => $summary['deleted_rows'],
2113 - ]);
2114 - wp_die();
2115 -}
2116 -
2117 -/**
2118 - * Fully wipe one or more leads by email: every transcripts row, every related wp_options
2119 - * entry (history, pre-chat capture, chat_deleted preservation, agent name, translations).
2120 - *
2121 - * Shared between the Leads-tab Delete button and the transcript-delete opt-in checkbox.
2122 - * Input emails must already be sanitized with sanitize_email().
2123 - */
2124 -private static function mxchat_wipe_leads_by_email(array $emails) {
2125 - global $wpdb;
2126 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2127 - $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
2128 - $has_translations = $wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table;
2129 -
2130 - $deleted_sessions = 0;
2131 - $deleted_rows = 0;
2132 - $emails_lc = array_map('strtolower', $emails);
2133 -
2134 - foreach ($emails as $email) {
2135 - $session_ids = $wpdb->get_col($wpdb->prepare(
2136 - "SELECT DISTINCT session_id FROM {$table} WHERE user_email = %s",
2137 - $email
2138 - ));
2139 -
2140 - $rows_removed = $wpdb->delete($table, ['user_email' => $email], ['%s']);
2141 - if ($rows_removed !== false) {
2142 - $deleted_rows += (int) $rows_removed;
2143 - }
2144 -
2145 - foreach ($session_ids as $sid) {
2146 - $deleted_sessions++;
2147 - wp_cache_delete('chat_session_' . $sid, 'mxchat_chat_sessions');
2148 - delete_option('mxchat_history_' . $sid);
2149 - delete_option('mxchat_email_' . $sid);
2150 - delete_option('mxchat_name_' . $sid);
2151 - delete_option('mxchat_agent_name_' . $sid);
2152 - delete_option('mxchat_lead_del_email_' . $sid);
2153 - delete_option('mxchat_lead_del_name_' . $sid);
2154 - delete_option('mxchat_lead_del_ts_' . $sid);
2155 - if ($has_translations) {
2156 - $wpdb->delete($translations_table, ['session_id' => $sid], ['%s']);
2157 - }
2158 - }
2159 - }
2160 -
2161 - // Clean up any lingering option entries (orphan pre-chat captures + chat_deleted
2162 - // preservations) whose stored value matches one of the emails being wiped.
2163 - $lingering = $wpdb->get_results(
2164 - "SELECT option_name, option_value FROM {$wpdb->options}
2165 - WHERE option_name LIKE 'mxchat_email_%' OR option_name LIKE 'mxchat_lead_del_email_%'"
2166 - );
2167 - foreach ($lingering as $opt) {
2168 - if (!in_array(strtolower(trim($opt->option_value)), $emails_lc, true)) {
2169 - continue;
2170 - }
2171 - if (strpos($opt->option_name, 'mxchat_lead_del_email_') === 0) {
2172 - $sid = substr($opt->option_name, strlen('mxchat_lead_del_email_'));
2173 - delete_option('mxchat_lead_del_email_' . $sid);
2174 - delete_option('mxchat_lead_del_name_' . $sid);
2175 - delete_option('mxchat_lead_del_ts_' . $sid);
2176 - } else {
2177 - $sid = substr($opt->option_name, strlen('mxchat_email_'));
2178 - delete_option('mxchat_email_' . $sid);
2179 - delete_option('mxchat_name_' . $sid);
2180 - }
2181 - }
2182 -
2183 - wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
2184 -
2185 - return [
2186 - 'deleted_sessions' => $deleted_sessions,
2187 - 'deleted_rows' => $deleted_rows,
2188 - ];
2189 -}
2190 -
2191 -/**
2192 - * Stream a leads CSV. scope=all exports every lead under current filters is not
2193 - * supported to keep semantics simple; caller either exports all leads or a
2194 - * specific set of selected emails.
2195 - */
2196 -public function mxchat_export_leads() {
2197 - if (!current_user_can('manage_options')) {
2198 - wp_die(esc_html__('You do not have sufficient permissions to access this page.', 'mxchat'));
2199 - }
2200 - check_ajax_referer('mxchat_export_leads', 'security');
2201 -
2202 - $scope = isset($_POST['scope']) ? sanitize_key($_POST['scope']) : 'all';
2203 - $fields_mode = isset($_POST['fields']) ? sanitize_key($_POST['fields']) : 'email_and_name';
2204 - $emails_in = isset($_POST['emails']) ? (array) wp_unslash($_POST['emails']) : [];
2205 -
2206 - $emails_in_clean = [];
2207 - foreach ($emails_in as $e) {
2208 - $clean = sanitize_email((string) $e);
2209 - if ($clean) {
2210 - $emails_in_clean[] = $clean;
2211 - }
2212 - }
2213 -
2214 - global $wpdb;
2215 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2216 - $has_page_url_column = !empty($wpdb->get_results("SHOW COLUMNS FROM $table LIKE 'originating_page_url'"));
2217 -
2218 - // Collect leads from transcripts.
2219 - $transcripts_sql = "SELECT user_email AS email,
2220 - MAX(timestamp) AS last_seen,
2221 - COUNT(DISTINCT session_id) AS conversation_count
2222 - FROM {$table}
2223 - WHERE user_email IS NOT NULL AND user_email != ''";
2224 - $params = [];
2225 - if ($scope === 'selected' && !empty($emails_in_clean)) {
2226 - $placeholders = implode(',', array_fill(0, count($emails_in_clean), '%s'));
2227 - $transcripts_sql .= " AND user_email IN ({$placeholders})";
2228 - $params = $emails_in_clean;
2229 - }
2230 - $transcripts_sql .= " GROUP BY user_email ORDER BY last_seen DESC";
2231 -
2232 - $rows = !empty($params)
2233 - ? $wpdb->get_results($wpdb->prepare($transcripts_sql, $params))
2234 - : $wpdb->get_results($transcripts_sql);
2235 -
2236 - // Hydrate each row with name + top page.
2237 - $export_rows = [];
2238 - foreach ($rows as $row) {
2239 - $detail = $has_page_url_column
2240 - ? $wpdb->get_row($wpdb->prepare(
2241 - "SELECT user_name, originating_page_url FROM {$table}
2242 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
2243 - $row->email
2244 - ))
2245 - : $wpdb->get_row($wpdb->prepare(
2246 - "SELECT user_name FROM {$table}
2247 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
2248 - $row->email
2249 - ));
2250 - $export_rows[] = [
2251 - 'email' => $row->email,
2252 - 'name' => isset($detail->user_name) ? (string) $detail->user_name : '',
2253 - 'conversation_count' => (int) $row->conversation_count,
2254 - 'last_seen' => $row->last_seen,
2255 - 'top_page_url' => isset($detail->originating_page_url) ? $detail->originating_page_url : '',
2256 - ];
2257 - }
2258 -
2259 - // Include orphan + chat_deleted leads when exporting all.
2260 - if ($scope === 'all') {
2261 - $transcripts_emails_lc = array_flip(array_map(
2262 - function ($r) { return strtolower($r['email']); },
2263 - $export_rows
2264 - ));
2265 - foreach (self::mxchat_collect_chat_deleted_leads('') as $cd) {
2266 - if (isset($transcripts_emails_lc[strtolower($cd['email'])])) continue;
2267 - $transcripts_emails_lc[strtolower($cd['email'])] = true;
2268 - $export_rows[] = [
2269 - 'email' => $cd['email'],
2270 - 'name' => $cd['name'],
2271 - 'conversation_count' => 0,
2272 - 'last_seen' => $cd['last_seen'],
2273 - 'top_page_url' => '',
2274 - ];
2275 - }
2276 - foreach (self::mxchat_collect_orphan_leads('') as $orphan) {
2277 - if (isset($transcripts_emails_lc[strtolower($orphan['email'])])) continue;
2278 - $transcripts_emails_lc[strtolower($orphan['email'])] = true;
2279 - $export_rows[] = [
2280 - 'email' => $orphan['email'],
2281 - 'name' => $orphan['name'],
2282 - 'conversation_count' => 0,
2283 - 'last_seen' => '',
2284 - 'top_page_url' => '',
2285 - ];
2286 - }
2287 - }
2288 -
2289 - if (empty($export_rows)) {
2290 - wp_send_json_error(['message' => 'No leads to export.']);
2291 - wp_die();
2292 - }
2293 -
2294 - $filename = 'mxchat-leads-' . date('Y-m-d') . '.csv';
2295 - header('Content-Type: text/csv');
2296 - header('Content-Disposition: attachment; filename="' . $filename . '"');
2297 - header('Pragma: no-cache');
2298 - header('Expires: 0');
2299 -
2300 - $output = fopen('php://output', 'w');
2301 - fputs($output, "\xEF\xBB\xBF"); // UTF-8 BOM for Excel
2302 -
2303 - if ($fields_mode === 'email_only') {
2304 - fputcsv($output, ['Email']);
2305 - foreach ($export_rows as $r) {
2306 - fputcsv($output, [$r['email']]);
2307 - }
2308 - } else {
2309 - fputcsv($output, ['Email', 'Name', 'Conversations', 'Last seen', 'Top page']);
2310 - foreach ($export_rows as $r) {
2311 - fputcsv($output, [
2312 - $r['email'],
2313 - $r['name'],
2314 - $r['conversation_count'],
2315 - $r['last_seen'],
2316 - $r['top_page_url'],
2317 - ]);
2318 - }
2319 - }
2320 -
2321 - fclose($output);
2322 - wp_die();
2323 -}
2324 -
2325 -/**
2326 - * Stats strip payload (independent of filters).
2327 - */
2328 -private static function mxchat_leads_stats($table, $has_page_url_column) {
2329 - global $wpdb;
2330 -
2331 - $total_transcripts_emails = (int) $wpdb->get_var(
2332 - "SELECT COUNT(DISTINCT user_email) FROM {$table}
2333 - WHERE user_email IS NOT NULL AND user_email != ''"
2334 - );
2335 -
2336 - $new_this_week = (int) $wpdb->get_var($wpdb->prepare(
2337 - "SELECT COUNT(*) FROM (
2338 - SELECT user_email FROM {$table}
2339 - WHERE user_email IS NOT NULL AND user_email != ''
2340 - GROUP BY user_email
2341 - HAVING MIN(timestamp) >= %s
2342 - ) AS new_leads",
2343 - gmdate('Y-m-d H:i:s', strtotime('-7 days'))
2344 - ));
2345 -
2346 - $total_convos = (int) $wpdb->get_var(
2347 - "SELECT COUNT(DISTINCT session_id) FROM {$table}
2348 - WHERE user_email IS NOT NULL AND user_email != ''"
2349 - );
2350 -
2351 - $orphan_count = count(self::mxchat_collect_orphan_leads(''));
2352 - $chat_deleted_count = self::mxchat_count_chat_deleted_leads();
2353 -
2354 - // Total leads = unique emails across all three sources (dedup priority: transcripts > chat_deleted > orphan
2355 - // is already enforced at collection time in mxchat_fetch_leads; stats re-apply it here).
2356 - $total_leads = $total_transcripts_emails + $chat_deleted_count + $orphan_count;
2357 -
2358 - $avg = $total_transcripts_emails > 0
2359 - ? round($total_convos / $total_transcripts_emails, 1)
2360 - : 0;
2361 -
2362 - // Orphan % reflects *true* orphans only (pre-chat dropoffs). Chat-deleted leads are
2363 - // excluded so the metric stays meaningful — admins shouldn't see their cleanups
2364 - // inflate this number.
2365 - $orphan_pct = $total_leads > 0
2366 - ? (int) round(($orphan_count / $total_leads) * 100)
2367 - : 0;
2368 -
2369 - return [
2370 - 'total_leads' => $total_leads,
2371 - 'new_this_week' => $new_this_week,
2372 - 'avg_convos' => $avg,
2373 - 'orphan_pct' => $orphan_pct,
2374 - 'orphan_count' => $orphan_count,
2375 - 'chat_deleted_count' => $chat_deleted_count,
2376 - ];
2377 -}
2378 -
2379 -/**
2380 - * Collect leads who had a conversation that an admin later deleted (preserved via
2381 - * mxchat_lead_del_* options). Returns rows tagged status='chat_deleted' with the
2382 - * original last-seen timestamp so they still sort and filter sensibly.
2383 - *
2384 - * @param string $search Optional email/name substring filter.
2385 - * @param string $date_cutoff Optional 'Y-m-d H:i:s' cutoff — only rows with last_ts >= cutoff.
2386 - * @return array
2387 - */
2388 -private static function mxchat_collect_chat_deleted_leads($search = '', $date_cutoff = '') {
2389 - global $wpdb;
2390 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2391 -
2392 - $rows = $wpdb->get_results(
2393 - "SELECT option_name, option_value FROM {$wpdb->options}
2394 - WHERE option_name LIKE 'mxchat_lead_del_email_%'"
2395 - );
2396 - if (empty($rows)) {
2397 - return [];
2398 - }
2399 -
2400 - // Emails that currently have transcripts rows should not appear as chat_deleted —
2401 - // they've come back and chatted, so they're active leads again.
2402 - $emails_in_transcripts = array_map(
2403 - 'strtolower',
2404 - (array) $wpdb->get_col(
2405 - "SELECT DISTINCT user_email FROM {$table}
2406 - WHERE user_email IS NOT NULL AND user_email != ''"
2407 - )
2408 - );
2409 - $emails_in_transcripts = array_flip($emails_in_transcripts);
2410 -
2411 - $needle = strtolower(trim((string) $search));
2412 - $by_email = [];
2413 -
2414 - foreach ($rows as $opt) {
2415 - $email = sanitize_email(trim((string) $opt->option_value));
2416 - if (!$email) {
2417 - continue;
2418 - }
2419 - if (isset($emails_in_transcripts[strtolower($email)])) {
2420 - continue;
2421 - }
2422 - $sid = substr($opt->option_name, strlen('mxchat_lead_del_email_'));
2423 - if (!$sid) {
2424 - continue;
2425 - }
2426 - $name = (string) get_option('mxchat_lead_del_name_' . $sid, '');
2427 - $ts = (string) get_option('mxchat_lead_del_ts_' . $sid, '');
2428 -
2429 - if ($date_cutoff !== '' && ($ts === '' || $ts < $date_cutoff)) {
2430 - continue;
2431 - }
2432 - if ($needle !== '') {
2433 - $hay = strtolower($email . ' ' . $name);
2434 - if (strpos($hay, $needle) === false) {
2435 - continue;
2436 - }
2437 - }
2438 -
2439 - $key = strtolower($email);
2440 - if (!isset($by_email[$key]) || (isset($by_email[$key]['last_seen']) && $ts > $by_email[$key]['last_seen'])) {
2441 - $by_email[$key] = [
2442 - 'email' => $email,
2443 - 'name' => $name,
2444 - 'conversation_count' => 0,
2445 - 'last_seen' => $ts,
2446 - 'last_seen_display' => $ts ? self::mxchat_leads_format_relative($ts) : __('Chat deleted', 'mxchat'),
2447 - 'first_seen' => $ts,
2448 - 'latest_session_id' => '',
2449 - 'top_page_url' => '',
2450 - 'top_page_title' => '',
2451 - 'is_orphan' => false,
2452 - 'status' => 'chat_deleted',
2453 - ];
2454 - }
2455 - }
2456 -
2457 - // Newest chat_deleted first.
2458 - usort($by_email, function ($a, $b) {
2459 - return strcmp((string) $b['last_seen'], (string) $a['last_seen']);
2460 - });
2461 - return array_values($by_email);
2462 -}
2463 -
2464 -/**
2465 - * Count unique emails preserved as "chat deleted" (for the stats strip).
2466 - */
2467 -private static function mxchat_count_chat_deleted_leads() {
2468 - global $wpdb;
2469 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2470 -
2471 - $emails = $wpdb->get_col(
2472 - "SELECT DISTINCT option_value FROM {$wpdb->options}
2473 - WHERE option_name LIKE 'mxchat_lead_del_email_%'"
2474 - );
2475 - if (empty($emails)) {
2476 - return 0;
2477 - }
2478 -
2479 - $transcripts_emails = array_map(
2480 - 'strtolower',
2481 - (array) $wpdb->get_col(
2482 - "SELECT DISTINCT user_email FROM {$table}
2483 - WHERE user_email IS NOT NULL AND user_email != ''"
2484 - )
2485 - );
2486 - $transcripts_emails = array_flip($transcripts_emails);
2487 -
2488 - $count = 0;
2489 - $seen = [];
2490 - foreach ($emails as $raw) {
2491 - $email = strtolower(trim((string) $raw));
2492 - if (!$email || isset($seen[$email]) || isset($transcripts_emails[$email])) {
2493 - continue;
2494 - }
2495 - $seen[$email] = true;
2496 - $count++;
2497 - }
2498 - return $count;
2499 -}
2500 -
2501 -/**
2502 - * Find leads who submitted the pre-chat form but never produced a transcripts row.
2503 - * Returned rows have no conversation_count, no timestamp.
2504 - *
2505 - * @param string $search Optional email/name substring filter.
2506 - * @return array
2507 - */
2508 -private static function mxchat_collect_orphan_leads($search = '') {
2509 - global $wpdb;
2510 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2511 -
2512 - $option_rows = $wpdb->get_results(
2513 - "SELECT option_name, option_value FROM {$wpdb->options}
2514 - WHERE option_name LIKE 'mxchat_email_%'"
2515 - );
2516 - if (empty($option_rows)) {
2517 - return [];
2518 - }
2519 -
2520 - // Collect all session_ids that have real transcripts rows so we can exclude them.
2521 - $session_ids_with_rows = $wpdb->get_col(
2522 - "SELECT DISTINCT session_id FROM {$table}
2523 - WHERE user_email IS NOT NULL AND user_email != ''"
2524 - );
2525 - $session_ids_with_rows = array_flip($session_ids_with_rows);
2526 -
2527 - // Seen emails in transcripts (so orphans only include truly never-chatted leads).
2528 - $emails_in_transcripts = array_map(
2529 - 'strtolower',
2530 - (array) $wpdb->get_col(
2531 - "SELECT DISTINCT user_email FROM {$table}
2532 - WHERE user_email IS NOT NULL AND user_email != ''"
2533 - )
2534 - );
2535 - $emails_in_transcripts = array_flip($emails_in_transcripts);
2536 -
2537 - $orphans_by_email = [];
2538 - $needle = strtolower(trim((string) $search));
2539 -
2540 - foreach ($option_rows as $opt) {
2541 - $email = sanitize_email(trim((string) $opt->option_value));
2542 - if (!$email) {
2543 - continue;
2544 - }
2545 - $sid = substr($opt->option_name, strlen('mxchat_email_'));
2546 - if (!$sid) {
2547 - continue;
2548 - }
2549 - // Exclude leads who have any transcripts rows (they appear in the main list).
2550 - if (isset($emails_in_transcripts[strtolower($email)])) {
2551 - continue;
2552 - }
2553 - if (isset($session_ids_with_rows[$sid])) {
2554 - continue;
2555 - }
2556 -
2557 - $name_option = get_option('mxchat_name_' . $sid, '');
2558 - $name = is_string($name_option) ? trim($name_option) : '';
2559 -
2560 - if ($needle !== '') {
2561 - $hay = strtolower($email . ' ' . $name);
2562 - if (strpos($hay, $needle) === false) {
2563 - continue;
2564 - }
2565 - }
2566 -
2567 - $key = strtolower($email);
2568 - if (!isset($orphans_by_email[$key])) {
2569 - $orphans_by_email[$key] = [
2570 - 'email' => $email,
2571 - 'name' => $name,
2572 - 'conversation_count' => 0,
2573 - 'last_seen' => '',
2574 - 'last_seen_display' => __('No conversation yet', 'mxchat'),
2575 - 'first_seen' => '',
2576 - 'latest_session_id' => '',
2577 - 'top_page_url' => '',
2578 - 'top_page_title' => '',
2579 - 'is_orphan' => true,
2580 - 'status' => 'orphan',
2581 - ];
2582 - }
2583 - }
2584 -
2585 - return array_values($orphans_by_email);
2586 -}
2587 -
2588 -/**
2589 - * Map a date_range key to a SQL-comparable cutoff string, or '' for all-time.
2590 - */
2591 -private static function mxchat_leads_date_cutoff($date_range) {
2592 - switch ($date_range) {
2593 - case 'today': return gmdate('Y-m-d H:i:s', strtotime('-24 hours'));
2594 - case '7d': return gmdate('Y-m-d H:i:s', strtotime('-7 days'));
2595 - case '30d': return gmdate('Y-m-d H:i:s', strtotime('-30 days'));
2596 - case '90d': return gmdate('Y-m-d H:i:s', strtotime('-90 days'));
2597 - case 'all':
2598 - default: return '';
2599 - }
2600 -}
2601 -
2602 -/**
2603 - * Turn a UTC timestamp into a short relative display like "2h ago" or "Apr 12".
2604 - */
2605 -private static function mxchat_leads_format_relative($timestamp) {
2606 - if (!$timestamp) {
2607 - return '';
2608 - }
2609 - $ts = strtotime($timestamp . ' UTC');
2610 - if (!$ts) {
2611 - return '';
2612 - }
2613 - $diff = time() - $ts;
2614 - if ($diff < 60) return __('just now', 'mxchat');
2615 - if ($diff < 3600) return floor($diff / 60) . __('m ago', 'mxchat');
2616 - if ($diff < 86400) return floor($diff / 3600) . __('h ago', 'mxchat');
2617 - if ($diff < 604800) return floor($diff / 86400) . __('d ago', 'mxchat');
2618 - return wp_date('M j', $ts);
2619 -}
2620 -
2621 -/**
2622 1509 * Handle translation of chat messages via AJAX
2623 1510 */
2624 1511 public function mxchat_translate_messages() {
2625 1512 if (!current_user_can('manage_options')) {
@@ -2902,12 +1789,8 @@
2902 1789 /**
2903 1790 * Translate text using Claude API
2904 1791 */
2905 1792 private function translate_with_claude($api_key, $model, $system_prompt, $text) {
2906 - // Anthropic retired claude-opus-4-20250514 / claude-sonnet-4-20250514 on 2026-06-15.
2907 - // Read-time rescue: remap a saved dead ID to the current equivalent before the API call.
2908 - if ($model === 'claude-opus-4-20250514') { $model = 'claude-opus-4-8'; }
2909 - elseif ($model === 'claude-sonnet-4-20250514') { $model = 'claude-sonnet-4-6'; }
2910 1793 $response = wp_remote_post('https://api.anthropic.com/v1/messages', [
2911 1794 'timeout' => 60,
2912 1795 'headers' => [
2913 1796 'x-api-key' => $api_key,
@@ -3018,11 +1901,8 @@
3018 1901 /**
3019 1902 * Translate text using Google Gemini API
3020 1903 */
3021 1904 private function translate_with_gemini($api_key, $model, $system_prompt, $text) {
3022 - if ($model === 'gemini-3-pro-preview') {
3023 - $model = 'gemini-3.1-pro-preview';
3024 - }
3025 1905 $url = 'https://generativelanguage.googleapis.com/v1beta/models/' . $model . ':generateContent?key=' . $api_key;
3026 1906
3027 1907 $response = wp_remote_post($url, [
3028 1908 'timeout' => 60,
@@ -3112,20 +1992,9 @@
3112 1992 $page = isset($_POST['page']) ? absint($_POST['page']) : 1;
3113 1993 $per_page = isset($_POST['per_page']) ? absint($_POST['per_page']) : 50;
3114 1994 $offset = ($page - 1) * $per_page;
3115 1995 $search = isset($_POST['search']) ? sanitize_text_field($_POST['search']) : '';
3116 - $sort_raw = isset($_POST['sort_order']) ? sanitize_key($_POST['sort_order']) : 'desc';
3117 - $allowed_sorts = array('asc', 'desc', 'rating_positive', 'rating_negative');
3118 - if (!in_array($sort_raw, $allowed_sorts, true)) { $sort_raw = 'desc'; }
3119 - $sort_order = ($sort_raw === 'asc') ? 'ASC' : 'DESC';
3120 - $ratings_table = $wpdb->prefix . 'mxchat_session_ratings';
3121 - $ratings_join = '';
3122 - $rating_table_exists = ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $ratings_table)) === $ratings_table);
3123 - if ($rating_table_exists && ($sort_raw === 'rating_positive' || $sort_raw === 'rating_negative')) {
3124 - // We sort by rating then recency. Wrap rating_value so NULL sorts last.
3125 - $rating_dir = ($sort_raw === 'rating_positive') ? 'DESC' : 'ASC';
3126 - $ratings_join = " LEFT JOIN {$ratings_table} r ON r.session_id = t.session_id ";
3127 - }
1996 + $sort_order = isset($_POST['sort_order']) && $_POST['sort_order'] === 'asc' ? 'ASC' : 'DESC';
3128 1997
3129 1998 // Build search condition
3130 1999 $search_condition = '';
3131 2000 $search_params = [];
@@ -3145,24 +2014,18 @@
3145 2014 ? $wpdb->prepare("SELECT COUNT(DISTINCT session_id) FROM {$table_name} {$search_condition}", $search_params)
3146 2015 : "SELECT COUNT(DISTINCT session_id) FROM {$table_name}";
3147 2016 $total_sessions = (int) $wpdb->get_var($count_query);
3148 2017
3149 - // Get session IDs for current page. Default sort is recency; rating sorts join the ratings table
3150 - // and order by rating value (NULLs last) with recency as tiebreaker.
3151 - if ($ratings_join) {
3152 - $order_by = "ORDER BY (r.rating_value IS NULL), r.rating_value {$rating_dir}, MAX(t.timestamp) DESC";
3153 - } else {
3154 - $order_by = "ORDER BY MAX(t.timestamp) {$sort_order}";
3155 - }
2018 + // Get session IDs for current page (sorted by newest or oldest)
3156 2019 $session_query = !empty($search)
3157 2020 ? $wpdb->prepare(
3158 - "SELECT DISTINCT t.session_id FROM {$table_name} t {$ratings_join} {$search_condition}
3159 - GROUP BY t.session_id {$order_by} LIMIT %d OFFSET %d",
2021 + "SELECT DISTINCT t.session_id FROM {$table_name} t {$search_condition}
2022 + GROUP BY t.session_id ORDER BY MAX(t.timestamp) {$sort_order} LIMIT %d OFFSET %d",
3160 2023 array_merge($search_params, [$per_page, $offset])
3161 2024 )
3162 2025 : $wpdb->prepare(
3163 - "SELECT DISTINCT t.session_id FROM {$table_name} t {$ratings_join}
3164 - GROUP BY t.session_id {$order_by} LIMIT %d OFFSET %d",
2026 + "SELECT DISTINCT session_id FROM {$table_name}
2027 + GROUP BY session_id ORDER BY MAX(timestamp) {$sort_order} LIMIT %d OFFSET %d",
3165 2028 $per_page, $offset
3166 2029 );
3167 2030 $session_ids = $wpdb->get_col($session_query);
3168 2031
@@ -3184,24 +2047,8 @@
3184 2047 // Check for optional columns/tables
3185 2048 $url_table_exists = $wpdb->get_var("SHOW TABLES LIKE '$url_clicks_table'") === $url_clicks_table;
3186 2049 $originating_columns_exist = !empty($wpdb->get_results("SHOW COLUMNS FROM $table_name LIKE 'originating_page_url'"));
3187 2050
3188 - // Batch-fetch session ratings for this page (plan-a5b006).
3189 - $ratings_map = array();
3190 - if ($rating_table_exists && !empty($session_ids)) {
3191 - $placeholders = implode(',', array_fill(0, count($session_ids), '%s'));
3192 - $rating_rows = $wpdb->get_results($wpdb->prepare(
3193 - "SELECT session_id, rating_value, rating_feedback FROM {$ratings_table} WHERE session_id IN ($placeholders)",
3194 - $session_ids
3195 - ));
3196 - foreach ($rating_rows as $row) {
3197 - $ratings_map[$row->session_id] = array(
3198 - 'value' => (int) $row->rating_value,
3199 - 'feedback' => (string) $row->rating_feedback,
3200 - );
3201 - }
3202 - }
3203 -
3204 2051 // Build session list data
3205 2052 $sessions = [];
3206 2053 foreach ($session_ids as $session_id) {
3207 2054 // Get session metadata
@@ -3258,12 +2105,8 @@
3258 2105 $parts = explode(' ', $display_name);
3259 2106 $initials = strtoupper(substr($parts[0], 0, 1) . substr(end($parts), 0, 1));
3260 2107 }
3261 2108
3262 - $rating_entry = isset($ratings_map[$session_id]) ? $ratings_map[$session_id] : null;
3263 - $rating_value = $rating_entry ? $rating_entry['value'] : null;
3264 - $rating_feedback = $rating_entry ? $rating_entry['feedback'] : '';
3265 -
3266 2109 $sessions[] = [
3267 2110 'session_id' => $session_id,
3268 2111 'display_name' => $display_name,
3269 2112 'display_sub' => $display_sub,
@@ -3270,11 +2113,9 @@
3270 2113 'initials' => $initials,
3271 2114 'preview' => $preview,
3272 2115 'message_count' => (int) $message_stats->count,
3273 2116 'time_display' => $time_display,
3274 - 'timestamp' => $message_stats->latest,
3275 - 'rating_value' => $rating_value,
3276 - 'rating_feedback' => $rating_feedback,
2117 + 'timestamp' => $message_stats->latest
3277 2118 ];
3278 2119 }
3279 2120
3280 2121 wp_send_json([
@@ -3412,18 +2253,8 @@
3412 2253
3413 2254 // First message timestamp for "started" display
3414 2255 $started = !empty($messages) ? wp_date('M j, Y g:i A', strtotime($messages[0]->timestamp . ' UTC')) : '-';
3415 2256
3416 - // Pull rating_feedback for this session (if any) so the details drawer can show it.
3417 - $rating_feedback = '';
3418 - $ratings_table_det = $wpdb->prefix . 'mxchat_session_ratings';
3419 - if ($wpdb->get_var("SHOW TABLES LIKE '$ratings_table_det'") === $ratings_table_det) {
3420 - $rating_feedback = (string) $wpdb->get_var($wpdb->prepare(
3421 - "SELECT rating_feedback FROM {$ratings_table_det} WHERE session_id = %s LIMIT 1",
3422 - $session_id
3423 - ));
3424 - }
3425 -
3426 2257 wp_send_json([
3427 2258 'success' => true,
3428 2259 'session_id' => $session_id,
3429 2260 'user' => [
@@ -3439,10 +2270,9 @@
3439 2270 ],
3440 2271 'clicked_urls' => $clicked_urls,
3441 2272 'messages' => $formatted_messages,
3442 2273 'message_count' => count($messages),
3443 - 'started' => $started,
3444 - 'rating_feedback' => $rating_feedback
2274 + 'started' => $started
3445 2275 ]);
3446 2276 wp_die();
3447 2277 }
3448 2278
@@ -3895,103 +2725,53 @@
3895 2725 echo wp_json_encode(['error' => esc_html__('You do not have sufficient permissions.', 'mxchat')]);
3896 2726 wp_die();
3897 2727 }
3898 2728 check_ajax_referer('mxchat_delete_chat_history', 'security');
3899 -
3900 - if (!isset($_POST['delete_session_ids']) || !is_array($_POST['delete_session_ids'])) {
3901 - echo wp_json_encode(['error' => esc_html__('No chat sessions selected for deletion.', 'mxchat')]);
3902 - wp_die();
3903 - }
3904 -
3905 2729 global $wpdb;
3906 2730 $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
3907 - $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
3908 - $has_translations = $wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table;
3909 2731
3910 - // When true, any lead attached to these sessions is fully wiped (all their sessions,
3911 - // across the whole table). Default false: the chat rows go away but the lead is
3912 - // preserved as a separate "chat deleted" lead in the Leads tab.
3913 - $also_delete_lead = !empty($_POST['also_delete_lead']) && $_POST['also_delete_lead'] !== 'false';
2732 + if (isset($_POST['delete_session_ids']) && is_array($_POST['delete_session_ids'])) {
2733 + $deleted_count = 0;
2734 + $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
3914 2735
3915 - $deleted_count = 0;
3916 - $preserved_as_deleted_leads = 0;
3917 - $emails_to_fully_wipe = [];
2736 + foreach ($_POST['delete_session_ids'] as $session_id) {
2737 + $session_id_sanitized = sanitize_text_field($session_id);
3918 2738
3919 - foreach ((array) $_POST['delete_session_ids'] as $session_id) {
3920 - $session_id_sanitized = sanitize_text_field($session_id);
3921 - if ($session_id_sanitized === '') {
3922 - continue;
3923 - }
2739 + // Clear relevant cache before deletion
2740 + $cache_key = 'chat_session_' . $session_id_sanitized;
2741 + wp_cache_delete($cache_key, 'mxchat_chat_sessions');
3924 2742
3925 - // Capture the lead info attached to this session *before* we delete the rows.
3926 - $lead_row = $wpdb->get_row($wpdb->prepare(
3927 - "SELECT user_email, user_name, MAX(timestamp) AS last_ts
3928 - FROM {$table_name}
3929 - WHERE session_id = %s AND user_email IS NOT NULL AND user_email != ''
3930 - GROUP BY user_email, user_name
3931 - ORDER BY last_ts DESC LIMIT 1",
3932 - $session_id_sanitized
3933 - ));
2743 + // Perform the deletion from the database table
2744 + $wpdb->delete($table_name, ['session_id' => $session_id_sanitized]);
3934 2745
3935 - wp_cache_delete('chat_session_' . $session_id_sanitized, 'mxchat_chat_sessions');
3936 - $wpdb->delete($table_name, ['session_id' => $session_id_sanitized]);
2746 + // Delete any saved translations for this session
2747 + if ($wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table) {
2748 + $wpdb->delete($translations_table, ['session_id' => $session_id_sanitized]);
2749 + }
3937 2750
3938 - if ($has_translations) {
3939 - $wpdb->delete($translations_table, ['session_id' => $session_id_sanitized]);
3940 - }
2751 + // Delete the corresponding option entry from wp_options table
2752 + delete_option("mxchat_history_" . $session_id_sanitized);
3941 2753
3942 - delete_option('mxchat_history_' . $session_id_sanitized);
3943 - delete_option('mxchat_agent_name_' . $session_id_sanitized);
2754 + // Delete any associated metadata options
2755 + delete_option("mxchat_email_" . $session_id_sanitized);
2756 + delete_option("mxchat_agent_name_" . $session_id_sanitized);
3944 2757
3945 - if ($lead_row && !empty($lead_row->user_email)) {
3946 - if ($also_delete_lead) {
3947 - // Full-wipe requested — queue the email so that all their sessions and
3948 - // related options get swept below. Also clear this session's pre-chat
3949 - // capture options (they're no longer meaningful).
3950 - $emails_to_fully_wipe[strtolower($lead_row->user_email)] = $lead_row->user_email;
3951 - delete_option('mxchat_email_' . $session_id_sanitized);
3952 - delete_option('mxchat_name_' . $session_id_sanitized);
3953 - } else {
3954 - // Preserve the lead in a "Chat deleted" state via distinct option keys so
3955 - // they stay out of the orphan bucket (orphan = pre-chat form dropoff).
3956 - update_option('mxchat_lead_del_email_' . $session_id_sanitized, $lead_row->user_email, false);
3957 - if (!empty($lead_row->user_name)) {
3958 - update_option('mxchat_lead_del_name_' . $session_id_sanitized, $lead_row->user_name, false);
3959 - }
3960 - if (!empty($lead_row->last_ts)) {
3961 - update_option('mxchat_lead_del_ts_' . $session_id_sanitized, $lead_row->last_ts, false);
3962 - }
3963 - // Clean up pre-chat capture options for this session — chat_deleted supersedes.
3964 - delete_option('mxchat_email_' . $session_id_sanitized);
3965 - delete_option('mxchat_name_' . $session_id_sanitized);
3966 - $preserved_as_deleted_leads++;
3967 - }
3968 - } else {
3969 - // No lead attached — nothing to preserve. Clean up any orphan options anyway.
3970 - delete_option('mxchat_email_' . $session_id_sanitized);
3971 - delete_option('mxchat_name_' . $session_id_sanitized);
2758 + $deleted_count++;
3972 2759 }
3973 2760
3974 - $deleted_count++;
3975 - }
2761 + // Optionally, clear a general cache if you have one
2762 + wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
3976 2763
3977 - // Opt-in full-lead wipe: sweep every remaining row + every option key (including
3978 - // chat_deleted preservation) for each affected email. Reuses the same internal
3979 - // helper as the Leads-tab Delete button for consistency.
3980 - if (!empty($emails_to_fully_wipe)) {
3981 - self::mxchat_wipe_leads_by_email(array_values($emails_to_fully_wipe));
2764 + echo wp_json_encode([
2765 + 'success' => sprintf(
2766 + esc_html__('%d chat session(s) have been deleted from all storage locations.', 'mxchat'),
2767 + $deleted_count
2768 + )
2769 + ]);
2770 + } else {
2771 + echo wp_json_encode(['error' => esc_html__('No chat sessions selected for deletion.', 'mxchat')]);
3982 2772 }
3983 2773
3984 - wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
3985 -
3986 - echo wp_json_encode([
3987 - 'success' => sprintf(
3988 - esc_html__('%d chat session(s) have been deleted.', 'mxchat'),
3989 - $deleted_count
3990 - ),
3991 - 'preserved_as_deleted_leads' => $preserved_as_deleted_leads,
3992 - 'leads_fully_wiped' => count($emails_to_fully_wipe),
3993 - ]);
3994 2774 wp_die();
3995 2775 }
3996 2776
3997 2777 /**
@@ -4247,58 +3027,8 @@
4247 3027 : $row->callback_function;
4248 3028 $action_type_distribution[$label] = $row->count;
4249 3029 }
4250 3030
4251 - // Native function-calling (AI Tools) data — plan-mxchat-20260617-a41dee.
4252 - // The AI Tools checklist reads from MxChat_Tool_Registry, the SAME single
4253 - // source the chat-time function-calling loop reads, so the two never drift.
4254 - if (!class_exists('MxChat_Tool_Registry')) {
4255 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-tool-registry.php';
4256 - }
4257 - if (!class_exists('MxChat_Model_Catalog')) {
4258 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
4259 - }
4260 - $fc_options = get_option('mxchat_options', array());
4261 - $fc_current_model = isset($fc_options['model']) ? $fc_options['model'] : 'gpt-5.1-chat-latest';
4262 - $fc_model_capable = class_exists('MxChat_Model_Catalog')
4263 - ? MxChat_Model_Catalog::supports_tools($fc_current_model) : true;
4264 - $active_tab = (isset($_GET['tab']) && $_GET['tab'] === 'ai-tools') ? 'ai-tools' : 'dashboard';
4265 -
4266 - // Enrich each AI Tool with the dashicon its callback already uses on the
4267 - // Trigger Phrases "Choose what it does" grid, so the AI Tools cards/modal
4268 - // share the same iconography (plan 8bbf98 part 4). View-layer only — the
4269 - // registry's model-facing data is untouched. Default admin-generic.
4270 - $fc_tools = MxChat_Tool_Registry::available_tools();
4271 - foreach ($fc_tools as &$fc_tool_ref) {
4272 - $fc_cb_ref = $fc_tool_ref['callback'];
4273 - $fc_tool_ref['icon'] = isset($available_callbacks[$fc_cb_ref]['icon'])
4274 - ? $available_callbacks[$fc_cb_ref]['icon']
4275 - : 'admin-generic';
4276 - }
4277 - unset($fc_tool_ref);
4278 -
4279 - // Count of ACTIVE tools — drives the AI Tools sidebar nav badge, mirroring
4280 - // $total_actions for Trigger Phrases. A tool in the list = active (plan
4281 - // d450a7), so the badge shows the same number the list pane shows (plan 5f7409).
4282 - $total_tools = count(array_filter($fc_tools, function ($t) {
4283 - return !empty($t['enabled']);
4284 - }));
4285 -
4286 - // Brave-key dependency check (plan 183856): Web Search + Image Search run on
4287 - // the Brave Search API. If either is enabled as a tool but no brave_api_key is
4288 - // configured, surface a graceful "key not set" notice so the admin isn't met
4289 - // with a silently no-firing tool.
4290 - $fc_brave_missing = false;
4291 - $brave_key = isset($fc_options['brave_api_key']) ? trim($fc_options['brave_api_key']) : '';
4292 - if ($brave_key === '') {
4293 - foreach ($fc_tools as $fc_t) {
4294 - if (!empty($fc_t['enabled']) && isset($fc_t['requires_key']) && $fc_t['requires_key'] === 'brave_api_key') {
4295 - $fc_brave_missing = true;
4296 - break;
4297 - }
4298 - }
4299 - }
4300 -
4301 3031 // Prepare page data
4302 3032 $page_data = array(
4303 3033 'total_actions' => $total_actions,
4304 3034 'enabled_actions' => $enabled_actions,
@@ -4306,17 +3036,8 @@
4306 3036 'action_types_count' => $action_types_count,
4307 3037 'action_type_distribution' => $action_type_distribution,
4308 3038 'available_callbacks' => $available_callbacks,
4309 3039 'callback_groups' => $callback_groups,
4310 - // AI Tools section
4311 - 'active_tab' => $active_tab,
4312 - 'fc_enabled' => MxChat_Tool_Registry::is_enabled(),
4313 - 'total_tools' => $total_tools,
4314 - 'fc_tools' => $fc_tools,
4315 - 'fc_current_model' => $fc_current_model,
4316 - 'fc_model_capable' => $fc_model_capable,
4317 - 'fc_brave_missing' => $fc_brave_missing,
4318 - 'fc_saved' => isset($_GET['mxchat_fc_saved']),
4319 3040 );
4320 3041
4321 3042 // Include and render the new template
4322 3043 require_once plugin_dir_path(__FILE__) . 'admin-actions-page.php';
@@ -4926,9 +3647,9 @@
4926 3647 'intent_label' => $intent_label,
4927 3648 'phrases' => implode(', ', $phrases_array),
4928 3649 'embedding_vector' => $serialized_vector,
4929 3650 'similarity_threshold' => $similarity_threshold,
4930 - 'enabled_bots' => $enabled_bots_json, // Include enabled_bots in update
3651 + 'enabled_bots' => $enabled_bots_json // Include enabled_bots in update
4931 3652 ),
4932 3653 array('id' => $intent_id),
4933 3654 array('%s', '%s', '%s', '%f', '%s'), // Format: string, string, string, float, string
4934 3655 array('%d') // Where format: integer
@@ -5045,9 +3766,9 @@
5045 3766 'phrases' => implode(', ', $phrases_array),
5046 3767 'embedding_vector' => $serialized_vector,
5047 3768 'callback_function' => $callback_function,
5048 3769 'similarity_threshold' => $similarity_threshold,
5049 - 'enabled_bots' => $enabled_bots_json, // NEW field
3770 + 'enabled_bots' => $enabled_bots_json // NEW field
5050 3771 ]);
5051 3772
5052 3773 if ($result === false) {
5053 3774 $this->handle_embedding_error(__('Database error: ', 'mxchat') . $wpdb->last_error);
@@ -5130,25 +3851,8 @@
5130 3851
5131 3852 // Get available callbacks for labels/icons
5132 3853 $available_callbacks = $this->mxchat_get_available_callbacks();
5133 3854
5134 - // Prefetch individual phrase counts for all fetched actions
5135 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5136 - $phrase_counts = array();
5137 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5138 - $action_ids = wp_list_pluck($actions, 'id');
5139 - if (!empty($action_ids)) {
5140 - $id_placeholders = implode(',', array_fill(0, count($action_ids), '%d'));
5141 - $count_results = $wpdb->get_results($wpdb->prepare(
5142 - "SELECT intent_id, COUNT(*) as cnt FROM $phrases_table WHERE intent_id IN ($id_placeholders) GROUP BY intent_id",
5143 - $action_ids
5144 - ));
5145 - foreach ($count_results as $row) {
5146 - $phrase_counts[$row->intent_id] = intval($row->cnt);
5147 - }
5148 - }
5149 - }
5150 -
5151 3855 // Format actions for response
5152 3856 $formatted_actions = array();
5153 3857 foreach ($actions as $action) {
5154 3858 $callback_data = isset($available_callbacks[$action->callback_function])
@@ -5169,10 +3873,8 @@
5169 3873 'icon' => isset($callback_data['icon']) ? $callback_data['icon'] : 'admin-generic',
5170 3874 'threshold' => round($action->similarity_threshold * 100),
5171 3875 'enabled' => (bool) $action->enabled,
5172 3876 'enabled_bots' => $enabled_bots,
5173 - 'has_legacy_vector' => !empty($action->embedding_vector),
5174 - 'individual_phrase_count' => isset($phrase_counts[$action->id]) ? $phrase_counts[$action->id] : 0,
5175 3877 );
5176 3878 }
5177 3879
5178 3880 $total_pages = ceil($total_actions / $per_page);
@@ -5251,14 +3953,8 @@
5251 3953 if ($result === false) {
5252 3954 wp_send_json_error(__('Failed to delete actions', 'mxchat'));
5253 3955 }
5254 3956
5255 - // Also delete individual phrases for these intents
5256 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5257 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5258 - $wpdb->query($wpdb->prepare("DELETE FROM $phrases_table WHERE intent_id IN ($placeholders)", $action_ids));
5259 - }
5260 -
5261 3957 wp_send_json_success(array('deleted' => $result));
5262 3958 }
5263 3959
5264 3960 /**
@@ -5281,18 +3977,25 @@
5281 3977 $similarity_threshold = isset($_POST['similarity_threshold']) ? floatval($_POST['similarity_threshold']) / 100 : 0.85;
5282 3978 $enabled_bots = isset($_POST['enabled_bots']) ? array_map('sanitize_text_field', (array) $_POST['enabled_bots']) : array('default');
5283 3979
5284 3980 // Validate
5285 - // Check if using new individual phrases mode or legacy mode
5286 - $individual_phrases = isset($_POST['individual_phrases']) ? array_filter(array_map('sanitize_text_field', (array) $_POST['individual_phrases'])) : array();
5287 - $use_individual = !empty($individual_phrases);
3981 + if (empty($intent_label) || empty($phrases_input) || empty($callback_function)) {
3982 + wp_send_json_error(__('Please fill in all required fields.', 'mxchat'));
3983 + }
5288 3984
5289 - // Validate required fields (phrases not required when using individual mode)
5290 - if (empty($intent_label) || empty($callback_function)) {
5291 - wp_send_json_error(__('Please fill in all required fields.', 'mxchat'));
3985 + // Process phrases
3986 + $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
3987 + if (empty($phrases_array)) {
3988 + wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
5292 3989 }
5293 - if (!$use_individual && empty($phrases_input)) {
5294 - wp_send_json_error(__('Please fill in all required fields.', 'mxchat'));
3990 +
3991 + // Generate embedding (combine phrases into single string for embedding)
3992 + $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
3993 + if (is_wp_error($embedding_vector)) {
3994 + // Fallback: store without embedding
3995 + $serialized_vector = null;
3996 + } else {
3997 + $serialized_vector = maybe_serialize($embedding_vector);
5295 3998 }
5296 3999
5297 4000 // Ensure default bot is included
5298 4001 if (!in_array('default', $enabled_bots)) {
@@ -5299,95 +4002,27 @@
5299 4002 $enabled_bots[] = 'default';
5300 4003 }
5301 4004 $enabled_bots_json = json_encode($enabled_bots);
5302 4005
5303 - if ($use_individual) {
5304 - // New mode: individual phrases each get their own vector
5305 - // Insert the intent row with empty legacy fields
5306 - $result = $wpdb->insert(
5307 - $table_name,
5308 - array(
5309 - 'intent_label' => $intent_label,
5310 - 'phrases' => '',
5311 - 'embedding_vector' => '',
5312 - 'similarity_threshold' => $similarity_threshold,
5313 - 'callback_function' => $callback_function,
5314 - 'enabled' => 1,
5315 - 'enabled_bots' => $enabled_bots_json,
5316 - )
5317 - );
4006 + // Insert
4007 + $result = $wpdb->insert(
4008 + $table_name,
4009 + array(
4010 + 'intent_label' => $intent_label,
4011 + 'phrases' => implode(', ', $phrases_array),
4012 + 'embedding_vector' => $serialized_vector,
4013 + 'similarity_threshold' => $similarity_threshold,
4014 + 'callback_function' => $callback_function,
4015 + 'enabled' => 1,
4016 + 'enabled_bots' => $enabled_bots_json,
4017 + )
4018 + );
5318 4019
5319 - if ($result === false) {
5320 - wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
5321 - }
4020 + if ($result === false) {
4021 + wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
4022 + }
5322 4023
5323 - $intent_id = $wpdb->insert_id;
5324 -
5325 - // Insert each phrase individually with its own embedding
5326 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5327 - $failed_phrases = array();
5328 - foreach ($individual_phrases as $phrase) {
5329 - $phrase = trim($phrase);
5330 - if (empty($phrase)) continue;
5331 -
5332 - $embedding_vector = $this->mxchat_generate_embedding($phrase);
5333 - if (is_wp_error($embedding_vector)) {
5334 - $failed_phrases[] = $phrase;
5335 - continue;
5336 - }
5337 -
5338 - $wpdb->insert(
5339 - $phrases_table,
5340 - array(
5341 - 'intent_id' => $intent_id,
5342 - 'phrase' => $phrase,
5343 - 'embedding_vector' => maybe_serialize($embedding_vector),
5344 - )
5345 - );
5346 - }
5347 -
5348 - $response = array('id' => $intent_id);
5349 - if (!empty($failed_phrases)) {
5350 - $response['failed_phrases'] = $failed_phrases;
5351 - }
5352 - wp_send_json_success($response);
5353 -
5354 - } else {
5355 - // Legacy mode: combine all phrases into one embedding (backwards compatible)
5356 - $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
5357 - if (empty($phrases_array)) {
5358 - wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
5359 - }
5360 -
5361 - // Generate embedding (combine phrases into single string for embedding)
5362 - $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
5363 - if (is_wp_error($embedding_vector)) {
5364 - // Fallback: store without embedding
5365 - $serialized_vector = null;
5366 - } else {
5367 - $serialized_vector = maybe_serialize($embedding_vector);
5368 - }
5369 -
5370 - // Insert
5371 - $result = $wpdb->insert(
5372 - $table_name,
5373 - array(
5374 - 'intent_label' => $intent_label,
5375 - 'phrases' => implode(', ', $phrases_array),
5376 - 'embedding_vector' => $serialized_vector,
5377 - 'similarity_threshold' => $similarity_threshold,
5378 - 'callback_function' => $callback_function,
5379 - 'enabled' => 1,
5380 - 'enabled_bots' => $enabled_bots_json,
5381 - )
5382 - );
5383 -
5384 - if ($result === false) {
5385 - wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
5386 - }
5387 -
5388 - wp_send_json_success(array('id' => $wpdb->insert_id));
5389 - }
4024 + wp_send_json_success(array('id' => $wpdb->insert_id));
5390 4025 }
5391 4026
5392 4027 /**
5393 4028 * AJAX handler to edit an existing intent/action
@@ -5410,52 +4045,40 @@
5410 4045 $similarity_threshold = isset($_POST['similarity_threshold']) ? floatval($_POST['similarity_threshold']) / 100 : 0.85;
5411 4046 $enabled_bots = isset($_POST['enabled_bots']) ? array_map('sanitize_text_field', (array) $_POST['enabled_bots']) : array('default');
5412 4047
5413 4048 // Validate
5414 - if (!$intent_id || empty($intent_label)) {
4049 + if (!$intent_id || empty($intent_label) || empty($phrases_input)) {
5415 4050 wp_send_json_error(__('Please fill in all required fields.', 'mxchat'));
5416 4051 }
5417 4052
5418 - // Check if phrases are managed individually (empty phrases_input means individual mode)
5419 - $uses_individual_phrases = empty($phrases_input);
4053 + // Process phrases
4054 + $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
4055 + if (empty($phrases_array)) {
4056 + wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
4057 + }
5420 4058
5421 - if ($uses_individual_phrases) {
5422 - // Individual phrase mode: only update non-phrase fields, skip embedding regeneration
4059 + // Generate new embedding (combine phrases into single string for embedding)
4060 + $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
4061 + if (is_wp_error($embedding_vector)) {
4062 + // Keep existing embedding
4063 + $serialized_vector = null;
5423 4064 $update_data = array(
5424 4065 'intent_label' => $intent_label,
4066 + 'phrases' => implode(', ', $phrases_array),
5425 4067 'similarity_threshold' => $similarity_threshold,
5426 4068 'callback_function' => $callback_function,
5427 4069 'enabled_bots' => json_encode($enabled_bots),
5428 4070 );
5429 4071 } else {
5430 - // Legacy mode: process phrases and regenerate embedding (backwards compatible for add-ons)
5431 - $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
5432 - if (empty($phrases_array)) {
5433 - wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
5434 - }
5435 -
5436 - // Generate new embedding (combine phrases into single string for embedding)
5437 - $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
5438 - if (is_wp_error($embedding_vector)) {
5439 - // Keep existing embedding
5440 - $update_data = array(
5441 - 'intent_label' => $intent_label,
5442 - 'phrases' => implode(', ', $phrases_array),
5443 - 'similarity_threshold' => $similarity_threshold,
5444 - 'callback_function' => $callback_function,
5445 - 'enabled_bots' => json_encode($enabled_bots),
5446 - );
5447 - } else {
5448 - $serialized_vector = maybe_serialize($embedding_vector);
5449 - $update_data = array(
5450 - 'intent_label' => $intent_label,
5451 - 'phrases' => implode(', ', $phrases_array),
5452 - 'embedding_vector' => $serialized_vector,
5453 - 'similarity_threshold' => $similarity_threshold,
5454 - 'callback_function' => $callback_function,
5455 - 'enabled_bots' => json_encode($enabled_bots),
5456 - );
5457 - }
4072 + $serialized_vector = maybe_serialize($embedding_vector);
4073 + $update_data = array(
4074 + 'intent_label' => $intent_label,
4075 + 'phrases' => implode(', ', $phrases_array),
4076 + 'embedding_vector' => $serialized_vector,
4077 + 'similarity_threshold' => $similarity_threshold,
4078 + 'callback_function' => $callback_function,
4079 + 'enabled_bots' => json_encode($enabled_bots),
4080 + );
5458 4081 }
5459 4082
5460 4083 // Ensure default bot is included
5461 4084 if (!in_array('default', $enabled_bots)) {
@@ -5502,154 +4125,13 @@
5502 4125 if ($result === false) {
5503 4126 wp_send_json_error(__('Failed to delete action', 'mxchat'));
5504 4127 }
5505 4128
5506 - // Also delete individual phrases for this intent
5507 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5508 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5509 - $wpdb->delete($phrases_table, array('intent_id' => $intent_id), array('%d'));
5510 - }
5511 -
5512 4129 wp_send_json_success(array('deleted' => true));
5513 4130 }
5514 4131
5515 -/**
5516 - * AJAX handler to add a single phrase with its own embedding to an intent
5517 - */
5518 -public function mxchat_add_phrase_ajax() {
5519 - check_ajax_referer('mxchat_add_phrase_nonce', 'security');
5520 4132
5521 - if (!current_user_can('manage_options')) {
5522 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5523 - }
5524 -
5525 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5526 - $phrase = isset($_POST['phrase']) ? sanitize_text_field($_POST['phrase']) : '';
5527 -
5528 - if (!$intent_id || empty($phrase)) {
5529 - wp_send_json_error(__('Please provide an intent ID and phrase.', 'mxchat'));
5530 - }
5531 -
5532 - // Verify the intent exists
5533 - global $wpdb;
5534 - $intents_table = $wpdb->prefix . 'mxchat_intents';
5535 - $intent = $wpdb->get_row($wpdb->prepare("SELECT id FROM $intents_table WHERE id = %d", $intent_id));
5536 - if (!$intent) {
5537 - wp_send_json_error(__('Action not found.', 'mxchat'));
5538 - }
5539 -
5540 - // Generate embedding for this single phrase
5541 - $embedding_vector = $this->mxchat_generate_embedding($phrase);
5542 - if (is_wp_error($embedding_vector)) {
5543 - wp_send_json_error(__('Failed to generate embedding: ', 'mxchat') . $embedding_vector->get_error_message());
5544 - }
5545 -
5546 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5547 - $result = $wpdb->insert(
5548 - $phrases_table,
5549 - array(
5550 - 'intent_id' => $intent_id,
5551 - 'phrase' => $phrase,
5552 - 'embedding_vector' => maybe_serialize($embedding_vector),
5553 - )
5554 - );
5555 -
5556 - if ($result === false) {
5557 - wp_send_json_error(__('Failed to add phrase.', 'mxchat'));
5558 - }
5559 -
5560 - wp_send_json_success(array('id' => $wpdb->insert_id, 'phrase' => $phrase));
5561 -}
5562 -
5563 4133 /**
5564 - * AJAX handler to delete a single phrase from wp_mxchat_intent_phrases
5565 - */
5566 -public function mxchat_delete_phrase_ajax() {
5567 - check_ajax_referer('mxchat_delete_phrase_nonce', 'security');
5568 -
5569 - if (!current_user_can('manage_options')) {
5570 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5571 - }
5572 -
5573 - $phrase_id = isset($_POST['phrase_id']) ? intval($_POST['phrase_id']) : 0;
5574 - if (!$phrase_id) {
5575 - wp_send_json_error(__('Invalid phrase ID.', 'mxchat'));
5576 - }
5577 -
5578 - global $wpdb;
5579 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5580 - $result = $wpdb->delete($phrases_table, array('id' => $phrase_id), array('%d'));
5581 -
5582 - if ($result === false) {
5583 - wp_send_json_error(__('Failed to delete phrase.', 'mxchat'));
5584 - }
5585 -
5586 - wp_send_json_success(array('deleted' => true));
5587 -}
5588 -
5589 -/**
5590 - * AJAX handler to fetch individual phrases for an intent
5591 - */
5592 -public function mxchat_get_phrases_ajax() {
5593 - check_ajax_referer('mxchat_get_phrases_nonce', 'security');
5594 -
5595 - if (!current_user_can('manage_options')) {
5596 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5597 - }
5598 -
5599 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5600 - if (!$intent_id) {
5601 - wp_send_json_error(__('Invalid intent ID.', 'mxchat'));
5602 - }
5603 -
5604 - global $wpdb;
5605 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5606 -
5607 - $phrases = array();
5608 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5609 - $phrases = $wpdb->get_results($wpdb->prepare(
5610 - "SELECT id, phrase, created_at FROM $phrases_table WHERE intent_id = %d ORDER BY created_at ASC",
5611 - $intent_id
5612 - ));
5613 - }
5614 -
5615 - wp_send_json_success(array('phrases' => $phrases));
5616 -}
5617 -
5618 -/**
5619 - * AJAX handler to clear legacy phrases and embedding from the main intents table
5620 - */
5621 -public function mxchat_delete_legacy_phrases_ajax() {
5622 - check_ajax_referer('mxchat_delete_legacy_nonce', 'security');
5623 -
5624 - if (!current_user_can('manage_options')) {
5625 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5626 - }
5627 -
5628 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5629 - if (!$intent_id) {
5630 - wp_send_json_error(__('Invalid intent ID.', 'mxchat'));
5631 - }
5632 -
5633 - global $wpdb;
5634 - $table_name = $wpdb->prefix . 'mxchat_intents';
5635 -
5636 - $result = $wpdb->update(
5637 - $table_name,
5638 - array('phrases' => '', 'embedding_vector' => ''),
5639 - array('id' => $intent_id),
5640 - array('%s', '%s'),
5641 - array('%d')
5642 - );
5643 -
5644 - if ($result === false) {
5645 - wp_send_json_error(__('Failed to clear legacy phrases.', 'mxchat'));
5646 - }
5647 -
5648 - wp_send_json_success(array('cleared' => true));
5649 -}
5650 -
5651 -/**
5652 4134 * Enhanced get_available_callbacks function with form action exclusion
5653 4135 *
5654 4136 * @param bool $grouped Whether to return callbacks grouped by category
5655 4137 * @param bool $include_all Whether to include all potential actions (even if add-on not installed)
@@ -5753,9 +4235,9 @@
5753 4235 'label' => __('Brave Web Search', 'mxchat'),
5754 4236 'pro_only' => false,
5755 4237 'group' => __('Search Features', 'mxchat'),
5756 4238 'icon' => 'search',
5757 - 'description' => __('Let users search the web directly from the chat (requires a Brave Search API key)', 'mxchat'),
4239 + 'description' => __('Let users search the web directly from the chat', 'mxchat'),
5758 4240 'addon' => false,
5759 4241 'installed' => true
5760 4242 ),
5761 4243 'mxchat_handle_image_search_request' => array(
@@ -5762,9 +4244,9 @@
5762 4244 'label' => __('Brave Image Search', 'mxchat'),
5763 4245 'pro_only' => false,
5764 4246 'group' => __('Search Features', 'mxchat'),
5765 4247 'icon' => 'format-image',
5766 - 'description' => __('Search and display images in the chat conversation (requires a Brave Search API key)', 'mxchat'),
4248 + 'description' => __('Search and display images in the chat conversation', 'mxchat'),
5767 4249 'addon' => false,
5768 4250 'installed' => true
5769 4251 ),
5770 4252 // Pro core features - check is_activated property
@@ -6119,17 +4601,8 @@
6119 4601 'mxchat-api-keys',
6120 4602 'mxchat_api_keys_section'
6121 4603 );
6122 4604
6123 - // Custom (OpenAI-compatible) Provider — for Ollama, LM Studio, vLLM, llama.cpp, Azure OpenAI, etc.
6124 - add_settings_field(
6125 - 'custom_provider',
6126 - esc_html__('Custom Provider (OpenAI-compatible)', 'mxchat'),
6127 - array($this, 'custom_provider_callback'),
6128 - 'mxchat-api-keys',
6129 - 'mxchat_api_keys_section'
6130 - );
6131 -
6132 4605 // Loops API Key
6133 4606 add_settings_field(
6134 4607 'loops_api_key',
6135 4608 esc_html__('Loops API Key', 'mxchat'),
@@ -6146,8 +4619,17 @@
6146 4619 'mxchat-api-keys',
6147 4620 'mxchat_api_keys_section'
6148 4621 );
6149 4622
4623 + // Frontend Debugger Toggle
4624 + add_settings_field(
4625 + 'show_frontend_debugger',
4626 + esc_html__('Frontend Debugger', 'mxchat'),
4627 + array($this, 'mxchat_frontend_debugger_callback'),
4628 + 'mxchat-chatbot',
4629 + 'mxchat_chatbot_section'
4630 + );
4631 +
6150 4632 // Similarity Threshold Slider
6151 4633 add_settings_field(
6152 4634 'similarity_threshold', // Field ID
6153 4635 esc_html__('Similarity Threshold', 'mxchat'), // Field title
@@ -6164,18 +4646,9 @@
6164 4646 'mxchat-chatbot', // Page
6165 4647 'mxchat_chatbot_section' // Section
6166 4648 );
6167 4649
6168 - // RAG Chunks Limit Slider
6169 4650 add_settings_field(
6170 - 'rag_chunks_limit', // Field ID
6171 - esc_html__('RAG Chunks Limit', 'mxchat'), // Field title
6172 - array($this, 'mxchat_rag_chunks_limit_callback'), // Callback function
6173 - 'mxchat-chatbot', // Page
6174 - 'mxchat_chatbot_section' // Section
6175 - );
6176 -
6177 - add_settings_field(
6178 4651 'append_to_body',
6179 4652 esc_html__('Auto-Display Chatbot', 'mxchat'),
6180 4653 array($this, 'mxchat_append_to_body_callback'),
6181 4654 'mxchat-chatbot',
@@ -6197,22 +4670,9 @@
6197 4670 'mxchat-chatbot',
6198 4671 'mxchat_chatbot_section'
6199 4672 );
6200 4673
6201 - // Satisfaction rating toggle (plan-a5b006).
6202 4674 add_settings_field(
6203 - 'satisfaction_rating_enabled',
6204 - esc_html__('Satisfaction Rating Prompt', 'mxchat'),
6205 - array($this, 'mxchat_satisfaction_rating_toggle_callback'),
6206 - 'mxchat-chatbot',
6207 - 'mxchat_chatbot_section'
6208 - );
6209 -
6210 - // Satisfaction rating customization (plan-141a12, plan-29caac):
6211 - // the 5 customization fields are now inline-rendered inside
6212 - // mxchat_satisfaction_rating_toggle_callback's sub-options wrapper.
6213 -
6214 - add_settings_field(
6215 4675 'enable_streaming_toggle',
6216 4676 esc_html__('Enable Streaming', 'mxchat'),
6217 4677 array($this, 'enable_streaming_toggle_callback'),
6218 4678 'mxchat-chatbot',
@@ -6361,32 +4821,8 @@
6361 4821 'mxchat_chatbot_section'
6362 4822 );
6363 4823
6364 4824 add_settings_field(
6365 - 'print_button_enabled',
6366 - esc_html__('Show Download Transcript Button', 'mxchat'),
6367 - array($this, 'mxchat_print_button_toggle_callback'),
6368 - 'mxchat-chatbot',
6369 - 'mxchat_chatbot_section'
6370 - );
6371 -
6372 - add_settings_field(
6373 - 'reset_chat_enabled',
6374 - esc_html__('Show Start-New-Chat Button', 'mxchat'),
6375 - array($this, 'mxchat_reset_chat_toggle_callback'),
6376 - 'mxchat-chatbot',
6377 - 'mxchat_chatbot_section'
6378 - );
6379 -
6380 - add_settings_field(
6381 - 'reset_chat_label',
6382 - esc_html__('Start-New-Chat Button Label', 'mxchat'),
6383 - array($this, 'mxchat_reset_chat_label_callback'),
6384 - 'mxchat-chatbot',
6385 - 'mxchat_chatbot_section'
6386 - );
6387 -
6388 - add_settings_field(
6389 4825 'popular_question_1',
6390 4826 esc_html__('Quick Question 1', 'mxchat'),
6391 4827 array($this, 'mxchat_popular_question_1_callback'),
6392 4828 'mxchat-chatbot',
@@ -6776,16 +5212,8 @@
6776 5212 'mxchat_transcripts_notification_section'
6777 5213 );
6778 5214
6779 5215 add_settings_field(
6780 - 'mxchat_retention_days',
6781 - esc_html__('Custom Retention (Days)', 'mxchat'),
6782 - array($this, 'mxchat_retention_days_callback'),
6783 - 'mxchat-transcripts',
6784 - 'mxchat_transcripts_notification_section'
6785 - );
6786 -
6787 - add_settings_field(
6788 5216 'mxchat_auto_email_transcript',
6789 5217 esc_html__('Auto-Email Full Transcript', 'mxchat'),
6790 5218 array($this, 'mxchat_auto_email_transcript_callback'),
6791 5219 'mxchat-transcripts',
@@ -7022,9 +5450,8 @@
7022 5450 echo '<div class="api-key-wrapper">';
7023 5451 echo '<input type="text" id="api_key" name="api_key" value="' . $apiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7024 5452 echo '<button type="button" id="toggleApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7025 5453 echo '<p class="description">' . esc_html__('Required for OpenAI GPT models and OpenAI embeddings. Get your API key from OpenAI Platform.', 'mxchat') . '</p>';
7026 - echo $this->mxchat_provider_key_test_button('openai', 'api_key');
7027 5454 echo '</div>';
7028 5455 }
7029 5456
7030 5457 // X.AI API Key
@@ -7035,9 +5462,8 @@
7035 5462 echo '<div class="api-key-wrapper">';
7036 5463 echo '<input type="text" id="xai_api_key" name="xai_api_key" value="' . $xaiApiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7037 5464 echo '<button type="button" id="toggleXaiApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7038 5465 echo '<p class="description">' . esc_html__('Required for X.AI Grok models. Get your API key from X.AI Console.', 'mxchat') . '</p>';
7039 - echo $this->mxchat_provider_key_test_button('xai', 'xai_api_key');
7040 5466 echo '</div>';
7041 5467 }
7042 5468 // Claude API Key
7043 5469 public function claude_api_key_callback() {
@@ -7047,9 +5473,8 @@
7047 5473 echo '<div class="api-key-wrapper">';
7048 5474 echo '<input type="text" id="claude_api_key" name="claude_api_key" value="' . $claudeApiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7049 5475 echo '<button type="button" id="toggleClaudeApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7050 5476 echo '<p class="description">' . esc_html__('Required for Anthropic Claude models. Get your API key from Anthropic Console.', 'mxchat') . '</p>';
7051 - echo $this->mxchat_provider_key_test_button('claude', 'claude_api_key');
7052 5477 echo '</div>';
7053 5478 }
7054 5479
7055 5480 // DeepSeek API Key
@@ -7060,9 +5485,8 @@
7060 5485 echo '<div class="api-key-wrapper">';
7061 5486 echo '<input type="text" id="deepseek_api_key" name="deepseek_api_key" value="' . $apiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7062 5487 echo '<button type="button" id="toggleDeepSeekApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7063 5488 echo '<p class="description">' . esc_html__('Required for DeepSeek models. Get your API key from DeepSeek Platform.', 'mxchat') . '</p>';
7064 - echo $this->mxchat_provider_key_test_button('deepseek', 'deepseek_api_key');
7065 5489 echo '</div>';
7066 5490 }
7067 5491
7068 5492 // Gemini API Key
@@ -7073,9 +5497,8 @@
7073 5497 echo '<div class="api-key-wrapper">';
7074 5498 echo '<input type="text" id="gemini_api_key" name="gemini_api_key" value="' . $geminiApiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7075 5499 echo '<button type="button" id="toggleGeminiApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7076 5500 echo '<p class="description">' . esc_html__('Required for Google Gemini models and embeddings. Get your API key from Google AI Studio.', 'mxchat') . '</p>';
7077 - echo $this->mxchat_provider_key_test_button('gemini', 'gemini_api_key');
7078 5501 echo '</div>';
7079 5502 }
7080 5503
7081 5504
@@ -7087,203 +5510,11 @@
7087 5510 echo '<div class="api-key-wrapper">';
7088 5511 echo '<input type="text" id="openrouter_api_key" name="openrouter_api_key" value="' . $openrouterApiKey . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7089 5512 echo '<button type="button" id="toggleOpenRouterApiKeyVisibility">' . esc_html__('Show', 'mxchat') . '</button>';
7090 5513 echo '<p class="description">' . esc_html__('Required for OpenRouter models. Get your API key from OpenRouter.ai', 'mxchat') . '</p>';
7091 - echo $this->mxchat_provider_key_test_button('openrouter', 'openrouter_api_key');
7092 5514 echo '</div>';
7093 5515 }
7094 5516
7095 -/**
7096 - * Renders a "Test key" button + result target next to a built-in provider key
7097 - * field, and emits the shared delegated click handler ONCE (static guard). The
7098 - * button carries data-target = the key field id so the owner can test the value
7099 - * they just typed (test-before-save); the AJAX handler falls back to the saved
7100 - * key when the field is empty. Styled with the WP `button` class to match the
7101 - * adjacent Custom-provider "Test Connection" button on this same page.
7102 - * plan-mxchat-20260623-c41f74.
7103 - */
7104 -public function mxchat_provider_key_test_button($provider, $target_id) {
7105 - static $script_emitted = false;
7106 - $nonce = wp_create_nonce('mxchat_test_provider_key');
7107 - $html = '<div class="mxchat-key-test" style="margin-top:8px;">'
7108 - . '<button type="button" class="button mxchat-test-provider-key" data-provider="' . esc_attr($provider) . '" data-target="' . esc_attr($target_id) . '" data-nonce="' . esc_attr($nonce) . '">' . esc_html__('Test key', 'mxchat') . '</button>'
7109 - . '<span class="mxchat-test-provider-key-result" style="margin-left:10px;font-size:13px;vertical-align:middle;"></span>'
7110 - . '</div>';
7111 - if (!$script_emitted) {
7112 - $script_emitted = true;
7113 - $html .= $this->mxchat_provider_key_test_script();
7114 - }
7115 - return $html;
7116 -}
7117 -
7118 -/**
7119 - * One-time delegated click handler shared by every .mxchat-test-provider-key
7120 - * button. Posts the typed key value + provider to mxchat_test_provider_key and
7121 - * renders the success/error message inline. Mirrors the Custom-provider test.
7122 - */
7123 -private function mxchat_provider_key_test_script() {
7124 - $t_testing = esc_js(__('Testing...', 'mxchat'));
7125 - $t_valid = esc_js(__('Key is valid.', 'mxchat'));
7126 - $t_failed = esc_js(__('Failed', 'mxchat'));
7127 - $t_req = esc_js(__('Request failed', 'mxchat'));
7128 - return '<script>(function(){'
7129 - . 'if (window.__mxchatProviderKeyTestWired) { return; }'
7130 - . 'window.__mxchatProviderKeyTestWired = true;'
7131 - . 'document.addEventListener("click", function(e){'
7132 - . 'var btn = e.target && e.target.closest ? e.target.closest(".mxchat-test-provider-key") : null;'
7133 - . 'if (!btn) { return; }'
7134 - . 'e.preventDefault();'
7135 - . 'var field = btn.getAttribute("data-target") ? document.getElementById(btn.getAttribute("data-target")) : null;'
7136 - . 'var out = btn.parentNode ? btn.parentNode.querySelector(".mxchat-test-provider-key-result") : null;'
7137 - . 'if (out) { out.textContent = "' . $t_testing . '"; out.style.color = "#646970"; }'
7138 - . 'btn.disabled = true;'
7139 - . 'var fd = new FormData();'
7140 - . 'fd.append("action", "mxchat_test_provider_key");'
7141 - . 'fd.append("_wpnonce", btn.getAttribute("data-nonce"));'
7142 - . 'fd.append("provider", btn.getAttribute("data-provider") || "");'
7143 - . 'fd.append("key", field ? field.value : "");'
7144 - . 'fetch(ajaxurl, { method:"POST", credentials:"same-origin", body: fd })'
7145 - . '.then(function(r){ return r.json(); })'
7146 - . '.then(function(j){'
7147 - . 'if (out) {'
7148 - . 'if (j && j.success) { out.textContent = "✓ " + ((j.data && j.data.message) ? j.data.message : "' . $t_valid . '"); out.style.color = "#00a32a"; }'
7149 - . 'else { out.textContent = "⚠ " + ((j && j.data && j.data.message) ? j.data.message : "' . $t_failed . '"); out.style.color = "#d63638"; }'
7150 - . '}'
7151 - . 'btn.disabled = false;'
7152 - . '})'
7153 - . '.catch(function(){ if (out) { out.textContent = "⚠ ' . $t_req . '"; out.style.color = "#d63638"; } btn.disabled = false; });'
7154 - . '});'
7155 - . '})();</script>';
7156 -}
7157 -
7158 -// Custom (OpenAI-compatible) Provider — Ollama, LM Studio, vLLM, llama.cpp, Azure OpenAI, etc.
7159 -public function custom_provider_callback() {
7160 - $base_url = isset($this->options['custom_provider_base_url']) ? esc_attr($this->options['custom_provider_base_url']) : '';
7161 - $api_key = isset($this->options['custom_provider_api_key']) ? esc_attr($this->options['custom_provider_api_key']) : '';
7162 - $model_name = isset($this->options['custom_provider_model']) ? esc_attr($this->options['custom_provider_model']) : '';
7163 - $auth_scheme = isset($this->options['custom_provider_auth_scheme']) ? esc_attr($this->options['custom_provider_auth_scheme']) : 'bearer';
7164 - $api_version = isset($this->options['custom_provider_api_version']) ? esc_attr($this->options['custom_provider_api_version']) : '';
7165 - $use_embed = !empty($this->options['custom_provider_for_embeddings']) && $this->options['custom_provider_for_embeddings'] === 'on';
7166 - $use_images = !empty($this->options['custom_provider_for_images']) && $this->options['custom_provider_for_images'] === 'on';
7167 - $embed_model = isset($this->options['custom_provider_embedding_model']) ? esc_attr($this->options['custom_provider_embedding_model']) : '';
7168 - $nonce = wp_create_nonce('mxchat_autosave_nonce');
7169 - $test_nonce = wp_create_nonce('mxchat_test_custom_provider');
7170 -
7171 - echo '<style>
7172 - .mxchat-cp { max-width: 680px; }
7173 - .mxchat-cp .mxchat-cp-intro { margin: 0 0 16px; color: #50575e; font-size: 13px; line-height: 1.5; }
7174 - .mxchat-cp .mxchat-cp-row { display: block; margin: 0 0 18px; }
7175 - .mxchat-cp .mxchat-cp-row > label { display: block; font-weight: 600; margin: 0 0 6px; color: #1d2327; font-size: 13px; }
7176 - .mxchat-cp .mxchat-cp-row > input[type="text"],
7177 - .mxchat-cp .mxchat-cp-row > input[type="password"],
7178 - .mxchat-cp .mxchat-cp-row > select { display: block; width: 100%; max-width: 480px; margin: 0; }
7179 - .mxchat-cp .mxchat-cp-row > .description { display: block; margin: 6px 0 0; color: #646970; font-size: 12px; line-height: 1.5; max-width: 480px; }
7180 - .mxchat-cp .mxchat-cp-test { margin-top: 4px; padding-top: 14px; border-top: 1px solid #e5e7eb; }
7181 - .mxchat-cp .mxchat-cp-test .mxchat-cp-test-status { display: inline-block; margin-left: 10px; vertical-align: middle; font-size: 13px; }
7182 - .mxchat-cp .mxchat-cp-azure { margin: 0 0 18px; padding: 12px 14px; background: #f6f7ff; border: 1px solid #dfe1f5; border-left: 3px solid #7873f5; border-radius: 6px; max-width: 480px; }
7183 - .mxchat-cp .mxchat-cp-azure > .mxchat-cp-azure-title { display: block; font-weight: 600; color: #1d2327; font-size: 12px; text-transform: uppercase; letter-spacing: 0.4px; margin: 0 0 8px; }
7184 - .mxchat-cp .mxchat-cp-azure ol { margin: 0; padding: 0 0 0 18px; color: #50575e; font-size: 12px; line-height: 1.7; }
7185 - .mxchat-cp .mxchat-cp-azure code { background: #eceefb; padding: 1px 5px; border-radius: 3px; font-size: 11px; }
7186 - </style>';
7187 -
7188 - echo '<div class="api-key-wrapper mxchat-cp">';
7189 - echo '<p class="mxchat-cp-intro">' . esc_html__('Point MxChat at any OpenAI-compatible /v1/chat/completions endpoint: Ollama, LM Studio, vLLM, llama.cpp, LocalAI, Azure OpenAI, etc. Then select "Custom (OpenAI-compatible)" in the model picker.', 'mxchat') . '</p>';
7190 -
7191 - // Azure OpenAI quick start — consolidates the 4-field Azure recipe in one scannable callout
7192 - // so admins can configure Azure without piecing it together from each field's hint.
7193 - echo '<div class="mxchat-cp-azure">';
7194 - echo '<span class="mxchat-cp-azure-title">' . esc_html__('Azure OpenAI quick start', 'mxchat') . '</span>';
7195 - echo '<ol>';
7196 - echo '<li>' . wp_kses(__('<strong>Base URL</strong> → <code>https://&lt;resource&gt;.openai.azure.com/openai/deployments/&lt;deployment&gt;</code>', 'mxchat'), array('strong' => array(), 'code' => array())) . '</li>';
7197 - echo '<li>' . wp_kses(__('<strong>API Key</strong> → your Azure OpenAI key (required)', 'mxchat'), array('strong' => array(), 'code' => array())) . '</li>';
7198 - echo '<li>' . wp_kses(__('<strong>Auth Scheme</strong> → <code>api-key header (Azure OpenAI)</code>', 'mxchat'), array('strong' => array(), 'code' => array())) . '</li>';
7199 - echo '<li>' . wp_kses(__('<strong>API Version</strong> → required for Azure, e.g. <code>2024-08-01-preview</code>', 'mxchat'), array('strong' => array(), 'code' => array())) . '</li>';
7200 - echo '</ol>';
7201 - echo '</div>';
7202 -
7203 - echo '<div class="mxchat-cp-row">';
7204 - echo '<label for="custom_provider_base_url">' . esc_html__('Base URL', 'mxchat') . '</label>';
7205 - echo '<input type="text" id="custom_provider_base_url" name="custom_provider_base_url" value="' . $base_url . '" class="regular-text mxchat-autosave-field" placeholder="http://localhost:11434/v1" autocomplete="off" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7206 - echo '<p class="description">' . esc_html__('Examples: Ollama http://localhost:11434/v1 · LM Studio http://localhost:1234/v1 · vLLM http://gpu:8000/v1 · Azure https://<resource>.openai.azure.com/openai/deployments/<deployment>', 'mxchat') . '</p>';
7207 - echo '</div>';
7208 -
7209 - echo '<div class="mxchat-cp-row">';
7210 - echo '<label for="custom_provider_api_key">' . esc_html__('API Key (optional)', 'mxchat') . '</label>';
7211 - echo '<input type="password" id="custom_provider_api_key" name="custom_provider_api_key" value="' . $api_key . '" class="regular-text mxchat-autosave-field mxchat-api-key-field" autocomplete="new-password" data-lpignore="true" data-form-type="other" data-nonce="' . $nonce . '" />';
7212 - echo '<p class="description">' . esc_html__('Leave empty for unauthenticated local servers. Required for Azure / vLLM / hosted endpoints.', 'mxchat') . '</p>';
7213 - echo '</div>';
7214 -
7215 - echo '<div class="mxchat-cp-row">';
7216 - echo '<label for="custom_provider_model">' . esc_html__('Model Name', 'mxchat') . '</label>';
7217 - echo '<input type="text" id="custom_provider_model" name="custom_provider_model" value="' . $model_name . '" class="regular-text mxchat-autosave-field" placeholder="llama3.2" autocomplete="off" data-lpignore="true" data-nonce="' . $nonce . '" />';
7218 - echo '<p class="description">' . esc_html__('The model identifier the upstream server expects (e.g. llama3.2, mistral, gpt-oss). For Azure this is the deployment ID — leave empty if the Base URL already includes /deployments/<deployment>.', 'mxchat') . '</p>';
7219 - echo '</div>';
7220 -
7221 - echo '<div class="mxchat-cp-row">';
7222 - echo '<label for="custom_provider_auth_scheme">' . esc_html__('Auth Scheme', 'mxchat') . '</label>';
7223 - echo '<select id="custom_provider_auth_scheme" name="custom_provider_auth_scheme" class="mxchat-autosave-field" data-nonce="' . $nonce . '">';
7224 - echo '<option value="bearer"' . selected($auth_scheme, 'bearer', false) . '>' . esc_html__('Authorization: Bearer (OpenAI / Ollama / vLLM / LM Studio)', 'mxchat') . '</option>';
7225 - echo '<option value="api-key"' . selected($auth_scheme, 'api-key', false) . '>' . esc_html__('api-key header (Azure OpenAI)', 'mxchat') . '</option>';
7226 - echo '</select>';
7227 - echo '<p class="description">' . esc_html__('Most OpenAI-compatible servers use Bearer. Azure OpenAI uses the api-key header.', 'mxchat') . '</p>';
7228 - echo '</div>';
7229 -
7230 - echo '<div class="mxchat-cp-row">';
7231 - echo '<label for="custom_provider_api_version">' . esc_html__('API Version (Azure only)', 'mxchat') . '</label>';
7232 - echo '<input type="text" id="custom_provider_api_version" name="custom_provider_api_version" value="' . $api_version . '" class="regular-text mxchat-autosave-field" placeholder="2024-08-01-preview" autocomplete="off" data-lpignore="true" data-nonce="' . $nonce . '" />';
7233 - echo '<p class="description">' . esc_html__('Appended as ?api-version=... on the request URL. Required for Azure OpenAI; leave empty for non-Azure providers.', 'mxchat') . '</p>';
7234 - echo '</div>';
7235 -
7236 - // Extended-use checkboxes — opt-in routing of other dispatcher paths through the custom provider.
7237 - echo '<div class="mxchat-cp-row">';
7238 - echo '<label style="font-weight:600; display:block; margin:0 0 6px; color:#1d2327; font-size:13px;">' . esc_html__('Extended routing (opt-in)', 'mxchat') . '</label>';
7239 - echo '<label style="display:block; margin:0 0 6px; font-weight:400;"><input type="checkbox" id="custom_provider_for_embeddings" name="custom_provider_for_embeddings" value="on"' . checked($use_embed, true, false) . ' class="mxchat-autosave-field" data-nonce="' . $nonce . '" /> ' . esc_html__('Use custom provider for embeddings', 'mxchat') . '</label>';
7240 - echo '<label style="display:block; margin:0 0 0; font-weight:400;"><input type="checkbox" id="custom_provider_for_images" name="custom_provider_for_images" value="on"' . checked($use_images, true, false) . ' class="mxchat-autosave-field" data-nonce="' . $nonce . '" /> ' . esc_html__('Use custom provider for image generation', 'mxchat') . '</label>';
7241 - echo '<p class="description">' . esc_html__('When off, embeddings and image generation continue to use OpenAI (current behavior). Turn on only if your endpoint exposes OpenAI-compatible /embeddings or /images/generations routes (e.g. Ollama, vLLM, LocalAI).', 'mxchat') . '</p>';
7242 - echo '</div>';
7243 -
7244 - echo '<div class="mxchat-cp-row">';
7245 - echo '<label for="custom_provider_embedding_model">' . esc_html__('Custom Embedding Model', 'mxchat') . '</label>';
7246 - echo '<input type="text" id="custom_provider_embedding_model" name="custom_provider_embedding_model" value="' . $embed_model . '" class="regular-text mxchat-autosave-field" placeholder="nomic-embed-text" autocomplete="off" data-lpignore="true" data-nonce="' . $nonce . '" />';
7247 - echo '<p class="description">' . esc_html__('Only used when "Use custom provider for embeddings" is on. The embedding model name is separate from the chat model name above (e.g. Ollama embedding models: nomic-embed-text, mxbai-embed-large). Leave blank to fall back to the chat model name.', 'mxchat') . '</p>';
7248 - echo '</div>';
7249 -
7250 - echo '<div class="mxchat-cp-test">';
7251 - echo '<button type="button" class="button" id="mxchat-test-custom-provider" data-nonce="' . $test_nonce . '">' . esc_html__('Test Connection', 'mxchat') . '</button>';
7252 - echo '<span id="mxchat-test-custom-provider-result" class="mxchat-cp-test-status"></span>';
7253 - echo '</div>';
7254 -
7255 - echo '<script>(function(){
7256 - var btn = document.getElementById("mxchat-test-custom-provider");
7257 - if (!btn || btn._wired) { return; } btn._wired = true;
7258 - btn.addEventListener("click", function(){
7259 - var out = document.getElementById("mxchat-test-custom-provider-result");
7260 - out.textContent = "' . esc_js(__('Testing...', 'mxchat')) . '";
7261 - out.style.color = "#646970";
7262 - var fd = new FormData();
7263 - fd.append("action", "mxchat_test_custom_provider");
7264 - fd.append("_wpnonce", btn.getAttribute("data-nonce"));
7265 - fetch(ajaxurl, { method:"POST", credentials:"same-origin", body: fd })
7266 - .then(function(r){ return r.json(); })
7267 - .then(function(j){
7268 - if (j && j.success) {
7269 - out.textContent = "✓ " + (j.data && j.data.message ? j.data.message : "' . esc_js(__('OK', 'mxchat')) . '");
7270 - out.style.color = "#00a32a";
7271 - } else {
7272 - out.textContent = "⚠ " + (j && j.data && j.data.message ? j.data.message : "' . esc_js(__('Failed', 'mxchat')) . '");
7273 - out.style.color = "#d63638";
7274 - }
7275 - })
7276 - .catch(function(){
7277 - out.textContent = "⚠ ' . esc_js(__('Request failed', 'mxchat')) . '";
7278 - out.style.color = "#d63638";
7279 - });
7280 - });
7281 - })();</script>';
7282 -
7283 - echo '</div>';
7284 -}
7285 -
7286 5517 // Voyage API Key
7287 5518 public function voyage_api_key_callback() {
7288 5519 $apiKey = isset($this->options['voyage_api_key']) ? esc_attr($this->options['voyage_api_key']) : '';
7289 5520 $nonce = wp_create_nonce('mxchat_autosave_nonce');
@@ -7492,15 +5723,60 @@
7492 5723 }
7493 5724
7494 5725
7495 5726 public function mxchat_model_callback() {
7496 - // Catalog refactor (plan-d14e89): single source of truth lives in
7497 - // includes/class-mxchat-model-catalog.php. Dropdown groups are the
7498 - // provider labels; each group maps model_id => "Label" strings.
7499 - if (!class_exists('MxChat_Model_Catalog')) {
7500 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
7501 - }
7502 - $models = MxChat_Model_Catalog::settings_dropdown_groups();
5727 + // Define available models grouped by provider
5728 + $models = array(
5729 + esc_html__('OpenRouter (100+ Models)', 'mxchat') => array(
5730 + 'openrouter' => esc_html__('OpenRouter - Select after entering API key', 'mxchat'),
5731 + ),
5732 + esc_html__('Google Gemini Models', 'mxchat') => array(
5733 + 'gemini-3-pro-preview' => esc_html__('Gemini 3 Pro (Most Intelligent, Multimodal)', 'mxchat'),
5734 + 'gemini-3-flash-preview' => esc_html__('Gemini 3 Flash (Balanced Speed & Scale)', 'mxchat'),
5735 + 'gemini-2.5-pro' => esc_html__('Gemini 2.5 Pro (Advanced Thinking)', 'mxchat'),
5736 + 'gemini-2.5-flash' => esc_html__('Gemini 2.5 Flash (Best Price-Performance)', 'mxchat'),
5737 + 'gemini-2.5-flash-lite' => esc_html__('Gemini 2.5 Flash-Lite (Ultra Fast)', 'mxchat'),
5738 + 'gemini-2.0-flash' => esc_html__('Gemini 2.0 Flash (Deprecated Mar 2026)', 'mxchat'),
5739 + 'gemini-2.0-flash-lite' => esc_html__('Gemini 2.0 Flash-Lite (Deprecated Mar 2026)', 'mxchat'),
5740 + 'gemini-1.5-pro' => esc_html__('Gemini 1.5 Pro (Deprecated Sep 2025)', 'mxchat'),
5741 + 'gemini-1.5-flash' => esc_html__('Gemini 1.5 Flash (Deprecated Sep 2025)', 'mxchat'),
5742 + ),
5743 + esc_html__('X.AI Models', 'mxchat') => array(
5744 + 'grok-3-beta' => esc_html__('Grok-3 (Powerful)', 'mxchat'),
5745 + 'grok-3-fast-beta' => esc_html__('Grok-3 Fast (High Performance)', 'mxchat'),
5746 + 'grok-3-mini-beta' => esc_html__('Grok-3 Mini (Affordable)', 'mxchat'),
5747 + 'grok-3-mini-fast-beta' => esc_html__('Grok-3 Mini Fast (Quick Response)', 'mxchat'),
5748 + 'grok-2' => esc_html__('Grok 2', 'mxchat'),
5749 + 'grok-4-0709' => esc_html__('Grok 4 (Latest Flagship)', 'mxchat'),
5750 + 'grok-4-1-fast-reasoning' => esc_html__('Grok 4.1 Fast (Reasoning)', 'mxchat'),
5751 + 'grok-4-1-fast-non-reasoning' => esc_html__('Grok 4.1 Fast (Non-Reasoning)', 'mxchat'),
5752 + ),
5753 + esc_html__('DeepSeek Models', 'mxchat') => array(
5754 + 'deepseek-chat' => esc_html__('DeepSeek-V3', 'mxchat'),
5755 + ),
5756 + esc_html__('Claude Models', 'mxchat') => array(
5757 + 'claude-opus-4-6' => esc_html__('Claude Opus 4.6 (Most Capable - Recommended)', 'mxchat'),
5758 + 'claude-sonnet-4-6' => esc_html__('Claude Sonnet 4.6 (Latest Sonnet - Fast & Capable)', 'mxchat'),
5759 + 'claude-opus-4-5' => esc_html__('Claude Opus 4.5 (Highly Capable)', 'mxchat'),
5760 + 'claude-sonnet-4-5-20250929' => esc_html__('Claude Sonnet 4.5 (Best for Agents & Coding)', 'mxchat'),
5761 + 'claude-opus-4-1-20250805' => esc_html__('Claude Opus 4.1 (Exceptional for Complex Tasks)', 'mxchat'),
5762 + 'claude-haiku-4-5-20251001' => esc_html__('Claude Haiku 4.5 (Fastest & Most Intelligent)', 'mxchat'),
5763 + 'claude-opus-4-20250514' => esc_html__('Claude 4 Opus (Complex Tasks)', 'mxchat'),
5764 + 'claude-sonnet-4-20250514' => esc_html__('Claude 4 Sonnet (High Performance)', 'mxchat'),
5765 + ),
5766 + esc_html__('OpenAI Models', 'mxchat') => array(
5767 + 'gpt-5.4' => esc_html__('GPT-5.4 (Flagship Reasoning & Coding)', 'mxchat'),
5768 + 'gpt-5.4-mini' => esc_html__('GPT-5.4 Mini (Fast, 400K Context)', 'mxchat'),
5769 + 'gpt-5.4-nano' => esc_html__('GPT-5.4 Nano (Fastest & Cheapest)', 'mxchat'),
5770 + 'gpt-5.3-chat-latest' => esc_html__('GPT-5.3 Chat (Conversational)', 'mxchat'),
5771 + 'gpt-5.2' => esc_html__('GPT-5.2 (Best General-Purpose & Agentic Model)', 'mxchat'),
5772 + 'gpt-5.1-chat-latest' => esc_html__('GPT-5.1 Chat Latest (Recommended)', 'mxchat'),
5773 + 'gpt-5.1-2025-11-13' => esc_html__('GPT-5.1 (Flagship for Coding & Agentic Tasks)', 'mxchat'),
5774 + 'gpt-5' => esc_html__('GPT-5 (Flagship for Coding, Reasoning & Agents)', 'mxchat'),
5775 + 'gpt-5-mini' => esc_html__('GPT-5 Mini (Fast and Lightweight)', 'mxchat'),
5776 + 'gpt-5-nano' => esc_html__('GPT-5 Nano (Fastest & Cheapest for Summarization/Classification)', 'mxchat'),
5777 + ),
5778 + );
7503 5779
7504 5780 // Retrieve the currently selected model from saved options
7505 5781 $selected_model = isset($this->options['model']) ? esc_attr($this->options['model']) : 'gpt-5.1-chat-latest';
7506 5782
@@ -7609,15 +5885,15 @@
7609 5885 );
7610 5886 echo '<span class="slider"></span>';
7611 5887 echo '</label>';
7612 5888
7613 - // Test button — branded .mxch-btn with inline SVG (IDs preserved for AJAX binding)
7614 - echo '<div class="mxch-streaming-test-row">';
7615 - echo '<button type="button" id="mxchat-test-streaming-btn" class="mxch-btn mxch-btn-secondary">';
7616 - echo '<svg class="mxch-streaming-test-icon" xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true"><polyline points="22 12 18 12 15 21 9 3 6 12 2 12"/></svg>';
5889 + // Test button with better styling
5890 + echo '<div style="margin-top: 15px;">';
5891 + echo '<button type="button" id="mxchat-test-streaming-btn" class="button button-secondary">';
5892 + echo '<span class="dashicons dashicons-admin-tools" style="vertical-align: middle; margin-right: 5px;"></span>';
7617 5893 echo esc_html__('Test Streaming Compatibility', 'mxchat');
7618 5894 echo '</button>';
7619 - echo '<p id="mxchat-test-streaming-result" class="mxch-streaming-test-result"></p>';
5895 + echo '<p id="mxchat-test-streaming-result" style="margin-top:10px; font-weight: bold;"></p>';
7620 5896 echo '</div>';
7621 5897 }
7622 5898
7623 5899 // Web Search toggle callback
@@ -7628,37 +5904,23 @@
7628 5904
7629 5905 // Get current model to determine if we should show/enable the toggle
7630 5906 $current_model = isset($this->options['model']) ? $this->options['model'] : 'gpt-5.1-chat-latest';
7631 5907
7632 - // Models that DON'T support web search — OpenAI-docs-driven exception list.
7633 - // Keep hardcoded; the catalog can't infer "supports web search" per-model, so any
7634 - // future OpenAI model that lacks Responses-API web_search support is added here.
5908 + // Models that DON'T support web search (per OpenAI docs)
5909 + // gpt-5 with minimal reasoning is handled at API level, gpt-4.1-nano doesn't support it
7635 5910 $unsupported_models = array('gpt-4.1-nano');
7636 5911
7637 - // Web-search-capable chat-model allowlists, derived from the central model catalog
7638 - // (class-mxchat-model-catalog.php). When a new OpenAI/Gemini chat model is added there,
7639 - // the Web Search toggle picks it up automatically — no edit here.
7640 - // OpenAI grounds via the Responses-API web_search tool; Gemini grounds natively via the
7641 - // Google Search tool (plan 46b9ea wired the Gemini dispatch — every shipped Gemini chat
7642 - // model is 2.x/3.x and grounds, matching that path's empty opt-out list, so all catalog
7643 - // Gemini models are supported here).
7644 - if (!class_exists('MxChat_Model_Catalog')) {
7645 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
7646 - }
7647 - $chat_catalog = MxChat_Model_Catalog::chat_models();
7648 - $openai_models = (isset($chat_catalog['openai']['models']) && is_array($chat_catalog['openai']['models']))
7649 - ? array_keys($chat_catalog['openai']['models'])
7650 - : array();
7651 - $gemini_models = (isset($chat_catalog['gemini']['models']) && is_array($chat_catalog['gemini']['models']))
7652 - ? array_keys($chat_catalog['gemini']['models'])
7653 - : array();
5912 + // Check if current model is an OpenAI model that supports web search
5913 + $openai_models = array(
5914 + 'gpt-5.4', 'gpt-5.4-mini', 'gpt-5.4-nano', 'gpt-5.3-chat-latest',
5915 + 'gpt-5.2', 'gpt-5.1-chat-latest', 'gpt-5.1-2025-11-13', 'gpt-5', 'gpt-5-mini', 'gpt-5-nano'
5916 + );
7654 5917
7655 - $is_capable = in_array($current_model, $openai_models) || in_array($current_model, $gemini_models);
7656 - $is_supported = $is_capable && !in_array($current_model, $unsupported_models);
5918 + $is_openai = in_array($current_model, $openai_models);
5919 + $is_supported = $is_openai && !in_array($current_model, $unsupported_models);
7657 5920
7658 - // Wrapper div with data attributes for JS to show/hide. data-openai-models is kept for
7659 - // back-compat; data-gemini-models is the added second provider the JS now also honors.
7660 - echo '<div id="web-search-toggle-wrapper" data-openai-models="' . esc_attr(implode(',', $openai_models)) . '" data-gemini-models="' . esc_attr(implode(',', $gemini_models)) . '" data-unsupported-models="' . esc_attr(implode(',', $unsupported_models)) . '"' . (!$is_supported ? ' style="display:none;"' : '') . '>';
5921 + // Wrapper div with data attributes for JS to show/hide
5922 + echo '<div id="web-search-toggle-wrapper" data-openai-models="' . esc_attr(implode(',', $openai_models)) . '" data-unsupported-models="' . esc_attr(implode(',', $unsupported_models)) . '"' . (!$is_supported ? ' style="display:none;"' : '') . '>';
7661 5923
7662 5924 echo '<label class="toggle-switch">';
7663 5925 echo sprintf(
7664 5926 '<input type="checkbox" id="enable_web_search" name="enable_web_search" value="on" %s />',
@@ -7668,12 +5930,12 @@
7668 5930 echo '</label>';
7669 5931
7670 5932 echo '</div>';
7671 5933
7672 - // Message shown when a model that can't ground (Claude, Grok, DeepSeek, OpenRouter, etc.) is selected
5934 + // Message shown when non-OpenAI model is selected
7673 5935 echo '<p id="web-search-unavailable-message" class="description" style="color: #666;' . ($is_supported ? ' display:none;' : '') . '">';
7674 5936 echo '<span class="dashicons dashicons-info" style="font-size: 16px; vertical-align: middle; margin-right: 4px;"></span>';
7675 - echo esc_html__('Web search is only available for OpenAI and Gemini models.', 'mxchat');
5937 + echo esc_html__('Web search is only available for OpenAI models.', 'mxchat');
7676 5938 echo '</p>';
7677 5939 }
7678 5940
7679 5941 // AJAX handler to fetch OpenRouter models
@@ -7778,9 +6040,8 @@
7778 6040 } else {
7779 6041 echo '<span style="color: #d63638;">⚠ ' . esc_html__('No API key for Google Gemini detected. Please enter API key in API Keys tab.', 'mxchat') . '</span>';
7780 6042 }
7781 6043 echo '</p>';
7782 -
7783 6044 }
7784 6045
7785 6046
7786 6047 public function mxchat_top_bar_title_callback() {
@@ -7882,12 +6143,11 @@
7882 6143 $all_options = get_option('mxchat_options', []);
7883 6144 // Retrieve the saved intro message or use the default
7884 6145 $default_message = __('Hello! How can I assist you today?', 'mxchat');
7885 6146 $saved_message = isset($all_options['intro_message']) ? $all_options['intro_message'] : $default_message;
7886 - // Escape on output (esc_textarea) — neutralizes any payload already stored before the
7887 - // Wordfence Stored-XSS fix (CWE-79, plan-3f8158) and prevents </textarea> context-breakout.
6147 + // Output the textarea with the saved value without escaping HTML
7888 6148 ?>
7889 - <textarea id="intro_message" name="intro_message" rows="5" cols="50"><?php echo esc_textarea( $saved_message ); ?></textarea>
6149 + <textarea id="intro_message" name="intro_message" rows="5" cols="50"><?php echo $saved_message; ?></textarea>
7890 6150 <p class="description" style="margin-top: 8px;">
7891 6151 <?php esc_html_e('Use {visitor_name} to personalize greetings when lead capture is enabled.', 'mxchat'); ?><br>
7892 6152 <code style="font-size: 12px;"><?php esc_html_e('Example: Hello {visitor_name}! How can I help you today?', 'mxchat'); ?></code>
7893 6153 </p>
@@ -7990,8 +6250,20 @@
7990 6250 echo '</div>'; // End post-type-visibility-options
7991 6251 echo '</div>'; // End mxchat-autosave-section
7992 6252 }
7993 6253
6254 +public function mxchat_frontend_debugger_callback() {
6255 + $show_debugger = isset($this->options['show_frontend_debugger']) ? $this->options['show_frontend_debugger'] : 'on';
6256 + $checked = ($show_debugger === 'on') ? 'checked' : '';
6257 + echo '<label class="toggle-switch">';
6258 + echo sprintf(
6259 + '<input type="checkbox" id="show_frontend_debugger" name="show_frontend_debugger" value="on" %s />',
6260 + esc_attr($checked)
6261 + );
6262 + echo '<span class="slider"></span>';
6263 + echo '</label>';
6264 +}
6265 +
7994 6266 public function mxchat_contextual_awareness_callback() {
7995 6267 // Get value from options array, default to 'off'
7996 6268 $contextual_awareness = isset($this->options['contextual_awareness_toggle']) ? $this->options['contextual_awareness_toggle'] : 'off';
7997 6269 $checked = ($contextual_awareness === 'on') ? 'checked' : '';
@@ -8016,125 +6288,8 @@
8016 6288 echo '<span class="slider"></span>';
8017 6289 echo '</label>';
8018 6290 }
8019 6291
8020 -/**
8021 - * Toggle for the end-of-session satisfaction rating prompt (plan-a5b006).
8022 - * Default ON. The widget reads this through the localized object; the
8023 - * mxchat_satisfaction_rating_enabled filter still lets developers force
8024 - * the value site-wide.
8025 - *
8026 - * The 5 customization fields (idle/question/thanks/placeholder/saved) are
8027 - * rendered inline here inside a single wrapper div whose initial display
8028 - * is set server-side from the toggle value (plan-29caac). Mirrors the
8029 - * auto-display chatbot pattern at mxchat_append_to_body_callback — no
8030 - * DOMContentLoaded race because rows exist as direct children of this
8031 - * callback's output, and the wrapper's display: none is inline at render
8032 - * time so refresh shows the correct state with no flash.
8033 - */
8034 -public function mxchat_satisfaction_rating_toggle_callback() {
8035 - $options = $this->options;
8036 - $value = isset($options['satisfaction_rating_enabled']) ? $options['satisfaction_rating_enabled'] : 'off';
8037 - $checked = ($value === 'on') ? 'checked' : '';
8038 -
8039 - $idle = isset($options['satisfaction_rating_idle_seconds']) ? intval($options['satisfaction_rating_idle_seconds']) : 60;
8040 - $idle = max(5, min(600, $idle));
8041 - $question = isset($options['satisfaction_rating_question']) ? $options['satisfaction_rating_question'] : '';
8042 - $thanks = isset($options['satisfaction_rating_thanks']) ? $options['satisfaction_rating_thanks'] : '';
8043 - $placeholder = isset($options['satisfaction_rating_placeholder']) ? $options['satisfaction_rating_placeholder'] : '';
8044 - $saved = isset($options['satisfaction_rating_saved']) ? $options['satisfaction_rating_saved'] : '';
8045 -
8046 - echo '<div class="mxchat-autosave-section">';
8047 -
8048 - echo '<label class="toggle-switch">';
8049 - echo sprintf(
8050 - '<input type="checkbox" id="satisfaction_rating_enabled" name="satisfaction_rating_enabled" value="on" %s />',
8051 - esc_attr($checked)
8052 - );
8053 - echo '<span class="slider"></span>';
8054 - echo '</label>';
8055 -
8056 - ?>
8057 - <style>
8058 - .mxchat-sub-options-field { margin: 12px 0; }
8059 - .mxchat-sub-options-field label { display: inline-block; margin-bottom: 4px; }
8060 - #satisfaction-rating-sub-options h4 { margin: 16px 0 8px; }
8061 - </style>
8062 - <?php
8063 -
8064 - $display_style = ($value === 'on') ? '' : 'display: none;';
8065 - echo '<div id="satisfaction-rating-sub-options" class="mxchat-sub-options" style="' . esc_attr($display_style) . '">';
8066 -
8067 - echo '<h4>' . esc_html__('Customize the prompt (optional)', 'mxchat') . '</h4>';
8068 -
8069 - echo '<div class="mxchat-sub-options-field">';
8070 - echo '<label for="satisfaction_rating_idle_seconds"><strong>' . esc_html__('Idle Timeout', 'mxchat') . '</strong></label><br />';
8071 - printf(
8072 - '<input type="number" id="satisfaction_rating_idle_seconds" name="satisfaction_rating_idle_seconds" value="%d" min="5" max="600" step="1" class="small-text" /> <span class="description">%s</span>',
8073 - (int) $idle,
8074 - esc_html__('seconds of user inactivity before the prompt appears (5-600)', 'mxchat')
8075 - );
8076 - echo '</div>';
8077 -
8078 - echo '<div class="mxchat-sub-options-field">';
8079 - echo '<label for="satisfaction_rating_question"><strong>' . esc_html__('Prompt Question', 'mxchat') . '</strong></label><br />';
8080 - printf(
8081 - '<input type="text" id="satisfaction_rating_question" name="satisfaction_rating_question" value="%s" maxlength="200" class="regular-text" placeholder="%s" />',
8082 - esc_attr($question),
8083 - esc_attr__('Was this helpful?', 'mxchat')
8084 - );
8085 - echo '<p class="description">' . esc_html__('Leave blank for the default. Shown above the thumbs up/down.', 'mxchat') . '</p>';
8086 - echo '</div>';
8087 -
8088 - echo '<div class="mxchat-sub-options-field">';
8089 - echo '<label for="satisfaction_rating_thanks"><strong>' . esc_html__('Thank-You Message', 'mxchat') . '</strong></label><br />';
8090 - printf(
8091 - '<input type="text" id="satisfaction_rating_thanks" name="satisfaction_rating_thanks" value="%s" maxlength="300" class="regular-text" placeholder="%s" />',
8092 - esc_attr($thanks),
8093 - esc_attr__('Thanks! Anything we should improve? (optional)', 'mxchat')
8094 - );
8095 - echo '<p class="description">' . esc_html__('Leave blank for the default. Shown after the user clicks a thumb.', 'mxchat') . '</p>';
8096 - echo '</div>';
8097 -
8098 - echo '<div class="mxchat-sub-options-field">';
8099 - echo '<label for="satisfaction_rating_placeholder"><strong>' . esc_html__('Feedback Placeholder', 'mxchat') . '</strong></label><br />';
8100 - printf(
8101 - '<input type="text" id="satisfaction_rating_placeholder" name="satisfaction_rating_placeholder" value="%s" maxlength="200" class="regular-text" placeholder="%s" />',
8102 - esc_attr($placeholder),
8103 - esc_attr__('Tell us what could be better…', 'mxchat')
8104 - );
8105 - echo '<p class="description">' . esc_html__('Leave blank for the default. Placeholder text inside the feedback textarea.', 'mxchat') . '</p>';
8106 - echo '</div>';
8107 -
8108 - echo '<div class="mxchat-sub-options-field">';
8109 - echo '<label for="satisfaction_rating_saved"><strong>' . esc_html__('Saved Confirmation', 'mxchat') . '</strong></label><br />';
8110 - printf(
8111 - '<input type="text" id="satisfaction_rating_saved" name="satisfaction_rating_saved" value="%s" maxlength="200" class="regular-text" placeholder="%s" />',
8112 - esc_attr($saved),
8113 - esc_attr__('Thanks for the feedback.', 'mxchat')
8114 - );
8115 - echo '<p class="description">' . esc_html__('Leave blank for the default. Shown after the feedback is sent.', 'mxchat') . '</p>';
8116 - echo '</div>';
8117 -
8118 - echo '</div>'; // #satisfaction-rating-sub-options
8119 - echo '</div>'; // .mxchat-autosave-section
8120 -
8121 - ?>
8122 - <script>
8123 - (function() {
8124 - document.addEventListener('DOMContentLoaded', function() {
8125 - var toggle = document.getElementById('satisfaction_rating_enabled');
8126 - var subOptions = document.getElementById('satisfaction-rating-sub-options');
8127 - if (!toggle || !subOptions) return;
8128 - toggle.addEventListener('change', function() {
8129 - subOptions.style.display = toggle.checked ? '' : 'none';
8130 - });
8131 - });
8132 - })();
8133 - </script>
8134 - <?php
8135 -}
8136 -
8137 6292 public function mxchat_privacy_toggle_callback() {
8138 6293 // Load from mxchat_options array
8139 6294 $options = get_option('mxchat_options', []);
8140 6295
@@ -8217,53 +6372,8 @@
8217 6372 echo '<span class="slider"></span>';
8218 6373 echo '</label>';
8219 6374 }
8220 6375
8221 -public function mxchat_print_button_toggle_callback() {
8222 - // Load from mxchat_options array
8223 - $options = get_option('mxchat_options', []);
8224 -
8225 - // Default ON — the option was previously unexposed and the button always showed.
8226 - $print_button_enabled = isset($options['print_button_enabled']) ? $options['print_button_enabled'] : 'on';
8227 - $checked = ($print_button_enabled === 'on') ? 'checked' : '';
8228 -
8229 - // Output the toggle switch
8230 - echo '<label class="toggle-switch">';
8231 - echo sprintf(
8232 - '<input type="checkbox" id="print_button_enabled" name="print_button_enabled" value="on" %s />',
8233 - esc_attr($checked)
8234 - );
8235 - echo '<span class="slider"></span>';
8236 - echo '</label>';
8237 -}
8238 -
8239 -public function mxchat_reset_chat_toggle_callback() {
8240 - // Load from mxchat_options array. plan ac2e81 — default OFF (new, opt-in).
8241 - $options = get_option('mxchat_options', []);
8242 - $reset_chat_enabled = isset($options['reset_chat_enabled']) ? $options['reset_chat_enabled'] : 'off';
8243 - $checked = ($reset_chat_enabled === 'on') ? 'checked' : '';
8244 -
8245 - echo '<label class="toggle-switch">';
8246 - echo sprintf(
8247 - '<input type="checkbox" id="reset_chat_enabled" name="reset_chat_enabled" value="on" %s />',
8248 - esc_attr($checked)
8249 - );
8250 - echo '<span class="slider"></span>';
8251 - echo '</label>';
8252 -}
8253 -
8254 -public function mxchat_reset_chat_label_callback() {
8255 - // Editable label for the "Start new chat" menu item. plan ac2e81.
8256 - $options = get_option('mxchat_options', []);
8257 - $reset_chat_label = isset($options['reset_chat_label']) ? $options['reset_chat_label'] : '';
8258 -
8259 - printf(
8260 - '<input type="text" id="reset_chat_label" name="reset_chat_label" value="%s" placeholder="%s" class="regular-text" />',
8261 - esc_attr($reset_chat_label),
8262 - esc_attr__('Start new chat', 'mxchat')
8263 - );
8264 -}
8265 -
8266 6376 public function mxchat_popular_question_1_callback() {
8267 6377 // Load the full plugin options array
8268 6378 $all_options = get_option('mxchat_options', []);
8269 6379
@@ -8795,35 +6905,14 @@
8795 6905 );
8796 6906 echo '</div>';
8797 6907 }
8798 6908
8799 -public function mxchat_max_input_length_callback() {
8800 - // Load from mxchat_options array (plan a3fae2 part C).
8801 - $options = get_option('mxchat_options', []);
8802 -
8803 - // 0 = unlimited (default — preserves current behavior, no cap).
8804 - $max_input_length = isset($options['max_input_length']) ? intval($options['max_input_length']) : 0;
8805 -
8806 - echo sprintf(
8807 - '<input type="number"
8808 - id="max_input_length"
8809 - name="max_input_length"
8810 - min="0"
8811 - max="100000"
8812 - step="1"
8813 - value="%s"
8814 - placeholder="0"
8815 - class="mxch-input mxch-input-sm" />',
8816 - esc_attr($max_input_length)
8817 - );
8818 -}
8819 -
8820 6909 public function mxchat_rag_sources_limit_callback() {
8821 6910 // Load from mxchat_options array
8822 6911 $options = get_option('mxchat_options', []);
8823 6912
8824 - // Get value from options array with default of 3
8825 - $rag_sources_limit = isset($options['rag_sources_limit']) ? intval($options['rag_sources_limit']) : 3;
6913 + // Get value from options array with default of 6
6914 + $rag_sources_limit = isset($options['rag_sources_limit']) ? intval($options['rag_sources_limit']) : 6;
8826 6915
8827 6916 echo '<div class="slider-container">';
8828 6917 echo sprintf(
8829 6918 '<input type="range"
@@ -8842,46 +6931,8 @@
8842 6931 );
8843 6932 echo '</div>';
8844 6933 }
8845 6934
8846 -public function mxchat_rag_chunks_limit_callback() {
8847 - // Load from mxchat_options array
8848 - $options = get_option('mxchat_options', []);
8849 -
8850 - // Get value from options array with default of 15
8851 - $rag_chunks_limit = isset($options['rag_chunks_limit']) ? intval($options['rag_chunks_limit']) : 15;
8852 -
8853 - echo '<div class="slider-container">';
8854 - echo sprintf(
8855 - '<input type="range"
8856 - id="rag_chunks_limit"
8857 - name="rag_chunks_limit"
8858 - min="8"
8859 - max="20"
8860 - step="1"
8861 - value="%s"
8862 - class="range-slider" />',
8863 - esc_attr($rag_chunks_limit)
8864 - );
8865 - echo sprintf(
8866 - '<span id="rag_chunks_limit_value" class="range-value">%s</span>',
8867 - esc_html($rag_chunks_limit)
8868 - );
8869 - echo '</div>';
8870 -}
8871 -
8872 -/**
8873 - * Add body class on the Onboarding wizard page so CSS-only chrome surgery
8874 - * (collapsing the WP admin sidebar) only applies on this page.
8875 - * Plan: plan-mxchat-20260527-905439.
8876 - */
8877 -public function mxchat_add_onboarding_body_class($classes) {
8878 - if (isset($_GET['page']) && $_GET['page'] === 'mxchat-onboarding') {
8879 - $classes .= ' mxchat-onboarding-focused';
8880 - }
8881 - return $classes;
8882 -}
8883 -
8884 6935 public function mxchat_enqueue_admin_assets() {
8885 6936 // Get plugin version
8886 6937 $version = MXCHAT_VERSION;
8887 6938
@@ -8921,13 +6972,8 @@
8921 6972 wp_enqueue_style('mxchat-content-selector-css', $plugin_url . 'css/content-selector.css', array(), $version);
8922 6973 wp_enqueue_script('mxchat-content-selector-js', $plugin_url . 'js/content-selector.js', array('jquery'), $version, true);
8923 6974 // Add the knowledge processing script (common script needed for WordPress dismiss functionality)
8924 6975 wp_enqueue_script('mxchat-knowledge-processing', $plugin_url . 'js/knowledge-processing.js', array('jquery', 'common'), $version, true);
8925 - // Per-entry "View indexed content" inspector (plan-d8cb4b) reuses the
8926 - // Testing tab's match-card / chunk-detail components, which are scoped
8927 - // under .mxch-testing-results. Load that stylesheet here so the inspector
8928 - // modal renders identically to the Testing tab.
8929 - wp_enqueue_style('mxchat-admin-testing-css', $plugin_url . 'css/admin-testing-tab.css', array('mxchat-admin-sidebar-css'), $version);
8930 6976 break;
8931 6977
8932 6978 case 'mxchat-transcripts':
8933 6979 // Load admin sidebar CSS first (shared styles for sidebar navigation)
@@ -8952,16 +6998,12 @@
8952 6998 'addNonce' => wp_create_nonce('mxchat_add_intent_nonce'),
8953 6999 'editNonce' => wp_create_nonce('mxchat_edit_intent'),
8954 7000 'deleteNonce' => wp_create_nonce('mxchat_delete_intent_nonce'),
8955 7001 'toggleNonce' => wp_create_nonce('mxchat_actions_nonce'),
8956 - 'addPhraseNonce' => wp_create_nonce('mxchat_add_phrase_nonce'),
8957 - 'deletePhraseNonce' => wp_create_nonce('mxchat_delete_phrase_nonce'),
8958 - 'getPhrasesNonce' => wp_create_nonce('mxchat_get_phrases_nonce'),
8959 - 'deleteLegacyNonce' => wp_create_nonce('mxchat_delete_legacy_nonce'),
8960 7002 'isActivated' => $is_activated,
8961 7003 'i18n' => array(
8962 - 'confirmDelete' => __('Are you sure you want to delete this trigger phrase?', 'mxchat'),
8963 - 'confirmBulkDelete' => __('Are you sure you want to delete the selected trigger phrases?', 'mxchat'),
7004 + 'confirmDelete' => __('Are you sure you want to delete this action?', 'mxchat'),
7005 + 'confirmBulkDelete' => __('Are you sure you want to delete the selected actions?', 'mxchat'),
8964 7006 'saving' => __('Saving...', 'mxchat'),
8965 7007 'saved' => __('Saved successfully!', 'mxchat'),
8966 7008 'error' => __('An error occurred. Please try again.', 'mxchat'),
8967 7009 'proRequired' => __('This feature requires MxChat Pro.', 'mxchat'),
@@ -8988,38 +7030,8 @@
8988 7030 wp_enqueue_style('mxchat-content-css', $plugin_url . 'css/admin-content.css', array('mxchat-admin-sidebar-css'), $version);
8989 7031 // Load content page JavaScript
8990 7032 wp_enqueue_script('mxchat-content-js', $plugin_url . 'js/mxchat-content.js', array('jquery'), $version, true);
8991 7033 break;
8992 -
8993 - case 'mxchat-api-access':
8994 - // Shared sidebar shell (CSS + JS for tab switching / mobile menu / copy buttons).
8995 - wp_enqueue_style('mxchat-admin-sidebar-css', $plugin_url . 'css/admin-sidebar.css', array(), $version);
8996 - wp_enqueue_script('mxchat-admin-sidebar-js', $plugin_url . 'js/admin-sidebar.js', array(), $version, true);
8997 - wp_localize_script('mxchat-admin-sidebar-js', 'MxChatAdminSidebarI18n', array(
8998 - 'copied' => __('Copied', 'mxchat'),
8999 - ));
9000 - break;
9001 -
9002 - case 'mxchat-max':
9003 - case 'mxchat-onboarding':
9004 - // Onboarding page — uses the shared admin shell PLUS the wizard
9005 - // overlay (plan-905439). admin-onboarding-wizard.css scopes the
9006 - // WP-chrome surgery to body.mxchat-onboarding-focused so it only
9007 - // applies on THIS page. The body class is added below via the
9008 - // admin_body_class filter.
9009 - wp_enqueue_style('mxchat-admin-sidebar-css', $plugin_url . 'css/admin-sidebar.css', array(), $version);
9010 - wp_enqueue_script('mxchat-admin-sidebar-js', $plugin_url . 'js/admin-sidebar.js', array(), $version, true);
9011 - wp_localize_script('mxchat-admin-sidebar-js', 'MxChatAdminSidebarI18n', array(
9012 - 'copied' => __('Copied', 'mxchat'),
9013 - ));
9014 - // admin-style.css provides the .mxchat-instructions-modal-* classes
9015 - // the new Behavior step's "View Sample Instructions" modal needs.
9016 - // Enqueued AFTER admin-sidebar.css but BEFORE the wizard overlay
9017 - // so the wizard's own rules win where they collide. plan-a2e4d6.
9018 - wp_enqueue_style('mxchat-admin-style-css', $plugin_url . 'css/admin-style.css', array('mxchat-admin-sidebar-css'), $version);
9019 - wp_enqueue_style('mxchat-admin-onboarding-wizard-css', $plugin_url . 'css/admin-onboarding-wizard.css', array('mxchat-admin-sidebar-css', 'mxchat-admin-style-css'), $version);
9020 - wp_enqueue_script('mxchat-admin-onboarding-wizard-js', $plugin_url . 'js/admin-onboarding-wizard.js', array(), $version, true);
9021 - break;
9022 7034 default:
9023 7035 wp_enqueue_script(
9024 7036 'mxchat-test-streaming-js',
9025 7037 $plugin_url . 'js/mxchat-test-streaming.js',
@@ -9032,77 +7044,8 @@
9032 7044 'ajax_url' => admin_url('admin-ajax.php'),
9033 7045 'nonce' => wp_create_nonce('mxchat_test_streaming_nonce'),
9034 7046 'settings_nonce' => wp_create_nonce('mxchat_save_setting_nonce')
9035 7047 ]);
9036 -
9037 - // Testing Tab: Load chatbot assets for the embedded testing chatbot
9038 - wp_enqueue_style('mxchat-chat-css', $plugin_url . 'css/chat-style.css', array(), $version);
9039 - wp_enqueue_style('mxchat-admin-testing-css', $plugin_url . 'css/admin-testing-tab.css', array('mxchat-admin-sidebar-css', 'mxchat-chat-css'), $version);
9040 -
9041 - wp_enqueue_script('mxchat-chat-js', $plugin_url . 'js/chat-script.js', array('jquery'), $version, true);
9042 - wp_enqueue_script('mxchat-admin-testing-js', $plugin_url . 'js/admin-testing-tab.js', array('jquery', 'mxchat-chat-js'), $version, true);
9043 -
9044 - // Allow add-ons to enqueue their public CSS/JS for the testing chatbot
9045 - do_action('mxchat_enqueue_testing_tab_assets');
9046 -
9047 - // Localize mxchatChat for the chatbot JS (same settings as frontend)
9048 - $options = get_option('mxchat_options', array());
9049 - $prompts_options = get_option('mxchat_prompts_options', array());
9050 - $theme_options = get_option('mxchat_theme_options', array());
9051 - $ai_theme_active = !empty($theme_options['active_ai_theme_css']);
9052 - $has_bot_theme_assignments = !empty($theme_options['bot_theme_assignments']);
9053 - $skip_inline_colors = $ai_theme_active || $has_bot_theme_assignments;
9054 -
9055 - wp_localize_script('mxchat-chat-js', 'mxchatChat', array(
9056 - 'ajax_url' => admin_url('admin-ajax.php'),
9057 - 'nonce' => wp_create_nonce('mxchat_chat_nonce'),
9058 - 'model' => isset($options['model']) ? $options['model'] : 'gpt-5.1-chat-latest',
9059 - 'enable_streaming_toggle' => isset($options['enable_streaming_toggle']) ? $options['enable_streaming_toggle'] : 'on',
9060 - 'contextual_awareness_toggle' => isset($options['contextual_awareness_toggle']) ? $options['contextual_awareness_toggle'] : 'off',
9061 - 'link_target_toggle' => $options['link_target_toggle'] ?? 'off',
9062 - 'rate_limit_message' => $options['rate_limit_message'] ?? 'Rate limit exceeded. Please try again later.',
9063 - 'complianz_toggle' => isset($options['complianz_toggle']) && $options['complianz_toggle'] === 'on',
9064 - 'user_message_bg_color' => $options['user_message_bg_color'] ?? '#fff',
9065 - 'user_message_font_color' => $options['user_message_font_color'] ?? '#212121',
9066 - 'bot_message_bg_color' => $options['bot_message_bg_color'] ?? '#212121',
9067 - 'bot_message_font_color' => $options['bot_message_font_color'] ?? '#fff',
9068 - 'top_bar_bg_color' => $options['top_bar_bg_color'] ?? '#212121',
9069 - 'send_button_font_color' => $options['send_button_font_color'] ?? '#212121',
9070 - 'close_button_color' => $options['close_button_color'] ?? '#fff',
9071 - 'chatbot_background_color' => $options['chatbot_background_color'] ?? '#212121',
9072 - 'chatbot_bg_color' => $options['chatbot_bg_color'] ?? '#fff',
9073 - 'icon_color' => $options['icon_color'] ?? '#fff',
9074 - 'chat_input_font_color' => $options['chat_input_font_color'] ?? '#212121',
9075 - 'chat_persistence_toggle' => 'off', // Always off for testing chatbot
9076 - 'appendWidgetToBody' => 'off',
9077 - 'live_agent_message_bg_color' => $options['live_agent_message_bg_color'] ?? '#ffffff',
9078 - 'live_agent_message_font_color' => $options['live_agent_message_font_color'] ?? '#333333',
9079 - 'chat_toolbar_toggle' => $options['chat_toolbar_toggle'] ?? 'off',
9080 - 'mode_indicator_bg_color' => $options['mode_indicator_bg_color'] ?? '#767676',
9081 - 'mode_indicator_font_color' => $options['mode_indicator_font_color'] ?? '#ffffff',
9082 - 'toolbar_icon_color' => $options['toolbar_icon_color'] ?? '#212121',
9083 - 'use_pinecone' => $prompts_options['mxchat_use_pinecone'] ?? '0',
9084 - 'email_collection_enabled' => 'off', // No email collection in testing
9085 - 'initial_email_state' => null,
9086 - 'skip_email_check' => true,
9087 - 'pinecone_enabled' => isset($prompts_options['mxchat_use_pinecone']) && $prompts_options['mxchat_use_pinecone'] === '1',
9088 - 'skip_inline_colors' => $skip_inline_colors,
9089 - 'bot_theme_assignments' => $theme_options['bot_theme_assignments'] ?? array()
9090 - ));
9091 -
9092 - // Localize testing tab script data
9093 - wp_localize_script('mxchat-admin-testing-js', 'mxchatAdminTestData', array(
9094 - 'ajaxUrl' => admin_url('admin-ajax.php'),
9095 - 'nonce' => wp_create_nonce('mxchat_test_nonce'),
9096 - 'isAdmin' => true,
9097 - 'testingEnabled' => true
9098 - ));
9099 -
9100 - // Add testing enabled flag for the chatbot to return debug data
9101 - add_action('admin_footer', function() {
9102 - echo '<script>window.mxchatTestingEnabled = true;</script>';
9103 - });
9104 -
9105 7048 break;
9106 7049 }
9107 7050 }
9108 7051 private function localize_admin_scripts($current_page) {
@@ -9117,12 +7060,8 @@
9117 7060 'export_nonce' => wp_create_nonce('mxchat_export_transcripts'),
9118 7061 'actions_nonce' => wp_create_nonce('mxchat_actions_nonce'),
9119 7062 'add_intent_nonce' => wp_create_nonce('mxchat_add_intent_nonce'),
9120 7063 'edit_intent_nonce' => wp_create_nonce('mxchat_edit_intent'),
9121 - 'add_phrase_nonce' => wp_create_nonce('mxchat_add_phrase_nonce'),
9122 - 'delete_phrase_nonce' => wp_create_nonce('mxchat_delete_phrase_nonce'),
9123 - 'get_phrases_nonce' => wp_create_nonce('mxchat_get_phrases_nonce'),
9124 - 'delete_legacy_nonce' => wp_create_nonce('mxchat_delete_legacy_nonce'),
9125 7064 'toggle_action_nonce' => wp_create_nonce('mxchat_actions_nonce'),
9126 7065 'fetch_openrouter_models_nonce' => wp_create_nonce('mxchat_fetch_openrouter_models'),
9127 7066 'is_activated' => $this->is_activated ? '1' : '0',
9128 7067 'status_refresh_interval' => 5000,
@@ -9132,16 +7071,8 @@
9132 7071
9133 7072 // Localize main admin script with base data
9134 7073 wp_localize_script('mxchat-admin-js', 'mxchatAdmin', $base_data);
9135 7074
9136 - // Canonical chat-model catalog for the modal picker grid
9137 - // (plan-d14e89). Adding a model in class-mxchat-model-catalog.php
9138 - // automatically appears here.
9139 - if (!class_exists('MxChat_Model_Catalog')) {
9140 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
9141 - }
9142 - wp_localize_script('mxchat-admin-js', 'mxchatChatModelCatalog', MxChat_Model_Catalog::js_picker_shape());
9143 -
9144 7075 // Page-specific localizations
9145 7076 $this->localize_page_specific_scripts($current_page);
9146 7077 }
9147 7078 private function localize_page_specific_scripts($current_page) {
@@ -9153,22 +7084,17 @@
9153 7084 'nonce' => wp_create_nonce('mxchat_status_nonce')
9154 7085 ));
9155 7086
9156 7087 // Content selector localization
9157 - $mxchat_options_for_selector = get_option('mxchat_options', array());
9158 - $acf_pdf_extract_default = !empty($mxchat_options_for_selector['acf_pdf_extract_default']);
9159 7088 wp_localize_script('mxchat-content-selector-js', 'mxchatSelector', array(
9160 7089 'ajaxurl' => admin_url('admin-ajax.php'),
9161 7090 'nonce' => wp_create_nonce('mxchat_content_selector_nonce'),
9162 - 'acfPdfExtractDefault' => $acf_pdf_extract_default ? 1 : 0,
9163 7091 'i18n' => array(
9164 7092 'searchPlaceholder' => __('Search posts and pages...', 'mxchat'),
9165 7093 'selectAll' => __('Select All', 'mxchat'),
9166 7094 'process' => __('Process Selected', 'mxchat'),
9167 7095 'cancel' => __('Cancel', 'mxchat'),
9168 - 'noResults' => __('No content found.', 'mxchat'),
9169 - 'extractingPdfs' => __('extracting %d PDF(s)...', 'mxchat'),
9170 - 'pdfExtractedSuffix' => __(' (%d PDF(s) extracted)', 'mxchat')
7096 + 'noResults' => __('No content found.', 'mxchat')
9171 7097 )
9172 7098 ));
9173 7099
9174 7100 wp_localize_script('mxchat-knowledge-processing', 'mxchatAdmin', array(
@@ -9309,13 +7235,8 @@
9309 7235 $new_input['rag_sources_limit'] = absint($input['rag_sources_limit']); // Ensure it's an integer
9310 7236 $new_input['rag_sources_limit'] = min(max($new_input['rag_sources_limit'], 3), 10); // Enforce range 3-10
9311 7237 }
9312 7238
9313 - if (isset($input['rag_chunks_limit'])) {
9314 - $new_input['rag_chunks_limit'] = absint($input['rag_chunks_limit']); // Ensure it's an integer
9315 - $new_input['rag_chunks_limit'] = min(max($new_input['rag_chunks_limit'], 8), 20); // Enforce range 8-20
9316 - }
9317 -
9318 7239 if (isset($input['xai_api_key'])) {
9319 7240 $new_input['xai_api_key'] = sanitize_text_field($input['xai_api_key']);
9320 7241 }
9321 7242
@@ -9398,48 +7319,16 @@
9398 7319 if (isset($input['contextual_awareness_toggle'])) {
9399 7320 $new_input['contextual_awareness_toggle'] = $input['contextual_awareness_toggle'] === 'on' ? 'on' : 'off';
9400 7321 }
9401 7322
7323 + if (isset($input['show_frontend_debugger'])) {
7324 + $new_input['show_frontend_debugger'] = $input['show_frontend_debugger'] === 'on' ? 'on' : 'off';
7325 +}
7326 +
9402 7327 if (isset($input['citation_links_toggle'])) {
9403 7328 $new_input['citation_links_toggle'] = $input['citation_links_toggle'] === 'on' ? 'on' : 'off';
9404 7329 }
9405 7330
9406 - // Satisfaction rating prompt — defaults ON when unchecked (so first save
9407 - // doesn't accidentally disable it). The form posts 'on' when checked;
9408 - // unchecked checkboxes don't post a value at all, so we infer 'off' only
9409 - // when the autosave/PHP request explicitly clears it via empty string.
9410 - if (array_key_exists('satisfaction_rating_enabled', $input)) {
9411 - $new_input['satisfaction_rating_enabled'] = $input['satisfaction_rating_enabled'] === 'on' ? 'on' : 'off';
9412 - }
9413 -
9414 - // Satisfaction rating customization (plan-141a12). Idle is clamped 5-600;
9415 - // the 4 text strings are sanitized + capped server-side. Blank values are
9416 - // preserved so the integrator falls back to translated defaults.
9417 - if (array_key_exists('satisfaction_rating_idle_seconds', $input)) {
9418 - $new_input['satisfaction_rating_idle_seconds'] = max(5, min(600, intval($input['satisfaction_rating_idle_seconds'])));
9419 - }
9420 -
9421 - // Max input length in characters (plan a3fae2 part C). 0 = unlimited (default,
9422 - // preserves current behavior). Clamp to a sane ceiling so a typo can't lock out
9423 - // all input. REQUIRED here — mxchat_sanitize() rebuilds the array from a whitelist,
9424 - // so without this isset-handler the key is stripped on the next save of ANY field
9425 - // (the 2c02ea global-rate-limit footgun).
9426 - if (array_key_exists('max_input_length', $input)) {
9427 - $new_input['max_input_length'] = max(0, min(100000, intval($input['max_input_length'])));
9428 - }
9429 - if (array_key_exists('satisfaction_rating_question', $input)) {
9430 - $new_input['satisfaction_rating_question'] = mb_substr(sanitize_text_field($input['satisfaction_rating_question']), 0, 200);
9431 - }
9432 - if (array_key_exists('satisfaction_rating_thanks', $input)) {
9433 - $new_input['satisfaction_rating_thanks'] = mb_substr(sanitize_text_field($input['satisfaction_rating_thanks']), 0, 300);
9434 - }
9435 - if (array_key_exists('satisfaction_rating_placeholder', $input)) {
9436 - $new_input['satisfaction_rating_placeholder'] = mb_substr(sanitize_text_field($input['satisfaction_rating_placeholder']), 0, 200);
9437 - }
9438 - if (array_key_exists('satisfaction_rating_saved', $input)) {
9439 - $new_input['satisfaction_rating_saved'] = mb_substr(sanitize_text_field($input['satisfaction_rating_saved']), 0, 200);
9440 - }
9441 -
9442 7331 if (isset($input['top_bar_title'])) {
9443 7332 $new_input['top_bar_title'] = sanitize_text_field($input['top_bar_title']);
9444 7333 }
9445 7334
@@ -9491,13 +7380,9 @@
9491 7380
9492 7381 // Sanitize limit
9493 7382 if (isset($settings['limit'])) {
9494 7383 $limit = sanitize_text_field($settings['limit']);
9495 - // Accept presets, 'unlimited', the '__custom__' sentinel, OR any positive
9496 - // integer (custom value) — mirrors the global branch (plan-2c02ea). Without
9497 - // the custom path the per-role custom input was dropped and reset to the role
9498 - // default on every save (plan-7e23e7).
9499 - if (in_array($limit, $allowed_limits, true) || $limit === '__custom__' || (ctype_digit($limit) && (int) $limit >= 1)) {
7384 + if (in_array($limit, $allowed_limits, true)) {
9500 7385 $new_input['rate_limits'][$role_id]['limit'] = $limit;
9501 7386 } else {
9502 7387 $new_input['rate_limits'][$role_id]['limit'] = ($role_id === 'logged_out') ? '10' : '100'; // Default
9503 7388 }
@@ -9502,13 +7387,8 @@
9502 7387 $new_input['rate_limits'][$role_id]['limit'] = ($role_id === 'logged_out') ? '10' : '100'; // Default
9503 7388 }
9504 7389 }
9505 7390
9506 - // Preserve the per-role custom value (mirrors the global branch's limit_custom).
9507 - if (isset($settings['limit_custom'])) {
9508 - $new_input['rate_limits'][$role_id]['limit_custom'] = preg_replace('/[^0-9]/', '', (string) $settings['limit_custom']);
9509 - }
9510 -
9511 7391 // Sanitize timeframe
9512 7392 if (isset($settings['timeframe'])) {
9513 7393 $timeframe = sanitize_text_field($settings['timeframe']);
9514 7394 if (in_array($timeframe, $allowed_timeframes, true)) {
@@ -9524,46 +7404,8 @@
9524 7404 }
9525 7405 }
9526 7406 }
9527 7407
9528 -// Handle the whole-chatbot global rate limit (plan-mxchat-20260603-2c02ea).
9529 -// Mirrors the per-role block above, adapted to the single global shape. Without
9530 -// this branch the whitelist-rebuild dropped rate_limits_global entirely on every
9531 -// save, so the global cap silently fell back to its 'unlimited' default.
9532 -// MUST accept arbitrary positive integers so the custom-value path (d55f65) is not regressed.
9533 -if (isset($input['rate_limits_global']) && is_array($input['rate_limits_global'])) {
9534 - $g = $input['rate_limits_global'];
9535 - $allowed_limits = array('1', '3', '5', '10', '15', '20', '50', '100', 'unlimited');
9536 - $allowed_timeframes = array('hourly', 'daily', 'weekly', 'monthly');
9537 - $global_out = array();
9538 -
9539 - if (isset($g['limit'])) {
9540 - $limit = sanitize_text_field($g['limit']);
9541 - // Accept presets, 'unlimited', the '__custom__' sentinel (resolved by the
9542 - // autosave handler / renderer), OR any positive integer (custom value).
9543 - if (in_array($limit, $allowed_limits, true) || $limit === '__custom__' || (ctype_digit($limit) && (int) $limit >= 1)) {
9544 - $global_out['limit'] = $limit;
9545 - } else {
9546 - $global_out['limit'] = 'unlimited';
9547 - }
9548 - }
9549 -
9550 - if (isset($g['limit_custom'])) {
9551 - $global_out['limit_custom'] = preg_replace('/[^0-9]/', '', (string) $g['limit_custom']);
9552 - }
9553 -
9554 - if (isset($g['timeframe'])) {
9555 - $timeframe = sanitize_text_field($g['timeframe']);
9556 - $global_out['timeframe'] = in_array($timeframe, $allowed_timeframes, true) ? $timeframe : 'daily';
9557 - }
9558 -
9559 - if (isset($g['message'])) {
9560 - $global_out['message'] = sanitize_textarea_field($g['message']);
9561 - }
9562 -
9563 - $new_input['rate_limits_global'] = $global_out;
9564 -}
9565 -
9566 7408 if (isset($input['pre_chat_message'])) {
9567 7409 $new_input['pre_chat_message'] = sanitize_textarea_field($input['pre_chat_message']);
9568 7410 }
9569 7411
@@ -9572,14 +7414,15 @@
9572 7414 }
9573 7415
9574 7416 // Add to your sanitize function
9575 7417 if (isset($input['embedding_model'])) {
9576 - // Catalog refactor (plan-d14e89): allowlist derived from the canonical
9577 - // catalog in includes/class-mxchat-model-catalog.php.
9578 - if (!class_exists('MxChat_Model_Catalog')) {
9579 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
9580 - }
9581 - $allowed_models = MxChat_Model_Catalog::embedding_model_ids();
7418 + $allowed_models = array(
7419 + 'text-embedding-ada-002',
7420 + 'text-embedding-3-small',
7421 + 'text-embedding-3-large',
7422 + 'voyage-3-large',
7423 + 'gemini-embedding-001'
7424 + );
9582 7425 if (in_array($input['embedding_model'], $allowed_models)) {
9583 7426 $new_input['embedding_model'] = sanitize_text_field($input['embedding_model']);
9584 7427 }
9585 7428 }
@@ -9587,12 +7430,46 @@
9587 7430 if (isset($input['model'])) {
9588 7431 if ($input['model'] === 'openrouter') {
9589 7432 $new_input['model'] = 'openrouter';
9590 7433 } else {
9591 - if (!class_exists('MxChat_Model_Catalog')) {
9592 - require_once plugin_dir_path(__FILE__) . 'class-mxchat-model-catalog.php';
9593 - }
9594 - $allowed_models = MxChat_Model_Catalog::chat_model_ids();
7434 + $allowed_models = array(
7435 + 'gemini-3-pro-preview',
7436 + 'gemini-3-flash-preview',
7437 + 'gemini-2.5-pro',
7438 + 'gemini-2.5-flash',
7439 + 'gemini-2.5-flash-lite',
7440 + 'gemini-2.0-flash',
7441 + 'gemini-2.0-flash-lite',
7442 + 'gemini-1.5-pro',
7443 + 'gemini-1.5-flash',
7444 + 'grok-4-0709',
7445 + 'grok-4-1-fast-reasoning',
7446 + 'grok-4-1-fast-non-reasoning',
7447 + 'grok-3-beta',
7448 + 'grok-3-fast-beta',
7449 + 'grok-3-mini-beta',
7450 + 'grok-3-mini-fast-beta',
7451 + 'grok-2',
7452 + 'deepseek-chat',
7453 + 'claude-opus-4-6',
7454 + 'claude-sonnet-4-6',
7455 + 'claude-opus-4-5',
7456 + 'claude-sonnet-4-5-20250929',
7457 + 'claude-opus-4-1-20250805',
7458 + 'claude-haiku-4-5-20251001',
7459 + 'claude-opus-4-20250514',
7460 + 'claude-sonnet-4-20250514',
7461 + 'gpt-5.2',
7462 + 'gpt-5.1-chat-latest',
7463 + 'gpt-5.1-2025-11-13',
7464 + 'gpt-5',
7465 + 'gpt-5-mini',
7466 + 'gpt-5-nano',
7467 + 'gpt-5.4',
7468 + 'gpt-5.4-mini',
7469 + 'gpt-5.4-nano',
7470 + 'gpt-5.3-chat-latest',
7471 + );
9595 7472
9596 7473 if (in_array($input['model'], $allowed_models)) {
9597 7474 $new_input['model'] = sanitize_text_field($input['model']);
9598 7475 } else {
@@ -9615,37 +7492,10 @@
9615 7492 if (isset($input['openrouter_api_key'])) {
9616 7493 $new_input['openrouter_api_key'] = sanitize_text_field($input['openrouter_api_key']);
9617 7494 }
9618 7495
9619 - // Custom (OpenAI-compatible) Provider — Ollama, LM Studio, vLLM, Azure OpenAI, etc.
9620 - if (isset($input['custom_provider_base_url'])) {
9621 - $new_input['custom_provider_base_url'] = esc_url_raw(rtrim(trim((string) $input['custom_provider_base_url']), '/'));
9622 - }
9623 - if (isset($input['custom_provider_api_key'])) {
9624 - $new_input['custom_provider_api_key'] = sanitize_text_field($input['custom_provider_api_key']);
9625 - }
9626 - if (isset($input['custom_provider_model'])) {
9627 - $new_input['custom_provider_model'] = sanitize_text_field($input['custom_provider_model']);
9628 - }
9629 - if (isset($input['custom_provider_auth_scheme'])) {
9630 - $scheme = sanitize_text_field($input['custom_provider_auth_scheme']);
9631 - $new_input['custom_provider_auth_scheme'] = in_array($scheme, array('bearer', 'api-key'), true) ? $scheme : 'bearer';
9632 - }
9633 - if (isset($input['custom_provider_for_embeddings'])) {
9634 - $new_input['custom_provider_for_embeddings'] = ($input['custom_provider_for_embeddings'] === 'on') ? 'on' : 'off';
9635 - }
9636 - if (isset($input['custom_provider_for_images'])) {
9637 - $new_input['custom_provider_for_images'] = ($input['custom_provider_for_images'] === 'on') ? 'on' : 'off';
9638 - }
9639 - if (isset($input['custom_provider_embedding_model'])) {
9640 - $new_input['custom_provider_embedding_model'] = sanitize_text_field($input['custom_provider_embedding_model']);
9641 - }
9642 - if (isset($input['custom_provider_api_version'])) {
9643 - $new_input['custom_provider_api_version'] = sanitize_text_field($input['custom_provider_api_version']);
9644 - }
9645 7496
9646 7497
9647 -
9648 7498 if (isset($input['woocommerce_consumer_key'])) {
9649 7499 $new_input['woocommerce_consumer_key'] = sanitize_text_field($input['woocommerce_consumer_key']);
9650 7500 }
9651 7501
@@ -9667,25 +7517,8 @@
9667 7517 if (isset($input['chat_persistence_toggle'])) {
9668 7518 $new_input['chat_persistence_toggle'] = $input['chat_persistence_toggle'] === 'on' ? 'on' : 'off';
9669 7519 }
9670 7520
9671 - // No else clause: an absent key stays absent, so the front-end default ('on') applies
9672 - // and the rebuild never strips a saved 'off' (autosave passes the full options array back through here).
9673 - if (isset($input['print_button_enabled'])) {
9674 - $new_input['print_button_enabled'] = $input['print_button_enabled'] === 'on' ? 'on' : 'off';
9675 - }
9676 -
9677 - // plan ac2e81 — "Start new chat" toggle (default OFF) + editable label.
9678 - // No else on the toggle: an absent key stays absent so the front-end '?? off'
9679 - // default applies, and the full-array autosave rebuild preserves a saved value.
9680 - if (isset($input['reset_chat_enabled'])) {
9681 - $new_input['reset_chat_enabled'] = $input['reset_chat_enabled'] === 'on' ? 'on' : 'off';
9682 - }
9683 -
9684 - if (isset($input['reset_chat_label'])) {
9685 - $new_input['reset_chat_label'] = sanitize_text_field($input['reset_chat_label']);
9686 - }
9687 -
9688 7521 if (isset($input['popular_question_1'])) {
9689 7522 $new_input['popular_question_1'] = sanitize_text_field($input['popular_question_1']);
9690 7523 }
9691 7524
@@ -9844,12 +7677,8 @@
9844 7677 }
9845 7678 if (isset($input['content_image_model'])) {
9846 7679 $new_input['content_image_model'] = sanitize_text_field($input['content_image_model']);
9847 7680 }
9848 - if (isset($input['content_image_quality'])) {
9849 - $q = sanitize_text_field($input['content_image_quality']);
9850 - $new_input['content_image_quality'] = in_array($q, array('auto', 'low', 'medium', 'high'), true) ? $q : 'auto';
9851 - }
9852 7681 if (isset($input['content_enable_images'])) {
9853 7682 $new_input['content_enable_images'] = ($input['content_enable_images'] === 'on') ? 'on' : 'off';
9854 7683 }
9855 7684 if (isset($input['content_use_placeholders'])) {
@@ -9860,11 +7689,8 @@
9860 7689 }
9861 7690 if (isset($input['content_tool_use'])) {
9862 7691 $new_input['content_tool_use'] = ($input['content_tool_use'] === 'on') ? 'on' : 'off';
9863 7692 }
9864 - if (isset($input['content_image_count'])) {
9865 - $new_input['content_image_count'] = (string) max(1, min(5, (int) $input['content_image_count']));
9866 - }
9867 7693
9868 7694 // SEO Optimize toggle fields
9869 7695 foreach (array('seo_optimize_meta_desc', 'seo_optimize_seo_title', 'seo_optimize_slug', 'seo_optimize_readability', 'seo_optimize_internal_links', 'seo_optimize_img_alt', 'seo_optimize_featured_img') as $seo_key) {
9870 7696 if (isset($input[$seo_key])) {
@@ -9874,9 +7700,9 @@
9874 7700
9875 7701 // Preserve content generator settings when saving from main settings page
9876 7702 // (where content fields are not in the form submission)
9877 7703 $existing = get_option('mxchat_options', array());
9878 - foreach (array('content_model', 'content_image_model', 'content_image_quality', 'content_image_count', 'content_enable_images', 'content_use_placeholders', 'content_internal_linking', 'content_tool_use', 'seo_optimize_meta_desc', 'seo_optimize_seo_title', 'seo_optimize_slug', 'seo_optimize_readability', 'seo_optimize_internal_links', 'seo_optimize_img_alt', 'seo_optimize_featured_img') as $key) {
7704 + foreach (array('content_model', 'content_image_model', 'content_enable_images', 'content_use_placeholders', 'content_internal_linking', 'content_tool_use', 'seo_optimize_meta_desc', 'seo_optimize_seo_title', 'seo_optimize_slug', 'seo_optimize_readability', 'seo_optimize_internal_links', 'seo_optimize_img_alt', 'seo_optimize_featured_img') as $key) {
9879 7705 if (!isset($new_input[$key]) && isset($existing[$key])) {
9880 7706 $new_input[$key] = $existing[$key];
9881 7707 }
9882 7708 }
@@ -10100,65 +7926,73 @@
10100 7926 //error_log('DEBUG: Permission check failed');
10101 7927 wp_die(__('You do not have sufficient permissions to delete all prompts.', 'mxchat'));
10102 7928 }
10103 7929
10104 - // Get bot_id and content type filter from POST data
7930 + // Get bot_id from POST data
10105 7931 $bot_id = isset($_POST['bot_id']) ? sanitize_text_field($_POST['bot_id']) : 'default';
10106 - $content_type_filter = isset($_POST['content_type_filter']) ? sanitize_text_field($_POST['content_type_filter']) : '';
10107 -
7932 + //error_log('DEBUG: Bot ID from POST: ' . $bot_id);
7933 +
10108 7934 $success = true;
10109 7935 $error_messages = array();
10110 -
7936 +
10111 7937 // Get bot-specific Pinecone configuration
10112 7938 $pinecone_manager = MxChat_Pinecone_Manager::get_instance();
10113 7939 $pinecone_options = $pinecone_manager->mxchat_get_bot_pinecone_options($bot_id);
10114 -
7940 +
7941 + //error_log('DEBUG: Pinecone options retrieved:');
7942 + //error_log(' - Use Pinecone: ' . ($pinecone_options['mxchat_use_pinecone'] ?? 'NOT SET'));
7943 + //error_log(' - API Key: ' . (empty($pinecone_options['mxchat_pinecone_api_key']) ? 'EMPTY' : 'SET'));
7944 + //error_log(' - Host: ' . ($pinecone_options['mxchat_pinecone_host'] ?? 'NOT SET'));
7945 +
10115 7946 $use_pinecone = ($pinecone_options['mxchat_use_pinecone'] ?? '0') === '1';
10116 -
7947 +
10117 7948 if ($use_pinecone && !empty($pinecone_options['mxchat_pinecone_api_key'])) {
10118 - // Delete from Pinecone (with optional content type filter)
10119 - $result = $pinecone_manager->mxchat_delete_all_from_pinecone($pinecone_options, $content_type_filter);
10120 -
7949 + //error_log('[MXCHAT-DELETE] Pinecone is enabled for bot ' . $bot_id . ' - deleting all from Pinecone');
7950 +
7951 + // Delete from bot-specific Pinecone index
7952 + $result = $pinecone_manager->mxchat_delete_all_from_pinecone($pinecone_options);
7953 +
7954 + //error_log('DEBUG: Delete all result: ' . ($result['success'] ? 'SUCCESS' : 'FAILED'));
10121 7955 if (!$result['success']) {
7956 + //error_log('DEBUG: Delete all error: ' . $result['message']);
7957 + }
7958 +
7959 + if (!$result['success']) {
10122 7960 $success = false;
10123 7961 $error_messages[] = $result['message'];
10124 7962 }
10125 -
7963 +
7964 + // No cache clearing needed since we removed caching
7965 +
10126 7966 } else {
7967 + //error_log('[MXCHAT-DELETE] Pinecone not enabled for bot ' . $bot_id . ' - deleting from WordPress database');
7968 +
10127 7969 // Delete from WordPress database
10128 7970 global $wpdb;
10129 7971 $table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
10130 -
10131 - // Build WHERE conditions
10132 - $where_clauses = array();
10133 - $where_values = array();
10134 -
10135 - // Bot filter
7972 +
7973 + // If multi-bot is active and we have a specific bot, delete only that bot's content
10136 7974 if ($bot_id !== 'default' && class_exists('MxChat_Multi_Bot_Manager')) {
10137 - $where_clauses[] = 'bot_id = %s';
10138 - $where_values[] = $bot_id;
10139 - }
10140 -
10141 - // Content type filter
10142 - if (!empty($content_type_filter)) {
10143 - $where_clauses[] = 'content_type = %s';
10144 - $where_values[] = $content_type_filter;
10145 - }
10146 -
10147 - if (!empty($where_clauses)) {
10148 - $where_sql = implode(' AND ', $where_clauses);
10149 - $result = $wpdb->query($wpdb->prepare("DELETE FROM {$table_name} WHERE {$where_sql}", $where_values));
7975 + $result = $wpdb->delete(
7976 + $table_name,
7977 + array('bot_id' => $bot_id),
7978 + array('%s')
7979 + );
10150 7980 } else {
10151 - // No filters — delete all
7981 + // Delete all content for default bot
10152 7982 $result = $wpdb->query("DELETE FROM {$table_name}");
10153 7983 }
10154 -
7984 +
10155 7985 if ($result === false) {
10156 7986 $success = false;
10157 7987 $error_messages[] = 'Failed to delete from WordPress database';
10158 7988 }
10159 7989 }
7990 +
7991 + // No cache clearing needed since we removed caching
10160 7992
7993 + //error_log('=== DELETE ALL DEBUG END ===');
7994 +
10161 7995 // Redirect back with a success message and bot_id
10162 7996 $redirect_url = add_query_arg(array(
10163 7997 'page' => 'mxchat-prompts',
10164 7998 'bot_id' => $bot_id,
@@ -10463,9 +8297,8 @@
10463 8297 if ($embedding_dimensions !== 1536) {
10464 8298 //error_log('[MXCHAT-EMBED] Warning: Unexpected Gemini embedding dimensions: ' . $embedding_dimensions);
10465 8299 }
10466 8300
10467 - MxChat_Utils::stamp_active_embedding_model($selected_model);
10468 8301 return $response_data['embedding']['values'];
10469 8302 } else {
10470 8303 //error_log('[MXCHAT-EMBED] Error: No embedding found in Gemini response');
10471 8304 //error_log('[MXCHAT-EMBED] Response structure: ' . wp_json_encode(array_keys($response_data)));
@@ -10491,9 +8324,8 @@
10491 8324 ($selected_model === 'voyage-3-large' && $embedding_dimensions !== 2048)) {
10492 8325 //error_log('[MXCHAT-EMBED] Warning: Unexpected embedding dimensions');
10493 8326 }
10494 8327
10495 - MxChat_Utils::stamp_active_embedding_model($selected_model);
10496 8328 return $response_data['data'][0]['embedding'];
10497 8329 } else {
10498 8330 //error_log('[MXCHAT-EMBED] Error: No embedding found in response');
10499 8331 //error_log('[MXCHAT-EMBED] Response structure: ' . wp_json_encode(array_keys($response_data)));