예제 #1
0
/**
*	Export CSV helper
*/
function pmxe_export_csv($exportQuery, $exportOptions, $preview = false, $is_cron = false, $file_path = false, $exported_by_cron = 0)
{
    ob_start();
    // Prepare headers
    $headers = array();
    $stream = fopen("php://output", 'w');
    $max_attach_count = 0;
    $max_images_count = 0;
    $cf = array();
    $woo = array();
    $woo_order = array();
    $acfs = array();
    $taxes = array();
    $attributes = array();
    $articles = array();
    $implode_delimiter = $exportOptions['delimiter'] == ',' ? '|' : ',';
    while ($exportQuery->have_posts()) {
        $attach_count = 0;
        $images_count = 0;
        $exportQuery->the_post();
        $record = get_post(get_the_ID());
        $article = array();
        $article['post_type'] = $record->post_type;
        $article['ID'] = apply_filters('pmxe_post_id', get_the_ID());
        $article['permalink'] = get_permalink();
        global $wpdb;
        $table_prefix = $wpdb->prefix;
        if ($exportOptions['ids']) {
            if (wp_all_export_is_compatible() and $exportOptions['is_generate_import'] and $exportOptions['import_id']) {
                $postRecord = new PMXI_Post_Record();
                $postRecord->clear();
                $postRecord->getBy(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id']));
                if ($postRecord->isEmpty()) {
                    $postRecord->set(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id'], 'unique_key' => $record->ID, 'product_key' => get_post_meta($record->ID, '_sku', true)))->save();
                }
                unset($postRecord);
            }
            foreach ($exportOptions['ids'] as $ID => $value) {
                if (is_numeric($ID)) {
                    if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                        continue;
                    }
                    $element_name = !empty($exportOptions['cc_name'][$ID]) ? $exportOptions['cc_name'][$ID] : 'untitled_' . $ID;
                    $fieldSnipped = (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) ? $exportOptions['cc_code'][$ID] : false;
                    switch ($exportOptions['cc_type'][$ID]) {
                        case 'id':
                            $article[$element_name] = apply_filters('pmxe_post_id', pmxe_filter(get_the_ID(), $fieldSnipped), get_the_ID());
                            break;
                        case 'permalink':
                            $article[$element_name] = apply_filters('pmxe_post_guid', pmxe_filter(get_permalink(), $fieldSnipped), get_the_ID());
                            break;
                        case 'post_type':
                            $pType = get_post_type();
                            if ($pType == 'product_variation') {
                                $pType = 'product';
                            }
                            $article[$element_name] = apply_filters('pmxe_post_type', pmxe_filter($pType, $fieldSnipped), get_the_ID());
                            break;
                        case 'title':
                            $article[$element_name] = apply_filters('pmxe_post_title', pmxe_filter($record->post_title, $fieldSnipped), get_the_ID());
                            break;
                        case 'content':
                            $val = apply_filters('pmxe_post_content', pmxe_filter($record->post_content, $fieldSnipped), get_the_ID());
                            $article[$element_name] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val;
                            break;
                        case 'media':
                            $attachment_ids = array();
                            $_featured_image = get_post_meta(get_the_ID(), '_thumbnail_id', true);
                            if (!empty($_featured_image)) {
                                $attachment_ids[] = $_featured_image;
                            }
                            $_gallery = get_post_meta(get_the_ID(), '_product_image_gallery', true);
                            if (!empty($_gallery)) {
                                $gallery = explode(',', $_gallery);
                                if (!empty($gallery) and is_array($gallery)) {
                                    foreach ($gallery as $aid) {
                                        if (!in_array($aid, $attachment_ids)) {
                                            $attachment_ids[] = $aid;
                                        }
                                    }
                                }
                            }
                            if (!empty($attachment_ids)) {
                                $img_urls = array();
                                $img_titles = array();
                                $img_captions = array();
                                $img_alts = array();
                                $img_descriptions = array();
                                foreach ($attachment_ids as $key => $attach_id) {
                                    $attach = get_post($attach_id);
                                    if (wp_attachment_is_image($attach->ID)) {
                                        $val = wp_get_attachment_url($attach->ID);
                                        if (!empty($exportOptions['cc_options'][$ID])) {
                                            switch ($exportOptions['cc_options'][$ID]) {
                                                case 'filenames':
                                                    $val = basename(wp_get_attachment_url($attach->ID));
                                                    break;
                                                case 'filepaths':
                                                    $val = get_attached_file($attach->ID);
                                                    break;
                                                default:
                                                    # code...
                                                    break;
                                            }
                                        }
                                        $img_urls[] = apply_filters('pmxe_attachment_url', $val, get_the_ID(), $attach->ID);
                                        $img_titles[] = apply_filters('pmxe_attachment_title', $attach->post_title, get_the_ID(), $attach->ID);
                                        $img_captions[] = apply_filters('pmxe_attachment_caption', $attach->post_excerpt, get_the_ID(), $attach->ID);
                                        $img_descriptions[] = apply_filters('pmxe_attachment_content', $attach->post_content, get_the_ID(), $attach->ID);
                                        $img_alts[] = apply_filters('pmxe_attachment_alt', get_post_meta($record->ID, '_wp_attachment_image_alt', true), get_the_ID(), $attach->ID);
                                        $images_count++;
                                    }
                                }
                                if (!empty($img_urls)) {
                                    $article[$element_name . '_images'] = implode($implode_delimiter, $img_urls);
                                }
                                if (!empty($img_titles)) {
                                    $article[$element_name . '_titles'] = implode($implode_delimiter, $img_titles);
                                }
                                if (!empty($img_captions)) {
                                    $article[$element_name . '_captions'] = implode($implode_delimiter, $img_captions);
                                }
                                if (!empty($img_alts)) {
                                    $article[$element_name . '_alts'] = implode($implode_delimiter, $img_alts);
                                }
                                if (!empty($img_descriptions)) {
                                    $article[$element_name . '_descriptions'] = implode($implode_delimiter, $img_descriptions);
                                }
                                if ($max_images_count > $images_count) {
                                    $max_images_count = $images_count;
                                }
                            }
                            break;
                        case 'date':
                            if (!empty($exportOptions['cc_options'][$ID])) {
                                switch ($exportOptions['cc_options'][$ID]) {
                                    case 'unix':
                                        $post_date = get_post_time('U', true);
                                        break;
                                    default:
                                        $post_date = date($exportOptions['cc_options'][$ID], get_post_time('U', true));
                                        break;
                                }
                            } else {
                                $post_date = date("Ymd", get_post_time('U', true));
                            }
                            $article[$element_name] = apply_filters('pmxe_post_date', pmxe_filter($post_date, $fieldSnipped), get_the_ID());
                            break;
                        case 'attachments':
                            $attachment_imgs = get_posts(array('post_type' => 'attachment', 'posts_per_page' => -1, 'post_parent' => $record->ID));
                            if (!empty($attachment_imgs)) {
                                $attachment_urls = array();
                                foreach ($attachment_imgs as $key => $attach) {
                                    if (!wp_attachment_is_image($attach->ID)) {
                                        $attachment_urls[] = apply_filters('pmxe_attachment_url', pmxe_filter(wp_get_attachment_url($attach->ID), $fieldSnipped), get_the_ID(), $attach->ID);
                                        $attach_count++;
                                    }
                                }
                                if (!empty($attachment_urls)) {
                                    $article[$element_name . '_attachments'] = implode($implode_delimiter, $attachment_urls);
                                }
                                if ($attach_count > $max_attach_count) {
                                    $max_attach_count = $attach_count;
                                }
                            }
                            break;
                        case 'parent':
                            $article[$element_name] = apply_filters('pmxe_post_parent', pmxe_filter($record->post_parent, $fieldSnipped), get_the_ID());
                            break;
                        case 'template':
                            $article[$element_name] = apply_filters('pmxe_post_template', pmxe_filter(get_post_meta($record->ID, '_wp_page_template', true), $fieldSnipped), get_the_ID());
                            break;
                        case 'order':
                            $article[$element_name] = apply_filters('pmxe_menu_order', pmxe_filter($record->menu_order, $fieldSnipped), get_the_ID());
                            break;
                        case 'status':
                            $article[$element_name] = apply_filters('pmxe_post_status', pmxe_filter($record->post_status, $fieldSnipped), get_the_ID());
                            break;
                        case 'format':
                            $article[$element_name] = apply_filters('pmxe_post_format', pmxe_filter(get_post_format($record->ID), $fieldSnipped), get_the_ID());
                            break;
                        case 'author':
                            $article[$element_name] = apply_filters('pmxe_post_author', pmxe_filter($record->post_author, $fieldSnipped), get_the_ID());
                            break;
                        case 'slug':
                            $article[$element_name] = apply_filters('pmxe_post_slug', pmxe_filter($record->post_name, $fieldSnipped), get_the_ID());
                            break;
                        case 'excerpt':
                            $val = apply_filters('pmxe_post_excerpt', pmxe_filter($record->post_excerpt, $fieldSnipped), get_the_ID());
                            $article[$element_name] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val;
                            break;
                        case 'cf':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_post_meta($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        if (empty($article[$element_name])) {
                                            $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                            if (!in_array($element_name, $cf)) {
                                                $cf[] = $element_name;
                                            }
                                        } else {
                                            $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter($article[$element_name] . $implode_delimiter . maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                        }
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    if (empty($article[$element_name])) {
                                        $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                        if (!in_array($element_name, $cf)) {
                                            $cf[] = $element_name;
                                        }
                                    }
                                    // else{
                                    // 	$article[$element_name . '_' . $key] = apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                    // 	if (!in_array($element_name . '_' . $key, $cf)) $cf[] = $element_name . '_' . $key;
                                    // }
                                }
                            }
                            break;
                        case 'acf':
                            if (!empty($exportOptions['cc_label'][$ID]) and class_exists('acf')) {
                                global $acf;
                                $field_options = unserialize($exportOptions['cc_options'][$ID]);
                                switch ($field_options['type']) {
                                    case 'textarea':
                                    case 'oembed':
                                    case 'wysiwyg':
                                    case 'wp_wysiwyg':
                                    case 'date_time_picker':
                                    case 'date_picker':
                                        $field_value = get_field($exportOptions['cc_label'][$ID], $record->ID, false);
                                        break;
                                    default:
                                        $field_value = get_field($exportOptions['cc_label'][$ID], $record->ID);
                                        break;
                                }
                                pmxe_export_acf_field_csv($field_value, $exportOptions, $ID, $record->ID, $article, $acfs, $element_name, $fieldSnipped, $field_options['group_id'], $preview);
                            }
                            break;
                        case 'woo':
                            //$element_name = 'woo' . $element_name;
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_post_meta($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        switch ($exportOptions['cc_label'][$ID]) {
                                            case '_downloadable_files':
                                                $files = maybe_unserialize($cur_meta_value);
                                                $file_paths = array();
                                                $file_names = array();
                                                if (!empty($files)) {
                                                    foreach ($files as $key => $file) {
                                                        $file_paths[] = $file['file'];
                                                        $file_names[] = $file['name'];
                                                    }
                                                    $article[$element_name . '_paths'] = implode($implode_delimiter, $file_paths);
                                                    if (!in_array($element_name, $woo)) {
                                                        $woo[] = $element_name . '_paths';
                                                    }
                                                    $article[$element_name . '_names'] = implode($implode_delimiter, $file_names);
                                                    if (!in_array($element_name, $woo)) {
                                                        $woo[] = $element_name . '_names';
                                                    }
                                                }
                                                break;
                                            case '_crosssell_ids':
                                            case '_upsell_ids':
                                                $_upsell_ids = maybe_unserialize($cur_meta_value);
                                                $_skus = array();
                                                if (!empty($_upsell_ids)) {
                                                    foreach ($_upsell_ids as $_upsell_id) {
                                                        $_skus[] = get_post_meta($_upsell_id, '_sku', true);
                                                    }
                                                    $article[$element_name] = implode($implode_delimiter, $_skus);
                                                    $woo[] = $element_name;
                                                }
                                                break;
                                            default:
                                                if (empty($article[$element_name])) {
                                                    $article[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                                    if (!in_array($element_name, $woo)) {
                                                        $woo[] = $element_name;
                                                    }
                                                } else {
                                                    $article[$element_name . '_' . $key] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                                    if (!in_array($element_name . '_' . $key, $woo)) {
                                                        $woo[] = $element_name . '_' . $key;
                                                    }
                                                }
                                                break;
                                        }
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    if (empty($article[$element_name])) {
                                        $article[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                        if (!in_array($element_name, $woo)) {
                                            $woo[] = $element_name;
                                        }
                                        switch ($exportOptions['cc_label'][$ID]) {
                                            case '_downloadable_files':
                                                if (!in_array($element_name, $woo)) {
                                                    $woo[] = $element_name . '_paths';
                                                }
                                                if (!in_array($element_name, $woo)) {
                                                    $woo[] = $element_name . '_names';
                                                }
                                                break;
                                        }
                                    }
                                }
                            }
                            break;
                        case 'woo_order':
                            XmlExportWooCommerceOrder::getInstance()->export_csv($article, $woo_order, $record, $exportOptions, $ID);
                            break;
                        case 'attr':
                            //$element_name = 'woo_' . $element_name;
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                if ($record->post_parent == 0) {
                                    // $is_variable_product = false;
                                    // $product_terms = wp_get_post_terms( $record->ID, 'product_type' );
                                    // if( ! empty($product_terms)){
                                    // 			if( ! is_wp_error( $product_terms )){
                                    // 				foreach($product_terms as $term){
                                    // 					if ('variable' == $term->slug){
                                    // 						$is_variable_product = true;
                                    // 						break;
                                    // 					}
                                    // 				}
                                    // 			}
                                    // 		}
                                    $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                    if (!is_wp_error($txes_list) and !empty($txes_list)) {
                                        $attr_new = array();
                                        foreach ($txes_list as $t) {
                                            $attr_new[] = $t->slug;
                                        }
                                        //$element_name = ($is_variable_product) ? $element_name : 'attribute_' . $element_name;
                                        $article[$element_name] = apply_filters('pmxe_woo_attribute', pmxe_filter(implode($implode_delimiter, $attr_new), $fieldSnipped), get_the_ID());
                                    }
                                    if (!in_array($element_name, $attributes)) {
                                        $attributes[] = $element_name;
                                    }
                                } else {
                                    $attribute_pa = get_post_meta($record->ID, 'attribute_' . $exportOptions['cc_value'][$ID], true);
                                    //if ( ! empty($attribute_pa)){
                                    $article['attribute_' . $element_name] = $attribute_pa;
                                    //}
                                    if (!in_array('attribute_' . $element_name, $attributes)) {
                                        $attributes[] = 'attribute_' . $element_name;
                                    }
                                }
                            }
                            break;
                        case 'cats':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!is_wp_error($txes_list) and !empty($txes_list)) {
                                    $txes_ids = array();
                                    $hierarchy_groups = array();
                                    foreach ($txes_list as $t) {
                                        $txes_ids[] = $t->term_id;
                                    }
                                    foreach ($txes_list as $t) {
                                        if (wp_all_export_check_children_assign($t->term_id, $exportOptions['cc_value'][$ID], $txes_ids)) {
                                            $ancestors = get_ancestors($t->term_id, $exportOptions['cc_value'][$ID]);
                                            if (count($ancestors) > 0) {
                                                $hierarchy_group = array();
                                                for ($i = count($ancestors) - 1; $i >= 0; $i--) {
                                                    $term = get_term_by('id', $ancestors[$i], $exportOptions['cc_value'][$ID]);
                                                    if ($term) {
                                                        $hierarchy_group[] = $term->slug;
                                                    }
                                                }
                                                $hierarchy_group[] = $t->slug;
                                                $hierarchy_groups[] = implode('>', $hierarchy_group);
                                            } else {
                                                $hierarchy_groups[] = $t->slug;
                                            }
                                        }
                                    }
                                    if (!empty($hierarchy_groups)) {
                                        $article[$element_name] = apply_filters('pmxe_post_taxonomy', pmxe_filter(implode($implode_delimiter, $hierarchy_groups), $fieldSnipped), get_the_ID());
                                    }
                                }
                                if (!in_array($element_name, $taxes)) {
                                    $taxes[] = $element_name;
                                }
                                if ($exportOptions['cc_label'][$ID] == 'product_type' and get_post_type() == 'product_variation') {
                                    $article[$element_name] = 'variable';
                                    $article['parent_sku'] = get_post_meta($record->post_parent, '_sku', true);
                                }
                            }
                            break;
                        case 'sql':
                            if (!empty($exportOptions['cc_sql'][$ID])) {
                                $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $exportOptions['cc_sql'][$ID])), get_the_ID()));
                                if (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) {
                                    // if shortcode defined
                                    if (strpos($exportOptions['cc_code'][$ID], '[') === 0) {
                                        $val = do_shortcode(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID]));
                                    } else {
                                        $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID])) . ';');
                                    }
                                }
                                $article[$element_name] = apply_filters('pmxe_sql_field', $val, $element_name, get_the_ID());
                            }
                            break;
                        default:
                            # code...
                            break;
                    }
                }
            }
        }
        $articles[] = $article;
        $articles = apply_filters('wp_all_export_csv_rows', $articles, $exportOptions);
        if ($preview) {
            break;
        }
    }
    if ($exportOptions['ids']) {
        foreach ($exportOptions['ids'] as $ID => $value) {
            if (is_numeric($ID)) {
                if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                    continue;
                }
                $element_name = !empty($exportOptions['cc_name'][$ID]) ? $exportOptions['cc_name'][$ID] : 'untitled_' . $ID;
                switch ($exportOptions['cc_type'][$ID]) {
                    case 'media':
                        $headers[] = $element_name . '_images';
                        $headers[] = $element_name . '_titles';
                        $headers[] = $element_name . '_captions';
                        $headers[] = $element_name . '_descriptions';
                        $headers[] = $element_name . '_alts';
                        break;
                    case 'attachments':
                        $headers[] = $element_name . '_attachments';
                        break;
                    case 'cats':
                        if (!empty($taxes)) {
                            $tx = array_shift($taxes);
                            $headers[] = $tx;
                            if ($tx == 'product_type') {
                                $headers[] = 'parent_sku';
                            }
                        }
                        break;
                    case 'attr':
                        if (!empty($attributes)) {
                            $headers[] = array_shift($attributes);
                            if (in_array('attribute_' . $element_name, $attributes)) {
                                $headers[] = 'attribute_' . $element_name;
                                foreach ($attributes as $akey => $avalue) {
                                    if ($avalue == 'attribute_' . $element_name) {
                                        unset($attributes[$akey]);
                                        break;
                                    }
                                }
                            }
                        }
                        break;
                    case 'cf':
                        if (!empty($cf)) {
                            $headers[] = array_shift($cf);
                        }
                        break;
                    case 'woo':
                        if (!empty($woo)) {
                            $headers[] = array_shift($woo);
                        }
                        break;
                    case 'woo_order':
                        XmlExportWooCommerceOrder::getInstance()->get_element_header($headers, $exportOptions, $ID);
                        break;
                    case 'acf':
                        if (!empty($acfs)) {
                            $headers[] = array_shift($acfs);
                        }
                        break;
                    default:
                        $headers[] = $element_name;
                        break;
                }
            }
        }
    }
    if ($is_cron) {
        if (!$exported_by_cron) {
            fputcsv($stream, $headers, $exportOptions['delimiter']);
        }
    } else {
        if ($preview or empty(PMXE_Plugin::$session->file)) {
            fputcsv($stream, $headers, $exportOptions['delimiter']);
        }
    }
    foreach ($articles as $article) {
        $line = array();
        foreach ($headers as $header) {
            $line[$header] = isset($article[$header]) ? $article[$header] : '';
        }
        fputcsv($stream, $line, $exportOptions['delimiter']);
    }
    if ($preview) {
        return ob_get_clean();
    }
    if ($is_cron) {
        file_put_contents($file_path, ob_get_clean(), FILE_APPEND);
        return $file_path;
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            $is_secure_import = PMXE_Plugin::getInstance()->getOption('secure');
            $wp_uploads = wp_upload_dir();
            $target = $is_secure_import ? wp_all_export_secure_file($wp_uploads['basedir'] . DIRECTORY_SEPARATOR . PMXE_Plugin::UPLOADS_DIRECTORY) : $wp_uploads['path'];
            $export_file = $target . DIRECTORY_SEPARATOR . time() . '.' . $exportOptions['export_to'];
            file_put_contents($export_file, ob_get_clean());
            PMXE_Plugin::$session->set('file', $export_file);
            PMXE_Plugin::$session->save_data();
        } else {
            file_put_contents(PMXE_Plugin::$session->file, ob_get_clean(), FILE_APPEND);
        }
        return true;
    }
}
 protected function prepare_export_data($record, $options, $elId)
 {
     $data = array();
     if (!empty($options['cc_value'][$elId])) {
         $implode_delimiter = $options['delimiter'] == ',' ? '|' : ',';
         $element_name = !empty($options['cc_name'][$elId]) ? $options['cc_name'][$elId] : 'untitled_' . $elId;
         $fieldSnipped = (!empty($options['cc_php'][$elId]) and !empty($options['cc_code'][$elId])) ? $options['cc_code'][$elId] : false;
         switch ($options['cc_value'][$elId]) {
             case 'attributes':
                 $_product_attributes = empty($record->post_parent) ? get_post_meta($record->ID, '_product_attributes', true) : get_post_meta($record->post_parent, '_product_attributes', true);
                 if (empty(self::$_existing_attributes)) {
                     global $wp_taxonomies;
                     foreach ($wp_taxonomies as $key => $obj) {
                         if (in_array($obj->name, array('nav_menu'))) {
                             continue;
                         }
                         if (strpos($obj->name, "pa_") === 0 and strlen($obj->name) > 3 and !in_array($obj->name, self::$_existing_attributes)) {
                             self::$_existing_attributes[] = $obj->name;
                         }
                     }
                 }
                 // combine taxonomies attributes
                 if (!empty(self::$_existing_attributes)) {
                     foreach (self::$_existing_attributes as $taxonomy_slug) {
                         $taxonomy = get_taxonomy($taxonomy_slug);
                         $data['Attribute Name (' . $taxonomy_slug . ')'] = $taxonomy->labels->name;
                         $data['Attribute In Variations (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_variation']) ? "yes" : "no";
                         $data['Attribute Is Visible (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_visible']) ? "yes" : "no";
                         $data['Attribute Is Taxonomy (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_taxonomy']) ? "yes" : "no";
                         $element_name = 'Attribute Value (' . $taxonomy_slug . ')';
                         if ($record->post_parent == 0) {
                             $txes_list = get_the_terms($record->ID, $taxonomy_slug);
                             if (!is_wp_error($txes_list) and !empty($txes_list)) {
                                 $attr_new = array();
                                 foreach ($txes_list as $t) {
                                     $attr_new[] = $t->name;
                                 }
                                 $data[$element_name] = apply_filters('pmxe_woo_attribute', pmxe_filter(implode($implode_delimiter, $attr_new), $fieldSnipped), $record->ID);
                             } else {
                                 $data[$element_name] = '';
                             }
                         } else {
                             $data[$element_name] = get_post_meta($record->ID, 'attribute_' . $taxonomy_slug, true);
                         }
                     }
                 }
                 // combine custom attributes
                 if (!empty(self::$products_data['attributes'])) {
                     foreach (self::$products_data['attributes'] as $attribute) {
                         $attribute_standart_name = str_replace('attribute_', '', $attribute->meta_key);
                         $attribute_name = ucfirst($attribute_standart_name);
                         $data['Attribute Name (' . $attribute_name . ')'] = $attribute_name;
                         $data['Attribute Value (' . $attribute_name . ')'] = get_post_meta($record->ID, $attribute->meta_key, true);
                         $data['Attribute In Variations (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_variation']) ? "yes" : "no";
                         $data['Attribute Is Visible (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_visible']) ? "yes" : "no";
                         $data['Attribute Is Taxonomy (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_taxonomy']) ? "yes" : "no";
                     }
                 }
                 break;
             default:
                 $cur_meta_values = get_post_meta($record->ID, $options['cc_value'][$elId]);
                 if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                     foreach ($cur_meta_values as $key => $cur_meta_value) {
                         switch ($options['cc_label'][$elId]) {
                             case '_downloadable_files':
                                 $files = maybe_unserialize($cur_meta_value);
                                 $file_paths = array();
                                 $file_names = array();
                                 if (!empty($files)) {
                                     foreach ($files as $key => $file) {
                                         $file_paths[] = $file['file'];
                                         $file_names[] = $file['name'];
                                     }
                                     $data[$element_name . ' Paths'] = implode($implode_delimiter, $file_paths);
                                     $data[$element_name . ' Names'] = implode($implode_delimiter, $file_names);
                                 }
                                 break;
                             case '_crosssell_ids':
                             case '_upsell_ids':
                                 $_upsell_ids = maybe_unserialize($cur_meta_value);
                                 $_skus = array();
                                 if (!empty($_upsell_ids)) {
                                     foreach ($_upsell_ids as $_upsell_id) {
                                         $_skus[] = get_post_meta($_upsell_id, '_sku', true);
                                     }
                                     $data[$element_name] = implode($implode_delimiter, $_skus);
                                 }
                                 break;
                             default:
                                 if (empty($data[$element_name])) {
                                     $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $options['cc_value'][$elId], $record->ID);
                                 } else {
                                     $data[$element_name . '_' . $key] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $options['cc_value'][$elId], $record->ID);
                                 }
                                 break;
                         }
                     }
                 }
                 if (empty($cur_meta_values)) {
                     $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter('', $fieldSnipped), $options['cc_value'][$elId], $record->ID);
                 }
                 break;
         }
     }
     return $data;
 }
