<?php
/**
* SNAF version 1.0
* Featured Products
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: header_php.php 6912 2007-09-02 02:23:45Z drbyte $
*/
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
$disp_order_default = PRODUCT_FEATURED_LIST_SORT_DEFAULT;
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
$featured_products_array = array();
$featured_products_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id
FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " .
TABLE_PRODUCTS_DESCRIPTION . " pd
LEFT JOIN " . TABLE_FEATURED . " f on pd.products_id = f.products_id )
WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1
AND p.products_id = pd.products_id and pd.language_id = :languagesID " .
$order_by;
$featured_products_query_raw = $db->bindVars($featured_products_query_raw, ':languagesID', $_SESSION['languages_id'], 'integer');
$featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS);
//check to see if we are in normal mode ... not showcase, not maintenance, etc
$show_submit = zen_run_normal();
// check whether to use multiple-add-to-cart, and whether top or bottom buttons are displayed
if (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) {
// check how many rows
$check_products_all = $db->Execute($featured_products_split->sql_query);
$how_many = 0;
while (!$check_products_all->EOF) {
if (zen_has_product_attributes($check_products_all->fields['products_id'])) {
} else {
// needs a better check v1.3.1
if ($check_products_all->fields['products_qty_box_status'] != 0) {
if (zen_get_products_allow_add_to_cart($check_products_all->fields['products_id']) !='N') {
if ($check_products_all->fields['product_is_call'] == 0) {
if ((SHOW_PRODUCTS_SOLD_OUT_IMAGE == 1 and $check_products_all->fields['products_quantity'] > 0) or SHOW_PRODUCTS_SOLD_OUT_IMAGE == 0) {
if ($check_products_all->fields['products_type'] != 3) {
if (zen_has_product_attributes($check_products_all->fields['products_id']) < 1) {
$how_many++;
}
}
}
}
}
}
}
$check_products_all->MoveNext();
}
if ( (($how_many > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) and (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART == 1 or  PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {
$show_top_submit_button = true;
} else {
$show_top_submit_button = false;
}
if ( (($how_many > 0 and $show_submit == true and $featured_products_split->number_of_rows > 0) and (PRODUCT_FEATURED_LISTING_MULTIPLE_ADD_TO_CART >= 2)) ) {
$show_bottom_submit_button = true;
} else {
$show_bottom_submit_button = false;
}
}
//===========  bof SNAF (set up for product listing)
$use_product_listing = false;
if(zen_get_configuration_key_value('USE_PRODUCT_LISTING_FOR_FEATURED_PRODUCTS')=='True')
{
$use_product_listing = true;
$snaf_listing_split = $featured_products_split;
if(zen_get_configuration_key_value('USE_PRODUCT_LISTING_FILTER_FOR_FEATURED_PRODUCTS')=='True')
{
$show_product_listing_filter = true;
}else{
$show_product_listing_filter = false;
}
if (PRODUCT_LISTING_LAYOUT_STYLE == 'rows'){
// include the language file for the headings
$category_depth = 'products';
if(file_exists(DIR_WS_LANGUAGES.$_SESSION['language'].'/index.php'))
{
require(DIR_WS_LANGUAGES.$_SESSION['language'].'/index.php');
}else{
require(DIR_WS_LANGUAGES.'english/index.php');
}
}
// create column list
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
/*                         ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}
}
//===========  eof SNAF (set up for product listing)
?>