Magento Daily New product show

http://blog.csdn.net/benben0503/article/details/8647020

1. Create newarrivals.php file:

[PHP]View Plaincopy

2. <?php
4. /**
6. * This was the part of ' bmproducts ' module for Magento,
8. * which allows easy access to product collection
10. * With flexible filters
12. */
16. Class Bestmagento_bmproducts_block_product_newarrivals extends Mage_catalog_block_product_list
18. {
20. function Get_prod_count ()
22. {
24. //unset any saved limits
26. Mage::getsingleton (' catalog/session ')->unslimitpage ();
28. return (isset ($_request[' limit '))?  intval ($_request[' limit '): 48;
30. }
34. function get_cur_page ()
36. {
38. return (isset ($_request[' P '))?  intval ($_request[' P ']): 1;
40. }
44. /** 
46. * Retrieve loaded Category Collection
48. *
50. * @return Mage_eav_model_entity_collection_abstract
52. **/
54. protected function _getproductcollection ()
56. {
58. $date = $_get[' Date '];
62. $collection = Mage::getresourcemodel (' catalog/product_collection ');
64. $collection->setvisibility (Mage::getsingleton (' catalog/product_visibility ')  Getvisibleincatalogids ());
68. $collection = $this->_addproductattributesandprices ($collection)
70. ->addattributetoselect (' created_at ')
72. ->setorder (' created_at ', ' desc ')
74. ->setpagesize ($this->get_prod_count ())
76. ->setcurpage ($this->get_cur_page ());
80. if (! Empty ($date))
82. {
84. $this->_data[' title ' = $date;
86. $collection->getselect ()->where (' DATE (created_at) =? ',$date);
88. }
92. $this->setproductcollection ($collection);
96. return $collection;
98. }
100. }

2, the background CMS list to add Page page, set design content is:

[HTML]View Plaincopy

2. <reference name="Content">
4. <block type="bmproducts/product_newarrivals" name="product_new" template=" Catalog/product/list.phtml ">
6. <block type= "catalog/product_list_toolbar" name="Product_list_toolbar " template="catalog/product/list/toolbar.phtml">
8. <block type="Page/html_pager" name="Product_list_toolbar_pager" />
10. <action method="Setdefaultgridperpage"><limit>48</ limit></action>
12. <action method="Addpagerlimit"><mode>grid</mode> <limit>48</limit></action>
14. </block>
16. <action method="Settoolbarblockname"><name>product_list_toolbar </name></action>
18. </block>
20. </Reference>

Without paging, you can set only the content items to:

[HTML]View Plaincopy

1. {{block type="bmproducts/product_newarrivals" name= "newarrivals" title= "New Arrivals" template="Catalog/product/list.phtml"}}

3. Add the following code where you want to display the directory:

[PHP]View Plaincopy

2. <div class="Support_left" >
4. <div class="subitem" >
6. <div class="title" >new arrivals</div>
8. <?php
10. $collection = Mage::getmodel (' catalog/product ')->getresourcecollection ()
12. ->setorder (' created_at ', ' desc ');
14. $collection->getselect ()->group (' CAST (created_at as Date) ';
16. //$collection->getselect ()->group (' CAST (created_at as Date) '->limit (5);
18. //echo $collection->getselect (); exit;
20. $date = Array ();
22. foreach ($collection as $val)
24. {
26. ?>
28. <div class="Left_link" ><a href="/new_arrivals?date=<?php echo Date (" Y-m-d", Strtotime ($ val[' Created_at '));?> "rel=" nofollow "><?php echo date (" y-m-d ",strtotime ($val [ ' Created_at ')); ?></a></div>
30. <?php
32. }
34. ?>
36. </div>
38. </div>

Magento Daily New product show