function woo_ce_generate_csv_header($dataset = '')
{
$filename = woo_ce_generate_csv_filename($dataset);
if ($filename) {
header('Content-Encoding: UTF-8');
header('Content-Type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=' . $filename);
header('Pragma: no-cache');
header('Expires: 0');
}
}
function woo_ce_generate_csv_header($export_type = '')
{
global $export;
if ($filename = woo_ce_generate_csv_filename($export_type)) {
$mime_type = 'text/csv';
header(sprintf('Content-Encoding: %s', esc_attr($export->encoding)));
header(sprintf('Content-Type: %s; charset=%s', $mime_type, esc_attr($export->encoding)));
header('Content-Transfer-Encoding: binary');
header(sprintf('Content-Disposition: attachment; filename=%s', $filename));
header('Pragma: no-cache');
header('Expires: 0');
}
}
function woo_ce_admin_init()
{
global $woo_ce, $export, $wp_roles;
include_once 'includes/formatting.php';
$action = woo_get_action();
switch ($action) {
case 'dismiss_memory_prompt':
woo_ce_update_option('dismiss_memory_prompt', 1);
$url = add_query_arg('action', null);
wp_redirect($url);
break;
case 'export':
$export = new stdClass();
$export->delimiter = $_POST['delimiter'];
if ($export->delimiter != woo_ce_get_option('delimiter')) {
woo_ce_update_option('delimiter', $export->delimiter);
}
$export->category_separator = $_POST['category_separator'];
if ($export->category_separator != woo_ce_get_option('category_separator')) {
woo_ce_update_option('category_separator', $export->category_separator);
}
$export->bom = $_POST['bom'];
if ($export->bom != woo_ce_get_option('bom')) {
woo_ce_update_option('bom', $export->bom);
}
$export->escape_formatting = $_POST['escape_formatting'];
if ($export->escape_formatting != woo_ce_get_option('escape_formatting')) {
woo_ce_update_option('escape_formatting', $export->escape_formatting);
}
$export->limit_volume = -1;
if (!empty($_POST['limit_volume'])) {
$export->limit_volume = $_POST['limit_volume'];
if ($export->limit_volume != woo_ce_get_option('limit_volume')) {
woo_ce_update_option('limit_volume', $export->limit_volume);
}
}
$export->offset = 0;
if (!empty($_POST['offset'])) {
$export->offset = (int) $_POST['offset'];
if ($export->offset != woo_ce_get_option('offset')) {
woo_ce_update_option('offset', $export->offset);
}
}
$export->delete_temporary_csv = 0;
if (!empty($_POST['delete_temporary_csv'])) {
$export->delete_temporary_csv = (int) $_POST['delete_temporary_csv'];
if ($export->limit_volume != woo_ce_get_option('delete_csv')) {
woo_ce_update_option('delete_csv', $export->delete_temporary_csv);
}
}
$export->encoding = $_POST['encoding'];
$export->order_dates_filter = false;
$export->order_dates_from = '';
$export->order_dates_to = '';
$export->order_status = false;
$export->fields = false;
$export->product_categories = false;
$export->product_tags = false;
$export->product_status = false;
$export->product_type = false;
$export->order_customer = false;
$export->order_items = 'combined';
$dataset = array();
$export->type = $_POST['dataset'];
switch ($export->type) {
case 'products':
$dataset[] = 'products';
$export->fields = isset($_POST['product_fields']) ? $_POST['product_fields'] : false;
$export->product_categories = isset($_POST['product_filter_categories']) ? woo_ce_format_product_filters($_POST['product_filter_categories']) : false;
$export->product_tags = isset($_POST['product_filter_tags']) ? woo_ce_format_product_filters($_POST['product_filter_tags']) : false;
$export->product_status = isset($_POST['product_filter_status']) ? woo_ce_format_product_filters($_POST['product_filter_status']) : false;
$export->product_type = isset($_POST['product_filter_type']) ? woo_ce_format_product_filters($_POST['product_filter_type']) : false;
break;
case 'categories':
$dataset[] = 'categories';
break;
case 'tags':
$dataset[] = 'tags';
break;
case 'orders':
$dataset[] = 'orders';
$export->fields = isset($_POST['order_fields']) ? $_POST['order_fields'] : false;
$export->order_status = isset($_POST['order_filter_status']) ? woo_ce_format_product_filters($_POST['order_filter_status']) : false;
$export->order_dates_filter = isset($_POST['order_dates_filter']) ? $_POST['order_dates_filter'] : false;
$export->order_dates_from = $_POST['order_dates_from'];
$export->order_dates_to = $_POST['order_dates_to'];
$export->order_customer = isset($_POST['order_customer']) ? $_POST['order_customer'] : false;
if (isset($_POST['order_items'])) {
$export->order_items = $_POST['order_items'];
if ($export->order_items != woo_ce_get_option('order_items_formatting')) {
woo_ce_update_option('order_items_formatting', $export->order_items);
}
}
if (isset($_POST['max_order_items'])) {
$export->max_order_items = (int) $_POST['max_order_items'];
if ($export->max_order_items != woo_ce_get_option('max_order_items')) {
woo_ce_update_option('max_order_items', $export->max_order_items);
}
}
break;
case 'customers':
$dataset[] = 'customers';
$export->fields = $_POST['customer_fields'];
break;
case 'coupons':
$dataset[] = 'coupons';
$export->fields = $_POST['coupon_fields'];
break;
}
if ($dataset) {
$timeout = 600;
if (isset($_POST['timeout'])) {
$timeout = (int) $_POST['timeout'];
if ($timeout != woo_ce_get_option('timeout')) {
woo_ce_update_option('timeout', $timeout);
}
}
if (!ini_get('safe_mode')) {
@set_time_limit($timeout);
}
@ini_set('memory_limit', WP_MAX_MEMORY_LIMIT);
@ini_set('max_execution_time', (int) $timeout);
$args = array('limit_volume' => $export->limit_volume, 'offset' => $export->offset, 'encoding' => $export->encoding, 'product_categories' => $export->product_categories, 'product_tags' => $export->product_tags, 'product_status' => $export->product_status, 'product_type' => $export->product_type, 'order_status' => $export->order_status, 'order_dates_filter' => $export->order_dates_filter, 'order_dates_from' => woo_ce_format_order_date($export->order_dates_from), 'order_dates_to' => woo_ce_format_order_date($export->order_dates_to), 'order_customer' => $export->order_customer, 'order_items' => $export->order_items);
woo_ce_save_fields($dataset, $export->fields);
$export->filename = woo_ce_generate_csv_filename($export->type);
if (isset($woo_ce['debug']) && $woo_ce['debug']) {
woo_ce_export_dataset($dataset, $args);
} else {
/* Generate CSV contents */
$bits = woo_ce_export_dataset($dataset, $args);
if (!$bits) {
wp_redirect(add_query_arg('empty', true));
exit;
}
if (isset($export->delete_temporary_csv) && $export->delete_temporary_csv) {
/* Print to browser */
woo_ce_generate_csv_header($export->type);
echo $bits;
exit;
} else {
/* Save to file and insert to WordPress Media */
if ($export->filename && $bits) {
$post_ID = woo_ce_save_csv_file_attachment($export->filename);
$upload = wp_upload_bits($export->filename, null, $bits);
$attach_data = wp_generate_attachment_metadata($post_ID, $upload['file']);
wp_update_attachment_metadata($post_ID, $attach_data);
if ($post_ID) {
woo_ce_save_csv_file_guid($post_ID, $export->type, $upload['url']);
}
woo_ce_generate_csv_header($export->type);
readfile($upload['file']);
} else {
wp_redirect(add_query_arg('failed', true));
}
exit;
}
}
}
break;
default:
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_date');
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_status');
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_customer');
break;
}
}
function woo_ce_admin_init()
{
global $export, $wp_roles;
// Now is the time to de-activate Store Exporter if Store Exporter Deluxe is activated
if (defined('WOO_CD_PREFIX')) {
include_once WOO_CE_PATH . 'includes/install.php';
woo_ce_deactivate_ce();
return;
}
// Detect if WooCommerce Subscriptions Exporter is activated
if (function_exists('wc_subs_exporter_admin_init')) {
$message = sprintf(__('We have detected a WooCommerce Plugin that is activated and known to conflict with Store Exporter, please de-activate WooCommerce Subscriptions Exporter to resolve export issues. <a href="%s" target="_blank">Need help?</a>', 'woocommerce-exporter'), $troubleshooting_url);
woo_cd_admin_notice($message, 'error', array('plugins.php', 'admin.php'));
}
// Check that we are on the Store Exporter screen
$page = isset($_GET['page']) ? sanitize_text_field($_GET['page']) : false;
if ($page != strtolower(WOO_CE_PREFIX)) {
return;
}
// Detect other platform versions
woo_ce_detect_non_woo_install();
// Process any pre-export notice confirmations
$action = woo_get_action();
switch ($action) {
// Prompt on Export screen when insufficient memory (less than 64M is allocated)
case 'dismiss_memory_prompt':
woo_ce_update_option('dismiss_memory_prompt', 1);
$url = esc_url(add_query_arg('action', null));
wp_redirect($url);
exit;
break;
// Prompt on Export screen when PHP configuration option max_execution_time cannot be increased
// Prompt on Export screen when PHP configuration option max_execution_time cannot be increased
case 'dismiss_execution_time_prompt':
woo_ce_update_option('dismiss_execution_time_prompt', 1);
$url = esc_url(add_query_arg('action', null));
wp_redirect($url);
exit;
break;
// Prompt on Export screen when insufficient memory (less than 64M is allocated)
// Prompt on Export screen when insufficient memory (less than 64M is allocated)
case 'dismiss_php_legacy':
woo_ce_update_option('dismiss_php_legacy', 1);
$url = esc_url(add_query_arg('action', null));
wp_redirect($url);
exit;
break;
case 'dismiss_subscription_prompt':
woo_ce_update_option('dismiss_subscription_prompt', 1);
$url = esc_url(add_query_arg('action', null));
wp_redirect($url);
exit;
break;
// Save skip overview preference
// Save skip overview preference
case 'skip_overview':
$skip_overview = false;
if (isset($_POST['skip_overview'])) {
$skip_overview = 1;
}
woo_ce_update_option('skip_overview', $skip_overview);
if ($skip_overview == 1) {
$url = esc_url(add_query_arg('tab', 'export'));
wp_redirect($url);
exit;
}
break;
// This is where the magic happens
// This is where the magic happens
case 'export':
// Make sure we play nice with other WooCommerce and WordPress exporters
if (isset($_POST['woo_ce_export']) && !check_admin_referer('manual_export', 'woo_ce_export')) {
return false;
}
// Set up the basic export options
$export = new stdClass();
$export->cron = 0;
$export->scheduled_export = 0;
$export->start_time = time();
$export->idle_memory_start = woo_ce_current_memory_usage();
$export->delete_file = woo_ce_get_option('delete_file', 0);
$export->encoding = woo_ce_get_option('encoding', get_option('blog_charset', 'UTF-8'));
// Reset the Encoding if corrupted
if ($export->encoding == '' || $export->encoding == false || $export->encoding == 'System default') {
error_log('[store-exporter] Encoding export option was corrupted, defaulted to UTF-8');
$export->encoding = 'UTF-8';
woo_ce_update_option('encoding', 'UTF-8');
}
$export->delimiter = woo_ce_get_option('delimiter', ',');
// Reset the Delimiter if corrupted
if ($export->delimiter == '' || $export->delimiter == false) {
error_log('[store-exporter] Delimiter export option was corrupted, defaulted to ,');
$export->delimiter = ',';
woo_ce_update_option('delimiter', ',');
}
$export->category_separator = woo_ce_get_option('category_separator', '|');
// Reset the Category Separator if corrupted
if ($export->category_separator == '' || $export->category_separator == false) {
error_log('[store-exporter] Category Separator export option was corrupted, defaulted to |');
$export->category_separator = '|';
woo_ce_update_option('category_separator', '|');
}
$export->bom = woo_ce_get_option('bom', 1);
$export->escape_formatting = woo_ce_get_option('escape_formatting', 'all');
// Reset the Escape Formatting if corrupted
if ($export->escape_formatting == '' || $export->escape_formatting == false) {
error_log('[store-exporter] Escape Formatting export option was corrupted, defaulted to all');
$export->escape_formatting = 'all';
woo_ce_update_option('escape_formatting', 'all');
}
$export->date_format = woo_ce_get_option('date_format', 'd/m/Y');
// Reset the Date Format if corrupted
if ($export->date_format == '1' || $export->date_format == '' || $export->date_format == false) {
error_log('[store-exporter] Date Format export option was corrupted, defaulted to d/m/Y');
$export->date_format = 'd/m/Y';
woo_ce_update_option('date_format', 'd/m/Y');
}
// Save export option changes made on the Export screen
$export->limit_volume = isset($_POST['limit_volume']) ? sanitize_text_field($_POST['limit_volume']) : '';
woo_ce_update_option('limit_volume', $export->limit_volume);
if ($export->limit_volume == '') {
$export->limit_volume = -1;
}
$export->offset = isset($_POST['offset']) ? sanitize_text_field($_POST['offset']) : '';
woo_ce_update_option('offset', $export->offset);
if ($export->offset == '') {
$export->offset = 0;
}
// Set default values for all export options to be later passed onto the export process
$export->fields = array();
$export->fields_order = false;
$export->export_format = 'csv';
// Product sorting
$export->product_categories = false;
$export->product_tags = false;
$export->product_status = false;
$export->product_type = false;
$export->product_orderby = false;
$export->product_order = false;
$export->gallery_formatting = false;
$export->upsell_formatting = false;
$export->crosssell_formatting = false;
// Category sorting
$export->category_orderby = false;
$export->category_order = false;
// Tag sorting
$export->tag_orderby = false;
$export->tag_order = false;
// User sorting
$export->user_orderby = false;
$export->user_order = false;
$export->type = isset($_POST['dataset']) ? sanitize_text_field($_POST['dataset']) : false;
if ($export->type) {
$export->fields = isset($_POST[$export->type . '_fields']) ? array_map('sanitize_text_field', $_POST[$export->type . '_fields']) : false;
$export->fields_order = isset($_POST[$export->type . '_fields_order']) ? array_map('absint', $_POST[$export->type . '_fields_order']) : false;
woo_ce_update_option('last_export', $export->type);
}
switch ($export->type) {
case 'product':
// Set up dataset specific options
$export->product_categories = isset($_POST['product_filter_category']) ? woo_ce_format_product_filters(array_map('absint', $_POST['product_filter_category'])) : false;
$export->product_tags = isset($_POST['product_filter_tag']) ? woo_ce_format_product_filters(array_map('absint', $_POST['product_filter_tag'])) : false;
$export->product_status = isset($_POST['product_filter_status']) ? woo_ce_format_product_filters(array_map('sanitize_text_field', $_POST['product_filter_status'])) : false;
$export->product_type = isset($_POST['product_filter_type']) ? woo_ce_format_product_filters(array_map('sanitize_text_field', $_POST['product_filter_type'])) : false;
$export->product_orderby = isset($_POST['product_orderby']) ? sanitize_text_field($_POST['product_orderby']) : false;
$export->product_order = isset($_POST['product_order']) ? sanitize_text_field($_POST['product_order']) : false;
$export->gallery_formatting = isset($_POST['product_gallery_formatting']) ? absint($_POST['product_gallery_formatting']) : false;
$export->upsell_formatting = isset($_POST['product_upsell_formatting']) ? absint($_POST['product_upsell_formatting']) : false;
$export->crosssell_formatting = isset($_POST['product_crosssell_formatting']) ? absint($_POST['product_crosssell_formatting']) : false;
// Save dataset export specific options
if ($export->product_orderby != woo_ce_get_option('product_orderby')) {
woo_ce_update_option('product_orderby', $export->product_orderby);
}
if ($export->product_order != woo_ce_get_option('product_order')) {
woo_ce_update_option('product_order', $export->product_order);
}
if ($export->upsell_formatting != woo_ce_get_option('upsell_formatting')) {
woo_ce_update_option('upsell_formatting', $export->upsell_formatting);
}
if ($export->crosssell_formatting != woo_ce_get_option('crosssell_formatting')) {
woo_ce_update_option('crosssell_formatting', $export->crosssell_formatting);
}
break;
case 'category':
// Set up dataset specific options
$export->category_orderby = isset($_POST['category_orderby']) ? sanitize_text_field($_POST['category_orderby']) : false;
$export->category_order = isset($_POST['category_order']) ? sanitize_text_field($_POST['category_order']) : false;
// Save dataset export specific options
if ($export->category_orderby != woo_ce_get_option('category_orderby')) {
woo_ce_update_option('category_orderby', $export->category_orderby);
}
if ($export->category_order != woo_ce_get_option('category_order')) {
woo_ce_update_option('category_order', $export->category_order);
}
break;
case 'tag':
// Set up dataset specific options
$export->tag_orderby = isset($_POST['tag_orderby']) ? sanitize_text_field($_POST['tag_orderby']) : false;
$export->tag_order = isset($_POST['tag_order']) ? sanitize_text_field($_POST['tag_order']) : false;
// Save dataset export specific options
if ($export->tag_orderby != woo_ce_get_option('tag_orderby')) {
woo_ce_update_option('tag_orderby', $export->tag_orderby);
}
if ($export->tag_order != woo_ce_get_option('tag_order')) {
woo_ce_update_option('tag_order', $export->tag_order);
}
break;
case 'user':
// Set up dataset specific options
$export->user_orderby = isset($_POST['user_orderby']) ? sanitize_text_field($_POST['user_orderby']) : false;
$export->user_order = isset($_POST['user_order']) ? sanitize_text_field($_POST['user_order']) : false;
// Save dataset export specific options
if ($export->user_orderby != woo_ce_get_option('user_orderby')) {
woo_ce_update_option('user_orderby', $export->user_orderby);
}
if ($export->user_order != woo_ce_get_option('user_order')) {
woo_ce_update_option('user_order', $export->user_order);
}
break;
}
if ($export->type) {
$timeout = 600;
if (isset($_POST['timeout'])) {
$timeout = absint((int) $_POST['timeout']);
if ($timeout != woo_ce_get_option('timeout')) {
woo_ce_update_option('timeout', $timeout);
}
}
if (!ini_get('safe_mode')) {
@set_time_limit((int) $timeout);
}
@ini_set('memory_limit', WP_MAX_MEMORY_LIMIT);
@ini_set('max_execution_time', (int) $timeout);
$export->args = array('limit_volume' => $export->limit_volume, 'offset' => $export->offset, 'encoding' => $export->encoding, 'date_format' => $export->date_format, 'product_categories' => $export->product_categories, 'product_tags' => $export->product_tags, 'product_status' => $export->product_status, 'product_type' => $export->product_type, 'product_orderby' => $export->product_orderby, 'product_order' => $export->product_order, 'category_orderby' => $export->category_orderby, 'category_order' => $export->category_order, 'tag_orderby' => $export->tag_orderby, 'tag_order' => $export->tag_order, 'user_orderby' => $export->user_orderby, 'user_order' => $export->user_order);
if (empty($export->fields)) {
$message = __('No export fields were selected, please try again with at least a single export field.', 'woocommerce-exporter');
woo_ce_admin_notice($message, 'error');
return false;
}
woo_ce_save_fields($export->type, $export->fields, $export->fields_order);
if ($export->export_format == 'csv') {
$export->filename = woo_ce_generate_csv_filename($export->type);
}
// Print file contents to debug export screen
if (WOO_CE_DEBUG) {
if (in_array($export->export_format, array('csv'))) {
woo_ce_export_dataset($export->type);
}
$export->idle_memory_end = woo_ce_current_memory_usage();
$export->end_time = time();
// Print file contents to browser
} else {
if (in_array($export->export_format, array('csv'))) {
// Generate CSV contents
$bits = woo_ce_export_dataset($export->type);
unset($export->fields);
if (!$bits) {
$message = __('No export entries were found, please try again with different export filters.', 'woocommerce-exporter');
woo_ce_admin_notice($message, 'error');
return false;
}
if ($export->delete_file) {
// Print to browser
if ($export->export_format == 'csv') {
woo_ce_generate_csv_header($export->type);
}
echo $bits;
exit;
} else {
// Save to file and insert to WordPress Media
if ($export->filename && $bits) {
if ($export->export_format == 'csv') {
$post_ID = woo_ce_save_file_attachment($export->filename, 'text/csv');
}
$upload = wp_upload_bits($export->filename, null, $bits);
if ($post_ID == false || $upload['error']) {
wp_delete_attachment($post_ID, true);
if (isset($upload['error'])) {
wp_redirect(esc_url(add_query_arg(array('failed' => true, 'message' => urlencode($upload['error'])))));
} else {
wp_redirect(esc_url(add_query_arg(array('failed' => true))));
}
return false;
}
$attach_data = wp_generate_attachment_metadata($post_ID, $upload['file']);
wp_update_attachment_metadata($post_ID, $attach_data);
update_attached_file($post_ID, $upload['file']);
if ($post_ID) {
woo_ce_save_file_guid($post_ID, $export->type, $upload['url']);
woo_ce_save_file_details($post_ID);
}
$export_type = $export->type;
unset($export);
// The end memory usage and time is collected at the very last opportunity prior to the CSV header being rendered to the screen
woo_ce_update_file_detail($post_ID, '_woo_idle_memory_end', woo_ce_current_memory_usage());
woo_ce_update_file_detail($post_ID, '_woo_end_time', time());
// Generate CSV header
woo_ce_generate_csv_header($export_type);
unset($export_type);
// Print file contents to screen
if ($upload['file']) {
readfile($upload['file']);
} else {
wp_redirect(esc_url(add_query_arg('failed', true)));
}
unset($upload);
} else {
wp_redirect(esc_url(add_query_arg('failed', true)));
}
}
}
exit;
}
}
break;
// Save changes on Settings screen
// Save changes on Settings screen
case 'save-settings':
// Sanitize each setting field as needed
woo_ce_update_option('export_filename', strip_tags((string) $_POST['export_filename']));
woo_ce_update_option('delete_file', sanitize_text_field((int) $_POST['delete_file']));
woo_ce_update_option('encoding', sanitize_text_field((string) $_POST['encoding']));
woo_ce_update_option('delimiter', sanitize_text_field((string) $_POST['delimiter']));
woo_ce_update_option('category_separator', sanitize_text_field((string) $_POST['category_separator']));
woo_ce_update_option('bom', absint((int) $_POST['bom']));
woo_ce_update_option('escape_formatting', sanitize_text_field((string) $_POST['escape_formatting']));
if ($_POST['date_format'] == 'custom' && !empty($_POST['date_format_custom'])) {
woo_ce_update_option('date_format', sanitize_text_field((string) $_POST['date_format_custom']));
} else {
woo_ce_update_option('date_format', sanitize_text_field((string) $_POST['date_format']));
}
$message = __('Changes have been saved.', 'woocommerce-exporter');
woo_ce_admin_notice($message);
break;
// Save changes on Field Editor screen
// Save changes on Field Editor screen
case 'save-fields':
$fields = isset($_POST['fields']) ? array_filter($_POST['fields']) : array();
$types = array_keys(woo_ce_return_export_types());
$export_type = isset($_POST['type']) ? sanitize_text_field($_POST['type']) : '';
if (in_array($export_type, $types)) {
woo_ce_update_option($export_type . '_labels', $fields);
$message = __('Changes have been saved.', 'woocommerce-exporter');
woo_ce_admin_notice($message);
} else {
$message = __('Changes could not be saved.', 'woocommerce-exporter');
woo_ce_admin_notice($message, 'error');
}
break;
}
}
function woo_ce_admin_init()
{
global $export, $wp_roles;
include_once 'includes/formatting.php';
$action = woo_get_action();
switch ($action) {
case 'dismiss_memory_prompt':
woo_ce_update_option('dismiss_memory_prompt', 1);
$url = add_query_arg('action', null);
wp_redirect($url);
exit;
break;
case 'export':
$export = new stdClass();
$export->start_time = time();
$export->idle_memory_start = woo_ce_current_memory_usage();
$export->delimiter = $_POST['delimiter'];
if ($export->delimiter != woo_ce_get_option('delimiter')) {
woo_ce_update_option('delimiter', $export->delimiter);
}
$export->category_separator = $_POST['category_separator'];
if ($export->category_separator != woo_ce_get_option('category_separator')) {
woo_ce_update_option('category_separator', $export->category_separator);
}
$export->bom = $_POST['bom'];
if ($export->bom != woo_ce_get_option('bom')) {
woo_ce_update_option('bom', $export->bom);
}
$export->escape_formatting = $_POST['escape_formatting'];
if ($export->escape_formatting != woo_ce_get_option('escape_formatting')) {
woo_ce_update_option('escape_formatting', $export->escape_formatting);
}
$export->limit_volume = -1;
if (!empty($_POST['limit_volume'])) {
$export->limit_volume = $_POST['limit_volume'];
if ($export->limit_volume != woo_ce_get_option('limit_volume')) {
woo_ce_update_option('limit_volume', $export->limit_volume);
}
}
$export->offset = 0;
if (!empty($_POST['offset'])) {
$export->offset = (int) $_POST['offset'];
if ($export->offset != woo_ce_get_option('offset')) {
woo_ce_update_option('offset', $export->offset);
}
}
$export->delete_temporary_csv = 0;
if (!empty($_POST['delete_temporary_csv'])) {
$export->delete_temporary_csv = (int) $_POST['delete_temporary_csv'];
if ($export->delete_temporary_csv != woo_ce_get_option('delete_csv')) {
woo_ce_update_option('delete_csv', $export->delete_temporary_csv);
}
}
$export->encoding = 'UTF-8';
if (!empty($_POST['encoding'])) {
$export->encoding = (string) $_POST['encoding'];
if ($export->encoding != woo_ce_get_option('encoding')) {
woo_ce_update_option('encoding', $export->encoding);
}
}
if (!empty($_POST['date_format'])) {
$export->date_format = (string) $_POST['date_format'];
if ($export->date_format != woo_ce_get_option('date_format')) {
woo_ce_update_option('date_format', $export->date_format);
}
}
$export->fields = false;
$export->product_categories = false;
$export->product_tags = false;
$export->product_status = false;
$export->product_type = false;
$export->product_orderby = false;
$export->product_order = false;
$export->category_orderby = false;
$export->category_order = false;
$export->tag_orderby = false;
$export->tag_order = false;
$export->order_dates_filter = false;
$export->order_dates_from = '';
$export->order_dates_to = '';
$export->order_status = false;
$export->order_customer = false;
$export->order_user_roles = false;
$export->order_items = 'combined';
$export->order_orderby = false;
$export->order_order = false;
$export->type = isset($_POST['dataset']) ? $_POST['dataset'] : false;
switch ($export->type) {
case 'products':
$export->fields = isset($_POST['product_fields']) ? $_POST['product_fields'] : false;
$export->product_categories = isset($_POST['product_filter_categories']) ? woo_ce_format_product_filters($_POST['product_filter_categories']) : false;
$export->product_tags = isset($_POST['product_filter_tags']) ? woo_ce_format_product_filters($_POST['product_filter_tags']) : false;
$export->product_status = isset($_POST['product_filter_status']) ? woo_ce_format_product_filters($_POST['product_filter_status']) : false;
$export->product_type = isset($_POST['product_filter_type']) ? woo_ce_format_product_filters($_POST['product_filter_type']) : false;
$export->product_orderby = isset($_POST['product_orderby']) ? $_POST['product_orderby'] : false;
if ($export->product_orderby != woo_ce_get_option('product_orderby')) {
woo_ce_update_option('product_orderby', $export->product_orderby);
}
$export->product_order = isset($_POST['product_order']) ? $_POST['product_order'] : false;
if ($export->product_order != woo_ce_get_option('product_order')) {
woo_ce_update_option('product_order', $export->product_order);
}
break;
case 'categories':
$export->fields = isset($_POST['category_fields']) ? $_POST['category_fields'] : false;
$export->category_orderby = isset($_POST['category_orderby']) ? $_POST['category_orderby'] : false;
if ($export->category_orderby != woo_ce_get_option('category_orderby')) {
woo_ce_update_option('category_orderby', $export->category_orderby);
}
$export->category_order = isset($_POST['category_order']) ? $_POST['category_order'] : false;
if ($export->category_order != woo_ce_get_option('category_order')) {
woo_ce_update_option('category_order', $export->category_order);
}
break;
case 'tags':
$export->fields = isset($_POST['tag_fields']) ? $_POST['tag_fields'] : false;
$export->tag_orderby = isset($_POST['tag_orderby']) ? $_POST['tag_orderby'] : false;
if ($export->tag_orderby != woo_ce_get_option('tag_orderby')) {
woo_ce_update_option('tag_orderby', $export->tag_orderby);
}
$export->tag_order = isset($_POST['tag_order']) ? $_POST['tag_order'] : false;
if ($export->tag_order != woo_ce_get_option('tag_order')) {
woo_ce_update_option('tag_order', $export->tag_order);
}
break;
case 'orders':
$export->fields = isset($_POST['order_fields']) ? $_POST['order_fields'] : false;
$export->order_dates_filter = isset($_POST['order_dates_filter']) ? $_POST['order_dates_filter'] : false;
$export->order_dates_from = $_POST['order_dates_from'];
$export->order_dates_to = $_POST['order_dates_to'];
$export->order_status = isset($_POST['order_filter_status']) ? woo_ce_format_product_filters($_POST['order_filter_status']) : false;
$export->order_customer = isset($_POST['order_customer']) ? $_POST['order_customer'] : false;
$export->order_user_roles = isset($_POST['order_filter_user_role']) ? woo_ce_format_user_role_filters($_POST['order_filter_user_role']) : false;
if (isset($_POST['order_items'])) {
$export->order_items = $_POST['order_items'];
if ($export->order_items != woo_ce_get_option('order_items_formatting')) {
woo_ce_update_option('order_items_formatting', $export->order_items);
}
}
if (isset($_POST['max_order_items'])) {
$export->max_order_items = (int) $_POST['max_order_items'];
if ($export->max_order_items != woo_ce_get_option('max_order_items')) {
woo_ce_update_option('max_order_items', $export->max_order_items);
}
}
$export->order_orderby = isset($_POST['order_orderby']) ? $_POST['order_orderby'] : false;
if ($export->order_orderby != woo_ce_get_option('order_orderby')) {
woo_ce_update_option('order_orderby', $export->order_orderby);
}
$export->order_order = isset($_POST['order_order']) ? $_POST['order_order'] : false;
if ($export->order_order != woo_ce_get_option('order_order')) {
woo_ce_update_option('order_order', $export->order_order);
}
break;
case 'customers':
$export->fields = $_POST['customer_fields'];
break;
case 'coupons':
$export->fields = $_POST['coupon_fields'];
break;
}
if ($export->type) {
$timeout = 600;
if (isset($_POST['timeout'])) {
$timeout = (int) $_POST['timeout'];
if ($timeout != woo_ce_get_option('timeout')) {
woo_ce_update_option('timeout', $timeout);
}
}
if (!ini_get('safe_mode')) {
@set_time_limit($timeout);
}
@ini_set('memory_limit', WP_MAX_MEMORY_LIMIT);
@ini_set('max_execution_time', (int) $timeout);
$args = array('limit_volume' => $export->limit_volume, 'offset' => $export->offset, 'encoding' => $export->encoding, 'date_format' => $export->date_format, 'product_categories' => $export->product_categories, 'product_tags' => $export->product_tags, 'product_status' => $export->product_status, 'product_type' => $export->product_type, 'product_orderby' => $export->product_orderby, 'product_order' => $export->product_order, 'category_orderby' => $export->category_orderby, 'category_order' => $export->category_order, 'tag_orderby' => $export->tag_orderby, 'tag_order' => $export->tag_order, 'order_status' => $export->order_status, 'order_dates_filter' => $export->order_dates_filter, 'order_dates_from' => woo_ce_format_order_date($export->order_dates_from), 'order_dates_to' => woo_ce_format_order_date($export->order_dates_to), 'order_customer' => $export->order_customer, 'order_user_roles' => $export->order_user_roles, 'order_items' => $export->order_items, 'order_orderby' => $export->order_orderby, 'order_order' => $export->order_order);
woo_ce_save_fields($export->type, $export->fields);
$export->filename = woo_ce_generate_csv_filename($export->type);
if (WOO_CE_DEBUG) {
woo_ce_export_dataset($export->type, $args);
$export->idle_memory_end = woo_ce_current_memory_usage();
$export->end_time = time();
} else {
// Generate CSV contents
$bits = woo_ce_export_dataset($export->type, $args);
unset($export->fields);
if (!$bits) {
wp_redirect(add_query_arg('empty', true));
exit;
}
if (isset($export->delete_temporary_csv) && $export->delete_temporary_csv) {
// Print to browser
woo_ce_generate_csv_header($export->type);
echo $bits;
exit;
} else {
// Save to file and insert to WordPress Media
if ($export->filename && $bits) {
$post_ID = woo_ce_save_csv_file_attachment($export->filename);
$upload = wp_upload_bits($export->filename, null, $bits);
if ($upload['error']) {
wp_delete_attachment($post_ID, true);
wp_redirect(add_query_arg(array('failed' => true, 'message' => urlencode($upload['error']))));
return;
}
$attach_data = wp_generate_attachment_metadata($post_ID, $upload['file']);
wp_update_attachment_metadata($post_ID, $attach_data);
if ($post_ID) {
woo_ce_save_csv_file_guid($post_ID, $export->type, $upload['url']);
woo_ce_save_csv_file_details($post_ID);
}
$export_type = $export->type;
unset($export);
// The end memory usage and time is collected at the very last opportunity prior to the CSV header being rendered to the screen
woo_ce_update_csv_file_detail($post_ID, '_woo_idle_memory_end', woo_ce_current_memory_usage());
woo_ce_update_csv_file_detail($post_ID, '_woo_end_time', time());
// Generate CSV header
woo_ce_generate_csv_header($export_type);
unset($export_type);
// Print file contents to screen
if ($upload['file']) {
readfile($upload['file']);
} else {
wp_redirect(add_query_arg('failed', true));
}
unset($upload);
} else {
wp_redirect(add_query_arg('failed', true));
}
exit;
}
}
}
break;
default:
// Detect other platform versions
woo_ce_detect_non_woo_install();
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_date');
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_status');
add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_customer');
add_action('woo_ce_export_order_options_after_table', 'woo_ce_orders_order_sorting');
add_action('woo_ce_export_after_form', 'woo_ce_products_custom_fields');
break;
}
}
function woo_ce_generate_csv_header($dataset = '')
{
global $export;
if ($filename = woo_ce_generate_csv_filename($dataset)) {
header(sprintf('Content-Encoding: %s', $export->encoding));
header(sprintf('Content-Type: text/csv; charset=%s', $export->encoding));
header('Content-Transfer-Encoding: binary');
header('Content-Disposition: attachment; filename=' . $filename);
header('Pragma: no-cache');
header('Expires: 0');
}
}