9B534B8686E580E0E01768F00155B461

at path：ROOT / wp-content / plugins / wplr-sync / classes / rest.php

run：R W Run

admin.php

43.65 KB

2025-12-03 14:11:38

R W Run

api.php

11.32 KB

2026-04-15 13:09:44

R W Run

core.php

79.15 KB

2026-04-15 13:09:44

R W Run

error.php

3.68 KB

2021-05-20 07:11:02

R W Run

explorer.php

2.92 KB

2026-01-27 09:01:44

R W Run

init.php

3.82 KB

2025-11-13 15:52:46

R W Run

keywords.php

3.36 KB

2026-04-25 14:46:28

R W Run

lrinfo.php

1.67 KB

2021-05-20 07:11:02

R W Run

public_api.php

4.91 KB

2024-10-17 12:37:14

R W Run

response.php

4.78 KB

2021-05-20 07:11:02

R W Run

rest.php

39.6 KB

2026-02-25 20:11:08

R W Run

troubleshoot.php

2.43 KB

2021-05-20 07:11:02

R W Run

ui.php

493 By

2021-05-20 07:11:02

R W Run

wplr-sync.log

20.83 KB

2023-09-08 12:37:56

R W Run

error_log

📄rest.php

<?php

class Meow_WPLR_Sync_Rest
{
	private $core = null;
	private $admin = null;
	private $namespace = 'wplr-sync/v1';

public function __construct( $core, $admin ) {
		if ( !current_user_can( 'upload_files' ) ) {
			return;
		} 
		$this->core = $core;
		$this->admin = $admin;
		add_action( 'rest_api_init', array( $this, 'rest_api_init' ) );
	}

function rest_api_init() {
		try {
			// SETTINGS
			register_rest_route( $this->namespace, '/update_option', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_update_option' )
			) );
			register_rest_route( $this->namespace, '/all_settings', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_all_settings' ),
			) );
			register_rest_route( $this->namespace, '/entries', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_entries' ),
				'args' => array(
					'show' => array( 'required' => true, 'default' => 'unlinked' ),
				)
			) );
			register_rest_route( $this->namespace, '/wp_hierarchy', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_wp_hierarchy' ),
			) );
			register_rest_route( $this->namespace, '/lr_hierarchy', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_lr_hierarchy' ),
			) );
			register_rest_route( $this->namespace, '/all_media', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_all_media' ),
				'args' => array(
					'limit' => array( 'required' => false, 'default' => 20 ),
					'skip' => array( 'required' => false, 'default' => 0 ),
					'orderBy' => array( 'required' => false, 'default' => 'id' ),
					'order' => array( 'required' => false, 'default' => 'desc' ),
				)
			) );
			register_rest_route( $this->namespace, '/unassigned_entries', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_unassigned_entries' ),
				'args' => array(
					'limit' => array( 'required' => false, 'default' => 20 ),
					'skip' => array( 'required' => false, 'default' => 0 ),
					'orderBy' => array( 'required' => false, 'default' => 'id' ),
					'order' => array( 'required' => false, 'default' => 'desc' ),
				)
			) );
			register_rest_route( $this->namespace, '/folder_content', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_folder_content' ),
			) );
			register_rest_route( $this->namespace, '/gallery_content', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_gallery_content' ),
				'args' => array(
					'collectionId' => array( 'required' => false, 'default' => null ),
					'limit' => array( 'required' => false, 'default' => 20 ),
					'skip' => array( 'required' => false, 'default' => 0 ),
					'orderBy' => array( 'required' => false, 'default' => 'id' ),
					'order' => array( 'required' => false, 'default' => 'desc' ),
				)
			) );
			register_rest_route( $this->namespace, '/delete_hierarchy', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_delete_hierarchy' ),
			) );
			register_rest_route( $this->namespace, '/keywords_hierarchy', array(
				'methods' => 'GET',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_keywords_hierarchy' ),
			) );
			register_rest_route( $this->namespace, '/delete_keywords_hierarchy', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_settings' ),
				'callback' => array( $this, 'rest_delete_keywords_hierarchy' ),
			) );

