Tableau Responsive Theme - Support Thread

**satello** · 4 Oct 2015, 11:13 AM

Hi everyone, long time since I retouched my heavily customized tableau. this morning i've installed the new one, over a 1.5.4 zencart, using old patched database.

before I go into extra custom work, just got this very odd problem. surely is just something in the settings I am missing...

Ok, in my old version (1.2) the main category page shows all the subcategories

http://www.londonsatman.co.uk/italian-satellite-tv-77/

with the same settings, but on the latest version of the template, the category main page show all the products present in the subcategories

http://www.londonsatman.co.uk/zencar...index&cPath=77

I would like the main category page to show subcategories, and also a small thumb for it. I remember when I tried to update a few months ago this was the result but as I was very busy I've abandoned the upgrade, but can't manage to have it now

here are a few conf settings:

Layout Settings

Main Page - Opens with Category 0
Categories - Always Open to Show SubCategories 1

many thanks for your time in reading this.

**mikestaps** · 8 Oct 2015, 03:32 PM

Originally Posted by satello

Hi everyone, long time since I retouched my heavily customized tableau. this morning i've installed the new one, over a 1.5.4 zencart, using old patched database.

before I go into extra custom work, just got this very odd problem. surely is just something in the settings I am missing...

Ok, in my old version (1.2) the main category page shows all the subcategories

http://www.londonsatman.co.uk/italian-satellite-tv-77/

with the same settings, but on the latest version of the template, the category main page show all the products present in the subcategories

http://www.londonsatman.co.uk/zencar...index&cPath=77

I would like the main category page to show subcategories, and also a small thumb for it. I remember when I tried to update a few months ago this was the result but as I was very busy I've abandoned the upgrade, but can't manage to have it now

here are a few conf settings:

Layout Settings

Main Page - Opens with Category 0
Categories - Always Open to Show SubCategories 1

many thanks for your time in reading this.

This is caused by a change in the includes\modules\pages\index\main_template_vars.php file
To switch back to the old way first uncomment lines 64 THROUGH 123 and line 126.

Code:

  /*$sql = "SELECT cd.categories_name, c.categories_image
          FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
          WHERE      c.categories_id = :categoriesID
          AND        cd.categories_id = :categoriesID
          AND        cd.language_id = :languagesID
          AND        c.categories_status= '1'";

  $sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer');
  $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  $category = $db->Execute($sql);

  if (isset($cPath) && strpos($cPath, '_'))
  {
    // check to see if there are deeper categories within the current category
    $category_links = array_reverse($cPath_array);
    for($i=0, $n=sizeof($category_links); $i<$n; $i++)
    {
      $sql = "SELECT count(*) AS total
              FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
              WHERE      c.parent_id = :parentID
              AND        c.categories_id = cd.categories_id
              AND        cd.language_id = :languagesID
              AND        c.categories_status= '1'";

      $sql = $db->bindVars($sql, ':parentID', $category_links[$i], 'integer');
      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
      $categories = $db->Execute($sql);

      if ($categories->fields['total'] < 1)
      {
        // do nothing, go through the loop
      } else {
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                             FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE      c.parent_id = :parentID
                             AND        c.categories_id = cd.categories_id
                             AND        cd.language_id = :languagesID
                             AND        c.categories_status= '1'
                             ORDER BY   sort_order, cd.categories_name";

        $categories_query = $db->bindVars($categories_query, ':parentID', $category_links[$i], 'integer');
        $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
        break; // we've found the deepest category the customer is in
      }
    }
  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                         FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                         WHERE      c.parent_id = :parentID
                         AND        c.categories_id = cd.categories_id
                         AND        cd.language_id = :languagesID
                         AND        c.categories_status= '1'
                         ORDER BY   sort_order, cd.categories_name";

    $categories_query = $db->bindVars($categories_query, ':parentID', $current_category_id, 'integer');
    $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
  }
  $categories = $db->Execute($categories_query);
  $number_of_categories = $categories->RecordCount();
  $new_products_category_id = $current_category_id;*/

  /////////////////////////////////////////////////////////////////////////////////////////////////////
  //$tpl_page_body = 'tpl_index_categories.php';
  /////////////////////////////////////////////////////////////////////////////////////////////////////

Next comment out this section (129-196):

Code:

//BOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES
   if (SHOW_PRODUCT_INFO_ALL_PRODUCTS == '1') {
    // set a category filter
    $new_products_category_id = $cPath;
  } else {
    // do not set the category
  }
  // 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;
  }

  $select_column_list = '';

  for ($i=0, $n=sizeof($column_list); $i<$n; $i++)
  {
    switch ($column_list[$i])
    {
      case 'PRODUCT_LIST_MODEL':
      $select_column_list .= 'p.products_model, ';
      break;
      case 'PRODUCT_LIST_NAME':
      $select_column_list .= 'pd.products_name, ';
      break;
      case 'PRODUCT_LIST_MANUFACTURER':
      $select_column_list .= 'm.manufacturers_name, ';
      break;
      case 'PRODUCT_LIST_QUANTITY':
      $select_column_list .= 'p.products_quantity, ';
      break;
      case 'PRODUCT_LIST_IMAGE':
      $select_column_list .= 'p.products_image, ';
      break;
      case 'PRODUCT_LIST_WEIGHT':
      $select_column_list .= 'p.products_weight, ';
      break;
    }
  }
  // always add quantity regardless of whether or not it is in the listing for add to cart buttons
  if (PRODUCT_LIST_QUANTITY < 1) {
    $select_column_list .= 'p.products_quantity, ';
  }

  // set the product filters according to selected product type
  $typefilter = 'default';
  if (isset($_GET['typefilter'])) $typefilter = $_GET['typefilter'];
  require(zen_get_index_filters_directory($typefilter . '_filter.php'));

  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
  $tpl_page_body = 'tpl_index_product_list.php';
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
   
   //EOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES

This will revert to sub-category photos showing when a parent category is selected.

**satello** · 10 Oct 2015, 12:16 AM

YOU ARE A STAR, YOU REALLY ARE!!!

Thanks for your help, this has been bugging me for a week. Just a question, is this related to this template only, or it is for the core cart?

As I've asked the same question in the main forum, and nobody new anything, thinking as well that was a db problem.

**mikestaps** · 12 Oct 2015, 01:46 PM

Originally Posted by satello

YOU ARE A STAR, YOU REALLY ARE!!!

Thanks for your help, this has been bugging me for a week. Just a question, is this related to this template only, or it is for the core cart?

As I've asked the same question in the main forum, and nobody new anything, thinking as well that was a db problem.

I'm thinking that this file would have an effect site wide, and not just in the tableau template, as it is not in a tableau "override" folder. I'm not sure that there is a way to use and override in this case.

**satello** · 16 Oct 2015, 11:11 AM

Suggestion for the developers: as there is the option to customize the colors of the Drop Down Background Color, etc it would be a good idea to include the same color scheme for the responsive design. What I mean is they give the option to customize that part of the layout, and with a little effort in the coding this could be reflected side wide even when in responsive mode

At the moment when drop down are opened in mobile view, the colors are different from the ones in full view (if customized), unless we go hard-coding into the responsive.css and do it ourselves but this is something i really don't want (not because I am not capable...)

just my thoughts

**MIKEYFM** · 28 Oct 2015, 10:06 PM

Originally Posted by mikestaps

This is caused by a change in the includes\modules\pages\index\main_template_vars.php file
To switch back to the old way first uncomment lines 64 THROUGH 123 and line 126.

Code:

  /*$sql = "SELECT cd.categories_name, c.categories_image
          FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
          WHERE      c.categories_id = :categoriesID
          AND        cd.categories_id = :categoriesID
          AND        cd.language_id = :languagesID
          AND        c.categories_status= '1'";

  $sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer');
  $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  $category = $db->Execute($sql);

  if (isset($cPath) && strpos($cPath, '_'))
  {
    // check to see if there are deeper categories within the current category
    $category_links = array_reverse($cPath_array);
    for($i=0, $n=sizeof($category_links); $i<$n; $i++)
    {
      $sql = "SELECT count(*) AS total
              FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
              WHERE      c.parent_id = :parentID
              AND        c.categories_id = cd.categories_id
              AND        cd.language_id = :languagesID
              AND        c.categories_status= '1'";

      $sql = $db->bindVars($sql, ':parentID', $category_links[$i], 'integer');
      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
      $categories = $db->Execute($sql);

      if ($categories->fields['total'] < 1)
      {
        // do nothing, go through the loop
      } else {
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                             FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE      c.parent_id = :parentID
                             AND        c.categories_id = cd.categories_id
                             AND        cd.language_id = :languagesID
                             AND        c.categories_status= '1'
                             ORDER BY   sort_order, cd.categories_name";

        $categories_query = $db->bindVars($categories_query, ':parentID', $category_links[$i], 'integer');
        $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
        break; // we've found the deepest category the customer is in
      }
    }
  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                         FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                         WHERE      c.parent_id = :parentID
                         AND        c.categories_id = cd.categories_id
                         AND        cd.language_id = :languagesID
                         AND        c.categories_status= '1'
                         ORDER BY   sort_order, cd.categories_name";

    $categories_query = $db->bindVars($categories_query, ':parentID', $current_category_id, 'integer');
    $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
  }
  $categories = $db->Execute($categories_query);
  $number_of_categories = $categories->RecordCount();
  $new_products_category_id = $current_category_id;*/

  /////////////////////////////////////////////////////////////////////////////////////////////////////
  //$tpl_page_body = 'tpl_index_categories.php';
  /////////////////////////////////////////////////////////////////////////////////////////////////////

