Adding New Product_types

**bondee** · 8 Aug 2005, 07:22 PM

Hi, Jazzyjus. I'm now creating product types and find your mod very helpful. I think you have a lot of experience and knowledge to this. There is one thing I'm wondering. Is there anyway u can show me how to create a sidebox with filter?

My zencart is a big shoppingMall. In the ShoppingMall there are a lot of stores. I have a product types called stores. I've followed the Product Types doc and managed to create all the files in admin and catalog. It works succesfully in admin.

I've create this files in catalog:

/includes/languages/MY_LANGUAGE/product_stores_info.php
/includes/languages/english/product_stores_info.php
/includes/modules/pages/product_stores_info/header_php.php
/includes/modules/pages/product_stores_info/jscript_main.php
/includes/modules/pages/product_stores_info/main_template_vars.php
/includes/modules/pages/product_stores_info/main_template_vars_attributes.php
/includes/modules/pages/product_stores_info/main_template_vars_images.php
/includes/modules/pages/product_stores_info/main_template_vars_images_additional.php
/includes/templates/MY_TEMPLATE/templates/tpl_product_stores_info_display.php
/includes/templates/MY_TEMPLATE/sideboxes/stores.php
/includes/templates/MY_TEMPLATE/sideboxes/tpl_stores_select.php
/includes/index_filters/stores_filter.php

I've managed to create the 'STORES' sidebox as the 'MANUFACTURER' box, and list all stores_name in that box. But when I choose one of the store_name, it comes up that there are no products on that catagory. But if I have any products in music, it shows them! That's so wrong!::frust

The codes in stores_filter are exactly from default_filter.php. The only things I've modified there was change out manufacturers with stores:

Code:

