exporter-helper.php

<?php

/**
 * Campaign Exporter Helper Functions
 *
 * @package P4MT
 */

/**
 * Parse the post content and return all attachment ids used in blocks.
 *
 * @param string $content The content to parse.
 * @return array All attachments used in the blocks.
 */
function get_attachments_used_in_content(string $content): array
{
    $blocks = parse_blocks($content);

    $attachment_ids = [];

    foreach ($blocks as $block) {
        // Fetch the attachement id/s from block fields.
        switch ($block['blockName']) {
            case 'core/media-text':
                $attachment_ids[] = $block['attrs']['mediaId'] ?? '';
                $attachment_ids[] = $block['attrs']['mediaLink'] ?? '';
                $attachment_ids[] = $block['attrs']['mediaType'] ?? '';
                break;

            case 'core/image':
            case 'planet4-blocks/happypoint':
                $attachment_ids[] = $block['attrs']['id'] ?? '';
                break;

            case 'planet4-blocks/gallery':
                if (isset($block['attrs']['multiple_image'])) {
                    $multiple_images = explode(',', $block['attrs']['multiple_image']);
                    $attachment_ids = array_merge($attachment_ids, $multiple_images);
                }
                break;

            case 'planet4-blocks/carousel-header':
                if (isset($block['attrs']['slides'])) {
                    foreach ($block['attrs']['slides'] as $slide) {
                        $attachment_ids[] = $slide['image'];
                    }
                }
                break;

            case 'planet4-blocks/columns':
                if (isset($block['attrs']['columns'])) {
                    foreach ($block['attrs']['columns'] as $column) {
                        $attachment_ids[] = $column['attachment'] ?? '';
                    }
                }
                break;

            case 'planet4-blocks/take-action-boxout':
                $attachment_ids[] = $block['attrs']['background_image'] ?? '';
                break;
        }
    }

    return $attachment_ids;
}

/**
 * Returns all attachment ids from campaign post content.
 *
 * @param array $post_ids Post IDs.
 * @return array  $post_ids Post IDs.
 */
function get_campaign_attachments(array $post_ids): array
{

    global $wpdb;

    if (empty($post_ids)) {
        return [];
    }

    $sql = '
		SELECT id
		FROM %1$s
		WHERE post_type = \'attachment\'
		AND post_parent IN (' . generate_list_placeholders($post_ids, 2) . ')';

    $prepared_sql = $wpdb->prepare(
        $sql, // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
        array_merge([ $wpdb->posts ], $post_ids)
    );
    $results = $wpdb->get_results($prepared_sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $attachment_ids = array_map(
        function ($result) {
            return $result->id;
        },
        $results
    );

    /**
     * Post thumbnails
     */
    $sql = '
		SELECT meta_value
		FROM %1$s
		WHERE ( meta_key = \'_thumbnail_id\' OR meta_key = \'background_image_id\' )
		AND post_id IN(' . generate_list_placeholders($post_ids, 2) . ')';

    $prepared_sql = $wpdb->prepare(
        $sql, // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
        array_merge([ $wpdb->postmeta ], $post_ids)
    );
    $results = $wpdb->get_results($prepared_sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

    $attachment_ids = array_merge(
        $attachment_ids,
        array_map(
            function ($result) {
                return $result->meta_value;
            },
            $results
        )
    );

    $sql = '
			SELECT post_content
			FROM %1$s
			WHERE ID IN(' . generate_list_placeholders($post_ids, 2) . ')
			AND post_content REGEXP \'((wp-image-|wp-att-)[0-9][0-9]*)|gallery_block_style|wp\:planet4\-blocks|href=|src=\'';// phpcs:ignore Generic.Files.LineLength.MaxExceeded
    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $prepared_sql = $wpdb->prepare($sql, array_merge([ $wpdb->posts ], $post_ids));
    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $results = $wpdb->get_results($prepared_sql);

    foreach ((array) $results as $text) {
        $text = $text->post_content;
        $attachment_ids = array_merge($attachment_ids, get_attachments_used_in_content($text));
    }

    $attachment_ids = array_unique($attachment_ids);
    sort($attachment_ids);

    // The post ids are reordered as sort all attachment ids first
    // and then append the post id to array.(Added for simplification of import process).
    $attachment_ids = array_diff($attachment_ids, $post_ids);
    $post_ids = array_merge($attachment_ids, $post_ids);

    return $post_ids;
}

/**
 * Wrap strings in nested CDATA tags.
 *
 * @param string|null $str String to replace.
 */
function p4_px_single_post_cdata(?string $str): string
{
    if (seems_utf8($str) === false) {
        $str = mb_convert_encoding($str, 'UTF-8');
    }
    $str = '<![CDATA[' . str_replace(']]>', ']]]]><![CDATA[>', $str) . ']]>';

    return $str;
}

/**
 * Get the site url.
 */
function p4_px_single_post_site_url(): string
{
    if (is_multisite()) {
        return network_home_url();
    }

    return get_bloginfo_rss('url');
}

/**
 * Get the Campaign authors.
 *
 * @param array $post_ids Tag object.
 */
function p4_px_single_post_authors_list(array $post_ids): void
{
    global $wpdb;

    $post_ids = array_map('intval', $post_ids); // santize the post_ids manually.
    $post_ids = array_filter($post_ids); // strip ones that didn't validate.

    $authors = [];

    $sql = 'SELECT DISTINCT post_author
			FROM %1$s
			WHERE ID IN(' . generate_list_placeholders($post_ids, 2) . ') AND post_status != \'auto-draft\'';
    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $prepared_sql = $wpdb->prepare($sql, array_merge([ $wpdb->posts ], $post_ids));
    // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
    $results = $wpdb->get_results($prepared_sql);

    foreach ((array) $results as $result) {
        $authors[] = get_userdata($result->post_author);
    }

    $authors = array_filter($authors);

	// phpcs:disable WordPress.Security.EscapeOutput.OutputNotEscaped
    foreach ($authors as $author) {
        echo "\t<wp:author>";
        echo '<wp:author_id>' . $author->ID . '</wp:author_id>';
        echo '<wp:author_login>' . $author->user_login . '</wp:author_login>';
        echo '<wp:author_email>' . $author->user_email . '</wp:author_email>';
        echo '<wp:author_display_name>' . p4_px_single_post_cdata($author->display_name) . '</wp:author_display_name>';
        echo '<wp:author_first_name>' . p4_px_single_post_cdata($author->user_firstname) . '</wp:author_first_name>';
        echo '<wp:author_last_name>' . p4_px_single_post_cdata($author->user_lastname) . '</wp:author_last_name>';
        echo "</wp:author>\n";
    }
}