Next comment out this section (129-196):

Code:

//BOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES
   if (SHOW_PRODUCT_INFO_ALL_PRODUCTS == '1') {
    // set a category filter
    $new_products_category_id = $cPath;
  } else {
    // do not set the category
  }
  // 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;
  }

  $select_column_list = '';

  for ($i=0, $n=sizeof($column_list); $i<$n; $i++)
  {
    switch ($column_list[$i])
    {
      case 'PRODUCT_LIST_MODEL':
      $select_column_list .= 'p.products_model, ';
      break;
      case 'PRODUCT_LIST_NAME':
      $select_column_list .= 'pd.products_name, ';
      break;
      case 'PRODUCT_LIST_MANUFACTURER':
      $select_column_list .= 'm.manufacturers_name, ';
      break;
      case 'PRODUCT_LIST_QUANTITY':
      $select_column_list .= 'p.products_quantity, ';
      break;
      case 'PRODUCT_LIST_IMAGE':
      $select_column_list .= 'p.products_image, ';
      break;
      case 'PRODUCT_LIST_WEIGHT':
      $select_column_list .= 'p.products_weight, ';
      break;
    }
  }
  // always add quantity regardless of whether or not it is in the listing for add to cart buttons
  if (PRODUCT_LIST_QUANTITY < 1) {
    $select_column_list .= 'p.products_quantity, ';
  }

  // set the product filters according to selected product type
  $typefilter = 'default';
  if (isset($_GET['typefilter'])) $typefilter = $_GET['typefilter'];
  require(zen_get_index_filters_directory($typefilter . '_filter.php'));

  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
  $tpl_page_body = 'tpl_index_product_list.php';
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////
   
   //EOF SHOW ALL PRODUCTS FOR PARENT CATEGORIES

This will revert to sub-category photos showing when a parent category is selected.

This is exactly what I wanted to get the category listing back but it seems to break the sort filter and the listing the products by cheapest to highest price. Or the old to new . I am not sure if you can have both. It would be good if you can as the price low to high is a nice feature..

Has anyone else noticed this and is there a fix somewhere that I have not been able to see on the forum/thread.

Thank you.

MG

**bislewl** · 28 Oct 2015, 11:22 PM

Originally Posted by MIKEYFM

This is exactly what I wanted to get the category listing back but it seems to break the sort filter and the listing the products by cheapest to highest price. Or the old to new . I am not sure if you can have both. It would be good if you can as the price low to high is a nice feature..

Has anyone else noticed this and is there a fix somewhere that I have not been able to see on the forum/thread.

Thank you.

MG

I resolved it by doing the following:
created a file: includes/functions/extra_functions/sort_by_functions.php

PHP Code:


<?php



function order_by_sort_by_sql($sortby, $order_by = true) {

    if($order_by == true){

    $listing_sql = ' ORDER BY ';

    }

    switch ($sortby) {

        case '1':

            //newest

            $listing_sql .= " p.products_date_added DESC ";

            break;

        case '3':

            //price HIGH->LOW

            $listing_sql .= " p.products_price DESC ";

            break;

        case '4':

            //price LOW->HIGH

            $listing_sql .= " p.products_price ASC ";

            break;

        case '5':

            //Name ASC

            $listing_sql .= " pd.products_name ASC ";

            break;

        case '6':

            //Name DESC

            $listing_sql .= " pd.products_name DESC ";

            break;

        case '0':

        default:

            //products defualt sort order

            $listing_sql .= " p.products_sort_order, pd.products_name";

            break;

    }

    return $listing_sql;

}