&#60;?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                    |
// +----------------------------------------------------------------------+
// | Copyright &#40;c&#41; 2004 The zen-cart developers              |
// |                                   |
// | http&#58;//www.zen-cart.com/index.php                  |
// |                                   |
// | Portions Copyright &#40;c&#41; 2003 osCommerce                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,    |
// | that is bundled with this package in the file LICENSE, and is    |
// | available through the world-wide-web at the following url&#58;      |
// | http&#58;//www.zen-cart.com/license/2_0.txt.               |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to    |
// | license AT zen-cart DOT com so we can mail you a copy immediately.     |
// +----------------------------------------------------------------------+
// &#036;Id&#58; default_filter.php 1223 2005-04-22 03&#58;46&#58;20Z ajeh &#036;
//
// show the products of a specified STORE
  if &#40;isset&#40;&#036;_GET&#91;&#39;stores_id&#39;&#93;&#41; && &#036;_GET&#91;&#39;stores_id&#39;&#93; &#33;= &#39;&#39; &#41;
  {
   if &#40;isset&#40;&#036;_GET&#91;&#39;filter_id&#39;&#93;&#41; && zen_not_null&#40;&#036;_GET&#91;&#39;filter_id&#39;&#93;&#41;&#41;
   {
// We are asked to show only a specific category
    &#036;listing_sql = &#34;select &#34; . &#036;select_column_list . &#34; p.products_id, stores_id, p.products_price, p.products_tax_class_id, pd.products_description, if&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, NULL&#41; AS specials_new_products_price, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, p.products_price&#41; as final_price, p.products_sort_order from &#34; . TABLE_PRODUCTS . &#34; p, &#34; . TABLE_PRODUCTS_DESCRIPTION . &#34; pd, &#34; . TABLE_PRODUCTS_TO_CATEGORIES . &#34; p2c, &#34; . TABLE_STORES . &#34; s left join &#34; . TABLE_SPECIALS . &#34; sp on p.products_id = sp.products_id where p.products_status = &#39;1&#39; and p.stores_id = s.stores_id and s.stores_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;stores_id&#39;&#93; . &#34;&#39; and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = &#39;&#34; . &#40;int&#41;&#036;_SESSION&#91;&#39;languages_id&#39;&#93; . &#34;&#39; and p2c.categories_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;filter_id&#39;&#93; . &#34;&#39;&#34;;
   } else {
// We show them all
    &#036;listing_sql = &#34;select &#34; . &#036;select_column_list . &#34; p.products_id, p.stores_id, p.products_price, p.products_tax_class_id, pd.products_description, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, NULL&#41; as specials_new_products_price, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, p.products_price&#41; as final_price, p.products_sort_order from &#34; . TABLE_PRODUCTS . &#34; p, &#34; . TABLE_PRODUCTS_DESCRIPTION . &#34; pd, &#34; . TABLE_STORES . &#34; s left join &#34; . TABLE_SPECIALS . &#34; sp on p.products_id = sp.products_id where p.products_status = &#39;1&#39; and pd.products_id = p.products_id and pd.language_id = &#39;&#34; . &#40;int&#41;&#036;_SESSION&#91;&#39;languages_id&#39;&#93; . &#34;&#39; and p.stores_id = s.stores_id and s.stores_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;stores_id&#39;&#93; . &#34;&#39;&#34;;
   }
  } else {
// show the products in a given categorie
   if &#40;isset&#40;&#036;_GET&#91;&#39;filter_id&#39;&#93;&#41; && zen_not_null&#40;&#036;_GET&#91;&#39;filter_id&#39;&#93;&#41;&#41;
   {
// We are asked to show only specific catgeory
    &#036;listing_sql = &#34;select &#34; . &#036;select_column_list . &#34; p.products_id, p.stores_id, p.products_price, p.products_tax_class_id, pd.products_description, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, NULL&#41; as specials_new_products_price, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, p.products_price&#41; as final_price, p.products_sort_order from &#34; . TABLE_PRODUCTS . &#34; p, &#34; . TABLE_PRODUCTS_DESCRIPTION . &#34; pd, &#34; . TABLE_STORES . &#34; s, &#34; . TABLE_PRODUCTS_TO_CATEGORIES . &#34; p2c left join &#34; . TABLE_SPECIALS . &#34; sp on p.products_id = sp.products_id where p.products_status = &#39;1&#39; and p.stores_id = s.stores_id and s.stores_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;filter_id&#39;&#93; . &#34;&#39; and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = &#39;&#34; . &#40;int&#41;&#036;_SESSION&#91;&#39;languages_id&#39;&#93; . &#34;&#39; and p2c.categories_id = &#39;&#34; . &#40;int&#41;&#036;current_category_id . &#34;&#39;&#34;;
   } else {
// We show them all
    &#036;listing_sql = &#34;select &#34; . &#036;select_column_list . &#34; p.products_id, p.stores_id, p.products_price, p.products_tax_class_id, pd.products_description, IF&#40;sp.status = &#39;1&#39;, sp.specials_new_products_price, NULL&#41; as specials_new_products_price, IF&#40;sp.status =&#39;1&#39;, sp.specials_new_products_price, p.products_price&#41; as final_price, p.products_sort_order from &#34; . TABLE_PRODUCTS_DESCRIPTION . &#34; pd, &#34; . TABLE_PRODUCTS . &#34; p left join &#34; . TABLE_STORES . &#34; s on p.stores_id = s.stores_id, &#34; . TABLE_PRODUCTS_TO_CATEGORIES . &#34; p2c left join &#34; . TABLE_SPECIALS . &#34; sp on p.products_id = sp.products_id where p.products_status = &#39;1&#39; and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = &#39;&#34; . &#40;int&#41;&#036;_SESSION&#91;&#39;languages_id&#39;&#93; . &#34;&#39; and p2c.categories_id = &#39;&#34; . &#40;int&#41;&#036;current_category_id . &#34;&#39;&#34;;
   }
  }

