Edit Category Landing Page

[timhersh]

Hello,

Have a client who wants something unique. I am using zen cart 1.5

We have built this landing page for the categories. http://www.domo-online.com/Outboard-.../evinrude-c-1/

The pictures are coming from the sub categories on this page. Here is what the client wants

Category 1 pic-------Category 1 description

Category 2 pic-------Category 2 description

Category 3 pic-------Category 3 description


So I need to figure out how to change the "category landing page only" to display the pictures vertically but also pull the 'category description' from the sub category and put it next to the category

any help would be greatly appreciated

[gjh42]

For starters, using the subcat names, you can add to your stylesheet

.categoryListBoxContents img+br {display: none;}
.categoryListBoxContents img {position: relative; top: 3.5em;}

Put this in a per-category stylesheet if you want it only on one category listing page. If you want all category listings to have this layout, change the categories per row in admin. If not, add another rule:

.categoryListBoxContents {clear: left;}


To get the actual subcat descriptions, you will need to add a database lookup and output the information in the listing code. /includes/modules/your_template/category_row.php would be a good place to start.

[timhersh]

Thank you. The cart is already setup for rows though, but it still displays the category pages horizontally

Product Page-http://www.domo-online.com/Outboard-Motor-Oil/yamalube-c-4/2m-c-4_11/

Category Page--I'm trying to edit http://www.domo-online.com/Outboard-.../yamalube-c-4/

any ideas

[gjh42]

There is no "rows/columns" setting for category listing pages. You can only set the category listing to maximum 1 per row.
Configuration > Maximum Values > Categories To List Per Row.
If you want all category listings vertical, set this to 1.

To get the subcat descriptions, you do need to modify main_template_vars.php and category_row.php, as mentioned above.
Add
, cd.categories_description
to this section in main_template_vars.php (around line 96) to get

        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id, cd.categories_description
                             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
      } 

In category_row.php, add
<p class="catListingDesc">' . $categories->fields['categories_description'] . '</p>
to this line to get

    $list_box_contents[$row][$col] = array('params' => 'class="categoryListBoxContents"' . ' ' . 'style="width:' . $col_width . '%;"',
                                           'text' => '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . zen_image(DIR_WS_IMAGES . $categories->fields['categories_image'], $categories->fields['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . $categories->fields['categories_name'] . '</a><p class="catListingDesc">' . $categories->fields['categories_description'] . '</p>'); 

Also, remove the
'<br />' .
that you will see in the original before $categories->fields['categories_name'] .
You might need a slightly more verbose edit to category_row.php, depending on exactly how you want the layout to work.

[timhersh]

I will try that, thank you.

[timhersh]

Thank you, it looks like that made a bit of a difference but it still isn't pulling the descriptions for the category.

Here is what is looks like now http://domo-online.com/Outboard-Moto...=index&cPath=1

I would like the categories left justified and the category description in the blank section to the right

Here is where I edited the category_row.php file

 if (!$categories->fields['categories_image']) !$categories->fields['categories_image'] = 'pixel_trans.gif';

    $cPath_new = zen_get_path($categories->fields['categories_id']);



    // strip out 0_ from top level cats

    $cPath_new = str_replace('=0_', '=', $cPath_new);



    //    $categories->fields['products_name'] = zen_get_products_name($categories->fields['products_id']);



       $list_box_contents[$row][$col] = array('params' => 'class="categoryListBoxContents"' . ' ' . 'style="width:' . $col_width . '%;"',
                                           'text' => '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . zen_image(DIR_WS_IMAGES . $categories->fields['categories_image'], $categories->fields['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . $categories->fields['categories_name'] . '</a><p class="catListingDesc">' . $categories->fields['categories_description'] . '</p>');  



    $col ++;

    if ($col > (MAX_DISPLAY_CATEGORIES_PER_ROW -1)) {

      $col = 0;

      $row ++;

    }

here is what I did to the main_template_vars

 $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "

            set        products_viewed = products_viewed+1

            where      products_id = '" . (int)$_GET['products_id'] . "'

            and        language_id = '" . (int)$_SESSION['languages_id'] . "'";



    $res = $db->Execute($sql);

$categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id, cd.categories_description
                             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
      }  

    $sql = "select p.products_id, pd.products_name,

                  pd.products_description, p.products_model,

                  p.products_quantity, p.products_image,

                  pd.products_url, p.products_price,

                  p.products_tax_class_id, p.products_date_added,

                  p.products_date_available, p.manufacturers_id, p.products_quantity,

                  p.products_weight, p.products_priced_by_attribute, p.product_is_free,

                  p.products_qty_box_status,

                  p.products_quantity_order_max,

                  p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter

           from   " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd

           where  p.products_status = '1'

           and    p.products_id = '" . (int)$_GET['products_id'] . "'

           and    pd.products_id = p.products_id

           and    pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

