function woo_ce_generate_csv_filename($export_type = '') { // Get the filename from WordPress options $filename = woo_ce_get_option('export_filename', 'woo-export_%dataset%-%date%.csv'); // Strip other file extensions if present $filename = str_replace(array('xml', 'xls'), 'csv', $filename); if (strpos($filename, '.xml') !== false || strpos($filename, '.xls') !== false) { $filename = str_replace(array('.xml', '.xls'), '.csv', $filename); } // Add file extension if it has been removed if (strpos($filename, '.csv') === false) { $filename .= '.csv'; } // Populate the available tags $date = date('Y_m_d'); $time = date('H_i_s'); $store_name = sanitize_title(get_bloginfo('name')); // Switch out the tags for filled values $filename = str_replace('%dataset%', $export_type, $filename); $filename = str_replace('%date%', $date, $filename); $filename = str_replace('%time%', $time, $filename); $filename = str_replace('%store_name%', $store_name, $filename); // Return the filename return $filename; }
function woo_ce_override_product_vendor_field_labels($fields = array()) { $labels = woo_ce_get_option('product_vendor_labels', array()); if (!empty($labels)) { foreach ($fields as $key => $field) { if (isset($labels[$field['name']])) { $fields[$key]['label'] = $labels[$field['name']]; } } } return $fields; }
function woo_ce_get_coupon_fields($format = 'full') { $fields = array(); $fields[] = array('name' => 'coupon_code', 'label' => __('Coupon Code', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'coupon_description', 'label' => __('Coupon Description', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'discount_type', 'label' => __('Discount Type', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'coupon_amount', 'label' => __('Coupon Amount', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'individual_use', 'label' => __('Individual Use', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'apply_before_tax', 'label' => __('Apply before tax', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'exclude_sale_items', 'label' => __('Exclude sale items', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'minimum_amount', 'label' => __('Minimum Amount', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'product_ids', 'label' => __('Products', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'exclude_product_ids', 'label' => __('Exclude Products', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'product_categories', 'label' => __('Product Categories', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'exclude_product_categories', 'label' => __('Exclude Product Categories', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'customer_email', 'label' => __('Customer e-mails', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'usage_limit', 'label' => __('Usage Limit', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'expiry_date', 'label' => __('Expiry Date', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ), 'default' => 1 ); */ // Allow Plugin/Theme authors to add support for additional Coupon columns $fields = apply_filters('woo_ce_coupon_fields', $fields); if ($remember = woo_ce_get_option('coupons_fields')) { $remember = maybe_unserialize($remember); $size = count($fields); for ($i = 0; $i < $size; $i++) { if (!array_key_exists($fields[$i]['name'], $remember)) { $fields[$i]['default'] = 0; } } } switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { $output[$fields[$i]['name']] = 'on'; } return $output; break; case 'full': default: return $fields; break; } }
function woo_ce_get_category_fields($format = 'full') { $fields = array(); $fields[] = array('name' => 'term_id', 'label' => __('Term ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'name', 'label' => __('Category Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'slug', 'label' => __('Category Slug', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'parent_id', 'label' => __('Parent Term ID', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ), 'default' => 1 ); */ // Allow Plugin/Theme authors to add support for additional Category columns $fields = apply_filters('woo_ce_category_fields', $fields); if ($remember = woo_ce_get_option('categories_fields', array())) { $remember = maybe_unserialize($remember); $size = count($fields); for ($i = 0; $i < $size; $i++) { $fields[$i]['disabled'] = 0; if (!array_key_exists($fields[$i]['name'], $remember)) { $fields[$i]['default'] = 0; } } } switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { $output[$fields[$i]['name']] = 'on'; } return $output; break; case 'full': default: return $fields; break; } }
function woo_ce_user_extend( $user ) { // WooCommerce Hear About Us - https://wordpress.org/plugins/woocommerce-hear-about-us/ if( class_exists( 'WooCommerce_HearAboutUs' ) ) { $source = get_user_meta( $user->ID, '_wchau_source', true ); if( $source == '' ) $source = __( 'N/A', 'woo_ce' ); $user->hear_about_us = $source; unset( $source ); } // WooCommerce User Profile fields if( class_exists( 'WC_Admin_Profile' ) ) { $admin_profile = new WC_Admin_Profile(); if( $show_fields = $admin_profile->get_customer_meta_fields() ) { foreach( $show_fields as $fieldset ) { foreach( $fieldset['fields'] as $key => $field ) $user->{$key} = esc_attr( get_user_meta( $user->ID, $key, true ) ); } } unset( $show_fields, $fieldset, $field ); } // Custom User fields $custom_users = woo_ce_get_option( 'custom_users', '' ); if( !empty( $custom_users ) ) { foreach( $custom_users as $custom_user ) { // Check that the custom User name is filled and it hasn't previously been set if( !empty( $custom_user ) && !isset( $user->{$custom_user} ) ) { $user->{$custom_user} = woo_ce_format_custom_meta( get_user_meta( $user->ID, $custom_user, true ) ); } } } unset( $custom_users, $custom_user ); return $user; }
function woo_ce_memory_prompt() { if (!woo_ce_get_option('dismiss_memory_prompt', 0)) { $memory_limit = (int) ini_get('memory_limit'); $minimum_memory_limit = 64; if ($memory_limit < $minimum_memory_limit) { ob_start(); $memory_url = add_query_arg('action', 'dismiss_memory_prompt'); $message = sprintf(__('We recommend setting memory to at least %dMB, your site has %dMB currently allocated. See: <a href="%s" target="_blank">Increasing memory allocated to PHP</a>', 'woo_ce'), $minimum_memory_limit, $memory_limit, 'http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP'); ?> <div class="error settings-error"> <p> <strong><?php echo $message; ?> </strong> <span style="float:right;"><a href="<?php echo $memory_url; ?> "><?php _e('Dismiss', 'woo_ce'); ?> </a></span> </p> </div> <?php ob_end_flush(); } } }
function woo_ce_trigger_new_order_export( $order_id = 0 ) { global $export; if( !empty( $order_id ) ) { $export_format = woo_ce_get_option( 'trigger_new_order_format', 'csv' ); $export_fields = woo_ce_get_option( 'trigger_new_order_fields', 'all' ); $gui = woo_ce_get_option( 'trigger_new_order_method', 'archive' ); set_transient( WOO_CD_PREFIX . '_single_export_format', sanitize_text_field( $export_format ), MINUTE_IN_SECONDS ); set_transient( WOO_CD_PREFIX . '_single_export_order_ids', absint( $order_id ), MINUTE_IN_SECONDS ); set_transient( WOO_CD_PREFIX . '_single_export_fields', sanitize_text_field( $export_fields ), MINUTE_IN_SECONDS ); $export_type = 'order'; if( woo_ce_cron_export( $gui, $export_type ) ) { error_log( sprintf( '[store-exporter-deluxe] %s: Success: %s', $export->filename, sprintf( __( 'New Order #%d export saved to WordPress Media', 'woo_ce' ), $order_id ) ) ); } delete_transient( WOO_CD_PREFIX . '_single_export_format' ); delete_transient( WOO_CD_PREFIX . '_single_export_order_ids' ); delete_transient( WOO_CD_PREFIX . '_single_export_fields' ); unset( $gui, $export_type ); } }
function woo_ce_memory_prompt() { if (!woo_ce_get_option('dismiss_memory_prompt', 0)) { $memory_limit = (int) ini_get('memory_limit'); $minimum_memory_limit = 64; if ($memory_limit < $minimum_memory_limit) { $memory_url = add_query_arg('action', 'dismiss_memory_prompt'); $troubleshooting_url = 'http://www.visser.com.au/documentation/store-exporter-deluxe/usage/'; $message = sprintf(__('We recommend setting memory to at least %dMB, your site has only %dMB allocated to it. See: <a href="%s" target="_blank">Increasing memory allocated to PHP</a>', 'woo_ce'), $minimum_memory_limit, $memory_limit, $troubleshooting_url) . '<span style="float:right;"><a href="' . $memory_url . '">' . __('Dismiss', 'woo_ce') . '</a></span>'; woo_ce_admin_notice($message, 'error'); } } }
function woo_ce_extend_product_item($product, $product_id) { // Custom Product meta $custom_products = woo_ce_get_option('custom_products', ''); if (!empty($custom_products)) { foreach ($custom_products as $custom_product) { // Check that the custom Product name is filled and it hasn't previously been set if (!empty($custom_product) && !isset($product->{$custom_product})) { $product->{$custom_product} = get_post_meta($product_id, $custom_product, true); } } } return $product; }
function woo_ce_extend_user_fields($fields = array()) { // WooCommerce User fields if (class_exists('WC_Admin_Profile')) { $admin_profile = new WC_Admin_Profile(); if (method_exists('WC_Admin_Profile', 'get_customer_meta_fields')) { $show_fields = $admin_profile->get_customer_meta_fields(); foreach ($show_fields as $fieldset) { foreach ($fieldset['fields'] as $key => $field) { $fields[] = array('name' => $key, 'label' => sprintf(apply_filters('woo_ce_extend_user_fields_wc', '%s: %s'), $fieldset['title'], esc_html($field['label'])), 'disabled' => 1); } } unset($show_fields, $fieldset, $field); } } // Custom User meta $custom_users = woo_ce_get_option('custom_users', ''); if (!empty($custom_users)) { foreach ($custom_users as $custom_user) { if (!empty($custom_user)) { $fields[] = array('name' => $custom_user, 'label' => $custom_user, 'disabled' => 1); } } unset($custom_users, $custom_user); } return $fields; }
function woo_ce_extend_order_items_unique_columns( $fields = array(), $i = 0, $original_columns = array() ) { // WooCommerce Tax Rates $tax_rates = woo_ce_get_order_tax_rates(); if( !empty( $tax_rates ) ) { foreach( $tax_rates as $tax_rate ) { if( isset( $original_columns[sprintf( 'order_item_%d_tax_rate_%d', $i, $tax_rate['rate_id'] )] ) ) $fields[] = sprintf( __( 'Order Item #%d: Tax Rate - %s', 'woo_ce' ), $i, $tax_rate['label'] ); } } unset( $tax_rates, $tax_rate ); // Product Add-ons - http://www.woothemes.com/ if( $product_addons = woo_ce_get_product_addons() ) { foreach( $product_addons as $product_addon ) { if( isset( $original_columns[sprintf( 'order_item_%d_product_addon_%s', $i, $product_addon->post_name )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, $product_addon->post_title ); } } // WooCommerce Checkout Add-Ons - http://www.skyverge.com/product/woocommerce-checkout-add-ons/ if( function_exists( 'init_woocommerce_checkout_add_ons' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_checkout_addon_id', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_checkout_addon_id', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_checkout_addon_label', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_checkout_addon_label', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_checkout_addon_value', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_check_addon_value', 'name', 'unique' ) ); } // WooCommerce Brands Addon - http://woothemes.com/woocommerce/ // WooCommerce Brands - http://proword.net/Woocommerce_Brands/ if( class_exists( 'WC_Brands' ) || class_exists( 'woo_brands' ) || taxonomy_exists( apply_filters( 'woo_ce_brand_term_taxonomy', 'product_brand' ) ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_brand', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_brand', 'name', 'unique' ) ); } // Product Vendors - http://www.woothemes.com/products/product-vendors/ if( class_exists( 'WooCommerce_Product_Vendors' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_vendor', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_vendor', 'name', 'unique' ) ); } // Cost of Goods - http://www.skyverge.com/product/woocommerce-cost-of-goods-tracking/ if( class_exists( 'WC_COG' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_cost_of_goods', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_cost_of_goods', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_total_cost_of_goods', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_total_cost_of_goods', 'name', 'unique' ) ); } // WooCommerce MSRP Pricing - http://woothemes.com/woocommerce/ if( function_exists( 'woocommerce_msrp_activate' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_msrp', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_msrp', 'name', 'unique' ) ); } // Gravity Forms - http://woothemes.com/woocommerce if( class_exists( 'RGForms' ) && class_exists( 'woocommerce_gravityforms' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_gf_form_id', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_gf_form_id', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_gf_form_label', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_gf_form_label', 'name', 'unique' ) ); // Check if there are any Products linked to Gravity Forms if( $gf_fields = woo_ce_get_gravity_form_fields() ) { foreach( $gf_fields as $key => $gf_field ) { if( isset( $original_columns[sprintf( 'order_item_%d_gf_%d_%s', $i, $gf_field['formId'], $gf_field['id'] )] ) ) $fields[] = sprintf( apply_filters( 'woo_ce_extend_order_items_unique_columns_gf_fields', __( 'Order Item #%d: %s - %s', 'woo_ce' ) ), $i, $gf_field['formTitle'], $gf_field['label'] ); } } } // Local Pickup Plus - http://www.woothemes.com/products/local-pickup-plus/ if( class_exists( 'WC_Local_Pickup_Plus' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_pickup_location', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_pickup_location', 'name', 'unique' ) ); } // WooCommerce Bookings - http://www.woothemes.com/products/woocommerce-bookings/ if( class_exists( 'WC_Bookings' ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_booking_id', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_booking_id', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_booking_date', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_booking_date', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_booking_type', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_booking_type', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_booking_start_date', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_booking_start_date', 'name', 'unique' ) ); if( isset( $original_columns[sprintf( 'order_item_%d_booking_end_date', $i )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, woo_ce_get_order_field( 'order_items_booking_end_date', 'name', 'unique' ) ); } // WooCommerce TM Extra Product Options - http://codecanyon.net/item/woocommerce-extra-product-options/7908619 if( class_exists( 'TM_Extra_Product_Options' ) ) { if( $tm_fields = woo_ce_get_extra_product_option_fields() ) { foreach( $tm_fields as $tm_field ) { if( isset( $original_columns[sprintf( 'order_item_%d_tm_%s', $i, sanitize_key( $tm_field['name'] ) )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, $tm_field['name'] ); } } } // Attributes if( $attributes = woo_ce_get_product_attributes() ) { foreach( $attributes as $attribute ) { if( isset( $original_columns[sprintf( 'order_item_%d_attribute_%s', $i, sanitize_key( $attribute->attribute_name ) )] ) ) { if( empty( $attribute->attribute_label ) ) $attribute->attribute_label = $attribute->attribute_name; $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, $attribute->attribute_label ); } } } // Custom Order Items fields $custom_order_items = woo_ce_get_option( 'custom_order_items', '' ); if( !empty( $custom_order_items ) ) { foreach( $custom_order_items as $custom_order_item ) { if( !empty( $custom_order_item ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_%s', $i, $custom_order_item )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, $custom_order_item ); } } } // Custom Product fields $custom_products = woo_ce_get_option( 'custom_products', '' ); if( !empty( $custom_products ) ) { foreach( $custom_products as $custom_product ) { if( !empty( $custom_product ) ) { if( isset( $original_columns[sprintf( 'order_item_%d_%s', $i, $custom_product )] ) ) $fields[] = sprintf( __( 'Order Item #%d: %s', 'woo_ce' ), $i, $custom_product ); } } } return $fields; }
function woo_ce_admin_save_settings() { // Strip file extension from export filename $export_filename = strip_tags( $_POST['export_filename'] ); if( ( strpos( $export_filename, '.csv' ) !== false ) || ( strpos( $export_filename, '.xml' ) !== false ) || ( strpos( $export_filename, '.xls' ) !== false ) ) $export_filename = str_replace( array( '.csv', '.xml', '.xls' ), '', $export_filename ); woo_ce_update_option( 'export_filename', $export_filename ); woo_ce_update_option( 'delete_file', absint( $_POST['delete_file'] ) ); woo_ce_update_option( 'encoding', sanitize_text_field( $_POST['encoding'] ) ); woo_ce_update_option( 'delimiter', sanitize_text_field( $_POST['delimiter'] ) ); woo_ce_update_option( 'category_separator', sanitize_text_field( $_POST['category_separator'] ) ); woo_ce_update_option( 'bom', absint( $_POST['bom'] ) ); woo_ce_update_option( 'escape_formatting', sanitize_text_field( $_POST['escape_formatting'] ) ); woo_ce_update_option( 'header_formatting', absint( $_POST['header_formatting'] ) ); if( $_POST['date_format'] == 'custom' && !empty( $_POST['date_format_custom'] ) ) woo_ce_update_option( 'date_format', sanitize_text_field( $_POST['date_format_custom'] ) ); else woo_ce_update_option( 'date_format', sanitize_text_field( $_POST['date_format'] ) ); woo_ce_update_option( 'email_to', sanitize_text_field( $_POST['email_to'] ) ); woo_ce_update_option( 'email_subject', sanitize_text_field( $_POST['email_subject'] ) ); woo_ce_update_option( 'post_to', sanitize_text_field( $_POST['post_to'] ) ); // XML settings woo_ce_update_option( 'xml_attribute_url', ( isset( $_POST['xml_attribute_url'] ) ? absint( $_POST['xml_attribute_url'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_title', ( isset( $_POST['xml_attribute_title'] ) ? absint( $_POST['xml_attribute_title'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_date', ( isset( $_POST['xml_attribute_date'] ) ? absint( $_POST['xml_attribute_date'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_time', ( isset( $_POST['xml_attribute_time'] ) ? absint( $_POST['xml_attribute_time'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_export', ( isset( $_POST['xml_attribute_export'] ) ? absint( $_POST['xml_attribute_export'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_orderby', ( isset( $_POST['xml_attribute_orderby'] ) ? absint( $_POST['xml_attribute_orderby'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_order', ( isset( $_POST['xml_attribute_order'] ) ? absint( $_POST['xml_attribute_order'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_limit', ( isset( $_POST['xml_attribute_limit'] ) ? absint( $_POST['xml_attribute_limit'] ) : 0 ) ); woo_ce_update_option( 'xml_attribute_offset', ( isset( $_POST['xml_attribute_offset'] ) ? absint( $_POST['xml_attribute_offset'] ) : 0 ) ); // RSS settings woo_ce_update_option( 'rss_title', ( isset( $_POST['rss_title'] ) ? sanitize_text_field( $_POST['rss_title'] ) : '' ) ); woo_ce_update_option( 'rss_link', ( isset( $_POST['rss_link'] ) ? esc_url_raw( $_POST['rss_link'] ) : '' ) ); woo_ce_update_option( 'rss_description', ( isset( $_POST['rss_description'] ) ? sanitize_text_field( $_POST['rss_description'] ) : '' ) ); // Scheduled export settings $enable_auto = absint( $_POST['enable_auto'] ); $auto_schedule = sanitize_text_field( $_POST['auto_schedule'] ); $auto_interval = absint( $_POST['auto_interval'] ); $auto_commence = sanitize_text_field( $_POST['auto_commence'] ); $auto_commence_date = sanitize_text_field( $_POST['auto_commence_date'] ); $site_hash = md5( get_option( 'siteurl' ) ); // Display additional notice if Enabled Scheduled Exports is enabled/disabled or scheduling options are modified if( woo_ce_get_option( 'enable_auto', 0 ) <> $enable_auto || woo_ce_get_option( 'auto_schedule', 'custom' ) <> $auto_schedule || woo_ce_get_option( 'auto_interval', 1440 ) <> $auto_interval || woo_ce_get_option( 'auto_commence', 'now' ) <> $auto_commence || woo_ce_get_option( 'auto_commence_date', date( 'd/m/Y H:i' ) ) <> $auto_commence_date ) { // Save these fields before we re-load the WP-CRON schedule woo_ce_update_option( 'enable_auto', $enable_auto ); // Remove from WP-CRON schedule if disabled if( $enable_auto == 0 ) { woo_ce_cron_activation(); // Re-load the WP-CRON schedule with our new scheduling options } else if( woo_ce_get_option( 'auto_schedule', 'custom' ) <> $auto_schedule || woo_ce_get_option( 'auto_interval', 1440 ) <> $auto_interval || woo_ce_get_option( 'auto_commence', 'now' ) <> $auto_commence || woo_ce_get_option( 'auto_commence_date', date( 'd/m/Y H:i' ) ) <> $auto_commence_date || woo_ce_get_option( 'site_hash', '' ) <> $site_hash ) { // Save these fields before we re-load the WP-CRON schedule woo_ce_update_option( 'auto_commence', $auto_commence ); woo_ce_update_option( 'auto_commence_date', $auto_commence_date ); woo_ce_update_option( 'auto_schedule', $auto_schedule ); woo_ce_update_option( 'auto_interval', $auto_interval ); // Update the Site URL hash we use for live vs. staging checks woo_ce_update_option( 'site_hash', $site_hash ); woo_ce_cron_activation( true ); } switch( $auto_schedule ) { case 'daily': case 'weekly': case 'monthly': $interval = $auto_schedule; break; case 'custom': $interval = sprintf( __( 'in %d minute(s)', 'woo_ce' ), $auto_interval ); break; } switch( $auto_commence ) { case 'now': $commence = __( ' from now' ); break; case 'future': $commence = sprintf( __( ' starting %s' ), $auto_commence_date ); break; } $message = sprintf( __( 'Scheduled exports has been %s.', 'woo_ce' ), ( ( $enable_auto == 1 ) ? sprintf( __( 'activated, next scheduled export will run %s%s', 'woo_ce' ), $interval, $commence ) : __( 'de-activated, no further automated exports will occur', 'woo_ce' ) ) ); woo_cd_admin_notice( $message ); } woo_ce_update_option( 'auto_type', sanitize_text_field( $_POST['auto_type'] ) ); woo_ce_update_option( 'auto_product_type', ( isset( $_POST['product_filter_type'] ) ? array_map( 'sanitize_text_field', $_POST['product_filter_type'] ) : array() ) ); woo_ce_update_option( 'auto_product_status', ( isset( $_POST['product_filter_status'] ) ? array_map( 'sanitize_text_field', $_POST['product_filter_status'] ) : array() ) ); woo_ce_update_option( 'auto_product_stock', sanitize_text_field( $_POST['product_filter_stock'] ) ); woo_ce_update_option( 'auto_product_category', ( isset( $_POST['product_filter_category'] ) ? array_map( 'absint', $_POST['product_filter_category'] ) : array() ) ); woo_ce_update_option( 'auto_product_tag', ( isset( $_POST['product_filter_tag'] ) ? array_map( 'absint', $_POST['product_filter_tag'] ) : array() ) ); woo_ce_update_option( 'auto_order_date', sanitize_text_field( $_POST['order_dates_filter'] ) ); woo_ce_update_option( 'auto_order_dates_from', sanitize_text_field( $_POST['order_dates_from'] ) ); woo_ce_update_option( 'auto_order_dates_to', sanitize_text_field( $_POST['order_dates_to'] ) ); woo_ce_update_option( 'auto_order_date_variable', sanitize_text_field( $_POST['order_dates_filter_variable'] ) ); woo_ce_update_option( 'auto_order_date_variable_length', sanitize_text_field( $_POST['order_dates_filter_variable_length'] ) ); woo_ce_update_option( 'auto_order_status', ( isset( $_POST['order_filter_status'] ) ? woo_ce_format_product_filters( array_map( 'sanitize_text_field', $_POST['order_filter_status'] ) ) : array() ) ); // Check if we are dealing with a string or array $auto_order_product = ( isset( $_POST['order_filter_product'] ) ? $_POST['order_filter_product'] : false ); // Select2 passes us a string whereas Chosen gives us an array if( is_array( $auto_order_product ) && count( $auto_order_product ) == 1 ) $auto_order_product = explode( ',', $auto_order_product[0] ); woo_ce_update_option( 'auto_order_product', ( !empty( $auto_order_product ) ? woo_ce_format_product_filters( array_map( 'absint', $auto_order_product ) ) : array() ) ); unset( $auto_order_product ); woo_ce_update_option( 'auto_order_billing_country', ( isset( $_POST['order_filter_billing_country'] ) ? array_map( 'sanitize_text_field', $_POST['order_filter_billing_country'] ) : array() ) ); woo_ce_update_option( 'auto_order_shipping_country', ( isset( $_POST['order_filter_shipping_country'] ) ? array_map( 'sanitize_text_field', $_POST['order_filter_shipping_country'] ) : array() ) ); woo_ce_update_option( 'auto_order_payment', ( isset( $_POST['order_filter_payment'] ) ? array_map( 'sanitize_text_field', $_POST['order_filter_payment'] ) : array() ) ); woo_ce_update_option( 'auto_order_shipping', ( isset( $_POST['order_filter_shipping'] ) ? array_map( 'sanitize_text_field', $_POST['order_filter_shipping'] ) : array() ) ); woo_ce_update_option( 'auto_format', sanitize_text_field( $_POST['auto_format'] ) ); woo_ce_update_option( 'auto_method', sanitize_text_field( $_POST['auto_method'] ) ); woo_ce_update_option( 'auto_ftp_method_host', ( isset( $_POST['ftp_method_host'] ) ? woo_ce_format_ftp_host( sanitize_text_field( $_POST['ftp_method_host'] ) ) : '' ) ); woo_ce_update_option( 'auto_ftp_method_user', sanitize_text_field( $_POST['ftp_method_user'] ) ); // Update FTP password only if it is filled in if( !empty( $_POST['ftp_method_pass'] ) ) woo_ce_update_option( 'auto_ftp_method_pass', sanitize_text_field( $_POST['ftp_method_pass'] ) ); woo_ce_update_option( 'auto_ftp_method_port', sanitize_text_field( $_POST['ftp_method_port'] ) ); woo_ce_update_option( 'auto_ftp_method_protocol', sanitize_text_field( $_POST['ftp_method_protocol'] ) ); woo_ce_update_option( 'auto_ftp_method_path', sanitize_text_field( $_POST['ftp_method_path'] ) ); // Strip file extension from export filename $ftp_filename = strip_tags( $_POST['ftp_method_filename'] ); if( ( strpos( $ftp_filename, '.csv' ) !== false ) || ( strpos( $ftp_filename, '.xml' ) !== false ) || ( strpos( $ftp_filename, '.xls' ) !== false ) || ( strpos( $ftp_filename, '.xlsx' ) !== false ) ) $ftp_filename = str_replace( array( '.csv', '.xml', '.xls', '.xlsx' ), '', $ftp_filename ); woo_ce_update_option( 'auto_ftp_method_filename', $ftp_filename ); unset( $ftp_filename ); woo_ce_update_option( 'auto_ftp_method_passive', sanitize_text_field( $_POST['ftp_method_passive'] ) ); woo_ce_update_option( 'auto_ftp_method_timeout', sanitize_text_field( $_POST['ftp_method_timeout'] ) ); woo_ce_update_option( 'scheduled_fields', sanitize_text_field( $_POST['scheduled_fields'] ) ); // CRON settings $enable_cron = absint( $_POST['enable_cron'] ); // Display additional notice if Enabled CRON is enabled/disabled if( woo_ce_get_option( 'enable_cron', 0 ) <> $enable_cron ) { $message = sprintf( __( 'CRON support has been %s.', 'woo_ce' ), ( ( $enable_cron == 1 ) ? __( 'enabled', 'woo_ce' ) : __( 'disabled', 'woo_ce' ) ) ); woo_cd_admin_notice( $message ); } woo_ce_update_option( 'enable_cron', $enable_cron ); woo_ce_update_option( 'secret_key', sanitize_text_field( $_POST['secret_key'] ) ); woo_ce_update_option( 'cron_fields', sanitize_text_field( $_POST['cron_fields'] ) ); // Orders Screen woo_ce_update_option( 'order_actions_csv', ( isset( $_POST['order_actions_csv'] ) ? absint( $_POST['order_actions_csv'] ) : 0 ) ); woo_ce_update_option( 'order_actions_xml', ( isset( $_POST['order_actions_xml'] ) ? absint( $_POST['order_actions_xml'] ) : 0 ) ); woo_ce_update_option( 'order_actions_xls', ( isset( $_POST['order_actions_xls'] ) ? absint( $_POST['order_actions_xls'] ) : 0 ) ); woo_ce_update_option( 'order_actions_xlsx', ( isset( $_POST['order_actions_xlsx'] ) ? absint( $_POST['order_actions_xlsx'] ) : 0 ) ); // Export Triggers woo_ce_update_option( 'enable_trigger_new_order', ( isset( $_POST['enable_trigger_new_order'] ) ? absint( $_POST['enable_trigger_new_order'] ) : 0 ) ); woo_ce_update_option( 'trigger_new_order_format', sanitize_text_field( $_POST['trigger_new_order_format'] ) ); woo_ce_update_option( 'trigger_new_order_method', sanitize_text_field( $_POST['trigger_new_order_method'] ) ); woo_ce_update_option( 'trigger_new_order_fields', sanitize_text_field( $_POST['trigger_new_order_fields'] ) ); $message = __( 'Changes have been saved.', 'woo_ce' ); woo_cd_admin_notice( $message ); }
function woo_ce_get_commission_fields($format = 'full') { $export_type = 'commission'; $fields = array(); $fields[] = array('name' => 'ID', 'label' => __('Commission ID', 'woo_ce')); $fields[] = array('name' => 'post_date', 'label' => __('Commission Date', 'woo_ce')); $fields[] = array('name' => 'title', 'label' => __('Commission Title', 'woo_ce')); $fields[] = array('name' => 'product_id', 'label' => __('Product ID', 'woo_ce')); $fields[] = array('name' => 'product_name', 'label' => __('Product Name', 'woo_ce')); $fields[] = array('name' => 'product_sku', 'label' => __('Product SKU', 'woo_ce')); $fields[] = array('name' => 'product_vendor_id', 'label' => __('Product Vendor ID', 'woo_ce')); $fields[] = array('name' => 'product_vendor_name', 'label' => __('Product Vendor Name', 'woo_ce')); $fields[] = array('name' => 'commission_amount', 'label' => __('Commission Amount', 'woo_ce')); $fields[] = array('name' => 'paid_status', 'label' => __('Commission Status', 'woo_ce')); $fields[] = array('name' => 'post_status', 'label' => __('Post Status', 'woo_ce')); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ) ); */ // Allow Plugin/Theme authors to add support for additional columns $fields = apply_filters('woo_ce_' . $export_type . '_fields', $fields, $export_type); switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { if (isset($fields[$i])) { $output[$fields[$i]['name']] = 'on'; } } return $output; break; case 'full': default: $sorting = woo_ce_get_option($export_type . '_sorting', array()); $size = count($fields); for ($i = 0; $i < $size; $i++) { $fields[$i]['reset'] = $i; $fields[$i]['order'] = isset($sorting[$fields[$i]['name']]) ? $sorting[$fields[$i]['name']] : $i; } // Check if we are using PHP 5.3 and above if (version_compare(phpversion(), '5.3') >= 0) { usort($fields, woo_ce_sort_fields('order')); } return $fields; 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_format_description_excerpt($string = '') { if ($description_excerpt_formatting = woo_ce_get_option('description_excerpt_formatting', 0)) { $string = wp_kses($string); } return $string; }
function woo_ce_get_order_fields($format = 'full') { $fields = array(); $fields[] = array('name' => 'purchase_id', 'label' => __('Purchase ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'purchase_total', 'label' => __('Order Total', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_discount', 'label' => __('Order Discount', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => 'order_incl_tax', 'label' => __( 'Order Incl. Tax', 'woo_ce' ), 'default' => '' ); */ $fields[] = array('name' => 'order_excl_tax', 'label' => __('Order Excl. Tax', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => 'order_tax_rate', 'label' => __( 'Order Tax Rate', 'woo_ce' ), 'default' => '' ); */ $fields[] = array('name' => 'order_sales_tax', 'label' => __('Sales Tax Total', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_shipping_tax', 'label' => __('Shipping Tax Total', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'payment_gateway_id', 'label' => __('Payment Gateway ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'payment_gateway', 'label' => __('Payment Gateway', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_method_id', 'label' => __('Shipping Method ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_method', 'label' => __('Shipping Method', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_cost', 'label' => __('Shipping Cost', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'payment_status', 'label' => __('Payment Status', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_key', 'label' => __('Order Key', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'purchase_date', 'label' => __('Purchase Date', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'purchase_time', 'label' => __('Purchase Time', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'customer_note', 'label' => __('Customer Note', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_notes', 'label' => __('Order Notes', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'user_id', 'label' => __('User ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'user_name', 'label' => __('Username', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'user_role', 'label' => __('User Role', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'ip_address', 'label' => __('Checkout IP Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'browser_agent', 'label' => __('Checkout Browser Agent', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_full_name', 'label' => __('Billing: Full Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_first_name', 'label' => __('Billing: First Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_last_name', 'label' => __('Billing: Last Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_company', 'label' => __('Billing: Company', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_address', 'label' => __('Billing: Street Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_city', 'label' => __('Billing: City', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_postcode', 'label' => __('Billing: ZIP Code', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_state', 'label' => __('Billing: State (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_state_full', 'label' => __('Billing: State', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_country', 'label' => __('Billing: Country (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_country_full', 'label' => __('Billing: Country', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_phone', 'label' => __('Billing: Phone Number', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_email', 'label' => __('Billing: E-mail Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_full_name', 'label' => __('Shipping: Full Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_first_name', 'label' => __('Shipping: First Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_last_name', 'label' => __('Shipping: Last Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_company', 'label' => __('Shipping: Company', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_address', 'label' => __('Shipping: Street Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_city', 'label' => __('Shipping: City', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_postcode', 'label' => __('Shipping: ZIP Code', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_state', 'label' => __('Shipping: State (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_state_full', 'label' => __('Shipping: State', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_country', 'label' => __('Shipping: Country (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_country_full', 'label' => __('Shipping: Country', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_product_id', 'label' => __('Order Items: Product ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_variation_id', 'label' => __('Order Items: Variation ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_sku', 'label' => __('Order Items: SKU', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_name', 'label' => __('Order Items: Product Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_variation', 'label' => __('Order Items: Product Variation', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_tax_class', 'label' => __('Order Items: Tax Class', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_quantity', 'label' => __('Order Items: Quantity', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_total', 'label' => __('Order Items: Total', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_subtotal', 'label' => __('Order Items: Subtotal', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_tax', 'label' => __('Order Items: Tax', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_tax_subtotal', 'label' => __('Order Items: Tax Subtotal', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_type', 'label' => __('Order Items: Type', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_type', 'label' => __('Order Items: Type', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_category', 'label' => __('Order Items: Category', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'order_items_tag', 'label' => __('Order Items: Tag', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ), 'default' => 1 ); */ // Allow Plugin/Theme authors to add support for additional Order columns $fields = apply_filters('woo_ce_order_fields', $fields); if ($remember = woo_ce_get_option('orders_fields')) { $remember = maybe_unserialize($remember); $size = count($fields); for ($i = 0; $i < $size; $i++) { if ($fields[$i]) { if (!array_key_exists($fields[$i]['name'], $remember)) { $fields[$i]['default'] = 0; } } } } switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { $output[$fields[$i]['name']] = 'on'; } return $output; break; case 'full': default: return $fields; break; } }
function woo_ce_get_shipping_class_fields($format = 'full') { $export_type = 'shipping_class'; $fields = array(); $fields[] = array('name' => 'term_id', 'label' => __('Term ID', 'woo_ce')); $fields[] = array('name' => 'name', 'label' => __('Shipping Class Name', 'woo_ce')); $fields[] = array('name' => 'slug', 'label' => __('Shipping Class Slug', 'woo_ce')); $fields[] = array('name' => 'description', 'label' => __('Shipping Class Description', 'woo_ce')); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ) ); */ // Allow Plugin/Theme authors to add support for additional columns $fields = apply_filters('woo_ce_' . $export_type . '_fields', $fields, $export_type); switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { if (isset($fields[$i])) { $output[$fields[$i]['name']] = 'on'; } } return $output; break; case 'full': default: $sorting = woo_ce_get_option($export_type . '_sorting', array()); $size = count($fields); for ($i = 0; $i < $size; $i++) { $fields[$i]['reset'] = $i; $fields[$i]['order'] = isset($sorting[$fields[$i]['name']]) ? $sorting[$fields[$i]['name']] : $i; } // Check if we are using PHP 5.3 and above if (version_compare(phpversion(), '5.3') >= 0) { usort($fields, woo_ce_sort_fields('order')); } return $fields; break; } }
function woo_ce_extend_customer_fields( $fields = array() ) { // WooCommerce Follow-Up Emails if( class_exists( 'FollowUpEmails' ) ) { $fields[] = array( 'name' => 'followup_optout', 'label' => __( 'Follow-Up Emails: Opted Out', 'woo_ce' ) ); } // WooCommerce Hear About Us - https://wordpress.org/plugins/woocommerce-hear-about-us/ if( class_exists( 'WooCommerce_HearAboutUs' ) ) { $fields[] = array( 'name' => 'hear_about_us', 'label' => __( 'Source', 'woo_ce' ), 'hover' => __( 'WooCommerce Hear About Us', 'woo_ce' ) ); } // Custom Customer fields $custom_customers = woo_ce_get_option( 'custom_customers', '' ); if( !empty( $custom_customers ) ) { foreach( $custom_customers as $custom_customer ) { if( !empty( $custom_customer ) ) { $fields[] = array( 'name' => $custom_customer, 'label' => woo_ce_clean_export_label( $custom_customer ), 'hover' => sprintf( apply_filters( 'woo_ce_extend_customer_fields_custom_customer_hover', '%s: %s' ), __( 'Custom Customer', 'woo_ce' ), $custom_customer ) ); } } unset( $custom_customers, $custom_customer ); } // Custom User fields $custom_users = woo_ce_get_option( 'custom_users', '' ); if( !empty( $custom_users ) ) { foreach( $custom_users as $custom_user ) { if( !empty( $custom_user ) ) { $fields[] = array( 'name' => $custom_user, 'label' => woo_ce_clean_export_label( $custom_user ), 'hover' => sprintf( apply_filters( 'woo_ce_extend_customer_fields_custom_user_hover', '%s: %s' ), __( 'Custom User', 'woo_ce' ), $custom_user ) ); } } } unset( $custom_users, $custom_user ); return $fields; }
function woo_ce_export_dataset($export_type = null, &$output = null) { global $export; $separator = $export->delimiter; $export->columns = array(); $export->total_rows = 0; $export->total_columns = 0; $troubleshooting_url = 'http://www.visser.com.au/documentation/store-exporter-deluxe/usage/'; set_transient(WOO_CE_PREFIX . '_running', time(), woo_ce_get_option('timeout', MINUTE_IN_SECONDS)); // Load up the fatal error notice if we 500 Internal Server Error (memory), hit a server timeout or encounter a fatal PHP error add_action('shutdown', 'woo_ce_fatal_error'); // Drop in our content filters here add_filter('sanitize_key', 'woo_ce_sanitize_key'); switch ($export_type) { // Products case 'product': $fields = woo_ce_get_product_fields('summary'); if ($export->fields = array_intersect_assoc((array) $export->fields, $fields)) { foreach ($export->fields as $key => $field) { $export->columns[] = woo_ce_get_product_field($key); } } $export->total_columns = $size = count($export->columns); $export->data_memory_start = woo_ce_current_memory_usage(); if ($products = woo_ce_get_products($export->args)) { $export->total_rows = count($products); // Generate the export headers if (in_array($export->export_format, array('csv'))) { for ($i = 0; $i < $size; $i++) { if ($i == $size - 1) { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . "\n"; } else { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . $separator; } } } $weight_unit = get_option('woocommerce_weight_unit'); $dimension_unit = get_option('woocommerce_dimension_unit'); $height_unit = $dimension_unit; $width_unit = $dimension_unit; $length_unit = $dimension_unit; if (!empty($export->fields)) { foreach ($products as $product) { $product = woo_ce_get_product_data($product, $export->args); foreach ($export->fields as $key => $field) { if (isset($product->{$key})) { if (is_array($field)) { foreach ($field as $array_key => $array_value) { if (!is_array($array_value)) { if (in_array($export->export_format, array('csv'))) { $output .= woo_ce_escape_csv_value($array_value, $export->delimiter, $export->escape_formatting); } } } } else { if (in_array($export->export_format, array('csv'))) { $output .= woo_ce_escape_csv_value($product->{$key}, $export->delimiter, $export->escape_formatting); } } } if (in_array($export->export_format, array('csv'))) { $output .= $separator; } } if (in_array($export->export_format, array('csv'))) { $output = substr($output, 0, -1) . "\n"; } } } unset($products, $product); } $export->data_memory_end = woo_ce_current_memory_usage(); break; // Categories // Categories case 'category': $fields = woo_ce_get_category_fields('summary'); if ($export->fields = array_intersect_assoc((array) $export->fields, $fields)) { foreach ($export->fields as $key => $field) { $export->columns[] = woo_ce_get_category_field($key); } } $export->total_columns = $size = count($export->columns); $export->data_memory_start = woo_ce_current_memory_usage(); $category_args = array('orderby' => isset($export->args['category_orderby']) ? $export->args['category_orderby'] : 'ID', 'order' => isset($export->args['category_order']) ? $export->args['category_order'] : 'ASC'); if ($categories = woo_ce_get_product_categories($category_args)) { $export->total_rows = count($categories); // Generate the export headers if (in_array($export->export_format, array('csv'))) { for ($i = 0; $i < $size; $i++) { if ($i == $size - 1) { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . "\n"; } else { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . $separator; } } } if (!empty($export->fields)) { foreach ($categories as $category) { foreach ($export->fields as $key => $field) { if (isset($category->{$key})) { if (in_array($export->export_format, array('csv'))) { $output .= woo_ce_escape_csv_value($category->{$key}, $export->delimiter, $export->escape_formatting); } } if (in_array($export->export_format, array('csv'))) { $output .= $separator; } } if (in_array($export->export_format, array('csv'))) { $output = substr($output, 0, -1) . "\n"; } } } unset($categories, $category); } $export->data_memory_end = woo_ce_current_memory_usage(); break; // Tags // Tags case 'tag': $fields = woo_ce_get_tag_fields('summary'); if ($export->fields = array_intersect_assoc((array) $export->fields, $fields)) { foreach ($export->fields as $key => $field) { $export->columns[] = woo_ce_get_tag_field($key); } } $export->total_columns = $size = count($export->columns); $export->data_memory_start = woo_ce_current_memory_usage(); $tag_args = array('orderby' => isset($export->args['tag_orderby']) ? $export->args['tag_orderby'] : 'ID', 'order' => isset($export->args['tag_order']) ? $export->args['tag_order'] : 'ASC'); if ($tags = woo_ce_get_product_tags($tag_args)) { $export->total_rows = count($tags); // Generate the export headers if (in_array($export->export_format, array('csv'))) { for ($i = 0; $i < $size; $i++) { if ($i == $size - 1) { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . "\n"; } else { $output .= woo_ce_escape_csv_value($export->columns[$i], $export->delimiter, $export->escape_formatting) . $separator; } } } if (!empty($export->fields)) { foreach ($tags as $tag) { foreach ($export->fields as $key => $field) { if (isset($tag->{$key})) { if (in_array($export->export_format, array('csv'))) { $output .= woo_ce_escape_csv_value($tag->{$key}, $export->delimiter, $export->escape_formatting); } } if (in_array($export->export_format, array('csv'))) { $output .= $separator; } } if (in_array($export->export_format, array('csv'))) { $output = substr($output, 0, -1) . "\n"; } } } unset($tags, $tag); } $export->data_memory_end = woo_ce_current_memory_usage(); break; // Users // Users case 'user': $fields = woo_ce_get_user_fields('summary'); if ($export->fields = array_intersect_assoc((array) $export->fields, $fields)) { foreach ($export->fields as $key => $field) { $export->columns[] = woo_ce_get_user_field($key); } } $export->total_columns = $size = count($export->columns); $export->data_memory_start = woo_ce_current_memory_usage(); if ($users = woo_ce_get_users($export->args)) { // Generate the export headers if (in_array($export->export_format, array('csv'))) { $i = 0; foreach ($export->columns as $column) { if ($i == $size - 1) { $output .= woo_ce_escape_csv_value($column, $export->delimiter, $export->escape_formatting) . "\n"; } else { $output .= woo_ce_escape_csv_value($column, $export->delimiter, $export->escape_formatting) . $separator; } $i++; } } if (!empty($export->fields)) { foreach ($users as $user) { $user = woo_ce_get_user_data($user, $export->args); foreach ($export->fields as $key => $field) { if (isset($user->{$key})) { if (in_array($export->export_format, array('csv'))) { $output .= woo_ce_escape_csv_value($user->{$key}, $export->delimiter, $export->escape_formatting); } } if (in_array($export->export_format, array('csv'))) { $output .= $separator; } } if (in_array($export->export_format, array('csv'))) { $output = substr($output, 0, -1) . "\n"; } } } unset($users, $user); } $export->data_memory_end = woo_ce_current_memory_usage(); break; } // Remove our content filters here to play nice with other Plugins remove_filter('sanitize_key', 'woo_ce_sanitize_key'); // Remove our fatal error notice so not to conflict with the CRON or scheduled export engine remove_action('shutdown', 'woo_ce_fatal_error'); // Export completed successfully delete_transient(WOO_CE_PREFIX . '_running'); // Check that the export file is populated, export columns have been assigned and rows counted if ($output && $export->total_rows && $export->total_columns) { if (in_array($export->export_format, array('csv'))) { $output = woo_ce_file_encoding($output); if ($export->export_format == 'csv' && $export->bom && WOO_CE_DEBUG == false) { $output = "" . $output; } } if (WOO_CE_DEBUG && !$export->cron) { $response = set_transient(WOO_CE_PREFIX . '_debug_log', base64_encode($output), woo_ce_get_option('timeout', MINUTE_IN_SECONDS)); if ($response !== true) { $message = __('The export contents were too large to store in a single WordPress transient, use the Volume offset / Limit volume options to reduce the size of your export and try again.', 'woo_ce') . ' (<a href="' . $troubleshooting_url . '" target="_blank">' . __('Need help?', 'woo_ce') . '</a>)'; if (function_exists('woo_ce_admin_notice')) { woo_ce_admin_notice($message, 'error'); } else { error_log(sprintf('[store-exporter] woo_ce_export_dataset() - %s', $message)); } } } else { return $output; } } }
function woo_ce_extend_order_fields($fields = array()) { // Product Add-ons - http://www.woothemes.com/ if (class_exists('Product_Addon_Admin') || class_exists('Product_Addon_Display')) { $product_addons = woo_ce_get_product_addons(); if (!empty($product_addons)) { foreach ($product_addons as $product_addon) { if (!empty($product_addon)) { $fields[] = array('name' => sprintf('order_items_product_addon_%s', $product_addon->post_name), 'label' => sprintf(__('Order Items: %s', 'woo_ce'), ucfirst($product_addon->post_title)), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_product_addons', '%s: %s'), __('Product Add-ons', 'woo_ce'), $product_addon->form_title)); } } } unset($product_addons, $product_addon); } // WooCommerce Sequential Order Numbers - http://www.skyverge.com/blog/woocommerce-sequential-order-numbers/ // Sequential Order Numbers Pro - http://www.woothemes.com/products/sequential-order-numbers-pro/ if (class_exists('WC_Seq_Order_Number') || class_exists('WC_Seq_Order_Number_Pro')) { $fields[] = array('name' => 'order_number', 'label' => __('Order Number', 'woo_ce')); } // WooCommerce Print Invoice & Delivery Note - https://wordpress.org/plugins/woocommerce-delivery-notes/ if (class_exists('WooCommerce_Delivery_Notes')) { $fields[] = array('name' => 'invoice_number', 'label' => __('Invoice Number', 'woo_ce')); $fields[] = array('name' => 'invoice_date', 'label' => __('Invoice Date', 'woo_ce')); } // WooCommerce PDF Invoices & Packing Slips - http://www.wpovernight.com if (class_exists('WooCommerce_PDF_Invoices')) { $fields[] = array('name' => 'pdf_invoice_number', 'label' => __('PDF Invoice Number', 'woo_ce')); $fields[] = array('name' => 'pdf_invoice_date', 'label' => __('PDF Invoice Date', 'woo_ce')); } // WooCommerce Checkout Manager - http://wordpress.org/plugins/woocommerce-checkout-manager/ // WooCommerce Checkout Manager Pro - http://www.trottyzone.com/product/woocommerce-checkout-manager-pro if (function_exists('wccs_install') || function_exists('wccs_install_pro')) { $options = get_option('wccs_settings'); if (isset($options['buttons'])) { $buttons = $options['buttons']; if (!empty($buttons)) { $header = $buttons[0]['type'] == 'heading' ? $buttons[0]['label'] : false; foreach ($buttons as $button) { if ($button['type'] == 'heading') { continue; } $fields[] = array('name' => $button['label'], 'label' => !empty($header) ? sprintf(apply_filters('woo_ce_extend_order_fields_wccs', '%s: %s'), ucfirst($header), ucfirst($button['label'])) : ucfirst($button['label'])); } unset($buttons, $button, $header); } } unset($options); } // Poor Guys Swiss Knife - http://wordpress.org/plugins/woocommerce-poor-guys-swiss-knife/ if (function_exists('wcpgsk_init')) { $options = get_option('wcpgsk_settings'); $billing_fields = isset($options['woofields']['billing']) ? $options['woofields']['billing'] : array(); $shipping_fields = isset($options['woofields']['shipping']) ? $options['woofields']['shipping'] : array(); // Custom billing fields if (!empty($billing_fields)) { foreach ($billing_fields as $key => $billing_field) { $fields[] = array('name' => $key, 'label' => $options['woofields']['label_' . $key]); } unset($billing_fields, $billing_field); } // Custom shipping fields if (!empty($shipping_fields)) { foreach ($shipping_fields as $key => $shipping_field) { $fields[] = array('name' => $key, 'label' => $options['woofields']['label_' . $key]); } unset($shipping_fields, $shipping_field); } unset($options); } // Checkout Field Editor - http://woothemes.com/woocommerce/ if (function_exists('woocommerce_init_checkout_field_editor')) { $billing_fields = get_option('wc_fields_billing', array()); $shipping_fields = get_option('wc_fields_shipping', array()); $custom_fields = get_option('wc_fields_additional', array()); // Custom billing fields if (!empty($billing_fields)) { foreach ($billing_fields as $key => $billing_field) { // Only add non-default Checkout fields to export columns list if (isset($billing_field['custom']) && $billing_field['custom'] == 1) { $fields[] = array('name' => sprintf('wc_billing_%s', $key), 'label' => sprintf(__('Billing: %s', 'woo_ce'), ucfirst($billing_field['label']))); } } } unset($billing_fields, $billing_field); // Custom shipping fields if (!empty($shipping_fields)) { foreach ($shipping_fields as $key => $shipping_field) { // Only add non-default Checkout fields to export columns list if (isset($shipping_field['custom']) && $shipping_field['custom'] == 1) { $fields[] = array('name' => sprintf('wc_shipping_%s', $key), 'label' => sprintf(__('Shipping: %s', 'woo_ce'), ucfirst($shipping_field['label']))); } } } unset($shipping_fields, $shipping_field); // Custom fields if (!empty($custom_fields)) { foreach ($custom_fields as $key => $custom_field) { // Only add non-default Checkout fields to export columns list if (isset($custom_field['custom']) && $custom_field['custom'] == 1) { $fields[] = array('name' => sprintf('wc_additional_%s', $key), 'label' => sprintf(__('Additional: %s', 'woo_ce'), ucfirst($custom_field['label']))); } } } unset($custom_fields, $custom_field); } // Checkout Field Manager - http://61extensions.com if (function_exists('sod_woocommerce_checkout_manager_settings')) { $billing_fields = get_option('woocommerce_checkout_billing_fields', array()); $shipping_fields = get_option('woocommerce_checkout_shipping_fields', array()); $custom_fields = get_option('woocommerce_checkout_additional_fields', array()); // Custom billing fields if (!empty($billing_fields)) { foreach ($billing_fields as $key => $billing_field) { // Only add non-default Checkout fields to export columns list if (strtolower($billing_field['default_field']) != 'on') { $fields[] = array('name' => sprintf('sod_billing_%s', $billing_field['name']), 'label' => sprintf(__('Billing: %s', 'woo_ce'), ucfirst($billing_field['label']))); } } } unset($billing_fields, $billing_field); // Custom shipping fields if (!empty($shipping_fields)) { foreach ($shipping_fields as $key => $shipping_field) { // Only add non-default Checkout fields to export columns list if (strtolower($shipping_field['default_field']) != 'on') { $fields[] = array('name' => sprintf('sod_shipping_%s', $shipping_field['name']), 'label' => sprintf(__('Shipping: %s', 'woo_ce'), ucfirst($shipping_field['label']))); } } } unset($shipping_fields, $shipping_field); // Custom fields if (!empty($custom_fields)) { foreach ($custom_fields as $key => $custom_field) { // Only add non-default Checkout fields to export columns list if (strtolower($custom_field['default_field']) != 'on') { $fields[] = array('name' => sprintf('sod_additional_%s', $custom_field['name']), 'label' => sprintf(__('Additional: %s', 'woo_ce'), ucfirst($custom_field['label']))); } } } unset($custom_fields, $custom_field); } // WooCommerce Checkout Add-Ons - http://www.skyverge.com/product/woocommerce-checkout-add-ons/ if (function_exists('init_woocommerce_checkout_add_ons')) { $fields[] = array('name' => 'order_items_checkout_addon_id', 'label' => __('Order Items: Checkout Add-ons ID', 'woo_ce')); $fields[] = array('name' => 'order_items_checkout_addon_label', 'label' => __('Order Items: Checkout Add-ons Label', 'woo_ce')); $fields[] = array('name' => 'order_items_checkout_addon_value', 'label' => __('Order Items: Checkout Add-ons Value', 'woo_ce')); } // WooCommerce Brands Addon - http://woothemes.com/woocommerce/ // WooCommerce Brands - http://proword.net/Woocommerce_Brands/ if (class_exists('WC_Brands') || class_exists('woo_brands') || taxonomy_exists(apply_filters('woo_ce_brand_term_taxonomy', 'product_brand'))) { $fields[] = array('name' => 'order_items_brand', 'label' => __('Order Items: Brand', 'woo_ce')); } // Product Vendors - http://www.woothemes.com/products/product-vendors/ if (class_exists('WooCommerce_Product_Vendors')) { $fields[] = array('name' => 'order_items_vendor', 'label' => __('Order Items: Product Vendor', 'woo_ce')); } // Cost of Goods - http://www.skyverge.com/product/woocommerce-cost-of-goods-tracking/ if (class_exists('WC_COG')) { $fields[] = array('name' => 'cost_of_goods', 'label' => __('Order Total Cost of Goods', 'woo_ce')); $fields[] = array('name' => 'order_items_cost_of_goods', 'label' => __('Order Items: Cost of Goods', 'woo_ce')); $fields[] = array('name' => 'order_items_total_cost_of_goods', 'label' => __('Order Items: Total Cost of Goods', 'woo_ce')); } // WooCommerce MSRP Pricing - http://woothemes.com/woocommerce/ if (function_exists('woocommerce_msrp_activate')) { $fields[] = array('name' => 'order_items_msrp', 'label' => __('Order Items: MSRP', 'woo_ce')); } // Local Pickup Plus - http://www.woothemes.com/products/local-pickup-plus/ if (class_exists('WC_Local_Pickup_Plus')) { $fields[] = array('name' => 'order_items_pickup_location', 'label' => __('Order Items: Pickup Location', 'woo_ce')); } // WooCommerce Bookings - http://www.woothemes.com/products/woocommerce-bookings/ if (class_exists('WC_Bookings')) { $fields[] = array('name' => 'order_items_booking_id', 'label' => __('Order Items: Booking ID', 'woo_ce'), 'hover' => __('WooCommerce Bookings', 'woo_ce')); $fields[] = array('name' => 'order_items_booking_date', 'label' => __('Order Items: Booking Date', 'woo_ce'), 'hover' => __('WooCommerce Bookings', 'woo_ce')); $fields[] = array('name' => 'order_items_booking_start_date', 'label' => __('Order Items: Start Date', 'woo_ce'), 'hover' => __('WooCommerce Bookings', 'woo_ce')); $fields[] = array('name' => 'order_items_booking_end_date', 'label' => __('Order Items: End Date', 'woo_ce'), 'hover' => __('WooCommerce Bookings', 'woo_ce')); } // Gravity Forms - http://woothemes.com/woocommerce if (class_exists('RGForms') && class_exists('woocommerce_gravityforms')) { // Check if there are any Products linked to Gravity Forms if ($gf_fields = woo_ce_get_gravity_form_fields()) { $fields[] = array('name' => 'order_items_gf_form_id', 'label' => __('Order Items: Gravity Form ID', 'woo_ce')); $fields[] = array('name' => 'order_items_gf_form_label', 'label' => __('Order Items: Gravity Form Label', 'woo_ce')); foreach ($gf_fields as $gf_field) { $gf_field_duplicate = false; // Check if this isn't a duplicate Gravity Forms field foreach ($fields as $field) { if (isset($field['name']) && $field['name'] == sprintf('order_items_gf_%d_%s', $gf_field['formId'], $gf_field['id'])) { // Duplicate exists $gf_field_duplicate = true; break; } } // If it's not a duplicate go ahead and add it to the list if ($gf_field_duplicate !== true) { $fields[] = array('name' => sprintf('order_items_gf_%d_%s', $gf_field['formId'], $gf_field['id']), 'label' => sprintf(apply_filters('woo_ce_extend_order_fields_gf_label', __('Order Items: %s - %s', 'woo_ce')), ucwords(strtolower($gf_field['formTitle'])), ucfirst(strtolower($gf_field['label']))), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_gf_hover', '%s: %s (ID: %d)'), __('Gravity Forms', 'woo_ce'), ucwords(strtolower($gf_field['formTitle'])), $gf_field['formId'])); } } unset($gf_fields, $gf_field); } } // WooCommerce Currency Switcher - http://dev.pathtoenlightenment.net/shop if (class_exists('WC_Aelia_CurrencySwitcher')) { $fields[] = array('name' => 'order_currency', 'label' => __('Order Currency', 'woo_ce')); } // WooCommerce TM Extra Product Options - http://codecanyon.net/item/woocommerce-extra-product-options/7908619 if (class_exists('TM_Extra_Product_Options')) { if ($tm_fields = woo_ce_get_extra_product_option_fields()) { foreach ($tm_fields as $tm_field) { $fields[] = array('name' => sprintf('order_items_tm_%s', sanitize_key($tm_field['name'])), 'label' => sprintf(__('Order Items: %s', 'woo_ce'), $tm_field['name'])); } unset($tm_fields, $tm_field); } } // WooCommerce Ship to Multiple Addresses - http://woothemes.com/woocommerce if (class_exists('WC_Ship_Multiple')) { $fields[] = array('name' => 'wcms_number_packages', 'label' => __('Number of Packages', 'woo_ce'), 'hover' => __('Ship to Multiple Addresses', 'woo_ce')); } // Attributes if ($attributes = woo_ce_get_product_attributes()) { foreach ($attributes as $attribute) { $attribute->attribute_label = trim($attribute->attribute_label); if (empty($attribute->attribute_label)) { $attribute->attribute_label = $attribute->attribute_name; } $fields[] = array('name' => sprintf('order_items_attribute_%s', $attribute->attribute_name), 'label' => sprintf(__('Order Items: %s', 'woo_ce'), ucwords($attribute->attribute_label)), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_attribute', '%s: %s (#%d)'), __('Attribute', 'woo_ce'), $attribute->attribute_name, $attribute->attribute_id)); } unset($attributes, $attribute); } // Custom Order fields $custom_orders = woo_ce_get_option('custom_orders', ''); if (!empty($custom_orders)) { foreach ($custom_orders as $custom_order) { if (!empty($custom_order)) { $fields[] = array('name' => $custom_order, 'label' => woo_ce_clean_export_label($custom_order), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_custom_order_hover', '%s: %s'), __('Custom Order', 'woo_ce'), $custom_order)); } } unset($custom_orders, $custom_order); } // Custom Order Items fields $custom_order_items = woo_ce_get_option('custom_order_items', ''); if (!empty($custom_order_items)) { foreach ($custom_order_items as $custom_order_item) { if (!empty($custom_order_item)) { $fields[] = array('name' => sprintf('order_items_%s', $custom_order_item), 'label' => sprintf(__('Order Items: %s', 'woo_ce'), woo_ce_clean_export_label($custom_order_item)), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_custom_order_item_hover', '%s: %s'), __('Custom Order Item', 'woo_ce'), $custom_order_item)); } } } // Custom Product fields $custom_product_fields = woo_ce_get_option('custom_products', ''); if (!empty($custom_product_fields)) { foreach ($custom_product_fields as $custom_product_field) { if (!empty($custom_product_field)) { $fields[] = array('name' => sprintf('order_items_%s', $custom_product_field), 'label' => sprintf(__('Order Items: %s', 'woo_ce'), woo_ce_clean_export_label($custom_product_field)), 'hover' => sprintf(apply_filters('woo_ce_extend_order_fields_custom_product_hover', '%s: %s'), __('Custom Product', 'woo_ce'), $custom_product_field)); } } } return $fields; }
function woo_ce_init() { // Check that Store Exporter Deluxe is installed and activated or jump out if( !function_exists( 'woo_ce_get_option' ) ) return; // Check if scheduled exports is enabled if( woo_ce_get_option( 'enable_auto', 0 ) == 1 ) { // Add custom schedule for automated exports add_filter( 'cron_schedules', 'woo_ce_cron_schedules' ); woo_ce_cron_activation(); } // Check if trigger export on New Order is enabled if( woo_ce_get_option( 'enable_trigger_new_order', 0 ) == 1 ) { // There are other WordPress Actions (woocommerce_new_order, woocommerce_api_create_order) we can hook into but woocommerce_checkout_update_order_meta is the only one where we can access the Order Items add_action( 'woocommerce_checkout_update_order_meta', 'woo_ce_trigger_new_order_export', 10, 1 ); } // Once every x minutes WP-CRON will run the automated export add_action( 'woo_ce_auto_export_schedule', 'woo_ce_auto_export' ); }
function woo_ce_tab_template($tab = '') { if (!$tab) { $tab = 'overview'; } // Store Exporter Deluxe $woo_cd_url = 'http://www.visser.com.au/woocommerce/plugins/exporter-deluxe/'; $woo_cd_link = sprintf('<a href="%s" target="_blank">' . __('Store Exporter Deluxe', 'woo_ce') . '</a>', $woo_cd_url); $troubleshooting_url = 'http://www.visser.com.au/documentation/store-exporter-deluxe/'; switch ($tab) { case 'overview': $skip_overview = woo_ce_get_option('skip_overview', false); break; case 'export': $export_type = sanitize_text_field(isset($_POST['dataset']) ? $_POST['dataset'] : woo_ce_get_option('last_export', 'product')); $types = array_keys(woo_ce_return_export_types()); // Check if the default export type exists if (!in_array($export_type, $types)) { $export_type = 'product'; } $products = woo_ce_return_count('product'); $categories = woo_ce_return_count('category'); $tags = woo_ce_return_count('tag'); $brands = '999'; $orders = '999'; $customers = '999'; $users = woo_ce_return_count('user'); $coupons = '999'; $attributes = '999'; $subscriptions = '999'; $product_vendors = '999'; $commissions = '999'; $shipping_classes = '999'; add_action('woo_ce_export_options', 'woo_ce_export_options_export_format'); if ($product_fields = woo_ce_get_product_fields()) { foreach ($product_fields as $key => $product_field) { $product_fields[$key]['disabled'] = isset($product_field['disabled']) ? $product_field['disabled'] : 0; } add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_category'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_tag'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_brand'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_vendor'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_status'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_product_type'); add_action('woo_ce_export_product_options_before_table', 'woo_ce_products_filter_by_stock_status'); add_action('woo_ce_export_product_options_after_table', 'woo_ce_product_sorting'); add_action('woo_ce_export_options', 'woo_ce_products_upsells_formatting'); add_action('woo_ce_export_options', 'woo_ce_products_crosssells_formatting'); add_action('woo_ce_export_options', 'woo_ce_export_options_gallery_format'); add_action('woo_ce_export_after_form', 'woo_ce_products_custom_fields'); } if ($category_fields = woo_ce_get_category_fields()) { foreach ($category_fields as $key => $category_field) { $category_fields[$key]['disabled'] = isset($category_field['disabled']) ? $category_field['disabled'] : 0; } add_action('woo_ce_export_category_options_after_table', 'woo_ce_category_sorting'); } if ($tag_fields = woo_ce_get_tag_fields()) { foreach ($tag_fields as $key => $tag_field) { $tag_fields[$key]['disabled'] = isset($tag_field['disabled']) ? $tag_field['disabled'] : 0; } add_action('woo_ce_export_tag_options_after_table', 'woo_ce_tag_sorting'); } if ($brand_fields = woo_ce_get_brand_fields()) { foreach ($brand_fields as $key => $brand_field) { $brand_fields[$key]['disabled'] = isset($brand_field['disabled']) ? $brand_field['disabled'] : 0; } add_action('woo_ce_export_brand_options_before_table', 'woo_ce_brand_sorting'); } if ($order_fields = woo_ce_get_order_fields()) { 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_before_table', 'woo_ce_orders_filter_by_billing_country'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_shipping_country'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_user_role'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_coupon'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_product'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_product_category'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_product_tag'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_product_brand'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_order_id'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_payment_gateway'); add_action('woo_ce_export_order_options_before_table', 'woo_ce_orders_filter_by_shipping_method'); add_action('woo_ce_export_order_options_after_table', 'woo_ce_order_sorting'); add_action('woo_ce_export_options', 'woo_ce_orders_items_formatting'); add_action('woo_ce_export_options', 'woo_ce_orders_max_order_items'); add_action('woo_ce_export_options', 'woo_ce_orders_items_types'); add_action('woo_ce_export_after_form', 'woo_ce_orders_custom_fields'); } if ($customer_fields = woo_ce_get_customer_fields()) { add_action('woo_ce_export_customer_options_before_table', 'woo_ce_customers_filter_by_status'); add_action('woo_ce_export_customer_options_before_table', 'woo_ce_customers_filter_by_user_role'); add_action('woo_ce_export_after_form', 'woo_ce_customers_custom_fields'); } if ($user_fields = woo_ce_get_user_fields()) { foreach ($user_fields as $key => $user_field) { $user_fields[$key]['disabled'] = isset($user_field['disabled']) ? $user_field['disabled'] : 0; } add_action('woo_ce_export_user_options_after_table', 'woo_ce_user_sorting'); add_action('woo_ce_export_after_form', 'woo_ce_users_custom_fields'); } if ($coupon_fields = woo_ce_get_coupon_fields()) { add_action('woo_ce_export_coupon_options_before_table', 'woo_ce_coupon_sorting'); } if ($subscription_fields = woo_ce_get_subscription_fields()) { add_action('woo_ce_export_subscription_options_before_table', 'woo_ce_subscriptions_filter_by_subscription_status'); add_action('woo_ce_export_subscription_options_before_table', 'woo_ce_subscriptions_filter_by_subscription_product'); } $product_vendor_fields = woo_ce_get_product_vendor_fields(); if ($commission_fields = woo_ce_get_commission_fields()) { add_action('woo_ce_export_commission_options_before_table', 'woo_ce_commissions_filter_by_date'); add_action('woo_ce_export_commission_options_before_table', 'woo_ce_commissions_filter_by_product_vendor'); add_action('woo_ce_export_commission_options_before_table', 'woo_ce_commissions_filter_by_commission_status'); add_action('woo_ce_export_commission_options_before_table', 'woo_ce_commission_sorting'); } if ($shipping_class_fields = woo_ce_get_shipping_class_fields()) { add_action('woo_ce_export_shipping_class_options_after_table', 'woo_ce_shipping_class_sorting'); } $attribute_fields = false; // Export modules $modules = woo_ce_modules_list(); // Export options $limit_volume = woo_ce_get_option('limit_volume'); $offset = woo_ce_get_option('offset'); break; case 'fields': $export_type = isset($_GET['type']) ? sanitize_text_field($_GET['type']) : ''; $types = array_keys(woo_ce_return_export_types()); $fields = array(); if (in_array($export_type, $types)) { if (has_filter('woo_ce_' . $export_type . '_fields', 'woo_ce_override_' . $export_type . '_field_labels')) { remove_filter('woo_ce_' . $export_type . '_fields', 'woo_ce_override_' . $export_type . '_field_labels', 11); } if (function_exists(sprintf('woo_ce_get_%s_fields', $export_type))) { $fields = call_user_func('woo_ce_get_' . $export_type . '_fields'); } $labels = woo_ce_get_option($export_type . '_labels', array()); } break; case 'archive': if (isset($_GET['deleted'])) { $message = __('Archived export has been deleted.', 'woo_ce'); woo_ce_admin_notice($message); } if ($files = woo_ce_get_archive_files()) { foreach ($files as $key => $file) { $files[$key] = woo_ce_get_archive_file($file); } } break; case 'settings': $export_filename = woo_ce_get_option('export_filename', ''); // Default export filename if (empty($export_filename)) { $export_filename = 'woo-export_%dataset%-%date%.csv'; } $delete_file = woo_ce_get_option('delete_file', 0); $timeout = woo_ce_get_option('timeout', 0); $encoding = woo_ce_get_option('encoding', 'UTF-8'); $bom = woo_ce_get_option('bom', 1); $delimiter = woo_ce_get_option('delimiter', ','); $category_separator = woo_ce_get_option('category_separator', '|'); $escape_formatting = woo_ce_get_option('escape_formatting', 'all'); $date_format = woo_ce_get_option('date_format', 'd/m/Y'); if ($date_format == 1 || $date_format == '') { $date_format = 'd/m/Y'; } $file_encodings = function_exists('mb_list_encodings') ? mb_list_encodings() : false; add_action('woo_ce_export_settings_top', 'woo_ce_export_settings_quicklinks'); add_action('woo_ce_export_settings_after', 'woo_ce_export_settings_csv'); add_action('woo_ce_export_settings_after', 'woo_ce_export_settings_cron'); break; case 'tools': // Product Importer Deluxe $woo_pd_url = 'http://www.visser.com.au/woocommerce/plugins/product-importer-deluxe/'; $woo_pd_target = ' target="_blank"'; if (function_exists('woo_pd_init')) { $woo_pd_url = add_query_arg(array('page' => 'woo_pd', 'tab' => null)); $woo_pd_target = false; } // Store Toolkit $woo_st_url = 'http://www.visser.com.au/woocommerce/plugins/store-toolkit/'; $woo_st_target = ' target="_blank"'; if (function_exists('woo_st_admin_init')) { $woo_st_url = add_query_arg(array('page' => 'woo_st', 'tab' => null)); $woo_st_target = false; } break; } if ($tab) { if (file_exists(WOO_CE_PATH . 'templates/admin/tabs-' . $tab . '.php')) { include_once WOO_CE_PATH . 'templates/admin/tabs-' . $tab . '.php'; } else { $message = sprintf(__('We couldn\'t load the export template file <code>%s</code> within <code>%s</code>, this file should be present.', 'woo_ce'), 'tabs-' . $tab . '.php', WOO_CE_PATH . 'templates/admin/...'); woo_ce_admin_notice_html($message, 'error'); ob_start(); ?> <p><?php _e('You can see this error for one of a few common reasons', 'woo_ce'); ?> :</p> <ul class="ul-disc"> <li><?php _e('WordPress was unable to create this file when the Plugin was installed or updated', 'woo_ce'); ?> </li> <li><?php _e('The Plugin files have been recently changed and there has been a file conflict', 'woo_ce'); ?> </li> <li><?php _e('The Plugin file has been locked and cannot be opened by WordPress', 'woo_ce'); ?> </li> </ul> <p><?php _e('Jump onto our website and download a fresh copy of this Plugin as it might be enough to fix this issue. If this persists get in touch with us.', 'woo_ce'); ?> </p> <?php ob_end_flush(); } } }
function woo_ce_manage_form() { $tab = isset($_GET['tab']) ? sanitize_text_field($_GET['tab']) : false; // If Skip Overview is set then jump to Export screen if ($tab == false && woo_ce_get_option('skip_overview', false)) { $tab = 'export'; } woo_ce_fail_notices(); include_once WOO_CE_PATH . 'templates/admin/tabs.php'; }
function woo_ce_subscription_extend( $subscription ) { // WooCommerce User Profile fields if( class_exists( 'WC_Admin_Profile' ) ) { $admin_profile = new WC_Admin_Profile(); if( $show_fields = $admin_profile->get_customer_meta_fields() ) { foreach( $show_fields as $fieldset ) { foreach( $fieldset['fields'] as $key => $field ) $subscription->{$key} = esc_attr( get_user_meta( $subscription->user_id, $key, true ) ); } } unset( $show_fields, $fieldset, $field ); } // Custom Order fields $custom_orders = woo_ce_get_option( 'custom_orders', '' ); if( !empty( $custom_orders ) ) { foreach( $custom_orders as $custom_order ) { if( !empty( $custom_order ) && !isset( $subscription->{$custom_order} ) ) $subscription->{$custom_order} = esc_attr( get_post_meta( $subscription->order_id, $custom_order, true ) ); } } // Custom User fields $custom_users = woo_ce_get_option( 'custom_users', '' ); if( !empty( $custom_users ) ) { foreach( $custom_users as $custom_user ) { if( !empty( $custom_user ) && !isset( $subscription->{$custom_user} ) ) { $subscription->{$custom_user} = woo_ce_format_custom_meta( get_user_meta( $subscription->user_id, $custom_user, true ) ); } } } unset( $custom_users, $custom_user ); return $subscription; }
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_recent_scheduled_export_widget() { $recent_exports = woo_ce_get_option( 'recent_scheduled_exports', array() ); if( empty( $recent_exports ) ) $recent_exports = array(); $size = count( $recent_exports ); $recent_exports = array_reverse( $recent_exports ); // Get widget options if( !$widget_options = get_option( 'woo_ce_recent_scheduled_export_widget_options', array() ) ) { $widget_options = array( 'number' => 5 ); } // Check if we need to limit the number of recent exports if( $size > $widget_options['number'] ) { $i = $size; // Loop through the recent exports till we get it down to our limit for( $i; $i >= $widget_options['number']; $i-- ) { unset( $recent_exports[$i] ); } // Save the changes so we don't have to do this next screen refresh woo_ce_update_option( 'recent_scheduled_exports', $recent_exports ); } if( file_exists( WOO_CD_PATH . 'templates/admin/dashboard_widget-recent_scheduled_export.php' ) ) { include_once( WOO_CD_PATH . 'templates/admin/dashboard_widget-recent_scheduled_export.php' ); } else { $message = sprintf( __( 'We couldn\'t load the widget template file <code>%s</code> within <code>%s</code>, this file should be present.', 'woo_ce' ), 'dashboard_widget-recent_scheduled_export.php', WOO_CD_PATH . 'templates/admin/...' ); ob_start(); ?> <p><strong><?php echo $message; ?></strong></p> <p><?php _e( 'You can see this error for one of a few common reasons', 'woo_ce' ); ?>:</p> <ul class="ul-disc"> <li><?php _e( 'WordPress was unable to create this file when the Plugin was installed or updated', 'woo_ce' ); ?></li> <li><?php _e( 'The Plugin files have been recently changed and there has been a file conflict', 'woo_ce' ); ?></li> <li><?php _e( 'The Plugin file has been locked and cannot be opened by WordPress', 'woo_ce' ); ?></li> </ul> <p><?php _e( 'Jump onto our website and download a fresh copy of this Plugin as it might be enough to fix this issue. If this persists get in touch with us.', 'woo_ce' ); ?></p> <?php ob_end_flush(); } }
function woo_ce_format_date($date = '') { $output = ''; if ($date) { $output = mysql2date(woo_ce_get_option('date_format', 'd/m/Y'), $date); } return $output; }
function woo_ce_override_shipping_class_field_labels( $fields = array() ) { $labels = woo_ce_get_option( 'shipping_class_labels', array() ); if( !empty( $labels ) ) { foreach( $fields as $key => $field ) { if( isset( $labels[$field['name']] ) ) $fields[$key]['label'] = $labels[$field['name']]; } } return $fields; }
function woo_ce_get_line_ending() { $output = "\n"; $line_ending_formatting = woo_ce_get_option( 'line_ending_formatting', 'windows' ); if( $line_ending_formatting == false || $line_ending_formatting == '' ) { error_log( '[store-exporter-deluxe] Line ending formatting export option was corrupted, defaulted to windows' ); $line_ending_formatting = 'windows'; woo_ce_update_option( 'line_ending_formatting', 'windows' ); } switch( $line_ending_formatting ) { case 'windows': $output = "\n"; break; case 'mac': $output = "\r"; break; case 'unix': $output = "\n"; break; } return $output; }
function woo_ce_get_customer_fields($format = 'full') { $fields = array(); $fields[] = array('name' => 'user_id', 'label' => __('User ID', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'user_name', 'label' => __('Username', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'user_role', 'label' => __('User Role', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_full_name', 'label' => __('Billing: Full Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_first_name', 'label' => __('Billing: First Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_last_name', 'label' => __('Billing: Last Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_company', 'label' => __('Billing: Company', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_address', 'label' => __('Billing: Street Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_city', 'label' => __('Billing: City', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_postcode', 'label' => __('Billing: ZIP Code', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_state', 'label' => __('Billing: State (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_state_full', 'label' => __('Billing: State', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_country', 'label' => __('Billing: Country', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_phone', 'label' => __('Billing: Phone Number', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'billing_email', 'label' => __('Billing: E-mail Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_full_name', 'label' => __('Shipping: Full Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_first_name', 'label' => __('Shipping: First Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_last_name', 'label' => __('Shipping: Last Name', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_company', 'label' => __('Shipping: Company', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_address', 'label' => __('Shipping: Street Address', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_city', 'label' => __('Shipping: City', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_postcode', 'label' => __('Shipping: ZIP Code', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_state', 'label' => __('Shipping: State (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_state_full', 'label' => __('Shipping: State', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_country', 'label' => __('Shipping: Country (prefix)', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'shipping_country_full', 'label' => __('Shipping: Country', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'total_spent', 'label' => __('Total Spent', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'completed_orders', 'label' => __('Completed Orders', 'woo_ce'), 'default' => 1); $fields[] = array('name' => 'total_orders', 'label' => __('Total Orders', 'woo_ce'), 'default' => 1); /* $fields[] = array( 'name' => '', 'label' => __( '', 'woo_ce' ), 'default' => 1 ); */ // Allow Plugin/Theme authors to add support for additional Customer columns $fields = apply_filters('woo_ce_customer_fields', $fields); if ($remember = woo_ce_get_option('customers_fields')) { $remember = maybe_unserialize($remember); $size = count($fields); for ($i = 0; $i < $size; $i++) { if (!array_key_exists($fields[$i]['name'], $remember)) { $fields[$i]['default'] = 0; } } } switch ($format) { case 'summary': $output = array(); $size = count($fields); for ($i = 0; $i < $size; $i++) { $output[$fields[$i]['name']] = 'on'; } return $output; break; case 'full': default: return $fields; break; } }