예제 #3
0
 public static function prepare_data($entry, $xmlWriter = false, &$acfs, &$woo, &$woo_order, $implode_delimiter, $preview, $is_item_data = false, $subID = false)
 {
     $article = array();
     // associate exported post with import
     if (!$is_item_data and wp_all_export_is_compatible() and XmlExportEngine::$exportOptions['is_generate_import'] and XmlExportEngine::$exportOptions['import_id']) {
         $postRecord = new PMXI_Post_Record();
         $postRecord->clear();
         $postRecord->getBy(array('post_id' => $entry->ID, 'import_id' => XmlExportEngine::$exportOptions['import_id']));
         if ($postRecord->isEmpty()) {
             $postRecord->set(array('post_id' => $entry->ID, 'import_id' => XmlExportEngine::$exportOptions['import_id'], 'unique_key' => $entry->ID, 'product_key' => $entry->ID))->save();
         }
         unset($postRecord);
     }
     $is_xml_export = false;
     if (!empty($xmlWriter) and XmlExportEngine::$exportOptions['export_to'] == 'xml' and !in_array(XmlExportEngine::$exportOptions['xml_template_type'], array('custom', 'XmlGoogleMerchants'))) {
         $is_xml_export = true;
     }
     foreach (XmlExportEngine::$exportOptions['ids'] as $ID => $value) {
         $pType = $entry->post_type;
         if ($is_item_data and $subID != $ID) {
             continue;
         }
         // skip shop order items data
         if ($pType == "shop_order" and strpos(XmlExportEngine::$exportOptions['cc_label'][$ID], "item_data__") !== false and !$is_item_data) {
             continue;
         }
         $fieldName = XmlExportEngine::$exportOptions['cc_name'][$ID];
         $fieldValue = str_replace("item_data__", "", XmlExportEngine::$exportOptions['cc_value'][$ID]);
         $fieldLabel = str_replace("item_data__", "", XmlExportEngine::$exportOptions['cc_label'][$ID]);
         $fieldSql = XmlExportEngine::$exportOptions['cc_sql'][$ID];
         $fieldPhp = XmlExportEngine::$exportOptions['cc_php'][$ID];
         $fieldCode = XmlExportEngine::$exportOptions['cc_code'][$ID];
         $fieldType = XmlExportEngine::$exportOptions['cc_type'][$ID];
         $fieldOptions = XmlExportEngine::$exportOptions['cc_options'][$ID];
         $fieldSettings = empty(XmlExportEngine::$exportOptions['cc_settings'][$ID]) ? $fieldOptions : XmlExportEngine::$exportOptions['cc_settings'][$ID];
         if (empty($fieldName) or empty($fieldType) or !is_numeric($ID)) {
             continue;
         }
         $element_name = !empty($fieldName) ? $fieldName : 'untitled_' . $ID;
         $element_name_ns = '';
         if ($is_xml_export) {
             $element_name = !empty($fieldName) ? preg_replace('/[^a-z0-9_:-]/i', '', $fieldName) : 'untitled_' . $ID;
             if (strpos($element_name, ":") !== false) {
                 $element_name_parts = explode(":", $element_name);
                 $element_name_ns = empty($element_name_parts[0]) ? '' : $element_name_parts[0];
                 $element_name = empty($element_name_parts[1]) ? 'untitled_' . $ID : preg_replace('/[^a-z0-9_-]/i', '', $element_name_parts[1]);
             }
         }
         $fieldSnipped = (!empty($fieldPhp) and !empty($fieldCode)) ? $fieldCode : false;
         switch ($fieldType) {
             case 'id':
                 if ($element_name == 'ID') {
                     $element_name = 'id';
                 }
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_id', pmxe_filter($entry->ID, $fieldSnipped), $entry->ID));
                 break;
             case 'permalink':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_guid', pmxe_filter(get_permalink(), $fieldSnipped), $entry->ID));
                 break;
             case 'post_type':
                 if ($entry->post_type == 'product_variation') {
                     $pType = 'product';
                 }
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_type', pmxe_filter($pType, $fieldSnipped), $entry->ID));
                 break;
             case 'title':
                 $val = apply_filters('pmxe_post_title', pmxe_filter($entry->post_title, $fieldSnipped));
                 wp_all_export_write_article($article, $element_name, $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val, $entry->ID);
                 break;
             case 'content':
                 $val = apply_filters('pmxe_post_content', pmxe_filter($entry->post_content, $fieldSnipped), $entry->ID);
                 wp_all_export_write_article($article, $element_name, $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val);
                 break;
                 // Media Attachments
             // Media Attachments
             case 'attachments':
             case 'attachment_id':
             case 'attachment_url':
             case 'attachment_filename':
             case 'attachment_path':
             case 'attachment_title':
             case 'attachment_caption':
             case 'attachment_description':
             case 'attachment_alt':
                 XmlExportMediaGallery::getInstance($entry->ID);
                 $attachment_data = XmlExportMediaGallery::get_attachments($fieldType);
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_' . $fieldType, pmxe_filter(implode($implode_delimiter, $attachment_data), $fieldSnipped), $entry->ID));
                 break;
                 // Media Images
             // Media Images
             case 'media':
             case 'image_id':
             case 'image_url':
             case 'image_filename':
             case 'image_path':
             case 'image_title':
             case 'image_caption':
             case 'image_description':
             case 'image_alt':
                 $field_options = json_decode($fieldOptions, true);
                 XmlExportMediaGallery::getInstance($entry->ID);
                 $images_data = XmlExportMediaGallery::get_images($fieldType, $field_options);
                 $images_separator = empty($field_options['image_separator']) ? $implode_delimiter : $field_options['image_separator'];
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_' . $fieldType, pmxe_filter(implode($images_separator, $images_data), $fieldSnipped), $entry->ID));
                 break;
             case 'date':
                 if (!empty($fieldSettings)) {
                     switch ($fieldSettings) {
                         case 'unix':
                             $post_date = get_post_time('U', true, $entry->ID);
                             break;
                         default:
                             $post_date = date($fieldSettings, get_post_time('U', true, $entry->ID));
                             break;
                     }
                 } else {
                     $post_date = date("Ymd", get_post_time('U', true, $entry->ID));
                 }
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_date', pmxe_filter($post_date, $fieldSnipped), $entry->ID));
                 break;
             case 'parent':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_parent', pmxe_filter($entry->post_parent, $fieldSnipped), $entry->ID));
                 break;
             case 'comment_status':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_comment_status', pmxe_filter($entry->comment_status, $fieldSnipped), $entry->ID));
                 break;
             case 'ping_status':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_ping_status', pmxe_filter($entry->ping_status, $fieldSnipped), $entry->ID));
                 break;
             case 'template':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_template', pmxe_filter(get_post_meta($entry->ID, '_wp_page_template', true), $fieldSnipped), $entry->ID));
                 break;
             case 'order':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_menu_order', pmxe_filter($entry->menu_order, $fieldSnipped), $entry->ID));
                 break;
             case 'status':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_status', pmxe_filter($entry->post_status, $fieldSnipped), $entry->ID));
                 break;
             case 'format':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_format', pmxe_filter(get_post_format($entry->ID), $fieldSnipped), $entry->ID));
                 break;
             case 'author':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_author', pmxe_filter($entry->post_author, $fieldSnipped), $entry->ID));
                 break;
             case 'slug':
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_slug', pmxe_filter($entry->post_name, $fieldSnipped), $entry->ID));
                 break;
             case 'excerpt':
                 $val = apply_filters('pmxe_post_excerpt', pmxe_filter($entry->post_excerpt, $fieldSnipped), $entry->ID);
                 wp_all_export_write_article($article, $element_name, $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val);
                 break;
             case 'cf':
                 if (!empty($fieldValue)) {
                     $val = "";
                     $cur_meta_values = get_post_meta($entry->ID, $fieldValue);
                     if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                         foreach ($cur_meta_values as $key => $cur_meta_value) {
                             if (empty($val)) {
                                 $val = apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $fieldValue, $entry->ID);
                             } else {
                                 $val = apply_filters('pmxe_custom_field', pmxe_filter($val . $implode_delimiter . maybe_serialize($cur_meta_value), $fieldSnipped), $fieldValue, $entry->ID);
                             }
                         }
                         wp_all_export_write_article($article, $element_name, $val);
                     }
                     if (empty($cur_meta_values)) {
                         if (empty($article[$element_name])) {
                             wp_all_export_write_article($article, $element_name, apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $fieldValue, $entry->ID));
                         }
                     }
                 }
                 break;
             case 'acf':
                 if (!empty($fieldLabel) and class_exists('acf')) {
                     global $acf;
                     $field_options = unserialize($fieldOptions);
                     if (!$is_xml_export) {
                         switch ($field_options['type']) {
                             case 'textarea':
                             case 'oembed':
                             case 'wysiwyg':
                             case 'wp_wysiwyg':
                             case 'date_time_picker':
                             case 'date_picker':
                                 $field_value = get_field($fieldLabel, $entry->ID, false);
                                 break;
                             default:
                                 $field_value = get_field($fieldLabel, $entry->ID);
                                 break;
                         }
                     } else {
                         $field_value = get_field($fieldLabel, $entry->ID);
                     }
                     XmlExportACF::export_acf_field($field_value, XmlExportEngine::$exportOptions, $ID, $entry->ID, $article, $xmlWriter, $acfs, $element_name, $element_name_ns, $fieldSnipped, $field_options['group_id'], $preview);
                 }
                 break;
             case 'woo':
                 if ($is_xml_export) {
                     XmlExportEngine::$woo_export->export_xml($xmlWriter, $entry, XmlExportEngine::$exportOptions, $ID);
                 } else {
                     XmlExportEngine::$woo_export->export_csv($article, $woo, $entry, XmlExportEngine::$exportOptions, $ID);
                 }
                 break;
             case 'woo_order':
                 if ($is_xml_export) {
                     XmlExportEngine::$woo_order_export->export_xml($xmlWriter, $entry, XmlExportEngine::$exportOptions, $ID, $preview);
                 } else {
                     XmlExportEngine::$woo_order_export->export_csv($article, $woo_order, $entry, XmlExportEngine::$exportOptions, $ID, $preview);
                 }
                 break;
             case 'attr':
                 if (!empty($fieldValue)) {
                     if ($entry->post_parent == 0) {
                         $txes_list = get_the_terms($entry->ID, $fieldValue);
                         if (!is_wp_error($txes_list) and !empty($txes_list)) {
                             $attr_new = array();
                             foreach ($txes_list as $t) {
                                 $attr_new[] = $t->name;
                             }
                             wp_all_export_write_article($article, $element_name, apply_filters('pmxe_woo_attribute', pmxe_filter(implode($implode_delimiter, $attr_new), $fieldSnipped), $entry->ID, $fieldValue));
                         }
                     } else {
                         $attribute_pa = apply_filters('pmxe_woo_attribute', get_post_meta($entry->ID, 'attribute_' . $fieldValue, true), $entry->ID, $fieldValue);
                         wp_all_export_write_article($article, $element_name, $attribute_pa);
                     }
                     // if ( ! in_array($element_name, $attributes)) $attributes[] = $element_name;
                 }
                 break;
             case 'cats':
                 if (!empty($fieldValue)) {
                     // get categories from parent product in case when variation exported
                     $entry_id = $entry->post_type == 'product_variation' ? $entry->post_parent : $entry->ID;
                     $txes_list = get_the_terms($entry_id, $fieldValue);
                     $hierarchy_groups = array();
                     if (!is_wp_error($txes_list) and !empty($txes_list)) {
                         $txes_ids = array();
                         foreach ($txes_list as $t) {
                             $txes_ids[] = $t->term_id;
                         }
                         foreach ($txes_list as $t) {
                             if (wp_all_export_check_children_assign($t->term_id, $fieldValue, $txes_ids)) {
                                 $ancestors = get_ancestors($t->term_id, $fieldValue);
                                 if (count($ancestors) > 0) {
                                     $hierarchy_group = array();
                                     for ($i = count($ancestors) - 1; $i >= 0; $i--) {
                                         $term = get_term_by('id', $ancestors[$i], $fieldValue);
                                         if ($term) {
                                             $hierarchy_group[] = $term->name;
                                         }
                                     }
                                     $hierarchy_group[] = $t->name;
                                     $hierarchy_groups[] = implode('>', $hierarchy_group);
                                 } else {
                                     $hierarchy_groups[] = $t->name;
                                 }
                             }
                         }
                         // if ( empty($hierarchy_groups) ) $hierarchy_groups = '';
                     }
                     wp_all_export_write_article($article, $element_name, apply_filters('pmxe_post_taxonomy', pmxe_filter(implode($implode_delimiter, $hierarchy_groups), $fieldSnipped), $entry->ID));
                     // if ( ! in_array($element_name, $taxes)) $taxes[] = $element_name;
                     if ($fieldLabel == 'product_type') {
                         if ($entry->post_type == 'product_variation') {
                             $article[$element_name] = 'variable';
                         }
                         $article['parent_id'] = $entry->post_parent;
                         if ($is_xml_export) {
                             $xmlWriter->beginElement($element_name_ns, 'parent_id', null);
                             $xmlWriter->writeData($article['parent_id'], 'parent_id');
                             $xmlWriter->closeElement();
                         }
                     }
                 }
                 break;
             case 'sql':
                 if (!empty($fieldSql)) {
                     global $wpdb;
                     $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $fieldSql)), $entry->ID));
                     if (!empty($fieldPhp) and !empty($fieldCode)) {
                         // if shortcode defined
                         if (strpos($fieldCode, '[') === 0) {
                             $val = do_shortcode(str_replace("%%VALUE%%", $val, $fieldCode));
                         } else {
                             $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $fieldCode)) . ';');
                         }
                     }
                     wp_all_export_write_article($article, $element_name, apply_filters('pmxe_sql_field', $val, $element_name, $entry->ID));
                 }
                 break;
             case 'wpml_trid':
                 $post_type = get_post_type($entry->ID);
                 $post_type = apply_filters('wpml_element_type', $post_type);
                 $post_language_details = apply_filters('wpml_element_language_details', null, array('element_id' => $entry->ID, 'element_type' => $post_type));
                 $trid = empty($post_language_details->trid) ? '' : $post_language_details->trid;
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_trid_field', $trid, $element_name, $entry->ID));
                 break;
             case 'wpml_lang':
                 $post_type = get_post_type($entry->ID);
                 $post_type = apply_filters('wpml_element_type', $post_type);
                 $post_language_details = apply_filters('wpml_element_language_details', null, array('element_id' => $entry->ID, 'element_type' => $post_type));
                 $language_code = empty($post_language_details->language_code) ? '' : $post_language_details->language_code;
                 wp_all_export_write_article($article, $element_name, apply_filters('pmxe_trid_field', $language_code, $element_name, $entry->ID));
                 break;
             default:
                 # code...
                 break;
         }
         if ($is_xml_export and isset($article[$element_name])) {
             $element_name_in_file = XmlCsvExport::_get_valid_header_name($element_name);
             $xmlWriter = apply_filters('wp_all_export_add_before_element', $xmlWriter, $element_name_in_file, XmlExportEngine::$exportID, $entry->ID);
             $xmlWriter->beginElement($element_name_ns, $element_name_in_file, null);
             $xmlWriter->writeData($article[$element_name], $element_name_in_file);
             $xmlWriter->closeElement();
             $xmlWriter = apply_filters('wp_all_export_add_after_element', $xmlWriter, $element_name_in_file, XmlExportEngine::$exportID, $entry->ID);
         }
     }
     return $article;
 }
