/** * getting orders for the customer filtered by given data * * @param $customerToken * @param $limit * @param $offset * @param $orderDateFrom * @param $sortOrder * @return array * @throws ShopgateLibraryException */ public function getOrders($customerToken, $limit, $offset, $orderDateFrom, $sortOrder) { $relation = Mage::getModel('shopgate/customer')->loadByToken($customerToken); $response = array(); if ($relation->getId()) { $sort = str_replace('created_', '', $sortOrder); $_orders = Mage::getModel('sales/order')->getCollection()->addFieldToSelect('*'); if ($orderDateFrom) { $_orders->addFieldToFilter('created_at', array('from' => date('Y-m-d H:i:s', strtotime($orderDateFrom)))); } $_orders->addFieldToFilter('customer_id', $relation->getCustomerId())->addFieldToFilter('state', array('in' => Mage::getSingleton('sales/order_config')->getVisibleOnFrontStates()))->setOrder('created_at', $sort); $_orders->getSelect()->limit($limit, $offset); if ($_orders->count() > 0) { /** @var Mage_Sales_Model_Order $order */ foreach ($_orders as $order) { /** @var Shopgate_Framework_Model_Shopgate_Order $shopgateOrder */ $shopgateOrder = $this->_getShopgateOrderNumber($order->getId()); $shopgateExternalOrder = new ShopgateExternalOrder(); $shopgateExternalOrder->setOrderNumber($shopgateOrder ? $shopgateOrder->getShopgateOrderNumber() : null); $shopgateExternalOrder->setExternalOrderId($order->getId()); $shopgateExternalOrder->setExternalOrderNumber($order->getIncrementId()); $shopgateExternalOrder->setCreatedTime(date(DateTime::ISO8601, strtotime($order->getCreatedAt()))); $shopgateExternalOrder->setMail($order->getCustomerEmail()); $shopgateExternalOrder->setCurrency($order->getOrderCurrencyCode()); $shopgateExternalOrder->setPaymentMethod($order->getPayment()->getMethodInstance()->getTitle()); $shopgateExternalOrder->setIsPaid($shopgateOrder ? $shopgateOrder->getIsPaid() : null); $shopgateExternalOrder->setPaymentTransactionNumber($this->_getPaymentTransactionNumber($order)); $shopgateExternalOrder->setAmountComplete($order->getGrandTotal()); $shopgateExternalOrder->setInvoiceAddress($this->_getShopgateAddressFromOrderAddress($order->getBillingAddress())); $shopgateExternalOrder->setDeliveryAddress($this->_getShopgateAddressFromOrderAddress($order->getShippingAddress())); $shopgateExternalOrder->setItems($this->_getOrderItemsFormatted($order)); $shopgateExternalOrder->setOrderTaxes($this->_getOrderTaxFormatted($order)); $shopgateExternalOrder->setDeliveryNotes($this->_getDeliveryNotes($order)); $shopgateExternalOrder->setExternalCoupons($this->_getCouponsFormatted($order)); $shopgateExternalOrder->setStatusName(ucwords(str_replace('_', ' ', $order->getStatus()))); $shopgateExternalOrder->setExtraCosts($this->_getExtraCost($order)); array_push($response, $shopgateExternalOrder); } } return $response; } else { throw new ShopgateLibraryException(ShopgateLibraryException::PLUGIN_CUSTOMER_TOKEN_INVALID); } }