<?php
/**
 * TMDO_Collab — integration with 2meet-collab (Wave 3 / v2.2.0).
 *
 * 7 張表的協作系統。註冊全部 7 表。
 *
 * @package WP_Data_Optimizer
 * @since   2.0.0
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

// phpcs:disable Squiz.Commenting.FunctionComment.Missing,Squiz.Commenting.InlineComment.InvalidEndChar,Generic.Commenting.DocComment.MissingShort,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,WordPress.PHP.YodaConditions,Generic.CodeAnalysis.EmptyStatement -- v2.0.0 partner integrations: pure registration helpers + intentional silent catches.

/**
 * 2meet-collab 整合。
 */
final class TMDO_Collab {

	/**
	 * 偵測以常數優先：`TMCLB_VERSION` / `TMCLB_PLUGIN_DIR` 在 2meet-collab 主檔的
	 * **檔案解析當下**（第 22/25 行）即 define，早於 `plugins_loaded`；本 AddOn
	 * bootstrap 掛在 `plugins_loaded:6`，故此時常數已可用。
	 *
	 * 舊版偵測的 `TMCLB_Plugin` / `TMCLB_Main` 兩個類別在 2meet-collab 中**並不存在**，
	 * 偵測實際完全靠 `file_exists()` 撐著。保留 file_exists 作最終後備，但常數檢查
	 * 現在真的有效——即使將來移除後備也不會像 infocards 那樣整個 AddOn 靜默失效。
	 */
	public static function register(): void {
		$detected = defined( 'TMCLB_VERSION' )
			|| defined( 'TMCLB_PLUGIN_DIR' )
			|| file_exists( WP_PLUGIN_DIR . '/2meet-collab/2meet-collab.php' );
		if ( ! $detected ) {
			return;
		}
		add_action( 'wpdo_register_custom_tables', array( __CLASS__, 'register_custom_tables' ) );
	}