예제 #4
0
/**
*	Export CSV helper
*/
function pmxe_export_users_csv($exportQuery, $exportOptions, $preview = false, $is_cron = false, $file_path = false, $exported_by_cron = 0)
{
    ob_start();
    // Prepare headers
    $headers = array();
    $stream = fopen("php://output", 'w');
    $max_attach_count = 0;
    $max_images_count = 0;
    $cf = array();
    $woo = array();
    $acfs = array();
    $taxes = array();
    $attributes = array();
    $articles = array();
    $implode_delimiter = $exportOptions['delimiter'] == ',' ? '|' : ',';
    foreach ($exportQuery->results as $user) {
        $attach_count = 0;
        $images_count = 0;
        //$exportQuery->the_post();
        //$record = get_post( get_the_ID() );
        $article = array();
        //$article['post_type'] = $record->post_type;
        $article['ID'] = apply_filters('pmxe_user_id', $user->ID);
        //$article['permalink'] = get_permalink();
        if ($exportOptions['ids']) {
            if (wp_all_export_is_compatible() and $exportOptions['is_generate_import'] and $exportOptions['import_id']) {
                $postRecord = new PMXI_Post_Record();
                $postRecord->clear();
                $postRecord->getBy(array('post_id' => $user->ID, 'import_id' => $exportOptions['import_id']));
                if ($postRecord->isEmpty()) {
                    $postRecord->set(array('post_id' => $user->ID, 'import_id' => $exportOptions['import_id'], 'unique_key' => $user->ID))->save();
                }
                unset($postRecord);
            }
            foreach ($exportOptions['ids'] as $ID => $value) {
                if (is_numeric($ID)) {
                    if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                        continue;
                    }
                    $element_name = !empty($exportOptions['cc_name'][$ID]) ? $exportOptions['cc_name'][$ID] : 'untitled_' . $ID;
                    $fieldSnipped = (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) ? $exportOptions['cc_code'][$ID] : false;
                    switch ($exportOptions['cc_type'][$ID]) {
                        case 'id':
                            $article[$element_name] = apply_filters('pmxe_user_id', pmxe_filter($user->ID, $fieldSnipped), $user->ID);
                            break;
                        case 'user_login':
                            $article[$element_name] = apply_filters('pmxe_user_login', pmxe_filter($user->user_login, $fieldSnipped), $user->ID);
                            break;
                        case 'user_pass':
                            $article[$element_name] = apply_filters('pmxe_user_pass', pmxe_filter($user->user_pass, $fieldSnipped), $user->ID);
                            break;
                        case 'user_email':
                            $article[$element_name] = apply_filters('pmxe_user_email', pmxe_filter($user->user_email, $fieldSnipped), $user->ID);
                            break;
                        case 'user_nicename':
                            $article[$element_name] = apply_filters('pmxe_user_nicename', pmxe_filter($user->user_nicename, $fieldSnipped), $user->ID);
                            break;
                        case 'user_url':
                            $article[$element_name] = apply_filters('pmxe_user_url', pmxe_filter($user->user_url, $fieldSnipped), $user->ID);
                            break;
                        case 'user_activation_key':
                            $article[$element_name] = apply_filters('pmxe_user_activation_key', pmxe_filter($user->user_activation_key, $fieldSnipped), $user->ID);
                            break;
                        case 'user_status':
                            $article[$element_name] = apply_filters('pmxe_user_status', pmxe_filter($user->user_status, $fieldSnipped), $user->ID);
                            break;
                        case 'display_name':
                            $article[$element_name] = apply_filters('pmxe_user_display_name', pmxe_filter($user->display_name, $fieldSnipped), $user->ID);
                            break;
                        case 'description':
                            $val = apply_filters('pmxe_user_description', pmxe_filter($user->description, $fieldSnipped), $user->ID);
                            $article[$element_name] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val;
                            break;
                        case 'user_registered':
                            if (!empty($exportOptions['cc_options'][$ID])) {
                                switch ($exportOptions['cc_options'][$ID]) {
                                    case 'unix':
                                        $post_date = strtotime($user->user_registered);
                                        break;
                                    default:
                                        $post_date = date($exportOptions['cc_options'][$ID], strtotime($user->user_registered));
                                        break;
                                }
                            } else {
                                $post_date = $user->user_registered;
                            }
                            $article[$element_name] = apply_filters('pmxe_user_registered', pmxe_filter($post_date, $fieldSnipped), $user->ID);
                            break;
                        case 'nickname':
                            $article[$element_name] = apply_filters('pmxe_user_nickname', pmxe_filter($user->nickname, $fieldSnipped), $user->ID);
                            break;
                        case 'first_name':
                            $article[$element_name] = apply_filters('pmxe_user_first_name', pmxe_filter($user->first_name, $fieldSnipped), $user->ID);
                            break;
                        case 'last_name':
                            $article[$element_name] = apply_filters('pmxe_user_last_name', pmxe_filter($user->last_name, $fieldSnipped), $user->ID);
                            break;
                        case 'wp_capabilities':
                            $article[$element_name] = apply_filters('pmxe_user_wp_capabilities', pmxe_filter(implode($implode_delimiter, $user->roles), $fieldSnipped), $user->ID);
                            break;
                        case 'cf':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_user_meta($user->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        if (empty($article[$element_name])) {
                                            $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], $user->ID);
                                            if (!in_array($element_name, $cf)) {
                                                $cf[] = $element_name;
                                            }
                                        } else {
                                            $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter($article[$element_name] . $implode_delimiter . maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], $user->ID);
                                        }
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    if (empty($article[$element_name])) {
                                        $article[$element_name] = apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], $user->ID);
                                        if (!in_array($element_name, $cf)) {
                                            $cf[] = $element_name;
                                        }
                                    }
                                    // else{
                                    // 	$article[$element_name . '_' . $key] = apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID());
                                    // 	if (!in_array($element_name . '_' . $key, $cf)) $cf[] = $element_name . '_' . $key;
                                    // }
                                }
                            }
                            break;
                        case 'acf':
                            if (!empty($exportOptions['cc_label'][$ID]) and class_exists('acf')) {
                                global $acf;
                                $field_options = unserialize($exportOptions['cc_options'][$ID]);
                                switch ($field_options['type']) {
                                    case 'textarea':
                                    case 'oembed':
                                    case 'wysiwyg':
                                    case 'wp_wysiwyg':
                                    case 'date_time_picker':
                                    case 'date_picker':
                                        $field_value = get_field($exportOptions['cc_label'][$ID], $user->ID, false);
                                        break;
                                    default:
                                        $field_value = get_field($exportOptions['cc_label'][$ID], $user->ID);
                                        break;
                                }
                                pmxe_export_acf_field_csv($field_value, $exportOptions, $ID, $user->ID, $article, $acfs, $element_name, $fieldSnipped, $field_options['group_id'], $preview);
                            }
                            break;
                        case 'sql':
                            if (!empty($exportOptions['cc_sql'][$ID])) {
                                global $wpdb;
                                $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $exportOptions['cc_sql'][$ID])), get_the_ID()));
                                if (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) {
                                    // if shortcode defined
                                    if (strpos($exportOptions['cc_code'][$ID], '[') === 0) {
                                        $val = do_shortcode(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID]));
                                    } else {
                                        $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID])) . ';');
                                    }
                                }
                                $article[$element_name] = apply_filters('pmxe_sql_field', $val, $element_name, get_the_ID());
                            }
                            break;
                        default:
                            # code...
                            break;
                    }
                }
            }
        }
        $articles[] = $article;
        if ($preview) {
            break;
        }
    }
    if ($exportOptions['ids']) {
        foreach ($exportOptions['ids'] as $ID => $value) {
            if (is_numeric($ID)) {
                if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                    continue;
                }
                $element_name = !empty($exportOptions['cc_name'][$ID]) ? $exportOptions['cc_name'][$ID] : 'untitled_' . $ID;
                switch ($exportOptions['cc_type'][$ID]) {
                    case 'cf':
                        if (!empty($cf)) {
                            $headers[] = array_shift($cf);
                        }
                        break;
                    case 'acf':
                        if (!empty($acfs)) {
                            $headers[] = array_shift($acfs);
                        }
                        break;
                    default:
                        $headers[] = $element_name;
                        break;
                }
            }
        }
    }
    if ($is_cron) {
        if (!$exported_by_cron) {
            fputcsv($stream, $headers, $exportOptions['delimiter']);
        }
    } else {
        if ($preview or empty(PMXE_Plugin::$session->file)) {
            fputcsv($stream, $headers, $exportOptions['delimiter']);
        }
    }
    foreach ($articles as $article) {
        $line = array();
        foreach ($headers as $header) {
            $line[$header] = isset($article[$header]) ? $article[$header] : '';
        }
        fputcsv($stream, $line, $exportOptions['delimiter']);
    }
    if ($preview) {
        return ob_get_clean();
    }
    if ($is_cron) {
        file_put_contents($file_path, ob_get_clean(), FILE_APPEND);
        return $file_path;
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            $is_secure_import = PMXE_Plugin::getInstance()->getOption('secure');
            $wp_uploads = wp_upload_dir();
            $target = $is_secure_import ? wp_all_export_secure_file($wp_uploads['basedir'] . DIRECTORY_SEPARATOR . PMXE_Plugin::UPLOADS_DIRECTORY) : $wp_uploads['path'];
            $export_file = $target . DIRECTORY_SEPARATOR . time() . '.' . $exportOptions['export_to'];
            file_put_contents($export_file, ob_get_clean());
            PMXE_Plugin::$session->set('file', $export_file);
            PMXE_Plugin::$session->save_data();
        } else {
            file_put_contents(PMXE_Plugin::$session->file, ob_get_clean(), FILE_APPEND);
        }
        return true;
    }
}
 protected function prepare_export_data($record, $options, $elId, $preview)
 {
     // an array with data to export
     $data = array('items' => array(), 'taxes' => array(), 'shipping' => array(), 'coupons' => array(), 'surcharge' => array());
     global $wpdb;
     $table_prefix = $wpdb->prefix;
     $implode_delimiter = XmlExportEngine::$implode;
     if (empty($this->order_id) or $this->order_id != $record->ID) {
         $this->order_id = $record->ID;
         $all_order_items = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_items WHERE order_id = {$record->ID}");
         if (!empty($all_order_items)) {
             foreach ($all_order_items as $item) {
                 switch ($item->order_item_type) {
                     case 'line_item':
                         $this->order_items[] = $item;
                         break;
                     case 'tax':
                         $this->order_taxes[] = $item;
                         break;
                     case 'shipping':
                         $this->order_shipping[] = $item;
                         break;
                     case 'coupon':
                         $this->order_coupons[] = $item;
                         break;
                     case 'fee':
                         $this->order_surcharge[] = $item;
                         break;
                 }
             }
         }
         $this->order_refunds = $wpdb->get_results("SELECT * FROM {$table_prefix}posts WHERE post_parent = {$record->ID} AND post_type = 'shop_order_refund'");
     }
     if (!empty($options['cc_value'][$elId])) {
         $is_items_in_list = false;
         $is_item_data_in_list = false;
         foreach ($options['ids'] as $ID => $value) {
             if ($options['cc_options'][$ID] == 'items') {
                 $is_items_in_list = true;
             }
             if (strpos($options['cc_label'][$ID], "item_data__") !== false) {
                 $is_item_data_in_list = true;
             }
         }
         $fieldSnipped = (!empty($options['cc_php'][$elId]) and !empty($options['cc_code'][$elId])) ? $options['cc_code'][$elId] : false;
         if (!$is_items_in_list and $is_item_data_in_list) {
             if (!empty($this->order_items)) {
                 foreach ($this->order_items as $n => $order_item) {
                     $meta_data = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_itemmeta WHERE order_item_id = {$order_item->order_item_id}", ARRAY_A);
                     $item_data = array();
                     foreach ($options['ids'] as $subID => $subvalue) {
                         if (strpos($options['cc_label'][$subID], 'item_data__') !== false) {
                             $product_id = '';
                             $variation_id = '';
                             foreach ($meta_data as $meta) {
                                 if ($meta['meta_key'] == '_variation_id' and !empty($meta['meta_value'])) {
                                     $variation_id = $meta['meta_value'];
                                 }
                                 if ($meta['meta_key'] == '_product_id' and !empty($meta['meta_value'])) {
                                     $product_id = $meta['meta_value'];
                                 }
                             }
                             $_product_id = empty($variation_id) ? $product_id : $variation_id;
                             $_product = get_post($_product_id);
                             // do not export anything if product doesn't exist
                             if (!empty($_product)) {
                                 $item_add_data = XmlExportCpt::prepare_data($_product, false, $this->acfs, $this->woo, $this->woo_order, ",", $preview, true, $subID);
                                 if (!empty($item_add_data)) {
                                     foreach ($item_add_data as $item_add_data_key => $item_add_data_value) {
                                         if (!isset($item_data[$item_add_data_key])) {
                                             $item_data[$item_add_data_key] = $item_add_data_value;
                                         }
                                     }
                                 }
                             }
                         }
                     }
                     if (!empty($item_data)) {
                         $data['items'][] = $item_data;
                     }
                 }
                 $this->order_items = null;
             }
         }
         switch ($options['cc_options'][$elId]) {
             case 'order':
             case 'customer':
                 $data[$options['cc_name'][$elId]] = strpos($options['cc_value'][$elId], "_") === 0 ? get_post_meta($record->ID, $options['cc_value'][$elId], true) : $record->{$options['cc_value'][$elId]};
                 if ($options['cc_value'][$elId] == "post_title") {
                     $data[$options['cc_name'][$elId]] = str_replace("–", '-', $data[$options['cc_name'][$elId]]);
                 }
                 $data[$options['cc_name'][$elId]] = pmxe_filter($data[$options['cc_name'][$elId]], $fieldSnipped);
                 break;
         }
     }
     return $data;
 }
 protected function prepare_export_data($record, $options, $elId, $preview)
 {
     // an array with data to export
     $data = array('items' => array(), 'taxes' => array(), 'shipping' => array(), 'coupons' => array(), 'surcharge' => array());
     global $wpdb;
     $table_prefix = $wpdb->prefix;
     if (!empty($options['cc_value'][$elId])) {
         switch ($options['cc_options'][$elId]) {
             case 'order':
             case 'customer':
                 $data[$options['cc_name'][$elId]] = strpos($options['cc_value'][$elId], "_") === 0 ? get_post_meta($record->ID, $options['cc_value'][$elId], true) : $record->{$options['cc_value'][$elId]};
                 if ($options['cc_value'][$elId] == "post_title") {
                     $data[$options['cc_name'][$elId]] = str_replace("–", '-', $data[$options['cc_name'][$elId]]);
                 }
                 $data[$options['cc_name'][$elId]] = pmxe_filter($data[$options['cc_name'][$elId]], $fieldSnipped);
                 break;
         }
     }
     return $data;
 }
