Snippets

MVF Export data from legacy Builders Library

Created by Fernando Paredes Murillo
bulli-legacy-export.php
Raw 
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
<?php
add_action( 'wp_loaded', 'bulli_export_json', 99 );
function bulli_export_json() {
    global $bulli;

    if ( is_admin() && isset( $_GET['bulli_export_json'] ) && $_GET['bulli_export_json'] == 'true' ) {

        $builder_ids =  bulli_get_post_ids( 'bulli-builder' );
        $industry_ids =  bulli_get_post_ids( 'bulli-industries' );
        array_unshift( $industry_ids, 0 );
        $feature_ids =  bulli_get_post_ids( 'bulli-feature' );

        $wpml_languages = ['es', 'de', 'fr'];

        $export = [];

        foreach( $builder_ids as $builder_id ){
            set_time_limit( 50 );

            foreach ( $industry_ids as $industry_id ){
                foreach ( $feature_ids as $feature_id ){
                    $value = bulli_get_feature_value_from_acf( $builder_id, $industry_id, $feature_id );
                    $comment = bulli_get_feature_comment_from_acf( $builder_id, $industry_id, $feature_id );
                    if ( ! bulli_is_empty_recursively( $value ) ){
                        $export[$builder_id][$industry_id][$feature_id]['value']['--'] = $value;
                    }
                    if ( $comment ){
                        $export[$builder_id][$industry_id][$feature_id]['comment']['--'] = $comment;
                    }

                    foreach ( $wpml_languages as $language ){
                        $value = bulli_get_feature_value_from_acf( $builder_id, $industry_id, $feature_id, $language );
                        $comment = bulli_get_feature_comment_from_acf( $builder_id, $industry_id, $feature_id, $language );
                        if ( ! bulli_is_empty_recursively( $value ) ){
                            $export[$builder_id][$industry_id][$feature_id]['value'][$language] = $value;
                        }
                        if ( $comment ){
                            $export[$builder_id][$industry_id][$feature_id]['comment'][$language] = $comment;
                        }
                    }
                }
            }
        }

        echo serialize( $export );
        die();
    }
}


function bulli_get_post_ids( $post_type ){
    $query = new WP_Query( array(
        'post_type' => $post_type,
        'post_status' => 'publish',
        'posts_per_page' => 200,
        'fields' => 'ids',
    ) );
    return $query->get_posts();
}

function bulli_get_feature_value_from_acf( int $builder_id, int $industry_id, int $feature_id, string $language_key = '' ){
    $industry_prefix = $industry_id ? get_post( $industry_id )->post_name : 'default';
    $field_name = $industry_prefix . '_group_field_' . $industry_prefix . '_feat_' . $feature_id;
    $field_name .= $language_key ? '_' . $language_key : '';
    $value = get_field( $field_name, $builder_id );
    if ( is_array( $value ) ){
        foreach ( $value as $key => $row ){
            if ( isset( $value[$key]['monthly_price']['dollars'] ) ){
                $value[$key]['monthly_price']['USD'] = $value[$key]['monthly_price']['dollars'];
                unset( $value[$key]['monthly_price']['dollars'] );
            }
            if ( isset( $value[$key]['annual_price']['dollars'] ) ){
                $value[$key]['annual_price']['USD'] = $value[$key]['annual_price']['dollars'];
                unset( $value[$key]['annual_price']['dollars'] );
            }
        }
    }

    return $value;
}

function bulli_get_feature_comment_from_acf( int $builder_id, int $industry_id, int $feature_id, string $language_key = '' ){
    $industry_prefix = $industry_id ? get_post( $industry_id )->post_name : 'default';
    $field_suffix = $language_key ? '_' .  $language_key . '_comment' : '_comment';
    $comment = get_field( $industry_prefix . '_group_field_' . $industry_prefix . '_feat_' . $feature_id . $field_suffix, $builder_id );;
    $comment = nl2br( $comment ) ;
    return $comment;
}

function bulli_is_empty_recursively ( $var ) {
        if ( is_array( $var ) ) {
                foreach ( $var as $value ) {
                        if ( is_array( $value ) ) {
                                if ( ! bulli_is_empty_recursively( $value ) ) {
                                        return false;
                }
            }elseif ( ! empty( $value ) ) {
                                return false;
            }
        }
    } elseif ( ! empty( $var ) ) {
                return false;
    }
    return true;
}

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.