<?php

require('includes/application_top.html');

require_once('includes/classes/product/product.php');

require('includes/categories_sidebar.php');

if($manufacturers_code){
  require('includes/manufacturers.php');
}
if($parent_category_id && $_GET['flags']=='all'){
  tep_redirect(tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('flags'))));
}

if(!($current_category_id || $manufacturers_id)){

  //featured products

  $maxFeaturedProductsPerRow = 5;

  $response=tep_db_query("select product_id, convert(category,unsigned integer) as cat from featured_products where active = 1 order by cat");
  $totalFeatured = tep_db_num_rows($response);
  if($totalFeatured > $maxFeaturedProductsPerRow){
    $rest = ($totalFeatured % $maxFeaturedProductsPerRow);
    if($rest > 0){
        $totalFeatured -= $rest;
    }
  }

  $featuredCounter = 0;
  while($row=tep_db_fetch_array($response)){
    if($featuredCounter < $totalFeatured){
        $featured_cat_prods[$row['cat']]=$row['product_id'];
    }
    $featuredCounter++;
  }

  $homepage_products = array();
  foreach($featured_cat_prods as $cat=>$product_id){
    $p2 =new Product($product_id);
    $p2->load_with_joins(array('Product_images','Product_description','Product_prices','Product_flags'));
    $homepage_products[] = array(
      'image'=>$p2->get_large_image_file(),
      'title'=>$p2->get_product_name(),
      'save'=>'Savings up to '.$p2->get_percent_savings().'%',
      'id'=> $product_id,
      'our_low_price' => $p2->get_low_price(),
      'our_high_price' => $p2->get_our_high_price(),
      'min_qty' => $p2->get_minimum_qty().' min'
    );
    unset($p2);
  }


    //popular categories

    $maxPopularCategoriesPerRow = 4;

    $homepage_categories = array();
    $response=tep_db_query("select c.categories_id, c.popular_image, c.popular_title, c.popular_extra, c.popular_alt from categories c where c.popular = 1 order by c.popular_order");
    while($row=tep_db_fetch_array($response)){
        $homepage_categories[] = array(
            'categories_id' => $row['categories_id'],
            'popular_image' => $row['popular_image'],
            'popular_title' => $row['popular_title'],
            'popular_extra' => $row['popular_extra'],
            'popular_alt' => $row['popular_alt'],
        );
    }


  $result = tep_db_query("select pages_content from pages where pages_title='homepage_bottom_content_visible'");
  $row=tep_db_fetch_array($result);
  $homepage_bottom_content_visible = $row['pages_content'];
  $result = tep_db_query("select pages_content from pages where pages_title='homepage_bottom_content_reveal'");
  $row=tep_db_fetch_array($result);
  $homepage_bottom_content_reveal = $row['pages_content'];
  $product=new Product;
  $cats=$product->get_categories();

  foreach($cats as $catinfo){
    if($catinfo['categories_id']){
      if($catinfo['categories_id']==1251 || $catinfo['categories_id']==1252 || $catinfo['categories_id']==1256) continue;
      $sub_categories[]=array(
        'categories_id'=>$catinfo['categories_id'],
        'categories_name'=>$catinfo['categories_name'],
        'products_in_category'=> $catinfo['total'],
        'cPath_new' => tep_get_path($catinfo['categories_id']),
        'categories_image'=>$catinfo['categories_image'],
        'flags_image'=>$catinfo['flags_image']
      );
    }
  }
}

require_once('includes/functions/product_listing_funcs.html');
if($listing_split->sql_query){
  //echo $listing_split->sql_query;
  $listing = tep_db_query($listing_split->sql_query);
  $product_ids=array();
  while ($prod = tep_db_fetch_array($listing)){
    $product_ids[]=$prod['products_id'];
  }
}

//dumb empty cat fix
if(!count($product_ids) && (isset($_REQUEST['filter_cat']) OR isset($_REQUEST['flags'])))  tep_redirect(tep_href_link(FILENAME_DEFAULT, 'cPath='.$current_category_id));+

// $canonical = tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('flags','price','filter_cat','sort')));

require('templates/index.tpl.php');
require(DIR_WS_INCLUDES . 'application_bottom.html');