예제 #7
0
/**
*	Export XML helper
*/
function pmxe_export_xml($exportQuery, $exportOptions, $preview = false, $is_cron = false, $file_path = false)
{
    $xmlWriter = new XMLWriter();
    $xmlWriter->openMemory();
    $xmlWriter->setIndent(true);
    $xmlWriter->setIndentString("\t");
    $xmlWriter->startDocument('1.0', $exportOptions['encoding']);
    $xmlWriter->startElement('data');
    global $wpdb;
    while ($exportQuery->have_posts()) {
        $exportQuery->the_post();
        $record = get_post(get_the_ID());
        // global $wpdb;
        // $table_prefix = $wpdb->prefix;
        // $order_items  = null;
        // if ( "shop_order" == get_post_type() )
        // {
        // 	$order_items  = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_items WHERE order_id = {$record->ID}");
        // }
        $xmlWriter->startElement('post');
        if ($exportOptions['ids']) {
            if (wp_all_export_is_compatible() and $exportOptions['is_generate_import'] and $exportOptions['import_id']) {
                $postRecord = new PMXI_Post_Record();
                $postRecord->clear();
                $postRecord->getBy(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id']));
                if ($postRecord->isEmpty()) {
                    $postRecord->set(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id'], 'unique_key' => $record->ID, 'product_key' => get_post_meta($record->ID, '_sku', true)))->save();
                }
                unset($postRecord);
            }
            foreach ($exportOptions['ids'] as $ID => $value) {
                if (is_numeric($ID)) {
                    if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                        continue;
                    }
                    $element_name = !empty($exportOptions['cc_name'][$ID]) ? str_replace(" ", "_", $exportOptions['cc_name'][$ID]) : 'untitled_' . $ID;
                    $fieldSnipped = (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) ? $exportOptions['cc_code'][$ID] : false;
                    switch ($exportOptions['cc_type'][$ID]) {
                        case 'id':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_id', pmxe_filter(get_the_ID(), $fieldSnipped), get_the_ID()));
                            break;
                        case 'permalink':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_guid', pmxe_filter(get_permalink(), $fieldSnipped), get_the_ID()));
                            break;
                        case 'post_type':
                            $pType = get_post_type();
                            if ($pType == 'product_variation') {
                                $pType = 'product';
                            }
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_type', pmxe_filter($pType, $fieldSnipped), get_the_ID()));
                            break;
                        case 'title':
                            $xmlWriter->startElement($element_name);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_title', pmxe_filter($record->post_title, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'content':
                            $xmlWriter->startElement($element_name);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_content', pmxe_filter($record->post_content, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'media':
                            $xmlWriter->startElement($element_name);
                            $attachment_ids = array();
                            $_featured_image = get_post_meta(get_the_ID(), '_thumbnail_id', true);
                            if (!empty($_featured_image)) {
                                $attachment_ids[] = $_featured_image;
                            }
                            $_gallery = get_post_meta(get_the_ID(), '_product_image_gallery', true);
                            if (!empty($_gallery)) {
                                $gallery = explode(',', $_gallery);
                                if (!empty($gallery) and is_array($gallery)) {
                                    foreach ($gallery as $aid) {
                                        if (!in_array($aid, $attachment_ids)) {
                                            $attachment_ids[] = $aid;
                                        }
                                    }
                                }
                            }
                            if (!empty($attachment_ids)) {
                                foreach ($attachment_ids as $attach_id) {
                                    $attach = get_post($attach_id);
                                    if (wp_attachment_is_image($attach->ID)) {
                                        $xmlWriter->startElement('image');
                                        $val = wp_get_attachment_url($attach->ID);
                                        if (!empty($exportOptions['cc_options'][$ID])) {
                                            switch ($exportOptions['cc_options'][$ID]) {
                                                case 'filenames':
                                                    $val = basename(wp_get_attachment_url($attach->ID));
                                                    break;
                                                case 'filepaths':
                                                    $val = get_attached_file($attach->ID);
                                                    break;
                                                default:
                                                    # code...
                                                    break;
                                            }
                                        }
                                        $xmlWriter->writeElement('file', apply_filters('pmxe_attachment_url', $val, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('title', apply_filters('pmxe_attachment_title', $attach->post_title, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('caption', apply_filters('pmxe_attachment_caption', $attach->post_excerpt, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('description', apply_filters('pmxe_attachment_content', $attach->post_content, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('alt', apply_filters('pmxe_attachment_alt', get_post_meta($record->ID, '_wp_attachment_image_alt', true), get_the_ID(), $attach->ID));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            $xmlWriter->endElement();
                            break;
                        case 'date':
                            if (!empty($exportOptions['cc_options'][$ID])) {
                                switch ($exportOptions['cc_options'][$ID]) {
                                    case 'unix':
                                        $post_date = get_post_time('U', true);
                                        break;
                                    default:
                                        $post_date = date($exportOptions['cc_options'][$ID], get_post_time('U', true));
                                        break;
                                }
                            } else {
                                $post_date = date("Ymd", get_post_time('U', true));
                            }
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_date', pmxe_filter($post_date, $fieldSnipped), get_the_ID()));
                            break;
                        case 'attachments':
                            $xmlWriter->startElement($element_name);
                            $attachment_imgs = get_posts(array('post_type' => 'attachment', 'posts_per_page' => -1, 'post_parent' => $record->ID));
                            if (!empty($attachment_imgs)) {
                                foreach ($attachment_imgs as $attach) {
                                    if (!wp_attachment_is_image($attach->ID)) {
                                        $xmlWriter->startElement('attach');
                                        $xmlWriter->writeElement('url', apply_filters('pmxe_attachment_url', pmxe_filter(wp_get_attachment_url($attach->ID), $fieldSnipped), get_the_ID(), $attach->ID));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            $xmlWriter->endElement();
                            // end attachments
                            break;
                        case 'parent':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_parent', pmxe_filter($record->post_parent, $fieldSnipped), get_the_ID()));
                            break;
                        case 'template':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_template', pmxe_filter(get_post_meta($record->ID, '_wp_page_template', true), $fieldSnipped), get_the_ID()));
                            break;
                        case 'order':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_menu_order', pmxe_filter($record->menu_order, $fieldSnipped), get_the_ID()));
                            break;
                        case 'status':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_status', pmxe_filter($record->post_status, $fieldSnipped), get_the_ID()));
                            break;
                        case 'format':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_format', pmxe_filter(get_post_format($record->ID), $fieldSnipped), get_the_ID()));
                            break;
                        case 'author':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_author', pmxe_filter($record->post_author, $fieldSnipped), get_the_ID()));
                            break;
                        case 'slug':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_post_slug', pmxe_filter($record->post_name, $fieldSnipped), get_the_ID()));
                            break;
                        case 'excerpt':
                            $xmlWriter->startElement($element_name);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_excerpt', pmxe_filter($record->post_excerpt, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'cf':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_post_meta($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        $xmlWriter->startElement($element_name);
                                        $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                        $xmlWriter->endElement();
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    $xmlWriter->startElement($element_name);
                                    $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                    $xmlWriter->endElement();
                                }
                            }
                            break;
                        case 'acf':
                            if (!empty($exportOptions['cc_label'][$ID]) and class_exists('acf')) {
                                global $acf;
                                $field_value = get_field($exportOptions['cc_label'][$ID], $record->ID);
                                $field_options = unserialize($exportOptions['cc_options'][$ID]);
                                pmxe_export_acf_field_xml($field_value, $exportOptions, $ID, $record->ID, $xmlWriter, $element_name, $fieldSnipped, $field_options['group_id']);
                            }
                            break;
                        case 'woo':
                            //$element_name = 'woo' . $element_name;
                            if (!empty($exportOptions['cc_label'][$ID])) {
                                $cur_meta_values = get_post_meta($record->ID, $exportOptions['cc_label'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        switch ($exportOptions['cc_label'][$ID]) {
                                            case '_downloadable_files':
                                                $files = maybe_unserialize($cur_meta_value);
                                                $file_paths = array();
                                                $file_names = array();
                                                if (!empty($files)) {
                                                    foreach ($files as $key => $file) {
                                                        $file_paths[] = $file['file'];
                                                        $file_names[] = $file['name'];
                                                    }
                                                    $xmlWriter->startElement($element_name . '_paths');
                                                    $xmlWriter->writeCData(implode(',', $file_paths));
                                                    $xmlWriter->endElement();
                                                    $xmlWriter->startElement($element_name . '_names');
                                                    $xmlWriter->writeCData(implode(',', $file_names));
                                                    $xmlWriter->endElement();
                                                }
                                                break;
                                            case '_crosssell_ids':
                                            case '_upsell_ids':
                                                $_upsell_ids = maybe_unserialize($cur_meta_value);
                                                $_upsell_skus = array();
                                                if (!empty($_upsell_ids)) {
                                                    foreach ($_upsell_ids as $_upsell_id) {
                                                        $_upsell_skus[] = get_post_meta($_upsell_id, '_sku', true);
                                                    }
                                                    $xmlWriter->startElement($element_name);
                                                    $xmlWriter->writeCData(apply_filters('woo_field', pmxe_filter(implode(',', $_upsell_skus), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                                    $xmlWriter->endElement();
                                                }
                                                break;
                                            default:
                                                $xmlWriter->startElement($element_name);
                                                $xmlWriter->writeCData(apply_filters('woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                                $xmlWriter->endElement();
                                                break;
                                        }
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    $xmlWriter->startElement($element_name);
                                    $xmlWriter->writeCData(apply_filters('woo_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                    $xmlWriter->endElement();
                                }
                            }
                            break;
                        case 'woo_order':
                            XmlExportWooCommerceOrder::getInstance()->export_xml($xmlWriter, $record, $exportOptions, $ID);
                            break;
                        case 'attr':
                            //$element_name = 'woo_' . $element_name;
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                if ($record->post_parent == 0) {
                                    $is_variable_product = false;
                                    $product_terms = wp_get_post_terms($record->ID, 'product_type');
                                    if (!empty($product_terms)) {
                                        if (!is_wp_error($product_terms)) {
                                            foreach ($product_terms as $term) {
                                                if ('variable' == $term->slug) {
                                                    $is_variable_product = true;
                                                    break;
                                                }
                                            }
                                        }
                                    }
                                    $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                    if (!is_wp_error($txes_list)) {
                                        $attr_new = array();
                                        if (!empty($txes_list)) {
                                            foreach ($txes_list as $t) {
                                                $attr_new[] = $t->slug;
                                            }
                                            $xmlWriter->startElement($is_variable_product ? $element_name : 'attribute_' . $element_name);
                                            $xmlWriter->writeCData(apply_filters('pmxe_woo_attribute', pmxe_filter(implode('|', $attr_new), $fieldSnipped), get_the_ID()));
                                            $xmlWriter->endElement();
                                        }
                                    }
                                } else {
                                    $attribute_pa = get_post_meta($record->ID, 'attribute_' . $exportOptions['cc_value'][$ID], true);
                                    if (!empty($attribute_pa)) {
                                        $xmlWriter->startElement('attribute_' . $element_name);
                                        $xmlWriter->writeCData(apply_filters('woo_field', $attribute_pa));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            break;
                        case 'cats':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!is_wp_error($txes_list)) {
                                    $txes_ids = array();
                                    $hierarchy_groups = array();
                                    if (!empty($txes_list)) {
                                        foreach ($txes_list as $t) {
                                            $txes_ids[] = $t->term_id;
                                        }
                                        foreach ($txes_list as $t) {
                                            if (wp_all_export_check_children_assign($t->term_id, $exportOptions['cc_value'][$ID], $txes_ids)) {
                                                $ancestors = get_ancestors($t->term_id, $exportOptions['cc_value'][$ID]);
                                                if (count($ancestors) > 0) {
                                                    $hierarchy_group = array();
                                                    for ($i = count($ancestors) - 1; $i >= 0; $i--) {
                                                        $term = get_term_by('id', $ancestors[$i], $exportOptions['cc_value'][$ID]);
                                                        if ($term) {
                                                            $hierarchy_group[] = $term->slug;
                                                        }
                                                    }
                                                    $hierarchy_group[] = $t->slug;
                                                    $hierarchy_groups[] = implode(">", $hierarchy_group);
                                                } else {
                                                    $hierarchy_groups[] = $t->slug;
                                                }
                                            }
                                        }
                                        if (!empty($hierarchy_groups)) {
                                            $xmlWriter->startElement($element_name);
                                            $xmlWriter->writeCData(apply_filters('pmxe_post_taxonomy', pmxe_filter(implode('|', $hierarchy_groups), $fieldSnipped), get_the_ID()));
                                            $xmlWriter->endElement();
                                        }
                                    }
                                }
                                if ($exportOptions['cc_label'][$ID] == 'product_type' and get_post_type() == 'product_variation') {
                                    $xmlWriter->writeElement('parent_sku', get_post_meta($record->post_parent, '_sku', true));
                                    $xmlWriter->writeElement($element_name, 'variable');
                                }
                            }
                            break;
                        case 'sql':
                            if (!empty($exportOptions['cc_sql'][$ID])) {
                                $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $exportOptions['cc_sql'][$ID])), get_the_ID()));
                                if (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) {
                                    // if shortcode defined
                                    if (strpos($exportOptions['cc_code'][$ID], '[') === 0) {
                                        $val = do_shortcode(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID]));
                                    } else {
                                        $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID])) . ';');
                                    }
                                }
                                $xmlWriter->startElement($element_name);
                                $xmlWriter->writeCData(apply_filters('pmxe_sql_field', $val, $element_name, get_the_ID()));
                                $xmlWriter->endElement();
                            }
                            break;
                        default:
                            # code...
                            break;
                    }
                }
            }
        }
        $xmlWriter->endElement();
        // end post
        if ($preview) {
            break;
        }
    }
    $xmlWriter->endElement();
    // end data
    if ($preview) {
        return wp_all_export_remove_colons($xmlWriter->flush(true));
    }
    if ($is_cron) {
        $xml = $xmlWriter->flush(true);
        if (file_exists($file_path)) {
            file_put_contents($file_path, wp_all_export_remove_colons(substr(substr($xml, 45), 0, -8)), FILE_APPEND);
        } else {
            file_put_contents($file_path, wp_all_export_remove_colons(substr($xml, 0, -8)));
        }
        return $file_path;
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            $is_secure_import = PMXE_Plugin::getInstance()->getOption('secure');
            $wp_uploads = wp_upload_dir();
            $target = $is_secure_import ? wp_all_export_secure_file($wp_uploads['basedir'] . DIRECTORY_SEPARATOR . PMXE_Plugin::UPLOADS_DIRECTORY) : $wp_uploads['path'];
            $export_file = $target . DIRECTORY_SEPARATOR . time() . '.' . $exportOptions['export_to'];
            file_put_contents($export_file, wp_all_export_remove_colons(substr($xmlWriter->flush(true), 0, -8)));
            PMXE_Plugin::$session->set('file', $export_file);
            PMXE_Plugin::$session->save_data();
        } else {
            file_put_contents(PMXE_Plugin::$session->file, wp_all_export_remove_colons(substr(substr($xmlWriter->flush(true), 45), 0, -8)), FILE_APPEND);
        }
        return true;
    }
}
예제 #8
0
function pmxe_export_acf_field_xml($field_value, $exportOptions, $ID, $recordID, &$xmlWriter, $element_name = '', $fieldSnipped = '', $group_id = '')
{
    if (!empty($field_value)) {
        $field_value = maybe_unserialize($field_value);
        $field_name = $ID ? $exportOptions['cc_label'][$ID] : $exportOptions['name'];
        $field_options = $ID ? unserialize($exportOptions['cc_options'][$ID]) : $exportOptions;
        //$element_name = 'acf_' . $element_name;
        $put_to_xml = true;
        // switch ACF field type
        switch ($field_options['type']) {
            case 'date_time_picker':
            case 'date_picker':
                $field_value = date('Ymd', strtotime($field_value));
                break;
            case 'file':
            case 'image':
                if (is_numeric($field_value)) {
                    $field_value = wp_get_attachment_url($field_value);
                } elseif (is_array($field_value)) {
                    $field_value = $field_value['url'];
                }
                break;
            case 'gallery':
                $v = array();
                foreach ($field_value as $key => $item) {
                    $v[] = $item['url'];
                }
                $field_value = implode(",", $v);
                break;
            case 'location-field':
                $localion_parts = explode("|", $field_value);
                if (!empty($localion_parts)) {
                    $xmlWriter->startElement($element_name);
                    $xmlWriter->startElement('address');
                    $xmlWriter->writeCData($localion_parts[0]);
                    $xmlWriter->endElement();
                    if (!empty($localion_parts[1])) {
                        $coordinates = explode(",", $localion_parts[1]);
                        if (!empty($coordinates)) {
                            $xmlWriter->startElement('lat');
                            $xmlWriter->writeCData($coordinates[0]);
                            $xmlWriter->endElement();
                            $xmlWriter->startElement('lng');
                            $xmlWriter->writeCData($coordinates[1]);
                            $xmlWriter->endElement();
                        }
                    }
                    $xmlWriter->endElement();
                }
                $put_to_xml = false;
                break;
            case 'paypal_item':
                $xmlWriter->startElement($element_name);
                if (is_array($field_value)) {
                    foreach ($field_value as $key => $value) {
                        $xmlWriter->startElement($key);
                        $xmlWriter->writeCData($value);
                        $xmlWriter->endElement();
                    }
                }
                $xmlWriter->endElement();
                $put_to_xml = false;
                break;
            case 'google_map':
                $xmlWriter->startElement($element_name);
                $xmlWriter->startElement('address');
                $xmlWriter->writeCData($field_value['address']);
                $xmlWriter->endElement();
                $xmlWriter->startElement('lat');
                $xmlWriter->writeCData($field_value['lat']);
                $xmlWriter->endElement();
                $xmlWriter->startElement('lng');
                $xmlWriter->writeCData($field_value['lng']);
                $xmlWriter->endElement();
                $xmlWriter->endElement();
                $put_to_xml = false;
                break;
            case 'acf_cf7':
            case 'gravity_forms_field':
                if (!empty($field_options['multiple'])) {
                    $field_value = implode(",", $field_value);
                }
                break;
            case 'page_link':
                if (is_array($field_value)) {
                    $field_value = implode(",", $field_value);
                }
                break;
            case 'post_object':
                if (!empty($field_options['multiple'])) {
                    $v = array();
                    foreach ($field_value as $key => $pid) {
                        if (is_numeric($pid)) {
                            $entry = get_post($pid);
                            if ($entry) {
                                $v[] = $entry->post_name;
                            }
                        } else {
                            $v[] = $pid->post_name;
                        }
                    }
                    $field_value = implode(",", $v);
                } else {
                    if (is_numeric($field_value)) {
                        $entry = get_post($field_value);
                        if ($entry) {
                            $field_value = $entry->post_name;
                        }
                    } else {
                        $field_value = $field_value->post_name;
                    }
                }
                break;
            case 'relationship':
                $v = array();
                foreach ($field_value as $key => $pid) {
                    $entry = get_post($pid);
                    if ($entry) {
                        $v[] = $entry->post_title;
                    }
                }
                $field_value = implode(",", $v);
                break;
            case 'user':
                if (!empty($field_options['multiple'])) {
                    $v = array();
                    foreach ($field_value as $key => $user) {
                        if (is_numeric($user)) {
                            $entry = get_user_by('ID', $user);
                            if ($entry) {
                                $v[] = $entry->user_email;
                            }
                        } else {
                            $v[] = $user['user_email'];
                        }
                    }
                    $field_value = implode(",", $v);
                } else {
                    if (is_numeric($field_value)) {
                        $entry = get_user_by('ID', $field_value);
                        if ($entry) {
                            $field_value = $entry->user_email;
                        }
                    } else {
                        $field_value = $field_value['user_email'];
                    }
                }
                break;
            case 'taxonomy':
                $xmlWriter->startElement($element_name);
                if (!in_array($field_options['field_type'], array('radio', 'select'))) {
                    foreach ($field_value as $key => $tid) {
                        $entry = get_term($tid, $field_options['taxonomy']);
                        if ($entry and !is_wp_error($entry)) {
                            $xmlWriter->startElement('term');
                            $xmlWriter->writeCData($entry->slug);
                            $xmlWriter->endElement();
                        }
                    }
                } else {
                    $entry = get_term($field_value, $field_options['taxonomy']);
                    if ($entry) {
                        $xmlWriter->startElement('term');
                        $xmlWriter->writeCData($entry->slug);
                        $xmlWriter->endElement();
                    }
                }
                $xmlWriter->endElement();
                $put_to_xml = false;
                break;
            case 'select':
                if (!empty($field_options['multiple'])) {
                    $field_value = implode(",", $field_value);
                }
                break;
            case 'checkbox':
                $field_value = implode(",", $field_value);
                break;
            case 'repeater':
                $xmlWriter->startElement($element_name);
                if (have_rows($field_name, $recordID)) {
                    while (have_rows($field_name, $recordID)) {
                        the_row();
                        $row = acf_get_row();
                        //$xmlWriter->startElementNs('key_' . $row['i'], 'row', null);
                        $xmlWriter->startElement('row');
                        foreach ($row['field']['sub_fields'] as $sub_field) {
                            // get
                            $v = acf_format_value($row['value'][$row['i']][$sub_field['key']], $row['post_id'], $sub_field);
                            pmxe_export_acf_field_xml($v, $sub_field, false, $recordID, $xmlWriter, $sub_field['name'], '', '');
                        }
                        $xmlWriter->endElement();
                    }
                }
                $xmlWriter->endElement();
                $put_to_xml = false;
                break;
            case 'flexible_content':
                $xmlWriter->startElement($element_name);
                // check if the flexible content field has rows of data
                if (have_rows($field_name)) {
                    // loop through the rows of data
                    while (have_rows($field_name)) {
                        the_row();
                        $row = acf_get_row();
                        foreach ($row['field']['layouts'] as $layout) {
                            if ($layout['name'] == $row['value'][$row['i']]['acf_fc_layout']) {
                                $xmlWriter->startElement($row['value'][$row['i']]['acf_fc_layout'] . '_' . $row['i']);
                                foreach ($layout['sub_fields'] as $sub_field) {
                                    if (isset($row['value'][$row['i']][$sub_field['key']])) {
                                        // get
                                        $v = acf_format_value($row['value'][$row['i']][$sub_field['key']], $row['post_id'], $sub_field);
                                        pmxe_export_acf_field_xml($v, $sub_field, false, $recordID, $xmlWriter, $sub_field['name'], '', '');
                                    }
                                }
                                $xmlWriter->endElement();
                            }
                        }
                    }
                } else {
                    // no layouts found
                }
                $xmlWriter->endElement();
                $put_to_xml = false;
                break;
            default:
                break;
        }
        if ($put_to_xml) {
            $xmlWriter->startElement($element_name);
            $xmlWriter->writeCData(apply_filters('pmxe_acf_field', pmxe_filter(maybe_serialize($field_value), $fieldSnipped), $field_name, $recordID));
            $xmlWriter->endElement();
        }
    }
}
예제 #9
0
 protected function prepare_export_data($record, $options, $elId)
 {
     // an array with data to export
     $data = array('items' => array(), 'taxes' => array(), 'shipping' => array(), 'coupons' => array(), 'surcharge' => array());
     global $wpdb;
     $table_prefix = $wpdb->prefix;
     if (empty($this->order_id) or $this->order_id != $record->ID) {
         $this->order_id = $record->ID;
         $all_order_items = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_items WHERE order_id = {$record->ID}");
         if (!empty($all_order_items)) {
             foreach ($all_order_items as $item) {
                 switch ($item->order_item_type) {
                     case 'line_item':
                         $this->order_items[] = $item;
                         break;
                     case 'tax':
                         $this->order_taxes[] = $item;
                         break;
                     case 'shipping':
                         $this->order_shipping[] = $item;
                         break;
                     case 'coupon':
                         $this->order_coupons[] = $item;
                         break;
                     case 'fee':
                         $this->order_surcharge[] = $item;
                         break;
                 }
             }
         }
     }
     if (!empty($options['cc_value'][$elId])) {
         $fieldSnipped = (!empty($options['cc_php'][$elId]) and !empty($options['cc_code'][$elId])) ? $options['cc_code'][$elId] : false;
         switch ($options['cc_options'][$elId]) {
             case 'order':
             case 'customer':
                 $data[$options['cc_name'][$elId]] = strpos($options['cc_value'][$elId], "_") === 0 ? get_post_meta($record->ID, $options['cc_value'][$elId], true) : $record->{$options}['cc_value'][$elId];
                 if ($options['cc_value'][$elId] == "post_title") {
                     $data[$options['cc_name'][$elId]] = str_replace("–", '-', $data[$options['cc_name'][$elId]]);
                 }
                 break;
             case 'items':
                 if (!empty($this->order_items)) {
                     foreach ($this->order_items as $n => $order_item) {
                         $meta_data = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_itemmeta WHERE order_item_id = {$order_item->order_item_id}", ARRAY_A);
                         $item_data = array();
                         foreach ($options['ids'] as $subID => $subvalue) {
                             if ($options['cc_type'][$subID] == 'woo_order' and $options['cc_options'][$subID] == 'items') {
                                 $element_name = $options['cc_name'][$subID] . ' #' . ($n + 1);
                                 $fieldSnipped = (!empty($options['cc_php'][$subID]) and !empty($options['cc_code'][$subID])) ? $options['cc_code'][$subID] : false;
                                 switch ($options['cc_value'][$subID]) {
                                     case '_product_id':
                                     case '__product_sku':
                                     case '__product_title':
                                         $product_id = '';
                                         $variation_id = '';
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == '_variation_id' and !empty($meta['meta_value'])) {
                                                 $variation_id = $meta['meta_value'];
                                             }
                                             if ($meta['meta_key'] == '_product_id' and !empty($meta['meta_value'])) {
                                                 $product_id = $meta['meta_value'];
                                             }
                                         }
                                         $_product_id = empty($variation_id) ? $product_id : $variation_id;
                                         switch ($options['cc_value'][$subID]) {
                                             case '_product_id':
                                                 $item_data[$element_name] = pmxe_filter($_product_id, $fieldSnipped);
                                                 break;
                                             case '__product_sku':
                                                 $item_data[$element_name] = pmxe_filter(get_post_meta($_product_id, '_sku', true), $fieldSnipped);
                                                 break;
                                             case '__product_title':
                                                 $_product = get_post($_product_id);
                                                 $item_data[$element_name] = !is_null($_product) ? pmxe_filter($_product->post_title, $fieldSnipped) : '';
                                                 break;
                                         }
                                         break;
                                     case '__product_variation':
                                         $variations = array();
                                         foreach ($meta_data as $meta) {
                                             if (strpos($meta['meta_key'], "pa_") === 0) {
                                                 $variations[str_replace("pa_", "", $meta['meta_key'])] = $meta['meta_value'];
                                             }
                                         }
                                         if (!empty($variations)) {
                                             foreach ($variations as $key => $value) {
                                                 $item_data[$element_name . " (" . sanitize_title($key) . ")"] = pmxe_filter($value, $fieldSnipped);
                                             }
                                         }
                                         break;
                                     case '_line_subtotal':
                                         $_line_total = 0;
                                         $_qty = 0;
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == '_line_total') {
                                                 $_line_total = $meta['meta_value'];
                                             }
                                             if ($meta['meta_key'] == '_qty') {
                                                 $_qty = $meta['meta_value'];
                                             }
                                         }
                                         $_line_subtotal = $_qty ? number_format($_line_total / $_qty, 2) : 0;
                                         $item_data[$element_name] = pmxe_filter($_line_subtotal, $fieldSnipped);
                                         break;
                                     default:
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == $options['cc_value'][$subID]) {
                                                 $item_data[$element_name] = pmxe_filter($meta['meta_value'], $fieldSnipped);
                                             }
                                         }
                                         break;
                                 }
                             }
                         }
                         if (!empty($item_data)) {
                             $data['items'][] = $item_data;
                         }
                     }
                     $this->order_items = null;
                 }
                 break;
             case 'taxes':
                 // Order Taxes
                 if (!empty($this->order_taxes)) {
                     foreach ($this->order_taxes as $order_tax) {
                         $meta_data = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_itemmeta WHERE order_item_id = {$order_tax->order_item_id}", ARRAY_A);
                         $rate_details = null;
                         foreach ($meta_data as $meta) {
                             if ($meta['meta_key'] == 'rate_id') {
                                 $rate_id = $meta['meta_value'];
                                 $rate_details = $wpdb->get_row("SELECT * FROM {$table_prefix}woocommerce_tax_rates WHERE tax_rate_id = {$rate_id}");
                                 break;
                             }
                         }
                         $tax_data = array();
                         foreach ($options['ids'] as $subID => $subvalue) {
                             if ($options['cc_type'][$subID] == 'woo_order' and $options['cc_options'][$subID] == 'taxes') {
                                 $element_name = str_replace("per tax", $rate_details->tax_rate_name, $options['cc_name'][$subID]);
                                 $fieldSnipped = (!empty($options['cc_php'][$subID]) and !empty($options['cc_code'][$subID])) ? $options['cc_code'][$subID] : false;
                                 switch ($options['cc_value'][$subID]) {
                                     case 'tax_order_item_name':
                                         $tax_data[$element_name] = pmxe_filter($order_tax->order_item_name, $fieldSnipped);
                                         break;
                                     case 'tax_rate':
                                         $tax_data[$element_name] = pmxe_filter(!empty($rate_details) ? $rate_details->tax_rate : '', $fieldSnipped);
                                         break;
                                     case 'tax_amount':
                                         $tax_amount = 0;
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == 'tax_amount' || $meta['meta_key'] == 'shipping_tax_amount') {
                                                 $tax_amount += $meta['meta_value'];
                                             }
                                         }
                                         $tax_data[$element_name] = pmxe_filter($tax_amount, $fieldSnipped);
                                         break;
                                 }
                             }
                         }
                         if (!empty($tax_data)) {
                             $data['taxes'][] = $tax_data;
                         }
                     }
                     $this->order_taxes = null;
                 }
                 // Calculate Total Tax Amount
                 if ($options['cc_value'][$elId] == '_order_tax') {
                     $_order_shipping_tax = get_post_meta($record->ID, '_order_shipping_tax', true);
                     $_order_tax = get_post_meta($record->ID, '_order_tax', true);
                     $_order_tax_total = $_order_shipping_tax + $_order_tax;
                     $data[$options['cc_name'][$elId]] = pmxe_filter($_order_tax_total, $fieldSnipped);
                 }
                 if (!empty($this->order_shipping)) {
                     foreach ($this->order_shipping as $order_ship) {
                         $shipping_data = array();
                         foreach ($options['ids'] as $subID => $subvalue) {
                             if ($options['cc_type'][$subID] == 'woo_order' and $options['cc_options'][$subID] == 'taxes') {
                                 $element_name = $options['cc_name'][$subID];
                                 $fieldSnipped = (!empty($options['cc_php'][$subID]) and !empty($options['cc_code'][$subID])) ? $options['cc_code'][$subID] : false;
                                 switch ($options['cc_value'][$subID]) {
                                     case 'shipping_order_item_name':
                                         $shipping_data[$element_name] = pmxe_filter($order_ship->order_item_name, $fieldSnipped);
                                         break;
                                     case '_order_shipping':
                                         $shipping_data[$element_name] = pmxe_filter(get_post_meta($record->ID, '_order_shipping', true), $fieldSnipped);
                                         break;
                                 }
                             }
                         }
                         if (!empty($shipping_data)) {
                             $data['shipping'][] = $shipping_data;
                         }
                     }
                     $this->order_shipping = null;
                 }
                 break;
             case 'fees':
                 if (!empty($this->order_coupons)) {
                     $this->__coupons_used = array();
                     foreach ($this->order_coupons as $order_coupon) {
                         $this->__coupons_used[] = $order_coupon->order_item_name;
                         $meta_data = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_itemmeta WHERE order_item_id = {$order_coupon->order_item_id}", ARRAY_A);
                         $coupons_data = array();
                         foreach ($options['ids'] as $subID => $subvalue) {
                             if ($options['cc_type'][$subID] == 'woo_order' and $options['cc_options'][$subID] == 'fees') {
                                 $element_name = str_replace("per coupon", $order_coupon->order_item_name, $options['cc_name'][$subID]);
                                 $fieldSnipped = (!empty($options['cc_php'][$subID]) and !empty($options['cc_code'][$subID])) ? $options['cc_code'][$subID] : false;
                                 switch ($options['cc_value'][$subID]) {
                                     case 'discount_amount':
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == 'discount_amount') {
                                                 $coupons_data[$element_name] = pmxe_filter($meta['meta_value'] * -1, $fieldSnipped);
                                                 break;
                                             }
                                         }
                                         break;
                                 }
                             }
                         }
                         if (!empty($coupons_data)) {
                             $data['coupons'][] = $coupons_data;
                         }
                     }
                     $this->order_coupons = null;
                 }
                 // List of all coupons used
                 if ($options['cc_value'][$elId] == '__coupons_used' and !is_null($this->__coupons_used)) {
                     $implode_delimiter = $options['delimiter'] == ',' ? '|' : ',';
                     $data[$options['cc_name'][$elId]] = pmxe_filter(implode($implode_delimiter, $this->__coupons_used), $fieldSnipped);
                 }
                 // Calculate Total Discount Amount
                 if ($options['cc_value'][$elId] == '_cart_discount') {
                     $_cart_discount = get_post_meta($record->ID, '_cart_discount', true);
                     $data[$options['cc_name'][$elId]] = pmxe_filter($_cart_discount * -1, $fieldSnipped);
                 }
                 if (!empty($this->order_surcharge)) {
                     $this->__total_fee_amount = 0;
                     foreach ($this->order_surcharge as $order_surcharge) {
                         $meta_data = $wpdb->get_results("SELECT * FROM {$table_prefix}woocommerce_order_itemmeta WHERE order_item_id = {$order_surcharge->order_item_id}", ARRAY_A);
                         $surcharge_data = array();
                         foreach ($options['ids'] as $subID => $subvalue) {
                             if ($options['cc_type'][$subID] == 'woo_order' and $options['cc_options'][$subID] == 'fees') {
                                 $element_name = str_replace("Amount (per surcharge)", "(" . $order_surcharge->order_item_name . ")", $options['cc_name'][$subID]);
                                 $fieldSnipped = (!empty($options['cc_php'][$subID]) and !empty($options['cc_code'][$subID])) ? $options['cc_code'][$subID] : false;
                                 switch ($options['cc_value'][$subID]) {
                                     case 'fee_line_total':
                                         foreach ($meta_data as $meta) {
                                             if ($meta['meta_key'] == '_line_total') {
                                                 $surcharge_data[$element_name] = pmxe_filter($meta['meta_value'], $fieldSnipped);
                                                 $this->__total_fee_amount += $meta['meta_value'];
                                                 break;
                                             }
                                         }
                                         break;
                                 }
                             }
                         }
                         if (!empty($surcharge_data)) {
                             $data['surcharge'][] = $surcharge_data;
                         }
                     }
                     $this->order_surcharge = null;
                 }
                 // Total Fee Amount
                 if ($options['cc_value'][$elId] == '__total_fee_amount' and !is_null($this->__total_fee_amount)) {
                     $data[$options['cc_name'][$elId]] = $this->__total_fee_amount;
                 }
                 break;
         }
     }
     return $data;
 }
