X-Cart forums

[funkydunk]

Cyberactive and I have been working on a module that shows up products added into the shop over the last week and have come up with the code below to show this on your home page.

Try this - it works fine and dandy in 3.2.2

First create a new php file customer/newest.php

<?
// set variables
$daterange = 604800; // 60 * 60 * 24 * 7 days in unix time
$nowtime = time();
$oldtime = $nowtime - $daterange ;

// the database query
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND add_date > " . $oldtime . " AND add_date < " . $nowtime . " ORDER BY xcart_products.productID DESC LIMIT 0,5 "; 


// give the product array to smarty to make it available sitewide.
$newproducts = func_query($query);
$smarty->assign("newproducts",$newproducts);
?>

This is set to select 5 products added within the last week but you can change the timespan to whatever you like by changing the daterange variable. This is unix time so is calculated in seconds.

Second, add into the customer/home.php file after the require featured.php bit

require "./newest.php";

Third, create a newest.tpl template:

{* $Id: newest.tpl,v 1.13 2002/05/20 06:55:20 lucky Exp $ *}
{capture name=dialog}
{if $newproducts ne ""}
{include file="customer/main/products.tpl" products=$newproducts}
{else}
{$lng.txt_no_new}
{/if}
{/capture}
{include file="dialog.tpl" title=$lng.lbl_new_products content=$smarty.capture.dialog extra="width=100%"}

You will note in here two extra fields to the languages part, one in labels for the heading to the section then a second one to show if there are no new prodoucts.

Fourth - amend home_main.tpl to

{if $smarty.get.mode eq "subscribed"}
{include file="main/subscribe_confirmation.tpl"}
{elseif $smarty.get.mode eq "unsubscribed"}
{include file="main/unsubscribe_confirmation.tpl"}
{elseif $main eq "search"}
{include file="customer/main/search_result.tpl"}
{elseif $main eq "advanced_search"}
{include file="customer/main/advanced_search.tpl"}
{elseif $main eq "cart"}
{include file="customer/main/cart.tpl"}
{elseif $main eq "wishlist"}
{if $active_modules.Wishlist ne ""}
{include file="modules/Wishlist/wishlist.tpl"}
{/if}
{elseif $main eq "anonymous_checkout"}
{include file="customer/main/anonymous_checkout.tpl"}
{elseif $main eq "order_message"}
{include file="customer/main/order_message.tpl"}
{elseif $main eq "checkout"}
{include file="customer/main/checkout.tpl"}
{elseif $main eq "product"}
{include file="customer/main/product.tpl" product=$product}
{elseif $main eq "giftcert"}
{include file="modules/Gift_Certificates/giftcert.tpl"}
{elseif $main eq "subscriptions"}
{include file="modules/Subscriptions/subscriptions.tpl"}
{elseif $main eq "catalog" and $current_category.category eq ""}

{include file="customer/main/welcome.tpl" f_products=$f_products newproducts=$newproducts}

{elseif $main eq "catalog"}
{include file="customer/main/subcategories.tpl" cat=$cat}
{else}
{include file="common_templates.tpl"}
{/if}

Fifth and finally - amended the welcome.tpl template to the following:

{* $Id: welcome.tpl,v 1.21 2002/09/10 12:36:34 zorg Exp $ *}
{if ($active_modules.Greet_Visitor ne "") AND ($smarty.cookies.GreetingCookie ne "")}
<h3>{$lng.lbl_welcome_back}, {$smarty.cookies.GreetingCookie} </h3> 
{else}
<h3>{$lng.lbl_welcome_to} { $config.Company.company_name }</h3>
{/if}
{$lng.txt_welcome}



{if $active_modules.Bestsellers ne "" and $config.Modules.bestsellers_menu ne "Y"}
{include file="modules/Bestsellers/bestsellers.tpl"}
{/if}



{include file="customer/main/featured.tpl" f_products=$f_products}



{include file="customer/main/newest.tpl" newproducts=$newproducts}

Not sure whether this works with 3.3.

Enjoy

[B00MER]

Nice work funky dunk, maybe I can implement this soon in some of my upcomming carts. From the looks of it though, should work great!

[funkydunk]

Cyberactive has taken it on further now - full thread is http://forum.x-cart.com/viewtopic.php?t=1402&highlight=

He has put it in place on his site and it looks really good - would make a good standard module if the x team are watching.

[cyberactive]

I runs smoothly over here.

And fast too....

I've just changed the query a bit to randomize the results.

[cyberactive]

The randomise query is

$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND add_date > " . $oldtime . " AND add_date < " . $nowtime . " ORDER BY RAND() LIMIT 5 "; 

Just change the number after LIMIT to show more or less products.

Good luck.

[herberr]

Originally Posted by funkydunk

Cyberactive and I have been working on a module that shows up products added into the shop over the last week and have come up with the code below to show this on your home page.

Not sure whether this works with 3.3.

Enjoy

Funkydunk, i copied your code (which looks good), but it doesn't run into my site.

I got the following errormessage at the top of the page :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site6/fst/var/www/html/config.php on line 288

And i got the following errormessage at the footer of the page :
Warning: Smarty error: unable to read template resource: "customer/main/newest.tpl" in /home/virtual/site6/fst/var/www/html/Smarty-2.1.1/Smarty.class.php on line 546
What did I wrong ?

[funkydunk]

Can you post your exact code into the forum and I will have a peek.

Cheers

[herbster]

Originally Posted by funkydunk

Can you post your exact code into the forum and I will have a peek.

Cheers

We are running version 3.1.3. Is that the cause of my problem ???

[funkydunk]

I would say yes... if you upgraded to 3.2.4 or 3.3.1 this would be workable. There seem to be quite a few changes from 3.1 to 3.2 onwards

[funkydunk]

Just a quick note that if you want this to show up when you are in other sections of the shop, like help.php cart.php then the thing to do is include the newest.php file in those files as per the instructions for home.php.

require "./newest.php";