/** * @throws PlentymarketsExportEntityException */ protected function bookIncommingPayment() { $paymentStatusPaid = explode('|', PlentymarketsConfig::getInstance()->getOrderPaidStatusID(12)); // Directly book the incoming payment if ($this->Order->getPaymentStatus() && in_array($this->Order->getPaymentStatus()->getId(), $paymentStatusPaid)) { // May throw an exception $IncomingPayment = new PlentymarketsExportEntityOrderIncomingPayment($this->Order->getId()); $IncomingPayment->book(); } }
/** * Writes the plenty order id and the status into the database * * @param integer $plentyOrderID * @param float $plentyOrderStatus */ protected function setSuccess($plentyOrderID, $plentyOrderStatus) { PlentymarketsLogger::getInstance()->message('Export:Order', 'The sales order with the number »' . $this->Order->getNumber() . '« has been created in plentymakets (id: ' . $plentyOrderID . ', status: ' . $plentyOrderStatus . ')'); Shopware()->Db()->prepare(' UPDATE plenty_order SET status = 2, timestampLastTry = NOW(), numberOfTries = numberOfTries + 1, plentyOrderTimestamp = NOW(), plentyOrderId = ?, plentyOrderStatus = ? WHERE shopwareId = ? ')->execute(array($plentyOrderID, $plentyOrderStatus, $this->Order->getId())); }
/** * Internal helper function to check if the order or payment status has been changed. If one * of the status changed, the function will create a status mail. If the passed autoSend parameter * is true, the created status mail will be send directly. * @param Order $order * @param \Shopware\Models\Order\Status $statusBefore * @param \Shopware\Models\Order\Status $clearedBefore * @param boolean $autoSend * @return array */ private function checkOrderStatus($order, $statusBefore, $clearedBefore, $autoSend) { if ($order->getOrderStatus()->getId() !== $statusBefore->getId() || $order->getPaymentStatus()->getId() !== $clearedBefore->getId()) { //status or cleared changed? if ($order->getOrderStatus()->getId() !== $statusBefore->getId()) { $mail = $this->getMailForOrder($order->getId(), $order->getOrderStatus()->getId()); } else { $mail = $this->getMailForOrder($order->getId(), $order->getPaymentStatus()->getId()); } //mail object created and auto send activated, then send mail directly. if (is_object($mail['mail']) && $autoSend === "true") { $result = Shopware()->Modules()->Order()->sendStatusMail($mail['mail']); //check if send mail was successfully. $mail['data']['sent'] = is_object($result); } return $mail['data']; } else { return null; } }
/** * @param \Shopware\Models\Order\Order $orderModel * @return array */ private function prepareOrderConfirmationMailData($orderModel) { $billingAddress = Shopware()->Db()->fetchRow('SELECT *, userID AS customerBillingId FROM s_order_billingaddress WHERE orderID = ?', [$orderModel->getId()]); $billingAddressAttributes = Shopware()->Db()->fetchRow('SELECT * FROM s_order_billingaddress_attributes WHERE billingID = ?', [$billingAddress['id']]); if (!empty($billingAddressAttributes)) { $billingAddress = array_merge($billingAddress, $billingAddressAttributes); } /** @var \Shopware_Components_CreateBackendOrder $createBackendOrder */ $createBackendOrder = Shopware()->CreateBackendOrder(); if ($createBackendOrder->getEqualBillingAddress()) { $shippingAddress = $billingAddress; } else { $shippingAddress = Shopware()->Db()->fetchRow('SELECT *, userID AS customerBillingId FROM s_order_shippingaddress WHERE orderID = ?', [$orderModel->getId()]); $shippingAddressAttributes = Shopware()->Db()->fetchRow('SELECT * FROM s_order_shippingaddress_attributes WHERE shippingID = ?', [$shippingAddress['id']]); if (!empty($shippingAddressAttributes)) { $shippingAddress = array_merge($shippingAddress, $shippingAddressAttributes); } } $context['billingaddress'] = $billingAddress; $context['shippingaddress'] = $shippingAddress; $context['sOrderNumber'] = $orderModel->getNumber(); $currency = $orderModel->getCurrency(); $context['sCurrency'] = $currency; $context['sAmount'] = $orderModel->getInvoiceAmount() . ' ' . $currency; $context['sAmountNet'] = $orderModel->getInvoiceAmountNet() . ' ' . $currency; $context['sShippingCosts'] = $orderModel->getInvoiceShipping() . ' ' . $currency; $orderTime = $orderModel->getOrderTime(); $context['sOrderDay'] = $orderTime->format('d.m.Y'); $context['sOrderTime'] = $orderTime->format('H:i'); $context['sComment'] = ''; $context['sLanguage'] = $orderModel->getLanguageSubShop()->getId(); $context['sSubShop'] = $orderModel->getShop()->getId(); $orderAttributes = Shopware()->Db()->fetchRow('SELECT * FROM s_order_attributes WHERE orderID = ?', [$orderModel->getId()]); $context['attributes'] = $orderAttributes; $dispatch = Shopware()->Db()->fetchRow('SELECT * FROM s_premium_dispatch WHERE id = ?', [$orderModel->getDispatch()->getId()]); $dispatch = $this->translateDispatch($dispatch, $orderModel->getLanguageSubShop()->getId()); $context['sDispatch'] = $dispatch; $user = Shopware()->Db()->fetchRow('SELECT * FROM s_user WHERE id = ?', [$orderModel->getCustomer()->getId()]); $context['additional']['user'] = $user; $country = Shopware()->Db()->fetchRow('SELECT * FROM s_core_countries WHERE id = ?', [$orderModel->getBilling()->getCountry()->getId()]); $context['additional']['country'] = $country; $context['additional']['state'] = []; if ($orderModel->getBilling()->getState()) { $state = Shopware()->Db()->fetchRow('SELECT * FROM s_core_countries_states WHERE id = ?', [$orderModel->getBilling()->getState()->getId()]); $context['additional']['state'] = $state; } $country = Shopware()->Db()->fetchRow('SELECT * FROM s_core_countries WHERE id = ?', [$orderModel->getShipping()->getCountry()->getId()]); $context['additional']['countryShipping'] = $country; $context['additional']['stateShipping'] = []; if ($orderModel->getShipping()->getState()) { $state = Shopware()->Db()->fetchRow('SELECT * FROM s_core_countries_states WHERE id = ?', [$orderModel->getShipping()->getState()->getId()]); $context['additional']['stateShipping'] = $state; } $payment = Shopware()->Db()->fetchRow('SELECT * FROM s_core_paymentmeans WHERE id = ?', [$orderModel->getPayment()->getId()]); $payment = $this->translatePayment($payment, $orderModel->getLanguageSubShop()->getId()); $context['additional']['payment'] = $payment; $context['sPaymentTable'] = []; if ($context['additional']['payment']['name'] === 'debit') { $paymentTable = Shopware()->Db()->fetchRow('SELECT * FROM s_core_payment_data WHERE user_id = ?', [$orderModel->getCustomer()->getId()]); $context['sPaymentTable'] = $paymentTable; } $context['additional']['show_net'] = $orderModel->getNet(); $context['additional']['charge_var'] = 1; return $context; }