/** * Create a order. * * @since 2.4 * * @return WC_Order Order object. */ public static function create_order() { // Create product $product = WC_Helper_Product::create_simple_product(); WC_Helper_Shipping::create_simple_flat_rate(); $order_data = array('status' => 'pending', 'customer_id' => 1, 'customer_note' => '', 'total' => ''); $_SERVER['REMOTE_ADDR'] = '127.0.0.1'; // Required, else wc_create_order throws an exception $order = wc_create_order($order_data); // Add order products $item_id = $order->add_product($product, 4); // Set billing address $billing_address = array('country' => 'US', 'first_name' => 'Jeroen', 'last_name' => 'Sormani', 'company' => 'WooCompany', 'address_1' => 'WooAddress', 'address_2' => '', 'postcode' => '123456', 'city' => 'WooCity', 'state' => 'NY', 'email' => '*****@*****.**', 'phone' => '555-32123'); $order->set_address($billing_address, 'billing'); // Add shipping costs $shipping_taxes = WC_Tax::calc_shipping_tax('10', WC_Tax::get_shipping_tax_rates()); $order->add_shipping(new WC_Shipping_Rate('flat_rate_shipping', 'Flat rate shipping', '10', $shipping_taxes, 'flat_rate')); // Set payment gateway $payment_gateways = WC()->payment_gateways->payment_gateways(); $order->set_payment_method($payment_gateways['bacs']); // Set totals $order->set_total(10, 'shipping'); $order->set_total(0, 'cart_discount'); $order->set_total(0, 'cart_discount_tax'); $order->set_total(0, 'tax'); $order->set_total(0, 'shipping_tax'); $order->set_total(40, 'total'); // 4 x $10 simple helper product return wc_get_order($order->id); }
public function update_order($data, $iopn_record_id) { global $wpdb, $woocommerce; $prefix = $wpdb->prefix . 'pwa_'; $xml = simplexml_load_string($data); $NotificationReferenceId = $xml->NotificationReferenceId; $OrderChannel = $xml->ProcessedOrder->OrderChannel; $AmazonOrderID = (string) $xml->ProcessedOrder->AmazonOrderID; $OrderDate = $xml->ProcessedOrder->OrderDate; $param['NotificationReferenceId'] = $NotificationReferenceId; $param['AmazonOrderID'] = $AmazonOrderID; $param['iopn_record_id'] = $iopn_record_id; $order_postmeta = $wpdb->get_results("select post_id from {$wpdb->postmeta} where meta_key = '_pwa_order_id' and meta_value = '{$AmazonOrderID}' "); if (empty($order_postmeta)) { $request_time = $wpdb->get_results("select * from `" . $prefix . "iopn_records` where amazon_order_id = '{$AmazonOrderID}' and notification_reference_id = '{$NotificationReferenceId}' and status = 'Rejected' "); if (!empty($request_time)) { $param['Status'] = 'Accepted'; $this->update_request($param); $order = wc_create_order(); add_post_meta($order->id, '_pwa_order_id', $AmazonOrderID); $this->update_order_detail($order->id, $data); } else { $param['Status'] = 'Rejected'; $this->update_request($param); header('HTTP/1.1 503 SERVICE_UNAVAILABLE'); exit; } } else { $param['Status'] = 'Accepted'; $this->update_request($param); $order_id = $order_postmeta[0]->post_id; $this->update_order_detail($order_id, $data); } }
/** * Create a order. * * @since 2.4 * * @return WC_Order Order object. */ public static function create_order($customer_id = 1) { // Create product $product = WC_Helper_Product::create_simple_product(); WC_Helper_Shipping::create_simple_flat_rate(); $order_data = array('status' => 'pending', 'customer_id' => $customer_id, 'customer_note' => '', 'total' => ''); $_SERVER['REMOTE_ADDR'] = '127.0.0.1'; // Required, else wc_create_order throws an exception $order = wc_create_order($order_data); // Add order products $order->add_product($product, 4); // Set billing address $order->set_billing_first_name('Jeroen'); $order->set_billing_last_name('Sormani'); $order->set_billing_company('WooCompany'); $order->set_billing_address_1('WooAddress'); $order->set_billing_address_2(''); $order->set_billing_city('WooCity'); $order->set_billing_state('NY'); $order->set_billing_postcode('123456'); $order->set_billing_country('US'); $order->set_billing_email('*****@*****.**'); $order->set_billing_phone('555-32123'); // Add shipping costs $shipping_taxes = WC_Tax::calc_shipping_tax('10', WC_Tax::get_shipping_tax_rates()); $rate = new WC_Shipping_Rate('flat_rate_shipping', 'Flat rate shipping', '10', $shipping_taxes, 'flat_rate'); $item = new WC_Order_Item_Shipping(); $item->set_props(array('method_title' => $rate->label, 'method_id' => $rate->id, 'total' => wc_format_decimal($rate->cost), 'taxes' => $rate->taxes, 'meta_data' => $rate->get_meta_data())); $order->add_item($item); // Set payment gateway $payment_gateways = WC()->payment_gateways->payment_gateways(); $order->set_payment_method($payment_gateways['bacs']); // Set totals $order->set_shipping_total(10); $order->set_discount_total(0); $order->set_discount_tax(0); $order->set_cart_tax(0); $order->set_shipping_tax(0); $order->set_total(40); // 4 x $10 simple helper product $order->save(); return $order; }
/** * Creates new WC_Order. * * @since 3.0.0 * @param $args array * @return WC_Order */ private function create_base_order($args, $data) { return wc_create_order($args); }
/** * Create an order * * @since 2.2 * @param array $data raw order data * @return array */ public function create_order($data) { $data = isset($data['order']) ? $data['order'] : array(); try { // permission check if (!current_user_can('publish_shop_orders')) { throw new WC_API_Exception('woocommerce_api_user_cannot_create_order', __('You do not have permission to create orders', 'woocommerce'), 401); } $data = apply_filters('woocommerce_api_create_order_data', $data, $this); // default order args, note that status is checked for validity in wc_create_order() $default_order_args = array('status' => isset($data['status']) ? $data['status'] : '', 'customer_note' => isset($data['note']) ? $data['note'] : null); // if creating order for existing customer if (!empty($data['customer_id'])) { // make sure customer exists if (false === get_user_by('id', $data['customer_id'])) { throw new WC_API_Exception('woocommerce_api_invalid_customer_id', __('Customer ID is invalid', 'woocommerce'), 400); } $default_order_args['customer_id'] = $data['customer_id']; } // create the pending order $order = wc_create_order($default_order_args); if (is_wp_error($order)) { throw new WC_API_Exception('woocommerce_api_cannot_create_order', sprintf(__('Cannot create order: %s', 'woocommerce'), implode(', ', $order->get_error_messages())), 400); } // billing/shipping addresses $this->set_order_addresses($order, $data); $lines = array('line_item' => 'line_items', 'shipping' => 'shipping_lines', 'fee' => 'fee_lines', 'coupon' => 'coupon_lines'); foreach ($lines as $line_type => $line) { if (isset($data[$line]) && is_array($data[$line])) { $set_item = "set_{$line_type}"; foreach ($data[$line] as $item) { $this->{$set_item}($order, $item, 'create'); } } } // calculate totals and set them $order->calculate_totals(); // payment method (and payment_complete() if `paid` == true) if (isset($data['payment_details']) && is_array($data['payment_details'])) { // method ID & title are required if (empty($data['payment_details']['method_id']) || empty($data['payment_details']['method_title'])) { throw new WC_API_Exception('woocommerce_invalid_payment_details', __('Payment method ID and title are required', 'woocommerce'), 400); } update_post_meta($order->id, '_payment_method', $data['payment_details']['method_id']); update_post_meta($order->id, '_payment_method_title', $data['payment_details']['method_title']); // mark as paid if set if (isset($data['payment_details']['paid']) && 'true' === $data['payment_details']['paid']) { $order->payment_complete(isset($data['payment_details']['transaction_id']) ? $data['payment_details']['transaction_id'] : ''); } } // set order currency if (isset($data['currency'])) { if (!array_key_exists($data['currency'], get_woocommerce_currencies())) { throw new WC_API_Exception('woocommerce_invalid_order_currency', __('Provided order currency is invalid', 'woocommerce'), 400); } update_post_meta($order->id, '_order_currency', $data['currency']); } // set order number if (isset($data['order_number'])) { update_post_meta($order->id, '_order_number', $data['order_number']); } // set order meta if (isset($data['order_meta']) && is_array($data['order_meta'])) { $this->set_order_meta($order->id, $data['order_meta']); } // HTTP 201 Created $this->server->send_status(201); wc_delete_shop_order_transients($order->id); do_action('woocommerce_api_create_order', $order->id, $this); return $this->get_order($order->id); } 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; } } } } }
/** * Create WC order. * * @since 2.0.0 * @access public */ public function create_order() { if ($this->klarna_debug == 'yes') { $this->klarna_log->add('klarna', 'Creating local order...'); } global $woocommerce; // Customer accounts $customer_id = apply_filters('woocommerce_checkout_customer_id', get_current_user_id()); // Order data $order_data = array('status' => apply_filters('klarna_checkout_incomplete_order_status', 'kco-incomplete'), 'customer_id' => $customer_id, 'created_via' => 'klarna_checkout'); // Create the order $order = wc_create_order($order_data); if (is_wp_error($order)) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } if ($this->klarna_debug == 'yes') { $this->klarna_log->add('klarna', 'Local order created, order ID: ' . $order->id); } return $order; }
function fast_order_plugin_cb() { global $post; global $woocommerce; global $product; global $wp_query; parse_str($_POST['formdata'], $formdata); $fullname = $formdata['fullname']; $address = $formdata['address']; $phone = $formdata['telephone']; $email = $formdata['email']; $pid = $formdata['pid']; $qty = $formdata['qty']; $flag = 0; $report = '<br/>'; if ($is_alpha_space = ctype_alpha(str_replace(' ', '', $fullname)) && $address != NULL && is_numeric($phone) && $pid != NULL && !$qty <= 0 && filter_var($email, FILTER_VALIDATE_EMAIL)) { $flag = 1; } else { if (!($is_alpha_space = ctype_alpha(str_replace(' ', '', $fullname)))) { $report .= "Full Name field has an error: " . $fullname . "<br/>"; } if (!$address != NULL) { $report .= "Address field has an error: " . $address . "<br/>"; } if (!is_numeric($phone)) { $report .= "Phone field has an error: " . $phone . "<br/>"; } if (!$pid != NULL) { $report .= "Product id is not correct: " . $pid . "<br/>"; } if ($qty <= 0) { $report .= "Quantity field has an error: " . $qty . "<br/>"; } if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $report .= "Email field has an error: " . $email . "<br/>"; } $flag = 0; } if ($flag == 1) { $address = array('first_name' => $fullname, 'email' => $email, 'phone' => '+92-' . $phone . '', 'address_1' => $address, 'country' => 'PK'); $order = wc_create_order(); $order->add_product(get_product($pid), $qty); //(get_product with id and next is for quantity) $order->set_address($address, 'billing'); $order->set_address($address, 'shipping'); $order->calculate_totals(); $messages = "Thank you " . $fullname . " <br/>Your order has been placed. <br/>You will receive a call from our representative shortly"; } else { $messages = "There is an error in the form <br/> Please correct it" . $report; } $return_data = array('flag' => $flag, 'messages' => $messages); echo json_encode($return_data); //echo "Yes! the ajax call was successful"; // this message will be displayed in our jacascript alert die(0); }
/** * Create order * @param float $total * @param int $customer_id * @return int */ public function create_order($total, $customer_id) { if (function_exists('wc_create_order')) { $order = wc_create_order(array('customer_id' => absint($customer_id))); $order_id = $order->id; $order->set_total($total); update_post_meta($order->id, '_booking_order', '1'); } else { $order_data = apply_filters('woocommerce_new_order_data', array('post_type' => 'shop_order', 'post_title' => sprintf(__('Order – %s', 'woocommerce-bookings'), strftime(_x('%b %d, %Y @ %I:%M %p', 'Order date parsed by strftime', 'woocommerce-bookings'))), 'post_status' => 'publish', 'ping_status' => 'closed', 'post_excerpt' => '', 'post_author' => 1, 'post_password' => uniqid('order_'))); $order_id = wp_insert_post($order_data, true); update_post_meta($order_id, '_order_shipping', 0); update_post_meta($order_id, '_order_discount', 0); update_post_meta($order_id, '_cart_discount', 0); update_post_meta($order_id, '_order_tax', 0); update_post_meta($order_id, '_order_shipping_tax', 0); update_post_meta($order_id, '_order_total', $total); update_post_meta($order_id, '_order_key', apply_filters('woocommerce_generate_order_key', uniqid('order_'))); update_post_meta($order_id, '_customer_user', absint($customer_id)); update_post_meta($order_id, '_order_currency', get_woocommerce_currency()); update_post_meta($order_id, '_prices_include_tax', get_option('woocommerce_prices_include_tax')); update_post_meta($order_id, '_booking_order', '1'); wp_set_object_terms($order_id, 'pending', 'shop_order_status'); } do_action('woocommerce_new_booking_order', $order_id); return $order_id; }
/** * Create new order for WooCommerce version 2.2+ * @return int|WP_ERROR */ public function create_order_2_2() { global $woocommerce, $wpdb; $this->shipping_methods = WC()->session->get('chosen_shipping_methods'); if (sizeof($woocommerce->cart->get_cart()) == 0) { wc_add_notice(sprintf(__('Sorry, your session has expired. <a href="%s">Return to homepage →</a>', 'hygglig'), home_url()), 'error'); } // Recheck cart items so that they are in stock $result = $woocommerce->cart->check_cart_item_stock(); if (is_wp_error($result)) { return $result->get_error_message(); exit; } // Update cart totals $woocommerce->cart->calculate_totals(); // Customer accounts $this->customer_id = apply_filters('woocommerce_checkout_customer_id', get_current_user_id()); // Give plugins the opportunity to create an order themselves if ($order_id = apply_filters('woocommerce_create_order', null, $this)) { return $order_id; } try { // Start transaction if available $wpdb->query('START TRANSACTION'); $order_data = array('status' => apply_filters('woocommerce_default_order_status', 'pending'), 'customer_id' => $this->customer_id, 'customer_note' => isset($this->posted['order_comments']) ? $this->posted['order_comments'] : ''); // Insert or update the post data $order_id = absint(WC()->session->order_awaiting_payment); // Resume the unpaid order if its pending if ($order_id > 0 && ($order = wc_get_order($order_id)) && $order->has_status(array('pending', 'failed'))) { $order_data['order_id'] = $order_id; $order = wc_update_order($order_data); if (is_wp_error($order)) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } else { $order->remove_order_items(); do_action('woocommerce_resume_order', $order_id); } } else { $order = wc_create_order($order_data); if (is_wp_error($order)) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } else { $order_id = $order->id; do_action('woocommerce_new_order', $order_id); } } // Store the line items to the new/resumed order foreach (WC()->cart->get_cart() as $cart_item_key => $values) { $item_id = $order->add_product($values['data'], $values['quantity'], array('variation' => $values['variation'], 'totals' => array('subtotal' => $values['line_subtotal'], 'subtotal_tax' => $values['line_subtotal_tax'], 'total' => $values['line_total'], 'tax' => $values['line_tax'], 'tax_data' => $values['line_tax_data']))); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allow plugins to add order item meta do_action('woocommerce_add_order_item_meta', $item_id, $values, $cart_item_key); } // Store fees foreach (WC()->cart->get_fees() as $fee_key => $fee) { $item_id = $order->add_fee($fee); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allow plugins to add order item meta to fees do_action('woocommerce_add_order_fee_meta', $order_id, $item_id, $fee, $fee_key); } // Store shipping for all packages foreach (WC()->shipping->get_packages() as $package_key => $package) { if (isset($package['rates'][$this->shipping_methods[$package_key]])) { $item_id = $order->add_shipping($package['rates'][$this->shipping_methods[$package_key]]); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allows plugins to add order item meta to shipping do_action('woocommerce_add_shipping_order_item', $order_id, $item_id, $package_key); } } // Store tax rows foreach (array_keys(WC()->cart->taxes + WC()->cart->shipping_taxes) as $tax_rate_id) { if (!$order->add_tax($tax_rate_id, WC()->cart->get_tax_amount($tax_rate_id), WC()->cart->get_shipping_tax_amount($tax_rate_id))) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } } // Store coupons foreach (WC()->cart->get_coupons() as $code => $coupon) { if (!$order->add_coupon($code, WC()->cart->get_coupon_discount_amount($code))) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } } // Payment Method $available_gateways = WC()->payment_gateways->payment_gateways(); $this->payment_method = $available_gateways['hygglig_checkout']; $order->set_payment_method($this->payment_method); $order->set_total(WC()->cart->shipping_total, 'shipping'); $order->set_total(WC()->cart->get_total_discount(), 'order_discount'); $order->set_total(WC()->cart->get_cart_discount_total(), 'cart_discount'); $order->set_total(WC()->cart->tax_total, 'tax'); $order->set_total(WC()->cart->shipping_tax_total, 'shipping_tax'); $order->set_total(WC()->cart->total); // Let plugin add meta do_action('woocommerce_checkout_update_order_meta', $order_id, array()); // If we got here, the order was created without problems! $wpdb->query('COMMIT'); } catch (Exception $e) { // There was an error adding order data! $wpdb->query('ROLLBACK'); return new WP_Error('checkout-error', $e->getMessage()); } return $order_id; }
/** * Function to create an order from a subscription. It can be used for a renewal or for a resubscribe * order creation. It is the common in both of those instances. * * @param WC_Subscription|int $subscription Subscription we're basing the order off of * @param string $type Type of new order. Default values are 'renewal_order'|'resubscribe_order' * @return WC_Order New order */ function wcs_create_order_from_subscription($subscription, $type) { $type = wcs_validate_new_order_type($type); if (is_wp_error($type)) { return $type; } global $wpdb; try { $wpdb->query('START TRANSACTION'); if (!is_object($subscription)) { $subscription = wcs_get_subscription($subscription); } $new_order = wc_create_order(array('customer_id' => $subscription->get_user_id(), 'customer_note' => $subscription->customer_note)); $new_order->post->post_title = wcs_get_new_order_title($type); wcs_copy_order_meta($subscription, $new_order, $type); // Copy over line items and allow extensions to add/remove items or item meta $items = apply_filters('wcs_new_order_items', $subscription->get_items(array('line_item', 'fee', 'shipping', 'tax')), $new_order, $subscription); $items = apply_filters('wcs_' . $type . '_items', $items, $new_order, $subscription); foreach ($items as $item_index => $item) { $item_name = apply_filters('wcs_new_order_item_name', $item['name'], $item, $subscription); $item_name = apply_filters('wcs_' . $type . '_item_name', $item_name, $item, $subscription); // Create order line item on the renewal order $recurring_item_id = wc_add_order_item($new_order->id, array('order_item_name' => $item_name, 'order_item_type' => $item['type'])); // Remove recurring line items and set item totals based on recurring line totals foreach ($item['item_meta'] as $meta_key => $meta_values) { foreach ($meta_values as $meta_value) { wc_add_order_item_meta($recurring_item_id, $meta_key, maybe_unserialize($meta_value)); } } } // If we got here, the subscription was created without problems $wpdb->query('COMMIT'); return apply_filters('wcs_new_order_created', $new_order, $subscription); } catch (Exception $e) { // There was an error adding the subscription $wpdb->query('ROLLBACK'); return new WP_Error('new-order-error', $e->getMessage()); } }
function invokeGetReportRequestList(MarketplaceWebService_Interface $service, $request) { global $wpdb, $woocommerce; try { $response = $service->getReportRequestList($request); if ($response->isSetGetReportRequestListResult()) { $getReportRequestListResult = $response->getGetReportRequestListResult(); $reportRequestInfoList = $getReportRequestListResult->getReportRequestInfoList(); print_r($reportRequestInfoList); foreach ($reportRequestInfoList as $reportRequestInfo) { if ($reportRequestInfo->isSetReportType() && $reportRequestInfo->getReportType() == '_GET_ORDERS_DATA_' && ($reportRequestInfo->isSetReportProcessingStatus() && $reportRequestInfo->getReportProcessingStatus() == '_DONE_')) { if ($reportRequestInfo->isSetReportRequestId()) { $ReportRequestId = $reportRequestInfo->getReportRequestId(); } if ($reportRequestInfo->isSetGeneratedReportId()) { $GeneratedReportId = $reportRequestInfo->getGeneratedReportId(); if ($GeneratedReportId == '' && $ReportRequestId != '') { $GeneratedReportId = $this->get_report_list_api($ReportRequestId); $data = $this->get_report_api($GeneratedReportId); } else { $data = $this->get_report_api($GeneratedReportId); } $xml = simplexml_load_string($data); // Check and dump MWS Report API Response $pwacheckkout = new Pwacheckout(); if ($pwacheckkout->get_option('mws_report_dump') == 'yes') { $dir = $pwacheckkout->get_option('mws_report_dump_url'); if (!file_exists($dir) && !is_dir($dir)) { mkdir($dir, 0777); } $filename = $dir . $GeneratedReportId . '_mws_report'; $myfile = fopen($filename, "w"); fwrite($myfile, $data); fclose($myfile); } foreach ($xml->Message as $orderdetail) { $AmazonOrderID = (string) $orderdetail->OrderReport->AmazonOrderID; $order_postmeta = $wpdb->get_results("select post_id from {$wpdb->postmeta} where meta_key = '_pwa_order_id' and meta_value = '{$AmazonOrderID}' "); if (empty($order_postmeta)) { $order = wc_create_order(); add_post_meta($order->id, '_pwa_order_id', $AmazonOrderID); $this->update_order_detail($order->id, $orderdetail); } else { $order_id = $order_postmeta[0]->post_id; $this->update_order_detail($order_id, $orderdetail); } } } } } $dateTime = new DateTime('now', new DateTimeZone('UTC')); $time = $dateTime->format(DATE_ISO8601); $wpdb->insert($wpdb->prefix . 'pwa_mws_report_cron', array('created_before' => $time)); } } catch (MarketplaceWebService_Exception $ex) { $message = 'MWS Report API : Caught Exception : ' . $ex->getMessage() . "\n"; $message .= "Response Status Code: " . $ex->getStatusCode() . "\n"; $message .= "Error Code: " . $ex->getErrorCode() . "\n"; $message .= "Error Type: " . $ex->getErrorType() . "\n"; $param['message'] = $message; $this->generate_log($param); } }
function hocwp_wc_insert_order($data) { $post_id = hocwp_get_value_by_key($data, 'post_id'); if (hocwp_id_number_valid($post_id)) { $post = get_post($post_id); if (is_a($post, 'WP_Post') && 'product' == $post->post_type) { $product = wc_get_product($post_id); $variable_product = new WC_Product_Variable($product); $variations = $variable_product->get_available_variations(); $variation_args = array(); $variation_id = null; foreach ($variations as $variation) { $variation_id = $variation['variation_id']; $variation_args['variation'] = $variation['attributes']; } $name = hocwp_get_value_by_key($data, 'name'); $phone = hocwp_get_value_by_key($data, 'phone'); $email = hocwp_get_value_by_key($data, 'email'); $address = hocwp_get_value_by_key($data, 'address'); $message = hocwp_get_value_by_key($data, 'message'); $name = hocwp_sanitize_first_and_last_name($name); $attributes = hocwp_get_value_by_key($data, 'attributes'); $addresses = array('first_name' => $name['first_name'], 'last_name' => $name['last_name'], 'email' => $email, 'phone' => $phone, 'address_1' => $address); $args = array('customer_note' => $message, 'created_via' => 'programmatically'); if (is_user_logged_in()) { $current = wp_get_current_user(); $args['customer_id'] = $current->ID; } $order = wc_create_order($args); $gateway = WC_Payment_Gateways::instance(); $gateways = $gateway->get_available_payment_gateways(); if (hocwp_array_has_value($gateways)) { $gateway = current($gateways); $order->set_payment_method($gateway); } $order->set_address($addresses); $order->set_address($addresses, 'shipping'); if (hocwp_array_has_value($attributes) && hocwp_id_number_valid($variation_id)) { foreach ($attributes as $attribute) { $attribute_name = hocwp_get_value_by_key($attribute, 'name'); $attribute_value = hocwp_get_value_by_key($attribute, 'value'); if (!empty($attribute_name) && !empty($attribute_value)) { if (isset($variation_args['variation'][$attribute_name])) { $variation_args['variation'][$attribute_name] = $attribute_value; } } } $variation_product = new WC_Product_Variation($variation_id); $order->add_product($variation_product, 1, $variation_args); } else { $order->add_product($product); } $order->record_product_sales(); $order->calculate_totals(); $order->payment_complete(); return $order; } } return false; }
public function create_order() { var_dump($_POST); DABBA_API_Catch_Request::get()->check_params(array('company', 'phone', 'address_1', 'address_2', 'corp', 'timeframe', 'food_delivery_accepted', 'line_items', 'method_id', 'method_title', 'paid', 'user_id')); //$user = wp_get_current_user(); $user = get_userdata($_POST['user_id']); $address = array('first_name' => $user->user_firstname, 'last_name' => $user->user_lastname, 'company' => $_POST['company'], 'email' => $user->user_email, 'phone' => $_POST['phone'], 'address_1' => $_POST['address_1'], 'address_2' => $_POST['address_2'], 'city' => 'Mexico City', 'state' => 'Distrito Federal', 'country' => 'MX', 'postcode' => $_POST['postcode']); $order = wc_create_order(); $order->set_address($address, 'billing'); $order->set_address($address, 'shipping'); //$order->add_coupon('Fresher','10','2'); // accepted param $couponcode, $couponamount,$coupon_tax update_post_meta($order->id, 'billing_corp', sanitize_text_field($_POST['corp'])); update_post_meta($order->id, 'billing_timeframe', sanitize_text_field($_POST['timeframe'])); update_post_meta($order->id, 'billing_food_delivery_accepted', $_POST['food_delivery_accepted']); update_post_meta($order->id, '_payment_method', $_POST['method_id']); update_post_meta($order->id, '_payment_method_title', $_POST['method_title']); if (isset($_POST['stripe_transaction_id']) && isset($_POST['stripe_customer_id'])) { // $fee = ( 3.6 * $amount + 3 ) * 0.16; // $net_revenue = $amount - $fee; update_post_meta($order->id, 'Stripe Fee', 0); update_post_meta($order->id, 'Net Revenue From Stripe', 0); update_post_meta($order->id, '_transaction_id', $_POST['stripe_transaction_id']); update_post_meta($order->id, '_stripe_customer_id', $_POST['stripe_customer_id']); update_post_meta($order->id, '_stripe_charge_id', $_POST['stripe_transaction_id']); } if (isset($_POST['paypal_address']) && isset($_POST['paypal_payment_type']) && isset($_POST['paypal_transaction_fee'])) { } update_post_meta($order->id, '_customer_user', $_POST['user_id']); $line_items_decode = json_decode(stripslashes($_POST['line_items'])); //$line_items_decode = json_decode( '[{"id" : "9579","quantity" : "1"},{"id" : "2933","quantity" :"1"}]'); foreach ($line_items_decode as $item) { $order->add_product(get_product($item->id), $item->quantity); } if (isset($_POST['line_coupons'])) { $line_coupons_decode = json_decode(stripslashes($_POST['line_coupons'])); foreach ($line_coupons_decode as $coupon) { $c = $order->add_coupon($coupon->code, $coupon->discount); } } if (isset($_POST['order_note'])) { $order->add_order_note($_POST['order_note']); } $order->calculate_totals(); $order->reduce_order_stock(); $order->update_status('processing'); $data = array($order); DABBA_API_Output::get()->output(true, 200, '', $data); }
/** * Creates a postsale order with postsale item * * @param $original_order_id * * @return WC_Order */ protected function create_postsale_order($original_order_id) { $original_order = wc_get_order($original_order_id); $postsale_product = $this->get_postsale_item(); $product_order_price = get_option('wc_settings_tab_luup_price') ? get_option('wc_settings_tab_luup_price') : $postsale_product->get_regular_price(); $order_qty = 1; $order_total = $product_order_price * $order_qty; $order_args = array('status' => '', 'customer_id' => get_current_user_id(), 'customer_note' => null, 'order_id' => 0, 'created_via' => '', 'parent' => 0); $order = wc_create_order($order_args); $order->add_product($postsale_product, $order_qty); $order->set_address($original_order->get_address('billing'), 'billing'); $order->set_address($original_order->get_address('shipping'), 'shipping'); $order->set_total($order_total); $order->add_order_note('Upsell order'); $order->set_payment_method($this); return $order; }
function wc1c_replace_document($document) { global $wpdb; if ($document['ХозОперация'] != "Заказ товара" || $document['Роль'] != "Продавец") { return; } $order = wc_get_order($document['Номер']); if (!$order) { $args = array('status' => 'on-hold', 'customer_note' => @$document['Комментарий']); $contragent_name = @$document['Контрагенты'][0]['Наименование']; if ($contragent_name == "Гость") { $user_id = 0; } elseif (strpos($contragent_name, ' ') !== false) { list($first_name, $last_name) = explode(' ', $contragent_name, 2); $result = $wpdb->get_var($wpdb->prepare("SELECT u1.user_id FROM {$wpdb->usermeta} u1 JOIN {$wpdb->usermeta} u2 ON u1.user_id = u2.user_id WHERE (u1.meta_key = 'billing_first_name' AND u1.meta_value = %s AND u2.meta_key = 'billing_last_name' AND u2.meta_value = %s) OR (u1.meta_key = 'shipping_first_name' AND u1.meta_value = %s AND u2.meta_key = 'shipping_last_name' AND u2.meta_value = %s)", $first_name, $last_name, $first_name, $last_name)); wc1c_check_wpdb_error(); if ($result) { $user_id = $result; } } if (isset($user_id)) { $args['customer_id'] = $user_id; } $order = wc_create_order($args); wc1c_check_wp_error($order); if (!isset($user_id)) { update_post_meta($order->id, 'wc1c_contragent', $contragent_name); } $args = array('ID' => $order->id); $date = @$document['Дата']; if ($date && !empty($document['Время'])) { $date .= " {$document['Время']}"; } $timestamp = strtotime($date); $args['post_date'] = date("Y-m-d H:i:s", $timestamp); $result = wp_update_post($args); wc1c_check_wp_error($result); if (!$result) { wc1c_error("Failed to update order post"); } update_post_meta($order->id, '_wc1c_guid', $document['Ид']); } else { $args = array('order_id' => $order->id, 'status' => 'on-hold'); $is_paid = false; foreach ($document['ЗначенияРеквизитов'] as $requisite) { if (!in_array($requisite['Наименование'], array("Дата оплаты по 1С", "Дата отгрузки по 1С"))) { continue; } $is_paid = true; break; } if ($is_paid) { $args['status'] = 'processing'; } $is_passed = false; foreach ($document['ЗначенияРеквизитов'] as $requisite) { if ($requisite['Наименование'] != 'Проведен' || $requisite['Значение'] != 'true') { continue; } $is_passed = true; break; } if ($is_passed) { $args['status'] = 'completed'; } $order = wc_update_order($args); wc1c_check_wp_error($order); } $is_deleted = false; foreach ($document['ЗначенияРеквизитов'] as $requisite) { if ($requisite['Наименование'] != 'ПометкаУдаления' || $requisite['Значение'] != 'true') { continue; } $is_deleted = true; break; } if ($is_deleted && $order->post_status != 'trash') { wp_trash_post($order->id); } elseif (!$is_deleted && $order->post_status == 'trash') { wp_untrash_post($order->id); } $post_meta = array(); if (isset($document['Валюта'])) { $post_meta['_order_currency'] = $document['Валюта']; } if (isset($document['Сумма'])) { $post_meta['_order_total'] = wc1c_parse_decimal($document['Сумма']); } $document_products = array(); $document_services = array(); foreach ($document['Товары'] as $i => $document_product) { foreach ($document_product['ЗначенияРеквизитов'] as $document_product_requisite) { if ($document_product_requisite['Наименование'] != 'ТипНоменклатуры') { continue; } if ($document_product_requisite['Значение'] == 'Услуга') { $document_services[] = $document_product; } else { $document_products[] = $document_product; } break; } } wc1c_replace_document_products($order, $document_products); $post_meta['_order_shipping'] = wc1c_replace_document_services($order, $document_services); $current_post_meta = get_post_meta($order->id); foreach ($current_post_meta as $meta_key => $meta_value) { $current_post_meta[$meta_key] = $meta_value[0]; } foreach ($post_meta as $meta_key => $meta_value) { $current_meta_value = @$current_post_meta[$meta_key]; if ($current_meta_value == $meta_value) { continue; } update_post_meta($order->id, $meta_key, $meta_value); } }
function doc_enrollment_submission($entry, $form) { global $woocommerce; $first_name = rgar($entry, '2'); $last_name = rgar($entry, '65'); $gender = rgar($entry, '4'); $dob = rgar($entry, '5'); $phone = rgar($entry, '6'); $phone2 = rgar($entry, '64'); $email = rgar($entry, '7'); $pc = rgar($entry, '8'); $reason_for_seeking_treatment = rgar($entry, '9'); $height = rgar($entry, '10'); $weight = rgar($entry, '11'); $blood_pressure = rgar($entry, '12'); $pulse = rgar($entry, '13'); $tobbacco = rgar($entry, '15'); $alcohol = rgar($entry, '16'); $caffeine = rgar($entry, '17'); $no_allergies = rgar($entry, '19.1'); $penicillin = rgar($entry, '19.2'); $sulfa_drug = rgar($entry, '19.3'); $nitrate = rgar($entry, '19.4'); $morphine = rgar($entry, '19.5'); $food = rgar($entry, '19.6'); $dye_allergies = rgar($entry, '19.7'); $seasonal = rgar($entry, '19.8'); $pet = rgar($entry, '19.9'); $codeine = rgar($entry, '19.11'); //console_log('allergies= ' . rgar( $entry, '19.1' )); $no_otc = rgar($entry, '21.1'); $aspirin = rgar($entry, '21.2'); $naproxen = rgar($entry, '21.3'); $acid_blockers = rgar($entry, '21.4'); $ketaprofen = rgar($entry, '21.5'); $decongestant = rgar($entry, '21.6'); $cough = rgar($entry, '21.7'); $laxatives = rgar($entry, '21.8'); $antihistamines = rgar($entry, '21.9'); $antacids = rgar($entry, '21.11'); $ibuprofen = rgar($entry, '21.12'); $acetaminophen = rgar($entry, '21.13'); $sleep_aids = rgar($entry, '21.14'); $diet_aids = rgar($entry, '21.15'); $antidiarrheal = rgar($entry, '21.16'); $pain_reliever = rgar($entry, '21.17'); //console_log($otc); $no_conditions = rgar($entry, '23.1'); $lung_issues = rgar($entry, '23.2'); $hbp = rgar($entry, '23.3'); $ulcers = rgar($entry, '23.4'); $migraines = rgar($entry, '23.5'); $depression = rgar($entry, '23.6'); $hormone_related = rgar($entry, '23.7'); $thyroid = rgar($entry, '23.8'); $eye_disease = rgar($entry, '23.9'); $epilepsy = rgar($entry, '23.11'); $blood_clotting = rgar($entry, '23.12'); $high_cholesterol = rgar($entry, '23.13'); //console_log($conditions); $medications = rgar($entry, '25'); $heart_disease = rgar($entry, '27'); //console_log($heart_disease); $heart_disease_relation = rgar($entry, '28'); $high_blood_pressure = rgar($entry, '29'); $high_blood_pressure_relation = rgar($entry, '30'); $diabetes = rgar($entry, '31'); $diabetes_relation = rgar($entry, '32'); $arthritis = rgar($entry, '33'); $arthritis_relation = rgar($entry, '34'); $skin_disorders = rgar($entry, '35'); $skin_disorders_relation = rgar($entry, '36'); $cancer = rgar($entry, '37'); $cancer_relation = rgar($entry, '38'); $pregnant = rgar($entry, '40'); $last_cycle = rgar($entry, '41'); $abnormal_cycle = rgar($entry, '42'); $breast_cancer = rgar($entry, '43'); $order_user = get_user_by('email', $email); console_log($order_user); $user_id = $order_user->ID; $items = $woocommerce->cart->get_cart(); //console_log($items); $order = wc_create_order(array('customer_id' => $user_id)); foreach ($items as $item => $values) { $product_ID = $values['product_id']; $order->add_product(get_product($values['product_id']), $values['quantity']); //(get_product with id and next is for quantity) } $title = get_the_title(); $order_id = $title; update_post_meta($order_id, '_patient-first-name', sanitize_text_field($first_name)); update_post_meta($order_id, '_patient-last-name', sanitize_text_field($last_name)); update_post_meta($order_id, '_gender', sanitize_text_field($gender)); update_post_meta($order_id, '_dob', sanitize_text_field($dob)); update_post_meta($order_id, '_primary-phone-number', sanitize_text_field($phone)); update_post_meta($order_id, '_addtional-phone-number', sanitize_text_field($phone2)); update_post_meta($order_id, '_email-address', sanitize_text_field($email)); update_post_meta($order_id, '_primary-physician', sanitize_text_field($pc)); update_post_meta($order_id, '_reason-for-seeking-treatment', sanitize_text_field($reason_for_seeking_treatment)); update_post_meta($order_id, '_height', sanitize_text_field($height)); update_post_meta($order_id, '_weight', sanitize_text_field($weight)); update_post_meta($order_id, '_bp', sanitize_text_field($blood_pressure)); update_post_meta($order_id, '_pulse', sanitize_text_field($pulse)); update_post_meta($order_id, '_tobbacco', sanitize_text_field($tobbacco)); update_post_meta($order_id, '_alcohol', sanitize_text_field($alcohol)); update_post_meta($order_id, '_caffeine', sanitize_text_field($caffeine)); update_post_meta($order_id, '_no-allergies', sanitize_text_field($no_allergies)); update_post_meta($order_id, '_no_otc', sanitize_text_field($no_otc)); update_post_meta($order_id, '_aspirin', sanitize_text_field($aspirin)); update_post_meta($order_id, '_naproxen', sanitize_text_field($naproxen)); update_post_meta($order_id, '_acid-blockers', sanitize_text_field($acid_blockers)); update_post_meta($order_id, '_ketaprofen', sanitize_text_field($ketaprofen)); update_post_meta($order_id, '_decongestant', sanitize_text_field($decongestant)); update_post_meta($order_id, '_cough-suppressant', sanitize_text_field($cough)); update_post_meta($order_id, '_laxatives', sanitize_text_field($laxatives)); update_post_meta($order_id, '_antihistamines', sanitize_text_field($antihistamines)); update_post_meta($order_id, '_antacids', sanitize_text_field($antacids)); update_post_meta($order_id, '_ibuprofen', sanitize_text_field($ibuprofen)); update_post_meta($order_id, '_acetaminophen', sanitize_text_field($acetaminophen)); update_post_meta($order_id, '_sleep-aids', sanitize_text_field($sleep_aids)); update_post_meta($order_id, '_diet-aids', sanitize_text_field($diet_aids)); update_post_meta($order_id, '_antidiarrheal', sanitize_text_field($antidiarrheal)); update_post_meta($order_id, '_pain-reliever', sanitize_text_field($pain_reliever)); update_post_meta($order_id, '_no-conditions', sanitize_text_field($no_conditions)); update_post_meta($order_id, '_lung-issues', sanitize_text_field($lung_issues)); update_post_meta($order_id, '_high-blood-pressure-condition', sanitize_text_field($hbp)); update_post_meta($order_id, '_ulcers', sanitize_text_field($ulcers)); update_post_meta($order_id, '_migraines', sanitize_text_field($migraines)); update_post_meta($order_id, '_depression', sanitize_text_field($depression)); update_post_meta($order_id, '_hormone-related', sanitize_text_field($hormone_related)); update_post_meta($order_id, '_thyroid', sanitize_text_field($thyroid)); update_post_meta($order_id, '_eye-disease', sanitize_text_field($eye_disease)); update_post_meta($order_id, '_epilepsy', sanitize_text_field($epilepsy)); update_post_meta($order_id, '_blood-clotting-issue', sanitize_text_field($blood_clotting)); update_post_meta($order_id, '_high-cholesterol', sanitize_text_field($high_cholesterol)); update_post_meta($order_id, '_penicillin', sanitize_text_field($penicillin)); update_post_meta($order_id, '_sulfa-drug', sanitize_text_field($sulfa_drug)); update_post_meta($order_id, '_nitrate', sanitize_text_field($nitrate)); update_post_meta($order_id, '_morphine', sanitize_text_field($morphine)); update_post_meta($order_id, '_food', sanitize_text_field($food)); update_post_meta($order_id, '_dye-allergies', sanitize_text_field($dye_allergies)); update_post_meta($order_id, '_seasonal', sanitize_text_field($seasonal)); update_post_meta($order_id, '_pet', sanitize_text_field($pet)); update_post_meta($order_id, '_codeine', sanitize_text_field($codeine)); update_post_meta($order_id, '_medication', sanitize_text_field($medications)); update_post_meta($order_id, '_heart-disease', sanitize_text_field($heart_disease)); update_post_meta($order_id, '_heart-disease-relationship', sanitize_text_field($heart_disease_relation)); update_post_meta($order_id, '_high-blood-pressure', sanitize_text_field($high_blood_pressure)); update_post_meta($order_id, '_high-blood-pressure-relationship', sanitize_text_field($high_blood_pressure_relation)); update_post_meta($order_id, '_diabetes', sanitize_text_field($diabetes)); update_post_meta($order_id, '_diabetes-relationship', sanitize_text_field($diabetes_relation)); update_post_meta($order_id, '_arthritis', sanitize_text_field($arthritis)); update_post_meta($order_id, '_arthritis-relationship', sanitize_text_field($arthritis_relation)); update_post_meta($order_id, '_skin-disorders', sanitize_text_field($skin_disorders)); update_post_meta($order_id, '_skin-disorders-relationship', sanitize_text_field($skin_disorders_relation)); update_post_meta($order_id, '_cancer', sanitize_text_field($cancer)); update_post_meta($order_id, '_cancer-relationship', sanitize_text_field($cancer_relation)); update_post_meta($order_id, '_are-you-currently-pregnant', sanitize_text_field($pregnant)); update_post_meta($order_id, '_last-menstrual-cycle', sanitize_text_field($last_cycle)); update_post_meta($order_id, '_abnormal-period-cycle', sanitize_text_field($abnormal_cycle)); update_post_meta($order_id, '_breast_cancer', sanitize_text_field($breast_cancer)); // Updating User Meta update_user_meta($user_id, 'first_name', sanitize_text_field($first_name)); update_user_meta($user_id, 'last_name', sanitize_text_field($last_name)); update_user_meta($user_id, '_patient-first-name', sanitize_text_field($first_name)); update_user_meta($user_id, '_patient-last-name', sanitize_text_field($last_name)); update_user_meta($user_id, '_gender', sanitize_text_field($gender)); update_user_meta($user_id, '_dob', sanitize_text_field($dob)); update_user_meta($user_id, '_primary-phone-number', sanitize_text_field($phone)); update_user_meta($user_id, '_addtional-phone-number', sanitize_text_field($phone2)); update_user_meta($user_id, '_email-address', sanitize_text_field($email)); update_user_meta($user_id, '_primary-physician', sanitize_text_field($pc)); update_user_meta($user_id, '_reason-for-seeking-treatment', sanitize_text_field($reason_for_seeking_treatment)); update_user_meta($user_id, '_height', sanitize_text_field($height)); update_user_meta($user_id, '_weight', sanitize_text_field($weight)); update_user_meta($user_id, '_bp', sanitize_text_field($blood_pressure)); update_user_meta($user_id, '_pulse', sanitize_text_field($pulse)); update_user_meta($user_id, '_tobbacco', sanitize_text_field($tobbacco)); update_user_meta($user_id, '_alcohol', sanitize_text_field($alcohol)); update_user_meta($user_id, '_caffeine', sanitize_text_field($caffeine)); update_user_meta($user_id, '_no-allergies', sanitize_text_field($no_allergies)); update_user_meta($user_id, '_no_otc', sanitize_text_field($no_otc)); update_user_meta($user_id, '_aspirin', sanitize_text_field($aspirin)); update_user_meta($user_id, '_naproxen', sanitize_text_field($naproxen)); update_user_meta($user_id, '_acid-blockers', sanitize_text_field($acid_blockers)); update_user_meta($user_id, '_ketaprofen', sanitize_text_field($ketaprofen)); update_user_meta($user_id, '_decongestant', sanitize_text_field($decongestant)); update_user_meta($user_id, '_cough-suppressant', sanitize_text_field($cough)); update_user_meta($user_id, '_laxatives', sanitize_text_field($laxatives)); update_user_meta($user_id, '_antihistamines', sanitize_text_field($antihistamines)); update_user_meta($user_id, '_antacids', sanitize_text_field($antacids)); update_user_meta($user_id, '_ibuprofen', sanitize_text_field($ibuprofen)); update_user_meta($user_id, '_acetaminophen', sanitize_text_field($acetaminophen)); update_user_meta($user_id, '_sleep-aids', sanitize_text_field($sleep_aids)); update_user_meta($user_id, '_diet-aids', sanitize_text_field($diet_aids)); update_user_meta($user_id, '_antidiarrheal', sanitize_text_field($antidiarrheal)); update_user_meta($user_id, '_pain-reliever', sanitize_text_field($pain_reliever)); update_user_meta($user_id, '_no-conditions', sanitize_text_field($no_conditions)); update_user_meta($user_id, '_lung-issues', sanitize_text_field($lung_issues)); update_user_meta($user_id, '_high-blood-pressure-condition', sanitize_text_field($hbp)); update_user_meta($user_id, '_ulcers', sanitize_text_field($ulcers)); update_user_meta($user_id, '_migraines', sanitize_text_field($migraines)); update_user_meta($user_id, '_depression', sanitize_text_field($depression)); update_user_meta($user_id, '_hormone-related', sanitize_text_field($hormone_related)); update_user_meta($user_id, '_thyroid', sanitize_text_field($thyroid)); update_user_meta($user_id, '_eye-disease', sanitize_text_field($eye_disease)); update_user_meta($user_id, '_epilepsy', sanitize_text_field($epilepsy)); update_user_meta($user_id, '_blood-clotting-issue', sanitize_text_field($blood_clotting)); update_user_meta($user_id, '_high-cholesterol', sanitize_text_field($high_cholesterol)); update_user_meta($user_id, '_penicillin', sanitize_text_field($penicillin)); update_user_meta($user_id, '_sulfa-drug', sanitize_text_field($sulfa_drug)); update_user_meta($user_id, '_nitrate', sanitize_text_field($nitrate)); update_user_meta($user_id, '_morphine', sanitize_text_field($morphine)); update_user_meta($user_id, '_food', sanitize_text_field($food)); update_user_meta($user_id, '_dye-allergies', sanitize_text_field($dye_allergies)); update_user_meta($user_id, '_seasonal', sanitize_text_field($seasonal)); update_user_meta($user_id, '_pet', sanitize_text_field($pet)); update_user_meta($user_id, '_codeine', sanitize_text_field($codeine)); update_user_meta($user_id, '_medication', sanitize_text_field($medications)); update_user_meta($user_id, '_heart-disease', sanitize_text_field($heart_disease)); update_user_meta($user_id, '_heart-disease-relationship', sanitize_text_field($heart_disease_relation)); update_user_meta($user_id, '_high-blood-pressure', sanitize_text_field($high_blood_pressure)); update_user_meta($user_id, '_high-blood-pressure-relationship', sanitize_text_field($high_blood_pressure_relation)); update_user_meta($user_id, '_diabetes', sanitize_text_field($diabetes)); update_user_meta($user_id, '_diabetes-relationship', sanitize_text_field($diabetes_relation)); update_user_meta($user_id, '_arthritis', sanitize_text_field($arthritis)); update_user_meta($user_id, '_arthritis-relationship', sanitize_text_field($arthritis_relation)); update_user_meta($user_id, '_skin-disorders', sanitize_text_field($skin_disorders)); update_user_meta($user_id, '_skin-disorders-relationship', sanitize_text_field($skin_disorders_relation)); update_user_meta($user_id, '_cancer', sanitize_text_field($cancer)); update_user_meta($user_id, '_cancer-relationship', sanitize_text_field($cancer_relation)); update_user_meta($user_id, '_are-you-currently-pregnant', sanitize_text_field($pregnant)); update_user_meta($user_id, '_last-menstrual-cycle', sanitize_text_field($last_cycle)); update_user_meta($user_id, '_abnormal-period-cycle', sanitize_text_field($abnormal_cycle)); update_user_meta($user_id, '_breast_cancer', sanitize_text_field($breast_cancer)); }
/** * create_order function. * @access public * @throws Exception * @return int|WP_ERROR */ public function create_order() { global $wpdb; // Give plugins the opportunity to create an order themselves if ($order_id = apply_filters('woocommerce_create_order', null, $this)) { return $order_id; } try { // Start transaction if available $wpdb->query('START TRANSACTION'); $order_data = array('status' => apply_filters('woocommerce_default_order_status', 'pending'), 'customer_id' => $this->customer_id, 'customer_note' => isset($this->posted['order_comments']) ? $this->posted['order_comments'] : ''); // Insert or update the post data $order_id = absint(WC()->session->order_awaiting_payment); // Resume the unpaid order if its pending if ($order_id > 0 && ($order = wc_get_order($order_id)) && $order->has_status(array('pending', 'failed'))) { $order_data['order_id'] = $order_id; $order = wc_update_order($order_data); if (is_wp_error($order)) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } else { $order->remove_order_items(); do_action('woocommerce_resume_order', $order_id); } } else { $order = wc_create_order($order_data); if (is_wp_error($order)) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } else { $order_id = $order->id; do_action('woocommerce_new_order', $order_id); } } // Store the line items to the new/resumed order foreach (WC()->cart->get_cart() as $cart_item_key => $values) { $item_id = $order->add_product($values['data'], $values['quantity'], array('variation' => $values['variation'], 'totals' => array('subtotal' => $values['line_subtotal'], 'subtotal_tax' => $values['line_subtotal_tax'], 'total' => $values['line_total'], 'tax' => $values['line_tax'], 'tax_data' => $values['line_tax_data']))); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allow plugins to add order item meta do_action('woocommerce_add_order_item_meta', $item_id, $values, $cart_item_key); } // Store fees foreach (WC()->cart->get_fees() as $fee_key => $fee) { $item_id = $order->add_fee($fee); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allow plugins to add order item meta to fees do_action('woocommerce_add_order_fee_meta', $order_id, $item_id, $fee, $fee_key); } // Store shipping for all packages foreach (WC()->shipping->get_packages() as $package_key => $package) { if (isset($package['rates'][$this->shipping_methods[$package_key]])) { $item_id = $order->add_shipping($package['rates'][$this->shipping_methods[$package_key]]); if (!$item_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } // Allows plugins to add order item meta to shipping do_action('woocommerce_add_shipping_order_item', $order_id, $item_id, $package_key); } } // Store tax rows foreach (array_keys(WC()->cart->taxes + WC()->cart->shipping_taxes) as $tax_rate_id) { if (!$order->add_tax($tax_rate_id, WC()->cart->get_tax_amount($tax_rate_id), WC()->cart->get_shipping_tax_amount($tax_rate_id)) && 'zero-rated' !== $tax_rate_id) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } } // Store coupons foreach (WC()->cart->get_coupons() as $code => $coupon) { if (!$order->add_coupon($code, WC()->cart->get_coupon_discount_amount($code))) { throw new Exception(__('Error: Unable to create order. Please try again.', 'woocommerce')); } } // Billing address $billing_address = array(); if ($this->checkout_fields['billing']) { foreach (array_keys($this->checkout_fields['billing']) as $field) { $field_name = str_replace('billing_', '', $field); $billing_address[$field_name] = $this->get_posted_address_data($field_name); } } // Shipping address. $shipping_address = array(); if ($this->checkout_fields['shipping']) { foreach (array_keys($this->checkout_fields['shipping']) as $field) { $field_name = str_replace('shipping_', '', $field); $shipping_address[$field_name] = $this->get_posted_address_data($field_name, 'shipping'); } } $order->set_address($billing_address, 'billing'); $order->set_address($shipping_address, 'shipping'); $order->set_payment_method($this->payment_method); $order->set_total(WC()->cart->shipping_total, 'shipping'); $order->set_total(WC()->cart->get_order_discount_total(), 'order_discount'); $order->set_total(WC()->cart->get_cart_discount_total(), 'cart_discount'); $order->set_total(WC()->cart->tax_total, 'tax'); $order->set_total(WC()->cart->shipping_tax_total, 'shipping_tax'); $order->set_total(WC()->cart->total); // Update user meta if ($this->customer_id) { if (apply_filters('woocommerce_checkout_update_customer_data', true, $this)) { foreach ($billing_address as $key => $value) { update_user_meta($this->customer_id, 'billing_' . $key, $value); } foreach ($shipping_address as $key => $value) { update_user_meta($this->customer_id, 'shipping_' . $key, $value); } } do_action('woocommerce_checkout_update_user_meta', $this->customer_id, $this->posted); } // Let plugins add meta do_action('woocommerce_checkout_update_order_meta', $order_id, $this->posted); // If we got here, the order was created without problems! $wpdb->query('COMMIT'); } catch (Exception $e) { // There was an error adding order data! $wpdb->query('ROLLBACK'); return new WP_Error('checkout-error', $e->getMessage()); } return $order_id; }
function dvin_qlist_create_order($data) { global $dvin_qlist_products, $dvin_wcql_settings; if (class_exists('Product_Addon_Cart')) { $addon_cart_obj = new Product_Addon_Cart(); //create object for addons } $address = array(); //stores the billing and shipping info for creating order $billing_address = dvin_wcql_map_address($data, ''); $shipping_address = dvin_wcql_map_address($data, 'ship_'); $order = wc_create_order(); foreach ($dvin_qlist_products as $key => $arr) { if (!isset($arr['variation_id']) && !isset($arr['product_id'])) { continue; } //simple or variable if (isset($arr['variation_id']) && !empty($arr['variation_id'])) { $product_obj = wc_get_product($arr['variation_id']); if (isset($arr['price'])) { $product_obj->set_price($arr['price']); } $item_id = $order->add_product($product_obj, $arr['quantity'], array('variation' => unserialize($arr['variation_data']))); } else { $product_obj = wc_get_product($arr['product_id']); $item_id = $order->add_product($product_obj, $arr['quantity']); //(get_product with id and next is for quantity) } // Allow plugins to add order item meta if (isset($addon_cart_obj) && $addon_cart_obj instanceof Product_Addon_Cart) { //to avoid/prevent notices $arr['data'] = array(); $addon_cart_obj->order_item_meta($item_id, $arr); } } //end of foreach $order->set_address($billing_address, 'billing'); $order->set_address($shipping_address, 'shipping'); $order->calculate_totals(); //update the customer data update_post_meta($order->id, '_customer_user', absint(get_current_user_id())); //update the order status to pending $order = new WC_Order($order->id); $order->update_status('pending'); return $order->id; }
/** * Update an order. Uses wc_create_order. * @param array $args * @return string | WC_Order */ function wc_update_order($args) { if (!$args['order_id']) { return new WP_Error(__('Invalid order ID', 'woocommerce')); } return wc_create_order($args); }
/** * Create base WC Order object. * * @param array $data * @return WC_Order */ protected function create_base_order($data) { return wc_create_order($data); }
public function pwa_order() { global $wp, $wpdb; global $order, $pwa_order_status, $pwa_order_id; global $woocommerce; $pwa_order_id = @$wp->query_vars['amznPmtsOrderIds']; $pwa_order_status = @$wp->query_vars['amznPmtsPaymentStatus']; if (isset($pwa_order_id) && $pwa_order_id != '') { $order_postmeta = $wpdb->get_results("select post_id from {$wpdb->postmeta} where meta_key = '_pwa_order_id' and meta_value = '{$pwa_order_id}' "); if (empty($order_postmeta)) { $order = wc_create_order(); $order_id = $order->id; add_post_meta($order->id, '_pwa_order_id', $pwa_order_id); add_post_meta($order->id, '_payment_method', 'pwa'); add_post_meta($order->id, '_payment_method_title', 'Pay with Amazon'); $woocommerce->cart->empty_cart(); } else { $order_id = $order_postmeta[0]->post_id; $order = new WC_Order($order_id); $woocommerce->cart->empty_cart(); } //$url = 'www.inlifehealthcare.com/checkout?orderType=pwa&orderId='.$order_id.'&amznPmtsOrderIds='.$pwa_order_id.'&amznPmtsPaymentStatus='.$pwa_order_status.''; //echo '<script>window.location.href = "'.$url.'" </script>'; //header('Location:'.$url); include PWA_TEMPLATE_DIR . 'pwa_order.php'; exit; } else { include PWA_TEMPLATE_DIR . 'pwa_order_error.php'; exit; } }
function create_order() { global $woocommerce, $wp; // Security check check_ajax_referer('ajax_post_validation', 'security'); //Getting Product ID $id = $_POST['prod_id']; // create order $address = array('first_name' => 'Iskandariya', 'last_name' => 'Solutions', 'company' => 'Iskandariya.Solutions', 'phone' => '+91-9999999999', 'address_1' => 'Chandigarh', 'address_2' => 'Mohali,Punjab', 'city' => 'Chandigarh', 'state' => 'PB', 'postcode' => '160001', 'country' => 'IN'); $order_data = array('customer_id' => get_current_user_id()); $order = wc_create_order($order_data); $order->add_product(get_product($id), 1); //(get_product with id and next is for quantity) $order->set_address($address, 'billing'); $order->set_address($address, 'shipping'); $order->calculate_totals(); wp_die(); }
/** * Create a scheduled order * @param string $payment_date * @param int $original_order_id */ public static function create_order($payment_date, $original_order_id, $payment_number, $item, $status = '') { $original_order = wc_get_order($original_order_id); $new_order = wc_create_order(array('status' => $status, 'customer_id' => $original_order->get_user_id(), 'customer_note' => $original_order->customer_note, 'created_via' => 'wc_deposits')); if (is_wp_error($new_order)) { $original_order->add_order_note(sprintf(__('Error: Unable to create follow up payment (%s)', 'woocommerce-deposits'), $scheduled_order->get_error_message())); } else { $new_order->set_address(array('first_name' => $original_order->billing_first_name, 'last_name' => $original_order->billing_last_name, 'company' => $original_order->billing_company, 'address_1' => $original_order->billing_address_1, 'address_2' => $original_order->billing_address_2, 'city' => $original_order->billing_city, 'state' => $original_order->billing_state, 'postcode' => $original_order->billing_postcode, 'country' => $original_order->billing_country, 'email' => $original_order->billing_email, 'phone' => $original_order->billing_phone), 'billing'); $new_order->set_address(array('first_name' => $original_order->shipping_first_name, 'last_name' => $original_order->shipping_last_name, 'company' => $original_order->shipping_company, 'address_1' => $original_order->shipping_address_1, 'address_2' => $original_order->shipping_address_2, 'city' => $original_order->shipping_city, 'state' => $original_order->shipping_state, 'postcode' => $original_order->shipping_postcode, 'country' => $original_order->shipping_country), 'shipping'); // Handle items $item_id = $new_order->add_product($item['product'], $item['qty'], array('totals' => array('subtotal' => $item['amount'], 'total' => $item['amount'], 'subtotal_tax' => 0, 'tax' => 0))); woocommerce_add_order_item_meta($item_id, '_original_order_id', $original_order_id); wc_update_order_item($item_id, array('order_item_name' => sprintf(__('Payment #%d for %s'), $payment_number, $item['product']->get_title()))); $new_order->calculate_totals(wc_tax_enabled()); // Set future date and parent $new_order_post = array('ID' => $new_order->id, 'post_date' => date('Y-m-d H:i:s', $payment_date), 'post_parent' => $original_order_id); wp_update_post($new_order_post); do_action('woocommerce_deposits_create_order', $new_order->id); return $new_order->id; } }
/** * Create an order. Error codes: * 520 - Cannot insert order into the database. * 521 - Cannot get order after creation. * 522 - Cannot update order. * 525 - Cannot create line item. * 526 - Cannot create fee item. * 527 - Cannot create shipping item. * 528 - Cannot create tax item. * 529 - Cannot create coupon item. * @access public * @throws Exception * @return int|WP_ERROR */ public function create_order() { global $wpdb; // Give plugins the opportunity to create an order themselves if ($order_id = apply_filters('woocommerce_create_order', null, $this)) { return $order_id; } try { // Start transaction if available wc_transaction_query('start'); $order_data = array('status' => apply_filters('woocommerce_default_order_status', 'pending'), 'customer_id' => $this->customer_id, 'customer_note' => isset($this->posted['order_comments']) ? $this->posted['order_comments'] : '', 'cart_hash' => md5(json_encode(WC()->cart->get_cart_for_session()) . WC()->cart->total), 'created_via' => 'checkout'); // Insert or update the post data $order_id = absint(WC()->session->order_awaiting_payment); /** * If there is an order pending payment, we can resume it here so * long as it has not changed. If the order has changed, i.e. * different items or cost, create a new order. We use a hash to * detect changes which is based on cart items + order total. */ if ($order_id && $order_data['cart_hash'] === get_post_meta($order_id, '_cart_hash', true) && ($order = wc_get_order($order_id)) && $order->has_status(array('pending', 'failed'))) { $order_data['order_id'] = $order_id; $order = wc_update_order($order_data); if (is_wp_error($order)) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 522)); } else { $order->remove_order_items(); do_action('woocommerce_resume_order', $order_id); } } else { $order = wc_create_order($order_data); if (is_wp_error($order)) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 520)); } elseif (false === $order) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 521)); } else { $order_id = $order->id; do_action('woocommerce_new_order', $order_id); } } // Store the line items to the new/resumed order foreach (WC()->cart->get_cart() as $cart_item_key => $values) { $item_id = $order->add_product($values['data'], $values['quantity'], array('variation' => $values['variation'], 'totals' => array('subtotal' => $values['line_subtotal'], 'subtotal_tax' => $values['line_subtotal_tax'], 'total' => $values['line_total'], 'tax' => $values['line_tax'], 'tax_data' => $values['line_tax_data']))); if (!$item_id) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 525)); } // Allow plugins to add order item meta do_action('woocommerce_add_order_item_meta', $item_id, $values, $cart_item_key); } // Store fees foreach (WC()->cart->get_fees() as $fee_key => $fee) { $item_id = $order->add_fee($fee); if (!$item_id) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 526)); } // Allow plugins to add order item meta to fees do_action('woocommerce_add_order_fee_meta', $order_id, $item_id, $fee, $fee_key); } // Store shipping for all packages foreach (WC()->shipping->get_packages() as $package_key => $package) { if (isset($package['rates'][$this->shipping_methods[$package_key]])) { $item_id = $order->add_shipping($package['rates'][$this->shipping_methods[$package_key]]); if (!$item_id) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 527)); } // Allows plugins to add order item meta to shipping do_action('woocommerce_add_shipping_order_item', $order_id, $item_id, $package_key); } } // Store tax rows foreach (array_keys(WC()->cart->taxes + WC()->cart->shipping_taxes) as $tax_rate_id) { if ($tax_rate_id && !$order->add_tax($tax_rate_id, WC()->cart->get_tax_amount($tax_rate_id), WC()->cart->get_shipping_tax_amount($tax_rate_id)) && apply_filters('woocommerce_cart_remove_taxes_zero_rate_id', 'zero-rated') !== $tax_rate_id) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 528)); } } // Store coupons foreach (WC()->cart->get_coupons() as $code => $coupon) { if (!$order->add_coupon($code, WC()->cart->get_coupon_discount_amount($code), WC()->cart->get_coupon_discount_tax_amount($code))) { throw new Exception(sprintf(__('Error %d: Unable to create order. Please try again.', 'woocommerce'), 529)); } } // Billing address $billing_address = array(); if ($this->checkout_fields['billing']) { foreach (array_keys($this->checkout_fields['billing']) as $field) { $field_name = str_replace('billing_', '', $field); $billing_address[$field_name] = $this->get_posted_address_data($field_name); } } // Shipping address. $shipping_address = array(); if ($this->checkout_fields['shipping']) { foreach (array_keys($this->checkout_fields['shipping']) as $field) { $field_name = str_replace('shipping_', '', $field); $shipping_address[$field_name] = $this->get_posted_address_data($field_name, 'shipping'); } } $order->set_address($billing_address, 'billing'); $order->set_address($shipping_address, 'shipping'); $order->set_payment_method($this->payment_method); $order->set_total(WC()->cart->shipping_total, 'shipping'); $order->set_total(WC()->cart->get_cart_discount_total(), 'cart_discount'); $order->set_total(WC()->cart->get_cart_discount_tax_total(), 'cart_discount_tax'); $order->set_total(WC()->cart->tax_total, 'tax'); $order->set_total(WC()->cart->shipping_tax_total, 'shipping_tax'); $order->set_total(WC()->cart->total); // Update user meta if ($this->customer_id) { if (apply_filters('woocommerce_checkout_update_customer_data', true, $this)) { foreach ($billing_address as $key => $value) { update_user_meta($this->customer_id, 'billing_' . $key, $value); } if (WC()->cart->needs_shipping()) { foreach ($shipping_address as $key => $value) { update_user_meta($this->customer_id, 'shipping_' . $key, $value); } } } do_action('woocommerce_checkout_update_user_meta', $this->customer_id, $this->posted); } // Let plugins add meta do_action('woocommerce_checkout_update_order_meta', $order_id, $this->posted); // If we got here, the order was created without problems! wc_transaction_query('commit'); } catch (Exception $e) { // There was an error adding order data! wc_transaction_query('rollback'); return new WP_Error('checkout-error', $e->getMessage()); } return $order_id; }
/** * Creates new WC_Order. * * @since 2.5.0 * @param $args array * @return WC_Order */ protected function create_base_order($args) { return wc_create_order($args); }
\Ebanx\Config::set(array('integrationKey' => $ebanx->merchant_key, 'testMode' => $ebanx->test_mode, 'directMode' => true)); $data = date('d'); try { $conn = new PDO("mysql:host={$servername};dbname={$database}", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // echo "Connected successfully 2\n"; $sql = "SELECT * FROM ebanx_token WHERE DATE_FORMAT(data,'%d') = {$data}"; //$sql = "SELECT * FROM ebanx_token"; $result = $conn->query($sql); //$result = $result->fetch (PDO::FETCH_ASSOC); while ($data = $result->fetch(PDO::FETCH_ASSOC)) { $args = array('status' => '', 'customer_id' => $data['customer_id'], 'customer_note' => '', 'created_via' => 'EBANX Recurring cron', 'order_id' => 0); $order = new WC_Order($data['order_id']); $streetNumber = isset($order->billing_number) ? $order->billing_number : '1'; $newOrder = wc_create_order($args); update_post_meta($newOrder->id, '_order_total', $order->order_total); $params = array('mode' => 'full', 'operation' => 'request', 'payment' => array('merchant_payment_code' => $newOrder->id, 'order_number' => $newOrder->id, 'amount_total' => $order->order_total, 'currency_code' => $data['currency_code'], 'name' => $order->billing_first_name . ' ' . $order->billing_last_name, 'email' => $order->billing_email, 'birth_date' => $data['birth_date'], 'address' => $order->billing_address_1, 'street_number' => $streetNumber, 'city' => $order->billing_city, 'state' => $order->billing_state, 'zipcode' => $order->billing_postcode, 'country' => $order->billing_country, 'phone_number' => $order->billing_phone, 'payment_type_code' => $data['payment_type_code'], 'document' => $order->billing_cpf, 'creditcard' => array('token' => $data['token']))); $response = \Ebanx\Ebanx::doRequest($params); if (isset($response->status) && $response->status == 'SUCCESS') { if ($response->payment->status == 'CA') { $newOrder->add_order_note('Payment failed.'); $newOrder->cancel_order(); echo "OK: Payment {$response->hash} was cancelled via IPN\n"; } if ($response->payment->status == 'CO') { $newOrder->add_order_note('Payment confirmed.'); $newOrder->update_status('completed'); echo "OK: Payment {$response->hash} was confirmed via IPN\n"; } }
/** * Create order. * * @param WP_REST_Request $request Full details about the request. * @return int|WP_Error */ protected function create_order($request) { wc_transaction_query('start'); try { // Make sure customer exists. if (0 !== $request['customer_id'] && false === get_user_by('id', $request['customer_id'])) { throw new WC_REST_Exception('woocommerce_rest_invalid_customer_id', __('Customer ID is invalid.', 'woocommerce'), 400); } $order = wc_create_order(array('status' => $request['status'], 'customer_id' => $request['customer_id'], 'customer_note' => $request['customer_note'], 'created_via' => 'rest-api')); if (is_wp_error($order)) { throw new WC_REST_Exception('woocommerce_rest_cannot_create_order', sprintf(__('Cannot create order: %s.', 'woocommerce'), implode(', ', $order->get_error_messages())), 400); } // Set addresses. if (is_array($request['billing'])) { $this->update_address($order, $request['billing'], 'billing'); } if (is_array($request['shipping'])) { $this->update_address($order, $request['shipping'], 'shipping'); } // Set currency. update_post_meta($order->id, '_order_currency', $request['currency']); // Set lines. $lines = array('line_item' => 'line_items', 'shipping' => 'shipping_lines', 'fee' => 'fee_lines', 'coupon' => 'coupon_lines'); foreach ($lines as $line_type => $line) { if (is_array($request[$line])) { foreach ($request[$line] as $item) { $set_item = 'set_' . $line_type; $new_item = $this->{$set_item}($order, $item, 'create'); } } } // Calculate totals and set them. $order->calculate_totals(); // Set payment method. if (!empty($request['payment_method'])) { update_post_meta($order->id, '_payment_method', $request['payment_method']); } if (!empty($request['payment_method_title'])) { update_post_meta($order->id, '_payment_method_title', $request['payment_method']); } if (true === $request['set_paid']) { $order->payment_complete($request['transaction_id']); } // Set meta data. if (!empty($request['meta_data']) && is_array($request['meta_data'])) { $this->update_meta_data($order->id, $request['meta_data']); } wc_transaction_query('commit'); return $order->id; } catch (WC_REST_Exception $e) { wc_transaction_query('rollback'); return new WP_Error($e->getErrorCode(), $e->getMessage(), array('status' => $e->getCode())); } }
public static function createSimpleOrder($total = 40) { $product = self::createSimpleProduct(); self::createSimpleShippingFlatRate(); $order_data = array('status' => 'pending', 'customer_id' => 1, 'customer_note' => '', 'total' => ''); // Required, else wc_create_order throws an exception $_SERVER['REMOTE_ADDR'] = '127.0.0.1'; $order = wc_create_order($order_data); // Add order products $order->add_product($product, 4); // Set billing address $shipping_address = array('country' => 'US', 'first_name' => 'Jeroen', 'last_name' => 'Sormani', 'company' => 'WooCompany', 'address_1' => 'WooAddress', 'address_2' => '', 'postcode' => '123456', 'city' => 'WooCity', 'state' => 'NY', 'email' => '*****@*****.**', 'phone' => '555-32123'); $order->set_address($shipping_address, 'shipping'); // Add shipping costs $shipping_taxes = \WC_Tax::calc_shipping_tax('10', \WC_Tax::get_shipping_tax_rates()); $order->add_shipping(new \WC_Shipping_Rate('flagship_shipping_method|Purolator|PurolatorExpress|Purolator Express|1473811200', 'Purolator - Purolator Express', '10', $shipping_taxes, 'flagship_shipping_method')); // Set totals $order->set_total(10, 'shipping'); $order->set_total(0, 'cart_discount'); $order->set_total(0, 'cart_discount_tax'); $order->set_total(0, 'tax'); $order->set_total(0, 'shipping_tax'); $order->set_total($total, 'total'); // 4 x $10 simple helper product return wc_get_order($order->id); }