// set the default sort order setting from the Admin when not defined by customer
  if &#40;&#33;isset&#40;&#036;_GET&#91;&#39;sort&#39;&#93;&#41; and PRODUCT_LISTING_DEFAULT_SORT_ORDER &#33;= &#39;&#39;&#41; {
   &#036;_GET&#91;&#39;sort&#39;&#93; = PRODUCT_LISTING_DEFAULT_SORT_ORDER;
  }

  if &#40; &#40;&#33;isset&#40;&#036;_GET&#91;&#39;sort&#39;&#93;&#41;&#41; || &#40;&#33;ereg&#40;&#39;&#91;1-8&#93;&#91;ad&#93;&#39;, &#036;_GET&#91;&#39;sort&#39;&#93;&#41;&#41; || &#40;substr&#40;&#036;_GET&#91;&#39;sort&#39;&#93;, 0, 1&#41; &#62; sizeof&#40;&#036;column_list&#41;&#41; &#41;
  {
   for &#40;&#036;i=0, &#036;n=sizeof&#40;&#036;column_list&#41;; &#036;i&#60;&#036;n; &#036;i++&#41;
   {
    if &#40;&#036;column_list&#91;&#036;i&#93; == &#39;PRODUCT_LIST_NAME&#39;&#41;
    {
     &#036;_GET&#91;&#39;sort&#39;&#93; = &#036;i+1 . &#39;a&#39;;
     &#036;listing_sql .= &#34; order by p.products_sort_order, pd.products_name&#34;;
     break;
    } else {
// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER ia left blank
// for reverse, descending order use&#58;
//    &#036;listing_sql .= &#34; order by p.products_sort_order desc, pd.products_name&#34;;
     &#036;listing_sql .= &#34; order by p.products_sort_order, pd.products_name&#34;;
     break;
    }
   }
// if set to nothing use products_sort_order and PRODUCTS_LIST_NAME is off
   if &#40;PRODUCT_LISTING_DEFAULT_SORT_ORDER == &#39;&#39;&#41; {
    &#036;_GET&#91;&#39;sort&#39;&#93; = &#39;20a&#39;;
   }
  } else {
   &#036;sort_col = substr&#40;&#036;_GET&#91;&#39;sort&#39;&#93;, 0 , 1&#41;;
   &#036;sort_order = substr&#40;&#036;_GET&#91;&#39;sort&#39;&#93;, 1&#41;;
   &#036;listing_sql .= &#39; order by &#39;;
   switch &#40;&#036;column_list&#91;&#036;sort_col-1&#93;&#41;
   {
    case &#39;PRODUCT_LIST_MODEL&#39;&#58;
     &#036;listing_sql .= &#34;p.products_model &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     break;
    case &#39;PRODUCT_LIST_NAME&#39;&#58;
     &#036;listing_sql .= &#34;pd.products_name &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41;;
     break;
    case &#39;PRODUCT_LIST_STORE&#39;&#58;
     &#036;listing_sql .= &#34;s.stores_name &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     break;
    case &#39;PRODUCT_LIST_QUANTITY&#39;&#58;
     &#036;listing_sql .= &#34;p.products_quantity &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     break;
    case &#39;PRODUCT_LIST_IMAGE&#39;&#58;
     &#036;listing_sql .= &#34;pd.products_name&#34;;
     break;
    case &#39;PRODUCT_LIST_WEIGHT&#39;&#58;
     &#036;listing_sql .= &#34;p.products_weight &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     break;
    case &#39;PRODUCT_LIST_PRICE&#39;&#58;
//     &#036;listing_sql .= &#34;final_price &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     &#036;listing_sql .= &#34;p.products_price_sorter &#34; . &#40;&#036;sort_order == &#39;d&#39; ? &#39;desc&#39; &#58; &#39;&#39;&#41; . &#34;, pd.products_name&#34;;
     break;
   }
  }
// optional Product List Filter
  if &#40;PRODUCT_LIST_FILTER &#62; 0&#41;
  {
   if &#40;isset&#40;&#036;_GET&#91;&#39;stores_id&#39;&#93;&#41; && &#036;_GET&#91;&#39;stores_id&#39;&#93; &#33;= &#39;&#39;&#41;
   {
    &#036;filterlist_sql = &#34;select distinct c.categories_id as id, cd.categories_name as name from &#34; . TABLE_PRODUCTS . &#34; p, &#34; . TABLE_PRODUCTS_TO_CATEGORIES . &#34; p2c, &#34; . TABLE_CATEGORIES . &#34; c, &#34; . TABLE_CATEGORIES_DESCRIPTION . &#34; cd where p.products_status = &#39;1&#39; and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = &#39;&#34; . &#40;int&#41;&#036;_SESSION&#91;&#39;languages_id&#39;&#93; . &#34;&#39; and p.stores_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;stores_id&#39;&#93; . &#34;&#39; order by cd.categories_name&#34;;
   } else {
    &#036;filterlist_sql= &#34;select distinct s.stores_id as id, s.stores_name as name from &#34; . TABLE_PRODUCTS . &#34; p, &#34; . TABLE_PRODUCTS_TO_CATEGORIES . &#34; p2c, &#34; . TABLE_STORES . &#34; s where p.products_status = &#39;1&#39; and p.stores_id = s.stores_id and p.products_id = p2c.products_id and p2c.categories_id = &#39;&#34; . &#40;int&#41;&#036;current_category_id . &#34;&#39; order by s.stores_name&#34;;
   }
   &#036;filterlist = &#036;db-&#62;Execute&#40;&#036;filterlist_sql&#41;;
   if &#40;&#036;filterlist-&#62;RecordCount&#40;&#41; &#62; 1&#41;
   {
     &#036;do_filter_list = true;
    if &#40;isset&#40;&#036;_GET&#91;&#39;stores_id&#39;&#93;&#41;&#41;
    {
     &#036;getoption_set = true;
     &#036;get_option_variable = &#39;stores_id&#39;;
     &#036;options = array&#40;array&#40;&#39;id&#39; =&#62; &#39;&#39;, &#39;text&#39; =&#62; TEXT_ALL_CATEGORIES&#41;&#41;;
    } else {
     &#036;options = array&#40;array&#40;&#39;id&#39; =&#62; &#39;&#39;, &#39;text&#39; =&#62; TEXT_ALL_STORES&#41;&#41;;
    }
    while &#40;&#33;&#036;filterlist-&#62;EOF&#41; {
     &#036;options&#91;&#93; = array&#40;&#39;id&#39; =&#62; &#036;filterlist-&#62;fields&#91;&#39;id&#39;&#93;, &#39;text&#39; =&#62; &#036;filterlist-&#62;fields&#91;&#39;name&#39;&#93;&#41;;
     &#036;filterlist-&#62;MoveNext&#40;&#41;;
    }
   }
  }

