/** * 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; } }
/** * 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; } }
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; } } }