register_rest_route( $this->namespace, '/sync_info', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_sync_info' )
			) );
			register_rest_route( $this->namespace, '/link', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_link' )
			) );
			register_rest_route( $this->namespace, '/unlink', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_unlink' )
			) );
			register_rest_route( $this->namespace, '/extensions_query', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_extensions_query' )
			) );
			register_rest_route( $this->namespace, '/extensions_init', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_extensions_init' )
			) );
			register_rest_route( $this->namespace, '/extensions_reset', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_extensions_reset' )
			) );
			register_rest_route( $this->namespace, '/clean', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_clean' )
			) );
			register_rest_route( $this->namespace, '/repair', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_repair' )
			) );
			register_rest_route( $this->namespace, '/create_folder', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_create_folder' )
			) );
			register_rest_route( $this->namespace, '/create_gallery', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_create_gallery' )
			) );
			register_rest_route( $this->namespace, '/update_folder', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_update_folder' )
			) );
			register_rest_route( $this->namespace, '/update_gallery', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_update_gallery' )
			) );
			register_rest_route( $this->namespace, '/delete_folder', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_delete_collection' )
			) );
			register_rest_route( $this->namespace, '/delete_gallery', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_delete_collection' )
			) );
			register_rest_route( $this->namespace, '/move_collection', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_move_collection' )
			) );
			register_rest_route( $this->namespace, '/move_media', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_move_media' )
			) );
			register_rest_route( $this->namespace, '/copy_media', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_copy_media' )
			) );
			register_rest_route( $this->namespace, '/remove_media', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_remove_media' )
			) );
			register_rest_route( $this->namespace, '/update_media', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_update_media' )
			) );
			register_rest_route( $this->namespace, '/update_featured_image', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_update_featured_image' )
			) );
			register_rest_route( $this->namespace, '/reorder_media', array(
				'methods' => 'POST',
				'permission_callback' => array( $this->core, 'can_access_features' ),
				'callback' => array( $this, 'rest_reorder_media' )
			) );
		}
		catch (Exception $e) {
			var_dump($e);
		}
	}

function rest_all_settings() {
		return new WP_REST_Response( [
			'success' => true,
			'data' => $this->admin->get_all_options()
		], 200 );
	}

function rest_wp_hierarchy() {
		$hierarchy = $this->core->get_hierarchy(null, 0, 'wp');
		$hierarchy = $this->format_hierarchy( $hierarchy );
		return new WP_REST_Response( [
			'success' => true,
			'data' => $hierarchy
		], 200 );
	}

function rest_lr_hierarchy() {
		$hierarchy = $this->core->get_hierarchy(null, 0, 'lr');
		$hierarchy = $this->format_hierarchy( $hierarchy );
		return new WP_REST_Response( [
			'success' => true,
			'data' => $hierarchy
		], 200 );
	}

function count_unassigned_entries() {
		global $wpdb;
		$table_name = $wpdb->prefix . "lrsync_relations";
		$whereIsOriginal = "";
		if ( $this->core->wpml_media_is_installed() ) {
			global $sitepress;
			$tbl_wpml = $wpdb->prefix . "icl_translations";
			$language = $sitepress->get_default_language();
			$whereIsOriginal = "AND p.ID IN (SELECT element_id FROM $tbl_wpml WHERE element_type = 'post_attachment' AND language_code = '$language') ";
		}
		return (int)$wpdb->get_var( "SELECT COUNT(ID) FROM $wpdb->posts p
			WHERE post_status = 'inherit'
			AND post_mime_type <> ''
			AND p.ID NOT IN (SELECT wp_id FROM $table_name) " .
			$whereIsOriginal
		);
	}

function rest_folder_content($request) {
		$params = $request->get_json_params();
		$folder_id = isset( $params['folder_id'] ) ? (int)$params['folder_id'] : null;
		$source = isset( $params['source'] ) ? $params['source'] : null;
		$collection_ids = $folder_id
			? $this->core->get_collections_from_folder($folder_id)
			: $this->get_root_folders_by_source($source);
		$data = [];
		foreach ($collection_ids as $collection_id) {
			$data[] = $this->core->get_collection($collection_id);
		}
		return new WP_REST_Response( [
			'success' => true,
			'data' => $data
		], 200 );
	}