// Get the right image for the top-right
  &#036;image = DIR_WS_TEMPLATE_IMAGES . &#39;table_background_list.gif&#39;;
  if &#40;isset&#40;&#036;_GET&#91;&#39;stores_id&#39;&#93;&#41;&#41;
  {
   &#036;sql = &#34;select stores_image
        from  &#34; . TABLE_STORES . &#34;
        where   stores_id = &#39;&#34; . &#40;int&#41;&#036;_GET&#91;&#39;stores_id&#39;&#93; . &#34;&#39;&#34;;

   &#036;image_name = &#036;db-&#62;Execute&#40;&#036;sql&#41;;
   &#036;image = &#036;image_name-&#62;fields&#91;&#39;stores_image&#39;&#93;;

  } elseif &#40;&#036;current_category_id&#41; {

   &#036;sql = &#34;select categories_image from &#34; . TABLE_CATEGORIES . &#34;
       where categories_id = &#39;&#34; . &#40;int&#41;&#036;current_category_id . &#34;&#39;&#34;;

   &#036;image_name = &#036;db-&#62;Execute&#40;&#036;sql&#41;;
   &#036;image = &#036;image_name-&#62;fields&#91;&#39;categories_image&#39;&#93;;
  }
?&#62;

This is how it looks like in tpl_stores_select.php:

Code:

&#60;?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                    |
// +----------------------------------------------------------------------+
// | Copyright &#40;c&#41; 2003 The zen-cart developers              |
// |                                   |
// | http&#58;//www.zen-cart.com/index.php                  |
// |                                   |
// | Portions Copyright &#40;c&#41; 2003 osCommerce                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,    |
// | that is bundled with this package in the file LICENSE, and is    |
// | available through the world-wide-web at the following url&#58;      |
// | http&#58;//www.zen-cart.com/license/2_0.txt.               |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to    |
// | license AT zen-cart DOT com so we can mail you a copy immediately.     |
// +----------------------------------------------------------------------+
// &#036;Id&#58; tpl_stores_select.php 1266 2005-07-27 02&#58;51&#58;24Z xxxx&#036;
//
 &#036;content = &#39;&#60;center&#62;&#39;;
 &#036;content.= zen_draw_form&#40;&#39;stores&#39;, zen_href_link&#40;FILENAME_DEFAULT, &#39;&#39;, &#39;NONSSL&#39;, false&#41;, &#39;get&#39;&#41;;
 &#036;content .= zen_draw_pull_down_menu&#40;&#39;stores_id&#39;, &#036;store_sidebox_array, &#40;isset&#40;&#036;_GET&#91;&#39;stores_id&#39;&#93;&#41; ? &#036;_GET&#91;&#39;stores_id&#39;&#93; &#58; &#39;&#39;&#41;, &#39;onchange=&#34;this.form.submit&#40;&#41;;&#34; class=&#34;DropdownMeny&#34; size=&#34;&#39; . MAX_STORES_LIST . &#39;&#34;&#39;&#41; . zen_hide_session_id&#40;&#41; . zen_draw_hidden_field&#40;&#39;typefilter&#39;, &#39;stores&#39;&#41;;
 &#036;content .= zen_draw_hidden_field&#40;&#39;main_page&#39;, FILENAME_DEFAULT&#41; . &#39;&#60;/center&#62;&#60;/form&#62;&#39;;
?&#62;

I've put a value 'stores_id' in table 'get_terms_to_filter'...

I want my zencart to list all the products relative to the store that I choose from the 'STORES' sidebox... I've been working with this for days, but still not figuring out what is wrong!!

Please, any comments/help from anyone will be appreciate... Thanxx

Thread: Adding New Product_types

Thread Tools

Search Thread

Display

Threaded View

Similar Threads

Is there a way of adding a product but stopping it from adding to new products?

When adding new parts, adding part number to preview screen

product_types.php details

Bookmarks

Bookmarks

Posting Permissions