0 "); while ($source_product = tep_db_fetch_array($source_query)) { // Build url. $url_301 = $source_product['domain_name'] . '/product_info.php?products_id=' . $source_product['source_products_id']; header("HTTP/1.1 301 Moved Permanently"); header("Location: " . $url_301); exit(); } } $detect = new Mobile_Detect(); $baco= false; $price = ''; if (isset($_GET['baco'])) { $product_info_query = tep_db_query("select p.*, pd.* from " . TABLE_CENTRAL_PRODUCTS . " p, " . TABLE_CENTRAL_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); if (!empty($product_info)) { // redirect to superdeal. $url_301 = $product_info['domain_name'] . '/superdeal'; header("HTTP/1.1 301 Moved Permanently"); header("Location: " . $url_301); exit(); } // @todo get dropship stock for baco //$product_info['products_quantity'] = getTotalStock(); $is_baco = true; $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); if ($new_price = tep_get_products_special_price($product_info['products_id'], true)) { $products_special_price = displayDecimalPrice($currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))); } // $products_price = '' . displayDecimalPrice($currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))) . ' ' . displayDecimalPrice($currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))) . ''; $products_name = $product_info['products_name']; $page_meta_title = $products_name . " is een absolute superdeal! Profiteer nu van deze aanbieding!"; $page_meta_description = "Wij hebben een superdeal gemaakt van " .$products_name . "! Voor jou een geweldige kans om dit product voor een voordelige prijs uit te proberen."; if ($product_info['products_meta_keywords'] != ""){ $page_meta_keywords = $product_info['products_meta_keywords']; }else{ $page_meta_keywords = $products_name; } if ($product_info['products_image_med']!='') { $new_image = $product_info['products_image_med']; $image_width = MEDIUM_IMAGE_WIDTH; $image_height = MEDIUM_IMAGE_HEIGHT; } else { $new_image = $product_info['products_image']; $image_width = SMALL_IMAGE_WIDTH; $image_height = SMALL_IMAGE_HEIGHT; } $products_attributes_query = tep_db_query("select count(*) as total, sum(products_ischaracteristic) as total_ischaracteristic from " . TABLE_CENTRAL_PRODUCTS_OPTIONS . " popt, " . TABLE_CENTRAL_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); $baco = true; $icon = theme_icon('superdeal', 'right'); $reviews_query = tep_db_query("select DISTINCT r.reviews_id, rd.host_id, r.products_model, rd.host_response, h.host_image, h.host_firstname, rd.reviews_text as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image_med, r.customers_name from " . TABLE_CENTRAL_REVIEWS . " r inner join " . TABLE_CENTRAL_REVIEWS_DESCRIPTION . " rd on rd.reviews_id = r.reviews_id inner join " . TABLE_CENTRAL_PRODUCTS . " p on p.products_model = r.products_model inner join " . TABLE_CENTRAL_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id left outer join " . TABLE_CENTRAL_REVIEWS_HOST. " h on h.host_id = rd.host_id where r.products_model = '" . $product_info['products_model'] . "' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "' GROUP BY r.reviews_id order by r.date_added DESC"); } elseif ($product_check['total'] > 0) { $product_info_query = tep_db_query("select p.*, pd.* from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); $product_exists = TRUE; // Check for a redirect. if (isset($product_info['redirect']) && !empty($product_info['redirect'])) { setRedirect($product_info['redirect']); } $product_info['products_quantity'] = getTotalStock($product_info['products_quantity'], $product_info['products_model'], $product_info['erp_unit_code']); $reviews_query = tep_db_query("select r.reviews_id, rd.host_id, r.products_model, rd.host_response, h.host_image, h.host_firstname, rd.reviews_text as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image_med, r.customers_name from " . TABLE_CENTRAL_REVIEWS . " r inner join " . TABLE_CENTRAL_REVIEWS_DESCRIPTION . " rd on rd.reviews_id = r.reviews_id inner join " . TABLE_PRODUCTS . " p on p.products_model = r.products_model inner join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id left outer join " . TABLE_CENTRAL_REVIEWS_HOST. " h on h.host_id = rd.host_id where r.products_model = '" . $product_info['products_model'] . "' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "' order by r.date_added DESC"); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if (EASY_USE_RELATEDPRODUCTS == 'Yes'){ $product_relatedprod = tep_db_query(" SELECT count(*) as total FROM " . TABLE_PRODUCTS_RELATED_PRODUCTS . " prp INNER JOIN " . TABLE_PRODUCTS . " p ON p.products_id = prp.pop_products_id_slave WHERE prp.pop_products_id_master = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND p.products_status = 1 "); $product_relatedcheck = tep_db_fetch_array($product_relatedprod); } if (USE_PRODUCTS_DISCOUNT_PACKAGES == 'Yes'){ $product_discountpackprods = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_DISCOUNT_BUNDLE . " where pdb_products_id_master = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $product_discountpackcheck = tep_db_fetch_array($product_discountpackprods); } if(EASY_USE_EXTRAFIELDS == 'Yes'){ // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_display = ""; $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". $product_info['products_id'] ." and ptf.products_extra_fields_value <>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); // END: Extra Fields Contribution v2.0b - mintpeel display fix } if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // JRUST, discount icons if($product_info['products_topproduct'] > 0){ $icon = theme_icon('topper', 'right'); }else{ //$icon = theme_icon('korting'); $icon = ''; } $clean_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $clean_special_price = $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])); $products_price = displayDecimalPrice($clean_price); $products_special_price = displayDecimalPrice($clean_special_price); $products_price_tax = number_format($new_price+ ($new_price/100) * tep_get_tax_rate($product_info['products_tax_class_id']),2); } else { $icon = ''; $new_price = $product_info['products_price']; // new_price = same as products_price because there's no special/discount $clean_price = $new_price; $products_price = draw_inline_content_edit("product", "price", $product_info['products_id'], $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))); $products_price_tax = number_format($product_info['products_price'] + ($product_info['products_price']/100) * tep_get_tax_rate($product_info['products_tax_class_id']),2); }// end $new_price = tep_get_products_special_price($product_info['products_id']) $products_name = $product_info['products_name']; $page_meta_title = ""; if ($product_info['products_meta_title'] != ""){ $page_meta_title .= $product_info['products_meta_title']; } else{ $page_meta_title .= $products_name; } if ($product_info['products_meta_keywords'] != ""){ $page_meta_keywords = $product_info['products_meta_keywords']; } else{ $page_meta_keywords = $products_name; } if ($product_info['products_meta_description'] != ""){ $page_meta_description = $product_info['products_meta_description']; } else{ $page_meta_description = "Koop ".$products_name; } if ($product_info['products_image_med']!='') { $new_image = $product_info['products_image_med']; $image_width = MEDIUM_IMAGE_WIDTH; $image_height = MEDIUM_IMAGE_HEIGHT; } else { $new_image = $product_info['products_image']; $image_width = SMALL_IMAGE_WIDTH; $image_height = SMALL_IMAGE_HEIGHT; }// end $product_info['products_image_med']!='' }//end $product_check['total'] > 0 // Show 404 header if product not exists. if ($product_check['total'] < 1 && !$baco ) { // Check for a (301) redirect. if (is_numeric($_GET['products_id'])) { $redirect = tep_db_fetch_array(tep_db_query(" SELECT redirect FROM " . TABLE_PRODUCTS . " WHERE products_id = " . $_GET['products_id'] . " AND redirect != '' ")); if ($redirect) { setRedirect($redirect['redirect']); } } // No redirect found, show the 404 / page not found page. header("HTTP/1.0 404 Not Found"); $product_exists = FALSE; } // Get reviews for this product. $query_overview = tep_db_query("SELECT count(1) as totalreviews, AVG(reviews_rating) as average FROM " . TABLE_CENTRAL_REVIEWS . " WHERE products_model = '" . $product_info['products_model'] . "'"); $reviews_overview = tep_db_fetch_array($query_overview); // Get the colors for this product. $colors = get_products_colors($product_info['products_id']); ob_start(); ?>
TEXT_PRODUCT_NOT_FOUND, 'content' => EASY_PRODUCT_NOT_FOUND_TEXT, 'content_2' => EASY_PRODUCT_NOT_FOUND_TEXT2, 'search_url' => FILENAME_ADVANCED_SEARCH_RESULT, 'placeholder_search' => EASY_PRODUCT_NOT_FOUND_PLACEHOLDER_SEARCH, ); print page_not_found_search_box($search_box); } else { if (!$baco) { $products_attributes_query = tep_db_query("select count(*) as total, sum(products_ischaracteristic) as total_ischaracteristic from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); } //prevent ?vcp or other wrong parameters after the ID $xsell_products = get_xsell_products(strtok($_GET["products_id"], '?')); // MvD create extra links (review stars / xsell etc.). $extra_h1_links = get_extra_product_h1_links($reviews_overview, $product_relatedcheck, $xsell_products); ?>
' . $extra_h1_links . '
'; } ?>
isMobile()) { ?>
isMobile()) { if (EASY_USE_PRODUCTICONS == "Yes") { print '
' . get_productsIconCategories($product_info['products_id']) . '
'; } print showProductsTabs($product_discountpackcheck, $product_info, $extra_fields_query, $reviews_query, $products_name, $products_attributes, $baco, $new_price, $currencies, $xsell_products); } ?>

' . $extra_h1_links . '
'; } ?>
0% btw in Nederland
'; } else { $info = ''; if (!tep_session_is_registered('price_includes_vat')) { $info .= EASY_EX_BTW; } else { $info .= EASY_INCL_BTW; } $info .= ''; } echo format_prices($clean_special_price, $clean_price, $product_info['products_tax_class_id'], false, $info, true); ?>
'; print $product_info['redirect_text']; print '
'; } ?>
' . EASY_TEXT_VIEW_SIZE_CHART . ''; } if ($product_info['products_has_characteristic_attr']) { // Get stock / delivery information. if (isset($_GET['products_id'])) { echo "" . $info_label . "
"; print get_product_delivery($_GET['products_id'], $products_attributes, $product_info, $languages_id, false, $baco, "select"); } } ?>
0) { $counter = 1; ?> $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { if (tep_session_is_registered('price_includes_vat')) { $products_options_array[sizeof($products_options_array) - 1]['text'] .= ' (' . $products_options['price_prefix'] . tep_add_tax($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id']), true) . ')'; } else { $products_options_array[sizeof($products_options_array) - 1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . ')'; } } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } if (sizeof($products_options_array) == 1) { echo ""; }else{ $counter++; // only ++ counter when there's something to display $productinfo_select_size = "productinfo_select_size"; if ($products_options_name['products_options_name'] === "Kleur") { $info_label = "Kleur"; } if ($products_options_name['products_options_name'] === "Type filter") { $info_label = "Type filter"; } //this is to prevent two dropdowns with same value if ($products_options_name['products_options_name'] === "Verstelbaar" || $products_options_name['products_options_name'] === "Type filter" || $products_options_name['products_options_name'] === "Afmeting" || $products_options_name['products_options_name'] === "Leesgedeelte" ) { $productinfo_select_size = "productinfo_select_size".$counter; $is_multiple_attribute_item = true; } if ($products_options_name['products_options_name'] === "Miller Relief Step" || $products_options_name['products_options_name'] === "Anticondens brillendoekje" ) { $productinfo_select_size = "productinfo_select_size".$counter; } //temporary fix for Peltor G3000 and some other products with many attributes to prevent 3 dropdowns, this is w/h stock if($counter > 2 && ($products_options_name['products_options_name'] === "Verstelbaar" || $products_options_name['products_options_name'] === "Riemclip" || $products_options_name['products_options_name'] === "Etui" || $products_options_name['products_options_name'] === "Type filter" || $products_options_name['products_options_name'] === "Hygiƫne Set" || $products_options_name['products_options_name'] === "Opbergkokertje" || $products_options_name['products_options_name'] === "Vizier" || $products_options_name['products_options_name'] === "Neklap" || $products_options_name['products_options_name'] === "Kinriem" || $products_options_name['products_options_name'] === "NOIZEZZ Transparant Draagkoordje" || $products_options_name['products_options_name'] === "Alpine kokertje" || $products_options_name['products_options_name'] === "Alpine Slaapmasker" || $products_options_name['products_options_name'] === "Schoonmaakdoekjes")) { $is_multiple_attribute_item = true; $productinfo_select_size = "productinfo_select_size".$counter; } //this is needed for the attributes which were merges with stock delivery dropdown to prevent double dropdowns if(strpos(strtolower($products_options_name['products_options_name']), 'maat') === false && strpos(strtolower($products_options_name['products_options_name']), 'ventiel') === false && strpos(strtolower($products_options_name['products_options_name']), 'afmeting') === false && strpos(strtolower($products_options_name['products_options_name']), 'grofte') === false && strpos(strtolower($products_options_name['products_options_name']), 'kabellengte') === false && strpos(strtolower($stock_status), 'univet') === false && strpos(strtolower($products_options_name['products_options_name']), 'kleur') === false ) { ?>
'; print '
' . ucfirst(EASY_COLOR) . '
'; print '
'; $firstColor = true; // Loop over the colors for this product. foreach ($colors as $color) { // Check if color exists. if (array_key_exists($color['colors_id'], $all_colors)) { // Color image $color_image = $all_colors[$color['colors_id']]['colors_image']; // Create input. // Check if this is the first, select te first color as default. $colorChecked = ''; if ($firstColor) { $colorChecked = ' checked '; } print '
'; print ''; print ' '; print '
'; $firstColor = false; } } print '
'; print '
'; } if (!empty($stock_status_message)) { print '
'; print '
'; print 'Levertijd: '; print '
'; print '
'; print $stock_status_message; print '
'; print '
'; } if (!empty($stock_status) && $is_multiple_attribute_item == false) { print '
'; print '
'; if (empty($product_info['products_custom_stock_message'])) { print $info_label; } else { print 'Taille / options'; } print '
'; print '
'; show_trobber(); print $stock_status; print '
'; print '
'; } ?>
- +
'; print EASY_MSG_PRODUCT_NOT_AVAILABLE_CHECK; } ?>
'') { echo '
'; // Link to the admin, only for the Coolsafety location / ipaddress. $adm_link = ''; if (is_coolsafety()) { $adm_link = ' '; if ($baco) { $adm_link = ' '; } } echo '
' . EASY_MODELNUMBER . ':
' . str_replace("21.01","",$product_info['products_model']) . $adm_link . '
'; echo '
'; } ?> 1) { $show_more_items = true; echo '
'; echo '
Bestellen:
per ' . $product_info['products_selling_amount'] . ' stuks
'; echo '
'; } ?> '') { $productUrlAttachment = DIR_FILES_ALL .'/' . $product_info['products_url']; if (preg_match("/http/", $product_info['products_url'])) { $productUrlAttachment = $product_info['products_url']; } echo '
'; echo '
' . EASY_BROCHURE . ':
'; echo '
'; } ?> '; echo '
Merk:
'; $manufacturer = get_manufacturers($product_info['manufacturers_id'], $baco); if ($manufacturer['manufacturers_image2']) { //echo ' '; } echo $manufacturer['manufacturers_name']; echo '
'; echo '
'; } ?>
' . EASY_PRICE_IN_BTW . ':
' . $products_price_tax; ?>
'' ) { $show_more_items = true; echo '
'; echo '
Fabrikantcode:
' . $product_info['products_manucode'] . '
'; echo '
'; } ?> '' && $product_info['products_ean'] != '0') { echo '
'; echo '
EAN:
' . $product_info['products_ean'] . '
'; echo '
'; } ?> '; echo '
' . TEXT_TAB_REVIEWS . ':
'; echo '
'; } ?>
isMobile()) { $description = replace_tokens($product_info['products_description']); print '
' . $description . '
'; } ?>
0 && EASY_USE_EASY_SAMPLE == "Yes" && ($customer_is_company == 1 || !tep_session_is_registered('customer_id'))){ $product_name = str_replace(' | ', ' | ', $product_info['products_name']); $sample_url = 'sample.php?sample=' . $product_info['products_model']; print '
Vraag een sample aan!
'; } ?> 0){ ?>
0){ ?>

Combineren met


Wij hebben al voor je uitgezocht met welke artikelen dit product gecombineerd kan worden.

0 && EASY_USE_EASY_SAMPLE == "Yes"){ ?>
Sample van de
Wil je dit product uit onze webshop eerst zelf zien, voelen, ervaren of uitproberen? Geen probleem! Bedrijven kunnen eenvoudig met behulp van een aanvraagformulier het sample aanvragen. Wij zorgen dan dat deze zo snel mogelijk wordt toegestuurd. Klik hier om een gratis sample aan te vragen. We zijn benieuwd naar je bevindingen!
isMobile()) { print ''; } ?> isMobile()) { if (EASY_USE_PRODUCTICONS == "Yes") { print '
' . get_productsIconCategories($product_info['products_id']) . '
'; } print showProductsTabs($product_discountpackcheck, $product_info, $extra_fields_query, $reviews_query, $products_name, $products_attributes, $baco, $new_price, $currencies, $xsell_products); } } ?>
'product_page', 'utm_medium' => 'website', 'utm_campaign' => 'thumbs_up_down', 'utm_content' => array('up', 'down') ); //print '

Wat vind je van deze pagina?

' . thumbsUpDown('product_page', $utm) . '
'; ?>
$product['products_name'], 'value' => round($price, 2), 'currency' => 'EUR', 'content_ids' => $product['products_model'], 'content_type' => 'product' ); if ($pixel = showFacebookPixelEvent('ViewContent', $fbArguments)) { print $pixel; } } ?>