Pricelist For Printing

[monkeymadness]

In addition to what quentinjs said, this information is printed by default at the bottom of each page.

so what could i be missing then as it doesnt show up when i print it or on the site...

using v1.2.7 and thats the only thing missing and its obviously quite important

heres the url if its of any use

http://www.photogiftideas.co.uk/pricelist.html

thanks

[monkeymadness]

its cool...i was missing includes/modules/tpl_header + footer



thanks again for contributing..hopefully thats my pricelist sorted ::tup

[titangen]

Hi Paul,

Thanks for your reply. I have a other request is it possible to link the price list to the rules of the shop ... I mean for me for example the customers can only see the prices if there create a account Is it possible to do this with the price list ?

best ragards


chris

::tup

[quentinjs]

Oh, thats a little daring for me :-) considering my work day is already 16 hours.... did find this though that you might be interested in... it is a php class to create pdf reports. http://sourceforge.net/projects/repgen/ a bit old, but might have merit :-)

okay back to my quest for php reporting engines....

[ginar]

I think this is a wonderful addition. I have installed it, but seem to be having a couple of minor problems and am hoping someone can point me in the right direction to fix them.

How do you edit the margins between the logo and the start of the template?

I can't seem to get the link onto the categories page under All products.

Here is a link to my Pricelist:
The pricelist
and you can see what I mean about the space between the logo, the category name and the wording Price-List:

Here is a copy of
sen/includes/templates/template_default/sideboxes/
tpl_categories.php

