OpenCart Community

Code: Select all

http://forum.opencart.com/viewtopic.php?f=89&t=6281

Code: Select all

          $query_product_option = $db->query("SELECT ov.quantity, ov.price, ovd.name as value, od.name " .
                                                       "FROM " . DB_PREFIX . "product_option_value ov, " .
                                                                 DB_PREFIX . "product_option_value_description ovd, " .
                                                                 DB_PREFIX . "product_option_description od " .
                                                       "WHERE ov.product_option_value_id = ovd.product_option_value_id AND " .
                                                             "ov.product_option_id = od.product_option_id AND " .
                                                             "od.product_id = '" . $product['product_id'] . "' AND " .
                                                             "od.language_id='5'");

Code: Select all

    od.language_id='5'

Code: Select all

"od.language_id='".$lang."'");

Code: Select all

$config = new Config();

        define('HTTP_SERVER', $config->get('config_url'));
        define('HTTP_IMAGE', HTTP_SERVER . 'image/');

        if ($config->get('config_ssl')) {
                define('HTTPS_SERVER', 'https://' . substr($config->get('config_url'), 0, 7));
                define('HTTPS_IMAGE', HTTPS_SERVER . 'image/');
        } else {
                //define('HTTPS_SERVER', HTTP_SERVER);
                define('HTTPS_SERVER', 'http://www.domena.cz/');//uprava
                //define('HTTPS_IMAGE', HTTP_IMAGE);
                define('HTTPS_IMAGE', 'http://www.domena.cz/image/');//uprava

Code: Select all

            // VARIANT
		foreach ($query_product_option->rows as $product_option) {
			echo("<VARIANT>");
			echo("<PRODUCTNAMEEXT>" . product_name($product_option['name']) . ": " . product_name($product_option['value']) . "</PRODUCTNAMEEXT>");
			if ($product_option['quantity']>0) {
                                // zboží na skladě
                                // echo("<DELIVERY_DATE>0</DELIVERY_DATE>");
                        } else {
                                // zboží není na skladě
                             //    echo("<DELIVERY_DATE>" . product_delivery_date($stock_status) . "</DELIVERY_DATE>");
                        }
  		if (!$product['tax_class_id'] == 0) {
                        echo_prices($product_price, $tax_rate);
  		} else {
	  		echo("<PRICE_VAT>".round($product_price + $product_option_value['prefix'] +  $product_option_value['price'],2)."</PRICE_VAT>");    //uprava
  		}
                echo("</VARIANT>\n");
		}

Code: Select all

echo("<PRICE_VAT>".round($product_price + $product_option_value['prefix'] +  $product_option_value['price'],2)."</PRICE_VAT>"); //uprava