예제 #10
0
function pmxe_export_xml($exportQuery, $exportOptions, $preview = false, $is_cron = false, $file_path = false, $exported_by_cron = 0)
{
    require_once PMXE_ROOT_DIR . '/classes/XMLWriter.php';
    $xmlWriter = new PMXE_XMLWriter();
    $xmlWriter->openMemory();
    $xmlWriter->setIndent(true);
    $xmlWriter->setIndentString("\t");
    $xmlWriter->startDocument('1.0', $exportOptions['encoding']);
    $xmlWriter->startElement($exportOptions['main_xml_tag']);
    if ($is_cron) {
        if (!$exported_by_cron) {
            $additional_data = apply_filters('wp_all_export_additional_data', array(), $exportOptions);
            if (!empty($additional_data)) {
                foreach ($additional_data as $key => $value) {
                    $xmlWriter->startElement(preg_replace('/[^a-z0-9_-]/i', '', $key));
                    $xmlWriter->writeCData($value);
                    $xmlWriter->endElement();
                }
            }
        }
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            $additional_data = apply_filters('wp_all_export_additional_data', array(), $exportOptions);
            if (!empty($additional_data)) {
                foreach ($additional_data as $key => $value) {
                    $xmlWriter->startElement(preg_replace('/[^a-z0-9_-]/i', '', $key));
                    $xmlWriter->writeCData($value);
                    $xmlWriter->endElement();
                }
            }
        }
    }
    global $wpdb;
    while ($exportQuery->have_posts()) {
        $exportQuery->the_post();
        $record = get_post(get_the_ID());
        $xmlWriter->startElement($exportOptions['record_xml_tag']);
        if ($exportOptions['ids']) {
            if (wp_all_export_is_compatible() and $exportOptions['is_generate_import'] and $exportOptions['import_id']) {
                $postRecord = new PMXI_Post_Record();
                $postRecord->clear();
                $postRecord->getBy(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id']));
                if ($postRecord->isEmpty()) {
                    $postRecord->set(array('post_id' => $record->ID, 'import_id' => $exportOptions['import_id'], 'unique_key' => $record->ID, 'product_key' => $record->ID))->save();
                }
                unset($postRecord);
            }
            foreach ($exportOptions['ids'] as $ID => $value) {
                if (is_numeric($ID)) {
                    if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                        continue;
                    }
                    $element_name_ns = '';
                    $element_name = !empty($exportOptions['cc_name'][$ID]) ? preg_replace('/[^a-z0-9_:-]/i', '', $exportOptions['cc_name'][$ID]) : 'untitled_' . $ID;
                    $fieldSnipped = (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) ? $exportOptions['cc_code'][$ID] : false;
                    if (strpos($element_name, ":") !== false) {
                        $element_name_parts = explode(":", $element_name);
                        $element_name_ns = empty($element_name_parts[0]) ? '' : $element_name_parts[0];
                        $element_name = empty($element_name_parts[1]) ? 'untitled_' . $ID : preg_replace('/[^a-z0-9_-]/i', '', $element_name_parts[1]);
                    }
                    switch ($exportOptions['cc_type'][$ID]) {
                        case 'id':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_id', pmxe_filter(get_the_ID(), $fieldSnipped), get_the_ID()));
                            break;
                        case 'permalink':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_guid', pmxe_filter(get_permalink(), $fieldSnipped), get_the_ID()));
                            break;
                        case 'post_type':
                            $pType = get_post_type();
                            if ($pType == 'product_variation') {
                                $pType = 'product';
                            }
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_type', pmxe_filter($pType, $fieldSnipped), get_the_ID()));
                            break;
                        case 'title':
                            $xmlWriter->beginElement($element_name_ns, $element_name, null);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_title', pmxe_filter($record->post_title, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'content':
                            $xmlWriter->beginElement($element_name_ns, $element_name, null);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_content', pmxe_filter($record->post_content, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'media':
                            $xmlWriter->beginElement($element_name_ns, $element_name, null);
                            $attachment_ids = array();
                            $_featured_image = get_post_meta(get_the_ID(), '_thumbnail_id', true);
                            if (!empty($_featured_image)) {
                                $attachment_ids[] = $_featured_image;
                            }
                            $_gallery = get_post_meta(get_the_ID(), '_product_image_gallery', true);
                            if (!empty($_gallery)) {
                                $gallery = explode(',', $_gallery);
                                if (!empty($gallery) and is_array($gallery)) {
                                    foreach ($gallery as $aid) {
                                        if (!in_array($aid, $attachment_ids)) {
                                            $attachment_ids[] = $aid;
                                        }
                                    }
                                }
                            }
                            $attachment_imgs = get_posts(array('post_type' => 'attachment', 'posts_per_page' => -1, 'post_parent' => $record->ID));
                            if (!empty($attachment_imgs)) {
                                foreach ($attachment_imgs as $attach) {
                                    if (wp_attachment_is_image($attach->ID) and !in_array($attach->ID, $attachment_ids)) {
                                        $attachment_ids[] = $attach->ID;
                                    }
                                }
                            }
                            if (!empty($attachment_ids)) {
                                foreach ($attachment_ids as $attach_id) {
                                    $attach = get_post($attach_id);
                                    if ($attach and !is_wp_error($attach) and wp_attachment_is_image($attach->ID)) {
                                        $xmlWriter->startElement('image');
                                        $val = wp_get_attachment_url($attach->ID);
                                        if (!empty($exportOptions['cc_options'][$ID])) {
                                            switch ($exportOptions['cc_options'][$ID]) {
                                                case 'filenames':
                                                    $val = basename(wp_get_attachment_url($attach->ID));
                                                    break;
                                                case 'filepaths':
                                                    $val = get_attached_file($attach->ID);
                                                    break;
                                                default:
                                                    # code...
                                                    break;
                                            }
                                        }
                                        $xmlWriter->writeElement('file', apply_filters('pmxe_attachment_url', $val, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('title', apply_filters('pmxe_attachment_title', $attach->post_title, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('caption', apply_filters('pmxe_attachment_caption', $attach->post_excerpt, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('description', apply_filters('pmxe_attachment_content', $attach->post_content, get_the_ID(), $attach->ID));
                                        $xmlWriter->writeElement('alt', apply_filters('pmxe_attachment_alt', get_post_meta($record->ID, '_wp_attachment_image_alt', true), get_the_ID(), $attach->ID));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            $xmlWriter->endElement();
                            break;
                        case 'date':
                            if (!empty($exportOptions['cc_options'][$ID])) {
                                switch ($exportOptions['cc_options'][$ID]) {
                                    case 'unix':
                                        $post_date = get_post_time('U', true);
                                        break;
                                    default:
                                        $post_date = date($exportOptions['cc_options'][$ID], get_post_time('U', true));
                                        break;
                                }
                            } else {
                                $post_date = date("Ymd", get_post_time('U', true));
                            }
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_date', pmxe_filter($post_date, $fieldSnipped), get_the_ID()));
                            break;
                        case 'attachments':
                            $xmlWriter->beginElement($element_name_ns, $element_name, null);
                            $attachment_imgs = get_posts(array('post_type' => 'attachment', 'posts_per_page' => -1, 'post_parent' => $record->ID));
                            if (!empty($attachment_imgs)) {
                                foreach ($attachment_imgs as $attach) {
                                    if (!wp_attachment_is_image($attach->ID)) {
                                        $xmlWriter->startElement('attach');
                                        $xmlWriter->writeElement('url', apply_filters('pmxe_attachment_url', pmxe_filter(wp_get_attachment_url($attach->ID), $fieldSnipped), get_the_ID(), $attach->ID));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            $xmlWriter->endElement();
                            // end attachments
                            break;
                        case 'parent':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_parent', pmxe_filter($record->post_parent, $fieldSnipped), get_the_ID()));
                            break;
                        case 'comment_status':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_comment_status', pmxe_filter($record->comment_status, $fieldSnipped), get_the_ID()));
                            break;
                        case 'ping_status':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_ping_status', pmxe_filter($record->ping_status, $fieldSnipped), get_the_ID()));
                            break;
                        case 'template':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_template', pmxe_filter(get_post_meta($record->ID, '_wp_page_template', true), $fieldSnipped), get_the_ID()));
                            break;
                        case 'order':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_menu_order', pmxe_filter($record->menu_order, $fieldSnipped), get_the_ID()));
                            break;
                        case 'status':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_status', pmxe_filter($record->post_status, $fieldSnipped), get_the_ID()));
                            break;
                        case 'format':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_format', pmxe_filter(get_post_format($record->ID), $fieldSnipped), get_the_ID()));
                            break;
                        case 'author':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_author', pmxe_filter($record->post_author, $fieldSnipped), get_the_ID()));
                            break;
                        case 'slug':
                            $xmlWriter->putElement($element_name_ns, $element_name, null, apply_filters('pmxe_post_slug', pmxe_filter($record->post_name, $fieldSnipped), get_the_ID()));
                            break;
                        case 'excerpt':
                            $xmlWriter->beginElement($element_name_ns, $element_name, null);
                            $xmlWriter->writeCData(apply_filters('pmxe_post_excerpt', pmxe_filter($record->post_excerpt, $fieldSnipped), get_the_ID()));
                            $xmlWriter->endElement();
                            break;
                        case 'cf':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_post_meta($record->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        $xmlWriter->beginElement($element_name_ns, $element_name, null);
                                        $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                        $xmlWriter->endElement();
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    $xmlWriter->beginElement($element_name_ns, $element_name, null);
                                    $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], get_the_ID()));
                                    $xmlWriter->endElement();
                                }
                            }
                            break;
                        case 'acf':
                            if (!empty($exportOptions['cc_label'][$ID]) and class_exists('acf')) {
                                global $acf;
                                $field_value = get_field($exportOptions['cc_label'][$ID], $record->ID);
                                $field_options = unserialize($exportOptions['cc_options'][$ID]);
                                pmxe_export_acf_field_xml($field_value, $exportOptions, $ID, $record->ID, $xmlWriter, $element_name, $element_name_ns, $fieldSnipped, $field_options['group_id']);
                            }
                            break;
                        case 'woo':
                            XmlExportWooCommerce::getInstance()->export_xml($xmlWriter, $record, $exportOptions, $ID);
                            break;
                        case 'woo_order':
                            XmlExportWooCommerceOrder::getInstance()->export_xml($xmlWriter, $record, $exportOptions, $ID);
                            break;
                        case 'attr':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                if ($record->post_parent == 0) {
                                    $is_variable_product = false;
                                    $product_terms = wp_get_post_terms($record->ID, 'product_type');
                                    if (!empty($product_terms)) {
                                        if (!is_wp_error($product_terms)) {
                                            foreach ($product_terms as $term) {
                                                if ('variable' == $term->slug) {
                                                    $is_variable_product = true;
                                                    break;
                                                }
                                            }
                                        }
                                    }
                                    $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                    if (!is_wp_error($txes_list)) {
                                        $attr_new = array();
                                        if (!empty($txes_list)) {
                                            foreach ($txes_list as $t) {
                                                $attr_new[] = $t->name;
                                            }
                                            $xmlWriter->beginElement($element_name_ns, $is_variable_product ? $element_name : 'attribute_' . $element_name, null);
                                            $xmlWriter->writeCData(apply_filters('pmxe_woo_attribute', pmxe_filter(implode('|', $attr_new), $fieldSnipped), get_the_ID()));
                                            $xmlWriter->endElement();
                                        }
                                    }
                                } else {
                                    $attribute_pa = get_post_meta($record->ID, 'attribute_' . $exportOptions['cc_value'][$ID], true);
                                    if (!empty($attribute_pa)) {
                                        $xmlWriter->beginElement($element_name_ns, 'attribute_' . $element_name, null);
                                        $xmlWriter->writeCData(apply_filters('woo_field', $attribute_pa));
                                        $xmlWriter->endElement();
                                    }
                                }
                            }
                            break;
                        case 'cats':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                if ($exportOptions['cc_label'][$ID] == 'product_type' and get_post_type() == 'product_variation') {
                                    $xmlWriter->writeElement('parent_id', $record->post_parent);
                                    $xmlWriter->writeElement($element_name, 'variable');
                                } else {
                                    $txes_list = get_the_terms($record->ID, $exportOptions['cc_value'][$ID]);
                                    if (!is_wp_error($txes_list)) {
                                        $txes_ids = array();
                                        $hierarchy_groups = array();
                                        if (!empty($txes_list)) {
                                            foreach ($txes_list as $t) {
                                                $txes_ids[] = $t->term_id;
                                            }
                                            foreach ($txes_list as $t) {
                                                if (wp_all_export_check_children_assign($t->term_id, $exportOptions['cc_value'][$ID], $txes_ids)) {
                                                    $ancestors = get_ancestors($t->term_id, $exportOptions['cc_value'][$ID]);
                                                    if (count($ancestors) > 0) {
                                                        $hierarchy_group = array();
                                                        for ($i = count($ancestors) - 1; $i >= 0; $i--) {
                                                            $term = get_term_by('id', $ancestors[$i], $exportOptions['cc_value'][$ID]);
                                                            if ($term) {
                                                                $hierarchy_group[] = $term->name;
                                                            }
                                                        }
                                                        $hierarchy_group[] = $t->name;
                                                        $hierarchy_groups[] = implode(">", $hierarchy_group);
                                                    } else {
                                                        $hierarchy_groups[] = $t->name;
                                                    }
                                                }
                                            }
                                            if (!empty($hierarchy_groups)) {
                                                $xmlWriter->beginElement($element_name_ns, $element_name, null);
                                                $xmlWriter->writeCData(apply_filters('pmxe_post_taxonomy', pmxe_filter(implode('|', $hierarchy_groups), $fieldSnipped), get_the_ID()));
                                                $xmlWriter->endElement();
                                            }
                                        }
                                    }
                                }
                            }
                            break;
                        case 'sql':
                            if (!empty($exportOptions['cc_sql'][$ID])) {
                                $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $exportOptions['cc_sql'][$ID])), get_the_ID()));
                                if (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) {
                                    // if shortcode defined
                                    if (strpos($exportOptions['cc_code'][$ID], '[') === 0) {
                                        $val = do_shortcode(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID]));
                                    } else {
                                        $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID])) . ';');
                                    }
                                }
                                $xmlWriter->beginElement($element_name_ns, $element_name, null);
                                $xmlWriter->writeCData(apply_filters('pmxe_sql_field', $val, $element_name, get_the_ID()));
                                $xmlWriter->endElement();
                            }
                            break;
                        default:
                            # code...
                            break;
                    }
                }
            }
        }
        $xmlWriter->endElement();
        // end post
        if ($preview) {
            break;
        }
        do_action('pmxe_exported_post', $record->ID);
    }
    $xmlWriter->endElement();
    // end data
    if ($preview) {
        return $xmlWriter->flush(true);
    }
    //wp_all_export_remove_colons($xmlWriter->flush(true));
    if ($is_cron) {
        $xml = $xmlWriter->flush(true);
        if (!$exported_by_cron) {
            // The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
            if ($exportOptions['include_bom']) {
                file_put_contents($file_path, chr(0xef) . chr(0xbb) . chr(0xbf) . substr($xml, 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1));
            } else {
                file_put_contents($file_path, substr($xml, 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1));
            }
        } else {
            file_put_contents($file_path, substr(substr($xml, 41 + strlen($exportOptions['main_xml_tag'])), 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1), FILE_APPEND);
        }
        return $file_path;
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            // generate export file name
            $export_file = wp_all_export_generate_export_file(XmlExportEngine::$exportID);
            // The BOM will help some programs like Microsoft Excel read your export file if it includes non-English characters.
            if ($exportOptions['include_bom']) {
                file_put_contents($export_file, chr(0xef) . chr(0xbb) . chr(0xbf) . substr($xmlWriter->flush(true), 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1));
            } else {
                file_put_contents($export_file, substr($xmlWriter->flush(true), 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1));
            }
            PMXE_Plugin::$session->set('file', $export_file);
            PMXE_Plugin::$session->save_data();
        } else {
            file_put_contents(PMXE_Plugin::$session->file, substr(substr($xmlWriter->flush(true), 41 + strlen($exportOptions['main_xml_tag'])), 0, (strlen($exportOptions['main_xml_tag']) + 4) * -1), FILE_APPEND);
        }
        return true;
    }
}
예제 #11
0
 protected function prepare_export_data($record, $options, $elId)
 {
     $data = array();
     $element_value = str_replace("item_data__", "", $options['cc_value'][$elId]);
     if (!empty($element_value)) {
         $implode_delimiter = XmlExportEngine::$implode;
         $element_name = !empty($options['cc_name'][$elId]) ? $options['cc_name'][$elId] : 'untitled_' . $elId;
         $fieldSnipped = (!empty($options['cc_php'][$elId]) and !empty($options['cc_code'][$elId])) ? $options['cc_code'][$elId] : false;
         switch ($element_value) {
             case 'attributes':
                 $_product_attributes = empty($record->post_parent) ? get_post_meta($record->ID, '_product_attributes', true) : get_post_meta($record->post_parent, '_product_attributes', true);
                 if (empty(self::$_existing_attributes)) {
                     global $wp_taxonomies;
                     foreach ($wp_taxonomies as $key => $obj) {
                         if (in_array($obj->name, array('nav_menu'))) {
                             continue;
                         }
                         if (strpos($obj->name, "pa_") === 0 and strlen($obj->name) > 3 and !in_array($obj->name, self::$_existing_attributes)) {
                             self::$_existing_attributes[] = $obj->name;
                         }
                     }
                 }
                 // combine taxonomies attributes
                 if (!empty(self::$_existing_attributes)) {
                     foreach (self::$_existing_attributes as $taxonomy_slug) {
                         $taxonomy = get_taxonomy($taxonomy_slug);
                         $data['Attribute Name (' . $taxonomy_slug . ')'] = $taxonomy->labels->name;
                         $data['Attribute In Variations (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_variation']) ? "yes" : "no";
                         $data['Attribute Is Visible (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_visible']) ? "yes" : "no";
                         $data['Attribute Is Taxonomy (' . $taxonomy_slug . ')'] = !empty($_product_attributes[$taxonomy_slug]['is_taxonomy']) ? "yes" : "no";
                         $element_name = 'Attribute Value (' . $taxonomy_slug . ')';
                         if ($record->post_parent == 0) {
                             $txes_list = get_the_terms($record->ID, $taxonomy_slug);
                             if (!is_wp_error($txes_list) and !empty($txes_list)) {
                                 $attr_new = array();
                                 foreach ($txes_list as $t) {
                                     $attr_new[] = $t->name;
                                 }
                                 $data[$element_name] = apply_filters('pmxe_woo_attribute', pmxe_filter(implode($implode_delimiter, $attr_new), $fieldSnipped), $record->ID, $taxonomy_slug);
                             } else {
                                 $data[$element_name] = pmxe_filter('', $fieldSnipped);
                             }
                         } else {
                             $variation_attribute = get_post_meta($record->ID, 'attribute_' . $taxonomy_slug, true);
                             $data[$element_name] = apply_filters('pmxe_woo_attribute', pmxe_filter($variation_attribute, $fieldSnipped), $record->ID, $taxonomy_slug);
                         }
                     }
                 }
                 // combine custom attributes
                 if (!empty(self::$products_data['attributes'])) {
                     foreach (self::$products_data['attributes'] as $attribute) {
                         $attribute_standart_name = str_replace('attribute_', '', $attribute->meta_key);
                         $attribute_name = ucfirst($attribute_standart_name);
                         $data['Attribute Name (' . $attribute_name . ')'] = $attribute_name;
                         $data['Attribute Value (' . $attribute_name . ')'] = get_post_meta($record->ID, $attribute->meta_key, true);
                         $data['Attribute In Variations (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_variation']) ? "yes" : "no";
                         $data['Attribute Is Visible (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_visible']) ? "yes" : "no";
                         $data['Attribute Is Taxonomy (' . $attribute_name . ')'] = !empty($_product_attributes[$attribute_standart_name]['is_taxonomy']) ? "yes" : "no";
                     }
                 }
                 break;
             default:
                 $cur_meta_values = get_post_meta($record->ID, $element_value);
                 if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                     foreach ($cur_meta_values as $key => $cur_meta_value) {
                         $fieldOptions = $options['cc_options'][$elId];
                         $fieldSettings = empty($options['cc_settings'][$elId]) ? $fieldOptions : $options['cc_settings'][$elId];
                         switch ($element_value) {
                             case '_downloadable_files':
                                 $files = maybe_unserialize($cur_meta_value);
                                 $file_paths = array();
                                 $file_names = array();
                                 if (!empty($files)) {
                                     foreach ($files as $key => $file) {
                                         $file_paths[] = $file['file'];
                                         $file_names[] = $file['name'];
                                     }
                                 }
                                 $data[$element_name . ' Paths'] = pmxe_filter(implode($implode_delimiter, $file_paths), $fieldSnipped);
                                 $data[$element_name . ' Names'] = pmxe_filter(implode($implode_delimiter, $file_names), $fieldSnipped);
                                 break;
                             case '_crosssell_ids':
                             case '_upsell_ids':
                                 $sell_export_type = empty($options['cc_settings'][$elId]) ? 'sku' : $options['cc_settings'][$elId];
                                 $_ids = maybe_unserialize($cur_meta_value);
                                 $_values = array();
                                 if (!empty($_ids)) {
                                     switch ($sell_export_type) {
                                         case 'sku':
                                             foreach ($_ids as $_id) {
                                                 $_values[] = get_post_meta($_id, '_sku', true);
                                             }
                                             break;
                                         case 'id':
                                             $_values = $_ids;
                                             break;
                                         case 'name':
                                             foreach ($_ids as $_id) {
                                                 $p = get_post($_id);
                                                 if ($p) {
                                                     $_values[] = $p->post_name;
                                                 }
                                             }
                                             break;
                                         default:
                                             # code...
                                             break;
                                     }
                                 }
                                 $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter(implode($implode_delimiter, $_values), $fieldSnipped), $element_value, $record->ID);
                                 break;
                             case '_sale_price_dates_from':
                             case '_sale_price_dates_to':
                                 if (!empty($fieldSettings)) {
                                     switch ($fieldSettings) {
                                         case 'unix':
                                             $post_date = $cur_meta_value;
                                             break;
                                         default:
                                             $post_date = date($fieldSettings, $cur_meta_value);
                                             break;
                                     }
                                 } else {
                                     $post_date = $cur_meta_value;
                                 }
                                 $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter($post_date, $fieldSnipped), $element_value, $record->ID);
                                 // wp_all_export_write_article( $article, $element_name, apply_filters('pmxe_post_date', pmxe_filter($post_date, $fieldSnipped), $record->ID) );
                                 break;
                             case '_tax_class':
                                 if ($cur_meta_value == '') {
                                     $tax_status = get_post_meta($record->ID, '_tax_status', true);
                                     if ('taxable' == $tax_status) {
                                         $cur_meta_value = 'standard';
                                     }
                                 }
                                 $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter($cur_meta_value, $fieldSnipped), $element_value, $record->ID);
                                 break;
                             default:
                                 if (empty($data[$element_name])) {
                                     $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $element_value, $record->ID);
                                 } else {
                                     $data[$element_name . '_' . $key] = apply_filters('pmxe_woo_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $element_value, $record->ID);
                                 }
                                 break;
                         }
                     }
                 }
                 if (empty($cur_meta_values)) {
                     $data[$element_name] = apply_filters('pmxe_woo_field', pmxe_filter('', $fieldSnipped), $element_value, $record->ID);
                 }
                 break;
         }
     }
     return $data;
 }
 protected function prepare_export_data($record, $options, $elId)
 {
     // an array with data to export
     $data = array();
     global $wpdb;
     $table_prefix = $wpdb->prefix;
     if (!empty($options['cc_value'][$elId])) {
         $fieldSnipped = (!empty($options['cc_php'][$elId]) and !empty($options['cc_code'][$elId])) ? $options['cc_code'][$elId] : false;
         switch ($options['cc_options'][$elId]) {
             case 'order':
             case 'customer':
                 $data[$options['cc_name'][$elId]] = strpos($options['cc_value'][$elId], "_") === 0 ? get_post_meta($record->ID, $options['cc_value'][$elId], true) : $record->{$options}['cc_value'][$elId];
                 if ($options['cc_value'][$elId] == "post_title") {
                     $data[$options['cc_name'][$elId]] = str_replace("–", '-', $data[$options['cc_name'][$elId]]);
                 }
                 $data[$options['cc_name'][$elId]] = pmxe_filter($data[$options['cc_name'][$elId]], $fieldSnipped);
                 break;
         }
     }
     return $data;
 }
