OpenCart Community

Code: Select all

			foreach ($order_product_query->rows as $product) {
				$option_data = array();
				$order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
				
				foreach ($order_option_query->rows as $option) {
					$option_data[] = array(
						'name'  => $option['name'],
						'value' => $option['value']
					);
				}
			  
				$template->data['products'][] = array(
					'name'     => $product['name'],
					'model'    => $product['model'],
					'option'   => $option_data,
					'quantity' => $product['quantity'],
					'price'    => $this->currency->format($product['price'], $order_query->row['currency'], $order_query->row['value']),
					'total'    => $this->currency->format($product['total'], $order_query->row['currency'], $order_query->row['value'])
				);
			}

Code: Select all

      $overeno_data = array();				
			foreach ($order_product_query->rows as $product) {
				$option_data = array();
        $overeno_data[] = $product['name'];  				
				$order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
				
				foreach ($order_option_query->rows as $option) {
					$option_data[] = array(
						'name'  => $option['name'],
						'value' => $option['value']
					);
				}
			  
				$template->data['products'][] = array(
					'name'     => $product['name'],
					'model'    => $product['model'],
					'option'   => $option_data,
					'quantity' => $product['quantity'],
					'price'    => $this->currency->format($product['price'], $order_query->row['currency'], $order_query->row['value']),
					'total'    => $this->currency->format($product['total'], $order_query->row['currency'], $order_query->row['value'])
				);
			}
	
		require_once 'HeurekaOvereno.php';
     
    try  {
        $overeno = new HeurekaOvereno('564c588731cff8111503f2e8036512d0');
                         
        $overeno->setEmail($order_query->row['email']);
        foreach ($overeno_data as $overeno_name) {
          $overeno->addProduct($overeno_name);
        } 
        $overeno->send();
    } catch (Exception $e) {
        print $e->getMessage();
    }

Code: Select all

$overeno_data = array(); // Heureka				
				
			foreach ($order_product_query->rows as $product) {
				$option_data = array();
        $overeno_data[] = $product['name']; // Heureka  				
				
				$order_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
				
				foreach ($order_option_query->rows as $option) {
					if ($option['type'] != 'file') {
						$option_data[] = array(
							'name'  => $option['name'],
							'value' => (strlen($option['value']) > 20 ? substr($option['value'], 0, 20) . '..' : $option['value'])
						);
					} else {
						$filename = substr($option['value'], 0, strrpos($option['value'], '.'));
						
						$option_data[] = array(
							'name'  => $option['name'],
							'value' => (strlen($filename) > 20 ? substr($filename, 0, 20) . '..' : $filename)
						);	
					}
				}
			  
				$template->data['products'][] = array(
					'name'     => $product['name'],
					'model'    => $product['model'],
					'option'   => $option_data,
					'quantity' => $product['quantity'],
					'price'    => $this->currency->format($product['price'], $order_info['currency_code'], $order_info['currency_value']),
					'total'    => $this->currency->format($product['total'], $order_info['currency_code'], $order_info['currency_value'])
				);
			}

  		require_once 'HeurekaOvereno.php'; // Heureka begin 
     
      try  {
        $overeno = new HeurekaOvereno('váš-kod!!!!');
                         
        $overeno->setEmail($order_info['email']);
        foreach ($overeno_data as $overeno_name) {
          $overeno->addProduct($overeno_name);
        } 
        $overeno->send();
      } catch (Exception $e) {
        print $e->getMessage();
      } // Heureka end

Code: Select all

http://www.heureka.cz/direct/dokumenty/overeno-zakazniky-implementace.zip