function rest_gallery_content( $request ) {
		$collectionId = sanitize_text_field( $request->get_param('collectionId') );
		$limit = sanitize_text_field( $request->get_param('limit') );
		$skip = sanitize_text_field( $request->get_param('skip') );
		$orderBy = sanitize_text_field( $request->get_param('orderBy') );
		$order = sanitize_text_field( $request->get_param('order') );

// Get gallery based on wp_posts

$mediaIds = $this->core->get_media_from_collection($collectionId);
		if (count($mediaIds) === 0) {
			return new WP_REST_Response( [
				'success' => true,
				'data' => [],
				'total' => 0,
			], 200 );
		}
		$mediaIdsPlaceholders = implode(', ', array_fill(0, count( $mediaIds ), '%s'));

global $wpdb;
		$total = (int)$wpdb->get_var( $wpdb->prepare(
			"SELECT COUNT(ID) FROM $wpdb->posts p 
			WHERE post_type='attachment' 
			AND post_status='inherit' 
			AND ID IN (" . $mediaIdsPlaceholders . ")", $mediaIds
		));
		$orderSql = 'ORDER BY p.ID DESC ';
		if ($orderBy === 'type') {
			$orderSql = 'ORDER BY p.ID ' . ( $order === 'asc' ? 'ASC' : 'DESC' );
		}
		$results = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT p.ID, p.post_title, p.post_content as description, p.post_excerpt as caption, pm1.meta_value as alt, pm2.meta_value as path 
				FROM $wpdb->posts p 
				LEFT JOIN $wpdb->postmeta pm1 ON pm1.post_id = p.ID AND pm1.meta_key = '_wp_attachment_image_alt' 
				LEFT JOIN $wpdb->postmeta pm2 ON pm2.post_id = p.ID AND pm2.meta_key = '_wp_attached_file' 
				WHERE post_type='attachment' 
				AND post_status='inherit' 
				AND ID IN (" . $mediaIdsPlaceholders . ") 
				$orderSql 
				LIMIT %d, %d", array_merge( $mediaIds, array( $skip, $limit ) )
			), ARRAY_A
		);

$data = [];
		if ( count( $results ) === 0 ) {
			return new WP_REST_Response( [
				'success' => true,
				'data' => $data,
				'total' => $total,
			], 200 );
		}

// Prefer the order by clause if specified.
		if ($orderBy === 'type') {
			foreach ( $results as $record ) {
				$data[] = [
					'ID' => $record['ID'],
					'title' => $record['post_title'],
					'description' => $record['description'],
					'caption' => $record['caption'],
					'alt' => $record['alt'],
					'path' => $record['path'],
					'thumbnail_url' => $this->getThumbnailUrl( $record['ID'], 'medium' )
				];
			}
			return new WP_REST_Response( [
				'success' => true,
				'data' => $data,
				'total' => $total,
			], 200 );
		}

// We need to keep the same order as the WPLR DB, hence this two loops.
		foreach ( $mediaIds as $mediaId ) {
			foreach ( $results as $record ) {
				if ( $record['ID'] === $mediaId ) {
					$data[] = [
						'ID' => $record['ID'],
						'title' => $record['post_title'],
						'description' => $record['description'],
						'caption' => $record['caption'],
						'alt' => $record['alt'],
						'path' => $record['path'],
						'thumbnail_url' => $this->getThumbnailUrl( $record['ID'], 'medium' )
					];
					break;
				}
			}
		}
		return new WP_REST_Response( [
			'success' => true,
			'data' => $data,
			'total' => $total,
		], 200 );
	}

function rest_delete_hierarchy($request) {
		$params = $request->get_json_params();
		$delete_collection = isset( $params['delete_collection'] ) ? $params['delete_collection'] : null;

if (!$delete_collection) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'delete_collection is missing.',
			], 400 );
		}
		$data = $this->core->delete_collection( $delete_collection );
		return new WP_REST_Response( [ 'success' => true, 'data' => $data ], 200 );
	}

function rest_keywords_hierarchy() {
		$hierarchy = $this->core->get_keywords_hierarchy();
		return new WP_REST_Response( [
			'success' => true,
			'data' => $hierarchy
		], 200 );
	}

