/**
* Displays the product data box, tabbed, with several panels covering price, stock etc
*
* @since 1.0
*/
public function box()
{
$post = $this->wp->getGlobalPost();
$coupon = $this->couponService->findForPost($post);
$methods = array();
foreach ($this->paymentService->getAvailable() as $method) {
/** @var $method Method */
$methods[$method->getId()] = $method->getName();
}
Render::output('admin/coupon/box', array('coupon' => $coupon, 'types' => $this->couponService->getTypes(), 'paymentMethods' => $methods));
}
/**
* Renders page template.
*
* @return string Page template.
*/
public function render()
{
$content = $this->wp->getPostField('post_content', $this->options->getPageId(Pages::CHECKOUT));
$content = do_shortcode($content);
$cart = $this->cartService->getCurrent();
$billingFields = $this->getBillingFields($cart->getCustomer()->getBillingAddress());
$shippingFields = $this->getShippingFields($cart->getCustomer()->getShippingAddress());
$termsUrl = '';
$termsPage = $this->options->get('advanced.pages.terms');
if ($termsPage > 0) {
$termsUrl = $this->wp->getPageLink($termsPage);
}
$verificationMessage = $this->options->get('shopping.enable_verification_message') ? $this->options->get('shopping.verification_message') : '';
return Render::get('shop/checkout', array('cartUrl' => $this->wp->getPermalink($this->options->getPageId(Pages::CART)), 'content' => $content, 'cart' => $cart, 'messages' => $this->messages, 'shippingMethods' => $this->shippingService->getEnabled(), 'paymentMethods' => $this->paymentService->getEnabled(), 'billingFields' => $billingFields, 'shippingFields' => $shippingFields, 'showWithTax' => $this->options->get('tax.price_tax') == 'with_tax', 'showLoginForm' => $this->options->get('shopping.show_login_form') && !$this->wp->isUserLoggedIn(), 'allowRegistration' => $this->options->get('shopping.allow_registration') && !$this->wp->isUserLoggedIn(), 'showRegistrationForm' => $this->options->get('shopping.allow_registration') && !$this->options->get('shopping.guest_purchases') && !$this->wp->isUserLoggedIn(), 'alwaysShowShipping' => $this->options->get('shipping.always_show_shipping'), 'verificationMessage' => $verificationMessage, 'differentShipping' => isset($_POST['jigoshop_order']) ? $_POST['jigoshop_order']['different_shipping_address'] == 'on' : false, 'termsUrl' => $termsUrl, 'defaultGateway' => $this->options->get('payment.default_gateway')));
}
public function render()
{
/** @var Order $order */
$order = $this->orderService->find((int) $this->wp->getQueryParameter('pay'));
$render = $this->wp->applyFilters('jigoshop\\pay\\render', '', $order);
if (!empty($render)) {
return Render::get('shop/checkout/payment', array('messages' => $this->messages, 'content' => $render, 'order' => $order));
}
$termsUrl = '';
$termsPage = $this->options->get('advanced.pages.terms');
if ($termsPage > 0) {
$termsUrl = $this->wp->getPageLink($termsPage);
}
$accountUrl = $this->wp->getPermalink($this->options->getPageId(Pages::ACCOUNT));
return Render::get('shop/checkout/pay', array('messages' => $this->messages, 'order' => $order, 'showWithTax' => $this->options->get('tax.price_tax') == 'with_tax', 'termsUrl' => $termsUrl, 'myAccountUrl' => $accountUrl, 'myOrdersUrl' => Api::getEndpointUrl('orders', '', $accountUrl), 'paymentMethods' => $this->paymentService->getEnabled(), 'getTaxLabel' => function ($taxClass) use($order) {
return Tax::getLabel($taxClass, $order);
}));
}
private function getStateFromCheckout($state)
{
$state['customer_note'] = $_POST['jigoshop_order']['customer_note'];
$state['billing_address'] = $_POST['jigoshop_order']['billing_address'];
if ($_POST['jigoshop_order']['different_shipping_address'] == 'on') {
$state['shipping_address'] = $_POST['jigoshop_order']['shipping_address'];
} else {
$state['shipping_address'] = $state['billing_address'];
}
if (isset($_POST['jigoshop_order']['payment_method'])) {
$payment = $this->paymentService->get($_POST['jigoshop_order']['payment_method']);
$this->wp->doAction('jigoshop\\service\\cart\\payment', $payment);
$state['payment'] = $payment;
}
if (isset($_POST['jigoshop_order']['shipping_method'])) {
$shipping = $this->shippingService->get($_POST['jigoshop_order']['shipping_method']);
$this->wp->doAction('jigoshop\\service\\cart\\shipping', $shipping);
$state['shipping'] = array('method' => $shipping, 'rate' => isset($_POST['jigoshop_order']['shipping_method_rate']) ? $_POST['jigoshop_order']['shipping_method_rate'] : null, 'price' => -1);
}
return $state;
}
/**
* 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)
{
$activeGatewayFromPost = array();
foreach ($this->paymentService->getAvailable() as $method) {
/** @var $method Method */
$methodId = $method->getId();
$settings[$methodId] = $method->validateOptions($settings[$methodId]);
// $_POST 'enabled' need be used by all as payment gateways
if ($_POST['jigoshop'][$methodId]['enabled'] == 'on') {
$activeGatewayFromPost[] = $methodId;
}
}
if (count($activeGatewayFromPost) == 0) {
$settings['default_gateway'] = 'no_default_gateway';
return $settings;
}
if ($_POST['jigoshop'][$this->options['default_gateway']]['enabled'] == 'off') {
$settings['default_gateway'] = $activeGatewayFromPost[0];
}
return $settings;
}
/**
* Fetches order from database.
*
* @param $post \WP_Post Post to fetch order for.
*
* @return \Jigoshop\Entity\Order
*/
public function fetch($post)
{
$order = new Entity($this->options->get('tax.classes'));
/** @var Entity $order */
$order = $this->wp->applyFilters('jigoshop\\factory\\order\\fetch\\before', $order);
$state = array();
if ($post) {
$state = array_map(function ($item) {
return $item[0];
}, $this->wp->getPostMeta($post->ID));
$order->setId($post->ID);
if (isset($state['customer'])) {
// Customer must be unserialized twice "thanks" to WordPress second serialization.
/** @var CustomerEntity */
$state['customer'] = unserialize(unserialize($state['customer']));
if ($state['customer'] instanceof CustomerEntity && !$state['customer'] instanceof CustomerEntity\Guest && $state['customer_id'] > 0) {
$customer = $this->customerService->find($state['customer_id']);
$customer->setBillingAddress($state['customer']->getBillingAddress());
$customer->setShippingAddress($state['customer']->getShippingAddress());
$state['customer'] = $customer;
}
}
$state['customer_note'] = $post->post_excerpt;
$state['status'] = $post->post_status;
$state['created_at'] = strtotime($post->post_date);
$state['items'] = $this->getItems($post->ID);
if (isset($state['shipping'])) {
$shipping = unserialize($state['shipping']);
if (!empty($shipping['method'])) {
$state['shipping'] = array('method' => $this->shippingService->findForState($shipping['method']), 'price' => $shipping['price'], 'rate' => isset($shipping['rate']) ? $shipping['rate'] : null);
}
}
if (isset($state['payment'])) {
$state['payment'] = $this->paymentService->get($state['payment']);
}
$order = $this->fill($order, $state);
}
return $this->wp->applyFilters('jigoshop\\find\\order', $order, $state);
}
/**
* 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;
}
}
