assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
$default_smarty->assign('session', session_id());
$main_content = '';
// include needed functions
require_once (DIR_FS_INC.'xtc_customer_greeting.inc.php');
require_once (DIR_FS_INC.'xtc_get_path.inc.php');
require_once (DIR_FS_INC.'xtc_check_categories_status.inc.php');
//BOF - Dokuman - 2009-10-02 - removed feature, due to wrong links in category on "last viewed"
//$_SESSION['lastpath'] = $_GET['cPath'];
//EOF - Dokuman - 2009-10-02 - removed feature, due to wrong links in category on "last viewed"
// 2010-04-03 - vr - refactoring and new products filter:
// - simplifiy if else nesting
// - init group check only once per branch
// - update sql statements to SQL-92-Syntax (move join conditions out of where part)
// - add products options filter
if (xtc_check_categories_status($current_category_id) >= 1) {
$error = CATEGORIE_NOT_FOUND;
include (DIR_WS_MODULES.FILENAME_ERROR_HANDLER);
return;
}
if ($category_depth == 'nested') {
if (GROUP_CHECK == 'true')
$group_check = "and c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
$category_query = "select cd.categories_description, cd.categories_name, cd.categories_heading_title,
c.categories_template, c.categories_image
from ".TABLE_CATEGORIES." c
join ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = c.categories_id
where c.categories_id = '".$current_category_id."'
".$group_check."
and cd.language_id = '".(int) $_SESSION['languages_id']."'";
$category_query = xtDBquery($category_query);
$category = xtc_db_fetch_array($category_query, true);
// subcategories ?
$categories_query = "select cd.categories_description, c.categories_id, cd.categories_name, cd.categories_heading_title,
c.categories_image, c.parent_id
from ".TABLE_CATEGORIES." c
join ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = c.categories_id
where c.categories_status = '1'
and c.parent_id = '".$current_category_id."'
".$group_check."
and cd.language_id = '".(int) $_SESSION['languages_id']."'
order by sort_order, cd.categories_name";
$categories_query = xtDBquery($categories_query);
$rows = 0;
while ($categories = xtc_db_fetch_array($categories_query, true)) {
$rows ++;
$cPath_new = xtc_category_link($categories['categories_id'], $categories['categories_name']);
$width = (int) (100 / MAX_DISPLAY_CATEGORIES_PER_ROW).'%';
$image = '';
if ($categories['categories_image'] != '') {
$image = DIR_WS_IMAGES.'categories/'.$categories['categories_image'];
// BOF - Tomcraft - 2009-10-30 - noimage.gif is displayed, when no image is defined
if(!file_exists($image)) $image = DIR_WS_IMAGES.'categories/noimage.gif';
// EOF - Tomcraft - 2009-10-30 - noimage.gif is displayed, when no image is defined
}
$categories_content[] = array ('CATEGORIES_NAME' => $categories['categories_name'],
'CATEGORIES_HEADING_TITLE' => $categories['categories_heading_title'],
'CATEGORIES_IMAGE' => $image,
'CATEGORIES_LINK' => xtc_href_link(FILENAME_DEFAULT, $cPath_new),
'CATEGORIES_DESCRIPTION' => $categories['categories_description']);
}
$new_products_category_id = $current_category_id;
include (DIR_WS_MODULES.FILENAME_NEW_PRODUCTS);
$image = '';
if ($category['categories_image'] != '')
$image = DIR_WS_IMAGES.'categories/'.$category['categories_image'];
$default_smarty->assign('CATEGORIES_NAME', $category['categories_name']);
$default_smarty->assign('CATEGORIES_HEADING_TITLE', $category['categories_heading_title']);
$default_smarty->assign('CATEGORIES_IMAGE', $image);
$default_smarty->assign('CATEGORIES_DESCRIPTION', $category['categories_description']);
$default_smarty->assign('language', $_SESSION['language']);
$default_smarty->assign('module_content', $categories_content);
// get default template
if ($category['categories_template'] == '' || $category['categories_template'] == 'default') {
$files = array ();
if ($dir = opendir(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/')) {
while (($file = readdir($dir)) !== false)
if (is_file(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/'.$file) and (substr($file, -5) == ".html") and ($file != "index.html") and (substr($file, 0, 1) !="."))
$files[] = array ('id' => $file, 'text' => $file);
closedir($dir);
}
$category['categories_template'] = $files[0]['id'];
}
$default_smarty->caching = 0;
$main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/categorie_listing/'.$category['categories_template']);
$smarty->assign('main_content', $main_content);
}
// products
elseif ($category_depth == 'products' || (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] > 0)) { //DokuMan - 2010-02-26 - Undefined index: manufacturers_id
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0')
$fsk_lock = ' and p.products_fsk18!=1';
// group check only once
if (GROUP_CHECK == 'true')
$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
// show the products of a specified manufacturer
if (isset ($_GET['manufacturers_id'])) {
if (isset ($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {
// show only products of filtered category - filter_id is a category here
// sorting query
$sorting_query = xtDBquery("select products_sorting, products_sorting2
from ".TABLE_CATEGORIES."
where categories_id='".(int) $_GET['filter_id']."'");
$sorting_data = xtc_db_fetch_array($sorting_query,true);
if (!$sorting_data['products_sorting'])
$sorting_data['products_sorting'] = 'pd.products_name';
$sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';
$listing_sql = "select DISTINCT p.products_fsk18, p.products_shippingtime, p.products_model, pd.products_name, p.products_ean,
p.products_price, p.products_tax_class_id, m.manufacturers_name, p.products_quantity, p.products_image,
p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id,
p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed,
p.products_tax_class_id
from ".TABLE_PRODUCTS_DESCRIPTION." pd
join ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = pd.products_id
join ".TABLE_PRODUCTS." p on p.products_id = p2c.products_id
join ".TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id
where p.products_status = '1'
and m.manufacturers_id = '".(int) $_GET['manufacturers_id']."'
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and p2c.categories_id = '".(int) $_GET['filter_id']."'".$sorting;
} else {
// Show products of all categories, matching given manufacturer
$listing_sql = "select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name,
p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight,
pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status,
p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id
from ".TABLE_PRODUCTS_DESCRIPTION." pd
join ".TABLE_PRODUCTS." p on p.products_id = pd.products_id
join ".TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id
where p.products_status = '1'
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and m.manufacturers_id = '".(int) $_GET['manufacturers_id']."'";
}
} else {
// show products in given category
// sorting query
$sorting_query = xtDBquery("SELECT products_sorting, products_sorting2
FROM ".TABLE_CATEGORIES."
where categories_id='".$current_category_id."'");
$sorting_data = xtc_db_fetch_array($sorting_query, true);
if (!$sorting_data['products_sorting'])
$sorting_data['products_sorting'] = 'pd.products_name';
$sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';
// ######################################################################
// option filter join sql
$option_filter_join = '';
$option_filter_ids = array();
// collect non-empty option filters
foreach ($_GET as $key => $value)
if ((substr($key, 0, 9) == 'optfilter') && !empty($value))
$option_filter_ids[] = $value;
$option_filter_ids = implode(',', $option_filter_ids);
// build filter sql to use in product queries and dropdown calculation as additional join part
if (!empty($option_filter_ids)) {
$option_filter_join = 'join (select p.products_id
from '.TABLE_PRODUCTS.' p
join '.TABLE_PRODUCTS_ATTRIBUTES.' pa on pa.products_id = p.products_id
join '.TABLE_PRODUCTS_OPTIONS_VALUES.' pv on pv.products_options_values_id = pa.options_values_id
where pa.options_values_id in (' . $option_filter_ids . ')
and pv.language_id = '.(int) $_SESSION['languages_id'].'
group by 1
having count(p.products_id) = (select count(products_options_values_id)
from '.TABLE_PRODUCTS_OPTIONS_VALUES.'
where language_id = '.(int) $_SESSION['languages_id'].'
and products_options_values_id in (' . $option_filter_ids . '))) x on x.products_id = p.products_id';
}
// ######################################################################
if (isset ($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {
// show only products of filtered manufacturer - filter_id is a manufacturer here
$listing_sql = "select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name,
p.products_id, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight,
pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_price, p.products_vpe,
p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id
from ".TABLE_PRODUCTS_DESCRIPTION." pd
join ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = pd.products_id
join ".TABLE_PRODUCTS." p on p.products_id = p2c.products_id
join ".TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id
".$option_filter_join."
where p.products_status = '1'
and m.manufacturers_id = '".(int) $_GET['filter_id']."'
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and p2c.categories_id = '".$current_category_id."'".$sorting;
} else {
// STANDARD CASE - show all products of this category, no manufacturer filter
$listing_sql = "select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name,
m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description,
pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_vpe,
p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id
from ".TABLE_PRODUCTS_DESCRIPTION." pd
join ".TABLE_PRODUCTS_TO_CATEGORIES." p2c
join ".TABLE_PRODUCTS." p
".$option_filter_join."
left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id
where p.products_status = '1'
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and p2c.categories_id = '".$current_category_id."'".$sorting;
}
}
// optional Product List Filter
if (PRODUCT_LIST_FILTER > 0) {
if (isset ($_GET['manufacturers_id'])) {
$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name
from ".TABLE_PRODUCTS." p
join ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = p.products_id
join ".TABLE_CATEGORIES." c on c.categories_id = p2c.categories_id
join ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = p2c.categories_id
where p.products_status = '1'
and cd.language_id = '".(int) $_SESSION['languages_id']."'
and p.manufacturers_id = '".(int) $_GET['manufacturers_id']."'
order by cd.categories_name";
} else {
$filterlist_sql = "select distinct m.manufacturers_id as id, m.manufacturers_name as name
from ".TABLE_PRODUCTS." p
join ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = p.products_id
join ".TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id
where p.products_status = '1'
and p2c.categories_id = '".$current_category_id."'
order by m.manufacturers_name";
}
$filterlist_query = xtDBquery($filterlist_sql);
if (xtc_db_num_rows($filterlist_query, true) > 1) {
$manufacturer_dropdown = xtc_draw_form('filter', FILENAME_DEFAULT, 'get');
if (isset ($_GET['manufacturers_id'])) {
$manufacturer_dropdown .= xtc_draw_hidden_field('manufacturers_id', (int)$_GET['manufacturers_id']);
$options = array (array ('text' => TEXT_ALL_CATEGORIES));
} else {
$manufacturer_dropdown .= xtc_draw_hidden_field('cat', $current_category_id);
$options = array (array ('text' => TEXT_ALL_MANUFACTURERS));
}
$manufacturer_dropdown .= xtc_draw_hidden_field('sort', $_GET['sort']);
$manufacturer_dropdown .= xtc_draw_hidden_field(xtc_session_name(), xtc_session_id());
while ($filterlist = xtc_db_fetch_array($filterlist_query, true))
$options[] = array ('id' => $filterlist['id'], 'text' => $filterlist['name']);
$manufacturer_dropdown .= xtc_draw_pull_down_menu('filter_id', $options, $_GET['filter_id'], 'onchange="this.form.submit()"');
$manufacturer_dropdown .= ''."\n";
}
}
// Get the right image for the top-right
$image = DIR_WS_IMAGES.'table_background_list.gif';
if (isset ($_GET['manufacturers_id'])) {
$image = xtDBquery("select manufacturers_image from ".TABLE_MANUFACTURERS." where manufacturers_id = '".(int) $_GET['manufacturers_id']."'");
$image = xtc_db_fetch_array($image,true);
$image = $image['manufacturers_image'];
}
elseif ($current_category_id) {
$image = xtDBquery("select categories_image from ".TABLE_CATEGORIES." where categories_id = '".$current_category_id."'");
$image = xtc_db_fetch_array($image,true);
$image = $image['categories_image'];
}
// ##########################################################################
// options filter for dropdowns
// $excluded_options = '10'; // comma-separated list of excluded option ids
if (!empty($excluded_options))
$excluded_options_condition = 'and po.products_options_id not in (' . $excluded_options . ')';
// modify options filter join to connect to products_attributes instead of products
$option_filter_join = str_replace('x.products_id = p.products_id', 'x.products_id = pa.products_id', $option_filter_join);
// 1. get options and values for this catgory
$filter_sql = 'select po.products_options_id options_id,
po.products_options_name options_name,
pv.products_options_values_id options_values_id,
pv.products_options_values_name options_values_name,
count(pa.products_id) option_values_count
from '.TABLE_PRODUCTS_OPTIONS.' po
join '.TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS.' pv2po on pv2po.products_options_id = po.products_options_id
join '.TABLE_PRODUCTS_OPTIONS_VALUES.' pv on pv.products_options_values_id = pv2po.products_options_values_id
join '.TABLE_PRODUCTS_ATTRIBUTES.' pa on pa.options_id = po.products_options_id and
pa.options_values_id = pv.products_options_values_id
join '.TABLE_PRODUCTS_TO_CATEGORIES.' p2c on p2c.products_id = pa.products_id
join '.TABLE_PRODUCTS.' p on p.products_id = pa.products_id
'. $option_filter_join .'
where p2c.categories_id = ' . $current_category_id . '
and po.language_id = '.(int) $_SESSION['languages_id'].'
and pv.language_id = '.(int) $_SESSION['languages_id'].'
and p.products_status = 1
'. $excluded_options_condition .'
group by 1, 2, 3, 4
order by 1, 4';
$filter_query = xtDBquery($filter_sql);
// 2. group result set in array
$option_id = 0;
while ($rec = xtc_db_fetch_array($filter_query, true)) {
// new option?
if ($option_id != $rec['options_id'])
{
$option_id = $rec['options_id'];
$filter[$option_id]['id'] = $rec['options_id'];
$filter[$option_id]['name'] = $rec['options_name'];
}
$option_values = array('id' => $rec['options_values_id'],
'name' => $rec['options_values_name'],
'count' => $rec['option_values_count']);
$filter[$option_id]['values'][] = $option_values;
}
// 3. collect url params
$url_params = $_GET;
// reset session
$url_params[xtc_session_name()] = xtc_session_id();
// remove empty params
foreach ($url_params as $key => $value)
if (empty($value)) unset($url_params[$key]);
// 4. build dropdowns
if (!empty($filter))
{
foreach ($filter as $optid => $option)
{
// init form
$dropdown = xtc_draw_form('filter'. $optid, FILENAME_DEFAULT, 'get');
// url params as hidden fields
$url_param_fields = '';
foreach ($url_params as $key => $value)
if ($key != 'optfilter'. $optid)
$url_param_fields .= xtc_draw_hidden_field($key, $value);
$dropdown .= $url_param_fields;
// init dropdown
$options = array (array ('text' => '-- ' . $option['name'] . ' --'));
foreach ($option['values'] as $key => $rec)
$options[] = array ('id' => $rec['id'], 'text' => $rec['name']);
$dropdown .= xtc_draw_pull_down_menu('optfilter'. $optid, $options, $_GET['optfilter'. $optid], 'style="float:left; width:150px; margin:5px;" onchange="this.form.submit()"');
$dropdown .= ''."\n";
$option_dropdowns[] = $dropdown;
}
// add separator
$option_dropdowns[] = '';
}
// ##########################################################################
include (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);
} else { // default page
if (GROUP_CHECK == 'true')
$group_check = "and group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";
$shop_content_query = xtDBquery("SELECT content_title, content_heading, content_text, content_file
FROM ".TABLE_CONTENT_MANAGER."
WHERE content_group='5'
".$group_check."
AND languages_id='".$_SESSION['languages_id']."'");
$shop_content_data = xtc_db_fetch_array($shop_content_query,true);
$default_smarty -> assign('title', htmlspecialchars($shop_content_data['content_heading']));
include (DIR_WS_INCLUDES.FILENAME_CENTER_MODULES);
if ($shop_content_data['content_file'] != '') {
ob_start();
if (strpos($shop_content_data['content_file'], '.txt'))
echo '';
include (DIR_FS_CATALOG.'media/content/'.$shop_content_data['content_file']);
if (strpos($shop_content_data['content_file'], '.txt'))
echo '';
$shop_content_data['content_text'] = ob_get_contents();
ob_end_clean();
}
$default_smarty->assign('text', str_replace('{$greeting}', xtc_customer_greeting(), $shop_content_data['content_text']));
$default_smarty->assign('language', $_SESSION['language']);
// set cache ID
if (!CacheCheck()) {
$default_smarty->caching = 0;
$main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html');
} else {
$default_smarty->caching = 1;
$default_smarty->cache_lifetime = CACHE_LIFETIME;
$default_smarty->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'].$_SESSION['currency'].$_SESSION['customer_id'];
$main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html', $cache_id);
}
$smarty->assign('main_content', $main_content);
}
?>