멀티 사이트 동시 관리

// Google Sheets: 사이트 마스터 시트 구조 // ┌──────────────────────────────────────────────────────────────────────────────────┐ // │ Site ID │ Site URL │ API User │ App Password │ Active │ Category │ // ├──────────────────────────────────────────────────────────────────────────────────┤ // │ site_01 │ https://brand-a.com │ api_admin│ xxxx xxxx .. │ YES │ 뉴스 │ // │ site_02 │ https://brand-b.co.kr │ api_admin│ yyyy yyyy .. │ YES │ 블로그 │ // │ site_03 │ https://shop-c.com │ editor │ zzzz zzzz .. │ YES │ 제품 │ // │ site_04 │ https://media-d.co.kr │ api_admin│ wwww wwww .. │ NO │ 뉴스 │ // │ site_05 │ https://franchise-e.com │ manager │ vvvv vvvv .. │ YES │ 공지 │ // │ ... │ ... │ ... │ ... │ ... │ ... │ // └──────────────────────────────────────────────────────────────────────────────────┘ // Make.com 시나리오 구성: // [Webhook/Schedule] → [Google Sheets: 사이트 목록] → [Filter: Active=YES] // → [Iterator] → [HTTP: POST /wp-json/wp/v2/posts] → [Error Handler] // → [Array Aggregator] → [Google Sheets: 로그 기록] → [Slack: 알림] // Make.com HTTP 모듈 설정 예시: // URL: {{iterator.site_url}}/wp-json/wp/v2/posts // Method: POST // Headers: // Authorization: Basic {{base64(iterator.api_user + ":" + iterator.app_password)}} // Content-Type: application/json // Body: { "title": "{{webhook.post_title}}", "content": "{{webhook.post_content}}", "status": "{{webhook.post_status}}", "categories": ["{{iterator.category_id}}"], "meta": { "_source_site": "central-hub", "_distribution_id": "{{webhook.distribution_id}}", "_deployed_at": "{{now}}" } }

/** * Plugin Name: MAP Remote Manager * Description: Make.com Automation Platform 원격 관리 엔드포인트 * Version: 2.0.0 * Author: WordPress Automation Team */ // 보안 체크 defined('ABSPATH') || exit; class MAP_Remote_Manager { private static $instance = null; public static function get_instance() { if (null === self::$instance) { self::$instance = new self(); } return self::$instance; } private function __construct() { add_action('rest_api_init', [$this, 'register_endpoints']); } public function register_endpoints() { // 사이트 종합 상태 조회 register_rest_route('map-remote/v1', '/status', [ 'methods' => 'GET', 'callback' => [$this, 'get_site_status'], 'permission_callback' => [$this, 'check_admin_permission'], ]); // 일괄 콘텐츠 발행 register_rest_route('map-remote/v1', '/bulk-publish', [ 'methods' => 'POST', 'callback' => [$this, 'bulk_publish'], 'permission_callback' => [$this, 'check_publish_permission'], ]); // 플러그인 목록 및 업데이트 현황 register_rest_route('map-remote/v1', '/plugins', [ 'methods' => 'GET', 'callback' => [$this, 'get_plugins_status'], 'permission_callback' => [$this, 'check_admin_permission'], ]); // 플러그인 일괄 업데이트 실행 register_rest_route('map-remote/v1', '/plugins/update', [ 'methods' => 'POST', 'callback' => [$this, 'update_plugins'], 'permission_callback' => [$this, 'check_admin_permission'], ]); // 보안 스캔 엔드포인트 register_rest_route('map-remote/v1', '/security-scan', [ 'methods' => 'GET', 'callback' => [$this, 'run_security_scan'], 'permission_callback' => [$this, 'check_admin_permission'], ]); // 백업 상태 확인 register_rest_route('map-remote/v1', '/backup-status', [ 'methods' => 'GET', 'callback' => [$this, 'get_backup_status'], 'permission_callback' => [$this, 'check_admin_permission'], ]); } // ===== 사이트 종합 상태 ===== public function get_site_status() { global $wp_version; $theme = wp_get_theme(); return [ 'site_name' => get_bloginfo('name'), 'site_url' => home_url(), 'wp_version' => $wp_version, 'php_version' => PHP_VERSION, 'mysql_version' => $GLOBALS['wpdb']->db_version(), 'theme_name' => $theme->get('Name'), 'theme_version' => $theme->get('Version'), 'post_count' => wp_count_posts()->publish, 'page_count' => wp_count_posts('page')->publish, 'user_count' => count_users()['total_users'], 'active_plugins' => count(get_option('active_plugins')), 'disk_usage' => size_format($this->get_upload_size()), 'last_post_date' => get_lastpostdate('blog', 'post'), 'updates_plugins' => $this->count_plugin_updates(), 'updates_themes' => $this->count_theme_updates(), 'ssl_valid' => is_ssl(), 'memory_limit' => WP_MEMORY_LIMIT, 'debug_mode' => WP_DEBUG, 'timestamp' => current_time('mysql'), ]; } // ===== 일괄 콘텐츠 발행 ===== public function bulk_publish($request) { $params = $request->get_json_params(); $results = []; foreach ($params['posts'] as $post_data) { $post_id = wp_insert_post([ 'post_title' => sanitize_text_field($post_data['title']), 'post_content' => wp_kses_post($post_data['content']), 'post_status' => $post_data['status'] ?? 'draft', 'post_author' => get_current_user_id(), 'post_category' => $post_data['categories'] ?? [], 'meta_input' => $post_data['meta'] ?? [], ]); if (!is_wp_error($post_id)) { // 피처 이미지 설정 if (!empty($post_data['featured_image_url'])) { $this->set_featured_image($post_id, $post_data['featured_image_url']); } $results[] = [ 'status' => 'success', 'post_id' => $post_id, 'url' => get_permalink($post_id), ]; } else { $results[] = [ 'status' => 'error', 'error' => $post_id->get_error_message(), ]; } } return [ 'total' => count($results), 'success' => count(array_filter($results, fn($r) => $r['status'] === 'success')), 'results' => $results, 'timestamp' => current_time('mysql'), ]; } // ===== 퍼미션 체크 ===== public function check_admin_permission() { return current_user_can('manage_options'); } public function check_publish_permission() { return current_user_can('publish_posts'); } // ===== 헬퍼 메서드 ===== private function get_upload_size() { $upload_dir = wp_upload_dir(); $size = 0; $path = $upload_dir['basedir']; if (is_dir($path)) { foreach (new RecursiveIteratorIterator( new RecursiveDirectoryIterator($path) ) as $file) { $size += $file->getSize(); } } return $size; } private function count_plugin_updates() { $updates = get_site_transient('update_plugins'); return isset($updates->response) ? count($updates->response) : 0; } private function count_theme_updates() { $updates = get_site_transient('update_themes'); return isset($updates->response) ? count($updates->response) : 0; } private function set_featured_image($post_id, $image_url) { require_once ABSPATH . 'wp-admin/includes/media.php'; require_once ABSPATH . 'wp-admin/includes/file.php'; require_once ABSPATH . 'wp-admin/includes/image.php'; $attach_id = media_sideload_image($image_url, $post_id, null, 'id'); if (!is_wp_error($attach_id)) { set_post_thumbnail($post_id, $attach_id); } } } MAP_Remote_Manager::get_instance();