	public static function register_custom_tables( TMDO_Custom_Table_Registry $registry ): void {
		// v2.0.4 修正：表名與 2meet-collab v0.1.2-alpha+ 實際 DB schema 對齊。
		// 之前 v2.0.0~v2.0.3 使用截短名（templates / instances / history / venues）導致
		// `wp wpdo doctor` 找不到實際表，誤報 missing。實際表名來自 2meet-collab 自身：
		// `class-tmclb-activator.php` CREATE TABLE 與 `uninstall.php` 的 7 張表。
		// v2.1.0 修正：補上 expected_columns / expected_indexes，讓 `wp wpdo doctor`/
		// `benchmark` 能做 schema drift 偵測。欄位/索引與 2meet-collab
		// `class-tmclb-activator.php::create_tables()` 的 CREATE TABLE 定義完全對齊。
		$tables = array(
			'2mclb_rider_templates' => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'               => 'BIGINT',
					'vendor_id'        => 'BIGINT',
					'title'            => 'VARCHAR',
					'description'      => 'TEXT',
					'default_sections' => 'LONGTEXT',
					'is_public'        => 'TINYINT',
					'status'           => 'VARCHAR',
					'created_at'       => 'DATETIME',
					'updated_at'       => 'DATETIME',
				),
				'indexes' => array(
					'vendor_id' => array( 'vendor_id' ),
					'status'    => array( 'status' ),
				),
			),
			'2mclb_rider_instances' => array(
				'primary_key'      => 'id',
				'post_type_link'   => 'hp_vendor',
				'expected_columns' => array(
					'id'                 => 'BIGINT',
					'template_id'        => 'BIGINT',
					'vendor_id'          => 'BIGINT',
					'title'              => 'VARCHAR',
					'event_date'         => 'DATE',
					'event_name'         => 'VARCHAR',
					'venue_profile_id'   => 'BIGINT',
					'status'             => 'VARCHAR',
					'stage_plot_data'    => 'LONGTEXT',
					'channel_list_data'  => 'LONGTEXT',
					'equipment_data'     => 'LONGTEXT',
					'timeline_data'      => 'LONGTEXT',
					'checklist_data'     => 'LONGTEXT',
					'access_token'       => 'VARCHAR',
					'token_expires_at'   => 'DATETIME',
					'locked_at'          => 'DATETIME',
					'locked_by'          => 'BIGINT',
					'created_at'         => 'DATETIME',
					'updated_at'         => 'DATETIME',
				),
				'indexes' => array(
					'vendor_id'    => array( 'vendor_id' ),
					'template_id'  => array( 'template_id' ),
					'status'       => array( 'status' ),
					'access_token' => array( 'access_token' ),
				),
			),
			'2mclb_collaborators'   => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'               => 'BIGINT',
					'instance_id'      => 'BIGINT',
					'user_id'          => 'BIGINT',
					'email'            => 'VARCHAR',
					'display_name'     => 'VARCHAR',
					'role'             => 'VARCHAR',
					'permissions'      => 'LONGTEXT',
					'invite_token'     => 'VARCHAR',
					'token_expires_at' => 'DATETIME',
					'status'           => 'VARCHAR',
					'last_seen_at'     => 'DATETIME',
					'created_at'       => 'DATETIME',
				),
				'indexes' => array(
					'instance_id'  => array( 'instance_id' ),
					'user_id'      => array( 'user_id' ),
					'invite_token' => array( 'invite_token' ),
					'email'        => array( 'email' ),
				),
			),
			'2mclb_confirmations'   => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'             => 'BIGINT',
					'instance_id'    => 'BIGINT',
					'section'        => 'VARCHAR',
					'confirmed_by'   => 'BIGINT',
					'confirmed_role' => 'VARCHAR',
					'status'         => 'VARCHAR',
					'note'           => 'TEXT',
					'confirmed_at'   => 'DATETIME',
				),
				'indexes' => array(
					'instance_section' => array( 'instance_id', 'section' ),
					'confirmed_by'      => array( 'confirmed_by' ),
				),
			),
			'2mclb_comments'        => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'          => 'BIGINT',
					'instance_id' => 'BIGINT',
					'section'     => 'VARCHAR',
					'parent_id'   => 'BIGINT',
					'author_id'   => 'BIGINT',
					'author_name' => 'VARCHAR',
					'author_role' => 'VARCHAR',
					'content'     => 'TEXT',
					'is_resolved' => 'TINYINT',
					'created_at'  => 'DATETIME',
				),
				'indexes' => array(
					'instance_section' => array( 'instance_id', 'section' ),
					'parent_id'         => array( 'parent_id' ),
				),
			),
			'2mclb_rider_history'   => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'          => 'BIGINT',
					'instance_id' => 'BIGINT',
					'action'      => 'VARCHAR',
					'section'     => 'VARCHAR',
					'actor_id'    => 'BIGINT',
					'actor_name'  => 'VARCHAR',
					'actor_role'  => 'VARCHAR',
					'snapshot'    => 'LONGTEXT',
					'note'        => 'TEXT',
					'created_at'  => 'DATETIME',
				),
				'indexes' => array(
					'instance_id'      => array( 'instance_id' ),
					'instance_section' => array( 'instance_id', 'section' ),
				),
			),
			'2mclb_venue_profiles'  => array(
				'primary_key'      => 'id',
				'post_type_link'   => null,
				'expected_columns' => array(
					'id'                   => 'BIGINT',
					'vendor_id'            => 'BIGINT',
					'buyer_id'             => 'BIGINT',
					'name'                 => 'VARCHAR',
					'address'              => 'VARCHAR',
					'stage_width'          => 'DECIMAL',
					'stage_depth'          => 'DECIMAL',
					'ceiling_height'       => 'DECIMAL',
					'power_capacity_amps'  => 'INT',
					'power_outlets_count'  => 'INT',
					'has_pa_system'        => 'TINYINT',
					'has_monitors'         => 'TINYINT',
					'has_lighting'         => 'TINYINT',
					'has_backline'         => 'TINYINT',
					'load_in_info'         => 'TEXT',
					'parking_info'         => 'TEXT',
					'contact_name'         => 'VARCHAR',
					'contact_phone'        => 'VARCHAR',
					'contact_email'        => 'VARCHAR',
					'notes'                => 'TEXT',
					'extra_specs'          => 'LONGTEXT',
					'created_at'           => 'DATETIME',
					'updated_at'           => 'DATETIME',
				),
				'indexes' => array(
					'vendor_id' => array( 'vendor_id' ),
					'buyer_id'  => array( 'buyer_id' ),
				),
			),
		);
		foreach ( $tables as $table_name => $meta ) {
			$registry->register(
				'2meet-collab',
				array_merge(
					array( 'table_name' => $table_name ),
					$meta
				)
			);
		}
	}
}