any ideas

thank you

[gjh42]

I think the query addition needs to be made in a different section... the "deepest category the customer is in" may not be what we need to use. That will execute for subcats of a subcat; we need subcats of a top cat here.
Try adding
, cd.categories_description
here to get

  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id, cd.categories_description
                         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); 

[timhersh]

I think the query addition needs to be made in a different section... the "deepest category the customer is in" may not be what we need to use. That will execute for subcats of a subcat; we need subcats of a top cat here.
Try adding
, cd.categories_description
here to get

  } else {
    $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id, cd.categories_description
                         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); 

thank you, where do I add this code though? Do I remove the one you had me add before? I see it starts with an Else clause so not sure where to put it

[gjh42]

Find the code block I show and add the ", cd.categories_description" bit to the query. It is just below the first addition area. Line numbers would be pointless, as I see you have a customized version of main_template_vars.php with a lot of added code.

I don't think it matters if you leave the first addition; it will come into play only if you have sub-subcategories.

[timhersh]

Very sorry but I do follow you. I'm using Zen Cart 1.5 and maybe that is the issue. I searched in the my original version of main_template_vars.php I don't have this in there anywhere: categories_query


here is what my main_template_vars.php looks like

<?php

/**

 *  document_general_info main_template_vars.php

 *

 * @package productTypes

 * @copyright Copyright 2003-2011 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: main_template_vars.php 19690 2011-10-04 16:41:45Z drbyte $

 */

/*

 * Extracts and constructs the data to be used in the product-type template tpl_TYPEHANDLER_info_display.php

 */



  // This should be first line of the script:

  $zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_START_DOCUMENT_GENERAL_INFO');



  $module_show_categories = DOCUMENT_GENERAL_INFO_CATEGORIES;



  $sql = "select count(*) as total

          from " . TABLE_PRODUCTS . " p, " .

                   TABLE_PRODUCTS_DESCRIPTION . " pd

          where    p.products_status = '1'

          and      p.products_id = '" . (int)$_GET['products_id'] . "'

          and      pd.products_id = p.products_id

          and      pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";





  $res = $db->Execute($sql);



  if ( $res->fields['total'] < 1 ) {



    $tpl_page_body = '/tpl_product_info_noproduct.php';



  } else {



    $tpl_page_body = '/tpl_document_general_info_display.php';



    $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "

            set        products_viewed = products_viewed+1

            where      products_id = '" . (int)$_GET['products_id'] . "'

            and        language_id = '" . (int)$_SESSION['languages_id'] . "'";



    $res = $db->Execute($sql);



    $sql = "select p.products_id, pd.products_name,

                  pd.products_description, p.products_model,

                  p.products_quantity, p.products_image,

                  pd.products_url, p.products_price,

                  p.products_tax_class_id, p.products_date_added,

                  p.products_date_available, p.manufacturers_id, p.products_quantity,

                  p.products_weight, p.products_priced_by_attribute, p.product_is_free,

                  p.products_qty_box_status,

                  p.products_quantity_order_max,

                  p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter

           from   " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd

           where  p.products_status = '1'

           and    p.products_id = '" . (int)$_GET['products_id'] . "'

           and    pd.products_id = p.products_id

           and    pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";



    $product_info = $db->Execute($sql);



    $products_price_sorter = $product_info->fields['products_price_sorter'];



    $products_price = $currencies->display_price($product_info->fields['products_price'],

                      zen_get_tax_rate($product_info->fields['products_tax_class_id']));



    $manufacturers_name= zen_get_products_manufacturers_name((int)$_GET['products_id']);



    if ($new_price = zen_get_products_special_price($product_info->fields['products_id'])) {



      $specials_price = $currencies->display_price($new_price,

                        zen_get_tax_rate($product_info->fields['products_tax_class_id']));



    }



// set flag for attributes module usage:

    $flag_show_weight_attrib_for_this_prod_type = SHOW_DOCUMENT_GENERAL_INFO_WEIGHT_ATTRIBUTES;

// get attributes

    require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_ATTRIBUTES));