function rest_delete_keywords_hierarchy($request) {
		$params = $request->get_json_params();
		$delete_keyword = isset( $params['delete_keyword'] ) ? $params['delete_keyword'] : null;

if (!$delete_keyword) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'delete_keyword is missing.',
			], 400 );
		}
		$data = $this->core->delete_keyword( $delete_keyword );
		return new WP_REST_Response( [ 'success' => true, 'data' => $data ], 200 );
	}

function validate_updated_option( $option_name ) {
		$wplr_library_show_hierarchy = get_option( 'wplr_library_show_hierarchy', 'none' );
		$wplr_public_api = get_option( 'wplr_public_api', false );
		if ( $wplr_library_show_hierarchy === '' )
			update_option( 'wplr_library_show_hierarchy', 'none' );
		if ( $wplr_public_api === '' )
			update_option( 'wplr_public_api', false );
		if (!get_option( 'wplr_public_api', false ) && get_transient( 'wplr_auth_token' ) !== false) {
			delete_transient( 'wplr_auth_token' );
		}
		return $this->createValidationResult();
	}

function createValidationResult( $result = true, $message = null) {
		$message = $message ? $message : __( 'OK', 'wplr-sync' );
		return ['result' => $result, 'message' => $message];
	}

function rest_unlink($request) {
		$params = $request->get_json_params();
		$lr_id = isset( $params['lrId'] ) ? (int)$params['lrId'] : null;
		$wp_id = isset( $params['wpId'] ) ? (int)$params['wpId'] : null;
		$afterDelete = isset( $params['afterDelete'] ) ? (int)$params['afterDelete'] : false;

list($result, $message, $code) = $this->validate_link_unlink($lr_id, $wp_id);

if (!$result) {
			return new WP_REST_Response([
				'success' => $result,
				'message' => $message,
			], $code );
		}

$result = $this->core->unlink_media( $lr_id, $wp_id );

if ($result && $afterDelete) {
			wp_delete_attachment( $wp_id );
		}

return new WP_REST_Response([
			'success' => $result,
			'data' => !$result ? null : [
				'wp_id' => $wp_id,
				'lr_id' => null
			],
			'message' => $result ? 'Success.' : $this->core->get_error(),
		], 200 );
	}

function rest_link($request) {
		$params = $request->get_json_params();
		$lr_id = isset( $params['lrId'] ) ? (int)$params['lrId'] : null;
		$wp_id = isset( $params['wpId'] ) ? (int)$params['wpId'] : null;

list($result, $message, $code) = $this->validate_link_unlink($lr_id, $wp_id);

if (!$result) {
			return new WP_REST_Response([
				'success' => $result,
				'message' => $message,
			], $code );
		}

$sync = $this->core->link_media( $lr_id, $wp_id );
		$result = (bool)$sync;
		return new WP_REST_Response([
			'success' => $result,
			'data' => !$result ? null : [
				'wp_id' => $wp_id,
				'lr_id' => $sync->lr_id,
				'lastsync' => $sync->lastsync
			],
			'message' => $result ? 'Success.' : $this->core->get_error(),
		], 200 );
	}

return new WP_REST_Response([
				'success' => true,
			], 200 );
		}
		catch ( Exception $e ) {
			error_log( print_r( $e, true ) );
			return new WP_REST_Response([
				'success' => false,
				'message' => 'An exception was caught and written in the PHP error logs.',
			], 500 );
		}
	}

