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 +154 -1287 3.2.2 → 3.1.4 View file →
@@ -54,14 +54,8 @@
54 54 add_action('admin_post_mxchat_add_intent', array($this, 'mxchat_handle_add_intent'));
55 55 add_action('admin_post_mxchat_delete_intent', array($this, 'mxchat_handle_delete_intent'));
56 56 add_action('admin_post_mxchat_edit_intent', array($this, 'mxchat_handle_edit_intent'));
57 57 add_action('wp_ajax_mxchat_export_transcripts', array($this, 'export_chat_transcripts'));
58 -
59 - // Leads tab (inside Transcripts)
60 - add_action('wp_ajax_mxchat_fetch_leads', array($this, 'mxchat_fetch_leads'));
61 - add_action('wp_ajax_mxchat_delete_leads', array($this, 'mxchat_delete_leads'));
62 - add_action('wp_ajax_mxchat_export_leads', array($this, 'mxchat_export_leads'));
63 -
64 58 add_action('admin_init', array($this, 'mxchat_transcripts_page_init'));
65 59 add_action('wp_ajax_dismiss_live_agent_notice', array($this, 'dismiss_live_agent_notice'));
66 60 add_action('wp_ajax_dismiss_theme_migration_notice', array($this, 'dismiss_theme_migration_notice'));
67 61 add_action('mxchat_cleanup_old_transcripts', array($this, 'cleanup_old_transcripts'));
@@ -85,12 +79,8 @@
85 79 add_action('wp_ajax_mxchat_bulk_delete_actions', array($this, 'mxchat_bulk_delete_actions'));
86 80 add_action('wp_ajax_mxchat_add_intent_ajax', array($this, 'mxchat_add_intent_ajax'));
87 81 add_action('wp_ajax_mxchat_edit_intent_ajax', array($this, 'mxchat_edit_intent_ajax'));
88 82 add_action('wp_ajax_mxchat_delete_intent_ajax', array($this, 'mxchat_delete_intent_ajax'));
89 - add_action('wp_ajax_mxchat_add_phrase', array($this, 'mxchat_add_phrase_ajax'));
90 - add_action('wp_ajax_mxchat_delete_phrase', array($this, 'mxchat_delete_phrase_ajax'));
91 - add_action('wp_ajax_mxchat_get_phrases', array($this, 'mxchat_get_phrases_ajax'));
92 - add_action('wp_ajax_mxchat_delete_legacy_phrases', array($this, 'mxchat_delete_legacy_phrases_ajax'));
93 83
94 84 // Slack test connection
95 85 add_action('wp_ajax_mxchat_test_slack_connection', array($this, 'mxchat_test_slack_connection'));
96 86
@@ -99,10 +89,13 @@
99 89 add_action('wp_ajax_mxchat_get_transcript_translation', array($this, 'mxchat_get_transcript_translation'));
100 90 }
101 91
102 92 private function is_license_active() {
93 + // Get the raw value without translation
103 94 $license_status = get_option('mxchat_license_status', 'inactive');
104 - 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'));
105 98 }
106 99
107 100 private function initialize_default_options() {
108 101 $default_options = array(
@@ -151,8 +144,9 @@
151 144 'post_type_visibility_mode' => 'all', // 'all', 'include', 'exclude'
152 145 'post_type_visibility_list' => array(), // Array of post type slugs
153 146 'contextual_awareness_toggle' => 'off',
154 147 'citation_links_toggle' => 'on',
148 + 'show_frontend_debugger' => 'on',
155 149 'close_button_color' => esc_html__('#fff', 'mxchat'),
156 150 'chatbot_bg_color' => esc_html__('#fff', 'mxchat'),
157 151 'user_message_bg_color' => esc_html__('#fff', 'mxchat'),
158 152 'user_message_font_color' => esc_html__('#212121', 'mxchat'),
@@ -1510,763 +1504,9 @@
1510 1504 fclose($output);
1511 1505 wp_die();
1512 1506 }
1513 1507
1514 -// ============================================================================
1515 -// Leads tab (inside Transcripts)
1516 -//
1517 -// Leads are derived from existing data — no dedicated table. Primary source:
1518 -// wp_mxchat_chat_transcripts rows where user_email is populated. Secondary
1519 -// source: wp_options entries `mxchat_email_{session_id}` / `mxchat_name_{sid}`
1520 -// for "orphan" leads who submitted the pre-chat form but never chatted.
1521 -// ============================================================================
1522 -
1523 1508 /**
1524 - * Fetch leads: dedup-by-email rows, stats strip, and top pages in one call.
1525 - */
1526 -public function mxchat_fetch_leads() {
1527 - if (!current_user_can('manage_options')) {
1528 - wp_send_json_error(['message' => 'Insufficient permissions']);
1529 - wp_die();
1530 - }
1531 -
1532 - global $wpdb;
1533 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
1534 -
1535 - $page = isset($_POST['page']) ? max(1, absint($_POST['page'])) : 1;
1536 - $per_page = isset($_POST['per_page']) ? min(100, max(10, absint($_POST['per_page']))) : 25;
1537 - $offset = ($page - 1) * $per_page;
1538 - $search = isset($_POST['search']) ? sanitize_text_field(wp_unslash($_POST['search'])) : '';
1539 - $date_range = isset($_POST['date_range']) ? sanitize_key($_POST['date_range']) : 'all';
1540 - $status = isset($_POST['status']) ? sanitize_key($_POST['status']) : 'all';
1541 - $page_filter = isset($_POST['page_url']) ? esc_url_raw(wp_unslash($_POST['page_url'])) : '';
1542 - $sort = isset($_POST['sort']) ? sanitize_key($_POST['sort']) : 'last_seen';
1543 - $sort_dir = (isset($_POST['sort_dir']) && $_POST['sort_dir'] === 'asc') ? 'ASC' : 'DESC';
1544 -
1545 - $date_cutoff = self::mxchat_leads_date_cutoff($date_range);
1546 - $has_page_url_column = !empty($wpdb->get_results("SHOW COLUMNS FROM $table LIKE 'originating_page_url'"));
1547 -
1548 - // Base WHERE for transcripts leads.
1549 - $where_clauses = ["user_email IS NOT NULL", "user_email != ''"];
1550 - $where_params = [];
1551 -
1552 - if ($date_cutoff) {
1553 - $where_clauses[] = 'timestamp >= %s';
1554 - $where_params[] = $date_cutoff;
1555 - }
1556 - if ($page_filter && $has_page_url_column) {
1557 - $where_clauses[] = 'originating_page_url = %s';
1558 - $where_params[] = $page_filter;
1559 - }
1560 - if ($search !== '') {
1561 - $like = '%' . $wpdb->esc_like($search) . '%';
1562 - $where_clauses[] = '(user_email LIKE %s OR user_name LIKE %s)';
1563 - $where_params[] = $like;
1564 - $where_params[] = $like;
1565 - }
1566 - $where_sql = 'WHERE ' . implode(' AND ', $where_clauses);
1567 -
1568 - // Aggregate query grouped by email.
1569 - $select_sql = $has_page_url_column
1570 - ? "SELECT user_email, MAX(timestamp) AS last_seen, MIN(timestamp) AS first_seen,
1571 - COUNT(DISTINCT session_id) AS conversation_count"
1572 - : "SELECT user_email, MAX(timestamp) AS last_seen, MIN(timestamp) AS first_seen,
1573 - COUNT(DISTINCT session_id) AS conversation_count";
1574 -
1575 - $order_column = in_array($sort, ['last_seen', 'conversation_count', 'first_seen'], true) ? $sort : 'last_seen';
1576 - $group_order_limit = " GROUP BY user_email ORDER BY {$order_column} {$sort_dir} LIMIT %d OFFSET %d";
1577 -
1578 - $transcripts_sql = $wpdb->prepare(
1579 - "{$select_sql} FROM {$table} {$where_sql}{$group_order_limit}",
1580 - array_merge($where_params, [$per_page, $offset])
1581 - );
1582 - $transcript_rows = $wpdb->get_results($transcripts_sql);
1583 -
1584 - // Count of unique transcript-based leads under the same filters.
1585 - $count_sql = $wpdb->prepare(
1586 - "SELECT COUNT(DISTINCT user_email) FROM {$table} {$where_sql}",
1587 - $where_params
1588 - );
1589 - $transcripts_lead_count = (int) $wpdb->get_var($count_sql);
1590 -
1591 - // Hydrate each row: name, latest_session_id, top page.
1592 - $leads = [];
1593 - foreach ($transcript_rows as $row) {
1594 - $detail = $has_page_url_column
1595 - ? $wpdb->get_row($wpdb->prepare(
1596 - "SELECT session_id, user_name, originating_page_url, originating_page_title
1597 - FROM {$table} WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1598 - $row->user_email
1599 - ))
1600 - : $wpdb->get_row($wpdb->prepare(
1601 - "SELECT session_id, user_name FROM {$table}
1602 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1603 - $row->user_email
1604 - ));
1605 -
1606 - $leads[] = [
1607 - 'email' => $row->user_email,
1608 - 'name' => isset($detail->user_name) ? (string) $detail->user_name : '',
1609 - 'conversation_count' => (int) $row->conversation_count,
1610 - 'last_seen' => $row->last_seen,
1611 - 'last_seen_display' => self::mxchat_leads_format_relative($row->last_seen),
1612 - 'first_seen' => $row->first_seen,
1613 - 'latest_session_id' => isset($detail->session_id) ? $detail->session_id : '',
1614 - 'top_page_url' => isset($detail->originating_page_url) ? $detail->originating_page_url : '',
1615 - 'top_page_title' => isset($detail->originating_page_title) ? $detail->originating_page_title : '',
1616 - 'is_orphan' => false,
1617 - 'status' => 'active',
1618 - ];
1619 - }
1620 -
1621 - // Non-transcript lead sources. Built once here, then filtered/merged based on the
1622 - // status filter below. Deduplication priority when the same email appears in multiple
1623 - // sources: transcripts > chat_deleted > orphan.
1624 - $transcripts_emails_seen = array_flip(array_map(
1625 - function ($r) { return strtolower($r['email']); },
1626 - $leads
1627 - ));
1628 -
1629 - // Chat-deleted leads: had a conversation that an admin removed. Preserved via
1630 - // mxchat_lead_del_* options, with timestamps so they respect date filters.
1631 - $chat_deleted_leads_all = [];
1632 - if ($status === 'all' || $status === 'chat_deleted') {
1633 - $chat_deleted_leads_all = self::mxchat_collect_chat_deleted_leads($search, $date_cutoff);
1634 - // Dedup: drop any chat_deleted row whose email is already in the transcripts set.
1635 - $chat_deleted_leads_all = array_values(array_filter(
1636 - $chat_deleted_leads_all,
1637 - function ($row) use ($transcripts_emails_seen) {
1638 - return !isset($transcripts_emails_seen[strtolower($row['email'])]);
1639 - }
1640 - ));
1641 - foreach ($chat_deleted_leads_all as $row) {
1642 - $transcripts_emails_seen[strtolower($row['email'])] = true;
1643 - }
1644 - }
1645 -
1646 - // Orphans: pre-chat form captures with no conversation. No timestamp, so skipped
1647 - // when a date filter is active.
1648 - $orphan_leads_all = [];
1649 - if (($status === 'all' || $status === 'orphan') && !$date_cutoff && !$page_filter) {
1650 - $orphan_leads_all = self::mxchat_collect_orphan_leads($search);
1651 - $orphan_leads_all = array_values(array_filter(
1652 - $orphan_leads_all,
1653 - function ($row) use ($transcripts_emails_seen) {
1654 - return !isset($transcripts_emails_seen[strtolower($row['email'])]);
1655 - }
1656 - ));
1657 - }
1658 -
1659 - // Apply status filter to the transcripts-derived list.
1660 - if ($status === 'orphan' || $status === 'chat_deleted') {
1661 - $leads = [];
1662 - $transcripts_lead_count = 0;
1663 - }
1664 -
1665 - // Stitch the current page from the three buckets in priority order.
1666 - $total_count = $transcripts_lead_count + count($chat_deleted_leads_all) + count($orphan_leads_all);
1667 - $remaining_slots = $per_page - count($leads);
1668 -
1669 - if ($remaining_slots > 0 && !empty($chat_deleted_leads_all)) {
1670 - $start = max(0, ($page - 1) * $per_page - $transcripts_lead_count);
1671 - if ($start < count($chat_deleted_leads_all)) {
1672 - $leads = array_merge($leads, array_slice($chat_deleted_leads_all, $start, $remaining_slots));
1673 - $remaining_slots = $per_page - count($leads);
1674 - }
1675 - }
1676 -
1677 - if ($remaining_slots > 0 && !empty($orphan_leads_all)) {
1678 - $before = $transcripts_lead_count + count($chat_deleted_leads_all);
1679 - $start = max(0, ($page - 1) * $per_page - $before);
1680 - if ($start < count($orphan_leads_all)) {
1681 - $leads = array_merge($leads, array_slice($orphan_leads_all, $start, $remaining_slots));
1682 - }
1683 - }
1684 -
1685 - $total_pages = $per_page > 0 ? (int) ceil($total_count / $per_page) : 1;
1686 -
1687 - // Stats strip: always computed over full dataset, unaffected by filters.
1688 - $stats = self::mxchat_leads_stats($table, $has_page_url_column);
1689 -
1690 - // Top pages: top 5 by distinct emails captured.
1691 - $top_pages = [];
1692 - if ($has_page_url_column) {
1693 - $top_pages_rows = $wpdb->get_results(
1694 - "SELECT originating_page_url AS url,
1695 - MAX(originating_page_title) AS title,
1696 - COUNT(DISTINCT user_email) AS lead_count
1697 - FROM {$table}
1698 - WHERE user_email IS NOT NULL AND user_email != ''
1699 - AND originating_page_url IS NOT NULL AND originating_page_url != ''
1700 - GROUP BY originating_page_url
1701 - ORDER BY lead_count DESC, url ASC
1702 - LIMIT 5"
1703 - );
1704 - foreach ($top_pages_rows as $p) {
1705 - $top_pages[] = [
1706 - 'url' => $p->url,
1707 - 'title' => $p->title ?: $p->url,
1708 - 'lead_count' => (int) $p->lead_count,
1709 - ];
1710 - }
1711 - }
1712 -
1713 - wp_send_json([
1714 - 'success' => true,
1715 - 'leads' => $leads,
1716 - 'page' => $page,
1717 - 'per_page' => $per_page,
1718 - 'total_count' => $total_count,
1719 - 'total_pages' => $total_pages,
1720 - 'showing_start' => $total_count === 0 ? 0 : ($offset + 1),
1721 - 'showing_end' => min($offset + $per_page, $total_count),
1722 - 'stats' => $stats,
1723 - 'top_pages' => $top_pages,
1724 - ]);
1725 - wp_die();
1726 -}
1727 -
1728 -/**
1729 - * Delete one or more leads by email. Removes every transcripts row for that
1730 - * email and cleans up related wp_options (mxchat_email_{sid}, mxchat_name_{sid},
1731 - * mxchat_history_{sid}) and any orphan option entries matching the email.
1732 - */
1733 -public function mxchat_delete_leads() {
1734 - if (!current_user_can('manage_options')) {
1735 - wp_send_json_error(['message' => 'Insufficient permissions']);
1736 - wp_die();
1737 - }
1738 - check_ajax_referer('mxchat_delete_leads', 'security');
1739 -
1740 - $emails_raw = isset($_POST['emails']) ? (array) wp_unslash($_POST['emails']) : [];
1741 - $emails = [];
1742 - foreach ($emails_raw as $e) {
1743 - $clean = sanitize_email((string) $e);
1744 - if ($clean) {
1745 - $emails[] = $clean;
1746 - }
1747 - }
1748 - if (empty($emails)) {
1749 - wp_send_json_error(['message' => 'No emails provided']);
1750 - wp_die();
1751 - }
1752 -
1753 - $summary = self::mxchat_wipe_leads_by_email($emails);
1754 -
1755 - wp_send_json([
1756 - 'success' => true,
1757 - 'deleted_leads' => count($emails),
1758 - 'deleted_sessions' => $summary['deleted_sessions'],
1759 - 'deleted_rows' => $summary['deleted_rows'],
1760 - ]);
1761 - wp_die();
1762 -}
1763 -
1764 -/**
1765 - * Fully wipe one or more leads by email: every transcripts row, every related wp_options
1766 - * entry (history, pre-chat capture, chat_deleted preservation, agent name, translations).
1767 - *
1768 - * Shared between the Leads-tab Delete button and the transcript-delete opt-in checkbox.
1769 - * Input emails must already be sanitized with sanitize_email().
1770 - */
1771 -private static function mxchat_wipe_leads_by_email(array $emails) {
1772 - global $wpdb;
1773 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
1774 - $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
1775 - $has_translations = $wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table;
1776 -
1777 - $deleted_sessions = 0;
1778 - $deleted_rows = 0;
1779 - $emails_lc = array_map('strtolower', $emails);
1780 -
1781 - foreach ($emails as $email) {
1782 - $session_ids = $wpdb->get_col($wpdb->prepare(
1783 - "SELECT DISTINCT session_id FROM {$table} WHERE user_email = %s",
1784 - $email
1785 - ));
1786 -
1787 - $rows_removed = $wpdb->delete($table, ['user_email' => $email], ['%s']);
1788 - if ($rows_removed !== false) {
1789 - $deleted_rows += (int) $rows_removed;
1790 - }
1791 -
1792 - foreach ($session_ids as $sid) {
1793 - $deleted_sessions++;
1794 - wp_cache_delete('chat_session_' . $sid, 'mxchat_chat_sessions');
1795 - delete_option('mxchat_history_' . $sid);
1796 - delete_option('mxchat_email_' . $sid);
1797 - delete_option('mxchat_name_' . $sid);
1798 - delete_option('mxchat_agent_name_' . $sid);
1799 - delete_option('mxchat_lead_del_email_' . $sid);
1800 - delete_option('mxchat_lead_del_name_' . $sid);
1801 - delete_option('mxchat_lead_del_ts_' . $sid);
1802 - if ($has_translations) {
1803 - $wpdb->delete($translations_table, ['session_id' => $sid], ['%s']);
1804 - }
1805 - }
1806 - }
1807 -
1808 - // Clean up any lingering option entries (orphan pre-chat captures + chat_deleted
1809 - // preservations) whose stored value matches one of the emails being wiped.
1810 - $lingering = $wpdb->get_results(
1811 - "SELECT option_name, option_value FROM {$wpdb->options}
1812 - WHERE option_name LIKE 'mxchat_email_%' OR option_name LIKE 'mxchat_lead_del_email_%'"
1813 - );
1814 - foreach ($lingering as $opt) {
1815 - if (!in_array(strtolower(trim($opt->option_value)), $emails_lc, true)) {
1816 - continue;
1817 - }
1818 - if (strpos($opt->option_name, 'mxchat_lead_del_email_') === 0) {
1819 - $sid = substr($opt->option_name, strlen('mxchat_lead_del_email_'));
1820 - delete_option('mxchat_lead_del_email_' . $sid);
1821 - delete_option('mxchat_lead_del_name_' . $sid);
1822 - delete_option('mxchat_lead_del_ts_' . $sid);
1823 - } else {
1824 - $sid = substr($opt->option_name, strlen('mxchat_email_'));
1825 - delete_option('mxchat_email_' . $sid);
1826 - delete_option('mxchat_name_' . $sid);
1827 - }
1828 - }
1829 -
1830 - wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
1831 -
1832 - return [
1833 - 'deleted_sessions' => $deleted_sessions,
1834 - 'deleted_rows' => $deleted_rows,
1835 - ];
1836 -}
1837 -
1838 -/**
1839 - * Stream a leads CSV. scope=all exports every lead under current filters is not
1840 - * supported to keep semantics simple; caller either exports all leads or a
1841 - * specific set of selected emails.
1842 - */
1843 -public function mxchat_export_leads() {
1844 - if (!current_user_can('manage_options')) {
1845 - wp_die(esc_html__('You do not have sufficient permissions to access this page.', 'mxchat'));
1846 - }
1847 - check_ajax_referer('mxchat_export_leads', 'security');
1848 -
1849 - $scope = isset($_POST['scope']) ? sanitize_key($_POST['scope']) : 'all';
1850 - $fields_mode = isset($_POST['fields']) ? sanitize_key($_POST['fields']) : 'email_and_name';
1851 - $emails_in = isset($_POST['emails']) ? (array) wp_unslash($_POST['emails']) : [];
1852 -
1853 - $emails_in_clean = [];
1854 - foreach ($emails_in as $e) {
1855 - $clean = sanitize_email((string) $e);
1856 - if ($clean) {
1857 - $emails_in_clean[] = $clean;
1858 - }
1859 - }
1860 -
1861 - global $wpdb;
1862 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
1863 - $has_page_url_column = !empty($wpdb->get_results("SHOW COLUMNS FROM $table LIKE 'originating_page_url'"));
1864 -
1865 - // Collect leads from transcripts.
1866 - $transcripts_sql = "SELECT user_email AS email,
1867 - MAX(timestamp) AS last_seen,
1868 - COUNT(DISTINCT session_id) AS conversation_count
1869 - FROM {$table}
1870 - WHERE user_email IS NOT NULL AND user_email != ''";
1871 - $params = [];
1872 - if ($scope === 'selected' && !empty($emails_in_clean)) {
1873 - $placeholders = implode(',', array_fill(0, count($emails_in_clean), '%s'));
1874 - $transcripts_sql .= " AND user_email IN ({$placeholders})";
1875 - $params = $emails_in_clean;
1876 - }
1877 - $transcripts_sql .= " GROUP BY user_email ORDER BY last_seen DESC";
1878 -
1879 - $rows = !empty($params)
1880 - ? $wpdb->get_results($wpdb->prepare($transcripts_sql, $params))
1881 - : $wpdb->get_results($transcripts_sql);
1882 -
1883 - // Hydrate each row with name + top page.
1884 - $export_rows = [];
1885 - foreach ($rows as $row) {
1886 - $detail = $has_page_url_column
1887 - ? $wpdb->get_row($wpdb->prepare(
1888 - "SELECT user_name, originating_page_url FROM {$table}
1889 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1890 - $row->email
1891 - ))
1892 - : $wpdb->get_row($wpdb->prepare(
1893 - "SELECT user_name FROM {$table}
1894 - WHERE user_email = %s ORDER BY timestamp DESC LIMIT 1",
1895 - $row->email
1896 - ));
1897 - $export_rows[] = [
1898 - 'email' => $row->email,
1899 - 'name' => isset($detail->user_name) ? (string) $detail->user_name : '',
1900 - 'conversation_count' => (int) $row->conversation_count,
1901 - 'last_seen' => $row->last_seen,
1902 - 'top_page_url' => isset($detail->originating_page_url) ? $detail->originating_page_url : '',
1903 - ];
1904 - }
1905 -
1906 - // Include orphan + chat_deleted leads when exporting all.
1907 - if ($scope === 'all') {
1908 - $transcripts_emails_lc = array_flip(array_map(
1909 - function ($r) { return strtolower($r['email']); },
1910 - $export_rows
1911 - ));
1912 - foreach (self::mxchat_collect_chat_deleted_leads('') as $cd) {
1913 - if (isset($transcripts_emails_lc[strtolower($cd['email'])])) continue;
1914 - $transcripts_emails_lc[strtolower($cd['email'])] = true;
1915 - $export_rows[] = [
1916 - 'email' => $cd['email'],
1917 - 'name' => $cd['name'],
1918 - 'conversation_count' => 0,
1919 - 'last_seen' => $cd['last_seen'],
1920 - 'top_page_url' => '',
1921 - ];
1922 - }
1923 - foreach (self::mxchat_collect_orphan_leads('') as $orphan) {
1924 - if (isset($transcripts_emails_lc[strtolower($orphan['email'])])) continue;
1925 - $transcripts_emails_lc[strtolower($orphan['email'])] = true;
1926 - $export_rows[] = [
1927 - 'email' => $orphan['email'],
1928 - 'name' => $orphan['name'],
1929 - 'conversation_count' => 0,
1930 - 'last_seen' => '',
1931 - 'top_page_url' => '',
1932 - ];
1933 - }
1934 - }
1935 -
1936 - if (empty($export_rows)) {
1937 - wp_send_json_error(['message' => 'No leads to export.']);
1938 - wp_die();
1939 - }
1940 -
1941 - $filename = 'mxchat-leads-' . date('Y-m-d') . '.csv';
1942 - header('Content-Type: text/csv');
1943 - header('Content-Disposition: attachment; filename="' . $filename . '"');
1944 - header('Pragma: no-cache');
1945 - header('Expires: 0');
1946 -
1947 - $output = fopen('php://output', 'w');
1948 - fputs($output, "\xEF\xBB\xBF"); // UTF-8 BOM for Excel
1949 -
1950 - if ($fields_mode === 'email_only') {
1951 - fputcsv($output, ['Email']);
1952 - foreach ($export_rows as $r) {
1953 - fputcsv($output, [$r['email']]);
1954 - }
1955 - } else {
1956 - fputcsv($output, ['Email', 'Name', 'Conversations', 'Last seen', 'Top page']);
1957 - foreach ($export_rows as $r) {
1958 - fputcsv($output, [
1959 - $r['email'],
1960 - $r['name'],
1961 - $r['conversation_count'],
1962 - $r['last_seen'],
1963 - $r['top_page_url'],
1964 - ]);
1965 - }
1966 - }
1967 -
1968 - fclose($output);
1969 - wp_die();
1970 -}
1971 -
1972 -/**
1973 - * Stats strip payload (independent of filters).
1974 - */
1975 -private static function mxchat_leads_stats($table, $has_page_url_column) {
1976 - global $wpdb;
1977 -
1978 - $total_transcripts_emails = (int) $wpdb->get_var(
1979 - "SELECT COUNT(DISTINCT user_email) FROM {$table}
1980 - WHERE user_email IS NOT NULL AND user_email != ''"
1981 - );
1982 -
1983 - $new_this_week = (int) $wpdb->get_var($wpdb->prepare(
1984 - "SELECT COUNT(*) FROM (
1985 - SELECT user_email FROM {$table}
1986 - WHERE user_email IS NOT NULL AND user_email != ''
1987 - GROUP BY user_email
1988 - HAVING MIN(timestamp) >= %s
1989 - ) AS new_leads",
1990 - gmdate('Y-m-d H:i:s', strtotime('-7 days'))
1991 - ));
1992 -
1993 - $total_convos = (int) $wpdb->get_var(
1994 - "SELECT COUNT(DISTINCT session_id) FROM {$table}
1995 - WHERE user_email IS NOT NULL AND user_email != ''"
1996 - );
1997 -
1998 - $orphan_count = count(self::mxchat_collect_orphan_leads(''));
1999 - $chat_deleted_count = self::mxchat_count_chat_deleted_leads();
2000 -
2001 - // Total leads = unique emails across all three sources (dedup priority: transcripts > chat_deleted > orphan
2002 - // is already enforced at collection time in mxchat_fetch_leads; stats re-apply it here).
2003 - $total_leads = $total_transcripts_emails + $chat_deleted_count + $orphan_count;
2004 -
2005 - $avg = $total_transcripts_emails > 0
2006 - ? round($total_convos / $total_transcripts_emails, 1)
2007 - : 0;
2008 -
2009 - // Orphan % reflects *true* orphans only (pre-chat dropoffs). Chat-deleted leads are
2010 - // excluded so the metric stays meaningful — admins shouldn't see their cleanups
2011 - // inflate this number.
2012 - $orphan_pct = $total_leads > 0
2013 - ? (int) round(($orphan_count / $total_leads) * 100)
2014 - : 0;
2015 -
2016 - return [
2017 - 'total_leads' => $total_leads,
2018 - 'new_this_week' => $new_this_week,
2019 - 'avg_convos' => $avg,
2020 - 'orphan_pct' => $orphan_pct,
2021 - 'orphan_count' => $orphan_count,
2022 - 'chat_deleted_count' => $chat_deleted_count,
2023 - ];
2024 -}
2025 -
2026 -/**
2027 - * Collect leads who had a conversation that an admin later deleted (preserved via
2028 - * mxchat_lead_del_* options). Returns rows tagged status='chat_deleted' with the
2029 - * original last-seen timestamp so they still sort and filter sensibly.
2030 - *
2031 - * @param string $search Optional email/name substring filter.
2032 - * @param string $date_cutoff Optional 'Y-m-d H:i:s' cutoff — only rows with last_ts >= cutoff.
2033 - * @return array
2034 - */
2035 -private static function mxchat_collect_chat_deleted_leads($search = '', $date_cutoff = '') {
2036 - global $wpdb;
2037 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2038 -
2039 - $rows = $wpdb->get_results(
2040 - "SELECT option_name, option_value FROM {$wpdb->options}
2041 - WHERE option_name LIKE 'mxchat_lead_del_email_%'"
2042 - );
2043 - if (empty($rows)) {
2044 - return [];
2045 - }
2046 -
2047 - // Emails that currently have transcripts rows should not appear as chat_deleted —
2048 - // they've come back and chatted, so they're active leads again.
2049 - $emails_in_transcripts = array_map(
2050 - 'strtolower',
2051 - (array) $wpdb->get_col(
2052 - "SELECT DISTINCT user_email FROM {$table}
2053 - WHERE user_email IS NOT NULL AND user_email != ''"
2054 - )
2055 - );
2056 - $emails_in_transcripts = array_flip($emails_in_transcripts);
2057 -
2058 - $needle = strtolower(trim((string) $search));
2059 - $by_email = [];
2060 -
2061 - foreach ($rows as $opt) {
2062 - $email = sanitize_email(trim((string) $opt->option_value));
2063 - if (!$email) {
2064 - continue;
2065 - }
2066 - if (isset($emails_in_transcripts[strtolower($email)])) {
2067 - continue;
2068 - }
2069 - $sid = substr($opt->option_name, strlen('mxchat_lead_del_email_'));
2070 - if (!$sid) {
2071 - continue;
2072 - }
2073 - $name = (string) get_option('mxchat_lead_del_name_' . $sid, '');
2074 - $ts = (string) get_option('mxchat_lead_del_ts_' . $sid, '');
2075 -
2076 - if ($date_cutoff !== '' && ($ts === '' || $ts < $date_cutoff)) {
2077 - continue;
2078 - }
2079 - if ($needle !== '') {
2080 - $hay = strtolower($email . ' ' . $name);
2081 - if (strpos($hay, $needle) === false) {
2082 - continue;
2083 - }
2084 - }
2085 -
2086 - $key = strtolower($email);
2087 - if (!isset($by_email[$key]) || (isset($by_email[$key]['last_seen']) && $ts > $by_email[$key]['last_seen'])) {
2088 - $by_email[$key] = [
2089 - 'email' => $email,
2090 - 'name' => $name,
2091 - 'conversation_count' => 0,
2092 - 'last_seen' => $ts,
2093 - 'last_seen_display' => $ts ? self::mxchat_leads_format_relative($ts) : __('Chat deleted', 'mxchat'),
2094 - 'first_seen' => $ts,
2095 - 'latest_session_id' => '',
2096 - 'top_page_url' => '',
2097 - 'top_page_title' => '',
2098 - 'is_orphan' => false,
2099 - 'status' => 'chat_deleted',
2100 - ];
2101 - }
2102 - }
2103 -
2104 - // Newest chat_deleted first.
2105 - usort($by_email, function ($a, $b) {
2106 - return strcmp((string) $b['last_seen'], (string) $a['last_seen']);
2107 - });
2108 - return array_values($by_email);
2109 -}
2110 -
2111 -/**
2112 - * Count unique emails preserved as "chat deleted" (for the stats strip).
2113 - */
2114 -private static function mxchat_count_chat_deleted_leads() {
2115 - global $wpdb;
2116 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2117 -
2118 - $emails = $wpdb->get_col(
2119 - "SELECT DISTINCT option_value FROM {$wpdb->options}
2120 - WHERE option_name LIKE 'mxchat_lead_del_email_%'"
2121 - );
2122 - if (empty($emails)) {
2123 - return 0;
2124 - }
2125 -
2126 - $transcripts_emails = array_map(
2127 - 'strtolower',
2128 - (array) $wpdb->get_col(
2129 - "SELECT DISTINCT user_email FROM {$table}
2130 - WHERE user_email IS NOT NULL AND user_email != ''"
2131 - )
2132 - );
2133 - $transcripts_emails = array_flip($transcripts_emails);
2134 -
2135 - $count = 0;
2136 - $seen = [];
2137 - foreach ($emails as $raw) {
2138 - $email = strtolower(trim((string) $raw));
2139 - if (!$email || isset($seen[$email]) || isset($transcripts_emails[$email])) {
2140 - continue;
2141 - }
2142 - $seen[$email] = true;
2143 - $count++;
2144 - }
2145 - return $count;
2146 -}
2147 -
2148 -/**
2149 - * Find leads who submitted the pre-chat form but never produced a transcripts row.
2150 - * Returned rows have no conversation_count, no timestamp.
2151 - *
2152 - * @param string $search Optional email/name substring filter.
2153 - * @return array
2154 - */
2155 -private static function mxchat_collect_orphan_leads($search = '') {
2156 - global $wpdb;
2157 - $table = $wpdb->prefix . 'mxchat_chat_transcripts';
2158 -
2159 - $option_rows = $wpdb->get_results(
2160 - "SELECT option_name, option_value FROM {$wpdb->options}
2161 - WHERE option_name LIKE 'mxchat_email_%'"
2162 - );
2163 - if (empty($option_rows)) {
2164 - return [];
2165 - }
2166 -
2167 - // Collect all session_ids that have real transcripts rows so we can exclude them.
2168 - $session_ids_with_rows = $wpdb->get_col(
2169 - "SELECT DISTINCT session_id FROM {$table}
2170 - WHERE user_email IS NOT NULL AND user_email != ''"
2171 - );
2172 - $session_ids_with_rows = array_flip($session_ids_with_rows);
2173 -
2174 - // Seen emails in transcripts (so orphans only include truly never-chatted leads).
2175 - $emails_in_transcripts = array_map(
2176 - 'strtolower',
2177 - (array) $wpdb->get_col(
2178 - "SELECT DISTINCT user_email FROM {$table}
2179 - WHERE user_email IS NOT NULL AND user_email != ''"
2180 - )
2181 - );
2182 - $emails_in_transcripts = array_flip($emails_in_transcripts);
2183 -
2184 - $orphans_by_email = [];
2185 - $needle = strtolower(trim((string) $search));
2186 -
2187 - foreach ($option_rows as $opt) {
2188 - $email = sanitize_email(trim((string) $opt->option_value));
2189 - if (!$email) {
2190 - continue;
2191 - }
2192 - $sid = substr($opt->option_name, strlen('mxchat_email_'));
2193 - if (!$sid) {
2194 - continue;
2195 - }
2196 - // Exclude leads who have any transcripts rows (they appear in the main list).
2197 - if (isset($emails_in_transcripts[strtolower($email)])) {
2198 - continue;
2199 - }
2200 - if (isset($session_ids_with_rows[$sid])) {
2201 - continue;
2202 - }
2203 -
2204 - $name_option = get_option('mxchat_name_' . $sid, '');
2205 - $name = is_string($name_option) ? trim($name_option) : '';
2206 -
2207 - if ($needle !== '') {
2208 - $hay = strtolower($email . ' ' . $name);
2209 - if (strpos($hay, $needle) === false) {
2210 - continue;
2211 - }
2212 - }
2213 -
2214 - $key = strtolower($email);
2215 - if (!isset($orphans_by_email[$key])) {
2216 - $orphans_by_email[$key] = [
2217 - 'email' => $email,
2218 - 'name' => $name,
2219 - 'conversation_count' => 0,
2220 - 'last_seen' => '',
2221 - 'last_seen_display' => __('No conversation yet', 'mxchat'),
2222 - 'first_seen' => '',
2223 - 'latest_session_id' => '',
2224 - 'top_page_url' => '',
2225 - 'top_page_title' => '',
2226 - 'is_orphan' => true,
2227 - 'status' => 'orphan',
2228 - ];
2229 - }
2230 - }
2231 -
2232 - return array_values($orphans_by_email);
2233 -}
2234 -
2235 -/**
2236 - * Map a date_range key to a SQL-comparable cutoff string, or '' for all-time.
2237 - */
2238 -private static function mxchat_leads_date_cutoff($date_range) {
2239 - switch ($date_range) {
2240 - case 'today': return gmdate('Y-m-d H:i:s', strtotime('-24 hours'));
2241 - case '7d': return gmdate('Y-m-d H:i:s', strtotime('-7 days'));
2242 - case '30d': return gmdate('Y-m-d H:i:s', strtotime('-30 days'));
2243 - case '90d': return gmdate('Y-m-d H:i:s', strtotime('-90 days'));
2244 - case 'all':
2245 - default: return '';
2246 - }
2247 -}
2248 -
2249 -/**
2250 - * Turn a UTC timestamp into a short relative display like "2h ago" or "Apr 12".
2251 - */
2252 -private static function mxchat_leads_format_relative($timestamp) {
2253 - if (!$timestamp) {
2254 - return '';
2255 - }
2256 - $ts = strtotime($timestamp . ' UTC');
2257 - if (!$ts) {
2258 - return '';
2259 - }
2260 - $diff = time() - $ts;
2261 - if ($diff < 60) return __('just now', 'mxchat');
2262 - if ($diff < 3600) return floor($diff / 60) . __('m ago', 'mxchat');
2263 - if ($diff < 86400) return floor($diff / 3600) . __('h ago', 'mxchat');
2264 - if ($diff < 604800) return floor($diff / 86400) . __('d ago', 'mxchat');
2265 - return wp_date('M j', $ts);
2266 -}
2267 -
2268 -/**
2269 1509 * Handle translation of chat messages via AJAX
2270 1510 */
2271 1511 public function mxchat_translate_messages() {
2272 1512 if (!current_user_can('manage_options')) {
@@ -3485,103 +2725,53 @@
3485 2725 echo wp_json_encode(['error' => esc_html__('You do not have sufficient permissions.', 'mxchat')]);
3486 2726 wp_die();
3487 2727 }
3488 2728 check_ajax_referer('mxchat_delete_chat_history', 'security');
3489 -
3490 - if (!isset($_POST['delete_session_ids']) || !is_array($_POST['delete_session_ids'])) {
3491 - echo wp_json_encode(['error' => esc_html__('No chat sessions selected for deletion.', 'mxchat')]);
3492 - wp_die();
3493 - }
3494 -
3495 2729 global $wpdb;
3496 2730 $table_name = $wpdb->prefix . 'mxchat_chat_transcripts';
3497 - $translations_table = $wpdb->prefix . 'mxchat_transcript_translations';
3498 - $has_translations = $wpdb->get_var("SHOW TABLES LIKE '$translations_table'") === $translations_table;
3499 2731
3500 - // When true, any lead attached to these sessions is fully wiped (all their sessions,
3501 - // across the whole table). Default false: the chat rows go away but the lead is
3502 - // preserved as a separate "chat deleted" lead in the Leads tab.
3503 - $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';
3504 2735
3505 - $deleted_count = 0;
3506 - $preserved_as_deleted_leads = 0;
3507 - $emails_to_fully_wipe = [];
2736 + foreach ($_POST['delete_session_ids'] as $session_id) {
2737 + $session_id_sanitized = sanitize_text_field($session_id);
3508 2738
3509 - foreach ((array) $_POST['delete_session_ids'] as $session_id) {
3510 - $session_id_sanitized = sanitize_text_field($session_id);
3511 - if ($session_id_sanitized === '') {
3512 - continue;
3513 - }
2739 + // Clear relevant cache before deletion
2740 + $cache_key = 'chat_session_' . $session_id_sanitized;
2741 + wp_cache_delete($cache_key, 'mxchat_chat_sessions');
3514 2742
3515 - // Capture the lead info attached to this session *before* we delete the rows.
3516 - $lead_row = $wpdb->get_row($wpdb->prepare(
3517 - "SELECT user_email, user_name, MAX(timestamp) AS last_ts
3518 - FROM {$table_name}
3519 - WHERE session_id = %s AND user_email IS NOT NULL AND user_email != ''
3520 - GROUP BY user_email, user_name
3521 - ORDER BY last_ts DESC LIMIT 1",
3522 - $session_id_sanitized
3523 - ));
2743 + // Perform the deletion from the database table
2744 + $wpdb->delete($table_name, ['session_id' => $session_id_sanitized]);
3524 2745
3525 - wp_cache_delete('chat_session_' . $session_id_sanitized, 'mxchat_chat_sessions');
3526 - $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 + }
3527 2750
3528 - if ($has_translations) {
3529 - $wpdb->delete($translations_table, ['session_id' => $session_id_sanitized]);
3530 - }
2751 + // Delete the corresponding option entry from wp_options table
2752 + delete_option("mxchat_history_" . $session_id_sanitized);
3531 2753
3532 - delete_option('mxchat_history_' . $session_id_sanitized);
3533 - 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);
3534 2757
3535 - if ($lead_row && !empty($lead_row->user_email)) {
3536 - if ($also_delete_lead) {
3537 - // Full-wipe requested — queue the email so that all their sessions and
3538 - // related options get swept below. Also clear this session's pre-chat
3539 - // capture options (they're no longer meaningful).
3540 - $emails_to_fully_wipe[strtolower($lead_row->user_email)] = $lead_row->user_email;
3541 - delete_option('mxchat_email_' . $session_id_sanitized);
3542 - delete_option('mxchat_name_' . $session_id_sanitized);
3543 - } else {
3544 - // Preserve the lead in a "Chat deleted" state via distinct option keys so
3545 - // they stay out of the orphan bucket (orphan = pre-chat form dropoff).
3546 - update_option('mxchat_lead_del_email_' . $session_id_sanitized, $lead_row->user_email, false);
3547 - if (!empty($lead_row->user_name)) {
3548 - update_option('mxchat_lead_del_name_' . $session_id_sanitized, $lead_row->user_name, false);
3549 - }
3550 - if (!empty($lead_row->last_ts)) {
3551 - update_option('mxchat_lead_del_ts_' . $session_id_sanitized, $lead_row->last_ts, false);
3552 - }
3553 - // Clean up pre-chat capture options for this session — chat_deleted supersedes.
3554 - delete_option('mxchat_email_' . $session_id_sanitized);
3555 - delete_option('mxchat_name_' . $session_id_sanitized);
3556 - $preserved_as_deleted_leads++;
3557 - }
3558 - } else {
3559 - // No lead attached — nothing to preserve. Clean up any orphan options anyway.
3560 - delete_option('mxchat_email_' . $session_id_sanitized);
3561 - delete_option('mxchat_name_' . $session_id_sanitized);
2758 + $deleted_count++;
3562 2759 }
3563 2760
3564 - $deleted_count++;
3565 - }
2761 + // Optionally, clear a general cache if you have one
2762 + wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
3566 2763
3567 - // Opt-in full-lead wipe: sweep every remaining row + every option key (including
3568 - // chat_deleted preservation) for each affected email. Reuses the same internal
3569 - // helper as the Leads-tab Delete button for consistency.
3570 - if (!empty($emails_to_fully_wipe)) {
3571 - 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')]);
3572 2772 }
3573 2773
3574 - wp_cache_delete('all_chat_sessions', 'mxchat_chat_sessions');
3575 -
3576 - echo wp_json_encode([
3577 - 'success' => sprintf(
3578 - esc_html__('%d chat session(s) have been deleted.', 'mxchat'),
3579 - $deleted_count
3580 - ),
3581 - 'preserved_as_deleted_leads' => $preserved_as_deleted_leads,
3582 - 'leads_fully_wiped' => count($emails_to_fully_wipe),
3583 - ]);
3584 2774 wp_die();
3585 2775 }
3586 2776
3587 2777 /**
@@ -4661,25 +3851,8 @@
4661 3851
4662 3852 // Get available callbacks for labels/icons
4663 3853 $available_callbacks = $this->mxchat_get_available_callbacks();
4664 3854
4665 - // Prefetch individual phrase counts for all fetched actions
4666 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
4667 - $phrase_counts = array();
4668 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
4669 - $action_ids = wp_list_pluck($actions, 'id');
4670 - if (!empty($action_ids)) {
4671 - $id_placeholders = implode(',', array_fill(0, count($action_ids), '%d'));
4672 - $count_results = $wpdb->get_results($wpdb->prepare(
4673 - "SELECT intent_id, COUNT(*) as cnt FROM $phrases_table WHERE intent_id IN ($id_placeholders) GROUP BY intent_id",
4674 - $action_ids
4675 - ));
4676 - foreach ($count_results as $row) {
4677 - $phrase_counts[$row->intent_id] = intval($row->cnt);
4678 - }
4679 - }
4680 - }
4681 -
4682 3855 // Format actions for response
4683 3856 $formatted_actions = array();
4684 3857 foreach ($actions as $action) {
4685 3858 $callback_data = isset($available_callbacks[$action->callback_function])
@@ -4700,10 +3873,8 @@
4700 3873 'icon' => isset($callback_data['icon']) ? $callback_data['icon'] : 'admin-generic',
4701 3874 'threshold' => round($action->similarity_threshold * 100),
4702 3875 'enabled' => (bool) $action->enabled,
4703 3876 'enabled_bots' => $enabled_bots,
4704 - 'has_legacy_vector' => !empty($action->embedding_vector),
4705 - 'individual_phrase_count' => isset($phrase_counts[$action->id]) ? $phrase_counts[$action->id] : 0,
4706 3877 );
4707 3878 }
4708 3879
4709 3880 $total_pages = ceil($total_actions / $per_page);
@@ -4782,14 +3953,8 @@
4782 3953 if ($result === false) {
4783 3954 wp_send_json_error(__('Failed to delete actions', 'mxchat'));
4784 3955 }
4785 3956
4786 - // Also delete individual phrases for these intents
4787 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
4788 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
4789 - $wpdb->query($wpdb->prepare("DELETE FROM $phrases_table WHERE intent_id IN ($placeholders)", $action_ids));
4790 - }
4791 -
4792 3957 wp_send_json_success(array('deleted' => $result));
4793 3958 }
4794 3959
4795 3960 /**
@@ -4812,18 +3977,25 @@
4812 3977 $similarity_threshold = isset($_POST['similarity_threshold']) ? floatval($_POST['similarity_threshold']) / 100 : 0.85;
4813 3978 $enabled_bots = isset($_POST['enabled_bots']) ? array_map('sanitize_text_field', (array) $_POST['enabled_bots']) : array('default');
4814 3979
4815 3980 // Validate
4816 - // Check if using new individual phrases mode or legacy mode
4817 - $individual_phrases = isset($_POST['individual_phrases']) ? array_filter(array_map('sanitize_text_field', (array) $_POST['individual_phrases'])) : array();
4818 - $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 + }
4819 3984
4820 - // Validate required fields (phrases not required when using individual mode)
4821 - if (empty($intent_label) || empty($callback_function)) {
4822 - 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'));
4823 3989 }
4824 - if (!$use_individual && empty($phrases_input)) {
4825 - 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);
4826 3998 }
4827 3999
4828 4000 // Ensure default bot is included
4829 4001 if (!in_array('default', $enabled_bots)) {
@@ -4830,95 +4002,27 @@
4830 4002 $enabled_bots[] = 'default';
4831 4003 }
4832 4004 $enabled_bots_json = json_encode($enabled_bots);
4833 4005
4834 - if ($use_individual) {
4835 - // New mode: individual phrases each get their own vector
4836 - // Insert the intent row with empty legacy fields
4837 - $result = $wpdb->insert(
4838 - $table_name,
4839 - array(
4840 - 'intent_label' => $intent_label,
4841 - 'phrases' => '',
4842 - 'embedding_vector' => '',
4843 - 'similarity_threshold' => $similarity_threshold,
4844 - 'callback_function' => $callback_function,
4845 - 'enabled' => 1,
4846 - 'enabled_bots' => $enabled_bots_json,
4847 - )
4848 - );
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 + );
4849 4019
4850 - if ($result === false) {
4851 - wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
4852 - }
4020 + if ($result === false) {
4021 + wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
4022 + }
4853 4023
4854 - $intent_id = $wpdb->insert_id;
4855 -
4856 - // Insert each phrase individually with its own embedding
4857 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
4858 - $failed_phrases = array();
4859 - foreach ($individual_phrases as $phrase) {
4860 - $phrase = trim($phrase);
4861 - if (empty($phrase)) continue;
4862 -
4863 - $embedding_vector = $this->mxchat_generate_embedding($phrase);
4864 - if (is_wp_error($embedding_vector)) {
4865 - $failed_phrases[] = $phrase;
4866 - continue;
4867 - }
4868 -
4869 - $wpdb->insert(
4870 - $phrases_table,
4871 - array(
4872 - 'intent_id' => $intent_id,
4873 - 'phrase' => $phrase,
4874 - 'embedding_vector' => maybe_serialize($embedding_vector),
4875 - )
4876 - );
4877 - }
4878 -
4879 - $response = array('id' => $intent_id);
4880 - if (!empty($failed_phrases)) {
4881 - $response['failed_phrases'] = $failed_phrases;
4882 - }
4883 - wp_send_json_success($response);
4884 -
4885 - } else {
4886 - // Legacy mode: combine all phrases into one embedding (backwards compatible)
4887 - $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
4888 - if (empty($phrases_array)) {
4889 - wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
4890 - }
4891 -
4892 - // Generate embedding (combine phrases into single string for embedding)
4893 - $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
4894 - if (is_wp_error($embedding_vector)) {
4895 - // Fallback: store without embedding
4896 - $serialized_vector = null;
4897 - } else {
4898 - $serialized_vector = maybe_serialize($embedding_vector);
4899 - }
4900 -
4901 - // Insert
4902 - $result = $wpdb->insert(
4903 - $table_name,
4904 - array(
4905 - 'intent_label' => $intent_label,
4906 - 'phrases' => implode(', ', $phrases_array),
4907 - 'embedding_vector' => $serialized_vector,
4908 - 'similarity_threshold' => $similarity_threshold,
4909 - 'callback_function' => $callback_function,
4910 - 'enabled' => 1,
4911 - 'enabled_bots' => $enabled_bots_json,
4912 - )
4913 - );
4914 -
4915 - if ($result === false) {
4916 - wp_send_json_error(__('Failed to add action to database.', 'mxchat'));
4917 - }
4918 -
4919 - wp_send_json_success(array('id' => $wpdb->insert_id));
4920 - }
4024 + wp_send_json_success(array('id' => $wpdb->insert_id));
4921 4025 }
4922 4026
4923 4027 /**
4924 4028 * AJAX handler to edit an existing intent/action
@@ -4941,52 +4045,40 @@
4941 4045 $similarity_threshold = isset($_POST['similarity_threshold']) ? floatval($_POST['similarity_threshold']) / 100 : 0.85;
4942 4046 $enabled_bots = isset($_POST['enabled_bots']) ? array_map('sanitize_text_field', (array) $_POST['enabled_bots']) : array('default');
4943 4047
4944 4048 // Validate
4945 - if (!$intent_id || empty($intent_label)) {
4049 + if (!$intent_id || empty($intent_label) || empty($phrases_input)) {
4946 4050 wp_send_json_error(__('Please fill in all required fields.', 'mxchat'));
4947 4051 }
4948 4052
4949 - // Check if phrases are managed individually (empty phrases_input means individual mode)
4950 - $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 + }
4951 4058
4952 - if ($uses_individual_phrases) {
4953 - // 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;
4954 4064 $update_data = array(
4955 4065 'intent_label' => $intent_label,
4066 + 'phrases' => implode(', ', $phrases_array),
4956 4067 'similarity_threshold' => $similarity_threshold,
4957 4068 'callback_function' => $callback_function,
4958 4069 'enabled_bots' => json_encode($enabled_bots),
4959 4070 );
4960 4071 } else {
4961 - // Legacy mode: process phrases and regenerate embedding (backwards compatible for add-ons)
4962 - $phrases_array = array_filter(array_map('trim', preg_split('/[\n,]+/', $phrases_input)));
4963 - if (empty($phrases_array)) {
4964 - wp_send_json_error(__('Please provide at least one trigger phrase.', 'mxchat'));
4965 - }
4966 -
4967 - // Generate new embedding (combine phrases into single string for embedding)
4968 - $embedding_vector = $this->mxchat_generate_embedding(implode(' ', $phrases_array));
4969 - if (is_wp_error($embedding_vector)) {
4970 - // Keep existing embedding
4971 - $update_data = array(
4972 - 'intent_label' => $intent_label,
4973 - 'phrases' => implode(', ', $phrases_array),
4974 - 'similarity_threshold' => $similarity_threshold,
4975 - 'callback_function' => $callback_function,
4976 - 'enabled_bots' => json_encode($enabled_bots),
4977 - );
4978 - } else {
4979 - $serialized_vector = maybe_serialize($embedding_vector);
4980 - $update_data = array(
4981 - 'intent_label' => $intent_label,
4982 - 'phrases' => implode(', ', $phrases_array),
4983 - 'embedding_vector' => $serialized_vector,
4984 - 'similarity_threshold' => $similarity_threshold,
4985 - 'callback_function' => $callback_function,
4986 - 'enabled_bots' => json_encode($enabled_bots),
4987 - );
4988 - }
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 + );
4989 4081 }
4990 4082
4991 4083 // Ensure default bot is included
4992 4084 if (!in_array('default', $enabled_bots)) {
@@ -5033,154 +4125,13 @@
5033 4125 if ($result === false) {
5034 4126 wp_send_json_error(__('Failed to delete action', 'mxchat'));
5035 4127 }
5036 4128
5037 - // Also delete individual phrases for this intent
5038 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5039 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5040 - $wpdb->delete($phrases_table, array('intent_id' => $intent_id), array('%d'));
5041 - }
5042 -
5043 4129 wp_send_json_success(array('deleted' => true));
5044 4130 }
5045 4131
5046 -/**
5047 - * AJAX handler to add a single phrase with its own embedding to an intent
5048 - */
5049 -public function mxchat_add_phrase_ajax() {
5050 - check_ajax_referer('mxchat_add_phrase_nonce', 'security');
5051 4132
5052 - if (!current_user_can('manage_options')) {
5053 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5054 - }
5055 -
5056 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5057 - $phrase = isset($_POST['phrase']) ? sanitize_text_field($_POST['phrase']) : '';
5058 -
5059 - if (!$intent_id || empty($phrase)) {
5060 - wp_send_json_error(__('Please provide an intent ID and phrase.', 'mxchat'));
5061 - }
5062 -
5063 - // Verify the intent exists
5064 - global $wpdb;
5065 - $intents_table = $wpdb->prefix . 'mxchat_intents';
5066 - $intent = $wpdb->get_row($wpdb->prepare("SELECT id FROM $intents_table WHERE id = %d", $intent_id));
5067 - if (!$intent) {
5068 - wp_send_json_error(__('Action not found.', 'mxchat'));
5069 - }
5070 -
5071 - // Generate embedding for this single phrase
5072 - $embedding_vector = $this->mxchat_generate_embedding($phrase);
5073 - if (is_wp_error($embedding_vector)) {
5074 - wp_send_json_error(__('Failed to generate embedding: ', 'mxchat') . $embedding_vector->get_error_message());
5075 - }
5076 -
5077 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5078 - $result = $wpdb->insert(
5079 - $phrases_table,
5080 - array(
5081 - 'intent_id' => $intent_id,
5082 - 'phrase' => $phrase,
5083 - 'embedding_vector' => maybe_serialize($embedding_vector),
5084 - )
5085 - );
5086 -
5087 - if ($result === false) {
5088 - wp_send_json_error(__('Failed to add phrase.', 'mxchat'));
5089 - }
5090 -
5091 - wp_send_json_success(array('id' => $wpdb->insert_id, 'phrase' => $phrase));
5092 -}
5093 -
5094 4133 /**
5095 - * AJAX handler to delete a single phrase from wp_mxchat_intent_phrases
5096 - */
5097 -public function mxchat_delete_phrase_ajax() {
5098 - check_ajax_referer('mxchat_delete_phrase_nonce', 'security');
5099 -
5100 - if (!current_user_can('manage_options')) {
5101 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5102 - }
5103 -
5104 - $phrase_id = isset($_POST['phrase_id']) ? intval($_POST['phrase_id']) : 0;
5105 - if (!$phrase_id) {
5106 - wp_send_json_error(__('Invalid phrase ID.', 'mxchat'));
5107 - }
5108 -
5109 - global $wpdb;
5110 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5111 - $result = $wpdb->delete($phrases_table, array('id' => $phrase_id), array('%d'));
5112 -
5113 - if ($result === false) {
5114 - wp_send_json_error(__('Failed to delete phrase.', 'mxchat'));
5115 - }
5116 -
5117 - wp_send_json_success(array('deleted' => true));
5118 -}
5119 -
5120 -/**
5121 - * AJAX handler to fetch individual phrases for an intent
5122 - */
5123 -public function mxchat_get_phrases_ajax() {
5124 - check_ajax_referer('mxchat_get_phrases_nonce', 'security');
5125 -
5126 - if (!current_user_can('manage_options')) {
5127 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5128 - }
5129 -
5130 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5131 - if (!$intent_id) {
5132 - wp_send_json_error(__('Invalid intent ID.', 'mxchat'));
5133 - }
5134 -
5135 - global $wpdb;
5136 - $phrases_table = $wpdb->prefix . 'mxchat_intent_phrases';
5137 -
5138 - $phrases = array();
5139 - if ($wpdb->get_var("SHOW TABLES LIKE '$phrases_table'") === $phrases_table) {
5140 - $phrases = $wpdb->get_results($wpdb->prepare(
5141 - "SELECT id, phrase, created_at FROM $phrases_table WHERE intent_id = %d ORDER BY created_at ASC",
5142 - $intent_id
5143 - ));
5144 - }
5145 -
5146 - wp_send_json_success(array('phrases' => $phrases));
5147 -}
5148 -
5149 -/**
5150 - * AJAX handler to clear legacy phrases and embedding from the main intents table
5151 - */
5152 -public function mxchat_delete_legacy_phrases_ajax() {
5153 - check_ajax_referer('mxchat_delete_legacy_nonce', 'security');
5154 -
5155 - if (!current_user_can('manage_options')) {
5156 - wp_send_json_error(__('Unauthorized', 'mxchat'));
5157 - }
5158 -
5159 - $intent_id = isset($_POST['intent_id']) ? intval($_POST['intent_id']) : 0;
5160 - if (!$intent_id) {
5161 - wp_send_json_error(__('Invalid intent ID.', 'mxchat'));
5162 - }
5163 -
5164 - global $wpdb;
5165 - $table_name = $wpdb->prefix . 'mxchat_intents';
5166 -
5167 - $result = $wpdb->update(
5168 - $table_name,
5169 - array('phrases' => '', 'embedding_vector' => ''),
5170 - array('id' => $intent_id),
5171 - array('%s', '%s'),
5172 - array('%d')
5173 - );
5174 -
5175 - if ($result === false) {
5176 - wp_send_json_error(__('Failed to clear legacy phrases.', 'mxchat'));
5177 - }
5178 -
5179 - wp_send_json_success(array('cleared' => true));
5180 -}
5181 -
5182 -/**
5183 4134 * Enhanced get_available_callbacks function with form action exclusion
5184 4135 *
5185 4136 * @param bool $grouped Whether to return callbacks grouped by category
5186 4137 * @param bool $include_all Whether to include all potential actions (even if add-on not installed)
@@ -5668,8 +4619,17 @@
5668 4619 'mxchat-api-keys',
5669 4620 'mxchat_api_keys_section'
5670 4621 );
5671 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 +
5672 4632 // Similarity Threshold Slider
5673 4633 add_settings_field(
5674 4634 'similarity_threshold', // Field ID
5675 4635 esc_html__('Similarity Threshold', 'mxchat'), // Field title
@@ -5686,18 +4646,9 @@
5686 4646 'mxchat-chatbot', // Page
5687 4647 'mxchat_chatbot_section' // Section
5688 4648 );
5689 4649
5690 - // RAG Chunks Limit Slider
5691 4650 add_settings_field(
5692 - 'rag_chunks_limit', // Field ID
5693 - esc_html__('RAG Chunks Limit', 'mxchat'), // Field title
5694 - array($this, 'mxchat_rag_chunks_limit_callback'), // Callback function
5695 - 'mxchat-chatbot', // Page
5696 - 'mxchat_chatbot_section' // Section
5697 - );
5698 -
5699 - add_settings_field(
5700 4651 'append_to_body',
5701 4652 esc_html__('Auto-Display Chatbot', 'mxchat'),
5702 4653 array($this, 'mxchat_append_to_body_callback'),
5703 4654 'mxchat-chatbot',
@@ -7299,8 +6250,20 @@
7299 6250 echo '</div>'; // End post-type-visibility-options
7300 6251 echo '</div>'; // End mxchat-autosave-section
7301 6252 }
7302 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 +
7303 6266 public function mxchat_contextual_awareness_callback() {
7304 6267 // Get value from options array, default to 'off'
7305 6268 $contextual_awareness = isset($this->options['contextual_awareness_toggle']) ? $this->options['contextual_awareness_toggle'] : 'off';
7306 6269 $checked = ($contextual_awareness === 'on') ? 'checked' : '';
@@ -7946,10 +6909,10 @@
7946 6909 public function mxchat_rag_sources_limit_callback() {
7947 6910 // Load from mxchat_options array
7948 6911 $options = get_option('mxchat_options', []);
7949 6912
7950 - // Get value from options array with default of 3
7951 - $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;
7952 6915
7953 6916 echo '<div class="slider-container">';
7954 6917 echo sprintf(
7955 6918 '<input type="range"
@@ -7968,34 +6931,8 @@
7968 6931 );
7969 6932 echo '</div>';
7970 6933 }
7971 6934
7972 -public function mxchat_rag_chunks_limit_callback() {
7973 - // Load from mxchat_options array
7974 - $options = get_option('mxchat_options', []);
7975 -
7976 - // Get value from options array with default of 15
7977 - $rag_chunks_limit = isset($options['rag_chunks_limit']) ? intval($options['rag_chunks_limit']) : 15;
7978 -
7979 - echo '<div class="slider-container">';
7980 - echo sprintf(
7981 - '<input type="range"
7982 - id="rag_chunks_limit"
7983 - name="rag_chunks_limit"
7984 - min="8"
7985 - max="20"
7986 - step="1"
7987 - value="%s"
7988 - class="range-slider" />',
7989 - esc_attr($rag_chunks_limit)
7990 - );
7991 - echo sprintf(
7992 - '<span id="rag_chunks_limit_value" class="range-value">%s</span>',
7993 - esc_html($rag_chunks_limit)
7994 - );
7995 - echo '</div>';
7996 -}
7997 -
7998 6935 public function mxchat_enqueue_admin_assets() {
7999 6936 // Get plugin version
8000 6937 $version = MXCHAT_VERSION;
8001 6938
@@ -8061,12 +6998,8 @@
8061 6998 'addNonce' => wp_create_nonce('mxchat_add_intent_nonce'),
8062 6999 'editNonce' => wp_create_nonce('mxchat_edit_intent'),
8063 7000 'deleteNonce' => wp_create_nonce('mxchat_delete_intent_nonce'),
8064 7001 'toggleNonce' => wp_create_nonce('mxchat_actions_nonce'),
8065 - 'addPhraseNonce' => wp_create_nonce('mxchat_add_phrase_nonce'),
8066 - 'deletePhraseNonce' => wp_create_nonce('mxchat_delete_phrase_nonce'),
8067 - 'getPhrasesNonce' => wp_create_nonce('mxchat_get_phrases_nonce'),
8068 - 'deleteLegacyNonce' => wp_create_nonce('mxchat_delete_legacy_nonce'),
8069 7002 'isActivated' => $is_activated,
8070 7003 'i18n' => array(
8071 7004 'confirmDelete' => __('Are you sure you want to delete this action?', 'mxchat'),
8072 7005 'confirmBulkDelete' => __('Are you sure you want to delete the selected actions?', 'mxchat'),
@@ -8111,77 +7044,8 @@
8111 7044 'ajax_url' => admin_url('admin-ajax.php'),
8112 7045 'nonce' => wp_create_nonce('mxchat_test_streaming_nonce'),
8113 7046 'settings_nonce' => wp_create_nonce('mxchat_save_setting_nonce')
8114 7047 ]);
8115 -
8116 - // Testing Tab: Load chatbot assets for the embedded testing chatbot
8117 - wp_enqueue_style('mxchat-chat-css', $plugin_url . 'css/chat-style.css', array(), $version);
8118 - wp_enqueue_style('mxchat-admin-testing-css', $plugin_url . 'css/admin-testing-tab.css', array('mxchat-admin-sidebar-css', 'mxchat-chat-css'), $version);
8119 -
8120 - wp_enqueue_script('mxchat-chat-js', $plugin_url . 'js/chat-script.js', array('jquery'), $version, true);
8121 - wp_enqueue_script('mxchat-admin-testing-js', $plugin_url . 'js/admin-testing-tab.js', array('jquery', 'mxchat-chat-js'), $version, true);
8122 -
8123 - // Allow add-ons to enqueue their public CSS/JS for the testing chatbot
8124 - do_action('mxchat_enqueue_testing_tab_assets');
8125 -
8126 - // Localize mxchatChat for the chatbot JS (same settings as frontend)
8127 - $options = get_option('mxchat_options', array());
8128 - $prompts_options = get_option('mxchat_prompts_options', array());
8129 - $theme_options = get_option('mxchat_theme_options', array());
8130 - $ai_theme_active = !empty($theme_options['active_ai_theme_css']);
8131 - $has_bot_theme_assignments = !empty($theme_options['bot_theme_assignments']);
8132 - $skip_inline_colors = $ai_theme_active || $has_bot_theme_assignments;
8133 -
8134 - wp_localize_script('mxchat-chat-js', 'mxchatChat', array(
8135 - 'ajax_url' => admin_url('admin-ajax.php'),
8136 - 'nonce' => wp_create_nonce('mxchat_chat_nonce'),
8137 - 'model' => isset($options['model']) ? $options['model'] : 'gpt-5.1-chat-latest',
8138 - 'enable_streaming_toggle' => isset($options['enable_streaming_toggle']) ? $options['enable_streaming_toggle'] : 'on',
8139 - 'contextual_awareness_toggle' => isset($options['contextual_awareness_toggle']) ? $options['contextual_awareness_toggle'] : 'off',
8140 - 'link_target_toggle' => $options['link_target_toggle'] ?? 'off',
8141 - 'rate_limit_message' => $options['rate_limit_message'] ?? 'Rate limit exceeded. Please try again later.',
8142 - 'complianz_toggle' => isset($options['complianz_toggle']) && $options['complianz_toggle'] === 'on',
8143 - 'user_message_bg_color' => $options['user_message_bg_color'] ?? '#fff',
8144 - 'user_message_font_color' => $options['user_message_font_color'] ?? '#212121',
8145 - 'bot_message_bg_color' => $options['bot_message_bg_color'] ?? '#212121',
8146 - 'bot_message_font_color' => $options['bot_message_font_color'] ?? '#fff',
8147 - 'top_bar_bg_color' => $options['top_bar_bg_color'] ?? '#212121',
8148 - 'send_button_font_color' => $options['send_button_font_color'] ?? '#212121',
8149 - 'close_button_color' => $options['close_button_color'] ?? '#fff',
8150 - 'chatbot_background_color' => $options['chatbot_background_color'] ?? '#212121',
8151 - 'chatbot_bg_color' => $options['chatbot_bg_color'] ?? '#fff',
8152 - 'icon_color' => $options['icon_color'] ?? '#fff',
8153 - 'chat_input_font_color' => $options['chat_input_font_color'] ?? '#212121',
8154 - 'chat_persistence_toggle' => 'off', // Always off for testing chatbot
8155 - 'appendWidgetToBody' => 'off',
8156 - 'live_agent_message_bg_color' => $options['live_agent_message_bg_color'] ?? '#ffffff',
8157 - 'live_agent_message_font_color' => $options['live_agent_message_font_color'] ?? '#333333',
8158 - 'chat_toolbar_toggle' => $options['chat_toolbar_toggle'] ?? 'off',
8159 - 'mode_indicator_bg_color' => $options['mode_indicator_bg_color'] ?? '#767676',
8160 - 'mode_indicator_font_color' => $options['mode_indicator_font_color'] ?? '#ffffff',
8161 - 'toolbar_icon_color' => $options['toolbar_icon_color'] ?? '#212121',
8162 - 'use_pinecone' => $prompts_options['mxchat_use_pinecone'] ?? '0',
8163 - 'email_collection_enabled' => 'off', // No email collection in testing
8164 - 'initial_email_state' => null,
8165 - 'skip_email_check' => true,
8166 - 'pinecone_enabled' => isset($prompts_options['mxchat_use_pinecone']) && $prompts_options['mxchat_use_pinecone'] === '1',
8167 - 'skip_inline_colors' => $skip_inline_colors,
8168 - 'bot_theme_assignments' => $theme_options['bot_theme_assignments'] ?? array()
8169 - ));
8170 -
8171 - // Localize testing tab script data
8172 - wp_localize_script('mxchat-admin-testing-js', 'mxchatAdminTestData', array(
8173 - 'ajaxUrl' => admin_url('admin-ajax.php'),
8174 - 'nonce' => wp_create_nonce('mxchat_test_nonce'),
8175 - 'isAdmin' => true,
8176 - 'testingEnabled' => true
8177 - ));
8178 -
8179 - // Add testing enabled flag for the chatbot to return debug data
8180 - add_action('admin_footer', function() {
8181 - echo '<script>window.mxchatTestingEnabled = true;</script>';
8182 - });
8183 -
8184 7048 break;
8185 7049 }
8186 7050 }
8187 7051 private function localize_admin_scripts($current_page) {
@@ -8196,12 +7060,8 @@
8196 7060 'export_nonce' => wp_create_nonce('mxchat_export_transcripts'),
8197 7061 'actions_nonce' => wp_create_nonce('mxchat_actions_nonce'),
8198 7062 'add_intent_nonce' => wp_create_nonce('mxchat_add_intent_nonce'),
8199 7063 'edit_intent_nonce' => wp_create_nonce('mxchat_edit_intent'),
8200 - 'add_phrase_nonce' => wp_create_nonce('mxchat_add_phrase_nonce'),
8201 - 'delete_phrase_nonce' => wp_create_nonce('mxchat_delete_phrase_nonce'),
8202 - 'get_phrases_nonce' => wp_create_nonce('mxchat_get_phrases_nonce'),
8203 - 'delete_legacy_nonce' => wp_create_nonce('mxchat_delete_legacy_nonce'),
8204 7064 'toggle_action_nonce' => wp_create_nonce('mxchat_actions_nonce'),
8205 7065 'fetch_openrouter_models_nonce' => wp_create_nonce('mxchat_fetch_openrouter_models'),
8206 7066 'is_activated' => $this->is_activated ? '1' : '0',
8207 7067 'status_refresh_interval' => 5000,
@@ -8375,13 +7235,8 @@
8375 7235 $new_input['rag_sources_limit'] = absint($input['rag_sources_limit']); // Ensure it's an integer
8376 7236 $new_input['rag_sources_limit'] = min(max($new_input['rag_sources_limit'], 3), 10); // Enforce range 3-10
8377 7237 }
8378 7238
8379 - if (isset($input['rag_chunks_limit'])) {
8380 - $new_input['rag_chunks_limit'] = absint($input['rag_chunks_limit']); // Ensure it's an integer
8381 - $new_input['rag_chunks_limit'] = min(max($new_input['rag_chunks_limit'], 8), 20); // Enforce range 8-20
8382 - }
8383 -
8384 7239 if (isset($input['xai_api_key'])) {
8385 7240 $new_input['xai_api_key'] = sanitize_text_field($input['xai_api_key']);
8386 7241 }
8387 7242
@@ -8464,8 +7319,12 @@
8464 7319 if (isset($input['contextual_awareness_toggle'])) {
8465 7320 $new_input['contextual_awareness_toggle'] = $input['contextual_awareness_toggle'] === 'on' ? 'on' : 'off';
8466 7321 }
8467 7322
7323 + if (isset($input['show_frontend_debugger'])) {
7324 + $new_input['show_frontend_debugger'] = $input['show_frontend_debugger'] === 'on' ? 'on' : 'off';
7325 +}
7326 +
8468 7327 if (isset($input['citation_links_toggle'])) {
8469 7328 $new_input['citation_links_toggle'] = $input['citation_links_toggle'] === 'on' ? 'on' : 'off';
8470 7329 }
8471 7330
@@ -9067,65 +7926,73 @@
9067 7926 //error_log('DEBUG: Permission check failed');
9068 7927 wp_die(__('You do not have sufficient permissions to delete all prompts.', 'mxchat'));
9069 7928 }
9070 7929
9071 - // Get bot_id and content type filter from POST data
7930 + // Get bot_id from POST data
9072 7931 $bot_id = isset($_POST['bot_id']) ? sanitize_text_field($_POST['bot_id']) : 'default';
9073 - $content_type_filter = isset($_POST['content_type_filter']) ? sanitize_text_field($_POST['content_type_filter']) : '';
9074 -
7932 + //error_log('DEBUG: Bot ID from POST: ' . $bot_id);
7933 +
9075 7934 $success = true;
9076 7935 $error_messages = array();
9077 -
7936 +
9078 7937 // Get bot-specific Pinecone configuration
9079 7938 $pinecone_manager = MxChat_Pinecone_Manager::get_instance();
9080 7939 $pinecone_options = $pinecone_manager->mxchat_get_bot_pinecone_options($bot_id);
9081 -
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 +
9082 7946 $use_pinecone = ($pinecone_options['mxchat_use_pinecone'] ?? '0') === '1';
9083 -
7947 +
9084 7948 if ($use_pinecone && !empty($pinecone_options['mxchat_pinecone_api_key'])) {
9085 - // Delete from Pinecone (with optional content type filter)
9086 - $result = $pinecone_manager->mxchat_delete_all_from_pinecone($pinecone_options, $content_type_filter);
9087 -
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'));
9088 7955 if (!$result['success']) {
7956 + //error_log('DEBUG: Delete all error: ' . $result['message']);
7957 + }
7958 +
7959 + if (!$result['success']) {
9089 7960 $success = false;
9090 7961 $error_messages[] = $result['message'];
9091 7962 }
9092 -
7963 +
7964 + // No cache clearing needed since we removed caching
7965 +
9093 7966 } else {
7967 + //error_log('[MXCHAT-DELETE] Pinecone not enabled for bot ' . $bot_id . ' - deleting from WordPress database');
7968 +
9094 7969 // Delete from WordPress database
9095 7970 global $wpdb;
9096 7971 $table_name = $wpdb->prefix . 'mxchat_system_prompt_content';
9097 -
9098 - // Build WHERE conditions
9099 - $where_clauses = array();
9100 - $where_values = array();
9101 -
9102 - // Bot filter
7972 +
7973 + // If multi-bot is active and we have a specific bot, delete only that bot's content
9103 7974 if ($bot_id !== 'default' && class_exists('MxChat_Multi_Bot_Manager')) {
9104 - $where_clauses[] = 'bot_id = %s';
9105 - $where_values[] = $bot_id;
9106 - }
9107 -
9108 - // Content type filter
9109 - if (!empty($content_type_filter)) {
9110 - $where_clauses[] = 'content_type = %s';
9111 - $where_values[] = $content_type_filter;
9112 - }
9113 -
9114 - if (!empty($where_clauses)) {
9115 - $where_sql = implode(' AND ', $where_clauses);
9116 - $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 + );
9117 7980 } else {
9118 - // No filters — delete all
7981 + // Delete all content for default bot
9119 7982 $result = $wpdb->query("DELETE FROM {$table_name}");
9120 7983 }
9121 -
7984 +
9122 7985 if ($result === false) {
9123 7986 $success = false;
9124 7987 $error_messages[] = 'Failed to delete from WordPress database';
9125 7988 }
9126 7989 }
7990 +
7991 + // No cache clearing needed since we removed caching
9127 7992
7993 + //error_log('=== DELETE ALL DEBUG END ===');
7994 +
9128 7995 // Redirect back with a success message and bot_id
9129 7996 $redirect_url = add_query_arg(array(
9130 7997 'page' => 'mxchat-prompts',
9131 7998 'bot_id' => $bot_id,