// if review must be approved or disabled do not show review

    $review_status = " and r.status = '1'";



    $reviews_query = "select count(*) as count from " . TABLE_REVIEWS . " r, "

                                                       . TABLE_REVIEWS_DESCRIPTION . " rd

                       where r.products_id = '" . (int)$_GET['products_id'] . "'

                       and r.reviews_id = rd.reviews_id

                       and rd.languages_id = '" . (int)$_SESSION['languages_id'] . "'" .

                       $review_status;



    $reviews = $db->Execute($reviews_query);



  }



  require(DIR_WS_MODULES . zen_get_module_directory('product_prev_next.php'));



  $products_name = $product_info->fields['products_name'];

  $products_model = $product_info->fields['products_model'];

  $products_description = $product_info->fields['products_description'];



  if ($product_info->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') {

    $products_image = PRODUCTS_IMAGE_NO_IMAGE;

  } else {

    $products_image = $product_info->fields['products_image'];

  }



  $products_url = $product_info->fields['products_url'];

  $products_date_available = $product_info->fields['products_date_available'];

  $products_date_added = $product_info->fields['products_date_added'];

  $products_manufacturer = $product_info->fields['manufacturers_name'];

  $products_weight = $product_info->fields['products_weight'];

  $products_quantity = $product_info->fields['products_quantity'];



  $products_qty_box_status = $product_info->fields['products_qty_box_status'];

  $products_quantity_order_max = $product_info->fields['products_quantity_order_max'];



  $products_base_price = $currencies->display_price(zen_get_products_base_price((int)$_GET['products_id']),

                      zen_get_tax_rate($product_info->fields['products_tax_class_id']));



  $product_is_free = $product_info->fields['product_is_free'];



  $products_tax_class_id = $product_info->fields['products_tax_class_id'];



  $module_show_categories = PRODUCT_INFO_CATEGORIES;

  $module_next_previous = PRODUCT_INFO_PREVIOUS_NEXT;



  $products_id_current = (int)$_GET['products_id'];

  $products_discount_type = $product_info->fields['products_discount_type'];

  $products_discount_type_from = $product_info->fields['products_discount_type_from'];



/**

 * Load product-type-specific main_template_vars

 */

  $prod_type_specific_vars_info = DIR_WS_MODULES . 'pages/' . $current_page_base . '/main_template_vars_product_type.php';

  if (file_exists($prod_type_specific_vars_info)) {

    include_once($prod_type_specific_vars_info);

  }

  $zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_PRODUCT_TYPE_VARS_DOCUMENT_GENERAL_INFO');





/**

 * Load all *.PHP files from the /includes/templates/MYTEMPLATE/PAGENAME/extra_main_template_vars

 */

  $extras_dir = $template->get_template_dir('.php', DIR_WS_TEMPLATE, $current_page_base . 'extra_main_template_vars', $current_page_base . '/' . 'extra_main_template_vars');

  if ($dir = @dir($extras_dir)) {

    while ($file = $dir->read()) {

      if (!is_dir($extras_dir . '/' . $file)) {

        if (preg_match('/\.php$/', $file) > 0) {

          $directory_array[] = '/' . $file;

        }

      }

    }

    $dir->close();

  }

  if (sizeof($directory_array)) sort($directory_array);



  for ($i = 0, $n = sizeof($directory_array); $i < $n; $i++) {

    if (file_exists($extras_dir . $directory_array[$i])) include($extras_dir . $directory_array[$i]);

  }



// build show flags from product type layout settings

//  $flag_show_product_info_starting_at = zen_get_show_product_switch($_GET['products_id'], 'starting_at');

//  $flag_show_product_info_model = zen_get_show_product_switch($_GET['products_id'], 'model');

//  $flag_show_product_info_weight = zen_get_show_product_switch($_GET['products_id'], 'weight');

//  $flag_show_product_info_quantity = zen_get_show_product_switch($_GET['products_id'], 'quantity');

//  $flag_show_product_info_manufacturer = zen_get_show_product_switch($_GET['products_id'], 'manufacturer');

//  $flag_show_product_info_in_cart_qty = zen_get_show_product_switch($_GET['products_id'], 'in_cart_qty');

  $flag_show_product_info_reviews = zen_get_show_product_switch($_GET['products_id'], 'reviews');

  $flag_show_product_info_reviews_count = zen_get_show_product_switch($_GET['products_id'], 'reviews_count');

  $flag_show_product_info_date_available = zen_get_show_product_switch($_GET['products_id'], 'date_available');

  $flag_show_product_info_date_added = zen_get_show_product_switch($_GET['products_id'], 'date_added');

  $flag_show_product_info_url = zen_get_show_product_switch($_GET['products_id'], 'url');

  $flag_show_product_info_additional_images = zen_get_show_product_switch($_GET['products_id'], 'additional_images');

  $flag_show_product_info_free_shipping = zen_get_show_product_switch($_GET['products_id'], 'always_free_shipping_image_switch');

  require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_PRODUCTS_QUANTITY_DISCOUNTS));



  $zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_EXTRA_DOCUMENT_GENERAL_INFO');





  require($template->get_template_dir($tpl_page_body,DIR_WS_TEMPLATE, $current_page_base,'templates'). $tpl_page_body);



  //require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_ALSO_PURCHASED_PRODUCTS));



  // This should be last line of the script:

  $zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_END_DOCUMENT_GENERAL_INFO');