function rest_extensions_init($request) {
		global $wpdb;
		$params = $request->get_json_params();
		$isRemoval = isset( $params['is_removal'] ) && $params['is_removal'] == 1;
		$tbl_m = $wpdb->prefix . 'lrsync';
		$tbl_r = $wpdb->prefix . 'lrsync_relations';
		$tbl_t = $wpdb->prefix . 'lrsync_meta';

$tasks = array();

// Tags
		$tags = $wpdb->get_results( $wpdb->prepare( "SELECT id as id, value as name FROM $tbl_t WHERE name = %s", 'tag_name' ), ARRAY_A );
		foreach ( $tags as $tag )
			array_push( $tasks, array_merge( array( 'action' => $isRemoval ? 'remove_tag' : 'add_tag' ), $tag ) );

// Tag's Parents
		if ( !$isRemoval ) {
			$tags = $wpdb->get_results( $wpdb->prepare( "SELECT m1.id as id, m1.value as name, m2.value as parent
				FROM $tbl_t m1
				JOIN $tbl_t m2 ON m2.id = m1.id AND m2.name = %s
				WHERE m1.name = %s", 'tag_parent', 'tag_name' ), ARRAY_A );

foreach ( $tags as $tag )
				array_push( $tasks, array_merge( array( 'action' => 'update_tag' ), $tag ) );
		}

// Collections
		$collections = $this->core->read_collections_recursively( null, array(), $isRemoval );
		$tasks = array_merge( $tasks, $collections );

// Photos
		foreach ( $collections as $c ) {
			if ( !$c['is_folder'] ) {
				$photos = $wpdb->get_results( $wpdb->prepare( "SELECT wp_id, wp_col_id, sort FROM $tbl_r WHERE wp_col_id = %d ORDER BY sort", $c['wp_col_id'] ), ARRAY_A );
				foreach ( $photos as $p )
					array_push( $tasks, array_merge( array( 'action' => $isRemoval ? 'remove_media' : 'add_media' ), $p ) );
			}
		};

// Media Tags
		$tags = $wpdb->get_results( $wpdb->prepare( "
			SELECT id as wp_id, value as id
			FROM $tbl_t
			WHERE name = %s", 'media_tag' ), ARRAY_A );
		foreach ( $tags as $tag )
			array_push( $tasks, array_merge( array( 'action' => $isRemoval ? 'remove_media_tag' : 'add_media_tag' ), $tag ) );

return new WP_REST_Response([
			'success' => true,
			'data' => $isRemoval ? $tasks : array_reverse( $tasks )
		], 200 );
	}

function rest_repair() {
		$messages = $this->core->check_db();

if ( empty( $messages ) ) {
			$messages[] = '🟢 No issues found.';
		}

return new WP_REST_Response([
			'success' => true,
			'data' => $messages
		], 200 );
	}

function rest_create_folder($request) {
		$params = $request->get_json_params();
		$name = isset( $params['name'] ) ? $params['name'] : '';
		$parentFolderId = isset( $params['parent_folder_id'] ) ? $params['parent_folder_id'] : null;
		$source = isset( $params['source'] ) ? $params['source'] : '';

if (!$name || !$source) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The create folder parameters are missing.',
			], 400 );
		}
		if (!$this->core->create_collection('folder', $name, $parentFolderId, $source)) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'Failed to create a new folder.',
			], 400 );
		}

return new WP_REST_Response([
			'success' => true,
		], 200 );
	}

function rest_create_gallery($request) {
		$params = $request->get_json_params();
		$name = isset( $params['name'] ) ? $params['name'] : '';
		$parentFolderId = isset( $params['parent_folder_id'] ) ? $params['parent_folder_id'] : null;
		$source = isset( $params['source'] ) ? $params['source'] : '';

if (!$name || !$source) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The create gallery parameters are missing.',
			], 400 );
		}
		if (!$this->core->create_collection('collection', $name, $parentFolderId, $source)) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'Failed to create a new gallery.',
			], 400 );
		}

return new WP_REST_Response([
			'success' => true,
		], 200 );
	}

function rest_update_folder($request) {
		$params = $request->get_json_params();
		$wp_col_id = isset( $params['id'] ) ? $params['id'] : '';
		$name = isset( $params['name'] ) ? $params['name'] : '';
		$slug = isset( $params['slug'] ) ? $params['slug'] : '';

if ( !$wp_col_id || !$name ) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The update folder parameters are missing.',
			], 400 );
		}

try {
			$this->core->update_collection( $wp_col_id, $name, $slug );
			return new WP_REST_Response([
				'success' => true,
			], 200 );
		}
		catch (Exception $e) {
			return new WP_REST_Response([
				'success' => false,
				'message' => $e->getMessage(),
			], 500 );
		}
	}

function rest_update_gallery($request) {
		$params = $request->get_json_params();
		$wp_col_id = isset( $params['id'] ) ? $params['id'] : '';
		$name = isset( $params['name'] ) ? $params['name'] : '';
		$slug = isset( $params['slug'] ) ? $params['slug'] : '';

if (!$wp_col_id || !$name) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The update gallery parameters are missing.',
			], 400 );
		}

