/**
* Get the add to cart URL for a product
*
* @param array $atts
* @return string
*/
public static function product_add_to_cart_url($atts)
{
global $wpdb;
if (empty($atts)) {
return '';
}
if (isset($atts['id'])) {
$product_data = get_post($atts['id']);
} elseif (isset($atts['sku'])) {
$product_id = wc_get_product_id_by_sku($atts['sku']);
$product_data = get_post($product_id);
} else {
return '';
}
if ('product' !== $product_data->post_type) {
return '';
}
$_product = wc_get_product($product_data);
return esc_url($_product->add_to_cart_url());
}
/**
* Create or update a line item
*
* @since 2.2
* @param \WC_Order $order
* @param array $item line item data
* @param string $action 'create' to add line item or 'update' to update it
* @throws WC_API_Exception invalid data, server error
*/
protected function set_line_item($order, $item, $action)
{
$creating = 'create' === $action;
// product is always required
if (!isset($item['product_id']) && !isset($item['sku'])) {
throw new WC_API_Exception('woocommerce_api_invalid_product_id', __('Product ID or SKU is required', 'woocommerce'), 400);
}
// when updating, ensure product ID provided matches
if ('update' === $action) {
$item_product_id = wc_get_order_item_meta($item['id'], '_product_id');
$item_variation_id = wc_get_order_item_meta($item['id'], '_variation_id');
if ($item['product_id'] != $item_product_id && $item['product_id'] != $item_variation_id) {
throw new WC_API_Exception('woocommerce_api_invalid_product_id', __('Product ID provided does not match this line item', 'woocommerce'), 400);
}
}
if (isset($item['product_id'])) {
$product_id = $item['product_id'];
} elseif (isset($item['sku'])) {
$product_id = wc_get_product_id_by_sku($item['sku']);
}
// variations must each have a key & value
$variation_id = 0;
if (isset($item['variations']) && is_array($item['variations'])) {
foreach ($item['variations'] as $key => $value) {
if (!$key || !$value) {
throw new WC_API_Exception('woocommerce_api_invalid_product_variation', __('The product variation is invalid', 'woocommerce'), 400);
}
}
$variation_id = $this->get_variation_id(wc_get_product($product_id), $item['variations']);
}
$product = wc_get_product($variation_id ? $variation_id : $product_id);
// must be a valid WC_Product
if (!is_object($product)) {
throw new WC_API_Exception('woocommerce_api_invalid_product', __('Product is invalid', 'woocommerce'), 400);
}
// quantity must be positive float
if (isset($item['quantity']) && floatval($item['quantity']) <= 0) {
throw new WC_API_Exception('woocommerce_api_invalid_product_quantity', __('Product quantity must be a positive float', 'woocommerce'), 400);
}
// quantity is required when creating
if ($creating && !isset($item['quantity'])) {
throw new WC_API_Exception('woocommerce_api_invalid_product_quantity', __('Product quantity is required', 'woocommerce'), 400);
}
if ($creating) {
$item = new WC_Order_Item_Product();
} else {
$item = new WC_Order_Item_Product($item['id']);
}
$item->set_product($product);
$item->set_order_id($order->id);
if (isset($item['quantity'])) {
$item->set_quantity($item['quantity']);
}
if (isset($item['total'])) {
$item->set_total(floatval($item['total']));
}
if (isset($item['total_tax'])) {
$item->set_total_tax(floatval($item['total_tax']));
}
if (isset($item['subtotal'])) {
$item->set_subtotal(floatval($item['subtotal']));
}
if (isset($item['subtotal_tax'])) {
$item->set_subtotal_tax(floatval($item['subtotal_tax']));
}
if ($variation_id) {
$item->set_variation_id($variation_id);
$item->set_variation($item['variations']);
}
$item_id = $item->save();
if (!$item_id) {
throw new WC_API_Exception('woocommerce_cannot_create_line_item', __('Cannot create line item, try again', 'woocommerce'), 500);
}
}
/**
* Get the add to cart URL for a product.
*
* @param array $atts
* @return string
*/
public static function product_add_to_cart_url($atts)
{
global $wpdb;
if (empty($atts)) {
return '';
}
if (isset($atts['id'])) {
$product_data = get_post($atts['id']);
} elseif (isset($atts['sku'])) {
$product_id = wc_get_product_id_by_sku($atts['sku']);
$product_data = get_post($product_id);
} else {
return '';
}
$product = is_object($product_data) && in_array($product_data->post_type, array('product', 'product_variation')) ? wc_setup_product_data($product_data) : false;
if (!$product) {
return '';
}
$_product = wc_get_product($product_data);
return esc_url($_product->add_to_cart_url());
}
/**
* Gets the product ID from the SKU or posted ID.
* @param array $posted Request data
* @return int
*/
protected function get_product_id($posted)
{
if (!empty($posted['sku'])) {
$product_id = (int) wc_get_product_id_by_sku($posted['sku']);
} elseif (!empty($posted['product_id']) && empty($posted['variation_id'])) {
$product_id = (int) $posted['product_id'];
} elseif (!empty($posted['variation_id'])) {
$product_id = (int) $posted['variation_id'];
} else {
throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or SKU is required.', 'woocommerce'), 400);
}
return $product_id;
}
function wc_autoship_import_muenster_file()
{
set_time_limit(300);
header('Content-Type: application/json');
// Check if file is valid
if (empty($_FILES['uploadedFiles']['error']) || $_FILES['uploadedFiles']['error'][0] !== UPLOAD_ERR_OK) {
echo json_encode(array('error' => 'Upload error code: ' . $_FILES['uploadedFiles']['error'][0]));
die;
}
// Open file
$file = fopen($_FILES['uploadedFiles']['tmp_name'][0], 'r');
if (!$file) {
echo json_encode(array('error' => 'Could not open file'));
die;
}
// Read column headers
$column_headers = fgetcsv($file);
if (empty($column_headers)) {
echo json_encode(array('error' => 'Invalid file format'));
die;
}
$columns = array();
foreach ($column_headers as $index => $name) {
$columns[$name] = $index;
}
$column_names = array('Customer Email', 'Next Shipping Date', 'Shipping Method', 'Frequency', 'Quantity', 'Product SKU');
foreach ($column_names as $name) {
if (!isset($columns[$name])) {
echo json_encode(array('error' => 'Missing column: ' . $name));
die;
}
}
// Include dependencies
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-customer.php';
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule.php';
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule-item.php';
// Process file
$result = array();
while ($row = fgetcsv($file)) {
// Get email
$email = $row[$columns['Customer Email']];
if (empty($email)) {
// Email is empty, skip this record
continue;
}
$result_item = array('data' => array_combine($column_headers, $row));
// Find existing user
$user_id = 0;
$user = get_user_by('email', $email);
if (!$user) {
$result_item['error'] = "User not found for email {$email}";
$result[] = $result_item;
continue;
} else {
$user_id = $user->ID;
}
$result_item['data']['user_id'] = $user_id;
if (empty($user_id) || is_object($user_id)) {
$result_item['error'] = 'Invalid user_id';
$result[] = $result_item;
continue;
}
// Create autoship customer
$customer = new WC_Autoship_Customer($user_id);
$customer->set('shipping_method', $row[$columns['Shipping Method']]);
if (false === $customer->save()) {
// Error creating autoship customer
$result_item['error'] = 'Error creating autoship customer';
$result[] = $result_item;
continue;
}
// Create autoship schedule item
$product_id = wc_get_product_id_by_sku($row[$columns['Product SKU']]);
if (empty($product_id)) {
// Product does not exist
$result_item['error'] = 'Product SKU not found';
$result[] = $result_item;
continue;
}
$result_item['data']['product_id'] = $product_id;
$product = wc_get_product($product_id);
$item = new WC_Autoship_Schedule_Item();
if ($product->is_type('simple')) {
$item->set('product_id', $product_id);
} elseif ($product->is_type('variation')) {
$item->set('variation_id', $product_id);
$item->set('product_id', $product->get_parent());
}
$item->set('qty', $row[$columns['Quantity']]);
// Create autoship schedule
$frequency_desc = $row[$columns['Frequency']];
$frequency_matches = null;
if (!preg_match('/(\\d+) Month/', $frequency_desc, $frequency_matches)) {
// Error saving autoship schedule
$result_item['error'] = "Invalid Frequency: {$frequency_desc}";
$result[] = $result_item;
continue;
}
$frequency = 30 * (int) $frequency_matches[1];
$schedule = WC_Autoship_Schedule::get_schedule($user_id, $frequency);
$schedule->set_autoship_status(WC_Autoship::STATUS_PAUSED);
$schedule->set_next_order_date(date('Y-m-d', strtotime($row[$columns['Next Shipping Date']])));
$schedule->add_item($item);
if (false === $schedule->save()) {
// Error saving autoship schedule
$result_item['error'] = 'Error saving autoship schedule';
$result[] = $result_item;
continue;
}
$result[] = $result_item;
}
fclose($file);
echo json_encode($result);
die;
}
function wc_autoship_import_paymentxp_file()
{
set_time_limit(300);
header('Content-Type: application/json');
// Check if file is valid
if (empty($_FILES['uploadedFiles']['error']) || $_FILES['uploadedFiles']['error'][0] !== UPLOAD_ERR_OK) {
echo json_encode(array('error' => 'Upload error code: ' . $_FILES['uploadedFiles']['error'][0]));
die;
}
// Open file
$file = fopen($_FILES['uploadedFiles']['tmp_name'][0], 'r');
if (!$file) {
echo json_encode(array('error' => 'Could not open file'));
die;
}
// Read column headers
$column_headers = fgetcsv($file);
if (empty($column_headers)) {
echo json_encode(array('error' => 'Invalid file format'));
die;
}
$columns = array();
foreach ($column_headers as $index => $name) {
$columns[$name] = $index;
}
$column_names = array('email', 'autoship frequency', 'next order date', 'product sku', 'item quantity', 'username', 'password', 'pxp_customer_id', 'pmt_desc', 'display_name', 'user_nicename', 'first_name', 'last_name', 'phone', 'billing_phone', 'billing_address', 'billing_address_1', 'billing_address_2', 'billing_city', 'billing_state', 'billing_zip', 'billing_postcode', 'billing_country', 'billing_last_name', 'billing_first_name', 'shipping_address_1', 'shipping_address_2', 'shipping_city', 'shipping_state', 'shipping_postcode', 'shipping_country', 'shipping_last_name', 'shipping_first_name', 'shipping_method', 'role', 'affwp_lc_email', 'affwp_lc_affiliate_id');
$usermeta_column_names = array('phone', 'billing_phone', 'billing_address', 'billing_address_1', 'billing_address_2', 'billing_city', 'billing_state', 'billing_zip', 'billing_postcode', 'billing_country', 'billing_last_name', 'billing_first_name', 'shipping_address_1', 'shipping_address_2', 'shipping_city', 'shipping_state', 'shipping_postcode', 'shipping_country', 'shipping_last_name', 'shipping_first_name', 'affwp_lc_email', 'affwp_lc_affiliate_id');
foreach ($column_names as $name) {
if (!isset($columns[$name])) {
echo json_encode(array('error' => 'Missing column: ' . $name));
die;
}
}
// Include dependencies
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-customer.php';
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule.php';
require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule-item.php';
// Process file
$result = array();
while ($row = fgetcsv($file)) {
// Get email
$email = $row[$columns['email']];
if (empty($email)) {
// Email is empty, skip this record
continue;
}
$result_item = array('data' => array_combine($column_headers, $row));
// Find existing user
$user_id = 0;
$user = get_user_by('email', $email);
if (!$user) {
// Create new user
$user_id = @wp_create_user($row[$columns['username']], $row[$columns['password']], $email);
if (!$user_id) {
$result_item['error'] = 'Error creating user';
$result[] = $result_item;
continue;
}
@wp_update_user(array('ID' => $user_id, 'user_nicename' => $row[$columns['user_nicename']], 'display_name' => $row[$columns['display_name']], 'first_name' => $row[$columns['first_name']], 'last_name' => $row[$columns['last_name']], 'role' => $row[$columns['role']]));
// Add user meta
foreach ($usermeta_column_names as $name) {
add_user_meta($user_id, $name, $row[$columns[$name]], true);
}
} else {
$user_id = $user->ID;
}
$result_item['data']['user_id'] = $user_id;
if (empty($user_id) || is_object($user_id)) {
$result_item['error'] = 'Invalid user_id';
$result[] = $result_item;
continue;
}
// Create autoship customer
$customer = new WC_Autoship_Customer($user_id);
$customer->store_payment_method('wc_autoship_paymentxp', $row[$columns['pxp_customer_id']], array('CustomerID' => $row[$columns['pxp_customer_id']], 'CardNumber' => $row[$columns['pmt_desc']]));
$customer->set('shipping_method', $row[$columns['shipping_method']]);
if (false === $customer->save()) {
// Error creating autoship customer
$result_item['error'] = 'Error creating autoship customer';
$result[] = $result_item;
continue;
}
// Create autoship schedule item
$product_id = wc_get_product_id_by_sku($row[$columns['product sku']]);
if (empty($product_id)) {
// Product does not exist
$result_item['error'] = 'Product SKU not found';
$result[] = $result_item;
continue;
}
$result_item['data']['product_id'] = $product_id;
$product = wc_get_product($product_id);
$item = new WC_Autoship_Schedule_Item();
if ($product->is_type('simple')) {
$item->set('product_id', $product_id);
} elseif ($product->is_type('variation')) {
$item->set('variation_id', $product_id);
$item->set('product_id', $product->get_parent());
}
$item->set('qty', $row[$columns['item quantity']]);
// Create autoship schedule
$schedule = WC_Autoship_Schedule::get_schedule($user_id, $row[$columns['autoship frequency']]);
$schedule->set_autoship_status(WC_Autoship::STATUS_ACTIVE);
$schedule->set_next_order_date(date('Y-m-d', strtotime($row[$columns['next order date']])));
$schedule->add_item($item);
if (false === $schedule->save()) {
// Error saving autoship schedule
$result_item['error'] = 'Error saving autoship schedule';
$result[] = $result_item;
continue;
}
$result[] = $result_item;
}
fclose($file);
echo json_encode($result);
die;
}
/**
* Get product by SKU
*
* @since 2.3.0
* @param int $sku the product SKU
* @param string $fields
* @return array
*/
public function get_product_by_sku($sku, $fields = null)
{
try {
$id = wc_get_product_id_by_sku($sku);
if (empty($id)) {
throw new WC_API_Exception('woocommerce_api_invalid_product_sku', __('Invalid product SKU', 'woocommerce'), 404);
}
return $this->get_product($id, $fields);
} catch (WC_API_Exception $e) {
return new WP_Error($e->getErrorCode(), $e->getMessage(), array('status' => $e->getCode()));
}
}
public function sync()
{
global $wp;
global $wpdb;
set_time_limit(0);
@ini_set('display_errors', '1');
@ini_set('zlib.output_compression', 'Off');
@ini_set('output_buffering', 'Off');
@ini_set('output_handler', '');
while (ob_get_level() > 1) {
@ob_end_clean();
}
if (ob_get_level() > 0) {
@ob_clean();
}
if (!in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) {
$this->sendHttpHeaders('500 Config Error', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'failed', 'message' => 'WooCommerce Deactivated'));
exit;
}
$type = $wp->query_vars['codisto-sync-route'];
if (strtolower($_SERVER['REQUEST_METHOD']) == 'get') {
if ($type == 'test' || $type == 'sync' && preg_match('/\\/sync\\/testHash\\?/', $_SERVER['REQUEST_URI'])) {
if (!$this->check_hash()) {
exit;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
} else {
if ($type === 'settings') {
if (!$this->check_hash()) {
exit;
}
$logo_url = get_header_image();
if (function_exists('site_logo')) {
$logo = site_logo()->logo;
$logo_id = get_theme_mod('custom_logo');
$logo_id = $logo_id ? $logo_id : $logo['id'];
if ($logo_id) {
$logo_url = wp_get_attachment_image_src($logo_id, 'full');
$logo_url = $logo_url[0];
}
}
$currency = get_option('woocommerce_currency');
$dimension_unit = get_option('woocommerce_dimension_unit');
$weight_unit = get_option('woocommerce_weight_unit');
$default_location = explode(':', get_option('woocommerce_default_country'));
$country_code = isset($default_location[0]) ? $default_location[0] : '';
$state_code = isset($default_location[1]) ? $default_location[1] : '';
$response = array('ack' => 'ok', 'logo' => $logo_url, 'currency' => $currency, 'dimension_unit' => $dimension_unit, 'weight_unit' => $weight_unit, 'country_code' => $country_code, 'state_code' => $state_code);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'tax') {
if (!$this->check_hash()) {
exit;
}
$tax_enabled = true;
if (function_exists('wc_tax_enabled')) {
$tax_enabled = wc_tax_enabled();
} else {
$tax_enabled = get_option('woocommerce_calc_taxes') === 'yes';
}
if ($tax_enabled) {
$rates = $wpdb->get_results("SELECT tax_rate_country AS country, tax_rate_state AS state, tax_rate AS rate, tax_rate_name AS name, tax_rate_class AS class, tax_rate_order AS sequence, tax_rate_priority AS priority FROM `{$wpdb->prefix}woocommerce_tax_rates` ORDER BY tax_rate_order");
} else {
$rates = array();
}
$response = array('ack' => 'ok', 'tax_rates' => $rates);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'products') {
if (!$this->check_hash()) {
exit;
}
$page = isset($_GET['page']) ? (int) $_GET['page'] : 0;
$count = isset($_GET['count']) ? (int) $_GET['count'] : 0;
$product_ids = isset($_GET['product_ids']) ? json_decode(wp_unslash($_GET['product_ids'])) : null;
if (!is_null($product_ids)) {
if (!is_array($product_ids)) {
$product_ids = array($product_ids);
}
$product_ids = array_filter($product_ids, create_function('$v', 'return is_numeric($v);'));
if (!isset($_GET['count'])) {
$count = count($product_ids);
}
}
$products = $wpdb->get_results($wpdb->prepare("SELECT id AS id " . "FROM `{$wpdb->prefix}posts` AS P " . "WHERE post_type = 'product' " . "\t\tAND post_status IN ('publish', 'future', 'pending', 'private') " . "\t" . (is_array($product_ids) ? 'AND id IN (' . implode(',', $product_ids) . ')' : '') . "" . "ORDER BY ID LIMIT %d, %d", $page * $count, $count));
if (!is_array($product_ids) && $page === 0) {
$total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` WHERE post_type = 'product' AND post_status IN ('publish', 'future', 'pending', 'private')");
}
$acf_installed = function_exists('acf');
foreach ($products as $product) {
$wc_product = $this->get_product($product->id);
$categoryproduct = $wc_product->get_categories();
$product->sku = $wc_product->get_sku();
$product->name = html_entity_decode(apply_filters('woocommerce_product_title', $wc_product->post->post_title, $wc_product), ENT_COMPAT | ENT_HTML401, 'UTF-8');
$product->enabled = $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock());
$product->price = $wc_product->get_price_excluding_tax();
$product->listprice = floatval($wc_product->get_regular_price());
$product->is_taxable = $wc_product->is_taxable();
$product->tax_class = $wc_product->get_tax_class();
$product->stock_control = $wc_product->managing_stock();
$product->stock_level = $wc_product->get_stock_quantity();
if (method_exists($wc_product, 'get_type')) {
$product->type = $wc_product->get_type();
} else {
$product->type = $wc_product->product_type;
}
$product->description = apply_filters('the_content', $wc_product->post->post_content);
$product->short_description = apply_filters('the_content', $wc_product->post->post_excerpt);
if (method_exists($wc_product, 'get_width')) {
$product->width = $wc_product->get_width();
if (!is_numeric($product->width)) {
unset($product->width);
}
$product->height = $wc_product->get_height();
if (!is_numeric($product->height)) {
unset($product->height);
}
$product->length = $wc_product->get_length();
if (!is_numeric($product->length)) {
unset($product->length);
}
} else {
$product->length = $wc_product->length;
$product->width = $wc_product->width;
$product->height = $wc_product->height;
}
$product->weight = $wc_product->get_weight();
if (!is_numeric($product->weight)) {
unset($product->weight);
}
if ($product->is_taxable && 'yes' === get_option('woocommerce_prices_include_tax')) {
$tax_rates = WC_Tax::get_shop_base_rate($product->tax_class);
$taxes = WC_Tax::calc_tax($product->listprice, $tax_rates, true);
$product->listprice = $product->listprice - array_sum($taxes);
}
if ($product->type == 'variable') {
$product->skus = array();
foreach ($wc_product->get_children() as $child_id) {
$child_product = $wc_product->get_child($child_id);
$img = wp_get_attachment_image_src($child_product->get_image_id(), 'full');
$img = $img[0];
$child_product_data = array('id' => $child_id, 'sku' => $child_product->get_sku(), 'enabled' => $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock()), 'price' => $child_product->get_price_excluding_tax(), 'listprice' => $child_product->get_regular_price(), 'is_taxable' => $child_product->is_taxable(), 'tax_class' => $child_product->get_tax_class(), 'stock_control' => $child_product->managing_stock(), 'stock_level' => $child_product->get_stock_quantity(), 'images' => array(array('source' => $img, 'sequence' => 0)));
$attributes = array();
$termsmap = array();
$names = array();
foreach ($child_product->get_variation_attributes() as $name => $value) {
$name = preg_replace('/(pa_)?attribute_/', '', $name);
if (!isset($names[$name])) {
$names[$name] = true;
$terms = get_terms(array('taxonomy' => $name));
if ($terms) {
foreach ($terms as $term) {
$termsmap[$term->slug] = $term->name;
}
}
}
if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) {
if (array_key_exists($value, $termsmap)) {
$newvalue = $termsmap[$value];
} else {
$newvalue = $value;
}
} else {
$newvalue = '';
}
$name = wc_attribute_label($name, $child_product);
$attributes[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value);
}
foreach (get_post_custom_keys($child_product->variation_id) as $attribute) {
if (!(in_array($attribute, array('_sku', '_weight', '_length', '_width', '_height', '_thumbnail_id', '_virtual', '_downloadable', '_regular_price', '_sale_price', '_sale_price_dates_from', '_sale_price_dates_to', '_price', '_download_limit', '_download_expiry', '_file_paths', '_manage_stock', '_stock_status', '_downloadable_files', '_variation_description', '_tax_class', '_tax_status', '_stock', '_default_attributes', '_product_attributes', '_file_path', '_backorders')) || substr($attribute, 0, 4) === '_wp_' || substr($attribute, 0, 13) === 'attribute_pa_')) {
$value = get_post_meta($child_product->variation_id, $attribute, false);
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$attributes[] = array('name' => $attribute, 'value' => $value, 'custom' => true);
}
}
$child_product_data['attributes'] = $attributes;
$product->skus[] = $child_product_data;
}
$attrs = array();
foreach ($wc_product->get_variation_attributes() as $name => $value) {
$name = preg_replace('/(pa_)?attribute_/', '', $name);
if (!isset($names[$name])) {
$names[$name] = true;
$terms = get_terms(array('taxonomy' => $name));
if ($terms) {
foreach ($terms as $term) {
$termsmap[$term->slug] = $term->name;
}
}
}
if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) {
if (array_key_exists($value, $termsmap)) {
$newvalue = $termsmap[$value];
} else {
$newvalue = $value;
}
} else {
$newvalue = '';
}
$name = wc_attribute_label($name, $child_product);
$attrs[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value);
}
$product->options = $attrs;
} else {
if ($product->type == 'grouped') {
$product->skus = array();
foreach ($wc_product->get_children() as $child_id) {
$child_product = $wc_product->get_child($child_id);
$child_product_data = array('id' => $child_id, 'price' => $child_product->get_price_excluding_tax(), 'sku' => $child_product->get_sku(), 'name' => $child_product->get_title());
$product->skus[] = $child_product_data;
}
}
}
$product->categories = array();
$product_categories = get_the_terms($product->id, 'product_cat');
if (is_array($product_categories)) {
$sequence = 0;
foreach ($product_categories as $category) {
$product->categories[] = array('category_id' => $category->term_id, 'sequence' => $sequence);
$sequence++;
}
}
$image_sequence = 1;
$product->images = array();
$imagesUsed = array();
$primaryimage_path = wp_get_attachment_image_src($wc_product->get_image_id(), 'full');
$primaryimage_path = $primaryimage_path[0];
if ($primaryimage_path) {
$product->images[] = array('source' => $primaryimage_path, 'sequence' => 0);
$imagesUsed[$primaryimage_path] = true;
foreach ($wc_product->get_gallery_attachment_ids() as $image_id) {
$image_path = wp_get_attachment_image_src($image_id, 'full');
$image_path = $image_path[0];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
}
}
$product->attributes = array();
$attributesUsed = array();
foreach ($wc_product->get_attributes() as $attribute) {
if (!$attribute['is_variation']) {
if (!array_key_exists($attribute['name'], $attributesUsed)) {
$attributesUsed[$attribute['name']] = true;
$attributeName = wc_attribute_label($attribute['name']);
if (!$attribute['is_taxonomy']) {
$product->attributes[] = array('name' => $attributeName, 'value' => $attribute['value']);
} else {
$attributeValue = implode(', ', wc_get_product_terms($product->id, $attribute['name'], array('fields' => 'names')));
$product->attributes[] = array('name' => $attributeName, 'value' => $attributeValue);
}
}
}
}
foreach (get_post_custom_keys($product->id) as $attribute) {
if (!(substr($attribute, 0, 1) === '_' || substr($attribute, 0, 3) === 'pa_')) {
if (!array_key_exists($attribute, $attributesUsed)) {
$attributesUsed[$attribute] = true;
$value = get_post_meta($product->id, $attribute, false);
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$product->attributes[] = array('name' => $attribute, 'value' => $value);
}
}
}
// acf
if ($acf_installed) {
if (function_exists('get_field_objects')) {
$fields = get_field_objects($product->id);
if (is_array($fields)) {
foreach ($fields as $field) {
if ($field['type'] == 'image') {
$image_path = $field['value']['url'];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
} else {
if ($field['type'] == 'gallery') {
$gallery = $field['value'];
if (is_array($gallery)) {
foreach ($gallery as $image) {
$image_path = $image['url'];
if (!array_key_exists($image_path, $imagesUsed)) {
$product->images[] = array('source' => $image_path, 'sequence' => $image_sequence);
$imagesUsed[$image_path] = true;
$image_sequence++;
}
}
}
} else {
if (in_array($field['type'], array('textarea', 'wysiwyg', 'text', 'number', 'select', 'radio', 'checkbox', 'true_false'))) {
if (!array_key_exists($field['label'], $attributesUsed)) {
$attributesUsed[$field['label']] = true;
$value = $field['value'];
if (is_array($value)) {
if (count($value) === 1) {
$value = $value[0];
} else {
$value = implode(',', $value);
}
}
$product->attributes[] = array('name' => $field['name'], 'value' => $value);
}
}
}
}
if (!$product->description) {
if (in_array($field['type'], array('textarea', 'wysiwyg')) && $field['name'] == 'description') {
$product->description = $field['value'];
}
}
}
}
}
}
}
$response = array('ack' => 'ok', 'products' => $products);
if (isset($total_count)) {
$response['total_count'] = $total_count;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'categories') {
if (!$this->check_hash()) {
exit;
}
$categories = get_categories(array('taxonomy' => 'product_cat', 'orderby' => 'term_order', 'hide_empty' => 0));
$result = array();
foreach ($categories as $category) {
$result[] = array('category_id' => $category->term_id, 'name' => $category->name, 'parent_id' => $category->parent);
}
$response = array('ack' => 'ok', 'categories' => $result, 'total_count' => count($categories));
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type === 'orders') {
if (!$this->check_hash()) {
exit;
}
$page = isset($_GET['page']) ? (int) $_GET['page'] : 0;
$count = isset($_GET['count']) ? (int) $_GET['count'] : 0;
$orders = $wpdb->get_results($wpdb->prepare("SELECT (SELECT meta_value FROM `{$wpdb->prefix}postmeta` WHERE post_id = P.id AND meta_key = '_codisto_orderid') AS id, ID AS post_id, post_status AS status FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid') ORDER BY ID LIMIT %d, %d", $page * $count, $count));
if ($page == 0) {
$total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid')");
}
$order_data = array();
foreach ($orders as $order) {
$ship_date = get_post_meta($order->post_id, '_date_shipped', true);
if ($ship_date) {
if (is_numeric($ship_date)) {
$ship_date = date('Y-m-d H:i:s', $ship_date);
}
$order->ship_date = $ship_date;
}
$carrier = get_post_meta($order->post_id, '_tracking_provider', true);
if ($carrier) {
if ($carrier === 'custom') {
$carrier = get_post_meta($order->post_id, '_custom_tracking_provider', true);
}
if ($carrier) {
$order->carrier = $carrier;
}
}
$tracking_number = get_post_meta($order->post_id, '_tracking_number', true);
if ($tracking_number) {
$order->track_number = $tracking_number;
}
unset($order->post_id);
$order_data[] = $order;
}
$response = array('ack' => 'ok', 'orders' => $order_data);
if (isset($total_count)) {
$response['total_count'] = $total_count;
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} else {
if ($type == 'sync') {
if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') {
if (!$this->check_hash()) {
exit;
}
$ebayDesignDir = WP_CONTENT_DIR . '/ebay/';
$merchantid = (int) $_GET['merchantid'];
if (!$merchantid) {
$merchantid = 0;
}
$templatedb = get_temp_dir() . '/ebay-template-' . $merchantid . '.db';
$db = new PDO('sqlite:' . $templatedb);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_TIMEOUT, 60);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=65536');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=MEMORY');
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
$db->exec('CREATE TABLE IF NOT EXISTS File(Name text NOT NULL PRIMARY KEY, Content blob NOT NULL, LastModified datetime NOT NULL, Changed bit NOT NULL DEFAULT -1)');
$db->exec('COMMIT TRANSACTION');
if (isset($_GET['markreceived'])) {
$update = $db->prepare('UPDATE File SET LastModified = ? WHERE Name = ?');
$files = $db->query('SELECT Name FROM File WHERE Changed != 0');
$files->execute();
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
while ($row = $files->fetch()) {
$stat = stat(WP_CONTENT_DIR . '/ebay/' . $row['Name']);
$lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']);
$update->bindParam(1, $lastModified);
$update->bindParam(2, $row['Name']);
$update->execute();
}
$db->exec('UPDATE File SET Changed = 0');
$db->exec('COMMIT TRANSACTION');
$db = null;
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
exit;
} else {
$insert = $db->prepare('INSERT OR IGNORE INTO File(Name, Content, LastModified) VALUES (?, ?, ?)');
$update = $db->prepare('UPDATE File SET Content = ?, Changed = -1 WHERE Name = ? AND LastModified != ?');
$filelist = $this->files_in_dir($ebayDesignDir);
$db->exec('BEGIN EXCLUSIVE TRANSACTION');
foreach ($filelist as $key => $name) {
try {
$fileName = $ebayDesignDir . $name;
if (!in_array($name, array('README'))) {
$content = @file_get_contents($fileName);
if ($content !== false) {
$stat = stat($fileName);
$lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']);
$update->bindParam(1, $content);
$update->bindParam(2, $name);
$update->bindParam(3, $lastModified);
$update->execute();
if ($update->rowCount() == 0) {
$insert->bindParam(1, $name);
$insert->bindParam(2, $content);
$insert->bindParam(3, $lastModified);
$insert->execute();
}
}
}
} catch (Exception $e) {
}
}
$db->exec('COMMIT TRANSACTION');
$tmpDb = wp_tempnam();
$db = new PDO('sqlite:' . $tmpDb);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=512');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=OFF');
$db->exec('ATTACH DATABASE \'' . $templatedb . '\' AS Source');
$db->exec('CREATE TABLE File AS SELECT * FROM Source.File WHERE Changed != 0');
$db->exec('DETACH DATABASE Source');
$db->exec('VACUUM');
$fileCountStmt = $db->query('SELECT COUNT(*) AS fileCount FROM File');
$fileCountStmt->execute();
$fileCountRow = $fileCountStmt->fetch();
$fileCount = $fileCountRow['fileCount'];
$db = null;
if ($fileCount == 0) {
$this->sendHttpHeaders('204 No Content', array('Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
} else {
$headers = array('Cache-Control' => 'no-cache, must-revalidate', 'Pragma' => 'no-cache', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Content-Type' => 'application/octet-stream', 'Content-Disposition' => 'attachment; filename=' . basename($tmpDb), 'Content-Length' => filesize($tmpDb));
$this->sendHttpHeaders('200 OK', $headers);
while (ob_get_level() > 0) {
if (!@ob_end_clean()) {
break;
}
}
flush();
readfile($tmpDb);
}
unlink($tmpDb);
exit;
}
}
}
}
}
}
}
}
}
} else {
if ($type === 'createorder') {
if (!$this->check_hash()) {
exit;
}
try {
$xml = simplexml_load_string(file_get_contents('php://input'));
$ordercontent = $xml->entry->content->children('http://api.codisto.com/schemas/2009/');
$wpdb->query('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE');
$wpdb->query('START TRANSACTION');
$billing_address = $ordercontent->orderaddresses->orderaddress[0];
$shipping_address = $ordercontent->orderaddresses->orderaddress[1];
$billing_first_name = $billing_last_name = '';
if (strpos($billing_address->name, ' ') !== false) {
$billing_name = explode(' ', $billing_address->name, 2);
$billing_first_name = $billing_name[0];
$billing_last_name = $billing_name[1];
} else {
$billing_first_name = (string) $billing_address->name;
}
$billing_country_code = (string) $billing_address->countrycode;
$billing_division = (string) $billing_address->division;
$billing_states = WC()->countries->get_states($billing_country_code);
if ($billing_states) {
$billing_division_match = preg_replace('/\\s+/', '', strtolower($billing_division));
foreach ($billing_states as $state_code => $state_name) {
if (preg_replace('/\\s+/', '', strtolower($state_name)) == $billing_division_match) {
$billing_division = $state_code;
break;
}
}
}
$shipping_first_name = $shipping_last_name = '';
if (strpos($shipping_address->name, ' ') !== false) {
$shipping_name = explode(' ', $shipping_address->name, 2);
$shipping_first_name = $shipping_name[0];
$shipping_last_name = $shipping_name[1];
} else {
$shipping_first_name = (string) $shipping_address->name;
}
$shipping_country_code = (string) $shipping_address->countrycode;
$shipping_division = (string) $shipping_address->division;
if ($billing_country_code === $shipping_country_code) {
$shipping_states = $billing_states;
} else {
$shipping_states = WC()->countries->get_states($shipping_country_code);
}
if ($shipping_states) {
$shipping_division_match = preg_replace('/\\s+/', '', strtolower($shipping_division));
foreach ($shipping_states as $state_code => $state_name) {
if (preg_replace('/\\s+/', '', strtolower($state_name)) == $shipping_division_match) {
$shipping_division = $state_code;
break;
}
}
}
$address_data = array('billing_first_name' => $billing_first_name, 'billing_last_name' => $billing_last_name, 'billing_company' => (string) $billing_address->companyname, 'billing_address_1' => (string) $billing_address->address1, 'billing_address_2' => (string) $billing_address->address2, 'billing_city' => (string) $billing_address->place, 'billing_postcode' => (string) $billing_address->postalcode, 'billing_state' => $billing_division, 'billing_country' => $billing_country_code, 'billing_email' => (string) $billing_address->email, 'billing_phone' => (string) $billing_address->phone, 'shipping_first_name' => $shipping_first_name, 'shipping_last_name' => $shipping_last_name, 'shipping_company' => (string) $shipping_address->companyname, 'shipping_address_1' => (string) $shipping_address->address1, 'shipping_address_2' => (string) $shipping_address->address2, 'shipping_city' => (string) $shipping_address->place, 'shipping_postcode' => (string) $shipping_address->postalcode, 'shipping_state' => $shipping_division, 'shipping_country' => $shipping_country_code, 'shipping_email' => (string) $shipping_address->email, 'shipping_phone' => (string) $shipping_address->phone);
$email = (string) $billing_address->email;
if (!$email) {
$email = (string) $shipping_address->email;
}
if ($email) {
$user = get_user_by('email', $email);
if (!$user) {
$username = (string) $ordercontent->ebayusername;
if (!$username) {
$username = current(explode('@', $email));
}
if ($username) {
$username = sanitize_user($username);
}
if (username_exists($username)) {
$counter = 1;
$newusername = $username . $counter;
while (username_exists($newusername)) {
$counter++;
$newusername = $username . $counter;
}
$username = $newusername;
}
$password = wp_generate_password();
$customer_data = apply_filters('woocommerce_new_customer_data', array('user_login' => $username, 'user_pass' => $password, 'user_email' => $email, 'role' => 'customer'));
$customer_id = wp_insert_user($customer_data);
foreach ($address_data as $key => $value) {
update_user_meta($customer_id, $key, $value);
}
do_action('woocommerce_created_customer', $customer_id, $customer_data, true);
} else {
$customer_id = $user->ID;
}
} else {
$customer_id = 0;
}
$customer_note = @count($ordercontent->instructions) ? strval($ordercontent->instructions) : '';
$order_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM `{$wpdb->prefix}posts` AS P WHERE ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid' AND meta_value = %d)", (int) $ordercontent->orderid));
$shipping = 0;
$shipping_tax = 0;
$cart_discount = 0;
$cart_discount_tax = 0;
$total = (double) $ordercontent->ordertotal;
$tax = 0;
if (!$order_id) {
$new_order_data_callback = array($this, 'order_set_date');
add_filter('woocommerce_new_order_data', $new_order_data_callback, 1, 1);
$order = wc_create_order(array('customer_id' => $customer_id, 'customer_note' => $customer_note, 'created_via' => 'eBay'));
remove_filter('woocommerce_new_order_data', $new_order_data_callback);
$order_id = $order->id;
update_post_meta($order_id, '_codisto_orderid', (int) $ordercontent->orderid);
update_post_meta($order_id, '_codisto_ebayuser', (string) $ordercontent->ebayusername);
update_post_meta($order_id, '_order_currency', (string) $ordercontent->transactcurrency);
update_post_meta($order_id, '_customer_ip_address', '-');
delete_post_meta($order_id, '_prices_include_tax');
do_action('woocommerce_new_order', $order_id);
foreach ($ordercontent->orderlines->orderline as $orderline) {
if ($orderline->productcode[0] != 'FREIGHT') {
$productcode = (string) $orderline->productcode;
if ($productcode == null) {
$productcode = '';
}
$productname = (string) $orderline->productname;
if ($productname == null) {
$productname = '';
}
$product_id = $orderline->externalreference[0];
if ($product_id != null) {
$product_id = intval($product_id);
}
$variation_id = 0;
if (get_post_type($product_id) === 'product_variation') {
$variation_id = $product_id;
$product_id = wp_get_post_parent_id($variation_id);
if (!is_numeric($product_id) || $product_id === 0) {
$product_id = 0;
$variation_id = 0;
}
}
$qty = (int) $orderline->quantity[0];
$item_id = wc_add_order_item($order_id, array('order_item_name' => $productname, 'order_item_type' => 'line_item'));
wc_add_order_item_meta($item_id, '_qty', $qty);
if (!is_null($product_id) && $product_id !== 0) {
wc_add_order_item_meta($item_id, '_product_id', $product_id);
wc_add_order_item_meta($item_id, '_variation_id', $variation_id);
wc_add_order_item_meta($item_id, '_tax_class', '');
} else {
wc_add_order_item_meta($item_id, '_product_id', 0);
wc_add_order_item_meta($item_id, '_variation_id', 0);
wc_add_order_item_meta($item_id, '_tax_class', '');
}
$line_total = wc_format_decimal((double) $orderline->linetotal);
$line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal);
wc_add_order_item_meta($item_id, '_line_subtotal', $line_total);
wc_add_order_item_meta($item_id, '_line_total', $line_total);
wc_add_order_item_meta($item_id, '_line_subtotal_tax', $line_total_tax);
wc_add_order_item_meta($item_id, '_line_tax', $line_total_tax);
wc_add_order_item_meta($item_id, '_line_tax_data', array('total' => array(1 => $line_total_tax), 'subtotal' => array(1 => $line_total_tax)));
$tax += $line_total_tax;
} else {
$item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping'));
wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal));
$shipping += (double) $orderline->linetotal;
$shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal;
}
}
if ($ordercontent->paymentstatus == 'complete') {
$transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid;
if ($transaction_id) {
update_post_meta($order_id, '_payment_method', 'paypal');
update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce'));
update_post_meta($order_id, '_transaction_id', $transaction_id);
} else {
update_post_meta($order_id, '_payment_method', 'bacs');
update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce'));
}
// payment_complete
add_post_meta($order_id, '_paid_date', current_time('mysql'), true);
if (!get_post_meta($order_id, '_order_stock_reduced', true)) {
$order->reduce_order_stock();
}
}
} else {
$order = wc_get_order($order_id);
foreach ($ordercontent->orderlines->orderline as $orderline) {
if ($orderline->productcode[0] != 'FREIGHT') {
$line_total = wc_format_decimal((double) $orderline->linetotal);
$line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal);
$tax += $line_total_tax;
} else {
$order->remove_order_items('shipping');
$item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping'));
wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal));
$shipping += (double) $orderline->linetotal;
$shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal;
}
}
if ($ordercontent->paymentstatus == 'complete') {
$transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid;
if ($transaction_id) {
update_post_meta($order_id, '_payment_method', 'paypal');
update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce'));
update_post_meta($order_id, '_transaction_id', $transaction_id);
} else {
update_post_meta($order_id, '_payment_method', 'bacs');
update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce'));
}
// payment_complete
add_post_meta($order_id, '_paid_date', current_time('mysql'), true);
if (!get_post_meta($order_id, '_order_stock_reduced', true)) {
$order->reduce_order_stock();
}
}
}
foreach ($address_data as $key => $value) {
update_post_meta($order_id, '_' . $key, $value);
}
$order->remove_order_items('tax');
$order->add_tax(1, $tax, $shipping_tax);
$order->set_total($shipping, 'shipping');
$order->set_total($shipping_tax, 'shipping_tax');
$order->set_total($cart_discount, 'cart_discount');
$order->set_total($cart_discount_tax, 'cart_discount_tax');
$order->set_total($tax, 'tax');
$order->set_total($total, 'total');
if ($ordercontent->orderstate == 'cancelled') {
if (!$order->has_status('cancelled')) {
// update_status
$order->post_status = 'wc-cancelled';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-cancelled', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
$order->decrease_coupon_usage_counts();
wc_delete_shop_order_transients($order_id);
}
} else {
if ($ordercontent->orderstate == 'inprogress' || $ordercontent->orderstate == 'processing') {
if ($ordercontent->paymentstatus == 'complete') {
if (!$order->has_status('processing')) {
// update_status
$order->post_status = 'wc-processing';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-processing', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
}
} else {
if (!$order->has_status('pending')) {
// update_status
$order->post_status = 'wc-pending';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-pending', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
}
}
} else {
if ($ordercontent->orderstate == 'complete') {
if (!$order->has_status('completed')) {
// update_status
$order->post_status = 'wc-completed';
$update_post_data = array('ID' => $order_id, 'post_status' => 'wc-completed', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1));
wp_update_post($update_post_data);
$order->record_product_sales();
$order->increase_coupon_usage_counts();
update_post_meta($order_id, '_completed_date', current_time('mysql'));
wc_delete_shop_order_transients($order_id);
}
}
}
}
$wpdb->query('COMMIT');
$response = array('ack' => 'ok', 'orderid' => $order_id);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
} catch (Exception $e) {
$wpdb->query('ROLLBACK');
$response = array('ack' => 'failed', 'message' => $e->getMessage() . ' ' . $e->getFile() . ' ' . $e->getLine());
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode($response);
exit;
}
} else {
if ($type == 'sync') {
if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') {
if (!$this->check_hash()) {
exit;
}
$ebayDesignDir = WP_CONTENT_DIR . '/ebay/';
$tmpPath = wp_tempnam();
@file_put_contents($tmpPath, file_get_contents('php://input'));
$db = new PDO('sqlite:' . $tmpPath);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('PRAGMA synchronous=0');
$db->exec('PRAGMA temp_store=2');
$db->exec('PRAGMA page_size=65536');
$db->exec('PRAGMA encoding=\'UTF-8\'');
$db->exec('PRAGMA cache_size=15000');
$db->exec('PRAGMA soft_heap_limit=67108864');
$db->exec('PRAGMA journal_mode=MEMORY');
$files = $db->prepare('SELECT Name, Content FROM File');
$files->execute();
$files->bindColumn(1, $name);
$files->bindColumn(2, $content);
while ($files->fetch()) {
$fileName = $ebayDesignDir . $name;
if (strpos($name, '..') === false) {
if (!file_exists($fileName)) {
$dir = dirname($fileName);
if (!is_dir($dir)) {
mkdir($dir . '/', 0755, true);
}
@file_put_contents($fileName, $content);
}
}
}
$db = null;
unlink($tmpPath);
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $this->json_encode(array('ack' => 'ok'));
exit;
}
} else {
if ($type == 'index/calc') {
$product_ids = array();
$quantities = array();
for ($i = 0;; $i++) {
if (!isset($_POST['PRODUCTCODE(' . $i . ')'])) {
break;
}
$productid = (int) $_POST['PRODUCTID(' . $i . ')'];
if (!$productid) {
$productcode = $_POST['PRODUCTCODE(' . $i . ')'];
$productid = wc_get_product_id_by_sku($productcode);
}
$productqty = $_POST['PRODUCTQUANTITY(' . $i . ')'];
if (!$productqty && $productqty != 0) {
$productqty = 1;
}
WC()->cart->add_to_cart($productid, $productqty);
}
WC()->customer->set_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']);
WC()->customer->set_shipping_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']);
WC()->cart->calculate_totals();
WC()->cart->calculate_shipping();
$response = '';
$idx = 0;
$methods = WC()->shipping()->get_shipping_methods();
foreach ($methods as $method) {
if (file_exists(plugin_dir_path(__FILE__) . 'shipping/' . $method->id)) {
include plugin_dir_path(__FILE__) . 'shipping/' . $method->id;
} else {
foreach ($method->rates as $method => $rate) {
$method_name = $rate->get_label();
if (!$method_name) {
$method_name = 'Shipping';
}
$method_cost = $rate->cost;
if (is_numeric($method_cost)) {
if (isset($rate->taxes) && is_array($rate->taxes)) {
foreach ($rate->taxes as $tax) {
if (is_numeric($tax)) {
$method_cost += $tax;
}
}
}
$response .= ($idx > 0 ? '&' : '') . 'FREIGHTNAME(' . $idx . ')=' . rawurlencode($method_name) . '&FREIGHTCHARGEINCTAX(' . $idx . ')=' . number_format((double) $method_cost, 2, '.', '');
$idx++;
}
}
}
}
$this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache'));
echo $response;
exit;
}
}
}
}
}
public function get_product_by_id($sku = null)
{
global $wpdb;
$product_id = null;
/* ! @since 3.0.6 use new function wc_get_product_id_by_sku to get SKU */
if (function_exists('wc_get_product_id_by_sku')) {
$product_id = wc_get_product_id_by_sku($sku);
} else {
$product_id = $wpdb->get_var($wpdb->prepare("SELECT max(post_id) FROM {$wpdb->postmeta} a, {$wpdb->posts} b\n\t\t\t\tWHERE a.post_id= b.id and meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku));
}
if ($product_id) {
$product['ID'] = $product_id;
}
return $product_id = apply_filters('woocsv_get_product_id', $product_id, $sku);
}
/**
* Create or update a line item
*
* @since 2.5.0
* @param WC_Order $order
* @param array $item line item data
* @param string $action 'create' to add line item or 'update' to update it
* @throws WC_CLI_Exception invalid data, server error
*/
protected function set_line_item($order, $item, $action)
{
$creating = 'create' === $action;
// product is always required
if (!isset($item['product_id']) && !isset($item['sku'])) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product_id', __('Product ID or SKU is required', 'woocommerce'));
}
// when updating, ensure product ID provided matches
if ('update' === $action) {
$item_product_id = wc_get_order_item_meta($item['id'], '_product_id');
$item_variation_id = wc_get_order_item_meta($item['id'], '_variation_id');
if ($item['product_id'] != $item_product_id && $item['product_id'] != $item_variation_id) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product_id', __('Product ID provided does not match this line item', 'woocommerce'));
}
}
if (isset($item['product_id'])) {
$product_id = $item['product_id'];
} elseif (isset($item['sku'])) {
$product_id = wc_get_product_id_by_sku($item['sku']);
}
// variations must each have a key & value
$variation_id = 0;
if (isset($item['variations']) && is_array($item['variations'])) {
foreach ($item['variations'] as $key => $value) {
if (!$key || !$value) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product_variation', __('The product variation is invalid', 'woocommerce'));
}
}
$item_args['variation'] = $item['variations'];
$variation_id = $this->get_variation_id(wc_get_product($product_id), $item_args['variation']);
}
$product = wc_get_product($variation_id ? $variation_id : $product_id);
// must be a valid WC_Product
if (!is_object($product)) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product', __('Product is invalid.', 'woocommerce'));
}
// quantity must be positive float
if (isset($item['quantity']) && floatval($item['quantity']) <= 0) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product_quantity', __('Product quantity must be a positive float.', 'woocommerce'));
}
// quantity is required when creating
if ($creating && !isset($item['quantity'])) {
throw new WC_CLI_Exception('woocommerce_cli_invalid_product_quantity', __('Product quantity is required.', 'woocommerce'));
}
$item_args = array();
// quantity
if (isset($item['quantity'])) {
$item_args['qty'] = $item['quantity'];
}
// total
if (isset($item['total'])) {
$item_args['totals']['total'] = floatval($item['total']);
}
// total tax
if (isset($item['total_tax'])) {
$item_args['totals']['tax'] = floatval($item['total_tax']);
}
// subtotal
if (isset($item['subtotal'])) {
$item_args['totals']['subtotal'] = floatval($item['subtotal']);
}
// subtotal tax
if (isset($item['subtotal_tax'])) {
$item_args['totals']['subtotal_tax'] = floatval($item['subtotal_tax']);
}
$item_args = apply_filters('woocommerce_cli_order_line_item_args', $item_args, $item, $order, $action);
if ($creating) {
$item_id = $order->add_product($product, $item_args['qty'], $item_args);
if (!$item_id) {
throw new WC_CLI_Exception('woocommerce_cannot_create_line_item', __('Cannot create line item, try again.', 'woocommerce'));
}
} else {
$item_id = $order->update_product($item['id'], $product, $item_args);
if (!$item_id) {
throw new WC_CLI_Exception('woocommerce_cannot_update_line_item', __('Cannot update line item, try again.', 'woocommerce'));
}
}
}
/**
* Test wc_get_product_id_by_sku()
*
* @since 2.3
*/
public function test_wc_get_product_id_by_sku()
{
// Create product
$product = \WC_Helper_Product::create_simple_product();
$this->assertEquals($product->id, wc_get_product_id_by_sku($product->sku));
// Delete Product
\WC_Helper_Product::delete_product($product->id);
}
public function get_product_sku($skus = array())
{
$return = array();
foreach ($skus as $sku) {
if (empty($sku)) {
continue;
}
$return[] = wc_get_product_id_by_sku($sku);
}
return $return;
}
/**
* Bulk update or insert products
* Accepts an array with products in the formats supported by
* WC_API_Products->create_product() and WC_API_Products->edit_product()
*
* @since 2.4.0
* @param array $data
* @return array
*/
public function bulk($data)
{
try {
if (!isset($data['products'])) {
throw new WC_API_Exception('woocommerce_api_missing_products_data', sprintf(__('No %1$s data specified to create/edit %1$s', 'woocommerce'), 'products'), 400);
}
$data = $data['products'];
$limit = apply_filters('woocommerce_api_bulk_limit', 100, 'products');
// Limit bulk operation
if (count($data) > $limit) {
throw new WC_API_Exception('woocommerce_api_products_request_entity_too_large', sprintf(__('Unable to accept more than %s items for this request', 'woocommerce'), $limit), 413);
}
$products = array();
foreach ($data as $_product) {
$product_id = 0;
$product_sku = '';
// Try to get the product ID
if (isset($_product['id'])) {
$product_id = intval($_product['id']);
}
if (!$product_id && isset($_product['sku'])) {
$product_sku = wc_clean($_product['sku']);
$product_id = wc_get_product_id_by_sku($product_sku);
}
// Product exists / edit product
if ($product_id) {
$edit = $this->edit_product($product_id, array('product' => $_product));
if (is_wp_error($edit)) {
$products[] = array('id' => $product_id, 'sku' => $product_sku, 'error' => array('code' => $edit->get_error_code(), 'message' => $edit->get_error_message()));
} else {
$products[] = $edit['product'];
}
} else {
$new = $this->create_product(array('product' => $_product));
if (is_wp_error($new)) {
$products[] = array('id' => $product_id, 'sku' => $product_sku, 'error' => array('code' => $new->get_error_code(), 'message' => $new->get_error_message()));
} else {
$products[] = $new['product'];
}
}
}
return array('products' => apply_filters('woocommerce_api_products_bulk_response', $products, $this));
} catch (WC_API_Exception $e) {
return new WP_Error($e->getErrorCode(), $e->getMessage(), array('status' => $e->getCode()));
}
}
/**
* Create or update a line item.
*
* @param WC_Order $order Order data.
* @param array $item Line item data.
* @param string $action 'create' to add line item or 'update' to update it.
* @throws WC_REST_Exception Invalid data, server error.
*/
protected function set_line_item($order, $item, $action = 'create')
{
$creating = 'create' === $action;
$item_args = array();
// Product is always required.
if (empty($item['product_id']) && empty($item['sku']) && empty($item['variation_id'])) {
throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or SKU is required.', 'woocommerce'), 400);
}
if (!empty($item['sku'])) {
$product_id = (int) wc_get_product_id_by_sku($item['sku']);
} elseif (!empty($item['product_id']) && empty($item['variation_id'])) {
$product_id = (int) $item['product_id'];
} elseif (!empty($item['variation_id'])) {
$product_id = (int) $item['variation_id'];
}
// When updating, ensure product ID provided matches.
if ('update' === $action && !empty($item['id'])) {
$item_product_id = (int) wc_get_order_item_meta($item['id'], '_product_id');
$item_variation_id = (int) wc_get_order_item_meta($item['id'], '_variation_id');
if ($product_id !== $item_product_id && $product_id !== $item_variation_id) {
throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or variation ID provided does not match this line item.', 'woocommerce'), 400);
}
}
$product = wc_get_product($product_id);
// Must be a valid WC_Product.
if (!is_object($product)) {
throw new WC_REST_Exception('woocommerce_rest_invalid_product', __('Product is invalid.', 'woocommerce'), 400);
}
// Quantity must be positive float.
if (isset($item['quantity']) && 0 >= floatval($item['quantity'])) {
throw new WC_REST_Exception('woocommerce_rest_invalid_product_quantity', __('Product quantity must be a positive float.', 'woocommerce'), 400);
}
// Quantity is required when creating.
if ($creating && !isset($item['quantity'])) {
throw new WC_REST_Exception('woocommerce_rest_invalid_product_quantity', __('Product quantity is required.', 'woocommerce'), 400);
}
// Get variation attributes.
if (method_exists($product, 'get_variation_attributes')) {
$item_args['variation'] = $product->get_variation_attributes();
}
// Quantity.
if (isset($item['quantity'])) {
$item_args['qty'] = $item['quantity'];
}
// Total.
if (isset($item['total'])) {
$item_args['totals']['total'] = floatval($item['total']);
}
// Total tax.
if (isset($item['total_tax'])) {
$item_args['totals']['tax'] = floatval($item['total_tax']);
}
// Subtotal.
if (isset($item['subtotal'])) {
$item_args['totals']['subtotal'] = floatval($item['subtotal']);
}
// Subtotal tax.
if (isset($item['subtotal_tax'])) {
$item_args['totals']['subtotal_tax'] = floatval($item['subtotal_tax']);
}
if ($creating) {
$item_id = $order->add_product($product, $item_args['qty'], $item_args);
if (!$item_id) {
throw new WC_REST_Exception('woocommerce_rest_cannot_create_line_item', __('Cannot create line item, try again.', 'woocommerce'), 500);
}
} else {
$item_id = $order->update_product($item['id'], $product, $item_args);
if (!$item_id) {
throw new WC_REST_Exception('woocommerce_rest_cannot_update_line_item', __('Cannot update line item, try again.', 'woocommerce'), 500);
}
}
}
