/**
* Validate and sanitize input values.
*
* @param array $settings Input fields.
*
* @return array Sanitized and validated output.
* @throws ValidationException When some items are not valid.
*/
public function validate($settings)
{
if (!in_array($settings['weight_unit'], array_keys($this->weightUnit))) {
$this->messages->addWarning(sprintf(__('Invalid weight unit: "%s". Value set to %s.', 'jigoshop'), $settings['weight_unit'], $this->weightUnit['kg']));
$settings['weight_unit'] = 'kg';
}
if (!in_array($settings['dimensions_unit'], array_keys($this->dimensionUnit))) {
$this->messages->addWarning(sprintf(__('Invalid dimensions unit: "%s". Value set to %s.', 'jigoshop'), $settings['dimensions_unit'], $this->dimensionUnit['cm']));
$settings['dimensions_unit'] = 'cm';
}
if (!in_array($settings['stock_status'], array_keys($this->stockStatuses))) {
$this->messages->addWarning(sprintf(__('Invalid default stock status: "%s". Value set to %s.', 'jigoshop'), $settings['stock_status'], $this->stockStatuses[StockStatus::IN_STOCK]));
$settings['stock_status'] = StockStatus::IN_STOCK;
}
$settings['manage_stock'] = $settings['manage_stock'] == 'on';
$settings['show_stock'] = $settings['show_stock'] == 'on';
$settings['related'] = $settings['related'] == 'on';
$settings['low_stock_threshold'] = (int) $settings['low_stock_threshold'];
if ($settings['low_stock_threshold'] < 0) {
$this->messages->addWarning(sprintf(__('Invalid low stock threshold: "%d". Value set to 2.', 'jigoshop'), $settings['low_stock_threshold']));
$settings['low_stock_threshold'] = 2;
}
$settings['notify_low_stock'] = $settings['notify_low_stock'] == 'on';
$settings['notify_out_of_stock'] = $settings['notify_out_of_stock'] == 'on';
$settings['notify_on_backorders'] = $settings['notify_on_backorders'] == 'on';
$settings['images']['tiny'] = array('width' => (int) $settings['images']['tiny']['width'], 'height' => (int) $settings['images']['tiny']['height'], 'crop' => $settings['images']['tiny']['crop'] == 'on');
$settings['images']['thumbnail'] = array('width' => (int) $settings['images']['thumbnail']['width'], 'height' => (int) $settings['images']['thumbnail']['height'], 'crop' => $settings['images']['thumbnail']['crop'] == 'on');
$settings['images']['small'] = array('width' => (int) $settings['images']['small']['width'], 'height' => (int) $settings['images']['small']['height'], 'crop' => $settings['images']['small']['crop'] == 'on');
$settings['images']['large'] = array('width' => (int) $settings['images']['large']['width'], 'height' => (int) $settings['images']['large']['height'], 'crop' => $settings['images']['large']['crop'] == 'on');
return $settings;
}
/**
* Validates and returns properly sanitized options.
*
* @param $settings array Input options.
*
* @return array Sanitized result.
*/
public function validateOptions($settings)
{
$settings['enabled'] = $settings['enabled'] == 'on';
if (!is_numeric($settings['minimum'])) {
$settings['minimum'] = $this->options['minimum'];
$this->messages->addWarning(__('Minimum cart value was invalid - value is left unchanged.', 'jigoshop'));
}
if ($settings['minimum'] >= 0) {
$settings['minimum'] = (int) $settings['minimum'];
} else {
$settings['minimum'] = $this->options['minimum'];
$this->messages->addWarning(__('Minimum cart value was below 0 - value is left unchanged.', 'jigoshop'));
}
if (!in_array($settings['available_for'], array_keys($this->availability))) {
$settings['available_for'] = $this->options['available_for'];
$this->messages->addWarning(__('Availability is invalid - value is left unchanged.', 'jigoshop'));
}
if ($settings['available_for'] === 'specific') {
$settings['countries'] = array_filter($settings['countries'], function ($item) {
return Country::exists($item);
});
} else {
$settings['countries'] = array();
}
return $settings;
}
/**
* Validate and sanitize input values.
*
* @param array $settings Input fields.
*
* @return array Sanitized and validated output.
* @throws ValidationException When some items are not valid.
*/
public function validate($settings)
{
$settings['catalog_per_page'] = (int) $settings['catalog_per_page'];
if ($settings['catalog_per_page'] <= 0) {
$this->messages->addWarning(sprintf(__('Invalid products per page value: "%d". Value set to 12.', 'jigoshop'), $settings['catalog_per_page']));
$settings['catalog_per_page'] = 12;
}
if (!in_array($settings['catalog_order_by'], array_keys($this->catalogOrderBy))) {
$this->messages->addWarning(sprintf(__('Invalid products sorting: "%s". Value set to %s.', 'jigoshop'), $settings['catalog_order_by'], $this->catalogOrderBy['post_date']));
$settings['catalog_order_by'] = 'post_date';
}
if (!in_array($settings['catalog_order'], array_keys($this->catalogOrder))) {
$this->messages->addWarning(sprintf(__('Invalid products sorting orientation: "%s". Value set to %s.', 'jigoshop'), $settings['catalog_order'], $this->catalogOrder['DESC']));
$settings['catalog_order'] = 'DESC';
}
$settings['hide_out_of_stock'] = $settings['hide_out_of_stock'] == 'on';
$settings['enable_verification_message'] = $settings['enable_verification_message'] == 'on';
$settings['guest_purchases'] = $settings['guest_purchases'] == 'on';
$settings['show_login_form'] = $settings['show_login_form'] == 'on';
$settings['allow_registration'] = $settings['allow_registration'] == 'on';
$settings['login_for_downloads'] = $settings['login_for_downloads'] == 'on';
$settings['force_ssl'] = $settings['force_ssl'] == 'on';
$settings['validate_zip'] = $settings['validate_zip'] == 'on';
$settings['restrict_selling_locations'] = $settings['restrict_selling_locations'] == 'on';
if (!$settings['restrict_selling_locations']) {
$settings['selling_locations'] = array();
} else {
$settings['selling_locations'] = array_intersect($settings['selling_locations'], array_keys(Country::getAll()));
}
if (!in_array($settings['redirect_add_to_cart'], array_keys($this->addToCartRedirectionOptions))) {
$this->messages->addWarning(sprintf(__('Invalid add to cart redirection: "%s". Value set to %s.', 'jigoshop'), $settings['redirect_add_to_cart'], $this->addToCartRedirectionOptions['same_page']));
$settings['redirect_add_to_cart'] = 'same_page';
}
if (!in_array($settings['redirect_continue_shopping'], array_keys($this->backToShopRedirectionOptions))) {
$this->messages->addWarning(sprintf(__('Invalid continue shopping redirection: "%s". Value set to %s.', 'jigoshop'), $settings['redirect_continue_shopping'], $this->backToShopRedirectionOptions['product_list']));
$settings['redirect_continue_shopping'] = 'product_list';
}
return $settings;
}
/**
* Validates and returns properly sanitized options.
*
* @param $settings array Input options.
*
* @return array Sanitized result.
*/
public function validateOptions($settings)
{
$settings['enabled'] = $settings['enabled'] == 'on';
$settings['title'] = trim(htmlspecialchars(strip_tags($settings['title'])));
$settings['description'] = trim(htmlspecialchars(strip_tags($settings['description'], '<p><a><strong><em><b><i>')));
if (!Validation::isEmail($settings['email'])) {
$settings['email'] = '';
if ($settings['enabled']) {
$this->messages->addWarning(__('Email address is not valid.', 'jigoshop'));
}
}
$settings['send_shipping'] = $settings['send_shipping'] == 'on';
$settings['force_payment'] = $settings['force_payment'] == 'on';
$settings['test_mode'] = $settings['test_mode'] == 'on';
if (!Validation::isEmail($settings['test_email'])) {
$settings['test_email'] = '';
if ($settings['enabled']) {
$this->messages->addWarning(__('Test email address is not valid.', 'jigoshop'));
}
}
return $settings;
}
public function action()
{
if (isset($_REQUEST['action'])) {
switch ($_REQUEST['action']) {
case 'cancel_order':
if ($this->wp->getHelpers()->verifyNonce($_REQUEST['nonce'], 'cancel_order')) {
/** @var Order $order */
$order = $this->orderService->find((int) $_REQUEST['id']);
if ($order->getKey() != $_REQUEST['key']) {
$this->messages->addError(__('Invalid order key.', 'jigoshop'));
return;
}
if ($order->getStatus() != Status::PENDING) {
$this->messages->addError(__('Unable to cancel order.', 'jigoshop'));
return;
}
$order->setStatus(Status::CANCELLED);
$cart = $this->cartService->createFromOrder($this->cartService->getCartIdForCurrentUser(), $order);
$this->orderService->save($order);
$this->cartService->save($cart);
$this->messages->addNotice(__('The order has been cancelled', 'jigoshop'));
}
break;
case 'update-shipping':
$customer = $this->customerService->getCurrent();
$this->updateCustomer($customer);
break;
case 'checkout':
try {
$cart = $this->cartService->getCurrent();
// Update quantities
$this->updateQuantities($cart);
// Update customer (if needed)
if ($this->options->get('shipping.calculator')) {
$customer = $this->customerService->getCurrent();
$this->updateCustomer($customer);
}
if (isset($_POST['jigoshop_order']['shipping_method'])) {
// Select shipping method
$method = $this->shippingService->get($_POST['jigoshop_order']['shipping_method']);
$cart->setShippingMethod($method);
}
if ($cart->getShippingMethod() && !$cart->getShippingMethod()->isEnabled()) {
$cart->removeShippingMethod();
$this->messages->addWarning(__('Previous shipping method is unavailable. Please select different one.', 'jigoshop'));
}
if ($this->options->get('shopping.validate_zip')) {
$address = $cart->getCustomer()->getShippingAddress();
if ($address->getPostcode() && !Validation::isPostcode($address->getPostcode(), $address->getCountry())) {
throw new Exception(__('Postcode is not valid!', 'jigoshop'));
}
}
do_action('jigoshop\\cart\\before_checkout', $cart);
$this->cartService->save($cart);
$this->messages->preserveMessages();
$this->wp->redirectTo($this->options->getPageId(Pages::CHECKOUT));
} catch (Exception $e) {
$this->messages->addError(sprintf(__('Error occurred while updating cart: %s', 'jigoshop'), $e->getMessage()));
}
break;
case 'update-cart':
if (isset($_POST['cart']) && is_array($_POST['cart'])) {
try {
$cart = $this->cartService->getCurrent();
$this->updateQuantities($cart);
$this->cartService->save($cart);
$this->messages->addNotice(__('Successfully updated the cart.', 'jigoshop'));
} catch (Exception $e) {
$this->messages->addError(sprintf(__('Error occurred while updating cart: %s', 'jigoshop'), $e->getMessage()));
}
}
}
}
if (isset($_GET['action']) && isset($_GET['item']) && $_GET['action'] === 'remove-item' && is_numeric($_GET['item'])) {
$cart = $this->cartService->getCurrent();
$cart->removeItem((int) $_GET['item']);
$this->cartService->save($cart);
$this->messages->addNotice(__('Successfully removed item from cart.', 'jigoshop'), false);
}
}
/**
* Executes actions associated with selected page.
*/
public function action()
{
$cart = $this->cartService->getCurrent();
if ($cart->isEmpty()) {
$this->messages->addWarning(__('Your cart is empty, please add products before proceeding.', 'jigoshop'));
$this->wp->redirectTo($this->options->getPageId(Pages::SHOP));
}
if (!$this->isAllowedToEnterCheckout()) {
$this->messages->addError(__('You need to log in before processing to checkout.', 'jigoshop'));
$this->wp->redirectTo($this->options->getPageId(Pages::CART));
}
if (isset($_POST['action']) && $_POST['action'] == 'purchase') {
try {
$allowRegistration = $this->options->get('shopping.allow_registration');
if ($allowRegistration && !$this->wp->isUserLoggedIn()) {
$this->createUserAccount();
}
if (!$this->isAllowedToCheckout($cart)) {
if ($allowRegistration) {
throw new Exception(__('You need either to log in or create account to purchase.', 'jigoshop'));
}
throw new Exception(__('You need to log in before purchasing.', 'jigoshop'));
}
if ($this->options->get('advanced.pages.terms') > 0 && (!isset($_POST['terms']) || $_POST['terms'] != 'on')) {
throw new Exception(__('You need to accept terms & conditions!', 'jigoshop'));
}
$this->cartService->validate($cart);
$this->customerService->save($cart->getCustomer());
if (!Country::isAllowed($cart->getCustomer()->getBillingAddress()->getCountry())) {
$locations = array_map(function ($location) {
return Country::getName($location);
}, $this->options->get('shopping.selling_locations'));
throw new Exception(sprintf(__('This location is not supported, we sell only to %s.'), join(', ', $locations)));
}
$shipping = $cart->getShippingMethod();
if ($this->isShippingRequired($cart) && (!$shipping || !$shipping->isEnabled())) {
throw new Exception(__('Shipping is required for this order. Please select shipping method.', 'jigoshop'));
}
$payment = $cart->getPaymentMethod();
$isPaymentRequired = $this->isPaymentRequired($cart);
$this->wp->doAction('jigoshop\\checkout\\payment', $payment);
if ($isPaymentRequired && (!$payment || !$payment->isEnabled())) {
throw new Exception(__('Payment is required for this order. Please select payment method.', 'jigoshop'));
}
$order = $this->orderService->createFromCart($cart);
/** @var Order $order */
$order = $this->wp->applyFilters('jigoshop\\checkout\\order', $order);
$this->orderService->save($order);
$this->cartService->remove($cart);
$url = '';
if ($isPaymentRequired) {
$url = $payment->process($order);
} else {
$order->setStatus(\Jigoshop\Helper\Order::getStatusAfterCompletePayment($order));
$this->orderService->save($order);
}
// Redirect to thank you page
if (empty($url)) {
$url = $this->wp->getPermalink($this->wp->applyFilters('jigoshop\\checkout\\redirect_page_id', $this->options->getPageId(Pages::THANK_YOU)));
$url = $this->wp->getHelpers()->addQueryArg(array('order' => $order->getId(), 'key' => $order->getKey()), $url);
}
$this->wp->wpRedirect($url);
exit;
} catch (Exception $e) {
$this->messages->addError($e->getMessage());
}
}
}
public function fill(OrderInterface $order, array $data)
{
if (!empty($data['customer']) && is_numeric($data['customer'])) {
$data['customer'] = $this->customerService->find($data['customer']);
}
if (isset($data['customer'])) {
if (!empty($data['customer'])) {
$data['customer'] = $this->wp->getHelpers()->maybeUnserialize($data['customer']);
} else {
$data['customer'] = new CustomerEntity\Guest();
}
if (isset($data['billing_address'])) {
$data['billing_address'] = array_merge(array_flip(array_keys(ProductHelper::getBasicBillingFields())), $data['billing_address']);
/** @var CustomerEntity $customer */
$customer = $data['customer'];
$customer->setBillingAddress($this->createAddress($data['billing_address']));
}
if (isset($data['shipping_address'])) {
$data['shipping_address'] = array_merge(array_flip(array_keys(ProductHelper::getBasicShippingFields())), $data['shipping_address']);
/** @var CustomerEntity $customer */
$customer = $data['customer'];
$customer->setShippingAddress($this->createAddress($data['shipping_address']));
}
$order->setCustomer($data['customer']);
unset($data['customer']);
}
/** @var OrderInterface $order */
$order = $this->wp->applyFilters('jigoshop\\factory\\order\\fetch\\after_customer', $order);
if (isset($data['items'])) {
$order->removeItems();
}
//We do not want to add coupons and from directly, without validation.
$coupons = null;
if (isset($data['coupons'])) {
$coupons = $data['coupons'];
unset($data['coupons']);
}
if (isset($data['discount'])) {
unset($data['discount']);
}
$order->restoreState($data);
if ($coupons) {
$coupons = $this->wp->getHelpers()->maybeUnserialize($coupons);
if (isset($coupons[0]) && is_array($coupons[0])) {
$codes = array_map(function ($coupon) {
return $coupon['code'];
}, $coupons);
} else {
$codes = $coupons;
}
$coupons = $this->couponService->getByCodes($codes);
foreach ($coupons as $coupon) {
/** @var Coupon $coupon */
try {
$order->addCoupon($coupon);
} catch (Exception $e) {
$this->messages->addWarning($e->getMessage(), false);
}
}
}
return $this->wp->applyFilters('jigoshop\\factory\\order\\fill', $order);
}
/**
* Migrates data from old format to new one.
* @param array $orders
* @return bool migration product status: success or not
*/
public function migrate($orders)
{
$wpdb = $this->wp->getWPDB();
// Open transaction for save migration products
$var_autocommit_sql = $wpdb->get_var("SELECT @@AUTOCOMMIT");
try {
$this->checkSql();
$wpdb->query("SET AUTOCOMMIT=0");
$this->checkSql();
$wpdb->query("START TRANSACTION");
$this->checkSql();
// Register order status taxonomy to fetch old statuses
$this->wp->registerTaxonomy('shop_order_status', array('shop_order'), array('hierarchical' => true, 'update_count_callback' => '_update_post_term_count', 'labels' => array('name' => __('Order statuses', 'jigoshop'), 'singular_name' => __('Order status', 'jigoshop'), 'search_items' => __('Search Order statuses', 'jigoshop'), 'all_items' => __('All Order statuses', 'jigoshop'), 'parent_item' => __('Parent Order status', 'jigoshop'), 'parent_item_colon' => __('Parent Order status:', 'jigoshop'), 'edit_item' => __('Edit Order status', 'jigoshop'), 'update_item' => __('Update Order status', 'jigoshop'), 'add_new_item' => __('Add New Order status', 'jigoshop'), 'new_item_name' => __('New Order status Name', 'jigoshop')), 'public' => false, 'show_ui' => false, 'show_in_nav_menus' => false, 'query_var' => true, 'rewrite' => false));
for ($i = 0, $endI = count($orders); $i < $endI;) {
$order = $orders[$i];
// Update central order data
$status = $this->wp->getTheTerms($order->ID, 'shop_order_status');
$this->checkSql();
if (!empty($status)) {
$status = $this->_transformStatus($status[0]->slug);
} else {
$status = Status::PENDING;
}
$query = $wpdb->prepare("UPDATE {$wpdb->posts} SET post_status = %s WHERE ID = %d", $status, $order->ID);
$wpdb->query($query);
$this->checkSql();
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'number', $order->ID));
$this->checkSql();
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'updated_at', time()));
$this->checkSql();
// Update columns
do {
switch ($orders[$i]->meta_key) {
case '_js_completed_date':
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_key = %s, meta_value = %d WHERE meta_id = %d", 'completed_at', strtotime($orders[$i]->meta_value), $orders[$i]->meta_id));
$this->checkSql();
break;
case 'order_key':
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_key = %s WHERE meta_id = %d", 'key', $orders[$i]->meta_id));
$this->checkSql();
break;
case 'order_data':
$data = unserialize($orders[$i]->meta_value);
$data = $this->_fetchOrderData($data);
// Migrate customer
if ($this->customer == null) {
$customer = $this->wp->getPostMeta($order->ID, 'customer', true);
$this->customer = $customer;
}
$this->customer = $this->_migrateCustomer($this->customer, $data);
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'customer', serialize(serialize($this->customer))));
$this->checkSql();
// Migrate coupons
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'coupons', serialize($data['order_discount_coupons'])));
// TODO: HERE
$this->checkSql();
// Migrate shipping method
try {
$method = $this->shippingService->get($data['shipping_method']);
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'shipping', serialize(array('method' => $method->getState(), 'price' => $data['order_shipping'], 'rate' => ''))));
$this->checkSql();
} catch (Exception $e) {
$this->messages->addWarning(sprintf(__('Shipping method "%s" not found. Order with ID "%d" has no shipping method now.'), $data['shipping_method'], $order->ID));
}
// Migrate payment method
try {
$method = $this->paymentService->get($data['payment_method']);
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'payment', $method->getId()));
$this->checkSql();
} catch (Exception $e) {
$this->messages->addWarning(sprintf(__('Payment method "%s" not found. Order with ID "%d" has no payment method now.'), $data['payment_method'], $order->ID));
}
// Migrate order totals
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'subtotal', $data['order_subtotal']));
$this->checkSql();
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'discount', $data['order_discount']));
$this->checkSql();
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", $order->ID, 'total', $data['order_total']));
$this->checkSql();
// TODO: Add new meta for shipping total price
/*$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)",
$order->ID,
'shipping',
$data['order_shipping']
));
$this->checkSql();*/
break;
case 'customer_user':
if ($this->customer == null) {
$customer = $this->wp->getPostMeta($order->ID, 'customer', true);
if ($customer !== false) {
/** @var Customer $customer */
$customer = maybe_unserialize(maybe_unserialize($customer));
if (!$customer) {
$customer = new Customer();
}
} else {
$customer = new Customer();
}
$this->customer = $customer;
}
/** @var \WP_User $user */
if (($user = $this->wp->getUserBy('id', $orders[$i]->meta_value)) !== false) {
$this->checkSql();
$this->customer->setId($user->ID);
$this->customer->setLogin($user->get('login'));
$this->customer->setEmail($user->get('user_email'));
$this->customer->setName($user->get('display_name'));
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_value = %d WHERE post_id = %d AND meta_key = %s", serialize(serialize($this->customer)), $orders[$i]->meta_id, 'customer'));
$this->checkSql();
$userId = $orders[$i]->meta_value;
} else {
$userId = 0;
$guest = new Customer\Guest();
$guest->setBillingAddress($this->customer->getBillingAddress());
$guest->setShippingAddress($this->customer->getShippingAddress());
$this->customer = $guest;
}
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %d)", $order->ID, 'customer_id', $userId));
break;
case 'order_items':
$data = unserialize($orders[$i]->meta_value);
$globalTaxRate = 0.0;
foreach ($data as $itemData) {
/** @var Product $product */
$itemData = $this->_fetchItemData($itemData);
$product = null;
$productGetId = null;
if ($wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$wpdb->posts} WHERE ID = %d", $itemData['id'])) > 0) {
$product = $this->productService->find($itemData['id']);
$productGetId = $product->getId();
}
$tax = 0.0;
$taxRate = 0;
if ($itemData['qty'] == 0) {
$itemData['qty'] = 1;
}
$price = $itemData['cost'] / $itemData['qty'];
if (!empty($itemData['taxrate']) && $itemData['taxrate'] > 0) {
$tax = $price * $itemData['taxrate'] / 100;
$taxRate = $itemData['taxrate'];
} else {
if (isset($itemData['cost_inc_tax']) && $itemData['cost'] < $itemData['cost_inc_tax']) {
$tax = ($itemData['cost_inc_tax'] - $itemData['cost']) / $itemData['qty'];
$taxRate = $tax / $itemData['cost'];
}
}
$globalTaxRate += $taxRate;
$productGetType = false;
if ($productGetId == null) {
if (isset($itemData['variation_id']) && !empty($itemData['variation_id'])) {
$productGetType = Product\Variable::TYPE;
} else {
$productGetType = Product\Simple::TYPE;
}
} else {
$productGetType = $product->getType();
}
$insertOrderData = array('order_id' => $order->ID, 'product_type' => $productGetType, 'title' => $itemData['name'], 'price' => $price, 'tax' => $tax, 'quantity' => $itemData['qty'], 'cost' => $itemData['cost']);
if ($productGetId != null) {
$insertOrderData['product_id'] = $productGetId;
}
$wpdb->insert($wpdb->prefix . 'jigoshop_order_item', $insertOrderData);
$this->checkSql();
$itemId = $wpdb->insert_id;
if (isset($itemData['variation_id']) && !empty($itemData['variation_id']) && ($productGetId == null || $product instanceof Product\Variable)) {
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->prefix}jigoshop_order_item_meta (item_id, meta_key, meta_value) VALUES (%d, %s, %s)", $itemId, 'variation_id', $itemData['variation_id']));
$this->checkSql();
if ($productGetId !== null) {
/** @var Product\Variable\Variation $variationProduct */
/** @var Product\Variable $product */
$variationProduct = $product->getVariation($itemData['variation_id']);
if (is_array($itemData['variation']) && $variationProduct && $variationProduct instanceof Product\Variable\Variation) {
foreach ($itemData['variation'] as $variation => $variationValue) {
$variation = str_replace('tax_', '', $variation);
$attribute = $this->getAttribute($variationProduct, $variation);
if ($attribute === null) {
$this->messages->addWarning(sprintf(__('Attribute "%s" not found for variation ID "%d".', 'jigoshop'), $variation, $variationProduct->getId()));
continue;
}
$option = $this->getAttributeOption($attribute, $variationValue);
if ($option === null) {
$this->messages->addWarning(sprintf(__('Attribute "%s" option "%s" not found for variation ID "%d".', 'jigoshop'), $variation, $variationValue, $variationProduct->getId()));
continue;
}
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->prefix}jigoshop_order_item_meta (item_id, meta_key, meta_value) VALUES (%d, %s, %s)", $itemId, $attribute->getAttribute()->getId(), $option->getId()));
$this->checkSql();
}
}
}
}
}
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->prefix}jigoshop_order_tax (order_id, label, tax_class, rate, is_compound) VALUES (%d, %s, %s, %d, %d)", $order->ID, __('Standard', 'jigoshop'), 'standard', $globalTaxRate / (count($data) == 0 ? 1 : count($data)), false));
$this->checkSql();
break;
}
$i++;
} while ($i < $endI && $orders[$i]->ID == $order->ID);
}
// commit sql transation and restore value of autocommit
$wpdb->query("COMMIT");
$wpdb->query("SET AUTOCOMMIT=" . $var_autocommit_sql);
return true;
} catch (Exception $e) {
// rollback sql transation and restore value of autocommit
if (WP_DEBUG) {
\Monolog\Registry::getInstance(JIGOSHOP_LOGGER)->addDebug($e);
}
$wpdb->query("ROLLBACK");
$wpdb->query("SET AUTOCOMMIT=" . $var_autocommit_sql);
Migration::saveLog(__('Migration orders end with error: ', 'jigoshop') . $e);
return false;
}
}
/**
* Validate and sanitize input values.
*
* @param array $settings Input fields.
*
* @return array Sanitized and validated output.
* @throws ValidationException When some items are not valid.
*/
public function validate($settings)
{
// This is required when installin emails this function is used twice,
// once for advanced settings and once for all jigoshop settings.
if (isset($settings['general']) && is_array($settings['general'])) {
return $settings;
}
if (isset($settings['install_emails'])) {
unset($settings['install_emails']);
// TODO add this to WPAL
remove_all_actions('save_post_' . Types\Email::NAME);
$this->di->get('jigoshop.installer')->installEmails();
$this->messages->addNotice(__('Emails created.', 'jigoshop'));
}
$settings['automatic_complete'] = $settings['automatic_complete'] == 'on';
$settings['automatic_reset'] = $settings['automatic_reset'] == 'on';
$settings['products_list']['variations_sku_stock'] = $settings['products_list']['variations_sku_stock'] == 'on';
if (!in_array($settings['cache'], array_keys($this->caches))) {
$this->messages->addWarning(sprintf(__('Invalid cache mechanism: "%s". Value set to %s.', 'jigoshop'), $settings['cache'], $this->caches['simple']));
$settings['cache'] = 'simple';
}
$settings['ignore_meta_queries'] = $settings['ignore_meta_queries'] == 'on';
if (isset($settings['api'], $settings['api']['keys'])) {
$settings['api']['keys'] = array_filter($settings['api']['keys'], function ($item) {
return !empty($item['key']);
});
$settings['api']['keys'] = array_map(function ($item) {
return array_merge(array('key' => '', 'permissions' => array()), $item);
}, $settings['api']['keys']);
}
$pages = $this->_getPages();
if (!in_array($settings['pages']['shop'], array_keys($pages))) {
$this->messages->addError(__('Invalid shop page, please select again.', 'jigoshop'));
} else {
$this->options->setPageId(Pages::SHOP, $settings['pages']['shop']);
}
if (!in_array($settings['pages']['cart'], array_keys($pages))) {
$this->messages->addError(__('Invalid cart page, please select again.', 'jigoshop'));
} else {
$this->options->setPageId(Pages::CART, $settings['pages']['cart']);
}
if (!in_array($settings['pages']['checkout'], array_keys($pages))) {
$this->messages->addError(__('Invalid checkout page, please select again.', 'jigoshop'));
} else {
$this->options->setPageId(Pages::CHECKOUT, $settings['pages']['checkout']);
}
if (!in_array($settings['pages']['checkout_thank_you'], array_keys($pages))) {
$this->messages->addError(__('Invalid thank you page, please select again.', 'jigoshop'));
} else {
$this->options->setPageId(Pages::THANK_YOU, $settings['pages']['checkout_thank_you']);
}
if (!in_array($settings['pages']['account'], array_keys($pages))) {
$this->messages->addError(__('Invalid My account page, please select again.', 'jigoshop'));
} else {
$this->options->setPageId(Pages::ACCOUNT, $settings['pages']['account']);
}
if (!empty($settings['pages']['terms']) && $settings['pages']['terms'] != 0 && !in_array($settings['pages']['terms'], array_keys($pages))) {
$this->messages->addError(__('Invalid terms page, please select again.', 'jigoshop'));
}
return $settings;
}
