private function getMagentoCustomerByEmail($_emailAddress, $_storeID)
 {
     $_customerCountry = null;
     $_obj = new MagentoCollection();
     $_obj->getCustomerByEmailAddress($_emailAddress, $_storeID);
     $_collection = $_obj->get('collection');
     $_addressData = $_obj->get('addressdata');
     if ($_addressData['country_id']) {
         $_customerCountry = $_obj->getCustomerCountry($_addressData['country_id']);
     }
     unset($_obj);
     $this->set('collection', $_collection);
     $this->set('addressdata', $_addressData);
     $this->set('customercountry', $_customerCountry);
 }
 private function getMagentoOrderByID($_orderID, $_storeID)
 {
     $_obj = new MagentoCollection();
     $_obj->getOrdersByOrderID($_orderID, $_storeID);
     $_collection = $_obj->get('collection');
     unset($_obj);
     $this->set('collection', $_collection);
 }
    function getOrdersHTML()
    {
        $_ULHtml = '';
        $_count = 0;
        $_todayCount = 0;
        $_obj = new MagentoCollection();
        $_storeID = $this->get('storeid');
        $_obj->getOrdersByDate($this->get('ordertimerange'));
        $_collection = $_obj->get('collection');
        unset($_obj);
        // -- iterate magento product collection
        foreach ($_collection as $order) {
            $_today = false;
            $_orderAlert = false;
            $_count++;
            $_orderID = $order->getIncrementId();
            $_orderStatus = $order->getStatus();
            if ($_orderStatus != 'complete') {
                $_orderAlert = true;
            }
            $_orderCreatedAt = $order->getCreatedAt();
            $_orderCreatedAtArray = explode(' ', $_orderCreatedAt);
            if ($_orderCreatedAtArray[0] === date('Y-m-d')) {
                $_today = true;
                $_todayCount++;
            }
            // add timezone to date and reformat to dd-mm-yyyy
            $_orderCreatedAt = strtotime($_orderCreatedAt);
            date_default_timezone_set($this->get('timezone'));
            $_orderCreatedAt = date('d-m-Y H:i:s', $_orderCreatedAt);
            $_orderAcknowledged = false;
            if (file_exists($this->get('cachefolder') . md5($_orderID) . 'MageInvoice')) {
                $_orderAckTime = date("F d Y H:i:s", filemtime($this->get('cachefolder') . md5($_orderID) . 'MageInvoice'));
                $_orderAcknowledged = true;
            }
            $_ULHtml = $_ULHtml . '
			<li id="order-' . $_orderID . '">' . ($_orderStatus != 'canceled' ? '<input type="checkbox" class="' . ($_orderAcknowledged ? 'form_1_order_ul_select_order_ack' : 'form_1_order_ul_select_order_notack') . '" name="form_1_order_ul_select_order" value="' . $_orderID . '">' : '') . '
						<a href="#">
							<div class="ordercontainer">
								<div class="ordericon">
									<img class="infotip" width="64" alt="Order ' . $_orderID . '" title="Order ' . $_orderID . '" id="order-icon-' . $_orderID . '" src="images/order-icon.png"><span class="textBlah">' . $_orderID . '</span>
								</div>
								<div class="ordertext"><img width="32" title="' . $this->__t->__('Customer info') . '" class="customerinfo clickable infotip" src="images/customerdata-icon.png" data-id="' . $order->getCustomer_email() . '"> ' . ($_orderAcknowledged ? '<img class="infotip printed" title="' . $this->__t->__('Printed') . ' ' . $_orderAckTime . '" alt="' . $this->__t->__('Printed') . ' ' . $_orderAckTime . '" width="32" src="images/printed-icon.png"><em> ' : '') . '<span class="capitalize">' . $order->getBillingAddress()->getName() . '</span> - <span class="customeremail">' . $order->getCustomer_email() . '</span> - ' . $_orderStatus . ' - <span class="infotip" title="TZ ' . $this->get('timezone') . '">' . $_orderCreatedAt . '</span>' . ($_orderAcknowledged ? '</em>  ' : '  ') . ($_today ? '<img class="infotip" title="' . $this->__t->__('Today') . '" alt="' . $this->__t->__('Today') . '" class="today-icon" width="32" src="images/today-icon.png">' : '') . ' ' . ($_orderAlert ? '<img class="infotip" title="' . $this->__t->__('Order not complete') . '" alt="' . $this->__t->__('Order not complete') . '" width="32" src="images/warning-icon2.png">' : '') . '</div>
							</div>
						</a>
			</li>';
        }
        $this->set('orderulhtml', '
			<p>' . $_count . ' ' . $this->__t->__('Order/s') . ' | ' . $_todayCount . ' ' . $this->__t->__('Today') . ' | <span id="ordertimerange" class="edit_time_range">' . $this->get('ordertimerange') . '</span> ' . $this->__t->__('Day/s') . '</p>
			<ul id="form_1_order_ul" class="order_ul">' . ($_count == 0 ? '<li>' . $this->__t->__('No Orders Found') . '</li>' : '
			<li><input type="checkbox" id="form_1_order_ul_select_allorders" name="form_1_order_ul_select_allorders" value="null"><span class="textSmall">' . $this->__t->__('Select All') . '</span>  <input type="checkbox" id="form_1_order_ul_select_allorders_notack" name="form_1_order_ul_select_allorders_notack" value="null"><span class="textSmall">' . $this->__t->__('Select Not Printed') . '</span>
			</li>
			' . $_ULHtml) . '
			</ul>');
    }
 /**
  * getProductCollection function.
  * -- gets Magento product collection
  * @access private
  * @param mixed $_collectionType
  * @return void
  */
 private function getProductCollection($_collectionType)
 {
     $_storeID = $this->get('storeid');
     // -- Load Magento --
     $_obj = new MagentoCollection($_storeID);
     $_collectionPage = $this->get('collectionpage');
     $_categoryID = $this->get('categoryid');
     $_collectionLimit = $this->get('productlimit');
     switch ($_collectionType) {
         case 'newfromdate':
             $_obj->getNewProducts($_storeID, (int) $_collectionPage, (int) $_collectionLimit);
             $this->set('selectedcollectionname', $this->__t->__('New Products'));
             break;
         case 'allproducts':
             $_obj->getAllProducts($_storeID, (int) $_collectionPage, (int) $_collectionLimit);
             $this->set('selectedcollectionname', $this->__t->__('All Products'));
             break;
         case 'categoryproducts':
             $_obj->getCategoryProducts($_storeID, (int) $_categoryID, (int) $_collectionPage, (int) $_collectionLimit);
             $this->set('selectedcollectionname', $this->__t->__('Category Products'));
             break;
         case 'bestselling':
             $_obj->getBestsellingProducts($_storeID);
             $this->set('selectedcollectionname', $this->__t->__('Bestselling Products'));
             break;
         default:
             throw new Exception('Invalid collection type.');
     }
     // -- load Magento Product Collection
     $_collection = $_obj->get('collection');
     $_imageBaseURL = $_obj->get('baseurlmedia') . 'catalog/product';
     $this->set('imagebaseurl', $_imageBaseURL);
     $this->set('collection', $_collection);
     // load categories and category product count used for menu
     if ($this->get('showmenu')) {
         $this->set('categories', $_obj->get('categories'));
         $this->set('categoriesproductcount', $_obj->get('categoriesproductcount'));
     }
     // -- Unload Magento
     unset($_collection);
     unset($_obj);
 }