includes/index_filters/default_filter.php
commented out: (around line 90ish) also similarly in the includes/modules/advanced_search_results/header_php.php

PHP Code:


array('id' => 0, 'text' => 'Default Order'),

              array('id' => 1, 'text' => 'Newest First'),

              //array('id' => 2, 'text' => 'Most Popular'),

              array('id' => 3, 'text' => 'Price (High to Low)'),

              array('id' => 4, 'text' => 'Price (Low to High)'),

              array('id' => 5, 'text' => 'Name (A-Z)'),

              array('id' => 6, 'text' => 'Name (Z-A)'),

...

        case 'PRODUCT_LIST_WEIGHT':

          $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

          break;

        case 'PRODUCT_LIST_PRICE':

          $listing_sql .= " order by p.products_price_sorter " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

          break;

      }

    }

  }

modified includes/templates/tableau/templates/tpl_modules_product_listing.php to have the

HTML Code:

<div class="sort-listings-wrapper">

look like this:

PHP Code:


<div class="sort-listings-wrapper">

        <?php echo zen_draw_form('sortbyform', zen_href_link(zen_db_prepare_input($_GET['main_page']), zen_get_all_get_params(array('sortby', 'sort','keyword','search_in_description','inc_subcat','')), $request_type, false), 'get') . zen_hide_session_id();?>

        <?php 

                echo zen_draw_hidden_field('main_page', zen_db_prepare_input($_GET['main_page']));

            $sortbyparams = explode('&', zen_get_all_get_params(array('sortby', 'sort','')));

            foreach($sortbyparams as $param) {

                  $param = explode('=', $param);

                                if(strlen($param[0]) > 1){

                  echo zen_draw_hidden_field($param[0], $param[1]);

                                }

        }

        ?>

        <label>Sort By:</label>

        <?php 

            $sortby_array = array(

                          array('id' => 0, 'text' => 'Default Order'),

              array('id' => 1, 'text' => 'Newest First'),

              //array('id' => 2, 'text' => 'Most Popular'),

              array('id' => 3, 'text' => 'Price (High to Low)'),

              array('id' => 4, 'text' => 'Price (Low to High)'),

              array('id' => 5, 'text' => 'Name (A-Z)'),

              array('id' => 6, 'text' => 'Name (Z-A)'),

            );

            echo zen_draw_pull_down_menu('sortby', $sortby_array, $_GET['sortby'], 'onchange="this.form.submit();"');

        ?>

        <?php echo '</form>';?>

    </div><!--EOF .sort-listings-wrapper-->



    <?php if($_GET['showall'] == 1) {?>

Hopefully that helps!

**bislewl** · 28 Oct 2015, 11:29 PM

I think I spoke too soon, it looks like the sort bug was fixed in version 1.6.5

**mikestaps** · 29 Oct 2015, 06:32 PM

Originally Posted by bislewl

I think I spoke too soon, it looks like the sort bug was fixed in version 1.6.5

It was only kind of fixed... If you set a default sort order in the Admin ->Configuration -> Product Listing you cannot select/re-select that sort option in the drop down.
This was also brought up on github - here

**vanhorn_s** · 29 Oct 2015, 07:10 PM

I asked a question a month ago, that never got answered. Here it is again:

In the left column sideboxes, the reviews sidebox has blue text that shows REVIEWS [MORE], and I cannot collapse the sidebox. The featured sidebox did the same thing, but I just turned it off, because I don't care about it.
Also, is there a way of setting the default sort order to best selling? When you navigate from a mobile device, it does not have the entire drop down menu, and so main categories are all you see, rather than sub categories.

http://redsautorehab.com/index.php?m...=index&cPath=8

The reviews sidebox only shows one review, with no link to any other reviews. I would like to have it show 3, or 4 reviews.

Thread: Tableau Responsive Theme - Support Thread

Thread Tools

Search Thread

Display

Hybrid View

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Re: Tableau Responsive Theme - Support Thread

Similar Threads

v155 Responsive Classic (built in to Zen Cart v1.5.5) [Support Thread]

v155 Support Thread - Responsive Color Changes for 155

v155 Tableau Theme configuration not working.

v155 Responsive Classic (built in to Zen Cart v1.5.5) [Support Thread]

v154 Order Steps Responsive [Support Thread]

Posting Permissions