array(
'label' => esc_html__( '📊 概覽', '2meet-data-optimizer' ),
'tabs' => array( 'dashboard', 'doctor', 'module-suggestions', 'conflicts', 'logs' ),
),
'wizards' => array(
'label' => esc_html__( '🧙 遷移精靈', '2meet-data-optimizer' ),
'tabs' => array( 'migration-wizard', 'post-migration-wizard', 'hpct-import' ),
),
'stress' => array(
'label' => esc_html__( '⚡ 壓力測試', '2meet-data-optimizer' ),
'tabs' => array( 'stress-test', 'post-stress-test', 'term-stress-test', 'comment-stress-test' ),
),
'config' => array(
'label' => esc_html__( '⚙️ 配置', '2meet-data-optimizer' ),
'tabs' => array( 'entity-bridge', 'zones', 'classifier', 'settings', 'rest-api', 'snapshots' ),
),
);
// Fallback bucket for any tab not explicitly listed (resilient to future tabs).
$grouped_slugs = array();
foreach ( $tab_groups as $g ) {
$grouped_slugs = array_merge( $grouped_slugs, $g['tabs'] );
}
$ungrouped = array_diff( array_keys( $tabs ), $grouped_slugs );
if ( ! empty( $ungrouped ) ) {
$tab_groups['other'] = array(
'label' => esc_html__( '其他', '2meet-data-optimizer' ),
'tabs' => array_values( $ungrouped ),
);
}
?>
get_stats();
$flags = TMDO_Feature_Flags::all();
$compat = TMDO_Compatibility::check();
$cache = TMDO_Cache_Layer::get_stats();
// ── Rate limit stats ──────────────────────────────────────────────
$rl_stats = get_option( 'wpdo_rl_stats', array() );
$rl_total = array_sum( $rl_stats );
arsort( $rl_stats );
$rl_top = array_slice( $rl_stats, 0, 10, true );
// ── Zone B / Zone D stats (60s transient — dashboard is read-heavy) ──
$cache_key = 'wpdo_dashboard_stats_v1';
$cached = get_transient( $cache_key );
if ( false === $cached ) {
$warm_table = TMDO_Zone_Warm::table();
$now_sql = TMDO_DB::now();
$warm_active = (int) $wpdb->get_var( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- table name from internal helper, no user input
$wpdb->prepare(
"SELECT COUNT(*) FROM `{$warm_table}` WHERE expires_at IS NULL OR expires_at > %s", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$now_sql
)
);
$warm_soon = (int) $wpdb->get_var( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$wpdb->prepare(
"SELECT COUNT(*) FROM `{$warm_table}` WHERE expires_at IS NOT NULL AND expires_at > %s AND expires_at < DATE_ADD(%s, INTERVAL 24 HOUR)", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$now_sql,
$now_sql
)
);
$top_views = $wpdb->get_results( // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
$wpdb->prepare(
"SELECT post_id, CAST(meta_value AS UNSIGNED) as views FROM `{$warm_table}` WHERE meta_key = %s AND (expires_at IS NULL OR expires_at > %s) ORDER BY views DESC LIMIT 10", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
TMDO_Listing_Stats::VIEW_KEY,
$now_sql
),
ARRAY_A
);
$cached = array(
'warm_active' => $warm_active,
'warm_soon' => $warm_soon,
'top_views' => $top_views,
'archive_stats' => TMDO_Zone_Archive::stats(),
);
set_transient( $cache_key, $cached, MINUTE_IN_SECONDS );
}
$warm_active = (int) $cached['warm_active'];
$warm_soon = (int) $cached['warm_soon'];
$top_views = $cached['top_views'];
$archive_stats = $cached['archive_stats'];
// v2.16.0: KPI hero metrics — read-only, transient-cached 5min.
$kpi = self::compute_dashboard_kpi();
?>
'background:#e0e0e0;color:#444',
'dual_write' => 'background:#d4edda;color:#155724',
'shadow_read' => 'background:#fff3cd;color:#856404',
'aeav_only' => 'background:#cce5ff;color:#004085',
);
?>
|
get_var( "SELECT COUNT(*) FROM {$wpdb->posts}" );
$postmeta_count = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->postmeta}" );
$ratio_num = $posts_count > 0 ? $postmeta_count / $posts_count : 0;
// 2) Latest benchmark speedup.
$bench_table = $wpdb->prefix . 'wpdo_benchmarks';
$row = $wpdb->get_row(
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- table from internal helper.
"SELECT module, native_ms, custom_ms, created_at FROM `{$bench_table}` WHERE custom_ms > 0 ORDER BY id DESC LIMIT 1",
ARRAY_A
);
$speedup_x = 0.0;
$speedup_label = '';
if ( $row && (float) $row['custom_ms'] > 0 ) {
$speedup_x = (float) $row['native_ms'] / (float) $row['custom_ms'];
if ( $speedup_x >= 1.0 ) {
$speedup_label = sprintf(
/* translators: 1: module, 2: timestamp */
__( '最近 %1$s @ %2$s', '2meet-data-optimizer' ),
(string) $row['module'],
mysql2date( get_option( 'date_format', 'Y-m-d' ), (string) $row['created_at'] )
);
}
}
// 3) Optimized field coverage from Schema Registry.
$fields_hot = 0;
$fields_cold = 0;
if ( class_exists( 'TMDO_Schema_Registry' ) ) {
$registry = TMDO_Schema_Registry::instance();
$hot_post_types = $registry->get_hot_post_types();
$cold_post_types = $registry->get_cold_post_types();
foreach ( $hot_post_types as $pt ) {
$fields_hot += count( $registry->get_hot_columns( $pt ) );
}
foreach ( $cold_post_types as $pt ) {
$fields_cold += count( $registry->get_cold_meta_keys( $pt ) );
}
}
// 4) Health score: starts at 100, deducts for recent errors / conflicts / mode mismatch.
$errors_24h = 0;
$err_table = $wpdb->prefix . 'wpdo_errors';
$err_exists = (bool) $wpdb->get_var(
$wpdb->prepare(
'SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = %s',
$err_table
)
);
if ( $err_exists ) {
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- table from internal helper, severity literals are static.
$err_sql = "SELECT COUNT(*) FROM `{$err_table}` WHERE severity IN ('error','critical') AND created_at >= %s";
$errors_24h = (int) $wpdb->get_var(
$wpdb->prepare( $err_sql, gmdate( 'Y-m-d H:i:s', time() - DAY_IN_SECONDS ) ) // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
);
}
$conflicts = 0;
if ( class_exists( 'TMDO_Conflict_Monitor' ) ) {
$summary = TMDO_Conflict_Monitor::get_summary();
$conflicts = (int) ( $summary['total'] ?? 0 );
}
$score = 100;
$score -= min( 30, $errors_24h * 3 );
$score -= min( 30, $conflicts * 5 );
$score = max( 0, min( 100, $score ) );
$health_class = $score >= 90 ? 'excellent' : ( $score >= 70 ? 'good' : ( $score >= 40 ? 'warn' : 'crit' ) );
$kpi = array(
'ratio_str' => $ratio_num > 0 ? number_format_i18n( $ratio_num, 2 ) : '0',
'posts' => $posts_count,
'postmeta' => $postmeta_count,
'speedup_x' => $speedup_x,
'speedup_label' => $speedup_label,
'fields_total' => $fields_hot + $fields_cold,
'fields_hot' => $fields_hot,
'fields_cold' => $fields_cold,
'health_score' => $score,
'health_class' => $health_class,
'errors_24h' => $errors_24h,
'conflicts' => $conflicts,
);
set_transient( 'wpdo_kpi_hero_v1', $kpi, 5 * MINUTE_IN_SECONDS );
return $kpi;
}
/**
* Entity Bridge tab: health cards + migration wizard for user/term/comment.
*/
private static function render_entity_bridge(): void {
$mode_order = array( 'disabled', 'dual_write', 'shadow_read', 'aeav_only' );
$mode_labels = array(
'disabled' => 'disabled',
'dual_write' => 'dual_write',
'shadow_read' => 'shadow_read',
'aeav_only' => 'aeav_only',
);
$mode_style = array(
'disabled' => 'background:#e0e0e0;color:#444',
'dual_write' => 'background:#d4edda;color:#155724',
'shadow_read' => 'background:#fff3cd;color:#856404',
'aeav_only' => 'background:#cce5ff;color:#004085',
);
$health_data = class_exists( 'TMDO_Entity_Health' ) ? TMDO_Entity_Health::get_all() : array();
// v2.11.0: post entity health is computed on-demand (post is not in
// TMDO_Entity_Health::MANAGED_TYPES yet — kept out to preserve user-side
// JS polling assumption of 3 types). Add post to the render loop only.
if ( class_exists( 'TMDO_Entity_Health' ) ) {
$health_data['post'] = TMDO_Entity_Health::get_one( 'post' );
}
$bridge_page = admin_url( 'tools.php?page=wp-data-optimizer&tab=entity-bridge' );
?>
' . esc_html__( '此 post type 沒有可分析的 postmeta 欄位。', '2meet-data-optimizer' ) . '
';
return;
}
$summary = TMDO_Zone_Classifier::summary( $post_type );
?>
' . sprintf( esc_html__( '已清除 %1$d 筆超過 %2$d 天的日誌。', '2meet-data-optimizer' ), (int) $deleted, (int) $days ) . '
';
}
$errors = TMDO_Logger::get_recent( '', 100 );
?>
'",
),
array(
'method' => 'GET',
'path' => '/listings',
'desc' => __( '查詢 Zone A 扁平欄位（搜尋/篩選），支援分頁與排序。', '2meet-data-optimizer' ),
'params' => array(
'post_type' => __( 'post type（預設 hp_listing）', '2meet-data-optimizer' ),
'per_page' => __( '每頁筆數 1–100（預設 20）', '2meet-data-optimizer' ),
'page' => __( '頁碼（預設 1）', '2meet-data-optimizer' ),
'orderby' => __( '排序欄位（預設 post_id）', '2meet-data-optimizer' ),
'order' => __( 'ASC 或 DESC（預設 DESC）', '2meet-data-optimizer' ),
'{col}_min' => __( '數值篩選下限，例如 hp_price_min=1000', '2meet-data-optimizer' ),
'{col}_max' => __( '數值篩選上限，例如 hp_price_max=5000', '2meet-data-optimizer' ),
'{col}' => __( '精確值篩選，例如 hp_featured=1', '2meet-data-optimizer' ),
),
'headers' => array(
'X-WP-Total' => __( '符合條件的總筆數', '2meet-data-optimizer' ),
'X-WP-TotalPages' => __( '總頁數', '2meet-data-optimizer' ),
),
'curl' => "curl '{$base}/listings?per_page=5&hp_price_min=1000&order=ASC'",
),
array(
'method' => 'GET',
'path' => '/listings/{id}',
'desc' => __( '單筆 listing：Zone A（熱區欄位）+ Zone C（JSON blob）合併回傳。Zone 未啟用時自動 fallback postmeta。', '2meet-data-optimizer' ),
'params' => array( 'id' => __( 'Post ID（路徑參數）', '2meet-data-optimizer' ) ),
'headers' => array(),
'curl' => "curl '{$base}/listings/123'",
),
array(
'method' => 'GET',
'path' => '/stats/{id}',
'desc' => __( 'Zone B 瀏覽計數（warm zone），warm 未啟用時 fallback hp_view_count postmeta。', '2meet-data-optimizer' ),
'params' => array( 'id' => __( 'Post ID（路徑參數）', '2meet-data-optimizer' ) ),
'headers' => array(),
'curl' => "curl '{$base}/stats/123'",
),
array(
'method' => 'GET',
'path' => '/status',
'desc' => __( '版本、引擎、欄位統計、模組狀態。需要 manage_options 權限（帶 WP Nonce）。', '2meet-data-optimizer' ),
'params' => array(),
'headers' => array(),
'curl' => "curl '{$base}/status' -H 'X-WP-Nonce: '",
),
);
foreach ( $endpoints as $ep ) :
?>
WpdoClient
rest_url( 'wpdo/v1' ),
'nonce' => wp_create_nonce( 'wp_rest' ),
'post_type' => 'hp_listing',
] );"
);
?>
console.log(r));'
);
?>
' . esc_html( $result->get_error_message() ) . '
';
} else {
echo '' . esc_html__( 'HPCT 匯入成功！建議停用 HP Custom Tables 外掛。', '2meet-data-optimizer' ) . '
' . esc_html__( 'Snapshot system not available.', '2meet-data-optimizer' ) . '
wp wpdo snapshot restore <snapshot_id> --apply
wp wpdo conflict-scan
' . esc_html__( '衝突監控模組未載入。', '2meet-data-optimizer' ) . '';
return;
}
$summary = TMDO_Conflict_Monitor::get_summary();
$total = (int) ( $summary['total'] ?? 0 );
?>
|
●
●
|
| Hook overlap |
|
| UAEPG overlap |
|
0 ) : ?>
' . esc_html__( 'Site Health 模組未載入。', '2meet-data-optimizer' ) . '';
return;
}
$tests = array(
'wpdo_schema_drift' => array( 'check_schema_drift', __( 'Schema 完整性', '2meet-data-optimizer' ) ),
'wpdo_error_budget' => array( 'check_error_budget', __( '錯誤預算（過去 7 天）', '2meet-data-optimizer' ) ),
'wpdo_hook_conflicts' => array( 'check_hook_conflicts', __( 'Hook 衝突', '2meet-data-optimizer' ) ),
'wpdo_autoload_bloat' => array( 'check_autoload_bloat', __( 'Autoload 大小', '2meet-data-optimizer' ) ),
'wpdo_postmeta_explosion' => array( 'check_postmeta_explosion', __( 'wp_postmeta 爆量', '2meet-data-optimizer' ) ),
'wpdo_orphan_zone_rows' => array( 'check_orphan_zone_rows', __( 'Orphan zone rows', '2meet-data-optimizer' ) ),
'wpdo_missing_snapshot' => array( 'check_missing_snapshot', __( '缺少最近快照', '2meet-data-optimizer' ) ),
);
?>
|
|
|
$info ) {
$result = call_user_func( array( 'TMDO_Site_Health', $info[0] ) );
$status = (string) ( $result['status'] ?? 'good' );
$badge = 'good' === $status ? '✅' : ( 'critical' === $status ? '🔴' : '🟡' );
printf(
'| %s | %s %s | %s |
',
esc_html( $info[1] ),
esc_html( $badge ),
esc_html( $status ),
wp_kses_post( (string) ( $result['description'] ?? '' ) )
);
}
?>
%s
',
esc_html(
sprintf(
/* translators: %s: module name */
__( '✅ Module %s 已切換至 dual_write 狀態。建議觀察 ≥ 24h 後再推進到 shadow_read（用 Entity Bridge tab 或 wp wpdo bridge-mode-set）。', '2meet-data-optimizer' ),
$mod
)
)
);
} elseif ( 'enable_blocked' === $msg ) {
printf(
'',
esc_html(
sprintf(
/* translators: %s: module name */
__( '⛔ Module %s 啟用被 FSM Guard 擋下（可能 module 已不在 idle 狀態）。', '2meet-data-optimizer' ),
$mod
)
)
);
} elseif ( 'enable_failed' === $msg ) {
echo '' . esc_html__( '⛔ 啟用失敗，請查日誌。', '2meet-data-optimizer' ) . '
' . esc_html__( '🤖 模組建議', '2meet-data-optimizer' ) . '
';
echo '' . esc_html__( '系統依環境自動偵測哪些 module 適合啟用。每筆建議含 confidence score + reasons + blockers。一鍵啟用會把 module 推進到 dual_write（FSM 第 1 個 active state，FSM Guard 確保不越級）。', '2meet-data-optimizer' ) . '
';
if ( ! class_exists( 'TMDO_Module_Detector' ) ) {
echo '' . esc_html__( '模組偵測器未載入。', '2meet-data-optimizer' ) . '
';
return;
}
$all = TMDO_Module_Detector::detect_all( true );
// Sort: actionable enable (high confidence first) → wait → skip.
$buckets = array(
'enable' => array(),
'wait' => array(),
'skip' => array(),
);
foreach ( $all as $module => $r ) {
$rec = $r['recommendation'] ?? 'skip';
if ( ! isset( $buckets[ $rec ] ) ) {
$rec = 'skip';
}
$buckets[ $rec ][ $module ] = $r;
}
uasort( $buckets['enable'], static fn( $a, $b ) => (float) $b['confidence'] <=> (float) $a['confidence'] );
// ─── enable bucket（重點）─────────────────────────────────
$enable = $buckets['enable'];
printf(
'%s
',
esc_html(
sprintf(
/* translators: %d: number of recommended modules */
__( '✅ 建議啟用（%d 個 module）', '2meet-data-optimizer' ),
count( $enable )
)
)
);
if ( empty( $enable ) ) {
echo '' . esc_html__( '目前沒有可立即啟用的 module 建議。', '2meet-data-optimizer' ) . '
';
} else {
echo '';
printf(
'| %s | %s | %s | %s | %s | ',
esc_html__( 'Module', '2meet-data-optimizer' ),
esc_html__( 'Confidence', '2meet-data-optimizer' ),
esc_html__( '說明 / 理由', '2meet-data-optimizer' ),
esc_html__( '當前狀態', '2meet-data-optimizer' ),
esc_html__( '操作', '2meet-data-optimizer' )
);
echo '
';
foreach ( $enable as $module => $r ) {
$conf = (float) $r['confidence'];
$bar_w = (int) round( $conf * 100 );
$color = $conf >= 0.7 ? '#46b450' : ( $conf >= 0.5 ? '#dba617' : '#c3c4c7' );
printf(
'%s | | ',
esc_html( $module ),
esc_attr( $color ),
(int) $bar_w,
esc_html( sprintf( '%.2f', $conf ) )
);
echo '';
if ( ! empty( $r['description'] ) ) {
echo '' . esc_html( (string) $r['description'] ) . '
';
}
if ( ! empty( $r['reasons'] ) ) {
echo '' . esc_html( implode( ' · ', $r['reasons'] ) ) . '';
}
echo ' | ';
printf( '%s | ', esc_html( (string) $r['current_state'] ) );
echo ' | ';
echo '
';
}
echo '
';
}
// ─── wait bucket（條件未滿）────────────────────────────────
$wait = $buckets['wait'];
if ( ! empty( $wait ) ) {
printf(
'%s
',
esc_html(
sprintf(
/* translators: %d: number of modules not yet ready */
__( '⏳ 條件未滿 / 暫不建議（%d 個）', '2meet-data-optimizer' ),
count( $wait )
)
)
);
echo '';
foreach ( $wait as $module => $r ) {
printf(
'%s | %s |
',
esc_html( $module ),
esc_html( implode( ' · ', $r['blockers'] ?? array() ) )
);
}
echo '
';
}
// ─── skip bucket（已啟用 / 不適用）────────────────────────
$skip = $buckets['skip'];
if ( ! empty( $skip ) ) {
$skip_count = count( $skip );
printf(
'%s
',
esc_html(
sprintf(
/* translators: %d: number of modules already enabled or not applicable */
__( '已啟用 / 不適用（%d 個）— 點擊展開', '2meet-data-optimizer' ),
$skip_count
)
)
);
echo '';
foreach ( $skip as $module => $r ) {
printf(
'%s | %s |
',
esc_html( $module ),
esc_html( implode( ' · ', $r['blockers'] ?? array() ) )
);
}
echo '
' . esc_html__( '結果由 1 小時 transient 快取；每日健康檢查 cron 也會自動更新。', '2meet-data-optimizer' ) . '
';
}
/**
* Settings tab — email alerts + throttle (v2.4.0 M10).
*/
private static function render_settings(): void {
if ( isset( $_GET['wpdo_msg'] ) && 'settings_saved' === sanitize_key( wp_unslash( (string) $_GET['wpdo_msg'] ) ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended
echo '' . esc_html__( '設定已儲存。', '2meet-data-optimizer' ) . '