function pmxe_export_acf_field_csv($field_value, $exportOptions, $ID, $recordID, &$article, &$acfs, $element_name = '', $fieldSnipped = '', $group_id = '', $preview = false, $parent_field_name = '', $return_value = false)
{
    $put_to_csv = true;
    $field_name = $ID ? $exportOptions['cc_label'][$ID] : $exportOptions['name'];
    $field_options = $ID ? unserialize($exportOptions['cc_options'][$ID]) : $exportOptions;
    if (!empty($field_value)) {
        global $acf;
        $field_value = maybe_unserialize($field_value);
        $implode_delimiter = $exportOptions['delimiter'] == ',' ? '|' : ',';
        // switch ACF field type
        switch ($field_options['type']) {
            case 'date_time_picker':
            case 'date_picker':
                $field_value = date('Ymd', strtotime($field_value));
                break;
            case 'file':
            case 'image':
                if (is_numeric($field_value)) {
                    $field_value = wp_get_attachment_url($field_value);
                } elseif (is_array($field_value)) {
                    $field_value = $field_value['url'];
                }
                break;
            case 'gallery':
                $v = array();
                foreach ($field_value as $key => $item) {
                    $v[] = $item['url'];
                }
                $field_value = implode($implode_delimiter, $v);
                break;
            case 'location-field':
                $localion_parts = explode("|", $field_value);
                $acfs[] = $element_name . '_address';
                $acfs[] = $element_name . '_lat';
                $acfs[] = $element_name . '_lng';
                if (!empty($localion_parts)) {
                    $article[$element_name . '_address'] = $localion_parts[0];
                    if (!empty($localion_parts[1])) {
                        $coordinates = explode(",", $localion_parts[1]);
                        if (!empty($coordinates)) {
                            $article[$element_name . '_lat'] = $coordinates[0];
                            $article[$element_name . '_lng'] = $coordinates[1];
                        }
                    }
                }
                $put_to_csv = false;
                break;
            case 'paypal_item':
                $acfs[] = $element_name . '_item_name';
                $acfs[] = $element_name . '_item_description';
                $acfs[] = $element_name . '_price';
                if (is_array($field_value)) {
                    foreach ($field_value as $key => $value) {
                        $article[$element_name . '_' . $key] = $value;
                    }
                }
                $put_to_csv = false;
                break;
            case 'google_map':
                $article[$element_name . '_address'] = $field_value['address'];
                $acfs[] = $element_name . '_address';
                $article[$element_name . '_lat'] = $field_value['lat'];
                $acfs[] = $element_name . '_lat';
                $article[$element_name . '_lng'] = $field_value['lng'];
                $acfs[] = $element_name . '_lng';
                $put_to_csv = false;
                break;
            case 'acf_cf7':
            case 'gravity_forms_field':
                if (!empty($field_options['multiple'])) {
                    $field_value = implode($implode_delimiter, $field_value);
                }
                break;
            case 'page_link':
                if (is_array($field_value)) {
                    $field_value = implode($implode_delimiter, $field_value);
                }
                break;
            case 'post_object':
                if (!empty($field_options['multiple'])) {
                    $v = array();
                    foreach ($field_value as $key => $pid) {
                        if (is_numeric($pid)) {
                            $entry = get_post($pid);
                            if ($entry) {
                                $v[] = $entry->post_name;
                            }
                        } else {
                            $v[] = $pid->post_name;
                        }
                    }
                    $field_value = implode($implode_delimiter, $v);
                } else {
                    if (is_numeric($field_value)) {
                        $entry = get_post($field_value);
                        if ($entry) {
                            $field_value = $entry->post_name;
                        }
                    } else {
                        $field_value = $field_value->post_name;
                    }
                }
                break;
            case 'relationship':
                $v = array();
                foreach ($field_value as $key => $pid) {
                    $entry = get_post($pid);
                    if ($entry) {
                        $v[] = $entry->post_title;
                    }
                }
                $field_value = implode($implode_delimiter, $v);
                break;
            case 'user':
                if (!empty($field_options['multiple'])) {
                    $v = array();
                    foreach ($field_value as $key => $user) {
                        if (is_numeric($user)) {
                            $entry = get_user_by('ID', $user);
                            if ($entry) {
                                $v[] = $entry->user_email;
                            }
                        } else {
                            $v[] = $user['user_email'];
                        }
                    }
                    $field_value = implode($implode_delimiter, $v);
                } else {
                    if (is_numeric($field_value)) {
                        $entry = get_user_by('ID', $field_value);
                        if ($entry) {
                            $field_value = $entry->user_email;
                        }
                    } else {
                        $field_value = $field_value['user_email'];
                    }
                }
                break;
            case 'taxonomy':
                if (!in_array($field_options['field_type'], array('radio', 'select'))) {
                    $v = array();
                    foreach ($field_value as $key => $tid) {
                        $entry = get_term($tid, $field_options['taxonomy']);
                        if ($entry and !is_wp_error($entry)) {
                            $v[] = $entry->name;
                        }
                    }
                    $field_value = implode($implode_delimiter, $v);
                } else {
                    $entry = get_term($field_value, $field_options['taxonomy']);
                    if ($entry) {
                        $field_value = $entry->name;
                    }
                }
                break;
            case 'select':
                if (!empty($field_options['multiple'])) {
                    $field_value = implode($implode_delimiter, $field_value);
                }
                break;
            case 'checkbox':
                $field_value = implode($implode_delimiter, $field_value);
                break;
            case 'repeater':
                if (have_rows($field_name, $recordID)) {
                    $repeater_element_name = empty($ID) ? $parent_field_name : $element_name;
                    if (!empty($ID)) {
                        $acfs[$repeater_element_name] = array();
                    }
                    $rowValues = array();
                    while (have_rows($field_name, $recordID)) {
                        the_row();
                        $row = XmlExportACF::acf_get_row();
                        foreach ($row['field']['sub_fields'] as $sub_field) {
                            if ($acf and version_compare($acf->settings['version'], '5.0.0') >= 0) {
                                // get
                                $v = $row['value'][$row['i']][$sub_field['key']];
                                //acf_format_value($row['value'][ $row['i'] ][ $sub_field['key'] ], $row['post_id'], $sub_field);
                            } else {
                                $v = get_sub_field($sub_field['name']);
                            }
                            $sub_field['delimiter'] = $exportOptions['delimiter'];
                            switch ($sub_field['type']) {
                                case 'repeater':
                                    pmxe_export_acf_field_csv($v, $sub_field, false, $recordID, $article, $acfs, str_replace('acf' . $group_id, '', $element_name) . '_' . $sub_field['name'], '', '', false, $element_name);
                                    break;
                                case 'google_map':
                                case 'paypal_item':
                                case 'location-field':
                                    $rowValues[$sub_field['name']][] = is_array($v) ? implode($exportOptions['delimiter'], $v) : $v;
                                    break;
                                default:
                                    $sub_field_value = pmxe_export_acf_field_csv($v, $sub_field, false, $recordID, $article, $acfs, str_replace('acf' . $group_id, '', $element_name) . '_' . $sub_field['name'], '', '', false, $element_name, true);
                                    $rowValues[$sub_field['name']][] = is_array($sub_field_value) ? implode($exportOptions['delimiter'], $sub_field_value) : $sub_field_value;
                                    break;
                            }
                            // if ($sub_field['type'] == 'repeater')
                            // {
                            // 	$sub_field['delimiter'] = $exportOptions['delimiter'];
                            // 	pmxe_export_acf_field_csv($v, $sub_field, false, $recordID, $article, $acfs, str_replace('acf' . $group_id, '', $element_name) . '_' . $sub_field['name'], '', '', false, $element_name);
                            // }
                            // else
                            // {
                            // 	$rowValues[$sub_field['name']][] = (is_array($v)) ? implode($exportOptions['delimiter'], $v) : $v;
                            // }
                        }
                    }
                    foreach ($rowValues as $key => $values) {
                        $article[$element_name . '_' . $key] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars(implode($exportOptions['delimiter'], $values)))) : implode($exportOptions['delimiter'], $values);
                        if (!in_array($element_name . '_' . $key, $acfs[$repeater_element_name])) {
                            $acfs[$repeater_element_name][] = $element_name . '_' . $key;
                        }
                    }
                }
                $put_to_csv = false;
                break;
            case 'flexible_content':
                // check if the flexible content field has rows of data
                if (have_rows($field_name)) {
                    // loop through the rows of data
                    while (have_rows($field_name)) {
                        the_row();
                        $row = XmlExportACF::acf_get_row();
                        foreach ($row['field']['layouts'] as $layout) {
                            if ($layout['name'] == $row['value'][$row['i']]['acf_fc_layout']) {
                                foreach ($layout['sub_fields'] as $sub_field) {
                                    if (isset($row['value'][$row['i']][$sub_field['key']])) {
                                        // get
                                        $v = $row['value'][$row['i']][$sub_field['key']];
                                        //acf_format_value($row['value'][ $row['i'] ][ $sub_field['key'] ], $row['post_id'], $sub_field);
                                        $article[$element_name . '_' . $layout['name'] . '_' . $row['i'] . '_' . $sub_field['name']] = $v;
                                        $acfs[] = $element_name . '_' . $layout['name'] . '_' . $row['i'] . '_' . $sub_field['name'];
                                        //pmxe_export_acf_field_csv($v, $sub_field, false, $recordID, $article, $acfs, str_replace('acf' . $group_id, '', $element_name) . '_' . $row['value'][ $row['i'] ]['acf_fc_layout'] . '_' . $row['i'] . '_' . $sub_field['name'], '', '', true);
                                    }
                                }
                            }
                        }
                    }
                } else {
                    // no layouts found
                }
                $put_to_csv = false;
                break;
            default:
                break;
        }
    }
    if ($return_value) {
        return $field_value;
    }
    if ($put_to_csv) {
        switch ($field_options['type']) {
            case 'repeater':
                global $acf;
                if ($acf->settings['version'] and version_compare($acf->settings['version'], '5.0.0') >= 0) {
                    $acf_fields = get_posts(array('posts_per_page' => -1, 'post_type' => 'acf-field', 'post_parent' => $field_options['ID'], 'post_status' => 'publish', 'orderby' => 'menu_order', 'order' => 'ASC'));
                    if (!empty($acf_fields)) {
                        foreach ($acf_fields as $field) {
                            $sub_name = $element_name . '_' . $field->post_excerpt;
                            if (!in_array($sub_name, $acfs)) {
                                $acfs[] = $sub_name;
                            }
                        }
                    }
                }
                break;
            case 'google_map':
            case 'location-field':
                $acfs[] = $element_name . '_address';
                $acfs[] = $element_name . '_lat';
                $acfs[] = $element_name . '_lng';
                break;
            case 'paypal_item':
                $acfs[] = $element_name . '_item_name';
                $acfs[] = $element_name . '_item_description';
                $acfs[] = $element_name . '_price';
                break;
            default:
                $val = apply_filters('pmxe_acf_field', pmxe_filter(!empty($field_value) ? maybe_serialize($field_value) : '', $fieldSnipped), $field_name, $recordID);
                $article[$element_name] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val;
                $acfs[] = $element_name;
                break;
        }
    }
}
예제 #14
0
 public static function export_acf_field($field_value = '', $exportOptions, $ID, $pid, &$article, $xmlWriter = false, &$acfs, $element_name = '', $element_name_ns = '', $fieldSnipped = '', $group_id = '', $preview = false, $return_value = false)
 {
     global $acf;
     $put_to_csv = true;
     $field_name = $ID ? $exportOptions['cc_label'][$ID] : $exportOptions['name'];
     $field_options = $ID ? unserialize($exportOptions['cc_options'][$ID]) : $exportOptions;
     $field_settings = $ID ? json_decode($exportOptions['cc_settings'][$ID], true) : false;
     $is_xml_export = $xmlWriter and XmlExportEngine::$exportOptions['export_to'] == 'xml';
     if (!empty($field_value)) {
         $field_value = maybe_unserialize($field_value);
         $implode_delimiter = (isset($exportOptions['delimiter']) and $exportOptions['delimiter'] == ',') ? '|' : ',';
         switch ($field_options['type']) {
             case 'date_time_picker':
             case 'date_picker':
                 $field_value = date('Ymd', strtotime($field_value));
                 break;
             case 'file':
             case 'image':
                 if (is_numeric($field_value)) {
                     $field_value = wp_get_attachment_url($field_value);
                 } elseif (is_array($field_value)) {
                     $field_value = $field_value['url'];
                 }
                 break;
             case 'gallery':
                 $v = array();
                 foreach ($field_value as $key => $item) {
                     $v[] = $item['url'];
                 }
                 $field_value = implode($implode_delimiter, $v);
                 break;
             case 'location-field':
                 $localion_parts = explode("|", $field_value);
                 if ($is_xml_export) {
                     if (!empty($localion_parts)) {
                         $xmlWriter->beginElement($element_name_ns, $element_name, null);
                         $xmlWriter->startElement('address');
                         $xmlWriter->writeData($localion_parts[0]);
                         $xmlWriter->endElement();
                         if (!empty($localion_parts[1])) {
                             $coordinates = explode(",", $localion_parts[1]);
                             if (!empty($coordinates)) {
                                 $xmlWriter->startElement('lat');
                                 $xmlWriter->writeData($coordinates[0]);
                                 $xmlWriter->endElement();
                                 $xmlWriter->startElement('lng');
                                 $xmlWriter->writeData($coordinates[1]);
                                 $xmlWriter->endElement();
                             }
                         }
                         $xmlWriter->endElement();
                     }
                 } else {
                     if (!$return_value) {
                         $acfs[$element_name] = array($element_name . '_address', $element_name . '_lat', $element_name . '_lng');
                         if (!empty($localion_parts)) {
                             $article[$element_name . '_address'] = $localion_parts[0];
                             if (!empty($localion_parts[1])) {
                                 $coordinates = explode(",", $localion_parts[1]);
                                 if (!empty($coordinates)) {
                                     $article[$element_name . '_lat'] = $coordinates[0];
                                     $article[$element_name . '_lng'] = $coordinates[1];
                                 }
                             }
                         }
                     } else {
                         if (!empty($localion_parts)) {
                             $return_value = array('address' => $localion_parts[0]);
                             if (!empty($localion_parts[1])) {
                                 $coordinates = explode(",", $localion_parts[1]);
                                 if (!empty($coordinates)) {
                                     $return_value['lat'] = $coordinates[0];
                                     $return_value['lng'] = $coordinates[1];
                                 }
                             }
                         }
                     }
                 }
                 $put_to_csv = false;
                 break;
             case 'paypal_item':
                 if ($is_xml_export) {
                     $xmlWriter->beginElement($element_name_ns, $element_name, null);
                     if (is_array($field_value)) {
                         foreach ($field_value as $key => $value) {
                             $xmlWriter->beginElement($element_name_ns, $key, null);
                             $xmlWriter->writeData($value);
                             $xmlWriter->endElement();
                         }
                     }
                     $xmlWriter->endElement();
                 } else {
                     if (!$return_value) {
                         $acfs[$element_name] = array($element_name . '_item_name', $element_name . '_item_description', $element_name . '_price');
                         if (is_array($field_value)) {
                             foreach ($field_value as $key => $value) {
                                 $article[$element_name . '_' . $key] = $value;
                             }
                         }
                     }
                 }
                 $put_to_csv = false;
                 break;
             case 'google_map':
                 if ($is_xml_export) {
                     $xmlWriter->beginElement($element_name_ns, $element_name, null);
                     $xmlWriter->startElement('address');
                     $xmlWriter->writeData($field_value['address']);
                     $xmlWriter->endElement();
                     $xmlWriter->startElement('lat');
                     $xmlWriter->writeData($field_value['lat']);
                     $xmlWriter->endElement();
                     $xmlWriter->startElement('lng');
                     $xmlWriter->writeData($field_value['lng']);
                     $xmlWriter->endElement();
                     $xmlWriter->endElement();
                 } else {
                     if (!$return_value) {
                         $acfs[$element_name] = array($element_name . '_address', $element_name . '_lat', $element_name . '_lng');
                         $article[$element_name . '_address'] = $field_value['address'];
                         $article[$element_name . '_lat'] = $field_value['lat'];
                         $article[$element_name . '_lng'] = $field_value['lng'];
                     }
                 }
                 $put_to_csv = false;
                 break;
             case 'acf_cf7':
             case 'gravity_forms_field':
                 if (!empty($field_options['multiple'])) {
                     $field_value = implode($implode_delimiter, $field_value);
                 }
                 break;
             case 'page_link':
                 if (is_array($field_value)) {
                     $field_value = implode($implode_delimiter, $field_value);
                 }
                 break;
             case 'post_object':
                 if (!empty($field_options['multiple'])) {
                     $v = array();
                     foreach ($field_value as $key => $pid) {
                         if (is_numeric($pid)) {
                             $entry = get_post($pid);
                             if ($entry) {
                                 $v[] = $entry->post_name;
                             }
                         } else {
                             $v[] = $pid->post_name;
                         }
                     }
                     $field_value = implode($implode_delimiter, $v);
                 } else {
                     if (is_numeric($field_value)) {
                         $entry = get_post($field_value);
                         if ($entry) {
                             $field_value = $entry->post_name;
                         }
                     } else {
                         $field_value = $field_value->post_name;
                     }
                 }
                 break;
             case 'relationship':
                 $v = array();
                 foreach ($field_value as $key => $pid) {
                     $entry = get_post($pid);
                     if ($entry) {
                         $v[] = $entry->post_title;
                     }
                 }
                 $field_value = implode($implode_delimiter, $v);
                 break;
             case 'user':
                 if (!empty($field_options['multiple'])) {
                     $v = array();
                     foreach ($field_value as $key => $user) {
                         if (is_numeric($user)) {
                             $entry = get_user_by('ID', $user);
                             if ($entry) {
                                 $v[] = $entry->user_email;
                             }
                         } else {
                             $v[] = $user['user_email'];
                         }
                     }
                     $field_value = implode($implode_delimiter, $v);
                 } else {
                     if (is_numeric($field_value)) {
                         $entry = get_user_by('ID', $field_value);
                         if ($entry) {
                             $field_value = $entry->user_email;
                         }
                     } else {
                         $field_value = $field_value['user_email'];
                     }
                 }
                 break;
             case 'taxonomy':
                 if ($is_xml_export) {
                     $xmlWriter->beginElement($element_name_ns, $element_name, null);
                     if (!in_array($field_options['field_type'], array('radio', 'select'))) {
                         foreach ($field_value as $key => $tid) {
                             $entry = get_term($tid, $field_options['taxonomy']);
                             if ($entry and !is_wp_error($entry)) {
                                 $xmlWriter->startElement('term');
                                 $xmlWriter->writeData($entry->name);
                                 $xmlWriter->endElement();
                             }
                         }
                     } else {
                         $entry = get_term($field_value, $field_options['taxonomy']);
                         if ($entry) {
                             $xmlWriter->startElement('term');
                             $xmlWriter->writeData($entry->name);
                             $xmlWriter->endElement();
                         }
                     }
                     $xmlWriter->endElement();
                     $put_to_csv = false;
                 } else {
                     if (!in_array($field_options['field_type'], array('radio', 'select'))) {
                         $v = array();
                         foreach ($field_value as $key => $tid) {
                             $entry = get_term($tid, $field_options['taxonomy']);
                             if ($entry and !is_wp_error($entry)) {
                                 $v[] = $entry->name;
                             }
                         }
                         $field_value = implode($implode_delimiter, $v);
                     } else {
                         $entry = get_term($field_value, $field_options['taxonomy']);
                         if ($entry) {
                             $field_value = $entry->name;
                         }
                     }
                 }
                 break;
             case 'select':
                 if (!empty($field_options['multiple'])) {
                     $field_value = implode($implode_delimiter, $field_value);
                 }
                 break;
             case 'checkbox':
                 if (is_array($field_value)) {
                     $field_value = implode($implode_delimiter, $field_value);
                 }
                 break;
             case 'repeater':
                 if ($is_xml_export) {
                     $xmlWriter->beginElement($element_name_ns, $element_name, null);
                 }
                 if (have_rows($field_name, $pid)) {
                     $rowValues = array();
                     $repeater_sub_field_names = array();
                     while (have_rows($field_name, $pid)) {
                         the_row();
                         $row = self::acf_get_row();
                         if ($is_xml_export) {
                             $xmlWriter->startElement('row');
                         }
                         foreach ($row['field']['sub_fields'] as $sub_field) {
                             if ($acf and version_compare($acf->settings['version'], '5.0.0') >= 0) {
                                 $v = $row['value'][$row['i']][$sub_field['key']];
                                 if ($is_xml_export) {
                                     $v = acf_format_value($v, $row['post_id'], $sub_field);
                                 }
                             } else {
                                 $v = get_sub_field($sub_field['name']);
                             }
                             $sub_field['delimiter'] = $implode_delimiter;
                             $sub_field_value = self::export_acf_field($v, $sub_field, false, $pid, $article, $xmlWriter, $acfs, $is_xml_export ? $sub_field['name'] : $element_name . '_' . $sub_field['name'], $element_name_ns, $fieldSnipped, '', $preview, $is_xml_export ? false : true);
                             if (!$is_xml_export) {
                                 switch ($sub_field['type']) {
                                     case 'google_map':
                                     case 'paypal_item':
                                     case 'location-field':
                                     case 'repeater':
                                         if (!empty($sub_field_value)) {
                                             foreach ($sub_field_value as $repeater_key => $repeater_value) {
                                                 $rowValues[$sub_field['name']][$repeater_key][] = is_array($repeater_value) ? implode($exportOptions['delimiter'], $repeater_value) : $repeater_value;
                                             }
                                         }
                                         break;
                                     default:
                                         $rowValues[$sub_field['name']][] = apply_filters('pmxe_acf_field', pmxe_filter(is_array($sub_field_value) ? implode($exportOptions['delimiter'], $sub_field_value) : $sub_field_value, $fieldSnipped), $sub_field['name'], $pid);
                                         break;
                                 }
                             }
                         }
                         if ($is_xml_export) {
                             $xmlWriter->endElement();
                         }
                     }
                     if ($return_value) {
                         return $rowValues;
                     }
                     if (!$is_xml_export) {
                         $additional_articles = array();
                         foreach ($rowValues as $key => $values) {
                             $is_have_subvalues = array_filter(array_keys($values), 'is_numeric');
                             if (empty($is_have_subvalues)) {
                                 foreach ($values as $subkey => $subvalue) {
                                     if (!in_array($element_name . '_' . $key . '_' . $subkey, $repeater_sub_field_names)) {
                                         $repeater_sub_field_names[] = $element_name . '_' . $key . '_' . $subkey;
                                     }
                                     // Display each repeater row in its own csv line
                                     if (!empty($field_settings) and $field_settings['repeater_field_item_per_line']) {
                                         $base_value = array_shift($subvalue);
                                         $article[$element_name . '_' . $key . '_' . $subkey] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($base_value))) : $base_value;
                                         if (!empty($subvalue)) {
                                             foreach ($subvalue as $i => $addRowValue) {
                                                 $additional_articles[$i]['settings'] = $field_settings;
                                                 $additional_articles[$i]['content'][$element_name . '_' . $key . '_' . $subkey] = $addRowValue;
                                             }
                                         }
                                     } else {
                                         $article[$element_name . '_' . $key . '_' . $subkey] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars(implode($implode_delimiter, $subvalue)))) : implode($implode_delimiter, $subvalue);
                                     }
                                 }
                             } else {
                                 if (!in_array($element_name . '_' . $key, $repeater_sub_field_names)) {
                                     $repeater_sub_field_names[] = $element_name . '_' . $key;
                                 }
                                 // Display each repeater row in its own csv line
                                 if (!empty($field_settings) and $field_settings['repeater_field_item_per_line']) {
                                     $base_value = array_shift($values);
                                     $article[$element_name . '_' . $key] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($base_value))) : $base_value;
                                     if (!empty($values)) {
                                         foreach ($values as $i => $addRowValue) {
                                             $additional_articles[$i]['settings'] = $field_settings;
                                             $additional_articles[$i]['content'][$element_name . '_' . $key] = $addRowValue;
                                         }
                                     }
                                 } else {
                                     $article[$element_name . '_' . $key] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars(implode($implode_delimiter, $values)))) : implode($implode_delimiter, $values);
                                 }
                             }
                         }
                         if (!empty($repeater_sub_field_names)) {
                             $acfs[$element_name] = $repeater_sub_field_names;
                         }
                         if (!empty($additional_articles)) {
                             foreach ($additional_articles as $i => $additional_article) {
                                 self::$additional_articles[] = $additional_article;
                             }
                         }
                     }
                 }
                 if ($is_xml_export) {
                     $xmlWriter->endElement();
                 }
                 $put_to_csv = false;
                 break;
             case 'flexible_content':
                 $fc_sub_field_names = array();
                 if ($is_xml_export) {
                     $xmlWriter->beginElement($element_name_ns, $element_name, null);
                 }
                 // check if the flexible content field has rows of data
                 if (have_rows($field_name)) {
                     // loop through the rows of data
                     while (have_rows($field_name)) {
                         the_row();
                         $row = self::acf_get_row();
                         foreach ($row['field']['layouts'] as $layout) {
                             if ($layout['name'] == $row['value'][$row['i']]['acf_fc_layout']) {
                                 if ($is_xml_export) {
                                     $xmlWriter->startElement($row['value'][$row['i']]['acf_fc_layout'] . '_' . $row['i']);
                                 }
                                 foreach ($layout['sub_fields'] as $sub_field) {
                                     $layout_field_name = $element_name . '_' . $layout['name'] . '_' . $row['i'];
                                     $v = '';
                                     if (isset($row['value'][$row['i']][$sub_field['key']])) {
                                         $v = $row['value'][$row['i']][$sub_field['key']];
                                         if ($is_xml_export) {
                                             $v = acf_format_value($v, $row['post_id'], $sub_field);
                                         }
                                     }
                                     $sub_field['delimiter'] = $implode_delimiter;
                                     $sub_field_values = self::export_acf_field($v, $sub_field, false, $pid, $article, $xmlWriter, $acfs, $is_xml_export ? $sub_field['name'] : $layout_field_name . '_' . $sub_field['name'], $element_name_ns, $fieldSnipped, '', $preview, $is_xml_export ? false : true);
                                     if (!$is_xml_export) {
                                         switch ($sub_field['type']) {
                                             case 'repeater':
                                                 if (!empty($sub_field_values)) {
                                                     foreach ($sub_field_values as $key => $values) {
                                                         $article[$layout_field_name . '_' . $key] = $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars(implode($implode_delimiter, $values)))) : implode($implode_delimiter, $values);
                                                         if (!in_array($layout_field_name . '_' . $key, $fc_sub_field_names)) {
                                                             $fc_sub_field_names[] = $layout_field_name . '_' . $key;
                                                         }
                                                     }
                                                 }
                                                 break;
                                             default:
                                                 $article[$layout_field_name . '_' . $sub_field['name']] = $v;
                                                 if (!in_array($layout_field_name . '_' . $sub_field['name'], $fc_sub_field_names)) {
                                                     $fc_sub_field_names[] = $layout_field_name . '_' . $sub_field['name'];
                                                 }
                                                 break;
                                         }
                                     }
                                 }
                                 if ($is_xml_export) {
                                     $xmlWriter->endElement();
                                 }
                             }
                         }
                     }
                 } else {
                     // no layouts found
                 }
                 if ($is_xml_export) {
                     $xmlWriter->endElement();
                 }
                 if (!empty($fc_sub_field_names)) {
                     $acfs[$element_name] = $fc_sub_field_names;
                 }
                 $put_to_csv = false;
                 break;
             default:
                 break;
         }
     }
     if ($return_value) {
         return $field_value;
     }
     if ($put_to_csv) {
         $val = apply_filters('pmxe_acf_field', pmxe_filter(!empty($field_value) ? maybe_serialize($field_value) : '', $fieldSnipped), $field_name, $pid);
         if ($is_xml_export) {
             $xmlWriter->beginElement($element_name_ns, $element_name, null);
             $xmlWriter->writeData($val);
             $xmlWriter->endElement();
         } else {
             // $article[$element_name] = ($preview) ? trim(preg_replace('~[\r\n]+~', ' ', htmlspecialchars($val))) : $val;
             wp_all_export_write_article($article, $element_name, $preview ? trim(preg_replace('~[\\r\\n]+~', ' ', htmlspecialchars($val))) : $val);
             if (!isset($acfs[$element_name])) {
                 $acfs[$element_name] = $element_name;
             }
         }
     }
 }
