/**
* Export the order
*/
protected function exportOrder()
{
$VariantResource = self::getVariantApi();
// Build the Request
$Request_AddOrders = new PlentySoapRequest_AddOrders();
$Request_AddOrders->Orders = array();
//
$Object_Order = new PlentySoapObject_Order();
//
$methodOfPayment = $this->getMethodOfPaymentId();
if ($methodOfPayment == MOP_AMAZON_PAYMENT) {
$externalOrderID = sprintf('Swag/%d/%s/%s', $this->Order->getId(), $this->Order->getNumber(), $this->Order->getTransactionId());
} else {
$externalOrderID = sprintf('Swag/%d/%s', $this->Order->getId(), $this->Order->getNumber());
}
$isOrderNet = (bool) $this->Order->getNet() || (bool) $this->Order->getTaxFree();
// Order head
$Object_OrderHead = new PlentySoapObject_OrderHead();
$Object_OrderHead->Currency = PlentymarketsMappingController::getCurrencyByShopwareID($this->Order->getCurrency());
$Object_OrderHead->CustomerID = $this->PLENTY_customerID;
$Object_OrderHead->DeliveryAddressID = $this->PLENTY_addressDispatchID;
$Object_OrderHead->ExternalOrderID = $externalOrderID;
$Object_OrderHead->IsNetto = $isOrderNet;
$Object_OrderHead->Marking1ID = PlentymarketsConfig::getInstance()->getOrderMarking1(null);
$Object_OrderHead->MethodOfPaymentID = $this->getMethodOfPaymentId();
$Object_OrderHead->OrderTimestamp = $this->getOrderTimestamp();
$Object_OrderHead->OrderType = 'order';
$Object_OrderHead->ResponsibleID = PlentymarketsConfig::getInstance()->getOrderUserID(null);
$Object_OrderHead->ShippingCosts = $this->getShippingCosts();
$Object_OrderHead->ShippingProfileID = $this->getParcelServicePresetId();
$Object_OrderHead->StoreID = $this->getShopId();
$Object_OrderHead->ReferrerID = $this->getReferrerId();
$Object_Order->OrderHead = $Object_OrderHead;
// Order infos
$Object_OrderHead->OrderInfos = array();
if ($Object_OrderHead->MethodOfPaymentID == MOP_DEBIT) {
$Customer = $this->Order->getCustomer();
if ($Customer) {
$Debit = $Customer->getDebit();
if ($Debit && $Debit->getAccountHolder()) {
$info = 'Account holder: ' . $Debit->getAccountHolder() . chr(10);
$info .= 'Bank name: ' . $Debit->getBankName() . chr(10);
$info .= 'Bank code: ' . $Debit->getBankCode() . chr(10);
$info .= 'Account number: ' . $Debit->getAccount() . chr(10);
$Object_OrderInfo = new PlentySoapObject_OrderInfo();
$Object_OrderInfo->Info = $info;
$Object_OrderInfo->InfoCustomer = 0;
$Object_OrderInfo->InfoDate = $this->getOrderTimestamp();
$Object_OrderHead->OrderInfos[] = $Object_OrderInfo;
}
$PaymentInstances = $Customer->getPaymentInstances();
if ($PaymentInstances) {
foreach ($PaymentInstances as $PaymentInstance) {
if ($this->Order->getId() === $PaymentInstance->getOrder()->getId()) {
$Object_BankData = new PlentySoapObject_BankData();
$Object_BankData->OwnerFirstname = $PaymentInstance->getFirstName();
$Object_BankData->OwnerLastname = $PaymentInstance->getLastName();
$Object_BankData->BankName = $PaymentInstance->getBankName();
$Object_BankData->IBAN = $PaymentInstance->getIban();
$Object_BankData->BIC = $PaymentInstance->getBic();
$Object_SetBankCreditCardData = new PlentySoapObject_SetBankCreditCardData();
$Object_SetBankCreditCardData->CustomerID = $this->PLENTY_customerID;
$Object_SetBankCreditCardData->BankData = $Object_BankData;
$Request_SetBankCreditCardData = new PlentySoapRequest_SetBankCreditCardData();
$Request_SetBankCreditCardData->CustomerData[] = $Object_SetBankCreditCardData;
$Response_SetBankCreditCardData = PlentymarketsSoapClient::getInstance()->SetBankCreditCardData($Request_SetBankCreditCardData);
if (!$Response_SetBankCreditCardData->Success) {
// Set the error end quit
$this->setError(self::CODE_ERROR_SOAP);
throw new PlentymarketsExportEntityException('The order with the number »' . $this->Order->getNumber() . '« could not be exported');
}
}
}
}
}
}
if ($this->Order->getInternalComment()) {
$Object_OrderInfo = new PlentySoapObject_OrderInfo();
$Object_OrderInfo->Info = $this->Order->getInternalComment();
$Object_OrderInfo->InfoCustomer = 0;
$Object_OrderInfo->InfoDate = $this->getOrderTimestamp();
$Object_OrderHead->OrderInfos[] = $Object_OrderInfo;
}
if ($this->Order->getCustomerComment()) {
$Object_OrderInfo = new PlentySoapObject_OrderInfo();
$Object_OrderInfo->Info = $this->Order->getCustomerComment();
$Object_OrderInfo->InfoCustomer = 1;
$Object_OrderInfo->InfoDate = $this->getOrderTimestamp();
$Object_OrderHead->OrderInfos[] = $Object_OrderInfo;
}
if ($this->Order->getComment()) {
$Object_OrderInfo = new PlentySoapObject_OrderInfo();
$Object_OrderInfo->Info = $this->Order->getComment();
$Object_OrderInfo->InfoCustomer = 1;
$Object_OrderInfo->InfoDate = $this->getOrderTimestamp();
$Object_OrderHead->OrderInfos[] = $Object_OrderInfo;
}
$Object_Order->OrderItems = array();
/** @var Shopware\Models\Order\Detail $Item */
foreach ($this->Order->getDetails() as $Item) {
$number = $Item->getArticleNumber();
$itemText = '';
// Variant
try {
$itemId = null;
try {
// get the detail id by the order number
$articleDetailID = $VariantResource->getIdFromNumber($Item->getArticleNumber());
} catch (Exception $E) {
$articleDetailID = -1;
}
// get the sku from the detail id
$sku = PlentymarketsMappingController::getItemVariantByShopwareID($articleDetailID);
} catch (PlentymarketsMappingExceptionNotExistant $E) {
// Base item
try {
$itemId = PlentymarketsMappingController::getItemByShopwareID($Item->getArticleId());
$sku = null;
} catch (PlentymarketsMappingExceptionNotExistant $E) {
$itemId = -2;
$sku = null;
// Mandatory because there will be no mapping to any item
$itemText = $Item->getArticleName();
}
}
//
if ($itemId > 0 || !empty($sku)) {
if (PlentymarketsConfig::getInstance()->getOrderItemTextSyncActionID(EXPORT_ORDER_ITEM_TEXT_SYNC) == EXPORT_ORDER_ITEM_TEXT_SYNC) {
$itemText = $Item->getArticleName();
} else {
$itemText = null;
}
}
// Coupon
if ($Item->getMode() == 2) {
$itemId = -1;
$rowType = 'Coupon';
}
// Additional coupon identifiers für 3rd party plugins
$couponIdentifiers = PyConf()->get('OrderAdditionalCouponIdentifiers', '');
$couponIdentifiers = explode('|', $couponIdentifiers);
if (in_array($number, $couponIdentifiers)) {
$itemId = -1;
$rowType = 'Coupon';
} else {
// PAYONE fix
if ($number == 'SHIPPING' && !$Object_OrderHead->ShippingCosts) {
$Object_OrderHead->ShippingCosts = $Item->getPrice();
continue;
}
$discountNumber = Shopware()->Config()->get('discountnumber');
$surchargeNumber = Shopware()->Config()->get('surchargenumber');
$paymentSurchargeNumber = Shopware()->Config()->get('paymentsurchargenumber');
$paymentSurchargeAbsoluteNumber = Shopware()->Config()->get('paymentSurchargeAbsoluteNumber');
$shippingDiscountNumber = Shopware()->Config()->get('shippingdiscountnumber');
switch ($number) {
case $paymentSurchargeNumber:
case $paymentSurchargeAbsoluteNumber:
$rowType = 'SurchargeForPaymentMethod';
break;
case $discountNumber:
$rowType = 'Discount';
break;
case $surchargeNumber:
$rowType = 'Surcharge';
break;
case $shippingDiscountNumber:
$rowType = 'SurchargeForShippingMethod';
break;
default:
$rowType = 'Default';
break;
}
}
if ($isOrderNet) {
// Calculate the gross amount (needed by plentymakets even though it is a net sales order)
$itemPrice = $Item->getPrice() * ((100 + (double) $Item->getTaxRate()) / 100);
} else {
$itemPrice = $Item->getPrice();
}
$Object_OrderItem = new PlentySoapObject_OrderItem();
$Object_OrderItem->ExternalOrderItemID = $number;
$Object_OrderItem->ItemID = $itemId;
$Object_OrderItem->ReferrerID = $Object_OrderHead->ReferrerID;
$Object_OrderItem->ItemText = $itemText;
$Object_OrderItem->Price = $itemPrice;
$Object_OrderItem->Quantity = $Item->getQuantity();
$Object_OrderItem->SKU = $sku;
$Object_OrderItem->VAT = $Item->getTaxRate();
$Object_OrderItem->RowType = $rowType;
$Object_Order->OrderItems[] = $Object_OrderItem;
}
$Request_AddOrders->Orders[] = $Object_Order;
// Do the request
$Response_AddOrders = PlentymarketsSoapClient::getInstance()->AddOrders($Request_AddOrders);
if (!$Response_AddOrders->Success) {
// Set the error end quit
$this->setError(self::CODE_ERROR_SOAP);
throw new PlentymarketsExportEntityException('The order with the number »' . $this->Order->getNumber() . '« could not be exported', 4010);
}
//
$plentyOrderID = null;
$plentyOrderStatus = 0.0;
foreach ($Response_AddOrders->ResponseMessages->item[0]->SuccessMessages->item as $SuccessMessage) {
switch ($SuccessMessage->Key) {
case 'OrderID':
$plentyOrderID = (int) $SuccessMessage->Value;
break;
case 'Status':
$plentyOrderStatus = (double) $SuccessMessage->Value;
break;
}
}
if ($plentyOrderID && $plentyOrderStatus) {
$this->setSuccess($plentyOrderID, $plentyOrderStatus);
} else {
// Set the error end quit
$this->setError(self::CODE_ERROR_SOAP);
throw new PlentymarketsExportEntityException('The order with the number »' . $this->Order->getNumber() . '« could not be exported (no order id or order status respectively)', 4020);
}
$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();
}
}
/**
* @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;
}
