function ShowAttributesTable($product_id)
{
global $languages_id;
$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int) $product_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);
if ($products_attributes['total'] > 0) {
$output = '<table border="0" cellspacing="1" cellpadding="7" width="180">';
$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int) $product_id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int) $languages_id . "' order by popt.products_options_name");
$count = 0;
while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
$count++;
$products_options_array = array();
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int) $product_id . "' and pa.options_id = '" . (int) $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int) $languages_id . "'");
while ($products_options = tep_db_fetch_array($products_options_query)) {
$stock = GetStockMaat($product_id, $products_options['products_options_values_name'], SOAP_STOCK_TYPE);
if ($stock > 0) {
$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name'] . ' (' . GetStockMaat($product_id, $products_options['products_options_values_name'], SOAP_STOCK_TYPE) . ' op voorraad)');
} else {
$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name'] . ' (niet op voorraad)');
}
if ($products_options['options_values_price'] != '0') {
$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[$product_id]['attributes'][$products_options_name['products_options_id']])) {
$selected_attribute = $cart->contents[$product_id]['attributes'][$products_options_name['products_options_id']];
} else {
$selected_attribute = false;
}
if (!empty($products_options_array)) {
$output .= '<tr>';
$output .= '<td class="main">' . $products_options_name['products_options_name'] . ':</td>';
$output .= '<td class="main">' . tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute) . '</td>';
$output .= '</tr>';
}
}
$output .= '</table>';
}
return $output;
}
echo $listing['products_technical'];
?>
</div>
<?php
} else {
if ($list_config['configuration_key'] == 'PRODUCT_' . $listtype . '_MANUFACTURER') {
?>
<div class="product-manufacturer"><?php
echo $listing['manufacturers_name'];
?>
</div>
<?php
} else {
if ($list_config['configuration_key'] == 'PRODUCT_' . $listtype . '_QUANTITY') {
if (SOAP_STATUS == 'true' && SOAP_STOCK == 'true') {
$voorraad = GetStockMaat($listing['products_id'], '', SOAP_STOCK_TYPE);
} else {
$voorraad = $listing['products_quantity'];
}
if ($voorraad > 0) {
?>
<div class="product-quantity available"><?php
echo Translate('Beschikbaar');
?>
</div>
<?php
} else {
?>
<div class="product-quantity unavailable"><?php
echo Translate('Niet beschikbaar');
?>
if (isset($product_opt['products_opt1']) && $product_opt['products_opt1'] != '') {
$optie = ' - ' . $product_opt['products_opt1'];
} else {
$optie = '';
}
if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
reset($products[$i]['attributes']);
while (list($option, $value) = each($products[$i]['attributes'])) {
$products_optie = $products[$i][$option]['products_options_values_name'];
}
}
$products_out_of_stock = '';
$products_name = '';
if (STOCK_CHECK == 'true') {
if (SOAP_STATUS == 'true' && SOAP_STOCK == 'true') {
if (GetStockMaat($products[$i]['id'], $products_optie, SOAP_STOCK_TYPE) < $products[$i]['quantity']) {
$any_out_of_stock = 1;
$products_out_of_stock = '<span class="stockWarning">' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . '</span> ';
} else {
$products_out_of_stock = ' ';
}
} else {
$stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity']);
if (tep_not_null($stock_check)) {
$any_out_of_stock = 1;
$products_name .= $stock_check;
}
}
}
// $products_name .= $products_out_of_stock.'<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '" class="prodlist_name"><b>' . $products[$i]['name'] . '</b></a>';
// nikhil starts