예제 #15
0
/**
*	Export XML helper
*/
function pmxe_export_users_xml($exportQuery, $exportOptions, $preview = false, $is_cron = false, $file_path = false)
{
    $xmlWriter = new XMLWriter();
    $xmlWriter->openMemory();
    $xmlWriter->setIndent(true);
    $xmlWriter->setIndentString("\t");
    $xmlWriter->startDocument('1.0', $exportOptions['encoding']);
    $xmlWriter->startElement('data');
    foreach ($exportQuery->results as $user) {
        //$exportQuery->the_post(); $record = get_post( get_the_ID() );
        $xmlWriter->startElement('post');
        if ($exportOptions['ids']) {
            if (wp_all_export_is_compatible() and $exportOptions['is_generate_import'] and $exportOptions['import_id']) {
                $postRecord = new PMXI_Post_Record();
                $postRecord->clear();
                $postRecord->getBy(array('post_id' => $user->ID, 'import_id' => $exportOptions['import_id']));
                if ($postRecord->isEmpty()) {
                    $postRecord->set(array('post_id' => $user->ID, 'import_id' => $exportOptions['import_id'], 'unique_key' => $user->ID))->save();
                }
                unset($postRecord);
            }
            foreach ($exportOptions['ids'] as $ID => $value) {
                if (is_numeric($ID)) {
                    if (empty($exportOptions['cc_name'][$ID]) or empty($exportOptions['cc_type'][$ID])) {
                        continue;
                    }
                    $element_name = !empty($exportOptions['cc_name'][$ID]) ? str_replace(" ", "_", $exportOptions['cc_name'][$ID]) : 'untitled_' . $ID;
                    $fieldSnipped = (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) ? $exportOptions['cc_code'][$ID] : false;
                    switch ($exportOptions['cc_type'][$ID]) {
                        case 'id':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_id', pmxe_filter($user->ID, $fieldSnipped), $user->ID));
                            break;
                        case 'user_login':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_login', pmxe_filter($user->user_login, $fieldSnipped), $user->ID));
                            break;
                        case 'user_pass':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_pass', pmxe_filter($user->user_pass, $fieldSnipped), $user->ID));
                            break;
                        case 'user_email':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_email', pmxe_filter($user->user_email, $fieldSnipped), $user->ID));
                            break;
                        case 'user_nicename':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_nicename', pmxe_filter($user->user_nicename, $fieldSnipped), $user->ID));
                            break;
                        case 'user_url':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_url', pmxe_filter($user->user_url, $fieldSnipped), $user->ID));
                            break;
                            /*case 'user_activation_key':
                            			$xmlWriter->writeElement($element_name, apply_filters('pmxe_user_activation_key', pmxe_filter($user->user_activation_key, $fieldSnipped), $user->ID));
                            			break;
                            		case 'user_status':
                            			$xmlWriter->writeElement($element_name, apply_filters('pmxe_user_status', pmxe_filter($user->user_status, $fieldSnipped), $user->ID));
                            			break;*/
                        /*case 'user_activation_key':
                        			$xmlWriter->writeElement($element_name, apply_filters('pmxe_user_activation_key', pmxe_filter($user->user_activation_key, $fieldSnipped), $user->ID));
                        			break;
                        		case 'user_status':
                        			$xmlWriter->writeElement($element_name, apply_filters('pmxe_user_status', pmxe_filter($user->user_status, $fieldSnipped), $user->ID));
                        			break;*/
                        case 'display_name':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_display_name', pmxe_filter($user->display_name, $fieldSnipped), $user->ID));
                            break;
                        case 'user_registered':
                            if (!empty($exportOptions['cc_options'][$ID])) {
                                switch ($exportOptions['cc_options'][$ID]) {
                                    case 'unix':
                                        $post_date = strtotime($user->user_registered);
                                        break;
                                    default:
                                        $post_date = date($exportOptions['cc_options'][$ID], strtotime($user->user_registered));
                                        break;
                                }
                            } else {
                                $post_date = $user->user_registered;
                            }
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_registered', pmxe_filter($post_date, $fieldSnipped), $user->ID));
                            break;
                        case 'nickname':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_nickname', pmxe_filter($user->nickname, $fieldSnipped), $user->ID));
                            break;
                        case 'first_name':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_first_name', pmxe_filter($user->first_name, $fieldSnipped), $user->ID));
                            break;
                        case 'last_name':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_last_name', pmxe_filter($user->last_name, $fieldSnipped), $user->ID));
                            break;
                        case 'wp_capabilities':
                            $xmlWriter->writeElement($element_name, apply_filters('pmxe_user_wp_capabilities', pmxe_filter(implode(",", $user->roles), $fieldSnipped), $user->ID));
                            break;
                        case 'description':
                            $xmlWriter->startElement($element_name);
                            $xmlWriter->writeCData(apply_filters('pmxe_user_description', pmxe_filter($user->description, $fieldSnipped), $user->ID));
                            $xmlWriter->endElement();
                            break;
                        case 'cf':
                            if (!empty($exportOptions['cc_value'][$ID])) {
                                $cur_meta_values = get_user_meta($user->ID, $exportOptions['cc_value'][$ID]);
                                if (!empty($cur_meta_values) and is_array($cur_meta_values)) {
                                    foreach ($cur_meta_values as $key => $cur_meta_value) {
                                        $xmlWriter->startElement($element_name);
                                        $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter(maybe_serialize($cur_meta_value), $fieldSnipped), $exportOptions['cc_value'][$ID], $user->ID));
                                        $xmlWriter->endElement();
                                    }
                                }
                                if (empty($cur_meta_values)) {
                                    $xmlWriter->startElement($element_name);
                                    $xmlWriter->writeCData(apply_filters('pmxe_custom_field', pmxe_filter('', $fieldSnipped), $exportOptions['cc_value'][$ID], $user->ID));
                                    $xmlWriter->endElement();
                                }
                            }
                            break;
                        case 'acf':
                            if (!empty($exportOptions['cc_label'][$ID]) and class_exists('acf')) {
                                global $acf;
                                $field_value = get_field($exportOptions['cc_label'][$ID], $user->ID);
                                $field_options = unserialize($exportOptions['cc_options'][$ID]);
                                pmxe_export_acf_field_xml($field_value, $exportOptions, $ID, $user->ID, $xmlWriter, $element_name, $fieldSnipped, $field_options['group_id']);
                            }
                            break;
                        case 'sql':
                            if (!empty($exportOptions['cc_sql'][$ID])) {
                                global $wpdb;
                                $val = $wpdb->get_var($wpdb->prepare(stripcslashes(str_replace("%%ID%%", "%d", $exportOptions['cc_sql'][$ID])), get_the_ID()));
                                if (!empty($exportOptions['cc_php'][$ID]) and !empty($exportOptions['cc_code'][$ID])) {
                                    // if shortcode defined
                                    if (strpos($exportOptions['cc_code'][$ID], '[') === 0) {
                                        $val = do_shortcode(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID]));
                                    } else {
                                        $val = eval('return ' . stripcslashes(str_replace("%%VALUE%%", $val, $exportOptions['cc_code'][$ID])) . ';');
                                    }
                                }
                                $xmlWriter->startElement($element_name);
                                $xmlWriter->writeCData(apply_filters('pmxe_sql_field', $val, $element_name, get_the_ID()));
                                $xmlWriter->endElement();
                            }
                            break;
                        default:
                            # code...
                            break;
                    }
                }
            }
        }
        $xmlWriter->endElement();
        // end post
        if ($preview) {
            break;
        }
    }
    $xmlWriter->endElement();
    // end data
    if ($preview) {
        return wp_all_export_remove_colons($xmlWriter->flush(true));
    }
    if ($is_cron) {
        $xml = $xmlWriter->flush(true);
        if (file_exists($file_path)) {
            file_put_contents($file_path, wp_all_export_remove_colons(substr(substr($xml, 45), 0, -8)), FILE_APPEND);
        } else {
            file_put_contents($file_path, wp_all_export_remove_colons(substr($xml, 0, -8)));
        }
        return $file_path;
    } else {
        if (empty(PMXE_Plugin::$session->file)) {
            $is_secure_import = PMXE_Plugin::getInstance()->getOption('secure');
            $wp_uploads = wp_upload_dir();
            $target = $is_secure_import ? wp_all_export_secure_file($wp_uploads['basedir'] . DIRECTORY_SEPARATOR . PMXE_Plugin::UPLOADS_DIRECTORY) : $wp_uploads['path'];
            $export_file = $target . DIRECTORY_SEPARATOR . time() . '.' . $exportOptions['export_to'];
            file_put_contents($export_file, wp_all_export_remove_colons(substr($xmlWriter->flush(true), 0, -8)));
            PMXE_Plugin::$session->set('file', $export_file);
            PMXE_Plugin::$session->save_data();
        } else {
            file_put_contents(PMXE_Plugin::$session->file, wp_all_export_remove_colons(substr(substr($xmlWriter->flush(true), 45), 0, -8)), FILE_APPEND);
        }
        return true;
    }
}