$content = "";
for (&#036;i=0;&#036;i<sizeof(&#036;box_categories_array);&#036;i++) {
switch(true) {
// to make a specific category stand out define a new class in the stylesheet example: A.category-holiday
// uncomment the select below and set the cPath=3 to the cPath= your_categories_id
// many variations of this can be done
// case (&#036;box_categories_array[&#036;i][&#39;path&#39;] == &#39;cPath=3&#39;):
// &#036;new_style = &#39;category-holiday&#39;;
// break;
case (&#036;box_categories_array[&#036;i][&#39;top&#39;] == &#39;true&#39;):
&#036;new_style = &#39;category-top&#39;;
break;
case (&#036;box_categories_array[&#036;i][&#39;has_sub_cat&#39;]):
&#036;new_style = &#39;category-subs&#39;;
break;
default:
&#036;new_style = &#39;category-products&#39;;
}
if (zen_get_product_types_to_category(&#036;box_categories_array[&#036;i][&#39;path&#39;]) == &#39;3&#39; or (&#036;box_categories_array[&#036;i][&#39;top&#39;] &#33;= &#39;true&#39; and SHOW_CATEGORIES_SUBCATEGORIES_ALWAYS &#33;= 1)) {
// skip it this is for the document box
} else {
&#036;content .= &#39;<a class="&#39; . &#036;new_style . &#39;" href="&#39; . zen_href_link(FILENAME_DEFAULT, &#036;box_categories_array[&#036;i][&#39;path&#39;]) . &#39;">&#39;;

if (&#036;box_categories_array[&#036;i][&#39;current&#39;]) {
if (&#036;box_categories_array[&#036;i][&#39;has_sub_cat&#39;]) {
&#036;content .= &#39;<span class="category-subs-parent">&#39; . &#036;box_categories_array[&#036;i][&#39;name&#39;] . &#39;</span>&#39;;
} else {
&#036;content .= &#39;<span class="category-subs-selected">&#39; . &#036;box_categories_array[&#036;i][&#39;name&#39;] . &#39;</span>&#39;;
}
} else {
&#036;content .= &#036;box_categories_array[&#036;i][&#39;name&#39;];
}

if (&#036;box_categories_array[&#036;i][&#39;has_sub_cat&#39;]) {
&#036;content .= CATEGORIES_SEPARATOR;
}
&#036;content .= &#39;</a>&#39;;

if (SHOW_COUNTS == &#39;true&#39;) {
if ((CATEGORIES_COUNT_ZERO == &#39;1&#39; and &#036;box_categories_array[&#036;i][&#39;count&#39;] == 0) or &#036;box_categories_array[&#036;i][&#39;count&#39;] >= 1) {
&#036;content .= CATEGORIES_COUNT_PREFIX . &#036;box_categories_array[&#036;i][&#39;count&#39;] . CATEGORIES_COUNT_SUFFIX;
}
}

&#036;content .= &#39;
&#39;;
}
}

if (SHOW_CATEGORIES_BOX_SPECIALS == &#39;true&#39; or SHOW_CATEGORIES_BOX_PRODUCTS_NEW == &#39;true&#39; or SHOW_CATEGORIES_BOX_FEATURED_PRODUCTS == &#39;true&#39; or SHOW_CATEGORIES_BOX_PRODUCTS_ALL == &#39;true&#39;) {
// display a separator between categories and links
if (SHOW_CATEGORIES_SEPARATOR_LINK == &#39;1&#39;) {
&#036;content .= &#39;
&#39; . zen_draw_separator(&#39;pixel_silver.gif&#39;) . &#39;
&#39;;
}
if (SHOW_CATEGORIES_BOX_SPECIALS == &#39;true&#39;) {
&#036;show_this = &#036;db->Execute("select s.products_id from " . TABLE_SPECIALS . " s where s.status= &#39;1&#39; limit 1");
if (&#036;show_this->RecordCount() > 0) {
&#036;content .= &#39;&#39; . CATEGORIES_BOX_HEADING_SPECIALS . &#39;&#39; . &#39;
&#39;;
}
}
if (SHOW_CATEGORIES_BOX_PRODUCTS_NEW == &#39;true&#39;) {
switch (true) {
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;0&#39;):
&#036;display_limit = &#39;&#39;;
break;
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;1&#39;):
&#036;display_limit = " and date_format(p.products_date_added, &#39;%Y%m&#39;) >= date_format(now(), &#39;%Y%m&#39;)";
break;
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;30&#39;):
&#036;display_limit = &#39; and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30&#39;;
break;
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;60&#39;):
&#036;display_limit = &#39; and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 60&#39;;
break;
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;90&#39;):
&#036;display_limit = &#39; and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 90&#39;;
break;
case (SHOW_NEW_PRODUCTS_LIMIT == &#39;120&#39;):
&#036;display_limit = &#39; and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 120&#39;;
break;
}

&#036;show_this = &#036;db->Execute("select p.products_id
from " . TABLE_PRODUCTS . " p
where p.products_status = &#39;1&#39; " . &#036;display_limit . " limit 1");
if (&#036;show_this->RecordCount() > 0) {
&#036;content .= &#39;&#39; . CATEGORIES_BOX_HEADING_WHATS_NEW . &#39;&#39; . &#39;
&#39;;
}
}
if (SHOW_CATEGORIES_BOX_FEATURED_PRODUCTS == &#39;true&#39;) {
&#036;show_this = &#036;db->Execute("select products_id from " . TABLE_FEATURED . " where status= &#39;1&#39; limit 1");
if (&#036;show_this->RecordCount() > 0) {
&#036;content .= &#39;&#39; . CATEGORIES_BOX_HEADING_FEATURED_PRODUCTS . &#39;&#39; . &#39;
&#39;;
}
}
if (SHOW_CATEGORIES_BOX_PRODUCTS_ALL == &#39;true&#39;) {
&#036;content .= &#39;&#39; . CATEGORIES_BOX_HEADING_PRODUCTS_ALL . &#39;&#39;;
}
}
//define(&#39;SHOW_CATEGORIES_BOX_PRICELIST&#39;,&#39;true&#39;);
if (SHOW_CATEGORIES_BOX_PRICELIST == &#39;true&#39;) {
&#036;content .= &#39;
&#39; . CATEGORIES_BOX_HEADING_PRICELIST . &#39;&#39;;
}


?>

[boyemillar]

Just installed this under v1.3 and its working fine

Thought id let people know...

:) ::tup :)

[ginar]

I woke up this morning with a clearer head and worked out the problems. Everything is working great...thanks.

[KADesign]

I tried to install this with 1.3 and it won&#39;t work. I did and upgrade on the db with fresh 1.3 files. Could that be the problem?

Thanks,
Kelly

[quentinjs]

It does work with 1.3. I updated the php tonight and its working.

One suggestion. The sections should sort as its done in the catalog, so if I have product with order no assigned, it should be using this as well, else the product list can get a little confusing and messy.... :-(

[KADesign]

I keep trying to install this on 1.3 but I can&#39;t get it to work. When I go where my pricelist should be, I get this and nothing else. I have uninstalled and reinstalled this about five times. ::frust

Table &#39;kellysco_forums.categories&#39; doesn&#39;t exist

Does anyone have any idea what could be happening? I have no idea why it&#39;s looking for this table.

Thanks,
Kelly