function rest_delete_collection($request) {
		$params = $request->get_json_params();
		$wpColId = isset( $params['id'] ) ? (int)$params['id'] : '';

if (!$wpColId) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The folder id or the gallery id to delete is missing.',
			], 400 );
		}
		if (!$this->core->delete_collection($wpColId)) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'Failed to delete the folder/gallery.',
			], 400 );
		}

return new WP_REST_Response([
			'success' => true,
		], 200 );
	}

function rest_update_media($request) {
		$params = $request->get_json_params();
		$wp_id = isset( $params['id'] ) ? $params['id'] : '';
		$title = isset( $params['title'] ) ? $params['title'] : '';
		$description = isset( $params['description'] ) ? $params['description'] : '';
		$caption = isset( $params['caption'] ) ? $params['caption'] : '';
		$alt = isset( $params['alt'] ) ? $params['alt'] : '';
		if (!$wp_id) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The id to move or current collection id is missing.',
			], 400 );
		}
		try {
			$post = [
				'ID' => $wp_id,
				'post_title' => $title,
				'post_content' => $description,
				'post_excerpt' => $caption
			];
			$result = wp_update_post( $post, true );
			if ( is_wp_error( $result ) ) {
				throw new Exception($result->get_error_message());
			}
			update_post_meta( $wp_id, '_wp_attachment_image_alt', $alt );

return new WP_REST_Response([
				'success' => true,
			], 200 );
		}
		catch (Exception $e) {
			return new WP_REST_Response([
				'success' => false,
				'message' => $e->getMessage(),
			], 500 );
		}
	}

public function rest_update_featured_image($request) {
		$params = $request->get_json_params();
		$collection_id = isset( $params['collection_id'] ) ? $params['collection_id'] : '';
		$featured_image_id = isset( $params['featured_image_id'] ) ? $params['featured_image_id'] : '';
		if (!$collection_id || !$featured_image_id ) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The featured image id or current collection id is missing.',
			], 400 );
		}
		try {
			$this->core->set_featured_image($collection_id, $featured_image_id);

public function rest_reorder_media($request) {
		$params = $request->get_json_params();
		$collection_id = isset( $params['collection_id'] ) ? $params['collection_id'] : '';
		$media_ids = isset( $params['media_ids'] ) ? $params['media_ids'] : [];
		if (!$collection_id || !is_array($media_ids) || count($media_ids) === 0) {
			return new WP_REST_Response([
				'success' => false,
				'message' => 'The collection id or media ids are missing.',
			], 400 );
		}
		try {
			global $wpdb;
			$tbl_r = $wpdb->prefix . 'lrsync_relations';
			
			// Update the sort order for each media in the collection
			foreach ($media_ids as $index => $media_id) {
				$wpdb->update(
					$tbl_r,
					array( 'sort' => $index ),
					array( 'wp_col_id' => $collection_id, 'wp_id' => $media_id ),
					array( '%d' ),
					array( '%d', '%d' )
				);
			}

/**
	 * Private Methods
	 */
	private function validate_link_unlink($lr_id, $wp_id)
	{
		if ( !current_user_can('upload_files') ) {
			return [ false, 'You do not have the roles to perform this action.', 403 ];
		}
		if ( $lr_id === '' || $lr_id === null || $wp_id === '' || $wp_id === null ) {
			return [ false, 'Some information is missing.', 422 ];
		}
		return [ true, null, null ];
	}

private function getThumbnailUrl($id, $size)
	{
		$attachment_src = wp_get_attachment_image_src( $id, $size );
		return empty( $attachment_src ) ? null : $attachment_src[0];
	}

private function getThumbnailAlt($id)
	{
		return get_post_meta( $id, '_wp_attachment_image_alt', true );
	}

private function getThumbnailPath($id)
	{
		return get_post_meta( $id, '_wp_attached_file', true );
	}

/**
	 * Get the folders which have no wp_folder_id in the specific source.
	 *
	 * @param string $source
	 * @return array
	 */
	private function get_root_folders_by_source( $source ) {
		global $wpdb;
		$tbl_c = $wpdb->prefix . 'lrsync_collections';
		$collections = $wpdb->get_col( $wpdb->prepare( "SELECT wp_col_id FROM $tbl_c
			WHERE wp_folder_id IS NULL AND source = %s ORDER BY name, lr_col_id", $source ) );
		return $collections;
	}
}