00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034
00035 class Mage_Wishlist_Model_Mysql4_Item_Collection extends Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection
00036 {
00037
00038 public function _construct()
00039 {
00040 $this->_init('wishlist/item', 'catalog/product');
00041 }
00042
00043 public function useProductItem()
00044 {
00045 $this->setObject(Mage::getModel('catalog/product'));
00046 return $this;
00047 }
00048
00049 public function addWishlistFilter(Mage_Wishlist_Model_Wishlist $wishlist)
00050 {
00051 $this->_joinFields['e_id'] = array('table'=>'e','field'=>'entity_id');
00052 $this->joinTable('wishlist/item',
00053 'product_id=e_id',
00054 array(
00055 'wishlist_item_id' => 'wishlist_item_id',
00056 'product_id' => 'product_id',
00057 'store_id' => 'store_id',
00058 'wishlist_id' => 'wishlist_id',
00059 'added_at' => 'added_at',
00060 'description' => 'description'
00061 ),
00062 array('wishlist_id'=>$wishlist->getId())
00063 );
00064
00065 return $this;
00066 }
00067
00068 public function addStoreData()
00069 {
00070 if(!isset($this->_joinFields['e_id'])) {
00071 return $this;
00072 }
00073
00074 $dayTable = $this->_getAttributeTableAlias('days_in_wishlist');
00075 $this->joinField('store_name', 'core/store', 'name', 'store_id=store_id')
00076 ->joinField('days_in_wishlist',
00077 'wishlist/item',
00078 "(TO_DAYS('" . Mage::getSingleton('core/date')->date() . "') - TO_DAYS(DATE_ADD(".$dayTable.".added_at, INTERVAL " .(int) Mage::getSingleton('core/date')->getGmtOffset() . " SECOND)))",
00079 'wishlist_item_id=wishlist_item_id');
00080
00081 return $this;
00082 }
00083
00084 protected function _getAttributeFieldName($attributeCode)
00085 {
00086 if($attributeCode == 'days_in_wishlist') {
00087 return $this->_joinFields[$attributeCode]['field'];
00088 }
00089 return parent::_getAttributeFieldName($attributeCode);
00090 }
00091
00092 public function load($p=false, $l=false)
00093 {
00094 return parent::load($p, $l);
00095 }
00096
00097 }